Pen Settings

HTML

CSS

CSS Base

Vendor Prefixing

Add External Stylesheets/Pens

Any URL's added here will be added as <link>s in order, and before the CSS in the editor. If you link to another Pen, it will include the CSS from that Pen. If the preprocessor matches, it will attempt to combine them before processing.

+ add another resource

JavaScript

Babel is required to process package imports. If you need a different preprocessor remove all packages first.

Add External Scripts/Pens

Any URL's added here will be added as <script>s in order, and run before the JavaScript in the editor. You can use the URL of any other Pen and it will include the JavaScript from that Pen.

+ add another resource

Behavior

Save Automatically?

If active, Pens will autosave every 30 seconds after being saved once.

Auto-Updating Preview

If enabled, the preview panel updates automatically as you code. If disabled, use the "Run" button to update.

Format on Save

If enabled, your code will be formatted when you actively save your Pen. Note: your code becomes un-folded during formatting.

Editor Settings

Code Indentation

Want to change your Syntax Highlighting theme, Fonts and more?

Visit your global Editor Settings.

HTML Settings

Here you can Sed posuere consectetur est at lobortis. Donec ullamcorper nulla non metus auctor fringilla. Maecenas sed diam eget risus varius blandit sit amet non magna. Donec id elit non mi porta gravida at eget metus. Praesent commodo cursus magna, vel scelerisque nisl consectetur et.

HTML

              
                <link href="https://cdn.webdatarocks.com/latest/webdatarocks.min.css" rel="stylesheet"/>
<script src="https://cdn.webdatarocks.com/latest/webdatarocks.toolbar.min.js"></script>
<script src="https://cdn.webdatarocks.com/latest/webdatarocks.js"></script>

<script src="https://cdn.webdatarocks.com/latest/webdatarocks.googlecharts.js"></script>
<script src="https://www.gstatic.com/charts/loader.js"></script>

<div id="wdr-component"></div>

<div id="bar-chart-container-1"></div>
              
            
!

CSS

              
                div#wdr-component {
  margin-bottom: 50px;
}
              
            
!

JS

              
                var pivot = new WebDataRocks({
    container: "#wdr-component",
    toolbar: true,
    height: 700,
    width: "100%",
    report: {
        "dataSource": {
            "data": getData()
        },
        "slice": {
            "reportFilters": [{
                    "uniqueName": "state"
                },
                {
                    "uniqueName": "organization_type"
                }
            ],
            "rows": [{
                    "uniqueName": "city"
                },
                {
                    "uniqueName": "charity_name"
                }
            ],
            "columns": [{
                "uniqueName": "Measures"
            }],
            "measures": [{
                    "uniqueName": "overall_score",
                    "aggregation": "sum"
                },
                {
                    "uniqueName": "net_assets",
                    "aggregation": "sum"
                },
                {
                    "uniqueName": "total_contributions",
                    "aggregation": "sum"
                },
                {
                    "uniqueName": "other_revenue",
                    "aggregation": "sum"
                },
                {
                    "uniqueName": "financial_score",
                    "aggregation": "sum"
                },
                {
                    "uniqueName": "program_expenses",
                    "aggregation": "sum"
                }
            ],
            "sorting": {
                "column": {
                    "type": "desc",
                    "tuple": [],
                    "measure": "net_assets"
                }
            },
            "expands": {
                "rows": [{
                        "tuple": [
                            "city.Seattle"
                        ]
                    },
                    {
                        "tuple": [
                            "city.Spring"
                        ]
                    },
                    {
                        "tuple": [
                            "city.State College"
                        ]
                    },
                    {
                        "tuple": [
                            "city.Houston"
                        ]
                    },
                    {
                        "tuple": [
                            "city.Portland"
                        ]
                    },
                    {
                        "tuple": [
                            "city.Washington"
                        ]
                    }
                ]
            }
        },
        "options": {
            "grid": {
                "type": "classic"
            }
        },
        "conditions": [
        {
            "formula": "#value > 3000000000",
            "measure": "net_assets",
            "format": {
                "backgroundColor": "#009000",
                "color": "#FFFFFF",
                "fontFamily": "Arial",
                "fontSize": "12px"
            }
        },
        {
            "formula": "#value > 1300",
            "measure": "overall_score",
            "format": {
                "backgroundColor": "#74C96A",
                "color": "#FFFFFF",
                "fontFamily": "Arial",
                "fontSize": "12px"
            }
        },
        {
            "formula": "#value > 7000000",
            "measure": "other_revenue",
            "format": {
                "backgroundColor": "#51BD48",
                "color": "#FFFFFF",
                "fontFamily": "Arial",
                "fontSize": "12px"
            }
        }
    ]
   },
    reportcomplete: function() {
        pivot.off("reportcomplete");
        pivotTableReportComplete = true;
        createBarChart();
    }
});

var pivotTableReportComplete = false;
var googleChartsLoaded = false;

google.charts.load('current', {
    'packages': ['corechart', 'bar']
});

google.charts.setOnLoadCallback(onGoogleChartsLoaded);

function onGoogleChartsLoaded() {
    googleChartsLoaded = true;
    if (pivotTableReportComplete) {
        createBarChart();
    }
}

function createBarChart() {
    if (googleChartsLoaded) {
        pivot.googlecharts.getData({
                type: "bar",
                "slice": {
                    "rows": [{
                        "uniqueName": "city",
                        "filter": {
                            "type": "top",
                            "quantity": 5,
                            "measure": "financial_score"
                        },
                        "sort": "unsorted"
                    }],
                    "columns": [{
                        "uniqueName": "Measures"
                    }],
                    "measures": [{
                        "uniqueName": "financial_score",
                        "aggregation": "sum"
                    }]
                },
            },
            drawBarChart,
            drawBarChart
        );
    }
}

function drawBarChart(_data) {
    var data = google.visualization.arrayToDataTable(_data.data);
    var formatter = new google.visualization.NumberFormat({
        fractionDigits: 2,
        prefix: '$'
    });
    formatter.format(data, 1);
    var options = {
        colors: ['#2A9D8F', '#E9C46A', '#E76F51'],
        bars: 'horizontal'
    };
    var chart = new google.charts.Bar(document.getElementById('bar-chart-container-1'));
    chart.draw(data, options);
}



function getData() {
    return [{
            "id": {
                "type": "string",
                "caption": "Id"
            },
            "accountability_score": {
                "type": "number",
                "caption": "Accountability Score"
            },
            "administrative_expenses": {
                "type": "number",
                "caption": "Administrative Expenses"
            },
            "charity_name": {
                "type": "string",
                "caption": "Charity Name"
            },
            "charity_url": {
                "type": "string",
                "caption": "Charity URL"
            },
            "city": {
                "type": "string",
                "caption": "City"
            },
            "cn_advisory": {
                "type": "string",
                "caption": "CN Advisory"
            },
            "compensation_leader_compensation": {
                "type": "number",
                "caption": "Compensation Leader Compensation"
            },
            "compensation_leader_expense_percent": {
                "type": "number",
                "caption": "Compensation Leader Expense Percent"
            },
            "compensation_leader_title": {
                "type": "string",
                "caption": "Compensation Leader Title"
            },
            "excess_or_deficit_for_year": {
                "type": "number",
                "caption": "Excess or Deficit for Year"
            },
            "financial_score": {
                "type": "number",
                "caption": "Financial Score"
            },
            "fundraising_expenses": {
                "type": "number",
                "caption": "Fundraising Expenses"
            },
            "net_assets": {
                "type": "number",
                "caption": "Net Assets"
            },
            "organization_type": {
                "type": "string",
                "caption": "Organization Type"
            },
            "other_revenue": {
                "type": "number",
                "caption": "Other Revenue"
            },
            "overall_score": {
                "type": "number",
                "caption": "Overall Score"
            },
            "payments_to_affiliates": {
                "type": "number",
                "caption": "Payments to Affiliates"
            },
            "program_expenses": {
                "type": "number",
                "caption": "Program Expenses"
            },
            "state": {
                "type": "string",
                "caption": "State"
            },
            "total_contributions": {
                "type": "number",
                "caption": "Total Contributions"
            }
        },
        {
            "id": 0,
            "accountability_score": 89,
            "administrative_expenses": 164590,
            "charity_name": "9to5 National Association of Working Women",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=14961",
            "city": "Milwaukee",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 53463,
            "compensation_leader_expense_percent": 3.11,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 349718,
            "financial_score": 90.56,
            "fundraising_expenses": 111522,
            "net_assets": 1350382,
            "organization_type": "Human and Civil Rights : Advocacy and Education",
            "other_revenue": 49634,
            "overall_score": 89.75,
            "payments_to_affiliates": 0,
            "program_expenses": 1440463,
            "state": "WI",
            "total_contributions": 1999023
        },
        {
            "id": 1,
            "accountability_score": 86,
            "administrative_expenses": 1001560,
            "charity_name": "'Aha Pūnana Leo",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=16012",
            "city": "Hilo",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 73500,
            "compensation_leader_expense_percent": 1.47,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 1175965,
            "financial_score": 85.92,
            "fundraising_expenses": 54613,
            "net_assets": 14773920,
            "organization_type": "Education : Early Childhood Programs and Services",
            "other_revenue": 382540,
            "overall_score": 85.95,
            "payments_to_affiliates": 0,
            "program_expenses": 3912270,
            "state": "HI",
            "total_contributions": 3339358
        },
        {
            "id": 2,
            "accountability_score": 85,
            "administrative_expenses": 93957,
            "charity_name": "AID FOR AIDS International",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=11185",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 85000,
            "compensation_leader_expense_percent": 0.99,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -461502,
            "financial_score": 77.65,
            "fundraising_expenses": 248833,
            "net_assets": -770370,
            "organization_type": "International : Development and Relief Services",
            "other_revenue": 0,
            "overall_score": 80.96,
            "payments_to_affiliates": 0,
            "program_expenses": 8157850,
            "state": "NY",
            "total_contributions": 8039138
        },
        {
            "id": 3,
            "accountability_score": 86,
            "administrative_expenses": 346867,
            "charity_name": "Futures in Education",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=17169",
            "city": "Brooklyn",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 61220,
            "compensation_leader_expense_percent": 0.78,
            "compensation_leader_title": "Acting Executive Director",
            "excess_or_deficit_for_year": 1872733,
            "financial_score": 97.5,
            "fundraising_expenses": 384550,
            "net_assets": 11460087,
            "organization_type": "Education : Scholarship and Financial Support ,",
            "other_revenue": -81726,
            "overall_score": 89.94,
            "payments_to_affiliates": 0,
            "program_expenses": 7018262,
            "state": "NY",
            "total_contributions": 9704138
        },
        {
            "id": 4,
            "accountability_score": 97,
            "administrative_expenses": 135195,
            "charity_name": "Every Generation Ministries",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=14080",
            "city": "Temecula",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 74244,
            "compensation_leader_expense_percent": 5.41,
            "compensation_leader_title": "President",
            "excess_or_deficit_for_year": -103940,
            "financial_score": 87.08,
            "fundraising_expenses": 87436,
            "net_assets": 723772,
            "organization_type": "Religion : Religious Activities",
            "other_revenue": 32436,
            "overall_score": 90.62,
            "payments_to_affiliates": 0,
            "program_expenses": 1148407,
            "state": "CA",
            "total_contributions": 1234662
        },
        {
            "id": 5,
            "accountability_score": 100,
            "administrative_expenses": 505751,
            "charity_name": "Futures Without Violence",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=6436",
            "city": "San Francisco",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 312498,
            "compensation_leader_expense_percent": 2.85,
            "compensation_leader_title": "President & Founder",
            "excess_or_deficit_for_year": 1931497,
            "financial_score": 93.14,
            "fundraising_expenses": 377933,
            "net_assets": 40621685,
            "organization_type": "Human and Civil Rights : Advocacy and Education",
            "other_revenue": 320916,
            "overall_score": 95.14,
            "payments_to_affiliates": 0,
            "program_expenses": 10059539,
            "state": "CA",
            "total_contributions": 12355178
        },
        {
            "id": 6,
            "accountability_score": 89,
            "administrative_expenses": 103173,
            "charity_name": "Gwinnett Habitat for Humanity",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=11467",
            "city": "Stone Mountain",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 85665,
            "compensation_leader_expense_percent": 7.27,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -126216,
            "financial_score": 99.94,
            "fundraising_expenses": 49542,
            "net_assets": 3579208,
            "organization_type": "Community Development : Housing and Neighborhood Development",
            "other_revenue": -13057,
            "overall_score": 92.22,
            "payments_to_affiliates": 33556,
            "program_expenses": 1024283,
            "state": "GA",
            "total_contributions": 536485
        },
        {
            "id": 7,
            "accountability_score": 100,
            "administrative_expenses": 663845,
            "charity_name": "Izaak Walton League of America",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=8974",
            "city": "Gaithersburg",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 154999,
            "compensation_leader_expense_percent": 6.01,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -294094,
            "financial_score": 79.94,
            "fundraising_expenses": 218404,
            "net_assets": 7474607,
            "organization_type": "Environment : Environmental Protection and Conservation",
            "other_revenue": 101537,
            "overall_score": 85.81,
            "payments_to_affiliates": 0,
            "program_expenses": 1695556,
            "state": "MD",
            "total_contributions": 2170503
        },
        {
            "id": 8,
            "accountability_score": 100,
            "administrative_expenses": 77155,
            "charity_name": "It's The Journey, Inc.",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=11793",
            "city": "Atlanta",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 110110,
            "compensation_leader_expense_percent": 7.36,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 107849,
            "financial_score": 89.98,
            "fundraising_expenses": 76939,
            "net_assets": 808446,
            "organization_type": "Health : Medical Research ,",
            "other_revenue": 10299,
            "overall_score": 92.91,
            "payments_to_affiliates": 0,
            "program_expenses": 1340579,
            "state": "GA",
            "total_contributions": 1473462
        },
        {
            "id": 9,
            "accountability_score": 89,
            "administrative_expenses": 200643,
            "charity_name": "Issaquah Schools Foundation",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=15427",
            "city": "Bellevue",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 98048,
            "compensation_leader_expense_percent": 5.89,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -59227,
            "financial_score": 78.66,
            "fundraising_expenses": 238249,
            "net_assets": 1173256,
            "organization_type": "Education : Scholarship and Financial Support ,",
            "other_revenue": 29857,
            "overall_score": 83.02,
            "payments_to_affiliates": 0,
            "program_expenses": 1225020,
            "state": "WA",
            "total_contributions": 1574828
        },
        {
            "id": 10,
            "accountability_score": 93,
            "administrative_expenses": 611779,
            "charity_name": "Hydrocephalus Association",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=11367",
            "city": "Bethesda",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 200000,
            "compensation_leader_expense_percent": 5.02,
            "compensation_leader_title": "CEO",
            "excess_or_deficit_for_year": 714966,
            "financial_score": 84.82,
            "fundraising_expenses": 562998,
            "net_assets": 3645570,
            "organization_type": "Health : Diseases, Disorders, and Disciplines",
            "other_revenue": 47177,
            "overall_score": 88.17,
            "payments_to_affiliates": 0,
            "program_expenses": 2805884,
            "state": "MD",
            "total_contributions": 4595007
        },
        {
            "id": 11,
            "accountability_score": 85,
            "administrative_expenses": 177985,
            "charity_name": "Hyde Park Art Center",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=15747",
            "city": "Chicago",
            "cn_advisory": "nan",
            "compensation_leader_compensation": "",
            "compensation_leader_expense_percent": "",
            "compensation_leader_title": "nan",
            "excess_or_deficit_for_year": -91315,
            "financial_score": 90.27,
            "fundraising_expenses": 255073,
            "net_assets": 6368885,
            "organization_type": "Arts, Culture, Humanities : Museums",
            "other_revenue": 3505,
            "overall_score": 87.35,
            "payments_to_affiliates": 0,
            "program_expenses": 1728407,
            "state": "IL",
            "total_contributions": 1287542
        },
        {
            "id": 12,
            "accountability_score": 89,
            "administrative_expenses": 359125,
            "charity_name": "The Hyde Collection",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=11456",
            "city": "Glens Falls",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 73138,
            "compensation_leader_expense_percent": 4.14,
            "compensation_leader_title": "Director",
            "excess_or_deficit_for_year": 2131553,
            "financial_score": 81.78,
            "fundraising_expenses": 184263,
            "net_assets": 24114195,
            "organization_type": "Arts, Culture, Humanities : Museums",
            "other_revenue": 718853,
            "overall_score": 84.95,
            "payments_to_affiliates": 0,
            "program_expenses": 1222660,
            "state": "NY",
            "total_contributions": 3051056
        },
        {
            "id": 13,
            "accountability_score": 89,
            "administrative_expenses": 168553,
            "charity_name": "Huntsville Symphony Orchestra",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=14797",
            "city": "Huntsville",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 82500,
            "compensation_leader_expense_percent": 4.51,
            "compensation_leader_title": "President, CEO",
            "excess_or_deficit_for_year": -3753,
            "financial_score": 75.39,
            "fundraising_expenses": 147873,
            "net_assets": 131009,
            "organization_type": "Arts, Culture, Humanities : Performing Arts",
            "other_revenue": 30692,
            "overall_score": 80.93,
            "payments_to_affiliates": 0,
            "program_expenses": 1512485,
            "state": "AL",
            "total_contributions": 1044160
        },
        {
            "id": 14,
            "accountability_score": 100,
            "administrative_expenses": 940855,
            "charity_name": "Huntington's Disease Society of America",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=13075",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 264026,
            "compensation_leader_expense_percent": 3.28,
            "compensation_leader_title": "Chief Executive Officer",
            "excess_or_deficit_for_year": 537310,
            "financial_score": 87.34,
            "fundraising_expenses": 853135,
            "net_assets": 4553274,
            "organization_type": "Health : Diseases, Disorders, and Disciplines",
            "other_revenue": 16889,
            "overall_score": 91.04,
            "payments_to_affiliates": 0,
            "program_expenses": 6247620,
            "state": "NY",
            "total_contributions": 8562031
        },
        {
            "id": 15,
            "accountability_score": 100,
            "administrative_expenses": 119743,
            "charity_name": "Huron River Watershed Council",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=16855",
            "city": "Ann Arbor",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 104945,
            "compensation_leader_expense_percent": 6.73,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 29518,
            "financial_score": 91.9,
            "fundraising_expenses": 136818,
            "net_assets": 1028525,
            "organization_type": "Environment : Environmental Protection and Conservation",
            "other_revenue": 4345,
            "overall_score": 94.27,
            "payments_to_affiliates": 0,
            "program_expenses": 1302535,
            "state": "MI",
            "total_contributions": 1063890
        },
        {
            "id": 16,
            "accountability_score": 89,
            "administrative_expenses": 83378,
            "charity_name": "Byrnes Health Education Center",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12426",
            "city": "York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 89280,
            "compensation_leader_expense_percent": 7.86,
            "compensation_leader_title": "President, CEO",
            "excess_or_deficit_for_year": -22834,
            "financial_score": 83.8,
            "fundraising_expenses": 162845,
            "net_assets": 5209352,
            "organization_type": "Health : Treatment and Prevention Services",
            "other_revenue": 140551,
            "overall_score": 86.15,
            "payments_to_affiliates": 0,
            "program_expenses": 888514,
            "state": "PA",
            "total_contributions": 809534
        },
        {
            "id": 17,
            "accountability_score": 89,
            "administrative_expenses": 548733,
            "charity_name": "Huntsville Botanical Garden",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=17198",
            "city": "Huntsville",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 151680,
            "compensation_leader_expense_percent": 4.51,
            "compensation_leader_title": "CEO",
            "excess_or_deficit_for_year": 7440415,
            "financial_score": 90.95,
            "fundraising_expenses": 98906,
            "net_assets": 18192084,
            "organization_type": "Environment : Botanical Gardens, Parks, and Nature Centers",
            "other_revenue": 248250,
            "overall_score": 89.92,
            "payments_to_affiliates": 0,
            "program_expenses": 2712221,
            "state": "AL",
            "total_contributions": 10103153
        },
        {
            "id": 18,
            "accountability_score": 81,
            "administrative_expenses": 204621,
            "charity_name": "Huntsville Museum of Art",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=14766",
            "city": "Huntsville",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 150988,
            "compensation_leader_expense_percent": 6.53,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 66429,
            "financial_score": 73.91,
            "fundraising_expenses": 344880,
            "net_assets": 97615,
            "organization_type": "Arts, Culture, Humanities : Museums",
            "other_revenue": 26406,
            "overall_score": 77.17,
            "payments_to_affiliates": 0,
            "program_expenses": 1760358,
            "state": "AL",
            "total_contributions": 1985118
        },
        {
            "id": 19,
            "accountability_score": 93,
            "administrative_expenses": 18026507,
            "charity_name": "Cystic Fibrosis Foundation",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9142",
            "city": "Bethesda",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 496970,
            "compensation_leader_expense_percent": 0.19,
            "compensation_leader_title": "President, CEO",
            "excess_or_deficit_for_year": -44527665,
            "financial_score": 97.35,
            "fundraising_expenses": 18419757,
            "net_assets": 3679424528,
            "organization_type": "Health : Diseases, Disorders, and Disciplines ,This rating represents consolidated financial data for these organizations:",
            "other_revenue": 89274989,
            "overall_score": 94.7,
            "payments_to_affiliates": 0,
            "program_expenses": 221903338,
            "state": "MD",
            "total_contributions": 122210533
        },
        {
            "id": 20,
            "accountability_score": 85,
            "administrative_expenses": 68569,
            "charity_name": "Curious Theatre Company",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=13445",
            "city": "Denver",
            "cn_advisory": "nan",
            "compensation_leader_compensation": "",
            "compensation_leader_expense_percent": "",
            "compensation_leader_title": "nan",
            "excess_or_deficit_for_year": 74817,
            "financial_score": 74.6,
            "fundraising_expenses": 134783,
            "net_assets": 584693,
            "organization_type": "Arts, Culture, Humanities : Performing Arts",
            "other_revenue": -11920,
            "overall_score": 79.14,
            "payments_to_affiliates": 0,
            "program_expenses": 1000940,
            "state": "CO",
            "total_contributions": 861035
        },
        {
            "id": 21,
            "accountability_score": 100,
            "administrative_expenses": 336234,
            "charity_name": "Cure SMA",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12524",
            "city": "Elk Grove Village",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 182099,
            "compensation_leader_expense_percent": 2.4,
            "compensation_leader_title": "President",
            "excess_or_deficit_for_year": 307259,
            "financial_score": 78.2,
            "fundraising_expenses": 1009256,
            "net_assets": 2695113,
            "organization_type": "Health : Diseases, Disorders, and Disciplines",
            "other_revenue": 673000,
            "overall_score": 84.58,
            "payments_to_affiliates": 0,
            "program_expenses": 6220527,
            "state": "IL",
            "total_contributions": 5818435
        },
        {
            "id": 22,
            "accountability_score": 96,
            "administrative_expenses": 385923,
            "charity_name": "CurePSP",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9827",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 193846,
            "compensation_leader_expense_percent": 6.14,
            "compensation_leader_title": "President",
            "excess_or_deficit_for_year": 71600,
            "financial_score": 86.36,
            "fundraising_expenses": 522075,
            "net_assets": 2226006,
            "organization_type": "Health : Medical Research",
            "other_revenue": 2965,
            "overall_score": 89.94,
            "payments_to_affiliates": 0,
            "program_expenses": 2244223,
            "state": "NY",
            "total_contributions": 3119335
        },
        {
            "id": 23,
            "accountability_score": 100,
            "administrative_expenses": 838660,
            "charity_name": "CURE International",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=5545",
            "city": "New Cumberland",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 168480,
            "compensation_leader_expense_percent": 0.24,
            "compensation_leader_title": "President, CEO",
            "excess_or_deficit_for_year": -14162177,
            "financial_score": 92.5,
            "fundraising_expenses": 3327969,
            "net_assets": 102655210,
            "organization_type": "International : Development and Relief Services",
            "other_revenue": 707769,
            "overall_score": 94.69,
            "payments_to_affiliates": 0,
            "program_expenses": 65695537,
            "state": "PA",
            "total_contributions": 23035192
        },
        {
            "id": 24,
            "accountability_score": 82,
            "administrative_expenses": 416919,
            "charity_name": "Dégagé Ministries",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12604",
            "city": "Grand Rapids",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 72079,
            "compensation_leader_expense_percent": 3.89,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -27245,
            "financial_score": 89.5,
            "fundraising_expenses": 63375,
            "net_assets": 2144882,
            "organization_type": "Human Services : Homeless Services",
            "other_revenue": -24976,
            "overall_score": 85.26,
            "payments_to_affiliates": 0,
            "program_expenses": 1371628,
            "state": "MI",
            "total_contributions": 1737373
        },
        {
            "id": 25,
            "accountability_score": 100,
            "administrative_expenses": 152412,
            "charity_name": "Cystinosis Research Foundation",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12069",
            "city": "Irvine",
            "cn_advisory": "nan",
            "compensation_leader_compensation": "",
            "compensation_leader_expense_percent": "",
            "compensation_leader_title": "Chair",
            "excess_or_deficit_for_year": 1820010,
            "financial_score": 86.88,
            "fundraising_expenses": 600799,
            "net_assets": 4522420,
            "organization_type": "Health : Medical Research ,",
            "other_revenue": 38599,
            "overall_score": 90.72,
            "payments_to_affiliates": 0,
            "program_expenses": 2284337,
            "state": "CA",
            "total_contributions": 4818959
        },
        {
            "id": 26,
            "accountability_score": 100,
            "administrative_expenses": 124005,
            "charity_name": "dZi Foundation",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12599",
            "city": "Ridgway",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 77762,
            "compensation_leader_expense_percent": 6.09,
            "compensation_leader_title": "President",
            "excess_or_deficit_for_year": 166629,
            "financial_score": 94.64,
            "fundraising_expenses": 164621,
            "net_assets": 2000106,
            "organization_type": "International : Development and Relief Services",
            "other_revenue": -10572,
            "overall_score": 96.2,
            "payments_to_affiliates": 0,
            "program_expenses": 987277,
            "state": "CO",
            "total_contributions": 1453104
        },
        {
            "id": 27,
            "accountability_score": 96,
            "administrative_expenses": 77735,
            "charity_name": "Dystrophic Epidermolysis Bullosa Research Association of America (debra of America)",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=11965",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 153012,
            "compensation_leader_expense_percent": 9.46,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -8398,
            "financial_score": 94.71,
            "fundraising_expenses": 169908,
            "net_assets": 2775860,
            "organization_type": "Health : Diseases, Disorders, and Disciplines",
            "other_revenue": 857985,
            "overall_score": 95.31,
            "payments_to_affiliates": 0,
            "program_expenses": 1368684,
            "state": "NY",
            "total_contributions": 749944
        },
        {
            "id": 28,
            "accountability_score": 100,
            "administrative_expenses": 552261,
            "charity_name": "CuriOdyssey",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12769",
            "city": "San Mateo",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 147578,
            "compensation_leader_expense_percent": 3.37,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 2682302,
            "financial_score": 81.16,
            "fundraising_expenses": 1052723,
            "net_assets": 15706277,
            "organization_type": "Arts, Culture, Humanities : Museums",
            "other_revenue": 603495,
            "overall_score": 86.67,
            "payments_to_affiliates": 0,
            "program_expenses": 2769811,
            "state": "CA",
            "total_contributions": 5578134
        },
        {
            "id": 29,
            "accountability_score": 100,
            "administrative_expenses": 163132,
            "charity_name": "Dystonia Medical Research Foundation",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=6640",
            "city": "Chicago",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 144894,
            "compensation_leader_expense_percent": 5.86,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 2655471,
            "financial_score": 83.97,
            "fundraising_expenses": 268624,
            "net_assets": 4434900,
            "organization_type": "Health : Medical Research",
            "other_revenue": 15833,
            "overall_score": 88.66,
            "payments_to_affiliates": 0,
            "program_expenses": 2038421,
            "state": "IL",
            "total_contributions": 5109815
        },
        {
            "id": 30,
            "accountability_score": 89,
            "administrative_expenses": 201970,
            "charity_name": "24 Foundation",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=15235",
            "city": "Charlotte",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 69731,
            "compensation_leader_expense_percent": 2.25,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -928932,
            "financial_score": 80,
            "fundraising_expenses": 144269,
            "net_assets": -427225,
            "organization_type": "Health : Medical Research",
            "other_revenue": 7134,
            "overall_score": 83.85,
            "payments_to_affiliates": 0,
            "program_expenses": 2741091,
            "state": "NC",
            "total_contributions": 1999290
        },
        {
            "id": 31,
            "accountability_score": 100,
            "administrative_expenses": 1418750,
            "charity_name": "Dumb Friends League",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=3610",
            "city": "Denver",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 302320,
            "compensation_leader_expense_percent": 1.64,
            "compensation_leader_title": "President",
            "excess_or_deficit_for_year": -1551599,
            "financial_score": 89.94,
            "fundraising_expenses": 2463940,
            "net_assets": 70125179,
            "organization_type": "Animals : Animal Rights, Welfare, and Services",
            "other_revenue": 2788674,
            "overall_score": 92.88,
            "payments_to_affiliates": 0,
            "program_expenses": 14526815,
            "state": "CO",
            "total_contributions": 12195279
        },
        {
            "id": 32,
            "accountability_score": 100,
            "administrative_expenses": 1337698,
            "charity_name": "Durham Rescue Mission",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=8985",
            "city": "Durham",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 148024,
            "compensation_leader_expense_percent": 0.71,
            "compensation_leader_title": "Chief Executive Officer",
            "excess_or_deficit_for_year": -8027987,
            "financial_score": 100,
            "fundraising_expenses": 574279,
            "net_assets": 15582886,
            "organization_type": "Human Services : Homeless Services",
            "other_revenue": 4340235,
            "overall_score": 100,
            "payments_to_affiliates": 0,
            "program_expenses": 18843152,
            "state": "NC",
            "total_contributions": 7897648
        },
        {
            "id": 33,
            "accountability_score": 93,
            "administrative_expenses": 462033,
            "charity_name": "Dutchess County SPCA",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=6764",
            "city": "Hyde Park",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 41686,
            "compensation_leader_expense_percent": 1.9,
            "compensation_leader_title": "Former Executive Director",
            "excess_or_deficit_for_year": -673663,
            "financial_score": 86.19,
            "fundraising_expenses": 113929,
            "net_assets": 6009181,
            "organization_type": "Animals : Animal Rights, Welfare, and Services",
            "other_revenue": 258802,
            "overall_score": 89.05,
            "payments_to_affiliates": 0,
            "program_expenses": 1609406,
            "state": "NY",
            "total_contributions": 748227
        },
        {
            "id": 34,
            "accountability_score": 100,
            "administrative_expenses": 102716,
            "charity_name": "DuPage PADS",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12278",
            "city": "Wheaton",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 131808,
            "compensation_leader_expense_percent": 3.51,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 390812,
            "financial_score": 82.83,
            "fundraising_expenses": 558415,
            "net_assets": 2600177,
            "organization_type": "Human Services : Homeless Services",
            "other_revenue": -57347,
            "overall_score": 87.85,
            "payments_to_affiliates": 0,
            "program_expenses": 3085564,
            "state": "IL",
            "total_contributions": 4045611
        },
        {
            "id": 35,
            "accountability_score": 78,
            "administrative_expenses": 267388,
            "charity_name": "DuPage Children's Museum",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=14735",
            "city": "Naperville",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 120672,
            "compensation_leader_expense_percent": 2.97,
            "compensation_leader_title": "President, CEO",
            "excess_or_deficit_for_year": 353973,
            "financial_score": 81.13,
            "fundraising_expenses": 330570,
            "net_assets": 3602916,
            "organization_type": "Arts, Culture, Humanities : Museums",
            "other_revenue": 1325508,
            "overall_score": 79.5,
            "payments_to_affiliates": 0,
            "program_expenses": 3463609,
            "state": "IL",
            "total_contributions": 1303678
        },
        {
            "id": 36,
            "accountability_score": 96,
            "administrative_expenses": 6146668,
            "charity_name": "Ducks Unlimited",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=3631",
            "city": "Memphis",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 511842,
            "compensation_leader_expense_percent": 0.25,
            "compensation_leader_title": "Chief Executive Officer",
            "excess_or_deficit_for_year": 28422623,
            "financial_score": 84.07,
            "fundraising_expenses": 37813823,
            "net_assets": 195923938,
            "organization_type": "Animals : Wildlife Conservation ,This rating represents consolidated financial data for these organizations:",
            "other_revenue": 24159550,
            "overall_score": 88.38,
            "payments_to_affiliates": 0,
            "program_expenses": 159565880,
            "state": "TN",
            "total_contributions": 207789444
        },
        {
            "id": 37,
            "accountability_score": 89,
            "administrative_expenses": 488815,
            "charity_name": "Dubuque County Historical Society",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12812",
            "city": "Dubuque",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 110200,
            "compensation_leader_expense_percent": 1.57,
            "compensation_leader_title": "President/CEO",
            "excess_or_deficit_for_year": -2299475,
            "financial_score": 93.25,
            "fundraising_expenses": 228191,
            "net_assets": 41573178,
            "organization_type": "Arts, Culture, Humanities : Museums",
            "other_revenue": 760401,
            "overall_score": 90.87,
            "payments_to_affiliates": 0,
            "program_expenses": 6284975,
            "state": "IA",
            "total_contributions": 1447829
        },
        {
            "id": 38,
            "accountability_score": 100,
            "administrative_expenses": 274079,
            "charity_name": "4 Paws for Ability",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=13055",
            "city": "Xenia",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 103803,
            "compensation_leader_expense_percent": 3.4,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 621712,
            "financial_score": 92.5,
            "fundraising_expenses": 163774,
            "net_assets": 3500111,
            "organization_type": "Human Services : Social Services",
            "other_revenue": 215424,
            "overall_score": 94.69,
            "payments_to_affiliates": 0,
            "program_expenses": 2610426,
            "state": "OH",
            "total_contributions": 976681
        },
        {
            "id": 39,
            "accountability_score": 82,
            "administrative_expenses": 112524,
            "charity_name": "Dubuque Regional Humane Society",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=14181",
            "city": "Dubuque",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 80000,
            "compensation_leader_expense_percent": 7.33,
            "compensation_leader_title": "President, CEO",
            "excess_or_deficit_for_year": -432203,
            "financial_score": 93.05,
            "fundraising_expenses": 102647,
            "net_assets": 5497007,
            "organization_type": "Animals : Animal Rights, Welfare, and Services",
            "other_revenue": 129752,
            "overall_score": 86.35,
            "payments_to_affiliates": 0,
            "program_expenses": 875329,
            "state": "IA",
            "total_contributions": 200955
        },
        {
            "id": 40,
            "accountability_score": 96,
            "administrative_expenses": 177504,
            "charity_name": "Drugs for Neglected Diseases Initiative North America",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=16059",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 154141,
            "compensation_leader_expense_percent": 5.16,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 232256,
            "financial_score": 79.98,
            "fundraising_expenses": 394582,
            "net_assets": 566614,
            "organization_type": "Health : Medical Research",
            "other_revenue": 241,
            "overall_score": 85.56,
            "payments_to_affiliates": 0,
            "program_expenses": 2414640,
            "state": "NY",
            "total_contributions": 3218741
        },
        {
            "id": 41,
            "accountability_score": 82,
            "administrative_expenses": 740208,
            "charity_name": "Drisha Institute for Jewish Education",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9364",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 150759,
            "compensation_leader_expense_percent": 7.46,
            "compensation_leader_title": "Dean",
            "excess_or_deficit_for_year": -835454,
            "financial_score": 69.28,
            "fundraising_expenses": 55864,
            "net_assets": 7018400,
            "organization_type": "Religion : Religious Activities",
            "other_revenue": 388176,
            "overall_score": 74.82,
            "payments_to_affiliates": 0,
            "program_expenses": 1223452,
            "state": "NY",
            "total_contributions": 700617
        },
        {
            "id": 42,
            "accountability_score": 96,
            "administrative_expenses": 355811,
            "charity_name": "Dress for Success Worldwide",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=7942",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": "",
            "compensation_leader_expense_percent": "",
            "compensation_leader_title": "Chief Executive Officer",
            "excess_or_deficit_for_year": 332576,
            "financial_score": 90,
            "fundraising_expenses": 962492,
            "net_assets": 5107651,
            "organization_type": "Human Services : Social Services",
            "other_revenue": 2940350,
            "overall_score": 92.38,
            "payments_to_affiliates": 2254689,
            "program_expenses": 21828611,
            "state": "NY",
            "total_contributions": 20539140
        },
        {
            "id": 43,
            "accountability_score": 93,
            "administrative_expenses": 167750,
            "charity_name": "Dreams Come True",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9624",
            "city": "Jacksonville",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 108720,
            "compensation_leader_expense_percent": 4.77,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 108718,
            "financial_score": 99.85,
            "fundraising_expenses": 136823,
            "net_assets": 4620438,
            "organization_type": "Health : Patient and Family Support",
            "other_revenue": 559187,
            "overall_score": 95.04,
            "payments_to_affiliates": 0,
            "program_expenses": 1971526,
            "state": "FL",
            "total_contributions": 1825630
        },
        {
            "id": 44,
            "accountability_score": 89,
            "administrative_expenses": 60495,
            "charity_name": "Dream Factory",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9630",
            "city": "Louisville",
            "cn_advisory": "nan",
            "compensation_leader_compensation": "",
            "compensation_leader_expense_percent": "",
            "compensation_leader_title": "Chief Executive Officer",
            "excess_or_deficit_for_year": 33649,
            "financial_score": 96.22,
            "fundraising_expenses": 29852,
            "net_assets": 3505329,
            "organization_type": "Health : Patient and Family Support",
            "other_revenue": -5029,
            "overall_score": 91.77,
            "payments_to_affiliates": 159325,
            "program_expenses": 2181218,
            "state": "KY",
            "total_contributions": 2310243
        },
        {
            "id": 45,
            "accountability_score": 85,
            "administrative_expenses": 476124,
            "charity_name": "The Drawing Center",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=6729",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 175000,
            "compensation_leader_expense_percent": 7.88,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -281839,
            "financial_score": 83.31,
            "fundraising_expenses": 333896,
            "net_assets": 8918807,
            "organization_type": "Arts, Culture, Humanities : Museums",
            "other_revenue": 15173,
            "overall_score": 84.13,
            "payments_to_affiliates": 0,
            "program_expenses": 1409669,
            "state": "NY",
            "total_contributions": 1870018
        },
        {
            "id": 46,
            "accountability_score": 89,
            "administrative_expenses": 100694,
            "charity_name": "The Drake House",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=13324",
            "city": "Roswell",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 78750,
            "compensation_leader_expense_percent": 8.98,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 214028,
            "financial_score": 95.35,
            "fundraising_expenses": 70581,
            "net_assets": 2517282,
            "organization_type": "Human Services : Youth Development, Shelter, and Crisis Services",
            "other_revenue": 149850,
            "overall_score": 91.55,
            "payments_to_affiliates": 0,
            "program_expenses": 704707,
            "state": "GA",
            "total_contributions": 928160
        },
        {
            "id": 47,
            "accountability_score": 100,
            "administrative_expenses": 88841,
            "charity_name": "Downtown Rescue Mission",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9643",
            "city": "Huntsville",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 101450,
            "compensation_leader_expense_percent": 1.11,
            "compensation_leader_title": "President, CEO",
            "excess_or_deficit_for_year": 1785719,
            "financial_score": 85,
            "fundraising_expenses": 1002981,
            "net_assets": 7351178,
            "organization_type": "Human Services : Homeless Services",
            "other_revenue": 0,
            "overall_score": 89.39,
            "payments_to_affiliates": 0,
            "program_expenses": 8005282,
            "state": "AL",
            "total_contributions": 10866393
        },
        {
            "id": 48,
            "accountability_score": 93,
            "administrative_expenses": 368708,
            "charity_name": "Dream Foundation",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9892",
            "city": "Santa Barbara",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 162176,
            "compensation_leader_expense_percent": 3.61,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -653513,
            "financial_score": 97.07,
            "fundraising_expenses": 379683,
            "net_assets": 4205692,
            "organization_type": "Health : Patient and Family Support",
            "other_revenue": -129438,
            "overall_score": 94.63,
            "payments_to_affiliates": 0,
            "program_expenses": 3737808,
            "state": "CA",
            "total_contributions": 3962124
        },
        {
            "id": 49,
            "accountability_score": 96,
            "administrative_expenses": 786239,
            "charity_name": "Downtown Women's Center",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9461",
            "city": "Los Angeles",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 146314,
            "compensation_leader_expense_percent": 1.98,
            "compensation_leader_title": "Chief Executive Officer",
            "excess_or_deficit_for_year": 63453,
            "financial_score": 87.26,
            "fundraising_expenses": 679258,
            "net_assets": 17685957,
            "organization_type": "Human Services : Homeless Services",
            "other_revenue": 225037,
            "overall_score": 90.55,
            "payments_to_affiliates": 0,
            "program_expenses": 5906129,
            "state": "CA",
            "total_contributions": 6653125
        },
        {
            "id": 50,
            "accountability_score": 96,
            "administrative_expenses": 168761,
            "charity_name": "Dress for Success Houston",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9703",
            "city": "Houston",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 149520,
            "compensation_leader_expense_percent": 7.38,
            "compensation_leader_title": "President",
            "excess_or_deficit_for_year": 328637,
            "financial_score": 90.6,
            "fundraising_expenses": 235553,
            "net_assets": 13297040,
            "organization_type": "Human Services : Social Services",
            "other_revenue": 203944,
            "overall_score": 92.77,
            "payments_to_affiliates": 0,
            "program_expenses": 1621606,
            "state": "TX",
            "total_contributions": 2150613
        },
        {
            "id": 51,
            "accountability_score": 89,
            "administrative_expenses": 417058,
            "charity_name": "DreamYard Project",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12702",
            "city": "Bronx",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 112300,
            "compensation_leader_expense_percent": 2.64,
            "compensation_leader_title": "Co-Director",
            "excess_or_deficit_for_year": 348133,
            "financial_score": 91.11,
            "fundraising_expenses": 290265,
            "net_assets": 1270018,
            "organization_type": "Education : Youth Education Programs and Services",
            "other_revenue": 5,
            "overall_score": 89.99,
            "payments_to_affiliates": 0,
            "program_expenses": 3540950,
            "state": "NY",
            "total_contributions": 3544959
        },
        {
            "id": 52,
            "accountability_score": 77,
            "administrative_expenses": 426800,
            "charity_name": "Downtown Cleveland Alliance",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9155",
            "city": "Cleveland",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 248020,
            "compensation_leader_expense_percent": 3.88,
            "compensation_leader_title": "President, CEO",
            "excess_or_deficit_for_year": 640459,
            "financial_score": 88.93,
            "fundraising_expenses": 292911,
            "net_assets": 2673256,
            "organization_type": "Community Development : Housing and Neighborhood Development",
            "other_revenue": 57070,
            "overall_score": 81.95,
            "payments_to_affiliates": 0,
            "program_expenses": 5668986,
            "state": "OH",
            "total_contributions": 6395443
        },
        {
            "id": 53,
            "accountability_score": 89,
            "administrative_expenses": 323355,
            "charity_name": "Downtown Community Television Center",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9361",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 86430,
            "compensation_leader_expense_percent": 2.2,
            "compensation_leader_title": "Co-Executive Director, President",
            "excess_or_deficit_for_year": 57141,
            "financial_score": 97.47,
            "fundraising_expenses": 162127,
            "net_assets": 3557955,
            "organization_type": "Arts, Culture, Humanities : Performing Arts",
            "other_revenue": 8875,
            "overall_score": 92.01,
            "payments_to_affiliates": 0,
            "program_expenses": 3427753,
            "state": "NY",
            "total_contributions": 931376
        },
        {
            "id": 54,
            "accountability_score": 96,
            "administrative_expenses": 1139640,
            "charity_name": "DoveLewis Emergency Animal Hospital",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12512",
            "city": "Portland",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 246301,
            "compensation_leader_expense_percent": 2.14,
            "compensation_leader_title": "Chief Executive Officer",
            "excess_or_deficit_for_year": 634721,
            "financial_score": 85,
            "fundraising_expenses": 416782,
            "net_assets": 7032558,
            "organization_type": "Animals : Animal Rights, Welfare, and Services",
            "other_revenue": 62906,
            "overall_score": 89.02,
            "payments_to_affiliates": 0,
            "program_expenses": 9935409,
            "state": "OR",
            "total_contributions": 1763793
        },
        {
            "id": 55,
            "accountability_score": 82,
            "administrative_expenses": 363126,
            "charity_name": "Downline Ministries",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=14124",
            "city": "Memphis",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 25749,
            "compensation_leader_expense_percent": 1.37,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -227165,
            "financial_score": 84.35,
            "fundraising_expenses": 90845,
            "net_assets": 1098466,
            "organization_type": "Religion : Religious Activities",
            "other_revenue": 99727,
            "overall_score": 83.13,
            "payments_to_affiliates": 0,
            "program_expenses": 1417719,
            "state": "TN",
            "total_contributions": 1251931
        },
        {
            "id": 56,
            "accountability_score": 93,
            "administrative_expenses": 221067,
            "charity_name": "The Dougy Center",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=13186",
            "city": "Portland",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 78395,
            "compensation_leader_expense_percent": 4.5,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -255466,
            "financial_score": 77.32,
            "fundraising_expenses": 314057,
            "net_assets": 5304123,
            "organization_type": "Human Services : Children's and Family Services",
            "other_revenue": 497719,
            "overall_score": 83.21,
            "payments_to_affiliates": 0,
            "program_expenses": 1204358,
            "state": "OR",
            "total_contributions": 923189
        },
        {
            "id": 57,
            "accountability_score": 100,
            "administrative_expenses": 393930,
            "charity_name": "Double H Ranch",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=10568",
            "city": "Lake Luzerne",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 201030,
            "compensation_leader_expense_percent": 4.95,
            "compensation_leader_title": "CEO, Executive Director",
            "excess_or_deficit_for_year": 2797545,
            "financial_score": 81.29,
            "fundraising_expenses": 733908,
            "net_assets": 17319878,
            "organization_type": "Health : Patient and Family Support",
            "other_revenue": 474123,
            "overall_score": 86.77,
            "payments_to_affiliates": 0,
            "program_expenses": 2926279,
            "state": "NY",
            "total_contributions": 6377539
        },
        {
            "id": 58,
            "accountability_score": 96,
            "administrative_expenses": 217621,
            "charity_name": "Dr. Susan Love Research Foundation",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=11077",
            "city": "Encino",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 210000,
            "compensation_leader_expense_percent": 7.59,
            "compensation_leader_title": "President",
            "excess_or_deficit_for_year": 86969,
            "financial_score": 89.4,
            "fundraising_expenses": 273590,
            "net_assets": 2963707,
            "organization_type": "Health : Medical Research",
            "other_revenue": -168319,
            "overall_score": 91.98,
            "payments_to_affiliates": 0,
            "program_expenses": 2272183,
            "state": "CA",
            "total_contributions": 2967182
        },
        {
            "id": 59,
            "accountability_score": 100,
            "administrative_expenses": 133693,
            "charity_name": "Doug Flutie Jr. Foundation For Autism",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=8742",
            "city": "Framingham",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 60000,
            "compensation_leader_expense_percent": 5.64,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 656743,
            "financial_score": 80.34,
            "fundraising_expenses": 119799,
            "net_assets": 2649691,
            "organization_type": "Health : Diseases, Disorders, and Disciplines ,",
            "other_revenue": 91146,
            "overall_score": 86.09,
            "payments_to_affiliates": 0,
            "program_expenses": 808816,
            "state": "MA",
            "total_contributions": 1624689
        },
        {
            "id": 60,
            "accountability_score": 75,
            "administrative_expenses": 17011,
            "charity_name": "Dreamchaser PMU Rescue & Rehabilitation",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=16105",
            "city": "Falcon",
            "cn_advisory": "nan",
            "compensation_leader_compensation": "",
            "compensation_leader_expense_percent": "",
            "compensation_leader_title": "CEO",
            "excess_or_deficit_for_year": 73172,
            "financial_score": 74.5,
            "fundraising_expenses": 288013,
            "net_assets": 275659,
            "organization_type": "Animals : Animal Rights, Welfare, and Services",
            "other_revenue": 33691,
            "overall_score": 74.74,
            "payments_to_affiliates": 0,
            "program_expenses": 1293096,
            "state": "MO",
            "total_contributions": 1637601
        },
        {
            "id": 61,
            "accountability_score": 100,
            "administrative_expenses": 211917,
            "charity_name": "Doorways for Women and Families",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=8581",
            "city": "Arlington",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 126273,
            "compensation_leader_expense_percent": 3.16,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 1524752,
            "financial_score": 87.72,
            "fundraising_expenses": 679666,
            "net_assets": 6296186,
            "organization_type": "Human Services : Social Services",
            "other_revenue": 12960,
            "overall_score": 91.31,
            "payments_to_affiliates": 0,
            "program_expenses": 3099925,
            "state": "VA",
            "total_contributions": 5503300
        },
        {
            "id": 62,
            "accountability_score": 97,
            "administrative_expenses": 601005,
            "charity_name": "DOROT",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=8104",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 266663,
            "compensation_leader_expense_percent": 3.76,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -767964,
            "financial_score": 94.85,
            "fundraising_expenses": 642278,
            "net_assets": 24627928,
            "organization_type": "Human Services : Social Services",
            "other_revenue": 347371,
            "overall_score": 95.78,
            "payments_to_affiliates": 0,
            "program_expenses": 5840860,
            "state": "NY",
            "total_contributions": 5968808
        },
        {
            "id": 63,
            "accountability_score": 97,
            "administrative_expenses": 2197589,
            "charity_name": "Drug Policy Alliance",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=6230",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 294181,
            "compensation_leader_expense_percent": 2.15,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -3250274,
            "financial_score": 74.88,
            "fundraising_expenses": 1461581,
            "net_assets": 2609490,
            "organization_type": "Research and Public Policy : Social and Public Policy Research",
            "other_revenue": 46428,
            "overall_score": 82.11,
            "payments_to_affiliates": 0,
            "program_expenses": 10021348,
            "state": "NY",
            "total_contributions": 9796994
        },
        {
            "id": 64,
            "accountability_score": 89,
            "administrative_expenses": 517141,
            "charity_name": "The Doseum",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=13320",
            "city": "San Antonio",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 135000,
            "compensation_leader_expense_percent": 2.51,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 1901523,
            "financial_score": 99.03,
            "fundraising_expenses": 388725,
            "net_assets": 51239590,
            "organization_type": "Arts, Culture, Humanities : Museums",
            "other_revenue": 380514,
            "overall_score": 92.19,
            "payments_to_affiliates": 0,
            "program_expenses": 4466430,
            "state": "TX",
            "total_contributions": 4306225
        },
        {
            "id": 65,
            "accountability_score": 96,
            "administrative_expenses": 865054,
            "charity_name": "DonorsChoose.org",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9284",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 323551,
            "compensation_leader_expense_percent": 0.32,
            "compensation_leader_title": "Chief Executive Officer",
            "excess_or_deficit_for_year": 6996938,
            "financial_score": 97.5,
            "fundraising_expenses": 4200623,
            "net_assets": 41187281,
            "organization_type": "Education : Youth Education Programs and Services",
            "other_revenue": 116461,
            "overall_score": 96.66,
            "payments_to_affiliates": 0,
            "program_expenses": 95527760,
            "state": "NY",
            "total_contributions": 107473914
        },
        {
            "id": 66,
            "accountability_score": 96,
            "administrative_expenses": 186936,
            "charity_name": "The Doorways",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=10285",
            "city": "Richmond",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 160419,
            "compensation_leader_expense_percent": 6.53,
            "compensation_leader_title": "President, CEO",
            "excess_or_deficit_for_year": 425866,
            "financial_score": 97.5,
            "fundraising_expenses": 101670,
            "net_assets": 11806753,
            "organization_type": "Health : Patient and Family Support",
            "other_revenue": 956728,
            "overall_score": 96.66,
            "payments_to_affiliates": 0,
            "program_expenses": 2165998,
            "state": "VA",
            "total_contributions": 1923742
        },
        {
            "id": 67,
            "accountability_score": 81,
            "administrative_expenses": 245384,
            "charity_name": "Donald W. Reynolds Boys & Girls Club",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9653",
            "city": "Fayetteville",
            "cn_advisory": "nan",
            "compensation_leader_compensation": "",
            "compensation_leader_expense_percent": "",
            "compensation_leader_title": "nan",
            "excess_or_deficit_for_year": 2133826,
            "financial_score": 92.12,
            "fundraising_expenses": 92857,
            "net_assets": 13579831,
            "organization_type": "Human Services : Youth Development, Shelter, and Crisis Services",
            "other_revenue": 95733,
            "overall_score": 85.45,
            "payments_to_affiliates": 0,
            "program_expenses": 1823756,
            "state": "AR",
            "total_contributions": 3249573
        },
        {
            "id": 68,
            "accountability_score": 82,
            "administrative_expenses": 146547,
            "charity_name": "Domestic Violence Project",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=15259",
            "city": "Canton",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 59152,
            "compensation_leader_expense_percent": 3.15,
            "compensation_leader_title": "Executive Director, CEO",
            "excess_or_deficit_for_year": -231661,
            "financial_score": 97.5,
            "fundraising_expenses": 92069,
            "net_assets": 2069986,
            "organization_type": "Human Services : Social Services",
            "other_revenue": 42463,
            "overall_score": 87.14,
            "payments_to_affiliates": 0,
            "program_expenses": 1635867,
            "state": "OH",
            "total_contributions": 1267216
        },
        {
            "id": 69,
            "accountability_score": 92,
            "administrative_expenses": 630488,
            "charity_name": "Domestic Violence Intervention Services, Inc. (DVIS)",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=13958",
            "city": "Tulsa",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 115781,
            "compensation_leader_expense_percent": 2.05,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -684798,
            "financial_score": 95.72,
            "fundraising_expenses": 362732,
            "net_assets": 18869218,
            "organization_type": "Human Services : Social Services",
            "other_revenue": 340245,
            "overall_score": 93.58,
            "payments_to_affiliates": 0,
            "program_expenses": 4631486,
            "state": "OK",
            "total_contributions": 4358746
        },
        {
            "id": 70,
            "accountability_score": 100,
            "administrative_expenses": 213616,
            "charity_name": "Domestic Violence Solutions for Santa Barbara County",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=6561",
            "city": "Santa Barbara",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 125781,
            "compensation_leader_expense_percent": 6.9,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -343184,
            "financial_score": 79.61,
            "fundraising_expenses": 174049,
            "net_assets": 3274897,
            "organization_type": "Human Services : Social Services",
            "other_revenue": 12585,
            "overall_score": 85.58,
            "payments_to_affiliates": 0,
            "program_expenses": 1432659,
            "state": "CA",
            "total_contributions": 1393851
        },
        {
            "id": 71,
            "accountability_score": 86,
            "administrative_expenses": 206192,
            "charity_name": "Domestic Violence Center of Chester County",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=13827",
            "city": "West Chester",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 110000,
            "compensation_leader_expense_percent": 6.58,
            "compensation_leader_title": "CEO",
            "excess_or_deficit_for_year": 37029,
            "financial_score": 91.87,
            "fundraising_expenses": 132052,
            "net_assets": 2865283,
            "organization_type": "Human Services : Social Services",
            "other_revenue": 18595,
            "overall_score": 88.55,
            "payments_to_affiliates": 0,
            "program_expenses": 1333107,
            "state": "PA",
            "total_contributions": 1668817
        },
        {
            "id": 72,
            "accountability_score": 92,
            "administrative_expenses": 193701,
            "charity_name": "Domestic Abuse Project of Delaware County, Inc.",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=16392",
            "city": "Media",
            "cn_advisory": "nan",
            "compensation_leader_compensation": "",
            "compensation_leader_expense_percent": "",
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 123590,
            "financial_score": 87.56,
            "fundraising_expenses": 66172,
            "net_assets": 1079155,
            "organization_type": "Human Services : Social Services",
            "other_revenue": 123072,
            "overall_score": 89.54,
            "payments_to_affiliates": 0,
            "program_expenses": 1369670,
            "state": "PA",
            "total_contributions": 1630061
        },
        {
            "id": 73,
            "accountability_score": 93,
            "administrative_expenses": 281430,
            "charity_name": "Domestic Abuse Intervention Services",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=14291",
            "city": "Madison",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 87248,
            "compensation_leader_expense_percent": 2.74,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -903904,
            "financial_score": 90.87,
            "fundraising_expenses": 330147,
            "net_assets": 6585456,
            "organization_type": "Human Services : Social Services",
            "other_revenue": -4075,
            "overall_score": 91.86,
            "payments_to_affiliates": 0,
            "program_expenses": 2564664,
            "state": "WI",
            "total_contributions": 2276412
        },
        {
            "id": 74,
            "accountability_score": 78,
            "administrative_expenses": 360621,
            "charity_name": "Dollywood Foundation",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=13711",
            "city": "Pigeon Force",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 249962,
            "compensation_leader_expense_percent": 9.04,
            "compensation_leader_title": "President",
            "excess_or_deficit_for_year": 8131517,
            "financial_score": 96.67,
            "fundraising_expenses": 113848,
            "net_assets": 16323229,
            "organization_type": "Education : Youth Education Programs and Services",
            "other_revenue": 548864,
            "overall_score": 84.26,
            "payments_to_affiliates": 0,
            "program_expenses": 2289217,
            "state": "TN",
            "total_contributions": 10346339
        },
        {
            "id": 75,
            "accountability_score": 89,
            "administrative_expenses": 234021,
            "charity_name": "Domestic Abuse Project",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=15314",
            "city": "Minneapolis",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 92579,
            "compensation_leader_expense_percent": 5.81,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 301797,
            "financial_score": 79.6,
            "fundraising_expenses": 146571,
            "net_assets": 717082,
            "organization_type": "Human Services : Social Services",
            "other_revenue": -18893,
            "overall_score": 83.61,
            "payments_to_affiliates": 0,
            "program_expenses": 1210182,
            "state": "MN",
            "total_contributions": 1842076
        },
        {
            "id": 76,
            "accountability_score": 100,
            "administrative_expenses": 246172,
            "charity_name": "Dogs for Better Lives",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=5781",
            "city": "Central Point",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 123871,
            "compensation_leader_expense_percent": 4.22,
            "compensation_leader_title": "President/CEO",
            "excess_or_deficit_for_year": -1597228,
            "financial_score": 91.21,
            "fundraising_expenses": 273098,
            "net_assets": 17135675,
            "organization_type": "Animals : Animal Rights, Welfare, and Services",
            "other_revenue": -417195,
            "overall_score": 93.78,
            "payments_to_affiliates": 0,
            "program_expenses": 2410682,
            "state": "OR",
            "total_contributions": 1747792
        },
        {
            "id": 77,
            "accountability_score": 100,
            "administrative_expenses": 882257,
            "charity_name": "Dollar Energy Fund",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=7957",
            "city": "Pittsburgh",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 196866,
            "compensation_leader_expense_percent": 1.11,
            "compensation_leader_title": "Chief Executive Officer",
            "excess_or_deficit_for_year": -1235391,
            "financial_score": 89.67,
            "fundraising_expenses": 388262,
            "net_assets": 11389269,
            "organization_type": "Human Services : Social Services",
            "other_revenue": 38461,
            "overall_score": 92.69,
            "payments_to_affiliates": 0,
            "program_expenses": 16322374,
            "state": "PA",
            "total_contributions": 6288924
        },
        {
            "id": 78,
            "accountability_score": 77,
            "administrative_expenses": 1550307,
            "charity_name": "Doernbecher Children's Hospital Foundation",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=6416",
            "city": "Portland",
            "cn_advisory": "nan",
            "compensation_leader_compensation": "",
            "compensation_leader_expense_percent": "",
            "compensation_leader_title": "nan",
            "excess_or_deficit_for_year": 4745056,
            "financial_score": 83.2,
            "fundraising_expenses": 1750072,
            "net_assets": 62800576,
            "organization_type": "Health : Treatment and Prevention Services ,",
            "other_revenue": 1285208,
            "overall_score": 79.85,
            "payments_to_affiliates": 0,
            "program_expenses": 9985811,
            "state": "OR",
            "total_contributions": 16394767
        },
        {
            "id": 79,
            "accountability_score": 96,
            "administrative_expenses": 7881815,
            "charity_name": "Doheny Eye Institute",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=5851",
            "city": "Los Angeles",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 508387,
            "compensation_leader_expense_percent": 2.3,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 135160,
            "financial_score": 75.35,
            "fundraising_expenses": 1156043,
            "net_assets": 73488393,
            "organization_type": "Health : Medical Research",
            "other_revenue": 4876609,
            "overall_score": 82.34,
            "payments_to_affiliates": 0,
            "program_expenses": 12990486,
            "state": "CA",
            "total_contributions": 5004366
        },
        {
            "id": 80,
            "accountability_score": 97,
            "administrative_expenses": 5558418,
            "charity_name": "Doctors Without Borders, USA",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=3628",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 200805,
            "compensation_leader_expense_percent": 0.05,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 10898493,
            "financial_score": 97.5,
            "fundraising_expenses": 32351142,
            "net_assets": 287228413,
            "organization_type": "International : Development and Relief Services ,",
            "other_revenue": 2582377,
            "overall_score": 97.23,
            "payments_to_affiliates": 0,
            "program_expenses": 325591291,
            "state": "NY",
            "total_contributions": 357438744
        },
        {
            "id": 81,
            "accountability_score": 92,
            "administrative_expenses": 127963,
            "charity_name": "Doctors Care",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=13211",
            "city": "Littleton",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 121039,
            "compensation_leader_expense_percent": 5.68,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 435057,
            "financial_score": 99.57,
            "fundraising_expenses": 73496,
            "net_assets": 5146089,
            "organization_type": "Health : Treatment and Prevention Services",
            "other_revenue": 59121,
            "overall_score": 94.33,
            "payments_to_affiliates": 0,
            "program_expenses": 1928532,
            "state": "CO",
            "total_contributions": 1410357
        },
        {
            "id": 82,
            "accountability_score": 96,
            "administrative_expenses": 901523,
            "charity_name": "Do Something",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9374",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 197812,
            "compensation_leader_expense_percent": 1.98,
            "compensation_leader_title": "Chief Executive Officer",
            "excess_or_deficit_for_year": -1094986,
            "financial_score": 97.5,
            "fundraising_expenses": 321439,
            "net_assets": 12137900,
            "organization_type": "Human Services : Youth Development, Shelter, and Crisis Services",
            "other_revenue": 13034,
            "overall_score": 96.66,
            "payments_to_affiliates": 0,
            "program_expenses": 8732903,
            "state": "NY",
            "total_contributions": 6696349
        },
        {
            "id": 83,
            "accountability_score": 85,
            "administrative_expenses": 2790569,
            "charity_name": "DKT International",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=3627",
            "city": "Washington",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 374511,
            "compensation_leader_expense_percent": 0.22,
            "compensation_leader_title": "President & CEO",
            "excess_or_deficit_for_year": 64799405,
            "financial_score": 97.5,
            "fundraising_expenses": 458429,
            "net_assets": 216603841,
            "organization_type": "International : Development and Relief Services",
            "other_revenue": 13814501,
            "overall_score": 89.24,
            "payments_to_affiliates": 0,
            "program_expenses": 164015177,
            "state": "DC",
            "total_contributions": 97787203
        },
        {
            "id": 84,
            "accountability_score": 78,
            "administrative_expenses": 603059,
            "charity_name": "The Dixon Gallery and Gardens",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9632",
            "city": "Memphis",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 219525,
            "compensation_leader_expense_percent": 4.76,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -295691,
            "financial_score": 91.91,
            "fundraising_expenses": 103496,
            "net_assets": 5005754,
            "organization_type": "Arts, Culture, Humanities : Museums",
            "other_revenue": 181398,
            "overall_score": 83.42,
            "payments_to_affiliates": 0,
            "program_expenses": 3900838,
            "state": "TN",
            "total_contributions": 4015692
        },
        {
            "id": 85,
            "accountability_score": 85,
            "administrative_expenses": 863795,
            "charity_name": "District of Columbia College Access Program",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=5467",
            "city": "Washington",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 342868,
            "compensation_leader_expense_percent": 4.54,
            "compensation_leader_title": "President, CEO",
            "excess_or_deficit_for_year": 651156,
            "financial_score": 88.77,
            "fundraising_expenses": 582034,
            "net_assets": 73740982,
            "organization_type": "Education : Scholarship and Financial Support",
            "other_revenue": 6181358,
            "overall_score": 86.75,
            "payments_to_affiliates": 0,
            "program_expenses": 6105784,
            "state": "DC",
            "total_contributions": 2021411
        },
        {
            "id": 86,
            "accountability_score": 93,
            "administrative_expenses": 713449,
            "charity_name": "Discovery World",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=15768",
            "city": "Milwaukee",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 182065,
            "compensation_leader_expense_percent": 1.77,
            "compensation_leader_title": "CEO and President",
            "excess_or_deficit_for_year": -2667095,
            "financial_score": 85.79,
            "fundraising_expenses": 304184,
            "net_assets": 37073513,
            "organization_type": "Arts, Culture, Humanities : Museums",
            "other_revenue": 295158,
            "overall_score": 88.79,
            "payments_to_affiliates": 0,
            "program_expenses": 9229297,
            "state": "WI",
            "total_contributions": 4120552
        },
        {
            "id": 87,
            "accountability_score": 67,
            "administrative_expenses": 171527,
            "charity_name": "Diskin Orphan Fund of Israel",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=10348",
            "city": "Brooklyn",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 60000,
            "compensation_leader_expense_percent": 3.58,
            "compensation_leader_title": "Executive Secretary",
            "excess_or_deficit_for_year": 964783,
            "financial_score": 89.95,
            "fundraising_expenses": 165994,
            "net_assets": 1528312,
            "organization_type": "Human Services : Youth Development, Shelter, and Crisis Services ,",
            "other_revenue": 0,
            "overall_score": 75.6,
            "payments_to_affiliates": 0,
            "program_expenses": 1338356,
            "state": "NY",
            "total_contributions": 2640660
        },
        {
            "id": 88,
            "accountability_score": 92,
            "administrative_expenses": 1885310,
            "charity_name": "Discovery Place",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=5500",
            "city": "Charlotte",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 234266,
            "compensation_leader_expense_percent": 1.5,
            "compensation_leader_title": "President & CEO",
            "excess_or_deficit_for_year": -3996610,
            "financial_score": 97.5,
            "fundraising_expenses": 340744,
            "net_assets": 106050901,
            "organization_type": "Arts, Culture, Humanities : Museums",
            "other_revenue": 1248581,
            "overall_score": 94.07,
            "payments_to_affiliates": 0,
            "program_expenses": 13388504,
            "state": "NC",
            "total_contributions": 2329222
        },
        {
            "id": 89,
            "accountability_score": 77,
            "administrative_expenses": 102567,
            "charity_name": "Discovery Institute",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=9757",
            "city": "Seattle",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 144200,
            "compensation_leader_expense_percent": 3.4,
            "compensation_leader_title": "President",
            "excess_or_deficit_for_year": 1693215,
            "financial_score": 92.71,
            "fundraising_expenses": 340504,
            "net_assets": 4940044,
            "organization_type": "Research and Public Policy : Social and Public Policy Research",
            "other_revenue": 61097,
            "overall_score": 82.93,
            "payments_to_affiliates": 0,
            "program_expenses": 3792540,
            "state": "WA",
            "total_contributions": 5773002
        },
        {
            "id": 90,
            "accountability_score": 89,
            "administrative_expenses": 484442,
            "charity_name": "Discovery Green Conservancy",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=14701",
            "city": "Houston",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 204685,
            "compensation_leader_expense_percent": 3.31,
            "compensation_leader_title": "President",
            "excess_or_deficit_for_year": -782355,
            "financial_score": 96,
            "fundraising_expenses": 405506,
            "net_assets": 39853956,
            "organization_type": "Environment : Botanical Gardens, Parks, and Nature Centers",
            "other_revenue": -32372,
            "overall_score": 91.72,
            "payments_to_affiliates": 0,
            "program_expenses": 5293664,
            "state": "TX",
            "total_contributions": 3173699
        },
        {
            "id": 91,
            "accountability_score": 96,
            "administrative_expenses": 135469,
            "charity_name": "The Discovery Museums",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=17310",
            "city": "Acton",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 166193,
            "compensation_leader_expense_percent": 9.99,
            "compensation_leader_title": "Chief Executive Officer",
            "excess_or_deficit_for_year": 1351434,
            "financial_score": 88.57,
            "fundraising_expenses": 219414,
            "net_assets": 7857273,
            "organization_type": "Arts, Culture, Humanities : Museums",
            "other_revenue": 125786,
            "overall_score": 91.43,
            "payments_to_affiliates": 0,
            "program_expenses": 1307953,
            "state": "MA",
            "total_contributions": 1919521
        },
        {
            "id": 92,
            "accountability_score": 66,
            "administrative_expenses": 323958,
            "charity_name": "Discovery Eye Foundation",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=6476",
            "city": "Los Angeles",
            "cn_advisory": "nan",
            "compensation_leader_compensation": "",
            "compensation_leader_expense_percent": "",
            "compensation_leader_title": "President, Medical Director",
            "excess_or_deficit_for_year": -464025,
            "financial_score": 73.75,
            "fundraising_expenses": 56556,
            "net_assets": 744604,
            "organization_type": "Health : Medical Research",
            "other_revenue": 75133,
            "overall_score": 69.62,
            "payments_to_affiliates": 0,
            "program_expenses": 517024,
            "state": "CA",
            "total_contributions": 358380
        },
        {
            "id": 93,
            "accountability_score": 96,
            "administrative_expenses": 1617200,
            "charity_name": "DISCOVERY Children's Museum",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12244",
            "city": "Las Vegas",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 159689,
            "compensation_leader_expense_percent": 2.69,
            "compensation_leader_title": "Trustee",
            "excess_or_deficit_for_year": -1804631,
            "financial_score": 86.26,
            "fundraising_expenses": 204866,
            "net_assets": 47244316,
            "organization_type": "Arts, Culture, Humanities : Museums",
            "other_revenue": 436819,
            "overall_score": 89.88,
            "payments_to_affiliates": 0,
            "program_expenses": 4100910,
            "state": "NV",
            "total_contributions": 1798271
        },
        {
            "id": 94,
            "accountability_score": 89,
            "administrative_expenses": 126259,
            "charity_name": "Discovery Center of Springfield",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12042",
            "city": "Spring",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 77500,
            "compensation_leader_expense_percent": 6.09,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -288198,
            "financial_score": 82.5,
            "fundraising_expenses": 88066,
            "net_assets": 4144829,
            "organization_type": "Arts, Culture, Humanities : Museums",
            "other_revenue": 58397,
            "overall_score": 85.38,
            "payments_to_affiliates": 0,
            "program_expenses": 1056727,
            "state": "MO",
            "total_contributions": 469066
        },
        {
            "id": 95,
            "accountability_score": 100,
            "administrative_expenses": 355180,
            "charity_name": "DiscipleMakers",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=6879",
            "city": "State College",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 54000,
            "compensation_leader_expense_percent": 1.37,
            "compensation_leader_title": "President",
            "excess_or_deficit_for_year": 144888,
            "financial_score": 89.28,
            "fundraising_expenses": 327414,
            "net_assets": 1469574,
            "organization_type": "Religion : Religious Activities",
            "other_revenue": 2011,
            "overall_score": 92.41,
            "payments_to_affiliates": 0,
            "program_expenses": 3233039,
            "state": "PA",
            "total_contributions": 3913760
        },
        {
            "id": 96,
            "accountability_score": 66,
            "administrative_expenses": 42704,
            "charity_name": "Disabled Police and Sheriff's Foundation",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12035",
            "city": "Ste. Genevieve",
            "cn_advisory": "nan",
            "compensation_leader_compensation": "",
            "compensation_leader_expense_percent": "",
            "compensation_leader_title": "nan",
            "excess_or_deficit_for_year": 11536,
            "financial_score": 0,
            "fundraising_expenses": 1401140,
            "net_assets": 4472,
            "organization_type": "Human Services : Multipurpose Human Service Organizations",
            "other_revenue": 10,
            "overall_score": 25.31,
            "payments_to_affiliates": 0,
            "program_expenses": 85839,
            "state": "MO",
            "total_contributions": 1541209
        },
        {
            "id": 97,
            "accountability_score": 96,
            "administrative_expenses": 2000823,
            "charity_name": "Disabled Veterans National Foundation",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=13131",
            "city": "Lanham",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 144616,
            "compensation_leader_expense_percent": 0.49,
            "compensation_leader_title": "Chief Executive Officer",
            "excess_or_deficit_for_year": -1560501,
            "financial_score": 0,
            "fundraising_expenses": 19776427,
            "net_assets": -3967104,
            "organization_type": "Human Services : Social Services",
            "other_revenue": 275135,
            "overall_score": 29.23,
            "payments_to_affiliates": 0,
            "program_expenses": 7523867,
            "state": "MD",
            "total_contributions": 27465481
        },
        {
            "id": 98,
            "accountability_score": 93,
            "administrative_expenses": 251918,
            "charity_name": "DIFFA",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=7766",
            "city": "New York",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 139098,
            "compensation_leader_expense_percent": 5.51,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 62949,
            "financial_score": 68.82,
            "fundraising_expenses": 780133,
            "net_assets": 904941,
            "organization_type": "Health : Diseases, Disorders, and Disciplines",
            "other_revenue": -226019,
            "overall_score": 77.4,
            "payments_to_affiliates": 0,
            "program_expenses": 1488252,
            "state": "NY",
            "total_contributions": 2764090
        },
        {
            "id": 99,
            "accountability_score": 89,
            "administrative_expenses": 140337,
            "charity_name": "The Dictionary Project",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12371",
            "city": "Charleston",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 64395,
            "compensation_leader_expense_percent": 1.36,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": 59470,
            "financial_score": 78.24,
            "fundraising_expenses": 41440,
            "net_assets": 619363,
            "organization_type": "Education : Youth Education Programs and Services",
            "other_revenue": 3495,
            "overall_score": 82.75,
            "payments_to_affiliates": 0,
            "program_expenses": 4541999,
            "state": "SC",
            "total_contributions": 4779751
        },
        {
            "id": 100,
            "accountability_score": 100,
            "administrative_expenses": 99755,
            "charity_name": "Diabetes Youth Families",
            "charity_url": "https://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=10892",
            "city": "Concord",
            "cn_advisory": "nan",
            "compensation_leader_compensation": 124604,
            "compensation_leader_expense_percent": 5.18,
            "compensation_leader_title": "Executive Director",
            "excess_or_deficit_for_year": -113202,
            "financial_score": 85.04,
            "fundraising_expenses": 340014,
            "net_assets": 4903689,
            "organization_type": "Health : Patient and Family Support",
            "other_revenue": 271556,
            "overall_score": 89.42,
            "payments_to_affiliates": 0,
            "program_expenses": 1963217,
            "state": "CA",
            "total_contributions": 1493372
        }
    ]
}
              
            
!
999px

Console