latimes_place_totals

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

1,237 rows where fips = 47 sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

place

fips

  • 47 · 1,237

county

Link rowid date ▲ county fips place confirmed_cases note x y
567 2020-10-30 Merced 47 Atwater 1405   -120.609167 37.347778
568 2020-10-30 Merced 47 Delhi 645   -120.778611 37.432222
569 2020-10-30 Merced 47 Dos Palos 288   -120.633333 36.983333
570 2020-10-30 Merced 47 Gustine 252   -120.998889 37.257778
571 2020-10-30 Merced 47 Hilmar 223   -120.850278 37.408611
572 2020-10-30 Merced 47 Le Grand Planada 264   -120.248333 37.228611
573 2020-10-30 Merced 47 Livingston 954   -120.723611 37.386944
574 2020-10-30 Merced 47 Los Banos 1215   -120.85 37.058333
575 2020-10-30 Merced 47 Merced 3528   -120.483333 37.3
576 2020-10-30 Merced 47 Winton 634   -120.613333 37.388333
1560 2020-10-29 Merced 47 Atwater 1401   -120.609167 37.347778
1561 2020-10-29 Merced 47 Delhi 643   -120.778611 37.432222
1562 2020-10-29 Merced 47 Dos Palos 287   -120.633333 36.983333
1563 2020-10-29 Merced 47 Gustine 251   -120.998889 37.257778
1564 2020-10-29 Merced 47 Hilmar 221   -120.850278 37.408611
1565 2020-10-29 Merced 47 Le Grand Planada 256   -120.248333 37.228611
1566 2020-10-29 Merced 47 Livingston 952   -120.723611 37.386944
1567 2020-10-29 Merced 47 Los Banos 1206   -120.85 37.058333
1568 2020-10-29 Merced 47 Merced 3522   -120.483333 37.3
1569 2020-10-29 Merced 47 Winton 634   -120.613333 37.388333
2561 2020-10-28 Merced 47 Atwater 1398   -120.609167 37.347778
2562 2020-10-28 Merced 47 Delhi 643   -120.778611 37.432222
2563 2020-10-28 Merced 47 Dos Palos 287   -120.633333 36.983333
2564 2020-10-28 Merced 47 Gustine 249   -120.998889 37.257778
2565 2020-10-28 Merced 47 Hilmar 221   -120.850278 37.408611
2566 2020-10-28 Merced 47 Le Grand Planada 252   -120.248333 37.228611
2567 2020-10-28 Merced 47 Livingston 947   -120.723611 37.386944
2568 2020-10-28 Merced 47 Los Banos 1203   -120.85 37.058333
2569 2020-10-28 Merced 47 Merced 3500   -120.483333 37.3
2570 2020-10-28 Merced 47 Winton 632   -120.613333 37.388333
3517 2020-10-27 Merced 47 Atwater 1390   -120.609167 37.347778
3518 2020-10-27 Merced 47 Delhi 641   -120.778611 37.432222
3519 2020-10-27 Merced 47 Dos Palos 287   -120.633333 36.983333
3520 2020-10-27 Merced 47 Gustine 249   -120.998889 37.257778
3521 2020-10-27 Merced 47 Hilmar 221   -120.850278 37.408611
3522 2020-10-27 Merced 47 Le Grand Planada 251   -120.248333 37.228611
3523 2020-10-27 Merced 47 Livingston 946   -120.723611 37.386944
3524 2020-10-27 Merced 47 Los Banos 1200   -120.85 37.058333
3525 2020-10-27 Merced 47 Merced 3490   -120.483333 37.3
3526 2020-10-27 Merced 47 Winton 630   -120.613333 37.388333
4479 2020-10-26 Merced 47 Atwater 1377   -120.609167 37.347778
4480 2020-10-26 Merced 47 Delhi 640   -120.778611 37.432222
4481 2020-10-26 Merced 47 Dos Palos 287   -120.633333 36.983333
4482 2020-10-26 Merced 47 Gustine 249   -120.998889 37.257778
4483 2020-10-26 Merced 47 Hilmar 221   -120.850278 37.408611
4484 2020-10-26 Merced 47 Le Grand Planada 249   -120.248333 37.228611
4485 2020-10-26 Merced 47 Livingston 941   -120.723611 37.386944
4486 2020-10-26 Merced 47 Los Banos 1199   -120.85 37.058333
4487 2020-10-26 Merced 47 Merced 3481   -120.483333 37.3
4488 2020-10-26 Merced 47 Winton 630   -120.613333 37.388333
6761 2020-10-23 Merced 47 Atwater 1370   -120.609167 37.347778
6762 2020-10-23 Merced 47 Delhi 638   -120.778611 37.432222
6763 2020-10-23 Merced 47 Dos Palos 283   -120.633333 36.983333
6764 2020-10-23 Merced 47 Gustine 247   -120.998889 37.257778
6765 2020-10-23 Merced 47 Hilmar 220   -120.850278 37.408611
6766 2020-10-23 Merced 47 Le Grand Planada 247   -120.248333 37.228611
6767 2020-10-23 Merced 47 Livingston 938   -120.723611 37.386944
6768 2020-10-23 Merced 47 Los Banos 1192   -120.85 37.058333
6769 2020-10-23 Merced 47 Merced 3453   -120.483333 37.3
6770 2020-10-23 Merced 47 Winton 629   -120.613333 37.388333
7784 2020-10-22 Merced 47 Atwater 1366   -120.609167 37.347778
7785 2020-10-22 Merced 47 Delhi 634   -120.778611 37.432222
7786 2020-10-22 Merced 47 Dos Palos 282   -120.633333 36.983333
7787 2020-10-22 Merced 47 Gustine 245   -120.998889 37.257778
7788 2020-10-22 Merced 47 Hilmar 220   -120.850278 37.408611
7789 2020-10-22 Merced 47 Le Grand Planada 246   -120.248333 37.228611
7790 2020-10-22 Merced 47 Livingston 937   -120.723611 37.386944
7791 2020-10-22 Merced 47 Los Banos 1192   -120.85 37.058333
7792 2020-10-22 Merced 47 Merced 3443   -120.483333 37.3
7793 2020-10-22 Merced 47 Winton 629   -120.613333 37.388333
8736 2020-10-21 Merced 47 Atwater 1360   -120.609167 37.347778
8737 2020-10-21 Merced 47 Delhi 627   -120.778611 37.432222
8738 2020-10-21 Merced 47 Dos Palos 282   -120.633333 36.983333
8739 2020-10-21 Merced 47 Gustine 243   -120.998889 37.257778
8740 2020-10-21 Merced 47 Hilmar 220   -120.850278 37.408611
8741 2020-10-21 Merced 47 Le Grand Planada 245   -120.248333 37.228611
8742 2020-10-21 Merced 47 Livingston 937   -120.723611 37.386944
8743 2020-10-21 Merced 47 Los Banos 1190   -120.85 37.058333
8744 2020-10-21 Merced 47 Merced 3420   -120.483333 37.3
8745 2020-10-21 Merced 47 Winton 629   -120.613333 37.388333
9755 2020-10-20 Merced 47 Atwater 1356   -120.609167 37.347778
9756 2020-10-20 Merced 47 Delhi 626   -120.778611 37.432222
9757 2020-10-20 Merced 47 Dos Palos 280   -120.633333 36.983333
9758 2020-10-20 Merced 47 Gustine 242   -120.998889 37.257778
9759 2020-10-20 Merced 47 Hilmar 220   -120.850278 37.408611
9760 2020-10-20 Merced 47 Le Grand Planada 245   -120.248333 37.228611
9761 2020-10-20 Merced 47 Livingston 936   -120.723611 37.386944
9762 2020-10-20 Merced 47 Los Banos 1188   -120.85 37.058333
9763 2020-10-20 Merced 47 Merced 3417   -120.483333 37.3
9764 2020-10-20 Merced 47 Winton 628   -120.613333 37.388333
10705 2020-10-19 Merced 47 Atwater 1354   -120.609167 37.347778
10706 2020-10-19 Merced 47 Delhi 619   -120.778611 37.432222
10707 2020-10-19 Merced 47 Dos Palos 280   -120.633333 36.983333
10708 2020-10-19 Merced 47 Gustine 241   -120.998889 37.257778
10709 2020-10-19 Merced 47 Hilmar 220   -120.850278 37.408611
10710 2020-10-19 Merced 47 Le Grand Planada 245   -120.248333 37.228611
10711 2020-10-19 Merced 47 Livingston 935   -120.723611 37.386944
10712 2020-10-19 Merced 47 Los Banos 1188   -120.85 37.058333
10713 2020-10-19 Merced 47 Merced 3414   -120.483333 37.3
10714 2020-10-19 Merced 47 Winton 628   -120.613333 37.388333

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
);
Powered by Datasette · Query took 820.529ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals