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,348 rows where county = "Douglas" sorted by date descending

View and edit SQL

state

fips

county

  • Douglas · 1,348
Link rowid date ▲ county state fips cases deaths
334635 2020-07-15 Douglas Colorado 8035 1224 54
334809 2020-07-15 Douglas Georgia 13097 1545 40
334988 2020-07-15 Douglas Illinois 17041 62 0
335285 2020-07-15 Douglas Kansas 20045 490 0
335711 2020-07-15 Douglas Minnesota 27041 83 0
335893 2020-07-15 Douglas Missouri 29067 17 0
336045 2020-07-15 Douglas Nebraska 31055 8436 111
336107 2020-07-15 Douglas Nevada 32005 97 0
336570 2020-07-15 Douglas Oregon 41019 70 1
336814 2020-07-15 Douglas South Dakota 46043 10 0
337388 2020-07-15 Douglas Washington 53017 408 3
337488 2020-07-15 Douglas Wisconsin 55031 64 0
331444 2020-07-14 Douglas Colorado 8035 1201 53
331618 2020-07-14 Douglas Georgia 13097 1499 40
331797 2020-07-14 Douglas Illinois 17041 61 0
332094 2020-07-14 Douglas Kansas 20045 456 0
332520 2020-07-14 Douglas Minnesota 27041 75 0
332702 2020-07-14 Douglas Missouri 29067 16 0
332853 2020-07-14 Douglas Nebraska 31055 8296 108
332915 2020-07-14 Douglas Nevada 32005 94 0
333378 2020-07-14 Douglas Oregon 41019 66 0
333622 2020-07-14 Douglas South Dakota 46043 10 0
334195 2020-07-14 Douglas Washington 53017 400 3
334295 2020-07-14 Douglas Wisconsin 55031 63 0
328260 2020-07-13 Douglas Colorado 8035 1178 52
328433 2020-07-13 Douglas Georgia 13097 1461 39
328612 2020-07-13 Douglas Illinois 17041 61 0
328909 2020-07-13 Douglas Kansas 20045 456 0
329335 2020-07-13 Douglas Minnesota 27041 74 0
329517 2020-07-13 Douglas Missouri 29067 13 0
329665 2020-07-13 Douglas Nebraska 31055 8211 106
329726 2020-07-13 Douglas Nevada 32005 86 0
330188 2020-07-13 Douglas Oregon 41019 64 0
330432 2020-07-13 Douglas South Dakota 46043 10 0
331004 2020-07-13 Douglas Washington 53017 396 3
331104 2020-07-13 Douglas Wisconsin 55031 61 0
325076 2020-07-12 Douglas Colorado 8035 1161 52
325249 2020-07-12 Douglas Georgia 13097 1409 39
325428 2020-07-12 Douglas Illinois 17041 61 0
325725 2020-07-12 Douglas Kansas 20045 415 0
326151 2020-07-12 Douglas Minnesota 27041 73 0
326333 2020-07-12 Douglas Missouri 29067 12 0
326480 2020-07-12 Douglas Nebraska 31055 8136 105
326541 2020-07-12 Douglas Nevada 32005 86 0
327004 2020-07-12 Douglas Oregon 41019 64 0
327248 2020-07-12 Douglas South Dakota 46043 10 0
327820 2020-07-12 Douglas Washington 53017 380 3
327920 2020-07-12 Douglas Wisconsin 55031 60 0
321897 2020-07-11 Douglas Colorado 8035 1134 52
322070 2020-07-11 Douglas Georgia 13097 1388 39
322249 2020-07-11 Douglas Illinois 17041 61 0
322545 2020-07-11 Douglas Kansas 20045 415 0
322970 2020-07-11 Douglas Minnesota 27041 70 0
323152 2020-07-11 Douglas Missouri 29067 12 0
323298 2020-07-11 Douglas Nebraska 31055 8063 105
323359 2020-07-11 Douglas Nevada 32005 84 0
323821 2020-07-11 Douglas Oregon 41019 60 0
324065 2020-07-11 Douglas South Dakota 46043 10 0
324637 2020-07-11 Douglas Washington 53017 351 3
324736 2020-07-11 Douglas Wisconsin 55031 56 0
318720 2020-07-10 Douglas Colorado 8035 1120 52
318893 2020-07-10 Douglas Georgia 13097 1347 39
319072 2020-07-10 Douglas Illinois 17041 55 0
319368 2020-07-10 Douglas Kansas 20045 415 0
319793 2020-07-10 Douglas Minnesota 27041 69 0
319975 2020-07-10 Douglas Missouri 29067 11 0
320121 2020-07-10 Douglas Nebraska 31055 7978 103
320181 2020-07-10 Douglas Nevada 32005 82 0
320643 2020-07-10 Douglas Oregon 41019 58 0
320887 2020-07-10 Douglas South Dakota 46043 10 0
321458 2020-07-10 Douglas Washington 53017 351 3
321557 2020-07-10 Douglas Wisconsin 55031 50 0
315549 2020-07-09 Douglas Colorado 8035 1078 52
315722 2020-07-09 Douglas Georgia 13097 1259 37
315901 2020-07-09 Douglas Illinois 17041 55 0
316197 2020-07-09 Douglas Kansas 20045 377 0
316620 2020-07-09 Douglas Minnesota 27041 67 0
316802 2020-07-09 Douglas Missouri 29067 8 0
316948 2020-07-09 Douglas Nebraska 31055 7876 102
317007 2020-07-09 Douglas Nevada 32005 80 0
317467 2020-07-09 Douglas Oregon 41019 56 0
317711 2020-07-09 Douglas South Dakota 46043 10 0
318281 2020-07-09 Douglas Washington 53017 334 3
318380 2020-07-09 Douglas Wisconsin 55031 48 0
312376 2020-07-08 Douglas Colorado 8035 1056 52
312549 2020-07-08 Douglas Georgia 13097 1230 37
312729 2020-07-08 Douglas Illinois 17041 54 0
313025 2020-07-08 Douglas Kansas 20045 377 0
313448 2020-07-08 Douglas Minnesota 27041 66 0
313630 2020-07-08 Douglas Missouri 29067 6 0
313776 2020-07-08 Douglas Nebraska 31055 7789 100
313835 2020-07-08 Douglas Nevada 32005 79 0
314296 2020-07-08 Douglas Oregon 41019 56 0
314540 2020-07-08 Douglas South Dakota 46043 10 0
315110 2020-07-08 Douglas Washington 53017 325 3
315209 2020-07-08 Douglas Wisconsin 55031 47 0
309208 2020-07-07 Douglas Colorado 8035 1042 52
309381 2020-07-07 Douglas Georgia 13097 1179 37
309561 2020-07-07 Douglas Illinois 17041 54 0
309857 2020-07-07 Douglas Kansas 20045 354 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 1073.002ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette