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)
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 |
---|---|---|---|---|---|---|---|---|---|---|
15 | 15 | 2020-02-15 | 130.0 | 1124.0 | 12.0 | 1.0 | 43.0 | 3.0 | 154.0 | 0.019481 |
17 | 17 | 2020-02-17 | 150.0 | 1273.0 | 13.0 | 0.0 | 85.0 | 3.0 | 266.0 | 0.011278 |
14 | 14 | 2020-02-14 | 118.0 | 1081.0 | 9.0 | 0.0 | 21.0 | 4.0 | 170.0 | 0.023529 |
16 | 16 | 2020-02-16 | 137.0 | 1188.0 | 7.0 | 2.0 | 64.0 | 4.0 | 197.0 | 0.020305 |
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 |
22 | 22 | 2020-02-22 | 229.0 | 1372.0 | 17.0 | 0.0 | 27.0 | 7.0 | 248.0 | 0.028226 |
21 | 21 | 2020-02-21 | 212.0 | 1345.0 | 20.0 | 2.0 | 19.0 | 8.0 | 264.0 | 0.030303 |
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 |
13 | 13 | 2020-02-13 | 109.0 | 1060.0 | 2.0 | 0.0 | 10.0 | 66.0 | 602.0 | 0.109635 |
12 | 12 | 2020-02-12 | 107.0 | 1050.0 | 3.0 | 0.0 | 3.0 | 67.0 | 604.0 | 0.110927 |
11 | 11 | 2020-02-11 | 104.0 | 1047.0 | 4.0 | 0.0 | 40.0 | 68.0 | 646.0 | 0.105263 |
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 |
8 | 8 | 2020-02-08 | 89.0 | 970.0 | 7.0 | 2.0 | 59.0 | 70.0 | 666.0 | 0.105105 |
7 | 7 | 2020-02-07 | 82.0 | 911.0 | 31.0 | 62.0 | 453.0 | 77.0 | 911.0 | 0.084523 |
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 |
486 | 486 | 2021-05-31 | 3702799.0 | 66435802.0 | 595.0 | 527.0 | 60572.0 | 7513.0 | 939723.0 | 0.007995 |
489 | 489 | 2021-06-03 | 3706049.0 | 67125663.0 | 996.0 | 1298.0 | 189353.0 | 7603.0 | 1015642.0 | 0.007486 |
488 | 488 | 2021-06-02 | 3705053.0 | 66936310.0 | 1044.0 | 1428.0 | 219158.0 | 7639.0 | 1006757.0 | 0.007588 |
490 | 490 | 2021-06-04 | 3706901.0 | 67302315.0 | 852.0 | 1309.0 | 176652.0 | 7661.0 | 1038386.0 | 0.007378 |
487 | 487 | 2021-06-01 | 3704009.0 | 66717152.0 | 1210.0 | 1704.0 | 281350.0 | 7668.0 | 991066.0 | 0.007737 |
491 | 491 | 2021-06-05 | 3707544.0 | 67376942.0 | 643.0 | 848.0 | 74627.0 | 7764.0 | 1053747.0 | 0.007368 |
57 | 57 | 2020-03-28 | 16322.0 | 144590.0 | 937.0 | 1037.0 | 7999.0 | 7771.0 | 73249.0 | 0.10609 |
492 | 492 | 2021-06-06 | 3708154.0 | 67435427.0 | 610.0 | 662.0 | 58485.0 | 7776.0 | 1060197.0 | 0.007334 |
501 | 501 | 2021-06-15 | 3716485.0 | 68728060.0 | 1048.0 | 1278.0 | 150001.0 | 7829.0 | 894715.0 | 0.00875 |
58 | 58 | 2020-03-29 | 17145.0 | 149833.0 | 823.0 | 698.0 | 5243.0 | 7861.0 | 73851.0 | 0.106444 |
500 | 500 | 2021-06-14 | 3715437.0 | 68578059.0 | 1156.0 | 1485.0 | 167725.0 | 7903.0 | 930155.0 | 0.008496 |
499 | 499 | 2021-06-13 | 3714281.0 | 68410334.0 | 701.0 | 639.0 | 54343.0 | 7917.0 | 974907.0 | 0.008121 |
498 | 498 | 2021-06-12 | 3713580.0 | 68355991.0 | 677.0 | 765.0 | 64388.0 | 7940.0 | 979049.0 | 0.00811 |
502 | 502 | 2021-06-16 | 3717548.0 | 68865757.0 | 1063.0 | 1391.0 | 137697.0 | 7955.0 | 875158.0 | 0.00909 |
497 | 497 | 2021-06-11 | 3712903.0 | 68291603.0 | 852.0 | 1206.0 | 141622.0 | 8023.0 | 989288.0 | 0.00811 |
496 | 496 | 2021-06-10 | 3712051.0 | 68149981.0 | 876.0 | 1191.0 | 159382.0 | 8126.0 | 1024318.0 | 0.007933 |
503 | 503 | 2021-06-17 | 3718574.0 | 68990683.0 | 1026.0 | 1375.0 | 124926.0 | 8139.0 | 840702.0 | 0.009681 |
504 | 504 | 2021-06-18 | 3719504.0 | 69111768.0 | 930.0 | 1283.0 | 121085.0 | 8216.0 | 820165.0 | 0.010017 |
495 | 495 | 2021-06-09 | 3711175.0 | 67990599.0 | 927.0 | 1265.0 | 157254.0 | 8233.0 | 1054289.0 | 0.007809 |
59 | 59 | 2020-03-30 | 18529.0 | 163798.0 | 1384.0 | 1610.0 | 13965.0 | 8259.0 | 75235.0 | 0.109776 |
505 | 505 | 2021-06-19 | 3720258.0 | 69174093.0 | 754.0 | 928.0 | 62325.0 | 8379.0 | 818102.0 | 0.010242 |
494 | 494 | 2021-06-08 | 3710248.0 | 67833345.0 | 1051.0 | 1352.0 | 185441.0 | 8396.0 | 1116193.0 | 0.007522 |
506 | 506 | 2021-06-20 | 3721058.0 | 69223169.0 | 800.0 | 664.0 | 49076.0 | 8404.0 | 812835.0 | 0.010339 |
507 | 507 | 2021-06-21 | 3722459.0 | 69386290.0 | 1401.0 | 1621.0 | 163121.0 | 8540.0 | 808231.0 | 0.010566 |
60 | 60 | 2020-03-31 | 19789.0 | 177543.0 | 1260.0 | 1554.0 | 13745.0 | 8607.0 | 77041.0 | 0.11172 |
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 |
493 | 493 | 2021-06-07 | 3709197.0 | 67647904.0 | 1043.0 | 1499.0 | 212477.0 | 8748.0 | 1212102.0 | 0.007217 |
483 | 483 | 2021-05-28 | 3701016.0 | 66263929.0 | 862.0 | 1251.0 | 153908.0 | 8895.0 | 1143376.0 | 0.00778 |
508 | 508 | 2021-06-22 | 3723768.0 | 69535402.0 | 1309.0 | 1661.0 | 149112.0 | 8923.0 | 807342.0 | 0.011052 |
482 | 482 | 2021-05-27 | 3700154.0 | 66110021.0 | 922.0 | 1334.0 | 180468.0 | 9104.0 | 1163316.0 | 0.007826 |
509 | 509 | 2021-06-23 | 3725000.0 | 69674979.0 | 1232.0 | 1627.0 | 139577.0 | 9159.0 | 809222.0 | 0.011318 |
61 | 61 | 2020-04-01 | 21296.0 | 192518.0 | 1507.0 | 1762.0 | 14975.0 | 9162.0 | 80290.0 | 0.114111 |
481 | 481 | 2021-05-26 | 3699232.0 | 65929553.0 | 982.0 | 1457.0 | 203467.0 | 9354.0 | 1183834.0 | 0.007901 |
480 | 480 | 2021-05-25 | 3698250.0 | 65726086.0 | 1042.0 | 1549.0 | 230007.0 | 9593.0 | 1206958.0 | 0.007948 |
510 | 510 | 2021-06-24 | 3726397.0 | 69800153.0 | 1397.0 | 1816.0 | 125174.0 | 9600.0 | 809470.0 | 0.01186 |
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 |
479 | 479 | 2021-05-24 | 3697208.0 | 65496079.0 | 1206.0 | 1670.0 | 254896.0 | 9897.0 | 1218207.0 | 0.008124 |
64 | 64 | 2020-04-04 | 25307.0 | 230950.0 | 1126.0 | 1078.0 | 8010.0 | 9933.0 | 86360.0 | 0.115019 |
511 | 511 | 2021-06-25 | 3727704.0 | 69920796.0 | 1307.0 | 1617.0 | 120643.0 | 9934.0 | 809028.0 | 0.012279 |
512 | 512 | 2021-06-26 | 3728779.0 | 69983276.0 | 1075.0 | 1137.0 | 62480.0 | 10143.0 | 809183.0 | 0.012535 |
66 | 66 | 2020-04-06 | 27803.0 | 250717.0 | 1356.0 | 1543.0 | 13690.0 | 10153.0 | 86919.0 | 0.11681 |
478 | 478 | 2021-05-23 | 3696002.0 | 65241183.0 | 662.0 | 728.0 | 55655.0 | 10184.0 | 1239282.0 | 0.008218 |
65 | 65 | 2020-04-05 | 26447.0 | 237027.0 | 1140.0 | 985.0 | 6077.0 | 10220.0 | 87194.0 | 0.11721 |
72 | 72 | 2020-04-12 | 35609.0 | 332902.0 | 1000.0 | 736.0 | 5749.0 | 10359.0 | 95875.0 | 0.108047 |
477 | 477 | 2021-05-22 | 3695340.0 | 65185528.0 | 710.0 | 906.0 | 64975.0 | 10359.0 | 1241229.0 | 0.008346 |
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 |
513 | 513 | 2021-06-27 | 3729950.0 | 70034893.0 | 1171.0 | 953.0 | 51617.0 | 10432.0 | 811724.0 | 0.012852 |
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 );