ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where deaths = 3 and state = "Hawaii" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Hawaii · 51 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1862660 | 1862660 | 2021-10-29 | Unknown | Hawaii | 0 | 3 | |
1846414 | 1846414 | 2021-10-24 | Unknown | Hawaii | 0 | 3 | |
1778182 | 1778182 | 2021-10-03 | Unknown | Hawaii | 0 | 3 | |
1774932 | 1774932 | 2021-10-02 | Unknown | Hawaii | 0 | 3 | |
1732695 | 1732695 | 2021-09-19 | Unknown | Hawaii | 0 | 3 | |
1729445 | 1729445 | 2021-09-18 | Unknown | Hawaii | 0 | 3 | |
1726195 | 1726195 | 2021-09-17 | Unknown | Hawaii | 0 | 3 | |
1709956 | 1709956 | 2021-09-12 | Unknown | Hawaii | 0 | 3 | |
1683963 | 1683963 | 2021-09-04 | Kauai | Hawaii | 15007 | 1447 | 3 |
1680712 | 1680712 | 2021-09-03 | Kauai | Hawaii | 15007 | 1408 | 3 |
1677464 | 1677464 | 2021-09-02 | Kauai | Hawaii | 15007 | 1366 | 3 |
1674217 | 1674217 | 2021-09-01 | Kauai | Hawaii | 15007 | 1327 | 3 |
1670969 | 1670969 | 2021-08-31 | Kauai | Hawaii | 15007 | 1290 | 3 |
1667722 | 1667722 | 2021-08-30 | Kauai | Hawaii | 15007 | 1277 | 3 |
1664475 | 1664475 | 2021-08-29 | Kauai | Hawaii | 15007 | 1243 | 3 |
1661227 | 1661227 | 2021-08-28 | Kauai | Hawaii | 15007 | 1188 | 3 |
1657979 | 1657979 | 2021-08-27 | Kauai | Hawaii | 15007 | 1157 | 3 |
1654731 | 1654731 | 2021-08-26 | Kauai | Hawaii | 15007 | 1119 | 3 |
1651484 | 1651484 | 2021-08-25 | Kauai | Hawaii | 15007 | 1087 | 3 |
1648235 | 1648235 | 2021-08-24 | Kauai | Hawaii | 15007 | 1048 | 3 |
1644987 | 1644987 | 2021-08-23 | Kauai | Hawaii | 15007 | 1031 | 3 |
1641737 | 1641737 | 2021-08-22 | Kauai | Hawaii | 15007 | 1008 | 3 |
1638487 | 1638487 | 2021-08-21 | Kauai | Hawaii | 15007 | 971 | 3 |
1635237 | 1635237 | 2021-08-20 | Kauai | Hawaii | 15007 | 945 | 3 |
1631988 | 1631988 | 2021-08-19 | Kauai | Hawaii | 15007 | 919 | 3 |
541446 | 541446 | 2020-09-17 | Hawaii | Hawaii | 15001 | 630 | 3 |
538209 | 538209 | 2020-09-16 | Hawaii | Hawaii | 15001 | 610 | 3 |
534973 | 534973 | 2020-09-15 | Hawaii | Hawaii | 15001 | 606 | 3 |
531738 | 531738 | 2020-09-14 | Hawaii | Hawaii | 15001 | 601 | 3 |
528501 | 528501 | 2020-09-13 | Hawaii | Hawaii | 15001 | 594 | 3 |
525265 | 525265 | 2020-09-12 | Hawaii | Hawaii | 15001 | 579 | 3 |
522029 | 522029 | 2020-09-11 | Hawaii | Hawaii | 15001 | 569 | 3 |
518792 | 518792 | 2020-09-10 | Hawaii | Hawaii | 15001 | 548 | 3 |
515557 | 515557 | 2020-09-09 | Hawaii | Hawaii | 15001 | 540 | 3 |
512324 | 512324 | 2020-09-08 | Hawaii | Hawaii | 15001 | 530 | 3 |
509091 | 509091 | 2020-09-07 | Hawaii | Hawaii | 15001 | 517 | 3 |
505859 | 505859 | 2020-09-06 | Hawaii | Hawaii | 15001 | 506 | 3 |
502625 | 502625 | 2020-09-05 | Hawaii | Hawaii | 15001 | 493 | 3 |
499391 | 499391 | 2020-09-04 | Hawaii | Hawaii | 15001 | 469 | 3 |
496158 | 496158 | 2020-09-03 | Hawaii | Hawaii | 15001 | 435 | 3 |
492924 | 492924 | 2020-09-02 | Hawaii | Hawaii | 15001 | 418 | 3 |
489691 | 489691 | 2020-09-01 | Hawaii | Hawaii | 15001 | 383 | 3 |
67886 | 67886 | 2020-04-18 | Maui | Hawaii | 15009 | 104 | 3 |
65138 | 65138 | 2020-04-17 | Maui | Hawaii | 15009 | 102 | 3 |
62405 | 62405 | 2020-04-16 | Maui | Hawaii | 15009 | 95 | 3 |
59685 | 59685 | 2020-04-15 | Maui | Hawaii | 15009 | 92 | 3 |
56978 | 56978 | 2020-04-14 | Maui | Hawaii | 15009 | 88 | 3 |
54286 | 54286 | 2020-04-13 | Maui | Hawaii | 15009 | 86 | 3 |
51606 | 51606 | 2020-04-12 | Maui | Hawaii | 15009 | 84 | 3 |
48944 | 48944 | 2020-04-11 | Maui | Hawaii | 15009 | 80 | 3 |
46313 | 46313 | 2020-04-10 | Maui | Hawaii | 15009 | 66 | 3 |
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);