ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
746 rows where county = "Mariposa" and state = "California" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
95511 | 95511 | 2020-04-28 | Mariposa | California | 6043 | 1 | 0 |
98356 | 98356 | 2020-04-29 | Mariposa | California | 6043 | 1 | 0 |
101206 | 101206 | 2020-04-30 | Mariposa | California | 6043 | 3 | 0 |
104061 | 104061 | 2020-05-01 | Mariposa | California | 6043 | 13 | 0 |
106926 | 106926 | 2020-05-02 | Mariposa | California | 6043 | 13 | 0 |
109795 | 109795 | 2020-05-03 | Mariposa | California | 6043 | 13 | 0 |
112670 | 112670 | 2020-05-04 | Mariposa | California | 6043 | 14 | 0 |
115553 | 115553 | 2020-05-05 | Mariposa | California | 6043 | 14 | 0 |
118512 | 118512 | 2020-05-06 | Mariposa | California | 6043 | 15 | 0 |
121479 | 121479 | 2020-05-07 | Mariposa | California | 6043 | 15 | 0 |
124459 | 124459 | 2020-05-08 | Mariposa | California | 6043 | 15 | 0 |
127444 | 127444 | 2020-05-09 | Mariposa | California | 6043 | 15 | 0 |
130434 | 130434 | 2020-05-10 | Mariposa | California | 6043 | 15 | 0 |
133424 | 133424 | 2020-05-11 | Mariposa | California | 6043 | 15 | 0 |
136414 | 136414 | 2020-05-12 | Mariposa | California | 6043 | 15 | 0 |
139405 | 139405 | 2020-05-13 | Mariposa | California | 6043 | 15 | 0 |
142401 | 142401 | 2020-05-14 | Mariposa | California | 6043 | 15 | 0 |
145400 | 145400 | 2020-05-15 | Mariposa | California | 6043 | 15 | 1 |
148404 | 148404 | 2020-05-16 | Mariposa | California | 6043 | 15 | 1 |
151413 | 151413 | 2020-05-17 | Mariposa | California | 6043 | 15 | 1 |
154425 | 154425 | 2020-05-18 | Mariposa | California | 6043 | 15 | 1 |
157441 | 157441 | 2020-05-19 | Mariposa | California | 6043 | 15 | 1 |
160467 | 160467 | 2020-05-20 | Mariposa | California | 6043 | 15 | 1 |
163495 | 163495 | 2020-05-21 | Mariposa | California | 6043 | 15 | 1 |
166527 | 166527 | 2020-05-22 | Mariposa | California | 6043 | 15 | 1 |
169564 | 169564 | 2020-05-23 | Mariposa | California | 6043 | 15 | 1 |
172605 | 172605 | 2020-05-24 | Mariposa | California | 6043 | 15 | 1 |
175649 | 175649 | 2020-05-25 | Mariposa | California | 6043 | 15 | 1 |
178693 | 178693 | 2020-05-26 | Mariposa | California | 6043 | 16 | 1 |
181737 | 181737 | 2020-05-27 | Mariposa | California | 6043 | 16 | 1 |
184791 | 184791 | 2020-05-28 | Mariposa | California | 6043 | 16 | 1 |
187847 | 187847 | 2020-05-29 | Mariposa | California | 6043 | 16 | 1 |
190912 | 190912 | 2020-05-30 | Mariposa | California | 6043 | 16 | 1 |
193979 | 193979 | 2020-05-31 | Mariposa | California | 6043 | 16 | 1 |
197049 | 197049 | 2020-06-01 | Mariposa | California | 6043 | 16 | 1 |
200122 | 200122 | 2020-06-02 | Mariposa | California | 6043 | 16 | 1 |
203198 | 203198 | 2020-06-03 | Mariposa | California | 6043 | 16 | 1 |
206278 | 206278 | 2020-06-04 | Mariposa | California | 6043 | 16 | 1 |
209359 | 209359 | 2020-06-05 | Mariposa | California | 6043 | 16 | 1 |
212444 | 212444 | 2020-06-06 | Mariposa | California | 6043 | 16 | 1 |
215531 | 215531 | 2020-06-07 | Mariposa | California | 6043 | 16 | 1 |
218622 | 218622 | 2020-06-08 | Mariposa | California | 6043 | 16 | 1 |
221717 | 221717 | 2020-06-09 | Mariposa | California | 6043 | 16 | 1 |
224812 | 224812 | 2020-06-10 | Mariposa | California | 6043 | 16 | 1 |
227914 | 227914 | 2020-06-11 | Mariposa | California | 6043 | 16 | 1 |
231017 | 231017 | 2020-06-12 | Mariposa | California | 6043 | 16 | 1 |
234123 | 234123 | 2020-06-13 | Mariposa | California | 6043 | 16 | 1 |
237230 | 237230 | 2020-06-14 | Mariposa | California | 6043 | 16 | 1 |
240338 | 240338 | 2020-06-15 | Mariposa | California | 6043 | 17 | 1 |
243449 | 243449 | 2020-06-16 | Mariposa | California | 6043 | 17 | 1 |
246562 | 246562 | 2020-06-17 | Mariposa | California | 6043 | 18 | 1 |
249674 | 249674 | 2020-06-18 | Mariposa | California | 6043 | 18 | 1 |
252789 | 252789 | 2020-06-19 | Mariposa | California | 6043 | 18 | 1 |
255908 | 255908 | 2020-06-20 | Mariposa | California | 6043 | 18 | 1 |
259035 | 259035 | 2020-06-21 | Mariposa | California | 6043 | 18 | 1 |
262162 | 262162 | 2020-06-22 | Mariposa | California | 6043 | 18 | 1 |
265290 | 265290 | 2020-06-23 | Mariposa | California | 6043 | 21 | 1 |
268420 | 268420 | 2020-06-24 | Mariposa | California | 6043 | 21 | 1 |
271555 | 271555 | 2020-06-25 | Mariposa | California | 6043 | 22 | 1 |
274695 | 274695 | 2020-06-26 | Mariposa | California | 6043 | 23 | 1 |
277843 | 277843 | 2020-06-27 | Mariposa | California | 6043 | 23 | 1 |
280990 | 280990 | 2020-06-28 | Mariposa | California | 6043 | 23 | 1 |
284136 | 284136 | 2020-06-29 | Mariposa | California | 6043 | 25 | 1 |
287282 | 287282 | 2020-06-30 | Mariposa | California | 6043 | 26 | 1 |
290433 | 290433 | 2020-07-01 | Mariposa | California | 6043 | 27 | 1 |
296743 | 296743 | 2020-07-03 | Mariposa | California | 6043 | 28 | 1 |
299905 | 299905 | 2020-07-04 | Mariposa | California | 6043 | 28 | 1 |
303069 | 303069 | 2020-07-05 | Mariposa | California | 6043 | 28 | 1 |
293587 | 293587 | 2020-07-02 | Mariposa | California | 6043 | 29 | 1 |
306233 | 306233 | 2020-07-06 | Mariposa | California | 6043 | 31 | 1 |
309401 | 309401 | 2020-07-07 | Mariposa | California | 6043 | 31 | 1 |
312571 | 312571 | 2020-07-08 | Mariposa | California | 6043 | 31 | 1 |
315746 | 315746 | 2020-07-09 | Mariposa | California | 6043 | 31 | 1 |
322098 | 322098 | 2020-07-11 | Mariposa | California | 6043 | 31 | 1 |
318919 | 318919 | 2020-07-10 | Mariposa | California | 6043 | 32 | 1 |
325279 | 325279 | 2020-07-12 | Mariposa | California | 6043 | 32 | 1 |
328465 | 328465 | 2020-07-13 | Mariposa | California | 6043 | 33 | 1 |
331651 | 331651 | 2020-07-14 | Mariposa | California | 6043 | 34 | 1 |
334844 | 334844 | 2020-07-15 | Mariposa | California | 6043 | 35 | 1 |
338039 | 338039 | 2020-07-16 | Mariposa | California | 6043 | 35 | 1 |
341235 | 341235 | 2020-07-17 | Mariposa | California | 6043 | 35 | 1 |
344434 | 344434 | 2020-07-18 | Mariposa | California | 6043 | 36 | 1 |
347634 | 347634 | 2020-07-19 | Mariposa | California | 6043 | 37 | 1 |
350835 | 350835 | 2020-07-20 | Mariposa | California | 6043 | 38 | 1 |
354037 | 354037 | 2020-07-21 | Mariposa | California | 6043 | 41 | 1 |
357240 | 357240 | 2020-07-22 | Mariposa | California | 6043 | 41 | 1 |
360445 | 360445 | 2020-07-23 | Mariposa | California | 6043 | 44 | 1 |
363652 | 363652 | 2020-07-24 | Mariposa | California | 6043 | 46 | 1 |
366859 | 366859 | 2020-07-25 | Mariposa | California | 6043 | 46 | 1 |
370069 | 370069 | 2020-07-26 | Mariposa | California | 6043 | 46 | 2 |
373281 | 373281 | 2020-07-27 | Mariposa | California | 6043 | 48 | 2 |
376495 | 376495 | 2020-07-28 | Mariposa | California | 6043 | 51 | 2 |
379711 | 379711 | 2020-07-29 | Mariposa | California | 6043 | 51 | 2 |
382928 | 382928 | 2020-07-30 | Mariposa | California | 6043 | 53 | 2 |
386146 | 386146 | 2020-07-31 | Mariposa | California | 6043 | 54 | 2 |
389363 | 389363 | 2020-08-01 | Mariposa | California | 6043 | 56 | 2 |
392580 | 392580 | 2020-08-02 | Mariposa | California | 6043 | 57 | 2 |
395796 | 395796 | 2020-08-03 | Mariposa | California | 6043 | 58 | 2 |
399012 | 399012 | 2020-08-04 | Mariposa | California | 6043 | 59 | 2 |
402228 | 402228 | 2020-08-05 | Mariposa | California | 6043 | 59 | 2 |
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);