Data source: Big Local News · About: Big Local

90,193 rows where state = "NY" and year = 2016 sorted by district_nces_id descending

View and edit SQL

year

  • 2016 · 90,193
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
1043666 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043667 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043668 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043669 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043670 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043671 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043672 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043673 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043674 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043675 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   grade_7 54.0 1.0 0.0         1.0     0.0   27.0 29.0             22     10   56 54 1 0         1     0   27 29         22   10   56
1043676 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   grade_8 69.0 5.0 2.0         0.0     2.0   43.0 35.0             25     12   78 69 5 2         0     2   43 35         25   12   78
1043677 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043678 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043679 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043680 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   pk_12_total 123.0 6.0 2.0         1.0     2.0   70.0 64.0             47     22   134 123 6 2         1     2   70 64         47   22   134
1043681 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043682 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043683 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1043684 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   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
1047580 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047581 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047582 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047583 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047584 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047585 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047586 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047587 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047588 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047589 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047590 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047591 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047592 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   kindergarten_full_day 20.0 170.0 123.0         2.0     44.0   197.0 162.0             268     58   359 20 170 123         2     44   197 162         268   58   359
1047593 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047594 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   pk_12_total 28.0 225.0 180.0         2.0     52.0   260.0 227.0             356     71   487 28 225 180         2     52   260 227         356   71   487
1047595 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047596 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   pre_kindergarten_half_day 8.0 55.0 57.0         0.0     8.0   63.0 65.0             88     13   128 8 55 57         0     8   63 65         88   13   128
1047597 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1047598 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1033273 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1033274 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_10 60.0 1.0 3.0   1.0     1.0     0.0   32.0 34.0             28     11   66 60 1 3   1     1     0   32 34         28   11   66
1033275 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_11 49.0 3.0 1.0   0.0     0.0     1.0   28.0 26.0             27     *   54 49 3 1   0     0     1   28 26         27       54
1033276 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_12 65.0 1.0 1.0   0.0     0.0     2.0   36.0 33.0             30     *   69 65 1 1   0     0     2   36 33         30       69
1033277 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1033278 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1033279 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1033280 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1033281 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1033282 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1033283 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1033284 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_9 66.0 1.0 3.0   0.0     2.0     0.0   39.0 33.0             32     13   72 66 1 3   0     2     0   39 33         32   13   72
1033285 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1033286 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1033287 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   pk_12_total 240.0 6.0 8.0   1.0     3.0     3.0   135.0 126.0             117     37   261 240 6 8   1     3     3   135 126         117   37   261
1033288 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1033289 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1033290 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1033291 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1033292 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   grade_1 67.0 2.0 1.0   0.0     0.0         41.0 29.0             43     11   70 67 2 1   0     0         41 29         43   11   70
1033293 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   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
1033294 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   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
1033295 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   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
1033296 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   grade_2 59.0 0.0 1.0   0.0     0.0         29.0 31.0             40     12   60 59 0 1   0     0         29 31         40   12   60
1033297 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   grade_3 45.0 0.0 1.0   0.0     1.0         23.0 24.0             27     *   47 45 0 1   0     1         23 24         27       47
1033298 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   grade_4 56.0 0.0 0.0   0.0     0.0         26.0 30.0             36     9   56 56 0 0   0     0         26 30         36   9   56
1033299 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   grade_5 46.0 0.0 1.0   1.0     0.0         29.0 19.0             29     6   48 46 0 1   1     0         29 19         29   6   48
1033300 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   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
1033301 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   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
1033302 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   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
1033303 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   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
1033304 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   kindergarten_full_day 45.0 3.0 0.0   0.0     0.0         21.0 27.0             29     *   48 45 3 0   0     0         21 27         29       48
1033305 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   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
1033306 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   pk_12_total 346.0 7.0 4.0   1.0     1.0         185.0 174.0             216     49   359 346 7 4   1     1         185 174         216   49   359
1033307 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   pre_kindergarten_full_day 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
1033308 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   pre_kindergarten_half_day 27.0 2.0 0.0   0.0     0.0         16.0 13.0             12     5   29 27 2 0   0     0         16 13         12   5   29
1033309 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   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
1033310 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   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
1033311 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   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
1033312 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   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
1033313 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   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
1033314 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   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
1033315 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   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
1033316 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   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
1033317 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   grade_4 1.0 0.0 0.0         0.0     0.0   1.0 0.0             0     *   1 1 0 0         0     0   1 0         0       1
1033318 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   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
1033319 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   grade_6 63.0 2.0 4.0         0.0     0.0   42.0 27.0             43     10   69 63 2 4         0     0   42 27         43   10   69
1033320 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   grade_7 62.0 0.0 0.0         1.0     0.0   39.0 24.0             32     *   63 62 0 0         1     0   39 24         32       63
1033321 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   grade_8 69.0 1.0 2.0         1.0     1.0   43.0 31.0             36     11   74 69 1 2         1     1   43 31         36   11   74
1033322 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   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
1033323 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   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
1033324 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   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
1033325 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   pk_12_total 195.0 3.0 6.0         2.0     1.0   125.0 82.0             111     31   207 195 3 6         2     1   125 82         111   31   207
1033326 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   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
1033327 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   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
1033328 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   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
1033329 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   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
1121547 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1121548 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_10 257.0 10.0 36.0   1.0     11.0     5.0   165.0 155.0             37     47   320 257 10 36   1     11     5   165 155         37   47   320
1121549 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_11 232.0 3.0 36.0   0.0     16.0     12.0   142.0 157.0             25     49   299 232 3 36   0     16     12   142 157         25   49   299
1121550 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_12 246.0 4.0 28.0   1.0     16.0     7.0   159.0 143.0             *     43   302 246 4 28   1     16     7   159 143             43   302
1121551 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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

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