latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
61 rows where "date" is on date 2020-09-30 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
20558 | 20558 | Alameda | Alameda | 1 | 2020-09-30 | 20658 | 421 | |
20559 | 20559 | Berkeley | Alameda | 1 | 2020-09-30 | 705 | 10 | |
20560 | 20560 | Alpine | Alpine | 3 | 2020-09-30 | 2 | 0 | TRUE |
20561 | 20561 | Amador | Amador | 5 | 2020-09-30 | 257 | 15 | |
20562 | 20562 | Butte | Butte | 7 | 2020-09-30 | 2858 | 45 | |
20563 | 20563 | Calaveras | Calaveras | 9 | 2020-09-30 | 322 | 14 | TRUE |
20564 | 20564 | Colusa | Colusa | 11 | 2020-09-30 | 536 | 6 | |
20565 | 20565 | Contra Costa | Contra Costa | 13 | 2020-09-30 | 16896 | 209 | |
20566 | 20566 | Del Norte | Del Norte | 15 | 2020-09-30 | 144 | 1 | TRUE |
20567 | 20567 | El Dorado | El Dorado | 17 | 2020-09-30 | 1150 | 4 | |
20568 | 20568 | Fresno | Fresno | 19 | 2020-09-30 | 30782 | 390 | |
20569 | 20569 | Glenn | Glenn | 21 | 2020-09-30 | 597 | 3 | |
20570 | 20570 | Humboldt | Humboldt | 23 | 2020-09-30 | 512 | 8 | |
20571 | 20571 | Imperial | Imperial | 25 | 2020-09-30 | 11908 | 320 | |
20572 | 20572 | Inyo | Inyo | 27 | 2020-09-30 | 188 | 15 | |
20573 | 20573 | Kern | Kern | 29 | 2020-09-30 | 32128 | 370 | |
20574 | 20574 | Kings | Kings | 31 | 2020-09-30 | 7682 | 80 | |
20575 | 20575 | Lake | Lake | 33 | 2020-09-30 | 566 | 11 | |
20576 | 20576 | Lassen | Lassen | 35 | 2020-09-30 | 741 | 0 | TRUE |
20577 | 20577 | Long Beach | Los Angeles | 37 | 2020-09-30 | 11950 | 246 | |
20578 | 20578 | Los Angeles | Los Angeles | 37 | 2020-09-30 | 255831 | 6207 | |
20579 | 20579 | Pasadena | Los Angeles | 37 | 2020-09-30 | 2580 | 124 | |
20580 | 20580 | Madera | Madera | 39 | 2020-09-30 | 4583 | 68 | |
20581 | 20581 | Marin | Marin | 41 | 2020-09-30 | 6742 | 119 | |
20582 | 20582 | Mariposa | Mariposa | 43 | 2020-09-30 | 76 | 2 | |
20583 | 20583 | Mendocino | Mendocino | 45 | 2020-09-30 | 964 | 19 | |
20584 | 20584 | Merced | Merced | 47 | 2020-09-30 | 8993 | 145 | |
20585 | 20585 | Modoc | Modoc | 49 | 2020-09-30 | 27 | 0 | TRUE |
20586 | 20586 | Mono | Mono | 51 | 2020-09-30 | 167 | 2 | |
20587 | 20587 | Monterey | Monterey | 53 | 2020-09-30 | 10087 | 73 | |
20588 | 20588 | Napa | Napa | 55 | 2020-09-30 | 1727 | 12 | |
20589 | 20589 | Nevada | Nevada | 57 | 2020-09-30 | 543 | 7 | |
20590 | 20590 | Orange | Orange | 59 | 2020-09-30 | 53751 | 1268 | |
20591 | 20591 | Placer | Placer | 61 | 2020-09-30 | 3604 | 48 | |
20592 | 20592 | Plumas | Plumas | 63 | 2020-09-30 | 50 | 0 | TRUE |
20593 | 20593 | Riverside | Riverside | 65 | 2020-09-30 | 59405 | 1226 | |
20594 | 20594 | Sacramento | Sacramento | 67 | 2020-09-30 | 22654 | 420 | |
20595 | 20595 | San Benito | San Benito | 69 | 2020-09-30 | 1352 | 11 | |
20596 | 20596 | San Bernardino | San Bernardino | 71 | 2020-09-30 | 55203 | 1115 | |
20597 | 20597 | San Diego | San Diego | 73 | 2020-09-30 | 47180 | 783 | |
20598 | 20598 | San Francisco | San Francisco | 75 | 2020-09-30 | 11275 | 104 | |
20599 | 20599 | San Joaquin | San Joaquin | 77 | 2020-09-30 | 20411 | 456 | |
20600 | 20600 | San Luis Obispo | San Luis Obispo | 79 | 2020-09-30 | 3629 | 31 | |
20601 | 20601 | San Mateo | San Mateo | 81 | 2020-09-30 | 9990 | 150 | |
20602 | 20602 | Santa Barbara | Santa Barbara | 83 | 2020-09-30 | 9197 | 114 | |
20603 | 20603 | Santa Clara | Santa Clara | 85 | 2020-09-30 | 21805 | 315 | |
20604 | 20604 | Santa Cruz | Santa Cruz | 87 | 2020-09-30 | 2423 | 12 | |
20605 | 20605 | Shasta | Shasta | 89 | 2020-09-30 | 894 | 20 | |
20606 | 20606 | Sierra | Sierra | 91 | 2020-09-30 | 6 | 0 | |
20607 | 20607 | Siskiyou | Siskiyou | 93 | 2020-09-30 | 166 | 0 | |
20608 | 20608 | Solano | Solano | 95 | 2020-09-30 | 6445 | 71 | |
20609 | 20609 | Sonoma | Sonoma | 97 | 2020-09-30 | 7578 | 122 | |
20610 | 20610 | Stanislaus | Stanislaus | 99 | 2020-09-30 | 16512 | 362 | |
20611 | 20611 | Sutter | Sutter | 101 | 2020-09-30 | 1726 | 11 | |
20612 | 20612 | Tehama | Tehama | 103 | 2020-09-30 | 584 | 5 | |
20613 | 20613 | Trinity | Trinity | 105 | 2020-09-30 | 16 | 0 | |
20614 | 20614 | Tulare | Tulare | 107 | 2020-09-30 | 16267 | 263 | |
20615 | 20615 | Tuolumne | Tuolumne | 109 | 2020-09-30 | 228 | 4 | |
20616 | 20616 | Ventura | Ventura | 111 | 2020-09-30 | 12787 | 152 | |
20617 | 20617 | Yolo | Yolo | 113 | 2020-09-30 | 2828 | 55 | |
20618 | 20618 | Yuba | Yuba | 115 | 2020-09-30 | 1177 | 8 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );