enrollments

Data source: Big Local News · About: Big Local

89,661 rows where state = "NY" and year = 2019 sorted by hispanic

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 89,661 ✖
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
2140765 2140765 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_1 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140766 2140766 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_10 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140767 2140767 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_11 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140768 2140768 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_12 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140769 2140769 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_2 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140770 2140770 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_3 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140771 2140771 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_4 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140772 2140772 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_5 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140773 2140773 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_6 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140774 2140774 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_7 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140775 2140775 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_8 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140776 2140776 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_9 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140777 2140777 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   kindergarten_full_day 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140778 2140778 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   kindergarten_half_day 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140779 2140779 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   pk_12_total 14.0                       11.0 3.0             *     *   14 14                       11 3                 14
2140780 2140780 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   pre_kindergarten_full_day 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140781 2140781 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   pre_kindergarten_half_day 14.0                       11.0 3.0             *     *   14 14                       11 3                 14
2140782 2140782 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   ungraded_elementary 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140783 2140783 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   ungraded_secondary 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2152697 2152697 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_1 23.0 0.0                 1.0   12.0 12.0             14     *   24 23 0                 1   12 12         14       24
2152698 2152698 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_10 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2152699 2152699 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_11 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2152700 2152700 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_12 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2152701 2152701 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 22.0 1.0                 0.0   14.0 9.0             18     5   23 22 1                 0   14 9         18   5   23
2152702 2152702 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_3 32.0 2.0                 0.0   18.0 16.0             15     *   34 32 2                 0   18 16         15       34
2152703 2152703 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_4 36.0 0.0                 0.0   18.0 18.0             18     7   36 36 0                 0   18 18         18   7   36
2152704 2152704 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_5 40.0 0.0                 1.0   17.0 24.0             27     7   41 40 0                 1   17 24         27   7   41
2152705 2152705 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_6 29.0 2.0                 0.0   18.0 13.0             17     *   31 29 2                 0   18 13         17       31
2152706 2152706 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2152707 2152707 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_8 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2152708 2152708 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_9 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2152709 2152709 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_full_day 33.0 0.0                 2.0   15.0 20.0             19     *   35 33 0                 2   15 20         19       35
2152710 2152710 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
2152711 2152711 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 231.0 5.0                 4.0   121.0 119.0             137     36   240 231 5                 4   121 119         137   36   240
2152712 2152712 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pre_kindergarten_full_day 14.0 0.0                 0.0   7.0 7.0             *     *   14 14 0                 0   7 7                 14
2152713 2152713 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
2152714 2152714 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   ungraded_elementary 2.0 0.0                 0.0   2.0 0.0             *     *   2 2 0                 0   2 0                 2
2152715 2152715 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   ungraded_secondary 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2153533 2153533 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_1 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2153534 2153534 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_10 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2153535 2153535 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_11 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2153536 2153536 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_12 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2153537 2153537 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_2 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2153538 2153538 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_3 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2153539 2153539 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_4 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2153540 2153540 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_5 45.0                   0.0   22.0 23.0             28     *   45 45                   0   22 23         28       45
2153541 2153541 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_6 47.0                   0.0   22.0 25.0             25     8   47 47                   0   22 25         25   8   47
2153542 2153542 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_7 41.0                   0.0   14.0 27.0             26     9   41 41                   0   14 27         26   9   41
2153543 2153543 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_8 45.0                   1.0   17.0 29.0             *     15   46 45                   1   17 29             15   46
2153544 2153544 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_9 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2153545 2153545 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   kindergarten_full_day 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2153546 2153546 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   kindergarten_half_day 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2153547 2153547 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   pk_12_total 179.0                   1.0   75.0 105.0             104     38   180 179                   1   75 105         104   38   180
2153548 2153548 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   pre_kindergarten_full_day 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2153549 2153549 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   pre_kindergarten_half_day 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2153550 2153550 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   ungraded_elementary 1.0                   0.0   0.0 1.0             *     *   1 1                   0   0 1                 1
2153551 2153551 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   ungraded_secondary 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2158226 2158226 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158227 2158227 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158228 2158228 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158229 2158229 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158230 2158230 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158231 2158231 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158232 2158232 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158233 2158233 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 2019   grade_5 171.0 1.0           0.0     2.0   90.0 84.0             *     *   174 171 1           0     2   90 84                 174
2158234 2158234 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158235 2158235 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158236 2158236 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158237 2158237 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158238 2158238 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158239 2158239 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158240 2158240 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 2019   pk_12_total 173.0 1.0           1.0     2.0   91.0 86.0             43     41   177 173 1           1     2   91 86         43   41   177
2158241 2158241 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158242 2158242 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 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
2158243 2158243 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 2019   ungraded_elementary 2.0 0.0           1.0     0.0   1.0 2.0             *     *   3 2 0           1     0   1 2                 3
2158244 2158244 NY Erie   school 3615360 141301060000   IROQUOIS 361536001292 141301060002 IROQUOIS INTERMEDIATE SCHOOL public Regular School No Middle 05 05 2019   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
2159689 2159689 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_1 27.0             0.0         16.0 11.0             20     *   27 27             0         16 11         20       27
2159690 2159690 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_10 16.0             0.0         9.0 7.0             9     *   16 16             0         9 7         9       16
2159691 2159691 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_11 16.0             0.0         8.0 8.0             12     *   16 16             0         8 8         12       16
2159692 2159692 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_12 23.0             1.0         10.0 14.0             13     *   24 23             1         10 14         13       24
2159693 2159693 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_2 21.0             0.0         7.0 14.0             14     *   21 21             0         7 14         14       21
2159694 2159694 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_3 25.0             0.0         8.0 17.0             18     6   25 25             0         8 17         18   6   25
2159695 2159695 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_4 20.0             0.0         13.0 7.0             12     5   20 20             0         13 7         12   5   20
2159696 2159696 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_5 29.0             0.0         12.0 17.0             21     8   29 29             0         12 17         21   8   29
2159697 2159697 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_6 19.0             0.0         10.0 9.0             13     *   19 19             0         10 9         13       19
2159698 2159698 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 23.0             0.0         9.0 14.0             10     5   23 23             0         9 14         10   5   23
2159699 2159699 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_8 13.0             0.0         9.0 4.0             6     *   13 13             0         9 4         6       13
2159700 2159700 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_9 19.0             0.0         8.0 11.0             9     *   19 19             0         8 11         9       19
2159701 2159701 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   kindergarten_full_day 22.0             0.0         12.0 10.0             11     *   22 22             0         12 10         11       22
2159702 2159702 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   kindergarten_half_day 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
2159703 2159703 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   pk_12_total 290.0             1.0         139.0 152.0             175     50   291 290             1         139 152         175   50   291
2159704 2159704 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   pre_kindergarten_full_day 17.0             0.0         8.0 9.0             7     *   17 17             0         8 9         7       17
2159705 2159705 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   pre_kindergarten_half_day 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
2159706 2159706 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   ungraded_elementary 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
2159707 2159707 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2019   ungraded_secondary 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
2159784 2159784 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_1 44.0 0.0                     20.0 24.0             *     9   44 44 0                     20 24             9   44
2159785 2159785 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_10 0.0 0.0                     0.0 0.0             0     0   0 0 0                     0 0         0   0   0
2159786 2159786 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_11 0.0 0.0                     0.0 0.0             0     0   0 0 0                     0 0         0   0   0
2159787 2159787 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_12 0.0 0.0                     0.0 0.0             0     0   0 0 0                     0 0         0   0   0
2159788 2159788 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 54.0 0.0                     21.0 33.0             39     14   54 54 0                     21 33         39   14   54

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