latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
551 rows where county = "San Joaquin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
5839 | 5839 | 2021-05-25 | San Joaquin | 77 | 73717 | 1419 | 100 | 16 |
5897 | 5897 | 2021-05-24 | San Joaquin | 77 | 73617 | 1403 | 73 | 1 |
5955 | 5955 | 2021-05-23 | San Joaquin | 77 | 73544 | 1402 | 0 | 0 |
6013 | 6013 | 2021-05-22 | San Joaquin | 77 | 73544 | 1402 | 0 | 0 |
6071 | 6071 | 2021-05-21 | San Joaquin | 77 | 73544 | 1402 | 68 | 0 |
6129 | 6129 | 2021-05-20 | San Joaquin | 77 | 73476 | 1402 | 36 | 2 |
6187 | 6187 | 2021-05-19 | San Joaquin | 77 | 73440 | 1400 | 39 | 1 |
6245 | 6245 | 2021-05-18 | San Joaquin | 77 | 73401 | 1399 | 62 | 5 |
6303 | 6303 | 2021-05-17 | San Joaquin | 77 | 73339 | 1394 | 29 | 0 |
6361 | 6361 | 2021-05-16 | San Joaquin | 77 | 73310 | 1394 | 0 | 0 |
6419 | 6419 | 2021-05-15 | San Joaquin | 77 | 73310 | 1394 | 0 | 0 |
6477 | 6477 | 2021-05-14 | San Joaquin | 77 | 73310 | 1394 | 43 | 3 |
6535 | 6535 | 2021-05-13 | San Joaquin | 77 | 73267 | 1391 | 47 | 0 |
6593 | 6593 | 2021-05-12 | San Joaquin | 77 | 73220 | 1391 | 40 | 0 |
6651 | 6651 | 2021-05-11 | San Joaquin | 77 | 73180 | 1391 | 6 | 0 |
6709 | 6709 | 2021-05-10 | San Joaquin | 77 | 73174 | 1391 | 165 | 0 |
6767 | 6767 | 2021-05-09 | San Joaquin | 77 | 73009 | 1391 | 0 | 0 |
6825 | 6825 | 2021-05-08 | San Joaquin | 77 | 73009 | 1391 | 0 | 0 |
6883 | 6883 | 2021-05-07 | San Joaquin | 77 | 73009 | 1391 | 67 | 0 |
6941 | 6941 | 2021-05-06 | San Joaquin | 77 | 72942 | 1391 | 158 | 7 |
6999 | 6999 | 2021-05-05 | San Joaquin | 77 | 72784 | 1384 | 60 | 2 |
7057 | 7057 | 2021-05-04 | San Joaquin | 77 | 72724 | 1382 | 52 | 17 |
7115 | 7115 | 2021-05-03 | San Joaquin | 77 | 72672 | 1365 | 194 | 19 |
7173 | 7173 | 2021-05-02 | San Joaquin | 77 | 72478 | 1346 | 0 | 0 |
7231 | 7231 | 2021-05-01 | San Joaquin | 77 | 72478 | 1346 | 0 | 0 |
7289 | 7289 | 2021-04-30 | San Joaquin | 77 | 72478 | 1346 | 83 | 0 |
7347 | 7347 | 2021-04-29 | San Joaquin | 77 | 72395 | 1346 | 50 | 0 |
7405 | 7405 | 2021-04-28 | San Joaquin | 77 | 72345 | 1346 | 64 | 0 |
7463 | 7463 | 2021-04-27 | San Joaquin | 77 | 72281 | 1346 | 294 | 0 |
7521 | 7521 | 2021-04-26 | San Joaquin | 77 | 71987 | 1346 | 15 | 6 |
7579 | 7579 | 2021-04-25 | San Joaquin | 77 | 71972 | 1340 | 0 | 0 |
7637 | 7637 | 2021-04-24 | San Joaquin | 77 | 71972 | 1340 | 0 | 0 |
7695 | 7695 | 2021-04-23 | San Joaquin | 77 | 71972 | 1340 | 73 | 0 |
7753 | 7753 | 2021-04-22 | San Joaquin | 77 | 71899 | 1340 | 86 | 0 |
7811 | 7811 | 2021-04-21 | San Joaquin | 77 | 71813 | 1340 | 78 | 6 |
7869 | 7869 | 2021-04-20 | San Joaquin | 77 | 71735 | 1334 | 208 | 0 |
7927 | 7927 | 2021-04-19 | San Joaquin | 77 | 71527 | 1334 | 96 | 0 |
7985 | 7985 | 2021-04-18 | San Joaquin | 77 | 71431 | 1334 | 0 | 0 |
8043 | 8043 | 2021-04-17 | San Joaquin | 77 | 71431 | 1334 | 0 | 0 |
8101 | 8101 | 2021-04-16 | San Joaquin | 77 | 71431 | 1334 | 93 | 0 |
8159 | 8159 | 2021-04-15 | San Joaquin | 77 | 71338 | 1334 | 109 | 0 |
8217 | 8217 | 2021-04-14 | San Joaquin | 77 | 71229 | 1334 | 51 | 0 |
8275 | 8275 | 2021-04-13 | San Joaquin | 77 | 71178 | 1334 | 184 | 0 |
8333 | 8333 | 2021-04-12 | San Joaquin | 77 | 70994 | 1334 | 248 | 6 |
8391 | 8391 | 2021-04-11 | San Joaquin | 77 | 70746 | 1328 | 0 | 0 |
8449 | 8449 | 2021-04-10 | San Joaquin | 77 | 70746 | 1328 | 0 | 0 |
8507 | 8507 | 2021-04-09 | San Joaquin | 77 | 70746 | 1328 | 137 | 3 |
8565 | 8565 | 2021-04-08 | San Joaquin | 77 | 70609 | 1325 | 98 | 0 |
8623 | 8623 | 2021-04-07 | San Joaquin | 77 | 70511 | 1325 | 46 | 0 |
8681 | 8681 | 2021-04-06 | San Joaquin | 77 | 70465 | 1325 | 220 | 12 |
8739 | 8739 | 2021-04-05 | San Joaquin | 77 | 70245 | 1313 | 128 | 3 |
8797 | 8797 | 2021-04-04 | San Joaquin | 77 | 70117 | 1310 | 0 | 0 |
8855 | 8855 | 2021-04-03 | San Joaquin | 77 | 70117 | 1310 | 0 | 0 |
8913 | 8913 | 2021-04-02 | San Joaquin | 77 | 70117 | 1310 | 139 | 10 |
8971 | 8971 | 2021-04-01 | San Joaquin | 77 | 69978 | 1300 | 132 | 0 |
9029 | 9029 | 2021-03-31 | San Joaquin | 77 | 69846 | 1300 | 50 | 22 |
9087 | 9087 | 2021-03-30 | San Joaquin | 77 | 69796 | 1278 | 246 | 19 |
9145 | 9145 | 2021-03-29 | San Joaquin | 77 | 69550 | 1259 | 102 | 9 |
9203 | 9203 | 2021-03-28 | San Joaquin | 77 | 69448 | 1250 | 0 | 0 |
9261 | 9261 | 2021-03-27 | San Joaquin | 77 | 69448 | 1250 | 0 | 0 |
9319 | 9319 | 2021-03-26 | San Joaquin | 77 | 69448 | 1250 | 153 | 6 |
9377 | 9377 | 2021-03-25 | San Joaquin | 77 | 69295 | 1244 | 108 | 0 |
9435 | 9435 | 2021-03-24 | San Joaquin | 77 | 69187 | 1244 | 75 | 13 |
9493 | 9493 | 2021-03-23 | San Joaquin | 77 | 69112 | 1231 | 257 | 0 |
9551 | 9551 | 2021-03-22 | San Joaquin | 77 | 68855 | 1231 | 141 | 2 |
9609 | 9609 | 2021-03-21 | San Joaquin | 77 | 68714 | 1229 | 0 | 0 |
9667 | 9667 | 2021-03-20 | San Joaquin | 77 | 68714 | 1229 | 0 | 0 |
9725 | 9725 | 2021-03-19 | San Joaquin | 77 | 68714 | 1229 | 163 | 13 |
9783 | 9783 | 2021-03-18 | San Joaquin | 77 | 68551 | 1216 | 250 | 3 |
9841 | 9841 | 2021-03-17 | San Joaquin | 77 | 68301 | 1213 | 265 | 1 |
9899 | 9899 | 2021-03-16 | San Joaquin | 77 | 68036 | 1212 | 219 | 2 |
9957 | 9957 | 2021-03-15 | San Joaquin | 77 | 67817 | 1210 | 0 | 0 |
10015 | 10015 | 2021-03-14 | San Joaquin | 77 | 67817 | 1210 | 0 | 0 |
10073 | 10073 | 2021-03-13 | San Joaquin | 77 | 67817 | 1210 | 0 | 0 |
10131 | 10131 | 2021-03-12 | San Joaquin | 77 | 67817 | 1210 | 0 | 0 |
10189 | 10189 | 2021-03-11 | San Joaquin | 77 | 67817 | 1210 | 63 | 2 |
10247 | 10247 | 2021-03-10 | San Joaquin | 77 | 67754 | 1208 | 97 | 9 |
10305 | 10305 | 2021-03-09 | San Joaquin | 77 | 67657 | 1199 | 262 | 10 |
10363 | 10363 | 2021-03-08 | San Joaquin | 77 | 67395 | 1189 | 111 | 7 |
10421 | 10421 | 2021-03-07 | San Joaquin | 77 | 67284 | 1182 | 0 | 0 |
10479 | 10479 | 2021-03-06 | San Joaquin | 77 | 67284 | 1182 | 0 | 0 |
10537 | 10537 | 2021-03-05 | San Joaquin | 77 | 67284 | 1182 | 71 | 5 |
10595 | 10595 | 2021-03-04 | San Joaquin | 77 | 67213 | 1177 | 90 | 27 |
10653 | 10653 | 2021-03-03 | San Joaquin | 77 | 67123 | 1150 | 83 | 10 |
10711 | 10711 | 2021-03-02 | San Joaquin | 77 | 67040 | 1140 | 211 | 14 |
10769 | 10769 | 2021-03-01 | San Joaquin | 77 | 66829 | 1126 | 120 | 25 |
10827 | 10827 | 2021-02-28 | San Joaquin | 77 | 66709 | 1101 | 0 | 0 |
10885 | 10885 | 2021-02-27 | San Joaquin | 77 | 66709 | 1101 | 0 | 0 |
10943 | 10943 | 2021-02-26 | San Joaquin | 77 | 66709 | 1101 | 140 | 19 |
11001 | 11001 | 2021-02-25 | San Joaquin | 77 | 66569 | 1082 | 107 | 21 |
11059 | 11059 | 2021-02-24 | San Joaquin | 77 | 66462 | 1061 | 172 | 19 |
11117 | 11117 | 2021-02-23 | San Joaquin | 77 | 66290 | 1042 | 244 | 3 |
11175 | 11175 | 2021-02-22 | San Joaquin | 77 | 66046 | 1039 | 155 | 13 |
11233 | 11233 | 2021-02-21 | San Joaquin | 77 | 65891 | 1026 | 0 | 0 |
11291 | 11291 | 2021-02-20 | San Joaquin | 77 | 65891 | 1026 | 0 | 0 |
11349 | 11349 | 2021-02-19 | San Joaquin | 77 | 65891 | 1026 | 186 | 5 |
11407 | 11407 | 2021-02-18 | San Joaquin | 77 | 65705 | 1021 | 46 | 3 |
11465 | 11465 | 2021-02-17 | San Joaquin | 77 | 65659 | 1018 | 300 | 0 |
11523 | 11523 | 2021-02-16 | San Joaquin | 77 | 65359 | 1018 | 390 | 26 |
11581 | 11581 | 2021-02-15 | San Joaquin | 77 | 64969 | 992 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );