 So everybody, again welcome to Mapping Philanthropy, how to use data visualization to do good. This webinar has been co-sponsored by us here at TechSoup and as well as the Foundation Center. We'll be talking a little bit about them near the end of today's presentation. So my name is Kyla Hunt. I'm going to be your facilitator today. I am the webinar program manager here at TechSoup Global. Now with us today is Jake Garcia and George Ford, both from the Foundation Center. Jake has worked on GIS projects for NASA, the U.S. Army, the City of New York, and Al Gore's Climate Project. And at the Foundation Center he built mapping applications, data visualization, semantic analysis scripts, and APIs. And in April 2011 he was the lead developer on a project that won the Large Organization Award in the World Bank's Apps for Development Contest. So that's really, really great. We're so excited to have him here with us today. And as we also have George Ford from the Foundation Center. And he's been with the Foundation Center since March of 2004 and as product manager for online subscription services, including Foundation Directory Online, which we'll be hearing a lot about later on in this webinar. He's responsible for the day-to-day oversight and the development of new product enhancements. So we're really excited to have George with us as well. And assisting with us on the back end is going to be Becky Wiggins from TechSoup. So you will probably see her name pop up in the chat pane. And just as a reminder, before I give control, before we do a little bit of polls that you will be muted throughout today's session. So if you do need to ask any questions, you can type those questions into the questions or chat pane, and we can respond to you there. And we will be reading questions out loud as time allows during the questions break. And so a little bit about today's agenda. Jake is first going to be talking with us about just visualizing philanthropy, data visualizations in general, and some different resources that are out there. And then George is going to be talking about the Foundation Directory online and giving us a little bit of a tour of that. And we will be handling questions both between the presenters and then at the end. And if we don't get to your question, we will be forwarding to the presenters to follow up with you afterwards. And so with that, we do have a poll question that we wanted to ask just before Jake got started. So let me go ahead and launch that. And this first question is how many of you currently create data visualizations? And so I'll give you guys a couple of minutes to answer that. And this is going to help Jake a lot in preparing his presentation and to knowing who he's speaking to. So I'm going to give you about five more seconds. It looks like 75% of you have voted. So I'm going to close it in five, four, three, two, one. So I want to go ahead and share those results with you. It looks like just 15% of you actually currently create data visualizations. And 51% had never created data visualizations. But at the same time, 51% are still looking into creating data visualizations. So hopefully that really helps Jake in knowing who he's speaking to. So thank you for answering that question. And we will also have another poll question before George's section. So with that, I'm going to go ahead and give Jake control of the screen. So Jake, go ahead and take it away. Great, thank you, Kyla. Let me just launch this. Hi, I'm Jake Garcia, a geographer at the Foundation Center. I'm going to show you guys a few visualizations that we've built over here and show a few other mapping tools and visualizations that other folks have created on the way. Talk about a little bit about our data, where it comes from, and what kind of stories that it tells. First of all, the Foundation Center is a leading source of information about philanthropy around the world. We've got information on 105,000 global foundations and other donors. And we have a database of 4.6 million grants. And that's grants that they've given across the last couple of decades. We do lots of activities. And George later on, George Ford's going to talk to you about Foundation Directory online. I'm going to show you a lot of the stuff that we do that's open to the public. But we do lots of research reports. We give advisories on giving trends, build special mapping tools for clients that say a foundation might hire us to do something. And sometimes we do issue-based portals on topics that we think are relevant and interesting. This part might be a little bit boring, but it is important for the kinds of things that we show is basically where our data comes from. A lot of our data, the majority of it about foundations and grant making, comes from this form, there's a little sample here called the 990-PF. Foundations have to file it every year. And they describe the grants they give to nonprofits in the US or abroad. We start with that basically, and then what we end up having to do is curate the data. So sometimes it's not machine readable, so we have to basically do OCR in order to get the data out of it. But then we've got folks here at the Foundation Center, about 40 of them, who basically just clean and code the grants. So Taxonomy has 1,100 codes. We also code it by recipient type population. And all of this basically means once we have clean, thorough, interesting data, we can then start doing some interesting things with it. So the goals for visualizing the data is to show the flow of funding to NGOs. And the second point, though, is the most interesting. Basically we want to try to identify the places where funding might be overlapping or where there are gaps in funding, and I think another important side part of that is finding the potential for collaboration, either between nonprofits or between foundations. Now every once in a while I'm going to show some links to things, and hopefully when you guys get this presentation available in a week, you can go back and actually look these up and click on them. But a very small sampling of some open data sources that you can use to help put stuff in context. The World Bank has lots of great international data. The US government has lots of good data about the US, and there's a lot of mapping data stuff here. Again, this is just for reference. And then I'll talk first one second about some of the problems with the data. Sometimes we don't have complete grant descriptions, or we don't exactly know where the grant's going to, or sometimes the flow of funding is not easy to describe. And on the right there, the image you see, there's an example of a grant record. It's from the Dow Chemical Company Foundation to Blue Planet Run Foundation, but there's really not much in the way of description, and it's a global program, so it's hard to map, it's hard to do anything with that. However, it's not always the case. Again, this one might be for reference, but sometimes in data visualization, one of the problems that occurs is that anytime you see two things in the same place, you might think they must be related to each other, or one must cause the other. That's not necessarily the case. Again, this is kind of a nerdy geographical kind of thing, or statistical kind of analysis, but it's very important to know that sometimes when you're reading a data visualization, that what appears to be one thing leading to another is not necessarily the case. And here are a couple of references at the bottom. There's a great book called How to Lie with Maps. It's a very short book, but it's really handy, basically saying that maps have to lie because they can't represent the whole entire world perfectly, and then there's a toughy book. If you guys have heard of him, you should definitely check him out, and he gives presentations around the country every year. But his books, especially the visual display of quantitative information, are fantastic guides, and there's lots of rules of thumb in those books for creating data visualizations. So I'm going to show a few of our visualizations now. This is one case, it's just called the Time Slider, Foundation Time Slider. It's available on one of our sites called GlassPockets.org. And the bubbles represent the amount of assets for all the foundations in each of the 50 states. You can see California and New York there are pretty big bubbles. That's where a lot of the big well-undowed foundations are located. And the color of the bubbles shows the increase in the assets of those foundations from the previous year. So in this case, all of them are blue or light blue, which means that, if you look in the key on the right there, it means that for the most part, assets went up in those foundations in those states by over 15%, which is pretty dramatic. And this is 1997 during the Clinton era before the dot-com boom, but this is when everything was looking pretty peachy. In that same application, you go to 2008 at the beginning of the housing crisis, you see everything as orange you read. That means that their assets dropped by over 15%. Those are the only two years across basically a 40-year period where we saw a nationwide trend in foundation assets. We did not even actually realize that this story was this dramatic until we actually saw this visualization. So it was one case where we built the visualization, then found some conclusions, not the other way around. We didn't know the conclusions and then saw visualization. We're also building something right now. This can be our open data portal. And I personally am a big fan of very simple visualizations. And this one's a little bit ugly, but I do like how simple it is. It's just a line chart. In this case, it shows that funding to recipients in New York and California over $2 billion a year, and they're pretty much in lockstep, which is interesting. Look at 2001, how close they are, and they diverge a little bit by 2008. But places like Michigan and Texas, nonprofits receive typically less than the nonprofits in California and New York. And here's one just showing some of the categories of funding in New York. And again, this is for recipients in New York State. Arts and culture is extremely well-funded in New York and look at science there, basically toward the bottom. It's not a trend that reflects across all the states, but we do find that arts funding in New York is extremely high, whereas agriculture and science funding across the board tends to be relatively low or then we would have thought. Sometimes we also build these special issue portals. And this one is one we built at the request of the Kellogg Foundation about grants to Haiti. And we'll see a little bit more about Haiti in a few minutes. But basically what we're trying to do, and each bubble represents a number of grants that went to different places in Haiti. And this is of particular interest because of the earthquake that happened there recently. So you can see that sometimes, like the bubble in the middle of the ocean, you can't decode a grant someplace because you don't exactly know where it went. But in other cases, you see an 89 there, 64, a few other things. There are some foundations that are spending money on nonprofits for specific projects in specific locations. For instance, that 64, which you can see in the middle, most of that is to one hospital in that area. And basically what you wanna try to do is find some trends here. And here I clicked on this application. By the way, this is that you can see at the bottom, this is foundationcenter.org slash Haiti. You can narrow it down by all these different categories, so these blue categories. And basically it says, yes, a lot of money was spent on these other categories, but we go to the next one. We've included safety and disasters, and you see the yellow bar there. Basically these safety disasters made up $326 million out of $347 million in funding. So basically Haiti doesn't receive that much in funding typically, but then something like a disaster occurs, then all of a sudden, lots of money will come in. And basically only one shot, only one year. I mentioned earlier one of the purposes of doing stuff like this, the visualizations is to make an argument. Either you wanna either discover something about the data, or you wanna help make an argument to someone else to show them something. In this case, this shows World Bank projects in kind of Greenwich Gold and foundation projects by the amount of money. In 2003, 2005, and 2007, and World Bank spends a lot more money than foundations do typically. We'll see a little bit more in a second about World Bank stuff. But in this one case, it's just one obvious one, the arrow is pointing to Angola. Angola didn't receive any money for fishing and agriculture and forestry in those years from the World Bank, nor did any foundation spend any money on Angola. In fact, I've seen that a lot, particularly for Angola, not very much funding goes there. Now, that doesn't mean that it's being neglected necessarily. It just means this is a good starting point for trying to dig deeper. That asks the question, why isn't any funding going there if they have a need? One of the things that we're most proud of right now is a new site that we also built called washfunders.org. And this is live and it's freely available to the public. And this is the map that's on that site. And we're trying to, basically the Hilton Foundation asked us to build this because they wanted to find out all the foundations that are working in the water and sanitation and hygiene sector around the world so they could collaborate with them potentially and see where there are trouble spots and see where there are gaps and see where there's overlaps in funding and where they can collaborate. Where it's on the map, where it's Yellowish, it's basically where we used World Bank's API to get the data. Where it's Yellowish, it means that access to water, just to clean water in those countries is relatively low. So in some places like 40 or 50% of the population has access to good water. Whereas the bluer countries like in Europe or Canada, United States, access to water is about 99 to 100% of the population. So parts of Africa, parts of Asia, parts of South America, basically the developing world are suffering, experienced a lot of problems with access to water and sanitation. And in the purple bubbles, the slightly bigger ones are in some of those African countries. Now what I did here was combined the purple bubbles, which is our data at the Foundation Center. The coloring of the countries is from World Bank data, but then you got these Yellowish bubbles and those represent OECD funding. And OECD is the Organization for Economic Cooperation and Development. It basically represents the World Bank and the big donor countries like Sweden and the United States and the UK. So basically it shows the Yellow bubbles are almost always much bigger than the purple bubbles. Basically, and they cover almost every country. So foundations are a part of this puzzle, but only on the small part. Then you can click on a country and get a profile and you can see by the bar charts here. Again, I really still really like some of these simple visualizations. The purple bars, about $10 million a year given from foundations to water projects in Kenya. Look at the second chart at the bottom. It's really no comparison. About 2008 and nine, it's $100 million a year from the large donor countries. So if we actually put the foundation funding next to the OECD funding, the purple bubbles would be too small to be displayed here. So that's why I split them out. And then you click on it and you get some grant records and you can find out who exactly is operating in those countries, what the names of the foundations are and descriptions about the projects. This helps foundations find each other. Some of the next things we're doing is basically we're gonna be coding things to an international standard, the International Aid Transparency Initiative called EATI. And we're gonna be working with the World Bank to set up some geocoding standards so that we can build some more applications that combine this because we wanna find out what's happening all around the world. And here's one example. The gold bubbles here are World Bank projects in Haiti and the blue bubbles again are the Foundation Center projects. Left side is the navigation for our subjects and the right side is the subject navigation for the World Bank. And this is just a prototype right now, but what we wanna start doing is add every single countries, like the Sweden's and the United States' projects in Haiti because after a disaster like what happened in Haiti recently, the world found out, nobody knows what's going on the ground. The United States doesn't know what the UK is doing in Haiti. Foundations don't know what the other ones are doing and then you got folks like Sean Penn coming in there running their own operations. It's just a, there's just such a wide array of actors. What we in the World Bank wanna try to do is say, can we collect everybody together and find out what the total story is? I'm gonna breeze through a couple of other things to the resources that I think are really interesting. If you go to maps.worldbank.org, there's some other examples. This one is Mapping for Results. And this shows World Bank projects by type a project and where the projects are. And so there's a pie chart there on the right that's also showing the breakdown. This shows how active the World Bank is in India and it's a very good example. It's a very elegant way of navigating around and finding stuff and I like this application a lot. This is also actually, this might not be mapped, this might be data.worldbank.org but regardless, this is like a kind of a panel, a multi-panel thing where you can, you see lots of little visualizations. Some cases they might be called spark lines if they're really tiny but it gives you a little dashboard summary of lots of stuff about Uganda in this case. You can see that their debt might have gone down. You might see the education has kind of gone up and then flattened out a few other things. I think this is a great example of getting a quick snapshot of something. This one is aiddata.org and it is also kind of in cooperation with the World Bank but it also shows projects from other entities, other big donors in Africa. And then below that the kind of modeled color I believe is, I can't remember what I'm talking about but I think it's showing rainfall. So it's kind of a mashup in a way but it's a very important one especially if you're covering things like water or agriculture. And this one is not, this is from data, this is from the United States government. It's not a very pretty map. It doesn't really show you anything like truly fascinating but this is something that the Foundation Center does even track. So I did a quick search and found this. These are, these bubbles basically show funding from the United States government for folks who want to teach American history. So these are grants for foundations. These are grants from the United States. It's something that we want to start tracking but it kind of tells me a story in a way. Of course we know there's a concentration in the Northeast and the Southwest because of population centers in Chicago but there are a few other ones out there like in Montana, a few other places sprinkled around. This one again is for reference. This is a list of the different types of utilities and tools that can be used. I use almost all of these on a regular basis. This would be for reference to get people started if anybody's already doing visualizations might be kind of boring but this might be a good reference when you're starting to look at applications for your own use. And so I got a couple of minutes left. I'll just go through the final takeaways. The Foundation Center has a lot of data on US international philanthropy and a lot of it's gonna be available soon through APIs. We've got a lot of free products and some of it is we're trying to make it cooler and cooler and have more and more that's available for free and it's, we've got a lot of data and a lot more coming. Second and this is an important one is that good visualization basically requires you have to curate it. It's not just not just gonna find data and have it magically be able to create visualizations with it and make a convincing argument. And lastly, and this is my most important one is is it accurate when you look at the visualization and when you create it? Does it help sustain an argument? If you're not exploring the data and you're showing the data you wanna show something to meet the argument really clear and ultimately did it help make a decision? If a visualization doesn't help you make a decision then it just becomes something cool. You go, wow, that's awesome. And then you go away from it and you realize you didn't really learn very much from it. I've seen a lot of those and I don't remember what they were trying to tell me. So simple is good and does it help someone a decision maker make a decision? And that is it. This is my contact information. Anybody can feel free to email me and if there's any confusion about the links or resources or anything please feel free to ask me. Okay. Thank you, Jake. That was a lot of really great information. Oh, sorry. No, it's great. So I'm gonna take a look to see if there are any questions that have come in. It looks like Rebecca had a couple of questions. Their first one, and you know, this is just good background information is what does API stand for? Oh yeah, sorry. APIs are application programming interfaces. Basically means web services. Basically a way for you to get information directly online using a URL instead of having to go to a website and downloading an Excel file, you'd be able to type in a URL with some parameters at the end of that URL into a browser, let's say, and get just, you know, the raw data. Okay, great. And you said the second, the P stands for programming, correct? Yes, application programming interfaces. Yeah, it just broke up just for one second. Oh, sorry. Oh, that's not your fault. And then her other question was she was saying that these international resources are really helpful, but are there any resources that break down funding by category, by state, or presumably the United States? There are, we actually, George Ford is gonna talk next about Foundation Directory Online, and there's a ton of stuff broken down by category in the United States. In fact, Foundation Directory Online is what's focused most on the United States, and a lot of our open data and stuff I work on is international. So I think the next segment should answer those questions. Okay, great, thanks. And then we're having a bunch of other questions come in. Bill is wondering, do you have any suggestions for a startup nonprofit, I'm assuming in creating, or using data visualizations? Yeah, you know, I hate to refer people to Google, in a way, but they have a lot of very easy APIs and data visualizations that you can use for the web. It's a really good start, and they make it very simple to start doing. The easiest case would be doing something in Excel, creating some charts and then just taking those images and putting them into slides. But for the web, I would suggest starting with Google's APIs, and then in the charts, and if you guys are still seeing my screen. Here we are. Go up several, this one, this slide has a bunch of stuff, some of them are more advanced than others, but Google charts and high charts on the lower left, high charts is excellent. Just need to know a little bit of JavaScript in most cases. Okay, great, thank you. And Melissa was wondering, has data visualization been used to show funding gaps? Yes, it has, and sometimes it has to be intuitive in a way, like it might not be obvious, I'm flipping back, back, back. Let's go to this one here. We can see, and I'm gonna escape out of it a little bit, if you can see where my mouse cursor is. If you look up here to Algeria and Libya, if you guys don't know if you can see my cursor, but up here there's a need for water access, but there's no funding. Afghanistan and Iraq, foundations aren't operating there right now, it's basically a war zone. There's parts of Southeast Asia here, basically where you don't see bubbles there and where it's basically yellow, where the country is yellowish and where there are no bubbles. That's where you start figuring out where the gaps are. Okay, great, thank you. And we're having a lot of other questions. I'm gonna take maybe two more questions before we hand it over to George and the rest of the questions that are coming in, we will handle after George's section. Kathy has a very specific question. She says that she's trying to get funding for the development of a small fishing village's hospital. And her group traveled to Daemarie to do surgery for one week. They plan on having a permanent presence there. They need to build a mission house, woman's center, water source for the town, et cetera. So she was wondering if you had any recommendations of a site for her to look at. She said that your map show no money has gone to the area in Haiti, so that was helpful to my argument. Yes, if it was, and what country again was it she's looking at? I believe Haiti. One more question? Haiti? Oh, it was in Haiti. Oh, no, great. Well, our, that site, which I'm gonna update very soon, World, sorry, foundationcenter.org slash Haiti. We'll have some of that information. Other resources, I would suggest emailing me and I could put together a list because some of it I had to kind of vet to make sure we specifically talk about that. There are lots of great sites that have information about different parts of the world, but not all of them have all parts of the world covered. So I need to do a little bit of research on that. But for finding funding sources, basically that site I referenced earlier is the best so far. Okay, thank you. And just so everybody knows, you can see we will be sending out the presenters' emails and the follow-up emails. So if you don't get a chance to jot that down today, you will still have that at your availability. And let me take a look. And then Danielle is wondering, when creating visualization, what types of software do you recommend? That is, we're going back to this really boring slide here with just this grid. I'm a big fan of open source. So I typically start with open source and or free. If we look here at these, for mapping, I love open layers. It's great and it's free and it's open source. Esri is fantastic, but it costs a lot of money. So I would suggest if you wanted to get into web mapping, I would say JavaScript as the primary web-related language. I would say open layers for mapping, and I would say high charts for charting. Those are the ones that I use all the time. If you're into statistics, I would say some of these desktop ones are pretty good. If you want to do just desktop mapping, you could do like Udig or QGIS. Some people just do it in Photoshop and Illustrator or Excel and just kind of have an image and post that image online. That's the easiest, simplest way. But by far my favorites are high charts and open layers. Okay, great, thanks. And Becky from TechSoup just chatted in just to remind us that Esri is also available to eligible non-profits through TechSoup's donation program. So we'll send that out. That's a good recommendation. That's how we get that. We actually get a discount through TechSoup for Esri stuff also. Yeah, exactly. So we'll send the link out about that in the follow-up email as well. So everybody has a chance to take a look at that. So with that, what I wanted to do is I wanted to go ahead and ask one additional polling question. Any of the other questions that have come in, we will take a look at after Georgia's section, but I do want to make sure George has time to provide his rundown on the Foundation Directory online. So really quick, before I get control of George, I'm going to bring up one additional polling question, which is, do you subscribe or have you subscribed in the past to Foundation Directory online? And you can select I currently subscribe, I subscribed in the past, or you have never subscribed. So I'm going to give you just a few more seconds. Looks like about 58% of you have voted. And of course, if you are not familiar with Foundation Directory online or don't know what it is, we will be talking about that in just a couple of minutes, but you can select I had never subscribed in that case. I'm going to give you five more seconds. Five, four, three, two, one. And it looks like 22% of you do currently subscribe. 12% have subscribed in the past and 66% have never subscribed. So I think this would be a really illuminating presentation to find out a little bit more about Foundation Directory online. So everybody, thank you for sharing your information. And with that, I'm going to go ahead and give control of the screen over to George. So George, go ahead and take it away. Okay, well, hello everyone. I'm George Ford, I'm the product manager for online subscription services here at the Foundation Center, including Foundation Directory online. And I'm going to be discussing how sort of pivoting here from some of the work that we as an organization do to show the reach of philanthropy and the impact of philanthropy through data visualization tools over to how a grant seeker, how a grant seeking organization can use some mapping and charting features within our, from your grant seeking product to help them in the grant seeking sort of prospect development process. So it's one data point among many in answering the question is this a foundation that represents a good likely funding prospect for me. And first a little overview of what Foundation Directory online is. Those of you who already subscribed know some of this. It is our database of over 100,000 grant makers. These are US based private foundations as well as corporate giving programs and grant making public charities as well as their grants that we have over, the actual number right now is over, it's almost 2.8 million grants. These are grants made going back to 2003. And it's already starting to include some 2012 grants. We do, as Jake was saying earlier, the data is based primarily on the 990 PF. We do have some, or many really foundations to submit to us their grant data electronically. So we're able to sort of keep ahead of having to wait for the next set of 990s to be released by the IRS. So you can search grant makers, you can search that set of grants at the professional level of Foundation Directory online, which we'll be talking about today. You can also search a database of sponsoring companies and you can have a keyword searchable database of 990s and 990 PFs as well as power search, which lets you search across all of those databases and several more at once. You can save your searches and tag different records. You can export results list. We'll take a look at some exporting to spreadsheet features when we look at the maps. See detail funder portfolios, including the maps and charts that we'll be looking at and including the grant maps and grant charts. These last couple of things I mentioned are available at the professional level. And at this point, I'd like to point out that Foundation Directory online is a subscription product. You know, there's available several different plan levels with the price associated with them. But in addition to that, so this isn't too sales pitchy, FDO at the professional level is also available to use for free at our own libraries. We have five of them, New York, Atlanta, Cleveland, Washington DC and San Francisco. It's also available at our network of cooperating collections, which is I think at this point over 450 libraries and other organizations that carry our set of core products, including FDO. So you can use these features for free at any of those locations. The maps and charts we'll be looking at, you'll see where we have grants indexed from a funder going back to 2003. We map and chart them and you can drill down and explore with a few different variables and work with the data a little bit. You can view by year grant subject or recipient type. You can drill down to different sub levels on the map or the chart. And then finally get to the point where you can actually view a grant record and get a little more of a story of what the funding was and what it meant for. There are several tools available, including just making simple images from these for later reference, generating PDF copies. And most valuably of these three is exporting the tabular data. So you can work with that. And with that I'm gonna switch over to take a look at Foundation Directory online. So we can take a look at how we get access to this data and working with it. So this is the power search screen that we were looking at earlier now for this. All of these maps and charts are available at the grantmaker level. So you're gonna get to them at first by searching for a particular grantmaker. And I don't wanna get too bogged down in all of the ways you can set criteria. I wanna do a fairly basic search so I get a good large set of results. So I'm gonna start in the field of interest area and I'm just gonna look for this field of interest. Tell me these are things that the funders are interested in funding. And I'm gonna look for a nice broad category which is arts grants. And I also wanna know, okay, well, where do they direct their funding? Where do these grantmakers direct their funding? So I'm gonna choose California because let's say I'm a California based nonprofit. I wanna know who funds there. So I wanna choose California. But I also wanna go ahead and select national for funders, particularly larger funders that give nationally which can include California even if they don't specify. As you can see here at the search grantmakers level there are many other search criteria available to you. Grantmaker location, types of support. You can look for names of trustees, officers and donors and different types of grantmakers. Rain searching. If anyone has quite general, because we're focusing just on the maps and charts if anyone has general questions for me about using the application and what's available and how to search it, my contact information will be up at the end of the presentation and you can get in touch with me directly about those more general questions about the product. For this though I'm just gonna take this basic search and just sort it by total giving and when I get my results I'm gonna take a look at which funder I'm more interested in learning more about. I'm gonna go ahead and select the Ford Foundation and this is their funder profile. This is where I can find out everything I need to know about who to contact, about application information, background, any limitations on their giving, who's on their board, what staff do they have, what key staff, some selected grants and other information germane to the grant seeking process. I can access, I can learn more about their grants several different ways. The first is very simply I can search through them using this tab of the profile. I can list all of them or I can specify by certain criteria but to get sort of the main events I can also skip that step and just see those grants displayed on a map and Jake was speaking earlier about sort of the clarity of simple visualizations and these maps while you know not the most high tech or elaborate do I think a good job of telling that or giving that simple information in a relatively clear way or important information in a clear way. In the map, the US map you see here it's a simple shading that the shading represents total grant amount and obviously the darker shades of blue are states where more grant money has been provided by this foundation. I can see the aggregate information at the top above the map. Everything that we have indexed for the Ford Foundation 9,000 grants going back to 2003 for over $3 billion. And if I wanna learn more about that I can see two ways. I can look at the table below that and see each state or district what's the amount, how many recipients and how many grants. If I wanna get a snapshot of that as well just by pointing at any of the states on a map I can see that aggregate data state by state from the Ford Foundation just by viewing that. Now, the search I conducted was specific to our grants. So these are all their grants. I wanna specify I wanna be a little more closer to what I was looking for so I'm gonna select arts and culture from this recipient type menu on the left. You also have the option of viewing the same map by primary grant subject. A word about that distinction, it's essentially the same taxonomy. It's how we code. In the case of primary subject this is how we code the grants that has been given. Recipient type is again mostly the same taxonomy but it's how we've coded the recipient organization. So it's your choice whether you're interested in seeing I wanna see all the arts grants or I wanna see all the grants to the arts organizations. Whichever it is that's your priority you'd make that selection. And let's say I'm an arts organization of some sort in California. I wanna know what's been given to organizations like mine so I'm gonna choose recipient type. I can copy this map. I mentioned the tools earlier. I can create an image. I can print and save it in PDF form. I can also export that data to spreadsheet. So I've just clicked that export link and that should open for me a spreadsheet. Nope, there it is. I just need to open it. And that's gonna give me a table of data that I can then slice and dice and do whatever I would like with. At the top I can see if I save this and wanna share it with colleagues I can see at a glance what it is. These are Ford Foundation grants. This is the total grants amount and number of recipients and number of grants that are represented here in this table. These are the parameters that I narrowed out to. And I can see all the states and the grant amounts, recipient and grant counts. So let's drill down now to California which is the state that I'm interested in. When I do that I get a new map. Again, I can create the same spreadsheet but now with just the California data. I can also view this data. I have a few choices. Right now by default I'm looking at it by county. Again, I can see that the totals and the number of recipients and grants I can also take a look at the same data by city. This is zip code. And then most recently we added congressional district which is gonna be a fun project for us. We'll be having to redraw these maps to represent new congressional districts in several states. But we are aware that that project is ahead of us. But you can view grants by congressional districts. So let's go back to county. And if I select a particular county to learn more about what was funded there now I get to my list of recipients. And at every step along the way here I can see the summary of what I'm looking at. I could also have some breadcrumb links here so I don't get lost. I can jump back to whatever map I'd like to look at. And I can re-sort this. It's by default it's sorted by which recipient has received the most in funding. I can also take a look at which recipient has received the highest number of grants. In this case it's the Sunday Institute. If I select them here are all their Ford grants. I can look at the newest one first. See what I'm doing there? I'm just clicking column headers to re-sort. And then lastly I open up a grant profile, a grant record and I can see all the data that we have available to share with you about this grant. Recipient information, their URL, how we've coded them are the type of recipient codes. These media film video and media television codes are subcategories of arts and culture which is why this came up in my results as well as the recipient in my 90s. Information on grants including a description of grants. That description isn't always available. It's very nice and very helpful when it is and when we have it and we can share it. The grant subject codes. And because we're already in the other screen looking at the full grant maker record, all we have here is just the very basic grant maker information. But that's the good example of a typical grant record and what you can find out there. And again, just one way of accessing that is using the maps and charts. There are other ways including just conducting a grant search, conducting a grant maker specific grant search or using the charts that we're going to look at in just a moment. I wanna go back to my first screen just to point out that we also have while foundation directory online at the moment only contains US based grant makers, we do have the grants that they have made to non-US recipients. And if that's available for the grant maker I'm looking at, I can just select world map and then I can see the US grade out. I can see all of their grants or grants that they've made around the world. And in much the same way as in the US map I click to drill down, in this case you just go we don't have sub levels within the country level internationally so when you click a country you go right to the recipient list and then as I demonstrated a moment ago you can go right into the grant record from there. So those are the grant maps. Now you will have noticed in that demonstration that as far as the type of recipient or subject code I can only go as deep as that first level category arts and culture. But if I wanna learn more about grants made to organizations that are like my own I probably wanna be more specific than that at my museum, at my dance troupe, at my orchestra. The charts that we're looking at now will allow you to do that in much the same way of drilling down to sub levels. Again I can look at just certain years. Again I can see all of the aggregate data I can export this data to a spreadsheet. But if I select arts and culture that set of grants that I was looking at on the map now I can drill down from that category and see some of the subcategories and start getting a more specific story about what sorts of organizations are funded. Media and communications, like the one that we looked at the record that we looked at for Sunday Institute would be somewhere in this set, this media communications set. But let's take a look at the performing arts and now I get a third level. I can see the table of these different third level categories as well as the aggregate counts and dollar amounts. And if I go one level deeper, one more drill down now I have my recipient names. Just like in the table we were looking at a moment ago I can re-sort by grant amount or grant count. Because as in the other use case that we started with as I'm based in California. So I wanna look at the locations of these recipients and maybe find California-based organization. So here's one, it's located in California. It's the Cornerstone Theater Company. They've received three grants from Ford, totaling $345,000. And I can see all of these grants. The most recent one was from 2010. And just like from the map view I can go right to that record and see what this grant was for, learn a little more about who Cornerstone is, what they do and the purpose of this grant, what kind of work it was funding. Also the duration of this grant, in this case it's a multi-year grant it was for a year and a quarter. That's an overview of what you can do with the grant maps and charts in Foundation Directory online at the moment. I wanna talk just for a moment, I wanna leave some time for all of the questions and answers we have on both parts of the presentation. But I do wanna take a minute to do two things. And the first, if I go back to my slide presentation, is tell you about something that's kind of around the corner on the horizon for Foundation Directory online. The maps that we were looking at in our example were all of the data is based on where is the recipient organization located? As all of you in the nonprofit sector know, the location of the recipient isn't always the same as the location of the audience that's ultimately served by that grant money. And we're hearing that there's more and more of an appetite to know, okay, it's fine that the grant went to this organization in the city but they're serving populations in all of these areas. I wanna know who's been helped by this grant, I wanna know where those people are. We're planning on adding us this year to these grant makers specific maps and chart or to the grant makers specific maps, the geographic area served data. What you will be able to do is toggle between the recipient view that we were looking at a moment ago and a geographic area served view. And in this, it's not exactly a mock up, it's a live thing, but it's the current iteration of what this prototype looks like. You would see the same shading in countries and if you were to go to the US level, you'd see states just like we saw. But you'd also see these sort of bubbles and those represent regions, different regions such as such as in Africa or global programs or at the US level, there'll be some US specific regions like mid-Atlantic or New England or whatever. So you can view the data at this sort of hierarchical state city level or you can look across different regions and see the population served by that grant data. The other thing I wanted to take just one second to do is go a little off the board because I wasn't initially part of the presentation but I thought it was relevant, particularly to some of the questions that came up earlier about identifying need and response, couple of the questions that were asked to Jake. We have a completely separate product, it's called Philanthropy Insight. The audience for this is primarily grant makers but it's also very useful for research, just general research in philanthropy and that's what this is designed to do is to tell that story. You can plot on this map a few different things. Where grant makers are located, where recipients are located, coming soon down the line also the geo area serve that I was speaking of a moment ago and then also data on demographic indicators and filters like that identify areas of need such as unemployment or poverty. So on the same map you would be able to see where is there a high level of poverty and where are there grants going that are specifically intended to address poverty. You'll be able to see that in one glance and tell the story that way. If anyone is interested in learning more about philanthropy insight, you can get in touch with me and I can put you in touch with the product manager for philanthropy insight. So that is, I guess we have a good 10 minutes or so left, that is using maps and charts and foundation directory online and a very quick introduction to philanthropy insight and with that I think I'm happy to take some questions about any of what I was speaking about. Thanks George, I really appreciate that. I'll leave your screen up for just a couple of seconds so people can jot down your contact information if they need. We have had a lot of questions come in. We've had several questions just asking about the pricing again in general and how to get to the libraries and the cooperating collections. I did put a link to the cooperating collections in the chat box and we'll be sending that out as well but I don't know George if you want to just touch on that really quickly again. The screen I'm sharing now is, one of our sites is called Grantspace. It's our hub for anything and everything useful to our non-profit audience, training and a lot of other things. Part of what's included here is a way to access or way to find the nearest cooperating collection to you. You can search by zip, browse by certain states and you can find the nearest cooperating collection or foundation center library. So you can see the URL here at the top, grantspace.org slash find us and you can find the nearest cooperating collection or foundation center library. As to pricing, for what we were looking at in Foundation Directory Online, that's available at the FDO professional level. Pricing for that ranges, it's available monthly annual or two year basis. Monthly, it's $179.50 per month, $1,295 per year and I believe the two year price is $3,600. Those are all for single user, there's additional rates for multi-user subscriptions and we also have a separate model called institution wide access. That's basically IP authentication for, for example, a university campus could have site wide access and the pricing varies pretty widely and it's based on your FTEs. So there are a lot of different, there's a lot of different prices for a lot of different plan levels and if you're interested in more about that you can contact me directly and I'll put that, put my contact information back up. Okay, thank you, George. Alexandra had a question specifically for you as well. She was wondering, what does the category selected grants contain? Selected grants on the main grant maker profile, it's a set of grants that the grant maker has provided to us that are recent and that they feel are representative of what they do. Not every grant maker provides us with one. But if they do, we can post it on that main profile screen. What that allows us to do is, if we haven't indexed and coded all of their grants from their 990s or for example, it's a corporate giving program that doesn't file a 990 PF. So they don't, their grants are all itemized and open. It gives us at least, at a minimum, a snapshot of the grants that they've given. For the example we were looking at with Ford, the selected grants, while useful, aren't as useful as just, you can look at all or just about all of them. You can look at, you can search the grants and look at the map and view much closer to the whole set of their grants. But it can be particularly valuable if you're looking at a smaller foundation and they said, here's a set of 10 recent grants and this is what they are. We can post that on their main profile screen. Okay, thanks. And Troy was wondering, why don't organizations break costs down by the non-profit's income? And I can forward you that question later if you want to look at it. I'm not quite sure that I, I'm gonna have to mold that one because I'm not quite sure what it is, but I'll get back to the person next to it. Yeah, great, thanks. And just so everybody knows another, we do have a lot of questions still out there and we only have about three minutes left. So I'm gonna just take probably a couple more questions. Anything else that you asked, I will be forwarding those questions to the presenters and they can email you back and I put their email addresses if you don't get a response within a week or so. You can enter or if you have any additional questions. I'm really quick. I'm gonna go ahead and take control back and just show my little questions slide. So I can start that. I did wanna go back to a couple of the questions that we had from Jake's presentation. So let me take a look. I know we had one question that was asking, what is the difference between Google Church and Google Fusion Tables? That's a good question. Google Fusion Tables is basically a way that you can upload your data to Google and Google will take that data and turn it into charts. It's a little bit, there's some other nuances about it and I haven't used Fusion Tables a lot but the thing that I know that the overall idea is that you upload your data to one of Google's servers and then create different charts based on that. In Google Charts you don't necessarily have to do it that way. You can just hand it a small amount of data for exactly the chart you wanna make. Hope that answers the question. Kyla, are you still there? Yes, I am, sorry. My go-to webinar music me for just a second. Danielle was wondering, as a follow-up to her question about software, she was thinking more about Photoshop, Illustrator and design and software like that so she didn't know if you had any recommendations along those lines. Let me get back to her about that because it's a more complicated thing. I mean, send me her email address and I'll answer that in more detail and I'll get more to what she's kinda getting at because if it's for mapping stuff but it's for images like you do in the Adobe products, I would say Esri, ESRI is the best one but there are some that exist out there that can let you do really cool charts, cool visuals that are static like you would do in Illustrator or Photoshop but I can send her a list. I have the feeling she's got something very specific in mind so I wanna try to help her with exactly what she needs. Okay, great. And I'm gonna ask just one more question and this one I believe is for George. He's asking, can you do a search for all the grants throughout the US received by specific national organizations with regional locations? For example, like Boys and Girls Clubs. The maps and charts in FDO are grant maker by grant maker. So you would have to do what we were looking at which is just going by state or going by subject areas as opposed to going by the name of the recipient but if you go to, if you just go to the main search grants tab and we're not talking about maps and charts anymore if you just wanna search all the grants in the database you can search by recipient name and then you can see in your results list all the grants made to whatever organization or organizations that you're interested in. It's just you'd be seeing the list of these are the grant makers and these are all the grants itemized. You can't map and chart them but you can get them as results and then go in and look at the grant records. Okay, great. So anybody, any additional questions that were out there we will go ahead and follow up with you later and then if you have any additional questions that you think of later just go ahead and email us and we will try to respond appropriately. And I do wanna thank both George and Jake for a great presentation today. It's really been a treat. A little bit about who the Foundation Center is. You can see a little bit about them up here and they're a leading source of information about philanthropy worldwide and through data analysis and training they connect people who want to change the world to the resources they need to succeed. And then also a little bit about who TechSoup is which that's the organization I'm from we're a nonprofit organization like so many of you out there and we are trying to provide the technology resources and just technology for you to be able to fulfill your mission and potential. And you can find out a lot of more about TechSoup on the TechSoup ORG website so you can learn you can hear about articles on our learning center you can read blog articles on our blog you can find products in our product donation center and don't forget to go ahead and subscribe to our TechSoup newsletters by the cup and your product donation alert. So with that I do want to just take one moment and think Citrix online for the go to webinar software that has provided this webinar. So thank you to them. And again, thank you to Foundation Center for a great presentation and thank you all for listening today. Please take a couple of minutes and fulfill our fill out our survey at the end of this presentation because that really does help us in creating new and better webinars in the future. So thank you everybody and I hope you all have a great day.