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-02-11 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 |
---|---|---|---|---|---|---|---|---|
12384 | 12384 | Alameda | Alameda | 1 | 2021-02-11 | 74648 | 1150 | |
12385 | 12385 | Berkeley | Alameda | 1 | 2021-02-11 | 3075 | 44 | |
12386 | 12386 | Alpine | Alpine | 3 | 2021-02-11 | 79 | 0 | |
12387 | 12387 | Amador | Amador | 5 | 2021-02-11 | 3324 | 38 | |
12388 | 12388 | Butte | Butte | 7 | 2021-02-11 | 10624 | 149 | |
12389 | 12389 | Calaveras | Calaveras | 9 | 2021-02-11 | 1822 | 25 | |
12390 | 12390 | Colusa | Colusa | 11 | 2021-02-11 | 2069 | 11 | |
12391 | 12391 | Contra Costa | Contra Costa | 13 | 2021-02-11 | 59895 | 595 | |
12392 | 12392 | Del Norte | Del Norte | 15 | 2021-02-11 | 919 | 4 | |
12393 | 12393 | El Dorado | El Dorado | 17 | 2021-02-11 | 8827 | 88 | |
12394 | 12394 | Fresno | Fresno | 19 | 2021-02-11 | 93415 | 1291 | |
12395 | 12395 | Glenn | Glenn | 21 | 2021-02-11 | 2133 | 23 | |
12396 | 12396 | Humboldt | Humboldt | 23 | 2021-02-11 | 3009 | 32 | |
12397 | 12397 | Imperial | Imperial | 25 | 2021-02-11 | 26574 | 584 | |
12398 | 12398 | Inyo | Inyo | 27 | 2021-02-11 | 1180 | 34 | |
12399 | 12399 | Kern | Kern | 29 | 2021-02-11 | 99087 | 677 | |
12400 | 12400 | Kings | Kings | 31 | 2021-02-11 | 21443 | 205 | |
12401 | 12401 | Lake | Lake | 33 | 2021-02-11 | 2942 | 36 | |
12402 | 12402 | Lassen | Lassen | 35 | 2021-02-11 | 5498 | 19 | |
12403 | 12403 | Long Beach | Los Angeles | 37 | 2021-02-11 | 50072 | 754 | |
12404 | 12404 | Los Angeles | Los Angeles | 37 | 2021-02-11 | 1098135 | 17632 | |
12405 | 12405 | Pasadena | Los Angeles | 37 | 2021-02-11 | 10587 | 292 | |
12406 | 12406 | Madera | Madera | 39 | 2021-02-11 | 14923 | 189 | |
12407 | 12407 | Marin | Marin | 41 | 2021-02-11 | 12754 | 182 | |
12408 | 12408 | Mariposa | Mariposa | 43 | 2021-02-11 | 385 | 5 | |
12409 | 12409 | Mendocino | Mendocino | 45 | 2021-02-11 | 3659 | 40 | |
12410 | 12410 | Merced | Merced | 47 | 2021-02-11 | 27701 | 375 | |
12411 | 12411 | Modoc | Modoc | 49 | 2021-02-11 | 441 | 4 | |
12412 | 12412 | Mono | Mono | 51 | 2021-02-11 | 1196 | 4 | |
12413 | 12413 | Monterey | Monterey | 53 | 2021-02-11 | 41076 | 301 | |
12414 | 12414 | Napa | Napa | 55 | 2021-02-11 | 8718 | 59 | |
12415 | 12415 | Nevada | Nevada | 57 | 2021-02-11 | 3723 | 74 | |
12416 | 12416 | Orange | Orange | 59 | 2021-02-11 | 240999 | 3493 | |
12417 | 12417 | Placer | Placer | 61 | 2021-02-11 | 19175 | 222 | |
12418 | 12418 | Plumas | Plumas | 63 | 2021-02-11 | 641 | 6 | |
12419 | 12419 | Riverside | Riverside | 65 | 2021-02-11 | 284814 | 3477 | |
12420 | 12420 | Sacramento | Sacramento | 67 | 2021-02-11 | 89634 | 1360 | |
12421 | 12421 | San Benito | San Benito | 69 | 2021-02-11 | 5531 | 57 | |
12422 | 12422 | San Bernardino | San Bernardino | 71 | 2021-02-11 | 280068 | 4424 | |
12423 | 12423 | San Diego | San Diego | 73 | 2021-02-11 | 249974 | 2955 | |
12424 | 12424 | San Francisco | San Francisco | 75 | 2021-02-11 | 32695 | 351 | |
12425 | 12425 | San Joaquin | San Joaquin | 77 | 2021-02-11 | 64709 | 965 | |
12426 | 12426 | San Luis Obispo | San Luis Obispo | 79 | 2021-02-11 | 18889 | 205 | |
12427 | 12427 | San Mateo | San Mateo | 81 | 2021-02-11 | 37437 | 447 | |
12428 | 12428 | Santa Barbara | Santa Barbara | 83 | 2021-02-11 | 30502 | 366 | |
12429 | 12429 | Santa Clara | Santa Clara | 85 | 2021-02-11 | 106716 | 1502 | |
12430 | 12430 | Santa Cruz | Santa Cruz | 87 | 2021-02-11 | 14163 | 166 | |
12431 | 12431 | Shasta | Shasta | 89 | 2021-02-11 | 10718 | 170 | |
12432 | 12432 | Sierra | Sierra | 91 | 2021-02-11 | 97 | 0 | |
12433 | 12433 | Siskiyou | Siskiyou | 93 | 2021-02-11 | 1650 | 13 | |
12434 | 12434 | Solano | Solano | 95 | 2021-02-11 | 29251 | 140 | |
12435 | 12435 | Sonoma | Sonoma | 97 | 2021-02-11 | 27056 | 283 | |
12436 | 12436 | Stanislaus | Stanislaus | 99 | 2021-02-11 | 48376 | 888 | |
12437 | 12437 | Sutter | Sutter | 101 | 2021-02-11 | 8639 | 92 | |
12438 | 12438 | Tehama | Tehama | 103 | 2021-02-11 | 4883 | 48 | TRUE |
12439 | 12439 | Trinity | Trinity | 105 | 2021-02-11 | 321 | 5 | |
12440 | 12440 | Tulare | Tulare | 107 | 2021-02-11 | 46608 | 684 | |
12441 | 12441 | Tuolumne | Tuolumne | 109 | 2021-02-11 | 3774 | 52 | |
12442 | 12442 | Ventura | Ventura | 111 | 2021-02-11 | 74218 | 714 | |
12443 | 12443 | Yolo | Yolo | 113 | 2021-02-11 | 12138 | 172 | |
12444 | 12444 | Yuba | Yuba | 115 | 2021-02-11 | 5565 | 36 |
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 );