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-16 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 |
---|---|---|---|---|---|---|---|---|
21412 | 21412 | Alameda | Alameda | 1 | 2020-09-16 | 19479 | 410 | TRUE |
21413 | 21413 | Berkeley | Alameda | 1 | 2020-09-16 | 654 | 10 | |
21414 | 21414 | Alpine | Alpine | 3 | 2020-09-16 | 2 | 0 | TRUE |
21415 | 21415 | Amador | Amador | 5 | 2020-09-16 | 248 | 15 | |
21416 | 21416 | Butte | Butte | 7 | 2020-09-16 | 2704 | 33 | |
21417 | 21417 | Calaveras | Calaveras | 9 | 2020-09-16 | 305 | 13 | TRUE |
21418 | 21418 | Colusa | Colusa | 11 | 2020-09-16 | 499 | 6 | |
21419 | 21419 | Contra Costa | Contra Costa | 13 | 2020-09-16 | 15544 | 197 | |
21420 | 21420 | Del Norte | Del Norte | 15 | 2020-09-16 | 135 | 1 | |
21421 | 21421 | El Dorado | El Dorado | 17 | 2020-09-16 | 1054 | 4 | |
21422 | 21422 | Fresno | Fresno | 19 | 2020-09-16 | 29522 | 348 | |
21423 | 21423 | Glenn | Glenn | 21 | 2020-09-16 | 547 | 3 | |
21424 | 21424 | Humboldt | Humboldt | 23 | 2020-09-16 | 481 | 6 | |
21425 | 21425 | Imperial | Imperial | 25 | 2020-09-16 | 11435 | 309 | |
21426 | 21426 | Inyo | Inyo | 27 | 2020-09-16 | 187 | 14 | |
21427 | 21427 | Kern | Kern | 29 | 2020-09-16 | 31076 | 340 | |
21428 | 21428 | Kings | Kings | 31 | 2020-09-16 | 7158 | 77 | |
21429 | 21429 | Lake | Lake | 33 | 2020-09-16 | 433 | 10 | |
21430 | 21430 | Lassen | Lassen | 35 | 2020-09-16 | 730 | 0 | |
21431 | 21431 | Long Beach | Los Angeles | 37 | 2020-09-16 | 11311 | 237 | |
21432 | 21432 | Los Angeles | Los Angeles | 37 | 2020-09-16 | 242398 | 5947 | |
21433 | 21433 | Pasadena | Los Angeles | 37 | 2020-09-16 | 2485 | 121 | |
21434 | 21434 | Madera | Madera | 39 | 2020-09-16 | 4267 | 58 | |
21435 | 21435 | Marin | Marin | 41 | 2020-09-16 | 6505 | 111 | |
21436 | 21436 | Mariposa | Mariposa | 43 | 2020-09-16 | 75 | 2 | |
21437 | 21437 | Mendocino | Mendocino | 45 | 2020-09-16 | 817 | 18 | |
21438 | 21438 | Merced | Merced | 47 | 2020-09-16 | 8692 | 131 | |
21439 | 21439 | Modoc | Modoc | 49 | 2020-09-16 | 23 | 0 | |
21440 | 21440 | Mono | Mono | 51 | 2020-09-16 | 163 | 2 | |
21441 | 21441 | Monterey | Monterey | 53 | 2020-09-16 | 9197 | 65 | |
21442 | 21442 | Napa | Napa | 55 | 2020-09-16 | 1581 | 12 | |
21443 | 21443 | Nevada | Nevada | 57 | 2020-09-16 | 497 | 5 | |
21444 | 21444 | Orange | Orange | 59 | 2020-09-16 | 51259 | 1111 | |
21445 | 21445 | Placer | Placer | 61 | 2020-09-16 | 3373 | 40 | |
21446 | 21446 | Plumas | Plumas | 63 | 2020-09-16 | 49 | 0 | TRUE |
21447 | 21447 | Riverside | Riverside | 65 | 2020-09-16 | 56201 | 1136 | |
21448 | 21448 | Sacramento | Sacramento | 67 | 2020-09-16 | 20660 | 364 | |
21449 | 21449 | San Benito | San Benito | 69 | 2020-09-16 | 1254 | 10 | |
21450 | 21450 | San Bernardino | San Bernardino | 71 | 2020-09-16 | 51252 | 1069 | |
21451 | 21451 | San Diego | San Diego | 73 | 2020-09-16 | 43445 | 748 | |
21452 | 21452 | San Francisco | San Francisco | 75 | 2020-09-16 | 10490 | 91 | |
21453 | 21453 | San Joaquin | San Joaquin | 77 | 2020-09-16 | 19623 | 399 | |
21454 | 21454 | San Luis Obispo | San Luis Obispo | 79 | 2020-09-16 | 3316 | 27 | |
21455 | 21455 | San Mateo | San Mateo | 81 | 2020-09-16 | 9264 | 142 | |
21456 | 21456 | Santa Barbara | Santa Barbara | 83 | 2020-09-16 | 8785 | 109 | |
21457 | 21457 | Santa Clara | Santa Clara | 85 | 2020-09-16 | 20306 | 288 | |
21458 | 21458 | Santa Cruz | Santa Cruz | 87 | 2020-09-16 | 2108 | 8 | |
21459 | 21459 | Shasta | Shasta | 89 | 2020-09-16 | 652 | 12 | |
21460 | 21460 | Sierra | Sierra | 91 | 2020-09-16 | 6 | 0 | |
21461 | 21461 | Siskiyou | Siskiyou | 93 | 2020-09-16 | 159 | 0 | |
21462 | 21462 | Solano | Solano | 95 | 2020-09-16 | 6007 | 52 | |
21463 | 21463 | Sonoma | Sonoma | 97 | 2020-09-16 | 6827 | 114 | |
21464 | 21464 | Stanislaus | Stanislaus | 99 | 2020-09-16 | 16077 | 321 | |
21465 | 21465 | Sutter | Sutter | 101 | 2020-09-16 | 1621 | 10 | |
21466 | 21466 | Tehama | Tehama | 103 | 2020-09-16 | 480 | 3 | |
21467 | 21467 | Trinity | Trinity | 105 | 2020-09-16 | 15 | 0 | |
21468 | 21468 | Tulare | Tulare | 107 | 2020-09-16 | 15486 | 255 | |
21469 | 21469 | Tuolumne | Tuolumne | 109 | 2020-09-16 | 216 | 3 | |
21470 | 21470 | Ventura | Ventura | 111 | 2020-09-16 | 11842 | 141 | |
21471 | 21471 | Yolo | Yolo | 113 | 2020-09-16 | 2710 | 53 | |
21472 | 21472 | Yuba | Yuba | 115 | 2020-09-16 | 1108 | 7 |
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 );