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

228 rows where place = 94112 sorted by date descending

View and edit SQL

Suggested facets: date (date)

place

  • 94112 · 228

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y
857 2020-10-30 San Francisco 75 94112 1876   -122.442936 37.720367
1847 2020-10-29 San Francisco 75 94112 1870   -122.442936 37.720367
2831 2020-10-28 San Francisco 75 94112 1865   -122.442936 37.720367
3807 2020-10-27 San Francisco 75 94112 1858   -122.442936 37.720367
4765 2020-10-26 San Francisco 75 94112 1852   -122.442936 37.720367
5529 2020-10-25 San Francisco 75 94112 1849   -122.442936 37.720367
6127 2020-10-24 San Francisco 75 94112 1848   -122.442936 37.720367
7050 2020-10-23 San Francisco 75 94112 1840   -122.442936 37.720367
8051 2020-10-22 San Francisco 75 94112 1829   -122.442936 37.720367
9025 2020-10-21 San Francisco 75 94112 1829   -122.442936 37.720367
10037 2020-10-20 San Francisco 75 94112 1827   -122.442936 37.720367
10944 2020-10-19 San Francisco 75 94112 1824   -122.442936 37.720367
11626 2020-10-18 San Francisco 75 94112 1822   -122.442936 37.720367
12285 2020-10-17 San Francisco 75 94112 1818   -122.442936 37.720367
14155 2020-10-15 San Francisco 75 94112 1808   -122.442936 37.720367
15088 2020-10-14 San Francisco 75 94112 1806   -122.442936 37.720367
15973 2020-10-13 San Francisco 75 94112 1804   -122.442936 37.720367
16922 2020-10-12 San Francisco 75 94112 1804   -122.442936 37.720367
17603 2020-10-11 San Francisco 75 94112 1799   -122.442936 37.720367
18314 2020-10-10 San Francisco 75 94112 1804   -122.442936 37.720367
19238 2020-10-09 San Francisco 75 94112 1804   -122.442936 37.720367
20223 2020-10-08 San Francisco 75 94112 1803   -122.442936 37.720367
21208 2020-10-07 San Francisco 75 94112 1801   -122.442936 37.720367
22148 2020-10-06 San Francisco 75 94112 1796   -122.442936 37.720367
23045 2020-10-05 San Francisco 75 94112 1791   -122.442936 37.720367
23732 2020-10-04 San Francisco 75 94112 1787   -122.442936 37.720367
24373 2020-10-03 San Francisco 75 94112 1786   -122.442936 37.720367
25315 2020-10-02 San Francisco 75 94112 1784   -122.442936 37.720367
26306 2020-10-01 San Francisco 75 94112 1780   -122.442936 37.720367
27244 2020-09-30 San Francisco 75 94112 1776   -122.442936 37.720367
28243 2020-09-29 San Francisco 75 94112 1767   -122.442936 37.720367
29225 2020-09-28 San Francisco 75 94112 1763   -122.442936 37.720367
29941 2020-09-27 San Francisco 75 94112 1754   -122.442936 37.720367
30614 2020-09-26 San Francisco 75 94112 1752   -122.442936 37.720367
31526 2020-09-25 San Francisco 75 94112 1748   -122.442936 37.720367
32546 2020-09-24 San Francisco 75 94112 1740   -122.442936 37.720367
33527 2020-09-23 San Francisco 75 94112 1721   -122.442936 37.720367
34404 2020-09-22 San Francisco 75 94112 1709   -122.442936 37.720367
35323 2020-09-21 San Francisco 75 94112 1702   -122.442936 37.720367
36050 2020-09-20 San Francisco 75 94112 1695   -122.442936 37.720367
36776 2020-09-19 San Francisco 75 94112 1691   -122.442936 37.720367
37675 2020-09-18 San Francisco 75 94112 1684   -122.442936 37.720367
38670 2020-09-17 San Francisco 75 94112 1673   -122.442936 37.720367
39555 2020-09-16 San Francisco 75 94112 1663   -122.442936 37.720367
40578 2020-09-15 San Francisco 75 94112 1651   -122.442936 37.720367
41540 2020-09-14 San Francisco 75 94112 1642   -122.442936 37.720367
42294 2020-09-13 San Francisco 75 94112 1633   -122.442936 37.720367
42977 2020-09-12 San Francisco 75 94112 1628   -122.442936 37.720367
43924 2020-09-11 San Francisco 75 94112 1612   -122.442936 37.720367
44897 2020-09-10 San Francisco 75 94112 1595   -122.442936 37.720367
45872 2020-09-09 San Francisco 75 94112 1590   -122.442936 37.720367
46869 2020-09-08 San Francisco 75 94112 1580   -122.442936 37.720367
47567 2020-09-07 San Francisco 75 94112 1563   -122.442936 37.720367
48199 2020-09-06 San Francisco 75 94112 1558   -122.442936 37.720367
48854 2020-09-05 San Francisco 75 94112 1555   -122.442936 37.720367
49780 2020-09-04 San Francisco 75 94112 1553   -122.442936 37.720367
50740 2020-09-03 San Francisco 75 94112 1542   -122.442936 37.720367
51672 2020-09-02 San Francisco 75 94112 1526   -122.442936 37.720367
52697 2020-09-01 San Francisco 75 94112 1512   -122.442936 37.720367
53638 2020-08-31 San Francisco 75 94112 1499   -122.442936 37.720367
54361 2020-08-30 San Francisco 75 94112 1484   -122.442936 37.720367
55190 2020-08-29 San Francisco 75 94112 1479   -122.442936 37.720367
55782 2020-08-28 San Francisco 75 94112 1468   -122.442936 37.720367
56602 2020-08-27 San Francisco 75 94112 1451   -122.442936 37.720367
57541 2020-08-26 San Francisco 75 94112 1436   -122.442936 37.720367
58456 2020-08-25 San Francisco 75 94112 1424   -122.442936 37.720367
59410 2020-08-24 San Francisco 75 94112 1412   -122.442936 37.720367
60076 2020-08-23 San Francisco 75 94112 1386   -122.442936 37.720367
60825 2020-08-22 San Francisco 75 94112 1378   -122.442936 37.720367
61769 2020-08-21 San Francisco 75 94112 1369   -122.442936 37.720367
62717 2020-08-20 San Francisco 75 94112 1356   -122.442936 37.720367
63672 2020-08-19 San Francisco 75 94112 1341   -122.442936 37.720367
64651 2020-08-18 San Francisco 75 94112 1327   -122.442936 37.720367
65596 2020-08-17 San Francisco 75 94112 1309   -122.442936 37.720367
66384 2020-08-16 San Francisco 75 94112 1296   -122.442936 37.720367
67060 2020-08-15 San Francisco 75 94112 1288   -122.442936 37.720367
67942 2020-08-14 San Francisco 75 94112 1278   -122.442936 37.720367
68832 2020-08-13 San Francisco 75 94112 1258   -122.442936 37.720367
69804 2020-08-12 San Francisco 75 94112 1242   -122.442936 37.720367
70731 2020-08-11 San Francisco 75 94112 1221   -122.442936 37.720367
71561 2020-08-10 San Francisco 75 94112 1205   -122.442936 37.720367
72292 2020-08-09 San Francisco 75 94112 1186   -122.442936 37.720367
72966 2020-08-08 San Francisco 75 94112 1180   -122.442936 37.720367
73788 2020-08-07 San Francisco 75 94112 1169   -122.442936 37.720367
74757 2020-08-06 San Francisco 75 94112 1140   -122.442936 37.720367
75613 2020-08-05 San Francisco 75 94112 1133   -122.442936 37.720367
76541 2020-08-04 San Francisco 75 94112 1106   -122.442936 37.720367
77408 2020-08-03 San Francisco 75 94112 1091   -122.442936 37.720367
78038 2020-08-02 San Francisco 75 94112 1064   -122.442936 37.720367
78642 2020-08-01 San Francisco 75 94112 1052   -122.442936 37.720367
79504 2020-07-31 San Francisco 75 94112 1047   -122.442936 37.720367
80455 2020-07-30 San Francisco 75 94112 1027   -122.442936 37.720367
81358 2020-07-29 San Francisco 75 94112 1007   -122.442936 37.720367
82274 2020-07-28 San Francisco 75 94112 982   -122.442936 37.720367
83175 2020-07-27 San Francisco 75 94112 963   -122.442936 37.720367
83868 2020-07-26 San Francisco 75 94112 950   -122.442936 37.720367
84574 2020-07-25 San Francisco 75 94112 941   -122.442936 37.720367
85401 2020-07-24 San Francisco 75 94112 925   -122.442936 37.720367
86369 2020-07-23 San Francisco 75 94112 902   -122.442936 37.720367
87308 2020-07-22 San Francisco 75 94112 868   -122.442936 37.720367

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