ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Washington" and fips = 49053 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
646 | 646 | 2020-03-06 | Washington | Utah | 49053 | 1 | 0 |
738 | 738 | 2020-03-07 | Washington | Utah | 49053 | 1 | 0 |
850 | 850 | 2020-03-08 | Washington | Utah | 49053 | 1 | 0 |
980 | 980 | 2020-03-09 | Washington | Utah | 49053 | 1 | 0 |
1141 | 1141 | 2020-03-10 | Washington | Utah | 49053 | 1 | 0 |
1338 | 1338 | 2020-03-11 | Washington | Utah | 49053 | 1 | 0 |
1585 | 1585 | 2020-03-12 | Washington | Utah | 49053 | 1 | 0 |
1894 | 1894 | 2020-03-13 | Washington | Utah | 49053 | 1 | 0 |
2262 | 2262 | 2020-03-14 | Washington | Utah | 49053 | 1 | 0 |
2689 | 2689 | 2020-03-15 | Washington | Utah | 49053 | 1 | 0 |
3160 | 3160 | 2020-03-16 | Washington | Utah | 49053 | 1 | 0 |
3696 | 3696 | 2020-03-17 | Washington | Utah | 49053 | 1 | 0 |
4328 | 4328 | 2020-03-18 | Washington | Utah | 49053 | 1 | 0 |
5084 | 5084 | 2020-03-19 | Washington | Utah | 49053 | 1 | 0 |
5978 | 5978 | 2020-03-20 | Washington | Utah | 49053 | 1 | 0 |
7001 | 7001 | 2020-03-21 | Washington | Utah | 49053 | 2 | 0 |
8131 | 8131 | 2020-03-22 | Washington | Utah | 49053 | 2 | 0 |
9351 | 9351 | 2020-03-23 | Washington | Utah | 49053 | 4 | 0 |
10695 | 10695 | 2020-03-24 | Washington | Utah | 49053 | 4 | 0 |
12206 | 12206 | 2020-03-25 | Washington | Utah | 49053 | 6 | 0 |
13842 | 13842 | 2020-03-26 | Washington | Utah | 49053 | 6 | 0 |
15608 | 15608 | 2020-03-27 | Washington | Utah | 49053 | 6 | 0 |
17482 | 17482 | 2020-03-28 | Washington | Utah | 49053 | 8 | 0 |
19441 | 19441 | 2020-03-29 | Washington | Utah | 49053 | 8 | 0 |
21504 | 21504 | 2020-03-30 | Washington | Utah | 49053 | 8 | 0 |
23643 | 23643 | 2020-03-31 | Washington | Utah | 49053 | 14 | 0 |
25858 | 25858 | 2020-04-01 | Washington | Utah | 49053 | 14 | 0 |
28147 | 28147 | 2020-04-02 | Washington | Utah | 49053 | 19 | 0 |
30490 | 30490 | 2020-04-03 | Washington | Utah | 49053 | 21 | 0 |
32888 | 32888 | 2020-04-04 | Washington | Utah | 49053 | 21 | 0 |
35326 | 35326 | 2020-04-05 | Washington | Utah | 49053 | 24 | 0 |
37804 | 37804 | 2020-04-06 | Washington | Utah | 49053 | 24 | 0 |
40333 | 40333 | 2020-04-07 | Washington | Utah | 49053 | 26 | 0 |
42901 | 42901 | 2020-04-08 | Washington | Utah | 49053 | 27 | 0 |
45495 | 45495 | 2020-04-09 | Washington | Utah | 49053 | 31 | 0 |
48119 | 48119 | 2020-04-10 | Washington | Utah | 49053 | 35 | 0 |
50777 | 50777 | 2020-04-11 | Washington | Utah | 49053 | 35 | 0 |
53452 | 53452 | 2020-04-12 | Washington | Utah | 49053 | 36 | 0 |
56141 | 56141 | 2020-04-13 | Washington | Utah | 49053 | 36 | 0 |
58847 | 58847 | 2020-04-14 | Washington | Utah | 49053 | 39 | 0 |
61566 | 61566 | 2020-04-15 | Washington | Utah | 49053 | 39 | 0 |
64298 | 64298 | 2020-04-16 | Washington | Utah | 49053 | 39 | 0 |
67046 | 67046 | 2020-04-17 | Washington | Utah | 49053 | 41 | 0 |
69808 | 69808 | 2020-04-18 | Washington | Utah | 49053 | 44 | 0 |
72578 | 72578 | 2020-04-19 | Washington | Utah | 49053 | 44 | 0 |
75354 | 75354 | 2020-04-20 | Washington | Utah | 49053 | 45 | 0 |
78136 | 78136 | 2020-04-21 | Washington | Utah | 49053 | 48 | 0 |
80928 | 80928 | 2020-04-22 | Washington | Utah | 49053 | 48 | 0 |
83729 | 83729 | 2020-04-23 | Washington | Utah | 49053 | 51 | 0 |
86536 | 86536 | 2020-04-24 | Washington | Utah | 49053 | 51 | 0 |
89351 | 89351 | 2020-04-25 | Washington | Utah | 49053 | 58 | 0 |
92168 | 92168 | 2020-04-26 | Washington | Utah | 49053 | 62 | 0 |
94997 | 94997 | 2020-04-27 | Washington | Utah | 49053 | 62 | 0 |
97839 | 97839 | 2020-04-28 | Washington | Utah | 49053 | 62 | 0 |
100689 | 100689 | 2020-04-29 | Washington | Utah | 49053 | 65 | 0 |
103544 | 103544 | 2020-04-30 | Washington | Utah | 49053 | 65 | 0 |
106408 | 106408 | 2020-05-01 | Washington | Utah | 49053 | 68 | 0 |
109277 | 109277 | 2020-05-02 | Washington | Utah | 49053 | 71 | 0 |
112151 | 112151 | 2020-05-03 | Washington | Utah | 49053 | 72 | 0 |
115034 | 115034 | 2020-05-04 | Washington | Utah | 49053 | 85 | 0 |
117993 | 117993 | 2020-05-05 | Washington | Utah | 49053 | 85 | 0 |
120957 | 120957 | 2020-05-06 | Washington | Utah | 49053 | 95 | 0 |
123938 | 123938 | 2020-05-07 | Washington | Utah | 49053 | 95 | 0 |
126923 | 126923 | 2020-05-08 | Washington | Utah | 49053 | 95 | 0 |
129912 | 129912 | 2020-05-09 | Washington | Utah | 49053 | 103 | 0 |
132902 | 132902 | 2020-05-10 | Washington | Utah | 49053 | 120 | 0 |
135892 | 135892 | 2020-05-11 | Washington | Utah | 49053 | 125 | 0 |
138883 | 138883 | 2020-05-12 | Washington | Utah | 49053 | 136 | 0 |
141879 | 141879 | 2020-05-13 | Washington | Utah | 49053 | 145 | 0 |
144876 | 144876 | 2020-05-14 | Washington | Utah | 49053 | 152 | 0 |
147879 | 147879 | 2020-05-15 | Washington | Utah | 49053 | 165 | 0 |
150888 | 150888 | 2020-05-16 | Washington | Utah | 49053 | 173 | 0 |
153899 | 153899 | 2020-05-17 | Washington | Utah | 49053 | 182 | 0 |
156916 | 156916 | 2020-05-18 | Washington | Utah | 49053 | 198 | 0 |
159940 | 159940 | 2020-05-19 | Washington | Utah | 49053 | 214 | 0 |
162968 | 162968 | 2020-05-20 | Washington | Utah | 49053 | 218 | 0 |
165997 | 165997 | 2020-05-21 | Washington | Utah | 49053 | 226 | 0 |
169033 | 169033 | 2020-05-22 | Washington | Utah | 49053 | 235 | 0 |
172074 | 172074 | 2020-05-23 | Washington | Utah | 49053 | 247 | 0 |
175117 | 175117 | 2020-05-24 | Washington | Utah | 49053 | 247 | 0 |
178162 | 178162 | 2020-05-25 | Washington | Utah | 49053 | 274 | 0 |
181206 | 181206 | 2020-05-26 | Washington | Utah | 49053 | 279 | 0 |
184257 | 184257 | 2020-05-27 | Washington | Utah | 49053 | 283 | 0 |
187314 | 187314 | 2020-05-28 | Washington | Utah | 49053 | 304 | 0 |
190378 | 190378 | 2020-05-29 | Washington | Utah | 49053 | 324 | 0 |
193444 | 193444 | 2020-05-30 | Washington | Utah | 49053 | 357 | 0 |
196514 | 196514 | 2020-05-31 | Washington | Utah | 49053 | 365 | 0 |
199587 | 199587 | 2020-06-01 | Washington | Utah | 49053 | 374 | 0 |
202663 | 202663 | 2020-06-02 | Washington | Utah | 49053 | 388 | 0 |
205742 | 205742 | 2020-06-03 | Washington | Utah | 49053 | 400 | 0 |
208824 | 208824 | 2020-06-04 | Washington | Utah | 49053 | 410 | 0 |
211909 | 211909 | 2020-06-05 | Washington | Utah | 49053 | 435 | 0 |
214996 | 214996 | 2020-06-06 | Washington | Utah | 49053 | 455 | 0 |
218086 | 218086 | 2020-06-07 | Washington | Utah | 49053 | 455 | 0 |
221178 | 221178 | 2020-06-08 | Washington | Utah | 49053 | 492 | 0 |
224274 | 224274 | 2020-06-09 | Washington | Utah | 49053 | 511 | 0 |
227374 | 227374 | 2020-06-10 | Washington | Utah | 49053 | 532 | 0 |
230478 | 230478 | 2020-06-11 | Washington | Utah | 49053 | 565 | 0 |
233583 | 233583 | 2020-06-12 | Washington | Utah | 49053 | 578 | 0 |
236690 | 236690 | 2020-06-13 | Washington | Utah | 49053 | 604 | 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);