home / la-times

Menu
  • GraphQL API

cdph-positive-test-rate

Table actions
  • GraphQL API for cdph-positive-test-rate

All of the data used by The Times to estimate how many recent tests have come back positive. The daily tallies of new cases and tests are drawn from cdph-state-totals.csv.

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

✎ View and edit SQL

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      
7 7 2020-02-07 82.0 911.0 31.0 62.0 453.0 77.0 911.0 0.084523
8 8 2020-02-08 89.0 970.0 7.0 2.0 59.0 70.0 666.0 0.105105
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
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
15 15 2020-02-15 130.0 1124.0 12.0 1.0 43.0 3.0 154.0 0.019481
16 16 2020-02-16 137.0 1188.0 7.0 2.0 64.0 4.0 197.0 0.020305
17 17 2020-02-17 150.0 1273.0 13.0 0.0 85.0 3.0 266.0 0.011278
18 18 2020-02-18 160.0 1290.0 10.0 1.0 17.0 4.0 243.0 0.016461
19 19 2020-02-19 172.0 1300.0 12.0 0.0 10.0 4.0 250.0 0.016
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
22 22 2020-02-22 229.0 1372.0 17.0 0.0 27.0 7.0 248.0 0.028226
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
25 25 2020-02-25 312.0 1441.0 25.0 1.0 12.0 11.0 151.0 0.072848
26 26 2020-02-26 351.0 1465.0 39.0 3.0 24.0 14.0 165.0 0.084848
27 27 2020-02-27 377.0 1543.0 26.0 9.0 78.0 21.0 217.0 0.096774
28 28 2020-02-28 426.0 1664.0 49.0 17.0 121.0 36.0 319.0 0.112853
29 29 2020-02-29 467.0 1753.0 41.0 16.0 89.0 52.0 381.0 0.136483
30 30 2020-03-01 566.0 1832.0 99.0 4.0 79.0 53.0 423.0 0.125296
31 31 2020-03-02 642.0 2009.0 76.0 33.0 177.0 83.0 580.0 0.143103
32 32 2020-03-03 727.0 2154.0 85.0 25.0 145.0 107.0 713.0 0.15007
33 33 2020-03-04 822.0 2391.0 95.0 39.0 237.0 143.0 926.0 0.154428
34 34 2020-03-05 933.0 2758.0 111.0 36.0 367.0 170.0 1215.0 0.139918
35 35 2020-03-06 1092.0 3169.0 159.0 31.0 411.0 184.0 1505.0 0.122259
36 36 2020-03-07 1256.0 3675.0 164.0 76.0 506.0 244.0 1922.0 0.126951
37 37 2020-03-08 1437.0 3996.0 181.0 51.0 321.0 291.0 2164.0 0.134473
38 38 2020-03-09 1769.0 5025.0 332.0 130.0 1029.0 388.0 3016.0 0.128647
39 39 2020-03-10 2126.0 6211.0 357.0 124.0 1186.0 487.0 4057.0 0.120039
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
42 42 2020-03-13 3646.0 16004.0 583.0 332.0 4475.0 1121.0 12835.0 0.087339
43 43 2020-03-14 4160.0 18787.0 514.0 312.0 2783.0 1357.0 15112.0 0.089796
44 44 2020-03-15 4762.0 21554.0 602.0 255.0 2767.0 1561.0 17558.0 0.088905
45 45 2020-03-16 5643.0 29329.0 881.0 579.0 7775.0 2010.0 24304.0 0.082702
46 46 2020-03-17 6482.0 38271.0 839.0 653.0 8942.0 2539.0 32060.0 0.079195
47 47 2020-03-18 7261.0 47197.0 779.0 616.0 8926.0 2985.0 39127.0 0.07629
48 48 2020-03-19 8048.0 56223.0 787.0 663.0 9026.0 3410.0 44694.0 0.076297
49 49 2020-03-20 9013.0 66257.0 965.0 769.0 10034.0 3847.0 50253.0 0.076553
50 50 2020-03-21 9707.0 71341.0 694.0 478.0 5084.0 4013.0 52554.0 0.07636
51 51 2020-03-22 10474.0 75982.0 767.0 608.0 4641.0 4366.0 54428.0 0.080216
52 52 2020-03-23 11515.0 88563.0 1041.0 1212.0 12581.0 4999.0 59234.0 0.084394
53 53 2020-03-24 12365.0 100502.0 850.0 1206.0 11939.0 5552.0 62231.0 0.089216
54 54 2020-03-25 13410.0 112228.0 1045.0 1207.0 11726.0 6143.0 65031.0 0.094463
55 55 2020-03-26 14382.0 124016.0 972.0 1184.0 11788.0 6664.0 67793.0 0.098299
56 56 2020-03-27 15385.0 136591.0 1003.0 1317.0 12575.0 7212.0 70334.0 0.102539
57 57 2020-03-28 16322.0 144590.0 937.0 1037.0 7999.0 7771.0 73249.0 0.10609
58 58 2020-03-29 17145.0 149833.0 823.0 698.0 5243.0 7861.0 73851.0 0.106444
59 59 2020-03-30 18529.0 163798.0 1384.0 1610.0 13965.0 8259.0 75235.0 0.109776
60 60 2020-03-31 19789.0 177543.0 1260.0 1554.0 13745.0 8607.0 77041.0 0.11172
61 61 2020-04-01 21296.0 192518.0 1507.0 1762.0 14975.0 9162.0 80290.0 0.114111
62 62 2020-04-02 22664.0 207627.0 1368.0 1695.0 15109.0 9673.0 83611.0 0.115691
63 63 2020-04-03 24181.0 222940.0 1517.0 1536.0 15313.0 9892.0 86349.0 0.114558
64 64 2020-04-04 25307.0 230950.0 1126.0 1078.0 8010.0 9933.0 86360.0 0.115019
65 65 2020-04-05 26447.0 237027.0 1140.0 985.0 6077.0 10220.0 87194.0 0.11721
66 66 2020-04-06 27803.0 250717.0 1356.0 1543.0 13690.0 10153.0 86919.0 0.11681
67 67 2020-04-07 29222.0 265951.0 1419.0 1774.0 15234.0 10373.0 88408.0 0.117331
68 68 2020-04-08 30688.0 281934.0 1466.0 1774.0 15983.0 10385.0 89416.0 0.116143
69 69 2020-04-09 32085.0 299804.0 1397.0 1761.0 17870.0 10451.0 92177.0 0.11338
70 70 2020-04-10 33558.0 317952.0 1473.0 1699.0 18148.0 10614.0 95012.0 0.111712
71 71 2020-04-11 34609.0 327153.0 1051.0 1072.0 9201.0 10608.0 96203.0 0.110267
72 72 2020-04-12 35609.0 332902.0 1000.0 736.0 5749.0 10359.0 95875.0 0.108047
73 73 2020-04-13 37129.0 348220.0 1520.0 1914.0 15318.0 10730.0 97503.0 0.110048
74 74 2020-04-14 38625.0 364937.0 1496.0 1756.0 16717.0 10712.0 98986.0 0.108217
75 75 2020-04-15 40287.0 384838.0 1662.0 1982.0 19901.0 10920.0 102904.0 0.106118
76 76 2020-04-16 41962.0 404515.0 1675.0 1878.0 19677.0 11037.0 104711.0 0.105404
77 77 2020-04-17 43569.0 425248.0 1607.0 1741.0 20733.0 11079.0 107296.0 0.103256
78 78 2020-04-18 44775.0 438232.0 1206.0 1273.0 12984.0 11280.0 111079.0 0.101549
79 79 2020-04-19 45856.0 446897.0 1081.0 901.0 8665.0 11445.0 113995.0 0.100399
80 80 2020-04-20 47776.0 469049.0 1920.0 2179.0 22152.0 11710.0 120829.0 0.096914
81 81 2020-04-21 49448.0 494305.0 1672.0 2029.0 25256.0 11983.0 129368.0 0.092627
82 82 2020-04-22 51212.0 518404.0 1764.0 2026.0 24099.0 12027.0 133566.0 0.090045
83 83 2020-04-23 53054.0 543894.0 1842.0 2142.0 25490.0 12291.0 139379.0 0.088184
84 84 2020-04-24 55064.0 573572.0 2010.0 2328.0 29678.0 12878.0 148324.0 0.086823
85 85 2020-04-25 56682.0 593520.0 1618.0 1711.0 19948.0 13316.0 155288.0 0.08575
86 86 2020-04-26 57952.0 605026.0 1270.0 1014.0 11506.0 13429.0 158129.0 0.084924
87 87 2020-04-27 60202.0 639846.0 2250.0 2746.0 34820.0 13996.0 170797.0 0.081945
88 88 2020-04-28 62305.0 675457.0 2103.0 2555.0 35611.0 14522.0 181152.0 0.080165
89 89 2020-04-29 64341.0 711372.0 2036.0 2406.0 35915.0 14902.0 192968.0 0.077225
90 90 2020-04-30 66279.0 752354.0 1938.0 2359.0 40982.0 15119.0 208460.0 0.072527
91 91 2020-05-01 68510.0 797419.0 2231.0 2361.0 45065.0 15152.0 223847.0 0.067689
92 92 2020-05-02 69899.0 824063.0 1389.0 1380.0 26644.0 14821.0 230543.0 0.064287
93 93 2020-05-03 71050.0 839651.0 1151.0 1050.0 15588.0 14857.0 234625.0 0.063322
94 94 2020-05-04 73450.0 884934.0 2400.0 2708.0 45283.0 14819.0 245088.0 0.060464
95 95 2020-05-05 76031.0 933158.0 2581.0 2971.0 48224.0 15235.0 257701.0 0.059119
96 96 2020-05-06 78376.0 989516.0 2345.0 2904.0 56358.0 15733.0 278144.0 0.056564
97 97 2020-05-07 80521.0 1043018.0 2145.0 2558.0 53502.0 15932.0 290664.0 0.054812
98 98 2020-05-08 82791.0 1096280.0 2270.0 2583.0 53262.0 16154.0 298861.0 0.054052
99 99 2020-05-09 84375.0 1123746.0 1584.0 1578.0 27466.0 16352.0 299683.0 0.054564
100 100 2020-05-10 85702.0 1138617.0 1327.0 924.0 14871.0 16226.0 298966.0 0.054274

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);
Powered by Datasette · Queries took 27.613ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README