enrollments

Data source: Big Local News · About: Big Local

671 rows where grade = "grade_8", state = "SD" and year = 2018 sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 671 ✖

grade ✖

  • grade_8 · 671 ✖
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
251927 251927 SD     school 4636990 61008   Dakota Valley 61-8 463699000809 3 Dakota Valley Middle School   Regular School No Middle 06 08 2018   grade_8 82.0 4.0 5.0 2.0   1.0         4.0   49.0 49.0                       98.0 82 4 5 2   1         4   49 49                 98
259384 259384 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No Middle 06 08 2018   grade_8 82.0 1.0 2.0 8.0   4.0         1.0   59.0 39.0                       98.0 82 1 2 8   4         1   59 39                 98
255437 255437 SD     school 4639600 39002   Madison Central 39-2 463960000364 2 Madison Middle School   Regular School No Middle 06 08 2018   grade_8 80.0 0.0 5.0 1.0   1.0         3.0   48.0 42.0                       90.0 80 0 5 1   1         3   48 42                 90
250578 250578 SD     school 4606960 25001   Big Stone City 25-1 460696000352 3 Big Stone MS   Regular School No Middle 06 08 2018   grade_8 9.0 0.0                     5.0 4.0                       9.0 9 0                     5 4                 9
252552 252552 SD     school 4634440 22005   Edmunds Central 22-5 463444000032 2 Edmunds Central Middle School   Regular School No Middle 07 08 2018   grade_8 9.0   0.0 0.0                 4.0 5.0                       9.0 9   0 0                 4 5                 9
256641 256641 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701035 3 Oldham-Ramona Junior High School   Regular School No Middle 07 08 2018   grade_8 9.0                   0.0   5.0 4.0                       9.0 9                   0   5 4                 9
259147 259147 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No Elementary KG 08 2018   grade_8 0.0     9.0                 3.0 6.0                       9.0 0     9                 3 6                 9
259315 259315 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000059 2 Tripp-Delmont JH   Regular School No Middle 07 08 2018   grade_8 8.0     1.0   0.0             5.0 4.0                       9.0 8     1   0             5 4                 9
259805 259805 SD     school 4676680 18003   Waubay 18-3 467668000945 3 Waubay Middle School   Regular School No Middle 06 08 2018   grade_8 3.0     6.0                 7.0 2.0                       9.0 3     6                 7 2                 9
255218 255218 SD     school 4641550 41004   Lennox 41-4 464155000963 8 Lennox Jr. High   Regular School No Middle 07 08 2018   grade_8 73.0 3.0 1.0 2.0             4.0   40.0 43.0                       83.0 73 3 1 2             4   40 43                 83
250781 250781 SD     school 4607800 22001   Bowdle 22-1 460780000883 3 Bowdle Jr High   Regular School No Middle 07 08 2018   grade_8 8.0                       5.0 3.0                       8.0 8                       5 3                 8
254317 254317 SD     school 4634600 53002   Hoven 53-2 463460000912 3 Hoven Jr High School   Regular School No Middle 07 08 2018   grade_8 8.0                       2.0 6.0                       8.0 8                       2 6                 8
255485 255485 SD     school 4645450 60003   Marion 60-3 464545001050 3 Marion Middle School   Regular School No Middle 06 08 2018   grade_8 5.0   3.0                   4.0 4.0                       8.0 5   3                   4 4                 8
256561 256561 SD     school 4665460 65001   Oglala Lakota 65-1 466546000575 4 Red Shirt School   Regular School No Elementary PK 08 2018   grade_8     0.0 8.0                 5.0 3.0                       8.0     0 8                 5 3                 8
259967 259967 SD     school 4677460 36002   Wessington Springs 36-2 467746000731 5 Spring Valley Elementary   Regular School No Elementary KG 08 2018   grade_8 8.0                       5.0 3.0                       8.0 8                       5 3                 8
252029 252029 SD     school 4618120 49003   Dell Rapids 49-3 461812000837 3 Dell Rapids Middle School   Regular School No Middle 05 08 2018   grade_8 70.0   3.0 3.0             1.0   34.0 43.0                       77.0 70   3 3             1   34 43                 77
255949 255949 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No Middle 06 08 2018   grade_8 67.0   2.0 0.0             1.0   39.0 31.0                       70.0 67   2 0             1   39 31                 70
250710 250710 SD     school 4607400 4002   Bon Homme 04-2 460740000060 18 Hutterische Colony Elementary   Regular School No Elementary KG 08 2018   grade_8 7.0                       5.0 2.0                       7.0 7                       5 2                 7
254045 254045 SD     school 4632430 10001   Herreid 10-1 463243000910 3 Herreid Middle Sch   Regular School No Middle 06 08 2018   grade_8 7.0   0.0 0.0             0.0   4.0 3.0                       7.0 7   0 0             0   4 3                 7
259245 259245 SD     school 4644940 49006   Tri-Valley 49-6 464494000406 3 Tri-Valley Jr High   Regular School No Middle 07 08 2018   grade_8 59.0 4.0 4.0 0.0             1.0   34.0 34.0                       68.0 59 4 4 0             1   34 34                 68
254269 254269 SD     school 4634480 23002   Hot Springs 23-2 463448000911 6 Hot Springs Middle Sch   Regular School No Middle 06 08 2018   grade_8 51.0 1.0 0.0 6.0   2.0         5.0   32.0 33.0                       65.0 51 1 0 6   2         5   32 33                 65
259511 259511 SD     school 4675420 11004   Wagner Community 11-4 467542000942 3 Wagner Middle School   Regular School No Middle 05 08 2018   grade_8 13.0   3.0 40.0   1.0         5.0   29.0 33.0                       62.0 13   3 40   1         5   29 33                 62
258572 258572 SD     school 4600053 54002   Sisseton 54-2 460005301258 2 Sisseton Middle School   Regular School No Middle 06 08 2018   grade_8 16.0 0.0 3.0 40.0   2.0         0.0   34.0 27.0                       61.0 16 0 3 40   2         0   34 27                 61
251630 251630 SD     school 4612940 12002   Clark 12-2 461294001319 7 Silver Creek Colony   Regular School No Elementary KG 08 2018   grade_8 6.0                       3.0 3.0                       6.0 6                       3 3                 6
252247 252247 SD     school 4619170 56002   Doland 56-2 461917000895 2 Doland Junior High   Regular School No Middle 07 08 2018   grade_8 5.0 1.0                     2.0 4.0                       6.0 5 1                     2 4                 6
252929 252929 SD     school 4622940 46002   Faith 46-2 462294000995 6 Faith Jr. High   Regular School No Middle 07 08 2018   grade_8 5.0   1.0 0.0   0.0             4.0 2.0                       6.0 5   1 0   0             4 2                 6
254829 254829 SD     school 4680437 35002   Kadoka Area 35-2 468043701256 10 Long Valley Elementary   Regular School No Elementary KG 08 2018   grade_8 3.0     3.0                 4.0 2.0                       6.0 3     3                 4 2                 6
255888 255888 SD     school 4647100 33002   Menno 33-2 464710000418 4 Maxwell Colony Elementary   Regular School No Elementary KG 08 2018   grade_8 6.0                       4.0 2.0                       6.0 6                       4 2                 6
258669 258669 SD     school 4607670 26005   South Central 26-5 460767000881 2 South Central MS   Regular School No Middle 06 08 2018   grade_8 3.0     3.0             0.0   3.0 3.0                       6.0 3     3             0   3 3                 6
250541 250541 SD     school 4606360 61002   Beresford 61-2 460636000051 3 Beresford Middle School   Regular School No Middle 06 08 2018   grade_8 50.0 1.0 4.0     0.0         1.0   33.0 23.0                       56.0 50 1 4     0         1   33 23                 56
251437 251437 SD     school 4612000 7001   Chamberlain 07-1 461200000889 2 Chamberlain Jr. High   Regular School No Middle 07 08 2018   grade_8 33.0   4.0 16.0   0.0         3.0   24.0 32.0                       56.0 33   4 16   0         3   24 32                 56
251276 251276 SD     school 4610560 41001   Canton 41-1 461056000831 4 Canton Middle School   Regular School No Middle 06 08 2018   grade_8 48.0 2.0 2.0 0.0   1.0         2.0   26.0 29.0                       55.0 48 2 2 0   1         2   26 29                 55
260349 260349 SD     school 4679710 59002   Winner 59-2 467971000782 2 Winner Middle School   Regular School No Middle 06 08 2018   grade_8 40.0   1.0 12.0   2.0             27.0 28.0                       55.0 40   1 12   2             27 28                 55
253629 253629 SD     school 4630800 28003   Hamlin 28-3 463080000259 2 Hamlin Middle School   Regular School No Middle 06 08 2018   grade_8 53.0   1.0               0.0   29.0 25.0                       54.0 53   1               0   29 25                 54
251863 251863 SD     school 4616950 16001   Custer 16-1 461695000992 5 Custer JH   Regular School No Middle 07 08 2018   grade_8 48.0 1.0 0.0 3.0             1.0   22.0 31.0                       53.0 48 1 0 3             1   22 31                 53
258525 258525 SD     school 4666300 5005   Sioux Valley 05-5 466630000613 4 Sioux Valley Middle School   Regular School No Middle 06 08 2018   grade_8 45.0   4.0               3.0   32.0 20.0                       52.0 45   4               3   32 20                 52
259901 259901 SD     school 4676990 18005   Webster Area 467699000947 2 Webster Area Middle School   Regular School No Middle 06 08 2018   grade_8 51.0   0.0 0.0             1.0   26.0 26.0                       52.0 51   0 0             1   26 26                 52
256183 256183 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100450 2 Mobridge Middle School   Regular School No Middle 06 08 2018   grade_8 30.0 1.0 1.0 17.0             2.0   27.0 24.0                       51.0 30 1 1 17             2   27 24                 51
251020 251020 SD     school 4600041 45004   Britton-Hecla 45-4 460004101143 4 Sunset Colony Elementary   Regular School No Elementary KG 08 2018   grade_8 5.0                       1.0 4.0                       5.0 5                       1 4                 5
254911 254911 SD     school 4638220 7002   Kimball 07-2 463822000917 13 Grass Ranch Colony Elem   Regular School No Elementary KG 08 2018   grade_8 5.0                       3.0 2.0                       5.0 5                       3 2                 5
255305 255305 SD     school 4641640 44002   Leola 44-2 464164001069 6 Grassland Colony Elem   Regular School No Elementary KG 08 2018   grade_8 5.0                       3.0 2.0                       5.0 5                       3 2                 5
256779 256779 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative School No High 05 12 2018   grade_8 2.0 0.0 1.0 2.0                 0.0 5.0                       5.0 2 0 1 2                 0 5                 5
257024 257024 SD     school 4680438 11005   Platte-Geddes 11-5 468043801267 10 Platte Colony School   Regular School No Elementary KG 08 2018   grade_8 5.0                       4.0 1.0                       5.0 5                       4 1                 5
257560 257560 SD     school 4663360 54004   Rosholt 54-4 466336000558 3 White Rock Colony Elem   Regular School No Elementary KG 08 2018   grade_8 5.0                       2.0 3.0                       5.0 5                       2 3                 5
258270 258270 SD     school 4666270 49005   Sioux Falls 49-5 466627001138 12 Structured Teaching Program   Special Education School No High 06 12 2018   grade_8 2.0 1.0   1.0             1.0   5.0 0.0                       5.0 2 1   1             1   5 0                 5
258272 258272 SD     school 4666270 49005   Sioux Falls 49-5 466627000609 40 Summit Oaks Day Program   Special Education School No Other KG 12 2018   grade_8 2.0 2.0 1.0                   2.0 3.0                       5.0 2 2 1                   2 3                 5
258768 258768 SD     school 4666930 40002   Spearfish 40-2 466693001346 9 Spearfish Academy at Canyon Hills Elemen   Alternative School No Elementary KG 08 2018   grade_8 5.0   0.0 0.0                 4.0 1.0                       5.0 5   0 0                 4 1                 5
259143 259143 SD     school 4672090 66001   Todd County 66-1 467209000504 9 Lakeview Elementary   Regular School No Elementary KG 08 2018   grade_8 1.0     4.0                 2.0 3.0                       5.0 1     4                 2 3                 5
256563 256563 SD     school 4665460 65001   Oglala Lakota 65-1 466546000574 2 Wolf Creek School   Regular School No Elementary PK 08 2018   grade_8 0.0   0.0 46.0             0.0   30.0 16.0                       46.0 0   0 46             0   30 16                 46
257496 257496 SD     school 4660450 56004   Redfield 56-4 466045000858 2 Redfield Junior High School   Regular School No Middle 07 08 2018   grade_8 41.0 2.0 1.0 2.0                 26.0 20.0                       46.0 41 2 1 2                 26 20                 46
258260 258260 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No Middle 06 08 2018   grade_8 374.0 21.0 22.0 10.0   13.0         15.0   228.0 227.0                       455.0 374 21 22 10   13         15   228 227                 455
250492 250492 SD     school 4606240 3001   Bennett County 03-1 460624001015 6 Bennett County Jr High   Regular School No Middle 07 08 2018   grade_8 7.0   4.0 21.0   1.0         12.0   19.0 26.0                       45.0 7   4 21   1         12   19 26                 45
253095 253095 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School No Middle 06 08 2018   grade_8 23.0 1.0 3.0 15.0   2.0       0.0 1.0   27.0 18.0                       45.0 23 1 3 15   2       0 1   27 18                 45
252637 252637 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000900 3 Elk Point Jefferson Middle School   Regular School No Middle 06 08 2018   grade_8 40.0 1.0 3.0               0.0   20.0 24.0                       44.0 40 1 3               0   20 24                 44
253325 253325 SD     school 4626370 49004   Garretson 49-4 462637000843 3 Garretson Middle School   Regular School No Middle 06 08 2018   grade_8 43.0   0.0 0.0   0.0         1.0   16.0 28.0                       44.0 43   0 0   0         1   16 28                 44
254141 254141 SD     school 4633360 51002   Hill City 51-2 463336000848 4 Hill City Middle Sch   Regular School No Middle 06 08 2018   grade_8 37.0   6.0 1.0             0.0   19.0 25.0                       44.0 37   6 1             0   19 25                 44
255096 255096 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000373 2 Lead-Deadwood Middle School   Regular School No Middle 06 08 2018   grade_8 34.0 1.0 4.0 2.0   0.0         2.0   20.0 23.0                       43.0 34 1 4 2   0         2   20 23                 43
250365 250365 SD     school 4604680 49001   Baltic 49-1 460468000986 3 Baltic Middle School   Regular School No Middle 06 08 2018   grade_8 41.0   0.0 1.0             0.0   19.0 23.0                       42.0 41   0 1             0   19 23                 42
253517 253517 SD     school 4600045 6006   Groton Area 460004501157 4 Groton Area MS   Regular School No Middle 06 08 2018   grade_8 41.0   0.0 0.0                 17.0 24.0                       41.0 41   0 0                 17 24                 41
252248 252248 SD     school 4619170 56002   Doland 56-2 461917001100 4 Hillside Colony Elementary   Regular School No Elementary KG 08 2018   grade_8 4.0                       1.0 3.0                       4.0 4                       1 3                 4
252454 252454 SD     school 4620100 20001   Eagle Butte 20-1 462010000898 6 C-EB Junior High   Regular School No Middle 07 08 2018   grade_8 1.0   1.0 2.0                 2.0 2.0                       4.0 1   1 2                 2 2                 4
255310 255310 SD     school 4641640 44002   Leola 44-2 464164000394 4 Spring Creek Colony Elementary   Regular School No Elementary KG 08 2018   grade_8 4.0                       3.0 1.0                       4.0 4                       3 1                 4
255773 255773 SD     school 4669930 46001   Meade 46-1 466993000736 9 Enning/Union Center Elem   Regular School No Elementary KG 08 2018   grade_8 4.0                   0.0   1.0 3.0                       4.0 4                   0   1 3                 4
258247 258247 SD     school 4666270 49005   Sioux Falls 49-5 466627001123 45 FLEX   Special Education School No High 06 12 2018   grade_8 3.0 0.0 0.0 1.0             0.0   4.0 0.0                       4.0 3 0 0 1             0   4 0                 4
259141 259141 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No Elementary KG 08 2018   grade_8     0.0 4.0             0.0   1.0 3.0                       4.0     0 4             0   1 3                 4
259142 259142 SD     school 4672090 66001   Todd County 66-1 467209000503 8 Klein Elementary   Regular School No Elementary KG 08 2018   grade_8 0.0   0.0 4.0   0.0             1.0 3.0                       4.0 0   0 4   0             1 3                 4
259145 259145 SD     school 4672090 66001   Todd County 66-1 467209000509 14 O'Kreek Elementary   Regular School No Elementary KG 08 2018   grade_8 0.0     4.0                 2.0 2.0                       4.0 0     4                 2 2                 4
260233 260233 SD     school 4679350 12003   Willow Lake 12-3 467935001297 6 Collins Colony Elem   Regular School No Elementary KG 08 2018   grade_8 4.0                       3.0 1.0                       4.0 4                       3 1                 4
258263 258263 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No Middle 06 08 2018   grade_8 289.0 33.0 24.0 8.0   8.0         11.0   193.0 180.0                       373.0 289 33 24 8   8         11   193 180                 373
256782 256782 SD     school 4654300 33003   Parkston 33-3 465430000926 5 Parkston Junior High   Regular School No Middle 07 08 2018   grade_8 36.0   0.0               1.0   21.0 16.0                       37.0 36   0               1   21 16                 37
252156 252156 SD     school 4600036 19004   Deuel 19-4 460003601013 4 Clear Lake Middle School   Regular School No Middle 06 08 2018   grade_8 34.0 0.0 2.0                   18.0 18.0                       36.0 34 0 2                   18 18                 36
258244 258244 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No Middle 06 08 2018   grade_8 258.0 21.0 17.0 19.0   13.0       0.0 15.0   175.0 168.0                       343.0 258 21 17 19   13       0 15   175 168                 343
258856 258856 SD     school 4624850 57001   Stanley County 57-1 462485000841 2 Stanley County Middle School   Regular School No Middle 06 08 2018   grade_8 27.0   1.0 4.0             1.0   21.0 12.0                       33.0 27   1 4             1   21 12                 33
256007 256007 SD     school 4647942 29004   Miller 464794201051 4 Miller Junior High   Regular School No Middle 07 08 2018   grade_8 30.0 1.0       0.0         1.0   13.0 19.0                       32.0 30 1       0         1   13 19                 32
256701 256701 SD     school 4654270 60004   Parker 60-4 465427000925 3 Parker JH   Regular School No Middle 07 08 2018   grade_8 29.0 1.0 0.0 1.0           0.0 1.0   13.0 19.0                       32.0 29 1 0 1           0 1   13 19                 32
260397 260397 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School No Middle 05 08 2018   grade_8 25.0 2.0 3.0               2.0   8.0 24.0                       32.0 25 2 3               2   8 24                 32
259732 259732 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No Middle 07 08 2018   grade_8 276.0 1.0 7.0 21.0   3.0         6.0   147.0 167.0                       314.0 276 1 7 21   3         6   147 167                 314
250870 250870 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No Middle 07 08 2018   grade_8 275.0 7.0 6.0 3.0   8.0       1.0 4.0   175.0 129.0                       304.0 275 7 6 3   8       1 4   175 129                 304
252097 252097 SD     school 4678300 5006   Deubrook Area 05-6 467830000016 2 Deubrook Jr High   Regular School No Middle 07 08 2018   grade_8 28.0 1.0 1.0 0.0   0.0             19.0 11.0                       30.0 28 1 1 0   0             19 11                 30
250130 250130 SD     school 4639540 11001   Andes Central 11-1 463954001080 5 Lakeview Colony Elem   Regular School No Elementary KG 08 2018   grade_8 3.0                       0.0 3.0                       3.0 3                       0 3                 3
251629 251629 SD     school 4612940 12002   Clark 12-2 461294001082 5 Hillcrest Colony Elementary   Regular School No Elementary KG 08 2018   grade_8 3.0                       1.0 2.0                       3.0 3                       1 2                 3
253017 253017 SD     school 4624030 24004   Faulkton Area 462403001158 6 Blumengard Colony Elem   Regular School No Elementary KG 08 2018   grade_8 3.0                       2.0 1.0                       3.0 3                       2 1                 3
253096 253096 SD     school 4624390 50003   Flandreau 50-3 462439001119 6 Pleasant Valley Colony Elem   Regular School No Elementary KG 08 2018   grade_8 3.0                       2.0 1.0                       3.0 3                       2 1                 3
254211 254211 SD     school 4600046 56006   Hitchcock-Tulare 460004601165 3 Spink Colony Elem   Regular School No Elementary KG 08 2018   grade_8 3.0                       1.0 2.0                       3.0 3                       1 2                 3
254825 254825 SD     school 4680437 35002   Kadoka Area 35-2 468043701245 9 Interior Elementary   Regular School No Elementary KG 08 2018   grade_8 0.0   0.0 3.0                 1.0 2.0                       3.0 0   0 3                 1 2                 3
254830 254830 SD     school 4680437 35002   Kadoka Area 35-2 468043701257 11 Midland Elementary   Regular School No Elementary KG 08 2018   grade_8 3.0     0.0                 3.0 0.0                       3.0 3     0                 3 0                 3
255308 255308 SD     school 4641640 44002   Leola 44-2 464164000919 3 Leola MS   Regular School No Middle 07 08 2018   grade_8 3.0                       3.0 0.0                       3.0 3                       3 0                 3
257688 257688 SD     school 4603932 55005   Sanborn Central 55-5 460393200120 5 Upland Colony   Regular School No Elementary KG 08 2018   grade_8 3.0                       3.0 0.0                       3.0 3                       3 0                 3
259144 259144 SD     school 4672090 66001   Todd County 66-1 467209000506 12 Littleburg Elementary   Regular School No Elementary KG 08 2018   grade_8 1.0     2.0                 3.0 0.0                       3.0 1     2                 3 0                 3
252705 252705 SD     school 4621390 5003   Elkton 05-3 462139000901 3 Elkton Junior High   Regular School No Middle 07 08 2018   grade_8 24.0   4.0               1.0   18.0 11.0                       29.0 24   4               1   18 11                 29
255383 255383 SD     school 4644770 42001   Lyman 42-1 464477000812 2 Lyman Middle School   Regular School No Middle 06 08 2018   grade_8 19.0     8.0             2.0   18.0 11.0                       29.0 19     8             2   18 11                 29
255645 255645 SD     school 4646380 15002   McLaughlin 15-2 464638000922 3 McLaughlin Middle School   Regular School No Middle 06 08 2018   grade_8 1.0   1.0 27.0                 18.0 11.0                       29.0 1   1 27                 18 11                 29
260152 260152 SD     school 4678570 47001   White River 47-1 467857000951 4 White River Middle Sch   Regular School No Middle 06 08 2018   grade_8 2.0 2.0 0.0 23.0             2.0   14.0 15.0                       29.0 2 2 0 23             2   14 15                 29
253469 253469 SD     school 4629880 26004   Gregory 26-4 462988001296 4 Gregory Jr High School   Regular School No Middle 06 08 2018   grade_8 22.0 0.0 0.0 4.0   2.0         0.0   10.0 18.0                       28.0 22 0 0 4   2         0   10 18                 28
253708 253708 SD     school 4602640 30001   Hanson 30-1 460264000018 2 Hanson Middle School   Regular School No Middle 06 08 2018   grade_8 26.0   2.0 0.0                 18.0 10.0                       28.0 26   2 0                 18 10                 28
257027 257027 SD     school 4680438 11005   Platte-Geddes 11-5 468043801250 3 Platte-Geddes Jr. Hi   Regular School No Middle 07 08 2018   grade_8 22.0 1.0   3.0             2.0   19.0 9.0                       28.0 22 1   3             2   19 9                 28
253373 253373 SD     school 4626490 63001   Gayville-Volin 63-1 462649000844 3 Gayville-Volin JH   Regular School No Middle 07 08 2018   grade_8 24.0   0.0               3.0   15.0 12.0                       27.0 24   0               3   15 12                 27
256445 256445 SD     school 4651750 56007   Northwestern Area 56-7 465175000924 2 Northwestern Middle School   Regular School No Middle 06 08 2018   grade_8 27.0                 0.0 0.0   12.0 15.0                       27.0 27                 0 0   12 15                 27
256562 256562 SD     school 4665460 65001   Oglala Lakota 65-1 466546000576 3 Rockyford School   Regular School No Elementary PK 08 2018   grade_8     0.0 27.0           0.0 0.0   18.0 9.0                       27.0     0 27           0 0   18 9                 27
258277 258277 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No Middle 06 08 2018   grade_8 108.0 66.0 47.0 21.0   19.0       1.0 7.0   139.0 130.0                       269.0 108 66 47 21   19       1 7   139 130                 269

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