ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where deaths = 42 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Irwin 79
- Turner 63
- Clinch 46
- Jenkins 42
- Bryan 35
- Twiggs 28
- Heard 27
- Cook 25
- Taylor 24
- Appling 15
- Bartow 15
- Brantley 14
- Butts 13
- Union 13
- Berrien 12
- Carroll 12
- Dawson 11
- Randolph 11
- Atkinson 10
- Terrell 10
- Hancock 9
- Harris 9
- Montgomery 9
- Fannin 8
- Franklin 8
- Stephens 8
- Ben Hill 7
- Charlton 7
- Macon 7
- Morgan 7
- …
state 1
- Georgia · 787 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499997 | 2499997 | 2022-05-13 | Clinch | Georgia | 13065 | 2124 | 42 |
2496739 | 2496739 | 2022-05-12 | Clinch | Georgia | 13065 | 2124 | 42 |
2493481 | 2493481 | 2022-05-11 | Clinch | Georgia | 13065 | 2124 | 42 |
2490223 | 2490223 | 2022-05-10 | Clinch | Georgia | 13065 | 2122 | 42 |
2486966 | 2486966 | 2022-05-09 | Clinch | Georgia | 13065 | 2122 | 42 |
2483708 | 2483708 | 2022-05-08 | Clinch | Georgia | 13065 | 2122 | 42 |
2480450 | 2480450 | 2022-05-07 | Clinch | Georgia | 13065 | 2122 | 42 |
2477192 | 2477192 | 2022-05-06 | Clinch | Georgia | 13065 | 2122 | 42 |
2473934 | 2473934 | 2022-05-05 | Clinch | Georgia | 13065 | 2122 | 42 |
2470677 | 2470677 | 2022-05-04 | Clinch | Georgia | 13065 | 2122 | 42 |
2467421 | 2467421 | 2022-05-03 | Clinch | Georgia | 13065 | 2121 | 42 |
2464166 | 2464166 | 2022-05-02 | Clinch | Georgia | 13065 | 2121 | 42 |
2460910 | 2460910 | 2022-05-01 | Clinch | Georgia | 13065 | 2121 | 42 |
2457654 | 2457654 | 2022-04-30 | Clinch | Georgia | 13065 | 2121 | 42 |
2454398 | 2454398 | 2022-04-29 | Clinch | Georgia | 13065 | 2121 | 42 |
2451142 | 2451142 | 2022-04-28 | Clinch | Georgia | 13065 | 2121 | 42 |
2447886 | 2447886 | 2022-04-27 | Clinch | Georgia | 13065 | 2121 | 42 |
2444630 | 2444630 | 2022-04-26 | Clinch | Georgia | 13065 | 2120 | 42 |
2441374 | 2441374 | 2022-04-25 | Clinch | Georgia | 13065 | 2120 | 42 |
2438118 | 2438118 | 2022-04-24 | Clinch | Georgia | 13065 | 2120 | 42 |
2434862 | 2434862 | 2022-04-23 | Clinch | Georgia | 13065 | 2120 | 42 |
2431606 | 2431606 | 2022-04-22 | Clinch | Georgia | 13065 | 2120 | 42 |
2428350 | 2428350 | 2022-04-21 | Clinch | Georgia | 13065 | 2120 | 42 |
2425094 | 2425094 | 2022-04-20 | Clinch | Georgia | 13065 | 2120 | 42 |
2421838 | 2421838 | 2022-04-19 | Clinch | Georgia | 13065 | 2122 | 42 |
2418582 | 2418582 | 2022-04-18 | Clinch | Georgia | 13065 | 2122 | 42 |
2415326 | 2415326 | 2022-04-17 | Clinch | Georgia | 13065 | 2122 | 42 |
2412070 | 2412070 | 2022-04-16 | Clinch | Georgia | 13065 | 2122 | 42 |
2408814 | 2408814 | 2022-04-15 | Clinch | Georgia | 13065 | 2122 | 42 |
2405558 | 2405558 | 2022-04-14 | Clinch | Georgia | 13065 | 2122 | 42 |
2402303 | 2402303 | 2022-04-13 | Clinch | Georgia | 13065 | 2122 | 42 |
2399048 | 2399048 | 2022-04-12 | Clinch | Georgia | 13065 | 2122 | 42 |
2395793 | 2395793 | 2022-04-11 | Clinch | Georgia | 13065 | 2120 | 42 |
2392537 | 2392537 | 2022-04-10 | Clinch | Georgia | 13065 | 2120 | 42 |
2389281 | 2389281 | 2022-04-09 | Clinch | Georgia | 13065 | 2120 | 42 |
2386026 | 2386026 | 2022-04-08 | Clinch | Georgia | 13065 | 2120 | 42 |
2382771 | 2382771 | 2022-04-07 | Clinch | Georgia | 13065 | 2120 | 42 |
2379516 | 2379516 | 2022-04-06 | Clinch | Georgia | 13065 | 2120 | 42 |
2376262 | 2376262 | 2022-04-05 | Clinch | Georgia | 13065 | 2120 | 42 |
2373010 | 2373010 | 2022-04-04 | Clinch | Georgia | 13065 | 2120 | 42 |
2369757 | 2369757 | 2022-04-03 | Clinch | Georgia | 13065 | 2120 | 42 |
2366504 | 2366504 | 2022-04-02 | Clinch | Georgia | 13065 | 2120 | 42 |
2363251 | 2363251 | 2022-04-01 | Clinch | Georgia | 13065 | 2120 | 42 |
2359997 | 2359997 | 2022-03-31 | Clinch | Georgia | 13065 | 2120 | 42 |
2356743 | 2356743 | 2022-03-30 | Clinch | Georgia | 13065 | 2119 | 42 |
2353490 | 2353490 | 2022-03-29 | Clinch | Georgia | 13065 | 2119 | 42 |
2242881 | 2242881 | 2022-02-23 | Atkinson | Georgia | 13003 | 2074 | 42 |
2239630 | 2239630 | 2022-02-22 | Atkinson | Georgia | 13003 | 2070 | 42 |
2239705 | 2239705 | 2022-02-22 | Irwin | Georgia | 13155 | 1874 | 42 |
2236379 | 2236379 | 2022-02-21 | Atkinson | Georgia | 13003 | 2070 | 42 |
2236454 | 2236454 | 2022-02-21 | Irwin | Georgia | 13155 | 1868 | 42 |
2233128 | 2233128 | 2022-02-20 | Atkinson | Georgia | 13003 | 2067 | 42 |
2233203 | 2233203 | 2022-02-20 | Irwin | Georgia | 13155 | 1866 | 42 |
2229877 | 2229877 | 2022-02-19 | Atkinson | Georgia | 13003 | 2067 | 42 |
2229952 | 2229952 | 2022-02-19 | Irwin | Georgia | 13155 | 1866 | 42 |
2226626 | 2226626 | 2022-02-18 | Atkinson | Georgia | 13003 | 2067 | 42 |
2226701 | 2226701 | 2022-02-18 | Irwin | Georgia | 13155 | 1866 | 42 |
2223375 | 2223375 | 2022-02-17 | Atkinson | Georgia | 13003 | 2061 | 42 |
2223450 | 2223450 | 2022-02-17 | Irwin | Georgia | 13155 | 1865 | 42 |
2220124 | 2220124 | 2022-02-16 | Atkinson | Georgia | 13003 | 2044 | 42 |
2220199 | 2220199 | 2022-02-16 | Irwin | Georgia | 13155 | 1865 | 42 |
2216873 | 2216873 | 2022-02-15 | Atkinson | Georgia | 13003 | 2039 | 42 |
2216948 | 2216948 | 2022-02-15 | Irwin | Georgia | 13155 | 1859 | 42 |
2213622 | 2213622 | 2022-02-14 | Atkinson | Georgia | 13003 | 2035 | 42 |
2213697 | 2213697 | 2022-02-14 | Irwin | Georgia | 13155 | 1848 | 42 |
2210445 | 2210445 | 2022-02-13 | Irwin | Georgia | 13155 | 1848 | 42 |
2207192 | 2207192 | 2022-02-12 | Irwin | Georgia | 13155 | 1848 | 42 |
2203939 | 2203939 | 2022-02-11 | Irwin | Georgia | 13155 | 1848 | 42 |
2200686 | 2200686 | 2022-02-10 | Irwin | Georgia | 13155 | 1847 | 42 |
2197432 | 2197432 | 2022-02-09 | Irwin | Georgia | 13155 | 1846 | 42 |
2194178 | 2194178 | 2022-02-08 | Irwin | Georgia | 13155 | 1843 | 42 |
2190924 | 2190924 | 2022-02-07 | Irwin | Georgia | 13155 | 1839 | 42 |
2187671 | 2187671 | 2022-02-06 | Irwin | Georgia | 13155 | 1833 | 42 |
2184418 | 2184418 | 2022-02-05 | Irwin | Georgia | 13155 | 1833 | 42 |
2181166 | 2181166 | 2022-02-04 | Irwin | Georgia | 13155 | 1833 | 42 |
2177915 | 2177915 | 2022-02-03 | Irwin | Georgia | 13155 | 1831 | 42 |
2174662 | 2174662 | 2022-02-02 | Irwin | Georgia | 13155 | 1801 | 42 |
2171409 | 2171409 | 2022-02-01 | Irwin | Georgia | 13155 | 1787 | 42 |
2168156 | 2168156 | 2022-01-31 | Irwin | Georgia | 13155 | 1768 | 42 |
2164901 | 2164901 | 2022-01-30 | Irwin | Georgia | 13155 | 1754 | 42 |
2161646 | 2161646 | 2022-01-29 | Irwin | Georgia | 13155 | 1754 | 42 |
2158390 | 2158390 | 2022-01-28 | Irwin | Georgia | 13155 | 1754 | 42 |
2155137 | 2155137 | 2022-01-27 | Irwin | Georgia | 13155 | 1735 | 42 |
2151884 | 2151884 | 2022-01-26 | Irwin | Georgia | 13155 | 1729 | 42 |
2151965 | 2151965 | 2022-01-26 | Wilkes | Georgia | 13317 | 2004 | 42 |
2148632 | 2148632 | 2022-01-25 | Irwin | Georgia | 13155 | 1707 | 42 |
2148713 | 2148713 | 2022-01-25 | Wilkes | Georgia | 13317 | 1997 | 42 |
2145380 | 2145380 | 2022-01-24 | Irwin | Georgia | 13155 | 1701 | 42 |
2142125 | 2142125 | 2022-01-23 | Irwin | Georgia | 13155 | 1672 | 42 |
2138870 | 2138870 | 2022-01-22 | Irwin | Georgia | 13155 | 1672 | 42 |
2135614 | 2135614 | 2022-01-21 | Irwin | Georgia | 13155 | 1672 | 42 |
2132362 | 2132362 | 2022-01-20 | Irwin | Georgia | 13155 | 1667 | 42 |
2129109 | 2129109 | 2022-01-19 | Irwin | Georgia | 13155 | 1651 | 42 |
2125855 | 2125855 | 2022-01-18 | Irwin | Georgia | 13155 | 1643 | 42 |
2122603 | 2122603 | 2022-01-17 | Irwin | Georgia | 13155 | 1620 | 42 |
2119351 | 2119351 | 2022-01-16 | Irwin | Georgia | 13155 | 1607 | 42 |
2119407 | 2119407 | 2022-01-16 | Taylor | Georgia | 13269 | 1645 | 42 |
2116099 | 2116099 | 2022-01-15 | Irwin | Georgia | 13155 | 1607 | 42 |
2116155 | 2116155 | 2022-01-15 | Taylor | Georgia | 13269 | 1645 | 42 |
2112848 | 2112848 | 2022-01-14 | Irwin | Georgia | 13155 | 1607 | 42 |
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);