ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 15003 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
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 |
2424 | 2424 | 2020-03-15 | Honolulu | Hawaii | 15003 | 4 | 0 |
2865 | 2865 | 2020-03-16 | Honolulu | Hawaii | 15003 | 6 | 0 |
3353 | 3353 | 2020-03-17 | Honolulu | Hawaii | 15003 | 8 | 0 |
3915 | 3915 | 2020-03-18 | Honolulu | Hawaii | 15003 | 10 | 0 |
4591 | 4591 | 2020-03-19 | Honolulu | Hawaii | 15003 | 18 | 0 |
5391 | 5391 | 2020-03-20 | Honolulu | Hawaii | 15003 | 28 | 0 |
6325 | 6325 | 2020-03-21 | Honolulu | Hawaii | 15003 | 35 | 0 |
7373 | 7373 | 2020-03-22 | Honolulu | Hawaii | 15003 | 41 | 0 |
8527 | 8527 | 2020-03-23 | Honolulu | Hawaii | 15003 | 53 | 0 |
9788 | 9788 | 2020-03-24 | Honolulu | Hawaii | 15003 | 58 | 0 |
11173 | 11173 | 2020-03-25 | Honolulu | Hawaii | 15003 | 68 | 0 |
12726 | 12726 | 2020-03-26 | Honolulu | Hawaii | 15003 | 77 | 0 |
14401 | 14401 | 2020-03-27 | Honolulu | Hawaii | 15003 | 87 | 0 |
16192 | 16192 | 2020-03-28 | Honolulu | Hawaii | 15003 | 108 | 0 |
18089 | 18089 | 2020-03-29 | Honolulu | Hawaii | 15003 | 119 | 0 |
20085 | 20085 | 2020-03-30 | Honolulu | Hawaii | 15003 | 139 | 0 |
22174 | 22174 | 2020-03-31 | Honolulu | Hawaii | 15003 | 157 | 1 |
24340 | 24340 | 2020-04-01 | Honolulu | Hawaii | 15003 | 182 | 1 |
26572 | 26572 | 2020-04-02 | Honolulu | Hawaii | 15003 | 206 | 2 |
28879 | 28879 | 2020-04-03 | Honolulu | Hawaii | 15003 | 237 | 2 |
31240 | 31240 | 2020-04-04 | Honolulu | Hawaii | 15003 | 266 | 2 |
33647 | 33647 | 2020-04-05 | Honolulu | Hawaii | 15003 | 281 | 2 |
36098 | 36098 | 2020-04-06 | Honolulu | Hawaii | 15003 | 292 | 4 |
38591 | 38591 | 2020-04-07 | Honolulu | Hawaii | 15003 | 312 | 4 |
41135 | 41135 | 2020-04-08 | Honolulu | Hawaii | 15003 | 328 | 4 |
43709 | 43709 | 2020-04-09 | Honolulu | Hawaii | 15003 | 334 | 4 |
46311 | 46311 | 2020-04-10 | Honolulu | Hawaii | 15003 | 343 | 5 |
48942 | 48942 | 2020-04-11 | Honolulu | Hawaii | 15003 | 348 | 5 |
51604 | 51604 | 2020-04-12 | Honolulu | Hawaii | 15003 | 350 | 6 |
54284 | 54284 | 2020-04-13 | Honolulu | Hawaii | 15003 | 352 | 6 |
56976 | 56976 | 2020-04-14 | Honolulu | Hawaii | 15003 | 358 | 6 |
59683 | 59683 | 2020-04-15 | Honolulu | Hawaii | 15003 | 369 | 6 |
62403 | 62403 | 2020-04-16 | Honolulu | Hawaii | 15003 | 373 | 6 |
65136 | 65136 | 2020-04-17 | Honolulu | Hawaii | 15003 | 380 | 6 |
67884 | 67884 | 2020-04-18 | Honolulu | Hawaii | 15003 | 382 | 6 |
70646 | 70646 | 2020-04-19 | Honolulu | Hawaii | 15003 | 385 | 6 |
73415 | 73415 | 2020-04-20 | Honolulu | Hawaii | 15003 | 385 | 6 |
76191 | 76191 | 2020-04-21 | Honolulu | Hawaii | 15003 | 385 | 7 |
78975 | 78975 | 2020-04-22 | Honolulu | Hawaii | 15003 | 388 | 7 |
81768 | 81768 | 2020-04-23 | Honolulu | Hawaii | 15003 | 389 | 7 |
84568 | 84568 | 2020-04-24 | Honolulu | Hawaii | 15003 | 392 | 8 |
87377 | 87377 | 2020-04-25 | Honolulu | Hawaii | 15003 | 395 | 9 |
90193 | 90193 | 2020-04-26 | Honolulu | Hawaii | 15003 | 396 | 9 |
93012 | 93012 | 2020-04-27 | Honolulu | Hawaii | 15003 | 396 | 11 |
95844 | 95844 | 2020-04-28 | Honolulu | Hawaii | 15003 | 396 | 11 |
98688 | 98688 | 2020-04-29 | Honolulu | Hawaii | 15003 | 399 | 11 |
101539 | 101539 | 2020-04-30 | Honolulu | Hawaii | 15003 | 399 | 11 |
104394 | 104394 | 2020-05-01 | Honolulu | Hawaii | 15003 | 400 | 11 |
107259 | 107259 | 2020-05-02 | Honolulu | Hawaii | 15003 | 400 | 11 |
110129 | 110129 | 2020-05-03 | Honolulu | Hawaii | 15003 | 400 | 11 |
113004 | 113004 | 2020-05-04 | Honolulu | Hawaii | 15003 | 400 | 11 |
115887 | 115887 | 2020-05-05 | Honolulu | Hawaii | 15003 | 404 | 11 |
118847 | 118847 | 2020-05-06 | Honolulu | Hawaii | 15003 | 405 | 11 |
121817 | 121817 | 2020-05-07 | Honolulu | Hawaii | 15003 | 408 | 11 |
124796 | 124796 | 2020-05-08 | Honolulu | Hawaii | 15003 | 408 | 11 |
127783 | 127783 | 2020-05-09 | Honolulu | Hawaii | 15003 | 407 | 11 |
130774 | 130774 | 2020-05-10 | Honolulu | Hawaii | 15003 | 408 | 11 |
133765 | 133765 | 2020-05-11 | Honolulu | Hawaii | 15003 | 410 | 11 |
136754 | 136754 | 2020-05-12 | Honolulu | Hawaii | 15003 | 411 | 11 |
139745 | 139745 | 2020-05-13 | Honolulu | Hawaii | 15003 | 414 | 11 |
142741 | 142741 | 2020-05-14 | Honolulu | Hawaii | 15003 | 414 | 11 |
145741 | 145741 | 2020-05-15 | Honolulu | Hawaii | 15003 | 414 | 11 |
148744 | 148744 | 2020-05-16 | Honolulu | Hawaii | 15003 | 415 | 11 |
151753 | 151753 | 2020-05-17 | Honolulu | Hawaii | 15003 | 415 | 11 |
154765 | 154765 | 2020-05-18 | Honolulu | Hawaii | 15003 | 415 | 11 |
157781 | 157781 | 2020-05-19 | Honolulu | Hawaii | 15003 | 415 | 11 |
160807 | 160807 | 2020-05-20 | Honolulu | Hawaii | 15003 | 416 | 11 |
163835 | 163835 | 2020-05-21 | Honolulu | Hawaii | 15003 | 416 | 11 |
166868 | 166868 | 2020-05-22 | Honolulu | Hawaii | 15003 | 414 | 11 |
169905 | 169905 | 2020-05-23 | Honolulu | Hawaii | 15003 | 414 | 11 |
172946 | 172946 | 2020-05-24 | Honolulu | Hawaii | 15003 | 414 | 11 |
175989 | 175989 | 2020-05-25 | Honolulu | Hawaii | 15003 | 414 | 11 |
179033 | 179033 | 2020-05-26 | Honolulu | Hawaii | 15003 | 414 | 11 |
182077 | 182077 | 2020-05-27 | Honolulu | Hawaii | 15003 | 414 | 11 |
185131 | 185131 | 2020-05-28 | Honolulu | Hawaii | 15003 | 417 | 11 |
188187 | 188187 | 2020-05-29 | Honolulu | Hawaii | 15003 | 419 | 11 |
191252 | 191252 | 2020-05-30 | Honolulu | Hawaii | 15003 | 421 | 11 |
194319 | 194319 | 2020-05-31 | Honolulu | Hawaii | 15003 | 421 | 11 |
197389 | 197389 | 2020-06-01 | Honolulu | Hawaii | 15003 | 421 | 11 |
200462 | 200462 | 2020-06-02 | Honolulu | Hawaii | 15003 | 422 | 11 |
203538 | 203538 | 2020-06-03 | Honolulu | Hawaii | 15003 | 423 | 11 |
206618 | 206618 | 2020-06-04 | Honolulu | Hawaii | 15003 | 424 | 11 |
209699 | 209699 | 2020-06-05 | Honolulu | Hawaii | 15003 | 431 | 11 |
212784 | 212784 | 2020-06-06 | Honolulu | Hawaii | 15003 | 439 | 11 |
215871 | 215871 | 2020-06-07 | Honolulu | Hawaii | 15003 | 441 | 11 |
218962 | 218962 | 2020-06-08 | Honolulu | Hawaii | 15003 | 442 | 11 |
222057 | 222057 | 2020-06-09 | Honolulu | Hawaii | 15003 | 448 | 11 |
225152 | 225152 | 2020-06-10 | Honolulu | Hawaii | 15003 | 451 | 11 |
228254 | 228254 | 2020-06-11 | Honolulu | Hawaii | 15003 | 458 | 11 |
231357 | 231357 | 2020-06-12 | Honolulu | Hawaii | 15003 | 472 | 11 |
234463 | 234463 | 2020-06-13 | Honolulu | Hawaii | 15003 | 489 | 11 |
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);