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 |
---|---|---|---|---|---|---|---|
1193333 | 1193333 | 2021-04-06 | San Joaquin | California | 6077 | 70465 | 1325 |
1190083 | 1190083 | 2021-04-05 | San Joaquin | California | 6077 | 70245 | 1313 |
1186836 | 1186836 | 2021-04-04 | San Joaquin | California | 6077 | 70117 | 1310 |
1183589 | 1183589 | 2021-04-03 | San Joaquin | California | 6077 | 70117 | 1310 |
1180342 | 1180342 | 2021-04-02 | San Joaquin | California | 6077 | 70117 | 1310 |
1177095 | 1177095 | 2021-04-01 | San Joaquin | California | 6077 | 69978 | 1300 |
1173848 | 1173848 | 2021-03-31 | San Joaquin | California | 6077 | 69846 | 1301 |
1170601 | 1170601 | 2021-03-30 | San Joaquin | California | 6077 | 69796 | 1278 |
1167353 | 1167353 | 2021-03-29 | San Joaquin | California | 6077 | 69550 | 1259 |
1164105 | 1164105 | 2021-03-28 | San Joaquin | California | 6077 | 69448 | 1250 |
1160857 | 1160857 | 2021-03-27 | San Joaquin | California | 6077 | 69448 | 1250 |
1157609 | 1157609 | 2021-03-26 | San Joaquin | California | 6077 | 69448 | 1250 |
1154362 | 1154362 | 2021-03-25 | San Joaquin | California | 6077 | 69295 | 1244 |
1151115 | 1151115 | 2021-03-24 | San Joaquin | California | 6077 | 69187 | 1244 |
1147868 | 1147868 | 2021-03-23 | San Joaquin | California | 6077 | 69112 | 1231 |
1144621 | 1144621 | 2021-03-22 | San Joaquin | California | 6077 | 68855 | 1231 |
1141374 | 1141374 | 2021-03-21 | San Joaquin | California | 6077 | 68714 | 1229 |
1138128 | 1138128 | 2021-03-20 | San Joaquin | California | 6077 | 68714 | 1229 |
1134882 | 1134882 | 2021-03-19 | San Joaquin | California | 6077 | 68714 | 1229 |
1131635 | 1131635 | 2021-03-18 | San Joaquin | California | 6077 | 68551 | 1216 |
1128387 | 1128387 | 2021-03-17 | San Joaquin | California | 6077 | 68301 | 1213 |
1125141 | 1125141 | 2021-03-16 | San Joaquin | California | 6077 | 68036 | 1212 |
1121895 | 1121895 | 2021-03-15 | San Joaquin | California | 6077 | 67817 | 1210 |
1118648 | 1118648 | 2021-03-14 | San Joaquin | California | 6077 | 67817 | 1210 |
1115401 | 1115401 | 2021-03-13 | San Joaquin | California | 6077 | 67817 | 1210 |
1112155 | 1112155 | 2021-03-12 | San Joaquin | California | 6077 | 67817 | 1210 |
1108909 | 1108909 | 2021-03-11 | San Joaquin | California | 6077 | 67817 | 1210 |
1105663 | 1105663 | 2021-03-10 | San Joaquin | California | 6077 | 67754 | 1208 |
1102417 | 1102417 | 2021-03-09 | San Joaquin | California | 6077 | 67657 | 1199 |
1099171 | 1099171 | 2021-03-08 | San Joaquin | California | 6077 | 67395 | 1189 |
1095923 | 1095923 | 2021-03-07 | San Joaquin | California | 6077 | 67284 | 1182 |
1092677 | 1092677 | 2021-03-06 | San Joaquin | California | 6077 | 67284 | 1182 |
1089431 | 1089431 | 2021-03-05 | San Joaquin | California | 6077 | 67284 | 1182 |
1086186 | 1086186 | 2021-03-04 | San Joaquin | California | 6077 | 67213 | 1177 |
1082940 | 1082940 | 2021-03-03 | San Joaquin | California | 6077 | 67123 | 1150 |
1079694 | 1079694 | 2021-03-02 | San Joaquin | California | 6077 | 67040 | 1140 |
1076449 | 1076449 | 2021-03-01 | San Joaquin | California | 6077 | 66829 | 1126 |
1073203 | 1073203 | 2021-02-28 | San Joaquin | California | 6077 | 66709 | 1101 |
1069957 | 1069957 | 2021-02-27 | San Joaquin | California | 6077 | 66709 | 1101 |
1066712 | 1066712 | 2021-02-26 | San Joaquin | California | 6077 | 66709 | 1101 |
1063467 | 1063467 | 2021-02-25 | San Joaquin | California | 6077 | 66569 | 1082 |
1060222 | 1060222 | 2021-02-24 | San Joaquin | California | 6077 | 66462 | 1061 |
1056976 | 1056976 | 2021-02-23 | San Joaquin | California | 6077 | 66290 | 1042 |
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 |
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);