ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Ventura" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
868754 | 868754 | 2020-12-27 | Ventura | California | 6111 | 36064 | 233 |
865509 | 865509 | 2020-12-26 | Ventura | California | 6111 | 35514 | 233 |
862264 | 862264 | 2020-12-25 | Ventura | California | 6111 | 34400 | 233 |
859019 | 859019 | 2020-12-24 | Ventura | California | 6111 | 33401 | 233 |
855774 | 855774 | 2020-12-23 | Ventura | California | 6111 | 32895 | 224 |
852529 | 852529 | 2020-12-22 | Ventura | California | 6111 | 32144 | 216 |
849284 | 849284 | 2020-12-21 | Ventura | California | 6111 | 31407 | 210 |
846039 | 846039 | 2020-12-20 | Ventura | California | 6111 | 30843 | 210 |
842793 | 842793 | 2020-12-19 | Ventura | California | 6111 | 29907 | 210 |
839548 | 839548 | 2020-12-18 | Ventura | California | 6111 | 29404 | 210 |
836303 | 836303 | 2020-12-17 | Ventura | California | 6111 | 28643 | 207 |
833057 | 833057 | 2020-12-16 | Ventura | California | 6111 | 27936 | 204 |
829810 | 829810 | 2020-12-15 | Ventura | California | 6111 | 27436 | 201 |
826564 | 826564 | 2020-12-14 | Ventura | California | 6111 | 26927 | 199 |
823317 | 823317 | 2020-12-13 | Ventura | California | 6111 | 25955 | 198 |
820071 | 820071 | 2020-12-12 | Ventura | California | 6111 | 24999 | 198 |
816825 | 816825 | 2020-12-11 | Ventura | California | 6111 | 24276 | 198 |
813579 | 813579 | 2020-12-10 | Ventura | California | 6111 | 23897 | 197 |
810335 | 810335 | 2020-12-09 | Ventura | California | 6111 | 23665 | 197 |
807090 | 807090 | 2020-12-08 | Ventura | California | 6111 | 23473 | 195 |
803845 | 803845 | 2020-12-07 | Ventura | California | 6111 | 23165 | 189 |
800600 | 800600 | 2020-12-06 | Ventura | California | 6111 | 22710 | 188 |
797355 | 797355 | 2020-12-05 | Ventura | California | 6111 | 22024 | 188 |
794110 | 794110 | 2020-12-04 | Ventura | California | 6111 | 21876 | 188 |
790865 | 790865 | 2020-12-03 | Ventura | California | 6111 | 21388 | 187 |
787620 | 787620 | 2020-12-02 | Ventura | California | 6111 | 20987 | 185 |
784376 | 784376 | 2020-12-01 | Ventura | California | 6111 | 20308 | 185 |
781131 | 781131 | 2020-11-30 | Ventura | California | 6111 | 20066 | 183 |
777885 | 777885 | 2020-11-29 | Ventura | California | 6111 | 19510 | 175 |
774640 | 774640 | 2020-11-28 | Ventura | California | 6111 | 19379 | 175 |
771395 | 771395 | 2020-11-27 | Ventura | California | 6111 | 19058 | 175 |
768150 | 768150 | 2020-11-26 | Ventura | California | 6111 | 18914 | 175 |
764904 | 764904 | 2020-11-25 | Ventura | California | 6111 | 18637 | 175 |
761659 | 761659 | 2020-11-24 | Ventura | California | 6111 | 18480 | 175 |
758414 | 758414 | 2020-11-23 | Ventura | California | 6111 | 18185 | 175 |
755167 | 755167 | 2020-11-22 | Ventura | California | 6111 | 18040 | 174 |
751921 | 751921 | 2020-11-21 | Ventura | California | 6111 | 17741 | 174 |
748675 | 748675 | 2020-11-20 | Ventura | California | 6111 | 17575 | 174 |
745429 | 745429 | 2020-11-19 | Ventura | California | 6111 | 17169 | 174 |
742182 | 742182 | 2020-11-18 | Ventura | California | 6111 | 17014 | 173 |
738935 | 738935 | 2020-11-17 | Ventura | California | 6111 | 16691 | 173 |
735691 | 735691 | 2020-11-16 | Ventura | California | 6111 | 16564 | 173 |
732445 | 732445 | 2020-11-15 | Ventura | California | 6111 | 16297 | 172 |
729200 | 729200 | 2020-11-14 | Ventura | California | 6111 | 16172 | 172 |
725957 | 725957 | 2020-11-13 | Ventura | California | 6111 | 16029 | 172 |
722714 | 722714 | 2020-11-12 | Ventura | California | 6111 | 15801 | 171 |
719471 | 719471 | 2020-11-11 | Ventura | California | 6111 | 15625 | 171 |
716228 | 716228 | 2020-11-10 | Ventura | California | 6111 | 15568 | 171 |
712984 | 712984 | 2020-11-09 | Ventura | California | 6111 | 15504 | 171 |
709740 | 709740 | 2020-11-08 | Ventura | California | 6111 | 15353 | 169 |
706496 | 706496 | 2020-11-07 | Ventura | California | 6111 | 15222 | 169 |
703253 | 703253 | 2020-11-06 | Ventura | California | 6111 | 15113 | 169 |
700010 | 700010 | 2020-11-05 | Ventura | California | 6111 | 14936 | 169 |
696766 | 696766 | 2020-11-04 | Ventura | California | 6111 | 14816 | 167 |
693524 | 693524 | 2020-11-03 | Ventura | California | 6111 | 14767 | 167 |
690281 | 690281 | 2020-11-02 | Ventura | California | 6111 | 14686 | 167 |
687036 | 687036 | 2020-11-01 | Ventura | California | 6111 | 14635 | 166 |
683792 | 683792 | 2020-10-31 | Ventura | California | 6111 | 14578 | 166 |
680549 | 680549 | 2020-10-30 | Ventura | California | 6111 | 14486 | 166 |
677306 | 677306 | 2020-10-29 | Ventura | California | 6111 | 14409 | 166 |
674063 | 674063 | 2020-10-28 | Ventura | California | 6111 | 14347 | 166 |
670821 | 670821 | 2020-10-27 | Ventura | California | 6111 | 14330 | 165 |
667578 | 667578 | 2020-10-26 | Ventura | California | 6111 | 14300 | 165 |
664333 | 664333 | 2020-10-25 | Ventura | California | 6111 | 14240 | 164 |
661089 | 661089 | 2020-10-24 | Ventura | California | 6111 | 14192 | 164 |
657845 | 657845 | 2020-10-23 | Ventura | California | 6111 | 14124 | 164 |
654600 | 654600 | 2020-10-22 | Ventura | California | 6111 | 14050 | 162 |
651355 | 651355 | 2020-10-21 | Ventura | California | 6111 | 13980 | 160 |
648111 | 648111 | 2020-10-20 | Ventura | California | 6111 | 13930 | 160 |
644866 | 644866 | 2020-10-19 | Ventura | California | 6111 | 13901 | 160 |
641618 | 641618 | 2020-10-18 | Ventura | California | 6111 | 13845 | 160 |
638371 | 638371 | 2020-10-17 | Ventura | California | 6111 | 13805 | 160 |
635126 | 635126 | 2020-10-16 | Ventura | California | 6111 | 13750 | 160 |
631880 | 631880 | 2020-10-15 | Ventura | California | 6111 | 13697 | 159 |
628636 | 628636 | 2020-10-14 | Ventura | California | 6111 | 13645 | 158 |
625393 | 625393 | 2020-10-13 | Ventura | California | 6111 | 13617 | 158 |
622150 | 622150 | 2020-10-12 | Ventura | California | 6111 | 13604 | 158 |
618907 | 618907 | 2020-10-11 | Ventura | California | 6111 | 13520 | 158 |
615665 | 615665 | 2020-10-10 | Ventura | California | 6111 | 13469 | 158 |
612424 | 612424 | 2020-10-09 | Ventura | California | 6111 | 13399 | 158 |
609182 | 609182 | 2020-10-08 | Ventura | California | 6111 | 13333 | 157 |
605939 | 605939 | 2020-10-07 | Ventura | California | 6111 | 13242 | 157 |
602697 | 602697 | 2020-10-06 | Ventura | California | 6111 | 13224 | 154 |
599454 | 599454 | 2020-10-05 | Ventura | California | 6111 | 13197 | 154 |
596211 | 596211 | 2020-10-04 | Ventura | California | 6111 | 13150 | 153 |
592969 | 592969 | 2020-10-03 | Ventura | California | 6111 | 13120 | 153 |
589729 | 589729 | 2020-10-02 | Ventura | California | 6111 | 13057 | 153 |
586488 | 586488 | 2020-10-01 | Ventura | California | 6111 | 12968 | 152 |
583248 | 583248 | 2020-09-30 | Ventura | California | 6111 | 12875 | 152 |
580009 | 580009 | 2020-09-29 | Ventura | California | 6111 | 12812 | 150 |
576768 | 576768 | 2020-09-28 | Ventura | California | 6111 | 12775 | 150 |
573525 | 573525 | 2020-09-27 | Ventura | California | 6111 | 12729 | 150 |
570283 | 570283 | 2020-09-26 | Ventura | California | 6111 | 12664 | 150 |
567041 | 567041 | 2020-09-25 | Ventura | California | 6111 | 12617 | 150 |
563801 | 563801 | 2020-09-24 | Ventura | California | 6111 | 12591 | 147 |
560562 | 560562 | 2020-09-23 | Ventura | California | 6111 | 12507 | 146 |
557326 | 557326 | 2020-09-22 | Ventura | California | 6111 | 12477 | 146 |
554089 | 554089 | 2020-09-21 | Ventura | California | 6111 | 12406 | 146 |
550850 | 550850 | 2020-09-20 | Ventura | California | 6111 | 12328 | 143 |
547611 | 547611 | 2020-09-19 | Ventura | California | 6111 | 12236 | 143 |
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);