ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Henry" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955456 | 955456 | 2021-01-22 | Henry | Tennessee | 47079 | 2669 | 58 |
952211 | 952211 | 2021-01-21 | Henry | Tennessee | 47079 | 2655 | 58 |
948966 | 948966 | 2021-01-20 | Henry | Tennessee | 47079 | 2629 | 58 |
945720 | 945720 | 2021-01-19 | Henry | Tennessee | 47079 | 2619 | 58 |
942473 | 942473 | 2021-01-18 | Henry | Tennessee | 47079 | 2608 | 58 |
939228 | 939228 | 2021-01-17 | Henry | Tennessee | 47079 | 2603 | 58 |
935983 | 935983 | 2021-01-16 | Henry | Tennessee | 47079 | 2591 | 58 |
932738 | 932738 | 2021-01-15 | Henry | Tennessee | 47079 | 2573 | 57 |
929493 | 929493 | 2021-01-14 | Henry | Tennessee | 47079 | 2539 | 57 |
926248 | 926248 | 2021-01-13 | Henry | Tennessee | 47079 | 2524 | 56 |
923002 | 923002 | 2021-01-12 | Henry | Tennessee | 47079 | 2511 | 56 |
919757 | 919757 | 2021-01-11 | Henry | Tennessee | 47079 | 2498 | 52 |
916512 | 916512 | 2021-01-10 | Henry | Tennessee | 47079 | 2487 | 48 |
913267 | 913267 | 2021-01-09 | Henry | Tennessee | 47079 | 2457 | 48 |
910022 | 910022 | 2021-01-08 | Henry | Tennessee | 47079 | 2443 | 47 |
906777 | 906777 | 2021-01-07 | Henry | Tennessee | 47079 | 2423 | 44 |
903531 | 903531 | 2021-01-06 | Henry | Tennessee | 47079 | 2399 | 44 |
900286 | 900286 | 2021-01-05 | Henry | Tennessee | 47079 | 2384 | 43 |
897041 | 897041 | 2021-01-04 | Henry | Tennessee | 47079 | 2372 | 41 |
893795 | 893795 | 2021-01-03 | Henry | Tennessee | 47079 | 2368 | 39 |
890549 | 890549 | 2021-01-02 | Henry | Tennessee | 47079 | 2361 | 38 |
887302 | 887302 | 2021-01-01 | Henry | Tennessee | 47079 | 2311 | 38 |
884057 | 884057 | 2020-12-31 | Henry | Tennessee | 47079 | 2311 | 38 |
880812 | 880812 | 2020-12-30 | Henry | Tennessee | 47079 | 2304 | 36 |
877567 | 877567 | 2020-12-29 | Henry | Tennessee | 47079 | 2287 | 36 |
874322 | 874322 | 2020-12-28 | Henry | Tennessee | 47079 | 2269 | 34 |
871077 | 871077 | 2020-12-27 | Henry | Tennessee | 47079 | 2262 | 33 |
867832 | 867832 | 2020-12-26 | Henry | Tennessee | 47079 | 2255 | 34 |
864587 | 864587 | 2020-12-25 | Henry | Tennessee | 47079 | 2239 | 34 |
861342 | 861342 | 2020-12-24 | Henry | Tennessee | 47079 | 2209 | 34 |
858097 | 858097 | 2020-12-23 | Henry | Tennessee | 47079 | 2197 | 34 |
854852 | 854852 | 2020-12-22 | Henry | Tennessee | 47079 | 2179 | 33 |
851607 | 851607 | 2020-12-21 | Henry | Tennessee | 47079 | 2167 | 32 |
848362 | 848362 | 2020-12-20 | Henry | Tennessee | 47079 | 2139 | 32 |
845117 | 845117 | 2020-12-19 | Henry | Tennessee | 47079 | 2101 | 31 |
841871 | 841871 | 2020-12-18 | Henry | Tennessee | 47079 | 2073 | 31 |
838626 | 838626 | 2020-12-17 | Henry | Tennessee | 47079 | 2031 | 28 |
835380 | 835380 | 2020-12-16 | Henry | Tennessee | 47079 | 2008 | 28 |
832134 | 832134 | 2020-12-15 | Henry | Tennessee | 47079 | 1991 | 28 |
828887 | 828887 | 2020-12-14 | Henry | Tennessee | 47079 | 1963 | 26 |
825641 | 825641 | 2020-12-13 | Henry | Tennessee | 47079 | 1907 | 26 |
822394 | 822394 | 2020-12-12 | Henry | Tennessee | 47079 | 1864 | 26 |
819148 | 819148 | 2020-12-11 | Henry | Tennessee | 47079 | 1846 | 24 |
815902 | 815902 | 2020-12-10 | Henry | Tennessee | 47079 | 1818 | 24 |
812656 | 812656 | 2020-12-09 | Henry | Tennessee | 47079 | 1785 | 24 |
809412 | 809412 | 2020-12-08 | Henry | Tennessee | 47079 | 1738 | 23 |
806167 | 806167 | 2020-12-07 | Henry | Tennessee | 47079 | 1715 | 23 |
802922 | 802922 | 2020-12-06 | Henry | Tennessee | 47079 | 1681 | 23 |
799677 | 799677 | 2020-12-05 | Henry | Tennessee | 47079 | 1673 | 22 |
796432 | 796432 | 2020-12-04 | Henry | Tennessee | 47079 | 1653 | 22 |
793187 | 793187 | 2020-12-03 | Henry | Tennessee | 47079 | 1633 | 21 |
789942 | 789942 | 2020-12-02 | Henry | Tennessee | 47079 | 1626 | 19 |
786697 | 786697 | 2020-12-01 | Henry | Tennessee | 47079 | 1608 | 18 |
783453 | 783453 | 2020-11-30 | Henry | Tennessee | 47079 | 1593 | 19 |
780208 | 780208 | 2020-11-29 | Henry | Tennessee | 47079 | 1543 | 19 |
776962 | 776962 | 2020-11-28 | Henry | Tennessee | 47079 | 1536 | 19 |
773717 | 773717 | 2020-11-27 | Henry | Tennessee | 47079 | 1493 | 17 |
770472 | 770472 | 2020-11-26 | Henry | Tennessee | 47079 | 1489 | 17 |
767226 | 767226 | 2020-11-25 | Henry | Tennessee | 47079 | 1463 | 17 |
763981 | 763981 | 2020-11-24 | Henry | Tennessee | 47079 | 1450 | 17 |
760736 | 760736 | 2020-11-23 | Henry | Tennessee | 47079 | 1446 | 17 |
757491 | 757491 | 2020-11-22 | Henry | Tennessee | 47079 | 1415 | 17 |
754244 | 754244 | 2020-11-21 | Henry | Tennessee | 47079 | 1384 | 17 |
750998 | 750998 | 2020-11-20 | Henry | Tennessee | 47079 | 1352 | 17 |
747752 | 747752 | 2020-11-19 | Henry | Tennessee | 47079 | 1339 | 16 |
744506 | 744506 | 2020-11-18 | Henry | Tennessee | 47079 | 1289 | 15 |
741259 | 741259 | 2020-11-17 | Henry | Tennessee | 47079 | 1261 | 15 |
738013 | 738013 | 2020-11-16 | Henry | Tennessee | 47079 | 1249 | 15 |
734769 | 734769 | 2020-11-15 | Henry | Tennessee | 47079 | 1227 | 15 |
731523 | 731523 | 2020-11-14 | Henry | Tennessee | 47079 | 1159 | 15 |
728279 | 728279 | 2020-11-13 | Henry | Tennessee | 47079 | 1134 | 13 |
725035 | 725035 | 2020-11-12 | Henry | Tennessee | 47079 | 1098 | 13 |
721792 | 721792 | 2020-11-11 | Henry | Tennessee | 47079 | 1078 | 13 |
718549 | 718549 | 2020-11-10 | Henry | Tennessee | 47079 | 1042 | 13 |
715306 | 715306 | 2020-11-09 | Henry | Tennessee | 47079 | 1043 | 13 |
712062 | 712062 | 2020-11-08 | Henry | Tennessee | 47079 | 1008 | 13 |
708818 | 708818 | 2020-11-07 | Henry | Tennessee | 47079 | 988 | 13 |
705575 | 705575 | 2020-11-06 | Henry | Tennessee | 47079 | 955 | 13 |
702332 | 702332 | 2020-11-05 | Henry | Tennessee | 47079 | 936 | 13 |
699088 | 699088 | 2020-11-04 | Henry | Tennessee | 47079 | 926 | 13 |
695845 | 695845 | 2020-11-03 | Henry | Tennessee | 47079 | 892 | 13 |
692603 | 692603 | 2020-11-02 | Henry | Tennessee | 47079 | 888 | 12 |
689359 | 689359 | 2020-11-01 | Henry | Tennessee | 47079 | 860 | 12 |
686114 | 686114 | 2020-10-31 | Henry | Tennessee | 47079 | 858 | 12 |
682871 | 682871 | 2020-10-30 | Henry | Tennessee | 47079 | 845 | 12 |
679628 | 679628 | 2020-10-29 | Henry | Tennessee | 47079 | 837 | 12 |
676385 | 676385 | 2020-10-28 | Henry | Tennessee | 47079 | 821 | 12 |
673142 | 673142 | 2020-10-27 | Henry | Tennessee | 47079 | 809 | 12 |
669900 | 669900 | 2020-10-26 | Henry | Tennessee | 47079 | 802 | 11 |
666656 | 666656 | 2020-10-25 | Henry | Tennessee | 47079 | 796 | 11 |
663411 | 663411 | 2020-10-24 | Henry | Tennessee | 47079 | 781 | 10 |
660167 | 660167 | 2020-10-23 | Henry | Tennessee | 47079 | 771 | 10 |
656923 | 656923 | 2020-10-22 | Henry | Tennessee | 47079 | 756 | 10 |
653678 | 653678 | 2020-10-21 | Henry | Tennessee | 47079 | 753 | 10 |
650433 | 650433 | 2020-10-20 | Henry | Tennessee | 47079 | 746 | 10 |
647189 | 647189 | 2020-10-19 | Henry | Tennessee | 47079 | 741 | 10 |
643943 | 643943 | 2020-10-18 | Henry | Tennessee | 47079 | 736 | 10 |
640695 | 640695 | 2020-10-17 | Henry | Tennessee | 47079 | 723 | 10 |
637449 | 637449 | 2020-10-16 | Henry | Tennessee | 47079 | 707 | 10 |
634203 | 634203 | 2020-10-15 | Henry | Tennessee | 47079 | 708 | 10 |
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);