ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
182 rows where deaths = 28 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502469 | 2502469 | 2022-05-13 | Emery | Utah | 49015 | 2486 | 28 |
2499211 | 2499211 | 2022-05-12 | Emery | Utah | 49015 | 2486 | 28 |
2495953 | 2495953 | 2022-05-11 | Emery | Utah | 49015 | 2486 | 28 |
2492695 | 2492695 | 2022-05-10 | Emery | Utah | 49015 | 2485 | 28 |
2489437 | 2489437 | 2022-05-09 | Emery | Utah | 49015 | 2482 | 28 |
2486179 | 2486179 | 2022-05-08 | Emery | Utah | 49015 | 2478 | 28 |
2482921 | 2482921 | 2022-05-07 | Emery | Utah | 49015 | 2475 | 28 |
2479663 | 2479663 | 2022-05-06 | Emery | Utah | 49015 | 2475 | 28 |
2476405 | 2476405 | 2022-05-05 | Emery | Utah | 49015 | 2475 | 28 |
2473148 | 2473148 | 2022-05-04 | Emery | Utah | 49015 | 2472 | 28 |
2469892 | 2469892 | 2022-05-03 | Emery | Utah | 49015 | 2472 | 28 |
2466636 | 2466636 | 2022-05-02 | Emery | Utah | 49015 | 2472 | 28 |
2463381 | 2463381 | 2022-05-01 | Emery | Utah | 49015 | 2470 | 28 |
2460125 | 2460125 | 2022-04-30 | Emery | Utah | 49015 | 2469 | 28 |
2456869 | 2456869 | 2022-04-29 | Emery | Utah | 49015 | 2469 | 28 |
2453613 | 2453613 | 2022-04-28 | Emery | Utah | 49015 | 2469 | 28 |
2450357 | 2450357 | 2022-04-27 | Emery | Utah | 49015 | 2469 | 28 |
2447100 | 2447100 | 2022-04-26 | Emery | Utah | 49015 | 2469 | 28 |
2443845 | 2443845 | 2022-04-25 | Emery | Utah | 49015 | 2469 | 28 |
2440589 | 2440589 | 2022-04-24 | Emery | Utah | 49015 | 2469 | 28 |
2437333 | 2437333 | 2022-04-23 | Emery | Utah | 49015 | 2469 | 28 |
2434077 | 2434077 | 2022-04-22 | Emery | Utah | 49015 | 2469 | 28 |
2430821 | 2430821 | 2022-04-21 | Emery | Utah | 49015 | 2468 | 28 |
2427565 | 2427565 | 2022-04-20 | Emery | Utah | 49015 | 2468 | 28 |
2424309 | 2424309 | 2022-04-19 | Emery | Utah | 49015 | 2468 | 28 |
2421053 | 2421053 | 2022-04-18 | Emery | Utah | 49015 | 2468 | 28 |
2417797 | 2417797 | 2022-04-17 | Emery | Utah | 49015 | 2468 | 28 |
2414541 | 2414541 | 2022-04-16 | Emery | Utah | 49015 | 2468 | 28 |
2411285 | 2411285 | 2022-04-15 | Emery | Utah | 49015 | 2468 | 28 |
2408029 | 2408029 | 2022-04-14 | Emery | Utah | 49015 | 2468 | 28 |
2404773 | 2404773 | 2022-04-13 | Emery | Utah | 49015 | 2467 | 28 |
2401518 | 2401518 | 2022-04-12 | Emery | Utah | 49015 | 2467 | 28 |
2398263 | 2398263 | 2022-04-11 | Emery | Utah | 49015 | 2467 | 28 |
2395008 | 2395008 | 2022-04-10 | Emery | Utah | 49015 | 2467 | 28 |
2391752 | 2391752 | 2022-04-09 | Emery | Utah | 49015 | 2467 | 28 |
2388496 | 2388496 | 2022-04-08 | Emery | Utah | 49015 | 2467 | 28 |
2385241 | 2385241 | 2022-04-07 | Emery | Utah | 49015 | 2467 | 28 |
2381986 | 2381986 | 2022-04-06 | Emery | Utah | 49015 | 2466 | 28 |
2378731 | 2378731 | 2022-04-05 | Emery | Utah | 49015 | 2466 | 28 |
2375477 | 2375477 | 2022-04-04 | Emery | Utah | 49015 | 2465 | 28 |
2372225 | 2372225 | 2022-04-03 | Emery | Utah | 49015 | 2465 | 28 |
2368972 | 2368972 | 2022-04-02 | Emery | Utah | 49015 | 2465 | 28 |
2365719 | 2365719 | 2022-04-01 | Emery | Utah | 49015 | 2465 | 28 |
2362466 | 2362466 | 2022-03-31 | Emery | Utah | 49015 | 2465 | 28 |
2359212 | 2359212 | 2022-03-30 | Emery | Utah | 49015 | 2465 | 28 |
2355958 | 2355958 | 2022-03-29 | Emery | Utah | 49015 | 2465 | 28 |
2352705 | 2352705 | 2022-03-28 | Emery | Utah | 49015 | 2464 | 28 |
2349453 | 2349453 | 2022-03-27 | Emery | Utah | 49015 | 2464 | 28 |
2346200 | 2346200 | 2022-03-26 | Emery | Utah | 49015 | 2464 | 28 |
2342947 | 2342947 | 2022-03-25 | Emery | Utah | 49015 | 2464 | 28 |
2339694 | 2339694 | 2022-03-24 | Emery | Utah | 49015 | 2464 | 28 |
2326681 | 2326681 | 2022-03-20 | Emery | Utah | 49015 | 2464 | 28 |
2323428 | 2323428 | 2022-03-19 | Emery | Utah | 49015 | 2464 | 28 |
2320174 | 2320174 | 2022-03-18 | Emery | Utah | 49015 | 2464 | 28 |
2316920 | 2316920 | 2022-03-17 | Emery | Utah | 49015 | 2464 | 28 |
2313667 | 2313667 | 2022-03-16 | Emery | Utah | 49015 | 2462 | 28 |
2310414 | 2310414 | 2022-03-15 | Emery | Utah | 49015 | 2462 | 28 |
2307161 | 2307161 | 2022-03-14 | Emery | Utah | 49015 | 2462 | 28 |
2303910 | 2303910 | 2022-03-13 | Emery | Utah | 49015 | 2460 | 28 |
2300658 | 2300658 | 2022-03-12 | Emery | Utah | 49015 | 2460 | 28 |
2297406 | 2297406 | 2022-03-11 | Emery | Utah | 49015 | 2460 | 28 |
2294154 | 2294154 | 2022-03-10 | Emery | Utah | 49015 | 2460 | 28 |
2290902 | 2290902 | 2022-03-09 | Emery | Utah | 49015 | 2460 | 28 |
2290915 | 2290915 | 2022-03-09 | Sevier | Utah | 49041 | 5420 | 28 |
2287663 | 2287663 | 2022-03-08 | Sevier | Utah | 49041 | 5420 | 28 |
1972246 | 1972246 | 2021-12-01 | Millard | Utah | 49027 | 2347 | 28 |
1968996 | 1968996 | 2021-11-30 | Millard | Utah | 49027 | 2347 | 28 |
1965745 | 1965745 | 2021-11-29 | Millard | Utah | 49027 | 2341 | 28 |
1917000 | 1917000 | 2021-11-14 | Wasatch | Utah | 49051 | 6366 | 28 |
1913750 | 1913750 | 2021-11-13 | Wasatch | Utah | 49051 | 6366 | 28 |
1910500 | 1910500 | 2021-11-12 | Wasatch | Utah | 49051 | 6366 | 28 |
1907251 | 1907251 | 2021-11-11 | Wasatch | Utah | 49051 | 6307 | 28 |
1904002 | 1904002 | 2021-11-10 | Wasatch | Utah | 49051 | 6307 | 28 |
1900752 | 1900752 | 2021-11-09 | Wasatch | Utah | 49051 | 6272 | 28 |
1897502 | 1897502 | 2021-11-08 | Wasatch | Utah | 49051 | 6236 | 28 |
1894252 | 1894252 | 2021-11-07 | Wasatch | Utah | 49051 | 6180 | 28 |
1891002 | 1891002 | 2021-11-06 | Wasatch | Utah | 49051 | 6180 | 28 |
1887752 | 1887752 | 2021-11-05 | Wasatch | Utah | 49051 | 6180 | 28 |
1884502 | 1884502 | 2021-11-04 | Wasatch | Utah | 49051 | 6154 | 28 |
1881253 | 1881253 | 2021-11-03 | Wasatch | Utah | 49051 | 6132 | 28 |
1878004 | 1878004 | 2021-11-02 | Wasatch | Utah | 49051 | 6107 | 28 |
1874755 | 1874755 | 2021-11-01 | Wasatch | Utah | 49051 | 6075 | 28 |
1871506 | 1871506 | 2021-10-31 | Wasatch | Utah | 49051 | 6045 | 28 |
1868257 | 1868257 | 2021-10-30 | Wasatch | Utah | 49051 | 6045 | 28 |
1865008 | 1865008 | 2021-10-29 | Wasatch | Utah | 49051 | 6045 | 28 |
1861759 | 1861759 | 2021-10-28 | Wasatch | Utah | 49051 | 6034 | 28 |
1858510 | 1858510 | 2021-10-27 | Wasatch | Utah | 49051 | 6018 | 28 |
1855238 | 1855238 | 2021-10-26 | Carbon | Utah | 49007 | 3029 | 28 |
1855261 | 1855261 | 2021-10-26 | Wasatch | Utah | 49051 | 6011 | 28 |
1851989 | 1851989 | 2021-10-25 | Carbon | Utah | 49007 | 2950 | 28 |
1852012 | 1852012 | 2021-10-25 | Wasatch | Utah | 49051 | 5990 | 28 |
1848739 | 1848739 | 2021-10-24 | Carbon | Utah | 49007 | 2940 | 28 |
1848762 | 1848762 | 2021-10-24 | Wasatch | Utah | 49051 | 5956 | 28 |
1845489 | 1845489 | 2021-10-23 | Carbon | Utah | 49007 | 2940 | 28 |
1845512 | 1845512 | 2021-10-23 | Wasatch | Utah | 49051 | 5956 | 28 |
1842239 | 1842239 | 2021-10-22 | Carbon | Utah | 49007 | 2919 | 28 |
1842262 | 1842262 | 2021-10-22 | Wasatch | Utah | 49051 | 5956 | 28 |
1839013 | 1839013 | 2021-10-21 | Wasatch | Utah | 49051 | 5941 | 28 |
1835764 | 1835764 | 2021-10-20 | Wasatch | Utah | 49051 | 5932 | 28 |
1832515 | 1832515 | 2021-10-19 | Wasatch | Utah | 49051 | 5915 | 28 |
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);