ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where county = "Clay" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418155 | 1418155 | 2021-06-14 | Clay | Kentucky | 21051 | 2696 | 46 |
1414909 | 1414909 | 2021-06-13 | Clay | Kentucky | 21051 | 2696 | 46 |
1411664 | 1411664 | 2021-06-12 | Clay | Kentucky | 21051 | 2696 | 46 |
1408419 | 1408419 | 2021-06-11 | Clay | Kentucky | 21051 | 2696 | 46 |
1405173 | 1405173 | 2021-06-10 | Clay | Kentucky | 21051 | 2696 | 46 |
1401928 | 1401928 | 2021-06-09 | Clay | Kentucky | 21051 | 2696 | 46 |
1398683 | 1398683 | 2021-06-08 | Clay | Kentucky | 21051 | 2696 | 46 |
1395436 | 1395436 | 2021-06-07 | Clay | Kentucky | 21051 | 2695 | 46 |
1392191 | 1392191 | 2021-06-06 | Clay | Kentucky | 21051 | 2695 | 46 |
1388946 | 1388946 | 2021-06-05 | Clay | Kentucky | 21051 | 2695 | 46 |
1385701 | 1385701 | 2021-06-04 | Clay | Kentucky | 21051 | 2693 | 46 |
1382455 | 1382455 | 2021-06-03 | Clay | Kentucky | 21051 | 2690 | 46 |
1379210 | 1379210 | 2021-06-02 | Clay | Kentucky | 21051 | 2689 | 46 |
1375964 | 1375964 | 2021-06-01 | Clay | Kentucky | 21051 | 2686 | 46 |
1372719 | 1372719 | 2021-05-31 | Clay | Kentucky | 21051 | 2684 | 45 |
1369474 | 1369474 | 2021-05-30 | Clay | Kentucky | 21051 | 2684 | 45 |
1366228 | 1366228 | 2021-05-29 | Clay | Kentucky | 21051 | 2684 | 45 |
1362982 | 1362982 | 2021-05-28 | Clay | Kentucky | 21051 | 2683 | 44 |
1359735 | 1359735 | 2021-05-27 | Clay | Kentucky | 21051 | 2683 | 44 |
1356489 | 1356489 | 2021-05-26 | Clay | Kentucky | 21051 | 2682 | 44 |
1353243 | 1353243 | 2021-05-25 | Clay | Kentucky | 21051 | 2681 | 44 |
1349997 | 1349997 | 2021-05-24 | Clay | Kentucky | 21051 | 2680 | 44 |
1346750 | 1346750 | 2021-05-23 | Clay | Kentucky | 21051 | 2680 | 44 |
1343502 | 1343502 | 2021-05-22 | Clay | Kentucky | 21051 | 2679 | 44 |
1340254 | 1340254 | 2021-05-21 | Clay | Kentucky | 21051 | 2678 | 44 |
1337007 | 1337007 | 2021-05-20 | Clay | Kentucky | 21051 | 2678 | 44 |
1333760 | 1333760 | 2021-05-19 | Clay | Kentucky | 21051 | 2678 | 44 |
1330513 | 1330513 | 2021-05-18 | Clay | Kentucky | 21051 | 2677 | 44 |
1327266 | 1327266 | 2021-05-17 | Clay | Kentucky | 21051 | 2675 | 44 |
1324020 | 1324020 | 2021-05-16 | Clay | Kentucky | 21051 | 2675 | 44 |
1320774 | 1320774 | 2021-05-15 | Clay | Kentucky | 21051 | 2675 | 44 |
1317527 | 1317527 | 2021-05-14 | Clay | Kentucky | 21051 | 2673 | 44 |
1314280 | 1314280 | 2021-05-13 | Clay | Kentucky | 21051 | 2672 | 44 |
1311033 | 1311033 | 2021-05-12 | Clay | Kentucky | 21051 | 2673 | 44 |
1307787 | 1307787 | 2021-05-11 | Clay | Kentucky | 21051 | 2671 | 44 |
1304541 | 1304541 | 2021-05-10 | Clay | Kentucky | 21051 | 2668 | 44 |
1301294 | 1301294 | 2021-05-09 | Clay | Kentucky | 21051 | 2664 | 44 |
1298047 | 1298047 | 2021-05-08 | Clay | Kentucky | 21051 | 2664 | 44 |
1294801 | 1294801 | 2021-05-07 | Clay | Kentucky | 21051 | 2665 | 44 |
1291555 | 1291555 | 2021-05-06 | Clay | Kentucky | 21051 | 2658 | 44 |
1288309 | 1288309 | 2021-05-05 | Clay | Kentucky | 21051 | 2657 | 44 |
1285063 | 1285063 | 2021-05-04 | Clay | Kentucky | 21051 | 2657 | 44 |
1281816 | 1281816 | 2021-05-03 | Clay | Kentucky | 21051 | 2656 | 44 |
1278569 | 1278569 | 2021-05-02 | Clay | Kentucky | 21051 | 2654 | 44 |
1275322 | 1275322 | 2021-05-01 | Clay | Kentucky | 21051 | 2654 | 44 |
1272075 | 1272075 | 2021-04-30 | Clay | Kentucky | 21051 | 2653 | 43 |
1268828 | 1268828 | 2021-04-29 | Clay | Kentucky | 21051 | 2650 | 43 |
1265581 | 1265581 | 2021-04-28 | Clay | Kentucky | 21051 | 2650 | 42 |
1262334 | 1262334 | 2021-04-27 | Clay | Kentucky | 21051 | 2648 | 42 |
1259087 | 1259087 | 2021-04-26 | Clay | Kentucky | 21051 | 2645 | 41 |
1255840 | 1255840 | 2021-04-25 | Clay | Kentucky | 21051 | 2643 | 41 |
1252593 | 1252593 | 2021-04-24 | Clay | Kentucky | 21051 | 2643 | 41 |
1249346 | 1249346 | 2021-04-23 | Clay | Kentucky | 21051 | 2641 | 41 |
1246099 | 1246099 | 2021-04-22 | Clay | Kentucky | 21051 | 2639 | 41 |
1242852 | 1242852 | 2021-04-21 | Clay | Kentucky | 21051 | 2635 | 41 |
1239605 | 1239605 | 2021-04-20 | Clay | Kentucky | 21051 | 2631 | 41 |
1236358 | 1236358 | 2021-04-19 | Clay | Kentucky | 21051 | 2624 | 40 |
1233111 | 1233111 | 2021-04-18 | Clay | Kentucky | 21051 | 2621 | 40 |
1229863 | 1229863 | 2021-04-17 | Clay | Kentucky | 21051 | 2621 | 39 |
1226615 | 1226615 | 2021-04-16 | Clay | Kentucky | 21051 | 2619 | 39 |
1223368 | 1223368 | 2021-04-15 | Clay | Kentucky | 21051 | 2617 | 39 |
1220120 | 1220120 | 2021-04-14 | Clay | Kentucky | 21051 | 2613 | 39 |
1216872 | 1216872 | 2021-04-13 | Clay | Kentucky | 21051 | 2607 | 39 |
1213625 | 1213625 | 2021-04-12 | Clay | Kentucky | 21051 | 2603 | 39 |
1210377 | 1210377 | 2021-04-11 | Clay | Kentucky | 21051 | 2600 | 38 |
1207128 | 1207128 | 2021-04-10 | Clay | Kentucky | 21051 | 2600 | 38 |
1203880 | 1203880 | 2021-04-09 | Clay | Kentucky | 21051 | 2599 | 38 |
1200632 | 1200632 | 2021-04-08 | Clay | Kentucky | 21051 | 2597 | 38 |
1197383 | 1197383 | 2021-04-07 | Clay | Kentucky | 21051 | 2595 | 38 |
1194135 | 1194135 | 2021-04-06 | Clay | Kentucky | 21051 | 2592 | 38 |
1190885 | 1190885 | 2021-04-05 | Clay | Kentucky | 21051 | 2589 | 38 |
1187638 | 1187638 | 2021-04-04 | Clay | Kentucky | 21051 | 2591 | 37 |
1184391 | 1184391 | 2021-04-03 | Clay | Kentucky | 21051 | 2591 | 37 |
1181144 | 1181144 | 2021-04-02 | Clay | Kentucky | 21051 | 2587 | 37 |
1177897 | 1177897 | 2021-04-01 | Clay | Kentucky | 21051 | 2581 | 37 |
1174650 | 1174650 | 2021-03-31 | Clay | Kentucky | 21051 | 2581 | 36 |
1171403 | 1171403 | 2021-03-30 | Clay | Kentucky | 21051 | 2577 | 36 |
1168155 | 1168155 | 2021-03-29 | Clay | Kentucky | 21051 | 2574 | 36 |
1164907 | 1164907 | 2021-03-28 | Clay | Kentucky | 21051 | 2572 | 36 |
1161659 | 1161659 | 2021-03-27 | Clay | Kentucky | 21051 | 2568 | 36 |
1158411 | 1158411 | 2021-03-26 | Clay | Kentucky | 21051 | 2570 | 36 |
1155164 | 1155164 | 2021-03-25 | Clay | Kentucky | 21051 | 2563 | 36 |
1151917 | 1151917 | 2021-03-24 | Clay | Kentucky | 21051 | 2558 | 35 |
1148670 | 1148670 | 2021-03-23 | Clay | Kentucky | 21051 | 2557 | 33 |
1145423 | 1145423 | 2021-03-22 | Clay | Kentucky | 21051 | 2551 | 33 |
1142176 | 1142176 | 2021-03-21 | Clay | Kentucky | 21051 | 2547 | 33 |
1138930 | 1138930 | 2021-03-20 | Clay | Kentucky | 21051 | 2547 | 33 |
1135684 | 1135684 | 2021-03-19 | Clay | Kentucky | 21051 | 2539 | 33 |
1132437 | 1132437 | 2021-03-18 | Clay | Kentucky | 21051 | 2537 | 32 |
1129189 | 1129189 | 2021-03-17 | Clay | Kentucky | 21051 | 2528 | 30 |
1125943 | 1125943 | 2021-03-16 | Clay | Kentucky | 21051 | 2523 | 30 |
1122697 | 1122697 | 2021-03-15 | Clay | Kentucky | 21051 | 2514 | 30 |
1119450 | 1119450 | 2021-03-14 | Clay | Kentucky | 21051 | 2505 | 30 |
1116203 | 1116203 | 2021-03-13 | Clay | Kentucky | 21051 | 2501 | 30 |
1112957 | 1112957 | 2021-03-12 | Clay | Kentucky | 21051 | 2492 | 30 |
1109711 | 1109711 | 2021-03-11 | Clay | Kentucky | 21051 | 2486 | 30 |
1106465 | 1106465 | 2021-03-10 | Clay | Kentucky | 21051 | 2480 | 28 |
1103219 | 1103219 | 2021-03-09 | Clay | Kentucky | 21051 | 2471 | 28 |
1099973 | 1099973 | 2021-03-08 | Clay | Kentucky | 21051 | 2464 | 28 |
1096725 | 1096725 | 2021-03-07 | Clay | Kentucky | 21051 | 2463 | 28 |
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);