latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
31,264 rows where county = "Placer" sorted by confirmed_cases descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | id | name | date | county | fips | confirmed_cases ▲ | note | population |
---|---|---|---|---|---|---|---|---|---|
72380 | 72380 | 95747 | 95747: Roseville | 2022-10-31 | Placer | 61 | 14960 | 59715 | |
73643 | 73643 | 95747 | 95747: Roseville | 2022-10-30 | Placer | 61 | 14960 | 59715 | |
74906 | 74906 | 95747 | 95747: Roseville | 2022-10-29 | Placer | 61 | 14960 | 59715 | |
76169 | 76169 | 95747 | 95747: Roseville | 2022-10-28 | Placer | 61 | 14960 | 59715 | |
77432 | 77432 | 95747 | 95747: Roseville | 2022-10-27 | Placer | 61 | 14960 | 59715 | |
78695 | 78695 | 95747 | 95747: Roseville | 2022-10-26 | Placer | 61 | 14960 | 59715 | |
79958 | 79958 | 95747 | 95747: Roseville | 2022-10-25 | Placer | 61 | 14937 | 59715 | |
81221 | 81221 | 95747 | 95747: Roseville | 2022-10-24 | Placer | 61 | 14937 | 59715 | |
82484 | 82484 | 95747 | 95747: Roseville | 2022-10-23 | Placer | 61 | 14937 | 59715 | |
83747 | 83747 | 95747 | 95747: Roseville | 2022-10-22 | Placer | 61 | 14937 | 59715 | |
85010 | 85010 | 95747 | 95747: Roseville | 2022-10-21 | Placer | 61 | 14937 | 59715 | |
86273 | 86273 | 95747 | 95747: Roseville | 2022-10-20 | Placer | 61 | 14937 | 59715 | |
87536 | 87536 | 95747 | 95747: Roseville | 2022-10-19 | Placer | 61 | 14937 | 59715 | |
88799 | 88799 | 95747 | 95747: Roseville | 2022-10-18 | Placer | 61 | 14914 | 59715 | |
90062 | 90062 | 95747 | 95747: Roseville | 2022-10-17 | Placer | 61 | 14914 | 59715 | |
91325 | 91325 | 95747 | 95747: Roseville | 2022-10-16 | Placer | 61 | 14914 | 59715 | |
92588 | 92588 | 95747 | 95747: Roseville | 2022-10-15 | Placer | 61 | 14914 | 59715 | |
93851 | 93851 | 95747 | 95747: Roseville | 2022-10-14 | Placer | 61 | 14914 | 59715 | |
95114 | 95114 | 95747 | 95747: Roseville | 2022-10-13 | Placer | 61 | 14914 | 59715 | |
96377 | 96377 | 95747 | 95747: Roseville | 2022-10-12 | Placer | 61 | 14914 | 59715 | |
97640 | 97640 | 95747 | 95747: Roseville | 2022-10-11 | Placer | 61 | 14885 | 59715 | |
98903 | 98903 | 95747 | 95747: Roseville | 2022-10-10 | Placer | 61 | 14885 | 59715 | |
100166 | 100166 | 95747 | 95747: Roseville | 2022-10-09 | Placer | 61 | 14885 | 59715 | |
101429 | 101429 | 95747 | 95747: Roseville | 2022-10-08 | Placer | 61 | 14885 | 59715 | |
102692 | 102692 | 95747 | 95747: Roseville | 2022-10-07 | Placer | 61 | 14885 | 59715 | |
103955 | 103955 | 95747 | 95747: Roseville | 2022-10-06 | Placer | 61 | 14885 | 59715 | |
105218 | 105218 | 95747 | 95747: Roseville | 2022-10-05 | Placer | 61 | 14885 | 59715 | |
106481 | 106481 | 95747 | 95747: Roseville | 2022-10-04 | Placer | 61 | 14845 | 59715 | |
107744 | 107744 | 95747 | 95747: Roseville | 2022-10-03 | Placer | 61 | 14845 | 59715 | |
109007 | 109007 | 95747 | 95747: Roseville | 2022-10-02 | Placer | 61 | 14845 | 59715 | |
110270 | 110270 | 95747 | 95747: Roseville | 2022-10-01 | Placer | 61 | 14845 | 59715 | |
111533 | 111533 | 95747 | 95747: Roseville | 2022-09-30 | Placer | 61 | 14845 | 59715 | |
112796 | 112796 | 95747 | 95747: Roseville | 2022-09-29 | Placer | 61 | 14845 | 59715 | |
114059 | 114059 | 95747 | 95747: Roseville | 2022-09-28 | Placer | 61 | 14845 | 59715 | |
115322 | 115322 | 95747 | 95747: Roseville | 2022-09-27 | Placer | 61 | 14818 | 59715 | |
116585 | 116585 | 95747 | 95747: Roseville | 2022-09-26 | Placer | 61 | 14818 | 59715 | |
117848 | 117848 | 95747 | 95747: Roseville | 2022-09-25 | Placer | 61 | 14818 | 59715 | |
119111 | 119111 | 95747 | 95747: Roseville | 2022-09-24 | Placer | 61 | 14818 | 59715 | |
120374 | 120374 | 95747 | 95747: Roseville | 2022-09-23 | Placer | 61 | 14818 | 59715 | |
121637 | 121637 | 95747 | 95747: Roseville | 2022-09-22 | Placer | 61 | 14818 | 59715 | |
122900 | 122900 | 95747 | 95747: Roseville | 2022-09-21 | Placer | 61 | 14818 | 59715 | |
124163 | 124163 | 95747 | 95747: Roseville | 2022-09-20 | Placer | 61 | 14782 | 59715 | |
125426 | 125426 | 95747 | 95747: Roseville | 2022-09-19 | Placer | 61 | 14782 | 59715 | |
126689 | 126689 | 95747 | 95747: Roseville | 2022-09-18 | Placer | 61 | 14782 | 59715 | |
127952 | 127952 | 95747 | 95747: Roseville | 2022-09-17 | Placer | 61 | 14782 | 59715 | |
129215 | 129215 | 95747 | 95747: Roseville | 2022-09-16 | Placer | 61 | 14782 | 59715 | |
130478 | 130478 | 95747 | 95747: Roseville | 2022-09-15 | Placer | 61 | 14782 | 59715 | |
131741 | 131741 | 95747 | 95747: Roseville | 2022-09-14 | Placer | 61 | 14782 | 59715 | |
133004 | 133004 | 95747 | 95747: Roseville | 2022-09-13 | Placer | 61 | 14728 | 59715 | |
134267 | 134267 | 95747 | 95747: Roseville | 2022-09-12 | Placer | 61 | 14728 | 59715 | |
135530 | 135530 | 95747 | 95747: Roseville | 2022-09-11 | Placer | 61 | 14728 | 59715 | |
136793 | 136793 | 95747 | 95747: Roseville | 2022-09-10 | Placer | 61 | 14728 | 59715 | |
138056 | 138056 | 95747 | 95747: Roseville | 2022-09-09 | Placer | 61 | 14728 | 59715 | |
139319 | 139319 | 95747 | 95747: Roseville | 2022-09-08 | Placer | 61 | 14728 | 59715 | |
140582 | 140582 | 95747 | 95747: Roseville | 2022-09-07 | Placer | 61 | 14728 | 59715 | |
141845 | 141845 | 95747 | 95747: Roseville | 2022-09-06 | Placer | 61 | 14668 | 59715 | |
143108 | 143108 | 95747 | 95747: Roseville | 2022-09-05 | Placer | 61 | 14668 | 59715 | |
144371 | 144371 | 95747 | 95747: Roseville | 2022-09-04 | Placer | 61 | 14668 | 59715 | |
145634 | 145634 | 95747 | 95747: Roseville | 2022-09-03 | Placer | 61 | 14668 | 59715 | |
146897 | 146897 | 95747 | 95747: Roseville | 2022-09-02 | Placer | 61 | 14668 | 59715 | |
148160 | 148160 | 95747 | 95747: Roseville | 2022-09-01 | Placer | 61 | 14668 | 59715 | |
149423 | 149423 | 95747 | 95747: Roseville | 2022-08-31 | Placer | 61 | 14668 | 59715 | |
150686 | 150686 | 95747 | 95747: Roseville | 2022-08-30 | Placer | 61 | 14606 | 59715 | |
151949 | 151949 | 95747 | 95747: Roseville | 2022-08-29 | Placer | 61 | 14606 | 59715 | |
153212 | 153212 | 95747 | 95747: Roseville | 2022-08-28 | Placer | 61 | 14606 | 59715 | |
154475 | 154475 | 95747 | 95747: Roseville | 2022-08-27 | Placer | 61 | 14606 | 59715 | |
155738 | 155738 | 95747 | 95747: Roseville | 2022-08-26 | Placer | 61 | 14606 | 59715 | |
157001 | 157001 | 95747 | 95747: Roseville | 2022-08-25 | Placer | 61 | 14606 | 59715 | |
158264 | 158264 | 95747 | 95747: Roseville | 2022-08-24 | Placer | 61 | 14606 | 59715 | |
159527 | 159527 | 95747 | 95747: Roseville | 2022-08-23 | Placer | 61 | 14529 | 59715 | |
160790 | 160790 | 95747 | 95747: Roseville | 2022-08-22 | Placer | 61 | 14529 | 59715 | |
162053 | 162053 | 95747 | 95747: Roseville | 2022-08-21 | Placer | 61 | 14529 | 59715 | |
163316 | 163316 | 95747 | 95747: Roseville | 2022-08-20 | Placer | 61 | 14529 | 59715 | |
164579 | 164579 | 95747 | 95747: Roseville | 2022-08-19 | Placer | 61 | 14529 | 59715 | |
165842 | 165842 | 95747 | 95747: Roseville | 2022-08-18 | Placer | 61 | 14529 | 59715 | |
167105 | 167105 | 95747 | 95747: Roseville | 2022-08-17 | Placer | 61 | 14529 | 59715 | |
168368 | 168368 | 95747 | 95747: Roseville | 2022-08-16 | Placer | 61 | 14400 | 59715 | |
169631 | 169631 | 95747 | 95747: Roseville | 2022-08-15 | Placer | 61 | 14400 | 59715 | |
170894 | 170894 | 95747 | 95747: Roseville | 2022-08-14 | Placer | 61 | 14400 | 59715 | |
172157 | 172157 | 95747 | 95747: Roseville | 2022-08-13 | Placer | 61 | 14400 | 59715 | |
173420 | 173420 | 95747 | 95747: Roseville | 2022-08-12 | Placer | 61 | 14400 | 59715 | |
174683 | 174683 | 95747 | 95747: Roseville | 2022-08-11 | Placer | 61 | 14400 | 59715 | |
175946 | 175946 | 95747 | 95747: Roseville | 2022-08-10 | Placer | 61 | 14400 | 59715 | |
177209 | 177209 | 95747 | 95747: Roseville | 2022-08-09 | Placer | 61 | 14281 | 59715 | |
178472 | 178472 | 95747 | 95747: Roseville | 2022-08-08 | Placer | 61 | 14281 | 59715 | |
179735 | 179735 | 95747 | 95747: Roseville | 2022-08-07 | Placer | 61 | 14281 | 59715 | |
180998 | 180998 | 95747 | 95747: Roseville | 2022-08-06 | Placer | 61 | 14281 | 59715 | |
182261 | 182261 | 95747 | 95747: Roseville | 2022-08-05 | Placer | 61 | 14281 | 59715 | |
183524 | 183524 | 95747 | 95747: Roseville | 2022-08-04 | Placer | 61 | 14281 | 59715 | |
184787 | 184787 | 95747 | 95747: Roseville | 2022-08-03 | Placer | 61 | 14281 | 59715 | |
186050 | 186050 | 95747 | 95747: Roseville | 2022-08-02 | Placer | 61 | 14120 | 59715 | |
187313 | 187313 | 95747 | 95747: Roseville | 2022-08-01 | Placer | 61 | 14120 | 59715 | |
188576 | 188576 | 95747 | 95747: Roseville | 2022-07-31 | Placer | 61 | 14120 | 59715 | |
189839 | 189839 | 95747 | 95747: Roseville | 2022-07-30 | Placer | 61 | 14120 | 59715 | |
191102 | 191102 | 95747 | 95747: Roseville | 2022-07-29 | Placer | 61 | 14120 | 59715 | |
192365 | 192365 | 95747 | 95747: Roseville | 2022-07-28 | Placer | 61 | 14120 | 59715 | |
193628 | 193628 | 95747 | 95747: Roseville | 2022-07-27 | Placer | 61 | 14120 | 59715 | |
194891 | 194891 | 95747 | 95747: Roseville | 2022-07-26 | Placer | 61 | 13986 | 59715 | |
196154 | 196154 | 95747 | 95747: Roseville | 2022-07-25 | Placer | 61 | 13986 | 59715 | |
197417 | 197417 | 95747 | 95747: Roseville | 2022-07-24 | Placer | 61 | 13986 | 59715 |
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 );