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 = "Arcadia" sorted by date descending

View and edit SQL

Suggested facets: date (date)

place

  • Arcadia · 219

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y
167 2020-10-23 Los Angeles 37 Arcadia 580   -118.037297 34.134186
1154 2020-10-22 Los Angeles 37 Arcadia 576   -118.037297 34.134186
2107 2020-10-21 Los Angeles 37 Arcadia 565   -118.037297 34.134186
3126 2020-10-20 Los Angeles 37 Arcadia 563   -118.037297 34.134186
4108 2020-10-19 Los Angeles 37 Arcadia 560   -118.037297 34.134186
4913 2020-10-18 Los Angeles 37 Arcadia 559   -118.037297 34.134186
5556 2020-10-17 Los Angeles 37 Arcadia 559   -118.037297 34.134186
6318 2020-10-16 Los Angeles 37 Arcadia 556   -118.037297 34.134186
7262 2020-10-15 Los Angeles 37 Arcadia 556   -118.037297 34.134186
8227 2020-10-14 Los Angeles 37 Arcadia 554   -118.037297 34.134186
9138 2020-10-13 Los Angeles 37 Arcadia 549   -118.037297 34.134186
10040 2020-10-12 Los Angeles 37 Arcadia 549   -118.037297 34.134186
10854 2020-10-11 Los Angeles 37 Arcadia 548   -118.037297 34.134186
11547 2020-10-10 Los Angeles 37 Arcadia 546   -118.037297 34.134186
12333 2020-10-09 Los Angeles 37 Arcadia 546   -118.037297 34.134186
13322 2020-10-08 Los Angeles 37 Arcadia 544   -118.037297 34.134186
14307 2020-10-07 Los Angeles 37 Arcadia 541   -118.037297 34.134186
15288 2020-10-06 Los Angeles 37 Arcadia 539   -118.037297 34.134186
16204 2020-10-05 Los Angeles 37 Arcadia 527   -118.037297 34.134186
17023 2020-10-04 Los Angeles 37 Arcadia 521   -118.037297 34.134186
17669 2020-10-03 Los Angeles 37 Arcadia 518   -118.037297 34.134186
18408 2020-10-02 Los Angeles 37 Arcadia 514   -118.037297 34.134186
19424 2020-10-01 Los Angeles 37 Arcadia 511   -118.037297 34.134186
20342 2020-09-30 Los Angeles 37 Arcadia 508   -118.037297 34.134186
21335 2020-09-29 Los Angeles 37 Arcadia 505   -118.037297 34.134186
22313 2020-09-28 Los Angeles 37 Arcadia 504   -118.037297 34.134186
23191 2020-09-27 Los Angeles 37 Arcadia 502   -118.037297 34.134186
23861 2020-09-26 Los Angeles 37 Arcadia 500   -118.037297 34.134186
24617 2020-09-25 Los Angeles 37 Arcadia 496   -118.037297 34.134186
25637 2020-09-24 Los Angeles 37 Arcadia 490   -118.037297 34.134186
26654 2020-09-23 Los Angeles 37 Arcadia 486   -118.037297 34.134186
27559 2020-09-22 Los Angeles 37 Arcadia 479   -118.037297 34.134186
28475 2020-09-21 Los Angeles 37 Arcadia 479   -118.037297 34.134186
29292 2020-09-20 Los Angeles 37 Arcadia 478   -118.037297 34.134186
30018 2020-09-19 Los Angeles 37 Arcadia 475   -118.037297 34.134186
30773 2020-09-18 Los Angeles 37 Arcadia 473   -118.037297 34.134186
31770 2020-09-17 Los Angeles 37 Arcadia 470   -118.037297 34.134186
32722 2020-09-16 Los Angeles 37 Arcadia 469   -118.037297 34.134186
33672 2020-09-15 Los Angeles 37 Arcadia 468   -118.037297 34.134186
34632 2020-09-14 Los Angeles 37 Arcadia 465   -118.037297 34.134186
35545 2020-09-13 Los Angeles 37 Arcadia 464   -118.037297 34.134186
36223 2020-09-12 Los Angeles 37 Arcadia 461   -118.037297 34.134186
37014 2020-09-11 Los Angeles 37 Arcadia 461   -118.037297 34.134186
37993 2020-09-10 Los Angeles 37 Arcadia 458   -118.037297 34.134186
38967 2020-09-09 Los Angeles 37 Arcadia 458   -118.037297 34.134186
39967 2020-09-08 Los Angeles 37 Arcadia 458   -118.037297 34.134186
40851 2020-09-07 Los Angeles 37 Arcadia 454   -118.037297 34.134186
41433 2020-09-06 Los Angeles 37 Arcadia 454   -118.037297 34.134186
42100 2020-09-05 Los Angeles 37 Arcadia 454   -118.037297 34.134186
42872 2020-09-04 Los Angeles 37 Arcadia 450   -118.037297 34.134186
43879 2020-09-03 Los Angeles 37 Arcadia 449   -118.037297 34.134186
44779 2020-09-02 Los Angeles 37 Arcadia 447   -118.037297 34.134186
45784 2020-09-01 Los Angeles 37 Arcadia 444   -118.037297 34.134186
46724 2020-08-31 Los Angeles 37 Arcadia 444   -118.037297 34.134186
47651 2020-08-30 Los Angeles 37 Arcadia 441   -118.037297 34.134186
48321 2020-08-29 Los Angeles 37 Arcadia 439   -118.037297 34.134186
49104 2020-08-28 Los Angeles 37 Arcadia 437   -118.037297 34.134186
49741 2020-08-27 Los Angeles 37 Arcadia 436   -118.037297 34.134186
50664 2020-08-26 Los Angeles 37 Arcadia 434   -118.037297 34.134186
51579 2020-08-25 Los Angeles 37 Arcadia 431   -118.037297 34.134186
52498 2020-08-24 Los Angeles 37 Arcadia 429   -118.037297 34.134186
53386 2020-08-23 Los Angeles 37 Arcadia 429   -118.037297 34.134186
53970 2020-08-22 Los Angeles 37 Arcadia 428   -118.037297 34.134186
54878 2020-08-21 Los Angeles 37 Arcadia 426   -118.037297 34.134186
55813 2020-08-20 Los Angeles 37 Arcadia 421   -118.037297 34.134186
56768 2020-08-19 Los Angeles 37 Arcadia 416   -118.037297 34.134186
57750 2020-08-18 Los Angeles 37 Arcadia 410   -118.037297 34.134186
58691 2020-08-17 Los Angeles 37 Arcadia 408   -118.037297 34.134186
59569 2020-08-16 Los Angeles 37 Arcadia 407   -118.037297 34.134186
60315 2020-08-15 Los Angeles 37 Arcadia 405   -118.037297 34.134186
61044 2020-08-14 Los Angeles 37 Arcadia 404   -118.037297 34.134186
61966 2020-08-13 Los Angeles 37 Arcadia 394   -118.037297 34.134186
62900 2020-08-12 Los Angeles 37 Arcadia 390   -118.037297 34.134186
63831 2020-08-11 Los Angeles 37 Arcadia 385   -118.037297 34.134186
64666 2020-08-10 Los Angeles 37 Arcadia 382   -118.037297 34.134186
65518 2020-08-09 Los Angeles 37 Arcadia 380   -118.037297 34.134186
66207 2020-08-08 Los Angeles 37 Arcadia 375   -118.037297 34.134186
66954 2020-08-07 Los Angeles 37 Arcadia 364   -118.037297 34.134186
67854 2020-08-06 Los Angeles 37 Arcadia 359   -118.037297 34.134186
68766 2020-08-05 Los Angeles 37 Arcadia 348   -118.037297 34.134186
69638 2020-08-04 Los Angeles 37 Arcadia 340   -118.037297 34.134186
70518 2020-08-03 Los Angeles 37 Arcadia 337   -118.037297 34.134186
71318 2020-08-02 Los Angeles 37 Arcadia 327   -118.037297 34.134186
71883 2020-08-01 Los Angeles 37 Arcadia 324   -118.037297 34.134186
72602 2020-07-31 Los Angeles 37 Arcadia 312   -118.037297 34.134186
73554 2020-07-30 Los Angeles 37 Arcadia 309   -118.037297 34.134186
74460 2020-07-29 Los Angeles 37 Arcadia 306   -118.037297 34.134186
75392 2020-07-28 Los Angeles 37 Arcadia 301   -118.037297 34.134186
76281 2020-07-27 Los Angeles 37 Arcadia 299   -118.037297 34.134186
77109 2020-07-26 Los Angeles 37 Arcadia 292   -118.037297 34.134186
77796 2020-07-25 Los Angeles 37 Arcadia 291   -118.037297 34.134186
78548 2020-07-24 Los Angeles 37 Arcadia 284   -118.037297 34.134186
79479 2020-07-23 Los Angeles 37 Arcadia 281   -118.037297 34.134186
80408 2020-07-22 Los Angeles 37 Arcadia 277   -118.037297 34.134186
81335 2020-07-21 Los Angeles 37 Arcadia 274   -118.037297 34.134186
82272 2020-07-20 Los Angeles 37 Arcadia 269   -118.037297 34.134186
83113 2020-07-19 Los Angeles 37 Arcadia 265   -118.037297 34.134186
83800 2020-07-18 Los Angeles 37 Arcadia 259   -118.037297 34.134186
84546 2020-07-17 Los Angeles 37 Arcadia 251   -118.037297 34.134186
85400 2020-07-16 Los Angeles 37 Arcadia 244   -118.037297 34.134186

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