Data source: Big Local News · About: Big Local

666 rows where grade = "k_12_total", state = "SD" and year = 2016 sorted by multiracial_int

View and edit SQL

year

  • 2016 · 666

grade

  • k_12_total · 666
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
3345056 SD     school 4607400 4002   Bon Homme 04-2 460740001328 8 Bon Homme PK   Regular School No 1 PK PK 2016   k_12_total 0.0   0.0               0.0   0.0 0.0                       0.0 0   0               0   0 0                 0
3346681 SD     school 4619410 51001   Douglas 51-1 461941001125 8 Douglas Preschool   Regular School No 1 PK PK 2016   k_12_total 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3346738 SD     school 4619450 64002   Dupree 64-2 461945000799 2 Dupree Elem   Regular School No 1 PK 06 2016   k_12_total 29.0   4.0 189.0             0.0   108.0 114.0       2.6               222.0 29   4 189             0   108 114                 222
3349022 SD     school 4636150 2003   Iroquois 02-3 463615001144 4 Iroquois Elementary   Regular School No 1 PK 05 2016   k_12_total 98.0 4.0 5.0 3.0             0.0   54.0 56.0                       110.0 98 4 5 3             0   54 56                 110
3350873 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   k_12_total     4.0 73.0             0.0   43.0 34.0       4.9               77.0     4 73             0   43 34                 77
3344366 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No 1 KG 05 2016   k_12_total 17.0   3.0 6.0             1.0   20.0 7.0       10.0               27.0 17   3 6             1   20 7                 27
3344369 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200939 6 Sully Buttes Junior High   Regular School No 2 07 08 2016   k_12_total 40.0   1.0 2.0             1.0   26.0 18.0       0.0               44.0 40   1 2             1   26 18                 44
3344639 SD     school 4604270 4001   Avon 04-1 460427000029 1 Avon High School   Regular School No 3 09 12 2016   k_12_total 73.0   1.0 2.0             1.0   37.0 40.0                       77.0 73   1 2             1   37 40                 77
3344946 SD     school 4607050 52001   Bison 52-1 460705000054 2 Bison Elementary   Regular School No 1 KG 06 2016   k_12_total 78.0   5.0 4.0   1.0         1.0   40.0 49.0       0.0               89.0 78   5 4   1         1   40 49                 89
3345054 SD     school 4607400 4002   Bon Homme 04-2 460740000065 1 Bon Homme High School   Regular School No 3 09 12 2016   k_12_total 124.0 1.0 3.0 1.0             1.0   64.0 66.0                       130.0 124 1 3 1             1   64 66                 130
3345586 SD     school 4610320 43001   Canistota 43-1 461032000104 2 Canistota Elementary School   Regular School No 1 PK 05 2016   k_12_total 93.0 1.0 7.0 1.0             1.0   53.0 50.0       0.0               103.0 93 1 7 1             1   53 50                 103
3345746 SD     school 4611760 60001   Centerville 60-1 461176000115 2 Centerville Elem   Regular School No 1 PK 04 2016   k_12_total 104.0 1.0 2.0 0.0             1.0   55.0 53.0       1.3               108.0 104 1 2 0             1   55 53                 108
3345880 SD     school 4612300 39001   Chester Area 39-1 461230000131 2 Chester Area Elementary School   Regular School No 1 PK 05 2016   k_12_total 154.0 2.0   4.0             1.0   77.0 84.0       0.0               161.0 154 2   4             1   77 84                 161
3346079 SD     school 4614130 59003   Colome Consolidated 461413000141 1 Colome High School   Regular School No 3 09 12 2016   k_12_total 66.0   1.0 9.0   1.0         1.0   43.0 35.0       0.0               78.0 66   1 9   1         1   43 35                 78
3346427 SD     school 4678300 5006   Deubrook Area 05-6 467830000012 1 Deubrook High School   Regular School No 3 09 12 2016   k_12_total 107.0   3.0 1.0             1.0   63.0 49.0                       112.0 107   3 1             1   63 49                 112
3346740 SD     school 4619450 64002   Dupree 64-2 461945000896 4 Dupree Jr Hi   Regular School No 2 07 08 2016   k_12_total 11.0   1.0 53.0             1.0   25.0 41.0       7.4               66.0 11   1 53             1   25 41                 66
3346948 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000900 3 Elk Point Jefferson Middle School   Regular School No 2 06 08 2016   k_12_total 143.0 3.0 6.0               1.0   73.0 80.0       0.0               153.0 143 3 6               1   73 80                 153
3347019 SD     school 4621390 5003   Elkton 05-3 462139000188 1 Elkton High School   Regular School No 3 09 12 2016   k_12_total 89.0   3.0             1.0 1.0   55.0 39.0                       94.0 89   3             1 1   55 39                 94
3347074 SD     school 4622410 28002   Estelline 28-2 462241000191 2 Estelline Elementary School   Regular School No 1 PK 06 2016   k_12_total 126.0   12.0               1.0   75.0 64.0       1.3               139.0 126   12               1   75 64                 139
3347076 SD     school 4622410 28002   Estelline 28-2 462241001045 3 Estelline Junior High   Regular School No 2 07 08 2016   k_12_total 40.0   1.0               1.0   23.0 19.0       7.9               42.0 40   1               1   23 19                 42
3347243 SD     school 4622940 46002   Faith 46-2 462294000806 1 Faith High School   Regular School No 3 09 12 2016   k_12_total 59.0   3.0 1.0             1.0   29.0 35.0       1.6               64.0 59   3 1             1   29 35                 64
3347407 SD     school 4624390 50003   Flandreau 50-3 462439000206 1 Flandreau High Sch   Regular School No 3 09 12 2016   k_12_total 92.0   8.0 65.0   4.0         1.0   91.0 79.0       1.8               170.0 92   8 65   4         1   91 79                 170
3347459 SD     school 4624540 14001   Florence 14-1 462454000209 1 Florence High School   Regular School No 3 09 12 2016   k_12_total 65.0   1.0 1.0             1.0   38.0 30.0       0.0               68.0 65   1 1             1   38 30                 68
3347506 SD     school 4621400 6002   Frederick Area 06-2 462140000189 2 Frederick Elementary   Regular School No 1 KG 06 2016   k_12_total 83.0                   1.0   50.0 34.0                       84.0 83                   1   50 34                 84
3347508 SD     school 4621400 6002   Frederick Area 06-2 462140000957 3 Frederick Jr High   Regular School No 2 07 08 2016   k_12_total 21.0                   1.0   15.0 7.0                       22.0 21                   1   15 7                 22
3347579 SD     school 4625500 33001   Freeman 33-1 462550000220 1 Freeman High School   Regular School No 3 09 12 2016   k_12_total 71.0   6.0 1.0             1.0   36.0 43.0       0.0               79.0 71   6 1             1   36 43                 79
3347950 SD     school 4630490 27001   Haakon 27-1 463049000247 3 Philip Junior High   Regular School No 2 07 08 2016   k_12_total 36.0   2.0 3.0             1.0   24.0 18.0       0.0               42.0 36   2 3             1   24 18                 42
3348004 SD     school 4630800 28003   Hamlin 28-3 463080000259 2 Hamlin Middle School   Regular School No 2 06 08 2016   k_12_total 166.0 2.0 3.0 1.0             1.0   91.0 82.0       1.7               173.0 166 2 3 1             1   91 82                 173
3348089 SD     school 4602640 30001   Hanson 30-1 460264000018 2 Hanson Middle School   Regular School No 2 06 08 2016   k_12_total 78.0   4.0               1.0   50.0 33.0       0.0               83.0 78   4               1   50 33                 83
3348402 SD     school 4632430 10001   Herreid 10-1 463243000277 2 Herreid Elem   Regular School No 1 KG 05 2016   k_12_total 38.0                 1.0 1.0   18.0 22.0       0.0               40.0 38                 1 1   18 22                 40
3348404 SD     school 4632430 10001   Herreid 10-1 463243000910 3 Herreid Middle Sch   Regular School No 2 06 08 2016   k_12_total 26.0   1.0             1.0 1.0   18.0 11.0       0.0               29.0 26   1             1 1   18 11                 29
3348813 SD     school 4635480 2002   Huron 02-2 463548000314 2 Huron Middle School   Regular School No 2 06 08 2016   k_12_total 293.0 11.0 88.0 10.0   119.0         1.0   265.0 257.0                       522.0 293 11 88 10   119         1   265 257                 522
3348904 SD     school 4636060 22006   Ipswich Public 22-6 463606000333 1 Ipswich Hi Sch   Regular School No 3 09 12 2016   k_12_total 96.0   3.0 1.0   1.0         1.0   50.0 52.0       0.0               102.0 96   3 1   1         1   50 52                 102
3348962 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901255 2 Irene-Wakonda Elementary School   Regular School No 1 PK 06 2016   k_12_total 147.0   1.0 3.0             1.0   68.0 84.0       0.0               152.0 147   1 3             1   68 84                 152
3349344 SD     school 4640860 45005   Langford Area 464086000851 3 Langford Area MS   Regular School No 2 06 08 2016   k_12_total 47.0   1.0 2.0             1.0   22.0 29.0       0.0               51.0 47   1 2             1   22 29                 51
3349459 SD     school 4641520 52004   Lemmon 52-4 464152000382 1 Lemmon High School   Regular School No 3 09 12 2016   k_12_total 80.0   1.0 3.0   2.0         1.0   43.0 44.0       0.0               87.0 80   1 3   2         1   43 44                 87
3349460 SD     school 4641520 52004   Lemmon 52-4 464152000852 6 Lemmon Jr Hi   Regular School No 2 07 08 2016   k_12_total 43.0                   1.0   18.0 26.0       0.0               44.0 43                   1   18 26                 44
3349534 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No 1 PK 04 2016   k_12_total 87.0   3.0 1.0             1.0   47.0 45.0       0.0               92.0 87   3 1             1   47 45                 92
3349697 SD     school 4644770 42001   Lyman 42-1 464477000397 3 Presho Elementary   Regular School No 1 PK 05 2016   k_12_total 72.0 1.0 1.0 18.0             1.0   52.0 41.0       0.0               93.0 72 1 1 18             1   52 41                 93
3349795 SD     school 4645450 60003   Marion 60-3 464545000408 1 Marion High School   Regular School No 3 09 12 2016   k_12_total 38.0 2.0 4.0     2.0         1.0   23.0 24.0       3.9               47.0 38 2 4     2         1   23 24                 47
3349908 SD     school 4646260 15001   McIntosh 15-1 464626000921 3 McIntosh Jr High   Regular School No 2 07 08 2016   k_12_total 14.0   2.0 9.0             1.0   14.0 12.0       0.0               26.0 14   2 9             1   14 12                 26
3349954 SD     school 4646380 15002   McLaughlin 15-2 464638000415 2 McLaughlin Elementary   Regular School No 1 PK 05 2016   k_12_total 2.0   2.0 216.0             1.0   107.0 114.0       0.5               221.0 2   2 216             1   107 114                 221
3349955 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No 3 09 12 2016   k_12_total 1.0     138.0             1.0   73.0 67.0       13.6               140.0 1     138             1   73 67                 140
3350090 SD     school 4669930 46001   Meade 46-1 466993000741 15 Opal Elementary   Regular School No 1 KG 08 2016   k_12_total 16.0   1.0               1.0   8.0 10.0       0.0               18.0 16   1               1   8 10                 18
3350542 SD     school 4648780 43002   Montrose 43-2 464878000451 2 Montrose Elementary School   Regular School No 1 PK 05 2016   k_12_total 95.0 1.0 1.0               1.0   52.0 46.0       0.0               98.0 95 1 1               1   52 46                 98
3350595 SD     school 4649650 17003   Mount Vernon 17-3 464965000455 1 Mount Vernon High School   Regular School No 3 09 12 2016   k_12_total 60.0   5.0 3.0           1.0 1.0   37.0 33.0       1.5               70.0 60   5 3           1 1   37 33                 70
3350691 SD     school 4650850 9002   Newell 09-2 465085000469 1 Newell High School   Regular School No 3 09 12 2016   k_12_total 70.0 4.0 1.0 6.0             1.0   45.0 37.0                       82.0 70 4 1 6             1   45 37                 82
3350692 SD     school 4650850 9002   Newell 09-2 465085000968 4 Newell Middle Sch   Regular School No 2 06 08 2016   k_12_total 63.0 3.0 2.0 3.0   2.0       1.0 1.0   44.0 31.0                       75.0 63 3 2 3   2       1 1   44 31                 75
3350740 SD     school 4651750 56007   Northwestern Area 56-7 465175000924 2 Northwestern Middle School   Regular School No 2 06 08 2016   k_12_total 70.0                 1.0 1.0   34.0 38.0       0.0               72.0 70                 1 1   34 38                 72
3350786 SD     school 4652770 23003   Oelrichs 23-3 465277000481 2 Oelrichs Elem   Regular School No 1 KG 06 2016   k_12_total 4.0   3.0 33.0             1.0   26.0 15.0       0.0               41.0 4   3 33             1   26 15                 41
3350955 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701027 1 Oldham-Ramona High School   Regular School No 3 09 12 2016   k_12_total 32.0 1.0                 1.0   24.0 10.0       0.0               34.0 32 1                 1   24 10                 34
3351012 SD     school 4654270 60004   Parker 60-4 465427000925 3 Parker JH   Regular School No 2 07 08 2016   k_12_total 66.0 1.0 2.0             1.0 1.0   30.0 41.0       0.0               71.0 66 1 2             1 1   30 41                 71
3351099 SD     school 4654300 33003   Parkston 33-3 465430000926 5 Parkston Junior High   Regular School No 2 07 08 2016   k_12_total 63.0   1.0               1.0   29.0 36.0       1.7               65.0 63   1               1   29 36                 65
3351342 SD     school 4680438 11005   Platte-Geddes 11-5 468043801250 3 Platte-Geddes Jr. Hi   Regular School No 2 07 08 2016   k_12_total 55.0   1.0               1.0   32.0 25.0       1.7               57.0 55   1               1   32 25                 57
3351668 SD     school 4659820 51004   Rapid City Area 51-4 465982001341 44 Lincoln Building   Special Education School No 3 12 12 2016   k_12_total 25.0     3.0             1.0   19.0 10.0       3.7               29.0 25     3             1   19 10                 29
3351872 SD     school 4663360 54004   Rosholt 54-4 466336001053 4 Rosholt Jr High   Regular School No 2 07 08 2016   k_12_total 27.0   1.0 3.0             1.0   18.0 14.0       0.0               32.0 27   1 3             1   18 14                 32
3351936 SD     school 4664140 39004   Rutland 39-4 466414000563 1 Rutland Hi Sch   Regular School No 3 09 12 2016   k_12_total 32.0 1.0                 1.0   17.0 17.0       0.0               34.0 32 1                 1   17 17                 34
3352051 SD     school 4665180 4003   Scotland 04-3 466518000569 1 Scotland High School   Regular School No 3 09 12 2016   k_12_total 74.0   3.0               1.0   42.0 36.0                       78.0 74   3               1   42 36                 78
3352100 SD     school 4601028 62005   Selby Area 62-5 460102801036 3 Selby Jr Hi   Regular School No 2 07 08 2016   k_12_total 27.0 1.0 1.0 2.0             1.0   19.0 13.0       0.0               32.0 27 1 1 2             1   19 13                 32
3352633 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School No 4 KG 12 2016   k_12_total 26.0 2.0 1.0     2.0         1.0   21.0 11.0       9.5               32.0 26 2 1     2         1   21 11                 32
3352664 SD     school 4666270 49005   Sioux Falls 49-5 466627001133 48 Summit Oaks Residential Program   Alternative Education School No 4 KG 12 2016   k_12_total 21.0 3.0 1.0 6.0             1.0   8.0 24.0       3.5               32.0 21 3 1 6             1   8 24                 32
3352894 SD     school 4600053 54002   Sisseton 54-2 460005301242 5 New Effington Elementary   Regular School No 1 PK 06 2016   k_12_total 16.0     17.0   1.0         1.0   12.0 23.0                       35.0 16     17   1         1   12 23                 35
3352948 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2016   k_12_total   1.0   38.0             1.0   16.0 24.0       0.0               40.0   1   38             1   16 24                 40
3353102 SD     school 4666930 40002   Spearfish 40-2 466693001346 9 Black Hills Academy at Canyon Hills Elem   Alternative Education School No 1 KG 08 2016   k_12_total 5.0     3.0             1.0   3.0 6.0       0.0               9.0 5     3             1   3 6                 9
3353104 SD     school 4666930 40002   Spearfish 40-2 466693001304 6 Black Hills Education Connections   Alternative Education School No 3 10 12 2016   k_12_total 27.0     3.0             1.0   16.0 15.0       0.0               31.0 27     3             1   16 15                 31
3353346 SD     school 4671880 20003   Timber Lake 20-3 467188000664 2 Timber Lake Elementary K-5   Regular School No 1 PK 05 2016   k_12_total 67.0 1.0 3.0 100.0             1.0   97.0 75.0       0.0               172.0 67 1 3 100             1   97 75                 172
3353480 SD     school 4672090 66001   Todd County 66-1 467209000504 9 Lakeview Elementary   Regular School No 1 KG 08 2016   k_12_total 11.0     40.0             1.0   30.0 22.0       2.1               52.0 11     40             1   30 22                 52
3353484 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No 1 KG 08 2016   k_12_total       74.0             1.0   36.0 39.0       0.0               75.0       74             1   36 39                 75
3353628 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000062 3 Tripp-Delmont Elementary K-6   Regular School No 1 PK 06 2016   k_12_total 56.0   1.0 9.0   2.0         1.0   33.0 36.0       0.0               69.0 56   1 9   2         1   33 36                 69
3353761 SD     school 4674520 60006   Viborg-Hurley 60-6 467452000961 3 Viborg-Hurley Middle School   Regular School No 2 05 08 2016   k_12_total 82.0 3.0                 1.0   54.0 32.0       0.0               86.0 82 3                 1   54 32                 86
3353874 SD     school 4675660 51005   Wall 51-5 467566000704 2 Wall Elementary School   Regular School No 1 KG 05 2016   k_12_total 96.0     13.0   1.0         1.0   61.0 50.0       0.0               111.0 96     13   1         1   61 50                 111
3353875 SD     school 4675660 51005   Wall 51-5 467566000705 1 Wall High School   Regular School No 3 09 12 2016   k_12_total 73.0   1.0 12.0             1.0   43.0 44.0       0.0               87.0 73   1 12             1   43 44                 87
3354098 SD     school 4676680 18003   Waubay 18-3 467668000719 2 Waubay Elem   Regular School No 1 PK 05 2016   k_12_total 39.0     45.0             1.0   50.0 35.0       0.0               85.0 39     45             1   50 35                 85
3354146 SD     school 4676740 14005   Waverly 14-5 467674000721 2 Waverly/South Shore Elementary   Regular School No 1 PK 05 2016   k_12_total 98.0 1.0 1.0 5.0             1.0   55.0 51.0       0.0               106.0 98 1 1 5             1   55 51                 106
3354148 SD     school 4676740 14005   Waverly 14-5 467674000946 3 Waverly/South Shore Middle School   Regular School No 2 06 08 2016   k_12_total 45.0     2.0             1.0   25.0 23.0       0.0               48.0 45     2             1   25 23                 48
3354195 SD     school 4676990 18005   Webster Area 467699000724 1 Webster Area High School   Regular School No 3 09 12 2016   k_12_total 129.0   5.0 1.0             1.0   74.0 62.0       0.0               136.0 129   5 1             1   74 62                 136
3354433 SD     school 4678570 47001   White River 47-1 467857000951 4 White River Middle Sch   Regular School No 2 06 08 2016   k_12_total 10.0 2.0   61.0             1.0   40.0 34.0       1.0               74.0 10 2   61             1   40 34                 74
3354594 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No 1 PK 05 2016   k_12_total 55.0 1.0 1.0 21.0           1.0 1.0   43.0 37.0       0.0               80.0 55 1 1 21           1 1   43 37                 80
3354691 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School No 3 09 12 2016   k_12_total 95.0 4.0 3.0 2.0             1.0   67.0 38.0                       105.0 95 4 3 2             1   67 38                 105
3354692 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School No 2 06 08 2016   k_12_total 46.0 3.0 2.0 1.0             1.0   29.0 24.0                       53.0 46 3 2 1             1   29 24                 53
3354727 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No 3 09 12 2016   k_12_total 52.0     1.0             1.0   34.0 20.0       0.0               54.0 52     1             1   34 20                 54
3344479 SD     school 4639540 11001   Andes Central 11-1 463954000360 1 Andes Central High School   Regular School No 3 09 12 2016   k_12_total 12.0   1.0 50.0             2.0   37.0 28.0       4.8               65.0 12   1 50             2   37 28                 65
3344578 SD     school 4603780 21001   Armour 21-1 460378000023 2 Armour Elementary   Regular School No 1 KG 05 2016   k_12_total 65.0 3.0 1.0 2.0             2.0   43.0 30.0       0.0               73.0 65 3 1 2             2   43 30                 73
3344690 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School No 1 PK 05 2016   k_12_total 206.0   6.0 1.0   2.0         2.0   112.0 105.0       0.0               217.0 206   6 1   2         2   112 105                 217
3344867 SD     school 4606360 61002   Beresford 61-2 460636000048 1 Beresford High School   Regular School No 3 09 12 2016   k_12_total 197.0 2.0 4.0     3.0         2.0   104.0 104.0       0.0               208.0 197 2 4     3         2   104 104                 208
3345061 SD     school 4607400 4002   Bon Homme 04-2 460740000064 4 Tyndall Elementary   Regular School No 1 KG 05 2016   k_12_total 118.0   3.0               2.0   62.0 61.0                       123.0 118   3               2   62 61                 123
3345224 SD     school 4607950 49002   Brandon Valley 49-2 460795000073 4 Valley Springs Elem   Regular School No 1 KG 04 2016   k_12_total 101.0 1.0                 2.0   49.0 55.0       0.0               104.0 101 1                 2   49 55                 104
3345634 SD     school 4610560 41001   Canton 41-1 461056000109 1 Canton High School   Regular School No 3 09 12 2016   k_12_total 244.0 1.0 4.0 5.0   4.0         2.0   128.0 132.0       0.4               260.0 244 1 4 5   4         2   128 132                 260
3345635 SD     school 4610560 41001   Canton 41-1 461056000831 4 Canton Middle School   Regular School No 2 06 08 2016   k_12_total 166.0 3.0 4.0 3.0   2.0         2.0   88.0 92.0       1.7               180.0 166 3 4 3   2         2   88 92                 180
3345694 SD     school 4611280 28001   Castlewood 28-1 461128000113 2 Castlewood Elementary   Regular School No 1 PK 06 2016   k_12_total 127.0 1.0 4.0 1.0             2.0   68.0 67.0       0.0               135.0 127 1 4 1             2   68 67                 135
3345796 SD     school 4612000 7001   Chamberlain 07-1 461200000889 2 Chamberlain Jr. High   Regular School No 2 07 08 2016   k_12_total 73.0 1.0 4.0 42.0   1.0         2.0   66.0 57.0                       123.0 73 1 4 42   1         2   66 57                 123
3346191 SD     school 4616950 16001   Custer 16-1 461695000155 1 Custer High School   Regular School No 3 09 12 2016   k_12_total 211.0 3.0 8.0 7.0   2.0         2.0   120.0 113.0       0.8               233.0 211 3 8 7   2         2   120 113                 233
3346947 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000186 1 Elk Point Jefferson High School   Regular School No 3 09 12 2016   k_12_total 193.0 4.0 4.0 1.0   3.0         2.0   99.0 108.0       0.0               207.0 193 4 4 1   3         2   99 108                 207
3347075 SD     school 4622410 28002   Estelline 28-2 462241000192 1 Estelline High School   Regular School No 3 09 12 2016   k_12_total 52.0   7.0               2.0   24.0 37.0       2.9               61.0 52   7               2   24 37                 61
3347122 SD     school 4622500 17001   Ethan 17-1 462250000193 2 Ethan Elementary   Regular School No 1 PK 06 2016   k_12_total 128.0   4.0 2.0             2.0   63.0 73.0       1.4               136.0 128   4 2             2   63 73                 136
3347123 SD     school 4622500 17001   Ethan 17-1 462250000194 1 Ethan High School   Regular School No 3 09 12 2016   k_12_total 62.0 1.0 1.0               2.0   38.0 28.0       1.4               66.0 62 1 1               2   38 28                 66
3347458 SD     school 4624540 14001   Florence 14-1 462454000208 2 Florence Elementary School   Regular School No 1 PK 06 2016   k_12_total 134.0     1.0             2.0   77.0 60.0       0.0               137.0 134     1             2   77 60                 137
3347460 SD     school 4624540 14001   Florence 14-1 462454000589 3 Florence Jr High   Regular School No 2 07 08 2016   k_12_total 27.0     2.0             2.0   18.0 13.0       0.0               31.0 27     2             2   18 13                 31
3348087 SD     school 4602640 30001   Hanson 30-1 460264000876 6 Hanson Elementary School   Regular School No 1 PK 05 2016   k_12_total 181.0   4.0 1.0   2.0         2.0   99.0 91.0       0.6               190.0 181   4 1   2         2   99 91                 190
3348734 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No 1 KG 06 2016   k_12_total 175.0 4.0 2.0 1.0             2.0   109.0 75.0       0.0               184.0 175 4 2 1             2   109 75                 184

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