Data source: Big Local News · About: Big Local

629,755 rows where state = "NY" sorted by ccd_school_low_grade descending

View and edit SQL

grade

year

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
2156364 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156365 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156366 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156367 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156368 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156369 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156370 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156371 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156372 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156373 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156374 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156375 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156376 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156377 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156378 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   pk_12_total 11.0 40.0 20.0   1.0     4.0     1.0   48.0 29.0     *       *     *   77 11 40 20   1     4     1   48 29                 77
2156379 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156380 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156381 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156382 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   ungraded_secondary 11.0 40.0 20.0   1.0     4.0     1.0   48.0 29.0     *       *     *   77 11 40 20   1     4     1   48 29                 77
1532992 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1532993 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1532994 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1532995 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1532996 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1532997 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1532998 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1532999 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1533000 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1533001 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1533002 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1533003 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1533004 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1533005 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1533006 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   pk_12_total 1.0 12.0 17.0         1.0         27.0 4.0     *       28     31   31 1 12 17         1         27 4         28   31   31
1533007 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1533008 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
1533009 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   ungraded_elementary 1.0 12.0 17.0         1.0         27.0 4.0     *       28     31   31 1 12 17         1         27 4         28   31   31
1533010 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   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
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
745199 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   grade_1 29.0 7.0 2.0   0.0     1.0     3.0   19.0 23.0             10     *   42 29 7 2   0     1     3   19 23         10       42
745200 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   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   0
745201 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   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   0
745202 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   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         0   0   0
745203 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   grade_2 27.0 4.0 6.0   1.0     2.0     3.0   24.0 19.0             8     *   43 27 4 6   1     2     3   24 19         8       43
745204 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   grade_3 22.0 9.0 9.0   0.0     2.0     3.0   12.0 33.0             7     0   45 22 9 9   0     2     3   12 33         7   0   45
745205 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   grade_4 25.0 13.0 2.0   0.0     5.0     2.0   14.0 33.0             13     *   47 25 13 2   0     5     2   14 33         13       47
745206 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   grade_5 22.0 11.0 4.0   0.0     6.0     2.0   16.0 29.0             11     *   45 22 11 4   0     6     2   16 29         11       45
745207 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   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         0   0   0
745208 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   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   0
745209 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   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   0
745210 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   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   0
745211 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   kindergarten_full_day 29.0 7.0 4.0   0.0     2.0     2.0   26.0 18.0             6     7   44 29 7 4   0     2     2   26 18         6   7   44
745212 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   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
745213 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   pk_12_total 177.0 63.0 33.0   1.0     20.0     17.0   137.0 174.0             66     25   311 177 63 33   1     20     17   137 174         66   25   311
745214 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   pre_kindergarten_full_day 20.0 8.0 5.0   0.0     1.0     2.0   18.0 18.0             6     *   36 20 8 5   0     1     2   18 18         6       36
745215 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   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
745216 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   ungraded_elementary 3.0 4.0 1.0   0.0     1.0     0.0   8.0 1.0             5     9   9 3 4 1   0     1     0   8 1         5   9   9
745217 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   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
745218 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   grade_1 19.0 28.0 15.0         8.0     7.0   44.0 33.0             53     10   77 19 28 15         8     7   44 33         53   10   77
745219 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   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
745220 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   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
745221 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   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
745222 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   grade_2 18.0 27.0 12.0         7.0     7.0   29.0 42.0             45     6   71 18 27 12         7     7   29 42         45   6   71
745223 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   grade_3 11.0 23.0 15.0         4.0     3.0   24.0 32.0             39     10   56 11 23 15         4     3   24 32         39   10   56
745224 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   grade_4 8.0 29.0 7.0         3.0     7.0   32.0 22.0             34     12   54 8 29 7         3     7   32 22         34   12   54
745225 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   grade_5 8.0 24.0 7.0         1.0     4.0   26.0 18.0             31     8   44 8 24 7         1     4   26 18         31   8   44
745226 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   grade_6 9.0 29.0 7.0         4.0     1.0   26.0 24.0             *     9   50 9 29 7         4     1   26 24             9   50
745227 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   grade_7 0.0 1.0 0.0         0.0     0.0   0.0 1.0             *     0   1 0 1 0         0     0   0 1             0   1
745228 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   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
745229 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   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
745230 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   kindergarten_full_day 17.0 23.0 20.0         5.0     5.0   36.0 34.0             43     6   70 17 23 20         5     5   36 34         43   6   70
745231 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   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
745232 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   pk_12_total 90.0 184.0 83.0         32.0     34.0   217.0 206.0             272     61   423 90 184 83         32     34   217 206         272   61   423
745233 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   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
745234 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   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
745235 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   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
745236 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   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
745237 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2015   grade_1 12.0 26.0 26.0   1.0     10.0     3.0   36.0 42.0             57     8   78 12 26 26   1     10     3   36 42         57   8   78
745238 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2015   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   0
745239 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2015   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   0
745240 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2015   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         0   0   0
745241 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2015   grade_2 10.0 31.0 28.0   0.0     10.0     1.0   41.0 39.0             65     15   80 10 31 28   0     10     1   41 39         65   15   80

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