enrollments

Data source: Big Local News · About: Big Local

89,718 rows where state = "NY" and year = 2018 sorted by disability_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 89,618 ✖
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
2050344 2050344 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2018   grade_1 42.0 0.0 5.0   0.0     20.0     1.0   37.0 31.0     5       6     *   68 42 0 5   0     20     1   37 31     5   6       68
2050348 2050348 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2018   grade_2 42.0 1.0 2.0   0.0     19.0     6.0   31.0 39.0     *       9     *   70 42 1 2   0     19     6   31 39         9       70
2050369 2050369 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2018   grade_4 45.0 5.0 5.0   0.0     13.0     6.0   34.0 40.0     7       20     *   74 45 5 5   0     13     6   34 40     7   20       74
2050371 2050371 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2018   grade_6 38.0 3.0 4.0   0.0     16.0     5.0   37.0 29.0     *       22     *   66 38 3 4   0     16     5   37 29         22       66
2050401 2050401 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2018   grade_1 33.0 0.0 6.0   0.0     4.0     2.0   17.0 28.0     *       5     *   45 33 0 6   0     4     2   17 28         5       45
2050405 2050405 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2018   grade_2 32.0 0.0 2.0   0.0     3.0     3.0   11.0 29.0     *       *     *   40 32 0 2   0     3     3   11 29                 40
2050407 2050407 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2018   grade_4 37.0 0.0 2.0   0.0     5.0     1.0   25.0 20.0     *       *     *   45 37 0 2   0     5     1   25 20                 45
2050408 2050408 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2018   grade_5 34.0 2.0 5.0   1.0     6.0     3.0   24.0 27.0     *       *     *   51 34 2 5   1     6     3   24 27                 51
2050409 2050409 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2018   grade_6 29.0 0.0 0.0   0.0     2.0     4.0   18.0 17.0     0       *     *   35 29 0 0   0     2     4   18 17     0           35
2050425 2050425 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2018   grade_3 27.0 2.0 4.0   1.0     4.0     5.0   25.0 18.0     *       11     *   43 27 2 4   1     4     5   25 18         11       43
2050426 2050426 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2018   grade_4 24.0 5.0 2.0   1.0     13.0     3.0   23.0 25.0     0       6     *   48 24 5 2   1     13     3   23 25     0   6       48
2050477 2050477 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2018   grade_1 21.0 1.0 1.0         0.0     3.0   14.0 12.0             14     *   26 21 1 1         0     3   14 12         14       26
2050479 2050479 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2018   grade_11 15.0 0.0 0.0         0.0     2.0   5.0 12.0             8     *   17 15 0 0         0     2   5 12         8       17
2050480 2050480 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2018   grade_12 9.0 0.0 1.0         0.0     2.0   2.0 10.0             7     *   12 9 0 1         0     2   2 10         7       12
2050481 2050481 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2018   grade_2 19.0 1.0 0.0         1.0     0.0   8.0 13.0             16     *   21 19 1 0         1     0   8 13         16       21
2050482 2050482 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2018   grade_3 14.0 0.0 0.0         0.0     1.0   3.0 12.0             8     *   15 14 0 0         0     1   3 12         8       15
2050487 2050487 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2018   grade_8 19.0 2.0 0.0         0.0     0.0   11.0 10.0             10     *   21 19 2 0         0     0   11 10         10       21
2050489 2050489 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2018   kindergarten_full_day 14.0 1.0 2.0         2.0     3.0   11.0 11.0             15     *   22 14 1 2         2     3   11 11         15       22
2050500 2050500 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 41.0 0.0 1.0         2.0     3.0   16.0 31.0     0       18     *   47 41 0 1         2     3   16 31     0   18       47
2050508 2050508 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   kindergarten_full_day 42.0 2.0 3.0         1.0     1.0   27.0 22.0     *       17     *   49 42 2 3         1     1   27 22         17       49
2050534 2050534 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001073 10802060004 WESTMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_1 46.0 6.0 2.0   1.0     22.0     2.0   48.0 31.0     15       16     *   79 46 6 2   1     22     2   48 31     15   16       79
2050546 2050546 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001073 10802060004 WESTMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   kindergarten_full_day 72.0 5.0 3.0   0.0     2.0     3.0   44.0 41.0     9       21     *   85 72 5 3   0     2     3   44 41     9   21       85
2050572 2050572 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_1 49.0 2.0 1.0         7.0     2.0   39.0 22.0     *       *     *   61 49 2 1         7     2   39 22                 61
2050584 2050584 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   kindergarten_full_day 61.0 1.0 1.0         3.0     1.0   37.0 30.0     *       *     *   67 61 1 1         3     1   37 30                 67
2050608 2050608 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2018   ungraded_elementary 9.0 0.0 1.0   0.0     1.0     0.0   5.0 6.0     0       *     *   11 9 0 1   0     1     0   5 6     0           11
2050609 2050609 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2018   ungraded_secondary 2.0 0.0 0.0   0.0     1.0     0.0   2.0 1.0     0       *     *   3 2 0 0   0     1     0   2 1     0           3
2050610 2050610 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_1 57.0 2.0 1.0         14.0     1.0   46.0 29.0     *       7     *   75 57 2 1         14     1   46 29         7       75
2050622 2050622 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   kindergarten_full_day 68.0 1.0 2.0         5.0     2.0   40.0 38.0     *       10     *   78 68 1 2         5     2   40 38         10       78
2050627 2050627 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   ungraded_elementary 0.0 0.0 0.0         1.0     0.0   0.0 1.0     0       *     *   1 0 0 0         1     0   0 1     0           1
2050629 2050629 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_1 89.0 1.0 3.0         3.0     12.0   51.0 57.0     *       7     *   108 89 1 3         3     12   51 57         7       108
2050635 2050635 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_4 57.0 0.0 4.0         3.0     2.0   19.0 47.0     0       7     *   66 57 0 4         3     2   19 47     0   7       66
2050698 2050698 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   kindergarten_full_day 53.0 14.0 13.0         6.0     15.0   47.0 54.0     6       69     *   101 53 14 13         6     15   47 54     6   69       101
2050703 2050703 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   ungraded_elementary 0.0 0.0 0.0         1.0     0.0   1.0 0.0     *       0     *   1 0 0 0         1     0   1 0         0       1
2050714 2050714 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_7 37.0 20.0 14.0   0.0     7.0     10.0   56.0 32.0     7       69     *   88 37 20 14   0     7     10   56 32     7   69       88
2050723 2050723 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   ungraded_secondary 2.0 0.0 0.0   0.0     0.0     1.0   3.0 0.0     0       *     *   3 2 0 0   0     0     1   3 0     0           3
2050736 2050736 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   kindergarten_full_day 34.0 1.0 2.0         2.0     2.0   19.0 22.0             11     *   41 34 1 2         2     2   19 22         11       41
2050739 2050739 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pre_kindergarten_full_day 18.0 0.0 0.0         0.0     0.0   8.0 10.0             *     *   18 18 0 0         0     0   8 10                 18
2050741 2050741 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   ungraded_elementary 1.0 0.0 0.0         0.0     0.0   0.0 1.0             *     *   1 1 0 0         0     0   0 1                 1
2050742 2050742 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   ungraded_secondary 1.0 0.0 0.0         0.0     0.0   0.0 1.0             *     *   1 1 0 0         0     0   0 1                 1
2050744 2050744 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2018   grade_10 45.0 0.0 0.0         3.0     1.0   22.0 27.0             *     *   49 45 0 0         3     1   22 27                 49
2050746 2050746 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2018   grade_12 42.0 0.0 0.0         4.0     0.0   18.0 28.0             15     *   46 42 0 0         4     0   18 28         15       46
2050762 2050762 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2018   grade_1 17.0 0.0 0.0         0.0     0.0   10.0 7.0             *     *   17 17 0 0         0     0   10 7                 17
2050763 2050763 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2018   grade_10 26.0 0.0 1.0         0.0     0.0   11.0 16.0             13     *   27 26 0 1         0     0   11 16         13       27
2050764 2050764 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2018   grade_11 21.0 0.0 1.0         0.0     0.0   8.0 14.0             10     *   22 21 0 1         0     0   8 14         10       22
2050765 2050765 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2018   grade_12 22.0 1.0 1.0         0.0     0.0   11.0 13.0             14     *   24 22 1 1         0     0   11 13         14       24
2050766 2050766 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2018   grade_2 21.0 0.0 0.0         0.0     0.0   6.0 15.0             12     *   21 21 0 0         0     0   6 15         12       21
2050767 2050767 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2018   grade_3 30.0 0.0 0.0         0.0     0.0   11.0 19.0             19     *   30 30 0 0         0     0   11 19         19       30
2050769 2050769 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2018   grade_5 15.0 1.0 0.0         0.0     0.0   8.0 8.0             7     *   16 15 1 0         0     0   8 8         7       16
2050771 2050771 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2018   grade_7 27.0 0.0 0.0         0.0     0.0   14.0 13.0             13     *   27 27 0 0         0     0   14 13         13       27
2050772 2050772 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2018   grade_8 21.0 0.0 0.0         0.0     0.0   13.0 8.0             11     *   21 21 0 0         0     0   13 8         11       21
2050773 2050773 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2018   grade_9 21.0 0.0 0.0         0.0     0.0   9.0 12.0             9     *   21 21 0 0         0     0   9 12         9       21
2050774 2050774 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2018   kindergarten_full_day 23.0 0.0 0.0         0.0     0.0   12.0 11.0             14     *   23 23 0 0         0     0   12 11         14       23
2050778 2050778 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2018   pre_kindergarten_half_day 15.0 0.0 0.0         0.0     1.0   5.0 11.0             9     *   16 15 0 0         0     1   5 11         9       16
2050779 2050779 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2018   ungraded_elementary 2.0 0.0 0.0         0.0     0.0   1.0 1.0             *     *   2 2 0 0         0     0   1 1                 2
2050783 2050783 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_11 33.0 1.0 0.0   1.0     2.0     0.0   23.0 14.0             10     *   37 33 1 0   1     2     0   23 14         10       37
2050784 2050784 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_12 40.0 0.0 0.0   0.0     0.0     0.0   22.0 18.0             16     *   40 40 0 0   0     0     0   22 18         16       40
2050785 2050785 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_2 33.0 1.0 0.0   0.0     0.0     0.0   17.0 17.0             22     *   34 33 1 0   0     0     0   17 17         22       34
2050786 2050786 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_3 27.0 0.0 1.0   0.0     0.0     0.0   14.0 14.0             21     *   28 27 0 1   0     0     0   14 14         21       28
2050789 2050789 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_6 29.0 1.0 0.0   0.0     0.0     0.0   14.0 16.0             15     *   30 29 1 0   0     0     0   14 16         15       30
2050793 2050793 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2018   kindergarten_full_day 35.0 0.0 0.0   0.0     0.0     0.0   16.0 19.0             26     *   35 35 0 0   0     0     0   16 19         26       35
2050796 2050796 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2018   pre_kindergarten_full_day 29.0 0.0 1.0   1.0     1.0     1.0   16.0 17.0             16     *   33 29 0 1   1     1     1   16 17         16       33
2050797 2050797 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2018   pre_kindergarten_half_day 4.0 0.0 0.0   0.0     0.0     0.0   3.0 1.0             *     *   4 4 0 0   0     0     0   3 1                 4
2050798 2050798 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2018   ungraded_elementary 0.0 0.0 0.0   1.0     0.0     0.0   1.0 0.0             *     *   1 0 0 0   1     0     0   1 0                 1
2050802 2050802 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2018   grade_11 19.0   0.0               0.0   14.0 5.0             8     *   19 19   0               0   14 5         8       19
2050803 2050803 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2018   grade_12 21.0   1.0               0.0   13.0 9.0             14     *   22 21   1               0   13 9         14       22
2050804 2050804 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2018   grade_2 23.0   0.0               3.0   10.0 16.0             17     *   26 23   0               3   10 16         17       26
2050805 2050805 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2018   grade_3 29.0   0.0               0.0   16.0 13.0             18     *   29 29   0               0   16 13         18       29
2050806 2050806 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2018   grade_4 27.0   0.0               2.0   12.0 17.0             20     *   29 27   0               2   12 17         20       29
2050807 2050807 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2018   grade_5 34.0   0.0               0.0   16.0 18.0             20     *   34 34   0               0   16 18         20       34
2050808 2050808 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2018   grade_6 18.0   0.0               1.0   10.0 9.0             11     *   19 18   0               1   10 9         11       19
2050812 2050812 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2018   kindergarten_full_day 22.0   0.0               0.0   11.0 11.0             14     *   22 22   0               0   11 11         14       22
2050818 2050818 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2018   ungraded_secondary 1.0   0.0               0.0   0.0 1.0             *     *   1 1   0               0   0 1                 1
2050819 2050819 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2018   grade_1 15.0   0.0         0.0     0.0   11.0 4.0             12     *   15 15   0         0     0   11 4         12       15
2050820 2050820 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2018   grade_10 17.0   1.0         0.0     0.0   8.0 10.0             12     *   18 17   1         0     0   8 10         12       18
2050822 2050822 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2018   grade_12 20.0   0.0         0.0     0.0   7.0 13.0             9     *   20 20   0         0     0   7 13         9       20
2050824 2050824 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2018   grade_3 16.0   0.0         0.0     0.0   11.0 5.0             10     *   16 16   0         0     0   11 5         10       16
2050825 2050825 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2018   grade_4 15.0   1.0         0.0     0.0   9.0 7.0             7     *   16 15   1         0     0   9 7         7       16
2050826 2050826 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2018   grade_5 15.0   0.0         0.0     0.0   6.0 9.0             8     *   15 15   0         0     0   6 9         8       15
2050827 2050827 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2018   grade_6 22.0   1.0         0.0     0.0   4.0 19.0             13     *   23 22   1         0     0   4 19         13       23
2050829 2050829 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2018   grade_8 17.0   1.0         0.0     0.0   7.0 11.0             13     *   18 17   1         0     0   7 11         13       18
2050830 2050830 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2018   grade_9 22.0   1.0         0.0     0.0   8.0 15.0             12     *   23 22   1         0     0   8 15         12       23
2050834 2050834 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2018   pre_kindergarten_full_day 19.0   0.0         0.0     0.0   9.0 10.0             6     *   19 19   0         0     0   9 10         6       19
2050836 2050836 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2018   ungraded_elementary 4.0   0.0         0.0     0.0   2.0 2.0             *     *   4 4   0         0     0   2 2                 4
2050841 2050841 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_12 24.0 0.0 0.0               0.0   12.0 12.0             17     *   24 24 0 0               0   12 12         17       24
2050842 2050842 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_2 23.0 0.0 0.0               0.0   11.0 12.0             22     *   23 23 0 0               0   11 12         22       23
2050843 2050843 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_3 22.0 0.0 2.0               0.0   10.0 14.0             20     *   24 22 0 2               0   10 14         20       24
2050844 2050844 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_4 23.0 0.0 1.0               1.0   9.0 16.0             17     *   25 23 0 1               1   9 16         17       25
2050845 2050845 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_5 16.0 0.0 0.0               3.0   13.0 6.0             17     *   19 16 0 0               3   13 6         17       19
2050846 2050846 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_6 25.0 0.0 1.0               0.0   12.0 14.0             17     *   26 25 0 1               0   12 14         17       26
2050848 2050848 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_8 15.0 1.0 0.0               0.0   6.0 10.0             11     *   16 15 1 0               0   6 10         11       16
2050858 2050858 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_10 48.0 0.0 0.0   0.0     0.0         25.0 23.0     *       23     *   48 48 0 0   0     0         25 23         23       48
2050860 2050860 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_12 44.0 0.0 0.0   0.0     1.0         23.0 22.0     *       18     *   45 44 0 0   0     1         23 22         18       45
2050862 2050862 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_3 46.0 1.0 2.0   0.0     0.0         26.0 23.0     *       31     *   49 46 1 2   0     0         26 23         31       49
2050866 2050866 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_7 41.0 0.0 2.0   1.0     0.0         16.0 28.0     *       24     *   44 41 0 2   1     0         16 28         24       44
2050874 2050874 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2018   ungraded_elementary 7.0 0.0 0.0   0.0     0.0         4.0 3.0     *       *     *   7 7 0 0   0     0         4 3                 7
2050875 2050875 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2018   ungraded_secondary 3.0 0.0 0.0   0.0     0.0         3.0 0.0     *       *     *   3 3 0 0   0     0         3 0                 3
2050876 2050876 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_1 15.0 0.0 0.0                   6.0 9.0             6     *   15 15 0 0                   6 9         6       15
2050878 2050878 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_11 15.0 0.0 0.0                   3.0 12.0             7     *   15 15 0 0                   3 12         7       15
2050881 2050881 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_3 11.0 0.0 0.0                   5.0 6.0             5     *   11 11 0 0                   5 6         5       11
2050883 2050883 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_5 13.0 0.0 1.0                   6.0 8.0             10     *   14 13 0 1                   6 8         10       14

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