,Backfill Analysis,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,, ,,"Checker instructions: - Look at graphs for each of the metrics, and confirm that any differences between the lines are small, or well understood - for each value in the ""spot check value"" columns, confirm that the value matches the same day's value on the state's page (see note on column header) - If all looks good, copy/paste each of the proposed columns into states daily.",,,,,,,,,,,,,,, ,Date,,Proposed,Spot check value,Total Tests (PCR),Proposed,Spot check value,Positive Tests (PCR),Proposed,Spot check value,,Negative Tests (PCR),Proposed,Spot check value,,Sensitivity,0.01 ,2020-10-29,,,,905290,905290,10905,,78673,1267,,,825406,,,, ,2020-10-28,,,,894385,894385,11765,,77406,981,,,815775,,,, ,2020-10-27,,,,882620,882620,9055,,76425,782,,,804996,,,, ,2020-10-26,,,,873565,873565,4402,,75643,643,,,796729,,,, ,2020-10-25,,,,869163,869163,6283,,75000,787,,,792969,,,, ,2020-10-24,,,,862880,862880,15611,,74213,1398,,,787484,,,, ,2020-10-23,,,,847269,847269,10467,,72815,1096,,,773277,,,, ,2020-10-22,,,,836802,836802,13898,,71719,1053,,,763923,,,, ,2020-10-21,,,,822904,822904,12406,,70666,711,,,751071,,,, ,2020-10-20,,,,810498,810498,10919,,69955,900,,,739379,,,, ,2020-10-19,,,,799579,799579,7949,,69055,820,,,729099,,,, ,2020-10-18,,,,791630,791630,7195,,68235,692,,,721983,,,, ,2020-10-17,,,,784435,784435,13928,,67543,1443,,,715487,,,, ,2020-10-16,,,,770507,770507,14047,,66100,1078,,,703017,,,, ,2020-10-15,,,,756460,756460,12277,,65022,1093,,,690063,,,, ,2020-10-14,,,,744183,744183,9491,,63929,808,,,678890,,,, ,2020-10-13,,,,734692,734692,6270,,63121,493,,,670224,,,, ,2020-10-12,,,,728422,728422,5172,,62628,562,,,664473,,,, ,2020-10-11,,,,723250,723250,7558,,62066,812,,,659869,,,, ,2020-10-10,,,,715692,715692,19440,,61254,252,,,653140,,,, ,2020-10-09,,,,696252,696252,8563,,61002,-552,,,633976,,,, ,2020-10-08,,,,687689,687689,12674,,61554,3036,,,624880,,,, ,2020-10-07,,,,675015,675015,11417,,58518,580,,,615248,,,, ,2020-10-06,,,,663598,663598,8067,,57938,501,,,604432,,,, ,2020-10-05,,,,655531,655531,5663,,57437,456,,,596884,,,, ,2020-10-04,,,,649868,649868,5236,,56981,507,,,591688,,,, ,2020-10-03,,,,644632,644632,9945,,56474,906,,,586964,,,, ,2020-10-02,,,,634687,634687,9733,,55568,781,,,577942,,,, ,2020-10-01,,,,624954,624954,6602,,54787,618,,,569018,,,, ,2020-09-30,,,,618352,618352,7272,,54169,777,,,563045,,,, ,2020-09-29,,,,611080,611080,4238,,53392,361,,,556572,,,, ,2020-09-28,,,,606842,606842,5306,,53031,526,,,552696,,,, ,2020-09-27,,,,601536,601536,6249,,52505,491,,,547931,,,, ,2020-09-26,,,,595287,595287,5078,,52014,489,,,542196,,,, ,2020-09-25,,,,590209,590209,5113,,51525,546,,,537626,,,, ,2020-09-24,,,,585096,585096,4956,,50979,568,,,533064,,,, ,2020-09-23,,,,580140,580140,3696,,50411,425,,,528685,,,, ,2020-09-22,,,,575663,576444,4420,,49986,377,,,525419,,,, ,2020-09-21,,,,562886,572024,3667,,49609,309,,,521381,,,, ,2020-09-20,,,,,568357,5017,,49300,480,,,518025,,,, ,2020-09-19,,,,,563340,5583,,48820,542,,,513488,,,, ,2020-09-18,,,,,557757,5967,,48278,607,,,508454,,,, ,2020-09-17,,,,,551790,5721,,47671,494,,,503094,,,, ,2020-09-16,,,,,546069,3790,,47177,399,,,497868,,,, ,2020-09-15,,,,,542279,3979,,46778,347,,,494481,,,, ,2020-09-14,,,,,538300,4640,,46431,252,,,490851,,,, ,2020-09-13,,,,,533660,4909,,46179,311,,,486466,,,, ,2020-09-12,,,,,528751,5737,,45868,548,,,481871,,,, ,2020-09-11,,,,,523014,5765,,45320,510,,,476686,,,, ,2020-09-10,,,,,517249,5528,,44810,417,,,471433,,,, ,2020-09-09,,,,,511721,11552,,44393,650,,,466326,,,, ,2020-09-08,,,,,500169,1033,,43743,82,,,455426,,,, ,2020-09-07,,,,,499136,1298,,43661,131,,,454475,,,, ,2020-09-06,,,,,497838,1840,,43530,155,,,453309,,,, ,2020-09-05,,,,,495998,2922,,43375,228,,,451629,,,, ,2020-09-04,,,,,493076,5257,,43147,443,,,448935,,,, ,2020-09-03,,,,,487819,5158,,42704,489,,,444127,,,, ,2020-09-02,,,,,482661,3606,,42215,332,,,439461,,,, ,2020-09-01,,,,,479055,2782,,41883,291,,,436188,,,, ,2020-08-31,,,,,476273,4775,,41592,328,,,433700,,,, ,2020-08-30,,,,,471498,4242,,41264,385,,,429254,,,, ,2020-08-29,,,,,467256,4332,,40879,396,,,425399,,,, ,2020-08-28,,,,,462924,5973,,40483,464,,,421468,,,, ,2020-08-27,,,,,456951,5718,,40019,460,,,415962,,,, ,2020-08-26,,,,,451233,1934,,39559,190,,,410704,,,, ,2020-08-25,,,,,449299,5774,,39369,342,,,408963,,,, ,2020-08-24,,,,,443525,1939,,39027,138,,,403533,,,, ,2020-08-23,,,,,441586,2688,,38889,177,,,401732,,,, ,2020-08-22,,,,,438898,3931,,38712,334,,,399222,,,, ,2020-08-21,,,,,434967,4421,,38378,322,,,395632,,,, ,2020-08-20,,,,,430546,4157,,38056,318,,,391534,,,, ,2020-08-19,,,,,426389,4159,,37738,303,,,387702,,,, ,2020-08-18,,,,,422230,2184,,37435,186,,,383848,,,, ,2020-08-17,,,,,420046,4436,,37249,231,,,381854,,,, ,2020-08-16,,,,,415610,4610,,37018,317,,,377649,,,, ,2020-08-15,,,,,411000,4412,,36701,394,,,373363,,,, ,2020-08-14,,,,,406588,5048,,36307,402,,,369348,,,, ,2020-08-13,,,,,401540,3077,,35905,270,,,364709,,,, ,2020-08-12,,,,,398463,4142,,35635,415,,,361907,,,, ,2020-08-11,,,,,394321,4499,,35220,334,,,358186,,,, ,2020-08-10,,,,,389822,4262,,34886,237,,,354027,,,, ,2020-08-09,,,,,385560,2859,,34649,177,,,350003,,,, ,2020-08-08,,,,,382701,3756,,34472,248,,,347323,,,, ,2020-08-07,,,,,378945,5802,,34224,468,,,343825,,,, ,2020-08-06,,,,,373143,5392,,33756,402,,,338496,,,, ,2020-08-05,,,,,367751,3159,,33354,264,,,333519,,,, ,2020-08-04,,,,,364592,3124,,33090,304,,,330640,,,, ,2020-08-03,,,,,361468,4903,,32786,326,,,327822,,,, ,2020-08-02,,,,,356565,4744,,32460,318,,,323249,,,, ,2020-08-01,,,,,351821,4403,,32142,435,,,318824,,,, ,2020-07-31,,,,,347418,5885,,31707,491,,,314873,,,, ,2020-07-30,,,,,341533,3523,,31216,306,,,309489,,,, ,2020-07-29,,,,,338010,5561,,30910,409,,,306284,,,, ,2020-07-28,,,,,332449,3029,,30501,353,,,301136,,,, ,2020-07-27,,,,,329420,3841,,30148,237,,,298461,,,, ,2020-07-26,,,,,325579,3583,,29911,254,,,294864,,,, ,2020-07-25,,,,,321996,5844,,29657,449,,,291539,,,, ,2020-07-24,,,,,316152,4473,,29208,385,,,286153,,,, ,2020-07-23,,,,,311679,4211,,28823,404,,,282068,,,, ,2020-07-22,,,,,307468,6691,,28419,428,,,278266,,,, ,2020-07-21,,,,,300777,4406,,27991,359,,,272028,,,, ,2020-07-20,,,,,296371,2890,,27632,94,,,267985,,,, ,2020-07-19,,,,,293481,2836,,27538,139,,,265190,,,, ,2020-07-18,,,,,290645,4832,,27399,265,,,262493,,,, ,2020-07-17,,,,,285813,3801,,27134,217,,,257927,,,, ,2020-07-16,,,,,282012,4716,,26917,300,,,254354,,,, ,2020-07-15,,,,,277296,5158,,26617,326,,,249941,,,, ,2020-07-14,,,,,272138,4438,,26291,286,,,245118,,,, ,2020-07-13,,,,,267700,5416,,26005,225,,,240972,,,, ,2020-07-12,,,,,262284,5451,,25780,260,,,235794,,,, ,2020-07-11,,,,,256833,3931,,25520,219,,,230616,,,, ,2020-07-10,,,,,252902,4020,,25301,254,,,226909,,,, ,2020-07-09,,,,,248882,4296,,25047,284,,,223148,,,, ,2020-07-08,,,,,244586,3368,,24763,241,,,219153,,,, ,2020-07-07,,,,,241218,1720,,24522,143,,,216032,,,, ,2020-07-06,,,,,239498,1270,,24379,96,,,214455,,,, ,2020-07-05,,,,,238228,3539,,24283,197,,,213281,,,, ,2020-07-04,,,,,234689,5452,,24086,292,,,209947,,,, ,2020-07-03,,,,,229237,2587,,23794,212,,,204801,,,, ,2020-07-02,,,,,226650,2350,,23582,143,,,202428,,,, ,2020-07-01,,,,,224300,3117,,23439,178,,,200223,,,, ,2020-06-30,,,,,221183,3951,,23261,250,,,197285,,,, ,2020-06-29,,,,,217232,2936,,23011,134,,,193600,,,, ,2020-06-28,,,,,214296,6371,,22877,330,,,190801,,,, ,2020-06-27,,,,,207925,6228,,22547,326,,,184781,,,, ,2020-06-26,,,,,201697,2410,,22221,151,,,178893,,,, ,2020-06-25,,,,,199287,2897,,22070,183,,,176638,,,, ,2020-06-24,,,,,196390,2885,,21887,147,,,173929,,,, ,2020-06-23,,,,,193505,3508,,21740,228,,,171196,,,, ,2020-06-22,,,,,189997,2825,,21512,130,,,167929,,,, ,2020-06-21,,,,,187172,2942,,21382,156,,,165239,,,, ,2020-06-20,,,,,184230,3434,,21226,217,,,162454,,,, ,2020-06-19,,,,,180796,3591,,21009,235,,,159240,,,, ,2020-06-18,,,,,177205,3652,,20774,271,,,155905,,,, ,2020-06-17,,,,,173553,3324,,20503,207,,,152535,,,, ,2020-06-16,,,,,170229,3348,,20296,223,,,149423,,,, ,2020-06-15,,,,,166881,2735,,20073,144,,,146309,,,, ,2020-06-14,,,,,164146,2480,,19929,157,,,143727,,,, ,2020-06-13,,,,,161666,3842,,19772,281,,,141410,,,, ,2020-06-12,,,,,157824,4137,,19491,338,,,137852,,,, ,2020-06-11,,,,,153687,3422,,19153,253,,,134062,,,, ,2020-06-10,,,,,150265,3438,,18900,142,,,130898,,,, ,2020-06-09,,,,,146827,2519,,18758,230,,,127607,,,, ,2020-06-08,,,,,144308,2188,,18528,122,,,125328,,,, ,2020-06-07,,,,,142120,2788,,18406,263,,,123269,,,, ,2020-06-06,,,,,139332,2692,,18143,245,,,120749,,,, ,2020-06-05,,,,,136640,3126,,17898,293,,,118324,,,, ,2020-06-04,,,,,133514,3906,,17605,421,,,115498,,,, ,2020-06-03,,,,,129608,3014,,17184,289,,,112019,,,, ,2020-06-02,,,,,126594,4198,,16895,331,,,109298,,,, ,2020-06-01,,,,,122396,2250,,16564,211,,,105439,,,, ,2020-05-31,,,,,120146,3497,,16353,324,,,103403,,,, ,2020-05-30,,,,,116649,5425,,16029,546,,,100232,,,, ,2020-05-29,,,,,111224,2083,,15483,348,,,95358,,,, ,2020-05-28,,,,,109141,3365,,15135,426,,,93625,,,, ,2020-05-27,,,,,105776,1976,,14709,252,,,90718,,,, ,2020-05-26,,,,,103800,2714,,14457,266,,,88998,,,, ,2020-05-25,,,,,101086,3870,,14191,229,,,86555,,,, ,2020-05-24,,,,,97216,1659,,13962,257,,,82917,,,, ,2020-05-23,,,,,95557,4614,,13705,460,,,81517,,,, ,2020-05-22,,,,,90943,2920,,13245,318,,,77369,,,, ,2020-05-21,,,,,88023,3968,,12927,374,,,74773,,,, ,2020-05-20,,,,,84055,3311,,12553,289,,,71185,,,, ,2020-05-19,,,,,80744,4046,,12264,383,,,68180,,,, ,2020-05-18,,,,,76698,1425,,11881,140,,,64529,,,, ,2020-05-17,,,,65774,75273,5410,,11741,502,,,63245,,,, ,2020-05-16,,,,,69863,4173,,11239,390,,,58346,,,, ,2020-05-15,,,,,65690,4921,,10849,530,,,54565,,,, ,2020-05-14,,,,,60769,2781,,10319,394,,,50178,,,, ,2020-05-13,,,,,57988,3547,,9925,278,,,47798,,,, ,2020-05-12,,,,,54441,1847,,9647,262,,,44530,,,, ,2020-05-11,,,,,52594,682,,9385,82,,,42946,,,, ,2020-05-10,,,,,51912,2156,,9303,389,,,42348,,,, ,2020-05-09,,,,,49756,4479,,8914,822,,,40586,,,, ,2020-05-08,,,,,45277,3054,,8092,738,,,36930,,,, ,2020-05-07,,,,,42223,1987,,7354,411,,,34617,,,, ,2020-05-06,,,,,40236,1737,,6943,408,,,33047,,,, ,2020-05-05,,,,,38499,2153,,6535,480,,,31719,,,, ,2020-05-04,,,,,36346,1651,,6055,366,,,30055,,,, ,2020-05-03,,,,,34695,1772,,5689,357,,,28774,,,, ,2020-05-02,,,,,32923,2124,,5332,562,,,27364,,,, ,2020-05-01,,,,,30799,2672,,4770,599,,,25834,,,, ,2020-04-30,,,,,28127,1958,,4171,467,,,23776,,,, ,2020-04-29,,,,,26169,18,,3704,12,,,22301,,,, ,2020-04-28,,,,,26151,1249,,3692,328,,,22295,,,, ,2020-04-27,,,,,24902,1281,,3364,317,,,21377,,,, ,2020-04-26,,,,,23621,1473,,3047,337,,,20415,,,, ,2020-04-25,,,,,22148,1632,,2710,353,,,19283,,,, ,2020-04-24,,,,,20516,1557,,2357,404,,,18011,,,, ,2020-04-23,,,,,18959,513,,1953,61,,,16863,,,, ,2020-04-22,,,,,18446,447,,1892,115,,,16415,,,, ,2020-04-21,,,,,17999,808,,1777,194,,,16092,,,, ,2020-04-20,,,,,17191,1125,,1583,198,,,15483,,,, ,2020-04-19,,,,,16066,1064,,1385,154,,,14558,,,, ,2020-04-18,,,,,15002,525,,1231,71,,,13651,,,, ,2020-04-17,,,,,14477,790,,1160,105,,,13197,,,, ,2020-04-16,,,,,13687,731,,1055,83,,,12519,,,, ,2020-04-15,,,,,12956,788,,972,106,,,11877,,,, ,2020-04-14,,,,,12168,455,,866,52,,,11199,,,, ,2020-04-13,,,,,11713,734,,814,93,,,10805,,,, ,2020-04-12,,,,,10979,809,,721,53,,,10166,,,, ,2020-04-11,,,,,10170,675,,668,63,,,9412,,,, ,2020-04-10,,,,,9495,812,,605,56,,,8806,,,, ,2020-04-09,,,,,8683,667,,549,47,,,8056,,,, ,2020-04-08,,,,,8016,561,,502,50,,,7439,,,, ,2020-04-07,,,,,7455,1083,,452,67,,,6933,,,, ,2020-04-06,,,,,6372,423,,385,39,,,5917,,,, ,2020-04-05,,,,,5949,659,,346,44,,,5535,,,, ,2020-04-04,,,,,5290,391,,302,26,,,4922,,,, ,2020-04-03,,,,,4899,762,,276,60,,,4560,,,, ,2020-04-02,,,,,4137,718,,216,41,,,3862,,,, ,2020-04-01,,,,,3419,417,,175,27,,,3187,,,, ,2020-03-31,,,,,3002,391,,148,21,,,2803,,,, ,2020-03-30,,,,,2611,353,,127,22,,,2434,,,, ,2020-03-29,,,,,2258,338,,105,27,,,2103,,,, ,2020-03-28,,,,,1920,189,,78,17,,,1802,,,, ,2020-03-27,,,,,1731,199,,61,4,,,1631,,,, ,2020-03-26,,,,,1532,123,,57,10,,,1440,,,, ,2020-03-25,,,,,1409,196,,47,10,,,1328,,,, ,2020-03-24,,,,,1213,178,,37,6,,,1143,,,, ,2020-03-23,,,,,1035,102,,31,4,,,975,,,, ,2020-03-22,,,,,933,164,,27,6,,,879,,,, ,2020-03-21,,,,,769,85,,21,5,,,728,,,, ,2020-03-20,,,,,684,117,,16,7,,,648,,,, ,2020-03-19,,,,,567,94,,9,2,,,538,,,, ,2020-03-18,,,,,473,97,,7,1,,,446,,,, ,2020-03-17,,,,,376,76,,6,1,,,351,,,, ,2020-03-16,,,,,300,54,,5,0,,,276,,,, ,2020-03-15,,,,,246,29,,5,2,,,222,,,, ,2020-03-14,,,,,217,13,,3,3,,,195,,,, ,2020-03-13,,,,,204,33,,0,0,,,185,,,, ,2020-03-12,,,,,171,21,,0,0,,,152,,,, ,2020-03-11,,,,,150,34,,0,0,,,134,,,, ,2020-03-10,,,,,116,15,,0,0,,,102,,,, ,2020-03-09,,,,,101,9,,0,0,,,88,,,, ,2020-03-08,,,,,92,13,,0,0,,,81,,,, ,2020-03-07,,,,,79,7,,0,0,,,69,,,, ,2020-03-06,,,,,72,6,,0,0,,,64,,,, ,2020-03-05,,,,,66,18,,0,0,,,58,,,, ,,,,,,48,0,,0,0,,,43,,,, ,,,,,,48,12,,0,0,,,43,,,, ,,,,,,36,0,,0,0,,,33,,,, ,,,,,,36,11,,0,0,,,33,,,, ,,,,,,25,15,,0,0,,,24,,,, ,,,,,,10,0,,0,0,,,9,,,, ,,,,,,10,0,,0,0,,,9,,,, ,,,,,,10,0,,0,0,,,9,,,, ,,,,,,10,0,,0,0,,,9,,,, ,,,,,,10,0,,0,0,,,9,,,, ,,,,,,10,0,,0,0,,,9,,,, ,,,,,,10,0,,0,0,,,9,,,, ,,,,,,10,1,,0,0,,,9,,,, ,,,,,,9,0,,0,0,,,8,,,, ,,,,,,9,6,,0,0,,,8,,,, ,,,,,,3,0,,0,0,,,2,,,, ,,,,,,3,0,,0,0,,,2,,,, ,,,,,,3,2,,0,0,,,2,,,, ,,,,,,1,1,,0,0,,,1,,,,