ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where "date" is on date 2021-02-22 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056382 | 1056382 | 2021-02-22 | Beaver | Utah | 49001 | 631 | 4 |
1056383 | 1056383 | 2021-02-22 | Box Elder | Utah | 49003 | 4787 | 42 |
1056384 | 1056384 | 2021-02-22 | Cache | Utah | 49005 | 14700 | 34 |
1056385 | 1056385 | 2021-02-22 | Carbon | Utah | 49007 | 1391 | 11 |
1056386 | 1056386 | 2021-02-22 | Daggett | Utah | 49009 | 37 | 0 |
1056387 | 1056387 | 2021-02-22 | Davis | Utah | 49011 | 34251 | 135 |
1056388 | 1056388 | 2021-02-22 | Duchesne | Utah | 49013 | 1106 | 9 |
1056389 | 1056389 | 2021-02-22 | Emery | Utah | 49015 | 779 | 8 |
1056390 | 1056390 | 2021-02-22 | Garfield | Utah | 49017 | 412 | 9 |
1056391 | 1056391 | 2021-02-22 | Grand | Utah | 49019 | 658 | 3 |
1056392 | 1056392 | 2021-02-22 | Iron | Utah | 49021 | 4924 | 30 |
1056393 | 1056393 | 2021-02-22 | Juab | Utah | 49023 | 1193 | 10 |
1056394 | 1056394 | 2021-02-22 | Kane | Utah | 49025 | 495 | 3 |
1056395 | 1056395 | 2021-02-22 | Millard | Utah | 49027 | 1354 | 10 |
1056396 | 1056396 | 2021-02-22 | Morgan | Utah | 49029 | 1119 | 11 |
1056397 | 1056397 | 2021-02-22 | Piute | Utah | 49031 | 96 | 2 |
1056398 | 1056398 | 2021-02-22 | Rich | Utah | 49033 | 123 | 0 |
1056399 | 1056399 | 2021-02-22 | Salt Lake | Utah | 49035 | 137262 | 734 |
1056400 | 1056400 | 2021-02-22 | San Juan | Utah | 49037 | 1796 | 36 |
1056401 | 1056401 | 2021-02-22 | Sanpete | Utah | 49039 | 3467 | 19 |
1056402 | 1056402 | 2021-02-22 | Sevier | Utah | 49041 | 1984 | 9 |
1056403 | 1056403 | 2021-02-22 | Summit | Utah | 49043 | 4912 | 8 |
1056404 | 1056404 | 2021-02-22 | Tooele | Utah | 49045 | 6446 | 30 |
1056405 | 1056405 | 2021-02-22 | Uintah | Utah | 49047 | 2195 | 18 |
1056406 | 1056406 | 2021-02-22 | Unknown | Utah | 1214 | 2 | |
1056407 | 1056407 | 2021-02-22 | Utah | Utah | 49049 | 89131 | 319 |
1056408 | 1056408 | 2021-02-22 | Wasatch | Utah | 49051 | 4290 | 20 |
1056409 | 1056409 | 2021-02-22 | Washington | Utah | 49053 | 19898 | 176 |
1056410 | 1056410 | 2021-02-22 | Wayne | Utah | 49055 | 123 | 0 |
1056411 | 1056411 | 2021-02-22 | Weber | Utah | 49057 | 26356 | 161 |
Advanced export
JSON shape: default, array, newline-delimited
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);