ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Lawrence" and fips = 47099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923012 | 923012 | 2021-01-12 | Lawrence | Tennessee | 47099 | 4938 | 68 |
919767 | 919767 | 2021-01-11 | Lawrence | Tennessee | 47099 | 4916 | 67 |
916522 | 916522 | 2021-01-10 | Lawrence | Tennessee | 47099 | 4885 | 66 |
913277 | 913277 | 2021-01-09 | Lawrence | Tennessee | 47099 | 4822 | 66 |
910032 | 910032 | 2021-01-08 | Lawrence | Tennessee | 47099 | 4801 | 66 |
906787 | 906787 | 2021-01-07 | Lawrence | Tennessee | 47099 | 4767 | 64 |
903541 | 903541 | 2021-01-06 | Lawrence | Tennessee | 47099 | 4676 | 64 |
900296 | 900296 | 2021-01-05 | Lawrence | Tennessee | 47099 | 4630 | 63 |
897051 | 897051 | 2021-01-04 | Lawrence | Tennessee | 47099 | 4600 | 62 |
893805 | 893805 | 2021-01-03 | Lawrence | Tennessee | 47099 | 4551 | 59 |
890559 | 890559 | 2021-01-02 | Lawrence | Tennessee | 47099 | 4519 | 59 |
887312 | 887312 | 2021-01-01 | Lawrence | Tennessee | 47099 | 4416 | 58 |
884067 | 884067 | 2020-12-31 | Lawrence | Tennessee | 47099 | 4416 | 58 |
880822 | 880822 | 2020-12-30 | Lawrence | Tennessee | 47099 | 4369 | 57 |
877577 | 877577 | 2020-12-29 | Lawrence | Tennessee | 47099 | 4310 | 57 |
874332 | 874332 | 2020-12-28 | Lawrence | Tennessee | 47099 | 4294 | 57 |
871087 | 871087 | 2020-12-27 | Lawrence | Tennessee | 47099 | 4266 | 57 |
867842 | 867842 | 2020-12-26 | Lawrence | Tennessee | 47099 | 4243 | 55 |
864597 | 864597 | 2020-12-25 | Lawrence | Tennessee | 47099 | 4223 | 55 |
861352 | 861352 | 2020-12-24 | Lawrence | Tennessee | 47099 | 4149 | 55 |
858107 | 858107 | 2020-12-23 | Lawrence | Tennessee | 47099 | 4112 | 54 |
854862 | 854862 | 2020-12-22 | Lawrence | Tennessee | 47099 | 4070 | 54 |
851617 | 851617 | 2020-12-21 | Lawrence | Tennessee | 47099 | 4016 | 52 |
848372 | 848372 | 2020-12-20 | Lawrence | Tennessee | 47099 | 3960 | 52 |
845127 | 845127 | 2020-12-19 | Lawrence | Tennessee | 47099 | 3859 | 52 |
841881 | 841881 | 2020-12-18 | Lawrence | Tennessee | 47099 | 3834 | 51 |
838636 | 838636 | 2020-12-17 | Lawrence | Tennessee | 47099 | 3778 | 51 |
835390 | 835390 | 2020-12-16 | Lawrence | Tennessee | 47099 | 3721 | 48 |
832144 | 832144 | 2020-12-15 | Lawrence | Tennessee | 47099 | 3604 | 47 |
828897 | 828897 | 2020-12-14 | Lawrence | Tennessee | 47099 | 3480 | 45 |
825651 | 825651 | 2020-12-13 | Lawrence | Tennessee | 47099 | 3455 | 44 |
822404 | 822404 | 2020-12-12 | Lawrence | Tennessee | 47099 | 3369 | 43 |
819158 | 819158 | 2020-12-11 | Lawrence | Tennessee | 47099 | 3291 | 41 |
815912 | 815912 | 2020-12-10 | Lawrence | Tennessee | 47099 | 3227 | 39 |
812666 | 812666 | 2020-12-09 | Lawrence | Tennessee | 47099 | 3182 | 39 |
809422 | 809422 | 2020-12-08 | Lawrence | Tennessee | 47099 | 3128 | 38 |
806177 | 806177 | 2020-12-07 | Lawrence | Tennessee | 47099 | 3055 | 38 |
802932 | 802932 | 2020-12-06 | Lawrence | Tennessee | 47099 | 2996 | 38 |
799687 | 799687 | 2020-12-05 | Lawrence | Tennessee | 47099 | 2987 | 38 |
796442 | 796442 | 2020-12-04 | Lawrence | Tennessee | 47099 | 2937 | 38 |
793197 | 793197 | 2020-12-03 | Lawrence | Tennessee | 47099 | 2902 | 37 |
789952 | 789952 | 2020-12-02 | Lawrence | Tennessee | 47099 | 2885 | 36 |
786707 | 786707 | 2020-12-01 | Lawrence | Tennessee | 47099 | 2841 | 34 |
783463 | 783463 | 2020-11-30 | Lawrence | Tennessee | 47099 | 2761 | 34 |
780218 | 780218 | 2020-11-29 | Lawrence | Tennessee | 47099 | 2701 | 34 |
776972 | 776972 | 2020-11-28 | Lawrence | Tennessee | 47099 | 2700 | 34 |
773727 | 773727 | 2020-11-27 | Lawrence | Tennessee | 47099 | 2639 | 34 |
770482 | 770482 | 2020-11-26 | Lawrence | Tennessee | 47099 | 2600 | 34 |
767236 | 767236 | 2020-11-25 | Lawrence | Tennessee | 47099 | 2535 | 33 |
763991 | 763991 | 2020-11-24 | Lawrence | Tennessee | 47099 | 2515 | 32 |
760746 | 760746 | 2020-11-23 | Lawrence | Tennessee | 47099 | 2507 | 32 |
757501 | 757501 | 2020-11-22 | Lawrence | Tennessee | 47099 | 2496 | 32 |
754254 | 754254 | 2020-11-21 | Lawrence | Tennessee | 47099 | 2457 | 32 |
751008 | 751008 | 2020-11-20 | Lawrence | Tennessee | 47099 | 2430 | 32 |
747762 | 747762 | 2020-11-19 | Lawrence | Tennessee | 47099 | 2399 | 31 |
744516 | 744516 | 2020-11-18 | Lawrence | Tennessee | 47099 | 2364 | 28 |
741269 | 741269 | 2020-11-17 | Lawrence | Tennessee | 47099 | 2339 | 26 |
738023 | 738023 | 2020-11-16 | Lawrence | Tennessee | 47099 | 2315 | 26 |
734779 | 734779 | 2020-11-15 | Lawrence | Tennessee | 47099 | 2253 | 25 |
731533 | 731533 | 2020-11-14 | Lawrence | Tennessee | 47099 | 2217 | 25 |
728289 | 728289 | 2020-11-13 | Lawrence | Tennessee | 47099 | 2169 | 25 |
725045 | 725045 | 2020-11-12 | Lawrence | Tennessee | 47099 | 2134 | 24 |
721802 | 721802 | 2020-11-11 | Lawrence | Tennessee | 47099 | 2103 | 24 |
718559 | 718559 | 2020-11-10 | Lawrence | Tennessee | 47099 | 2065 | 24 |
715316 | 715316 | 2020-11-09 | Lawrence | Tennessee | 47099 | 1998 | 24 |
712072 | 712072 | 2020-11-08 | Lawrence | Tennessee | 47099 | 1942 | 24 |
708828 | 708828 | 2020-11-07 | Lawrence | Tennessee | 47099 | 1937 | 24 |
705585 | 705585 | 2020-11-06 | Lawrence | Tennessee | 47099 | 1876 | 24 |
702342 | 702342 | 2020-11-05 | Lawrence | Tennessee | 47099 | 1864 | 24 |
699098 | 699098 | 2020-11-04 | Lawrence | Tennessee | 47099 | 1854 | 24 |
695855 | 695855 | 2020-11-03 | Lawrence | Tennessee | 47099 | 1802 | 24 |
692613 | 692613 | 2020-11-02 | Lawrence | Tennessee | 47099 | 1780 | 20 |
689369 | 689369 | 2020-11-01 | Lawrence | Tennessee | 47099 | 1746 | 20 |
686124 | 686124 | 2020-10-31 | Lawrence | Tennessee | 47099 | 1740 | 20 |
682881 | 682881 | 2020-10-30 | Lawrence | Tennessee | 47099 | 1732 | 20 |
679638 | 679638 | 2020-10-29 | Lawrence | Tennessee | 47099 | 1707 | 20 |
676395 | 676395 | 2020-10-28 | Lawrence | Tennessee | 47099 | 1696 | 20 |
673152 | 673152 | 2020-10-27 | Lawrence | Tennessee | 47099 | 1665 | 20 |
669910 | 669910 | 2020-10-26 | Lawrence | Tennessee | 47099 | 1645 | 20 |
666666 | 666666 | 2020-10-25 | Lawrence | Tennessee | 47099 | 1618 | 20 |
663421 | 663421 | 2020-10-24 | Lawrence | Tennessee | 47099 | 1587 | 19 |
660177 | 660177 | 2020-10-23 | Lawrence | Tennessee | 47099 | 1556 | 18 |
656933 | 656933 | 2020-10-22 | Lawrence | Tennessee | 47099 | 1526 | 18 |
653688 | 653688 | 2020-10-21 | Lawrence | Tennessee | 47099 | 1505 | 18 |
650443 | 650443 | 2020-10-20 | Lawrence | Tennessee | 47099 | 1479 | 18 |
647199 | 647199 | 2020-10-19 | Lawrence | Tennessee | 47099 | 1462 | 17 |
643953 | 643953 | 2020-10-18 | Lawrence | Tennessee | 47099 | 1429 | 17 |
640705 | 640705 | 2020-10-17 | Lawrence | Tennessee | 47099 | 1405 | 17 |
637459 | 637459 | 2020-10-16 | Lawrence | Tennessee | 47099 | 1376 | 17 |
634213 | 634213 | 2020-10-15 | Lawrence | Tennessee | 47099 | 1368 | 17 |
630968 | 630968 | 2020-10-14 | Lawrence | Tennessee | 47099 | 1332 | 17 |
627724 | 627724 | 2020-10-13 | Lawrence | Tennessee | 47099 | 1307 | 17 |
624482 | 624482 | 2020-10-12 | Lawrence | Tennessee | 47099 | 1296 | 17 |
621239 | 621239 | 2020-10-11 | Lawrence | Tennessee | 47099 | 1262 | 17 |
617996 | 617996 | 2020-10-10 | Lawrence | Tennessee | 47099 | 1244 | 17 |
614754 | 614754 | 2020-10-09 | Lawrence | Tennessee | 47099 | 1224 | 17 |
611513 | 611513 | 2020-10-08 | Lawrence | Tennessee | 47099 | 1206 | 16 |
608271 | 608271 | 2020-10-07 | Lawrence | Tennessee | 47099 | 1193 | 16 |
605028 | 605028 | 2020-10-06 | Lawrence | Tennessee | 47099 | 1175 | 14 |
601786 | 601786 | 2020-10-05 | Lawrence | Tennessee | 47099 | 1160 | 14 |
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);