 Hey there, Chad Bondra here for High University Libraries. Today I had an awesome consultation with a student. She was looking for some pretty difficult to find information. Basically she was looking for, I got to read it off here. She's looking for small companies with less than 75 employees with less than seven years of operation that are located in specific counties in Ohio that do manufacturing in a particular or in a particular kind of business in local areas in Ohio. So the immediate database that came to mind was a database called Mergent Intellect which is a great tool to use if you need to screen for specific company criteria and get a list of companies in your area. So this video shows you how to do that because I thought it was such a cool question that I really wanted to share with you guys how to do that. So here you go. So this is the Mergent Intellect homepage and Mergent Intellect is basically like a big phone book that contains just company information. So if we want to go and just search by company, for a particular company name, we could do that here. For the purposes of our search, we're actually going to do the advanced search feature down here which is going to allow us to screen or to search for custom criteria for our companies. The easiest way to begin our search is to search by location and for that search we're going to search by county. That's what the student was originally asking for was counties in Ohio. So we'll do USA here and then search for Ohio. And it's going to give us a list of counties. And for my example, I'm just going to choose Muskingham County as my example. And once you have one selected, you get out here and click add to criteria. And then it's going to populate how many companies that are in Mergent Intellect in Muskingham County. And in this case, it finds over 11,000 companies in Muskingham County that are in Mergent Intellect. Next thing we're going to do is look for the size of the company by employees. We're going to go and click on size. And we'll do employment. And we'll say she wanted smaller companies that have less than 75 employees. So we will do that. Add to criteria. And you can see this only got rid of like 100 companies. So that's not really a great way to screen. What we can also do is now we're going to go and limit by industry. So this will give us a little more granular search here. So we click on industry. I generally prefer to start with the NAICS code. The NAICS codes are newer. This is the way of industries are classified by particular codes here. And if we look at manufacturing, we see this is kind of more kind of traditional manufacturing. If we go and look at things like this, we see there's chemical manufacturing plastics. I'm just going to choose a section within here. It looks like they're doing a lot of computer equipment and metal manufacturing and that kind of stuff in this category. You can drill down further if you like. So if you're just looking for a computer electronic equipment, you can do that. I'm just going to choose 33 right here. And then I'm also going to look at just choose another industry. We'll choose the information industry because this will contain things like internet publishing, telecommunications, search providers, web portals, data processing, all that kind of stuff. So kind of some high tech areas in there. So we're going to click on that right there and add a criteria and watch our number here. Our number is going to go from 11,600 down to 269. So that's a lot more manageable for that area. The download limit in Mergent Inselect is about 2,000 companies. So we can't get like 12,000 companies and do a search and try to download all those companies. So we want to make sure we get a manageable set and 269 is definitely appropriate. So what we're going to do is click on all right here. If we just click on the download right here or export, we're just going to get this list here. I want some more extensive information than that. So I'm going to click on all and I'm going to go up here and click build files. This takes us to this screen and you can see all these sections are actually checked by default. I don't really want all that data. So I'm going to actually click on choose fields which will allow me to go in and choose which fields I want. Obviously, I want company name. I want their website address if it's listed in here. I want their physical address. I also want their NAICS code, their primary SIC code and the description. So I want to know what kind of business they are in. And we're just looking at the primary, what they're primarily engaged in. I'm also going to go in and look at here's our year of founding because part of our question was the student wanted to know companies that were founded in the last seven years. And I want to know if the company is a subsidiary of another company. And also if they are a subsidiary who the parent is. Finally, it also be a good idea to do the size. So we'll do the for sales. And let's do how many employees that they have at that current location. Once we're satisfied with that, we go down and click on we have to enter a file name here. So I'm just going to call this Chad's. Let's call it Chad Muskingham. And we will build our files. You can either email it to yourself or download your file. I'm just going to click download here. And this opens up. And if we just click on the Excel file here, it's going to open up in Excel, we can look at it within Excel. So I want to enable editing here. So I can do some sorting. And what this allows you to do, you can see these companies, they look kind of random here. But if we scroll over and look at sales, we can see that the companies are indeed sorted by sales. Okay. So what I'm actually going to do is the original question was to find companies by industry that are less than seven years old, and we can't screen for year of founding. But what we can do once we have our list here, that's one reason I want to make sure we have the year of founding in our in our list of that we're building, as we can go and now do data. And we can sort it. And we can sort by year of founding, and then largest the smallest and then what do you know, in our list here, now we have the companies that were founded by your founding. And that's a good way that we can identify companies by industry within the past, you know, seven to 10 years found in the past 70 years, seven 10 years by location, a particular area. So hopefully this video showed you how you can use emergent intellect to do some really cool stuff and get really granular and get some really good information about the companies by industry by location, with less than seven years of operation with less than 75 employees, you can get all kinds of crazy stuff like that emergent select should need more help about about emergent select or any other database look for the contact link on the business blog and got to help you any way I can take care and have a great day.