ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Santa Barbara" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386166 | 386166 | 2020-07-31 | Santa Barbara | California | 6083 | 6273 | 60 |
382948 | 382948 | 2020-07-30 | Santa Barbara | California | 6083 | 6215 | 32 |
379731 | 379731 | 2020-07-29 | Santa Barbara | California | 6083 | 6110 | 32 |
376514 | 376514 | 2020-07-28 | Santa Barbara | California | 6083 | 6026 | 32 |
373300 | 373300 | 2020-07-27 | Santa Barbara | California | 6083 | 5939 | 32 |
370088 | 370088 | 2020-07-26 | Santa Barbara | California | 6083 | 5880 | 32 |
366878 | 366878 | 2020-07-25 | Santa Barbara | California | 6083 | 5776 | 32 |
363671 | 363671 | 2020-07-24 | Santa Barbara | California | 6083 | 5628 | 32 |
360464 | 360464 | 2020-07-23 | Santa Barbara | California | 6083 | 5508 | 32 |
357259 | 357259 | 2020-07-22 | Santa Barbara | California | 6083 | 5422 | 32 |
354056 | 354056 | 2020-07-21 | Santa Barbara | California | 6083 | 5266 | 32 |
350854 | 350854 | 2020-07-20 | Santa Barbara | California | 6083 | 5145 | 32 |
347653 | 347653 | 2020-07-19 | Santa Barbara | California | 6083 | 5110 | 32 |
344453 | 344453 | 2020-07-18 | Santa Barbara | California | 6083 | 5001 | 32 |
341254 | 341254 | 2020-07-17 | Santa Barbara | California | 6083 | 4872 | 32 |
338058 | 338058 | 2020-07-16 | Santa Barbara | California | 6083 | 4733 | 32 |
334863 | 334863 | 2020-07-15 | Santa Barbara | California | 6083 | 4641 | 32 |
331670 | 331670 | 2020-07-14 | Santa Barbara | California | 6083 | 4441 | 31 |
328484 | 328484 | 2020-07-13 | Santa Barbara | California | 6083 | 4353 | 31 |
325298 | 325298 | 2020-07-12 | Santa Barbara | California | 6083 | 4283 | 31 |
322117 | 322117 | 2020-07-11 | Santa Barbara | California | 6083 | 4177 | 31 |
318938 | 318938 | 2020-07-10 | Santa Barbara | California | 6083 | 4068 | 31 |
315765 | 315765 | 2020-07-09 | Santa Barbara | California | 6083 | 3985 | 29 |
312590 | 312590 | 2020-07-08 | Santa Barbara | California | 6083 | 3866 | 30 |
309420 | 309420 | 2020-07-07 | Santa Barbara | California | 6083 | 3763 | 30 |
306252 | 306252 | 2020-07-06 | Santa Barbara | California | 6083 | 3671 | 29 |
303088 | 303088 | 2020-07-05 | Santa Barbara | California | 6083 | 3520 | 29 |
299924 | 299924 | 2020-07-04 | Santa Barbara | California | 6083 | 3406 | 29 |
296762 | 296762 | 2020-07-03 | Santa Barbara | California | 6083 | 3385 | 29 |
293606 | 293606 | 2020-07-02 | Santa Barbara | California | 6083 | 3268 | 29 |
290452 | 290452 | 2020-07-01 | Santa Barbara | California | 6083 | 3164 | 29 |
287301 | 287301 | 2020-06-30 | Santa Barbara | California | 6083 | 2933 | 29 |
284155 | 284155 | 2020-06-29 | Santa Barbara | California | 6083 | 2872 | 28 |
281009 | 281009 | 2020-06-28 | Santa Barbara | California | 6083 | 2831 | 28 |
277862 | 277862 | 2020-06-27 | Santa Barbara | California | 6083 | 2784 | 28 |
274714 | 274714 | 2020-06-26 | Santa Barbara | California | 6083 | 2666 | 28 |
271574 | 271574 | 2020-06-25 | Santa Barbara | California | 6083 | 2591 | 27 |
268439 | 268439 | 2020-06-24 | Santa Barbara | California | 6083 | 2553 | 27 |
265309 | 265309 | 2020-06-23 | Santa Barbara | California | 6083 | 2478 | 27 |
262181 | 262181 | 2020-06-22 | Santa Barbara | California | 6083 | 2430 | 22 |
259054 | 259054 | 2020-06-21 | Santa Barbara | California | 6083 | 2358 | 22 |
255927 | 255927 | 2020-06-20 | Santa Barbara | California | 6083 | 2293 | 22 |
252808 | 252808 | 2020-06-19 | Santa Barbara | California | 6083 | 2293 | 22 |
249693 | 249693 | 2020-06-18 | Santa Barbara | California | 6083 | 2228 | 22 |
246581 | 246581 | 2020-06-17 | Santa Barbara | California | 6083 | 2155 | 21 |
243468 | 243468 | 2020-06-16 | Santa Barbara | California | 6083 | 2100 | 18 |
240357 | 240357 | 2020-06-15 | Santa Barbara | California | 6083 | 2049 | 18 |
237249 | 237249 | 2020-06-14 | Santa Barbara | California | 6083 | 1999 | 18 |
234142 | 234142 | 2020-06-13 | Santa Barbara | California | 6083 | 1969 | 16 |
231036 | 231036 | 2020-06-12 | Santa Barbara | California | 6083 | 1959 | 16 |
227933 | 227933 | 2020-06-11 | Santa Barbara | California | 6083 | 1899 | 16 |
224831 | 224831 | 2020-06-10 | Santa Barbara | California | 6083 | 1855 | 15 |
221736 | 221736 | 2020-06-09 | Santa Barbara | California | 6083 | 1838 | 15 |
218641 | 218641 | 2020-06-08 | Santa Barbara | California | 6083 | 1818 | 15 |
215550 | 215550 | 2020-06-07 | Santa Barbara | California | 6083 | 1815 | 15 |
212463 | 212463 | 2020-06-06 | Santa Barbara | California | 6083 | 1795 | 15 |
209378 | 209378 | 2020-06-05 | Santa Barbara | California | 6083 | 1779 | 14 |
206297 | 206297 | 2020-06-04 | Santa Barbara | California | 6083 | 1729 | 14 |
203217 | 203217 | 2020-06-03 | Santa Barbara | California | 6083 | 1708 | 14 |
200141 | 200141 | 2020-06-02 | Santa Barbara | California | 6083 | 1686 | 12 |
197068 | 197068 | 2020-06-01 | Santa Barbara | California | 6083 | 1662 | 12 |
193998 | 193998 | 2020-05-31 | Santa Barbara | California | 6083 | 1660 | 12 |
190931 | 190931 | 2020-05-30 | Santa Barbara | California | 6083 | 1656 | 12 |
187866 | 187866 | 2020-05-29 | Santa Barbara | California | 6083 | 1642 | 12 |
184810 | 184810 | 2020-05-28 | Santa Barbara | California | 6083 | 1629 | 12 |
181756 | 181756 | 2020-05-27 | Santa Barbara | California | 6083 | 1616 | 12 |
178712 | 178712 | 2020-05-26 | Santa Barbara | California | 6083 | 1597 | 12 |
175668 | 175668 | 2020-05-25 | Santa Barbara | California | 6083 | 1573 | 12 |
172624 | 172624 | 2020-05-24 | Santa Barbara | California | 6083 | 1566 | 12 |
169583 | 169583 | 2020-05-23 | Santa Barbara | California | 6083 | 1554 | 12 |
166546 | 166546 | 2020-05-22 | Santa Barbara | California | 6083 | 1544 | 11 |
163514 | 163514 | 2020-05-21 | Santa Barbara | California | 6083 | 1533 | 11 |
160486 | 160486 | 2020-05-20 | Santa Barbara | California | 6083 | 1521 | 11 |
157460 | 157460 | 2020-05-19 | Santa Barbara | California | 6083 | 1509 | 11 |
154444 | 154444 | 2020-05-18 | Santa Barbara | California | 6083 | 1489 | 11 |
151432 | 151432 | 2020-05-17 | Santa Barbara | California | 6083 | 1468 | 11 |
148423 | 148423 | 2020-05-16 | Santa Barbara | California | 6083 | 1412 | 11 |
145419 | 145419 | 2020-05-15 | Santa Barbara | California | 6083 | 1396 | 11 |
142420 | 142420 | 2020-05-14 | Santa Barbara | California | 6083 | 1382 | 11 |
139424 | 139424 | 2020-05-13 | Santa Barbara | California | 6083 | 1377 | 11 |
136433 | 136433 | 2020-05-12 | Santa Barbara | California | 6083 | 1372 | 11 |
133443 | 133443 | 2020-05-11 | Santa Barbara | California | 6083 | 1362 | 11 |
130453 | 130453 | 2020-05-10 | Santa Barbara | California | 6083 | 1308 | 11 |
127463 | 127463 | 2020-05-09 | Santa Barbara | California | 6083 | 1250 | 11 |
124478 | 124478 | 2020-05-08 | Santa Barbara | California | 6083 | 1032 | 11 |
121498 | 121498 | 2020-05-07 | Santa Barbara | California | 6083 | 722 | 11 |
118531 | 118531 | 2020-05-06 | Santa Barbara | California | 6083 | 613 | 10 |
115572 | 115572 | 2020-05-05 | Santa Barbara | California | 6083 | 544 | 9 |
112689 | 112689 | 2020-05-04 | Santa Barbara | California | 6083 | 526 | 8 |
109814 | 109814 | 2020-05-03 | Santa Barbara | California | 6083 | 514 | 8 |
106945 | 106945 | 2020-05-02 | Santa Barbara | California | 6083 | 508 | 8 |
104080 | 104080 | 2020-05-01 | Santa Barbara | California | 6083 | 506 | 8 |
101225 | 101225 | 2020-04-30 | Santa Barbara | California | 6083 | 496 | 8 |
98375 | 98375 | 2020-04-29 | Santa Barbara | California | 6083 | 485 | 8 |
95530 | 95530 | 2020-04-28 | Santa Barbara | California | 6083 | 477 | 7 |
92698 | 92698 | 2020-04-27 | Santa Barbara | California | 6083 | 471 | 7 |
89880 | 89880 | 2020-04-26 | Santa Barbara | California | 6083 | 471 | 7 |
87063 | 87063 | 2020-04-25 | Santa Barbara | California | 6083 | 466 | 6 |
84255 | 84255 | 2020-04-24 | Santa Barbara | California | 6083 | 460 | 6 |
81455 | 81455 | 2020-04-23 | Santa Barbara | California | 6083 | 451 | 5 |
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);