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
962 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 | 41.0 | 401.0 | 1.0 | 1.0 | 32.0 | |||
| 5 | 5 | 2020-02-05 | 44.0 | 446.0 | 3.0 | 1.0 | 45.0 | |||
| 6 | 6 | 2020-02-06 | 50.0 | 458.0 | 6.0 | 1.0 | 12.0 | |||
| 7 | 7 | 2020-02-07 | 82.0 | 911.0 | 32.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 | 132.0 | 1124.0 | 14.0 | 1.0 | 43.0 | 3.0 | 154.0 | 0.019481 |
| 16 | 16 | 2020-02-16 | 139.0 | 1188.0 | 7.0 | 2.0 | 64.0 | 4.0 | 197.0 | 0.020305 |
| 17 | 17 | 2020-02-17 | 152.0 | 1273.0 | 13.0 | 0.0 | 85.0 | 3.0 | 266.0 | 0.011278 |
| 18 | 18 | 2020-02-18 | 162.0 | 1290.0 | 10.0 | 1.0 | 17.0 | 4.0 | 243.0 | 0.016461 |
| 19 | 19 | 2020-02-19 | 174.0 | 1300.0 | 12.0 | 0.0 | 10.0 | 4.0 | 250.0 | 0.016 |
| 20 | 20 | 2020-02-20 | 195.0 | 1326.0 | 21.0 | 2.0 | 26.0 | 6.0 | 266.0 | 0.022556 |
| 21 | 21 | 2020-02-21 | 215.0 | 1345.0 | 20.0 | 2.0 | 19.0 | 8.0 | 264.0 | 0.030303 |
| 22 | 22 | 2020-02-22 | 232.0 | 1372.0 | 17.0 | 0.0 | 27.0 | 7.0 | 248.0 | 0.028226 |
| 23 | 23 | 2020-02-23 | 251.0 | 1409.0 | 19.0 | 3.0 | 37.0 | 8.0 | 221.0 | 0.036199 |
| 24 | 24 | 2020-02-24 | 290.0 | 1429.0 | 39.0 | 3.0 | 20.0 | 11.0 | 156.0 | 0.070513 |
| 25 | 25 | 2020-02-25 | 315.0 | 1441.0 | 25.0 | 1.0 | 12.0 | 11.0 | 151.0 | 0.072848 |
| 26 | 26 | 2020-02-26 | 354.0 | 1465.0 | 39.0 | 3.0 | 24.0 | 14.0 | 165.0 | 0.084848 |
| 27 | 27 | 2020-02-27 | 380.0 | 1543.0 | 26.0 | 9.0 | 78.0 | 21.0 | 217.0 | 0.096774 |
| 28 | 28 | 2020-02-28 | 429.0 | 1664.0 | 49.0 | 17.0 | 121.0 | 36.0 | 319.0 | 0.112853 |
| 29 | 29 | 2020-02-29 | 470.0 | 1753.0 | 41.0 | 16.0 | 89.0 | 52.0 | 381.0 | 0.136483 |
| 30 | 30 | 2020-03-01 | 570.0 | 1832.0 | 100.0 | 4.0 | 79.0 | 53.0 | 423.0 | 0.125296 |
| 31 | 31 | 2020-03-02 | 646.0 | 2009.0 | 76.0 | 33.0 | 177.0 | 83.0 | 580.0 | 0.143103 |
| 32 | 32 | 2020-03-03 | 731.0 | 2151.0 | 85.0 | 25.0 | 142.0 | 107.0 | 710.0 | 0.150704 |
| 33 | 33 | 2020-03-04 | 826.0 | 2388.0 | 95.0 | 39.0 | 237.0 | 143.0 | 923.0 | 0.15493 |
| 34 | 34 | 2020-03-05 | 937.0 | 2755.0 | 111.0 | 36.0 | 367.0 | 170.0 | 1212.0 | 0.140264 |
| 35 | 35 | 2020-03-06 | 1096.0 | 3166.0 | 159.0 | 31.0 | 411.0 | 184.0 | 1502.0 | 0.122503 |
| 36 | 36 | 2020-03-07 | 1260.0 | 3672.0 | 164.0 | 76.0 | 506.0 | 244.0 | 1919.0 | 0.12715 |
| 37 | 37 | 2020-03-08 | 1441.0 | 3993.0 | 181.0 | 51.0 | 321.0 | 291.0 | 2161.0 | 0.13466 |
| 38 | 38 | 2020-03-09 | 1773.0 | 5020.0 | 332.0 | 130.0 | 1027.0 | 388.0 | 3011.0 | 0.128861 |
| 39 | 39 | 2020-03-10 | 2131.0 | 6206.0 | 358.0 | 124.0 | 1186.0 | 487.0 | 4055.0 | 0.120099 |
| 40 | 40 | 2020-03-11 | 2558.0 | 8065.0 | 427.0 | 170.0 | 1859.0 | 618.0 | 5677.0 | 0.10886 |
| 41 | 41 | 2020-03-12 | 3068.0 | 11522.0 | 510.0 | 238.0 | 3457.0 | 820.0 | 8767.0 | 0.093533 |
| 42 | 42 | 2020-03-13 | 3650.0 | 15988.0 | 582.0 | 332.0 | 4466.0 | 1121.0 | 12822.0 | 0.087428 |
| 43 | 43 | 2020-03-14 | 4163.0 | 18770.0 | 513.0 | 312.0 | 2782.0 | 1357.0 | 15098.0 | 0.089879 |
| 44 | 44 | 2020-03-15 | 4765.0 | 21535.0 | 602.0 | 255.0 | 2765.0 | 1561.0 | 17542.0 | 0.088986 |
| 45 | 45 | 2020-03-16 | 5648.0 | 29296.0 | 883.0 | 579.0 | 7761.0 | 2010.0 | 24276.0 | 0.082798 |
| 46 | 46 | 2020-03-17 | 6485.0 | 38239.0 | 837.0 | 654.0 | 8943.0 | 2540.0 | 32033.0 | 0.079293 |
| 47 | 47 | 2020-03-18 | 7264.0 | 47164.0 | 779.0 | 616.0 | 8925.0 | 2986.0 | 39099.0 | 0.07637 |
| 48 | 48 | 2020-03-19 | 8052.0 | 56189.0 | 788.0 | 663.0 | 9025.0 | 3411.0 | 44667.0 | 0.076365 |
| 49 | 49 | 2020-03-20 | 9017.0 | 66223.0 | 965.0 | 769.0 | 10034.0 | 3848.0 | 50235.0 | 0.0766 |
| 50 | 50 | 2020-03-21 | 9709.0 | 71306.0 | 692.0 | 478.0 | 5083.0 | 4014.0 | 52536.0 | 0.076405 |
| 51 | 51 | 2020-03-22 | 10472.0 | 75947.0 | 763.0 | 608.0 | 4641.0 | 4367.0 | 54412.0 | 0.080258 |
| 52 | 52 | 2020-03-23 | 11513.0 | 88526.0 | 1041.0 | 1212.0 | 12579.0 | 5000.0 | 59230.0 | 0.084417 |
| 53 | 53 | 2020-03-24 | 12361.0 | 100462.0 | 848.0 | 1205.0 | 11936.0 | 5551.0 | 62223.0 | 0.089211 |
| 54 | 54 | 2020-03-25 | 13406.0 | 112187.0 | 1045.0 | 1207.0 | 11725.0 | 6142.0 | 65023.0 | 0.094459 |
| 55 | 55 | 2020-03-26 | 14378.0 | 123966.0 | 972.0 | 1184.0 | 11779.0 | 6663.0 | 67777.0 | 0.098308 |
| 56 | 56 | 2020-03-27 | 15381.0 | 136536.0 | 1003.0 | 1317.0 | 12570.0 | 7211.0 | 70313.0 | 0.102556 |
| 57 | 57 | 2020-03-28 | 16315.0 | 144533.0 | 934.0 | 1037.0 | 7997.0 | 7770.0 | 73227.0 | 0.106108 |
| 58 | 58 | 2020-03-29 | 17140.0 | 149774.0 | 825.0 | 698.0 | 5241.0 | 7860.0 | 73827.0 | 0.106465 |
| 59 | 59 | 2020-03-30 | 18520.0 | 163731.0 | 1380.0 | 1610.0 | 13957.0 | 8258.0 | 75205.0 | 0.109807 |
| 60 | 60 | 2020-03-31 | 19780.0 | 177474.0 | 1260.0 | 1554.0 | 13743.0 | 8607.0 | 77012.0 | 0.111762 |
| 61 | 61 | 2020-04-01 | 21283.0 | 192445.0 | 1503.0 | 1761.0 | 14971.0 | 9161.0 | 80258.0 | 0.114144 |
| 62 | 62 | 2020-04-02 | 22654.0 | 207549.0 | 1371.0 | 1695.0 | 15104.0 | 9672.0 | 83583.0 | 0.115717 |
| 63 | 63 | 2020-04-03 | 24173.0 | 222853.0 | 1519.0 | 1536.0 | 15304.0 | 9891.0 | 86317.0 | 0.114589 |
| 64 | 64 | 2020-04-04 | 25298.0 | 230861.0 | 1125.0 | 1078.0 | 8008.0 | 9932.0 | 86328.0 | 0.11505 |
| 65 | 65 | 2020-04-05 | 26438.0 | 236934.0 | 1140.0 | 985.0 | 6073.0 | 10219.0 | 87160.0 | 0.117244 |
| 66 | 66 | 2020-04-06 | 27800.0 | 250618.0 | 1362.0 | 1543.0 | 13684.0 | 10152.0 | 86887.0 | 0.116841 |
| 67 | 67 | 2020-04-07 | 29223.0 | 265848.0 | 1423.0 | 1774.0 | 15230.0 | 10372.0 | 88374.0 | 0.117365 |
| 68 | 68 | 2020-04-08 | 30694.0 | 281824.0 | 1471.0 | 1774.0 | 15976.0 | 10385.0 | 89379.0 | 0.116191 |
| 69 | 69 | 2020-04-09 | 32098.0 | 299693.0 | 1404.0 | 1761.0 | 17869.0 | 10451.0 | 92144.0 | 0.11342 |
| 70 | 70 | 2020-04-10 | 33571.0 | 317839.0 | 1473.0 | 1699.0 | 18146.0 | 10614.0 | 94986.0 | 0.111743 |
| 71 | 71 | 2020-04-11 | 34621.0 | 327041.0 | 1050.0 | 1072.0 | 9202.0 | 10608.0 | 96180.0 | 0.110293 |
| 72 | 72 | 2020-04-12 | 35620.0 | 332786.0 | 999.0 | 736.0 | 5745.0 | 10359.0 | 95852.0 | 0.108073 |
| 73 | 73 | 2020-04-13 | 37142.0 | 348102.0 | 1522.0 | 1914.0 | 15316.0 | 10730.0 | 97484.0 | 0.110069 |
| 74 | 74 | 2020-04-14 | 38638.0 | 364819.0 | 1496.0 | 1756.0 | 16717.0 | 10712.0 | 98971.0 | 0.108234 |
| 75 | 75 | 2020-04-15 | 40303.0 | 384719.0 | 1665.0 | 1982.0 | 19900.0 | 10920.0 | 102895.0 | 0.106128 |
| 76 | 76 | 2020-04-16 | 41979.0 | 404396.0 | 1676.0 | 1878.0 | 19677.0 | 11037.0 | 104703.0 | 0.105412 |
| 77 | 77 | 2020-04-17 | 43587.0 | 425126.0 | 1608.0 | 1741.0 | 20730.0 | 11079.0 | 107287.0 | 0.103265 |
| 78 | 78 | 2020-04-18 | 44794.0 | 438110.0 | 1207.0 | 1273.0 | 12984.0 | 11280.0 | 111069.0 | 0.101558 |
| 79 | 79 | 2020-04-19 | 45875.0 | 446774.0 | 1081.0 | 901.0 | 8664.0 | 11445.0 | 113988.0 | 0.100405 |
| 80 | 80 | 2020-04-20 | 47792.0 | 468924.0 | 1917.0 | 2179.0 | 22150.0 | 11710.0 | 120822.0 | 0.096919 |
| 81 | 81 | 2020-04-21 | 49468.0 | 494178.0 | 1676.0 | 2029.0 | 25254.0 | 11983.0 | 129359.0 | 0.092634 |
| 82 | 82 | 2020-04-22 | 51231.0 | 518276.0 | 1763.0 | 2026.0 | 24098.0 | 12027.0 | 133557.0 | 0.090051 |
| 83 | 83 | 2020-04-23 | 53071.0 | 543761.0 | 1840.0 | 2142.0 | 25485.0 | 12291.0 | 139365.0 | 0.088193 |
| 84 | 84 | 2020-04-24 | 55080.0 | 573437.0 | 2009.0 | 2328.0 | 29676.0 | 12878.0 | 148311.0 | 0.086831 |
| 85 | 85 | 2020-04-25 | 56697.0 | 593385.0 | 1617.0 | 1711.0 | 19948.0 | 13316.0 | 155275.0 | 0.085758 |
| 86 | 86 | 2020-04-26 | 57964.0 | 604889.0 | 1267.0 | 1014.0 | 11504.0 | 13429.0 | 158115.0 | 0.084932 |
| 87 | 87 | 2020-04-27 | 60217.0 | 639707.0 | 2253.0 | 2747.0 | 34818.0 | 13997.0 | 170783.0 | 0.081958 |
| 88 | 88 | 2020-04-28 | 62319.0 | 675315.0 | 2102.0 | 2554.0 | 35608.0 | 14522.0 | 181137.0 | 0.080171 |
| 89 | 89 | 2020-04-29 | 64353.0 | 711225.0 | 2034.0 | 2406.0 | 35910.0 | 14902.0 | 192949.0 | 0.077233 |
| 90 | 90 | 2020-04-30 | 66291.0 | 752189.0 | 1938.0 | 2359.0 | 40964.0 | 15119.0 | 208428.0 | 0.072538 |
| 91 | 91 | 2020-05-01 | 68524.0 | 797244.0 | 2233.0 | 2361.0 | 45055.0 | 15152.0 | 223807.0 | 0.067701 |
| 92 | 92 | 2020-05-02 | 69912.0 | 823886.0 | 1388.0 | 1380.0 | 26642.0 | 14821.0 | 230501.0 | 0.064299 |
| 93 | 93 | 2020-05-03 | 71061.0 | 839468.0 | 1149.0 | 1050.0 | 15582.0 | 14857.0 | 234579.0 | 0.063335 |
| 94 | 94 | 2020-05-04 | 73488.0 | 884743.0 | 2427.0 | 2708.0 | 45275.0 | 14818.0 | 245036.0 | 0.060473 |
| 95 | 95 | 2020-05-05 | 76083.0 | 932964.0 | 2595.0 | 2971.0 | 48221.0 | 15235.0 | 257649.0 | 0.059131 |
| 96 | 96 | 2020-05-06 | 78431.0 | 989322.0 | 2348.0 | 2904.0 | 56358.0 | 15733.0 | 278097.0 | 0.056574 |
| 97 | 97 | 2020-05-07 | 80577.0 | 1042822.0 | 2146.0 | 2558.0 | 53500.0 | 15932.0 | 290633.0 | 0.054818 |
| 98 | 98 | 2020-05-08 | 82843.0 | 1096080.0 | 2266.0 | 2583.0 | 53258.0 | 16154.0 | 298836.0 | 0.054056 |
| 99 | 99 | 2020-05-09 | 84424.0 | 1123546.0 | 1581.0 | 1578.0 | 27466.0 | 16352.0 | 299660.0 | 0.054569 |
| 100 | 100 | 2020-05-10 | 85750.0 | 1138415.0 | 1326.0 | 923.0 | 14869.0 | 16225.0 | 298947.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 );