covid: latimes_place_totals: 353 rows where county = "Los Angeles", "date" is on date 2021-10-31 and fips = 37 sorted by date descending

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

353 rows where county = "Los Angeles", "date" is on date 2021-10-31 and fips = 37 sorted by date descending

descending

✎ View and edit SQL

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

Link	rowid	id	name	date ▲	county	fips	confirmed_cases	population
534374	534374	90802	90802: Long Beach	2021-10-31	Los Angeles	37	4928	39453
534375	534375	90803	90803: Long Beach	2021-10-31	Los Angeles	37	2559	32389
534376	534376	90804	90804: Long Beach	2021-10-31	Los Angeles	37	5592	39344
534377	534377	90805	90805: Long Beach	2021-10-31	Los Angeles	37	16188	96708
534378	534378	90806	90806: Long Beach	2021-10-31	Los Angeles	37	7384	42817
534379	534379	90807	90807: Long Beach	2021-10-31	Los Angeles	37	3708	32067
534380	534380	90808	90808: Long Beach	2021-10-31	Los Angeles	37	3596	38860
534381	534381	90810	90810: Long Beach	2021-10-31	Los Angeles	37	5288	38579
534382	534382	90813	90813: Long Beach	2021-10-31	Los Angeles	37	9332	59000
534383	534383	90814	90814: Long Beach	2021-10-31	Los Angeles	37	1776	18587
534384	534384	90815	90815: Long Beach	2021-10-31	Los Angeles	37	3803	41026
534385	534385	91101	91101: Pasadena	2021-10-31	Los Angeles	37	1718	20719
534386	534386	91103	91103: Pasadena	2021-10-31	Los Angeles	37	4114	28435
534387	534387	91104	91104: Pasadena	2021-10-31	Los Angeles	37	3073	39178
534388	534388	91105	91105: Pasadena	2021-10-31	Los Angeles	37	889	11907
534389	534389	91106	91106: Pasadena	2021-10-31	Los Angeles	37	1958	25479
534390	534390	91107	91107: Pasadena	2021-10-31	Los Angeles	37	1692	321
534391	534391	City of Agoura Hills	Agoura Hills	2021-10-31	Los Angeles	37	1473	20883
534392	534392	City of Alhambra	Alhambra	2021-10-31	Los Angeles	37	8281	86724
534393	534393	City of Arcadia	Arcadia	2021-10-31	Los Angeles	37	3406	57754
534394	534394	City of Artesia	Artesia	2021-10-31	Los Angeles	37	2451	16795
534395	534395	City of Avalon	Avalon	2021-10-31	Los Angeles	37	32	3869
534396	534396	City of Azusa	Azusa	2021-10-31	Los Angeles	37	7492	50040
534397	534397	City of Baldwin Park	Baldwin Park	2021-10-31	Los Angeles	37	14724	76769
534398	534398	City of Bell	Bell	2021-10-31	Los Angeles	37	7596	36332
534399	534399	City of Bell Gardens	Bell Gardens	2021-10-31	Los Angeles	37	9118	43071
534400	534400	City of Bellflower	Bellflower	2021-10-31	Los Angeles	37	13073	77735
534401	534401	City of Beverly Hills	Beverly Hills	2021-10-31	Los Angeles	37	3660	34520
534402	534402	City of Bradbury	Bradbury	2021-10-31	Los Angeles	37	42	1069
534403	534403	City of Burbank	Burbank	2021-10-31	Los Angeles	37	11336	107180
534404	534404	City of Calabasas	Calabasas	2021-10-31	Los Angeles	37	1806	24323
534405	534405	City of Carson	Carson	2021-10-31	Los Angeles	37	12187	93846
534406	534406	City of Cerritos	Cerritos	2021-10-31	Los Angeles	37	3807	50067
534407	534407	City of Claremont	Claremont	2021-10-31	Los Angeles	37	2884	36484
534408	534408	City of Commerce	Commerce	2021-10-31	Los Angeles	37	2713	13069
534409	534409	City of Compton	Compton	2021-10-31	Los Angeles	37	19740	99904
534410	534410	City of Covina	Covina	2021-10-31	Los Angeles	37	7757	49032
534411	534411	City of Cudahy	Cudahy	2021-10-31	Los Angeles	37	5401	24347
534412	534412	City of Culver City	Culver City	2021-10-31	Los Angeles	37	2966	39865
534413	534413	City of Diamond Bar	Diamond Bar	2021-10-31	Los Angeles	37	4054	57515
534414	534414	City of Downey	Downey	2021-10-31	Los Angeles	37	20591	114263
534415	534415	City of Duarte	Duarte	2021-10-31	Los Angeles	37	2788	22016
534416	534416	City of El Monte	El Monte	2021-10-31	Los Angeles	37	19189	117269
534417	534417	City of El Segundo	El Segundo	2021-10-31	Los Angeles	37	1085	16786
534418	534418	City of Gardena	Gardena	2021-10-31	Los Angeles	37	7924	61310
534419	534419	City of Glendale	Glendale	2021-10-31	Los Angeles	37	25035	206493
534420	534420	City of Glendora	Glendora	2021-10-31	Los Angeles	37	6016	52764
534421	534421	City of Hawaiian Gardens	Hawaiian Gardens	2021-10-31	Los Angeles	37	2586	14676
534422	534422	City of Hawthorne	Hawthorne	2021-10-31	Los Angeles	37	12734	88787
534423	534423	City of Hermosa Beach	Hermosa Beach	2021-10-31	Los Angeles	37	1599	19670
534424	534424	City of Hidden Hills	Hidden Hills	2021-10-31	Los Angeles	37	136	1890
534425	534425	City of Huntington Park	Huntington Park	2021-10-31	Los Angeles	37	12460	59484
534426	534426	City of Industry	Industry	2021-10-31	Los Angeles	37	194	437
534427	534427	City of Inglewood	Inglewood	2021-10-31	Los Angeles	37	16885	113582
534428	534428	City of Irwindale	Irwindale	2021-10-31	Los Angeles	37	306	1459
534429	534429	City of La Canada Flintridge	La Canada Flintridge	2021-10-31	Los Angeles	37	1115	20693
534430	534430	City of La Habra Heights	La Habra Heights	2021-10-31	Los Angeles	37	131	5455
534431	534431	City of La Mirada	La Mirada	2021-10-31	Los Angeles	37	5438	49599
534432	534432	City of La Puente	La Puente	2021-10-31	Los Angeles	37	7544	40697
534433	534433	City of La Verne	La Verne	2021-10-31	Los Angeles	37	3587	33282
534434	534434	City of Lakewood	Lakewood	2021-10-31	Los Angeles	37	9473	80362
534435	534435	City of Lancaster	Lancaster	2021-10-31	Los Angeles	37	28874	161570
534436	534436	City of Lawndale	Lawndale	2021-10-31	Los Angeles	37	4318	33614
534437	534437	City of Lomita	Lomita	2021-10-31	Los Angeles	37	1969	20729
534438	534438	City of Lynwood	Lynwood	2021-10-31	Los Angeles	37	15036	72047
534439	534439	City of Malibu	Malibu	2021-10-31	Los Angeles	37	682	12961
534440	534440	City of Manhattan Beach	Manhattan Beach	2021-10-31	Los Angeles	37	2113	35999
534441	534441	City of Maywood	Maywood	2021-10-31	Los Angeles	37	5796	28049
534442	534442	City of Monrovia	Monrovia	2021-10-31	Los Angeles	37	4050	38800
534443	534443	City of Montebello	Montebello	2021-10-31	Los Angeles	37	11598	64375
534444	534444	City of Monterey Park	Monterey Park	2021-10-31	Los Angeles	37	5639	62262
534445	534445	City of Norwalk	Norwalk	2021-10-31	Los Angeles	37	18649	107622
534446	534446	City of Palmdale	Palmdale	2021-10-31	Los Angeles	37	30023	158968
534447	534447	City of Palos Verdes Estates	Palos Verdes Estates	2021-10-31	Los Angeles	37	682	13522
534448	534448	City of Paramount	Paramount	2021-10-31	Los Angeles	37	11456	56023
534449	534449	City of Pico Rivera	Pico Rivera	2021-10-31	Los Angeles	37	12650	64284
534450	534450	City of Pomona	Pomona	2021-10-31	Los Angeles	37	29462	155931
534451	534451	City of Rancho Palos Verdes	Rancho Palos Verdes	2021-10-31	Los Angeles	37	2160	42747
534452	534452	City of Redondo Beach	Redondo Beach	2021-10-31	Los Angeles	37	4185	68697
534453	534453	City of Rolling Hills	Rolling Hills	2021-10-31	Los Angeles	37	85	1940
534454	534454	City of Rolling Hills Estates	Rolling Hills Estates	2021-10-31	Los Angeles	37	441	8113
534455	534455	City of Rosemead	Rosemead	2021-10-31	Los Angeles	37	5633	55350
534456	534456	City of San Dimas	San Dimas	2021-10-31	Los Angeles	37	4021	34516
534457	534457	City of San Fernando	San Fernando	2021-10-31	Los Angeles	37	6035	24612
534458	534458	City of San Gabriel	San Gabriel	2021-10-31	Los Angeles	37	3707	40954
534459	534459	City of San Marino	San Marino	2021-10-31	Los Angeles	37	476	13277
534460	534460	City of Santa Clarita	Santa Clarita	2021-10-31	Los Angeles	37	27519	220424
534461	534461	City of Santa Fe Springs	Santa Fe Springs	2021-10-31	Los Angeles	37	3403	18364
534462	534462	City of Santa Monica	Santa Monica	2021-10-31	Los Angeles	37	6786	92446
534463	534463	City of Sierra Madre	Sierra Madre	2021-10-31	Los Angeles	37	655	10989
534464	534464	City of Signal Hill	Signal Hill	2021-10-31	Los Angeles	37	1476	11797
534465	534465	City of South El Monte	South El Monte	2021-10-31	Los Angeles	37	3859	20885
534466	534466	City of South Gate	South Gate	2021-10-31	Los Angeles	37	21284	98155
534467	534467	City of South Pasadena	South Pasadena	2021-10-31	Los Angeles	37	1737	26053
534468	534468	City of Temple City	Temple City	2021-10-31	Los Angeles	37	2786	36455
534469	534469	City of Torrance	Torrance	2021-10-31	Los Angeles	37	9834	149268
534470	534470	City of Vernon	Vernon	2021-10-31	Los Angeles	37	141	209
534471	534471	City of Walnut	Walnut	2021-10-31	Los Angeles	37	2155	30532
534472	534472	City of West Covina	West Covina	2021-10-31	Los Angeles	37	15358	108235
534473	534473	City of West Hollywood	West Hollywood	2021-10-31	Los Angeles	37	3657	36951

Advanced export

JSON shape: default, array, newline-delimited

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