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

269 rows where place = "94566: Pleasanton" sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

place

  • 94566: Pleasanton · 269

fips

  • 1 269

county

Link rowid date ▲ county fips place confirmed_cases note x y population
16 2020-12-02 Alameda 1 94566: Pleasanton 435   -121.855191 37.651123 45046
1167 2020-12-01 Alameda 1 94566: Pleasanton 427   -121.855191 37.651123 45046
2388 2020-11-30 Alameda 1 94566: Pleasanton 427   -121.855191 37.651123 45046
3581 2020-11-29 Alameda 1 94566: Pleasanton 419   -121.855191 37.651123 45046
4522 2020-11-28 Alameda 1 94566: Pleasanton 406   -121.855191 37.651123 45046
5539 2020-11-27 Alameda 1 94566: Pleasanton 385   -121.855191 37.651123 45046
6421 2020-11-26 Alameda 1 94566: Pleasanton 385   -121.855191 37.651123 45046
7171 2020-11-25 Alameda 1 94566: Pleasanton 382   -121.855191 37.651123 45046
8300 2020-11-24 Alameda 1 94566: Pleasanton 382   -121.855191 37.651123 45046
9497 2020-11-23 Alameda 1 94566: Pleasanton 378   -121.855191 37.651123 45046
10481 2020-11-22 Alameda 1 94566: Pleasanton 373   -121.855191 37.651123 45046
11331 2020-11-21 Alameda 1 94566: Pleasanton 362   -121.855191 37.651123 45046
12144 2020-11-20 Alameda 1 94566: Pleasanton 362   -121.855191 37.651123 45046
13331 2020-11-19 Alameda 1 94566: Pleasanton 355   -121.855191 37.651123 45046
14480 2020-11-18 Alameda 1 94566: Pleasanton 343   -121.855191 37.651123 45046
15616 2020-11-17 Alameda 1 94566: Pleasanton 343   -121.855191 37.651123 45046
16806 2020-11-16 Alameda 1 94566: Pleasanton 340   -121.855191 37.651123 45046
17960 2020-11-15 Alameda 1 94566: Pleasanton 334   -121.855191 37.651123 45046
18662 2020-11-14 Alameda 1 94566: Pleasanton 333   -121.855191 37.651123 45046
19535 2020-11-13 Alameda 1 94566: Pleasanton 330   -121.855191 37.651123 45046
20638 2020-11-12 Alameda 1 94566: Pleasanton 331   -121.855191 37.651123 45046
21799 2020-11-11 Alameda 1 94566: Pleasanton 325   -121.855191 37.651123 45046
22686 2020-11-10 Alameda 1 94566: Pleasanton 323   -121.855191 37.651123 45046
23865 2020-11-09 Alameda 1 94566: Pleasanton 321   -121.855191 37.651123 45046
24972 2020-11-08 Alameda 1 94566: Pleasanton 321   -121.855191 37.651123 45046
25804 2020-11-07 Alameda 1 94566: Pleasanton 319   -121.855191 37.651123 45046
26629 2020-11-06 Alameda 1 94566: Pleasanton 319   -121.855191 37.651123 45046
27826 2020-11-05 Alameda 1 94566: Pleasanton 314   -121.855191 37.651123 45046
28938 2020-11-04 Alameda 1 94566: Pleasanton 312   -121.855191 37.651123 45046
30115 2020-11-03 Alameda 1 94566: Pleasanton 308   -121.855191 37.651123 45046
31282 2020-11-02 Alameda 1 94566: Pleasanton 305   -121.855191 37.651123 45046
32368 2020-11-01 Alameda 1 94566: Pleasanton 305   -121.855191 37.651123 45046
33157 2020-10-31 Alameda 1 94566: Pleasanton 305   -121.855191 37.651123 45046
33966 2020-10-30 Alameda 1 94566: Pleasanton 298   -121.855191 37.651123 45046
35142 2020-10-29 Alameda 1 94566: Pleasanton 297   -121.855191 37.651123 45046
36290 2020-10-28 Alameda 1 94566: Pleasanton 295   -121.855191 37.651123 45046
37391 2020-10-27 Alameda 1 94566: Pleasanton 294   -121.855191 37.651123 45046
38510 2020-10-26 Alameda 1 94566: Pleasanton 294   -121.855191 37.651123 45046
39593 2020-10-25 Alameda 1 94566: Pleasanton 293   -121.855191 37.651123 45046
40441 2020-10-24 Alameda 1 94566: Pleasanton 289   -121.855191 37.651123 45046
41245 2020-10-23 Alameda 1 94566: Pleasanton 289   -121.855191 37.651123 45046
42421 2020-10-22 Alameda 1 94566: Pleasanton 288   -121.855191 37.651123 45046
43532 2020-10-21 Alameda 1 94566: Pleasanton 284   -121.855191 37.651123 45046
44642 2020-10-20 Alameda 1 94566: Pleasanton 283   -121.855191 37.651123 45046
45816 2020-10-19 Alameda 1 94566: Pleasanton 283   -121.855191 37.651123 45046
46908 2020-10-18 Alameda 1 94566: Pleasanton 283   -121.855191 37.651123 45046
47744 2020-10-17 Alameda 1 94566: Pleasanton 283   -121.855191 37.651123 45046
48628 2020-10-16 Alameda 1 94566: Pleasanton 283   -121.855191 37.651123 45046
49792 2020-10-15 Alameda 1 94566: Pleasanton 282   -121.855191 37.651123 45046
50909 2020-10-14 Alameda 1 94566: Pleasanton 280   -121.855191 37.651123 45046
52030 2020-10-13 Alameda 1 94566: Pleasanton 279   -121.855191 37.651123 45046
53096 2020-10-12 Alameda 1 94566: Pleasanton 279   -121.855191 37.651123 45046
54113 2020-10-11 Alameda 1 94566: Pleasanton 279   -121.855191 37.651123 45046
54942 2020-10-10 Alameda 1 94566: Pleasanton 278   -121.855191 37.651123 45046
55809 2020-10-09 Alameda 1 94566: Pleasanton 276   -121.855191 37.651123 45046
56974 2020-10-08 Alameda 1 94566: Pleasanton 274   -121.855191 37.651123 45046
58080 2020-10-07 Alameda 1 94566: Pleasanton 272   -121.855191 37.651123 45046
59193 2020-10-06 Alameda 1 94566: Pleasanton 268   -121.855191 37.651123 45046
60283 2020-10-05 Alameda 1 94566: Pleasanton 268   -121.855191 37.651123 45046
61338 2020-10-04 Alameda 1 94566: Pleasanton 267   -121.855191 37.651123 45046
62181 2020-10-03 Alameda 1 94566: Pleasanton 267   -121.855191 37.651123 45046
63029 2020-10-02 Alameda 1 94566: Pleasanton 266   -121.855191 37.651123 45046
64214 2020-10-01 Alameda 1 94566: Pleasanton 266   -121.855191 37.651123 45046
65279 2020-09-30 Alameda 1 94566: Pleasanton 264   -121.855191 37.651123 45046
66387 2020-09-29 Alameda 1 94566: Pleasanton 259   -121.855191 37.651123 45046
67503 2020-09-28 Alameda 1 94566: Pleasanton 258   -121.855191 37.651123 45046
68604 2020-09-27 Alameda 1 94566: Pleasanton 256   -121.855191 37.651123 45046
69411 2020-09-26 Alameda 1 94566: Pleasanton 255   -121.855191 37.651123 45046
70274 2020-09-25 Alameda 1 94566: Pleasanton 253   -121.855191 37.651123 45046
71450 2020-09-24 Alameda 1 94566: Pleasanton 249   -121.855191 37.651123 45046
72564 2020-09-23 Alameda 1 94566: Pleasanton 249   -121.855191 37.651123 45046
73662 2020-09-22 Alameda 1 94566: Pleasanton 249   -121.855191 37.651123 45046
74713 2020-09-21 Alameda 1 94566: Pleasanton 249   -121.855191 37.651123 45046
75735 2020-09-20 Alameda 1 94566: Pleasanton 248   -121.855191 37.651123 45046
76572 2020-09-19 Alameda 1 94566: Pleasanton 247   -121.855191 37.651123 45046
77436 2020-09-18 Alameda 1 94566: Pleasanton 245   -121.855191 37.651123 45046
78600 2020-09-17 Alameda 1 94566: Pleasanton 245   -121.855191 37.651123 45046
79702 2020-09-16 Alameda 1 94566: Pleasanton 244   -121.855191 37.651123 45046
80741 2020-09-15 Alameda 1 94566: Pleasanton 242   -121.855191 37.651123 45046
81890 2020-09-14 Alameda 1 94566: Pleasanton 240   -121.855191 37.651123 45046
83003 2020-09-13 Alameda 1 94566: Pleasanton 239   -121.855191 37.651123 45046
83834 2020-09-12 Alameda 1 94566: Pleasanton 237   -121.855191 37.651123 45046
84707 2020-09-11 Alameda 1 94566: Pleasanton 236   -121.855191 37.651123 45046
85886 2020-09-10 Alameda 1 94566: Pleasanton 232   -121.855191 37.651123 45046
86935 2020-09-09 Alameda 1 94566: Pleasanton 229   -121.855191 37.651123 45046
88066 2020-09-08 Alameda 1 94566: Pleasanton 225   -121.855191 37.651123 45046
89153 2020-09-07 Alameda 1 94566: Pleasanton 224   -121.855191 37.651123 45046
89963 2020-09-06 Alameda 1 94566: Pleasanton 224   -121.855191 37.651123 45046
90776 2020-09-05 Alameda 1 94566: Pleasanton 223   -121.855191 37.651123 45046
91634 2020-09-04 Alameda 1 94566: Pleasanton 220   -121.855191 37.651123 45046
92812 2020-09-03 Alameda 1 94566: Pleasanton 220   -121.855191 37.651123 45046
93875 2020-09-02 Alameda 1 94566: Pleasanton 216   -121.855191 37.651123 45046
94967 2020-09-01 Alameda 1 94566: Pleasanton 210   -121.855191 37.651123 45046
96113 2020-08-31 Alameda 1 94566: Pleasanton 210   -121.855191 37.651123 45046
97190 2020-08-30 Alameda 1 94566: Pleasanton 210   -121.855191 37.651123 45046
98001 2020-08-29 Alameda 1 94566: Pleasanton 207   -121.855191 37.651123 45046
99133 2020-08-28 Alameda 1 94566: Pleasanton 203   -121.855191 37.651123 45046
99805 2020-08-27 Alameda 1 94566: Pleasanton 201   -121.855191 37.651123 45046
100868 2020-08-26 Alameda 1 94566: Pleasanton 195   -121.855191 37.651123 45046
101936 2020-08-25 Alameda 1 94566: Pleasanton 188   -121.855191 37.651123 45046

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