cdph-positive-test-rate
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The month the data describe in ISO 8601 format.
- alpha
- The percentage of new cases attributed to the Alpha variant
- gamma
- The percentage of new cases attributed to the Gamma variant
- epsilon
- The percentage of new cases attributed to the Epsilon variant
- iota
- The percentage of new cases attributed to the Iota variant
- delta
- The percentage of new cases attributed to the Delta variant
- other
- The percentage of new cases attributed to other variants
1,060 rows sorted by new_confirmed_cases_seven_day_total
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | confirmed_cases | total_tests | new_confirmed_cases | new_positive_tests | new_tests | new_confirmed_cases_seven_day_total ▼ | new_tests_seven_day_total | positive_test_rate_seven_day_percent |
---|---|---|---|---|---|---|---|---|---|---|
69 | 69 | 2020-04-09 | 32085.0 | 299804.0 | 1397.0 | 1761.0 | 17870.0 | 10451.0 | 92177.0 | 0.11338 |
476 | 476 | 2021-05-21 | 3694630.0 | 65120553.0 | 948.0 | 1460.0 | 173848.0 | 10603.0 | 1244911.0 | 0.008517 |
71 | 71 | 2020-04-11 | 34609.0 | 327153.0 | 1051.0 | 1072.0 | 9201.0 | 10608.0 | 96203.0 | 0.110267 |
70 | 70 | 2020-04-10 | 33558.0 | 317952.0 | 1473.0 | 1699.0 | 18148.0 | 10614.0 | 95012.0 | 0.111712 |
74 | 74 | 2020-04-14 | 38625.0 | 364937.0 | 1496.0 | 1756.0 | 16717.0 | 10712.0 | 98986.0 | 0.108217 |
73 | 73 | 2020-04-13 | 37129.0 | 348220.0 | 1520.0 | 1914.0 | 15318.0 | 10730.0 | 97503.0 | 0.110048 |
75 | 75 | 2020-04-15 | 40287.0 | 384838.0 | 1662.0 | 1982.0 | 19901.0 | 10920.0 | 102904.0 | 0.106118 |
475 | 475 | 2021-05-20 | 3693682.0 | 64946705.0 | 999.0 | 1584.0 | 200986.0 | 10940.0 | 1248621.0 | 0.008762 |
76 | 76 | 2020-04-16 | 41962.0 | 404515.0 | 1675.0 | 1878.0 | 19677.0 | 11037.0 | 104711.0 | 0.105404 |
77 | 77 | 2020-04-17 | 43569.0 | 425248.0 | 1607.0 | 1741.0 | 20733.0 | 11079.0 | 107296.0 | 0.103256 |
514 | 514 | 2021-06-28 | 3731882.0 | 70196458.0 | 1932.0 | 2289.0 | 161565.0 | 11100.0 | 810168.0 | 0.013701 |
474 | 474 | 2021-05-19 | 3692683.0 | 64745719.0 | 1191.0 | 1696.0 | 226591.0 | 11176.0 | 1255837.0 | 0.008899 |
78 | 78 | 2020-04-18 | 44775.0 | 438232.0 | 1206.0 | 1273.0 | 12984.0 | 11280.0 | 111079.0 | 0.101549 |
79 | 79 | 2020-04-19 | 45856.0 | 446897.0 | 1081.0 | 901.0 | 8665.0 | 11445.0 | 113995.0 | 0.100399 |
473 | 473 | 2021-05-18 | 3691492.0 | 64519128.0 | 1231.0 | 1853.0 | 241256.0 | 11577.0 | 1266007.0 | 0.009144 |
515 | 515 | 2021-06-29 | 3733763.0 | 70349532.0 | 1881.0 | 2261.0 | 153074.0 | 11700.0 | 814130.0 | 0.014371 |
80 | 80 | 2020-04-20 | 47776.0 | 469049.0 | 1920.0 | 2179.0 | 22152.0 | 11710.0 | 120829.0 | 0.096914 |
472 | 472 | 2021-05-17 | 3690261.0 | 64277872.0 | 1339.0 | 1957.0 | 275971.0 | 11929.0 | 1278387.0 | 0.009331 |
81 | 81 | 2020-04-21 | 49448.0 | 494305.0 | 1672.0 | 2029.0 | 25256.0 | 11983.0 | 129368.0 | 0.092627 |
82 | 82 | 2020-04-22 | 51212.0 | 518404.0 | 1764.0 | 2026.0 | 24099.0 | 12027.0 | 133566.0 | 0.090045 |
471 | 471 | 2021-05-16 | 3688922.0 | 64001901.0 | 813.0 | 903.0 | 57602.0 | 12241.0 | 1289580.0 | 0.009492 |
470 | 470 | 2021-05-15 | 3688109.0 | 63944299.0 | 900.0 | 1150.0 | 68657.0 | 12246.0 | 1286372.0 | 0.00952 |
83 | 83 | 2020-04-23 | 53054.0 | 543894.0 | 1842.0 | 2142.0 | 25490.0 | 12291.0 | 139379.0 | 0.088184 |
469 | 469 | 2021-05-14 | 3687209.0 | 63875642.0 | 1179.0 | 1797.0 | 177558.0 | 12358.0 | 1289910.0 | 0.009581 |
516 | 516 | 2021-06-30 | 3735791.0 | 70493871.0 | 2028.0 | 2416.0 | 144339.0 | 12489.0 | 818892.0 | 0.015251 |
468 | 468 | 2021-05-13 | 3686030.0 | 63698084.0 | 1198.0 | 1820.0 | 208202.0 | 12679.0 | 1293387.0 | 0.009803 |
84 | 84 | 2020-04-24 | 55064.0 | 573572.0 | 2010.0 | 2328.0 | 29678.0 | 12878.0 | 148324.0 | 0.086823 |
467 | 467 | 2021-05-12 | 3684832.0 | 63489882.0 | 1351.0 | 2097.0 | 236761.0 | 13187.0 | 1299316.0 | 0.010149 |
517 | 517 | 2021-07-01 | 3737950.0 | 70626703.0 | 2159.0 | 2526.0 | 132832.0 | 13199.0 | 826550.0 | 0.015969 |
85 | 85 | 2020-04-25 | 56682.0 | 593520.0 | 1618.0 | 1711.0 | 19948.0 | 13316.0 | 155288.0 | 0.08575 |
466 | 466 | 2021-05-11 | 3683481.0 | 63253121.0 | 1465.0 | 2205.0 | 253636.0 | 13384.0 | 1295945.0 | 0.010328 |
86 | 86 | 2020-04-26 | 57952.0 | 605026.0 | 1270.0 | 1014.0 | 11506.0 | 13429.0 | 158129.0 | 0.084924 |
465 | 465 | 2021-05-10 | 3682016.0 | 62999485.0 | 1633.0 | 2269.0 | 287164.0 | 13557.0 | 1295982.0 | 0.010461 |
464 | 464 | 2021-05-09 | 3680383.0 | 62712321.0 | 940.0 | 908.0 | 54394.0 | 13888.0 | 1295668.0 | 0.010719 |
87 | 87 | 2020-04-27 | 60202.0 | 639846.0 | 2250.0 | 2746.0 | 34820.0 | 13996.0 | 170797.0 | 0.081945 |
518 | 518 | 2021-07-02 | 3739967.0 | 70736348.0 | 2017.0 | 2419.0 | 109645.0 | 14001.0 | 815552.0 | 0.017168 |
463 | 463 | 2021-05-08 | 3679443.0 | 62657927.0 | 1049.0 | 1262.0 | 72195.0 | 14071.0 | 1300145.0 | 0.010823 |
521 | 521 | 2021-07-05 | 3745993.0 | 70908253.0 | 2790.0 | 2208.0 | 79673.0 | 14326.0 | 711795.0 | 0.020127 |
462 | 462 | 2021-05-07 | 3678394.0 | 62585732.0 | 1440.0 | 2118.0 | 181035.0 | 14351.0 | 1301949.0 | 0.011023 |
520 | 520 | 2021-07-04 | 3743203.0 | 70828580.0 | 1555.0 | 781.0 | 27994.0 | 14407.0 | 793687.0 | 0.018152 |
88 | 88 | 2020-04-28 | 62305.0 | 675457.0 | 2103.0 | 2555.0 | 35611.0 | 14522.0 | 181152.0 | 0.080165 |
519 | 519 | 2021-07-03 | 3741648.0 | 70800586.0 | 1681.0 | 1715.0 | 64238.0 | 14579.0 | 817310.0 | 0.017838 |
461 | 461 | 2021-05-06 | 3676954.0 | 62404697.0 | 1523.0 | 2328.0 | 214131.0 | 14623.0 | 1305495.0 | 0.011201 |
460 | 460 | 2021-05-05 | 3675431.0 | 62190566.0 | 1696.0 | 2294.0 | 233390.0 | 14783.0 | 1303852.0 | 0.011338 |
94 | 94 | 2020-05-04 | 73450.0 | 884934.0 | 2400.0 | 2708.0 | 45283.0 | 14819.0 | 245088.0 | 0.060464 |
92 | 92 | 2020-05-02 | 69899.0 | 824063.0 | 1389.0 | 1380.0 | 26644.0 | 14821.0 | 230543.0 | 0.064287 |
93 | 93 | 2020-05-03 | 71050.0 | 839651.0 | 1151.0 | 1050.0 | 15588.0 | 14857.0 | 234625.0 | 0.063322 |
89 | 89 | 2020-04-29 | 64341.0 | 711372.0 | 2036.0 | 2406.0 | 35915.0 | 14902.0 | 192968.0 | 0.077225 |
459 | 459 | 2021-05-04 | 3673735.0 | 61957176.0 | 1597.0 | 2378.0 | 253673.0 | 15049.0 | 1311245.0 | 0.011477 |
90 | 90 | 2020-04-30 | 66279.0 | 752354.0 | 1938.0 | 2359.0 | 40982.0 | 15119.0 | 208460.0 | 0.072527 |
91 | 91 | 2020-05-01 | 68510.0 | 797419.0 | 2231.0 | 2361.0 | 45065.0 | 15152.0 | 223847.0 | 0.067689 |
95 | 95 | 2020-05-05 | 76031.0 | 933158.0 | 2581.0 | 2971.0 | 48224.0 | 15235.0 | 257701.0 | 0.059119 |
458 | 458 | 2021-05-03 | 3672138.0 | 61703503.0 | 1966.0 | 2600.0 | 286850.0 | 15290.0 | 1318910.0 | 0.011593 |
457 | 457 | 2021-05-02 | 3670172.0 | 61416653.0 | 1103.0 | 1091.0 | 58871.0 | 15539.0 | 1332384.0 | 0.011663 |
96 | 96 | 2020-05-06 | 78376.0 | 989516.0 | 2345.0 | 2904.0 | 56358.0 | 15733.0 | 278144.0 | 0.056564 |
456 | 456 | 2021-05-01 | 3669069.0 | 61357782.0 | 1276.0 | 1542.0 | 73999.0 | 15761.0 | 1345470.0 | 0.011714 |
455 | 455 | 2021-04-30 | 3667793.0 | 61283783.0 | 1645.0 | 2390.0 | 184581.0 | 15891.0 | 1357140.0 | 0.011709 |
97 | 97 | 2020-05-07 | 80521.0 | 1043018.0 | 2145.0 | 2558.0 | 53502.0 | 15932.0 | 290664.0 | 0.054812 |
522 | 522 | 2021-07-06 | 3749600.0 | 71093327.0 | 3607.0 | 4006.0 | 185074.0 | 16071.0 | 743795.0 | 0.021607 |
98 | 98 | 2020-05-08 | 82791.0 | 1096280.0 | 2270.0 | 2583.0 | 53262.0 | 16154.0 | 298861.0 | 0.054052 |
454 | 454 | 2021-04-29 | 3666148.0 | 61099202.0 | 1661.0 | 2488.0 | 212488.0 | 16217.0 | 1371300.0 | 0.011826 |
100 | 100 | 2020-05-10 | 85702.0 | 1138617.0 | 1327.0 | 924.0 | 14871.0 | 16226.0 | 298966.0 | 0.054274 |
102 | 102 | 2020-05-12 | 90617.0 | 1249577.0 | 2473.0 | 2962.0 | 59446.0 | 16279.0 | 316419.0 | 0.051448 |
101 | 101 | 2020-05-11 | 88144.0 | 1190131.0 | 2442.0 | 2770.0 | 51514.0 | 16288.0 | 305197.0 | 0.053369 |
103 | 103 | 2020-05-13 | 92921.0 | 1306767.0 | 2304.0 | 2927.0 | 57190.0 | 16302.0 | 317251.0 | 0.051385 |
99 | 99 | 2020-05-09 | 84375.0 | 1123746.0 | 1584.0 | 1578.0 | 27466.0 | 16352.0 | 299683.0 | 0.054564 |
453 | 453 | 2021-04-28 | 3664487.0 | 60886714.0 | 1822.0 | 2560.0 | 240783.0 | 16450.0 | 1380969.0 | 0.011912 |
452 | 452 | 2021-04-27 | 3662665.0 | 60645931.0 | 1873.0 | 2619.0 | 261338.0 | 16891.0 | 1390341.0 | 0.012149 |
451 | 451 | 2021-04-26 | 3660792.0 | 60384593.0 | 2103.0 | 2849.0 | 300324.0 | 17148.0 | 1394580.0 | 0.012296 |
104 | 104 | 2020-05-14 | 95582.0 | 1364734.0 | 2661.0 | 3417.0 | 57967.0 | 17161.0 | 321716.0 | 0.053342 |
450 | 450 | 2021-04-25 | 3658689.0 | 60084269.0 | 1217.0 | 1313.0 | 71957.0 | 17570.0 | 1397079.0 | 0.012576 |
449 | 449 | 2021-04-24 | 3657472.0 | 60012312.0 | 1372.0 | 1672.0 | 85669.0 | 17761.0 | 1397224.0 | 0.012712 |
523 | 523 | 2021-07-07 | 3753356.0 | 71247332.0 | 3756.0 | 4291.0 | 154005.0 | 17946.0 | 753461.0 | 0.023818 |
105 | 105 | 2020-05-15 | 98096.0 | 1427706.0 | 2514.0 | 3396.0 | 62972.0 | 17974.0 | 331426.0 | 0.054232 |
448 | 448 | 2021-04-23 | 3656100.0 | 59926643.0 | 1819.0 | 2716.0 | 198741.0 | 18022.0 | 1405172.0 | 0.012825 |
106 | 106 | 2020-05-16 | 99829.0 | 1462284.0 | 1733.0 | 1865.0 | 34578.0 | 18261.0 | 338538.0 | 0.053941 |
447 | 447 | 2021-04-22 | 3654281.0 | 59727902.0 | 1840.0 | 2721.0 | 222157.0 | 18451.0 | 1409865.0 | 0.013087 |
107 | 107 | 2020-05-17 | 101157.0 | 1479763.0 | 1328.0 | 1120.0 | 17479.0 | 18457.0 | 341146.0 | 0.054103 |
115 | 115 | 2020-05-25 | 119441.0 | 1881530.0 | 2229.0 | 1451.0 | 18629.0 | 18611.0 | 336898.0 | 0.055242 |
446 | 446 | 2021-04-21 | 3652441.0 | 59505745.0 | 1995.0 | 3001.0 | 250155.0 | 18823.0 | 1412377.0 | 0.013327 |
445 | 445 | 2021-04-20 | 3650446.0 | 59255590.0 | 2126.0 | 2876.0 | 265577.0 | 19215.0 | 1410381.0 | 0.013624 |
108 | 108 | 2020-05-18 | 103953.0 | 1544632.0 | 2796.0 | 3714.0 | 64869.0 | 19401.0 | 354501.0 | 0.054728 |
784 | 784 | 2022-03-25 | 8518904.0 | 155330841.0 | 2001.0 | 2796.0 | 237439.0 | 19551.0 | 1555395.0 | 0.01257 |
783 | 783 | 2022-03-24 | 8516903.0 | 155093402.0 | 2290.0 | 3082.0 | 279837.0 | 19564.0 | 1572977.0 | 0.012438 |
788 | 788 | 2022-03-29 | 8527504.0 | 156024110.0 | 2703.0 | 3539.0 | 316340.0 | 19629.0 | 1495172.0 | 0.013128 |
444 | 444 | 2021-04-19 | 3648320.0 | 58990013.0 | 2436.0 | 3271.0 | 302823.0 | 19650.0 | 1406367.0 | 0.013972 |
782 | 782 | 2022-03-23 | 8514613.0 | 154813565.0 | 2254.0 | 3071.0 | 284627.0 | 19651.0 | 1589509.0 | 0.012363 |
785 | 785 | 2022-03-26 | 8520346.0 | 155396105.0 | 1442.0 | 1782.0 | 65264.0 | 19704.0 | 1555619.0 | 0.012666 |
429 | 429 | 2021-04-04 | 3615246.0 | 55977829.0 | 1552.0 | 1275.0 | 51321.0 | 19768.0 | 1163899.0 | 0.016984 |
780 | 780 | 2022-03-21 | 8509345.0 | 154234987.0 | 2692.0 | 3649.0 | 336253.0 | 19789.0 | 1662256.0 | 0.011905 |
430 | 430 | 2021-04-05 | 3618124.0 | 56258420.0 | 2878.0 | 3757.0 | 280591.0 | 19901.0 | 1177681.0 | 0.016898 |
524 | 524 | 2021-07-08 | 3756924.0 | 71387877.0 | 3568.0 | 4486.0 | 140545.0 | 19906.0 | 761174.0 | 0.026152 |
786 | 786 | 2022-03-27 | 8521907.0 | 155456786.0 | 1561.0 | 1695.0 | 60681.0 | 19943.0 | 1558052.0 | 0.0128 |
109 | 109 | 2020-05-19 | 106366.0 | 1610682.0 | 2413.0 | 3511.0 | 66050.0 | 19950.0 | 361105.0 | 0.055247 |
787 | 787 | 2022-03-28 | 8524801.0 | 155707770.0 | 2894.0 | 3664.0 | 250984.0 | 19958.0 | 1472783.0 | 0.013551 |
431 | 431 | 2021-04-06 | 3620673.0 | 56503731.0 | 2549.0 | 3347.0 | 245311.0 | 19965.0 | 1188645.0 | 0.016796 |
427 | 427 | 2021-04-02 | 3611990.0 | 55851387.0 | 2233.0 | 3085.0 | 156815.0 | 20001.0 | 1178221.0 | 0.016976 |
789 | 789 | 2022-03-30 | 8530143.0 | 156320232.0 | 2639.0 | 3458.0 | 296122.0 | 20016.0 | 1506667.0 | 0.013285 |
428 | 428 | 2021-04-03 | 3613694.0 | 55926508.0 | 1704.0 | 2044.0 | 75121.0 | 20022.0 | 1177729.0 | 0.017001 |
443 | 443 | 2021-04-18 | 3645884.0 | 58687190.0 | 1428.0 | 1504.0 | 72102.0 | 20058.0 | 1413848.0 | 0.014187 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-positive-test-rate" ( [date] TEXT, [confirmed_cases] FLOAT, [total_tests] FLOAT, [new_confirmed_cases] FLOAT, [new_positive_tests] FLOAT, [new_tests] FLOAT, [new_confirmed_cases_seven_day_total] FLOAT, [new_tests_seven_day_total] FLOAT, [positive_test_rate_seven_day_percent] FLOAT );