ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Dickson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091754 | 1091754 | 2021-03-05 | Dickson | Tennessee | 47043 | 6274 | 106 |
1088508 | 1088508 | 2021-03-04 | Dickson | Tennessee | 47043 | 6256 | 106 |
1085263 | 1085263 | 2021-03-03 | Dickson | Tennessee | 47043 | 6239 | 106 |
1082017 | 1082017 | 2021-03-02 | Dickson | Tennessee | 47043 | 6228 | 106 |
1078771 | 1078771 | 2021-03-01 | Dickson | Tennessee | 47043 | 6217 | 106 |
1075526 | 1075526 | 2021-02-28 | Dickson | Tennessee | 47043 | 6205 | 106 |
1072280 | 1072280 | 2021-02-27 | Dickson | Tennessee | 47043 | 6197 | 106 |
1069034 | 1069034 | 2021-02-26 | Dickson | Tennessee | 47043 | 6183 | 106 |
1065789 | 1065789 | 2021-02-25 | Dickson | Tennessee | 47043 | 6169 | 103 |
1062544 | 1062544 | 2021-02-24 | Dickson | Tennessee | 47043 | 6148 | 103 |
1059299 | 1059299 | 2021-02-23 | Dickson | Tennessee | 47043 | 6118 | 103 |
1056053 | 1056053 | 2021-02-22 | Dickson | Tennessee | 47043 | 6103 | 102 |
1052807 | 1052807 | 2021-02-21 | Dickson | Tennessee | 47043 | 6096 | 102 |
1049560 | 1049560 | 2021-02-20 | Dickson | Tennessee | 47043 | 6088 | 102 |
1046313 | 1046313 | 2021-02-19 | Dickson | Tennessee | 47043 | 6064 | 102 |
1043068 | 1043068 | 2021-02-18 | Dickson | Tennessee | 47043 | 6053 | 102 |
1039823 | 1039823 | 2021-02-17 | Dickson | Tennessee | 47043 | 6044 | 102 |
1036578 | 1036578 | 2021-02-16 | Dickson | Tennessee | 47043 | 6035 | 102 |
1033333 | 1033333 | 2021-02-15 | Dickson | Tennessee | 47043 | 6026 | 102 |
1030087 | 1030087 | 2021-02-14 | Dickson | Tennessee | 47043 | 6018 | 102 |
1026840 | 1026840 | 2021-02-13 | Dickson | Tennessee | 47043 | 6015 | 102 |
1023595 | 1023595 | 2021-02-12 | Dickson | Tennessee | 47043 | 5997 | 102 |
1020350 | 1020350 | 2021-02-11 | Dickson | Tennessee | 47043 | 5953 | 100 |
1017105 | 1017105 | 2021-02-10 | Dickson | Tennessee | 47043 | 5915 | 99 |
1013860 | 1013860 | 2021-02-09 | Dickson | Tennessee | 47043 | 5900 | 98 |
1010615 | 1010615 | 2021-02-08 | Dickson | Tennessee | 47043 | 5895 | 98 |
1007369 | 1007369 | 2021-02-07 | Dickson | Tennessee | 47043 | 5892 | 98 |
1004123 | 1004123 | 2021-02-06 | Dickson | Tennessee | 47043 | 5882 | 98 |
1000877 | 1000877 | 2021-02-05 | Dickson | Tennessee | 47043 | 5861 | 98 |
997631 | 997631 | 2021-02-04 | Dickson | Tennessee | 47043 | 5844 | 92 |
994385 | 994385 | 2021-02-03 | Dickson | Tennessee | 47043 | 5825 | 92 |
991139 | 991139 | 2021-02-02 | Dickson | Tennessee | 47043 | 5784 | 90 |
987893 | 987893 | 2021-02-01 | Dickson | Tennessee | 47043 | 5773 | 87 |
984646 | 984646 | 2021-01-31 | Dickson | Tennessee | 47043 | 5760 | 87 |
981399 | 981399 | 2021-01-30 | Dickson | Tennessee | 47043 | 5743 | 86 |
978153 | 978153 | 2021-01-29 | Dickson | Tennessee | 47043 | 5724 | 85 |
974908 | 974908 | 2021-01-28 | Dickson | Tennessee | 47043 | 5631 | 85 |
971663 | 971663 | 2021-01-27 | Dickson | Tennessee | 47043 | 5624 | 85 |
968418 | 968418 | 2021-01-26 | Dickson | Tennessee | 47043 | 5602 | 85 |
965174 | 965174 | 2021-01-25 | Dickson | Tennessee | 47043 | 5590 | 82 |
961929 | 961929 | 2021-01-24 | Dickson | Tennessee | 47043 | 5584 | 82 |
958684 | 958684 | 2021-01-23 | Dickson | Tennessee | 47043 | 5570 | 82 |
955438 | 955438 | 2021-01-22 | Dickson | Tennessee | 47043 | 5526 | 82 |
952193 | 952193 | 2021-01-21 | Dickson | Tennessee | 47043 | 5495 | 80 |
948948 | 948948 | 2021-01-20 | Dickson | Tennessee | 47043 | 5435 | 79 |
945702 | 945702 | 2021-01-19 | Dickson | Tennessee | 47043 | 5404 | 79 |
942455 | 942455 | 2021-01-18 | Dickson | Tennessee | 47043 | 5363 | 78 |
939210 | 939210 | 2021-01-17 | Dickson | Tennessee | 47043 | 5346 | 78 |
935965 | 935965 | 2021-01-16 | Dickson | Tennessee | 47043 | 5326 | 77 |
932720 | 932720 | 2021-01-15 | Dickson | Tennessee | 47043 | 5292 | 77 |
929475 | 929475 | 2021-01-14 | Dickson | Tennessee | 47043 | 5247 | 77 |
926230 | 926230 | 2021-01-13 | Dickson | Tennessee | 47043 | 5196 | 75 |
922984 | 922984 | 2021-01-12 | Dickson | Tennessee | 47043 | 5156 | 75 |
919739 | 919739 | 2021-01-11 | Dickson | Tennessee | 47043 | 5133 | 74 |
916494 | 916494 | 2021-01-10 | Dickson | Tennessee | 47043 | 5120 | 74 |
913249 | 913249 | 2021-01-09 | Dickson | Tennessee | 47043 | 5083 | 72 |
910004 | 910004 | 2021-01-08 | Dickson | Tennessee | 47043 | 5041 | 70 |
906759 | 906759 | 2021-01-07 | Dickson | Tennessee | 47043 | 4977 | 68 |
903513 | 903513 | 2021-01-06 | Dickson | Tennessee | 47043 | 4927 | 68 |
900268 | 900268 | 2021-01-05 | Dickson | Tennessee | 47043 | 4859 | 65 |
897023 | 897023 | 2021-01-04 | Dickson | Tennessee | 47043 | 4828 | 63 |
893777 | 893777 | 2021-01-03 | Dickson | Tennessee | 47043 | 4803 | 61 |
890531 | 890531 | 2021-01-02 | Dickson | Tennessee | 47043 | 4770 | 61 |
887284 | 887284 | 2021-01-01 | Dickson | Tennessee | 47043 | 4624 | 59 |
884039 | 884039 | 2020-12-31 | Dickson | Tennessee | 47043 | 4624 | 59 |
880794 | 880794 | 2020-12-30 | Dickson | Tennessee | 47043 | 4593 | 59 |
877549 | 877549 | 2020-12-29 | Dickson | Tennessee | 47043 | 4545 | 59 |
874304 | 874304 | 2020-12-28 | Dickson | Tennessee | 47043 | 4505 | 58 |
871059 | 871059 | 2020-12-27 | Dickson | Tennessee | 47043 | 4486 | 58 |
867814 | 867814 | 2020-12-26 | Dickson | Tennessee | 47043 | 4464 | 57 |
864569 | 864569 | 2020-12-25 | Dickson | Tennessee | 47043 | 4424 | 57 |
861324 | 861324 | 2020-12-24 | Dickson | Tennessee | 47043 | 4385 | 57 |
858079 | 858079 | 2020-12-23 | Dickson | Tennessee | 47043 | 4327 | 57 |
854834 | 854834 | 2020-12-22 | Dickson | Tennessee | 47043 | 4264 | 53 |
851589 | 851589 | 2020-12-21 | Dickson | Tennessee | 47043 | 4190 | 53 |
848344 | 848344 | 2020-12-20 | Dickson | Tennessee | 47043 | 4123 | 51 |
845099 | 845099 | 2020-12-19 | Dickson | Tennessee | 47043 | 4061 | 51 |
841853 | 841853 | 2020-12-18 | Dickson | Tennessee | 47043 | 4026 | 51 |
838608 | 838608 | 2020-12-17 | Dickson | Tennessee | 47043 | 3937 | 50 |
835362 | 835362 | 2020-12-16 | Dickson | Tennessee | 47043 | 3873 | 48 |
832116 | 832116 | 2020-12-15 | Dickson | Tennessee | 47043 | 3773 | 48 |
828869 | 828869 | 2020-12-14 | Dickson | Tennessee | 47043 | 3721 | 47 |
825623 | 825623 | 2020-12-13 | Dickson | Tennessee | 47043 | 3590 | 47 |
822376 | 822376 | 2020-12-12 | Dickson | Tennessee | 47043 | 3502 | 46 |
819130 | 819130 | 2020-12-11 | Dickson | Tennessee | 47043 | 3420 | 41 |
815884 | 815884 | 2020-12-10 | Dickson | Tennessee | 47043 | 3382 | 41 |
812638 | 812638 | 2020-12-09 | Dickson | Tennessee | 47043 | 3322 | 41 |
809394 | 809394 | 2020-12-08 | Dickson | Tennessee | 47043 | 3231 | 40 |
806149 | 806149 | 2020-12-07 | Dickson | Tennessee | 47043 | 3174 | 40 |
802904 | 802904 | 2020-12-06 | Dickson | Tennessee | 47043 | 3136 | 39 |
799659 | 799659 | 2020-12-05 | Dickson | Tennessee | 47043 | 3098 | 39 |
796414 | 796414 | 2020-12-04 | Dickson | Tennessee | 47043 | 3078 | 39 |
793169 | 793169 | 2020-12-03 | Dickson | Tennessee | 47043 | 3050 | 37 |
789924 | 789924 | 2020-12-02 | Dickson | Tennessee | 47043 | 3038 | 35 |
786679 | 786679 | 2020-12-01 | Dickson | Tennessee | 47043 | 3025 | 35 |
783435 | 783435 | 2020-11-30 | Dickson | Tennessee | 47043 | 3004 | 34 |
780190 | 780190 | 2020-11-29 | Dickson | Tennessee | 47043 | 2938 | 34 |
776944 | 776944 | 2020-11-28 | Dickson | Tennessee | 47043 | 2891 | 33 |
773699 | 773699 | 2020-11-27 | Dickson | Tennessee | 47043 | 2848 | 33 |
770454 | 770454 | 2020-11-26 | Dickson | Tennessee | 47043 | 2810 | 33 |
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);