ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
713 rows where county = "Douglas" and state = "Missouri" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
195256 | 195256 | 2020-05-31 | Douglas | Missouri | 29067 | 1 | 0 |
198327 | 198327 | 2020-06-01 | Douglas | Missouri | 29067 | 1 | 0 |
201400 | 201400 | 2020-06-02 | Douglas | Missouri | 29067 | 2 | 0 |
204477 | 204477 | 2020-06-03 | Douglas | Missouri | 29067 | 2 | 0 |
207558 | 207558 | 2020-06-04 | Douglas | Missouri | 29067 | 2 | 0 |
210639 | 210639 | 2020-06-05 | Douglas | Missouri | 29067 | 2 | 0 |
213723 | 213723 | 2020-06-06 | Douglas | Missouri | 29067 | 2 | 0 |
216811 | 216811 | 2020-06-07 | Douglas | Missouri | 29067 | 2 | 0 |
219903 | 219903 | 2020-06-08 | Douglas | Missouri | 29067 | 3 | 0 |
222998 | 222998 | 2020-06-09 | Douglas | Missouri | 29067 | 3 | 0 |
226096 | 226096 | 2020-06-10 | Douglas | Missouri | 29067 | 3 | 0 |
229199 | 229199 | 2020-06-11 | Douglas | Missouri | 29067 | 3 | 0 |
232303 | 232303 | 2020-06-12 | Douglas | Missouri | 29067 | 3 | 0 |
235409 | 235409 | 2020-06-13 | Douglas | Missouri | 29067 | 3 | 0 |
238516 | 238516 | 2020-06-14 | Douglas | Missouri | 29067 | 3 | 0 |
241626 | 241626 | 2020-06-15 | Douglas | Missouri | 29067 | 3 | 0 |
244737 | 244737 | 2020-06-16 | Douglas | Missouri | 29067 | 3 | 0 |
247850 | 247850 | 2020-06-17 | Douglas | Missouri | 29067 | 3 | 0 |
250963 | 250963 | 2020-06-18 | Douglas | Missouri | 29067 | 3 | 0 |
254078 | 254078 | 2020-06-19 | Douglas | Missouri | 29067 | 3 | 0 |
257198 | 257198 | 2020-06-20 | Douglas | Missouri | 29067 | 3 | 0 |
260324 | 260324 | 2020-06-21 | Douglas | Missouri | 29067 | 3 | 0 |
263452 | 263452 | 2020-06-22 | Douglas | Missouri | 29067 | 3 | 0 |
266578 | 266578 | 2020-06-23 | Douglas | Missouri | 29067 | 3 | 0 |
269711 | 269711 | 2020-06-24 | Douglas | Missouri | 29067 | 3 | 0 |
272849 | 272849 | 2020-06-25 | Douglas | Missouri | 29067 | 3 | 0 |
275992 | 275992 | 2020-06-26 | Douglas | Missouri | 29067 | 3 | 0 |
279140 | 279140 | 2020-06-27 | Douglas | Missouri | 29067 | 3 | 0 |
282288 | 282288 | 2020-06-28 | Douglas | Missouri | 29067 | 3 | 0 |
285433 | 285433 | 2020-06-29 | Douglas | Missouri | 29067 | 4 | 0 |
288583 | 288583 | 2020-06-30 | Douglas | Missouri | 29067 | 4 | 0 |
291734 | 291734 | 2020-07-01 | Douglas | Missouri | 29067 | 5 | 0 |
294888 | 294888 | 2020-07-02 | Douglas | Missouri | 29067 | 6 | 0 |
298046 | 298046 | 2020-07-03 | Douglas | Missouri | 29067 | 6 | 0 |
301209 | 301209 | 2020-07-04 | Douglas | Missouri | 29067 | 6 | 0 |
304373 | 304373 | 2020-07-05 | Douglas | Missouri | 29067 | 6 | 0 |
307540 | 307540 | 2020-07-06 | Douglas | Missouri | 29067 | 6 | 0 |
310708 | 310708 | 2020-07-07 | Douglas | Missouri | 29067 | 6 | 0 |
313878 | 313878 | 2020-07-08 | Douglas | Missouri | 29067 | 6 | 0 |
317052 | 317052 | 2020-07-09 | Douglas | Missouri | 29067 | 8 | 0 |
320227 | 320227 | 2020-07-10 | Douglas | Missouri | 29067 | 11 | 0 |
323406 | 323406 | 2020-07-11 | Douglas | Missouri | 29067 | 12 | 0 |
326589 | 326589 | 2020-07-12 | Douglas | Missouri | 29067 | 12 | 0 |
329775 | 329775 | 2020-07-13 | Douglas | Missouri | 29067 | 13 | 0 |
332962 | 332962 | 2020-07-14 | Douglas | Missouri | 29067 | 16 | 0 |
336155 | 336155 | 2020-07-15 | Douglas | Missouri | 29067 | 17 | 0 |
339351 | 339351 | 2020-07-16 | Douglas | Missouri | 29067 | 21 | 0 |
342547 | 342547 | 2020-07-17 | Douglas | Missouri | 29067 | 22 | 0 |
345747 | 345747 | 2020-07-18 | Douglas | Missouri | 29067 | 22 | 1 |
348948 | 348948 | 2020-07-19 | Douglas | Missouri | 29067 | 26 | 1 |
352148 | 352148 | 2020-07-20 | Douglas | Missouri | 29067 | 28 | 1 |
355350 | 355350 | 2020-07-21 | Douglas | Missouri | 29067 | 31 | 1 |
358553 | 358553 | 2020-07-22 | Douglas | Missouri | 29067 | 32 | 1 |
361758 | 361758 | 2020-07-23 | Douglas | Missouri | 29067 | 36 | 1 |
364965 | 364965 | 2020-07-24 | Douglas | Missouri | 29067 | 40 | 1 |
368173 | 368173 | 2020-07-25 | Douglas | Missouri | 29067 | 43 | 1 |
371384 | 371384 | 2020-07-26 | Douglas | Missouri | 29067 | 46 | 1 |
374596 | 374596 | 2020-07-27 | Douglas | Missouri | 29067 | 47 | 1 |
377811 | 377811 | 2020-07-28 | Douglas | Missouri | 29067 | 53 | 2 |
381028 | 381028 | 2020-07-29 | Douglas | Missouri | 29067 | 56 | 2 |
384244 | 384244 | 2020-07-30 | Douglas | Missouri | 29067 | 61 | 2 |
387462 | 387462 | 2020-07-31 | Douglas | Missouri | 29067 | 68 | 2 |
390679 | 390679 | 2020-08-01 | Douglas | Missouri | 29067 | 73 | 2 |
393896 | 393896 | 2020-08-02 | Douglas | Missouri | 29067 | 73 | 2 |
397112 | 397112 | 2020-08-03 | Douglas | Missouri | 29067 | 81 | 2 |
400326 | 400326 | 2020-08-04 | Douglas | Missouri | 29067 | 83 | 2 |
403543 | 403543 | 2020-08-05 | Douglas | Missouri | 29067 | 83 | 2 |
406761 | 406761 | 2020-08-06 | Douglas | Missouri | 29067 | 84 | 2 |
409981 | 409981 | 2020-08-07 | Douglas | Missouri | 29067 | 83 | 2 |
413201 | 413201 | 2020-08-08 | Douglas | Missouri | 29067 | 83 | 2 |
416421 | 416421 | 2020-08-09 | Douglas | Missouri | 29067 | 82 | 2 |
419642 | 419642 | 2020-08-10 | Douglas | Missouri | 29067 | 87 | 2 |
422864 | 422864 | 2020-08-11 | Douglas | Missouri | 29067 | 89 | 2 |
426086 | 426086 | 2020-08-12 | Douglas | Missouri | 29067 | 89 | 2 |
429310 | 429310 | 2020-08-13 | Douglas | Missouri | 29067 | 89 | 2 |
432537 | 432537 | 2020-08-14 | Douglas | Missouri | 29067 | 89 | 2 |
435763 | 435763 | 2020-08-15 | Douglas | Missouri | 29067 | 92 | 2 |
438988 | 438988 | 2020-08-16 | Douglas | Missouri | 29067 | 94 | 2 |
442215 | 442215 | 2020-08-17 | Douglas | Missouri | 29067 | 94 | 2 |
445441 | 445441 | 2020-08-18 | Douglas | Missouri | 29067 | 94 | 2 |
448667 | 448667 | 2020-08-19 | Douglas | Missouri | 29067 | 95 | 2 |
451895 | 451895 | 2020-08-20 | Douglas | Missouri | 29067 | 97 | 2 |
455123 | 455123 | 2020-08-21 | Douglas | Missouri | 29067 | 97 | 2 |
458351 | 458351 | 2020-08-22 | Douglas | Missouri | 29067 | 97 | 2 |
461578 | 461578 | 2020-08-23 | Douglas | Missouri | 29067 | 97 | 2 |
464809 | 464809 | 2020-08-24 | Douglas | Missouri | 29067 | 98 | 2 |
468038 | 468038 | 2020-08-25 | Douglas | Missouri | 29067 | 98 | 2 |
471268 | 471268 | 2020-08-26 | Douglas | Missouri | 29067 | 101 | 2 |
474500 | 474500 | 2020-08-27 | Douglas | Missouri | 29067 | 102 | 2 |
477733 | 477733 | 2020-08-28 | Douglas | Missouri | 29067 | 106 | 2 |
480965 | 480965 | 2020-08-29 | Douglas | Missouri | 29067 | 109 | 2 |
484200 | 484200 | 2020-08-30 | Douglas | Missouri | 29067 | 110 | 2 |
487434 | 487434 | 2020-08-31 | Douglas | Missouri | 29067 | 112 | 2 |
490667 | 490667 | 2020-09-01 | Douglas | Missouri | 29067 | 112 | 2 |
493901 | 493901 | 2020-09-02 | Douglas | Missouri | 29067 | 114 | 2 |
497134 | 497134 | 2020-09-03 | Douglas | Missouri | 29067 | 119 | 2 |
500368 | 500368 | 2020-09-04 | Douglas | Missouri | 29067 | 117 | 2 |
503602 | 503602 | 2020-09-05 | Douglas | Missouri | 29067 | 117 | 2 |
506835 | 506835 | 2020-09-06 | Douglas | Missouri | 29067 | 118 | 3 |
510068 | 510068 | 2020-09-07 | Douglas | Missouri | 29067 | 119 | 3 |
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);