⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

View and edit SQL

place

  • 94606: Oakland · 306

fips

  • 1 306

county

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT,
   [population] TEXT
);