ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,982 rows where state = "Hawaii" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Hawaii · 3,982 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500127 | 2500127 | 2022-05-13 | Hawaii | Hawaii | 15001 | 28425 | 190 |
2500128 | 2500128 | 2022-05-13 | Honolulu | Hawaii | 15003 | 178469 | 1063 |
2500129 | 2500129 | 2022-05-13 | Kalawao | Hawaii | 15005 | 1 | 0 |
2500130 | 2500130 | 2022-05-13 | Kauai | Hawaii | 15007 | 12864 | 29 |
2500131 | 2500131 | 2022-05-13 | Maui | Hawaii | 15009 | 32000 | 140 |
2500132 | 2500132 | 2022-05-13 | Unknown | Hawaii | 0 | 9 | |
2496869 | 2496869 | 2022-05-12 | Hawaii | Hawaii | 15001 | 28425 | 190 |
2496870 | 2496870 | 2022-05-12 | Honolulu | Hawaii | 15003 | 178469 | 1063 |
2496871 | 2496871 | 2022-05-12 | Kalawao | Hawaii | 15005 | 1 | 0 |
2496872 | 2496872 | 2022-05-12 | Kauai | Hawaii | 15007 | 12864 | 29 |
2496873 | 2496873 | 2022-05-12 | Maui | Hawaii | 15009 | 32000 | 140 |
2496874 | 2496874 | 2022-05-12 | Unknown | Hawaii | 0 | 9 | |
2493611 | 2493611 | 2022-05-11 | Hawaii | Hawaii | 15001 | 28425 | 190 |
2493612 | 2493612 | 2022-05-11 | Honolulu | Hawaii | 15003 | 178469 | 1063 |
2493613 | 2493613 | 2022-05-11 | Kalawao | Hawaii | 15005 | 1 | 0 |
2493614 | 2493614 | 2022-05-11 | Kauai | Hawaii | 15007 | 12864 | 29 |
2493615 | 2493615 | 2022-05-11 | Maui | Hawaii | 15009 | 32000 | 140 |
2493616 | 2493616 | 2022-05-11 | Unknown | Hawaii | 0 | 9 | |
2490353 | 2490353 | 2022-05-10 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2490354 | 2490354 | 2022-05-10 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2490355 | 2490355 | 2022-05-10 | Kalawao | Hawaii | 15005 | 1 | 0 |
2490356 | 2490356 | 2022-05-10 | Kauai | Hawaii | 15007 | 12473 | 29 |
2490357 | 2490357 | 2022-05-10 | Maui | Hawaii | 15009 | 31311 | 140 |
2490358 | 2490358 | 2022-05-10 | Unknown | Hawaii | 0 | 9 | |
2487096 | 2487096 | 2022-05-09 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2487097 | 2487097 | 2022-05-09 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2487098 | 2487098 | 2022-05-09 | Kalawao | Hawaii | 15005 | 1 | 0 |
2487099 | 2487099 | 2022-05-09 | Kauai | Hawaii | 15007 | 12473 | 29 |
2487100 | 2487100 | 2022-05-09 | Maui | Hawaii | 15009 | 31311 | 140 |
2487101 | 2487101 | 2022-05-09 | Unknown | Hawaii | 0 | 9 | |
2483838 | 2483838 | 2022-05-08 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2483839 | 2483839 | 2022-05-08 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2483840 | 2483840 | 2022-05-08 | Kalawao | Hawaii | 15005 | 1 | 0 |
2483841 | 2483841 | 2022-05-08 | Kauai | Hawaii | 15007 | 12473 | 29 |
2483842 | 2483842 | 2022-05-08 | Maui | Hawaii | 15009 | 31311 | 140 |
2483843 | 2483843 | 2022-05-08 | Unknown | Hawaii | 0 | 9 | |
2480580 | 2480580 | 2022-05-07 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2480581 | 2480581 | 2022-05-07 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2480582 | 2480582 | 2022-05-07 | Kalawao | Hawaii | 15005 | 1 | 0 |
2480583 | 2480583 | 2022-05-07 | Kauai | Hawaii | 15007 | 12473 | 29 |
2480584 | 2480584 | 2022-05-07 | Maui | Hawaii | 15009 | 31311 | 140 |
2480585 | 2480585 | 2022-05-07 | Unknown | Hawaii | 0 | 9 | |
2477322 | 2477322 | 2022-05-06 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2477323 | 2477323 | 2022-05-06 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2477324 | 2477324 | 2022-05-06 | Kalawao | Hawaii | 15005 | 1 | 0 |
2477325 | 2477325 | 2022-05-06 | Kauai | Hawaii | 15007 | 12473 | 29 |
2477326 | 2477326 | 2022-05-06 | Maui | Hawaii | 15009 | 31311 | 140 |
2477327 | 2477327 | 2022-05-06 | Unknown | Hawaii | 0 | 9 | |
2474064 | 2474064 | 2022-05-05 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2474065 | 2474065 | 2022-05-05 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2474066 | 2474066 | 2022-05-05 | Kalawao | Hawaii | 15005 | 1 | 0 |
2474067 | 2474067 | 2022-05-05 | Kauai | Hawaii | 15007 | 12473 | 29 |
2474068 | 2474068 | 2022-05-05 | Maui | Hawaii | 15009 | 31311 | 140 |
2474069 | 2474069 | 2022-05-05 | Unknown | Hawaii | 0 | 9 | |
2470807 | 2470807 | 2022-05-04 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2470808 | 2470808 | 2022-05-04 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2470809 | 2470809 | 2022-05-04 | Kalawao | Hawaii | 15005 | 1 | 0 |
2470810 | 2470810 | 2022-05-04 | Kauai | Hawaii | 15007 | 12473 | 29 |
2470811 | 2470811 | 2022-05-04 | Maui | Hawaii | 15009 | 31311 | 140 |
2470812 | 2470812 | 2022-05-04 | Unknown | Hawaii | 0 | 9 | |
2467551 | 2467551 | 2022-05-03 | Hawaii | Hawaii | 15001 | 27142 | 187 |
2467552 | 2467552 | 2022-05-03 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2467553 | 2467553 | 2022-05-03 | Kalawao | Hawaii | 15005 | 1 | 0 |
2467554 | 2467554 | 2022-05-03 | Kauai | Hawaii | 15007 | 12240 | 28 |
2467555 | 2467555 | 2022-05-03 | Maui | Hawaii | 15009 | 30809 | 139 |
2467556 | 2467556 | 2022-05-03 | Unknown | Hawaii | 0 | 9 | |
2464296 | 2464296 | 2022-05-02 | Hawaii | Hawaii | 15001 | 27142 | 187 |
2464297 | 2464297 | 2022-05-02 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2464298 | 2464298 | 2022-05-02 | Kalawao | Hawaii | 15005 | 1 | 0 |
2464299 | 2464299 | 2022-05-02 | Kauai | Hawaii | 15007 | 12240 | 28 |
2464300 | 2464300 | 2022-05-02 | Maui | Hawaii | 15009 | 30809 | 139 |
2464301 | 2464301 | 2022-05-02 | Unknown | Hawaii | 0 | 9 | |
2461040 | 2461040 | 2022-05-01 | Hawaii | Hawaii | 15001 | 27142 | 187 |
2461041 | 2461041 | 2022-05-01 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2461042 | 2461042 | 2022-05-01 | Kalawao | Hawaii | 15005 | 1 | 0 |
2461043 | 2461043 | 2022-05-01 | Kauai | Hawaii | 15007 | 12240 | 28 |
2461044 | 2461044 | 2022-05-01 | Maui | Hawaii | 15009 | 30809 | 139 |
2461045 | 2461045 | 2022-05-01 | Unknown | Hawaii | 0 | 9 | |
2457784 | 2457784 | 2022-04-30 | Hawaii | Hawaii | 15001 | 27142 | 187 |
2457785 | 2457785 | 2022-04-30 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2457786 | 2457786 | 2022-04-30 | Kalawao | Hawaii | 15005 | 1 | 0 |
2457787 | 2457787 | 2022-04-30 | Kauai | Hawaii | 15007 | 12240 | 28 |
2457788 | 2457788 | 2022-04-30 | Maui | Hawaii | 15009 | 30809 | 139 |
2457789 | 2457789 | 2022-04-30 | Unknown | Hawaii | 0 | 9 | |
2454528 | 2454528 | 2022-04-29 | Hawaii | Hawaii | 15001 | 27142 | 187 |
2454529 | 2454529 | 2022-04-29 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2454530 | 2454530 | 2022-04-29 | Kalawao | Hawaii | 15005 | 1 | 0 |
2454531 | 2454531 | 2022-04-29 | Kauai | Hawaii | 15007 | 12240 | 28 |
2454532 | 2454532 | 2022-04-29 | Maui | Hawaii | 15009 | 30809 | 139 |
2454533 | 2454533 | 2022-04-29 | Unknown | Hawaii | 0 | 9 | |
2451272 | 2451272 | 2022-04-28 | Hawaii | Hawaii | 15001 | 27142 | 187 |
2451273 | 2451273 | 2022-04-28 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2451274 | 2451274 | 2022-04-28 | Kalawao | Hawaii | 15005 | 1 | 0 |
2451275 | 2451275 | 2022-04-28 | Kauai | Hawaii | 15007 | 12240 | 28 |
2451276 | 2451276 | 2022-04-28 | Maui | Hawaii | 15009 | 30809 | 139 |
2451277 | 2451277 | 2022-04-28 | Unknown | Hawaii | 0 | 9 | |
2448016 | 2448016 | 2022-04-27 | Hawaii | Hawaii | 15001 | 27142 | 187 |
2448017 | 2448017 | 2022-04-27 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2448018 | 2448018 | 2022-04-27 | Kalawao | Hawaii | 15005 | 1 | 0 |
2448019 | 2448019 | 2022-04-27 | Kauai | Hawaii | 15007 | 12240 | 28 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);