Data source: Big Local News · About: Big Local

669 rows where grade = "pk_12_total", state = "SD" and year = 2017 sorted by district_nces_id

View and edit SQL

year

  • 2017 · 669

grade

  • pk_12_total · 669
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
3012384 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   pk_12_total 335.0 6.0 25.0               12.0   205.0 173.0                       378.0 335 6 25               12   205 173                 378
3012385 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No High 09 12 2017   pk_12_total 308.0   19.0 4.0           1.0 3.0   169.0 166.0                       335.0 308   19 4           1 3   169 166                 335
3012386 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No Middle 06 08 2017   pk_12_total 202.0   13.0               3.0   114.0 104.0                       218.0 202   13               3   114 104                 218
3016704 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2017   pk_12_total 84.0 2.0 3.0 25.0             1.0   57.0 58.0                       115.0 84 2 3 25             1   57 58                 115
3016705 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No High 09 12 2017   pk_12_total 51.0   4.0 18.0             2.0   34.0 41.0                       75.0 51   4 18             2   34 41                 75
3016706 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School No Middle 07 08 2017   pk_12_total 24.0   1.0 3.0                 16.0 12.0                       28.0 24   1 3                 16 12                 28
3010846 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No Elementary KG 06 2017   pk_12_total 180.0 4.0 3.0                   106.0 81.0                       187.0 180 4 3                   106 81                 187
3010847 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School No High 09 12 2017   pk_12_total 100.0 1.0 4.0                   49.0 56.0                       105.0 100 1 4                   49 56                 105
3010848 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School No Middle 07 08 2017   pk_12_total 39.0   1.0               2.0   25.0 17.0                       42.0 39   1               2   25 17                 42
3010849 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No Elementary KG 08 2017   pk_12_total 29.0                       12.0 17.0                       29.0 29                       12 17                 29
3006496 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2017   pk_12_total 202.0   10.0 1.0   1.0         9.0   106.0 117.0                       223.0 202   10 1   1         9   106 117                 223
3006497 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School No High 09 12 2017   pk_12_total 74.0 1.0 3.0     1.0             40.0 39.0                       79.0 74 1 3     1             40 39                 79
3006498 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No Middle 07 08 2017   pk_12_total 45.0   3.0               2.0   24.0 26.0                       50.0 45   3               2   24 26                 50
3008576 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No Elementary PK 05 2017   pk_12_total 249.0 2.0 18.0 4.0           1.0     141.0 133.0                       274.0 249 2 18 4           1     141 133                 274
3008577 SD     school 4600036 19004   Deuel 19-4 460003601013 4 Clear Lake Middle School   Regular School No Middle 06 08 2017   pk_12_total 90.0 1.0 2.0 1.0                 52.0 42.0                       94.0 90 1 2 1                 52 42                 94
3008578 SD     school 4600036 19004   Deuel 19-4 460003601010 1 Deuel High School   Regular School No High 09 12 2017   pk_12_total 138.0   1.0             1.0     71.0 69.0                       140.0 138   1             1     71 69                 140
3007450 SD     school 4600041 45004   Britton-Hecla 45-4 460004101140 2 Britton-Hecla Elementary School   Regular School No Elementary KG 06 2017   pk_12_total 185.0 3.0 5.0 4.0   2.0         8.0   103.0 104.0                       207.0 185 3 5 4   2         8   103 104                 207
3007451 SD     school 4600041 45004   Britton-Hecla 45-4 460004101141 1 Britton-Hecla High School   Regular School No High 09 12 2017   pk_12_total 89.0 2.0 1.0 5.0           1.0 1.0   46.0 53.0                       99.0 89 2 1 5           1 1   46 53                 99
3007452 SD     school 4600041 45004   Britton-Hecla 45-4 460004101142 3 Britton-Hecla Junior High   Regular School No Middle 07 08 2017   pk_12_total 36.0 1.0   1.0   1.0         1.0   29.0 11.0                       40.0 36 1   1   1         1   29 11                 40
3007453 SD     school 4600041 45004   Britton-Hecla 45-4 460004101143 4 Sunset Colony   Regular School No Elementary KG 08 2017   pk_12_total 27.0                       14.0 13.0                       27.0 27                       14 13                 27
3007454 SD     school 4600041 45004   Britton-Hecla 45-4 460004101364 6 Sunset Colony High School   Regular School No High 09 12 2017   pk_12_total 15.0                       9.0 6.0                       15.0 15                       9 6                 15
3007455 SD     school 4600041 45004   Britton-Hecla 45-4 460004101180 5 Westwood Colony   Regular School No Elementary KG 08 2017   pk_12_total 22.0                       12.0 10.0                       22.0 22                       12 10                 22
3006446 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No Elementary KG 05 2017   pk_12_total 21.0   3.0 5.0             1.0   19.0 11.0                       30.0 21   3 5             1   19 11                 30
3006447 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No Elementary KG 06 2017   pk_12_total 95.0   1.0 2.0   1.0         1.0   54.0 46.0                       100.0 95   1 2   1         1   54 46                 100
3006448 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200656 7 Sully Buttes High School   Regular School No High 09 12 2017   pk_12_total 66.0   1.0 4.0   1.0         5.0   37.0 40.0                       77.0 66   1 4   1         5   37 40                 77
3006449 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200939 6 Sully Buttes Junior High   Regular School No Middle 07 08 2017   pk_12_total 38.0   1.0 1.0             3.0   31.0 12.0                       43.0 38   1 1             3   31 12                 43
3009984 SD     school 4600045 6006   Groton Area 460004501156 2 Groton Area Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 279.0 3.0 4.0 1.0   7.0         3.0   158.0 139.0                       297.0 279 3 4 1   7         3   158 139                 297
3009985 SD     school 4600045 6006   Groton Area 460004501155 1 Groton Area High School   Regular School No High 09 12 2017   pk_12_total 161.0 7.0 1.0 1.0   4.0             81.0 93.0                       174.0 161 7 1 1   4             81 93                 174
3009986 SD     school 4600045 6006   Groton Area 460004501157 4 Groton Area MS   Regular School No Middle 06 08 2017   pk_12_total 124.0 1.0 1.0 1.0   3.0             69.0 61.0                       130.0 124 1 1 1   3             69 61                 130
3010684 SD     school 4600046 56006   Hitchcock-Tulare 460004601166 4 Glendale Colony Elem   Regular School No Elementary KG 08 2017   pk_12_total 20.0                       11.0 9.0                       20.0 20                       11 9                 20
3010685 SD     school 4600046 56006   Hitchcock-Tulare 460004601167 5 Hitchcock-Tulare Elementary   Regular School No Elementary KG 06 2017   pk_12_total 99.0   1.0 1.0                 57.0 44.0                       101.0 99   1 1                 57 44                 101
3010686 SD     school 4600046 56006   Hitchcock-Tulare 460004601163 1 Hitchcock-Tulare HS   Regular School No High 09 12 2017   pk_12_total 48.0                       23.0 25.0                       48.0 48                       23 25                 48
3010687 SD     school 4600046 56006   Hitchcock-Tulare 460004601164 2 Hitchcock-Tulare JH   Regular School No Middle 07 08 2017   pk_12_total 31.0     1.0                 18.0 14.0                       32.0 31     1                 18 14                 32
3010688 SD     school 4600046 56006   Hitchcock-Tulare 460004601165 3 Spink Colony Elem   Regular School No Elementary KG 08 2017   pk_12_total 30.0                       15.0 15.0                       30.0 30                       15 15                 30
3015374 SD     school 4600052 41005   Tea Area 41-5 460005201358 5 Tea Area Frontier Elementary   Regular School No Elementary KG 04 2017   pk_12_total 62.0 9.0 8.0 1.0   2.0         10.0   53.0 39.0                       92.0 62 9 8 1   2         10   53 39                 92
3015375 SD     school 4600052 41005   Tea Area 41-5 460005201235 3 Tea Area High School   Regular School No High 09 12 2017   pk_12_total 407.0 6.0 9.0 7.0   1.0         19.0   238.0 211.0                       449.0 407 6 9 7   1         19   238 211                 449
3015376 SD     school 4600052 41005   Tea Area 41-5 460005200853 2 Tea Area Intermediate/Middle School   Regular School No Middle 05 08 2017   pk_12_total 423.0 12.0 12.0 8.0           1.0 21.0   274.0 203.0                       477.0 423 12 12 8           1 21   274 203                 477
3015377 SD     school 4600052 41005   Tea Area 41-5 460005200388 1 Tea Area Legacy Elementary   Regular School No Elementary KG 04 2017   pk_12_total 628.0 6.0 9.0 7.0   1.0         25.0   357.0 319.0                       676.0 628 6 9 7   1         25   357 319                 676
3015008 SD     school 4600053 54002   Sisseton 54-2 460005301239 1 Sisseton High School   Regular School No High 09 12 2017   pk_12_total 99.0 3.0 10.0 104.0   1.0         4.0   121.0 100.0                       221.0 99 3 10 104   1         4   121 100                 221
3015009 SD     school 4600053 54002   Sisseton 54-2 460005301258 2 Sisseton Middle School   Regular School No Middle 06 08 2017   pk_12_total 55.0 1.0 10.0 118.0   2.0         3.0   106.0 83.0                       189.0 55 1 10 118   2         3   106 83                 189
3015010 SD     school 4600053 54002   Sisseton 54-2 460005301241 3 Westside Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 117.0 1.0 47.0 280.0             55.0   263.0 237.0                       500.0 117 1 47 280             55   263 237                 500
3011998 SD     school 4601026 43007   McCook Central 43-7 460102601281 4 Golden View Colony Elementary   Regular School No Elementary KG 08 2017   pk_12_total 20.0                       9.0 11.0                       20.0 20                       9 11                 20
3011999 SD     school 4601026 43007   McCook Central 43-7 460102600404 2 McCook Central Elementary   Regular School No Elementary PK 05 2017   pk_12_total 186.0   10.0               5.0   121.0 80.0                       201.0 186   10               5   121 80                 201
3012000 SD     school 4601026 43007   McCook Central 43-7 460102601026 1 McCook Central Hi Sch   Regular School No High 09 12 2017   pk_12_total 115.0   4.0               4.0   60.0 63.0                       123.0 115   4               4   60 63                 123
3012001 SD     school 4601026 43007   McCook Central 43-7 460102601034 3 McCook Central Middle School   Regular School No Middle 06 08 2017   pk_12_total 63.0   2.0               2.0   37.0 30.0                       67.0 63   2               2   37 30                 67
3013100 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701030 2 Oldham-Ramona Elementary   Regular School No Elementary PK 06 2017   pk_12_total 84.0   3.0               1.0   45.0 43.0                       88.0 84   3               1   45 43                 88
3013101 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701027 1 Oldham-Ramona High School   Regular School No High 09 12 2017   pk_12_total 35.0                   1.0   25.0 11.0                       36.0 35                   1   25 11                 36
3013102 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701035 3 Oldham-Ramona Junior High School   Regular School No Middle 07 08 2017   pk_12_total 15.0                   1.0   8.0 8.0                       16.0 15                   1   8 8                 16
3013103 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701112 4 Spring Lake Colony Elementary   Regular School No Elementary KG 08 2017   pk_12_total 30.0                       10.0 20.0                       30.0 30                       10 20                 30
3013104 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701339 5 Spring Lake Colony HS   Regular School No High 09 12 2017   pk_12_total 6.0                       4.0 2.0                       6.0 6                       4 2                 6
3014240 SD     school 4601028 62005   Selby Area 62-5 460102801032 2 Selby Elem K-6   Regular School No Elementary PK 06 2017   pk_12_total 95.0   7.0 3.0                 62.0 43.0                       105.0 95   7 3                 62 43                 105
3014241 SD     school 4601028 62005   Selby Area 62-5 460102801028 1 Selby Hi Sch   Regular School No High 09 12 2017   pk_12_total 59.0 1.0 1.0 3.0                 35.0 29.0                       64.0 59 1 1 3                 35 29                 64
3014242 SD     school 4601028 62005   Selby Area 62-5 460102801036 3 Selby Jr Hi   Regular School No Middle 07 08 2017   pk_12_total 37.0     1.0             1.0   20.0 19.0                       39.0 37     1             1   20 19                 39
3006370 SD     school 4602070 6001   Aberdeen 06-1 460207000002 5 C.C. Lee Elementary   Regular School No Elementary KG 05 2017   pk_12_total 346.0 11.0 11.0 10.0   9.0         23.0   226.0 184.0                       410.0 346 11 11 10   9         23   226 184                 410
3006371 SD     school 4602070 6001   Aberdeen 06-1 460207000003 1 Central High School   Regular School No High 09 12 2017   pk_12_total 1044.0 40.0 40.0 87.0   34.0       7.0 11.0   652.0 611.0                       1263.0 1044 40 40 87   34       7 11   652 611                 1263
3006372 SD     school 4602070 6001   Aberdeen 06-1 460207000005 2 Holgate Middle School   Regular School No Middle 06 08 2017   pk_12_total 436.0 11.0 16.0 23.0   16.0         12.0   269.0 245.0                       514.0 436 11 16 23   16         12   269 245                 514
3006373 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No Elementary PK 05 2017   pk_12_total 310.0 2.0 31.0 34.0   19.0         19.0   215.0 200.0                       415.0 310 2 31 34   19         19   215 200                 415
3006374 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School No Elementary KG 05 2017   pk_12_total 309.0 7.0 26.0 22.0   10.0       3.0 29.0   208.0 198.0                       406.0 309 7 26 22   10       3 29   208 198                 406
3006375 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School No Elementary KG 05 2017   pk_12_total 149.0 2.0 9.0 17.0   5.0       1.0 9.0   96.0 96.0                       192.0 149 2 9 17   5       1 9   96 96                 192
3006376 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No Other 05 12 2017   pk_12_total 2.0 1.0 1.0 10.0                 3.0 11.0                       14.0 2 1 1 10                 3 11                 14
3006377 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School No Elementary KG 05 2017   pk_12_total 284.0 9.0 22.0 29.0   20.0         26.0   201.0 189.0                       390.0 284 9 22 29   20         26   201 189                 390
3006378 SD     school 4602070 6001   Aberdeen 06-1 460207000010 10 Simmons Elementary   Regular School No Elementary KG 05 2017   pk_12_total 334.0 9.0 16.0 28.0   8.0       3.0 19.0   225.0 192.0                       417.0 334 9 16 28   8       3 19   225 192                 417
3006379 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No Middle 06 08 2017   pk_12_total 425.0 11.0 24.0 41.0   21.0       3.0 7.0   247.0 285.0                       532.0 425 11 24 41   21       3 7   247 285                 532
3010186 SD     school 4602640 30001   Hanson 30-1 460264001272 7 Hanson Alternative Colony High School   Regular School No High 09 12 2017   pk_12_total 7.0                       2.0 5.0                       7.0 7                       2 5                 7
3010187 SD     school 4602640 30001   Hanson 30-1 460264000876 6 Hanson Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 191.0   5.0               4.0   100.0 100.0                       200.0 191   5               4   100 100                 200
3010188 SD     school 4602640 30001   Hanson 30-1 460264000017 1 Hanson High School   Regular School No High 09 12 2017   pk_12_total 94.0 1.0 1.0     1.0         2.0   53.0 46.0                       99.0 94 1 1     1         2   53 46                 99
3010189 SD     school 4602640 30001   Hanson 30-1 460264000018 2 Hanson Middle School   Regular School No Middle 06 08 2017   pk_12_total 89.0   3.0 1.0             1.0   56.0 38.0                       94.0 89   3 1             1   56 38                 94
3010190 SD     school 4602640 30001   Hanson 30-1 460264000015 4 Millbrook Colony Elementary   Regular School No Elementary KG 08 2017   pk_12_total 12.0                       7.0 5.0                       12.0 12                       7 5                 12
3010191 SD     school 4602640 30001   Hanson 30-1 460264000875 5 Oaklane Colony   Regular School No Elementary KG 08 2017   pk_12_total 29.0   1.0                   14.0 16.0                       30.0 29   1                   14 16                 30
3006622 SD     school 4603720 38001   Arlington 38-1 460372000021 2 Arlington Elementary   Regular School No Elementary PK 06 2017   pk_12_total 139.0 2.0 9.0 1.0   1.0         2.0   66.0 88.0                       154.0 139 2 9 1   1         2   66 88                 154
3006623 SD     school 4603720 38001   Arlington 38-1 460372000022 1 Arlington High School   Regular School No High 09 12 2017   pk_12_total 73.0   1.0               1.0   38.0 37.0                       75.0 73   1               1   38 37                 75
3006624 SD     school 4603720 38001   Arlington 38-1 460372000877 3 Arlington Junior High School   Regular School No Middle 07 08 2017   pk_12_total 44.0   1.0                   30.0 15.0                       45.0 44   1                   30 15                 45
3006625 SD     school 4603720 38001   Arlington 38-1 460372001381 4 Arlington PreSchool   Regular School No Elementary PK PK 2017   pk_12_total 18.0   1.0                   11.0 8.0                       19.0 18   1                   11 8                 19
3006672 SD     school 4603780 21001   Armour 21-1 460378000023 2 Armour Elementary   Regular School No Elementary KG 05 2017   pk_12_total 65.0 4.0 1.0 2.0             2.0   44.0 30.0                       74.0 65 4 1 2             2   44 30                 74
3006673 SD     school 4603780 21001   Armour 21-1 460378000024 1 Armour High School   Regular School No High 09 12 2017   pk_12_total 48.0 1.0 3.0 2.0                 24.0 30.0                       54.0 48 1 3 2                 24 30                 54
3006674 SD     school 4603780 21001   Armour 21-1 460378000878 3 Armour Middle School   Regular School No Middle 06 08 2017   pk_12_total 42.0   1.0 2.0                 25.0 20.0                       45.0 42   1 2                 25 20                 45
3014142 SD     school 4603932 55005   Sanborn Central 55-5 460393201162 6 Sanborn Central Elementary   Regular School No Elementary PK 05 2017   pk_12_total 82.0   1.0 2.0             4.0   54.0 35.0                       89.0 82   1 2             4   54 35                 89
3014143 SD     school 4603932 55005   Sanborn Central 55-5 460393200099 1 Sanborn Central High School   Regular School No High 09 12 2017   pk_12_total 42.0   1.0 1.0             1.0   25.0 20.0                       45.0 42   1 1             1   25 20                 45
3014144 SD     school 4603932 55005   Sanborn Central 55-5 460393200102 2 Sanborn Central Middle School   Regular School No Middle 06 08 2017   pk_12_total 36.0   1.0 1.0           1.0 1.0   18.0 22.0                       40.0 36   1 1           1 1   18 22                 40
3014145 SD     school 4603932 55005   Sanborn Central 55-5 460393200120 5 Upland Colony   Regular School No Elementary KG 08 2017   pk_12_total 27.0                       14.0 13.0                       27.0 27                       14 13                 27
3006734 SD     school 4604270 4001   Avon 04-1 460427000028 2 Avon Elementary School   Regular School No Elementary KG 06 2017   pk_12_total 118.0   4.0 7.0             4.0   67.0 66.0                       133.0 118   4 7             4   67 66                 133
3006735 SD     school 4604270 4001   Avon 04-1 460427000029 1 Avon High School   Regular School No High 09 12 2017   pk_12_total 77.0   4.0 3.0             1.0   46.0 39.0                       85.0 77   4 3             1   46 39                 85
3006736 SD     school 4604270 4001   Avon 04-1 460427000829 5 Avon Jr High School   Regular School No Middle 07 08 2017   pk_12_total 33.0     2.0             1.0   16.0 20.0                       36.0 33     2             1   16 20                 36
3006737 SD     school 4604270 4001   Avon 04-1 460427001325 6 Avon PK   Regular School No Elementary PK PK 2017   pk_12_total 10.0   1.0                   3.0 8.0                       11.0 10   1                   3 8                 11
3006784 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School No Elementary PK 05 2017   pk_12_total 263.0   7.0 1.0   2.0         4.0   140.0 137.0                       277.0 263   7 1   2         4   140 137                 277
3006785 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School No High 09 12 2017   pk_12_total 137.0   4.0     2.0         1.0   84.0 60.0                       144.0 137   4     2         1   84 60                 144
3006786 SD     school 4604680 49001   Baltic 49-1 460468000986 3 Baltic Middle School   Regular School No Middle 06 08 2017   pk_12_total 113.0 2.0 4.0     1.0             62.0 58.0                       120.0 113 2 4     1             62 58                 120
3006860 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2017   pk_12_total 26.0   2.0 4.0             1.0   21.0 12.0                       33.0 26   2 4             1   21 12                 33
3006861 SD     school 4605610 9001   Belle Fourche 09-1 460561000038 1 Belle Fourche HS   Regular School No High 09 12 2017   pk_12_total 321.0   21.0 11.0   6.0         12.0   189.0 182.0                       371.0 321   21 11   6         12   189 182                 371
3006862 SD     school 4605610 9001   Belle Fourche 09-1 460561001117 7 Belle Fourche MS   Regular School No Middle 05 08 2017   pk_12_total 388.0   29.0 5.0             22.0   231.0 213.0                       444.0 388   29 5             22   231 213                 444
3006863 SD     school 4605610 9001   Belle Fourche 09-1 460561000289 8 North Park Elementary   Regular School No Elementary KG KG 2017   pk_12_total 109.0   5.0 3.0             3.0   62.0 58.0                       120.0 109   5 3             3   62 58                 120
3006864 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School No Elementary 01 04 2017   pk_12_total 355.0 1.0 23.0 6.0             18.0   222.0 181.0                       403.0 355 1 23 6             18   222 181                 403
3006912 SD     school 4606240 3001   Bennett County 03-1 460624000042 1 Bennett County High School   Regular School No High 09 12 2017   pk_12_total 43.0   3.0 88.0   1.0         25.0   84.0 76.0                       160.0 43   3 88   1         25   84 76                 160
3006913 SD     school 4606240 3001   Bennett County 03-1 460624001015 6 Bennett County Jr High   Regular School No Middle 07 08 2017   pk_12_total 16.0   5.0 35.0   1.0         18.0   38.0 37.0                       75.0 16   5 35   1         18   38 37                 75
3006914 SD     school 4606240 3001   Bennett County 03-1 460624000045 3 Martin Elem   Regular School No Elementary PK 06 2017   pk_12_total 55.0   13.0 126.0             68.0   122.0 140.0                       262.0 55   13 126             68   122 140                 262
3006960 SD     school 4606360 61002   Beresford 61-2 460636000047 2 Beresford Elementary   Regular School No Elementary KG 05 2017   pk_12_total 277.0 2.0 9.0     2.0         3.0   149.0 144.0                       293.0 277 2 9     2         3   149 144                 293
3006961 SD     school 4606360 61002   Beresford 61-2 460636000048 1 Beresford High School   Regular School No High 09 12 2017   pk_12_total 212.0 1.0 5.0     3.0         4.0   114.0 111.0                       225.0 212 1 5     3         4   114 111                 225
3006962 SD     school 4606360 61002   Beresford 61-2 460636000051 3 Beresford Middle School   Regular School No Middle 06 08 2017   pk_12_total 142.0 1.0 7.0     1.0         3.0   80.0 74.0                       154.0 142 1 7     1         3   80 74                 154
3006994 SD     school 4606960 25001   Big Stone City 25-1 460696000053 1 Big Stone City Elementary   Regular School No Elementary PK 05 2017   pk_12_total 65.0   4.0 4.0   1.0             38.0 36.0                       74.0 65   4 4   1             38 36                 74
3006995 SD     school 4606960 25001   Big Stone City 25-1 460696000352 3 Big Stone MS   Regular School No Middle 06 08 2017   pk_12_total 23.0 4.0 1.0                   19.0 9.0                       28.0 23 4 1                   19 9                 28

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