Data source: Big Local News · About: Big Local

2,040 rows where grade = "pk_12_total" and state = "HI" sorted by total

View and edit SQL

year

grade

  • pk_12_total · 1,940
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
2432790 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 Maui Waena Int   Regular School No Middle 06 8 2020   pk_12_total                                               97.0   1162.0                                         97   1162
2457331 HI     school 1500030 1   Hawaii Department of Education 150003000150 224 Radford High   Regular School No High 09 12 2021   pk_12_total                                               128.0   1166.0                                         128   1166
2432815 HI     school 1500030 1   Hawaii Department of Education 150003000086 456 Kauai High   Regular School No High 09 12 2020   pk_12_total                                               114.0   1168.0                                         114   1168
2783413 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2018   pk_12_total                                               201.0   1173.0                                         201   1173
2432577 HI     school 1500030 1   Hawaii Department of Education 150003000228 154 Kaiser High   Regular School No High 09 12 2020   pk_12_total                                               104.0   1175.0                                         104   1175
2783496 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 Maui Waena Int   Regular School No Middle 06 8 2018   pk_12_total                                               106.0   1176.0                                         106   1176
2738394 HI     school 1500030 1   Hawaii Department of Education 150003000029 355 Hilo High   Regular School No High 09 12 2019   pk_12_total                                               200.0   1178.0                                         200   1178
111579 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 CASTLE HI   Regular School No 3 09 12 2016   pk_12_total                                               187.0   1179.0                                         187   1179
2457272 HI     school 1500030 1   Hawaii Department of Education 150003000228 154 Kaiser High   Regular School No High 09 12 2021   pk_12_total                                               95.0   1180.0                                         95   1180
130582 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 CASTLE HI   Regular School No High 09 12 2017   pk_12_total                                               199.0   1181.0                                         199   1181
2783374 HI     school 1500030 1   Hawaii Department of Education 150003000248 280 Holomua Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               86.0   1181.0                                         86   1181
130665 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No Middle 06 8 2017   pk_12_total                                               111.0   1183.0                                         111   1183
130628 HI     school 1500030 1   Hawaii Department of Education 150003000035 363 HOOKENA   Regular School No Elementary PK 5 2017   pk_12_total                                               12.0   119.0                                         12   119
2432730 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2020   pk_12_total                                               11.0   119.0                                         11   119
111618 HI     school 1500030 1   Hawaii Department of Education 150003000052 389 WAIAKEA HI   Regular School No 3 09 12 2016   pk_12_total                                               160.0   1197.0                                         160   1197
2738501 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Acad PCS charter Regular School Yes Other KG 12 2019   pk_12_total                                               93.0   1197.0                                         93   1197
2432636 HI     school 1500030 1   Hawaii Department of Education 150003000150 224 Radford High   Regular School No High 09 12 2020   pk_12_total                                               116.0   1199.0                                         116   1199
2738497 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2019   pk_12_total                                               3.0   120.0                                         3   120
130543 HI     school 1500030 1   Hawaii Department of Education 150003000248 280 HOLOMUA   Regular School No Elementary PK 6 2017   pk_12_total                                               81.0   1200.0                                         81   1200
2457449 HI     school 1500030 1   Hawaii Department of Education 150003000035 363 Hookena Elem   Regular School No Elementary PK 5 2021   pk_12_total                                               12.0   121.0                                         12   121
281552 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 CASTLE HI   Regular School No 3 09 12 2015   pk_12_total                                               194.0   1211.0                                         194   1211
281591 HI     school 1500030 1   Hawaii Department of Education 150003000052 389 WAIAKEA HI   Regular School No 3 09 12 2015   pk_12_total                                               168.0   1219.0                                         168   1219
2432738 HI     school 1500030 1   Hawaii Department of Education 150003000029 355 Hilo High   Regular School No High 09 12 2020   pk_12_total                                               185.0   1219.0                                         185   1219
111625 HI     school 1500030 1   Hawaii Department of Education 150003000035 363 HOOKENA   Regular School No 1 PK 5 2016   pk_12_total                                               11.0   122.0                                         11   122
2432710 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2020   pk_12_total                                               17.0   122.0                                         17   122
281583 HI     school 1500030 1   Hawaii Department of Education 150003000029 355 HILO HI   Regular School No 3 09 12 2015   pk_12_total                                               222.0   1224.0                                         222   1224
130605 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No Elementary PK 6 2017   pk_12_total                                               13.0   123.0                                         13   123
2738507 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   pk_12_total                                               4.0   123.0                                         4   123
2457442 HI     school 1500030 1   Hawaii Department of Education 150003000052 389 Waiakea High   Regular School No High 09 12 2021   pk_12_total                                               101.0   1233.0                                         101   1233
111629 HI     school 1500030 1   Hawaii Department of Education 150003000254 392 KEALAKEHE HI   Regular School No 3 09 12 2016   pk_12_total                                               140.0   1237.0                                         140   1237
2432844 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2020   pk_12_total                                               2.0   124.0                                         2   124
2783436 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               12.0   124.0                                         12   124
2738402 HI     school 1500030 1   Hawaii Department of Education 150003000052 389 Waiakea High   Regular School No High 09 12 2019   pk_12_total                                               118.0   1241.0                                         118   1241
111540 HI     school 1500030 1   Hawaii Department of Education 150003000248 280 HOLOMUA   Regular School No 1 PK 6 2016   pk_12_total                                               85.0   1243.0                                         85   1243
2738292 HI     school 1500030 1   Hawaii Department of Education 150003000150 224 Radford High   Regular School No High 09 12 2019   pk_12_total                                               124.0   1244.0                                         124   1244
130585 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No Elementary PK 6 2017   pk_12_total                                               21.0   125.0                                         21   125
2783416 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               20.0   125.0                                         20   125
130621 HI     school 1500030 1   Hawaii Department of Education 150003000052 389 WAIAKEA HI   Regular School No High 09 12 2017   pk_12_total                                               140.0   1253.0                                         140   1253
2457385 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 Ahrens Elem   Regular School No Elementary PK 6 2021   pk_12_total                                               83.0   1256.0                                         83   1256
2783452 HI     school 1500030 1   Hawaii Department of Education 150003000052 389 Waiakea High   Regular School No High 09 12 2018   pk_12_total                                               122.0   1256.0                                         122   1256
2783395 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               75.0   1258.0                                         75   1258
281555 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2015   pk_12_total                                               13.0   126.0                                         13   126
281702 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes 2 06 8 2015   pk_12_total                                               19.0   126.0                                         19   126
2738500 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   pk_12_total                                               8.0   126.0                                         8   126
2738345 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               67.0   1260.0                                         67   1260
2457362 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 06 8 2021   pk_12_total                                               86.0   1262.0                                         86   1262
130564 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   pk_12_total                                               80.0   1269.0                                         80   1269
281687 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 KE KULA O KAMAKAU LAB-PCS charter Regular School Yes 4 PK 12 2015   pk_12_total                                               1.0   127.0                                         1   127
2457434 HI     school 1500030 1   Hawaii Department of Education 150003000029 355 Hilo High   Regular School No High 09 12 2021   pk_12_total                                               194.0   1272.0                                         194   1272
2738361 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2019   pk_12_total                                               105.0   1275.0                                         105   1275
2783342 HI     school 1500030 1   Hawaii Department of Education 150003000150 224 Radford High   Regular School No High 09 12 2018   pk_12_total                                               124.0   1275.0                                         124   1275
281425 HI     school 1500030 1   Hawaii Department of Education 150003000163 119 KALANI HI   Regular School No 3 09 12 2015   pk_12_total                                               134.0   1277.0                                         134   1277
281514 HI     school 1500030 1   Hawaii Department of Education 150003000248 280 HOLOMUA   Regular School No 1 PK 6 2015   pk_12_total                                               77.0   1279.0                                         77   1279
111582 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 KAAAWA   Regular School No 1 PK 6 2016   pk_12_total                                               13.0   128.0                                         13   128
130632 HI     school 1500030 1   Hawaii Department of Education 150003000254 392 KEALAKEHE HI   Regular School No High 09 12 2017   pk_12_total                                               149.0   1281.0                                         149   1281
281550 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 WAIPAHU INT   Regular School No 2 07 8 2015   pk_12_total                                               119.0   1281.0                                         119   1281
2432746 HI     school 1500030 1   Hawaii Department of Education 150003000052 389 Waiakea High   Regular School No High 09 12 2020   pk_12_total                                               110.0   1282.0                                         110   1282
2432830 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Acad PCS charter Regular School Yes Other KG 12 2020   pk_12_total                                               103.0   1285.0                                         103   1285
2457401 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2021   pk_12_total                                               96.0   1289.0                                         96   1289
2738386 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               16.0   129.0                                         16   129
2432689 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2020   pk_12_total                                               74.0   1294.0                                         74   1294
2783411 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2018   pk_12_total                                               104.0   1294.0                                         104   1294
130511 HI     school 1500030 1   Hawaii Department of Education 150003000150 224 RADFORD HI   Regular School No High 09 12 2017   pk_12_total                                               132.0   1298.0                                         132   1298
281602 HI     school 1500030 1   Hawaii Department of Education 150003000254 392 KEALAKEHE HI   Regular School No 3 09 12 2015   pk_12_total                                               145.0   1299.0                                         145   1299
2457473 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2021   pk_12_total                                               138.0   1299.0                                         138   1299
2432777 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2020   pk_12_total                                               138.0   1304.0                                         138   1304
111561 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No 1 PK 6 2016   pk_12_total                                               85.0   1309.0                                         85   1309
2432828 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2020   pk_12_total                                               24.0   131.0                                         24   131
2783463 HI     school 1500030 1   Hawaii Department of Education 150003000254 392 Kealakehe High   Regular School No High 09 12 2018   pk_12_total                                               134.0   1311.0                                         134   1311
130580 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 WAIPAHU INT   Regular School No Middle 07 8 2017   pk_12_total                                               99.0   1314.0                                         99   1314
2738366 HI     school 1500030 1   Hawaii Department of Education 150003000004 305 Kaaawa Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               15.0   132.0                                         15   132
2738433 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   pk_12_total                                               139.0   1322.0                                         139   1322
2738406 HI     school 1500030 1   Hawaii Department of Education 150003000033 359 Honaunau Elem   Regular School No Elementary PK 5 2019   pk_12_total                                               14.0   133.0                                         14   133
2783549 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2018   pk_12_total                                               1.0   133.0                                         1   133
111508 HI     school 1500030 1   Hawaii Department of Education 150003000150 224 RADFORD HI   Regular School No 3 09 12 2016   pk_12_total                                               131.0   1330.0                                         131   1330
111451 HI     school 1500030 1   Hawaii Department of Education 150003000163 119 KALANI HI   Regular School No 3 09 12 2016   pk_12_total                                               140.0   1331.0                                         140   1331
2457526 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Academy PCS charter Regular School Yes Other KG 12 2021   pk_12_total                                               114.0   1337.0                                         114   1337
111577 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 WAIPAHU INT   Regular School No 2 07 8 2016   pk_12_total                                               134.0   1339.0                                         134   1339
281680 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes 4 04 12 2015   pk_12_total                                               13.0   134.0                                         13   134
281534 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No 1 PK 6 2015   pk_12_total                                               75.0   1342.0                                         75   1342
281482 HI     school 1500030 1   Hawaii Department of Education 150003000150 224 RADFORD HI   Regular School No 3 09 12 2015   pk_12_total                                               124.0   1347.0                                         124   1347
2432705 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2020   pk_12_total                                               103.0   1349.0                                         103   1349
2432713 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2020   pk_12_total                                               171.0   1351.0                                         171   1351
130492 HI     school 1500030 1   Hawaii Department of Education 150003000186 146 ROOSEVELT HI   Regular School No High 09 12 2017   pk_12_total                                               141.0   1355.0                                         141   1355
2432757 HI     school 1500030 1   Hawaii Department of Education 150003000254 392 Kealakehe High   Regular School No High 09 12 2020   pk_12_total                                               153.0   1357.0                                         153   1357
111602 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No 1 PK 6 2016   pk_12_total                                               14.0   136.0                                         14   136
281598 HI     school 1500030 1   Hawaii Department of Education 150003000035 363 HOOKENA   Regular School No 1 PK 5 2015   pk_12_total                                               11.0   136.0                                         11   136
281700 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes 4 KG 12 2015   pk_12_total                                               6.0   136.0                                         6   136
2457540 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2021   pk_12_total                                               3.0   136.0                                         3   136
130652 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No High 09 12 2017   pk_12_total                                               128.0   1361.0                                         128   1361
2783483 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2018   pk_12_total                                               145.0   1361.0                                         145   1361
2783323 HI     school 1500030 1   Hawaii Department of Education 150003000186 146 Roosevelt High   Regular School No High 09 12 2018   pk_12_total                                               140.0   1363.0                                         140   1363
111489 HI     school 1500030 1   Hawaii Department of Education 150003000186 146 ROOSEVELT HI   Regular School No 3 09 12 2016   pk_12_total                                               132.0   1368.0                                         132   1368
130454 HI     school 1500030 1   Hawaii Department of Education 150003000163 119 KALANI HI   Regular School No High 09 12 2017   pk_12_total                                               154.0   1371.0                                         154   1371
2738273 HI     school 1500030 1   Hawaii Department of Education 150003000186 146 Roosevelt High   Regular School No High 09 12 2019   pk_12_total                                               149.0   1372.0                                         149   1372
2738413 HI     school 1500030 1   Hawaii Department of Education 150003000254 392 Kealakehe High   Regular School No High 09 12 2019   pk_12_total                                               144.0   1374.0                                         144   1374
111585 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 KAHUKU HI   Regular School No 3 07 12 2016   pk_12_total                                               168.0   1379.0                                         168   1379
111460 HI     school 1500030 1   Hawaii Department of Education 150003000198 133 LINAPUNI   Regular School No 1 PK 1 2016   pk_12_total                                               6.0   138.0                                         6   138
281575 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No 1 PK 6 2015   pk_12_total                                               9.0   138.0                                         9   138
2738369 HI     school 1500030 1   Hawaii Department of Education 150003000007 307 Kahuku High & Int   Regular School No High 07 12 2019   pk_12_total                                               177.0   1381.0                                         177   1381

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