ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 49005 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
cases 547 ✖
- 43 7
- 40 6
- 2 5
- 28678 5
- 36 4
- 16608 4
- 16712 4
- 16888 4
- 17492 4
- 18356 4
- 19289 4
- 19815 4
- 20690 4
- 21061 4
- 21944 4
- 22330 4
- 22715 4
- 23940 4
- 24702 4
- 26686 4
- 32233 4
- 5 3
- 44 3
- 16025 3
- 16667 3
- 17111 3
- 17325 3
- 17728 3
- 18001 3
- 18803 3
- 20220 3
- 21530 3
- 23218 3
- 23592 3
- 24236 3
- 24492 3
- 25185 3
- 34747 3
- 3 2
- 4 2
- 7 2
- 15 2
- 30 2
- 41 2
- 45 2
- 51 2
- 59 2
- 60 2
- 63 2
- 64 2
- 72 2
- 77 2
- 1620 2
- 2044 2
- 6062 2
- 10539 2
- 11167 2
- 15813 2
- 15883 2
- 16205 2
- 16251 2
- 16328 2
- 16496 2
- 16753 2
- 19118 2
- 21330 2
- 21815 2
- 22517 2
- 22969 2
- 23483 2
- 23724 2
- 25077 2
- 25533 2
- 27490 2
- 6 1
- 10 1
- 19 1
- 20 1
- 23 1
- 28 1
- 29 1
- 33 1
- 38 1
- 58 1
- 61 1
- 74 1
- 78 1
- 79 1
- 89 1
- 111 1
- 142 1
- 179 1
- 219 1
- 238 1
- 268 1
- 310 1
- 329 1
- 514 1
- 709 1
- 731 1
- 773 1
- 805 1
- 861 1
- 913 1
- 939 1
- 966 1
- 982 1
- 1020 1
- 1060 1
- 1087 1
- 1136 1
- 1205 1
- 1245 1
- 1283 1
- 1301 1
- 1317 1
- 1328 1
- 1357 1
- 1389 1
- 1400 1
- 1426 1
- 1445 1
- 1453 1
- 1470 1
- 1477 1
- 1499 1
- 1521 1
- 1532 1
- 1540 1
- 1557 1
- 1571 1
- 1582 1
- 1605 1
- 1632 1
- 1640 1
- 1650 1
- 1654 1
- 1656 1
- 1657 1
- 1658 1
- 1663 1
- 1681 1
- 1685 1
- 1706 1
- 1736 1
- 1751 1
- 1758 1
- 1764 1
- 1770 1
- 1790 1
- 1798 1
- 1805 1
- 1809 1
- 1828 1
- 1833 1
- 1857 1
- 1872 1
- 1886 1
- 1908 1
- 1911 1
- 1926 1
- 1937 1
- 1943 1
- 1950 1
- 1960 1
- 1965 1
- 1971 1
- 1973 1
- 1974 1
- 1982 1
- 1993 1
- 2005 1
- 2017 1
- 2046 1
- 2054 1
- 2068 1
- 2078 1
- 2088 1
- 2097 1
- 2109 1
- 2114 1
- 2119 1
- 2143 1
- 2182 1
- 2184 1
- 2194 1
- 2202 1
- 2217 1
- 2225 1
- 2232 1
- 2260 1
- 2301 1
- 2321 1
- 2346 1
- 2365 1
- 2389 1
- 2422 1
- 2442 1
- 2501 1
- 2536 1
- 2557 1
- 2573 1
- 2598 1
- 2635 1
- 2659 1
- 2695 1
- 2728 1
- 2736 1
- 2762 1
- 2785 1
- 2803 1
- 2854 1
- 2895 1
- 2929 1
- 2992 1
- 3025 1
- 3053 1
- 3122 1
- 3170 1
- 3202 1
- 3255 1
- 3288 1
- 3343 1
- 3376 1
- 3459 1
- 3509 1
- 3560 1
- 3609 1
- 3677 1
- 3703 1
- 3738 1
- 3790 1
- 3851 1
- 3940 1
- 3998 1
- 4044 1
- 4077 1
- 4125 1
- 4209 1
- 4277 1
- 4343 1
- 4422 1
- 4458 1
- 4479 1
- 4498 1
- 4615 1
- 4682 1
- 4772 1
- 4874 1
- 4975 1
- 5041 1
- 5078 1
- 5231 1
- 5380 1
- 5560 1
- 5811 1
- 5909 1
- 6235 1
- 6456 1
- 6637 1
- 6886 1
- 6990 1
- 7095 1
- 7165 1
- 7262 1
- 7444 1
- 7550 1
- 7655 1
- 7698 1
- 7808 1
- 7920 1
- 8091 1
- 8247 1
- 8416 1
- 8567 1
- 8682 1
- 8760 1
- 8829 1
- 8913 1
- 9067 1
- 9136 1
- 9325 1
- 9396 1
- 9491 1
- 9565 1
- 9720 1
- 9908 1
- 10026 1
- 10150 1
- 10201 1
- 10279 1
- 10355 1
- 10454 1
- 10700 1
- 10723 1
- 10790 1
- 10887 1
- 10967 1
- 11351 1
- 11417 1
- 11500 1
- 11620 1
- 11807 1
- 11941 1
- 12065 1
- 12144 1
- 12211 1
- 12239 1
- 12289 1
- 12471 1
- 12578 1
- 12727 1
- 12815 1
- 12867 1
- 12898 1
- 12925 1
- 13025 1
- 13128 1
- 13247 1
- 13314 1
- 13382 1
- 13408 1
- 13476 1
- 13581 1
- 13642 1
- 13704 1
- 13765 1
- 13804 1
- 13824 1
- 13879 1
- 13980 1
- 14024 1
- 14072 1
- 14144 1
- 14163 1
- 14174 1
- 14234 1
- 14276 1
- 14324 1
- 14378 1
- 14419 1
- 14455 1
- 14465 1
- 14485 1
- 14521 1
- 14560 1
- 14614 1
- 14648 1
- 14686 1
- 14700 1
- 14723 1
- 14760 1
- 14808 1
- 14818 1
- 14836 1
- 14853 1
- 14865 1
- 14880 1
- 14901 1
- 14926 1
- 14951 1
- 14971 1
- 14991 1
- 15004 1
- 15038 1
- 15063 1
- 15098 1
- 15137 1
- 15166 1
- 15194 1
- 15208 1
- 15222 1
- 15263 1
- 15284 1
- 15298 1
- 15322 1
- 15342 1
- 15351 1
- 15367 1
- 15400 1
- 15426 1
- 15441 1
- 15458 1
- 15470 1
- 15480 1
- 15497 1
- 15524 1
- 15553 1
- 15563 1
- 15571 1
- 15599 1
- 15601 1
- 15608 1
- 15621 1
- 15645 1
- 15665 1
- 15680 1
- 15693 1
- 15696 1
- 15718 1
- 15766 1
- 15786 1
- 15803 1
- 15831 1
- 15837 1
- 15928 1
- 15938 1
- 15939 1
- 15946 1
- 15953 1
- 15961 1
- 15973 1
- 15986 1
- 16007 1
- 16021 1
- 16049 1
- 16071 1
- 16083 1
- 16091 1
- 16102 1
- 16108 1
- 16128 1
- 16142 1
- 16156 1
- 16164 1
- 16174 1
- 16181 1
- 16188 1
- 16219 1
- 16227 1
- 16231 1
- 16237 1
- 16242 1
- 16269 1
- 16278 1
- 16285 1
- 16290 1
- 16296 1
- 16302 1
- 16318 1
- 16354 1
- 16362 1
- 16368 1
- 16379 1
- 16388 1
- 16398 1
- 16422 1
- 16430 1
- 16436 1
- 16440 1
- 16451 1
- 16460 1
- 16465 1
- 16472 1
- 16480 1
- 16483 1
- 16485 1
- 16514 1
- 16529 1
- 16545 1
- 16557 1
- 16567 1
- 16583 1
- 16595 1
- 16641 1
- 16648 1
- 16657 1
- 16695 1
- 16806 1
- 16822 1
- 16854 1
- 16962 1
- 16969 1
- 16989 1
- 17066 1
- 17186 1
- 17209 1
- 17237 1
- 17299 1
- 17408 1
- 17428 1
- 17453 1
- 17478 1
- 17595 1
- 17650 1
- 17688 1
- 17834 1
- 17855 1
- 17898 1
- 17958 1
- 18118 1
- 18160 1
- 18237 1
- 18283 1
- 18565 1
- 18614 1
- 18710 1
- 18999 1
- 19040 1
- 19592 1
- 19658 1
- 19740 1
- 19996 1
- 20067 1
- 20138 1
- 20378 1
- 20432 1
- 20551 1
- 20615 1
- 20883 1
- 20960 1
- 20998 1
- 21278 1
- 21680 1
- 21731 1
- 22082 1
- 22156 1
- 22266 1
- 22570 1
- 23146 1
- 23371 1
- 23390 1
- 23695 1
- 23879 1
- 24064 1
- 24105 1
- 24161 1
- 24343 1
- 24367 1
- 24418 1
- 24459 1
- 24570 1
- 24596 1
- 24658 1
- 24896 1
- 24943 1
- 25534 1
- 26464 1
- 28408 1
- 30947 1
- 31483 1
- 33712 1
- 34036 1
- 34388 1
- 35293 1
- 35346 1
- 35553 1
state 1
- Utah 687
fips 1
- 49005 · 687 ✖
county 1
- Cache 687
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177079 | 2177079 | 2022-02-02 | Cache | Utah | 49005 | 35553 | 89 |
2173826 | 2173826 | 2022-02-01 | Cache | Utah | 49005 | 35346 | 89 |
2170574 | 2170574 | 2022-01-31 | Cache | Utah | 49005 | 35293 | 89 |
2167320 | 2167320 | 2022-01-30 | Cache | Utah | 49005 | 34747 | 89 |
2164065 | 2164065 | 2022-01-29 | Cache | Utah | 49005 | 34747 | 89 |
2160810 | 2160810 | 2022-01-28 | Cache | Utah | 49005 | 34747 | 89 |
2157554 | 2157554 | 2022-01-27 | Cache | Utah | 49005 | 34388 | 89 |
2154301 | 2154301 | 2022-01-26 | Cache | Utah | 49005 | 34036 | 89 |
2151049 | 2151049 | 2022-01-25 | Cache | Utah | 49005 | 33712 | 88 |
2147797 | 2147797 | 2022-01-24 | Cache | Utah | 49005 | 32233 | 87 |
2144543 | 2144543 | 2022-01-23 | Cache | Utah | 49005 | 32233 | 87 |
2141288 | 2141288 | 2022-01-22 | Cache | Utah | 49005 | 32233 | 87 |
2138032 | 2138032 | 2022-01-21 | Cache | Utah | 49005 | 32233 | 87 |
2134778 | 2134778 | 2022-01-20 | Cache | Utah | 49005 | 31483 | 87 |
2131526 | 2131526 | 2022-01-19 | Cache | Utah | 49005 | 30947 | 86 |
2128272 | 2128272 | 2022-01-18 | Cache | Utah | 49005 | 28678 | 84 |
2125020 | 2125020 | 2022-01-17 | Cache | Utah | 49005 | 28678 | 84 |
2121768 | 2121768 | 2022-01-16 | Cache | Utah | 49005 | 28678 | 84 |
2118516 | 2118516 | 2022-01-15 | Cache | Utah | 49005 | 28678 | 84 |
2115264 | 2115264 | 2022-01-14 | Cache | Utah | 49005 | 28678 | 84 |
2112012 | 2112012 | 2022-01-13 | Cache | Utah | 49005 | 28408 | 84 |
2108760 | 2108760 | 2022-01-12 | Cache | Utah | 49005 | 27490 | 84 |
2105509 | 2105509 | 2022-01-11 | Cache | Utah | 49005 | 27490 | 84 |
2102258 | 2102258 | 2022-01-10 | Cache | Utah | 49005 | 26686 | 84 |
2099007 | 2099007 | 2022-01-09 | Cache | Utah | 49005 | 26686 | 84 |
2095755 | 2095755 | 2022-01-08 | Cache | Utah | 49005 | 26686 | 84 |
2092503 | 2092503 | 2022-01-07 | Cache | Utah | 49005 | 26686 | 84 |
2089251 | 2089251 | 2022-01-06 | Cache | Utah | 49005 | 26464 | 84 |
2086000 | 2086000 | 2022-01-05 | Cache | Utah | 49005 | 25534 | 84 |
2082748 | 2082748 | 2022-01-04 | Cache | Utah | 49005 | 25533 | 84 |
2079496 | 2079496 | 2022-01-03 | Cache | Utah | 49005 | 25533 | 84 |
2076245 | 2076245 | 2022-01-02 | Cache | Utah | 49005 | 25185 | 84 |
2072994 | 2072994 | 2022-01-01 | Cache | Utah | 49005 | 25185 | 84 |
2069743 | 2069743 | 2021-12-31 | Cache | Utah | 49005 | 25185 | 84 |
2066492 | 2066492 | 2021-12-30 | Cache | Utah | 49005 | 25077 | 84 |
2063242 | 2063242 | 2021-12-29 | Cache | Utah | 49005 | 25077 | 84 |
2059992 | 2059992 | 2021-12-28 | Cache | Utah | 49005 | 24943 | 85 |
2056743 | 2056743 | 2021-12-27 | Cache | Utah | 49005 | 24896 | 85 |
2053494 | 2053494 | 2021-12-26 | Cache | Utah | 49005 | 24702 | 85 |
2050244 | 2050244 | 2021-12-25 | Cache | Utah | 49005 | 24702 | 85 |
2046994 | 2046994 | 2021-12-24 | Cache | Utah | 49005 | 24702 | 85 |
2043744 | 2043744 | 2021-12-23 | Cache | Utah | 49005 | 24702 | 85 |
2040495 | 2040495 | 2021-12-22 | Cache | Utah | 49005 | 24658 | 85 |
2037245 | 2037245 | 2021-12-21 | Cache | Utah | 49005 | 24596 | 85 |
2033995 | 2033995 | 2021-12-20 | Cache | Utah | 49005 | 24570 | 84 |
2030745 | 2030745 | 2021-12-19 | Cache | Utah | 49005 | 24492 | 83 |
2027494 | 2027494 | 2021-12-18 | Cache | Utah | 49005 | 24492 | 83 |
2024243 | 2024243 | 2021-12-17 | Cache | Utah | 49005 | 24492 | 83 |
2020992 | 2020992 | 2021-12-16 | Cache | Utah | 49005 | 24459 | 83 |
2017741 | 2017741 | 2021-12-15 | Cache | Utah | 49005 | 24418 | 83 |
2014491 | 2014491 | 2021-12-14 | Cache | Utah | 49005 | 24367 | 83 |
2011240 | 2011240 | 2021-12-13 | Cache | Utah | 49005 | 24343 | 83 |
2007989 | 2007989 | 2021-12-12 | Cache | Utah | 49005 | 24236 | 82 |
2004738 | 2004738 | 2021-12-11 | Cache | Utah | 49005 | 24236 | 82 |
2001487 | 2001487 | 2021-12-10 | Cache | Utah | 49005 | 24236 | 82 |
1998237 | 1998237 | 2021-12-09 | Cache | Utah | 49005 | 24161 | 82 |
1994986 | 1994986 | 2021-12-08 | Cache | Utah | 49005 | 24105 | 82 |
1991735 | 1991735 | 2021-12-07 | Cache | Utah | 49005 | 24064 | 81 |
1988484 | 1988484 | 2021-12-06 | Cache | Utah | 49005 | 23940 | 79 |
1985234 | 1985234 | 2021-12-05 | Cache | Utah | 49005 | 23940 | 79 |
1981984 | 1981984 | 2021-12-04 | Cache | Utah | 49005 | 23940 | 79 |
1978734 | 1978734 | 2021-12-03 | Cache | Utah | 49005 | 23940 | 79 |
1975484 | 1975484 | 2021-12-02 | Cache | Utah | 49005 | 23879 | 78 |
1972235 | 1972235 | 2021-12-01 | Cache | Utah | 49005 | 23724 | 78 |
1968985 | 1968985 | 2021-11-30 | Cache | Utah | 49005 | 23724 | 78 |
1965734 | 1965734 | 2021-11-29 | Cache | Utah | 49005 | 23695 | 78 |
1962482 | 1962482 | 2021-11-28 | Cache | Utah | 49005 | 23592 | 77 |
1959231 | 1959231 | 2021-11-27 | Cache | Utah | 49005 | 23592 | 77 |
1955980 | 1955980 | 2021-11-26 | Cache | Utah | 49005 | 23592 | 77 |
1952729 | 1952729 | 2021-11-25 | Cache | Utah | 49005 | 23483 | 77 |
1949478 | 1949478 | 2021-11-24 | Cache | Utah | 49005 | 23483 | 77 |
1946227 | 1946227 | 2021-11-23 | Cache | Utah | 49005 | 23390 | 76 |
1942976 | 1942976 | 2021-11-22 | Cache | Utah | 49005 | 23371 | 74 |
1939726 | 1939726 | 2021-11-21 | Cache | Utah | 49005 | 23218 | 74 |
1936476 | 1936476 | 2021-11-20 | Cache | Utah | 49005 | 23218 | 74 |
1933226 | 1933226 | 2021-11-19 | Cache | Utah | 49005 | 23218 | 74 |
1929975 | 1929975 | 2021-11-18 | Cache | Utah | 49005 | 23146 | 73 |
1926725 | 1926725 | 2021-11-17 | Cache | Utah | 49005 | 22969 | 72 |
1923475 | 1923475 | 2021-11-16 | Cache | Utah | 49005 | 22969 | 72 |
1920226 | 1920226 | 2021-11-15 | Cache | Utah | 49005 | 22715 | 72 |
1916976 | 1916976 | 2021-11-14 | Cache | Utah | 49005 | 22715 | 72 |
1913726 | 1913726 | 2021-11-13 | Cache | Utah | 49005 | 22715 | 72 |
1910476 | 1910476 | 2021-11-12 | Cache | Utah | 49005 | 22715 | 72 |
1907227 | 1907227 | 2021-11-11 | Cache | Utah | 49005 | 22570 | 72 |
1903978 | 1903978 | 2021-11-10 | Cache | Utah | 49005 | 22517 | 72 |
1900728 | 1900728 | 2021-11-09 | Cache | Utah | 49005 | 22517 | 72 |
1897478 | 1897478 | 2021-11-08 | Cache | Utah | 49005 | 22330 | 70 |
1894228 | 1894228 | 2021-11-07 | Cache | Utah | 49005 | 22330 | 70 |
1890978 | 1890978 | 2021-11-06 | Cache | Utah | 49005 | 22330 | 70 |
1887728 | 1887728 | 2021-11-05 | Cache | Utah | 49005 | 22330 | 70 |
1884478 | 1884478 | 2021-11-04 | Cache | Utah | 49005 | 22266 | 70 |
1881229 | 1881229 | 2021-11-03 | Cache | Utah | 49005 | 22156 | 68 |
1877980 | 1877980 | 2021-11-02 | Cache | Utah | 49005 | 22082 | 68 |
1874731 | 1874731 | 2021-11-01 | Cache | Utah | 49005 | 21944 | 67 |
1871482 | 1871482 | 2021-10-31 | Cache | Utah | 49005 | 21944 | 67 |
1868233 | 1868233 | 2021-10-30 | Cache | Utah | 49005 | 21944 | 67 |
1864984 | 1864984 | 2021-10-29 | Cache | Utah | 49005 | 21944 | 67 |
1861735 | 1861735 | 2021-10-28 | Cache | Utah | 49005 | 21815 | 66 |
1858486 | 1858486 | 2021-10-27 | Cache | Utah | 49005 | 21815 | 66 |
1855237 | 1855237 | 2021-10-26 | Cache | Utah | 49005 | 21731 | 64 |
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);