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)
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 |
---|---|---|---|---|---|---|---|---|---|---|
101 | 101 | 2020-05-11 | 88144.0 | 1190131.0 | 2442.0 | 2770.0 | 51514.0 | 16288.0 | 305197.0 | 0.053369 |
102 | 102 | 2020-05-12 | 90617.0 | 1249577.0 | 2473.0 | 2962.0 | 59446.0 | 16279.0 | 316419.0 | 0.051448 |
103 | 103 | 2020-05-13 | 92921.0 | 1306767.0 | 2304.0 | 2927.0 | 57190.0 | 16302.0 | 317251.0 | 0.051385 |
104 | 104 | 2020-05-14 | 95582.0 | 1364734.0 | 2661.0 | 3417.0 | 57967.0 | 17161.0 | 321716.0 | 0.053342 |
105 | 105 | 2020-05-15 | 98096.0 | 1427706.0 | 2514.0 | 3396.0 | 62972.0 | 17974.0 | 331426.0 | 0.054232 |
106 | 106 | 2020-05-16 | 99829.0 | 1462284.0 | 1733.0 | 1865.0 | 34578.0 | 18261.0 | 338538.0 | 0.053941 |
107 | 107 | 2020-05-17 | 101157.0 | 1479763.0 | 1328.0 | 1120.0 | 17479.0 | 18457.0 | 341146.0 | 0.054103 |
108 | 108 | 2020-05-18 | 103953.0 | 1544632.0 | 2796.0 | 3714.0 | 64869.0 | 19401.0 | 354501.0 | 0.054728 |
109 | 109 | 2020-05-19 | 106366.0 | 1610682.0 | 2413.0 | 3511.0 | 66050.0 | 19950.0 | 361105.0 | 0.055247 |
110 | 110 | 2020-05-20 | 109089.0 | 1675572.0 | 2723.0 | 3736.0 | 64890.0 | 20759.0 | 368805.0 | 0.056287 |
111 | 111 | 2020-05-21 | 111528.0 | 1738988.0 | 2439.0 | 3465.0 | 63416.0 | 20807.0 | 374254.0 | 0.055596 |
112 | 112 | 2020-05-22 | 114050.0 | 1806653.0 | 2522.0 | 3308.0 | 67665.0 | 20719.0 | 378947.0 | 0.054675 |
113 | 113 | 2020-05-23 | 115806.0 | 1843170.0 | 1756.0 | 1951.0 | 36517.0 | 20805.0 | 380886.0 | 0.054623 |
114 | 114 | 2020-05-24 | 117212.0 | 1862901.0 | 1406.0 | 1189.0 | 19731.0 | 20874.0 | 383138.0 | 0.054482 |
115 | 115 | 2020-05-25 | 119441.0 | 1881530.0 | 2229.0 | 1451.0 | 18629.0 | 18611.0 | 336898.0 | 0.055242 |
116 | 116 | 2020-05-26 | 123034.0 | 1959358.0 | 3593.0 | 5128.0 | 77828.0 | 20228.0 | 348676.0 | 0.058014 |
117 | 117 | 2020-05-27 | 126553.0 | 2033402.0 | 3519.0 | 4486.0 | 74044.0 | 20978.0 | 357830.0 | 0.058626 |
118 | 118 | 2020-05-28 | 129732.0 | 2103337.0 | 3179.0 | 4033.0 | 69935.0 | 21546.0 | 364349.0 | 0.059136 |
119 | 119 | 2020-05-29 | 133515.0 | 2180253.0 | 3783.0 | 4574.0 | 76916.0 | 22812.0 | 373600.0 | 0.06106 |
120 | 120 | 2020-05-30 | 135743.0 | 2221230.0 | 2228.0 | 2361.0 | 40977.0 | 23222.0 | 378060.0 | 0.061424 |
121 | 121 | 2020-05-31 | 137332.0 | 2242618.0 | 1589.0 | 1246.0 | 21388.0 | 23279.0 | 379717.0 | 0.061306 |
122 | 122 | 2020-06-01 | 141009.0 | 2310293.0 | 3677.0 | 3779.0 | 67675.0 | 25607.0 | 428763.0 | 0.059723 |
123 | 123 | 2020-06-02 | 144913.0 | 2382126.0 | 3904.0 | 4471.0 | 71833.0 | 24950.0 | 422768.0 | 0.059016 |
124 | 124 | 2020-06-03 | 148324.0 | 2452748.0 | 3411.0 | 4077.0 | 70622.0 | 24541.0 | 419346.0 | 0.058522 |
125 | 125 | 2020-06-04 | 151902.0 | 2526851.0 | 3578.0 | 4168.0 | 74103.0 | 24676.0 | 423514.0 | 0.058265 |
126 | 126 | 2020-06-05 | 155595.0 | 2608741.0 | 3693.0 | 4251.0 | 81890.0 | 24353.0 | 428488.0 | 0.056835 |
127 | 127 | 2020-06-06 | 158297.0 | 2655127.0 | 2702.0 | 2755.0 | 46386.0 | 24747.0 | 433897.0 | 0.057034 |
128 | 128 | 2020-06-07 | 160329.0 | 2679366.0 | 2032.0 | 1433.0 | 24239.0 | 24934.0 | 436748.0 | 0.05709 |
129 | 129 | 2020-06-08 | 164526.0 | 2765168.0 | 4197.0 | 4729.0 | 85802.0 | 25884.0 | 454875.0 | 0.056904 |
130 | 130 | 2020-06-09 | 168520.0 | 2856257.0 | 3994.0 | 4962.0 | 91089.0 | 26375.0 | 474131.0 | 0.055628 |
131 | 131 | 2020-06-10 | 172773.0 | 2945583.0 | 4253.0 | 5253.0 | 89326.0 | 27551.0 | 492835.0 | 0.055903 |
132 | 132 | 2020-06-11 | 176836.0 | 3035235.0 | 4063.0 | 5150.0 | 89652.0 | 28533.0 | 508384.0 | 0.056125 |
133 | 133 | 2020-06-12 | 181307.0 | 3126659.0 | 4471.0 | 5037.0 | 91424.0 | 29319.0 | 517918.0 | 0.056609 |
134 | 134 | 2020-06-13 | 184956.0 | 3171891.0 | 3649.0 | 3290.0 | 45232.0 | 29854.0 | 516764.0 | 0.057771 |
135 | 135 | 2020-06-14 | 187956.0 | 3198115.0 | 3000.0 | 1862.0 | 26224.0 | 30283.0 | 518749.0 | 0.058377 |
136 | 136 | 2020-06-15 | 194383.0 | 3292610.0 | 6427.0 | 6457.0 | 94495.0 | 32011.0 | 527442.0 | 0.060691 |
137 | 137 | 2020-06-16 | 200844.0 | 3392252.0 | 6461.0 | 7418.0 | 99642.0 | 34467.0 | 535995.0 | 0.064305 |
138 | 138 | 2020-06-17 | 207593.0 | 3491850.0 | 6749.0 | 7759.0 | 99598.0 | 36973.0 | 546267.0 | 0.067683 |
139 | 139 | 2020-06-18 | 214352.0 | 3592973.0 | 6759.0 | 8050.0 | 101123.0 | 39873.0 | 557738.0 | 0.071491 |
140 | 140 | 2020-06-19 | 221268.0 | 3694238.0 | 6916.0 | 8056.0 | 101265.0 | 42892.0 | 567579.0 | 0.07557 |
141 | 141 | 2020-06-20 | 226626.0 | 3744937.0 | 5358.0 | 5064.0 | 50699.0 | 44666.0 | 573046.0 | 0.077945 |
142 | 142 | 2020-06-21 | 230978.0 | 3772788.0 | 4352.0 | 2967.0 | 27851.0 | 45771.0 | 574673.0 | 0.079647 |
143 | 143 | 2020-06-22 | 240380.0 | 3881064.0 | 9402.0 | 9697.0 | 108276.0 | 49011.0 | 588454.0 | 0.083288 |
144 | 144 | 2020-06-23 | 250079.0 | 4002233.0 | 9699.0 | 10794.0 | 121169.0 | 52387.0 | 609981.0 | 0.085883 |
145 | 145 | 2020-06-24 | 259943.0 | 4125891.0 | 9864.0 | 11025.0 | 123658.0 | 55653.0 | 634041.0 | 0.087775 |
146 | 146 | 2020-06-25 | 269366.0 | 4254468.0 | 9423.0 | 11269.0 | 128577.0 | 58872.0 | 661495.0 | 0.088998 |
147 | 147 | 2020-06-26 | 278480.0 | 4379527.0 | 9114.0 | 10513.0 | 125059.0 | 61329.0 | 685289.0 | 0.089494 |
148 | 148 | 2020-06-27 | 284747.0 | 4444017.0 | 6267.0 | 6524.0 | 64490.0 | 62789.0 | 699080.0 | 0.089817 |
149 | 149 | 2020-06-28 | 290217.0 | 4481026.0 | 5470.0 | 3981.0 | 37009.0 | 63803.0 | 708238.0 | 0.090087 |
150 | 150 | 2020-06-29 | 300736.0 | 4604373.0 | 10519.0 | 11803.0 | 123347.0 | 65909.0 | 723309.0 | 0.091121 |
151 | 151 | 2020-06-30 | 311258.0 | 4736737.0 | 10522.0 | 12313.0 | 132364.0 | 67428.0 | 734504.0 | 0.091801 |
152 | 152 | 2020-07-01 | 322499.0 | 4873818.0 | 11241.0 | 12471.0 | 137081.0 | 68874.0 | 747927.0 | 0.092087 |
153 | 153 | 2020-07-02 | 333123.0 | 5020037.0 | 10624.0 | 12811.0 | 146219.0 | 70416.0 | 765569.0 | 0.091979 |
154 | 154 | 2020-07-03 | 341105.0 | 5101432.0 | 7982.0 | 8049.0 | 81395.0 | 67952.0 | 721905.0 | 0.094129 |
155 | 155 | 2020-07-04 | 346489.0 | 5128835.0 | 5384.0 | 3752.0 | 27403.0 | 65180.0 | 684818.0 | 0.095179 |
156 | 156 | 2020-07-05 | 352718.0 | 5168189.0 | 6229.0 | 4669.0 | 39354.0 | 65868.0 | 687163.0 | 0.095855 |
157 | 157 | 2020-07-06 | 364505.0 | 5306185.0 | 11787.0 | 13030.0 | 137996.0 | 67095.0 | 701812.0 | 0.095603 |
158 | 158 | 2020-07-07 | 377035.0 | 5461881.0 | 12530.0 | 14871.0 | 155696.0 | 69653.0 | 725144.0 | 0.096054 |
159 | 159 | 2020-07-08 | 389238.0 | 5621754.0 | 12203.0 | 14763.0 | 159873.0 | 71945.0 | 747936.0 | 0.096191 |
160 | 160 | 2020-07-09 | 400408.0 | 5777159.0 | 11170.0 | 14319.0 | 155405.0 | 73453.0 | 757122.0 | 0.097016 |
161 | 161 | 2020-07-10 | 411833.0 | 5929478.0 | 11425.0 | 13955.0 | 152319.0 | 79359.0 | 828046.0 | 0.095839 |
162 | 162 | 2020-07-11 | 419404.0 | 6009357.0 | 7571.0 | 8512.0 | 79879.0 | 84119.0 | 880522.0 | 0.095533 |
163 | 163 | 2020-07-12 | 425301.0 | 6053904.0 | 5897.0 | 5166.0 | 44547.0 | 84616.0 | 885715.0 | 0.095534 |
164 | 164 | 2020-07-13 | 436948.0 | 6210963.0 | 11647.0 | 14075.0 | 157059.0 | 85661.0 | 904778.0 | 0.094676 |
165 | 165 | 2020-07-14 | 448513.0 | 6373716.0 | 11565.0 | 14652.0 | 162753.0 | 85442.0 | 911835.0 | 0.093703 |
166 | 166 | 2020-07-15 | 460113.0 | 6536676.0 | 11600.0 | 14107.0 | 162960.0 | 84786.0 | 914922.0 | 0.09267 |
167 | 167 | 2020-07-16 | 471182.0 | 6698186.0 | 11069.0 | 13832.0 | 161510.0 | 84299.0 | 921027.0 | 0.091527 |
168 | 168 | 2020-07-17 | 481874.0 | 6848345.0 | 10692.0 | 13304.0 | 150159.0 | 83648.0 | 918867.0 | 0.091034 |
169 | 169 | 2020-07-18 | 489205.0 | 6930337.0 | 7331.0 | 8196.0 | 81992.0 | 83332.0 | 920980.0 | 0.090482 |
170 | 170 | 2020-07-19 | 494688.0 | 6980972.0 | 5483.0 | 5006.0 | 50635.0 | 83172.0 | 927068.0 | 0.089715 |
171 | 171 | 2020-07-20 | 505752.0 | 7141352.0 | 11064.0 | 13733.0 | 160380.0 | 82830.0 | 930389.0 | 0.089027 |
172 | 172 | 2020-07-21 | 515863.0 | 7306813.0 | 10111.0 | 13524.0 | 165461.0 | 81702.0 | 933097.0 | 0.08756 |
173 | 173 | 2020-07-22 | 525231.0 | 7457936.0 | 9368.0 | 11654.0 | 151123.0 | 79249.0 | 921260.0 | 0.086022 |
174 | 174 | 2020-07-23 | 533731.0 | 7595658.0 | 8500.0 | 10666.0 | 137722.0 | 76083.0 | 897472.0 | 0.084775 |
175 | 175 | 2020-07-24 | 542013.0 | 7717190.0 | 8282.0 | 10318.0 | 121532.0 | 73097.0 | 868845.0 | 0.084131 |
176 | 176 | 2020-07-25 | 547810.0 | 7783990.0 | 5797.0 | 6501.0 | 66800.0 | 71402.0 | 853653.0 | 0.083643 |
177 | 177 | 2020-07-26 | 551963.0 | 7823322.0 | 4153.0 | 3343.0 | 39332.0 | 69739.0 | 842350.0 | 0.082791 |
178 | 178 | 2020-07-27 | 561050.0 | 7979859.0 | 9087.0 | 11484.0 | 156537.0 | 67490.0 | 838507.0 | 0.080488 |
179 | 179 | 2020-07-28 | 569850.0 | 8138669.0 | 8800.0 | 12001.0 | 158810.0 | 65967.0 | 831856.0 | 0.079301 |
180 | 180 | 2020-07-29 | 577664.0 | 8289018.0 | 7814.0 | 11098.0 | 150349.0 | 65411.0 | 831082.0 | 0.078706 |
181 | 181 | 2020-07-30 | 584903.0 | 8431224.0 | 7239.0 | 10277.0 | 142206.0 | 65022.0 | 835566.0 | 0.077818 |
182 | 182 | 2020-07-31 | 592120.0 | 8570111.0 | 7217.0 | 10052.0 | 138887.0 | 64756.0 | 852921.0 | 0.075923 |
183 | 183 | 2020-08-01 | 597509.0 | 8643241.0 | 5389.0 | 5931.0 | 73130.0 | 64186.0 | 859251.0 | 0.0747 |
184 | 184 | 2020-08-02 | 601081.0 | 8683904.0 | 3572.0 | 3142.0 | 40663.0 | 63985.0 | 860582.0 | 0.074351 |
185 | 185 | 2020-08-03 | 608634.0 | 8828677.0 | 7553.0 | 10204.0 | 144773.0 | 62705.0 | 848818.0 | 0.073873 |
186 | 186 | 2020-08-04 | 615859.0 | 8985244.0 | 7225.0 | 10326.0 | 156567.0 | 61030.0 | 846575.0 | 0.07209 |
187 | 187 | 2020-08-05 | 622567.0 | 9130538.0 | 6708.0 | 8755.0 | 145294.0 | 58687.0 | 841520.0 | 0.069739 |
188 | 188 | 2020-08-06 | 628827.0 | 9266580.0 | 6260.0 | 8499.0 | 136042.0 | 56909.0 | 835356.0 | 0.068125 |
189 | 189 | 2020-08-07 | 635273.0 | 9395069.0 | 6446.0 | 8721.0 | 128489.0 | 55578.0 | 824958.0 | 0.067371 |
190 | 190 | 2020-08-08 | 639569.0 | 9457278.0 | 4296.0 | 4667.0 | 62209.0 | 54314.0 | 814037.0 | 0.066722 |
191 | 191 | 2020-08-09 | 642746.0 | 9493771.0 | 3177.0 | 2627.0 | 36493.0 | 53799.0 | 809867.0 | 0.066429 |
192 | 192 | 2020-08-10 | 649835.0 | 9629217.0 | 7089.0 | 9020.0 | 135446.0 | 52615.0 | 800540.0 | 0.065724 |
193 | 193 | 2020-08-11 | 656048.0 | 9768445.0 | 6213.0 | 8772.0 | 139228.0 | 51061.0 | 783201.0 | 0.065195 |
194 | 194 | 2020-08-12 | 662006.0 | 9912798.0 | 5958.0 | 8512.0 | 144353.0 | 50818.0 | 782260.0 | 0.064963 |
195 | 195 | 2020-08-13 | 667161.0 | 10039065.0 | 5155.0 | 7403.0 | 126267.0 | 49722.0 | 772485.0 | 0.064366 |
196 | 196 | 2020-08-14 | 672372.0 | 10158340.0 | 5211.0 | 7375.0 | 119275.0 | 48376.0 | 763271.0 | 0.06338 |
197 | 197 | 2020-08-15 | 676040.0 | 10219519.0 | 3668.0 | 4348.0 | 61179.0 | 48057.0 | 762241.0 | 0.063047 |
198 | 198 | 2020-08-16 | 678723.0 | 10253332.0 | 2683.0 | 2181.0 | 33813.0 | 47611.0 | 759561.0 | 0.062682 |
199 | 199 | 2020-08-17 | 684495.0 | 10382708.0 | 5772.0 | 7461.0 | 129376.0 | 46052.0 | 753491.0 | 0.061118 |
200 | 200 | 2020-08-18 | 689762.0 | 10511408.0 | 5267.0 | 6967.0 | 128700.0 | 44247.0 | 742963.0 | 0.059555 |
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 );