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
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 | 24.0 | 304.0 | 24.0 | 9.0 | 304.0 | |||
| 2 | 2 | 2020-02-02 | 33.0 | 340.0 | 9.0 | 2.0 | 36.0 | |||
| 3 | 3 | 2020-02-03 | 40.0 | 369.0 | 7.0 | 1.0 | 29.0 | |||
| 4 | 4 | 2020-02-04 | 42.0 | 401.0 | 2.0 | 1.0 | 32.0 | |||
| 5 | 5 | 2020-02-05 | 45.0 | 446.0 | 3.0 | 1.0 | 45.0 | |||
| 6 | 6 | 2020-02-06 | 51.0 | 458.0 | 6.0 | 1.0 | 12.0 | |||
| 7 | 7 | 2020-02-07 | 82.0 | 911.0 | 31.0 | 62.0 | 453.0 | 77.0 | 911.0 | 0.084523 |
| 8 | 8 | 2020-02-08 | 89.0 | 970.0 | 7.0 | 2.0 | 59.0 | 70.0 | 666.0 | 0.105105 |
| 9 | 9 | 2020-02-09 | 94.0 | 991.0 | 5.0 | 1.0 | 21.0 | 69.0 | 651.0 | 0.105991 |
| 10 | 10 | 2020-02-10 | 100.0 | 1007.0 | 6.0 | 1.0 | 16.0 | 69.0 | 638.0 | 0.10815 |
| 11 | 11 | 2020-02-11 | 104.0 | 1047.0 | 4.0 | 0.0 | 40.0 | 68.0 | 646.0 | 0.105263 |
| 12 | 12 | 2020-02-12 | 107.0 | 1050.0 | 3.0 | 0.0 | 3.0 | 67.0 | 604.0 | 0.110927 |
| 13 | 13 | 2020-02-13 | 109.0 | 1060.0 | 2.0 | 0.0 | 10.0 | 66.0 | 602.0 | 0.109635 |
| 14 | 14 | 2020-02-14 | 118.0 | 1081.0 | 9.0 | 0.0 | 21.0 | 4.0 | 170.0 | 0.023529 |
| 15 | 15 | 2020-02-15 | 130.0 | 1124.0 | 12.0 | 1.0 | 43.0 | 3.0 | 154.0 | 0.019481 |
| 16 | 16 | 2020-02-16 | 137.0 | 1188.0 | 7.0 | 2.0 | 64.0 | 4.0 | 197.0 | 0.020305 |
| 17 | 17 | 2020-02-17 | 150.0 | 1273.0 | 13.0 | 0.0 | 85.0 | 3.0 | 266.0 | 0.011278 |
| 18 | 18 | 2020-02-18 | 160.0 | 1290.0 | 10.0 | 1.0 | 17.0 | 4.0 | 243.0 | 0.016461 |
| 19 | 19 | 2020-02-19 | 172.0 | 1300.0 | 12.0 | 0.0 | 10.0 | 4.0 | 250.0 | 0.016 |
| 20 | 20 | 2020-02-20 | 192.0 | 1326.0 | 20.0 | 2.0 | 26.0 | 6.0 | 266.0 | 0.022556 |
| 21 | 21 | 2020-02-21 | 212.0 | 1345.0 | 20.0 | 2.0 | 19.0 | 8.0 | 264.0 | 0.030303 |
| 22 | 22 | 2020-02-22 | 229.0 | 1372.0 | 17.0 | 0.0 | 27.0 | 7.0 | 248.0 | 0.028226 |
| 23 | 23 | 2020-02-23 | 248.0 | 1409.0 | 19.0 | 3.0 | 37.0 | 8.0 | 221.0 | 0.036199 |
| 24 | 24 | 2020-02-24 | 287.0 | 1429.0 | 39.0 | 3.0 | 20.0 | 11.0 | 156.0 | 0.070513 |
| 25 | 25 | 2020-02-25 | 312.0 | 1441.0 | 25.0 | 1.0 | 12.0 | 11.0 | 151.0 | 0.072848 |
| 26 | 26 | 2020-02-26 | 351.0 | 1465.0 | 39.0 | 3.0 | 24.0 | 14.0 | 165.0 | 0.084848 |
| 27 | 27 | 2020-02-27 | 377.0 | 1543.0 | 26.0 | 9.0 | 78.0 | 21.0 | 217.0 | 0.096774 |
| 28 | 28 | 2020-02-28 | 426.0 | 1664.0 | 49.0 | 17.0 | 121.0 | 36.0 | 319.0 | 0.112853 |
| 29 | 29 | 2020-02-29 | 467.0 | 1753.0 | 41.0 | 16.0 | 89.0 | 52.0 | 381.0 | 0.136483 |
| 30 | 30 | 2020-03-01 | 566.0 | 1832.0 | 99.0 | 4.0 | 79.0 | 53.0 | 423.0 | 0.125296 |
| 31 | 31 | 2020-03-02 | 642.0 | 2009.0 | 76.0 | 33.0 | 177.0 | 83.0 | 580.0 | 0.143103 |
| 32 | 32 | 2020-03-03 | 727.0 | 2154.0 | 85.0 | 25.0 | 145.0 | 107.0 | 713.0 | 0.15007 |
| 33 | 33 | 2020-03-04 | 822.0 | 2391.0 | 95.0 | 39.0 | 237.0 | 143.0 | 926.0 | 0.154428 |
| 34 | 34 | 2020-03-05 | 933.0 | 2758.0 | 111.0 | 36.0 | 367.0 | 170.0 | 1215.0 | 0.139918 |
| 35 | 35 | 2020-03-06 | 1092.0 | 3169.0 | 159.0 | 31.0 | 411.0 | 184.0 | 1505.0 | 0.122259 |
| 36 | 36 | 2020-03-07 | 1256.0 | 3675.0 | 164.0 | 76.0 | 506.0 | 244.0 | 1922.0 | 0.126951 |
| 37 | 37 | 2020-03-08 | 1437.0 | 3996.0 | 181.0 | 51.0 | 321.0 | 291.0 | 2164.0 | 0.134473 |
| 38 | 38 | 2020-03-09 | 1769.0 | 5025.0 | 332.0 | 130.0 | 1029.0 | 388.0 | 3016.0 | 0.128647 |
| 39 | 39 | 2020-03-10 | 2126.0 | 6211.0 | 357.0 | 124.0 | 1186.0 | 487.0 | 4057.0 | 0.120039 |
| 40 | 40 | 2020-03-11 | 2553.0 | 8070.0 | 427.0 | 170.0 | 1859.0 | 618.0 | 5679.0 | 0.108822 |
| 41 | 41 | 2020-03-12 | 3063.0 | 11529.0 | 510.0 | 238.0 | 3459.0 | 820.0 | 8771.0 | 0.09349 |
| 42 | 42 | 2020-03-13 | 3646.0 | 16004.0 | 583.0 | 332.0 | 4475.0 | 1121.0 | 12835.0 | 0.087339 |
| 43 | 43 | 2020-03-14 | 4160.0 | 18787.0 | 514.0 | 312.0 | 2783.0 | 1357.0 | 15112.0 | 0.089796 |
| 44 | 44 | 2020-03-15 | 4762.0 | 21554.0 | 602.0 | 255.0 | 2767.0 | 1561.0 | 17558.0 | 0.088905 |
| 45 | 45 | 2020-03-16 | 5643.0 | 29329.0 | 881.0 | 579.0 | 7775.0 | 2010.0 | 24304.0 | 0.082702 |
| 46 | 46 | 2020-03-17 | 6482.0 | 38271.0 | 839.0 | 653.0 | 8942.0 | 2539.0 | 32060.0 | 0.079195 |
| 47 | 47 | 2020-03-18 | 7261.0 | 47197.0 | 779.0 | 616.0 | 8926.0 | 2985.0 | 39127.0 | 0.07629 |
| 48 | 48 | 2020-03-19 | 8048.0 | 56223.0 | 787.0 | 663.0 | 9026.0 | 3410.0 | 44694.0 | 0.076297 |
| 49 | 49 | 2020-03-20 | 9013.0 | 66257.0 | 965.0 | 769.0 | 10034.0 | 3847.0 | 50253.0 | 0.076553 |
| 50 | 50 | 2020-03-21 | 9707.0 | 71341.0 | 694.0 | 478.0 | 5084.0 | 4013.0 | 52554.0 | 0.07636 |
| 51 | 51 | 2020-03-22 | 10474.0 | 75982.0 | 767.0 | 608.0 | 4641.0 | 4366.0 | 54428.0 | 0.080216 |
| 52 | 52 | 2020-03-23 | 11515.0 | 88563.0 | 1041.0 | 1212.0 | 12581.0 | 4999.0 | 59234.0 | 0.084394 |
| 53 | 53 | 2020-03-24 | 12365.0 | 100502.0 | 850.0 | 1206.0 | 11939.0 | 5552.0 | 62231.0 | 0.089216 |
| 54 | 54 | 2020-03-25 | 13410.0 | 112228.0 | 1045.0 | 1207.0 | 11726.0 | 6143.0 | 65031.0 | 0.094463 |
| 55 | 55 | 2020-03-26 | 14382.0 | 124016.0 | 972.0 | 1184.0 | 11788.0 | 6664.0 | 67793.0 | 0.098299 |
| 56 | 56 | 2020-03-27 | 15385.0 | 136591.0 | 1003.0 | 1317.0 | 12575.0 | 7212.0 | 70334.0 | 0.102539 |
| 57 | 57 | 2020-03-28 | 16322.0 | 144590.0 | 937.0 | 1037.0 | 7999.0 | 7771.0 | 73249.0 | 0.10609 |
| 58 | 58 | 2020-03-29 | 17145.0 | 149833.0 | 823.0 | 698.0 | 5243.0 | 7861.0 | 73851.0 | 0.106444 |
| 59 | 59 | 2020-03-30 | 18529.0 | 163798.0 | 1384.0 | 1610.0 | 13965.0 | 8259.0 | 75235.0 | 0.109776 |
| 60 | 60 | 2020-03-31 | 19789.0 | 177543.0 | 1260.0 | 1554.0 | 13745.0 | 8607.0 | 77041.0 | 0.11172 |
| 61 | 61 | 2020-04-01 | 21296.0 | 192518.0 | 1507.0 | 1762.0 | 14975.0 | 9162.0 | 80290.0 | 0.114111 |
| 62 | 62 | 2020-04-02 | 22664.0 | 207627.0 | 1368.0 | 1695.0 | 15109.0 | 9673.0 | 83611.0 | 0.115691 |
| 63 | 63 | 2020-04-03 | 24181.0 | 222940.0 | 1517.0 | 1536.0 | 15313.0 | 9892.0 | 86349.0 | 0.114558 |
| 64 | 64 | 2020-04-04 | 25307.0 | 230950.0 | 1126.0 | 1078.0 | 8010.0 | 9933.0 | 86360.0 | 0.115019 |
| 65 | 65 | 2020-04-05 | 26447.0 | 237027.0 | 1140.0 | 985.0 | 6077.0 | 10220.0 | 87194.0 | 0.11721 |
| 66 | 66 | 2020-04-06 | 27803.0 | 250717.0 | 1356.0 | 1543.0 | 13690.0 | 10153.0 | 86919.0 | 0.11681 |
| 67 | 67 | 2020-04-07 | 29222.0 | 265951.0 | 1419.0 | 1774.0 | 15234.0 | 10373.0 | 88408.0 | 0.117331 |
| 68 | 68 | 2020-04-08 | 30688.0 | 281934.0 | 1466.0 | 1774.0 | 15983.0 | 10385.0 | 89416.0 | 0.116143 |
| 69 | 69 | 2020-04-09 | 32085.0 | 299804.0 | 1397.0 | 1761.0 | 17870.0 | 10451.0 | 92177.0 | 0.11338 |
| 70 | 70 | 2020-04-10 | 33558.0 | 317952.0 | 1473.0 | 1699.0 | 18148.0 | 10614.0 | 95012.0 | 0.111712 |
| 71 | 71 | 2020-04-11 | 34609.0 | 327153.0 | 1051.0 | 1072.0 | 9201.0 | 10608.0 | 96203.0 | 0.110267 |
| 72 | 72 | 2020-04-12 | 35609.0 | 332902.0 | 1000.0 | 736.0 | 5749.0 | 10359.0 | 95875.0 | 0.108047 |
| 73 | 73 | 2020-04-13 | 37129.0 | 348220.0 | 1520.0 | 1914.0 | 15318.0 | 10730.0 | 97503.0 | 0.110048 |
| 74 | 74 | 2020-04-14 | 38625.0 | 364937.0 | 1496.0 | 1756.0 | 16717.0 | 10712.0 | 98986.0 | 0.108217 |
| 75 | 75 | 2020-04-15 | 40287.0 | 384838.0 | 1662.0 | 1982.0 | 19901.0 | 10920.0 | 102904.0 | 0.106118 |
| 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 |
| 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 |
| 80 | 80 | 2020-04-20 | 47776.0 | 469049.0 | 1920.0 | 2179.0 | 22152.0 | 11710.0 | 120829.0 | 0.096914 |
| 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 |
| 83 | 83 | 2020-04-23 | 53054.0 | 543894.0 | 1842.0 | 2142.0 | 25490.0 | 12291.0 | 139379.0 | 0.088184 |
| 84 | 84 | 2020-04-24 | 55064.0 | 573572.0 | 2010.0 | 2328.0 | 29678.0 | 12878.0 | 148324.0 | 0.086823 |
| 85 | 85 | 2020-04-25 | 56682.0 | 593520.0 | 1618.0 | 1711.0 | 19948.0 | 13316.0 | 155288.0 | 0.08575 |
| 86 | 86 | 2020-04-26 | 57952.0 | 605026.0 | 1270.0 | 1014.0 | 11506.0 | 13429.0 | 158129.0 | 0.084924 |
| 87 | 87 | 2020-04-27 | 60202.0 | 639846.0 | 2250.0 | 2746.0 | 34820.0 | 13996.0 | 170797.0 | 0.081945 |
| 88 | 88 | 2020-04-28 | 62305.0 | 675457.0 | 2103.0 | 2555.0 | 35611.0 | 14522.0 | 181152.0 | 0.080165 |
| 89 | 89 | 2020-04-29 | 64341.0 | 711372.0 | 2036.0 | 2406.0 | 35915.0 | 14902.0 | 192968.0 | 0.077225 |
| 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 |
| 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 |
| 94 | 94 | 2020-05-04 | 73450.0 | 884934.0 | 2400.0 | 2708.0 | 45283.0 | 14819.0 | 245088.0 | 0.060464 |
| 95 | 95 | 2020-05-05 | 76031.0 | 933158.0 | 2581.0 | 2971.0 | 48224.0 | 15235.0 | 257701.0 | 0.059119 |
| 96 | 96 | 2020-05-06 | 78376.0 | 989516.0 | 2345.0 | 2904.0 | 56358.0 | 15733.0 | 278144.0 | 0.056564 |
| 97 | 97 | 2020-05-07 | 80521.0 | 1043018.0 | 2145.0 | 2558.0 | 53502.0 | 15932.0 | 290664.0 | 0.054812 |
| 98 | 98 | 2020-05-08 | 82791.0 | 1096280.0 | 2270.0 | 2583.0 | 53262.0 | 16154.0 | 298861.0 | 0.054052 |
| 99 | 99 | 2020-05-09 | 84375.0 | 1123746.0 | 1584.0 | 1578.0 | 27466.0 | 16352.0 | 299683.0 | 0.054564 |
| 100 | 100 | 2020-05-10 | 85702.0 | 1138617.0 | 1327.0 | 924.0 | 14871.0 | 16226.0 | 298966.0 | 0.054274 |
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 );