ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Colleton" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176629 | 2176629 | 2022-02-02 | Colleton | South Carolina | 45029 | 8311 | 203 |
2173375 | 2173375 | 2022-02-01 | Colleton | South Carolina | 45029 | 8291 | 202 |
2170123 | 2170123 | 2022-01-31 | Colleton | South Carolina | 45029 | 8267 | 202 |
2166869 | 2166869 | 2022-01-30 | Colleton | South Carolina | 45029 | 8125 | 198 |
2163614 | 2163614 | 2022-01-29 | Colleton | South Carolina | 45029 | 8125 | 198 |
2160359 | 2160359 | 2022-01-28 | Colleton | South Carolina | 45029 | 8125 | 198 |
2157103 | 2157103 | 2022-01-27 | Colleton | South Carolina | 45029 | 7943 | 198 |
2153850 | 2153850 | 2022-01-26 | Colleton | South Carolina | 45029 | 7901 | 198 |
2150598 | 2150598 | 2022-01-25 | Colleton | South Carolina | 45029 | 7589 | 197 |
2147346 | 2147346 | 2022-01-24 | Colleton | South Carolina | 45029 | 7589 | 197 |
2144092 | 2144092 | 2022-01-23 | Colleton | South Carolina | 45029 | 7589 | 197 |
2140837 | 2140837 | 2022-01-22 | Colleton | South Carolina | 45029 | 7589 | 197 |
2137581 | 2137581 | 2022-01-21 | Colleton | South Carolina | 45029 | 7589 | 197 |
2134327 | 2134327 | 2022-01-20 | Colleton | South Carolina | 45029 | 7479 | 197 |
2131075 | 2131075 | 2022-01-19 | Colleton | South Carolina | 45029 | 7416 | 197 |
2127821 | 2127821 | 2022-01-18 | Colleton | South Carolina | 45029 | 7383 | 197 |
2124569 | 2124569 | 2022-01-17 | Colleton | South Carolina | 45029 | 7002 | 196 |
2121317 | 2121317 | 2022-01-16 | Colleton | South Carolina | 45029 | 7002 | 196 |
2118065 | 2118065 | 2022-01-15 | Colleton | South Carolina | 45029 | 7002 | 196 |
2114814 | 2114814 | 2022-01-14 | Colleton | South Carolina | 45029 | 7002 | 196 |
2111562 | 2111562 | 2022-01-13 | Colleton | South Carolina | 45029 | 6873 | 195 |
2108310 | 2108310 | 2022-01-12 | Colleton | South Carolina | 45029 | 6743 | 195 |
2105059 | 2105059 | 2022-01-11 | Colleton | South Carolina | 45029 | 6665 | 195 |
2101808 | 2101808 | 2022-01-10 | Colleton | South Carolina | 45029 | 6613 | 195 |
2098557 | 2098557 | 2022-01-09 | Colleton | South Carolina | 45029 | 6350 | 193 |
2095305 | 2095305 | 2022-01-08 | Colleton | South Carolina | 45029 | 6350 | 193 |
2092053 | 2092053 | 2022-01-07 | Colleton | South Carolina | 45029 | 6350 | 193 |
2088801 | 2088801 | 2022-01-06 | Colleton | South Carolina | 45029 | 6297 | 193 |
2085550 | 2085550 | 2022-01-05 | Colleton | South Carolina | 45029 | 6200 | 193 |
2082298 | 2082298 | 2022-01-04 | Colleton | South Carolina | 45029 | 6170 | 193 |
2079046 | 2079046 | 2022-01-03 | Colleton | South Carolina | 45029 | 5962 | 192 |
2075795 | 2075795 | 2022-01-02 | Colleton | South Carolina | 45029 | 5962 | 192 |
2072544 | 2072544 | 2022-01-01 | Colleton | South Carolina | 45029 | 5962 | 192 |
2069293 | 2069293 | 2021-12-31 | Colleton | South Carolina | 45029 | 5962 | 192 |
2066042 | 2066042 | 2021-12-30 | Colleton | South Carolina | 45029 | 5937 | 192 |
2062792 | 2062792 | 2021-12-29 | Colleton | South Carolina | 45029 | 5894 | 192 |
2059542 | 2059542 | 2021-12-28 | Colleton | South Carolina | 45029 | 5849 | 192 |
2056293 | 2056293 | 2021-12-27 | Colleton | South Carolina | 45029 | 5849 | 192 |
2053044 | 2053044 | 2021-12-26 | Colleton | South Carolina | 45029 | 5849 | 192 |
2049794 | 2049794 | 2021-12-25 | Colleton | South Carolina | 45029 | 5849 | 192 |
2046544 | 2046544 | 2021-12-24 | Colleton | South Carolina | 45029 | 5849 | 192 |
2043294 | 2043294 | 2021-12-23 | Colleton | South Carolina | 45029 | 5849 | 192 |
2040045 | 2040045 | 2021-12-22 | Colleton | South Carolina | 45029 | 5843 | 191 |
2036795 | 2036795 | 2021-12-21 | Colleton | South Carolina | 45029 | 5842 | 191 |
2033545 | 2033545 | 2021-12-20 | Colleton | South Carolina | 45029 | 5841 | 191 |
2030295 | 2030295 | 2021-12-19 | Colleton | South Carolina | 45029 | 5828 | 191 |
2027044 | 2027044 | 2021-12-18 | Colleton | South Carolina | 45029 | 5828 | 191 |
2023793 | 2023793 | 2021-12-17 | Colleton | South Carolina | 45029 | 5828 | 191 |
2020542 | 2020542 | 2021-12-16 | Colleton | South Carolina | 45029 | 5821 | 191 |
2017291 | 2017291 | 2021-12-15 | Colleton | South Carolina | 45029 | 5820 | 191 |
2014041 | 2014041 | 2021-12-14 | Colleton | South Carolina | 45029 | 5817 | 191 |
2010790 | 2010790 | 2021-12-13 | Colleton | South Carolina | 45029 | 5811 | 191 |
2007539 | 2007539 | 2021-12-12 | Colleton | South Carolina | 45029 | 5782 | 190 |
2004288 | 2004288 | 2021-12-11 | Colleton | South Carolina | 45029 | 5782 | 190 |
2001037 | 2001037 | 2021-12-10 | Colleton | South Carolina | 45029 | 5782 | 190 |
1997787 | 1997787 | 2021-12-09 | Colleton | South Carolina | 45029 | 5777 | 190 |
1994536 | 1994536 | 2021-12-08 | Colleton | South Carolina | 45029 | 5771 | 190 |
1991285 | 1991285 | 2021-12-07 | Colleton | South Carolina | 45029 | 5771 | 190 |
1988034 | 1988034 | 2021-12-06 | Colleton | South Carolina | 45029 | 5762 | 190 |
1984784 | 1984784 | 2021-12-05 | Colleton | South Carolina | 45029 | 5742 | 190 |
1981534 | 1981534 | 2021-12-04 | Colleton | South Carolina | 45029 | 5742 | 190 |
1978284 | 1978284 | 2021-12-03 | Colleton | South Carolina | 45029 | 5742 | 190 |
1975034 | 1975034 | 2021-12-02 | Colleton | South Carolina | 45029 | 5733 | 190 |
1971785 | 1971785 | 2021-12-01 | Colleton | South Carolina | 45029 | 5726 | 190 |
1968535 | 1968535 | 2021-11-30 | Colleton | South Carolina | 45029 | 5723 | 190 |
1965284 | 1965284 | 2021-11-29 | Colleton | South Carolina | 45029 | 5708 | 190 |
1962032 | 1962032 | 2021-11-28 | Colleton | South Carolina | 45029 | 5702 | 190 |
1958781 | 1958781 | 2021-11-27 | Colleton | South Carolina | 45029 | 5702 | 190 |
1955530 | 1955530 | 2021-11-26 | Colleton | South Carolina | 45029 | 5702 | 190 |
1952279 | 1952279 | 2021-11-25 | Colleton | South Carolina | 45029 | 5701 | 190 |
1949028 | 1949028 | 2021-11-24 | Colleton | South Carolina | 45029 | 5701 | 190 |
1945777 | 1945777 | 2021-11-23 | Colleton | South Carolina | 45029 | 5698 | 190 |
1942526 | 1942526 | 2021-11-22 | Colleton | South Carolina | 45029 | 5695 | 190 |
1939276 | 1939276 | 2021-11-21 | Colleton | South Carolina | 45029 | 5671 | 190 |
1936026 | 1936026 | 2021-11-20 | Colleton | South Carolina | 45029 | 5671 | 190 |
1932776 | 1932776 | 2021-11-19 | Colleton | South Carolina | 45029 | 5671 | 190 |
1929525 | 1929525 | 2021-11-18 | Colleton | South Carolina | 45029 | 5662 | 190 |
1926275 | 1926275 | 2021-11-17 | Colleton | South Carolina | 45029 | 5659 | 190 |
1923025 | 1923025 | 2021-11-16 | Colleton | South Carolina | 45029 | 5658 | 190 |
1919776 | 1919776 | 2021-11-15 | Colleton | South Carolina | 45029 | 5657 | 190 |
1916526 | 1916526 | 2021-11-14 | Colleton | South Carolina | 45029 | 5653 | 190 |
1913276 | 1913276 | 2021-11-13 | Colleton | South Carolina | 45029 | 5653 | 190 |
1910026 | 1910026 | 2021-11-12 | Colleton | South Carolina | 45029 | 5653 | 190 |
1906777 | 1906777 | 2021-11-11 | Colleton | South Carolina | 45029 | 5651 | 190 |
1903528 | 1903528 | 2021-11-10 | Colleton | South Carolina | 45029 | 5651 | 190 |
1900278 | 1900278 | 2021-11-09 | Colleton | South Carolina | 45029 | 5645 | 190 |
1897028 | 1897028 | 2021-11-08 | Colleton | South Carolina | 45029 | 5644 | 190 |
1893778 | 1893778 | 2021-11-07 | Colleton | South Carolina | 45029 | 5640 | 190 |
1890528 | 1890528 | 2021-11-06 | Colleton | South Carolina | 45029 | 5640 | 190 |
1887278 | 1887278 | 2021-11-05 | Colleton | South Carolina | 45029 | 5640 | 190 |
1884028 | 1884028 | 2021-11-04 | Colleton | South Carolina | 45029 | 5633 | 190 |
1880779 | 1880779 | 2021-11-03 | Colleton | South Carolina | 45029 | 5632 | 190 |
1877530 | 1877530 | 2021-11-02 | Colleton | South Carolina | 45029 | 5632 | 190 |
1874281 | 1874281 | 2021-11-01 | Colleton | South Carolina | 45029 | 5632 | 190 |
1871032 | 1871032 | 2021-10-31 | Colleton | South Carolina | 45029 | 5624 | 190 |
1867783 | 1867783 | 2021-10-30 | Colleton | South Carolina | 45029 | 5624 | 190 |
1864534 | 1864534 | 2021-10-29 | Colleton | South Carolina | 45029 | 5624 | 190 |
1861285 | 1861285 | 2021-10-28 | Colleton | South Carolina | 45029 | 5619 | 190 |
1858036 | 1858036 | 2021-10-27 | Colleton | South Carolina | 45029 | 5617 | 189 |
1854787 | 1854787 | 2021-10-26 | Colleton | South Carolina | 45029 | 5616 | 189 |
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);