ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Pickens" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417631 | 1417631 | 2021-06-14 | Pickens | Georgia | 13227 | 3531 | 78 |
1414385 | 1414385 | 2021-06-13 | Pickens | Georgia | 13227 | 3528 | 78 |
1411140 | 1411140 | 2021-06-12 | Pickens | Georgia | 13227 | 3527 | 78 |
1407895 | 1407895 | 2021-06-11 | Pickens | Georgia | 13227 | 3527 | 78 |
1404649 | 1404649 | 2021-06-10 | Pickens | Georgia | 13227 | 3525 | 78 |
1401404 | 1401404 | 2021-06-09 | Pickens | Georgia | 13227 | 3521 | 78 |
1398159 | 1398159 | 2021-06-08 | Pickens | Georgia | 13227 | 3519 | 78 |
1394912 | 1394912 | 2021-06-07 | Pickens | Georgia | 13227 | 3519 | 78 |
1391667 | 1391667 | 2021-06-06 | Pickens | Georgia | 13227 | 3519 | 78 |
1388422 | 1388422 | 2021-06-05 | Pickens | Georgia | 13227 | 3519 | 78 |
1385177 | 1385177 | 2021-06-04 | Pickens | Georgia | 13227 | 3519 | 79 |
1381931 | 1381931 | 2021-06-03 | Pickens | Georgia | 13227 | 3517 | 78 |
1378686 | 1378686 | 2021-06-02 | Pickens | Georgia | 13227 | 3514 | 78 |
1375440 | 1375440 | 2021-06-01 | Pickens | Georgia | 13227 | 3513 | 78 |
1372195 | 1372195 | 2021-05-31 | Pickens | Georgia | 13227 | 3511 | 78 |
1368950 | 1368950 | 2021-05-30 | Pickens | Georgia | 13227 | 3511 | 78 |
1365704 | 1365704 | 2021-05-29 | Pickens | Georgia | 13227 | 3512 | 78 |
1362458 | 1362458 | 2021-05-28 | Pickens | Georgia | 13227 | 3508 | 78 |
1359211 | 1359211 | 2021-05-27 | Pickens | Georgia | 13227 | 3507 | 78 |
1355965 | 1355965 | 2021-05-26 | Pickens | Georgia | 13227 | 3505 | 78 |
1352719 | 1352719 | 2021-05-25 | Pickens | Georgia | 13227 | 3507 | 80 |
1349473 | 1349473 | 2021-05-24 | Pickens | Georgia | 13227 | 3507 | 80 |
1346226 | 1346226 | 2021-05-23 | Pickens | Georgia | 13227 | 3507 | 80 |
1342978 | 1342978 | 2021-05-22 | Pickens | Georgia | 13227 | 3506 | 80 |
1339730 | 1339730 | 2021-05-21 | Pickens | Georgia | 13227 | 3502 | 79 |
1336483 | 1336483 | 2021-05-20 | Pickens | Georgia | 13227 | 3501 | 79 |
1333236 | 1333236 | 2021-05-19 | Pickens | Georgia | 13227 | 3495 | 79 |
1329989 | 1329989 | 2021-05-18 | Pickens | Georgia | 13227 | 3494 | 79 |
1326742 | 1326742 | 2021-05-17 | Pickens | Georgia | 13227 | 3491 | 79 |
1323496 | 1323496 | 2021-05-16 | Pickens | Georgia | 13227 | 3486 | 79 |
1320250 | 1320250 | 2021-05-15 | Pickens | Georgia | 13227 | 3482 | 79 |
1317003 | 1317003 | 2021-05-14 | Pickens | Georgia | 13227 | 3476 | 79 |
1313756 | 1313756 | 2021-05-13 | Pickens | Georgia | 13227 | 3470 | 79 |
1310509 | 1310509 | 2021-05-12 | Pickens | Georgia | 13227 | 3465 | 79 |
1307263 | 1307263 | 2021-05-11 | Pickens | Georgia | 13227 | 3461 | 79 |
1304017 | 1304017 | 2021-05-10 | Pickens | Georgia | 13227 | 3457 | 79 |
1300770 | 1300770 | 2021-05-09 | Pickens | Georgia | 13227 | 3454 | 79 |
1297523 | 1297523 | 2021-05-08 | Pickens | Georgia | 13227 | 3452 | 79 |
1294277 | 1294277 | 2021-05-07 | Pickens | Georgia | 13227 | 3449 | 79 |
1291031 | 1291031 | 2021-05-06 | Pickens | Georgia | 13227 | 3436 | 79 |
1287785 | 1287785 | 2021-05-05 | Pickens | Georgia | 13227 | 3429 | 79 |
1284539 | 1284539 | 2021-05-04 | Pickens | Georgia | 13227 | 3425 | 79 |
1281292 | 1281292 | 2021-05-03 | Pickens | Georgia | 13227 | 3419 | 79 |
1278045 | 1278045 | 2021-05-02 | Pickens | Georgia | 13227 | 3418 | 79 |
1274798 | 1274798 | 2021-05-01 | Pickens | Georgia | 13227 | 3416 | 79 |
1271551 | 1271551 | 2021-04-30 | Pickens | Georgia | 13227 | 3412 | 79 |
1268304 | 1268304 | 2021-04-29 | Pickens | Georgia | 13227 | 3407 | 79 |
1265057 | 1265057 | 2021-04-28 | Pickens | Georgia | 13227 | 3404 | 78 |
1261810 | 1261810 | 2021-04-27 | Pickens | Georgia | 13227 | 3400 | 77 |
1258563 | 1258563 | 2021-04-26 | Pickens | Georgia | 13227 | 3400 | 77 |
1255316 | 1255316 | 2021-04-25 | Pickens | Georgia | 13227 | 3397 | 76 |
1252069 | 1252069 | 2021-04-24 | Pickens | Georgia | 13227 | 3391 | 76 |
1248822 | 1248822 | 2021-04-23 | Pickens | Georgia | 13227 | 3391 | 76 |
1245575 | 1245575 | 2021-04-22 | Pickens | Georgia | 13227 | 3390 | 74 |
1242328 | 1242328 | 2021-04-21 | Pickens | Georgia | 13227 | 3386 | 74 |
1239081 | 1239081 | 2021-04-20 | Pickens | Georgia | 13227 | 3380 | 74 |
1235834 | 1235834 | 2021-04-19 | Pickens | Georgia | 13227 | 3373 | 74 |
1232587 | 1232587 | 2021-04-18 | Pickens | Georgia | 13227 | 3368 | 74 |
1229338 | 1229338 | 2021-04-17 | Pickens | Georgia | 13227 | 3360 | 74 |
1226090 | 1226090 | 2021-04-16 | Pickens | Georgia | 13227 | 3357 | 74 |
1222843 | 1222843 | 2021-04-15 | Pickens | Georgia | 13227 | 3355 | 74 |
1219595 | 1219595 | 2021-04-14 | Pickens | Georgia | 13227 | 3350 | 74 |
1216347 | 1216347 | 2021-04-13 | Pickens | Georgia | 13227 | 3348 | 74 |
1213100 | 1213100 | 2021-04-12 | Pickens | Georgia | 13227 | 3339 | 74 |
1209852 | 1209852 | 2021-04-11 | Pickens | Georgia | 13227 | 3334 | 74 |
1206603 | 1206603 | 2021-04-10 | Pickens | Georgia | 13227 | 3334 | 74 |
1203355 | 1203355 | 2021-04-09 | Pickens | Georgia | 13227 | 3332 | 74 |
1200107 | 1200107 | 2021-04-08 | Pickens | Georgia | 13227 | 3327 | 74 |
1196858 | 1196858 | 2021-04-07 | Pickens | Georgia | 13227 | 3320 | 74 |
1193610 | 1193610 | 2021-04-06 | Pickens | Georgia | 13227 | 3312 | 74 |
1190360 | 1190360 | 2021-04-05 | Pickens | Georgia | 13227 | 3307 | 74 |
1187113 | 1187113 | 2021-04-04 | Pickens | Georgia | 13227 | 3306 | 74 |
1183866 | 1183866 | 2021-04-03 | Pickens | Georgia | 13227 | 3306 | 74 |
1180619 | 1180619 | 2021-04-02 | Pickens | Georgia | 13227 | 3300 | 74 |
1177372 | 1177372 | 2021-04-01 | Pickens | Georgia | 13227 | 3296 | 74 |
1174125 | 1174125 | 2021-03-31 | Pickens | Georgia | 13227 | 3290 | 74 |
1170878 | 1170878 | 2021-03-30 | Pickens | Georgia | 13227 | 3283 | 74 |
1167630 | 1167630 | 2021-03-29 | Pickens | Georgia | 13227 | 3278 | 74 |
1164382 | 1164382 | 2021-03-28 | Pickens | Georgia | 13227 | 3279 | 74 |
1161134 | 1161134 | 2021-03-27 | Pickens | Georgia | 13227 | 3279 | 74 |
1157886 | 1157886 | 2021-03-26 | Pickens | Georgia | 13227 | 3277 | 74 |
1154639 | 1154639 | 2021-03-25 | Pickens | Georgia | 13227 | 3273 | 74 |
1151392 | 1151392 | 2021-03-24 | Pickens | Georgia | 13227 | 3263 | 74 |
1148145 | 1148145 | 2021-03-23 | Pickens | Georgia | 13227 | 3258 | 74 |
1144898 | 1144898 | 2021-03-22 | Pickens | Georgia | 13227 | 3254 | 74 |
1141651 | 1141651 | 2021-03-21 | Pickens | Georgia | 13227 | 3247 | 74 |
1138405 | 1138405 | 2021-03-20 | Pickens | Georgia | 13227 | 3244 | 74 |
1135159 | 1135159 | 2021-03-19 | Pickens | Georgia | 13227 | 3240 | 74 |
1131912 | 1131912 | 2021-03-18 | Pickens | Georgia | 13227 | 3240 | 74 |
1128664 | 1128664 | 2021-03-17 | Pickens | Georgia | 13227 | 3236 | 73 |
1125418 | 1125418 | 2021-03-16 | Pickens | Georgia | 13227 | 3232 | 72 |
1122172 | 1122172 | 2021-03-15 | Pickens | Georgia | 13227 | 3226 | 72 |
1118925 | 1118925 | 2021-03-14 | Pickens | Georgia | 13227 | 3225 | 72 |
1115678 | 1115678 | 2021-03-13 | Pickens | Georgia | 13227 | 3220 | 72 |
1112432 | 1112432 | 2021-03-12 | Pickens | Georgia | 13227 | 3213 | 72 |
1109186 | 1109186 | 2021-03-11 | Pickens | Georgia | 13227 | 3206 | 72 |
1105940 | 1105940 | 2021-03-10 | Pickens | Georgia | 13227 | 3203 | 72 |
1102694 | 1102694 | 2021-03-09 | Pickens | Georgia | 13227 | 3197 | 72 |
1099448 | 1099448 | 2021-03-08 | Pickens | Georgia | 13227 | 3185 | 72 |
1096200 | 1096200 | 2021-03-07 | Pickens | Georgia | 13227 | 3184 | 72 |
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);