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

This data as json, CSV (advanced)

Suggested facets: date (date)

fips

county

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