enrollments

Data source: Big Local News · About: Big Local

14,702 rows where state = "WI" and year = 2018 sorted by asian

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 14,602 ✖
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
3088747 3088747 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   12                                             12
3088748 3088748 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   kindergarten                                                   18                                             18
3088749 3088749 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3088751 3088751 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2018   grade_10                                                   19                                             19
3088752 3088752 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2018   grade_11                                                   21                                             21
3088753 3088753 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2018   grade_12                                                   14                                             14
3088754 3088754 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2018   grade_9                                                   16                                             16
3088755 3088755 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   pk_12_total 292.0 2.0 47.0 5.0           1.0 5.0   182.0 170.0             198     56   352 292 2 47 5           1 5   182 170         198   56   352
3088756 3088756 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   grade_1                                                   45                                             45
3088757 3088757 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   49                                             49
3088758 3088758 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   grade_3                                                   41                                             41
3088759 3088759 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   grade_4                                                   37                                             37
3088760 3088760 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   grade_5                                                   49                                             49
3088761 3088761 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   grade_6                                                   53                                             53
3088762 3088762 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   33                                             33
3088763 3088763 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   kindergarten                                                   42                                             42
3088764 3088764 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   3                                             3
3088766 3088766 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2018   grade_10                                                   40                                             40
3088767 3088767 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2018   grade_11                                                   39                                             39
3088768 3088768 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2018   grade_12                                                   47                                             47
3088769 3088769 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2018   grade_9                                                   49                                             49
3088770 3088770 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2018   pk_12_total 63.0   12.0 2.0           1.0 3.0   39.0 42.0             41     15   81 63   12 2           1 3   39 42         41   15   81
3088771 3088771 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2018   grade_7                                                   43                                             43
3088772 3088772 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2018   grade_8                                                   38                                             38
3088773 3088773 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   pk_12_total 143.0 2.0 47.0 1.0                 102.0 91.0             88     38   193 143 2 47 1                 102 91         88   38   193
3088774 3088774 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   35                                             35
3088775 3088775 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   21                                             21
3088776 3088776 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   31                                             31
3088777 3088777 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   24                                             24
3088778 3088778 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   31                                             31
3088779 3088779 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   22                                             22
3088780 3088780 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   28                                             28
3088781 3088781 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3088782 3088782 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   pk_12_total 87.0   25.0 1.0                 66.0 47.0             60     12   113 87   25 1                 66 47         60   12   113
3088783 3088783 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   grade_10                                                   38                                             38
3088784 3088784 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   grade_11                                                   31                                             31
3088785 3088785 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   grade_12                                                   27                                             27
3088786 3088786 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2018   grade_9                                                   17                                             17
3088787 3088787 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2018   pk_12_total 72.0   18.0               1.0   53.0 38.0             39     19   91 72   18               1   53 38         39   19   91
3088788 3088788 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2018   grade_6                                                   23                                             23
3088789 3088789 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2018   grade_7                                                   28                                             28
3088790 3088790 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2018   grade_8                                                   40                                             40
3088792 3088792 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   grade_1                                                   118                                             118
3088793 3088793 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   grade_2                                                   108                                             108
3088794 3088794 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   grade_3                                                   134                                             134
3088795 3088795 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   kindergarten_4_year_old                                                   104                                             104
3088796 3088796 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   kindergarten                                                   126                                             126
3088797 3088797 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   pre_kindergarten                                                   11                                             11
3088799 3088799 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2018   grade_10                                                   108                                             108
3088800 3088800 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2018   grade_11                                                   102                                             102
3088801 3088801 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2018   grade_12                                                   97                                             97
3088802 3088802 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2018   grade_9                                                   106                                             106
3088804 3088804 WI Eau Claire   school 5500270 112 Public school Altoona 550027002925 100 Altoona Intermediate   Regular School No Elementary 04 05 2018   grade_4                                                   129                                             129
3088805 3088805 WI Eau Claire   school 5500270 112 Public school Altoona 550027002925 100 Altoona Intermediate   Regular School No Elementary 04 05 2018   grade_5                                                   118                                             118
3088807 3088807 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2018   grade_6                                                   113                                             113
3088808 3088808 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2018   grade_7                                                   126                                             126
3088809 3088809 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2018   grade_8                                                   122                                             122
3088811 3088811 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2018   grade_10                                                   116                                             116
3088812 3088812 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2018   grade_11                                                   126                                             126
3088813 3088813 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2018   grade_12                                                   105                                             105
3088814 3088814 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2018   grade_9                                                   115                                             115
3088816 3088816 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2018   grade_3                                                   99                                             99
3088817 3088817 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2018   grade_4                                                   84                                             84
3088818 3088818 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2018   grade_5                                                   129                                             129
3088820 3088820 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2018   grade_6                                                   115                                             115
3088821 3088821 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2018   grade_7                                                   119                                             119
3088822 3088822 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2018   grade_8                                                   119                                             119
3088824 3088824 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2018   grade_1                                                   99                                             99
3088825 3088825 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2018   grade_2                                                   100                                             100
3088826 3088826 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2018   kindergarten_4_year_old                                                   88                                             88
3088827 3088827 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2018   kindergarten                                                   106                                             106
3088828 3088828 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2018   pre_kindergarten                                                   6                                             6
3088830 3088830 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2018   grade_10                                                   209                                             209
3088831 3088831 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2018   grade_11                                                   171                                             171
3088832 3088832 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2018   grade_12                                                   210                                             210
3088833 3088833 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2018   grade_9                                                   185                                             185
3088835 3088835 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 06 08 2018   grade_6                                                   147                                             147
3088836 3088836 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 06 08 2018   grade_7                                                   175                                             175
3088837 3088837 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 06 08 2018   grade_8                                                   177                                             177
3088839 3088839 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   15                                             15
3088840 3088840 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   25                                             25
3088841 3088841 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   18                                             18
3088842 3088842 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   20                                             20
3088843 3088843 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   24                                             24
3088844 3088844 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   22                                             22
3088845 3088845 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3088846 3088846 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   pk_12_total 121.0 1.0                 3.0   76.0 49.0             72     32   125 121 1                 3   76 49         72   32   125
3088847 3088847 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   22                                             22
3088848 3088848 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   20                                             20
3088849 3088849 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   21                                             21
3088850 3088850 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   13                                             13
3088851 3088851 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   26                                             26
3088852 3088852 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   16                                             16
3088853 3088853 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   7                                             7
3088854 3088854 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2018   pk_12_total 116.0 1.0 10.0 7.0             12.0   86.0 60.0             117     32   146 116 1 10 7             12   86 60         117   32   146
3088855 3088855 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   20                                             20
3088856 3088856 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   28                                             28
3088857 3088857 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   29                                             29
3088858 3088858 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   28                                             28
3088859 3088859 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   24                                             24

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