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
673 rows
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 2020-02-01 | 25.0 | 303.0 | 25.0 | 9.0 | 303.0 | |||
| 2 | 2 | 2020-02-02 | 32.0 | 337.0 | 7.0 | 2.0 | 34.0 | |||
| 3 | 3 | 2020-02-03 | 37.0 | 366.0 | 5.0 | 1.0 | 29.0 | |||
| 4 | 4 | 2020-02-04 | 38.0 | 397.0 | 1.0 | 1.0 | 31.0 | |||
| 5 | 5 | 2020-02-05 | 41.0 | 440.0 | 3.0 | 1.0 | 43.0 | |||
| 6 | 6 | 2020-02-06 | 47.0 | 452.0 | 6.0 | 1.0 | 12.0 | |||
| 7 | 7 | 2020-02-07 | 79.0 | 904.0 | 32.0 | 62.0 | 452.0 | 77.0 | 904.0 | 0.085177 |
| 8 | 8 | 2020-02-08 | 86.0 | 961.0 | 7.0 | 1.0 | 57.0 | 69.0 | 658.0 | 0.104863 |
| 9 | 9 | 2020-02-09 | 92.0 | 982.0 | 6.0 | 1.0 | 21.0 | 68.0 | 645.0 | 0.105426 |
| 10 | 10 | 2020-02-10 | 99.0 | 998.0 | 7.0 | 1.0 | 16.0 | 68.0 | 632.0 | 0.107595 |
| 11 | 11 | 2020-02-11 | 103.0 | 1038.0 | 4.0 | 0.0 | 40.0 | 67.0 | 641.0 | 0.104524 |
| 12 | 12 | 2020-02-12 | 106.0 | 1041.0 | 3.0 | 0.0 | 3.0 | 66.0 | 601.0 | 0.109817 |
| 13 | 13 | 2020-02-13 | 108.0 | 1051.0 | 2.0 | 0.0 | 10.0 | 65.0 | 599.0 | 0.108514 |
| 14 | 14 | 2020-02-14 | 117.0 | 1062.0 | 9.0 | 0.0 | 11.0 | 3.0 | 158.0 | 0.018987 |
| 15 | 15 | 2020-02-15 | 129.0 | 1102.0 | 12.0 | 0.0 | 40.0 | 2.0 | 141.0 | 0.014184 |
| 16 | 16 | 2020-02-16 | 136.0 | 1166.0 | 7.0 | 2.0 | 64.0 | 3.0 | 184.0 | 0.016304 |
| 17 | 17 | 2020-02-17 | 150.0 | 1251.0 | 14.0 | 0.0 | 85.0 | 2.0 | 253.0 | 0.007905 |
| 18 | 18 | 2020-02-18 | 160.0 | 1267.0 | 10.0 | 1.0 | 16.0 | 3.0 | 229.0 | 0.0131 |
| 19 | 19 | 2020-02-19 | 171.0 | 1277.0 | 11.0 | 0.0 | 10.0 | 3.0 | 236.0 | 0.012712 |
| 20 | 20 | 2020-02-20 | 192.0 | 1303.0 | 21.0 | 2.0 | 26.0 | 5.0 | 252.0 | 0.019841 |
| 21 | 21 | 2020-02-21 | 212.0 | 1318.0 | 20.0 | 1.0 | 15.0 | 6.0 | 256.0 | 0.023438 |
| 22 | 22 | 2020-02-22 | 229.0 | 1345.0 | 17.0 | 0.0 | 27.0 | 6.0 | 243.0 | 0.024691 |
| 23 | 23 | 2020-02-23 | 248.0 | 1382.0 | 19.0 | 3.0 | 37.0 | 7.0 | 216.0 | 0.032407 |
| 24 | 24 | 2020-02-24 | 287.0 | 1402.0 | 39.0 | 3.0 | 20.0 | 10.0 | 151.0 | 0.066225 |
| 25 | 25 | 2020-02-25 | 311.0 | 1414.0 | 24.0 | 1.0 | 12.0 | 10.0 | 147.0 | 0.068027 |
| 26 | 26 | 2020-02-26 | 350.0 | 1437.0 | 39.0 | 3.0 | 23.0 | 13.0 | 160.0 | 0.08125 |
| 27 | 27 | 2020-02-27 | 375.0 | 1515.0 | 25.0 | 9.0 | 78.0 | 20.0 | 212.0 | 0.09434 |
| 28 | 28 | 2020-02-28 | 423.0 | 1635.0 | 48.0 | 17.0 | 120.0 | 36.0 | 317.0 | 0.113565 |
| 29 | 29 | 2020-02-29 | 463.0 | 1724.0 | 40.0 | 16.0 | 89.0 | 52.0 | 379.0 | 0.137203 |
| 30 | 30 | 2020-03-01 | 563.0 | 1802.0 | 100.0 | 4.0 | 78.0 | 53.0 | 420.0 | 0.12619 |
| 31 | 31 | 2020-03-02 | 639.0 | 1979.0 | 76.0 | 33.0 | 177.0 | 83.0 | 577.0 | 0.143847 |
| 32 | 32 | 2020-03-03 | 723.0 | 2121.0 | 84.0 | 25.0 | 142.0 | 107.0 | 707.0 | 0.151344 |
| 33 | 33 | 2020-03-04 | 818.0 | 2357.0 | 95.0 | 39.0 | 236.0 | 143.0 | 920.0 | 0.155435 |
| 34 | 34 | 2020-03-05 | 928.0 | 2724.0 | 110.0 | 36.0 | 367.0 | 170.0 | 1209.0 | 0.140612 |
| 35 | 35 | 2020-03-06 | 1083.0 | 3135.0 | 155.0 | 31.0 | 411.0 | 184.0 | 1500.0 | 0.122667 |
| 36 | 36 | 2020-03-07 | 1246.0 | 3639.0 | 163.0 | 76.0 | 504.0 | 244.0 | 1915.0 | 0.127415 |
| 37 | 37 | 2020-03-08 | 1426.0 | 3960.0 | 180.0 | 51.0 | 321.0 | 291.0 | 2158.0 | 0.134847 |
| 38 | 38 | 2020-03-09 | 1753.0 | 4986.0 | 327.0 | 130.0 | 1026.0 | 388.0 | 3007.0 | 0.129032 |
| 39 | 39 | 2020-03-10 | 2106.0 | 6172.0 | 353.0 | 124.0 | 1186.0 | 487.0 | 4051.0 | 0.120217 |
| 40 | 40 | 2020-03-11 | 2529.0 | 8031.0 | 423.0 | 170.0 | 1859.0 | 618.0 | 5674.0 | 0.108918 |
| 41 | 41 | 2020-03-12 | 3032.0 | 11490.0 | 503.0 | 238.0 | 3459.0 | 820.0 | 8766.0 | 0.093543 |
| 42 | 42 | 2020-03-13 | 3601.0 | 15956.0 | 569.0 | 332.0 | 4466.0 | 1121.0 | 12821.0 | 0.087435 |
| 43 | 43 | 2020-03-14 | 4103.0 | 18737.0 | 502.0 | 312.0 | 2781.0 | 1357.0 | 15098.0 | 0.089879 |
| 44 | 44 | 2020-03-15 | 4704.0 | 21501.0 | 601.0 | 255.0 | 2764.0 | 1561.0 | 17541.0 | 0.088992 |
| 45 | 45 | 2020-03-16 | 5562.0 | 29262.0 | 858.0 | 579.0 | 7761.0 | 2010.0 | 24276.0 | 0.082798 |
| 46 | 46 | 2020-03-17 | 6388.0 | 38204.0 | 826.0 | 654.0 | 8942.0 | 2540.0 | 32032.0 | 0.079296 |
| 47 | 47 | 2020-03-18 | 7146.0 | 47129.0 | 758.0 | 616.0 | 8925.0 | 2986.0 | 39098.0 | 0.076372 |
| 48 | 48 | 2020-03-19 | 7913.0 | 56154.0 | 767.0 | 663.0 | 9025.0 | 3411.0 | 44664.0 | 0.07637 |
| 49 | 49 | 2020-03-20 | 8858.0 | 66188.0 | 945.0 | 769.0 | 10034.0 | 3848.0 | 50232.0 | 0.076605 |
| 50 | 50 | 2020-03-21 | 9541.0 | 71271.0 | 683.0 | 478.0 | 5083.0 | 4014.0 | 52534.0 | 0.076408 |
| 51 | 51 | 2020-03-22 | 10294.0 | 75913.0 | 753.0 | 608.0 | 4642.0 | 4367.0 | 54412.0 | 0.080258 |
| 52 | 52 | 2020-03-23 | 11306.0 | 88493.0 | 1012.0 | 1212.0 | 12580.0 | 5000.0 | 59231.0 | 0.084415 |
| 53 | 53 | 2020-03-24 | 12144.0 | 100428.0 | 838.0 | 1205.0 | 11935.0 | 5551.0 | 62224.0 | 0.08921 |
| 54 | 54 | 2020-03-25 | 13194.0 | 112150.0 | 1050.0 | 1207.0 | 11722.0 | 6142.0 | 65021.0 | 0.094462 |
| 55 | 55 | 2020-03-26 | 14159.0 | 123929.0 | 965.0 | 1184.0 | 11779.0 | 6663.0 | 67775.0 | 0.098311 |
| 56 | 56 | 2020-03-27 | 15152.0 | 136499.0 | 993.0 | 1317.0 | 12570.0 | 7211.0 | 70311.0 | 0.102559 |
| 57 | 57 | 2020-03-28 | 16096.0 | 144496.0 | 944.0 | 1037.0 | 7997.0 | 7770.0 | 73225.0 | 0.106111 |
| 58 | 58 | 2020-03-29 | 16921.0 | 149737.0 | 825.0 | 698.0 | 5241.0 | 7860.0 | 73824.0 | 0.106469 |
| 59 | 59 | 2020-03-30 | 18294.0 | 163694.0 | 1373.0 | 1610.0 | 13957.0 | 8258.0 | 75201.0 | 0.109812 |
| 60 | 60 | 2020-03-31 | 19546.0 | 177437.0 | 1252.0 | 1554.0 | 13743.0 | 8607.0 | 77009.0 | 0.111766 |
| 61 | 61 | 2020-04-01 | 21049.0 | 192409.0 | 1503.0 | 1762.0 | 14972.0 | 9162.0 | 80259.0 | 0.114155 |
| 62 | 62 | 2020-04-02 | 22416.0 | 207513.0 | 1367.0 | 1695.0 | 15104.0 | 9673.0 | 83584.0 | 0.115728 |
| 63 | 63 | 2020-04-03 | 23929.0 | 222818.0 | 1513.0 | 1537.0 | 15305.0 | 9893.0 | 86319.0 | 0.11461 |
| 64 | 64 | 2020-04-04 | 25053.0 | 230825.0 | 1124.0 | 1078.0 | 8007.0 | 9934.0 | 86329.0 | 0.115071 |
| 65 | 65 | 2020-04-05 | 26195.0 | 236898.0 | 1142.0 | 985.0 | 6073.0 | 10221.0 | 87161.0 | 0.117266 |
| 66 | 66 | 2020-04-06 | 27552.0 | 250582.0 | 1357.0 | 1543.0 | 13684.0 | 10154.0 | 86888.0 | 0.116863 |
| 67 | 67 | 2020-04-07 | 28972.0 | 265812.0 | 1420.0 | 1774.0 | 15230.0 | 10374.0 | 88375.0 | 0.117386 |
| 68 | 68 | 2020-04-08 | 30437.0 | 281788.0 | 1465.0 | 1774.0 | 15976.0 | 10386.0 | 89379.0 | 0.116202 |
| 69 | 69 | 2020-04-09 | 31835.0 | 299657.0 | 1398.0 | 1761.0 | 17869.0 | 10452.0 | 92144.0 | 0.113431 |
| 70 | 70 | 2020-04-10 | 33301.0 | 317803.0 | 1466.0 | 1699.0 | 18146.0 | 10614.0 | 94985.0 | 0.111744 |
| 71 | 71 | 2020-04-11 | 34350.0 | 327004.0 | 1049.0 | 1072.0 | 9201.0 | 10608.0 | 96179.0 | 0.110294 |
| 72 | 72 | 2020-04-12 | 35326.0 | 332749.0 | 976.0 | 736.0 | 5745.0 | 10359.0 | 95851.0 | 0.108074 |
| 73 | 73 | 2020-04-13 | 36840.0 | 348065.0 | 1514.0 | 1914.0 | 15316.0 | 10730.0 | 97483.0 | 0.11007 |
| 74 | 74 | 2020-04-14 | 38323.0 | 364781.0 | 1483.0 | 1756.0 | 16716.0 | 10712.0 | 98969.0 | 0.108236 |
| 75 | 75 | 2020-04-15 | 39989.0 | 384682.0 | 1666.0 | 1983.0 | 19901.0 | 10921.0 | 102894.0 | 0.106138 |
| 76 | 76 | 2020-04-16 | 41654.0 | 404345.0 | 1665.0 | 1878.0 | 19663.0 | 11038.0 | 104688.0 | 0.105437 |
| 77 | 77 | 2020-04-17 | 43243.0 | 425056.0 | 1589.0 | 1741.0 | 20711.0 | 11080.0 | 107253.0 | 0.103307 |
| 78 | 78 | 2020-04-18 | 44444.0 | 438028.0 | 1201.0 | 1273.0 | 12972.0 | 11281.0 | 111024.0 | 0.101609 |
| 79 | 79 | 2020-04-19 | 45512.0 | 446679.0 | 1068.0 | 901.0 | 8651.0 | 11446.0 | 113930.0 | 0.100465 |
| 80 | 80 | 2020-04-20 | 47411.0 | 468818.0 | 1899.0 | 2179.0 | 22139.0 | 11711.0 | 120753.0 | 0.096983 |
| 81 | 81 | 2020-04-21 | 49075.0 | 494052.0 | 1664.0 | 2029.0 | 25234.0 | 11984.0 | 129271.0 | 0.092704 |
| 82 | 82 | 2020-04-22 | 50824.0 | 518133.0 | 1749.0 | 2026.0 | 24081.0 | 12027.0 | 133451.0 | 0.090123 |
| 83 | 83 | 2020-04-23 | 52659.0 | 543592.0 | 1835.0 | 2142.0 | 25459.0 | 12291.0 | 139247.0 | 0.088268 |
| 84 | 84 | 2020-04-24 | 54666.0 | 573251.0 | 2007.0 | 2329.0 | 29659.0 | 12879.0 | 148195.0 | 0.086906 |
| 85 | 85 | 2020-04-25 | 56272.0 | 593182.0 | 1606.0 | 1711.0 | 19931.0 | 13317.0 | 155154.0 | 0.085831 |
| 86 | 86 | 2020-04-26 | 57528.0 | 604668.0 | 1256.0 | 1014.0 | 11486.0 | 13430.0 | 157989.0 | 0.085006 |
| 87 | 87 | 2020-04-27 | 59766.0 | 639462.0 | 2238.0 | 2743.0 | 34794.0 | 13994.0 | 170644.0 | 0.082007 |
| 88 | 88 | 2020-04-28 | 61862.0 | 675046.0 | 2096.0 | 2554.0 | 35584.0 | 14519.0 | 180994.0 | 0.080218 |
| 89 | 89 | 2020-04-29 | 63890.0 | 710936.0 | 2028.0 | 2406.0 | 35890.0 | 14899.0 | 192803.0 | 0.077276 |
| 90 | 90 | 2020-04-30 | 65810.0 | 751876.0 | 1920.0 | 2358.0 | 40940.0 | 15115.0 | 208284.0 | 0.072569 |
| 91 | 91 | 2020-05-01 | 68032.0 | 796917.0 | 2222.0 | 2362.0 | 45041.0 | 15148.0 | 223666.0 | 0.067726 |
| 92 | 92 | 2020-05-02 | 69419.0 | 823535.0 | 1387.0 | 1380.0 | 26618.0 | 14817.0 | 230353.0 | 0.064323 |
| 93 | 93 | 2020-05-03 | 70566.0 | 839095.0 | 1147.0 | 1050.0 | 15560.0 | 14853.0 | 234427.0 | 0.063359 |
| 94 | 94 | 2020-05-04 | 72984.0 | 884359.0 | 2418.0 | 2708.0 | 45264.0 | 14818.0 | 244897.0 | 0.060507 |
| 95 | 95 | 2020-05-05 | 75587.0 | 932558.0 | 2603.0 | 2971.0 | 48199.0 | 15235.0 | 257512.0 | 0.059162 |
| 96 | 96 | 2020-05-06 | 77922.0 | 988899.0 | 2335.0 | 2904.0 | 56341.0 | 15733.0 | 277963.0 | 0.056601 |
| 97 | 97 | 2020-05-07 | 80065.0 | 1042383.0 | 2143.0 | 2558.0 | 53484.0 | 15933.0 | 290507.0 | 0.054845 |
| 98 | 98 | 2020-05-08 | 82321.0 | 1095618.0 | 2256.0 | 2583.0 | 53235.0 | 16154.0 | 298701.0 | 0.054081 |
| 99 | 99 | 2020-05-09 | 83895.0 | 1123066.0 | 1574.0 | 1578.0 | 27448.0 | 16352.0 | 299531.0 | 0.054592 |
| 100 | 100 | 2020-05-10 | 85222.0 | 1137925.0 | 1327.0 | 923.0 | 14859.0 | 16225.0 | 298830.0 | 0.054295 |
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 );