⚠️ 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,586 rows where fips = "" sorted by date descending

View and edit SQL

Suggested facets: x, y, population

county

fips

  • - · 2,586
Link rowid date ▲ county fips place confirmed_cases note x y population
231 2021-01-14 Long Beach   90802: Long Beach 3040   -118.194003 33.769156 39453
232 2021-01-14 Long Beach   90803: Long Beach 1472   -118.139478 33.760214 32389
233 2021-01-14 Long Beach   90804: Long Beach 3617   -118.155654 33.782746 39344
234 2021-01-14 Long Beach   90805: Long Beach 10433   -118.177401 33.866266 96708
235 2021-01-14 Long Beach   90806: Long Beach 4861   -118.195749 33.804492 42817
236 2021-01-14 Long Beach   90807: Long Beach 2241   -118.182104 33.832434 32067
237 2021-01-14 Long Beach   90808: Long Beach 2041   -118.113299 33.823521 38860
238 2021-01-14 Long Beach   90810: Long Beach 3670   -118.216885 33.810148 38579
239 2021-01-14 Long Beach   90813: Long Beach 6291   -118.187759 33.783222 59000
240 2021-01-14 Long Beach   90814: Long Beach 1008   -118.144793 33.771725 18587
241 2021-01-14 Long Beach   90815: Long Beach 2203   -118.117951 33.796833 41026
759 2021-01-14 Pasadena   91101: Pasadena 1098   -118.138869 34.146615 20719
760 2021-01-14 Pasadena   91103: Pasadena 3000   -118.164825 34.166847 28435
761 2021-01-14 Pasadena   91104: Pasadena 1917   -118.123449 34.168028 39178
762 2021-01-14 Pasadena   91105: Pasadena 573   -118.167933 34.139851 11907
763 2021-01-14 Pasadena   91106: Pasadena 1198   -118.127601 34.139064 25479
764 2021-01-14 Pasadena   91107: Pasadena 996   -118.087236 34.158855 321
1560 2021-01-13 Long Beach   90802: Long Beach 3040   -118.194003 33.769156 39453
1561 2021-01-13 Long Beach   90803: Long Beach 1472   -118.139478 33.760214 32389
1562 2021-01-13 Long Beach   90804: Long Beach 3617   -118.155654 33.782746 39344
1563 2021-01-13 Long Beach   90805: Long Beach 10433   -118.177401 33.866266 96708
1564 2021-01-13 Long Beach   90806: Long Beach 4861   -118.195749 33.804492 42817
1565 2021-01-13 Long Beach   90807: Long Beach 2241   -118.182104 33.832434 32067
1566 2021-01-13 Long Beach   90808: Long Beach 2041   -118.113299 33.823521 38860
1567 2021-01-13 Long Beach   90810: Long Beach 3670   -118.216885 33.810148 38579
1568 2021-01-13 Long Beach   90813: Long Beach 6291   -118.187759 33.783222 59000
1569 2021-01-13 Long Beach   90814: Long Beach 1008   -118.144793 33.771725 18587
1570 2021-01-13 Long Beach   90815: Long Beach 2203   -118.117951 33.796833 41026
2088 2021-01-13 Pasadena   91101: Pasadena 1098   -118.138869 34.146615 20719
2089 2021-01-13 Pasadena   91103: Pasadena 3000   -118.164825 34.166847 28435
2090 2021-01-13 Pasadena   91104: Pasadena 1917   -118.123449 34.168028 39178
2091 2021-01-13 Pasadena   91105: Pasadena 573   -118.167933 34.139851 11907
2092 2021-01-13 Pasadena   91106: Pasadena 1198   -118.127601 34.139064 25479
2093 2021-01-13 Pasadena   91107: Pasadena 996   -118.087236 34.158855 321
2906 2021-01-12 Long Beach   90802: Long Beach 3007   -118.194003 33.769156 39453
2907 2021-01-12 Long Beach   90803: Long Beach 1453   -118.139478 33.760214 32389
2908 2021-01-12 Long Beach   90804: Long Beach 3557   -118.155654 33.782746 39344
2909 2021-01-12 Long Beach   90805: Long Beach 10300   -118.177401 33.866266 96708
2910 2021-01-12 Long Beach   90806: Long Beach 4793   -118.195749 33.804492 42817
2911 2021-01-12 Long Beach   90807: Long Beach 2229   -118.182104 33.832434 32067
2912 2021-01-12 Long Beach   90808: Long Beach 2013   -118.113299 33.823521 38860
2913 2021-01-12 Long Beach   90810: Long Beach 3631   -118.216885 33.810148 38579
2914 2021-01-12 Long Beach   90813: Long Beach 6203   -118.187759 33.783222 59000
2915 2021-01-12 Long Beach   90814: Long Beach 987   -118.144793 33.771725 18587
2916 2021-01-12 Long Beach   90815: Long Beach 2175   -118.117951 33.796833 41026
3434 2021-01-12 Pasadena   91101: Pasadena 1082   -118.138869 34.146615 20719
3435 2021-01-12 Pasadena   91103: Pasadena 2962   -118.164825 34.166847 28435
3436 2021-01-12 Pasadena   91104: Pasadena 1889   -118.123449 34.168028 39178
3437 2021-01-12 Pasadena   91105: Pasadena 570   -118.167933 34.139851 11907
3438 2021-01-12 Pasadena   91106: Pasadena 1184   -118.127601 34.139064 25479
3439 2021-01-12 Pasadena   91107: Pasadena 984   -118.087236 34.158855 321
4240 2021-01-11 Long Beach   90802: Long Beach 2869   -118.194003 33.769156 39453
4241 2021-01-11 Long Beach   90803: Long Beach 1371   -118.139478 33.760214 32389
4242 2021-01-11 Long Beach   90804: Long Beach 3323   -118.155654 33.782746 39344
4243 2021-01-11 Long Beach   90805: Long Beach 9661   -118.177401 33.866266 96708
4244 2021-01-11 Long Beach   90806: Long Beach 4500   -118.195749 33.804492 42817
4245 2021-01-11 Long Beach   90807: Long Beach 2073   -118.182104 33.832434 32067
4246 2021-01-11 Long Beach   90808: Long Beach 1899   -118.113299 33.823521 38860
4247 2021-01-11 Long Beach   90810: Long Beach 3396   -118.216885 33.810148 38579
4248 2021-01-11 Long Beach   90813: Long Beach 5840   -118.187759 33.783222 59000
4249 2021-01-11 Long Beach   90814: Long Beach 935   -118.144793 33.771725 18587
4250 2021-01-11 Long Beach   90815: Long Beach 2056   -118.117951 33.796833 41026
4768 2021-01-11 Pasadena   91101: Pasadena 1060   -118.138869 34.146615 20719
4769 2021-01-11 Pasadena   91103: Pasadena 2916   -118.164825 34.166847 28435
4770 2021-01-11 Pasadena   91104: Pasadena 1823   -118.123449 34.168028 39178
4771 2021-01-11 Pasadena   91105: Pasadena 555   -118.167933 34.139851 11907
4772 2021-01-11 Pasadena   91106: Pasadena 1167   -118.127601 34.139064 25479
4773 2021-01-11 Pasadena   91107: Pasadena 954   -118.087236 34.158855 321
5566 2021-01-10 Long Beach   90802: Long Beach 2862   -118.194003 33.769156 39453
5567 2021-01-10 Long Beach   90803: Long Beach 1369   -118.139478 33.760214 32389
5568 2021-01-10 Long Beach   90804: Long Beach 3295   -118.155654 33.782746 39344
5569 2021-01-10 Long Beach   90805: Long Beach 9641   -118.177401 33.866266 96708
5570 2021-01-10 Long Beach   90806: Long Beach 4500   -118.195749 33.804492 42817
5571 2021-01-10 Long Beach   90807: Long Beach 2068   -118.182104 33.832434 32067
5572 2021-01-10 Long Beach   90808: Long Beach 1898   -118.113299 33.823521 38860
5573 2021-01-10 Long Beach   90810: Long Beach 3388   -118.216885 33.810148 38579
5574 2021-01-10 Long Beach   90813: Long Beach 5836   -118.187759 33.783222 59000
5575 2021-01-10 Long Beach   90814: Long Beach 934   -118.144793 33.771725 18587
5576 2021-01-10 Long Beach   90815: Long Beach 2052   -118.117951 33.796833 41026
6094 2021-01-10 Pasadena   91101: Pasadena 1041   -118.138869 34.146615 20719
6095 2021-01-10 Pasadena   91103: Pasadena 2881   -118.164825 34.166847 28435
6096 2021-01-10 Pasadena   91104: Pasadena 1794   -118.123449 34.168028 39178
6097 2021-01-10 Pasadena   91105: Pasadena 549   -118.167933 34.139851 11907
6098 2021-01-10 Pasadena   91106: Pasadena 1156   -118.127601 34.139064 25479
6099 2021-01-10 Pasadena   91107: Pasadena 935   -118.087236 34.158855 321
6820 2021-01-09 Long Beach   90802: Long Beach 2862   -118.194003 33.769156 39453
6821 2021-01-09 Long Beach   90803: Long Beach 1369   -118.139478 33.760214 32389
6822 2021-01-09 Long Beach   90804: Long Beach 3295   -118.155654 33.782746 39344
6823 2021-01-09 Long Beach   90805: Long Beach 9641   -118.177401 33.866266 96708
6824 2021-01-09 Long Beach   90806: Long Beach 4500   -118.195749 33.804492 42817
6825 2021-01-09 Long Beach   90807: Long Beach 2068   -118.182104 33.832434 32067
6826 2021-01-09 Long Beach   90808: Long Beach 1898   -118.113299 33.823521 38860
6827 2021-01-09 Long Beach   90810: Long Beach 3388   -118.216885 33.810148 38579
6828 2021-01-09 Long Beach   90813: Long Beach 5836   -118.187759 33.783222 59000
6829 2021-01-09 Long Beach   90814: Long Beach 934   -118.144793 33.771725 18587
6830 2021-01-09 Long Beach   90815: Long Beach 2052   -118.117951 33.796833 41026
7348 2021-01-09 Pasadena   91101: Pasadena 1027   -118.138869 34.146615 20719
7349 2021-01-09 Pasadena   91103: Pasadena 2840   -118.164825 34.166847 28435
7350 2021-01-09 Pasadena   91104: Pasadena 1757   -118.123449 34.168028 39178
7351 2021-01-09 Pasadena   91105: Pasadena 542   -118.167933 34.139851 11907

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,
   [population] TEXT
);