latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
100 rows where new_deaths = 11 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 23
county 23
- Orange 10
- Sacramento 10
- Alameda 7
- Riverside 7
- San Bernardino 7
- San Diego 7
- Los Angeles 6
- Kern 5
- Stanislaus 5
- Ventura 5
- Fresno 4
- San Joaquin 4
- Santa Clara 4
- Tulare 4
- San Francisco 3
- Contra Costa 2
- Monterey 2
- San Mateo 2
- Santa Barbara 2
- Imperial 1
- Lake 1
- Merced 1
- San Luis Obispo 1
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
33 | 33 | 2021-09-02 | Riverside | 65 | 337921 | 4749 | 846 | 11 |
92 | 92 | 2021-09-01 | Sacramento | 67 | 137232 | 1934 | 615 | 11 |
2165 | 2165 | 2021-07-27 | Los Angeles | 37 | 1288090 | 24643 | 2127 | 11 |
2745 | 2745 | 2021-07-17 | Los Angeles | 37 | 1266227 | 24579 | 1669 | 11 |
2869 | 2869 | 2021-07-15 | Monterey | 53 | 44113 | 518 | 26 | 11 |
2977 | 2977 | 2021-07-13 | Los Angeles | 37 | 1259992 | 24554 | 1307 | 11 |
3671 | 3671 | 2021-07-01 | Lake | 33 | 3600 | 56 | 20 | 11 |
4021 | 4021 | 2021-06-25 | Los Angeles | 37 | 1248764 | 24468 | 602 | 11 |
4377 | 4377 | 2021-06-19 | Monterey | 53 | 43819 | 432 | 0 | 11 |
5819 | 5819 | 2021-05-25 | Los Angeles | 37 | 1239127 | 24186 | 195 | 11 |
6167 | 6167 | 2021-05-19 | Los Angeles | 37 | 1237910 | 24117 | 210 | 11 |
7868 | 7868 | 2021-04-20 | San Francisco | 75 | 35816 | 528 | 70 | 11 |
8327 | 8327 | 2021-04-12 | Riverside | 65 | 296635 | 4492 | 545 | 11 |
8560 | 8560 | 2021-04-08 | Sacramento | 67 | 99268 | 1638 | 111 | 11 |
8947 | 8947 | 2021-04-01 | Kern | 29 | 106288 | 1264 | 49 | 11 |
8962 | 8962 | 2021-04-01 | Orange | 59 | 250764 | 4755 | 81 | 11 |
9375 | 9375 | 2021-03-25 | San Diego | 73 | 268627 | 3520 | 210 | 11 |
9426 | 9426 | 2021-03-24 | Orange | 59 | 249842 | 4646 | 82 | 11 |
9433 | 9433 | 2021-03-24 | San Diego | 73 | 268417 | 3509 | 257 | 11 |
9643 | 9643 | 2021-03-20 | Kern | 29 | 105441 | 1043 | 73 | 11 |
9720 | 9720 | 2021-03-19 | Sacramento | 67 | 95964 | 1576 | 127 | 11 |
9774 | 9774 | 2021-03-18 | Orange | 59 | 249181 | 4522 | 114 | 11 |
10358 | 10358 | 2021-03-08 | Sacramento | 67 | 94561 | 1521 | 432 | 11 |
10941 | 10941 | 2021-02-26 | San Diego | 73 | 259644 | 3271 | 662 | 11 |
10972 | 10972 | 2021-02-25 | Fresno | 19 | 95492 | 1412 | 146 | 11 |
11134 | 11134 | 2021-02-23 | Ventura | 111 | 76715 | 805 | 137 | 11 |
11317 | 11317 | 2021-02-19 | Contra Costa | 13 | 61284 | 643 | 150 | 11 |
11320 | 11320 | 2021-02-19 | Fresno | 19 | 94658 | 1367 | 168 | 11 |
11348 | 11348 | 2021-02-19 | San Francisco | 75 | 33397 | 387 | 90 | 11 |
11422 | 11422 | 2021-02-18 | Tulare | 107 | 47311 | 717 | 91 | 11 |
11875 | 11875 | 2021-02-10 | Santa Clara | 85 | 106413 | 1490 | 375 | 11 |
11886 | 11886 | 2021-02-10 | Tulare | 107 | 46477 | 672 | 95 | 11 |
11931 | 11931 | 2021-02-09 | San Mateo | 81 | 37139 | 447 | 81 | 11 |
11932 | 11932 | 2021-02-09 | Santa Barbara | 83 | 30206 | 348 | 119 | 11 |
11933 | 11933 | 2021-02-09 | Santa Clara | 85 | 106038 | 1479 | 411 | 11 |
12155 | 12155 | 2021-02-05 | Riverside | 65 | 280170 | 3320 | 981 | 11 |
12352 | 12352 | 2021-02-02 | Ventura | 111 | 71212 | 629 | 413 | 11 |
12624 | 12624 | 2021-01-28 | San Francisco | 75 | 30674 | 308 | 196 | 11 |
12814 | 12814 | 2021-01-25 | Tulare | 107 | 43574 | 542 | 815 | 11 |
12976 | 12976 | 2021-01-22 | Santa Barbara | 83 | 25986 | 260 | 235 | 11 |
13007 | 13007 | 2021-01-21 | Kern | 29 | 87714 | 583 | 474 | 11 |
13032 | 13032 | 2021-01-21 | San Luis Obispo | 79 | 16228 | 151 | 172 | 11 |
13396 | 13396 | 2021-01-15 | Ventura | 111 | 57611 | 412 | 1763 | 11 |
13399 | 13399 | 2021-01-14 | Alameda | 1 | 64465 | 1029 | 767 | 11 |
13448 | 13448 | 2021-01-14 | Stanislaus | 99 | 40695 | 720 | 443 | 11 |
13622 | 13622 | 2021-01-11 | Stanislaus | 99 | 39216 | 686 | 365 | 11 |
13901 | 13901 | 2021-01-06 | San Joaquin | 77 | 49682 | 683 | 376 | 11 |
13912 | 13912 | 2021-01-06 | Stanislaus | 99 | 36833 | 649 | 394 | 11 |
13979 | 13979 | 2021-01-04 | Alameda | 1 | 55872 | 904 | 808 | 11 |
14302 | 14302 | 2020-12-30 | Sacramento | 67 | 64405 | 844 | 507 | 11 |
14327 | 14327 | 2020-12-29 | Alameda | 1 | 50896 | 827 | 529 | 11 |
14382 | 14382 | 2020-12-29 | Ventura | 111 | 37572 | 255 | 993 | 11 |
14440 | 14440 | 2020-12-28 | Ventura | 111 | 36579 | 244 | 3178 | 11 |
14501 | 14501 | 2020-12-26 | Alameda | 1 | 49028 | 792 | 706 | 11 |
14708 | 14708 | 2020-12-23 | Sacramento | 67 | 58869 | 797 | 868 | 11 |
14713 | 14713 | 2020-12-23 | San Joaquin | 77 | 40328 | 603 | 1024 | 11 |
14782 | 14782 | 2020-12-22 | Stanislaus | 99 | 31106 | 544 | 557 | 11 |
14907 | 14907 | 2020-12-19 | Alameda | 1 | 43204 | 711 | 904 | 11 |
15087 | 15087 | 2020-12-16 | Contra Costa | 13 | 32526 | 290 | 1010 | 11 |
15123 | 15123 | 2020-12-16 | Santa Clara | 85 | 57027 | 580 | 1646 | 11 |
15291 | 15291 | 2020-12-13 | San Diego | 73 | 107372 | 1162 | 2416 | 11 |
15404 | 15404 | 2020-12-11 | Sacramento | 67 | 47473 | 670 | 994 | 11 |
15465 | 15465 | 2020-12-10 | San Diego | 73 | 99599 | 1114 | 2050 | 11 |
15487 | 15487 | 2020-12-09 | Alameda | 1 | 35460 | 602 | 543 | 11 |
15520 | 15520 | 2020-12-09 | Sacramento | 67 | 45336 | 646 | 648 | 11 |
15645 | 15645 | 2020-12-07 | Santa Clara | 85 | 45159 | 488 | 1285 | 11 |
15810 | 15810 | 2020-12-04 | Sacramento | 67 | 41096 | 614 | 791 | 11 |
16450 | 16450 | 2020-11-23 | San Bernardino | 71 | 85176 | 1398 | 645 | 11 |
16560 | 16560 | 2020-11-21 | Orange | 59 | 69142 | 1551 | 806 | 11 |
16566 | 16566 | 2020-11-21 | San Bernardino | 71 | 84201 | 1378 | 2873 | 11 |
16624 | 16624 | 2020-11-20 | San Bernardino | 71 | 81328 | 1367 | 1010 | 11 |
18300 | 18300 | 2020-10-22 | Orange | 59 | 57848 | 1434 | 213 | 11 |
18358 | 18358 | 2020-10-21 | Orange | 59 | 57635 | 1423 | 262 | 11 |
20391 | 20391 | 2020-09-16 | Riverside | 65 | 56201 | 1136 | 215 | 11 |
20426 | 20426 | 2020-09-15 | Fresno | 19 | 29418 | 348 | 85 | 11 |
20658 | 20658 | 2020-09-11 | Fresno | 19 | 29077 | 337 | 119 | 11 |
20968 | 20968 | 2020-09-06 | Orange | 59 | 49732 | 1053 | 474 | 11 |
21142 | 21142 | 2020-09-03 | Orange | 59 | 48945 | 1018 | 0 | 11 |
21589 | 21589 | 2020-08-26 | Imperial | 25 | 10509 | 283 | 23 | 11 |
21649 | 21649 | 2020-08-25 | Kern | 29 | 28520 | 251 | 286 | 11 |
21974 | 21974 | 2020-08-20 | Stanislaus | 99 | 13084 | 223 | 149 | 11 |
21983 | 21983 | 2020-08-19 | Alameda | 1 | 16056 | 334 | 200 | 11 |
22016 | 22016 | 2020-08-19 | Sacramento | 67 | 14760 | 230 | 158 | 11 |
22079 | 22079 | 2020-08-18 | San Joaquin | 77 | 15201 | 280 | 193 | 11 |
22418 | 22418 | 2020-08-12 | Orange | 59 | 41823 | 745 | 245 | 11 |
22635 | 22635 | 2020-08-08 | Kern | 29 | 22626 | 171 | 617 | 11 |
22964 | 22964 | 2020-08-03 | Tulare | 107 | 9745 | 189 | 291 | 11 |
23108 | 23108 | 2020-07-31 | Merced | 47 | 4285 | 50 | 220 | 11 |
23178 | 23178 | 2020-07-30 | San Bernardino | 71 | 31688 | 693 | 863 | 11 |
23294 | 23294 | 2020-07-28 | San Bernardino | 71 | 29962 | 662 | 831 | 11 |
23526 | 23526 | 2020-07-24 | San Bernardino | 71 | 26796 | 601 | 611 | 11 |
23761 | 23761 | 2020-07-20 | San Joaquin | 77 | 8321 | 94 | 502 | 11 |
23984 | 23984 | 2020-07-16 | Orange | 59 | 27904 | 466 | 873 | 11 |
24222 | 24222 | 2020-07-12 | San Bernardino | 71 | 19043 | 423 | 131 | 11 |
25727 | 25727 | 2020-06-16 | Riverside | 65 | 11694 | 395 | 409 | 11 |
26539 | 26539 | 2020-06-02 | Riverside | 65 | 8155 | 342 | 173 | 11 |
26945 | 26945 | 2020-05-26 | Riverside | 65 | 7139 | 303 | 135 | 11 |
27239 | 27239 | 2020-05-21 | San Diego | 73 | 6315 | 241 | 175 | 11 |
27355 | 27355 | 2020-05-19 | San Diego | 73 | 6026 | 222 | 80 | 11 |
28893 | 28893 | 2020-04-22 | San Mateo | 81 | 958 | 39 | 23 | 11 |
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 );