Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2018 · 571

grade

  • k_12_total · 571
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
256450 SD     school 4651750 56007   Northwestern Area 56-7 465175000475 1 Northwestern High School   Regular School No High 09 12 2018   k_12_total 75.0     2.0           1.0 1.0   41.0 38.0       0.0               79.0 75     2           1 1   41 38                 79
256498 SD     school 4652770 23003   Oelrichs 23-3 465277000482 1 Oelrichs High School   Regular School No High 09 12 2018   k_12_total 1.0     61.0                 40.0 22.0       3.2               62.0 1     61                 40 22                 62
256569 SD     school 4665460 65001   Oglala Lakota 65-1 466546000573 1 Batesland School   Regular School No Elementary PK 08 2018   k_12_total     0.0 166.0             1.0   79.0 88.0       1.8               167.0     0 166             1   79 88                 167
256650 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701027 1 Oldham-Ramona High School   Regular School No High 09 12 2018   k_12_total 29.0                       21.0 8.0       0.0               29.0 29                       21 8                 29
256706 SD     school 4654270 60004   Parker 60-4 465427000488 1 Parker High School   Regular School No High 09 12 2018   k_12_total 120.0 1.0 6.0 1.0           1.0 3.0   73.0 59.0       3.0               132.0 120 1 6 1           1 3   73 59                 132
256793 SD     school 4654300 33003   Parkston 33-3 465430000492 1 Parkston High School   Regular School No High 09 12 2018   k_12_total 125.0   3.0 3.0             3.0   70.0 64.0       1.5               134.0 125   3 3             3   70 64                 134
256877 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School No High 09 12 2018   k_12_total 560.0 2.0 35.0 90.0   6.0       1.0 33.0   365.0 362.0       0.8               727.0 560 2 35 90   6       1 33   365 362                 727
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
257036 SD     school 4680438 11005   Platte-Geddes 11-5 468043801248 1 Platte-Geddes H.S   Regular School No High 09 12 2018   k_12_total 112.0   3.0 1.0             4.0   59.0 61.0       0.0               120.0 112   3 1             4   59 61                 120
257358 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School No Elementary PK 05 2018   k_12_total 88.0 1.0 45.0 285.0   3.0       2.0 37.0   254.0 207.0       0.9               461.0 88 1 45 285   3       2 37   254 207                 461
257503 SD     school 4660450 56004   Redfield 56-4 466045000552 1 Redfield High School   Regular School No High 09 12 2018   k_12_total 161.0   6.0 1.0                 88.0 80.0       0.0               168.0 161   6 1                 88 80                 168
257566 SD     school 4663360 54004   Rosholt 54-4 466336000557 1 Rosholt High School   Regular School No High 09 12 2018   k_12_total 59.0     7.0             3.0   40.0 29.0       0.0               69.0 59     7             3   40 29                 69
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
257694 SD     school 4603932 55005   Sanborn Central 55-5 460393200099 1 Sanborn Central High School   Regular School No High 09 12 2018   k_12_total 34.0   1.0 1.0             1.0   20.0 17.0       0.0               37.0 34   1 1             1   20 17                 37
257746 SD     school 4665180 4003   Scotland 04-3 466518000569 1 Scotland High School   Regular School No High 09 12 2018   k_12_total 75.0   1.0               1.0   37.0 40.0       0.0               77.0 75   1               1   37 40                 77
257794 SD     school 4601028 62005   Selby Area 62-5 460102801028 1 Selby Hi Sch   Regular School No High 09 12 2018   k_12_total 53.0 1.0 1.0 4.0             1.0   36.0 24.0       0.0               60.0 53 1 1 4             1   36 24                 60
258362 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School No High 09 12 2018   k_12_total 1111.0 333.0 224.0 66.0   143.0       1.0 61.0   997.0 942.0       14.7               1939.0 1111 333 224 66   143       1 61   997 942                 1939
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
258577 SD     school 4600053 54002   Sisseton 54-2 460005301239 1 Sisseton High School   Regular School No High 09 12 2018   k_12_total 96.0 3.0 10.0 99.0   1.0         10.0   126.0 93.0       0.9               219.0 96 3 10 99   1         10   126 93                 219
258626 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No High 09 12 2018   k_12_total       58.0                 32.0 26.0       10.3               58.0       58                 32 26                 58
258674 SD     school 4607670 26005   South Central 26-5 460767000880 1 South Central High School   Regular School No High 09 12 2018   k_12_total 13.0 1.0   9.0             1.0   16.0 8.0       0.0               24.0 13 1   9             1   16 8                 24
258786 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School No High 09 12 2018   k_12_total 561.0 4.0 27.0 13.0   10.0         11.0   312.0 314.0       0.2               626.0 561 4 27 13   10         11   312 314                 626
258863 SD     school 4624850 57001   Stanley County 57-1 462485000217 1 Stanley County High School   Regular School No High 09 12 2018   k_12_total 114.0   2.0 25.0             5.0   86.0 60.0       0.0               146.0 114   2 25             5   86 60                 146
258902 SD     school 4670140 54006   Summit 54-6 467014000663 1 Summit High School   Regular School No High 09 12 2018   k_12_total 39.0 1.0 2.0 6.0             3.0   25.0 26.0       2.0               51.0 39 1 2 6             3   25 26                 51
258959 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School No Elementary KG 04 2018   k_12_total 652.0 7.0 19.0 8.0   1.0         23.0   378.0 332.0       1.4               710.0 652 7 19 8   1         23   378 332                 710
259010 SD     school 4671880 20003   Timber Lake 20-3 467188000665 1 Timber Lake High School 9-12   Regular School No High 09 12 2018   k_12_total 34.0   3.0 60.0                 44.0 53.0       0.0               97.0 34   3 60                 44 53                 97
259175 SD     school 4672090 66001   Todd County 66-1 467209000678 1 Todd County HS   Regular School No High 09 12 2018   k_12_total 4.0   2.0 449.0   1.0         2.0   242.0 216.0       2.2               458.0 4   2 449   1         2   242 216                 458
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
259324 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000050 1 Tripp-Delmont High School   Regular School No High 09 12 2018   k_12_total 31.0     3.0                 18.0 16.0       0.0               34.0 31     3                 18 16                 34
259391 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2018   k_12_total 303.0 8.0 19.0 39.0   5.0       2.0 2.0   174.0 204.0       0.3               378.0 303 8 19 39   5       2 2   174 204                 378
259455 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000693 1 Viborg-Hurley High School   Regular School No High 09 12 2018   k_12_total 104.0 1.0 3.0 2.0                 68.0 42.0       1.8               110.0 104 1 3 2                 68 42                 110
259518 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School No High 09 12 2018   k_12_total 62.0   7.0 99.0             14.0   83.0 99.0       0.0               182.0 62   7 99             14   83 99                 182
259583 SD     school 4675660 51005   Wall 51-5 467566000705 1 Wall High School   Regular School No High 09 12 2018   k_12_total 58.0     15.0                 36.0 37.0       0.0               73.0 58     15                 36 37                 73
259634 SD     school 4676020 6005   Warner 06-5 467602000709 1 Warner Hi Sch   Regular School No High 09 12 2018   k_12_total 86.0 2.0 1.0 4.0   1.0             49.0 45.0       1.1               94.0 86 2 1 4   1             49 45                 94
259746 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2018   k_12_total 1086.0 8.0 38.0 45.0   10.0       1.0 23.0   619.0 592.0       0.5               1211.0 1086 8 38 45   10       1 23   619 592                 1211
259810 SD     school 4676680 18003   Waubay 18-3 467668000720 1 Waubay Hi Sch   Regular School No High 09 12 2018   k_12_total 19.0   3.0 25.0                 25.0 22.0       2.1               47.0 19   3 25                 25 22                 47
259858 SD     school 4676740 14005   Waverly 14-5 467674000722 1 Waverly/South Shore High School   Regular School No High 09 12 2018   k_12_total 68.0   3.0 3.0             2.0   34.0 42.0       0.0               76.0 68   3 3             2   34 42                 76
259906 SD     school 4676990 18005   Webster Area 467699000724 1 Webster Area High School   Regular School No High 09 12 2018   k_12_total 140.0   3.0 1.0             2.0   77.0 69.0       0.0               146.0 140   3 1             2   77 69                 146
259979 SD     school 4677460 36002   Wessington Springs 36-2 467746000733 1 Wessington Springs Hi Sch   Regular School No High 09 12 2018   k_12_total 71.0   2.0                   38.0 35.0       0.0               73.0 71   2                   38 35                 73
260046 SD     school 4631710 49007   West Central 49-7 463171000274 1 West Central Hi Sch   Regular School No High 09 12 2018   k_12_total 386.0 5.0 2.0 3.0             6.0   192.0 210.0       0.5               402.0 386 5 2 3             6   192 210                 402
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
260159 SD     school 4678570 47001   White River 47-1 467857000754 1 White River High School   Regular School No High 09 12 2018   k_12_total 14.0 1.0 2.0 80.0   1.0       1.0 4.0   54.0 49.0       0.0               103.0 14 1 2 80   1       1 4   54 49                 103
260249 SD     school 4679350 12003   Willow Lake 12-3 467935000756 1 Willow Lake Hi Sch   Regular School No High 09 12 2018   k_12_total 49.0   3.0 1.0                 29.0 24.0       0.0               53.0 49   3 1                 29 24                 53
260306 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No High 09 12 2018   k_12_total 49.0   3.0 17.0             3.0   33.0 39.0       0.0               72.0 49   3 17             3   33 39                 72
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
260402 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School No High 09 12 2018   k_12_total 93.0 5.0 7.0 2.0             2.0   65.0 44.0       0.9               109.0 93 5 7 2             2   65 44                 109
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
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
249927 SD     school 4602070 6001   Aberdeen 06-1 460207000005 2 Holgate Middle School   Regular School No Middle 06 08 2018   k_12_total 425.0 12.0 25.0 24.0   16.0         20.0   263.0 259.0       1.5               522.0 425 12 25 24   16         20   263 259                 522
250137 SD     school 4639540 11001   Andes Central 11-1 463954000359 2 Andes Central Elementary   Regular School No Elementary PK 06 2018   k_12_total 34.0   8.0 93.0             21.0   72.0 84.0       0.0               156.0 34   8 93             21   72 84                 156
250205 SD     school 4603720 38001   Arlington 38-1 460372000021 2 Arlington Elementary   Regular School No Elementary PK 06 2018   k_12_total 137.0 2.0 10.0     1.0             67.0 83.0       0.0               150.0 137 2 10     1             67 83                 150
250257 SD     school 4603780 21001   Armour 21-1 460378000023 2 Armour Elementary   Regular School No Elementary KG 05 2018   k_12_total 63.0 5.0 1.0 1.0             2.0   46.0 26.0       0.0               72.0 63 5 1 1             2   46 26                 72
250317 SD     school 4604270 4001   Avon 04-1 460427000028 2 Avon Elementary School   Regular School No Elementary KG 06 2018   k_12_total 104.0   5.0 5.0             5.0   59.0 60.0       0.0               119.0 104   5 5             5   59 60                 119
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
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
250625 SD     school 4607050 52001   Bison 52-1 460705000054 2 Bison Elementary   Regular School No Elementary KG 06 2018   k_12_total 74.0   3.0 1.0   3.0         2.0   38.0 45.0       0.0               83.0 74   3 1   3         2   38 45                 83
250722 SD     school 4607400 4002   Bon Homme 04-2 460740000987 2 Bon Homme Middle School   Regular School No Middle 06 08 2018   k_12_total 92.0   1.0 1.0             4.0   58.0 40.0       0.0               98.0 92   1 1             4   58 40                 98
250785 SD     school 4607800 22001   Bowdle 22-1 460780000068 2 Bowdle Elementary   Regular School No Elementary PK 06 2018   k_12_total 55.0   1.0               1.0   30.0 27.0       0.0               57.0 55   1               1   30 27                 57
250884 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2018   k_12_total 572.0 20.0 14.0 4.0   9.0       2.0 11.0   334.0 298.0       0.3               632.0 572 20 14 4   9       2 11   334 298                 632
250945 SD     school 4621420 30003   Bridgewater-Emery 30-3 462142010071 2 Bridgewater-Emery Elementary   Regular School No Elementary PK 05 2018   k_12_total 135.0 3.0 14.0                   89.0 63.0       2.6               152.0 135 3 14                   89 63                 152
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
251128 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No Middle 06 08 2018   k_12_total 644.0 18.0 38.0 17.0   34.0       1.0 44.0   408.0 388.0       2.0               796.0 644 18 38 17   34       1 44   408 388                 796
251185 SD     school 4609512 26002   Burke 26-2 460951200100 2 Burke Elementary School   Regular School No Elementary PK 06 2018   k_12_total 111.0     13.0                 66.0 58.0       0.0               124.0 111     13                 66 58                 124
251233 SD     school 4610320 43001   Canistota 43-1 461032000104 2 Canistota Elementary School   Regular School No Elementary PK 05 2018   k_12_total 94.0 4.0 5.0                   57.0 46.0       0.0               103.0 94 4 5                   57 46                 103
251283 SD     school 4610560 41001   Canton 41-1 461056000108 2 Lawrence Elementary   Regular School No Elementary KG 05 2018   k_12_total 370.0 2.0 5.0 4.0   2.0         13.0   208.0 188.0       0.3               396.0 370 2 5 4   2         13   208 188                 396
251341 SD     school 4611280 28001   Castlewood 28-1 461128000113 2 Castlewood Elementary   Regular School No Elementary PK 06 2018   k_12_total 134.0   10.0 1.0             3.0   71.0 77.0       1.4               148.0 134   10 1             3   71 77                 148
251393 SD     school 4611760 60001   Centerville 60-1 461176000115 2 Centerville Elem   Regular School No Elementary PK 05 2018   k_12_total 132.0 2.0 11.0 1.0                 79.0 67.0       2.1               146.0 132 2 11 1                 79 67                 146
251443 SD     school 4612000 7001   Chamberlain 07-1 461200000889 2 Chamberlain Jr. High   Regular School No Middle 07 08 2018   k_12_total 73.0   5.0 38.0   1.0         5.0   55.0 67.0       0.0               122.0 73   5 38   1         5   55 67                 122
251538 SD     school 4612300 39001   Chester Area 39-1 461230000131 2 Chester Area Elementary School   Regular School No Elementary PK 05 2018   k_12_total 142.0   0.0 3.0             1.0   70.0 76.0       0.0               146.0 142   0 3             1   70 76                 146
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
251699 SD     school 4614100 50005   Colman-Egan 50-5 461410000092 2 Colman-Egan Jr Hi   Regular School No Middle 07 08 2018   k_12_total 37.0     2.0                 22.0 17.0       0.0               39.0 37     2                 22 17                 39
251757 SD     school 4614130 59003   Colome Consolidated 461413000140 2 Colome Elementary School   Regular School No Elementary PK 05 2018   k_12_total 63.0   1.0 16.0   2.0         3.0   35.0 50.0       0.0               85.0 63   1 16   2         3   35 50                 85
251809 SD     school 4680445 21003   Corsica-Stickney 21-3 468044501354 2 Corsica-Stickney Elementary   Regular School No Elementary PK 06 2018   k_12_total 133.0   2.0     1.0             71.0 65.0       0.0               136.0 133   2     1             71 65                 136
251869 SD     school 4616950 16001   Custer 16-1 461695000154 2 Custer Elementary   Regular School No Elementary PK 06 2018   k_12_total 288.0 1.0 29.0 16.0   2.0         7.0   173.0 170.0       1.2               343.0 288 1 29 16   2         7   173 170                 343
251933 SD     school 4636990 61008   Dakota Valley 61-8 463699000251 2 Dakota Valley Elementary School   Regular School No Elementary KG 03 2018   k_12_total 332.0 3.0 27.0 1.0   15.0         18.0   204.0 192.0       1.0               396.0 332 3 27 1   15         18   204 192                 396
251987 SD     school 4617850 38002   De Smet 38-2 461785000162 2 Laura Ingalls Wilder Elem   Regular School No Elementary PK 05 2018   k_12_total 144.0 4.0   3.0             1.0   84.0 68.0       0.7               152.0 144 4   3             1   84 68                 152
252033 SD     school 4618120 49003   Dell Rapids 49-3 461812000164 2 Dell Rapids Elementary   Regular School No Elementary KG 04 2018   k_12_total 341.0 1.0 11.0 9.0             10.0   198.0 174.0       1.1               372.0 341 1 11 9             10   198 174                 372
252107 SD     school 4678300 5006   Deubrook Area 05-6 467830000016 2 Deubrook Jr High   Regular School No Middle 07 08 2018   k_12_total 63.0 1.0 1.0 1.0   1.0             34.0 33.0       0.0               67.0 63 1 1 1   1             34 33                 67
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
252261 SD     school 4619170 56002   Doland 56-2 461917000895 2 Doland Junior High   Regular School No Middle 07 08 2018   k_12_total 12.0 1.0                     7.0 6.0       0.0               13.0 12 1                     7 6                 13
252349 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No Elementary 04 05 2018   k_12_total 346.0 16.0 39.0 31.0   4.0       1.0 43.0   231.0 249.0       0.0               480.0 346 16 39 31   4       1 43   231 249                 480
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
252463 SD     school 4620100 20001   Eagle Butte 20-1 462010000897 2 C-EB Primary   Regular School No Elementary KG 02 2018   k_12_total 2.0     105.0   1.0       1.0     57.0 52.0       0.0               109.0 2     105   1       1     57 52                 109
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
252641 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000185 2 Elk Point Jefferson Elementary   Regular School No Elementary KG 05 2018   k_12_total 303.0   17.0 1.0   1.0         11.0   168.0 165.0       1.2               333.0 303   17 1   1         11   168 165                 333
252713 SD     school 4621390 5003   Elkton 05-3 462139000187 2 Elkton Elementary School   Regular School No Elementary PK 06 2018   k_12_total 122.0   38.0               8.0   85.0 83.0       11.9               168.0 122   38               8   85 83                 168
252769 SD     school 4622410 28002   Estelline 28-2 462241000191 2 Estelline Elementary School   Regular School No Elementary PK 06 2018   k_12_total 144.0   12.0               3.0   88.0 71.0       0.6               159.0 144   12               3   88 71                 159
252817 SD     school 4622500 17001   Ethan 17-1 462250000193 2 Ethan Elementary   Regular School No Elementary PK 06 2018   k_12_total 122.0   3.0 2.0             3.0   60.0 70.0       0.8               130.0 122   3 2             3   60 70                 130
252865 SD     school 4622560 44001   Eureka 44-1 462256000195 2 Eureka Elementary School   Regular School No Elementary PK 05 2018   k_12_total 66.0                       33.0 33.0       0.0               66.0 66                       33 33                 66
252937 SD     school 4622940 46002   Faith 46-2 462294000805 2 Faith Elementary School   Regular School No Elementary KG 06 2018   k_12_total 57.0   1.0 5.0   1.0             35.0 29.0       0.0               64.0 57   1 5   1             35 29                 64
253031 SD     school 4624030 24004   Faulkton Area 462403000202 2 Faulkton Elem   Regular School No Elementary PK 06 2018   k_12_total 123.0 1.0 2.0 3.0             2.0   66.0 65.0       0.0               131.0 123 1 2 3             2   66 65                 131
253153 SD     school 4624540 14001   Florence 14-1 462454000208 2 Florence Elementary School   Regular School No Elementary PK 05 2018   k_12_total 127.0     2.0             1.0   64.0 66.0       0.0               130.0 127     2             1   64 66                 130
253201 SD     school 4621400 6002   Frederick Area 06-2 462140000189 2 Frederick Elementary   Regular School No Elementary KG 06 2018   k_12_total 80.0     2.0             6.0   44.0 44.0       0.0               88.0 80     2             6   44 44                 88
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
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
253377 SD     school 4626490 63001   Gayville-Volin 63-1 462649000228 2 Gayville-Volin Elementary   Regular School No Elementary PK 06 2018   k_12_total 134.0   8.0     0.0         3.0   78.0 67.0       0.0               145.0 134   8     0         3   78 67                 145
253425 SD     school 4626970 53001   Gettysburg 53-1 462697000231 2 Gettysburg Elem   Regular School No Elementary KG 06 2018   k_12_total 108.0   4.0 3.0             4.0   64.0 55.0       0.8               119.0 108   4 3             4   64 55                 119
253473 SD     school 4629880 26004   Gregory 26-4 462988000238 2 Gregory Elementary School   Regular School No Elementary KG 05 2018   k_12_total 143.0 1.0 4.0 24.0   4.0       1.0 7.0   92.0 92.0       0.0               184.0 143 1 4 24   4       1 7   92 92                 184
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
253582 SD     school 4630490 27001   Haakon 27-1 463049000255 2 Philip Elementary School   Regular School No Elementary KG 06 2018   k_12_total 130.0   4.0 1.0   1.0         9.0   75.0 70.0       0.0               145.0 130   4 1   1         9   75 70                 145

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