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

226 rows where place = "Alhambra" sorted by date descending

View and edit SQL

Suggested facets: date (date)

place

  • Alhambra · 226

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y
196 2020-10-30 Los Angeles 37 Alhambra 1446   -118.135504 34.083961
1190 2020-10-29 Los Angeles 37 Alhambra 1439   -118.135504 34.083961
2191 2020-10-28 Los Angeles 37 Alhambra 1428   -118.135504 34.083961
3184 2020-10-27 Los Angeles 37 Alhambra 1425   -118.135504 34.083961
4113 2020-10-26 Los Angeles 37 Alhambra 1423   -118.135504 34.083961
5027 2020-10-25 Los Angeles 37 Alhambra 1422   -118.135504 34.083961
5674 2020-10-24 Los Angeles 37 Alhambra 1415   -118.135504 34.083961
6395 2020-10-23 Los Angeles 37 Alhambra 1404   -118.135504 34.083961
7414 2020-10-22 Los Angeles 37 Alhambra 1391   -118.135504 34.083961
8367 2020-10-21 Los Angeles 37 Alhambra 1382   -118.135504 34.083961
9386 2020-10-20 Los Angeles 37 Alhambra 1383   -118.135504 34.083961
10368 2020-10-19 Los Angeles 37 Alhambra 1376   -118.135504 34.083961
11173 2020-10-18 Los Angeles 37 Alhambra 1369   -118.135504 34.083961
11816 2020-10-17 Los Angeles 37 Alhambra 1368   -118.135504 34.083961
12578 2020-10-16 Los Angeles 37 Alhambra 1362   -118.135504 34.083961
13522 2020-10-15 Los Angeles 37 Alhambra 1361   -118.135504 34.083961
14487 2020-10-14 Los Angeles 37 Alhambra 1356   -118.135504 34.083961
15398 2020-10-13 Los Angeles 37 Alhambra 1351   -118.135504 34.083961
16300 2020-10-12 Los Angeles 37 Alhambra 1349   -118.135504 34.083961
17114 2020-10-11 Los Angeles 37 Alhambra 1344   -118.135504 34.083961
17807 2020-10-10 Los Angeles 37 Alhambra 1341   -118.135504 34.083961
18593 2020-10-09 Los Angeles 37 Alhambra 1335   -118.135504 34.083961
19582 2020-10-08 Los Angeles 37 Alhambra 1327   -118.135504 34.083961
20567 2020-10-07 Los Angeles 37 Alhambra 1322   -118.135504 34.083961
21548 2020-10-06 Los Angeles 37 Alhambra 1309   -118.135504 34.083961
22464 2020-10-05 Los Angeles 37 Alhambra 1304   -118.135504 34.083961
23283 2020-10-04 Los Angeles 37 Alhambra 1301   -118.135504 34.083961
23929 2020-10-03 Los Angeles 37 Alhambra 1298   -118.135504 34.083961
24668 2020-10-02 Los Angeles 37 Alhambra 1292   -118.135504 34.083961
25684 2020-10-01 Los Angeles 37 Alhambra 1277   -118.135504 34.083961
26602 2020-09-30 Los Angeles 37 Alhambra 1272   -118.135504 34.083961
27595 2020-09-29 Los Angeles 37 Alhambra 1267   -118.135504 34.083961
28573 2020-09-28 Los Angeles 37 Alhambra 1265   -118.135504 34.083961
29451 2020-09-27 Los Angeles 37 Alhambra 1262   -118.135504 34.083961
30121 2020-09-26 Los Angeles 37 Alhambra 1257   -118.135504 34.083961
30877 2020-09-25 Los Angeles 37 Alhambra 1249   -118.135504 34.083961
31897 2020-09-24 Los Angeles 37 Alhambra 1243   -118.135504 34.083961
32914 2020-09-23 Los Angeles 37 Alhambra 1234   -118.135504 34.083961
33819 2020-09-22 Los Angeles 37 Alhambra 1229   -118.135504 34.083961
34735 2020-09-21 Los Angeles 37 Alhambra 1225   -118.135504 34.083961
35552 2020-09-20 Los Angeles 37 Alhambra 1224   -118.135504 34.083961
36278 2020-09-19 Los Angeles 37 Alhambra 1223   -118.135504 34.083961
37033 2020-09-18 Los Angeles 37 Alhambra 1222   -118.135504 34.083961
38030 2020-09-17 Los Angeles 37 Alhambra 1215   -118.135504 34.083961
38982 2020-09-16 Los Angeles 37 Alhambra 1210   -118.135504 34.083961
39932 2020-09-15 Los Angeles 37 Alhambra 1205   -118.135504 34.083961
40892 2020-09-14 Los Angeles 37 Alhambra 1204   -118.135504 34.083961
41805 2020-09-13 Los Angeles 37 Alhambra 1199   -118.135504 34.083961
42483 2020-09-12 Los Angeles 37 Alhambra 1195   -118.135504 34.083961
43274 2020-09-11 Los Angeles 37 Alhambra 1191   -118.135504 34.083961
44253 2020-09-10 Los Angeles 37 Alhambra 1185   -118.135504 34.083961
45227 2020-09-09 Los Angeles 37 Alhambra 1177   -118.135504 34.083961
46227 2020-09-08 Los Angeles 37 Alhambra 1176   -118.135504 34.083961
47111 2020-09-07 Los Angeles 37 Alhambra 1175   -118.135504 34.083961
47693 2020-09-06 Los Angeles 37 Alhambra 1175   -118.135504 34.083961
48360 2020-09-05 Los Angeles 37 Alhambra 1172   -118.135504 34.083961
49132 2020-09-04 Los Angeles 37 Alhambra 1170   -118.135504 34.083961
50139 2020-09-03 Los Angeles 37 Alhambra 1159   -118.135504 34.083961
51039 2020-09-02 Los Angeles 37 Alhambra 1153   -118.135504 34.083961
52044 2020-09-01 Los Angeles 37 Alhambra 1144   -118.135504 34.083961
52984 2020-08-31 Los Angeles 37 Alhambra 1141   -118.135504 34.083961
53911 2020-08-30 Los Angeles 37 Alhambra 1135   -118.135504 34.083961
54581 2020-08-29 Los Angeles 37 Alhambra 1135   -118.135504 34.083961
55364 2020-08-28 Los Angeles 37 Alhambra 1129   -118.135504 34.083961
56001 2020-08-27 Los Angeles 37 Alhambra 1122   -118.135504 34.083961
56924 2020-08-26 Los Angeles 37 Alhambra 1115   -118.135504 34.083961
57839 2020-08-25 Los Angeles 37 Alhambra 1107   -118.135504 34.083961
58758 2020-08-24 Los Angeles 37 Alhambra 1103   -118.135504 34.083961
59646 2020-08-23 Los Angeles 37 Alhambra 1101   -118.135504 34.083961
60230 2020-08-22 Los Angeles 37 Alhambra 1097   -118.135504 34.083961
61138 2020-08-21 Los Angeles 37 Alhambra 1092   -118.135504 34.083961
62073 2020-08-20 Los Angeles 37 Alhambra 1082   -118.135504 34.083961
63028 2020-08-19 Los Angeles 37 Alhambra 1070   -118.135504 34.083961
64010 2020-08-18 Los Angeles 37 Alhambra 1059   -118.135504 34.083961
64951 2020-08-17 Los Angeles 37 Alhambra 1057   -118.135504 34.083961
65829 2020-08-16 Los Angeles 37 Alhambra 1046   -118.135504 34.083961
66575 2020-08-15 Los Angeles 37 Alhambra 1041   -118.135504 34.083961
67304 2020-08-14 Los Angeles 37 Alhambra 1036   -118.135504 34.083961
68226 2020-08-13 Los Angeles 37 Alhambra 1023   -118.135504 34.083961
69160 2020-08-12 Los Angeles 37 Alhambra 1019   -118.135504 34.083961
70091 2020-08-11 Los Angeles 37 Alhambra 1014   -118.135504 34.083961
70926 2020-08-10 Los Angeles 37 Alhambra 1009   -118.135504 34.083961
71778 2020-08-09 Los Angeles 37 Alhambra 999   -118.135504 34.083961
72467 2020-08-08 Los Angeles 37 Alhambra 994   -118.135504 34.083961
73214 2020-08-07 Los Angeles 37 Alhambra 981   -118.135504 34.083961
74114 2020-08-06 Los Angeles 37 Alhambra 972   -118.135504 34.083961
75026 2020-08-05 Los Angeles 37 Alhambra 955   -118.135504 34.083961
75898 2020-08-04 Los Angeles 37 Alhambra 947   -118.135504 34.083961
76778 2020-08-03 Los Angeles 37 Alhambra 937   -118.135504 34.083961
77578 2020-08-02 Los Angeles 37 Alhambra 931   -118.135504 34.083961
78143 2020-08-01 Los Angeles 37 Alhambra 921   -118.135504 34.083961
78862 2020-07-31 Los Angeles 37 Alhambra 905   -118.135504 34.083961
79814 2020-07-30 Los Angeles 37 Alhambra 892   -118.135504 34.083961
80720 2020-07-29 Los Angeles 37 Alhambra 881   -118.135504 34.083961
81652 2020-07-28 Los Angeles 37 Alhambra 848   -118.135504 34.083961
82541 2020-07-27 Los Angeles 37 Alhambra 820   -118.135504 34.083961
83369 2020-07-26 Los Angeles 37 Alhambra 812   -118.135504 34.083961
84056 2020-07-25 Los Angeles 37 Alhambra 801   -118.135504 34.083961
84808 2020-07-24 Los Angeles 37 Alhambra 776   -118.135504 34.083961
85739 2020-07-23 Los Angeles 37 Alhambra 765   -118.135504 34.083961

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