ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Trumbull" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176337 | 2176337 | 2022-02-02 | Trumbull | Ohio | 39155 | 40504 | 823 |
2173083 | 2173083 | 2022-02-01 | Trumbull | Ohio | 39155 | 40426 | 823 |
2169831 | 2169831 | 2022-01-31 | Trumbull | Ohio | 39155 | 40374 | 811 |
2166576 | 2166576 | 2022-01-30 | Trumbull | Ohio | 39155 | 40336 | 811 |
2163321 | 2163321 | 2022-01-29 | Trumbull | Ohio | 39155 | 40276 | 811 |
2160066 | 2160066 | 2022-01-28 | Trumbull | Ohio | 39155 | 40194 | 811 |
2156811 | 2156811 | 2022-01-27 | Trumbull | Ohio | 39155 | 40091 | 800 |
2153558 | 2153558 | 2022-01-26 | Trumbull | Ohio | 39155 | 39968 | 800 |
2150306 | 2150306 | 2022-01-25 | Trumbull | Ohio | 39155 | 39785 | 800 |
2147054 | 2147054 | 2022-01-24 | Trumbull | Ohio | 39155 | 39746 | 790 |
2143800 | 2143800 | 2022-01-23 | Trumbull | Ohio | 39155 | 39646 | 790 |
2140545 | 2140545 | 2022-01-22 | Trumbull | Ohio | 39155 | 39527 | 790 |
2137289 | 2137289 | 2022-01-21 | Trumbull | Ohio | 39155 | 39357 | 790 |
2134035 | 2134035 | 2022-01-20 | Trumbull | Ohio | 39155 | 39108 | 755 |
2130783 | 2130783 | 2022-01-19 | Trumbull | Ohio | 39155 | 38910 | 755 |
2127529 | 2127529 | 2022-01-18 | Trumbull | Ohio | 39155 | 38726 | 755 |
2124277 | 2124277 | 2022-01-17 | Trumbull | Ohio | 39155 | 38576 | 748 |
2121025 | 2121025 | 2022-01-16 | Trumbull | Ohio | 39155 | 38385 | 748 |
2117773 | 2117773 | 2022-01-15 | Trumbull | Ohio | 39155 | 37996 | 748 |
2114522 | 2114522 | 2022-01-14 | Trumbull | Ohio | 39155 | 36959 | 748 |
2111270 | 2111270 | 2022-01-13 | Trumbull | Ohio | 39155 | 36296 | 736 |
2108018 | 2108018 | 2022-01-12 | Trumbull | Ohio | 39155 | 35997 | 736 |
2104767 | 2104767 | 2022-01-11 | Trumbull | Ohio | 39155 | 35657 | 736 |
2101516 | 2101516 | 2022-01-10 | Trumbull | Ohio | 39155 | 35311 | 710 |
2098265 | 2098265 | 2022-01-09 | Trumbull | Ohio | 39155 | 34987 | 710 |
2095013 | 2095013 | 2022-01-08 | Trumbull | Ohio | 39155 | 34645 | 710 |
2091761 | 2091761 | 2022-01-07 | Trumbull | Ohio | 39155 | 34443 | 710 |
2088509 | 2088509 | 2022-01-06 | Trumbull | Ohio | 39155 | 34109 | 705 |
2085258 | 2085258 | 2022-01-05 | Trumbull | Ohio | 39155 | 33822 | 705 |
2082006 | 2082006 | 2022-01-04 | Trumbull | Ohio | 39155 | 33530 | 705 |
2078754 | 2078754 | 2022-01-03 | Trumbull | Ohio | 39155 | 33159 | 705 |
2075503 | 2075503 | 2022-01-02 | Trumbull | Ohio | 39155 | 32836 | 705 |
2072252 | 2072252 | 2022-01-01 | Trumbull | Ohio | 39155 | 32074 | 705 |
2069001 | 2069001 | 2021-12-31 | Trumbull | Ohio | 39155 | 32074 | 705 |
2065750 | 2065750 | 2021-12-30 | Trumbull | Ohio | 39155 | 31696 | 662 |
2062500 | 2062500 | 2021-12-29 | Trumbull | Ohio | 39155 | 31362 | 662 |
2059250 | 2059250 | 2021-12-28 | Trumbull | Ohio | 39155 | 31111 | 662 |
2056001 | 2056001 | 2021-12-27 | Trumbull | Ohio | 39155 | 30864 | 662 |
2052752 | 2052752 | 2021-12-26 | Trumbull | Ohio | 39155 | 30733 | 662 |
2049502 | 2049502 | 2021-12-25 | Trumbull | Ohio | 39155 | 30343 | 662 |
2046252 | 2046252 | 2021-12-24 | Trumbull | Ohio | 39155 | 30343 | 662 |
2043002 | 2043002 | 2021-12-23 | Trumbull | Ohio | 39155 | 30163 | 662 |
2039753 | 2039753 | 2021-12-22 | Trumbull | Ohio | 39155 | 29928 | 662 |
2036503 | 2036503 | 2021-12-21 | Trumbull | Ohio | 39155 | 29810 | 662 |
2033253 | 2033253 | 2021-12-20 | Trumbull | Ohio | 39155 | 29628 | 661 |
2030003 | 2030003 | 2021-12-19 | Trumbull | Ohio | 39155 | 29446 | 661 |
2026752 | 2026752 | 2021-12-18 | Trumbull | Ohio | 39155 | 29357 | 661 |
2023501 | 2023501 | 2021-12-17 | Trumbull | Ohio | 39155 | 29247 | 661 |
2020250 | 2020250 | 2021-12-16 | Trumbull | Ohio | 39155 | 29094 | 637 |
2016999 | 2016999 | 2021-12-15 | Trumbull | Ohio | 39155 | 28975 | 637 |
2013749 | 2013749 | 2021-12-14 | Trumbull | Ohio | 39155 | 28863 | 637 |
2010498 | 2010498 | 2021-12-13 | Trumbull | Ohio | 39155 | 28745 | 633 |
2007247 | 2007247 | 2021-12-12 | Trumbull | Ohio | 39155 | 28664 | 633 |
2003996 | 2003996 | 2021-12-11 | Trumbull | Ohio | 39155 | 28579 | 633 |
2000745 | 2000745 | 2021-12-10 | Trumbull | Ohio | 39155 | 28422 | 633 |
1997495 | 1997495 | 2021-12-09 | Trumbull | Ohio | 39155 | 28279 | 623 |
1994244 | 1994244 | 2021-12-08 | Trumbull | Ohio | 39155 | 28123 | 623 |
1990993 | 1990993 | 2021-12-07 | Trumbull | Ohio | 39155 | 27953 | 623 |
1987742 | 1987742 | 2021-12-06 | Trumbull | Ohio | 39155 | 27766 | 620 |
1984492 | 1984492 | 2021-12-05 | Trumbull | Ohio | 39155 | 27614 | 620 |
1981242 | 1981242 | 2021-12-04 | Trumbull | Ohio | 39155 | 27506 | 620 |
1977992 | 1977992 | 2021-12-03 | Trumbull | Ohio | 39155 | 27344 | 620 |
1974742 | 1974742 | 2021-12-02 | Trumbull | Ohio | 39155 | 27130 | 616 |
1971493 | 1971493 | 2021-12-01 | Trumbull | Ohio | 39155 | 26962 | 616 |
1968243 | 1968243 | 2021-11-30 | Trumbull | Ohio | 39155 | 26782 | 616 |
1964992 | 1964992 | 2021-11-29 | Trumbull | Ohio | 39155 | 26664 | 611 |
1961740 | 1961740 | 2021-11-28 | Trumbull | Ohio | 39155 | 26516 | 611 |
1958489 | 1958489 | 2021-11-27 | Trumbull | Ohio | 39155 | 26366 | 611 |
1955238 | 1955238 | 2021-11-26 | Trumbull | Ohio | 39155 | 26232 | 611 |
1951987 | 1951987 | 2021-11-25 | Trumbull | Ohio | 39155 | 25991 | 605 |
1948736 | 1948736 | 2021-11-24 | Trumbull | Ohio | 39155 | 25991 | 605 |
1945485 | 1945485 | 2021-11-23 | Trumbull | Ohio | 39155 | 25846 | 605 |
1942234 | 1942234 | 2021-11-22 | Trumbull | Ohio | 39155 | 25713 | 602 |
1938984 | 1938984 | 2021-11-21 | Trumbull | Ohio | 39155 | 25592 | 602 |
1935734 | 1935734 | 2021-11-20 | Trumbull | Ohio | 39155 | 25492 | 602 |
1932484 | 1932484 | 2021-11-19 | Trumbull | Ohio | 39155 | 25347 | 602 |
1929233 | 1929233 | 2021-11-18 | Trumbull | Ohio | 39155 | 25184 | 597 |
1925983 | 1925983 | 2021-11-17 | Trumbull | Ohio | 39155 | 25025 | 597 |
1922733 | 1922733 | 2021-11-16 | Trumbull | Ohio | 39155 | 24925 | 597 |
1919484 | 1919484 | 2021-11-15 | Trumbull | Ohio | 39155 | 24811 | 595 |
1916234 | 1916234 | 2021-11-14 | Trumbull | Ohio | 39155 | 24739 | 595 |
1912984 | 1912984 | 2021-11-13 | Trumbull | Ohio | 39155 | 24637 | 595 |
1909734 | 1909734 | 2021-11-12 | Trumbull | Ohio | 39155 | 24537 | 595 |
1906485 | 1906485 | 2021-11-11 | Trumbull | Ohio | 39155 | 24436 | 586 |
1903236 | 1903236 | 2021-11-10 | Trumbull | Ohio | 39155 | 24334 | 586 |
1899986 | 1899986 | 2021-11-09 | Trumbull | Ohio | 39155 | 24252 | 586 |
1896736 | 1896736 | 2021-11-08 | Trumbull | Ohio | 39155 | 24132 | 583 |
1893486 | 1893486 | 2021-11-07 | Trumbull | Ohio | 39155 | 24082 | 583 |
1890236 | 1890236 | 2021-11-06 | Trumbull | Ohio | 39155 | 23980 | 583 |
1886986 | 1886986 | 2021-11-05 | Trumbull | Ohio | 39155 | 23919 | 583 |
1883736 | 1883736 | 2021-11-04 | Trumbull | Ohio | 39155 | 23842 | 580 |
1880487 | 1880487 | 2021-11-03 | Trumbull | Ohio | 39155 | 23736 | 580 |
1877238 | 1877238 | 2021-11-02 | Trumbull | Ohio | 39155 | 23622 | 580 |
1873989 | 1873989 | 2021-11-01 | Trumbull | Ohio | 39155 | 23529 | 572 |
1870740 | 1870740 | 2021-10-31 | Trumbull | Ohio | 39155 | 23454 | 572 |
1867491 | 1867491 | 2021-10-30 | Trumbull | Ohio | 39155 | 23398 | 572 |
1864242 | 1864242 | 2021-10-29 | Trumbull | Ohio | 39155 | 23316 | 572 |
1860993 | 1860993 | 2021-10-28 | Trumbull | Ohio | 39155 | 23237 | 565 |
1857744 | 1857744 | 2021-10-27 | Trumbull | Ohio | 39155 | 23143 | 565 |
1854495 | 1854495 | 2021-10-26 | Trumbull | Ohio | 39155 | 23064 | 565 |
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);