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

359,354 rows where county = "Los Angeles" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

  • 37 359,354

county 1

  • Los Angeles · 359,354 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
1829 1829 90802 90802: Long Beach 2022-12-28 Los Angeles 37 12038   39453
1830 1830 90803 90803: Long Beach 2022-12-28 Los Angeles 37 7183   32389
1831 1831 90804 90804: Long Beach 2022-12-28 Los Angeles 37 13036   39344
1832 1832 90805 90805: Long Beach 2022-12-28 Los Angeles 37 34282   96708
1833 1833 90806 90806: Long Beach 2022-12-28 Los Angeles 37 15419   42817
1834 1834 90807 90807: Long Beach 2022-12-28 Los Angeles 37 9943   32067
1835 1835 90808 90808: Long Beach 2022-12-28 Los Angeles 37 10628   38860
1836 1836 90810 90810: Long Beach 2022-12-28 Los Angeles 37 11435   38579
1837 1837 90813 90813: Long Beach 2022-12-28 Los Angeles 37 18323   59000
1838 1838 90814 90814: Long Beach 2022-12-28 Los Angeles 37 5128   18587
1839 1839 90815 90815: Long Beach 2022-12-28 Los Angeles 37 11059   41026
1840 1840 91101 91101: Pasadena 2022-12-28 Los Angeles 37 5007   20719
1841 1841 91103 91103: Pasadena 2022-12-28 Los Angeles 37 9781   28435
1842 1842 91104 91104: Pasadena 2022-12-28 Los Angeles 37 8554   39178
1843 1843 91105 91105: Pasadena 2022-12-28 Los Angeles 37 2910   11907
1844 1844 91106 91106: Pasadena 2022-12-28 Los Angeles 37 6203   25479
1845 1845 91107 91107: Pasadena 2022-12-28 Los Angeles 37 5   321
1846 1846 City of Agoura Hills Agoura Hills 2022-12-28 Los Angeles 37 6179   20883
1847 1847 City of Alhambra Alhambra 2022-12-28 Los Angeles 37 24399   86724
1848 1848 City of Arcadia Arcadia 2022-12-28 Los Angeles 37 12838   57754
1849 1849 City of Artesia Artesia 2022-12-28 Los Angeles 37 5721   16795
1850 1850 City of Avalon Avalon 2022-12-28 Los Angeles 37 284   3869
1851 1851 City of Azusa Azusa 2022-12-28 Los Angeles 37 16971   50040
1852 1852 City of Baldwin Park Baldwin Park 2022-12-28 Los Angeles 37 28708   76769
1853 1853 City of Bell Bell 2022-12-28 Los Angeles 37 16593   36332
1854 1854 City of Bell Gardens Bell Gardens 2022-12-28 Los Angeles 37 16718   43071
1855 1855 City of Bellflower Bellflower 2022-12-28 Los Angeles 37 29750   77735
1856 1856 City of Beverly Hills Beverly Hills 2022-12-28 Los Angeles 37 11151   34520
1857 1857 City of Bradbury Bradbury 2022-12-28 Los Angeles 37 69   1069
1858 1858 City of Burbank Burbank 2022-12-28 Los Angeles 37 31542   107180
1859 1859 City of Calabasas Calabasas 2022-12-28 Los Angeles 37 5616   24323
1860 1860 City of Carson Carson 2022-12-28 Los Angeles 37 33665   93846
1861 1861 City of Cerritos Cerritos 2022-12-28 Los Angeles 37 12715   50067
1862 1862 City of Claremont Claremont 2022-12-28 Los Angeles 37 9777   36484
1863 1863 City of Commerce Commerce 2022-12-28 Los Angeles 37 5685   13069
1864 1864 City of Compton Compton 2022-12-28 Los Angeles 37 39160   99904
1865 1865 City of Covina Covina 2022-12-28 Los Angeles 37 19525   49032
1866 1866 City of Cudahy Cudahy 2022-12-28 Los Angeles 37 11960   24347
1867 1867 City of Culver City Culver City 2022-12-28 Los Angeles 37 11253   39865
1868 1868 City of Diamond Bar Diamond Bar 2022-12-28 Los Angeles 37 13047   57515
1869 1869 City of Downey Downey 2022-12-28 Los Angeles 37 45204   114263
1870 1870 City of Duarte Duarte 2022-12-28 Los Angeles 37 7148   22016
1871 1871 City of El Monte El Monte 2022-12-28 Los Angeles 37 41399   117269
1872 1872 City of El Segundo El Segundo 2022-12-28 Los Angeles 37 3933   16786
1873 1873 City of Gardena Gardena 2022-12-28 Los Angeles 37 21138   61310
1874 1874 City of Glendale Glendale 2022-12-28 Los Angeles 37 58108   206493
1875 1875 City of Glendora Glendora 2022-12-28 Los Angeles 37 14506   52764
1876 1876 City of Hawaiian Gardens Hawaiian Gardens 2022-12-28 Los Angeles 37 4877   14676
1877 1877 City of Hawthorne Hawthorne 2022-12-28 Los Angeles 37 28547   88787
1878 1878 City of Hermosa Beach Hermosa Beach 2022-12-28 Los Angeles 37 4582   19670
1879 1879 City of Hidden Hills Hidden Hills 2022-12-28 Los Angeles 37 375   1890
1880 1880 City of Huntington Park Huntington Park 2022-12-28 Los Angeles 37 25760   59484
1881 1881 City of Industry Industry 2022-12-28 Los Angeles 37 966   437
1882 1882 City of Inglewood Inglewood 2022-12-28 Los Angeles 37 37362   113582
1883 1883 City of Irwindale Irwindale 2022-12-28 Los Angeles 37 863   1459
1884 1884 City of La Canada Flintridge La Canada Flintridge 2022-12-28 Los Angeles 37 4377   20693
1885 1885 City of La Habra Heights La Habra Heights 2022-12-28 Los Angeles 37 207   5455
1886 1886 City of La Mirada La Mirada 2022-12-28 Los Angeles 37 13633   49599
1887 1887 City of La Puente La Puente 2022-12-28 Los Angeles 37 15589   40697
1888 1888 City of La Verne La Verne 2022-12-28 Los Angeles 37 8966   33282
1889 1889 City of Lakewood Lakewood 2022-12-28 Los Angeles 37 25959   80362
1890 1890 City of Lancaster Lancaster 2022-12-28 Los Angeles 37 62382   161570
1891 1891 City of Lawndale Lawndale 2022-12-28 Los Angeles 37 10272   33614
1892 1892 City of Lomita Lomita 2022-12-28 Los Angeles 37 5808   20729
1893 1893 City of Lynwood Lynwood 2022-12-28 Los Angeles 37 30322   72047
1894 1894 City of Malibu Malibu 2022-12-28 Los Angeles 37 2764   12961
1895 1895 City of Manhattan Beach Manhattan Beach 2022-12-28 Los Angeles 37 7169   35999
1896 1896 City of Maywood Maywood 2022-12-28 Los Angeles 37 12550   28049
1897 1897 City of Monrovia Monrovia 2022-12-28 Los Angeles 37 11459   38800
1898 1898 City of Montebello Montebello 2022-12-28 Los Angeles 37 24589   64375
1899 1899 City of Monterey Park Monterey Park 2022-12-28 Los Angeles 37 16792   62262
1900 1900 City of Norwalk Norwalk 2022-12-28 Los Angeles 37 41481   107622
1901 1901 City of Palmdale Palmdale 2022-12-28 Los Angeles 37 65217   158968
1902 1902 City of Palos Verdes Estates Palos Verdes Estates 2022-12-28 Los Angeles 37 2154   13522
1903 1903 City of Paramount Paramount 2022-12-28 Los Angeles 37 22033   56023
1904 1904 City of Pico Rivera Pico Rivera 2022-12-28 Los Angeles 37 27037   64284
1905 1905 City of Pomona Pomona 2022-12-28 Los Angeles 37 63412   155931
1906 1906 City of Rancho Palos Verdes Rancho Palos Verdes 2022-12-28 Los Angeles 37 7278   42747
1907 1907 City of Redondo Beach Redondo Beach 2022-12-28 Los Angeles 37 14954   68697
1908 1908 City of Rolling Hills Rolling Hills 2022-12-28 Los Angeles 37 274   1940
1909 1909 City of Rolling Hills Estates Rolling Hills Estates 2022-12-28 Los Angeles 37 1429   8113
1910 1910 City of Rosemead Rosemead 2022-12-28 Los Angeles 37 14749   55350
1911 1911 City of San Dimas San Dimas 2022-12-28 Los Angeles 37 10703   34516
1912 1912 City of San Fernando San Fernando 2022-12-28 Los Angeles 37 12476   24612
1913 1913 City of San Gabriel San Gabriel 2022-12-28 Los Angeles 37 10915   40954
1914 1914 City of San Marino San Marino 2022-12-28 Los Angeles 37 2310   13277
1915 1915 City of Santa Clarita Santa Clarita 2022-12-28 Los Angeles 37 71057   220424
1916 1916 City of Santa Fe Springs Santa Fe Springs 2022-12-28 Los Angeles 37 7631   18364
1917 1917 City of Santa Monica Santa Monica 2022-12-28 Los Angeles 37 25416   92446
1918 1918 City of Sierra Madre Sierra Madre 2022-12-28 Los Angeles 37 2288   10989
1919 1919 City of Signal Hill Signal Hill 2022-12-28 Los Angeles 37 3929   11797
1920 1920 City of South El Monte South El Monte 2022-12-28 Los Angeles 37 8179   20885
1921 1921 City of South Gate South Gate 2022-12-28 Los Angeles 37 46050   98155
1922 1922 City of South Pasadena South Pasadena 2022-12-28 Los Angeles 37 6048   26053
1923 1923 City of Temple City Temple City 2022-12-28 Los Angeles 37 10290   36455
1924 1924 City of Torrance Torrance 2022-12-28 Los Angeles 37 32700   149268
1925 1925 City of Vernon Vernon 2022-12-28 Los Angeles 37 355   209
1926 1926 City of Walnut Walnut 2022-12-28 Los Angeles 37 7228   30532
1927 1927 City of West Covina West Covina 2022-12-28 Los Angeles 37 38131   108235
1928 1928 City of West Hollywood West Hollywood 2022-12-28 Los Angeles 37 10909   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
);
Powered by Datasette · Queries took 2234.828ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals