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)
state 1
- Hawaii · 3,882 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2448020 | 2448020 | 2022-04-27 | Maui | Hawaii | 15009 | 30809 | 139 |
2448021 | 2448021 | 2022-04-27 | Unknown | Hawaii | 0 | 9 | |
2444760 | 2444760 | 2022-04-26 | Hawaii | Hawaii | 15001 | 26651 | 185 |
2444761 | 2444761 | 2022-04-26 | Honolulu | Hawaii | 15003 | 169656 | 1043 |
2444762 | 2444762 | 2022-04-26 | Kalawao | Hawaii | 15005 | 1 | 0 |
2444763 | 2444763 | 2022-04-26 | Kauai | Hawaii | 15007 | 12049 | 28 |
2444764 | 2444764 | 2022-04-26 | Maui | Hawaii | 15009 | 30406 | 139 |
2444765 | 2444765 | 2022-04-26 | Unknown | Hawaii | 0 | 9 | |
2441504 | 2441504 | 2022-04-25 | Hawaii | Hawaii | 15001 | 26651 | 185 |
2441505 | 2441505 | 2022-04-25 | Honolulu | Hawaii | 15003 | 169656 | 1043 |
2441506 | 2441506 | 2022-04-25 | Kalawao | Hawaii | 15005 | 1 | 0 |
2441507 | 2441507 | 2022-04-25 | Kauai | Hawaii | 15007 | 12049 | 28 |
2441508 | 2441508 | 2022-04-25 | Maui | Hawaii | 15009 | 30406 | 139 |
2441509 | 2441509 | 2022-04-25 | Unknown | Hawaii | 0 | 9 | |
2438248 | 2438248 | 2022-04-24 | Hawaii | Hawaii | 15001 | 26651 | 185 |
2438249 | 2438249 | 2022-04-24 | Honolulu | Hawaii | 15003 | 169656 | 1043 |
2438250 | 2438250 | 2022-04-24 | Kalawao | Hawaii | 15005 | 1 | 0 |
2438251 | 2438251 | 2022-04-24 | Kauai | Hawaii | 15007 | 12049 | 28 |
2438252 | 2438252 | 2022-04-24 | Maui | Hawaii | 15009 | 30406 | 139 |
2438253 | 2438253 | 2022-04-24 | Unknown | Hawaii | 0 | 9 | |
2434992 | 2434992 | 2022-04-23 | Hawaii | Hawaii | 15001 | 26651 | 185 |
2434993 | 2434993 | 2022-04-23 | Honolulu | Hawaii | 15003 | 169656 | 1043 |
2434994 | 2434994 | 2022-04-23 | Kalawao | Hawaii | 15005 | 1 | 0 |
2434995 | 2434995 | 2022-04-23 | Kauai | Hawaii | 15007 | 12049 | 28 |
2434996 | 2434996 | 2022-04-23 | Maui | Hawaii | 15009 | 30406 | 139 |
2434997 | 2434997 | 2022-04-23 | Unknown | Hawaii | 0 | 9 | |
2431736 | 2431736 | 2022-04-22 | Hawaii | Hawaii | 15001 | 26651 | 185 |
2431737 | 2431737 | 2022-04-22 | Honolulu | Hawaii | 15003 | 169656 | 1043 |
2431738 | 2431738 | 2022-04-22 | Kalawao | Hawaii | 15005 | 1 | 0 |
2431739 | 2431739 | 2022-04-22 | Kauai | Hawaii | 15007 | 12049 | 28 |
2431740 | 2431740 | 2022-04-22 | Maui | Hawaii | 15009 | 30406 | 139 |
2431741 | 2431741 | 2022-04-22 | Unknown | Hawaii | 0 | 9 | |
2428480 | 2428480 | 2022-04-21 | Hawaii | Hawaii | 15001 | 26651 | 185 |
2428481 | 2428481 | 2022-04-21 | Honolulu | Hawaii | 15003 | 169656 | 1043 |
2428482 | 2428482 | 2022-04-21 | Kalawao | Hawaii | 15005 | 1 | 0 |
2428483 | 2428483 | 2022-04-21 | Kauai | Hawaii | 15007 | 12049 | 28 |
2428484 | 2428484 | 2022-04-21 | Maui | Hawaii | 15009 | 30406 | 139 |
2428485 | 2428485 | 2022-04-21 | Unknown | Hawaii | 0 | 9 | |
2425224 | 2425224 | 2022-04-20 | Hawaii | Hawaii | 15001 | 26651 | 185 |
2425225 | 2425225 | 2022-04-20 | Honolulu | Hawaii | 15003 | 169656 | 1043 |
2425226 | 2425226 | 2022-04-20 | Kalawao | Hawaii | 15005 | 1 | 0 |
2425227 | 2425227 | 2022-04-20 | Kauai | Hawaii | 15007 | 12049 | 28 |
2425228 | 2425228 | 2022-04-20 | Maui | Hawaii | 15009 | 30406 | 139 |
2425229 | 2425229 | 2022-04-20 | Unknown | Hawaii | 0 | 9 | |
2421968 | 2421968 | 2022-04-19 | Hawaii | Hawaii | 15001 | 26501 | 184 |
2421969 | 2421969 | 2022-04-19 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2421970 | 2421970 | 2022-04-19 | Kalawao | Hawaii | 15005 | 1 | 0 |
2421971 | 2421971 | 2022-04-19 | Kauai | Hawaii | 15007 | 11961 | 28 |
2421972 | 2421972 | 2022-04-19 | Maui | Hawaii | 15009 | 30190 | 137 |
2421973 | 2421973 | 2022-04-19 | Unknown | Hawaii | 0 | 9 | |
2418712 | 2418712 | 2022-04-18 | Hawaii | Hawaii | 15001 | 26501 | 184 |
2418713 | 2418713 | 2022-04-18 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2418714 | 2418714 | 2022-04-18 | Kalawao | Hawaii | 15005 | 1 | 0 |
2418715 | 2418715 | 2022-04-18 | Kauai | Hawaii | 15007 | 11961 | 28 |
2418716 | 2418716 | 2022-04-18 | Maui | Hawaii | 15009 | 30190 | 137 |
2418717 | 2418717 | 2022-04-18 | Unknown | Hawaii | 0 | 9 | |
2415456 | 2415456 | 2022-04-17 | Hawaii | Hawaii | 15001 | 26501 | 184 |
2415457 | 2415457 | 2022-04-17 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2415458 | 2415458 | 2022-04-17 | Kalawao | Hawaii | 15005 | 1 | 0 |
2415459 | 2415459 | 2022-04-17 | Kauai | Hawaii | 15007 | 11961 | 28 |
2415460 | 2415460 | 2022-04-17 | Maui | Hawaii | 15009 | 30190 | 137 |
2415461 | 2415461 | 2022-04-17 | Unknown | Hawaii | 0 | 9 | |
2412200 | 2412200 | 2022-04-16 | Hawaii | Hawaii | 15001 | 26501 | 184 |
2412201 | 2412201 | 2022-04-16 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2412202 | 2412202 | 2022-04-16 | Kalawao | Hawaii | 15005 | 1 | 0 |
2412203 | 2412203 | 2022-04-16 | Kauai | Hawaii | 15007 | 11961 | 28 |
2412204 | 2412204 | 2022-04-16 | Maui | Hawaii | 15009 | 30190 | 137 |
2412205 | 2412205 | 2022-04-16 | Unknown | Hawaii | 0 | 9 | |
2408944 | 2408944 | 2022-04-15 | Hawaii | Hawaii | 15001 | 26501 | 184 |
2408945 | 2408945 | 2022-04-15 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2408946 | 2408946 | 2022-04-15 | Kalawao | Hawaii | 15005 | 1 | 0 |
2408947 | 2408947 | 2022-04-15 | Kauai | Hawaii | 15007 | 11961 | 28 |
2408948 | 2408948 | 2022-04-15 | Maui | Hawaii | 15009 | 30190 | 137 |
2408949 | 2408949 | 2022-04-15 | Unknown | Hawaii | 0 | 9 | |
2405688 | 2405688 | 2022-04-14 | Hawaii | Hawaii | 15001 | 26501 | 184 |
2405689 | 2405689 | 2022-04-14 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2405690 | 2405690 | 2022-04-14 | Kalawao | Hawaii | 15005 | 1 | 0 |
2405691 | 2405691 | 2022-04-14 | Kauai | Hawaii | 15007 | 11961 | 28 |
2405692 | 2405692 | 2022-04-14 | Maui | Hawaii | 15009 | 30190 | 137 |
2405693 | 2405693 | 2022-04-14 | Unknown | Hawaii | 0 | 9 | |
2402433 | 2402433 | 2022-04-13 | Hawaii | Hawaii | 15001 | 26501 | 184 |
2402434 | 2402434 | 2022-04-13 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2402435 | 2402435 | 2022-04-13 | Kalawao | Hawaii | 15005 | 1 | 0 |
2402436 | 2402436 | 2022-04-13 | Kauai | Hawaii | 15007 | 11961 | 28 |
2402437 | 2402437 | 2022-04-13 | Maui | Hawaii | 15009 | 30190 | 137 |
2402438 | 2402438 | 2022-04-13 | Unknown | Hawaii | 0 | 9 | |
2399178 | 2399178 | 2022-04-12 | Hawaii | Hawaii | 15001 | 26341 | 184 |
2399179 | 2399179 | 2022-04-12 | Honolulu | Hawaii | 15003 | 167503 | 1022 |
2399180 | 2399180 | 2022-04-12 | Kalawao | Hawaii | 15005 | 1 | 0 |
2399181 | 2399181 | 2022-04-12 | Kauai | Hawaii | 15007 | 11906 | 28 |
2399182 | 2399182 | 2022-04-12 | Maui | Hawaii | 15009 | 30046 | 136 |
2399183 | 2399183 | 2022-04-12 | Unknown | Hawaii | 0 | 9 | |
2395923 | 2395923 | 2022-04-11 | Hawaii | Hawaii | 15001 | 26341 | 184 |
2395924 | 2395924 | 2022-04-11 | Honolulu | Hawaii | 15003 | 167503 | 1022 |
2395925 | 2395925 | 2022-04-11 | Kalawao | Hawaii | 15005 | 1 | 0 |
2395926 | 2395926 | 2022-04-11 | Kauai | Hawaii | 15007 | 11906 | 28 |
2395927 | 2395927 | 2022-04-11 | Maui | Hawaii | 15009 | 30046 | 136 |
2395928 | 2395928 | 2022-04-11 | Unknown | Hawaii | 0 | 9 | |
2392667 | 2392667 | 2022-04-10 | Hawaii | Hawaii | 15001 | 26341 | 184 |
2392668 | 2392668 | 2022-04-10 | Honolulu | Hawaii | 15003 | 167503 | 1022 |
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);