ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Franklin" and fips = 29071 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194640 | 1194640 | 2021-04-06 | Franklin | Missouri | 29071 | 10467 | 177 |
1191391 | 1191391 | 2021-04-05 | Franklin | Missouri | 29071 | 10461 | 177 |
1188143 | 1188143 | 2021-04-04 | Franklin | Missouri | 29071 | 10449 | 177 |
1184896 | 1184896 | 2021-04-03 | Franklin | Missouri | 29071 | 10435 | 177 |
1181650 | 1181650 | 2021-04-02 | Franklin | Missouri | 29071 | 10426 | 177 |
1178403 | 1178403 | 2021-04-01 | Franklin | Missouri | 29071 | 10414 | 177 |
1175156 | 1175156 | 2021-03-31 | Franklin | Missouri | 29071 | 10397 | 177 |
1171909 | 1171909 | 2021-03-30 | Franklin | Missouri | 29071 | 10377 | 177 |
1168661 | 1168661 | 2021-03-29 | Franklin | Missouri | 29071 | 10367 | 176 |
1165413 | 1165413 | 2021-03-28 | Franklin | Missouri | 29071 | 10358 | 176 |
1162165 | 1162165 | 2021-03-27 | Franklin | Missouri | 29071 | 10334 | 176 |
1158917 | 1158917 | 2021-03-26 | Franklin | Missouri | 29071 | 10324 | 176 |
1155670 | 1155670 | 2021-03-25 | Franklin | Missouri | 29071 | 10315 | 176 |
1152423 | 1152423 | 2021-03-24 | Franklin | Missouri | 29071 | 10308 | 176 |
1149176 | 1149176 | 2021-03-23 | Franklin | Missouri | 29071 | 10287 | 171 |
1145929 | 1145929 | 2021-03-22 | Franklin | Missouri | 29071 | 10277 | 170 |
1142682 | 1142682 | 2021-03-21 | Franklin | Missouri | 29071 | 10271 | 170 |
1139435 | 1139435 | 2021-03-20 | Franklin | Missouri | 29071 | 10262 | 170 |
1136189 | 1136189 | 2021-03-19 | Franklin | Missouri | 29071 | 10253 | 170 |
1132943 | 1132943 | 2021-03-18 | Franklin | Missouri | 29071 | 10234 | 170 |
1129695 | 1129695 | 2021-03-17 | Franklin | Missouri | 29071 | 10220 | 170 |
1126448 | 1126448 | 2021-03-16 | Franklin | Missouri | 29071 | 10199 | 170 |
1123202 | 1123202 | 2021-03-15 | Franklin | Missouri | 29071 | 10188 | 168 |
1119955 | 1119955 | 2021-03-14 | Franklin | Missouri | 29071 | 10173 | 168 |
1116708 | 1116708 | 2021-03-13 | Franklin | Missouri | 29071 | 10160 | 168 |
1113462 | 1113462 | 2021-03-12 | Franklin | Missouri | 29071 | 10141 | 168 |
1110216 | 1110216 | 2021-03-11 | Franklin | Missouri | 29071 | 10115 | 168 |
1106970 | 1106970 | 2021-03-10 | Franklin | Missouri | 29071 | 10093 | 168 |
1103724 | 1103724 | 2021-03-09 | Franklin | Missouri | 29071 | 10073 | 168 |
1100478 | 1100478 | 2021-03-08 | Franklin | Missouri | 29071 | 10059 | 164 |
1097231 | 1097231 | 2021-03-07 | Franklin | Missouri | 29071 | 8458 | 164 |
1093984 | 1093984 | 2021-03-06 | Franklin | Missouri | 29071 | 8455 | 164 |
1090738 | 1090738 | 2021-03-05 | Franklin | Missouri | 29071 | 8449 | 164 |
1087493 | 1087493 | 2021-03-04 | Franklin | Missouri | 29071 | 8444 | 164 |
1084248 | 1084248 | 2021-03-03 | Franklin | Missouri | 29071 | 8435 | 164 |
1081002 | 1081002 | 2021-03-02 | Franklin | Missouri | 29071 | 8427 | 154 |
1077756 | 1077756 | 2021-03-01 | Franklin | Missouri | 29071 | 8423 | 154 |
1074510 | 1074510 | 2021-02-28 | Franklin | Missouri | 29071 | 8418 | 154 |
1071264 | 1071264 | 2021-02-27 | Franklin | Missouri | 29071 | 8415 | 154 |
1068019 | 1068019 | 2021-02-26 | Franklin | Missouri | 29071 | 8409 | 154 |
1064774 | 1064774 | 2021-02-25 | Franklin | Missouri | 29071 | 8402 | 154 |
1061530 | 1061530 | 2021-02-24 | Franklin | Missouri | 29071 | 8388 | 154 |
1058284 | 1058284 | 2021-02-23 | Franklin | Missouri | 29071 | 8380 | 154 |
1055038 | 1055038 | 2021-02-22 | Franklin | Missouri | 29071 | 8375 | 153 |
1051791 | 1051791 | 2021-02-21 | Franklin | Missouri | 29071 | 8358 | 153 |
1048544 | 1048544 | 2021-02-20 | Franklin | Missouri | 29071 | 8348 | 153 |
1045298 | 1045298 | 2021-02-19 | Franklin | Missouri | 29071 | 8341 | 153 |
1042053 | 1042053 | 2021-02-18 | Franklin | Missouri | 29071 | 8322 | 153 |
1038808 | 1038808 | 2021-02-17 | Franklin | Missouri | 29071 | 8305 | 149 |
1035563 | 1035563 | 2021-02-16 | Franklin | Missouri | 29071 | 8301 | 149 |
1032318 | 1032318 | 2021-02-15 | Franklin | Missouri | 29071 | 8291 | 149 |
1029071 | 1029071 | 2021-02-14 | Franklin | Missouri | 29071 | 8272 | 149 |
1025825 | 1025825 | 2021-02-13 | Franklin | Missouri | 29071 | 8264 | 149 |
1022580 | 1022580 | 2021-02-12 | Franklin | Missouri | 29071 | 8253 | 149 |
1019335 | 1019335 | 2021-02-11 | Franklin | Missouri | 29071 | 8241 | 148 |
1016090 | 1016090 | 2021-02-10 | Franklin | Missouri | 29071 | 8214 | 138 |
1012845 | 1012845 | 2021-02-09 | Franklin | Missouri | 29071 | 8190 | 138 |
1009600 | 1009600 | 2021-02-08 | Franklin | Missouri | 29071 | 8181 | 138 |
1006353 | 1006353 | 2021-02-07 | Franklin | Missouri | 29071 | 8170 | 138 |
1003107 | 1003107 | 2021-02-06 | Franklin | Missouri | 29071 | 8159 | 138 |
999862 | 999862 | 2021-02-05 | Franklin | Missouri | 29071 | 8146 | 138 |
996616 | 996616 | 2021-02-04 | Franklin | Missouri | 29071 | 8111 | 138 |
993370 | 993370 | 2021-02-03 | Franklin | Missouri | 29071 | 8086 | 138 |
990124 | 990124 | 2021-02-02 | Franklin | Missouri | 29071 | 8063 | 138 |
986877 | 986877 | 2021-02-01 | Franklin | Missouri | 29071 | 8052 | 131 |
983630 | 983630 | 2021-01-31 | Franklin | Missouri | 29071 | 8032 | 131 |
980384 | 980384 | 2021-01-30 | Franklin | Missouri | 29071 | 8018 | 131 |
977138 | 977138 | 2021-01-29 | Franklin | Missouri | 29071 | 7997 | 131 |
973893 | 973893 | 2021-01-28 | Franklin | Missouri | 29071 | 7967 | 131 |
970648 | 970648 | 2021-01-27 | Franklin | Missouri | 29071 | 7928 | 131 |
967403 | 967403 | 2021-01-26 | Franklin | Missouri | 29071 | 7896 | 131 |
964159 | 964159 | 2021-01-25 | Franklin | Missouri | 29071 | 7871 | 128 |
960914 | 960914 | 2021-01-24 | Franklin | Missouri | 29071 | 7854 | 128 |
957668 | 957668 | 2021-01-23 | Franklin | Missouri | 29071 | 7828 | 128 |
954423 | 954423 | 2021-01-22 | Franklin | Missouri | 29071 | 7790 | 128 |
951178 | 951178 | 2021-01-21 | Franklin | Missouri | 29071 | 7754 | 127 |
947932 | 947932 | 2021-01-20 | Franklin | Missouri | 29071 | 7694 | 127 |
944685 | 944685 | 2021-01-19 | Franklin | Missouri | 29071 | 7664 | 122 |
941440 | 941440 | 2021-01-18 | Franklin | Missouri | 29071 | 7623 | 122 |
938195 | 938195 | 2021-01-17 | Franklin | Missouri | 29071 | 7582 | 122 |
934950 | 934950 | 2021-01-16 | Franklin | Missouri | 29071 | 7560 | 122 |
931705 | 931705 | 2021-01-15 | Franklin | Missouri | 29071 | 7508 | 122 |
928460 | 928460 | 2021-01-14 | Franklin | Missouri | 29071 | 7463 | 122 |
925214 | 925214 | 2021-01-13 | Franklin | Missouri | 29071 | 7381 | 122 |
921969 | 921969 | 2021-01-12 | Franklin | Missouri | 29071 | 7339 | 122 |
918724 | 918724 | 2021-01-11 | Franklin | Missouri | 29071 | 7305 | 116 |
915479 | 915479 | 2021-01-10 | Franklin | Missouri | 29071 | 7267 | 116 |
912234 | 912234 | 2021-01-09 | Franklin | Missouri | 29071 | 7195 | 116 |
908989 | 908989 | 2021-01-08 | Franklin | Missouri | 29071 | 7104 | 116 |
905743 | 905743 | 2021-01-07 | Franklin | Missouri | 29071 | 7001 | 116 |
902498 | 902498 | 2021-01-06 | Franklin | Missouri | 29071 | 6930 | 115 |
899253 | 899253 | 2021-01-05 | Franklin | Missouri | 29071 | 6859 | 115 |
896008 | 896008 | 2021-01-04 | Franklin | Missouri | 29071 | 6819 | 113 |
892761 | 892761 | 2021-01-03 | Franklin | Missouri | 29071 | 6819 | 113 |
889515 | 889515 | 2021-01-02 | Franklin | Missouri | 29071 | 6708 | 113 |
886269 | 886269 | 2021-01-01 | Franklin | Missouri | 29071 | 6656 | 113 |
883024 | 883024 | 2020-12-31 | Franklin | Missouri | 29071 | 6556 | 113 |
879779 | 879779 | 2020-12-30 | Franklin | Missouri | 29071 | 6466 | 113 |
876534 | 876534 | 2020-12-29 | Franklin | Missouri | 29071 | 6408 | 113 |
873289 | 873289 | 2020-12-28 | Franklin | Missouri | 29071 | 6363 | 109 |
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);