Data source: Big Local News · About: Big Local

666 rows where grade = "pk_12_total", state = "SD" and year = 2016 sorted by native_american_int

View and edit SQL

year

  • 2016 · 666

grade

  • pk_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
3344426 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No 2 07 08 2016   pk_12_total 37.0   2.0 1.0                 22.0 18.0                       40.0 37   2 1                 22 18                 40
3344586 SD     school 4603780 21001   Armour 21-1 460378000878 3 Armour Middle School   Regular School No 2 06 08 2016   pk_12_total 40.0     1.0                 19.0 22.0                       41.0 40     1                 19 22                 41
3344648 SD     school 4604270 4001   Avon 04-1 460427000829 5 Avon Jr High School   Regular School No 2 07 08 2016   pk_12_total 29.0   2.0 1.0                 16.0 16.0                       32.0 29   2 1                 16 16                 32
3344696 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School No 1 PK 05 2016   pk_12_total 247.0   7.0 1.0   2.0         3.0   132.0 128.0                       260.0 247   7 1   2         3   132 128                 260
3344697 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School No 3 09 12 2016   pk_12_total 139.0 1.0 5.0 1.0   2.0             85.0 63.0                       148.0 139 1 5 1   2             85 63                 148
3344775 SD     school 4605610 9001   Belle Fourche 09-1 460561000289 8 North Park Elementary   Regular School No 1 KG KG 2016   pk_12_total 92.0   8.0 1.0             6.0   55.0 52.0                       107.0 92   8 1             6   55 52                 107
3344953 SD     school 4607050 52001   Bison 52-1 460705000055 1 Bison High School   Regular School No 3 09 12 2016   pk_12_total 40.0     1.0                 25.0 16.0                       41.0 40     1                 25 16                 41
3345070 SD     school 4607400 4002   Bon Homme 04-2 460740000065 1 Bon Homme High School   Regular School No 3 09 12 2016   pk_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
3345075 SD     school 4607400 4002   Bon Homme 04-2 460740001350 9 Springfield Preschool   Regular School No 1 PK PK 2016   pk_12_total 11.0     1.0                 8.0 4.0                       12.0 11     1                 8 4                 12
3345076 SD     school 4607400 4002   Bon Homme 04-2 460740000063 5 Tabor Elementary   Regular School No 1 KG 05 2016   pk_12_total 39.0   1.0 1.0                 21.0 20.0                       41.0 39   1 1                 21 20                 41
3345396 SD     school 4600041 45004   Britton-Hecla 45-4 460004101142 3 Britton-Hecla Junior High   Regular School No 2 07 08 2016   pk_12_total 40.0 1.0 2.0 1.0   1.0             33.0 12.0                       45.0 40 1 2 1   1             33 12                 45
3345592 SD     school 4610320 43001   Canistota 43-1 461032000104 2 Canistota Elementary School   Regular School No 1 PK 05 2016   pk_12_total 97.0 1.0 7.0 1.0             1.0   57.0 50.0                       107.0 97 1 7 1             1   57 50                 107
3345594 SD     school 4610320 43001   Canistota 43-1 461032001016 3 Canistota Middle School   Regular School No 2 06 08 2016   pk_12_total 35.0 1.0 1.0 1.0                 18.0 20.0                       38.0 35 1 1 1                 18 20                 38
3345702 SD     school 4611280 28001   Castlewood 28-1 461128000113 2 Castlewood Elementary   Regular School No 1 PK 06 2016   pk_12_total 138.0 1.0 5.0 1.0             2.0   74.0 73.0                       147.0 138 1 5 1             2   74 73                 147
3345752 SD     school 4611760 60001   Centerville 60-1 461176000115 2 Centerville Elem   Regular School No 1 PK 04 2016   pk_12_total 130.0 1.0 4.0 1.0             1.0   71.0 66.0                       137.0 130 1 4 1             1   71 66                 137
3345753 SD     school 4611760 60001   Centerville 60-1 461176000116 1 Centerville Hi Sch   Regular School No 3 09 12 2016   pk_12_total 45.0   4.0 1.0                 33.0 17.0                       50.0 45   4 1                 33 17                 50
3345894 SD     school 4612300 39001   Chester Area 39-1 461230000832 3 Chester Area Middle School   Regular School No 2 06 08 2016   pk_12_total 73.0 1.0   1.0                 40.0 35.0                       75.0 73 1   1                 40 35                 75
3345987 SD     school 4612940 12002   Clark 12-2 461294000133 1 Clark High School   Regular School No 3 09 12 2016   pk_12_total 78.0 2.0 1.0 1.0                 40.0 42.0                       82.0 78 2 1 1                 40 42                 82
3346027 SD     school 4614100 50005   Colman-Egan 50-5 461410000092 2 Colman-Egan Jr Hi   Regular School No 2 07 08 2016   pk_12_total 34.0 2.0   1.0                 19.0 18.0                       37.0 34 2   1                 19 18                 37
3346313 SD     school 4617850 38002   De Smet 38-2 461785000993 3 De Smet Middle School   Regular School No 2 06 08 2016   pk_12_total 63.0     1.0                 34.0 30.0                       64.0 63     1                 34 30                 64
3346437 SD     school 4678300 5006   Deubrook Area 05-6 467830000012 1 Deubrook High School   Regular School No 3 09 12 2016   pk_12_total 107.0   3.0 1.0             1.0   63.0 49.0                       112.0 107   3 1             1   63 49                 112
3346490 SD     school 4600036 19004   Deuel 19-4 460003601010 1 Deuel High School   Regular School No 3 09 12 2016   pk_12_total 147.0 1.0 1.0 1.0           1.0     82.0 69.0                       151.0 147 1 1 1           1     82 69                 151
3346843 SD     school 4620850 23001   Edgemont 23-1 462085000182 1 Edgemont High School   Regular School No 3 09 12 2016   pk_12_total 36.0   6.0 1.0                 23.0 20.0                       43.0 36   6 1                 23 20                 43
3346953 SD     school 4621340 61007   Elk Point-Jefferson 61-7 462134000186 1 Elk Point Jefferson High School   Regular School No 3 09 12 2016   pk_12_total 193.0 4.0 4.0 1.0   3.0         2.0   99.0 108.0                       207.0 193 4 4 1   3         2   99 108                 207
3347253 SD     school 4622940 46002   Faith 46-2 462294000806 1 Faith High School   Regular School No 3 09 12 2016   pk_12_total 59.0   3.0 1.0             1.0   29.0 35.0                       64.0 59   3 1             1   29 35                 64
3347349 SD     school 4624030 24004   Faulkton Area 462403000203 1 Faulkton Hi Sch   Regular School No 3 09 12 2016   pk_12_total 67.0 2.0   1.0                 38.0 32.0                       70.0 67 2   1                 38 32                 70
3347464 SD     school 4624540 14001   Florence 14-1 462454000208 2 Florence Elementary School   Regular School No 1 PK 06 2016   pk_12_total 155.0     1.0             2.0   88.0 70.0                       158.0 155     1             2   88 70                 158
3347465 SD     school 4624540 14001   Florence 14-1 462454000209 1 Florence High School   Regular School No 3 09 12 2016   pk_12_total 65.0   1.0 1.0             1.0   38.0 30.0                       68.0 65   1 1             1   38 30                 68
3347588 SD     school 4625500 33001   Freeman 33-1 462550000219 2 Freeman Elem   Regular School No 1 KG 06 2016   pk_12_total 122.0 4.0 11.0 1.0   1.0         4.0   68.0 75.0                       143.0 122 4 11 1   1         4   68 75                 143
3347589 SD     school 4625500 33001   Freeman 33-1 462550000220 1 Freeman High School   Regular School No 3 09 12 2016   pk_12_total 71.0   6.0 1.0             1.0   36.0 43.0                       79.0 71   6 1             1   36 43                 79
3347640 SD     school 4626370 49004   Garretson 49-4 462637000223 2 Garretson Elementary   Regular School No 1 PK 05 2016   pk_12_total 195.0   14.0 1.0   2.0         16.0   114.0 114.0                       228.0 195   14 1   2         16   114 114                 228
3347642 SD     school 4626370 49004   Garretson 49-4 462637000843 3 Garretson Middle School   Regular School No 2 06 08 2016   pk_12_total 119.0 1.0 5.0 1.0             6.0   64.0 68.0                       132.0 119 1 5 1             6   64 68                 132
3347738 SD     school 4626970 53001   Gettysburg 53-1 462697000959 3 Gettysburg Junior High   Regular School No 2 07 08 2016   pk_12_total 31.0   1.0 1.0                 21.0 12.0                       33.0 31   1 1                 21 12                 33
3347784 SD     school 4629340 25003   Grant-Deuel 25-3 462934000235 2 Grant-Deuel Elementary   Regular School No 1 PK 06 2016   pk_12_total 42.0     1.0                 24.0 19.0                       43.0 42     1                 24 19                 43
3347880 SD     school 4600045 6006   Groton Area 460004501156 2 Groton Area Elementary School   Regular School No 1 PK 05 2016   pk_12_total 276.0 3.0 2.0 1.0   2.0         3.0   151.0 136.0                       287.0 276 3 2 1   2         3   151 136                 287
3347882 SD     school 4600045 6006   Groton Area 460004501157 4 Groton Area MS   Regular School No 2 06 08 2016   pk_12_total 123.0 2.0 2.0 1.0   1.0             68.0 61.0                       129.0 123 2 2 1   1             68 61                 129
3348010 SD     school 4630800 28003   Hamlin 28-3 463080000259 2 Hamlin Middle School   Regular School No 2 06 08 2016   pk_12_total 166.0 2.0 3.0 1.0             1.0   91.0 82.0                       173.0 166 2 3 1             1   91 82                 173
3348099 SD     school 4602640 30001   Hanson 30-1 460264000876 6 Hanson Elementary School   Regular School No 1 PK 05 2016   pk_12_total 205.0   4.0 1.0   2.0         3.0   113.0 102.0                       215.0 205   4 1   2         3   113 102                 215
3348100 SD     school 4602640 30001   Hanson 30-1 460264000017 1 Hanson High School   Regular School No 3 09 12 2016   pk_12_total 106.0 2.0   1.0   1.0         3.0   53.0 60.0                       113.0 106 2   1   1         3   53 60                 113
3348742 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No 1 KG 06 2016   pk_12_total 175.0 4.0 2.0 1.0             2.0   109.0 75.0                       184.0 175 4 2 1             2   109 75                 184
3348916 SD     school 4636060 22006   Ipswich Public 22-6 463606000333 1 Ipswich Hi Sch   Regular School No 3 09 12 2016   pk_12_total 96.0   3.0 1.0   1.0         1.0   50.0 52.0                       102.0 96   3 1   1         1   50 52                 102
3348970 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901253 4 Irene-Wakonda Junior High   Regular School No 2 07 08 2016   pk_12_total 38.0   1.0 1.0                 19.0 21.0                       40.0 38   1 1                 19 21                 40
3349288 SD     school 4639990 38003   Lake Preston 38-3 463999000367 2 Lake Preston Elementary   Regular School No 1 PK 06 2016   pk_12_total 94.0   1.0 1.0             5.0   53.0 48.0                       101.0 94   1 1             5   53 48                 101
3349540 SD     school 4641550 41004   Lennox 41-4 464155000386 2 Lennox Elementary   Regular School No 1 PK 04 2016   pk_12_total 368.0 2.0 6.0 1.0   1.0         15.0   197.0 196.0                       393.0 368 2 6 1   1         15   197 196                 393
3349544 SD     school 4641550 41004   Lennox 41-4 464155000389 5 Worthing Elem   Regular School No 1 PK 04 2016   pk_12_total 106.0   3.0 1.0             1.0   58.0 53.0                       111.0 106   3 1             1   58 53                 111
3349754 SD     school 4639600 39002   Madison Central 39-2 463960000364 2 Madison Middle School   Regular School No 2 06 08 2016   pk_12_total 249.0 4.0 15.0 1.0   1.0         7.0   145.0 132.0                       277.0 249 4 15 1   1         7   145 132                 277
3349800 SD     school 4645450 60003   Marion 60-3 464545000407 2 Marion Elementary School   Regular School No 1 PK 05 2016   pk_12_total 96.0   11.0 1.0             5.0   61.0 52.0                       113.0 96   11 1             5   61 52                 113
3349802 SD     school 4645450 60003   Marion 60-3 464545001050 3 Marion Middle School   Regular School No 2 06 08 2016   pk_12_total 40.0 1.0 3.0 1.0                 25.0 20.0                       45.0 40 1 3 1                 25 20                 45
3350964 SD     school 4601027 39005   Oldham-Ramona 39-5 460102701030 2 Oldham-Ramona Elementary   Regular School No 1 PK 06 2016   pk_12_total 80.0 2.0 2.0 1.0             3.0   41.0 47.0                       88.0 80 2 2 1             3   41 47                 88
3351945 SD     school 4664140 39004   Rutland 39-4 466414000932 3 Rutland Jr Hi   Regular School No 2 07 08 2016   pk_12_total 16.0     1.0                 10.0 7.0                       17.0 16     1                 10 7                 17
3352007 SD     school 4603932 55005   Sanborn Central 55-5 460393200099 1 Sanborn Central High School   Regular School No 3 09 12 2016   pk_12_total 48.0   1.0 1.0                 31.0 19.0                       50.0 48   1 1                 31 19                 50
3352008 SD     school 4603932 55005   Sanborn Central 55-5 460393200102 2 Sanborn Central Middle School   Regular School No 2 06 08 2016   pk_12_total 28.0     1.0             2.0   11.0 20.0                       31.0 28     1             2   11 20                 31
3352717 SD     school 4666270 49005   Sioux Falls 49-5 466627001129 51 Challenge Center   Regular School No 1 KG 05 2016   pk_12_total 122.0 1.0 4.0 1.0   16.0         6.0   82.0 68.0                       150.0 122 1 4 1   16         6   82 68                 150
3353301 SD     school 4600052 41005   Tea Area 41-5 460005201358 5 Tea Area Frontier Elementary   Regular School No 1 KG 04 2016   pk_12_total 49.0 7.0 5.0 1.0   1.0         5.0   37.0 31.0                       68.0 49 7 5 1   1         5   37 31                 68
3353304 SD     school 4600052 41005   Tea Area 41-5 460005200853 2 Tea Area Middle School   Regular School No 2 06 08 2016   pk_12_total 309.0 5.0 8.0 1.0   2.0       1.0 15.0   197.0 144.0                       341.0 309 5 8 1   2       1 15   197 144                 341
3353560 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School No 1 PK 06 2016   pk_12_total 451.0 24.0 23.0 1.0             10.0   257.0 252.0                       509.0 451 24 23 1             10   257 252                 509
3353562 SD     school 4644940 49006   Tri-Valley 49-6 464494000406 3 Tri-Valley Jr High   Regular School No 2 07 08 2016   pk_12_total 114.0 6.0 1.0 1.0             3.0   72.0 53.0                       125.0 114 6 1 1             3   72 53                 125
3353930 SD     school 4676020 6005   Warner 06-5 467602000710 3 Warner Middle Sch   Regular School No 2 06 08 2016   pk_12_total 62.0 1.0 2.0 1.0                 36.0 30.0                       66.0 62 1 2 1                 36 30                 66
3354201 SD     school 4676990 18005   Webster Area 467699000724 1 Webster Area High School   Regular School No 3 09 12 2016   pk_12_total 129.0   5.0 1.0             1.0   74.0 62.0                       136.0 129   5 1             1   74 62                 136
3354376 SD     school 4678510 1003   White Lake 01-3 467851000745 2 White Lake Elementary   Regular School No 1 PK 06 2016   pk_12_total 64.0 1.0 6.0 1.0           1.0     40.0 33.0                       73.0 64 1 6 1           1     40 33                 73
3354377 SD     school 4678510 1003   White Lake 01-3 467851000746 1 White Lake High School   Regular School No 3 09 12 2016   pk_12_total 32.0 1.0 3.0 1.0                 23.0 14.0                       37.0 32 1 3 1                 23 14                 37
3354549 SD     school 4679350 12003   Willow Lake 12-3 467935000756 1 Willow Lake Hi Sch   Regular School No 3 09 12 2016   pk_12_total 49.0   2.0 1.0                 27.0 25.0                       52.0 49   2 1                 27 25                 52
3354550 SD     school 4679350 12003   Willow Lake 12-3 467935000952 3 Willow Lake Middle School   Regular School No 2 06 08 2016   pk_12_total 32.0   4.0 1.0                 22.0 15.0                       37.0 32   4 1                 22 15                 37
3354698 SD     school 4680100 2006   Wolsey-Wessington 02-6 468010000546 3 Wolsey-Wessington Middle School   Regular School No 2 06 08 2016   pk_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
3354731 SD     school 4680190 55004   Woonsocket 55-4 468019000790 1 Woonsocket High School   Regular School No 3 09 12 2016   pk_12_total 52.0     1.0             1.0   34.0 20.0                       54.0 52     1             1   34 20                 54
3344375 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200655 4 Onida Elementary   Regular School No 1 KG 06 2016   pk_12_total 101.0   1.0 2.0           1.0 4.0   57.0 52.0                       109.0 101   1 2           1 4   57 52                 109
3344376 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200656 7 Sully Buttes High School   Regular School No 3 09 12 2016   pk_12_total 70.0   3.0 2.0             7.0   43.0 39.0                       82.0 70   3 2             7   43 39                 82
3344377 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200939 6 Sully Buttes Junior High   Regular School No 2 07 08 2016   pk_12_total 40.0   1.0 2.0             1.0   26.0 18.0                       44.0 40   1 2             1   26 18                 44
3344424 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No 1 PK 06 2016   pk_12_total 193.0 1.0 7.0 2.0             9.0   104.0 108.0                       212.0 193 1 7 2             9   104 108                 212
3344584 SD     school 4603780 21001   Armour 21-1 460378000023 2 Armour Elementary   Regular School No 1 KG 05 2016   pk_12_total 65.0 3.0 1.0 2.0             2.0   43.0 30.0                       73.0 65 3 1 2             2   43 30                 73
3344647 SD     school 4604270 4001   Avon 04-1 460427000029 1 Avon High School   Regular School No 3 09 12 2016   pk_12_total 73.0   1.0 2.0             1.0   37.0 40.0                       77.0 73   1 2             1   37 40                 77
3345233 SD     school 4607950 49002   Brandon Valley 49-2 460795000071 1 Brandon Valley Hi Sch   Regular School No 3 09 12 2016   pk_12_total 948.0 28.0 17.0 2.0   17.0       6.0 6.0   505.0 519.0                       1024.0 948 28 17 2   17       6 6   505 519                 1024
3345703 SD     school 4611280 28001   Castlewood 28-1 461128000114 1 Castlewood High School   Regular School No 3 09 12 2016   pk_12_total 73.0     2.0                 37.0 38.0                       75.0 73     2                 37 38                 75
3345754 SD     school 4611760 60001   Centerville 60-1 461176001023 3 Centerville Middle School   Regular School No 2 05 08 2016   pk_12_total 62.0 3.0   2.0                 39.0 28.0                       67.0 62 3   2                 39 28                 67
3346200 SD     school 4616950 16001   Custer 16-1 461695000992 5 Custer JH   Regular School No 2 07 08 2016   pk_12_total 98.0 1.0 8.0 2.0             3.0   49.0 63.0                       112.0 98 1 8 2             3   49 63                 112
3346263 SD     school 4636990 61008   Dakota Valley 61-8 463699000345 1 Dakota Valley High School   Regular School No 3 09 12 2016   pk_12_total 319.0 2.0 13.0 2.0   5.0         15.0   188.0 168.0                       356.0 319 2 13 2   5         15   188 168                 356
3346436 SD     school 4678300 5006   Deubrook Area 05-6 467830000559 3 Deubrook Elementary   Regular School No 1 PK 06 2016   pk_12_total 165.0 2.0 8.0 2.0   1.0             94.0 84.0                       178.0 165 2 8 2   1             94 84                 178
3346488 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No 1 PK 05 2016   pk_12_total 256.0 3.0 24.0 2.0           1.0     148.0 138.0                       286.0 256 3 24 2           1     148 138                 286
3346807 SD     school 4620100 20001   Eagle Butte 20-1 462010000898 6 C-EB Junior High   Regular School No 2 07 08 2016   pk_12_total 4.0   1.0 2.0                 4.0 3.0                       7.0 4   1 2                 4 3                 7
3346888 SD     school 4634440 22005   Edmunds Central 22-5 463444001066 5 Edmunds Central Elementary   Regular School No 1 PK 05 2016   pk_12_total 49.0   11.0 2.0                 34.0 28.0                       62.0 49   11 2                 34 28                 62
3347128 SD     school 4622500 17001   Ethan 17-1 462250000193 2 Ethan Elementary   Regular School No 1 PK 06 2016   pk_12_total 141.0   4.0 2.0             2.0   70.0 79.0                       149.0 141   4 2             2   70 79                 149
3347254 SD     school 4622940 46002   Faith 46-2 462294000995 6 Faith Jr. High   Regular School No 2 07 08 2016   pk_12_total 28.0   1.0 2.0                 14.0 17.0                       31.0 28   1 2                 14 17                 31
3347350 SD     school 4624030 24004   Faulkton Area 462403000204 8 Faulkton Jr Hi   Regular School No 2 07 08 2016   pk_12_total 38.0     2.0                 20.0 20.0                       40.0 38     2                 20 20                 40
3347466 SD     school 4624540 14001   Florence 14-1 462454000589 3 Florence Jr High   Regular School No 2 07 08 2016   pk_12_total 27.0     2.0             2.0   18.0 13.0                       31.0 27     2             2   18 13                 31
3347513 SD     school 4621400 6002   Frederick Area 06-2 462140000190 1 Frederick High School   Regular School No 3 09 12 2016   pk_12_total 50.0     2.0                 25.0 27.0                       52.0 50     2                 25 27                 52
3347641 SD     school 4626370 49004   Garretson 49-4 462637000224 1 Garretson High School   Regular School No 3 09 12 2016   pk_12_total 120.0 1.0 7.0 2.0   1.0         4.0   68.0 67.0                       135.0 120 1 7 2   1         4   68 67                 135
3347881 SD     school 4600045 6006   Groton Area 460004501155 1 Groton Area High School   Regular School No 3 09 12 2016   pk_12_total 169.0 5.0 1.0 2.0   2.0             80.0 99.0                       179.0 169 5 1 2   2             80 99                 179
3348183 SD     school 4609300 31001   Harding County 31-1 460930000887 3 Harding County MS   Regular School No 2 06 08 2016   pk_12_total 41.0 2.0   2.0                 21.0 24.0                       45.0 41 2   2                 21 24                 45
3348306 SD     school 4631350 41002   Harrisburg 41-2 463135001334 8 Harrisburg North MS   Regular School No 2 06 08 2016   pk_12_total 454.0 10.0 10.0 2.0   8.0         11.0   242.0 253.0                       495.0 454 10 10 2   8         11   242 253                 495
3348307 SD     school 4631350 41002   Harrisburg 41-2 463135000847 3 Harrisburg South MS   Regular School No 2 06 08 2016   pk_12_total 316.0 3.0 4.0 2.0   1.0         14.0   177.0 163.0                       340.0 316 3 4 2   1         14   177 163                 340
3348309 SD     school 4631350 41002   Harrisburg 41-2 463135000263 2 Liberty Elementary   Regular School No 1 PK 05 2016   pk_12_total 434.0 7.0 6.0 2.0   1.0         18.0   238.0 230.0                       468.0 434 7 6 2   1         18   238 230                 468
3348361 SD     school 4632340 14002   Henry 14-2 463234000276 1 Henry High School   Regular School No 3 09 12 2016   pk_12_total 50.0   1.0 2.0   1.0             27.0 27.0                       54.0 50   1 2   1             27 27                 54
3348581 SD     school 4600046 56006   Hitchcock-Tulare 460004601167 5 Hitchcock-Tulare Elementary   Regular School No 1 KG 06 2016   pk_12_total 99.0     2.0                 58.0 43.0                       101.0 99     2                 58 43                 101
3348680 SD     school 4634600 53002   Hoven 53-2 463460000297 2 Hoven Elementary   Regular School No 1 PK 06 2016   pk_12_total 63.0     2.0                 29.0 36.0                       65.0 63     2                 29 36                 65
3348915 SD     school 4636060 22006   Ipswich Public 22-6 463606000332 2 Ipswich Elem   Regular School No 1 PK 05 2016   pk_12_total 144.0   4.0 2.0   1.0         3.0   79.0 75.0                       154.0 144   4 2   1         3   79 75                 154
3349240 SD     school 4638220 7002   Kimball 07-2 463822000142 4 Kimball Middle School   Regular School No 2 05 08 2016   pk_12_total 63.0   1.0 2.0             3.0   34.0 35.0                       69.0 63   1 2             3   34 35                 69
3349352 SD     school 4640860 45005   Langford Area 464086000851 3 Langford Area MS   Regular School No 2 06 08 2016   pk_12_total 47.0   1.0 2.0             1.0   22.0 29.0                       51.0 47   1 2             1   22 29                 51
3349416 SD     school 4641300 40001   Lead-Deadwood 40-1 464130000374 1 Lead-Deadwood High School   Regular School No 3 09 12 2016   pk_12_total 189.0 1.0 13.0 2.0   3.0         5.0   106.0 107.0                       213.0 189 1 13 2   3         5   106 107                 213
3349541 SD     school 4641550 41004   Lennox 41-4 464155000387 1 Lennox High School   Regular School No 3 09 12 2016   pk_12_total 271.0 2.0 5.0 2.0   3.0         5.0   160.0 128.0                       288.0 271 2 5 2   3         5   160 128                 288
3350250 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No 2 06 08 2016   pk_12_total 203.0   13.0 2.0   1.0         2.0   114.0 107.0                       221.0 203   13 2   1         2   114 107                 221

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