enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
746567 746567 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_1 45.0   0.0         2.0     2.0   25.0 24.0             21     *   49 45   0         2     2   25 24         21       49
746568 746568 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND 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
746569 746569 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND 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
746570 746570 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND 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
746571 746571 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_2 45.0   1.0         3.0     1.0   29.0 21.0             26     7   50 45   1         3     1   29 21         26   7   50
746572 746572 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_3 39.0   3.0         1.0     2.0   19.0 26.0             20     9   45 39   3         1     2   19 26         20   9   45
746573 746573 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_4 47.0   1.0         2.0     2.0   27.0 25.0             22     7   52 47   1         2     2   27 25         22   7   52
746574 746574 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_5 50.0   1.0         2.0     0.0   28.0 25.0             24     8   53 50   1         2     0   28 25         24   8   53
746575 746575 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_6 39.0   0.0         3.0     1.0   22.0 21.0             18     8   43 39   0         3     1   22 21         18   8   43
746576 746576 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND 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
746577 746577 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND 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
746578 746578 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND 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
746579 746579 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   kindergarten_full_day 40.0   1.0         2.0     1.0   19.0 25.0             22     *   44 40   1         2     1   19 25         22       44
746580 746580 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND 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
746581 746581 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   pk_12_total 324.0   7.0         16.0     9.0   180.0 176.0             160     51   356 324   7         16     9   180 176         160   51   356
746582 746582 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   pre_kindergarten_full_day 17.0   0.0         1.0     0.0   10.0 8.0             *     *   18 17   0         1     0   10 8                 18
746583 746583 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND 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
746584 746584 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   ungraded_elementary 1.0   0.0         0.0     0.0   1.0 0.0             0     *   1 1   0         0     0   1 0         0       1
746585 746585 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   ungraded_secondary 1.0   0.0         0.0     0.0   0.0 1.0             *     *   1 1   0         0     0   0 1                 1
746643 746643 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_1 30.0   0.0               1.0   16.0 15.0             15     5   31 30   0               1   16 15         15   5   31
746644 746644 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_10 26.0   0.0               0.0   15.0 11.0             13     *   26 26   0               0   15 11         13       26
746645 746645 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_11 16.0   0.0               1.0   12.0 5.0             *     *   17 16   0               1   12 5                 17
746646 746646 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_12 18.0   4.0               0.0   12.0 10.0             11     *   22 18   4               0   12 10         11       22
746647 746647 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_2 26.0   0.0               0.0   9.0 17.0             11     *   26 26   0               0   9 17         11       26
746648 746648 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_3 26.0   0.0               1.0   18.0 9.0             13     *   27 26   0               1   18 9         13       27
746649 746649 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_4 28.0   1.0               0.0   18.0 11.0             20     5   29 28   1               0   18 11         20   5   29
746650 746650 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_5 29.0   0.0               0.0   18.0 11.0             20     8   29 29   0               0   18 11         20   8   29
746651 746651 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_6 33.0   1.0               0.0   19.0 15.0             18     5   34 33   1               0   19 15         18   5   34
746652 746652 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_7 22.0   1.0               0.0   11.0 12.0             10     9   23 22   1               0   11 12         10   9   23
746653 746653 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_8 19.0   0.0               0.0   12.0 7.0             9     *   19 19   0               0   12 7         9       19
746654 746654 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_9 27.0   1.0               0.0   16.0 12.0             16     *   28 27   1               0   16 12         16       28
746655 746655 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   kindergarten_full_day 29.0   0.0               0.0   20.0 9.0             10     *   29 29   0               0   20 9         10       29
746656 746656 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 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
746657 746657 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   pk_12_total 357.0   8.0               4.0   212.0 157.0             188     63   369 357   8               4   212 157         188   63   369
746658 746658 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 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
746659 746659 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   pre_kindergarten_half_day 26.0   0.0               1.0   14.0 13.0             16     5   27 26   0               1   14 13         16   5   27
746660 746660 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   ungraded_elementary 1.0   0.0               0.0   1.0 0.0             0     *   1 1   0               0   1 0         0       1
746661 746661 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   ungraded_secondary 1.0   0.0               0.0   1.0 0.0             *     *   1 1   0               0   1 0                 1
746662 746662 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   grade_1 14.0   0.0         0.0         8.0 6.0             6     *   14 14   0         0         8 6         6       14
746663 746663 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   grade_10 11.0   0.0         0.0         2.0 9.0             5     *   11 11   0         0         2 9         5       11
746664 746664 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   grade_11 18.0   0.0         0.0         11.0 7.0             10     *   18 18   0         0         11 7         10       18
746665 746665 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   grade_12 21.0   0.0         0.0         11.0 10.0             12     *   21 21   0         0         11 10         12       21
746666 746666 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   grade_2 15.0   0.0         0.0         8.0 7.0             9     *   15 15   0         0         8 7         9       15
746667 746667 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   grade_3 19.0   0.0         0.0         3.0 16.0             13     *   19 19   0         0         3 16         13       19
746668 746668 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   grade_4 12.0   0.0         0.0         9.0 3.0             7     0   12 12   0         0         9 3         7   0   12
746669 746669 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   grade_5 18.0   0.0         0.0         7.0 11.0             9     *   18 18   0         0         7 11         9       18
746670 746670 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   grade_6 17.0   1.0         0.0         5.0 13.0             7     *   18 17   1         0         5 13         7       18
746671 746671 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   grade_7 16.0   0.0         0.0         7.0 9.0             12     *   16 16   0         0         7 9         12       16
746672 746672 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   grade_8 12.0   0.0         1.0         8.0 5.0             7     *   13 12   0         1         8 5         7       13
746673 746673 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   grade_9 22.0   0.0         0.0         10.0 12.0             12     *   22 22   0         0         10 12         12       22
746674 746674 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   kindergarten_full_day 23.0   0.0         0.0         13.0 10.0             16     *   23 23   0         0         13 10         16       23
746675 746675 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 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
746676 746676 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   pk_12_total 235.0   1.0         1.0         111.0 126.0             133     21   237 235   1         1         111 126         133   21   237
746677 746677 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   pre_kindergarten_full_day 17.0   0.0         0.0         9.0 8.0             8     *   17 17   0         0         9 8         8       17
746678 746678 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 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
746679 746679 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   ungraded_elementary 0.0   0.0         0.0         0.0 0.0             0     0   0 0   0         0         0 0         0   0   0
746680 746680 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   ungraded_secondary 0.0   0.0         0.0         0.0 0.0             0     0   0 0   0         0         0 0         0   0   0
746681 746681 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_1 20.0   0.0               2.0   7.0 15.0             12     *   22 20   0               2   7 15         12       22
746682 746682 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_10 22.0   0.0               0.0   7.0 15.0             16     *   22 22   0               0   7 15         16       22
746683 746683 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_11 22.0   0.0               0.0   11.0 11.0             12     *   22 22   0               0   11 11         12       22
746684 746684 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_12 24.0   0.0               0.0   11.0 13.0             18     5   24 24   0               0   11 13         18   5   24
746685 746685 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_2 24.0   1.0               3.0   16.0 12.0             25     5   28 24   1               3   16 12         25   5   28
746686 746686 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_3 27.0   0.0               0.0   13.0 14.0             17     *   27 27   0               0   13 14         17       27
746687 746687 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_4 27.0   1.0               1.0   14.0 15.0             23     7   29 27   1               1   14 15         23   7   29
746688 746688 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_5 27.0   1.0               1.0   14.0 15.0             22     6   29 27   1               1   14 15         22   6   29
746689 746689 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_6 19.0   0.0               4.0   12.0 11.0             15     *   23 19   0               4   12 11         15       23
746690 746690 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_7 25.0   1.0               2.0   16.0 12.0             15     7   28 25   1               2   16 12         15   7   28
746691 746691 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_8 30.0   0.0               1.0   15.0 16.0             18     5   31 30   0               1   15 16         18   5   31
746692 746692 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_9 25.0   0.0               1.0   12.0 14.0             19     5   26 25   0               1   12 14         19   5   26
746693 746693 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   kindergarten_full_day 28.0   2.0               0.0   14.0 16.0             25     *   30 28   2               0   14 16         25       30
746694 746694 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 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
746695 746695 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   pk_12_total 341.0   7.0               17.0   173.0 192.0             254     57   365 341   7               17   173 192         254   57   365
746696 746696 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 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
746697 746697 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   pre_kindergarten_half_day 21.0   1.0               2.0   11.0 13.0             17     *   24 21   1               2   11 13         17       24
746698 746698 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   ungraded_elementary 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
746699 746699 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   ungraded_secondary 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
746719 746719 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_1 14.0   1.0                   9.0 6.0             8     *   15 14   1                   9 6         8       15
746720 746720 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_10 26.0   0.0                   8.0 18.0             10     *   26 26   0                   8 18         10       26
746721 746721 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_11 24.0   0.0                   11.0 13.0             10     *   24 24   0                   11 13         10       24
746722 746722 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_12 17.0   0.0                   11.0 6.0             10     *   17 17   0                   11 6         10       17
746723 746723 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_2 14.0   1.0                   6.0 9.0             12     *   15 14   1                   6 9         12       15
746724 746724 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_3 12.0   0.0                   8.0 4.0             9     0   12 12   0                   8 4         9   0   12
746725 746725 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_4 16.0   0.0                   8.0 8.0             10     *   16 16   0                   8 8         10       16
746726 746726 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_5 18.0   0.0                   10.0 8.0             11     *   18 18   0                   10 8         11       18
746727 746727 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_6 24.0   0.0                   13.0 11.0             13     *   24 24   0                   13 11         13       24
746728 746728 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_7 19.0   0.0                   6.0 13.0             11     *   19 19   0                   6 13         11       19
746729 746729 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_8 19.0   0.0                   5.0 14.0             8     *   19 19   0                   5 14         8       19
746730 746730 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_9 14.0   0.0                   8.0 6.0             *     *   14 14   0                   8 6                 14
746731 746731 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   kindergarten_full_day 17.0   0.0                   9.0 8.0             11     0   17 17   0                   9 8         11   0   17
746732 746732 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   kindergarten_half_day 0.0   0.0                   0.0 0.0             0     0   0 0   0                   0 0         0   0   0
746733 746733 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   pk_12_total 250.0   4.0                   120.0 134.0             141     30   254 250   4                   120 134         141   30   254
746734 746734 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   pre_kindergarten_full_day 0.0   0.0                   0.0 0.0             0     0   0 0   0                   0 0         0   0   0
746735 746735 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   pre_kindergarten_half_day 13.0   2.0                   7.0 8.0             9     0   15 13   2                   7 8         9   0   15
746736 746736 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   ungraded_elementary 0.0   0.0                   0.0 0.0             0     0   0 0   0                   0 0         0   0   0
746737 746737 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   ungraded_secondary 3.0   0.0                   1.0 2.0             *     *   3 3   0                   1 2                 3
754775 754775 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_1     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
754776 754776 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_10     90.0                   55.0 35.0             90     *   90     90                   55 35         90       90
754777 754777 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_11     133.0                   68.0 65.0             132     *   133     133                   68 65         132       133
754778 754778 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_12     34.0                   17.0 17.0             *     0   34     34                   17 17             0   34
754779 754779 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_2     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]);