latimes_place_totals

Table actions
⚠️ 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 "date" is on date 2020-09-28 and fips = 37 sorted by date descending

✎ View and edit SQL

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

fips 1

  • 37 · 353 ✖

county 1

Link rowid id name date ▲ county fips confirmed_cases note population
1035834 1035834 90802 90802: Long Beach 2020-09-28 Los Angeles 37 978   39453
1035835 1035835 90803 90803: Long Beach 2020-09-28 Los Angeles 37 420   32389
1035836 1035836 90804 90804: Long Beach 2020-09-28 Los Angeles 37 1015   39344
1035837 1035837 90805 90805: Long Beach 2020-09-28 Los Angeles 37 2827   96708
1035838 1035838 90806 90806: Long Beach 2020-09-28 Los Angeles 37 1384   42817
1035839 1035839 90807 90807: Long Beach 2020-09-28 Los Angeles 37 605   32067
1035840 1035840 90808 90808: Long Beach 2020-09-28 Los Angeles 37 476   38860
1035841 1035841 90810 90810: Long Beach 2020-09-28 Los Angeles 37 1069   38579
1035842 1035842 90813 90813: Long Beach 2020-09-28 Los Angeles 37 2054   59000
1035843 1035843 90814 90814: Long Beach 2020-09-28 Los Angeles 37 255   18587
1035844 1035844 90815 90815: Long Beach 2020-09-28 Los Angeles 37 651   41026
1035845 1035845 91101 91101: Pasadena 2020-09-28 Los Angeles 37 0   20719
1035846 1035846 91103 91103: Pasadena 2020-09-28 Los Angeles 37 0   28435
1035847 1035847 91104 91104: Pasadena 2020-09-28 Los Angeles 37 0   39178
1035848 1035848 91105 91105: Pasadena 2020-09-28 Los Angeles 37 0   11907
1035849 1035849 91106 91106: Pasadena 2020-09-28 Los Angeles 37 0   25479
1035850 1035850 91107 91107: Pasadena 2020-09-28 Los Angeles 37 0   321
1035851 1035851 City of Agoura Hills Agoura Hills 2020-09-28 Los Angeles 37 161   20883
1035852 1035852 City of Alhambra Alhambra 2020-09-28 Los Angeles 37 1265   86724
1035853 1035853 City of Arcadia Arcadia 2020-09-28 Los Angeles 37 504   57754
1035854 1035854 City of Artesia Artesia 2020-09-28 Los Angeles 37 379   16795
1035855 1035855 City of Avalon Avalon 2020-09-28 Los Angeles 37 6   3869
1035856 1035856 City of Azusa Azusa 2020-09-28 Los Angeles 37 1543   50040
1035857 1035857 City of Baldwin Park Baldwin Park 2020-09-28 Los Angeles 37 3008   76769
1035858 1035858 City of Bell Bell 2020-09-28 Los Angeles 37 1612   36332
1035859 1035859 City of Bell Gardens Bell Gardens 2020-09-28 Los Angeles 37 1961   43071
1035860 1035860 City of Bellflower Bellflower 2020-09-28 Los Angeles 37 2389   77735
1035861 1035861 City of Beverly Hills Beverly Hills 2020-09-28 Los Angeles 37 691   34520
1035862 1035862 City of Bradbury Bradbury 2020-09-28 Los Angeles 37 14   1069
1035863 1035863 City of Burbank Burbank 2020-09-28 Los Angeles 37 1565   107180
1035864 1035864 City of Calabasas Calabasas 2020-09-28 Los Angeles 37 269   24323
1035865 1035865 City of Carson Carson 2020-09-28 Los Angeles 37 1846   93846
1035866 1035866 City of Cerritos Cerritos 2020-09-28 Los Angeles 37 569   50067
1035867 1035867 City of Claremont Claremont 2020-09-28 Los Angeles 37 384   36484
1035868 1035868 City of Commerce Commerce 2020-09-28 Los Angeles 37 589   13069
1035869 1035869 City of Compton Compton 2020-09-28 Los Angeles 37 4065   99904
1035870 1035870 City of Covina Covina 2020-09-28 Los Angeles 37 1418   49032
1035871 1035871 City of Cudahy Cudahy 2020-09-28 Los Angeles 37 1103   24347
1035872 1035872 City of Culver City Culver City 2020-09-28 Los Angeles 37 385   39865
1035873 1035873 City of Diamond Bar Diamond Bar 2020-09-28 Los Angeles 37 553   57515
1035874 1035874 City of Downey Downey 2020-09-28 Los Angeles 37 4134   114263
1035875 1035875 City of Duarte Duarte 2020-09-28 Los Angeles 37 571   22016
1035876 1035876 City of El Monte El Monte 2020-09-28 Los Angeles 37 4349   117269
1035877 1035877 City of El Segundo El Segundo 2020-09-28 Los Angeles 37 131   16786
1035878 1035878 City of Gardena Gardena 2020-09-28 Los Angeles 37 1249   61310
1035879 1035879 City of Glendale Glendale 2020-09-28 Los Angeles 37 3749   206493
1035880 1035880 City of Glendora Glendora 2020-09-28 Los Angeles 37 1258   52764
1035881 1035881 City of Hawaiian Gardens Hawaiian Gardens 2020-09-28 Los Angeles 37 536   14676
1035882 1035882 City of Hawthorne Hawthorne 2020-09-28 Los Angeles 37 1942   88787
1035883 1035883 City of Hermosa Beach Hermosa Beach 2020-09-28 Los Angeles 37 211   19670
1035884 1035884 City of Hidden Hills Hidden Hills 2020-09-28 Los Angeles 37 7   1890
1035885 1035885 City of Huntington Park Huntington Park 2020-09-28 Los Angeles 37 2952   59484
1035886 1035886 City of Industry Industry 2020-09-28 Los Angeles 37 37   437
1035887 1035887 City of Inglewood Inglewood 2020-09-28 Los Angeles 37 2877   113582
1035888 1035888 City of Irwindale Irwindale 2020-09-28 Los Angeles 37 68   1459
1035889 1035889 City of La Canada Flintridge La Canada Flintridge 2020-09-28 Los Angeles 37 183   20693
1035890 1035890 City of La Habra Heights La Habra Heights 2020-09-28 Los Angeles 37 44   5455
1035891 1035891 City of La Mirada La Mirada 2020-09-28 Los Angeles 37 847   49599
1035892 1035892 City of La Puente La Puente 2020-09-28 Los Angeles 37 1505   40697
1035893 1035893 City of La Verne La Verne 2020-09-28 Los Angeles 37 467   33282
1035894 1035894 City of Lakewood Lakewood 2020-09-28 Los Angeles 37 1289   80362
1035895 1035895 City of Lancaster Lancaster 2020-09-28 Los Angeles 37 3422   161570
1035896 1035896 City of Lawndale Lawndale 2020-09-28 Los Angeles 37 634   33614
1035897 1035897 City of Lomita Lomita 2020-09-28 Los Angeles 37 240   20729
1035898 1035898 City of Lynwood Lynwood 2020-09-28 Los Angeles 37 3319   72047
1035899 1035899 City of Malibu Malibu 2020-09-28 Los Angeles 37 103   12961
1035900 1035900 City of Manhattan Beach Manhattan Beach 2020-09-28 Los Angeles 37 362   35999
1035901 1035901 City of Maywood Maywood 2020-09-28 Los Angeles 37 1442   28049
1035902 1035902 City of Monrovia Monrovia 2020-09-28 Los Angeles 37 750   38800
1035903 1035903 City of Montebello Montebello 2020-09-28 Los Angeles 37 2319   64375
1035904 1035904 City of Monterey Park Monterey Park 2020-09-28 Los Angeles 37 970   62262
1035905 1035905 City of Norwalk Norwalk 2020-09-28 Los Angeles 37 3290   107622
1035906 1035906 City of Palmdale Palmdale 2020-09-28 Los Angeles 37 4123   158968
1035907 1035907 City of Palos Verdes Estates Palos Verdes Estates 2020-09-28 Los Angeles 37 99   13522
1035908 1035908 City of Paramount Paramount 2020-09-28 Los Angeles 37 2407   56023
1035909 1035909 City of Pico Rivera Pico Rivera 2020-09-28 Los Angeles 37 2433   64284
1035910 1035910 City of Pomona Pomona 2020-09-28 Los Angeles 37 5521   155931
1035911 1035911 City of Rancho Palos Verdes Rancho Palos Verdes 2020-09-28 Los Angeles 37 303   42747
1035912 1035912 City of Redondo Beach Redondo Beach 2020-09-28 Los Angeles 37 558   68697
1035913 1035913 City of Rolling Hills Rolling Hills 2020-09-28 Los Angeles 37 12   1940
1035914 1035914 City of Rolling Hills Estates Rolling Hills Estates 2020-09-28 Los Angeles 37 43   8113
1035915 1035915 City of Rosemead Rosemead 2020-09-28 Los Angeles 37 829   55350
1035916 1035916 City of San Dimas San Dimas 2020-09-28 Los Angeles 37 535   34516
1035917 1035917 City of San Fernando San Fernando 2020-09-28 Los Angeles 37 937   24612
1035918 1035918 City of San Gabriel San Gabriel 2020-09-28 Los Angeles 37 639   40954
1035919 1035919 City of San Marino San Marino 2020-09-28 Los Angeles 37 90   13277
1035920 1035920 City of Santa Clarita Santa Clarita 2020-09-28 Los Angeles 37 3469   220424
1035921 1035921 City of Santa Fe Springs Santa Fe Springs 2020-09-28 Los Angeles 37 567   18364
1035922 1035922 City of Santa Monica Santa Monica 2020-09-28 Los Angeles 37 876   92446
1035923 1035923 City of Sierra Madre Sierra Madre 2020-09-28 Los Angeles 37 76   10989
1035924 1035924 City of Signal Hill Signal Hill 2020-09-28 Los Angeles 37 275   11797
1035925 1035925 City of South El Monte South El Monte 2020-09-28 Los Angeles 37 797   20885
1035926 1035926 City of South Gate South Gate 2020-09-28 Los Angeles 37 4469   98155
1035927 1035927 City of South Pasadena South Pasadena 2020-09-28 Los Angeles 37 281   26053
1035928 1035928 City of Temple City Temple City 2020-09-28 Los Angeles 37 526   36455
1035929 1035929 City of Torrance Torrance 2020-09-28 Los Angeles 37 1434   149268
1035930 1035930 City of Vernon Vernon 2020-09-28 Los Angeles 37 12   209
1035931 1035931 City of Walnut Walnut 2020-09-28 Los Angeles 37 277   30532
1035932 1035932 City of West Covina West Covina 2020-09-28 Los Angeles 37 2888   108235
1035933 1035933 City of West Hollywood West Hollywood 2020-09-28 Los Angeles 37 564   36951

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
);