ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Spalding" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174711 | 2174711 | 2022-02-02 | Spalding | Georgia | 13255 | 15337 | 364 |
2171458 | 2171458 | 2022-02-01 | Spalding | Georgia | 13255 | 15294 | 363 |
2168205 | 2168205 | 2022-01-31 | Spalding | Georgia | 13255 | 15243 | 363 |
2164950 | 2164950 | 2022-01-30 | Spalding | Georgia | 13255 | 15115 | 359 |
2161695 | 2161695 | 2022-01-29 | Spalding | Georgia | 13255 | 15115 | 359 |
2158439 | 2158439 | 2022-01-28 | Spalding | Georgia | 13255 | 15115 | 359 |
2155186 | 2155186 | 2022-01-27 | Spalding | Georgia | 13255 | 15038 | 358 |
2151933 | 2151933 | 2022-01-26 | Spalding | Georgia | 13255 | 14962 | 354 |
2148681 | 2148681 | 2022-01-25 | Spalding | Georgia | 13255 | 14876 | 354 |
2145429 | 2145429 | 2022-01-24 | Spalding | Georgia | 13255 | 14787 | 353 |
2142174 | 2142174 | 2022-01-23 | Spalding | Georgia | 13255 | 14627 | 353 |
2138919 | 2138919 | 2022-01-22 | Spalding | Georgia | 13255 | 14627 | 353 |
2135663 | 2135663 | 2022-01-21 | Spalding | Georgia | 13255 | 14627 | 353 |
2132411 | 2132411 | 2022-01-20 | Spalding | Georgia | 13255 | 14531 | 352 |
2129158 | 2129158 | 2022-01-19 | Spalding | Georgia | 13255 | 14452 | 350 |
2125904 | 2125904 | 2022-01-18 | Spalding | Georgia | 13255 | 14282 | 350 |
2122652 | 2122652 | 2022-01-17 | Spalding | Georgia | 13255 | 14247 | 349 |
2119400 | 2119400 | 2022-01-16 | Spalding | Georgia | 13255 | 14100 | 348 |
2116148 | 2116148 | 2022-01-15 | Spalding | Georgia | 13255 | 14100 | 348 |
2112897 | 2112897 | 2022-01-14 | Spalding | Georgia | 13255 | 14100 | 348 |
2109645 | 2109645 | 2022-01-13 | Spalding | Georgia | 13255 | 13991 | 347 |
2106394 | 2106394 | 2022-01-12 | Spalding | Georgia | 13255 | 13857 | 347 |
2103143 | 2103143 | 2022-01-11 | Spalding | Georgia | 13255 | 13732 | 344 |
2099892 | 2099892 | 2022-01-10 | Spalding | Georgia | 13255 | 13430 | 344 |
2096641 | 2096641 | 2022-01-09 | Spalding | Georgia | 13255 | 12775 | 341 |
2093389 | 2093389 | 2022-01-08 | Spalding | Georgia | 13255 | 12775 | 341 |
2090137 | 2090137 | 2022-01-07 | Spalding | Georgia | 13255 | 12775 | 341 |
2086886 | 2086886 | 2022-01-06 | Spalding | Georgia | 13255 | 12775 | 341 |
2083634 | 2083634 | 2022-01-05 | Spalding | Georgia | 13255 | 12775 | 341 |
2080382 | 2080382 | 2022-01-04 | Spalding | Georgia | 13255 | 12616 | 341 |
2077130 | 2077130 | 2022-01-03 | Spalding | Georgia | 13255 | 12044 | 341 |
2073879 | 2073879 | 2022-01-02 | Spalding | Georgia | 13255 | 12044 | 341 |
2070628 | 2070628 | 2022-01-01 | Spalding | Georgia | 13255 | 12044 | 341 |
2067377 | 2067377 | 2021-12-31 | Spalding | Georgia | 13255 | 12044 | 341 |
2064126 | 2064126 | 2021-12-30 | Spalding | Georgia | 13255 | 11836 | 341 |
2060876 | 2060876 | 2021-12-29 | Spalding | Georgia | 13255 | 11534 | 339 |
2057627 | 2057627 | 2021-12-28 | Spalding | Georgia | 13255 | 11373 | 339 |
2054378 | 2054378 | 2021-12-27 | Spalding | Georgia | 13255 | 11286 | 338 |
2051128 | 2051128 | 2021-12-26 | Spalding | Georgia | 13255 | 11104 | 338 |
2047878 | 2047878 | 2021-12-25 | Spalding | Georgia | 13255 | 11104 | 338 |
2044628 | 2044628 | 2021-12-24 | Spalding | Georgia | 13255 | 11104 | 338 |
2041379 | 2041379 | 2021-12-23 | Spalding | Georgia | 13255 | 11021 | 338 |
2038129 | 2038129 | 2021-12-22 | Spalding | Georgia | 13255 | 10953 | 337 |
2034879 | 2034879 | 2021-12-21 | Spalding | Georgia | 13255 | 10904 | 335 |
2031629 | 2031629 | 2021-12-20 | Spalding | Georgia | 13255 | 10835 | 335 |
2028378 | 2028378 | 2021-12-19 | Spalding | Georgia | 13255 | 10778 | 332 |
2025127 | 2025127 | 2021-12-18 | Spalding | Georgia | 13255 | 10778 | 332 |
2021876 | 2021876 | 2021-12-17 | Spalding | Georgia | 13255 | 10778 | 332 |
2018625 | 2018625 | 2021-12-16 | Spalding | Georgia | 13255 | 10771 | 331 |
2015375 | 2015375 | 2021-12-15 | Spalding | Georgia | 13255 | 10761 | 331 |
2012124 | 2012124 | 2021-12-14 | Spalding | Georgia | 13255 | 10741 | 331 |
2008873 | 2008873 | 2021-12-13 | Spalding | Georgia | 13255 | 10724 | 331 |
2005622 | 2005622 | 2021-12-12 | Spalding | Georgia | 13255 | 10707 | 331 |
2002371 | 2002371 | 2021-12-11 | Spalding | Georgia | 13255 | 10707 | 331 |
1999121 | 1999121 | 2021-12-10 | Spalding | Georgia | 13255 | 10707 | 331 |
1995870 | 1995870 | 2021-12-09 | Spalding | Georgia | 13255 | 10697 | 331 |
1992619 | 1992619 | 2021-12-08 | Spalding | Georgia | 13255 | 10690 | 330 |
1989368 | 1989368 | 2021-12-07 | Spalding | Georgia | 13255 | 10669 | 328 |
1986118 | 1986118 | 2021-12-06 | Spalding | Georgia | 13255 | 10665 | 328 |
1982868 | 1982868 | 2021-12-05 | Spalding | Georgia | 13255 | 10641 | 328 |
1979618 | 1979618 | 2021-12-04 | Spalding | Georgia | 13255 | 10641 | 328 |
1976368 | 1976368 | 2021-12-03 | Spalding | Georgia | 13255 | 10641 | 328 |
1973119 | 1973119 | 2021-12-02 | Spalding | Georgia | 13255 | 10634 | 327 |
1969869 | 1969869 | 2021-12-01 | Spalding | Georgia | 13255 | 10614 | 325 |
1966619 | 1966619 | 2021-11-30 | Spalding | Georgia | 13255 | 10592 | 325 |
1963367 | 1963367 | 2021-11-29 | Spalding | Georgia | 13255 | 10582 | 325 |
1960116 | 1960116 | 2021-11-28 | Spalding | Georgia | 13255 | 10550 | 324 |
1956865 | 1956865 | 2021-11-27 | Spalding | Georgia | 13255 | 10550 | 324 |
1953614 | 1953614 | 2021-11-26 | Spalding | Georgia | 13255 | 10550 | 324 |
1950363 | 1950363 | 2021-11-25 | Spalding | Georgia | 13255 | 10550 | 324 |
1947112 | 1947112 | 2021-11-24 | Spalding | Georgia | 13255 | 10550 | 324 |
1943861 | 1943861 | 2021-11-23 | Spalding | Georgia | 13255 | 10539 | 324 |
1940611 | 1940611 | 2021-11-22 | Spalding | Georgia | 13255 | 10526 | 324 |
1937361 | 1937361 | 2021-11-21 | Spalding | Georgia | 13255 | 10503 | 322 |
1934111 | 1934111 | 2021-11-20 | Spalding | Georgia | 13255 | 10503 | 322 |
1930859 | 1930859 | 2021-11-19 | Spalding | Georgia | 13255 | 10503 | 322 |
1927609 | 1927609 | 2021-11-18 | Spalding | Georgia | 13255 | 10499 | 320 |
1924359 | 1924359 | 2021-11-17 | Spalding | Georgia | 13255 | 10492 | 320 |
1921110 | 1921110 | 2021-11-16 | Spalding | Georgia | 13255 | 10490 | 319 |
1917860 | 1917860 | 2021-11-15 | Spalding | Georgia | 13255 | 10483 | 318 |
1914610 | 1914610 | 2021-11-14 | Spalding | Georgia | 13255 | 10466 | 318 |
1911360 | 1911360 | 2021-11-13 | Spalding | Georgia | 13255 | 10466 | 318 |
1908111 | 1908111 | 2021-11-12 | Spalding | Georgia | 13255 | 10466 | 318 |
1904862 | 1904862 | 2021-11-11 | Spalding | Georgia | 13255 | 10449 | 316 |
1901612 | 1901612 | 2021-11-10 | Spalding | Georgia | 13255 | 10449 | 316 |
1898362 | 1898362 | 2021-11-09 | Spalding | Georgia | 13255 | 10431 | 315 |
1895112 | 1895112 | 2021-11-08 | Spalding | Georgia | 13255 | 10389 | 315 |
1891862 | 1891862 | 2021-11-07 | Spalding | Georgia | 13255 | 10388 | 315 |
1888612 | 1888612 | 2021-11-06 | Spalding | Georgia | 13255 | 10388 | 315 |
1885362 | 1885362 | 2021-11-05 | Spalding | Georgia | 13255 | 10388 | 315 |
1882113 | 1882113 | 2021-11-04 | Spalding | Georgia | 13255 | 10386 | 313 |
1878864 | 1878864 | 2021-11-03 | Spalding | Georgia | 13255 | 10377 | 312 |
1875615 | 1875615 | 2021-11-02 | Spalding | Georgia | 13255 | 10363 | 309 |
1872366 | 1872366 | 2021-11-01 | Spalding | Georgia | 13255 | 10356 | 309 |
1869117 | 1869117 | 2021-10-31 | Spalding | Georgia | 13255 | 10339 | 306 |
1865868 | 1865868 | 2021-10-30 | Spalding | Georgia | 13255 | 10339 | 306 |
1862619 | 1862619 | 2021-10-29 | Spalding | Georgia | 13255 | 10339 | 306 |
1859370 | 1859370 | 2021-10-28 | Spalding | Georgia | 13255 | 10334 | 299 |
1856121 | 1856121 | 2021-10-27 | Spalding | Georgia | 13255 | 10317 | 299 |
1852872 | 1852872 | 2021-10-26 | Spalding | Georgia | 13255 | 10309 | 298 |
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);