enrollments

Data source: Big Local News · About: Big Local

89,661 rows where state = "NY" and year = 2019 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 89,661 ✖
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
2153172 2153172 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_1 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2153173 2153173 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_10 5.0 5.0 6.0                   16.0 0.0             11     9   16 5 5 6                   16 0         11   9   16
2153174 2153174 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_11 1.0 0.0 1.0                   2.0 0.0             *     *   2 1 0 1                   2 0                 2
2153175 2153175 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_12 2.0 2.0 0.0                   4.0 0.0             *     *   4 2 2 0                   4 0                 4
2153176 2153176 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2153177 2153177 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_3 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2153178 2153178 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_4 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2153179 2153179 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_5 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2153180 2153180 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_6 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2153181 2153181 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_7 1.0 0.0 1.0                   2.0 0.0             *     *   2 1 0 1                   2 0                 2
2153182 2153182 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_8 2.0 0.0 0.0                   2.0 0.0             *     *   2 2 0 0                   2 0                 2
2153183 2153183 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_9 5.0 3.0 4.0                   11.0 1.0             5     7   12 5 3 4                   11 1         5   7   12
2153184 2153184 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   kindergarten_full_day 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2153185 2153185 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   kindergarten_half_day 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2153186 2153186 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   pk_12_total 16.0 10.0 12.0                   37.0 1.0             23     25   38 16 10 12                   37 1         23   25   38
2153187 2153187 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   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
2153188 2153188 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   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
2153189 2153189 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   ungraded_elementary 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2153190 2153190 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   ungraded_secondary 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2153191 2153191 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153192 2153192 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   grade_10 8.0 5.0 3.0               1.0   15.0 2.0             11     9   17 8 5 3               1   15 2         11   9   17
2153193 2153193 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   grade_11 6.0 5.0 1.0               2.0   10.0 4.0             11     6   14 6 5 1               2   10 4         11   6   14
2153194 2153194 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   grade_12 8.0 1.0 1.0               0.0   9.0 1.0             *     *   10 8 1 1               0   9 1                 10
2153195 2153195 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153196 2153196 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153197 2153197 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153198 2153198 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153199 2153199 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153200 2153200 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153201 2153201 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   grade_8 1.0 0.0 0.0               0.0   1.0 0.0             *     *   1 1 0 0               0   1 0                 1
2153202 2153202 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   grade_9 1.0 0.0 2.0               1.0   2.0 2.0             *     *   4 1 0 2               1   2 2                 4
2153203 2153203 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153204 2153204 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153205 2153205 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   pk_12_total 24.0 11.0 7.0               4.0   37.0 9.0             31     21   46 24 11 7               4   37 9         31   21   46
2153206 2153206 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153207 2153207 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153208 2153208 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153209 2153209 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153210 2153210 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   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
2153211 2153211 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   grade_10 89.0 1.0 12.0   0.0     1.0     4.0   51.0 56.0     *       59     12   107 89 1 12   0     1     4   51 56         59   12   107
2153212 2153212 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   grade_11 74.0 0.0 7.0   0.0     0.0     2.0   39.0 44.0     *       45     12   83 74 0 7   0     0     2   39 44         45   12   83
2153213 2153213 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   grade_12 77.0 1.0 13.0   0.0     0.0     3.0   49.0 45.0     *       55     10   94 77 1 13   0     0     3   49 45         55   10   94
2153214 2153214 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   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
2153215 2153215 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   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
2153216 2153216 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   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
2153217 2153217 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   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
2153218 2153218 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   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
2153219 2153219 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   grade_7 87.0 3.0 15.0   0.0     0.0     5.0   62.0 48.0     *       72     22   110 87 3 15   0     0     5   62 48         72   22   110
2153220 2153220 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   grade_8 95.0 0.0 12.0   0.0     1.0     5.0   57.0 56.0     *       63     17   113 95 0 12   0     1     5   57 56         63   17   113
2153221 2153221 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   grade_9 92.0 1.0 14.0   1.0     0.0     9.0   66.0 51.0     *       68     21   117 92 1 14   1     0     9   66 51         68   21   117
2153222 2153222 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   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
2153223 2153223 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   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
2153224 2153224 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   pk_12_total 521.0 6.0 75.0   1.0     2.0     29.0   329.0 305.0     15       370     104   634 521 6 75   1     2     29   329 305     15   370   104   634
2153225 2153225 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   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
2153226 2153226 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   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
2153227 2153227 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   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
2153228 2153228 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   ungraded_secondary 7.0 0.0 2.0   0.0     0.0     1.0   5.0 5.0     0       8     10   10 7 0 2   0     0     1   5 5     0   8   10   10
2153229 2153229 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_1 57.0 4.0 12.0   0.0     0.0     7.0   42.0 38.0     5       51     6   80 57 4 12   0     0     7   42 38     5   51   6   80
2153230 2153230 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153231 2153231 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153232 2153232 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153233 2153233 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 82.0 0.0 10.0   0.0     1.0     8.0   50.0 51.0     *       75     7   101 82 0 10   0     1     8   50 51         75   7   101
2153234 2153234 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_3 62.0 3.0 7.0   0.0     0.0     5.0   45.0 32.0     0       56     *   77 62 3 7   0     0     5   45 32     0   56       77
2153235 2153235 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_4 72.0 1.0 14.0   0.0     0.0     9.0   45.0 51.0     5       64     7   96 72 1 14   0     0     9   45 51     5   64   7   96
2153236 2153236 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_5 83.0 4.0 12.0   1.0     1.0     4.0   54.0 51.0     *       75     11   105 83 4 12   1     1     4   54 51         75   11   105
2153237 2153237 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_6 63.0 2.0 13.0   0.0     0.0     6.0   39.0 45.0     0       51     10   84 63 2 13   0     0     6   39 45     0   51   10   84
2153238 2153238 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153239 2153239 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153240 2153240 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153241 2153241 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_full_day 51.0 1.0 7.0   0.0     0.0     4.0   34.0 29.0     *       40     *   63 51 1 7   0     0     4   34 29         40       63
2153242 2153242 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153243 2153243 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 501.0 15.0 77.0   1.0     2.0     50.0   332.0 314.0     17       435     56   646 501 15 77   1     2     50   332 314     17   435   56   646
2153244 2153244 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pre_kindergarten_full_day 28.0 0.0 1.0   0.0     0.0     7.0   20.0 16.0     0       *     5   36 28 0 1   0     0     7   20 16     0       5   36
2153245 2153245 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153246 2153246 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   ungraded_elementary 3.0 0.0 1.0   0.0     0.0     0.0   3.0 1.0     0       *     *   4 3 0 1   0     0     0   3 1     0           4
2153247 2153247 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153248 2153248 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_1 25.0   5.0         0.0     2.0   15.0 17.0     *       16     5   32 25   5         0     2   15 17         16   5   32
2153249 2153249 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153250 2153250 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153251 2153251 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153252 2153252 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 28.0   2.0         0.0     4.0   18.0 16.0     0       17     8   34 28   2         0     4   18 16     0   17   8   34
2153253 2153253 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_3 28.0   3.0         0.0     1.0   17.0 15.0     *       15     *   32 28   3         0     1   17 15         15       32
2153254 2153254 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_4 34.0   1.0         0.0     1.0   19.0 17.0     *       15     6   36 34   1         0     1   19 17         15   6   36
2153255 2153255 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_5 27.0   2.0         0.0     1.0   16.0 14.0     *       14     5   30 27   2         0     1   16 14         14   5   30
2153256 2153256 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_6 33.0   3.0         2.0     1.0   25.0 14.0     *       18     11   39 33   3         2     1   25 14         18   11   39
2153257 2153257 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153258 2153258 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153259 2153259 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153260 2153260 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_full_day 33.0   4.0         0.0     1.0   19.0 19.0     0       15     *   38 33   4         0     1   19 19     0   15       38
2153261 2153261 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153262 2153262 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 229.0   20.0         3.0     11.0   138.0 125.0     5       120     46   263 229   20         3     11   138 125     5   120   46   263
2153263 2153263 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pre_kindergarten_full_day 20.0   0.0         1.0     0.0   8.0 13.0     0       *     *   21 20   0         1     0   8 13     0           21
2153264 2153264 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153265 2153265 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   ungraded_elementary 1.0   0.0         0.0     0.0   1.0 0.0     0       *     *   1 1   0         0     0   1 0     0           1
2153266 2153266 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2153267 2153267 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   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
2153268 2153268 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_10 45.0 0.0 5.0   0.0     0.0     2.0   29.0 23.0     *       22     6   52 45 0 5   0     0     2   29 23         22   6   52
2153269 2153269 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_11 33.0 0.0 2.0   0.0     1.0     4.0   20.0 20.0     *       18     6   40 33 0 2   0     1     4   20 20         18   6   40
2153270 2153270 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_12 30.0 0.0 2.0   1.0     0.0     2.0   17.0 18.0     *       14     6   35 30 0 2   1     0     2   17 18         14   6   35
2153271 2153271 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   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

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