ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where county = "Lake" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637457 | 637457 | 2020-10-16 | Lake | Tennessee | 47095 | 955 | 3 |
634211 | 634211 | 2020-10-15 | Lake | Tennessee | 47095 | 954 | 3 |
630966 | 630966 | 2020-10-14 | Lake | Tennessee | 47095 | 952 | 3 |
627722 | 627722 | 2020-10-13 | Lake | Tennessee | 47095 | 951 | 3 |
624480 | 624480 | 2020-10-12 | Lake | Tennessee | 47095 | 950 | 3 |
621237 | 621237 | 2020-10-11 | Lake | Tennessee | 47095 | 945 | 3 |
617994 | 617994 | 2020-10-10 | Lake | Tennessee | 47095 | 941 | 3 |
614752 | 614752 | 2020-10-09 | Lake | Tennessee | 47095 | 941 | 3 |
611511 | 611511 | 2020-10-08 | Lake | Tennessee | 47095 | 941 | 3 |
608269 | 608269 | 2020-10-07 | Lake | Tennessee | 47095 | 940 | 3 |
605026 | 605026 | 2020-10-06 | Lake | Tennessee | 47095 | 938 | 2 |
601784 | 601784 | 2020-10-05 | Lake | Tennessee | 47095 | 935 | 2 |
598541 | 598541 | 2020-10-04 | Lake | Tennessee | 47095 | 935 | 2 |
595298 | 595298 | 2020-10-03 | Lake | Tennessee | 47095 | 932 | 2 |
592057 | 592057 | 2020-10-02 | Lake | Tennessee | 47095 | 928 | 2 |
588816 | 588816 | 2020-10-01 | Lake | Tennessee | 47095 | 929 | 2 |
585576 | 585576 | 2020-09-30 | Lake | Tennessee | 47095 | 928 | 2 |
582336 | 582336 | 2020-09-29 | Lake | Tennessee | 47095 | 925 | 2 |
579096 | 579096 | 2020-09-28 | Lake | Tennessee | 47095 | 925 | 2 |
575855 | 575855 | 2020-09-27 | Lake | Tennessee | 47095 | 925 | 2 |
572611 | 572611 | 2020-09-26 | Lake | Tennessee | 47095 | 919 | 2 |
569369 | 569369 | 2020-09-25 | Lake | Tennessee | 47095 | 918 | 2 |
566128 | 566128 | 2020-09-24 | Lake | Tennessee | 47095 | 914 | 2 |
562887 | 562887 | 2020-09-23 | Lake | Tennessee | 47095 | 919 | 2 |
559650 | 559650 | 2020-09-22 | Lake | Tennessee | 47095 | 915 | 2 |
556413 | 556413 | 2020-09-21 | Lake | Tennessee | 47095 | 915 | 2 |
553176 | 553176 | 2020-09-20 | Lake | Tennessee | 47095 | 873 | 2 |
549937 | 549937 | 2020-09-19 | Lake | Tennessee | 47095 | 871 | 2 |
546698 | 546698 | 2020-09-18 | Lake | Tennessee | 47095 | 868 | 2 |
543461 | 543461 | 2020-09-17 | Lake | Tennessee | 47095 | 865 | 2 |
540225 | 540225 | 2020-09-16 | Lake | Tennessee | 47095 | 864 | 2 |
536988 | 536988 | 2020-09-15 | Lake | Tennessee | 47095 | 863 | 2 |
533752 | 533752 | 2020-09-14 | Lake | Tennessee | 47095 | 863 | 2 |
530517 | 530517 | 2020-09-13 | Lake | Tennessee | 47095 | 857 | 2 |
527280 | 527280 | 2020-09-12 | Lake | Tennessee | 47095 | 856 | 2 |
524044 | 524044 | 2020-09-11 | Lake | Tennessee | 47095 | 854 | 2 |
520808 | 520808 | 2020-09-10 | Lake | Tennessee | 47095 | 853 | 2 |
517572 | 517572 | 2020-09-09 | Lake | Tennessee | 47095 | 850 | 2 |
514337 | 514337 | 2020-09-08 | Lake | Tennessee | 47095 | 848 | 2 |
511104 | 511104 | 2020-09-07 | Lake | Tennessee | 47095 | 846 | 2 |
507871 | 507871 | 2020-09-06 | Lake | Tennessee | 47095 | 845 | 2 |
504639 | 504639 | 2020-09-05 | Lake | Tennessee | 47095 | 846 | 2 |
501405 | 501405 | 2020-09-04 | Lake | Tennessee | 47095 | 844 | 2 |
498171 | 498171 | 2020-09-03 | Lake | Tennessee | 47095 | 844 | 2 |
494938 | 494938 | 2020-09-02 | Lake | Tennessee | 47095 | 848 | 2 |
491704 | 491704 | 2020-09-01 | Lake | Tennessee | 47095 | 840 | 2 |
488471 | 488471 | 2020-08-31 | Lake | Tennessee | 47095 | 837 | 2 |
485238 | 485238 | 2020-08-30 | Lake | Tennessee | 47095 | 834 | 2 |
482003 | 482003 | 2020-08-29 | Lake | Tennessee | 47095 | 834 | 2 |
478769 | 478769 | 2020-08-28 | Lake | Tennessee | 47095 | 831 | 1 |
475536 | 475536 | 2020-08-27 | Lake | Tennessee | 47095 | 822 | 1 |
472303 | 472303 | 2020-08-26 | Lake | Tennessee | 47095 | 820 | 1 |
469071 | 469071 | 2020-08-25 | Lake | Tennessee | 47095 | 820 | 1 |
465842 | 465842 | 2020-08-24 | Lake | Tennessee | 47095 | 820 | 1 |
462613 | 462613 | 2020-08-23 | Lake | Tennessee | 47095 | 815 | 1 |
459385 | 459385 | 2020-08-22 | Lake | Tennessee | 47095 | 815 | 1 |
456157 | 456157 | 2020-08-21 | Lake | Tennessee | 47095 | 812 | 1 |
452929 | 452929 | 2020-08-20 | Lake | Tennessee | 47095 | 809 | 1 |
449701 | 449701 | 2020-08-19 | Lake | Tennessee | 47095 | 807 | 1 |
446473 | 446473 | 2020-08-18 | Lake | Tennessee | 47095 | 805 | 1 |
443247 | 443247 | 2020-08-17 | Lake | Tennessee | 47095 | 804 | 1 |
440020 | 440020 | 2020-08-16 | Lake | Tennessee | 47095 | 801 | 1 |
436795 | 436795 | 2020-08-15 | Lake | Tennessee | 47095 | 799 | 1 |
433568 | 433568 | 2020-08-14 | Lake | Tennessee | 47095 | 800 | 0 |
430343 | 430343 | 2020-08-13 | Lake | Tennessee | 47095 | 798 | 0 |
427116 | 427116 | 2020-08-12 | Lake | Tennessee | 47095 | 796 | 0 |
423893 | 423893 | 2020-08-11 | Lake | Tennessee | 47095 | 794 | 0 |
420671 | 420671 | 2020-08-10 | Lake | Tennessee | 47095 | 792 | 0 |
417450 | 417450 | 2020-08-09 | Lake | Tennessee | 47095 | 787 | 0 |
414229 | 414229 | 2020-08-08 | Lake | Tennessee | 47095 | 782 | 0 |
411009 | 411009 | 2020-08-07 | Lake | Tennessee | 47095 | 782 | 0 |
407790 | 407790 | 2020-08-06 | Lake | Tennessee | 47095 | 765 | 0 |
404570 | 404570 | 2020-08-05 | Lake | Tennessee | 47095 | 758 | 0 |
401352 | 401352 | 2020-08-04 | Lake | Tennessee | 47095 | 756 | 0 |
398137 | 398137 | 2020-08-03 | Lake | Tennessee | 47095 | 749 | 0 |
394920 | 394920 | 2020-08-02 | Lake | Tennessee | 47095 | 744 | 0 |
391704 | 391704 | 2020-08-01 | Lake | Tennessee | 47095 | 740 | 0 |
388487 | 388487 | 2020-07-31 | Lake | Tennessee | 47095 | 736 | 0 |
385270 | 385270 | 2020-07-30 | Lake | Tennessee | 47095 | 726 | 0 |
382052 | 382052 | 2020-07-29 | Lake | Tennessee | 47095 | 722 | 0 |
378835 | 378835 | 2020-07-28 | Lake | Tennessee | 47095 | 721 | 0 |
375619 | 375619 | 2020-07-27 | Lake | Tennessee | 47095 | 716 | 0 |
372406 | 372406 | 2020-07-26 | Lake | Tennessee | 47095 | 710 | 0 |
369194 | 369194 | 2020-07-25 | Lake | Tennessee | 47095 | 706 | 0 |
365985 | 365985 | 2020-07-24 | Lake | Tennessee | 47095 | 704 | 0 |
362779 | 362779 | 2020-07-23 | Lake | Tennessee | 47095 | 703 | 0 |
359572 | 359572 | 2020-07-22 | Lake | Tennessee | 47095 | 702 | 0 |
356368 | 356368 | 2020-07-21 | Lake | Tennessee | 47095 | 702 | 0 |
353165 | 353165 | 2020-07-20 | Lake | Tennessee | 47095 | 702 | 0 |
349962 | 349962 | 2020-07-19 | Lake | Tennessee | 47095 | 700 | 0 |
346762 | 346762 | 2020-07-18 | Lake | Tennessee | 47095 | 699 | 0 |
343562 | 343562 | 2020-07-17 | Lake | Tennessee | 47095 | 699 | 0 |
340364 | 340364 | 2020-07-16 | Lake | Tennessee | 47095 | 698 | 0 |
337167 | 337167 | 2020-07-15 | Lake | Tennessee | 47095 | 698 | 0 |
333973 | 333973 | 2020-07-14 | Lake | Tennessee | 47095 | 696 | 0 |
330781 | 330781 | 2020-07-13 | Lake | Tennessee | 47095 | 696 | 0 |
327595 | 327595 | 2020-07-12 | Lake | Tennessee | 47095 | 696 | 0 |
324410 | 324410 | 2020-07-11 | Lake | Tennessee | 47095 | 697 | 0 |
321229 | 321229 | 2020-07-10 | Lake | Tennessee | 47095 | 696 | 0 |
318051 | 318051 | 2020-07-09 | Lake | Tennessee | 47095 | 697 | 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);