ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 45053 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 |
---|---|---|---|---|---|---|---|
2176641 | 2176641 | 2022-02-02 | Jasper | South Carolina | 45053 | 5637 | 86 |
2173387 | 2173387 | 2022-02-01 | Jasper | South Carolina | 45053 | 5627 | 84 |
2170135 | 2170135 | 2022-01-31 | Jasper | South Carolina | 45053 | 5618 | 84 |
2166881 | 2166881 | 2022-01-30 | Jasper | South Carolina | 45053 | 5472 | 83 |
2163626 | 2163626 | 2022-01-29 | Jasper | South Carolina | 45053 | 5472 | 83 |
2160371 | 2160371 | 2022-01-28 | Jasper | South Carolina | 45053 | 5472 | 83 |
2157115 | 2157115 | 2022-01-27 | Jasper | South Carolina | 45053 | 5428 | 83 |
2153862 | 2153862 | 2022-01-26 | Jasper | South Carolina | 45053 | 5399 | 83 |
2150610 | 2150610 | 2022-01-25 | Jasper | South Carolina | 45053 | 5202 | 83 |
2147358 | 2147358 | 2022-01-24 | Jasper | South Carolina | 45053 | 5202 | 83 |
2144104 | 2144104 | 2022-01-23 | Jasper | South Carolina | 45053 | 5202 | 83 |
2140849 | 2140849 | 2022-01-22 | Jasper | South Carolina | 45053 | 5202 | 83 |
2137593 | 2137593 | 2022-01-21 | Jasper | South Carolina | 45053 | 5202 | 83 |
2134339 | 2134339 | 2022-01-20 | Jasper | South Carolina | 45053 | 5139 | 82 |
2131087 | 2131087 | 2022-01-19 | Jasper | South Carolina | 45053 | 5115 | 82 |
2127833 | 2127833 | 2022-01-18 | Jasper | South Carolina | 45053 | 5070 | 82 |
2124581 | 2124581 | 2022-01-17 | Jasper | South Carolina | 45053 | 4746 | 82 |
2121329 | 2121329 | 2022-01-16 | Jasper | South Carolina | 45053 | 4746 | 82 |
2118077 | 2118077 | 2022-01-15 | Jasper | South Carolina | 45053 | 4746 | 82 |
2114826 | 2114826 | 2022-01-14 | Jasper | South Carolina | 45053 | 4746 | 82 |
2111574 | 2111574 | 2022-01-13 | Jasper | South Carolina | 45053 | 4670 | 82 |
2108322 | 2108322 | 2022-01-12 | Jasper | South Carolina | 45053 | 4623 | 82 |
2105071 | 2105071 | 2022-01-11 | Jasper | South Carolina | 45053 | 4581 | 82 |
2101820 | 2101820 | 2022-01-10 | Jasper | South Carolina | 45053 | 4532 | 82 |
2098569 | 2098569 | 2022-01-09 | Jasper | South Carolina | 45053 | 4347 | 82 |
2095317 | 2095317 | 2022-01-08 | Jasper | South Carolina | 45053 | 4347 | 82 |
2092065 | 2092065 | 2022-01-07 | Jasper | South Carolina | 45053 | 4347 | 82 |
2088813 | 2088813 | 2022-01-06 | Jasper | South Carolina | 45053 | 4322 | 82 |
2085562 | 2085562 | 2022-01-05 | Jasper | South Carolina | 45053 | 4275 | 82 |
2082310 | 2082310 | 2022-01-04 | Jasper | South Carolina | 45053 | 4259 | 82 |
2079058 | 2079058 | 2022-01-03 | Jasper | South Carolina | 45053 | 4135 | 82 |
2075807 | 2075807 | 2022-01-02 | Jasper | South Carolina | 45053 | 4135 | 82 |
2072556 | 2072556 | 2022-01-01 | Jasper | South Carolina | 45053 | 4135 | 82 |
2069305 | 2069305 | 2021-12-31 | Jasper | South Carolina | 45053 | 4135 | 82 |
2066054 | 2066054 | 2021-12-30 | Jasper | South Carolina | 45053 | 4098 | 82 |
2062804 | 2062804 | 2021-12-29 | Jasper | South Carolina | 45053 | 4087 | 82 |
2059554 | 2059554 | 2021-12-28 | Jasper | South Carolina | 45053 | 4056 | 82 |
2056305 | 2056305 | 2021-12-27 | Jasper | South Carolina | 45053 | 4056 | 82 |
2053056 | 2053056 | 2021-12-26 | Jasper | South Carolina | 45053 | 4056 | 82 |
2049806 | 2049806 | 2021-12-25 | Jasper | South Carolina | 45053 | 4056 | 82 |
2046556 | 2046556 | 2021-12-24 | Jasper | South Carolina | 45053 | 4056 | 82 |
2043306 | 2043306 | 2021-12-23 | Jasper | South Carolina | 45053 | 4056 | 82 |
2040057 | 2040057 | 2021-12-22 | Jasper | South Carolina | 45053 | 4055 | 82 |
2036807 | 2036807 | 2021-12-21 | Jasper | South Carolina | 45053 | 4052 | 82 |
2033557 | 2033557 | 2021-12-20 | Jasper | South Carolina | 45053 | 4052 | 82 |
2030307 | 2030307 | 2021-12-19 | Jasper | South Carolina | 45053 | 4041 | 82 |
2027056 | 2027056 | 2021-12-18 | Jasper | South Carolina | 45053 | 4041 | 82 |
2023805 | 2023805 | 2021-12-17 | Jasper | South Carolina | 45053 | 4041 | 82 |
2020554 | 2020554 | 2021-12-16 | Jasper | South Carolina | 45053 | 4038 | 82 |
2017303 | 2017303 | 2021-12-15 | Jasper | South Carolina | 45053 | 4028 | 82 |
2014053 | 2014053 | 2021-12-14 | Jasper | South Carolina | 45053 | 4026 | 82 |
2010802 | 2010802 | 2021-12-13 | Jasper | South Carolina | 45053 | 4024 | 82 |
2007551 | 2007551 | 2021-12-12 | Jasper | South Carolina | 45053 | 4019 | 82 |
2004300 | 2004300 | 2021-12-11 | Jasper | South Carolina | 45053 | 4019 | 82 |
2001049 | 2001049 | 2021-12-10 | Jasper | South Carolina | 45053 | 4019 | 82 |
1997799 | 1997799 | 2021-12-09 | Jasper | South Carolina | 45053 | 4013 | 82 |
1994548 | 1994548 | 2021-12-08 | Jasper | South Carolina | 45053 | 4009 | 82 |
1991297 | 1991297 | 2021-12-07 | Jasper | South Carolina | 45053 | 4005 | 82 |
1988046 | 1988046 | 2021-12-06 | Jasper | South Carolina | 45053 | 4003 | 82 |
1984796 | 1984796 | 2021-12-05 | Jasper | South Carolina | 45053 | 3992 | 82 |
1981546 | 1981546 | 2021-12-04 | Jasper | South Carolina | 45053 | 3992 | 82 |
1978296 | 1978296 | 2021-12-03 | Jasper | South Carolina | 45053 | 3992 | 82 |
1975046 | 1975046 | 2021-12-02 | Jasper | South Carolina | 45053 | 3990 | 82 |
1971797 | 1971797 | 2021-12-01 | Jasper | South Carolina | 45053 | 3988 | 82 |
1968547 | 1968547 | 2021-11-30 | Jasper | South Carolina | 45053 | 3981 | 82 |
1965296 | 1965296 | 2021-11-29 | Jasper | South Carolina | 45053 | 3981 | 82 |
1962044 | 1962044 | 2021-11-28 | Jasper | South Carolina | 45053 | 3981 | 82 |
1958793 | 1958793 | 2021-11-27 | Jasper | South Carolina | 45053 | 3981 | 82 |
1955542 | 1955542 | 2021-11-26 | Jasper | South Carolina | 45053 | 3981 | 82 |
1952291 | 1952291 | 2021-11-25 | Jasper | South Carolina | 45053 | 3979 | 82 |
1949040 | 1949040 | 2021-11-24 | Jasper | South Carolina | 45053 | 3979 | 82 |
1945789 | 1945789 | 2021-11-23 | Jasper | South Carolina | 45053 | 3977 | 82 |
1942538 | 1942538 | 2021-11-22 | Jasper | South Carolina | 45053 | 3973 | 82 |
1939288 | 1939288 | 2021-11-21 | Jasper | South Carolina | 45053 | 3966 | 82 |
1936038 | 1936038 | 2021-11-20 | Jasper | South Carolina | 45053 | 3966 | 82 |
1932788 | 1932788 | 2021-11-19 | Jasper | South Carolina | 45053 | 3966 | 82 |
1929537 | 1929537 | 2021-11-18 | Jasper | South Carolina | 45053 | 3964 | 82 |
1926287 | 1926287 | 2021-11-17 | Jasper | South Carolina | 45053 | 3960 | 82 |
1923037 | 1923037 | 2021-11-16 | Jasper | South Carolina | 45053 | 3957 | 81 |
1919788 | 1919788 | 2021-11-15 | Jasper | South Carolina | 45053 | 3957 | 81 |
1916538 | 1916538 | 2021-11-14 | Jasper | South Carolina | 45053 | 3952 | 81 |
1913288 | 1913288 | 2021-11-13 | Jasper | South Carolina | 45053 | 3952 | 81 |
1910038 | 1910038 | 2021-11-12 | Jasper | South Carolina | 45053 | 3952 | 81 |
1906789 | 1906789 | 2021-11-11 | Jasper | South Carolina | 45053 | 3957 | 81 |
1903540 | 1903540 | 2021-11-10 | Jasper | South Carolina | 45053 | 3957 | 81 |
1900290 | 1900290 | 2021-11-09 | Jasper | South Carolina | 45053 | 3951 | 81 |
1897040 | 1897040 | 2021-11-08 | Jasper | South Carolina | 45053 | 3951 | 81 |
1893790 | 1893790 | 2021-11-07 | Jasper | South Carolina | 45053 | 3947 | 81 |
1890540 | 1890540 | 2021-11-06 | Jasper | South Carolina | 45053 | 3947 | 81 |
1887290 | 1887290 | 2021-11-05 | Jasper | South Carolina | 45053 | 3947 | 81 |
1884040 | 1884040 | 2021-11-04 | Jasper | South Carolina | 45053 | 3947 | 81 |
1880791 | 1880791 | 2021-11-03 | Jasper | South Carolina | 45053 | 3947 | 81 |
1877542 | 1877542 | 2021-11-02 | Jasper | South Carolina | 45053 | 3947 | 81 |
1874293 | 1874293 | 2021-11-01 | Jasper | South Carolina | 45053 | 3947 | 81 |
1871044 | 1871044 | 2021-10-31 | Jasper | South Carolina | 45053 | 3938 | 81 |
1867795 | 1867795 | 2021-10-30 | Jasper | South Carolina | 45053 | 3938 | 81 |
1864546 | 1864546 | 2021-10-29 | Jasper | South Carolina | 45053 | 3938 | 81 |
1861297 | 1861297 | 2021-10-28 | Jasper | South Carolina | 45053 | 3932 | 81 |
1858048 | 1858048 | 2021-10-27 | Jasper | South Carolina | 45053 | 3927 | 81 |
1854799 | 1854799 | 2021-10-26 | Jasper | South Carolina | 45053 | 3925 | 81 |
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);