Data source: Big Local News · About: Big Local

671 rows where grade = "k_12_total", state = "SD" and year = 2018 sorted by female

View and edit SQL

year

  • 2018 · 671

grade

  • k_12_total · 671
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
250208 SD     school 4603720 38001   Arlington 38-1 460372001381 4 Arlington PreSchool   Regular School No Prekindergarten PK PK 2018   k_12_total 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
250320 SD     school 4604270 4001   Avon 04-1 460427001325 6 Avon PK   Regular School No Prekindergarten PK PK 2018   k_12_total 0.0                   0.0   0.0 0.0                       0.0 0                   0   0 0                 0
250723 SD     school 4607400 4002   Bon Homme 04-2 460740001328 8 Bon Homme PK   Regular School No Prekindergarten PK PK 2018   k_12_total 0.0                       0.0 0.0                       0.0 0                       0 0                 0
252347 SD     school 4619410 51001   Douglas 51-1 461941001125 8 Douglas Preschool   Regular School No Prekindergarten PK PK 2018   k_12_total 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
252940 SD     school 4622940 46002   Faith 46-2 462294001306 10 Faith PreSchool   Regular School No Prekindergarten PK PK 2018   k_12_total 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
257361 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No Other PK 12 2018   k_12_total 0.0                       0.0 0.0                       0.0 0                       0 0                 0
252598 SD     school 4621300 16002   Elk Mountain 16-2 462130001371 4 Elk Mountain High School   Regular School No High 09 12 2018   k_12_total 2.0                       1.0 1.0       0.0               2.0 2                       1 1                 2
258325 SD     school 4666270 49005   Sioux Falls 49-5 466627001305 37 Career and Technical Education Academy   Career and Technical School No High 09 12 2018   k_12_total 3.0                       2.0 1.0       0.0               3.0 3                       2 1                 3
258357 SD     school 4666270 49005   Sioux Falls 49-5 466627001121 39 Success Academy   Special Education School No High 06 12 2018   k_12_total 12.0 4.0 1.0                   16.0 1.0       0.0               17.0 12 4 1                   16 1                 17
252258 SD     school 4619170 56002   Doland 56-2 461917001101 5 Clark Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 14.0                       4.0 10.0       28.6               14.0 14                       4 10                 14
252260 SD     school 4619170 56002   Doland 56-2 461917000171 1 Doland High School   Regular School No High 09 12 2018   k_12_total 26.0                       16.0 10.0       0.0               26.0 26                       16 10                 26
252560 SD     school 4634440 22005   Edmunds Central 22-5 463444000032 2 Edmunds Central Middle School   Regular School No Middle 07 08 2018   k_12_total 16.0   2.0 1.0                 9.0 10.0       0.0               19.0 16   2 1                 9 10                 19
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
254323 SD     school 4634600 53002   Hoven 53-2 463460000912 3 Hoven Jr High School   Regular School No Middle 07 08 2018   k_12_total 18.0                       8.0 10.0       0.0               18.0 18                       8 10                 18
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
255797 SD     school 4669930 46001   Meade 46-1 466993000741 15 Opal Elementary   Regular School No Elementary KG 08 2018   k_12_total 17.0                       7.0 10.0       0.0               17.0 17                       7 10                 17
257363 SD     school 4659820 51004   Rapid City Area 51-4 465982001341 44 Lincoln Building   Special Education School No High 12 12 2018   k_12_total 21.0   3.0 5.0   2.0         2.0   23.0 10.0       3.0               33.0 21   3 5   2         2   23 10                 33
257632 SD     school 4664140 39004   Rutland 39-4 466414000932 3 Rutland Jr Hi   Regular School No Middle 06 08 2018   k_12_total 28.0                   1.0   19.0 10.0       0.0               29.0 28                   1   19 10                 29
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
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
260354 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No High 09 12 2018   k_12_total 147.0 3.0 1.0 45.0   2.0       1.0     99.0 100.0       0.5               199.0 147 3 1 45   2       1     99 100                 199
252642 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000186 1 Elk Point Jefferson High School   Regular School No High 09 12 2018   k_12_total 190.0 3.0 7.0     1.0       2.0 2.0   104.0 101.0       0.0               205.0 190 3 7     1       2 2   104 101                 205
255955 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No Middle 06 08 2018   k_12_total 192.0   16.0 2.0             3.0   111.0 102.0       1.9               213.0 192   16 2             3   111 102                 213
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
255103 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000374 1 Lead-Deadwood High School   Regular School No High 09 12 2018   k_12_total 184.0 1.0 13.0 4.0   4.0         6.0   107.0 105.0       1.9               212.0 184 1 13 4   4         6   107 105                 212
251872 SD     school 4616950 16001   Custer 16-1 461695000159 4 Hermosa Elem   Regular School No Elementary KG 08 2018   k_12_total 166.0   8.0 13.0           1.0 16.0   98.0 106.0       0.0               204.0 166   8 13           1 16   98 106                 204
259250 SD     school 4644940 49006   Tri-Valley 49-6 464494000405 1 Tri-Valley High School   Regular School No High 09 12 2018   k_12_total 226.0 14.0 7.0 1.0   1.0         5.0   148.0 106.0       3.2               254.0 226 14 7 1   1         5   148 106                 254
250369 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School No Elementary PK 05 2018   k_12_total 202.0   9.0 2.0   2.0         5.0   113.0 107.0       0.5               220.0 202   9 2   2         5   113 107                 220
253329 SD     school 4626370 49004   Garretson 49-4 462637000223 2 Garretson Elementary   Regular School No Elementary PK 05 2018   k_12_total 182.0   7.0 5.0   1.0         9.0   95.0 109.0       0.0               204.0 182   7 5   1         9   95 109                 204
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
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
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
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
259325 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000059 2 Tripp-Delmont JH   Regular School No Middle 07 08 2018   k_12_total 20.0     1.0   1.0             11.0 11.0       0.0               22.0 20     1   1             11 11                 22
251936 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School No Elementary 04 05 2018   k_12_total 180.0 2.0 14.0 1.0   3.0         13.0   103.0 110.0       1.9               213.0 180 2 14 1   3         13   103 110                 213
252161 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No Elementary PK 05 2018   k_12_total 220.0 2.0 16.0 5.0           1.0     134.0 110.0       1.2               244.0 220 2 16 5           1     134 110                 244
251029 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School No Elementary KG 06 2018   k_12_total 191.0 4.0 8.0 2.0   1.0         8.0   103.0 111.0       0.0               214.0 191 4 8 2   1         8   103 111                 214
258530 SD     school 4666300 5005   Sioux Valley 05-5 466630000612 1 Sioux Valley High School   Regular School No High 09 12 2018   k_12_total 185.0   9.0 2.0   3.0         3.0   91.0 111.0       2.0               202.0 185   9 2   3         3   91 111                 202
250546 SD     school 4606360 61002   Beresford 61-2 460636000048 1 Beresford High School   Regular School No High 09 12 2018   k_12_total 199.0 2.0 8.0     4.0         5.0   106.0 112.0       0.0               218.0 199 2 8     4         5   106 112                 218
252401 SD     school 4619450 64002   Dupree 64-2 461945000799 2 Dupree Elem   Regular School No Elementary PK 06 2018   k_12_total 32.0   5.0 182.0             1.0   108.0 112.0       0.0               220.0 32   5 182             1   108 112                 220
256792 SD     school 4654300 33003   Parkston 33-3 465430000491 2 Parkston Elementary   Regular School No Elementary PK 06 2018   k_12_total 218.0   6.0 2.0   2.0         7.0   122.0 113.0       0.0               235.0 218   6 2   2         7   122 113                 235
252464 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No Elementary 03 06 2018   k_12_total 2.0     226.0   1.0             115.0 114.0       0.0               229.0 2     226   1             115 114                 229
259743 SD     school 4676620 14004   Watertown 14-4 467662000713 6 McKinley Elementary School   Regular School No Elementary PK 04 2018   k_12_total 168.0   17.0 22.0             14.0   107.0 114.0       0.0               221.0 168   17 22             14   107 114                 221
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
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
253521 SD     school 4600045 6006   Groton Area 460004501156 2 Groton Area Elementary School   Regular School No Elementary PK 05 2018   k_12_total 267.0   2.0 3.0   2.0         1.0   157.0 118.0       1.1               275.0 267   2 3   2         1   157 118                 275
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
253034 SD     school 4624030 24004   Faulkton Area 462403001160 10 Thunderbird Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 23.0                       11.0 12.0       17.4               23.0 23                       11 12                 23
254979 SD     school 4639990 38003   Lake Preston 38-3 463999000918 3 Lake Preston Jr High   Regular School No Middle 07 08 2018   k_12_total 24.0 1.0                 2.0   15.0 12.0       0.0               27.0 24 1                 2   15 12                 27
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
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
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
258328 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School No High 12 12 2018   k_12_total 21.0 4.0 1.0 2.0   2.0             18.0 12.0       3.3               30.0 21 4 1 2   2             18 12                 30
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
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
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
260045 SD     school 4631710 49007   West Central 49-7 463171000777 5 West Central Hartford Elem   Regular School No Elementary KG 02 2018   k_12_total 229.0 2.0 7.0 2.0             7.0   127.0 120.0       0.4               247.0 229 2 7 2             7   127 120                 247
256705 SD     school 4654270 60004   Parker 60-4 465427000487 2 Parker Elementary School   Regular School No Elementary PK 06 2018   k_12_total 216.0 1.0 8.0 2.0             14.0   120.0 121.0       3.3               241.0 216 1 8 2             14   120 121                 241
259744 SD     school 4676620 14004   Watertown 14-4 467662000714 7 Mellette Elementary School   Regular School No Elementary KG 04 2018   k_12_total 212.0 1.0 3.0 14.0   1.0         7.0   117.0 121.0       0.4               238.0 212 1 3 14   1         7   117 121                 238
251870 SD     school 4616950 16001   Custer 16-1 461695000155 1 Custer High School   Regular School No High 09 12 2018   k_12_total 214.0 2.0 12.0 7.0           1.0 4.0   115.0 125.0       0.8               240.0 214 2 12 7           1 4   115 125                 240
255226 SD     school 4641550 41004   Lennox 41-4 464155000387 1 Lennox High School   Regular School No High 09 12 2018   k_12_total 254.0 1.0 9.0 4.0   1.0         8.0   152.0 125.0       0.0               277.0 254 1 9 4   1         8   152 125                 277
251442 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School No High 09 12 2018   k_12_total 134.0 3.0 13.0 98.0   3.0         4.0   129.0 126.0       0.4               255.0 134 3 13 98   3         4   129 126                 255
257035 SD     school 4680438 11005   Platte-Geddes 11-5 468043801244 2 Platte-Geddes Elem   Regular School No Elementary KG 06 2018   k_12_total 211.0 1.0 3.0 13.0             19.0   119.0 128.0       0.0               247.0 211 1 3 13             19   119 128                 247
254274 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School No High 09 12 2018   k_12_total 200.0 6.0 12.0 23.0   2.0       1.0 15.0   130.0 129.0       0.4               259.0 200 6 12 23   2       1 15   130 129                 259
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
250582 SD     school 4606960 25001   Big Stone City 25-1 460696000352 3 Big Stone MS   Regular School No Middle 06 08 2018   k_12_total 28.0 1.0                     16.0 13.0       0.0               29.0 28 1                     16 13                 29
254220 SD     school 4600046 56006   Hitchcock-Tulare 460004601164 2 Hitchcock-Tulare JH   Regular School No Middle 07 08 2018   k_12_total 31.0     1.0                 19.0 13.0       3.1               32.0 31     1                 19 13                 32
256651 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701035 3 Oldham-Ramona Junior High School   Regular School No Middle 07 08 2018   k_12_total 22.0                   1.0   10.0 13.0       0.0               23.0 22                   1   10 13                 23
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
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
252034 SD     school 4618120 49003   Dell Rapids 49-3 461812000165 1 Dell Rapids High School   Regular School No High 09 12 2018   k_12_total 259.0 2.0 3.0 10.0   1.0         4.0   148.0 131.0       0.4               279.0 259 2 3 10   1         4   148 131                 279
259519 SD     school 4675420 11004   Wagner Community 11-4 467542000942 3 Wagner Middle School   Regular School No Middle 05 08 2018   k_12_total 64.0   9.0 159.0   1.0         26.0   128.0 131.0       0.0               259.0 64   9 159   1         26   128 131                 259
259905 SD     school 4676990 18005   Webster Area 467699000723 3 Webster Area Elementary School   Regular School No Elementary PK 05 2018   k_12_total 233.0   8.0 6.0   1.0       1.0 12.0   130.0 131.0       0.4               261.0 233   8 6   1       1 12   130 131                 261
251281 SD     school 4610560 41001   Canton 41-1 461056000109 1 Canton High School   Regular School No High 09 12 2018   k_12_total 248.0   5.0 4.0   7.0         3.0   135.0 132.0       1.5               267.0 248   5 4   7         3   135 132                 267
256013 SD     school 4647942 29004   Miller 464794200429 2 Miller Elementary School   Regular School No Elementary KG 06 2018   k_12_total 269.0 1.0 5.0 2.0           4.0 1.0   147.0 135.0       0.4               282.0 269 1 5 2           4 1   147 135                 282
259170 SD     school 4672090 66001   Todd County 66-1 467209000675 4 Rosebud Elementary   Regular School No Elementary KG 05 2018   k_12_total     4.0 271.0             1.0   141.0 135.0       0.7               276.0     4 271             1   141 135                 276
252035 SD     school 4618120 49003   Dell Rapids 49-3 461812000837 3 Dell Rapids Middle School   Regular School No Middle 05 08 2018   k_12_total 265.0   6.0 3.0             8.0   146.0 136.0       0.4               282.0 265   6 3             8   146 136                 282
260519 SD     school 4680430 63003   Yankton 63-3 468043000795 5 Stewart Elem   Regular School No Elementary KG 05 2018   k_12_total 228.0 5.0 19.0 9.0   6.0         6.0   137.0 136.0       1.5               273.0 228 5 19 9   6         6   137 136                 273
257370 SD     school 4659820 51004   Rapid City Area 51-4 465982000527 15 South Canyon Elem   Regular School No Elementary KG 05 2018   k_12_total 213.0 3.0 23.0 32.0   1.0       1.0 12.0   146.0 139.0       0.4               285.0 213 3 23 32   1       1 12   146 139                 285
250627 SD     school 4607050 52001   Bison 52-1 460705000879 4 Bison JH   Regular School No Middle 07 08 2018   k_12_total 20.0   2.0 3.0                 11.0 14.0       0.0               25.0 20   2 3                 11 14                 25
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
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
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
254099 SD     school 4680440 34002   Highmore-Harrold 468044001049 3 Highmore-Harrold Junior High   Regular School No Middle 07 08 2018   k_12_total 35.0     1.0             5.0   27.0 14.0       0.0               41.0 35     1             5   27 14                 41
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
257631 SD     school 4664140 39004   Rutland 39-4 466414000563 1 Rutland Hi Sch   Regular School No High 09 12 2018   k_12_total 32.0     1.0                 19.0 14.0       0.0               33.0 32     1                 19 14                 33
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
259980 SD     school 4677460 36002   Wessington Springs 36-2 467746001374 92 Wessington Springs High School Cyber Sch   Regular School No High 09 12 2018   k_12_total 22.0   1.0 2.0                 11.0 14.0       0.0               25.0 22   1 2                 11 14                 25
260098 SD     school 4678510 1003   White Lake 01-3 467851000746 1 White Lake High School   Regular School No High 09 12 2018   k_12_total 28.0   4.0                   18.0 14.0       0.0               32.0 28   4                   18 14                 32
260307 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School No Middle 07 08 2018   k_12_total 22.0     8.0                 16.0 14.0       0.0               30.0 22     8                 16 14                 30
250499 SD     school 4606240 3001   Bennett County 03-1 460624000045 3 Martin Elem   Regular School No Elementary PK 06 2018   k_12_total 53.0   16.0 131.0             65.0   125.0 140.0       0.0               265.0 53   16 131             65   125 140                 265
255443 SD     school 4639600 39002   Madison Central 39-2 463960000364 2 Madison Middle School   Regular School No Middle 06 08 2018   k_12_total 243.0 1.0 16.0 4.0   3.0         10.0   135.0 142.0       0.7               277.0 243 1 16 4   3         10   135 142                 277
257372 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   Regular School No Elementary KG 05 2018   k_12_total 117.0 1.0 36.0 110.0   3.0         36.0   161.0 142.0       0.3               303.0 117 1 36 110   3         36   161 142                 303
259392 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No Middle 06 08 2018   k_12_total 220.0 4.0 13.0 31.0   8.0         12.0   146.0 142.0       1.0               288.0 220 4 13 31   8         12   146 142                 288
250545 SD     school 4606360 61002   Beresford 61-2 460636000047 2 Beresford Elementary   Regular School No Elementary KG 05 2018   k_12_total 269.0 2.0 8.0 1.0   1.0         2.0   138.0 145.0       0.0               283.0 269 2 8 1   1         2   138 145                 283
259517 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School No Elementary 01 04 2018   k_12_total 77.0   15.0 179.0             37.0   163.0 145.0       0.3               308.0 77   15 179             37   163 145                 308
257502 SD     school 4660450 56004   Redfield 56-4 466045000551 3 Redfield Elementary School   Regular School No Elementary PK 06 2018   k_12_total 283.0 7.0 8.0 7.0   1.0             160.0 146.0       0.0               306.0 283 7 8 7   1             160 146                 306
260048 SD     school 4631710 49007   West Central 49-7 463171000909 4 West Central MS   Regular School No Middle 06 08 2018   k_12_total 296.0 4.0 4.0 9.0   1.0         7.0   172.0 149.0       0.3               321.0 296 4 4 9   1         7   172 149                 321
250013 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No Elementary KG 05 2018   k_12_total 21.0   6.0 7.0             1.0   20.0 15.0       11.4               35.0 21   6 7             1   20 15                 35
251187 SD     school 4609512 26002   Burke 26-2 460951201043 4 Burke JH   Regular School No Middle 07 08 2018   k_12_total 32.0 1.0 2.0 1.0                 21.0 15.0       0.0               36.0 32 1 2 1                 21 15                 36

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