latimes_place_totals

Table actions
⚠️ 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

12,045 rows where county = "Lake" and fips = 33 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 1

  • 33 · 12,045 ✖

county 1

  • Lake · 12,045 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
158 158 95422 95422 2022-12-30 Lake 33 2851   15550
159 159 95423 95423 2022-12-30 Lake 33 492   3757
160 160 95424 95424 2022-12-30 Lake 33 49   0
161 161 95426 95426 2022-12-30 Lake 33 159   1404
162 162 95435 95435 2022-12-30 Lake 33 69   14
163 163 95443 95443 2022-12-30 Lake 33 24   270
164 164 95451 95451 2022-12-30 Lake 33 1997   11627
165 165 95453 95453 2022-12-30 Lake 33 2575   11092
166 166 95457 95457 2022-12-30 Lake 33 530   3330
167 167 95458 95458 2022-12-30 Lake 33 524   3019
168 168 95461 95461 2022-12-30 Lake 33 389   2440
169 169 95464 95464 2022-12-30 Lake 33 471   2538
170 170 95467 95467 2022-12-30 Lake 33 705   6044
171 171 95485 95485 2022-12-30 Lake 33 495   2688
172 172 95493 95493 2022-12-30 Lake 33 19   241
986 986 95422 95422 2022-12-29 Lake 33 2851   15550
987 987 95423 95423 2022-12-29 Lake 33 492   3757
988 988 95424 95424 2022-12-29 Lake 33 49   0
989 989 95426 95426 2022-12-29 Lake 33 159   1404
990 990 95435 95435 2022-12-29 Lake 33 69   14
991 991 95443 95443 2022-12-29 Lake 33 24   270
992 992 95451 95451 2022-12-29 Lake 33 1997   11627
993 993 95453 95453 2022-12-29 Lake 33 2575   11092
994 994 95457 95457 2022-12-29 Lake 33 530   3330
995 995 95458 95458 2022-12-29 Lake 33 524   3019
996 996 95461 95461 2022-12-29 Lake 33 389   2440
997 997 95464 95464 2022-12-29 Lake 33 471   2538
998 998 95467 95467 2022-12-29 Lake 33 705   6044
999 999 95485 95485 2022-12-29 Lake 33 495   2688
1000 1000 95493 95493 2022-12-29 Lake 33 19   241
1814 1814 95422 95422 2022-12-28 Lake 33 2851   15550
1815 1815 95423 95423 2022-12-28 Lake 33 492   3757
1816 1816 95424 95424 2022-12-28 Lake 33 49   0
1817 1817 95426 95426 2022-12-28 Lake 33 159   1404
1818 1818 95435 95435 2022-12-28 Lake 33 69   14
1819 1819 95443 95443 2022-12-28 Lake 33 24   270
1820 1820 95451 95451 2022-12-28 Lake 33 1997   11627
1821 1821 95453 95453 2022-12-28 Lake 33 2575   11092
1822 1822 95457 95457 2022-12-28 Lake 33 530   3330
1823 1823 95458 95458 2022-12-28 Lake 33 524   3019
1824 1824 95461 95461 2022-12-28 Lake 33 389   2440
1825 1825 95464 95464 2022-12-28 Lake 33 471   2538
1826 1826 95467 95467 2022-12-28 Lake 33 705   6044
1827 1827 95485 95485 2022-12-28 Lake 33 495   2688
1828 1828 95493 95493 2022-12-28 Lake 33 19   241
2995 2995 95422 95422 2022-12-27 Lake 33 2851   15550
2996 2996 95423 95423 2022-12-27 Lake 33 492   3757
2997 2997 95424 95424 2022-12-27 Lake 33 49   0
2998 2998 95426 95426 2022-12-27 Lake 33 159   1404
2999 2999 95435 95435 2022-12-27 Lake 33 69   14
3000 3000 95443 95443 2022-12-27 Lake 33 24   270
3001 3001 95451 95451 2022-12-27 Lake 33 1997   11627
3002 3002 95453 95453 2022-12-27 Lake 33 2575   11092
3003 3003 95457 95457 2022-12-27 Lake 33 530   3330
3004 3004 95458 95458 2022-12-27 Lake 33 524   3019
3005 3005 95461 95461 2022-12-27 Lake 33 389   2440
3006 3006 95464 95464 2022-12-27 Lake 33 471   2538
3007 3007 95467 95467 2022-12-27 Lake 33 705   6044
3008 3008 95485 95485 2022-12-27 Lake 33 495   2688
3009 3009 95493 95493 2022-12-27 Lake 33 19   241
4176 4176 95422 95422 2022-12-26 Lake 33 2851   15550
4177 4177 95423 95423 2022-12-26 Lake 33 492   3757
4178 4178 95424 95424 2022-12-26 Lake 33 49   0
4179 4179 95426 95426 2022-12-26 Lake 33 159   1404
4180 4180 95435 95435 2022-12-26 Lake 33 69   14
4181 4181 95443 95443 2022-12-26 Lake 33 24   270
4182 4182 95451 95451 2022-12-26 Lake 33 1997   11627
4183 4183 95453 95453 2022-12-26 Lake 33 2575   11092
4184 4184 95457 95457 2022-12-26 Lake 33 530   3330
4185 4185 95458 95458 2022-12-26 Lake 33 524   3019
4186 4186 95461 95461 2022-12-26 Lake 33 389   2440
4187 4187 95464 95464 2022-12-26 Lake 33 471   2538
4188 4188 95467 95467 2022-12-26 Lake 33 705   6044
4189 4189 95485 95485 2022-12-26 Lake 33 495   2688
4190 4190 95493 95493 2022-12-26 Lake 33 19   241
5357 5357 95422 95422 2022-12-25 Lake 33 2851   15550
5358 5358 95423 95423 2022-12-25 Lake 33 492   3757
5359 5359 95424 95424 2022-12-25 Lake 33 49   0
5360 5360 95426 95426 2022-12-25 Lake 33 159   1404
5361 5361 95435 95435 2022-12-25 Lake 33 69   14
5362 5362 95443 95443 2022-12-25 Lake 33 24   270
5363 5363 95451 95451 2022-12-25 Lake 33 1997   11627
5364 5364 95453 95453 2022-12-25 Lake 33 2575   11092
5365 5365 95457 95457 2022-12-25 Lake 33 530   3330
5366 5366 95458 95458 2022-12-25 Lake 33 524   3019
5367 5367 95461 95461 2022-12-25 Lake 33 389   2440
5368 5368 95464 95464 2022-12-25 Lake 33 471   2538
5369 5369 95467 95467 2022-12-25 Lake 33 705   6044
5370 5370 95485 95485 2022-12-25 Lake 33 495   2688
5371 5371 95493 95493 2022-12-25 Lake 33 19   241
6538 6538 95422 95422 2022-12-24 Lake 33 2851   15550
6539 6539 95423 95423 2022-12-24 Lake 33 492   3757
6540 6540 95424 95424 2022-12-24 Lake 33 49   0
6541 6541 95426 95426 2022-12-24 Lake 33 159   1404
6542 6542 95435 95435 2022-12-24 Lake 33 69   14
6543 6543 95443 95443 2022-12-24 Lake 33 24   270
6544 6544 95451 95451 2022-12-24 Lake 33 1997   11627
6545 6545 95453 95453 2022-12-24 Lake 33 2575   11092
6546 6546 95457 95457 2022-12-24 Lake 33 530   3330
6547 6547 95458 95458 2022-12-24 Lake 33 524   3019

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);