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_positive_tests
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
17 | 17 | 2020-02-17 | 150.0 | 1273.0 | 13.0 | 0.0 | 85.0 | 3.0 | 266.0 | 0.011278 |
19 | 19 | 2020-02-19 | 172.0 | 1300.0 | 12.0 | 0.0 | 10.0 | 4.0 | 250.0 | 0.016 |
22 | 22 | 2020-02-22 | 229.0 | 1372.0 | 17.0 | 0.0 | 27.0 | 7.0 | 248.0 | 0.028226 |
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 | |||
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 |
15 | 15 | 2020-02-15 | 130.0 | 1124.0 | 12.0 | 1.0 | 43.0 | 3.0 | 154.0 | 0.019481 |
18 | 18 | 2020-02-18 | 160.0 | 1290.0 | 10.0 | 1.0 | 17.0 | 4.0 | 243.0 | 0.016461 |
25 | 25 | 2020-02-25 | 312.0 | 1441.0 | 25.0 | 1.0 | 12.0 | 11.0 | 151.0 | 0.072848 |
2 | 2 | 2020-02-02 | 33.0 | 340.0 | 9.0 | 2.0 | 36.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 |
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 |
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 |
26 | 26 | 2020-02-26 | 351.0 | 1465.0 | 39.0 | 3.0 | 24.0 | 14.0 | 165.0 | 0.084848 |
30 | 30 | 2020-03-01 | 566.0 | 1832.0 | 99.0 | 4.0 | 79.0 | 53.0 | 423.0 | 0.125296 |
1 | 1 | 2020-02-01 | 24.0 | 304.0 | 24.0 | 9.0 | 304.0 | |||
27 | 27 | 2020-02-27 | 377.0 | 1543.0 | 26.0 | 9.0 | 78.0 | 21.0 | 217.0 | 0.096774 |
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 |
32 | 32 | 2020-03-03 | 727.0 | 2154.0 | 85.0 | 25.0 | 145.0 | 107.0 | 713.0 | 0.15007 |
35 | 35 | 2020-03-06 | 1092.0 | 3169.0 | 159.0 | 31.0 | 411.0 | 184.0 | 1505.0 | 0.122259 |
31 | 31 | 2020-03-02 | 642.0 | 2009.0 | 76.0 | 33.0 | 177.0 | 83.0 | 580.0 | 0.143103 |
34 | 34 | 2020-03-05 | 933.0 | 2758.0 | 111.0 | 36.0 | 367.0 | 170.0 | 1215.0 | 0.139918 |
33 | 33 | 2020-03-04 | 822.0 | 2391.0 | 95.0 | 39.0 | 237.0 | 143.0 | 926.0 | 0.154428 |
37 | 37 | 2020-03-08 | 1437.0 | 3996.0 | 181.0 | 51.0 | 321.0 | 291.0 | 2164.0 | 0.134473 |
7 | 7 | 2020-02-07 | 82.0 | 911.0 | 31.0 | 62.0 | 453.0 | 77.0 | 911.0 | 0.084523 |
36 | 36 | 2020-03-07 | 1256.0 | 3675.0 | 164.0 | 76.0 | 506.0 | 244.0 | 1922.0 | 0.126951 |
39 | 39 | 2020-03-10 | 2126.0 | 6211.0 | 357.0 | 124.0 | 1186.0 | 487.0 | 4057.0 | 0.120039 |
38 | 38 | 2020-03-09 | 1769.0 | 5025.0 | 332.0 | 130.0 | 1029.0 | 388.0 | 3016.0 | 0.128647 |
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 |
44 | 44 | 2020-03-15 | 4762.0 | 21554.0 | 602.0 | 255.0 | 2767.0 | 1561.0 | 17558.0 | 0.088905 |
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 |
50 | 50 | 2020-03-21 | 9707.0 | 71341.0 | 694.0 | 478.0 | 5084.0 | 4013.0 | 52554.0 | 0.07636 |
486 | 486 | 2021-05-31 | 3702799.0 | 66435802.0 | 595.0 | 527.0 | 60572.0 | 7513.0 | 939723.0 | 0.007995 |
45 | 45 | 2020-03-16 | 5643.0 | 29329.0 | 881.0 | 579.0 | 7775.0 | 2010.0 | 24304.0 | 0.082702 |
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 |
499 | 499 | 2021-06-13 | 3714281.0 | 68410334.0 | 701.0 | 639.0 | 54343.0 | 7917.0 | 974907.0 | 0.008121 |
485 | 485 | 2021-05-30 | 3702204.0 | 66375230.0 | 585.0 | 650.0 | 52035.0 | 8656.0 | 1134047.0 | 0.007633 |
46 | 46 | 2020-03-17 | 6482.0 | 38271.0 | 839.0 | 653.0 | 8942.0 | 2539.0 | 32060.0 | 0.079195 |
492 | 492 | 2021-06-06 | 3708154.0 | 67435427.0 | 610.0 | 662.0 | 58485.0 | 7776.0 | 1060197.0 | 0.007334 |
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 |
58 | 58 | 2020-03-29 | 17145.0 | 149833.0 | 823.0 | 698.0 | 5243.0 | 7861.0 | 73851.0 | 0.106444 |
478 | 478 | 2021-05-23 | 3696002.0 | 65241183.0 | 662.0 | 728.0 | 55655.0 | 10184.0 | 1239282.0 | 0.008218 |
72 | 72 | 2020-04-12 | 35609.0 | 332902.0 | 1000.0 | 736.0 | 5749.0 | 10359.0 | 95875.0 | 0.108047 |
484 | 484 | 2021-05-29 | 3701619.0 | 66323195.0 | 603.0 | 745.0 | 59266.0 | 8734.0 | 1137667.0 | 0.007677 |
498 | 498 | 2021-06-12 | 3713580.0 | 68355991.0 | 677.0 | 765.0 | 64388.0 | 7940.0 | 979049.0 | 0.00811 |
49 | 49 | 2020-03-20 | 9013.0 | 66257.0 | 965.0 | 769.0 | 10034.0 | 3847.0 | 50253.0 | 0.076553 |
520 | 520 | 2021-07-04 | 3743203.0 | 70828580.0 | 1555.0 | 781.0 | 27994.0 | 14407.0 | 793687.0 | 0.018152 |
491 | 491 | 2021-06-05 | 3707544.0 | 67376942.0 | 643.0 | 848.0 | 74627.0 | 7764.0 | 1053747.0 | 0.007368 |
79 | 79 | 2020-04-19 | 45856.0 | 446897.0 | 1081.0 | 901.0 | 8665.0 | 11445.0 | 113995.0 | 0.100399 |
471 | 471 | 2021-05-16 | 3688922.0 | 64001901.0 | 813.0 | 903.0 | 57602.0 | 12241.0 | 1289580.0 | 0.009492 |
477 | 477 | 2021-05-22 | 3695340.0 | 65185528.0 | 710.0 | 906.0 | 64975.0 | 10359.0 | 1241229.0 | 0.008346 |
464 | 464 | 2021-05-09 | 3680383.0 | 62712321.0 | 940.0 | 908.0 | 54394.0 | 13888.0 | 1295668.0 | 0.010719 |
100 | 100 | 2020-05-10 | 85702.0 | 1138617.0 | 1327.0 | 924.0 | 14871.0 | 16226.0 | 298966.0 | 0.054274 |
505 | 505 | 2021-06-19 | 3720258.0 | 69174093.0 | 754.0 | 928.0 | 62325.0 | 8379.0 | 818102.0 | 0.010242 |
513 | 513 | 2021-06-27 | 3729950.0 | 70034893.0 | 1171.0 | 953.0 | 51617.0 | 10432.0 | 811724.0 | 0.012852 |
65 | 65 | 2020-04-05 | 26447.0 | 237027.0 | 1140.0 | 985.0 | 6077.0 | 10220.0 | 87194.0 | 0.11721 |
86 | 86 | 2020-04-26 | 57952.0 | 605026.0 | 1270.0 | 1014.0 | 11506.0 | 13429.0 | 158129.0 | 0.084924 |
57 | 57 | 2020-03-28 | 16322.0 | 144590.0 | 937.0 | 1037.0 | 7999.0 | 7771.0 | 73249.0 | 0.10609 |
93 | 93 | 2020-05-03 | 71050.0 | 839651.0 | 1151.0 | 1050.0 | 15588.0 | 14857.0 | 234625.0 | 0.063322 |
71 | 71 | 2020-04-11 | 34609.0 | 327153.0 | 1051.0 | 1072.0 | 9201.0 | 10608.0 | 96203.0 | 0.110267 |
64 | 64 | 2020-04-04 | 25307.0 | 230950.0 | 1126.0 | 1078.0 | 8010.0 | 9933.0 | 86360.0 | 0.115019 |
457 | 457 | 2021-05-02 | 3670172.0 | 61416653.0 | 1103.0 | 1091.0 | 58871.0 | 15539.0 | 1332384.0 | 0.011663 |
107 | 107 | 2020-05-17 | 101157.0 | 1479763.0 | 1328.0 | 1120.0 | 17479.0 | 18457.0 | 341146.0 | 0.054103 |
512 | 512 | 2021-06-26 | 3728779.0 | 69983276.0 | 1075.0 | 1137.0 | 62480.0 | 10143.0 | 809183.0 | 0.012535 |
470 | 470 | 2021-05-15 | 3688109.0 | 63944299.0 | 900.0 | 1150.0 | 68657.0 | 12246.0 | 1286372.0 | 0.00952 |
55 | 55 | 2020-03-26 | 14382.0 | 124016.0 | 972.0 | 1184.0 | 11788.0 | 6664.0 | 67793.0 | 0.098299 |
114 | 114 | 2020-05-24 | 117212.0 | 1862901.0 | 1406.0 | 1189.0 | 19731.0 | 20874.0 | 383138.0 | 0.054482 |
496 | 496 | 2021-06-10 | 3712051.0 | 68149981.0 | 876.0 | 1191.0 | 159382.0 | 8126.0 | 1024318.0 | 0.007933 |
53 | 53 | 2020-03-24 | 12365.0 | 100502.0 | 850.0 | 1206.0 | 11939.0 | 5552.0 | 62231.0 | 0.089216 |
497 | 497 | 2021-06-11 | 3712903.0 | 68291603.0 | 852.0 | 1206.0 | 141622.0 | 8023.0 | 989288.0 | 0.00811 |
54 | 54 | 2020-03-25 | 13410.0 | 112228.0 | 1045.0 | 1207.0 | 11726.0 | 6143.0 | 65031.0 | 0.094463 |
52 | 52 | 2020-03-23 | 11515.0 | 88563.0 | 1041.0 | 1212.0 | 12581.0 | 4999.0 | 59234.0 | 0.084394 |
664 | 664 | 2021-11-25 | 4830872.0 | 111409677.0 | 2313.0 | 1215.0 | 30667.0 | 34430.0 | 1200234.0 | 0.028686 |
121 | 121 | 2020-05-31 | 137332.0 | 2242618.0 | 1589.0 | 1246.0 | 21388.0 | 23279.0 | 379717.0 | 0.061306 |
483 | 483 | 2021-05-28 | 3701016.0 | 66263929.0 | 862.0 | 1251.0 | 153908.0 | 8895.0 | 1143376.0 | 0.00778 |
463 | 463 | 2021-05-08 | 3679443.0 | 62657927.0 | 1049.0 | 1262.0 | 72195.0 | 14071.0 | 1300145.0 | 0.010823 |
495 | 495 | 2021-06-09 | 3711175.0 | 67990599.0 | 927.0 | 1265.0 | 157254.0 | 8233.0 | 1054289.0 | 0.007809 |
78 | 78 | 2020-04-18 | 44775.0 | 438232.0 | 1206.0 | 1273.0 | 12984.0 | 11280.0 | 111079.0 | 0.101549 |
429 | 429 | 2021-04-04 | 3615246.0 | 55977829.0 | 1552.0 | 1275.0 | 51321.0 | 19768.0 | 1163899.0 | 0.016984 |
501 | 501 | 2021-06-15 | 3716485.0 | 68728060.0 | 1048.0 | 1278.0 | 150001.0 | 7829.0 | 894715.0 | 0.00875 |
504 | 504 | 2021-06-18 | 3719504.0 | 69111768.0 | 930.0 | 1283.0 | 121085.0 | 8216.0 | 820165.0 | 0.010017 |
489 | 489 | 2021-06-03 | 3706049.0 | 67125663.0 | 996.0 | 1298.0 | 189353.0 | 7603.0 | 1015642.0 | 0.007486 |
490 | 490 | 2021-06-04 | 3706901.0 | 67302315.0 | 852.0 | 1309.0 | 176652.0 | 7661.0 | 1038386.0 | 0.007378 |
450 | 450 | 2021-04-25 | 3658689.0 | 60084269.0 | 1217.0 | 1313.0 | 71957.0 | 17570.0 | 1397079.0 | 0.012576 |
56 | 56 | 2020-03-27 | 15385.0 | 136591.0 | 1003.0 | 1317.0 | 12575.0 | 7212.0 | 70334.0 | 0.102539 |
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 );