ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Franklin" and state = "Washington" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3725 | 3725 | 2020-03-17 | Franklin | Washington | 53021 | 1 | 0 |
4360 | 4360 | 2020-03-18 | Franklin | Washington | 53021 | 1 | 0 |
5117 | 5117 | 2020-03-19 | Franklin | Washington | 53021 | 1 | 0 |
6019 | 6019 | 2020-03-20 | Franklin | Washington | 53021 | 1 | 0 |
7050 | 7050 | 2020-03-21 | Franklin | Washington | 53021 | 1 | 0 |
8187 | 8187 | 2020-03-22 | Franklin | Washington | 53021 | 2 | 0 |
9412 | 9412 | 2020-03-23 | Franklin | Washington | 53021 | 2 | 0 |
10761 | 10761 | 2020-03-24 | Franklin | Washington | 53021 | 7 | 0 |
12284 | 12284 | 2020-03-25 | Franklin | Washington | 53021 | 7 | 0 |
13934 | 13934 | 2020-03-26 | Franklin | Washington | 53021 | 7 | 0 |
15702 | 15702 | 2020-03-27 | Franklin | Washington | 53021 | 12 | 0 |
17582 | 17582 | 2020-03-28 | Franklin | Washington | 53021 | 16 | 0 |
19547 | 19547 | 2020-03-29 | Franklin | Washington | 53021 | 32 | 0 |
21614 | 21614 | 2020-03-30 | Franklin | Washington | 53021 | 32 | 0 |
23763 | 23763 | 2020-03-31 | Franklin | Washington | 53021 | 33 | 0 |
25981 | 25981 | 2020-04-01 | Franklin | Washington | 53021 | 33 | 0 |
28271 | 28271 | 2020-04-02 | Franklin | Washington | 53021 | 43 | 0 |
30624 | 30624 | 2020-04-03 | Franklin | Washington | 53021 | 45 | 1 |
33024 | 33024 | 2020-04-04 | Franklin | Washington | 53021 | 49 | 1 |
35462 | 35462 | 2020-04-05 | Franklin | Washington | 53021 | 59 | 2 |
37946 | 37946 | 2020-04-06 | Franklin | Washington | 53021 | 64 | 1 |
40481 | 40481 | 2020-04-07 | Franklin | Washington | 53021 | 75 | 2 |
43050 | 43050 | 2020-04-08 | Franklin | Washington | 53021 | 75 | 2 |
45646 | 45646 | 2020-04-09 | Franklin | Washington | 53021 | 93 | 2 |
48273 | 48273 | 2020-04-10 | Franklin | Washington | 53021 | 107 | 2 |
50931 | 50931 | 2020-04-11 | Franklin | Washington | 53021 | 112 | 2 |
53606 | 53606 | 2020-04-12 | Franklin | Washington | 53021 | 120 | 2 |
56296 | 56296 | 2020-04-13 | Franklin | Washington | 53021 | 129 | 2 |
59002 | 59002 | 2020-04-14 | Franklin | Washington | 53021 | 138 | 2 |
61721 | 61721 | 2020-04-15 | Franklin | Washington | 53021 | 142 | 4 |
64454 | 64454 | 2020-04-16 | Franklin | Washington | 53021 | 156 | 2 |
67202 | 67202 | 2020-04-17 | Franklin | Washington | 53021 | 167 | 4 |
69964 | 69964 | 2020-04-18 | Franklin | Washington | 53021 | 177 | 4 |
72734 | 72734 | 2020-04-19 | Franklin | Washington | 53021 | 187 | 4 |
75510 | 75510 | 2020-04-20 | Franklin | Washington | 53021 | 198 | 4 |
78293 | 78293 | 2020-04-21 | Franklin | Washington | 53021 | 207 | 4 |
81086 | 81086 | 2020-04-22 | Franklin | Washington | 53021 | 212 | 4 |
83887 | 83887 | 2020-04-23 | Franklin | Washington | 53021 | 233 | 5 |
86694 | 86694 | 2020-04-24 | Franklin | Washington | 53021 | 242 | 5 |
89509 | 89509 | 2020-04-25 | Franklin | Washington | 53021 | 250 | 5 |
92326 | 92326 | 2020-04-26 | Franklin | Washington | 53021 | 251 | 5 |
95155 | 95155 | 2020-04-27 | Franklin | Washington | 53021 | 259 | 5 |
98000 | 98000 | 2020-04-28 | Franklin | Washington | 53021 | 265 | 7 |
100850 | 100850 | 2020-04-29 | Franklin | Washington | 53021 | 276 | 8 |
103705 | 103705 | 2020-04-30 | Franklin | Washington | 53021 | 279 | 9 |
106569 | 106569 | 2020-05-01 | Franklin | Washington | 53021 | 309 | 11 |
109438 | 109438 | 2020-05-02 | Franklin | Washington | 53021 | 348 | 10 |
112312 | 112312 | 2020-05-03 | Franklin | Washington | 53021 | 363 | 11 |
115195 | 115195 | 2020-05-04 | Franklin | Washington | 53021 | 377 | 11 |
118154 | 118154 | 2020-05-05 | Franklin | Washington | 53021 | 379 | 13 |
121118 | 121118 | 2020-05-06 | Franklin | Washington | 53021 | 487 | 14 |
124098 | 124098 | 2020-05-07 | Franklin | Washington | 53021 | 501 | 14 |
127083 | 127083 | 2020-05-08 | Franklin | Washington | 53021 | 507 | 16 |
130073 | 130073 | 2020-05-09 | Franklin | Washington | 53021 | 513 | 16 |
133063 | 133063 | 2020-05-10 | Franklin | Washington | 53021 | 516 | 16 |
136053 | 136053 | 2020-05-11 | Franklin | Washington | 53021 | 525 | 16 |
139044 | 139044 | 2020-05-12 | Franklin | Washington | 53021 | 530 | 16 |
142040 | 142040 | 2020-05-13 | Franklin | Washington | 53021 | 531 | 16 |
145037 | 145037 | 2020-05-14 | Franklin | Washington | 53021 | 544 | 17 |
148040 | 148040 | 2020-05-15 | Franklin | Washington | 53021 | 552 | 17 |
151049 | 151049 | 2020-05-16 | Franklin | Washington | 53021 | 564 | 17 |
154060 | 154060 | 2020-05-17 | Franklin | Washington | 53021 | 572 | 17 |
157077 | 157077 | 2020-05-18 | Franklin | Washington | 53021 | 577 | 17 |
160101 | 160101 | 2020-05-19 | Franklin | Washington | 53021 | 587 | 18 |
163129 | 163129 | 2020-05-20 | Franklin | Washington | 53021 | 593 | 18 |
166158 | 166158 | 2020-05-21 | Franklin | Washington | 53021 | 605 | 18 |
169194 | 169194 | 2020-05-22 | Franklin | Washington | 53021 | 612 | 18 |
172235 | 172235 | 2020-05-23 | Franklin | Washington | 53021 | 612 | 19 |
175278 | 175278 | 2020-05-24 | Franklin | Washington | 53021 | 612 | 19 |
178323 | 178323 | 2020-05-25 | Franklin | Washington | 53021 | 641 | 19 |
181367 | 181367 | 2020-05-26 | Franklin | Washington | 53021 | 649 | 19 |
184418 | 184418 | 2020-05-27 | Franklin | Washington | 53021 | 661 | 20 |
187475 | 187475 | 2020-05-28 | Franklin | Washington | 53021 | 668 | 20 |
190539 | 190539 | 2020-05-29 | Franklin | Washington | 53021 | 694 | 20 |
193605 | 193605 | 2020-05-30 | Franklin | Washington | 53021 | 694 | 20 |
196675 | 196675 | 2020-05-31 | Franklin | Washington | 53021 | 704 | 20 |
199748 | 199748 | 2020-06-01 | Franklin | Washington | 53021 | 760 | 20 |
202824 | 202824 | 2020-06-02 | Franklin | Washington | 53021 | 786 | 20 |
205903 | 205903 | 2020-06-03 | Franklin | Washington | 53021 | 800 | 20 |
208985 | 208985 | 2020-06-04 | Franklin | Washington | 53021 | 834 | 20 |
212070 | 212070 | 2020-06-05 | Franklin | Washington | 53021 | 855 | 21 |
215157 | 215157 | 2020-06-06 | Franklin | Washington | 53021 | 855 | 21 |
218247 | 218247 | 2020-06-07 | Franklin | Washington | 53021 | 859 | 21 |
221339 | 221339 | 2020-06-08 | Franklin | Washington | 53021 | 943 | 21 |
224435 | 224435 | 2020-06-09 | Franklin | Washington | 53021 | 956 | 22 |
227535 | 227535 | 2020-06-10 | Franklin | Washington | 53021 | 979 | 22 |
230639 | 230639 | 2020-06-11 | Franklin | Washington | 53021 | 1008 | 25 |
233744 | 233744 | 2020-06-12 | Franklin | Washington | 53021 | 1034 | 25 |
236851 | 236851 | 2020-06-13 | Franklin | Washington | 53021 | 1034 | 25 |
239959 | 239959 | 2020-06-14 | Franklin | Washington | 53021 | 1034 | 25 |
243070 | 243070 | 2020-06-15 | Franklin | Washington | 53021 | 1083 | 26 |
246183 | 246183 | 2020-06-16 | Franklin | Washington | 53021 | 1144 | 26 |
249295 | 249295 | 2020-06-17 | Franklin | Washington | 53021 | 1180 | 26 |
252410 | 252410 | 2020-06-18 | Franklin | Washington | 53021 | 1218 | 28 |
255529 | 255529 | 2020-06-19 | Franklin | Washington | 53021 | 1264 | 29 |
258656 | 258656 | 2020-06-20 | Franklin | Washington | 53021 | 1264 | 29 |
261783 | 261783 | 2020-06-21 | Franklin | Washington | 53021 | 1278 | 29 |
264912 | 264912 | 2020-06-22 | Franklin | Washington | 53021 | 1450 | 29 |
268041 | 268041 | 2020-06-23 | Franklin | Washington | 53021 | 1450 | 30 |
271175 | 271175 | 2020-06-24 | Franklin | Washington | 53021 | 1540 | 31 |
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);