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 |
---|---|---|---|---|---|---|---|
1053730 | 1053730 | 2021-02-22 | San Joaquin | California | 6077 | 66046 | 1039 |
1050483 | 1050483 | 2021-02-21 | San Joaquin | California | 6077 | 65891 | 1026 |
1047236 | 1047236 | 2021-02-20 | San Joaquin | California | 6077 | 65891 | 1026 |
1043991 | 1043991 | 2021-02-19 | San Joaquin | California | 6077 | 65891 | 1026 |
1040746 | 1040746 | 2021-02-18 | San Joaquin | California | 6077 | 65705 | 1021 |
1037501 | 1037501 | 2021-02-17 | San Joaquin | California | 6077 | 65659 | 1018 |
1034256 | 1034256 | 2021-02-16 | San Joaquin | California | 6077 | 65359 | 1018 |
1031010 | 1031010 | 2021-02-15 | San Joaquin | California | 6077 | 64969 | 992 |
1027763 | 1027763 | 2021-02-14 | San Joaquin | California | 6077 | 64969 | 992 |
1024518 | 1024518 | 2021-02-13 | San Joaquin | California | 6077 | 64969 | 992 |
1021273 | 1021273 | 2021-02-12 | San Joaquin | California | 6077 | 64969 | 992 |
1018028 | 1018028 | 2021-02-11 | San Joaquin | California | 6077 | 64709 | 965 |
1014783 | 1014783 | 2021-02-10 | San Joaquin | California | 6077 | 64457 | 943 |
1011538 | 1011538 | 2021-02-09 | San Joaquin | California | 6077 | 64396 | 929 |
1008292 | 1008292 | 2021-02-08 | San Joaquin | California | 6077 | 64138 | 923 |
1005046 | 1005046 | 2021-02-07 | San Joaquin | California | 6077 | 63619 | 893 |
1001800 | 1001800 | 2021-02-06 | San Joaquin | California | 6077 | 63619 | 893 |
998554 | 998554 | 2021-02-05 | San Joaquin | California | 6077 | 63619 | 893 |
995308 | 995308 | 2021-02-04 | San Joaquin | California | 6077 | 63258 | 878 |
992062 | 992062 | 2021-02-03 | San Joaquin | California | 6077 | 62890 | 874 |
988816 | 988816 | 2021-02-02 | San Joaquin | California | 6077 | 62737 | 871 |
985569 | 985569 | 2021-02-01 | San Joaquin | California | 6077 | 62146 | 870 |
982322 | 982322 | 2021-01-31 | San Joaquin | California | 6077 | 61901 | 853 |
979076 | 979076 | 2021-01-30 | San Joaquin | California | 6077 | 61901 | 853 |
975831 | 975831 | 2021-01-29 | San Joaquin | California | 6077 | 61901 | 853 |
972586 | 972586 | 2021-01-28 | San Joaquin | California | 6077 | 61548 | 850 |
969341 | 969341 | 2021-01-27 | San Joaquin | California | 6077 | 61092 | 849 |
966097 | 966097 | 2021-01-26 | San Joaquin | California | 6077 | 60545 | 844 |
962852 | 962852 | 2021-01-25 | San Joaquin | California | 6077 | 59665 | 835 |
959607 | 959607 | 2021-01-24 | San Joaquin | California | 6077 | 59395 | 808 |
956361 | 956361 | 2021-01-23 | San Joaquin | California | 6077 | 59395 | 808 |
953116 | 953116 | 2021-01-22 | San Joaquin | California | 6077 | 59395 | 808 |
949871 | 949871 | 2021-01-21 | San Joaquin | California | 6077 | 59096 | 806 |
946625 | 946625 | 2021-01-20 | San Joaquin | California | 6077 | 58843 | 788 |
943378 | 943378 | 2021-01-19 | San Joaquin | California | 6077 | 58290 | 786 |
940133 | 940133 | 2021-01-18 | San Joaquin | California | 6077 | 57094 | 748 |
936888 | 936888 | 2021-01-17 | San Joaquin | California | 6077 | 56642 | 748 |
933643 | 933643 | 2021-01-16 | San Joaquin | California | 6077 | 56484 | 748 |
930398 | 930398 | 2021-01-15 | San Joaquin | California | 6077 | 56484 | 748 |
927153 | 927153 | 2021-01-14 | San Joaquin | California | 6077 | 55580 | 738 |
923907 | 923907 | 2021-01-13 | San Joaquin | California | 6077 | 54796 | 736 |
920662 | 920662 | 2021-01-12 | San Joaquin | California | 6077 | 53994 | 724 |
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 |
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);