ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Dyer" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091755 | 1091755 | 2021-03-05 | Dyer | Tennessee | 47045 | 5243 | 101 |
1088509 | 1088509 | 2021-03-04 | Dyer | Tennessee | 47045 | 5242 | 101 |
1085264 | 1085264 | 2021-03-03 | Dyer | Tennessee | 47045 | 5241 | 101 |
1082018 | 1082018 | 2021-03-02 | Dyer | Tennessee | 47045 | 5237 | 101 |
1078772 | 1078772 | 2021-03-01 | Dyer | Tennessee | 47045 | 5235 | 101 |
1075527 | 1075527 | 2021-02-28 | Dyer | Tennessee | 47045 | 5234 | 101 |
1072281 | 1072281 | 2021-02-27 | Dyer | Tennessee | 47045 | 5233 | 101 |
1069035 | 1069035 | 2021-02-26 | Dyer | Tennessee | 47045 | 5228 | 101 |
1065790 | 1065790 | 2021-02-25 | Dyer | Tennessee | 47045 | 5225 | 101 |
1062545 | 1062545 | 2021-02-24 | Dyer | Tennessee | 47045 | 5222 | 101 |
1059300 | 1059300 | 2021-02-23 | Dyer | Tennessee | 47045 | 5221 | 100 |
1056054 | 1056054 | 2021-02-22 | Dyer | Tennessee | 47045 | 5220 | 99 |
1052808 | 1052808 | 2021-02-21 | Dyer | Tennessee | 47045 | 5216 | 99 |
1049561 | 1049561 | 2021-02-20 | Dyer | Tennessee | 47045 | 5215 | 99 |
1046314 | 1046314 | 2021-02-19 | Dyer | Tennessee | 47045 | 5213 | 99 |
1043069 | 1043069 | 2021-02-18 | Dyer | Tennessee | 47045 | 5211 | 99 |
1039824 | 1039824 | 2021-02-17 | Dyer | Tennessee | 47045 | 5210 | 98 |
1036579 | 1036579 | 2021-02-16 | Dyer | Tennessee | 47045 | 5209 | 98 |
1033334 | 1033334 | 2021-02-15 | Dyer | Tennessee | 47045 | 5188 | 98 |
1030088 | 1030088 | 2021-02-14 | Dyer | Tennessee | 47045 | 5167 | 97 |
1026841 | 1026841 | 2021-02-13 | Dyer | Tennessee | 47045 | 5149 | 96 |
1023596 | 1023596 | 2021-02-12 | Dyer | Tennessee | 47045 | 5126 | 96 |
1020351 | 1020351 | 2021-02-11 | Dyer | Tennessee | 47045 | 5125 | 96 |
1017106 | 1017106 | 2021-02-10 | Dyer | Tennessee | 47045 | 5088 | 96 |
1013861 | 1013861 | 2021-02-09 | Dyer | Tennessee | 47045 | 5070 | 92 |
1010616 | 1010616 | 2021-02-08 | Dyer | Tennessee | 47045 | 5060 | 93 |
1007370 | 1007370 | 2021-02-07 | Dyer | Tennessee | 47045 | 5059 | 92 |
1004124 | 1004124 | 2021-02-06 | Dyer | Tennessee | 47045 | 5051 | 92 |
1000878 | 1000878 | 2021-02-05 | Dyer | Tennessee | 47045 | 5028 | 92 |
997632 | 997632 | 2021-02-04 | Dyer | Tennessee | 47045 | 5017 | 90 |
994386 | 994386 | 2021-02-03 | Dyer | Tennessee | 47045 | 5006 | 90 |
991140 | 991140 | 2021-02-02 | Dyer | Tennessee | 47045 | 4992 | 90 |
987894 | 987894 | 2021-02-01 | Dyer | Tennessee | 47045 | 4981 | 87 |
984647 | 984647 | 2021-01-31 | Dyer | Tennessee | 47045 | 4976 | 87 |
981400 | 981400 | 2021-01-30 | Dyer | Tennessee | 47045 | 4965 | 87 |
978154 | 978154 | 2021-01-29 | Dyer | Tennessee | 47045 | 4942 | 87 |
974909 | 974909 | 2021-01-28 | Dyer | Tennessee | 47045 | 4910 | 87 |
971664 | 971664 | 2021-01-27 | Dyer | Tennessee | 47045 | 4903 | 87 |
968419 | 968419 | 2021-01-26 | Dyer | Tennessee | 47045 | 4885 | 87 |
965175 | 965175 | 2021-01-25 | Dyer | Tennessee | 47045 | 4874 | 87 |
961930 | 961930 | 2021-01-24 | Dyer | Tennessee | 47045 | 4869 | 86 |
958685 | 958685 | 2021-01-23 | Dyer | Tennessee | 47045 | 4852 | 86 |
955439 | 955439 | 2021-01-22 | Dyer | Tennessee | 47045 | 4833 | 86 |
952194 | 952194 | 2021-01-21 | Dyer | Tennessee | 47045 | 4816 | 87 |
948949 | 948949 | 2021-01-20 | Dyer | Tennessee | 47045 | 4786 | 83 |
945703 | 945703 | 2021-01-19 | Dyer | Tennessee | 47045 | 4772 | 82 |
942456 | 942456 | 2021-01-18 | Dyer | Tennessee | 47045 | 4749 | 82 |
939211 | 939211 | 2021-01-17 | Dyer | Tennessee | 47045 | 4736 | 82 |
935966 | 935966 | 2021-01-16 | Dyer | Tennessee | 47045 | 4715 | 82 |
932721 | 932721 | 2021-01-15 | Dyer | Tennessee | 47045 | 4692 | 81 |
929476 | 929476 | 2021-01-14 | Dyer | Tennessee | 47045 | 4664 | 81 |
926231 | 926231 | 2021-01-13 | Dyer | Tennessee | 47045 | 4642 | 81 |
922985 | 922985 | 2021-01-12 | Dyer | Tennessee | 47045 | 4609 | 81 |
919740 | 919740 | 2021-01-11 | Dyer | Tennessee | 47045 | 4582 | 79 |
916495 | 916495 | 2021-01-10 | Dyer | Tennessee | 47045 | 4571 | 79 |
913250 | 913250 | 2021-01-09 | Dyer | Tennessee | 47045 | 4531 | 79 |
910005 | 910005 | 2021-01-08 | Dyer | Tennessee | 47045 | 4506 | 79 |
906760 | 906760 | 2021-01-07 | Dyer | Tennessee | 47045 | 4478 | 79 |
903514 | 903514 | 2021-01-06 | Dyer | Tennessee | 47045 | 4432 | 75 |
900269 | 900269 | 2021-01-05 | Dyer | Tennessee | 47045 | 4407 | 77 |
897024 | 897024 | 2021-01-04 | Dyer | Tennessee | 47045 | 4368 | 72 |
893778 | 893778 | 2021-01-03 | Dyer | Tennessee | 47045 | 4359 | 70 |
890532 | 890532 | 2021-01-02 | Dyer | Tennessee | 47045 | 4342 | 70 |
887285 | 887285 | 2021-01-01 | Dyer | Tennessee | 47045 | 4254 | 70 |
884040 | 884040 | 2020-12-31 | Dyer | Tennessee | 47045 | 4254 | 70 |
880795 | 880795 | 2020-12-30 | Dyer | Tennessee | 47045 | 4229 | 70 |
877550 | 877550 | 2020-12-29 | Dyer | Tennessee | 47045 | 4172 | 70 |
874305 | 874305 | 2020-12-28 | Dyer | Tennessee | 47045 | 4138 | 68 |
871060 | 871060 | 2020-12-27 | Dyer | Tennessee | 47045 | 4114 | 67 |
867815 | 867815 | 2020-12-26 | Dyer | Tennessee | 47045 | 4089 | 67 |
864570 | 864570 | 2020-12-25 | Dyer | Tennessee | 47045 | 4071 | 67 |
861325 | 861325 | 2020-12-24 | Dyer | Tennessee | 47045 | 4047 | 67 |
858080 | 858080 | 2020-12-23 | Dyer | Tennessee | 47045 | 4033 | 66 |
854835 | 854835 | 2020-12-22 | Dyer | Tennessee | 47045 | 3991 | 66 |
851590 | 851590 | 2020-12-21 | Dyer | Tennessee | 47045 | 3965 | 65 |
848345 | 848345 | 2020-12-20 | Dyer | Tennessee | 47045 | 3934 | 65 |
845100 | 845100 | 2020-12-19 | Dyer | Tennessee | 47045 | 3894 | 65 |
841854 | 841854 | 2020-12-18 | Dyer | Tennessee | 47045 | 3883 | 64 |
838609 | 838609 | 2020-12-17 | Dyer | Tennessee | 47045 | 3840 | 63 |
835363 | 835363 | 2020-12-16 | Dyer | Tennessee | 47045 | 3792 | 63 |
832117 | 832117 | 2020-12-15 | Dyer | Tennessee | 47045 | 3724 | 61 |
828870 | 828870 | 2020-12-14 | Dyer | Tennessee | 47045 | 3691 | 60 |
825624 | 825624 | 2020-12-13 | Dyer | Tennessee | 47045 | 3648 | 60 |
822377 | 822377 | 2020-12-12 | Dyer | Tennessee | 47045 | 3605 | 61 |
819131 | 819131 | 2020-12-11 | Dyer | Tennessee | 47045 | 3570 | 61 |
815885 | 815885 | 2020-12-10 | Dyer | Tennessee | 47045 | 3531 | 59 |
812639 | 812639 | 2020-12-09 | Dyer | Tennessee | 47045 | 3496 | 55 |
809395 | 809395 | 2020-12-08 | Dyer | Tennessee | 47045 | 3454 | 54 |
806150 | 806150 | 2020-12-07 | Dyer | Tennessee | 47045 | 3431 | 53 |
802905 | 802905 | 2020-12-06 | Dyer | Tennessee | 47045 | 3391 | 52 |
799660 | 799660 | 2020-12-05 | Dyer | Tennessee | 47045 | 3363 | 52 |
796415 | 796415 | 2020-12-04 | Dyer | Tennessee | 47045 | 3335 | 52 |
793170 | 793170 | 2020-12-03 | Dyer | Tennessee | 47045 | 3326 | 52 |
789925 | 789925 | 2020-12-02 | Dyer | Tennessee | 47045 | 3293 | 52 |
786680 | 786680 | 2020-12-01 | Dyer | Tennessee | 47045 | 3283 | 52 |
783436 | 783436 | 2020-11-30 | Dyer | Tennessee | 47045 | 3254 | 51 |
780191 | 780191 | 2020-11-29 | Dyer | Tennessee | 47045 | 3220 | 51 |
776945 | 776945 | 2020-11-28 | Dyer | Tennessee | 47045 | 3207 | 51 |
773700 | 773700 | 2020-11-27 | Dyer | Tennessee | 47045 | 3160 | 51 |
770455 | 770455 | 2020-11-26 | Dyer | Tennessee | 47045 | 3147 | 51 |
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);