latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
53 rows where "date" is on date 2020-04-08 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, new_deaths, date (date)
fips >30
county >30
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
29598 | 29598 | 2020-04-08 | Alameda | 1 | 712 | 55 | 29 | 4 |
29599 | 29599 | 2020-04-08 | Alpine | 3 | 1 | 0 | 0 | 0 |
29600 | 29600 | 2020-04-08 | Amador | 5 | 3 | 0 | 0 | 0 |
29601 | 29601 | 2020-04-08 | Butte | 7 | 11 | 0 | 0 | 0 |
29602 | 29602 | 2020-04-08 | Calaveras | 9 | 5 | 0 | 0 | 0 |
29603 | 29603 | 2020-04-08 | Colusa | 11 | 3 | 0 | 0 | 0 |
29604 | 29604 | 2020-04-08 | Contra Costa | 13 | 482 | 7 | 21 | 0 |
29605 | 29605 | 2020-04-08 | Del Norte | 15 | 2 | 0 | 0 | 0 |
29606 | 29606 | 2020-04-08 | El Dorado | 17 | 29 | 0 | 1 | 0 |
29607 | 29607 | 2020-04-08 | Fresno | 19 | 372 | 3 | 15 | 0 |
29608 | 29608 | 2020-04-08 | Glenn | 21 | 2 | 0 | 0 | 0 |
29609 | 29609 | 2020-04-08 | Humboldt | 23 | 50 | 0 | 0 | 0 |
29610 | 29610 | 2020-04-08 | Imperial | 25 | 75 | 3 | 2 | 0 |
29611 | 29611 | 2020-04-08 | Inyo | 27 | 11 | 0 | 0 | 0 |
29612 | 29612 | 2020-04-08 | Kern | 29 | 303 | 2 | 42 | 0 |
29613 | 29613 | 2020-04-08 | Kings | 31 | 8 | 0 | 3 | 0 |
29614 | 29614 | 2020-04-08 | Lake | 33 | 3 | 0 | 1 | 0 |
29615 | 29615 | 2020-04-08 | Los Angeles | 37 | 7573 | 200 | 629 | 27 |
29616 | 29616 | 2020-04-08 | Madera | 39 | 28 | 1 | 0 | 0 |
29617 | 29617 | 2020-04-08 | Marin | 41 | 149 | 10 | 1 | 0 |
29618 | 29618 | 2020-04-08 | Mendocino | 45 | 4 | 0 | 0 | 0 |
29619 | 29619 | 2020-04-08 | Merced | 47 | 40 | 3 | 6 | 2 |
29620 | 29620 | 2020-04-08 | Mono | 51 | 20 | 1 | 1 | 0 |
29621 | 29621 | 2020-04-08 | Monterey | 53 | 69 | 3 | 5 | 1 |
29622 | 29622 | 2020-04-08 | Napa | 55 | 25 | 2 | 2 | 0 |
29623 | 29623 | 2020-04-08 | Nevada | 57 | 34 | 1 | 0 | 0 |
29624 | 29624 | 2020-04-08 | Orange | 59 | 998 | 17 | 89 | 2 |
29625 | 29625 | 2020-04-08 | Placer | 61 | 117 | 4 | 2 | 1 |
29626 | 29626 | 2020-04-08 | Plumas | 63 | 3 | 0 | 0 | 0 |
29627 | 29627 | 2020-04-08 | Riverside | 65 | 1179 | 32 | 163 | 4 |
29628 | 29628 | 2020-04-08 | Sacramento | 67 | 580 | 22 | 55 | 1 |
29629 | 29629 | 2020-04-08 | San Benito | 69 | 33 | 2 | 2 | 0 |
29630 | 29630 | 2020-04-08 | San Bernardino | 71 | 641 | 26 | 94 | 1 |
29631 | 29631 | 2020-04-08 | San Diego | 73 | 1530 | 36 | 76 | 5 |
29632 | 29632 | 2020-04-08 | San Francisco | 75 | 676 | 10 | 54 | 1 |
29633 | 29633 | 2020-04-08 | San Joaquin | 77 | 224 | 14 | 8 | 1 |
29634 | 29634 | 2020-04-08 | San Luis Obispo | 79 | 102 | 1 | 3 | 0 |
29635 | 29635 | 2020-04-08 | San Mateo | 81 | 617 | 21 | 28 | 0 |
29636 | 29636 | 2020-04-08 | Santa Barbara | 83 | 228 | 2 | 10 | 0 |
29637 | 29637 | 2020-04-08 | Santa Clara | 85 | 1535 | 51 | 72 | 2 |
29638 | 29638 | 2020-04-08 | Santa Cruz | 87 | 76 | 1 | 0 | 0 |
29639 | 29639 | 2020-04-08 | Shasta | 89 | 24 | 3 | 1 | 0 |
29640 | 29640 | 2020-04-08 | Siskiyou | 93 | 4 | 0 | 0 | 0 |
29641 | 29641 | 2020-04-08 | Solano | 95 | 112 | 2 | 13 | 0 |
29642 | 29642 | 2020-04-08 | Sonoma | 97 | 136 | 1 | 16 | 0 |
29643 | 29643 | 2020-04-08 | Stanislaus | 99 | 95 | 0 | 5 | 0 |
29644 | 29644 | 2020-04-08 | Sutter | 101 | 20 | 2 | 1 | 0 |
29645 | 29645 | 2020-04-08 | Tehama | 103 | 1 | 0 | 0 | 0 |
29646 | 29646 | 2020-04-08 | Tulare | 107 | 168 | 9 | 11 | 3 |
29647 | 29647 | 2020-04-08 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
29648 | 29648 | 2020-04-08 | Ventura | 111 | 263 | 7 | 20 | 1 |
29649 | 29649 | 2020-04-08 | Yolo | 113 | 67 | 3 | 11 | 1 |
29650 | 29650 | 2020-04-08 | Yuba | 115 | 15 | 0 | 2 | 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 );