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)
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 |
---|---|---|---|---|---|---|---|---|---|---|
960 | 960 | 2022-09-17 | 10404360.0 | 185383497.0 | 2771.0 | 3166.0 | 45822.0 | 35226.0 | 695541.0 | 0.050645 |
959 | 959 | 2022-09-16 | 10401589.0 | 185337675.0 | 3809.0 | 4840.0 | 96506.0 | 35882.0 | 694259.0 | 0.051684 |
958 | 958 | 2022-09-15 | 10397780.0 | 185241169.0 | 4047.0 | 5101.0 | 115716.0 | 36939.0 | 698519.0 | 0.052882 |
957 | 957 | 2022-09-14 | 10393733.0 | 185125453.0 | 4429.0 | 5568.0 | 116808.0 | 38303.0 | 701083.0 | 0.054634 |
956 | 956 | 2022-09-13 | 10389304.0 | 185008645.0 | 4987.0 | 6143.0 | 136161.0 | 40197.0 | 711028.0 | 0.056534 |
955 | 955 | 2022-09-12 | 10384317.0 | 184872484.0 | 5699.0 | 7086.0 | 143797.0 | 44301.0 | 754890.0 | 0.058685 |
954 | 954 | 2022-09-11 | 10378618.0 | 184728687.0 | 3043.0 | 3322.0 | 40731.0 | 40667.0 | 664451.0 | 0.061204 |
953 | 953 | 2022-09-10 | 10375575.0 | 184687956.0 | 3263.0 | 3822.0 | 44540.0 | 41113.0 | 662307.0 | 0.062075 |
952 | 952 | 2022-09-09 | 10372312.0 | 184643416.0 | 4829.0 | 5897.0 | 100766.0 | 41650.0 | 660506.0 | 0.063058 |
951 | 951 | 2022-09-08 | 10367483.0 | 184542650.0 | 5301.0 | 6465.0 | 118280.0 | 42807.0 | 657562.0 | 0.0651 |
950 | 950 | 2022-09-07 | 10362182.0 | 184424370.0 | 5970.0 | 7462.0 | 126753.0 | 44123.0 | 659190.0 | 0.066935 |
949 | 949 | 2022-09-06 | 10356212.0 | 184297617.0 | 7813.0 | 10247.0 | 180023.0 | 45502.0 | 661134.0 | 0.068824 |
948 | 948 | 2022-09-05 | 10348399.0 | 184117594.0 | 3321.0 | 3452.0 | 53358.0 | 45007.0 | 629982.0 | 0.071442 |
947 | 947 | 2022-09-04 | 10345078.0 | 184064236.0 | 3160.0 | 3768.0 | 38587.0 | 53020.0 | 736730.0 | 0.071967 |
946 | 946 | 2022-09-03 | 10341918.0 | 184025649.0 | 3546.0 | 4359.0 | 42739.0 | 54378.0 | 742765.0 | 0.07321 |
945 | 945 | 2022-09-02 | 10338372.0 | 183982910.0 | 5444.0 | 7054.0 | 97822.0 | 56038.0 | 750394.0 | 0.074678 |
944 | 944 | 2022-09-01 | 10332928.0 | 183885088.0 | 6222.0 | 7781.0 | 119908.0 | 58408.0 | 764162.0 | 0.076434 |
943 | 943 | 2022-08-31 | 10326706.0 | 183765180.0 | 6873.0 | 8841.0 | 128697.0 | 60167.0 | 766290.0 | 0.078517 |
942 | 942 | 2022-08-30 | 10319833.0 | 183636483.0 | 7685.0 | 9752.0 | 148871.0 | 62113.0 | 768355.0 | 0.080839 |
941 | 941 | 2022-08-29 | 10312148.0 | 183487612.0 | 9015.0 | 11465.0 | 160106.0 | 64298.0 | 768119.0 | 0.083708 |
940 | 940 | 2022-08-28 | 10303133.0 | 183327506.0 | 4475.0 | 5126.0 | 44622.0 | 66760.0 | 773993.0 | 0.086254 |
939 | 939 | 2022-08-27 | 10298658.0 | 183282884.0 | 4818.0 | 6019.0 | 50368.0 | 67697.0 | 775155.0 | 0.087334 |
938 | 938 | 2022-08-26 | 10293840.0 | 183232516.0 | 7357.0 | 9424.0 | 111590.0 | 68764.0 | 776253.0 | 0.088585 |
937 | 937 | 2022-08-25 | 10286483.0 | 183120926.0 | 7619.0 | 9540.0 | 122036.0 | 70241.0 | 776293.0 | 0.090483 |
936 | 936 | 2022-08-24 | 10278864.0 | 182998890.0 | 8465.0 | 10787.0 | 130762.0 | 72133.0 | 781492.0 | 0.092302 |
935 | 935 | 2022-08-23 | 10270399.0 | 182868128.0 | 9508.0 | 11937.0 | 148635.0 | 73636.0 | 780335.0 | 0.094365 |
934 | 934 | 2022-08-22 | 10260891.0 | 182719493.0 | 11034.0 | 13927.0 | 165980.0 | 75306.0 | 779138.0 | 0.096653 |
933 | 933 | 2022-08-21 | 10249857.0 | 182553513.0 | 5411.0 | 6063.0 | 45784.0 | 76396.0 | 776843.0 | 0.098342 |
932 | 932 | 2022-08-20 | 10244446.0 | 182507729.0 | 6046.0 | 7086.0 | 51466.0 | 77403.0 | 777445.0 | 0.099561 |
931 | 931 | 2022-08-19 | 10238400.0 | 182456263.0 | 8394.0 | 10901.0 | 111630.0 | 78434.0 | 777864.0 | 0.100833 |
930 | 930 | 2022-08-18 | 10230006.0 | 182344633.0 | 9054.0 | 11432.0 | 127235.0 | 80101.0 | 780979.0 | 0.102565 |
929 | 929 | 2022-08-17 | 10220952.0 | 182217398.0 | 9910.0 | 12290.0 | 129605.0 | 81987.0 | 786654.0 | 0.104222 |
928 | 928 | 2022-08-16 | 10211042.0 | 182087793.0 | 10992.0 | 13607.0 | 147438.0 | 84458.0 | 791412.0 | 0.106718 |
927 | 927 | 2022-08-15 | 10200050.0 | 181940355.0 | 12000.0 | 15017.0 | 163685.0 | 86527.0 | 795295.0 | 0.108799 |
926 | 926 | 2022-08-14 | 10188050.0 | 181776670.0 | 6163.0 | 7070.0 | 46386.0 | 89821.0 | 799637.0 | 0.112327 |
925 | 925 | 2022-08-13 | 10181887.0 | 181730284.0 | 6586.0 | 8117.0 | 51885.0 | 90770.0 | 801296.0 | 0.113279 |
924 | 924 | 2022-08-12 | 10175301.0 | 181678399.0 | 9660.0 | 12568.0 | 114745.0 | 92156.0 | 805062.0 | 0.114471 |
923 | 923 | 2022-08-11 | 10165641.0 | 181563654.0 | 10361.0 | 13318.0 | 132910.0 | 94792.0 | 809896.0 | 0.117042 |
922 | 922 | 2022-08-10 | 10155280.0 | 181430744.0 | 11357.0 | 14761.0 | 134363.0 | 96979.0 | 808255.0 | 0.119986 |
921 | 921 | 2022-08-09 | 10143923.0 | 181296381.0 | 12327.0 | 15676.0 | 151321.0 | 99450.0 | 815888.0 | 0.121892 |
920 | 920 | 2022-08-08 | 10131596.0 | 181145060.0 | 14569.0 | 18311.0 | 168027.0 | 102581.0 | 824393.0 | 0.124432 |
919 | 919 | 2022-08-07 | 10117027.0 | 180977033.0 | 7169.0 | 8019.0 | 48045.0 | 105787.0 | 830340.0 | 0.127402 |
918 | 918 | 2022-08-06 | 10109858.0 | 180928988.0 | 7992.0 | 9503.0 | 55651.0 | 107298.0 | 834075.0 | 0.128643 |
917 | 917 | 2022-08-05 | 10101866.0 | 180873337.0 | 11687.0 | 15204.0 | 119579.0 | 109301.0 | 839553.0 | 0.13019 |
916 | 916 | 2022-08-04 | 10090179.0 | 180753758.0 | 12302.0 | 15505.0 | 131269.0 | 112595.0 | 846166.0 | 0.133065 |
915 | 915 | 2022-08-03 | 10077877.0 | 180622489.0 | 13742.0 | 17232.0 | 141996.0 | 116125.0 | 859147.0 | 0.135163 |
914 | 914 | 2022-08-02 | 10064135.0 | 180480493.0 | 15328.0 | 18807.0 | 159826.0 | 120033.0 | 870932.0 | 0.137821 |
913 | 913 | 2022-08-01 | 10048807.0 | 180320667.0 | 17667.0 | 21517.0 | 173974.0 | 124458.0 | 883283.0 | 0.140904 |
912 | 912 | 2022-07-31 | 10031140.0 | 180146693.0 | 8217.0 | 9530.0 | 51780.0 | 129824.0 | 897114.0 | 0.144713 |
911 | 911 | 2022-07-30 | 10022923.0 | 180094913.0 | 9261.0 | 11506.0 | 61129.0 | 131438.0 | 901836.0 | 0.145745 |
910 | 910 | 2022-07-29 | 10013662.0 | 180033784.0 | 13904.0 | 18498.0 | 126192.0 | 133559.0 | 908496.0 | 0.147011 |
909 | 909 | 2022-07-28 | 9999758.0 | 179907592.0 | 15061.0 | 19035.0 | 144250.0 | 137149.0 | 920068.0 | 0.149064 |
908 | 908 | 2022-07-27 | 9984697.0 | 179763342.0 | 16689.0 | 21140.0 | 153781.0 | 140370.0 | 931651.0 | 0.150668 |
907 | 907 | 2022-07-26 | 9968008.0 | 179609561.0 | 18611.0 | 23232.0 | 172177.0 | 143604.0 | 943293.0 | 0.152237 |
906 | 906 | 2022-07-25 | 9949397.0 | 179437384.0 | 21299.0 | 26883.0 | 187805.0 | 146348.0 | 957457.0 | 0.152851 |
905 | 905 | 2022-07-24 | 9928098.0 | 179249579.0 | 9884.0 | 11144.0 | 56502.0 | 148835.0 | 971324.0 | 0.153229 |
904 | 904 | 2022-07-23 | 9918214.0 | 179193077.0 | 11336.0 | 13627.0 | 67789.0 | 150221.0 | 975185.0 | 0.154044 |
903 | 903 | 2022-07-22 | 9906878.0 | 179125288.0 | 17148.0 | 22088.0 | 137764.0 | 151931.0 | 980241.0 | 0.154994 |
902 | 902 | 2022-07-21 | 9889730.0 | 178987524.0 | 17716.0 | 22256.0 | 155833.0 | 153992.0 | 988073.0 | 0.155851 |
901 | 901 | 2022-07-20 | 9872014.0 | 178831691.0 | 19456.0 | 24374.0 | 165423.0 | 156203.0 | 995395.0 | 0.156926 |
900 | 900 | 2022-07-19 | 9852558.0 | 178666268.0 | 21175.0 | 25976.0 | 186341.0 | 157872.0 | 999411.0 | 0.157965 |
899 | 899 | 2022-07-18 | 9831383.0 | 178479927.0 | 23467.0 | 29370.0 | 201672.0 | 159753.0 | 1001961.0 | 0.15944 |
898 | 898 | 2022-07-17 | 9807916.0 | 178278255.0 | 11050.0 | 12530.0 | 60363.0 | 160936.0 | 1004540.0 | 0.160209 |
897 | 897 | 2022-07-16 | 9796866.0 | 178217892.0 | 12897.0 | 15337.0 | 72845.0 | 161334.0 | 1004756.0 | 0.16057 |
896 | 896 | 2022-07-15 | 9783969.0 | 178145047.0 | 18827.0 | 24149.0 | 145596.0 | 161788.0 | 1005765.0 | 0.160861 |
895 | 895 | 2022-07-14 | 9765142.0 | 177999451.0 | 19933.0 | 24467.0 | 163155.0 | 162761.0 | 1016107.0 | 0.160181 |
894 | 894 | 2022-07-13 | 9745209.0 | 177836296.0 | 21231.0 | 26043.0 | 169439.0 | 164699.0 | 1025693.0 | 0.160573 |
893 | 893 | 2022-07-12 | 9723978.0 | 177666857.0 | 22458.0 | 27857.0 | 188891.0 | 166840.0 | 1041650.0 | 0.160169 |
892 | 892 | 2022-07-11 | 9701520.0 | 177477966.0 | 24510.0 | 30553.0 | 204251.0 | 172971.0 | 1092389.0 | 0.158342 |
891 | 891 | 2022-07-10 | 9677010.0 | 177273715.0 | 11665.0 | 12928.0 | 60579.0 | 151107.0 | 947316.0 | 0.159511 |
890 | 890 | 2022-07-09 | 9665345.0 | 177213136.0 | 13492.0 | 15791.0 | 73854.0 | 148590.0 | 938142.0 | 0.158388 |
889 | 889 | 2022-07-08 | 9651853.0 | 177139282.0 | 20197.0 | 25122.0 | 155938.0 | 146180.0 | 930543.0 | 0.157091 |
888 | 888 | 2022-07-07 | 9631656.0 | 176983344.0 | 21182.0 | 26405.0 | 172741.0 | 143065.0 | 912217.0 | 0.156832 |
887 | 887 | 2022-07-06 | 9610474.0 | 176810603.0 | 23064.0 | 28184.0 | 185396.0 | 139617.0 | 906598.0 | 0.154001 |
886 | 886 | 2022-07-05 | 9587410.0 | 176625207.0 | 27228.0 | 33988.0 | 239630.0 | 136101.0 | 892043.0 | 0.152572 |
885 | 885 | 2022-07-04 | 9560182.0 | 176385577.0 | 10063.0 | 8689.0 | 59178.0 | 127688.0 | 844383.0 | 0.15122 |
884 | 884 | 2022-07-03 | 9550119.0 | 176326399.0 | 9881.0 | 10411.0 | 51405.0 | 146504.0 | 992125.0 | 0.147667 |
883 | 883 | 2022-07-02 | 9540238.0 | 176274994.0 | 11457.0 | 13381.0 | 66255.0 | 147589.0 | 1002809.0 | 0.147176 |
882 | 882 | 2022-07-01 | 9528781.0 | 176208739.0 | 17977.0 | 22007.0 | 137612.0 | 147734.0 | 1009538.0 | 0.146338 |
881 | 881 | 2022-06-30 | 9510804.0 | 176071127.0 | 18187.0 | 22957.0 | 167122.0 | 146065.0 | 1021879.0 | 0.142938 |
880 | 880 | 2022-06-29 | 9492617.0 | 175904005.0 | 19840.0 | 24668.0 | 170841.0 | 144586.0 | 1027106.0 | 0.14077 |
879 | 879 | 2022-06-28 | 9472777.0 | 175733164.0 | 21066.0 | 25575.0 | 191970.0 | 141343.0 | 1033090.0 | 0.136816 |
878 | 878 | 2022-06-27 | 9451711.0 | 175541194.0 | 22580.0 | 27505.0 | 206920.0 | 139829.0 | 1053161.0 | 0.132771 |
877 | 877 | 2022-06-26 | 9429131.0 | 175334274.0 | 10805.0 | 11496.0 | 62089.0 | 134298.0 | 1029441.0 | 0.130457 |
876 | 876 | 2022-06-25 | 9418326.0 | 175272185.0 | 11602.0 | 13526.0 | 72984.0 | 132788.0 | 1026508.0 | 0.129359 |
875 | 875 | 2022-06-24 | 9406724.0 | 175199201.0 | 16338.0 | 20338.0 | 149953.0 | 131166.0 | 1026893.0 | 0.127731 |
874 | 874 | 2022-06-23 | 9390386.0 | 175049248.0 | 17136.0 | 21478.0 | 172349.0 | 129679.0 | 1032266.0 | 0.125626 |
873 | 873 | 2022-06-22 | 9373250.0 | 174876899.0 | 17841.0 | 21425.0 | 176825.0 | 127132.0 | 1035293.0 | 0.122798 |
872 | 872 | 2022-06-21 | 9355409.0 | 174700074.0 | 19414.0 | 24061.0 | 212041.0 | 125896.0 | 1039675.0 | 0.121092 |
871 | 871 | 2022-06-20 | 9335995.0 | 174488033.0 | 18275.0 | 21974.0 | 183200.0 | 122656.0 | 1034695.0 | 0.118543 |
870 | 870 | 2022-06-19 | 9317720.0 | 174304833.0 | 9334.0 | 9986.0 | 59156.0 | 123507.0 | 1073722.0 | 0.115027 |
869 | 869 | 2022-06-18 | 9308386.0 | 174245677.0 | 10320.0 | 11904.0 | 73369.0 | 122950.0 | 1078284.0 | 0.114024 |
868 | 868 | 2022-06-17 | 9298066.0 | 174172308.0 | 14873.0 | 18851.0 | 155326.0 | 122519.0 | 1080452.0 | 0.113396 |
867 | 867 | 2022-06-16 | 9283193.0 | 174016982.0 | 15325.0 | 18931.0 | 175376.0 | 123343.0 | 1134590.0 | 0.108712 |
866 | 866 | 2022-06-15 | 9267868.0 | 173841606.0 | 16371.0 | 20189.0 | 181207.0 | 124559.0 | 1210379.0 | 0.102909 |
865 | 865 | 2022-06-14 | 9251497.0 | 173660399.0 | 16916.0 | 20821.0 | 207061.0 | 126799.0 | 1314382.0 | 0.09647 |
864 | 864 | 2022-06-13 | 9234581.0 | 173453338.0 | 18546.0 | 22825.0 | 222227.0 | 129129.0 | 1414823.0 | 0.091269 |
863 | 863 | 2022-06-12 | 9216035.0 | 173231111.0 | 8926.0 | 9429.0 | 63718.0 | 132109.0 | 1533879.0 | 0.086127 |
862 | 862 | 2022-06-11 | 9207109.0 | 173167393.0 | 9900.0 | 11473.0 | 75537.0 | 133043.0 | 1538983.0 | 0.086449 |
861 | 861 | 2022-06-10 | 9197209.0 | 173091856.0 | 15384.0 | 19675.0 | 209464.0 | 133851.0 | 1546136.0 | 0.086571 |
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 );