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

30 rows where date = "2021-10-05" and state = "Utah" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

fips 30

state 1

  • Utah · 30 ✖
Link rowid date ▲ county state fips cases deaths
1787003 1787003 2021-10-05 Beaver Utah 49001 985 11
1787004 1787004 2021-10-05 Box Elder Utah 49003 7643 72
1787005 1787005 2021-10-05 Cache Utah 49005 20432 59
1787006 1787006 2021-10-05 Carbon Utah 49007 2566 23
1787007 1787007 2021-10-05 Daggett Utah 49009 94 0
1787008 1787008 2021-10-05 Davis Utah 49011 50977 244
1787009 1787009 2021-10-05 Duchesne Utah 49013 2693 15
1787010 1787010 2021-10-05 Emery Utah 49015 1301 16
1787011 1787011 2021-10-05 Garfield Utah 49017 608 11
1787012 1787012 2021-10-05 Grand Utah 49019 1322 4
1787013 1787013 2021-10-05 Iron Utah 49021 8537 50
1787014 1787014 2021-10-05 Juab Utah 49023 1816 16
1787015 1787015 2021-10-05 Kane Utah 49025 902 9
1787016 1787016 2021-10-05 Millard Utah 49027 2030 24
1787017 1787017 2021-10-05 Morgan Utah 49029 1648 11
1787018 1787018 2021-10-05 Piute Utah 49031 151 2
1787019 1787019 2021-10-05 Rich Utah 49033 198 0
1787020 1787020 2021-10-05 Salt Lake Utah 49035 184456 1089
1787021 1787021 2021-10-05 San Juan Utah 49037 2252 40
1787022 1787022 2021-10-05 Sanpete Utah 49039 5078 31
1787023 1787023 2021-10-05 Sevier Utah 49041 3404 16
1787024 1787024 2021-10-05 Summit Utah 49043 6486 18
1787025 1787025 2021-10-05 Tooele Utah 49045 10763 59
1787026 1787026 2021-10-05 Uintah Utah 49047 4622 39
1787027 1787027 2021-10-05 Unknown Utah   1729 35
1787028 1787028 2021-10-05 Utah Utah 49049 119452 509
1787029 1787029 2021-10-05 Wasatch Utah 49051 5762 27
1787030 1787030 2021-10-05 Washington Utah 49053 27517 262
1787031 1787031 2021-10-05 Wayne Utah 49055 228 0
1787032 1787032 2021-10-05 Weber Utah 49057 39221 270

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