ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Washington" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637499 | 637499 | 2020-10-16 | Washington | Tennessee | 47179 | 2874 | 42 |
634254 | 634254 | 2020-10-15 | Washington | Tennessee | 47179 | 2855 | 42 |
631009 | 631009 | 2020-10-14 | Washington | Tennessee | 47179 | 2801 | 42 |
627765 | 627765 | 2020-10-13 | Washington | Tennessee | 47179 | 2783 | 42 |
624523 | 624523 | 2020-10-12 | Washington | Tennessee | 47179 | 2761 | 41 |
621280 | 621280 | 2020-10-11 | Washington | Tennessee | 47179 | 2709 | 40 |
618037 | 618037 | 2020-10-10 | Washington | Tennessee | 47179 | 2672 | 40 |
614795 | 614795 | 2020-10-09 | Washington | Tennessee | 47179 | 2623 | 39 |
611554 | 611554 | 2020-10-08 | Washington | Tennessee | 47179 | 2590 | 39 |
608312 | 608312 | 2020-10-07 | Washington | Tennessee | 47179 | 2573 | 38 |
605069 | 605069 | 2020-10-06 | Washington | Tennessee | 47179 | 2531 | 38 |
601827 | 601827 | 2020-10-05 | Washington | Tennessee | 47179 | 2512 | 38 |
598584 | 598584 | 2020-10-04 | Washington | Tennessee | 47179 | 2488 | 38 |
595341 | 595341 | 2020-10-03 | Washington | Tennessee | 47179 | 2460 | 38 |
592099 | 592099 | 2020-10-02 | Washington | Tennessee | 47179 | 2435 | 38 |
588859 | 588859 | 2020-10-01 | Washington | Tennessee | 47179 | 2406 | 38 |
585618 | 585618 | 2020-09-30 | Washington | Tennessee | 47179 | 2393 | 38 |
582378 | 582378 | 2020-09-29 | Washington | Tennessee | 47179 | 2355 | 38 |
579139 | 579139 | 2020-09-28 | Washington | Tennessee | 47179 | 2337 | 36 |
575898 | 575898 | 2020-09-27 | Washington | Tennessee | 47179 | 2328 | 36 |
572654 | 572654 | 2020-09-26 | Washington | Tennessee | 47179 | 2297 | 36 |
569412 | 569412 | 2020-09-25 | Washington | Tennessee | 47179 | 2276 | 35 |
566171 | 566171 | 2020-09-24 | Washington | Tennessee | 47179 | 2239 | 35 |
562930 | 562930 | 2020-09-23 | Washington | Tennessee | 47179 | 2232 | 34 |
559692 | 559692 | 2020-09-22 | Washington | Tennessee | 47179 | 2186 | 34 |
556456 | 556456 | 2020-09-21 | Washington | Tennessee | 47179 | 2179 | 33 |
553219 | 553219 | 2020-09-20 | Washington | Tennessee | 47179 | 2167 | 32 |
549980 | 549980 | 2020-09-19 | Washington | Tennessee | 47179 | 2123 | 32 |
546741 | 546741 | 2020-09-18 | Washington | Tennessee | 47179 | 2107 | 32 |
543504 | 543504 | 2020-09-17 | Washington | Tennessee | 47179 | 2068 | 28 |
540268 | 540268 | 2020-09-16 | Washington | Tennessee | 47179 | 2053 | 27 |
537031 | 537031 | 2020-09-15 | Washington | Tennessee | 47179 | 2025 | 26 |
533795 | 533795 | 2020-09-14 | Washington | Tennessee | 47179 | 2007 | 25 |
530560 | 530560 | 2020-09-13 | Washington | Tennessee | 47179 | 1964 | 24 |
527323 | 527323 | 2020-09-12 | Washington | Tennessee | 47179 | 1944 | 24 |
524087 | 524087 | 2020-09-11 | Washington | Tennessee | 47179 | 1935 | 22 |
520851 | 520851 | 2020-09-10 | Washington | Tennessee | 47179 | 1913 | 16 |
517615 | 517615 | 2020-09-09 | Washington | Tennessee | 47179 | 1876 | 16 |
514380 | 514380 | 2020-09-08 | Washington | Tennessee | 47179 | 1863 | 14 |
511147 | 511147 | 2020-09-07 | Washington | Tennessee | 47179 | 1862 | 14 |
507914 | 507914 | 2020-09-06 | Washington | Tennessee | 47179 | 1837 | 14 |
504682 | 504682 | 2020-09-05 | Washington | Tennessee | 47179 | 1819 | 14 |
501448 | 501448 | 2020-09-04 | Washington | Tennessee | 47179 | 1773 | 14 |
498214 | 498214 | 2020-09-03 | Washington | Tennessee | 47179 | 1766 | 13 |
494981 | 494981 | 2020-09-02 | Washington | Tennessee | 47179 | 1812 | 13 |
491747 | 491747 | 2020-09-01 | Washington | Tennessee | 47179 | 1771 | 13 |
488514 | 488514 | 2020-08-31 | Washington | Tennessee | 47179 | 1741 | 13 |
485281 | 485281 | 2020-08-30 | Washington | Tennessee | 47179 | 1718 | 13 |
482046 | 482046 | 2020-08-29 | Washington | Tennessee | 47179 | 1700 | 12 |
478812 | 478812 | 2020-08-28 | Washington | Tennessee | 47179 | 1671 | 12 |
475579 | 475579 | 2020-08-27 | Washington | Tennessee | 47179 | 1650 | 9 |
472346 | 472346 | 2020-08-26 | Washington | Tennessee | 47179 | 1641 | 8 |
469114 | 469114 | 2020-08-25 | Washington | Tennessee | 47179 | 1601 | 8 |
465885 | 465885 | 2020-08-24 | Washington | Tennessee | 47179 | 1597 | 7 |
462656 | 462656 | 2020-08-23 | Washington | Tennessee | 47179 | 1592 | 6 |
459427 | 459427 | 2020-08-22 | Washington | Tennessee | 47179 | 1555 | 6 |
456200 | 456200 | 2020-08-21 | Washington | Tennessee | 47179 | 1541 | 6 |
452972 | 452972 | 2020-08-20 | Washington | Tennessee | 47179 | 1524 | 4 |
449744 | 449744 | 2020-08-19 | Washington | Tennessee | 47179 | 1513 | 4 |
446516 | 446516 | 2020-08-18 | Washington | Tennessee | 47179 | 1476 | 3 |
443289 | 443289 | 2020-08-17 | Washington | Tennessee | 47179 | 1466 | 2 |
440063 | 440063 | 2020-08-16 | Washington | Tennessee | 47179 | 1455 | 2 |
436837 | 436837 | 2020-08-15 | Washington | Tennessee | 47179 | 1405 | 2 |
433611 | 433611 | 2020-08-14 | Washington | Tennessee | 47179 | 1391 | 2 |
430386 | 430386 | 2020-08-13 | Washington | Tennessee | 47179 | 1382 | 2 |
427159 | 427159 | 2020-08-12 | Washington | Tennessee | 47179 | 1352 | 2 |
423935 | 423935 | 2020-08-11 | Washington | Tennessee | 47179 | 1291 | 2 |
420714 | 420714 | 2020-08-10 | Washington | Tennessee | 47179 | 1277 | 2 |
417493 | 417493 | 2020-08-09 | Washington | Tennessee | 47179 | 1252 | 2 |
414272 | 414272 | 2020-08-08 | Washington | Tennessee | 47179 | 1225 | 2 |
411052 | 411052 | 2020-08-07 | Washington | Tennessee | 47179 | 1200 | 2 |
407833 | 407833 | 2020-08-06 | Washington | Tennessee | 47179 | 1131 | 2 |
404613 | 404613 | 2020-08-05 | Washington | Tennessee | 47179 | 1114 | 2 |
401395 | 401395 | 2020-08-04 | Washington | Tennessee | 47179 | 1089 | 2 |
398179 | 398179 | 2020-08-03 | Washington | Tennessee | 47179 | 1066 | 2 |
394963 | 394963 | 2020-08-02 | Washington | Tennessee | 47179 | 1038 | 2 |
391747 | 391747 | 2020-08-01 | Washington | Tennessee | 47179 | 993 | 2 |
388530 | 388530 | 2020-07-31 | Washington | Tennessee | 47179 | 943 | 2 |
385313 | 385313 | 2020-07-30 | Washington | Tennessee | 47179 | 870 | 2 |
382095 | 382095 | 2020-07-29 | Washington | Tennessee | 47179 | 840 | 2 |
378878 | 378878 | 2020-07-28 | Washington | Tennessee | 47179 | 786 | 2 |
375662 | 375662 | 2020-07-27 | Washington | Tennessee | 47179 | 750 | 0 |
372449 | 372449 | 2020-07-26 | Washington | Tennessee | 47179 | 694 | 0 |
369237 | 369237 | 2020-07-25 | Washington | Tennessee | 47179 | 626 | 0 |
366028 | 366028 | 2020-07-24 | Washington | Tennessee | 47179 | 577 | 0 |
362822 | 362822 | 2020-07-23 | Washington | Tennessee | 47179 | 523 | 0 |
359615 | 359615 | 2020-07-22 | Washington | Tennessee | 47179 | 502 | 0 |
356410 | 356410 | 2020-07-21 | Washington | Tennessee | 47179 | 490 | 0 |
353207 | 353207 | 2020-07-20 | Washington | Tennessee | 47179 | 470 | 0 |
350005 | 350005 | 2020-07-19 | Washington | Tennessee | 47179 | 430 | 0 |
346805 | 346805 | 2020-07-18 | Washington | Tennessee | 47179 | 379 | 0 |
343605 | 343605 | 2020-07-17 | Washington | Tennessee | 47179 | 358 | 0 |
340406 | 340406 | 2020-07-16 | Washington | Tennessee | 47179 | 336 | 0 |
337210 | 337210 | 2020-07-15 | Washington | Tennessee | 47179 | 321 | 0 |
334015 | 334015 | 2020-07-14 | Washington | Tennessee | 47179 | 293 | 0 |
330824 | 330824 | 2020-07-13 | Washington | Tennessee | 47179 | 276 | 0 |
327638 | 327638 | 2020-07-12 | Washington | Tennessee | 47179 | 262 | 0 |
324453 | 324453 | 2020-07-11 | Washington | Tennessee | 47179 | 261 | 0 |
321272 | 321272 | 2020-07-10 | Washington | Tennessee | 47179 | 235 | 0 |
318094 | 318094 | 2020-07-09 | Washington | Tennessee | 47179 | 212 | 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);