Data source: Big Local News · About: Big Local

10,752 rows where state = "SD" and year = 2019 sorted by white descending

View and edit SQL

year

  • 2019 · 10,752
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
360012 SD     school 4622410 28002   Estelline 28-2 462241000191 2 Estelline Elementary School   Regular School No Elementary PK 05 2019   k_12_total 99.0   11.0               4.0   62.0 52.0       2.6               114.0 99   11               4   62 52                 114
361143 SD     school 4631350 41002   Harrisburg 41-2 463135000847 3 Harrisburg South MS   Regular School No Middle 06 08 2019   grade_8 99.0 3.0 2.0     0.0         3.0   48.0 59.0                       107.0 99 3 2     0         3   48 59                 107
361330 SD     school 4680440 34002   Highmore-Harrold 468044000323 2 Highmore Elementary   Regular School No Elementary PK 06 2019   pk_12_total 99.0   2.0 19.0             3.0   60.0 63.0                       123.0 99   2 19             3   60 63                 123
362990 SD     school 4669930 46001   Meade 46-1 466993001392 10 Stagebarn Middle School   Regular School No Middle 05 08 2019   grade_6 99.0 1.0 6.0 4.0   1.0       1.0 4.0   53.0 63.0                       116.0 99 1 6 4   1       1 4   53 63                 116
363052 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No Elementary KG 04 2019   kindergarten 99.0 2.0 7.0 5.0   1.0       0.0 6.0   65.0 55.0                       120.0 99 2 7 5   1       0 6   65 55                 120
367247 SD     school 4631710 49007   West Central 49-7 463171000274 1 West Central Hi Sch   Regular School No High 09 12 2019   grade_10 99.0 1.0 0.0 3.0             2.0   57.0 48.0                       105.0 99 1 0 3             2   57 48                 105
358096 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School No Elementary KG 04 2019   grade_3 98.0 0.0 3.0 0.0   0.0         2.0   63.0 40.0                       103.0 98 0 3 0   0         2   63 40                 103
360946 SD     school 4602640 30001   Hanson 30-1 460264000017 1 Hanson High School   Regular School No High 09 12 2019   k_12_total 98.0   4.0 1.0   1.0         2.0   63.0 43.0       0.0               106.0 98   4 1   1         2   63 43                 106
360958 SD     school 4602640 30001   Hanson 30-1 460264000017 1 Hanson High School   Regular School No High 09 12 2019   pk_12_total 98.0   4.0 1.0   1.0         2.0   63.0 43.0                       106.0 98   4 1   1         2   63 43                 106
361810 SD     school 4636060 22006   Ipswich Public 22-6 463606000333 1 Ipswich Hi Sch   Regular School No High 09 12 2019   k_12_total 98.0 1.0 2.0     2.0         4.0   49.0 58.0       0.0               107.0 98 1 2     2         4   49 58                 107
361822 SD     school 4636060 22006   Ipswich Public 22-6 463606000333 1 Ipswich Hi Sch   Regular School No High 09 12 2019   pk_12_total 98.0 1.0 2.0     2.0         4.0   49.0 58.0                       107.0 98 1 2     2         4   49 58                 107
365457 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No Middle 06 08 2019   grade_6 98.0 72.0 59.0 18.0   30.0       1.0 26.0   162.0 142.0                       304.0 98 72 59 18   30       1 26   162 142                 304
366809 SD     school 4675660 51005   Wall 51-5 467566000704 2 Wall Elementary School   Regular School No Elementary KG 05 2019   k_12_total 98.0 3.0 1.0 14.0   1.0         1.0   53.0 65.0       0.0               118.0 98 3 1 14   1         1   53 65                 118
366817 SD     school 4675660 51005   Wall 51-5 467566000704 2 Wall Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 98.0 3.0 1.0 14.0   1.0         1.0   53.0 65.0                       118.0 98 3 1 14   1         1   53 65                 118
367278 SD     school 4631710 49007   West Central 49-7 463171000273 2 West Central Humboldt Elem   Regular School No Elementary KG 05 2019   grade_5 98.0 1.0 1.0 0.0             3.0   53.0 50.0                       103.0 98 1 1 0             3   53 50                 103
367297 SD     school 4631710 49007   West Central 49-7 463171000274 1 West Central Hi Sch   Regular School No High 09 12 2019   grade_9 98.0 1.0 1.0 2.0             3.0   56.0 49.0                       105.0 98 1 1 2             3   56 49                 105
357560 SD     school 4604270 4001   Avon 04-1 460427000028 2 Avon Elementary School   Regular School No Elementary KG 06 2019   k_12_total 97.0   5.0 9.0             8.0   57.0 62.0       0.0               119.0 97   5 9             8   57 62                 119
357568 SD     school 4604270 4001   Avon 04-1 460427000028 2 Avon Elementary School   Regular School No Elementary KG 06 2019   pk_12_total 97.0   5.0 9.0             8.0   57.0 62.0                       119.0 97   5 9             8   57 62                 119
357630 SD     school 4605610 9001   Belle Fourche 09-1 460561000038 1 Belle Fourche HS   Regular School No High 09 12 2019   grade_10 97.0   2.0 0.0   0.0         4.0   52.0 51.0                       103.0 97   2 0   0         4   52 51                 103
358088 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School No Elementary KG 04 2019   grade_2 97.0 7.0 2.0     4.0         9.0   51.0 68.0                       119.0 97 7 2     4         9   51 68                 119
358098 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2019   grade_4 97.0 2.0 4.0 1.0   1.0       0.0 4.0   63.0 46.0                       109.0 97 2 4 1   1       0 4   63 46                 109
358392 SD     school 4608520 5001   Brookings 05-1 460852001356 7 Dakota Prairie Elementary   Regular School No Elementary KG 03 2019   kindergarten 97.0 5.0 5.0 0.0   2.0         8.0   66.0 51.0                       117.0 97 5 5 0   2         8   66 51                 117
358798 SD     school 4612300 39001   Chester Area 39-1 461230000130 1 Chester Area High School   Regular School No High 09 12 2019   k_12_total 97.0 1.0 1.0                   48.0 51.0       0.0               99.0 97 1 1                   48 51                 99
358812 SD     school 4612300 39001   Chester Area 39-1 461230000130 1 Chester Area High School   Regular School No High 09 12 2019   pk_12_total 97.0 1.0 1.0                   48.0 51.0                       99.0 97 1 1                   48 51                 99
361697 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2019   grade_8 97.0 6.0 38.0 1.0   33.0       4.0 2.0   98.0 83.0                       181.0 97 6 38 1   33       4 2   98 83                 181
363496 SD     school 4648780 43002   Montrose 43-2 464878000451 2 Montrose Elementary School   Regular School No Elementary PK 05 2019   k_12_total 97.0 1.0 4.0                   46.0 56.0       0.0               102.0 97 1 4                   46 56                 102
367268 SD     school 4631710 49007   West Central 49-7 463171000273 2 West Central Humboldt Elem   Regular School No Elementary KG 05 2019   grade_3 97.0 0.0 3.0 1.0             3.0   48.0 56.0                       104.0 97 0 3 1             3   48 56                 104
357257 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No Elementary KG 06 2019   k_12_total 96.0   8.0 3.0   1.0         3.0   58.0 53.0       7.2               111.0 96   8 3   1         3   58 53                 111
357265 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No Elementary KG 06 2019   pk_12_total 96.0   8.0 3.0   1.0         3.0   58.0 53.0                       111.0 96   8 3   1         3   58 53                 111
357648 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School No Elementary 01 04 2019   grade_2 96.0   7.0 3.0             6.0   52.0 60.0                       112.0 96   7 3             6   52 60                 112
358146 SD     school 4607950 49002   Brandon Valley 49-2 460795000073 4 Valley Springs Elem   Regular School No Elementary KG 04 2019   k_12_total 96.0   2.0               2.0   52.0 48.0       0.0               100.0 96   2               2   52 48                 100
358160 SD     school 4607950 49002   Brandon Valley 49-2 460795000073 4 Valley Springs Elem   Regular School No Elementary KG 04 2019   pk_12_total 96.0   2.0               2.0   52.0 48.0                       100.0 96   2               2   52 48                 100
358896 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School No Elementary PK 04 2019   k_12_total 96.0 1.0 8.0               6.0   58.0 53.0       2.7               111.0 96 1 8               6   58 53                 111
361672 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2019   grade_4 96.0 3.0 59.0 4.0   38.0       0.0 4.0   114.0 90.0                       204.0 96 3 59 4   38       0 4   114 90                 204
362778 SD     school 4601026 43007   McCook Central 43-7 460102601026 1 McCook Central Hi Sch   Regular School No High 09 12 2019   k_12_total 96.0   4.0               3.0   55.0 48.0       0.0               103.0 96   4               3   55 48                 103
362786 SD     school 4601026 43007   McCook Central 43-7 460102601026 1 McCook Central Hi Sch   Regular School No High 09 12 2019   pk_12_total 96.0   4.0               3.0   55.0 48.0                       103.0 96   4               3   55 48                 103
362944 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No Elementary KG 04 2019   grade_2 96.0 0.0 4.0 1.0   2.0       0.0 5.0   60.0 48.0                       108.0 96 0 4 1   2       0 5   60 48                 108
364637 SD     school 4659820 51004   Rapid City Area 51-4 465982000539 8 Knollwood Heights Elem   Regular School No Elementary KG 05 2019   k_12_total 96.0 2.0 38.0 239.0   1.0       1.0 55.0   230.0 202.0       0.0               432.0 96 2 38 239   1       1 55   230 202                 432
364687 SD     school 4659820 51004   Rapid City Area 51-4 465982000539 8 Knollwood Heights Elem   Regular School No Elementary KG 05 2019   pk_12_total 96.0 2.0 38.0 239.0   1.0       1.0 55.0   230.0 202.0                       432.0 96 2 38 239   1       1 55   230 202                 432
365074 SD     school 4601028 62005   Selby Area 62-5 460102801032 2 Selby Elem K-6   Regular School No Elementary PK 06 2019   pk_12_total 96.0   7.0 3.0                 59.0 47.0                       106.0 96   7 3                 59 47                 106
365281 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School No Elementary PK 05 2019   grade_2 96.0 5.0 14.0 0.0   0.0         7.0   55.0 67.0                       122.0 96 5 14 0   0         7   55 67                 122
365645 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No Elementary PK 05 2019   kindergarten 96.0 6.0 0.0 2.0   1.0       0.0 3.0   45.0 63.0                       108.0 96 6 0 2   1       0 3   45 63                 108
366682 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000693 1 Viborg-Hurley High School   Regular School No High 09 12 2019   k_12_total 96.0 2.0 3.0 1.0             1.0   65.0 38.0       1.0               103.0 96 2 3 1             1   65 38                 103
366690 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000693 1 Viborg-Hurley High School   Regular School No High 09 12 2019   pk_12_total 96.0 2.0 3.0 1.0             1.0   65.0 38.0                       103.0 96 2 3 1             1   65 38                 103
361159 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2019   k_12_total 953.0 20.0 27.0 9.0   10.0         34.0   528.0 525.0       1.0               1053.0 953 20 27 9   10         34   528 525                 1053
361177 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2019   pk_12_total 953.0 20.0 27.0 9.0   10.0         34.0   528.0 525.0                       1053.0 953 20 27 9   10         34   528 525                 1053
357658 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School No Elementary 01 04 2019   grade_4 95.0   7.0 2.0             6.0   61.0 49.0                       110.0 95   7 2             6   61 49                 110
358056 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2019   grade_1 95.0 1.0 5.0 1.0   0.0       0.0 3.0   53.0 52.0                       105.0 95 1 5 1   0       0 3   53 52                 105
361374 SD     school 4633360 51002   Hill City 51-2 463336000848 4 Hill City Middle Sch   Regular School No Middle 06 08 2019   k_12_total 95.0   16.0 5.0             2.0   64.0 54.0       1.7               118.0 95   16 5             2   64 54                 118
361380 SD     school 4633360 51002   Hill City 51-2 463336000848 4 Hill City Middle Sch   Regular School No Middle 06 08 2019   pk_12_total 95.0   16.0 5.0             2.0   64.0 54.0                       118.0 95   16 5             2   64 54                 118
361640 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2019   grade_11 95.0 4.0 30.0 1.0   37.0       0.0 0.0   82.0 85.0                       167.0 95 4 30 1   37       0 0   82 85                 167
361663 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2019   grade_3 95.0 4.0 69.0 4.0   50.0       1.0 6.0   136.0 93.0                       229.0 95 4 69 4   50       1 6   136 93                 229
364683 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School No Elementary PK 05 2019   pk_12_total 95.0 5.0 75.0 277.0   5.0         60.0   265.0 252.0                       517.0 95 5 75 277   5         60   265 252                 517
365351 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No Elementary PK 05 2019   grade_4 95.0 4.0 6.0 1.0   2.0       1.0 3.0   52.0 60.0                       112.0 95 4 6 1   2       1 3   52 60                 112
367257 SD     school 4631710 49007   West Central 49-7 463171000274 1 West Central Hi Sch   Regular School No High 09 12 2019   grade_12 95.0 0.0 1.0 0.0             1.0   39.0 58.0                       97.0 95 0 1 0             1   39 58                 97
357628 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School No Elementary 01 04 2019   grade_1 94.0   2.0 0.0             7.0   54.0 49.0                       103.0 94   2 0             7   54 49                 103
359130 SD     school 4616950 16001   Custer 16-1 461695000992 5 Custer JH   Regular School No Middle 07 08 2019   k_12_total 94.0 2.0 7.0 5.0   1.0         2.0   52.0 59.0       0.0               111.0 94 2 7 5   1         2   52 59                 111
359138 SD     school 4616950 16001   Custer 16-1 461695000992 5 Custer JH   Regular School No Middle 07 08 2019   pk_12_total 94.0 2.0 7.0 5.0   1.0         2.0   52.0 59.0                       111.0 94 2 7 5   1         2   52 59                 111
359175 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School No Elementary 04 05 2019   grade_5 94.0 6.0 7.0 1.0   2.0         5.0   61.0 54.0                       115.0 94 6 7 1   2         5   61 54                 115
360652 SD     school 4626970 53001   Gettysburg 53-1 462697000231 2 Gettysburg Elem   Regular School No Elementary KG 05 2019   k_12_total 94.0   3.0 3.0             3.0   56.0 47.0       0.0               103.0 94   3 3             3   56 47                 103
360658 SD     school 4626970 53001   Gettysburg 53-1 462697000231 2 Gettysburg Elem   Regular School No Elementary KG 05 2019   pk_12_total 94.0   3.0 3.0             3.0   56.0 47.0                       103.0 94   3 3             3   56 47                 103
362639 SD     school 4639600 39002   Madison Central 39-2 463960000363 1 Madison High School   Regular School No High 09 12 2019   grade_11 94.0 1.0 5.0 2.0   1.0         1.0   53.0 51.0                       104.0 94 1 5 2   1         1   53 51                 104
363644 SD     school 4650850 9002   Newell 09-2 465085000468 2 Newell Elem   Regular School No Elementary PK 05 2019   k_12_total 94.0 2.0 6.0 9.0             2.0   48.0 65.0       0.0               113.0 94 2 6 9             2   48 65                 113
364976 SD     school 4603932 55005   Sanborn Central 55-5 460393201162 6 Sanborn Central Elementary   Regular School No Elementary PK 05 2019   pk_12_total 94.0   1.0 1.0             5.0   59.0 42.0                       101.0 94   1 1             5   59 42                 101
367662 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School No Middle 05 08 2019   k_12_total 94.0   13.0               6.0   57.0 56.0       2.7               113.0 94   13               6   57 56                 113
367668 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School No Middle 05 08 2019   pk_12_total 94.0   13.0               6.0   57.0 56.0                       113.0 94   13               6   57 56                 113
358091 SD     school 4607950 49002   Brandon Valley 49-2 460795000414 3 Brandon Elem   Regular School No Elementary PK 04 2019   grade_3 93.0 2.0 2.0 1.0   0.0       0.0 6.0   57.0 47.0                       104.0 93 2 2 1   0       0 6   57 47                 104
359295 SD     school 4618120 49003   Dell Rapids 49-3 461812000164 2 Dell Rapids Elementary   Regular School No Elementary KG 04 2019   kindergarten 93.0 0.0 1.0 3.0           0.0 1.0   58.0 40.0                       98.0 93 0 1 3           0 1   58 40                 98
362457 SD     school 4641550 41004   Lennox 41-4 464155000386 2 Lennox Elementary   Regular School No Elementary PK 04 2019   kindergarten 93.0 1.0 1.0 2.0   0.0         7.0   63.0 41.0                       104.0 93 1 1 2   0         7   63 41                 104
365309 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No Elementary PK 05 2019   grade_3 93.0 7.0 5.0 0.0   1.0       0.0 5.0   57.0 54.0                       111.0 93 7 5 0   1       0 5   57 54                 111
365393 SD     school 4666270 49005   Sioux Falls 49-5 466627001064 23 John Harris Elementary   Regular School No Elementary PK 05 2019   grade_5 93.0 5.0 3.0 1.0   4.0       0.0 1.0   54.0 53.0                       107.0 93 5 3 1   4       0 1   54 53                 107
365659 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School No Elementary PK 05 2019   kindergarten 93.0 4.0 22.0 0.0   0.0         6.0   67.0 58.0                       125.0 93 4 22 0   0         6   67 58                 125
366141 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No High 09 12 2019   grade_10 93.0 5.0 4.0 2.0             4.0   56.0 52.0                       108.0 93 5 4 2             4   56 52                 108
366149 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No High 09 12 2019   grade_12 93.0 0.0 1.0 1.0             10.0   56.0 49.0                       105.0 93 0 1 1             10   56 49                 105
358103 SD     school 4607950 49002   Brandon Valley 49-2 460795001237 5 Robert Bennis Elementary   Regular School No Elementary KG 04 2019   grade_4 92.0 1.0 3.0 1.0   0.0         1.0   53.0 45.0                       98.0 92 1 3 1   0         1   53 45                 98
359171 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School No Elementary 04 05 2019   grade_4 92.0 1.0 7.0 2.0   1.0         5.0   51.0 57.0                       108.0 92 1 7 2   1         5   51 57                 108
359744 SD     school 4620850 23001   Edgemont 23-1 462085000181 3 Edgemont Elementary   Regular School No Elementary KG 08 2019   k_12_total 92.0   3.0 8.0             7.0   57.0 53.0       1.8               110.0 92   3 8             7   57 53                 110
359748 SD     school 4620850 23001   Edgemont 23-1 462085000181 3 Edgemont Elementary   Regular School No Elementary KG 08 2019   pk_12_total 92.0   3.0 8.0             7.0   57.0 53.0                       110.0 92   3 8             7   57 53                 110
361102 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School No Elementary KG 05 2019   grade_4 92.0 3.0 2.0 1.0   1.0       0.0 4.0   52.0 51.0                       103.0 92 3 2 1   1       0 4   52 51                 103
361111 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School No Elementary KG 05 2019   grade_5 92.0 2.0 0.0 0.0   2.0       0.0 3.0   55.0 44.0                       99.0 92 2 0 0   2       0 3   55 44                 99
361167 SD     school 4631350 41002   Harrisburg 41-2 463135001318 6 Freedom Elementary   Regular School No Elementary KG 05 2019   kindergarten 92.0 1.0 2.0 2.0           1.0 2.0   54.0 46.0                       100.0 92 1 2 2           1 2   54 46                 100
361683 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2019   grade_6 92.0 4.0 46.0 4.0   32.0       0.0 5.0   94.0 89.0                       183.0 92 4 46 4   32       0 5   94 89                 183
362445 SD     school 4641550 41004   Lennox 41-4 464155000963 8 Lennox Jr. High   Regular School No Middle 07 08 2019   grade_8 92.0 1.0 4.0 1.0             0.0   49.0 49.0                       98.0 92 1 4 1             0   49 49                 98
362968 SD     school 4669930 46001   Meade 46-1 466993000637 3 Sturgis Elementary   Regular School No Elementary KG 04 2019   grade_4 92.0 1.0 6.0 1.0   1.0       1.0 6.0   55.0 53.0                       108.0 92 1 6 1   1       1 6   55 53                 108
363918 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701030 2 Oldham-Ramona Elementary   Regular School No Elementary PK 06 2019   pk_12_total 92.0   2.0               1.0   44.0 51.0                       95.0 92   2               1   44 51                 95
367570 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2019   pk_12_total 92.0 3.0 4.0 34.0             1.0   70.0 64.0                       134.0 92 3 4 34             1   70 64                 134
367661 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School No High 09 12 2019   k_12_total 92.0 3.0 7.0               4.0   51.0 55.0       0.9               106.0 92 3 7               4   51 55                 106
367667 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School No High 09 12 2019   pk_12_total 92.0 3.0 7.0               4.0   51.0 55.0                       106.0 92 3 7               4   51 55                 106
357680 SD     school 4605610 9001   Belle Fourche 09-1 460561000038 1 Belle Fourche HS   Regular School No High 09 12 2019   grade_9 91.0   5.0 2.0   0.0         5.0   56.0 47.0                       103.0 91   5 2   0         5   56 47                 103
359182 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No Middle 06 08 2019   grade_7 91.0 4.0 8.0 3.0   3.0         5.0   54.0 60.0                       114.0 91 4 8 3   3         5   54 60                 114
360114 SD     school 4622560 44001   Eureka 44-1 462256000195 2 Eureka Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 91.0                   4.0   53.0 42.0                       95.0 91                   4   53 42                 95
361690 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2019   grade_7 91.0 3.0 41.0 4.0   44.0       1.0 3.0   100.0 87.0                       187.0 91 3 41 4   44       1 3   100 87                 187
361936 SD     school 4636150 2003   Iroquois 02-3 463615001144 4 Iroquois Elementary   Regular School No Elementary PK 05 2019   pk_12_total 91.0 4.0 7.0 2.0           1.0 4.0   50.0 59.0                       109.0 91 4 7 2           1 4   50 59                 109
362150 SD     school 4638220 7002   Kimball 07-2 463822000354 2 Kimball Elementary   Regular School No Elementary PK 04 2019   k_12_total 91.0   3.0 3.0             5.0   60.0 42.0       0.0               102.0 91   3 3             5   60 42                 102
362978 SD     school 4669930 46001   Meade 46-1 466993001392 10 Stagebarn Middle School   Regular School No Middle 05 08 2019   grade_5 91.0 2.0 5.0 5.0   1.0       0.0 6.0   49.0 61.0                       110.0 91 2 5 5   1       0 6   49 61                 110
363706 SD     school 4651750 56007   Northwestern Area 56-7 465175000475 1 Northwestern High School   Regular School No High 09 12 2019   k_12_total 91.0     1.0   1.0         1.0   48.0 46.0       0.0               94.0 91     1   1         1   48 46                 94
363714 SD     school 4651750 56007   Northwestern Area 56-7 465175000475 1 Northwestern High School   Regular School No High 09 12 2019   pk_12_total 91.0     1.0   1.0         1.0   48.0 46.0                       94.0 91     1   1         1   48 46                 94
365305 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School No Elementary PK 05 2019   grade_3 91.0 4.0 4.0 3.0   2.0         5.0   53.0 56.0                       109.0 91 4 4 3   2         5   53 56                 109
360605 SD     school 4626490 63001   Gayville-Volin 63-1 462649000227 1 Gayville-Volin Hi Sch   Regular School No High 09 12 2019   k_12_total 90.0   6.0 1.0   2.0         4.0   47.0 56.0       0.0               103.0 90   6 1   2         4   47 56                 103
360611 SD     school 4626490 63001   Gayville-Volin 63-1 462649000227 1 Gayville-Volin Hi Sch   Regular School No High 09 12 2019   pk_12_total 90.0   6.0 1.0   2.0         4.0   47.0 56.0                       103.0 90   6 1   2         4   47 56                 103

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