 Thank you so much and thank you everyone for joining today. I am going to just turn off my camera. I hate to see myself talk and I will share my screen with you just one moment. You should be seeing that now. So reference solutions, if you've used our database in the past, you may remember that we were under a different name at that time, reference USA. It's the same great database. We've just rebranded. In fact, we did so probably September, October timeframe of last year and we made just a few changes on this home page. We pulled our webinars out and made them front and center. They used to be under our learning center. So we've made that more available or accessible to patrons. You probably perhaps noticed we do offer an app. So if you would like to be able to use that, you could download that on your phone or your tablet and have access to two modules. That would be the US business and the US consumer lifestyles. And then of course, we do give you the ability, you know, with the feedback from our library partners of which we depend on their insights because they're hearing it firsthand from from their library patrons. We were told that not in every case did people necessarily need to be able to download information, but some might rather be able to simply save that. So that's when we created this personal account. It's not a shortcut by any chance to get to the database. You still have to log in through the library's website. But once you're here and after you've registered, you can log in and you can save any of the searches that you would like to do with the majority of these modules. The only one that you can't save information is the US jobs and internships. With this one, you're able to email yourself results, but you're just not able to save them in that personal account. And I would also point out, I'll get back here to the top. Under the Learning Center, there might be some use for and I'll show you where that's at. Of course, we have our contact information all over the place in here. You'll notice that, but we do have some training materials that you might want to utilize. So if you want to open this up on this far right hand side, we have these database overviews. We have one for all the business related databases. So the US business, the US new business, the health care, one for all the consumers, one for all the modules, and then a breakdown of each of those modules. So know that you could use any of that information. We also have this data dictionary for business and for the consumer modules. So if you had a question about a specific data element, you could get to that as well. Know that that's something that you could have up on another tab, or if you would rather print it off and have it available for whenever you were going to do a search or use the database, you could certainly do that as well. It's up to you. Know that that's available. Of course, you could always contact the library and they can help you through your search or you can reach out to us as well. I'll go back to my dashboard, my homepage here. You'll always know that you're in the database when you see the San Francisco Public Libraries logo there. And there is on these nine various modules, there's an update schedule and slightly different across these. So with the US business database, this is the one that we came into business with, right? We started in 1972, pretty much as a list marketing company, you know, businesses would call us and they'd say, hey, I need a list of all print manufacturers in the United States and we would sell them that list and they would go about contacting those businesses. In roughly 1992, if you remember Vice President Al Gore invented the internet and we moved from a floppy disk into the universe of the internet and made this access available through public libraries at that point in time. So the US business database is still the one that gets the lion's share of attention. We call verify businesses and as you note here, there are some 62 million, about 60 million of those are verified records that we have called annually to make certain they're still open that we can still keep them verified and make that information available to you and we're pushing out those updates in regards to the US business database every Thursday into Friday morning. So 52 times a year this is being updated. The US historical information technically it's being updated at the beginning of every new calendar year. The Canadian business information, this is being updated monthly, the jobs and internships. This is a relationship that we have with indeed.com and this information is being updated daily. Sometimes it multiple times a day just depends on what's going on with the job listings. And if you're not real familiar with indeed, they are their own posting site but then they also aggregate information from other sites like monster or career link, county posting sites, those types of locations. So we're updating this daily and really the difference between going directly through indeed and coming through us is you not only learn about those jobs and those internships, but you also learn about the company that's doing the hiring. Our US new business filings through the Secretary of State's office. We also get that from utility hookups, phone hookups, that kind of information. We're updating this information every week. We'll keep it in here as a new business record very raw in its form. We'll keep that in there for a year because we do know that there are entities that want to be able to look at over the course of a year how many business filings have been done in a particular area. So we'll certainly keep that in there for a year but we're generally able to turn these new business filings into a full business record within 30 to 60 days. So this is being updated weekly. Our US healthcare, this is being updated monthly as is the consumer lifestyles and the Canadian white pages. Those are all monthly updates. Last but not least, the new movers, new homeowners. Great information especially if you're a business and you rely on consumers perhaps coming into your physical location or perhaps a phone call into your physical location to transact some business. You can find those new movers, new homeowners in your area and that's being updated weekly. We're getting this through our license with the USPS national change of address and making that available weekly. So I'll certainly give you a good overview of how to use the database and how to use these various modules within the tools that I'll disclose today are available in most of these modules. Certainly not every one of them will have each of these tools but most do if it's not there, it's not missing, it's not broken, it's just not available. So I'll open the US business database first and whenever I open any module I'm always going to come to this quick search tab first and in this case maybe I want to look up just one company and get some information about that company. I could certainly do that. Maybe there was an executive that I had worked with at another company and I've learned recently that they've moved but I'm not certain where they may have gone to. I could try that first name, last name, hopefully you can narrow it to the city and state that they're in and then be able to get access to that information. I could even do a reverse phone number lookup if I wanted to. So know that you can produce that kind of information and whenever you're going to view those results it's always going to be about that particular those verified records will never show you unverified records whenever you're doing a quick search it's only going to be those that are verified. So if you didn't find that company and you thought hmm that's odd you could always go to the advanced search and look for that company by name in that city and state and include the unverified records. Those are those are records that had been verified at one point in time and then when I went to do our annual phone call with them we didn't reach them. We don't stop after one attempt. We'll continue trying to reach them a total of two dozen or a dozen times throughout the course of two years and if we can't find any information that they've closed we can't get them verified. We'll move them from that verified status into the unverified and then of course we also have closed businesses. But whenever I'm doing a quick search it's always going to be about those businesses that are in fact verified businesses and let's do this. Let's do I'm going to do a a search here for you and we're just going to do your community. So I'll grab San Francisco there it is California there you are and now I'm going to look at those verified records. This will give me a total of all those businesses across your community of which there are 72,000 plus and it's one thing to know how many there are. I'm able to use this charts tool to then give it a breakdown by business type. So I'll select that and notice it first gives me it by the SIC code. If you're not familiar with that that's the standard industrial classification code. Every retail every for profit every for non-profit would have an SIC code. In fact technically Uncle Sam has retired these but we have been using those codes so long we've actually added additional digits to what was a four digit code at greatest length and we've made in some cases a nine digit code to allow you to get very granular. So this is my top seven across your community and in first position as it is in most communities physicians and surgeons coming at that top spot because they're all 1099 guys and gals right they are their own individual businesses followed by in this case restaurants then attorneys dentists real estate nurse practitioners and just like in my city of Omaha Nebraska you have automated tellers in this seventh position and I like to point that out because we do have those kinds of records in our system and if you wanted to exclude them maybe you didn't want to waste time looking at automated teller records when you're not going to call one right you're not going to ask it for its business right so you could certainly omit those and I'll show you how you could omit any type of business not just automated tellers we will also have kiosks in our records so for example like red we'll have those in the records as well but I can omit anything in this case it's giving me those top seven I can scroll down and get a full report notice this is 140 pages in length it gives you the primary s i cco that they're under that description and how many records apply and if I wanted to maybe I wanted to get into this group of beauty salons because I have some product that I want to be able to sell them I could hyperlink right into this group by selecting that number and it will open up that universe of 7797 for me excuse me and I can get to that information so know that's always available to you if you would like it I'm going to revise my search and I'm going to go to advanced search it's one thing to look at an entire community or maybe a single company or look for an executive advanced search allows me to do so many more using so many more features and by the way there are additional filters it goes to the same place it goes to advanced search so all these filters that are on the left hand side are available to you and I do like to point out the difference that we saw with quick search with one company that I could look at this would allow me to look up companies by name and I can do more than one so if I wanted IBM for example I could add that to my list if maybe I want Delta I could add that to my list I get to add as many businesses by name as I want and then it's just a matter of selecting my geography otherwise we will always give you the company name we'll always give you this executive information where we can get that in our verification phone calls we always ask who's the owner or manager of that business or if it's of a larger company you know who's that CEO or that chief financial officer we try and capture that information and make that available so that you can use that criteria to drive in your records maybe you need to only look at businesses that have an owner present if that were the case certainly select that and then just drive in those records or maybe you would accept a manager if an owner you could certainly drive in that management information as well you may get both but for sure one or the other right so that is always available to you type of business you know for us it's always been about being able to deliver to the end user that kind of information that's most important to them and again type is is one of those key filters that often gets used as it notes here you could put in restaurants and just see restaurants in an area or hospitals or dry cleaners or certain kinds of manufacturers you get to be the driver and you can do that with this keyword let me also point out we have this major industry group which is just the sic codes you may also be aware of or have heard of NAICS codes so when Uncle Sam retired the sic codes the NAICS codes took its place they came up with this coding system when the North American trade agreement was reached between us Mexico and Canada and they needed a system that all countries would use in order to identify those those products coming in or going out right so that's that was that's what's replaced the sic codes we have both I would always encourage people to use the sic codes simply because they're more granular geography kind of speaks for itself I will show you this map based search tool let's look at this major industry group though this is always going to be only sic codes and you can look at it from the standpoint of those businesses that their primary line of business is x think about Walmart their primary line of business is a grocery grocery store chain right but they have so many other lines of business under their umbrella the certainly the the garden center which by the way I've been to a lot this spring uh the pharmacy the automotive electronics clothing you name it they have all of those other lines of business if I wanted to look at those businesses that their primary line of business is something specific I could certainly drive that in let me give you an example under construction of course there are these these three codes 1516 and 17 if you want to know what that definition is click the plus symbol and it will give you the definition for each of those codes so if if general contractors were important to you you could click on that plus symbol and it takes you to this level of a four digit code and that was the extent that Uncle Sam was using this coding system we decided to add to that and notice how much more granular it's become in fact I helped my niece who lives in Dallas she had some water damage that occurred when when texas went in the deep freeze and she wanted to be able to reach out to a contractor that this is their primary line of business so you simply select that and then scroll down and select show me those that that's their primary line of business and as you can imagine any general contractor could say oh I do this kind of work I'll come in and I'll I'll cut up your sheet rock to about three feet and and I'll dry everything out real good for you make sure there's there's no problems there she really wanted somebody that this was their specialty so that's why we got to that level so no you can stair step your way into information if you'd like to then for her it was just a matter of putting in Dallas texas phone information speaks for itself number of employees we do know that a lot of people want to use something to define a business by size so certainly number of employees is one as well as sales volume this is that one of those questions that we're asking how many employees do you have about 72 of the businesses will give us an exact number those that don't we look at their peers in the area so based on the type of business they're in will apply a range if we can't get a response to that question will apply a range so know when you see that in the record if it's an actual number bingo we got that in our call if there's a range there they did not respond to that question and we learned a long time ago you don't ask a privately owned business how much money they're making and not have that phone call perhaps and suddenly so we have a team that puts together an algorithm that produces that modeled number for that sales volume if it's a publicly traded company then that sales volume is going to come from their 10k report but if it's private that will always be modeled information and the same thing is true with the business expenditure some people want to be able to look at business expenditures can certainly do that but know that that's also modeled ownership we give you lots of different ways to look at businesses I had an email because we I showed you where our contact information is took an took an email request from a customer who wanted to identify jewelry stores across the country that had at least 10 or more locations somewhere in the country right well as it relates to actual numbers of locations affixed to a business I have that but I don't have the ability to break that down by 10 or more so what I instructed that person to do I did some homework of course and I identified that type of business and I simply was able to drive in this I c code I I did some research and I found this s I c code in our records for jeweler's retail there it is you can click on that add that to the selected field and then I simply went down he didn't I didn't need to change anything under geography because he wanted to look at the entire united states that's easy so I selected jeweler's retail and then I went I came down here and I said let's look at the headquarters branch he didn't care if they were publicly traded or private so at this point in time I said let's grab all of them with subsidiaries right so that means they're going to have a number of those particular businesses under their umbrella and as you'll note here there are 36 across the united state so that's only two pages of records real easy for that person to be able to go through and simply count up and I would go under the corporate tree structure here and count up how many of those businesses had at least 10 or more locations wouldn't take him very long at all to be able to do that so know that that is certainly something that can be done with the database so you can use a lot of these different filters to get to the kind of information or get close to the kind of information that you need I am going to do this type of search for you let's well let me do point out we do have home-based businesses so if you wanted to see them or exclude them in an area you could certainly do so maybe maybe you want to look at businesses that have been been open for a certain number of years maybe you want to see those newer businesses you can tell the system hey show me the last three years of businesses that have opened in whatever geography you want perhaps you'd rather identify businesses that have been around for a while if the high water mark for you were 12 years or older you could certainly do it that way as well you get to be the driver know that there's lots of different ways you can filter in or filter out pieces of information and as it relates to professionals all or one we added this much like we did with the the ability to create a personal account we added this because we were told by our library partners that in some cases patrons didn't necessarily want to include every doctor or every attorney in a listing of businesses that they were going to look at in an area maybe they were planning on doing a mailer but they didn't want to reach out to every attorney just a primary attorney at that office you could choose to go from all to one it would reduce the number of records that you would ultimately receive and if they were going to do a mailer it would reduce the cost certainly associated with that mailer so know that you can certainly include that if you would like as a filter and then we have a lot of different ways that you can omit information the if I did not want ATM machines to show up in my in my records in my output maybe I'm doing a search in a generic area and I don't want those ATMs to show up I could search for that the system will identify the SIC code that goes with automated telephone machines and I simply click on it add it to my selected field and as long as I leave that active I'll never have an ATM machine show up again maybe I don't want bars either for example I could I could certainly search for that and and exclude bars as well just depends on what I want to be able to do so know you can exclude a lot of different information including previously saved searches as it notes here so maybe I wanted to look at across all of San Francisco County but I wanted to exclude one city I could do that just depends on how I'd like to do that I'm going to do a simple search we're going to do a keyword and we'll just look for restaurants I need some some numbers here so I'm going to search for all restaurants notice that's what I'm set on here here's my all-inclusive for all restaurants so that would be those fine dining establishments as well as those small mom and pop sorts of restaurants just depends on what I need if you'll note I mentioned how much granular we take this notice if you wanted to get to just bank houses or just French restaurants German restaurants you can certainly do that we added another digit to that and once we got down to number nine we turned it into an alpha so went from six to that seven we even if you wanted to get to certain chains made that a nine-digit number so know that you can get that granular should you need to be able to do so then it's just a matter of driving in my geography where in the world do I want to go uh let's do this let's let's select from from the we'll do the the entire county so also at San Francisco and there's my California then it's just a matter of I can either scroll down if I wanted to or I can start to key that in in this case I'll just select that and so now I'm telling the system show me all restaurants across the county I have a total of three thousand six hundred and fifty nine now notice if I change this up from searching all to only primary notice it drops it down to thirty one seventy seven so it's gotten rid of those businesses like I mentioned Walmart uh think about businesses that have perhaps a restaurant in them but that's not their primary line of business how about bowling you know there's his entertainment or bowling whatever that would fall under right so it gets rid of those think about the convenience store that has a a corner of their building or corner of their store with a few tables and they referred that as their restaurant all of those who are being excluded since I'm asking the system to look at those by primary line of business I can get into that list and let's chart this real quick so notice since I'm just looking at the one s ic code it's not going to give me a breakdown by that it's going to give me the city the zip codes so I could switch this up if I wanted to get all of the zip codes across the area with those that have those numbers in each and I get a full report of all those zip codes across your county I can change this up to employment size maybe I want to look at this from an employment size I hope the lady do a prepare some information like this for Orange County Florida and she would be able to show this listing to her employer so that her employer knew what she was in essence going after as it related to she wanted to look at it from an employment size standpoint as well as a sales volume standpoint so all of this can be made printed off for me be made part of a PowerPoint presentation just depends on what you need so you can certainly look at it that way you're also able to put this information on a heat map it's a density map I have a feeling it's going to look quite dense across the county let's see because of those all those locations right so it's applying those 3100 records across the county and I had where it's red there are lots of restaurants in those areas where it flushes more yellow fewer green even less and of course if there's no color there are no restaurants in those areas I can even change as it notes here on this left hand column I can even change the zoom to on my map and when I get to the point where it's 300 or fewer records this is what it will do I'll just drill in and I'm gonna kind of pull this up so I can get rid of some of those restaurants so then it will pinpoint where those restaurants are at based on the view of the map and it gives you this legend on the side so if I wanted to know where this blue plate was at I could get get right to it and notice it does state that there's two locations closely close to one another and there's the other one so it just depends on what you need to be able to do all of this can be printed off or may part of a PowerPoint presentation right now I'm just looking at this from a location standpoint it could certainly be sales or or number of employees I can always go back I have the ability to download this information if you scroll down to the bottom here it says how many downloads you can do at a time so this would be 10 pages because it's uh 25 records per page so with that said I can come right up here and I can put a check mark in this box next to company name grab all 25 records and then it's just a matter of going to the 10th page right and at that point I'm able to then do my my download there's my sixth page seventh eighth and then always tell you how many records because you're you're gonna want to stop this yourself right if I keep going I'm gonna get an air message because I've gone too far I'm not allowed more than 250 at a time so if that's the case and you want these records then it's just a matter of selecting your download notice you could print I do get this question if I want to save the records can I just save the ones that I put the check mark next to that's not the way that save search is set up the same search is going to save all of these records uh and you can like I mentioned come back to those at any point in time so here's my download if you intend on making mailing labels because you want to send something out to these businesses know that comma delimited is definitely what you want to use this is mailing label friendly still drops it into a form of excel I do have the summary option here that it automatically defaults to if the name of that business their address phone it would include information like that owner or manager's name and title the number of employees sales volumes line of business that they're in all of that information would be captured in this download and presented to you just as it is here on this excel document the only thing I would add to this is my pages this page that just came up is static I can't add anything to it if you would like and didn't want to save multiple groups multiple pages of 250 at a time if you would like you could open up your own version of excel because your pages are going to be static and you could keep adding more and more records to it if that's the case I would just come up here with your mouse into this corner between cell one and a and simply click in there it'll highlight this entire record all of this stuff is ready to go then it's just a matter of copying this and dropping it on your version of excel that way you could save one record for maybe 500 or 600 results that you want to be able to download it's up to you right so if that's the case you could drop it on your own version of excel minimize yours come back here close mine it'll always leave you on this instructional page then you simply select the word back it leaves you on the page that you were last on which is page 10 with those checkmarks now you need to clear out those checkmarks otherwise you'll produce the same records easiest way to do that is revise search it doesn't forget how you built your search there's all those records then I can view my results again it's left me on page one all those checkmarks are gone I need to start on page 11 hit enter and there I'm ready to go with the next group of 10 pages so you can do as many of those as you need to in groups of 250 at a time and the same thing would be true when printing same process let me take this out and let me see I'm going to cheat a little here and I'm just going to go back a couple of pages I wanted to see if it's not going to be on that page and I can't remember if you all have oh we'll use this one so I have the Asian box here I have an up arrow and and this is my entire corporate tree so if I wanted to see who the subsidiary is and if there weren't a subsidiary the ultimate parent I could choose this up arrow and it's going to show me one record this will show me their entire organizational flow so also at that notice it's part of fk restrooms and hospitality out of Palo Alto I've got one subsidiary in eight branches and there they are if this were a larger group if we were looking at for example Arby's that's one of the restaurants I like to use they have 42 subsidiaries under their umbrella and some almost 40 000 branches so you can get to any of that data that you would like by selecting that option and by the way I'll just go back to that record let's open this record up I can also get to that same corporate tree information from inside the record so know that you have access to that insight either way and in fact this is a typical record right for for any of our businesses I've got that location information here there in this case their website and a couple of the social links that they use those job listings and as you can see I've got 19 days ago 12 days ago 30 plus five months ago so it just depends on what it is that you're interested in I have that industry profile there now I won't necessarily have a business profile on every single business I'll have that either on the subsidiary or the corporate parent I have google maps embedded in here so there's their location and as you can see I can change that up to satellite view I can use the street view toggle just depends on what I need and this is a great example so when we contacted them they did not tell us how many employees they had we last reached them in November of 20 so that's one we'll call them back again in 21 unless let's imagine for a moment let's imagine that you know this general manager Wendy and the two of you were having a conversation one day she mentioned that that they had actually 15 employees at this location you can tell us about anything that needs to be updated about a record right here by using this data feedback button and what that'll do is it tells you that it's going to go to this group of researchers and that based on the item or items that you put a check mark next to we'll go ahead and research and get that updated so if 15 were that number of employees you can put a check mark there wipe out that five to nine put in that number 15 fill out this information submit it to us and we'll go about calling that business to get that insight verified at which point in time so you'll get two emails from us you'll get an immediate response thanking you thanking you for that information and then within seven to 10 business days you'll get another response confirming the update of that business information and when we call let's say that we call and and they say no we have 17 employees of course we'll put in 17 and skip this 15 that you put in there just depends on what we learn in that phone call so any record of ours can be updated that easily I can always get back to my original list let's do this I'm gonna revise this slightly and instead of looking at the entire county I'm gonna show you another option and we'll go with the map based search tool but I'm gonna just for the heck of it I'm gonna add in a couple of employment ranges and I'll even throw in those businesses with web addresses so I'll grab these two and I'm gonna say those companies with the web address and instead of using the county I'm gonna remove that and let's just do the map based search and we'll start off let's open that up and whenever using this tool you'll always want to drive in your filters first and then open this Laurie what would be a zip code either there at the library or anywhere in in san francisco oh at the library our zip code is 94102 94102 now wait a second wasn't there a tv show called 904 no that was uh I'm gonna say go and it brings me right to that area in the zip centroid and I have this map that I can use with this I have all these tools that I can employ so I could draw my own shape if I wanted to I could do a true radius I have some predetermined boundaries like zip codes etc I could even create a drive route so when using for example this uh map tool I could I put in the zip code but I could be putting in a physical address maybe I wanted to put in my business's physical address and then do a true radius around that address to find more to find these businesses that I'm interested in seeing I could certainly do that I just wanted to use the zip code because it's kind of quick right and it gives me this view that I want to employ and drawing a shape so let's say that let's say that I want to start off here kind of at this twin peaks area and I'm going to cut the mission district kind of in half so to start my search it's a single click then to change direction it's a single click and then where do I want to go from there do I want to further out this way where do I want to go let's say I want to come right up here and I want to go out here and that's that's the shape that I want to draw I can double click to finish it and then the system has identified that there are 244 businesses that match my criteria that are in that shape and as I'm looking at this I'm going you know what I don't I don't like the way I drew that shape I really meant to to do something a little different I could either delete this and start all over or maybe I want to maybe I just want to cut out this area I can trace that line bring it right back there double click to finish it there are 23 results of this 240 that are in this area if I want to double click there and exclude that I could do so and those 23 results will be deleted from that 240 and as you can see I've got that 217 ready to go so all you have to do is say done and then view your results and you'd get those in this case restaurants so I want to show you a couple of these other tools though I'm going to delete these guys I'm going to go for a radius again with a radius how far out do I want to go so if this were truly my starting point maybe this was the address I put in I can start from there and pull that out so it's a click hold it and drag it away and I can go in any direction right I get to be the driver here I don't want to cause anybody a vision problem by doing that too much but as you can see I'm already out to just about two miles there if that's what I wanted I can say good I'm done there's my 320 second I can say done and I'll get those 320 results and I can do that same draw shape in there I could even do this true radius maybe maybe I don't want this area for whatever reason I can double click in there exclude those say okay and then however many are in this shape will get excluded from my 320 so again it just depends on what I need to be able to do here are my boundary selects it always starts with the state boundary itself could be area codes metro areas counties zip city just depends let's overlay the zips so there are the zip codes in my area and if I wanted to expand that by the way I just I just use that navigation and and select that minus sign and it and it expands my my view so then it's just a matter of clicking in whichever of these zip codes I'm interested in seeing so I've got 15 results in there 44 results in there you get the idea you get to drive you get to select whatever makes the most sense to you and again if that's what you want you say done and bingo that's it perhaps how far I'm going to delete these guys how far away and I'm going to return to my tools how far away is where in the world let's go I'm going to do my drive route and I'm going to say my buffer distance I'm going to say to the system notice that the maximum I can go is 15 I'm going to say .3 that would be three blocks on either side of the roadway that my route will take me so I'm going to create that buffered route bingo it looks like an earthworm and there are 80 businesses that match my criteria from Stockton all the way down to San Jose so you get the idea how you could use that drive route and then if that's all you need bingo I say done there's my 80 results based on that criteria that I asked the system to use and I have that available to me let's look at Chipotle I wonder so they have quite a few branches but no other no subs at all it just goes directly to their parent company so you can get to any of that kind of data questions I don't see any question in the chat if anyone has question please type it in in the chat well while you're considering your question I do want to point out notice that it says that three of these 80 have email addresses and more information what it will do is it'll direct you to contact us we sell that information we don't put those email addresses out there you can imagine that if all the people that have access to the database through all the libraries across the United States had access to those email addresses as well how quickly those would sour so that is something that we do sell in fact this 80 isn't really and the number of three isn't really exact we probably have 65 coverage of that 80 that's a good rule of thumb in terms of our coverage Bill we we have a question the question is is it possible to look up residential real estate holdings by investment consortia consortia for example if I want to know who has bought up the houses in a neighborhood and turn them into expensive rentals would this database give me the information it would not what we care about is who resides at that address our our database is always going to be first and foremost focused on marketing so it's being able to get businesses in front of either businesses or people at a particular address but great great question I'm not quite certain where you would get that kind of insight unless it were perhaps through a local government entity I'm not aware of any database that would provide that kind of of insight not to say that there isn't something out there I'm just never heard of that great question though and another question from Chris is wondering when performing a surge choosing special selects and then professional all the one if you choose the one option in an office of many doctors or lawyers for example how does the surge decide on a single person so the search decides on that single entity that person based on the information we have about Jones and Sons right so we're going to provide you that insight based on what we learned in our verification phone call great question so even though Mr. Jones you know this could be possible even though Mr. Jones started the company it may have already gone over to the to the Sons but it could be in between those verification phone calls that that happened and we may not be aware of that so know that in some cases you might end up speaking with someone else at that entity but we that's what we attempt to get in our verification phone call so that would be doctors offices could be under Smith and Smith and Samson right so we're going to give you that one name based on that primary as we know it through that phone call excellent question Chris other questions I don't see other question in the checkbox now okay let's speaking of consumers let's do this I'm going to well I do want to show you real quickly obviously you've seen the records as it relates to the business database let's take a peek at the records and the amount of information that's that's available in the new business filings not nearly as robust as what you see here because these are simply filings right so I can open up the database again I can go directly to advanced search and I could ask the system you know show me those businesses that were filed and as as you'll note here it always defaults to the last six months it could be as recent as last week or within the last year let's look in the last three months and let's let's do this uh I'm going to pull up let's do that zip code again Laurie what was that it was nine nine four one oh two one oh two we'll do that give me another zip code that might be right down there in downtown oh um let me think oh nine four one oh three during set I was going to guess oh three and I think oh four is somewhere down there as well uh I'll do that as well we'll do those three so we'll say show me businesses that have filed in these three zip codes in the last three months I have 266 filings now if I wanted to filter these filings a little bit more I could do it based on location type or and or I'll open up both of these so I could do it by location type home-based or corporate location maybe doing business ads so let's do that how many of these apply now 71 bingo I've got those 71 and there they are so in these filings we didn't even get an address notice that's missing from that file let's look at this LW supply company so I've got that location information and it notes that it's a new location doing business ads and that they have three employees they did not choose to fill in this information so again we'll try and capture that when we reach out to this business and we may find in our phone call that they don't plan on opening anytime too soon we're not going to create a record until we're able to verify them as open so that information is available and I can frame this you know I could I could maybe I want to know about these these 71 records and the type of businesses they are I could chart this again and it'll give me that SIC code breakdown again in the last three months and there they are general merch merchandise restaurants real estate tree services etc notice I have the ability to change that a little bit a little bit in terms of do I want to go two months or within the last month again all of that is available I could always put this information on my heat map as well and get a sense of where that is and since there are fewer than 300 records it's going to give me that pinpoint information so that is always available to you in most of our modules the only one that's slightly different uh or the only two would be the jobs and internships and the US healthcare otherwise this heat map is available in all of the modules as is the charts so you can utilize if if if knowing about new businesses or new filings for businesses is important to you you can always utilize this information and by the way I not only have it for new businesses but of course new homeowners and and those people that have moved to the community so if that kind of insights important you could always open that module up again it's going to come to that quick search page but no you can get into advanced search and use additional filters to include or exclude uh the folks that you're going to get in terms of their records so a lot of people like to use this feature the move distance and time frame maybe I don't want to know about people who've moved across town or who've come from Oakland but I'd like to extend that range so you can tell the system you know what I don't want to see anybody that's moved from within 100 miles of my community so I truly want those newer people to my community who wouldn't know about my business and I can say let's say 2600 miles and again you've got this time frame it defaults to that six months as recent as last week or within the last year let's let's look in the last six months and we'll just do the city again you can see I've been in the city before because it populates there I'll say go and I have a total in the last six months of nearly 3000 people imagine if I went out to the full one year what would I have 6200 how about within the last week 129 let's see of this group of 100 let's imagine that I sell renters insurance or maybe I sell real estate wouldn't I love to know how many of these 129 are in fact renters so there's an audience of 79 over the last week that had moved into San Francisco and I could be I could be using those zip codes again if I wanted to it just depends on you know I could be doing a radius from a particular address maybe my work address just depends on how I want to frame it but I could get to that group of renters and notice no matter what module you're in when it comes to any of our consumer data you'll always receive this cautionary message that would indicate that any kind of telephone numbers displayed and by the way I rarely see telephone numbers displayed because we're getting this through the national change of address form that people are filling out and rarely do people put a phone number on there in some cases you might see one but rarely but it does go on to state that any of the telephone numbers displayed maybe on the do not call list and should not be used for phone solicitation ultimately you're responsible for the compliance with all federal state and and local laws with that said we do clean lists whether it's your list or our information let's say that you wanted new movers that are renters in a particular area that have moved there within the last several months we can give you a clean list that you could in fact call if there were many phone numbers that's the that's the key right uh I can get this information I can open up this information and I'm going to get this address information this person moved from quite the ways away 2566 miles away to come into your community then I've got some neighborhood information through the census along with ages and this is the only database module that will allow you to use an estimated age like that so no I can get to that kind of information I can download this I can send a mailer out I have a cousin who lives in uh Gainesville Florida and what he'll do is he'll do a radius around his business and let's imagine for a moment that his business was near this address we'll we'll pretend this you can open this up and you can say show new movers within and and you can say one block to 150 miles out so he uses this and he'll do this five and let's see how many other new movers are within a five mile radius of this address here he's got a carpet and tile cleaning service and he wants to reach out to these new movers to let them know about his service and try and earn or win some business right so then when you go into that view wow I've got a lot of something seems is daily city uh nearby yes okay that's why south of San Francisco okay okay so yeah a lot of folks and this is going to be over a different period of time this is going to show the entire year it might even be beyond that I'm going to have to double check on that that just seems like too large of a number daily city would begin to sink in the ground if this were if people were coming in at this rate in a year's time yeah that's too much I'm going to have to find out if there's not a an ubu here that just seems far too large I'm going to go back and I can always get back to my original record here's that original record I was on and get back to my list so know you can access information like that as well and use any of these filters that someone might might want to use there's that estimated age estimated income you can use that kind of insight in order to produce those results and and I don't remember if that was Chris's question or whom had asked the question about the people buying up homes in a particular area notice this is always based on individuals that are going to be residing well as as best we know it are going to be residing at an address I'm going to go back to my homepage because I also have consumer lifestyles data this can be can we ask a question there are two questions they came in when you were demonstrating the US new businesses data base the first question is how is it that some of those companies have a listing without an address and the second question is can you also look up how many businesses have shut down in the last 12 months during COVID you know I can't do that in the new business filings but I can do that in the in the US business database by just looking at closed businesses and that's as we can get that information realize that when we make our phone call let's say we don't reach that business that first attempt and we're calling Monday through Saturday that's when those researchers work and they work from 7 a.m central standard time to 9 p.m central standard time that Monday through Friday and then a reduced hours on Saturday so they're calling those businesses but the process is we keep calling for two years unless of course we see maybe from their website that they're closed then we'll update that accordingly but if we don't find any information about closure we will continue to try and reach them for two years so we keep them verified until we can't until we've exhausted that period of time and then we'll move them from that verified status into unverified they well may be closed we just haven't learned about that so let's go back to that first question about the new businesses it was the question was why am I not seeing addresses with all those new business filings that's exactly what I'd like to know because we got that filing through the secretary of state's office but that business chose not to put an address in there we copy exactly what we get if there's no address bingo we don't have an address and that's something that we try and obtain when we make a verification phone call in some cases we don't even get phone numbers so then we're left trying to search online for phone numbers about a business right and then get that information verified it's possible that a new business filing we never reach we never move that from that status other than moving it out after a year so you'll see that perhaps as an unverified business and it may not be a complete address because again we didn't get that in our in our in our file great questions other questions I have a question how often the databases updated so remember at the outset I mentioned that the U.S. business database we're pushing any new data that we get about about businesses we're pushing that new information out every Thursday and the Friday morning so 52 times a year this is being updated with new information right whereas the U.S. historical is technically at the beginning of every year and the new business that's also weekly that's why it gives you that ability to look at it from as recent as last week all the way up to within the last year thank you you bet the consumers this is the only consumer module that's updated weekly the U.S consumers the standard white pages the U.S. health care and the Canadian businesses those are all updated monthly whereas the jobs and internships this information can be updated multiple times in a day just depends on what's happening within any given community within any given area I've seen where I've gone in and done the same search in the morning and came back and did the same search in the afternoon and there were more records added so it just depends let's do this consumer lifestyles this is a terrific database I helped a lady do a search just recently she was she owns a dog uh morning kennel and she was interested in finding because you've heard it on the news whether it's your local news or the national news you know some of the morning hosts have have uh their dogs present with them especially when everybody was working from home and they had their four-legged friends with them during their production piece we know that a lot of people have uh purchased pets in this last year or so and so this lady has a boarding kennel and she knows that people are starting to go back to work going on vacation work we hear on the news about the fact that airports are getting busier and busier nowadays the she expects to see an increase and she wanted to be able to identify those people in her immediate area and it was based on a radius she wanted to be able identify those dog lovers so with that said I would go right to advanced search like most of the databases we're getting this consumer and and lifestyle data from a variety of sources surveys that people have completed warranty card submissions that they've sent in you know maybe I have maybe I bought a uh one of those uh dog bark collars and I sent in the warranty on that collar because it gave a uh a one-year parts and labor whatever they train that I sent that in along with my address information etc so we're capturing that from those kinds of sources membership subscriptions people have joined I wasn't in the database as a dog lover when I first moved back into Omaha I started buying my dog food at petco and was soon identified under lifestyles as a dog lover so here are my pets and animals and you can drive in just those that are dog lovers in any given area and there is a scoring system that works in the in the background it's zero through nine but we will only show you people who score a six or higher so anybody that's a five would not show up in a search for dog lovers let's just do the city of San Francisco again I'll say go I'll select those results so instead of showing all per household I would switch it to one per household one one name one address right I have a total across San Francisco of those dog lovers to the tune of 2100 that score in that six or higher range if I wanted that universe I can get to just that group she wanted to be able to do a radius around her physical uh location where her boarding panel is in order to be able to do that but we'll just look at the entire community here and again it's always going to give you that same message about the telephone numbers that may be displayed and I often get this question Bill how many of these are cell phone numbers have no idea we are not asking for that kind of insight so if somebody filled out a warranty card and they put their cell number down versus a landline or if they even have a land landline we don't know the difference we just know it's a phone number for that person so here's that here's what that information is going to look like it's going to give you that name information now everything that we've seen is that she's single been in this home for a number of years we have some neighborhood information along with those lifestyle indicators now the only thing we asked about were dog lovers not not not gerbils or goldfish or hamsters just dog lovers we could do another search for say like general cooking and this record may not come up because she's not active enough in that category in fact a a library that I used to cover the state of Florida in a library staff member that I'd known for a number of years she called me up one day and she was looking at this lifestyle's interest on her mother-in-law's record and she said bill there's a problem with with my mother-in-law's record as it relates to this technology and entertainment she said I can tell you that she is not at all interested in electronics so that's an error and and she shared a few other insights with me and I I said well I was with one moment please so you're telling me that your mother-in-law has never bought any electronic games or any kind of products for any of your three children or for that matter any of her other grandchildren is that what you're telling me and she said I understand just because you see this doesn't mean that they're active in that category it's just it simply means that they had have had some interest at one point in time in that category but that record wouldn't show up if we were doing a search for those particular products because they're not active enough so that's how that is always going to work and notice this let's let's go back to the I'll revise the search slightly and we're going to notice this other section that's called consumer snapshot and it goes from here with age all the way down to veteran present let's grab a few of these and we'll grab some age ranges here and we'll say married with children present what is that going to do to my total now that I added some of these additional filters so now I have 69 records at that point I can view those results and get to that that level if I need to so know that that's always available as well just depends on what you need and of course the download works the same the print function and the save search any questions regarding the consumer lifestyles yes yes there is a question so many websites and companies say they won't share our personal information such as the fact that we have a companion animal so how do you get this information is it by definition limited to only companies that are willing to share the customer information or do you have another way of getting that information know all about those company relationships yes correct like I mentioned I was not in the database when I first moved back into Omaha but it was my activity through petco and specifically my pals membership that identified me as such thank you you betcha other questions I don't see another question right now in the chat any questions on any of these other modules we're about six minutes before we conclude I'd like to give it enough time that we can answer any last minute kinds of what ifs or questions someone asked for a link to the database let me send it again and that access is always going to be obtained by going through the San Francisco public library but you have that like nice little example that you shared at the beginning correct yes but in my introductory slide I didn't actually include how to get to the database yeah so so Jenny if you click on the link that I just put it lists all the database that start with the letter R so you scroll down and you will find a reference solution so you click on that link and you will need to type in your library card number and pin and and you will have access to the database so there's a question from when if I want to see what information about me it's included in the database what kind of search would I do just name and name and city state would get you there so he would go into consumer the consumer database and yeah yeah yeah so you could do just the name search and then that city state and that should produce a record for you if it doesn't that means that we just don't have your information there thank you other questions I don't see another question in the chat but thank you very much bill for your wonderful demonstration and thank you everyone for joining the program I hope you all find the demonstration and the reference solution database useful to you we will be sending out the evaluation survey together with a link to the recording later this afternoon please give us your feedback so we can continue to improve again thank you everyone thank you bill and have a wonderful rest of your day thank you everyone thank you goodbye