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

220 rows where place = 94109 sorted by date descending

View and edit SQL

Suggested facets: date (date)

place

  • 94109 · 220

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y
781 2020-10-23 San Francisco 75 94109 697   -122.422444 37.795388
1782 2020-10-22 San Francisco 75 94109 693   -122.422444 37.795388
2756 2020-10-21 San Francisco 75 94109 693   -122.422444 37.795388
3768 2020-10-20 San Francisco 75 94109 689   -122.422444 37.795388
4675 2020-10-19 San Francisco 75 94109 687   -122.422444 37.795388
5357 2020-10-18 San Francisco 75 94109 687   -122.422444 37.795388
6016 2020-10-17 San Francisco 75 94109 685   -122.422444 37.795388
7886 2020-10-15 San Francisco 75 94109 678   -122.422444 37.795388
8819 2020-10-14 San Francisco 75 94109 677   -122.422444 37.795388
9704 2020-10-13 San Francisco 75 94109 676   -122.422444 37.795388
10653 2020-10-12 San Francisco 75 94109 674   -122.422444 37.795388
11334 2020-10-11 San Francisco 75 94109 670   -122.422444 37.795388
12045 2020-10-10 San Francisco 75 94109 676   -122.422444 37.795388
12969 2020-10-09 San Francisco 75 94109 675   -122.422444 37.795388
13954 2020-10-08 San Francisco 75 94109 673   -122.422444 37.795388
14939 2020-10-07 San Francisco 75 94109 672   -122.422444 37.795388
15879 2020-10-06 San Francisco 75 94109 671   -122.422444 37.795388
16776 2020-10-05 San Francisco 75 94109 667   -122.422444 37.795388
17463 2020-10-04 San Francisco 75 94109 664   -122.422444 37.795388
18104 2020-10-03 San Francisco 75 94109 664   -122.422444 37.795388
19046 2020-10-02 San Francisco 75 94109 664   -122.422444 37.795388
20037 2020-10-01 San Francisco 75 94109 663   -122.422444 37.795388
20975 2020-09-30 San Francisco 75 94109 662   -122.422444 37.795388
21974 2020-09-29 San Francisco 75 94109 660   -122.422444 37.795388
22956 2020-09-28 San Francisco 75 94109 656   -122.422444 37.795388
23672 2020-09-27 San Francisco 75 94109 651   -122.422444 37.795388
24345 2020-09-26 San Francisco 75 94109 649   -122.422444 37.795388
25257 2020-09-25 San Francisco 75 94109 646   -122.422444 37.795388
26277 2020-09-24 San Francisco 75 94109 640   -122.422444 37.795388
27258 2020-09-23 San Francisco 75 94109 638   -122.422444 37.795388
28135 2020-09-22 San Francisco 75 94109 635   -122.422444 37.795388
29054 2020-09-21 San Francisco 75 94109 632   -122.422444 37.795388
29781 2020-09-20 San Francisco 75 94109 628   -122.422444 37.795388
30507 2020-09-19 San Francisco 75 94109 628   -122.422444 37.795388
31406 2020-09-18 San Francisco 75 94109 626   -122.422444 37.795388
32401 2020-09-17 San Francisco 75 94109 624   -122.422444 37.795388
33286 2020-09-16 San Francisco 75 94109 623   -122.422444 37.795388
34309 2020-09-15 San Francisco 75 94109 622   -122.422444 37.795388
35271 2020-09-14 San Francisco 75 94109 620   -122.422444 37.795388
36025 2020-09-13 San Francisco 75 94109 612   -122.422444 37.795388
36708 2020-09-12 San Francisco 75 94109 610   -122.422444 37.795388
37655 2020-09-11 San Francisco 75 94109 609   -122.422444 37.795388
38628 2020-09-10 San Francisco 75 94109 602   -122.422444 37.795388
39603 2020-09-09 San Francisco 75 94109 600   -122.422444 37.795388
40600 2020-09-08 San Francisco 75 94109 599   -122.422444 37.795388
41298 2020-09-07 San Francisco 75 94109 594   -122.422444 37.795388
41930 2020-09-06 San Francisco 75 94109 593   -122.422444 37.795388
42585 2020-09-05 San Francisco 75 94109 592   -122.422444 37.795388
43511 2020-09-04 San Francisco 75 94109 590   -122.422444 37.795388
44471 2020-09-03 San Francisco 75 94109 578   -122.422444 37.795388
45403 2020-09-02 San Francisco 75 94109 567   -122.422444 37.795388
46428 2020-09-01 San Francisco 75 94109 562   -122.422444 37.795388
47369 2020-08-31 San Francisco 75 94109 559   -122.422444 37.795388
48092 2020-08-30 San Francisco 75 94109 553   -122.422444 37.795388
48921 2020-08-29 San Francisco 75 94109 553   -122.422444 37.795388
49513 2020-08-28 San Francisco 75 94109 552   -122.422444 37.795388
50333 2020-08-27 San Francisco 75 94109 552   -122.422444 37.795388
51272 2020-08-26 San Francisco 75 94109 540   -122.422444 37.795388
52187 2020-08-25 San Francisco 75 94109 536   -122.422444 37.795388
53141 2020-08-24 San Francisco 75 94109 529   -122.422444 37.795388
53807 2020-08-23 San Francisco 75 94109 524   -122.422444 37.795388
54556 2020-08-22 San Francisco 75 94109 522   -122.422444 37.795388
55500 2020-08-21 San Francisco 75 94109 520   -122.422444 37.795388
56448 2020-08-20 San Francisco 75 94109 514   -122.422444 37.795388
57403 2020-08-19 San Francisco 75 94109 510   -122.422444 37.795388
58382 2020-08-18 San Francisco 75 94109 506   -122.422444 37.795388
59327 2020-08-17 San Francisco 75 94109 501   -122.422444 37.795388
60115 2020-08-16 San Francisco 75 94109 492   -122.422444 37.795388
60791 2020-08-15 San Francisco 75 94109 491   -122.422444 37.795388
61673 2020-08-14 San Francisco 75 94109 488   -122.422444 37.795388
62563 2020-08-13 San Francisco 75 94109 480   -122.422444 37.795388
63535 2020-08-12 San Francisco 75 94109 472   -122.422444 37.795388
64462 2020-08-11 San Francisco 75 94109 460   -122.422444 37.795388
65292 2020-08-10 San Francisco 75 94109 454   -122.422444 37.795388
66023 2020-08-09 San Francisco 75 94109 448   -122.422444 37.795388
66697 2020-08-08 San Francisco 75 94109 447   -122.422444 37.795388
67519 2020-08-07 San Francisco 75 94109 446   -122.422444 37.795388
68488 2020-08-06 San Francisco 75 94109 437   -122.422444 37.795388
69344 2020-08-05 San Francisco 75 94109 434   -122.422444 37.795388
70272 2020-08-04 San Francisco 75 94109 430   -122.422444 37.795388
71139 2020-08-03 San Francisco 75 94109 426   -122.422444 37.795388
71769 2020-08-02 San Francisco 75 94109 424   -122.422444 37.795388
72373 2020-08-01 San Francisco 75 94109 423   -122.422444 37.795388
73235 2020-07-31 San Francisco 75 94109 421   -122.422444 37.795388
74186 2020-07-30 San Francisco 75 94109 412   -122.422444 37.795388
75089 2020-07-29 San Francisco 75 94109 401   -122.422444 37.795388
76005 2020-07-28 San Francisco 75 94109 391   -122.422444 37.795388
76906 2020-07-27 San Francisco 75 94109 389   -122.422444 37.795388
77599 2020-07-26 San Francisco 75 94109 384   -122.422444 37.795388
78305 2020-07-25 San Francisco 75 94109 376   -122.422444 37.795388
79132 2020-07-24 San Francisco 75 94109 370   -122.422444 37.795388
80100 2020-07-23 San Francisco 75 94109 360   -122.422444 37.795388
81039 2020-07-22 San Francisco 75 94109 353   -122.422444 37.795388
81966 2020-07-21 San Francisco 75 94109 344   -122.422444 37.795388
82861 2020-07-20 San Francisco 75 94109 341   -122.422444 37.795388
83597 2020-07-19 San Francisco 75 94109 325   -122.422444 37.795388
84303 2020-07-18 San Francisco 75 94109 309   -122.422444 37.795388
85131 2020-07-17 San Francisco 75 94109 304   -122.422444 37.795388
85968 2020-07-16 San Francisco 75 94109 297   -122.422444 37.795388
86897 2020-07-15 San Francisco 75 94109 289   -122.422444 37.795388

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