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
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 |
---|---|---|---|---|---|---|---|---|---|---|
4 | 4 | 2020-02-04 | 42.0 | 401.0 | 2.0 | 1.0 | 32.0 | |||
13 | 13 | 2020-02-13 | 109.0 | 1060.0 | 2.0 | 0.0 | 10.0 | 66.0 | 602.0 | 0.109635 |
5 | 5 | 2020-02-05 | 45.0 | 446.0 | 3.0 | 1.0 | 45.0 | |||
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 |
6 | 6 | 2020-02-06 | 51.0 | 458.0 | 6.0 | 1.0 | 12.0 | |||
10 | 10 | 2020-02-10 | 100.0 | 1007.0 | 6.0 | 1.0 | 16.0 | 69.0 | 638.0 | 0.10815 |
3 | 3 | 2020-02-03 | 40.0 | 369.0 | 7.0 | 1.0 | 29.0 | |||
8 | 8 | 2020-02-08 | 89.0 | 970.0 | 7.0 | 2.0 | 59.0 | 70.0 | 666.0 | 0.105105 |
16 | 16 | 2020-02-16 | 137.0 | 1188.0 | 7.0 | 2.0 | 64.0 | 4.0 | 197.0 | 0.020305 |
2 | 2 | 2020-02-02 | 33.0 | 340.0 | 9.0 | 2.0 | 36.0 | |||
14 | 14 | 2020-02-14 | 118.0 | 1081.0 | 9.0 | 0.0 | 21.0 | 4.0 | 170.0 | 0.023529 |
18 | 18 | 2020-02-18 | 160.0 | 1290.0 | 10.0 | 1.0 | 17.0 | 4.0 | 243.0 | 0.016461 |
15 | 15 | 2020-02-15 | 130.0 | 1124.0 | 12.0 | 1.0 | 43.0 | 3.0 | 154.0 | 0.019481 |
19 | 19 | 2020-02-19 | 172.0 | 1300.0 | 12.0 | 0.0 | 10.0 | 4.0 | 250.0 | 0.016 |
17 | 17 | 2020-02-17 | 150.0 | 1273.0 | 13.0 | 0.0 | 85.0 | 3.0 | 266.0 | 0.011278 |
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 |
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 |
1 | 1 | 2020-02-01 | 24.0 | 304.0 | 24.0 | 9.0 | 304.0 | |||
25 | 25 | 2020-02-25 | 312.0 | 1441.0 | 25.0 | 1.0 | 12.0 | 11.0 | 151.0 | 0.072848 |
27 | 27 | 2020-02-27 | 377.0 | 1543.0 | 26.0 | 9.0 | 78.0 | 21.0 | 217.0 | 0.096774 |
7 | 7 | 2020-02-07 | 82.0 | 911.0 | 31.0 | 62.0 | 453.0 | 77.0 | 911.0 | 0.084523 |
24 | 24 | 2020-02-24 | 287.0 | 1429.0 | 39.0 | 3.0 | 20.0 | 11.0 | 156.0 | 0.070513 |
26 | 26 | 2020-02-26 | 351.0 | 1465.0 | 39.0 | 3.0 | 24.0 | 14.0 | 165.0 | 0.084848 |
29 | 29 | 2020-02-29 | 467.0 | 1753.0 | 41.0 | 16.0 | 89.0 | 52.0 | 381.0 | 0.136483 |
28 | 28 | 2020-02-28 | 426.0 | 1664.0 | 49.0 | 17.0 | 121.0 | 36.0 | 319.0 | 0.112853 |
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 |
30 | 30 | 2020-03-01 | 566.0 | 1832.0 | 99.0 | 4.0 | 79.0 | 53.0 | 423.0 | 0.125296 |
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 |
43 | 43 | 2020-03-14 | 4160.0 | 18787.0 | 514.0 | 312.0 | 2783.0 | 1357.0 | 15112.0 | 0.089796 |
42 | 42 | 2020-03-13 | 3646.0 | 16004.0 | 583.0 | 332.0 | 4475.0 | 1121.0 | 12835.0 | 0.087339 |
485 | 485 | 2021-05-30 | 3702204.0 | 66375230.0 | 585.0 | 650.0 | 52035.0 | 8656.0 | 1134047.0 | 0.007633 |
486 | 486 | 2021-05-31 | 3702799.0 | 66435802.0 | 595.0 | 527.0 | 60572.0 | 7513.0 | 939723.0 | 0.007995 |
44 | 44 | 2020-03-15 | 4762.0 | 21554.0 | 602.0 | 255.0 | 2767.0 | 1561.0 | 17558.0 | 0.088905 |
484 | 484 | 2021-05-29 | 3701619.0 | 66323195.0 | 603.0 | 745.0 | 59266.0 | 8734.0 | 1137667.0 | 0.007677 |
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 |
478 | 478 | 2021-05-23 | 3696002.0 | 65241183.0 | 662.0 | 728.0 | 55655.0 | 10184.0 | 1239282.0 | 0.008218 |
498 | 498 | 2021-06-12 | 3713580.0 | 68355991.0 | 677.0 | 765.0 | 64388.0 | 7940.0 | 979049.0 | 0.00811 |
50 | 50 | 2020-03-21 | 9707.0 | 71341.0 | 694.0 | 478.0 | 5084.0 | 4013.0 | 52554.0 | 0.07636 |
499 | 499 | 2021-06-13 | 3714281.0 | 68410334.0 | 701.0 | 639.0 | 54343.0 | 7917.0 | 974907.0 | 0.008121 |
477 | 477 | 2021-05-22 | 3695340.0 | 65185528.0 | 710.0 | 906.0 | 64975.0 | 10359.0 | 1241229.0 | 0.008346 |
505 | 505 | 2021-06-19 | 3720258.0 | 69174093.0 | 754.0 | 928.0 | 62325.0 | 8379.0 | 818102.0 | 0.010242 |
51 | 51 | 2020-03-22 | 10474.0 | 75982.0 | 767.0 | 608.0 | 4641.0 | 4366.0 | 54428.0 | 0.080216 |
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 |
506 | 506 | 2021-06-20 | 3721058.0 | 69223169.0 | 800.0 | 664.0 | 49076.0 | 8404.0 | 812835.0 | 0.010339 |
471 | 471 | 2021-05-16 | 3688922.0 | 64001901.0 | 813.0 | 903.0 | 57602.0 | 12241.0 | 1289580.0 | 0.009492 |
58 | 58 | 2020-03-29 | 17145.0 | 149833.0 | 823.0 | 698.0 | 5243.0 | 7861.0 | 73851.0 | 0.106444 |
46 | 46 | 2020-03-17 | 6482.0 | 38271.0 | 839.0 | 653.0 | 8942.0 | 2539.0 | 32060.0 | 0.079195 |
53 | 53 | 2020-03-24 | 12365.0 | 100502.0 | 850.0 | 1206.0 | 11939.0 | 5552.0 | 62231.0 | 0.089216 |
490 | 490 | 2021-06-04 | 3706901.0 | 67302315.0 | 852.0 | 1309.0 | 176652.0 | 7661.0 | 1038386.0 | 0.007378 |
497 | 497 | 2021-06-11 | 3712903.0 | 68291603.0 | 852.0 | 1206.0 | 141622.0 | 8023.0 | 989288.0 | 0.00811 |
483 | 483 | 2021-05-28 | 3701016.0 | 66263929.0 | 862.0 | 1251.0 | 153908.0 | 8895.0 | 1143376.0 | 0.00778 |
496 | 496 | 2021-06-10 | 3712051.0 | 68149981.0 | 876.0 | 1191.0 | 159382.0 | 8126.0 | 1024318.0 | 0.007933 |
45 | 45 | 2020-03-16 | 5643.0 | 29329.0 | 881.0 | 579.0 | 7775.0 | 2010.0 | 24304.0 | 0.082702 |
470 | 470 | 2021-05-15 | 3688109.0 | 63944299.0 | 900.0 | 1150.0 | 68657.0 | 12246.0 | 1286372.0 | 0.00952 |
482 | 482 | 2021-05-27 | 3700154.0 | 66110021.0 | 922.0 | 1334.0 | 180468.0 | 9104.0 | 1163316.0 | 0.007826 |
495 | 495 | 2021-06-09 | 3711175.0 | 67990599.0 | 927.0 | 1265.0 | 157254.0 | 8233.0 | 1054289.0 | 0.007809 |
504 | 504 | 2021-06-18 | 3719504.0 | 69111768.0 | 930.0 | 1283.0 | 121085.0 | 8216.0 | 820165.0 | 0.010017 |
57 | 57 | 2020-03-28 | 16322.0 | 144590.0 | 937.0 | 1037.0 | 7999.0 | 7771.0 | 73249.0 | 0.10609 |
464 | 464 | 2021-05-09 | 3680383.0 | 62712321.0 | 940.0 | 908.0 | 54394.0 | 13888.0 | 1295668.0 | 0.010719 |
476 | 476 | 2021-05-21 | 3694630.0 | 65120553.0 | 948.0 | 1460.0 | 173848.0 | 10603.0 | 1244911.0 | 0.008517 |
49 | 49 | 2020-03-20 | 9013.0 | 66257.0 | 965.0 | 769.0 | 10034.0 | 3847.0 | 50253.0 | 0.076553 |
55 | 55 | 2020-03-26 | 14382.0 | 124016.0 | 972.0 | 1184.0 | 11788.0 | 6664.0 | 67793.0 | 0.098299 |
481 | 481 | 2021-05-26 | 3699232.0 | 65929553.0 | 982.0 | 1457.0 | 203467.0 | 9354.0 | 1183834.0 | 0.007901 |
489 | 489 | 2021-06-03 | 3706049.0 | 67125663.0 | 996.0 | 1298.0 | 189353.0 | 7603.0 | 1015642.0 | 0.007486 |
475 | 475 | 2021-05-20 | 3693682.0 | 64946705.0 | 999.0 | 1584.0 | 200986.0 | 10940.0 | 1248621.0 | 0.008762 |
72 | 72 | 2020-04-12 | 35609.0 | 332902.0 | 1000.0 | 736.0 | 5749.0 | 10359.0 | 95875.0 | 0.108047 |
56 | 56 | 2020-03-27 | 15385.0 | 136591.0 | 1003.0 | 1317.0 | 12575.0 | 7212.0 | 70334.0 | 0.102539 |
503 | 503 | 2021-06-17 | 3718574.0 | 68990683.0 | 1026.0 | 1375.0 | 124926.0 | 8139.0 | 840702.0 | 0.009681 |
52 | 52 | 2020-03-23 | 11515.0 | 88563.0 | 1041.0 | 1212.0 | 12581.0 | 4999.0 | 59234.0 | 0.084394 |
480 | 480 | 2021-05-25 | 3698250.0 | 65726086.0 | 1042.0 | 1549.0 | 230007.0 | 9593.0 | 1206958.0 | 0.007948 |
493 | 493 | 2021-06-07 | 3709197.0 | 67647904.0 | 1043.0 | 1499.0 | 212477.0 | 8748.0 | 1212102.0 | 0.007217 |
488 | 488 | 2021-06-02 | 3705053.0 | 66936310.0 | 1044.0 | 1428.0 | 219158.0 | 7639.0 | 1006757.0 | 0.007588 |
54 | 54 | 2020-03-25 | 13410.0 | 112228.0 | 1045.0 | 1207.0 | 11726.0 | 6143.0 | 65031.0 | 0.094463 |
501 | 501 | 2021-06-15 | 3716485.0 | 68728060.0 | 1048.0 | 1278.0 | 150001.0 | 7829.0 | 894715.0 | 0.00875 |
463 | 463 | 2021-05-08 | 3679443.0 | 62657927.0 | 1049.0 | 1262.0 | 72195.0 | 14071.0 | 1300145.0 | 0.010823 |
71 | 71 | 2020-04-11 | 34609.0 | 327153.0 | 1051.0 | 1072.0 | 9201.0 | 10608.0 | 96203.0 | 0.110267 |
494 | 494 | 2021-06-08 | 3710248.0 | 67833345.0 | 1051.0 | 1352.0 | 185441.0 | 8396.0 | 1116193.0 | 0.007522 |
502 | 502 | 2021-06-16 | 3717548.0 | 68865757.0 | 1063.0 | 1391.0 | 137697.0 | 7955.0 | 875158.0 | 0.00909 |
512 | 512 | 2021-06-26 | 3728779.0 | 69983276.0 | 1075.0 | 1137.0 | 62480.0 | 10143.0 | 809183.0 | 0.012535 |
79 | 79 | 2020-04-19 | 45856.0 | 446897.0 | 1081.0 | 901.0 | 8665.0 | 11445.0 | 113995.0 | 0.100399 |
457 | 457 | 2021-05-02 | 3670172.0 | 61416653.0 | 1103.0 | 1091.0 | 58871.0 | 15539.0 | 1332384.0 | 0.011663 |
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 |
93 | 93 | 2020-05-03 | 71050.0 | 839651.0 | 1151.0 | 1050.0 | 15588.0 | 14857.0 | 234625.0 | 0.063322 |
500 | 500 | 2021-06-14 | 3715437.0 | 68578059.0 | 1156.0 | 1485.0 | 167725.0 | 7903.0 | 930155.0 | 0.008496 |
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 );