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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
549 | 549 | 2020-03-05 | Douglas | Colorado | 8035 | 1 | 0 |
830 | 830 | 2020-03-08 | Douglas | Oregon | 41019 | 1 | 0 |
958 | 958 | 2020-03-09 | Douglas | Oregon | 41019 | 1 | 0 |
1109 | 1109 | 2020-03-10 | Douglas | Oregon | 41019 | 1 | 0 |
1299 | 1299 | 2020-03-11 | Douglas | Oregon | 41019 | 1 | 0 |
1543 | 1543 | 2020-03-12 | Douglas | Oregon | 41019 | 1 | 0 |
1839 | 1839 | 2020-03-13 | Douglas | Oregon | 41019 | 1 | 0 |
2200 | 2200 | 2020-03-14 | Douglas | Oregon | 41019 | 1 | 0 |
2619 | 2619 | 2020-03-15 | Douglas | Oregon | 41019 | 1 | 0 |
3084 | 3084 | 2020-03-16 | Douglas | Oregon | 41019 | 1 | 0 |
3399 | 3399 | 2020-03-17 | Douglas | Kansas | 20045 | 1 | 0 |
3612 | 3612 | 2020-03-17 | Douglas | Oregon | 41019 | 1 | 0 |
3975 | 3975 | 2020-03-18 | Douglas | Kansas | 20045 | 1 | 0 |
4227 | 4227 | 2020-03-18 | Douglas | Oregon | 41019 | 1 | 0 |
4657 | 4657 | 2020-03-19 | Douglas | Kansas | 20045 | 1 | 0 |
4966 | 4966 | 2020-03-19 | Douglas | Oregon | 41019 | 1 | 0 |
5349 | 5349 | 2020-03-20 | Douglas | Georgia | 13097 | 1 | 0 |
5468 | 5468 | 2020-03-20 | Douglas | Kansas | 20045 | 1 | 0 |
5833 | 5833 | 2020-03-20 | Douglas | Oregon | 41019 | 1 | 0 |
6053 | 6053 | 2020-03-20 | Douglas | Wisconsin | 55031 | 1 | 0 |
6834 | 6834 | 2020-03-21 | Douglas | Oregon | 41019 | 1 | 0 |
7086 | 7086 | 2020-03-21 | Douglas | Wisconsin | 55031 | 1 | 0 |
7949 | 7949 | 2020-03-22 | Douglas | Oregon | 41019 | 1 | 0 |
8224 | 8224 | 2020-03-22 | Douglas | Wisconsin | 55031 | 1 | 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 |
10477 | 10477 | 2020-03-24 | Douglas | Oregon | 41019 | 1 | 0 |
11200 | 11200 | 2020-03-25 | Douglas | Illinois | 17041 | 1 | 0 |
12755 | 12755 | 2020-03-26 | Douglas | Illinois | 17041 | 1 | 0 |
14431 | 14431 | 2020-03-27 | Douglas | Illinois | 17041 | 1 | 0 |
16225 | 16225 | 2020-03-28 | Douglas | Illinois | 17041 | 1 | 0 |
18124 | 18124 | 2020-03-29 | Douglas | Illinois | 17041 | 1 | 0 |
18568 | 18568 | 2020-03-29 | Douglas | Minnesota | 27041 | 1 | 0 |
20126 | 20126 | 2020-03-30 | Douglas | Illinois | 17041 | 1 | 0 |
20588 | 20588 | 2020-03-30 | Douglas | Minnesota | 27041 | 1 | 0 |
22702 | 22702 | 2020-03-31 | Douglas | Minnesota | 27041 | 1 | 0 |
24883 | 24883 | 2020-04-01 | Douglas | Minnesota | 27041 | 1 | 0 |
27136 | 27136 | 2020-04-02 | Douglas | Minnesota | 27041 | 1 | 0 |
29455 | 29455 | 2020-04-03 | Douglas | Minnesota | 27041 | 1 | 0 |
31833 | 31833 | 2020-04-04 | Douglas | Minnesota | 27041 | 1 | 0 |
34258 | 34258 | 2020-04-05 | Douglas | Minnesota | 27041 | 1 | 0 |
36718 | 36718 | 2020-04-06 | Douglas | Minnesota | 27041 | 1 | 0 |
39227 | 39227 | 2020-04-07 | Douglas | Minnesota | 27041 | 1 | 0 |
41780 | 41780 | 2020-04-08 | Douglas | Minnesota | 27041 | 1 | 0 |
44356 | 44356 | 2020-04-09 | Douglas | Minnesota | 27041 | 1 | 0 |
46965 | 46965 | 2020-04-10 | Douglas | Minnesota | 27041 | 1 | 0 |
49610 | 49610 | 2020-04-11 | Douglas | Minnesota | 27041 | 1 | 0 |
52280 | 52280 | 2020-04-12 | Douglas | Minnesota | 27041 | 1 | 0 |
54962 | 54962 | 2020-04-13 | Douglas | Minnesota | 27041 | 1 | 0 |
57660 | 57660 | 2020-04-14 | Douglas | Minnesota | 27041 | 1 | 0 |
60370 | 60370 | 2020-04-15 | Douglas | Minnesota | 27041 | 1 | 0 |
63092 | 63092 | 2020-04-16 | Douglas | Minnesota | 27041 | 1 | 0 |
65831 | 65831 | 2020-04-17 | Douglas | Minnesota | 27041 | 1 | 0 |
68582 | 68582 | 2020-04-18 | Douglas | Minnesota | 27041 | 1 | 0 |
94644 | 94644 | 2020-04-27 | Douglas | South Dakota | 46043 | 1 | 0 |
97484 | 97484 | 2020-04-28 | Douglas | South Dakota | 46043 | 1 | 0 |
100334 | 100334 | 2020-04-29 | Douglas | South Dakota | 46043 | 1 | 0 |
103187 | 103187 | 2020-04-30 | Douglas | South Dakota | 46043 | 1 | 0 |
106050 | 106050 | 2020-05-01 | Douglas | South Dakota | 46043 | 1 | 0 |
108917 | 108917 | 2020-05-02 | Douglas | South Dakota | 46043 | 1 | 0 |
111791 | 111791 | 2020-05-03 | Douglas | South Dakota | 46043 | 1 | 0 |
114673 | 114673 | 2020-05-04 | Douglas | South Dakota | 46043 | 1 | 0 |
117629 | 117629 | 2020-05-05 | Douglas | South Dakota | 46043 | 1 | 0 |
120591 | 120591 | 2020-05-06 | Douglas | South Dakota | 46043 | 1 | 0 |
123569 | 123569 | 2020-05-07 | Douglas | South Dakota | 46043 | 1 | 0 |
126552 | 126552 | 2020-05-08 | Douglas | South Dakota | 46043 | 1 | 0 |
129541 | 129541 | 2020-05-09 | Douglas | South Dakota | 46043 | 1 | 0 |
132530 | 132530 | 2020-05-10 | Douglas | South Dakota | 46043 | 1 | 0 |
135521 | 135521 | 2020-05-11 | Douglas | South Dakota | 46043 | 1 | 0 |
138511 | 138511 | 2020-05-12 | Douglas | South Dakota | 46043 | 1 | 0 |
141507 | 141507 | 2020-05-13 | Douglas | South Dakota | 46043 | 1 | 0 |
144503 | 144503 | 2020-05-14 | Douglas | South Dakota | 46043 | 1 | 0 |
147504 | 147504 | 2020-05-15 | Douglas | South Dakota | 46043 | 1 | 0 |
150512 | 150512 | 2020-05-16 | Douglas | South Dakota | 46043 | 1 | 0 |
153523 | 153523 | 2020-05-17 | Douglas | South Dakota | 46043 | 1 | 0 |
156540 | 156540 | 2020-05-18 | Douglas | South Dakota | 46043 | 1 | 0 |
159561 | 159561 | 2020-05-19 | Douglas | South Dakota | 46043 | 1 | 0 |
162588 | 162588 | 2020-05-20 | Douglas | South Dakota | 46043 | 1 | 0 |
165617 | 165617 | 2020-05-21 | Douglas | South Dakota | 46043 | 1 | 0 |
168653 | 168653 | 2020-05-22 | Douglas | South Dakota | 46043 | 1 | 0 |
195256 | 195256 | 2020-05-31 | Douglas | Missouri | 29067 | 1 | 0 |
198327 | 198327 | 2020-06-01 | Douglas | Missouri | 29067 | 1 | 0 |
9450 | 9450 | 2020-03-23 | Douglas | Wisconsin | 55031 | 2 | 0 |
10250 | 10250 | 2020-03-24 | Douglas | Nevada | 32005 | 2 | 0 |
10760 | 10760 | 2020-03-24 | Douglas | Washington | 53017 | 2 | 0 |
12282 | 12282 | 2020-03-25 | Douglas | Washington | 53017 | 2 | 0 |
71346 | 71346 | 2020-04-19 | Douglas | Minnesota | 27041 | 2 | 0 |
74119 | 74119 | 2020-04-20 | Douglas | Minnesota | 27041 | 2 | 0 |
76899 | 76899 | 2020-04-21 | Douglas | Minnesota | 27041 | 2 | 0 |
79684 | 79684 | 2020-04-22 | Douglas | Minnesota | 27041 | 2 | 0 |
82480 | 82480 | 2020-04-23 | Douglas | Minnesota | 27041 | 2 | 0 |
85284 | 85284 | 2020-04-24 | Douglas | Minnesota | 27041 | 2 | 0 |
88094 | 88094 | 2020-04-25 | Douglas | Minnesota | 27041 | 2 | 0 |
90910 | 90910 | 2020-04-26 | Douglas | Minnesota | 27041 | 2 | 0 |
93731 | 93731 | 2020-04-27 | Douglas | Minnesota | 27041 | 2 | 0 |
96566 | 96566 | 2020-04-28 | Douglas | Minnesota | 27041 | 2 | 0 |
99412 | 99412 | 2020-04-29 | Douglas | Minnesota | 27041 | 2 | 0 |
102264 | 102264 | 2020-04-30 | Douglas | Minnesota | 27041 | 2 | 0 |
105124 | 105124 | 2020-05-01 | Douglas | Minnesota | 27041 | 2 | 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);