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

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

✎ View and edit SQL

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

fips

  • 23 · 6,300 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
142 142 95501 95501: Eureka 2021-04-10 Humboldt 23 684   23467
143 143 95503 95503: Eureka 2021-04-10 Humboldt 23 554   25503
144 144 95511 95511: Alderpoint 2021-04-10 Humboldt 23 6   290
145 145 95514 95514: Blocksburg 2021-04-10 Humboldt 23 5 0 to 5 117
146 146 95519 95519: Mckinleyville 2021-04-10 Humboldt 23 369   19099
147 147 95521 95521: Arcata 2021-04-10 Humboldt 23 600   21462
148 148 95524 95524: Bayside 2021-04-10 Humboldt 23 38   1724
149 149 95525 95525: Blue Lake 2021-04-10 Humboldt 23 36   1433
150 150 95526 95526: Bridgeville 2021-04-10 Humboldt 23 5 0 to 5 210
151 151 95528 95528: Carlotta 2021-04-10 Humboldt 23 13   1493
152 152 95536 95536: Ferndale 2021-04-10 Humboldt 23 48   2898
153 153 95537 95537: Fields Landing 2021-04-10 Humboldt 23 6   325
154 154 95540 95540: Fortuna 2021-04-10 Humboldt 23 417   14305
155 155 95542 95542: Garberville 2021-04-10 Humboldt 23 40   2072
156 156 95545 95545: Honeydew 2021-04-10 Humboldt 23 6   101
157 157 95546 95546: Hoopa 2021-04-10 Humboldt 23 256   3768
158 158 95547 95547: Hydesville 2021-04-10 Humboldt 23 28   978
159 159 95549 95549: Kneeland 2021-04-10 Humboldt 23 18   1050
160 160 95550 95550: Korbel 2021-04-10 Humboldt 23 5 0 to 5 71
161 161 95551 95551: Loleta 2021-04-10 Humboldt 23 44   1374
162 162 95553 95553: Miranda 2021-04-10 Humboldt 23 15   913
163 163 95554 95554: Myers Flat 2021-04-10 Humboldt 23 12   287
164 164 95555 95555: Orick 2021-04-10 Humboldt 23 5 0 to 5 337
165 165 95556 95556: Orleans 2021-04-10 Humboldt 23 11   627
166 166 95558 95558: Petrolia 2021-04-10 Humboldt 23 5 0 to 5 423
167 167 95559 95559: Phillipsville 2021-04-10 Humboldt 23 5 0 to 5 72
168 168 95560 95560: Redway 2021-04-10 Humboldt 23 63   1466
169 169 95562 95562: Rio Dell 2021-04-10 Humboldt 23 89   3422
170 170 95564 95564: Samoa 2021-04-10 Humboldt 23 8   432
171 171 95565 95565: Scotia 2021-04-10 Humboldt 23 26   772
172 172 95569 95569: Redcrest 2021-04-10 Humboldt 23 7   295
173 173 95570 95570: Trinidad 2021-04-10 Humboldt 23 38   2274
174 174 95571 95571: Weott 2021-04-10 Humboldt 23 7   271
175 175 95573 95573: Willow Creek 2021-04-10 Humboldt 23 27   1554
176 176 95589 95589: Whitethorn 2021-04-10 Humboldt 23 7   982
1509 1509 95501 95501: Eureka 2021-04-09 Humboldt 23 684   23467
1510 1510 95503 95503: Eureka 2021-04-09 Humboldt 23 554   25503
1511 1511 95511 95511: Alderpoint 2021-04-09 Humboldt 23 6   290
1512 1512 95514 95514: Blocksburg 2021-04-09 Humboldt 23 5 0 to 5 117
1513 1513 95519 95519: Mckinleyville 2021-04-09 Humboldt 23 369   19099
1514 1514 95521 95521: Arcata 2021-04-09 Humboldt 23 600   21462
1515 1515 95524 95524: Bayside 2021-04-09 Humboldt 23 38   1724
1516 1516 95525 95525: Blue Lake 2021-04-09 Humboldt 23 36   1433
1517 1517 95526 95526: Bridgeville 2021-04-09 Humboldt 23 5 0 to 5 210
1518 1518 95528 95528: Carlotta 2021-04-09 Humboldt 23 13   1493
1519 1519 95536 95536: Ferndale 2021-04-09 Humboldt 23 48   2898
1520 1520 95537 95537: Fields Landing 2021-04-09 Humboldt 23 6   325
1521 1521 95540 95540: Fortuna 2021-04-09 Humboldt 23 417   14305
1522 1522 95542 95542: Garberville 2021-04-09 Humboldt 23 40   2072
1523 1523 95545 95545: Honeydew 2021-04-09 Humboldt 23 6   101
1524 1524 95546 95546: Hoopa 2021-04-09 Humboldt 23 256   3768
1525 1525 95547 95547: Hydesville 2021-04-09 Humboldt 23 28   978
1526 1526 95549 95549: Kneeland 2021-04-09 Humboldt 23 18   1050
1527 1527 95550 95550: Korbel 2021-04-09 Humboldt 23 5 0 to 5 71
1528 1528 95551 95551: Loleta 2021-04-09 Humboldt 23 44   1374
1529 1529 95553 95553: Miranda 2021-04-09 Humboldt 23 15   913
1530 1530 95554 95554: Myers Flat 2021-04-09 Humboldt 23 12   287
1531 1531 95555 95555: Orick 2021-04-09 Humboldt 23 5 0 to 5 337
1532 1532 95556 95556: Orleans 2021-04-09 Humboldt 23 11   627
1533 1533 95558 95558: Petrolia 2021-04-09 Humboldt 23 5 0 to 5 423
1534 1534 95559 95559: Phillipsville 2021-04-09 Humboldt 23 5 0 to 5 72
1535 1535 95560 95560: Redway 2021-04-09 Humboldt 23 63   1466
1536 1536 95562 95562: Rio Dell 2021-04-09 Humboldt 23 89   3422
1537 1537 95564 95564: Samoa 2021-04-09 Humboldt 23 8   432
1538 1538 95565 95565: Scotia 2021-04-09 Humboldt 23 26   772
1539 1539 95569 95569: Redcrest 2021-04-09 Humboldt 23 7   295
1540 1540 95570 95570: Trinidad 2021-04-09 Humboldt 23 38   2274
1541 1541 95571 95571: Weott 2021-04-09 Humboldt 23 7   271
1542 1542 95573 95573: Willow Creek 2021-04-09 Humboldt 23 27   1554
1543 1543 95589 95589: Whitethorn 2021-04-09 Humboldt 23 7   982
2876 2876 95501 95501: Eureka 2021-04-08 Humboldt 23 684   23467
2877 2877 95503 95503: Eureka 2021-04-08 Humboldt 23 554   25503
2878 2878 95511 95511: Alderpoint 2021-04-08 Humboldt 23 6   290
2879 2879 95514 95514: Blocksburg 2021-04-08 Humboldt 23 5 0 to 5 117
2880 2880 95519 95519: Mckinleyville 2021-04-08 Humboldt 23 369   19099
2881 2881 95521 95521: Arcata 2021-04-08 Humboldt 23 600   21462
2882 2882 95524 95524: Bayside 2021-04-08 Humboldt 23 38   1724
2883 2883 95525 95525: Blue Lake 2021-04-08 Humboldt 23 36   1433
2884 2884 95526 95526: Bridgeville 2021-04-08 Humboldt 23 5 0 to 5 210
2885 2885 95528 95528: Carlotta 2021-04-08 Humboldt 23 13   1493
2886 2886 95536 95536: Ferndale 2021-04-08 Humboldt 23 48   2898
2887 2887 95537 95537: Fields Landing 2021-04-08 Humboldt 23 6   325
2888 2888 95540 95540: Fortuna 2021-04-08 Humboldt 23 417   14305
2889 2889 95542 95542: Garberville 2021-04-08 Humboldt 23 40   2072
2890 2890 95545 95545: Honeydew 2021-04-08 Humboldt 23 6   101
2891 2891 95546 95546: Hoopa 2021-04-08 Humboldt 23 256   3768
2892 2892 95547 95547: Hydesville 2021-04-08 Humboldt 23 28   978
2893 2893 95549 95549: Kneeland 2021-04-08 Humboldt 23 18   1050
2894 2894 95550 95550: Korbel 2021-04-08 Humboldt 23 5 0 to 5 71
2895 2895 95551 95551: Loleta 2021-04-08 Humboldt 23 44   1374
2896 2896 95553 95553: Miranda 2021-04-08 Humboldt 23 15   913
2897 2897 95554 95554: Myers Flat 2021-04-08 Humboldt 23 12   287
2898 2898 95555 95555: Orick 2021-04-08 Humboldt 23 5 0 to 5 337
2899 2899 95556 95556: Orleans 2021-04-08 Humboldt 23 11   627
2900 2900 95558 95558: Petrolia 2021-04-08 Humboldt 23 5 0 to 5 423
2901 2901 95559 95559: Phillipsville 2021-04-08 Humboldt 23 5 0 to 5 72
2902 2902 95560 95560: Redway 2021-04-08 Humboldt 23 63   1466
2903 2903 95562 95562: Rio Dell 2021-04-08 Humboldt 23 89   3422
2904 2904 95564 95564: Samoa 2021-04-08 Humboldt 23 8   432
2905 2905 95565 95565: Scotia 2021-04-08 Humboldt 23 26   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
);