ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 6083 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635112 | 635112 | 2020-10-16 | Santa Barbara | California | 6083 | 9560 | 119 |
631866 | 631866 | 2020-10-15 | Santa Barbara | California | 6083 | 9540 | 118 |
628622 | 628622 | 2020-10-14 | Santa Barbara | California | 6083 | 9520 | 117 |
625379 | 625379 | 2020-10-13 | Santa Barbara | California | 6083 | 9503 | 116 |
622136 | 622136 | 2020-10-12 | Santa Barbara | California | 6083 | 9475 | 116 |
618893 | 618893 | 2020-10-11 | Santa Barbara | California | 6083 | 9417 | 116 |
615651 | 615651 | 2020-10-10 | Santa Barbara | California | 6083 | 9408 | 116 |
612410 | 612410 | 2020-10-09 | Santa Barbara | California | 6083 | 9408 | 116 |
609168 | 609168 | 2020-10-08 | Santa Barbara | California | 6083 | 9387 | 115 |
605925 | 605925 | 2020-10-07 | Santa Barbara | California | 6083 | 9363 | 115 |
602683 | 602683 | 2020-10-06 | Santa Barbara | California | 6083 | 9340 | 115 |
599440 | 599440 | 2020-10-05 | Santa Barbara | California | 6083 | 9319 | 115 |
596197 | 596197 | 2020-10-04 | Santa Barbara | California | 6083 | 9256 | 115 |
592955 | 592955 | 2020-10-03 | Santa Barbara | California | 6083 | 9249 | 115 |
589715 | 589715 | 2020-10-02 | Santa Barbara | California | 6083 | 9249 | 115 |
586474 | 586474 | 2020-10-01 | Santa Barbara | California | 6083 | 9223 | 115 |
583234 | 583234 | 2020-09-30 | Santa Barbara | California | 6083 | 9197 | 114 |
579995 | 579995 | 2020-09-29 | Santa Barbara | California | 6083 | 9164 | 113 |
576754 | 576754 | 2020-09-28 | Santa Barbara | California | 6083 | 9133 | 113 |
573511 | 573511 | 2020-09-27 | Santa Barbara | California | 6083 | 9061 | 113 |
570269 | 570269 | 2020-09-26 | Santa Barbara | California | 6083 | 9037 | 113 |
567027 | 567027 | 2020-09-25 | Santa Barbara | California | 6083 | 9037 | 113 |
563787 | 563787 | 2020-09-24 | Santa Barbara | California | 6083 | 9003 | 113 |
560548 | 560548 | 2020-09-23 | Santa Barbara | California | 6083 | 8973 | 113 |
557312 | 557312 | 2020-09-22 | Santa Barbara | California | 6083 | 8952 | 111 |
554075 | 554075 | 2020-09-21 | Santa Barbara | California | 6083 | 8930 | 110 |
550836 | 550836 | 2020-09-20 | Santa Barbara | California | 6083 | 8862 | 110 |
547597 | 547597 | 2020-09-19 | Santa Barbara | California | 6083 | 8846 | 110 |
544359 | 544359 | 2020-09-18 | Santa Barbara | California | 6083 | 8846 | 110 |
541123 | 541123 | 2020-09-17 | Santa Barbara | California | 6083 | 8803 | 109 |
537886 | 537886 | 2020-09-16 | Santa Barbara | California | 6083 | 8785 | 109 |
534650 | 534650 | 2020-09-15 | Santa Barbara | California | 6083 | 8741 | 107 |
531415 | 531415 | 2020-09-14 | Santa Barbara | California | 6083 | 8718 | 106 |
528178 | 528178 | 2020-09-13 | Santa Barbara | California | 6083 | 8642 | 105 |
524942 | 524942 | 2020-09-12 | Santa Barbara | California | 6083 | 8608 | 105 |
521706 | 521706 | 2020-09-11 | Santa Barbara | California | 6083 | 8608 | 105 |
518469 | 518469 | 2020-09-10 | Santa Barbara | California | 6083 | 8579 | 103 |
515234 | 515234 | 2020-09-09 | Santa Barbara | California | 6083 | 8550 | 99 |
512001 | 512001 | 2020-09-08 | Santa Barbara | California | 6083 | 8499 | 97 |
508768 | 508768 | 2020-09-07 | Santa Barbara | California | 6083 | 8434 | 97 |
505536 | 505536 | 2020-09-06 | Santa Barbara | California | 6083 | 8404 | 97 |
502302 | 502302 | 2020-09-05 | Santa Barbara | California | 6083 | 8361 | 97 |
499068 | 499068 | 2020-09-04 | Santa Barbara | California | 6083 | 8361 | 97 |
495835 | 495835 | 2020-09-03 | Santa Barbara | California | 6083 | 8300 | 97 |
492601 | 492601 | 2020-09-02 | Santa Barbara | California | 6083 | 8229 | 97 |
489368 | 489368 | 2020-09-01 | Santa Barbara | California | 6083 | 8164 | 95 |
486135 | 486135 | 2020-08-31 | Santa Barbara | California | 6083 | 8143 | 93 |
482900 | 482900 | 2020-08-30 | Santa Barbara | California | 6083 | 8052 | 92 |
479666 | 479666 | 2020-08-29 | Santa Barbara | California | 6083 | 8014 | 92 |
476433 | 476433 | 2020-08-28 | Santa Barbara | California | 6083 | 8014 | 92 |
473200 | 473200 | 2020-08-27 | Santa Barbara | California | 6083 | 7951 | 91 |
469968 | 469968 | 2020-08-26 | Santa Barbara | California | 6083 | 7916 | 90 |
466739 | 466739 | 2020-08-25 | Santa Barbara | California | 6083 | 7869 | 89 |
463510 | 463510 | 2020-08-24 | Santa Barbara | California | 6083 | 7800 | 88 |
460281 | 460281 | 2020-08-23 | Santa Barbara | California | 6083 | 7685 | 87 |
457054 | 457054 | 2020-08-22 | Santa Barbara | California | 6083 | 7653 | 87 |
453826 | 453826 | 2020-08-21 | Santa Barbara | California | 6083 | 7653 | 87 |
450598 | 450598 | 2020-08-20 | Santa Barbara | California | 6083 | 7578 | 84 |
447370 | 447370 | 2020-08-19 | Santa Barbara | California | 6083 | 7508 | 82 |
444143 | 444143 | 2020-08-18 | Santa Barbara | California | 6083 | 7481 | 81 |
440917 | 440917 | 2020-08-17 | Santa Barbara | California | 6083 | 7454 | 80 |
437691 | 437691 | 2020-08-16 | Santa Barbara | California | 6083 | 7338 | 77 |
434465 | 434465 | 2020-08-15 | Santa Barbara | California | 6083 | 7302 | 77 |
431240 | 431240 | 2020-08-14 | Santa Barbara | California | 6083 | 7274 | 77 |
428012 | 428012 | 2020-08-13 | Santa Barbara | California | 6083 | 7148 | 75 |
424788 | 424788 | 2020-08-12 | Santa Barbara | California | 6083 | 7083 | 73 |
421567 | 421567 | 2020-08-11 | Santa Barbara | California | 6083 | 7074 | 73 |
418346 | 418346 | 2020-08-10 | Santa Barbara | California | 6083 | 6996 | 72 |
415125 | 415125 | 2020-08-09 | Santa Barbara | California | 6083 | 6704 | 69 |
411905 | 411905 | 2020-08-08 | Santa Barbara | California | 6083 | 6704 | 69 |
408686 | 408686 | 2020-08-07 | Santa Barbara | California | 6083 | 6704 | 69 |
405466 | 405466 | 2020-08-06 | Santa Barbara | California | 6083 | 6652 | 68 |
402248 | 402248 | 2020-08-05 | Santa Barbara | California | 6083 | 6591 | 67 |
399032 | 399032 | 2020-08-04 | Santa Barbara | California | 6083 | 6580 | 64 |
395816 | 395816 | 2020-08-03 | Santa Barbara | California | 6083 | 6532 | 61 |
392600 | 392600 | 2020-08-02 | Santa Barbara | California | 6083 | 6465 | 60 |
389383 | 389383 | 2020-08-01 | Santa Barbara | California | 6083 | 6375 | 60 |
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 |
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);