 I want to reiterate that when Pauline said she covered the tip of the iceberg, I mean there's such a wealth of data and census. She really only covered two data sets, the 2010 census in the American Community Survey and there's so many other data sets and so many other tools. Would anybody be interested in follow-up training somewhere along the way? Okay. I may inflict a survey monkey on you later to find out what kinds of things you're interested in knowing more about. CNOW's job is to democratize data among other things to grow local data capacity. So whether it's being able to bring Pauline back in for a more advanced training or more of this or customizing something, once we know what your needs are we can try to address those. I also want to tell you I've been working in community data since 1992 for lots of grant writing purposes but also community assessments and so forth. The census should always, always, always be the first place you check. Now if you find that the margins of error are too wide for the geographic area that you're interested in or what you need is not there, okay move on to something else. But when a funder or other stakeholder that you're giving data to your board of directors sees census they're going to trust it a whole lot more than if it's some no-name non-brand organization that puts something together even if they use census data to get their numbers. So if y'all are already in the habit please start with the census. And let me take you first to cinow.info. This is community information now's home page and again we have three legs to our stool nowcastSA is webcasting this training today. NowTek is actually bridging the digital divide through tech training through community based learning centers like the one you're sitting in today. And then NowData let's click on NowData up at our projects. This is actually where you're going to find all of the data shop oops I messed up my very first agenda which is to let you know that we have an address, a newsletter sign up here on the home page. We issue 10 to 12 newsletters a year so if you sign up for this you won't get a flood in your inbox but you will get updates about new data that we have and also interesting webcasts and so forth. So if you want to subscribe you can do that here on our home page or anywhere in the NowData site that you see that subscription button. So here's our data explorer page and I just want to give you a brief orientation we're not going to go into nearly as much depth as Pauline did for the census tools. We have some focus areas where folks have asked us to do some in depth work. Some of you may be familiar with Voices for Children in the annual child data report that they put out. We gather the data that goes into that report. We have a grant from Methodist Healthcare Ministries to collect mental health data and then we do data support for the Eastside Promise neighborhood, that implementation grant on the Eastside and the weekly choice planning grant. So you can explore those and there's some narrative behind those if you're interested but mostly I want to spend our time this morning on this right hand screen which is how you will search all the different data that we have locally which includes census that goes far beyond it. So let me just orient you to this side. You can do a keyword search and the keyword search is going to look through what we call indicators which is something like immunization rates among two-year-olds. The resources attached to that, maps and tables and so forth and also any descriptive text we have. So if you do a keyword search and the indicator name that you have cropped up doesn't have the word in it that you found that you searched for, it doesn't mean the keyword search is broken, it just means it's hidden somewhere down in the description or the resource name. You can browse everything we have if you have eight hours of your life that you never want to get back. You can go by topic and if you click on one of these topics you'll see a list of subtopics. I'll show you that in a minute. If you're only interested in one county then you can look at everything we've got within the county of interest and then we have some special tools and a help screen. Let me first go to browse health and safety. We're going to click show more options. That's critical. All the good stuff doesn't show up until you click show more options. Let's go to behaviors and risks. All the things that are upstream of good or poor health status. Let's say, I was expecting some folks from Comal today but they didn't show up so let's use bear instead of Comal. Click the bear check box and let's say that you need to know stuff below the city or county level. Let's just grab some check boxes. We'll say census tract, city council district, neighborhood, zip code and these are all war searches so you're not looking for everything that's by census tract and city council district. It'll be city census tract or city council district. Then you can limit by the format. We're not going to do that right now but if you were only interested in maps or only interested in tables that you could download and manipulate the data yourself you could restrict it that way. Is everybody caught up so far? Okay we're going to hit the magic blue button search. Now this gray text up here will tell you what you just searched for so we're exploring health and safety looking just in the subtopic of behaviors and risks just for bear county and just for these kinds of sub county data. That's your shopping cart. That's my shopping cart. We found 10 indicators the way that our data are organized again is you have your indicator and then you have what we call resources, a map, a table, a report, a link externally attached and there may be one resource for an indicator, there may be 27 resources for an indicator. Let's just click on walkability. Not everything that we do is crunching data from someplace like the Census Bureau. In some cases people have done a very good job of analyzing data and visualizing it and in that case we don't want to reinvent that wheel. So we do what we call curating. If you imagine a museum exhibit somebody pulls together the paintings that should go into that museum exhibit and we vet all these different resources that are out there and say this is a quality one, it's accurate, it's of interest, it's local, we'll add it to our collection. So we're curating other stuff as well as generating our own. So there's a lot of stuff here because we provide data support to Eastside Promise. We've got the walk score for every different neighborhood within Eastside Promise. But let's look at San Antonio, walk score for San Antonio. It's low, it has to be low. It's too simple to write here. It is. So here's a thematic map just as you were looking at earlier where red is worse and green is better and yellow is in between. You can see you're still within our frame and you can click back to indicator. You haven't gotten lost. You can navigate within the walk score site without leaving our website. You can see here downtown is very walkable. But especially once you get out to the suburban areas, not so much. So some of these sites will have the raw data for you and I know that I am always wanting the raw data. I want the map but I also want the raw data. So we can't guarantee that everything will always be available for the stuff that we link to but we try to get you the raw data every chance that we get. So San Antonio is the 40th most walkable city in the U.S. but like everything else, it really depends on where in San Antonio you are, right? Okay. So let's click back to indicator. That wasn't a surprise. That was a confirmation, 40th. So now from here, again, if you're just like you can't sleep, you can just browse through other indicators that are related or you can go back to home to get started again. But let me just let you know here that we've tried to add, we have the years that the data are for. We have the topics that it is filed in. And then we have some notes where we try to give you some user cautions or tell you something about where the data came from, help you interpret how to use it. I like the word user cautions. User cautions. We need to add user encouragement. Look, you found it. User encouragement. User cautions. I like it. All right. So I'm just going to use the back button. Actually, I'm going to go back all the way. Back to the exploring screen. Now that I've shown you one indicator, I just want to make sure that it's clear that each one of these bold titles is a different indicator and each one has a different number of resources in it. It's a little bit of a hodgepodge. We cover 12 counties in every different issue area. So we have a whole lot more on births than we do on elevated blood lead. Okay? So it may be a little bit hit and miss. But again, you will have to, nothing here is clickable. And if you click this view, again, you're going to see what's in there so you don't waste your time. If the walkability thing that you need is not actually in walkability, but you have to click on the indicator title in order to drill down to the good stuff. Here's one I like that we just found. Housing plus transportation affordability index. For those of you who are dealing with poverty, you know, the rule of thumb that housing should be no more than 30% of your income. But because transportation is so critical in San Antonio, we're a little bit behind the times on mass transit, although we're getting a whole lot better. And so many of our neighborhoods are not walkable. And, you know, you frequently just have to have a car or you're on bus transfers multiple times each trip. So the housing plus transportation index loads in transportation to the very basic cost of living for neighborhood affordability. All right, let's go back to home. I want to show you some of the stuff that we have related to the census data that Pauline has already showed you. Again, we curate other people's stuff and sometimes we are able to make it easier for you to get to it. So I hope that you'll all become experts in American fact finder. But let's say that you just got to have that population figure for San Antonio and you can't remember it off the top of your head and you don't want to go look through quick facts. How fast can you get it? Or you need data aggregated to a service area, which is the life that I used to live, that you've got kind of a random collection of census tracks and you have to aggregate a number like race, ethnicity breakdowns for your service area and you have to do that by adding up census tracks. So I did a keyword search for census and it found everything that has census in the title of either the indicator or one of the resources underneath it. So here you can see census is not in this title, but it is in the resource titles. So there's a reason those come up. I'm going to share you census 2010, census track, demographic and housing profiles. Now the Census Bureau this time with the new American fact finder, which has been by some of my fellow data geeks described as the Swiss Army knife to the buck knife. It was the old American fact finder. It's a whole lot more complicated, but it's a whole lot more robust. It's got a lot more tools in it. One of the new tools is something called a bookmark. It used to be you couldn't bookmark results to send to people. It would revert to the query screen. That's not true anymore. So let me connect to Bear. And here you can see it's taken you straight to Table DP1 that you guys looked at earlier, for Bear County. And the census tracks are all here in this pull down menu. If you only need one census tract, let's go back to 1305, which does happen to be in the East Side Promise neighborhood. You can see it there. Now on the indicator description, again, user notes and encouragement, cautions and encouragement. We've put text that says you can use the pull down menu to view each different census tract and downloading to CSV format will generate a file that contains all of the census tracks. Downloading to Excel or other presentation ready format will only save the one that you're viewing, the one that's selected. So right here, if I say download and go to Excel, it's going to build my file. I'm just going to open it rather than save it. And you can see that it has preserved the indents and everything that make the data intelligible to you. It looks exactly like it did on the screen. But it's only 1305, right? So we need to go back here and say download, because let's imagine that I need all the south side census tracks for my service area. So I've got to eliminate all the ones in all of the other areas of the county. I'm going to say data and annotations in a single file just like this is here. I'm going to wait incredibly patiently and be grateful for all of the things that are technologically possible. I believe in gratitude. While that's doing that, let me just back up here and show you that we have, let's say, that I want to search census demographic. So we've got the demographic and housing profiles for the congressional district, for the census tract, and for the county. So those are the shortcuts that we have available for you through these deep links. So here, it's finished. It never takes that long. I'm just not that patient. Now, here's the problem with this setup. You can see here are all the census tracks that you need, right? You can just select out or delete the ones that you don't want. However, we've lost the pretty indents. So you'll have to, the way that I do it honestly is to get rid of the ones that I don't like and copy it, paste it transposed so that these things are all on the left side and my census tracks are columns. This is the kind of thing we could cover in a later training if you wanted to do that. But I wanted to let you know how you can get all of the census tracks of interest in Bear County or just some of them, just one of them. Does that make sense to folks? Now you can navigate here back to search and change if you want something else in Bear County. Let's say that you didn't want the demographic and housing profile. You needed something from American Community Survey, but you still wanted all the census tracks. It's a little shortcut. You've already got the right geographies here in this list. So what else do I have for you? Oh, weave. Here's the fun part. Weave. Weave. What is weave? Weave is the web-enabled analysis and visualization environment, which I highly recommend you not say at a party. People don't think you're very cool. Can tell you from experience. Weave is an open-source data visualization tool that we started using that does maps and a whole lot more. Let me do a keyword search for immunization. I could also find weave. Wow, I don't have a show other. Okay, good to know. Usability testing on the fly. Each of these resources that's a weave visualization is labeled that way if you want to go and find them. I'm going to show you percent of children 19 to 35 months old with their 431-331 series. It does take a minute, and let me let you know. It works on any PC that has, it has to have flash and JavaScript. So it won't work on your iPhone. It will work on your Android. It will or will not? Will. It will work on Android. It won't work because iPhone doesn't like flash. So here's a thematic map. One nice thing about these visualizations is everything's tied together. So if I highlight zip code 7-8202 over here, can you see that it's highlighting it in the histogram in the middle? Amazing. And it's off the screen. This is childhood immunization rates. Two-year-old immunization rates. Beautiful. This is what we, yes, this is what we call it. This is by zip code. This is our time slider. This is my favorite thing. This is 2004 data, and it's going to take you through change over time. So I asked much earlier about changing. Right. And it tells you, I don't know if you can see in the data table, it says 2008, 2009, 2010. I like this map because it actually shows things getting better. We go back to 2004, you see how the histogram is pushed to the left? And over the years, it starts to move a little bit to the right until we hit the recession in 2009. Wow. So, again, because we do data support for eSide Promise, we can select the subset of... The slider is... I'm going to pause it for a minute. So I've stripped away everything except the two zip codes that make up the eSide Promise neighborhood. It's beyond what we're going to do today, but you can create under subsets, selections and subsets. You can create your own if you want to get information just for a handful of census tractors or zip codes that are on the map. But so I can play the change in time just for these two zip codes just the same way. And then I can go back to show all records. Under subsets, show all records. All right. Now let's say that you wanted to get 2010 only. You want the most recent thing there was. So you can manually move your time slider over to 2010. And let's imagine that you wanted everything on the screen. If you right click on the gray bar, you can print, export application image. And it will spit out for you the entire screen that you're looking at. And then you say save as image. Okay? Or you can print it from there, but I think saving as image works a little bit better. So if you only... Save as image and then you print it? Yes. Okay. Because it seems to give you more control over how it looks when it's printed. I wish this thing would stop playing. I want the time slider to stop sliding. Let's say you only wanted the map. You can just say instead of application image, which gives you everything, just the map. Now the problem is you can just like you can get something without a source, which is a terrible thing to do. You can get a map without a legend. So if you do this, be sure to grab your legend too. And that way the colors and the breaks are cut off. Also, if you want this data yourself and you need a subset of the zip codes, you can click export data and save it in CSV to your desktop. And let me show you another view visualization really quick. Given our probation, child use neglect and family violence. In addition to the maps and the bar charts, we have scatter plots, which I love. How many of you have seen scatter plots before? Do you know what you're looking at? About half. Okay. So the deal is here with a scatter plot. Here's 7-8-2-0-3. So can you see? I've got to lose my pointer and I don't. Can you see the highlighted circle in the first map? Thank you. Do you see this highlighted circle? And do you see these actual numbers? So what the scatter plot is doing is taking the rate of family violence, which is 144.3, and plotting it against the rate of juvenile probation referrals, which is 464.3. So there's where 464.3 meets 144.3. That's how scatter plots work. The thing that's cool about them is if you see a tight association between two variables, in other words a zip code where, let me say it this way, zip codes that experience high rates of family violence almost always experience high rates of juvenile probation referrals. You're going to see a very tight diagonal line up here because they always track together. If there were no association, these dots would be spread out all over the screen. So this is actually people run a regression line here when they get into more sophisticated data analysis, but this is a quick way to visualize whether there's a relationship or not. The size of the dot is the number of kids. Is that the number of kids? No, this particular one is the number of population. So you can see that even though this orange dot is not the worst zip code for either one, it doesn't have the highest rate of juvenile probation referral and it doesn't have the highest rate of family violence. It's got the most people. So if you're planning where to put services, you might want to put them where there's a whole lot of people needing services, not necessarily where there's few people with the greatest concentration of problems. I mean that's something that's with the organizational policy. So you can see here, this is darn near where we are now. Are we in 7-8-2-0-7 right now? I think we are. 3-7. Okay, so we're right next door probably. But here's 7-8-2-0-7. You can see that even though it's not got the worst rates of either one, it's got a huge population worth paying attention to. So here is a scatter plot of family violence against abuse neglect. So you can see again, there's a very close association. Where you see one, you're going to see the other. Does that make sense? And here's the data table again. It's cut off, but you can export this data. Some things are missing. We don't have data for it, especially family violence. You'll just see a blank there. You don't have the data, and the dot will appear off the scatter plot. Here's one where we have family violence, but we don't have given-all probation. Does this make sense to folks? And again, you can take the whole screen for just the scatter plot. All right, that is we. Eventually, we will have support for you to put your own data in Weave as a quick way to map it. Like the Census Bureau has given you great support to map census data. I can't imagine why you'd use anything else. But if there's data that comes from multiple sources or something besides census, you could use Weave to do your own. Let me show you one more thing that's coming up. I like to indicate home. If you click on custom crosstabs, you'll see the custom crosstab tool is no longer available. That's the big news. It's good news. The custom crosstab tool was a little bit hanky, and we wanted something better. Hanky, yes, that's the thing. Useless, totally useless. Community view is not going to be useless. And community view is going to be a public access web tool that's going to pull together what I call person-based data, administrative data like patient data, student data, client data. In the aggregate, you'll never see person-level data pulling that together with place-based data like census tract. So then maybe you would know be able to examine the neighborhood characteristics of the people that you surf, right? We know that neighborhood matters a lot. Growing up in kind of the stew of poverty matters a whole lot. So we'll be able to show you births and deaths, the demographic and housing profiles. I actually think we'll be able to get down to block group. Hospital discharges. So if you wanted to look at asthma hospitalization rates for, or ER, let's say ER admissions for asthma, against pollutant exposure for respiratory risk pollutants, you'd be able to do that if you wanted to see kinder readiness against elevated blood lead level. So you'll be able to grab data for a demographic group like if you only cared about teenage Hispanic females, you could do that. Or if you only cared about zip code 78207, you'll be able to pull all that down. We expect that to come online in mid-December. So again, if you want to stay updated, join our mailing list and you'll know when that's coming. And there's a narrative description here if you want to read more about community view. Do you have questions on our site? We've got a lot of stuff up here, and yet I know that whatever you go looking for will not be there, because that's the way it works. Who do you contact? Because it is an early learning firm. Yes. Anyone who has a community tool is designed in San Antonio. It's the US Department of Ed is looking at this. It's probably one of the key reasons we've got the props and the grants to be able to do this. But everything that community information has been able to do is whether it's for voices or for promise or whatever. They make it available to the public and the whole community. The whole purpose is to give every tool that they make and create, make it available for all of us. Yeah. And importantly, it's free. So two things about how to give us feedback. We have what I call the nine second survey. There are three mandatory questions and several other optional questions about usability of this site. So if you have a chance to play with it and you have good or bad things to say, please take our usability survey. I'm going to go here to contact us, and here is our email address. And you also have, I believe, Stephanie's email address from, and maybe Celia's as well, from coordinating registration for this. So we're happy to help you however we can. We would prefer to figure out what people's needs are and address them in trainings like this to the extent that we can rather than one-on-one.