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

2,240 rows where fips = 23 sorted by date descending

✎ View and edit SQL

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

fips

  • 23 · 2,240 ✖

county

Link rowid date ▲ county fips place confirmed_cases note x y population
105 105 2021-01-27 Humboldt 23 95501: Eureka 522   -124.16102 40.793739 23467
106 106 2021-01-27 Humboldt 23 95503: Eureka 444   -124.1513 40.757091 25503
107 107 2021-01-27 Humboldt 23 95511: Alderpoint 5 0 to 5 -123.60216 40.169518 290
108 108 2021-01-27 Humboldt 23 95514: Blocksburg 5 0 to 5 -123.69266 40.325767 117
109 109 2021-01-27 Humboldt 23 95519: Mckinleyville 282   -124.07286 40.963482 19099
110 110 2021-01-27 Humboldt 23 95521: Arcata 489   -124.07519 40.867469 21462
111 111 2021-01-27 Humboldt 23 95524: Bayside 34   -124.06711 40.822884 1724
112 112 2021-01-27 Humboldt 23 95525: Blue Lake 22   -123.88348 40.907437 1433
113 113 2021-01-27 Humboldt 23 95526: Bridgeville 5 0 to 5 -123.53267 40.413386 210
114 114 2021-01-27 Humboldt 23 95528: Carlotta 11   -123.97132 40.489925 1493
115 115 2021-01-27 Humboldt 23 95536: Ferndale 41   -124.25781 40.561448 2898
116 116 2021-01-27 Humboldt 23 95537: Fields Landing 6   -124.21697 40.725444 325
117 117 2021-01-27 Humboldt 23 95540: Fortuna 280   -124.14367 40.583488 14305
118 118 2021-01-27 Humboldt 23 95542: Garberville 37   -123.80654 40.0985 2072
119 119 2021-01-27 Humboldt 23 95545: Honeydew 6   -124.08998 40.281369 101
120 120 2021-01-27 Humboldt 23 95546: Hoopa 145   -123.72444 41.161505 3768
121 121 2021-01-27 Humboldt 23 95547: Hydesville 19   -124.08412 40.546202 978
122 122 2021-01-27 Humboldt 23 95549: Kneeland 17   -123.87189 40.691578 1050
123 123 2021-01-27 Humboldt 23 95550: Korbel 5 0 to 5 -123.83488 40.766645 71
124 124 2021-01-27 Humboldt 23 95551: Loleta 40   -124.22153 40.659753 1374
125 125 2021-01-27 Humboldt 23 95553: Miranda 15   -123.86447 40.210793 913
126 126 2021-01-27 Humboldt 23 95554: Myers Flat 8   -123.77902 40.2959 287
127 127 2021-01-27 Humboldt 23 95555: Orick 5 0 to 5 -124.05351 41.296122 337
128 128 2021-01-27 Humboldt 23 95556: Orleans 6   -123.54411 41.300573 627
129 129 2021-01-27 Humboldt 23 95558: Petrolia 5 0 to 5 -124.21494 40.272963 423
130 130 2021-01-27 Humboldt 23 95559: Phillipsville 5 0 to 5 -123.77315 40.196116 72
131 131 2021-01-27 Humboldt 23 95560: Redway 56   -123.85855 40.131417 1466
132 132 2021-01-27 Humboldt 23 95562: Rio Dell 56   -124.11637 40.494813 3422
133 133 2021-01-27 Humboldt 23 95564: Samoa 7   -124.19929 40.79348 432
134 134 2021-01-27 Humboldt 23 95565: Scotia 15   -124.06059 40.459978 772
135 135 2021-01-27 Humboldt 23 95569: Redcrest 5 0 to 5 -123.87105 40.35983 295
136 136 2021-01-27 Humboldt 23 95570: Trinidad 22   -124.13112 41.081726 2274
137 137 2021-01-27 Humboldt 23 95571: Weott 5 0 to 5 -123.92367 40.322683 271
138 138 2021-01-27 Humboldt 23 95573: Willow Creek 19   -123.65806 40.945039 1554
139 139 2021-01-27 Humboldt 23 95589: Whitethorn 6   -124.02379 40.033316 982
1438 1438 2021-01-26 Humboldt 23 95501: Eureka 522   -124.16102 40.793739 23467
1439 1439 2021-01-26 Humboldt 23 95503: Eureka 444   -124.1513 40.757091 25503
1440 1440 2021-01-26 Humboldt 23 95511: Alderpoint 5 0 to 5 -123.60216 40.169518 290
1441 1441 2021-01-26 Humboldt 23 95514: Blocksburg 5 0 to 5 -123.69266 40.325767 117
1442 1442 2021-01-26 Humboldt 23 95519: Mckinleyville 282   -124.07286 40.963482 19099
1443 1443 2021-01-26 Humboldt 23 95521: Arcata 489   -124.07519 40.867469 21462
1444 1444 2021-01-26 Humboldt 23 95524: Bayside 34   -124.06711 40.822884 1724
1445 1445 2021-01-26 Humboldt 23 95525: Blue Lake 22   -123.88348 40.907437 1433
1446 1446 2021-01-26 Humboldt 23 95526: Bridgeville 5 0 to 5 -123.53267 40.413386 210
1447 1447 2021-01-26 Humboldt 23 95528: Carlotta 11   -123.97132 40.489925 1493
1448 1448 2021-01-26 Humboldt 23 95536: Ferndale 41   -124.25781 40.561448 2898
1449 1449 2021-01-26 Humboldt 23 95537: Fields Landing 6   -124.21697 40.725444 325
1450 1450 2021-01-26 Humboldt 23 95540: Fortuna 280   -124.14367 40.583488 14305
1451 1451 2021-01-26 Humboldt 23 95542: Garberville 37   -123.80654 40.0985 2072
1452 1452 2021-01-26 Humboldt 23 95545: Honeydew 6   -124.08998 40.281369 101
1453 1453 2021-01-26 Humboldt 23 95546: Hoopa 145   -123.72444 41.161505 3768
1454 1454 2021-01-26 Humboldt 23 95547: Hydesville 19   -124.08412 40.546202 978
1455 1455 2021-01-26 Humboldt 23 95549: Kneeland 17   -123.87189 40.691578 1050
1456 1456 2021-01-26 Humboldt 23 95550: Korbel 5 0 to 5 -123.83488 40.766645 71
1457 1457 2021-01-26 Humboldt 23 95551: Loleta 40   -124.22153 40.659753 1374
1458 1458 2021-01-26 Humboldt 23 95553: Miranda 15   -123.86447 40.210793 913
1459 1459 2021-01-26 Humboldt 23 95554: Myers Flat 8   -123.77902 40.2959 287
1460 1460 2021-01-26 Humboldt 23 95555: Orick 5 0 to 5 -124.05351 41.296122 337
1461 1461 2021-01-26 Humboldt 23 95556: Orleans 6   -123.54411 41.300573 627
1462 1462 2021-01-26 Humboldt 23 95558: Petrolia 5 0 to 5 -124.21494 40.272963 423
1463 1463 2021-01-26 Humboldt 23 95559: Phillipsville 5 0 to 5 -123.77315 40.196116 72
1464 1464 2021-01-26 Humboldt 23 95560: Redway 56   -123.85855 40.131417 1466
1465 1465 2021-01-26 Humboldt 23 95562: Rio Dell 56   -124.11637 40.494813 3422
1466 1466 2021-01-26 Humboldt 23 95564: Samoa 7   -124.19929 40.79348 432
1467 1467 2021-01-26 Humboldt 23 95565: Scotia 15   -124.06059 40.459978 772
1468 1468 2021-01-26 Humboldt 23 95569: Redcrest 5 0 to 5 -123.87105 40.35983 295
1469 1469 2021-01-26 Humboldt 23 95570: Trinidad 22   -124.13112 41.081726 2274
1470 1470 2021-01-26 Humboldt 23 95571: Weott 5 0 to 5 -123.92367 40.322683 271
1471 1471 2021-01-26 Humboldt 23 95573: Willow Creek 19   -123.65806 40.945039 1554
1472 1472 2021-01-26 Humboldt 23 95589: Whitethorn 6   -124.02379 40.033316 982
2779 2779 2021-01-25 Humboldt 23 95501: Eureka 522   -124.16102 40.793739 23467
2780 2780 2021-01-25 Humboldt 23 95503: Eureka 444   -124.1513 40.757091 25503
2781 2781 2021-01-25 Humboldt 23 95511: Alderpoint 5 0 to 5 -123.60216 40.169518 290
2782 2782 2021-01-25 Humboldt 23 95514: Blocksburg 5 0 to 5 -123.69266 40.325767 117
2783 2783 2021-01-25 Humboldt 23 95519: Mckinleyville 282   -124.07286 40.963482 19099
2784 2784 2021-01-25 Humboldt 23 95521: Arcata 489   -124.07519 40.867469 21462
2785 2785 2021-01-25 Humboldt 23 95524: Bayside 34   -124.06711 40.822884 1724
2786 2786 2021-01-25 Humboldt 23 95525: Blue Lake 22   -123.88348 40.907437 1433
2787 2787 2021-01-25 Humboldt 23 95526: Bridgeville 5 0 to 5 -123.53267 40.413386 210
2788 2788 2021-01-25 Humboldt 23 95528: Carlotta 11   -123.97132 40.489925 1493
2789 2789 2021-01-25 Humboldt 23 95536: Ferndale 41   -124.25781 40.561448 2898
2790 2790 2021-01-25 Humboldt 23 95537: Fields Landing 6   -124.21697 40.725444 325
2791 2791 2021-01-25 Humboldt 23 95540: Fortuna 280   -124.14367 40.583488 14305
2792 2792 2021-01-25 Humboldt 23 95542: Garberville 37   -123.80654 40.0985 2072
2793 2793 2021-01-25 Humboldt 23 95545: Honeydew 6   -124.08998 40.281369 101
2794 2794 2021-01-25 Humboldt 23 95546: Hoopa 145   -123.72444 41.161505 3768
2795 2795 2021-01-25 Humboldt 23 95547: Hydesville 19   -124.08412 40.546202 978
2796 2796 2021-01-25 Humboldt 23 95549: Kneeland 17   -123.87189 40.691578 1050
2797 2797 2021-01-25 Humboldt 23 95550: Korbel 5 0 to 5 -123.83488 40.766645 71
2798 2798 2021-01-25 Humboldt 23 95551: Loleta 40   -124.22153 40.659753 1374
2799 2799 2021-01-25 Humboldt 23 95553: Miranda 15   -123.86447 40.210793 913
2800 2800 2021-01-25 Humboldt 23 95554: Myers Flat 8   -123.77902 40.2959 287
2801 2801 2021-01-25 Humboldt 23 95555: Orick 5 0 to 5 -124.05351 41.296122 337
2802 2802 2021-01-25 Humboldt 23 95556: Orleans 6   -123.54411 41.300573 627
2803 2803 2021-01-25 Humboldt 23 95558: Petrolia 5 0 to 5 -124.21494 40.272963 423
2804 2804 2021-01-25 Humboldt 23 95559: Phillipsville 5 0 to 5 -123.77315 40.196116 72
2805 2805 2021-01-25 Humboldt 23 95560: Redway 56   -123.85855 40.131417 1466
2806 2806 2021-01-25 Humboldt 23 95562: Rio Dell 56   -124.11637 40.494813 3422
2807 2807 2021-01-25 Humboldt 23 95564: Samoa 7   -124.19929 40.79348 432
2808 2808 2021-01-25 Humboldt 23 95565: Scotia 15   -124.06059 40.459978 772

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,
   [population] TEXT
);