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,177 rows where county = "Imperial" sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

place

fips

  • 25 2,177

county

  • Imperial · 2,177
Link rowid date ▲ county fips place confirmed_cases note x y
107 2020-10-30 Imperial 25 92222 2   -114.560561 32.789371
108 2020-10-30 Imperial 25 92227 2205   -115.331169 33.000108
109 2020-10-30 Imperial 25 92231 4032   -115.57995 32.682647
110 2020-10-30 Imperial 25 92233 334   -115.615473 33.190472
111 2020-10-30 Imperial 25 92243 3445   -115.57746 32.783359
112 2020-10-30 Imperial 25 92249 578   -115.491124 32.728313
113 2020-10-30 Imperial 25 92250 532   -115.236341 32.767433
114 2020-10-30 Imperial 25 92251 1228   -115.73385 32.849187
115 2020-10-30 Imperial 25 92257 48   -115.331169 33.336559
116 2020-10-30 Imperial 25 92259 3   -115.994099 32.686531
117 2020-10-30 Imperial 25 92266 6   -114.951687 33.334267
118 2020-10-30 Imperial 25 92273 86   -115.693904 32.790838
119 2020-10-30 Imperial 25 92274 188   -116.183207 33.565881
120 2020-10-30 Imperial 25 92275 27   -115.828515 33.248298
121 2020-10-30 Imperial 25 92281 164   -115.585871 33.065678
122 2020-10-30 Imperial 25 92283 155   -114.809269 32.900519
1101 2020-10-29 Imperial 25 92222 2   -114.560561 32.789371
1102 2020-10-29 Imperial 25 92227 2201   -115.331169 33.000108
1103 2020-10-29 Imperial 25 92231 4027   -115.57995 32.682647
1104 2020-10-29 Imperial 25 92233 334   -115.615473 33.190472
1105 2020-10-29 Imperial 25 92243 3443   -115.57746 32.783359
1106 2020-10-29 Imperial 25 92249 576   -115.491124 32.728313
1107 2020-10-29 Imperial 25 92250 531   -115.236341 32.767433
1108 2020-10-29 Imperial 25 92251 1224   -115.73385 32.849187
1109 2020-10-29 Imperial 25 92257 47   -115.331169 33.336559
1110 2020-10-29 Imperial 25 92259 3   -115.994099 32.686531
1111 2020-10-29 Imperial 25 92266 6   -114.951687 33.334267
1112 2020-10-29 Imperial 25 92273 86   -115.693904 32.790838
1113 2020-10-29 Imperial 25 92274 188   -116.183207 33.565881
1114 2020-10-29 Imperial 25 92275 27   -115.828515 33.248298
1115 2020-10-29 Imperial 25 92281 164   -115.585871 33.065678
1116 2020-10-29 Imperial 25 92283 155   -114.809269 32.900519
2102 2020-10-28 Imperial 25 92222 2   -114.560561 32.789371
2103 2020-10-28 Imperial 25 92227 2199   -115.331169 33.000108
2104 2020-10-28 Imperial 25 92231 4013   -115.57995 32.682647
2105 2020-10-28 Imperial 25 92233 332   -115.615473 33.190472
2106 2020-10-28 Imperial 25 92243 3437   -115.57746 32.783359
2107 2020-10-28 Imperial 25 92249 574   -115.491124 32.728313
2108 2020-10-28 Imperial 25 92250 528   -115.236341 32.767433
2109 2020-10-28 Imperial 25 92251 1221   -115.73385 32.849187
2110 2020-10-28 Imperial 25 92257 47   -115.331169 33.336559
2111 2020-10-28 Imperial 25 92259 3   -115.994099 32.686531
2112 2020-10-28 Imperial 25 92266 6   -114.951687 33.334267
2113 2020-10-28 Imperial 25 92273 86   -115.693904 32.790838
2114 2020-10-28 Imperial 25 92274 186   -116.183207 33.565881
2115 2020-10-28 Imperial 25 92275 27   -115.828515 33.248298
2116 2020-10-28 Imperial 25 92281 160   -115.585871 33.065678
2117 2020-10-28 Imperial 25 92283 153   -114.809269 32.900519
3091 2020-10-27 Imperial 25 92222 2   -114.560561 32.789371
3092 2020-10-27 Imperial 25 92227 2193   -115.331169 33.000108
3093 2020-10-27 Imperial 25 92231 4009   -115.57995 32.682647
3094 2020-10-27 Imperial 25 92233 332   -115.615473 33.190472
3095 2020-10-27 Imperial 25 92243 3433   -115.57746 32.783359
3096 2020-10-27 Imperial 25 92249 573   -115.491124 32.728313
3097 2020-10-27 Imperial 25 92250 528   -115.236341 32.767433
3098 2020-10-27 Imperial 25 92251 1220   -115.73385 32.849187
3099 2020-10-27 Imperial 25 92257 47   -115.331169 33.336559
3100 2020-10-27 Imperial 25 92259 3   -115.994099 32.686531
3101 2020-10-27 Imperial 25 92266 6   -114.951687 33.334267
3102 2020-10-27 Imperial 25 92273 86   -115.693904 32.790838
3103 2020-10-27 Imperial 25 92274 186   -116.183207 33.565881
3104 2020-10-27 Imperial 25 92275 27   -115.828515 33.248298
3105 2020-10-27 Imperial 25 92281 160   -115.585871 33.065678
3106 2020-10-27 Imperial 25 92283 153   -114.809269 32.900519
4023 2020-10-26 Imperial 25 92222 2   -114.560561 32.789371
4024 2020-10-26 Imperial 25 92227 2184   -115.331169 33.000108
4025 2020-10-26 Imperial 25 92231 3965   -115.57995 32.682647
4026 2020-10-26 Imperial 25 92233 332   -115.615473 33.190472
4027 2020-10-26 Imperial 25 92243 3406   -115.57746 32.783359
4028 2020-10-26 Imperial 25 92244 1   -115.692714 32.79475
4029 2020-10-26 Imperial 25 92249 567   -115.491124 32.728313
4030 2020-10-26 Imperial 25 92250 527   -115.236341 32.767433
4031 2020-10-26 Imperial 25 92251 1218   -115.73385 32.849187
4032 2020-10-26 Imperial 25 92257 47   -115.331169 33.336559
4033 2020-10-26 Imperial 25 92259 3   -115.994099 32.686531
4034 2020-10-26 Imperial 25 92266 6   -114.951687 33.334267
4035 2020-10-26 Imperial 25 92273 86   -115.693904 32.790838
4036 2020-10-26 Imperial 25 92274 186   -116.183207 33.565881
4037 2020-10-26 Imperial 25 92275 27   -115.828515 33.248298
4038 2020-10-26 Imperial 25 92281 160   -115.585871 33.065678
4039 2020-10-26 Imperial 25 92283 153   -114.809269 32.900519
6295 2020-10-23 Imperial 25 92222 2   -114.560561 32.789371
6296 2020-10-23 Imperial 25 92227 2167   -115.331169 33.000108
6297 2020-10-23 Imperial 25 92231 3886   -115.57995 32.682647
6298 2020-10-23 Imperial 25 92233 332   -115.615473 33.190472
6299 2020-10-23 Imperial 25 92243 3366   -115.57746 32.783359
6300 2020-10-23 Imperial 25 92249 556   -115.491124 32.728313
6301 2020-10-23 Imperial 25 92250 516   -115.236341 32.767433
6302 2020-10-23 Imperial 25 92251 1201   -115.73385 32.849187
6303 2020-10-23 Imperial 25 92257 47   -115.331169 33.336559
6304 2020-10-23 Imperial 25 92259 3   -115.994099 32.686531
6305 2020-10-23 Imperial 25 92266 6   -114.951687 33.334267
6306 2020-10-23 Imperial 25 92273 86   -115.693904 32.790838
6307 2020-10-23 Imperial 25 92274 183   -116.183207 33.565881
6308 2020-10-23 Imperial 25 92275 27   -115.828515 33.248298
6309 2020-10-23 Imperial 25 92281 160   -115.585871 33.065678
6310 2020-10-23 Imperial 25 92283 153   -114.809269 32.900519
7325 2020-10-22 Imperial 25 92222 2   -114.560561 32.789371
7326 2020-10-22 Imperial 25 92227 2161   -115.331169 33.000108
7327 2020-10-22 Imperial 25 92231 3876   -115.57995 32.682647

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