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-06-16 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 |
---|---|---|---|---|---|---|---|---|
4759 | 4759 | Alameda | Alameda | 1 | 2021-06-16 | 85899 | 1217 | |
4760 | 4760 | Berkeley | Alameda | 1 | 2021-06-16 | 3636 | 46 | |
4761 | 4761 | Alpine | Alpine | 3 | 2021-06-16 | 89 | 0 | TRUE |
4762 | 4762 | Amador | Amador | 5 | 2021-06-16 | 3685 | 47 | TRUE |
4763 | 4763 | Butte | Butte | 7 | 2021-06-16 | 12635 | 192 | TRUE |
4764 | 4764 | Calaveras | Calaveras | 9 | 2021-06-16 | 2201 | 56 | |
4765 | 4765 | Colusa | Colusa | 11 | 2021-06-16 | 2284 | 18 | TRUE |
4766 | 4766 | Contra Costa | Contra Costa | 13 | 2021-06-16 | 70428 | 808 | |
4767 | 4767 | Del Norte | Del Norte | 15 | 2021-06-16 | 1454 | 7 | |
4768 | 4768 | El Dorado | El Dorado | 17 | 2021-06-16 | 10356 | 116 | |
4769 | 4769 | Fresno | Fresno | 19 | 2021-06-16 | 102235 | 1722 | |
4770 | 4770 | Glenn | Glenn | 21 | 2021-06-16 | 2359 | 27 | |
4771 | 4771 | Humboldt | Humboldt | 23 | 2021-06-16 | 4451 | 48 | |
4772 | 4772 | Imperial | Imperial | 25 | 2021-06-16 | 28287 | 741 | |
4773 | 4773 | Inyo | Inyo | 27 | 2021-06-16 | 1434 | 38 | TRUE |
4774 | 4774 | Kern | Kern | 29 | 2021-06-16 | 110687 | 1401 | |
4775 | 4775 | Kings | Kings | 31 | 2021-06-16 | 23093 | 247 | |
4776 | 4776 | Lake | Lake | 33 | 2021-06-16 | 3549 | 45 | TRUE |
4777 | 4777 | Lassen | Lassen | 35 | 2021-06-16 | 5799 | 24 | |
4778 | 4778 | Long Beach | Los Angeles | 37 | 2021-06-16 | 53515 | 945 | |
4779 | 4779 | Los Angeles | Los Angeles | 37 | 2021-06-16 | 1182001 | 23128 | |
4780 | 4780 | Pasadena | Los Angeles | 37 | 2021-06-16 | 11316 | 349 | |
4781 | 4781 | Madera | Madera | 39 | 2021-06-16 | 16493 | 245 | TRUE |
4782 | 4782 | Marin | Marin | 41 | 2021-06-16 | 14185 | 212 | |
4783 | 4783 | Mariposa | Mariposa | 43 | 2021-06-16 | 464 | 7 | |
4784 | 4784 | Mendocino | Mendocino | 45 | 2021-06-16 | 4289 | 50 | TRUE |
4785 | 4785 | Merced | Merced | 47 | 2021-06-16 | 32278 | 477 | |
4786 | 4786 | Modoc | Modoc | 49 | 2021-06-16 | 542 | 5 | TRUE |
4787 | 4787 | Mono | Mono | 51 | 2021-06-16 | 1295 | 4 | |
4788 | 4788 | Monterey | Monterey | 53 | 2021-06-16 | 43819 | 421 | |
4789 | 4789 | Napa | Napa | 55 | 2021-06-16 | 10001 | 79 | |
4790 | 4790 | Nevada | Nevada | 57 | 2021-06-16 | 4896 | 75 | |
4791 | 4791 | Orange | Orange | 59 | 2021-06-16 | 255728 | 5101 | |
4792 | 4792 | Placer | Placer | 61 | 2021-06-16 | 23438 | 299 | |
4793 | 4793 | Plumas | Plumas | 63 | 2021-06-16 | 736 | 6 | TRUE |
4794 | 4794 | Riverside | Riverside | 65 | 2021-06-16 | 301482 | 4624 | |
4795 | 4795 | Sacramento | Sacramento | 67 | 2021-06-16 | 107494 | 1726 | |
4796 | 4796 | San Benito | San Benito | 69 | 2021-06-16 | 6104 | 63 | |
4797 | 4797 | San Bernardino | San Bernardino | 71 | 2021-06-16 | 299096 | 4835 | |
4798 | 4798 | San Diego | San Diego | 73 | 2021-06-16 | 281422 | 3770 | |
4799 | 4799 | San Francisco | San Francisco | 75 | 2021-06-16 | 36885 | 550 | |
4800 | 4800 | San Joaquin | San Joaquin | 77 | 2021-06-16 | 74596 | 1435 | |
4801 | 4801 | San Luis Obispo | San Luis Obispo | 79 | 2021-06-16 | 21421 | 261 | TRUE |
4802 | 4802 | San Mateo | San Mateo | 81 | 2021-06-16 | 42274 | 581 | |
4803 | 4803 | Santa Barbara | Santa Barbara | 83 | 2021-06-16 | 34587 | 453 | |
4804 | 4804 | Santa Clara | Santa Clara | 85 | 2021-06-16 | 118837 | 1696 | |
4805 | 4805 | Santa Cruz | Santa Cruz | 87 | 2021-06-16 | 16222 | 207 | |
4806 | 4806 | Shasta | Shasta | 89 | 2021-06-16 | 12605 | 233 | TRUE |
4807 | 4807 | Sierra | Sierra | 91 | 2021-06-16 | 113 | 0 | |
4808 | 4808 | Siskiyou | Siskiyou | 93 | 2021-06-16 | 2392 | 37 | |
4809 | 4809 | Solano | Solano | 95 | 2021-06-16 | 33651 | 244 | |
4810 | 4810 | Sonoma | Sonoma | 97 | 2021-06-16 | 30783 | 316 | |
4811 | 4811 | Stanislaus | Stanislaus | 99 | 2021-06-16 | 56701 | 1068 | |
4812 | 4812 | Sutter | Sutter | 101 | 2021-06-16 | 9638 | 106 | |
4813 | 4813 | Tehama | Tehama | 103 | 2021-06-16 | 5724 | 59 | |
4814 | 4814 | Trinity | Trinity | 105 | 2021-06-16 | 422 | 5 | |
4815 | 4815 | Tulare | Tulare | 107 | 2021-06-16 | 49768 | 849 | |
4816 | 4816 | Tuolumne | Tuolumne | 109 | 2021-06-16 | 4206 | 71 | |
4817 | 4817 | Ventura | Ventura | 111 | 2021-06-16 | 81609 | 1025 | |
4818 | 4818 | Yolo | Yolo | 113 | 2021-06-16 | 14070 | 209 | |
4819 | 4819 | Yuba | Yuba | 115 | 2021-06-16 | 6464 | 41 |
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 );