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 rowid 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 |
---|---|---|---|---|---|---|---|---|---|---|
1060 | 1060 | 2022-12-26 | 10887571.0 | 193110661.0 | 1624.0 | 1739.0 | 13042.0 | 33777.0 | 283696.0 | 0.119061 |
1059 | 1059 | 2022-12-25 | 10885947.0 | 193097619.0 | 1536.0 | 1368.0 | 11205.0 | 42556.0 | 372185.0 | 0.114341 |
1058 | 1058 | 2022-12-24 | 10884411.0 | 193086414.0 | 2720.0 | 2570.0 | 19613.0 | 45699.0 | 396989.0 | 0.115114 |
1057 | 1057 | 2022-12-23 | 10881691.0 | 193066801.0 | 5462.0 | 5277.0 | 40001.0 | 48367.0 | 417332.0 | 0.115896 |
1056 | 1056 | 2022-12-22 | 10876229.0 | 193026800.0 | 6228.0 | 6108.0 | 50891.0 | 51048.0 | 455455.0 | 0.112081 |
1055 | 1055 | 2022-12-21 | 10870001.0 | 192975909.0 | 7078.0 | 7464.0 | 63524.0 | 53614.0 | 492194.0 | 0.108929 |
1054 | 1054 | 2022-12-20 | 10862923.0 | 192912385.0 | 8110.0 | 9251.0 | 85420.0 | 55756.0 | 519573.0 | 0.107311 |
1053 | 1053 | 2022-12-19 | 10854813.0 | 192826965.0 | 8916.0 | 10518.0 | 101531.0 | 56796.0 | 542282.0 | 0.104735 |
1052 | 1052 | 2022-12-18 | 10845897.0 | 192725434.0 | 4067.0 | 4511.0 | 36009.0 | 58340.0 | 563073.0 | 0.10361 |
1051 | 1051 | 2022-12-17 | 10841830.0 | 192689425.0 | 4616.0 | 5238.0 | 39956.0 | 58855.0 | 565667.0 | 0.104045 |
1050 | 1050 | 2022-12-16 | 10837214.0 | 192649469.0 | 6557.0 | 7958.0 | 78124.0 | 59444.0 | 569692.0 | 0.104344 |
1049 | 1049 | 2022-12-15 | 10830657.0 | 192571345.0 | 7211.0 | 8674.0 | 87630.0 | 60919.0 | 574377.0 | 0.106061 |
1048 | 1048 | 2022-12-14 | 10823446.0 | 192483715.0 | 7936.0 | 9606.0 | 90903.0 | 62066.0 | 581333.0 | 0.106765 |
1047 | 1047 | 2022-12-13 | 10815510.0 | 192392812.0 | 8589.0 | 10291.0 | 108129.0 | 63044.0 | 588388.0 | 0.107147 |
1046 | 1046 | 2022-12-12 | 10806921.0 | 192284683.0 | 10091.0 | 12062.0 | 122322.0 | 64464.0 | 595231.0 | 0.108301 |
1045 | 1045 | 2022-12-11 | 10796830.0 | 192162361.0 | 4723.0 | 5026.0 | 38603.0 | 65965.0 | 602804.0 | 0.10943 |
1044 | 1044 | 2022-12-10 | 10792107.0 | 192123758.0 | 5343.0 | 5827.0 | 43981.0 | 66982.0 | 605857.0 | 0.110557 |
1043 | 1043 | 2022-12-09 | 10786764.0 | 192079777.0 | 7844.0 | 9433.0 | 82809.0 | 67663.0 | 607573.0 | 0.111366 |
1042 | 1042 | 2022-12-08 | 10778920.0 | 191996968.0 | 8307.0 | 9821.0 | 94586.0 | 68472.0 | 614505.0 | 0.111426 |
1041 | 1041 | 2022-12-07 | 10770613.0 | 191902382.0 | 8948.0 | 10584.0 | 97958.0 | 69730.0 | 619621.0 | 0.112537 |
1040 | 1040 | 2022-12-06 | 10761665.0 | 191804424.0 | 9913.0 | 11711.0 | 114972.0 | 71739.0 | 628310.0 | 0.114178 |
1039 | 1039 | 2022-12-05 | 10751752.0 | 191689452.0 | 11570.0 | 13563.0 | 129895.0 | 73362.0 | 637477.0 | 0.115082 |
1038 | 1038 | 2022-12-04 | 10740182.0 | 191559557.0 | 5741.0 | 6043.0 | 41656.0 | 75917.0 | 652960.0 | 0.116266 |
1037 | 1037 | 2022-12-03 | 10734441.0 | 191517901.0 | 6105.0 | 6508.0 | 45697.0 | 76407.0 | 657950.0 | 0.116129 |
1036 | 1036 | 2022-12-02 | 10728336.0 | 191472204.0 | 8827.0 | 10242.0 | 89741.0 | 76451.0 | 661927.0 | 0.115498 |
1035 | 1035 | 2022-12-01 | 10719509.0 | 191382463.0 | 9986.0 | 11079.0 | 99702.0 | 74078.0 | 633518.0 | 0.116931 |
1034 | 1034 | 2022-11-30 | 10709523.0 | 191282761.0 | 10823.0 | 12593.0 | 106647.0 | 65426.0 | 559321.0 | 0.116974 |
1033 | 1033 | 2022-11-29 | 10698700.0 | 191176114.0 | 11918.0 | 13334.0 | 124139.0 | 61108.0 | 536839.0 | 0.113829 |
1032 | 1032 | 2022-11-28 | 10686782.0 | 191051975.0 | 14297.0 | 16118.0 | 145378.0 | 56413.0 | 508227.0 | 0.111 |
1031 | 1031 | 2022-11-27 | 10672485.0 | 190906597.0 | 6966.0 | 6533.0 | 46646.0 | 49527.0 | 466683.0 | 0.106126 |
1030 | 1030 | 2022-11-26 | 10665519.0 | 190859951.0 | 6636.0 | 6552.0 | 49674.0 | 46955.0 | 458451.0 | 0.102421 |
1029 | 1029 | 2022-11-25 | 10658883.0 | 190810277.0 | 7456.0 | 7869.0 | 61332.0 | 44563.0 | 453180.0 | 0.098334 |
1028 | 1028 | 2022-11-24 | 10651427.0 | 190748945.0 | 3200.0 | 2427.0 | 25505.0 | 43411.0 | 476357.0 | 0.091131 |
1027 | 1027 | 2022-11-23 | 10648227.0 | 190723440.0 | 7372.0 | 8275.0 | 84165.0 | 47665.0 | 542726.0 | 0.087825 |
1026 | 1026 | 2022-11-22 | 10640855.0 | 190639275.0 | 7622.0 | 8639.0 | 95527.0 | 45877.0 | 555359.0 | 0.082608 |
1025 | 1025 | 2022-11-21 | 10633233.0 | 190543748.0 | 8219.0 | 9232.0 | 103834.0 | 44150.0 | 569796.0 | 0.077484 |
1024 | 1024 | 2022-11-20 | 10625014.0 | 190439914.0 | 4064.0 | 3961.0 | 38414.0 | 42389.0 | 585001.0 | 0.07246 |
1023 | 1023 | 2022-11-19 | 10620950.0 | 190401500.0 | 4061.0 | 4160.0 | 44403.0 | 41660.0 | 586450.0 | 0.071038 |
1022 | 1022 | 2022-11-18 | 10616889.0 | 190357097.0 | 5768.0 | 6717.0 | 84509.0 | 40910.0 | 584895.0 | 0.069944 |
1021 | 1021 | 2022-11-17 | 10611121.0 | 190272588.0 | 5801.0 | 6681.0 | 91874.0 | 38681.0 | 567692.0 | 0.068137 |
1020 | 1020 | 2022-11-16 | 10605320.0 | 190180714.0 | 5735.0 | 6487.0 | 96798.0 | 37173.0 | 564094.0 | 0.065899 |
1019 | 1019 | 2022-11-15 | 10599585.0 | 190083916.0 | 5991.0 | 6912.0 | 109964.0 | 35963.0 | 559006.0 | 0.064334 |
1018 | 1018 | 2022-11-14 | 10593594.0 | 189973952.0 | 6571.0 | 7471.0 | 119039.0 | 34139.0 | 548074.0 | 0.062289 |
1017 | 1017 | 2022-11-13 | 10587023.0 | 189854913.0 | 3198.0 | 3232.0 | 39863.0 | 32882.0 | 540882.0 | 0.060793 |
1016 | 1016 | 2022-11-12 | 10583825.0 | 189815050.0 | 3106.0 | 3410.0 | 42848.0 | 32429.0 | 539646.0 | 0.060093 |
1015 | 1015 | 2022-11-11 | 10580719.0 | 189772202.0 | 3899.0 | 4488.0 | 67306.0 | 31773.0 | 537532.0 | 0.059109 |
1014 | 1014 | 2022-11-10 | 10576820.0 | 189704896.0 | 4453.0 | 5173.0 | 88276.0 | 31479.0 | 550180.0 | 0.057216 |
1013 | 1013 | 2022-11-09 | 10572367.0 | 189616620.0 | 4581.0 | 5277.0 | 91710.0 | 30673.0 | 544649.0 | 0.056317 |
1012 | 1012 | 2022-11-08 | 10567786.0 | 189524910.0 | 4504.0 | 5088.0 | 99032.0 | 29828.0 | 542822.0 | 0.05495 |
1011 | 1011 | 2022-11-07 | 10563282.0 | 189425878.0 | 5406.0 | 6214.0 | 111847.0 | 29218.0 | 545835.0 | 0.053529 |
1010 | 1010 | 2022-11-06 | 10557876.0 | 189314031.0 | 2823.0 | 2779.0 | 38627.0 | 27773.0 | 536860.0 | 0.051732 |
1009 | 1009 | 2022-11-05 | 10555053.0 | 189275404.0 | 2733.0 | 2754.0 | 40734.0 | 27027.0 | 534247.0 | 0.050589 |
1008 | 1008 | 2022-11-04 | 10552320.0 | 189234670.0 | 3636.0 | 4194.0 | 79954.0 | 26607.0 | 531804.0 | 0.050032 |
1007 | 1007 | 2022-11-03 | 10548684.0 | 189154716.0 | 3730.0 | 4367.0 | 82745.0 | 25888.0 | 527637.0 | 0.049064 |
1006 | 1006 | 2022-11-02 | 10544954.0 | 189071971.0 | 3907.0 | 4432.0 | 89883.0 | 25055.0 | 525632.0 | 0.047666 |
1005 | 1005 | 2022-11-01 | 10541047.0 | 188982088.0 | 4242.0 | 4478.0 | 102045.0 | 24218.0 | 522666.0 | 0.046336 |
1004 | 1004 | 2022-10-31 | 10536805.0 | 188880043.0 | 4064.0 | 4769.0 | 102872.0 | 23445.0 | 522851.0 | 0.044841 |
1003 | 1003 | 2022-10-30 | 10532741.0 | 188777171.0 | 2082.0 | 2033.0 | 36014.0 | 22822.0 | 526228.0 | 0.043369 |
1002 | 1002 | 2022-10-29 | 10530659.0 | 188741157.0 | 2128.0 | 2334.0 | 38291.0 | 22538.0 | 523599.0 | 0.043044 |
1001 | 1001 | 2022-10-28 | 10528531.0 | 188702866.0 | 2905.0 | 3475.0 | 75787.0 | 22149.0 | 521008.0 | 0.042512 |
1000 | 1000 | 2022-10-27 | 10525626.0 | 188627079.0 | 3009.0 | 3534.0 | 80740.0 | 21700.0 | 519037.0 | 0.041808 |
999 | 999 | 2022-10-26 | 10522617.0 | 188546339.0 | 3060.0 | 3595.0 | 86917.0 | 21448.0 | 517806.0 | 0.041421 |
998 | 998 | 2022-10-25 | 10519557.0 | 188459422.0 | 3173.0 | 3705.0 | 102230.0 | 21337.0 | 518419.0 | 0.041158 |
997 | 997 | 2022-10-24 | 10516384.0 | 188357192.0 | 3461.0 | 4146.0 | 106249.0 | 21234.0 | 514076.0 | 0.041305 |
996 | 996 | 2022-10-23 | 10512923.0 | 188250943.0 | 1749.0 | 1749.0 | 33385.0 | 21261.0 | 513480.0 | 0.041406 |
995 | 995 | 2022-10-22 | 10511174.0 | 188217558.0 | 1814.0 | 1945.0 | 35700.0 | 21346.0 | 513822.0 | 0.041544 |
994 | 994 | 2022-10-21 | 10509360.0 | 188181858.0 | 2526.0 | 3026.0 | 73816.0 | 21536.0 | 513895.0 | 0.041907 |
993 | 993 | 2022-10-20 | 10506834.0 | 188108042.0 | 2794.0 | 3282.0 | 79509.0 | 21717.0 | 514135.0 | 0.04224 |
992 | 992 | 2022-10-19 | 10504040.0 | 188028533.0 | 2873.0 | 3484.0 | 87530.0 | 21806.0 | 517777.0 | 0.042115 |
991 | 991 | 2022-10-18 | 10501167.0 | 187941003.0 | 3110.0 | 3602.0 | 97887.0 | 21971.0 | 518425.0 | 0.04238 |
990 | 990 | 2022-10-17 | 10498057.0 | 187843116.0 | 3506.0 | 4173.0 | 105653.0 | 22147.0 | 523584.0 | 0.042299 |
989 | 989 | 2022-10-16 | 10494551.0 | 187737463.0 | 1723.0 | 1834.0 | 33727.0 | 21888.0 | 518658.0 | 0.042201 |
988 | 988 | 2022-10-15 | 10492828.0 | 187703736.0 | 1874.0 | 2135.0 | 35773.0 | 22102.0 | 519488.0 | 0.042546 |
987 | 987 | 2022-10-14 | 10490954.0 | 187667963.0 | 2556.0 | 3207.0 | 74056.0 | 22351.0 | 520378.0 | 0.042951 |
986 | 986 | 2022-10-13 | 10488398.0 | 187593907.0 | 2735.0 | 3371.0 | 83151.0 | 22694.0 | 523033.0 | 0.043389 |
985 | 985 | 2022-10-12 | 10485663.0 | 187510756.0 | 2967.0 | 3649.0 | 88178.0 | 22870.0 | 526381.0 | 0.043448 |
984 | 984 | 2022-10-11 | 10482696.0 | 187422578.0 | 3137.0 | 3778.0 | 103046.0 | 23115.0 | 525676.0 | 0.043972 |
983 | 983 | 2022-10-10 | 10479559.0 | 187319532.0 | 3490.0 | 3914.0 | 100727.0 | 23609.0 | 527336.0 | 0.04477 |
982 | 982 | 2022-10-09 | 10476069.0 | 187218805.0 | 1874.0 | 2048.0 | 34557.0 | 24619.0 | 541588.0 | 0.045457 |
981 | 981 | 2022-10-08 | 10474195.0 | 187184248.0 | 2068.0 | 2384.0 | 36663.0 | 24896.0 | 541002.0 | 0.046018 |
980 | 980 | 2022-10-07 | 10472127.0 | 187147585.0 | 2792.0 | 3550.0 | 76711.0 | 25136.0 | 541117.0 | 0.046452 |
979 | 979 | 2022-10-06 | 10469335.0 | 187070874.0 | 2861.0 | 3547.0 | 86499.0 | 25670.0 | 547562.0 | 0.046881 |
978 | 978 | 2022-10-05 | 10466474.0 | 186984375.0 | 3144.0 | 3894.0 | 87473.0 | 26430.0 | 557268.0 | 0.047428 |
977 | 977 | 2022-10-04 | 10463330.0 | 186896902.0 | 3491.0 | 4272.0 | 104706.0 | 27327.0 | 571542.0 | 0.047813 |
976 | 976 | 2022-10-03 | 10459839.0 | 186792196.0 | 4002.0 | 4924.0 | 114979.0 | 27909.0 | 587676.0 | 0.04749 |
975 | 975 | 2022-10-02 | 10455837.0 | 186677217.0 | 2063.0 | 2325.0 | 33971.0 | 28749.0 | 601009.0 | 0.047835 |
974 | 974 | 2022-10-01 | 10453774.0 | 186643246.0 | 2409.0 | 2624.0 | 36778.0 | 29005.0 | 603819.0 | 0.048036 |
973 | 973 | 2022-09-30 | 10451365.0 | 186606468.0 | 3193.0 | 4084.0 | 83156.0 | 29301.0 | 606955.0 | 0.048275 |
972 | 972 | 2022-09-29 | 10448172.0 | 186523312.0 | 3427.0 | 4307.0 | 96205.0 | 29663.0 | 614492.0 | 0.048272 |
971 | 971 | 2022-09-28 | 10444745.0 | 186427107.0 | 3919.0 | 4791.0 | 101747.0 | 29884.0 | 624751.0 | 0.047833 |
970 | 970 | 2022-09-27 | 10440826.0 | 186325360.0 | 4044.0 | 4854.0 | 120840.0 | 29939.0 | 633101.0 | 0.047289 |
969 | 969 | 2022-09-26 | 10436782.0 | 186204520.0 | 4742.0 | 5764.0 | 128312.0 | 30458.0 | 641711.0 | 0.047464 |
968 | 968 | 2022-09-25 | 10432040.0 | 186076208.0 | 2387.0 | 2581.0 | 36781.0 | 30734.0 | 651335.0 | 0.047186 |
967 | 967 | 2022-09-24 | 10429653.0 | 186039427.0 | 2583.0 | 2920.0 | 39914.0 | 30865.0 | 655930.0 | 0.047055 |
966 | 966 | 2022-09-23 | 10427070.0 | 185999513.0 | 3487.0 | 4446.0 | 90693.0 | 31111.0 | 661838.0 | 0.047007 |
965 | 965 | 2022-09-22 | 10423583.0 | 185908820.0 | 3707.0 | 4528.0 | 106464.0 | 31505.0 | 667651.0 | 0.047188 |
964 | 964 | 2022-09-21 | 10419876.0 | 185802356.0 | 3871.0 | 4846.0 | 110097.0 | 32078.0 | 676903.0 | 0.047389 |
963 | 963 | 2022-09-20 | 10416005.0 | 185692259.0 | 4296.0 | 5373.0 | 129450.0 | 32800.0 | 683614.0 | 0.04798 |
962 | 962 | 2022-09-19 | 10411709.0 | 185562809.0 | 4850.0 | 6040.0 | 137936.0 | 33570.0 | 690325.0 | 0.048629 |
961 | 961 | 2022-09-18 | 10406859.0 | 185424873.0 | 2499.0 | 2712.0 | 41376.0 | 34616.0 | 696186.0 | 0.049722 |
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 );