enrollments

Data source: Big Local News · About: Big Local

10,656 rows where state = "SD" and year = 2016 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 10,656 ✖
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
3350752 3350752 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   grade_1       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350755 3350755 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   grade_10       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350758 3350758 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   grade_11       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350761 3350761 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   grade_12       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350764 3350764 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   grade_2       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350767 3350767 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   grade_3       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350770 3350770 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   grade_4       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350773 3350773 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   grade_5       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350776 3350776 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   grade_6       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350779 3350779 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   grade_7       5.0                 3.0 2.0                       5.0       5                 3 2                 5
3350782 3350782 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   grade_8       6.0                 5.0 1.0                       6.0       6                 5 1                 6
3350785 3350785 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   grade_9       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350788 3350788 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   k_12_total       11.0                 8.0 3.0       5.0               11.0       11                 8 3                 11
3350791 3350791 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350794 3350794 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   pk_12_total       11.0                 8.0 3.0                       11.0       11                 8 3                 11
3350797 3350797 SD     school 4652770 23003   Oelrichs 23-3 465277000608 3 Oelrichs Jr Hi   Regular School No 2 07 08 2016   pre_kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350798 3350798 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   grade_1       22.0                 13.0 9.0                       22.0       22                 13 9                 22
3350799 3350799 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   grade_1       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350800 3350800 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   grade_1       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350801 3350801 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   grade_1     0.0 10.0             0.0   6.0 4.0                       10.0     0 10             0   6 4                 10
3350802 3350802 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   grade_1     2.0 40.0             0.0   21.0 21.0                       42.0     2 40             0   21 21                 42
3350804 3350804 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   grade_10       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350805 3350805 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   grade_10       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350806 3350806 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   grade_10       21.0                 8.0 13.0                       21.0       21                 8 13                 21
3350807 3350807 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   grade_10     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
3350808 3350808 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   grade_10     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
3350810 3350810 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   grade_11       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350811 3350811 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   grade_11       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350812 3350812 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   grade_11       16.0                 8.0 8.0                       16.0       16                 8 8                 16
3350813 3350813 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   grade_11     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
3350814 3350814 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   grade_11     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
3350816 3350816 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   grade_12       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350817 3350817 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   grade_12       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350818 3350818 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   grade_12       3.0                 0.0 3.0                       3.0       3                 0 3                 3
3350819 3350819 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   grade_12     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
3350820 3350820 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   grade_12     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
3350822 3350822 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   grade_2       24.0                 14.0 10.0                       24.0       24                 14 10                 24
3350823 3350823 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   grade_2       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350824 3350824 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   grade_2       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350825 3350825 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   grade_2     1.0 11.0             0.0   4.0 8.0                       12.0     1 11             0   4 8                 12
3350826 3350826 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   grade_2     3.0 32.0             1.0   20.0 16.0                       36.0     3 32             1   20 16                 36
3350828 3350828 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   grade_3       25.0                 11.0 14.0                       25.0       25                 11 14                 25
3350829 3350829 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   grade_3       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350830 3350830 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   grade_3       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350831 3350831 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   grade_3     1.0 4.0             0.0   3.0 2.0                       5.0     1 4             0   3 2                 5
3350832 3350832 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   grade_3     1.0 38.0             2.0   22.0 19.0                       41.0     1 38             2   22 19                 41
3350834 3350834 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   grade_4       19.0                 8.0 11.0                       19.0       19                 8 11                 19
3350835 3350835 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   grade_4       1.0                 1.0 0.0                       1.0       1                 1 0                 1
3350836 3350836 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   grade_4       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350837 3350837 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   grade_4     0.0 3.0             0.0   3.0 0.0                       3.0     0 3             0   3 0                 3
3350838 3350838 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   grade_4     2.0 52.0             1.0   25.0 30.0                       55.0     2 52             1   25 30                 55
3350840 3350840 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   grade_5       25.0                 10.0 15.0                       25.0       25                 10 15                 25
3350841 3350841 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   grade_5       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350842 3350842 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   grade_5       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350843 3350843 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   grade_5     0.0 11.0             0.0   4.0 7.0                       11.0     0 11             0   4 7                 11
3350844 3350844 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   grade_5     1.0 42.0             1.0   17.0 27.0                       44.0     1 42             1   17 27                 44
3350846 3350846 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   grade_6       26.0                 14.0 12.0                       26.0       26                 14 12                 26
3350847 3350847 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   grade_6       3.0                 2.0 1.0                       3.0       3                 2 1                 3
3350848 3350848 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   grade_6       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350849 3350849 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   grade_6     0.0 9.0             0.0   6.0 3.0                       9.0     0 9             0   6 3                 9
3350850 3350850 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   grade_6     0.0 36.0             0.0   20.0 16.0                       36.0     0 36             0   20 16                 36
3350852 3350852 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   grade_7       20.0                 10.0 10.0                       20.0       20                 10 10                 20
3350853 3350853 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   grade_7       7.0                 3.0 4.0                       7.0       7                 3 4                 7
3350854 3350854 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   grade_7       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350855 3350855 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   grade_7     2.0 7.0             0.0   7.0 2.0                       9.0     2 7             0   7 2                 9
3350856 3350856 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   grade_7     1.0 34.0             0.0   16.0 19.0                       35.0     1 34             0   16 19                 35
3350858 3350858 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   grade_8       19.0                 8.0 11.0                       19.0       19                 8 11                 19
3350859 3350859 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   grade_8       4.0                 3.0 1.0                       4.0       4                 3 1                 4
3350860 3350860 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   grade_8       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350861 3350861 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   grade_8     0.0 10.0             0.0   7.0 3.0                       10.0     0 10             0   7 3                 10
3350862 3350862 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   grade_8     0.0 35.0             0.0   21.0 14.0                       35.0     0 35             0   21 14                 35
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
3350865 3350865 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   grade_9       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350866 3350866 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   grade_9       79.0                 35.0 44.0                       79.0       79                 35 44                 79
3350867 3350867 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   grade_9     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
3350868 3350868 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   grade_9     0.0 0.0             0.0   0.0 0.0                       0.0     0 0             0   0 0                 0
3350870 3350870 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   k_12_total       201.0                 93.0 108.0       1.1               201.0       201                 93 108                 201
3350871 3350871 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   k_12_total       15.0                 9.0 6.0       4.2               15.0       15                 9 6                 15
3350872 3350872 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   k_12_total       119.0                 51.0 68.0                       119.0       119                 51 68                 119
3350873 3350873 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   k_12_total     4.0 73.0             0.0   43.0 34.0       4.9               77.0     4 73             0   43 34                 77
3350874 3350874 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   k_12_total     11.0 351.0             6.0   186.0 182.0       1.5               368.0     11 351             6   186 182                 368
3350876 3350876 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   kindergarten       21.0                 5.0 16.0                       21.0       21                 5 16                 21
3350877 3350877 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350878 3350878 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350879 3350879 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   kindergarten     0.0 8.0             0.0   3.0 5.0                       8.0     0 8             0   3 5                 8
3350880 3350880 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   kindergarten     1.0 42.0             1.0   24.0 20.0                       44.0     1 42             1   24 20                 44
3350882 3350882 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   pk_12_total       208.0                 95.0 113.0                       208.0       208                 95 113                 208
3350883 3350883 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   pk_12_total       15.0                 9.0 6.0                       15.0       15                 9 6                 15
3350884 3350884 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   pk_12_total       119.0                 51.0 68.0                       119.0       119                 51 68                 119
3350885 3350885 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   pk_12_total     4.0 82.0             1.0   48.0 39.0                       87.0     4 82             1   48 39                 87
3350886 3350886 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   pk_12_total     14.0 385.0             6.0   209.0 196.0                       405.0     14 385             6   209 196                 405
3350888 3350888 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000573 1 Batesland School - 01   Regular School No 1 PK 08 2016   pre_kindergarten       7.0                 2.0 5.0                       7.0       7                 2 5                 7
3350889 3350889 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001273 9 Oglala Lakota County Alternative   Alternative Education School No 1 KG 08 2016   pre_kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350890 3350890 SD     school 4665460 65001   Oglala Lakota County 65-1 466546001262 8 Oglala Lakota County Virtual High School   Regular School No 3 09 12 2016   pre_kindergarten       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3350891 3350891 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000575 4 Red Shirt School - 04   Regular School No 1 PK 08 2016   pre_kindergarten     0.0 9.0             1.0   5.0 5.0                       10.0     0 9             1   5 5                 10
3350892 3350892 SD     school 4665460 65001   Oglala Lakota County 65-1 466546000576 3 Rockyford School   Regular School No 1 PK 08 2016   pre_kindergarten     3.0 34.0             0.0   23.0 14.0                       37.0     3 34             0   23 14                 37
3352910 3352910 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2016   grade_1   1.0   13.0             1.0   9.0 6.0                       15.0   1   13             1   9 6                 15
3352911 3352911 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No 3 09 12 2016   grade_1       0.0                 0.0 0.0                       0.0       0                 0 0                 0
3352912 3352912 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No 2 06 08 2016   grade_1   0.0   0.0             0.0   0.0 0.0                       0.0   0   0             0   0 0                 0
3352913 3352913 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No 1 PK 05 2016   grade_10   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]);