{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "### Load Packages" ] }, { "cell_type": "code", "execution_count": 440, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "4857" ] }, "execution_count": 440, "metadata": {}, "output_type": "execute_result" } ], "source": [ "3522 + 35 + 1032 + 62 + 206" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false }, "outputs": [], "source": [ "import sys\n", "import time\n", "import json" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [], "source": [ "import numpy as np\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "import sqlite3 as lite\n", "\n", "from pandas import DataFrame\n", "from pandas import Series" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": true }, "outputs": [], "source": [ "#http://pandas.pydata.org/pandas-docs/stable/options.html\n", "pd.set_option('display.max_columns', None)\n", "pd.set_option('max_colwidth', 250)" ] }, { "cell_type": "code", "execution_count": 92, "metadata": { "collapsed": true }, "outputs": [], "source": [ "from __future__ import division" ] }, { "cell_type": "markdown", "metadata": { "collapsed": true }, "source": [ "#### Set working directory" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "/Users/gregorysaxton/Google Drive/SOX\n" ] } ], "source": [ "cd '/Users/gregorysaxton/Google Drive/SOX'" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Create List of EINs for '2016' charities -- I'll use this to create a list of EINs for matching with e-file database\n", "- Previous (Read in Saved List of EINs with 'current' (2016) donor advisories)\n", "- What I'm doing here is reading in the Stata 'Table 5' dataset so that I can create a list of the 8,304 relevant EINs." ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false }, "outputs": [], "source": [ "#f = open('2016 donor advisory EINs.json', 'r')\n", "#advisories_2016 = json.load(f)\n", "#print len(advisories_2016)\n", "#print advisories_2016[:10]" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": false }, "outputs": [], "source": [ "#df = pd.read_pickle('2016 - Test 4 data.pkl')\n", "#print \"Number of columns:\", len(df.columns)\n", "#print \"Number of observations:\", len(df)\n", "#df.head(1)" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [], "source": [ "#print len(set(df['EIN'].tolist()))\n", "#eins_2016 = df['EIN'].tolist()\n", "#print len(eins_2016), len(set(eins_2016))\n", "#print eins_2016[:5]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Read in Test 4 data" ] }, { "cell_type": "code", "execution_count": 393, "metadata": { "collapsed": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Number of columns: 35\n", "Number of observations: 8304\n" ] }, { "data": { "text/html": [ "
\n", " | donor_advisory | \n", "donor_advisory_2016 | \n", "donor_advisory_2011_to_2016 | \n", "org_id | \n", "EIN | \n", "FYE | \n", "Form 990 FYE | \n", "ratings_system | \n", "2011_data | \n", "2016_data | \n", "conflict_of_interest_policy_v2 | \n", "records_retention_policy_v2 | \n", "whistleblower_policy_v2 | \n", "SOX_policies | \n", "SOX_policies_binary | \n", "SOX_policies_all_binary | \n", "program_efficiency | \n", "complexity | \n", "complexity_2011 | \n", "age | \n", "total_revenue_logged | \n", "category | \n", "state | \n", "tot_rev | \n", "category_Animals | \n", "category_Arts, Culture, Humanities | \n", "category_Community Development | \n", "category_Education | \n", "category_Environment | \n", "category_Health | \n", "category_Human Services | \n", "category_Human and Civil Rights | \n", "category_International | \n", "category_Religion | \n", "category_Research and Public Policy | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50709 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "5954 | \n", "010202467 | \n", "FY2014 | \n", "2014-12 | \n", "CN 2.1 | \n", "0.0 | \n", "1.0 | \n", "1.0 | \n", "1.0 | \n", "1.0 | \n", "3.0 | \n", "1.0 | \n", "1.0 | \n", "0.794457 | \n", "6.0 | \n", "NaN | \n", "62.0 | \n", "16.377993 | \n", "Research and Public Policy | \n", "ME | \n", "NaN | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "1.0 | \n", "
\n", " | @documentId | \n", "@referenceDocumentId | \n", "@referenceDocumentName | \n", "@softwareId | \n", "@softwareVersion | \n", "@softwareVersionNum | \n", "AccountantCompileOrReview | \n", "AccountantCompileOrReviewBasis | \n", "AccountantCompileOrReviewInd | \n", "AccountsPayableAccrExpnssGrp | \n", "AccountsPayableAccruedExpenses | \n", "AccountsReceivable | \n", "AccountsReceivableGrp | \n", "AcctCompileOrReviewBasisGrp | \n", "ActivitiesConductedPartnership | \n", "ActivitiesConductedPrtshpInd | \n", "Activity2 | \n", "Activity3 | \n", "ActivityCd | \n", "ActivityCode | \n", "ActivityOrMissionDesc | \n", "ActivityOrMissionDescription | \n", "ActivityOther | \n", "AddressChange | \n", "AddressChangeInd | \n", "AddressPrincipalOfficerForeign | \n", "AddressPrincipalOfficerUS | \n", "Advertising | \n", "AdvertisingGrp | \n", "AllAffiliatesIncluded | \n", "AllAffiliatesIncludedInd | \n", "AllOtherContributions | \n", "AllOtherContributionsAmt | \n", "AllOtherExpenses | \n", "AllOtherExpensesGrp | \n", "AmendedReturn | \n", "AmendedReturnInd | \n", "AnnualDisclosureCoveredPersons | \n", "AnnualDisclosureCoveredPrsnInd | \n", "AuditCommittee | \n", "AuditCommitteeInd | \n", "AuditedFinancialStmtAttInd | \n", "BackupWthldComplianceInd | \n", "BalanceSheetAmountsReported | \n", "BenefitsPaidToMembersCY | \n", "BenefitsPaidToMembersPriorYear | \n", "BenefitsToMembers | \n", "BenefitsToMembersGrp | \n", "BooksInCareOfDetail | \n", "BsnssRltnshpThruFamilyMember | \n", "BsnssRltnshpWithOrganization | \n", "BusinessRlnWithFamMemInd | \n", "BusinessRlnWithOfficerEntInd | \n", "BusinessRlnWithOrgMemInd | \n", "CYBenefitsPaidToMembersAmt | \n", "CYContributionsGrantsAmt | \n", "CYGrantsAndSimilarPaidAmt | \n", "CYInvestmentIncomeAmt | \n", "CYOtherExpensesAmt | \n", "CYOtherRevenueAmt | \n", "CYProgramServiceRevenueAmt | \n", "CYRevenuesLessExpensesAmt | \n", "CYSalariesCompEmpBnftPaidAmt | \n", "CYTotalExpensesAmt | \n", "CYTotalFundraisingExpenseAmt | \n", "CYTotalProfFndrsngExpnsAmt | \n", "CYTotalRevenueAmt | \n", "CapStckTrstPrinCurrentFunds | \n", "CapStkTrPrinCurrentFundsGrp | \n", "CashNonInterestBearing | \n", "CashNonInterestBearingGrp | \n", "ChangeToOrgDocumentsInd | \n", "ChangesToOrganizingDocs | \n", "CntrbtnsRprtdFundraisingEvents | \n", "CntrctRcvdGreaterThan100KCnt | \n", "CollectionsOfArt | \n", "CollectionsOfArtInd | \n", "CompCurrentOfcrDirectorsGrp | \n", "CompCurrentOfficersDirectors | \n", "CompDisqualPersons | \n", "CompDisqualPersonsGrp | \n", "CompensationFromOtherSources | \n", "CompensationFromOtherSrcsInd | \n", "CompensationProcessCEO | \n", "CompensationProcessCEOInd | \n", "CompensationProcessOther | \n", "CompensationProcessOtherInd | \n", "ComplianceWithBackupWitholding | \n", "ConferencesMeetings | \n", "ConferencesMeetingsGrp | \n", "ConflictOfInterestPolicy | \n", "ConflictOfInterestPolicyInd | \n", "ConservationEasements | \n", "ConservationEasementsInd | \n", "ConsolidatedAuditFinancialStmt | \n", "ConsolidatedAuditFinclStmtInd | \n", "ContractTerminationInd | \n", "ContractorCompensation | \n", "ContractorCompensationGrp | \n", "ContriRptFundraisingEventAmt | \n", "ContributionsGrantsCurrentYear | \n", "ContributionsGrantsPriorYear | \n", "CostOfGoodsSold | \n", "CostOfGoodsSoldAmt | \n", "CountryLegalDomicile | \n", "CreditCounseling | \n", "CreditCounselingInd | \n", "DAFExcessBusinessHoldingsInd | \n", "DLN | \n", "DecisionsSubjectToApprovaInd | \n", "DecisionsSubjectToApproval | \n", "DeductibleArtContributionInd | \n", "DeductibleContributionsOfArt | \n", "DeductibleNonCashContriInd | \n", "DeductibleNonCashContributions | \n", "DeferredRevenue | \n", "DeferredRevenueGrp | \n", "DelegationOfManagementDuties | \n", "DelegationOfMgmtDutiesInd | \n", "DepreciationDepletion | \n", "DepreciationDepletionGrp | \n", "Desc | \n", "DescribedIn501C3 | \n", "DescribedInSection501c3Ind | \n", "Description | \n", "DisregardedEntity | \n", "DisregardedEntityInd | \n", "DistributionToDonor | \n", "DistributionToDonorInd | \n", "DoNotFollowSFAS117 | \n", "DocumentRetentionPolicy | \n", "DocumentRetentionPolicyInd | \n", "DoingBusinessAs | \n", "DoingBusinessAsName | \n", "DonatedServicesAndUseFcltsAmt | \n", "DonorAdvisedFundInd | \n", "DonorAdvisedFunds | \n", "EIN | \n", "ElectionOfBoardMembers | \n", "ElectionOfBoardMembersInd | \n", "EmployeeCnt | \n", "EmploymentTaxReturnsFiled | \n", "EmploymentTaxReturnsFiledInd | \n", "EngagedInExcessBenefitTransInd | \n", "EscrowAccount | \n", "EscrowAccountInd | \n", "EscrowAccountLiability | \n", "EscrowAccountLiabilityGrp | \n", "ExcessBenefitTransaction | \n", "ExcessBusinessHoldings | \n", "ExcessBusinessHoldingsInd | \n", "Expense | \n", "ExpenseAmt | \n", "FSAudited | \n", "FSAuditedBasis | \n", "FSAuditedBasisGrp | \n", "FSAuditedInd | \n", "FamilyOrBusinessRelationship | \n", "FamilyOrBusinessRlnInd | \n", "FederalGrantAuditPerformed | \n", "FederalGrantAuditPerformedInd | \n", "FederalGrantAuditRequired | \n", "FederalGrantAuditRequiredInd | \n", "FederatedCampaigns | \n", "FederatedCampaignsAmt | \n", "FeesForServicesAccounting | \n", "FeesForServicesAccountingGrp | \n", "FeesForServicesInvstMgmntFees | \n", "FeesForServicesLegal | \n", "FeesForServicesLegalGrp | \n", "FeesForServicesLobbying | \n", "FeesForServicesLobbyingGrp | \n", "FeesForServicesManagement | \n", "FeesForServicesManagementGrp | \n", "FeesForServicesOther | \n", "FeesForServicesOtherGrp | \n", "FeesForServicesProfFundraising | \n", "FeesForSrvcInvstMgmntFeesGrp | \n", "FiledLieu1041 | \n", "FinalReturnInd | \n", "FinancialStatementBoth | \n", "FinancialStatementConsolidated | \n", "FinancialStatementSeparate | \n", "FinancialStmtAttached | \n", "FollowSFAS117 | \n", "ForeignActivities | \n", "ForeignActivitiesInd | \n", "ForeignAddress | \n", "ForeignCountryCd | \n", "ForeignFinancialAccount | \n", "ForeignFinancialAccountInd | \n", "ForeignGrants | \n", "ForeignGrantsGrp | \n", "ForeignOffice | \n", "ForeignOfficeInd | \n", "Form1098CFiled | \n", "Form1098CFiledInd | \n", "Form720Filed | \n", "Form8282FiledCnt | \n", "Form8282PropertyDisposedOf | \n", "Form8282PropertyDisposedOfInd | \n", "Form8886TFiled | \n", "Form8886TFiledInd | \n", "Form8899Filed | \n", "Form8899Filedind | \n", "Form990-TFiled | \n", "Form990PartVIISectionA | \n", "Form990PartVIISectionAGrp | \n", "Form990ProvidedToGoverningBody | \n", "Form990ProvidedToGvrnBodyInd | \n", "Form990TFiledInd | \n", "FormType | \n", "FormationYr | \n", "FormerOfcrEmployeesListedInd | \n", "FormersListed | \n", "FundraisingActivities | \n", "FundraisingActivitiesInd | \n", "FundraisingAmt | \n", "FundraisingDirectExpenses | \n", "FundraisingDirectExpensesAmt | \n", "FundraisingEvents | \n", "FundraisingGrossIncomeAmt | \n", "FundsToPayPremiums | \n", "GainOrLoss | \n", "GainOrLossGrp | \n", "Gaming | \n", "GamingActivitiesInd | \n", "GamingDirectExpenses | \n", "GamingDirectExpensesAmt | \n", "GamingGrossIncomeAmt | \n", "GoverningBodyVotingMembersCnt | \n", "GovernmentGrants | \n", "GovernmentGrantsAmt | \n", "GrantAmt | \n", "GrantToRelatedPerson | \n", "GrantToRelatedPersonInd | \n", "Grants | \n", "GrantsAndSimilarAmntsCY | \n", "GrantsAndSimilarAmntsPriorYear | \n", "GrantsPayable | \n", "GrantsPayableGrp | \n", "GrantsToDomesticIndividuals | \n", "GrantsToDomesticIndividualsGrp | \n", "GrantsToDomesticOrgs | \n", "GrantsToDomesticOrgsGrp | \n", "GrantsToIndividuals | \n", "GrantsToIndividualsInd | \n", "GrantsToOrganizations | \n", "GrantsToOrganizationsInd | \n", "GrossAmountSalesAssets | \n", "GrossAmountSalesAssetsGrp | \n", "GrossIncomeFundraisingEvents | \n", "GrossIncomeGaming | \n", "GrossReceipts | \n", "GrossReceiptsAmt | \n", "GrossRents | \n", "GrossRentsGrp | \n", "GrossSalesOfInventory | \n", "GrossSalesOfInventoryAmt | \n", "GroupExemptionNum | \n", "GroupExemptionNumber | \n", "GroupReturnForAffiliates | \n", "GroupReturnForAffiliatesInd | \n", "Hospital | \n", "IRPDocumentCnt | \n", "IRPDocumentW2GCnt | \n", "IncludeFIN48FootnoteInd | \n", "IncmFromInvestBondProceedsGrp | \n", "IncomeFromInvestBondProceeds | \n", "IndependentAuditFinancialStmt | \n", "IndependentAuditFinclStmtInd | \n", "IndependentVotingMemberCnt | \n", "IndivRcvdGreaterThan100KCnt | \n", "IndoorTanningServices | \n", "IndoorTanningServicesInd | \n", "InfoInScheduleOPartIII | \n", "InfoInScheduleOPartIIIInd | \n", "InfoInScheduleOPartIX | \n", "InfoInScheduleOPartIXInd | \n", "InfoInScheduleOPartV | \n", "InfoInScheduleOPartVI | \n", "InfoInScheduleOPartVII | \n", "InfoInScheduleOPartVIII | \n", "InfoInScheduleOPartVIIIInd | \n", "InfoInScheduleOPartVIIInd | \n", "InfoInScheduleOPartVIInd | \n", "InfoInScheduleOPartVInd | \n", "InfoInScheduleOPartX | \n", "InfoInScheduleOPartXI | \n", "InfoInScheduleOPartXII | \n", "InfoInScheduleOPartXIIInd | \n", "InfoInScheduleOPartXIInd | \n", "InfoInScheduleOPartXInd | \n", "InformationTechnology | \n", "InformationTechnologyGrp | \n", "InitialReturn | \n", "InitialReturnInd | \n", "Insurance | \n", "InsuranceGrp | \n", "IntangibleAssets | \n", "IntangibleAssetsGrp | \n", "Interest | \n", "InterestGrp | \n", "InventoriesForSaleOrUse | \n", "InventoriesForSaleOrUseGrp | \n", "InvestTaxExemptBonds | \n", "InvestTaxExemptBondsInd | \n", "InvestmentExpenseAmt | \n", "InvestmentInJointVenture | \n", "InvestmentInJointVentureInd | \n", "InvestmentIncome | \n", "InvestmentIncomeCurrentYear | \n", "InvestmentIncomeGrp | \n", "InvestmentIncomePriorYear | \n", "InvestmentsOtherSecurities | \n", "InvestmentsOtherSecuritiesGrp | \n", "InvestmentsProgramRelated | \n", "InvestmentsProgramRelatedGrp | \n", "InvestmentsPubTradedSecGrp | \n", "InvestmentsPubTradedSecurities | \n", "IsAvailable | \n", "IsElectronic | \n", "JointCosts | \n", "JointCostsInd | \n", "LandBldgEquipAccumDeprecAmt | \n", "LandBldgEquipBasisNetGrp | \n", "LandBldgEquipCostOrOtherBssAmt | \n", "LandBldgEquipmentAccumDeprec | \n", "LandBuildingsEquipmentBasis | \n", "LandBuildingsEquipmentBasisNet | \n", "LastUpdated | \n", "LegalDomicileStateCd | \n", "LessCostOthBasisSalesExpenses | \n", "LessCostOthBasisSalesExpnssGrp | \n", "LessRentalExpenses | \n", "LessRentalExpensesGrp | \n", "LicensedMoreThanOneState | \n", "LicensedMoreThanOneStateInd | \n", "LoanOutstandingInd | \n", "LoanToOfficerOrDQP | \n", "LoansFromOfficersDirectors | \n", "LoansFromOfficersDirectorsGrp | \n", "LobbyingActivities | \n", "LobbyingActivitiesInd | \n", "LocalChapters | \n", "LocalChaptersInd | \n", "MaterialDiversionOrMisuse | \n", "MaterialDiversionOrMisuseInd | \n", "MembersOrStockholders | \n", "MembersOrStockholdersInd | \n", "MembershipDues | \n", "MembershipDuesAmt | \n", "MethodOfAccountingAccrual | \n", "MethodOfAccountingAccrualInd | \n", "MethodOfAccountingCash | \n", "MethodOfAccountingCashInd | \n", "MethodOfAccountingOther | \n", "MethodOfAccountingOtherInd | \n", "MinutesOfCommittees | \n", "MinutesOfCommitteesInd | \n", "MinutesOfGoverningBody | \n", "MinutesOfGoverningBodyInd | \n", "MiscellaneousRevenue | \n", "MiscellaneousRevenueGrp | \n", "MissionDesc | \n", "MissionDescription | \n", "MoreThan5000KToIndividuals | \n", "MoreThan5000KToIndividualsInd | \n", "MoreThan5000KToOrgInd | \n", "MoreThan5000KToOrganizations | \n", "MortNotesPyblSecuredInvestProp | \n", "MortgNotesPyblScrdInvstPropGrp | \n", "NameOfForeignCountry | \n", "NameOfPrincipalOfficerBusiness | \n", "NameOfPrincipalOfficerPerson | \n", "NbrIndependentVotingMembers | \n", "NbrVotingGoverningBodyMembers | \n", "NbrVotingMembersGoverningBody | \n", "NetAssetsOrFundBalancesBOY | \n", "NetAssetsOrFundBalancesBOYAmt | \n", "NetAssetsOrFundBalancesEOY | \n", "NetAssetsOrFundBalancesEOYAmt | \n", "NetGainOrLossInvestments | \n", "NetGainOrLossInvestmentsGrp | \n", "NetIncmFromFundraisingEvtGrp | \n", "NetIncomeFromFundraisingEvents | \n", "NetIncomeFromGaming | \n", "NetIncomeFromGamingGrp | \n", "NetIncomeOrLoss | \n", "NetIncomeOrLossGrp | \n", "NetRentalIncomeOrLoss | \n", "NetRentalIncomeOrLossGrp | \n", "NetUnrelatedBusTxblIncmAmt | \n", "NetUnrelatedBusinessTxblIncome | \n", "NetUnrlzdGainsLossesInvstAmt | \n", "NoListedPersonsCompensated | \n", "NoListedPersonsCompensatedInd | \n", "NonDeductibleContributions | \n", "NonDeductibleDisclosure | \n", "NoncashContributions | \n", "NoncashContributionsAmt | \n", "NondeductibleContriDisclInd | \n", "NondeductibleContributionsInd | \n", "NumberFormsTransmittedWith1096 | \n", "NumberIndependentVotingMembers | \n", "NumberIndividualsGT100K | \n", "NumberOf8282Filed | \n", "NumberOfContractorsGT100K | \n", "NumberOfEmployees | \n", "NumberW2GIncluded | \n", "ObjectId | \n", "Occupancy | \n", "OccupancyGrp | \n", "OfficeExpenses | \n", "OfficeExpensesGrp | \n", "OfficerEntityWithBsnssRltnshp | \n", "OfficerMailingAddress | \n", "OfficerMailingAddressInd | \n", "OnBehalfOfIssuer | \n", "OnBehalfOfIssuerInd | \n", "OperateHospitalInd | \n", "OrgDoesNotFollowSFAS117Ind | \n", "OrgFiledInLieuOfForm1041Ind | \n", "Organization501c | \n", "Organization501c3 | \n", "Organization501c3Ind | \n", "Organization501cInd | \n", "OrganizationFollowsSFAS117Ind | \n", "OrganizationName | \n", "OthNotesLoansReceivableNetGrp | \n", "OtherAssetsTotal | \n", "OtherAssetsTotalGrp | \n", "OtherChangesInNetAssetsAmt | \n", "OtherEmployeeBenefits | \n", "OtherEmployeeBenefitsGrp | \n", "OtherExpensePriorYear | \n", "OtherExpenses | \n", "OtherExpensesCurrentYear | \n", "OtherExpensesGrp | \n", "OtherExplainInSchO | \n", "OtherInd | \n", "OtherLiabilities | \n", "OtherLiabilitiesGrp | \n", "OtherNotesLoansReceivableNet | \n", "OtherOrganizationDsc | \n", "OtherRevenueCurrentYear | \n", "OtherRevenueMisc | \n", "OtherRevenueMiscGrp | \n", "OtherRevenuePriorYear | \n", "OtherRevenueTotalAmt | \n", "OtherSalariesAndWages | \n", "OtherSalariesAndWagesGrp | \n", "OtherWebsite | \n", "OtherWebsiteInd | \n", "OwnWebsite | \n", "OwnWebsiteInd | \n", "PYBenefitsPaidToMembersAmt | \n", "PYContributionsGrantsAmt | \n", "PYExcessBenefitTransInd | \n", "PYGrantsAndSimilarPaidAmt | \n", "PYInvestmentIncomeAmt | \n", "PYOtherExpensesAmt | \n", "PYOtherRevenueAmt | \n", "PYProgramServiceRevenueAmt | \n", "PYRevenuesLessExpensesAmt | \n", "PYSalariesCompEmpBnftPaidAmt | \n", "PYTotalExpensesAmt | \n", "PYTotalProfFndrsngExpnsAmt | \n", "PYTotalRevenueAmt | \n", "PaidInCapSrplsLandBldgEqpFund | \n", "PartialLiquidation | \n", "PartialLiquidationInd | \n", "PayPremiumsPrsnlBnftCntrctInd | \n", "PaymentsToAffiliates | \n", "PaymentsToAffiliatesGrp | \n", "PayrollTaxes | \n", "PayrollTaxesGrp | \n", "PdInCapSrplsLandBldgEqpFundGrp | \n", "PensionPlanContributions | \n", "PensionPlanContributionsGrp | \n", "PermanentlyRestrictedNetAssets | \n", "PermanentlyRstrNetAssetsGrp | \n", "PledgesAndGrantsReceivable | \n", "PledgesAndGrantsReceivableGrp | \n", "PoliciesReferenceChapters | \n", "PoliciesReferenceChaptersInd | \n", "PoliticalActivities | \n", "PoliticalCampaignActyInd | \n", "PremiumsPaid | \n", "PrepaidExpensesDeferredCharges | \n", "PrepaidExpensesDefrdChargesGrp | \n", "PrincipalOfcrBusinessAddress | \n", "PrincipalOfcrBusinessName | \n", "PrincipalOfficerNm | \n", "PriorExcessBenefitTransaction | \n", "PriorPeriodAdjustmentsAmt | \n", "ProfessionalFundraising | \n", "ProfessionalFundraisingInd | \n", "ProgSrvcAccomActy2Grp | \n", "ProgSrvcAccomActy3Grp | \n", "ProgSrvcAccomActyOtherGrp | \n", "ProgramServiceRevenue | \n", "ProgramServiceRevenueCY | \n", "ProgramServiceRevenueGrp | \n", "ProgramServiceRevenuePriorYear | \n", "ProhibitedTaxShelterTrans | \n", "ProhibitedTaxShelterTransInd | \n", "PymtTravelEntrtnmntPubOfclGrp | \n", "QuidProQuoContriDisclInd | \n", "QuidProQuoContributions | \n", "QuidProQuoContributionsInd | \n", "QuidProQuoDisclosure | \n", "RcvFndsToPayPrsnlBnftCntrctInd | \n", "RcvblFromDisqualifiedPrsnGrp | \n", "ReceivablesFromDisqualPersons | \n", "ReceivablesFromOfficersEtc | \n", "ReceivablesFromOfficersEtcGrp | \n", "ReconcilationDonatedServices | \n", "ReconcilationInvestExpenses | \n", "ReconcilationOtherChanges | \n", "ReconcilationPriorAdjustment | \n", "ReconcilationRevenueExpenses | \n", "ReconcilationRevenueExpnssAmt | \n", "ReconciliationUnrealizedInvest | \n", "RegularMonitoringEnforcement | \n", "RegularMonitoringEnfrcInd | \n", "RelatedEntity | \n", "RelatedEntityInd | \n", "RelatedOrgControlledEntity | \n", "RelatedOrganizationCtrlEntInd | \n", "RelatedOrganizations | \n", "RelatedOrganizationsAmt | \n", "RentalIncomeOrLoss | \n", "RentalIncomeOrLossGrp | \n", "ReportFin48Footnote | \n", "ReportInvestOthSecurities | \n", "ReportInvestmentsOtherSecInd | \n", "ReportLandBldgEquip | \n", "ReportLandBuildingEquipmentInd | \n", "ReportOtherAssets | \n", "ReportOtherAssetsInd | \n", "ReportOtherLiabilities | \n", "ReportOtherLiabilitiesInd | \n", "ReportProgRelInvest | \n", "ReportProgramRelatedInvstInd | \n", "ReservesMaintainedAmt | \n", "RetainedEarningsEndowmentEtc | \n", "Revenue | \n", "RevenueAmt | \n", "RevenuesLessExpensesCY | \n", "RevenuesLessExpensesPriorYear | \n", "Royalties | \n", "RoyaltiesGrp | \n", "RoyaltiesRevenue | \n", "RoyaltiesRevenueGrp | \n", "RtnEarnEndowmentIncmOthFndsGrp | \n", "SalariesEtcCurrentYear | \n", "SalariesEtcPriorYear | \n", "SavingsAndTempCashInvestments | \n", "SavingsAndTempCashInvstGrp | \n", "ScheduleBRequired | \n", "ScheduleBRequiredInd | \n", "ScheduleJRequired | \n", "ScheduleJRequiredInd | \n", "ScheduleORequired | \n", "ScheduleORequiredInd | \n", "School | \n", "SchoolOperatingInd | \n", "SignificantChange | \n", "SignificantChangeInd | \n", "SignificantNewProgramServices | \n", "SignificantNewProgramSrvcInd | \n", "SpecialConditionDescription | \n", "StateLegalDomicile | \n", "StateRequiredReservesAmt | \n", "StatesWhereCopyOfReturnIsFiled | \n", "StatesWhereCopyOfReturnIsFldCd | \n", "SubjectToProxyTax | \n", "SubjectToProxyTaxInd | \n", "SubmittedOn | \n", "TaxExemptBondLiabilities | \n", "TaxExemptBondLiabilitiesGrp | \n", "TaxExemptBonds | \n", "TaxExemptBondsInd | \n", "TaxPeriod | \n", "TaxableDistributions | \n", "TaxableDistributionsInd | \n", "TaxablePartyNotification | \n", "TaxablePartyNotificationInd | \n", "TempOrPermanentEndowmentsInd | \n", "TemporarilyRestrictedNetAssets | \n", "TemporarilyRstrNetAssetsGrp | \n", "TermOrPermanentEndowments | \n", "TerminateOperationsInd | \n", "Terminated | \n", "TerminationOrContraction | \n", "TheBooksAreInCareOf | \n", "TotLiabNetAssetsFundBalanceGrp | \n", "TotReportableCompRltdOrgAmt | \n", "TotalAssets | \n", "TotalAssetsBOY | \n", "TotalAssetsBOYAmt | \n", "TotalAssetsEOY | \n", "TotalAssetsEOYAmt | \n", "TotalAssetsGrp | \n", "TotalCompGT150K | \n", "TotalCompGreaterThan150KInd | \n", "TotalContributions | \n", "TotalContributionsAmt | \n", "TotalEmployeeCnt | \n", "TotalExpensesCurrentYear | \n", "TotalExpensesPriorYear | \n", "TotalFunctionalExpenses | \n", "TotalFunctionalExpensesGrp | \n", "TotalFundrsngExpCurrentYear | \n", "TotalGrossUBI | \n", "TotalGrossUBIAmt | \n", "TotalJointCosts | \n", "TotalJointCostsGrp | \n", "TotalLiabNetAssetsFundBalances | \n", "TotalLiabilities | \n", "TotalLiabilitiesBOY | \n", "TotalLiabilitiesBOYAmt | \n", "TotalLiabilitiesEOY | \n", "TotalLiabilitiesEOYAmt | \n", "TotalLiabilitiesGrp | \n", "TotalNbrEmployees | \n", "TotalNbrVolunteers | \n", "TotalNetAssetsFundBalanceGrp | \n", "TotalNetAssetsFundBalances | \n", "TotalOfOtherProgramServiceExp | \n", "TotalOfOtherProgramServiceGrnt | \n", "TotalOfOtherProgramServiceRev | \n", "TotalOthProgramServiceRevGrp | \n", "TotalOthProgramServiceRevenue | \n", "TotalOtherCompensation | \n", "TotalOtherCompensationAmt | \n", "TotalOtherProgSrvcExpenseAmt | \n", "TotalOtherProgSrvcGrantAmt | \n", "TotalOtherProgSrvcRevenueAmt | \n", "TotalOtherRevenue | \n", "TotalProfFundrsngExpCY | \n", "TotalProfFundrsngExpPriorYear | \n", "TotalProgramServiceExpense | \n", "TotalProgramServiceExpensesAmt | \n", "TotalProgramServiceRevenue | \n", "TotalProgramServiceRevenueAmt | \n", "TotalReportableCompFrmRltdOrgs | \n", "TotalReportableCompFromOrg | \n", "TotalReportableCompFromOrgAmt | \n", "TotalRevenue | \n", "TotalRevenueCurrentYear | \n", "TotalRevenueGrp | \n", "TotalRevenuePriorYear | \n", "TotalVolunteersCnt | \n", "TransactionRelatedEntity | \n", "TransactionWithControlEntInd | \n", "TransfersToExemptNonChrtblOrg | \n", "Travel | \n", "TravelEntrtnmntPublicOfficials | \n", "TravelGrp | \n", "TrnsfrExmptNonChrtblRltdOrgInd | \n", "TypeOfOrgOtherDescription | \n", "TypeOfOrganizationAssocInd | \n", "TypeOfOrganizationAssociation | \n", "TypeOfOrganizationCorpInd | \n", "TypeOfOrganizationCorporation | \n", "TypeOfOrganizationOther | \n", "TypeOfOrganizationOtherInd | \n", "TypeOfOrganizationTrust | \n", "TypeOfOrganizationTrustInd | \n", "URL | \n", "USAddress | \n", "UnrelatedBusIncmOverLimitInd | \n", "UnrelatedBusinessIncome | \n", "UnrestrictedNetAssets | \n", "UnrestrictedNetAssetsGrp | \n", "UnsecuredNotesLoansPayable | \n", "UnsecuredNotesLoansPayableGrp | \n", "UponRequest | \n", "UponRequestInd | \n", "VotingMembersGoverningBodyCnt | \n", "VotingMembersIndependentCnt | \n", "WebSite | \n", "WebsiteAddressTxt | \n", "WhistleblowerPolicy | \n", "WhistleblowerPolicyInd | \n", "WrittenPolicyOrProcedure | \n", "WrittenPolicyOrProcedureInd | \n", "YearFormation | \n", "_id | \n", "FeesForServicesAccountingGrp_v2 | \n", "FYE | \n", "FeesForServicesAccounting_TotalAmt | \n", "FeesForServicesAccounting_binary | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18819 | \n", "RetDoc1038000001 | \n", "RetDoc1044400001 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "{u'BOYAmt': u'506341', u'EOYAmt': u'557069'} | \n", "NaN | \n", "NaN | \n", "{u'BOYAmt': u'315681', u'EOYAmt': u'161137'} | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "TO DEVELOP SOLUTIONS TO COMPLEX HUMAN & ENVIRONMENTAL HEALTH PROBLEMS THROUGH RESEARCH & EDUCATION. | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2334773 | \n", "NaN | \n", "{u'TotalAmt': u'660207', u'ProgramServicesAmt': u'515736', u'ManagementAndGeneralAmt': u'95934', u'FundraisingAmt': u'48537'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'PersonNm': u'CLAUDINE D LURVEY', u'PhoneNum': u'2072889880', u'USAddress': {u'CityNm': u'SALISBURY COVE', u'StateAbbreviationCd': u'ME', u'ZIPCd': u'04672', u'AddressLine1Txt': u'OLD BAR HARBOR ROAD'}} | \n", "NaN | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1042800001'} | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1042800001'} | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1042800001'} | \n", "0 | \n", "10272455 | \n", "0 | \n", "982272 | \n", "6661282 | \n", "1404 | \n", "1711837 | \n", "2136547 | \n", "4155139 | \n", "10831421 | \n", "554608 | \n", "15000 | \n", "12967968 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'BOYAmt': u'1121795', u'EOYAmt': u'2540456'} | \n", "0 | \n", "NaN | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "NaN | \n", "{u'ContractorName': {u'BusinessName': {u'BusinessNameLine1Txt': u'GOODIE'S ELECTRICAL SERVICE'}}, u'ServicesDesc': u'ELECTRICIAN', u'ContractorAddress': {u'USAddress': {u'CityNm': u'BAR HARBOR', u'StateAbbreviationCd': u'ME', u'ZIPCd': u'04609', ... | \n", "800 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "93493320080035 | \n", "0 | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1042900001'} | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1042900001'} | \n", "NaN | \n", "NaN | \n", "{u'BOYAmt': u'529444', u'EOYAmt': u'835605'} | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'TotalAmt': u'1121059', u'ProgramServicesAmt': u'896847', u'ManagementAndGeneralAmt': u'168159', u'FundraisingAmt': u'56053'} | \n", "THE MDI BIOLOGICAL LABORATORY IS RECOGNIZED BY THE NATIONAL INSTITUTES OF HEALTH AS A CENTER OF BIOMEDICAL RESEARCH EXCELLENCE (COBRE) FOR OUR INNOVATIVE RESEARCH PROGRAM IN REGENERATIVE AND AGING BIOLOGY AND MEDICINE.OUR APPROACH SPEEDS THE DISC... | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1039100001'} | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "010202467 | \n", "NaN | \n", "1 | \n", "96 | \n", "NaN | \n", "1 | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1042800001'} | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "8605100 | \n", "NaN | \n", "NaN | \n", "{u'SeparateBasisFinclStmtInd': u'X'} | \n", "1 | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'TotalAmt': u'23700', u'ManagementAndGeneralAmt': u'23700'} | \n", "NaN | \n", "NaN | \n", "{u'TotalAmt': u'3792', u'ManagementAndGeneralAmt': u'3792'} | \n", "NaN | \n", "{u'TotalAmt': u'89167', u'ManagementAndGeneralAmt': u'3379', u'FundraisingAmt': u'85788'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'TotalAmt': u'201518', u'ProgramServicesAmt': u'127950', u'ManagementAndGeneralAmt': u'64909', u'FundraisingAmt': u'8659'} | \n", "{u'TotalAmt': u'15000', u'FundraisingAmt': u'15000'} | \n", "{u'TotalAmt': u'18902', u'ManagementAndGeneralAmt': u'18902'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "[{u'PersonNm': u'DR EDWARD J BENZ', u'IndividualTrusteeOrDirectorInd': u'X', u'AverageHoursPerWeekRt': u'2.00', u'ReportableCompFromRltdOrgAmt': u'0', u'OtherCompensationAmt': u'0', u'TitleTxt': u'VICE CHAIRMAN OF THE BOARD', u'OfficerInd': u'X',... | \n", "NaN | \n", "1 | \n", "NaN | \n", "990 | \n", "1898 | \n", "0 | \n", "NaN | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1041300001'} | \n", "800 | \n", "NaN | \n", "37598 | \n", "NaN | \n", "38964 | \n", "NaN | \n", "NaN | \n", "{u'OtherAmt': u'322752'} | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1041300001'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "22 | \n", "NaN | \n", "7932282 | \n", "NaN | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1042800001'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "0 | \n", "NaN | \n", "{u'OtherAmt': u'340000'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "13022814 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "38 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "158 | \n", "0 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "21 | \n", "3 | \n", "NaN | \n", "0 | \n", "NaN | \n", "X | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "X | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "X | \n", "X | \n", "NaN | \n", "NaN | \n", "{u'TotalAmt': u'49382', u'ProgramServicesAmt': u'8673', u'ManagementAndGeneralAmt': u'40709'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'TotalAmt': u'92396', u'ProgramServicesAmt': u'10397', u'ManagementAndGeneralAmt': u'81746', u'FundraisingAmt': u'253'} | \n", "NaN | \n", "{u'BOYAmt': u'147691', u'EOYAmt': u'141271'} | \n", "NaN | \n", "{u'TotalAmt': u'255985', u'ProgramServicesAmt': u'191989', u'ManagementAndGeneralAmt': u'63996'} | \n", "NaN | \n", "{u'BOYAmt': u'8329'} | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "{u'TotalRevenueColumnAmt': u'659520', u'ExclusionAmt': u'659520'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'BOYAmt': u'4031973', u'EOYAmt': u'4747115'} | \n", "NaN | \n", "True | \n", "True | \n", "NaN | \n", "NaN | \n", "11322245 | \n", "{u'BOYAmt': u'14025403', u'EOYAmt': u'14020382'} | \n", "25342627 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2016-04-29T13:40:20 | \n", "ME | \n", "NaN | \n", "{u'OtherAmt': u'17248'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1042800001'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1039700001'} | \n", "NaN | \n", "0 | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "4600 | \n", "NaN | \n", "X | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "THE MDI BIOLOGICAL LABORATORY IS A RAPIDLY GROWING, INDEPENDENT NON-PROFIT BIOMEDICAL RESEARCH INSTITUTION. ITS MISSION IS TO IMPROVE HUMAN HEALTH AND WELL-BEING THROUGH RESEARCH, EDUCATION,AND DEVELOPMENT VENTURES THAT TRANSFORM DISCOVERIES INTO... | \n", "NaN | \n", "NaN | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "21657900 | \n", "NaN | \n", "23690097 | \n", "NaN | \n", "{u'TotalRevenueColumnAmt': u'322752', u'ExclusionAmt': u'322752'} | \n", "{u'TotalRevenueColumnAmt': u'1366', u'ExclusionAmt': u'1366'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'TotalRevenueColumnAmt': u'38', u'ExclusionAmt': u'38'} | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "-104353 | \n", "NaN | \n", "X | \n", "NaN | \n", "NaN | \n", "NaN | \n", "57474 | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "201533209349308003 | \n", "NaN | \n", "{u'TotalAmt': u'587738', u'ProgramServicesAmt': u'494365', u'ManagementAndGeneralAmt': u'91234', u'FundraisingAmt': u'2139'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "X | \n", "NaN | \n", "X | \n", "MOUNT DESERT ISLAND BIOLOGICAL LABORATORY | \n", "NaN | \n", "NaN | \n", "NaN | \n", "3 | \n", "NaN | \n", "{u'TotalAmt': u'370740', u'ProgramServicesAmt': u'284086', u'ManagementAndGeneralAmt': u'70910', u'FundraisingAmt': u'15744'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "[{u'TotalAmt': u'2124748', u'ProgramServicesAmt': u'2124748', u'Desc': u'SUBAWARDS'}, {u'TotalAmt': u'682378', u'ProgramServicesAmt': u'627645', u'ManagementAndGeneralAmt': u'47547', u'FundraisingAmt': u'7186', u'Desc': u'SUPPLIES'}, {u'TotalAmt'... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'BOYAmt': u'4630000', u'EOYAmt': u'4525000'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'TotalAmt': u'3353971', u'ProgramServicesAmt': u'2478596', u'ManagementAndGeneralAmt': u'683266', u'FundraisingAmt': u'192109'} | \n", "NaN | \n", "X | \n", "NaN | \n", "X | \n", "0 | \n", "7802139 | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1042800001'} | \n", "0 | \n", "785633 | \n", "6736413 | \n", "-13375 | \n", "1591204 | \n", "-449665 | \n", "3878853 | \n", "10615266 | \n", "0 | \n", "10165601 | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'TotalAmt': u'257923', u'ProgramServicesAmt': u'189245', u'ManagementAndGeneralAmt': u'52592', u'FundraisingAmt': u'16086'} | \n", "NaN | \n", "NaN | \n", "{u'TotalAmt': u'172505', u'ProgramServicesAmt': u'125037', u'ManagementAndGeneralAmt': u'37384', u'FundraisingAmt': u'10084'} | \n", "NaN | \n", "{u'BOYAmt': u'4193257', u'EOYAmt': u'4433997'} | \n", "NaN | \n", "{u'BOYAmt': u'797504', u'EOYAmt': u'986621'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1039700001'} | \n", "NaN | \n", "NaN | \n", "{u'BOYAmt': u'4791', u'EOYAmt': u'5301'} | \n", "NaN | \n", "NaN | \n", "DR KEVIN STRANGE PHD | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1041300001'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "[{u'TotalRevenueColumnAmt': u'469300', u'BusinessCd': u'611710', u'RelatedOrExemptFuncIncomeAmt': u'469300', u'Desc': u'CONFER & COURSE FEES'}, {u'TotalRevenueColumnAmt': u'353507', u'BusinessCd': u'541700', u'RelatedOrExemptFuncIncomeAmt': u'353... | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2136547 | \n", "NaN | \n", "NaN | \n", "1 | \n", "NaN | \n", "0 | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1733437 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'BOYAmt': u'6870518', u'EOYAmt': u'7005488'} | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1234500001'} | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1042400001'} | \n", "NaN | \n", "1 | \n", "NaN | \n", "0 | \n", "NaN | \n", "0 | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "ME | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1039700001'} | \n", "2016-02-16 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1053100001'} | \n", "201412 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "{u'BOYAmt': u'5880227', u'EOYAmt': u'7351259'} | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'BOYAmt': u'27323685', u'EOYAmt': u'29607771'} | \n", "0 | \n", "NaN | \n", "NaN | \n", "27323685 | \n", "NaN | \n", "29607771 | \n", "{u'BOYAmt': u'27323685', u'EOYAmt': u'29607771'} | \n", "NaN | \n", "1 | \n", "NaN | \n", "10272455 | \n", "96 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'TotalAmt': u'10831421', u'ProgramServicesAmt': u'8605100', u'ManagementAndGeneralAmt': u'1671713', u'FundraisingAmt': u'554608'} | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "5665785 | \n", "NaN | \n", "5917674 | \n", "{u'BOYAmt': u'5665785', u'EOYAmt': u'5917674'} | \n", "NaN | \n", "NaN | \n", "{u'BOYAmt': u'21657900', u'EOYAmt': u'23690097'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'TotalRevenueColumnAmt': u'38356', u'RelatedOrExemptFuncIncomeAmt': u'38356'} | \n", "NaN | \n", "NaN | \n", "67100 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "8605100 | \n", "NaN | \n", "1711837 | \n", "NaN | \n", "NaN | \n", "496334 | \n", "NaN | \n", "NaN | \n", "{u'UnrelatedBusinessRevenueAmt': u'0', u'TotalRevenueColumnAmt': u'12967968', u'RelatedOrExemptFuncIncomeAmt': u'1711837', u'ExclusionAmt': u'983676'} | \n", "NaN | \n", "125 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'TotalAmt': u'128657', u'ProgramServicesAmt': u'84416', u'ManagementAndGeneralAmt': u'33781', u'FundraisingAmt': u'10460'} | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "X | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "https://s3.amazonaws.com/irs-form-990/201533209349308003_public.xml | \n", "{u'CityNm': u'SALISBURY COVE', u'StateAbbreviationCd': u'ME', u'ZIPCd': u'046720035', u'AddressLine1Txt': u'PO BOX 35'} | \n", "0 | \n", "NaN | \n", "NaN | \n", "{u'BOYAmt': u'11584416', u'EOYAmt': u'11904841'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "X | \n", "22 | \n", "21 | \n", "NaN | \n", "WWW.MDIBL.ORG | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "58c33e003ffc5a1664e96b73 | \n", "{u'TotalAmt': u'23700', u'ManagementAndGeneralAmt': u'23700'} | \n", "FY2014 | \n", "23700.0 | \n", "1 | \n", "
\n", " | variable | \n", "description | \n", "line_number | \n", "first year | \n", "
---|---|---|---|---|
0 | \n", "AccountantCompileOrReview | \n", "Accountant provide compilation or review? | \n", "Part XII Line 2a | \n", "2010 | \n", "
\n", " | FYE | \n", "EIN | \n", "NbrIndependentVotingMembers | \n", "NbrVotingGoverningBodyMembers | \n", "NbrVotingMembersGoverningBody | \n", "NumberIndependentVotingMembers | \n", "GoverningBodyVotingMembersCnt | \n", "IndependentVotingMemberCnt | \n", "VotingMembersGoverningBodyCnt | \n", "VotingMembersIndependentCnt | \n", "
---|---|---|---|---|---|---|---|---|---|---|
18819 | \n", "FY2014 | \n", "010202467 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "22 | \n", "21 | \n", "22 | \n", "21 | \n", "
7965 | \n", "FY2013 | \n", "010202467 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "21 | \n", "21 | \n", "21 | \n", "21 | \n", "
8989 | \n", "FY2012 | \n", "010202467 | \n", "20 | \n", "20 | \n", "20 | \n", "20 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
22904 | \n", "FY2011 | \n", "010202467 | \n", "23 | \n", "23 | \n", "23 | \n", "23 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
19649 | \n", "FY2010 | \n", "010202467 | \n", "24 | \n", "24 | \n", "24 | \n", "24 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
28581 | \n", "FY2015 | \n", "010211478 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "18 | \n", "18 | \n", "18 | \n", "18 | \n", "
20683 | \n", "FY2014 | \n", "010211478 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "18 | \n", "18 | \n", "18 | \n", "18 | \n", "
4797 | \n", "FY2013 | \n", "010211478 | \n", "18 | \n", "18 | \n", "18 | \n", "18 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
15877 | \n", "FY2012 | \n", "010211478 | \n", "18 | \n", "18 | \n", "18 | \n", "18 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
18981 | \n", "FY2011 | \n", "010211478 | \n", "19 | \n", "19 | \n", "19 | \n", "19 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
589 | \n", "FY2014 | \n", "010211513 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "23 | \n", "21 | \n", "23 | \n", "21 | \n", "
21460 | \n", "FY2013 | \n", "010211513 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "22 | \n", "20 | \n", "22 | \n", "20 | \n", "
4502 | \n", "FY2012 | \n", "010211513 | \n", "20 | \n", "22 | \n", "22 | \n", "20 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
13619 | \n", "FY2011 | \n", "010211513 | \n", "21 | \n", "21 | \n", "21 | \n", "21 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
17018 | \n", "FY2010 | \n", "010211513 | \n", "24 | \n", "25 | \n", "25 | \n", "24 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
28147 | \n", "FY2014 | \n", "010211530 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "28 | \n", "28 | \n", "28 | \n", "28 | \n", "
6614 | \n", "FY2013 | \n", "010211530 | \n", "29 | \n", "29 | \n", "29 | \n", "29 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
27887 | \n", "FY2012 | \n", "010211530 | \n", "27 | \n", "27 | \n", "27 | \n", "27 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
13438 | \n", "FY2011 | \n", "010211530 | \n", "29 | \n", "29 | \n", "29 | \n", "29 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
17003 | \n", "FY2010 | \n", "010211530 | \n", "29 | \n", "29 | \n", "29 | \n", "29 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
\n", " | EIN | \n", "FYE | \n", "TemporarilyRstrNetAssetsGrp | \n", "TemporarilyRestrictedNetAssets | \n", "PermanentlyRstrNetAssetsGrp | \n", "PermanentlyRestrictedNetAssets | \n", "UnrestrictedNetAssetsGrp | \n", "UnrestrictedNetAssets | \n", "TotalNetAssetsFundBalanceGrp | \n", "TotalNetAssetsFundBalances | \n", "NetAssetsOrFundBalancesBOYAmt | \n", "NetAssetsOrFundBalancesBOY | \n", "NetAssetsOrFundBalancesEOYAmt | \n", "NetAssetsOrFundBalancesEOY | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18819 | \n", "010202467 | \n", "FY2014 | \n", "{u'BOYAmt': u'5880227', u'EOYAmt': u'7351259'} | \n", "NaN | \n", "{u'BOYAmt': u'4193257', u'EOYAmt': u'4433997'} | \n", "NaN | \n", "{u'BOYAmt': u'11584416', u'EOYAmt': u'11904841'} | \n", "NaN | \n", "{u'BOYAmt': u'21657900', u'EOYAmt': u'23690097'} | \n", "NaN | \n", "21657900 | \n", "NaN | \n", "23690097 | \n", "NaN | \n", "
7965 | \n", "010202467 | \n", "FY2013 | \n", "{u'BOYAmt': u'5773597', u'EOYAmt': u'5880227'} | \n", "NaN | \n", "{u'BOYAmt': u'4153627', u'EOYAmt': u'4193257'} | \n", "NaN | \n", "{u'BOYAmt': u'12203695', u'EOYAmt': u'11584416'} | \n", "NaN | \n", "{u'BOYAmt': u'22130919', u'EOYAmt': u'21657900'} | \n", "NaN | \n", "22130919 | \n", "NaN | \n", "21657900 | \n", "NaN | \n", "
8989 | \n", "010202467 | \n", "FY2012 | \n", "NaN | \n", "{u'BOY': u'6554891', u'EOY': u'5773597'} | \n", "NaN | \n", "{u'BOY': u'3096087', u'EOY': u'4153627'} | \n", "NaN | \n", "{u'BOY': u'10835720', u'EOY': u'12203695'} | \n", "NaN | \n", "{u'BOY': u'20486698', u'EOY': u'22130919'} | \n", "NaN | \n", "20486698 | \n", "NaN | \n", "22130919 | \n", "
22904 | \n", "010202467 | \n", "FY2011 | \n", "NaN | \n", "{u'BOY': u'7110362', u'EOY': u'6554891'} | \n", "NaN | \n", "{u'BOY': u'2873816', u'EOY': u'3096087'} | \n", "NaN | \n", "{u'BOY': u'7951722', u'EOY': u'10835720'} | \n", "NaN | \n", "{u'BOY': u'17935900', u'EOY': u'20486698'} | \n", "NaN | \n", "17935900 | \n", "NaN | \n", "20486698 | \n", "
19649 | \n", "010202467 | \n", "FY2010 | \n", "NaN | \n", "{u'BOY': u'7291747', u'EOY': u'7110362'} | \n", "NaN | \n", "{u'BOY': u'2824416', u'EOY': u'2873816'} | \n", "NaN | \n", "{u'BOY': u'7878008', u'EOY': u'7951722'} | \n", "NaN | \n", "{u'BOY': u'17994171', u'EOY': u'17935900'} | \n", "NaN | \n", "17994171 | \n", "NaN | \n", "17935900 | \n", "
28581 | \n", "010211478 | \n", "FY2015 | \n", "{u'BOYAmt': u'889233', u'EOYAmt': u'908556'} | \n", "NaN | \n", "{u'BOYAmt': u'2717476', u'EOYAmt': u'2717000'} | \n", "NaN | \n", "{u'BOYAmt': u'1254972', u'EOYAmt': u'1179056'} | \n", "NaN | \n", "{u'BOYAmt': u'4861681', u'EOYAmt': u'4804612'} | \n", "NaN | \n", "4861681 | \n", "NaN | \n", "4804612 | \n", "NaN | \n", "
20683 | \n", "010211478 | \n", "FY2014 | \n", "{u'BOYAmt': u'614778', u'EOYAmt': u'889233'} | \n", "NaN | \n", "{u'BOYAmt': u'2669412', u'EOYAmt': u'2717476'} | \n", "NaN | \n", "{u'BOYAmt': u'1291239', u'EOYAmt': u'1254972'} | \n", "NaN | \n", "{u'BOYAmt': u'4575429', u'EOYAmt': u'4861681'} | \n", "NaN | \n", "4575429 | \n", "NaN | \n", "4861681 | \n", "NaN | \n", "
4797 | \n", "010211478 | \n", "FY2013 | \n", "NaN | \n", "{u'BOY': u'563731', u'EOY': u'614778'} | \n", "NaN | \n", "{u'BOY': u'2652247', u'EOY': u'2669412'} | \n", "NaN | \n", "{u'BOY': u'1362377', u'EOY': u'1291239'} | \n", "NaN | \n", "{u'BOY': u'4578355', u'EOY': u'4575429'} | \n", "NaN | \n", "4578355 | \n", "NaN | \n", "4575429 | \n", "
15877 | \n", "010211478 | \n", "FY2012 | \n", "NaN | \n", "{u'BOY': u'511917', u'EOY': u'563731'} | \n", "NaN | \n", "{u'BOY': u'2662228', u'EOY': u'2652247'} | \n", "NaN | \n", "{u'BOY': u'1383839', u'EOY': u'1362377'} | \n", "NaN | \n", "{u'BOY': u'4557984', u'EOY': u'4578355'} | \n", "NaN | \n", "4557984 | \n", "NaN | \n", "4578355 | \n", "
18981 | \n", "010211478 | \n", "FY2011 | \n", "NaN | \n", "{u'BOY': u'586298', u'EOY': u'511917'} | \n", "NaN | \n", "{u'BOY': u'406957', u'EOY': u'2662228'} | \n", "NaN | \n", "{u'BOY': u'928373', u'EOY': u'1383839'} | \n", "NaN | \n", "{u'BOY': u'1921628', u'EOY': u'4557984'} | \n", "NaN | \n", "1921628 | \n", "NaN | \n", "4557984 | \n", "
\n", " | EIN | \n", "FYE | \n", "FSAuditedInd | \n", "FSAudited | \n", "FederalGrantAuditPerformedInd | \n", "FederalGrantAuditPerformed | \n", "FederalGrantAuditRequiredInd | \n", "FederalGrantAuditRequired | \n", "IndependentAuditFinclStmtInd | \n", "IndependentAuditFinancialStmt | \n", "
---|---|---|---|---|---|---|---|---|---|---|
18819 | \n", "010202467 | \n", "FY2014 | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "
7965 | \n", "010202467 | \n", "FY2013 | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "
8989 | \n", "010202467 | \n", "FY2012 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "
22904 | \n", "010202467 | \n", "FY2011 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "
19649 | \n", "010202467 | \n", "FY2010 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1039900001'} | \n", "
28581 | \n", "010211478 | \n", "FY2015 | \n", "true | \n", "NaN | \n", "NaN | \n", "NaN | \n", "false | \n", "NaN | \n", "{u'#text': u'true', u'@referenceDocumentId': u'RetDoc3'} | \n", "NaN | \n", "
20683 | \n", "010211478 | \n", "FY2014 | \n", "true | \n", "NaN | \n", "NaN | \n", "NaN | \n", "false | \n", "NaN | \n", "{u'#text': u'true', u'@referenceDocumentId': u'RetDoc4'} | \n", "NaN | \n", "
4797 | \n", "010211478 | \n", "FY2013 | \n", "NaN | \n", "true | \n", "NaN | \n", "NaN | \n", "NaN | \n", "false | \n", "NaN | \n", "{u'#text': u'true', u'@referenceDocumentId': u'RetDoc3'} | \n", "
\n", " | FYE | \n", "donor_restrictions | \n", "temp_rest_assets | \n", "TemporarilyRstrNetAssetsGrp | \n", "TemporarilyRestrictedNetAssets | \n", "perm_rest_assets | \n", "PermanentlyRstrNetAssetsGrp | \n", "PermanentlyRestrictedNetAssets | \n", "net_assets | \n", "NetAssetsOrFundBalancesEOYAmt | \n", "NetAssetsOrFundBalancesEOY | \n", "TotalNetAssetsFundBalanceGrp | \n", "TotalNetAssetsFundBalances | \n", "NetAssetsOrFundBalancesEOYAmt | \n", "NetAssetsOrFundBalancesEOY | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13277 | \n", "FY2011 | \n", "0.011886 | \n", "45000 | \n", "NaN | \n", "{u'BOY': u'73257', u'EOY': u'45000'} | \n", "0 | \n", "NaN | \n", "NaN | \n", "3785879 | \n", "NaN | \n", "3785879 | \n", "NaN | \n", "{u'BOY': u'3228716', u'EOY': u'3785879'} | \n", "NaN | \n", "3785879 | \n", "
616 | \n", "FY2014 | \n", "0.143153 | \n", "52310 | \n", "{u'BOYAmt': u'91351', u'EOYAmt': u'52310'} | \n", "NaN | \n", "284363 | \n", "{u'BOYAmt': u'207970', u'EOYAmt': u'284363'} | \n", "NaN | \n", "2351842 | \n", "2351842 | \n", "NaN | \n", "{u'BOYAmt': u'2321970', u'EOYAmt': u'2351842'} | \n", "NaN | \n", "2351842 | \n", "NaN | \n", "
8573 | \n", "FY2013 | \n", "0.128908 | \n", "91351 | \n", "{u'BOYAmt': u'467396', u'EOYAmt': u'91351'} | \n", "NaN | \n", "207970 | \n", "{u'BOYAmt': u'100000', u'EOYAmt': u'207970'} | \n", "NaN | \n", "2321970 | \n", "2321970 | \n", "NaN | \n", "{u'BOYAmt': u'2441674', u'EOYAmt': u'2321970'} | \n", "NaN | \n", "2321970 | \n", "NaN | \n", "
23577 | \n", "FY2012 | \n", "0.232380 | \n", "467396 | \n", "NaN | \n", "{u'BOY': u'171880', u'EOY': u'467396'} | \n", "100000 | \n", "NaN | \n", "{u'BOY': u'0', u'EOY': u'100000'} | \n", "2441674 | \n", "NaN | \n", "2441674 | \n", "NaN | \n", "{u'BOY': u'1953372', u'EOY': u'2441674'} | \n", "NaN | \n", "2441674 | \n", "
16294 | \n", "FY2011 | \n", "0.087991 | \n", "171880 | \n", "NaN | \n", "{u'BOY': u'96956', u'EOY': u'171880'} | \n", "0 | \n", "NaN | \n", "NaN | \n", "1953372 | \n", "NaN | \n", "1953372 | \n", "NaN | \n", "{u'BOY': u'1720152', u'EOY': u'1953372'} | \n", "NaN | \n", "1953372 | \n", "
26647 | \n", "FY2010 | \n", "0.056365 | \n", "96956 | \n", "NaN | \n", "{u'BOY': u'79000', u'EOY': u'96956'} | \n", "0 | \n", "NaN | \n", "NaN | \n", "1720152 | \n", "NaN | \n", "1720152 | \n", "NaN | \n", "{u'BOY': u'1413351', u'EOY': u'1720152'} | \n", "NaN | \n", "1720152 | \n", "
\n", " | FYE | \n", "donor_restrictions | \n", "temp_rest_assets | \n", "perm_rest_assets | \n", "net_assets | \n", "
---|---|---|---|---|---|
13277 | \n", "FY2011 | \n", "0.011886 | \n", "45000 | \n", "0 | \n", "3785879 | \n", "
616 | \n", "FY2014 | \n", "0.143153 | \n", "52310 | \n", "284363 | \n", "2351842 | \n", "
8573 | \n", "FY2013 | \n", "0.128908 | \n", "91351 | \n", "207970 | \n", "2321970 | \n", "
23577 | \n", "FY2012 | \n", "0.232380 | \n", "467396 | \n", "100000 | \n", "2441674 | \n", "
16294 | \n", "FY2011 | \n", "0.087991 | \n", "171880 | \n", "0 | \n", "1953372 | \n", "
26647 | \n", "FY2010 | \n", "0.056365 | \n", "96956 | \n", "0 | \n", "1720152 | \n", "
\n", " | FYE | \n", "donor_restrictions | \n", "temp_rest_assets | \n", "TemporarilyRstrNetAssetsGrp | \n", "TemporarilyRestrictedNetAssets | \n", "perm_rest_assets | \n", "PermanentlyRstrNetAssetsGrp | \n", "PermanentlyRestrictedNetAssets | \n", "net_assets | \n", "NetAssetsOrFundBalancesEOYAmt | \n", "NetAssetsOrFundBalancesEOY | \n", "TotalNetAssetsFundBalanceGrp | \n", "TotalNetAssetsFundBalances | \n", "NetAssetsOrFundBalancesEOYAmt | \n", "NetAssetsOrFundBalancesEOY | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4768 | \n", "FY2012 | \n", "1.029663 | \n", "261414 | \n", "NaN | \n", "{u'BOY': u'589365', u'EOY': u'261414'} | \n", "0 | \n", "NaN | \n", "NaN | \n", "253883 | \n", "NaN | \n", "253883 | \n", "NaN | \n", "{u'BOY': u'610579', u'EOY': u'253883'} | \n", "NaN | \n", "253883 | \n", "
3425 | \n", "FY2014 | \n", "1.162178 | \n", "124675 | \n", "{u'BOYAmt': u'271888', u'EOYAmt': u'124675'} | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "107277 | \n", "107277 | \n", "NaN | \n", "{u'BOYAmt': u'440094', u'EOYAmt': u'107277'} | \n", "NaN | \n", "107277 | \n", "NaN | \n", "
25435 | \n", "FY2014 | \n", "1.426897 | \n", "312031 | \n", "{u'BOYAmt': u'94893', u'EOYAmt': u'312031'} | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "218678 | \n", "218678 | \n", "NaN | \n", "{u'BOYAmt': u'608360', u'EOYAmt': u'218678'} | \n", "NaN | \n", "218678 | \n", "NaN | \n", "
1853 | \n", "FY2014 | \n", "1.013958 | \n", "685532 | \n", "{u'BOYAmt': u'499406', u'EOYAmt': u'685532'} | \n", "NaN | \n", "0 | \n", "NaN | \n", "NaN | \n", "676095 | \n", "676095 | \n", "NaN | \n", "{u'BOYAmt': u'426629', u'EOYAmt': u'676095'} | \n", "NaN | \n", "676095 | \n", "NaN | \n", "
1872 | \n", "FY2014 | \n", "1.001405 | \n", "2144621 | \n", "{u'BOYAmt': u'1579409', u'EOYAmt': u'2144621'} | \n", "NaN | \n", "6644457 | \n", "{u'BOYAmt': u'6501148', u'EOYAmt': u'6644457'} | \n", "NaN | \n", "8776750 | \n", "8776750 | \n", "NaN | \n", "{u'BOYAmt': u'8480604', u'EOYAmt': u'8776750'} | \n", "NaN | \n", "8776750 | \n", "NaN | \n", "
1938 | \n", "FY2014 | \n", "1.001405 | \n", "2144621 | \n", "{u'BOYAmt': u'1579409', u'EOYAmt': u'2144621'} | \n", "NaN | \n", "6644457 | \n", "{u'BOYAmt': u'6501148', u'EOYAmt': u'6644457'} | \n", "NaN | \n", "8776750 | \n", "8776750 | \n", "NaN | \n", "{u'BOYAmt': u'8480604', u'EOYAmt': u'8776750'} | \n", "NaN | \n", "8776750 | \n", "NaN | \n", "
\n", " | FeesForServicesAccounting_TotalAmt | \n", "
---|---|
25894 | \n", "-2500.0 | \n", "
24536 | \n", "-67439.0 | \n", "
1466 | \n", "-48284.0 | \n", "
12588 | \n", "-44250.0 | \n", "
\n", " | EIN | \n", "FYE | \n", "VotingMembersGoverningBodyCnt | \n", "NbrVotingMembersGoverningBody | \n", "VotingMembersIndependentCnt | \n", "NbrIndependentVotingMembers | \n", "DelegationOfMgmtDutiesInd | \n", "DelegationOfManagementDuties | \n", "Form990ProvidedToGvrnBodyInd | \n", "Form990ProvidedToGoverningBody | \n", "AuditCommitteeInd | \n", "AuditCommittee | \n", "perm_rest_assets | \n", "temp_rest_assets | \n", "net_assets | \n", "donor_restrictions | \n", "TaxExemptBondsInd | \n", "TaxExemptBonds | \n", "NetUnrelatedBusTxblIncmAmt | \n", "NetUnrelatedBusinessTxblIncome | \n", "FSAuditedInd | \n", "FSAudited | \n", "FederalGrantAuditPerformedInd | \n", "FederalGrantAuditPerformed | \n", "FederalGrantAuditRequiredInd | \n", "FederalGrantAuditRequired | \n", "IndependentAuditFinclStmtInd | \n", "IndependentAuditFinancialStmt | \n", "FeesForServicesAccounting_binary | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27377 | \n", "840516736 | \n", "FY2014 | \n", "10 | \n", "NaN | \n", "9 | \n", "NaN | \n", "false | \n", "NaN | \n", "true | \n", "NaN | \n", "true | \n", "NaN | \n", "260654 | \n", "0 | \n", "0 | \n", "inf | \n", "false | \n", "NaN | \n", "NaN | \n", "NaN | \n", "true | \n", "NaN | \n", "NaN | \n", "NaN | \n", "false | \n", "NaN | \n", "{u'#text': u'true', u'@referenceDocumentId': u'00000004', u'@referenceDocumentName': u'IRS990ScheduleD'} | \n", "NaN | \n", "0 | \n", "
\n", " | EIN | \n", "FYE | \n", "VotingMembersGoverningBodyCnt | \n", "NbrVotingMembersGoverningBody | \n", "VotingMembersIndependentCnt | \n", "NbrIndependentVotingMembers | \n", "DelegationOfMgmtDutiesInd | \n", "DelegationOfManagementDuties | \n", "Form990ProvidedToGvrnBodyInd | \n", "Form990ProvidedToGoverningBody | \n", "AuditCommitteeInd | \n", "AuditCommittee | \n", "perm_rest_assets | \n", "temp_rest_assets | \n", "net_assets | \n", "donor_restrictions | \n", "TaxExemptBondsInd | \n", "TaxExemptBonds | \n", "NetUnrelatedBusTxblIncmAmt | \n", "NetUnrelatedBusinessTxblIncome | \n", "FSAuditedInd | \n", "FSAudited | \n", "FederalGrantAuditPerformedInd | \n", "FederalGrantAuditPerformed | \n", "FederalGrantAuditRequiredInd | \n", "FederalGrantAuditRequired | \n", "IndependentAuditFinclStmtInd | \n", "IndependentAuditFinancialStmt | \n", "FeesForServicesAccounting_binary | \n", "FamilyOrBusinessRlnInd | \n", "FamilyOrBusinessRelationship | \n", "TaxExemptBondLiabilitiesGrp | \n", "TaxExemptBondLiabilities | \n", "GovernmentGrantsAmt | \n", "GovernmentGrants | \n", "ElectionOfBoardMembersInd | \n", "ElectionOfBoardMembers | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18819 | \n", "010202467 | \n", "FY2014 | \n", "22 | \n", "NaN | \n", "21 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "4433997 | \n", "7351259 | \n", "23690097 | \n", "0.50 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1053100001'} | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "1 | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "7932282 | \n", "NaN | \n", "1 | \n", "NaN | \n", "
7965 | \n", "010202467 | \n", "FY2013 | \n", "21 | \n", "NaN | \n", "21 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "4193257 | \n", "5880227 | \n", "21657900 | \n", "0.47 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1053100001'} | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "NaN | \n", "1 | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "6258147 | \n", "NaN | \n", "1 | \n", "NaN | \n", "
8989 | \n", "010202467 | \n", "FY2012 | \n", "NaN | \n", "20 | \n", "NaN | \n", "20 | \n", "NaN | \n", "1 | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "4153627 | \n", "5773597 | \n", "22130919 | \n", "0.45 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1053100001'} | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "7295185 | \n", "NaN | \n", "1 | \n", "
22904 | \n", "010202467 | \n", "FY2011 | \n", "NaN | \n", "23 | \n", "NaN | \n", "23 | \n", "NaN | \n", "1 | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "3096087 | \n", "6554891 | \n", "20486698 | \n", "0.47 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1053100001'} | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "9819406 | \n", "NaN | \n", "1 | \n", "
19649 | \n", "010202467 | \n", "FY2010 | \n", "NaN | \n", "24 | \n", "NaN | \n", "24 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "2873816 | \n", "7110362 | \n", "17935900 | \n", "0.56 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1053100001'} | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1039900001'} | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "7006788 | \n", "NaN | \n", "1 | \n", "
\n", " | EIN | \n", "FYE | \n", "VotingMembersGoverningBodyCnt | \n", "NbrVotingMembersGoverningBody | \n", "VotingMembersIndependentCnt | \n", "NbrIndependentVotingMembers | \n", "DelegationOfMgmtDutiesInd | \n", "DelegationOfManagementDuties | \n", "Form990ProvidedToGvrnBodyInd | \n", "Form990ProvidedToGoverningBody | \n", "AuditCommitteeInd | \n", "AuditCommittee | \n", "perm_rest_assets | \n", "temp_rest_assets | \n", "net_assets | \n", "donor_restrictions | \n", "TaxExemptBondsInd | \n", "TaxExemptBonds | \n", "NetUnrelatedBusTxblIncmAmt | \n", "NetUnrelatedBusinessTxblIncome | \n", "FSAuditedInd | \n", "FSAudited | \n", "FederalGrantAuditPerformedInd | \n", "FederalGrantAuditPerformed | \n", "FederalGrantAuditRequiredInd | \n", "FederalGrantAuditRequired | \n", "IndependentAuditFinclStmtInd | \n", "IndependentAuditFinancialStmt | \n", "FeesForServicesAccounting_binary | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23577 | \n", "990350803 | \n", "FY2012 | \n", "NaN | \n", "11 | \n", "NaN | \n", "11 | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "100000 | \n", "467396 | \n", "2441674 | \n", "0.232380 | \n", "NaN | \n", "0 | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "1 | \n", "
16294 | \n", "990350803 | \n", "FY2011 | \n", "NaN | \n", "11 | \n", "NaN | \n", "11 | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "0 | \n", "171880 | \n", "1953372 | \n", "0.087991 | \n", "NaN | \n", "0 | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "1 | \n", "
26647 | \n", "990350803 | \n", "FY2010 | \n", "NaN | \n", "7 | \n", "NaN | \n", "7 | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "0 | \n", "96956 | \n", "1720152 | \n", "0.056365 | \n", "NaN | \n", "0 | \n", "NaN | \n", "0 | \n", "NaN | \n", "0 | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "1 | \n", "
\n", " | EIN | \n", "FYE | \n", "VotingMembersGoverningBodyCnt | \n", "NbrVotingMembersGoverningBody | \n", "VotingMembersIndependentCnt | \n", "NbrIndependentVotingMembers | \n", "DelegationOfMgmtDutiesInd | \n", "DelegationOfManagementDuties | \n", "Form990ProvidedToGvrnBodyInd | \n", "Form990ProvidedToGoverningBody | \n", "AuditCommitteeInd | \n", "AuditCommittee | \n", "perm_rest_assets | \n", "temp_rest_assets | \n", "net_assets | \n", "donor_restrictions | \n", "TaxExemptBondsInd | \n", "TaxExemptBonds | \n", "NetUnrelatedBusTxblIncmAmt | \n", "NetUnrelatedBusinessTxblIncome | \n", "FSAuditedInd | \n", "FSAudited | \n", "FederalGrantAuditPerformedInd | \n", "FederalGrantAuditPerformed | \n", "FederalGrantAuditRequiredInd | \n", "FederalGrantAuditRequired | \n", "IndependentAuditFinclStmtInd | \n", "IndependentAuditFinancialStmt | \n", "FeesForServicesAccounting_binary | \n", "FamilyOrBusinessRlnInd | \n", "FamilyOrBusinessRelationship | \n", "TaxExemptBondLiabilitiesGrp | \n", "TaxExemptBondLiabilities | \n", "GovernmentGrantsAmt | \n", "GovernmentGrants | \n", "ElectionOfBoardMembersInd | \n", "ElectionOfBoardMembers | \n", "CYTotalFundraisingExpenseAmt | \n", "TotalFundrsngExpCurrentYear | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "010202467 | \n", "FY2014 | \n", "22 | \n", "20 | \n", "21 | \n", "20 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "4433997 | \n", "7351259 | \n", "23690097 | \n", "0.50 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1053100001'} | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1053100001'} | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "1 | \n", "0 | \n", "1 | \n", "NaN | \n", "NaN | \n", "7932282 | \n", "7295185 | \n", "1 | \n", "1 | \n", "554608 | \n", "358835 | \n", "
1 | \n", "010211478 | \n", "FY2015 | \n", "18 | \n", "18 | \n", "18 | \n", "18 | \n", "false | \n", "false | \n", "true | \n", "true | \n", "true | \n", "true | \n", "2717000 | \n", "908556 | \n", "4804612 | \n", "0.75 | \n", "false | \n", "false | \n", "NaN | \n", "NaN | \n", "true | \n", "true | \n", "NaN | \n", "NaN | \n", "false | \n", "false | \n", "{u'#text': u'true', u'@referenceDocumentId': u'RetDoc3'} | \n", "{u'#text': u'true', u'@referenceDocumentId': u'RetDoc3'} | \n", "0 | \n", "false | \n", "false | \n", "NaN | \n", "NaN | \n", "42442 | \n", "129755 | \n", "false | \n", "false | \n", "415743 | \n", "363139 | \n", "
2 | \n", "010211513 | \n", "FY2014 | \n", "23 | \n", "22 | \n", "21 | \n", "20 | \n", "false | \n", "false | \n", "true | \n", "true | \n", "true | \n", "true | \n", "15329657 | \n", "38570318 | \n", "492985953 | \n", "0.11 | \n", "{u'#text': u'true', u'@referenceDocumentId': u'IRS990ScheduleK'} | \n", "{u'#text': u'true', u'@referenceDocumentId': u'IRS990ScheduleK'} | \n", "-57641 | \n", "-12313 | \n", "true | \n", "true | \n", "true | \n", "true | \n", "true | \n", "true | \n", "{u'#text': u'true', u'@referenceDocumentId': u'IRS990ScheduleD'} | \n", "{u'#text': u'true', u'@referenceDocumentId': u'IRS990ScheduleD'} | \n", "1 | \n", "false | \n", "true | \n", "{u'BOYAmt': u'106014868', u'EOYAmt': u'104647760'} | \n", "{u'BOY': u'77905017', u'EOY': u'109371484'} | \n", "77323736 | \n", "57810755 | \n", "false | \n", "false | \n", "3474538 | \n", "2402953 | \n", "
3 | \n", "010211530 | \n", "FY2014 | \n", "28 | \n", "29 | \n", "28 | \n", "29 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "477857 | \n", "1161177 | \n", "12763602 | \n", "0.13 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "NaN | \n", "NaN | \n", "0 | \n", "0 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "237183 | \n", "318383 | \n", "1 | \n", "1 | \n", "181290 | \n", "255685 | \n", "
4 | \n", "010211543 | \n", "FY2014 | \n", "35 | \n", "34 | \n", "35 | \n", "34 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "779327 | \n", "4259694 | \n", "16702601 | \n", "0.30 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "NaN | \n", "NaN | \n", "0 | \n", "0 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "1 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "94663 | \n", "113548 | \n", "0 | \n", "0 | \n", "150504 | \n", "103085 | \n", "
\n", " | EIN | \n", "FYE | \n", "VotingMembersGoverningBodyCnt | \n", "NbrVotingMembersGoverningBody | \n", "VotingMembersIndependentCnt | \n", "NbrIndependentVotingMembers | \n", "DelegationOfMgmtDutiesInd | \n", "DelegationOfManagementDuties | \n", "Form990ProvidedToGvrnBodyInd | \n", "Form990ProvidedToGoverningBody | \n", "AuditCommitteeInd | \n", "AuditCommittee | \n", "perm_rest_assets | \n", "temp_rest_assets | \n", "net_assets | \n", "donor_restrictions | \n", "TaxExemptBondsInd | \n", "TaxExemptBonds | \n", "NetUnrelatedBusTxblIncmAmt | \n", "NetUnrelatedBusinessTxblIncome | \n", "FSAuditedInd | \n", "FSAudited | \n", "FederalGrantAuditPerformedInd | \n", "FederalGrantAuditPerformed | \n", "FederalGrantAuditRequiredInd | \n", "FederalGrantAuditRequired | \n", "IndependentAuditFinclStmtInd | \n", "IndependentAuditFinancialStmt | \n", "FeesForServicesAccounting_binary | \n", "FamilyOrBusinessRlnInd | \n", "FamilyOrBusinessRelationship | \n", "TaxExemptBondLiabilitiesGrp | \n", "TaxExemptBondLiabilities | \n", "GovernmentGrantsAmt | \n", "GovernmentGrants | \n", "ElectionOfBoardMembersInd | \n", "ElectionOfBoardMembers | \n", "independent_directors_num | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35 | \n", "010679337 | \n", "FY2013 | \n", "NaN | \n", "11 | \n", "NaN | \n", "10 | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "111972495 | \n", "584038945 | \n", "1137256059 | \n", "0.61 | \n", "NaN | \n", "0 | \n", "NaN | \n", "30871 | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1039900001'} | \n", "1 | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "237833 | \n", "NaN | \n", "0 | \n", "10 | \n", "
65 | \n", "026015642 | \n", "FY2012 | \n", "NaN | \n", "24 | \n", "NaN | \n", "24 | \n", "NaN | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "1 | \n", "0 | \n", "243648 | \n", "1047304 | \n", "0.23 | \n", "NaN | \n", "0 | \n", "NaN | \n", "-34607 | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "NaN | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "0 | \n", "NaN | \n", "1 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "24 | \n", "
\n", " | EIN | \n", "FYE | \n", "VotingMembersGoverningBodyCnt | \n", "NbrVotingMembersGoverningBody | \n", "VotingMembersIndependentCnt | \n", "NbrIndependentVotingMembers | \n", "DelegationOfMgmtDutiesInd | \n", "DelegationOfManagementDuties | \n", "Form990ProvidedToGvrnBodyInd | \n", "Form990ProvidedToGoverningBody | \n", "AuditCommitteeInd | \n", "AuditCommittee | \n", "perm_rest_assets | \n", "temp_rest_assets | \n", "net_assets | \n", "donor_restrictions | \n", "TaxExemptBondsInd | \n", "TaxExemptBonds | \n", "NetUnrelatedBusTxblIncmAmt | \n", "NetUnrelatedBusinessTxblIncome | \n", "FSAuditedInd | \n", "FSAudited | \n", "FederalGrantAuditPerformedInd | \n", "FederalGrantAuditPerformed | \n", "FederalGrantAuditRequiredInd | \n", "FederalGrantAuditRequired | \n", "IndependentAuditFinclStmtInd | \n", "IndependentAuditFinancialStmt | \n", "FeesForServicesAccounting_binary | \n", "FamilyOrBusinessRlnInd | \n", "FamilyOrBusinessRelationship | \n", "TaxExemptBondLiabilitiesGrp | \n", "TaxExemptBondLiabilities | \n", "GovernmentGrantsAmt | \n", "GovernmentGrants | \n", "ElectionOfBoardMembersInd | \n", "ElectionOfBoardMembers | \n", "independent_directors_num | \n", "voting_directors | \n", "independent_directors_pct | \n", "
---|
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
perm_rest_assets | \n", "7133.00 | \n", "5398758.08 | \n", "34888704.49 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1033359.00 | \n", "1097020543.00 | \n", "
temp_rest_assets | \n", "7133.00 | \n", "7347199.39 | \n", "40974295.28 | \n", "-1417569.00 | \n", "119999.00 | \n", "660803.00 | \n", "2879306.00 | \n", "1473750677.00 | \n", "
net_assets | \n", "7133.00 | \n", "31409548.61 | \n", "175347462.23 | \n", "-139954787.00 | \n", "1766750.00 | \n", "5157328.00 | \n", "15828642.00 | \n", "7982613662.00 | \n", "
donor_restrictions | \n", "7133.00 | \n", "inf | \n", "nan | \n", "-156.44 | \n", "0.06 | \n", "0.24 | \n", "0.55 | \n", "inf | \n", "
FeesForServicesAccounting_binary | \n", "7133.00 | \n", "0.83 | \n", "0.38 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
independent_directors_num | \n", "7133.00 | \n", "21.45 | \n", "34.58 | \n", "0.00 | \n", "11.00 | \n", "17.00 | \n", "26.00 | \n", "2500.00 | \n", "
voting_directors | \n", "7133.00 | \n", "21.70 | \n", "18.27 | \n", "0.00 | \n", "12.00 | \n", "18.00 | \n", "26.00 | \n", "434.00 | \n", "
independent_directors_pct | \n", "7133.00 | \n", "0.97 | \n", "1.09 | \n", "0.00 | \n", "0.96 | \n", "1.00 | \n", "1.00 | \n", "92.59 | \n", "
independent_directors_pct_v2 | \n", "7133.00 | \n", "0.95 | \n", "0.13 | \n", "0.00 | \n", "0.96 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
outsourced_mgt | \n", "7133.00 | \n", "0.02 | \n", "0.13 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "
990_review | \n", "7133.00 | \n", "0.90 | \n", "0.30 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
audit_committee | \n", "7133.00 | \n", "0.93 | \n", "0.25 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
\n", " | EIN | \n", "FYE | \n", "VotingMembersGoverningBodyCnt | \n", "NbrVotingMembersGoverningBody | \n", "VotingMembersIndependentCnt | \n", "NbrIndependentVotingMembers | \n", "DelegationOfMgmtDutiesInd | \n", "DelegationOfManagementDuties | \n", "Form990ProvidedToGvrnBodyInd | \n", "Form990ProvidedToGoverningBody | \n", "AuditCommitteeInd | \n", "AuditCommittee | \n", "perm_rest_assets | \n", "temp_rest_assets | \n", "net_assets | \n", "donor_restrictions | \n", "TaxExemptBondsInd | \n", "TaxExemptBonds | \n", "NetUnrelatedBusTxblIncmAmt | \n", "NetUnrelatedBusinessTxblIncome | \n", "FSAuditedInd | \n", "FSAudited | \n", "FederalGrantAuditPerformedInd | \n", "FederalGrantAuditPerformed | \n", "FederalGrantAuditRequiredInd | \n", "FederalGrantAuditRequired | \n", "IndependentAuditFinclStmtInd | \n", "IndependentAuditFinancialStmt | \n", "FeesForServicesAccounting_binary | \n", "FamilyOrBusinessRlnInd | \n", "FamilyOrBusinessRelationship | \n", "TaxExemptBondLiabilitiesGrp | \n", "TaxExemptBondLiabilities | \n", "GovernmentGrantsAmt | \n", "GovernmentGrants | \n", "ElectionOfBoardMembersInd | \n", "ElectionOfBoardMembers | \n", "independent_directors_num | \n", "voting_directors | \n", "independent_directors_pct | \n", "independent_directors_pct_v2 | \n", "outsourced_mgt | \n", "990_review | \n", "audit_committee | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5939 | \n", "840516736 | \n", "FY2014 | \n", "10 | \n", "10 | \n", "9 | \n", "9 | \n", "false | \n", "false | \n", "true | \n", "true | \n", "true | \n", "true | \n", "260654 | \n", "0 | \n", "0 | \n", "inf | \n", "false | \n", "false | \n", "NaN | \n", "NaN | \n", "true | \n", "true | \n", "NaN | \n", "NaN | \n", "false | \n", "false | \n", "{u'#text': u'true', u'@referenceDocumentId': u'00000004', u'@referenceDocumentName': u'IRS990ScheduleD'} | \n", "{u'#text': u'true', u'@referenceDocumentId': u'00000004', u'@referenceDocumentName': u'IRS990ScheduleD'} | \n", "0 | \n", "true | \n", "false | \n", "NaN | \n", "NaN | \n", "NaN | \n", "5644 | \n", "false | \n", "false | \n", "9 | \n", "10 | \n", "0.90 | \n", "0.90 | \n", "0 | \n", "1 | \n", "1 | \n", "
\n", " | EIN | \n", "FYE | \n", "VotingMembersGoverningBodyCnt | \n", "NbrVotingMembersGoverningBody | \n", "VotingMembersIndependentCnt | \n", "NbrIndependentVotingMembers | \n", "DelegationOfMgmtDutiesInd | \n", "DelegationOfManagementDuties | \n", "Form990ProvidedToGvrnBodyInd | \n", "Form990ProvidedToGoverningBody | \n", "AuditCommitteeInd | \n", "AuditCommittee | \n", "perm_rest_assets | \n", "temp_rest_assets | \n", "net_assets | \n", "donor_restrictions | \n", "TaxExemptBondsInd | \n", "TaxExemptBonds | \n", "NetUnrelatedBusTxblIncmAmt | \n", "NetUnrelatedBusinessTxblIncome | \n", "FSAuditedInd | \n", "FSAudited | \n", "FederalGrantAuditPerformedInd | \n", "FederalGrantAuditPerformed | \n", "FederalGrantAuditRequiredInd | \n", "FederalGrantAuditRequired | \n", "IndependentAuditFinclStmtInd | \n", "IndependentAuditFinancialStmt | \n", "FeesForServicesAccounting_binary | \n", "independent_directors_num | \n", "voting_directors | \n", "independent_directors_pct | \n", "outsourced_mgt | \n", "990_review | \n", "audit_committee | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
435 | \n", "061343149 | \n", "FY2015 | \n", "30 | \n", "24 | \n", "28 | \n", "22 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "38420 | \n", "478 | \n", "80.376569 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "NaN | \n", "NaN | \n", "0 | \n", "0 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "1 | \n", "28 | \n", "30 | \n", "0.933333 | \n", "0 | \n", "1 | \n", "1 | \n", "
3907 | \n", "521591381 | \n", "FY2014 | \n", "13 | \n", "14 | \n", "12 | \n", "13 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "1893106 | \n", "137848 | \n", "13.733286 | \n", "0 | \n", "0 | \n", "-1009 | \n", "880 | \n", "1 | \n", "1 | \n", "NaN | \n", "NaN | \n", "0 | \n", "0 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "1 | \n", "12 | \n", "13 | \n", "0.923077 | \n", "0 | \n", "1 | \n", "1 | \n", "
4438 | \n", "570761297 | \n", "FY2015 | \n", "24 | \n", "23 | \n", "21 | \n", "23 | \n", "false | \n", "false | \n", "false | \n", "true | \n", "true | \n", "true | \n", "224809 | \n", "122436 | \n", "21241 | \n", "16.347865 | \n", "false | \n", "false | \n", "0 | \n", "0 | \n", "true | \n", "false | \n", "NaN | \n", "NaN | \n", "false | \n", "false | \n", "{u'#text': u'true', u'@referenceDocumentId': u'RetDoc4'} | \n", "false | \n", "1 | \n", "21 | \n", "24 | \n", "0.875000 | \n", "0 | \n", "0 | \n", "1 | \n", "
5358 | \n", "730568096 | \n", "FY2014 | \n", "11 | \n", "11 | \n", "11 | \n", "11 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "521821 | \n", "1082185 | \n", "63200 | \n", "25.379842 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "NaN | \n", "false | \n", "0 | \n", "0 | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "1 | \n", "11 | \n", "11 | \n", "1.000000 | \n", "0 | \n", "1 | \n", "1 | \n", "
7045 | \n", "954291515 | \n", "FY2014 | \n", "6 | \n", "9 | \n", "4 | \n", "7 | \n", "0 | \n", "true | \n", "1 | \n", "true | \n", "1 | \n", "false | \n", "0 | \n", "5844708 | \n", "503140 | \n", "11.616465 | \n", "0 | \n", "false | \n", "0 | \n", "0 | \n", "1 | \n", "true | \n", "1 | \n", "true | \n", "1 | \n", "true | \n", "{u'#text': u'0', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "{u'#text': u'true', u'@referenceDocumentId': u'IRS990ScheduleD'} | \n", "0 | \n", "4 | \n", "6 | \n", "0.666667 | \n", "0 | \n", "1 | \n", "1 | \n", "
\n", " | EIN | \n", "FYE | \n", "VotingMembersGoverningBodyCnt | \n", "NbrVotingMembersGoverningBody | \n", "VotingMembersIndependentCnt | \n", "NbrIndependentVotingMembers | \n", "DelegationOfMgmtDutiesInd | \n", "DelegationOfManagementDuties | \n", "Form990ProvidedToGvrnBodyInd | \n", "Form990ProvidedToGoverningBody | \n", "AuditCommitteeInd | \n", "AuditCommittee | \n", "perm_rest_assets | \n", "temp_rest_assets | \n", "net_assets | \n", "donor_restrictions | \n", "TaxExemptBondsInd | \n", "TaxExemptBonds | \n", "NetUnrelatedBusTxblIncmAmt | \n", "NetUnrelatedBusinessTxblIncome | \n", "FSAuditedInd | \n", "FSAudited | \n", "FederalGrantAuditPerformedInd | \n", "FederalGrantAuditPerformed | \n", "FederalGrantAuditRequiredInd | \n", "FederalGrantAuditRequired | \n", "IndependentAuditFinclStmtInd | \n", "IndependentAuditFinancialStmt | \n", "FeesForServicesAccounting_binary | \n", "FamilyOrBusinessRlnInd | \n", "FamilyOrBusinessRelationship | \n", "TaxExemptBondLiabilitiesGrp | \n", "TaxExemptBondLiabilities | \n", "GovernmentGrantsAmt | \n", "GovernmentGrants | \n", "ElectionOfBoardMembersInd | \n", "ElectionOfBoardMembers | \n", "independent_directors_num | \n", "voting_directors | \n", "independent_directors_pct | \n", "independent_directors_pct_v2 | \n", "outsourced_mgt | \n", "990_review | \n", "audit_committee | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "010202467 | \n", "FY2014 | \n", "22 | \n", "20 | \n", "21 | \n", "20 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "4433997 | \n", "7351259 | \n", "23690097 | \n", "0.50 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1053100001'} | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1053100001'} | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "1 | \n", "0 | \n", "1 | \n", "NaN | \n", "NaN | \n", "7932282 | \n", "7295185 | \n", "1 | \n", "1 | \n", "21 | \n", "22 | \n", "0.95 | \n", "0.95 | \n", "1 | \n", "1 | \n", "1 | \n", "
\n", " | perm_rest_assets | \n", "temp_rest_assets | \n", "restricted_donations | \n", "
---|---|---|---|
20 | \n", "23608300 | \n", "3240612 | \n", "1 | \n", "
21 | \n", "0 | \n", "8161109 | \n", "1 | \n", "
22 | \n", "153032 | \n", "1981180 | \n", "1 | \n", "
23 | \n", "0 | \n", "0 | \n", "0 | \n", "
24 | \n", "11057335 | \n", "14212432 | \n", "1 | \n", "
\n", " | FYE | \n", "TemporarilyRstrNetAssetsGrp | \n", "TemporarilyRestrictedNetAssets | \n", "PermanentlyRstrNetAssetsGrp | \n", "PermanentlyRestrictedNetAssets | \n", "UnrestrictedNetAssetsGrp | \n", "UnrestrictedNetAssets | \n", "TotalNetAssetsFundBalanceGrp | \n", "TotalNetAssetsFundBalances | \n", "NetAssetsOrFundBalancesBOYAmt | \n", "NetAssetsOrFundBalancesBOY | \n", "NetAssetsOrFundBalancesEOYAmt | \n", "NetAssetsOrFundBalancesEOY | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19137 | \n", "FY2014 | \n", "{u'BOYAmt': u'763419', u'EOYAmt': u'718875'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'BOYAmt': u'1114442', u'EOYAmt': u'1112268'} | \n", "NaN | \n", "{u'BOYAmt': u'1877861', u'EOYAmt': u'1831143'} | \n", "NaN | \n", "1877861 | \n", "NaN | \n", "1831143 | \n", "NaN | \n", "
4153 | \n", "FY2013 | \n", "{u'BOYAmt': u'568056', u'EOYAmt': u'763419'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'BOYAmt': u'969792', u'EOYAmt': u'1114442'} | \n", "NaN | \n", "{u'BOYAmt': u'1537848', u'EOYAmt': u'1877861'} | \n", "NaN | \n", "1537848 | \n", "NaN | \n", "1877861 | \n", "NaN | \n", "
4696 | \n", "FY2012 | \n", "NaN | \n", "{u'BOY': u'489517', u'EOY': u'568056'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'BOY': u'1227268', u'EOY': u'969792'} | \n", "NaN | \n", "{u'BOY': u'1716785', u'EOY': u'1537848'} | \n", "NaN | \n", "1716785 | \n", "NaN | \n", "1537848 | \n", "
22671 | \n", "FY2011 | \n", "NaN | \n", "{u'BOY': u'472102', u'EOY': u'489517'} | \n", "NaN | \n", "NaN | \n", "NaN | \n", "{u'BOY': u'1451414', u'EOY': u'1227268'} | \n", "NaN | \n", "{u'BOY': u'1923516', u'EOY': u'1716785'} | \n", "NaN | \n", "1923516 | \n", "NaN | \n", "1716785 | \n", "
\n", " | TaxExemptBondLiabilitiesGrp | \n", "TaxExemptBondLiabilities | \n", "tax_exempt_bond | \n", "
---|---|---|---|
2 | \n", "{u'BOYAmt': u'106014868', u'EOYAmt': u'104647760'} | \n", "{u'BOY': u'77905017', u'EOY': u'109371484'} | \n", "1 | \n", "
3 | \n", "NaN | \n", "NaN | \n", "0 | \n", "
\n", " | EIN | \n", "FYE | \n", "VotingMembersGoverningBodyCnt | \n", "NbrVotingMembersGoverningBody | \n", "VotingMembersIndependentCnt | \n", "NbrIndependentVotingMembers | \n", "DelegationOfMgmtDutiesInd | \n", "DelegationOfManagementDuties | \n", "Form990ProvidedToGvrnBodyInd | \n", "Form990ProvidedToGoverningBody | \n", "AuditCommitteeInd | \n", "AuditCommittee | \n", "perm_rest_assets | \n", "temp_rest_assets | \n", "net_assets | \n", "donor_restrictions | \n", "TaxExemptBondsInd | \n", "TaxExemptBonds | \n", "NetUnrelatedBusTxblIncmAmt | \n", "NetUnrelatedBusinessTxblIncome | \n", "FSAuditedInd | \n", "FSAudited | \n", "FederalGrantAuditPerformedInd | \n", "FederalGrantAuditPerformed | \n", "FederalGrantAuditRequiredInd | \n", "FederalGrantAuditRequired | \n", "IndependentAuditFinclStmtInd | \n", "IndependentAuditFinancialStmt | \n", "FeesForServicesAccounting_binary | \n", "FamilyOrBusinessRlnInd | \n", "FamilyOrBusinessRelationship | \n", "TaxExemptBondLiabilitiesGrp | \n", "TaxExemptBondLiabilities | \n", "GovernmentGrantsAmt | \n", "GovernmentGrants | \n", "ElectionOfBoardMembersInd | \n", "ElectionOfBoardMembers | \n", "independent_directors_num | \n", "voting_directors | \n", "independent_directors_pct | \n", "independent_directors_pct_v2 | \n", "outsourced_mgt | \n", "990_review | \n", "audit_committee | \n", "restricted_donations | \n", "tax_exempt_bond | \n", "taxable_revenue | \n", "taxable_revenue_binary | \n", "taxable_revenue_neg_or_pos_rev_binary | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "010202467 | \n", "FY2014 | \n", "22 | \n", "20 | \n", "21 | \n", "20 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "4433997 | \n", "7351259 | \n", "23690097 | \n", "0.50 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1053100001'} | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1053100001'} | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "1 | \n", "0 | \n", "1 | \n", "NaN | \n", "NaN | \n", "7932282 | \n", "7295185 | \n", "1 | \n", "1 | \n", "21 | \n", "22 | \n", "0.95 | \n", "0.95 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
\n", " | EIN | \n", "FYE | \n", "VotingMembersGoverningBodyCnt | \n", "NbrVotingMembersGoverningBody | \n", "VotingMembersIndependentCnt | \n", "NbrIndependentVotingMembers | \n", "DelegationOfMgmtDutiesInd | \n", "DelegationOfManagementDuties | \n", "Form990ProvidedToGvrnBodyInd | \n", "Form990ProvidedToGoverningBody | \n", "AuditCommitteeInd | \n", "AuditCommittee | \n", "perm_rest_assets | \n", "temp_rest_assets | \n", "net_assets | \n", "donor_restrictions | \n", "TaxExemptBondsInd | \n", "TaxExemptBonds | \n", "NetUnrelatedBusTxblIncmAmt | \n", "NetUnrelatedBusinessTxblIncome | \n", "FSAuditedInd | \n", "FSAudited | \n", "FederalGrantAuditPerformedInd | \n", "FederalGrantAuditPerformed | \n", "FederalGrantAuditRequiredInd | \n", "FederalGrantAuditRequired | \n", "IndependentAuditFinclStmtInd | \n", "IndependentAuditFinancialStmt | \n", "FeesForServicesAccounting_binary | \n", "FamilyOrBusinessRlnInd | \n", "FamilyOrBusinessRelationship | \n", "TaxExemptBondLiabilitiesGrp | \n", "TaxExemptBondLiabilities | \n", "GovernmentGrantsAmt | \n", "GovernmentGrants | \n", "ElectionOfBoardMembersInd | \n", "ElectionOfBoardMembers | \n", "independent_directors_num | \n", "voting_directors | \n", "independent_directors_pct | \n", "independent_directors_pct_v2 | \n", "outsourced_mgt | \n", "990_review | \n", "audit_committee | \n", "restricted_donations | \n", "tax_exempt_bond | \n", "taxable_revenue | \n", "taxable_revenue_binary | \n", "taxable_revenue_neg_or_pos_rev_binary | \n", "audited_financials | \n", "federal_grant_audit_performed | \n", "federal_grant_audit_required | \n", "independent_audited_fs | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "010202467 | \n", "FY2014 | \n", "22 | \n", "20 | \n", "21 | \n", "20 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "4433997 | \n", "7351259 | \n", "23690097 | \n", "0.50 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1053100001'} | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1053100001'} | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "{u'#text': u'1', u'@referenceDocumentId': u'RetDoc1040000001'} | \n", "1 | \n", "0 | \n", "1 | \n", "NaN | \n", "NaN | \n", "7932282 | \n", "7295185 | \n", "1 | \n", "1 | \n", "21 | \n", "22 | \n", "0.95 | \n", "0.95 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
\n", " | donor_advisory | \n", "donor_advisory_2016 | \n", "donor_advisory_2011_to_2016 | \n", "org_id | \n", "EIN | \n", "FYE | \n", "Form 990 FYE | \n", "ratings_system | \n", "2011_data | \n", "2016_data | \n", "conflict_of_interest_policy_v2 | \n", "records_retention_policy_v2 | \n", "whistleblower_policy_v2 | \n", "SOX_policies | \n", "SOX_policies_binary | \n", "SOX_policies_all_binary | \n", "program_efficiency | \n", "complexity | \n", "complexity_2011 | \n", "age | \n", "total_revenue_logged | \n", "category | \n", "state | \n", "tot_rev | \n", "category_Animals | \n", "category_Arts, Culture, Humanities | \n", "category_Community Development | \n", "category_Education | \n", "category_Environment | \n", "category_Health | \n", "category_Human Services | \n", "category_Human and Civil Rights | \n", "category_International | \n", "category_Religion | \n", "category_Research and Public Policy | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50709 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "5954 | \n", "010202467 | \n", "FY2014 | \n", "2014-12 | \n", "CN 2.1 | \n", "0.0 | \n", "1.0 | \n", "1.0 | \n", "1.0 | \n", "1.0 | \n", "3.0 | \n", "1.0 | \n", "1.0 | \n", "0.794457 | \n", "6.0 | \n", "NaN | \n", "62.0 | \n", "16.377993 | \n", "Research and Public Policy | \n", "ME | \n", "NaN | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "1.0 | \n", "
\n", " | Col1 | \n", "A2011_data | \n", "A2016_data | \n", "ein | \n", "fye | \n", "Form_990_FYE | \n", "SOX_policies | \n", "SOX_policies_all_binary | \n", "SOX_policies_binary | \n", "age | \n", "category | \n", "category_Animals | \n", "category_Arts__Culture__Humaniti | \n", "category_Community_Development | \n", "category_Education | \n", "category_Environment | \n", "category_Health | \n", "category_Human_Services | \n", "category_Human_and_Civil_Rights | \n", "category_International | \n", "category_Religion | \n", "category_Research_and_Public_Pol | \n", "complexity | \n", "complexity_2011 | \n", "conflict_of_interest_policy_v2 | \n", "donor_advisory | \n", "donor_advisory_2011_to_2016 | \n", "donor_advisory_2016 | \n", "org_id | \n", "program_efficiency | \n", "ratings_system | \n", "records_retention_policy_v2 | \n", "state | \n", "tot_rev | \n", "total_revenue_logged | \n", "whistleblower_policy_v2 | \n", "ncategory | \n", "revs | \n", "samused_ | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "50709 | \n", "0 | \n", "1 | \n", "010202467 | \n", "FY2014 | \n", "2014-12 | \n", "3.00 | \n", "1.00 | \n", "1.00 | \n", "62.00 | \n", "Research and Public Policy | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "6.00 | \n", "nan | \n", "1.00 | \n", "0 | \n", "0 | \n", "0 | \n", "5954 | \n", "0.79 | \n", "CN 2.1 | \n", "1.00 | \n", "ME | \n", "nan | \n", "16.38 | \n", "1.00 | \n", "Research and Public Policy | \n", "12967968.00 | \n", "1.00 | \n", "
\n", " | Col1 | \n", "A2011_data | \n", "A2016_data | \n", "ein | \n", "fye | \n", "Form_990_FYE | \n", "SOX_policies | \n", "SOX_policies_all_binary | \n", "SOX_policies_binary | \n", "age | \n", "category | \n", "category_Animals | \n", "category_Arts__Culture__Humaniti | \n", "category_Community_Development | \n", "category_Education | \n", "category_Environment | \n", "category_Health | \n", "category_Human_Services | \n", "category_Human_and_Civil_Rights | \n", "category_International | \n", "category_Religion | \n", "category_Research_and_Public_Pol | \n", "complexity | \n", "complexity_2011 | \n", "conflict_of_interest_policy_v2 | \n", "donor_advisory | \n", "donor_advisory_2011_to_2016 | \n", "donor_advisory_2016 | \n", "org_id | \n", "program_efficiency | \n", "ratings_system | \n", "records_retention_policy_v2 | \n", "state | \n", "tot_rev | \n", "total_revenue_logged | \n", "whistleblower_policy_v2 | \n", "ncategory | \n", "revs | \n", "samused_ | \n", "EIN_x | \n", "FYE | \n", "independent_directors_num | \n", "independent_directors_pct | \n", "independent_directors_pct_v2 | \n", "voting_directors | \n", "outsourced_mgt | \n", "990_review | \n", "audit_committee | \n", "perm_rest_assets | \n", "temp_rest_assets | \n", "net_assets | \n", "donor_restrictions | \n", "restricted_donations | \n", "tax_exempt_bond | \n", "taxable_revenue | \n", "taxable_revenue_binary | \n", "taxable_revenue_neg_or_pos_rev_binary | \n", "audited_financials | \n", "independent_audited_fs | \n", "federal_grant_audit_performed | \n", "federal_grant_audit_required | \n", "FeesForServicesAccounting_binary | \n", "no_relations | \n", "elected_board | \n", "government_grant | \n", "EIN_y | \n", "zero_FR | \n", "_merge | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "50709 | \n", "0 | \n", "1 | \n", "010202467 | \n", "FY2014 | \n", "2014-12 | \n", "3.00 | \n", "1.00 | \n", "1.00 | \n", "62.00 | \n", "Research and Public Policy | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "6.00 | \n", "nan | \n", "1.00 | \n", "0 | \n", "0 | \n", "0 | \n", "5954 | \n", "0.79 | \n", "CN 2.1 | \n", "1.00 | \n", "ME | \n", "nan | \n", "16.38 | \n", "1.00 | \n", "Research and Public Policy | \n", "12967968.00 | \n", "1.00 | \n", "010202467 | \n", "FY2014 | \n", "21.00 | \n", "0.95 | \n", "0.95 | \n", "22.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "4433997.00 | \n", "7351259.00 | \n", "23690097.00 | \n", "0.50 | \n", "1.00 | \n", "1.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1.00 | \n", "0 | \n", "1 | \n", "1.00 | \n", "010202467 | \n", "0.00 | \n", "both | \n", "
\n", " | Col1 | \n", "A2011_data | \n", "A2016_data | \n", "ein | \n", "fye | \n", "Form_990_FYE | \n", "SOX_policies | \n", "SOX_policies_all_binary | \n", "SOX_policies_binary | \n", "age | \n", "category | \n", "category_Animals | \n", "category_Arts__Culture__Humaniti | \n", "category_Community_Development | \n", "category_Education | \n", "category_Environment | \n", "category_Health | \n", "category_Human_Services | \n", "category_Human_and_Civil_Rights | \n", "category_International | \n", "category_Religion | \n", "category_Research_and_Public_Pol | \n", "complexity | \n", "complexity_2011 | \n", "conflict_of_interest_policy_v2 | \n", "donor_advisory | \n", "donor_advisory_2011_to_2016 | \n", "donor_advisory_2016 | \n", "org_id | \n", "program_efficiency | \n", "ratings_system | \n", "records_retention_policy_v2 | \n", "state | \n", "tot_rev | \n", "total_revenue_logged | \n", "whistleblower_policy_v2 | \n", "ncategory | \n", "revs | \n", "EIN | \n", "FYE | \n", "independent_directors_num | \n", "independent_directors_pct | \n", "voting_directors | \n", "outsourced_mgt | \n", "990_review | \n", "audit_committee | \n", "perm_rest_assets | \n", "temp_rest_assets | \n", "net_assets | \n", "donor_restrictions | \n", "tax_exempt_bond | \n", "taxable_revenue | \n", "taxable_revenue_binary | \n", "taxable_revenue_neg_or_pos_rev_binary | \n", "audited_financials | \n", "independent_audited_fs | \n", "federal_grant_audit_performed | \n", "federal_grant_audit_required | \n", "FeesForServicesAccounting_binary | \n", "_merge | \n", "independent_directors_pct_v2 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "50709 | \n", "0 | \n", "1 | \n", "010202467 | \n", "FY2014 | \n", "2014-12 | \n", "3.00 | \n", "1.00 | \n", "1.00 | \n", "62.00 | \n", "Research and Public Policy | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "6.00 | \n", "nan | \n", "1.00 | \n", "0 | \n", "0 | \n", "0 | \n", "5954 | \n", "0.79 | \n", "CN 2.1 | \n", "1.00 | \n", "ME | \n", "nan | \n", "16.38 | \n", "1.00 | \n", "Research and Public Policy | \n", "12967968.00 | \n", "010202467 | \n", "FY2014 | \n", "21.00 | \n", "0.95 | \n", "22.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "4433997.00 | \n", "7351259.00 | \n", "23690097.00 | \n", "0.50 | \n", "1.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1.00 | \n", "both | \n", "0.95 | \n", "