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

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

View and edit SQL

fips

  • 99 · 3,700

county

Link rowid id name date ▲ county fips confirmed_cases note population
1288 Ceres Ceres 2021-04-10 Stanislaus 99 5407   47975
1289 Hughson Hughson 2021-04-10 Stanislaus 99 581   7370
1290 Modesto Modesto 2021-04-10 Stanislaus 99 19999   211336
1291 Newman Newman 2021-04-10 Stanislaus 99 1185   11119
1292 Oakdale Oakdale 2021-04-10 Stanislaus 99 1794   22599
1293 Patterson Patterson 2021-04-10 Stanislaus 99 2558   21783
1294 Riverbank Riverbank 2021-04-10 Stanislaus 99 2489   24237
1295 Turlock Turlock 2021-04-10 Stanislaus 99 7214   72335
1296 Unincorporated districts Other 2021-04-10 Stanislaus 99 9293    
1297 Waterford Waterford 2021-04-10 Stanislaus 99 641   8823
2655 Ceres Ceres 2021-04-09 Stanislaus 99 5399   47975
2656 Hughson Hughson 2021-04-09 Stanislaus 99 580   7370
2657 Modesto Modesto 2021-04-09 Stanislaus 99 19952   211336
2658 Newman Newman 2021-04-09 Stanislaus 99 1183   11119
2659 Oakdale Oakdale 2021-04-09 Stanislaus 99 1790   22599
2660 Patterson Patterson 2021-04-09 Stanislaus 99 2559   21783
2661 Riverbank Riverbank 2021-04-09 Stanislaus 99 2484   24237
2662 Turlock Turlock 2021-04-09 Stanislaus 99 7203   72335
2663 Unincorporated districts Other 2021-04-09 Stanislaus 99 9279    
2664 Waterford Waterford 2021-04-09 Stanislaus 99 639   8823
4025 Ceres Ceres 2021-04-08 Stanislaus 99 5394   47975
4026 Hughson Hughson 2021-04-08 Stanislaus 99 579   7370
4027 Modesto Modesto 2021-04-08 Stanislaus 99 19894   211336
4028 Newman Newman 2021-04-08 Stanislaus 99 1181   11119
4029 Oakdale Oakdale 2021-04-08 Stanislaus 99 1785   22599
4030 Patterson Patterson 2021-04-08 Stanislaus 99 2555   21783
4031 Riverbank Riverbank 2021-04-08 Stanislaus 99 2482   24237
4032 Turlock Turlock 2021-04-08 Stanislaus 99 7189   72335
4033 Unincorporated districts Other 2021-04-08 Stanislaus 99 9270    
4034 Waterford Waterford 2021-04-08 Stanislaus 99 637   8823
5397 Ceres Ceres 2021-04-07 Stanislaus 99 5393   47975
5398 Hughson Hughson 2021-04-07 Stanislaus 99 578   7370
5399 Modesto Modesto 2021-04-07 Stanislaus 99 19876   211336
5400 Newman Newman 2021-04-07 Stanislaus 99 1179   11119
5401 Oakdale Oakdale 2021-04-07 Stanislaus 99 1785   22599
5402 Patterson Patterson 2021-04-07 Stanislaus 99 2552   21783
5403 Riverbank Riverbank 2021-04-07 Stanislaus 99 2480   24237
5404 Turlock Turlock 2021-04-07 Stanislaus 99 7182   72335
5405 Unincorporated districts Other 2021-04-07 Stanislaus 99 9258    
5406 Waterford Waterford 2021-04-07 Stanislaus 99 637   8823
6769 Ceres Ceres 2021-04-06 Stanislaus 99 5388   47975
6770 Hughson Hughson 2021-04-06 Stanislaus 99 577   7370
6771 Modesto Modesto 2021-04-06 Stanislaus 99 19853   211336
6772 Newman Newman 2021-04-06 Stanislaus 99 1179   11119
6773 Oakdale Oakdale 2021-04-06 Stanislaus 99 1784   22599
6774 Patterson Patterson 2021-04-06 Stanislaus 99 2548   21783
6775 Riverbank Riverbank 2021-04-06 Stanislaus 99 2476   24237
6776 Turlock Turlock 2021-04-06 Stanislaus 99 7176   72335
6777 Unincorporated districts Other 2021-04-06 Stanislaus 99 9238    
6778 Waterford Waterford 2021-04-06 Stanislaus 99 636   8823
8145 Ceres Ceres 2021-04-05 Stanislaus 99 5374   47975
8146 Hughson Hughson 2021-04-05 Stanislaus 99 577   7370
8147 Modesto Modesto 2021-04-05 Stanislaus 99 19803   211336
8148 Newman Newman 2021-04-05 Stanislaus 99 1179   11119
8149 Oakdale Oakdale 2021-04-05 Stanislaus 99 1781   22599
8150 Patterson Patterson 2021-04-05 Stanislaus 99 2544   21783
8151 Riverbank Riverbank 2021-04-05 Stanislaus 99 2469   24237
8152 Turlock Turlock 2021-04-05 Stanislaus 99 7159   72335
8153 Unincorporated districts Other 2021-04-05 Stanislaus 99 9216    
8154 Waterford Waterford 2021-04-05 Stanislaus 99 636   8823
9521 Ceres Ceres 2021-04-04 Stanislaus 99 5370   47975
9522 Hughson Hughson 2021-04-04 Stanislaus 99 577   7370
9523 Modesto Modesto 2021-04-04 Stanislaus 99 19775   211336
9524 Newman Newman 2021-04-04 Stanislaus 99 1174   11119
9525 Oakdale Oakdale 2021-04-04 Stanislaus 99 1781   22599
9526 Patterson Patterson 2021-04-04 Stanislaus 99 2538   21783
9527 Riverbank Riverbank 2021-04-04 Stanislaus 99 2469   24237
9528 Turlock Turlock 2021-04-04 Stanislaus 99 7154   72335
9529 Unincorporated districts Other 2021-04-04 Stanislaus 99 9204    
9530 Waterford Waterford 2021-04-04 Stanislaus 99 634   8823
10897 Ceres Ceres 2021-04-03 Stanislaus 99 5360   47975
10898 Hughson Hughson 2021-04-03 Stanislaus 99 577   7370
10899 Modesto Modesto 2021-04-03 Stanislaus 99 19664   211336
10900 Newman Newman 2021-04-03 Stanislaus 99 1169   11119
10901 Oakdale Oakdale 2021-04-03 Stanislaus 99 1763   22599
10902 Patterson Patterson 2021-04-03 Stanislaus 99 2527   21783
10903 Riverbank Riverbank 2021-04-03 Stanislaus 99 2459   24237
10904 Turlock Turlock 2021-04-03 Stanislaus 99 7135   72335
10905 Unincorporated districts Other 2021-04-03 Stanislaus 99 9156    
10906 Waterford Waterford 2021-04-03 Stanislaus 99 633   8823
12273 Ceres Ceres 2021-04-02 Stanislaus 99 5360   47975
12274 Hughson Hughson 2021-04-02 Stanislaus 99 577   7370
12275 Modesto Modesto 2021-04-02 Stanislaus 99 19664   211336
12276 Newman Newman 2021-04-02 Stanislaus 99 1169   11119
12277 Oakdale Oakdale 2021-04-02 Stanislaus 99 1763   22599
12278 Patterson Patterson 2021-04-02 Stanislaus 99 2527   21783
12279 Riverbank Riverbank 2021-04-02 Stanislaus 99 2459   24237
12280 Turlock Turlock 2021-04-02 Stanislaus 99 7135   72335
12281 Unincorporated districts Other 2021-04-02 Stanislaus 99 9156    
12282 Waterford Waterford 2021-04-02 Stanislaus 99 633   8823
13653 Ceres Ceres 2021-04-01 Stanislaus 99 5359   47975
13654 Hughson Hughson 2021-04-01 Stanislaus 99 577   7370
13655 Modesto Modesto 2021-04-01 Stanislaus 99 19635   211336
13656 Newman Newman 2021-04-01 Stanislaus 99 1166   11119
13657 Oakdale Oakdale 2021-04-01 Stanislaus 99 1761   22599
13658 Patterson Patterson 2021-04-01 Stanislaus 99 2526   21783
13659 Riverbank Riverbank 2021-04-01 Stanislaus 99 2454   24237
13660 Turlock Turlock 2021-04-01 Stanislaus 99 7130   72335
13661 Unincorporated districts Other 2021-04-01 Stanislaus 99 9145    
13662 Waterford Waterford 2021-04-01 Stanislaus 99 633   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
);