ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Warren" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056121 | 1056121 | 2021-02-22 | Warren | Tennessee | 47177 | 5289 | 75 |
1052875 | 1052875 | 2021-02-21 | Warren | Tennessee | 47177 | 5284 | 73 |
1049628 | 1049628 | 2021-02-20 | Warren | Tennessee | 47177 | 5284 | 73 |
1046381 | 1046381 | 2021-02-19 | Warren | Tennessee | 47177 | 5282 | 73 |
1043136 | 1043136 | 2021-02-18 | Warren | Tennessee | 47177 | 5281 | 73 |
1039891 | 1039891 | 2021-02-17 | Warren | Tennessee | 47177 | 5282 | 73 |
1036646 | 1036646 | 2021-02-16 | Warren | Tennessee | 47177 | 5282 | 73 |
1033401 | 1033401 | 2021-02-15 | Warren | Tennessee | 47177 | 5282 | 73 |
1030155 | 1030155 | 2021-02-14 | Warren | Tennessee | 47177 | 5276 | 73 |
1026908 | 1026908 | 2021-02-13 | Warren | Tennessee | 47177 | 5271 | 73 |
1023663 | 1023663 | 2021-02-12 | Warren | Tennessee | 47177 | 5244 | 73 |
1020418 | 1020418 | 2021-02-11 | Warren | Tennessee | 47177 | 5238 | 74 |
1017173 | 1017173 | 2021-02-10 | Warren | Tennessee | 47177 | 5223 | 71 |
1013928 | 1013928 | 2021-02-09 | Warren | Tennessee | 47177 | 5249 | 70 |
1010683 | 1010683 | 2021-02-08 | Warren | Tennessee | 47177 | 5266 | 66 |
1007437 | 1007437 | 2021-02-07 | Warren | Tennessee | 47177 | 5264 | 66 |
1004191 | 1004191 | 2021-02-06 | Warren | Tennessee | 47177 | 5263 | 66 |
1000945 | 1000945 | 2021-02-05 | Warren | Tennessee | 47177 | 5238 | 66 |
997699 | 997699 | 2021-02-04 | Warren | Tennessee | 47177 | 5229 | 65 |
994453 | 994453 | 2021-02-03 | Warren | Tennessee | 47177 | 5215 | 63 |
991207 | 991207 | 2021-02-02 | Warren | Tennessee | 47177 | 5208 | 63 |
987961 | 987961 | 2021-02-01 | Warren | Tennessee | 47177 | 5209 | 63 |
984714 | 984714 | 2021-01-31 | Warren | Tennessee | 47177 | 5202 | 62 |
981467 | 981467 | 2021-01-30 | Warren | Tennessee | 47177 | 5193 | 62 |
978221 | 978221 | 2021-01-29 | Warren | Tennessee | 47177 | 5169 | 61 |
974976 | 974976 | 2021-01-28 | Warren | Tennessee | 47177 | 5143 | 60 |
971731 | 971731 | 2021-01-27 | Warren | Tennessee | 47177 | 5132 | 59 |
968486 | 968486 | 2021-01-26 | Warren | Tennessee | 47177 | 5116 | 59 |
965242 | 965242 | 2021-01-25 | Warren | Tennessee | 47177 | 5116 | 56 |
961997 | 961997 | 2021-01-24 | Warren | Tennessee | 47177 | 5112 | 55 |
958752 | 958752 | 2021-01-23 | Warren | Tennessee | 47177 | 5104 | 55 |
955506 | 955506 | 2021-01-22 | Warren | Tennessee | 47177 | 5044 | 54 |
952261 | 952261 | 2021-01-21 | Warren | Tennessee | 47177 | 5033 | 54 |
949016 | 949016 | 2021-01-20 | Warren | Tennessee | 47177 | 5026 | 53 |
945770 | 945770 | 2021-01-19 | Warren | Tennessee | 47177 | 5000 | 53 |
942523 | 942523 | 2021-01-18 | Warren | Tennessee | 47177 | 4987 | 53 |
939278 | 939278 | 2021-01-17 | Warren | Tennessee | 47177 | 4975 | 53 |
936033 | 936033 | 2021-01-16 | Warren | Tennessee | 47177 | 4962 | 53 |
932788 | 932788 | 2021-01-15 | Warren | Tennessee | 47177 | 4927 | 53 |
929543 | 929543 | 2021-01-14 | Warren | Tennessee | 47177 | 4875 | 53 |
926298 | 926298 | 2021-01-13 | Warren | Tennessee | 47177 | 4850 | 51 |
923052 | 923052 | 2021-01-12 | Warren | Tennessee | 47177 | 4833 | 51 |
919807 | 919807 | 2021-01-11 | Warren | Tennessee | 47177 | 4813 | 51 |
916562 | 916562 | 2021-01-10 | Warren | Tennessee | 47177 | 4801 | 51 |
913317 | 913317 | 2021-01-09 | Warren | Tennessee | 47177 | 4754 | 50 |
910072 | 910072 | 2021-01-08 | Warren | Tennessee | 47177 | 4734 | 48 |
906827 | 906827 | 2021-01-07 | Warren | Tennessee | 47177 | 4651 | 48 |
903581 | 903581 | 2021-01-06 | Warren | Tennessee | 47177 | 4611 | 47 |
900336 | 900336 | 2021-01-05 | Warren | Tennessee | 47177 | 4578 | 46 |
897091 | 897091 | 2021-01-04 | Warren | Tennessee | 47177 | 4555 | 45 |
893845 | 893845 | 2021-01-03 | Warren | Tennessee | 47177 | 4536 | 43 |
890599 | 890599 | 2021-01-02 | Warren | Tennessee | 47177 | 4514 | 43 |
887352 | 887352 | 2021-01-01 | Warren | Tennessee | 47177 | 4395 | 43 |
884107 | 884107 | 2020-12-31 | Warren | Tennessee | 47177 | 4395 | 43 |
880862 | 880862 | 2020-12-30 | Warren | Tennessee | 47177 | 4367 | 41 |
877617 | 877617 | 2020-12-29 | Warren | Tennessee | 47177 | 4328 | 38 |
874372 | 874372 | 2020-12-28 | Warren | Tennessee | 47177 | 4295 | 34 |
871127 | 871127 | 2020-12-27 | Warren | Tennessee | 47177 | 4275 | 33 |
867882 | 867882 | 2020-12-26 | Warren | Tennessee | 47177 | 4274 | 33 |
864637 | 864637 | 2020-12-25 | Warren | Tennessee | 47177 | 4194 | 33 |
861392 | 861392 | 2020-12-24 | Warren | Tennessee | 47177 | 4102 | 33 |
858147 | 858147 | 2020-12-23 | Warren | Tennessee | 47177 | 4078 | 32 |
854902 | 854902 | 2020-12-22 | Warren | Tennessee | 47177 | 4040 | 30 |
851657 | 851657 | 2020-12-21 | Warren | Tennessee | 47177 | 3966 | 29 |
848412 | 848412 | 2020-12-20 | Warren | Tennessee | 47177 | 3924 | 29 |
845167 | 845167 | 2020-12-19 | Warren | Tennessee | 47177 | 3783 | 28 |
841921 | 841921 | 2020-12-18 | Warren | Tennessee | 47177 | 3732 | 27 |
838676 | 838676 | 2020-12-17 | Warren | Tennessee | 47177 | 3642 | 26 |
835430 | 835430 | 2020-12-16 | Warren | Tennessee | 47177 | 3498 | 24 |
832184 | 832184 | 2020-12-15 | Warren | Tennessee | 47177 | 3397 | 24 |
828937 | 828937 | 2020-12-14 | Warren | Tennessee | 47177 | 3295 | 24 |
825691 | 825691 | 2020-12-13 | Warren | Tennessee | 47177 | 3159 | 23 |
822444 | 822444 | 2020-12-12 | Warren | Tennessee | 47177 | 3060 | 22 |
819198 | 819198 | 2020-12-11 | Warren | Tennessee | 47177 | 2946 | 21 |
815952 | 815952 | 2020-12-10 | Warren | Tennessee | 47177 | 2874 | 21 |
812706 | 812706 | 2020-12-09 | Warren | Tennessee | 47177 | 2799 | 21 |
809462 | 809462 | 2020-12-08 | Warren | Tennessee | 47177 | 2724 | 21 |
806217 | 806217 | 2020-12-07 | Warren | Tennessee | 47177 | 2702 | 20 |
802972 | 802972 | 2020-12-06 | Warren | Tennessee | 47177 | 2642 | 20 |
799727 | 799727 | 2020-12-05 | Warren | Tennessee | 47177 | 2560 | 19 |
796482 | 796482 | 2020-12-04 | Warren | Tennessee | 47177 | 2539 | 19 |
793237 | 793237 | 2020-12-03 | Warren | Tennessee | 47177 | 2519 | 19 |
789992 | 789992 | 2020-12-02 | Warren | Tennessee | 47177 | 2507 | 20 |
786747 | 786747 | 2020-12-01 | Warren | Tennessee | 47177 | 2484 | 20 |
783503 | 783503 | 2020-11-30 | Warren | Tennessee | 47177 | 2431 | 20 |
780258 | 780258 | 2020-11-29 | Warren | Tennessee | 47177 | 2410 | 20 |
777012 | 777012 | 2020-11-28 | Warren | Tennessee | 47177 | 2400 | 20 |
773767 | 773767 | 2020-11-27 | Warren | Tennessee | 47177 | 2294 | 19 |
770522 | 770522 | 2020-11-26 | Warren | Tennessee | 47177 | 2282 | 19 |
767276 | 767276 | 2020-11-25 | Warren | Tennessee | 47177 | 2278 | 18 |
764031 | 764031 | 2020-11-24 | Warren | Tennessee | 47177 | 2271 | 18 |
760786 | 760786 | 2020-11-23 | Warren | Tennessee | 47177 | 2270 | 18 |
757541 | 757541 | 2020-11-22 | Warren | Tennessee | 47177 | 2265 | 17 |
754294 | 754294 | 2020-11-21 | Warren | Tennessee | 47177 | 2229 | 16 |
751048 | 751048 | 2020-11-20 | Warren | Tennessee | 47177 | 2166 | 16 |
747802 | 747802 | 2020-11-19 | Warren | Tennessee | 47177 | 2140 | 16 |
744556 | 744556 | 2020-11-18 | Warren | Tennessee | 47177 | 2120 | 16 |
741309 | 741309 | 2020-11-17 | Warren | Tennessee | 47177 | 2078 | 16 |
738063 | 738063 | 2020-11-16 | Warren | Tennessee | 47177 | 2073 | 16 |
734819 | 734819 | 2020-11-15 | Warren | Tennessee | 47177 | 2031 | 15 |
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);