ethics

This is a collection of disclosures made by nonprofit organizations about top salaries and transactions involving insiders. Data is from the IRS' Form 990/990EZ/990PF; self-dealing disclosures come from Schedule L. Data is as of December 2021. Read more at IRS directions on completing schedule L.

Data source: https://registry.opendata.aws/irs990/

Queries

Custom SQL query

excess_benefits

Orgnztn501c3Ind, Orgnztn501cInd, Orgnztn49471NtPFInd, Orgnztn527Ind, url_base, RtrnHdr_TxPrdEndDt, RtrnHdr_TxYr, BsnssOffcr_SgntrDt, Org_BsnssNmLn1, Org_BsnssNmL21, Org_BsnssOffcr_PrsnNm, Org_BsnssOffcr_PrsnTtlTxt, Org_BsnssOffcr_PhnNm, Org_BsnssOffcr_EmlAddrssTxt, Org_AddrssLn1Txt, Org_AddrssLn2Txt, Org_CtyNm, Org_SttAbbrvtnCd, Org_ZIPCd, Org_FrgnAddrss_AddrssLn1Txt, Org_FrgnAddrss_AddrssLn2Txt, Org_FrgnAddrss_CtyNm, Org_PrvncOrSttNm, Org_CntryCd, id, object_id, ein, PrsnNm, BsnssNmLn1Txt, BsnssNmLn2Txt, RlnDsqlfdPrsnOrgTxt, TrnsctnDsc, TrnsctnCrrctdInd

5,023 rows

insider_assistance

Orgnztn501c3Ind, Orgnztn501cInd, Orgnztn49471NtPFInd, Orgnztn527Ind, url_base, RtrnHdr_TxPrdEndDt, RtrnHdr_TxYr, BsnssOffcr_SgntrDt, Org_BsnssNmLn1, Org_BsnssNmL21, Org_BsnssOffcr_PrsnNm, Org_BsnssOffcr_PrsnTtlTxt, Org_BsnssOffcr_PhnNm, Org_BsnssOffcr_EmlAddrssTxt, Org_AddrssLn1Txt, Org_AddrssLn2Txt, Org_CtyNm, Org_SttAbbrvtnCd, Org_ZIPCd, Org_FrgnAddrss_AddrssLn1Txt, Org_FrgnAddrss_AddrssLn2Txt, Org_FrgnAddrss_CtyNm, Org_PrvncOrSttNm, Org_CntryCd, id, object_id, ein, PrsnNm, BsnssNmLn1Txt, BsnssNmLn2Txt, RltnshpWthOrgTxt, CshGrntAmt, OfAssstncTxt, AssstncPrpsTxt

11,002 rows

insider_transactions

Orgnztn501c3Ind, Orgnztn501cInd, Orgnztn49471NtPFInd, Orgnztn527Ind, url_base, RtrnHdr_TxPrdEndDt, RtrnHdr_TxYr, BsnssOffcr_SgntrDt, Org_BsnssNmLn1, Org_BsnssNmL21, Org_BsnssOffcr_PrsnNm, Org_BsnssOffcr_PrsnTtlTxt, Org_BsnssOffcr_PhnNm, Org_BsnssOffcr_EmlAddrssTxt, Org_AddrssLn1Txt, Org_AddrssLn2Txt, Org_CtyNm, Org_SttAbbrvtnCd, Org_ZIPCd, Org_FrgnAddrss_AddrssLn1Txt, Org_FrgnAddrss_AddrssLn2Txt, Org_FrgnAddrss_CtyNm, Org_PrvncOrSttNm, Org_CntryCd, id, object_id, ein, PrsnNm, BsnssNmLn1Txt, BsnssNmLn2Txt, RltnshpDscrptnTxt, TrnsctnAmt, TrnsctnDsc, ShrngOfRvnsInd

235,625 rows

loans_from

Orgnztn501c3Ind, Orgnztn501cInd, Orgnztn49471NtPFInd, Orgnztn527Ind, url_base, RtrnHdr_TxPrdEndDt, RtrnHdr_TxYr, BsnssOffcr_SgntrDt, Org_BsnssNmLn1, Org_BsnssNmL21, Org_BsnssOffcr_PrsnNm, Org_BsnssOffcr_PrsnTtlTxt, Org_BsnssOffcr_PhnNm, Org_BsnssOffcr_EmlAddrssTxt, Org_AddrssLn1Txt, Org_AddrssLn2Txt, Org_CtyNm, Org_SttAbbrvtnCd, Org_ZIPCd, Org_FrgnAddrss_AddrssLn1Txt, Org_FrgnAddrss_AddrssLn2Txt, Org_FrgnAddrss_CtyNm, Org_PrvncOrSttNm, Org_CntryCd, id, object_id, ein, PrsnNm, BsnssNmLn1Txt, BsnssNmLn2Txt, LnTOrgnztnInd, LnFrmOrgnztnInd, RltnshpWthOrgTxt, LnPrpsTxt, OrgnlPrncplAmt, BlncDAmt, DfltInd, BrdOrCmmttApprvlInd, WrttnAgrmntInd

57,998 rows

loans_to

Orgnztn501c3Ind, Orgnztn501cInd, Orgnztn49471NtPFInd, Orgnztn527Ind, url_base, RtrnHdr_TxPrdEndDt, RtrnHdr_TxYr, BsnssOffcr_SgntrDt, Org_BsnssNmLn1, Org_BsnssNmL21, Org_BsnssOffcr_PrsnNm, Org_BsnssOffcr_PrsnTtlTxt, Org_BsnssOffcr_PhnNm, Org_BsnssOffcr_EmlAddrssTxt, Org_AddrssLn1Txt, Org_AddrssLn2Txt, Org_CtyNm, Org_SttAbbrvtnCd, Org_ZIPCd, Org_FrgnAddrss_AddrssLn1Txt, Org_FrgnAddrss_AddrssLn2Txt, Org_FrgnAddrss_CtyNm, Org_PrvncOrSttNm, Org_CntryCd, id, object_id, ein, PrsnNm, BsnssNmLn1Txt, BsnssNmLn2Txt, LnTOrgnztnInd, LnFrmOrgnztnInd, RltnshpWthOrgTxt, LnPrpsTxt, OrgnlPrncplAmt, BlncDAmt, DfltInd, BrdOrCmmttApprvlInd, WrttnAgrmntInd

82,054 rows

Download SQLite DB: ethics.db 109.8 MB