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

49 rows where cases = 7989 sorted by date descending

✎ View and edit SQL

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

These facets timed out: county, fips

Link rowid date ▲ county state fips cases deaths
2502243 2502243 2022-05-13 Cherokee Texas 48073 7989 254
2497882 2497882 2022-05-12 Marion Missouri 29127 7989 118
2494624 2494624 2022-05-11 Marion Missouri 29127 7989 118
2491366 2491366 2022-05-10 Marion Missouri 29127 7989 118
2488108 2488108 2022-05-09 Marion Missouri 29127 7989 118
2484851 2484851 2022-05-08 Marion Missouri 29127 7989 118
2481593 2481593 2022-05-07 Marion Missouri 29127 7989 118
2478335 2478335 2022-05-06 Marion Missouri 29127 7989 118
2472596 2472596 2022-05-04 Aguadilla Puerto Rico 72005 7989  
2466114 2466114 2022-05-02 Gurabo Puerto Rico 72063 7989  
2279532 2279532 2022-03-06 Huron Michigan 26063 7989 144
2276279 2276279 2022-03-05 Huron Michigan 26063 7989 144
2273026 2273026 2022-03-04 Huron Michigan 26063 7989 144
2062896 2062896 2021-12-29 Campbell Tennessee 47013 7989 128
2047502 2047502 2021-12-25 Hot Spring Arkansas 5059 7989 114
2039750 2039750 2021-12-22 Shelby Ohio 39149 7989 138
2005347 2005347 2021-12-12 Tuolumne California 6109 7989 148
2000184 2000184 2021-12-10 Pettis Missouri 29159 7989 128
1995575 1995575 2021-12-09 San Benito California 6069 7989 79
1996712 1996712 2021-12-09 Itasca Minnesota 27061 7989 102
1945670 1945670 2021-11-23 Union Pennsylvania 42119 7989 109
1880902 1880902 2021-11-03 Franklin Tennessee 47051 7989 102
1857456 1857456 2021-10-27 Cattaraugus New York 36009 7989 119
1830371 1830371 2021-10-19 Noble Indiana 18113 7989 109
1790356 1790356 2021-10-06 Harrisonburg city Virginia 51660 7989 101
1774532 1774532 2021-10-02 Mississippi Arkansas 5093 7989 130
1770172 1770172 2021-09-30 Indiana Pennsylvania 42063 7989 194
1714737 1714737 2021-09-13 Hancock Ohio 39063 7989 139
1706280 1706280 2021-09-11 Crittenden Arkansas 5035 7989 113
1624137 1624137 2021-08-16 Laurens South Carolina 45059 7989 173
1540390 1540390 2021-07-21 Wood West Virginia 54107 7989 176
1528034 1528034 2021-07-18 Walker Georgia 13295 7989 91
1524787 1524787 2021-07-17 Walker Georgia 13295 7989 91
1521539 1521539 2021-07-16 Walker Georgia 13295 7989 91
1406703 1406703 2021-06-10 Greene Tennessee 47059 7989 159
1400212 1400212 2021-06-08 Greene Tennessee 47059 7989 159
1374010 1374010 2021-05-31 Somerset Pennsylvania 42111 7989 212
1326348 1326348 2021-05-17 Santa Cruz Arizona 4023 7989 179
1323102 1323102 2021-05-16 Santa Cruz Arizona 4023 7989 179
1250600 1250600 2021-04-23 Clearfield Pennsylvania 42033 7989 134
1229569 1229569 2021-04-17 Hancock Indiana 18059 7989 143
1145606 1145606 2021-03-22 Carroll Maryland 24013 7989 216
1081580 1081580 2021-03-02 Marion Ohio 39101 7989 125
808751 808751 2020-12-08 Alamance North Carolina 37001 7989 111
786125 786125 2020-12-01 Union North Carolina 37179 7989 76
782881 782881 2020-11-30 Union North Carolina 37179 7989 76
760313 760313 2020-11-23 Warren Ohio 39165 7989 75
479810 479810 2020-08-29 Pasco Florida 12101 7989 173
476523 476523 2020-08-28 New Castle Delaware 10003 7989 300

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