Data source: Big Local News · About: Big Local

14,749 rows where state = "WI" and year = 2019 sorted by female

View and edit SQL

year

  • 2019 · 14,649
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
3074004 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2019   kindergarten                                                   39                                             39
3074005 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   2                                             2
3074007 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2019   grade_10                                                   50                                             50
3074008 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2019   grade_11                                                   38                                             38
3074009 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2019   grade_12                                                   37                                             37
3074010 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2019   grade_9                                                   35                                             35
3074012 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2019   grade_7                                                   50                                             50
3074013 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2019   grade_8                                                   42                                             42
3074015 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   32                                             32
3074016 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   31                                             31
3074017 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   20                                             20
3074018 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   29                                             29
3074019 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   26                                             26
3074020 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   28                                             28
3074021 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   18                                             18
3074022 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   3                                             3
3074024 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2019   grade_10                                                   18                                             18
3074025 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2019   grade_11                                                   35                                             35
3074026 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2019   grade_12                                                   31                                             31
3074027 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2019   grade_9                                                   42                                             42
3074029 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2019   grade_6                                                   32                                             32
3074030 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2019   grade_7                                                   23                                             23
3074031 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2019   grade_8                                                   30                                             30
3074033 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2019   grade_1                                                   119                                             119
3074034 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2019   grade_2                                                   119                                             119
3074035 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2019   grade_3                                                   106                                             106
3074036 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2019   kindergarten_4_year_old                                                   70                                             70
3074037 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2019   kindergarten                                                   115                                             115
3074038 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2019   pre_kindergarten                                                   14                                             14
3074040 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2019   grade_10                                                   108                                             108
3074041 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2019   grade_11                                                   104                                             104
3074042 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2019   grade_12                                                   105                                             105
3074043 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2019   grade_9                                                   119                                             119
3074045 WI Eau Claire   school 5500270 112 Public school Altoona 550027002925 100 Altoona Intermediate   Regular School No Elementary 04 05 2019   grade_4                                                   133                                             133
3074046 WI Eau Claire   school 5500270 112 Public school Altoona 550027002925 100 Altoona Intermediate   Regular School No Elementary 04 05 2019   grade_5                                                   127                                             127
3074048 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2019   grade_6                                                   116                                             116
3074049 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2019   grade_7                                                   111                                             111
3074050 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2019   grade_8                                                   133                                             133
3074052 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2019   grade_10                                                   113                                             113
3074053 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2019   grade_11                                                   121                                             121
3074054 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2019   grade_12                                                   128                                             128
3074055 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2019   grade_9                                                   119                                             119
3074057 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2019   grade_3                                                   102                                             102
3074058 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2019   grade_4                                                   101                                             101
3074059 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2019   grade_5                                                   86                                             86
3074061 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2019   grade_6                                                   129                                             129
3074062 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2019   grade_7                                                   115                                             115
3074063 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2019   grade_8                                                   121                                             121
3074065 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2019   grade_1                                                   110                                             110
3074066 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2019   grade_2                                                   100                                             100
3074067 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2019   kindergarten_4_year_old                                                   112                                             112
3074068 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2019   kindergarten                                                   92                                             92
3074069 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2019   pre_kindergarten                                                   5                                             5
3074071 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2019   grade_10                                                   189                                             189
3074072 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2019   grade_11                                                   207                                             207
3074073 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2019   grade_12                                                   179                                             179
3074074 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2019   grade_9                                                   195                                             195
3074076 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 06 08 2019   grade_6                                                   164                                             164
3074077 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 06 08 2019   grade_7                                                   151                                             151
3074078 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 06 08 2019   grade_8                                                   184                                             184
3074080 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   24                                             24
3074081 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   13                                             13
3074082 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   22                                             22
3074083 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   20                                             20
3074084 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   20                                             20
3074085 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   13                                             13
3074086 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   1                                             1
3074088 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   14                                             14
3074089 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   18                                             18
3074090 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   19                                             19
3074091 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   17                                             17
3074092 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   14                                             14
3074093 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   20                                             20
3074094 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   16                                             16
3074096 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   19                                             19
3074097 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   19                                             19
3074098 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   28                                             28
3074099 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   26                                             26
3074100 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   27                                             27
3074101 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   34                                             34
3074103 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   18                                             18
3074104 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   20                                             20
3074105 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2019   grade_3                                                   16                                             16
3074106 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   18                                             18
3074107 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2019   grade_5                                                   18                                             18
3074108 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   132                                             132
3074109 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2019   kindergarten                                                   21                                             21
3074110 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   2                                             2
3074112 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2019   grade_10                                                   6                                             6
3074113 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2019   grade_11                                                   2                                             2
3074114 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2019   grade_12                                                   3                                             3
3074115 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2019   grade_2                                                   1                                             1
3074116 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2019   grade_3                                                   2                                             2
3074117 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2019   grade_4                                                   2                                             2
3074118 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2019   grade_5                                                   2                                             2
3074119 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2019   grade_6                                                   2                                             2
3074120 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2019   grade_7                                                   3                                             3
3074121 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2019   grade_8                                                   1                                             1
3074122 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2019   grade_9                                                   3                                             3
3074123 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2019   kindergarten_4_year_old                                                   1                                             1

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