Data source: Big Local News · About: Big Local

10,800 rows where state = "SD" and year = 2021 sorted by hispanic descending

View and edit SQL

year

  • 2021 · 10,800
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
457563 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 559.0 17.0 99.0 2.0   1.0         28.0   344.0 362.0                       706.0 559 17 99 2   1         28   344 362                 706
457468 SD     school 4666270 49005   Sioux Falls 49-5 466627000602 28 Lowell Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 126.0 63.0 98.0 51.0   3.0         41.0   196.0 186.0       20.4               382.0 126 63 98 51   3         41   196 186                 382
457024 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2021   grade_10 258.0 101.0 96.0 30.0   26.0       0.0 22.0   280.0 253.0                       533.0 258 101 96 30   26       0 22   280 253                 533
457542 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 205.0 122.0 95.0 51.0   14.0         60.0   293.0 254.0                       547.0 205 122 95 51   14         60   293 254                 547
449031 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2021   k_12_total 1132.0 18.0 94.0 74.0   42.0       2.0 48.0   697.0 713.0       3.1               1410.0 1132 18 94 74   42       2 48   697 713                 1410
449051 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School Not applicable High 09 12 2021   pk_12_total 1132.0 18.0 94.0 74.0   42.0       2.0 48.0   697.0 713.0                       1410.0 1132 18 94 74   42       2 48   697 713                 1410
457479 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 538.0 17.0 94.0 2.0   1.0         25.0   328.0 349.0       0.0               677.0 538 17 94 2   1         25   328 349                 677
457444 SD     school 4666270 49005   Sioux Falls 49-5 466627000610 1 Washington High School   Regular School Not applicable High 09 12 2021   grade_9 248.0 139.0 93.0 42.0   41.0       2.0 29.0   300.0 294.0                       594.0 248 139 93 42   41       2 29   300 294                 594
457485 SD     school 4666270 49005   Sioux Falls 49-5 466627000579 11 Terry Redlin Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 138.0 105.0 93.0 46.0   17.0         33.0   226.0 206.0       27.6               432.0 138 105 93 46   17         33   226 206                 432
449030 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School Not applicable Elementary KG 05 2021   k_12_total 311.0 9.0 9.0 10.0   9.0         19.0   190.0 177.0       1.1               367.0 311 9 9 10   9         19   190 177                 367
449050 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School Not applicable Elementary KG 05 2021   pk_12_total 311.0 9.0 9.0 10.0   9.0         19.0   190.0 177.0                       367.0 311 9 9 10   9         19   190 177                 367
449230 SD     school 4639540 11001   Andes Central 11-1 463954000359 2 Andes Central Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 30.0   9.0 89.0             25.0   81.0 72.0       0.0               153.0 30   9 89             25   81 72                 153
449238 SD     school 4639540 11001   Andes Central 11-1 463954000359 2 Andes Central Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 38.0   9.0 94.0             34.0   91.0 84.0                       175.0 38   9 94             34   91 84                 175
449512 SD     school 4605610 9001   Belle Fourche 09-1 460561001117 7 Belle Fourche MS   Regular School Not applicable Middle 05 08 2021   grade_6 93.0 0.0 9.0 4.0             5.0   56.0 55.0                       111.0 93 0 9 4             5   56 55                 111
449533 SD     school 4605610 9001   Belle Fourche 09-1 460561000289 8 North Park Elementary   Regular School Not applicable Elementary KG KG 2021   k_12_total 89.0   9.0 2.0             7.0   50.0 57.0       0.0               107.0 89   9 2             7   50 57                 107
449538 SD     school 4605610 9001   Belle Fourche 09-1 460561000289 8 North Park Elementary   Regular School Not applicable Elementary KG KG 2021   kindergarten 89.0   9.0 2.0             7.0   50.0 57.0                       107.0 89   9 2             7   50 57                 107
449543 SD     school 4605610 9001   Belle Fourche 09-1 460561000289 8 North Park Elementary   Regular School Not applicable Elementary KG KG 2021   pk_12_total 89.0   9.0 2.0             7.0   50.0 57.0                       107.0 89   9 2             7   50 57                 107
449632 SD     school 4606360 61002   Beresford 61-2 460636000048 1 Beresford High School   Regular School Not applicable High 09 12 2021   grade_9 52.0   9.0 0.0   2.0         0.0   39.0 24.0                       63.0 52   9 0   2         0   39 24                 63
449636 SD     school 4606360 61002   Beresford 61-2 460636000051 3 Beresford Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 151.0 1.0 9.0 1.0             1.0   92.0 71.0       3.1               163.0 151 1 9 1             1   92 71                 163
449642 SD     school 4606360 61002   Beresford 61-2 460636000051 3 Beresford Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 151.0 1.0 9.0 1.0             1.0   92.0 71.0                       163.0 151 1 9 1             1   92 71                 163
449906 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School Not applicable Elementary KG 04 2021   grade_1 88.0 7.0 9.0 0.0   6.0       1.0 3.0   63.0 51.0                       114.0 88 7 9 0   6       1 3   63 51                 114
449934 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School Not applicable Elementary KG 04 2021   grade_2 91.0 8.0 9.0 0.0   2.0       0.0 5.0   58.0 57.0                       115.0 91 8 9 0   2       0 5   58 57                 115
450050 SD     school 4621420 30003   Bridgewater-Emery 30-3 462142010071 2 Bridgewater-Emery Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 141.0 1.0 9.0               7.0   81.0 77.0       1.3               158.0 141 1 9               7   81 77                 158
450056 SD     school 4621420 30003   Bridgewater-Emery 30-3 462142010071 2 Bridgewater-Emery Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 150.0 1.0 9.0               7.0   85.0 82.0                       167.0 150 1 9               7   85 82                 167
450446 SD     school 4611280 28001   Castlewood 28-1 461128000113 2 Castlewood Elementary   Regular School Not applicable Elementary PK 06 2021   k_12_total 149.0 1.0 9.0               3.0   76.0 86.0       1.2               162.0 149 1 9               3   76 86                 162
450547 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School Not applicable High 09 12 2021   k_12_total 161.0 2.0 9.0 91.0   1.0         5.0   141.0 128.0       0.0               269.0 161 2 9 91   1         5   141 128                 269
450553 SD     school 4612000 7001   Chamberlain 07-1 461200000119 1 Chamberlain High School   Regular School Not applicable High 09 12 2021   pk_12_total 161.0 2.0 9.0 91.0   1.0         5.0   141.0 128.0                       269.0 161 2 9 91   1         5   141 128                 269
450977 SD     school 4616950 16001   Custer 16-1 461695000159 4 Hermosa Elem   Regular School Not applicable Elementary KG 08 2021   k_12_total 194.0   9.0 16.0           1.0 13.0   114.0 119.0       0.0               233.0 194   9 16           1 13   114 119                 233
450985 SD     school 4616950 16001   Custer 16-1 461695000159 4 Hermosa Elem   Regular School Not applicable Elementary KG 08 2021   pk_12_total 194.0   9.0 16.0           1.0 13.0   114.0 119.0                       233.0 194   9 16           1 13   114 119                 233
451024 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School Not applicable Middle 06 08 2021   grade_6 94.0 1.0 9.0 3.0   1.0         6.0   53.0 61.0                       114.0 94 1 9 3   1         6   53 61                 114
451032 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School Not applicable Middle 06 08 2021   grade_8 107.0 2.0 9.0 2.0   3.0         10.0   67.0 66.0                       133.0 107 2 9 2   3         10   67 66                 133
451490 SD     school 4619450 64002   Dupree 64-2 461945000799 2 Dupree Elem   Regular School Not applicable Elementary PK 06 2021   k_12_total 22.0 1.0 9.0 156.0             10.0   102.0 96.0       0.0               198.0 22 1 9 156             10   102 96                 198
451843 SD     school 4622410 28002   Estelline 28-2 462241000192 1 Estelline High School   Regular School Not applicable High 09 12 2021   k_12_total 68.0   9.0                   41.0 36.0       9.1               77.0 68   9                   41 36                 77
451849 SD     school 4622410 28002   Estelline 28-2 462241000192 1 Estelline High School   Regular School Not applicable High 09 12 2021   pk_12_total 68.0   9.0                   41.0 36.0                       77.0 68   9                   41 36                 77
452178 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School Not applicable Elementary KG 04 2021   kindergarten 22.0   9.0 20.0   1.0       0.0 8.0   31.0 29.0                       60.0 22   9 20   1       0 8   31 29                 60
452915 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School Not applicable High 09 12 2021   grade_11 282.0 6.0 9.0 2.0   4.0         9.0   146.0 166.0                       312.0 282 6 9 2   4         9   146 166                 312
452931 SD     school 4631350 41002   Harrisburg 41-2 463135001169 4 Explorer Elementary   Regular School Not applicable Elementary KG 05 2021   grade_2 54.0 7.0 9.0 0.0   1.0         7.0   38.0 40.0                       78.0 54 7 9 0   1         7   38 40                 78
453208 SD     school 4633360 51002   Hill City 51-2 463336000848 4 Hill City Middle Sch   Regular School Not applicable Middle 06 08 2021   grade_6 20.0   9.0 3.0   1.0         2.0   16.0 19.0                       35.0 20   9 3   1         2   16 19                 35
454478 SD     school 4639600 39002   Madison Central 39-2 463960001189 7 Madison Elementary School   Regular School Not applicable Elementary KG 05 2021   grade_1 59.0 2.0 9.0 2.0   0.0         3.0   38.0 37.0                       75.0 59 2 9 2   0         3   38 37                 75
454493 SD     school 4639600 39002   Madison Central 39-2 463960001189 7 Madison Elementary School   Regular School Not applicable Elementary KG 05 2021   grade_3 72.0 2.0 9.0 2.0   2.0         1.0   40.0 48.0                       88.0 72 2 9 2   2         1   40 48                 88
454631 SD     school 4601026 43007   McCook Central 43-7 460102600404 2 McCook Central Elementary   Regular School Not applicable Elementary PK 04 2021   pk_12_total 156.0   9.0               8.0   102.0 71.0                       173.0 156   9               8   102 71                 173
454753 SD     school 4669930 46001   Meade 46-1 466993000633 1 Sturgis Brown HS   Regular School Not applicable High 09 12 2021   grade_10 155.0 0.0 9.0 6.0   1.0       0.0 13.0   87.0 97.0                       184.0 155 0 9 6   1       0 13   87 97                 184
454840 SD     school 4669930 46001   Meade 46-1 466993000653 2 Sturgis Williams MS   Regular School Not applicable Middle 06 08 2021   grade_6 108.0 2.0 9.0 2.0   0.0         9.0   68.0 62.0                       130.0 108 2 9 2   0         9   68 62                 130
454864 SD     school 4669930 46001   Meade 46-1 466993000653 2 Sturgis Williams MS   Regular School Not applicable Middle 06 08 2021   grade_8 115.0 0.0 9.0 5.0   1.0         8.0   84.0 54.0                       138.0 115 0 9 5   1         8   84 54                 138
455049 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School Not applicable Middle 06 08 2021   grade_8 73.0 0.0 9.0 1.0             2.0   54.0 31.0                       85.0 73 0 9 1             2   54 31                 85
455059 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Milbank Elementary School   Regular School Not applicable Elementary PK 05 2021   kindergarten 63.0 0.0 9.0 1.0   0.0       1.0 2.0   43.0 33.0                       76.0 63 0 9 1   0       1 2   43 33                 76
455151 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School Not applicable High 09 12 2021   grade_11 191.0 1.0 9.0 7.0   4.0       1.0 2.0   109.0 106.0                       215.0 191 1 9 7   4       1 2   109 106                 215
455975 SD     school 4655260 32002   Pierre 32-2 465526000500 1 T F Riggs High School   Regular School Not applicable High 09 12 2021   grade_10 158.0 0.0 9.0 26.0   3.0         17.0   93.0 120.0                       213.0 158 0 9 26   3         17   93 120                 213
456215 SD     school 4659820 51004   Rapid City Area 51-4 465982000539 8 Knollwood Heights Elem   Regular School Not applicable Elementary KG 05 2021   grade_1 10.0   9.0 28.0   1.0         10.0   32.0 26.0                       58.0 10   9 28   1         10   32 26                 58
456332 SD     school 4659820 51004   Rapid City Area 51-4 465982000540 4 Canyon Lake Elem   Regular School Not applicable Elementary PK 05 2021   grade_3 32.0 2.0 9.0 7.0   0.0       0.0 14.0   32.0 32.0                       64.0 32 2 9 7   0       0 14   32 32                 64
456353 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School Not applicable Elementary KG 05 2021   grade_3 61.0 2.0 9.0 11.0   1.0         9.0   52.0 41.0                       93.0 61 2 9 11   1         9   52 41                 93
456378 SD     school 4659820 51004   Rapid City Area 51-4 465982000969 13 Valley View Elem   Regular School Not applicable Elementary KG 05 2021   grade_4 49.0 2.0 9.0 15.0   0.0         9.0   40.0 44.0                       84.0 49 2 9 15   0         9   40 44                 84
456392 SD     school 4659820 51004   Rapid City Area 51-4 465982000549 10 Meadowbrook Elem   Regular School Not applicable Elementary KG 05 2021   grade_5 74.0 3.0 9.0 9.0   1.0         4.0   48.0 52.0                       100.0 74 3 9 9   1         4   48 52                 100
456400 SD     school 4659820 51004   Rapid City Area 51-4 465982000824 16 South Park Elem   Regular School Not applicable Elementary KG 05 2021   grade_5 12.0 0.0 9.0 12.0           0.0 7.0   18.0 22.0                       40.0 12 0 9 12           0 7   18 22                 40
456405 SD     school 4659820 51004   Rapid City Area 51-4 465982000530 17 Woodrow Wilson Elem   Regular School Not applicable Elementary KG 05 2021   grade_5 27.0 2.0 9.0 8.0   1.0         8.0   24.0 31.0                       55.0 27 2 9 8   1         8   24 31                 55
456426 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School Not applicable Middle 06 08 2021   grade_6 172.0 0.0 9.0 13.0   5.0       0.0 15.0   116.0 98.0                       214.0 172 0 9 13   5       0 15   116 98                 214
456476 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School Not applicable Middle 06 08 2021   grade_8 217.0 2.0 9.0 13.0   3.0       0.0 15.0   123.0 136.0                       259.0 217 2 9 13   3       0 15   123 136                 259
456586 SD     school 4659820 51004   Rapid City Area 51-4 465982000536 1 General Beadle Elem   Regular School Not applicable Elementary PK 05 2021   pre_kindergarten 8.0 0.0 9.0 16.0   0.0       0.0 4.0   15.0 22.0                       37.0 8 0 9 16   0       0 4   15 22                 37
456947 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School Not applicable Elementary PK 05 2021   grade_1 24.0 26.0 9.0 11.0   4.0       0.0 5.0   44.0 35.0                       79.0 24 26 9 11   4       0 5   44 35                 79
457119 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School Not applicable Elementary KG 05 2021   grade_2 1.0 3.0 9.0     0.0       0.0     4.0 9.0                       13.0 1 3 9     0       0     4 9                 13
457157 SD     school 4666270 49005   Sioux Falls 49-5 466627000581 14 Cleveland Elementary   Regular School Not applicable Elementary PK 05 2021   grade_3 19.0 36.0 9.0 6.0   6.0       0.0 4.0   35.0 45.0                       80.0 19 36 9 6   6       0 4   35 45                 80
457166 SD     school 4666270 49005   Sioux Falls 49-5 466627000588 54 Harvey Dunn Elementary   Regular School Not applicable Elementary PK 05 2021   grade_3 65.0 3.0 9.0 2.0   2.0         7.0   52.0 36.0                       88.0 65 3 9 2   2         7   52 36                 88
457180 SD     school 4666270 49005   Sioux Falls 49-5 466627001300 17 R. F. Pettigrew Elementary   Regular School Not applicable Elementary PK 05 2021   grade_3 111.0 7.0 9.0 0.0   4.0       0.0 12.0   78.0 65.0                       143.0 111 7 9 0   4       0 12   78 65                 143
457185 SD     school 4666270 49005   Sioux Falls 49-5 466627001344 65 Sonia Sotomayor Elementary   Regular School Not applicable Elementary PK 05 2021   grade_3 104.0 2.0 9.0 1.0   0.0         2.0   58.0 60.0                       118.0 104 2 9 1   0         2   58 60                 118
457209 SD     school 4666270 49005   Sioux Falls 49-5 466627000936 56 Hawthorne Elementary   Regular School Not applicable Elementary PK 05 2021   grade_4 6.0 4.0 9.0 10.0   1.0       0.0 3.0   11.0 22.0                       33.0 6 4 9 10   1       0 3   11 22                 33
457243 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School Not applicable Elementary PK 05 2021   grade_5 130.0 11.0 9.0 1.0   2.0       0.0 10.0   82.0 81.0                       163.0 130 11 9 1   2       0 10   82 81                 163
457490 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School Not applicable Elementary PK 05 2021   kindergarten 18.0 22.0 9.0 0.0   19.0       0.0 9.0   39.0 38.0                       77.0 18 22 9 0   19       0 9   39 38                 77
457526 SD     school 4666270 49005   Sioux Falls 49-5 466627001351 66 Susan B. Anthony Elementary   Regular School Not applicable Elementary KG 05 2021   kindergarten 69.0 18.0 9.0 3.0   1.0       0.0 8.0   69.0 39.0                       108.0 69 18 9 3   1       0 8   69 39                 108
457787 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School Not applicable High 09 12 2021   grade_10 165.0 1.0 9.0 4.0   1.0       0.0 8.0   104.0 84.0                       188.0 165 1 9 4   1       0 8   104 84                 188
457831 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School Not applicable Elementary 03 05 2021   grade_5 167.0 3.0 9.0 3.0   1.0       2.0 6.0   101.0 90.0                       191.0 167 3 9 3   1       2 6   101 90                 191
457867 SD     school 4666930 40002   Spearfish 40-2 466693000623 1 Spearfish High School   Regular School Not applicable High 09 12 2021   grade_9 169.0 1.0 9.0 5.0   4.0       1.0 2.0   103.0 88.0                       191.0 169 1 9 5   4       1 2   103 88                 191
458485 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School Not applicable Middle 06 08 2021   grade_7 85.0 3.0 9.0 11.0             8.0   66.0 50.0                       116.0 85 3 9 11             8   66 50                 116
458489 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School Not applicable Middle 06 08 2021   grade_8 70.0 0.0 9.0 12.0             4.0   48.0 47.0                       95.0 70 0 9 12             4   48 47                 95
458839 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School Not applicable Middle 07 08 2021   grade_7 274.0 0.0 9.0 15.0   4.0       0.0 19.0   155.0 166.0                       321.0 274 0 9 15   4       0 19   155 166                 321
459610 SD     school 4680190 55004   Woonsocket 55-4 468019000789 3 Woonsocket Elementary   Regular School Not applicable Elementary PK 08 2021   pk_12_total 183.0   9.0 4.0             4.0   108.0 92.0                       200.0 183   9 4             4   108 92                 200
457375 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School Not applicable Middle 06 08 2021   grade_8 101.0 62.0 89.0 19.0   5.0       0.0 24.0   151.0 149.0                       300.0 101 62 89 19   5       0 24   151 149                 300
457469 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 1088.0 89.0 89.0 25.0   15.0       3.0 80.0   669.0 720.0       2.7               1389.0 1088 89 89 25   15       3 80   669 720                 1389
457553 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 1088.0 89.0 89.0 25.0   15.0       3.0 80.0   669.0 720.0                       1389.0 1088 89 89 25   15       3 80   669 720                 1389
457458 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 180.0 103.0 87.0 47.0   13.0         55.0   259.0 226.0       25.6               485.0 180 103 87 47   13         55   259 226                 485
457532 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 99.0 217.0 87.0 19.0   126.0       1.0 44.0   309.0 284.0                       593.0 99 217 87 19   126       1 44   309 284                 593
457455 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School Not applicable Elementary KG 05 2021   k_12_total 5.0 25.0 84.0     2.0       1.0     65.0 52.0       99.2               117.0 5 25 84     2       1     65 52                 117
457539 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School Not applicable Elementary KG 05 2021   pk_12_total 5.0 25.0 84.0     2.0       1.0     65.0 52.0                       117.0 5 25 84     2       1     65 52                 117
457448 SD     school 4666270 49005   Sioux Falls 49-5 466627000770 20 Anne Sullivan Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 90.0 185.0 81.0 18.0   102.0       0.0 35.0   258.0 253.0       50.5               511.0 90 185 81 18   102       0 35   258 253                 511
453470 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School Not applicable Elementary KG 01 2021   grade_1 79.0 4.0 80.0 2.0   54.0       2.0 11.0   105.0 127.0                       232.0 79 4 80 2   54       2 11   105 127                 232
456518 SD     school 4659820 51004   Rapid City Area 51-4 465982000532 35 North Middle Sch   Regular School Not applicable Middle 06 08 2021   k_12_total 117.0 4.0 80.0 245.0   7.0         78.0   267.0 264.0       1.9               531.0 117 4 80 245   7         78   267 264                 531
456568 SD     school 4659820 51004   Rapid City Area 51-4 465982000532 35 North Middle Sch   Regular School Not applicable Middle 06 08 2021   pk_12_total 117.0 4.0 80.0 245.0   7.0         78.0   267.0 264.0                       531.0 117 4 80 245   7         78   267 264                 531
448913 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School Not applicable Elementary PK 05 2021   grade_1 28.0 0.0 8.0 2.0   6.0         1.0   29.0 16.0                       45.0 28 0 8 2   6         1   29 16                 45
448918 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School Not applicable Elementary KG 05 2021   grade_1 56.0 0.0 8.0 3.0   1.0         2.0   34.0 36.0                       70.0 56 0 8 3   1         2   34 36                 70
448964 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School Not applicable Elementary KG 05 2021   grade_3 40.0 2.0 8.0 4.0   5.0         5.0   29.0 35.0                       64.0 40 2 8 4   5         5   29 35                 64
449294 SD     school 4603720 38001   Arlington 38-1 460372000021 2 Arlington Elementary   Regular School Not applicable Elementary KG 06 2021   k_12_total 128.0   8.0               1.0   59.0 78.0       0.7               137.0 128   8               1   59 78                 137
449302 SD     school 4603720 38001   Arlington 38-1 460372000021 2 Arlington Elementary   Regular School Not applicable Elementary KG 06 2021   pk_12_total 128.0   8.0               1.0   59.0 78.0                       137.0 128   8               1   59 78                 137
449474 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School Not applicable Elementary 01 04 2021   grade_1 87.0   8.0 3.0             4.0   48.0 54.0                       102.0 87   8 3             4   48 54                 102
449507 SD     school 4605610 9001   Belle Fourche 09-1 460561001117 7 Belle Fourche MS   Regular School Not applicable Middle 05 08 2021   grade_5 73.0 0.0 8.0 2.0             4.0   42.0 45.0                       87.0 73 0 8 2             4   42 45                 87
449526 SD     school 4605610 9001   Belle Fourche 09-1 460561000038 1 Belle Fourche HS   Regular School Not applicable High 09 12 2021   grade_9 106.0   8.0 1.0             6.0   62.0 59.0                       121.0 106   8 1             6   62 59                 121
449587 SD     school 4606240 3001   Bennett County 03-1 460624001015 6 Bennett County Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 20.0   8.0 47.0             21.0   46.0 50.0       0.0               96.0 20   8 47             21   46 50                 96
449593 SD     school 4606240 3001   Bennett County 03-1 460624001015 6 Bennett County Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 20.0   8.0 47.0             21.0   46.0 50.0                       96.0 20   8 47             21   46 50                 96
450162 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   grade_1 49.0 1.0 8.0 4.0   4.0         10.0   47.0 29.0                       76.0 49 1 8 4   4         10   47 29                 76
450163 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   grade_1 52.0 5.0 8.0 3.0   1.0       0.0 4.0   39.0 34.0                       73.0 52 5 8 3   1       0 4   39 34                 73
450170 SD     school 4608520 5001   Brookings 05-1 460852000082 1 Brookings Hi Sch   Regular School Not applicable High 09 12 2021   grade_11 202.0 1.0 8.0 5.0   9.0       0.0 9.0   134.0 100.0                       234.0 202 1 8 5   9       0 9   134 100                 234
450187 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School Not applicable Elementary KG 03 2021   grade_2 62.0 2.0 8.0 4.0   4.0       1.0 5.0   48.0 38.0                       86.0 62 2 8 4   4       1 5   48 38                 86

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