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
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2021-08-03 6
- 2021-08-04 6
- 2021-08-05 6
- 2021-08-06 6
- 2021-08-07 6
- 2021-08-08 6
- 2021-08-20 6
- 2021-08-21 6
- 2021-08-22 6
- 2021-09-01 6
- 2021-09-02 6
- 2021-09-03 6
- 2021-09-04 6
- 2021-09-05 6
- 2021-09-06 6
- 2021-09-07 6
- 2021-09-08 6
- 2021-09-09 6
- 2021-09-10 6
- 2021-09-11 6
- 2021-09-12 6
- 2021-09-13 6
- 2021-09-14 6
- 2021-09-15 6
- 2021-09-16 6
- 2021-09-17 6
- 2021-09-18 6
- 2021-09-19 6
- 2021-09-20 6
- 2021-09-21 6
- …
state 1
- Hawaii · 3,982 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
612 | 612 | 2020-03-06 | Honolulu | Hawaii | 15003 | 1 | 0 |
696 | 696 | 2020-03-07 | Honolulu | Hawaii | 15003 | 1 | 0 |
793 | 793 | 2020-03-08 | Honolulu | Hawaii | 15003 | 2 | 0 |
913 | 913 | 2020-03-09 | Honolulu | Hawaii | 15003 | 2 | 0 |
1054 | 1054 | 2020-03-10 | Honolulu | Hawaii | 15003 | 2 | 0 |
1228 | 1228 | 2020-03-11 | Honolulu | Hawaii | 15003 | 2 | 0 |
1442 | 1442 | 2020-03-12 | Honolulu | Hawaii | 15003 | 2 | 0 |
1712 | 1712 | 2020-03-13 | Honolulu | Hawaii | 15003 | 2 | 0 |
2035 | 2035 | 2020-03-14 | Honolulu | Hawaii | 15003 | 2 | 0 |
2036 | 2036 | 2020-03-14 | Kauai | Hawaii | 15007 | 2 | 0 |
2424 | 2424 | 2020-03-15 | Honolulu | Hawaii | 15003 | 4 | 0 |
2425 | 2425 | 2020-03-15 | Kauai | Hawaii | 15007 | 2 | 0 |
2426 | 2426 | 2020-03-15 | Maui | Hawaii | 15009 | 1 | 0 |
2865 | 2865 | 2020-03-16 | Honolulu | Hawaii | 15003 | 6 | 0 |
2866 | 2866 | 2020-03-16 | Kauai | Hawaii | 15007 | 2 | 0 |
2867 | 2867 | 2020-03-16 | Maui | Hawaii | 15009 | 2 | 0 |
3352 | 3352 | 2020-03-17 | Hawaii | Hawaii | 15001 | 1 | 0 |
3353 | 3353 | 2020-03-17 | Honolulu | Hawaii | 15003 | 8 | 0 |
3354 | 3354 | 2020-03-17 | Kauai | Hawaii | 15007 | 2 | 0 |
3355 | 3355 | 2020-03-17 | Maui | Hawaii | 15009 | 3 | 0 |
3914 | 3914 | 2020-03-18 | Hawaii | Hawaii | 15001 | 1 | 0 |
3915 | 3915 | 2020-03-18 | Honolulu | Hawaii | 15003 | 10 | 0 |
3916 | 3916 | 2020-03-18 | Kauai | Hawaii | 15007 | 2 | 0 |
3917 | 3917 | 2020-03-18 | Maui | Hawaii | 15009 | 3 | 0 |
4590 | 4590 | 2020-03-19 | Hawaii | Hawaii | 15001 | 1 | 0 |
4591 | 4591 | 2020-03-19 | Honolulu | Hawaii | 15003 | 18 | 0 |
4592 | 4592 | 2020-03-19 | Kauai | Hawaii | 15007 | 2 | 0 |
4593 | 4593 | 2020-03-19 | Maui | Hawaii | 15009 | 5 | 0 |
5390 | 5390 | 2020-03-20 | Hawaii | Hawaii | 15001 | 1 | 0 |
5391 | 5391 | 2020-03-20 | Honolulu | Hawaii | 15003 | 28 | 0 |
5392 | 5392 | 2020-03-20 | Kauai | Hawaii | 15007 | 3 | 0 |
5393 | 5393 | 2020-03-20 | Maui | Hawaii | 15009 | 5 | 0 |
6324 | 6324 | 2020-03-21 | Hawaii | Hawaii | 15001 | 3 | 0 |
6325 | 6325 | 2020-03-21 | Honolulu | Hawaii | 15003 | 35 | 0 |
6326 | 6326 | 2020-03-21 | Kauai | Hawaii | 15007 | 3 | 0 |
6327 | 6327 | 2020-03-21 | Maui | Hawaii | 15009 | 7 | 0 |
7372 | 7372 | 2020-03-22 | Hawaii | Hawaii | 15001 | 3 | 0 |
7373 | 7373 | 2020-03-22 | Honolulu | Hawaii | 15003 | 41 | 0 |
7374 | 7374 | 2020-03-22 | Kauai | Hawaii | 15007 | 3 | 0 |
7375 | 7375 | 2020-03-22 | Maui | Hawaii | 15009 | 9 | 0 |
8526 | 8526 | 2020-03-23 | Hawaii | Hawaii | 15001 | 5 | 0 |
8527 | 8527 | 2020-03-23 | Honolulu | Hawaii | 15003 | 53 | 0 |
8528 | 8528 | 2020-03-23 | Kauai | Hawaii | 15007 | 3 | 0 |
8529 | 8529 | 2020-03-23 | Maui | Hawaii | 15009 | 11 | 0 |
8530 | 8530 | 2020-03-23 | Unknown | Hawaii | 5 | 0 | |
9787 | 9787 | 2020-03-24 | Hawaii | Hawaii | 15001 | 5 | 0 |
9788 | 9788 | 2020-03-24 | Honolulu | Hawaii | 15003 | 58 | 0 |
9789 | 9789 | 2020-03-24 | Kauai | Hawaii | 15007 | 3 | 0 |
9790 | 9790 | 2020-03-24 | Maui | Hawaii | 15009 | 11 | 0 |
9791 | 9791 | 2020-03-24 | Unknown | Hawaii | 13 | 0 | |
11172 | 11172 | 2020-03-25 | Hawaii | Hawaii | 15001 | 5 | 0 |
11173 | 11173 | 2020-03-25 | Honolulu | Hawaii | 15003 | 68 | 0 |
11174 | 11174 | 2020-03-25 | Kauai | Hawaii | 15007 | 5 | 0 |
11175 | 11175 | 2020-03-25 | Maui | Hawaii | 15009 | 13 | 0 |
11176 | 11176 | 2020-03-25 | Unknown | Hawaii | 4 | 0 | |
12725 | 12725 | 2020-03-26 | Hawaii | Hawaii | 15001 | 5 | 0 |
12726 | 12726 | 2020-03-26 | Honolulu | Hawaii | 15003 | 77 | 0 |
12727 | 12727 | 2020-03-26 | Kauai | Hawaii | 15007 | 5 | 0 |
12728 | 12728 | 2020-03-26 | Maui | Hawaii | 15009 | 14 | 0 |
12729 | 12729 | 2020-03-26 | Unknown | Hawaii | 5 | 0 | |
14400 | 14400 | 2020-03-27 | Hawaii | Hawaii | 15001 | 7 | 0 |
14401 | 14401 | 2020-03-27 | Honolulu | Hawaii | 15003 | 87 | 0 |
14402 | 14402 | 2020-03-27 | Kauai | Hawaii | 15007 | 5 | 0 |
14403 | 14403 | 2020-03-27 | Maui | Hawaii | 15009 | 16 | 0 |
14404 | 14404 | 2020-03-27 | Unknown | Hawaii | 5 | 0 | |
16191 | 16191 | 2020-03-28 | Hawaii | Hawaii | 15001 | 10 | 0 |
16192 | 16192 | 2020-03-28 | Honolulu | Hawaii | 15003 | 108 | 0 |
16193 | 16193 | 2020-03-28 | Kauai | Hawaii | 15007 | 11 | 0 |
16194 | 16194 | 2020-03-28 | Maui | Hawaii | 15009 | 16 | 0 |
16195 | 16195 | 2020-03-28 | Unknown | Hawaii | 6 | 0 | |
18088 | 18088 | 2020-03-29 | Hawaii | Hawaii | 15001 | 12 | 0 |
18089 | 18089 | 2020-03-29 | Honolulu | Hawaii | 15003 | 119 | 0 |
18090 | 18090 | 2020-03-29 | Kauai | Hawaii | 15007 | 12 | 0 |
18091 | 18091 | 2020-03-29 | Maui | Hawaii | 15009 | 20 | 0 |
18092 | 18092 | 2020-03-29 | Unknown | Hawaii | 12 | 0 | |
20084 | 20084 | 2020-03-30 | Hawaii | Hawaii | 15001 | 15 | 0 |
20085 | 20085 | 2020-03-30 | Honolulu | Hawaii | 15003 | 139 | 0 |
20086 | 20086 | 2020-03-30 | Kauai | Hawaii | 15007 | 12 | 0 |
20087 | 20087 | 2020-03-30 | Maui | Hawaii | 15009 | 25 | 0 |
20088 | 20088 | 2020-03-30 | Unknown | Hawaii | 13 | 0 | |
22173 | 22173 | 2020-03-31 | Hawaii | Hawaii | 15001 | 15 | 0 |
22174 | 22174 | 2020-03-31 | Honolulu | Hawaii | 15003 | 157 | 1 |
22175 | 22175 | 2020-03-31 | Kauai | Hawaii | 15007 | 12 | 0 |
22176 | 22176 | 2020-03-31 | Maui | Hawaii | 15009 | 25 | 0 |
22177 | 22177 | 2020-03-31 | Unknown | Hawaii | 15 | 0 | |
24339 | 24339 | 2020-04-01 | Hawaii | Hawaii | 15001 | 18 | 0 |
24340 | 24340 | 2020-04-01 | Honolulu | Hawaii | 15003 | 182 | 1 |
24341 | 24341 | 2020-04-01 | Kauai | Hawaii | 15007 | 12 | 0 |
24342 | 24342 | 2020-04-01 | Maui | Hawaii | 15009 | 26 | 0 |
24343 | 24343 | 2020-04-01 | Unknown | Hawaii | 20 | 0 | |
26571 | 26571 | 2020-04-02 | Hawaii | Hawaii | 15001 | 18 | 0 |
26572 | 26572 | 2020-04-02 | Honolulu | Hawaii | 15003 | 206 | 2 |
26573 | 26573 | 2020-04-02 | Kauai | Hawaii | 15007 | 12 | 0 |
26574 | 26574 | 2020-04-02 | Maui | Hawaii | 15009 | 27 | 0 |
26575 | 26575 | 2020-04-02 | Unknown | Hawaii | 20 | 0 | |
28878 | 28878 | 2020-04-03 | Hawaii | Hawaii | 15001 | 20 | 0 |
28879 | 28879 | 2020-04-03 | Honolulu | Hawaii | 15003 | 237 | 2 |
28880 | 28880 | 2020-04-03 | Kauai | Hawaii | 15007 | 13 | 0 |
28881 | 28881 | 2020-04-03 | Maui | Hawaii | 15009 | 36 | 0 |
28882 | 28882 | 2020-04-03 | Unknown | Hawaii | 11 | 1 |
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);