ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

13,908 rows where county = "Clay" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 18

county 1

  • Clay · 13,908 ✖
Link rowid date ▲ county state fips cases deaths
2499588 2499588 2022-05-13 Clay Alabama 1027 4099 82
2499696 2499696 2022-05-13 Clay Arkansas 5021 4154 93
2499907 2499907 2022-05-13 Clay Florida 12019 53825 856
2499995 2499995 2022-05-13 Clay Georgia 13061 533 6
2500189 2500189 2022-05-13 Clay Illinois 17025 4750 74
2500290 2500290 2022-05-13 Clay Indiana 18021 6856 88
2500393 2500393 2022-05-13 Clay Iowa 19041 4120 44
2500486 2500486 2022-05-13 Clay Kansas 20027 1985 35
2500604 2500604 2022-05-13 Clay Kentucky 21051 7867 92
2500918 2500918 2022-05-13 Clay Minnesota 27027 20161 124
2501005 2501005 2022-05-13 Clay Mississippi 28025 4974 98
2501099 2501099 2022-05-13 Clay Missouri 29047 27390 363
2501266 2501266 2022-05-13 Clay Nebraska 31035 1512 24
2501507 2501507 2022-05-13 Clay North Carolina 37043 2634 44
2502057 2502057 2022-05-13 Clay South Dakota 46027 3493 21
2502124 2502124 2022-05-13 Clay Tennessee 47027 2300 50
2502245 2502245 2022-05-13 Clay Texas 48077 2096 35
2502690 2502690 2022-05-13 Clay West Virginia 54015 2351 41
2496330 2496330 2022-05-12 Clay Alabama 1027 4097 82
2496438 2496438 2022-05-12 Clay Arkansas 5021 4154 93
2496649 2496649 2022-05-12 Clay Florida 12019 53825 856
2496737 2496737 2022-05-12 Clay Georgia 13061 533 6
2496931 2496931 2022-05-12 Clay Illinois 17025 4748 74
2497032 2497032 2022-05-12 Clay Indiana 18021 6852 88
2497135 2497135 2022-05-12 Clay Iowa 19041 4120 44
2497228 2497228 2022-05-12 Clay Kansas 20027 1981 35
2497346 2497346 2022-05-12 Clay Kentucky 21051 7867 92
2497660 2497660 2022-05-12 Clay Minnesota 27027 20138 124
2497747 2497747 2022-05-12 Clay Mississippi 28025 4974 98
2497841 2497841 2022-05-12 Clay Missouri 29047 27246 361
2498008 2498008 2022-05-12 Clay Nebraska 31035 1513 24
2498249 2498249 2022-05-12 Clay North Carolina 37043 2634 44
2498799 2498799 2022-05-12 Clay South Dakota 46027 3493 21
2498866 2498866 2022-05-12 Clay Tennessee 47027 2300 50
2498987 2498987 2022-05-12 Clay Texas 48077 2095 35
2499432 2499432 2022-05-12 Clay West Virginia 54015 2348 41
2493072 2493072 2022-05-11 Clay Alabama 1027 4092 82
2493180 2493180 2022-05-11 Clay Arkansas 5021 4152 93
2493391 2493391 2022-05-11 Clay Florida 12019 53825 856
2493479 2493479 2022-05-11 Clay Georgia 13061 533 6
2493673 2493673 2022-05-11 Clay Illinois 17025 4748 74
2493774 2493774 2022-05-11 Clay Indiana 18021 6852 88
2493877 2493877 2022-05-11 Clay Iowa 19041 4120 44
2493970 2493970 2022-05-11 Clay Kansas 20027 1981 35
2494088 2494088 2022-05-11 Clay Kentucky 21051 7867 92
2494402 2494402 2022-05-11 Clay Minnesota 27027 20112 124
2494489 2494489 2022-05-11 Clay Mississippi 28025 4974 98
2494583 2494583 2022-05-11 Clay Missouri 29047 27246 361
2494750 2494750 2022-05-11 Clay Nebraska 31035 1513 24
2494991 2494991 2022-05-11 Clay North Carolina 37043 2634 44
2495541 2495541 2022-05-11 Clay South Dakota 46027 3493 21
2495608 2495608 2022-05-11 Clay Tennessee 47027 2300 50
2495729 2495729 2022-05-11 Clay Texas 48077 2095 35
2496174 2496174 2022-05-11 Clay West Virginia 54015 2348 41
2489814 2489814 2022-05-10 Clay Alabama 1027 4092 82
2489922 2489922 2022-05-10 Clay Arkansas 5021 4152 93
2490133 2490133 2022-05-10 Clay Florida 12019 53825 855
2490221 2490221 2022-05-10 Clay Georgia 13061 533 6
2490415 2490415 2022-05-10 Clay Illinois 17025 4747 74
2490516 2490516 2022-05-10 Clay Indiana 18021 6849 88
2490619 2490619 2022-05-10 Clay Iowa 19041 4113 44
2490712 2490712 2022-05-10 Clay Kansas 20027 1981 35
2490830 2490830 2022-05-10 Clay Kentucky 21051 7867 92
2491144 2491144 2022-05-10 Clay Minnesota 27027 20087 124
2491231 2491231 2022-05-10 Clay Mississippi 28025 4974 98
2491325 2491325 2022-05-10 Clay Missouri 29047 27246 361
2491492 2491492 2022-05-10 Clay Nebraska 31035 1517 24
2491733 2491733 2022-05-10 Clay North Carolina 37043 2629 44
2492283 2492283 2022-05-10 Clay South Dakota 46027 3489 21
2492350 2492350 2022-05-10 Clay Tennessee 47027 2297 50
2492471 2492471 2022-05-10 Clay Texas 48077 2095 35
2492916 2492916 2022-05-10 Clay West Virginia 54015 2345 41
2486557 2486557 2022-05-09 Clay Alabama 1027 4091 82
2486665 2486665 2022-05-09 Clay Arkansas 5021 4152 93
2486876 2486876 2022-05-09 Clay Florida 12019 53825 855
2486964 2486964 2022-05-09 Clay Georgia 13061 533 6
2487158 2487158 2022-05-09 Clay Illinois 17025 4747 74
2487259 2487259 2022-05-09 Clay Indiana 18021 6849 88
2487362 2487362 2022-05-09 Clay Iowa 19041 4113 44
2487455 2487455 2022-05-09 Clay Kansas 20027 1981 35
2487573 2487573 2022-05-09 Clay Kentucky 21051 7867 92
2487887 2487887 2022-05-09 Clay Minnesota 27027 20066 124
2487974 2487974 2022-05-09 Clay Mississippi 28025 4974 98
2488067 2488067 2022-05-09 Clay Missouri 29047 27246 361
2488234 2488234 2022-05-09 Clay Nebraska 31035 1517 24
2488475 2488475 2022-05-09 Clay North Carolina 37043 2629 44
2489025 2489025 2022-05-09 Clay South Dakota 46027 3489 21
2489092 2489092 2022-05-09 Clay Tennessee 47027 2297 50
2489213 2489213 2022-05-09 Clay Texas 48077 2094 35
2489658 2489658 2022-05-09 Clay West Virginia 54015 2345 41
2483299 2483299 2022-05-08 Clay Alabama 1027 4090 82
2483407 2483407 2022-05-08 Clay Arkansas 5021 4151 93
2483618 2483618 2022-05-08 Clay Florida 12019 53825 855
2483706 2483706 2022-05-08 Clay Georgia 13061 533 6
2483900 2483900 2022-05-08 Clay Illinois 17025 4747 74
2484001 2484001 2022-05-08 Clay Indiana 18021 6840 88
2484104 2484104 2022-05-08 Clay Iowa 19041 4113 44
2484197 2484197 2022-05-08 Clay Kansas 20027 1981 35
2484315 2484315 2022-05-08 Clay Kentucky 21051 7866 92
2484629 2484629 2022-05-08 Clay Minnesota 27027 20034 124

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);