home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for 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

25,407 rows where county = "Monterey" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

  • 53 25,407

county 1

  • Monterey · 25,407 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
249 249 93426 93426: Bradley 2022-12-30 Monterey 53 100   1604
250 250 93901 93901: Salinas 2022-12-30 Monterey 53 6765   27805
251 251 93905 93905: Salinas 2022-12-30 Monterey 53 15857   60408
252 252 93906 93906: Salinas 2022-12-30 Monterey 53 15976   65256
253 253 93907 93907: Salinas 2022-12-30 Monterey 53 4331   22766
254 254 93908 93908: Salinas 2022-12-30 Monterey 53 1772   12093
255 255 93912 93912: Boronda 2022-12-30 Monterey 53 294   0
256 256 93920 93920: Big Sur 2022-12-30 Monterey 53 120   1403
257 257 93921 93921: Carmel 2022-12-30 Monterey 53 255   3379
258 258 93922 93922: Carmel 2022-12-30 Monterey 53 110   0
259 259 93923 93923: Carmel 2022-12-30 Monterey 53 1084   12833
260 260 93924 93924: Carmel Valley 2022-12-30 Monterey 53 605   6568
261 261 93925 93925: Chualar 2022-12-30 Monterey 53 363   2155
262 262 93926 93926: Gonzales 2022-12-30 Monterey 53 2222   9262
263 263 93927 93927: Greenfield 2022-12-30 Monterey 53 4840   18778
264 264 93930 93930: King City 2022-12-30 Monterey 53 4140   17142
265 265 93933 93933: Marina 2022-12-30 Monterey 53 4909   25015
266 266 93940 93940: Monterey 2022-12-30 Monterey 53 4401   32411
267 267 93942 93942: Monterey 2022-12-30 Monterey 53 94   0
268 268 93950 93950: Pacific Grove 2022-12-30 Monterey 53 1892   15595
269 269 93953 93953: Pebble Beach 2022-12-30 Monterey 53 442   4117
270 270 93955 93955: Seaside 2022-12-30 Monterey 53 7268   34395
271 271 93960 93960: Soledad 2022-12-30 Monterey 53 10411   26610
272 272 95004 95004: Aromas 2022-12-30 Monterey 53 468   3956
273 273 95012 95012: Castroville 2022-12-30 Monterey 53 3004   10792
274 274 95039 95039: Moss Landing 2022-12-30 Monterey 53 310   1195
275 275 95076 95076: Watsonville 2022-12-30 Monterey 53 3753   86703
1077 1077 93426 93426: Bradley 2022-12-29 Monterey 53 100   1604
1078 1078 93901 93901: Salinas 2022-12-29 Monterey 53 6765   27805
1079 1079 93905 93905: Salinas 2022-12-29 Monterey 53 15857   60408
1080 1080 93906 93906: Salinas 2022-12-29 Monterey 53 15976   65256
1081 1081 93907 93907: Salinas 2022-12-29 Monterey 53 4331   22766
1082 1082 93908 93908: Salinas 2022-12-29 Monterey 53 1772   12093
1083 1083 93912 93912: Boronda 2022-12-29 Monterey 53 294   0
1084 1084 93920 93920: Big Sur 2022-12-29 Monterey 53 120   1403
1085 1085 93921 93921: Carmel 2022-12-29 Monterey 53 255   3379
1086 1086 93922 93922: Carmel 2022-12-29 Monterey 53 110   0
1087 1087 93923 93923: Carmel 2022-12-29 Monterey 53 1084   12833
1088 1088 93924 93924: Carmel Valley 2022-12-29 Monterey 53 605   6568
1089 1089 93925 93925: Chualar 2022-12-29 Monterey 53 363   2155
1090 1090 93926 93926: Gonzales 2022-12-29 Monterey 53 2222   9262
1091 1091 93927 93927: Greenfield 2022-12-29 Monterey 53 4840   18778
1092 1092 93930 93930: King City 2022-12-29 Monterey 53 4140   17142
1093 1093 93933 93933: Marina 2022-12-29 Monterey 53 4909   25015
1094 1094 93940 93940: Monterey 2022-12-29 Monterey 53 4401   32411
1095 1095 93942 93942: Monterey 2022-12-29 Monterey 53 94   0
1096 1096 93950 93950: Pacific Grove 2022-12-29 Monterey 53 1892   15595
1097 1097 93953 93953: Pebble Beach 2022-12-29 Monterey 53 442   4117
1098 1098 93955 93955: Seaside 2022-12-29 Monterey 53 7268   34395
1099 1099 93960 93960: Soledad 2022-12-29 Monterey 53 10411   26610
1100 1100 95004 95004: Aromas 2022-12-29 Monterey 53 468   3956
1101 1101 95012 95012: Castroville 2022-12-29 Monterey 53 3004   10792
1102 1102 95039 95039: Moss Landing 2022-12-29 Monterey 53 310   1195
1103 1103 95076 95076: Watsonville 2022-12-29 Monterey 53 3753   86703
2258 2258 93426 93426: Bradley 2022-12-28 Monterey 53 100   1604
2259 2259 93901 93901: Salinas 2022-12-28 Monterey 53 6757   27805
2260 2260 93905 93905: Salinas 2022-12-28 Monterey 53 15845   60408
2261 2261 93906 93906: Salinas 2022-12-28 Monterey 53 15966   65256
2262 2262 93907 93907: Salinas 2022-12-28 Monterey 53 4326   22766
2263 2263 93908 93908: Salinas 2022-12-28 Monterey 53 1771   12093
2264 2264 93912 93912: Boronda 2022-12-28 Monterey 53 294   0
2265 2265 93920 93920: Big Sur 2022-12-28 Monterey 53 120   1403
2266 2266 93921 93921: Carmel 2022-12-28 Monterey 53 253   3379
2267 2267 93922 93922: Carmel 2022-12-28 Monterey 53 110   0
2268 2268 93923 93923: Carmel 2022-12-28 Monterey 53 1084   12833
2269 2269 93924 93924: Carmel Valley 2022-12-28 Monterey 53 602   6568
2270 2270 93925 93925: Chualar 2022-12-28 Monterey 53 363   2155
2271 2271 93926 93926: Gonzales 2022-12-28 Monterey 53 2222   9262
2272 2272 93927 93927: Greenfield 2022-12-28 Monterey 53 4838   18778
2273 2273 93930 93930: King City 2022-12-28 Monterey 53 4136   17142
2274 2274 93933 93933: Marina 2022-12-28 Monterey 53 4901   25015
2275 2275 93940 93940: Monterey 2022-12-28 Monterey 53 4397   32411
2276 2276 93942 93942: Monterey 2022-12-28 Monterey 53 94   0
2277 2277 93950 93950: Pacific Grove 2022-12-28 Monterey 53 1889   15595
2278 2278 93953 93953: Pebble Beach 2022-12-28 Monterey 53 442   4117
2279 2279 93955 93955: Seaside 2022-12-28 Monterey 53 7259   34395
2280 2280 93960 93960: Soledad 2022-12-28 Monterey 53 10411   26610
2281 2281 95004 95004: Aromas 2022-12-28 Monterey 53 467   3956
2282 2282 95012 95012: Castroville 2022-12-28 Monterey 53 3001   10792
2283 2283 95039 95039: Moss Landing 2022-12-28 Monterey 53 310   1195
2284 2284 95076 95076: Watsonville 2022-12-28 Monterey 53 3751   86703
3439 3439 93426 93426: Bradley 2022-12-27 Monterey 53 100   1604
3440 3440 93901 93901: Salinas 2022-12-27 Monterey 53 6757   27805
3441 3441 93905 93905: Salinas 2022-12-27 Monterey 53 15845   60408
3442 3442 93906 93906: Salinas 2022-12-27 Monterey 53 15966   65256
3443 3443 93907 93907: Salinas 2022-12-27 Monterey 53 4326   22766
3444 3444 93908 93908: Salinas 2022-12-27 Monterey 53 1771   12093
3445 3445 93912 93912: Boronda 2022-12-27 Monterey 53 294   0
3446 3446 93920 93920: Big Sur 2022-12-27 Monterey 53 120   1403
3447 3447 93921 93921: Carmel 2022-12-27 Monterey 53 253   3379
3448 3448 93922 93922: Carmel 2022-12-27 Monterey 53 110   0
3449 3449 93923 93923: Carmel 2022-12-27 Monterey 53 1084   12833
3450 3450 93924 93924: Carmel Valley 2022-12-27 Monterey 53 602   6568
3451 3451 93925 93925: Chualar 2022-12-27 Monterey 53 363   2155
3452 3452 93926 93926: Gonzales 2022-12-27 Monterey 53 2222   9262
3453 3453 93927 93927: Greenfield 2022-12-27 Monterey 53 4838   18778
3454 3454 93930 93930: King City 2022-12-27 Monterey 53 4136   17142
3455 3455 93933 93933: Marina 2022-12-27 Monterey 53 4901   25015
3456 3456 93940 93940: Monterey 2022-12-27 Monterey 53 4397   32411
3457 3457 93942 93942: Monterey 2022-12-27 Monterey 53 94   0

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