Data source: Big Local News · About: Big Local

103,197 rows where state = "WI"

View and edit SQL

grade

year

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
111930 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   26                                             26
111931 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   20                                             20
111932 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 144.0 2.0   2.0             6.0   78.0 76.0             107     49   154 144 2   2             6   78 76         107   49   154
111933 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   17                                             17
111934 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   31                                             31
111935 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   18                                             18
111936 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   26                                             26
111937 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   26                                             26
111938 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   17                                             17
111939 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   19                                             19
111940 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000041 160 Mattoon Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 203.0 1.0 23.0 4.0   1.0         7.0   132.0 107.0             125     35   239 203 1 23 4   1         7   132 107         125   35   239
111941 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000041 160 Mattoon Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   13                                             13
111942 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000041 160 Mattoon Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   10                                             10
111943 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000041 160 Mattoon Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   14                                             14
111944 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000041 160 Mattoon Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   25                                             25
111945 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000041 160 Mattoon Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   11                                             11
111946 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000041 160 Mattoon Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   155                                             155
111947 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000041 160 Mattoon Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   9                                             9
111948 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000041 160 Mattoon Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   2                                             2
111949 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 158.0 4.0 14.0 1.0             9.0   102.0 84.0             144     44   186 158 4 14 1             9   102 84         144   44   186
111950 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   34                                             34
111951 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   32                                             32
111952 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   28                                             28
111953 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   31                                             31
111954 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   28                                             28
111955 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   33                                             33
111956 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 100.0                   5.0   49.0 56.0             50     7   105 100                   5   49 56         50   7   105
111957 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   17                                             17
111958 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   19                                             19
111959 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   11                                             11
111960 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   19                                             19
111961 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   22                                             22
111962 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   17                                             17
111963 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2015   pk_12_total 2.0   1.0                   2.0 1.0             *     *   3 2   1                   2 1                 3
111964 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2015   grade_2                                                   1                                             1
111965 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2015   grade_5                                                   1                                             1
111966 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2015   grade_9                                                   1                                             1
111967 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 99.0   7.0 1.0             2.0   61.0 48.0             70     13   109 99   7 1             2   61 48         70   13   109
111968 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   18                                             18
111969 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   14                                             14
111970 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   20                                             20
111971 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   21                                             21
111972 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   19                                             19
111973 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   16                                             16
111974 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
111975 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 164.0 7.0 21.0     2.0         10.0   111.0 93.0             140     50   204 164 7 21     2         10   111 93         140   50   204
111976 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   30                                             30
111977 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   36                                             36
111978 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   36                                             36
111979 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   29                                             29
111980 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   40                                             40
111981 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   33                                             33
111982 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes 1.0 KG 04 2015   pk_12_total 40.0 1.0 73.0     2.0         3.0   54.0 65.0             53     8   119 40 1 73     2         3   54 65         53   8   119
111983 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes 1.0 KG 04 2015   grade_1                                                   28                                             28
111984 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes 1.0 KG 04 2015   grade_2                                                   17                                             17
111985 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes 1.0 KG 04 2015   grade_3                                                   26                                             26
111986 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes 1.0 KG 04 2015   grade_4                                                   21                                             21
111987 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes 1.0 KG 04 2015   kindergarten                                                   27                                             27
111988 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Appleton Career Academy charter Regular School Yes 3.0 09 12 2015   pk_12_total 92.0 1.0 4.0     5.0         2.0   42.0 62.0             29     10   104 92 1 4     5         2   42 62         29   10   104
111989 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Appleton Career Academy charter Regular School Yes 3.0 09 12 2015   grade_10                                                   24                                             24
111990 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Appleton Career Academy charter Regular School Yes 3.0 09 12 2015   grade_11                                                   25                                             25
111991 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Appleton Career Academy charter Regular School Yes 3.0 09 12 2015   grade_12                                                   31                                             31
111992 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Appleton Career Academy charter Regular School Yes 3.0 09 12 2015   grade_9                                                   24                                             24
111993 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000692 400 Appleton Central High charter Regular School Yes 4.0 06 12 2015   pk_12_total 67.0 13.0 20.0 2.0   1.0             60.0 43.0             74     1   103 67 13 20 2   1             60 43         74   1   103
111994 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000692 400 Appleton Central High charter Regular School Yes 4.0 06 12 2015   grade_10                                                   2                                             2
111995 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000692 400 Appleton Central High charter Regular School Yes 4.0 06 12 2015   grade_11                                                   25                                             25
111996 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000692 400 Appleton Central High charter Regular School Yes 4.0 06 12 2015   grade_12                                                   75                                             75
111997 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000692 400 Appleton Central High charter Regular School Yes 4.0 06 12 2015   grade_8                                                   1                                             1
111998 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No 1.0 PK PK 2015   pk_12_total 647.0 26.0 77.0 2.0   109.0         35.0   471.0 425.0             217     102   896 647 26 77 2   109         35   471 425         217   102   896
111999 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   896                                             896
112000 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes 3.0 07 12 2015   pk_12_total 24.0 1.0 2.0                   5.0 22.0             6         27 24 1 2                   5 22         6       27
112001 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes 3.0 07 12 2015   grade_10                                                   7                                             7
112002 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes 3.0 07 12 2015   grade_11                                                   8                                             8
112003 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes 3.0 07 12 2015   grade_12                                                   9                                             9
112004 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes 3.0 07 12 2015   grade_7                                                   1                                             1
112005 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes 3.0 07 12 2015   grade_9                                                   2                                             2
112006 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   pk_12_total 153.0 1.0 2.0     1.0             76.0 81.0             25     4   157 153 1 2     1             76 81         25   4   157
112007 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   grade_1                                                   20                                             20
112008 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   grade_2                                                   20                                             20
112009 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   grade_3                                                   20                                             20
112010 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   grade_4                                                   19                                             19
112011 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   grade_5                                                   22                                             22
112012 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   grade_6                                                   16                                             16
112013 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   kindergarten_4_year_old                                                   20                                             20
112014 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   kindergarten                                                   20                                             20
112015 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   pk_12_total 39.0   17.0                   53.0 3.0             27     16   56 39   17                   53 3         27   16   56
112016 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   grade_10                                                   14                                             14
112017 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   grade_11                                                   17                                             17
112018 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   grade_12                                                   17                                             17
112019 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Vocational Education School Yes 3.0 09 12 2015   grade_9                                                   8                                             8
112020 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 191.0 42.0 69.0 4.0   23.0         3.0   160.0 172.0             165     44   332 191 42 69 4   23         3   160 172         165   44   332
112021 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No 1.0 PK 06 2015   grade_1                                                   59                                             59
112022 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   55                                             55
112023 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No 1.0 PK 06 2015   grade_3                                                   36                                             36
112024 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No 1.0 PK 06 2015   grade_4                                                   40                                             40
112025 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No 1.0 PK 06 2015   grade_5                                                   54                                             54
112026 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   35                                             35
112027 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No 1.0 PK 06 2015   kindergarten                                                   52                                             52
112028 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   1                                             1
112029 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 394.0 1.0 25.0 2.0   28.0         1.0   238.0 213.0             66     66   451 394 1 25 2   28         1   238 213         66   66   451

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