enrollments

Data source: Big Local News · About: Big Local

670 rows where grade = "grade_8", state = "SD" and year = 2015 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 670 ✖

grade ✖

  • grade_8 · 670 ✖
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
2962204 2962204 SD     school 4605610 9001   Belle Fourche 09-1 460561000269 3 South Park Elementary   Regular School No 1 01 04 2015   grade_8 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
2970525 2970525 SD     school 4666930 40002   Spearfish 40-2 466693000392 3 West Elementary   Regular School No 1 01 02 2015   grade_8 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
2971294 2971294 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School No 1 01 04 2015   grade_8 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
2964054 2964054 SD     school 4619410 51001   Douglas 51-1 461941000439 4 Francis Case Elementary   Regular School No 1 02 03 2015   grade_8 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2969102 2969102 SD     school 4660450 56004   Redfield 56-4 466045001102 4 George S Mickelson Alternative   Alternative Education School No 4 02 12 2015   grade_8 4.0 0.0   1.0                 3.0 2.0                       5.0 4 0   1                 3 2                 5
2971167 2971167 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No 1 02 05 2015   grade_8 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
2962857 2962857 SD     school 4608520 5001   Brookings 05-1 460852001298 6 Camelot Intermediate School   Regular School No 1 03 05 2015   grade_8 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2964188 2964188 SD     school 4620100 20001   Eagle Butte 20-1 462010000605 3 C-EB Upper Elementary   Regular School No 1 03 06 2015   grade_8 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
2967873 2967873 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100493 4 Mobridge Upper Elementary   Regular School No 1 03 05 2015   grade_8 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
2970521 2970521 SD     school 4666930 40002   Spearfish 40-2 466693000401 7 Creekside Elem   Regular School No 1 03 05 2015   grade_8 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2970768 2970768 SD     school 4600052 41005   Tea Area 41-5 460005201331 4 Tea Area Intermediate   Regular School No 1 03 05 2015   grade_8 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
2964055 2964055 SD     school 4619410 51001   Douglas 51-1 461941000436 2 Vandenberg Elementary   Regular School No 2 04 05 2015   grade_8 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2966433 2966433 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No 2 04 08 2015   grade_8 1.0                       0.0 1.0                       1.0 1                       0 1                 1
2961712 2961712 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative Education School No 4 05 12 2015   grade_8 2.0   0.0 0.0           0.0     2.0 0.0                       2.0 2   0 0           0     2 0                 2
2962022 2962022 SD     school 4603780 21001   Armour 21-1 460378000878 3 Armour Middle School   Regular School No 2 05 08 2015   grade_8 14.0     1.0                 8.0 7.0                       15.0 14     1                 8 7                 15
2962202 2962202 SD     school 4605610 9001   Belle Fourche 09-1 460561001117 7 Belle Fourche MS   Regular School No 2 05 08 2015   grade_8 84.0   5.0 4.0   0.0         3.0   56.0 40.0                       96.0 84   5 4   0         3   56 40                 96
2963142 2963142 SD     school 4611760 60001   Centerville 60-1 461176001023 3 Centerville Middle School   Regular School No 2 05 08 2015   grade_8 12.0 0.0 1.0 0.0                 7.0 6.0                       13.0 12 0 1 0                 7 6                 13
2963364 2963364 SD     school 4612940 12002   Clark 12-2 461294000890 3 Clark Middle School   Regular School No 2 05 08 2015   grade_8 19.0 0.0 0.0                   10.0 9.0                       19.0 19 0 0                   10 9                 19
2963649 2963649 SD     school 4636990 61008   Dakota Valley 61-8 463699001075 4 Dakota Valley Upper Elem   Regular School No 2 05 06 2015   grade_8 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
2963750 2963750 SD     school 4618120 49003   Dell Rapids 49-3 461812000837 3 Dell Rapids Middle School   Regular School No 2 05 08 2015   grade_8 66.0 0.0 2.0 2.0             1.0   36.0 35.0                       71.0 66 0 2 2             1   36 35                 71
2964184 2964184 SD     school 4620100 20001   Eagle Butte 20-1 462010001233 7 C-EB EAGLE Center   Alternative Education School No 4 05 12 2015   grade_8 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
2966486 2966486 SD     school 4619580 37003   Jones County 37-3 461958000955 4 Jones County MS   Regular School No 2 05 08 2015   grade_8 10.0   0.0 1.0             3.0   12.0 2.0                       14.0 10   0 1             3   12 2                 14
2966636 2966636 SD     school 4638220 7002   Kimball 07-2 463822000142 4 Kimball Middle School   Regular School No 2 05 08 2015   grade_8 16.0   1.0 3.0             0.0   10.0 10.0                       20.0 16   1 3             0   10 10                 20
2967249 2967249 SD     school 4601026 43007   McCook Central 43-7 460102601034 3 McCook Central Middle School   Regular School No 2 05 08 2015   grade_8 18.0   0.0               1.0   12.0 7.0                       19.0 18   0               1   12 7                 19
2968372 2968372 SD     school 4654300 33003   Parkston 33-3 465430001132 88 Our Home   Alternative Education School No 4 05 12 2015   grade_8 2.0   0.0 1.0                 2.0 1.0                       3.0 2   0 1                 2 1                 3
2968553 2968553 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative Education School No 2 05 08 2015   grade_8 7.0 1.0   1.0             0.0   8.0 1.0                       9.0 7 1   1             0   8 1                 9
2969999 2969999 SD     school 4666270 49005   Sioux Falls 49-5 466627001121 39 Success Academy   Special Education School No 4 05 12 2015   grade_8 5.0   0.0 0.0             0.0   5.0 0.0                       5.0 5   0 0             0   5 0                 5
2971233 2971233 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000961 3 Viborg-Hurley Middle School   Regular School No 2 05 08 2015   grade_8 25.0 0.0 1.0                   14.0 12.0                       26.0 25 0 1                   14 12                 26
2971296 2971296 SD     school 4675420 11004   Wagner Community 11-4 467542000942 3 Wagner Middle School   Regular School No 2 05 08 2015   grade_8 14.0 1.0 2.0 24.0   0.0         2.0   19.0 24.0                       43.0 14 1 2 24   0         2   19 24                 43
2961706 2961706 SD     school 4602070 6001   Aberdeen 06-1 460207001230 12 Aberdeen Alternative Learning Center   Alternative Education School No 4 06 12 2015   grade_8 2.0                       1.0 1.0                       2.0 2                       1 1                 2
2961709 2961709 SD     school 4602070 6001   Aberdeen 06-1 460207000005 2 Holgate Middle School   Regular School No 2 06 08 2015   grade_8 142.0 2.0 2.0 13.0   2.0         1.0   83.0 79.0                       162.0 142 2 2 13   2         1   83 79                 162
2961715 2961715 SD     school 4602070 6001   Aberdeen 06-1 460207000011 3 Simmons Middle School   Regular School No 2 06 08 2015   grade_8 140.0 3.0 3.0 14.0   4.0       4.0 1.0   82.0 87.0                       169.0 140 3 3 14   4       4 1   82 87                 169
2962134 2962134 SD     school 4604680 49001   Baltic 49-1 460468000986 3 Baltic Middle School   Regular School No 2 06 08 2015   grade_8 24.0 1.0 1.0     0.0             16.0 10.0                       26.0 24 1 1     0             16 10                 26
2962310 2962310 SD     school 4606360 61002   Beresford 61-2 460636000051 3 Beresford Middle School   Regular School No 2 06 08 2015   grade_8 54.0 0.0 1.0     0.0         0.0   27.0 28.0                       55.0 54 0 1     0         0   27 28                 55
2962347 2962347 SD     school 4606960 25001   Big Stone City 25-1 460696000352 3 Big Stone MS   Regular School No 2 06 08 2015   grade_8 8.0 0.0 0.0                   2.0 6.0                       8.0 8 0 0                   2 6                 8
2962477 2962477 SD     school 4607400 4002   Bon Homme 04-2 460740000987 2 Bon Homme Middle School   Regular School No 2 06 08 2015   grade_8 34.0 1.0 1.0               2.0   21.0 17.0                       38.0 34 1 1               2   21 17                 38
2962628 2962628 SD     school 4607950 49002   Brandon Valley 49-2 460795000072 2 Brandon Valley Middle Sch   Regular School No 2 06 08 2015   grade_8 236.0 5.0 5.0 1.0   1.0       1.0 2.0   124.0 127.0                       251.0 236 5 5 1   1       1 2   124 127                 251
2962704 2962704 SD     school 4621420 30003   Bridgewater-Emery 30-3 462142000902 4 Bridgewater-Emery Middle School   Regular School No 2 06 08 2015   grade_8 26.0 0.0                     7.0 19.0                       26.0 26 0                     7 19                 26
2962858 2962858 SD     school 4608520 5001   Brookings 05-1 460852000083 2 George S Mickelson Middle School   Regular School No 2 06 08 2015   grade_8 182.0 4.0 11.0 5.0   10.0       2.0 6.0   116.0 104.0                       220.0 182 4 11 5   10       2 6   116 104                 220
2962966 2962966 SD     school 4610320 43001   Canistota 43-1 461032001016 3 Canistota Middle School   Regular School No 2 06 08 2015   grade_8 16.0 0.0   1.0                 7.0 10.0                       17.0 16 0   1                 7 10                 17
2963023 2963023 SD     school 4610560 41001   Canton 41-1 461056000831 4 Canton Middle School   Regular School No 2 06 08 2015   grade_8 57.0   2.0 2.0   1.0         0.0   29.0 33.0                       62.0 57   2 2   1         0   29 33                 62
2963270 2963270 SD     school 4612300 39001   Chester Area 39-1 461230000832 3 Chester Area Middle School   Regular School No 2 06 08 2015   grade_8 31.0     0.0             0.0   16.0 15.0                       31.0 31     0             0   16 15                 31
2963526 2963526 SD     school 4616230 21002   Corsica 21-2 461623000991 3 Corsica Middle School   Regular School No 2 06 08 2015   grade_8 10.0                       6.0 4.0                       10.0 10                       6 4                 10
2963701 2963701 SD     school 4617850 38002   De Smet 38-2 461785000993 3 De Smet Middle School   Regular School No 2 06 08 2015   grade_8 22.0     0.0                 11.0 11.0                       22.0 22     0                 11 11                 22
2963877 2963877 SD     school 4600036 19004   Deuel 19-4 460003601013 4 Clear Lake Middle School   Regular School No 2 06 08 2015   grade_8 39.0   0.0 1.0                 24.0 16.0                       40.0 39   0 1                 24 16                 40
2964052 2964052 SD     school 4619410 51001   Douglas 51-1 461941000176 1 Douglas Middle School   Regular School No 2 06 08 2015   grade_8 125.0 7.0 5.0 15.0   0.0       0.0 15.0   88.0 79.0                       167.0 125 7 5 15   0       0 15   88 79                 167
2964278 2964278 SD     school 4634440 22005   Edmunds Central 22-5 463444000032 2 Edmunds Central Middle School   Regular School No 2 06 08 2015   grade_8 10.0   2.0                   9.0 3.0                       12.0 10   2                   9 3                 12
2964342 2964342 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000900 3 Elk Point Jefferson Middle School   Regular School No 2 06 08 2015   grade_8 41.0 1.0 2.0               1.0   23.0 22.0                       45.0 41 1 2               1   23 22                 45
2964566 2964566 SD     school 4622560 44001   Eureka 44-1 462256000958 3 Eureka MS   Regular School No 2 06 08 2015   grade_8 9.0         1.0             5.0 5.0                       10.0 9         1             5 5                 10
2964816 2964816 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School No 2 06 08 2015   grade_8 24.0   3.0 25.0   0.0       0.0 0.0   24.0 28.0                       52.0 24   3 25   0       0 0   24 28                 52
2965046 2965046 SD     school 4626370 49004   Garretson 49-4 462637000843 3 Garretson Middle School   Regular School No 2 06 08 2015   grade_8 26.0 1.0 2.0 0.0             1.0   18.0 12.0                       30.0 26 1 2 0             1   18 12                 30
2965286 2965286 SD     school 4600045 6006   Groton Area 460004501157 4 Groton Area MS   Regular School No 2 06 08 2015   grade_8 38.0 3.0 1.0     0.0             14.0 28.0                       42.0 38 3 1     0             14 28                 42
2965414 2965414 SD     school 4630800 28003   Hamlin 28-3 463080000259 2 Hamlin Middle School   Regular School No 2 06 08 2015   grade_8 49.0 0.0 3.0               0.0   30.0 22.0                       52.0 49 0 3               0   30 22                 52
2965493 2965493 SD     school 4602640 30001   Hanson 30-1 460264000018 2 Hanson Middle School   Regular School No 2 06 08 2015   grade_8 24.0   1.0     1.0             16.0 10.0                       26.0 24   1     1             16 10                 26
2965579 2965579 SD     school 4609300 31001   Harding County 31-1 460930000887 3 Harding County MS   Regular School No 2 06 08 2015   grade_8 11.0 0.0   0.0                 5.0 6.0                       11.0 11 0   0                 5 6                 11
2965690 2965690 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No 2 06 08 2015   grade_8 108.0 2.0 5.0 1.0   5.0         2.0   61.0 62.0                       123.0 108 2 5 1   5         2   61 62                 123
2965691 2965691 SD     school 4631350 41002   Harrisburg 41-2 463135000847 3 Harrisburg South MS   Regular School No 2 06 08 2015   grade_8 112.0 3.0 1.0 1.0             5.0   58.0 64.0                       122.0 112 3 1 1             5   58 64                 122
2965766 2965766 SD     school 4632340 14002   Henry 14-2 463234001047 3 Henry MS   Regular School No 2 06 08 2015   grade_8 14.0     1.0                 7.0 8.0                       15.0 14     1                 7 8                 15
2965814 2965814 SD     school 4632430 10001   Herreid 10-1 463243000910 3 Herreid Middle Sch   Regular School No 2 06 08 2015   grade_8 12.0   0.0                   7.0 5.0                       12.0 12   0                   7 5                 12
2965910 2965910 SD     school 4633360 51002   Hill City 51-2 463336000848 4 Hill City Middle Sch   Regular School No 2 06 08 2015   grade_8 41.0 1.0 5.0 2.0                 19.0 30.0                       49.0 41 1 5 2                 19 30                 49
2966038 2966038 SD     school 4634480 23002   Hot Springs 23-2 463448000911 6 Hot Springs Middle Sch   Regular School No 2 06 08 2015   grade_8 57.0 3.0 0.0 8.0   0.0       0.0 1.0   32.0 37.0                       69.0 57 3 0 8   0       0 1   32 37                 69
2966219 2966219 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No 2 06 08 2015   grade_8 105.0 3.0 19.0 1.0   35.0       1.0 0.0   84.0 80.0                       164.0 105 3 19 1   35       1 0   84 80                 164
2966309 2966309 SD     school 4636060 22006   Ipswich Public 22-6 463606000914 4 Ipswich MS   Regular School No 2 06 08 2015   grade_8 25.0                   1.0   13.0 13.0                       26.0 25                   1   13 13                 26
2966432 2966432 SD     school 4636150 2003   Iroquois 02-3 463615000916 2 Iroquois Middle School   Regular School No 2 06 08 2015   grade_8 14.0 0.0 0.0                   9.0 5.0                       14.0 14 0 0                   9 5                 14
2966752 2966752 SD     school 4640860 45005   Langford Area 464086000851 3 Langford Area MS   Regular School No 2 06 08 2015   grade_8 15.0   0.0               2.0   8.0 9.0                       17.0 15   0               2   8 9                 17
2966817 2966817 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000373 2 Lead-Deadwood Middle School   Regular School No 2 06 08 2015   grade_8 52.0 0.0 2.0 3.0   0.0       0.0 1.0   30.0 28.0                       58.0 52 0 2 3   0       0 1   30 28                 58
2966928 2966928 SD     school 4641550 41004   Lennox 41-4 464155000963 8 Lennox Middle School   Regular School No 2 06 08 2015   grade_8 73.0   1.0 0.0             1.0   45.0 30.0                       75.0 73   1 0             1   45 30                 75
2967088 2967088 SD     school 4644770 42001   Lyman 42-1 464477000812 2 Lyman Middle School   Regular School No 2 06 08 2015   grade_8 13.0     14.0             0.0   16.0 11.0                       27.0 13     14             0   16 11                 27
2967142 2967142 SD     school 4639600 39002   Madison Central 39-2 463960000364 2 Madison Middle School   Regular School No 2 06 08 2015   grade_8 73.0 1.0 3.0 1.0   0.0         4.0   48.0 34.0                       82.0 73 1 3 1   0         4   48 34                 82
2967190 2967190 SD     school 4645450 60003   Marion 60-3 464545001050 3 Marion Middle School   Regular School No 2 06 08 2015   grade_8 12.0 1.0 1.0 0.0                 8.0 6.0                       14.0 12 1 1 0                 8 6                 14
2967350 2967350 SD     school 4646380 15002   McLaughlin 15-2 464638000922 3 McLaughlin Middle School   Regular School No 2 06 08 2015   grade_8 1.0   0.0 37.0             1.0   17.0 22.0                       39.0 1   0 37             1   17 22                 39
2967474 2967474 SD     school 4669930 46001   Meade 46-1 466993000653 2 Sturgis Williams MS   Regular School No 2 06 08 2015   grade_8 156.0 3.0 7.0 7.0   1.0       1.0 1.0   83.0 93.0                       176.0 156 3 7 7   1       1 1   83 93                 176
2967580 2967580 SD     school 4647100 33002   Menno 33-2 464710000965 5 Menno Middle School   Regular School No 2 06 08 2015   grade_8 18.0                   2.0   9.0 11.0                       20.0 18                   2   9 11                 20
2967638 2967638 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No 2 06 08 2015   grade_8 58.0   2.0 2.0   0.0         0.0   29.0 33.0                       62.0 58   2 2   0         0   29 33                 62
2967792 2967792 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No 2 06 08 2015   grade_8 196.0 3.0 7.0 8.0   1.0         0.0   119.0 96.0                       215.0 196 3 7 8   1         0   119 96                 215
2967872 2967872 SD     school 4680441 62006   Mobridge-Pollock 62-6 468044100450 2 Mobridge Middle School   Regular School No 2 06 08 2015   grade_8 27.0   1.0 17.0             0.0   21.0 24.0                       45.0 27   1 17             0   21 24                 45
2967936 2967936 SD     school 4648780 43002   Montrose 43-2 464878000966 3 Montrose Middle School   Regular School No 2 06 08 2015   grade_8 13.0   1.0               1.0   5.0 10.0                       15.0 13   1               1   5 10                 15
2967990 2967990 SD     school 4649650 17003   Mount Vernon 17-3 464965000967 3 Mount Vernon MS   Regular School No 2 06 08 2015   grade_8 10.0   2.0 1.0                 4.0 9.0                       13.0 10   2 1                 4 9                 13
2968086 2968086 SD     school 4650850 9002   Newell 09-2 465085000968 4 Newell Middle Sch   Regular School No 2 06 08 2015   grade_8 24.0 1.0 1.0 1.0           0.0 1.0   13.0 15.0                       28.0 24 1 1 1           0 1   13 15                 28
2968134 2968134 SD     school 4651750 56007   Northwestern Area 56-7 465175000924 2 Northwestern Middle School   Regular School No 2 06 08 2015   grade_8 14.0                   0.0   10.0 4.0                       14.0 14                   0   10 4                 14
2968467 2968467 SD     school 4655260 32002   Pierre 32-2 465526000501 2 Georgia Morse Middle School   Regular School No 2 06 08 2015   grade_8 118.0 1.0 8.0 21.0   4.0       0.0 7.0   75.0 84.0                       159.0 118 1 8 21   4       0 7   75 84                 159
2968916 2968916 SD     school 4659820 51004   Rapid City Area 51-4 465982000528 30 East MS   Regular School No 2 06 08 2015   grade_8 169.0 8.0 6.0 21.0   3.0         9.0   114.0 102.0                       216.0 169 8 6 21   3         9   114 102                 216
2968924 2968924 SD     school 4659820 51004   Rapid City Area 51-4 465982000532 35 North Middle Sch   Regular School No 2 06 08 2015   grade_8 41.0 4.0 10.0 91.0   1.0         7.0   78.0 76.0                       154.0 41 4 10 91   1         7   78 76                 154
2968930 2968930 SD     school 4659820 51004   Rapid City Area 51-4 465982000533 36 South Middle Sch   Regular School No 2 06 08 2015   grade_8 149.0 2.0 10.0 35.0   2.0         7.0   93.0 112.0                       205.0 149 2 10 35   2         7   93 112                 205
2968932 2968932 SD     school 4659820 51004   Rapid City Area 51-4 465982000457 38 Southwest Middle Sch   Regular School No 2 06 08 2015   grade_8 168.0 1.0 8.0 17.0   2.0         3.0   104.0 95.0                       199.0 168 1 8 17   2         3   104 95                 199
2968935 2968935 SD     school 4659820 51004   Rapid City Area 51-4 465982000822 37 West Middle Sch   Regular School No 2 06 08 2015   grade_8 183.0 1.0 11.0 13.0   1.0         10.0   90.0 129.0                       219.0 183 1 11 13   1         10   90 129                 219
2969296 2969296 SD     school 4603932 55005   Sanborn Central 55-5 460393200102 2 Sanborn Central Middle School   Regular School No 2 06 08 2015   grade_8 15.0   1.0               1.0   11.0 6.0                       17.0 15   1               1   11 6                 17
2969350 2969350 SD     school 4665180 4003   Scotland 04-3 466518000933 5 Scotland Middle School   Regular School No 2 06 08 2015   grade_8 13.0                   1.0   7.0 7.0                       14.0 13                   1   7 7                 14
2969969 2969969 SD     school 4666270 49005   Sioux Falls 49-5 466627000583 6 Edison Middle School   Regular School No 2 06 08 2015   grade_8 209.0 23.0 15.0 12.0   5.0         9.0   164.0 109.0                       273.0 209 23 15 12   5         9   164 109                 273
2969972 2969972 SD     school 4666270 49005   Sioux Falls 49-5 466627001123 45 FLEX   Special Education School No 4 06 12 2015   grade_8 1.0 0.0 0.0 0.0             0.0   1.0 0.0                       1.0 1 0 0 0             0   1 0                 1
2969974 2969974 SD     school 4666270 49005   Sioux Falls 49-5 466627001333 9 George McGovern Middle School   Regular School No 2 06 08 2015   grade_8 93.0 42.0 36.0 19.0   15.0       0.0 8.0   113.0 100.0                       213.0 93 42 36 19   15       0 8   113 100                 213
2969987 2969987 SD     school 4666270 49005   Sioux Falls 49-5 466627001170 53 MS Immersion Center   Regular School No 2 06 08 2015   grade_8 1.0 11.0 1.0     6.0             12.0 7.0                       19.0 1 11 1     6             12 7                 19
2969989 2969989 SD     school 4666270 49005   Sioux Falls 49-5 466627001070 4 Memorial Middle School   Regular School No 2 06 08 2015   grade_8 329.0 18.0 12.0 8.0   11.0         3.0   188.0 193.0                       381.0 329 18 12 8   11         3   188 193                 381
2969992 2969992 SD     school 4666270 49005   Sioux Falls 49-5 466627000604 7 Patrick Henry Middle School   Regular School No 2 06 08 2015   grade_8 338.0 31.0 12.0 10.0   9.0         6.0   220.0 186.0                       406.0 338 31 12 10   9         6   220 186                 406
2970004 2970004 SD     school 4666270 49005   Sioux Falls 49-5 466627000611 8 Whittier Middle School   Regular School No 2 06 08 2015   grade_8 160.0 65.0 39.0 30.0   24.0         14.0   169.0 163.0                       332.0 160 65 39 30   24         14   169 163                 332
2970262 2970262 SD     school 4666300 5005   Sioux Valley 05-5 466630000613 4 Sioux Valley Middle School   Regular School No 2 06 08 2015   grade_8 37.0   0.0     1.0         0.0   18.0 20.0                       38.0 37   0     1         0   18 20                 38
2970320 2970320 SD     school 4600053 54002   Sisseton 54-2 460005301258 2 Sisseton Middle School   Regular School No 2 06 08 2015   grade_8 19.0 0.0 2.0 32.0             0.0   35.0 18.0                       53.0 19 0 2 32             0   35 18                 53
2970374 2970374 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2015   grade_8       14.0                 10.0 4.0                       14.0       14                 10 4                 14
2970422 2970422 SD     school 4607670 26005   South Central 26-5 460767000881 2 South Central MS   Regular School No 2 06 08 2015   grade_8 3.0 0.0   4.0             1.0   6.0 2.0                       8.0 3 0   4             1   6 2                 8
2970524 2970524 SD     school 4666930 40002   Spearfish 40-2 466693000622 5 Spearfish MS   Regular School No 2 06 08 2015   grade_8 158.0 0.0 7.0 4.0   5.0         3.0   93.0 84.0                       177.0 158 0 7 4   5         3   93 84                 177

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