latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
306 rows where place = "94606: Oakland" sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
| Link | rowid | date ▲ | county | fips | place | confirmed_cases | note | x | y | population |
|---|---|---|---|---|---|---|---|---|---|---|
| 30 | 30 | 2021-01-14 | Alameda | 1 | 94606: Oakland | 1566 | -122.244658 | 37.792494 | 37076 | |
| 1355 | 1355 | 2021-01-13 | Alameda | 1 | 94606: Oakland | 1566 | -122.244658 | 37.792494 | 37076 | |
| 2690 | 2690 | 2021-01-12 | Alameda | 1 | 94606: Oakland | 1536 | -122.244658 | 37.792494 | 37076 | |
| 4031 | 4031 | 2021-01-11 | Alameda | 1 | 94606: Oakland | 1509 | -122.244658 | 37.792494 | 37076 | |
| 5367 | 5367 | 2021-01-10 | Alameda | 1 | 94606: Oakland | 1456 | -122.244658 | 37.792494 | 37076 | |
| 6621 | 6621 | 2021-01-09 | Alameda | 1 | 94606: Oakland | 1456 | -122.244658 | 37.792494 | 37076 | |
| 7940 | 7940 | 2021-01-08 | Alameda | 1 | 94606: Oakland | 1411 | -122.244658 | 37.792494 | 37076 | |
| 9280 | 9280 | 2021-01-07 | Alameda | 1 | 94606: Oakland | 1397 | -122.244658 | 37.792494 | 37076 | |
| 10615 | 10615 | 2021-01-06 | Alameda | 1 | 94606: Oakland | 1397 | -122.244658 | 37.792494 | 37076 | |
| 11945 | 11945 | 2021-01-05 | Alameda | 1 | 94606: Oakland | 1328 | -122.244658 | 37.792494 | 37076 | |
| 13286 | 13286 | 2021-01-04 | Alameda | 1 | 94606: Oakland | 1328 | -122.244658 | 37.792494 | 37076 | |
| 14616 | 14616 | 2021-01-03 | Alameda | 1 | 94606: Oakland | 1324 | -122.244658 | 37.792494 | 37076 | |
| 15913 | 15913 | 2021-01-02 | Alameda | 1 | 94606: Oakland | 1309 | -122.244658 | 37.792494 | 37076 | |
| 17210 | 17210 | 2021-01-01 | Alameda | 1 | 94606: Oakland | 1309 | -122.244658 | 37.792494 | 37076 | |
| 18500 | 18500 | 2020-12-31 | Alameda | 1 | 94606: Oakland | 1294 | -122.244658 | 37.792494 | 37076 | |
| 19810 | 19810 | 2020-12-30 | Alameda | 1 | 94606: Oakland | 1264 | -122.244658 | 37.792494 | 37076 | |
| 21120 | 21120 | 2020-12-29 | Alameda | 1 | 94606: Oakland | 1264 | -122.244658 | 37.792494 | 37076 | |
| 22425 | 22425 | 2020-12-28 | Alameda | 1 | 94606: Oakland | 1257 | -122.244658 | 37.792494 | 37076 | |
| 23676 | 23676 | 2020-12-27 | Alameda | 1 | 94606: Oakland | 1245 | -122.244658 | 37.792494 | 37076 | |
| 24894 | 24894 | 2020-12-26 | Alameda | 1 | 94606: Oakland | 1238 | -122.244658 | 37.792494 | 37076 | |
| 26116 | 26116 | 2020-12-25 | Alameda | 1 | 94606: Oakland | 1214 | -122.244658 | 37.792494 | 37076 | |
| 26925 | 26925 | 2020-12-24 | Alameda | 1 | 94606: Oakland | 1214 | -122.244658 | 37.792494 | 37076 | |
| 28146 | 28146 | 2020-12-23 | Alameda | 1 | 94606: Oakland | 1200 | -122.244658 | 37.792494 | 37076 | |
| 29447 | 29447 | 2020-12-22 | Alameda | 1 | 94606: Oakland | 1165 | -122.244658 | 37.792494 | 37076 | |
| 30670 | 30670 | 2020-12-21 | Alameda | 1 | 94606: Oakland | 1165 | -122.244658 | 37.792494 | 37076 | |
| 31987 | 31987 | 2020-12-20 | Alameda | 1 | 94606: Oakland | 1148 | -122.244658 | 37.792494 | 37076 | |
| 33163 | 33163 | 2020-12-19 | Alameda | 1 | 94606: Oakland | 1103 | -122.244658 | 37.792494 | 37076 | |
| 34342 | 34342 | 2020-12-18 | Alameda | 1 | 94606: Oakland | 1103 | -122.244658 | 37.792494 | 37076 | |
| 35647 | 35647 | 2020-12-17 | Alameda | 1 | 94606: Oakland | 1103 | -122.244658 | 37.792494 | 37076 | |
| 36930 | 36930 | 2020-12-16 | Alameda | 1 | 94606: Oakland | 1090 | -122.244658 | 37.792494 | 37076 | |
| 38211 | 38211 | 2020-12-15 | Alameda | 1 | 94606: Oakland | 1075 | -122.244658 | 37.792494 | 37076 | |
| 39502 | 39502 | 2020-12-14 | Alameda | 1 | 94606: Oakland | 1064 | -122.244658 | 37.792494 | 37076 | |
| 40797 | 40797 | 2020-12-13 | Alameda | 1 | 94606: Oakland | 1025 | -122.244658 | 37.792494 | 37076 | |
| 41959 | 41959 | 2020-12-12 | Alameda | 1 | 94606: Oakland | 1025 | -122.244658 | 37.792494 | 37076 | |
| 43154 | 43154 | 2020-12-11 | Alameda | 1 | 94606: Oakland | 1009 | -122.244658 | 37.792494 | 37076 | |
| 44455 | 44455 | 2020-12-10 | Alameda | 1 | 94606: Oakland | 991 | -122.244658 | 37.792494 | 37076 | |
| 45714 | 45714 | 2020-12-09 | Alameda | 1 | 94606: Oakland | 971 | -122.244658 | 37.792494 | 37076 | |
| 46935 | 46935 | 2020-12-08 | Alameda | 1 | 94606: Oakland | 953 | -122.244658 | 37.792494 | 37076 | |
| 48175 | 48175 | 2020-12-07 | Alameda | 1 | 94606: Oakland | 914 | -122.244658 | 37.792494 | 37076 | |
| 49472 | 49472 | 2020-12-06 | Alameda | 1 | 94606: Oakland | 903 | -122.244658 | 37.792494 | 37076 | |
| 50578 | 50578 | 2020-12-05 | Alameda | 1 | 94606: Oakland | 903 | -122.244658 | 37.792494 | 37076 | |
| 51667 | 51667 | 2020-12-04 | Alameda | 1 | 94606: Oakland | 886 | -122.244658 | 37.792494 | 37076 | |
| 52869 | 52869 | 2020-12-03 | Alameda | 1 | 94606: Oakland | 863 | -122.244658 | 37.792494 | 37076 | |
| 54043 | 54043 | 2020-12-02 | Alameda | 1 | 94606: Oakland | 852 | -122.244658 | 37.792494 | 37076 | |
| 55186 | 55186 | 2020-12-01 | Alameda | 1 | 94606: Oakland | 849 | -122.244658 | 37.792494 | 37076 | |
| 56400 | 56400 | 2020-11-30 | Alameda | 1 | 94606: Oakland | 849 | -122.244658 | 37.792494 | 37076 | |
| 57582 | 57582 | 2020-11-29 | Alameda | 1 | 94606: Oakland | 842 | -122.244658 | 37.792494 | 37076 | |
| 58547 | 58547 | 2020-11-28 | Alameda | 1 | 94606: Oakland | 834 | -122.244658 | 37.792494 | 37076 | |
| 59553 | 59553 | 2020-11-27 | Alameda | 1 | 94606: Oakland | 822 | -122.244658 | 37.792494 | 37076 | |
| 60424 | 60424 | 2020-11-26 | Alameda | 1 | 94606: Oakland | 822 | -122.244658 | 37.792494 | 37076 | |
| 61142 | 61142 | 2020-11-25 | Alameda | 1 | 94606: Oakland | 817 | -122.244658 | 37.792494 | 37076 | |
| 62259 | 62259 | 2020-11-24 | Alameda | 1 | 94606: Oakland | 817 | -122.244658 | 37.792494 | 37076 | |
| 63445 | 63445 | 2020-11-23 | Alameda | 1 | 94606: Oakland | 812 | -122.244658 | 37.792494 | 37076 | |
| 64463 | 64463 | 2020-11-22 | Alameda | 1 | 94606: Oakland | 809 | -122.244658 | 37.792494 | 37076 | |
| 65337 | 65337 | 2020-11-21 | Alameda | 1 | 94606: Oakland | 807 | -122.244658 | 37.792494 | 37076 | |
| 66146 | 66146 | 2020-11-20 | Alameda | 1 | 94606: Oakland | 807 | -122.244658 | 37.792494 | 37076 | |
| 67354 | 67354 | 2020-11-19 | Alameda | 1 | 94606: Oakland | 804 | -122.244658 | 37.792494 | 37076 | |
| 68496 | 68496 | 2020-11-18 | Alameda | 1 | 94606: Oakland | 798 | -122.244658 | 37.792494 | 37076 | |
| 69685 | 69685 | 2020-11-17 | Alameda | 1 | 94606: Oakland | 798 | -122.244658 | 37.792494 | 37076 | |
| 70865 | 70865 | 2020-11-16 | Alameda | 1 | 94606: Oakland | 790 | -122.244658 | 37.792494 | 37076 | |
| 72044 | 72044 | 2020-11-15 | Alameda | 1 | 94606: Oakland | 784 | -122.244658 | 37.792494 | 37076 | |
| 72742 | 72742 | 2020-11-14 | Alameda | 1 | 94606: Oakland | 782 | -122.244658 | 37.792494 | 37076 | |
| 73639 | 73639 | 2020-11-13 | Alameda | 1 | 94606: Oakland | 776 | -122.244658 | 37.792494 | 37076 | |
| 74761 | 74761 | 2020-11-12 | Alameda | 1 | 94606: Oakland | 778 | -122.244658 | 37.792494 | 37076 | |
| 75924 | 75924 | 2020-11-11 | Alameda | 1 | 94606: Oakland | 771 | -122.244658 | 37.792494 | 37076 | |
| 76843 | 76843 | 2020-11-10 | Alameda | 1 | 94606: Oakland | 767 | -122.244658 | 37.792494 | 37076 | |
| 78024 | 78024 | 2020-11-09 | Alameda | 1 | 94606: Oakland | 766 | -122.244658 | 37.792494 | 37076 | |
| 79166 | 79166 | 2020-11-08 | Alameda | 1 | 94606: Oakland | 766 | -122.244658 | 37.792494 | 37076 | |
| 80031 | 80031 | 2020-11-07 | Alameda | 1 | 94606: Oakland | 763 | -122.244658 | 37.792494 | 37076 | |
| 80889 | 80889 | 2020-11-06 | Alameda | 1 | 94606: Oakland | 759 | -122.244658 | 37.792494 | 37076 | |
| 82085 | 82085 | 2020-11-05 | Alameda | 1 | 94606: Oakland | 755 | -122.244658 | 37.792494 | 37076 | |
| 83225 | 83225 | 2020-11-04 | Alameda | 1 | 94606: Oakland | 755 | -122.244658 | 37.792494 | 37076 | |
| 84403 | 84403 | 2020-11-03 | Alameda | 1 | 94606: Oakland | 755 | -122.244658 | 37.792494 | 37076 | |
| 85564 | 85564 | 2020-11-02 | Alameda | 1 | 94606: Oakland | 755 | -122.244658 | 37.792494 | 37076 | |
| 86683 | 86683 | 2020-11-01 | Alameda | 1 | 94606: Oakland | 751 | -122.244658 | 37.792494 | 37076 | |
| 87530 | 87530 | 2020-10-31 | Alameda | 1 | 94606: Oakland | 751 | -122.244658 | 37.792494 | 37076 | |
| 88401 | 88401 | 2020-10-30 | Alameda | 1 | 94606: Oakland | 749 | -122.244658 | 37.792494 | 37076 | |
| 89577 | 89577 | 2020-10-29 | Alameda | 1 | 94606: Oakland | 748 | -122.244658 | 37.792494 | 37076 | |
| 90756 | 90756 | 2020-10-28 | Alameda | 1 | 94606: Oakland | 748 | -122.244658 | 37.792494 | 37076 | |
| 91888 | 91888 | 2020-10-27 | Alameda | 1 | 94606: Oakland | 745 | -122.244658 | 37.792494 | 37076 | |
| 92981 | 92981 | 2020-10-26 | Alameda | 1 | 94606: Oakland | 744 | -122.244658 | 37.792494 | 37076 | |
| 94121 | 94121 | 2020-10-25 | Alameda | 1 | 94606: Oakland | 741 | -122.244658 | 37.792494 | 37076 | |
| 95000 | 95000 | 2020-10-24 | Alameda | 1 | 94606: Oakland | 737 | -122.244658 | 37.792494 | 37076 | |
| 95838 | 95838 | 2020-10-23 | Alameda | 1 | 94606: Oakland | 737 | -122.244658 | 37.792494 | 37076 | |
| 97010 | 97010 | 2020-10-22 | Alameda | 1 | 94606: Oakland | 736 | -122.244658 | 37.792494 | 37076 | |
| 98153 | 98153 | 2020-10-21 | Alameda | 1 | 94606: Oakland | 734 | -122.244658 | 37.792494 | 37076 | |
| 99290 | 99290 | 2020-10-20 | Alameda | 1 | 94606: Oakland | 733 | -122.244658 | 37.792494 | 37076 | |
| 100458 | 100458 | 2020-10-19 | Alameda | 1 | 94606: Oakland | 731 | -122.244658 | 37.792494 | 37076 | |
| 101608 | 101608 | 2020-10-18 | Alameda | 1 | 94606: Oakland | 731 | -122.244658 | 37.792494 | 37076 | |
| 102476 | 102476 | 2020-10-17 | Alameda | 1 | 94606: Oakland | 724 | -122.244658 | 37.792494 | 37076 | |
| 103393 | 103393 | 2020-10-16 | Alameda | 1 | 94606: Oakland | 722 | -122.244658 | 37.792494 | 37076 | |
| 104558 | 104558 | 2020-10-15 | Alameda | 1 | 94606: Oakland | 721 | -122.244658 | 37.792494 | 37076 | |
| 105679 | 105679 | 2020-10-14 | Alameda | 1 | 94606: Oakland | 721 | -122.244658 | 37.792494 | 37076 | |
| 106769 | 106769 | 2020-10-13 | Alameda | 1 | 94606: Oakland | 721 | -122.244658 | 37.792494 | 37076 | |
| 107861 | 107861 | 2020-10-12 | Alameda | 1 | 94606: Oakland | 721 | -122.244658 | 37.792494 | 37076 | |
| 108909 | 108909 | 2020-10-11 | Alameda | 1 | 94606: Oakland | 721 | -122.244658 | 37.792494 | 37076 | |
| 109742 | 109742 | 2020-10-10 | Alameda | 1 | 94606: Oakland | 718 | -122.244658 | 37.792494 | 37076 | |
| 110641 | 110641 | 2020-10-09 | Alameda | 1 | 94606: Oakland | 717 | -122.244658 | 37.792494 | 37076 | |
| 111802 | 111802 | 2020-10-08 | Alameda | 1 | 94606: Oakland | 716 | -122.244658 | 37.792494 | 37076 | |
| 112907 | 112907 | 2020-10-07 | Alameda | 1 | 94606: Oakland | 713 | -122.244658 | 37.792494 | 37076 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [place] TEXT, [confirmed_cases] INTEGER, [note] TEXT, [x] TEXT, [y] TEXT, [population] TEXT );