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 346
- Minnesota 338
- Mississippi 338
- Missouri 336
- Alabama 333
- Kansas 331
- South Dakota 330
- Indiana 329
- Georgia 328
- North Carolina 328
- Iowa 327
- Tennessee 327
- Texas 327
- Arkansas 321
- Nebraska 318
- Illinois 313
- Kentucky 308
- West Virginia 292
fips 18
county 1
- Clay · 5,870 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1051686 | 1051686 | 2021-02-21 | Clay | Mississippi | 28025 | 1769 | 48 |
1051779 | 1051779 | 2021-02-21 | Clay | Missouri | 29047 | 9386 | 143 |
1051946 | 1051946 | 2021-02-21 | Clay | Nebraska | 31035 | 649 | 11 |
1052185 | 1052185 | 2021-02-21 | Clay | North Carolina | 37043 | 646 | 18 |
1052732 | 1052732 | 2021-02-21 | Clay | South Dakota | 46027 | 1781 | 15 |
1052799 | 1052799 | 2021-02-21 | Clay | Tennessee | 47027 | 1056 | 30 |
1052920 | 1052920 | 2021-02-21 | Clay | Texas | 48077 | 988 | 16 |
1053363 | 1053363 | 2021-02-21 | Clay | West Virginia | 54015 | 370 | 4 |
1047025 | 1047025 | 2021-02-20 | Clay | Alabama | 1027 | 1416 | 54 |
1047132 | 1047132 | 2021-02-20 | Clay | Arkansas | 5021 | 1661 | 46 |
1047343 | 1047343 | 2021-02-20 | Clay | Florida | 12019 | 16500 | 297 |
1047431 | 1047431 | 2021-02-20 | Clay | Georgia | 13061 | 228 | 3 |
1047624 | 1047624 | 2021-02-20 | Clay | Illinois | 17025 | 1421 | 46 |
1047725 | 1047725 | 2021-02-20 | Clay | Indiana | 18021 | 2381 | 43 |
1047827 | 1047827 | 2021-02-20 | Clay | Iowa | 19041 | 1823 | 25 |
1047920 | 1047920 | 2021-02-20 | Clay | Kansas | 20027 | 817 | 24 |
1048038 | 1048038 | 2021-02-20 | Clay | Kentucky | 21051 | 2342 | 26 |
1048352 | 1048352 | 2021-02-20 | Clay | Minnesota | 27027 | 6790 | 84 |
1048439 | 1048439 | 2021-02-20 | Clay | Mississippi | 28025 | 1768 | 48 |
1048532 | 1048532 | 2021-02-20 | Clay | Missouri | 29047 | 9386 | 143 |
1048699 | 1048699 | 2021-02-20 | Clay | Nebraska | 31035 | 649 | 11 |
1048938 | 1048938 | 2021-02-20 | Clay | North Carolina | 37043 | 645 | 18 |
1049485 | 1049485 | 2021-02-20 | Clay | South Dakota | 46027 | 1779 | 15 |
1049552 | 1049552 | 2021-02-20 | Clay | Tennessee | 47027 | 1056 | 30 |
1049673 | 1049673 | 2021-02-20 | Clay | Texas | 48077 | 988 | 16 |
1050116 | 1050116 | 2021-02-20 | Clay | West Virginia | 54015 | 370 | 4 |
1043780 | 1043780 | 2021-02-19 | Clay | Alabama | 1027 | 1409 | 54 |
1043887 | 1043887 | 2021-02-19 | Clay | Arkansas | 5021 | 1660 | 46 |
1044098 | 1044098 | 2021-02-19 | Clay | Florida | 12019 | 16462 | 297 |
1044186 | 1044186 | 2021-02-19 | Clay | Georgia | 13061 | 228 | 3 |
1044379 | 1044379 | 2021-02-19 | Clay | Illinois | 17025 | 1421 | 46 |
1044480 | 1044480 | 2021-02-19 | Clay | Indiana | 18021 | 2376 | 43 |
1044582 | 1044582 | 2021-02-19 | Clay | Iowa | 19041 | 1823 | 25 |
1044675 | 1044675 | 2021-02-19 | Clay | Kansas | 20027 | 773 | 24 |
1044793 | 1044793 | 2021-02-19 | Clay | Kentucky | 21051 | 2337 | 26 |
1045106 | 1045106 | 2021-02-19 | Clay | Minnesota | 27027 | 6780 | 84 |
1045193 | 1045193 | 2021-02-19 | Clay | Mississippi | 28025 | 1765 | 48 |
1045286 | 1045286 | 2021-02-19 | Clay | Missouri | 29047 | 9386 | 141 |
1045453 | 1045453 | 2021-02-19 | Clay | Nebraska | 31035 | 649 | 11 |
1045691 | 1045691 | 2021-02-19 | Clay | North Carolina | 37043 | 642 | 18 |
1046238 | 1046238 | 2021-02-19 | Clay | South Dakota | 46027 | 1778 | 15 |
1046305 | 1046305 | 2021-02-19 | Clay | Tennessee | 47027 | 1055 | 29 |
1046426 | 1046426 | 2021-02-19 | Clay | Texas | 48077 | 988 | 16 |
1046869 | 1046869 | 2021-02-19 | Clay | West Virginia | 54015 | 370 | 4 |
1040535 | 1040535 | 2021-02-18 | Clay | Alabama | 1027 | 1407 | 53 |
1040642 | 1040642 | 2021-02-18 | Clay | Arkansas | 5021 | 1659 | 46 |
1040853 | 1040853 | 2021-02-18 | Clay | Florida | 12019 | 16417 | 295 |
1040941 | 1040941 | 2021-02-18 | Clay | Georgia | 13061 | 228 | 3 |
1041134 | 1041134 | 2021-02-18 | Clay | Illinois | 17025 | 1417 | 46 |
1041235 | 1041235 | 2021-02-18 | Clay | Indiana | 18021 | 2373 | 42 |
1041337 | 1041337 | 2021-02-18 | Clay | Iowa | 19041 | 1821 | 25 |
1041430 | 1041430 | 2021-02-18 | Clay | Kansas | 20027 | 816 | 24 |
1041548 | 1041548 | 2021-02-18 | Clay | Kentucky | 21051 | 2335 | 26 |
1041861 | 1041861 | 2021-02-18 | Clay | Minnesota | 27027 | 6768 | 84 |
1041948 | 1041948 | 2021-02-18 | Clay | Mississippi | 28025 | 1765 | 48 |
1042041 | 1042041 | 2021-02-18 | Clay | Missouri | 29047 | 9371 | 141 |
1042208 | 1042208 | 2021-02-18 | Clay | Nebraska | 31035 | 648 | 11 |
1042446 | 1042446 | 2021-02-18 | Clay | North Carolina | 37043 | 640 | 18 |
1042993 | 1042993 | 2021-02-18 | Clay | South Dakota | 46027 | 1777 | 15 |
1043060 | 1043060 | 2021-02-18 | Clay | Tennessee | 47027 | 1055 | 29 |
1043181 | 1043181 | 2021-02-18 | Clay | Texas | 48077 | 988 | 16 |
1043624 | 1043624 | 2021-02-18 | Clay | West Virginia | 54015 | 370 | 4 |
1037290 | 1037290 | 2021-02-17 | Clay | Alabama | 1027 | 1403 | 53 |
1037397 | 1037397 | 2021-02-17 | Clay | Arkansas | 5021 | 1658 | 45 |
1037608 | 1037608 | 2021-02-17 | Clay | Florida | 12019 | 16375 | 283 |
1037696 | 1037696 | 2021-02-17 | Clay | Georgia | 13061 | 227 | 3 |
1037889 | 1037889 | 2021-02-17 | Clay | Illinois | 17025 | 1415 | 46 |
1037990 | 1037990 | 2021-02-17 | Clay | Indiana | 18021 | 2372 | 42 |
1038092 | 1038092 | 2021-02-17 | Clay | Iowa | 19041 | 1820 | 25 |
1038185 | 1038185 | 2021-02-17 | Clay | Kansas | 20027 | 816 | 24 |
1038303 | 1038303 | 2021-02-17 | Clay | Kentucky | 21051 | 2329 | 26 |
1038616 | 1038616 | 2021-02-17 | Clay | Minnesota | 27027 | 6752 | 84 |
1038703 | 1038703 | 2021-02-17 | Clay | Mississippi | 28025 | 1765 | 48 |
1038796 | 1038796 | 2021-02-17 | Clay | Missouri | 29047 | 9351 | 137 |
1038963 | 1038963 | 2021-02-17 | Clay | Nebraska | 31035 | 648 | 11 |
1039201 | 1039201 | 2021-02-17 | Clay | North Carolina | 37043 | 634 | 18 |
1039748 | 1039748 | 2021-02-17 | Clay | South Dakota | 46027 | 1775 | 15 |
1039815 | 1039815 | 2021-02-17 | Clay | Tennessee | 47027 | 1056 | 29 |
1039936 | 1039936 | 2021-02-17 | Clay | Texas | 48077 | 988 | 16 |
1040379 | 1040379 | 2021-02-17 | Clay | West Virginia | 54015 | 370 | 4 |
1034045 | 1034045 | 2021-02-16 | Clay | Alabama | 1027 | 1399 | 53 |
1034152 | 1034152 | 2021-02-16 | Clay | Arkansas | 5021 | 1656 | 45 |
1034363 | 1034363 | 2021-02-16 | Clay | Florida | 12019 | 16331 | 283 |
1034451 | 1034451 | 2021-02-16 | Clay | Georgia | 13061 | 227 | 3 |
1034644 | 1034644 | 2021-02-16 | Clay | Illinois | 17025 | 1413 | 46 |
1034745 | 1034745 | 2021-02-16 | Clay | Indiana | 18021 | 2367 | 42 |
1034847 | 1034847 | 2021-02-16 | Clay | Iowa | 19041 | 1816 | 25 |
1034940 | 1034940 | 2021-02-16 | Clay | Kansas | 20027 | 816 | 23 |
1035058 | 1035058 | 2021-02-16 | Clay | Kentucky | 21051 | 2329 | 26 |
1035371 | 1035371 | 2021-02-16 | Clay | Minnesota | 27027 | 6746 | 84 |
1035458 | 1035458 | 2021-02-16 | Clay | Mississippi | 28025 | 1764 | 48 |
1035551 | 1035551 | 2021-02-16 | Clay | Missouri | 29047 | 9256 | 137 |
1035718 | 1035718 | 2021-02-16 | Clay | Nebraska | 31035 | 651 | 11 |
1035956 | 1035956 | 2021-02-16 | Clay | North Carolina | 37043 | 633 | 18 |
1036503 | 1036503 | 2021-02-16 | Clay | South Dakota | 46027 | 1774 | 15 |
1036570 | 1036570 | 2021-02-16 | Clay | Tennessee | 47027 | 1056 | 29 |
1036691 | 1036691 | 2021-02-16 | Clay | Texas | 48077 | 983 | 16 |
1037134 | 1037134 | 2021-02-16 | Clay | West Virginia | 54015 | 370 | 4 |
1030799 | 1030799 | 2021-02-15 | Clay | Alabama | 1027 | 1394 | 53 |
1030906 | 1030906 | 2021-02-15 | Clay | Arkansas | 5021 | 1656 | 44 |
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);