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

9,085 rows where fips = 77 sorted by date descending

View and edit SQL

fips

  • 77 · 9,085

county

Link rowid date ▲ county fips place confirmed_cases note x y population
1070 2021-01-14 San Joaquin 77 95202: Stockton 425   -121.287599 37.959203 6001
1071 2021-01-14 San Joaquin 77 95203: Stockton 1195   -121.331767 37.951656 15775
1072 2021-01-14 San Joaquin 77 95204: Stockton 2160   -121.318612 37.973719 28425
1073 2021-01-14 San Joaquin 77 95205: Stockton 3250   -121.259645 37.964459 38544
1074 2021-01-14 San Joaquin 77 95206: Stockton 5746   -121.436076 37.911634 64034
1075 2021-01-14 San Joaquin 77 95207: Stockton 3653   -121.324936 38.002336 51879
1076 2021-01-14 San Joaquin 77 95209: Stockton 3289   -121.342078 38.041801 44313
1077 2021-01-14 San Joaquin 77 95210: Stockton 3122   -121.297246 38.031625 41117
1078 2021-01-14 San Joaquin 77 95211: Stockton 3   -121.313432 37.980261 1629
1079 2021-01-14 San Joaquin 77 95212: Stockton 2266   -121.227915 38.046863 28049
1080 2021-01-14 San Joaquin 77 95215: Stockton 1813   -121.148466 37.942248 24371
1081 2021-01-14 San Joaquin 77 95219: Stockton 1626   -121.455041 38.039366 29668
1082 2021-01-14 San Joaquin 77 95220: Acampo 436   -121.236363 38.196424 7538
1083 2021-01-14 San Joaquin 77 95227: Clements 45   -121.050645 38.225205 842
1084 2021-01-14 San Joaquin 77 95230: Farmington 24   -120.968738 37.923979 597
1085 2021-01-14 San Joaquin 77 95231: French Camp 337   -121.292472 37.87482 5092
1086 2021-01-14 San Joaquin 77 95236: Linden 287   -121.030084 38.032482 4223
1087 2021-01-14 San Joaquin 77 95237: Lockeford 209   -121.142772 38.165139 3531
1088 2021-01-14 San Joaquin 77 95240: Lodi 3906   -121.143949 38.11981 48838
1089 2021-01-14 San Joaquin 77 95242: Lodi 1575   -121.40376 38.128605 26235
1090 2021-01-14 San Joaquin 77 95258: Woodbridge 259   -121.307941 38.160339 3881
1091 2021-01-14 San Joaquin 77 95304: Banta 719   -121.253872 37.889849 14539
1092 2021-01-14 San Joaquin 77 95320: Escalon 780   -121.016229 37.818205 13094
1093 2021-01-14 San Joaquin 77 95330: Lathrop 1766   -121.309455 37.813311 21552
1094 2021-01-14 San Joaquin 77 95336: Manteca 2827   -121.196192 37.830973 47612
1095 2021-01-14 San Joaquin 77 95337: Manteca 2667   -121.240105 37.74227 37706
1096 2021-01-14 San Joaquin 77 95361: Oakdale 9   -120.941453 37.837395 34558
1097 2021-01-14 San Joaquin 77 95366: Ripon 1051   -121.126292 37.759786 17654
1098 2021-01-14 San Joaquin 77 95376: Tracy 3374   -121.431974 37.737138 53542
1099 2021-01-14 San Joaquin 77 95377: Tracy 1850   -121.472086 37.620602 32501
1100 2021-01-14 San Joaquin 77 95391: Mountain House 665   -121.540498 37.776932 16562
1101 2021-01-14 San Joaquin 77 95632: Galt 56   -121.211109 38.239647 31431
1102 2021-01-14 San Joaquin 77 95686: Thornton 48   -121.481307 38.189707 1209
2403 2021-01-13 San Joaquin 77 95202: Stockton 425   -121.287599 37.959203 6001
2404 2021-01-13 San Joaquin 77 95203: Stockton 1195   -121.331767 37.951656 15775
2405 2021-01-13 San Joaquin 77 95204: Stockton 2160   -121.318612 37.973719 28425
2406 2021-01-13 San Joaquin 77 95205: Stockton 3250   -121.259645 37.964459 38544
2407 2021-01-13 San Joaquin 77 95206: Stockton 5746   -121.436076 37.911634 64034
2408 2021-01-13 San Joaquin 77 95207: Stockton 3653   -121.324936 38.002336 51879
2409 2021-01-13 San Joaquin 77 95209: Stockton 3289   -121.342078 38.041801 44313
2410 2021-01-13 San Joaquin 77 95210: Stockton 3122   -121.297246 38.031625 41117
2411 2021-01-13 San Joaquin 77 95211: Stockton 3   -121.313432 37.980261 1629
2412 2021-01-13 San Joaquin 77 95212: Stockton 2266   -121.227915 38.046863 28049
2413 2021-01-13 San Joaquin 77 95215: Stockton 1813   -121.148466 37.942248 24371
2414 2021-01-13 San Joaquin 77 95219: Stockton 1626   -121.455041 38.039366 29668
2415 2021-01-13 San Joaquin 77 95220: Acampo 436   -121.236363 38.196424 7538
2416 2021-01-13 San Joaquin 77 95227: Clements 45   -121.050645 38.225205 842
2417 2021-01-13 San Joaquin 77 95230: Farmington 24   -120.968738 37.923979 597
2418 2021-01-13 San Joaquin 77 95231: French Camp 337   -121.292472 37.87482 5092
2419 2021-01-13 San Joaquin 77 95236: Linden 287   -121.030084 38.032482 4223
2420 2021-01-13 San Joaquin 77 95237: Lockeford 209   -121.142772 38.165139 3531
2421 2021-01-13 San Joaquin 77 95240: Lodi 3906   -121.143949 38.11981 48838
2422 2021-01-13 San Joaquin 77 95242: Lodi 1575   -121.40376 38.128605 26235
2423 2021-01-13 San Joaquin 77 95258: Woodbridge 259   -121.307941 38.160339 3881
2424 2021-01-13 San Joaquin 77 95304: Banta 719   -121.253872 37.889849 14539
2425 2021-01-13 San Joaquin 77 95320: Escalon 780   -121.016229 37.818205 13094
2426 2021-01-13 San Joaquin 77 95330: Lathrop 1766   -121.309455 37.813311 21552
2427 2021-01-13 San Joaquin 77 95336: Manteca 2827   -121.196192 37.830973 47612
2428 2021-01-13 San Joaquin 77 95337: Manteca 2667   -121.240105 37.74227 37706
2429 2021-01-13 San Joaquin 77 95361: Oakdale 9   -120.941453 37.837395 34558
2430 2021-01-13 San Joaquin 77 95366: Ripon 1051   -121.126292 37.759786 17654
2431 2021-01-13 San Joaquin 77 95376: Tracy 3374   -121.431974 37.737138 53542
2432 2021-01-13 San Joaquin 77 95377: Tracy 1850   -121.472086 37.620602 32501
2433 2021-01-13 San Joaquin 77 95391: Mountain House 665   -121.540498 37.776932 16562
2434 2021-01-13 San Joaquin 77 95632: Galt 56   -121.211109 38.239647 31431
2435 2021-01-13 San Joaquin 77 95686: Thornton 48   -121.481307 38.189707 1209
3745 2021-01-12 San Joaquin 77 95202: Stockton 414   -121.287599 37.959203 6001
3746 2021-01-12 San Joaquin 77 95203: Stockton 1187   -121.331767 37.951656 15775
3747 2021-01-12 San Joaquin 77 95204: Stockton 2127   -121.318612 37.973719 28425
3748 2021-01-12 San Joaquin 77 95205: Stockton 3205   -121.259645 37.964459 38544
3749 2021-01-12 San Joaquin 77 95206: Stockton 5678   -121.436076 37.911634 64034
3750 2021-01-12 San Joaquin 77 95207: Stockton 3593   -121.324936 38.002336 51879
3751 2021-01-12 San Joaquin 77 95209: Stockton 3245   -121.342078 38.041801 44313
3752 2021-01-12 San Joaquin 77 95210: Stockton 3077   -121.297246 38.031625 41117
3753 2021-01-12 San Joaquin 77 95211: Stockton 3   -121.313432 37.980261 1629
3754 2021-01-12 San Joaquin 77 95212: Stockton 2223   -121.227915 38.046863 28049
3755 2021-01-12 San Joaquin 77 95215: Stockton 1788   -121.148466 37.942248 24371
3756 2021-01-12 San Joaquin 77 95219: Stockton 1604   -121.455041 38.039366 29668
3757 2021-01-12 San Joaquin 77 95220: Acampo 431   -121.236363 38.196424 7538
3758 2021-01-12 San Joaquin 77 95227: Clements 45   -121.050645 38.225205 842
3759 2021-01-12 San Joaquin 77 95230: Farmington 24   -120.968738 37.923979 597
3760 2021-01-12 San Joaquin 77 95231: French Camp 336   -121.292472 37.87482 5092
3761 2021-01-12 San Joaquin 77 95236: Linden 286   -121.030084 38.032482 4223
3762 2021-01-12 San Joaquin 77 95237: Lockeford 207   -121.142772 38.165139 3531
3763 2021-01-12 San Joaquin 77 95240: Lodi 3870   -121.143949 38.11981 48838
3764 2021-01-12 San Joaquin 77 95242: Lodi 1551   -121.40376 38.128605 26235
3765 2021-01-12 San Joaquin 77 95258: Woodbridge 256   -121.307941 38.160339 3881
3766 2021-01-12 San Joaquin 77 95304: Banta 698   -121.253872 37.889849 14539
3767 2021-01-12 San Joaquin 77 95320: Escalon 770   -121.016229 37.818205 13094
3768 2021-01-12 San Joaquin 77 95330: Lathrop 1743   -121.309455 37.813311 21552
3769 2021-01-12 San Joaquin 77 95336: Manteca 2777   -121.196192 37.830973 47612
3770 2021-01-12 San Joaquin 77 95337: Manteca 2624   -121.240105 37.74227 37706
3771 2021-01-12 San Joaquin 77 95361: Oakdale 9   -120.941453 37.837395 34558
3772 2021-01-12 San Joaquin 77 95366: Ripon 1031   -121.126292 37.759786 17654
3773 2021-01-12 San Joaquin 77 95376: Tracy 3310   -121.431974 37.737138 53542
3774 2021-01-12 San Joaquin 77 95377: Tracy 1820   -121.472086 37.620602 32501
3775 2021-01-12 San Joaquin 77 95391: Mountain House 642   -121.540498 37.776932 16562
3776 2021-01-12 San Joaquin 77 95632: Galt 56   -121.211109 38.239647 31431
3777 2021-01-12 San Joaquin 77 95686: Thornton 47   -121.481307 38.189707 1209
5083 2021-01-11 San Joaquin 77 95202: Stockton 403   -121.287599 37.959203 6001

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,
   [population] TEXT
);