Data source: Big Local News · About: Big Local

669 rows where grade = "k_12_total", state = "SD" and year = 2017 sorted by multiracial_int

View and edit SQL

year

  • 2017 · 669

grade

  • k_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
3007132 SD     school 4607400 4002   Bon Homme 04-2 460740001328 8 Bon Homme PK   Regular School No Elementary PK PK 2017   k_12_total 0.0                   0.0   0.0 0.0                       0.0 0                   0   0 0                 0
3008514 SD     school 4678300 5006   Deubrook Area 05-6 467830000559 3 Deubrook Elementary   Regular School No Elementary PK 06 2017   k_12_total 149.0 1.0 5.0 3.0   1.0         0.0   80.0 79.0       0.0               159.0 149 1 5 3   1         0   80 79                 159
3008769 SD     school 4619410 51001   Douglas 51-1 461941001125 8 Douglas Preschool   Regular School No Elementary PK PK 2017   k_12_total 0.0   0.0               0.0   0.0 0.0                       0.0 0   0               0   0 0                 0
3009349 SD     school 4622940 46002   Faith 46-2 462294001306 10 Faith PreSchool   Regular School No Elementary PK PK 2017   k_12_total 0.0                   0.0   0.0 0.0                       0.0 0                   0   0 0                 0
3013802 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No Other PK 12 2017   k_12_total 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
3006438 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No Elementary KG 05 2017   k_12_total 21.0   3.0 5.0             1.0   19.0 11.0       10.0               30.0 21   3 5             1   19 11                 30
3006439 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No Elementary KG 06 2017   k_12_total 95.0   1.0 2.0   1.0         1.0   54.0 46.0       1.0               100.0 95   1 2   1         1   54 46                 100
3006551 SD     school 4639540 11001   Andes Central 11-1 463954000360 1 Andes Central High School   Regular School No High 09 12 2017   k_12_total 9.0     53.0             1.0   38.0 25.0       4.8               63.0 9     53             1   38 25                 63
3006615 SD     school 4603720 38001   Arlington 38-1 460372000022 1 Arlington High School   Regular School No High 09 12 2017   k_12_total 73.0   1.0               1.0   38.0 37.0       0.0               75.0 73   1               1   38 37                 75
3006727 SD     school 4604270 4001   Avon 04-1 460427000029 1 Avon High School   Regular School No High 09 12 2017   k_12_total 77.0   4.0 3.0             1.0   46.0 39.0       0.0               85.0 77   4 3             1   46 39                 85
3006728 SD     school 4604270 4001   Avon 04-1 460427000829 5 Avon Jr High School   Regular School No Middle 07 08 2017   k_12_total 33.0     2.0             1.0   16.0 20.0       0.0               36.0 33     2             1   16 20                 36
3006779 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School No High 09 12 2017   k_12_total 137.0   4.0     2.0         1.0   84.0 60.0       0.0               144.0 137   4     2         1   84 60                 144
3006850 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2017   k_12_total 26.0   2.0 4.0             1.0   21.0 12.0       0.0               33.0 26   2 4             1   21 12                 33
3007034 SD     school 4607050 52001   Bison 52-1 460705000054 2 Bison Elementary   Regular School No Elementary KG 06 2017   k_12_total 74.0   5.0 2.0   1.0         1.0   39.0 44.0       0.0               83.0 74   5 2   1         1   39 44                 83
3007130 SD     school 4607400 4002   Bon Homme 04-2 460740000065 1 Bon Homme High School   Regular School No High 09 12 2017   k_12_total 132.0   2.0 2.0             1.0   73.0 64.0       0.0               137.0 132   2 2             1   73 64                 137
3007131 SD     school 4607400 4002   Bon Homme 04-2 460740000987 2 Bon Homme Middle School   Regular School No Middle 06 08 2017   k_12_total 79.0   2.0 1.0             1.0   46.0 37.0       0.0               83.0 79   2 1             1   46 37                 83
3007194 SD     school 4607800 22001   Bowdle 22-1 460780000068 2 Bowdle Elementary   Regular School No Elementary PK 06 2017   k_12_total 61.0 0.0 2.0               1.0   34.0 30.0       0.0               64.0 61 0 2               1   34 30                 64
3007439 SD     school 4600041 45004   Britton-Hecla 45-4 460004101141 1 Britton-Hecla High School   Regular School No High 09 12 2017   k_12_total 89.0 2.0 1.0 5.0           1.0 1.0   46.0 53.0       0.0               99.0 89 2 1 5           1 1   46 53                 99
3007440 SD     school 4600041 45004   Britton-Hecla 45-4 460004101142 3 Britton-Hecla Junior High   Regular School No Middle 07 08 2017   k_12_total 36.0 1.0   1.0   1.0         1.0   29.0 11.0       0.0               40.0 36 1   1   1         1   29 11                 40
3008046 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School No Elementary PK 04 2017   k_12_total 102.0 0.0 8.0 2.0             1.0   60.0 53.0       4.4               113.0 102 0 8 2             1   60 53                 113
3008280 SD     school 4616950 16001   Custer 16-1 461695000992 5 Custer JH   Regular School No Middle 07 08 2017   k_12_total 94.0 1.0 4.0 7.0             1.0   45.0 62.0       0.0               107.0 94 1 4 7             1   45 62                 107
3008396 SD     school 4617850 38002   De Smet 38-2 461785000162 2 Laura Ingalls Wilder Elem   Regular School No Elementary KG 05 2017   k_12_total 141.0 5.0 1.0     1.0         1.0   77.0 72.0       0.7               149.0 141 5 1     1         1   77 72                 149
3008826 SD     school 4619450 64002   Dupree 64-2 461945000799 2 Dupree Elem   Regular School No Elementary PK 06 2017   k_12_total 33.0   6.0 189.0             1.0   110.0 119.0       2.6               229.0 33   6 189             1   110 119                 229
3008827 SD     school 4619450 64002   Dupree 64-2 461945000800 1 Dupree Hi Sch   Regular School No High 09 12 2017   k_12_total 20.0     83.0             1.0   52.0 52.0       1.0               104.0 20     83             1   52 52                 104
3009007 SD     school 4621300 16002   Elk Mountain 16-2 462130001186 92 Elk Mountain Virtual HS   Regular School No High 09 12 2017   k_12_total 1.0                   1.0   1.0 1.0       0.0               2.0 1                   1   1 1                 2
3009051 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000186 1 Elk Point Jefferson High School   Regular School No High 09 12 2017   k_12_total 173.0 4.0 4.0 1.0   2.0         1.0   94.0 91.0       0.0               185.0 173 4 4 1   2         1   94 91                 185
3009124 SD     school 4621390 5003   Elkton 05-3 462139000901 3 Elkton Junior High   Regular School No Middle 07 08 2017   k_12_total 53.0 1.0 4.0               1.0   35.0 24.0       3.4               59.0 53 1 4               1   35 24                 59
3009179 SD     school 4622410 28002   Estelline 28-2 462241000192 1 Estelline High School   Regular School No High 09 12 2017   k_12_total 61.0   7.0               1.0   29.0 40.0       2.9               69.0 61   7               1   29 40                 69
3009276 SD     school 4622560 44001   Eureka 44-1 462256000958 3 Eureka MS   Regular School No Middle 06 08 2017   k_12_total 30.0 1.0 1.0               1.0   20.0 13.0       0.0               33.0 30 1 1               1   20 13                 33
3009347 SD     school 4622940 46002   Faith 46-2 462294000806 1 Faith High School   Regular School No High 09 12 2017   k_12_total 55.0   2.0 3.0             1.0   33.0 28.0       1.6               61.0 55   2 3             1   33 28                 61
3009562 SD     school 4624540 14001   Florence 14-1 462454000208 2 Florence Elementary School   Regular School No Elementary PK 05 2017   k_12_total 131.0     1.0             1.0   69.0 64.0       0.0               133.0 131     1             1   69 64                 133
3009611 SD     school 4621400 6002   Frederick Area 06-2 462140000190 1 Frederick High School   Regular School No High 09 12 2017   k_12_total 55.0   1.0 1.0             1.0   30.0 28.0       0.0               58.0 55   1 1             1   30 28                 58
3009684 SD     school 4625500 33001   Freeman 33-1 462550000842 5 Freeman Jr High   Regular School No Middle 07 08 2017   k_12_total 35.0                   1.0   17.0 19.0       0.0               36.0 35                   1   17 19                 36
3009931 SD     school 4629880 26004   Gregory 26-4 462988000239 1 Gregory High School   Regular School No High 09 12 2017   k_12_total 94.0   2.0 9.0   1.0       2.0 1.0   62.0 47.0       0.0               109.0 94   2 9   1       2 1   62 47                 109
3010091 SD     school 4630800 28003   Hamlin 28-3 463080000260 1 Hamlin Hi Sch   Regular School No High 09 12 2017   k_12_total 185.0   2.0     1.0         1.0   95.0 94.0       0.0               189.0 185   2     1         1   95 94                 189
3010177 SD     school 4602640 30001   Hanson 30-1 460264000018 2 Hanson Middle School   Regular School No Middle 06 08 2017   k_12_total 89.0   3.0 1.0             1.0   56.0 38.0       0.0               94.0 89   3 1             1   56 38                 94
3010506 SD     school 4632430 10001   Herreid 10-1 463243000277 2 Herreid Elem   Regular School No Elementary KG 05 2017   k_12_total 47.0   1.0 1.0             1.0   28.0 22.0       0.0               50.0 47   1 1             1   28 22                 50
3010508 SD     school 4632430 10001   Herreid 10-1 463243000910 3 Herreid Middle Sch   Regular School No Middle 06 08 2017   k_12_total 15.0   1.0 1.0             1.0   11.0 7.0       0.0               18.0 15   1 1             1   11 7                 18
3011040 SD     school 4636060 22006   Ipswich Public 22-6 463606000333 1 Ipswich Hi Sch   Regular School No High 09 12 2017   k_12_total 94.0   3.0 1.0   2.0         1.0   49.0 52.0       0.0               101.0 94   3 1   2         1   49 52                 101
3011158 SD     school 4636150 2003   Iroquois 02-3 463615001144 4 Iroquois Elementary   Regular School No Elementary PK 05 2017   k_12_total 90.0 9.0 6.0 3.0             1.0   55.0 54.0       4.6               109.0 90 9 6 3             1   55 54                 109
3011420 SD     school 4639990 38003   Lake Preston 38-3 463999000918 3 Lake Preston Jr High   Regular School No Middle 07 08 2017   k_12_total 20.0                   1.0   10.0 11.0       0.0               21.0 20                   1   10 11                 21
3011595 SD     school 4641520 52004   Lemmon 52-4 464152000382 1 Lemmon High School   Regular School No High 09 12 2017   k_12_total 75.0   1.0 2.0   2.0         1.0   39.0 42.0       0.0               81.0 75   1 2   2         1   39 42                 81
3011596 SD     school 4641520 52004   Lemmon 52-4 464152000852 6 Lemmon Jr Hi   Regular School No Middle 07 08 2017   k_12_total 36.0     2.0             1.0   22.0 17.0       0.0               39.0 36     2             1   22 17                 39
3011670 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2017   k_12_total 76.0 0.0 4.0 4.0             1.0   48.0 37.0       0.0               85.0 76 0 4 4             1   48 37                 85
3011831 SD     school 4644770 42001   Lyman 42-1 464477000398 1 Lyman High School   Regular School No High 09 12 2017   k_12_total 73.0     33.0             1.0   54.0 53.0       0.0               107.0 73     33             1   54 53                 107
3011833 SD     school 4644770 42001   Lyman 42-1 464477000397 3 Presho Elementary   Regular School No Elementary PK 05 2017   k_12_total 71.0   1.0 15.0             1.0   47.0 41.0       0.0               88.0 71   1 15             1   47 41                 88
3011931 SD     school 4645450 60003   Marion 60-3 464545000408 1 Marion High School   Regular School No High 09 12 2017   k_12_total 43.0 1.0 5.0 1.0             1.0   27.0 24.0       3.9               51.0 43 1 5 1             1   27 24                 51
3011932 SD     school 4645450 60003   Marion 60-3 464545001050 3 Marion Middle School   Regular School No Middle 06 08 2017   k_12_total 32.0   3.0               1.0   19.0 17.0       0.0               36.0 32   3               1   19 17                 36
3012043 SD     school 4646260 15001   McIntosh 15-1 464626000411 1 McIntosh High School   Regular School No High 09 12 2017   k_12_total 29.0   1.0 13.0             1.0   19.0 25.0       0.0               44.0 29   1 13             1   19 25                 44
3012044 SD     school 4646260 15001   McIntosh 15-1 464626000921 3 McIntosh Jr High   Regular School No Middle 07 08 2017   k_12_total 17.0   1.0 8.0             1.0   15.0 12.0       0.0               27.0 17   1 8             1   15 12                 27
3012091 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No High 09 12 2017   k_12_total     2.0 129.0             1.0   77.0 55.0       13.6               132.0     2 129             1   77 55                 132
3012226 SD     school 4669930 46001   Meade 46-1 466993000741 15 Opal Elementary   Regular School No Elementary KG 08 2017   k_12_total 18.0   1.0               1.0   9.0 11.0       0.0               20.0 18   1               1   9 11                 20
3012440 SD     school 4647942 29004   Miller 464794201051 4 Miller Junior High   Regular School No Middle 07 08 2017   k_12_total 49.0 1.0                 1.0   21.0 30.0       0.0               51.0 49 1                 1   21 30                 51
3012678 SD     school 4648780 43002   Montrose 43-2 464878000451 2 Montrose Elementary School   Regular School No Elementary PK 05 2017   k_12_total 97.0 1.0 1.0               1.0   51.0 49.0       0.0               100.0 97 1 1               1   51 49                 100
3012679 SD     school 4648780 43002   Montrose 43-2 464878000452 1 Montrose High School   Regular School No High 09 12 2017   k_12_total 66.0 1.0 1.0               1.0   26.0 43.0       0.0               69.0 66 1 1               1   26 43                 69
3012779 SD     school 4650670 51003   New Underwood 51-3 465067000464 1 New Underwood Hi Sch   Regular School No High 09 12 2017   k_12_total 72.0     6.0             1.0   45.0 34.0       0.0               79.0 72     6             1   45 34                 79
3012828 SD     school 4650850 9002   Newell 09-2 465085000968 4 Newell Middle Sch   Regular School No Middle 06 08 2017   k_12_total 68.0 2.0 2.0 8.0   2.0       1.0 1.0   50.0 34.0       0.0               84.0 68 2 2 8   2       1 1   50 34                 84
3012875 SD     school 4651750 56007   Northwestern Area 56-7 465175000475 1 Northwestern High School   Regular School No High 09 12 2017   k_12_total 63.0                 2.0 1.0   32.0 34.0       0.0               66.0 63                 2 1   32 34                 66
3013006 SD     school 4665460 65001   Oglala Lakota 65-1 466546000573 1 Batesland School - 01   Regular School No Elementary PK 08 2017   k_12_total 1.0     184.0             1.0   87.0 99.0       1.1               186.0 1     184             1   87 99                 186
3013090 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701030 2 Oldham-Ramona Elementary   Regular School No Elementary PK 06 2017   k_12_total 66.0   2.0               1.0   35.0 34.0       0.0               69.0 66   2               1   35 34                 69
3013091 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701027 1 Oldham-Ramona High School   Regular School No High 09 12 2017   k_12_total 35.0                   1.0   25.0 11.0       0.0               36.0 35                   1   25 11                 36
3013092 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701035 3 Oldham-Ramona Junior High School   Regular School No Middle 07 08 2017   k_12_total 15.0                   1.0   8.0 8.0       0.0               16.0 15                   1   8 8                 16
3013147 SD     school 4654270 60004   Parker 60-4 465427000488 1 Parker High School   Regular School No High 09 12 2017   k_12_total 108.0 1.0 3.0 2.0           1.0 1.0   62.0 54.0       1.7               116.0 108 1 3 2           1 1   62 54                 116
3013235 SD     school 4654300 33003   Parkston 33-3 465430000926 5 Parkston Junior High   Regular School No Middle 07 08 2017   k_12_total 56.0   1.0               1.0   31.0 27.0       1.7               58.0 56   1               1   31 27                 58
3013804 SD     school 4659820 51004   Rapid City Area 51-4 465982001341 44 Lincoln Building   Special Education School No High 12 12 2017   k_12_total 22.0     2.0   2.0         1.0   19.0 8.0       3.7               27.0 22     2   2         1   19 8                 27
3014071 SD     school 4664140 39004   Rutland 39-4 466414000562 2 Rutland Elem   Regular School No Elementary KG 05 2017   k_12_total 79.0                   1.0   38.0 42.0       0.0               80.0 79                   1   38 42                 80
3014072 SD     school 4664140 39004   Rutland 39-4 466414000563 1 Rutland Hi Sch   Regular School No High 09 12 2017   k_12_total 35.0 1.0       1.0         1.0   21.0 17.0       0.0               38.0 35 1       1         1   21 17                 38
3014135 SD     school 4603932 55005   Sanborn Central 55-5 460393200099 1 Sanborn Central High School   Regular School No High 09 12 2017   k_12_total 42.0   1.0 1.0             1.0   25.0 20.0       0.0               45.0 42   1 1             1   25 20                 45
3014136 SD     school 4603932 55005   Sanborn Central 55-5 460393200102 2 Sanborn Central Middle School   Regular School No Middle 06 08 2017   k_12_total 36.0   1.0 1.0           1.0 1.0   18.0 22.0       0.0               40.0 36   1 1           1 1   18 22                 40
3014187 SD     school 4665180 4003   Scotland 04-3 466518000569 1 Scotland High School   Regular School No High 09 12 2017   k_12_total 83.0   2.0               1.0   43.0 43.0       1.2               86.0 83   2               1   43 43                 86
3014188 SD     school 4665180 4003   Scotland 04-3 466518000933 5 Scotland Middle School   Regular School No Middle 06 08 2017   k_12_total 63.0                   1.0   28.0 36.0       0.0               64.0 63                   1   28 36                 64
3014236 SD     school 4601028 62005   Selby Area 62-5 460102801036 3 Selby Jr Hi   Regular School No Middle 07 08 2017   k_12_total 37.0     1.0             1.0   20.0 19.0       0.0               39.0 37     1             1   20 19                 39
3014755 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School No High 12 12 2017   k_12_total 30.0 2.0 4.0 3.0   2.0         1.0   26.0 16.0       9.5               42.0 30 2 4 3   2         1   26 16                 42
3014783 SD     school 4666270 49005   Sioux Falls 49-5 466627001138 12 Structured Teaching Program   Special Education School No Other 06 12 2017   k_12_total 7.0 4.0 1.0 3.0             1.0   15.0 1.0       0.0               16.0 7 4 1 3             1   15 1                 16
3014784 SD     school 4666270 49005   Sioux Falls 49-5 466627001121 39 Success Academy   Special Education School No Other 06 12 2017   k_12_total 14.0 2.0 1.0 2.0             1.0   17.0 3.0       5.0               20.0 14 2 1 2             1   17 3                 20
3014955 SD     school 4666300 5005   Sioux Valley 05-5 466630000612 1 Sioux Valley High School   Regular School No High 09 12 2017   k_12_total 187.0 1.0 14.0 2.0   1.0         1.0   104.0 102.0       2.4               206.0 187 1 14 2   1         1   104 102                 206
3015100 SD     school 4607670 26005   South Central 26-5 460767000881 2 South Central MS   Regular School No Middle 06 08 2017   k_12_total 16.0     6.0             1.0   14.0 9.0       0.0               23.0 16     6             1   14 9                 23
3015418 SD     school 4671880 20003   Timber Lake 20-3 467188000664 2 Timber Lake Elementary K-5   Regular School No Elementary PK 05 2017   k_12_total 68.0 1.0 5.0 91.0             1.0   93.0 73.0       0.0               166.0 68 1 5 91             1   93 73                 166
3015562 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No Elementary KG 08 2017   k_12_total     3.0 137.0             1.0   77.0 64.0       0.7               141.0     3 137             1   77 64                 141
3015564 SD     school 4672090 66001   Todd County 66-1 467209000504 9 Lakeview Elementary   Regular School No Elementary KG 08 2017   k_12_total 9.0     37.0             1.0   23.0 24.0       2.1               47.0 9     37             1   23 24                 47
3015565 SD     school 4672090 66001   Todd County 66-1 467209000506 12 Littleburg Elementary   Regular School No Elementary KG 08 2017   k_12_total 2.0     37.0             1.0   19.0 21.0       2.5               40.0 2     37             1   19 21                 40
3015568 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No Elementary KG 08 2017   k_12_total       70.0             1.0   36.0 35.0       0.0               71.0       70             1   36 35                 71
3015716 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000062 3 Tripp-Delmont Elementary K-6   Regular School No Elementary PK 06 2017   k_12_total 64.0   2.0 7.0   2.0         1.0   36.0 40.0       0.0               76.0 64   2 7   2         1   36 40                 76
3015975 SD     school 4675660 51005   Wall 51-5 467566000704 2 Wall Elementary School   Regular School No Elementary KG 05 2017   k_12_total 93.0 2.0   18.0   1.0         1.0   54.0 61.0       0.0               115.0 93 2   18   1         1   54 61                 115
3015976 SD     school 4675660 51005   Wall 51-5 467566000705 1 Wall High School   Regular School No High 09 12 2017   k_12_total 63.0     11.0             1.0   36.0 39.0       0.0               75.0 63     11             1   36 39                 75
3016026 SD     school 4676020 6005   Warner 06-5 467602000708 2 Warner Elementary School   Regular School No Elementary KG 05 2017   k_12_total 138.0 1.0 3.0 3.0             1.0   62.0 84.0       0.0               146.0 138 1 3 3             1   62 84                 146
3016027 SD     school 4676020 6005   Warner 06-5 467602000709 1 Warner Hi Sch   Regular School No High 09 12 2017   k_12_total 85.0 2.0 1.0 6.0   1.0         1.0   48.0 48.0       2.1               96.0 85 2 1 6   1         1   48 48                 96
3016299 SD     school 4676990 18005   Webster Area 467699000724 1 Webster Area High School   Regular School No High 09 12 2017   k_12_total 153.0   2.0 2.0             1.0   86.0 72.0       0.0               158.0 153   2 2             1   86 72                 158
3016371 SD     school 4677460 36002   Wessington Springs 36-2 467746000732 2 Wessington Springs Elem   Regular School No Elementary PK 06 2017   k_12_total 138.0   14.0               1.0   73.0 80.0       5.9               153.0 138   14               1   73 80                 153
3016552 SD     school 4678570 47001   White River 47-1 467857000754 1 White River High School   Regular School No High 09 12 2017   k_12_total 16.0 2.0   87.0   1.0       1.0 1.0   57.0 51.0       2.8               108.0 16 2   87   1       1 1   57 51                 108
3016553 SD     school 4678570 47001   White River 47-1 467857000951 4 White River Middle Sch   Regular School No Middle 06 08 2017   k_12_total 7.0 2.0   86.0             1.0   49.0 47.0       1.0               96.0 7 2   86             1   49 47                 96
3016698 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2017   k_12_total 66.0 2.0 2.0 25.0             1.0   50.0 46.0       0.0               96.0 66 2 2 25             1   50 46                 96
3016747 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No High 09 12 2017   k_12_total 142.0 1.0 1.0 49.0           1.0 1.0   103.0 92.0       0.0               195.0 142 1 1 49           1 1   103 92                 195
3016795 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School No High 09 12 2017   k_12_total 90.0 5.0 5.0 2.0             1.0   69.0 34.0       0.0               103.0 90 5 5 2             1   69 34                 103
3016831 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2017   k_12_total 62.0   2.0               1.0   34.0 31.0       0.0               65.0 62   2               1   34 31                 65
3006492 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No Middle 07 08 2017   k_12_total 45.0   3.0               2.0   24.0 26.0       0.0               50.0 45   3               2   24 26                 50
3006614 SD     school 4603720 38001   Arlington 38-1 460372000021 2 Arlington Elementary   Regular School No Elementary PK 06 2017   k_12_total 139.0 2.0 9.0 1.0   1.0         2.0   66.0 88.0       0.0               154.0 139 2 9 1   1         2   66 88                 154
3006666 SD     school 4603780 21001   Armour 21-1 460378000023 2 Armour Elementary   Regular School No Elementary KG 05 2017   k_12_total 65.0 4.0 1.0 2.0             2.0   44.0 30.0       0.0               74.0 65 4 1 2             2   44 30                 74
3007690 SD     school 4610560 41001   Canton 41-1 461056000109 1 Canton High School   Regular School No High 09 12 2017   k_12_total 254.0 1.0 4.0 5.0   5.0         2.0   135.0 136.0       0.4               271.0 254 1 4 5   5         2   135 136                 271
3007946 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative School No High 09 12 2017   k_12_total 48.0 1.0 1.0 2.0             2.0   19.0 35.0       0.0               54.0 48 1 1 2             2   19 35                 54

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