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

44 rows where date = "2021-03-23" and state = "Idaho" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Idaho · 44 ✖
Link rowid date ▲ county state fips cases deaths
1148200 1148200 2021-03-23 Ada Idaho 16001 48545 447
1148201 1148201 2021-03-23 Adams Idaho 16003 336 4
1148202 1148202 2021-03-23 Bannock Idaho 16005 8256 98
1148203 1148203 2021-03-23 Bear Lake Idaho 16007 367 2
1148204 1148204 2021-03-23 Benewah Idaho 16009 644 9
1148205 1148205 2021-03-23 Bingham Idaho 16011 4576 69
1148206 1148206 2021-03-23 Blaine Idaho 16013 2231 17
1148207 1148207 2021-03-23 Boise Idaho 16015 319 2
1148208 1148208 2021-03-23 Bonner Idaho 16017 3078 38
1148209 1148209 2021-03-23 Bonneville Idaho 16019 13664 157
1148210 1148210 2021-03-23 Boundary Idaho 16021 839 10
1148211 1148211 2021-03-23 Butte Idaho 16023 201 1
1148212 1148212 2021-03-23 Camas Idaho 16025 71 0
1148213 1148213 2021-03-23 Canyon Idaho 16027 25333 286
1148214 1148214 2021-03-23 Caribou Idaho 16029 633 12
1148215 1148215 2021-03-23 Cassia Idaho 16031 2890 25
1148216 1148216 2021-03-23 Clark Idaho 16033 56 0
1148217 1148217 2021-03-23 Clearwater Idaho 16035 1020 12
1148218 1148218 2021-03-23 Custer Idaho 16037 239 3
1148219 1148219 2021-03-23 Elmore Idaho 16039 1720 13
1148220 1148220 2021-03-23 Franklin Idaho 16041 1125 16
1148221 1148221 2021-03-23 Fremont Idaho 16043 1068 14
1148222 1148222 2021-03-23 Gem Idaho 16045 1719 34
1148223 1148223 2021-03-23 Gooding Idaho 16047 1277 23
1148224 1148224 2021-03-23 Idaho Idaho 16049 1190 17
1148225 1148225 2021-03-23 Jefferson Idaho 16051 2711 22
1148226 1148226 2021-03-23 Jerome Idaho 16053 2530 23
1148227 1148227 2021-03-23 Kootenai Idaho 16055 17093 193
1148228 1148228 2021-03-23 Latah Idaho 16057 2894 8
1148229 1148229 2021-03-23 Lemhi Idaho 16059 515 9
1148230 1148230 2021-03-23 Lewis Idaho 16061 383 9
1148231 1148231 2021-03-23 Lincoln Idaho 16063 491 11
1148232 1148232 2021-03-23 Madison Idaho 16065 6733 22
1148233 1148233 2021-03-23 Minidoka Idaho 16067 2305 32
1148234 1148234 2021-03-23 Nez Perce Idaho 16069 3461 53
1148235 1148235 2021-03-23 Oneida Idaho 16071 337 4
1148236 1148236 2021-03-23 Owyhee Idaho 16073 1031 26
1148237 1148237 2021-03-23 Payette Idaho 16075 2427 32
1148238 1148238 2021-03-23 Power Idaho 16077 652 9
1148239 1148239 2021-03-23 Shoshone Idaho 16079 1040 33
1148240 1148240 2021-03-23 Teton Idaho 16081 1133 4
1148241 1148241 2021-03-23 Twin Falls Idaho 16083 9108 127
1148242 1148242 2021-03-23 Valley Idaho 16085 820 7
1148243 1148243 2021-03-23 Washington Idaho 16087 1193 21

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