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 2021-03-29 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
9578 | 9578 | Alameda | Alameda | 1 | 2021-03-29 | 80390 | 1203 | |
9579 | 9579 | Berkeley | Alameda | 1 | 2021-03-29 | 3437 | 46 | |
9580 | 9580 | Alpine | Alpine | 3 | 2021-03-29 | 88 | ||
9581 | 9581 | Amador | Amador | 5 | 2021-03-29 | 3515 | 45 | |
9582 | 9582 | Butte | Butte | 7 | 2021-03-29 | 11291 | 178 | |
9583 | 9583 | Calaveras | Calaveras | 9 | 2021-03-29 | 2006 | 51 | |
9584 | 9584 | Colusa | Colusa | 11 | 2021-03-29 | 2164 | 16 | TRUE |
9585 | 9585 | Contra Costa | Contra Costa | 13 | 2021-03-29 | 65230 | 754 | |
9586 | 9586 | Del Norte | Del Norte | 15 | 2021-03-29 | 1138 | 5 | |
9587 | 9587 | El Dorado | El Dorado | 17 | 2021-03-29 | 9441 | 107 | |
9588 | 9588 | Fresno | Fresno | 19 | 2021-03-29 | 98954 | 1592 | |
9589 | 9589 | Glenn | Glenn | 21 | 2021-03-29 | 2257 | 25 | |
9590 | 9590 | Humboldt | Humboldt | 23 | 2021-03-29 | 3473 | 36 | |
9591 | 9591 | Imperial | Imperial | 25 | 2021-03-29 | 27103 | 715 | |
9592 | 9592 | Inyo | Inyo | 27 | 2021-03-29 | 1397 | 37 | |
9593 | 9593 | Kern | Kern | 29 | 2021-03-29 | 106127 | 1239 | |
9594 | 9594 | Kings | Kings | 31 | 2021-03-29 | 22610 | 241 | |
9595 | 9595 | Lake | Lake | 33 | 2021-03-29 | 3309 | 43 | |
9596 | 9596 | Lassen | Lassen | 35 | 2021-03-29 | 5652 | 24 | |
9597 | 9597 | Long Beach | Los Angeles | 37 | 2021-03-29 | 52094 | 908 | |
9598 | 9598 | Los Angeles | Los Angeles | 37 | 2021-03-29 | 1155414 | 21841 | |
9599 | 9599 | Pasadena | Los Angeles | 37 | 2021-03-29 | 11135 | 335 | |
9600 | 9600 | Madera | Madera | 39 | 2021-03-29 | 15903 | 231 | |
9601 | 9601 | Marin | Marin | 41 | 2021-03-29 | 13664 | 203 | |
9602 | 9602 | Mariposa | Mariposa | 43 | 2021-03-29 | 410 | 7 | |
9603 | 9603 | Mendocino | Mendocino | 45 | 2021-03-29 | 3939 | 46 | |
9604 | 9604 | Merced | Merced | 47 | 2021-03-29 | 30521 | 435 | |
9605 | 9605 | Modoc | Modoc | 49 | 2021-03-29 | 474 | 4 | |
9606 | 9606 | Mono | Mono | 51 | 2021-03-29 | 1262 | 4 | |
9607 | 9607 | Monterey | Monterey | 53 | 2021-03-29 | 42890 | 340 | |
9608 | 9608 | Napa | Napa | 55 | 2021-03-29 | 9384 | 78 | |
9609 | 9609 | Nevada | Nevada | 57 | 2021-03-29 | 4256 | 74 | |
9610 | 9610 | Orange | Orange | 59 | 2021-03-29 | 250431 | 4726 | |
9611 | 9611 | Placer | Placer | 61 | 2021-03-29 | 20888 | 272 | |
9612 | 9612 | Plumas | Plumas | 63 | 2021-03-29 | 682 | 6 | |
9613 | 9613 | Riverside | Riverside | 65 | 2021-03-29 | 294063 | 4273 | |
9614 | 9614 | Sacramento | Sacramento | 67 | 2021-03-29 | 97481 | 1602 | |
9615 | 9615 | San Benito | San Benito | 69 | 2021-03-29 | 5852 | 61 | |
9616 | 9616 | San Bernardino | San Bernardino | 71 | 2021-03-29 | 290715 | 4733 | |
9617 | 9617 | San Diego | San Diego | 73 | 2021-03-29 | 269770 | 3547 | |
9618 | 9618 | San Francisco | San Francisco | 75 | 2021-03-29 | 35029 | 463 | |
9619 | 9619 | San Joaquin | San Joaquin | 77 | 2021-03-29 | 69550 | 1259 | |
9620 | 9620 | San Luis Obispo | San Luis Obispo | 79 | 2021-03-29 | 20433 | 255 | |
9621 | 9621 | San Mateo | San Mateo | 81 | 2021-03-29 | 40290 | 547 | |
9622 | 9622 | Santa Barbara | Santa Barbara | 83 | 2021-03-29 | 33105 | 436 | |
9623 | 9623 | Santa Clara | Santa Clara | 85 | 2021-03-29 | 113719 | 1651 | |
9624 | 9624 | Santa Cruz | Santa Cruz | 87 | 2021-03-29 | 15247 | 200 | |
9625 | 9625 | Shasta | Shasta | 89 | 2021-03-29 | 11353 | 204 | |
9626 | 9626 | Sierra | Sierra | 91 | 2021-03-29 | 104 | 0 | |
9627 | 9627 | Siskiyou | Siskiyou | 93 | 2021-03-29 | 1875 | 16 | |
9628 | 9628 | Solano | Solano | 95 | 2021-03-29 | 31121 | 197 | |
9629 | 9629 | Sonoma | Sonoma | 97 | 2021-03-29 | 29219 | 308 | |
9630 | 9630 | Stanislaus | Stanislaus | 99 | 2021-03-29 | 52473 | 996 | |
9631 | 9631 | Sutter | Sutter | 101 | 2021-03-29 | 9134 | 102 | |
9632 | 9632 | Tehama | Tehama | 103 | 2021-03-29 | 5282 | 54 | |
9633 | 9633 | Trinity | Trinity | 105 | 2021-03-29 | 390 | 5 | |
9634 | 9634 | Tulare | Tulare | 107 | 2021-03-29 | 49005 | 809 | |
9635 | 9635 | Tuolumne | Tuolumne | 109 | 2021-03-29 | 4031 | 62 | |
9636 | 9636 | Ventura | Ventura | 111 | 2021-03-29 | 79588 | 972 | |
9637 | 9637 | Yolo | Yolo | 113 | 2021-03-29 | 13218 | 196 | |
9638 | 9638 | Yuba | Yuba | 115 | 2021-03-29 | 5981 | 40 |
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 );