ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 47035 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091750 | 1091750 | 2021-03-05 | Cumberland | Tennessee | 47035 | 6130 | 123 |
1088504 | 1088504 | 2021-03-04 | Cumberland | Tennessee | 47035 | 6127 | 122 |
1085259 | 1085259 | 2021-03-03 | Cumberland | Tennessee | 47035 | 6116 | 121 |
1082013 | 1082013 | 2021-03-02 | Cumberland | Tennessee | 47035 | 6106 | 121 |
1078767 | 1078767 | 2021-03-01 | Cumberland | Tennessee | 47035 | 6105 | 121 |
1075522 | 1075522 | 2021-02-28 | Cumberland | Tennessee | 47035 | 6102 | 121 |
1072276 | 1072276 | 2021-02-27 | Cumberland | Tennessee | 47035 | 6099 | 120 |
1069030 | 1069030 | 2021-02-26 | Cumberland | Tennessee | 47035 | 6093 | 120 |
1065785 | 1065785 | 2021-02-25 | Cumberland | Tennessee | 47035 | 6092 | 120 |
1062540 | 1062540 | 2021-02-24 | Cumberland | Tennessee | 47035 | 6072 | 117 |
1059295 | 1059295 | 2021-02-23 | Cumberland | Tennessee | 47035 | 6070 | 117 |
1056049 | 1056049 | 2021-02-22 | Cumberland | Tennessee | 47035 | 6058 | 116 |
1052803 | 1052803 | 2021-02-21 | Cumberland | Tennessee | 47035 | 6054 | 116 |
1049556 | 1049556 | 2021-02-20 | Cumberland | Tennessee | 47035 | 6043 | 115 |
1046309 | 1046309 | 2021-02-19 | Cumberland | Tennessee | 47035 | 6035 | 113 |
1043064 | 1043064 | 2021-02-18 | Cumberland | Tennessee | 47035 | 6025 | 113 |
1039819 | 1039819 | 2021-02-17 | Cumberland | Tennessee | 47035 | 6022 | 112 |
1036574 | 1036574 | 2021-02-16 | Cumberland | Tennessee | 47035 | 6017 | 112 |
1033329 | 1033329 | 2021-02-15 | Cumberland | Tennessee | 47035 | 6003 | 112 |
1030083 | 1030083 | 2021-02-14 | Cumberland | Tennessee | 47035 | 5984 | 112 |
1026836 | 1026836 | 2021-02-13 | Cumberland | Tennessee | 47035 | 5959 | 111 |
1023591 | 1023591 | 2021-02-12 | Cumberland | Tennessee | 47035 | 5919 | 111 |
1020346 | 1020346 | 2021-02-11 | Cumberland | Tennessee | 47035 | 5901 | 109 |
1017101 | 1017101 | 2021-02-10 | Cumberland | Tennessee | 47035 | 5874 | 108 |
1013856 | 1013856 | 2021-02-09 | Cumberland | Tennessee | 47035 | 5781 | 106 |
1010611 | 1010611 | 2021-02-08 | Cumberland | Tennessee | 47035 | 5748 | 104 |
1007365 | 1007365 | 2021-02-07 | Cumberland | Tennessee | 47035 | 5744 | 103 |
1004119 | 1004119 | 2021-02-06 | Cumberland | Tennessee | 47035 | 5739 | 103 |
1000873 | 1000873 | 2021-02-05 | Cumberland | Tennessee | 47035 | 5706 | 102 |
997627 | 997627 | 2021-02-04 | Cumberland | Tennessee | 47035 | 5693 | 97 |
994381 | 994381 | 2021-02-03 | Cumberland | Tennessee | 47035 | 5674 | 94 |
991135 | 991135 | 2021-02-02 | Cumberland | Tennessee | 47035 | 5668 | 91 |
987889 | 987889 | 2021-02-01 | Cumberland | Tennessee | 47035 | 5663 | 87 |
984642 | 984642 | 2021-01-31 | Cumberland | Tennessee | 47035 | 5658 | 86 |
981395 | 981395 | 2021-01-30 | Cumberland | Tennessee | 47035 | 5650 | 82 |
978149 | 978149 | 2021-01-29 | Cumberland | Tennessee | 47035 | 5639 | 80 |
974904 | 974904 | 2021-01-28 | Cumberland | Tennessee | 47035 | 5595 | 80 |
971659 | 971659 | 2021-01-27 | Cumberland | Tennessee | 47035 | 5578 | 79 |
968414 | 968414 | 2021-01-26 | Cumberland | Tennessee | 47035 | 5570 | 79 |
965170 | 965170 | 2021-01-25 | Cumberland | Tennessee | 47035 | 5567 | 77 |
961925 | 961925 | 2021-01-24 | Cumberland | Tennessee | 47035 | 5556 | 76 |
958680 | 958680 | 2021-01-23 | Cumberland | Tennessee | 47035 | 5544 | 76 |
955434 | 955434 | 2021-01-22 | Cumberland | Tennessee | 47035 | 5505 | 76 |
952189 | 952189 | 2021-01-21 | Cumberland | Tennessee | 47035 | 5470 | 75 |
948944 | 948944 | 2021-01-20 | Cumberland | Tennessee | 47035 | 5441 | 73 |
945698 | 945698 | 2021-01-19 | Cumberland | Tennessee | 47035 | 5421 | 73 |
942451 | 942451 | 2021-01-18 | Cumberland | Tennessee | 47035 | 5400 | 72 |
939206 | 939206 | 2021-01-17 | Cumberland | Tennessee | 47035 | 5378 | 72 |
935961 | 935961 | 2021-01-16 | Cumberland | Tennessee | 47035 | 5352 | 72 |
932716 | 932716 | 2021-01-15 | Cumberland | Tennessee | 47035 | 5286 | 72 |
929471 | 929471 | 2021-01-14 | Cumberland | Tennessee | 47035 | 5235 | 71 |
926226 | 926226 | 2021-01-13 | Cumberland | Tennessee | 47035 | 5193 | 70 |
922980 | 922980 | 2021-01-12 | Cumberland | Tennessee | 47035 | 5164 | 68 |
919735 | 919735 | 2021-01-11 | Cumberland | Tennessee | 47035 | 5140 | 62 |
916490 | 916490 | 2021-01-10 | Cumberland | Tennessee | 47035 | 5122 | 58 |
913245 | 913245 | 2021-01-09 | Cumberland | Tennessee | 47035 | 5070 | 58 |
910000 | 910000 | 2021-01-08 | Cumberland | Tennessee | 47035 | 4973 | 54 |
906755 | 906755 | 2021-01-07 | Cumberland | Tennessee | 47035 | 4896 | 53 |
903509 | 903509 | 2021-01-06 | Cumberland | Tennessee | 47035 | 4824 | 53 |
900264 | 900264 | 2021-01-05 | Cumberland | Tennessee | 47035 | 4750 | 53 |
897019 | 897019 | 2021-01-04 | Cumberland | Tennessee | 47035 | 4713 | 53 |
893773 | 893773 | 2021-01-03 | Cumberland | Tennessee | 47035 | 4687 | 53 |
890527 | 890527 | 2021-01-02 | Cumberland | Tennessee | 47035 | 4635 | 51 |
887280 | 887280 | 2021-01-01 | Cumberland | Tennessee | 47035 | 4398 | 51 |
884035 | 884035 | 2020-12-31 | Cumberland | Tennessee | 47035 | 4398 | 51 |
880790 | 880790 | 2020-12-30 | Cumberland | Tennessee | 47035 | 4358 | 51 |
877545 | 877545 | 2020-12-29 | Cumberland | Tennessee | 47035 | 4261 | 51 |
874300 | 874300 | 2020-12-28 | Cumberland | Tennessee | 47035 | 4225 | 51 |
871055 | 871055 | 2020-12-27 | Cumberland | Tennessee | 47035 | 4207 | 49 |
867810 | 867810 | 2020-12-26 | Cumberland | Tennessee | 47035 | 4196 | 48 |
864565 | 864565 | 2020-12-25 | Cumberland | Tennessee | 47035 | 4156 | 48 |
861320 | 861320 | 2020-12-24 | Cumberland | Tennessee | 47035 | 4024 | 48 |
858075 | 858075 | 2020-12-23 | Cumberland | Tennessee | 47035 | 3982 | 48 |
854830 | 854830 | 2020-12-22 | Cumberland | Tennessee | 47035 | 3943 | 48 |
851585 | 851585 | 2020-12-21 | Cumberland | Tennessee | 47035 | 3909 | 48 |
848340 | 848340 | 2020-12-20 | Cumberland | Tennessee | 47035 | 3823 | 48 |
845095 | 845095 | 2020-12-19 | Cumberland | Tennessee | 47035 | 3723 | 48 |
841849 | 841849 | 2020-12-18 | Cumberland | Tennessee | 47035 | 3677 | 47 |
838604 | 838604 | 2020-12-17 | Cumberland | Tennessee | 47035 | 3574 | 47 |
835358 | 835358 | 2020-12-16 | Cumberland | Tennessee | 47035 | 3457 | 44 |
832112 | 832112 | 2020-12-15 | Cumberland | Tennessee | 47035 | 3392 | 44 |
828865 | 828865 | 2020-12-14 | Cumberland | Tennessee | 47035 | 3339 | 44 |
825619 | 825619 | 2020-12-13 | Cumberland | Tennessee | 47035 | 3235 | 44 |
822372 | 822372 | 2020-12-12 | Cumberland | Tennessee | 47035 | 3158 | 44 |
819126 | 819126 | 2020-12-11 | Cumberland | Tennessee | 47035 | 3076 | 43 |
815880 | 815880 | 2020-12-10 | Cumberland | Tennessee | 47035 | 3041 | 42 |
812634 | 812634 | 2020-12-09 | Cumberland | Tennessee | 47035 | 2989 | 42 |
809390 | 809390 | 2020-12-08 | Cumberland | Tennessee | 47035 | 2912 | 42 |
806145 | 806145 | 2020-12-07 | Cumberland | Tennessee | 47035 | 2897 | 41 |
802900 | 802900 | 2020-12-06 | Cumberland | Tennessee | 47035 | 2806 | 38 |
799655 | 799655 | 2020-12-05 | Cumberland | Tennessee | 47035 | 2777 | 38 |
796410 | 796410 | 2020-12-04 | Cumberland | Tennessee | 47035 | 2741 | 38 |
793165 | 793165 | 2020-12-03 | Cumberland | Tennessee | 47035 | 2729 | 37 |
789920 | 789920 | 2020-12-02 | Cumberland | Tennessee | 47035 | 2717 | 37 |
786675 | 786675 | 2020-12-01 | Cumberland | Tennessee | 47035 | 2699 | 37 |
783431 | 783431 | 2020-11-30 | Cumberland | Tennessee | 47035 | 2665 | 36 |
780186 | 780186 | 2020-11-29 | Cumberland | Tennessee | 47035 | 2611 | 36 |
776940 | 776940 | 2020-11-28 | Cumberland | Tennessee | 47035 | 2572 | 36 |
773695 | 773695 | 2020-11-27 | Cumberland | Tennessee | 47035 | 2485 | 36 |
770450 | 770450 | 2020-11-26 | Cumberland | Tennessee | 47035 | 2470 | 35 |
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);