ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Franklin" and fips = 53021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1196178 | 1196178 | 2021-04-06 | Franklin | Washington | 53021 | 11654 | 105 |
1192930 | 1192930 | 2021-04-05 | Franklin | Washington | 53021 | 11645 | 105 |
1189680 | 1189680 | 2021-04-04 | Franklin | Washington | 53021 | 11632 | 105 |
1186433 | 1186433 | 2021-04-03 | Franklin | Washington | 53021 | 11632 | 105 |
1183186 | 1183186 | 2021-04-02 | Franklin | Washington | 53021 | 11622 | 105 |
1179939 | 1179939 | 2021-04-01 | Franklin | Washington | 53021 | 11605 | 105 |
1176692 | 1176692 | 2021-03-31 | Franklin | Washington | 53021 | 11588 | 105 |
1173445 | 1173445 | 2021-03-30 | Franklin | Washington | 53021 | 11565 | 103 |
1170198 | 1170198 | 2021-03-29 | Franklin | Washington | 53021 | 11545 | 103 |
1166950 | 1166950 | 2021-03-28 | Franklin | Washington | 53021 | 11531 | 103 |
1163702 | 1163702 | 2021-03-27 | Franklin | Washington | 53021 | 11531 | 103 |
1160454 | 1160454 | 2021-03-26 | Franklin | Washington | 53021 | 11517 | 103 |
1157206 | 1157206 | 2021-03-25 | Franklin | Washington | 53021 | 11503 | 103 |
1153959 | 1153959 | 2021-03-24 | Franklin | Washington | 53021 | 11487 | 103 |
1150712 | 1150712 | 2021-03-23 | Franklin | Washington | 53021 | 11477 | 103 |
1147465 | 1147465 | 2021-03-22 | Franklin | Washington | 53021 | 11457 | 103 |
1144218 | 1144218 | 2021-03-21 | Franklin | Washington | 53021 | 11443 | 103 |
1140971 | 1140971 | 2021-03-20 | Franklin | Washington | 53021 | 11443 | 103 |
1137725 | 1137725 | 2021-03-19 | Franklin | Washington | 53021 | 11416 | 103 |
1134479 | 1134479 | 2021-03-18 | Franklin | Washington | 53021 | 11407 | 103 |
1131231 | 1131231 | 2021-03-17 | Franklin | Washington | 53021 | 11398 | 103 |
1127984 | 1127984 | 2021-03-16 | Franklin | Washington | 53021 | 11385 | 103 |
1124738 | 1124738 | 2021-03-15 | Franklin | Washington | 53021 | 11370 | 103 |
1121492 | 1121492 | 2021-03-14 | Franklin | Washington | 53021 | 11349 | 103 |
1118245 | 1118245 | 2021-03-13 | Franklin | Washington | 53021 | 11349 | 103 |
1114998 | 1114998 | 2021-03-12 | Franklin | Washington | 53021 | 11323 | 103 |
1111752 | 1111752 | 2021-03-11 | Franklin | Washington | 53021 | 11318 | 101 |
1108506 | 1108506 | 2021-03-10 | Franklin | Washington | 53021 | 11289 | 101 |
1105260 | 1105260 | 2021-03-09 | Franklin | Washington | 53021 | 11281 | 101 |
1102014 | 1102014 | 2021-03-08 | Franklin | Washington | 53021 | 11268 | 101 |
1098768 | 1098768 | 2021-03-07 | Franklin | Washington | 53021 | 11247 | 101 |
1095520 | 1095520 | 2021-03-06 | Franklin | Washington | 53021 | 11247 | 101 |
1092274 | 1092274 | 2021-03-05 | Franklin | Washington | 53021 | 11229 | 101 |
1089028 | 1089028 | 2021-03-04 | Franklin | Washington | 53021 | 11211 | 100 |
1085783 | 1085783 | 2021-03-03 | Franklin | Washington | 53021 | 11192 | 100 |
1082537 | 1082537 | 2021-03-02 | Franklin | Washington | 53021 | 11156 | 100 |
1079291 | 1079291 | 2021-03-01 | Franklin | Washington | 53021 | 11143 | 100 |
1076046 | 1076046 | 2021-02-28 | Franklin | Washington | 53021 | 11113 | 100 |
1072800 | 1072800 | 2021-02-27 | Franklin | Washington | 53021 | 11113 | 100 |
1069554 | 1069554 | 2021-02-26 | Franklin | Washington | 53021 | 11100 | 100 |
1066309 | 1066309 | 2021-02-25 | Franklin | Washington | 53021 | 11083 | 99 |
1063064 | 1063064 | 2021-02-24 | Franklin | Washington | 53021 | 11061 | 99 |
1059819 | 1059819 | 2021-02-23 | Franklin | Washington | 53021 | 11031 | 98 |
1056573 | 1056573 | 2021-02-22 | Franklin | Washington | 53021 | 11022 | 98 |
1053327 | 1053327 | 2021-02-21 | Franklin | Washington | 53021 | 10991 | 97 |
1050080 | 1050080 | 2021-02-20 | Franklin | Washington | 53021 | 10991 | 97 |
1046833 | 1046833 | 2021-02-19 | Franklin | Washington | 53021 | 10974 | 97 |
1043588 | 1043588 | 2021-02-18 | Franklin | Washington | 53021 | 10940 | 97 |
1040343 | 1040343 | 2021-02-17 | Franklin | Washington | 53021 | 10891 | 97 |
1037098 | 1037098 | 2021-02-16 | Franklin | Washington | 53021 | 10875 | 97 |
1033853 | 1033853 | 2021-02-15 | Franklin | Washington | 53021 | 10855 | 97 |
1030607 | 1030607 | 2021-02-14 | Franklin | Washington | 53021 | 10855 | 97 |
1027360 | 1027360 | 2021-02-13 | Franklin | Washington | 53021 | 10855 | 97 |
1024115 | 1024115 | 2021-02-12 | Franklin | Washington | 53021 | 10824 | 97 |
1020870 | 1020870 | 2021-02-11 | Franklin | Washington | 53021 | 10785 | 97 |
1017625 | 1017625 | 2021-02-10 | Franklin | Washington | 53021 | 10733 | 97 |
1014380 | 1014380 | 2021-02-09 | Franklin | Washington | 53021 | 10714 | 97 |
1011135 | 1011135 | 2021-02-08 | Franklin | Washington | 53021 | 10689 | 95 |
1007889 | 1007889 | 2021-02-07 | Franklin | Washington | 53021 | 10622 | 95 |
1004643 | 1004643 | 2021-02-06 | Franklin | Washington | 53021 | 10622 | 95 |
1001397 | 1001397 | 2021-02-05 | Franklin | Washington | 53021 | 10618 | 95 |
998151 | 998151 | 2021-02-04 | Franklin | Washington | 53021 | 10560 | 95 |
994905 | 994905 | 2021-02-03 | Franklin | Washington | 53021 | 10540 | 95 |
991659 | 991659 | 2021-02-02 | Franklin | Washington | 53021 | 10483 | 94 |
988413 | 988413 | 2021-02-01 | Franklin | Washington | 53021 | 10466 | 94 |
985166 | 985166 | 2021-01-31 | Franklin | Washington | 53021 | 10166 | 90 |
981919 | 981919 | 2021-01-30 | Franklin | Washington | 53021 | 10166 | 90 |
978673 | 978673 | 2021-01-29 | Franklin | Washington | 53021 | 10139 | 90 |
975428 | 975428 | 2021-01-28 | Franklin | Washington | 53021 | 10095 | 90 |
972183 | 972183 | 2021-01-27 | Franklin | Washington | 53021 | 10048 | 90 |
968938 | 968938 | 2021-01-26 | Franklin | Washington | 53021 | 10018 | 90 |
965694 | 965694 | 2021-01-25 | Franklin | Washington | 53021 | 9981 | 90 |
962449 | 962449 | 2021-01-24 | Franklin | Washington | 53021 | 9927 | 88 |
959204 | 959204 | 2021-01-23 | Franklin | Washington | 53021 | 9927 | 88 |
955958 | 955958 | 2021-01-22 | Franklin | Washington | 53021 | 9885 | 88 |
952713 | 952713 | 2021-01-21 | Franklin | Washington | 53021 | 9847 | 88 |
949468 | 949468 | 2021-01-20 | Franklin | Washington | 53021 | 9795 | 87 |
946222 | 946222 | 2021-01-19 | Franklin | Washington | 53021 | 9753 | 87 |
942975 | 942975 | 2021-01-18 | Franklin | Washington | 53021 | 9711 | 87 |
939730 | 939730 | 2021-01-17 | Franklin | Washington | 53021 | 9711 | 87 |
936485 | 936485 | 2021-01-16 | Franklin | Washington | 53021 | 9622 | 87 |
933240 | 933240 | 2021-01-15 | Franklin | Washington | 53021 | 9622 | 87 |
929995 | 929995 | 2021-01-14 | Franklin | Washington | 53021 | 9586 | 87 |
926750 | 926750 | 2021-01-13 | Franklin | Washington | 53021 | 9526 | 87 |
923504 | 923504 | 2021-01-12 | Franklin | Washington | 53021 | 9477 | 87 |
920259 | 920259 | 2021-01-11 | Franklin | Washington | 53021 | 9432 | 86 |
917014 | 917014 | 2021-01-10 | Franklin | Washington | 53021 | 9321 | 86 |
913769 | 913769 | 2021-01-09 | Franklin | Washington | 53021 | 9321 | 86 |
910524 | 910524 | 2021-01-08 | Franklin | Washington | 53021 | 9267 | 86 |
907279 | 907279 | 2021-01-07 | Franklin | Washington | 53021 | 9156 | 86 |
904033 | 904033 | 2021-01-06 | Franklin | Washington | 53021 | 9082 | 86 |
900788 | 900788 | 2021-01-05 | Franklin | Washington | 53021 | 9040 | 84 |
897543 | 897543 | 2021-01-04 | Franklin | Washington | 53021 | 9001 | 83 |
894297 | 894297 | 2021-01-03 | Franklin | Washington | 53021 | 8939 | 83 |
891051 | 891051 | 2021-01-02 | Franklin | Washington | 53021 | 8772 | 83 |
887804 | 887804 | 2021-01-01 | Franklin | Washington | 53021 | 8772 | 83 |
884559 | 884559 | 2020-12-31 | Franklin | Washington | 53021 | 8772 | 83 |
881314 | 881314 | 2020-12-30 | Franklin | Washington | 53021 | 8649 | 83 |
878069 | 878069 | 2020-12-29 | Franklin | Washington | 53021 | 8623 | 82 |
874824 | 874824 | 2020-12-28 | Franklin | Washington | 53021 | 8586 | 79 |
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);