ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Marion" and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176647 | 2176647 | 2022-02-02 | Marion | South Carolina | 45067 | 8272 | 153 |
2173393 | 2173393 | 2022-02-01 | Marion | South Carolina | 45067 | 8243 | 152 |
2170141 | 2170141 | 2022-01-31 | Marion | South Carolina | 45067 | 8235 | 150 |
2166887 | 2166887 | 2022-01-30 | Marion | South Carolina | 45067 | 8087 | 150 |
2163632 | 2163632 | 2022-01-29 | Marion | South Carolina | 45067 | 8087 | 150 |
2160377 | 2160377 | 2022-01-28 | Marion | South Carolina | 45067 | 8087 | 150 |
2157121 | 2157121 | 2022-01-27 | Marion | South Carolina | 45067 | 7999 | 150 |
2153868 | 2153868 | 2022-01-26 | Marion | South Carolina | 45067 | 7917 | 150 |
2150616 | 2150616 | 2022-01-25 | Marion | South Carolina | 45067 | 7543 | 150 |
2147364 | 2147364 | 2022-01-24 | Marion | South Carolina | 45067 | 7543 | 150 |
2144110 | 2144110 | 2022-01-23 | Marion | South Carolina | 45067 | 7543 | 150 |
2140855 | 2140855 | 2022-01-22 | Marion | South Carolina | 45067 | 7543 | 150 |
2137599 | 2137599 | 2022-01-21 | Marion | South Carolina | 45067 | 7543 | 150 |
2134345 | 2134345 | 2022-01-20 | Marion | South Carolina | 45067 | 7441 | 150 |
2131093 | 2131093 | 2022-01-19 | Marion | South Carolina | 45067 | 7357 | 149 |
2127839 | 2127839 | 2022-01-18 | Marion | South Carolina | 45067 | 7230 | 149 |
2124587 | 2124587 | 2022-01-17 | Marion | South Carolina | 45067 | 6798 | 147 |
2121335 | 2121335 | 2022-01-16 | Marion | South Carolina | 45067 | 6798 | 147 |
2118083 | 2118083 | 2022-01-15 | Marion | South Carolina | 45067 | 6798 | 147 |
2114832 | 2114832 | 2022-01-14 | Marion | South Carolina | 45067 | 6798 | 147 |
2111580 | 2111580 | 2022-01-13 | Marion | South Carolina | 45067 | 6671 | 146 |
2108328 | 2108328 | 2022-01-12 | Marion | South Carolina | 45067 | 6597 | 146 |
2105077 | 2105077 | 2022-01-11 | Marion | South Carolina | 45067 | 6513 | 146 |
2101826 | 2101826 | 2022-01-10 | Marion | South Carolina | 45067 | 6430 | 144 |
2098575 | 2098575 | 2022-01-09 | Marion | South Carolina | 45067 | 6192 | 143 |
2095323 | 2095323 | 2022-01-08 | Marion | South Carolina | 45067 | 6192 | 143 |
2092071 | 2092071 | 2022-01-07 | Marion | South Carolina | 45067 | 6192 | 143 |
2088819 | 2088819 | 2022-01-06 | Marion | South Carolina | 45067 | 6103 | 143 |
2085568 | 2085568 | 2022-01-05 | Marion | South Carolina | 45067 | 5980 | 143 |
2082316 | 2082316 | 2022-01-04 | Marion | South Carolina | 45067 | 5939 | 143 |
2079064 | 2079064 | 2022-01-03 | Marion | South Carolina | 45067 | 5754 | 143 |
2075813 | 2075813 | 2022-01-02 | Marion | South Carolina | 45067 | 5754 | 143 |
2072562 | 2072562 | 2022-01-01 | Marion | South Carolina | 45067 | 5754 | 143 |
2069311 | 2069311 | 2021-12-31 | Marion | South Carolina | 45067 | 5754 | 143 |
2066060 | 2066060 | 2021-12-30 | Marion | South Carolina | 45067 | 5710 | 143 |
2062810 | 2062810 | 2021-12-29 | Marion | South Carolina | 45067 | 5672 | 143 |
2059560 | 2059560 | 2021-12-28 | Marion | South Carolina | 45067 | 5622 | 143 |
2056311 | 2056311 | 2021-12-27 | Marion | South Carolina | 45067 | 5622 | 143 |
2053062 | 2053062 | 2021-12-26 | Marion | South Carolina | 45067 | 5622 | 143 |
2049812 | 2049812 | 2021-12-25 | Marion | South Carolina | 45067 | 5622 | 143 |
2046562 | 2046562 | 2021-12-24 | Marion | South Carolina | 45067 | 5622 | 143 |
2043312 | 2043312 | 2021-12-23 | Marion | South Carolina | 45067 | 5622 | 143 |
2040063 | 2040063 | 2021-12-22 | Marion | South Carolina | 45067 | 5620 | 143 |
2036813 | 2036813 | 2021-12-21 | Marion | South Carolina | 45067 | 5612 | 143 |
2033563 | 2033563 | 2021-12-20 | Marion | South Carolina | 45067 | 5612 | 143 |
2030313 | 2030313 | 2021-12-19 | Marion | South Carolina | 45067 | 5595 | 143 |
2027062 | 2027062 | 2021-12-18 | Marion | South Carolina | 45067 | 5595 | 143 |
2023811 | 2023811 | 2021-12-17 | Marion | South Carolina | 45067 | 5595 | 143 |
2020560 | 2020560 | 2021-12-16 | Marion | South Carolina | 45067 | 5588 | 143 |
2017309 | 2017309 | 2021-12-15 | Marion | South Carolina | 45067 | 5582 | 143 |
2014059 | 2014059 | 2021-12-14 | Marion | South Carolina | 45067 | 5580 | 143 |
2010808 | 2010808 | 2021-12-13 | Marion | South Carolina | 45067 | 5579 | 143 |
2007557 | 2007557 | 2021-12-12 | Marion | South Carolina | 45067 | 5572 | 143 |
2004306 | 2004306 | 2021-12-11 | Marion | South Carolina | 45067 | 5572 | 143 |
2001055 | 2001055 | 2021-12-10 | Marion | South Carolina | 45067 | 5572 | 143 |
1997805 | 1997805 | 2021-12-09 | Marion | South Carolina | 45067 | 5567 | 143 |
1994554 | 1994554 | 2021-12-08 | Marion | South Carolina | 45067 | 5565 | 143 |
1991303 | 1991303 | 2021-12-07 | Marion | South Carolina | 45067 | 5561 | 143 |
1988052 | 1988052 | 2021-12-06 | Marion | South Carolina | 45067 | 5561 | 143 |
1984802 | 1984802 | 2021-12-05 | Marion | South Carolina | 45067 | 5547 | 143 |
1981552 | 1981552 | 2021-12-04 | Marion | South Carolina | 45067 | 5547 | 143 |
1978302 | 1978302 | 2021-12-03 | Marion | South Carolina | 45067 | 5547 | 143 |
1975052 | 1975052 | 2021-12-02 | Marion | South Carolina | 45067 | 5547 | 143 |
1971803 | 1971803 | 2021-12-01 | Marion | South Carolina | 45067 | 5541 | 143 |
1968553 | 1968553 | 2021-11-30 | Marion | South Carolina | 45067 | 5539 | 143 |
1965302 | 1965302 | 2021-11-29 | Marion | South Carolina | 45067 | 5536 | 143 |
1962050 | 1962050 | 2021-11-28 | Marion | South Carolina | 45067 | 5528 | 142 |
1958799 | 1958799 | 2021-11-27 | Marion | South Carolina | 45067 | 5528 | 142 |
1955548 | 1955548 | 2021-11-26 | Marion | South Carolina | 45067 | 5528 | 142 |
1952297 | 1952297 | 2021-11-25 | Marion | South Carolina | 45067 | 5523 | 142 |
1949046 | 1949046 | 2021-11-24 | Marion | South Carolina | 45067 | 5523 | 142 |
1945795 | 1945795 | 2021-11-23 | Marion | South Carolina | 45067 | 5521 | 142 |
1942544 | 1942544 | 2021-11-22 | Marion | South Carolina | 45067 | 5519 | 142 |
1939294 | 1939294 | 2021-11-21 | Marion | South Carolina | 45067 | 5512 | 142 |
1936044 | 1936044 | 2021-11-20 | Marion | South Carolina | 45067 | 5512 | 142 |
1932794 | 1932794 | 2021-11-19 | Marion | South Carolina | 45067 | 5512 | 142 |
1929543 | 1929543 | 2021-11-18 | Marion | South Carolina | 45067 | 5510 | 142 |
1926293 | 1926293 | 2021-11-17 | Marion | South Carolina | 45067 | 5512 | 141 |
1923043 | 1923043 | 2021-11-16 | Marion | South Carolina | 45067 | 5512 | 141 |
1919794 | 1919794 | 2021-11-15 | Marion | South Carolina | 45067 | 5510 | 141 |
1916544 | 1916544 | 2021-11-14 | Marion | South Carolina | 45067 | 5508 | 141 |
1913294 | 1913294 | 2021-11-13 | Marion | South Carolina | 45067 | 5508 | 141 |
1910044 | 1910044 | 2021-11-12 | Marion | South Carolina | 45067 | 5508 | 141 |
1906795 | 1906795 | 2021-11-11 | Marion | South Carolina | 45067 | 5498 | 141 |
1903546 | 1903546 | 2021-11-10 | Marion | South Carolina | 45067 | 5498 | 141 |
1900296 | 1900296 | 2021-11-09 | Marion | South Carolina | 45067 | 5496 | 140 |
1897046 | 1897046 | 2021-11-08 | Marion | South Carolina | 45067 | 5485 | 140 |
1893796 | 1893796 | 2021-11-07 | Marion | South Carolina | 45067 | 5478 | 140 |
1890546 | 1890546 | 2021-11-06 | Marion | South Carolina | 45067 | 5478 | 140 |
1887296 | 1887296 | 2021-11-05 | Marion | South Carolina | 45067 | 5478 | 140 |
1884046 | 1884046 | 2021-11-04 | Marion | South Carolina | 45067 | 5475 | 140 |
1880797 | 1880797 | 2021-11-03 | Marion | South Carolina | 45067 | 5467 | 140 |
1877548 | 1877548 | 2021-11-02 | Marion | South Carolina | 45067 | 5463 | 140 |
1874299 | 1874299 | 2021-11-01 | Marion | South Carolina | 45067 | 5460 | 139 |
1871050 | 1871050 | 2021-10-31 | Marion | South Carolina | 45067 | 5441 | 139 |
1867801 | 1867801 | 2021-10-30 | Marion | South Carolina | 45067 | 5441 | 139 |
1864552 | 1864552 | 2021-10-29 | Marion | South Carolina | 45067 | 5441 | 139 |
1861303 | 1861303 | 2021-10-28 | Marion | South Carolina | 45067 | 5431 | 139 |
1858054 | 1858054 | 2021-10-27 | Marion | South Carolina | 45067 | 5429 | 138 |
1854805 | 1854805 | 2021-10-26 | Marion | South Carolina | 45067 | 5428 | 138 |
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);