Data source: Big Local News · About: Big Local

90,079 rows where state = "NY" and year = 2021 sorted by ccd_school_type descending

View and edit SQL

year

  • 2021 · 90,079
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
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
1443045 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_secondary 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1450494 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2021   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1450495 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 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         0   0   0
1450496 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2021   grade_11 1.0 0.0 0.0         0.0     0.0   0.0 1.0     *       *     *   1 1 0 0         0     0   0 1                 1
1450497 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 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         0   0   0
1450498 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2021   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1450499 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2021   grade_3 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1450500 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2021   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1450501 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2021   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1450502 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 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         0   0   0
1450503 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 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         0   0   0
1450504 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 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         0   0   0
1450505 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 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         0   0   0
1450506 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 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         0   0   0
1450507 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 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         0   0   0
1450508 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2021   pk_12_total 11.0 40.0 15.0         3.0     1.0   40.0 30.0     *       62     70   70 11 40 15         3     1   40 30         62   70   70
1450509 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 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         0   0   0
1450510 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 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         0   0   0
1450511 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2021   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1450512 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2021   ungraded_secondary 10.0 40.0 15.0         3.0     1.0   40.0 29.0     *       *     *   69 10 40 15         3     1   40 29                 69
1450817 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 2021   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1450818 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 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 0     0   0   0   0
1450819 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 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 0     0   0   0   0
1450820 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 2021   grade_12 1.0 0.0 0.0         0.0     0.0   0.0 1.0     0       0     *   1 1 0 0         0     0   0 1     0   0       1
1450821 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 2021   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1450822 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 2021   grade_3 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1450823 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 2021   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1450824 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 2021   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1450825 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 2021   grade_6 1.0 0.0 0.0         0.0     0.0   1.0 0.0     0       *     0   1 1 0 0         0     0   1 0     0       0   1
1450826 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 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 0     0   0   0   0
1450827 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 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 0     0   0   0   0
1450828 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 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 0     0   0   0   0
1450829 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 2021   kindergarten_full_day 0.0 1.0 0.0         0.0     0.0   1.0 0.0     0       0     0   1 0 1 0         0     0   1 0     0   0   0   1
1450830 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 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 0     0   0   0   0
1450831 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 2021   pk_12_total 58.0 72.0 37.0         12.0     7.0   108.0 78.0     31       154     180   186 58 72 37         12     7   108 78     31   154   180   186
1450832 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 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 0     0   0   0   0
1450833 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 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 0     0   0   0   0
1450834 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 2021   ungraded_elementary 21.0 40.0 16.0         2.0     5.0   53.0 31.0     6       *     *   84 21 40 16         2     5   53 31     6           84
1450835 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 2021   ungraded_secondary 35.0 31.0 21.0         10.0     2.0   53.0 46.0     25       78     96   99 35 31 21         10     2   53 46     25   78   96   99
1477854 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1477855 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   grade_10 8.0 40.0 40.0   0.0     0.0     0.0   56.0 32.0     *       77     73   88 8 40 40   0     0     0   56 32         77   73   88
1477856 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   grade_11 4.0 7.0 10.0   0.0     2.0     0.0   15.0 8.0     *       17     18   23 4 7 10   0     2     0   15 8         17   18   23
1477857 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   grade_12 10.0 9.0 13.0   0.0     3.0     0.0   28.0 7.0     *       24     31   35 10 9 13   0     3     0   28 7         24   31   35
1477858 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1477859 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   grade_3 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1477860 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   grade_4 0.0 1.0 1.0   0.0     0.0     0.0   2.0 0.0     0       *     *   2 0 1 1   0     0     0   2 0     0           2
1477861 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   grade_5 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0     0       *     0   1 0 0 1   0     0     0   1 0     0       0   1
1477862 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   grade_6 0.0 0.0 3.0   0.0     0.0     0.0   0.0 3.0     0       *     *   3 0 0 3   0     0     0   0 3     0           3
1477863 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   grade_7 0.0 0.0 1.0   0.0     0.0     0.0   0.0 1.0     0       *     0   1 0 0 1   0     0     0   0 1     0       0   1
1477864 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   grade_8 1.0 1.0 3.0   0.0     1.0     0.0   1.0 5.0     0       *     *   6 1 1 3   0     1     0   1 5     0           6
1477865 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   grade_9 10.0 32.0 39.0   2.0     4.0     2.0   71.0 18.0     7       81     82   89 10 32 39   2     4     2   71 18     7   81   82   89
1477866 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 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     0     0   0 0     0   0   0   0
1477867 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 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     0     0   0 0     0   0   0   0
1477868 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   pk_12_total 33.0 90.0 111.0   2.0     10.0     2.0   174.0 74.0     16       209     212   248 33 90 111   2     10     2   174 74     16   209   212   248
1477869 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 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     0     0   0 0     0   0   0   0
1477870 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 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     0     0   0 0     0   0   0   0
1477871 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1477872 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   ungraded_secondary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1477873 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1477874 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   grade_10 0.0 3.0 6.0   0.0     0.0     0.0   6.0 3.0     *       8     9   9 0 3 6   0     0     0   6 3         8   9   9
1477875 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   grade_11 1.0 5.0 7.0   0.0     0.0     1.0   8.0 6.0     *       14     14   14 1 5 7   0     0     1   8 6         14   14   14
1477876 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   grade_12 5.0 56.0 105.0   1.0     4.0     0.0   113.0 58.0     64       164     170   171 5 56 105   1     4     0   113 58     64   164   170   171
1477877 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1477878 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   grade_3 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1477879 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1477880 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1477881 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   grade_6 2.0 6.0 5.0   0.0     0.0     0.0   11.0 2.0     *       12     13   13 2 6 5   0     0     0   11 2         12   13   13
1477882 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   grade_7 0.0 3.0 3.0   0.0     0.0     0.0   5.0 1.0     *       6     *   6 0 3 3   0     0     0   5 1         6       6
1477883 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   grade_8 0.0 3.0 3.0   0.0     0.0     0.0   5.0 1.0     0       *     6   6 0 3 3   0     0     0   5 1     0       6   6
1477884 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   grade_9 0.0 3.0 3.0   0.0     0.0     0.0   3.0 3.0     *       6     6   6 0 3 3   0     0     0   3 3         6   6   6
1477885 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 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     0     0   0 0     0   0   0   0
1477886 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 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     0     0   0 0     0   0   0   0
1477887 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   pk_12_total 8.0 79.0 133.0   1.0     4.0     1.0   151.0 75.0     78       216     225   226 8 79 133   1     4     1   151 75     78   216   225   226
1477888 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 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     0     0   0 0     0   0   0   0
1477889 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 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     0     0   0 0     0   0   0   0
1477890 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1477891 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504807 307500011079 PS 79 HORAN SCHOOL public Special Education School No Middle 06 06 2021   ungraded_secondary 0.0 0.0 1.0   0.0     0.0     0.0   0.0 1.0     0       *     *   1 0 0 1   0     0     0   0 1     0           1
1477892 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504596 307500011094 PS 94 public Special Education School No Elementary KG 08 2021   grade_1 5.0 16.0 7.0   0.0     1.0     0.0   22.0 7.0     *       22     29   29 5 16 7   0     1     0   22 7         22   29   29
1477893 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504596 307500011094 PS 94 public Special Education School No Elementary KG 08 2021   grade_10 0.0 1.0 3.0   0.0     0.0     0.0   3.0 1.0     *       *     *   4 0 1 3   0     0     0   3 1                 4
1477894 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504596 307500011094 PS 94 public Special Education School No Elementary KG 08 2021   grade_11 0.0 2.0 2.0   0.0     0.0     0.0   3.0 1.0     *       *     *   4 0 2 2   0     0     0   3 1                 4
1477895 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504596 307500011094 PS 94 public Special Education School No Elementary KG 08 2021   grade_12 2.0 4.0 6.0   1.0     5.0     0.0   10.0 8.0     9       15     18   18 2 4 6   1     5     0   10 8     9   15   18   18
1477896 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504596 307500011094 PS 94 public Special Education School No Elementary KG 08 2021   grade_2 8.0 7.0 15.0   0.0     4.0     0.0   30.0 4.0     8       31     34   34 8 7 15   0     4     0   30 4     8   31   34   34

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]);