latimes_place_totals

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

361 rows where place = "El Cerrito" sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

fips

county

place

  • El Cerrito · 361
Link rowid date ▲ county fips place confirmed_cases note x y
48 2020-10-27 Contra Costa 13 El Cerrito 122   -122.311667 37.915833
653 2020-10-27 Riverside 65 El Cerrito 149   -117.522944 33.836027
1020 2020-10-26 Contra Costa 13 El Cerrito 122   -122.311667 37.915833
1611 2020-10-26 Riverside 65 El Cerrito 147   -117.522944 33.836027
1967 2020-10-25 Contra Costa 13 El Cerrito 122   -122.311667 37.915833
2650 2020-10-24 Contra Costa 13 El Cerrito 120   -122.311667 37.915833
3897 2020-10-23 Riverside 65 El Cerrito 144   -117.522944 33.836027
4314 2020-10-22 Contra Costa 13 El Cerrito 119   -122.311667 37.915833
4898 2020-10-22 Riverside 65 El Cerrito 144   -117.522944 33.836027
5270 2020-10-21 Contra Costa 13 El Cerrito 118   -122.311667 37.915833
5872 2020-10-21 Riverside 65 El Cerrito 144   -117.522944 33.836027
6254 2020-10-20 Contra Costa 13 El Cerrito 118   -122.311667 37.915833
6884 2020-10-20 Riverside 65 El Cerrito 144   -117.522944 33.836027
7261 2020-10-19 Contra Costa 13 El Cerrito 119   -122.311667 37.915833
7834 2020-10-19 Riverside 65 El Cerrito 141   -117.522944 33.836027
8115 2020-10-18 Contra Costa 13 El Cerrito 120   -122.311667 37.915833
8747 2020-10-17 Contra Costa 13 El Cerrito 118   -122.311667 37.915833
9446 2020-10-16 Contra Costa 13 El Cerrito 118   -122.311667 37.915833
10083 2020-10-16 Riverside 65 El Cerrito 139   -117.522944 33.836027
10425 2020-10-15 Contra Costa 13 El Cerrito 118   -122.311667 37.915833
11002 2020-10-15 Riverside 65 El Cerrito 139   -117.522944 33.836027
11358 2020-10-14 Contra Costa 13 El Cerrito 118   -122.311667 37.915833
11935 2020-10-14 Riverside 65 El Cerrito 139   -117.522944 33.836027
12301 2020-10-13 Contra Costa 13 El Cerrito 118   -122.311667 37.915833
13200 2020-10-12 Contra Costa 13 El Cerrito 117   -122.311667 37.915833
13771 2020-10-12 Riverside 65 El Cerrito 138   -117.522944 33.836027
14056 2020-10-11 Contra Costa 13 El Cerrito 116   -122.311667 37.915833
14738 2020-10-10 Contra Costa 13 El Cerrito 115   -122.311667 37.915833
15477 2020-10-09 Contra Costa 13 El Cerrito 115   -122.311667 37.915833
16089 2020-10-09 Riverside 65 El Cerrito 138   -117.522944 33.836027
16484 2020-10-08 Contra Costa 13 El Cerrito 115   -122.311667 37.915833
17074 2020-10-08 Riverside 65 El Cerrito 137   -117.522944 33.836027
17469 2020-10-07 Contra Costa 13 El Cerrito 114   -122.311667 37.915833
18059 2020-10-07 Riverside 65 El Cerrito 136   -117.522944 33.836027
18416 2020-10-06 Contra Costa 13 El Cerrito 114   -122.311667 37.915833
18999 2020-10-06 Riverside 65 El Cerrito 136   -117.522944 33.836027
19375 2020-10-05 Contra Costa 13 El Cerrito 114   -122.311667 37.915833
19937 2020-10-05 Riverside 65 El Cerrito 135   -117.522944 33.836027
20217 2020-10-04 Contra Costa 13 El Cerrito 113   -122.311667 37.915833
20853 2020-10-03 Contra Costa 13 El Cerrito 113   -122.311667 37.915833
21536 2020-10-02 Contra Costa 13 El Cerrito 113   -122.311667 37.915833
22164 2020-10-02 Riverside 65 El Cerrito 134   -117.522944 33.836027
22596 2020-10-01 Contra Costa 13 El Cerrito 113   -122.311667 37.915833
23155 2020-10-01 Riverside 65 El Cerrito 133   -117.522944 33.836027
23505 2020-09-30 Contra Costa 13 El Cerrito 111   -122.311667 37.915833
24093 2020-09-30 Riverside 65 El Cerrito 133   -117.522944 33.836027
24495 2020-09-29 Contra Costa 13 El Cerrito 109   -122.311667 37.915833
25092 2020-09-29 Riverside 65 El Cerrito 134   -117.522944 33.836027
25476 2020-09-28 Contra Costa 13 El Cerrito 109   -122.311667 37.915833
26073 2020-09-28 Riverside 65 El Cerrito 133   -117.522944 33.836027
26393 2020-09-27 Contra Costa 13 El Cerrito 109   -122.311667 37.915833
27036 2020-09-26 Contra Costa 13 El Cerrito 107   -122.311667 37.915833
27754 2020-09-25 Contra Costa 13 El Cerrito 106   -122.311667 37.915833
28374 2020-09-25 Riverside 65 El Cerrito 130   -117.522944 33.836027
28799 2020-09-24 Contra Costa 13 El Cerrito 106   -122.311667 37.915833
29394 2020-09-24 Riverside 65 El Cerrito 129   -117.522944 33.836027
29785 2020-09-23 Contra Costa 13 El Cerrito 104   -122.311667 37.915833
30375 2020-09-23 Riverside 65 El Cerrito 128   -117.522944 33.836027
30722 2020-09-22 Contra Costa 13 El Cerrito 102   -122.311667 37.915833
31316 2020-09-22 Riverside 65 El Cerrito 129   -117.522944 33.836027
31638 2020-09-21 Contra Costa 13 El Cerrito 100   -122.311667 37.915833
32494 2020-09-20 Contra Costa 13 El Cerrito 99   -122.311667 37.915833
33193 2020-09-19 Contra Costa 13 El Cerrito 99   -122.311667 37.915833
33916 2020-09-18 Contra Costa 13 El Cerrito 99   -122.311667 37.915833
34523 2020-09-18 Riverside 65 El Cerrito 127   -117.522944 33.836027
34933 2020-09-17 Contra Costa 13 El Cerrito 96   -122.311667 37.915833
35518 2020-09-17 Riverside 65 El Cerrito 126   -117.522944 33.836027
35885 2020-09-16 Contra Costa 13 El Cerrito 95   -122.311667 37.915833
36800 2020-09-15 Contra Costa 13 El Cerrito 95   -122.311667 37.915833
37426 2020-09-15 Riverside 65 El Cerrito 124   -117.522944 33.836027
37792 2020-09-14 Contra Costa 13 El Cerrito 95   -122.311667 37.915833
38388 2020-09-14 Riverside 65 El Cerrito 124   -117.522944 33.836027
38747 2020-09-13 Contra Costa 13 El Cerrito 95   -122.311667 37.915833
39398 2020-09-12 Contra Costa 13 El Cerrito 94   -122.311667 37.915833
40143 2020-09-11 Contra Costa 13 El Cerrito 94   -122.311667 37.915833
40772 2020-09-11 Riverside 65 El Cerrito 122   -117.522944 33.836027
41197 2020-09-10 Contra Costa 13 El Cerrito 94   -122.311667 37.915833
41746 2020-09-10 Riverside 65 El Cerrito 122   -117.522944 33.836027
42094 2020-09-09 Contra Costa 13 El Cerrito 94   -122.311667 37.915833
42720 2020-09-09 Riverside 65 El Cerrito 122   -117.522944 33.836027
43098 2020-09-08 Contra Costa 13 El Cerrito 94   -122.311667 37.915833
43717 2020-09-08 Riverside 65 El Cerrito 122   -117.522944 33.836027
44043 2020-09-07 Contra Costa 13 El Cerrito 94   -122.311667 37.915833
44634 2020-09-06 Contra Costa 13 El Cerrito 94   -122.311667 37.915833
45286 2020-09-05 Contra Costa 13 El Cerrito 94   -122.311667 37.915833
46002 2020-09-04 Contra Costa 13 El Cerrito 94   -122.311667 37.915833
46628 2020-09-04 Riverside 65 El Cerrito 121   -117.522944 33.836027
47042 2020-09-03 Contra Costa 13 El Cerrito 94   -122.311667 37.915833
47588 2020-09-03 Riverside 65 El Cerrito 121   -117.522944 33.836027
47942 2020-09-02 Contra Costa 13 El Cerrito 91   -122.311667 37.915833
48522 2020-09-02 Riverside 65 El Cerrito 120   -117.522944 33.836027
48915 2020-09-01 Contra Costa 13 El Cerrito 90   -122.311667 37.915833
49547 2020-09-01 Riverside 65 El Cerrito 120   -117.522944 33.836027
49928 2020-08-31 Contra Costa 13 El Cerrito 89   -122.311667 37.915833
50487 2020-08-31 Riverside 65 El Cerrito 120   -117.522944 33.836027
50842 2020-08-30 Contra Costa 13 El Cerrito 88   -122.311667 37.915833
51456 2020-08-29 Contra Costa 13 El Cerrito 88   -122.311667 37.915833
52084 2020-08-29 Riverside 65 El Cerrito 118   -117.522944 33.836027
52904 2020-08-27 Contra Costa 13 El Cerrito 87   -122.311667 37.915833
53451 2020-08-27 Riverside 65 El Cerrito 119   -117.522944 33.836027

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
);
Powered by Datasette · Query took 888.815ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals