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

159 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-07-02 240195 6163             19328 138340 49466 32815   246 120678 118389 1128 4338718     5355 1676 1457 258 15379 91  
2 2020-07-01 232657 6090             18672 133458 48149 32145   233 116952 114626 1079 4254176     5196 1617 1416 242 15145 91  
3 2020-06-30 222917 5980             17739 127082 46486 31379   231 112043 109850 1024 4167139     5077 1528 1389 223 14942 89 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-142.aspx
4 2020-06-29 216550 5936             17157 122833 45434 30893   233 108793 106610 967 4061692     4776 1465 1403 221 14827 88 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-141.aspx
5 2020-06-28 211243 5905             16546 118923 44383 30333   1058 105949 103517 1777 3955952     4577 1385 1379 217 14699 86 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-140.aspx
6 2020-06-27 206433 5872             16093 116389 43730 30007   214 104025 101509 899 3862310     4494 1379 1296 183 14520 86 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-138.aspx
7 2020-06-26 200461 5812             15449 112547 42721 29544   200 101070 98564 827 3771314     4380 1364 1259 206 14218 86 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-137.aspx
8 2020-06-25 195571 5733             14968 109489 41870 29048   196 98718 96068 785 3694345     4240 1306 1282 217 13958 85 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-136.aspx
9 2020-06-24 190222 5632             14524 106053 40923 28528   194 95884 93554 784 3592899     4095 1268 1304 219 13737 85 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-135.aspx
10 2020-06-23 183073 5580             13867 101474 39667 27864   201 92199 90119 755 3496929     3868 1225 1197 196 13546 85 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-134.aspx
11 2020-06-22 178054 5515             13346 98269 38795 27456   188 89690 87641 723 3411686     3702 1199 1102 213 13476 83 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-133.aspx
12 2020-06-21 173824 5495             12987 95513 38046 27173   195 87602 85516 706 3319256     3574 1163 1105 203 13373 83 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-132.aspx
13 2020-06-20 169309 5424             12441 92703 37313 26741   211 85352 83285 672 3234412     3494 1145 1088 187 13150 82 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-131.aspx
14 2020-06-19 165416 5360             12063 90278 36485 26385   205 83438 81326 652 3155702     3428 1128 1159 201 12914 80 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-129.aspx
15 2020-06-18 161099 5290             11582 87796 35609 25911   201 81212 79243 644 3074530     3439 1119 1145 179 12685 78 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-128.aspx
16 2020-06-17 157015 5208             11064 85325 34922 25503   201 79128 77199 688 2997988     3421 1109 1101 209 12459 76 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-127.aspx
17 2020-06-16 153560 5121             10702 83254 34290 25109   205 77466 75416 678 2937755     3335 1069 1127 203 12295 75 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-126.aspx
18 2020-06-15 151452 5089             10451 81943 33871 24981   206 76412 74350 690 2868182     3103 1053 1220 217 12237 74 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-125.aspx
19 2020-06-14 148855 5063             10184 80348 33357 24762   204 75088 73095 672 2801996     3092 1076 1155 204 12173 73 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-124.aspx
20 2020-06-13 145643 4989             9819 78441 32783 24403   197 73480 71501 662 2724393     3191 1109 1220 204 11969 70 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-123.aspx
21 2020-06-12 141983 4943             9461 76220 32069 24043   190 71605 69729 649 2662258     3222 1101 1258 209 11714 68 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-122.aspx
22 2020-06-11 139281 4881             9136 74622 31530 23806   187 70212 68430 639 2597647     3177 1073 1357 252 11558 68 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-120.aspx
23 2020-06-10 136191 4776             8800 72829 30914 23469   179 68667 66889 635 2540798     3240 1090 1479 236 11374 67 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-119.aspx
24 2020-06-09 133489 4697             8509 71233 30400 23154   193 67306 65556 627 2486245     3257 1103 1326 242 11171 67 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-118.aspx
25 2020-06-08 131319 4653             8248 69915 30025 22939   192 66303 64392 624 2431190     3184 1079 1322 222 11111 66 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-117.aspx
26 2020-06-07 128812 4626             7947 68412 29556 22704   193 65024 63173 615 2362218     3138 1068 1387 220 11062 65 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-116.aspx
27 2020-06-06 126016 4559             7678 66755 29033 22365   185 63565 61848 603 2308300     3181 1077 1345 238 10962 65 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-115.aspx
28 2020-06-05 122901 4485             7408 64914 28396 22002   181 61884 60404 613 2238463     3142 1083 1483 250 10750 65 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-114.aspx
29 2020-06-04 119807 4422             7119 63152 27762 21595   179 60336 58886 585 2182671     3109 1058 1346 221 10519 64 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-112.aspx
30 2020-06-03 117687 4361             6925 61896 27334 21354   178 59237 57878 572 2131294     3090 1079 1368 234 10293 63 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-111.aspx
31 2020-06-02 115310 4286             6706 60493 26880 21054   177 58001 56728 581 2071591     3038 1054 1355 242 10161 61 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-110.aspx
32 2020-06-01 113006 4251             6488 59144 26405 20792   177 56841 55605 560 2012583     2973 1053 1285 220 10083 60 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-109.aspx
33 2020-05-31 110583 4213             6254 57738 25964 20455   172 55627 54396 560 1944848     2940 1067 1391 257 10033 59 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-108.aspx
34 2020-05-30 106878 4156             5861 55552 25223 20073   169 53765 52561 552 1888595     2928 1042 1287 231 9910 59 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-107.aspx
35 2020-05-29 103886 4068             5542 53795 24617 19773   159 52177 51169 540 1835478     3016 1078 1398 250 9786 57 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-106.aspx
36 2020-05-28 101697 3973             5371 52555 24154 19462   155 51067 50091 539 1790559     3091 1092 1438 233 9647 56 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-105.aspx
37 2020-05-27 98980 3884             5122 50981 23633 19095   149 49714 48739 527 1736894     3114 1095 1430 312 9379 51 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-103.aspx
38 2020-05-26 96733 3814             4872 49643 23185 18898   135 48614 47595 524 1696396     3065 1084 1339 308 9360 50 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-102.aspx
39 2020-05-25 94558 3795             4633 48364 22754 18670   137 47490 46544 524 1644102     3015 1062 1291 239 9328 50 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-099.aspx
40 2020-05-24 92710 3774             4462 47331 22361 18424   132 46595 45597 518 1582745     2980 1071 1320 244 9272 51 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-098.aspx
41 2020-05-23 90631 3708             4273 46131 21938 18164   125 45580 44539 512 1515306     3024 1079 1318 233 9054 49 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-097.aspx
42 2020-05-22 88444 3630             4049 44952 21461 17864   118 44534 43272 638 1466773     3007 1050 1755 267 8902 49 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-096.aspx
43 2020-05-21 86197 3542             3855 43749 20967 17513   113 43450 42252 495 1421127     3048 1051 1687 259 8793 47 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-095.aspx
44 2020-05-20 84057 3436             3657 42591 20468 17232   109 42336 41226 495 1380120     3047 1068 1634 277 8633 46 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-094.aspx
45 2020-05-19 81795 3334             3446 41321 20003 16920   105 41214 40105 476 1339316     3073 1076 1290 231 8405 46 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-093.aspx
46 2020-05-18 80430 3302             3355 40539 19703 16727   106 40533 39425 472 1292672     3037 1076 1354 249 8330 47 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-092.aspx
47 2020-05-17 78839 3261             3225 39651 19365 16489   109 39701 38662 476 1235243     3025 1069 1266 224 8248 46 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-089.aspx
48 2020-05-16 76793 3204             3064 38611 18908 16101   109 38647 37676 470 1179126     3126 1079 1298 234 8111 47 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-088.aspx
49 2020-05-15 74936 3108             2951 37637 18510 15725   113 37744 36728 464 1133906     3157 1067 1362 257 7977 44 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-087.aspx
50 2020-05-14 73164 3032             2799 36602 18154 15498   111 36826 35890 448 1104651     3261 1099 1394 225 7752 42 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-086.aspx
51 2020-05-13 71141 2934             2672 35567 17701 15098   103 35845 34851 445 1065592     3301 1075 1244 239 7496 40  
52 2020-05-12 69382 2847             2549 34573 17322 14845   93 34955 33992 435 1033370     3284 1078 1260 271 7274 39 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-082.aspx
53 2020-05-11 67939 2770             2444 33805 17002 14597   91 34221 33291 427 991897     3248 1093 1301 236 7211 40 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-081.aspx
54 2020-05-10 66680 2745             2373 33190 16729 14290   98 33584 32660 436 955664     3218 1097 1337 231 7160 38 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-080.aspx
55 2020-05-09 64561 2678             2260 32004 16250 13948   99 32379 31756 426 912570     3282 1115 1256 234 7026 38 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-079.aspx
56 2020-05-08 62512 2585             2181 30860 15793 13580   98 31111 30972 429 875272     3250 1118 1264 224 6821 36 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-078.aspx
57 2020-05-07 60614 2504             2055 29902 15375 13194   88 30096 30109 409 842874     3319 1125 1241 249 6625 35 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-077.aspx
58 2020-05-06 58815 2412             1937 28968 14974 12842   94 29193 29190 432 809036     3334 1140 1347 275 6368 36 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-075.aspx
59 2020-05-05 56212 2317             1773 27556 14366 12425   92 27980 27853 379 779902     3369 1157 1253 231 6167 33 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-074.aspx
60 2020-05-04 54937 2254             1715 26956 14078 12098   90 27332 27239 366 747874     3284 1179 1332 285 6103 32 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-073.aspx
61 2020-05-03 53616 2215             1640 26256 13773 11860   87 26716 26556 344 715751     3318 1169 1416 299 5952 33 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-072.aspx
62 2020-05-02 52197 2171             1566 25548 13454 11547   82 26006 25881 310 685048     3423 1178 1299 255 5743 31 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-071.aspx
63 2020-05-01 50442 2073             1449 24613 13044 11256   80 25167 24973 302 654985     3428 1192 1278 242 5617 31 https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/Race-Ethnicity.aspx
64 2020-04-30 48917 1982             1398 23836 12705 10906   72 24372 24247 298 625337     3497 1192 1484 281 5316 29 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-069.aspx
65 2020-04-29 46500 1887             1263 22596 12153 10413   75 23045 23154 301 603139     3495 1186 1516 326 5015 28 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-068.aspx
66 2020-04-28 45031 1809             1190 21888 11781 10086   86 22337 22384 310 577608     3455 1181 1528 304 4794 24 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-067.aspx
67 2020-04-27 43464 1755             1085 21028 11442 9842   85 21600 21562 302 553409     3372 1185 1506 314 4709 24 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-066.aspx
68 2020-04-26 42164 1710             1039 20379 11139 9512   95 20957 20908 299 526084     3324 1184 1604 289 4593 24 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-065.aspx
69 2020-04-25 41137 1651             1011 19897 10885 9256   88 20459 20395 283 506035     3343 1198 1504 260 4453 22 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-064.aspx
70 2020-04-24 39254 1562             936 18954 10451 8832   81 19577 19394 283 494173     3344 1216 1536 305 4322 22 https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-063.aspx
71 2020-04-23 37369 1469             855 18004 10025 8401   84 18690 18395 284 482097 482097 0 3343 1204 1586 327 4153   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-062.aspx
72 2020-04-22 35396 1354             768 17009 9517 8035   67 17718 17411 267 308700 301547 7200 3357 1219 1627 332 3877   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-061.aspx
73 2020-04-21 33261 1268             683 15901 8961 7650   66 16641 16363 257 300100 292906 7200 3365 1241 1521 261 3704   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-060.aspx
74 2020-04-20 30978 1208             573 14690 8385 7267   63 15507 15224 247 290500 283317 7200 3257 1196 1417 284 3584   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-059.aspx
75 2020-04-19 30333 1166             550 14408 8232 7071   72 15185 14902 246 280900 273721 7200 3196 1163 1535 294 3523   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-058.aspx
76 2020-04-18 28963 1072             507 13798 7862 6729   67 14535 14185 243 266900 259666 7200 3221 1173 1715 316 3370   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-057.aspx
77 2020-04-17 27528 985             472 13144 7488 6360   64 13865 13424 239 258800 251614 7200 3180 1174 1712 310 3155   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-056.aspx
78 2020-04-16 26182 890             432 12479 7141 6051   79 13169 12771 242 246400 239181 7200 3141 1191 1890 377 2974   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-055.aspx
79 2020-04-15 24424 821             385 11721 6644 5605   69 12265 11934 225 227600 214387 13200 3171 1175 1894 368 2789   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-054.aspx
80 2020-04-14 23338 758             362 11246 6348 5320   62 11772 11352 214 215400 202208 13200 3124 1177 2039 375 2599   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-053.aspx
81 2020-04-13 22348 687             337 10838 6079 5036   58 11256 10877 215 212900 199667 13200 3015 1178 2033 374 2501   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-052.aspx
82 2020-04-12 21794 651             330 10599 5941 4870   54 10926 10571 297 203400 190238 13200 2917 1145 2317 394 2388   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-051.aspx
83 2020-04-11 20615 609             303 10069 5633 4561   49 10330 9981 304 196200 182986 13200 2846 1145 2221 420 2243   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-050.aspx
84 2020-04-10 19472 541             269 9469 5347 4335   52 9745 9387 340 185300 172076 13200 2897 1145 2339 446 2024   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-049.aspx
85 2020-04-09 18309 492             252 8939 5003 4056   59 9130 8776 403 177600 163704 13900 2825 1132 2803 530 1803   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-048.aspx
86 2020-04-08 16957 442             222 8289 4639 3751   56 8488 8108 361 168800 154733 14100 2714 1154 3078 522 1651   https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-047.aspx
87 2020-04-07 15865 374             197 7753 4344 3516   55 7957 7600 308 157800 143172 14600 2611 1108 2796 522     https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-046.aspx
88 2020-04-06 14336 343             173 7099 3884 3129   51 7296 6740 300 143800 129693 14100 2509 1085 2967 575     https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-045.aspx
89 2020-04-05 13438 319             160 6610 3653 2966   49 6876 6349 213 131500 116563 15000 2398 1040 3187 559     https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-044.aspx
90 2020-04-04 12026 276             137 5917 3253 2660   59 6202 5674 150 126700 113687 13000 2300 1008 3267 586     https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-043.aspx
91 2020-04-03 10701 237             120 5302 2879 2342   58 5547 5015 139 94800 35267 59500 2188 901 3417 584     https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-042.aspx
92 2020-04-02 9191 203             101 4604 2429 2007   50 4806 4254 131 92500 32944 59500 1922 816 3481 618     https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-041.aspx
93 2020-04-01 8155 171             90 4137 2131 1764   33 4267 3753 135 90100 31038 59100 1855 774 3168 642     https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-039.aspx
94 2020-03-31 6932 150             73 3529 1765 1531   34 3666 3155 111 86100 28704 57400 1617 657 3439 602     https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-038.aspx
95 2020-03-30 5763 135             65 2973 1447 1252   26 3083 2581 99 83800 27251 56550             https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-037.aspx
96 2020-03-28 4643 101     923   3720   54 2368 1184 1016   21 2536 2057 50 89600 25192 64400             https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-036.aspx
97 2020-03-27 3801 78     1083   2718   45 1906 967 847   36 2074 1680 47 88400 23480 65000             https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-035.aspx
98 2020-03-26 3006 65     886   2120   37 1505 764 678   22 1665 1309 32 77800 20386 57400             https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-034.aspx
99 2020-03-25 2535 53     707   1828   37 1278 638 562   20 1389 1117 29 66800 18276 48600             https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-033.aspx
100 2020-03-24 2102 40     531   1571   28 970 493 449   162 1081 843 178 27650 15554 12100             https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-32.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
);
Powered by Datasette · Query took 66.918ms · 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