enrollments

Data source: Big Local News · About: Big Local

675 rows where grade = "kindergarten", state = "SD" and year = 2021 sorted by hispanic

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 675 ✖

grade ✖

  • kindergarten · 675 ✖
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
449046 449046 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School Not applicable High 05 12 2021   kindergarten 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
449237 449237 SD     school 4639540 11001   Andes Central 11-1 463954001080 5 Lakeview Colony Elem   Regular School Not applicable Elementary KG 08 2021   kindergarten 3.0                       1.0 2.0                       3.0 3                       1 2                 3
449301 449301 SD     school 4603720 38001   Arlington 38-1 460372001381 4 Arlington PreSchool   Regular School Not applicable Prekindergarten PK PK 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
449413 449413 SD     school 4604270 4001   Avon 04-1 460427001325 6 Avon PK   Regular School Not applicable Prekindergarten PK PK 2021   kindergarten 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
449673 449673 SD     school 4606960 25001   Big Stone City 25-1 460696000352 3 Big Stone MS   Regular School Not applicable Middle 06 08 2021   kindergarten 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
449717 449717 SD     school 4607050 52001   Bison 52-1 460705000054 2 Bison Elementary   Regular School Not applicable Elementary KG 06 2021   kindergarten 8.0     1.0   0.0         0.0   3.0 6.0                       9.0 8     1   0         0   3 6                 9
449718 449718 SD     school 4607050 52001   Bison 52-1 460705000055 1 Bison High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
449832 449832 SD     school 4607400 4002   Bon Homme 04-2 460740001328 8 Bon Homme PK   Regular School Not applicable Prekindergarten PK PK 2021   kindergarten 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
449833 449833 SD     school 4607400 4002   Bon Homme 04-2 460740001393 20 Dawson Colony School   Regular School Not applicable Elementary KG 08 2021   kindergarten 3.0                       3.0 0.0                       3.0 3                       3 0                 3
449834 449834 SD     school 4607400 4002   Bon Homme 04-2 460740000060 18 Hutterische Colony Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 6.0                       2.0 4.0                       6.0 6                       2 4                 6
449836 449836 SD     school 4607400 4002   Bon Homme 04-2 460740000063 5 Tabor Elementary   Regular School Not applicable Elementary KG 05 2021   kindergarten 7.0     2.0                 4.0 5.0                       9.0 7     2                 4 5                 9
449894 449894 SD     school 4607800 22001   Bowdle 22-1 460780000069 1 Bowdle High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0 0.0                     0.0 0.0                       0.0 0 0                     0 0                 0
449895 449895 SD     school 4607800 22001   Bowdle 22-1 460780000883 3 Bowdle Jr High   Regular School Not applicable Middle 07 08 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
450143 450143 SD     school 4600041 45004   Britton-Hecla 45-4 460004101143 4 Sunset Colony Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 4.0                       3.0 1.0                       4.0 4                       3 1                 4
450144 450144 SD     school 4600041 45004   Britton-Hecla 45-4 460004101364 6 Sunset Colony High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
450145 450145 SD     school 4600041 45004   Britton-Hecla 45-4 460004101180 5 Westwood Rural Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 10.0                       6.0 4.0                       10.0 10                       6 4                 10
450295 450295 SD     school 4609512 26002   Burke 26-2 460951201043 4 Burke Middle School   Regular School Not applicable Middle 06 08 2021   kindergarten 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
450342 450342 SD     school 4610320 43001   Canistota 43-1 461032000105 1 Canistota High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0 0.0                 0.0   0.0 0.0                       0.0 0 0                 0   0 0                 0
450453 450453 SD     school 4611280 28001   Castlewood 28-1 461128001126 4 Claremont Colony Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 1.0                       0.0 1.0                       1.0 1                       0 1                 1
450502 450502 SD     school 4611760 60001   Centerville 60-1 461176000116 1 Centerville Hi Sch   Regular School Not applicable High 09 12 2021   kindergarten 0.0 0.0   0.0             0.0   0.0 0.0                       0.0 0 0   0             0   0 0                 0
450649 450649 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Regular School Not applicable High 09 12 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
450653 450653 SD     school 4612300 39001   Chester Area 39-1 461230001377 7 Gracevale Colony   Regular School Not applicable Elementary KG 08 2021   kindergarten 2.0                       1.0 1.0                       2.0 2                       1 1                 2
450655 450655 SD     school 4612300 39001   Chester Area 39-1 461230001092 4 Rustic Acres   Regular School Not applicable Elementary KG 08 2021   kindergarten 10.0                       8.0 2.0                       10.0 10                       8 2                 10
450751 450751 SD     school 4612940 12002   Clark 12-2 461294001081 4 Fordham Colony Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 6.0                       4.0 2.0                       6.0 6                       4 2                 6
450752 450752 SD     school 4612940 12002   Clark 12-2 461294001082 5 Hillcrest Colony Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 4.0                       1.0 3.0                       4.0 4                       1 3                 4
450753 450753 SD     school 4612940 12002   Clark 12-2 461294001319 7 Silver Creek Colony   Regular School Not applicable Elementary KG 08 2021   kindergarten 2.0                       0.0 2.0                       2.0 2                       0 2                 2
450866 450866 SD     school 4614130 59003   Colome Consolidated 461413000140 2 Colome Elementary School   Regular School Not applicable Elementary PK 05 2021   kindergarten 8.0     3.0             1.0   4.0 8.0                       12.0 8     3             1   4 8                 12
450867 450867 SD     school 4614130 59003   Colome Consolidated 461413000141 1 Colome High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0     0.0   0.0         0.0   0.0 0.0                       0.0 0     0   0         0   0 0                 0
450869 450869 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 1.0     1.0                 1.0 1.0                       2.0 1     1                 1 1                 2
450918 450918 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501357 1 Corsica-Stickney High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
450919 450919 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501352 3 Corsica-Stickney Jr. High   Regular School Not applicable Middle 07 08 2021   kindergarten 0.0                   0.0   0.0 0.0                       0.0 0                   0   0 0                 0
451218 451218 SD     school 4678300 5006   Deubrook Area 05-6 467830001154 7 Norfeld Colony School   Regular School Not applicable Elementary KG 08 2021   kindergarten 5.0                       1.0 4.0                       5.0 5                       1 4                 5
451219 451219 SD     school 4678300 5006   Deubrook Area 05-6 467830001320 9 Red Willow Colony School   Regular School Not applicable Elementary KG 08 2021   kindergarten 1.0                       0.0 1.0                       1.0 1                       0 1                 1
451369 451369 SD     school 4619170 56002   Doland 56-2 461917001299 6 Camrose Colony Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 2.0                       2.0 0.0                       2.0 2                       2 0                 2
451370 451370 SD     school 4619170 56002   Doland 56-2 461917001101 5 Clark Colony Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
451374 451374 SD     school 4619170 56002   Doland 56-2 461917001100 4 Hillside Colony Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 1.0                       1.0 0.0                       1.0 1                       1 0                 1
451375 451375 SD     school 4619170 56002   Doland 56-2 461917001359 7 Hillside Colony High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
451554 451554 SD     school 4620100 20001   Eagle Butte 20-1 462010000956 1 C-EB High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
451555 451555 SD     school 4620100 20001   Eagle Butte 20-1 462010000898 6 C-EB Junior High   Regular School Not applicable Middle 07 08 2021   kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
451557 451557 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School Not applicable Elementary 03 06 2021   kindergarten 0.0     0.0   0.0             0.0 0.0                       0.0 0     0   0             0 0                 0
451650 451650 SD     school 4634440 22005   Edmunds Central 22-5 463444001385 6 Boulder Colony School   Regular School Not applicable Elementary KG 08 2021   kindergarten 1.0                       1.0 0.0                       1.0 1                       1 0                 1
451675 451675 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School Not applicable Elementary PK 08 2021   kindergarten 4.0                       4.0 0.0                       4.0 4                       4 0                 4
451794 451794 SD     school 4621390 5003   Elkton 05-3 462139001078 4 Newdale Colony Elem   Regular School Not applicable Elementary KG 08 2021   kindergarten 6.0                       5.0 1.0                       6.0 6                       5 1                 6
451795 451795 SD     school 4621390 5003   Elkton 05-3 462139001168 5 Rolland Colony Elem   Regular School Not applicable Elementary KG 08 2021   kindergarten 1.0                       1.0 0.0                       1.0 1                       1 0                 1
451943 451943 SD     school 4622560 44001   Eureka 44-1 462256000958 3 Eureka Jr. High   Regular School Not applicable Middle 07 08 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
452005 452005 SD     school 4622940 46002   Faith 46-2 462294000412 4 Maurine Elem.   Regular School Not applicable Elementary KG 08 2021   kindergarten 3.0                       1.0 2.0                       3.0 3                       1 2                 3
452105 452105 SD     school 4624030 24004   Faulkton Area 462403001158 6 Blumengard Colony Elem   Regular School Not applicable Elementary KG 08 2021   kindergarten 10.0                       5.0 5.0                       10.0 10                       5 5                 10
452106 452106 SD     school 4624030 24004   Faulkton Area 462403001090 5 Brentwood Colony School   Regular School Not applicable Elementary KG 08 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
452107 452107 SD     school 4624030 24004   Faulkton Area 462403001405 92 Brentwood Colony Virtual High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
452109 452109 SD     school 4624030 24004   Faulkton Area 462403000203 1 Faulkton Hi Sch   Regular School Not applicable High 09 12 2021   kindergarten 0.0 0.0                 0.0   0.0 0.0                       0.0 0 0                 0   0 0                 0
452110 452110 SD     school 4624030 24004   Faulkton Area 462403000204 8 Faulkton Jr Hi   Regular School Not applicable Middle 07 08 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
452111 452111 SD     school 4624030 24004   Faulkton Area 462403001160 10 Thunderbird Colony Elem   Regular School Not applicable Elementary KG 08 2021   kindergarten 5.0                       2.0 3.0                       5.0 5                       2 3                 5
452181 452181 SD     school 4624390 50003   Flandreau 50-3 462439001119 6 Pleasant Valley Colony Elem   Regular School Not applicable Elementary KG 08 2021   kindergarten 5.0                       5.0 0.0                       5.0 5                       5 0                 5
452229 452229 SD     school 4624540 14001   Florence 14-1 462454000208 2 Florence Elementary School   Regular School Not applicable Elementary PK 05 2021   kindergarten 22.0     0.0             0.0   9.0 13.0                       22.0 22     0             0   9 13                 22
452230 452230 SD     school 4624540 14001   Florence 14-1 462454000209 1 Florence High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
452231 452231 SD     school 4624540 14001   Florence 14-1 462454000589 3 Florence Middle School   Regular School Not applicable Middle 06 08 2021   kindergarten 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
452278 452278 SD     school 4621400 6002   Frederick Area 06-2 462140000190 1 Frederick High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0                   0.0   0.0 0.0                       0.0 0                   0   0 0                 0
452279 452279 SD     school 4621400 6002   Frederick Area 06-2 462140000957 3 Frederick Jr High   Regular School Not applicable Middle 07 08 2021   kindergarten 0.0                   0.0   0.0 0.0                       0.0 0                   0   0 0                 0
452354 452354 SD     school 4625500 33001   Freeman 33-1 462550000221 3 Tschetter Colony Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 15.0                       10.0 5.0                       15.0 15                       10 5                 15
452355 452355 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 7.0                       3.0 4.0                       7.0 7                       3 4                 7
452502 452502 SD     school 4626970 53001   Gettysburg 53-1 462697000232 1 Gettysburg High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
452658 452658 SD     school 4630490 27001   Haakon 27-1 463049000647 8 Milesville Elem   Regular School Not applicable Elementary KG 08 2021   kindergarten 2.0                       2.0 0.0                       2.0 2                       2 0                 2
452660 452660 SD     school 4630490 27001   Haakon 27-1 463049000256 1 Philip High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
452796 452796 SD     school 4602640 30001   Hanson 30-1 460264001272 7 Hanson Alternative Colony High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
452800 452800 SD     school 4602640 30001   Hanson 30-1 460264000015 4 Millbrook Colony Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 1.0                       1.0 0.0                       1.0 1                       1 0                 1
452801 452801 SD     school 4602640 30001   Hanson 30-1 460264000875 5 Oaklane Colony   Regular School Not applicable Elementary KG 08 2021   kindergarten 2.0                       2.0 0.0                       2.0 2                       2 0                 2
452879 452879 SD     school 4609300 31001   Harding County 31-1 460930000087 2 Buffalo Elementary   Regular School Not applicable Elementary KG 05 2021   kindergarten 17.0     1.0             0.0   10.0 8.0                       18.0 17     1             0   10 8                 18
452880 452880 SD     school 4609300 31001   Harding County 31-1 460930000701 8 Camp Crook Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 4.0                       3.0 1.0                       4.0 4                       3 1                 4
452881 452881 SD     school 4609300 31001   Harding County 31-1 460930000088 1 Harding County High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
452882 452882 SD     school 4609300 31001   Harding County 31-1 460930000887 3 Harding County MS   Regular School Not applicable Middle 06 08 2021   kindergarten 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
452883 452883 SD     school 4609300 31001   Harding County 31-1 460930000667 6 Ludlow Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 1.0                       1.0 0.0                       1.0 1                       1 0                 1
453077 453077 SD     school 4632340 14002   Henry 14-2 463234000275 2 Henry Elementary   Regular School Not applicable Elementary PK 05 2021   kindergarten 11.0                       7.0 4.0                       11.0 11                       7 4                 11
453079 453079 SD     school 4632340 14002   Henry 14-2 463234001047 3 Henry MS   Regular School Not applicable Middle 06 08 2021   kindergarten 0.0         0.0             0.0 0.0                       0.0 0         0             0 0                 0
453174 453174 SD     school 4680440 34002   Highmore-Harrold 468044000324 1 Highmore-Harrold High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
453175 453175 SD     school 4680440 34002   Highmore-Harrold 468044001049 3 Highmore-Harrold Junior High   Regular School Not applicable Middle 07 08 2021   kindergarten 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
453295 453295 SD     school 4600046 56006   Hitchcock-Tulare 460004601166 4 Glendale Colony Elem   Regular School Not applicable Elementary KG 08 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
453296 453296 SD     school 4600046 56006   Hitchcock-Tulare 460004601167 5 Hitchcock-Tulare Elementary   Regular School Not applicable Elementary KG 06 2021   kindergarten 10.0                       5.0 5.0                       10.0 10                       5 5                 10
453297 453297 SD     school 4600046 56006   Hitchcock-Tulare 460004601163 1 Hitchcock-Tulare HS   Regular School Not applicable High 09 12 2021   kindergarten 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
453298 453298 SD     school 4600046 56006   Hitchcock-Tulare 460004601164 2 Hitchcock-Tulare JH   Regular School Not applicable Middle 07 08 2021   kindergarten 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
453299 453299 SD     school 4600046 56006   Hitchcock-Tulare 460004601165 3 Spink Colony Elem   Regular School Not applicable Elementary KG 08 2021   kindergarten 3.0                       2.0 1.0                       3.0 3                       2 1                 3
453398 453398 SD     school 4634600 53002   Hoven 53-2 463460000298 1 Hoven High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
453399 453399 SD     school 4634600 53002   Hoven 53-2 463460000912 3 Hoven Jr High School   Regular School Not applicable Middle 07 08 2021   kindergarten 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
453461 453461 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School Not applicable Elementary KG 08 2021   kindergarten 5.0                       4.0 1.0                       5.0 5                       4 1                 5
453562 453562 SD     school 4635480 2002   Huron 02-2 463548000312 13 Huron Colony Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 2.0                       2.0 0.0                       2.0 2                       2 0                 2
453566 453566 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 3.0                       2.0 1.0                       3.0 3                       2 1                 3
453660 453660 SD     school 4636060 22006   Ipswich Public 22-6 463606001085 5 Deerfield Colony Elem   Regular School Not applicable Elementary PK 08 2021   kindergarten 6.0                       3.0 3.0                       6.0 6                       3 3                 6
453663 453663 SD     school 4636060 22006   Ipswich Public 22-6 463606000914 4 Ipswich MS   Regular School Not applicable Middle 06 08 2021   kindergarten 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
453664 453664 SD     school 4636060 22006   Ipswich Public 22-6 463606001086 6 Pembrook Colony Elem   Regular School Not applicable Elementary PK 08 2021   kindergarten 5.0                       3.0 2.0                       5.0 5                       3 2                 5
453665 453665 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School Not applicable Elementary PK 08 2021   kindergarten 2.0                       0.0 2.0                       2.0 2                       0 2                 2
453719 453719 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901253 4 Irene-Wakonda Junior High   Regular School Not applicable Middle 07 08 2021   kindergarten 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
453781 453781 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School Not applicable Middle 04 08 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
453830 453830 SD     school 4619580 37003   Jones County 37-3 461958000803 1 Jones County HS   Regular School Not applicable High 09 12 2021   kindergarten 0.0 0.0   0.0             0.0   0.0 0.0                       0.0 0 0   0             0   0 0                 0
453831 453831 SD     school 4619580 37003   Jones County 37-3 461958000955 4 Jones County MS   Regular School Not applicable Middle 05 08 2021   kindergarten 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
453918 453918 SD     school 4680437 35002   Kadoka Area 35-2 468043701249 2 Kadoka Elementary School   Regular School Not applicable Elementary PK 05 2021   kindergarten 19.0     14.0                 18.0 15.0                       33.0 19     14                 18 15                 33
453919 453919 SD     school 4680437 35002   Kadoka Area 35-2 468043701382 3 Kadoka Middle School   Regular School Not applicable Middle 06 08 2021   kindergarten 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
453920 453920 SD     school 4680437 35002   Kadoka Area 35-2 468043701256 10 Long Valley Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 1.0     3.0                 0.0 4.0                       4.0 1     3                 0 4                 4
453921 453921 SD     school 4680437 35002   Kadoka Area 35-2 468043701257 11 Midland Elementary   Regular School Not applicable Elementary KG 08 2021   kindergarten 2.0                       0.0 2.0                       2.0 2                       0 2                 2
453999 453999 SD     school 4638220 7002   Kimball 07-2 463822000917 13 Grass Ranch Colony Elem   Regular School Not applicable Elementary KG 08 2021   kindergarten 9.0                       5.0 4.0                       9.0 9                       5 4                 9
454000 454000 SD     school 4638220 7002   Kimball 07-2 463822001185 15 Grass Ranch Colony High School   Regular School Not applicable High 09 12 2021   kindergarten 0.0                       0.0 0.0                       0.0 0                       0 0                 0
454055 454055 SD     school 4639990 38003   Lake Preston 38-3 463999000918 3 Lake Preston Middle School   Regular School Not applicable Middle 06 08 2021   kindergarten 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]);