enrollments

Data source: Big Local News · About: Big Local

3,371,677 rows sorted by ccd_school_high_grade descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade ▲ year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
398756 398756 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   ged 0.0 0.0 0.0     0.0                                       0.0 0 0 0     0                                 0
398757 398757 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   grade_1 0.0 0.0 0.0     0.0                                       0.0 0 0 0     0                                 0
398758 398758 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   grade_10 0.0 0.0 0.0     0.0                                       0.0 0 0 0     0                                 0
398759 398759 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   grade_11 0.0 0.0 0.0     0.0                                       0.0 0 0 0     0                                 0
398760 398760 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   grade_12 0.0 0.0 0.0     0.0                                       0.0 0 0 0     0                                 0
398761 398761 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   grade_2 0.0 0.0 0.0     0.0                                       0.0 0 0 0     0                                 0
398762 398762 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   grade_3 0.0 0.0 0.0     0.0                                       0.0 0 0 0     0                                 0
398763 398763 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   grade_4 0.0 0.0 0.0     0.0                                       0.0 0 0 0     0                                 0
398764 398764 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   grade_5 0.0 0.0 0.0     0.0                                       0.0 0 0 0     0                                 0
398765 398765 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   grade_6 0.0 0.0 0.0     0.0                                       0.0 0 0 0     0                                 0
398766 398766 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   grade_7 0.0 0.0 0.0     0.0                                       0.0 0 0 0     0                                 0
398767 398767 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   grade_8 0.0 0.0 0.0     0.0                                       0.0 0 0 0     0                                 0
398768 398768 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   grade_9 0.0 0.0 0.0     0.0                                       0.0 0 0 0     0                                 0
398769 398769 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   k_12_total 11.0 82.0 8.0     1.0             23.0 79.0                       102.0 11 82 8     1             23 79                 102
398770 398770 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   kindergarten 0.0 0.0 0.0     0.0                                       0.0 0 0 0     0                                 0
398771 398771 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2019   ungraded 11.0 82.0 8.0     1.0                                       102.0 11 82 8     1                                 102
444766 444766 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   ged 0.0 0.0 0.0                                             0.0 0 0 0                                       0
444767 444767 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   grade_1 0.0 0.0 0.0                                             0.0 0 0 0                                       0
444768 444768 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   grade_10 0.0 0.0 0.0                                             0.0 0 0 0                                       0
444769 444769 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   grade_11 0.0 0.0 0.0                                             0.0 0 0 0                                       0
444770 444770 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   grade_12 0.0 0.0 0.0                                             0.0 0 0 0                                       0
444771 444771 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   grade_2 0.0 0.0 0.0                                             0.0 0 0 0                                       0
444772 444772 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   grade_3 0.0 0.0 0.0                                             0.0 0 0 0                                       0
444773 444773 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   grade_4 0.0 0.0 0.0                                             0.0 0 0 0                                       0
444774 444774 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   grade_5 0.0 0.0 0.0                                             0.0 0 0 0                                       0
444775 444775 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   grade_6 0.0 0.0 0.0                                             0.0 0 0 0                                       0
444776 444776 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   grade_7 0.0 0.0 0.0                                             0.0 0 0 0                                       0
444777 444777 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   grade_8 0.0 0.0 0.0                                             0.0 0 0 0                                       0
444778 444778 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   grade_9 0.0 0.0 0.0                                             0.0 0 0 0                                       0
444779 444779 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   k_12_total 19.0 101.0 7.0                   23.0 104.0                       127.0 19 101 7                   23 104                 127
444780 444780 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   kindergarten 0.0 0.0 0.0                                             0.0 0 0 0                                       0
444781 444781 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2021   ungraded 19.0 101.0 7.0                                             127.0 19 101 7                                       127
510725 510725 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   ged 0.0 0.0 0.0                                             0.0 0 0 0                                       0
510726 510726 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   grade_1 0.0 0.0 0.0                                             0.0 0 0 0                                       0
510727 510727 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   grade_10 0.0 0.0 0.0                                             0.0 0 0 0                                       0
510728 510728 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   grade_11 0.0 0.0 0.0                                             0.0 0 0 0                                       0
510729 510729 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   grade_12 0.0 0.0 0.0                                             0.0 0 0 0                                       0
510730 510730 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   grade_2 0.0 0.0 0.0                                             0.0 0 0 0                                       0
510731 510731 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   grade_3 0.0 0.0 0.0                                             0.0 0 0 0                                       0
510732 510732 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   grade_4 0.0 0.0 0.0                                             0.0 0 0 0                                       0
510733 510733 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   grade_5 0.0 0.0 0.0                                             0.0 0 0 0                                       0
510734 510734 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   grade_6 0.0 0.0 0.0                                             0.0 0 0 0                                       0
510735 510735 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   grade_7 0.0 0.0 0.0                                             0.0 0 0 0                                       0
510736 510736 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   grade_8 0.0 0.0 0.0                                             0.0 0 0 0                                       0
510737 510737 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   grade_9 0.0 0.0 0.0                                             0.0 0 0 0                                       0
510738 510738 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   k_12_total 16.0 74.0 3.0                   19.0 74.0                       93.0 16 74 3                   19 74                 93
510739 510739 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   kindergarten 0.0 0.0 0.0                                             0.0 0 0 0                                       0
510740 510740 AR     school 500420 6058700   THE EXCEL CENTER 50042001638 6058703 THE EXCEL CENTER   Regular School Yes Ungraded UG UG 2020   ungraded 16.0 74.0 3.0                                             93.0 16 74 3                                       93
744654 744654 MA Middlesex   school 2508790 735   North Middlesex 250879002705 7350515 Peter Fitzpatrick School   Regular School No 4 UG UG 2015   SP * * * *   *     *   *                             1                                             1
941477 941477 MA Middlesex   school 2508790 735   North Middlesex 250879002705 7350515 Peter Fitzpatrick School   Regular School No 4 UG UG 2016   sped_beyond_grade_12 10 0 0 0   0     0   0   * *                       10 10 0 0 0   0     0   0                       10
1132536 1132536 MA Middlesex   school 2508790 735   North Middlesex 250879002705 7350515 Peter Fitzpatrick School   Regular School No Ungraded UG UG 2017   sped_beyond_grade_12 10 0 0 0   0     0   0                             10 10 0 0 0   0     0   0                       10
1368456 1368456 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1368457 1368457 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   pre_kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1368458 1368458 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1368459 1368459 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1368460 1368460 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_3 * * * *   *     *   *   * * *                     0.0                                             0
1368461 1368461 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1368462 1368462 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1368463 1368463 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1368464 1368464 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1368465 1368465 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1368466 1368466 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1368467 1368467 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_10 * * * *   *     *   *   * * *                     0.0                                             0
1368468 1368468 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_11 * * * *   *     *   *   * * *                     0.0                                             0
1368469 1368469 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1368470 1368470 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   sped_beyond_grade_12 6 0 0 0   0     0   0   * * *                     6.0 6 0 0 0   0     0   0                       6
1371080 1371080 MA Hampden   school 2511130 281   Springfield 251113002875 2810675 Springfield Vocational Academy   Special Education School No Ungraded UG UG 2020   sped_beyond_grade_12 10 22 70 0   4     0   1   65 42 *                     107.0 10 22 70 0   4     0   1   65 42                 107
1374306 1374306 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1374307 1374307 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   pre_kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1374308 1374308 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1374309 1374309 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1374310 1374310 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_3 * * * *   *     *   *   * * *                     0.0                                             0
1374311 1374311 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1374312 1374312 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1374313 1374313 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1374314 1374314 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1374315 1374315 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1374316 1374316 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1374317 1374317 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_10 * * * *   *     *   *   * * *                     0.0                                             0
1374318 1374318 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_11 * * * *   *     *   *   * * *                     0.0                                             0
1374319 1374319 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1374320 1374320 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   sped_beyond_grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1443027 1443027 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   grade_1 0.0 5.0 6.0         2.0         11.0 2.0     *       11     13   13 0 5 6         2         11 2         11   13   13
1443028 1443028 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   grade_10 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1443029 1443029 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   grade_11 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1443030 1443030 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   grade_12 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1443031 1443031 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   grade_2 0.0 1.0 1.0         0.0         2.0 0.0     *       *     *   2 0 1 1         0         2 0                 2
1443032 1443032 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   grade_3 1.0 3.0 3.0         0.0         6.0 1.0     *       6     7   7 1 3 3         0         6 1         6   7   7
1443033 1443033 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   grade_4 0.0 2.0 3.0         0.0         4.0 1.0     *       *     *   5 0 2 3         0         4 1                 5
1443034 1443034 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   grade_5 0.0 0.0 1.0         0.0         1.0 0.0     *       *     *   1 0 0 1         0         1 0                 1
1443035 1443035 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   grade_6 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1443036 1443036 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   grade_7 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1443037 1443037 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   grade_8 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1443038 1443038 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   grade_9 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1443039 1443039 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   kindergarten_full_day 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1443040 1443040 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   kindergarten_half_day 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1443041 1443041 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   pk_12_total 1.0 12.0 14.0         2.0         24.0 5.0     *       26     29   29 1 12 14         2         24 5         26   29   29
1443042 1443042 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   pre_kindergarten_full_day 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1443043 1443043 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   pre_kindergarten_half_day 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1443044 1443044 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   ungraded_elementary 0.0 1.0 0.0         0.0         0.0 1.0     *       *     *   1 0 1 0         0         0 1                 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);