Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • pk_12_total · 2,040
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
111692 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No 4 PK 12 2016   pk_12_total                                               0.0   4.0                                         0   4
111720 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 MALAMA HONUA PCS charter Regular School Yes 1 KG 3 2016   pk_12_total                                               0.0   63.0                                         0   63
130695 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No Other PK 12 2017   pk_12_total                                               0.0   11.0                                         0   11
281665 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No 4 PK 12 2015   pk_12_total                                               0.0   9.0                                         0   9
2432820 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 Niihau High & Elem   Regular School No Other PK 12 2020   pk_12_total                                               0.0   10.0                                         0   10
2457516 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 Niihau High & Elem   Regular School No Other PK 12 2021   pk_12_total                                               0.0   15.0                                         0   15
2738476 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 Niihau High & Elem   Regular School No Other PK 12 2019   pk_12_total                                               0.0   9.0                                         0   9
2738494 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 Myron Thompson Acad NCPCS charter Regular School Yes Other KG 12 2019   pk_12_total                                               0.0   568.0                                         0   568
2783526 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 Niihau High & Elem   Regular School No Other PK 12 2018   pk_12_total                                               0.0   9.0                                         0   9
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
2432852 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 Myron Thompson Acad NCPCS charter Regular School Yes Other KG 12 2020   pk_12_total                                               1.0   585.0                                         1   585
2457548 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 Myron Thompson Academy NCPCS charter Regular School Yes Other KG 12 2021   pk_12_total                                               1.0   527.0                                         1   527
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
2783557 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 Myron Thompson Acad NCPCS charter Regular School Yes Other KG 12 2018   pk_12_total                                               1.0   582.0                                         1   582
130625 HI     school 1500030 1   Hawaii Department of Education 150003000033 359 HONAUNAU   Regular School No Elementary PK 5 2017   pk_12_total                                               10.0   170.0                                         10   170
281566 HI     school 1500030 1   Hawaii Department of Education 150003000025 326 WAIAHOLE   Regular School No 1 PK 6 2015   pk_12_total                                               10.0   82.0                                         10   82
281582 HI     school 1500030 1   Hawaii Department of Education 150003000028 352 HAAHEO   Regular School No 1 PK 6 2015   pk_12_total                                               10.0   192.0                                         10   192
281699 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes 4 KG 12 2015   pk_12_total                                               10.0   179.0                                         10   179
2457539 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   pk_12_total                                               10.0   473.0                                         10   473
2738411 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 Ke Kula o Ehunuikaimalino   Regular School No Other PK 12 2019   pk_12_total                                               10.0   216.0                                         10   216
2738456 HI     school 1500030 1   Hawaii Department of Education 150003000065 410 Kilohana Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               10.0   77.0                                         10   77
2783461 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 Ke Kula o Ehunuikaimalino   Regular School No Other PK 12 2018   pk_12_total                                               10.0   210.0                                         10   210
111555 HI     school 1500030 1   Hawaii Department of Education 150003000119 261 NANAIKAPONO   Regular School No 1 PK 6 2016   pk_12_total                                               100.0   848.0                                         100   848
130602 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No Middle 07 8 2017   pk_12_total                                               100.0   781.0                                         100   781
130686 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No Middle 06 8 2017   pk_12_total                                               100.0   975.0                                         100   975
281528 HI     school 1500030 1   Hawaii Department of Education 150003000119 261 NANAIKAPONO   Regular School No 1 PK 6 2015   pk_12_total                                               100.0   868.0                                         100   868
2432716 HI     school 1500030 1   Hawaii Department of Education 150003000016 318 King Int   Regular School No Middle 07 8 2020   pk_12_total                                               100.0   629.0                                         100   629
2457511 HI     school 1500030 1   Hawaii Department of Education 150003000086 456 Kauai High   Regular School No High 09 12 2021   pk_12_total                                               100.0   1134.0                                         100   1134
2738337 HI     school 1500030 1   Hawaii Department of Education 150003000125 257 Maili Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               100.0   803.0                                         100   803
2783508 HI     school 1500030 1   Hawaii Department of Education 150003000069 414 Lahainaluna High   Regular School No High 09 12 2018   pk_12_total                                               100.0   1020.0                                         100   1020
111562 HI     school 1500030 1   Hawaii Department of Education 150003000131 255 HIGHLANDS INT   Regular School No 2 07 8 2016   pk_12_total                                               101.0   907.0                                         101   907
130557 HI     school 1500030 1   Hawaii Department of Education 150003000124 258 MAKAHA   Regular School No Elementary PK 6 2017   pk_12_total                                               101.0   565.0                                         101   565
130591 HI     school 1500030 1   Hawaii Department of Education 150003000016 318 KING INT   Regular School No Middle 07 8 2017   pk_12_total                                               101.0   609.0                                         101   609
130651 HI     school 1500030 1   Hawaii Department of Education 150003000050 383 PAHOA HI & INT   Regular School No High 07 12 2017   pk_12_total                                               101.0   528.0                                         101   528
2432779 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 Iao Int   Regular School No Middle 06 8 2020   pk_12_total                                               101.0   1004.0                                         101   1004
2457378 HI     school 1500030 1   Hawaii Department of Education 150003000124 258 Makaha Elem   Regular School No Elementary PK 6 2021   pk_12_total                                               101.0   446.0                                         101   446
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
2457467 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 Keaau Middle   Regular School No Middle 06 8 2021   pk_12_total                                               101.0   708.0                                         101   708
111687 HI     school 1500030 1   Hawaii Department of Education 150003000086 456 KAUAI HI   Regular School No 3 09 12 2016   pk_12_total                                               102.0   1131.0                                         102   1131
130558 HI     school 1500030 1   Hawaii Department of Education 150003000119 261 NANAIKAPONO   Regular School No Elementary PK 6 2017   pk_12_total                                               102.0   832.0                                         102   832
130565 HI     school 1500030 1   Hawaii Department of Education 150003000131 255 HIGHLANDS INT   Regular School No Middle 07 8 2017   pk_12_total                                               102.0   876.0                                         102   876
130690 HI     school 1500030 1   Hawaii Department of Education 150003000086 456 KAUAI HI   Regular School No High 09 12 2017   pk_12_total                                               102.0   1130.0                                         102   1130
281656 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No 2 06 8 2015   pk_12_total                                               102.0   943.0                                         102   943
2432625 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2020   pk_12_total                                               102.0   814.0                                         102   814
281626 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No 2 06 8 2015   pk_12_total                                               103.0   822.0                                         103   822
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
2432729 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 Kalaheo High   Regular School No High 09 12 2020   pk_12_total                                               103.0   813.0                                         103   813
2432771 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 Keaau Middle   Regular School No Middle 06 8 2020   pk_12_total                                               103.0   756.0                                         103   756
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
2457423 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2021   pk_12_total                                               103.0   785.0                                         103   785
2783482 HI     school 1500030 1   Hawaii Department of Education 150003000050 383 Pahoa High & Int   Regular School No High 07 12 2018   pk_12_total                                               103.0   532.0                                         103   532
2783538 HI     school 1500030 1   Hawaii Department of Education 150003000240 275 Kamaile Academy PCS charter Regular School Yes Other PK 12 2018   pk_12_total                                               103.0   860.0                                         103   860
111553 HI     school 1500030 1   Hawaii Department of Education 150003000125 257 MAILI   Regular School No 1 PK 6 2016   pk_12_total                                               104.0   1022.0                                         104   1022
111651 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No 2 06 8 2016   pk_12_total                                               104.0   918.0                                         104   918
130677 HI     school 1500030 1   Hawaii Department of Education 150003000069 414 LAHAINALUNA HI   Regular School No High 09 12 2017   pk_12_total                                               104.0   1007.0                                         104   1007
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
2457486 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 Maui Waena Int   Regular School No Middle 06 8 2021   pk_12_total                                               104.0   1100.0                                         104   1100
2738372 HI     school 1500030 1   Hawaii Department of Education 150003000016 318 King Int   Regular School No Middle 07 8 2019   pk_12_total                                               104.0   641.0                                         104   641
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
111648 HI     school 1500030 1   Hawaii Department of Education 150003000050 383 PAHOA HI & INT   Regular School No 3 07 12 2016   pk_12_total                                               105.0   576.0                                         105   576
111674 HI     school 1500030 1   Hawaii Department of Education 150003000069 414 LAHAINALUNA HI   Regular School No 3 09 12 2016   pk_12_total                                               105.0   964.0                                         105   964
281574 HI     school 1500030 1   Hawaii Department of Education 150003000012 312 KALAHEO HI   Regular School No 3 09 12 2015   pk_12_total                                               105.0   916.0                                         105   916
2432683 HI     school 1500030 1   Hawaii Department of Education 150003000119 261 Nanaikapono Elem   Regular School No Elementary PK 6 2020   pk_12_total                                               105.0   748.0                                         105   748
2457443 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 Waiakea Int   Regular School No Middle 06 8 2021   pk_12_total                                               105.0   805.0                                         105   805
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
130654 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No Middle 06 8 2017   pk_12_total                                               106.0   904.0                                         106   904
2432727 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 Kailua Int   Regular School No Middle 07 8 2020   pk_12_total                                               106.0   776.0                                         106   776
2457379 HI     school 1500030 1   Hawaii Department of Education 150003000119 261 Nanaikapono Elem   Regular School No Elementary PK 6 2021   pk_12_total                                               106.0   730.0                                         106   730
2738446 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 Maui Waena Int   Regular School No Middle 06 8 2019   pk_12_total                                               106.0   1155.0                                         106   1155
2783364 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 Wahiawa Middle   Regular School No Middle 06 8 2018   pk_12_total                                               106.0   775.0                                         106   775
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
2783521 HI     school 1500030 1   Hawaii Department of Education 150003000086 456 Kauai High   Regular School No High 09 12 2018   pk_12_total                                               106.0   1126.0                                         106   1126
130708 HI     school 1500030 1   Hawaii Department of Education 150003000240 275 KAMAILE ACADEMY charter Regular School Yes Other PK 12 2017   pk_12_total                                               107.0   891.0                                         107   891
2432813 HI     school 1500030 1   Hawaii Department of Education 150003000085 455 Kapaa High   Regular School No High 09 12 2020   pk_12_total                                               107.0   1042.0                                         107   1042
2738469 HI     school 1500030 1   Hawaii Department of Education 150003000085 455 Kapaa High   Regular School No High 09 12 2019   pk_12_total                                               107.0   1083.0                                         107   1083
2738471 HI     school 1500030 1   Hawaii Department of Education 150003000086 456 Kauai High   Regular School No High 09 12 2019   pk_12_total                                               107.0   1154.0                                         107   1154
281504 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No 2 06 8 2015   pk_12_total                                               108.0   838.0                                         108   838
2432747 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 Waiakea Int   Regular School No Middle 06 8 2020   pk_12_total                                               108.0   903.0                                         108   903
2457412 HI     school 1500030 1   Hawaii Department of Education 150003000016 318 King Int   Regular School No Middle 07 8 2021   pk_12_total                                               109.0   609.0                                         109   609
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
130599 HI     school 1500030 1   Hawaii Department of Education 150003000005 330 KAELEPULU   Regular School No Elementary PK 6 2017   pk_12_total                                               11.0   189.0                                         11   189
130612 HI     school 1500030 1   Hawaii Department of Education 150003000028 352 HAAHEO   Regular School No Elementary PK 6 2017   pk_12_total                                               11.0   190.0                                         11   190
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
2432721 HI     school 1500030 1   Hawaii Department of Education 150003000025 326 Waiahole Elem   Regular School No Elementary PK 6 2020   pk_12_total                                               11.0   90.0                                         11   90
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
2432848 HI     school 1500030 1   Hawaii Department of Education 150003000288 557 Kua O Ka La PCS charter Regular School Yes Other PK 12 2020   pk_12_total                                               11.0   231.0                                         11   231
2457417 HI     school 1500030 1   Hawaii Department of Education 150003000025 326 Waiahole Elem   Regular School No Elementary PK 6 2021   pk_12_total                                               11.0   95.0                                         11   95
2457544 HI     school 1500030 1   Hawaii Department of Education 150003000288 557 Kua O Ka La PCS charter Regular School Yes Elementary PK 8 2021   pk_12_total                                               11.0   173.0                                         11   173
2457549 HI     school 1500030 1   Hawaii Department of Education 150003000264 398 Na Wai Ola NCPCS charter Regular School Yes Elementary PK 6 2021   pk_12_total                                               11.0   150.0                                         11   150
2457556 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 West Hawaii Explorations PCS charter Regular School Yes High 06 12 2021   pk_12_total                                               11.0   275.0                                         11   275
2738513 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2019   pk_12_total                                               11.0   155.0                                         11   155
2783402 HI     school 1500030 1   Hawaii Department of Education 150003000120 285 Momilani Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               11.0   412.0                                         11   412
2783565 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 West Hawaii Explorations PCS charter Regular School Yes High 06 12 2018   pk_12_total                                               11.0   252.0                                         11   252
281423 HI     school 1500030 1   Hawaii Department of Education 150003000228 154 KAISER HI   Regular School No 3 09 12 2015   pk_12_total                                               110.0   1156.0                                         110   1156
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
2457376 HI     school 1500030 1   Hawaii Department of Education 150003000230 271 Leihoku Elem   Regular School No Elementary PK 6 2021   pk_12_total                                               110.0   779.0                                         110   779
2457509 HI     school 1500030 1   Hawaii Department of Education 150003000085 455 Kapaa High   Regular School No High 09 12 2021   pk_12_total                                               110.0   1060.0                                         110   1060
2738481 HI     school 1500030 1   Hawaii Department of Education 150003000240 275 Kamaile Academy PCS charter Regular School Yes Other PK 12 2019   pk_12_total                                               110.0   844.0                                         110   844
130627 HI     school 1500030 1   Hawaii Department of Education 150003000034 360 HONOKAA HI & INT   Regular School No High 07 12 2017   pk_12_total                                               111.0   683.0                                         111   683
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

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