 Hey there, Chad Boninger here for High University Libraries. Today I got an email from a student looking for state-by-state consumption of organic foods. To get that data by state, we're going to use a database called SimplyMap. So this video is going to show you how to do that. So here we go. So when you first get to SimplyMap, you have the option to create an account if you have not done so. I highly recommend you do that because it will allow you to actually save your searching here inside of SimplyMap. So definitely do that if you can. Use your high email address. And you can save the information that way. Upon signing in, you're presented with this screen here where you can do a new map or a new report. And because we're looking for state-by-state consumption, we're actually going to look at rankings of information. So to create a new ranking, just go up to New Ranking here, click on the link here. And then it gives you options to launch the ranking wizard or basically choose variables or locations. So I want to choose variables first. And what we're going to do here, I don't really know what I'm looking for in these variable categories here. So I'm actually going to click on Search here. And then just go up and search for organic. And you can see it brings up lots of things. Percent of people who use organic food, household uses organic food. If you want to, we can actually click on that and use this variable. And then close this guy here. And then go over Locations. And I just want rankings by state in the US. So I'm going to do all of the USA. And once I do that and close the tab here, it's actually going to open just the USA. If I want to change that, I can analyze data by states. And then change this. So there are 50 rows because there are 50 states. And so here we have a nice list of the percent of households who use organic food by state in the US. So that's one way to do that. Now you might want to go back in and look at another information there. Or you might want to just create a tabular report on particular states. So let's do that. Let's go and do a standard report. And we can do Locations. And let's say we just want states. And let's just choose a few different states. Let's just do Alabama since it's right through the top. And let's do, we can type in Ohio. If you just want a comparison of states, you can do this. And you can keep on doing this till your heart's content to choose different states. And then we can go back over here under Variables. And if we want to, we can click on Recent. And just select that one variable. So if we want to do that, it'll give us a comparison of comparing Alabama to Ohio to the USA as a whole. Now let's say we want more information about the information. What you can do is say, well, if I want more information about this, you can click on a number of things. You can just click on View Metadata. It'll tell you the path for this information. You can also, once you do a search, if we go back and do a search for organic, again, we see the folder that this information is in. Simmons Local, Food, General, Organic Foods. So what you can do is go back and say, let's look at variables. And there's Simmons Local. And then we have Food, General. If we scroll down, here will be Organic Foods. And you can say, this is your household uses. And if you want to, you can say, let's use all variables. Or you can say, organic foods, foods type most often, use all variables. And organic foods also uses, use all variables. And you'll notice we're getting percentages and numbers. If we were really just going to compare states, we might just want to just use percentages. And again, these are projections. These aren't actual numbers. These are projections that are calculated by the Simmons Market Research Group. And so you can see we have all this data here on percentage of people who use particular kinds of food by location. If you want to add more locations, so again, go back over here to Locations, Change to States or Cities or whatever you want to do there. And let's say you want to add Tennessee in the mix. We can do that. Use Location here. Close the tab. And here we have information on that. Now if you want to, we can go here and download this as a report as an Excel file and make charts and tables and that kind of stuff until our hearts content. So a great way to get information that way about state consumption of organic foods in SimplyMap. Hope this video helped you. Should you need more help, look for the contact link on the business blog. I'll be glad to help you anyway. Take care and have a great day.