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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
state 1
- Hawaii · 3,982 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
3352 | 3352 | 2020-03-17 | Hawaii | Hawaii | 15001 | 1 | 0 |
3914 | 3914 | 2020-03-18 | Hawaii | Hawaii | 15001 | 1 | 0 |
4590 | 4590 | 2020-03-19 | Hawaii | Hawaii | 15001 | 1 | 0 |
5390 | 5390 | 2020-03-20 | Hawaii | Hawaii | 15001 | 1 | 0 |
6324 | 6324 | 2020-03-21 | Hawaii | Hawaii | 15001 | 3 | 0 |
7372 | 7372 | 2020-03-22 | Hawaii | Hawaii | 15001 | 3 | 0 |
8526 | 8526 | 2020-03-23 | Hawaii | Hawaii | 15001 | 5 | 0 |
9787 | 9787 | 2020-03-24 | Hawaii | Hawaii | 15001 | 5 | 0 |
11172 | 11172 | 2020-03-25 | Hawaii | Hawaii | 15001 | 5 | 0 |
12725 | 12725 | 2020-03-26 | Hawaii | Hawaii | 15001 | 5 | 0 |
14400 | 14400 | 2020-03-27 | Hawaii | Hawaii | 15001 | 7 | 0 |
16191 | 16191 | 2020-03-28 | Hawaii | Hawaii | 15001 | 10 | 0 |
18088 | 18088 | 2020-03-29 | Hawaii | Hawaii | 15001 | 12 | 0 |
20084 | 20084 | 2020-03-30 | Hawaii | Hawaii | 15001 | 15 | 0 |
22173 | 22173 | 2020-03-31 | Hawaii | Hawaii | 15001 | 15 | 0 |
24339 | 24339 | 2020-04-01 | Hawaii | Hawaii | 15001 | 18 | 0 |
26571 | 26571 | 2020-04-02 | Hawaii | Hawaii | 15001 | 18 | 0 |
28878 | 28878 | 2020-04-03 | Hawaii | Hawaii | 15001 | 20 | 0 |
31239 | 31239 | 2020-04-04 | Hawaii | Hawaii | 15001 | 22 | 0 |
33646 | 33646 | 2020-04-05 | Hawaii | Hawaii | 15001 | 22 | 0 |
36097 | 36097 | 2020-04-06 | Hawaii | Hawaii | 15001 | 23 | 0 |
38590 | 38590 | 2020-04-07 | Hawaii | Hawaii | 15001 | 23 | 0 |
41134 | 41134 | 2020-04-08 | Hawaii | Hawaii | 15001 | 26 | 0 |
43708 | 43708 | 2020-04-09 | Hawaii | Hawaii | 15001 | 28 | 0 |
46310 | 46310 | 2020-04-10 | Hawaii | Hawaii | 15001 | 31 | 0 |
48941 | 48941 | 2020-04-11 | Hawaii | Hawaii | 15001 | 34 | 0 |
51603 | 51603 | 2020-04-12 | Hawaii | Hawaii | 15001 | 39 | 0 |
54283 | 54283 | 2020-04-13 | Hawaii | Hawaii | 15001 | 40 | 0 |
56975 | 56975 | 2020-04-14 | Hawaii | Hawaii | 15001 | 41 | 0 |
59682 | 59682 | 2020-04-15 | Hawaii | Hawaii | 15001 | 41 | 0 |
62402 | 62402 | 2020-04-16 | Hawaii | Hawaii | 15001 | 41 | 0 |
65135 | 65135 | 2020-04-17 | Hawaii | Hawaii | 15001 | 44 | 0 |
67883 | 67883 | 2020-04-18 | Hawaii | Hawaii | 15001 | 61 | 0 |
70645 | 70645 | 2020-04-19 | Hawaii | Hawaii | 15001 | 62 | 0 |
73414 | 73414 | 2020-04-20 | Hawaii | Hawaii | 15001 | 64 | 0 |
76190 | 76190 | 2020-04-21 | Hawaii | Hawaii | 15001 | 64 | 0 |
78974 | 78974 | 2020-04-22 | Hawaii | Hawaii | 15001 | 67 | 0 |
81767 | 81767 | 2020-04-23 | Hawaii | Hawaii | 15001 | 68 | 0 |
84567 | 84567 | 2020-04-24 | Hawaii | Hawaii | 15001 | 69 | 0 |
87376 | 87376 | 2020-04-25 | Hawaii | Hawaii | 15001 | 69 | 0 |
90192 | 90192 | 2020-04-26 | Hawaii | Hawaii | 15001 | 70 | 0 |
93011 | 93011 | 2020-04-27 | Hawaii | Hawaii | 15001 | 70 | 0 |
95843 | 95843 | 2020-04-28 | Hawaii | Hawaii | 15001 | 70 | 0 |
98687 | 98687 | 2020-04-29 | Hawaii | Hawaii | 15001 | 70 | 0 |
101538 | 101538 | 2020-04-30 | Hawaii | Hawaii | 15001 | 73 | 0 |
104393 | 104393 | 2020-05-01 | Hawaii | Hawaii | 15001 | 73 | 0 |
107258 | 107258 | 2020-05-02 | Hawaii | Hawaii | 15001 | 73 | 0 |
110128 | 110128 | 2020-05-03 | Hawaii | Hawaii | 15001 | 74 | 0 |
113003 | 113003 | 2020-05-04 | Hawaii | Hawaii | 15001 | 75 | 0 |
115886 | 115886 | 2020-05-05 | Hawaii | Hawaii | 15001 | 74 | 0 |
118846 | 118846 | 2020-05-06 | Hawaii | Hawaii | 15001 | 74 | 0 |
121816 | 121816 | 2020-05-07 | Hawaii | Hawaii | 15001 | 74 | 0 |
124795 | 124795 | 2020-05-08 | Hawaii | Hawaii | 15001 | 74 | 0 |
127782 | 127782 | 2020-05-09 | Hawaii | Hawaii | 15001 | 75 | 0 |
130773 | 130773 | 2020-05-10 | Hawaii | Hawaii | 15001 | 75 | 0 |
133764 | 133764 | 2020-05-11 | Hawaii | Hawaii | 15001 | 75 | 0 |
136753 | 136753 | 2020-05-12 | Hawaii | Hawaii | 15001 | 75 | 0 |
139744 | 139744 | 2020-05-13 | Hawaii | Hawaii | 15001 | 75 | 0 |
142740 | 142740 | 2020-05-14 | Hawaii | Hawaii | 15001 | 75 | 0 |
145740 | 145740 | 2020-05-15 | Hawaii | Hawaii | 15001 | 76 | 0 |
148743 | 148743 | 2020-05-16 | Hawaii | Hawaii | 15001 | 76 | 0 |
151752 | 151752 | 2020-05-17 | Hawaii | Hawaii | 15001 | 77 | 0 |
154764 | 154764 | 2020-05-18 | Hawaii | Hawaii | 15001 | 77 | 0 |
157780 | 157780 | 2020-05-19 | Hawaii | Hawaii | 15001 | 78 | 0 |
160806 | 160806 | 2020-05-20 | Hawaii | Hawaii | 15001 | 79 | 0 |
163834 | 163834 | 2020-05-21 | Hawaii | Hawaii | 15001 | 82 | 0 |
166867 | 166867 | 2020-05-22 | Hawaii | Hawaii | 15001 | 81 | 0 |
169904 | 169904 | 2020-05-23 | Hawaii | Hawaii | 15001 | 81 | 0 |
172945 | 172945 | 2020-05-24 | Hawaii | Hawaii | 15001 | 81 | 0 |
175988 | 175988 | 2020-05-25 | Hawaii | Hawaii | 15001 | 81 | 0 |
179032 | 179032 | 2020-05-26 | Hawaii | Hawaii | 15001 | 81 | 0 |
182076 | 182076 | 2020-05-27 | Hawaii | Hawaii | 15001 | 82 | 0 |
185130 | 185130 | 2020-05-28 | Hawaii | Hawaii | 15001 | 82 | 0 |
188186 | 188186 | 2020-05-29 | Hawaii | Hawaii | 15001 | 82 | 0 |
191251 | 191251 | 2020-05-30 | Hawaii | Hawaii | 15001 | 81 | 0 |
194318 | 194318 | 2020-05-31 | Hawaii | Hawaii | 15001 | 81 | 0 |
197388 | 197388 | 2020-06-01 | Hawaii | Hawaii | 15001 | 81 | 0 |
200461 | 200461 | 2020-06-02 | Hawaii | Hawaii | 15001 | 81 | 0 |
203537 | 203537 | 2020-06-03 | Hawaii | Hawaii | 15001 | 81 | 0 |
206617 | 206617 | 2020-06-04 | Hawaii | Hawaii | 15001 | 81 | 0 |
209698 | 209698 | 2020-06-05 | Hawaii | Hawaii | 15001 | 81 | 0 |
212783 | 212783 | 2020-06-06 | Hawaii | Hawaii | 15001 | 81 | 0 |
215870 | 215870 | 2020-06-07 | Hawaii | Hawaii | 15001 | 81 | 0 |
218961 | 218961 | 2020-06-08 | Hawaii | Hawaii | 15001 | 81 | 0 |
222056 | 222056 | 2020-06-09 | Hawaii | Hawaii | 15001 | 81 | 0 |
225151 | 225151 | 2020-06-10 | Hawaii | Hawaii | 15001 | 81 | 0 |
228253 | 228253 | 2020-06-11 | Hawaii | Hawaii | 15001 | 81 | 0 |
231356 | 231356 | 2020-06-12 | Hawaii | Hawaii | 15001 | 81 | 0 |
234462 | 234462 | 2020-06-13 | Hawaii | Hawaii | 15001 | 81 | 0 |
237569 | 237569 | 2020-06-14 | Hawaii | Hawaii | 15001 | 82 | 0 |
240677 | 240677 | 2020-06-15 | Hawaii | Hawaii | 15001 | 82 | 0 |
243788 | 243788 | 2020-06-16 | Hawaii | Hawaii | 15001 | 82 | 0 |
246901 | 246901 | 2020-06-17 | Hawaii | Hawaii | 15001 | 83 | 0 |
250013 | 250013 | 2020-06-18 | Hawaii | Hawaii | 15001 | 83 | 0 |
253128 | 253128 | 2020-06-19 | Hawaii | Hawaii | 15001 | 83 | 0 |
256247 | 256247 | 2020-06-20 | Hawaii | Hawaii | 15001 | 83 | 0 |
259374 | 259374 | 2020-06-21 | Hawaii | Hawaii | 15001 | 85 | 0 |
262501 | 262501 | 2020-06-22 | Hawaii | Hawaii | 15001 | 85 | 0 |
265629 | 265629 | 2020-06-23 | Hawaii | Hawaii | 15001 | 85 | 0 |
268759 | 268759 | 2020-06-24 | Hawaii | Hawaii | 15001 | 86 | 0 |
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);