enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
1031753 1031753 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   grade_1 32.0 9.0 4.0   0.0     4.0     2.0   31.0 20.0             12     7   51 32 9 4   0     4     2   31 20         12   7   51
1031754 1031754 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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         0   0   0
1031755 1031755 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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         0   0   0
1031756 1031756 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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         0   0   0
1031757 1031757 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   grade_2 30.0 7.0 4.0   0.0     1.0     3.0   18.0 27.0             19     *   45 30 7 4   0     1     3   18 27         19       45
1031758 1031758 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   grade_3 29.0 8.0 5.0   1.0     3.0     3.0   26.0 23.0             15     0   49 29 8 5   1     3     3   26 23         15   0   49
1031759 1031759 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   grade_4 22.0 9.0 9.0   0.0     2.0     3.0   13.0 32.0             9     0   45 22 9 9   0     2     3   13 32         9   0   45
1031760 1031760 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   grade_5 25.0 12.0 1.0   0.0     5.0     1.0   14.0 30.0             12     *   44 25 12 1   0     5     1   14 30         12       44
1031761 1031761 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031762 1031762 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031763 1031763 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031764 1031764 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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         0   0   0
1031765 1031765 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   kindergarten_full_day 28.0 12.0 3.0   0.0     2.0     3.0   23.0 25.0             14     *   48 28 12 3   0     2     3   23 25         14       48
1031766 1031766 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031767 1031767 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   pk_12_total 188.0 71.0 31.0   1.0     20.0     19.0   152.0 178.0             96     26   330 188 71 31   1     20     19   152 178         96   26   330
1031768 1031768 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   pre_kindergarten_full_day 20.0 8.0 3.0   0.0     1.0     4.0   19.0 17.0             6     *   36 20 8 3   0     1     4   19 17         6       36
1031769 1031769 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031770 1031770 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   ungraded_elementary 2.0 6.0 2.0   0.0     2.0     0.0   8.0 4.0             9     12   12 2 6 2   0     2     0   8 4         9   12   12
1031771 1031771 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031772 1031772 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_1 14.0 30.0 22.0   0.0     6.0     5.0   34.0 43.0             54     6   77 14 30 22   0     6     5   34 43         54   6   77
1031773 1031773 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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         0   0   0
1031774 1031774 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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         0   0   0
1031775 1031775 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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         0   0   0
1031776 1031776 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_2 14.0 30.0 19.0   0.0     8.0     5.0   46.0 30.0             56     10   76 14 30 19   0     8     5   46 30         56   10   76
1031777 1031777 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_3 16.0 26.0 11.0   0.0     5.0     7.0   26.0 39.0             44     6   65 16 26 11   0     5     7   26 39         44   6   65
1031778 1031778 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_4 6.0 24.0 11.0   0.0     5.0     5.0   20.0 31.0             40     *   51 6 24 11   0     5     5   20 31         40       51
1031779 1031779 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_5 8.0 22.0 8.0   0.0     3.0     8.0   27.0 22.0             31     10   49 8 22 8   0     3     8   27 22         31   10   49
1031780 1031780 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_6 9.0 26.0 7.0   0.0     1.0     5.0   27.0 21.0             31     7   48 9 26 7   0     1     5   27 21         31   7   48
1031781 1031781 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031782 1031782 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031783 1031783 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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         0   0   0
1031784 1031784 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   kindergarten_full_day 7.0 30.0 16.0   1.0     10.0     8.0   40.0 32.0             34     *   72 7 30 16   1     10     8   40 32         34       72
1031785 1031785 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031786 1031786 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   pk_12_total 74.0 188.0 94.0   1.0     38.0     43.0   220.0 218.0             290     48   438 74 188 94   1     38     43   220 218         290   48   438
1031787 1031787 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031788 1031788 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031789 1031789 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031790 1031790 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031791 1031791 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   grade_1 9.0 19.0 32.0   0.0     10.0     5.0   37.0 38.0             57     7   75 9 19 32   0     10     5   37 38         57   7   75
1031792 1031792 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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         0   0   0
1031793 1031793 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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         0   0   0
1031794 1031794 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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         0   0   0
1031795 1031795 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   grade_2 10.0 25.0 29.0   1.0     15.0     4.0   38.0 46.0             57     11   84 10 25 29   1     15     4   38 46         57   11   84
1031796 1031796 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   grade_3 8.0 23.0 32.0   0.0     9.0     3.0   39.0 36.0             57     8   75 8 23 32   0     9     3   39 36         57   8   75
1031797 1031797 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   grade_4 11.0 21.0 28.0   0.0     11.0     2.0   37.0 36.0             51     7   73 11 21 28   0     11     2   37 36         51   7   73
1031798 1031798 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   grade_5 9.0 37.0 17.0   1.0     8.0     3.0   37.0 38.0             54     5   75 9 37 17   1     8     3   37 38         54   5   75
1031799 1031799 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031800 1031800 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031801 1031801 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031802 1031802 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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         0   0   0
1031803 1031803 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   kindergarten_full_day 8.0 15.0 26.0   1.0     7.0     7.0   28.0 36.0             32     *   64 8 15 26   1     7     7   28 36         32       64
1031804 1031804 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031805 1031805 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   pk_12_total 61.0 141.0 175.0   3.0     60.0     24.0   224.0 240.0             313     43   464 61 141 175   3     60     24   224 240         313   43   464
1031806 1031806 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   pre_kindergarten_full_day 6.0 0.0 11.0   0.0     0.0     0.0   7.0 10.0             *     *   17 6 0 11   0     0     0   7 10                 17
1031807 1031807 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031808 1031808 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   ungraded_elementary 0.0 1.0 0.0   0.0     0.0     0.0   1.0 0.0             *     *   1 0 1 0   0     0     0   1 0                 1
1031809 1031809 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031810 1031810 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_1 52.0 24.0 8.0   0.0     3.0     9.0   57.0 39.0             42     16   96 52 24 8   0     3     9   57 39         42   16   96
1031811 1031811 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 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         0   0   0
1031812 1031812 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 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         0   0   0
1031813 1031813 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 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         0   0   0
1031814 1031814 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_2 50.0 16.0 11.0   0.0     8.0     4.0   51.0 38.0             21     11   89 50 16 11   0     8     4   51 38         21   11   89

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