ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
327 rows where deaths = 22 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 |
---|---|---|---|---|---|---|---|
2290916 | 2290916 | 2022-03-09 | Summit | Utah | 49043 | 13376 | 22 |
2287664 | 2287664 | 2022-03-08 | Summit | Utah | 49043 | 13370 | 22 |
2284412 | 2284412 | 2022-03-07 | Summit | Utah | 49043 | 13365 | 22 |
2281160 | 2281160 | 2022-03-06 | Summit | Utah | 49043 | 13357 | 22 |
2277907 | 2277907 | 2022-03-05 | Summit | Utah | 49043 | 13357 | 22 |
2274654 | 2274654 | 2022-03-04 | Summit | Utah | 49043 | 13357 | 22 |
2271401 | 2271401 | 2022-03-03 | Summit | Utah | 49043 | 13352 | 22 |
2268149 | 2268149 | 2022-03-02 | Summit | Utah | 49043 | 13350 | 22 |
2264886 | 2264886 | 2022-03-01 | Juab | Utah | 49023 | 2875 | 22 |
2264896 | 2264896 | 2022-03-01 | Summit | Utah | 49043 | 13345 | 22 |
2261636 | 2261636 | 2022-02-28 | Juab | Utah | 49023 | 2873 | 22 |
2261646 | 2261646 | 2022-02-28 | Summit | Utah | 49043 | 13341 | 22 |
2258385 | 2258385 | 2022-02-27 | Juab | Utah | 49023 | 2872 | 22 |
2258395 | 2258395 | 2022-02-27 | Summit | Utah | 49043 | 13336 | 22 |
2255134 | 2255134 | 2022-02-26 | Juab | Utah | 49023 | 2872 | 22 |
2255144 | 2255144 | 2022-02-26 | Summit | Utah | 49043 | 13336 | 22 |
2251883 | 2251883 | 2022-02-25 | Juab | Utah | 49023 | 2872 | 22 |
2251893 | 2251893 | 2022-02-25 | Summit | Utah | 49043 | 13336 | 22 |
2248632 | 2248632 | 2022-02-24 | Juab | Utah | 49023 | 2871 | 22 |
2248642 | 2248642 | 2022-02-24 | Summit | Utah | 49043 | 13332 | 22 |
2245381 | 2245381 | 2022-02-23 | Juab | Utah | 49023 | 2869 | 22 |
2245391 | 2245391 | 2022-02-23 | Summit | Utah | 49043 | 13322 | 22 |
2242130 | 2242130 | 2022-02-22 | Juab | Utah | 49023 | 2868 | 22 |
2242140 | 2242140 | 2022-02-22 | Summit | Utah | 49043 | 13317 | 22 |
2238879 | 2238879 | 2022-02-21 | Juab | Utah | 49023 | 2865 | 22 |
2238889 | 2238889 | 2022-02-21 | Summit | Utah | 49043 | 13291 | 22 |
2235628 | 2235628 | 2022-02-20 | Juab | Utah | 49023 | 2865 | 22 |
2235638 | 2235638 | 2022-02-20 | Summit | Utah | 49043 | 13291 | 22 |
2232377 | 2232377 | 2022-02-19 | Juab | Utah | 49023 | 2865 | 22 |
2232387 | 2232387 | 2022-02-19 | Summit | Utah | 49043 | 13291 | 22 |
2229126 | 2229126 | 2022-02-18 | Juab | Utah | 49023 | 2865 | 22 |
2229136 | 2229136 | 2022-02-18 | Summit | Utah | 49043 | 13291 | 22 |
2225875 | 2225875 | 2022-02-17 | Juab | Utah | 49023 | 2864 | 22 |
2225885 | 2225885 | 2022-02-17 | Summit | Utah | 49043 | 13273 | 22 |
2222624 | 2222624 | 2022-02-16 | Juab | Utah | 49023 | 2860 | 22 |
2222634 | 2222634 | 2022-02-16 | Summit | Utah | 49043 | 13261 | 22 |
2219373 | 2219373 | 2022-02-15 | Juab | Utah | 49023 | 2858 | 22 |
2219383 | 2219383 | 2022-02-15 | Summit | Utah | 49043 | 13245 | 22 |
2216122 | 2216122 | 2022-02-14 | Juab | Utah | 49023 | 2857 | 22 |
2216132 | 2216132 | 2022-02-14 | Summit | Utah | 49043 | 13230 | 22 |
2212871 | 2212871 | 2022-02-13 | Juab | Utah | 49023 | 2850 | 22 |
2212881 | 2212881 | 2022-02-13 | Summit | Utah | 49043 | 13189 | 22 |
2209618 | 2209618 | 2022-02-12 | Juab | Utah | 49023 | 2850 | 22 |
2209628 | 2209628 | 2022-02-12 | Summit | Utah | 49043 | 13189 | 22 |
2206365 | 2206365 | 2022-02-11 | Juab | Utah | 49023 | 2850 | 22 |
2206375 | 2206375 | 2022-02-11 | Summit | Utah | 49043 | 13189 | 22 |
2203112 | 2203112 | 2022-02-10 | Juab | Utah | 49023 | 2838 | 22 |
2203122 | 2203122 | 2022-02-10 | Summit | Utah | 49043 | 13161 | 22 |
2199858 | 2199858 | 2022-02-09 | Juab | Utah | 49023 | 2834 | 22 |
2199868 | 2199868 | 2022-02-09 | Summit | Utah | 49043 | 13146 | 22 |
2196599 | 2196599 | 2022-02-08 | Duchesne | Utah | 49013 | 4197 | 22 |
2196604 | 2196604 | 2022-02-08 | Juab | Utah | 49023 | 2831 | 22 |
2196614 | 2196614 | 2022-02-08 | Summit | Utah | 49043 | 13126 | 22 |
2193350 | 2193350 | 2022-02-07 | Juab | Utah | 49023 | 2827 | 22 |
2190097 | 2190097 | 2022-02-06 | Juab | Utah | 49023 | 2810 | 22 |
2186844 | 2186844 | 2022-02-05 | Juab | Utah | 49023 | 2810 | 22 |
2183591 | 2183591 | 2022-02-04 | Juab | Utah | 49023 | 2810 | 22 |
2167338 | 2167338 | 2022-01-30 | Sevier | Utah | 49041 | 5098 | 22 |
2164083 | 2164083 | 2022-01-29 | Sevier | Utah | 49041 | 5098 | 22 |
2160828 | 2160828 | 2022-01-28 | Sevier | Utah | 49041 | 5098 | 22 |
2157572 | 2157572 | 2022-01-27 | Sevier | Utah | 49041 | 5064 | 22 |
2154319 | 2154319 | 2022-01-26 | Sevier | Utah | 49041 | 5027 | 22 |
2151067 | 2151067 | 2022-01-25 | Sevier | Utah | 49041 | 4960 | 22 |
1900733 | 1900733 | 2021-11-09 | Emery | Utah | 49015 | 1643 | 22 |
1897483 | 1897483 | 2021-11-08 | Emery | Utah | 49015 | 1628 | 22 |
1894233 | 1894233 | 2021-11-07 | Emery | Utah | 49015 | 1628 | 22 |
1890983 | 1890983 | 2021-11-06 | Emery | Utah | 49015 | 1628 | 22 |
1767519 | 1767519 | 2021-09-29 | Millard | Utah | 49027 | 1983 | 22 |
1764270 | 1764270 | 2021-09-28 | Millard | Utah | 49027 | 1971 | 22 |
1761011 | 1761011 | 2021-09-27 | Carbon | Utah | 49007 | 2438 | 22 |
1757763 | 1757763 | 2021-09-26 | Carbon | Utah | 49007 | 2430 | 22 |
1754515 | 1754515 | 2021-09-25 | Carbon | Utah | 49007 | 2413 | 22 |
1751267 | 1751267 | 2021-09-24 | Carbon | Utah | 49007 | 2411 | 22 |
1634337 | 1634337 | 2021-08-19 | Wasatch | Utah | 49051 | 5126 | 22 |
1631090 | 1631090 | 2021-08-18 | Wasatch | Utah | 49051 | 5107 | 22 |
1627843 | 1627843 | 2021-08-17 | Wasatch | Utah | 49051 | 5096 | 22 |
1624596 | 1624596 | 2021-08-16 | Wasatch | Utah | 49051 | 5087 | 22 |
1621349 | 1621349 | 2021-08-15 | Wasatch | Utah | 49051 | 5054 | 22 |
1618101 | 1618101 | 2021-08-14 | Wasatch | Utah | 49051 | 5054 | 22 |
1614853 | 1614853 | 2021-08-13 | Wasatch | Utah | 49051 | 5054 | 22 |
1611604 | 1611604 | 2021-08-12 | Wasatch | Utah | 49051 | 5048 | 22 |
1608356 | 1608356 | 2021-08-11 | Wasatch | Utah | 49051 | 5040 | 22 |
1605107 | 1605107 | 2021-08-10 | Wasatch | Utah | 49051 | 5026 | 22 |
1601858 | 1601858 | 2021-08-09 | Wasatch | Utah | 49051 | 5018 | 22 |
1598610 | 1598610 | 2021-08-08 | Wasatch | Utah | 49051 | 4990 | 22 |
1595361 | 1595361 | 2021-08-07 | Wasatch | Utah | 49051 | 4990 | 22 |
1592112 | 1592112 | 2021-08-06 | Wasatch | Utah | 49051 | 4990 | 22 |
1588863 | 1588863 | 2021-08-05 | Wasatch | Utah | 49051 | 4986 | 22 |
1585613 | 1585613 | 2021-08-04 | Wasatch | Utah | 49051 | 4969 | 22 |
1582363 | 1582363 | 2021-08-03 | Wasatch | Utah | 49051 | 4957 | 22 |
1579114 | 1579114 | 2021-08-02 | Wasatch | Utah | 49051 | 4950 | 22 |
1575866 | 1575866 | 2021-08-01 | Wasatch | Utah | 49051 | 4913 | 22 |
1572618 | 1572618 | 2021-07-31 | Wasatch | Utah | 49051 | 4913 | 22 |
1569370 | 1569370 | 2021-07-30 | Wasatch | Utah | 49051 | 4913 | 22 |
1566122 | 1566122 | 2021-07-29 | Wasatch | Utah | 49051 | 4894 | 22 |
1562874 | 1562874 | 2021-07-28 | Wasatch | Utah | 49051 | 4883 | 22 |
1559626 | 1559626 | 2021-07-27 | Wasatch | Utah | 49051 | 4875 | 22 |
1556379 | 1556379 | 2021-07-26 | Wasatch | Utah | 49051 | 4856 | 22 |
1553132 | 1553132 | 2021-07-25 | Wasatch | Utah | 49051 | 4825 | 22 |
1549885 | 1549885 | 2021-07-24 | Wasatch | Utah | 49051 | 4825 | 22 |
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);