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

View and edit SQL

Suggested facets: date (date)

place

  • La Mirada · 219

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y
282 2020-10-23 Los Angeles 37 La Mirada 930   -118.00932 33.90251
1269 2020-10-22 Los Angeles 37 La Mirada 919   -118.00932 33.90251
2221 2020-10-21 Los Angeles 37 La Mirada 904   -118.00932 33.90251
3240 2020-10-20 Los Angeles 37 La Mirada 904   -118.00932 33.90251
4222 2020-10-19 Los Angeles 37 La Mirada 901   -118.00932 33.90251
5027 2020-10-18 Los Angeles 37 La Mirada 899   -118.00932 33.90251
5670 2020-10-17 Los Angeles 37 La Mirada 899   -118.00932 33.90251
6432 2020-10-16 Los Angeles 37 La Mirada 899   -118.00932 33.90251
7376 2020-10-15 Los Angeles 37 La Mirada 899   -118.00932 33.90251
8341 2020-10-14 Los Angeles 37 La Mirada 894   -118.00932 33.90251
9252 2020-10-13 Los Angeles 37 La Mirada 889   -118.00932 33.90251
10154 2020-10-12 Los Angeles 37 La Mirada 882   -118.00932 33.90251
10968 2020-10-11 Los Angeles 37 La Mirada 881   -118.00932 33.90251
11661 2020-10-10 Los Angeles 37 La Mirada 881   -118.00932 33.90251
12447 2020-10-09 Los Angeles 37 La Mirada 880   -118.00932 33.90251
13436 2020-10-08 Los Angeles 37 La Mirada 878   -118.00932 33.90251
14421 2020-10-07 Los Angeles 37 La Mirada 877   -118.00932 33.90251
15402 2020-10-06 Los Angeles 37 La Mirada 877   -118.00932 33.90251
16318 2020-10-05 Los Angeles 37 La Mirada 871   -118.00932 33.90251
17137 2020-10-04 Los Angeles 37 La Mirada 871   -118.00932 33.90251
17783 2020-10-03 Los Angeles 37 La Mirada 868   -118.00932 33.90251
18522 2020-10-02 Los Angeles 37 La Mirada 864   -118.00932 33.90251
19538 2020-10-01 Los Angeles 37 La Mirada 859   -118.00932 33.90251
20456 2020-09-30 Los Angeles 37 La Mirada 855   -118.00932 33.90251
21449 2020-09-29 Los Angeles 37 La Mirada 852   -118.00932 33.90251
22427 2020-09-28 Los Angeles 37 La Mirada 847   -118.00932 33.90251
23305 2020-09-27 Los Angeles 37 La Mirada 847   -118.00932 33.90251
23975 2020-09-26 Los Angeles 37 La Mirada 846   -118.00932 33.90251
24731 2020-09-25 Los Angeles 37 La Mirada 846   -118.00932 33.90251
25751 2020-09-24 Los Angeles 37 La Mirada 842   -118.00932 33.90251
26768 2020-09-23 Los Angeles 37 La Mirada 839   -118.00932 33.90251
27673 2020-09-22 Los Angeles 37 La Mirada 835   -118.00932 33.90251
28589 2020-09-21 Los Angeles 37 La Mirada 830   -118.00932 33.90251
29406 2020-09-20 Los Angeles 37 La Mirada 830   -118.00932 33.90251
30132 2020-09-19 Los Angeles 37 La Mirada 828   -118.00932 33.90251
30887 2020-09-18 Los Angeles 37 La Mirada 826   -118.00932 33.90251
31884 2020-09-17 Los Angeles 37 La Mirada 822   -118.00932 33.90251
32836 2020-09-16 Los Angeles 37 La Mirada 815   -118.00932 33.90251
33786 2020-09-15 Los Angeles 37 La Mirada 812   -118.00932 33.90251
34746 2020-09-14 Los Angeles 37 La Mirada 810   -118.00932 33.90251
35659 2020-09-13 Los Angeles 37 La Mirada 809   -118.00932 33.90251
36337 2020-09-12 Los Angeles 37 La Mirada 807   -118.00932 33.90251
37128 2020-09-11 Los Angeles 37 La Mirada 804   -118.00932 33.90251
38107 2020-09-10 Los Angeles 37 La Mirada 802   -118.00932 33.90251
39081 2020-09-09 Los Angeles 37 La Mirada 801   -118.00932 33.90251
40081 2020-09-08 Los Angeles 37 La Mirada 800   -118.00932 33.90251
40965 2020-09-07 Los Angeles 37 La Mirada 797   -118.00932 33.90251
41547 2020-09-06 Los Angeles 37 La Mirada 794   -118.00932 33.90251
42214 2020-09-05 Los Angeles 37 La Mirada 794   -118.00932 33.90251
42986 2020-09-04 Los Angeles 37 La Mirada 790   -118.00932 33.90251
43993 2020-09-03 Los Angeles 37 La Mirada 787   -118.00932 33.90251
44893 2020-09-02 Los Angeles 37 La Mirada 784   -118.00932 33.90251
45898 2020-09-01 Los Angeles 37 La Mirada 780   -118.00932 33.90251
46838 2020-08-31 Los Angeles 37 La Mirada 774   -118.00932 33.90251
47765 2020-08-30 Los Angeles 37 La Mirada 773   -118.00932 33.90251
48435 2020-08-29 Los Angeles 37 La Mirada 771   -118.00932 33.90251
49218 2020-08-28 Los Angeles 37 La Mirada 770   -118.00932 33.90251
49855 2020-08-27 Los Angeles 37 La Mirada 770   -118.00932 33.90251
50778 2020-08-26 Los Angeles 37 La Mirada 768   -118.00932 33.90251
51693 2020-08-25 Los Angeles 37 La Mirada 762   -118.00932 33.90251
52612 2020-08-24 Los Angeles 37 La Mirada 759   -118.00932 33.90251
53500 2020-08-23 Los Angeles 37 La Mirada 755   -118.00932 33.90251
54084 2020-08-22 Los Angeles 37 La Mirada 753   -118.00932 33.90251
54992 2020-08-21 Los Angeles 37 La Mirada 747   -118.00932 33.90251
55927 2020-08-20 Los Angeles 37 La Mirada 741   -118.00932 33.90251
56882 2020-08-19 Los Angeles 37 La Mirada 736   -118.00932 33.90251
57864 2020-08-18 Los Angeles 37 La Mirada 733   -118.00932 33.90251
58805 2020-08-17 Los Angeles 37 La Mirada 728   -118.00932 33.90251
59683 2020-08-16 Los Angeles 37 La Mirada 727   -118.00932 33.90251
60429 2020-08-15 Los Angeles 37 La Mirada 727   -118.00932 33.90251
61158 2020-08-14 Los Angeles 37 La Mirada 722   -118.00932 33.90251
62080 2020-08-13 Los Angeles 37 La Mirada 706   -118.00932 33.90251
63014 2020-08-12 Los Angeles 37 La Mirada 694   -118.00932 33.90251
63945 2020-08-11 Los Angeles 37 La Mirada 688   -118.00932 33.90251
64780 2020-08-10 Los Angeles 37 La Mirada 684   -118.00932 33.90251
65632 2020-08-09 Los Angeles 37 La Mirada 678   -118.00932 33.90251
66321 2020-08-08 Los Angeles 37 La Mirada 669   -118.00932 33.90251
67068 2020-08-07 Los Angeles 37 La Mirada 666   -118.00932 33.90251
67968 2020-08-06 Los Angeles 37 La Mirada 658   -118.00932 33.90251
68880 2020-08-05 Los Angeles 37 La Mirada 646   -118.00932 33.90251
69752 2020-08-04 Los Angeles 37 La Mirada 636   -118.00932 33.90251
70632 2020-08-03 Los Angeles 37 La Mirada 624   -118.00932 33.90251
71432 2020-08-02 Los Angeles 37 La Mirada 622   -118.00932 33.90251
71997 2020-08-01 Los Angeles 37 La Mirada 620   -118.00932 33.90251
72716 2020-07-31 Los Angeles 37 La Mirada 611   -118.00932 33.90251
73668 2020-07-30 Los Angeles 37 La Mirada 607   -118.00932 33.90251
74574 2020-07-29 Los Angeles 37 La Mirada 603   -118.00932 33.90251
75506 2020-07-28 Los Angeles 37 La Mirada 597   -118.00932 33.90251
76395 2020-07-27 Los Angeles 37 La Mirada 587   -118.00932 33.90251
77223 2020-07-26 Los Angeles 37 La Mirada 579   -118.00932 33.90251
77910 2020-07-25 Los Angeles 37 La Mirada 571   -118.00932 33.90251
78662 2020-07-24 Los Angeles 37 La Mirada 566   -118.00932 33.90251
79593 2020-07-23 Los Angeles 37 La Mirada 563   -118.00932 33.90251
80522 2020-07-22 Los Angeles 37 La Mirada 551   -118.00932 33.90251
81449 2020-07-21 Los Angeles 37 La Mirada 547   -118.00932 33.90251
82386 2020-07-20 Los Angeles 37 La Mirada 537   -118.00932 33.90251
83227 2020-07-19 Los Angeles 37 La Mirada 525   -118.00932 33.90251
83914 2020-07-18 Los Angeles 37 La Mirada 515   -118.00932 33.90251
84660 2020-07-17 Los Angeles 37 La Mirada 506   -118.00932 33.90251
85514 2020-07-16 Los Angeles 37 La Mirada 501   -118.00932 33.90251

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