⚠️ 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

319 rows where place = "94611: Oakland" sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

place

  • 94611: Oakland · 319

fips

  • 1 319

county

Link rowid date ▲ county fips place confirmed_cases note x y population
35 2021-01-27 Alameda 1 94611: Oakland 697   -122.216308 37.831401 37826
1357 2021-01-26 Alameda 1 94611: Oakland 697   -122.216308 37.831401 37826
2698 2021-01-25 Alameda 1 94611: Oakland 691   -122.216308 37.831401 37826
4041 2021-01-24 Alameda 1 94611: Oakland 689   -122.216308 37.831401 37826
5363 2021-01-23 Alameda 1 94611: Oakland 677   -122.216308 37.831401 37826
6685 2021-01-22 Alameda 1 94611: Oakland 683   -122.216308 37.831401 37826
8028 2021-01-21 Alameda 1 94611: Oakland 675   -122.216308 37.831401 37826
9375 2021-01-20 Alameda 1 94611: Oakland 661   -122.216308 37.831401 37826
10718 2021-01-19 Alameda 1 94611: Oakland 661   -122.216308 37.831401 37826
12052 2021-01-18 Alameda 1 94611: Oakland 661   -122.216308 37.831401 37826
13377 2021-01-17 Alameda 1 94611: Oakland 641   -122.216308 37.831401 37826
14702 2021-01-16 Alameda 1 94611: Oakland 641   -122.216308 37.831401 37826
16027 2021-01-15 Alameda 1 94611: Oakland 626   -122.216308 37.831401 37826
17373 2021-01-14 Alameda 1 94611: Oakland 626   -122.216308 37.831401 37826
18708 2021-01-13 Alameda 1 94611: Oakland 623   -122.216308 37.831401 37826
20043 2021-01-12 Alameda 1 94611: Oakland 618   -122.216308 37.831401 37826
21384 2021-01-11 Alameda 1 94611: Oakland 598   -122.216308 37.831401 37826
22720 2021-01-10 Alameda 1 94611: Oakland 583   -122.216308 37.831401 37826
23974 2021-01-09 Alameda 1 94611: Oakland 583   -122.216308 37.831401 37826
25293 2021-01-08 Alameda 1 94611: Oakland 552   -122.216308 37.831401 37826
26633 2021-01-07 Alameda 1 94611: Oakland 545   -122.216308 37.831401 37826
27968 2021-01-06 Alameda 1 94611: Oakland 545   -122.216308 37.831401 37826
29298 2021-01-05 Alameda 1 94611: Oakland 518   -122.216308 37.831401 37826
30639 2021-01-04 Alameda 1 94611: Oakland 518   -122.216308 37.831401 37826
31969 2021-01-03 Alameda 1 94611: Oakland 513   -122.216308 37.831401 37826
33266 2021-01-02 Alameda 1 94611: Oakland 504   -122.216308 37.831401 37826
34563 2021-01-01 Alameda 1 94611: Oakland 504   -122.216308 37.831401 37826
35853 2020-12-31 Alameda 1 94611: Oakland 497   -122.216308 37.831401 37826
37163 2020-12-30 Alameda 1 94611: Oakland 482   -122.216308 37.831401 37826
38473 2020-12-29 Alameda 1 94611: Oakland 482   -122.216308 37.831401 37826
39778 2020-12-28 Alameda 1 94611: Oakland 474   -122.216308 37.831401 37826
41029 2020-12-27 Alameda 1 94611: Oakland 464   -122.216308 37.831401 37826
42247 2020-12-26 Alameda 1 94611: Oakland 454   -122.216308 37.831401 37826
43469 2020-12-25 Alameda 1 94611: Oakland 438   -122.216308 37.831401 37826
44278 2020-12-24 Alameda 1 94611: Oakland 438   -122.216308 37.831401 37826
45499 2020-12-23 Alameda 1 94611: Oakland 430   -122.216308 37.831401 37826
46800 2020-12-22 Alameda 1 94611: Oakland 419   -122.216308 37.831401 37826
48023 2020-12-21 Alameda 1 94611: Oakland 419   -122.216308 37.831401 37826
49340 2020-12-20 Alameda 1 94611: Oakland 412   -122.216308 37.831401 37826
50516 2020-12-19 Alameda 1 94611: Oakland 388   -122.216308 37.831401 37826
51695 2020-12-18 Alameda 1 94611: Oakland 388   -122.216308 37.831401 37826
53000 2020-12-17 Alameda 1 94611: Oakland 388   -122.216308 37.831401 37826
54283 2020-12-16 Alameda 1 94611: Oakland 379   -122.216308 37.831401 37826
55564 2020-12-15 Alameda 1 94611: Oakland 375   -122.216308 37.831401 37826
56855 2020-12-14 Alameda 1 94611: Oakland 367   -122.216308 37.831401 37826
58150 2020-12-13 Alameda 1 94611: Oakland 350   -122.216308 37.831401 37826
59312 2020-12-12 Alameda 1 94611: Oakland 350   -122.216308 37.831401 37826
60507 2020-12-11 Alameda 1 94611: Oakland 346   -122.216308 37.831401 37826
61808 2020-12-10 Alameda 1 94611: Oakland 342   -122.216308 37.831401 37826
63067 2020-12-09 Alameda 1 94611: Oakland 334   -122.216308 37.831401 37826
64288 2020-12-08 Alameda 1 94611: Oakland 333   -122.216308 37.831401 37826
65528 2020-12-07 Alameda 1 94611: Oakland 324   -122.216308 37.831401 37826
66825 2020-12-06 Alameda 1 94611: Oakland 323   -122.216308 37.831401 37826
67931 2020-12-05 Alameda 1 94611: Oakland 323   -122.216308 37.831401 37826
69020 2020-12-04 Alameda 1 94611: Oakland 319   -122.216308 37.831401 37826
70222 2020-12-03 Alameda 1 94611: Oakland 313   -122.216308 37.831401 37826
71396 2020-12-02 Alameda 1 94611: Oakland 310   -122.216308 37.831401 37826
72539 2020-12-01 Alameda 1 94611: Oakland 307   -122.216308 37.831401 37826
73753 2020-11-30 Alameda 1 94611: Oakland 307   -122.216308 37.831401 37826
74935 2020-11-29 Alameda 1 94611: Oakland 306   -122.216308 37.831401 37826
75900 2020-11-28 Alameda 1 94611: Oakland 305   -122.216308 37.831401 37826
76906 2020-11-27 Alameda 1 94611: Oakland 294   -122.216308 37.831401 37826
77777 2020-11-26 Alameda 1 94611: Oakland 294   -122.216308 37.831401 37826
78495 2020-11-25 Alameda 1 94611: Oakland 289   -122.216308 37.831401 37826
79612 2020-11-24 Alameda 1 94611: Oakland 289   -122.216308 37.831401 37826
80798 2020-11-23 Alameda 1 94611: Oakland 288   -122.216308 37.831401 37826
81816 2020-11-22 Alameda 1 94611: Oakland 284   -122.216308 37.831401 37826
82690 2020-11-21 Alameda 1 94611: Oakland 280   -122.216308 37.831401 37826
83499 2020-11-20 Alameda 1 94611: Oakland 280   -122.216308 37.831401 37826
84707 2020-11-19 Alameda 1 94611: Oakland 273   -122.216308 37.831401 37826
85849 2020-11-18 Alameda 1 94611: Oakland 270   -122.216308 37.831401 37826
87038 2020-11-17 Alameda 1 94611: Oakland 270   -122.216308 37.831401 37826
88218 2020-11-16 Alameda 1 94611: Oakland 255   -122.216308 37.831401 37826
89397 2020-11-15 Alameda 1 94611: Oakland 251   -122.216308 37.831401 37826
90095 2020-11-14 Alameda 1 94611: Oakland 250   -122.216308 37.831401 37826
90992 2020-11-13 Alameda 1 94611: Oakland 246   -122.216308 37.831401 37826
92114 2020-11-12 Alameda 1 94611: Oakland 249   -122.216308 37.831401 37826
93277 2020-11-11 Alameda 1 94611: Oakland 246   -122.216308 37.831401 37826
94196 2020-11-10 Alameda 1 94611: Oakland 242   -122.216308 37.831401 37826
95377 2020-11-09 Alameda 1 94611: Oakland 242   -122.216308 37.831401 37826
96519 2020-11-08 Alameda 1 94611: Oakland 239   -122.216308 37.831401 37826
97384 2020-11-07 Alameda 1 94611: Oakland 237   -122.216308 37.831401 37826
98242 2020-11-06 Alameda 1 94611: Oakland 234   -122.216308 37.831401 37826
99438 2020-11-05 Alameda 1 94611: Oakland 233   -122.216308 37.831401 37826
100578 2020-11-04 Alameda 1 94611: Oakland 232   -122.216308 37.831401 37826
101756 2020-11-03 Alameda 1 94611: Oakland 231   -122.216308 37.831401 37826
102917 2020-11-02 Alameda 1 94611: Oakland 230   -122.216308 37.831401 37826
104036 2020-11-01 Alameda 1 94611: Oakland 229   -122.216308 37.831401 37826
104883 2020-10-31 Alameda 1 94611: Oakland 228   -122.216308 37.831401 37826
105754 2020-10-30 Alameda 1 94611: Oakland 226   -122.216308 37.831401 37826
106930 2020-10-29 Alameda 1 94611: Oakland 224   -122.216308 37.831401 37826
108109 2020-10-28 Alameda 1 94611: Oakland 222   -122.216308 37.831401 37826
109241 2020-10-27 Alameda 1 94611: Oakland 220   -122.216308 37.831401 37826
110334 2020-10-26 Alameda 1 94611: Oakland 220   -122.216308 37.831401 37826
111474 2020-10-25 Alameda 1 94611: Oakland 219   -122.216308 37.831401 37826
112353 2020-10-24 Alameda 1 94611: Oakland 217   -122.216308 37.831401 37826
113191 2020-10-23 Alameda 1 94611: Oakland 216   -122.216308 37.831401 37826
114363 2020-10-22 Alameda 1 94611: Oakland 215   -122.216308 37.831401 37826
115506 2020-10-21 Alameda 1 94611: Oakland 215   -122.216308 37.831401 37826
116643 2020-10-20 Alameda 1 94611: Oakland 215   -122.216308 37.831401 37826

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
);