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