ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13,908 rows where county = "Clay" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 18
- Florida 391
- Minnesota 383
- Mississippi 382
- Missouri 380
- Alabama 378
- Kansas 376
- Indiana 374
- South Dakota 374
- Georgia 373
- Iowa 372
- North Carolina 372
- Tennessee 371
- Texas 371
- Arkansas 366
- Nebraska 362
- Illinois 358
- Kentucky 353
- West Virginia 336
fips 18
county 1
- Clay · 6,672 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193122 | 1193122 | 2021-04-06 | Clay | Alabama | 1027 | 1488 | 54 |
1193229 | 1193229 | 2021-04-06 | Clay | Arkansas | 5021 | 1723 | 50 |
1193440 | 1193440 | 2021-04-06 | Clay | Florida | 12019 | 17496 | 329 |
1193528 | 1193528 | 2021-04-06 | Clay | Georgia | 13061 | 237 | 3 |
1193721 | 1193721 | 2021-04-06 | Clay | Illinois | 17025 | 1462 | 47 |
1193822 | 1193822 | 2021-04-06 | Clay | Indiana | 18021 | 2487 | 44 |
1193924 | 1193924 | 2021-04-06 | Clay | Iowa | 19041 | 2060 | 25 |
1194017 | 1194017 | 2021-04-06 | Clay | Kansas | 20027 | 826 | 27 |
1194135 | 1194135 | 2021-04-06 | Clay | Kentucky | 21051 | 2592 | 38 |
1194448 | 1194448 | 2021-04-06 | Clay | Minnesota | 27027 | 7507 | 89 |
1194535 | 1194535 | 2021-04-06 | Clay | Mississippi | 28025 | 1821 | 54 |
1194628 | 1194628 | 2021-04-06 | Clay | Missouri | 29047 | 9970 | 160 |
1194795 | 1194795 | 2021-04-06 | Clay | Nebraska | 31035 | 679 | 11 |
1195034 | 1195034 | 2021-04-06 | Clay | North Carolina | 37043 | 687 | 18 |
1195582 | 1195582 | 2021-04-06 | Clay | South Dakota | 46027 | 1875 | 15 |
1195649 | 1195649 | 2021-04-06 | Clay | Tennessee | 47027 | 1082 | 31 |
1195770 | 1195770 | 2021-04-06 | Clay | Texas | 48077 | 1023 | 16 |
1196214 | 1196214 | 2021-04-06 | Clay | West Virginia | 54015 | 414 | 9 |
1189872 | 1189872 | 2021-04-05 | Clay | Alabama | 1027 | 1485 | 54 |
1189979 | 1189979 | 2021-04-05 | Clay | Arkansas | 5021 | 1723 | 50 |
1190190 | 1190190 | 2021-04-05 | Clay | Florida | 12019 | 17480 | 329 |
1190278 | 1190278 | 2021-04-05 | Clay | Georgia | 13061 | 237 | 3 |
1190471 | 1190471 | 2021-04-05 | Clay | Illinois | 17025 | 1462 | 47 |
1190572 | 1190572 | 2021-04-05 | Clay | Indiana | 18021 | 2483 | 44 |
1190674 | 1190674 | 2021-04-05 | Clay | Iowa | 19041 | 2052 | 25 |
1190767 | 1190767 | 2021-04-05 | Clay | Kansas | 20027 | 826 | 27 |
1190885 | 1190885 | 2021-04-05 | Clay | Kentucky | 21051 | 2589 | 38 |
1191199 | 1191199 | 2021-04-05 | Clay | Minnesota | 27027 | 7467 | 89 |
1191286 | 1191286 | 2021-04-05 | Clay | Mississippi | 28025 | 1821 | 54 |
1191379 | 1191379 | 2021-04-05 | Clay | Missouri | 29047 | 9970 | 159 |
1191546 | 1191546 | 2021-04-05 | Clay | Nebraska | 31035 | 679 | 11 |
1191786 | 1191786 | 2021-04-05 | Clay | North Carolina | 37043 | 687 | 18 |
1192334 | 1192334 | 2021-04-05 | Clay | South Dakota | 46027 | 1875 | 15 |
1192401 | 1192401 | 2021-04-05 | Clay | Tennessee | 47027 | 1080 | 31 |
1192522 | 1192522 | 2021-04-05 | Clay | Texas | 48077 | 1023 | 16 |
1192966 | 1192966 | 2021-04-05 | Clay | West Virginia | 54015 | 413 | 9 |
1186625 | 1186625 | 2021-04-04 | Clay | Alabama | 1027 | 1485 | 54 |
1186732 | 1186732 | 2021-04-04 | Clay | Arkansas | 5021 | 1723 | 50 |
1186943 | 1186943 | 2021-04-04 | Clay | Florida | 12019 | 17462 | 329 |
1187031 | 1187031 | 2021-04-04 | Clay | Georgia | 13061 | 237 | 3 |
1187224 | 1187224 | 2021-04-04 | Clay | Illinois | 17025 | 1462 | 47 |
1187325 | 1187325 | 2021-04-04 | Clay | Indiana | 18021 | 2481 | 44 |
1187427 | 1187427 | 2021-04-04 | Clay | Iowa | 19041 | 2040 | 25 |
1187520 | 1187520 | 2021-04-04 | Clay | Kansas | 20027 | 826 | 27 |
1187638 | 1187638 | 2021-04-04 | Clay | Kentucky | 21051 | 2591 | 37 |
1187951 | 1187951 | 2021-04-04 | Clay | Minnesota | 27027 | 7461 | 89 |
1188038 | 1188038 | 2021-04-04 | Clay | Mississippi | 28025 | 1821 | 54 |
1188131 | 1188131 | 2021-04-04 | Clay | Missouri | 29047 | 9970 | 159 |
1188298 | 1188298 | 2021-04-04 | Clay | Nebraska | 31035 | 678 | 11 |
1188537 | 1188537 | 2021-04-04 | Clay | North Carolina | 37043 | 684 | 18 |
1189085 | 1189085 | 2021-04-04 | Clay | South Dakota | 46027 | 1874 | 15 |
1189152 | 1189152 | 2021-04-04 | Clay | Tennessee | 47027 | 1079 | 31 |
1189273 | 1189273 | 2021-04-04 | Clay | Texas | 48077 | 1023 | 16 |
1189716 | 1189716 | 2021-04-04 | Clay | West Virginia | 54015 | 413 | 9 |
1183378 | 1183378 | 2021-04-03 | Clay | Alabama | 1027 | 1485 | 54 |
1183485 | 1183485 | 2021-04-03 | Clay | Arkansas | 5021 | 1723 | 50 |
1183696 | 1183696 | 2021-04-03 | Clay | Florida | 12019 | 17447 | 329 |
1183784 | 1183784 | 2021-04-03 | Clay | Georgia | 13061 | 237 | 3 |
1183977 | 1183977 | 2021-04-03 | Clay | Illinois | 17025 | 1460 | 47 |
1184078 | 1184078 | 2021-04-03 | Clay | Indiana | 18021 | 2481 | 44 |
1184180 | 1184180 | 2021-04-03 | Clay | Iowa | 19041 | 2040 | 25 |
1184273 | 1184273 | 2021-04-03 | Clay | Kansas | 20027 | 826 | 27 |
1184391 | 1184391 | 2021-04-03 | Clay | Kentucky | 21051 | 2591 | 37 |
1184704 | 1184704 | 2021-04-03 | Clay | Minnesota | 27027 | 7461 | 89 |
1184791 | 1184791 | 2021-04-03 | Clay | Mississippi | 28025 | 1820 | 54 |
1184884 | 1184884 | 2021-04-03 | Clay | Missouri | 29047 | 9970 | 159 |
1185051 | 1185051 | 2021-04-03 | Clay | Nebraska | 31035 | 678 | 11 |
1185290 | 1185290 | 2021-04-03 | Clay | North Carolina | 37043 | 684 | 18 |
1185838 | 1185838 | 2021-04-03 | Clay | South Dakota | 46027 | 1874 | 15 |
1185905 | 1185905 | 2021-04-03 | Clay | Tennessee | 47027 | 1079 | 31 |
1186026 | 1186026 | 2021-04-03 | Clay | Texas | 48077 | 1023 | 16 |
1186469 | 1186469 | 2021-04-03 | Clay | West Virginia | 54015 | 410 | 9 |
1180131 | 1180131 | 2021-04-02 | Clay | Alabama | 1027 | 1485 | 54 |
1180238 | 1180238 | 2021-04-02 | Clay | Arkansas | 5021 | 1723 | 50 |
1180449 | 1180449 | 2021-04-02 | Clay | Florida | 12019 | 17414 | 329 |
1180537 | 1180537 | 2021-04-02 | Clay | Georgia | 13061 | 237 | 3 |
1180730 | 1180730 | 2021-04-02 | Clay | Illinois | 17025 | 1460 | 47 |
1180831 | 1180831 | 2021-04-02 | Clay | Indiana | 18021 | 2475 | 44 |
1180933 | 1180933 | 2021-04-02 | Clay | Iowa | 19041 | 2038 | 25 |
1181026 | 1181026 | 2021-04-02 | Clay | Kansas | 20027 | 826 | 27 |
1181144 | 1181144 | 2021-04-02 | Clay | Kentucky | 21051 | 2587 | 37 |
1181458 | 1181458 | 2021-04-02 | Clay | Minnesota | 27027 | 7409 | 89 |
1181545 | 1181545 | 2021-04-02 | Clay | Mississippi | 28025 | 1819 | 54 |
1181638 | 1181638 | 2021-04-02 | Clay | Missouri | 29047 | 9970 | 159 |
1181805 | 1181805 | 2021-04-02 | Clay | Nebraska | 31035 | 677 | 11 |
1182043 | 1182043 | 2021-04-02 | Clay | North Carolina | 37043 | 684 | 18 |
1182591 | 1182591 | 2021-04-02 | Clay | South Dakota | 46027 | 1873 | 15 |
1182658 | 1182658 | 2021-04-02 | Clay | Tennessee | 47027 | 1079 | 31 |
1182779 | 1182779 | 2021-04-02 | Clay | Texas | 48077 | 1023 | 16 |
1183222 | 1183222 | 2021-04-02 | Clay | West Virginia | 54015 | 407 | 9 |
1176884 | 1176884 | 2021-04-01 | Clay | Alabama | 1027 | 1483 | 54 |
1176991 | 1176991 | 2021-04-01 | Clay | Arkansas | 5021 | 1723 | 50 |
1177202 | 1177202 | 2021-04-01 | Clay | Florida | 12019 | 17390 | 329 |
1177290 | 1177290 | 2021-04-01 | Clay | Georgia | 13061 | 236 | 3 |
1177483 | 1177483 | 2021-04-01 | Clay | Illinois | 17025 | 1457 | 47 |
1177584 | 1177584 | 2021-04-01 | Clay | Indiana | 18021 | 2472 | 44 |
1177686 | 1177686 | 2021-04-01 | Clay | Iowa | 19041 | 2033 | 25 |
1177779 | 1177779 | 2021-04-01 | Clay | Kansas | 20027 | 826 | 27 |
1177897 | 1177897 | 2021-04-01 | Clay | Kentucky | 21051 | 2581 | 37 |
1178211 | 1178211 | 2021-04-01 | Clay | Minnesota | 27027 | 7382 | 89 |
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);