ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Charlton" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174609 | 2174609 | 2022-02-02 | Charlton | Georgia | 13049 | 2737 | 58 |
2171356 | 2171356 | 2022-02-01 | Charlton | Georgia | 13049 | 2734 | 58 |
2168103 | 2168103 | 2022-01-31 | Charlton | Georgia | 13049 | 2726 | 58 |
2164848 | 2164848 | 2022-01-30 | Charlton | Georgia | 13049 | 2698 | 58 |
2161593 | 2161593 | 2022-01-29 | Charlton | Georgia | 13049 | 2698 | 58 |
2158337 | 2158337 | 2022-01-28 | Charlton | Georgia | 13049 | 2698 | 58 |
2155084 | 2155084 | 2022-01-27 | Charlton | Georgia | 13049 | 2677 | 58 |
2151831 | 2151831 | 2022-01-26 | Charlton | Georgia | 13049 | 2658 | 58 |
2148579 | 2148579 | 2022-01-25 | Charlton | Georgia | 13049 | 2646 | 58 |
2145327 | 2145327 | 2022-01-24 | Charlton | Georgia | 13049 | 2637 | 58 |
2142072 | 2142072 | 2022-01-23 | Charlton | Georgia | 13049 | 2586 | 58 |
2138817 | 2138817 | 2022-01-22 | Charlton | Georgia | 13049 | 2586 | 58 |
2135561 | 2135561 | 2022-01-21 | Charlton | Georgia | 13049 | 2586 | 58 |
2132309 | 2132309 | 2022-01-20 | Charlton | Georgia | 13049 | 2556 | 58 |
2129056 | 2129056 | 2022-01-19 | Charlton | Georgia | 13049 | 2535 | 58 |
2125802 | 2125802 | 2022-01-18 | Charlton | Georgia | 13049 | 2508 | 58 |
2122550 | 2122550 | 2022-01-17 | Charlton | Georgia | 13049 | 2503 | 58 |
2119298 | 2119298 | 2022-01-16 | Charlton | Georgia | 13049 | 2477 | 58 |
2116046 | 2116046 | 2022-01-15 | Charlton | Georgia | 13049 | 2477 | 58 |
2112795 | 2112795 | 2022-01-14 | Charlton | Georgia | 13049 | 2477 | 58 |
2109543 | 2109543 | 2022-01-13 | Charlton | Georgia | 13049 | 2464 | 58 |
2106292 | 2106292 | 2022-01-12 | Charlton | Georgia | 13049 | 2458 | 58 |
2103041 | 2103041 | 2022-01-11 | Charlton | Georgia | 13049 | 2449 | 58 |
2099790 | 2099790 | 2022-01-10 | Charlton | Georgia | 13049 | 2430 | 58 |
2096539 | 2096539 | 2022-01-09 | Charlton | Georgia | 13049 | 2382 | 58 |
2093287 | 2093287 | 2022-01-08 | Charlton | Georgia | 13049 | 2382 | 58 |
2090035 | 2090035 | 2022-01-07 | Charlton | Georgia | 13049 | 2382 | 58 |
2086784 | 2086784 | 2022-01-06 | Charlton | Georgia | 13049 | 2382 | 58 |
2083532 | 2083532 | 2022-01-05 | Charlton | Georgia | 13049 | 2382 | 58 |
2080280 | 2080280 | 2022-01-04 | Charlton | Georgia | 13049 | 2372 | 58 |
2077028 | 2077028 | 2022-01-03 | Charlton | Georgia | 13049 | 2350 | 58 |
2073777 | 2073777 | 2022-01-02 | Charlton | Georgia | 13049 | 2350 | 58 |
2070526 | 2070526 | 2022-01-01 | Charlton | Georgia | 13049 | 2350 | 58 |
2067275 | 2067275 | 2021-12-31 | Charlton | Georgia | 13049 | 2350 | 58 |
2064024 | 2064024 | 2021-12-30 | Charlton | Georgia | 13049 | 2343 | 58 |
2060774 | 2060774 | 2021-12-29 | Charlton | Georgia | 13049 | 2339 | 58 |
2057525 | 2057525 | 2021-12-28 | Charlton | Georgia | 13049 | 2334 | 58 |
2054276 | 2054276 | 2021-12-27 | Charlton | Georgia | 13049 | 2333 | 58 |
2051026 | 2051026 | 2021-12-26 | Charlton | Georgia | 13049 | 2333 | 58 |
2047776 | 2047776 | 2021-12-25 | Charlton | Georgia | 13049 | 2333 | 58 |
2044526 | 2044526 | 2021-12-24 | Charlton | Georgia | 13049 | 2333 | 58 |
2041277 | 2041277 | 2021-12-23 | Charlton | Georgia | 13049 | 2332 | 57 |
2038027 | 2038027 | 2021-12-22 | Charlton | Georgia | 13049 | 2333 | 57 |
2034777 | 2034777 | 2021-12-21 | Charlton | Georgia | 13049 | 2330 | 57 |
2031527 | 2031527 | 2021-12-20 | Charlton | Georgia | 13049 | 2330 | 57 |
2028276 | 2028276 | 2021-12-19 | Charlton | Georgia | 13049 | 2329 | 57 |
2025025 | 2025025 | 2021-12-18 | Charlton | Georgia | 13049 | 2329 | 57 |
2021774 | 2021774 | 2021-12-17 | Charlton | Georgia | 13049 | 2329 | 57 |
2018523 | 2018523 | 2021-12-16 | Charlton | Georgia | 13049 | 2329 | 57 |
2015273 | 2015273 | 2021-12-15 | Charlton | Georgia | 13049 | 2329 | 57 |
2012022 | 2012022 | 2021-12-14 | Charlton | Georgia | 13049 | 2327 | 56 |
2008771 | 2008771 | 2021-12-13 | Charlton | Georgia | 13049 | 2325 | 56 |
2005520 | 2005520 | 2021-12-12 | Charlton | Georgia | 13049 | 2325 | 56 |
2002269 | 2002269 | 2021-12-11 | Charlton | Georgia | 13049 | 2325 | 56 |
1999019 | 1999019 | 2021-12-10 | Charlton | Georgia | 13049 | 2325 | 56 |
1995768 | 1995768 | 2021-12-09 | Charlton | Georgia | 13049 | 2324 | 56 |
1992517 | 1992517 | 2021-12-08 | Charlton | Georgia | 13049 | 2324 | 56 |
1989266 | 1989266 | 2021-12-07 | Charlton | Georgia | 13049 | 2322 | 56 |
1986016 | 1986016 | 2021-12-06 | Charlton | Georgia | 13049 | 2322 | 56 |
1982766 | 1982766 | 2021-12-05 | Charlton | Georgia | 13049 | 2321 | 56 |
1979516 | 1979516 | 2021-12-04 | Charlton | Georgia | 13049 | 2321 | 56 |
1976266 | 1976266 | 2021-12-03 | Charlton | Georgia | 13049 | 2321 | 56 |
1973017 | 1973017 | 2021-12-02 | Charlton | Georgia | 13049 | 2319 | 56 |
1969767 | 1969767 | 2021-12-01 | Charlton | Georgia | 13049 | 2317 | 56 |
1966517 | 1966517 | 2021-11-30 | Charlton | Georgia | 13049 | 2317 | 56 |
1963265 | 1963265 | 2021-11-29 | Charlton | Georgia | 13049 | 2317 | 56 |
1960014 | 1960014 | 2021-11-28 | Charlton | Georgia | 13049 | 2316 | 56 |
1956763 | 1956763 | 2021-11-27 | Charlton | Georgia | 13049 | 2316 | 56 |
1953512 | 1953512 | 2021-11-26 | Charlton | Georgia | 13049 | 2316 | 56 |
1950261 | 1950261 | 2021-11-25 | Charlton | Georgia | 13049 | 2316 | 56 |
1947010 | 1947010 | 2021-11-24 | Charlton | Georgia | 13049 | 2316 | 56 |
1943759 | 1943759 | 2021-11-23 | Charlton | Georgia | 13049 | 2316 | 56 |
1940509 | 1940509 | 2021-11-22 | Charlton | Georgia | 13049 | 2312 | 56 |
1937259 | 1937259 | 2021-11-21 | Charlton | Georgia | 13049 | 2312 | 56 |
1934009 | 1934009 | 2021-11-20 | Charlton | Georgia | 13049 | 2312 | 56 |
1930757 | 1930757 | 2021-11-19 | Charlton | Georgia | 13049 | 2312 | 56 |
1927507 | 1927507 | 2021-11-18 | Charlton | Georgia | 13049 | 2312 | 56 |
1924257 | 1924257 | 2021-11-17 | Charlton | Georgia | 13049 | 2311 | 56 |
1921008 | 1921008 | 2021-11-16 | Charlton | Georgia | 13049 | 2311 | 56 |
1917758 | 1917758 | 2021-11-15 | Charlton | Georgia | 13049 | 2312 | 56 |
1914508 | 1914508 | 2021-11-14 | Charlton | Georgia | 13049 | 2312 | 55 |
1911258 | 1911258 | 2021-11-13 | Charlton | Georgia | 13049 | 2312 | 55 |
1908009 | 1908009 | 2021-11-12 | Charlton | Georgia | 13049 | 2312 | 55 |
1904760 | 1904760 | 2021-11-11 | Charlton | Georgia | 13049 | 2309 | 55 |
1901510 | 1901510 | 2021-11-10 | Charlton | Georgia | 13049 | 2309 | 55 |
1898260 | 1898260 | 2021-11-09 | Charlton | Georgia | 13049 | 2310 | 55 |
1895010 | 1895010 | 2021-11-08 | Charlton | Georgia | 13049 | 2309 | 55 |
1891760 | 1891760 | 2021-11-07 | Charlton | Georgia | 13049 | 2307 | 55 |
1888510 | 1888510 | 2021-11-06 | Charlton | Georgia | 13049 | 2307 | 55 |
1885260 | 1885260 | 2021-11-05 | Charlton | Georgia | 13049 | 2307 | 55 |
1882011 | 1882011 | 2021-11-04 | Charlton | Georgia | 13049 | 2305 | 55 |
1878762 | 1878762 | 2021-11-03 | Charlton | Georgia | 13049 | 2305 | 55 |
1875513 | 1875513 | 2021-11-02 | Charlton | Georgia | 13049 | 2303 | 55 |
1872264 | 1872264 | 2021-11-01 | Charlton | Georgia | 13049 | 2303 | 55 |
1869015 | 1869015 | 2021-10-31 | Charlton | Georgia | 13049 | 2299 | 55 |
1865766 | 1865766 | 2021-10-30 | Charlton | Georgia | 13049 | 2299 | 55 |
1862517 | 1862517 | 2021-10-29 | Charlton | Georgia | 13049 | 2299 | 55 |
1859268 | 1859268 | 2021-10-28 | Charlton | Georgia | 13049 | 2296 | 55 |
1856019 | 1856019 | 2021-10-27 | Charlton | Georgia | 13049 | 2293 | 55 |
1852770 | 1852770 | 2021-10-26 | Charlton | Georgia | 13049 | 2292 | 54 |
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);