ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 12119 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1391547 | 1391547 | 2021-06-06 | Sumter | Florida | 12119 | 9400 | 284 |
1388302 | 1388302 | 2021-06-05 | Sumter | Florida | 12119 | 9400 | 284 |
1385057 | 1385057 | 2021-06-04 | Sumter | Florida | 12119 | 9400 | 284 |
1381811 | 1381811 | 2021-06-03 | Sumter | Florida | 12119 | 9506 | 284 |
1378566 | 1378566 | 2021-06-02 | Sumter | Florida | 12119 | 9504 | 283 |
1375320 | 1375320 | 2021-06-01 | Sumter | Florida | 12119 | 9504 | 282 |
1372075 | 1372075 | 2021-05-31 | Sumter | Florida | 12119 | 9487 | 281 |
1368830 | 1368830 | 2021-05-30 | Sumter | Florida | 12119 | 9487 | 281 |
1365584 | 1365584 | 2021-05-29 | Sumter | Florida | 12119 | 9487 | 281 |
1362338 | 1362338 | 2021-05-28 | Sumter | Florida | 12119 | 9487 | 281 |
1359091 | 1359091 | 2021-05-27 | Sumter | Florida | 12119 | 9477 | 281 |
1355845 | 1355845 | 2021-05-26 | Sumter | Florida | 12119 | 9467 | 280 |
1352599 | 1352599 | 2021-05-25 | Sumter | Florida | 12119 | 9458 | 279 |
1349353 | 1349353 | 2021-05-24 | Sumter | Florida | 12119 | 9456 | 279 |
1346106 | 1346106 | 2021-05-23 | Sumter | Florida | 12119 | 9450 | 279 |
1342858 | 1342858 | 2021-05-22 | Sumter | Florida | 12119 | 9439 | 279 |
1339610 | 1339610 | 2021-05-21 | Sumter | Florida | 12119 | 9431 | 279 |
1336363 | 1336363 | 2021-05-20 | Sumter | Florida | 12119 | 9422 | 278 |
1333116 | 1333116 | 2021-05-19 | Sumter | Florida | 12119 | 9413 | 278 |
1329869 | 1329869 | 2021-05-18 | Sumter | Florida | 12119 | 9406 | 278 |
1326622 | 1326622 | 2021-05-17 | Sumter | Florida | 12119 | 9391 | 278 |
1323376 | 1323376 | 2021-05-16 | Sumter | Florida | 12119 | 9386 | 278 |
1320130 | 1320130 | 2021-05-15 | Sumter | Florida | 12119 | 9381 | 278 |
1316883 | 1316883 | 2021-05-14 | Sumter | Florida | 12119 | 9378 | 278 |
1313636 | 1313636 | 2021-05-13 | Sumter | Florida | 12119 | 9374 | 278 |
1310389 | 1310389 | 2021-05-12 | Sumter | Florida | 12119 | 9369 | 278 |
1307143 | 1307143 | 2021-05-11 | Sumter | Florida | 12119 | 9364 | 278 |
1303897 | 1303897 | 2021-05-10 | Sumter | Florida | 12119 | 9356 | 279 |
1300650 | 1300650 | 2021-05-09 | Sumter | Florida | 12119 | 9352 | 278 |
1297403 | 1297403 | 2021-05-08 | Sumter | Florida | 12119 | 9345 | 277 |
1294157 | 1294157 | 2021-05-07 | Sumter | Florida | 12119 | 9341 | 277 |
1290911 | 1290911 | 2021-05-06 | Sumter | Florida | 12119 | 9331 | 275 |
1287665 | 1287665 | 2021-05-05 | Sumter | Florida | 12119 | 9312 | 275 |
1284419 | 1284419 | 2021-05-04 | Sumter | Florida | 12119 | 9307 | 275 |
1281172 | 1281172 | 2021-05-03 | Sumter | Florida | 12119 | 9294 | 275 |
1277925 | 1277925 | 2021-05-02 | Sumter | Florida | 12119 | 9281 | 275 |
1274678 | 1274678 | 2021-05-01 | Sumter | Florida | 12119 | 9270 | 275 |
1271431 | 1271431 | 2021-04-30 | Sumter | Florida | 12119 | 9263 | 275 |
1268184 | 1268184 | 2021-04-29 | Sumter | Florida | 12119 | 9249 | 275 |
1264937 | 1264937 | 2021-04-28 | Sumter | Florida | 12119 | 9234 | 275 |
1261690 | 1261690 | 2021-04-27 | Sumter | Florida | 12119 | 9220 | 275 |
1258443 | 1258443 | 2021-04-26 | Sumter | Florida | 12119 | 9208 | 273 |
1255196 | 1255196 | 2021-04-25 | Sumter | Florida | 12119 | 9205 | 273 |
1251949 | 1251949 | 2021-04-24 | Sumter | Florida | 12119 | 9196 | 273 |
1248702 | 1248702 | 2021-04-23 | Sumter | Florida | 12119 | 9174 | 273 |
1245455 | 1245455 | 2021-04-22 | Sumter | Florida | 12119 | 9163 | 273 |
1242208 | 1242208 | 2021-04-21 | Sumter | Florida | 12119 | 9136 | 273 |
1238961 | 1238961 | 2021-04-20 | Sumter | Florida | 12119 | 9116 | 272 |
1235714 | 1235714 | 2021-04-19 | Sumter | Florida | 12119 | 9101 | 270 |
1232467 | 1232467 | 2021-04-18 | Sumter | Florida | 12119 | 9093 | 269 |
1229218 | 1229218 | 2021-04-17 | Sumter | Florida | 12119 | 9084 | 269 |
1225970 | 1225970 | 2021-04-16 | Sumter | Florida | 12119 | 9070 | 269 |
1222723 | 1222723 | 2021-04-15 | Sumter | Florida | 12119 | 9048 | 266 |
1219475 | 1219475 | 2021-04-14 | Sumter | Florida | 12119 | 9035 | 266 |
1216227 | 1216227 | 2021-04-13 | Sumter | Florida | 12119 | 9020 | 266 |
1212980 | 1212980 | 2021-04-12 | Sumter | Florida | 12119 | 8990 | 264 |
1209732 | 1209732 | 2021-04-11 | Sumter | Florida | 12119 | 8988 | 263 |
1206483 | 1206483 | 2021-04-10 | Sumter | Florida | 12119 | 8971 | 264 |
1203235 | 1203235 | 2021-04-09 | Sumter | Florida | 12119 | 8956 | 263 |
1199987 | 1199987 | 2021-04-08 | Sumter | Florida | 12119 | 8923 | 263 |
1196738 | 1196738 | 2021-04-07 | Sumter | Florida | 12119 | 8909 | 263 |
1193490 | 1193490 | 2021-04-06 | Sumter | Florida | 12119 | 8886 | 262 |
1190240 | 1190240 | 2021-04-05 | Sumter | Florida | 12119 | 8880 | 260 |
1186993 | 1186993 | 2021-04-04 | Sumter | Florida | 12119 | 8868 | 261 |
1183746 | 1183746 | 2021-04-03 | Sumter | Florida | 12119 | 8852 | 261 |
1180499 | 1180499 | 2021-04-02 | Sumter | Florida | 12119 | 8827 | 257 |
1177252 | 1177252 | 2021-04-01 | Sumter | Florida | 12119 | 8812 | 257 |
1174005 | 1174005 | 2021-03-31 | Sumter | Florida | 12119 | 8790 | 257 |
1170758 | 1170758 | 2021-03-30 | Sumter | Florida | 12119 | 8780 | 258 |
1167510 | 1167510 | 2021-03-29 | Sumter | Florida | 12119 | 8755 | 244 |
1164262 | 1164262 | 2021-03-28 | Sumter | Florida | 12119 | 8751 | 244 |
1161014 | 1161014 | 2021-03-27 | Sumter | Florida | 12119 | 8730 | 244 |
1157766 | 1157766 | 2021-03-26 | Sumter | Florida | 12119 | 8693 | 243 |
1154519 | 1154519 | 2021-03-25 | Sumter | Florida | 12119 | 8678 | 243 |
1151272 | 1151272 | 2021-03-24 | Sumter | Florida | 12119 | 8644 | 243 |
1148025 | 1148025 | 2021-03-23 | Sumter | Florida | 12119 | 8562 | 243 |
1144778 | 1144778 | 2021-03-22 | Sumter | Florida | 12119 | 8518 | 243 |
1141531 | 1141531 | 2021-03-21 | Sumter | Florida | 12119 | 8501 | 243 |
1138285 | 1138285 | 2021-03-20 | Sumter | Florida | 12119 | 8489 | 242 |
1135039 | 1135039 | 2021-03-19 | Sumter | Florida | 12119 | 8472 | 242 |
1131792 | 1131792 | 2021-03-18 | Sumter | Florida | 12119 | 8442 | 242 |
1128544 | 1128544 | 2021-03-17 | Sumter | Florida | 12119 | 8422 | 242 |
1125298 | 1125298 | 2021-03-16 | Sumter | Florida | 12119 | 8392 | 242 |
1122052 | 1122052 | 2021-03-15 | Sumter | Florida | 12119 | 8369 | 242 |
1118805 | 1118805 | 2021-03-14 | Sumter | Florida | 12119 | 8349 | 242 |
1115558 | 1115558 | 2021-03-13 | Sumter | Florida | 12119 | 8339 | 242 |
1112312 | 1112312 | 2021-03-12 | Sumter | Florida | 12119 | 8297 | 242 |
1109066 | 1109066 | 2021-03-11 | Sumter | Florida | 12119 | 8269 | 242 |
1105820 | 1105820 | 2021-03-10 | Sumter | Florida | 12119 | 8247 | 242 |
1102574 | 1102574 | 2021-03-09 | Sumter | Florida | 12119 | 8227 | 242 |
1099328 | 1099328 | 2021-03-08 | Sumter | Florida | 12119 | 8206 | 244 |
1096080 | 1096080 | 2021-03-07 | Sumter | Florida | 12119 | 8192 | 243 |
1092834 | 1092834 | 2021-03-06 | Sumter | Florida | 12119 | 8165 | 243 |
1089588 | 1089588 | 2021-03-05 | Sumter | Florida | 12119 | 8147 | 243 |
1086343 | 1086343 | 2021-03-04 | Sumter | Florida | 12119 | 8125 | 243 |
1083097 | 1083097 | 2021-03-03 | Sumter | Florida | 12119 | 8095 | 241 |
1079851 | 1079851 | 2021-03-02 | Sumter | Florida | 12119 | 8071 | 238 |
1076606 | 1076606 | 2021-03-01 | Sumter | Florida | 12119 | 8021 | 238 |
1073360 | 1073360 | 2021-02-28 | Sumter | Florida | 12119 | 8017 | 238 |
1070114 | 1070114 | 2021-02-27 | Sumter | Florida | 12119 | 7990 | 238 |
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);