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-04-18 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 |
---|---|---|---|---|---|---|---|---|
8358 | 8358 | Alameda | Alameda | 1 | 2021-04-18 | 82438 | 1210 | |
8359 | 8359 | Berkeley | Alameda | 1 | 2021-04-18 | 3523 | 46 | |
8360 | 8360 | Alpine | Alpine | 3 | 2021-04-18 | 88 | 0 | TRUE |
8361 | 8361 | Amador | Amador | 5 | 2021-04-18 | 3593 | 46 | |
8362 | 8362 | Butte | Butte | 7 | 2021-04-18 | 11591 | 181 | TRUE |
8363 | 8363 | Calaveras | Calaveras | 9 | 2021-04-18 | 2055 | 51 | TRUE |
8364 | 8364 | Colusa | Colusa | 11 | 2021-04-18 | 2198 | 16 | TRUE |
8365 | 8365 | Contra Costa | Contra Costa | 13 | 2021-04-18 | 67019 | 768 | |
8366 | 8366 | Del Norte | Del Norte | 15 | 2021-04-18 | 1274 | 7 | TRUE |
8367 | 8367 | El Dorado | El Dorado | 17 | 2021-04-18 | 9719 | 109 | TRUE |
8368 | 8368 | Fresno | Fresno | 19 | 2021-04-18 | 100169 | 1646 | |
8369 | 8369 | Glenn | Glenn | 21 | 2021-04-18 | 2297 | 25 | TRUE |
8370 | 8370 | Humboldt | Humboldt | 23 | 2021-04-18 | 3587 | 37 | TRUE |
8371 | 8371 | Imperial | Imperial | 25 | 2021-04-18 | 27562 | 717 | |
8372 | 8372 | Inyo | Inyo | 27 | 2021-04-18 | 1417 | 38 | TRUE |
8373 | 8373 | Kern | Kern | 29 | 2021-04-18 | 107859 | 1322 | |
8374 | 8374 | Kings | Kings | 31 | 2021-04-18 | 22774 | 245 | |
8375 | 8375 | Lake | Lake | 33 | 2021-04-18 | 3378 | 43 | TRUE |
8376 | 8376 | Lassen | Lassen | 35 | 2021-04-18 | 5669 | 24 | |
8377 | 8377 | Long Beach | Los Angeles | 37 | 2021-04-18 | 52659 | 928 | TRUE |
8378 | 8378 | Los Angeles | Los Angeles | 37 | 2021-04-18 | 1165148 | 22355 | |
8379 | 8379 | Pasadena | Los Angeles | 37 | 2021-04-18 | 11190 | 340 | TRUE |
8380 | 8380 | Madera | Madera | 39 | 2021-04-18 | 16156 | 239 | TRUE |
8381 | 8381 | Marin | Marin | 41 | 2021-04-18 | 13861 | 207 | |
8382 | 8382 | Mariposa | Mariposa | 43 | 2021-04-18 | 424 | 7 | TRUE |
8383 | 8383 | Mendocino | Mendocino | 45 | 2021-04-18 | 3987 | 47 | TRUE |
8384 | 8384 | Merced | Merced | 47 | 2021-04-18 | 31196 | 452 | TRUE |
8385 | 8385 | Modoc | Modoc | 49 | 2021-04-18 | 488 | 4 | TRUE |
8386 | 8386 | Mono | Mono | 51 | 2021-04-18 | 1273 | 4 | TRUE |
8387 | 8387 | Monterey | Monterey | 53 | 2021-04-18 | 43267 | 357 | TRUE |
8388 | 8388 | Napa | Napa | 55 | 2021-04-18 | 9654 | 75 | TRUE |
8389 | 8389 | Nevada | Nevada | 57 | 2021-04-18 | 4447 | 75 | TRUE |
8390 | 8390 | Orange | Orange | 59 | 2021-04-18 | 252963 | 4896 | |
8391 | 8391 | Placer | Placer | 61 | 2021-04-18 | 21751 | 283 | TRUE |
8392 | 8392 | Plumas | Plumas | 63 | 2021-04-18 | 690 | 6 | TRUE |
8393 | 8393 | Riverside | Riverside | 65 | 2021-04-18 | 297215 | 4525 | TRUE |
8394 | 8394 | Sacramento | Sacramento | 67 | 2021-04-18 | 101058 | 1646 | TRUE |
8395 | 8395 | San Benito | San Benito | 69 | 2021-04-18 | 5973 | 63 | |
8396 | 8396 | San Bernardino | San Bernardino | 71 | 2021-04-18 | 294779 | 4776 | |
8397 | 8397 | San Diego | San Diego | 73 | 2021-04-18 | 274960 | 3674 | |
8398 | 8398 | San Francisco | San Francisco | 75 | 2021-04-18 | 35694 | 517 | TRUE |
8399 | 8399 | San Joaquin | San Joaquin | 77 | 2021-04-18 | 71431 | 1334 | TRUE |
8400 | 8400 | San Luis Obispo | San Luis Obispo | 79 | 2021-04-18 | 20917 | 256 | TRUE |
8401 | 8401 | San Mateo | San Mateo | 81 | 2021-04-18 | 41016 | 560 | TRUE |
8402 | 8402 | Santa Barbara | Santa Barbara | 83 | 2021-04-18 | 33896 | 444 | |
8403 | 8403 | Santa Clara | Santa Clara | 85 | 2021-04-18 | 116144 | 1672 | |
8404 | 8404 | Santa Cruz | Santa Cruz | 87 | 2021-04-18 | 15554 | 203 | TRUE |
8405 | 8405 | Shasta | Shasta | 89 | 2021-04-18 | 11677 | 217 | TRUE |
8406 | 8406 | Sierra | Sierra | 91 | 2021-04-18 | 110 | 0 | TRUE |
8407 | 8407 | Siskiyou | Siskiyou | 93 | 2021-04-18 | 1940 | 21 | TRUE |
8408 | 8408 | Solano | Solano | 95 | 2021-04-18 | 31875 | 211 | TRUE |
8409 | 8409 | Sonoma | Sonoma | 97 | 2021-04-18 | 29696 | 311 | |
8410 | 8410 | Stanislaus | Stanislaus | 99 | 2021-04-18 | 53899 | 1028 | TRUE |
8411 | 8411 | Sutter | Sutter | 101 | 2021-04-18 | 9268 | 104 | TRUE |
8412 | 8412 | Tehama | Tehama | 103 | 2021-04-18 | 5430 | 56 | TRUE |
8413 | 8413 | Trinity | Trinity | 105 | 2021-04-18 | 398 | 5 | TRUE |
8414 | 8414 | Tulare | Tulare | 107 | 2021-04-18 | 49383 | 829 | TRUE |
8415 | 8415 | Tuolumne | Tuolumne | 109 | 2021-04-18 | 4066 | 64 | TRUE |
8416 | 8416 | Ventura | Ventura | 111 | 2021-04-18 | 80230 | 1000 | |
8417 | 8417 | Yolo | Yolo | 113 | 2021-04-18 | 13468 | 199 | TRUE |
8418 | 8418 | Yuba | Yuba | 115 | 2021-04-18 | 6098 | 40 | TRUE |
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 );