Data source: Big Local News · About: Big Local

629,755 rows where state = "NY" sorted by black_int descending

View and edit SQL

grade

year

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
754780 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   grade_3     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
754781 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   grade_4     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
754782 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   grade_5     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
754783 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   grade_6     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
754784 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   grade_7     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
754785 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   grade_8     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
754786 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   grade_9     159.0                   88.0 71.0             159     *   159     159                   88 71         159       159
754787 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   kindergarten_full_day     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
754788 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   kindergarten_half_day     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
754789 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   pk_12_total     417.0                   228.0 189.0             416     11   417     417                   228 189         416   11   417
754790 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   pre_kindergarten_full_day     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
754791 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   pre_kindergarten_half_day     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
754792 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   ungraded_elementary     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
754793 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   ungraded_secondary     1.0                   0.0 1.0             *     *   1     1                   0 1                 1
756200 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_1 48.0   0.0   3.0     1.0     1.0   24.0 29.0             36     *   53 48   0   3     1     1   24 29         36       53
756201 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_10 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756202 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_11 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756203 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_12 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756204 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_2 51.0   2.0   0.0     2.0     0.0   25.0 30.0             35     8   55 51   2   0     2     0   25 30         35   8   55
756205 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_3 37.0   2.0   1.0     1.0     0.0   18.0 23.0             24     *   41 37   2   1     1     0   18 23         24       41
756206 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_4 35.0   2.0   0.0     1.0     0.0   18.0 20.0             27     *   38 35   2   0     1     0   18 20         27       38
756207 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_5 49.0   1.0   0.0     0.0     0.0   18.0 32.0             31     6   50 49   1   0     0     0   18 32         31   6   50
756208 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_6 46.0   1.0   2.0     1.0     0.0   24.0 26.0             34     *   50 46   1   2     1     0   24 26         34       50
756209 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_7 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756210 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_8 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756211 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_9 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756212 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   kindergarten_full_day 38.0   1.0   1.0     1.0     0.0   16.0 25.0             38     8   41 38   1   1     1     0   16 25         38   8   41
756213 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   kindergarten_half_day 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756214 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   pk_12_total 345.0   9.0   8.0     7.0     1.0   166.0 204.0             241     37   370 345   9   8     7     1   166 204         241   37   370
756215 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   pre_kindergarten_full_day 41.0   0.0   1.0     0.0     0.0   23.0 19.0             16     *   42 41   0   1     0     0   23 19         16       42
756216 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   pre_kindergarten_half_day 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756217 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   ungraded_elementary 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756218 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   ungraded_secondary 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756428 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_1 57.0   1.0   0.0     0.0     3.0   30.0 31.0             33     *   61 57   1   0     0     3   30 31         33       61
756429 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_10 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756430 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_11 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756431 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_12 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756432 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_2 74.0   1.0   0.0     1.0     3.0   42.0 37.0             49     6   79 74   1   0     1     3   42 37         49   6   79
756433 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_3 76.0   1.0   0.0     0.0     6.0   41.0 42.0             41     10   83 76   1   0     0     6   41 42         41   10   83
756434 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_4 66.0   0.0   0.0     0.0     1.0   33.0 34.0             27     *   67 66   0   0     0     1   33 34         27       67
756435 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_5 68.0   0.0   0.0     1.0     1.0   35.0 35.0             34     7   70 68   0   0     1     1   35 35         34   7   70
756436 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_6 87.0   0.0   0.0     0.0     3.0   41.0 49.0             32     11   90 87   0   0     0     3   41 49         32   11   90
756437 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_7 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756438 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_8 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756439 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_9 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756440 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   kindergarten_full_day 58.0   2.0   0.0     0.0     1.0   23.0 38.0             33     7   61 58   2   0     0     1   23 38         33   7   61
756441 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   kindergarten_half_day 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756442 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   pk_12_total 537.0   6.0   1.0     2.0     19.0   267.0 298.0             277     55   565 537   6   1     2     19   267 298         277   55   565
756443 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   pre_kindergarten_full_day 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756444 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   pre_kindergarten_half_day 49.0   0.0   1.0     0.0     1.0   21.0 30.0             *     5   51 49   0   1     0     1   21 30             5   51
756445 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   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
756446 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   ungraded_secondary 0.0   1.0   0.0     0.0     0.0   0.0 1.0             0     *   1 0   1   0     0     0   0 1         0       1
756466 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_1 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756467 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_10 72.0   2.0   1.0     0.0     1.0   44.0 32.0             38     9   76 72   2   1     0     1   44 32         38   9   76
756468 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_11 66.0   0.0   2.0     0.0     0.0   34.0 34.0             27     12   68 66   0   2     0     0   34 34         27   12   68
756469 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_12 66.0   1.0   2.0     0.0     0.0   43.0 26.0             28     8   69 66   1   2     0     0   43 26         28   8   69
756470 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_2 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756471 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_3 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756472 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_4 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756473 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_5 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756474 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_6 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756475 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_7 63.0   1.0   3.0     2.0     4.0   33.0 40.0             39     13   73 63   1   3     2     4   33 40         39   13   73
756476 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_8 58.0   1.0   3.0     2.0     0.0   35.0 29.0             *     14   64 58   1   3     2     0   35 29             14   64
756477 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_9 58.0   3.0   2.0     1.0     1.0   43.0 22.0             38     11   65 58   3   2     1     1   43 22         38   11   65
756478 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   kindergarten_full_day 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756479 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   kindergarten_half_day 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756480 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   pk_12_total 388.0   8.0   13.0     5.0     6.0   237.0 183.0             190     72   420 388   8   13     5     6   237 183         190   72   420
756481 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   pre_kindergarten_full_day 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756482 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   pre_kindergarten_half_day 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756483 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   ungraded_elementary 1.0   0.0   0.0     0.0     0.0   1.0 0.0             *     *   1 1   0   0     0     0   1 0                 1
756484 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   ungraded_secondary 4.0   0.0   0.0     0.0     0.0   4.0 0.0             *     *   4 4   0   0     0     0   4 0                 4
756485 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_1 64.0   1.0   4.0     0.0     4.0   34.0 39.0             44     13   73 64   1   4     0     4   34 39         44   13   73
756486 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_10 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756487 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_11 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756488 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_12 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756489 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_2 59.0   1.0   5.0     0.0     2.0   33.0 34.0             38     13   67 59   1   5     0     2   33 34         38   13   67
756490 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_3 62.0   0.0   1.0     0.0     2.0   27.0 38.0             39     9   65 62   0   1     0     2   27 38         39   9   65
756491 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_4 60.0   2.0   4.0     0.0     4.0   36.0 34.0             40     5   70 60   2   4     0     4   36 34         40   5   70
756492 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_5 45.0   3.0   2.0     0.0     3.0   21.0 32.0             27     8   53 45   3   2     0     3   21 32         27   8   53
756493 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_6 54.0   2.0   1.0     1.0     0.0   31.0 27.0             31     7   58 54   2   1     1     0   31 27         31   7   58
756494 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_7 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756495 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_8 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756496 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_9 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756497 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   kindergarten_full_day 69.0   4.0   1.0     0.0     6.0   40.0 40.0             45     17   80 69   4   1     0     6   40 40         45   17   80
756498 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   kindergarten_half_day 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
756499 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   pk_12_total 460.0   14.0   18.0     1.0     22.0   250.0 265.0             292     93   515 460   14   18     1     22   250 265         292   93   515
756500 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   pre_kindergarten_full_day 24.0   0.0   0.0     0.0     1.0   15.0 10.0             14     13   25 24   0   0     0     1   15 10         14   13   25
756501 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   pre_kindergarten_half_day 20.0   1.0   0.0     0.0     0.0   11.0 10.0             *     *   21 20   1   0     0     0   11 10                 21
756502 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   ungraded_elementary 3.0   0.0   0.0     0.0     0.0   2.0 1.0             *     *   3 3   0   0     0     0   2 1                 3
756503 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   ungraded_secondary 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
757245 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_1 42.0   1.0   0.0           2.0   25.0 20.0             35     *   45 42   1   0           2   25 20         35       45
757246 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   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
757247 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   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
757248 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   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
757249 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_2 43.0   2.0   0.0           0.0   18.0 27.0             29     5   45 43   2   0           0   18 27         29   5   45
757250 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_3 41.0   1.0   1.0           1.0   27.0 17.0             28     11   44 41   1   1           1   27 17         28   11   44
757251 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_4 40.0   3.0   0.0           2.0   22.0 23.0             25     7   45 40   3   0           2   22 23         25   7   45
757252 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_5 38.0   0.0   0.0           0.0   17.0 21.0             24     *   38 38   0   0           0   17 21         24       38
757253 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_6 41.0   2.0   0.0           0.0   14.0 29.0             28     6   43 41   2   0           0   14 29         28   6   43
757254 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   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

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