enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 89,998 ✖
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
1577039 1577039 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 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         0   0   0
1577040 1577040 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 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         0   0   0
1577041 1577041 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_5 92.0 0.0 2.0         0.0     3.0   48.0 49.0     *       56     14   97 92 0 2         0     3   48 49         56   14   97
1577042 1577042 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_6 59.0 1.0 4.0         1.0     1.0   31.0 35.0     *       31     7   66 59 1 4         1     1   31 35         31   7   66
1577043 1577043 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 69.0 1.0 5.0         0.0     4.0   42.0 37.0     *       39     7   79 69 1 5         0     4   42 37         39   7   79
1577044 1577044 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_8 63.0 0.0 4.0         1.0     4.0   37.0 35.0     *       23     9   72 63 0 4         1     4   37 35         23   9   72
1577045 1577045 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2020   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
1577046 1577046 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 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         0   0   0
1577047 1577047 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 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         0   0   0
1577048 1577048 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2020   pk_12_total 283.0 2.0 15.0         2.0     12.0   158.0 156.0     *       149     37   314 283 2 15         2     12   158 156         149   37   314
1577049 1577049 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 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         0   0   0
1577050 1577050 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 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         0   0   0
1577051 1577051 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 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         0   0   0
1577052 1577052 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2020   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
1595084 1595084 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   grade_1 35.0   0.0               2.0   17.0 20.0             20     6   37 35   0               2   17 20         20   6   37
1595085 1595085 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   grade_10 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1595086 1595086 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   grade_11 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1595087 1595087 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   grade_12 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1595088 1595088 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   grade_2 34.0   0.0               0.0   20.0 14.0             22     7   34 34   0               0   20 14         22   7   34
1595089 1595089 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   grade_3 34.0   0.0               0.0   19.0 15.0             20     6   34 34   0               0   19 15         20   6   34
1595090 1595090 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   grade_4 41.0   0.0               1.0   26.0 16.0             27     11   42 41   0               1   26 16         27   11   42
1595091 1595091 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   grade_5 37.0   0.0               0.0   22.0 15.0             21     10   37 37   0               0   22 15         21   10   37
1595092 1595092 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   grade_6 32.0   0.0               1.0   16.0 17.0             23     8   33 32   0               1   16 17         23   8   33
1595093 1595093 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   grade_7 1.0   0.0               0.0   1.0 0.0             *     *   1 1   0               0   1 0                 1
1595094 1595094 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   grade_8 1.0   0.0               0.0   1.0 0.0             *     *   1 1   0               0   1 0                 1
1595095 1595095 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   grade_9 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1595096 1595096 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   kindergarten_full_day 37.0   0.0               1.0   21.0 17.0             25     *   38 37   0               1   21 17         25       38
1595097 1595097 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 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
1595098 1595098 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   pk_12_total 289.0   1.0               5.0   164.0 131.0             179     62   295 289   1               5   164 131         179   62   295
1595099 1595099 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   pre_kindergarten_full_day 34.0   1.0               0.0   20.0 15.0             16     5   35 34   1               0   20 15         16   5   35
1595100 1595100 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 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
1595101 1595101 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   ungraded_elementary 2.0   0.0               0.0   1.0 1.0             *     *   2 2   0               0   1 1                 2
1595102 1595102 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2020   ungraded_secondary 1.0   0.0               0.0   0.0 1.0             *     *   1 1   0               0   0 1                 1
1595103 1595103 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS 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
1595104 1595104 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No High 07 12 2020   grade_10 31.0   0.0   0.0           0.0   20.0 11.0             *     6   31 31   0   0           0   20 11             6   31
1595105 1595105 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No High 07 12 2020   grade_11 22.0   0.0   1.0           1.0   14.0 10.0             14     *   24 22   0   1           1   14 10         14       24
1595106 1595106 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No High 07 12 2020   grade_12 36.0   1.0   2.0           1.0   21.0 19.0             22     10   40 36   1   2           1   21 19         22   10   40
1595107 1595107 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS 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
1595108 1595108 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS 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
1595109 1595109 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS 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
1595110 1595110 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS 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
1595111 1595111 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS 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
1595112 1595112 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No High 07 12 2020   grade_7 40.0   0.0   0.0           0.0   19.0 21.0             22     6   40 40   0   0           0   19 21         22   6   40
1595113 1595113 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No High 07 12 2020   grade_8 41.0   1.0   1.0           0.0   21.0 22.0             18     10   43 41   1   1           0   21 22         18   10   43
1595114 1595114 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No High 07 12 2020   grade_9 44.0   0.0   0.0           0.0   17.0 27.0             33     15   44 44   0   0           0   17 27         33   15   44
1595115 1595115 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS 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
1595116 1595116 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS 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
1595117 1595117 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No High 07 12 2020   pk_12_total 217.0   2.0   4.0           2.0   113.0 112.0             123     54   225 217   2   4           2   113 112         123   54   225
1595118 1595118 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS 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
1595119 1595119 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS 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
1595120 1595120 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS 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
1595121 1595121 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No High 07 12 2020   ungraded_secondary 3.0   0.0   0.0           0.0   1.0 2.0             *     *   3 3   0   0           0   1 2                 3
1596490 1596490 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 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     0   0 0         0   0   0
1596491 1596491 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1596492 1596492 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1596493 1596493 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1596494 1596494 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 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     0   0 0         0   0   0
1596495 1596495 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 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     0   0 0         0   0   0
1596496 1596496 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 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     0   0 0         0   0   0
1596497 1596497 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 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     0   0 0         0   0   0
1596498 1596498 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 180.0 10.0 17.0   1.0     6.0     11.0   109.0 116.0     *       118     33   225 180 10 17   1     6     11   109 116         118   33   225
1596499 1596499 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 190.0 13.0 26.0   0.0     7.0     19.0   133.0 122.0     *       131     30   255 190 13 26   0     7     19   133 122         131   30   255
1596500 1596500 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 161.0 11.0 21.0   1.0     6.0     13.0   100.0 113.0     *       *     17   213 161 11 21   1     6     13   100 113             17   213
1596501 1596501 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1596502 1596502 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 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     0   0 0         0   0   0
1596503 1596503 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 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     0   0 0         0   0   0
1596504 1596504 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 535.0 35.0 64.0   2.0     20.0     43.0   345.0 354.0     *       347     86   699 535 35 64   2     20     43   345 354         347   86   699
1596505 1596505 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 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     0   0 0         0   0   0
1596506 1596506 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 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     0   0 0         0   0   0
1596507 1596507 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 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     0   0 0         0   0   0
1596508 1596508 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   ungraded_secondary 4.0 1.0 0.0   0.0     1.0     0.0   3.0 3.0     *       *     6   6 4 1 0   0     1     0   3 3             6   6
1596509 1596509 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL 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       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1596510 1596510 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_10 160.0 7.0 12.0   2.0     4.0     15.0   103.0 97.0     *       86     28   200 160 7 12   2     4     15   103 97         86   28   200
1596511 1596511 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_11 165.0 17.0 13.0   0.0     8.0     8.0   100.0 111.0     *       87     15   211 165 17 13   0     8     8   100 111         87   15   211
1596512 1596512 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_12 170.0 8.0 14.0   2.0     9.0     8.0   99.0 112.0     *       74     17   211 170 8 14   2     9     8   99 112         74   17   211
1596513 1596513 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL 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       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1596514 1596514 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL 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       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1596515 1596515 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL 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       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1596516 1596516 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL 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       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1596517 1596517 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL 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       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1596518 1596518 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL 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       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1596519 1596519 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL 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       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1596520 1596520 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 165.0 10.0 19.0   0.0     10.0     9.0   115.0 98.0     *       103     29   213 165 10 19   0     10     9   115 98         103   29   213
1596521 1596521 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL 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       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1596522 1596522 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL 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       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1596523 1596523 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 668.0 42.0 58.0   4.0     31.0     40.0   422.0 421.0     7       357     97   843 668 42 58   4     31     40   422 421     7   357   97   843
1596524 1596524 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL 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       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1596525 1596525 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL 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       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1596526 1596526 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL 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       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1596527 1596527 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   ungraded_secondary 8.0 0.0 0.0   0.0     0.0     0.0   5.0 3.0     0       7     8   8 8 0 0   0     0     0   5 3     0   7   8   8
1596471 1596471 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2020   grade_1 152.0 6.0 19.0   0.0     8.0     13.0   106.0 92.0     *       86     31   198 152 6 19   0     8     13   106 92         86   31   198
1596472 1596472 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2020   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
1596473 1596473 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2020   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
1596474 1596474 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2020   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
1596475 1596475 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2020   grade_2 150.0 5.0 16.0   1.0     14.0     22.0   119.0 89.0     8       97     31   208 150 5 16   1     14     22   119 89     8   97   31   208
1596476 1596476 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 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     0     0   0 0     0   0   0   0
1596477 1596477 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 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     0     0   0 0     0   0   0   0
1596478 1596478 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 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     0     0   0 0     0   0   0   0
1596479 1596479 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 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     0     0   0 0     0   0   0   0
1596480 1596480 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2020   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]);