ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where county = "Washington" and fips = 29221 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636493 | 636493 | 2020-10-16 | Washington | Missouri | 29221 | 573 | 11 |
633247 | 633247 | 2020-10-15 | Washington | Missouri | 29221 | 561 | 11 |
630002 | 630002 | 2020-10-14 | Washington | Missouri | 29221 | 551 | 11 |
626758 | 626758 | 2020-10-13 | Washington | Missouri | 29221 | 544 | 12 |
623516 | 623516 | 2020-10-12 | Washington | Missouri | 29221 | 544 | 12 |
620273 | 620273 | 2020-10-11 | Washington | Missouri | 29221 | 544 | 12 |
617031 | 617031 | 2020-10-10 | Washington | Missouri | 29221 | 544 | 12 |
613790 | 613790 | 2020-10-09 | Washington | Missouri | 29221 | 522 | 11 |
610548 | 610548 | 2020-10-08 | Washington | Missouri | 29221 | 508 | 11 |
607306 | 607306 | 2020-10-07 | Washington | Missouri | 29221 | 504 | 11 |
604063 | 604063 | 2020-10-06 | Washington | Missouri | 29221 | 501 | 11 |
600821 | 600821 | 2020-10-05 | Washington | Missouri | 29221 | 494 | 11 |
597578 | 597578 | 2020-10-04 | Washington | Missouri | 29221 | 477 | 11 |
594337 | 594337 | 2020-10-03 | Washington | Missouri | 29221 | 472 | 11 |
591096 | 591096 | 2020-10-02 | Washington | Missouri | 29221 | 454 | 11 |
587855 | 587855 | 2020-10-01 | Washington | Missouri | 29221 | 444 | 11 |
584615 | 584615 | 2020-09-30 | Washington | Missouri | 29221 | 434 | 11 |
581374 | 581374 | 2020-09-29 | Washington | Missouri | 29221 | 430 | 10 |
578133 | 578133 | 2020-09-28 | Washington | Missouri | 29221 | 430 | 10 |
574892 | 574892 | 2020-09-27 | Washington | Missouri | 29221 | 423 | 10 |
571649 | 571649 | 2020-09-26 | Washington | Missouri | 29221 | 414 | 10 |
568407 | 568407 | 2020-09-25 | Washington | Missouri | 29221 | 384 | 10 |
565167 | 565167 | 2020-09-24 | Washington | Missouri | 29221 | 376 | 10 |
561927 | 561927 | 2020-09-23 | Washington | Missouri | 29221 | 367 | 10 |
558690 | 558690 | 2020-09-22 | Washington | Missouri | 29221 | 342 | 10 |
555453 | 555453 | 2020-09-21 | Washington | Missouri | 29221 | 340 | 6 |
552215 | 552215 | 2020-09-20 | Washington | Missouri | 29221 | 339 | 5 |
548976 | 548976 | 2020-09-19 | Washington | Missouri | 29221 | 329 | 5 |
545738 | 545738 | 2020-09-18 | Washington | Missouri | 29221 | 319 | 4 |
542501 | 542501 | 2020-09-17 | Washington | Missouri | 29221 | 314 | 3 |
539265 | 539265 | 2020-09-16 | Washington | Missouri | 29221 | 305 | 1 |
536028 | 536028 | 2020-09-15 | Washington | Missouri | 29221 | 304 | 1 |
532793 | 532793 | 2020-09-14 | Washington | Missouri | 29221 | 304 | 1 |
529557 | 529557 | 2020-09-13 | Washington | Missouri | 29221 | 298 | 1 |
526321 | 526321 | 2020-09-12 | Washington | Missouri | 29221 | 295 | 1 |
523085 | 523085 | 2020-09-11 | Washington | Missouri | 29221 | 294 | 1 |
519848 | 519848 | 2020-09-10 | Washington | Missouri | 29221 | 279 | 1 |
516613 | 516613 | 2020-09-09 | Washington | Missouri | 29221 | 273 | 1 |
513379 | 513379 | 2020-09-08 | Washington | Missouri | 29221 | 269 | 1 |
510147 | 510147 | 2020-09-07 | Washington | Missouri | 29221 | 267 | 1 |
506914 | 506914 | 2020-09-06 | Washington | Missouri | 29221 | 268 | 1 |
503681 | 503681 | 2020-09-05 | Washington | Missouri | 29221 | 262 | 1 |
500447 | 500447 | 2020-09-04 | Washington | Missouri | 29221 | 253 | 1 |
497213 | 497213 | 2020-09-03 | Washington | Missouri | 29221 | 251 | 1 |
493980 | 493980 | 2020-09-02 | Washington | Missouri | 29221 | 246 | 1 |
490746 | 490746 | 2020-09-01 | Washington | Missouri | 29221 | 239 | 1 |
487513 | 487513 | 2020-08-31 | Washington | Missouri | 29221 | 238 | 1 |
484279 | 484279 | 2020-08-30 | Washington | Missouri | 29221 | 237 | 1 |
481044 | 481044 | 2020-08-29 | Washington | Missouri | 29221 | 228 | 1 |
477812 | 477812 | 2020-08-28 | Washington | Missouri | 29221 | 227 | 1 |
474579 | 474579 | 2020-08-27 | Washington | Missouri | 29221 | 224 | 1 |
471347 | 471347 | 2020-08-26 | Washington | Missouri | 29221 | 212 | 1 |
468117 | 468117 | 2020-08-25 | Washington | Missouri | 29221 | 200 | 1 |
464888 | 464888 | 2020-08-24 | Washington | Missouri | 29221 | 199 | 1 |
461657 | 461657 | 2020-08-23 | Washington | Missouri | 29221 | 191 | 1 |
458430 | 458430 | 2020-08-22 | Washington | Missouri | 29221 | 184 | 1 |
455202 | 455202 | 2020-08-21 | Washington | Missouri | 29221 | 181 | 1 |
451974 | 451974 | 2020-08-20 | Washington | Missouri | 29221 | 169 | 1 |
448746 | 448746 | 2020-08-19 | Washington | Missouri | 29221 | 156 | 1 |
445520 | 445520 | 2020-08-18 | Washington | Missouri | 29221 | 149 | 1 |
442294 | 442294 | 2020-08-17 | Washington | Missouri | 29221 | 143 | 1 |
439067 | 439067 | 2020-08-16 | Washington | Missouri | 29221 | 133 | 1 |
435842 | 435842 | 2020-08-15 | Washington | Missouri | 29221 | 126 | 1 |
432616 | 432616 | 2020-08-14 | Washington | Missouri | 29221 | 124 | 1 |
429389 | 429389 | 2020-08-13 | Washington | Missouri | 29221 | 105 | 1 |
426165 | 426165 | 2020-08-12 | Washington | Missouri | 29221 | 94 | 1 |
422943 | 422943 | 2020-08-11 | Washington | Missouri | 29221 | 87 | 1 |
419721 | 419721 | 2020-08-10 | Washington | Missouri | 29221 | 82 | 1 |
416500 | 416500 | 2020-08-09 | Washington | Missouri | 29221 | 77 | 1 |
413280 | 413280 | 2020-08-08 | Washington | Missouri | 29221 | 69 | 1 |
410060 | 410060 | 2020-08-07 | Washington | Missouri | 29221 | 69 | 1 |
406840 | 406840 | 2020-08-06 | Washington | Missouri | 29221 | 67 | 1 |
403622 | 403622 | 2020-08-05 | Washington | Missouri | 29221 | 66 | 1 |
400405 | 400405 | 2020-08-04 | Washington | Missouri | 29221 | 60 | 1 |
397191 | 397191 | 2020-08-03 | Washington | Missouri | 29221 | 56 | 1 |
393975 | 393975 | 2020-08-02 | Washington | Missouri | 29221 | 56 | 1 |
390758 | 390758 | 2020-08-01 | Washington | Missouri | 29221 | 54 | 1 |
387541 | 387541 | 2020-07-31 | Washington | Missouri | 29221 | 55 | 1 |
384323 | 384323 | 2020-07-30 | Washington | Missouri | 29221 | 54 | 1 |
381107 | 381107 | 2020-07-29 | Washington | Missouri | 29221 | 50 | 1 |
377890 | 377890 | 2020-07-28 | Washington | Missouri | 29221 | 49 | 1 |
374675 | 374675 | 2020-07-27 | Washington | Missouri | 29221 | 46 | 1 |
371463 | 371463 | 2020-07-26 | Washington | Missouri | 29221 | 46 | 1 |
368252 | 368252 | 2020-07-25 | Washington | Missouri | 29221 | 46 | 1 |
365044 | 365044 | 2020-07-24 | Washington | Missouri | 29221 | 42 | 1 |
361837 | 361837 | 2020-07-23 | Washington | Missouri | 29221 | 42 | 1 |
358632 | 358632 | 2020-07-22 | Washington | Missouri | 29221 | 41 | 1 |
355429 | 355429 | 2020-07-21 | Washington | Missouri | 29221 | 41 | 1 |
352227 | 352227 | 2020-07-20 | Washington | Missouri | 29221 | 40 | 1 |
349027 | 349027 | 2020-07-19 | Washington | Missouri | 29221 | 40 | 1 |
345826 | 345826 | 2020-07-18 | Washington | Missouri | 29221 | 39 | 1 |
342626 | 342626 | 2020-07-17 | Washington | Missouri | 29221 | 39 | 1 |
339430 | 339430 | 2020-07-16 | Washington | Missouri | 29221 | 38 | 1 |
336234 | 336234 | 2020-07-15 | Washington | Missouri | 29221 | 28 | 1 |
333041 | 333041 | 2020-07-14 | Washington | Missouri | 29221 | 27 | 1 |
329854 | 329854 | 2020-07-13 | Washington | Missouri | 29221 | 27 | 1 |
326668 | 326668 | 2020-07-12 | Washington | Missouri | 29221 | 26 | 1 |
323485 | 323485 | 2020-07-11 | Washington | Missouri | 29221 | 26 | 1 |
320306 | 320306 | 2020-07-10 | Washington | Missouri | 29221 | 26 | 1 |
317131 | 317131 | 2020-07-09 | Washington | Missouri | 29221 | 26 | 1 |
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);