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

889 rows where fips = 113 sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

fips

  • 113 · 889

county

Link rowid date ▲ county fips place confirmed_cases note x y
973 2020-10-27 Yolo 113 Davis 374   -121.738056 38.553889
974 2020-10-27 Yolo 113 Other 377      
975 2020-10-27 Yolo 113 West Sacramento 953   -121.530278 38.580556
976 2020-10-27 Yolo 113 Winters 139   -121.970833 38.525
977 2020-10-27 Yolo 113 Woodland 1376   -121.773333 38.678611
1934 2020-10-26 Yolo 113 Davis 373   -121.738056 38.553889
1935 2020-10-26 Yolo 113 Other 376      
1936 2020-10-26 Yolo 113 West Sacramento 947   -121.530278 38.580556
1937 2020-10-26 Yolo 113 Winters 139   -121.970833 38.525
1938 2020-10-26 Yolo 113 Woodland 1372   -121.773333 38.678611
2617 2020-10-25 Yolo 113 Davis 370   -121.738056 38.553889
2618 2020-10-25 Yolo 113 Other 376      
2619 2020-10-25 Yolo 113 West Sacramento 945   -121.530278 38.580556
2620 2020-10-25 Yolo 113 Winters 138   -121.970833 38.525
2621 2020-10-25 Yolo 113 Woodland 1362   -121.773333 38.678611
3215 2020-10-24 Yolo 113 Davis 367   -121.738056 38.553889
3216 2020-10-24 Yolo 113 Other 372      
3217 2020-10-24 Yolo 113 West Sacramento 936   -121.530278 38.580556
3218 2020-10-24 Yolo 113 Winters 137   -121.970833 38.525
3219 2020-10-24 Yolo 113 Woodland 1354   -121.773333 38.678611
4267 2020-10-23 Yolo 113 Davis 365   -121.738056 38.553889
4268 2020-10-23 Yolo 113 Other 367      
4269 2020-10-23 Yolo 113 West Sacramento 932   -121.530278 38.580556
4270 2020-10-23 Yolo 113 Winters 136   -121.970833 38.525
4271 2020-10-23 Yolo 113 Woodland 1344   -121.773333 38.678611
5226 2020-10-22 Yolo 113 Davis 362   -121.738056 38.553889
5227 2020-10-22 Yolo 113 Other 363      
5228 2020-10-22 Yolo 113 West Sacramento 925   -121.530278 38.580556
5229 2020-10-22 Yolo 113 Winters 136   -121.970833 38.525
5230 2020-10-22 Yolo 113 Woodland 1333   -121.773333 38.678611
6210 2020-10-21 Yolo 113 Davis 359   -121.738056 38.553889
6211 2020-10-21 Yolo 113 Other 363      
6212 2020-10-21 Yolo 113 West Sacramento 924   -121.530278 38.580556
6213 2020-10-21 Yolo 113 Winters 136   -121.970833 38.525
6214 2020-10-21 Yolo 113 Woodland 1317   -121.773333 38.678611
7214 2020-10-20 Yolo 113 Davis 357   -121.738056 38.553889
7215 2020-10-20 Yolo 113 Other 362      
7216 2020-10-20 Yolo 113 West Sacramento 920   -121.530278 38.580556
7217 2020-10-20 Yolo 113 Winters 136   -121.970833 38.525
7218 2020-10-20 Yolo 113 Woodland 1311   -121.773333 38.678611
8714 2020-10-18 Yolo 113 Davis 355   -121.738056 38.553889
8715 2020-10-18 Yolo 113 Other 360      
8716 2020-10-18 Yolo 113 West Sacramento 907   -121.530278 38.580556
8717 2020-10-18 Yolo 113 Winters 137   -121.970833 38.525
8718 2020-10-18 Yolo 113 Woodland 1304   -121.773333 38.678611
9395 2020-10-17 Yolo 113 Other 358      
9396 2020-10-17 Yolo 113 West Sacramento 904   -121.530278 38.580556
9397 2020-10-17 Yolo 113 Winters 134   -121.970833 38.525
9398 2020-10-17 Yolo 113 Woodland 1299   -121.773333 38.678611
10373 2020-10-16 Yolo 113 Davis 351   -121.738056 38.553889
10374 2020-10-16 Yolo 113 Other 358      
10375 2020-10-16 Yolo 113 West Sacramento 901   -121.530278 38.580556
10376 2020-10-16 Yolo 113 Winters 134   -121.970833 38.525
10377 2020-10-16 Yolo 113 Woodland 1291   -121.773333 38.678611
11311 2020-10-15 Yolo 113 Davis 349   -121.738056 38.553889
11312 2020-10-15 Yolo 113 Other 356      
11313 2020-10-15 Yolo 113 West Sacramento 899   -121.530278 38.580556
11314 2020-10-15 Yolo 113 Winters 132   -121.970833 38.525
11315 2020-10-15 Yolo 113 Woodland 1279   -121.773333 38.678611
12249 2020-10-14 Yolo 113 Davis 347   -121.738056 38.553889
12250 2020-10-14 Yolo 113 Other 358      
12251 2020-10-14 Yolo 113 West Sacramento 897   -121.530278 38.580556
12252 2020-10-14 Yolo 113 Winters 131   -121.970833 38.525
12253 2020-10-14 Yolo 113 Woodland 1277   -121.773333 38.678611
13159 2020-10-13 Yolo 113 Davis 343   -121.738056 38.553889
13160 2020-10-13 Yolo 113 Other 356      
13161 2020-10-13 Yolo 113 West Sacramento 894   -121.530278 38.580556
13162 2020-10-13 Yolo 113 Winters 129   -121.970833 38.525
13163 2020-10-13 Yolo 113 Woodland 1264   -121.773333 38.678611
14023 2020-10-12 Yolo 113 Davis 339   -121.738056 38.553889
14024 2020-10-12 Yolo 113 Other 355      
14025 2020-10-12 Yolo 113 West Sacramento 888   -121.530278 38.580556
14026 2020-10-12 Yolo 113 Winters 129   -121.970833 38.525
14027 2020-10-12 Yolo 113 Woodland 1255   -121.773333 38.678611
14691 2020-10-11 Yolo 113 Davis 336   -121.738056 38.553889
14692 2020-10-11 Yolo 113 Other 355      
14693 2020-10-11 Yolo 113 West Sacramento 883   -121.530278 38.580556
14694 2020-10-11 Yolo 113 Winters 129   -121.970833 38.525
14695 2020-10-11 Yolo 113 Woodland 1251   -121.773333 38.678611
15425 2020-10-10 Yolo 113 Davis 336   -121.738056 38.553889
15426 2020-10-10 Yolo 113 Other 351      
15427 2020-10-10 Yolo 113 West Sacramento 883   -121.530278 38.580556
15428 2020-10-10 Yolo 113 Winters 126   -121.970833 38.525
15429 2020-10-10 Yolo 113 Woodland 1246   -121.773333 38.678611
17417 2020-10-08 Yolo 113 Davis 329   -121.738056 38.553889
17418 2020-10-08 Yolo 113 Other 348      
17419 2020-10-08 Yolo 113 West Sacramento 874   -121.530278 38.580556
17420 2020-10-08 Yolo 113 Winters 124   -121.970833 38.525
17421 2020-10-08 Yolo 113 Woodland 1243   -121.773333 38.678611
18372 2020-10-07 Yolo 113 Davis 331   -121.738056 38.553889
18373 2020-10-07 Yolo 113 Other 348      
18374 2020-10-07 Yolo 113 West Sacramento 871   -121.530278 38.580556
18375 2020-10-07 Yolo 113 Winters 123   -121.970833 38.525
18376 2020-10-07 Yolo 113 Woodland 1237   -121.773333 38.678611
19328 2020-10-06 Yolo 113 Davis 331   -121.738056 38.553889
19329 2020-10-06 Yolo 113 Other 348      
19330 2020-10-06 Yolo 113 West Sacramento 869   -121.530278 38.580556
19331 2020-10-06 Yolo 113 Winters 123   -121.970833 38.525
19332 2020-10-06 Yolo 113 Woodland 1232   -121.773333 38.678611
20820 2020-10-04 Yolo 113 Davis 330   -121.738056 38.553889

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 889.366ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals