enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 90,098 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id ▼ district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1537343 1537343 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education 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
1537344 1537344 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2020   grade_10 2.0 10.0 3.0                   14.0 1.0             12     11   15 2 10 3                   14 1         12   11   15
1537345 1537345 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2020   grade_11 2.0 5.0 1.0                   8.0 0.0             7     8   8 2 5 1                   8 0         7   8   8
1537346 1537346 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2020   grade_12 2.0 0.0 1.0                   3.0 0.0             *     *   3 2 0 1                   3 0                 3
1537347 1537347 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education 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
1537348 1537348 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education 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
1537349 1537349 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education 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
1537350 1537350 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education 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
1537351 1537351 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education 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
1537352 1537352 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2020   grade_7 0.0 2.0 0.0                   1.0 1.0             *     *   2 0 2 0                   1 1                 2
1537353 1537353 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2020   grade_8 0.0 1.0 2.0                   3.0 0.0             *     *   3 0 1 2                   3 0                 3
1537354 1537354 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2020   grade_9 3.0 4.0 2.0                   9.0 0.0             7     8   9 3 4 2                   9 0         7   8   9
1537355 1537355 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education 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
1537356 1537356 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education 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
1537357 1537357 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2020   pk_12_total 9.0 22.0 9.0                   38.0 2.0             31     33   40 9 22 9                   38 2         31   33   40
1537358 1537358 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education 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
1537359 1537359 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education 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
1537360 1537360 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education 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
1537361 1537361 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2020   ungraded_secondary 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
1537362 1537362 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative 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
1537363 1537363 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2020   grade_10 5.0 1.0 1.0               1.0   7.0 1.0             *     *   8 5 1 1               1   7 1                 8
1537364 1537364 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2020   grade_11 8.0 3.0 2.0               2.0   13.0 2.0             7     7   15 8 3 2               2   13 2         7   7   15
1537365 1537365 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2020   grade_12 7.0 3.0 3.0               1.0   9.0 5.0             5     6   14 7 3 3               1   9 5         5   6   14
1537366 1537366 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative 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
1537367 1537367 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative 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
1537368 1537368 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative 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
1537369 1537369 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative 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
1537370 1537370 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative 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
1537371 1537371 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 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
1537372 1537372 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 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
1537373 1537373 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2020   grade_9 3.0 1.0 0.0               2.0   5.0 1.0             *     *   6 3 1 0               2   5 1                 6
1537374 1537374 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative 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
1537375 1537375 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative 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
1537376 1537376 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2020   pk_12_total 23.0 8.0 6.0               6.0   34.0 9.0             20     21   43 23 8 6               6   34 9         20   21   43
1537377 1537377 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative 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
1537378 1537378 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative 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
1537379 1537379 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative 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
1537380 1537380 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 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
1537381 1537381 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH 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     0     0   0 0     0   0   0   0
1537382 1537382 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2020   grade_10 81.0 0.0 10.0   1.0     0.0     7.0   55.0 44.0     *       31     7   99 81 0 10   1     0     7   55 44         31   7   99
1537383 1537383 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2020   grade_11 79.0 2.0 10.0   0.0     1.0     3.0   44.0 51.0     0       33     14   95 79 2 10   0     1     3   44 51     0   33   14   95
1537384 1537384 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2020   grade_12 73.0 1.0 8.0   0.0     0.0     2.0   40.0 44.0     *       *     11   84 73 1 8   0     0     2   40 44             11   84
1537385 1537385 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH 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     0     0   0 0     0   0   0   0
1537386 1537386 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH 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     0     0   0 0     0   0   0   0
1537387 1537387 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH 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     0     0   0 0     0   0   0   0
1537388 1537388 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH 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     0     0   0 0     0   0   0   0
1537389 1537389 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH 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     0     0   0 0     0   0   0   0
1537390 1537390 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2020   grade_7 63.0 2.0 13.0   0.0     1.0     5.0   35.0 49.0     0       29     11   84 63 2 13   0     1     5   35 49     0   29   11   84
1537391 1537391 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2020   grade_8 90.0 3.0 15.0   0.0     0.0     5.0   63.0 50.0     *       42     22   113 90 3 15   0     0     5   63 50         42   22   113
1537392 1537392 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2020   grade_9 102.0 2.0 13.0   0.0     1.0     6.0   69.0 55.0     *       39     19   124 102 2 13   0     1     6   69 55         39   19   124
1537393 1537393 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH 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     0     0   0 0     0   0   0   0
1537394 1537394 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH 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     0     0   0 0     0   0   0   0
1537395 1537395 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2020   pk_12_total 494.0 10.0 71.0   1.0     3.0     29.0   311.0 297.0     9       205     93   608 494 10 71   1     3     29   311 297     9   205   93   608
1537396 1537396 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH 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     0     0   0 0     0   0   0   0
1537397 1537397 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH 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     0     0   0 0     0   0   0   0
1537398 1537398 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH 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     0     0   0 0     0   0   0   0
1537399 1537399 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2020   ungraded_secondary 6.0 0.0 2.0   0.0     0.0     1.0   5.0 4.0     0       *     9   9 6 0 2   0     0     1   5 4     0       9   9
1537400 1537400 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_1 53.0 1.0 9.0   0.0     0.0     3.0   36.0 30.0     *       20     6   66 53 1 9   0     0     3   36 30         20   6   66
1537401 1537401 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537402 1537402 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537403 1537403 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537404 1537404 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_2 54.0 4.0 11.0   0.0     0.0     7.0   42.0 34.0     5       32     6   76 54 4 11   0     0     7   42 34     5   32   6   76
1537405 1537405 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_3 84.0 0.0 9.0   0.0     1.0     6.0   49.0 51.0     *       48     5   100 84 0 9   0     1     6   49 51         48   5   100
1537406 1537406 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_4 60.0 3.0 6.0   0.0     0.0     7.0   43.0 33.0     *       32     9   76 60 3 6   0     0     7   43 33         32   9   76
1537407 1537407 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_5 72.0 0.0 14.0   0.0     0.0     8.0   44.0 50.0     5       41     9   94 72 0 14   0     0     8   44 50     5   41   9   94
1537408 1537408 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_6 80.0 3.0 12.0   1.0     1.0     4.0   51.0 50.0     *       48     12   101 80 3 12   1     1     4   51 50         48   12   101
1537409 1537409 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537410 1537410 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537411 1537411 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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   0   0
1537412 1537412 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   kindergarten_full_day 61.0 4.0 6.0   0.0     0.0     10.0   34.0 47.0     *       14     *   81 61 4 6   0     0     10   34 47         14       81
1537413 1537413 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537414 1537414 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   pk_12_total 503.0 15.0 67.0   1.0     2.0     47.0   321.0 314.0     23       241     59   635 503 15 67   1     2     47   321 314     23   241   59   635
1537415 1537415 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   pre_kindergarten_full_day 36.0 0.0 0.0   0.0     0.0     2.0   20.0 18.0     0       *     5   38 36 0 0   0     0     2   20 18     0       5   38
1537416 1537416 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537417 1537417 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   ungraded_elementary 3.0 0.0 0.0   0.0     0.0     0.0   2.0 1.0     0       *     *   3 3 0 0   0     0     0   2 1     0           3
1537418 1537418 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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 0     0   0   0   0
1537419 1537419 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_1 36.0 0.0 3.0         0.0     2.0   21.0 20.0     0       16     7   41 36 0 3         0     2   21 20     0   16   7   41
1537420 1537420 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537421 1537421 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537422 1537422 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537423 1537423 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_2 25.0 0.0 5.0         0.0     3.0   15.0 18.0     *       18     8   33 25 0 5         0     3   15 18         18   8   33
1537424 1537424 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_3 29.0 0.0 2.0         0.0     4.0   19.0 16.0     0       18     9   35 29 0 2         0     4   19 16     0   18   9   35
1537425 1537425 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_4 28.0 0.0 4.0         0.0     1.0   18.0 15.0     *       16     *   33 28 0 4         0     1   18 15         16       33
1537426 1537426 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_5 33.0 0.0 1.0         0.0     1.0   19.0 16.0     *       16     5   35 33 0 1         0     1   19 16         16   5   35
1537427 1537427 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_6 26.0 0.0 2.0         0.0     1.0   16.0 13.0     *       12     *   29 26 0 2         0     1   16 13         12       29
1537428 1537428 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537429 1537429 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537430 1537430 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537431 1537431 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   kindergarten_full_day 21.0 1.0 0.0         1.0     0.0   9.0 14.0     *       12     *   23 21 1 0         1     0   9 14         12       23
1537432 1537432 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537433 1537433 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   pk_12_total 224.0 1.0 22.0         2.0     15.0   131.0 133.0     6       123     40   264 224 1 22         2     15   131 133     6   123   40   264
1537434 1537434 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   pre_kindergarten_full_day 26.0 0.0 5.0         1.0     3.0   14.0 21.0     0       15     *   35 26 0 5         1     3   14 21     0   15       35
1537435 1537435 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537436 1537436 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
1537437 1537437 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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   0   0
1537438 1537438 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL 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         0   0   0
1537439 1537439 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_10 31.0 0.0 5.0         0.0     0.0   15.0 21.0     *       17     *   36 31 0 5         0     0   15 21         17       36
1537440 1537440 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_11 42.0 0.0 3.0         0.0     2.0   27.0 20.0     *       16     5   47 42 0 3         0     2   27 20         16   5   47
1537441 1537441 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_12 31.0 0.0 4.0         1.0     3.0   19.0 20.0     *       20     6   39 31 0 4         1     3   19 20         20   6   39
1537442 1537442 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL 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         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]);