Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2021 · 90,079
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic ▼ native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1434591 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_1 45.0 1.0                 1.0   29.0 18.0             26     6   47 45 1                 1   29 18         26   6   47
1434592 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_10 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1434593 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_11 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1434594 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_12 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1434595 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_2 49.0 0.0                 2.0   33.0 18.0             29     5   51 49 0                 2   33 18         29   5   51
1434596 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_3 48.0 0.0                 2.0   27.0 23.0             29     8   50 48 0                 2   27 23         29   8   50
1434597 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_4 45.0 0.0                 0.0   28.0 17.0             22     *   45 45 0                 0   28 17         22       45
1434598 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_5 38.0 0.0                 1.0   21.0 18.0             24     11   39 38 0                 1   21 18         24   11   39
1434599 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_6 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1434600 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1434601 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_8 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1434602 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_9 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1434603 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_full_day 48.0 1.0                 0.0   23.0 26.0             *     *   49 48 1                 0   23 26                 49
1434604 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_half_day 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1434605 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pk_12_total 296.0 2.0                 7.0   169.0 136.0             154     38   305 296 2                 7   169 136         154   38   305
1434606 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pre_kindergarten_full_day 23.0 0.0                 1.0   8.0 16.0             *     *   24 23 0                 1   8 16                 24
1434607 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pre_kindergarten_half_day 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1434608 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   ungraded_elementary 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1434609 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   ungraded_secondary 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1434610 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   grade_1 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434611 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   grade_10 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434612 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   grade_11 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434613 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   grade_12 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434614 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   grade_2 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434615 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   grade_3 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434616 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   grade_4 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434617 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   grade_5 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434618 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   grade_6 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434619 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   grade_7 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434620 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   grade_8 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434621 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   grade_9 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434622 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   kindergarten_full_day 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434623 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   kindergarten_half_day 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434624 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   pk_12_total 10.0                       5.0 5.0                   *   10 10                       5 5                 10
1434625 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434626 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day 10.0                       5.0 5.0                   *   10 10                       5 5                 10
1434627 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   ungraded_elementary 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1434628 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2021   ungraded_secondary 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1443293 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_1 35.0 0.0           0.0     0.0   19.0 16.0             23     *   35 35 0           0     0   19 16         23       35
1443294 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_10 0.0 0.0           0.0     0.0   0.0 0.0             0     0   0 0 0           0     0   0 0         0   0   0
1443295 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_11 0.0 0.0           0.0     0.0   0.0 0.0             0     0   0 0 0           0     0   0 0         0   0   0
1443296 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_12 0.0 0.0           0.0     0.0   0.0 0.0             0     0   0 0 0           0     0   0 0         0   0   0
1443297 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_2 45.0 0.0           0.0     2.0   30.0 17.0             29     5   47 45 0           0     2   30 17         29   5   47
1443298 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_3 48.0 0.0           0.0     1.0   27.0 22.0             37     10   49 48 0           0     1   27 22         37   10   49
1443299 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_4 40.0 0.0           0.0     0.0   20.0 20.0             25     5   40 40 0           0     0   20 20         25   5   40
1443300 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_5 39.0 1.0           0.0     2.0   23.0 19.0             28     10   42 39 1           0     2   23 19         28   10   42
1443301 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_6 39.0 0.0           0.0     0.0   28.0 11.0             25     7   39 39 0           0     0   28 11         25   7   39
1443302 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_7 0.0 0.0           0.0     0.0   0.0 0.0             0     0   0 0 0           0     0   0 0         0   0   0
1443303 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_8 0.0 0.0           0.0     0.0   0.0 0.0             0     0   0 0 0           0     0   0 0         0   0   0
1443304 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_9 0.0 0.0           0.0     0.0   0.0 0.0             0     0   0 0 0           0     0   0 0         0   0   0
1443305 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   kindergarten_full_day 37.0 1.0           1.0     1.0   22.0 18.0             27     5   40 37 1           1     1   22 18         27   5   40
1443306 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   kindergarten_half_day 0.0 0.0           0.0     0.0   0.0 0.0             0     0   0 0 0           0     0   0 0         0   0   0
1443307 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   pk_12_total 311.0 2.0           1.0     6.0   185.0 135.0             204     48   320 311 2           1     6   185 135         204   48   320
1443308 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   pre_kindergarten_full_day 0.0 0.0           0.0     0.0   0.0 0.0             0     0   0 0 0           0     0   0 0         0   0   0
1443309 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   pre_kindergarten_half_day 28.0 0.0           0.0     0.0   16.0 12.0             10     *   28 28 0           0     0   16 12         10       28
1443310 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   ungraded_elementary 0.0 0.0           0.0     0.0   0.0 0.0             0     0   0 0 0           0     0   0 0         0   0   0
1443311 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   ungraded_secondary 0.0 0.0           0.0     0.0   0.0 0.0             0     0   0 0 0           0     0   0 0         0   0   0
1444547 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_1         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444548 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_10         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444549 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_11         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444550 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_12         2.0           1.0   2.0 1.0             *     *   3         2           1   2 1                 3
1444551 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_2         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444552 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_3         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444553 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_4         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444554 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_5         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444555 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_6         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444556 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_7         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444557 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_8         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444558 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_9         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444559 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   kindergarten_full_day         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444560 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   kindergarten_half_day         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444561 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   pk_12_total         2.0           1.0   2.0 1.0             *     *   3         2           1   2 1                 3
1444562 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   pre_kindergarten_full_day         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444563 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   pre_kindergarten_half_day         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444564 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   ungraded_elementary         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444565 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   ungraded_secondary         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1446865 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_1 26.0 0.0                 1.0   13.0 14.0             20     *   27 26 0                 1   13 14         20       27
1446866 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_10 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1446867 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_11 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1446868 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_12 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1446869 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_2 21.0 0.0                 3.0   12.0 12.0             14     *   24 21 0                 3   12 12         14       24
1446870 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_3 18.0 0.0                 1.0   10.0 9.0             11     *   19 18 0                 1   10 9         11       19
1446871 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_4 22.0 0.0                 0.0   15.0 7.0             16     *   22 22 0                 0   15 7         16       22
1446872 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_5 36.0 2.0                 0.0   19.0 19.0             18     8   38 36 2                 0   19 19         18   8   38
1446873 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_6 38.0 0.0                 0.0   19.0 19.0             19     9   38 38 0                 0   19 19         19   9   38
1446874 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_7 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1446875 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_8 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1446876 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_9 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1446877 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   kindergarten_full_day 35.0 3.0                 1.0   18.0 21.0             17     6   39 35 3                 1   18 21         17   6   39
1446878 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   kindergarten_half_day 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1446879 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   pk_12_total 210.0 5.0                 6.0   116.0 105.0             120     38   221 210 5                 6   116 105         120   38   221
1446880 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   pre_kindergarten_full_day 10.0 0.0                 0.0   6.0 4.0             *     *   10 10 0                 0   6 4                 10
1446881 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   pre_kindergarten_half_day 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1446882 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   ungraded_elementary 4.0 0.0                 0.0   4.0 0.0             *     *   4 4 0                 0   4 0                 4
1446883 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   ungraded_secondary 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1446884 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_1 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1446885 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_10 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1446886 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_11 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1446887 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_12 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1446888 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_2 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]);