 Testing, testing. Okay, so a little bit about Social Explorer. Social Explorer contains about 220 years of U.S. demographic data. It's essentially a digital tool that allows you to access this data, which also includes economic data, health data, religion, crime data, et cetera, in both visual and traditional report format. It includes U.S. census data back to 1790, as well as some specialized sources like the FBI crime reports, election data, and more. And there is some limited international data. I do see that Social Explorer is adding more and more of that, but by and large, it's focused on our domestic U.S. data. So what I'm going to do is start by demonstrating how to actually access this tool. The file library pays for a subscription to Social Explorer. So you'll want to follow this pathway that I'm showing you. You'll want to go through the library to access the database to make sure that you have access to all of the features that our subscription pays for. So here we are at the CSUSB homepage. We're going to go up to the library link here in the top right. And you can find Social Explorer under our database link. This is that icon kind of in the center right, right here. Choose a database. And there are two ways where you can access databases. One is through our A to Z list. So if you know the name of your database, in this case, we would just go to S to access it. The other way to access it is here over here on the left under databases by subject. We have a statistics category here on the bottom right. And if we click that, Social Explorer is the first database. So I'll go ahead and open that up. And here we are in the tool. So this is a really important piece here. Social Explorer allows you to create an account. And if you ever want to create a map or build a table and actually save that, you're going to want to log into your account. You can see here on the top right, it says GS. I'm already logged in. You don't need to necessarily do that right now, but just keep in mind that if you're in there playing and you create a map and you haven't logged in, it won't save it after you log in. So the best thing to do is just go ahead and get in the habit of logging in from the get go so that everything you create there after you're able to save. OK, so this is our landing page for Social Explorer. Over here on the left, this kind of helps you navigate. On the top left, it says explore maps. And this is highlighted blue here. So that tells us that's what we see over here on the right. This is also where you'll access tables. Geo data is new. We won't cover that in today's session. Oh, no, Barbara can't hear anything. Barbara, I'm not sure if you can hear me now. I'll go ahead and type something in the chat. But yes, this will be recorded. So I'll make sure that this the recording gets sent to you. All right. Over here under my projects. Also, this is where we can access maps and reports that you have created and saves. OK, so we're going to go ahead. As I mentioned, we're going to explore maps. This is what we see over here on the right to get in and start creating your own map. All you need to do is select one and click the blue explore button. So I'll just start with this one at the top. Go ahead and click explore. This is our default map. On the top left, this tells us what we're looking at. So we're looking at population density per square mile. The maps in social explore explore our dynamic, meaning if you hover over them, they'll give you more information. So here we're getting the population density of California. We hover over Colorado. We get the same and it changes and so on and so forth. Over here on the top left, this is where you will change your data depending on what you want to see on your map. So to do so, we'll click this blue change data. And there are multiple ways here for you to access data. The first is by year. Notice we have a lot of data. The first is by year. Notice we have a row of years listed here. I'm going to click show all years. And notice we can go back as far as 1790. Under the particular year that you select, we have what are called categories. These are essentially things that are calculated in a survey that you can display on your map. So here in 2018, we can display population like we currently are viewing data about sex, income, marital status, and so on and so forth. We can see there's quite a few different categories that folks have measured and accounted for. What I like too is it says, it gives you what's not available for the selected year. So 2019, for example, or 2018 doesn't have industry data yet. Travel time to work, religion. Just note too that it can be frustrating at times. The way that surveys work is they're not necessarily administered every year, your data source, and it might not necessarily be measuring what you want for the particular year. So this is a case where you kind of have to work with what's out there. Let's go all the way up to 1840, just as an example, and see what types of things they were measured looking at back then. So notice the categories we have available for 1840 are definitely fewer. We have population, sex, occupation, disabilities, age, race, and slavery. So this is something they were measuring back in 1840. This was legal back in 1840. So if we click on that, we can look at, for example, slave status and click on slave population. And our map changes. Notice it doesn't look the same because again, we're looking at data from 1840. And our map is color coded, depending on the percentage of the population that was a slave population. So we go to Maine, for example, 0%. And that's why we see a really light yellow color. But if we go down here to a state like Virginia, that's darker in color, 36.2% of the population was a slave population. If you go over to Missouri, it's not quite as dark of a color. It's an orange, 15.18%. We go down to Mississippi, which is even darker. We've got 51.97%. And so again, I mentioned this map is dynamic. It changes based not only on the data that you're displaying, but also on the color scheme that you choose. And I will cover how to manipulate that in a moment. Okay, I'm going to go back here. So that's one way to select data is by just simply selecting the year that you want and narrowing down from there. The other way at the top here is if you click on all data by source, this allows you to select your source. So we're at census 1840, but this allows you to browse all of the different data sources that are available to you. So we have presidential elections, congressional elections, population estimates, religion, and so on and so forth. This does assume you know which source you want to pull your data from. So this is useful if you have an assignment or you know exactly what you're looking for. The other thing that you can do is search. So we have the search for data icon up here on the top right. This is useful if you don't know what source you want to pull your data from, but you know a topic. So if I wanted to look at female income, for example, I can search my variables and type that in. I'm going to change 1840 up to all years. Unfortunately, I don't think there was much female income in 1840. My sources are all sources and now I can skim everything from all of my sources all years that address female income. So if I go, I can scroll down here. And if I want to look at, for example, a median income for population 15 and over female, I can see this is from the ACS. This is the American Community Survey from 2018. And it shows me the particular table. So let's go ahead and click on that just to see what happens. All right. And so I have my map here. Visually this isn't going to close this. This isn't particularly interesting. Because the color scheme is pretty uniform here. So let's go ahead and pick something else. I'm going to change my data. I'm going to do my search again, female income. And let's do female household or no husband present. There we go. Okay. So this is pretty interesting. If we go over to Mississippi, we've got 10.16 female household or no husband present. We compare that to the state like California, which is 4.73. So we have a pretty interesting map right here in front of us. We have a pretty interesting map right here in front of us. We have a pretty interesting map right here in front of us. All right. And I should have mentioned, if at any point you have any questions, feel free. You can either use your microphone or use the chat. And I'll be happy to answer any questions you might have. Okay. So in our box up here, the default is to show the data by state. You can also show the data by the county. So I just clicked on county and now you, now we can narrow it down to county. And it also lets you get even narrower. So by congestion, excuse me, congressional district census tract. Again, depending on the data, you can narrow it down by elementary or secondary school district. And so on and so forth. I find that county data sometimes tells a richer picture than state data simply does. And it really depends on your goals as a researcher and the message that you're trying to convey, as well as what sort of data is available. You can also change how your, your data is displayed. So again, we're, we are shading our data, depending on how great the percentages. So again, here, Lake County, Oregon, 10.75% is darker than Modoc County, which is 1.24%. We go up to shaded area. We can select bubbles, which gives us larger bubbles for areas for counties that have greater percentages. And we can do the same for dot density. We see a dot down here. They don't always appear where you want them to dot density. I don't love. So just keep that in mind that the. Bubbles and dot density is available only for data that is gathered as counts and numbers. Whereas the shading is used for medians, rates, average averages and population density. So again, be aware that the visualization type, it might be limited based on the type of data that you choose to display. But again, I have a preference for county level shaded data. I think it makes sense. It's pretty obvious. The other cool thing that you can do over here on the left is change your color palette. So the default is SE orange, Southeast Orange. I'm not sure what that SE Southeast is referring to. But we can change that. We can change that to fern green, for example, or blue. So that's just, those are some other neat ways you can manipulate your visual, however you like. Down here on the legend on the bottom left, you can also style your visualization down here. So if I click on this edit icon, this also opens that up and allows me to change the color palette and the visualization type. So that does the same thing. Okay, so some more ways that you can change your map. We see this hamburger icon, the more options icon on the bottom right of this top left box. If I open that up, it gives us some options for things we can do. The first is to create a report. It will create a report of the entire map or just particular geographies that you select. I'm going to skip this for now because we're going to be creating re, I'm going to show you how to create reports at the end of the session. But we're going to pop down to mask map data. And what this allows you to do is really focus in on one particular geographic area by eliminating the data from the other, the surrounding areas, which can be really powerful if you would like to use your map for a presentation or a paper or something like that. So I'll click on this. And this is a matter of selecting the geographies that you want to highlight. So if I look at my map, I see that it's pretty interesting here. We have South Dakota, part of the Northwest, Midwestern part of the country here. We have some darker, darker shaded counties. So what I can do, I can either select each county using this arrow, or I can do a rectangular selection. And basically select this area of interest and notice how all of the rest of these counties are blocked out. And so it will help my viewer, I'm looking at my map really focus in on the story. I want to tell. And then you can zoom in. Oops. I didn't want to do that. Clear my mask. And start over here. There we go. This will, can help me tell the story that I want to tell. So I'm, I am going to go ahead and clear that mask doing that by clicking clear mask in the top left. And hit done. And I'm going to zoom back out so I can see this better. Go back into my hamburger icon. And I'm going to pop down here to filter areas. Filter. This is a fairly new feature, but what this allows you to do is add specific criteria. So essentially add another layer of data. So I'm going to add a variable. So if I want to, for example, I want to add an additional layer of data. On top of the data already see. Add, for example, race data. I can do that. And so I would, I would select the particular data point that I want to visualize on top of this. And that would add that additional layer. And go back to my hamburger icon. Here we have map layers. Some more ways that you can add or, you know, add a map. So if we look over here, we have a list of different information that's on our map. So. For example, our state boundaries are currently displaying. I'm going to go ahead and uncheck that box and they'll disappear. It was pretty hard to tell because my county boundaries are shown, but I'll go ahead and remove those. And there you can see the difference. Those are gone. So if you zoom into your map, you will see more. So notice that those state capitals just appeared. We're getting some major cities. I just saw Omaha and Kansas City appear. More cities. More cities. And eventually. There we go. I'll get things like major roadways. And these are all things as you zoom in. On the left here, you'll have the option to remove. And then on the right, you'll have the option to remove cities. And those are gone. I can remove cities if I want. And capitals. And so again, when I zoom out, I'll no longer see those. And I just have the state names. So let's go back in here. Under map layer. I also like this satellite view. This can be useful if the story that you want to tell with satellite view. So you can use this for photography. For example, you want to look at the movement of people or the movement of. Like transportation, like commute, commuter data. Or something like that. We can do a satellite view. And what it does. Is that it overlays our data on an actual satellite here. Over on the left. We can change the opacity of our data. darker or lighter. We can change the color. So right now it's not very vibrant but if we click on that we'll get some more greens and browns. And then again this is where you can add or remove some of those layers. So your state boundaries for example or your county boundaries. So I'll go ahead and put those back on. Okay so my map's looking pretty different than when we started. There we go. So final point, final piece I want to point out here with under our more options hamburger icon is the annotate map on the bottom. This is where you can add your own unique information again which could be really useful for a presentation or a poster. Up here these are our options. So we can add a marker. I'm going to go ahead and add a marker. It popped up here in red and this is approximately where I'm from, Belle Plain, Iowa, town of about 3,000. On our left notice that I have the option to title this marker. So I'm going to go ahead and title it my hometown. The symbol here is red. If I click on this I can change the color of that symbol. So I've just made it blue. Also the size and opacity and we can do the same with the color of the text here. Notice if I want to add a legend to my map. This is where I would do so right here on the bottom is legend. I'll click on that and now my map has a legend. Underneath have appeared all the different things that I can add to my legend. So it wants to add this marker my hometown. If I didn't want that in my legend I would simply uncheck that box. Other options at the top are lines, boxes, shapes. The arrow one might be helpful. So if I wanted to, for example, click on that and visualize my journey to Colorado and then from Colorado, oopsie, from Colorado to San Bernardino, I could do so. And again over here on the left this is where I could title my arrows. I could change the shape, the size, the color, the width, and so on and so forth. On the top here too we have what are labels. This is essentially where you can add text to your map. So if I wanted to actually on my map go ahead over here. I'm going to type in whatever I wanted to say. So my journey westward. I could do that. It's black. It's really hard to see up there so I'm going to change the color to white and make it a little bigger and then I'll move it there and there we go. There's my beautiful map, my journey westward. The other thing that's pretty neat too, you can add an image to your map. So if you, for example, wanted to, for this map I could add an image of CSUSB which is what brought me here and I could size that accordingly. So some fun ways for you to customize your map again depending on the story that you want to tell with your data. Okay so I'm going to go ahead and hit done and notice here that we have my legend has populated based on the annotations that I've created there. So I'm going to pause there. Do you have any questions for me right now? Okay well if you do just go ahead and use that chat function. All right so I have one more thing I want to show you with maps and then we'll move to actually creating tables of your data but to do so because I kind of have a mess of a map in front of me right now but I'm going to go ahead and change my data. I'm going to go back to categories and let's select, let's see, 1980 and I'll go to population density per square mile and my satellite is still on here so I'm going to remove that. I'm going into satellite view, removing that. I'm also going to remove my annotations and just create a clean map here. So I'm going to delete all of these things here. Delete my arrows. Delete that title. All right great so we have started fresh. Okay so I see a question here. Does it have to be all US or could we do a county? Yes absolutely of course it depends on the source and whether they have gathered county level data but you see up here where it says we're viewing it by state. We can also select county and then if we zoom in, move my map over, we get data by San Bernardino County and you can also select county level data when we go into the tables. There's some other different levels at which you can display your data. Here we just have census tract but earlier we were looking at another source and we were looking at data by school district for example so again what's available really depends on the data that you're looking at but for population density absolutely. Okay so I'm actually just for the sake of demonstration I'm going to move this back to state and remember we're looking up here at census 1980 data. If I go over to the right I have an icon that almost looks like an open book and it says change map view. I'm going to select that and I want to choose side by side and so now move this over. We have two identical maps side by side. They're both population density per square mile and they're both from the 1980 census. What I can do however is change one of those and I'll change the one on the right. I'll change the data and what I want to do is select a different year let's say 2016 but I want to choose the same data source and variable so I want to do population density per square mile and so what this allows us to do is do some comparison over time so we can move our oops there we go. So we can see for example that if we hover over California from 1980 the population density per square mile is close to 150. We pop over here it's a darker color it's almost 250. This color scheme we've selected doesn't really demonstrate the drastic changes as well as I would like so I'm going to change this back to the default the se orange on both of these maps and I think that'll give us a better visual. Kind of I mean we can definitely see California is a darker color same with Wyoming in 1980 population density was only 4.8 and now we're at six so really farce we populated still but there has been some change. I want an even more drastic example for you all so I'm going to change the data on the left go back even further to 1950 we'll do population density per square mile and I can already see on my map that it's not giving me that at the state level so that's not going to work again it's a limitation of what was collected when let's try 1970 let's see what we get there we go okay so we can see some more contrast between 1970 and 2016 the other option I have for comparing maps or doing some comparing and contrasting over time is under change my map view the swipe feature and so this is a really neat interactive feature that allows you to move your map so if we move the entire map to the left to 1970 we can slowly move it to the right to 2016 and we can see that these many of these states are darkening as the population density per square mile increases so yeah Colorado is darkening almost every state is darkening but it provides a really but it provides a really neat way for whoever's viewing or viewing or interacting with your map to see change over time so it can be a really nice educational tool as well okay so at this point you will have been logged in and so you can save and share your maps that you create so at the top we have this share icon this will give you a link that you can go ahead and send or email to someone else your students your colleagues your professor whoever you can also embed your map into a website or email it directly you can here you can export your map as an image or you can save it and I'll go ahead and save it now as let me see February workshop map and I can provide a description if I want to so I'm going to do my side by side swipe and I'm going to hit save I go here to the top left and go back to my dashboard back to that landing page this should look familiar this is where we started and under my maps this is where I can find that map that I just saved and here it is February workshop map and I can go back in and edit that or again share that from here if I would like so that's where all that stuff ends up that you save all right so let's go ahead and move to tables we started again here on the top left that explore maps tables are directly below and when you go into tables what you see are different sources of data so we have the US decennial census the American community surveys US school data health data and then down here this is where we have some amount some of our international data data on the Canadian census UK census European statistics data and then development indicators from the World Bank so again it's not very robust as far as international data but it seems like they continue to add more and more let's go ahead and select US school data and this is new I haven't explored this yet myself and it will tell you a little bit about where the data is coming from if you click on more info it will give you some more details about the survey and where that's coming from the data source but again I'm selecting US school data and I'm going to click begin report note that if you're using tables you do need to know which data source you want to use in maps there's that nice search feature where you can just search a topic like we searched female income and it gave me options that's not available here so again you kind of need to know what sort of source that what source you want to start with before you even begin okay so we're in school digger 2018 school data this is where you can select a geographic type and I know Barbara you asked about county level data this is going to depend on the source so school digger only the our only options are state level or lea which is like the school school district I looked this up the other day I can't remember the acronym off the top of my head but let's stick with state let's do california add that and let's compare Iowa add that you can select more than one state at the same time if you'd like you would just hold down your option um function and then select those together or as I just did you can click and add one by one then we will proceed to tables and this gives you different options for what you want to add to your report so here are options our rankings school attendance and school details so let's say I were really interested in rankings of schools I would go ahead and add that and then show my results and so here we have our data table notice here that you can over over on the top right click excel and download this table in excel format or you can do an s s excuse me csv file for different programs like spss um and sas and so on and so forth what I'd like to do is um go ahead and choose another data source so we can create a more robust um table there wasn't much data there so again I'm at our dashboard let's go ahead let's choose an American community survey through your estimate I know this is going to give us a lot let's go back to 2011 2013 I'll begin my report and here we go this is what I want to see um this gives me a lot of different options for geographic types so let's do county and let's look at California and let's look at San Bernardino county and let's compare this to Riverside County again I could add as many counties as I want but for the sake of demonstration I don't want my table to be too unwieldy so we'll just stick with these two counties I'll click proceed to tables and now look at all these fun options I have for information to add to my table so I'm just gonna pick a few at random here um uh let's do average household size that might be interesting to compare the two counties and let's look at average family income so income and household size and we'll do show results all right and so here we have our nice neat table again it's pretty tiny but we could have added as much information as we wanted to depending on our goals but we can see here the average household size is 3.2 in Riverside County versus 3.4 in San Bernardino County an average family income is 77 897 in Riverside and 72 422 in San Bernardino County and it gives you also a total on the right hand column if you'd like to see that so again it's a pretty tiny table but we only selected those two those two pieces the household size and income but I've written tables on health data that can get pretty granular that gives you a really interesting picture about some of the disparities in healthcare access for example so you can do some really really neat stuff with this okay um so I already showed you that you can download your data as an excel file or a csv file on the top right here again this is where you can save or share your table and then I want to wrap up today by showing you a resource that we have created at the library so I'm going to go ahead and go to the library's home page and if we click on library guides in the middle we have created a guide with some with some supporting and useful information for how to use social explorer the easiest way to get there is under the with the search bar just go ahead and search social explorer um and notice this first hit has social explorer in bold if you click on that that takes you right here to the guide um and so our home page just sort of explains um how to access our professional license going through the library's home page like I showed you before gives you a sample map here and then you can use these tabs at the top to navigate the guide the first one is for creating maps it walks you through how to do maps it's like we covered today I also have a tab here for creating tables um how to start a report what exactly you need to click on and then an example report that I ran and this is um I was looking at health data comparing Riverside and San Bernardino County and I got this pretty interesting report here looking at birth weight um access to doctors health insurance coverage life loss mortality diet and exercise um and so again I was I was able to identify some um disparities in access here that were pretty interesting um I also have a tab up here for citing maps and reports um this just provide goes to a link that social explorer has provided about how to cite their information so if you're using maps or tables and you want to incorporate that into a lecture or a presentation or a paper that can be really useful because I know citing data can be tricky at times um and then finally this last tab is a workshop recording this was my workshop from last year the interface has since changed so um hopefully I will have captured a good recording today and I will update that so you can always return to this if if you um just want to revisit how to use the tool so that is all I have for you today um I know we've wrapped up a little early but we have that means we have some time for questions so I'll hang out a little bit if there are any questions or if anyone would like to me to review anything one more time but I do appreciate you joining me today and like I said I'm I'm hoping to get um today's recording up here um in this guide I'll update this with today's recording so you can always access that in the future if you need a refresher so thank you all