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

314 rows sorted by date descending

View and edit SQL

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 source_url
1 2020-12-04 1286557 19582             144555 765403 241906 133635   1058 623621 652467 10469 24675478     9065 2152 883 96 54711 220  
2 2020-12-03 1264539 19437             141712 752442 237843 131495   1047 613458 641220 9861 24474642     8831 2066 871 81 54020 220 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-322.aspx
3 2020-12-02 1245948 19324             139427 741663 234277 129548   1033 604591 631636 9721 24299126     8517 2006 848 115 53409 218 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-320.aspx
4 2020-12-01 1225189 19211             136904 729630 230204 127432   1019 594629 620979 9581 24161313     8240 1890 809 110 53003 218 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-319.aspx
5 2020-11-30 1212968 19141             135365 722382 227953 126255   1013 588688 614770 9510 24025171     7787 1812 791 107 52729 218 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-318.aspx
6 2020-11-29 1198934 19121             133586 714382 225207 124744   1015 581955 607559 9420 23807501     7415 1711 783 112 52410 218 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-317.aspx
7 2020-11-28 1183320 19089             131829 705285 222191 123005   1010 574323 599687 9310 23573182     6972 1638 712 125 52227 218 https://twitter.com/CAPublicHealth/status/1332794738806718465/photo/1
8 2020-11-27 1171324 19033             130355 698204 219932 121832   1001 568573 593595 9156 23315918     6647 1595 741 131 51801 218 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-315.aspx
9 2020-11-26 1158689 18979             128707 690862 217589 120544   987 562702 586945 9042 23096745     6449 1512 748 105 51259 217 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-314.aspx
10 2020-11-25 1144049 18875             126874 682308 214756 119130   981 555627 579540 8882 22910351     6188 1433 861 118 50757 215 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-313.aspx
11 2020-11-24 1125699 18769             124712 671494 211185 117343   965 546676 570248 8775 22741363     5844 1397 797 117 50318 214 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-312.aspx
12 2020-11-23 1110370 18726             122672 662497 208339 115905   957 539261 562480 8629 22457544     5459 1333 795 122 50052 214 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-310.aspx
13 2020-11-22 1102033 18676             121574 657635 206897 114971   956 535242 558424 8549 22237309     5170 1282 748 108 49705 214 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-309.aspx
14 2020-11-21 1087714 18643             119794 649210 204214 113542   954 528371 550885 8458 21971832     4989 1227 756 105 49312 214 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-308.aspx
15 2020-11-20 1072272 18557             117930 640116 201254 112026   946 520928 543000 8344 21730551     4755 1240 742 92 48906 211 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-307.aspx
16 2020-11-19 1059267 18466             116320 632227 198904 110871   945 514692 536393 8182 21552528     4523 1155 796 98 48464 211 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-305.aspx
17 2020-11-18 1047789 18360             114812 625550 196717 109763   947 509304 530421 8064 21418543     4309 1148 769 110 47080 211 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-304.aspx
18 2020-11-17 1037978 18299             113638 619702 194932 108766   940 504618 525328 8032 21259076     4118 1086 767 120 47827 211 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-303.aspx
19 2020-11-16 1029235 18263             112297 614649 193375 107973   941 500408 520859 7968 21068894     3852 1031 707 100 47667 211 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-302.aspx
20 2020-11-15 1019345 18253             111029 608738 191565 107074   939 495550 545924 7871 20866785     3683 1001 771 93 47400 211 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-301.aspx
21 2020-11-14 1008377 18218             109636 602180 189615 106013   933 490387 510169 7821 20671596     3531 955 681 69 47138 211 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-300.aspx
22 2020-11-13 998502 18137             108445 596237 187873 105031   916 485678 505051 7773 20478500     3399 931 739 100 46922 211 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-299.aspx
23 2020-11-12 991609 18108             107582 592114 186603 104403   907 482394 501490 7725 20342072     3300 913 702 97 46693 210 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-298.aspx
24 2020-11-11 984682 18070             106693 588029 185315 103745   900 479043 497954 7685 20222093     3224 889 763 117 46468 209 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-297.aspx
25 2020-11-10 977218 18001             105792 583469 184005 103063   889 475297 494286 7635 20094641     3083 859 716 125 46347 209 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-296.aspx
26 2020-11-09 971851 17997             105005 580281 183085 102592   888 472695 491542 7614 19918479     3001 839 667 102 46208 209 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-295.aspx
27 2020-11-08 964639 17963             103975 576051 181808 101922   883 469207 487884 7548 19724628     2902 811 652 99 46146 209 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-294.aspx
28 2020-11-07 956957 17939             102996 571373 180424 101279   885 465544 483919 7494 19565151     2821 807 635 94 45790 209 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-293.aspx
29 2020-11-06 951094 17866             102277 567927 179365 100643   882 462738 480900 7456 19396349     2765 822 724 101 45548 207 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-292.aspx
30 2020-11-05 944576 17815             101430 564094 178172 100004   876 459667 477502 7407 19266363     2712 814 750 108 45260 206 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-291.aspx
31 2020-11-04 940010 17752             100856 561326 177367 99592   869 457423 475256 7331 19181012     2669 779 741 122 45173 206 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-289.aspx
32 2020-11-03 934672 17686             100239 558194 176308 99065   866 454850 472513 7309 19074921     2602 743 668 97 44870 205 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-288.aspx
33 2020-11-02 930628 17672             99679 555933 175508 98643   865 452908 470424 7296 18912501     2537 708 704 115 44787 205 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-287.aspx
34 2020-11-01 926534 17667             99123 553578 174737 98240   856 450953 468321 7260 18743315     2474 698 719 93 44686 206 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-286.aspx
35 2020-10-31 922005 17626             98615 550862 173917 97764   847 448772 466008 7225 18602317     2525 681 687 90 44497 206 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-285.aspx
36 2020-10-30 916918 17571             97994 547963 172862 97247   852 446320 463411 7187 18444523     2430 666 718 106 44296 206 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-284.aspx
37 2020-10-29 912904 17541             97497 545660 172094 96800   853 444378 461383 7143 18323771     2358 657 725 111 44048 205 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-283.aspx
38 2020-10-28 908713 17475             96978 546262 171333 96305   835 442321 459278 7114 18223596     2342 663 656 107 43870 203 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-282.aspx
39 2020-10-27 904198 17400             96360 540531 170563 95901   843 440111 456990 7097 18127049     2334 659 666 115 43695 200 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-280.aspx
40 2020-10-26 901010 17357             95990 538674 169913 95584   849 438587 455339 7084 17982829     2281 633 710 102 43663 200 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-279.aspx
41 2020-10-25 898029 17345             95603 536903 169336 95336   851 437115 453853 7061 17787885     2254 615 715 107 43520 199 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-278.aspx
42 2020-10-24 892810 17311             94896 533822 168370 94882   840 434601 451184 7025 17609179     2336 636 671 108 43338 200 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-277.aspx
43 2020-10-23 886865 17262             94030 530359 167321 94321   934 431774 448100 6991 17483293     2338 650 673 104 43113 197 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-276.aspx
44 2020-10-22 880724 17189             93249 526820 166162 93662   831 428858 444925 6941 17358770     2351 652 700 106 42918 197 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-275.aspx
45 2020-10-21 877784 17027             92864 525174 165568 93333   845 427427 443416 6941 17293139     2348 660 729 103 42711 196 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-274.aspx
46 2020-10-20 874077 16992             92375 523072 164817 92952   861 425648 441502 6927 17189070     2291 657 813 124 42565 197 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-273.aspx
47 2020-10-19 870791 16970             91935 521159 164194 92643   860 424039 439844 6908 17042408     2241 660 761 98 42498 196 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-271.aspx
48 2020-10-18 867317 16943             91471 519066 163593 92326   861 422413 437997 6907 16892062     2286 624 734 103 42388 196 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-270.aspx
49 2020-10-17 864455 16899             91051 517420 163077 92027   880 421047 436495 6913 16756711     2234 644 761 99 42206 197 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-269.aspx
50 2020-10-16 861476 16830             90645 515699 162544 91697   891 419655 434912 6909 16621956     2245 615 790 98 41984 194 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-268.aspx
51 2020-10-15 858401 16757             90259 513932 161957 91359   894 418205 433299 6897 16517812     2239 600 839 106 41753 194 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-267.aspx
52 2020-10-14 855072 16639             89843 511954 161329 91051   895 416579 431587 6906 16425487     2239 622 887 131 41575 193 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-266.aspx
53 2020-10-13 852406 16581             89498 510413 160823 90787   885 415294 430237 6875 16333717     2226 626 834 122 41484 192 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-264.aspx
54 2020-10-12 850028 16572             89138 509044 160393 90571   882 414166 428996 6866 16191341     2196 604 874 132 41402 192 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-263.aspx
55 2020-10-11 846579 16564             88691 507025 159737 90249   877 412555 427180 6844 16047004     2209 612 894 123 41249 192 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-262.aspx
56 2020-10-10 842776 16500             88203 504734 159028 89927   884 410644 425304 6828 15878445     2264 612 820 120 41034 191 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-261.aspx
57 2020-10-09 838606 16428             87657 502291 158233 89535   890 408687 423126 6793 15736497     2310 635 876 107 40758 191 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-260.aspx
58 2020-10-08 834800 16361             87201 500052 157546 89114   887 406928 421112 6760 15623623     2328 652 858 102 40488 191 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-259.aspx
59 2020-10-07 831225 16228             86720 498012 156845 88764   884 405212 419257 6756 15556706     2323 673 881 124 40265 190 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-258.aspx
60 2020-10-06 828461 16177             86370 496431 156312 88464   884 403885 417819 6757 15430421     2344 681 831 128 40142 190 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-257.aspx
61 2020-10-05 826784 16149             86137 495458 156007 88296   886 403070 416956 6758 15301681     2291 681 855 124 40063 191 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-256.aspx
62 2020-10-04 823729 16120             85748 493676 155398 88023   884 401556 415440 6733 15160287     2283 664 846 123 39943 191 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-255.aspx
63 2020-10-03 819436 16074             85246 491142 154619 87546   883 399431 413300 6705 14998888     2287 673 792 114 39792 191 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-254.aspx
64 2020-10-02 817277 15986             84871 489846 154229 87371   890 398313 412239 6725 14868431     2339 679 827 117 39653 191 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-253.aspx
65 2020-10-01 813687 15888             84468 487779 153584 86965   891 396552 410433 6702 14771851     2369 685 836 132 39414 188 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-252.aspx
66 2020-09-30 810625 15792             84064 485990 153030 86652   889 395012 408908 6705 14705202     2393 697 874 133 39120 186 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-251s.aspx
67 2020-09-29 807425 15640             83695 484115 152456 86274   885 393417 407312 6696 14613545     2392 693 831 135 38907 185 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-249.aspx
68 2020-09-28 805263 15608             83407 482861 152059 86053   883 392328 406263 6672 14484852     2317 714 843 117 38827 185 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-248.aspx
69 2020-09-27 802308 15587             83024 481120 151507 85776   881 390753 404887 6668 14333498     2339 764 790 128 38686 185 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-247.aspx
70 2020-09-26 798237 15532             82484 478701 150729 85424   889 388687 402911 6639 14182730     2385 738 818 127 38443 183 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-246.aspx
71 2020-09-25 794040 15398             81942 476199 149978 85007   914 386661 400779 6600 14052247     2474 753 833 146 38179 183 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-245.aspx
72 2020-09-24 790640 15314             81545 474158 149356 84659   922 384959 399084 9597 13952857     2578 774 906 140 37855 182 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-244.aspx
73 2020-09-23 787470 15204             81177 472300 147760 84312   921 383438 397436 6596 13879423     2617 783 940 122 37531 180 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-243.aspx
74 2020-09-22 784324 15071             80868 470432 148177 83936   911 381901 395828 6595 13804055     2632 799 888 124 37267 177 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-242.aspx
75 2020-09-21 781694 15018             80508 468969 147624 83683   910 380480 394632 6582 13672782     2573 811 886 149 37205 177 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-241.aspx
76 2020-09-20 778400 14987             80869 466993 147049 83379   910 378892 392944 6564 13523158     2607 807 834 118 37082 178 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-240.aspx
77 2020-09-19 774135 14912             79502 464501 146262 82954   916 376730 390834 6571 13343886     2663 839 847 131 36803 174 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-239.aspx
78 2020-09-18 769831 14812             78946 462003 145439 82521   922 374646 388633 6552 13177186     2676 836 894 129 36460 171 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-238.aspx
79 2020-09-17 766201 14721             78506 459903 144721 82148   923 372752 386895 6554 13080037     2708 860 913 137 36175 170 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-236.aspx
80 2020-09-16 762963 14615             78192 457919 144116 81822   914 371046 385393 6524 13000522     2821 875 864 157 35846 172 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-234.aspx
81 2020-09-15 760013 14451             77859 456173 143563 81506   912 369597 383892 6524 12928170     2887 902 848 142 35525 167 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-233.aspx
82 2020-09-14 757778 14385             77560 454811 143153 81333   921 368459 382809 6510 12806189     2841 921 824 119 35483 167 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-231.aspx
83 2020-09-13 754923 14329             77187 453134 142627 81053   922 367162 381278 6483 12690016     2869 932 872 124 35344 166 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-230.aspx
84 2020-09-12 750298 14251             76593 450341 141798 80630   936 364731 378984 6583 12556967     2970 970 878 150 35107 166 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-229.aspx
85 2020-09-11 746191 14089             76136 447876 141078 80183   918 362679 376954 6558 12451660     3142 1023 881 149 34834 167 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-227.aspx
86 2020-09-10 742865 13978             75769 445900 140488 79803   905 361051 375254 6560 12389991     3288 1040 937 144 34506 164 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-226.aspx
87 2020-09-09 739527 13841             75382 443906 139866 79476   897 359429 373544 6554 12343979     3354 1072 1071 161 34318 164 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-225.aspx
88 2020-09-08 737911 13758             75198 442946 139563 79301   903 358617 372728 6566 12267948     3311 1080 986 137 34254 163 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-224.aspx
89 2020-09-07 735235 13726             74886 441336 139067 79046   900 357224 371456 6555 12158292     3308 1120 977 124 34179 163 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-223.aspx
90 2020-09-06 732144 13709             74490 439510 138496 78740   908 355719 369877 6548 12047191     3336 1091 890 110 34014 164 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-222.aspx
91 2020-09-05 727239 13643             73915 436511 137641 78262   910 353245 367462 6532 11916323     3413 1116 829 126 33689 163 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-221.aspx
92 2020-09-04 722283 13490             73330 433487 136757 77807   902 350835 364956 6492 11796970     3513 1107 888 128 33307 157 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-220.aspx
93 2020-09-03 717777 13327             72822 430475 135797 77191   892 348495 362183 6499 11663924     3604 1119 967 151 33003 155 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-218.aspx
94 2020-09-02 712052 13163             72271 427519 134862 76511   889 346117 359315 6620 11580370     3773 1197 1078 142 32644 150 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-217.aspx
95 2020-09-01 707797 13018             71776 424850 134175 76098   898 344006 357162 6629 11470696     3849 1194 1020 158 32361 150 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-216.aspx
96 2020-08-31 704085 12933             71224 422691 133533 75729   908 342297 355181 6607 11373305     3878 1223 951 123 32262 150 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-214.aspx
97 2020-08-30 699909 12905             70677 420231 132806 75284   911 340298 353037 6574 11231829     3940 1266 1003 130 32074 151 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-213.aspx
98 2020-08-29 693839 12834             69964 416615 131694 74665   901 337348 349907 6584 11109630     4072 1282 991 129 31767 148 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-212.aspx
99 2020-08-28 688858 12690             69369 413764 130701 74124   900 334946 347253 6659 11010637     4205 1329 1062 148 31468 149 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-211.aspx
100 2020-08-27 683529 12550             68731 410668 129732 73489   909 332354 344479 6696 10918415     4293 1349 1104 143 31115 150 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-210.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,
   [source_url] TEXT
);