Data source: Big Local News · About: Big Local

90,098 rows where state = "NY" and year = 2020 sorted by black

View and edit SQL

year

  • 2020 · 90,098
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
1524385 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   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
1524386 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   grade_10 48.0   2.0         1.0     0.0   25.0 26.0             23     *   51 48   2         1     0   25 26         23       51
1524387 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   grade_11 39.0   1.0         4.0     1.0   25.0 20.0             16     6   45 39   1         4     1   25 20         16   6   45
1524388 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   grade_12 42.0   1.0         3.0     0.0   23.0 23.0             17     *   46 42   1         3     0   23 23         17       46
1524389 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   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
1524390 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   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
1524391 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   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
1524392 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   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
1524393 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   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
1524394 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   grade_7 45.0   0.0         2.0     1.0   30.0 18.0             26     8   48 45   0         2     1   30 18         26   8   48
1524395 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   grade_8 35.0   3.0         1.0     2.0   20.0 21.0             *     6   41 35   3         1     2   20 21             6   41
1524396 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   grade_9 45.0   3.0         2.0     3.0   31.0 22.0             16     8   53 45   3         2     3   31 22         16   8   53
1524397 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   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
1524398 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   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
1524399 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   pk_12_total 256.0   10.0         14.0     7.0   154.0 133.0             114     36   287 256   10         14     7   154 133         114   36   287
1524400 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   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
1524401 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   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
1524402 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   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
1524403 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   ungraded_secondary 2.0   0.0         1.0     0.0   0.0 3.0             *     *   3 2   0         1     0   0 3                 3
1524461 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_1 13.0   1.0                   6.0 8.0             *     *   14 13   1                   6 8                 14
1524462 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_10 15.0   3.0                   9.0 9.0             12     *   18 15   3                   9 9         12       18
1524463 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_11 17.0   0.0                   7.0 10.0             8     *   17 17   0                   7 10         8       17
1524464 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_12 14.0   1.0                   5.0 10.0             7     *   15 14   1                   5 10         7       15
1524465 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_2 14.0   1.0                   8.0 7.0             7     *   15 14   1                   8 7         7       15
1524466 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_3 11.0   0.0                   7.0 4.0             6     *   11 11   0                   7 4         6       11
1524467 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_4 15.0   1.0                   7.0 9.0             9     *   16 15   1                   7 9         9       16
1524468 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_5 14.0   0.0                   10.0 4.0             6     *   14 14   0                   10 4         6       14
1524469 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_6 12.0   1.0                   6.0 7.0             *     *   13 12   1                   6 7                 13
1524470 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_7 12.0   1.0                   4.0 9.0             6     *   13 12   1                   4 9         6       13
1524471 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_8 23.0   1.0                   5.0 19.0             9     *   24 23   1                   5 19         9       24
1524472 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_9 10.0   0.0                   8.0 2.0             *     *   10 10   0                   8 2                 10
1524473 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   kindergarten_full_day 14.0   1.0                   10.0 5.0             6     *   15 14   1                   10 5         6       15
1524474 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   kindergarten_half_day 0.0   0.0                   0.0 0.0             0     0   0 0   0                   0 0         0   0   0
1524475 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   pk_12_total 202.0   13.0                   101.0 114.0             93     32   215 202   13                   101 114         93   32   215
1524476 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   pre_kindergarten_full_day 14.0   2.0                   7.0 9.0             *     7   16 14   2                   7 9             7   16
1524477 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   pre_kindergarten_half_day 0.0   0.0                   0.0 0.0             0     0   0 0   0                   0 0         0   0   0
1524478 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   ungraded_elementary 0.0   0.0                   0.0 0.0             0     0   0 0   0                   0 0         0   0   0
1524479 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   ungraded_secondary 4.0   0.0                   2.0 2.0             *     *   4 4   0                   2 2                 4
1524670 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_1 62.0       1.0           2.0   41.0 24.0             44     10   65 62       1           2   41 24         44   10   65
1524671 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_10 0.0       0.0           0.0   0.0 0.0             0     0   0 0       0           0   0 0         0   0   0
1524672 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_11 0.0       0.0           0.0   0.0 0.0             0     0   0 0       0           0   0 0         0   0   0
1524673 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_12 0.0       0.0           0.0   0.0 0.0             0     0   0 0       0           0   0 0         0   0   0
1524674 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 52.0       0.0           2.0   30.0 24.0             35     7   54 52       0           2   30 24         35   7   54
1524675 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_3 50.0       0.0           0.0   31.0 19.0             29     *   50 50       0           0   31 19         29       50
1524676 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_4 43.0       0.0           1.0   23.0 21.0             27     11   44 43       0           1   23 21         27   11   44
1524677 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_5 49.0       0.0           0.0   19.0 30.0             36     9   49 49       0           0   19 30         36   9   49
1524678 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_6 0.0       0.0           0.0   0.0 0.0             0     0   0 0       0           0   0 0         0   0   0
1524679 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_7 0.0       0.0           0.0   0.0 0.0             0     0   0 0       0           0   0 0         0   0   0
1524680 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0       0.0           0.0   0.0 0.0             0     0   0 0       0           0   0 0         0   0   0
1524681 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_9 0.0       0.0           0.0   0.0 0.0             0     0   0 0       0           0   0 0         0   0   0
1524682 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   kindergarten_full_day 48.0       0.0           1.0   33.0 16.0             28     11   49 48       0           1   33 16         28   11   49
1524683 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   kindergarten_half_day 0.0       0.0           0.0   0.0 0.0             0     0   0 0       0           0   0 0         0   0   0
1524684 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   pk_12_total 337.0       1.0           6.0   191.0 153.0             215     55   344 337       1           6   191 153         215   55   344
1524685 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   pre_kindergarten_full_day 33.0       0.0           0.0   14.0 19.0             16     *   33 33       0           0   14 19         16       33
1524686 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1524687 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0       0.0           0.0   0.0 0.0             0     0   0 0       0           0   0 0         0   0   0
1524688 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   ungraded_secondary 0.0       0.0           0.0   0.0 0.0             0     0   0 0       0           0   0 0         0   0   0
1524689 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_1 0.0                       0.0 0.0                       0 0                       0 0                 0
1524690 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_10 0.0                       0.0 0.0                       0 0                       0 0                 0
1524691 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_11 0.0                       0.0 0.0                       0 0                       0 0                 0
1524692 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_12 0.0                       0.0 0.0                       0 0                       0 0                 0
1524693 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_2 0.0                       0.0 0.0                       0 0                       0 0                 0
1524694 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_3 0.0                       0.0 0.0                       0 0                       0 0                 0
1524695 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_4 0.0                       0.0 0.0                       0 0                       0 0                 0
1524696 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_5 0.0                       0.0 0.0                       0 0                       0 0                 0
1524697 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_6 0.0                       0.0 0.0                       0 0                       0 0                 0
1524698 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_7 0.0                       0.0 0.0                       0 0                       0 0                 0
1524699 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_8 0.0                       0.0 0.0                       0 0                       0 0                 0
1524700 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_9 0.0                       0.0 0.0                       0 0                       0 0                 0
1524701 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   kindergarten_full_day 0.0                       0.0 0.0                       0 0                       0 0                 0
1524702 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   kindergarten_half_day 0.0                       0.0 0.0                       0 0                       0 0                 0
1524703 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   pk_12_total 11.0                       6.0 5.0                       11 11                       6 5                 11
1524704 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day 0.0                       0.0 0.0                       0 0                       0 0                 0
1524705 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day 11.0                       6.0 5.0                       11 11                       6 5                 11
1524706 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   ungraded_elementary 0.0                       0.0 0.0                       0 0                       0 0                 0
1524707 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   ungraded_secondary 0.0                       0.0 0.0                       0 0                       0 0                 0
1528356 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   grade_1     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1528357 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   grade_10     92.0                   54.0 38.0     84       92     *   92     92                   54 38     84   92       92
1528358 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   grade_11     77.0                   39.0 38.0     34       76     7   77     77                   39 38     34   76   7   77
1528359 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   grade_12     61.0                   37.0 24.0     15       61     *   61     61                   37 24     15   61       61
1528360 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   grade_2     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1528361 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   grade_3     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1528362 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   grade_4     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1528363 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   grade_5     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1528364 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   grade_6     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1528365 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   grade_7     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1528366 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   grade_8     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1528367 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   grade_9     94.0                   50.0 44.0     82       92     *   94     94                   50 44     82   92       94
1528368 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   kindergarten_full_day     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1528369 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   kindergarten_half_day     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1528370 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   pk_12_total     324.0                   180.0 144.0     215       321     17   324     324                   180 144     215   321   17   324
1528371 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   pre_kindergarten_full_day     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1528372 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   pre_kindergarten_half_day     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1528373 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   ungraded_elementary     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1528374 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   ungraded_secondary     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1530009 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705938 321000011342 INTERNATIONAL SCHOOL FOR LIBERAL ART public Regular School No High 06 12 2020   grade_1     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1530010 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705938 321000011342 INTERNATIONAL SCHOOL FOR LIBERAL ART public Regular School No High 06 12 2020   grade_10     90.0                   44.0 46.0     66       87     *   90     90                   44 46     66   87       90
1530011 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705938 321000011342 INTERNATIONAL SCHOOL FOR LIBERAL ART public Regular School No High 06 12 2020   grade_11     98.0                   46.0 52.0     73       95     13   98     98                   46 52     73   95   13   98
1530012 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705938 321000011342 INTERNATIONAL SCHOOL FOR LIBERAL ART public Regular School No High 06 12 2020   grade_12     93.0                   37.0 56.0     46       91     6   93     93                   37 56     46   91   6   93
1530013 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705938 321000011342 INTERNATIONAL SCHOOL FOR LIBERAL ART public Regular School No High 06 12 2020   grade_2     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]);