ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "San Joaquin" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917417 | 917417 | 2021-01-11 | San Joaquin | California | 6077 | 52535 | 724 |
914172 | 914172 | 2021-01-10 | San Joaquin | California | 6077 | 51927 | 712 |
910927 | 910927 | 2021-01-09 | San Joaquin | California | 6077 | 51523 | 712 |
907682 | 907682 | 2021-01-08 | San Joaquin | California | 6077 | 51523 | 712 |
904436 | 904436 | 2021-01-07 | San Joaquin | California | 6077 | 50104 | 696 |
901191 | 901191 | 2021-01-06 | San Joaquin | California | 6077 | 49682 | 683 |
897946 | 897946 | 2021-01-05 | San Joaquin | California | 6077 | 49306 | 672 |
894701 | 894701 | 2021-01-04 | San Joaquin | California | 6077 | 47886 | 667 |
891454 | 891454 | 2021-01-03 | San Joaquin | California | 6077 | 47310 | 651 |
888207 | 888207 | 2021-01-02 | San Joaquin | California | 6077 | 46640 | 651 |
884962 | 884962 | 2021-01-01 | San Joaquin | California | 6077 | 45764 | 651 |
881717 | 881717 | 2020-12-31 | San Joaquin | California | 6077 | 45583 | 651 |
878472 | 878472 | 2020-12-30 | San Joaquin | California | 6077 | 44699 | 628 |
875227 | 875227 | 2020-12-29 | San Joaquin | California | 6077 | 44660 | 628 |
871982 | 871982 | 2020-12-28 | San Joaquin | California | 6077 | 43930 | 625 |
868737 | 868737 | 2020-12-27 | San Joaquin | California | 6077 | 42887 | 618 |
865492 | 865492 | 2020-12-26 | San Joaquin | California | 6077 | 42089 | 618 |
862247 | 862247 | 2020-12-25 | San Joaquin | California | 6077 | 41324 | 618 |
859002 | 859002 | 2020-12-24 | San Joaquin | California | 6077 | 41104 | 618 |
855757 | 855757 | 2020-12-23 | San Joaquin | California | 6077 | 40328 | 603 |
852512 | 852512 | 2020-12-22 | San Joaquin | California | 6077 | 39304 | 592 |
849267 | 849267 | 2020-12-21 | San Joaquin | California | 6077 | 38564 | 588 |
846022 | 846022 | 2020-12-20 | San Joaquin | California | 6077 | 37340 | 561 |
842776 | 842776 | 2020-12-19 | San Joaquin | California | 6077 | 36484 | 561 |
839531 | 839531 | 2020-12-18 | San Joaquin | California | 6077 | 36428 | 561 |
836286 | 836286 | 2020-12-17 | San Joaquin | California | 6077 | 35010 | 556 |
833040 | 833040 | 2020-12-16 | San Joaquin | California | 6077 | 33849 | 549 |
829793 | 829793 | 2020-12-15 | San Joaquin | California | 6077 | 32641 | 537 |
826547 | 826547 | 2020-12-14 | San Joaquin | California | 6077 | 32170 | 535 |
823300 | 823300 | 2020-12-13 | San Joaquin | California | 6077 | 32200 | 534 |
820054 | 820054 | 2020-12-12 | San Joaquin | California | 6077 | 32044 | 534 |
816808 | 816808 | 2020-12-11 | San Joaquin | California | 6077 | 31720 | 535 |
813562 | 813562 | 2020-12-10 | San Joaquin | California | 6077 | 30816 | 535 |
810318 | 810318 | 2020-12-09 | San Joaquin | California | 6077 | 30579 | 532 |
807073 | 807073 | 2020-12-08 | San Joaquin | California | 6077 | 28532 | 530 |
803828 | 803828 | 2020-12-07 | San Joaquin | California | 6077 | 28188 | 530 |
800583 | 800583 | 2020-12-06 | San Joaquin | California | 6077 | 28105 | 522 |
797338 | 797338 | 2020-12-05 | San Joaquin | California | 6077 | 27806 | 522 |
794093 | 794093 | 2020-12-04 | San Joaquin | California | 6077 | 27469 | 522 |
790848 | 790848 | 2020-12-03 | San Joaquin | California | 6077 | 27083 | 522 |
787603 | 787603 | 2020-12-02 | San Joaquin | California | 6077 | 26784 | 519 |
784359 | 784359 | 2020-12-01 | San Joaquin | California | 6077 | 26064 | 510 |
781114 | 781114 | 2020-11-30 | San Joaquin | California | 6077 | 25920 | 509 |
777868 | 777868 | 2020-11-29 | San Joaquin | California | 6077 | 25742 | 502 |
774623 | 774623 | 2020-11-28 | San Joaquin | California | 6077 | 25741 | 502 |
771378 | 771378 | 2020-11-27 | San Joaquin | California | 6077 | 25738 | 502 |
768133 | 768133 | 2020-11-26 | San Joaquin | California | 6077 | 25675 | 502 |
764887 | 764887 | 2020-11-25 | San Joaquin | California | 6077 | 25675 | 504 |
761642 | 761642 | 2020-11-24 | San Joaquin | California | 6077 | 25237 | 504 |
758397 | 758397 | 2020-11-23 | San Joaquin | California | 6077 | 24804 | 504 |
755150 | 755150 | 2020-11-22 | San Joaquin | California | 6077 | 24649 | 503 |
751904 | 751904 | 2020-11-21 | San Joaquin | California | 6077 | 24649 | 503 |
748658 | 748658 | 2020-11-20 | San Joaquin | California | 6077 | 24649 | 504 |
745412 | 745412 | 2020-11-19 | San Joaquin | California | 6077 | 24450 | 505 |
742165 | 742165 | 2020-11-18 | San Joaquin | California | 6077 | 24335 | 505 |
738918 | 738918 | 2020-11-17 | San Joaquin | California | 6077 | 24171 | 504 |
735674 | 735674 | 2020-11-16 | San Joaquin | California | 6077 | 23734 | 501 |
732428 | 732428 | 2020-11-15 | San Joaquin | California | 6077 | 23517 | 501 |
729183 | 729183 | 2020-11-14 | San Joaquin | California | 6077 | 23517 | 501 |
725940 | 725940 | 2020-11-13 | San Joaquin | California | 6077 | 23517 | 501 |
722697 | 722697 | 2020-11-12 | San Joaquin | California | 6077 | 23224 | 500 |
719454 | 719454 | 2020-11-11 | San Joaquin | California | 6077 | 22993 | 500 |
716211 | 716211 | 2020-11-10 | San Joaquin | California | 6077 | 22993 | 500 |
712967 | 712967 | 2020-11-09 | San Joaquin | California | 6077 | 22740 | 497 |
709723 | 709723 | 2020-11-08 | San Joaquin | California | 6077 | 22635 | 494 |
706479 | 706479 | 2020-11-07 | San Joaquin | California | 6077 | 22635 | 494 |
703236 | 703236 | 2020-11-06 | San Joaquin | California | 6077 | 22635 | 494 |
699993 | 699993 | 2020-11-05 | San Joaquin | California | 6077 | 22556 | 494 |
696749 | 696749 | 2020-11-04 | San Joaquin | California | 6077 | 22450 | 494 |
693507 | 693507 | 2020-11-03 | San Joaquin | California | 6077 | 22365 | 494 |
690264 | 690264 | 2020-11-02 | San Joaquin | California | 6077 | 22167 | 494 |
687019 | 687019 | 2020-11-01 | San Joaquin | California | 6077 | 22106 | 494 |
683775 | 683775 | 2020-10-31 | San Joaquin | California | 6077 | 22106 | 494 |
680532 | 680532 | 2020-10-30 | San Joaquin | California | 6077 | 22106 | 494 |
677289 | 677289 | 2020-10-29 | San Joaquin | California | 6077 | 21994 | 492 |
674046 | 674046 | 2020-10-28 | San Joaquin | California | 6077 | 21988 | 492 |
670804 | 670804 | 2020-10-27 | San Joaquin | California | 6077 | 21906 | 490 |
667561 | 667561 | 2020-10-26 | San Joaquin | California | 6077 | 21729 | 489 |
664316 | 664316 | 2020-10-25 | San Joaquin | California | 6077 | 21630 | 489 |
661072 | 661072 | 2020-10-24 | San Joaquin | California | 6077 | 21630 | 489 |
657828 | 657828 | 2020-10-23 | San Joaquin | California | 6077 | 21630 | 489 |
654583 | 654583 | 2020-10-22 | San Joaquin | California | 6077 | 21528 | 488 |
651338 | 651338 | 2020-10-21 | San Joaquin | California | 6077 | 21473 | 488 |
648094 | 648094 | 2020-10-20 | San Joaquin | California | 6077 | 21436 | 484 |
644849 | 644849 | 2020-10-19 | San Joaquin | California | 6077 | 21196 | 484 |
641601 | 641601 | 2020-10-18 | San Joaquin | California | 6077 | 21187 | 484 |
638354 | 638354 | 2020-10-17 | San Joaquin | California | 6077 | 21187 | 484 |
635109 | 635109 | 2020-10-16 | San Joaquin | California | 6077 | 21187 | 484 |
631863 | 631863 | 2020-10-15 | San Joaquin | California | 6077 | 21138 | 483 |
628619 | 628619 | 2020-10-14 | San Joaquin | California | 6077 | 20828 | 477 |
625376 | 625376 | 2020-10-13 | San Joaquin | California | 6077 | 20828 | 473 |
622133 | 622133 | 2020-10-12 | San Joaquin | California | 6077 | 20828 | 473 |
618890 | 618890 | 2020-10-11 | San Joaquin | California | 6077 | 20828 | 473 |
615648 | 615648 | 2020-10-10 | San Joaquin | California | 6077 | 20828 | 473 |
612407 | 612407 | 2020-10-09 | San Joaquin | California | 6077 | 20828 | 473 |
609165 | 609165 | 2020-10-08 | San Joaquin | California | 6077 | 20828 | 473 |
605922 | 605922 | 2020-10-07 | San Joaquin | California | 6077 | 20779 | 473 |
602680 | 602680 | 2020-10-06 | San Joaquin | California | 6077 | 20731 | 472 |
599437 | 599437 | 2020-10-05 | San Joaquin | California | 6077 | 20569 | 471 |
596194 | 596194 | 2020-10-04 | San Joaquin | California | 6077 | 20485 | 470 |
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);