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 |
---|---|---|---|---|---|---|---|
310103 | 310103 | 2020-07-07 | Douglas | Kansas | 20045 | 354 | 0 |
310526 | 310526 | 2020-07-07 | Douglas | Minnesota | 27041 | 65 | 0 |
310708 | 310708 | 2020-07-07 | Douglas | Missouri | 29067 | 6 | 0 |
310853 | 310853 | 2020-07-07 | Douglas | Nebraska | 31055 | 7687 | 98 |
310912 | 310912 | 2020-07-07 | Douglas | Nevada | 32005 | 79 | 0 |
311372 | 311372 | 2020-07-07 | Douglas | Oregon | 41019 | 54 | 0 |
311615 | 311615 | 2020-07-07 | Douglas | South Dakota | 46043 | 10 | 0 |
312186 | 312186 | 2020-07-07 | Douglas | Washington | 53017 | 310 | 3 |
312285 | 312285 | 2020-07-07 | Douglas | Wisconsin | 55031 | 46 | 0 |
306286 | 306286 | 2020-07-06 | Douglas | Colorado | 8035 | 1019 | 52 |
306459 | 306459 | 2020-07-06 | Douglas | Georgia | 13097 | 1137 | 37 |
306639 | 306639 | 2020-07-06 | Douglas | Illinois | 17041 | 54 | 0 |
306935 | 306935 | 2020-07-06 | Douglas | Kansas | 20045 | 354 | 0 |
307358 | 307358 | 2020-07-06 | Douglas | Minnesota | 27041 | 65 | 0 |
307540 | 307540 | 2020-07-06 | Douglas | Missouri | 29067 | 6 | 0 |
307685 | 307685 | 2020-07-06 | Douglas | Nebraska | 31055 | 7643 | 97 |
307744 | 307744 | 2020-07-06 | Douglas | Nevada | 32005 | 76 | 0 |
308203 | 308203 | 2020-07-06 | Douglas | Oregon | 41019 | 51 | 0 |
308446 | 308446 | 2020-07-06 | Douglas | South Dakota | 46043 | 9 | 0 |
309017 | 309017 | 2020-07-06 | Douglas | Washington | 53017 | 303 | 3 |
309116 | 309116 | 2020-07-06 | Douglas | Wisconsin | 55031 | 41 | 0 |
303122 | 303122 | 2020-07-05 | Douglas | Colorado | 8035 | 1013 | 52 |
303295 | 303295 | 2020-07-05 | Douglas | Georgia | 13097 | 1101 | 36 |
303474 | 303474 | 2020-07-05 | Douglas | Illinois | 17041 | 54 | 0 |
303770 | 303770 | 2020-07-05 | Douglas | Kansas | 20045 | 251 | 0 |
304191 | 304191 | 2020-07-05 | Douglas | Minnesota | 27041 | 64 | 0 |
304373 | 304373 | 2020-07-05 | Douglas | Missouri | 29067 | 6 | 0 |
304518 | 304518 | 2020-07-05 | Douglas | Nebraska | 31055 | 7593 | 96 |
304577 | 304577 | 2020-07-05 | Douglas | Nevada | 32005 | 74 | 0 |
305036 | 305036 | 2020-07-05 | Douglas | Oregon | 41019 | 50 | 0 |
305279 | 305279 | 2020-07-05 | Douglas | South Dakota | 46043 | 9 | 0 |
305849 | 305849 | 2020-07-05 | Douglas | Washington | 53017 | 279 | 3 |
305947 | 305947 | 2020-07-05 | Douglas | Wisconsin | 55031 | 41 | 0 |
299958 | 299958 | 2020-07-04 | Douglas | Colorado | 8035 | 1006 | 52 |
300131 | 300131 | 2020-07-04 | Douglas | Georgia | 13097 | 1079 | 36 |
300310 | 300310 | 2020-07-04 | Douglas | Illinois | 17041 | 54 | 0 |
300606 | 300606 | 2020-07-04 | Douglas | Kansas | 20045 | 251 | 0 |
301027 | 301027 | 2020-07-04 | Douglas | Minnesota | 27041 | 62 | 0 |
301209 | 301209 | 2020-07-04 | Douglas | Missouri | 29067 | 6 | 0 |
301354 | 301354 | 2020-07-04 | Douglas | Nebraska | 31055 | 7406 | 96 |
301414 | 301414 | 2020-07-04 | Douglas | Nevada | 32005 | 72 | 0 |
301873 | 301873 | 2020-07-04 | Douglas | Oregon | 41019 | 46 | 0 |
302116 | 302116 | 2020-07-04 | Douglas | South Dakota | 46043 | 7 | 0 |
302685 | 302685 | 2020-07-04 | Douglas | Washington | 53017 | 273 | 3 |
302783 | 302783 | 2020-07-04 | Douglas | Wisconsin | 55031 | 39 | 0 |
296796 | 296796 | 2020-07-03 | Douglas | Colorado | 8035 | 993 | 52 |
296969 | 296969 | 2020-07-03 | Douglas | Georgia | 13097 | 1041 | 36 |
297148 | 297148 | 2020-07-03 | Douglas | Illinois | 17041 | 54 | 0 |
297444 | 297444 | 2020-07-03 | Douglas | Kansas | 20045 | 251 | 0 |
297864 | 297864 | 2020-07-03 | Douglas | Minnesota | 27041 | 62 | 0 |
298046 | 298046 | 2020-07-03 | Douglas | Missouri | 29067 | 6 | 0 |
298191 | 298191 | 2020-07-03 | Douglas | Nebraska | 31055 | 7344 | 96 |
298251 | 298251 | 2020-07-03 | Douglas | Nevada | 32005 | 70 | 0 |
298710 | 298710 | 2020-07-03 | Douglas | Oregon | 41019 | 45 | 0 |
298952 | 298952 | 2020-07-03 | Douglas | South Dakota | 46043 | 7 | 0 |
299521 | 299521 | 2020-07-03 | Douglas | Washington | 53017 | 265 | 3 |
299619 | 299619 | 2020-07-03 | Douglas | Wisconsin | 55031 | 39 | 0 |
293640 | 293640 | 2020-07-02 | Douglas | Colorado | 8035 | 984 | 52 |
293813 | 293813 | 2020-07-02 | Douglas | Georgia | 13097 | 1021 | 36 |
293991 | 293991 | 2020-07-02 | Douglas | Illinois | 17041 | 53 | 0 |
294286 | 294286 | 2020-07-02 | Douglas | Kansas | 20045 | 190 | 0 |
294706 | 294706 | 2020-07-02 | Douglas | Minnesota | 27041 | 61 | 0 |
294888 | 294888 | 2020-07-02 | Douglas | Missouri | 29067 | 6 | 0 |
295032 | 295032 | 2020-07-02 | Douglas | Nebraska | 31055 | 7344 | 95 |
295091 | 295091 | 2020-07-02 | Douglas | Nevada | 32005 | 70 | 0 |
295551 | 295551 | 2020-07-02 | Douglas | Oregon | 41019 | 44 | 0 |
295792 | 295792 | 2020-07-02 | Douglas | South Dakota | 46043 | 5 | 0 |
296359 | 296359 | 2020-07-02 | Douglas | Washington | 53017 | 253 | 3 |
296457 | 296457 | 2020-07-02 | Douglas | Wisconsin | 55031 | 31 | 0 |
290486 | 290486 | 2020-07-01 | Douglas | Colorado | 8035 | 964 | 52 |
290659 | 290659 | 2020-07-01 | Douglas | Georgia | 13097 | 971 | 36 |
290837 | 290837 | 2020-07-01 | Douglas | Illinois | 17041 | 52 | 0 |
291132 | 291132 | 2020-07-01 | Douglas | Kansas | 20045 | 188 | 0 |
291552 | 291552 | 2020-07-01 | Douglas | Minnesota | 27041 | 61 | 0 |
291734 | 291734 | 2020-07-01 | Douglas | Missouri | 29067 | 5 | 0 |
291877 | 291877 | 2020-07-01 | Douglas | Nebraska | 31055 | 7294 | 94 |
291936 | 291936 | 2020-07-01 | Douglas | Nevada | 32005 | 69 | 0 |
292395 | 292395 | 2020-07-01 | Douglas | Oregon | 41019 | 42 | 0 |
292636 | 292636 | 2020-07-01 | Douglas | South Dakota | 46043 | 4 | 0 |
293204 | 293204 | 2020-07-01 | Douglas | Washington | 53017 | 245 | 3 |
293302 | 293302 | 2020-07-01 | Douglas | Wisconsin | 55031 | 30 | 0 |
287335 | 287335 | 2020-06-30 | Douglas | Colorado | 8035 | 951 | 52 |
287508 | 287508 | 2020-06-30 | Douglas | Georgia | 13097 | 917 | 36 |
287687 | 287687 | 2020-06-30 | Douglas | Illinois | 17041 | 52 | 0 |
287982 | 287982 | 2020-06-30 | Douglas | Kansas | 20045 | 159 | 0 |
288401 | 288401 | 2020-06-30 | Douglas | Minnesota | 27041 | 61 | 0 |
288583 | 288583 | 2020-06-30 | Douglas | Missouri | 29067 | 4 | 0 |
288726 | 288726 | 2020-06-30 | Douglas | Nebraska | 31055 | 7235 | 93 |
288784 | 288784 | 2020-06-30 | Douglas | Nevada | 32005 | 65 | 0 |
289243 | 289243 | 2020-06-30 | Douglas | Oregon | 41019 | 40 | 0 |
289484 | 289484 | 2020-06-30 | Douglas | South Dakota | 46043 | 4 | 0 |
290051 | 290051 | 2020-06-30 | Douglas | Washington | 53017 | 239 | 3 |
290149 | 290149 | 2020-06-30 | Douglas | Wisconsin | 55031 | 25 | 0 |
284189 | 284189 | 2020-06-29 | Douglas | Colorado | 8035 | 946 | 52 |
284362 | 284362 | 2020-06-29 | Douglas | Georgia | 13097 | 879 | 36 |
284538 | 284538 | 2020-06-29 | Douglas | Illinois | 17041 | 50 | 0 |
284833 | 284833 | 2020-06-29 | Douglas | Kansas | 20045 | 159 | 0 |
285251 | 285251 | 2020-06-29 | Douglas | Minnesota | 27041 | 58 | 0 |
285433 | 285433 | 2020-06-29 | Douglas | Missouri | 29067 | 4 | 0 |
285576 | 285576 | 2020-06-29 | Douglas | Nebraska | 31055 | 7170 | 88 |
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);