ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where fips = 6097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
758407 | 758407 | 2020-11-23 | Sonoma | California | 6097 | 11608 | 155 |
755160 | 755160 | 2020-11-22 | Sonoma | California | 6097 | 11486 | 155 |
751914 | 751914 | 2020-11-21 | Sonoma | California | 6097 | 11428 | 155 |
748668 | 748668 | 2020-11-20 | Sonoma | California | 6097 | 11363 | 155 |
745422 | 745422 | 2020-11-19 | Sonoma | California | 6097 | 11316 | 150 |
742175 | 742175 | 2020-11-18 | Sonoma | California | 6097 | 11169 | 150 |
738928 | 738928 | 2020-11-17 | Sonoma | California | 6097 | 11133 | 150 |
735684 | 735684 | 2020-11-16 | Sonoma | California | 6097 | 11055 | 150 |
732438 | 732438 | 2020-11-15 | Sonoma | California | 6097 | 10970 | 149 |
729193 | 729193 | 2020-11-14 | Sonoma | California | 6097 | 10845 | 149 |
725950 | 725950 | 2020-11-13 | Sonoma | California | 6097 | 10679 | 149 |
722707 | 722707 | 2020-11-12 | Sonoma | California | 6097 | 10679 | 149 |
719464 | 719464 | 2020-11-11 | Sonoma | California | 6097 | 10606 | 149 |
716221 | 716221 | 2020-11-10 | Sonoma | California | 6097 | 10505 | 149 |
712977 | 712977 | 2020-11-09 | Sonoma | California | 6097 | 10424 | 146 |
709733 | 709733 | 2020-11-08 | Sonoma | California | 6097 | 10248 | 146 |
706489 | 706489 | 2020-11-07 | Sonoma | California | 6097 | 10248 | 146 |
703246 | 703246 | 2020-11-06 | Sonoma | California | 6097 | 10170 | 146 |
700003 | 700003 | 2020-11-05 | Sonoma | California | 6097 | 10116 | 146 |
696759 | 696759 | 2020-11-04 | Sonoma | California | 6097 | 10041 | 142 |
693517 | 693517 | 2020-11-03 | Sonoma | California | 6097 | 9953 | 142 |
690274 | 690274 | 2020-11-02 | Sonoma | California | 6097 | 9866 | 142 |
687029 | 687029 | 2020-11-01 | Sonoma | California | 6097 | 9686 | 136 |
683785 | 683785 | 2020-10-31 | Sonoma | California | 6097 | 9686 | 136 |
680542 | 680542 | 2020-10-30 | Sonoma | California | 6097 | 9646 | 136 |
677299 | 677299 | 2020-10-29 | Sonoma | California | 6097 | 9601 | 136 |
674056 | 674056 | 2020-10-28 | Sonoma | California | 6097 | 9569 | 136 |
670814 | 670814 | 2020-10-27 | Sonoma | California | 6097 | 9494 | 136 |
667571 | 667571 | 2020-10-26 | Sonoma | California | 6097 | 9402 | 136 |
664326 | 664326 | 2020-10-25 | Sonoma | California | 6097 | 9312 | 136 |
661082 | 661082 | 2020-10-24 | Sonoma | California | 6097 | 9245 | 134 |
657838 | 657838 | 2020-10-23 | Sonoma | California | 6097 | 9163 | 134 |
654593 | 654593 | 2020-10-22 | Sonoma | California | 6097 | 9099 | 134 |
651348 | 651348 | 2020-10-21 | Sonoma | California | 6097 | 9073 | 134 |
648104 | 648104 | 2020-10-20 | Sonoma | California | 6097 | 9016 | 134 |
644859 | 644859 | 2020-10-19 | Sonoma | California | 6097 | 8934 | 129 |
641611 | 641611 | 2020-10-18 | Sonoma | California | 6097 | 8858 | 129 |
638364 | 638364 | 2020-10-17 | Sonoma | California | 6097 | 8810 | 129 |
635119 | 635119 | 2020-10-16 | Sonoma | California | 6097 | 8717 | 129 |
631873 | 631873 | 2020-10-15 | Sonoma | California | 6097 | 8684 | 128 |
628629 | 628629 | 2020-10-14 | Sonoma | California | 6097 | 8615 | 128 |
625386 | 625386 | 2020-10-13 | Sonoma | California | 6097 | 8558 | 128 |
622143 | 622143 | 2020-10-12 | Sonoma | California | 6097 | 8500 | 128 |
618900 | 618900 | 2020-10-11 | Sonoma | California | 6097 | 8422 | 128 |
615658 | 615658 | 2020-10-10 | Sonoma | California | 6097 | 8352 | 126 |
612417 | 612417 | 2020-10-09 | Sonoma | California | 6097 | 8270 | 126 |
609175 | 609175 | 2020-10-08 | Sonoma | California | 6097 | 8155 | 126 |
605932 | 605932 | 2020-10-07 | Sonoma | California | 6097 | 8083 | 126 |
602690 | 602690 | 2020-10-06 | Sonoma | California | 6097 | 8037 | 122 |
599447 | 599447 | 2020-10-05 | Sonoma | California | 6097 | 7940 | 122 |
596204 | 596204 | 2020-10-04 | Sonoma | California | 6097 | 7861 | 122 |
592962 | 592962 | 2020-10-03 | Sonoma | California | 6097 | 7799 | 122 |
589722 | 589722 | 2020-10-02 | Sonoma | California | 6097 | 7752 | 122 |
586481 | 586481 | 2020-10-01 | Sonoma | California | 6097 | 7578 | 122 |
583241 | 583241 | 2020-09-30 | Sonoma | California | 6097 | 7578 | 122 |
580002 | 580002 | 2020-09-29 | Sonoma | California | 6097 | 7528 | 122 |
576761 | 576761 | 2020-09-28 | Sonoma | California | 6097 | 7412 | 122 |
573518 | 573518 | 2020-09-27 | Sonoma | California | 6097 | 7412 | 122 |
570276 | 570276 | 2020-09-26 | Sonoma | California | 6097 | 7369 | 122 |
567034 | 567034 | 2020-09-25 | Sonoma | California | 6097 | 7320 | 120 |
563794 | 563794 | 2020-09-24 | Sonoma | California | 6097 | 7262 | 120 |
560555 | 560555 | 2020-09-23 | Sonoma | California | 6097 | 7225 | 120 |
557319 | 557319 | 2020-09-22 | Sonoma | California | 6097 | 7160 | 120 |
554082 | 554082 | 2020-09-21 | Sonoma | California | 6097 | 7112 | 114 |
550843 | 550843 | 2020-09-20 | Sonoma | California | 6097 | 7060 | 114 |
547604 | 547604 | 2020-09-19 | Sonoma | California | 6097 | 6998 | 114 |
544366 | 544366 | 2020-09-18 | Sonoma | California | 6097 | 6987 | 114 |
541130 | 541130 | 2020-09-17 | Sonoma | California | 6097 | 6874 | 114 |
537893 | 537893 | 2020-09-16 | Sonoma | California | 6097 | 6827 | 114 |
534657 | 534657 | 2020-09-15 | Sonoma | California | 6097 | 6777 | 110 |
531422 | 531422 | 2020-09-14 | Sonoma | California | 6097 | 6738 | 110 |
528185 | 528185 | 2020-09-13 | Sonoma | California | 6097 | 6701 | 108 |
524949 | 524949 | 2020-09-12 | Sonoma | California | 6097 | 6666 | 108 |
521713 | 521713 | 2020-09-11 | Sonoma | California | 6097 | 6623 | 108 |
518476 | 518476 | 2020-09-10 | Sonoma | California | 6097 | 6561 | 105 |
515241 | 515241 | 2020-09-09 | Sonoma | California | 6097 | 6516 | 98 |
512008 | 512008 | 2020-09-08 | Sonoma | California | 6097 | 6488 | 98 |
508775 | 508775 | 2020-09-07 | Sonoma | California | 6097 | 6360 | 93 |
505543 | 505543 | 2020-09-06 | Sonoma | California | 6097 | 6303 | 93 |
502309 | 502309 | 2020-09-05 | Sonoma | California | 6097 | 6142 | 93 |
499075 | 499075 | 2020-09-04 | Sonoma | California | 6097 | 6142 | 93 |
495842 | 495842 | 2020-09-03 | Sonoma | California | 6097 | 6142 | 93 |
492608 | 492608 | 2020-09-02 | Sonoma | California | 6097 | 6067 | 89 |
489375 | 489375 | 2020-09-01 | Sonoma | California | 6097 | 5917 | 83 |
486142 | 486142 | 2020-08-31 | Sonoma | California | 6097 | 5800 | 80 |
482907 | 482907 | 2020-08-30 | Sonoma | California | 6097 | 5654 | 78 |
479673 | 479673 | 2020-08-29 | Sonoma | California | 6097 | 5654 | 78 |
476440 | 476440 | 2020-08-28 | Sonoma | California | 6097 | 5588 | 78 |
473207 | 473207 | 2020-08-27 | Sonoma | California | 6097 | 5469 | 78 |
469975 | 469975 | 2020-08-26 | Sonoma | California | 6097 | 5422 | 75 |
466746 | 466746 | 2020-08-25 | Sonoma | California | 6097 | 5351 | 75 |
463517 | 463517 | 2020-08-24 | Sonoma | California | 6097 | 5212 | 73 |
460288 | 460288 | 2020-08-23 | Sonoma | California | 6097 | 5120 | 72 |
457061 | 457061 | 2020-08-22 | Sonoma | California | 6097 | 5067 | 72 |
453833 | 453833 | 2020-08-21 | Sonoma | California | 6097 | 4942 | 70 |
450605 | 450605 | 2020-08-20 | Sonoma | California | 6097 | 4863 | 70 |
447377 | 447377 | 2020-08-19 | Sonoma | California | 6097 | 4779 | 65 |
444150 | 444150 | 2020-08-18 | Sonoma | California | 6097 | 4465 | 57 |
440924 | 440924 | 2020-08-17 | Sonoma | California | 6097 | 4465 | 57 |
437698 | 437698 | 2020-08-16 | Sonoma | California | 6097 | 4377 | 57 |
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);