latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
99 rows where new_deaths = 12 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 22
county 22
- San Diego 10
- Los Angeles 9
- Riverside 9
- Sacramento 9
- Orange 8
- San Joaquin 8
- Santa Clara 6
- Alameda 5
- Imperial 5
- Kern 5
- San Bernardino 5
- Tulare 4
- Ventura 3
- Fresno 2
- Kings 2
- Santa Barbara 2
- Stanislaus 2
- Contra Costa 1
- Madera 1
- Merced 1
- San Francisco 1
- Yolo 1
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
97 | 97 | 2021-09-01 | San Joaquin | 77 | 87365 | 1540 | 1443 | 12 |
904 | 904 | 2021-08-18 | Sacramento | 67 | 124985 | 1834 | 381 | 12 |
4137 | 4137 | 2021-06-23 | Los Angeles | 37 | 1248161 | 24457 | 252 | 12 |
5007 | 5007 | 2021-06-08 | Los Angeles | 37 | 1245429 | 24404 | 162 | 12 |
5239 | 5239 | 2021-06-04 | Los Angeles | 37 | 1244684 | 24379 | 211 | 12 |
6051 | 6051 | 2021-05-21 | Los Angeles | 37 | 1238382 | 24153 | 235 | 12 |
8041 | 8041 | 2021-04-17 | San Diego | 73 | 274811 | 3674 | 245 | 12 |
8269 | 8269 | 2021-04-13 | Riverside | 65 | 296801 | 4504 | 166 | 12 |
8559 | 8559 | 2021-04-08 | Riverside | 65 | 295896 | 4454 | 126 | 12 |
8672 | 8672 | 2021-04-06 | Orange | 59 | 251441 | 4784 | 131 | 12 |
8681 | 8681 | 2021-04-06 | San Joaquin | 77 | 70465 | 1325 | 220 | 12 |
8795 | 8795 | 2021-04-04 | San Diego | 73 | 271527 | 3583 | 193 | 12 |
10163 | 10163 | 2021-03-11 | Imperial | 25 | 26749 | 679 | 17 | 12 |
10343 | 10343 | 2021-03-08 | Los Angeles | 37 | 1204069 | 22041 | 917 | 12 |
10380 | 10380 | 2021-03-08 | Ventura | 111 | 78271 | 895 | 221 | 12 |
10535 | 10535 | 2021-03-05 | San Diego | 73 | 262360 | 3371 | 499 | 12 |
10670 | 10670 | 2021-03-03 | Ventura | 111 | 77783 | 870 | 108 | 12 |
10764 | 10764 | 2021-03-01 | Sacramento | 67 | 93528 | 1484 | 368 | 12 |
10876 | 10876 | 2021-02-27 | Orange | 59 | 246264 | 3904 | 281 | 12 |
10942 | 10942 | 2021-02-26 | San Francisco | 75 | 33910 | 410 | 131 | 12 |
10958 | 10958 | 2021-02-26 | Tulare | 107 | 47869 | 758 | 85 | 12 |
11053 | 11053 | 2021-02-24 | Riverside | 65 | 288960 | 3707 | 419 | 12 |
11057 | 11057 | 2021-02-24 | San Diego | 73 | 258463 | 3230 | 658 | 12 |
11192 | 11192 | 2021-02-22 | Ventura | 111 | 76578 | 794 | 344 | 12 |
11209 | 11209 | 2021-02-21 | Kern | 29 | 101738 | 773 | 125 | 12 |
11504 | 11504 | 2021-02-16 | Madera | 39 | 15064 | 201 | 98 | 12 |
11750 | 11750 | 2021-02-12 | Sacramento | 67 | 89965 | 1372 | 331 | 12 |
11817 | 11817 | 2021-02-11 | Santa Clara | 85 | 106716 | 1502 | 303 | 12 |
11828 | 11828 | 2021-02-11 | Tulare | 107 | 46608 | 684 | 131 | 12 |
11903 | 11903 | 2021-02-09 | Imperial | 25 | 26509 | 573 | 20 | 12 |
11947 | 11947 | 2021-02-09 | Yolo | 113 | 12060 | 170 | 48 | 12 |
12196 | 12196 | 2021-02-04 | Kings | 31 | 20981 | 189 | 87 | 12 |
12223 | 12223 | 2021-02-04 | Santa Clara | 85 | 104455 | 1439 | 397 | 12 |
12306 | 12306 | 2021-02-02 | Fresno | 19 | 91530 | 1185 | 328 | 12 |
12455 | 12455 | 2021-01-31 | Santa Clara | 85 | 102566 | 1384 | 276 | 12 |
12686 | 12686 | 2021-01-27 | Santa Barbara | 83 | 27532 | 279 | 383 | 12 |
12861 | 12861 | 2021-01-24 | Santa Clara | 85 | 99286 | 1302 | 345 | 12 |
12968 | 12968 | 2021-01-22 | Sacramento | 67 | 82066 | 1157 | 429 | 12 |
13005 | 13005 | 2021-01-21 | Imperial | 25 | 25324 | 486 | 53 | 12 |
13008 | 13008 | 2021-01-21 | Kings | 31 | 19703 | 160 | 115 | 12 |
13035 | 13035 | 2021-01-21 | Santa Clara | 85 | 97900 | 1257 | 780 | 12 |
13132 | 13132 | 2021-01-19 | Merced | 47 | 24452 | 308 | 960 | 12 |
13283 | 13283 | 2021-01-16 | Alameda | 1 | 66600 | 1055 | 1100 | 12 |
13452 | 13452 | 2021-01-14 | Tulare | 107 | 39723 | 494 | 376 | 12 |
13495 | 13495 | 2021-01-13 | San Joaquin | 77 | 54796 | 736 | 802 | 12 |
13611 | 13611 | 2021-01-11 | San Joaquin | 77 | 52400 | 724 | 877 | 12 |
13673 | 13673 | 2021-01-10 | Santa Clara | 85 | 87150 | 1049 | 696 | 12 |
13730 | 13730 | 2021-01-09 | Santa Barbara | 83 | 20550 | 197 | 597 | 12 |
13805 | 13805 | 2021-01-07 | Alameda | 1 | 57988 | 955 | 869 | 12 |
13916 | 13916 | 2021-01-06 | Tulare | 107 | 35890 | 433 | 604 | 12 |
14159 | 14159 | 2021-01-01 | Contra Costa | 13 | 41599 | 347 | 902 | 12 |
14211 | 14211 | 2020-12-31 | Alameda | 1 | 52507 | 858 | 937 | 12 |
14318 | 14318 | 2020-12-30 | Stanislaus | 99 | 34141 | 608 | 242 | 12 |
14650 | 14650 | 2020-12-24 | Sacramento | 67 | 59770 | 809 | 901 | 12 |
14675 | 14675 | 2020-12-23 | Alameda | 1 | 46738 | 762 | 959 | 12 |
14724 | 14724 | 2020-12-23 | Stanislaus | 99 | 31568 | 556 | 462 | 12 |
14766 | 14766 | 2020-12-22 | Sacramento | 67 | 58001 | 786 | 919 | 12 |
15023 | 15023 | 2020-12-17 | Alameda | 1 | 41643 | 691 | 772 | 12 |
15114 | 15114 | 2020-12-16 | Sacramento | 67 | 52182 | 711 | 1130 | 12 |
15119 | 15119 | 2020-12-16 | San Joaquin | 77 | 33336 | 549 | 695 | 12 |
15461 | 15461 | 2020-12-10 | Riverside | 65 | 111053 | 1551 | 3729 | 12 |
15868 | 15868 | 2020-12-03 | Sacramento | 67 | 40305 | 603 | 938 | 12 |
16741 | 16741 | 2020-11-18 | San Diego | 73 | 67241 | 945 | 922 | 12 |
17027 | 17027 | 2020-11-13 | Riverside | 65 | 74180 | 1367 | 639 | 12 |
17361 | 17361 | 2020-11-07 | Los Angeles | 37 | 320068 | 7170 | 2372 | 12 |
18289 | 18289 | 2020-10-22 | Los Angeles | 37 | 294138 | 6956 | 3580 | 12 |
20446 | 20446 | 2020-09-15 | Orange | 59 | 51124 | 1105 | 150 | 12 |
20620 | 20620 | 2020-09-12 | Orange | 59 | 50760 | 1093 | 147 | 12 |
20678 | 20678 | 2020-09-11 | Orange | 59 | 50613 | 1081 | 142 | 12 |
20801 | 20801 | 2020-09-09 | San Diego | 73 | 41324 | 721 | 247 | 12 |
21319 | 21319 | 2020-08-31 | Riverside | 65 | 52909 | 1019 | 1049 | 12 |
21726 | 21726 | 2020-08-24 | Sacramento | 67 | 16331 | 246 | 1085 | 12 |
21997 | 21997 | 2020-08-19 | Kern | 29 | 27184 | 228 | 216 | 12 |
22055 | 22055 | 2020-08-18 | Kern | 29 | 26968 | 216 | 180 | 12 |
22076 | 22076 | 2020-08-18 | San Bernardino | 71 | 42150 | 904 | 586 | 12 |
22282 | 22282 | 2020-08-14 | Fresno | 19 | 25040 | 203 | 224 | 12 |
22308 | 22308 | 2020-08-14 | San Bernardino | 71 | 39374 | 868 | 704 | 12 |
22461 | 22461 | 2020-08-11 | Kern | 29 | 24995 | 183 | 555 | 12 |
22485 | 22485 | 2020-08-11 | San Joaquin | 77 | 13870 | 235 | 1006 | 12 |
22543 | 22543 | 2020-08-10 | San Joaquin | 77 | 12864 | 223 | 561 | 12 |
22824 | 22824 | 2020-08-05 | Orange | 59 | 38131 | 665 | 65 | 12 |
22946 | 22946 | 2020-08-03 | San Bernardino | 71 | 33432 | 736 | 452 | 12 |
22949 | 22949 | 2020-08-03 | San Joaquin | 77 | 11885 | 180 | 402 | 12 |
23155 | 23155 | 2020-07-30 | Imperial | 25 | 9298 | 200 | 57 | 12 |
23273 | 23273 | 2020-07-28 | Kern | 29 | 16896 | 135 | 1893 | 12 |
23527 | 23527 | 2020-07-24 | San Diego | 73 | 26098 | 524 | 490 | 12 |
23799 | 23799 | 2020-07-19 | Los Angeles | 37 | 155917 | 4096 | 2738 | 12 |
24049 | 24049 | 2020-07-15 | San Diego | 73 | 21446 | 448 | 559 | 12 |
24106 | 24106 | 2020-07-14 | San Bernardino | 71 | 20456 | 450 | 954 | 12 |
24513 | 24513 | 2020-07-07 | San Diego | 73 | 17578 | 399 | 578 | 12 |
24895 | 24895 | 2020-06-30 | Imperial | 25 | 6242 | 93 | 55 | 12 |
24976 | 24976 | 2020-06-29 | San Bernardino | 71 | 11797 | 322 | 296 | 12 |
25724 | 25724 | 2020-06-16 | Orange | 59 | 8999 | 233 | 240 | 12 |
27116 | 27116 | 2020-05-23 | Orange | 59 | 5157 | 130 | 216 | 12 |
27815 | 27815 | 2020-05-11 | Riverside | 65 | 5189 | 217 | 150 | 12 |
27989 | 27989 | 2020-05-08 | Riverside | 65 | 4817 | 204 | 61 | 12 |
28779 | 28779 | 2020-04-24 | Riverside | 65 | 3315 | 112 | 97 | 12 |
29684 | 29684 | 2020-04-07 | San Diego | 73 | 1454 | 31 | 50 | 12 |
29981 | 29981 | 2020-04-01 | Los Angeles | 37 | 3528 | 66 | 491 | 12 |
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 );