ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
167 rows where deaths = 30 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502482 | 2502482 | 2022-05-13 | Sevier | Utah | 49041 | 5448 | 30 |
2499224 | 2499224 | 2022-05-12 | Sevier | Utah | 49041 | 5448 | 30 |
2495966 | 2495966 | 2022-05-11 | Sevier | Utah | 49041 | 5447 | 30 |
2492708 | 2492708 | 2022-05-10 | Sevier | Utah | 49041 | 5446 | 30 |
2489450 | 2489450 | 2022-05-09 | Sevier | Utah | 49041 | 5446 | 30 |
2486192 | 2486192 | 2022-05-08 | Sevier | Utah | 49041 | 5444 | 30 |
2482934 | 2482934 | 2022-05-07 | Sevier | Utah | 49041 | 5444 | 30 |
2479676 | 2479676 | 2022-05-06 | Sevier | Utah | 49041 | 5444 | 30 |
2476418 | 2476418 | 2022-05-05 | Sevier | Utah | 49041 | 5444 | 30 |
2473161 | 2473161 | 2022-05-04 | Sevier | Utah | 49041 | 5444 | 30 |
2469905 | 2469905 | 2022-05-03 | Sevier | Utah | 49041 | 5444 | 30 |
2466649 | 2466649 | 2022-05-02 | Sevier | Utah | 49041 | 5443 | 30 |
2463394 | 2463394 | 2022-05-01 | Sevier | Utah | 49041 | 5439 | 30 |
2460138 | 2460138 | 2022-04-30 | Sevier | Utah | 49041 | 5439 | 30 |
2456882 | 2456882 | 2022-04-29 | Sevier | Utah | 49041 | 5439 | 30 |
2453626 | 2453626 | 2022-04-28 | Sevier | Utah | 49041 | 5439 | 30 |
2450370 | 2450370 | 2022-04-27 | Sevier | Utah | 49041 | 5439 | 30 |
2447113 | 2447113 | 2022-04-26 | Sevier | Utah | 49041 | 5439 | 30 |
2443858 | 2443858 | 2022-04-25 | Sevier | Utah | 49041 | 5439 | 30 |
2440602 | 2440602 | 2022-04-24 | Sevier | Utah | 49041 | 5439 | 30 |
2437346 | 2437346 | 2022-04-23 | Sevier | Utah | 49041 | 5439 | 30 |
2434090 | 2434090 | 2022-04-22 | Sevier | Utah | 49041 | 5439 | 30 |
2430834 | 2430834 | 2022-04-21 | Sevier | Utah | 49041 | 5439 | 30 |
2427578 | 2427578 | 2022-04-20 | Sevier | Utah | 49041 | 5438 | 30 |
2424322 | 2424322 | 2022-04-19 | Sevier | Utah | 49041 | 5438 | 30 |
2421066 | 2421066 | 2022-04-18 | Sevier | Utah | 49041 | 5438 | 30 |
2417810 | 2417810 | 2022-04-17 | Sevier | Utah | 49041 | 5438 | 30 |
2414554 | 2414554 | 2022-04-16 | Sevier | Utah | 49041 | 5438 | 30 |
2411298 | 2411298 | 2022-04-15 | Sevier | Utah | 49041 | 5438 | 30 |
2408042 | 2408042 | 2022-04-14 | Sevier | Utah | 49041 | 5438 | 30 |
2381999 | 2381999 | 2022-04-06 | Sevier | Utah | 49041 | 5430 | 30 |
2378744 | 2378744 | 2022-04-05 | Sevier | Utah | 49041 | 5430 | 30 |
2375490 | 2375490 | 2022-04-04 | Sevier | Utah | 49041 | 5430 | 30 |
2372238 | 2372238 | 2022-04-03 | Sevier | Utah | 49041 | 5430 | 30 |
2368985 | 2368985 | 2022-04-02 | Sevier | Utah | 49041 | 5430 | 30 |
2365732 | 2365732 | 2022-04-01 | Sevier | Utah | 49041 | 5430 | 30 |
2362479 | 2362479 | 2022-03-31 | Sevier | Utah | 49041 | 5430 | 30 |
2359225 | 2359225 | 2022-03-30 | Sevier | Utah | 49041 | 5430 | 30 |
2355971 | 2355971 | 2022-03-29 | Sevier | Utah | 49041 | 5428 | 30 |
2352718 | 2352718 | 2022-03-28 | Sevier | Utah | 49041 | 5428 | 30 |
2349466 | 2349466 | 2022-03-27 | Sevier | Utah | 49041 | 5427 | 30 |
2346213 | 2346213 | 2022-03-26 | Sevier | Utah | 49041 | 5427 | 30 |
2342960 | 2342960 | 2022-03-25 | Sevier | Utah | 49041 | 5427 | 30 |
2339707 | 2339707 | 2022-03-24 | Sevier | Utah | 49041 | 5427 | 30 |
2336453 | 2336453 | 2022-03-23 | Sevier | Utah | 49041 | 5427 | 30 |
2333199 | 2333199 | 2022-03-22 | Sevier | Utah | 49041 | 5424 | 30 |
2329946 | 2329946 | 2022-03-21 | Sevier | Utah | 49041 | 5424 | 30 |
2326694 | 2326694 | 2022-03-20 | Sevier | Utah | 49041 | 5424 | 30 |
2323441 | 2323441 | 2022-03-19 | Sevier | Utah | 49041 | 5424 | 30 |
2320187 | 2320187 | 2022-03-18 | Sevier | Utah | 49041 | 5424 | 30 |
2316933 | 2316933 | 2022-03-17 | Sevier | Utah | 49041 | 5424 | 30 |
2313680 | 2313680 | 2022-03-16 | Sevier | Utah | 49041 | 5424 | 30 |
2310427 | 2310427 | 2022-03-15 | Sevier | Utah | 49041 | 5423 | 30 |
2307174 | 2307174 | 2022-03-14 | Sevier | Utah | 49041 | 5422 | 30 |
2303923 | 2303923 | 2022-03-13 | Sevier | Utah | 49041 | 5422 | 30 |
2300671 | 2300671 | 2022-03-12 | Sevier | Utah | 49041 | 5422 | 30 |
2297419 | 2297419 | 2022-03-11 | Sevier | Utah | 49041 | 5422 | 30 |
2008000 | 2008000 | 2021-12-12 | Millard | Utah | 49027 | 2387 | 30 |
2004749 | 2004749 | 2021-12-11 | Millard | Utah | 49027 | 2387 | 30 |
2001498 | 2001498 | 2021-12-10 | Millard | Utah | 49027 | 2387 | 30 |
1998248 | 1998248 | 2021-12-09 | Millard | Utah | 49027 | 2382 | 30 |
1994997 | 1994997 | 2021-12-08 | Millard | Utah | 49027 | 2381 | 30 |
1995010 | 1995010 | 2021-12-08 | Wasatch | Utah | 49051 | 6796 | 30 |
1991746 | 1991746 | 2021-12-07 | Millard | Utah | 49027 | 2376 | 30 |
1991759 | 1991759 | 2021-12-07 | Wasatch | Utah | 49051 | 6785 | 30 |
1887729 | 1887729 | 2021-11-05 | Carbon | Utah | 49007 | 3300 | 30 |
1884479 | 1884479 | 2021-11-04 | Carbon | Utah | 49007 | 3269 | 30 |
1881230 | 1881230 | 2021-11-03 | Carbon | Utah | 49007 | 3235 | 30 |
1877981 | 1877981 | 2021-11-02 | Carbon | Utah | 49007 | 3198 | 30 |
1874732 | 1874732 | 2021-11-01 | Carbon | Utah | 49007 | 3145 | 30 |
1871483 | 1871483 | 2021-10-31 | Carbon | Utah | 49007 | 3145 | 30 |
1868234 | 1868234 | 2021-10-30 | Carbon | Utah | 49007 | 3145 | 30 |
1864985 | 1864985 | 2021-10-29 | Carbon | Utah | 49007 | 3126 | 30 |
1861736 | 1861736 | 2021-10-28 | Carbon | Utah | 49007 | 3104 | 30 |
1761027 | 1761027 | 2021-09-27 | Sanpete | Utah | 49039 | 4941 | 30 |
1757779 | 1757779 | 2021-09-26 | Sanpete | Utah | 49039 | 4941 | 30 |
1754531 | 1754531 | 2021-09-25 | Sanpete | Utah | 49039 | 4941 | 30 |
1751283 | 1751283 | 2021-09-24 | Sanpete | Utah | 49039 | 4941 | 30 |
1748034 | 1748034 | 2021-09-23 | Sanpete | Utah | 49039 | 4920 | 30 |
1744784 | 1744784 | 2021-09-22 | Sanpete | Utah | 49039 | 4903 | 30 |
1741535 | 1741535 | 2021-09-21 | Sanpete | Utah | 49039 | 4873 | 30 |
1715547 | 1715547 | 2021-09-13 | Unknown | Utah | 1567 | 30 | |
1712301 | 1712301 | 2021-09-12 | Unknown | Utah | 1415 | 30 | |
1709054 | 1709054 | 2021-09-11 | Unknown | Utah | 1415 | 30 | |
1705807 | 1705807 | 2021-09-10 | Unknown | Utah | 1426 | 30 | |
1696060 | 1696060 | 2021-09-07 | Unknown | Utah | 1490 | 30 | |
1647333 | 1647333 | 2021-08-23 | Uintah | Utah | 49047 | 3555 | 30 |
1644084 | 1644084 | 2021-08-22 | Uintah | Utah | 49047 | 3524 | 30 |
1640834 | 1640834 | 2021-08-21 | Uintah | Utah | 49047 | 3524 | 30 |
1637584 | 1637584 | 2021-08-20 | Uintah | Utah | 49047 | 3524 | 30 |
1634334 | 1634334 | 2021-08-19 | Uintah | Utah | 49047 | 3517 | 30 |
1631087 | 1631087 | 2021-08-18 | Uintah | Utah | 49047 | 3515 | 30 |
1627840 | 1627840 | 2021-08-17 | Uintah | Utah | 49047 | 3510 | 30 |
1624593 | 1624593 | 2021-08-16 | Uintah | Utah | 49047 | 3479 | 30 |
1621346 | 1621346 | 2021-08-15 | Uintah | Utah | 49047 | 3479 | 30 |
1618098 | 1618098 | 2021-08-14 | Uintah | Utah | 49047 | 3479 | 30 |
1614850 | 1614850 | 2021-08-13 | Uintah | Utah | 49047 | 3479 | 30 |
1611601 | 1611601 | 2021-08-12 | Uintah | Utah | 49047 | 3470 | 30 |
1608353 | 1608353 | 2021-08-11 | Uintah | Utah | 49047 | 3458 | 30 |
1605104 | 1605104 | 2021-08-10 | Uintah | Utah | 49047 | 3446 | 30 |
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);