ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Clayton" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417550 | 1417550 | 2021-06-14 | Clayton | Georgia | 13063 | 27375 | 514 |
1414304 | 1414304 | 2021-06-13 | Clayton | Georgia | 13063 | 27369 | 514 |
1411059 | 1411059 | 2021-06-12 | Clayton | Georgia | 13063 | 27362 | 514 |
1407814 | 1407814 | 2021-06-11 | Clayton | Georgia | 13063 | 27351 | 511 |
1404568 | 1404568 | 2021-06-10 | Clayton | Georgia | 13063 | 27335 | 511 |
1401323 | 1401323 | 2021-06-09 | Clayton | Georgia | 13063 | 27315 | 509 |
1398078 | 1398078 | 2021-06-08 | Clayton | Georgia | 13063 | 27295 | 508 |
1394831 | 1394831 | 2021-06-07 | Clayton | Georgia | 13063 | 27282 | 507 |
1391586 | 1391586 | 2021-06-06 | Clayton | Georgia | 13063 | 27269 | 507 |
1388341 | 1388341 | 2021-06-05 | Clayton | Georgia | 13063 | 27259 | 507 |
1385096 | 1385096 | 2021-06-04 | Clayton | Georgia | 13063 | 27250 | 505 |
1381850 | 1381850 | 2021-06-03 | Clayton | Georgia | 13063 | 27234 | 504 |
1378605 | 1378605 | 2021-06-02 | Clayton | Georgia | 13063 | 27213 | 502 |
1375359 | 1375359 | 2021-06-01 | Clayton | Georgia | 13063 | 27201 | 501 |
1372114 | 1372114 | 2021-05-31 | Clayton | Georgia | 13063 | 27189 | 501 |
1368869 | 1368869 | 2021-05-30 | Clayton | Georgia | 13063 | 27180 | 501 |
1365623 | 1365623 | 2021-05-29 | Clayton | Georgia | 13063 | 27164 | 501 |
1362377 | 1362377 | 2021-05-28 | Clayton | Georgia | 13063 | 27141 | 498 |
1359130 | 1359130 | 2021-05-27 | Clayton | Georgia | 13063 | 27122 | 495 |
1355884 | 1355884 | 2021-05-26 | Clayton | Georgia | 13063 | 27088 | 494 |
1352638 | 1352638 | 2021-05-25 | Clayton | Georgia | 13063 | 27073 | 492 |
1349392 | 1349392 | 2021-05-24 | Clayton | Georgia | 13063 | 27060 | 490 |
1346145 | 1346145 | 2021-05-23 | Clayton | Georgia | 13063 | 27048 | 490 |
1342897 | 1342897 | 2021-05-22 | Clayton | Georgia | 13063 | 27030 | 490 |
1339649 | 1339649 | 2021-05-21 | Clayton | Georgia | 13063 | 27011 | 490 |
1336402 | 1336402 | 2021-05-20 | Clayton | Georgia | 13063 | 26993 | 489 |
1333155 | 1333155 | 2021-05-19 | Clayton | Georgia | 13063 | 26977 | 488 |
1329908 | 1329908 | 2021-05-18 | Clayton | Georgia | 13063 | 26955 | 486 |
1326661 | 1326661 | 2021-05-17 | Clayton | Georgia | 13063 | 26934 | 484 |
1323415 | 1323415 | 2021-05-16 | Clayton | Georgia | 13063 | 26918 | 484 |
1320169 | 1320169 | 2021-05-15 | Clayton | Georgia | 13063 | 26899 | 484 |
1316922 | 1316922 | 2021-05-14 | Clayton | Georgia | 13063 | 26872 | 483 |
1313675 | 1313675 | 2021-05-13 | Clayton | Georgia | 13063 | 26836 | 483 |
1310428 | 1310428 | 2021-05-12 | Clayton | Georgia | 13063 | 26779 | 481 |
1307182 | 1307182 | 2021-05-11 | Clayton | Georgia | 13063 | 26747 | 479 |
1303936 | 1303936 | 2021-05-10 | Clayton | Georgia | 13063 | 26696 | 478 |
1300689 | 1300689 | 2021-05-09 | Clayton | Georgia | 13063 | 26675 | 478 |
1297442 | 1297442 | 2021-05-08 | Clayton | Georgia | 13063 | 26653 | 478 |
1294196 | 1294196 | 2021-05-07 | Clayton | Georgia | 13063 | 26615 | 474 |
1290950 | 1290950 | 2021-05-06 | Clayton | Georgia | 13063 | 26555 | 472 |
1287704 | 1287704 | 2021-05-05 | Clayton | Georgia | 13063 | 26508 | 469 |
1284458 | 1284458 | 2021-05-04 | Clayton | Georgia | 13063 | 26463 | 469 |
1281211 | 1281211 | 2021-05-03 | Clayton | Georgia | 13063 | 26424 | 469 |
1277964 | 1277964 | 2021-05-02 | Clayton | Georgia | 13063 | 26393 | 468 |
1274717 | 1274717 | 2021-05-01 | Clayton | Georgia | 13063 | 26365 | 468 |
1271470 | 1271470 | 2021-04-30 | Clayton | Georgia | 13063 | 26321 | 468 |
1268223 | 1268223 | 2021-04-29 | Clayton | Georgia | 13063 | 26270 | 468 |
1264976 | 1264976 | 2021-04-28 | Clayton | Georgia | 13063 | 26191 | 467 |
1261729 | 1261729 | 2021-04-27 | Clayton | Georgia | 13063 | 26139 | 465 |
1258482 | 1258482 | 2021-04-26 | Clayton | Georgia | 13063 | 26070 | 465 |
1255235 | 1255235 | 2021-04-25 | Clayton | Georgia | 13063 | 26043 | 465 |
1251988 | 1251988 | 2021-04-24 | Clayton | Georgia | 13063 | 26017 | 465 |
1248741 | 1248741 | 2021-04-23 | Clayton | Georgia | 13063 | 25960 | 461 |
1245494 | 1245494 | 2021-04-22 | Clayton | Georgia | 13063 | 25888 | 460 |
1242247 | 1242247 | 2021-04-21 | Clayton | Georgia | 13063 | 25821 | 455 |
1239000 | 1239000 | 2021-04-20 | Clayton | Georgia | 13063 | 25770 | 453 |
1235753 | 1235753 | 2021-04-19 | Clayton | Georgia | 13063 | 25723 | 453 |
1232506 | 1232506 | 2021-04-18 | Clayton | Georgia | 13063 | 25688 | 452 |
1229257 | 1229257 | 2021-04-17 | Clayton | Georgia | 13063 | 25634 | 452 |
1226009 | 1226009 | 2021-04-16 | Clayton | Georgia | 13063 | 25570 | 450 |
1222762 | 1222762 | 2021-04-15 | Clayton | Georgia | 13063 | 25505 | 449 |
1219514 | 1219514 | 2021-04-14 | Clayton | Georgia | 13063 | 25454 | 443 |
1216266 | 1216266 | 2021-04-13 | Clayton | Georgia | 13063 | 25393 | 439 |
1213019 | 1213019 | 2021-04-12 | Clayton | Georgia | 13063 | 25297 | 439 |
1209771 | 1209771 | 2021-04-11 | Clayton | Georgia | 13063 | 25270 | 438 |
1206522 | 1206522 | 2021-04-10 | Clayton | Georgia | 13063 | 25245 | 438 |
1203274 | 1203274 | 2021-04-09 | Clayton | Georgia | 13063 | 25194 | 437 |
1200026 | 1200026 | 2021-04-08 | Clayton | Georgia | 13063 | 25153 | 437 |
1196777 | 1196777 | 2021-04-07 | Clayton | Georgia | 13063 | 25091 | 434 |
1193529 | 1193529 | 2021-04-06 | Clayton | Georgia | 13063 | 25022 | 434 |
1190279 | 1190279 | 2021-04-05 | Clayton | Georgia | 13063 | 24976 | 434 |
1187032 | 1187032 | 2021-04-04 | Clayton | Georgia | 13063 | 24952 | 434 |
1183785 | 1183785 | 2021-04-03 | Clayton | Georgia | 13063 | 24915 | 434 |
1180538 | 1180538 | 2021-04-02 | Clayton | Georgia | 13063 | 24865 | 433 |
1177291 | 1177291 | 2021-04-01 | Clayton | Georgia | 13063 | 24826 | 429 |
1174044 | 1174044 | 2021-03-31 | Clayton | Georgia | 13063 | 24791 | 429 |
1170797 | 1170797 | 2021-03-30 | Clayton | Georgia | 13063 | 24740 | 426 |
1167549 | 1167549 | 2021-03-29 | Clayton | Georgia | 13063 | 24708 | 426 |
1164301 | 1164301 | 2021-03-28 | Clayton | Georgia | 13063 | 24678 | 424 |
1161053 | 1161053 | 2021-03-27 | Clayton | Georgia | 13063 | 24647 | 424 |
1157805 | 1157805 | 2021-03-26 | Clayton | Georgia | 13063 | 24602 | 421 |
1154558 | 1154558 | 2021-03-25 | Clayton | Georgia | 13063 | 24564 | 421 |
1151311 | 1151311 | 2021-03-24 | Clayton | Georgia | 13063 | 24473 | 419 |
1148064 | 1148064 | 2021-03-23 | Clayton | Georgia | 13063 | 24433 | 418 |
1144817 | 1144817 | 2021-03-22 | Clayton | Georgia | 13063 | 24392 | 417 |
1141570 | 1141570 | 2021-03-21 | Clayton | Georgia | 13063 | 24349 | 417 |
1138324 | 1138324 | 2021-03-20 | Clayton | Georgia | 13063 | 24278 | 417 |
1135078 | 1135078 | 2021-03-19 | Clayton | Georgia | 13063 | 24235 | 416 |
1131831 | 1131831 | 2021-03-18 | Clayton | Georgia | 13063 | 24203 | 414 |
1128583 | 1128583 | 2021-03-17 | Clayton | Georgia | 13063 | 24147 | 414 |
1125337 | 1125337 | 2021-03-16 | Clayton | Georgia | 13063 | 24097 | 411 |
1122091 | 1122091 | 2021-03-15 | Clayton | Georgia | 13063 | 24049 | 411 |
1118844 | 1118844 | 2021-03-14 | Clayton | Georgia | 13063 | 24014 | 409 |
1115597 | 1115597 | 2021-03-13 | Clayton | Georgia | 13063 | 23993 | 409 |
1112351 | 1112351 | 2021-03-12 | Clayton | Georgia | 13063 | 23945 | 408 |
1109105 | 1109105 | 2021-03-11 | Clayton | Georgia | 13063 | 23903 | 406 |
1105859 | 1105859 | 2021-03-10 | Clayton | Georgia | 13063 | 23851 | 404 |
1102613 | 1102613 | 2021-03-09 | Clayton | Georgia | 13063 | 23786 | 398 |
1099367 | 1099367 | 2021-03-08 | Clayton | Georgia | 13063 | 23735 | 398 |
1096119 | 1096119 | 2021-03-07 | Clayton | Georgia | 13063 | 23684 | 397 |
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);