enrollments

Data source: Big Local News · About: Big Local

89,718 rows where state = "NY" and year = 2018 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 89,718 ✖
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
2063454 2063454 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   grade_1 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
2063455 2063455 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   grade_10 3.0 3.0 2.0                   8.0               7     6   8 3 3 2                   8           7   6   8
2063456 2063456 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   grade_11 4.0 1.0 0.0                   5.0               *     *   5 4 1 0                   5                   5
2063457 2063457 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   grade_12 1.0 2.0 0.0                   3.0               *     *   3 1 2 0                   3                   3
2063458 2063458 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   grade_2 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
2063459 2063459 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   grade_3 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
2063460 2063460 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   grade_4 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
2063461 2063461 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   grade_5 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
2063462 2063462 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   grade_6 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
2063463 2063463 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   grade_7 1.0 1.0 0.0                   2.0               *     *   2 1 1 0                   2                   2
2063464 2063464 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   grade_8 3.0 3.0 2.0                   8.0               6     6   8 3 3 2                   8           6   6   8
2063465 2063465 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   grade_9 7.0 9.0 6.0                   22.0               18     14   22 7 9 6                   22           18   14   22
2063466 2063466 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   kindergarten_full_day 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
2063467 2063467 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   kindergarten_half_day 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
2063468 2063468 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   pk_12_total 19.0 19.0 10.0                   48.0               39     33   48 19 19 10                   48           39   33   48
2063469 2063469 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   pre_kindergarten_full_day 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
2063470 2063470 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   pre_kindergarten_half_day 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
2063471 2063471 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   ungraded_elementary 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
2063472 2063472 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   ungraded_secondary 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
2063473 2063473 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   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
2063474 2063474 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   grade_10 2.0 1.0 1.0               1.0   3.0 2.0             *     *   5 2 1 1               1   3 2                 5
2063475 2063475 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   grade_11 8.0 3.0 0.0               0.0   10.0 1.0             6     5   11 8 3 0               0   10 1         6   5   11
2063476 2063476 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   grade_12 5.0 3.0 2.0               1.0   5.0 6.0             5     *   11 5 3 2               1   5 6         5       11
2063477 2063477 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   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
2063478 2063478 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   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
2063479 2063479 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   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
2063480 2063480 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   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
2063481 2063481 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   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
2063482 2063482 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   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
2063483 2063483 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   grade_8 0.0 0.0 0.0               1.0   0.0 1.0             *     *   1 0 0 0               1   0 1                 1
2063484 2063484 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   grade_9 4.0 2.0 0.0               1.0   6.0 1.0             5     5   7 4 2 0               1   6 1         5   5   7
2063485 2063485 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   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
2063486 2063486 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   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
2063487 2063487 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   pk_12_total 19.0 9.0 3.0               4.0   24.0 11.0             21     18   35 19 9 3               4   24 11         21   18   35
2063488 2063488 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   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
2063489 2063489 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   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
2063490 2063490 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   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
2063491 2063491 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   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
2063492 2063492 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   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
2063493 2063493 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   grade_10 78.0 1.0 5.0   0.0     0.0     2.0   43.0 43.0     *       43     13   86 78 1 5   0     0     2   43 43         43   13   86
2063494 2063494 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   grade_11 81.0 1.0 14.0   0.0     0.0     3.0   52.0 47.0     *       60     14   99 81 1 14   0     0     3   52 47         60   14   99
2063495 2063495 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   grade_12 87.0 2.0 10.0   0.0     0.0     3.0   44.0 58.0     *       50     15   102 87 2 10   0     0     3   44 58         50   15   102
2063496 2063496 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   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
2063497 2063497 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   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
2063498 2063498 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   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
2063499 2063499 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   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
2063500 2063500 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   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
2063501 2063501 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   grade_7 91.0 0.0 14.0   0.0     1.0     6.0   57.0 55.0     *       61     17   112 91 0 14   0     1     6   57 55         61   17   112
2063502 2063502 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   grade_8 81.0 0.0 10.0   1.0     0.0     6.0   52.0 46.0     *       53     11   98 81 0 10   1     0     6   52 46         53   11   98
2063503 2063503 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   grade_9 108.0 2.0 12.0   0.0     1.0     7.0   63.0 67.0     *       84     27   130 108 2 12   0     1     7   63 67         84   27   130
2063504 2063504 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   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
2063505 2063505 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   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
2063506 2063506 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   pk_12_total 534.0 6.0 67.0   1.0     2.0     28.0   317.0 321.0     10       360     108   638 534 6 67   1     2     28   317 321     10   360   108   638
2063507 2063507 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   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
2063508 2063508 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   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
2063509 2063509 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   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
2063510 2063510 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   ungraded_secondary 8.0 0.0 2.0   0.0     0.0     1.0   6.0 5.0     0       9     11   11 8 0 2   0     0     1   6 5     0   9   11   11
2063511 2063511 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_1 84.0 0.0 8.0   0.0     1.0     8.0   51.0 50.0     *       71     5   101 84 0 8   0     1     8   51 50         71   5   101
2063512 2063512 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063513 2063513 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063514 2063514 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063515 2063515 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_2 64.0 2.0 8.0   0.0     0.0     6.0   48.0 32.0     0       56     8   80 64 2 8   0     0     6   48 32     0   56   8   80
2063516 2063516 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_3 79.0 1.0 11.0   0.0     0.0     10.0   45.0 56.0     *       68     7   101 79 1 11   0     0     10   45 56         68   7   101
2063517 2063517 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_4 91.0 3.0 13.0   1.0     1.0     4.0   58.0 55.0     *       78     11   113 91 3 13   1     1     4   58 55         78   11   113
2063518 2063518 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_5 61.0 1.0 14.0   0.0     0.0     7.0   38.0 45.0     0       56     8   83 61 1 14   0     0     7   38 45     0   56   8   83
2063519 2063519 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_6 90.0 2.0 14.0   0.0     0.0     5.0   62.0 49.0     *       74     23   111 90 2 14   0     0     5   62 49         74   23   111
2063520 2063520 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063521 2063521 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063522 2063522 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063523 2063523 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   kindergarten_full_day 59.0 3.0 11.0   0.0     0.0     8.0   44.0 37.0     *       48     6   81 59 3 11   0     0     8   44 37         48   6   81
2063524 2063524 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063525 2063525 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pk_12_total 558.0 12.0 82.0   1.0     2.0     51.0   366.0 340.0     13       476     73   706 558 12 82   1     2     51   366 340     13   476   73   706
2063526 2063526 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pre_kindergarten_full_day 29.0 0.0 3.0   0.0     0.0     3.0   19.0 16.0     0       *     *   35 29 0 3   0     0     3   19 16     0           35
2063527 2063527 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063528 2063528 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   ungraded_elementary 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0     0       *     *   1 1 0 0   0     0     0   1 0     0           1
2063529 2063529 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063530 2063530 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_1 33.0 0.0 2.0         0.0     4.0   19.0 20.0     0       19     9   39 33 0 2         0     4   19 20     0   19   9   39
2063531 2063531 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063532 2063532 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063533 2063533 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063534 2063534 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_2 28.0 0.0 3.0         0.0     1.0   16.0 16.0     *       16     *   32 28 0 3         0     1   16 16         16       32
2063535 2063535 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_3 32.0 0.0 1.0         1.0     1.0   18.0 17.0     *       14     *   35 32 0 1         1     1   18 17         14       35
2063536 2063536 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_4 27.0 0.0 2.0         0.0     1.0   15.0 15.0     *       13     *   30 27 0 2         0     1   15 15         13       30
2063537 2063537 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_5 30.0 0.0 4.0         2.0     1.0   22.0 15.0     *       16     6   37 30 0 4         2     1   22 15         16   6   37
2063538 2063538 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_6 56.0 1.0 7.0         0.0     2.0   41.0 25.0     *       30     14   66 56 1 7         0     2   41 25         30   14   66
2063539 2063539 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063540 2063540 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063541 2063541 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063542 2063542 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   kindergarten_full_day 27.0 0.0 6.0         0.0     2.0   18.0 17.0     *       16     *   35 27 0 6         0     2   18 17         16       35
2063543 2063543 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063544 2063544 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pk_12_total 262.0 1.0 29.0         3.0     13.0   169.0 139.0     8       135     50   308 262 1 29         3     13   169 139     8   135   50   308
2063545 2063545 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pre_kindergarten_full_day 28.0 0.0 4.0         0.0     1.0   19.0 14.0     0       *     6   33 28 0 4         0     1   19 14     0       6   33
2063546 2063546 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063547 2063547 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   ungraded_elementary 1.0 0.0 0.0         0.0     0.0   1.0 0.0     0       *     *   1 1 0 0         0     0   1 0     0           1
2063548 2063548 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2063549 2063549 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   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
2063550 2063550 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_10 37.0   3.0   0.0     1.0     3.0   23.0 21.0     *       22     9   44 37   3   0     1     3   23 21         22   9   44
2063551 2063551 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_11 33.0   2.0   1.0     0.0     3.0   20.0 19.0     *       14     6   39 33   2   1     0     3   20 19         14   6   39
2063552 2063552 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_12 26.0   1.0   0.0     0.0     0.0   16.0 11.0     *       *     0   27 26   1   0     0     0   16 11             0   27
2063553 2063553 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   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]);