latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
1,020 rows where county = "San Francisco" and population = 42471 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
622 | 622 | 94134 | 94134 | 2022-12-30 | San Francisco | 75 | 11346 | 42471 | |
1450 | 1450 | 94134 | 94134 | 2022-12-29 | San Francisco | 75 | 11345 | 42471 | |
2631 | 2631 | 94134 | 94134 | 2022-12-28 | San Francisco | 75 | 11342 | 42471 | |
3812 | 3812 | 94134 | 94134 | 2022-12-27 | San Francisco | 75 | 11321 | 42471 | |
4993 | 4993 | 94134 | 94134 | 2022-12-26 | San Francisco | 75 | 11321 | 42471 | |
6174 | 6174 | 94134 | 94134 | 2022-12-25 | San Francisco | 75 | 11309 | 42471 | |
7355 | 7355 | 94134 | 94134 | 2022-12-24 | San Francisco | 75 | 11301 | 42471 | |
8536 | 8536 | 94134 | 94134 | 2022-12-23 | San Francisco | 75 | 11274 | 42471 | |
9717 | 9717 | 94134 | 94134 | 2022-12-22 | San Francisco | 75 | 11271 | 42471 | |
10898 | 10898 | 94134 | 94134 | 2022-12-21 | San Francisco | 75 | 11259 | 42471 | |
12079 | 12079 | 94134 | 94134 | 2022-12-20 | San Francisco | 75 | 11246 | 42471 | |
13260 | 13260 | 94134 | 94134 | 2022-12-19 | San Francisco | 75 | 11236 | 42471 | |
14441 | 14441 | 94134 | 94134 | 2022-12-18 | San Francisco | 75 | 11222 | 42471 | |
15622 | 15622 | 94134 | 94134 | 2022-12-17 | San Francisco | 75 | 11214 | 42471 | |
16803 | 16803 | 94134 | 94134 | 2022-12-16 | San Francisco | 75 | 11196 | 42471 | |
17984 | 17984 | 94134 | 94134 | 2022-12-15 | San Francisco | 75 | 11192 | 42471 | |
19165 | 19165 | 94134 | 94134 | 2022-12-14 | San Francisco | 75 | 11183 | 42471 | |
20346 | 20346 | 94134 | 94134 | 2022-12-13 | San Francisco | 75 | 11169 | 42471 | |
21527 | 21527 | 94134 | 94134 | 2022-12-12 | San Francisco | 75 | 11152 | 42471 | |
22708 | 22708 | 94134 | 94134 | 2022-12-11 | San Francisco | 75 | 11136 | 42471 | |
23889 | 23889 | 94134 | 94134 | 2022-12-10 | San Francisco | 75 | 11118 | 42471 | |
25070 | 25070 | 94134 | 94134 | 2022-12-09 | San Francisco | 75 | 11094 | 42471 | |
26251 | 26251 | 94134 | 94134 | 2022-12-08 | San Francisco | 75 | 11087 | 42471 | |
27432 | 27432 | 94134 | 94134 | 2022-12-07 | San Francisco | 75 | 11080 | 42471 | |
28613 | 28613 | 94134 | 94134 | 2022-12-06 | San Francisco | 75 | 11067 | 42471 | |
29794 | 29794 | 94134 | 94134 | 2022-12-05 | San Francisco | 75 | 11046 | 42471 | |
30975 | 30975 | 94134 | 94134 | 2022-12-04 | San Francisco | 75 | 11039 | 42471 | |
32156 | 32156 | 94134 | 94134 | 2022-12-03 | San Francisco | 75 | 11013 | 42471 | |
33337 | 33337 | 94134 | 94134 | 2022-12-02 | San Francisco | 75 | 10989 | 42471 | |
34518 | 34518 | 94134 | 94134 | 2022-12-01 | San Francisco | 75 | 10979 | 42471 | |
35699 | 35699 | 94134 | 94134 | 2022-11-30 | San Francisco | 75 | 10967 | 42471 | |
36930 | 36930 | 94134 | 94134 | 2022-11-29 | San Francisco | 75 | 10960 | 42471 | |
38161 | 38161 | 94134 | 94134 | 2022-11-28 | San Francisco | 75 | 10929 | 42471 | |
39392 | 39392 | 94134 | 94134 | 2022-11-27 | San Francisco | 75 | 10929 | 42471 | |
40623 | 40623 | 94134 | 94134 | 2022-11-26 | San Francisco | 75 | 10929 | 42471 | |
41854 | 41854 | 94134 | 94134 | 2022-11-25 | San Francisco | 75 | 10912 | 42471 | |
43085 | 43085 | 94134 | 94134 | 2022-11-24 | San Francisco | 75 | 10910 | 42471 | |
44316 | 44316 | 94134 | 94134 | 2022-11-23 | San Francisco | 75 | 10908 | 42471 | |
45547 | 45547 | 94134 | 94134 | 2022-11-22 | San Francisco | 75 | 10902 | 42471 | |
46778 | 46778 | 94134 | 94134 | 2022-11-21 | San Francisco | 75 | 10896 | 42471 | |
48009 | 48009 | 94134 | 94134 | 2022-11-20 | San Francisco | 75 | 10885 | 42471 | |
49240 | 49240 | 94134 | 94134 | 2022-11-19 | San Francisco | 75 | 10878 | 42471 | |
50471 | 50471 | 94134 | 94134 | 2022-11-18 | San Francisco | 75 | 10869 | 42471 | |
51702 | 51702 | 94134 | 94134 | 2022-11-17 | San Francisco | 75 | 10864 | 42471 | |
52933 | 52933 | 94134 | 94134 | 2022-11-16 | San Francisco | 75 | 10861 | 42471 | |
54164 | 54164 | 94134 | 94134 | 2022-11-15 | San Francisco | 75 | 10858 | 42471 | |
55395 | 55395 | 94134 | 94134 | 2022-11-14 | San Francisco | 75 | 10840 | 42471 | |
56626 | 56626 | 94134 | 94134 | 2022-11-13 | San Francisco | 75 | 10840 | 42471 | |
57857 | 57857 | 94134 | 94134 | 2022-11-12 | San Francisco | 75 | 10832 | 42471 | |
59088 | 59088 | 94134 | 94134 | 2022-11-11 | San Francisco | 75 | 10824 | 42471 | |
60319 | 60319 | 94134 | 94134 | 2022-11-10 | San Francisco | 75 | 10821 | 42471 | |
61550 | 61550 | 94134 | 94134 | 2022-11-09 | San Francisco | 75 | 10809 | 42471 | |
62781 | 62781 | 94134 | 94134 | 2022-11-08 | San Francisco | 75 | 10801 | 42471 | |
64012 | 64012 | 94134 | 94134 | 2022-11-07 | San Francisco | 75 | 10799 | 42471 | |
65243 | 65243 | 94134 | 94134 | 2022-11-06 | San Francisco | 75 | 10795 | 42471 | |
66474 | 66474 | 94134 | 94134 | 2022-11-05 | San Francisco | 75 | 10793 | 42471 | |
67705 | 67705 | 94134 | 94134 | 2022-11-04 | San Francisco | 75 | 10771 | 42471 | |
68936 | 68936 | 94134 | 94134 | 2022-11-03 | San Francisco | 75 | 10761 | 42471 | |
70167 | 70167 | 94134 | 94134 | 2022-11-02 | San Francisco | 75 | 10753 | 42471 | |
71398 | 71398 | 94134 | 94134 | 2022-11-01 | San Francisco | 75 | 10753 | 42471 | |
72661 | 72661 | 94134 | 94134 | 2022-10-31 | San Francisco | 75 | 10750 | 42471 | |
73924 | 73924 | 94134 | 94134 | 2022-10-30 | San Francisco | 75 | 10744 | 42471 | |
75187 | 75187 | 94134 | 94134 | 2022-10-29 | San Francisco | 75 | 10739 | 42471 | |
76450 | 76450 | 94134 | 94134 | 2022-10-28 | San Francisco | 75 | 10733 | 42471 | |
77713 | 77713 | 94134 | 94134 | 2022-10-27 | San Francisco | 75 | 10729 | 42471 | |
78976 | 78976 | 94134 | 94134 | 2022-10-26 | San Francisco | 75 | 10725 | 42471 | |
80239 | 80239 | 94134 | 94134 | 2022-10-25 | San Francisco | 75 | 10724 | 42471 | |
81502 | 81502 | 94134 | 94134 | 2022-10-24 | San Francisco | 75 | 10720 | 42471 | |
82765 | 82765 | 94134 | 94134 | 2022-10-23 | San Francisco | 75 | 10718 | 42471 | |
84028 | 84028 | 94134 | 94134 | 2022-10-22 | San Francisco | 75 | 10715 | 42471 | |
85291 | 85291 | 94134 | 94134 | 2022-10-21 | San Francisco | 75 | 10709 | 42471 | |
86554 | 86554 | 94134 | 94134 | 2022-10-20 | San Francisco | 75 | 10709 | 42471 | |
87817 | 87817 | 94134 | 94134 | 2022-10-19 | San Francisco | 75 | 10707 | 42471 | |
89080 | 89080 | 94134 | 94134 | 2022-10-18 | San Francisco | 75 | 10705 | 42471 | |
90343 | 90343 | 94134 | 94134 | 2022-10-17 | San Francisco | 75 | 10699 | 42471 | |
91606 | 91606 | 94134 | 94134 | 2022-10-16 | San Francisco | 75 | 10690 | 42471 | |
92869 | 92869 | 94134 | 94134 | 2022-10-15 | San Francisco | 75 | 10683 | 42471 | |
94132 | 94132 | 94134 | 94134 | 2022-10-14 | San Francisco | 75 | 10679 | 42471 | |
95395 | 95395 | 94134 | 94134 | 2022-10-13 | San Francisco | 75 | 10675 | 42471 | |
96658 | 96658 | 94134 | 94134 | 2022-10-12 | San Francisco | 75 | 10672 | 42471 | |
97921 | 97921 | 94134 | 94134 | 2022-10-11 | San Francisco | 75 | 10657 | 42471 | |
99184 | 99184 | 94134 | 94134 | 2022-10-10 | San Francisco | 75 | 10657 | 42471 | |
100447 | 100447 | 94134 | 94134 | 2022-10-09 | San Francisco | 75 | 10656 | 42471 | |
101710 | 101710 | 94134 | 94134 | 2022-10-08 | San Francisco | 75 | 10655 | 42471 | |
102973 | 102973 | 94134 | 94134 | 2022-10-07 | San Francisco | 75 | 10648 | 42471 | |
104236 | 104236 | 94134 | 94134 | 2022-10-06 | San Francisco | 75 | 10649 | 42471 | |
105499 | 105499 | 94134 | 94134 | 2022-10-05 | San Francisco | 75 | 10647 | 42471 | |
106762 | 106762 | 94134 | 94134 | 2022-10-04 | San Francisco | 75 | 10644 | 42471 | |
108025 | 108025 | 94134 | 94134 | 2022-10-03 | San Francisco | 75 | 10638 | 42471 | |
109288 | 109288 | 94134 | 94134 | 2022-10-02 | San Francisco | 75 | 10632 | 42471 | |
110551 | 110551 | 94134 | 94134 | 2022-10-01 | San Francisco | 75 | 10627 | 42471 | |
111814 | 111814 | 94134 | 94134 | 2022-09-30 | San Francisco | 75 | 10617 | 42471 | |
113077 | 113077 | 94134 | 94134 | 2022-09-29 | San Francisco | 75 | 10613 | 42471 | |
114340 | 114340 | 94134 | 94134 | 2022-09-28 | San Francisco | 75 | 10610 | 42471 | |
115603 | 115603 | 94134 | 94134 | 2022-09-27 | San Francisco | 75 | 10522 | 42471 | |
116866 | 116866 | 94134 | 94134 | 2022-09-26 | San Francisco | 75 | 10521 | 42471 | |
118129 | 118129 | 94134 | 94134 | 2022-09-25 | San Francisco | 75 | 10519 | 42471 | |
119392 | 119392 | 94134 | 94134 | 2022-09-24 | San Francisco | 75 | 10518 | 42471 | |
120655 | 120655 | 94134 | 94134 | 2022-09-23 | San Francisco | 75 | 10516 | 42471 | |
121918 | 121918 | 94134 | 94134 | 2022-09-22 | San Francisco | 75 | 10515 | 42471 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] TEXT );