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

fips

  • 23 · 2,240

county

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