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

356 rows where place = "El Sobrante" sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

fips

county

place

  • El Sobrante · 356
Link rowid date ▲ county fips place confirmed_cases note x y
49 2020-10-23 Contra Costa 13 El Sobrante 307   -122.295278 37.977222
614 2020-10-23 Riverside 65 El Sobrante 319   -117.46117 33.872462
1031 2020-10-22 Contra Costa 13 El Sobrante 306   -122.295278 37.977222
1615 2020-10-22 Riverside 65 El Sobrante 317   -117.46117 33.872462
1987 2020-10-21 Contra Costa 13 El Sobrante 306   -122.295278 37.977222
2589 2020-10-21 Riverside 65 El Sobrante 314   -117.46117 33.872462
2971 2020-10-20 Contra Costa 13 El Sobrante 306   -122.295278 37.977222
3601 2020-10-20 Riverside 65 El Sobrante 312   -117.46117 33.872462
3978 2020-10-19 Contra Costa 13 El Sobrante 306   -122.295278 37.977222
4551 2020-10-19 Riverside 65 El Sobrante 309   -117.46117 33.872462
4832 2020-10-18 Contra Costa 13 El Sobrante 304   -122.295278 37.977222
5464 2020-10-17 Contra Costa 13 El Sobrante 298   -122.295278 37.977222
6163 2020-10-16 Contra Costa 13 El Sobrante 297   -122.295278 37.977222
6800 2020-10-16 Riverside 65 El Sobrante 301   -117.46117 33.872462
7142 2020-10-15 Contra Costa 13 El Sobrante 294   -122.295278 37.977222
7719 2020-10-15 Riverside 65 El Sobrante 300   -117.46117 33.872462
8075 2020-10-14 Contra Costa 13 El Sobrante 292   -122.295278 37.977222
8652 2020-10-14 Riverside 65 El Sobrante 299   -117.46117 33.872462
9018 2020-10-13 Contra Costa 13 El Sobrante 292   -122.295278 37.977222
9917 2020-10-12 Contra Costa 13 El Sobrante 290   -122.295278 37.977222
10488 2020-10-12 Riverside 65 El Sobrante 292   -117.46117 33.872462
10773 2020-10-11 Contra Costa 13 El Sobrante 290   -122.295278 37.977222
11455 2020-10-10 Contra Costa 13 El Sobrante 288   -122.295278 37.977222
12194 2020-10-09 Contra Costa 13 El Sobrante 288   -122.295278 37.977222
12806 2020-10-09 Riverside 65 El Sobrante 292   -117.46117 33.872462
13201 2020-10-08 Contra Costa 13 El Sobrante 288   -122.295278 37.977222
13791 2020-10-08 Riverside 65 El Sobrante 289   -117.46117 33.872462
14186 2020-10-07 Contra Costa 13 El Sobrante 288   -122.295278 37.977222
14776 2020-10-07 Riverside 65 El Sobrante 289   -117.46117 33.872462
15133 2020-10-06 Contra Costa 13 El Sobrante 288   -122.295278 37.977222
15716 2020-10-06 Riverside 65 El Sobrante 288   -117.46117 33.872462
16092 2020-10-05 Contra Costa 13 El Sobrante 288   -122.295278 37.977222
16654 2020-10-05 Riverside 65 El Sobrante 287   -117.46117 33.872462
16934 2020-10-04 Contra Costa 13 El Sobrante 289   -122.295278 37.977222
17570 2020-10-03 Contra Costa 13 El Sobrante 288   -122.295278 37.977222
18253 2020-10-02 Contra Costa 13 El Sobrante 288   -122.295278 37.977222
18881 2020-10-02 Riverside 65 El Sobrante 282   -117.46117 33.872462
19313 2020-10-01 Contra Costa 13 El Sobrante 287   -122.295278 37.977222
19872 2020-10-01 Riverside 65 El Sobrante 279   -117.46117 33.872462
20222 2020-09-30 Contra Costa 13 El Sobrante 286   -122.295278 37.977222
20810 2020-09-30 Riverside 65 El Sobrante 280   -117.46117 33.872462
21212 2020-09-29 Contra Costa 13 El Sobrante 285   -122.295278 37.977222
21809 2020-09-29 Riverside 65 El Sobrante 279   -117.46117 33.872462
22193 2020-09-28 Contra Costa 13 El Sobrante 285   -122.295278 37.977222
22790 2020-09-28 Riverside 65 El Sobrante 278   -117.46117 33.872462
23110 2020-09-27 Contra Costa 13 El Sobrante 283   -122.295278 37.977222
23753 2020-09-26 Contra Costa 13 El Sobrante 281   -122.295278 37.977222
24471 2020-09-25 Contra Costa 13 El Sobrante 280   -122.295278 37.977222
25091 2020-09-25 Riverside 65 El Sobrante 280   -117.46117 33.872462
25516 2020-09-24 Contra Costa 13 El Sobrante 278   -122.295278 37.977222
26111 2020-09-24 Riverside 65 El Sobrante 278   -117.46117 33.872462
26502 2020-09-23 Contra Costa 13 El Sobrante 272   -122.295278 37.977222
27092 2020-09-23 Riverside 65 El Sobrante 277   -117.46117 33.872462
27439 2020-09-22 Contra Costa 13 El Sobrante 270   -122.295278 37.977222
28033 2020-09-22 Riverside 65 El Sobrante 275   -117.46117 33.872462
28355 2020-09-21 Contra Costa 13 El Sobrante 270   -122.295278 37.977222
29211 2020-09-20 Contra Costa 13 El Sobrante 268   -122.295278 37.977222
29910 2020-09-19 Contra Costa 13 El Sobrante 266   -122.295278 37.977222
30633 2020-09-18 Contra Costa 13 El Sobrante 262   -122.295278 37.977222
31240 2020-09-18 Riverside 65 El Sobrante 270   -117.46117 33.872462
31650 2020-09-17 Contra Costa 13 El Sobrante 257   -122.295278 37.977222
32235 2020-09-17 Riverside 65 El Sobrante 269   -117.46117 33.872462
32602 2020-09-16 Contra Costa 13 El Sobrante 254   -122.295278 37.977222
33517 2020-09-15 Contra Costa 13 El Sobrante 253   -122.295278 37.977222
34143 2020-09-15 Riverside 65 El Sobrante 268   -117.46117 33.872462
34509 2020-09-14 Contra Costa 13 El Sobrante 250   -122.295278 37.977222
35105 2020-09-14 Riverside 65 El Sobrante 265   -117.46117 33.872462
35464 2020-09-13 Contra Costa 13 El Sobrante 244   -122.295278 37.977222
36115 2020-09-12 Contra Costa 13 El Sobrante 239   -122.295278 37.977222
36860 2020-09-11 Contra Costa 13 El Sobrante 237   -122.295278 37.977222
37489 2020-09-11 Riverside 65 El Sobrante 262   -117.46117 33.872462
37914 2020-09-10 Contra Costa 13 El Sobrante 236   -122.295278 37.977222
38463 2020-09-10 Riverside 65 El Sobrante 261   -117.46117 33.872462
38811 2020-09-09 Contra Costa 13 El Sobrante 235   -122.295278 37.977222
39437 2020-09-09 Riverside 65 El Sobrante 261   -117.46117 33.872462
39815 2020-09-08 Contra Costa 13 El Sobrante 233   -122.295278 37.977222
40434 2020-09-08 Riverside 65 El Sobrante 259   -117.46117 33.872462
40760 2020-09-07 Contra Costa 13 El Sobrante 233   -122.295278 37.977222
41351 2020-09-06 Contra Costa 13 El Sobrante 233   -122.295278 37.977222
42003 2020-09-05 Contra Costa 13 El Sobrante 235   -122.295278 37.977222
42719 2020-09-04 Contra Costa 13 El Sobrante 233   -122.295278 37.977222
43345 2020-09-04 Riverside 65 El Sobrante 255   -117.46117 33.872462
43759 2020-09-03 Contra Costa 13 El Sobrante 227   -122.295278 37.977222
44305 2020-09-03 Riverside 65 El Sobrante 254   -117.46117 33.872462
44659 2020-09-02 Contra Costa 13 El Sobrante 223   -122.295278 37.977222
45239 2020-09-02 Riverside 65 El Sobrante 251   -117.46117 33.872462
45632 2020-09-01 Contra Costa 13 El Sobrante 220   -122.295278 37.977222
46264 2020-09-01 Riverside 65 El Sobrante 253   -117.46117 33.872462
46645 2020-08-31 Contra Costa 13 El Sobrante 220   -122.295278 37.977222
47204 2020-08-31 Riverside 65 El Sobrante 253   -117.46117 33.872462
47559 2020-08-30 Contra Costa 13 El Sobrante 215   -122.295278 37.977222
48173 2020-08-29 Contra Costa 13 El Sobrante 209   -122.295278 37.977222
48801 2020-08-29 Riverside 65 El Sobrante 246   -117.46117 33.872462
49621 2020-08-27 Contra Costa 13 El Sobrante 205   -122.295278 37.977222
50168 2020-08-27 Riverside 65 El Sobrante 245   -117.46117 33.872462
50541 2020-08-26 Contra Costa 13 El Sobrante 203   -122.295278 37.977222
51107 2020-08-26 Riverside 65 El Sobrante 241   -117.46117 33.872462
51471 2020-08-25 Contra Costa 13 El Sobrante 201   -122.295278 37.977222
52022 2020-08-25 Riverside 65 El Sobrante 241   -117.46117 33.872462
52376 2020-08-24 Contra Costa 13 El Sobrante 198   -122.295278 37.977222

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 881.143ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals