ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 47157 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056110 | 1056110 | 2021-02-22 | Shelby | Tennessee | 47157 | 87088 | 1460 |
1052864 | 1052864 | 2021-02-21 | Shelby | Tennessee | 47157 | 86978 | 1460 |
1049617 | 1049617 | 2021-02-20 | Shelby | Tennessee | 47157 | 86865 | 1459 |
1046370 | 1046370 | 2021-02-19 | Shelby | Tennessee | 47157 | 86759 | 1454 |
1043125 | 1043125 | 2021-02-18 | Shelby | Tennessee | 47157 | 86686 | 1452 |
1039880 | 1039880 | 2021-02-17 | Shelby | Tennessee | 47157 | 86644 | 1443 |
1036635 | 1036635 | 2021-02-16 | Shelby | Tennessee | 47157 | 86522 | 1441 |
1033390 | 1033390 | 2021-02-15 | Shelby | Tennessee | 47157 | 86522 | 1441 |
1030144 | 1030144 | 2021-02-14 | Shelby | Tennessee | 47157 | 86250 | 1441 |
1026897 | 1026897 | 2021-02-13 | Shelby | Tennessee | 47157 | 86250 | 1440 |
1023652 | 1023652 | 2021-02-12 | Shelby | Tennessee | 47157 | 85807 | 1424 |
1020407 | 1020407 | 2021-02-11 | Shelby | Tennessee | 47157 | 85594 | 1410 |
1017162 | 1017162 | 2021-02-10 | Shelby | Tennessee | 47157 | 85594 | 1406 |
1013917 | 1013917 | 2021-02-09 | Shelby | Tennessee | 47157 | 85234 | 1387 |
1010672 | 1010672 | 2021-02-08 | Shelby | Tennessee | 47157 | 85234 | 1387 |
1007426 | 1007426 | 2021-02-07 | Shelby | Tennessee | 47157 | 84798 | 1378 |
1004180 | 1004180 | 2021-02-06 | Shelby | Tennessee | 47157 | 84798 | 1378 |
1000934 | 1000934 | 2021-02-05 | Shelby | Tennessee | 47157 | 84479 | 1371 |
997688 | 997688 | 2021-02-04 | Shelby | Tennessee | 47157 | 84123 | 1348 |
994442 | 994442 | 2021-02-03 | Shelby | Tennessee | 47157 | 83489 | 1298 |
991196 | 991196 | 2021-02-02 | Shelby | Tennessee | 47157 | 83489 | 1296 |
987950 | 987950 | 2021-02-01 | Shelby | Tennessee | 47157 | 83235 | 1289 |
984703 | 984703 | 2021-01-31 | Shelby | Tennessee | 47157 | 83029 | 1280 |
981456 | 981456 | 2021-01-30 | Shelby | Tennessee | 47157 | 82653 | 1265 |
978210 | 978210 | 2021-01-29 | Shelby | Tennessee | 47157 | 82428 | 1254 |
974965 | 974965 | 2021-01-28 | Shelby | Tennessee | 47157 | 81657 | 1241 |
971720 | 971720 | 2021-01-27 | Shelby | Tennessee | 47157 | 80991 | 1223 |
968475 | 968475 | 2021-01-26 | Shelby | Tennessee | 47157 | 80991 | 1211 |
965231 | 965231 | 2021-01-25 | Shelby | Tennessee | 47157 | 80991 | 1202 |
961986 | 961986 | 2021-01-24 | Shelby | Tennessee | 47157 | 80770 | 1194 |
958741 | 958741 | 2021-01-23 | Shelby | Tennessee | 47157 | 79925 | 1182 |
955495 | 955495 | 2021-01-22 | Shelby | Tennessee | 47157 | 79925 | 1182 |
952250 | 952250 | 2021-01-21 | Shelby | Tennessee | 47157 | 79388 | 1169 |
949005 | 949005 | 2021-01-20 | Shelby | Tennessee | 47157 | 79051 | 1154 |
945759 | 945759 | 2021-01-19 | Shelby | Tennessee | 47157 | 78619 | 1140 |
942512 | 942512 | 2021-01-18 | Shelby | Tennessee | 47157 | 78020 | 1140 |
939267 | 939267 | 2021-01-17 | Shelby | Tennessee | 47157 | 77566 | 1128 |
936022 | 936022 | 2021-01-16 | Shelby | Tennessee | 47157 | 77069 | 1115 |
932777 | 932777 | 2021-01-15 | Shelby | Tennessee | 47157 | 77069 | 1115 |
929532 | 929532 | 2021-01-14 | Shelby | Tennessee | 47157 | 76534 | 1102 |
926287 | 926287 | 2021-01-13 | Shelby | Tennessee | 47157 | 75495 | 1080 |
923041 | 923041 | 2021-01-12 | Shelby | Tennessee | 47157 | 75016 | 1055 |
919796 | 919796 | 2021-01-11 | Shelby | Tennessee | 47157 | 74508 | 1039 |
916551 | 916551 | 2021-01-10 | Shelby | Tennessee | 47157 | 73817 | 1029 |
913306 | 913306 | 2021-01-09 | Shelby | Tennessee | 47157 | 73817 | 1024 |
910061 | 910061 | 2021-01-08 | Shelby | Tennessee | 47157 | 72626 | 1009 |
906816 | 906816 | 2021-01-07 | Shelby | Tennessee | 47157 | 72626 | 1003 |
903570 | 903570 | 2021-01-06 | Shelby | Tennessee | 47157 | 71728 | 984 |
900325 | 900325 | 2021-01-05 | Shelby | Tennessee | 47157 | 70532 | 947 |
897080 | 897080 | 2021-01-04 | Shelby | Tennessee | 47157 | 70532 | 945 |
893834 | 893834 | 2021-01-03 | Shelby | Tennessee | 47157 | 70142 | 925 |
890588 | 890588 | 2021-01-02 | Shelby | Tennessee | 47157 | 69798 | 914 |
887341 | 887341 | 2021-01-01 | Shelby | Tennessee | 47157 | 67800 | 903 |
884096 | 884096 | 2020-12-31 | Shelby | Tennessee | 47157 | 67198 | 903 |
880851 | 880851 | 2020-12-30 | Shelby | Tennessee | 47157 | 66437 | 889 |
877606 | 877606 | 2020-12-29 | Shelby | Tennessee | 47157 | 66437 | 877 |
874361 | 874361 | 2020-12-28 | Shelby | Tennessee | 47157 | 66084 | 861 |
871116 | 871116 | 2020-12-27 | Shelby | Tennessee | 47157 | 65713 | 849 |
867871 | 867871 | 2020-12-26 | Shelby | Tennessee | 47157 | 64356 | 839 |
864626 | 864626 | 2020-12-25 | Shelby | Tennessee | 47157 | 64013 | 839 |
861381 | 861381 | 2020-12-24 | Shelby | Tennessee | 47157 | 63394 | 837 |
858136 | 858136 | 2020-12-23 | Shelby | Tennessee | 47157 | 62783 | 835 |
854891 | 854891 | 2020-12-22 | Shelby | Tennessee | 47157 | 62783 | 826 |
851646 | 851646 | 2020-12-21 | Shelby | Tennessee | 47157 | 61444 | 818 |
848401 | 848401 | 2020-12-20 | Shelby | Tennessee | 47157 | 61429 | 818 |
845156 | 845156 | 2020-12-19 | Shelby | Tennessee | 47157 | 60651 | 810 |
841910 | 841910 | 2020-12-18 | Shelby | Tennessee | 47157 | 59387 | 802 |
838665 | 838665 | 2020-12-17 | Shelby | Tennessee | 47157 | 58762 | 782 |
835419 | 835419 | 2020-12-16 | Shelby | Tennessee | 47157 | 58762 | 761 |
832173 | 832173 | 2020-12-15 | Shelby | Tennessee | 47157 | 57599 | 757 |
828926 | 828926 | 2020-12-14 | Shelby | Tennessee | 47157 | 56820 | 753 |
825680 | 825680 | 2020-12-13 | Shelby | Tennessee | 47157 | 55456 | 744 |
822433 | 822433 | 2020-12-12 | Shelby | Tennessee | 47157 | 54465 | 737 |
819187 | 819187 | 2020-12-11 | Shelby | Tennessee | 47157 | 54234 | 731 |
815941 | 815941 | 2020-12-10 | Shelby | Tennessee | 47157 | 53304 | 726 |
812695 | 812695 | 2020-12-09 | Shelby | Tennessee | 47157 | 53058 | 722 |
809451 | 809451 | 2020-12-08 | Shelby | Tennessee | 47157 | 52363 | 716 |
806206 | 806206 | 2020-12-07 | Shelby | Tennessee | 47157 | 51775 | 709 |
802961 | 802961 | 2020-12-06 | Shelby | Tennessee | 47157 | 51030 | 705 |
799716 | 799716 | 2020-12-05 | Shelby | Tennessee | 47157 | 50923 | 702 |
796471 | 796471 | 2020-12-04 | Shelby | Tennessee | 47157 | 50470 | 696 |
793226 | 793226 | 2020-12-03 | Shelby | Tennessee | 47157 | 49731 | 687 |
789981 | 789981 | 2020-12-02 | Shelby | Tennessee | 47157 | 49412 | 681 |
786736 | 786736 | 2020-12-01 | Shelby | Tennessee | 47157 | 49077 | 672 |
783492 | 783492 | 2020-11-30 | Shelby | Tennessee | 47157 | 48561 | 673 |
780247 | 780247 | 2020-11-29 | Shelby | Tennessee | 47157 | 47963 | 660 |
777001 | 777001 | 2020-11-28 | Shelby | Tennessee | 47157 | 47682 | 659 |
773756 | 773756 | 2020-11-27 | Shelby | Tennessee | 47157 | 47215 | 659 |
770511 | 770511 | 2020-11-26 | Shelby | Tennessee | 47157 | 46549 | 658 |
767265 | 767265 | 2020-11-25 | Shelby | Tennessee | 47157 | 46330 | 652 |
764020 | 764020 | 2020-11-24 | Shelby | Tennessee | 47157 | 46210 | 645 |
760775 | 760775 | 2020-11-23 | Shelby | Tennessee | 47157 | 45952 | 637 |
757530 | 757530 | 2020-11-22 | Shelby | Tennessee | 47157 | 45609 | 635 |
754283 | 754283 | 2020-11-21 | Shelby | Tennessee | 47157 | 45045 | 630 |
751037 | 751037 | 2020-11-20 | Shelby | Tennessee | 47157 | 44659 | 630 |
747791 | 747791 | 2020-11-19 | Shelby | Tennessee | 47157 | 44474 | 626 |
744545 | 744545 | 2020-11-18 | Shelby | Tennessee | 47157 | 44102 | 623 |
741298 | 741298 | 2020-11-17 | Shelby | Tennessee | 47157 | 43700 | 616 |
738052 | 738052 | 2020-11-16 | Shelby | Tennessee | 47157 | 43478 | 613 |
734808 | 734808 | 2020-11-15 | Shelby | Tennessee | 47157 | 42660 | 612 |
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);