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

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

Suggested facets: x, y, date (date)

place

fips

  • 47 · 1,237 ✖

county

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