latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
130 rows where new_deaths = 10 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 27
county 27
- Riverside 14
- Los Angeles 10
- Orange 10
- Sacramento 10
- San Bernardino 9
- Stanislaus 9
- Contra Costa 7
- Kern 7
- San Diego 7
- San Joaquin 6
- Santa Clara 6
- Tulare 6
- Alameda 4
- Imperial 4
- Monterey 4
- Placer 4
- Fresno 2
- Santa Cruz 2
- Kings 1
- Merced 1
- San Francisco 1
- San Luis Obispo 1
- San Mateo 1
- Santa Barbara 1
- Shasta 1
- Tuolumne 1
- Ventura 1
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
7 | 7 | 2021-09-02 | Contra Costa | 13 | 90440 | 882 | 193 | 10 |
147 | 147 | 2021-08-31 | Placer | 61 | 30796 | 326 | 1848 | 10 |
391 | 391 | 2021-08-27 | Santa Clara | 85 | 132504 | 1731 | 563 | 10 |
518 | 518 | 2021-08-25 | Tulare | 107 | 53591 | 865 | 462 | 10 |
599 | 599 | 2021-08-23 | Los Angeles | 37 | 1385784 | 25081 | 2598 | 10 |
614 | 614 | 2021-08-23 | Sacramento | 67 | 128340 | 1853 | 1697 | 10 |
657 | 657 | 2021-08-22 | Los Angeles | 37 | 1383186 | 25071 | 2771 | 10 |
907 | 907 | 2021-08-18 | San Diego | 73 | 318152 | 3834 | 1094 | 10 |
1025 | 1025 | 2021-08-16 | San Joaquin | 77 | 80832 | 1488 | 1191 | 10 |
2527 | 2527 | 2021-07-21 | Riverside | 65 | 304060 | 4657 | 1991 | 10 |
3797 | 3797 | 2021-06-29 | Monterey | 53 | 43885 | 476 | 10 | 10 |
4029 | 4029 | 2021-06-25 | Monterey | 53 | 43860 | 466 | 2 | 10 |
5181 | 5181 | 2021-06-05 | Los Angeles | 37 | 1244917 | 24389 | 233 | 10 |
5645 | 5645 | 2021-05-28 | Los Angeles | 37 | 1243531 | 24333 | 193 | 10 |
7671 | 7671 | 2021-04-23 | Kern | 29 | 108195 | 1345 | 64 | 10 |
8211 | 8211 | 2021-04-14 | Riverside | 65 | 296908 | 4514 | 107 | 10 |
8266 | 8266 | 2021-04-13 | Orange | 59 | 252538 | 4849 | 102 | 10 |
8371 | 8371 | 2021-04-11 | Los Angeles | 37 | 1225796 | 23477 | 497 | 10 |
8913 | 8913 | 2021-04-02 | San Joaquin | 77 | 70117 | 1310 | 139 | 10 |
9897 | 9897 | 2021-03-16 | San Diego | 73 | 265906 | 3462 | 257 | 10 |
10160 | 10160 | 2021-03-11 | Fresno | 19 | 97262 | 1519 | 106 | 10 |
10305 | 10305 | 2021-03-09 | San Joaquin | 77 | 67657 | 1199 | 262 | 10 |
10648 | 10648 | 2021-03-03 | Sacramento | 67 | 93790 | 1498 | 112 | 10 |
10653 | 10653 | 2021-03-03 | San Joaquin | 77 | 67123 | 1150 | 83 | 10 |
10826 | 10826 | 2021-02-28 | San Francisco | 75 | 34034 | 422 | 64 | 10 |
10914 | 10914 | 2021-02-26 | Fresno | 19 | 95635 | 1422 | 143 | 10 |
10960 | 10960 | 2021-02-26 | Ventura | 111 | 77256 | 844 | 240 | 10 |
11054 | 11054 | 2021-02-24 | Sacramento | 67 | 92772 | 1456 | 151 | 10 |
11056 | 11056 | 2021-02-24 | San Bernardino | 71 | 285334 | 4590 | 253 | 10 |
11151 | 11151 | 2021-02-22 | Kern | 29 | 101849 | 783 | 111 | 10 |
11259 | 11259 | 2021-02-20 | Contra Costa | 13 | 61469 | 653 | 185 | 10 |
11402 | 11402 | 2021-02-18 | Sacramento | 67 | 91393 | 1412 | 249 | 10 |
11404 | 11404 | 2021-02-18 | San Bernardino | 71 | 283356 | 4534 | 620 | 10 |
11518 | 11518 | 2021-02-16 | Sacramento | 67 | 90930 | 1382 | 965 | 10 |
11665 | 11665 | 2021-02-13 | Contra Costa | 13 | 60365 | 620 | 223 | 10 |
11673 | 11673 | 2021-02-13 | Kern | 29 | 100025 | 687 | 455 | 10 |
11787 | 11787 | 2021-02-11 | Imperial | 25 | 26574 | 584 | 25 | 10 |
11874 | 11874 | 2021-02-10 | Santa Barbara | 83 | 30352 | 358 | 146 | 10 |
11944 | 11944 | 2021-02-09 | Tulare | 107 | 46382 | 661 | 249 | 10 |
12129 | 12129 | 2021-02-05 | Contra Costa | 13 | 58462 | 552 | 214 | 10 |
12165 | 12165 | 2021-02-05 | Santa Clara | 85 | 104850 | 1449 | 395 | 10 |
12187 | 12187 | 2021-02-04 | Contra Costa | 13 | 58248 | 542 | 227 | 10 |
12272 | 12272 | 2021-02-03 | Sacramento | 67 | 87037 | 1281 | 242 | 10 |
12333 | 12333 | 2021-02-02 | San Diego | 73 | 240050 | 2629 | 926 | 10 |
12339 | 12339 | 2021-02-02 | Santa Clara | 85 | 103566 | 1410 | 454 | 10 |
12408 | 12408 | 2021-02-01 | Tulare | 107 | 45243 | 598 | 725 | 10 |
12610 | 12610 | 2021-01-28 | Merced | 47 | 26038 | 349 | 204 | 10 |
12761 | 12761 | 2021-01-25 | Alameda | 1 | 71370 | 1125 | 429 | 10 |
12803 | 12803 | 2021-01-25 | Santa Clara | 85 | 99911 | 1312 | 625 | 10 |
12978 | 12978 | 2021-01-22 | Santa Cruz | 87 | 12649 | 130 | 116 | 10 |
13057 | 13057 | 2021-01-20 | Contra Costa | 13 | 53349 | 460 | 384 | 10 |
13167 | 13167 | 2021-01-18 | Alameda | 1 | 67977 | 1066 | 571 | 10 |
13182 | 13182 | 2021-01-18 | Kings | 31 | 19321 | 143 | 67 | 10 |
13216 | 13216 | 2021-01-18 | Stanislaus | 99 | 42548 | 749 | 211 | 10 |
13379 | 13379 | 2021-01-15 | San Joaquin | 77 | 56484 | 748 | 904 | 10 |
13390 | 13390 | 2021-01-15 | Stanislaus | 99 | 41270 | 730 | 575 | 10 |
13487 | 13487 | 2021-01-13 | Placer | 61 | 16317 | 170 | 182 | 10 |
13506 | 13506 | 2021-01-13 | Stanislaus | 99 | 40252 | 709 | 543 | 10 |
13568 | 13568 | 2021-01-12 | Tulare | 107 | 38909 | 474 | 625 | 10 |
13612 | 13612 | 2021-01-11 | San Luis Obispo | 79 | 13735 | 111 | 844 | 10 |
13715 | 13715 | 2021-01-09 | Monterey | 53 | 32394 | 242 | 592 | 10 |
13738 | 13738 | 2021-01-09 | Stanislaus | 99 | 38469 | 675 | 518 | 10 |
13801 | 13801 | 2021-01-08 | Tuolumne | 109 | 3180 | 33 | 22 | 10 |
13835 | 13835 | 2021-01-07 | Placer | 61 | 15233 | 142 | 218 | 10 |
13907 | 13907 | 2021-01-06 | Shasta | 89 | 8574 | 89 | 111 | 10 |
13964 | 13964 | 2021-01-05 | Santa Cruz | 87 | 9700 | 93 | 121 | 10 |
14251 | 14251 | 2020-12-31 | San Mateo | 81 | 24589 | 227 | 343 | 10 |
14322 | 14322 | 2020-12-30 | Tulare | 107 | 33125 | 399 | 547 | 10 |
14376 | 14376 | 2020-12-29 | Stanislaus | 99 | 33899 | 596 | 276 | 10 |
14617 | 14617 | 2020-12-24 | Alameda | 1 | 47494 | 772 | 756 | 10 |
14647 | 14647 | 2020-12-24 | Placer | 61 | 12262 | 120 | 294 | 10 |
14681 | 14681 | 2020-12-23 | Contra Costa | 13 | 36313 | 308 | 525 | 10 |
14840 | 14840 | 2020-12-21 | Stanislaus | 99 | 30549 | 533 | 557 | 10 |
15014 | 15014 | 2020-12-18 | Stanislaus | 99 | 29040 | 509 | 373 | 10 |
15172 | 15172 | 2020-12-15 | Sacramento | 67 | 51052 | 699 | 829 | 10 |
15197 | 15197 | 2020-12-14 | Alameda | 1 | 39513 | 660 | 729 | 10 |
15413 | 15413 | 2020-12-11 | Santa Clara | 85 | 50702 | 521 | 1111 | 10 |
15513 | 15513 | 2020-12-09 | Monterey | 53 | 16966 | 146 | 126 | 10 |
15877 | 15877 | 2020-12-03 | Santa Clara | 85 | 41338 | 461 | 1232 | 10 |
16216 | 16216 | 2020-11-27 | Sacramento | 67 | 36630 | 576 | 891 | 10 |
16682 | 16682 | 2020-11-19 | San Bernardino | 71 | 80318 | 1356 | 2020 | 10 |
16798 | 16798 | 2020-11-17 | San Bernardino | 71 | 76685 | 1338 | 1756 | 10 |
17611 | 17611 | 2020-11-03 | San Diego | 73 | 57702 | 901 | 293 | 10 |
18648 | 18648 | 2020-10-16 | Orange | 59 | 56587 | 1401 | 151 | 10 |
19054 | 19054 | 2020-10-09 | Orange | 59 | 55345 | 1316 | 162 | 10 |
19445 | 19445 | 2020-10-02 | Kern | 29 | 32343 | 381 | 159 | 10 |
19527 | 19527 | 2020-10-01 | San Joaquin | 77 | 20457 | 466 | 46 | 10 |
19579 | 19579 | 2020-09-30 | Riverside | 65 | 59405 | 1226 | 232 | 10 |
19637 | 19637 | 2020-09-29 | Riverside | 65 | 59173 | 1216 | 241 | 10 |
19739 | 19739 | 2020-09-27 | Los Angeles | 37 | 267807 | 6514 | 779 | 10 |
19808 | 19808 | 2020-09-26 | Orange | 59 | 53069 | 1214 | 165 | 10 |
19869 | 19869 | 2020-09-25 | Riverside | 65 | 58178 | 1189 | 295 | 10 |
20043 | 20043 | 2020-09-22 | Riverside | 65 | 57482 | 1172 | 63 | 10 |
20044 | 20044 | 2020-09-22 | Sacramento | 67 | 21800 | 393 | 172 | 10 |
20257 | 20257 | 2020-09-18 | Kern | 29 | 31261 | 350 | 113 | 10 |
20275 | 20275 | 2020-09-18 | Riverside | 65 | 56681 | 1153 | 307 | 10 |
20551 | 20551 | 2020-09-13 | Los Angeles | 37 | 253985 | 6208 | 765 | 10 |
20721 | 20721 | 2020-09-10 | Kern | 29 | 30440 | 307 | 69 | 10 |
20797 | 20797 | 2020-09-09 | Riverside | 65 | 54735 | 1085 | 163 | 10 |
21088 | 21088 | 2020-09-04 | Sacramento | 67 | 18813 | 327 | 206 | 10 |
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 );