Data source: Big Local News · About: Big Local

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

View and edit SQL

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
257629 SD     school 4664140 39004   Rutland 39-4 466414001348 4 Camridge Colony School   Regular School No Elementary KG 08 2018   k_12_total 20.0                       12.0 8.0       90.0               20.0 20                       12 8                 20
258329 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2018   k_12_total 685.0 67.0 65.0 8.0   16.0       1.0 48.0   438.0 452.0       9.1               890.0 685 67 65 8   16       1 48   438 452                 890
254486 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 15.0                       10.0 5.0       86.7               15.0 15                       10 5                 15
251541 SD     school 4612300 39001   Chester Area 39-1 461230001377 7 Gracevale Colony   Regular School No Elementary KG 08 2018   k_12_total 16.0                       9.0 7.0       81.3               16.0 16                       9 7                 16
258333 SD     school 4666270 49005   Sioux Falls 49-5 466627001123 45 FLEX   Special Education School No High 06 12 2018   k_12_total 16.0 10.0 3.0 5.0             2.0   27.0 9.0       8.3               36.0 16 10 3 5             2   27 9                 36
249928 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No Elementary PK 05 2018   k_12_total 239.0 4.0 33.0 31.0   27.0       3.0 11.0   185.0 163.0       8.1               348.0 239 4 33 31   27       3 11   185 163                 348
252109 SD     school 4678300 5006   Deubrook Area 05-6 467830001320 9 Red Willow Colony School   Regular School No Elementary KG 08 2018   k_12_total 13.0                       7.0 6.0       76.9               13.0 13                       7 6                 13
251641 SD     school 4612940 12002   Clark 12-2 461294001082 5 Hillcrest Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 29.0                       17.0 12.0       75.9               29.0 29                       17 12                 29
256256 SD     school 4648780 43002   Montrose 43-2 464878001095 4 Orland Colony   Regular School No Elementary KG 08 2018   k_12_total 29.0                       18.0 11.0       75.9               29.0 29                       18 11                 29
251640 SD     school 4612940 12002   Clark 12-2 461294001081 4 Fordham Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 29.0                       8.0 21.0       72.4               29.0 29                       8 21                 29
251642 SD     school 4612940 12002   Clark 12-2 461294001319 7 Silver Creek Colony   Regular School No Elementary KG 08 2018   k_12_total 43.0                       24.0 19.0       72.1               43.0 43                       24 19                 43
251543 SD     school 4612300 39001   Chester Area 39-1 461230001092 4 Rustic Acres   Regular School No Elementary KG 08 2018   k_12_total 21.0                       14.0 7.0       71.4               21.0 21                       14 7                 21
254221 SD     school 4600046 56006   Hitchcock-Tulare 460004601165 3 Spink Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 28.0                       14.0 14.0       71.4               28.0 28                       14 14                 28
254384 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No Elementary KG 08 2018   k_12_total 28.0                       13.0 15.0       71.4               28.0 28                       13 15                 28
251129 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2018   k_12_total 214.0 7.0 14.0 13.0   11.0         18.0   146.0 131.0       7.9               277.0 214 7 14 13   11         18   146 131                 277
254145 SD     school 4633360 51002   Hill City 51-2 463336000279 2 Hill City Elementary   Regular School No Elementary PK 05 2018   k_12_total 132.0   44.0 5.0             9.0   92.0 98.0       7.4               190.0 132   44 5             9   92 98                 190
258335 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No Middle 06 08 2018   k_12_total 339.0 137.0 158.0 100.0   18.0       2.0 56.0   435.0 375.0       7.4               810.0 339 137 158 100   18       2 56   435 375                 810
253935 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School No Elementary KG 05 2018   k_12_total 177.0 8.0 8.0     5.0         7.0   102.0 103.0       7.3               205.0 177 8 8     5         7   102 103                 205
259249 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School No Elementary KG 06 2018   k_12_total 442.0 40.0 24.0               11.0   278.0 239.0       7.2               517.0 442 40 24               11   278 239                 517
253276 SD     school 4625500 33001   Freeman 33-1 462550000221 3 Tschetter Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 23.0                       15.0 8.0       69.6               23.0 23                       15 8                 23
257568 SD     school 4663360 54004   Rosholt 54-4 466336000558 3 White Rock Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 23.0                       11.0 12.0       69.6               23.0 23                       11 12                 23
252717 SD     school 4621390 5003   Elkton 05-3 462139001168 5 Rolland Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 13.0                       8.0 5.0       69.2               13.0 13                       8 5                 13
253277 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 27.0                       13.0 14.0       66.7               27.0 27                       13 14                 27
256118 SD     school 4648390 17002   Mitchell 17-2 464839000444 10 Rockport Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 17.0                       6.0 11.0       64.7               17.0 17                       6 11                 17
253029 SD     school 4624030 24004   Faulkton Area 462403001158 6 Blumengard Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 28.0                       17.0 11.0       64.3               28.0 28                       17 11                 28
252108 SD     school 4678300 5006   Deubrook Area 05-6 467830001154 7 Norfeld Colony School   Regular School No Elementary KG 08 2018   k_12_total 22.0                       7.0 15.0       63.6               22.0 22                       7 15                 22
255322 SD     school 4641640 44002   Leola 44-2 464164000394 4 Spring Creek Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 29.0                       20.0 9.0       62.1               29.0 29                       20 9                 29
251344 SD     school 4611280 28001   Castlewood 28-1 461128001126 4 Claremont Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 10.0                       5.0 5.0       60.0               10.0 10                       5 5                 10
254482 SD     school 4635480 2002   Huron 02-2 463548000312 13 Huron Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 20.0                       13.0 7.0       60.0               20.0 20                       13 7                 20
249930 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School No Elementary KG 05 2018   k_12_total 173.0 5.0 11.0 23.0   12.0       1.0 10.0   120.0 115.0       6.8               235.0 173 5 11 23   12       1 10   120 115                 235
253273 SD     school 4625500 33001   Freeman 33-1 462550000219 2 Freeman Elem   Regular School No Elementary KG 06 2018   k_12_total 127.0 2.0 15.0 1.0   1.0         3.0   69.0 80.0       6.7               149.0 127 2 15 1   1         3   69 80                 149
249933 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No Elementary KG 05 2018   k_12_total 312.0 12.0 23.0 24.0   11.0       3.0 18.0   197.0 206.0       6.5               403.0 312 12 23 24   11       3 18   197 206                 403
252770 SD     school 4622410 28002   Estelline 28-2 462241000192 1 Estelline High School   Regular School No High 09 12 2018   k_12_total 66.0   9.0     1.0         1.0   32.0 45.0       6.5               77.0 66   9     1         1   32 45                 77
253930 SD     school 4631350 41002   Harrisburg 41-2 463135001169 4 Explorer Elementary   Regular School No Elementary PK 05 2018   k_12_total 357.0 19.0 17.0 9.0   8.0         20.0   221.0 209.0       6.3               430.0 357 19 17 9   8         20   221 209                 430
253275 SD     school 4625500 33001   Freeman 33-1 462550000842 5 Freeman Jr High   Regular School No Middle 07 08 2018   k_12_total 28.0   3.0               2.0   16.0 17.0       6.1               33.0 28   3               2   16 17                 33
255953 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   k_12_total 353.0 6.0 36.0 1.0             12.0   224.0 184.0       6.1               408.0 353 6 36 1             12   224 184                 408
258324 SD     school 4666270 49005   Sioux Falls 49-5 466627001139 52 Bridges at Horace Mann   Regular School No Elementary KG 05 2018   k_12_total 44.0 13.0 8.0 7.0             11.0   69.0 14.0       6.0               83.0 44 13 8 7             11   69 14                 83
256652 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701112 4 Spring Lake Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 27.0                       10.0 17.0       59.3               27.0 27                       10 17                 27
250724 SD     school 4607400 4002   Bon Homme 04-2 460740000060 18 Hutterische Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 51.0                       27.0 24.0       58.8               51.0 51                       27 24                 51
256016 SD     school 4647942 29004   Miller 464794200431 11 Millerdale Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 17.0                       8.0 9.0       58.8               17.0 17                       8 9                 17
255040 SD     school 4640860 45005   Langford Area 464086001097 4 Newport Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 29.0                       14.0 15.0       58.6               29.0 29                       14 15                 29
252257 SD     school 4619170 56002   Doland 56-2 461917001299 6 Camrose Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 12.0                       6.0 6.0       58.3               12.0 12                       6 6                 12
259453 SD     school 4674520 60006   Viborg-Hurley 60-6 467452001301 4 Cameron Colony   Regular School No Elementary KG 08 2018   k_12_total 18.0   1.0                   7.0 12.0       57.9               19.0 18   1                   7 12                 19
255549 SD     school 4601026 43007   McCook Central 43-7 460102601281 4 Golden View Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 21.0                       9.0 12.0       57.1               21.0 21                       9 12                 21
256119 SD     school 4648390 17002   Mitchell 17-2 464839000445 11 Rosedale Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 23.0                       14.0 9.0       56.5               23.0 23                       14 9                 23
255897 SD     school 4647100 33002   Menno 33-2 464710000417 3 Jamesville Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 16.0                       9.0 7.0       56.3               16.0 16                       9 7                 16
251032 SD     school 4600041 45004   Britton-Hecla 45-4 460004101143 4 Sunset Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 22.0                       14.0 8.0       54.6               22.0 22                       14 8                 22
255321 SD     school 4641640 44002   Leola 44-2 464164000393 5 Long Lake Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 22.0                       13.0 9.0       54.6               22.0 22                       13 9                 22
260245 SD     school 4679350 12003   Willow Lake 12-3 467935001297 6 Collins Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 22.0                       12.0 10.0       54.6               22.0 22                       12 10                 22
260247 SD     school 4679350 12003   Willow Lake 12-3 467935001137 5 Shamrock Colony   Regular School No Elementary KG 08 2018   k_12_total 13.0                       6.0 7.0       53.9               13.0 13                       6 7                 13
253104 SD     school 4624390 50003   Flandreau 50-3 462439001119 6 Pleasant Valley Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 30.0                       16.0 14.0       53.3               30.0 30                       16 14                 30
254586 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School No Elementary PK 08 2018   k_12_total 15.0                       10.0 5.0       53.3               15.0 15                       10 5                 15
250141 SD     school 4639540 11001   Andes Central 11-1 463954001379 6 Pease Creek Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 26.0                       13.0 13.0       50.0               26.0 26                       13 13                 26
251033 SD     school 4600041 45004   Britton-Hecla 45-4 460004101364 6 Sunset Colony High School   Regular School No High 09 12 2018   k_12_total 10.0                       6.0 4.0       50.0               10.0 10                       6 4                 10
259321 SD     school 4672450 33005   Tripp-Delmont 33-5 467245001091 7 Clearfield Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 10.0                       3.0 7.0       50.0               10.0 10                       3 7                 10
259977 SD     school 4677460 36002   Wessington Springs 36-2 467746000731 5 Spring Valley Elementary   Regular School No Elementary KG 08 2018   k_12_total 40.0                       19.0 21.0       50.0               40.0 40                       19 21                 40
260246 SD     school 4679350 12003   Willow Lake 12-3 467935001067 4 Mayfield Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 16.0                       6.0 10.0       50.0               16.0 16                       6 10                 16
258353 SD     school 4666270 49005   Sioux Falls 49-5 466627001063 3 Roosevelt High School   Regular School No High 09 12 2018   k_12_total 1719.0 188.0 234.0 83.0   68.0       1.0 60.0   1200.0 1153.0       5.9               2353.0 1719 188 234 83   68       1 60   1200 1153                 2353
258343 SD     school 4666270 49005   Sioux Falls 49-5 466627000600 2 Lincoln High School   Regular School No High 09 12 2018   k_12_total 1419.0 224.0 145.0 91.0   54.0       1.0 72.0   1049.0 957.0       5.5               2006.0 1419 224 145 91   54       1 72   1049 957                 2006
250885 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School No Elementary KG 04 2018   k_12_total 391.0 41.0 17.0 2.0   11.0         22.0   239.0 245.0       5.4               484.0 391 41 17 2   11         22   239 245                 484
256957 SD     school 4655710 1001   Plankinton 01-1 465571000927 3 Plankinton Junior High   Regular School No Middle 07 08 2018   k_12_total 27.0   10.0                   19.0 18.0       5.4               37.0 27   10                   19 18                 37
256956 SD     school 4655710 1001   Plankinton 01-1 465571000508 1 Plankinton High School   Regular School No High 09 12 2018   k_12_total 61.0   14.0                   40.0 35.0       5.3               75.0 61   14                   40 35                 75
257696 SD     school 4603932 55005   Sanborn Central 55-5 460393200120 5 Upland Colony   Regular School No Elementary KG 08 2018   k_12_total 25.0                       13.0 12.0       48.0               25.0 25                       13 12                 25
254581 SD     school 4636060 22006   Ipswich Public 22-6 463606001085 5 Deerfield Colony Elem   Regular School No Elementary PK 08 2018   k_12_total 21.0                       12.0 9.0       47.6               21.0 21                       12 9                 21
255898 SD     school 4647100 33002   Menno 33-2 464710000418 4 Maxwell Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 62.0                       28.0 34.0       46.8               62.0 62                       28 34                 62
253722 SD     school 4602640 30001   Hanson 30-1 460264000875 5 Oaklane Colony   Regular School No Elementary KG 08 2018   k_12_total 29.0   1.0                   15.0 15.0       46.7               30.0 29   1                   15 15                 30
254481 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2018   k_12_total 177.0 2.0 162.0 7.0   111.0       1.0 18.0   254.0 224.0       45.8               478.0 177 2 162 7   111       1 18   254 224                 478
259322 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000067 5 Greenwood Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 9.0                       4.0 5.0       44.4               9.0 9                       4 5                 9
252557 SD     school 4634440 22005   Edmunds Central 22-5 463444001385 6 Boulder Colony School   Regular School No Elementary KG 08 2018   k_12_total 7.0                       4.0 3.0       42.9               7.0 7                       4 3                 7
255317 SD     school 4641640 44002   Leola 44-2 464164001069 6 Grassland Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 21.0                       11.0 10.0       42.9               21.0 21                       11 10                 21
257033 SD     school 4680438 11005   Platte-Geddes 11-5 468043801252 14 Cedar Grove Colony School   Regular School No Elementary KG 08 2018   k_12_total 42.0                       15.0 27.0       42.9               42.0 42                       15 27                 42
253030 SD     school 4624030 24004   Faulkton Area 462403001090 5 Brentwood Colony School   Regular School No Elementary KG 08 2018   k_12_total 19.0                       9.0 10.0       42.1               19.0 19                       9 10                 19
258323 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School No Elementary PK 05 2018   k_12_total 152.0 163.0 87.0 14.0   92.0         37.0   279.0 266.0       41.8               545.0 152 163 87 14   92         37   279 266                 545
254485 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2018   k_12_total 190.0 4.0 126.0 7.0   92.0         13.0   245.0 187.0       41.7               432.0 190 4 126 7   92         13   245 187                 432
256789 SD     school 4654300 33003   Parkston 33-3 465430000490 8 New Elm Spring Colony Elem   Regular School No Elementary PK 08 2018   k_12_total 25.0                       10.0 15.0       40.0               25.0 25                       10 15                 25
256790 SD     school 4654300 33003   Parkston 33-3 465430000489 3 Old Elm Spring Colony Elem   Regular School No Elementary PK 08 2018   k_12_total 25.0                       10.0 15.0       40.0               25.0 25                       10 15                 25
249929 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No Elementary KG 05 2018   k_12_total 280.0 7.0 35.0 20.0   13.0       1.0 33.0   199.0 190.0       4.9               389.0 280 7 35 20   13       1 33   199 190                 389
251126 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No Elementary 04 05 2018   k_12_total 464.0 15.0 29.0 12.0   23.0       1.0 32.0   286.0 290.0       4.9               576.0 464 15 29 12   23       1 32   286 290                 576
255489 SD     school 4645450 60003   Marion 60-3 464545000407 2 Marion Elementary School   Regular School No Elementary PK 05 2018   k_12_total 69.0   10.0               5.0   46.0 38.0       4.8               84.0 69   10               5   46 38                 84
256571 SD     school 4665460 65001   Oglala Lakota 65-1 466546000575 4 Red Shirt School   Regular School No Elementary PK 08 2018   k_12_total     2.0 82.0                 43.0 41.0       4.8               84.0     2 82                 43 41                 84
252715 SD     school 4621390 5003   Elkton 05-3 462139000901 3 Elkton Junior High   Regular School No Middle 07 08 2018   k_12_total 56.0   7.0               3.0   37.0 29.0       4.6               66.0 56   7               3   37 29                 66
259978 SD     school 4677460 36002   Wessington Springs 36-2 467746000732 2 Wessington Springs Elem   Regular School No Elementary PK 06 2018   k_12_total 147.0   9.0                   83.0 73.0       4.5               156.0 147   9                   83 73                 156
251637 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School No Elementary PK 04 2018   k_12_total 99.0 1.0 10.0               4.0   63.0 51.0       4.4               114.0 99 1 10               4   63 51                 114
259166 SD     school 4672090 66001   Todd County 66-1 467209000503 8 Klein Elementary   Regular School No Elementary KG 08 2018   k_12_total 5.0   2.0 15.0   1.0             11.0 12.0       4.4               23.0 5   2 15   1             11 12                 23
249932 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2018   k_12_total 255.0 9.0 14.0 21.0   15.0       1.0 23.0   179.0 159.0       4.1               338.0 255 9 14 21   15       1 23   179 159                 338
258901 SD     school 4670140 54006   Summit 54-6 467014000662 2 Summit Elementary   Regular School No Elementary PK 08 2018   k_12_total 70.0 0.0 5.0 16.0             7.0   48.0 50.0       4.1               98.0 70 0 5 16             7   48 50                 98
250014 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No Elementary KG 06 2018   k_12_total 88.0   4.0 3.0           1.0 4.0   52.0 48.0       4.0               100.0 88   4 3           1 4   52 48                 100
255650 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No High 09 12 2018   k_12_total 1.0   1.0 146.0             1.0   80.0 69.0       4.0               149.0 1   1 146             1   80 69                 149
257034 SD     school 4680438 11005   Platte-Geddes 11-5 468043801267 10 Platte Colony School   Regular School No Elementary KG 08 2018   k_12_total 28.0                       15.0 13.0       39.3               28.0 28                       15 13                 28
254217 SD     school 4600046 56006   Hitchcock-Tulare 460004601166 4 Glendale Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 23.0                       12.0 11.0       39.1               23.0 23                       12 11                 23
258327 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School No Elementary PK 05 2018   k_12_total 141.0 161.0 65.0 13.0   44.0       2.0 34.0   218.0 242.0       37.8               460.0 141 161 65 13   44       2 34   218 242                 460
254704 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No Middle 04 08 2018   k_12_total 8.0                       5.0 3.0       37.5               8.0 8                       5 3                 8
252716 SD     school 4621390 5003   Elkton 05-3 462139001078 4 Newdale Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 19.0                       11.0 8.0       36.8               19.0 19                       11 8                 19
254585 SD     school 4636060 22006   Ipswich Public 22-6 463606001086 6 Pembrook Colony Elem   Regular School No Elementary PK 08 2018   k_12_total 19.0                       11.0 8.0       36.8               19.0 19                       11 8                 19
250140 SD     school 4639540 11001   Andes Central 11-1 463954001080 5 Lakeview Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 30.0                       10.0 20.0       36.7               30.0 30                       10 20                 30
255101 SD     school 4641300 40001   Lead-Deadwood 40-1 464130001145 10 Lead-Deadwood Career & Tech Ed   Alternative School No High 09 12 2018   k_12_total 29.0 33.0 5.0 28.0   11.0         9.0   77.0 38.0       36.5               115.0 29 33 5 28   11         9   77 38                 115
251034 SD     school 4600041 45004   Britton-Hecla 45-4 460004101180 5 Westwood Rural Elementary   Regular School No Elementary KG 08 2018   k_12_total 22.0                       13.0 9.0       36.4               22.0 22                       13 9                 22
252262 SD     school 4619170 56002   Doland 56-2 461917001100 4 Hillside Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 26.0                       12.0 14.0       34.6               26.0 26                       12 14                 26
253721 SD     school 4602640 30001   Hanson 30-1 460264000015 4 Millbrook Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 10.0                       6.0 4.0       30.0               10.0 10                       6 4                 10
259173 SD     school 4672090 66001   Todd County 66-1 467209001386 18 Todd County Achievement Middle School   Alternative School No Middle 06 08 2018   k_12_total       26.0                 14.0 12.0       3.9               26.0       26                 14 12                 26

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