enrollments

Data source: Big Local News · About: Big Local

10,736 rows where state = "SD" and year = 2018 sorted by school descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 10,736 ✖
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
260450 260450 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 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
260456 260456 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 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
260462 260462 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 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
260468 260468 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 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
260474 260474 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 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
260480 260480 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 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
260486 260486 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 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
260492 260492 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 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
260498 260498 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   grade_6 163.0 2.0 15.0 13.0   0.0         9.0   110.0 92.0                       202.0 163 2 15 13   0         9   110 92                 202
260504 260504 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   grade_7 187.0 3.0 18.0 10.0   1.0         3.0   112.0 110.0                       222.0 187 3 18 10   1         3   112 110                 222
260510 260510 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   grade_8 179.0 4.0 9.0 13.0   3.0         3.0   113.0 98.0                       211.0 179 4 9 13   3         3   113 98                 211
260516 260516 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 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
260522 260522 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   k_12_total 529.0 9.0 42.0 36.0   4.0         15.0   335.0 300.0       1.6               635.0 529 9 42 36   4         15   335 300                 635
260528 260528 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   kindergarten 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
260534 260534 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   pk_12_total 529.0 9.0 42.0 36.0   4.0         15.0   335.0 300.0                       635.0 529 9 42 36   4         15   335 300                 635
260540 260540 SD     school 4680430 63003   Yankton 63-3 468043010799 2 Yankton Middle School   Regular School No Middle 06 08 2018   pre_kindergarten 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
260449 260449 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 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
260455 260455 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   grade_10 190.0 3.0 12.0 9.0   1.0         4.0   112.0 107.0                       219.0 190 3 12 9   1         4   112 107                 219
260461 260461 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   grade_11 196.0 3.0 14.0 11.0   4.0         0.0   123.0 105.0                       228.0 196 3 14 11   4         0   123 105                 228
260467 260467 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   grade_12 184.0 3.0 18.0 6.0   4.0         1.0   115.0 101.0                       216.0 184 3 18 6   4         1   115 101                 216
260473 260473 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 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
260479 260479 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 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
260485 260485 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 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
260491 260491 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 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
260497 260497 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 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
260503 260503 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 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   0 0                 0
260509 260509 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 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
260515 260515 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   grade_9 175.0 1.0 16.0 12.0   0.0         0.0   103.0 101.0                       204.0 175 1 16 12   0         0   103 101                 204
260521 260521 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   k_12_total 745.0 10.0 60.0 38.0   9.0         5.0   453.0 414.0       1.6               867.0 745 10 60 38   9         5   453 414                 867
260527 260527 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   kindergarten 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
260533 260533 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   pk_12_total 745.0 10.0 60.0 38.0   9.0         5.0   453.0 414.0                       867.0 745 10 60 38   9         5   453 414                 867
260539 260539 SD     school 4680430 63003   Yankton 63-3 468043000798 1 Yankton Hi Sch   Regular School No High 09 12 2018   pre_kindergarten 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
255169 255169 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   grade_1 16.0   1.0 0.0                 14.0 3.0                       17.0 16   1 0                 14 3                 17
255174 255174 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   grade_10 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
255179 255179 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   grade_11 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
255184 255184 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   grade_12 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
255189 255189 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   grade_2 15.0   2.0 0.0                 8.0 9.0                       17.0 15   2 0                 8 9                 17
255194 255194 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   grade_3 17.0   0.0 0.0                 9.0 8.0                       17.0 17   0 0                 9 8                 17
255199 255199 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   grade_4 10.0   0.0 1.0                 5.0 6.0                       11.0 10   0 1                 5 6                 11
255204 255204 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   grade_5 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
255209 255209 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   grade_6 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
255214 255214 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   grade_7 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
255219 255219 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   grade_8 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
255224 255224 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   grade_9 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
255229 255229 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   k_12_total 72.0   3.0 2.0                 44.0 33.0       0.0               77.0 72   3 2                 44 33                 77
255234 255234 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   kindergarten 14.0   0.0 1.0                 8.0 7.0                       15.0 14   0 1                 8 7                 15
255239 255239 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   pk_12_total 91.0   3.0 2.0                 55.0 41.0                       96.0 91   3 2                 55 41                 96
255244 255244 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2018   pre_kindergarten 19.0   0.0 0.0                 11.0 8.0                       19.0 19   0 0                 11 8                 19
260414 260414 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   grade_1 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
260416 260416 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   grade_10 19.0   2.0                   8.0 13.0                       21.0 19   2                   8 13                 21
260418 260418 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   grade_11 14.0   0.0                   7.0 7.0                       14.0 14   0                   7 7                 14
260420 260420 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   grade_12 17.0   0.0                   11.0 6.0                       17.0 17   0                   11 6                 17
260422 260422 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   grade_2 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
260424 260424 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   grade_3 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
260426 260426 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   grade_4 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
260428 260428 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   grade_5 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
260430 260430 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   grade_6 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
260432 260432 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   grade_7 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
260434 260434 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   grade_8 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
260436 260436 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   grade_9 16.0   1.0                   9.0 8.0                       17.0 16   1                   9 8                 17
260438 260438 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   k_12_total 66.0   3.0                   35.0 34.0       0.0               69.0 66   3                   35 34                 69
260440 260440 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   kindergarten 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
260442 260442 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   pk_12_total 66.0   3.0                   35.0 34.0                       69.0 66   3                   35 34                 69
260444 260444 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2018   pre_kindergarten 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
260413 260413 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   grade_1 17.0 0.0 0.0     0.0         0.0   7.0 10.0                       17.0 17 0 0     0         0   7 10                 17
260415 260415 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 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
260417 260417 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 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
260419 260419 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 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
260421 260421 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   grade_2 15.0 1.0 0.0     0.0         0.0   8.0 8.0                       16.0 15 1 0     0         0   8 8                 16
260423 260423 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   grade_3 8.0 0.0 3.0     0.0         2.0   8.0 5.0                       13.0 8 0 3     0         2   8 5                 13
260425 260425 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   grade_4 24.0 0.0 0.0     1.0         0.0   11.0 14.0                       25.0 24 0 0     1         0   11 14                 25
260427 260427 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   grade_5 20.0 0.0 2.0     0.0         0.0   12.0 10.0                       22.0 20 0 2     0         0   12 10                 22
260429 260429 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   grade_6 14.0 0.0 3.0     1.0         2.0   10.0 10.0                       20.0 14 0 3     1         2   10 10                 20
260431 260431 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   grade_7 17.0 0.0 1.0     0.0         1.0   9.0 10.0                       19.0 17 0 1     0         1   9 10                 19
260433 260433 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   grade_8 15.0 0.0 0.0     0.0         0.0   6.0 9.0                       15.0 15 0 0     0         0   6 9                 15
260435 260435 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 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
260437 260437 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   k_12_total 144.0 1.0 10.0     3.0         5.0   81.0 82.0       1.8               163.0 144 1 10     3         5   81 82                 163
260439 260439 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   kindergarten 14.0 0.0 1.0     1.0         0.0   10.0 6.0                       16.0 14 0 1     1         0   10 6                 16
260441 260441 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   pk_12_total 164.0 1.0 12.0     3.0         6.0   94.0 92.0                       186.0 164 1 12     3         6   94 92                 186
260443 260443 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten 20.0 0.0 2.0     0.0         1.0   13.0 10.0                       23.0 20 0 2     0         1   13 10                 23
257077 257077 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   grade_1 27.0 0.0 2.0 12.0   1.0       0.0 2.0   17.0 27.0                       44.0 27 0 2 12   1       0 2   17 27                 44
257102 257102 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 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
257127 257127 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 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
257152 257152 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 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
257177 257177 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   grade_2 38.0 0.0 4.0 12.0   3.0       0.0 7.0   33.0 31.0                       64.0 38 0 4 12   3       0 7   33 31                 64
257202 257202 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   grade_3 44.0 0.0 2.0 11.0   1.0       0.0 4.0   29.0 33.0                       62.0 44 0 2 11   1       0 4   29 33                 62
257227 257227 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   grade_4 29.0 0.0 3.0 15.0   1.0       0.0 7.0   32.0 23.0                       55.0 29 0 3 15   1       0 7   32 23                 55
257252 257252 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   grade_5 39.0 0.0 7.0 8.0   0.0       0.0 5.0   27.0 32.0                       59.0 39 0 7 8   0       0 5   27 32                 59
257277 257277 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 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
257302 257302 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 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
257327 257327 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 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
257352 257352 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 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
257377 257377 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   k_12_total 212.0 2.0 27.0 70.0   7.0       1.0 34.0   170.0 183.0       0.9               353.0 212 2 27 70   7       1 34   170 183                 353
257402 257402 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   kindergarten 35.0 2.0 9.0 12.0   1.0       1.0 9.0   32.0 37.0                       69.0 35 2 9 12   1       1 9   32 37                 69
257427 257427 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   pk_12_total 212.0 2.0 27.0 70.0   7.0       1.0 34.0   170.0 183.0                       353.0 212 2 27 70   7       1 34   170 183                 353
257452 257452 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School No Elementary KG 05 2018   pre_kindergarten 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
251712 251712 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No Elementary KG 08 2018   grade_1 0.0     1.0                 0.0 1.0                       1.0 0     1                 0 1                 1
251716 251716 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No Elementary KG 08 2018   grade_10 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
251720 251720 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No Elementary KG 08 2018   grade_11 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
251724 251724 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No Elementary KG 08 2018   grade_12 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]);