Data source: Big Local News · About: Big Local

4,696 rows where grade = "pk_12_total" and state = "SD"

View and edit SQL

year

grade

  • pk_12_total · 4,496
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
253044 SD     school 4624030 24004   Faulkton Area 462403000203 1 Faulkton Hi Sch   Regular School No High 09 12 2018   pk_12_total 71.0 1.0                     35.0 37.0                       72.0 71 1                     35 37                 72
253045 SD     school 4624030 24004   Faulkton Area 462403000204 8 Faulkton Jr Hi   Regular School No Middle 07 08 2018   pk_12_total 30.0 1.0   1.0                 10.0 22.0                       32.0 30 1   1                 10 22                 32
253046 SD     school 4624030 24004   Faulkton Area 462403001160 10 Thunderbird Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 23.0                       11.0 12.0                       23.0 23                       11 12                 23
253109 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School No Elementary KG 05 2018   pk_12_total 136.0 1.0 44.0 100.0   6.0       4.0 24.0   164.0 151.0                       315.0 136 1 44 100   6       4 24   164 151                 315
253110 SD     school 4624390 50003   Flandreau 50-3 462439000206 1 Flandreau High Sch   Regular School No High 09 12 2018   pk_12_total 91.0 1.0 16.0 74.0   2.0       1.0 3.0   93.0 95.0                       188.0 91 1 16 74   2       1 3   93 95                 188
253111 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 77.0 2.0 8.0 49.0   2.0       3.0 3.0   76.0 68.0                       144.0 77 2 8 49   2       3 3   76 68                 144
253112 SD     school 4624390 50003   Flandreau 50-3 462439001119 6 Pleasant Valley Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 30.0                       16.0 14.0                       30.0 30                       16 14                 30
253159 SD     school 4624540 14001   Florence 14-1 462454000208 2 Florence Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 145.0     2.0             1.0   73.0 75.0                       148.0 145     2             1   73 75                 148
253160 SD     school 4624540 14001   Florence 14-1 462454000209 1 Florence High School   Regular School No High 09 12 2018   pk_12_total 62.0     3.0   1.0         3.0   36.0 33.0                       69.0 62     3   1         3   36 33                 69
253161 SD     school 4624540 14001   Florence 14-1 462454000589 3 Florence Middle School   Regular School No Middle 06 08 2018   pk_12_total 55.0                   1.0   32.0 24.0                       56.0 55                   1   32 24                 56
253207 SD     school 4621400 6002   Frederick Area 06-2 462140000189 2 Frederick Elementary   Regular School No Elementary KG 06 2018   pk_12_total 80.0     2.0             6.0   44.0 44.0                       88.0 80     2             6   44 44                 88
253208 SD     school 4621400 6002   Frederick Area 06-2 462140000190 1 Frederick High School   Regular School No High 09 12 2018   pk_12_total 44.0     1.0             1.0   25.0 21.0                       46.0 44     1             1   25 21                 46
253209 SD     school 4621400 6002   Frederick Area 06-2 462140000957 3 Frederick Jr High   Regular School No Middle 07 08 2018   pk_12_total 26.0                       17.0 9.0                       26.0 26                       17 9                 26
253283 SD     school 4625500 33001   Freeman 33-1 462550000219 2 Freeman Elem   Regular School No Elementary KG 06 2018   pk_12_total 127.0 2.0 15.0 1.0   1.0         3.0   69.0 80.0                       149.0 127 2 15 1   1         3   69 80                 149
253284 SD     school 4625500 33001   Freeman 33-1 462550000220 1 Freeman High School   Regular School No High 09 12 2018   pk_12_total 78.0   2.0               1.0   31.0 50.0                       81.0 78   2               1   31 50                 81
253285 SD     school 4625500 33001   Freeman 33-1 462550000842 5 Freeman Jr High   Regular School No Middle 07 08 2018   pk_12_total 28.0   3.0               2.0   16.0 17.0                       33.0 28   3               2   16 17                 33
253286 SD     school 4625500 33001   Freeman 33-1 462550000221 3 Tschetter Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 23.0                       15.0 8.0                       23.0 23                       15 8                 23
253287 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 27.0                       13.0 14.0                       27.0 27                       13 14                 27
253335 SD     school 4626370 49004   Garretson 49-4 462637000223 2 Garretson Elementary   Regular School No Elementary PK 05 2018   pk_12_total 206.0   8.0 7.0   1.0         9.0   109.0 122.0                       231.0 206   8 7   1         9   109 122                 231
253336 SD     school 4626370 49004   Garretson 49-4 462637000224 1 Garretson High School   Regular School No High 09 12 2018   pk_12_total 137.0 2.0 11.0 2.0   1.0         6.0   89.0 70.0                       159.0 137 2 11 2   1         6   89 70                 159
253337 SD     school 4626370 49004   Garretson 49-4 462637000843 3 Garretson Middle School   Regular School No Middle 06 08 2018   pk_12_total 105.0   1.0 1.0   1.0         5.0   55.0 58.0                       113.0 105   1 1   1         5   55 58                 113
253383 SD     school 4626490 63001   Gayville-Volin 63-1 462649000228 2 Gayville-Volin Elementary   Regular School No Elementary PK 06 2018   pk_12_total 159.0   10.0     1.0         3.0   92.0 81.0                       173.0 159   10     1         3   92 81                 173
253384 SD     school 4626490 63001   Gayville-Volin 63-1 462649000227 1 Gayville-Volin Hi Sch   Regular School No High 09 12 2018   pk_12_total 84.0   3.0 1.0             5.0   47.0 46.0                       93.0 84   3 1             5   47 46                 93
253385 SD     school 4626490 63001   Gayville-Volin 63-1 462649000844 3 Gayville-Volin JH   Regular School No Middle 07 08 2018   pk_12_total 35.0   2.0               4.0   22.0 19.0                       41.0 35   2               4   22 19                 41
253431 SD     school 4626970 53001   Gettysburg 53-1 462697000231 2 Gettysburg Elem   Regular School No Elementary KG 06 2018   pk_12_total 108.0   4.0 3.0             4.0   64.0 55.0                       119.0 108   4 3             4   64 55                 119
253432 SD     school 4626970 53001   Gettysburg 53-1 462697000232 1 Gettysburg High School   Regular School No High 09 12 2018   pk_12_total 67.0 1.0 3.0 4.0             2.0   37.0 40.0                       77.0 67 1 3 4             2   37 40                 77
253433 SD     school 4626970 53001   Gettysburg 53-1 462697000959 3 Gettysburg Junior High   Regular School No Middle 07 08 2018   pk_12_total 38.0 1.0 2.0 6.0                 22.0 25.0                       47.0 38 1 2 6                 22 25                 47
253479 SD     school 4629880 26004   Gregory 26-4 462988000238 2 Gregory Elementary School   Regular School No Elementary KG 05 2018   pk_12_total 143.0 1.0 4.0 24.0   4.0       1.0 7.0   92.0 92.0                       184.0 143 1 4 24   4       1 7   92 92                 184
253480 SD     school 4629880 26004   Gregory 26-4 462988000239 1 Gregory High School   Regular School No High 09 12 2018   pk_12_total 88.0   2.0 12.0   2.0       1.0     64.0 41.0                       105.0 88   2 12   2       1     64 41                 105
253481 SD     school 4629880 26004   Gregory 26-4 462988001296 4 Gregory Jr High School   Regular School No Middle 06 08 2018   pk_12_total 59.0 1.0 1.0 13.0   4.0         2.0   36.0 44.0                       80.0 59 1 1 13   4         2   36 44                 80
253527 SD     school 4600045 6006   Groton Area 460004501156 2 Groton Area Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 277.0   2.0 3.0   2.0         1.0   161.0 124.0                       285.0 277   2 3   2         1   161 124                 285
253528 SD     school 4600045 6006   Groton Area 460004501155 1 Groton Area High School   Regular School No High 09 12 2018   pk_12_total 157.0 3.0 2.0 2.0   1.0             73.0 92.0                       165.0 157 3 2 2   1             73 92                 165
253529 SD     school 4600045 6006   Groton Area 460004501157 4 Groton Area MS   Regular School No Middle 06 08 2018   pk_12_total 125.0   1.0 1.0                 59.0 68.0                       127.0 125   1 1                 59 68                 127
253589 SD     school 4630490 27001   Haakon 27-1 463049000647 8 Milesville Elem   Regular School No Elementary KG 08 2018   pk_12_total 10.0                       6.0 4.0                       10.0 10                       6 4                 10
253590 SD     school 4630490 27001   Haakon 27-1 463049000255 2 Philip Elementary School   Regular School No Elementary KG 06 2018   pk_12_total 130.0   4.0 1.0   1.0         9.0   75.0 70.0                       145.0 130   4 1   1         9   75 70                 145
253591 SD     school 4630490 27001   Haakon 27-1 463049000256 1 Philip High School   Regular School No High 09 12 2018   pk_12_total 86.0   1.0 7.0   1.0         5.0   53.0 47.0                       100.0 86   1 7   1         5   53 47                 100
253592 SD     school 4630490 27001   Haakon 27-1 463049000247 3 Philip Junior High   Regular School No Middle 07 08 2018   pk_12_total 40.0 1.0   2.0             2.0   23.0 22.0                       45.0 40 1   2             2   23 22                 45
253639 SD     school 4630800 28003   Hamlin 28-3 463080001111 9 Hamlin Elementary   Regular School No Elementary PK 05 2018   pk_12_total 411.0 3.0 10.0 2.0   1.0         3.0   241.0 189.0                       430.0 411 3 10 2   1         3   241 189                 430
253640 SD     school 4630800 28003   Hamlin 28-3 463080000260 1 Hamlin Hi Sch   Regular School No High 09 12 2018   pk_12_total 199.0 1.0 3.0     1.0         1.0   107.0 98.0                       205.0 199 1 3     1         1   107 98                 205
253641 SD     school 4630800 28003   Hamlin 28-3 463080000259 2 Hamlin Middle School   Regular School No Middle 06 08 2018   pk_12_total 170.0   6.0               4.0   99.0 81.0                       180.0 170   6               4   99 81                 180
253729 SD     school 4602640 30001   Hanson 30-1 460264001272 7 Hanson Alternative Colony High School   Regular School No High 09 12 2018   pk_12_total 7.0                       4.0 3.0                       7.0 7                       4 3                 7
253730 SD     school 4602640 30001   Hanson 30-1 460264000876 6 Hanson Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 175.0   4.0               5.0   88.0 96.0                       184.0 175   4               5   88 96                 184
253731 SD     school 4602640 30001   Hanson 30-1 460264000017 1 Hanson High School   Regular School No High 09 12 2018   pk_12_total 96.0 1.0 3.0     1.0         3.0   57.0 47.0                       104.0 96 1 3     1         3   57 47                 104
253732 SD     school 4602640 30001   Hanson 30-1 460264000018 2 Hanson Middle School   Regular School No Middle 06 08 2018   pk_12_total 87.0   2.0 1.0                 52.0 38.0                       90.0 87   2 1                 52 38                 90
253733 SD     school 4602640 30001   Hanson 30-1 460264000015 4 Millbrook Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 10.0                       6.0 4.0                       10.0 10                       6 4                 10
253734 SD     school 4602640 30001   Hanson 30-1 460264000875 5 Oaklane Colony   Regular School No Elementary KG 08 2018   pk_12_total 29.0   1.0                   15.0 15.0                       30.0 29   1                   15 15                 30
253811 SD     school 4609300 31001   Harding County 31-1 460930000087 2 Buffalo Elementary   Regular School No Elementary KG 05 2018   pk_12_total 75.0 1.0   1.0             2.0   36.0 43.0                       79.0 75 1   1             2   36 43                 79
253812 SD     school 4609300 31001   Harding County 31-1 460930000701 8 Camp Crook Elementary   Regular School No Elementary KG 08 2018   pk_12_total 12.0                       5.0 7.0                       12.0 12                       5 7                 12
253813 SD     school 4609300 31001   Harding County 31-1 460930000088 1 Harding County High School   Regular School No High 09 12 2018   pk_12_total 58.0     1.0                 25.0 34.0                       59.0 58     1                 25 34                 59
253814 SD     school 4609300 31001   Harding County 31-1 460930000887 3 Harding County MS   Regular School No Middle 06 08 2018   pk_12_total 36.0     1.0                 21.0 16.0                       37.0 36     1                 21 16                 37
253815 SD     school 4609300 31001   Harding County 31-1 460930000667 6 Ludlow Elementary   Regular School No Elementary KG 08 2018   pk_12_total 8.0                       2.0 6.0                       8.0 8                       2 6                 8
253947 SD     school 4631350 41002   Harrisburg 41-2 463135001335 7 Endeavor Elem   Regular School No Elementary KG 05 2018   pk_12_total 458.0 11.0 11.0 5.0   19.0         17.0   274.0 247.0                       521.0 458 11 11 5   19         17   274 247                 521
253948 SD     school 4631350 41002   Harrisburg 41-2 463135001169 4 Explorer Elementary   Regular School No Elementary PK 05 2018   pk_12_total 369.0 20.0 17.0 9.0   8.0         20.0   228.0 215.0                       443.0 369 20 17 9   8         20   228 215                 443
253949 SD     school 4631350 41002   Harrisburg 41-2 463135001318 6 Freedom Elementary   Regular School No Elementary KG 05 2018   pk_12_total 405.0 3.0 12.0 1.0   2.0       1.0 18.0   214.0 228.0                       442.0 405 3 12 1   2       1 18   214 228                 442
253950 SD     school 4631350 41002   Harrisburg 41-2 463135000264 1 Harrisburg High School   Regular School No High 09 12 2018   pk_12_total 900.0 16.0 21.0 9.0   11.0         29.0   524.0 462.0                       986.0 900 16 21 9   11         29   524 462                 986
253951 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No Middle 06 08 2018   pk_12_total 580.0 9.0 19.0 4.0   15.0         21.0   335.0 313.0                       648.0 580 9 19 4   15         21   335 313                 648
253952 SD     school 4631350 41002   Harrisburg 41-2 463135000847 3 Harrisburg South MS   Regular School No Middle 06 08 2018   pk_12_total 365.0 9.0 10.0     1.0         12.0   193.0 204.0                       397.0 365 9 10     1         12   193 204                 397
253953 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School No Elementary KG 05 2018   pk_12_total 177.0 8.0 8.0     5.0         7.0   102.0 103.0                       205.0 177 8 8     5         7   102 103                 205
253954 SD     school 4631350 41002   Harrisburg 41-2 463135001288 5 Journey Elementary   Regular School No Elementary KG 05 2018   pk_12_total 369.0 4.0 7.0 4.0   8.0         7.0   199.0 200.0                       399.0 369 4 7 4   8         7   199 200                 399
253955 SD     school 4631350 41002   Harrisburg 41-2 463135000263 2 Liberty Elementary   Regular School No Elementary PK 05 2018   pk_12_total 471.0 7.0 11.0 5.0   3.0         13.0   277.0 233.0                       510.0 471 7 11 5   3         13   277 233                 510
254007 SD     school 4632340 14002   Henry 14-2 463234000275 2 Henry Elementary   Regular School No Elementary PK 04 2018   pk_12_total 63.0 1.0       1.0             26.0 39.0                       65.0 63 1       1             26 39                 65
254008 SD     school 4632340 14002   Henry 14-2 463234000276 1 Henry High School   Regular School No High 09 12 2018   pk_12_total 54.0 2.0   1.0                 29.0 28.0                       57.0 54 2   1                 29 28                 57
254009 SD     school 4632340 14002   Henry 14-2 463234001047 3 Henry MS   Regular School No Middle 05 08 2018   pk_12_total 52.0 1.0 1.0     1.0             24.0 31.0                       55.0 52 1 1     1             24 31                 55
254055 SD     school 4632430 10001   Herreid 10-1 463243000277 2 Herreid Elem   Regular School No Elementary KG 05 2018   pk_12_total 45.0     1.0             1.0   26.0 21.0                       47.0 45     1             1   26 21                 47
254056 SD     school 4632430 10001   Herreid 10-1 463243000278 1 Herreid Hi Sch   Regular School No High 09 12 2018   pk_12_total 41.0   1.0 1.0                 21.0 22.0                       43.0 41   1 1                 21 22                 43
254057 SD     school 4632430 10001   Herreid 10-1 463243000910 3 Herreid Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 16.0   1.0 1.0             1.0   13.0 6.0                       19.0 16   1 1             1   13 6                 19
254103 SD     school 4680440 34002   Highmore-Harrold 468044000323 2 Highmore Elementary   Regular School No Elementary PK 06 2018   pk_12_total 107.0 1.0 2.0 14.0             3.0   60.0 67.0                       127.0 107 1 2 14             3   60 67                 127
254104 SD     school 4680440 34002   Highmore-Harrold 468044000324 1 Highmore-Harrold High School   Regular School No High 09 12 2018   pk_12_total 63.0   2.0 10.0             3.0   39.0 39.0                       78.0 63   2 10             3   39 39                 78
254105 SD     school 4680440 34002   Highmore-Harrold 468044001049 3 Highmore-Harrold Junior High   Regular School No Middle 07 08 2018   pk_12_total 35.0     1.0             5.0   27.0 14.0                       41.0 35     1             5   27 14                 41
254151 SD     school 4633360 51002   Hill City 51-2 463336000279 2 Hill City Elementary   Regular School No Elementary PK 05 2018   pk_12_total 133.0   47.0 5.0             9.0   95.0 99.0                       194.0 133   47 5             9   95 99                 194
254152 SD     school 4633360 51002   Hill City 51-2 463336000280 1 Hill City High School   Regular School No High 09 12 2018   pk_12_total 111.0 1.0 23.0 5.0                 65.0 75.0                       140.0 111 1 23 5                 65 75                 140
254153 SD     school 4633360 51002   Hill City 51-2 463336000848 4 Hill City Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 104.0   18.0 3.0             1.0   69.0 57.0                       126.0 104   18 3             1   69 57                 126
254227 SD     school 4600046 56006   Hitchcock-Tulare 460004601166 4 Glendale Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 23.0                       12.0 11.0                       23.0 23                       12 11                 23
254228 SD     school 4600046 56006   Hitchcock-Tulare 460004601167 5 Hitchcock-Tulare Elementary   Regular School No Elementary KG 06 2018   pk_12_total 97.0   1.0 1.0                 57.0 42.0                       99.0 97   1 1                 57 42                 99
254229 SD     school 4600046 56006   Hitchcock-Tulare 460004601163 1 Hitchcock-Tulare HS   Regular School No High 09 12 2018   pk_12_total 50.0                       27.0 23.0                       50.0 50                       27 23                 50
254230 SD     school 4600046 56006   Hitchcock-Tulare 460004601164 2 Hitchcock-Tulare JH   Regular School No Middle 07 08 2018   pk_12_total 31.0     1.0                 19.0 13.0                       32.0 31     1                 19 13                 32
254231 SD     school 4600046 56006   Hitchcock-Tulare 460004601165 3 Spink Colony Elem   Regular School No Elementary KG 08 2018   pk_12_total 28.0                       14.0 14.0                       28.0 28                       14 14                 28
254279 SD     school 4634480 23002   Hot Springs 23-2 463448000287 2 Hot Springs Elementary   Regular School No Elementary PK 05 2018   pk_12_total 264.0 1.0 14.0 33.0   5.0       2.0 56.0   198.0 177.0                       375.0 264 1 14 33   5       2 56   198 177                 375
254280 SD     school 4634480 23002   Hot Springs 23-2 463448000288 1 Hot Springs Hi Sch   Regular School No High 09 12 2018   pk_12_total 200.0 6.0 12.0 23.0   2.0       1.0 15.0   130.0 129.0                       259.0 200 6 12 23   2       1 15   130 129                 259
254281 SD     school 4634480 23002   Hot Springs 23-2 463448000911 6 Hot Springs Middle Sch   Regular School No Middle 06 08 2018   pk_12_total 140.0 1.0 7.0 16.0   2.0         19.0   89.0 96.0                       185.0 140 1 7 16   2         19   89 96                 185
254327 SD     school 4634600 53002   Hoven 53-2 463460000297 2 Hoven Elementary   Regular School No Elementary PK 06 2018   pk_12_total 55.0     3.0                 29.0 29.0                       58.0 55     3                 29 29                 58
254328 SD     school 4634600 53002   Hoven 53-2 463460000298 1 Hoven High School   Regular School No High 09 12 2018   pk_12_total 31.0     3.0                 15.0 19.0                       34.0 31     3                 15 19                 34
254329 SD     school 4634600 53002   Hoven 53-2 463460000912 3 Hoven Jr High School   Regular School No Middle 07 08 2018   pk_12_total 18.0                       8.0 10.0                       18.0 18                       8 10                 18
254389 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No Elementary KG 06 2018   pk_12_total 163.0 1.0 6.0 1.0                 95.0 76.0                       171.0 163 1 6 1                 95 76                 171
254390 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School No High 09 12 2018   pk_12_total 99.0 1.0 6.0                   57.0 49.0                       106.0 99 1 6                   57 49                 106
254391 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School No Middle 07 08 2018   pk_12_total 52.0 3.0 1.0               2.0   33.0 25.0                       58.0 52 3 1               2   33 25                 58
254392 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No Elementary KG 08 2018   pk_12_total 28.0                       13.0 15.0                       28.0 28                       13 15                 28
254495 SD     school 4635480 2002   Huron 02-2 463548001370 18 Buchanan K-1 Center   Regular School No Elementary KG 01 2018   pk_12_total 177.0 2.0 162.0 7.0   111.0       1.0 18.0   254.0 224.0                       478.0 177 2 162 7   111       1 18   254 224                 478
254496 SD     school 4635480 2002   Huron 02-2 463548000312 13 Huron Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 20.0                       13.0 7.0                       20.0 20                       13 7                 20
254497 SD     school 4635480 2002   Huron 02-2 463548000313 1 Huron High School   Regular School No High 09 12 2018   pk_12_total 375.0 14.0 145.0 6.0   176.0       3.0 2.0   395.0 326.0                       721.0 375 14 145 6   176       3 2   395 326                 721
254498 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No Middle 06 08 2018   pk_12_total 279.0 8.0 105.0 5.0   110.0       2.0 6.0   259.0 256.0                       515.0 279 8 105 5   110       2 6   259 256                 515
254499 SD     school 4635480 2002   Huron 02-2 463548001369 19 Madison 2-3 Center   Regular School No Elementary 02 03 2018   pk_12_total 190.0 4.0 126.0 7.0   92.0         13.0   245.0 187.0                       432.0 190 4 126 7   92         13   245 187                 432
254500 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2018   pk_12_total 15.0                       10.0 5.0                       15.0 15                       10 5                 15
254501 SD     school 4635480 2002   Huron 02-2 463548001373 20 Washington 4-5 Center   Regular School No Elementary 04 05 2018   pk_12_total 190.0 8.0 95.0 5.0   73.0         12.0   213.0 170.0                       383.0 190 8 95 5   73         12   213 170                 383
254593 SD     school 4636060 22006   Ipswich Public 22-6 463606001085 5 Deerfield Colony Elem   Regular School No Elementary PK 08 2018   pk_12_total 24.0                       13.0 11.0                       24.0 24                       13 11                 24
254594 SD     school 4636060 22006   Ipswich Public 22-6 463606000332 2 Ipswich Elem   Regular School No Elementary PK 05 2018   pk_12_total 179.0 1.0 6.0 1.0   1.0         3.0   90.0 101.0                       191.0 179 1 6 1   1         3   90 101                 191
254595 SD     school 4636060 22006   Ipswich Public 22-6 463606000333 1 Ipswich Hi Sch   Regular School No High 09 12 2018   pk_12_total 97.0   3.0     1.0         3.0   46.0 58.0                       104.0 97   3     1         3   46 58                 104
254596 SD     school 4636060 22006   Ipswich Public 22-6 463606000914 4 Ipswich MS   Regular School No Middle 06 08 2018   pk_12_total 76.0 1.0 2.0     1.0         3.0   52.0 31.0                       83.0 76 1 2     1         3   52 31                 83
254597 SD     school 4636060 22006   Ipswich Public 22-6 463606001086 6 Pembrook Colony Elem   Regular School No Elementary PK 08 2018   pk_12_total 22.0                       14.0 8.0                       22.0 22                       14 8                 22
254598 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School No Elementary PK 08 2018   pk_12_total 18.0                       12.0 6.0                       18.0 18                       12 6                 18

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