ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "San Juan" and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177095 | 2177095 | 2022-02-02 | San Juan | Utah | 49037 | 3740 | 47 |
2173842 | 2173842 | 2022-02-01 | San Juan | Utah | 49037 | 3728 | 47 |
2170590 | 2170590 | 2022-01-31 | San Juan | Utah | 49037 | 3718 | 47 |
2167336 | 2167336 | 2022-01-30 | San Juan | Utah | 49037 | 3655 | 47 |
2164081 | 2164081 | 2022-01-29 | San Juan | Utah | 49037 | 3655 | 47 |
2160826 | 2160826 | 2022-01-28 | San Juan | Utah | 49037 | 3655 | 47 |
2157570 | 2157570 | 2022-01-27 | San Juan | Utah | 49037 | 3611 | 47 |
2154317 | 2154317 | 2022-01-26 | San Juan | Utah | 49037 | 3586 | 47 |
2151065 | 2151065 | 2022-01-25 | San Juan | Utah | 49037 | 3558 | 47 |
2147813 | 2147813 | 2022-01-24 | San Juan | Utah | 49037 | 3549 | 47 |
2144559 | 2144559 | 2022-01-23 | San Juan | Utah | 49037 | 3448 | 47 |
2141304 | 2141304 | 2022-01-22 | San Juan | Utah | 49037 | 3448 | 47 |
2138048 | 2138048 | 2022-01-21 | San Juan | Utah | 49037 | 3448 | 47 |
2134794 | 2134794 | 2022-01-20 | San Juan | Utah | 49037 | 3364 | 47 |
2131542 | 2131542 | 2022-01-19 | San Juan | Utah | 49037 | 3316 | 47 |
2128288 | 2128288 | 2022-01-18 | San Juan | Utah | 49037 | 3288 | 47 |
2125036 | 2125036 | 2022-01-17 | San Juan | Utah | 49037 | 3168 | 47 |
2121784 | 2121784 | 2022-01-16 | San Juan | Utah | 49037 | 3168 | 47 |
2118532 | 2118532 | 2022-01-15 | San Juan | Utah | 49037 | 3168 | 47 |
2115280 | 2115280 | 2022-01-14 | San Juan | Utah | 49037 | 3168 | 47 |
2112028 | 2112028 | 2022-01-13 | San Juan | Utah | 49037 | 3129 | 47 |
2108776 | 2108776 | 2022-01-12 | San Juan | Utah | 49037 | 3074 | 47 |
2105525 | 2105525 | 2022-01-11 | San Juan | Utah | 49037 | 3057 | 47 |
2102274 | 2102274 | 2022-01-10 | San Juan | Utah | 49037 | 3037 | 46 |
2099023 | 2099023 | 2022-01-09 | San Juan | Utah | 49037 | 2967 | 46 |
2095771 | 2095771 | 2022-01-08 | San Juan | Utah | 49037 | 2967 | 46 |
2092519 | 2092519 | 2022-01-07 | San Juan | Utah | 49037 | 2967 | 46 |
2089267 | 2089267 | 2022-01-06 | San Juan | Utah | 49037 | 2943 | 46 |
2086016 | 2086016 | 2022-01-05 | San Juan | Utah | 49037 | 2914 | 46 |
2082764 | 2082764 | 2022-01-04 | San Juan | Utah | 49037 | 2890 | 46 |
2079512 | 2079512 | 2022-01-03 | San Juan | Utah | 49037 | 2879 | 46 |
2076261 | 2076261 | 2022-01-02 | San Juan | Utah | 49037 | 2863 | 45 |
2073010 | 2073010 | 2022-01-01 | San Juan | Utah | 49037 | 2863 | 45 |
2069759 | 2069759 | 2021-12-31 | San Juan | Utah | 49037 | 2863 | 45 |
2066508 | 2066508 | 2021-12-30 | San Juan | Utah | 49037 | 2863 | 45 |
2063258 | 2063258 | 2021-12-29 | San Juan | Utah | 49037 | 2857 | 45 |
2060008 | 2060008 | 2021-12-28 | San Juan | Utah | 49037 | 2845 | 45 |
2056759 | 2056759 | 2021-12-27 | San Juan | Utah | 49037 | 2842 | 45 |
2053510 | 2053510 | 2021-12-26 | San Juan | Utah | 49037 | 2831 | 45 |
2050260 | 2050260 | 2021-12-25 | San Juan | Utah | 49037 | 2831 | 45 |
2047010 | 2047010 | 2021-12-24 | San Juan | Utah | 49037 | 2831 | 45 |
2043760 | 2043760 | 2021-12-23 | San Juan | Utah | 49037 | 2831 | 45 |
2040511 | 2040511 | 2021-12-22 | San Juan | Utah | 49037 | 2828 | 45 |
2037261 | 2037261 | 2021-12-21 | San Juan | Utah | 49037 | 2824 | 45 |
2034011 | 2034011 | 2021-12-20 | San Juan | Utah | 49037 | 2826 | 45 |
2030761 | 2030761 | 2021-12-19 | San Juan | Utah | 49037 | 2820 | 45 |
2027510 | 2027510 | 2021-12-18 | San Juan | Utah | 49037 | 2820 | 45 |
2024259 | 2024259 | 2021-12-17 | San Juan | Utah | 49037 | 2820 | 45 |
2021008 | 2021008 | 2021-12-16 | San Juan | Utah | 49037 | 2812 | 45 |
2017757 | 2017757 | 2021-12-15 | San Juan | Utah | 49037 | 2806 | 45 |
2014507 | 2014507 | 2021-12-14 | San Juan | Utah | 49037 | 2794 | 44 |
2011256 | 2011256 | 2021-12-13 | San Juan | Utah | 49037 | 2794 | 44 |
2008005 | 2008005 | 2021-12-12 | San Juan | Utah | 49037 | 2781 | 43 |
2004754 | 2004754 | 2021-12-11 | San Juan | Utah | 49037 | 2781 | 43 |
2001503 | 2001503 | 2021-12-10 | San Juan | Utah | 49037 | 2781 | 43 |
1998253 | 1998253 | 2021-12-09 | San Juan | Utah | 49037 | 2778 | 43 |
1995002 | 1995002 | 2021-12-08 | San Juan | Utah | 49037 | 2775 | 43 |
1991751 | 1991751 | 2021-12-07 | San Juan | Utah | 49037 | 2766 | 43 |
1988500 | 1988500 | 2021-12-06 | San Juan | Utah | 49037 | 2764 | 43 |
1985250 | 1985250 | 2021-12-05 | San Juan | Utah | 49037 | 2740 | 43 |
1982000 | 1982000 | 2021-12-04 | San Juan | Utah | 49037 | 2740 | 43 |
1978750 | 1978750 | 2021-12-03 | San Juan | Utah | 49037 | 2740 | 43 |
1975500 | 1975500 | 2021-12-02 | San Juan | Utah | 49037 | 2730 | 43 |
1972251 | 1972251 | 2021-12-01 | San Juan | Utah | 49037 | 2720 | 43 |
1969001 | 1969001 | 2021-11-30 | San Juan | Utah | 49037 | 2706 | 43 |
1965750 | 1965750 | 2021-11-29 | San Juan | Utah | 49037 | 2703 | 43 |
1962498 | 1962498 | 2021-11-28 | San Juan | Utah | 49037 | 2692 | 43 |
1959247 | 1959247 | 2021-11-27 | San Juan | Utah | 49037 | 2692 | 43 |
1955996 | 1955996 | 2021-11-26 | San Juan | Utah | 49037 | 2692 | 43 |
1952745 | 1952745 | 2021-11-25 | San Juan | Utah | 49037 | 2682 | 43 |
1949494 | 1949494 | 2021-11-24 | San Juan | Utah | 49037 | 2682 | 43 |
1946243 | 1946243 | 2021-11-23 | San Juan | Utah | 49037 | 2667 | 43 |
1942992 | 1942992 | 2021-11-22 | San Juan | Utah | 49037 | 2664 | 43 |
1939742 | 1939742 | 2021-11-21 | San Juan | Utah | 49037 | 2644 | 43 |
1936492 | 1936492 | 2021-11-20 | San Juan | Utah | 49037 | 2644 | 43 |
1933242 | 1933242 | 2021-11-19 | San Juan | Utah | 49037 | 2644 | 43 |
1929991 | 1929991 | 2021-11-18 | San Juan | Utah | 49037 | 2635 | 43 |
1926741 | 1926741 | 2021-11-17 | San Juan | Utah | 49037 | 2620 | 43 |
1923491 | 1923491 | 2021-11-16 | San Juan | Utah | 49037 | 2609 | 43 |
1920242 | 1920242 | 2021-11-15 | San Juan | Utah | 49037 | 2605 | 43 |
1916992 | 1916992 | 2021-11-14 | San Juan | Utah | 49037 | 2588 | 43 |
1913742 | 1913742 | 2021-11-13 | San Juan | Utah | 49037 | 2588 | 43 |
1910492 | 1910492 | 2021-11-12 | San Juan | Utah | 49037 | 2588 | 43 |
1907243 | 1907243 | 2021-11-11 | San Juan | Utah | 49037 | 2567 | 43 |
1903994 | 1903994 | 2021-11-10 | San Juan | Utah | 49037 | 2567 | 43 |
1900744 | 1900744 | 2021-11-09 | San Juan | Utah | 49037 | 2560 | 43 |
1897494 | 1897494 | 2021-11-08 | San Juan | Utah | 49037 | 2526 | 42 |
1894244 | 1894244 | 2021-11-07 | San Juan | Utah | 49037 | 2502 | 41 |
1890994 | 1890994 | 2021-11-06 | San Juan | Utah | 49037 | 2502 | 41 |
1887744 | 1887744 | 2021-11-05 | San Juan | Utah | 49037 | 2502 | 41 |
1884494 | 1884494 | 2021-11-04 | San Juan | Utah | 49037 | 2486 | 41 |
1881245 | 1881245 | 2021-11-03 | San Juan | Utah | 49037 | 2472 | 41 |
1877996 | 1877996 | 2021-11-02 | San Juan | Utah | 49037 | 2458 | 41 |
1874747 | 1874747 | 2021-11-01 | San Juan | Utah | 49037 | 2451 | 41 |
1871498 | 1871498 | 2021-10-31 | San Juan | Utah | 49037 | 2430 | 41 |
1868249 | 1868249 | 2021-10-30 | San Juan | Utah | 49037 | 2430 | 41 |
1865000 | 1865000 | 2021-10-29 | San Juan | Utah | 49037 | 2430 | 41 |
1861751 | 1861751 | 2021-10-28 | San Juan | Utah | 49037 | 2418 | 41 |
1858502 | 1858502 | 2021-10-27 | San Juan | Utah | 49037 | 2413 | 41 |
1855253 | 1855253 | 2021-10-26 | San Juan | Utah | 49037 | 2402 | 41 |
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);