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

1,499 rows where fips = 99 sorted by date descending

View and edit SQL

Suggested facets: note, x, y, date (date)

place

fips

  • 99 · 1,499

county

Link rowid date ▲ county fips place confirmed_cases note x y
13089 2020-10-09 Stanislaus 99 Ceres 2160   -120.957222 37.601389
13090 2020-10-09 Stanislaus 99 Hughson 169   -120.866944 37.603056
13091 2020-10-09 Stanislaus 99 Modesto 6461   -120.994444 37.661389
13092 2020-10-09 Stanislaus 99 Newman 348   -121.0225 37.315
13093 2020-10-09 Stanislaus 99 Oakdale 398   -120.856944 37.769167
13094 2020-10-09 Stanislaus 99 Other 3336      
13095 2020-10-09 Stanislaus 99 Patterson 857   -121.132778 37.473056
13096 2020-10-09 Stanislaus 99 Riverbank 863   -120.943611 37.731389
13097 2020-10-09 Stanislaus 99 Turlock 2322   -120.848889 37.505833
13098 2020-10-09 Stanislaus 99 Waterford 265   -120.7675 37.645
14072 2020-10-08 Stanislaus 99 Ceres 2098   -120.957222 37.601389
14073 2020-10-08 Stanislaus 99 Hughson 157   -120.866944 37.603056
14074 2020-10-08 Stanislaus 99 Modesto 6225   -120.994444 37.661389
14075 2020-10-08 Stanislaus 99 Newman 340   -121.0225 37.315
14076 2020-10-08 Stanislaus 99 Oakdale 388   -120.856944 37.769167
14077 2020-10-08 Stanislaus 99 Other 3229      
14078 2020-10-08 Stanislaus 99 Patterson 821   -121.132778 37.473056
14079 2020-10-08 Stanislaus 99 Riverbank 844   -120.943611 37.731389
14080 2020-10-08 Stanislaus 99 Turlock 2253   -120.848889 37.505833
14081 2020-10-08 Stanislaus 99 Waterford 258   -120.7675 37.645
15027 2020-10-07 Stanislaus 99 Ceres 2090   -120.957222 37.601389
15028 2020-10-07 Stanislaus 99 Hughson 153   -120.866944 37.603056
15029 2020-10-07 Stanislaus 99 Modesto 6235   -120.994444 37.661389
15030 2020-10-07 Stanislaus 99 Newman 340   -121.0225 37.315
15031 2020-10-07 Stanislaus 99 Oakdale 388   -120.856944 37.769167
15032 2020-10-07 Stanislaus 99 Other 3223      
15033 2020-10-07 Stanislaus 99 Patterson 819   -121.132778 37.473056
15034 2020-10-07 Stanislaus 99 Riverbank 844   -120.943611 37.731389
15035 2020-10-07 Stanislaus 99 Turlock 2245   -120.848889 37.505833
15036 2020-10-07 Stanislaus 99 Waterford 257   -120.7675 37.645
16870 2020-10-05 Stanislaus 99 Ceres 2087   -120.957222 37.601389
16871 2020-10-05 Stanislaus 99 Hughson 153   -120.866944 37.603056
16872 2020-10-05 Stanislaus 99 Modesto 6233   -120.994444 37.661389
16873 2020-10-05 Stanislaus 99 Newman 340   -121.0225 37.315
16874 2020-10-05 Stanislaus 99 Oakdale 388   -120.856944 37.769167
16875 2020-10-05 Stanislaus 99 Other 3221      
16876 2020-10-05 Stanislaus 99 Patterson 819   -121.132778 37.473056
16877 2020-10-05 Stanislaus 99 Riverbank 842   -120.943611 37.731389
16878 2020-10-05 Stanislaus 99 Turlock 2243   -120.848889 37.505833
16879 2020-10-05 Stanislaus 99 Waterford 257   -120.7675 37.645
19196 2020-10-02 Stanislaus 99 Ceres 2079   -120.957222 37.601389
19197 2020-10-02 Stanislaus 99 Hughson 151   -120.866944 37.603056
19198 2020-10-02 Stanislaus 99 Modesto 6174   -120.994444 37.661389
19199 2020-10-02 Stanislaus 99 Newman 338   -121.0225 37.315
19200 2020-10-02 Stanislaus 99 Oakdale 379   -120.856944 37.769167
19201 2020-10-02 Stanislaus 99 Other 3204      
19202 2020-10-02 Stanislaus 99 Patterson 812   -121.132778 37.473056
19203 2020-10-02 Stanislaus 99 Riverbank 836   -120.943611 37.731389
19204 2020-10-02 Stanislaus 99 Turlock 2231   -120.848889 37.505833
19205 2020-10-02 Stanislaus 99 Waterford 255   -120.7675 37.645
21092 2020-09-30 Stanislaus 99 Ceres 2068   -120.957222 37.601389
21093 2020-09-30 Stanislaus 99 Hughson 146   -120.866944 37.603056
21094 2020-09-30 Stanislaus 99 Modesto 6135   -120.994444 37.661389
21095 2020-09-30 Stanislaus 99 Newman 337   -121.0225 37.315
21096 2020-09-30 Stanislaus 99 Oakdale 371   -120.856944 37.769167
21097 2020-09-30 Stanislaus 99 Other 3185      
21098 2020-09-30 Stanislaus 99 Patterson 809   -121.132778 37.473056
21099 2020-09-30 Stanislaus 99 Riverbank 829   -120.943611 37.731389
21100 2020-09-30 Stanislaus 99 Turlock 2227   -120.848889 37.505833
21101 2020-09-30 Stanislaus 99 Waterford 253   -120.7675 37.645
22084 2020-09-29 Stanislaus 99 Ceres 2061   -120.957222 37.601389
22085 2020-09-29 Stanislaus 99 Hughson 146   -120.866944 37.603056
22086 2020-09-29 Stanislaus 99 Modesto 6122   -120.994444 37.661389
22087 2020-09-29 Stanislaus 99 Newman 337   -121.0225 37.315
22088 2020-09-29 Stanislaus 99 Oakdale 368   -120.856944 37.769167
22089 2020-09-29 Stanislaus 99 Other 3177      
22090 2020-09-29 Stanislaus 99 Patterson 804   -121.132778 37.473056
22091 2020-09-29 Stanislaus 99 Riverbank 828   -120.943611 37.731389
22092 2020-09-29 Stanislaus 99 Turlock 2226   -120.848889 37.505833
22093 2020-09-29 Stanislaus 99 Waterford 253   -120.7675 37.645
23050 2020-09-28 Stanislaus 99 Ceres 2057   -120.957222 37.601389
23051 2020-09-28 Stanislaus 99 Hughson 146   -120.866944 37.603056
23052 2020-09-28 Stanislaus 99 Modesto 6110   -120.994444 37.661389
23053 2020-09-28 Stanislaus 99 Newman 335   -121.0225 37.315
23054 2020-09-28 Stanislaus 99 Oakdale 367   -120.856944 37.769167
23055 2020-09-28 Stanislaus 99 Other 3165      
23056 2020-09-28 Stanislaus 99 Patterson 801   -121.132778 37.473056
23057 2020-09-28 Stanislaus 99 Riverbank 825   -120.943611 37.731389
23058 2020-09-28 Stanislaus 99 Turlock 2223   -120.848889 37.505833
23059 2020-09-28 Stanislaus 99 Waterford 252   -120.7675 37.645
25407 2020-09-25 Stanislaus 99 Ceres 2053   -120.957222 37.601389
25408 2020-09-25 Stanislaus 99 Hughson 145   -120.866944 37.603056
25409 2020-09-25 Stanislaus 99 Modesto 6087   -120.994444 37.661389
25410 2020-09-25 Stanislaus 99 Newman 334   -121.0225 37.315
25411 2020-09-25 Stanislaus 99 Oakdale 363   -120.856944 37.769167
25412 2020-09-25 Stanislaus 99 Other 3135      
25413 2020-09-25 Stanislaus 99 Patterson 795   -121.132778 37.473056
25414 2020-09-25 Stanislaus 99 Riverbank 820   -120.943611 37.731389
25415 2020-09-25 Stanislaus 99 Turlock 2215   -120.848889 37.505833
25416 2020-09-25 Stanislaus 99 Waterford 245   -120.7675 37.645
26388 2020-09-24 Stanislaus 99 Ceres 2050   -120.957222 37.601389
26389 2020-09-24 Stanislaus 99 Hughson 145   -120.866944 37.603056
26390 2020-09-24 Stanislaus 99 Modesto 6060   -120.994444 37.661389
26391 2020-09-24 Stanislaus 99 Newman 333   -121.0225 37.315
26392 2020-09-24 Stanislaus 99 Oakdale 363   -120.856944 37.769167
26393 2020-09-24 Stanislaus 99 Other 3130      
26394 2020-09-24 Stanislaus 99 Patterson 792   -121.132778 37.473056
26395 2020-09-24 Stanislaus 99 Riverbank 817   -120.943611 37.731389
26396 2020-09-24 Stanislaus 99 Turlock 2211   -120.848889 37.505833
26397 2020-09-24 Stanislaus 99 Waterford 244   -120.7675 37.645

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