ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where county = "Mendocino", deaths = 0 and fips = 6045 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
350836 | 350836 | 2020-07-20 | Mendocino | California | 6045 | 207 | 0 |
347635 | 347635 | 2020-07-19 | Mendocino | California | 6045 | 199 | 0 |
344435 | 344435 | 2020-07-18 | Mendocino | California | 6045 | 194 | 0 |
341236 | 341236 | 2020-07-17 | Mendocino | California | 6045 | 185 | 0 |
338040 | 338040 | 2020-07-16 | Mendocino | California | 6045 | 177 | 0 |
334845 | 334845 | 2020-07-15 | Mendocino | California | 6045 | 165 | 0 |
331652 | 331652 | 2020-07-14 | Mendocino | California | 6045 | 155 | 0 |
328466 | 328466 | 2020-07-13 | Mendocino | California | 6045 | 146 | 0 |
325280 | 325280 | 2020-07-12 | Mendocino | California | 6045 | 132 | 0 |
322099 | 322099 | 2020-07-11 | Mendocino | California | 6045 | 113 | 0 |
318920 | 318920 | 2020-07-10 | Mendocino | California | 6045 | 113 | 0 |
315747 | 315747 | 2020-07-09 | Mendocino | California | 6045 | 107 | 0 |
312572 | 312572 | 2020-07-08 | Mendocino | California | 6045 | 107 | 0 |
309402 | 309402 | 2020-07-07 | Mendocino | California | 6045 | 92 | 0 |
306234 | 306234 | 2020-07-06 | Mendocino | California | 6045 | 92 | 0 |
303070 | 303070 | 2020-07-05 | Mendocino | California | 6045 | 85 | 0 |
299906 | 299906 | 2020-07-04 | Mendocino | California | 6045 | 85 | 0 |
296744 | 296744 | 2020-07-03 | Mendocino | California | 6045 | 85 | 0 |
293588 | 293588 | 2020-07-02 | Mendocino | California | 6045 | 85 | 0 |
290434 | 290434 | 2020-07-01 | Mendocino | California | 6045 | 85 | 0 |
287283 | 287283 | 2020-06-30 | Mendocino | California | 6045 | 83 | 0 |
284137 | 284137 | 2020-06-29 | Mendocino | California | 6045 | 76 | 0 |
280991 | 280991 | 2020-06-28 | Mendocino | California | 6045 | 76 | 0 |
277844 | 277844 | 2020-06-27 | Mendocino | California | 6045 | 76 | 0 |
274696 | 274696 | 2020-06-26 | Mendocino | California | 6045 | 76 | 0 |
271556 | 271556 | 2020-06-25 | Mendocino | California | 6045 | 74 | 0 |
268421 | 268421 | 2020-06-24 | Mendocino | California | 6045 | 72 | 0 |
265291 | 265291 | 2020-06-23 | Mendocino | California | 6045 | 72 | 0 |
262163 | 262163 | 2020-06-22 | Mendocino | California | 6045 | 62 | 0 |
259036 | 259036 | 2020-06-21 | Mendocino | California | 6045 | 54 | 0 |
255909 | 255909 | 2020-06-20 | Mendocino | California | 6045 | 54 | 0 |
252790 | 252790 | 2020-06-19 | Mendocino | California | 6045 | 54 | 0 |
249675 | 249675 | 2020-06-18 | Mendocino | California | 6045 | 54 | 0 |
246563 | 246563 | 2020-06-17 | Mendocino | California | 6045 | 47 | 0 |
243450 | 243450 | 2020-06-16 | Mendocino | California | 6045 | 47 | 0 |
240339 | 240339 | 2020-06-15 | Mendocino | California | 6045 | 45 | 0 |
237231 | 237231 | 2020-06-14 | Mendocino | California | 6045 | 38 | 0 |
234124 | 234124 | 2020-06-13 | Mendocino | California | 6045 | 38 | 0 |
231018 | 231018 | 2020-06-12 | Mendocino | California | 6045 | 38 | 0 |
227915 | 227915 | 2020-06-11 | Mendocino | California | 6045 | 36 | 0 |
224813 | 224813 | 2020-06-10 | Mendocino | California | 6045 | 36 | 0 |
221718 | 221718 | 2020-06-09 | Mendocino | California | 6045 | 36 | 0 |
218623 | 218623 | 2020-06-08 | Mendocino | California | 6045 | 36 | 0 |
215532 | 215532 | 2020-06-07 | Mendocino | California | 6045 | 33 | 0 |
212445 | 212445 | 2020-06-06 | Mendocino | California | 6045 | 33 | 0 |
209360 | 209360 | 2020-06-05 | Mendocino | California | 6045 | 33 | 0 |
206279 | 206279 | 2020-06-04 | Mendocino | California | 6045 | 33 | 0 |
203199 | 203199 | 2020-06-03 | Mendocino | California | 6045 | 33 | 0 |
200123 | 200123 | 2020-06-02 | Mendocino | California | 6045 | 30 | 0 |
197050 | 197050 | 2020-06-01 | Mendocino | California | 6045 | 30 | 0 |
193980 | 193980 | 2020-05-31 | Mendocino | California | 6045 | 30 | 0 |
190913 | 190913 | 2020-05-30 | Mendocino | California | 6045 | 30 | 0 |
187848 | 187848 | 2020-05-29 | Mendocino | California | 6045 | 30 | 0 |
184792 | 184792 | 2020-05-28 | Mendocino | California | 6045 | 30 | 0 |
181738 | 181738 | 2020-05-27 | Mendocino | California | 6045 | 25 | 0 |
178694 | 178694 | 2020-05-26 | Mendocino | California | 6045 | 23 | 0 |
175650 | 175650 | 2020-05-25 | Mendocino | California | 6045 | 22 | 0 |
172606 | 172606 | 2020-05-24 | Mendocino | California | 6045 | 21 | 0 |
169565 | 169565 | 2020-05-23 | Mendocino | California | 6045 | 21 | 0 |
166528 | 166528 | 2020-05-22 | Mendocino | California | 6045 | 21 | 0 |
163496 | 163496 | 2020-05-21 | Mendocino | California | 6045 | 15 | 0 |
160468 | 160468 | 2020-05-20 | Mendocino | California | 6045 | 15 | 0 |
157442 | 157442 | 2020-05-19 | Mendocino | California | 6045 | 15 | 0 |
154426 | 154426 | 2020-05-18 | Mendocino | California | 6045 | 14 | 0 |
151414 | 151414 | 2020-05-17 | Mendocino | California | 6045 | 14 | 0 |
148405 | 148405 | 2020-05-16 | Mendocino | California | 6045 | 13 | 0 |
145401 | 145401 | 2020-05-15 | Mendocino | California | 6045 | 13 | 0 |
142402 | 142402 | 2020-05-14 | Mendocino | California | 6045 | 13 | 0 |
139406 | 139406 | 2020-05-13 | Mendocino | California | 6045 | 13 | 0 |
136415 | 136415 | 2020-05-12 | Mendocino | California | 6045 | 12 | 0 |
133425 | 133425 | 2020-05-11 | Mendocino | California | 6045 | 12 | 0 |
130435 | 130435 | 2020-05-10 | Mendocino | California | 6045 | 12 | 0 |
127445 | 127445 | 2020-05-09 | Mendocino | California | 6045 | 12 | 0 |
124460 | 124460 | 2020-05-08 | Mendocino | California | 6045 | 12 | 0 |
121480 | 121480 | 2020-05-07 | Mendocino | California | 6045 | 12 | 0 |
118513 | 118513 | 2020-05-06 | Mendocino | California | 6045 | 40 | 0 |
115554 | 115554 | 2020-05-05 | Mendocino | California | 6045 | 12 | 0 |
112671 | 112671 | 2020-05-04 | Mendocino | California | 6045 | 12 | 0 |
109796 | 109796 | 2020-05-03 | Mendocino | California | 6045 | 12 | 0 |
106927 | 106927 | 2020-05-02 | Mendocino | California | 6045 | 12 | 0 |
104062 | 104062 | 2020-05-01 | Mendocino | California | 6045 | 12 | 0 |
101207 | 101207 | 2020-04-30 | Mendocino | California | 6045 | 12 | 0 |
98357 | 98357 | 2020-04-29 | Mendocino | California | 6045 | 12 | 0 |
95512 | 95512 | 2020-04-28 | Mendocino | California | 6045 | 11 | 0 |
92680 | 92680 | 2020-04-27 | Mendocino | California | 6045 | 11 | 0 |
89862 | 89862 | 2020-04-26 | Mendocino | California | 6045 | 11 | 0 |
87045 | 87045 | 2020-04-25 | Mendocino | California | 6045 | 11 | 0 |
84237 | 84237 | 2020-04-24 | Mendocino | California | 6045 | 11 | 0 |
81437 | 81437 | 2020-04-23 | Mendocino | California | 6045 | 5 | 0 |
78643 | 78643 | 2020-04-22 | Mendocino | California | 6045 | 5 | 0 |
75859 | 75859 | 2020-04-21 | Mendocino | California | 6045 | 5 | 0 |
73083 | 73083 | 2020-04-20 | Mendocino | California | 6045 | 5 | 0 |
70314 | 70314 | 2020-04-19 | Mendocino | California | 6045 | 5 | 0 |
67552 | 67552 | 2020-04-18 | Mendocino | California | 6045 | 5 | 0 |
64804 | 64804 | 2020-04-17 | Mendocino | California | 6045 | 4 | 0 |
62071 | 62071 | 2020-04-16 | Mendocino | California | 6045 | 4 | 0 |
59352 | 59352 | 2020-04-15 | Mendocino | California | 6045 | 4 | 0 |
56644 | 56644 | 2020-04-14 | Mendocino | California | 6045 | 4 | 0 |
53952 | 53952 | 2020-04-13 | Mendocino | California | 6045 | 4 | 0 |
51273 | 51273 | 2020-04-12 | Mendocino | California | 6045 | 4 | 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);