ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

33 rows where cases = 1250 and state = "Georgia" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

fips 18

state 1

  • Georgia · 33 ✖
Link rowid date ▲ county state fips cases deaths
2041343 2041343 2021-12-23 Lincoln Georgia 13181 1250 33
2034853 2034853 2021-12-21 Miller Georgia 13201 1250 24
2031603 2031603 2021-12-20 Miller Georgia 13201 1250 24
2012098 2012098 2021-12-14 Miller Georgia 13201 1250 24
2008847 2008847 2021-12-13 Miller Georgia 13201 1250 24
2005596 2005596 2021-12-12 Miller Georgia 13201 1250 24
2002345 2002345 2021-12-11 Miller Georgia 13201 1250 24
1999095 1999095 2021-12-10 Miller Georgia 13201 1250 24
1995844 1995844 2021-12-09 Miller Georgia 13201 1250 24
1992593 1992593 2021-12-08 Miller Georgia 13201 1250 24
1973128 1973128 2021-12-02 Terrell Georgia 13273 1250 58
1943835 1943835 2021-11-23 Miller Georgia 13201 1250 23
1940585 1940585 2021-11-22 Miller Georgia 13201 1250 23
1690426 1690426 2021-09-06 Stewart Georgia 13259 1250 26
1687176 1687176 2021-09-05 Stewart Georgia 13259 1250 26
1683926 1683926 2021-09-04 Stewart Georgia 13259 1250 26
1680675 1680675 2021-09-03 Stewart Georgia 13259 1250 26
1667715 1667715 2021-08-30 Wilkes Georgia 13317 1250 32
1618889 1618889 2021-08-15 Evans Georgia 13109 1250 35
1615641 1615641 2021-08-14 Evans Georgia 13109 1250 35
1612392 1612392 2021-08-13 Evans Georgia 13109 1250 35
1362485 1362485 2021-05-28 Towns Georgia 13281 1250 56
1118947 1118947 2021-03-14 Telfair Georgia 13271 1250 54
1040925 1040925 2021-02-18 Brooks Georgia 13027 1250 43
969615 969615 2021-01-27 Oglethorpe Georgia 13221 1250 16
907857 907857 2021-01-08 Berrien Georgia 13019 1250 30
842996 842996 2020-12-19 Fannin Georgia 13111 1250 41
823576 823576 2020-12-13 Peach Georgia 13225 1250 29
820351 820351 2020-12-12 Tattnall Georgia 13267 1250 34
658082 658082 2020-10-23 Liberty Georgia 13179 1250 25
560729 560729 2020-09-23 Camden Georgia 13039 1250 8
441214 441214 2020-08-17 Thomas Georgia 13275 1250 44
408854 408854 2020-08-07 Barrow Georgia 13013 1250 32

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);