Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 669

grade

  • pk_12_total · 669
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int ▼ unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
3006446 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No Elementary KG 05 2017   pk_12_total 21.0   3.0 5.0             1.0   19.0 11.0                       30.0 21   3 5             1   19 11                 30
3006447 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No Elementary KG 06 2017   pk_12_total 95.0   1.0 2.0   1.0         1.0   54.0 46.0                       100.0 95   1 2   1         1   54 46                 100
3006559 SD     school 4639540 11001   Andes Central 11-1 463954000360 1 Andes Central High School   Regular School No High 09 12 2017   pk_12_total 9.0     53.0             1.0   38.0 25.0                       63.0 9     53             1   38 25                 63
3006623 SD     school 4603720 38001   Arlington 38-1 460372000022 1 Arlington High School   Regular School No High 09 12 2017   pk_12_total 73.0   1.0               1.0   38.0 37.0                       75.0 73   1               1   38 37                 75
3006735 SD     school 4604270 4001   Avon 04-1 460427000029 1 Avon High School   Regular School No High 09 12 2017   pk_12_total 77.0   4.0 3.0             1.0   46.0 39.0                       85.0 77   4 3             1   46 39                 85
3006736 SD     school 4604270 4001   Avon 04-1 460427000829 5 Avon Jr High School   Regular School No Middle 07 08 2017   pk_12_total 33.0     2.0             1.0   16.0 20.0                       36.0 33     2             1   16 20                 36
3006785 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School No High 09 12 2017   pk_12_total 137.0   4.0     2.0         1.0   84.0 60.0                       144.0 137   4     2         1   84 60                 144
3006860 SD     school 4605610 9001   Belle Fourche 09-1 460561001277 9 Belle Fourche Education Connection   Alternative School No High 09 12 2017   pk_12_total 26.0   2.0 4.0             1.0   21.0 12.0                       33.0 26   2 4             1   21 12                 33
3007040 SD     school 4607050 52001   Bison 52-1 460705000054 2 Bison Elementary   Regular School No Elementary KG 06 2017   pk_12_total 74.0   5.0 2.0   1.0         1.0   39.0 44.0                       83.0 74   5 2   1         1   39 44                 83
3007144 SD     school 4607400 4002   Bon Homme 04-2 460740000065 1 Bon Homme High School   Regular School No High 09 12 2017   pk_12_total 132.0   2.0 2.0             1.0   73.0 64.0                       137.0 132   2 2             1   73 64                 137
3007145 SD     school 4607400 4002   Bon Homme 04-2 460740000987 2 Bon Homme Middle School   Regular School No Middle 06 08 2017   pk_12_total 79.0   2.0 1.0             1.0   46.0 37.0                       83.0 79   2 1             1   46 37                 83
3007200 SD     school 4607800 22001   Bowdle 22-1 460780000068 2 Bowdle Elementary   Regular School No Elementary PK 06 2017   pk_12_total 67.0 1.0 2.0               1.0   38.0 33.0                       71.0 67 1 2               1   38 33                 71
3007451 SD     school 4600041 45004   Britton-Hecla 45-4 460004101141 1 Britton-Hecla High School   Regular School No High 09 12 2017   pk_12_total 89.0 2.0 1.0 5.0           1.0 1.0   46.0 53.0                       99.0 89 2 1 5           1 1   46 53                 99
3007452 SD     school 4600041 45004   Britton-Hecla 45-4 460004101142 3 Britton-Hecla Junior High   Regular School No Middle 07 08 2017   pk_12_total 36.0 1.0   1.0   1.0         1.0   29.0 11.0                       40.0 36 1   1   1         1   29 11                 40
3008288 SD     school 4616950 16001   Custer 16-1 461695000992 5 Custer JH   Regular School No Middle 07 08 2017   pk_12_total 94.0 1.0 4.0 7.0             1.0   45.0 62.0                       107.0 94 1 4 7             1   45 62                 107
3008402 SD     school 4617850 38002   De Smet 38-2 461785000162 2 Laura Ingalls Wilder Elem   Regular School No Elementary KG 05 2017   pk_12_total 141.0 5.0 1.0     1.0         1.0   77.0 72.0                       149.0 141 5 1     1         1   77 72                 149
3008524 SD     school 4678300 5006   Deubrook Area 05-6 467830000559 3 Deubrook Elementary   Regular School No Elementary PK 06 2017   pk_12_total 167.0 1.0 5.0 3.0   1.0         1.0   88.0 90.0                       178.0 167 1 5 3   1         1   88 90                 178
3008832 SD     school 4619450 64002   Dupree 64-2 461945000799 2 Dupree Elem   Regular School No Elementary PK 06 2017   pk_12_total 35.0   7.0 204.0             1.0   118.0 129.0                       247.0 35   7 204             1   118 129                 247
3008833 SD     school 4619450 64002   Dupree 64-2 461945000800 1 Dupree Hi Sch   Regular School No High 09 12 2017   pk_12_total 20.0     83.0             1.0   52.0 52.0                       104.0 20     83             1   52 52                 104
3009011 SD     school 4621300 16002   Elk Mountain 16-2 462130001186 92 Elk Mountain Virtual HS   Regular School No High 09 12 2017   pk_12_total 1.0                   1.0   1.0 1.0                       2.0 1                   1   1 1                 2
3009057 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000186 1 Elk Point Jefferson High School   Regular School No High 09 12 2017   pk_12_total 173.0 4.0 4.0 1.0   2.0         1.0   94.0 91.0                       185.0 173 4 4 1   2         1   94 91                 185
3009134 SD     school 4621390 5003   Elkton 05-3 462139000901 3 Elkton Junior High   Regular School No Middle 07 08 2017   pk_12_total 53.0 1.0 4.0               1.0   35.0 24.0                       59.0 53 1 4               1   35 24                 59
3009185 SD     school 4622410 28002   Estelline 28-2 462241000192 1 Estelline High School   Regular School No High 09 12 2017   pk_12_total 61.0   7.0               1.0   29.0 40.0                       69.0 61   7               1   29 40                 69
3009282 SD     school 4622560 44001   Eureka 44-1 462256000958 3 Eureka MS   Regular School No Middle 06 08 2017   pk_12_total 30.0 1.0 1.0               1.0   20.0 13.0                       33.0 30 1 1               1   20 13                 33
3009357 SD     school 4622940 46002   Faith 46-2 462294000806 1 Faith High School   Regular School No High 09 12 2017   pk_12_total 55.0   2.0 3.0             1.0   33.0 28.0                       61.0 55   2 3             1   33 28                 61
3009359 SD     school 4622940 46002   Faith 46-2 462294001306 10 Faith PreSchool   Regular School No Elementary PK PK 2017   pk_12_total 5.0                   1.0   3.0 3.0                       6.0 5                   1   3 3                 6
3009568 SD     school 4624540 14001   Florence 14-1 462454000208 2 Florence Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 144.0     2.0             1.0   73.0 74.0                       147.0 144     2             1   73 74                 147
3009617 SD     school 4621400 6002   Frederick Area 06-2 462140000190 1 Frederick High School   Regular School No High 09 12 2017   pk_12_total 55.0   1.0 1.0             1.0   30.0 28.0                       58.0 55   1 1             1   30 28                 58
3009694 SD     school 4625500 33001   Freeman 33-1 462550000842 5 Freeman Jr High   Regular School No Middle 07 08 2017   pk_12_total 35.0                   1.0   17.0 19.0                       36.0 35                   1   17 19                 36
3009937 SD     school 4629880 26004   Gregory 26-4 462988000239 1 Gregory High School   Regular School No High 09 12 2017   pk_12_total 94.0   2.0 9.0   1.0       2.0 1.0   62.0 47.0                       109.0 94   2 9   1       2 1   62 47                 109
3010097 SD     school 4630800 28003   Hamlin 28-3 463080000260 1 Hamlin Hi Sch   Regular School No High 09 12 2017   pk_12_total 185.0   2.0     1.0         1.0   95.0 94.0                       189.0 185   2     1         1   95 94                 189
3010189 SD     school 4602640 30001   Hanson 30-1 460264000018 2 Hanson Middle School   Regular School No Middle 06 08 2017   pk_12_total 89.0   3.0 1.0             1.0   56.0 38.0                       94.0 89   3 1             1   56 38                 94
3010512 SD     school 4632430 10001   Herreid 10-1 463243000277 2 Herreid Elem   Regular School No Elementary KG 05 2017   pk_12_total 47.0   1.0 1.0             1.0   28.0 22.0                       50.0 47   1 1             1   28 22                 50
3010514 SD     school 4632430 10001   Herreid 10-1 463243000910 3 Herreid Middle Sch   Regular School No Middle 06 08 2017   pk_12_total 15.0   1.0 1.0             1.0   11.0 7.0                       18.0 15   1 1             1   11 7                 18
3011052 SD     school 4636060 22006   Ipswich Public 22-6 463606000333 1 Ipswich Hi Sch   Regular School No High 09 12 2017   pk_12_total 94.0   3.0 1.0   2.0         1.0   49.0 52.0                       101.0 94   3 1   2         1   49 52                 101
3011166 SD     school 4636150 2003   Iroquois 02-3 463615001144 4 Iroquois Elementary   Regular School No Elementary PK 05 2017   pk_12_total 100.0 10.0 6.0 3.0             1.0   60.0 60.0                       120.0 100 10 6 3             1   60 60                 120
3011426 SD     school 4639990 38003   Lake Preston 38-3 463999000918 3 Lake Preston Jr High   Regular School No Middle 07 08 2017   pk_12_total 20.0                   1.0   10.0 11.0                       21.0 20                   1   10 11                 21
3011601 SD     school 4641520 52004   Lemmon 52-4 464152000382 1 Lemmon High School   Regular School No High 09 12 2017   pk_12_total 75.0   1.0 2.0   2.0         1.0   39.0 42.0                       81.0 75   1 2   2         1   39 42                 81
3011602 SD     school 4641520 52004   Lemmon 52-4 464152000852 6 Lemmon Jr Hi   Regular School No Middle 07 08 2017   pk_12_total 36.0     2.0             1.0   22.0 17.0                       39.0 36     2             1   22 17                 39
3011680 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No Elementary PK 04 2017   pk_12_total 91.0 1.0 4.0 4.0             1.0   57.0 44.0                       101.0 91 1 4 4             1   57 44                 101
3011839 SD     school 4644770 42001   Lyman 42-1 464477000398 1 Lyman High School   Regular School No High 09 12 2017   pk_12_total 73.0     33.0             1.0   54.0 53.0                       107.0 73     33             1   54 53                 107
3011937 SD     school 4645450 60003   Marion 60-3 464545000408 1 Marion High School   Regular School No High 09 12 2017   pk_12_total 43.0 1.0 5.0 1.0             1.0   27.0 24.0                       51.0 43 1 5 1             1   27 24                 51
3011938 SD     school 4645450 60003   Marion 60-3 464545001050 3 Marion Middle School   Regular School No Middle 06 08 2017   pk_12_total 32.0   3.0               1.0   19.0 17.0                       36.0 32   3               1   19 17                 36
3012049 SD     school 4646260 15001   McIntosh 15-1 464626000411 1 McIntosh High School   Regular School No High 09 12 2017   pk_12_total 29.0   1.0 13.0             1.0   19.0 25.0                       44.0 29   1 13             1   19 25                 44
3012050 SD     school 4646260 15001   McIntosh 15-1 464626000921 3 McIntosh Jr High   Regular School No Middle 07 08 2017   pk_12_total 17.0   1.0 8.0             1.0   15.0 12.0                       27.0 17   1 8             1   15 12                 27
3012097 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No High 09 12 2017   pk_12_total     2.0 129.0             1.0   77.0 55.0                       132.0     2 129             1   77 55                 132
3012246 SD     school 4669930 46001   Meade 46-1 466993000741 15 Opal Elementary   Regular School No Elementary KG 08 2017   pk_12_total 18.0   1.0               1.0   9.0 11.0                       20.0 18   1               1   9 11                 20
3012448 SD     school 4647942 29004   Miller 464794201051 4 Miller Junior High   Regular School No Middle 07 08 2017   pk_12_total 49.0 1.0                 1.0   21.0 30.0                       51.0 49 1                 1   21 30                 51
3012686 SD     school 4648780 43002   Montrose 43-2 464878000451 2 Montrose Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 99.0 1.0 1.0               1.0   52.0 50.0                       102.0 99 1 1               1   52 50                 102
3012687 SD     school 4648780 43002   Montrose 43-2 464878000452 1 Montrose High School   Regular School No High 09 12 2017   pk_12_total 66.0 1.0 1.0               1.0   26.0 43.0                       69.0 66 1 1               1   26 43                 69
3012785 SD     school 4650670 51003   New Underwood 51-3 465067000464 1 New Underwood Hi Sch   Regular School No High 09 12 2017   pk_12_total 72.0     6.0             1.0   45.0 34.0                       79.0 72     6             1   45 34                 79
3012834 SD     school 4650850 9002   Newell 09-2 465085000968 4 Newell Middle Sch   Regular School No Middle 06 08 2017   pk_12_total 68.0 2.0 2.0 8.0   2.0       1.0 1.0   50.0 34.0                       84.0 68 2 2 8   2       1 1   50 34                 84
3012881 SD     school 4651750 56007   Northwestern Area 56-7 465175000475 1 Northwestern High School   Regular School No High 09 12 2017   pk_12_total 63.0                 2.0 1.0   32.0 34.0                       66.0 63                 2 1   32 34                 66
3013018 SD     school 4665460 65001   Oglala Lakota 65-1 466546000573 1 Batesland School - 01   Regular School No Elementary PK 08 2017   pk_12_total 1.0     187.0             1.0   88.0 101.0                       189.0 1     187             1   88 101                 189
3013100 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701030 2 Oldham-Ramona Elementary   Regular School No Elementary PK 06 2017   pk_12_total 84.0   3.0               1.0   45.0 43.0                       88.0 84   3               1   45 43                 88
3013101 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701027 1 Oldham-Ramona High School   Regular School No High 09 12 2017   pk_12_total 35.0                   1.0   25.0 11.0                       36.0 35                   1   25 11                 36
3013102 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701035 3 Oldham-Ramona Junior High School   Regular School No Middle 07 08 2017   pk_12_total 15.0                   1.0   8.0 8.0                       16.0 15                   1   8 8                 16
3013153 SD     school 4654270 60004   Parker 60-4 465427000488 1 Parker High School   Regular School No High 09 12 2017   pk_12_total 108.0 1.0 3.0 2.0           1.0 1.0   62.0 54.0                       116.0 108 1 3 2           1 1   62 54                 116
3013247 SD     school 4654300 33003   Parkston 33-3 465430000926 5 Parkston Junior High   Regular School No Middle 07 08 2017   pk_12_total 56.0   1.0               1.0   31.0 27.0                       58.0 56   1               1   31 27                 58
3013852 SD     school 4659820 51004   Rapid City Area 51-4 465982001072 64 Jefferson Building   Special Education School No Other PK 12 2017   pk_12_total 23.0 1.0 2.0 9.0             1.0   24.0 12.0                       36.0 23 1 2 9             1   24 12                 36
3013854 SD     school 4659820 51004   Rapid City Area 51-4 465982001341 44 Lincoln Building   Special Education School No High 12 12 2017   pk_12_total 22.0     2.0   2.0         1.0   19.0 8.0                       27.0 22     2   2         1   19 8                 27
3014079 SD     school 4664140 39004   Rutland 39-4 466414000562 2 Rutland Elem   Regular School No Elementary KG 05 2017   pk_12_total 79.0                   1.0   38.0 42.0                       80.0 79                   1   38 42                 80
3014080 SD     school 4664140 39004   Rutland 39-4 466414000563 1 Rutland Hi Sch   Regular School No High 09 12 2017   pk_12_total 35.0 1.0       1.0         1.0   21.0 17.0                       38.0 35 1       1         1   21 17                 38
3014143 SD     school 4603932 55005   Sanborn Central 55-5 460393200099 1 Sanborn Central High School   Regular School No High 09 12 2017   pk_12_total 42.0   1.0 1.0             1.0   25.0 20.0                       45.0 42   1 1             1   25 20                 45
3014144 SD     school 4603932 55005   Sanborn Central 55-5 460393200102 2 Sanborn Central Middle School   Regular School No Middle 06 08 2017   pk_12_total 36.0   1.0 1.0           1.0 1.0   18.0 22.0                       40.0 36   1 1           1 1   18 22                 40
3014193 SD     school 4665180 4003   Scotland 04-3 466518000569 1 Scotland High School   Regular School No High 09 12 2017   pk_12_total 83.0   2.0               1.0   43.0 43.0                       86.0 83   2               1   43 43                 86
3014194 SD     school 4665180 4003   Scotland 04-3 466518000933 5 Scotland Middle School   Regular School No Middle 06 08 2017   pk_12_total 63.0                   1.0   28.0 36.0                       64.0 63                   1   28 36                 64
3014242 SD     school 4601028 62005   Selby Area 62-5 460102801036 3 Selby Jr Hi   Regular School No Middle 07 08 2017   pk_12_total 37.0     1.0             1.0   20.0 19.0                       39.0 37     1             1   20 19                 39
3014839 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School No High 12 12 2017   pk_12_total 30.0 2.0 4.0 3.0   2.0         1.0   26.0 16.0                       42.0 30 2 4 3   2         1   26 16                 42
3014867 SD     school 4666270 49005   Sioux Falls 49-5 466627001138 12 Structured Teaching Program   Special Education School No Other 06 12 2017   pk_12_total 7.0 4.0 1.0 3.0             1.0   15.0 1.0                       16.0 7 4 1 3             1   15 1                 16
3014868 SD     school 4666270 49005   Sioux Falls 49-5 466627001121 39 Success Academy   Special Education School No Other 06 12 2017   pk_12_total 14.0 2.0 1.0 2.0             1.0   17.0 3.0                       20.0 14 2 1 2             1   17 3                 20
3014961 SD     school 4666300 5005   Sioux Valley 05-5 466630000612 1 Sioux Valley High School   Regular School No High 09 12 2017   pk_12_total 187.0 1.0 14.0 2.0   1.0         1.0   104.0 102.0                       206.0 187 1 14 2   1         1   104 102                 206
3015106 SD     school 4607670 26005   South Central 26-5 460767000881 2 South Central MS   Regular School No Middle 06 08 2017   pk_12_total 16.0     6.0             1.0   14.0 9.0                       23.0 16     6             1   14 9                 23
3015584 SD     school 4672090 66001   Todd County 66-1 467209000669 5 He Dog School   Regular School No Elementary KG 08 2017   pk_12_total     3.0 137.0             1.0   77.0 64.0                       141.0     3 137             1   77 64                 141
3015586 SD     school 4672090 66001   Todd County 66-1 467209000504 9 Lakeview Elementary   Regular School No Elementary KG 08 2017   pk_12_total 9.0     37.0             1.0   23.0 24.0                       47.0 9     37             1   23 24                 47
3015587 SD     school 4672090 66001   Todd County 66-1 467209000506 12 Littleburg Elementary   Regular School No Elementary KG 08 2017   pk_12_total 2.0     37.0             1.0   19.0 21.0                       40.0 2     37             1   19 21                 40
3015590 SD     school 4672090 66001   Todd County 66-1 467209000677 7 Spring Creek Elem   Regular School No Elementary KG 08 2017   pk_12_total       70.0             1.0   36.0 35.0                       71.0       70             1   36 35                 71
3015726 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000062 3 Tripp-Delmont Elementary K-6   Regular School No Elementary PK 06 2017   pk_12_total 70.0   2.0 8.0   2.0         1.0   40.0 43.0                       83.0 70   2 8   2         1   40 43                 83
3015983 SD     school 4675660 51005   Wall 51-5 467566000704 2 Wall Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 93.0 2.0   18.0   1.0         1.0   54.0 61.0                       115.0 93 2   18   1         1   54 61                 115
3015984 SD     school 4675660 51005   Wall 51-5 467566000705 1 Wall High School   Regular School No High 09 12 2017   pk_12_total 63.0     11.0             1.0   36.0 39.0                       75.0 63     11             1   36 39                 75
3016032 SD     school 4676020 6005   Warner 06-5 467602000708 2 Warner Elementary School   Regular School No Elementary KG 05 2017   pk_12_total 138.0 1.0 3.0 3.0             1.0   62.0 84.0                       146.0 138 1 3 3             1   62 84                 146
3016033 SD     school 4676020 6005   Warner 06-5 467602000709 1 Warner Hi Sch   Regular School No High 09 12 2017   pk_12_total 85.0 2.0 1.0 6.0   1.0         1.0   48.0 48.0                       96.0 85 2 1 6   1         1   48 48                 96
3016305 SD     school 4676990 18005   Webster Area 467699000724 1 Webster Area High School   Regular School No High 09 12 2017   pk_12_total 153.0   2.0 2.0             1.0   86.0 72.0                       158.0 153   2 2             1   86 72                 158
3016381 SD     school 4677460 36002   Wessington Springs 36-2 467746000732 2 Wessington Springs Elem   Regular School No Elementary PK 06 2017   pk_12_total 164.0   16.0               1.0   93.0 88.0                       181.0 164   16               1   93 88                 181
3016560 SD     school 4678570 47001   White River 47-1 467857000754 1 White River High School   Regular School No High 09 12 2017   pk_12_total 16.0 2.0   87.0   1.0       1.0 1.0   57.0 51.0                       108.0 16 2   87   1       1 1   57 51                 108
3016561 SD     school 4678570 47001   White River 47-1 467857000951 4 White River Middle Sch   Regular School No Middle 06 08 2017   pk_12_total 7.0 2.0   86.0             1.0   49.0 47.0                       96.0 7 2   86             1   49 47                 96
3016704 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2017   pk_12_total 84.0 2.0 3.0 25.0             1.0   57.0 58.0                       115.0 84 2 3 25             1   57 58                 115
3016753 SD     school 4679710 59002   Winner 59-2 467971000781 1 Winner High School   Regular School No High 09 12 2017   pk_12_total 142.0 1.0 1.0 49.0           1.0 1.0   103.0 92.0                       195.0 142 1 1 49           1 1   103 92                 195
3016801 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000784 1 Wolsey-Wessington High School   Regular School No High 09 12 2017   pk_12_total 90.0 5.0 5.0 2.0             1.0   69.0 34.0                       103.0 90 5 5 2             1   69 34                 103
3016835 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No High 09 12 2017   pk_12_total 62.0   2.0               1.0   34.0 31.0                       65.0 62   2               1   34 31                 65
3006498 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No Middle 07 08 2017   pk_12_total 45.0   3.0               2.0   24.0 26.0                       50.0 45   3               2   24 26                 50
3006622 SD     school 4603720 38001   Arlington 38-1 460372000021 2 Arlington Elementary   Regular School No Elementary PK 06 2017   pk_12_total 139.0 2.0 9.0 1.0   1.0         2.0   66.0 88.0                       154.0 139 2 9 1   1         2   66 88                 154
3006672 SD     school 4603780 21001   Armour 21-1 460378000023 2 Armour Elementary   Regular School No Elementary KG 05 2017   pk_12_total 65.0 4.0 1.0 2.0             2.0   44.0 30.0                       74.0 65 4 1 2             2   44 30                 74
3007146 SD     school 4607400 4002   Bon Homme 04-2 460740001328 8 Bon Homme PK   Regular School No Elementary PK PK 2017   pk_12_total 35.0                   2.0   20.0 17.0                       37.0 35                   2   20 17                 37
3007696 SD     school 4610560 41001   Canton 41-1 461056000109 1 Canton High School   Regular School No High 09 12 2017   pk_12_total 254.0 1.0 4.0 5.0   5.0         2.0   135.0 136.0                       271.0 254 1 4 5   5         2   135 136                 271
3007960 SD     school 4612300 39001   Chester Area 39-1 461230001295 6 Alternative School   Alternative School No High 09 12 2017   pk_12_total 48.0 1.0 1.0 2.0             2.0   19.0 35.0                       54.0 48 1 1 2             2   19 35                 54
3008058 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School No Elementary PK 04 2017   pk_12_total 120.0 1.0 11.0 2.0             2.0   72.0 64.0                       136.0 120 1 11 2             2   72 64                 136
3008176 SD     school 4614130 59003   Colome Consolidated 461413000893 3 Colome Middle School   Regular School No Middle 06 08 2017   pk_12_total 42.0   2.0 5.0   2.0         2.0   29.0 24.0                       53.0 42   2 5   2         2   29 24                 53
3009133 SD     school 4621390 5003   Elkton 05-3 462139000188 1 Elkton High School   Regular School No High 09 12 2017   pk_12_total 90.0   8.0             1.0 2.0   58.0 43.0                       101.0 90   8             1 2   58 43                 101
3009233 SD     school 4622500 17001   Ethan 17-1 462250000194 1 Ethan High School   Regular School No High 09 12 2017   pk_12_total 68.0   2.0               2.0   37.0 35.0                       72.0 68   2               2   37 35                 72

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