enrollments

Data source: Big Local News · About: Big Local

90,079 rows where state = "NY" and year = 2021 sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

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
1486884 1486884 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   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
1486885 1486885 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   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
1486886 1486886 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_5 73.0 0.0 3.0         0.0     3.0   40.0 39.0             38     11   79 73 0 3         0     3   40 39         38   11   79
1486887 1486887 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_6 87.0 0.0 2.0         0.0     4.0   48.0 45.0             51     11   93 87 0 2         0     4   48 45         51   11   93
1486888 1486888 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_7 59.0 2.0 4.0         1.0     1.0   30.0 37.0             29     6   67 59 2 4         1     1   30 37         29   6   67
1486889 1486889 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_8 67.0 0.0 5.0         0.0     3.0   39.0 36.0             36     6   75 67 0 5         0     3   39 36         36   6   75
1486890 1486890 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   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
1486891 1486891 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   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
1486892 1486892 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   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
1486893 1486893 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   pk_12_total 286.0 2.0 14.0         1.0     11.0   157.0 157.0             154     34   314 286 2 14         1     11   157 157         154   34   314
1486894 1486894 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   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
1486895 1486895 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   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
1486896 1486896 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   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
1486897 1486897 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2021   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
1504948 1504948 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   grade_1 36.0   0.0               2.0   21.0 17.0             28     6   38 36   0               2   21 17         28   6   38
1504949 1504949 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   grade_10 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1504950 1504950 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   grade_11 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1504951 1504951 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   grade_12 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1504952 1504952 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   grade_2 34.0   1.0               2.0   18.0 19.0             19     7   37 34   1               2   18 19         19   7   37
1504953 1504953 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   grade_3 33.0   0.0               0.0   20.0 13.0             22     7   33 33   0               0   20 13         22   7   33
1504954 1504954 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   grade_4 33.0   0.0               1.0   19.0 15.0             18     6   34 33   0               1   19 15         18   6   34
1504955 1504955 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   grade_5 38.0   0.0               1.0   25.0 14.0             25     10   39 38   0               1   25 14         25   10   39
1504956 1504956 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   grade_6 37.0   0.0               0.0   21.0 16.0             20     10   37 37   0               0   21 16         20   10   37
1504957 1504957 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   grade_7 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1504958 1504958 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   grade_8 1.0   0.0               0.0   1.0 0.0             0     *   1 1   0               0   1 0         0       1
1504959 1504959 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   grade_9 1.0   0.0               0.0   1.0 0.0             0     *   1 1   0               0   1 0         0       1
1504960 1504960 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   kindergarten_full_day 34.0   1.0               0.0   18.0 17.0             18     5   35 34   1               0   18 17         18   5   35
1504961 1504961 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   kindergarten_half_day 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1504962 1504962 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   pk_12_total 272.0   3.0               6.0   161.0 120.0             156     58   281 272   3               6   161 120         156   58   281
1504963 1504963 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   pre_kindergarten_full_day 23.0   1.0               0.0   16.0 8.0             *     *   24 23   1               0   16 8                 24
1504964 1504964 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   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
1504965 1504965 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   ungraded_elementary 2.0   0.0               0.0   1.0 1.0             *     *   2 2   0               0   1 1                 2
1504966 1504966 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Other PK 12 2021   ungraded_secondary 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1504967 1504967 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   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
1504968 1504968 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   grade_10 39.0   1.0   0.0           1.0   17.0 24.0             28     15   41 39   1   0           1   17 24         28   15   41
1504969 1504969 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   grade_11 34.0   0.0   0.0           0.0   24.0 10.0             *     7   34 34   0   0           0   24 10             7   34
1504970 1504970 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   grade_12 21.0   0.0   1.0           1.0   13.0 10.0             13     *   23 21   0   1           1   13 10         13       23
1504971 1504971 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   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
1504972 1504972 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   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
1504973 1504973 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   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
1504974 1504974 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   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
1504975 1504975 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   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
1504976 1504976 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   grade_7 29.0   0.0   0.0           1.0   15.0 15.0             20     6   30 29   0   0           1   15 15         20   6   30
1504977 1504977 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   grade_8 36.0   0.0   0.0           0.0   18.0 18.0             16     6   36 36   0   0           0   18 18         16   6   36
1504978 1504978 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   grade_9 38.0   1.0   1.0           0.0   18.0 22.0             15     8   40 38   1   1           0   18 22         15   8   40
1504979 1504979 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   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
1504980 1504980 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   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
1504981 1504981 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   pk_12_total 200.0   2.0   2.0           3.0   106.0 101.0             108     49   207 200   2   2           3   106 101         108   49   207
1504982 1504982 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   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
1504983 1504983 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   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
1504984 1504984 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   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
1504985 1504985 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No Other PK 12 2021   ungraded_secondary 3.0   0.0   0.0           0.0   1.0 2.0             *     *   3 3   0   0           0   1 2                 3
1506335 1506335 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   grade_1 138.0 8.0 21.0   0.0     5.0     26.0   95.0 103.0     6       105     25   198 138 8 21   0     5     26   95 103     6   105   25   198
1506336 1506336 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506337 1506337 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506338 1506338 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506339 1506339 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   grade_2 138.0 7.0 19.0   0.0     8.0     12.0   96.0 88.0     *       77     33   184 138 7 19   0     8     12   96 88         77   33   184
1506340 1506340 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506341 1506341 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506342 1506342 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506343 1506343 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506344 1506344 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506345 1506345 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506346 1506346 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506347 1506347 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   kindergarten_full_day 144.0 7.0 17.0   1.0     8.0     18.0   97.0 98.0     *       76     32   195 144 7 17   1     8     18   97 98         76   32   195
1506348 1506348 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506349 1506349 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   pk_12_total 420.0 22.0 57.0   1.0     21.0     56.0   288.0 289.0     12       258     90   577 420 22 57   1     21     56   288 289     12   258   90   577
1506350 1506350 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506351 1506351 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506352 1506352 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506353 1506353 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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 0     0   0   0   0
1506354 1506354 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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 0     0   0   0   0
1506355 1506355 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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 0     0   0   0   0
1506356 1506356 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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 0     0   0   0   0
1506357 1506357 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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 0     0   0   0   0
1506358 1506358 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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 0     0   0   0   0
1506359 1506359 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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 0     0   0   0   0
1506360 1506360 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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 0     0   0   0   0
1506361 1506361 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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 0     0   0   0   0
1506362 1506362 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 144.0 10.0 20.0   1.0     8.0     7.0   83.0 107.0     *       74     22   190 144 10 20   1     8     7   83 107         74   22   190
1506363 1506363 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 181.0 9.0 17.0   1.0     5.0     12.0   108.0 117.0     *       111     35   225 181 9 17   1     5     12   108 117         111   35   225
1506364 1506364 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_8 184.0 16.0 26.0   0.0     6.0     16.0   131.0 117.0     *       114     28   248 184 16 26   0     6     16   131 117         114   28   248
1506365 1506365 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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 0     0   0   0   0
1506366 1506366 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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 0     0   0   0   0
1506367 1506367 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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 0     0   0   0   0
1506368 1506368 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   pk_12_total 512.0 36.0 65.0   2.0     21.0     35.0   326.0 345.0     9       304     93   671 512 36 65   2     21     35   326 345     9   304   93   671
1506369 1506369 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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 0     0   0   0   0
1506370 1506370 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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 0     0   0   0   0
1506371 1506371 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   ungraded_elementary 0.0 0.0 2.0   0.0     1.0     0.0   2.0 1.0     *       *     *   3 0 0 2   0     1     0   2 1                 3
1506372 1506372 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   ungraded_secondary 3.0 1.0 0.0   0.0     1.0     0.0   2.0 3.0     0       *     *   5 3 1 0   0     1     0   2 3     0           5
1506373 1506373 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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 0     0   0   0   0
1506374 1506374 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_10 155.0 10.0 21.0   0.0     9.0     10.0   111.0 94.0     *       93     23   205 155 10 21   0     9     10   111 94         93   23   205
1506375 1506375 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_11 154.0 4.0 11.0   2.0     4.0     9.0   98.0 86.0     *       66     23   184 154 4 11   2     4     9   98 86         66   23   184
1506376 1506376 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_12 167.0 17.0 15.0   0.0     8.0     9.0   103.0 113.0     *       80     17   216 167 17 15   0     8     9   103 113         80   17   216
1506377 1506377 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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 0     0   0   0   0
1506378 1506378 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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 0     0   0   0   0
1506379 1506379 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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 0     0   0   0   0
1506380 1506380 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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 0     0   0   0   0
1506381 1506381 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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 0     0   0   0   0
1506382 1506382 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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 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]);