ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Effingham" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417570 | 1417570 | 2021-06-14 | Effingham | Georgia | 13103 | 4706 | 72 |
1414324 | 1414324 | 2021-06-13 | Effingham | Georgia | 13103 | 4706 | 72 |
1411079 | 1411079 | 2021-06-12 | Effingham | Georgia | 13103 | 4703 | 72 |
1407834 | 1407834 | 2021-06-11 | Effingham | Georgia | 13103 | 4701 | 72 |
1404588 | 1404588 | 2021-06-10 | Effingham | Georgia | 13103 | 4695 | 69 |
1401343 | 1401343 | 2021-06-09 | Effingham | Georgia | 13103 | 4695 | 69 |
1398098 | 1398098 | 2021-06-08 | Effingham | Georgia | 13103 | 4690 | 69 |
1394851 | 1394851 | 2021-06-07 | Effingham | Georgia | 13103 | 4687 | 69 |
1391606 | 1391606 | 2021-06-06 | Effingham | Georgia | 13103 | 4685 | 69 |
1388361 | 1388361 | 2021-06-05 | Effingham | Georgia | 13103 | 4682 | 69 |
1385116 | 1385116 | 2021-06-04 | Effingham | Georgia | 13103 | 4683 | 69 |
1381870 | 1381870 | 2021-06-03 | Effingham | Georgia | 13103 | 4682 | 69 |
1378625 | 1378625 | 2021-06-02 | Effingham | Georgia | 13103 | 4681 | 69 |
1375379 | 1375379 | 2021-06-01 | Effingham | Georgia | 13103 | 4681 | 69 |
1372134 | 1372134 | 2021-05-31 | Effingham | Georgia | 13103 | 4678 | 69 |
1368889 | 1368889 | 2021-05-30 | Effingham | Georgia | 13103 | 4677 | 69 |
1365643 | 1365643 | 2021-05-29 | Effingham | Georgia | 13103 | 4675 | 69 |
1362397 | 1362397 | 2021-05-28 | Effingham | Georgia | 13103 | 4674 | 69 |
1359150 | 1359150 | 2021-05-27 | Effingham | Georgia | 13103 | 4673 | 69 |
1355904 | 1355904 | 2021-05-26 | Effingham | Georgia | 13103 | 4670 | 69 |
1352658 | 1352658 | 2021-05-25 | Effingham | Georgia | 13103 | 4670 | 69 |
1349412 | 1349412 | 2021-05-24 | Effingham | Georgia | 13103 | 4668 | 69 |
1346165 | 1346165 | 2021-05-23 | Effingham | Georgia | 13103 | 4665 | 69 |
1342917 | 1342917 | 2021-05-22 | Effingham | Georgia | 13103 | 4663 | 69 |
1339669 | 1339669 | 2021-05-21 | Effingham | Georgia | 13103 | 4659 | 69 |
1336422 | 1336422 | 2021-05-20 | Effingham | Georgia | 13103 | 4658 | 69 |
1333175 | 1333175 | 2021-05-19 | Effingham | Georgia | 13103 | 4654 | 69 |
1329928 | 1329928 | 2021-05-18 | Effingham | Georgia | 13103 | 4650 | 69 |
1326681 | 1326681 | 2021-05-17 | Effingham | Georgia | 13103 | 4648 | 69 |
1323435 | 1323435 | 2021-05-16 | Effingham | Georgia | 13103 | 4644 | 69 |
1320189 | 1320189 | 2021-05-15 | Effingham | Georgia | 13103 | 4643 | 69 |
1316942 | 1316942 | 2021-05-14 | Effingham | Georgia | 13103 | 4641 | 69 |
1313695 | 1313695 | 2021-05-13 | Effingham | Georgia | 13103 | 4638 | 68 |
1310448 | 1310448 | 2021-05-12 | Effingham | Georgia | 13103 | 4631 | 68 |
1307202 | 1307202 | 2021-05-11 | Effingham | Georgia | 13103 | 4626 | 68 |
1303956 | 1303956 | 2021-05-10 | Effingham | Georgia | 13103 | 4620 | 68 |
1300709 | 1300709 | 2021-05-09 | Effingham | Georgia | 13103 | 4617 | 68 |
1297462 | 1297462 | 2021-05-08 | Effingham | Georgia | 13103 | 4615 | 68 |
1294216 | 1294216 | 2021-05-07 | Effingham | Georgia | 13103 | 4612 | 68 |
1290970 | 1290970 | 2021-05-06 | Effingham | Georgia | 13103 | 4607 | 68 |
1287724 | 1287724 | 2021-05-05 | Effingham | Georgia | 13103 | 4602 | 68 |
1284478 | 1284478 | 2021-05-04 | Effingham | Georgia | 13103 | 4598 | 68 |
1281231 | 1281231 | 2021-05-03 | Effingham | Georgia | 13103 | 4591 | 68 |
1277984 | 1277984 | 2021-05-02 | Effingham | Georgia | 13103 | 4587 | 68 |
1274737 | 1274737 | 2021-05-01 | Effingham | Georgia | 13103 | 4587 | 68 |
1271490 | 1271490 | 2021-04-30 | Effingham | Georgia | 13103 | 4582 | 68 |
1268243 | 1268243 | 2021-04-29 | Effingham | Georgia | 13103 | 4575 | 68 |
1264996 | 1264996 | 2021-04-28 | Effingham | Georgia | 13103 | 4568 | 67 |
1261749 | 1261749 | 2021-04-27 | Effingham | Georgia | 13103 | 4562 | 67 |
1258502 | 1258502 | 2021-04-26 | Effingham | Georgia | 13103 | 4551 | 67 |
1255255 | 1255255 | 2021-04-25 | Effingham | Georgia | 13103 | 4545 | 67 |
1252008 | 1252008 | 2021-04-24 | Effingham | Georgia | 13103 | 4543 | 67 |
1248761 | 1248761 | 2021-04-23 | Effingham | Georgia | 13103 | 4536 | 67 |
1245514 | 1245514 | 2021-04-22 | Effingham | Georgia | 13103 | 4531 | 67 |
1242267 | 1242267 | 2021-04-21 | Effingham | Georgia | 13103 | 4525 | 67 |
1239020 | 1239020 | 2021-04-20 | Effingham | Georgia | 13103 | 4522 | 67 |
1235773 | 1235773 | 2021-04-19 | Effingham | Georgia | 13103 | 4513 | 67 |
1232526 | 1232526 | 2021-04-18 | Effingham | Georgia | 13103 | 4509 | 67 |
1229277 | 1229277 | 2021-04-17 | Effingham | Georgia | 13103 | 4508 | 67 |
1226029 | 1226029 | 2021-04-16 | Effingham | Georgia | 13103 | 4499 | 67 |
1222782 | 1222782 | 2021-04-15 | Effingham | Georgia | 13103 | 4491 | 67 |
1219534 | 1219534 | 2021-04-14 | Effingham | Georgia | 13103 | 4483 | 67 |
1216286 | 1216286 | 2021-04-13 | Effingham | Georgia | 13103 | 4476 | 67 |
1213039 | 1213039 | 2021-04-12 | Effingham | Georgia | 13103 | 4473 | 67 |
1209791 | 1209791 | 2021-04-11 | Effingham | Georgia | 13103 | 4470 | 66 |
1206542 | 1206542 | 2021-04-10 | Effingham | Georgia | 13103 | 4469 | 66 |
1203294 | 1203294 | 2021-04-09 | Effingham | Georgia | 13103 | 4462 | 66 |
1200046 | 1200046 | 2021-04-08 | Effingham | Georgia | 13103 | 4456 | 66 |
1196797 | 1196797 | 2021-04-07 | Effingham | Georgia | 13103 | 4448 | 66 |
1193549 | 1193549 | 2021-04-06 | Effingham | Georgia | 13103 | 4436 | 65 |
1190299 | 1190299 | 2021-04-05 | Effingham | Georgia | 13103 | 4431 | 65 |
1187052 | 1187052 | 2021-04-04 | Effingham | Georgia | 13103 | 4435 | 65 |
1183805 | 1183805 | 2021-04-03 | Effingham | Georgia | 13103 | 4427 | 65 |
1180558 | 1180558 | 2021-04-02 | Effingham | Georgia | 13103 | 4420 | 65 |
1177311 | 1177311 | 2021-04-01 | Effingham | Georgia | 13103 | 4408 | 65 |
1174064 | 1174064 | 2021-03-31 | Effingham | Georgia | 13103 | 4408 | 65 |
1170817 | 1170817 | 2021-03-30 | Effingham | Georgia | 13103 | 4407 | 65 |
1167569 | 1167569 | 2021-03-29 | Effingham | Georgia | 13103 | 4401 | 65 |
1164321 | 1164321 | 2021-03-28 | Effingham | Georgia | 13103 | 4399 | 65 |
1161073 | 1161073 | 2021-03-27 | Effingham | Georgia | 13103 | 4393 | 65 |
1157825 | 1157825 | 2021-03-26 | Effingham | Georgia | 13103 | 4384 | 65 |
1154578 | 1154578 | 2021-03-25 | Effingham | Georgia | 13103 | 4378 | 64 |
1151331 | 1151331 | 2021-03-24 | Effingham | Georgia | 13103 | 4370 | 63 |
1148084 | 1148084 | 2021-03-23 | Effingham | Georgia | 13103 | 4360 | 62 |
1144837 | 1144837 | 2021-03-22 | Effingham | Georgia | 13103 | 4349 | 62 |
1141590 | 1141590 | 2021-03-21 | Effingham | Georgia | 13103 | 4343 | 62 |
1138344 | 1138344 | 2021-03-20 | Effingham | Georgia | 13103 | 4339 | 62 |
1135098 | 1135098 | 2021-03-19 | Effingham | Georgia | 13103 | 4312 | 62 |
1131851 | 1131851 | 2021-03-18 | Effingham | Georgia | 13103 | 4311 | 62 |
1128603 | 1128603 | 2021-03-17 | Effingham | Georgia | 13103 | 4298 | 61 |
1125357 | 1125357 | 2021-03-16 | Effingham | Georgia | 13103 | 4369 | 63 |
1122111 | 1122111 | 2021-03-15 | Effingham | Georgia | 13103 | 4367 | 64 |
1118864 | 1118864 | 2021-03-14 | Effingham | Georgia | 13103 | 4366 | 63 |
1115617 | 1115617 | 2021-03-13 | Effingham | Georgia | 13103 | 4352 | 63 |
1112371 | 1112371 | 2021-03-12 | Effingham | Georgia | 13103 | 4330 | 63 |
1109125 | 1109125 | 2021-03-11 | Effingham | Georgia | 13103 | 4321 | 63 |
1105879 | 1105879 | 2021-03-10 | Effingham | Georgia | 13103 | 4312 | 63 |
1102633 | 1102633 | 2021-03-09 | Effingham | Georgia | 13103 | 4303 | 63 |
1099387 | 1099387 | 2021-03-08 | Effingham | Georgia | 13103 | 4299 | 63 |
1096139 | 1096139 | 2021-03-07 | Effingham | Georgia | 13103 | 4306 | 63 |
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);