enrollments
Data source: Big Local News · About: Big Local
290 rows where grade = "grade_1", state = "HI" and year = 2017 sorted by unknown_race_int
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
126773 | 126773 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000248 | 280 | HOLOMUA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 154.0 | 154 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126774 | 126774 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000300 | 293 | HOOKELE EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 125.0 | 125 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126775 | 126775 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000129 | 279 | ILIMA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126776 | 126776 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000128 | 256 | IROQUOIS POINT | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 89.0 | 89 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126777 | 126777 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000127 | 281 | KAIMILOA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 96.0 | 96 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126778 | 126778 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000166 | 282 | KAPOLEI EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 139.0 | 139 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126779 | 126779 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000261 | 292 | KAPOLEI HI | Regular School | No | High | 09 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126780 | 126780 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | KAPOLEI MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126781 | 126781 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000291 | 294 | KEONEULA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 144.0 | 144 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126782 | 126782 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000123 | 259 | MAKAKILO | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 71.0 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126783 | 126783 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000121 | 286 | MAUKA LANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 91.0 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126784 | 126784 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000112 | 269 | POHAKEA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 68.0 | 68 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126785 | 126785 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000230 | 271 | LEIHOKU | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 121.0 | 121 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126786 | 126786 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000125 | 257 | MAILI | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 103.0 | 103 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126787 | 126787 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000124 | 258 | MAKAHA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 58.0 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126788 | 126788 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000119 | 261 | NANAIKAPONO | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 103.0 | 103 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126789 | 126789 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000118 | 262 | NANAKULI EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 70.0 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126790 | 126790 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000117 | 263 | NANAKULI HI & INT | Regular School | No | High | 07 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126791 | 126791 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000111 | 270 | WAIANAE EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 71.0 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126792 | 126792 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000110 | 272 | WAIANAE HI | Regular School | No | High | 09 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126793 | 126793 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000229 | 273 | WAIANAE INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126794 | 126794 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 159.0 | 159 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126795 | 126795 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000131 | 255 | HIGHLANDS INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126796 | 126796 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000130 | 276 | HONOWAI | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 93.0 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126797 | 126797 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000239 | 287 | KALEIOPUU | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 118.0 | 118 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126798 | 126798 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000231 | 283 | KANOELANI | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 112.0 | 112 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126799 | 126799 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000126 | 268 | LEHUA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 31.0 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126800 | 126800 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000122 | 260 | MANANA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 52.0 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126801 | 126801 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000120 | 285 | MOMILANI | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 58.0 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126802 | 126802 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000116 | 264 | PALISADES | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 64.0 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126803 | 126803 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000113 | 267 | PC HIGHLANDS | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 82.0 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126804 | 126804 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000115 | 265 | PEARL CITY EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 57.0 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126805 | 126805 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000114 | 266 | PEARL CITY HI | Regular School | No | High | 09 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126806 | 126806 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000109 | 288 | WAIAU | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 69.0 | 69 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126807 | 126807 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000257 | 290 | WAIKELE | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 82.0 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126808 | 126808 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000159 | 274 | WAIPAHU EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 166.0 | 166 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126809 | 126809 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000161 | 277 | WAIPAHU HI | Regular School | No | High | 09 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126810 | 126810 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000158 | 278 | WAIPAHU INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126811 | 126811 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 44.0 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126812 | 126812 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | CASTLE HI | Regular School | No | High | 09 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126813 | 126813 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000002 | 303 | HAUULA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 56.0 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126814 | 126814 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000003 | 304 | HEEIA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 57.0 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126815 | 126815 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000004 | 305 | KAAAWA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 19.0 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126816 | 126816 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000006 | 306 | KAHALUU | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 27.0 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126817 | 126817 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000236 | 331 | KAHUKU EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 43.0 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126818 | 126818 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000007 | 307 | KAHUKU HI | Regular School | No | High | 07 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126819 | 126819 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000013 | 313 | KANEOHE | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 93.0 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126820 | 126820 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000014 | 315 | KAPUNAHALA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 66.0 | 66 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126821 | 126821 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000016 | 318 | KING INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126822 | 126822 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000017 | 319 | LAIE | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 91.0 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126823 | 126823 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000021 | 323 | PARKER | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 49.0 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126824 | 126824 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000023 | 314 | PUOHALA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 41.0 | 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126825 | 126825 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000024 | 325 | SUNSET BEACH | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 55.0 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126826 | 126826 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000025 | 326 | WAIAHOLE | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 13.0 | 13 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126827 | 126827 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 64.0 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126828 | 126828 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | ENCHANTED LAKE | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 55.0 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126829 | 126829 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000005 | 330 | KAELEPULU | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 27.0 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126830 | 126830 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000008 | 308 | KAILUA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 45.0 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126831 | 126831 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000009 | 309 | KAILUA HI | Regular School | No | High | 09 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126832 | 126832 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000010 | 310 | KAILUA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126833 | 126833 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000011 | 311 | KAINALU | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 81.0 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126834 | 126834 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000012 | 312 | KALAHEO HI | Regular School | No | High | 09 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126835 | 126835 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000015 | 317 | KEOLU | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 18.0 | 18 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126836 | 126836 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000019 | 321 | MAUNAWILI | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 48.0 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126837 | 126837 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000020 | 322 | MOKAPU | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 129.0 | 129 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126838 | 126838 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000098 | 475 | OLOMANA | Alternative School | No | High | 07 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126839 | 126839 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000022 | 324 | POPE | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 36.0 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126840 | 126840 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000026 | 327 | WAIMANALO EL & INT | Regular School | No | Elementary | PK | 8 | 2017 | grade_1 | 27.0 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126841 | 126841 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | DE SILVA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 64.0 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126842 | 126842 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | HAAHEO | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 25.0 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126843 | 126843 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000029 | 355 | HILO HI | Regular School | No | High | 09 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126844 | 126844 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000030 | 356 | HILO INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126845 | 126845 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000031 | 357 | HILO UNION | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 50.0 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126846 | 126846 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000036 | 365 | KALANIANAOLE EL & INT | Regular School | No | Elementary | PK | 8 | 2017 | grade_1 | 31.0 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126847 | 126847 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000037 | 367 | KAPIOLANI | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 45.0 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126848 | 126848 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000039 | 369 | KAUMANA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 36.0 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126849 | 126849 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000042 | 372 | KEAUKAHA | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 47.0 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126850 | 126850 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000051 | 384 | WAIAKEA EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 134.0 | 134 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126851 | 126851 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000052 | 389 | WAIAKEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126852 | 126852 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | WAIAKEA INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126853 | 126853 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000054 | 386 | WAIAKEAWAENA | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 125.0 | 125 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126854 | 126854 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000032 | 358 | HOLUALOA | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 81.0 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126855 | 126855 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000033 | 359 | HONAUNAU | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 28.0 | 28 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126856 | 126856 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000249 | 361 | HONOKAA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 60.0 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126857 | 126857 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000034 | 360 | HONOKAA HI & INT | Regular School | No | High | 07 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126858 | 126858 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000035 | 363 | HOOKENA | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 18.0 | 18 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126859 | 126859 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000232 | 371 | KAHAKAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 116.0 | 116 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126860 | 126860 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000287 | 378 | KE KULA O EHUNUIKAIMALINO | Regular School | No | Other | PK | 12 | 2017 | grade_1 | 23.0 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126861 | 126861 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000041 | 388 | KEALAKEHE | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 163.0 | 163 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126862 | 126862 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000254 | 392 | KEALAKEHE HI | Regular School | No | High | 09 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126863 | 126863 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | KEALAKEHE INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126864 | 126864 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000250 | 395 | KOHALA EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 44.0 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126865 | 126865 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000043 | 373 | KOHALA HI | Regular School | No | High | 09 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126866 | 126866 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | KOHALA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126867 | 126867 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000044 | 375 | KONAWAENA EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 87.0 | 87 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126868 | 126868 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000045 | 374 | KONAWAENA HI | Regular School | No | High | 09 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126869 | 126869 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | KONAWAENA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126870 | 126870 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000049 | 382 | PAAUILO EL & INT | Regular School | No | Other | PK | 9 | 2017 | grade_1 | 23.0 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126871 | 126871 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000247 | 393 | WAIKOLOA | Regular School | No | Elementary | PK | 8 | 2017 | grade_1 | 95.0 | 95 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126872 | 126872 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000055 | 387 | WAIMEA EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 65.0 | 65 |
Advanced export
JSON shape: default, array, newline-delimited
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]);