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

869 rows where county = "Yolo" sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

fips

county

  • Yolo · 869
Link rowid date ▲ county fips place confirmed_cases note x y
983 2020-10-23 Yolo 113 Davis 365   -121.738056 38.553889
984 2020-10-23 Yolo 113 Other 367      
985 2020-10-23 Yolo 113 West Sacramento 932   -121.530278 38.580556
986 2020-10-23 Yolo 113 Winters 136   -121.970833 38.525
987 2020-10-23 Yolo 113 Woodland 1344   -121.773333 38.678611
1942 2020-10-22 Yolo 113 Davis 362   -121.738056 38.553889
1943 2020-10-22 Yolo 113 Other 363      
1944 2020-10-22 Yolo 113 West Sacramento 925   -121.530278 38.580556
1945 2020-10-22 Yolo 113 Winters 136   -121.970833 38.525
1946 2020-10-22 Yolo 113 Woodland 1333   -121.773333 38.678611
2926 2020-10-21 Yolo 113 Davis 359   -121.738056 38.553889
2927 2020-10-21 Yolo 113 Other 363      
2928 2020-10-21 Yolo 113 West Sacramento 924   -121.530278 38.580556
2929 2020-10-21 Yolo 113 Winters 136   -121.970833 38.525
2930 2020-10-21 Yolo 113 Woodland 1317   -121.773333 38.678611
3930 2020-10-20 Yolo 113 Davis 357   -121.738056 38.553889
3931 2020-10-20 Yolo 113 Other 362      
3932 2020-10-20 Yolo 113 West Sacramento 920   -121.530278 38.580556
3933 2020-10-20 Yolo 113 Winters 136   -121.970833 38.525
3934 2020-10-20 Yolo 113 Woodland 1311   -121.773333 38.678611
5430 2020-10-18 Yolo 113 Davis 355   -121.738056 38.553889
5431 2020-10-18 Yolo 113 Other 360      
5432 2020-10-18 Yolo 113 West Sacramento 907   -121.530278 38.580556
5433 2020-10-18 Yolo 113 Winters 137   -121.970833 38.525
5434 2020-10-18 Yolo 113 Woodland 1304   -121.773333 38.678611
6111 2020-10-17 Yolo 113 Other 358      
6112 2020-10-17 Yolo 113 West Sacramento 904   -121.530278 38.580556
6113 2020-10-17 Yolo 113 Winters 134   -121.970833 38.525
6114 2020-10-17 Yolo 113 Woodland 1299   -121.773333 38.678611
7089 2020-10-16 Yolo 113 Davis 351   -121.738056 38.553889
7090 2020-10-16 Yolo 113 Other 358      
7091 2020-10-16 Yolo 113 West Sacramento 901   -121.530278 38.580556
7092 2020-10-16 Yolo 113 Winters 134   -121.970833 38.525
7093 2020-10-16 Yolo 113 Woodland 1291   -121.773333 38.678611
8027 2020-10-15 Yolo 113 Davis 349   -121.738056 38.553889
8028 2020-10-15 Yolo 113 Other 356      
8029 2020-10-15 Yolo 113 West Sacramento 899   -121.530278 38.580556
8030 2020-10-15 Yolo 113 Winters 132   -121.970833 38.525
8031 2020-10-15 Yolo 113 Woodland 1279   -121.773333 38.678611
8965 2020-10-14 Yolo 113 Davis 347   -121.738056 38.553889
8966 2020-10-14 Yolo 113 Other 358      
8967 2020-10-14 Yolo 113 West Sacramento 897   -121.530278 38.580556
8968 2020-10-14 Yolo 113 Winters 131   -121.970833 38.525
8969 2020-10-14 Yolo 113 Woodland 1277   -121.773333 38.678611
9875 2020-10-13 Yolo 113 Davis 343   -121.738056 38.553889
9876 2020-10-13 Yolo 113 Other 356      
9877 2020-10-13 Yolo 113 West Sacramento 894   -121.530278 38.580556
9878 2020-10-13 Yolo 113 Winters 129   -121.970833 38.525
9879 2020-10-13 Yolo 113 Woodland 1264   -121.773333 38.678611
10739 2020-10-12 Yolo 113 Davis 339   -121.738056 38.553889
10740 2020-10-12 Yolo 113 Other 355      
10741 2020-10-12 Yolo 113 West Sacramento 888   -121.530278 38.580556
10742 2020-10-12 Yolo 113 Winters 129   -121.970833 38.525
10743 2020-10-12 Yolo 113 Woodland 1255   -121.773333 38.678611
11407 2020-10-11 Yolo 113 Davis 336   -121.738056 38.553889
11408 2020-10-11 Yolo 113 Other 355      
11409 2020-10-11 Yolo 113 West Sacramento 883   -121.530278 38.580556
11410 2020-10-11 Yolo 113 Winters 129   -121.970833 38.525
11411 2020-10-11 Yolo 113 Woodland 1251   -121.773333 38.678611
12141 2020-10-10 Yolo 113 Davis 336   -121.738056 38.553889
12142 2020-10-10 Yolo 113 Other 351      
12143 2020-10-10 Yolo 113 West Sacramento 883   -121.530278 38.580556
12144 2020-10-10 Yolo 113 Winters 126   -121.970833 38.525
12145 2020-10-10 Yolo 113 Woodland 1246   -121.773333 38.678611
14133 2020-10-08 Yolo 113 Davis 329   -121.738056 38.553889
14134 2020-10-08 Yolo 113 Other 348      
14135 2020-10-08 Yolo 113 West Sacramento 874   -121.530278 38.580556
14136 2020-10-08 Yolo 113 Winters 124   -121.970833 38.525
14137 2020-10-08 Yolo 113 Woodland 1243   -121.773333 38.678611
15088 2020-10-07 Yolo 113 Davis 331   -121.738056 38.553889
15089 2020-10-07 Yolo 113 Other 348      
15090 2020-10-07 Yolo 113 West Sacramento 871   -121.530278 38.580556
15091 2020-10-07 Yolo 113 Winters 123   -121.970833 38.525
15092 2020-10-07 Yolo 113 Woodland 1237   -121.773333 38.678611
16044 2020-10-06 Yolo 113 Davis 331   -121.738056 38.553889
16045 2020-10-06 Yolo 113 Other 348      
16046 2020-10-06 Yolo 113 West Sacramento 869   -121.530278 38.580556
16047 2020-10-06 Yolo 113 Winters 123   -121.970833 38.525
16048 2020-10-06 Yolo 113 Woodland 1232   -121.773333 38.678611
17536 2020-10-04 Yolo 113 Davis 330   -121.738056 38.553889
17537 2020-10-04 Yolo 113 Other 345      
17538 2020-10-04 Yolo 113 West Sacramento 867   -121.530278 38.580556
17539 2020-10-04 Yolo 113 Winters 120   -121.970833 38.525
17540 2020-10-04 Yolo 113 Woodland 1217   -121.773333 38.678611
18200 2020-10-03 Yolo 113 Davis 326   -121.738056 38.553889
18201 2020-10-03 Yolo 113 Other 344      
18202 2020-10-03 Yolo 113 West Sacramento 863   -121.530278 38.580556
18203 2020-10-03 Yolo 113 Winters 120   -121.970833 38.525
18204 2020-10-03 Yolo 113 Woodland 1214   -121.773333 38.678611
19260 2020-10-02 Yolo 113 Davis 321   -121.738056 38.553889
19261 2020-10-02 Yolo 113 Other 340      
19262 2020-10-02 Yolo 113 West Sacramento 859   -121.530278 38.580556
19263 2020-10-02 Yolo 113 Winters 120   -121.970833 38.525
19264 2020-10-02 Yolo 113 Woodland 1207   -121.773333 38.678611
20174 2020-10-01 Yolo 113 Davis 317   -121.738056 38.553889
20175 2020-10-01 Yolo 113 Other 340      
20176 2020-10-01 Yolo 113 West Sacramento 857   -121.530278 38.580556
20177 2020-10-01 Yolo 113 Winters 120   -121.970833 38.525
20178 2020-10-01 Yolo 113 Woodland 1202   -121.773333 38.678611
21154 2020-09-30 Yolo 113 Davis 315   -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 770.3ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals