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-07-13 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
25377 | 25377 | Alameda | Alameda | 1 | 2020-07-13 | 8079 | 201 | |
25378 | 25378 | Berkeley | Alameda | 1 | 2020-07-13 | 279 | 5 | |
25379 | 25379 | Alpine | Alpine | 3 | 2020-07-13 | 1 | 0 | TRUE |
25380 | 25380 | Amador | Amador | 5 | 2020-07-13 | 40 | 0 | |
25381 | 25381 | Butte | Butte | 7 | 2020-07-13 | 354 | 4 | |
25382 | 25382 | Calaveras | Calaveras | 9 | 2020-07-13 | 67 | 0 | TRUE |
25383 | 25383 | Colusa | Colusa | 11 | 2020-07-13 | 129 | 0 | |
25384 | 25384 | Contra Costa | Contra Costa | 13 | 2020-07-13 | 4886 | 90 | |
25385 | 25385 | Del Norte | Del Norte | 15 | 2020-07-13 | 61 | 0 | |
25386 | 25386 | El Dorado | El Dorado | 17 | 2020-07-13 | 337 | 0 | |
25387 | 25387 | Fresno | Fresno | 19 | 2020-07-13 | 15087 | 88 | TRUE |
25388 | 25388 | Glenn | Glenn | 21 | 2020-07-13 | 176 | 0 | |
25389 | 25389 | Humboldt | Humboldt | 23 | 2020-07-13 | 165 | 4 | |
25390 | 25390 | Imperial | Imperial | 25 | 2020-07-13 | 7977 | 136 | |
25391 | 25391 | Inyo | Inyo | 27 | 2020-07-13 | 37 | 1 | |
25392 | 25392 | Kern | Kern | 29 | 2020-07-13 | 6601 | 98 | |
25393 | 25393 | Kings | Kings | 31 | 2020-07-13 | 3024 | 40 | |
25394 | 25394 | Lake | Lake | 33 | 2020-07-13 | 121 | 1 | |
25395 | 25395 | Lassen | Lassen | 35 | 2020-07-13 | 428 | 0 | |
25396 | 25396 | Long Beach | Los Angeles | 37 | 2020-07-13 | 5616 | 149 | |
25397 | 25397 | Los Angeles | Los Angeles | 37 | 2020-07-13 | 129224 | 3575 | |
25398 | 25398 | Pasadena | Los Angeles | 37 | 2020-07-13 | 1544 | 100 | |
25399 | 25399 | Madera | Madera | 39 | 2020-07-13 | 893 | 8 | TRUE |
25400 | 25400 | Marin | Marin | 41 | 2020-07-13 | 3734 | 38 | |
25401 | 25401 | Mariposa | Mariposa | 43 | 2020-07-13 | 33 | 1 | |
25402 | 25402 | Mendocino | Mendocino | 45 | 2020-07-13 | 146 | 0 | |
25403 | 25403 | Merced | Merced | 47 | 2020-07-13 | 2082 | 12 | |
25404 | 25404 | Modoc | Modoc | 49 | 2020-07-13 | 0 | 0 | TRUE |
25405 | 25405 | Mono | Mono | 51 | 2020-07-13 | 52 | 1 | |
25406 | 25406 | Monterey | Monterey | 53 | 2020-07-13 | 2790 | 18 | |
25407 | 25407 | Napa | Napa | 55 | 2020-07-13 | 518 | 4 | |
25408 | 25408 | Nevada | Nevada | 57 | 2020-07-13 | 180 | 1 | |
25409 | 25409 | Orange | Orange | 59 | 2020-07-13 | 25255 | 424 | |
25410 | 25410 | Placer | Placer | 61 | 2020-07-13 | 1114 | 11 | |
25411 | 25411 | Plumas | Plumas | 63 | 2020-07-13 | 19 | 0 | |
25412 | 25412 | Riverside | Riverside | 65 | 2020-07-13 | 25748 | 550 | |
25413 | 25413 | Sacramento | Sacramento | 67 | 2020-07-13 | 5714 | 83 | |
25414 | 25414 | San Benito | San Benito | 69 | 2020-07-13 | 382 | 2 | |
25415 | 25415 | San Bernardino | San Bernardino | 71 | 2020-07-13 | 19502 | 438 | |
25416 | 25416 | San Diego | San Diego | 73 | 2020-07-13 | 20348 | 422 | |
25417 | 25417 | San Francisco | San Francisco | 75 | 2020-07-13 | 4590 | 50 | |
25418 | 25418 | San Joaquin | San Joaquin | 77 | 2020-07-13 | 6988 | 70 | |
25419 | 25419 | San Luis Obispo | San Luis Obispo | 79 | 2020-07-13 | 1006 | 5 | |
25420 | 25420 | San Mateo | San Mateo | 81 | 2020-07-13 | 4045 | 112 | |
25421 | 25421 | Santa Barbara | Santa Barbara | 83 | 2020-07-13 | 4140 | 31 | |
25422 | 25422 | Santa Clara | Santa Clara | 85 | 2020-07-13 | 7562 | 172 | |
25423 | 25423 | Santa Cruz | Santa Cruz | 87 | 2020-07-13 | 569 | 3 | |
25424 | 25424 | Shasta | Shasta | 89 | 2020-07-13 | 203 | 6 | |
25425 | 25425 | Sierra | Sierra | 91 | 2020-07-13 | 1 | 0 | |
25426 | 25426 | Siskiyou | Siskiyou | 93 | 2020-07-13 | 43 | 0 | |
25427 | 25427 | Solano | Solano | 95 | 2020-07-13 | 2219 | 31 | |
25428 | 25428 | Sonoma | Sonoma | 97 | 2020-07-13 | 1886 | 16 | |
25429 | 25429 | Stanislaus | Stanislaus | 99 | 2020-07-13 | 5178 | 51 | |
25430 | 25430 | Sutter | Sutter | 101 | 2020-07-13 | 421 | 4 | |
25431 | 25431 | Tehama | Tehama | 103 | 2020-07-13 | 115 | 1 | |
25432 | 25432 | Trinity | Trinity | 105 | 2020-07-13 | 2 | 0 | |
25433 | 25433 | Tulare | Tulare | 107 | 2020-07-13 | 5942 | 152 | |
25434 | 25434 | Tuolumne | Tuolumne | 109 | 2020-07-13 | 73 | 0 | |
25435 | 25435 | Ventura | Ventura | 111 | 2020-07-13 | 4619 | 53 | |
25436 | 25436 | Yolo | Yolo | 113 | 2020-07-13 | 966 | 28 | |
25437 | 25437 | Yuba | Yuba | 115 | 2020-07-13 | 211 | 3 |
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 );