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

13,300 rows where fips = 23 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

  • 23 · 13,300 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
144 144 95501 95501: Eureka 2021-10-27 Humboldt 23 1554   23467
145 145 95503 95503: Eureka 2021-10-27 Humboldt 23 1616   25503
146 146 95511 95511: Alderpoint 2021-10-27 Humboldt 23 17   290
147 147 95514 95514: Blocksburg 2021-10-27 Humboldt 23 5 0 to 5 117
148 148 95519 95519: Mckinleyville 2021-10-27 Humboldt 23 929   19099
149 149 95521 95521: Arcata 2021-10-27 Humboldt 23 1148   21462
150 150 95524 95524: Bayside 2021-10-27 Humboldt 23 97   1724
151 151 95525 95525: Blue Lake 2021-10-27 Humboldt 23 79   1433
152 152 95526 95526: Bridgeville 2021-10-27 Humboldt 23 10   210
153 153 95528 95528: Carlotta 2021-10-27 Humboldt 23 59   1493
154 154 95536 95536: Ferndale 2021-10-27 Humboldt 23 130   2898
155 155 95537 95537: Fields Landing 2021-10-27 Humboldt 23 22   325
156 156 95540 95540: Fortuna 2021-10-27 Humboldt 23 1155   14305
157 157 95542 95542: Garberville 2021-10-27 Humboldt 23 101   2072
158 158 95545 95545: Honeydew 2021-10-27 Humboldt 23 7   101
159 159 95546 95546: Hoopa 2021-10-27 Humboldt 23 465   3768
160 160 95547 95547: Hydesville 2021-10-27 Humboldt 23 89   978
161 161 95549 95549: Kneeland 2021-10-27 Humboldt 23 40   1050
162 162 95550 95550: Korbel 2021-10-27 Humboldt 23 5 0 to 5 71
163 163 95551 95551: Loleta 2021-10-27 Humboldt 23 121   1374
164 164 95553 95553: Miranda 2021-10-27 Humboldt 23 30   913
165 165 95554 95554: Myers Flat 2021-10-27 Humboldt 23 24   287
166 166 95555 95555: Orick 2021-10-27 Humboldt 23 11   337
167 167 95556 95556: Orleans 2021-10-27 Humboldt 23 35   627
168 168 95558 95558: Petrolia 2021-10-27 Humboldt 23 5 0 to 5 423
169 169 95559 95559: Phillipsville 2021-10-27 Humboldt 23 5 0 to 5 72
170 170 95560 95560: Redway 2021-10-27 Humboldt 23 126   1466
171 171 95562 95562: Rio Dell 2021-10-27 Humboldt 23 307   3422
172 172 95564 95564: Samoa 2021-10-27 Humboldt 23 42   432
173 173 95565 95565: Scotia 2021-10-27 Humboldt 23 82   772
174 174 95569 95569: Redcrest 2021-10-27 Humboldt 23 12   295
175 175 95570 95570: Trinidad 2021-10-27 Humboldt 23 84   2274
176 176 95571 95571: Weott 2021-10-27 Humboldt 23 10   271
177 177 95573 95573: Willow Creek 2021-10-27 Humboldt 23 112   1554
178 178 95589 95589: Whitethorn 2021-10-27 Humboldt 23 33   982
1509 1509 95501 95501: Eureka 2021-10-26 Humboldt 23 1554   23467
1510 1510 95503 95503: Eureka 2021-10-26 Humboldt 23 1616   25503
1511 1511 95511 95511: Alderpoint 2021-10-26 Humboldt 23 17   290
1512 1512 95514 95514: Blocksburg 2021-10-26 Humboldt 23 5 0 to 5 117
1513 1513 95519 95519: Mckinleyville 2021-10-26 Humboldt 23 929   19099
1514 1514 95521 95521: Arcata 2021-10-26 Humboldt 23 1148   21462
1515 1515 95524 95524: Bayside 2021-10-26 Humboldt 23 97   1724
1516 1516 95525 95525: Blue Lake 2021-10-26 Humboldt 23 79   1433
1517 1517 95526 95526: Bridgeville 2021-10-26 Humboldt 23 10   210
1518 1518 95528 95528: Carlotta 2021-10-26 Humboldt 23 59   1493
1519 1519 95536 95536: Ferndale 2021-10-26 Humboldt 23 130   2898
1520 1520 95537 95537: Fields Landing 2021-10-26 Humboldt 23 22   325
1521 1521 95540 95540: Fortuna 2021-10-26 Humboldt 23 1155   14305
1522 1522 95542 95542: Garberville 2021-10-26 Humboldt 23 101   2072
1523 1523 95545 95545: Honeydew 2021-10-26 Humboldt 23 7   101
1524 1524 95546 95546: Hoopa 2021-10-26 Humboldt 23 465   3768
1525 1525 95547 95547: Hydesville 2021-10-26 Humboldt 23 89   978
1526 1526 95549 95549: Kneeland 2021-10-26 Humboldt 23 40   1050
1527 1527 95550 95550: Korbel 2021-10-26 Humboldt 23 5 0 to 5 71
1528 1528 95551 95551: Loleta 2021-10-26 Humboldt 23 121   1374
1529 1529 95553 95553: Miranda 2021-10-26 Humboldt 23 30   913
1530 1530 95554 95554: Myers Flat 2021-10-26 Humboldt 23 24   287
1531 1531 95555 95555: Orick 2021-10-26 Humboldt 23 11   337
1532 1532 95556 95556: Orleans 2021-10-26 Humboldt 23 35   627
1533 1533 95558 95558: Petrolia 2021-10-26 Humboldt 23 5 0 to 5 423
1534 1534 95559 95559: Phillipsville 2021-10-26 Humboldt 23 5 0 to 5 72
1535 1535 95560 95560: Redway 2021-10-26 Humboldt 23 126   1466
1536 1536 95562 95562: Rio Dell 2021-10-26 Humboldt 23 307   3422
1537 1537 95564 95564: Samoa 2021-10-26 Humboldt 23 42   432
1538 1538 95565 95565: Scotia 2021-10-26 Humboldt 23 82   772
1539 1539 95569 95569: Redcrest 2021-10-26 Humboldt 23 12   295
1540 1540 95570 95570: Trinidad 2021-10-26 Humboldt 23 84   2274
1541 1541 95571 95571: Weott 2021-10-26 Humboldt 23 10   271
1542 1542 95573 95573: Willow Creek 2021-10-26 Humboldt 23 112   1554
1543 1543 95589 95589: Whitethorn 2021-10-26 Humboldt 23 33   982
2874 2874 95501 95501: Eureka 2021-10-25 Humboldt 23 1554   23467
2875 2875 95503 95503: Eureka 2021-10-25 Humboldt 23 1616   25503
2876 2876 95511 95511: Alderpoint 2021-10-25 Humboldt 23 17   290
2877 2877 95514 95514: Blocksburg 2021-10-25 Humboldt 23 5 0 to 5 117
2878 2878 95519 95519: Mckinleyville 2021-10-25 Humboldt 23 929   19099
2879 2879 95521 95521: Arcata 2021-10-25 Humboldt 23 1148   21462
2880 2880 95524 95524: Bayside 2021-10-25 Humboldt 23 97   1724
2881 2881 95525 95525: Blue Lake 2021-10-25 Humboldt 23 79   1433
2882 2882 95526 95526: Bridgeville 2021-10-25 Humboldt 23 10   210
2883 2883 95528 95528: Carlotta 2021-10-25 Humboldt 23 59   1493
2884 2884 95536 95536: Ferndale 2021-10-25 Humboldt 23 130   2898
2885 2885 95537 95537: Fields Landing 2021-10-25 Humboldt 23 22   325
2886 2886 95540 95540: Fortuna 2021-10-25 Humboldt 23 1155   14305
2887 2887 95542 95542: Garberville 2021-10-25 Humboldt 23 101   2072
2888 2888 95545 95545: Honeydew 2021-10-25 Humboldt 23 7   101
2889 2889 95546 95546: Hoopa 2021-10-25 Humboldt 23 465   3768
2890 2890 95547 95547: Hydesville 2021-10-25 Humboldt 23 89   978
2891 2891 95549 95549: Kneeland 2021-10-25 Humboldt 23 40   1050
2892 2892 95550 95550: Korbel 2021-10-25 Humboldt 23 5 0 to 5 71
2893 2893 95551 95551: Loleta 2021-10-25 Humboldt 23 121   1374
2894 2894 95553 95553: Miranda 2021-10-25 Humboldt 23 30   913
2895 2895 95554 95554: Myers Flat 2021-10-25 Humboldt 23 24   287
2896 2896 95555 95555: Orick 2021-10-25 Humboldt 23 11   337
2897 2897 95556 95556: Orleans 2021-10-25 Humboldt 23 35   627
2898 2898 95558 95558: Petrolia 2021-10-25 Humboldt 23 5 0 to 5 423
2899 2899 95559 95559: Phillipsville 2021-10-25 Humboldt 23 5 0 to 5 72
2900 2900 95560 95560: Redway 2021-10-25 Humboldt 23 126   1466
2901 2901 95562 95562: Rio Dell 2021-10-25 Humboldt 23 307   3422
2902 2902 95564 95564: Samoa 2021-10-25 Humboldt 23 42   432
2903 2903 95565 95565: Scotia 2021-10-25 Humboldt 23 82   772

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
);