Data source: Big Local News · About: Big Local

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

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
3073988 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2019   grade_8                                                   17                                             17
3073989 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2019   kindergarten_4_year_old                                                   17                                             17
3073990 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2019   kindergarten                                                   15                                             15
3073991 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2019   pk_12_total 72.0   1.0     2.0         2.0   48.0 29.0             18     16   77 72   1     2         2   48 29         18   16   77
3073992 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2019   grade_10                                                   18                                             18
3073993 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2019   grade_11                                                   18                                             18
3073994 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2019   grade_12                                                   18                                             18
3073995 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2019   grade_9                                                   23                                             23
3073996 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2019   pk_12_total 295.0 5.0 45.0 4.0             6.0   198.0 157.0             208     44   355 295 5 45 4             6   198 157         208   44   355
3073997 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2019   grade_1                                                   42                                             42
3073998 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   44                                             44
3073999 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2019   grade_3                                                   51                                             51
3074000 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2019   grade_4                                                   44                                             44
3074001 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2019   grade_5                                                   41                                             41
3074002 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   51                                             51
3074003 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2019   kindergarten_4_year_old                                                   41                                             41
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
3074006 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2019   pk_12_total 126.0   25.0 5.0   1.0       1.0 2.0   87.0 73.0             85     20   160 126   25 5   1       1 2   87 73         85   20   160
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
3074011 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2019   pk_12_total 69.0   13.0 4.0           2.0 4.0   36.0 56.0             56     18   92 69   13 4           2 4   36 56         56   18   92
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
3074014 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   pk_12_total 134.0 2.0 49.0     1.0         1.0   97.0 90.0             99     38   187 134 2 49     1         1   97 90         99   38   187
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
3074023 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2019   pk_12_total 98.0   28.0                   77.0 49.0             60     16   126 98   28                   77 49         60   16   126
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
3074028 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2019   pk_12_total 60.0   25.0                   49.0 36.0             44     15   85 60   25                   49 36         44   15   85
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
3074032 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2019   pk_12_total 447.0 4.0 38.0     17.0         37.0   298.0 245.0             188     105   543 447 4 38     17         37   298 245         188   105   543
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
3074039 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2019   pk_12_total 372.0 9.0 17.0 4.0   9.0       1.0 24.0   242.0 194.0             136     58   436 372 9 17 4   9       1 24   242 194         136   58   436
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
3074044 WI Eau Claire   school 5500270 112 Public school Altoona 550027002925 100 Altoona Intermediate   Regular School No Elementary 04 05 2019   pk_12_total 222.0 4.0 10.0     7.0         17.0   140.0 120.0             108     37   260 222 4 10     7         17   140 120         108   37   260
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
3074047 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2019   pk_12_total 298.0 1.0 18.0 2.0   10.0       1.0 30.0   180.0 180.0             130     45   360 298 1 18 2   10       1 30   180 180         130   45   360
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
3074051 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2019   pk_12_total 441.0 3.0 18.0 4.0   4.0         11.0   246.0 235.0             145     68   481 441 3 18 4   4         11   246 235         145   68   481
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
3074056 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2019   pk_12_total 261.0 3.0 10.0 3.0   3.0         9.0   161.0 128.0             124     43   289 261 3 10 3   3         9   161 128         124   43   289
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
3074060 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2019   pk_12_total 339.0 4.0 7.0 1.0   2.0         12.0   186.0 179.0             140     52   365 339 4 7 1   2         12   186 179         140   52   365
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
3074064 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2019   pk_12_total 374.0 8.0 19.0     3.0         15.0   204.0 215.0             186     44   419 374 8 19     3         15   204 215         186   44   419
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
3074070 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000037 70 Antigo High   Regular School No High 09 12 2019   pk_12_total 683.0 7.0 36.0 12.0   6.0         26.0   401.0 369.0             374     114   770 683 7 36 12   6         26   401 369         374   114   770
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
3074075 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 06 08 2019   pk_12_total 433.0 3.0 31.0 4.0   3.0         25.0   256.0 243.0             289     78   499 433 3 31 4   3         25   256 243         289   78   499
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
3074079 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2019   pk_12_total 99.0   11.0 1.0   1.0         1.0   59.0 54.0             57     24   113 99   11 1   1         1   59 54         57   24   113
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
3074087 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2019   pk_12_total 108.0 1.0 1.0 3.0             5.0   73.0 45.0             91     31   118 108 1 1 3             5   73 45         91   31   118

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