ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 45003 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176616 | 2176616 | 2022-02-02 | Aiken | South Carolina | 45003 | 38893 | 391 |
2173362 | 2173362 | 2022-02-01 | Aiken | South Carolina | 45003 | 38724 | 388 |
2170110 | 2170110 | 2022-01-31 | Aiken | South Carolina | 45003 | 38604 | 388 |
2166856 | 2166856 | 2022-01-30 | Aiken | South Carolina | 45003 | 37880 | 383 |
2163601 | 2163601 | 2022-01-29 | Aiken | South Carolina | 45003 | 37880 | 383 |
2160346 | 2160346 | 2022-01-28 | Aiken | South Carolina | 45003 | 37880 | 383 |
2157090 | 2157090 | 2022-01-27 | Aiken | South Carolina | 45003 | 37406 | 380 |
2153837 | 2153837 | 2022-01-26 | Aiken | South Carolina | 45003 | 37197 | 379 |
2150585 | 2150585 | 2022-01-25 | Aiken | South Carolina | 45003 | 35642 | 378 |
2147333 | 2147333 | 2022-01-24 | Aiken | South Carolina | 45003 | 35642 | 378 |
2144079 | 2144079 | 2022-01-23 | Aiken | South Carolina | 45003 | 35642 | 378 |
2140824 | 2140824 | 2022-01-22 | Aiken | South Carolina | 45003 | 35642 | 378 |
2137568 | 2137568 | 2022-01-21 | Aiken | South Carolina | 45003 | 35642 | 378 |
2134314 | 2134314 | 2022-01-20 | Aiken | South Carolina | 45003 | 35165 | 375 |
2131062 | 2131062 | 2022-01-19 | Aiken | South Carolina | 45003 | 34737 | 375 |
2127808 | 2127808 | 2022-01-18 | Aiken | South Carolina | 45003 | 34396 | 374 |
2124556 | 2124556 | 2022-01-17 | Aiken | South Carolina | 45003 | 32748 | 373 |
2121304 | 2121304 | 2022-01-16 | Aiken | South Carolina | 45003 | 32748 | 373 |
2118052 | 2118052 | 2022-01-15 | Aiken | South Carolina | 45003 | 32748 | 373 |
2114801 | 2114801 | 2022-01-14 | Aiken | South Carolina | 45003 | 32748 | 373 |
2111549 | 2111549 | 2022-01-13 | Aiken | South Carolina | 45003 | 32331 | 372 |
2108297 | 2108297 | 2022-01-12 | Aiken | South Carolina | 45003 | 31914 | 372 |
2105046 | 2105046 | 2022-01-11 | Aiken | South Carolina | 45003 | 31667 | 371 |
2101795 | 2101795 | 2022-01-10 | Aiken | South Carolina | 45003 | 31479 | 371 |
2098544 | 2098544 | 2022-01-09 | Aiken | South Carolina | 45003 | 30463 | 369 |
2095292 | 2095292 | 2022-01-08 | Aiken | South Carolina | 45003 | 30463 | 369 |
2092040 | 2092040 | 2022-01-07 | Aiken | South Carolina | 45003 | 30463 | 369 |
2088788 | 2088788 | 2022-01-06 | Aiken | South Carolina | 45003 | 30238 | 369 |
2085537 | 2085537 | 2022-01-05 | Aiken | South Carolina | 45003 | 29947 | 369 |
2082285 | 2082285 | 2022-01-04 | Aiken | South Carolina | 45003 | 29731 | 368 |
2079033 | 2079033 | 2022-01-03 | Aiken | South Carolina | 45003 | 28969 | 368 |
2075782 | 2075782 | 2022-01-02 | Aiken | South Carolina | 45003 | 28969 | 368 |
2072531 | 2072531 | 2022-01-01 | Aiken | South Carolina | 45003 | 28969 | 368 |
2069280 | 2069280 | 2021-12-31 | Aiken | South Carolina | 45003 | 28969 | 368 |
2066029 | 2066029 | 2021-12-30 | Aiken | South Carolina | 45003 | 28698 | 368 |
2062779 | 2062779 | 2021-12-29 | Aiken | South Carolina | 45003 | 28531 | 367 |
2059529 | 2059529 | 2021-12-28 | Aiken | South Carolina | 45003 | 28150 | 364 |
2056280 | 2056280 | 2021-12-27 | Aiken | South Carolina | 45003 | 28150 | 364 |
2053031 | 2053031 | 2021-12-26 | Aiken | South Carolina | 45003 | 28150 | 364 |
2049781 | 2049781 | 2021-12-25 | Aiken | South Carolina | 45003 | 28150 | 364 |
2046531 | 2046531 | 2021-12-24 | Aiken | South Carolina | 45003 | 28150 | 364 |
2043281 | 2043281 | 2021-12-23 | Aiken | South Carolina | 45003 | 28150 | 364 |
2040032 | 2040032 | 2021-12-22 | Aiken | South Carolina | 45003 | 28106 | 364 |
2036782 | 2036782 | 2021-12-21 | Aiken | South Carolina | 45003 | 28058 | 361 |
2033532 | 2033532 | 2021-12-20 | Aiken | South Carolina | 45003 | 28052 | 361 |
2030282 | 2030282 | 2021-12-19 | Aiken | South Carolina | 45003 | 27953 | 360 |
2027031 | 2027031 | 2021-12-18 | Aiken | South Carolina | 45003 | 27953 | 360 |
2023780 | 2023780 | 2021-12-17 | Aiken | South Carolina | 45003 | 27953 | 360 |
2020529 | 2020529 | 2021-12-16 | Aiken | South Carolina | 45003 | 27892 | 360 |
2017278 | 2017278 | 2021-12-15 | Aiken | South Carolina | 45003 | 27850 | 359 |
2014028 | 2014028 | 2021-12-14 | Aiken | South Carolina | 45003 | 27828 | 358 |
2010777 | 2010777 | 2021-12-13 | Aiken | South Carolina | 45003 | 27818 | 357 |
2007526 | 2007526 | 2021-12-12 | Aiken | South Carolina | 45003 | 27772 | 356 |
2004275 | 2004275 | 2021-12-11 | Aiken | South Carolina | 45003 | 27772 | 356 |
2001024 | 2001024 | 2021-12-10 | Aiken | South Carolina | 45003 | 27772 | 356 |
1997774 | 1997774 | 2021-12-09 | Aiken | South Carolina | 45003 | 27740 | 356 |
1994523 | 1994523 | 2021-12-08 | Aiken | South Carolina | 45003 | 27726 | 356 |
1991272 | 1991272 | 2021-12-07 | Aiken | South Carolina | 45003 | 27705 | 356 |
1988021 | 1988021 | 2021-12-06 | Aiken | South Carolina | 45003 | 27703 | 356 |
1984771 | 1984771 | 2021-12-05 | Aiken | South Carolina | 45003 | 27639 | 356 |
1981521 | 1981521 | 2021-12-04 | Aiken | South Carolina | 45003 | 27639 | 356 |
1978271 | 1978271 | 2021-12-03 | Aiken | South Carolina | 45003 | 27639 | 356 |
1975021 | 1975021 | 2021-12-02 | Aiken | South Carolina | 45003 | 27617 | 356 |
1971772 | 1971772 | 2021-12-01 | Aiken | South Carolina | 45003 | 27590 | 356 |
1968522 | 1968522 | 2021-11-30 | Aiken | South Carolina | 45003 | 27550 | 356 |
1965271 | 1965271 | 2021-11-29 | Aiken | South Carolina | 45003 | 27534 | 356 |
1962019 | 1962019 | 2021-11-28 | Aiken | South Carolina | 45003 | 27477 | 356 |
1958768 | 1958768 | 2021-11-27 | Aiken | South Carolina | 45003 | 27477 | 356 |
1955517 | 1955517 | 2021-11-26 | Aiken | South Carolina | 45003 | 27477 | 356 |
1952266 | 1952266 | 2021-11-25 | Aiken | South Carolina | 45003 | 27437 | 355 |
1949015 | 1949015 | 2021-11-24 | Aiken | South Carolina | 45003 | 27437 | 355 |
1945764 | 1945764 | 2021-11-23 | Aiken | South Carolina | 45003 | 27396 | 355 |
1942513 | 1942513 | 2021-11-22 | Aiken | South Carolina | 45003 | 27385 | 355 |
1939263 | 1939263 | 2021-11-21 | Aiken | South Carolina | 45003 | 27307 | 354 |
1936013 | 1936013 | 2021-11-20 | Aiken | South Carolina | 45003 | 27307 | 354 |
1932763 | 1932763 | 2021-11-19 | Aiken | South Carolina | 45003 | 27307 | 354 |
1929512 | 1929512 | 2021-11-18 | Aiken | South Carolina | 45003 | 27288 | 354 |
1926262 | 1926262 | 2021-11-17 | Aiken | South Carolina | 45003 | 27276 | 354 |
1923012 | 1923012 | 2021-11-16 | Aiken | South Carolina | 45003 | 27240 | 352 |
1919763 | 1919763 | 2021-11-15 | Aiken | South Carolina | 45003 | 27234 | 352 |
1916513 | 1916513 | 2021-11-14 | Aiken | South Carolina | 45003 | 27178 | 349 |
1913263 | 1913263 | 2021-11-13 | Aiken | South Carolina | 45003 | 27178 | 349 |
1910013 | 1910013 | 2021-11-12 | Aiken | South Carolina | 45003 | 27178 | 349 |
1906764 | 1906764 | 2021-11-11 | Aiken | South Carolina | 45003 | 27136 | 348 |
1903515 | 1903515 | 2021-11-10 | Aiken | South Carolina | 45003 | 27136 | 348 |
1900265 | 1900265 | 2021-11-09 | Aiken | South Carolina | 45003 | 27094 | 347 |
1897015 | 1897015 | 2021-11-08 | Aiken | South Carolina | 45003 | 27090 | 347 |
1893765 | 1893765 | 2021-11-07 | Aiken | South Carolina | 45003 | 27048 | 347 |
1890515 | 1890515 | 2021-11-06 | Aiken | South Carolina | 45003 | 27048 | 347 |
1887265 | 1887265 | 2021-11-05 | Aiken | South Carolina | 45003 | 27048 | 347 |
1884015 | 1884015 | 2021-11-04 | Aiken | South Carolina | 45003 | 27025 | 347 |
1880766 | 1880766 | 2021-11-03 | Aiken | South Carolina | 45003 | 27009 | 347 |
1877517 | 1877517 | 2021-11-02 | Aiken | South Carolina | 45003 | 26990 | 345 |
1874268 | 1874268 | 2021-11-01 | Aiken | South Carolina | 45003 | 26978 | 345 |
1871019 | 1871019 | 2021-10-31 | Aiken | South Carolina | 45003 | 26928 | 343 |
1867770 | 1867770 | 2021-10-30 | Aiken | South Carolina | 45003 | 26928 | 343 |
1864521 | 1864521 | 2021-10-29 | Aiken | South Carolina | 45003 | 26928 | 343 |
1861272 | 1861272 | 2021-10-28 | Aiken | South Carolina | 45003 | 26880 | 339 |
1858023 | 1858023 | 2021-10-27 | Aiken | South Carolina | 45003 | 26867 | 336 |
1854774 | 1854774 | 2021-10-26 | Aiken | South Carolina | 45003 | 26856 | 336 |
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);