ny_times_us_counties

⚠️ 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

1,396 rows where county = "Warren" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

  • Warren · 1,396
Link rowid date ▲ county state fips cases deaths
292294 2020-07-03 Warren Georgia 13301 25 0
292445 2020-07-03 Warren Illinois 17187 143 0
292539 2020-07-03 Warren Indiana 18171 15 1
292637 2020-07-03 Warren Iowa 19181 267 1
292855 2020-07-03 Warren Kentucky 21227 1583 15
293228 2020-07-03 Warren Mississippi 28149 496 18
293346 2020-07-03 Warren Missouri 29219 45 0
293519 2020-07-03 Warren New Jersey 34041 1257 161
293603 2020-07-03 Warren New York 36113 266 31
293701 2020-07-03 Warren North Carolina 37185 161 5
293842 2020-07-03 Warren Ohio 39165 814 21
294019 2020-07-03 Warren Pennsylvania 42123 7 1
294226 2020-07-03 Warren Tennessee 47177 72 0
294646 2020-07-03 Warren Virginia 51187 294 7
289217 2020-07-02 Warren Georgia 13301 23 0
289366 2020-07-02 Warren Illinois 17187 139 0
289460 2020-07-02 Warren Indiana 18171 15 1
289558 2020-07-02 Warren Iowa 19181 258 1
289776 2020-07-02 Warren Kentucky 21227 1563 15
290149 2020-07-02 Warren Mississippi 28149 463 17
290267 2020-07-02 Warren Missouri 29219 44 0
290438 2020-07-02 Warren New Jersey 34041 1254 160
290522 2020-07-02 Warren New York 36113 264 31
290620 2020-07-02 Warren North Carolina 37185 160 5
290762 2020-07-02 Warren Ohio 39165 757 21
290939 2020-07-02 Warren Pennsylvania 42123 7 1
291145 2020-07-02 Warren Tennessee 47177 69 0
291563 2020-07-02 Warren Virginia 51187 292 6
286142 2020-07-01 Warren Georgia 13301 23 0
286291 2020-07-01 Warren Illinois 17187 138 0
286385 2020-07-01 Warren Indiana 18171 15 1
286483 2020-07-01 Warren Iowa 19181 252 1
286701 2020-07-01 Warren Kentucky 21227 1547 14
287074 2020-07-01 Warren Mississippi 28149 443 17
287192 2020-07-01 Warren Missouri 29219 43 0
287362 2020-07-01 Warren New Jersey 34041 1252 159
287446 2020-07-01 Warren New York 36113 263 31
287544 2020-07-01 Warren North Carolina 37185 160 5
287685 2020-07-01 Warren Ohio 39165 757 21
287862 2020-07-01 Warren Pennsylvania 42123 7 0
288069 2020-07-01 Warren Tennessee 47177 65 0
288487 2020-07-01 Warren Virginia 51187 290 5
283069 2020-06-30 Warren Georgia 13301 22 0
283219 2020-06-30 Warren Illinois 17187 136 0
283313 2020-06-30 Warren Indiana 18171 15 1
283411 2020-06-30 Warren Iowa 19181 245 2
283629 2020-06-30 Warren Kentucky 21227 1533 14
284002 2020-06-30 Warren Mississippi 28149 425 17
284120 2020-06-30 Warren Missouri 29219 43 0
284289 2020-06-30 Warren New Jersey 34041 1244 158
284373 2020-06-30 Warren New York 36113 263 31
284471 2020-06-30 Warren North Carolina 37185 161 5
284612 2020-06-30 Warren Ohio 39165 738 21
284789 2020-06-30 Warren Pennsylvania 42123 6 0
284995 2020-06-30 Warren Tennessee 47177 62 0
285413 2020-06-30 Warren Virginia 51187 284 5
280000 2020-06-29 Warren Georgia 13301 20 0
280147 2020-06-29 Warren Illinois 17187 135 0
280241 2020-06-29 Warren Indiana 18171 15 1
280339 2020-06-29 Warren Iowa 19181 243 2
280557 2020-06-29 Warren Kentucky 21227 1514 14
280929 2020-06-29 Warren Mississippi 28149 409 17
281047 2020-06-29 Warren Missouri 29219 40 0
281216 2020-06-29 Warren New Jersey 34041 1241 156
281300 2020-06-29 Warren New York 36113 263 31
281398 2020-06-29 Warren North Carolina 37185 159 5
281539 2020-06-29 Warren Ohio 39165 731 20
281715 2020-06-29 Warren Pennsylvania 42123 5 0
281922 2020-06-29 Warren Tennessee 47177 58 0
282340 2020-06-29 Warren Virginia 51187 285 5
276932 2020-06-28 Warren Georgia 13301 19 0
277080 2020-06-28 Warren Illinois 17187 135 0
277174 2020-06-28 Warren Indiana 18171 15 1
277272 2020-06-28 Warren Iowa 19181 237 2
277488 2020-06-28 Warren Kentucky 21227 1491 14
277861 2020-06-28 Warren Mississippi 28149 398 17
277979 2020-06-28 Warren Missouri 29219 40 0
278148 2020-06-28 Warren New Jersey 34041 1239 156
278232 2020-06-28 Warren New York 36113 263 31
278330 2020-06-28 Warren North Carolina 37185 159 5
278471 2020-06-28 Warren Ohio 39165 725 20
278647 2020-06-28 Warren Pennsylvania 42123 5 0
278853 2020-06-28 Warren Tennessee 47177 55 0
279271 2020-06-28 Warren Virginia 51187 285 5
273863 2020-06-27 Warren Georgia 13301 19 0
274010 2020-06-27 Warren Illinois 17187 133 0
274104 2020-06-27 Warren Indiana 18171 15 1
274202 2020-06-27 Warren Iowa 19181 231 2
274418 2020-06-27 Warren Kentucky 21227 1481 14
274791 2020-06-27 Warren Mississippi 28149 392 17
274909 2020-06-27 Warren Missouri 29219 40 0
275079 2020-06-27 Warren New Jersey 34041 1238 156
275164 2020-06-27 Warren New York 36113 263 31
275262 2020-06-27 Warren North Carolina 37185 157 5
275403 2020-06-27 Warren Ohio 39165 708 20
275579 2020-06-27 Warren Pennsylvania 42123 5 0
275785 2020-06-27 Warren Tennessee 47177 55 0
276203 2020-06-27 Warren Virginia 51187 278 5
270794 2020-06-26 Warren Georgia 13301 19 0
270941 2020-06-26 Warren Illinois 17187 133 0

Next page

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
);
Powered by Datasette · Query took 941.402ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette