⚠️ 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

6,318 rows where fips = 25 sorted by date descending

View and edit SQL

fips

  • 25 · 6,318

county

Link rowid id name date ▲ county fips confirmed_cases note population
177 92004 92004: Borrego Springs 2021-04-10 Imperial 25 155   2414
178 92222 92222: Bard 2021-04-10 Imperial 25 8   0
179 92227 92227: Brawley 2021-04-10 Imperial 25 4173   27255
180 92231 92231: Calexico 2021-04-10 Imperial 25 7044   40019
181 92233 92233: Calipatria 2021-04-10 Imperial 25 541   7618
182 92243 92243: El Centro 2021-04-10 Imperial 25 6950   50484
183 92244 92244: El Centro 2021-04-10 Imperial 25 92   0
184 92249 92249: Heber 2021-04-10 Imperial 25 1111   7898
185 92250 92250: Holtville 2021-04-10 Imperial 25 1029   8979
186 92251 92251: Imperial 2021-04-10 Imperial 25 2852   23388
187 92257 92257: Niland 2021-04-10 Imperial 25 105   1332
188 92259 92259: Ocotillo 2021-04-10 Imperial 25 15   94
189 92266 92266: Palo Verde 2021-04-10 Imperial 25 8   108
190 92273 92273: Seeley 2021-04-10 Imperial 25 197   1704
191 92274 92274: Thermal 2021-04-10 Imperial 25 524   15118
192 92275 92275: Salton City 2021-04-10 Imperial 25 37   2456
193 92281 92281: Westmorland 2021-04-10 Imperial 25 251   2859
194 92283 92283: Winterhaven 2021-04-10 Imperial 25 322   1694
1544 92004 92004: Borrego Springs 2021-04-09 Imperial 25 155   2414
1545 92222 92222: Bard 2021-04-09 Imperial 25 8   0
1546 92227 92227: Brawley 2021-04-09 Imperial 25 4173   27255
1547 92231 92231: Calexico 2021-04-09 Imperial 25 7044   40019
1548 92233 92233: Calipatria 2021-04-09 Imperial 25 541   7618
1549 92243 92243: El Centro 2021-04-09 Imperial 25 6950   50484
1550 92244 92244: El Centro 2021-04-09 Imperial 25 92   0
1551 92249 92249: Heber 2021-04-09 Imperial 25 1111   7898
1552 92250 92250: Holtville 2021-04-09 Imperial 25 1029   8979
1553 92251 92251: Imperial 2021-04-09 Imperial 25 2852   23388
1554 92257 92257: Niland 2021-04-09 Imperial 25 105   1332
1555 92259 92259: Ocotillo 2021-04-09 Imperial 25 15   94
1556 92266 92266: Palo Verde 2021-04-09 Imperial 25 8   108
1557 92273 92273: Seeley 2021-04-09 Imperial 25 197   1704
1558 92274 92274: Thermal 2021-04-09 Imperial 25 524   15118
1559 92275 92275: Salton City 2021-04-09 Imperial 25 37   2456
1560 92281 92281: Westmorland 2021-04-09 Imperial 25 251   2859
1561 92283 92283: Winterhaven 2021-04-09 Imperial 25 322   1694
2911 92004 92004: Borrego Springs 2021-04-08 Imperial 25 155   2414
2912 92222 92222: Bard 2021-04-08 Imperial 25 8   0
2913 92227 92227: Brawley 2021-04-08 Imperial 25 4172   27255
2914 92231 92231: Calexico 2021-04-08 Imperial 25 7026   40019
2915 92233 92233: Calipatria 2021-04-08 Imperial 25 539   7618
2916 92243 92243: El Centro 2021-04-08 Imperial 25 6947   50484
2917 92244 92244: El Centro 2021-04-08 Imperial 25 92   0
2918 92249 92249: Heber 2021-04-08 Imperial 25 1109   7898
2919 92250 92250: Holtville 2021-04-08 Imperial 25 1028   8979
2920 92251 92251: Imperial 2021-04-08 Imperial 25 2845   23388
2921 92257 92257: Niland 2021-04-08 Imperial 25 105   1332
2922 92259 92259: Ocotillo 2021-04-08 Imperial 25 15   94
2923 92266 92266: Palo Verde 2021-04-08 Imperial 25 8   108
2924 92273 92273: Seeley 2021-04-08 Imperial 25 197   1704
2925 92274 92274: Thermal 2021-04-08 Imperial 25 524   15118
2926 92275 92275: Salton City 2021-04-08 Imperial 25 37   2456
2927 92281 92281: Westmorland 2021-04-08 Imperial 25 251   2859
2928 92283 92283: Winterhaven 2021-04-08 Imperial 25 322   1694
4281 92004 92004: Borrego Springs 2021-04-07 Imperial 25 154   2414
4282 92222 92222: Bard 2021-04-07 Imperial 25 8   0
4283 92227 92227: Brawley 2021-04-07 Imperial 25 4168   27255
4284 92231 92231: Calexico 2021-04-07 Imperial 25 7010   40019
4285 92233 92233: Calipatria 2021-04-07 Imperial 25 539   7618
4286 92243 92243: El Centro 2021-04-07 Imperial 25 6924   50484
4287 92244 92244: El Centro 2021-04-07 Imperial 25 92   0
4288 92249 92249: Heber 2021-04-07 Imperial 25 1106   7898
4289 92250 92250: Holtville 2021-04-07 Imperial 25 1026   8979
4290 92251 92251: Imperial 2021-04-07 Imperial 25 2837   23388
4291 92257 92257: Niland 2021-04-07 Imperial 25 105   1332
4292 92259 92259: Ocotillo 2021-04-07 Imperial 25 15   94
4293 92266 92266: Palo Verde 2021-04-07 Imperial 25 8   108
4294 92273 92273: Seeley 2021-04-07 Imperial 25 197   1704
4295 92274 92274: Thermal 2021-04-07 Imperial 25 523   15118
4296 92275 92275: Salton City 2021-04-07 Imperial 25 37   2456
4297 92281 92281: Westmorland 2021-04-07 Imperial 25 250   2859
4298 92283 92283: Winterhaven 2021-04-07 Imperial 25 322   1694
5653 92004 92004: Borrego Springs 2021-04-06 Imperial 25 154   2414
5654 92222 92222: Bard 2021-04-06 Imperial 25 8   0
5655 92227 92227: Brawley 2021-04-06 Imperial 25 4167   27255
5656 92231 92231: Calexico 2021-04-06 Imperial 25 7003   40019
5657 92233 92233: Calipatria 2021-04-06 Imperial 25 539   7618
5658 92243 92243: El Centro 2021-04-06 Imperial 25 6922   50484
5659 92244 92244: El Centro 2021-04-06 Imperial 25 92   0
5660 92249 92249: Heber 2021-04-06 Imperial 25 1106   7898
5661 92250 92250: Holtville 2021-04-06 Imperial 25 1025   8979
5662 92251 92251: Imperial 2021-04-06 Imperial 25 2837   23388
5663 92257 92257: Niland 2021-04-06 Imperial 25 105   1332
5664 92259 92259: Ocotillo 2021-04-06 Imperial 25 15   94
5665 92266 92266: Palo Verde 2021-04-06 Imperial 25 8   108
5666 92273 92273: Seeley 2021-04-06 Imperial 25 197   1704
5667 92274 92274: Thermal 2021-04-06 Imperial 25 523   15118
5668 92275 92275: Salton City 2021-04-06 Imperial 25 37   2456
5669 92281 92281: Westmorland 2021-04-06 Imperial 25 249   2859
5670 92283 92283: Winterhaven 2021-04-06 Imperial 25 322   1694
7025 92004 92004: Borrego Springs 2021-04-05 Imperial 25 154   2414
7026 92222 92222: Bard 2021-04-05 Imperial 25 8   0
7027 92227 92227: Brawley 2021-04-05 Imperial 25 4165   27255
7028 92231 92231: Calexico 2021-04-05 Imperial 25 7002   40019
7029 92233 92233: Calipatria 2021-04-05 Imperial 25 539   7618
7030 92243 92243: El Centro 2021-04-05 Imperial 25 6920   50484
7031 92244 92244: El Centro 2021-04-05 Imperial 25 92   0
7032 92249 92249: Heber 2021-04-05 Imperial 25 1106   7898
7033 92250 92250: Holtville 2021-04-05 Imperial 25 1024   8979
7034 92251 92251: Imperial 2021-04-05 Imperial 25 2832   23388

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);