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 descending
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 | 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 | |||
710 | 710 | 2022-01-10 | 6679627.0 | 128729005.0 | 141620.0 | 178258.0 | 835216.0 | 1061193.0 | 4711626.0 | 0.225229 |
709 | 709 | 2022-01-09 | 6538007.0 | 127893789.0 | 56172.0 | 65590.0 | 255519.0 | 1047219.0 | 4664700.0 | 0.224499 |
711 | 711 | 2022-01-11 | 6814820.0 | 129565534.0 | 135193.0 | 172426.0 | 836529.0 | 1043409.0 | 4697045.0 | 0.222142 |
708 | 708 | 2022-01-08 | 6481835.0 | 127638270.0 | 77100.0 | 93952.0 | 366134.0 | 1042420.0 | 4682120.0 | 0.222638 |
712 | 712 | 2022-01-12 | 6941543.0 | 130358785.0 | 126723.0 | 162277.0 | 793251.0 | 1017082.0 | 4669137.0 | 0.217831 |
713 | 713 | 2022-01-13 | 7056072.0 | 131128359.0 | 114529.0 | 149869.0 | 769574.0 | 991443.0 | 4620981.0 | 0.214552 |
707 | 707 | 2022-01-07 | 6404735.0 | 127272136.0 | 135067.0 | 169071.0 | 764758.0 | 974745.0 | 4421483.0 | 0.220457 |
714 | 714 | 2022-01-14 | 7160307.0 | 131815351.0 | 104235.0 | 137996.0 | 686992.0 | 960368.0 | 4543215.0 | 0.211385 |
715 | 715 | 2022-01-15 | 7218888.0 | 132098427.0 | 58581.0 | 73946.0 | 283076.0 | 940362.0 | 4460157.0 | 0.210836 |
716 | 716 | 2022-01-16 | 7259255.0 | 132299655.0 | 40367.0 | 48309.0 | 201228.0 | 923081.0 | 4405866.0 | 0.209512 |
706 | 706 | 2022-01-06 | 6269668.0 | 126507378.0 | 143683.0 | 175508.0 | 817730.0 | 868107.0 | 3940839.0 | 0.220285 |
717 | 717 | 2022-01-17 | 7340741.0 | 132764473.0 | 81486.0 | 105650.0 | 464818.0 | 850473.0 | 4035468.0 | 0.21075 |
718 | 718 | 2022-01-18 | 7460565.0 | 133637289.0 | 119824.0 | 156980.0 | 872816.0 | 835027.0 | 4071755.0 | 0.205078 |
719 | 719 | 2022-01-19 | 7561706.0 | 134373699.0 | 101141.0 | 132538.0 | 736410.0 | 805288.0 | 4014914.0 | 0.200574 |
705 | 705 | 2022-01-05 | 6125985.0 | 125689648.0 | 155374.0 | 188604.0 | 821159.0 | 797972.0 | 3625069.0 | 0.220126 |
720 | 720 | 2022-01-20 | 7651745.0 | 135072989.0 | 90039.0 | 120399.0 | 699290.0 | 775818.0 | 3944630.0 | 0.196677 |
721 | 721 | 2022-01-21 | 7729070.0 | 135686495.0 | 77325.0 | 106731.0 | 613506.0 | 744553.0 | 3871144.0 | 0.192334 |
722 | 722 | 2022-01-22 | 7768980.0 | 135922347.0 | 39910.0 | 54236.0 | 235852.0 | 724843.0 | 3823920.0 | 0.189555 |
704 | 704 | 2022-01-04 | 5970611.0 | 124868489.0 | 157048.0 | 190210.0 | 851110.0 | 718557.0 | 3320086.0 | 0.216427 |
723 | 723 | 2022-01-23 | 7797365.0 | 136091297.0 | 28385.0 | 36770.0 | 168950.0 | 713304.0 | 3791642.0 | 0.188125 |
724 | 724 | 2022-01-24 | 7868082.0 | 136788173.0 | 70717.0 | 100283.0 | 696876.0 | 707937.0 | 4023700.0 | 0.175942 |
725 | 725 | 2022-01-25 | 7928222.0 | 137417246.0 | 60140.0 | 86223.0 | 629073.0 | 637180.0 | 3779957.0 | 0.168568 |
703 | 703 | 2022-01-03 | 5813563.0 | 124017379.0 | 140227.0 | 164284.0 | 788290.0 | 634250.0 | 2988503.0 | 0.21223 |
726 | 726 | 2022-01-26 | 7980285.0 | 138005358.0 | 52063.0 | 75844.0 | 588112.0 | 580486.0 | 3631659.0 | 0.15984 |
702 | 702 | 2022-01-02 | 5673336.0 | 123229089.0 | 56862.0 | 60791.0 | 272939.0 | 555215.0 | 2670274.0 | 0.207924 |
701 | 701 | 2022-01-01 | 5616474.0 | 122956150.0 | 33071.0 | 26277.0 | 105497.0 | 528279.0 | 2586304.0 | 0.20426 |
727 | 727 | 2022-01-27 | 8024685.0 | 138558764.0 | 44400.0 | 65405.0 | 553406.0 | 525492.0 | 3485775.0 | 0.150753 |
700 | 700 | 2021-12-31 | 5583403.0 | 122850653.0 | 54761.0 | 62433.0 | 284114.0 | 510553.0 | 2532091.0 | 0.201633 |
728 | 728 | 2022-01-28 | 8063504.0 | 139046711.0 | 38819.0 | 59619.0 | 487947.0 | 478380.0 | 3360216.0 | 0.142366 |
699 | 699 | 2021-12-30 | 5528642.0 | 122566539.0 | 86207.0 | 105373.0 | 501960.0 | 469588.0 | 2410916.0 | 0.194776 |
729 | 729 | 2022-01-29 | 8084393.0 | 139218626.0 | 20889.0 | 31283.0 | 171915.0 | 455427.0 | 3296279.0 | 0.138164 |
730 | 730 | 2022-01-30 | 8099906.0 | 139348908.0 | 15513.0 | 20828.0 | 130282.0 | 439485.0 | 3257611.0 | 0.13491 |
698 | 698 | 2021-12-29 | 5442435.0 | 122064579.0 | 88804.0 | 109189.0 | 516176.0 | 404270.0 | 2259703.0 | 0.178904 |
731 | 731 | 2022-01-31 | 8138494.0 | 139964957.0 | 38588.0 | 59151.0 | 616049.0 | 398353.0 | 3176784.0 | 0.125395 |
343 | 343 | 2021-01-08 | 2862306.0 | 37513632.0 | 40989.0 | 53011.0 | 369135.0 | 384145.0 | 2537076.0 | 0.151412 |
344 | 344 | 2021-01-09 | 2890868.0 | 37723059.0 | 28562.0 | 34952.0 | 209427.0 | 375293.0 | 2526986.0 | 0.148514 |
345 | 345 | 2021-01-10 | 2910006.0 | 37868900.0 | 19138.0 | 19093.0 | 145841.0 | 368731.0 | 2513087.0 | 0.146724 |
732 | 732 | 2022-02-01 | 8171153.0 | 140487617.0 | 32659.0 | 46999.0 | 522660.0 | 359129.0 | 3070371.0 | 0.116966 |
346 | 346 | 2021-01-11 | 2951962.0 | 38331105.0 | 41956.0 | 53479.0 | 462205.0 | 350971.0 | 2495236.0 | 0.140656 |
342 | 342 | 2021-01-07 | 2821317.0 | 37144497.0 | 44961.0 | 58003.0 | 414873.0 | 342062.0 | 2227562.0 | 0.153559 |
697 | 697 | 2021-12-28 | 5353631.0 | 121548403.0 | 89472.0 | 105903.0 | 519527.0 | 333480.0 | 2129714.0 | 0.156584 |
327 | 327 | 2020-12-23 | 2218108.0 | 32870031.0 | 45376.0 | 56102.0 | 386130.0 | 333426.0 | 2377048.0 | 0.140269 |
326 | 326 | 2020-12-22 | 2172732.0 | 32483901.0 | 49039.0 | 59247.0 | 425513.0 | 333113.0 | 2389266.0 | 0.139421 |
347 | 347 | 2021-01-12 | 2990550.0 | 38753935.0 | 38588.0 | 50320.0 | 422830.0 | 331922.0 | 2454798.0 | 0.135214 |
325 | 325 | 2020-12-21 | 2123693.0 | 32058388.0 | 48547.0 | 57432.0 | 448746.0 | 331696.0 | 2373761.0 | 0.139734 |
339 | 339 | 2021-01-04 | 2671124.0 | 35835869.0 | 60486.0 | 71239.0 | 480056.0 | 331488.0 | 1980512.0 | 0.167375 |
324 | 324 | 2020-12-20 | 2075146.0 | 31609642.0 | 21114.0 | 19800.0 | 145893.0 | 329034.0 | 2338972.0 | 0.140675 |
323 | 323 | 2020-12-19 | 2054032.0 | 31463749.0 | 29910.0 | 34760.0 | 210392.0 | 328366.0 | 2324045.0 | 0.141291 |
340 | 340 | 2021-01-05 | 2725930.0 | 36299137.0 | 54806.0 | 69369.0 | 463268.0 | 327529.0 | 2016891.0 | 0.162393 |
338 | 338 | 2021-01-03 | 2610638.0 | 35355813.0 | 27233.0 | 25655.0 | 159740.0 | 326402.0 | 1926356.0 | 0.16944 |
322 | 322 | 2020-12-18 | 2024122.0 | 31253357.0 | 41822.0 | 50863.0 | 362337.0 | 326324.0 | 2306590.0 | 0.141475 |
337 | 337 | 2021-01-02 | 2583405.0 | 35196073.0 | 37401.0 | 43804.0 | 219517.0 | 325091.0 | 1910143.0 | 0.170192 |
733 | 733 | 2022-02-02 | 8198468.0 | 140979690.0 | 27315.0 | 40670.0 | 492073.0 | 323955.0 | 2974332.0 | 0.108917 |
341 | 341 | 2021-01-06 | 2776356.0 | 36729624.0 | 50426.0 | 63064.0 | 430487.0 | 322572.0 | 2048853.0 | 0.15744 |
336 | 336 | 2021-01-01 | 2546004.0 | 34976556.0 | 19845.0 | 10928.0 | 59621.0 | 321628.0 | 1886430.0 | 0.170496 |
321 | 321 | 2020-12-17 | 1982300.0 | 30891020.0 | 44711.0 | 55222.0 | 398037.0 | 320540.0 | 2276543.0 | 0.140801 |
335 | 335 | 2020-12-31 | 2526159.0 | 34916935.0 | 35645.0 | 38513.0 | 236164.0 | 318286.0 | 1866706.0 | 0.170507 |
348 | 348 | 2021-01-13 | 3025172.0 | 39148816.0 | 34622.0 | 46104.0 | 394881.0 | 314962.0 | 2419192.0 | 0.130193 |
320 | 320 | 2020-12-16 | 1937589.0 | 30492983.0 | 45972.0 | 55789.0 | 398348.0 | 312252.0 | 2232653.0 | 0.139857 |
334 | 334 | 2020-12-30 | 2490514.0 | 34680771.0 | 53971.0 | 68021.0 | 398525.0 | 306814.0 | 1810740.0 | 0.169441 |
328 | 328 | 2020-12-24 | 2245080.0 | 33050229.0 | 26972.0 | 27041.0 | 180198.0 | 305245.0 | 2159209.0 | 0.141369 |
319 | 319 | 2020-12-15 | 1891617.0 | 30094635.0 | 48525.0 | 57830.0 | 410008.0 | 304735.0 | 2206345.0 | 0.138118 |
349 | 349 | 2021-01-14 | 3056956.0 | 39534129.0 | 31784.0 | 44362.0 | 385313.0 | 301321.0 | 2389632.0 | 0.126095 |
333 | 333 | 2020-12-29 | 2436543.0 | 34282246.0 | 58572.0 | 73328.0 | 426889.0 | 294895.0 | 1798345.0 | 0.163981 |
734 | 734 | 2022-02-03 | 8222324.0 | 141470852.0 | 23856.0 | 36263.0 | 491162.0 | 294813.0 | 2912088.0 | 0.101238 |
318 | 318 | 2020-12-14 | 1843092.0 | 29684627.0 | 49499.0 | 54770.0 | 413957.0 | 294373.0 | 2183942.0 | 0.13479 |
350 | 350 | 2021-01-15 | 3085934.0 | 39870349.0 | 28978.0 | 39814.0 | 336220.0 | 288124.0 | 2356717.0 | 0.122257 |
317 | 317 | 2020-12-13 | 1793593.0 | 29270670.0 | 21087.0 | 19132.0 | 130966.0 | 285720.0 | 2166477.0 | 0.131882 |
316 | 316 | 2020-12-12 | 1772506.0 | 29139704.0 | 30848.0 | 32718.0 | 192937.0 | 282804.0 | 2157536.0 | 0.131077 |
332 | 332 | 2020-12-28 | 2377971.0 | 33855357.0 | 58083.0 | 66153.0 | 425900.0 | 280814.0 | 1796969.0 | 0.156271 |
351 | 351 | 2021-01-16 | 3105896.0 | 40045278.0 | 19962.0 | 26005.0 | 174929.0 | 279177.0 | 2322219.0 | 0.12022 |
315 | 315 | 2020-12-11 | 1741658.0 | 28946767.0 | 40163.0 | 45079.0 | 332290.0 | 276284.0 | 2145723.0 | 0.12876 |
352 | 352 | 2021-01-17 | 3119526.0 | 40163742.0 | 13630.0 | 14633.0 | 118464.0 | 274717.0 | 2294842.0 | 0.119711 |
331 | 331 | 2020-12-27 | 2319888.0 | 33429457.0 | 26543.0 | 24344.0 | 143527.0 | 272093.0 | 1819815.0 | 0.149517 |
314 | 314 | 2020-12-10 | 1701495.0 | 28614477.0 | 40952.0 | 46934.0 | 354147.0 | 269086.0 | 2145033.0 | 0.125446 |
735 | 735 | 2022-02-04 | 8243997.0 | 141882569.0 | 21673.0 | 33692.0 | 411717.0 | 268886.0 | 2835858.0 | 0.094816 |
330 | 330 | 2020-12-26 | 2293345.0 | 33285930.0 | 34789.0 | 40341.0 | 195804.0 | 267549.0 | 1822181.0 | 0.146829 |
329 | 329 | 2020-12-25 | 2258556.0 | 33090126.0 | 13476.0 | 7586.0 | 39897.0 | 261968.0 | 1836769.0 | 0.142624 |
313 | 313 | 2020-12-09 | 1660543.0 | 28260330.0 | 41782.0 | 48272.0 | 372040.0 | 261031.0 | 2140554.0 | 0.121946 |
696 | 696 | 2021-12-27 | 5264159.0 | 121028876.0 | 76125.0 | 85249.0 | 470061.0 | 258762.0 | 1977631.0 | 0.130844 |
736 | 736 | 2022-02-05 | 8255695.0 | 142009659.0 | 11698.0 | 17613.0 | 127090.0 | 255216.0 | 2791033.0 | 0.091441 |
312 | 312 | 2020-12-08 | 1618761.0 | 27888290.0 | 41488.0 | 47468.0 | 387605.0 | 251542.0 | 2123215.0 | 0.118472 |
353 | 353 | 2021-01-18 | 3143088.0 | 40464613.0 | 23562.0 | 28771.0 | 300871.0 | 250009.0 | 2133508.0 | 0.117182 |
737 | 737 | 2022-02-06 | 8265527.0 | 142112875.0 | 9832.0 | 12882.0 | 103216.0 | 247270.0 | 2763967.0 | 0.089462 |
311 | 311 | 2020-12-07 | 1577273.0 | 27500685.0 | 41222.0 | 46117.0 | 396492.0 | 242118.0 | 2115584.0 | 0.114445 |
354 | 354 | 2021-01-19 | 3170403.0 | 40867037.0 | 27315.0 | 37263.0 | 402424.0 | 236952.0 | 2113102.0 | 0.112135 |
310 | 310 | 2020-12-06 | 1536051.0 | 27104193.0 | 18473.0 | 16216.0 | 122025.0 | 232718.0 | 2092268.0 | 0.111228 |
309 | 309 | 2020-12-05 | 1517578.0 | 26982168.0 | 24526.0 | 26198.0 | 181124.0 | 229326.0 | 2084689.0 | 0.110005 |
355 | 355 | 2021-01-20 | 3195548.0 | 41222378.0 | 25145.0 | 33635.0 | 355341.0 | 224483.0 | 2073562.0 | 0.10826 |
308 | 308 | 2020-12-04 | 1493052.0 | 26801044.0 | 32036.0 | 37881.0 | 331600.0 | 223382.0 | 2058869.0 | 0.108497 |
738 | 738 | 2022-02-07 | 8287906.0 | 142657342.0 | 22379.0 | 34252.0 | 544467.0 | 222371.0 | 2692385.0 | 0.082593 |
356 | 356 | 2021-01-21 | 3217571.0 | 41574802.0 | 22023.0 | 31897.0 | 352424.0 | 212018.0 | 2040673.0 | 0.103896 |
307 | 307 | 2020-12-03 | 1461016.0 | 26469444.0 | 32012.0 | 38879.0 | 349668.0 | 202618.0 | 1877102.0 | 0.107942 |
739 | 739 | 2022-02-08 | 8305820.0 | 143125663.0 | 17914.0 | 26630.0 | 468321.0 | 202002.0 | 2638046.0 | 0.076573 |
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 );