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

2,096 rows where fips = 25 sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

place

fips

  • 25 · 2,096

county

Link rowid date ▲ county fips place confirmed_cases note x y
106 2020-10-23 Imperial 25 92222 2   -114.560561 32.789371
107 2020-10-23 Imperial 25 92227 2167   -115.331169 33.000108
108 2020-10-23 Imperial 25 92231 3886   -115.57995 32.682647
109 2020-10-23 Imperial 25 92233 332   -115.615473 33.190472
110 2020-10-23 Imperial 25 92243 3366   -115.57746 32.783359
111 2020-10-23 Imperial 25 92249 556   -115.491124 32.728313
112 2020-10-23 Imperial 25 92250 516   -115.236341 32.767433
113 2020-10-23 Imperial 25 92251 1201   -115.73385 32.849187
114 2020-10-23 Imperial 25 92257 47   -115.331169 33.336559
115 2020-10-23 Imperial 25 92259 3   -115.994099 32.686531
116 2020-10-23 Imperial 25 92266 6   -114.951687 33.334267
117 2020-10-23 Imperial 25 92273 86   -115.693904 32.790838
118 2020-10-23 Imperial 25 92274 183   -116.183207 33.565881
119 2020-10-23 Imperial 25 92275 27   -115.828515 33.248298
120 2020-10-23 Imperial 25 92281 160   -115.585871 33.065678
121 2020-10-23 Imperial 25 92283 153   -114.809269 32.900519
1059 2020-10-22 Imperial 25 92222 2   -114.560561 32.789371
1060 2020-10-22 Imperial 25 92227 2161   -115.331169 33.000108
1061 2020-10-22 Imperial 25 92231 3876   -115.57995 32.682647
1062 2020-10-22 Imperial 25 92233 332   -115.615473 33.190472
1063 2020-10-22 Imperial 25 92243 3358   -115.57746 32.783359
1064 2020-10-22 Imperial 25 92249 555   -115.491124 32.728313
1065 2020-10-22 Imperial 25 92250 514   -115.236341 32.767433
1066 2020-10-22 Imperial 25 92251 1200   -115.73385 32.849187
1067 2020-10-22 Imperial 25 92257 46   -115.331169 33.336559
1068 2020-10-22 Imperial 25 92259 3   -115.994099 32.686531
1069 2020-10-22 Imperial 25 92266 6   -114.951687 33.334267
1070 2020-10-22 Imperial 25 92273 85   -115.693904 32.790838
1071 2020-10-22 Imperial 25 92274 181   -116.183207 33.565881
1072 2020-10-22 Imperial 25 92275 27   -115.828515 33.248298
1073 2020-10-22 Imperial 25 92281 160   -115.585871 33.065678
1074 2020-10-22 Imperial 25 92283 153   -114.809269 32.900519
2012 2020-10-21 Imperial 25 92222 2   -114.560561 32.789371
2013 2020-10-21 Imperial 25 92227 2156   -115.331169 33.000108
2014 2020-10-21 Imperial 25 92231 3853   -115.57995 32.682647
2015 2020-10-21 Imperial 25 92233 331   -115.615473 33.190472
2016 2020-10-21 Imperial 25 92243 3343   -115.57746 32.783359
2017 2020-10-21 Imperial 25 92249 548   -115.491124 32.728313
2018 2020-10-21 Imperial 25 92250 514   -115.236341 32.767433
2019 2020-10-21 Imperial 25 92251 1193   -115.73385 32.849187
2020 2020-10-21 Imperial 25 92257 46   -115.331169 33.336559
2021 2020-10-21 Imperial 25 92259 3   -115.994099 32.686531
2022 2020-10-21 Imperial 25 92266 6   -114.951687 33.334267
2023 2020-10-21 Imperial 25 92273 85   -115.693904 32.790838
2024 2020-10-21 Imperial 25 92274 181   -116.183207 33.565881
2025 2020-10-21 Imperial 25 92275 27   -115.828515 33.248298
2026 2020-10-21 Imperial 25 92281 160   -115.585871 33.065678
2027 2020-10-21 Imperial 25 92283 153   -114.809269 32.900519
3031 2020-10-20 Imperial 25 92222 2   -114.560561 32.789371
3032 2020-10-20 Imperial 25 92227 2145   -115.331169 33.000108
3033 2020-10-20 Imperial 25 92231 3821   -115.57995 32.682647
3034 2020-10-20 Imperial 25 92233 331   -115.615473 33.190472
3035 2020-10-20 Imperial 25 92243 3319   -115.57746 32.783359
3036 2020-10-20 Imperial 25 92249 547   -115.491124 32.728313
3037 2020-10-20 Imperial 25 92250 512   -115.236341 32.767433
3038 2020-10-20 Imperial 25 92251 1185   -115.73385 32.849187
3039 2020-10-20 Imperial 25 92257 46   -115.331169 33.336559
3040 2020-10-20 Imperial 25 92259 3   -115.994099 32.686531
3041 2020-10-20 Imperial 25 92266 6   -114.951687 33.334267
3042 2020-10-20 Imperial 25 92273 85   -115.693904 32.790838
3043 2020-10-20 Imperial 25 92274 181   -116.183207 33.565881
3044 2020-10-20 Imperial 25 92275 27   -115.828515 33.248298
3045 2020-10-20 Imperial 25 92281 160   -115.585871 33.065678
3046 2020-10-20 Imperial 25 92283 154   -114.809269 32.900519
4009 2020-10-19 Imperial 25 92222 2   -114.560561 32.789371
4010 2020-10-19 Imperial 25 92227 2140   -115.331169 33.000108
4011 2020-10-19 Imperial 25 92231 3793   -115.57995 32.682647
4012 2020-10-19 Imperial 25 92233 330   -115.615473 33.190472
4013 2020-10-19 Imperial 25 92243 3312   -115.57746 32.783359
4014 2020-10-19 Imperial 25 92249 545   -115.491124 32.728313
4015 2020-10-19 Imperial 25 92250 507   -115.236341 32.767433
4016 2020-10-19 Imperial 25 92251 1177   -115.73385 32.849187
4017 2020-10-19 Imperial 25 92257 46   -115.331169 33.336559
4018 2020-10-19 Imperial 25 92259 3   -115.994099 32.686531
4019 2020-10-19 Imperial 25 92266 6   -114.951687 33.334267
4020 2020-10-19 Imperial 25 92273 85   -115.693904 32.790838
4021 2020-10-19 Imperial 25 92274 178   -116.183207 33.565881
4022 2020-10-19 Imperial 25 92275 27   -115.828515 33.248298
4023 2020-10-19 Imperial 25 92281 160   -115.585871 33.065678
4024 2020-10-19 Imperial 25 92283 154   -114.809269 32.900519
6223 2020-10-16 Imperial 25 92222 2   -114.560561 32.789371
6224 2020-10-16 Imperial 25 92227 2129   -115.331169 33.000108
6225 2020-10-16 Imperial 25 92231 3765   -115.57995 32.682647
6226 2020-10-16 Imperial 25 92233 328   -115.615473 33.190472
6227 2020-10-16 Imperial 25 92243 3305   -115.57746 32.783359
6228 2020-10-16 Imperial 25 92249 539   -115.491124 32.728313
6229 2020-10-16 Imperial 25 92250 504   -115.236341 32.767433
6230 2020-10-16 Imperial 25 92251 1170   -115.73385 32.849187
6231 2020-10-16 Imperial 25 92257 46   -115.331169 33.336559
6232 2020-10-16 Imperial 25 92259 3   -115.994099 32.686531
6233 2020-10-16 Imperial 25 92266 6   -114.951687 33.334267
6234 2020-10-16 Imperial 25 92273 84   -115.693904 32.790838
6235 2020-10-16 Imperial 25 92274 177   -116.183207 33.565881
6236 2020-10-16 Imperial 25 92275 27   -115.828515 33.248298
6237 2020-10-16 Imperial 25 92281 160   -115.585871 33.065678
6238 2020-10-16 Imperial 25 92283 156   -114.809269 32.900519
7167 2020-10-15 Imperial 25 92222 2   -114.560561 32.789371
7168 2020-10-15 Imperial 25 92227 2116   -115.331169 33.000108
7169 2020-10-15 Imperial 25 92231 3757   -115.57995 32.682647
7170 2020-10-15 Imperial 25 92233 328   -115.615473 33.190472

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