ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Gibson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091759 | 1091759 | 2021-03-05 | Gibson | Tennessee | 47053 | 6197 | 141 |
1088513 | 1088513 | 2021-03-04 | Gibson | Tennessee | 47053 | 6196 | 141 |
1085268 | 1085268 | 2021-03-03 | Gibson | Tennessee | 47053 | 6196 | 141 |
1082022 | 1082022 | 2021-03-02 | Gibson | Tennessee | 47053 | 6188 | 141 |
1078776 | 1078776 | 2021-03-01 | Gibson | Tennessee | 47053 | 6187 | 140 |
1075531 | 1075531 | 2021-02-28 | Gibson | Tennessee | 47053 | 6187 | 140 |
1072285 | 1072285 | 2021-02-27 | Gibson | Tennessee | 47053 | 6181 | 140 |
1069039 | 1069039 | 2021-02-26 | Gibson | Tennessee | 47053 | 6178 | 140 |
1065794 | 1065794 | 2021-02-25 | Gibson | Tennessee | 47053 | 6174 | 140 |
1062549 | 1062549 | 2021-02-24 | Gibson | Tennessee | 47053 | 6168 | 140 |
1059304 | 1059304 | 2021-02-23 | Gibson | Tennessee | 47053 | 6166 | 140 |
1056058 | 1056058 | 2021-02-22 | Gibson | Tennessee | 47053 | 6153 | 139 |
1052812 | 1052812 | 2021-02-21 | Gibson | Tennessee | 47053 | 6151 | 139 |
1049565 | 1049565 | 2021-02-20 | Gibson | Tennessee | 47053 | 6146 | 138 |
1046318 | 1046318 | 2021-02-19 | Gibson | Tennessee | 47053 | 6144 | 138 |
1043073 | 1043073 | 2021-02-18 | Gibson | Tennessee | 47053 | 6140 | 138 |
1039828 | 1039828 | 2021-02-17 | Gibson | Tennessee | 47053 | 6141 | 138 |
1036583 | 1036583 | 2021-02-16 | Gibson | Tennessee | 47053 | 6139 | 138 |
1033338 | 1033338 | 2021-02-15 | Gibson | Tennessee | 47053 | 6116 | 138 |
1030092 | 1030092 | 2021-02-14 | Gibson | Tennessee | 47053 | 6095 | 138 |
1026845 | 1026845 | 2021-02-13 | Gibson | Tennessee | 47053 | 6060 | 137 |
1023600 | 1023600 | 2021-02-12 | Gibson | Tennessee | 47053 | 6029 | 137 |
1020355 | 1020355 | 2021-02-11 | Gibson | Tennessee | 47053 | 6022 | 137 |
1017110 | 1017110 | 2021-02-10 | Gibson | Tennessee | 47053 | 5973 | 130 |
1013865 | 1013865 | 2021-02-09 | Gibson | Tennessee | 47053 | 5987 | 129 |
1010620 | 1010620 | 2021-02-08 | Gibson | Tennessee | 47053 | 5994 | 129 |
1007374 | 1007374 | 2021-02-07 | Gibson | Tennessee | 47053 | 5980 | 129 |
1004128 | 1004128 | 2021-02-06 | Gibson | Tennessee | 47053 | 5967 | 129 |
1000882 | 1000882 | 2021-02-05 | Gibson | Tennessee | 47053 | 5943 | 129 |
997636 | 997636 | 2021-02-04 | Gibson | Tennessee | 47053 | 5931 | 128 |
994390 | 994390 | 2021-02-03 | Gibson | Tennessee | 47053 | 5916 | 127 |
991144 | 991144 | 2021-02-02 | Gibson | Tennessee | 47053 | 5909 | 126 |
987898 | 987898 | 2021-02-01 | Gibson | Tennessee | 47053 | 5897 | 123 |
984651 | 984651 | 2021-01-31 | Gibson | Tennessee | 47053 | 5884 | 122 |
981404 | 981404 | 2021-01-30 | Gibson | Tennessee | 47053 | 5864 | 122 |
978158 | 978158 | 2021-01-29 | Gibson | Tennessee | 47053 | 5855 | 122 |
974913 | 974913 | 2021-01-28 | Gibson | Tennessee | 47053 | 5800 | 122 |
971668 | 971668 | 2021-01-27 | Gibson | Tennessee | 47053 | 5786 | 119 |
968423 | 968423 | 2021-01-26 | Gibson | Tennessee | 47053 | 5777 | 118 |
965179 | 965179 | 2021-01-25 | Gibson | Tennessee | 47053 | 5767 | 117 |
961934 | 961934 | 2021-01-24 | Gibson | Tennessee | 47053 | 5761 | 116 |
958689 | 958689 | 2021-01-23 | Gibson | Tennessee | 47053 | 5739 | 116 |
955443 | 955443 | 2021-01-22 | Gibson | Tennessee | 47053 | 5733 | 114 |
952198 | 952198 | 2021-01-21 | Gibson | Tennessee | 47053 | 5701 | 114 |
948953 | 948953 | 2021-01-20 | Gibson | Tennessee | 47053 | 5671 | 112 |
945707 | 945707 | 2021-01-19 | Gibson | Tennessee | 47053 | 5656 | 111 |
942460 | 942460 | 2021-01-18 | Gibson | Tennessee | 47053 | 5639 | 111 |
939215 | 939215 | 2021-01-17 | Gibson | Tennessee | 47053 | 5630 | 111 |
935970 | 935970 | 2021-01-16 | Gibson | Tennessee | 47053 | 5594 | 111 |
932725 | 932725 | 2021-01-15 | Gibson | Tennessee | 47053 | 5571 | 111 |
929480 | 929480 | 2021-01-14 | Gibson | Tennessee | 47053 | 5534 | 109 |
926235 | 926235 | 2021-01-13 | Gibson | Tennessee | 47053 | 5521 | 108 |
922989 | 922989 | 2021-01-12 | Gibson | Tennessee | 47053 | 5490 | 107 |
919744 | 919744 | 2021-01-11 | Gibson | Tennessee | 47053 | 5453 | 104 |
916499 | 916499 | 2021-01-10 | Gibson | Tennessee | 47053 | 5441 | 102 |
913254 | 913254 | 2021-01-09 | Gibson | Tennessee | 47053 | 5385 | 102 |
910009 | 910009 | 2021-01-08 | Gibson | Tennessee | 47053 | 5352 | 97 |
906764 | 906764 | 2021-01-07 | Gibson | Tennessee | 47053 | 5327 | 98 |
903518 | 903518 | 2021-01-06 | Gibson | Tennessee | 47053 | 5271 | 95 |
900273 | 900273 | 2021-01-05 | Gibson | Tennessee | 47053 | 5218 | 95 |
897028 | 897028 | 2021-01-04 | Gibson | Tennessee | 47053 | 5183 | 93 |
893782 | 893782 | 2021-01-03 | Gibson | Tennessee | 47053 | 5165 | 93 |
890536 | 890536 | 2021-01-02 | Gibson | Tennessee | 47053 | 5133 | 93 |
887289 | 887289 | 2021-01-01 | Gibson | Tennessee | 47053 | 5033 | 91 |
884044 | 884044 | 2020-12-31 | Gibson | Tennessee | 47053 | 5033 | 91 |
880799 | 880799 | 2020-12-30 | Gibson | Tennessee | 47053 | 5000 | 90 |
877554 | 877554 | 2020-12-29 | Gibson | Tennessee | 47053 | 4928 | 88 |
874309 | 874309 | 2020-12-28 | Gibson | Tennessee | 47053 | 4871 | 87 |
871064 | 871064 | 2020-12-27 | Gibson | Tennessee | 47053 | 4856 | 87 |
867819 | 867819 | 2020-12-26 | Gibson | Tennessee | 47053 | 4801 | 87 |
864574 | 864574 | 2020-12-25 | Gibson | Tennessee | 47053 | 4763 | 87 |
861329 | 861329 | 2020-12-24 | Gibson | Tennessee | 47053 | 4699 | 87 |
858084 | 858084 | 2020-12-23 | Gibson | Tennessee | 47053 | 4645 | 87 |
854839 | 854839 | 2020-12-22 | Gibson | Tennessee | 47053 | 4614 | 87 |
851594 | 851594 | 2020-12-21 | Gibson | Tennessee | 47053 | 4577 | 82 |
848349 | 848349 | 2020-12-20 | Gibson | Tennessee | 47053 | 4457 | 81 |
845104 | 845104 | 2020-12-19 | Gibson | Tennessee | 47053 | 4404 | 81 |
841858 | 841858 | 2020-12-18 | Gibson | Tennessee | 47053 | 4372 | 81 |
838613 | 838613 | 2020-12-17 | Gibson | Tennessee | 47053 | 4288 | 80 |
835367 | 835367 | 2020-12-16 | Gibson | Tennessee | 47053 | 4209 | 80 |
832121 | 832121 | 2020-12-15 | Gibson | Tennessee | 47053 | 4105 | 79 |
828874 | 828874 | 2020-12-14 | Gibson | Tennessee | 47053 | 4058 | 78 |
825628 | 825628 | 2020-12-13 | Gibson | Tennessee | 47053 | 3967 | 77 |
822381 | 822381 | 2020-12-12 | Gibson | Tennessee | 47053 | 3893 | 77 |
819135 | 819135 | 2020-12-11 | Gibson | Tennessee | 47053 | 3841 | 76 |
815889 | 815889 | 2020-12-10 | Gibson | Tennessee | 47053 | 3798 | 75 |
812643 | 812643 | 2020-12-09 | Gibson | Tennessee | 47053 | 3757 | 75 |
809399 | 809399 | 2020-12-08 | Gibson | Tennessee | 47053 | 3661 | 73 |
806154 | 806154 | 2020-12-07 | Gibson | Tennessee | 47053 | 3601 | 72 |
802909 | 802909 | 2020-12-06 | Gibson | Tennessee | 47053 | 3540 | 72 |
799664 | 799664 | 2020-12-05 | Gibson | Tennessee | 47053 | 3496 | 72 |
796419 | 796419 | 2020-12-04 | Gibson | Tennessee | 47053 | 3446 | 72 |
793174 | 793174 | 2020-12-03 | Gibson | Tennessee | 47053 | 3393 | 72 |
789929 | 789929 | 2020-12-02 | Gibson | Tennessee | 47053 | 3370 | 70 |
786684 | 786684 | 2020-12-01 | Gibson | Tennessee | 47053 | 3340 | 68 |
783440 | 783440 | 2020-11-30 | Gibson | Tennessee | 47053 | 3320 | 65 |
780195 | 780195 | 2020-11-29 | Gibson | Tennessee | 47053 | 3242 | 65 |
776949 | 776949 | 2020-11-28 | Gibson | Tennessee | 47053 | 3233 | 65 |
773704 | 773704 | 2020-11-27 | Gibson | Tennessee | 47053 | 3150 | 64 |
770459 | 770459 | 2020-11-26 | Gibson | Tennessee | 47053 | 3119 | 65 |
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);