ny_times_us_counties

⚠️ 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

1,686 rows where county = "Clay" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

  • Clay · 1,686
Link rowid date ▲ county state fips cases deaths
291773 2020-07-03 Clay Alabama 1027 62 2
291879 2020-07-03 Clay Arkansas 5021 64 3
292086 2020-07-03 Clay Florida 12019 871 34
292174 2020-07-03 Clay Georgia 13061 56 2
292363 2020-07-03 Clay Illinois 17025 2 0
292464 2020-07-03 Clay Indiana 18021 60 4
292566 2020-07-03 Clay Iowa 19041 129 0
292659 2020-07-03 Clay Kansas 20027 7 2
292767 2020-07-03 Clay Kentucky 21051 68 3
293080 2020-07-03 Clay Minnesota 27027 585 38
293166 2020-07-03 Clay Mississippi 28025 247 10
293259 2020-07-03 Clay Missouri 29047 478 16
293405 2020-07-03 Clay Nebraska 31035 27 0
293630 2020-07-03 Clay North Carolina 37043 12 0
294089 2020-07-03 Clay South Dakota 46027 87 0
294151 2020-07-03 Clay Tennessee 47027 16 0
294270 2020-07-03 Clay Texas 48077 9 0
294700 2020-07-03 Clay West Virginia 54015 10 1
288697 2020-07-02 Clay Alabama 1027 61 2
288802 2020-07-02 Clay Arkansas 5021 62 3
289009 2020-07-02 Clay Florida 12019 801 34
289097 2020-07-02 Clay Georgia 13061 56 2
289285 2020-07-02 Clay Illinois 17025 2 0
289385 2020-07-02 Clay Indiana 18021 59 4
289487 2020-07-02 Clay Iowa 19041 127 0
289580 2020-07-02 Clay Kansas 20027 7 2
289688 2020-07-02 Clay Kentucky 21051 64 3
290001 2020-07-02 Clay Minnesota 27027 580 37
290087 2020-07-02 Clay Mississippi 28025 244 10
290180 2020-07-02 Clay Missouri 29047 472 16
290325 2020-07-02 Clay Nebraska 31035 27 0
290549 2020-07-02 Clay North Carolina 37043 10 0
291008 2020-07-02 Clay South Dakota 46027 85 0
291070 2020-07-02 Clay Tennessee 47027 16 0
291189 2020-07-02 Clay Texas 48077 8 0
291617 2020-07-02 Clay West Virginia 54015 10 1
285623 2020-07-01 Clay Alabama 1027 58 2
285727 2020-07-01 Clay Arkansas 5021 59 3
285934 2020-07-01 Clay Florida 12019 729 34
286022 2020-07-01 Clay Georgia 13061 57 2
286210 2020-07-01 Clay Illinois 17025 2 0
286310 2020-07-01 Clay Indiana 18021 59 4
286412 2020-07-01 Clay Iowa 19041 126 0
286505 2020-07-01 Clay Kansas 20027 7 2
286613 2020-07-01 Clay Kentucky 21051 62 3
286926 2020-07-01 Clay Minnesota 27027 576 37
287012 2020-07-01 Clay Mississippi 28025 242 10
287105 2020-07-01 Clay Missouri 29047 460 16
287249 2020-07-01 Clay Nebraska 31035 27 0
287473 2020-07-01 Clay North Carolina 37043 10 0
287931 2020-07-01 Clay South Dakota 46027 83 0
287993 2020-07-01 Clay Tennessee 47027 16 0
288113 2020-07-01 Clay Texas 48077 8 0
288541 2020-07-01 Clay West Virginia 54015 10 1
282550 2020-06-30 Clay Alabama 1027 53 2
282654 2020-06-30 Clay Arkansas 5021 54 3
282861 2020-06-30 Clay Florida 12019 713 34
282949 2020-06-30 Clay Georgia 13061 57 2
283138 2020-06-30 Clay Illinois 17025 2 0
283238 2020-06-30 Clay Indiana 18021 59 4
283340 2020-06-30 Clay Iowa 19041 123 0
283433 2020-06-30 Clay Kansas 20027 6 2
283542 2020-06-30 Clay Kentucky 21051 59 3
283854 2020-06-30 Clay Minnesota 27027 563 37
283940 2020-06-30 Clay Mississippi 28025 240 10
284033 2020-06-30 Clay Missouri 29047 454 16
284177 2020-06-30 Clay Nebraska 31035 27 0
284400 2020-06-30 Clay North Carolina 37043 10 0
284858 2020-06-30 Clay South Dakota 46027 82 0
284920 2020-06-30 Clay Tennessee 47027 16 0
285039 2020-06-30 Clay Texas 48077 7 0
285467 2020-06-30 Clay West Virginia 54015 10 1
279481 2020-06-29 Clay Alabama 1027 48 2
279585 2020-06-29 Clay Arkansas 5021 54 3
279792 2020-06-29 Clay Florida 12019 682 34
279880 2020-06-29 Clay Georgia 13061 57 2
280066 2020-06-29 Clay Illinois 17025 2 0
280166 2020-06-29 Clay Indiana 18021 59 4
280268 2020-06-29 Clay Iowa 19041 120 0
280361 2020-06-29 Clay Kansas 20027 6 2
280470 2020-06-29 Clay Kentucky 21051 53 3
280781 2020-06-29 Clay Minnesota 27027 560 37
280867 2020-06-29 Clay Mississippi 28025 237 8
280960 2020-06-29 Clay Missouri 29047 443 14
281104 2020-06-29 Clay Nebraska 31035 27 0
281327 2020-06-29 Clay North Carolina 37043 9 0
281784 2020-06-29 Clay South Dakota 46027 80 0
281846 2020-06-29 Clay Tennessee 47027 14 0
281966 2020-06-29 Clay Texas 48077 6 0
282394 2020-06-29 Clay West Virginia 54015 10 1
276413 2020-06-28 Clay Alabama 1027 35 2
276517 2020-06-28 Clay Arkansas 5021 54 3
276724 2020-06-28 Clay Florida 12019 659 34
276812 2020-06-28 Clay Georgia 13061 57 2
276999 2020-06-28 Clay Illinois 17025 2 0
277099 2020-06-28 Clay Indiana 18021 59 4
277201 2020-06-28 Clay Iowa 19041 119 0
277294 2020-06-28 Clay Kansas 20027 6 2
277401 2020-06-28 Clay Kentucky 21051 53 3
277713 2020-06-28 Clay Minnesota 27027 557 37

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
);
Powered by Datasette · Query took 975.61ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette