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-15 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
10432 | 10432 | Alameda | Alameda | 1 | 2021-03-15 | 79208 | 1192 | |
10433 | 10433 | Berkeley | Alameda | 1 | 2021-03-15 | 3372 | 45 | |
10434 | 10434 | Alpine | Alpine | 3 | 2021-03-15 | 85 | 0 | TRUE |
10435 | 10435 | Amador | Amador | 5 | 2021-03-15 | 3474 | 44 | |
10436 | 10436 | Butte | Butte | 7 | 2021-03-15 | 11141 | 171 | |
10437 | 10437 | Calaveras | Calaveras | 9 | 2021-03-15 | 1946 | 50 | |
10438 | 10438 | Colusa | Colusa | 11 | 2021-03-15 | 2155 | 14 | |
10439 | 10439 | Contra Costa | Contra Costa | 13 | 2021-03-15 | 64096 | 720 | |
10440 | 10440 | Del Norte | Del Norte | 15 | 2021-03-15 | 1068 | 5 | |
10441 | 10441 | El Dorado | El Dorado | 17 | 2021-03-15 | 9296 | 105 | |
10442 | 10442 | Fresno | Fresno | 19 | 2021-03-15 | 97637 | 1534 | |
10443 | 10443 | Glenn | Glenn | 21 | 2021-03-15 | 2217 | 23 | |
10444 | 10444 | Humboldt | Humboldt | 23 | 2021-03-15 | 3370 | 34 | |
10445 | 10445 | Imperial | Imperial | 25 | 2021-03-15 | 26814 | 680 | |
10446 | 10446 | Inyo | Inyo | 27 | 2021-03-15 | 1369 | 37 | |
10447 | 10447 | Kern | Kern | 29 | 2021-03-15 | 104943 | 988 | |
10448 | 10448 | Kings | Kings | 31 | 2021-03-15 | 22380 | 235 | |
10449 | 10449 | Lake | Lake | 33 | 2021-03-15 | 3215 | 43 | |
10450 | 10450 | Lassen | Lassen | 35 | 2021-03-15 | 5631 | 24 | |
10451 | 10451 | Long Beach | Los Angeles | 37 | 2021-03-15 | 51614 | 885 | |
10452 | 10452 | Los Angeles | Los Angeles | 37 | 2021-03-15 | 1148011 | 21263 | |
10453 | 10453 | Pasadena | Los Angeles | 37 | 2021-03-15 | 11032 | 327 | |
10454 | 10454 | Madera | Madera | 39 | 2021-03-15 | 15722 | 222 | |
10455 | 10455 | Marin | Marin | 41 | 2021-03-15 | 13462 | 198 | |
10456 | 10456 | Mariposa | Mariposa | 43 | 2021-03-15 | 398 | 7 | |
10457 | 10457 | Mendocino | Mendocino | 45 | 2021-03-15 | 3881 | 45 | |
10458 | 10458 | Merced | Merced | 47 | 2021-03-15 | 29940 | 423 | |
10459 | 10459 | Modoc | Modoc | 49 | 2021-03-15 | 464 | 4 | |
10460 | 10460 | Mono | Mono | 51 | 2021-03-15 | 1231 | 4 | |
10461 | 10461 | Monterey | Monterey | 53 | 2021-03-15 | 42575 | 336 | TRUE |
10462 | 10462 | Napa | Napa | 55 | 2021-03-15 | 9180 | 73 | |
10463 | 10463 | Nevada | Nevada | 57 | 2021-03-15 | 4125 | 74 | |
10464 | 10464 | Orange | Orange | 59 | 2021-03-15 | 248881 | 4486 | |
10465 | 10465 | Placer | Placer | 61 | 2021-03-15 | 20364 | 232 | |
10466 | 10466 | Plumas | Plumas | 63 | 2021-03-15 | 662 | 6 | |
10467 | 10467 | Riverside | Riverside | 65 | 2021-03-15 | 292293 | 3984 | |
10468 | 10468 | Sacramento | Sacramento | 67 | 2021-03-15 | 95441 | 1548 | |
10469 | 10469 | San Benito | San Benito | 69 | 2021-03-15 | 5788 | 61 | |
10470 | 10470 | San Bernardino | San Bernardino | 71 | 2021-03-15 | 288868 | 4689 | |
10471 | 10471 | San Diego | San Diego | 73 | 2021-03-15 | 265649 | 3452 | |
10472 | 10472 | San Francisco | San Francisco | 75 | 2021-03-15 | 34573 | 446 | |
10473 | 10473 | San Joaquin | San Joaquin | 77 | 2021-03-15 | 67817 | 1210 | TRUE |
10474 | 10474 | San Luis Obispo | San Luis Obispo | 79 | 2021-03-15 | 20078 | 253 | |
10475 | 10475 | San Mateo | San Mateo | 81 | 2021-03-15 | 39448 | 534 | |
10476 | 10476 | Santa Barbara | Santa Barbara | 83 | 2021-03-15 | 32634 | 429 | |
10477 | 10477 | Santa Clara | Santa Clara | 85 | 2021-03-15 | 112221 | 1629 | |
10478 | 10478 | Santa Cruz | Santa Cruz | 87 | 2021-03-15 | 15080 | 196 | |
10479 | 10479 | Shasta | Shasta | 89 | 2021-03-15 | 11084 | 192 | |
10480 | 10480 | Sierra | Sierra | 91 | 2021-03-15 | 101 | 0 | |
10481 | 10481 | Siskiyou | Siskiyou | 93 | 2021-03-15 | 1835 | 14 | |
10482 | 10482 | Solano | Solano | 95 | 2021-03-15 | 30581 | 177 | |
10483 | 10483 | Sonoma | Sonoma | 97 | 2021-03-15 | 28753 | 308 | TRUE |
10484 | 10484 | Stanislaus | Stanislaus | 99 | 2021-03-15 | 51706 | 972 | |
10485 | 10485 | Sutter | Sutter | 101 | 2021-03-15 | 8996 | 100 | |
10486 | 10486 | Tehama | Tehama | 103 | 2021-03-15 | 5160 | 53 | TRUE |
10487 | 10487 | Trinity | Trinity | 105 | 2021-03-15 | 378 | 5 | |
10488 | 10488 | Tulare | Tulare | 107 | 2021-03-15 | 48604 | 784 | |
10489 | 10489 | Tuolumne | Tuolumne | 109 | 2021-03-15 | 3994 | 59 | |
10490 | 10490 | Ventura | Ventura | 111 | 2021-03-15 | 78792 | 932 | |
10491 | 10491 | Yolo | Yolo | 113 | 2021-03-15 | 12996 | 190 | |
10492 | 10492 | Yuba | Yuba | 115 | 2021-03-15 | 5874 | 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 );