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

5,700 rows where fips = 99 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

  • 99 · 5,700 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
1286 1286 Ceres Ceres 2021-10-27 Stanislaus 99 7785   47975
1287 1287 Hughson Hughson 2021-10-27 Stanislaus 99 883   7370
1288 1288 Modesto Modesto 2021-10-27 Stanislaus 99 29379   211336
1289 1289 Newman Newman 2021-10-27 Stanislaus 99 1558   11119
1290 1290 Oakdale Oakdale 2021-10-27 Stanislaus 99 2708   22599
1291 1291 Patterson Patterson 2021-10-27 Stanislaus 99 3289   21783
1292 1292 Riverbank Riverbank 2021-10-27 Stanislaus 99 3554   24237
1293 1293 Turlock Turlock 2021-10-27 Stanislaus 99 10058   72335
1294 1294 Unincorporated districts Other 2021-10-27 Stanislaus 99 13192    
1295 1295 Waterford Waterford 2021-10-27 Stanislaus 99 1069   8823
2651 2651 Ceres Ceres 2021-10-26 Stanislaus 99 7785   47975
2652 2652 Hughson Hughson 2021-10-26 Stanislaus 99 883   7370
2653 2653 Modesto Modesto 2021-10-26 Stanislaus 99 29379   211336
2654 2654 Newman Newman 2021-10-26 Stanislaus 99 1558   11119
2655 2655 Oakdale Oakdale 2021-10-26 Stanislaus 99 2708   22599
2656 2656 Patterson Patterson 2021-10-26 Stanislaus 99 3289   21783
2657 2657 Riverbank Riverbank 2021-10-26 Stanislaus 99 3554   24237
2658 2658 Turlock Turlock 2021-10-26 Stanislaus 99 10058   72335
2659 2659 Unincorporated districts Other 2021-10-26 Stanislaus 99 13192    
2660 2660 Waterford Waterford 2021-10-26 Stanislaus 99 1069   8823
4016 4016 Ceres Ceres 2021-10-25 Stanislaus 99 7772   47975
4017 4017 Hughson Hughson 2021-10-25 Stanislaus 99 883   7370
4018 4018 Modesto Modesto 2021-10-25 Stanislaus 99 29350   211336
4019 4019 Newman Newman 2021-10-25 Stanislaus 99 1558   11119
4020 4020 Oakdale Oakdale 2021-10-25 Stanislaus 99 2708   22599
4021 4021 Patterson Patterson 2021-10-25 Stanislaus 99 3289   21783
4022 4022 Riverbank Riverbank 2021-10-25 Stanislaus 99 3554   24237
4023 4023 Turlock Turlock 2021-10-25 Stanislaus 99 10051   72335
4024 4024 Unincorporated districts Other 2021-10-25 Stanislaus 99 13183    
4025 4025 Waterford Waterford 2021-10-25 Stanislaus 99 1068   8823
5381 5381 Ceres Ceres 2021-10-24 Stanislaus 99 7733   47975
5382 5382 Hughson Hughson 2021-10-24 Stanislaus 99 882   7370
5383 5383 Modesto Modesto 2021-10-24 Stanislaus 99 29242   211336
5384 5384 Newman Newman 2021-10-24 Stanislaus 99 1556   11119
5385 5385 Oakdale Oakdale 2021-10-24 Stanislaus 99 2698   22599
5386 5386 Patterson Patterson 2021-10-24 Stanislaus 99 3286   21783
5387 5387 Riverbank Riverbank 2021-10-24 Stanislaus 99 3541   24237
5388 5388 Turlock Turlock 2021-10-24 Stanislaus 99 10011   72335
5389 5389 Unincorporated districts Other 2021-10-24 Stanislaus 99 13134    
5390 5390 Waterford Waterford 2021-10-24 Stanislaus 99 1061   8823
6746 6746 Ceres Ceres 2021-10-23 Stanislaus 99 7733   47975
6747 6747 Hughson Hughson 2021-10-23 Stanislaus 99 882   7370
6748 6748 Modesto Modesto 2021-10-23 Stanislaus 99 29242   211336
6749 6749 Newman Newman 2021-10-23 Stanislaus 99 1556   11119
6750 6750 Oakdale Oakdale 2021-10-23 Stanislaus 99 2698   22599
6751 6751 Patterson Patterson 2021-10-23 Stanislaus 99 3286   21783
6752 6752 Riverbank Riverbank 2021-10-23 Stanislaus 99 3541   24237
6753 6753 Turlock Turlock 2021-10-23 Stanislaus 99 10011   72335
6754 6754 Unincorporated districts Other 2021-10-23 Stanislaus 99 13134    
6755 6755 Waterford Waterford 2021-10-23 Stanislaus 99 1061   8823
8111 8111 Ceres Ceres 2021-10-22 Stanislaus 99 7625   47975
8112 8112 Hughson Hughson 2021-10-22 Stanislaus 99 873   7370
8113 8113 Modesto Modesto 2021-10-22 Stanislaus 99 28792   211336
8114 8114 Newman Newman 2021-10-22 Stanislaus 99 1531   11119
8115 8115 Oakdale Oakdale 2021-10-22 Stanislaus 99 2637   22599
8116 8116 Patterson Patterson 2021-10-22 Stanislaus 99 3257   21783
8117 8117 Riverbank Riverbank 2021-10-22 Stanislaus 99 3485   24237
8118 8118 Turlock Turlock 2021-10-22 Stanislaus 99 9832   72335
8119 8119 Unincorporated districts Other 2021-10-22 Stanislaus 99 12914    
8120 8120 Waterford Waterford 2021-10-22 Stanislaus 99 1045   8823
9476 9476 Ceres Ceres 2021-10-21 Stanislaus 99 7625   47975
9477 9477 Hughson Hughson 2021-10-21 Stanislaus 99 873   7370
9478 9478 Modesto Modesto 2021-10-21 Stanislaus 99 28792   211336
9479 9479 Newman Newman 2021-10-21 Stanislaus 99 1531   11119
9480 9480 Oakdale Oakdale 2021-10-21 Stanislaus 99 2637   22599
9481 9481 Patterson Patterson 2021-10-21 Stanislaus 99 3257   21783
9482 9482 Riverbank Riverbank 2021-10-21 Stanislaus 99 3485   24237
9483 9483 Turlock Turlock 2021-10-21 Stanislaus 99 9832   72335
9484 9484 Unincorporated districts Other 2021-10-21 Stanislaus 99 12914    
9485 9485 Waterford Waterford 2021-10-21 Stanislaus 99 1045   8823
10841 10841 Ceres Ceres 2021-10-20 Stanislaus 99 7625   47975
10842 10842 Hughson Hughson 2021-10-20 Stanislaus 99 873   7370
10843 10843 Modesto Modesto 2021-10-20 Stanislaus 99 28792   211336
10844 10844 Newman Newman 2021-10-20 Stanislaus 99 1531   11119
10845 10845 Oakdale Oakdale 2021-10-20 Stanislaus 99 2637   22599
10846 10846 Patterson Patterson 2021-10-20 Stanislaus 99 3257   21783
10847 10847 Riverbank Riverbank 2021-10-20 Stanislaus 99 3485   24237
10848 10848 Turlock Turlock 2021-10-20 Stanislaus 99 9832   72335
10849 10849 Unincorporated districts Other 2021-10-20 Stanislaus 99 12914    
10850 10850 Waterford Waterford 2021-10-20 Stanislaus 99 1045   8823
12206 12206 Ceres Ceres 2021-10-19 Stanislaus 99 7625   47975
12207 12207 Hughson Hughson 2021-10-19 Stanislaus 99 873   7370
12208 12208 Modesto Modesto 2021-10-19 Stanislaus 99 28792   211336
12209 12209 Newman Newman 2021-10-19 Stanislaus 99 1531   11119
12210 12210 Oakdale Oakdale 2021-10-19 Stanislaus 99 2637   22599
12211 12211 Patterson Patterson 2021-10-19 Stanislaus 99 3257   21783
12212 12212 Riverbank Riverbank 2021-10-19 Stanislaus 99 3485   24237
12213 12213 Turlock Turlock 2021-10-19 Stanislaus 99 9832   72335
12214 12214 Unincorporated districts Other 2021-10-19 Stanislaus 99 12914    
12215 12215 Waterford Waterford 2021-10-19 Stanislaus 99 1045   8823
13571 13571 Ceres Ceres 2021-10-18 Stanislaus 99 7625   47975
13572 13572 Hughson Hughson 2021-10-18 Stanislaus 99 873   7370
13573 13573 Modesto Modesto 2021-10-18 Stanislaus 99 28792   211336
13574 13574 Newman Newman 2021-10-18 Stanislaus 99 1531   11119
13575 13575 Oakdale Oakdale 2021-10-18 Stanislaus 99 2637   22599
13576 13576 Patterson Patterson 2021-10-18 Stanislaus 99 3257   21783
13577 13577 Riverbank Riverbank 2021-10-18 Stanislaus 99 3485   24237
13578 13578 Turlock Turlock 2021-10-18 Stanislaus 99 9832   72335
13579 13579 Unincorporated districts Other 2021-10-18 Stanislaus 99 12914    
13580 13580 Waterford Waterford 2021-10-18 Stanislaus 99 1045   8823

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