ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 45027 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 |
---|---|---|---|---|---|---|---|
2176628 | 2176628 | 2022-02-02 | Clarendon | South Carolina | 45027 | 8088 | 145 |
2173374 | 2173374 | 2022-02-01 | Clarendon | South Carolina | 45027 | 8033 | 142 |
2170122 | 2170122 | 2022-01-31 | Clarendon | South Carolina | 45027 | 7998 | 142 |
2166868 | 2166868 | 2022-01-30 | Clarendon | South Carolina | 45027 | 7787 | 141 |
2163613 | 2163613 | 2022-01-29 | Clarendon | South Carolina | 45027 | 7787 | 141 |
2160358 | 2160358 | 2022-01-28 | Clarendon | South Carolina | 45027 | 7787 | 141 |
2157102 | 2157102 | 2022-01-27 | Clarendon | South Carolina | 45027 | 7691 | 141 |
2153849 | 2153849 | 2022-01-26 | Clarendon | South Carolina | 45027 | 7651 | 141 |
2150597 | 2150597 | 2022-01-25 | Clarendon | South Carolina | 45027 | 7165 | 141 |
2147345 | 2147345 | 2022-01-24 | Clarendon | South Carolina | 45027 | 7165 | 141 |
2144091 | 2144091 | 2022-01-23 | Clarendon | South Carolina | 45027 | 7165 | 141 |
2140836 | 2140836 | 2022-01-22 | Clarendon | South Carolina | 45027 | 7165 | 141 |
2137580 | 2137580 | 2022-01-21 | Clarendon | South Carolina | 45027 | 7165 | 141 |
2134326 | 2134326 | 2022-01-20 | Clarendon | South Carolina | 45027 | 7034 | 141 |
2131074 | 2131074 | 2022-01-19 | Clarendon | South Carolina | 45027 | 6944 | 140 |
2127820 | 2127820 | 2022-01-18 | Clarendon | South Carolina | 45027 | 6790 | 140 |
2124568 | 2124568 | 2022-01-17 | Clarendon | South Carolina | 45027 | 6349 | 138 |
2121316 | 2121316 | 2022-01-16 | Clarendon | South Carolina | 45027 | 6349 | 138 |
2118064 | 2118064 | 2022-01-15 | Clarendon | South Carolina | 45027 | 6349 | 138 |
2114813 | 2114813 | 2022-01-14 | Clarendon | South Carolina | 45027 | 6349 | 138 |
2111561 | 2111561 | 2022-01-13 | Clarendon | South Carolina | 45027 | 6270 | 138 |
2108309 | 2108309 | 2022-01-12 | Clarendon | South Carolina | 45027 | 6168 | 138 |
2105058 | 2105058 | 2022-01-11 | Clarendon | South Carolina | 45027 | 6034 | 138 |
2101807 | 2101807 | 2022-01-10 | Clarendon | South Carolina | 45027 | 6004 | 138 |
2098556 | 2098556 | 2022-01-09 | Clarendon | South Carolina | 45027 | 5781 | 138 |
2095304 | 2095304 | 2022-01-08 | Clarendon | South Carolina | 45027 | 5781 | 138 |
2092052 | 2092052 | 2022-01-07 | Clarendon | South Carolina | 45027 | 5781 | 138 |
2088800 | 2088800 | 2022-01-06 | Clarendon | South Carolina | 45027 | 5748 | 138 |
2085549 | 2085549 | 2022-01-05 | Clarendon | South Carolina | 45027 | 5685 | 138 |
2082297 | 2082297 | 2022-01-04 | Clarendon | South Carolina | 45027 | 5661 | 137 |
2079045 | 2079045 | 2022-01-03 | Clarendon | South Carolina | 45027 | 5467 | 137 |
2075794 | 2075794 | 2022-01-02 | Clarendon | South Carolina | 45027 | 5467 | 137 |
2072543 | 2072543 | 2022-01-01 | Clarendon | South Carolina | 45027 | 5467 | 137 |
2069292 | 2069292 | 2021-12-31 | Clarendon | South Carolina | 45027 | 5467 | 137 |
2066041 | 2066041 | 2021-12-30 | Clarendon | South Carolina | 45027 | 5428 | 137 |
2062791 | 2062791 | 2021-12-29 | Clarendon | South Carolina | 45027 | 5399 | 137 |
2059541 | 2059541 | 2021-12-28 | Clarendon | South Carolina | 45027 | 5324 | 137 |
2056292 | 2056292 | 2021-12-27 | Clarendon | South Carolina | 45027 | 5324 | 137 |
2053043 | 2053043 | 2021-12-26 | Clarendon | South Carolina | 45027 | 5324 | 137 |
2049793 | 2049793 | 2021-12-25 | Clarendon | South Carolina | 45027 | 5324 | 137 |
2046543 | 2046543 | 2021-12-24 | Clarendon | South Carolina | 45027 | 5324 | 137 |
2043293 | 2043293 | 2021-12-23 | Clarendon | South Carolina | 45027 | 5324 | 137 |
2040044 | 2040044 | 2021-12-22 | Clarendon | South Carolina | 45027 | 5309 | 137 |
2036794 | 2036794 | 2021-12-21 | Clarendon | South Carolina | 45027 | 5303 | 137 |
2033544 | 2033544 | 2021-12-20 | Clarendon | South Carolina | 45027 | 5300 | 137 |
2030294 | 2030294 | 2021-12-19 | Clarendon | South Carolina | 45027 | 5293 | 137 |
2027043 | 2027043 | 2021-12-18 | Clarendon | South Carolina | 45027 | 5293 | 137 |
2023792 | 2023792 | 2021-12-17 | Clarendon | South Carolina | 45027 | 5293 | 137 |
2020541 | 2020541 | 2021-12-16 | Clarendon | South Carolina | 45027 | 5285 | 137 |
2017290 | 2017290 | 2021-12-15 | Clarendon | South Carolina | 45027 | 5275 | 137 |
2014040 | 2014040 | 2021-12-14 | Clarendon | South Carolina | 45027 | 5259 | 137 |
2010789 | 2010789 | 2021-12-13 | Clarendon | South Carolina | 45027 | 5256 | 137 |
2007538 | 2007538 | 2021-12-12 | Clarendon | South Carolina | 45027 | 5242 | 136 |
2004287 | 2004287 | 2021-12-11 | Clarendon | South Carolina | 45027 | 5242 | 136 |
2001036 | 2001036 | 2021-12-10 | Clarendon | South Carolina | 45027 | 5242 | 136 |
1997786 | 1997786 | 2021-12-09 | Clarendon | South Carolina | 45027 | 5232 | 136 |
1994535 | 1994535 | 2021-12-08 | Clarendon | South Carolina | 45027 | 5226 | 136 |
1991284 | 1991284 | 2021-12-07 | Clarendon | South Carolina | 45027 | 5220 | 136 |
1988033 | 1988033 | 2021-12-06 | Clarendon | South Carolina | 45027 | 5216 | 136 |
1984783 | 1984783 | 2021-12-05 | Clarendon | South Carolina | 45027 | 5198 | 136 |
1981533 | 1981533 | 2021-12-04 | Clarendon | South Carolina | 45027 | 5198 | 136 |
1978283 | 1978283 | 2021-12-03 | Clarendon | South Carolina | 45027 | 5198 | 136 |
1975033 | 1975033 | 2021-12-02 | Clarendon | South Carolina | 45027 | 5194 | 136 |
1971784 | 1971784 | 2021-12-01 | Clarendon | South Carolina | 45027 | 5188 | 136 |
1968534 | 1968534 | 2021-11-30 | Clarendon | South Carolina | 45027 | 5185 | 136 |
1965283 | 1965283 | 2021-11-29 | Clarendon | South Carolina | 45027 | 5184 | 136 |
1962031 | 1962031 | 2021-11-28 | Clarendon | South Carolina | 45027 | 5168 | 136 |
1958780 | 1958780 | 2021-11-27 | Clarendon | South Carolina | 45027 | 5168 | 136 |
1955529 | 1955529 | 2021-11-26 | Clarendon | South Carolina | 45027 | 5168 | 136 |
1952278 | 1952278 | 2021-11-25 | Clarendon | South Carolina | 45027 | 5167 | 136 |
1949027 | 1949027 | 2021-11-24 | Clarendon | South Carolina | 45027 | 5167 | 136 |
1945776 | 1945776 | 2021-11-23 | Clarendon | South Carolina | 45027 | 5165 | 136 |
1942525 | 1942525 | 2021-11-22 | Clarendon | South Carolina | 45027 | 5165 | 136 |
1939275 | 1939275 | 2021-11-21 | Clarendon | South Carolina | 45027 | 5150 | 136 |
1936025 | 1936025 | 2021-11-20 | Clarendon | South Carolina | 45027 | 5150 | 136 |
1932775 | 1932775 | 2021-11-19 | Clarendon | South Carolina | 45027 | 5150 | 136 |
1929524 | 1929524 | 2021-11-18 | Clarendon | South Carolina | 45027 | 5148 | 136 |
1926274 | 1926274 | 2021-11-17 | Clarendon | South Carolina | 45027 | 5141 | 136 |
1923024 | 1923024 | 2021-11-16 | Clarendon | South Carolina | 45027 | 5142 | 136 |
1919775 | 1919775 | 2021-11-15 | Clarendon | South Carolina | 45027 | 5142 | 136 |
1916525 | 1916525 | 2021-11-14 | Clarendon | South Carolina | 45027 | 5140 | 136 |
1913275 | 1913275 | 2021-11-13 | Clarendon | South Carolina | 45027 | 5140 | 136 |
1910025 | 1910025 | 2021-11-12 | Clarendon | South Carolina | 45027 | 5140 | 136 |
1906776 | 1906776 | 2021-11-11 | Clarendon | South Carolina | 45027 | 5141 | 136 |
1903527 | 1903527 | 2021-11-10 | Clarendon | South Carolina | 45027 | 5141 | 136 |
1900277 | 1900277 | 2021-11-09 | Clarendon | South Carolina | 45027 | 5135 | 136 |
1897027 | 1897027 | 2021-11-08 | Clarendon | South Carolina | 45027 | 5133 | 136 |
1893777 | 1893777 | 2021-11-07 | Clarendon | South Carolina | 45027 | 5115 | 136 |
1890527 | 1890527 | 2021-11-06 | Clarendon | South Carolina | 45027 | 5115 | 136 |
1887277 | 1887277 | 2021-11-05 | Clarendon | South Carolina | 45027 | 5115 | 136 |
1884027 | 1884027 | 2021-11-04 | Clarendon | South Carolina | 45027 | 5109 | 136 |
1880778 | 1880778 | 2021-11-03 | Clarendon | South Carolina | 45027 | 5104 | 136 |
1877529 | 1877529 | 2021-11-02 | Clarendon | South Carolina | 45027 | 5102 | 136 |
1874280 | 1874280 | 2021-11-01 | Clarendon | South Carolina | 45027 | 5099 | 136 |
1871031 | 1871031 | 2021-10-31 | Clarendon | South Carolina | 45027 | 5081 | 136 |
1867782 | 1867782 | 2021-10-30 | Clarendon | South Carolina | 45027 | 5081 | 136 |
1864533 | 1864533 | 2021-10-29 | Clarendon | South Carolina | 45027 | 5081 | 136 |
1861284 | 1861284 | 2021-10-28 | Clarendon | South Carolina | 45027 | 5078 | 136 |
1858035 | 1858035 | 2021-10-27 | Clarendon | South Carolina | 45027 | 5075 | 136 |
1854786 | 1854786 | 2021-10-26 | Clarendon | South Carolina | 45027 | 5064 | 136 |
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);