Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2016 · 90,193
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black ▼ hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1033102 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_1 40.0   1.0         2.0     1.0   20.0 24.0             23     5   44 40   1         2     1   20 24         23   5   44
1033103 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_10 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033104 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_11 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033105 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_12 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033106 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_2 39.0   0.0         2.0     3.0   23.0 21.0             16     *   44 39   0         2     3   23 21         16       44
1033107 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_3 43.0   0.0         3.0     2.0   28.0 20.0             26     7   48 43   0         3     2   28 20         26   7   48
1033108 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_4 40.0   2.0         1.0     2.0   19.0 26.0             21     8   45 40   2         1     2   19 26         21   8   45
1033109 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_5 48.0   1.0         2.0     2.0   29.0 24.0             22     7   53 48   1         2     2   29 24         22   7   53
1033110 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_6 52.0   1.0         0.0     0.0   28.0 25.0             26     8   53 52   1         0     0   28 25         26   8   53
1033111 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_7 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033112 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_8 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033113 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_9 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033114 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   kindergarten_full_day 40.0   1.0         1.0     1.0   25.0 18.0             20     *   43 40   1         1     1   25 18         20       43
1033115 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   kindergarten_half_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033116 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   pk_12_total 320.0   6.0         12.0     11.0   179.0 170.0             162     45   349 320   6         12     11   179 170         162   45   349
1033117 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   pre_kindergarten_full_day 17.0   0.0         1.0     0.0   7.0 11.0             *     *   18 17   0         1     0   7 11                 18
1033118 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   pre_kindergarten_half_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033119 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   ungraded_elementary 1.0   0.0         0.0     0.0   0.0 1.0             *     *   1 1   0         0     0   0 1                 1
1033120 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   ungraded_secondary 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033121 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   grade_1 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033122 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   grade_10 49.0   0.0         3.0     0.0   22.0 30.0             21     *   52 49   0         3     0   22 30         21       52
1033123 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   grade_11 42.0   0.0         2.0     0.0   29.0 15.0             16     11   44 42   0         2     0   29 15         16   11   44
1033124 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   grade_12 48.0   1.0         1.0     1.0   25.0 26.0             18     6   51 48   1         1     1   25 26         18   6   51
1033125 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   grade_2 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033126 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   grade_3 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033127 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   grade_4 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033128 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   grade_5 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033129 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   grade_6 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033130 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   grade_7 45.0   0.0         3.0     0.0   27.0 21.0             23     8   48 45   0         3     0   27 21         23   8   48
1033131 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   grade_8 49.0   0.0         2.0     1.0   24.0 28.0             19     *   52 49   0         2     1   24 28         19       52
1033132 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   grade_9 45.0   0.0         2.0     0.0   23.0 24.0             *     7   47 45   0         2     0   23 24             7   47
1033133 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   kindergarten_full_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033134 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   kindergarten_half_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033135 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   pk_12_total 282.0   1.0         13.0     2.0   153.0 145.0             115     44   298 282   1         13     2   153 145         115   44   298
1033136 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   pre_kindergarten_full_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033137 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   pre_kindergarten_half_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033138 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   ungraded_elementary 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033139 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   ungraded_secondary 4.0   0.0         0.0     0.0   3.0 1.0             *     *   4 4   0         0     0   3 1                 4
1033178 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   grade_1 28.0   0.0               0.0   17.0 11.0             18     *   28 28   0               0   17 11         18       28
1033179 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   grade_10 22.0   1.0               0.0   14.0 9.0             16     *   23 22   1               0   14 9         16       23
1033180 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   grade_11 25.0   0.0               0.0   15.0 10.0             11     *   25 25   0               0   15 10         11       25
1033181 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   grade_12 17.0   1.0               0.0   11.0 7.0             6     5   18 17   1               0   11 7         6   5   18
1033182 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   grade_2 26.0   0.0               1.0   13.0 14.0             16     *   27 26   0               1   13 14         16       27
1033183 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   grade_3 32.0   0.0               0.0   15.0 17.0             21     *   32 32   0               0   15 17         21       32
1033184 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   grade_4 24.0   0.0               1.0   17.0 8.0             15     *   25 24   0               1   17 8         15       25
1033185 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   grade_5 27.0   1.0               0.0   19.0 9.0             21     *   28 27   1               0   19 9         21       28
1033186 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   grade_6 27.0   0.0               0.0   17.0 10.0             21     8   27 27   0               0   17 10         21   8   27
1033187 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   grade_7 34.0   1.0               0.0   20.0 15.0             23     6   35 34   1               0   20 15         23   6   35
1033188 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   grade_8 20.0   1.0               0.0   10.0 11.0             12     7   21 20   1               0   10 11         12   7   21
1033189 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   grade_9 18.0   0.0               1.0   13.0 6.0             9     *   19 18   0               1   13 6         9       19
1033190 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   kindergarten_full_day 28.0   0.0               1.0   13.0 16.0             19     *   29 28   0               1   13 16         19       29
1033191 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   kindergarten_half_day 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1033192 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   pk_12_total 349.0   5.0               4.0   206.0 152.0             223     57   358 349   5               4   206 152         223   57   358
1033193 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   pre_kindergarten_full_day 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1033194 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   pre_kindergarten_half_day 21.0   0.0               0.0   12.0 9.0             15     *   21 21   0               0   12 9         15       21
1033195 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   ungraded_elementary 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1033196 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   ungraded_secondary 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1033197 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_1 22.0   0.0         0.0         12.0 10.0             14     *   22 22   0         0         12 10         14       22
1033198 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_10 20.0   0.0         0.0         7.0 13.0             11     *   20 20   0         0         7 13         11       20
1033199 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_11 12.0   0.0         0.0         1.0 11.0             *     0   12 12   0         0         1 11             0   12
1033200 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_12 16.0   0.0         0.0         11.0 5.0             9     *   16 16   0         0         11 5         9       16
1033201 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_2 17.0   2.0         0.0         11.0 8.0             11     *   19 17   2         0         11 8         11       19
1033202 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_3 15.0   0.0         0.0         7.0 8.0             9     0   15 15   0         0         7 8         9   0   15
1033203 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_4 24.0   1.0         0.0         3.0 22.0             16     *   25 24   1         0         3 22         16       25
1033204 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_5 15.0   0.0         0.0         11.0 4.0             9     *   15 15   0         0         11 4         9       15
1033205 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_6 22.0   0.0         0.0         9.0 13.0             13     5   22 22   0         0         9 13         13   5   22
1033206 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_7 26.0   1.0         0.0         11.0 16.0             12     *   27 26   1         0         11 16         12       27
1033207 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_8 17.0   0.0         0.0         6.0 11.0             12     0   17 17   0         0         6 11         12   0   17
1033208 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_9 14.0   0.0         1.0         9.0 6.0             7     *   15 14   0         1         9 6         7       15
1033209 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   kindergarten_full_day 19.0   0.0         0.0         9.0 10.0             12     *   19 19   0         0         9 10         12       19
1033210 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   kindergarten_half_day 0.0   0.0         0.0         0.0 0.0             0     0   0 0   0         0         0 0         0   0   0
1033211 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   pk_12_total 255.0   4.0         1.0         117.0 143.0             154     32   260 255   4         1         117 143         154   32   260
1033212 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   pre_kindergarten_full_day 13.0   0.0         0.0         9.0 4.0             10     *   13 13   0         0         9 4         10       13
1033213 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   pre_kindergarten_half_day 0.0   0.0         0.0         0.0 0.0             0     0   0 0   0         0         0 0         0   0   0
1033214 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   ungraded_elementary 3.0   0.0         0.0         1.0 2.0             *     *   3 3   0         0         1 2                 3
1033215 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   ungraded_secondary 0.0   0.0         0.0         0.0 0.0             0     0   0 0   0         0         0 0         0   0   0
1033216 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_1 26.0   3.0               0.0   15.0 14.0             24     *   29 26   3               0   15 14         24       29
1033217 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_10 21.0   0.0               0.0   9.0 12.0             14     *   21 21   0               0   9 12         14       21
1033218 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_11 22.0   0.0               0.0   6.0 16.0             14     *   22 22   0               0   6 16         14       22
1033219 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_12 23.0   0.0               0.0   11.0 12.0             13     *   23 23   0               0   11 12         13       23
1033220 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_2 19.0   1.0               2.0   7.0 15.0             *     *   22 19   1               2   7 15                 22
1033221 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_3 21.0   1.0               3.0   16.0 9.0             22     6   25 21   1               3   16 9         22   6   25
1033222 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_4 25.0   1.0               0.0   12.0 14.0             16     *   26 25   1               0   12 14         16       26
1033223 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_5 28.0   1.0               1.0   15.0 15.0             23     8   30 28   1               1   15 15         23   8   30
1033224 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_6 24.0   1.0               1.0   13.0 13.0             17     5   26 24   1               1   13 13         17   5   26
1033225 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_7 17.0   0.0               3.0   9.0 11.0             15     *   20 17   0               3   9 11         15       20
1033226 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_8 25.0   1.0               2.0   15.0 13.0             14     7   28 25   1               2   15 13         14   7   28
1033227 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_9 33.0   2.0               1.0   20.0 16.0             22     12   36 33   2               1   20 16         22   12   36
1033228 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   kindergarten_full_day 24.0   0.0               2.0   12.0 14.0             22     6   26 24   0               2   12 14         22   6   26
1033229 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   kindergarten_half_day 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1033230 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   pk_12_total 326.0   11.0               17.0   169.0 185.0             244     69   354 326   11               17   169 185         244   69   354
1033231 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   pre_kindergarten_full_day 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1033232 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   pre_kindergarten_half_day 17.0   0.0               2.0   8.0 11.0             15     6   19 17   0               2   8 11         15   6   19
1033233 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   ungraded_elementary 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1033234 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   ungraded_secondary 1.0   0.0               0.0   1.0 0.0             *     *   1 1   0               0   1 0                 1
1033254 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_1 17.0   0.0                   6.0 11.0             12     *   17 17   0                   6 11         12       17
1033255 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_10 16.0   0.0                   9.0 7.0             8     *   16 16   0                   9 7         8       16
1033256 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_11 25.0   0.0                   8.0 17.0             10     *   25 25   0                   8 17         10       25
1033257 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_12 25.0   0.0                   11.0 14.0             10     *   25 25   0                   11 14         10       25
1033258 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_2 11.0   1.0                   6.0 6.0             *     *   12 11   1                   6 6                 12

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