home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for 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

14,399 rows where fips = 25 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 1

  • 25 · 14,399 ✖

county 1

  • Imperial 14,399
Link rowid id name date ▲ county fips confirmed_cases note population
132 132 92259 92259: Ocotillo 2022-08-19 Imperial 25 28   94
133 133 92266 92266: Palo Verde 2022-08-19 Imperial 25 15   108
134 134 92273 92273: Seeley 2022-08-19 Imperial 25 412   1704
135 135 92274 92274: Thermal 2022-08-19 Imperial 25 1062   15118
136 136 92275 92275: Salton City 2022-08-19 Imperial 25 67   2456
137 137 92281 92281: Westmorland 2022-08-19 Imperial 25 590   2859
138 138 92283 92283: Winterhaven 2022-08-19 Imperial 25 807   1694
139 139 92222 92222: Bard 2022-08-19 Imperial 25 13   0
140 140 92227 92227: Brawley 2022-08-19 Imperial 25 9207   27255
141 141 92231 92231: Calexico 2022-08-19 Imperial 25 13571   40019
142 142 92233 92233: Calipatria 2022-08-19 Imperial 25 1090   7618
143 143 92243 92243: El Centro 2022-08-19 Imperial 25 14004   50484
144 144 92244 92244: El Centro 2022-08-19 Imperial 25 225   0
145 145 92249 92249: Heber 2022-08-19 Imperial 25 2127   7898
146 146 92250 92250: Holtville 2022-08-19 Imperial 25 2038   8979
147 147 92251 92251: Imperial 2022-08-19 Imperial 25 6493   23388
148 148 92257 92257: Niland 2022-08-19 Imperial 25 319   1332
1355 1355 92259 92259: Ocotillo 2022-08-18 Imperial 25 28   94
1356 1356 92266 92266: Palo Verde 2022-08-18 Imperial 25 15   108
1357 1357 92273 92273: Seeley 2022-08-18 Imperial 25 412   1704
1358 1358 92274 92274: Thermal 2022-08-18 Imperial 25 1062   15118
1359 1359 92275 92275: Salton City 2022-08-18 Imperial 25 67   2456
1360 1360 92281 92281: Westmorland 2022-08-18 Imperial 25 590   2859
1361 1361 92283 92283: Winterhaven 2022-08-18 Imperial 25 807   1694
1362 1362 92222 92222: Bard 2022-08-18 Imperial 25 13   0
1363 1363 92227 92227: Brawley 2022-08-18 Imperial 25 9207   27255
1364 1364 92231 92231: Calexico 2022-08-18 Imperial 25 13571   40019
1365 1365 92233 92233: Calipatria 2022-08-18 Imperial 25 1090   7618
1366 1366 92243 92243: El Centro 2022-08-18 Imperial 25 14004   50484
1367 1367 92244 92244: El Centro 2022-08-18 Imperial 25 225   0
1368 1368 92249 92249: Heber 2022-08-18 Imperial 25 2127   7898
1369 1369 92250 92250: Holtville 2022-08-18 Imperial 25 2038   8979
1370 1370 92251 92251: Imperial 2022-08-18 Imperial 25 6493   23388
1371 1371 92257 92257: Niland 2022-08-18 Imperial 25 319   1332
2593 2593 92259 92259: Ocotillo 2022-08-17 Imperial 25 28   94
2594 2594 92266 92266: Palo Verde 2022-08-17 Imperial 25 15   108
2595 2595 92273 92273: Seeley 2022-08-17 Imperial 25 412   1704
2596 2596 92274 92274: Thermal 2022-08-17 Imperial 25 1062   15118
2597 2597 92275 92275: Salton City 2022-08-17 Imperial 25 67   2456
2598 2598 92281 92281: Westmorland 2022-08-17 Imperial 25 590   2859
2599 2599 92283 92283: Winterhaven 2022-08-17 Imperial 25 807   1694
2600 2600 92222 92222: Bard 2022-08-17 Imperial 25 13   0
2601 2601 92227 92227: Brawley 2022-08-17 Imperial 25 9207   27255
2602 2602 92231 92231: Calexico 2022-08-17 Imperial 25 13571   40019
2603 2603 92233 92233: Calipatria 2022-08-17 Imperial 25 1090   7618
2604 2604 92243 92243: El Centro 2022-08-17 Imperial 25 14004   50484
2605 2605 92244 92244: El Centro 2022-08-17 Imperial 25 225   0
2606 2606 92249 92249: Heber 2022-08-17 Imperial 25 2127   7898
2607 2607 92250 92250: Holtville 2022-08-17 Imperial 25 2038   8979
2608 2608 92251 92251: Imperial 2022-08-17 Imperial 25 6493   23388
2609 2609 92257 92257: Niland 2022-08-17 Imperial 25 319   1332
3831 3831 92259 92259: Ocotillo 2022-08-16 Imperial 25 28   94
3832 3832 92266 92266: Palo Verde 2022-08-16 Imperial 25 15   108
3833 3833 92273 92273: Seeley 2022-08-16 Imperial 25 412   1704
3834 3834 92274 92274: Thermal 2022-08-16 Imperial 25 1062   15118
3835 3835 92275 92275: Salton City 2022-08-16 Imperial 25 67   2456
3836 3836 92281 92281: Westmorland 2022-08-16 Imperial 25 590   2859
3837 3837 92283 92283: Winterhaven 2022-08-16 Imperial 25 807   1694
3838 3838 92222 92222: Bard 2022-08-16 Imperial 25 13   0
3839 3839 92227 92227: Brawley 2022-08-16 Imperial 25 9207   27255
3840 3840 92231 92231: Calexico 2022-08-16 Imperial 25 13571   40019
3841 3841 92233 92233: Calipatria 2022-08-16 Imperial 25 1090   7618
3842 3842 92243 92243: El Centro 2022-08-16 Imperial 25 14004   50484
3843 3843 92244 92244: El Centro 2022-08-16 Imperial 25 225   0
3844 3844 92249 92249: Heber 2022-08-16 Imperial 25 2127   7898
3845 3845 92250 92250: Holtville 2022-08-16 Imperial 25 2038   8979
3846 3846 92251 92251: Imperial 2022-08-16 Imperial 25 6493   23388
3847 3847 92257 92257: Niland 2022-08-16 Imperial 25 319   1332
5069 5069 92259 92259: Ocotillo 2022-08-15 Imperial 25 28   94
5070 5070 92266 92266: Palo Verde 2022-08-15 Imperial 25 15   108
5071 5071 92273 92273: Seeley 2022-08-15 Imperial 25 412   1704
5072 5072 92274 92274: Thermal 2022-08-15 Imperial 25 1062   15118
5073 5073 92275 92275: Salton City 2022-08-15 Imperial 25 67   2456
5074 5074 92281 92281: Westmorland 2022-08-15 Imperial 25 590   2859
5075 5075 92283 92283: Winterhaven 2022-08-15 Imperial 25 807   1694
5076 5076 92222 92222: Bard 2022-08-15 Imperial 25 13   0
5077 5077 92227 92227: Brawley 2022-08-15 Imperial 25 9207   27255
5078 5078 92231 92231: Calexico 2022-08-15 Imperial 25 13571   40019
5079 5079 92233 92233: Calipatria 2022-08-15 Imperial 25 1090   7618
5080 5080 92243 92243: El Centro 2022-08-15 Imperial 25 14004   50484
5081 5081 92244 92244: El Centro 2022-08-15 Imperial 25 225   0
5082 5082 92249 92249: Heber 2022-08-15 Imperial 25 2127   7898
5083 5083 92250 92250: Holtville 2022-08-15 Imperial 25 2038   8979
5084 5084 92251 92251: Imperial 2022-08-15 Imperial 25 6493   23388
5085 5085 92257 92257: Niland 2022-08-15 Imperial 25 319   1332
6339 6339 92259 92259: Ocotillo 2022-08-14 Imperial 25 28   94
6340 6340 92266 92266: Palo Verde 2022-08-14 Imperial 25 15   108
6341 6341 92273 92273: Seeley 2022-08-14 Imperial 25 412   1704
6342 6342 92274 92274: Thermal 2022-08-14 Imperial 25 1062   15118
6343 6343 92275 92275: Salton City 2022-08-14 Imperial 25 67   2456
6344 6344 92281 92281: Westmorland 2022-08-14 Imperial 25 590   2859
6345 6345 92283 92283: Winterhaven 2022-08-14 Imperial 25 807   1694
6346 6346 92222 92222: Bard 2022-08-14 Imperial 25 13   0
6347 6347 92227 92227: Brawley 2022-08-14 Imperial 25 9207   27255
6348 6348 92231 92231: Calexico 2022-08-14 Imperial 25 13571   40019
6349 6349 92233 92233: Calipatria 2022-08-14 Imperial 25 1090   7618
6350 6350 92243 92243: El Centro 2022-08-14 Imperial 25 14004   50484
6351 6351 92244 92244: El Centro 2022-08-14 Imperial 25 225   0
6352 6352 92249 92249: Heber 2022-08-14 Imperial 25 2127   7898
6353 6353 92250 92250: Holtville 2022-08-14 Imperial 25 2038   8979

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
);
Powered by Datasette · Queries took 1337.726ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals