ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,352 rows where county = "Douglas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281043 | 281043 | 2020-06-28 | Douglas | Colorado | 8035 | 939 | 52 |
281216 | 281216 | 2020-06-28 | Douglas | Georgia | 13097 | 878 | 36 |
281393 | 281393 | 2020-06-28 | Douglas | Illinois | 17041 | 48 | 0 |
281688 | 281688 | 2020-06-28 | Douglas | Kansas | 20045 | 124 | 0 |
282106 | 282106 | 2020-06-28 | Douglas | Minnesota | 27041 | 58 | 0 |
282288 | 282288 | 2020-06-28 | Douglas | Missouri | 29067 | 3 | 0 |
282431 | 282431 | 2020-06-28 | Douglas | Nebraska | 31055 | 7107 | 88 |
282489 | 282489 | 2020-06-28 | Douglas | Nevada | 32005 | 64 | 0 |
282947 | 282947 | 2020-06-28 | Douglas | Oregon | 41019 | 38 | 0 |
283188 | 283188 | 2020-06-28 | Douglas | South Dakota | 46043 | 4 | 0 |
283755 | 283755 | 2020-06-28 | Douglas | Washington | 53017 | 230 | 3 |
283853 | 283853 | 2020-06-28 | Douglas | Wisconsin | 55031 | 24 | 0 |
277896 | 277896 | 2020-06-27 | Douglas | Colorado | 8035 | 922 | 52 |
278069 | 278069 | 2020-06-27 | Douglas | Georgia | 13097 | 864 | 36 |
278245 | 278245 | 2020-06-27 | Douglas | Illinois | 17041 | 47 | 0 |
278540 | 278540 | 2020-06-27 | Douglas | Kansas | 20045 | 124 | 0 |
278958 | 278958 | 2020-06-27 | Douglas | Minnesota | 27041 | 58 | 0 |
279140 | 279140 | 2020-06-27 | Douglas | Missouri | 29067 | 3 | 0 |
279283 | 279283 | 2020-06-27 | Douglas | Nebraska | 31055 | 6937 | 88 |
279342 | 279342 | 2020-06-27 | Douglas | Nevada | 32005 | 62 | 0 |
279801 | 279801 | 2020-06-27 | Douglas | Oregon | 41019 | 38 | 0 |
280042 | 280042 | 2020-06-27 | Douglas | South Dakota | 46043 | 4 | 0 |
280609 | 280609 | 2020-06-27 | Douglas | Washington | 53017 | 223 | 3 |
280707 | 280707 | 2020-06-27 | Douglas | Wisconsin | 55031 | 22 | 0 |
274748 | 274748 | 2020-06-26 | Douglas | Colorado | 8035 | 911 | 52 |
274921 | 274921 | 2020-06-26 | Douglas | Georgia | 13097 | 843 | 36 |
275097 | 275097 | 2020-06-26 | Douglas | Illinois | 17041 | 45 | 0 |
275392 | 275392 | 2020-06-26 | Douglas | Kansas | 20045 | 124 | 0 |
275810 | 275810 | 2020-06-26 | Douglas | Minnesota | 27041 | 55 | 0 |
275992 | 275992 | 2020-06-26 | Douglas | Missouri | 29067 | 3 | 0 |
276135 | 276135 | 2020-06-26 | Douglas | Nebraska | 31055 | 6778 | 88 |
276194 | 276194 | 2020-06-26 | Douglas | Nevada | 32005 | 60 | 0 |
276653 | 276653 | 2020-06-26 | Douglas | Oregon | 41019 | 38 | 0 |
276894 | 276894 | 2020-06-26 | Douglas | South Dakota | 46043 | 4 | 0 |
277461 | 277461 | 2020-06-26 | Douglas | Washington | 53017 | 216 | 3 |
277559 | 277559 | 2020-06-26 | Douglas | Wisconsin | 55031 | 22 | 0 |
271608 | 271608 | 2020-06-25 | Douglas | Colorado | 8035 | 895 | 52 |
271781 | 271781 | 2020-06-25 | Douglas | Georgia | 13097 | 821 | 35 |
271955 | 271955 | 2020-06-25 | Douglas | Illinois | 17041 | 45 | 0 |
272250 | 272250 | 2020-06-25 | Douglas | Kansas | 20045 | 106 | 0 |
272667 | 272667 | 2020-06-25 | Douglas | Minnesota | 27041 | 55 | 0 |
272849 | 272849 | 2020-06-25 | Douglas | Missouri | 29067 | 3 | 0 |
272992 | 272992 | 2020-06-25 | Douglas | Nebraska | 31055 | 6716 | 84 |
273050 | 273050 | 2020-06-25 | Douglas | Nevada | 32005 | 60 | 0 |
273506 | 273506 | 2020-06-25 | Douglas | Oregon | 41019 | 34 | 0 |
273747 | 273747 | 2020-06-25 | Douglas | South Dakota | 46043 | 4 | 0 |
274313 | 274313 | 2020-06-25 | Douglas | Washington | 53017 | 210 | 3 |
274411 | 274411 | 2020-06-25 | Douglas | Wisconsin | 55031 | 20 | 0 |
268473 | 268473 | 2020-06-24 | Douglas | Colorado | 8035 | 873 | 52 |
268645 | 268645 | 2020-06-24 | Douglas | Georgia | 13097 | 793 | 35 |
268818 | 268818 | 2020-06-24 | Douglas | Illinois | 17041 | 43 | 0 |
269113 | 269113 | 2020-06-24 | Douglas | Kansas | 20045 | 106 | 0 |
269530 | 269530 | 2020-06-24 | Douglas | Minnesota | 27041 | 54 | 0 |
269711 | 269711 | 2020-06-24 | Douglas | Missouri | 29067 | 3 | 0 |
269853 | 269853 | 2020-06-24 | Douglas | Nebraska | 31055 | 6652 | 83 |
269911 | 269911 | 2020-06-24 | Douglas | Nevada | 32005 | 58 | 0 |
270367 | 270367 | 2020-06-24 | Douglas | Oregon | 41019 | 34 | 0 |
270608 | 270608 | 2020-06-24 | Douglas | South Dakota | 46043 | 4 | 0 |
271173 | 271173 | 2020-06-24 | Douglas | Washington | 53017 | 205 | 3 |
271271 | 271271 | 2020-06-24 | Douglas | Wisconsin | 55031 | 20 | 0 |
265343 | 265343 | 2020-06-23 | Douglas | Colorado | 8035 | 869 | 51 |
265515 | 265515 | 2020-06-23 | Douglas | Georgia | 13097 | 778 | 35 |
265688 | 265688 | 2020-06-23 | Douglas | Illinois | 17041 | 42 | 0 |
265983 | 265983 | 2020-06-23 | Douglas | Kansas | 20045 | 103 | 0 |
266397 | 266397 | 2020-06-23 | Douglas | Minnesota | 27041 | 54 | 0 |
266578 | 266578 | 2020-06-23 | Douglas | Missouri | 29067 | 3 | 0 |
266719 | 266719 | 2020-06-23 | Douglas | Nebraska | 31055 | 6591 | 83 |
266776 | 266776 | 2020-06-23 | Douglas | Nevada | 32005 | 54 | 0 |
267233 | 267233 | 2020-06-23 | Douglas | Oregon | 41019 | 34 | 0 |
267474 | 267474 | 2020-06-23 | Douglas | South Dakota | 46043 | 4 | 0 |
268039 | 268039 | 2020-06-23 | Douglas | Washington | 53017 | 199 | 3 |
268137 | 268137 | 2020-06-23 | Douglas | Wisconsin | 55031 | 20 | 0 |
262215 | 262215 | 2020-06-22 | Douglas | Colorado | 8035 | 864 | 51 |
262387 | 262387 | 2020-06-22 | Douglas | Georgia | 13097 | 740 | 36 |
262560 | 262560 | 2020-06-22 | Douglas | Illinois | 17041 | 42 | 0 |
262855 | 262855 | 2020-06-22 | Douglas | Kansas | 20045 | 103 | 0 |
263271 | 263271 | 2020-06-22 | Douglas | Minnesota | 27041 | 54 | 0 |
263452 | 263452 | 2020-06-22 | Douglas | Missouri | 29067 | 3 | 0 |
263593 | 263593 | 2020-06-22 | Douglas | Nebraska | 31055 | 6489 | 80 |
263649 | 263649 | 2020-06-22 | Douglas | Nevada | 32005 | 52 | 0 |
264105 | 264105 | 2020-06-22 | Douglas | Oregon | 41019 | 34 | 0 |
264346 | 264346 | 2020-06-22 | Douglas | South Dakota | 46043 | 4 | 0 |
264910 | 264910 | 2020-06-22 | Douglas | Washington | 53017 | 196 | 3 |
265008 | 265008 | 2020-06-22 | Douglas | Wisconsin | 55031 | 20 | 0 |
259088 | 259088 | 2020-06-21 | Douglas | Colorado | 8035 | 852 | 51 |
259260 | 259260 | 2020-06-21 | Douglas | Georgia | 13097 | 724 | 35 |
259433 | 259433 | 2020-06-21 | Douglas | Illinois | 17041 | 42 | 0 |
259728 | 259728 | 2020-06-21 | Douglas | Kansas | 20045 | 93 | 0 |
260142 | 260142 | 2020-06-21 | Douglas | Minnesota | 27041 | 54 | 0 |
260324 | 260324 | 2020-06-21 | Douglas | Missouri | 29067 | 3 | 0 |
260464 | 260464 | 2020-06-21 | Douglas | Nebraska | 31055 | 6426 | 80 |
260520 | 260520 | 2020-06-21 | Douglas | Nevada | 32005 | 49 | 0 |
260977 | 260977 | 2020-06-21 | Douglas | Oregon | 41019 | 33 | 0 |
261218 | 261218 | 2020-06-21 | Douglas | South Dakota | 46043 | 4 | 0 |
261781 | 261781 | 2020-06-21 | Douglas | Washington | 53017 | 193 | 3 |
261879 | 261879 | 2020-06-21 | Douglas | Wisconsin | 55031 | 20 | 0 |
255961 | 255961 | 2020-06-20 | Douglas | Colorado | 8035 | 839 | 51 |
256133 | 256133 | 2020-06-20 | Douglas | Georgia | 13097 | 712 | 35 |
256307 | 256307 | 2020-06-20 | Douglas | Illinois | 17041 | 42 | 0 |
256602 | 256602 | 2020-06-20 | Douglas | Kansas | 20045 | 93 | 0 |
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);