ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Washington" and fips = 5143 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386121 | 386121 | 2020-07-31 | Washington | Arkansas | 5143 | 5896 | 45 |
382903 | 382903 | 2020-07-30 | Washington | Arkansas | 5143 | 5855 | 43 |
379686 | 379686 | 2020-07-29 | Washington | Arkansas | 5143 | 5812 | 43 |
376470 | 376470 | 2020-07-28 | Washington | Arkansas | 5143 | 5783 | 42 |
373256 | 373256 | 2020-07-27 | Washington | Arkansas | 5143 | 5729 | 40 |
370044 | 370044 | 2020-07-26 | Washington | Arkansas | 5143 | 5662 | 40 |
366834 | 366834 | 2020-07-25 | Washington | Arkansas | 5143 | 5576 | 40 |
363627 | 363627 | 2020-07-24 | Washington | Arkansas | 5143 | 5536 | 40 |
360420 | 360420 | 2020-07-23 | Washington | Arkansas | 5143 | 5451 | 40 |
357215 | 357215 | 2020-07-22 | Washington | Arkansas | 5143 | 5350 | 39 |
354012 | 354012 | 2020-07-21 | Washington | Arkansas | 5143 | 5312 | 39 |
350810 | 350810 | 2020-07-20 | Washington | Arkansas | 5143 | 5234 | 38 |
347609 | 347609 | 2020-07-19 | Washington | Arkansas | 5143 | 5139 | 37 |
344409 | 344409 | 2020-07-18 | Washington | Arkansas | 5143 | 5059 | 37 |
341210 | 341210 | 2020-07-17 | Washington | Arkansas | 5143 | 4913 | 37 |
338014 | 338014 | 2020-07-16 | Washington | Arkansas | 5143 | 4860 | 37 |
334819 | 334819 | 2020-07-15 | Washington | Arkansas | 5143 | 4778 | 37 |
331626 | 331626 | 2020-07-14 | Washington | Arkansas | 5143 | 4721 | 37 |
328440 | 328440 | 2020-07-13 | Washington | Arkansas | 5143 | 4594 | 37 |
325254 | 325254 | 2020-07-12 | Washington | Arkansas | 5143 | 4526 | 36 |
322073 | 322073 | 2020-07-11 | Washington | Arkansas | 5143 | 4456 | 36 |
318894 | 318894 | 2020-07-10 | Washington | Arkansas | 5143 | 4344 | 36 |
315721 | 315721 | 2020-07-09 | Washington | Arkansas | 5143 | 4309 | 35 |
312546 | 312546 | 2020-07-08 | Washington | Arkansas | 5143 | 4266 | 35 |
309376 | 309376 | 2020-07-07 | Washington | Arkansas | 5143 | 4171 | 34 |
306208 | 306208 | 2020-07-06 | Washington | Arkansas | 5143 | 4137 | 33 |
303044 | 303044 | 2020-07-05 | Washington | Arkansas | 5143 | 4050 | 32 |
299880 | 299880 | 2020-07-04 | Washington | Arkansas | 5143 | 3932 | 32 |
296718 | 296718 | 2020-07-03 | Washington | Arkansas | 5143 | 3853 | 31 |
293562 | 293562 | 2020-07-02 | Washington | Arkansas | 5143 | 3766 | 31 |
290408 | 290408 | 2020-07-01 | Washington | Arkansas | 5143 | 3634 | 30 |
287257 | 287257 | 2020-06-30 | Washington | Arkansas | 5143 | 3578 | 30 |
284111 | 284111 | 2020-06-29 | Washington | Arkansas | 5143 | 3417 | 30 |
280965 | 280965 | 2020-06-28 | Washington | Arkansas | 5143 | 3320 | 30 |
277818 | 277818 | 2020-06-27 | Washington | Arkansas | 5143 | 3238 | 27 |
274670 | 274670 | 2020-06-26 | Washington | Arkansas | 5143 | 3140 | 24 |
271530 | 271530 | 2020-06-25 | Washington | Arkansas | 5143 | 2880 | 23 |
268395 | 268395 | 2020-06-24 | Washington | Arkansas | 5143 | 2767 | 23 |
265265 | 265265 | 2020-06-23 | Washington | Arkansas | 5143 | 2680 | 21 |
262137 | 262137 | 2020-06-22 | Washington | Arkansas | 5143 | 2531 | 18 |
259010 | 259010 | 2020-06-21 | Washington | Arkansas | 5143 | 2404 | 18 |
255883 | 255883 | 2020-06-20 | Washington | Arkansas | 5143 | 2321 | 18 |
252764 | 252764 | 2020-06-19 | Washington | Arkansas | 5143 | 2222 | 17 |
249649 | 249649 | 2020-06-18 | Washington | Arkansas | 5143 | 2141 | 15 |
246537 | 246537 | 2020-06-17 | Washington | Arkansas | 5143 | 2080 | 15 |
243424 | 243424 | 2020-06-16 | Washington | Arkansas | 5143 | 1977 | 13 |
240313 | 240313 | 2020-06-15 | Washington | Arkansas | 5143 | 1925 | 12 |
237205 | 237205 | 2020-06-14 | Washington | Arkansas | 5143 | 1804 | 12 |
234098 | 234098 | 2020-06-13 | Washington | Arkansas | 5143 | 1710 | 12 |
230992 | 230992 | 2020-06-12 | Washington | Arkansas | 5143 | 1605 | 12 |
227889 | 227889 | 2020-06-11 | Washington | Arkansas | 5143 | 1389 | 10 |
224787 | 224787 | 2020-06-10 | Washington | Arkansas | 5143 | 1235 | 9 |
221692 | 221692 | 2020-06-09 | Washington | Arkansas | 5143 | 1185 | 7 |
218597 | 218597 | 2020-06-08 | Washington | Arkansas | 5143 | 1097 | 7 |
215506 | 215506 | 2020-06-07 | Washington | Arkansas | 5143 | 1016 | 8 |
212419 | 212419 | 2020-06-06 | Washington | Arkansas | 5143 | 913 | 8 |
209334 | 209334 | 2020-06-05 | Washington | Arkansas | 5143 | 824 | 8 |
206253 | 206253 | 2020-06-04 | Washington | Arkansas | 5143 | 771 | 8 |
203173 | 203173 | 2020-06-03 | Washington | Arkansas | 5143 | 652 | 7 |
200097 | 200097 | 2020-06-02 | Washington | Arkansas | 5143 | 620 | 7 |
197024 | 197024 | 2020-06-01 | Washington | Arkansas | 5143 | 562 | 7 |
193954 | 193954 | 2020-05-31 | Washington | Arkansas | 5143 | 509 | 7 |
190887 | 190887 | 2020-05-30 | Washington | Arkansas | 5143 | 452 | 7 |
187822 | 187822 | 2020-05-29 | Washington | Arkansas | 5143 | 410 | 7 |
184766 | 184766 | 2020-05-28 | Washington | Arkansas | 5143 | 352 | 6 |
181712 | 181712 | 2020-05-27 | Washington | Arkansas | 5143 | 326 | 6 |
178668 | 178668 | 2020-05-26 | Washington | Arkansas | 5143 | 303 | 5 |
175624 | 175624 | 2020-05-25 | Washington | Arkansas | 5143 | 276 | 5 |
172580 | 172580 | 2020-05-24 | Washington | Arkansas | 5143 | 259 | 5 |
169539 | 169539 | 2020-05-23 | Washington | Arkansas | 5143 | 233 | 5 |
166503 | 166503 | 2020-05-22 | Washington | Arkansas | 5143 | 213 | 5 |
163471 | 163471 | 2020-05-21 | Washington | Arkansas | 5143 | 180 | 5 |
160443 | 160443 | 2020-05-20 | Washington | Arkansas | 5143 | 154 | 5 |
157417 | 157417 | 2020-05-19 | Washington | Arkansas | 5143 | 151 | 5 |
154401 | 154401 | 2020-05-18 | Washington | Arkansas | 5143 | 145 | 5 |
151389 | 151389 | 2020-05-17 | Washington | Arkansas | 5143 | 143 | 5 |
148380 | 148380 | 2020-05-16 | Washington | Arkansas | 5143 | 141 | 5 |
145376 | 145376 | 2020-05-15 | Washington | Arkansas | 5143 | 131 | 5 |
142377 | 142377 | 2020-05-14 | Washington | Arkansas | 5143 | 126 | 5 |
139381 | 139381 | 2020-05-13 | Washington | Arkansas | 5143 | 114 | 5 |
136390 | 136390 | 2020-05-12 | Washington | Arkansas | 5143 | 111 | 4 |
133400 | 133400 | 2020-05-11 | Washington | Arkansas | 5143 | 110 | 3 |
130410 | 130410 | 2020-05-10 | Washington | Arkansas | 5143 | 110 | 3 |
127420 | 127420 | 2020-05-09 | Washington | Arkansas | 5143 | 105 | 3 |
124435 | 124435 | 2020-05-08 | Washington | Arkansas | 5143 | 105 | 3 |
121455 | 121455 | 2020-05-07 | Washington | Arkansas | 5143 | 102 | 3 |
118488 | 118488 | 2020-05-06 | Washington | Arkansas | 5143 | 94 | 3 |
115529 | 115529 | 2020-05-05 | Washington | Arkansas | 5143 | 91 | 3 |
112646 | 112646 | 2020-05-04 | Washington | Arkansas | 5143 | 91 | 3 |
109771 | 109771 | 2020-05-03 | Washington | Arkansas | 5143 | 90 | 3 |
106902 | 106902 | 2020-05-02 | Washington | Arkansas | 5143 | 87 | 3 |
104037 | 104037 | 2020-05-01 | Washington | Arkansas | 5143 | 87 | 3 |
101182 | 101182 | 2020-04-30 | Washington | Arkansas | 5143 | 86 | 3 |
98332 | 98332 | 2020-04-29 | Washington | Arkansas | 5143 | 84 | 3 |
95487 | 95487 | 2020-04-28 | Washington | Arkansas | 5143 | 77 | 3 |
92656 | 92656 | 2020-04-27 | Washington | Arkansas | 5143 | 77 | 3 |
89838 | 89838 | 2020-04-26 | Washington | Arkansas | 5143 | 77 | 3 |
87021 | 87021 | 2020-04-25 | Washington | Arkansas | 5143 | 74 | 3 |
84213 | 84213 | 2020-04-24 | Washington | Arkansas | 5143 | 71 | 2 |
81413 | 81413 | 2020-04-23 | Washington | Arkansas | 5143 | 62 | 2 |
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);