ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 49003 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177078 | 2177078 | 2022-02-02 | Box Elder | Utah | 49003 | 13521 | 103 |
2173825 | 2173825 | 2022-02-01 | Box Elder | Utah | 49003 | 13465 | 103 |
2170573 | 2170573 | 2022-01-31 | Box Elder | Utah | 49003 | 13432 | 103 |
2167319 | 2167319 | 2022-01-30 | Box Elder | Utah | 49003 | 13255 | 103 |
2164064 | 2164064 | 2022-01-29 | Box Elder | Utah | 49003 | 13255 | 103 |
2160809 | 2160809 | 2022-01-28 | Box Elder | Utah | 49003 | 13255 | 103 |
2157553 | 2157553 | 2022-01-27 | Box Elder | Utah | 49003 | 13182 | 103 |
2154300 | 2154300 | 2022-01-26 | Box Elder | Utah | 49003 | 13050 | 103 |
2151048 | 2151048 | 2022-01-25 | Box Elder | Utah | 49003 | 12902 | 102 |
2147796 | 2147796 | 2022-01-24 | Box Elder | Utah | 49003 | 12432 | 102 |
2144542 | 2144542 | 2022-01-23 | Box Elder | Utah | 49003 | 12432 | 102 |
2141287 | 2141287 | 2022-01-22 | Box Elder | Utah | 49003 | 12432 | 102 |
2138031 | 2138031 | 2022-01-21 | Box Elder | Utah | 49003 | 12432 | 102 |
2134777 | 2134777 | 2022-01-20 | Box Elder | Utah | 49003 | 12281 | 102 |
2131525 | 2131525 | 2022-01-19 | Box Elder | Utah | 49003 | 12050 | 101 |
2128271 | 2128271 | 2022-01-18 | Box Elder | Utah | 49003 | 11338 | 101 |
2125019 | 2125019 | 2022-01-17 | Box Elder | Utah | 49003 | 11338 | 101 |
2121767 | 2121767 | 2022-01-16 | Box Elder | Utah | 49003 | 11338 | 101 |
2118515 | 2118515 | 2022-01-15 | Box Elder | Utah | 49003 | 11338 | 101 |
2115263 | 2115263 | 2022-01-14 | Box Elder | Utah | 49003 | 11338 | 101 |
2112011 | 2112011 | 2022-01-13 | Box Elder | Utah | 49003 | 11230 | 101 |
2108759 | 2108759 | 2022-01-12 | Box Elder | Utah | 49003 | 10953 | 101 |
2105508 | 2105508 | 2022-01-11 | Box Elder | Utah | 49003 | 10953 | 101 |
2102257 | 2102257 | 2022-01-10 | Box Elder | Utah | 49003 | 10732 | 101 |
2099006 | 2099006 | 2022-01-09 | Box Elder | Utah | 49003 | 10732 | 101 |
2095754 | 2095754 | 2022-01-08 | Box Elder | Utah | 49003 | 10732 | 101 |
2092502 | 2092502 | 2022-01-07 | Box Elder | Utah | 49003 | 10732 | 101 |
2089250 | 2089250 | 2022-01-06 | Box Elder | Utah | 49003 | 10669 | 101 |
2085999 | 2085999 | 2022-01-05 | Box Elder | Utah | 49003 | 10453 | 101 |
2082747 | 2082747 | 2022-01-04 | Box Elder | Utah | 49003 | 10454 | 101 |
2079495 | 2079495 | 2022-01-03 | Box Elder | Utah | 49003 | 10453 | 100 |
2076244 | 2076244 | 2022-01-02 | Box Elder | Utah | 49003 | 10393 | 99 |
2072993 | 2072993 | 2022-01-01 | Box Elder | Utah | 49003 | 10393 | 99 |
2069742 | 2069742 | 2021-12-31 | Box Elder | Utah | 49003 | 10393 | 99 |
2066491 | 2066491 | 2021-12-30 | Box Elder | Utah | 49003 | 10364 | 99 |
2063241 | 2063241 | 2021-12-29 | Box Elder | Utah | 49003 | 10364 | 99 |
2059991 | 2059991 | 2021-12-28 | Box Elder | Utah | 49003 | 10339 | 99 |
2056742 | 2056742 | 2021-12-27 | Box Elder | Utah | 49003 | 10329 | 99 |
2053493 | 2053493 | 2021-12-26 | Box Elder | Utah | 49003 | 10283 | 99 |
2050243 | 2050243 | 2021-12-25 | Box Elder | Utah | 49003 | 10283 | 99 |
2046993 | 2046993 | 2021-12-24 | Box Elder | Utah | 49003 | 10283 | 99 |
2043743 | 2043743 | 2021-12-23 | Box Elder | Utah | 49003 | 10283 | 99 |
2040494 | 2040494 | 2021-12-22 | Box Elder | Utah | 49003 | 10271 | 99 |
2037244 | 2037244 | 2021-12-21 | Box Elder | Utah | 49003 | 10252 | 99 |
2033994 | 2033994 | 2021-12-20 | Box Elder | Utah | 49003 | 10236 | 98 |
2030744 | 2030744 | 2021-12-19 | Box Elder | Utah | 49003 | 10207 | 98 |
2027493 | 2027493 | 2021-12-18 | Box Elder | Utah | 49003 | 10207 | 98 |
2024242 | 2024242 | 2021-12-17 | Box Elder | Utah | 49003 | 10207 | 98 |
2020991 | 2020991 | 2021-12-16 | Box Elder | Utah | 49003 | 10197 | 98 |
2017740 | 2017740 | 2021-12-15 | Box Elder | Utah | 49003 | 10180 | 98 |
2014490 | 2014490 | 2021-12-14 | Box Elder | Utah | 49003 | 10155 | 97 |
2011239 | 2011239 | 2021-12-13 | Box Elder | Utah | 49003 | 10140 | 97 |
2007988 | 2007988 | 2021-12-12 | Box Elder | Utah | 49003 | 10094 | 97 |
2004737 | 2004737 | 2021-12-11 | Box Elder | Utah | 49003 | 10094 | 97 |
2001486 | 2001486 | 2021-12-10 | Box Elder | Utah | 49003 | 10094 | 97 |
1998236 | 1998236 | 2021-12-09 | Box Elder | Utah | 49003 | 10076 | 97 |
1994985 | 1994985 | 2021-12-08 | Box Elder | Utah | 49003 | 10057 | 97 |
1991734 | 1991734 | 2021-12-07 | Box Elder | Utah | 49003 | 10030 | 96 |
1988483 | 1988483 | 2021-12-06 | Box Elder | Utah | 49003 | 9919 | 95 |
1985233 | 1985233 | 2021-12-05 | Box Elder | Utah | 49003 | 9919 | 95 |
1981983 | 1981983 | 2021-12-04 | Box Elder | Utah | 49003 | 9919 | 95 |
1978733 | 1978733 | 2021-12-03 | Box Elder | Utah | 49003 | 9919 | 95 |
1975483 | 1975483 | 2021-12-02 | Box Elder | Utah | 49003 | 9899 | 95 |
1972234 | 1972234 | 2021-12-01 | Box Elder | Utah | 49003 | 9809 | 95 |
1968984 | 1968984 | 2021-11-30 | Box Elder | Utah | 49003 | 9809 | 95 |
1965733 | 1965733 | 2021-11-29 | Box Elder | Utah | 49003 | 9792 | 95 |
1962481 | 1962481 | 2021-11-28 | Box Elder | Utah | 49003 | 9744 | 95 |
1959230 | 1959230 | 2021-11-27 | Box Elder | Utah | 49003 | 9744 | 95 |
1955979 | 1955979 | 2021-11-26 | Box Elder | Utah | 49003 | 9744 | 95 |
1952728 | 1952728 | 2021-11-25 | Box Elder | Utah | 49003 | 9690 | 95 |
1949477 | 1949477 | 2021-11-24 | Box Elder | Utah | 49003 | 9690 | 95 |
1946226 | 1946226 | 2021-11-23 | Box Elder | Utah | 49003 | 9647 | 95 |
1942975 | 1942975 | 2021-11-22 | Box Elder | Utah | 49003 | 9634 | 95 |
1939725 | 1939725 | 2021-11-21 | Box Elder | Utah | 49003 | 9536 | 94 |
1936475 | 1936475 | 2021-11-20 | Box Elder | Utah | 49003 | 9536 | 94 |
1933225 | 1933225 | 2021-11-19 | Box Elder | Utah | 49003 | 9536 | 94 |
1929974 | 1929974 | 2021-11-18 | Box Elder | Utah | 49003 | 9500 | 94 |
1926724 | 1926724 | 2021-11-17 | Box Elder | Utah | 49003 | 9406 | 93 |
1923474 | 1923474 | 2021-11-16 | Box Elder | Utah | 49003 | 9406 | 93 |
1920225 | 1920225 | 2021-11-15 | Box Elder | Utah | 49003 | 9282 | 92 |
1916975 | 1916975 | 2021-11-14 | Box Elder | Utah | 49003 | 9282 | 92 |
1913725 | 1913725 | 2021-11-13 | Box Elder | Utah | 49003 | 9282 | 92 |
1910475 | 1910475 | 2021-11-12 | Box Elder | Utah | 49003 | 9282 | 92 |
1907226 | 1907226 | 2021-11-11 | Box Elder | Utah | 49003 | 9184 | 90 |
1903977 | 1903977 | 2021-11-10 | Box Elder | Utah | 49003 | 9136 | 90 |
1900727 | 1900727 | 2021-11-09 | Box Elder | Utah | 49003 | 9136 | 90 |
1897477 | 1897477 | 2021-11-08 | Box Elder | Utah | 49003 | 9047 | 90 |
1894227 | 1894227 | 2021-11-07 | Box Elder | Utah | 49003 | 9047 | 90 |
1890977 | 1890977 | 2021-11-06 | Box Elder | Utah | 49003 | 9047 | 90 |
1887727 | 1887727 | 2021-11-05 | Box Elder | Utah | 49003 | 9047 | 90 |
1884477 | 1884477 | 2021-11-04 | Box Elder | Utah | 49003 | 8995 | 88 |
1881228 | 1881228 | 2021-11-03 | Box Elder | Utah | 49003 | 8918 | 88 |
1877979 | 1877979 | 2021-11-02 | Box Elder | Utah | 49003 | 8866 | 87 |
1874730 | 1874730 | 2021-11-01 | Box Elder | Utah | 49003 | 8773 | 85 |
1871481 | 1871481 | 2021-10-31 | Box Elder | Utah | 49003 | 8773 | 85 |
1868232 | 1868232 | 2021-10-30 | Box Elder | Utah | 49003 | 8773 | 85 |
1864983 | 1864983 | 2021-10-29 | Box Elder | Utah | 49003 | 8773 | 85 |
1861734 | 1861734 | 2021-10-28 | Box Elder | Utah | 49003 | 8676 | 84 |
1858485 | 1858485 | 2021-10-27 | Box Elder | Utah | 49003 | 8676 | 84 |
1855236 | 1855236 | 2021-10-26 | Box Elder | Utah | 49003 | 8620 | 82 |
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);