latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
57 rows where new_deaths = 16 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 15
- Los Angeles 13
- San Bernardino 6
- Sacramento 5
- Kern 4
- San Joaquin 4
- Ventura 4
- Alameda 3
- Orange 3
- Riverside 3
- San Diego 3
- Santa Clara 3
- Contra Costa 2
- San Mateo 2
- Imperial 1
- Merced 1
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
150 | 150 | 2021-08-31 | Sacramento | 67 | 136617 | 1923 | 3137 | 16 |
1585 | 1585 | 2021-08-06 | Los Angeles | 37 | 1319492 | 24756 | 3815 | 16 |
5839 | 5839 | 2021-05-25 | San Joaquin | 77 | 73717 | 1419 | 100 | 16 |
6515 | 6515 | 2021-05-13 | Los Angeles | 37 | 1236469 | 24057 | 213 | 16 |
6921 | 6921 | 2021-05-06 | Los Angeles | 37 | 1234782 | 23964 | 377 | 16 |
7037 | 7037 | 2021-05-04 | Los Angeles | 37 | 1234242 | 23930 | 244 | 16 |
8498 | 8498 | 2021-04-09 | Orange | 59 | 251698 | 4826 | 87 | 16 |
9467 | 9467 | 2021-03-23 | Imperial | 25 | 26946 | 715 | 26 | 16 |
9759 | 9759 | 2021-03-18 | Kern | 29 | 105222 | 1026 | 78 | 16 |
10165 | 10165 | 2021-03-11 | Kern | 29 | 104564 | 964 | 55 | 16 |
11346 | 11346 | 2021-02-19 | San Bernardino | 71 | 283873 | 4550 | 517 | 16 |
11351 | 11351 | 2021-02-19 | San Mateo | 81 | 38124 | 497 | 88 | 16 |
11482 | 11482 | 2021-02-17 | Ventura | 111 | 75896 | 767 | 179 | 16 |
11578 | 11578 | 2021-02-15 | San Bernardino | 71 | 282494 | 4497 | 325 | 16 |
11982 | 11982 | 2021-02-08 | Sacramento | 67 | 88775 | 1318 | 1071 | 16 |
12178 | 12178 | 2021-02-05 | Ventura | 111 | 72479 | 664 | 568 | 16 |
12397 | 12397 | 2021-02-01 | Santa Clara | 85 | 103112 | 1400 | 546 | 16 |
12449 | 12449 | 2021-01-31 | San Diego | 73 | 238042 | 2619 | 1274 | 16 |
12743 | 12743 | 2021-01-26 | San Mateo | 81 | 34510 | 356 | 216 | 16 |
12919 | 12919 | 2021-01-23 | Santa Clara | 85 | 98941 | 1290 | 422 | 16 |
12990 | 12990 | 2021-01-22 | Ventura | 111 | 63893 | 507 | 285 | 16 |
13289 | 13289 | 2021-01-16 | Contra Costa | 13 | 51573 | 446 | 946 | 16 |
13428 | 13428 | 2021-01-14 | Orange | 59 | 202753 | 2195 | 3221 | 16 |
13512 | 13512 | 2021-01-13 | Ventura | 111 | 54494 | 388 | 1563 | 16 |
13548 | 13548 | 2021-01-12 | Sacramento | 67 | 75236 | 1031 | 1135 | 16 |
13747 | 13747 | 2021-01-08 | Alameda | 1 | 59272 | 971 | 1284 | 16 |
13761 | 13761 | 2021-01-08 | Kern | 29 | 76673 | 539 | 1941 | 16 |
13785 | 13785 | 2021-01-08 | San Joaquin | 77 | 51523 | 712 | 1419 | 16 |
13789 | 13789 | 2021-01-08 | Santa Clara | 85 | 85584 | 1013 | 1143 | 16 |
13811 | 13811 | 2021-01-07 | Contra Costa | 13 | 44967 | 371 | 693 | 16 |
13863 | 13863 | 2021-01-06 | Alameda | 1 | 57119 | 943 | 680 | 16 |
14017 | 14017 | 2021-01-04 | San Joaquin | 77 | 46562 | 667 | 979 | 16 |
14037 | 14037 | 2021-01-03 | Alameda | 1 | 55064 | 893 | 548 | 16 |
14399 | 14399 | 2020-12-28 | Kern | 29 | 66526 | 502 | 1716 | 16 |
14408 | 14408 | 2020-12-28 | Merced | 47 | 18843 | 248 | 1058 | 16 |
14707 | 14707 | 2020-12-23 | Riverside | 65 | 156834 | 1805 | 5121 | 16 |
15056 | 15056 | 2020-12-17 | Sacramento | 67 | 53185 | 727 | 1003 | 16 |
15635 | 15635 | 2020-12-07 | Riverside | 65 | 92272 | 1488 | 4327 | 16 |
15929 | 15929 | 2020-12-02 | San Diego | 73 | 84638 | 1035 | 1217 | 16 |
16085 | 16085 | 2020-11-29 | Los Angeles | 37 | 395879 | 7639 | 4654 | 16 |
16393 | 16393 | 2020-11-24 | San Diego | 73 | 74361 | 984 | 1546 | 16 |
17129 | 17129 | 2020-11-11 | Los Angeles | 37 | 328058 | 7218 | 2024 | 16 |
17941 | 17941 | 2020-10-28 | Los Angeles | 37 | 303520 | 7043 | 1418 | 16 |
18071 | 18071 | 2020-10-26 | Riverside | 65 | 66732 | 1295 | 975 | 16 |
19391 | 19391 | 2020-10-03 | Los Angeles | 37 | 273699 | 6641 | 1040 | 16 |
22311 | 22311 | 2020-08-14 | San Joaquin | 77 | 14651 | 261 | 375 | 16 |
22366 | 22366 | 2020-08-13 | San Bernardino | 71 | 38670 | 856 | 380 | 16 |
22538 | 22538 | 2020-08-10 | Sacramento | 67 | 12040 | 177 | 1245 | 16 |
22650 | 22650 | 2020-08-08 | Orange | 59 | 39076 | 720 | 322 | 16 |
22714 | 22714 | 2020-08-07 | San Bernardino | 71 | 34939 | 791 | 304 | 16 |
22888 | 22888 | 2020-08-04 | San Bernardino | 71 | 34017 | 752 | 585 | 16 |
23700 | 23700 | 2020-07-21 | San Bernardino | 71 | 25067 | 554 | 968 | 16 |
25075 | 25075 | 2020-06-27 | Los Angeles | 37 | 95385 | 3285 | 1994 | 16 |
25365 | 25365 | 2020-06-22 | Los Angeles | 37 | 86017 | 3137 | 2603 | 16 |
25945 | 25945 | 2020-06-12 | Los Angeles | 37 | 70534 | 2834 | 1575 | 16 |
27047 | 27047 | 2020-05-24 | Los Angeles | 37 | 45034 | 2108 | 913 | 16 |
27859 | 27859 | 2020-05-10 | Los Angeles | 37 | 31703 | 1531 | 462 | 16 |
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 );