Skip to content

Instantly share code, notes, and snippets.

@mtigas
Created July 9, 2014 22:15
Show Gist options
  • Save mtigas/69736b755e7422204694 to your computer and use it in GitHub Desktop.
Save mtigas/69736b755e7422204694 to your computer and use it in GitHub Desktop.
Examples of the three output formats for the Nonprofit Explorer API: default mode, "output=flat", and "output=noorg". See https://projects.propublica.org/nonprofits/api/
/* Example of "output=flat" format.
* https://projects.propublica.org/nonprofits/api/v1/search.json?q=propublica */
{
"total_results": 2,
"filings": [
{
"tax_prd": 201212,
"tax_prd_yr": 2012,
"formtype": 0,
"pdf_url": "https://bulk.resource.org/irs.gov/eo/2013_09_EO/14-2007220_990_201212.pdf",
"updated": "2014-04-30T16:31:12Z",
"totrevenue": 10955982,
"totfuncexpns": 9884450,
"totassetsend": 4529443,
"totliabend": 119078,
"pct_compnsatncurrofcr": 0.0,
"tax_pd": null,
"subseccd": 3,
"unrelbusinccd": "Y",
"initiationfees": 0,
"grsrcptspublicuse": 0,
"grsincmembers": 0,
"grsincother": 0,
"totcntrbgfts": 10920019,
"totprgmrevnue": 0,
"invstmntinc": 50,
"txexmptbndsproceeds": 0,
"royaltsinc": 17096,
"grsrntsreal": 0,
"grsrntsprsnl": 0,
"rntlexpnsreal": 0,
"rntlexpnsprsnl": 0,
"rntlincreal": 0,
"rntlincprsnl": 0,
"netrntlinc": 0,
"grsalesecur": 0,
"grsalesothr": 0,
"cstbasisecur": 0,
"cstbasisothr": 0,
"gnlsecur": 0,
"gnlsothr": 0,
"netgnls": 0,
"grsincfndrsng": 0,
"lessdirfndrsng": 0,
"netincfndrsng": 0,
"grsincgaming": 0,
"lessdirgaming": 0,
"netincgaming": 0,
"grsalesinvent": 0,
"lesscstofgoods": 0,
"netincsales": 0,
"miscrevtot11e": 18817,
"compnsatncurrofcr": 0,
"othrsalwages": 0,
"payrolltx": 0,
"profndraising": 0,
"txexmptbndsend": 0,
"secrdmrtgsend": 0,
"unsecurednotesend": 0,
"retainedearnend": 0,
"totnetassetend": 4410365,
"nonpfrea": "07",
"gftgrntsrcvd170": 46144525,
"txrevnuelevied170": 0,
"srvcsval170": 0,
"grsinc170": 70024,
"grsrcptsrelated170": 0,
"totgftgrntrcvd509": 0,
"grsrcptsadmissn509": 0,
"txrevnuelevied509": 0,
"srvcsval509": 0,
"subtotsuppinc509": 0,
"totsupp509": 0,
"ein": 142007220,
"organization": {
"strein": "14-2007220",
"sub_name": "PRO PUBLICA INC",
"guidestar_url": "http://www.guidestar.org/organizations/14-2007220/.aspx",
"nccs_url": "http://nccsweb.urban.org/communityplatform/nccs/organization/profile/id/142007220/",
"updated": "2013-04-11T15:41:23Z",
"subseccd": 3,
"ein": 142007220,
"name": "PRO PUBLICA INC",
"careofname": "",
"address": "55 BROADWAY",
"city": "NEW YORK",
"state": "NY",
"zipcode": "10006-3008",
"exemption_number": 0,
"subsection_code": 3,
"affiliation_code": 3,
"classification_codes": "1",
"ruling_date": "2008-02-01",
"deductibility_code": 1,
"foundation_code": 15,
"activity_codes": "000000000",
"organization_code": 1,
"exempt_organization_status_code": 0,
"tax_period": "2011-12-01",
"asset_code": 6,
"income_code": 8,
"filing_requirement_code": 1,
"pf_filing_requirement_code": 0,
"accounting_period": 120,
"asset_amount": 3591151,
"income_amount": 10142780,
"revenue_amount": 10142780,
"ntee_code": "A20"
}
},
{
"tax_prd": 201112,
"tax_prd_yr": 2011,
"formtype": 0,
"pdf_url": "https://bulk.resource.org/irs.gov/eo/2012_08_EO/14-2007220_990_201112.pdf",
"updated": "2013-04-11T16:18:36Z",
"totrevenue": 10142780,
"totfuncexpns": 9651650,
"totassetsend": 3591151,
"totliabend": 252318,
"pct_compnsatncurrofcr": 0.160904,
"tax_pd": null,
"subseccd": 3,
"unrelbusinccd": "Y",
"initiationfees": 0,
"grsrcptspublicuse": 0,
"grsincmembers": 0,
"grsincother": 0,
"totcntrbgfts": 10115367,
"totprgmrevnue": 0,
"invstmntinc": 83,
"txexmptbndsproceeds": 0,
"royaltsinc": 4547,
"grsrntsreal": 0,
"grsrntsprsnl": 0,
"rntlexpnsreal": 0,
"rntlexpnsprsnl": 0,
"rntlincreal": 0,
"rntlincprsnl": 0,
"netrntlinc": 0,
"grsalesecur": 0,
"grsalesothr": 0,
"cstbasisecur": 0,
"cstbasisothr": 0,
"gnlsecur": 0,
"gnlsothr": 0,
"netgnls": 0,
"grsincfndrsng": 0,
"lessdirfndrsng": 0,
"netincfndrsng": 0,
"grsincgaming": 0,
"lessdirgaming": 0,
"netincgaming": 0,
"grsalesinvent": 0,
"lesscstofgoods": 0,
"netincsales": 0,
"miscrevtot11e": 22783,
"compnsatncurrofcr": 1552988,
"othrsalwages": 4522408,
"payrolltx": 331237,
"profndraising": 0,
"txexmptbndsend": 0,
"secrdmrtgsend": 0,
"unsecurednotesend": 0,
"retainedearnend": 0,
"totnetassetend": 3338833,
"nonpfrea": "07",
"gftgrntsrcvd170": 36669506,
"txrevnuelevied170": 0,
"srvcsval170": 0,
"grsinc170": 41334,
"grsrcptsrelated170": 0,
"totgftgrntrcvd509": 0,
"grsrcptsadmissn509": 0,
"txrevnuelevied509": 0,
"srvcsval509": 0,
"subtotsuppinc509": 0,
"totsupp509": 0,
"ein": 142007220,
"organization": {
"strein": "14-2007220",
"sub_name": "PRO PUBLICA INC",
"guidestar_url": "http://www.guidestar.org/organizations/14-2007220/.aspx",
"nccs_url": "http://nccsweb.urban.org/communityplatform/nccs/organization/profile/id/142007220/",
"updated": "2013-04-11T15:41:23Z",
"subseccd": 3,
"ein": 142007220,
"name": "PRO PUBLICA INC",
"careofname": "",
"address": "55 BROADWAY",
"city": "NEW YORK",
"state": "NY",
"zipcode": "10006-3008",
"exemption_number": 0,
"subsection_code": 3,
"affiliation_code": 3,
"classification_codes": "1",
"ruling_date": "2008-02-01",
"deductibility_code": 1,
"foundation_code": 15,
"activity_codes": "000000000",
"organization_code": 1,
"exempt_organization_status_code": 0,
"tax_period": "2011-12-01",
"asset_code": 6,
"income_code": 8,
"filing_requirement_code": 1,
"pf_filing_requirement_code": 0,
"accounting_period": 120,
"asset_amount": 3591151,
"income_amount": 10142780,
"revenue_amount": 10142780,
"ntee_code": "A20"
}
}
],
"max_pages": 1,
"cur_page": 0,
"page_offset": 0,
"per_page": 25,
"order": null,
"sort_order": null,
"search_query": "propublica",
"selected_state": null,
"selected_ntee": null,
"selected_code": null,
"data_source": "ProPublica Nonprofit Explorer API: http://projects.propublica.org/nonprofits/api/\nIRS Exempt Organizations Business Master File Extract (EO BMF): http://www.irs.gov/uac/SOI-Tax-Stats-Exempt-Organizations-Business-Master-File-Extract-(EO-BMF)\nIRS Annual Extract of Tax-Exempt Organization Financial Data: http://www.irs.gov/uac/SOI-Tax-Stats-Annual-Extract-of-Tax-Exempt-Organization-Financial-Data",
"api_version": 1
}
/* Example of "output=flat" format.
* https://projects.propublica.org/nonprofits/api/v1/search.json?q=propublica&output=flat */
{
"total_results": 2,
"filings": [
{
"tax_prd": 201212,
"tax_prd_yr": 2012,
"formtype": 0,
"pdf_url": "https://bulk.resource.org/irs.gov/eo/2013_09_EO/14-2007220_990_201212.pdf",
"updated": "2013-04-11T15:41:23Z",
"totrevenue": 10955982,
"totfuncexpns": 9884450,
"totassetsend": 4529443,
"totliabend": 119078,
"pct_compnsatncurrofcr": 0.0,
"tax_pd": null,
"subseccd": 3,
"unrelbusinccd": "Y",
"initiationfees": 0,
"grsrcptspublicuse": 0,
"grsincmembers": 0,
"grsincother": 0,
"totcntrbgfts": 10920019,
"totprgmrevnue": 0,
"invstmntinc": 50,
"txexmptbndsproceeds": 0,
"royaltsinc": 17096,
"grsrntsreal": 0,
"grsrntsprsnl": 0,
"rntlexpnsreal": 0,
"rntlexpnsprsnl": 0,
"rntlincreal": 0,
"rntlincprsnl": 0,
"netrntlinc": 0,
"grsalesecur": 0,
"grsalesothr": 0,
"cstbasisecur": 0,
"cstbasisothr": 0,
"gnlsecur": 0,
"gnlsothr": 0,
"netgnls": 0,
"grsincfndrsng": 0,
"lessdirfndrsng": 0,
"netincfndrsng": 0,
"grsincgaming": 0,
"lessdirgaming": 0,
"netincgaming": 0,
"grsalesinvent": 0,
"lesscstofgoods": 0,
"netincsales": 0,
"miscrevtot11e": 18817,
"compnsatncurrofcr": 0,
"othrsalwages": 0,
"payrolltx": 0,
"profndraising": 0,
"txexmptbndsend": 0,
"secrdmrtgsend": 0,
"unsecurednotesend": 0,
"retainedearnend": 0,
"totnetassetend": 4410365,
"nonpfrea": "07",
"gftgrntsrcvd170": 46144525,
"txrevnuelevied170": 0,
"srvcsval170": 0,
"grsinc170": 70024,
"grsrcptsrelated170": 0,
"totgftgrntrcvd509": 0,
"grsrcptsadmissn509": 0,
"txrevnuelevied509": 0,
"srvcsval509": 0,
"subtotsuppinc509": 0,
"totsupp509": 0,
"ein": 142007220,
"strein": "14-2007220",
"sub_name": "PRO PUBLICA INC",
"guidestar_url": "http://www.guidestar.org/organizations/14-2007220/.aspx",
"nccs_url": "http://nccsweb.urban.org/communityplatform/nccs/organization/profile/id/142007220/",
"name": "PRO PUBLICA INC",
"careofname": "",
"address": "55 BROADWAY",
"city": "NEW YORK",
"state": "NY",
"zipcode": "10006-3008",
"exemption_number": 0,
"subsection_code": 3,
"affiliation_code": 3,
"classification_codes": "1",
"ruling_date": "2008-02-01",
"deductibility_code": 1,
"foundation_code": 15,
"activity_codes": "000000000",
"organization_code": 1,
"exempt_organization_status_code": 0,
"tax_period": "2011-12-01",
"asset_code": 6,
"income_code": 8,
"filing_requirement_code": 1,
"pf_filing_requirement_code": 0,
"accounting_period": 120,
"asset_amount": 3591151,
"income_amount": 10142780,
"revenue_amount": 10142780,
"ntee_code": "A20"
},
{
"tax_prd": 201112,
"tax_prd_yr": 2011,
"formtype": 0,
"pdf_url": "https://bulk.resource.org/irs.gov/eo/2012_08_EO/14-2007220_990_201112.pdf",
"updated": "2013-04-11T15:41:23Z",
"totrevenue": 10142780,
"totfuncexpns": 9651650,
"totassetsend": 3591151,
"totliabend": 252318,
"pct_compnsatncurrofcr": 0.160904,
"tax_pd": null,
"subseccd": 3,
"unrelbusinccd": "Y",
"initiationfees": 0,
"grsrcptspublicuse": 0,
"grsincmembers": 0,
"grsincother": 0,
"totcntrbgfts": 10115367,
"totprgmrevnue": 0,
"invstmntinc": 83,
"txexmptbndsproceeds": 0,
"royaltsinc": 4547,
"grsrntsreal": 0,
"grsrntsprsnl": 0,
"rntlexpnsreal": 0,
"rntlexpnsprsnl": 0,
"rntlincreal": 0,
"rntlincprsnl": 0,
"netrntlinc": 0,
"grsalesecur": 0,
"grsalesothr": 0,
"cstbasisecur": 0,
"cstbasisothr": 0,
"gnlsecur": 0,
"gnlsothr": 0,
"netgnls": 0,
"grsincfndrsng": 0,
"lessdirfndrsng": 0,
"netincfndrsng": 0,
"grsincgaming": 0,
"lessdirgaming": 0,
"netincgaming": 0,
"grsalesinvent": 0,
"lesscstofgoods": 0,
"netincsales": 0,
"miscrevtot11e": 22783,
"compnsatncurrofcr": 1552988,
"othrsalwages": 4522408,
"payrolltx": 331237,
"profndraising": 0,
"txexmptbndsend": 0,
"secrdmrtgsend": 0,
"unsecurednotesend": 0,
"retainedearnend": 0,
"totnetassetend": 3338833,
"nonpfrea": "07",
"gftgrntsrcvd170": 36669506,
"txrevnuelevied170": 0,
"srvcsval170": 0,
"grsinc170": 41334,
"grsrcptsrelated170": 0,
"totgftgrntrcvd509": 0,
"grsrcptsadmissn509": 0,
"txrevnuelevied509": 0,
"srvcsval509": 0,
"subtotsuppinc509": 0,
"totsupp509": 0,
"ein": 142007220,
"strein": "14-2007220",
"sub_name": "PRO PUBLICA INC",
"guidestar_url": "http://www.guidestar.org/organizations/14-2007220/.aspx",
"nccs_url": "http://nccsweb.urban.org/communityplatform/nccs/organization/profile/id/142007220/",
"name": "PRO PUBLICA INC",
"careofname": "",
"address": "55 BROADWAY",
"city": "NEW YORK",
"state": "NY",
"zipcode": "10006-3008",
"exemption_number": 0,
"subsection_code": 3,
"affiliation_code": 3,
"classification_codes": "1",
"ruling_date": "2008-02-01",
"deductibility_code": 1,
"foundation_code": 15,
"activity_codes": "000000000",
"organization_code": 1,
"exempt_organization_status_code": 0,
"tax_period": "2011-12-01",
"asset_code": 6,
"income_code": 8,
"filing_requirement_code": 1,
"pf_filing_requirement_code": 0,
"accounting_period": 120,
"asset_amount": 3591151,
"income_amount": 10142780,
"revenue_amount": 10142780,
"ntee_code": "A20"
}
],
"max_pages": 1,
"cur_page": 0,
"page_offset": 0,
"per_page": 25,
"order": null,
"sort_order": null,
"search_query": "propublica",
"selected_state": null,
"selected_ntee": null,
"selected_code": null,
"data_source": "ProPublica Nonprofit Explorer API: http://projects.propublica.org/nonprofits/api/\nIRS Exempt Organizations Business Master File Extract (EO BMF): http://www.irs.gov/uac/SOI-Tax-Stats-Exempt-Organizations-Business-Master-File-Extract-(EO-BMF)\nIRS Annual Extract of Tax-Exempt Organization Financial Data: http://www.irs.gov/uac/SOI-Tax-Stats-Annual-Extract-of-Tax-Exempt-Organization-Financial-Data",
"api_version": 1
}
/* Example of "output=noorg" format.
* https://projects.propublica.org/nonprofits/api/v1/search.json?q=propublica&output=noorg */
{
"total_results": 2,
"filings": [
{
"tax_prd": 201212,
"tax_prd_yr": 2012,
"formtype": 0,
"pdf_url": "https://bulk.resource.org/irs.gov/eo/2013_09_EO/14-2007220_990_201212.pdf",
"updated": "2014-04-30T16:31:12Z",
"totrevenue": 10955982,
"totfuncexpns": 9884450,
"totassetsend": 4529443,
"totliabend": 119078,
"pct_compnsatncurrofcr": 0.0,
"tax_pd": null,
"subseccd": 3,
"unrelbusinccd": "Y",
"initiationfees": 0,
"grsrcptspublicuse": 0,
"grsincmembers": 0,
"grsincother": 0,
"totcntrbgfts": 10920019,
"totprgmrevnue": 0,
"invstmntinc": 50,
"txexmptbndsproceeds": 0,
"royaltsinc": 17096,
"grsrntsreal": 0,
"grsrntsprsnl": 0,
"rntlexpnsreal": 0,
"rntlexpnsprsnl": 0,
"rntlincreal": 0,
"rntlincprsnl": 0,
"netrntlinc": 0,
"grsalesecur": 0,
"grsalesothr": 0,
"cstbasisecur": 0,
"cstbasisothr": 0,
"gnlsecur": 0,
"gnlsothr": 0,
"netgnls": 0,
"grsincfndrsng": 0,
"lessdirfndrsng": 0,
"netincfndrsng": 0,
"grsincgaming": 0,
"lessdirgaming": 0,
"netincgaming": 0,
"grsalesinvent": 0,
"lesscstofgoods": 0,
"netincsales": 0,
"miscrevtot11e": 18817,
"compnsatncurrofcr": 0,
"othrsalwages": 0,
"payrolltx": 0,
"profndraising": 0,
"txexmptbndsend": 0,
"secrdmrtgsend": 0,
"unsecurednotesend": 0,
"retainedearnend": 0,
"totnetassetend": 4410365,
"nonpfrea": "07",
"gftgrntsrcvd170": 46144525,
"txrevnuelevied170": 0,
"srvcsval170": 0,
"grsinc170": 70024,
"grsrcptsrelated170": 0,
"totgftgrntrcvd509": 0,
"grsrcptsadmissn509": 0,
"txrevnuelevied509": 0,
"srvcsval509": 0,
"subtotsuppinc509": 0,
"totsupp509": 0,
"ein": 142007220
},
{
"tax_prd": 201112,
"tax_prd_yr": 2011,
"formtype": 0,
"pdf_url": "https://bulk.resource.org/irs.gov/eo/2012_08_EO/14-2007220_990_201112.pdf",
"updated": "2013-04-11T16:18:36Z",
"totrevenue": 10142780,
"totfuncexpns": 9651650,
"totassetsend": 3591151,
"totliabend": 252318,
"pct_compnsatncurrofcr": 0.160904,
"tax_pd": null,
"subseccd": 3,
"unrelbusinccd": "Y",
"initiationfees": 0,
"grsrcptspublicuse": 0,
"grsincmembers": 0,
"grsincother": 0,
"totcntrbgfts": 10115367,
"totprgmrevnue": 0,
"invstmntinc": 83,
"txexmptbndsproceeds": 0,
"royaltsinc": 4547,
"grsrntsreal": 0,
"grsrntsprsnl": 0,
"rntlexpnsreal": 0,
"rntlexpnsprsnl": 0,
"rntlincreal": 0,
"rntlincprsnl": 0,
"netrntlinc": 0,
"grsalesecur": 0,
"grsalesothr": 0,
"cstbasisecur": 0,
"cstbasisothr": 0,
"gnlsecur": 0,
"gnlsothr": 0,
"netgnls": 0,
"grsincfndrsng": 0,
"lessdirfndrsng": 0,
"netincfndrsng": 0,
"grsincgaming": 0,
"lessdirgaming": 0,
"netincgaming": 0,
"grsalesinvent": 0,
"lesscstofgoods": 0,
"netincsales": 0,
"miscrevtot11e": 22783,
"compnsatncurrofcr": 1552988,
"othrsalwages": 4522408,
"payrolltx": 331237,
"profndraising": 0,
"txexmptbndsend": 0,
"secrdmrtgsend": 0,
"unsecurednotesend": 0,
"retainedearnend": 0,
"totnetassetend": 3338833,
"nonpfrea": "07",
"gftgrntsrcvd170": 36669506,
"txrevnuelevied170": 0,
"srvcsval170": 0,
"grsinc170": 41334,
"grsrcptsrelated170": 0,
"totgftgrntrcvd509": 0,
"grsrcptsadmissn509": 0,
"txrevnuelevied509": 0,
"srvcsval509": 0,
"subtotsuppinc509": 0,
"totsupp509": 0,
"ein": 142007220
}
],
"max_pages": 1,
"cur_page": 0,
"page_offset": 0,
"per_page": 25,
"order": null,
"sort_order": null,
"search_query": "propublica",
"selected_state": null,
"selected_ntee": null,
"selected_code": null,
"data_source": "ProPublica Nonprofit Explorer API: http://projects.propublica.org/nonprofits/api/\nIRS Exempt Organizations Business Master File Extract (EO BMF): http://www.irs.gov/uac/SOI-Tax-Stats-Exempt-Organizations-Business-Master-File-Extract-(EO-BMF)\nIRS Annual Extract of Tax-Exempt Organization Financial Data: http://www.irs.gov/uac/SOI-Tax-Stats-Annual-Extract-of-Tax-Exempt-Organization-Financial-Data",
"api_version": 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment