enrollments

Data source: Big Local News · About: Big Local

4,696 rows where grade = "grade_9" and state = "SD" sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 4,596 ✖
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
487767 487767 SD     school 4603780 21001   Armour 21-1 460378000024 1 Armour High School   Regular School Not applicable High 09 12 2020   grade_9 10.0   1.0 1.0                 7.0 5.0                       12.0 10   1 1                 7 5                 12
2962024 2962024 SD     school 4603780 21001   Armour 21-1 460378000024 1 Armour High School   Regular School No 3 09 12 2015   grade_9 14.0 0.0   1.0                 10.0 5.0                       15.0 14 0   1                 10 5                 15
3006664 3006664 SD     school 4603780 21001   Armour 21-1 460378000024 1 Armour High School   Regular School No High 09 12 2017   grade_9 10.0 0.0 2.0 0.0                 3.0 9.0                       12.0 10 0 2 0                 3 9                 12
3344576 3344576 SD     school 4603780 21001   Armour 21-1 460378000024 1 Armour High School   Regular School No 3 09 12 2016   grade_9 13.0 0.0 0.0 1.0                 7.0 7.0                       14.0 13 0 0 1                 7 7                 14
250256 250256 SD     school 4603780 21001   Armour 21-1 460378000878 3 Armour Middle School   Regular School No Middle 06 08 2018   grade_9 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
357499 357499 SD     school 4603780 21001   Armour 21-1 460378000878 3 Armour Middle School   Regular School No Middle 06 08 2019   grade_9 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
449345 449345 SD     school 4603780 21001   Armour 21-1 460378000878 3 Armour Middle School   Regular School Not applicable Middle 06 08 2021   grade_9 0.0 0.0 0.0                   0.0 0.0                       0.0 0 0 0                   0 0                 0
487768 487768 SD     school 4603780 21001   Armour 21-1 460378000878 3 Armour Middle School   Regular School Not applicable Middle 06 08 2020   grade_9 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
2962025 2962025 SD     school 4603780 21001   Armour 21-1 460378000878 3 Armour Middle School   Regular School No 2 05 08 2015   grade_9 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
3006665 3006665 SD     school 4603780 21001   Armour 21-1 460378000878 3 Armour Middle School   Regular School No Middle 06 08 2017   grade_9 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
3344577 3344577 SD     school 4603780 21001   Armour 21-1 460378000878 3 Armour Middle School   Regular School No 2 06 08 2016   grade_9 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
255782 255782 SD     school 4669930 46001   Meade 46-1 466993001236 17 Atall Elem   Regular School No Elementary KG 08 2018   grade_9 0.0                       0.0 0.0                       0.0 0                       0 0                 0
363020 363020 SD     school 4669930 46001   Meade 46-1 466993001236 17 Atall Elem   Regular School No Elementary KG 08 2019   grade_9 0.0                       0.0 0.0                       0.0 0                       0 0                 0
454866 454866 SD     school 4669930 46001   Meade 46-1 466993001236 17 Atall Elem   Regular School Not applicable Elementary KG 08 2021   grade_9 0.0                   0.0   0.0 0.0                       0.0 0                   0   0 0                 0
493289 493289 SD     school 4669930 46001   Meade 46-1 466993001236 17 Atall Elem   Regular School Not applicable Elementary KG 08 2020   grade_9 0.0                   0.0   0.0 0.0                       0.0 0                   0   0 0                 0
2967476 2967476 SD     school 4669930 46001   Meade 46-1 466993001236 17 Atall Elem   Regular School No 1 KG 08 2015   grade_9 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3012212 3012212 SD     school 4669930 46001   Meade 46-1 466993001236 17 Atall Elem   Regular School No Elementary KG 08 2017   grade_9 0.0                       0.0 0.0                       0.0 0                       0 0                 0
3350076 3350076 SD     school 4669930 46001   Meade 46-1 466993001236 17 Atall Elem   Regular School No 1 KG 08 2016   grade_9 0.0                       0.0 0.0                       0.0 0                       0 0                 0
256948 256948 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative School No High 09 12 2018   grade_9 8.0 1.0 2.0 2.0             1.0   10.0 4.0                       14.0 8 1 2 2             1   10 4                 14
364223 364223 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative School No High 09 12 2019   grade_9 9.0 1.0 1.0 6.0             0.0   12.0 5.0                       17.0 9 1 1 6             0   12 5                 17
456101 456101 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative School Not applicable High 09 12 2021   grade_9 1.0 0.0   1.0                 1.0 1.0                       2.0 1 0   1                 1 1                 2
494508 494508 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative School Not applicable High 09 12 2020   grade_9 2.0 1.0   5.0             1.0   6.0 3.0                       9.0 2 1   5             1   6 3                 9
2968557 2968557 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative Education School No 3 09 12 2015   grade_9 9.0     7.0           0.0     10.0 6.0                       16.0 9     7           0     10 6                 16
3013389 3013389 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative School No High 09 12 2017   grade_9 7.0 1.0 0.0 11.0             0.0   9.0 10.0                       19.0 7 1 0 11             0   9 10                 19
3351253 3351253 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative Education School No 3 09 12 2016   grade_9 7.0     8.0             2.0   13.0 4.0                       17.0 7     8             2   13 4                 17
256949 256949 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School No Middle 04 08 2018   grade_9 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
364224 364224 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School No Middle 04 08 2019   grade_9 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
456102 456102 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School Not applicable Middle 04 08 2021   grade_9 0.0 0.0   0.0             0.0   0.0 0.0                       0.0 0 0   0             0   0 0                 0
494509 494509 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School Not applicable Middle 04 08 2020   grade_9 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
2968558 2968558 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative Education School No 2 05 08 2015   grade_9 0.0 0.0   0.0             0.0   0.0 0.0                       0.0 0 0   0             0   0 0                 0
3013390 3013390 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School No Elementary 04 08 2017   grade_9 0.0 0.0 0.0 0.0                 0.0 0.0                       0.0 0 0 0 0                 0 0                 0
3351254 3351254 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative Education School No 2 05 08 2016   grade_9 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
259385 259385 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2018   grade_9 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
366612 366612 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2019   grade_9 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
458490 458490 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School Not applicable Elementary PK 01 2021   grade_9 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
496913 496913 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School Not applicable Elementary PK 01 2020   grade_9 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
2971170 2971170 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No 1 PK 01 2015   grade_9 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
3015778 3015778 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2017   grade_9 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
3353690 3353690 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No 1 PK 01 2016   grade_9 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
250313 250313 SD     school 4604270 4001   Avon 04-1 460427000028 2 Avon Elementary School   Regular School No Elementary KG 06 2018   grade_9 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
357556 357556 SD     school 4604270 4001   Avon 04-1 460427000028 2 Avon Elementary School   Regular School No Elementary KG 06 2019   grade_9 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
449402 449402 SD     school 4604270 4001   Avon 04-1 460427000028 2 Avon Elementary School   Regular School Not applicable Elementary KG 06 2021   grade_9 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
487825 487825 SD     school 4604270 4001   Avon 04-1 460427000028 2 Avon Elementary School   Regular School Not applicable Elementary KG 06 2020   grade_9 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
2962082 2962082 SD     school 4604270 4001   Avon 04-1 460427000028 2 Avon Elementary School   Regular School No 1 KG 06 2015   grade_9 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
3006722 3006722 SD     school 4604270 4001   Avon 04-1 460427000028 2 Avon Elementary School   Regular School No Elementary KG 06 2017   grade_9 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
3344634 3344634 SD     school 4604270 4001   Avon 04-1 460427000028 2 Avon Elementary School   Regular School No 1 KG 06 2016   grade_9 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
250314 250314 SD     school 4604270 4001   Avon 04-1 460427000029 1 Avon High School   Regular School No High 09 12 2018   grade_9 12.0   1.0               0.0   4.0 9.0                       13.0 12   1               0   4 9                 13
357557 357557 SD     school 4604270 4001   Avon 04-1 460427000029 1 Avon High School   Regular School No High 09 12 2019   grade_9 19.0   0.0               2.0   10.0 11.0                       21.0 19   0               2   10 11                 21
449403 449403 SD     school 4604270 4001   Avon 04-1 460427000029 1 Avon High School   Regular School Not applicable High 09 12 2021   grade_9 19.0   0.0               0.0   11.0 8.0                       19.0 19   0               0   11 8                 19
487826 487826 SD     school 4604270 4001   Avon 04-1 460427000029 1 Avon High School   Regular School Not applicable High 09 12 2020   grade_9 19.0   1.0               0.0   11.0 9.0                       20.0 19   1               0   11 9                 20
2962083 2962083 SD     school 4604270 4001   Avon 04-1 460427000029 1 Avon High School   Regular School No 3 09 12 2015   grade_9 19.0 0.0 1.0 0.0             1.0   11.0 10.0                       21.0 19 0 1 0             1   11 10                 21
3006723 3006723 SD     school 4604270 4001   Avon 04-1 460427000029 1 Avon High School   Regular School No High 09 12 2017   grade_9 17.0   2.0 1.0             0.0   11.0 9.0                       20.0 17   2 1             0   11 9                 20
3344635 3344635 SD     school 4604270 4001   Avon 04-1 460427000029 1 Avon High School   Regular School No 3 09 12 2016   grade_9 15.0   0.0 1.0             0.0   9.0 7.0                       16.0 15   0 1             0   9 7                 16
250315 250315 SD     school 4604270 4001   Avon 04-1 460427000829 5 Avon Jr High School   Regular School No Middle 07 08 2018   grade_9 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
357558 357558 SD     school 4604270 4001   Avon 04-1 460427000829 5 Avon Jr High School   Regular School No Middle 07 08 2019   grade_9 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
449404 449404 SD     school 4604270 4001   Avon 04-1 460427000829 5 Avon Jr High School   Regular School Not applicable Middle 07 08 2021   grade_9 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
487827 487827 SD     school 4604270 4001   Avon 04-1 460427000829 5 Avon Jr High School   Regular School Not applicable Middle 07 08 2020   grade_9 0.0   0.0               0.0   0.0 0.0                       0.0 0   0               0   0 0                 0
2962084 2962084 SD     school 4604270 4001   Avon 04-1 460427000829 5 Avon Jr High School   Regular School No 2 07 08 2015   grade_9 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
3006724 3006724 SD     school 4604270 4001   Avon 04-1 460427000829 5 Avon Jr High School   Regular School No Middle 07 08 2017   grade_9 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
3344636 3344636 SD     school 4604270 4001   Avon 04-1 460427000829 5 Avon Jr High School   Regular School No 2 07 08 2016   grade_9 0.0   0.0 0.0                 0.0 0.0                       0.0 0   0 0                 0 0                 0
250316 250316 SD     school 4604270 4001   Avon 04-1 460427001325 6 Avon PK   Regular School No Prekindergarten PK PK 2018   grade_9 0.0                   0.0   0.0 0.0                       0.0 0                   0   0 0                 0
357559 357559 SD     school 4604270 4001   Avon 04-1 460427001325 6 Avon PK   Regular School No Prekindergarten PK PK 2019   grade_9 0.0                       0.0 0.0                       0.0 0                       0 0                 0
449405 449405 SD     school 4604270 4001   Avon 04-1 460427001325 6 Avon PK   Regular School Not applicable Prekindergarten PK PK 2021   grade_9 0.0     0.0                 0.0 0.0                       0.0 0     0                 0 0                 0
487828 487828 SD     school 4604270 4001   Avon 04-1 460427001325 6 Avon PK   Regular School Not applicable Prekindergarten PK PK 2020   grade_9 0.0   0.0               0.0   0.0 0.0                       0.0 0   0               0   0 0                 0
2962085 2962085 SD     school 4604270 4001   Avon 04-1 460427001325 6 Avon PK   Regular School No 1 PK PK 2015   grade_9 0.0                   0.0   0.0 0.0                       0.0 0                   0   0 0                 0
3006725 3006725 SD     school 4604270 4001   Avon 04-1 460427001325 6 Avon PK   Regular School No Elementary PK PK 2017   grade_9 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
3344637 3344637 SD     school 4604270 4001   Avon 04-1 460427001325 6 Avon PK   Regular School No 1 PK PK 2016   grade_9 0.0   0.0                   0.0 0.0                       0.0 0   0                   0 0                 0
2964056 2964056 SD     school 4619410 51001   Douglas 51-1 461941000453 5 Badger Clark Elem   Regular School No 1 KG 01 2015   grade_9 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
3008760 3008760 SD     school 4619410 51001   Douglas 51-1 461941000453 5 Badger Clark Elem   Regular School No Elementary KG 01 2017   grade_9 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
3346672 3346672 SD     school 4619410 51001   Douglas 51-1 461941000453 5 Badger Clark Elem   Regular School No 1 KG 01 2016   grade_9 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
250366 250366 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School No Elementary PK 05 2018   grade_9 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
357609 357609 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
449455 449455 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School Not applicable Elementary PK 05 2021   grade_9 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
487878 487878 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School Not applicable Elementary PK 05 2020   grade_9 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
2962135 2962135 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School No 1 PK 05 2015   grade_9 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
3006775 3006775 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School No Elementary PK 05 2017   grade_9 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
3344687 3344687 SD     school 4604680 49001   Baltic 49-1 460468000035 2 Baltic Elem   Regular School No 1 PK 05 2016   grade_9 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
250367 250367 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School No High 09 12 2018   grade_9 35.0 2.0 1.0 0.0   1.0         0.0   20.0 19.0                       39.0 35 2 1 0   1         0   20 19                 39
357610 357610 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School No High 09 12 2019   grade_9 40.0   1.0 1.0   0.0         0.0   19.0 23.0                       42.0 40   1 1   0         0   19 23                 42
449456 449456 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School Not applicable High 09 12 2021   grade_9 48.0   0.0 1.0   0.0         2.0   29.0 22.0                       51.0 48   0 1   0         2   29 22                 51
487879 487879 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School Not applicable High 09 12 2020   grade_9 36.0 0.0 4.0 0.0   0.0         0.0   23.0 17.0                       40.0 36 0 4 0   0         0   23 17                 40
2962136 2962136 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School No 3 09 12 2015   grade_9 43.0 1.0 3.0 0.0   0.0             25.0 22.0                       47.0 43 1 3 0   0             25 22                 47
3006776 3006776 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School No High 09 12 2017   grade_9 29.0   1.0     0.0         0.0   15.0 15.0                       30.0 29   1     0         0   15 15                 30
3344688 3344688 SD     school 4604680 49001   Baltic 49-1 460468000036 1 Baltic High School   Regular School No 3 09 12 2016   grade_9 29.0 0.0 0.0 0.0   0.0             19.0 10.0                       29.0 29 0 0 0   0             19 10                 29
250368 250368 SD     school 4604680 49001   Baltic 49-1 460468000986 3 Baltic Middle School   Regular School No Middle 06 08 2018   grade_9 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
357611 357611 SD     school 4604680 49001   Baltic 49-1 460468000986 3 Baltic Middle School   Regular School No Middle 06 08 2019   grade_9 0.0   0.0               0.0   0.0 0.0                       0.0 0   0               0   0 0                 0
449457 449457 SD     school 4604680 49001   Baltic 49-1 460468000986 3 Baltic Middle School   Regular School Not applicable Middle 06 08 2021   grade_9 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
487880 487880 SD     school 4604680 49001   Baltic 49-1 460468000986 3 Baltic Middle School   Regular School Not applicable Middle 06 08 2020   grade_9 0.0   0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0   0 0   0         0   0 0                 0
2962137 2962137 SD     school 4604680 49001   Baltic 49-1 460468000986 3 Baltic Middle School   Regular School No 2 06 08 2015   grade_9 0.0 0.0 0.0     0.0             0.0 0.0                       0.0 0 0 0     0             0 0                 0
3006777 3006777 SD     school 4604680 49001   Baltic 49-1 460468000986 3 Baltic Middle School   Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0     0.0             0.0 0.0                       0.0 0 0 0     0             0 0                 0
3344689 3344689 SD     school 4604680 49001   Baltic 49-1 460468000986 3 Baltic Middle School   Regular School No 2 06 08 2016   grade_9 0.0 0.0 0.0     0.0             0.0 0.0                       0.0 0 0 0     0             0 0                 0
256564 256564 SD     school 4665460 65001   Oglala Lakota 65-1 466546000573 1 Batesland School   Regular School No Elementary PK 08 2018   grade_9     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
363823 363823 SD     school 4665460 65001   Oglala Lakota 65-1 466546000573 1 Batesland School   Regular School No Elementary PK 08 2019   grade_9       0.0             0.0   0.0 0.0                       0.0       0             0   0 0                 0
455696 455696 SD     school 4665460 65001   Oglala Lakota 65-1 466546000573 1 Batesland School   Regular School Not applicable Elementary PK 08 2021   grade_9 0.0   0.0 0.0             0.0   0.0 0.0                       0.0 0   0 0             0   0 0                 0
494108 494108 SD     school 4665460 65001   Oglala Lakota 65-1 466546000573 1 Batesland School   Regular School Not applicable Elementary PK 08 2020   grade_9       0.0             0.0   0.0 0.0                       0.0       0             0   0 0                 0
2969480 2969480 SD     school 4665460 65001   Shannon County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2015   grade_9       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3013000 3013000 SD     school 4665460 65001   Oglala Lakota 65-1 466546000573 1 Batesland School - 01   Regular School No Elementary PK 08 2017   grade_9 0.0     0.0             0.0   0.0 0.0                       0.0 0     0             0   0 0                 0
3350864 3350864 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   grade_9       0.0                 0.0 0.0                       0.0       0                 0 0                 0
260511 260511 SD     school 4680430 63003   Yankton 63-3 468043000791 3 Beadle Elem   Regular School No Elementary KG 05 2018   grade_9 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
367770 367770 SD     school 4680430 63003   Yankton 63-3 468043000791 3 Beadle Elem   Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0

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