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

219 rows where place = 94103 sorted by date descending

View and edit SQL

Suggested facets: date (date)

place

  • 94103 · 219

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y
776 2020-10-23 San Francisco 75 94103 642   -122.411164 37.773152
1777 2020-10-22 San Francisco 75 94103 635   -122.411164 37.773152
2751 2020-10-21 San Francisco 75 94103 635   -122.411164 37.773152
3763 2020-10-20 San Francisco 75 94103 633   -122.411164 37.773152
4670 2020-10-19 San Francisco 75 94103 632   -122.411164 37.773152
5352 2020-10-18 San Francisco 75 94103 629   -122.411164 37.773152
6011 2020-10-17 San Francisco 75 94103 626   -122.411164 37.773152
7881 2020-10-15 San Francisco 75 94103 622   -122.411164 37.773152
8814 2020-10-14 San Francisco 75 94103 617   -122.411164 37.773152
9699 2020-10-13 San Francisco 75 94103 616   -122.411164 37.773152
10648 2020-10-12 San Francisco 75 94103 614   -122.411164 37.773152
11329 2020-10-11 San Francisco 75 94103 613   -122.411164 37.773152
12041 2020-10-10 San Francisco 75 94103 616   -122.411164 37.773152
12965 2020-10-09 San Francisco 75 94103 615   -122.411164 37.773152
13950 2020-10-08 San Francisco 75 94103 615   -122.411164 37.773152
14935 2020-10-07 San Francisco 75 94103 614   -122.411164 37.773152
15875 2020-10-06 San Francisco 75 94103 610   -122.411164 37.773152
16772 2020-10-05 San Francisco 75 94103 608   -122.411164 37.773152
17459 2020-10-04 San Francisco 75 94103 607   -122.411164 37.773152
18100 2020-10-03 San Francisco 75 94103 605   -122.411164 37.773152
19042 2020-10-02 San Francisco 75 94103 604   -122.411164 37.773152
20033 2020-10-01 San Francisco 75 94103 604   -122.411164 37.773152
20971 2020-09-30 San Francisco 75 94103 602   -122.411164 37.773152
21970 2020-09-29 San Francisco 75 94103 602   -122.411164 37.773152
22952 2020-09-28 San Francisco 75 94103 601   -122.411164 37.773152
23668 2020-09-27 San Francisco 75 94103 599   -122.411164 37.773152
24341 2020-09-26 San Francisco 75 94103 599   -122.411164 37.773152
25253 2020-09-25 San Francisco 75 94103 599   -122.411164 37.773152
26273 2020-09-24 San Francisco 75 94103 596   -122.411164 37.773152
27254 2020-09-23 San Francisco 75 94103 592   -122.411164 37.773152
28131 2020-09-22 San Francisco 75 94103 591   -122.411164 37.773152
29050 2020-09-21 San Francisco 75 94103 589   -122.411164 37.773152
29777 2020-09-20 San Francisco 75 94103 586   -122.411164 37.773152
30503 2020-09-19 San Francisco 75 94103 585   -122.411164 37.773152
31402 2020-09-18 San Francisco 75 94103 580   -122.411164 37.773152
32397 2020-09-17 San Francisco 75 94103 572   -122.411164 37.773152
33282 2020-09-16 San Francisco 75 94103 570   -122.411164 37.773152
34305 2020-09-15 San Francisco 75 94103 567   -122.411164 37.773152
35267 2020-09-14 San Francisco 75 94103 559   -122.411164 37.773152
36021 2020-09-13 San Francisco 75 94103 552   -122.411164 37.773152
36704 2020-09-12 San Francisco 75 94103 549   -122.411164 37.773152
37651 2020-09-11 San Francisco 75 94103 546   -122.411164 37.773152
38624 2020-09-10 San Francisco 75 94103 544   -122.411164 37.773152
39599 2020-09-09 San Francisco 75 94103 537   -122.411164 37.773152
40596 2020-09-08 San Francisco 75 94103 533   -122.411164 37.773152
41294 2020-09-07 San Francisco 75 94103 528   -122.411164 37.773152
41926 2020-09-06 San Francisco 75 94103 527   -122.411164 37.773152
42581 2020-09-05 San Francisco 75 94103 525   -122.411164 37.773152
43507 2020-09-04 San Francisco 75 94103 524   -122.411164 37.773152
44467 2020-09-03 San Francisco 75 94103 520   -122.411164 37.773152
45399 2020-09-02 San Francisco 75 94103 514   -122.411164 37.773152
46424 2020-09-01 San Francisco 75 94103 508   -122.411164 37.773152
47365 2020-08-31 San Francisco 75 94103 503   -122.411164 37.773152
48088 2020-08-30 San Francisco 75 94103 500   -122.411164 37.773152
48917 2020-08-29 San Francisco 75 94103 499   -122.411164 37.773152
49509 2020-08-28 San Francisco 75 94103 498   -122.411164 37.773152
50329 2020-08-27 San Francisco 75 94103 492   -122.411164 37.773152
51268 2020-08-26 San Francisco 75 94103 489   -122.411164 37.773152
52183 2020-08-25 San Francisco 75 94103 485   -122.411164 37.773152
53137 2020-08-24 San Francisco 75 94103 480   -122.411164 37.773152
53803 2020-08-23 San Francisco 75 94103 477   -122.411164 37.773152
54552 2020-08-22 San Francisco 75 94103 474   -122.411164 37.773152
55496 2020-08-21 San Francisco 75 94103 471   -122.411164 37.773152
56444 2020-08-20 San Francisco 75 94103 469   -122.411164 37.773152
57399 2020-08-19 San Francisco 75 94103 462   -122.411164 37.773152
58378 2020-08-18 San Francisco 75 94103 459   -122.411164 37.773152
59323 2020-08-17 San Francisco 75 94103 458   -122.411164 37.773152
60111 2020-08-16 San Francisco 75 94103 455   -122.411164 37.773152
60787 2020-08-15 San Francisco 75 94103 453   -122.411164 37.773152
61669 2020-08-14 San Francisco 75 94103 442   -122.411164 37.773152
62559 2020-08-13 San Francisco 75 94103 437   -122.411164 37.773152
63531 2020-08-12 San Francisco 75 94103 429   -122.411164 37.773152
64458 2020-08-11 San Francisco 75 94103 414   -122.411164 37.773152
65288 2020-08-10 San Francisco 75 94103 406   -122.411164 37.773152
66019 2020-08-09 San Francisco 75 94103 399   -122.411164 37.773152
66693 2020-08-08 San Francisco 75 94103 397   -122.411164 37.773152
67515 2020-08-07 San Francisco 75 94103 396   -122.411164 37.773152
68484 2020-08-06 San Francisco 75 94103 386   -122.411164 37.773152
69340 2020-08-05 San Francisco 75 94103 381   -122.411164 37.773152
70268 2020-08-04 San Francisco 75 94103 374   -122.411164 37.773152
71135 2020-08-03 San Francisco 75 94103 372   -122.411164 37.773152
71765 2020-08-02 San Francisco 75 94103 370   -122.411164 37.773152
72369 2020-08-01 San Francisco 75 94103 370   -122.411164 37.773152
73231 2020-07-31 San Francisco 75 94103 366   -122.411164 37.773152
74182 2020-07-30 San Francisco 75 94103 362   -122.411164 37.773152
75085 2020-07-29 San Francisco 75 94103 351   -122.411164 37.773152
76001 2020-07-28 San Francisco 75 94103 348   -122.411164 37.773152
76902 2020-07-27 San Francisco 75 94103 344   -122.411164 37.773152
77595 2020-07-26 San Francisco 75 94103 340   -122.411164 37.773152
78301 2020-07-25 San Francisco 75 94103 338   -122.411164 37.773152
79128 2020-07-24 San Francisco 75 94103 335   -122.411164 37.773152
80096 2020-07-23 San Francisco 75 94103 330   -122.411164 37.773152
81035 2020-07-22 San Francisco 75 94103 329   -122.411164 37.773152
81962 2020-07-21 San Francisco 75 94103 323   -122.411164 37.773152
82857 2020-07-20 San Francisco 75 94103 316   -122.411164 37.773152
83593 2020-07-19 San Francisco 75 94103 311   -122.411164 37.773152
84299 2020-07-18 San Francisco 75 94103 309   -122.411164 37.773152
85127 2020-07-17 San Francisco 75 94103 303   -122.411164 37.773152
85964 2020-07-16 San Francisco 75 94103 294   -122.411164 37.773152
86893 2020-07-15 San Francisco 75 94103 285   -122.411164 37.773152

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