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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
199 | 199 | 2020-02-17 | Douglas | Nebraska | 31055 | 10 | 0 |
211 | 211 | 2020-02-18 | Douglas | Nebraska | 31055 | 10 | 0 |
223 | 223 | 2020-02-19 | Douglas | Nebraska | 31055 | 10 | 0 |
236 | 236 | 2020-02-20 | Douglas | Nebraska | 31055 | 11 | 0 |
250 | 250 | 2020-02-21 | Douglas | Nebraska | 31055 | 11 | 0 |
264 | 264 | 2020-02-22 | Douglas | Nebraska | 31055 | 11 | 0 |
278 | 278 | 2020-02-23 | Douglas | Nebraska | 31055 | 11 | 0 |
293 | 293 | 2020-02-24 | Douglas | Nebraska | 31055 | 12 | 0 |
309 | 309 | 2020-02-25 | Douglas | Nebraska | 31055 | 13 | 0 |
329 | 329 | 2020-02-26 | Douglas | Nebraska | 31055 | 13 | 0 |
349 | 349 | 2020-02-27 | Douglas | Nebraska | 31055 | 13 | 0 |
369 | 369 | 2020-02-28 | Douglas | Nebraska | 31055 | 13 | 0 |
391 | 391 | 2020-02-29 | Douglas | Nebraska | 31055 | 13 | 0 |
416 | 416 | 2020-03-01 | Douglas | Nebraska | 31055 | 13 | 0 |
447 | 447 | 2020-03-02 | Douglas | Nebraska | 31055 | 13 | 0 |
481 | 481 | 2020-03-03 | Douglas | Nebraska | 31055 | 13 | 0 |
516 | 516 | 2020-03-04 | Douglas | Nebraska | 31055 | 13 | 0 |
549 | 549 | 2020-03-05 | Douglas | Colorado | 8035 | 1 | 0 |
560 | 560 | 2020-03-05 | Douglas | Nebraska | 31055 | 13 | 0 |
601 | 601 | 2020-03-06 | Douglas | Colorado | 8035 | 3 | 0 |
621 | 621 | 2020-03-06 | Douglas | Nebraska | 31055 | 14 | 0 |
679 | 679 | 2020-03-07 | Douglas | Colorado | 8035 | 3 | 0 |
708 | 708 | 2020-03-07 | Douglas | Nebraska | 31055 | 14 | 0 |
774 | 774 | 2020-03-08 | Douglas | Colorado | 8035 | 3 | 0 |
812 | 812 | 2020-03-08 | Douglas | Nebraska | 31055 | 16 | 0 |
830 | 830 | 2020-03-08 | Douglas | Oregon | 41019 | 1 | 0 |
890 | 890 | 2020-03-09 | Douglas | Colorado | 8035 | 3 | 0 |
936 | 936 | 2020-03-09 | Douglas | Nebraska | 31055 | 16 | 0 |
958 | 958 | 2020-03-09 | Douglas | Oregon | 41019 | 1 | 0 |
1024 | 1024 | 2020-03-10 | Douglas | Colorado | 8035 | 3 | 0 |
1086 | 1086 | 2020-03-10 | Douglas | Nebraska | 31055 | 17 | 0 |
1109 | 1109 | 2020-03-10 | Douglas | Oregon | 41019 | 1 | 0 |
1191 | 1191 | 2020-03-11 | Douglas | Colorado | 8035 | 3 | 0 |
1268 | 1268 | 2020-03-11 | Douglas | Nebraska | 31055 | 23 | 0 |
1299 | 1299 | 2020-03-11 | Douglas | Oregon | 41019 | 1 | 0 |
1399 | 1399 | 2020-03-12 | Douglas | Colorado | 8035 | 3 | 0 |
1496 | 1496 | 2020-03-12 | Douglas | Nebraska | 31055 | 23 | 0 |
1543 | 1543 | 2020-03-12 | Douglas | Oregon | 41019 | 1 | 0 |
1661 | 1661 | 2020-03-13 | Douglas | Colorado | 8035 | 4 | 0 |
1788 | 1788 | 2020-03-13 | Douglas | Nebraska | 31055 | 26 | 0 |
1839 | 1839 | 2020-03-13 | Douglas | Oregon | 41019 | 1 | 0 |
1980 | 1980 | 2020-03-14 | Douglas | Colorado | 8035 | 4 | 0 |
2134 | 2134 | 2020-03-14 | Douglas | Nebraska | 31055 | 28 | 0 |
2200 | 2200 | 2020-03-14 | Douglas | Oregon | 41019 | 1 | 0 |
2361 | 2361 | 2020-03-15 | Douglas | Colorado | 8035 | 8 | 0 |
2541 | 2541 | 2020-03-15 | Douglas | Nebraska | 31055 | 30 | 0 |
2619 | 2619 | 2020-03-15 | Douglas | Oregon | 41019 | 1 | 0 |
2796 | 2796 | 2020-03-16 | Douglas | Colorado | 8035 | 8 | 0 |
2996 | 2996 | 2020-03-16 | Douglas | Nebraska | 31055 | 32 | 0 |
3084 | 3084 | 2020-03-16 | Douglas | Oregon | 41019 | 1 | 0 |
3278 | 3278 | 2020-03-17 | Douglas | Colorado | 8035 | 9 | 0 |
3399 | 3399 | 2020-03-17 | Douglas | Kansas | 20045 | 1 | 0 |
3506 | 3506 | 2020-03-17 | Douglas | Nebraska | 31055 | 33 | 0 |
3612 | 3612 | 2020-03-17 | Douglas | Oregon | 41019 | 1 | 0 |
3832 | 3832 | 2020-03-18 | Douglas | Colorado | 8035 | 11 | 0 |
3975 | 3975 | 2020-03-18 | Douglas | Kansas | 20045 | 1 | 0 |
4098 | 4098 | 2020-03-18 | Douglas | Nebraska | 31055 | 37 | 0 |
4227 | 4227 | 2020-03-18 | Douglas | Oregon | 41019 | 1 | 0 |
4493 | 4493 | 2020-03-19 | Douglas | Colorado | 8035 | 14 | 0 |
4657 | 4657 | 2020-03-19 | Douglas | Kansas | 20045 | 1 | 0 |
4821 | 4821 | 2020-03-19 | Douglas | Nebraska | 31055 | 37 | 0 |
4966 | 4966 | 2020-03-19 | Douglas | Oregon | 41019 | 1 | 0 |
5269 | 5269 | 2020-03-20 | Douglas | Colorado | 8035 | 17 | 0 |
5349 | 5349 | 2020-03-20 | Douglas | Georgia | 13097 | 1 | 0 |
5468 | 5468 | 2020-03-20 | Douglas | Kansas | 20045 | 1 | 0 |
5661 | 5661 | 2020-03-20 | Douglas | Nebraska | 31055 | 40 | 0 |
5833 | 5833 | 2020-03-20 | Douglas | Oregon | 41019 | 1 | 0 |
6053 | 6053 | 2020-03-20 | Douglas | Wisconsin | 55031 | 1 | 0 |
6193 | 6193 | 2020-03-21 | Douglas | Colorado | 8035 | 27 | 0 |
6282 | 6282 | 2020-03-21 | Douglas | Georgia | 13097 | 4 | 0 |
6413 | 6413 | 2020-03-21 | Douglas | Kansas | 20045 | 3 | 0 |
6653 | 6653 | 2020-03-21 | Douglas | Nebraska | 31055 | 46 | 0 |
6834 | 6834 | 2020-03-21 | Douglas | Oregon | 41019 | 1 | 0 |
7086 | 7086 | 2020-03-21 | Douglas | Wisconsin | 55031 | 1 | 0 |
7228 | 7228 | 2020-03-22 | Douglas | Colorado | 8035 | 33 | 0 |
7328 | 7328 | 2020-03-22 | Douglas | Georgia | 13097 | 4 | 0 |
7480 | 7480 | 2020-03-22 | Douglas | Kansas | 20045 | 4 | 0 |
7743 | 7743 | 2020-03-22 | Douglas | Nebraska | 31055 | 46 | 0 |
7949 | 7949 | 2020-03-22 | Douglas | Oregon | 41019 | 1 | 0 |
8224 | 8224 | 2020-03-22 | Douglas | Wisconsin | 55031 | 1 | 0 |
8371 | 8371 | 2020-03-23 | Douglas | Colorado | 8035 | 48 | 0 |
8476 | 8476 | 2020-03-23 | Douglas | Georgia | 13097 | 7 | 0 |
8641 | 8641 | 2020-03-23 | Douglas | Kansas | 20045 | 6 | 0 |
8936 | 8936 | 2020-03-23 | Douglas | Nebraska | 31055 | 50 | 0 |
8946 | 8946 | 2020-03-23 | Douglas | Nevada | 32005 | 1 | 0 |
9158 | 9158 | 2020-03-23 | Douglas | Oregon | 41019 | 1 | 0 |
9411 | 9411 | 2020-03-23 | Douglas | Washington | 53017 | 1 | 0 |
9450 | 9450 | 2020-03-23 | Douglas | Wisconsin | 55031 | 2 | 0 |
9614 | 9614 | 2020-03-24 | Douglas | Colorado | 8035 | 53 | 0 |
9727 | 9727 | 2020-03-24 | Douglas | Georgia | 13097 | 12 | 0 |
9922 | 9922 | 2020-03-24 | Douglas | Kansas | 20045 | 6 | 0 |
10239 | 10239 | 2020-03-24 | Douglas | Nebraska | 31055 | 52 | 0 |
10250 | 10250 | 2020-03-24 | Douglas | Nevada | 32005 | 2 | 0 |
10477 | 10477 | 2020-03-24 | Douglas | Oregon | 41019 | 1 | 0 |
10760 | 10760 | 2020-03-24 | Douglas | Washington | 53017 | 2 | 0 |
10804 | 10804 | 2020-03-24 | Douglas | Wisconsin | 55031 | 4 | 0 |
10987 | 10987 | 2020-03-25 | Douglas | Colorado | 8035 | 58 | 0 |
11104 | 11104 | 2020-03-25 | Douglas | Georgia | 13097 | 18 | 0 |
11200 | 11200 | 2020-03-25 | Douglas | Illinois | 17041 | 1 | 0 |
11320 | 11320 | 2020-03-25 | Douglas | Kansas | 20045 | 10 | 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);