ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Mendocino" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3802 | 3802 | 2020-03-18 | Mendocino | California | 6045 | 1 | 0 |
4462 | 4462 | 2020-03-19 | Mendocino | California | 6045 | 1 | 0 |
5237 | 5237 | 2020-03-20 | Mendocino | California | 6045 | 1 | 0 |
6158 | 6158 | 2020-03-21 | Mendocino | California | 6045 | 1 | 0 |
7192 | 7192 | 2020-03-22 | Mendocino | California | 6045 | 1 | 0 |
8335 | 8335 | 2020-03-23 | Mendocino | California | 6045 | 1 | 0 |
9576 | 9576 | 2020-03-24 | Mendocino | California | 6045 | 2 | 0 |
10948 | 10948 | 2020-03-25 | Mendocino | California | 6045 | 2 | 0 |
12493 | 12493 | 2020-03-26 | Mendocino | California | 6045 | 2 | 0 |
14159 | 14159 | 2020-03-27 | Mendocino | California | 6045 | 2 | 0 |
15941 | 15941 | 2020-03-28 | Mendocino | California | 6045 | 2 | 0 |
17830 | 17830 | 2020-03-29 | Mendocino | California | 6045 | 3 | 0 |
19807 | 19807 | 2020-03-30 | Mendocino | California | 6045 | 4 | 0 |
21881 | 21881 | 2020-03-31 | Mendocino | California | 6045 | 4 | 0 |
24039 | 24039 | 2020-04-01 | Mendocino | California | 6045 | 4 | 0 |
26268 | 26268 | 2020-04-02 | Mendocino | California | 6045 | 4 | 0 |
28567 | 28567 | 2020-04-03 | Mendocino | California | 6045 | 4 | 0 |
30925 | 30925 | 2020-04-04 | Mendocino | California | 6045 | 4 | 0 |
33331 | 33331 | 2020-04-05 | Mendocino | California | 6045 | 4 | 0 |
35776 | 35776 | 2020-04-06 | Mendocino | California | 6045 | 4 | 0 |
38265 | 38265 | 2020-04-07 | Mendocino | California | 6045 | 4 | 0 |
40809 | 40809 | 2020-04-08 | Mendocino | California | 6045 | 4 | 0 |
43381 | 43381 | 2020-04-09 | Mendocino | California | 6045 | 4 | 0 |
45981 | 45981 | 2020-04-10 | Mendocino | California | 6045 | 4 | 0 |
48611 | 48611 | 2020-04-11 | Mendocino | California | 6045 | 4 | 0 |
51273 | 51273 | 2020-04-12 | Mendocino | California | 6045 | 4 | 0 |
53952 | 53952 | 2020-04-13 | Mendocino | California | 6045 | 4 | 0 |
56644 | 56644 | 2020-04-14 | Mendocino | California | 6045 | 4 | 0 |
59352 | 59352 | 2020-04-15 | Mendocino | California | 6045 | 4 | 0 |
62071 | 62071 | 2020-04-16 | Mendocino | California | 6045 | 4 | 0 |
64804 | 64804 | 2020-04-17 | Mendocino | California | 6045 | 4 | 0 |
67552 | 67552 | 2020-04-18 | Mendocino | California | 6045 | 5 | 0 |
70314 | 70314 | 2020-04-19 | Mendocino | California | 6045 | 5 | 0 |
73083 | 73083 | 2020-04-20 | Mendocino | California | 6045 | 5 | 0 |
75859 | 75859 | 2020-04-21 | Mendocino | California | 6045 | 5 | 0 |
78643 | 78643 | 2020-04-22 | Mendocino | California | 6045 | 5 | 0 |
81437 | 81437 | 2020-04-23 | Mendocino | California | 6045 | 5 | 0 |
84237 | 84237 | 2020-04-24 | Mendocino | California | 6045 | 11 | 0 |
87045 | 87045 | 2020-04-25 | Mendocino | California | 6045 | 11 | 0 |
89862 | 89862 | 2020-04-26 | Mendocino | California | 6045 | 11 | 0 |
92680 | 92680 | 2020-04-27 | Mendocino | California | 6045 | 11 | 0 |
95512 | 95512 | 2020-04-28 | Mendocino | California | 6045 | 11 | 0 |
98357 | 98357 | 2020-04-29 | Mendocino | California | 6045 | 12 | 0 |
101207 | 101207 | 2020-04-30 | Mendocino | California | 6045 | 12 | 0 |
104062 | 104062 | 2020-05-01 | Mendocino | California | 6045 | 12 | 0 |
106927 | 106927 | 2020-05-02 | Mendocino | California | 6045 | 12 | 0 |
109796 | 109796 | 2020-05-03 | Mendocino | California | 6045 | 12 | 0 |
112671 | 112671 | 2020-05-04 | Mendocino | California | 6045 | 12 | 0 |
115554 | 115554 | 2020-05-05 | Mendocino | California | 6045 | 12 | 0 |
118513 | 118513 | 2020-05-06 | Mendocino | California | 6045 | 40 | 0 |
121480 | 121480 | 2020-05-07 | Mendocino | California | 6045 | 12 | 0 |
124460 | 124460 | 2020-05-08 | Mendocino | California | 6045 | 12 | 0 |
127445 | 127445 | 2020-05-09 | Mendocino | California | 6045 | 12 | 0 |
130435 | 130435 | 2020-05-10 | Mendocino | California | 6045 | 12 | 0 |
133425 | 133425 | 2020-05-11 | Mendocino | California | 6045 | 12 | 0 |
136415 | 136415 | 2020-05-12 | Mendocino | California | 6045 | 12 | 0 |
139406 | 139406 | 2020-05-13 | Mendocino | California | 6045 | 13 | 0 |
142402 | 142402 | 2020-05-14 | Mendocino | California | 6045 | 13 | 0 |
145401 | 145401 | 2020-05-15 | Mendocino | California | 6045 | 13 | 0 |
148405 | 148405 | 2020-05-16 | Mendocino | California | 6045 | 13 | 0 |
151414 | 151414 | 2020-05-17 | Mendocino | California | 6045 | 14 | 0 |
154426 | 154426 | 2020-05-18 | Mendocino | California | 6045 | 14 | 0 |
157442 | 157442 | 2020-05-19 | Mendocino | California | 6045 | 15 | 0 |
160468 | 160468 | 2020-05-20 | Mendocino | California | 6045 | 15 | 0 |
163496 | 163496 | 2020-05-21 | Mendocino | California | 6045 | 15 | 0 |
166528 | 166528 | 2020-05-22 | Mendocino | California | 6045 | 21 | 0 |
169565 | 169565 | 2020-05-23 | Mendocino | California | 6045 | 21 | 0 |
172606 | 172606 | 2020-05-24 | Mendocino | California | 6045 | 21 | 0 |
175650 | 175650 | 2020-05-25 | Mendocino | California | 6045 | 22 | 0 |
178694 | 178694 | 2020-05-26 | Mendocino | California | 6045 | 23 | 0 |
181738 | 181738 | 2020-05-27 | Mendocino | California | 6045 | 25 | 0 |
184792 | 184792 | 2020-05-28 | Mendocino | California | 6045 | 30 | 0 |
187848 | 187848 | 2020-05-29 | Mendocino | California | 6045 | 30 | 0 |
190913 | 190913 | 2020-05-30 | Mendocino | California | 6045 | 30 | 0 |
193980 | 193980 | 2020-05-31 | Mendocino | California | 6045 | 30 | 0 |
197050 | 197050 | 2020-06-01 | Mendocino | California | 6045 | 30 | 0 |
200123 | 200123 | 2020-06-02 | Mendocino | California | 6045 | 30 | 0 |
203199 | 203199 | 2020-06-03 | Mendocino | California | 6045 | 33 | 0 |
206279 | 206279 | 2020-06-04 | Mendocino | California | 6045 | 33 | 0 |
209360 | 209360 | 2020-06-05 | Mendocino | California | 6045 | 33 | 0 |
212445 | 212445 | 2020-06-06 | Mendocino | California | 6045 | 33 | 0 |
215532 | 215532 | 2020-06-07 | Mendocino | California | 6045 | 33 | 0 |
218623 | 218623 | 2020-06-08 | Mendocino | California | 6045 | 36 | 0 |
221718 | 221718 | 2020-06-09 | Mendocino | California | 6045 | 36 | 0 |
224813 | 224813 | 2020-06-10 | Mendocino | California | 6045 | 36 | 0 |
227915 | 227915 | 2020-06-11 | Mendocino | California | 6045 | 36 | 0 |
231018 | 231018 | 2020-06-12 | Mendocino | California | 6045 | 38 | 0 |
234124 | 234124 | 2020-06-13 | Mendocino | California | 6045 | 38 | 0 |
237231 | 237231 | 2020-06-14 | Mendocino | California | 6045 | 38 | 0 |
240339 | 240339 | 2020-06-15 | Mendocino | California | 6045 | 45 | 0 |
243450 | 243450 | 2020-06-16 | Mendocino | California | 6045 | 47 | 0 |
246563 | 246563 | 2020-06-17 | Mendocino | California | 6045 | 47 | 0 |
249675 | 249675 | 2020-06-18 | Mendocino | California | 6045 | 54 | 0 |
252790 | 252790 | 2020-06-19 | Mendocino | California | 6045 | 54 | 0 |
255909 | 255909 | 2020-06-20 | Mendocino | California | 6045 | 54 | 0 |
259036 | 259036 | 2020-06-21 | Mendocino | California | 6045 | 54 | 0 |
262163 | 262163 | 2020-06-22 | Mendocino | California | 6045 | 62 | 0 |
265291 | 265291 | 2020-06-23 | Mendocino | California | 6045 | 72 | 0 |
268421 | 268421 | 2020-06-24 | Mendocino | California | 6045 | 72 | 0 |
271556 | 271556 | 2020-06-25 | Mendocino | California | 6045 | 74 | 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);