ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Washington" and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388812 | 388812 | 2020-07-31 | Washington | Utah | 49053 | 2274 | 20 |
385595 | 385595 | 2020-07-30 | Washington | Utah | 49053 | 2233 | 20 |
382377 | 382377 | 2020-07-29 | Washington | Utah | 49053 | 2215 | 20 |
379160 | 379160 | 2020-07-28 | Washington | Utah | 49053 | 2209 | 20 |
375944 | 375944 | 2020-07-27 | Washington | Utah | 49053 | 2186 | 19 |
372731 | 372731 | 2020-07-26 | Washington | Utah | 49053 | 2151 | 18 |
369519 | 369519 | 2020-07-25 | Washington | Utah | 49053 | 2151 | 18 |
366310 | 366310 | 2020-07-24 | Washington | Utah | 49053 | 2106 | 18 |
363104 | 363104 | 2020-07-23 | Washington | Utah | 49053 | 2046 | 17 |
359897 | 359897 | 2020-07-22 | Washington | Utah | 49053 | 2007 | 17 |
356692 | 356692 | 2020-07-21 | Washington | Utah | 49053 | 1954 | 17 |
353489 | 353489 | 2020-07-20 | Washington | Utah | 49053 | 1905 | 17 |
350287 | 350287 | 2020-07-19 | Washington | Utah | 49053 | 1842 | 17 |
347086 | 347086 | 2020-07-18 | Washington | Utah | 49053 | 1842 | 17 |
343886 | 343886 | 2020-07-17 | Washington | Utah | 49053 | 1799 | 15 |
340687 | 340687 | 2020-07-16 | Washington | Utah | 49053 | 1750 | 7 |
337491 | 337491 | 2020-07-15 | Washington | Utah | 49053 | 1709 | 7 |
334296 | 334296 | 2020-07-14 | Washington | Utah | 49053 | 1701 | 7 |
331103 | 331103 | 2020-07-13 | Washington | Utah | 49053 | 1671 | 7 |
327917 | 327917 | 2020-07-12 | Washington | Utah | 49053 | 1588 | 0 |
324732 | 324732 | 2020-07-11 | Washington | Utah | 49053 | 1588 | 0 |
321551 | 321551 | 2020-07-10 | Washington | Utah | 49053 | 1545 | 0 |
318372 | 318372 | 2020-07-09 | Washington | Utah | 49053 | 1494 | 0 |
315199 | 315199 | 2020-07-08 | Washington | Utah | 49053 | 1460 | 0 |
312025 | 312025 | 2020-07-07 | Washington | Utah | 49053 | 1428 | 0 |
308856 | 308856 | 2020-07-06 | Washington | Utah | 49053 | 1361 | 0 |
305688 | 305688 | 2020-07-05 | Washington | Utah | 49053 | 1304 | 0 |
302524 | 302524 | 2020-07-04 | Washington | Utah | 49053 | 1304 | 0 |
299360 | 299360 | 2020-07-03 | Washington | Utah | 49053 | 1280 | 0 |
296198 | 296198 | 2020-07-02 | Washington | Utah | 49053 | 1245 | 0 |
293043 | 293043 | 2020-07-01 | Washington | Utah | 49053 | 1228 | 0 |
289890 | 289890 | 2020-06-30 | Washington | Utah | 49053 | 1198 | 0 |
286740 | 286740 | 2020-06-29 | Washington | Utah | 49053 | 1156 | 0 |
283594 | 283594 | 2020-06-28 | Washington | Utah | 49053 | 1063 | 0 |
280448 | 280448 | 2020-06-27 | Washington | Utah | 49053 | 1063 | 0 |
277300 | 277300 | 2020-06-26 | Washington | Utah | 49053 | 1011 | 0 |
274152 | 274152 | 2020-06-25 | Washington | Utah | 49053 | 977 | 0 |
271012 | 271012 | 2020-06-24 | Washington | Utah | 49053 | 936 | 0 |
267878 | 267878 | 2020-06-23 | Washington | Utah | 49053 | 899 | 0 |
264749 | 264749 | 2020-06-22 | Washington | Utah | 49053 | 864 | 0 |
261620 | 261620 | 2020-06-21 | Washington | Utah | 49053 | 806 | 0 |
258493 | 258493 | 2020-06-20 | Washington | Utah | 49053 | 806 | 0 |
255366 | 255366 | 2020-06-19 | Washington | Utah | 49053 | 767 | 0 |
252248 | 252248 | 2020-06-18 | Washington | Utah | 49053 | 716 | 0 |
249133 | 249133 | 2020-06-17 | Washington | Utah | 49053 | 689 | 0 |
246021 | 246021 | 2020-06-16 | Washington | Utah | 49053 | 663 | 0 |
242909 | 242909 | 2020-06-15 | Washington | Utah | 49053 | 640 | 0 |
239798 | 239798 | 2020-06-14 | Washington | Utah | 49053 | 604 | 0 |
236690 | 236690 | 2020-06-13 | Washington | Utah | 49053 | 604 | 0 |
233583 | 233583 | 2020-06-12 | Washington | Utah | 49053 | 578 | 0 |
230478 | 230478 | 2020-06-11 | Washington | Utah | 49053 | 565 | 0 |
227374 | 227374 | 2020-06-10 | Washington | Utah | 49053 | 532 | 0 |
224274 | 224274 | 2020-06-09 | Washington | Utah | 49053 | 511 | 0 |
221178 | 221178 | 2020-06-08 | Washington | Utah | 49053 | 492 | 0 |
218086 | 218086 | 2020-06-07 | Washington | Utah | 49053 | 455 | 0 |
214996 | 214996 | 2020-06-06 | Washington | Utah | 49053 | 455 | 0 |
211909 | 211909 | 2020-06-05 | Washington | Utah | 49053 | 435 | 0 |
208824 | 208824 | 2020-06-04 | Washington | Utah | 49053 | 410 | 0 |
205742 | 205742 | 2020-06-03 | Washington | Utah | 49053 | 400 | 0 |
202663 | 202663 | 2020-06-02 | Washington | Utah | 49053 | 388 | 0 |
199587 | 199587 | 2020-06-01 | Washington | Utah | 49053 | 374 | 0 |
196514 | 196514 | 2020-05-31 | Washington | Utah | 49053 | 365 | 0 |
193444 | 193444 | 2020-05-30 | Washington | Utah | 49053 | 357 | 0 |
190378 | 190378 | 2020-05-29 | Washington | Utah | 49053 | 324 | 0 |
187314 | 187314 | 2020-05-28 | Washington | Utah | 49053 | 304 | 0 |
184257 | 184257 | 2020-05-27 | Washington | Utah | 49053 | 283 | 0 |
181206 | 181206 | 2020-05-26 | Washington | Utah | 49053 | 279 | 0 |
178162 | 178162 | 2020-05-25 | Washington | Utah | 49053 | 274 | 0 |
175117 | 175117 | 2020-05-24 | Washington | Utah | 49053 | 247 | 0 |
172074 | 172074 | 2020-05-23 | Washington | Utah | 49053 | 247 | 0 |
169033 | 169033 | 2020-05-22 | Washington | Utah | 49053 | 235 | 0 |
165997 | 165997 | 2020-05-21 | Washington | Utah | 49053 | 226 | 0 |
162968 | 162968 | 2020-05-20 | Washington | Utah | 49053 | 218 | 0 |
159940 | 159940 | 2020-05-19 | Washington | Utah | 49053 | 214 | 0 |
156916 | 156916 | 2020-05-18 | Washington | Utah | 49053 | 198 | 0 |
153899 | 153899 | 2020-05-17 | Washington | Utah | 49053 | 182 | 0 |
150888 | 150888 | 2020-05-16 | Washington | Utah | 49053 | 173 | 0 |
147879 | 147879 | 2020-05-15 | Washington | Utah | 49053 | 165 | 0 |
144876 | 144876 | 2020-05-14 | Washington | Utah | 49053 | 152 | 0 |
141879 | 141879 | 2020-05-13 | Washington | Utah | 49053 | 145 | 0 |
138883 | 138883 | 2020-05-12 | Washington | Utah | 49053 | 136 | 0 |
135892 | 135892 | 2020-05-11 | Washington | Utah | 49053 | 125 | 0 |
132902 | 132902 | 2020-05-10 | Washington | Utah | 49053 | 120 | 0 |
129912 | 129912 | 2020-05-09 | Washington | Utah | 49053 | 103 | 0 |
126923 | 126923 | 2020-05-08 | Washington | Utah | 49053 | 95 | 0 |
123938 | 123938 | 2020-05-07 | Washington | Utah | 49053 | 95 | 0 |
120957 | 120957 | 2020-05-06 | Washington | Utah | 49053 | 95 | 0 |
117993 | 117993 | 2020-05-05 | Washington | Utah | 49053 | 85 | 0 |
115034 | 115034 | 2020-05-04 | Washington | Utah | 49053 | 85 | 0 |
112151 | 112151 | 2020-05-03 | Washington | Utah | 49053 | 72 | 0 |
109277 | 109277 | 2020-05-02 | Washington | Utah | 49053 | 71 | 0 |
106408 | 106408 | 2020-05-01 | Washington | Utah | 49053 | 68 | 0 |
103544 | 103544 | 2020-04-30 | Washington | Utah | 49053 | 65 | 0 |
100689 | 100689 | 2020-04-29 | Washington | Utah | 49053 | 65 | 0 |
97839 | 97839 | 2020-04-28 | Washington | Utah | 49053 | 62 | 0 |
94997 | 94997 | 2020-04-27 | Washington | Utah | 49053 | 62 | 0 |
92168 | 92168 | 2020-04-26 | Washington | Utah | 49053 | 62 | 0 |
89351 | 89351 | 2020-04-25 | Washington | Utah | 49053 | 58 | 0 |
86536 | 86536 | 2020-04-24 | Washington | Utah | 49053 | 51 | 0 |
83729 | 83729 | 2020-04-23 | Washington | Utah | 49053 | 51 | 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);