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 positive_test_rate_seven_day_percent
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|
493 | 493 | 2021-06-07 | 3709197.0 | 67647904.0 | 1043.0 | 1499.0 | 212477.0 | 8748.0 | 1212102.0 | 0.007217 |
492 | 492 | 2021-06-06 | 3708154.0 | 67435427.0 | 610.0 | 662.0 | 58485.0 | 7776.0 | 1060197.0 | 0.007334 |
491 | 491 | 2021-06-05 | 3707544.0 | 67376942.0 | 643.0 | 848.0 | 74627.0 | 7764.0 | 1053747.0 | 0.007368 |
490 | 490 | 2021-06-04 | 3706901.0 | 67302315.0 | 852.0 | 1309.0 | 176652.0 | 7661.0 | 1038386.0 | 0.007378 |
489 | 489 | 2021-06-03 | 3706049.0 | 67125663.0 | 996.0 | 1298.0 | 189353.0 | 7603.0 | 1015642.0 | 0.007486 |
494 | 494 | 2021-06-08 | 3710248.0 | 67833345.0 | 1051.0 | 1352.0 | 185441.0 | 8396.0 | 1116193.0 | 0.007522 |
488 | 488 | 2021-06-02 | 3705053.0 | 66936310.0 | 1044.0 | 1428.0 | 219158.0 | 7639.0 | 1006757.0 | 0.007588 |
485 | 485 | 2021-05-30 | 3702204.0 | 66375230.0 | 585.0 | 650.0 | 52035.0 | 8656.0 | 1134047.0 | 0.007633 |
484 | 484 | 2021-05-29 | 3701619.0 | 66323195.0 | 603.0 | 745.0 | 59266.0 | 8734.0 | 1137667.0 | 0.007677 |
487 | 487 | 2021-06-01 | 3704009.0 | 66717152.0 | 1210.0 | 1704.0 | 281350.0 | 7668.0 | 991066.0 | 0.007737 |
483 | 483 | 2021-05-28 | 3701016.0 | 66263929.0 | 862.0 | 1251.0 | 153908.0 | 8895.0 | 1143376.0 | 0.00778 |
495 | 495 | 2021-06-09 | 3711175.0 | 67990599.0 | 927.0 | 1265.0 | 157254.0 | 8233.0 | 1054289.0 | 0.007809 |
482 | 482 | 2021-05-27 | 3700154.0 | 66110021.0 | 922.0 | 1334.0 | 180468.0 | 9104.0 | 1163316.0 | 0.007826 |
481 | 481 | 2021-05-26 | 3699232.0 | 65929553.0 | 982.0 | 1457.0 | 203467.0 | 9354.0 | 1183834.0 | 0.007901 |
496 | 496 | 2021-06-10 | 3712051.0 | 68149981.0 | 876.0 | 1191.0 | 159382.0 | 8126.0 | 1024318.0 | 0.007933 |
480 | 480 | 2021-05-25 | 3698250.0 | 65726086.0 | 1042.0 | 1549.0 | 230007.0 | 9593.0 | 1206958.0 | 0.007948 |
486 | 486 | 2021-05-31 | 3702799.0 | 66435802.0 | 595.0 | 527.0 | 60572.0 | 7513.0 | 939723.0 | 0.007995 |
497 | 497 | 2021-06-11 | 3712903.0 | 68291603.0 | 852.0 | 1206.0 | 141622.0 | 8023.0 | 989288.0 | 0.00811 |
498 | 498 | 2021-06-12 | 3713580.0 | 68355991.0 | 677.0 | 765.0 | 64388.0 | 7940.0 | 979049.0 | 0.00811 |
499 | 499 | 2021-06-13 | 3714281.0 | 68410334.0 | 701.0 | 639.0 | 54343.0 | 7917.0 | 974907.0 | 0.008121 |
479 | 479 | 2021-05-24 | 3697208.0 | 65496079.0 | 1206.0 | 1670.0 | 254896.0 | 9897.0 | 1218207.0 | 0.008124 |
478 | 478 | 2021-05-23 | 3696002.0 | 65241183.0 | 662.0 | 728.0 | 55655.0 | 10184.0 | 1239282.0 | 0.008218 |
477 | 477 | 2021-05-22 | 3695340.0 | 65185528.0 | 710.0 | 906.0 | 64975.0 | 10359.0 | 1241229.0 | 0.008346 |
500 | 500 | 2021-06-14 | 3715437.0 | 68578059.0 | 1156.0 | 1485.0 | 167725.0 | 7903.0 | 930155.0 | 0.008496 |
476 | 476 | 2021-05-21 | 3694630.0 | 65120553.0 | 948.0 | 1460.0 | 173848.0 | 10603.0 | 1244911.0 | 0.008517 |
501 | 501 | 2021-06-15 | 3716485.0 | 68728060.0 | 1048.0 | 1278.0 | 150001.0 | 7829.0 | 894715.0 | 0.00875 |
475 | 475 | 2021-05-20 | 3693682.0 | 64946705.0 | 999.0 | 1584.0 | 200986.0 | 10940.0 | 1248621.0 | 0.008762 |
474 | 474 | 2021-05-19 | 3692683.0 | 64745719.0 | 1191.0 | 1696.0 | 226591.0 | 11176.0 | 1255837.0 | 0.008899 |
502 | 502 | 2021-06-16 | 3717548.0 | 68865757.0 | 1063.0 | 1391.0 | 137697.0 | 7955.0 | 875158.0 | 0.00909 |
473 | 473 | 2021-05-18 | 3691492.0 | 64519128.0 | 1231.0 | 1853.0 | 241256.0 | 11577.0 | 1266007.0 | 0.009144 |
472 | 472 | 2021-05-17 | 3690261.0 | 64277872.0 | 1339.0 | 1957.0 | 275971.0 | 11929.0 | 1278387.0 | 0.009331 |
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 |
469 | 469 | 2021-05-14 | 3687209.0 | 63875642.0 | 1179.0 | 1797.0 | 177558.0 | 12358.0 | 1289910.0 | 0.009581 |
503 | 503 | 2021-06-17 | 3718574.0 | 68990683.0 | 1026.0 | 1375.0 | 124926.0 | 8139.0 | 840702.0 | 0.009681 |
468 | 468 | 2021-05-13 | 3686030.0 | 63698084.0 | 1198.0 | 1820.0 | 208202.0 | 12679.0 | 1293387.0 | 0.009803 |
504 | 504 | 2021-06-18 | 3719504.0 | 69111768.0 | 930.0 | 1283.0 | 121085.0 | 8216.0 | 820165.0 | 0.010017 |
467 | 467 | 2021-05-12 | 3684832.0 | 63489882.0 | 1351.0 | 2097.0 | 236761.0 | 13187.0 | 1299316.0 | 0.010149 |
505 | 505 | 2021-06-19 | 3720258.0 | 69174093.0 | 754.0 | 928.0 | 62325.0 | 8379.0 | 818102.0 | 0.010242 |
466 | 466 | 2021-05-11 | 3683481.0 | 63253121.0 | 1465.0 | 2205.0 | 253636.0 | 13384.0 | 1295945.0 | 0.010328 |
506 | 506 | 2021-06-20 | 3721058.0 | 69223169.0 | 800.0 | 664.0 | 49076.0 | 8404.0 | 812835.0 | 0.010339 |
465 | 465 | 2021-05-10 | 3682016.0 | 62999485.0 | 1633.0 | 2269.0 | 287164.0 | 13557.0 | 1295982.0 | 0.010461 |
507 | 507 | 2021-06-21 | 3722459.0 | 69386290.0 | 1401.0 | 1621.0 | 163121.0 | 8540.0 | 808231.0 | 0.010566 |
464 | 464 | 2021-05-09 | 3680383.0 | 62712321.0 | 940.0 | 908.0 | 54394.0 | 13888.0 | 1295668.0 | 0.010719 |
463 | 463 | 2021-05-08 | 3679443.0 | 62657927.0 | 1049.0 | 1262.0 | 72195.0 | 14071.0 | 1300145.0 | 0.010823 |
462 | 462 | 2021-05-07 | 3678394.0 | 62585732.0 | 1440.0 | 2118.0 | 181035.0 | 14351.0 | 1301949.0 | 0.011023 |
508 | 508 | 2021-06-22 | 3723768.0 | 69535402.0 | 1309.0 | 1661.0 | 149112.0 | 8923.0 | 807342.0 | 0.011052 |
461 | 461 | 2021-05-06 | 3676954.0 | 62404697.0 | 1523.0 | 2328.0 | 214131.0 | 14623.0 | 1305495.0 | 0.011201 |
17 | 17 | 2020-02-17 | 150.0 | 1273.0 | 13.0 | 0.0 | 85.0 | 3.0 | 266.0 | 0.011278 |
509 | 509 | 2021-06-23 | 3725000.0 | 69674979.0 | 1232.0 | 1627.0 | 139577.0 | 9159.0 | 809222.0 | 0.011318 |
460 | 460 | 2021-05-05 | 3675431.0 | 62190566.0 | 1696.0 | 2294.0 | 233390.0 | 14783.0 | 1303852.0 | 0.011338 |
459 | 459 | 2021-05-04 | 3673735.0 | 61957176.0 | 1597.0 | 2378.0 | 253673.0 | 15049.0 | 1311245.0 | 0.011477 |
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 |
455 | 455 | 2021-04-30 | 3667793.0 | 61283783.0 | 1645.0 | 2390.0 | 184581.0 | 15891.0 | 1357140.0 | 0.011709 |
456 | 456 | 2021-05-01 | 3669069.0 | 61357782.0 | 1276.0 | 1542.0 | 73999.0 | 15761.0 | 1345470.0 | 0.011714 |
454 | 454 | 2021-04-29 | 3666148.0 | 61099202.0 | 1661.0 | 2488.0 | 212488.0 | 16217.0 | 1371300.0 | 0.011826 |
510 | 510 | 2021-06-24 | 3726397.0 | 69800153.0 | 1397.0 | 1816.0 | 125174.0 | 9600.0 | 809470.0 | 0.01186 |
780 | 780 | 2022-03-21 | 8509345.0 | 154234987.0 | 2692.0 | 3649.0 | 336253.0 | 19789.0 | 1662256.0 | 0.011905 |
453 | 453 | 2021-04-28 | 3664487.0 | 60886714.0 | 1822.0 | 2560.0 | 240783.0 | 16450.0 | 1380969.0 | 0.011912 |
779 | 779 | 2022-03-20 | 8506653.0 | 153898734.0 | 1304.0 | 1456.0 | 58248.0 | 20170.0 | 1687332.0 | 0.011954 |
778 | 778 | 2022-03-19 | 8505349.0 | 153840486.0 | 1257.0 | 1629.0 | 65040.0 | 20327.0 | 1692909.0 | 0.012007 |
452 | 452 | 2021-04-27 | 3662665.0 | 60645931.0 | 1873.0 | 2619.0 | 261338.0 | 16891.0 | 1390341.0 | 0.012149 |
777 | 777 | 2022-03-18 | 8504092.0 | 153775446.0 | 1991.0 | 2809.0 | 255021.0 | 20794.0 | 1698083.0 | 0.012246 |
511 | 511 | 2021-06-25 | 3727704.0 | 69920796.0 | 1307.0 | 1617.0 | 120643.0 | 9934.0 | 809028.0 | 0.012279 |
451 | 451 | 2021-04-26 | 3660792.0 | 60384593.0 | 2103.0 | 2849.0 | 300324.0 | 17148.0 | 1394580.0 | 0.012296 |
782 | 782 | 2022-03-23 | 8514613.0 | 154813565.0 | 2254.0 | 3071.0 | 284627.0 | 19651.0 | 1589509.0 | 0.012363 |
781 | 781 | 2022-03-22 | 8512359.0 | 154528938.0 | 3014.0 | 3868.0 | 293951.0 | 20065.0 | 1622140.0 | 0.012369 |
783 | 783 | 2022-03-24 | 8516903.0 | 155093402.0 | 2290.0 | 3082.0 | 279837.0 | 19564.0 | 1572977.0 | 0.012438 |
512 | 512 | 2021-06-26 | 3728779.0 | 69983276.0 | 1075.0 | 1137.0 | 62480.0 | 10143.0 | 809183.0 | 0.012535 |
784 | 784 | 2022-03-25 | 8518904.0 | 155330841.0 | 2001.0 | 2796.0 | 237439.0 | 19551.0 | 1555395.0 | 0.01257 |
450 | 450 | 2021-04-25 | 3658689.0 | 60084269.0 | 1217.0 | 1313.0 | 71957.0 | 17570.0 | 1397079.0 | 0.012576 |
776 | 776 | 2022-03-17 | 8502101.0 | 153520425.0 | 2302.0 | 3169.0 | 296369.0 | 21523.0 | 1707772.0 | 0.012603 |
785 | 785 | 2022-03-26 | 8520346.0 | 155396105.0 | 1442.0 | 1782.0 | 65264.0 | 19704.0 | 1555619.0 | 0.012666 |
449 | 449 | 2021-04-24 | 3657472.0 | 60012312.0 | 1372.0 | 1672.0 | 85669.0 | 17761.0 | 1397224.0 | 0.012712 |
786 | 786 | 2022-03-27 | 8521907.0 | 155456786.0 | 1561.0 | 1695.0 | 60681.0 | 19943.0 | 1558052.0 | 0.0128 |
448 | 448 | 2021-04-23 | 3656100.0 | 59926643.0 | 1819.0 | 2716.0 | 198741.0 | 18022.0 | 1405172.0 | 0.012825 |
775 | 775 | 2022-03-16 | 8499799.0 | 153224056.0 | 2467.0 | 3485.0 | 317258.0 | 22157.0 | 1725975.0 | 0.012837 |
513 | 513 | 2021-06-27 | 3729950.0 | 70034893.0 | 1171.0 | 953.0 | 51617.0 | 10432.0 | 811724.0 | 0.012852 |
447 | 447 | 2021-04-22 | 3654281.0 | 59727902.0 | 1840.0 | 2721.0 | 222157.0 | 18451.0 | 1409865.0 | 0.013087 |
788 | 788 | 2022-03-29 | 8527504.0 | 156024110.0 | 2703.0 | 3539.0 | 316340.0 | 19629.0 | 1495172.0 | 0.013128 |
774 | 774 | 2022-03-15 | 8497332.0 | 152906798.0 | 2625.0 | 3592.0 | 334067.0 | 22936.0 | 1736620.0 | 0.013207 |
789 | 789 | 2022-03-30 | 8530143.0 | 156320232.0 | 2639.0 | 3458.0 | 296122.0 | 20016.0 | 1506667.0 | 0.013285 |
446 | 446 | 2021-04-21 | 3652441.0 | 59505745.0 | 1995.0 | 3001.0 | 250155.0 | 18823.0 | 1412377.0 | 0.013327 |
787 | 787 | 2022-03-28 | 8524801.0 | 155707770.0 | 2894.0 | 3664.0 | 250984.0 | 19958.0 | 1472783.0 | 0.013551 |
790 | 790 | 2022-03-31 | 8532582.0 | 156579826.0 | 2439.0 | 3227.0 | 259594.0 | 20161.0 | 1486424.0 | 0.013563 |
445 | 445 | 2021-04-20 | 3650446.0 | 59255590.0 | 2126.0 | 2876.0 | 265577.0 | 19215.0 | 1410381.0 | 0.013624 |
773 | 773 | 2022-03-14 | 8494707.0 | 152572731.0 | 2901.0 | 4030.0 | 361329.0 | 23905.0 | 1746656.0 | 0.013686 |
514 | 514 | 2021-06-28 | 3731882.0 | 70196458.0 | 1932.0 | 2289.0 | 161565.0 | 11100.0 | 810168.0 | 0.013701 |
791 | 791 | 2022-04-01 | 8535211.0 | 156824119.0 | 2629.0 | 3234.0 | 244293.0 | 20599.0 | 1493278.0 | 0.013794 |
792 | 792 | 2022-04-02 | 8536934.0 | 156884320.0 | 1723.0 | 1919.0 | 60201.0 | 20736.0 | 1488215.0 | 0.013933 |
444 | 444 | 2021-04-19 | 3648320.0 | 58990013.0 | 2436.0 | 3271.0 | 302823.0 | 19650.0 | 1406367.0 | 0.013972 |
793 | 793 | 2022-04-03 | 8538708.0 | 156937797.0 | 1774.0 | 1850.0 | 53477.0 | 20891.0 | 1481011.0 | 0.014106 |
794 | 794 | 2022-04-04 | 8542500.0 | 157241029.0 | 3792.0 | 4523.0 | 303232.0 | 21750.0 | 1533259.0 | 0.014185 |
443 | 443 | 2021-04-18 | 3645884.0 | 58687190.0 | 1428.0 | 1504.0 | 72102.0 | 20058.0 | 1413848.0 | 0.014187 |
442 | 442 | 2021-04-17 | 3644456.0 | 58615088.0 | 1553.0 | 1933.0 | 93617.0 | 20182.0 | 1411408.0 | 0.014299 |
515 | 515 | 2021-06-29 | 3733763.0 | 70349532.0 | 1881.0 | 2261.0 | 153074.0 | 11700.0 | 814130.0 | 0.014371 |
772 | 772 | 2022-03-13 | 8491806.0 | 152211402.0 | 1293.0 | 1613.0 | 63825.0 | 25497.0 | 1765717.0 | 0.01444 |
441 | 441 | 2021-04-16 | 3642903.0 | 58521471.0 | 2052.0 | 3145.0 | 203434.0 | 20422.0 | 1399882.0 | 0.014588 |
771 | 771 | 2022-03-12 | 8490513.0 | 152147577.0 | 1529.0 | 2096.0 | 70214.0 | 26152.0 | 1767231.0 | 0.014798 |
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 );