la_times_cdph_state_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: California Department of Public Health via The Los Angeles Times · About: Data dictionary for la_times_cdph_state_totals

465 rows sorted by date descending

✎ View and edit SQL

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

Suggested facets: travel, person_to_person, community_spread, under_investigation, other_causes, self_monitoring, age_18_to_64, pending_tests, date (date)

Link rowid date ▲ confirmed_cases deaths travel person_to_person community_spread under_investigation other_causes self_monitoring age_0_to_17 age_18_to_49 age_50_to_64 age_65_and_up age_18_to_64 age_unknown gender_male gender_female gender_unknown total_tests received_tests pending_tests confirmed_hospitalizations confirmed_icu suspected_hospitalizations suspected_icu healthcare_worker_infections healthcare_worker_deaths vaccine_doses_administered vaccine_doses_distributed source_url
1 1 2021-05-04 3645341 60765             473102 2090146 693919 385874   2300 1743287 1851930 50124 60858620     1608 395 322 51 107899 456 30700655 39463160 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-147.aspx
2 2 2021-05-03 3643992 60763             472846 2089376 693725 385767   2278 1742614 1851231 50147 60709771     1626 387 315 46 107876 455 30501711 38560120 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-146.aspx
3 3 2021-05-02 3642480 60748             472531 2088492 693530 385670   2257 1741923 1850415 50142 60514937     1630 377 312 40 107813 455 30412414 38560120 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-145.aspx
4 4 2021-05-01 3640226 60625             472080 2087200 693188 385500   2258 1740834 1849270 50122 60265800     1681 371 320 47 107621 454 30209999 38560120 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-144.aspx
5 5 2021-04-30 3638132 60467             471698 2085955 692869 385343   2267 1739789 1848219 50124 60015928     1711 371 318 48 107499 453 29846479 37848540 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-143.aspx
6 6 2021-04-29 3636235 60362             471353 2084875 692551 385191   2265 1738849 1847268 50118 59795197     1715 401 353 54 107383 453 29262215 37500880 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-141.aspx
7 7 2021-04-28 3634778 60273             471135 2083997 692332 385048   2266 1738092 1846518 50168 59621509     1755 424 339 54 107190 452 29000025 36887890 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-140.aspx
8 8 2021-04-27 3633185 60208             470841 2083067 692062 384951   2264 1737185 1845590 50410 59484125     1776 431 314 47 107082 451 28682914 36545160 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-139.aspx
9 9 2021-04-26 3631740 60203             470516 2082210 691879 384868   2267 1736357 1844733 50650 59327368     1730 403 323 49 107019 451 28398915 35058910 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-138.aspx
10 10 2021-04-25 3629624 60188             470071 2080988 691590 384709   2266 1735181 1843556 50887 59095717     1717 402 335 39 106948 451 28200566 35058910 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-137.aspx
11 11 2021-04-24 3627885 60135             469741 2079972 691312 384595   2265 1734324 1842597 50964 58896325     1765 400 348 28 106759 451 27843725 35052860  
12 12 2021-04-23 3626656 60086             469386 2079179 691203 384620   2268 1733698 1841919 51039 58644659     1752 404 338 42 106589 451 27389602 34470600  
13 13 2021-04-22 3624838 59992             469047 2078108 690908 384507   2268 1732747 1841004 51087 58202413     1752 435 346 44 106469 451 26823157 34013640 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-132.aspx
14 14 2021-04-21 3622427 59890             468639 2076661 690509 384349   2269 1731541 1839792 51094 58202413     1774 437 342 46 106256 450 26454819 33390900 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-132.aspx
15 15 2021-04-20 3620301 59804             468328 2075390 690127 384188   2268 1730504 1838695 51102 58075920     1796 431 352 49 106125 452 26127571 32778990  
16 16 2021-04-19 3618695 59772             467982 2074515 689861 384073   2264 1729733 1837858 51104 57934087     1779 404 320 42 106056 451 25790401 31625990 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-130.aspx
17 17 2021-04-18 3616779 59768             467590 2073392 689552 383982   2263 1728845 1836857 51077 57733460     1783 404 357 47 105983 452 25533215 31625990 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-129.aspx
18 18 2021-04-17 3614112 59690             467111 2071818 689144 383796   2243 1727546 1835498 51068 57481126     1801 407 344 46 105772 450 25188138 31625990 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-128.aspx
19 19 2021-04-16 3611349 59587             466652 2070149 688697 383610   2241 1726180 1834098 51071 57228812     1833 433 353 43 105493 449 24672255 30970800 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-127.aspx
20 20 2021-04-15 3608898 59508             466223 2068722 688280 383433   2240 1724997 1832834 51067 56997332     1865 459 350 51 105196 450 24163906 30450640 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-126.aspx
21 21 2021-04-14 3606882 59372             465935 2067505 687922 383277   2243 1723973 1831831 51078 56837538     1884 451 367 54 104960 449 23760123 29888030 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-124.aspx
22 22 2021-04-13 3604395 59258             465539 2065938 687529 383138   2251 1722777 1830538 51080 56722428     1839 476 336 38 104794 447 23243392 28799070 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-123.aspx
23 23 2021-04-12 3602827 59249             465272 2065020 687261 383022   2252 1721980 1829743 51104 56593271     1783 448 330 42 104727 447 22974654 28121700 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-121.aspx
24 24 2021-04-11 3600178 59218             464768 2063506 686813 382850   2240 1720702 1828386 51089 56363675     1799 434 324 35 104627 446 22777893 28121700 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-120.aspx
25 25 2021-04-10 3595224 59113             464036 2060545 685960 382494   2189 1718288 1825866 51070 56078860     1854 456 316 35 104455 445 22501294 28121700 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-119.aspx
26 26 2021-04-09 3590758 58943             463351 2057797 685233 382190   2187 1716220 1823475 51063 55827642     1930 475 298 43 104233 446 22030704 27620170 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-118.aspx
27 27 2021-04-08 3588152 58788             462986 2056115 684824 382037   2190 1714973 1822144 51035 55610191     1960 491 352 43 103952 444 21483192 26966680 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-116.aspx
28 28 2021-04-07 3586059 58659             462723 2054830 684460 381853   2193 1713866 1821187 51006 55483634     2021 478 345 49 103647 445 20641692 26488830 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-115.aspx
29 29 2021-04-06 3583830 58541             462453 2053485 684033 381670   2189 1712742 1820065 51023 55377325     1989 493 384 50 103471 444 20267689 26126320 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-114.aspx
30 30 2021-04-05 3582463 58534             462211 2052679 683808 381577   2188 1712025 1819367 51071 55277310     2005 507 381 53 103414 444 19894885 24530300 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-113.aspx
31 31 2021-04-04 3580351 58513             461877 2051415 683452 381424   2183 1711005 1818272 51074 55087131     2023 526 388 42 103301 444 19717651 24530300 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-112.aspx
32 32 2021-04-03 3577951 58404             461575 2049989 683040 381268   2179 1709808 1817075 51068 54895447     2054 538 375 38 102992 444 19368672 24530300 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-111.aspx
33 33 2021-04-02 3573074 58269             460898 2046901 682173 380916   2186 1707300 1814708 51066 54553918     2147 562 391 43 102762 444 18862091 24073790 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-110.aspx
34 34 2021-04-01 3570660 58090             460542 2045519 681723 380688   2188 1706049 1813549 51062 53934609     2200 576 383 47 102520 443 18401747 23505520 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-108.aspx
35 35 2021-03-31 3568426 57936             460204 2044163 681366 380504   2189 1704944 1812443 51039 53786487     2264 576 359 51 102279 445 18023603 22892620 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-107.aspx
36 36 2021-03-30 3566464 57788             459952 2042995 681008 380323   2186 1703910 1811508 51046 53684932     2257 561 342 52 102220 444 17649015 22374090 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-105.aspx
37 37 2021-03-29 3564468 57778             459571 2041874 680630 380204   2189 1702967 1810483 51018 53558339     2254 576 342 55 102176 444 17356911 21147010 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-104.aspx
38 38 2021-03-28 3562191 57746             459194 2040565 680221 380019   2192 1701777 1809399 50015 53384553     2290 571 360 60 102032 444 17136841 21147010 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-103.aspx
39 39 2021-03-27 3559193 57551             458685 2038803 679727 379788   2190 1700247 1807948 50998 53170348     2372 576 332 59 101890 443 16775843 21147010 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-102.aspx
40 40 2021-03-26 3555915 57336             458163 2036888 679151 379527   2186 1698620 1806308 50987 52962296     2380 601 386 50 101642 442 16392678 20802720 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-101.aspx
41 41 2021-03-25 3553307 57091             457781 2035373 678688 379280   2185 1697330 1804980 50997 52765254     2449 641 337 61 101371 443 15979099 20244790 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-100.aspx
42 42 2021-03-24 3551056 56850             457495 2034026 678249 379094   2192 1696171 1803852 51033 52630376     2545 620 442 56 101094 439 15537745 19809080 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-099.aspx
43 43 2021-03-23 3549101 56596             457182 2032882 677907 378926   2206 1695184 1802844 51073 52525010     2586 635 419 68 100915 439 15152845 19292060 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-098.aspx
44 44 2021-03-22 3547278 56545             456891 2031814 677588 378795   2190 1694329 1801902 51047 52416454     2605 674 407 60 100864 439 14819755 18234500 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-096.aspx
45 45 2021-03-21 3545278 56118             456578 2030714 677178 378618   2190 1693345 1800864 51069 52258578     2690 710 425 66 100741 437 14520575 18234500 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-095.aspx
46 46 2021-03-20 3541928 56072             456036 2028846 676537 378324   2185 1691660 1799168 51100 52047615     2769 731 428 60 100474 436 14180095 18234500 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-094.aspx
47 47 2021-03-19 3538821 56027             455593 2027073 675926 378046   2183 1690113 1797858 51123 51811542     2872 753 431 59 100208 435 13769061 17661490 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-093.aspx
48 48 2021-03-18 3535534 55795             455199 2025200 675313 377718   2184 1688494 1795896 51144 51601716     3002 778 454 72 99959 430 13382046 17213150 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-092.aspx
49 49 2021-03-17 3532496 55577             454701 2023482 674714 377420   2179 1686934 1794402 51160 51460324     3025 784 437 72 99579 420 13037557 16813070 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-090.aspx
50 50 2021-03-16 3530055 55372             454381 2022221 674213 377062   2178 1685718 1793122 51215 51351366     3058 827 398 70 99414 417 12637197 16686580 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-089.aspx
51 51 2021-03-15 3528795 55330             454207 2021468 673988 376953   2179 1685050 1792486 51259 51263837     3119 862 438 77 99330 416 12172948 15702230 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-088.aspx
52 52 2021-03-14 3526335 55235             453803 2020118 673527 376712   2175 1683830 1791231 51274 51099687     3434 896 445 63 99175 415 11785750 16361975 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-087.aspx
53 53 2021-03-13 3523563 55095             453368 2018557 673006 376467   2165 1682434 1789858 51271 50889509     3250 942 439 57 98861 414 11418507 15896795 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-086.aspx
54 54 2021-03-12 3520333 54878             452919 2016747 672444 376063   2160 1680865 1788199 51269 50648522     3335 966 477 64 98570 410 11169839 15743525 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-085.aspx
55 55 2021-03-11 3516862 54891             452443 2014716 671794 375736   2173 1679075 1786504 51283 50316151     3477 961 481 70 98306 409 10988301 15426105 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-082.aspx
56 56 2021-03-10 3513678 54621             451984 2012786 671260 375480   2168 1677509 1784884 51285 50223971     3625 992 494 72 97997 409 10772859 15107575 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-081.aspx
57 57 2021-03-09 3507266 54395             451462 2009104 669976 374580   2164 1674247 1781806 51213 50139831     3744 1028 461 79 97813 406 10628752 14689305 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-080.aspx
58 58 2021-03-08 3504652 54224             451015 2007650 669481 374342   2164 1672907 1780520 51225 49922499     3766 1065 462 71 97693 406 10512860 14503895 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-079.aspx
59 59 2021-03-07 3501394 54124             450519 2005831 668847 374031   2166 1671356 1778826 51212 49646014     3812 1100 479 59 97514 405 10379688 13345790 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-078.aspx
60 60 2021-03-06 3497578 53866             449972 2003731 668098 373601   2176 1669485 1776841 51252 49512828     4004 1152 509 69 97277 404 10213706 13743075 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-077.aspx
61 61 2021-03-05 3493126 53448             449313 2001313 667234 373112   2154 1667291 1774589 51246 49294503     4179 1190 535 46 96938 404 10003942 13069780 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-076.aspx
62 62 2021-03-04 3488467 53048             448653 1998780 666332 372554   2148 1665042 1772224 51201 49147685     4449 1267 518 60 96492 400 9673787 13098655 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-073.aspx
63 63 2021-03-03 3484963 52775             448193 1996925 665595 372106   2144 1663374 1770397 51192 49028048     4597 1335 513 68 96089 400 9458722 12783315 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-071.aspx
64 64 2021-03-02 3481611 52497             447770 1995109 664879 371704   2149 1661717 1768628 51266 48897190     4812 1390 490 62 95791 397 9313799 12311565 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-070.aspx
65 65 2021-03-01 3479078 52194             447354 1993740 664406 371427   2151 1660484 1767316 51278 48712676     4912 1439 497 79 95641 397 9087899 12112965 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-069.aspx
66 66 2021-02-28 3475562 51979             446763 1991839 663739 371071   2150 1658745 1765523 51294 48469106     5143 1507 531 78 95381 397 8772866 11724565 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-068.aspx
67 67 2021-02-27 3470877 51821             446057 1989308 662816 370554   2142 1656448 1763115 51314 48219490     5372 1578 525 73 95063 396 8491076 11480035 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-067.aspx
68 68 2021-02-26 3465726 51382             445314 1986471 661836 369969   2136 1621774 1758322 55630 47995576     5590 1640 562 85 94769 396 8243711 11186365 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-065.aspx
69 69 2021-02-25 3460326 50991             444547 1983548 660785 369313   2133 1651296 1757746 51284 47814160     5934 1708 586 75 94331 396 8003120 10897085 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-064.aspx
70 70 2021-02-24 3455361 49877             443900 1980770 659757 368784   2150 1648874 1755203 51284 47652172     6185 1775 579 64 93893 392 7763668 10573585 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-063.aspx
71 71 2021-02-23 3450058 49563             443234 1977904 658650 368121   2149 1646261 1752452 51345 47513367     6345 1822 563 76 93605 391 7581560 10334985 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-062.aspx
72 72 2021-02-22 3446611 49338             442690 1976055 657968 367754   2144 1644578 1750671 51362 47320802     6569 1933 596 77 93494 392 7437925 9857175 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-061.aspx
73 73 2021-02-21 3441946 49105             441978 1973516 657076 367229   2147 1642318 1748322 51306 47043348     6704 2003 609 70 93260 389 7320679 9264515 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-060.aspx
74 74 2021-02-20 3435186 48825             440968 1969895 655764 366399   2160 1639066 1744886 51234 46813876     7148 2089 599 79 92960 387 7174164 8858445 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-059.aspx
75 75 2021-02-19 3428518 48344             440098 1966284 654421 365575   2140 1635830 1741520 51168 46621654     7514 2207 642 84 92654 386 6929954 8858445 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-058.aspx
76 76 2021-02-18 3421720 47924             439176 1962504 653133 364781   2126 1632464 1739179 51077 46504255     7904 2341 662 86 92161 385 6699137 8854155 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-056.aspx
77 77 2021-02-17 3416147 47507             438493 1959463 652016 364046   2129 1629733 1735351 51063 46384932     8215 2439 640 94 91866 385 6435184 8748075 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-055.aspx
78 78 2021-02-16 3412057 47107             437865 1957284 651225 363548   2125 1627698 1733301 51058 46227725     8459 2487 616 117 91767 383 6262781 8517000 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-054.aspx
79 79 2021-02-15 3406365 47043             436921 1954321 650118 362882   2123 1624937 1730360 51068 45964127     8693 2552 606 98 91673 382 6153109 8517000 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-053.aspx
80 80 2021-02-14 3399878 46843             435945 1950853 648871 361993   2116 1621806 1727045 51027 45703217     8996 2632 640 101 91452 380 5981552 8517000 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-051.aspx
81 81 2021-02-13 3391036 46435             434526 1946247 647161 360993   2109 1617383 1722603 51050 45411637     9414 2731 584 77 91106 380 5768684 8372700 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-050.aspx
82 82 2021-02-12 3381615 46002             433159 1941204 645327 359817   2108 1612786 1717877 50952 45125441     9883 2849 622 81 90744 376 5511429 8169900 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-049.aspx
83 83 2021-02-11 3371556 45456             431804 1935819 643344 358485   2104 1607931 1712835 50790 44923981     10338 2915 707 81 90308 374 5291493 8066625 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-048.aspx
84 84 2021-02-10 3362981 44995             430453 1931294 641686 357449   2099 1603715 1708439 50827 44770601     10771 3031 745 96 89841 370 5089483 7911375 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-047.aspx
85 85 2021-02-09 3354591 44477             429257 1926874 640035 356332   2093 1599569 1704207 50815 44583304     11198 3164 706 100 89643 369 4914630 7634975 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-046.aspx
86 86 2021-02-08 3346340 44150             427969 1922508 638410 355369   2084 1595640 1699904 50796 44323550     11385 3240 700 73 89507 367 4746539 7556800 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-045.aspx
87 87 2021-02-07 3335926 43942             426326 1917098 636296 354119   2087 1590682 1694648 50596 43994322     11695 3260 781 79 89256 366 4650637 7392300 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-044.aspx
88 88 2021-02-06 3320862 43647             424067 1908979 633364 352363   2089 1583369 1686938 50556 43719155     12345 3391 792 88 88898 361 4453271 7167500 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-043.aspx
89 89 2021-02-05 3308468 43024             422274 1902343 630958 350812   2081 1577423 1680602 50443 43433104     12863 3432 809 95 88481 358 4199626 6981275 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-042.aspx
90 90 2021-02-04 3294447 42466             420213 1894834 628226 349039   2135 1570616 1673610 50221 43235327     13277 3637 861 119 88061 354 3984752 6438225 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-041.aspx
91 91 2021-02-03 3281271 41811             418365 1887798 625572 347383   2153 1564212 1666909 50150 43067233     13766 3667 812 105 87603 353 3792797 6343925 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-040.aspx
92 92 2021-02-02 3270770 41330             416891 1882333 623439 345985   2122 1559144 1661448 50178 42851891     14221 3797 778 97 87342 347 3649440 5780150 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-039.aspx
93 93 2021-02-01 3258706 40908             414991 1876071 621018 344502   2124 1553217 1655273 50216 42569193     14443 3857 769 92 87142 345 3523111 5772775  
94 94 2021-01-31 3243348 40697             412601 1867867 618143 342610   2127 1545854 1647516 49978 42279018     14856 3944 820 103 86707 342 3434295 4759750  
95 95 2021-01-30 3224374 40216             409826 1857546 614408 340478   2116 1536611 1637851 49912 41980456     15113 3955 828 87 86115 338 3266914 4759750  
96 96 2021-01-29 3205947 39578             407198 1847694 610690 338251   2114 1527644 1628412 49891 41677405     15705 4145 876 87 85125 335 3078250 4759750  
97 97 2021-01-28 3186610 38961             404631 1837255 606779 335853   2092 1518121 1618782 49707 41470634     16251 4196 892 87 84432 331 2893493 4736750  
98 98 2021-01-27 3169914 38224             402283 1828399 603406 333827   1999 1510132 1610402 49380 41252482     16839 4284 871 91 83817 332 2730262 4728850  
99 99 2021-01-26 3153186 37527             400095 1819350 600018 331706   2017 1501958 1601818 49410 41010770     17236 4315 803 69 83351 328 2587736 4695625  
100 100 2021-01-25 3136158 37118             397453 1810255 596666 329760   2024 1493610 1593139 49409 40688908     17432 4395 915 80 83113 328 2437504 4564425 https://www.cdph.ca.gov/Programs/OPA/Pages/NR21-031.aspx

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [la_times_cdph_state_totals] (
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [travel] TEXT,
   [person_to_person] TEXT,
   [community_spread] TEXT,
   [under_investigation] TEXT,
   [other_causes] TEXT,
   [self_monitoring] TEXT,
   [age_0_to_17] INTEGER,
   [age_18_to_49] INTEGER,
   [age_50_to_64] INTEGER,
   [age_65_and_up] INTEGER,
   [age_18_to_64] TEXT,
   [age_unknown] INTEGER,
   [gender_male] INTEGER,
   [gender_female] INTEGER,
   [gender_unknown] INTEGER,
   [total_tests] INTEGER,
   [received_tests] TEXT,
   [pending_tests] TEXT,
   [confirmed_hospitalizations] INTEGER,
   [confirmed_icu] INTEGER,
   [suspected_hospitalizations] INTEGER,
   [suspected_icu] INTEGER,
   [healthcare_worker_infections] INTEGER,
   [healthcare_worker_deaths] INTEGER,
   [vaccine_doses_administered] INTEGER,
   [vaccine_doses_distributed] INTEGER,
   [source_url] TEXT
);