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 787
- Minnesota 779
- Mississippi 779
- Missouri 777
- Alabama 774
- Kansas 772
- South Dakota 771
- Indiana 770
- Georgia 769
- North Carolina 769
- Iowa 768
- Tennessee 768
- Texas 768
- Arkansas 762
- Nebraska 759
- Illinois 754
- Kentucky 749
- West Virginia 733
fips 18
county 1
- Clay · 13,808 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484716 | 2484716 | 2022-05-08 | Clay | Mississippi | 28025 | 4968 | 98 |
2484810 | 2484810 | 2022-05-08 | Clay | Missouri | 29047 | 27246 | 361 |
2484977 | 2484977 | 2022-05-08 | Clay | Nebraska | 31035 | 1514 | 24 |
2485218 | 2485218 | 2022-05-08 | Clay | North Carolina | 37043 | 2629 | 44 |
2485768 | 2485768 | 2022-05-08 | Clay | South Dakota | 46027 | 3489 | 21 |
2485835 | 2485835 | 2022-05-08 | Clay | Tennessee | 47027 | 2297 | 50 |
2485956 | 2485956 | 2022-05-08 | Clay | Texas | 48077 | 2094 | 35 |
2486401 | 2486401 | 2022-05-08 | Clay | West Virginia | 54015 | 2343 | 41 |
2480041 | 2480041 | 2022-05-07 | Clay | Alabama | 1027 | 4090 | 82 |
2480149 | 2480149 | 2022-05-07 | Clay | Arkansas | 5021 | 4150 | 93 |
2480360 | 2480360 | 2022-05-07 | Clay | Florida | 12019 | 53825 | 855 |
2480448 | 2480448 | 2022-05-07 | Clay | Georgia | 13061 | 533 | 6 |
2480642 | 2480642 | 2022-05-07 | Clay | Illinois | 17025 | 4747 | 74 |
2480743 | 2480743 | 2022-05-07 | Clay | Indiana | 18021 | 6840 | 88 |
2480846 | 2480846 | 2022-05-07 | Clay | Iowa | 19041 | 4113 | 44 |
2480939 | 2480939 | 2022-05-07 | Clay | Kansas | 20027 | 1981 | 35 |
2481057 | 2481057 | 2022-05-07 | Clay | Kentucky | 21051 | 7866 | 92 |
2481371 | 2481371 | 2022-05-07 | Clay | Minnesota | 27027 | 20034 | 124 |
2481458 | 2481458 | 2022-05-07 | Clay | Mississippi | 28025 | 4968 | 98 |
2481552 | 2481552 | 2022-05-07 | Clay | Missouri | 29047 | 27246 | 361 |
2481719 | 2481719 | 2022-05-07 | Clay | Nebraska | 31035 | 1514 | 24 |
2481960 | 2481960 | 2022-05-07 | Clay | North Carolina | 37043 | 2629 | 44 |
2482510 | 2482510 | 2022-05-07 | Clay | South Dakota | 46027 | 3489 | 21 |
2482577 | 2482577 | 2022-05-07 | Clay | Tennessee | 47027 | 2297 | 50 |
2482698 | 2482698 | 2022-05-07 | Clay | Texas | 48077 | 2094 | 35 |
2483143 | 2483143 | 2022-05-07 | Clay | West Virginia | 54015 | 2343 | 41 |
2476783 | 2476783 | 2022-05-06 | Clay | Alabama | 1027 | 4090 | 82 |
2476891 | 2476891 | 2022-05-06 | Clay | Arkansas | 5021 | 4149 | 93 |
2477102 | 2477102 | 2022-05-06 | Clay | Florida | 12019 | 53825 | 855 |
2477190 | 2477190 | 2022-05-06 | Clay | Georgia | 13061 | 533 | 6 |
2477384 | 2477384 | 2022-05-06 | Clay | Illinois | 17025 | 4747 | 74 |
2477485 | 2477485 | 2022-05-06 | Clay | Indiana | 18021 | 6840 | 88 |
2477588 | 2477588 | 2022-05-06 | Clay | Iowa | 19041 | 4113 | 44 |
2477681 | 2477681 | 2022-05-06 | Clay | Kansas | 20027 | 1981 | 35 |
2477799 | 2477799 | 2022-05-06 | Clay | Kentucky | 21051 | 7866 | 92 |
2478113 | 2478113 | 2022-05-06 | Clay | Minnesota | 27027 | 20034 | 124 |
2478200 | 2478200 | 2022-05-06 | Clay | Mississippi | 28025 | 4968 | 98 |
2478294 | 2478294 | 2022-05-06 | Clay | Missouri | 29047 | 27246 | 361 |
2478461 | 2478461 | 2022-05-06 | Clay | Nebraska | 31035 | 1514 | 24 |
2478702 | 2478702 | 2022-05-06 | Clay | North Carolina | 37043 | 2629 | 44 |
2479252 | 2479252 | 2022-05-06 | Clay | South Dakota | 46027 | 3489 | 21 |
2479319 | 2479319 | 2022-05-06 | Clay | Tennessee | 47027 | 2297 | 50 |
2479440 | 2479440 | 2022-05-06 | Clay | Texas | 48077 | 2094 | 35 |
2479885 | 2479885 | 2022-05-06 | Clay | West Virginia | 54015 | 2343 | 41 |
2473525 | 2473525 | 2022-05-05 | Clay | Alabama | 1027 | 4090 | 82 |
2473633 | 2473633 | 2022-05-05 | Clay | Arkansas | 5021 | 4143 | 93 |
2473844 | 2473844 | 2022-05-05 | Clay | Florida | 12019 | 53548 | 855 |
2473932 | 2473932 | 2022-05-05 | Clay | Georgia | 13061 | 533 | 6 |
2474126 | 2474126 | 2022-05-05 | Clay | Illinois | 17025 | 4746 | 74 |
2474227 | 2474227 | 2022-05-05 | Clay | Indiana | 18021 | 6840 | 88 |
2474330 | 2474330 | 2022-05-05 | Clay | Iowa | 19041 | 4113 | 44 |
2474423 | 2474423 | 2022-05-05 | Clay | Kansas | 20027 | 1975 | 35 |
2474541 | 2474541 | 2022-05-05 | Clay | Kentucky | 21051 | 7866 | 92 |
2474855 | 2474855 | 2022-05-05 | Clay | Minnesota | 27027 | 20010 | 124 |
2474942 | 2474942 | 2022-05-05 | Clay | Mississippi | 28025 | 4968 | 98 |
2475036 | 2475036 | 2022-05-05 | Clay | Missouri | 29047 | 27106 | 361 |
2475203 | 2475203 | 2022-05-05 | Clay | Nebraska | 31035 | 1514 | 24 |
2475444 | 2475444 | 2022-05-05 | Clay | North Carolina | 37043 | 2629 | 44 |
2475994 | 2475994 | 2022-05-05 | Clay | South Dakota | 46027 | 3489 | 21 |
2476061 | 2476061 | 2022-05-05 | Clay | Tennessee | 47027 | 2297 | 50 |
2476182 | 2476182 | 2022-05-05 | Clay | Texas | 48077 | 2094 | 35 |
2476627 | 2476627 | 2022-05-05 | Clay | West Virginia | 54015 | 2343 | 41 |
2470268 | 2470268 | 2022-05-04 | Clay | Alabama | 1027 | 4089 | 82 |
2470376 | 2470376 | 2022-05-04 | Clay | Arkansas | 5021 | 4134 | 93 |
2470587 | 2470587 | 2022-05-04 | Clay | Florida | 12019 | 53548 | 855 |
2470675 | 2470675 | 2022-05-04 | Clay | Georgia | 13061 | 533 | 6 |
2470869 | 2470869 | 2022-05-04 | Clay | Illinois | 17025 | 4745 | 74 |
2470970 | 2470970 | 2022-05-04 | Clay | Indiana | 18021 | 6840 | 88 |
2471073 | 2471073 | 2022-05-04 | Clay | Iowa | 19041 | 4113 | 44 |
2471166 | 2471166 | 2022-05-04 | Clay | Kansas | 20027 | 1975 | 35 |
2471284 | 2471284 | 2022-05-04 | Clay | Kentucky | 21051 | 7866 | 92 |
2471598 | 2471598 | 2022-05-04 | Clay | Minnesota | 27027 | 19985 | 124 |
2471685 | 2471685 | 2022-05-04 | Clay | Mississippi | 28025 | 4968 | 98 |
2471779 | 2471779 | 2022-05-04 | Clay | Missouri | 29047 | 26987 | 351 |
2471946 | 2471946 | 2022-05-04 | Clay | Nebraska | 31035 | 1511 | 24 |
2472187 | 2472187 | 2022-05-04 | Clay | North Carolina | 37043 | 2629 | 44 |
2472737 | 2472737 | 2022-05-04 | Clay | South Dakota | 46027 | 3489 | 21 |
2472804 | 2472804 | 2022-05-04 | Clay | Tennessee | 47027 | 2297 | 50 |
2472925 | 2472925 | 2022-05-04 | Clay | Texas | 48077 | 2094 | 35 |
2473369 | 2473369 | 2022-05-04 | Clay | West Virginia | 54015 | 2343 | 41 |
2467012 | 2467012 | 2022-05-03 | Clay | Alabama | 1027 | 4089 | 82 |
2467120 | 2467120 | 2022-05-03 | Clay | Arkansas | 5021 | 4132 | 93 |
2467331 | 2467331 | 2022-05-03 | Clay | Florida | 12019 | 53548 | 854 |
2467419 | 2467419 | 2022-05-03 | Clay | Georgia | 13061 | 532 | 6 |
2467613 | 2467613 | 2022-05-03 | Clay | Illinois | 17025 | 4745 | 74 |
2467714 | 2467714 | 2022-05-03 | Clay | Indiana | 18021 | 6835 | 88 |
2467817 | 2467817 | 2022-05-03 | Clay | Iowa | 19041 | 4107 | 44 |
2467910 | 2467910 | 2022-05-03 | Clay | Kansas | 20027 | 1975 | 35 |
2468028 | 2468028 | 2022-05-03 | Clay | Kentucky | 21051 | 7866 | 92 |
2468342 | 2468342 | 2022-05-03 | Clay | Minnesota | 27027 | 19968 | 124 |
2468429 | 2468429 | 2022-05-03 | Clay | Mississippi | 28025 | 4968 | 98 |
2468523 | 2468523 | 2022-05-03 | Clay | Missouri | 29047 | 26987 | 351 |
2468690 | 2468690 | 2022-05-03 | Clay | Nebraska | 31035 | 1516 | 24 |
2468931 | 2468931 | 2022-05-03 | Clay | North Carolina | 37043 | 2627 | 40 |
2469481 | 2469481 | 2022-05-03 | Clay | South Dakota | 46027 | 3489 | 21 |
2469548 | 2469548 | 2022-05-03 | Clay | Tennessee | 47027 | 2296 | 50 |
2469669 | 2469669 | 2022-05-03 | Clay | Texas | 48077 | 2087 | 35 |
2470112 | 2470112 | 2022-05-03 | Clay | West Virginia | 54015 | 2343 | 41 |
2463757 | 2463757 | 2022-05-02 | Clay | Alabama | 1027 | 4088 | 82 |
2463865 | 2463865 | 2022-05-02 | Clay | Arkansas | 5021 | 4131 | 93 |
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);