METADATA last updated: 2026-03-23 file_name: FLMP_pilot-data_summary.md file_date: 2023-01-02 title: FLMP Pilot Data Summary category: pilots subcategory: pilot-data tags: source_file_type: csv xfile_type: xlsx gfile_url: NA xfile_github_download_url: NA pdf_gdrive_url: NA pdf_github_url: NA license: CC BY 4.0 - https://creativecommons.org/licenses/by/4.0/ words: 3788 tokens: 7073 notes: summary_short: The "FLMP_pilot-data_summary" document was the organization's home-base testing in San Carlos and Portola Valley, CA, where FloodLAMP staff tested themselves and their working colleagues along with their household members. The testing used pooled household and individual self-collection across various sites and configurations. The program ran for over 2 years (2020-12-11 to 2023-01-02), testing 1,540 tubes with 3,399 participant results and 57 positive tubes detected. The files for FLMP include all data for the 2 programs Carillon, a local preschool where FloodLAMP founders kids attended (CRLN), and all other FloodLAMP internal and local testing, termed "FloodLAMP Staff Plus" (FLSP). These 2 programs were intermingled and utilized the same FloodLAMP app tenant. CONTENT ## Plots ### Composite ![FLMP Weekly Composite](_plots/FLMP_weekly_composite.png) ### Percent Positive Tubes ![FLMP Weekly Percent Positives](_plots/FLMP_weekly_percent_positives.png) ### Volume ![FLMP Weekly Volume](_plots/FLMP_weekly_volume.png) ## Files ### Google Sheets URLs - [FLMP_APS_deID_PUB](https://docs.google.com/spreadsheets/d/1ni39vn-fdXq0HrOgHbim_FK0OZidUv-YBLvzPwhhlFQ) - [FLMP_RFR_deID_PUB](https://docs.google.com/spreadsheets/d/16CwPJ9LeknD8lJFTr-gJSx916WZaGEMbN6iKnlVx4dI) - [FLMP_RTR_deID_PUB](https://docs.google.com/spreadsheets/d/16R3LlannlrGfiIIJq4T3EWjbtFLZrtPC4gkKycu8RXc) ### Curated CSVs - Curated CSV folder: `FLMP_curated_csvs/` - Stats key-values CSV: [FLMP_APS_stats_key-values.csv](FLMP_curated_csvs/FLMP_APS_stats_key-values.csv) - Weekly summary CSV: [FLMP_APS_weekly-summary.csv](FLMP_curated_csvs/FLMP_APS_weekly-summary.csv) - Referral tests by person CSV: _not available_ ### XLSX downloads: - [FLMP_APS_deID_PUB.xlsx](FLMP_xlsx_downloads/FLMP_APS_deID_PUB.xlsx) - [FLMP_RFR_deID_PUB.xlsx](FLMP_xlsx_downloads/FLMP_RFR_deID_PUB.xlsx) - [FLMP_RTR_deID_PUB.xlsx](FLMP_xlsx_downloads/FLMP_RTR_deID_PUB.xlsx) ## Key tables ### Stats key-values | section | metric | value | details | comments | source_sheet | source_row | | --- | --- | --- | --- | --- | --- | --- | | Files | RFR File | FLMP_RFR_deID_PUB | | | Stats | 1 | | Files | RTR File | FLMP_RTR_deID_PUB | | | Stats | 2 | | Files | RSR File | NONE | | | Stats | 3 | | Overall | Number of Tubes Tested (initial only - no re-runs) | 1,540 | initial run tubes only so excludes re-runs | | Stats | 5 | | Overall | Number of Tube Tests Run (includes re-runs) | 1,618 | includes re-runs | | Stats | 6 | | Overall | Number of Initial Runs | 243 | | divide CRLN by time period 1-2 to 5-31 | Stats | 7 | | Overall | Number of APS Only Tubes run | 436 | | divide CRLN by time period 1-2 to 5-31 | Stats | 8 | | Overall | Number of Test Reactions (RFR plus APS only tubes run) | 1,915 | includes technical replicates (the same tube sample in multiple reactions in the same run) | divide CRLN by time period 1-2 to 5-31 - 135 is num FLSP tubes in CRLN time period and 1290 is num RFR audit rxns during CRLN time period | Stats | 9 | | Overall | Number of Participant Results | 3,399 | counts individual samples in pools and excludes re-runs | | Stats | 11 | | Overall | Number of ARF Tubes | 48 | tubes run and present in RFR but not in Appivo - created tube IDs that start with ARF | all during CRLN period so assign to CRLN | Stats | 12 | | Overall | Sum of Participant Results plus ARF Tubes | 3,447 | Will be equal to the number of tubes tested if no pooling. | | Stats | 13 | | Overall | Average Pool Level (excludes ARF) | 2.3 | | | Stats | 14 | | Re-runs | Number of Run Tubes (re-runs only) | 78 | from RFR Audit Num Run Tubes | | Stats | 17 | | Re-runs | Number of Reactions (re-runs only) | 230 | from RFR Audit Num rxns (excl ctrls) | | Stats | 18 | | Re-runs | Re-run % of Tubes | 5.1% | re-run / initial | | Stats | 19 | | Re-runs | Number of Initial Runs with Re-runs | 37 | | | Stats | 20 | | Re-runs | % Initial Runs with Re-runs | 15.2% | | | Stats | 21 | | Positives | Number of Tubes with Final Result Positive | 57 | | count from VALUES Pos and Incl | Stats | 24 | | Positives | % of Tubes Positives (Final Result) | 3.7% | | | Stats | 25 | | Positives | Number of Cases with Final Result Positive (Indiv or Pool) | 19 | Subtract off Re-tests | | Stats | 26 | | Positives | Known Positive Cases | 3 | Previous tested (including by FloodLAMP test) or reported positive | | Stats | 27 | | Positives | Unknown Positive Cases | 16 | | | Stats | 28 | | Inconclusives | Number of Tubes with Final Result Inconclusive | 4 | | | Stats | 31 | | Inconclusives | Number of Tubes in RFR Audit Inconclusive not in Appivo Final Results | 0 | | | Stats | 32 | | Inconclusives | Total Number of Inconclusive Tubes | 4 | | | Stats | 33 | | Inconclusives | % of Tubes Inconclusive | 0.3% | | | Stats | 34 | | Inconclusives | Number of Inconclusive Tubes resolved Positive by Referral Test or Correspondence | 1 | | 2022-05-08T00:00:00 | Stats | 35 | | Inconclusives | % Inconclusives resolved Positive by Referral Tests | 25.0% | | 2/4 unknown and 1 of those was in household of positives | Stats | 36 | | Inconclusives | Number of Inconclusive Tubes with Referral Test or Correspondence Negative | 1 | | | Stats | 37 | | Inconclusives | Number of Inconclusive Tubes with no Referral Test result or Correspondence | 2 | | | Stats | 38 | | Inconclusives | Number of Tubes with Initial Inconclusives and Re-run Negative | 36 | Count Result Correction Code=2.5 in preDel col AJ, or from RFR preExcl if not resulted as Incl in App | No 2.5 correction code, Sum AE - AF = 36 | Stats | 39 | | Inconclusives | Number of Inconclusive Test Run Calls | 43 | includes re-runs - from RFR Audit only and excludes any APS only resulted inconclusives | | Stats | 40 | | Inconclusives | % Tube Tests Run Called Inconclusive | 2.7% | includes re-runs | | Stats | 41 | | Referrals and Correspondence | Number of FloodLAMP Cases with Referral Tests or Correspondence | 15 | Indiv or Pool, Cases used instead of Person to account for people being contracting COVID multiple times, and instead of Results to exclude re-tests | | Stats | 44 | | Referrals and Correspondence | Number of Referral Confirmed FloodLAMP Positives | 14 | Sometimes also termed Agree Positives - Include initial Inconclusive with Referral or Correspondence Positive | | Stats | 45 | | Referrals and Correspondence | FL Inconclusives with Referral / Correspondence Positive | 1 | | 2022-05-08T00:00:00 | Stats | 46 | | Referrals and Correspondence | % FloodLAMP Positive or Inconclusive with Referral / Correspondence Positive | 100.0% | | | Stats | 47 | | Referrals and Correspondence | FL Inconclusives but Referral / Correspondence Negative | 1 | | 2022-02-14T00:00:00 | Stats | 48 | | Referrals and Correspondence | FL Inconclusives with No Referral Tests or Correspondence | 2 | | | Stats | 49 | | Comparison to Antigen | Number of FloodLAMP Test Person Cases with Referral Antigen Tests (including non-Same Day) | 11 | | | Stats | 52 | | Comparison to Antigen | Number of FloodLAMP Test Person Cases with Same Day Referral Antigen Tests | 11 | | | Stats | 53 | | Comparison to Antigen | Number of FloodLAMP Positive Test Person Cases with Same Day Antigen Negative | 5 | Agree with Referral Test Positive (usually PCR or later Antigen) but Initial Antigen Negative | | Stats | 54 | | Comparison to Antigen | % Confirmed FloodLAMP Positives with Same Day Antigen Negative | 45.5% | | | Stats | 55 | | Comparison to Antigen | Number of FloodLAMP Positive Test Person Cases confirmed with Referral Tests but Antigen and Other Non-Antigen Test Negative | 1 | | | Stats | 56 | | Comparison to Antigen | % Confirmed FloodLAMP Positives that were Antigen and Other Non-Antigen Test Negative | 9.1% | | | Stats | 57 | | False Calls | False Positives Final Results | 0 | From reviewing APS/Pos and Incl tab Unconfirmed FL Positives | | Stats | 60 | | False Calls | False Negative Final Results (Suspected) | 0 | From reviewing Referral Tests by Person and correspondence with Program Admin | | Stats | 61 | | People | Number of Unique Individuals Tested | 212 | Includes UnknownPerson additions but not ARF tubes | | Stats | 64 | | People | Number of Unique Sponsors | 60 | People who collect using the app | | Stats | 65 | | Positivity | Number of Unique Individual Tested FloodLAMP Positive | 26 | includes Inconclusive FloodLAMP result confirmed Positive by follow-up or Referral | | Stats | 68 | | Positivity | % of Population FloodLAMP Positive (excluding pools not deconv) | 12.3% | | | Stats | 69 | | Positivity | Number of Unique Individual Tested FloodLAMP Positive (including if in a positive pool) | 52 | | | Stats | 70 | | Positivity | % of Population FloodLAMP Positive (including everyone in a positive pool) | 24.5% | | | Stats | 71 | | Dates | Start Run Date | 2020-12-11 | | | Stats | 74 | | Dates | End Run Date | 2023-01-02 | | | Stats | 75 | | Info | Test Operator | FloodLAMP | Who ran the actual testing (running LAMP reactions) | | Stats | 78 | | Info | Test Processing Site | Various | Where the test processing (running LAMP reactions) was done | | Stats | 79 | | Info | Population Tested | Staff, Students, Families, Community | Description of the participants | | Stats | 80 | | Info | Configuration | Various | Equipment set used for test processing (relates to throughput and type of test tube used) | | Stats | 81 | | Info | Collection Type | Pooled Household, Individual | Pooled, Individual, or Both | | Stats | 82 | | Info | Self or HCW Collected | Self | HCW is Health Care Worker | | Stats | 83 | | Info | App Used? | Yes | Was the FloodLAMP Mobile App and Admin Portal utilized in the program | | Stats | 84 | | Info | Bring-up Type | In Person | How the initial setup and validation of the testing site was done | | Stats | 85 | | Info | Program Name | FloodLAMP | Shorthand name used internally at FloodLAMP and in other documents for this program | | Stats | 86 | | Info | Site | Various | Broader physical space where the testing was done and/or where participants congregated | | Stats | 87 | | Info | Site Type | Various | Type of entity or organization receiving the testing program | | Stats | 88 | | Info | Location | Portola Valley, CA | Geographical location of where the FloodLAMP testing program occurred | | Stats | 89 | | Pooling | Number of Initial FloodLAMP Positive Pools | 13 | | | Stats | 92 | | Pooling | Number of Initial FloodLAMP Positive Pools with Indiv Deconvolution | 8 | | | Stats | 93 | | Pooling | Number of Initial FloodLAMP Positive Pools Confirmed by Referral Testing | 9 | | | Stats | 94 | | Pooling | Number of Initial Confirmed FL Pools where the organization member (i.e. parent or other child) was Positive | 5 | | | Stats | 95 | | Pooling | Number of Initial Confirmed FL Pools where Positive Individual was not the organization member (i.e. parent or other child) | 4 | | | Stats | 96 | | Pooling | % Confirmed Positive Pools where Positive Individual was not the organization member (i.e. parent or other child) | 44.4% | | | Stats | 97 | ### Weekly summary | week_start_date | week_end_date | participants_n | tubes_n | positive_tubes_n | inconclusive_tubes_n | pct_positive | pct_positive_status | | --- | --- | --- | --- | --- | --- | --- | --- | | 2020-12-07 | 2020-12-13 | 6 | 2 | 0 | 0 | 0.0% | ok | | 2020-12-14 | 2020-12-20 | 3 | 1 | 0 | 0 | 0.0% | ok | | 2020-12-21 | 2020-12-27 | 2 | 1 | 0 | 0 | 0.0% | ok | | 2020-12-28 | 2021-01-03 | 6 | 2 | 0 | 0 | 0.0% | ok | | 2021-01-04 | 2021-01-10 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-01-11 | 2021-01-17 | 36 | 15 | 3 | 0 | 20.0% | ok | | 2021-01-18 | 2021-01-24 | 49 | 24 | 0 | 0 | 0.0% | ok | | 2021-01-25 | 2021-01-31 | 45 | 19 | 0 | 0 | 0.0% | ok | | 2021-02-01 | 2021-02-07 | 31 | 11 | 0 | 0 | 0.0% | ok | | 2021-02-08 | 2021-02-14 | 40 | 13 | 0 | 0 | 0.0% | ok | | 2021-02-15 | 2021-02-21 | 14 | 4 | 0 | 0 | 0.0% | ok | | 2021-02-22 | 2021-02-28 | 24 | 9 | 0 | 0 | 0.0% | ok | | 2021-03-01 | 2021-03-07 | 35 | 11 | 0 | 0 | 0.0% | ok | | 2021-03-08 | 2021-03-14 | 30 | 9 | 0 | 0 | 0.0% | ok | | 2021-03-15 | 2021-03-21 | 16 | 6 | 0 | 0 | 0.0% | ok | | 2021-03-22 | 2021-03-28 | 6 | 2 | 0 | 0 | 0.0% | ok | | 2021-03-29 | 2021-04-04 | 6 | 2 | 0 | 0 | 0.0% | ok | | 2021-04-05 | 2021-04-11 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-04-12 | 2021-04-18 | 8 | 3 | 0 | 0 | 0.0% | ok | | 2021-04-19 | 2021-04-25 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-04-26 | 2021-05-02 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-05-03 | 2021-05-09 | 1 | 1 | 0 | 0 | 0.0% | ok | | 2021-05-10 | 2021-05-16 | 5 | 2 | 0 | 0 | 0.0% | ok | | 2021-05-17 | 2021-05-23 | 6 | 6 | 0 | 0 | 0.0% | ok | | 2021-05-24 | 2021-05-30 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-05-31 | 2021-06-06 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-06-07 | 2021-06-13 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-06-14 | 2021-06-20 | 2 | 2 | 0 | 0 | 0.0% | ok | | 2021-06-21 | 2021-06-27 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-06-28 | 2021-07-04 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-07-05 | 2021-07-11 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-07-12 | 2021-07-18 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-07-19 | 2021-07-25 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-07-26 | 2021-08-01 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-08-02 | 2021-08-08 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-08-09 | 2021-08-15 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-08-16 | 2021-08-22 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-08-23 | 2021-08-29 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-08-30 | 2021-09-05 | 7 | 4 | 0 | 0 | 0.0% | ok | | 2021-09-06 | 2021-09-12 | 4 | 2 | 0 | 0 | 0.0% | ok | | 2021-09-13 | 2021-09-19 | 9 | 6 | 0 | 0 | 0.0% | ok | | 2021-09-20 | 2021-09-26 | 7 | 4 | 0 | 0 | 0.0% | ok | | 2021-09-27 | 2021-10-03 | 0 | 0 | 0 | 0 | | denom_zero | | 2021-10-04 | 2021-10-10 | 10 | 7 | 0 | 0 | 0.0% | ok | | 2021-10-11 | 2021-10-17 | 11 | 5 | 0 | 0 | 0.0% | ok | | 2021-10-18 | 2021-10-24 | 15 | 8 | 0 | 0 | 0.0% | ok | | 2021-10-25 | 2021-10-31 | 2 | 2 | 0 | 0 | 0.0% | ok | | 2021-11-01 | 2021-11-07 | 19 | 9 | 0 | 0 | 0.0% | ok | | 2021-11-08 | 2021-11-14 | 15 | 6 | 0 | 0 | 0.0% | ok | | 2021-11-15 | 2021-11-21 | 15 | 6 | 0 | 0 | 0.0% | ok | | 2021-11-22 | 2021-11-28 | 43 | 12 | 0 | 0 | 0.0% | ok | | 2021-11-29 | 2021-12-05 | 18 | 8 | 0 | 0 | 0.0% | ok | | 2021-12-06 | 2021-12-12 | 39 | 19 | 0 | 0 | 0.0% | ok | | 2021-12-13 | 2021-12-19 | 43 | 22 | 2 | 0 | 9.1% | ok | | 2021-12-20 | 2021-12-26 | 38 | 30 | 6 | 0 | 20.0% | ok | | 2021-12-27 | 2022-01-02 | 78 | 43 | 6 | 0 | 14.0% | ok | | 2022-01-03 | 2022-01-09 | 94 | 43 | 7 | 0 | 16.3% | ok | | 2022-01-10 | 2022-01-16 | 183 | 93 | 15 | 1 | 16.1% | ok | | 2022-01-17 | 2022-01-23 | 177 | 86 | 9 | 0 | 10.5% | ok | | 2022-01-24 | 2022-01-30 | 154 | 65 | 0 | 0 | 0.0% | ok | | 2022-01-31 | 2022-02-06 | 144 | 59 | 0 | 0 | 0.0% | ok | | 2022-02-07 | 2022-02-13 | 148 | 60 | 0 | 0 | 0.0% | ok | | 2022-02-14 | 2022-02-20 | 128 | 54 | 0 | 1 | 0.0% | ok | | 2022-02-21 | 2022-02-27 | 55 | 21 | 0 | 0 | 0.0% | ok | | 2022-02-28 | 2022-03-06 | 51 | 25 | 0 | 0 | 0.0% | ok | | 2022-03-07 | 2022-03-13 | 113 | 52 | 0 | 0 | 0.0% | ok | | 2022-03-14 | 2022-03-20 | 91 | 42 | 0 | 0 | 0.0% | ok | | 2022-03-21 | 2022-03-27 | 113 | 47 | 0 | 0 | 0.0% | ok | | 2022-03-28 | 2022-04-03 | 25 | 12 | 0 | 0 | 0.0% | ok | | 2022-04-04 | 2022-04-10 | 119 | 47 | 0 | 0 | 0.0% | ok | | 2022-04-11 | 2022-04-17 | 104 | 43 | 0 | 0 | 0.0% | ok | | 2022-04-18 | 2022-04-24 | 116 | 53 | 0 | 0 | 0.0% | ok | | 2022-04-25 | 2022-05-01 | 113 | 48 | 0 | 0 | 0.0% | ok | | 2022-05-02 | 2022-05-08 | 114 | 53 | 2 | 0 | 3.8% | ok | | 2022-05-09 | 2022-05-15 | 117 | 67 | 4 | 2 | 6.0% | ok | | 2022-05-16 | 2022-05-22 | 102 | 51 | 1 | 0 | 2.0% | ok | | 2022-05-23 | 2022-05-29 | 93 | 44 | 1 | 0 | 2.3% | ok | | 2022-05-30 | 2022-06-05 | 49 | 22 | 0 | 0 | 0.0% | ok | | 2022-06-06 | 2022-06-12 | 13 | 7 | 0 | 0 | 0.0% | ok | | 2022-06-13 | 2022-06-19 | 7 | 5 | 0 | 0 | 0.0% | ok | | 2022-06-20 | 2022-06-26 | 9 | 3 | 0 | 0 | 0.0% | ok | | 2022-06-27 | 2022-07-03 | 4 | 3 | 0 | 0 | 0.0% | ok | | 2022-07-04 | 2022-07-10 | 0 | 0 | 0 | 0 | | denom_zero | | 2022-07-11 | 2022-07-17 | 0 | 0 | 0 | 0 | | denom_zero | | 2022-07-18 | 2022-07-24 | 6 | 3 | 0 | 0 | 0.0% | ok | | 2022-07-25 | 2022-07-31 | 8 | 4 | 0 | 0 | 0.0% | ok | | 2022-08-01 | 2022-08-07 | 6 | 3 | 0 | 0 | 0.0% | ok | | 2022-08-08 | 2022-08-14 | 0 | 0 | 0 | 0 | | denom_zero | | 2022-08-15 | 2022-08-21 | 0 | 0 | 0 | 0 | | denom_zero | | 2022-08-22 | 2022-08-28 | 4 | 1 | 0 | 0 | 0.0% | ok | | 2022-08-29 | 2022-09-04 | 0 | 0 | 0 | 0 | | denom_zero | | 2022-09-05 | 2022-09-11 | 8 | 3 | 0 | 0 | 0.0% | ok | | 2022-09-12 | 2022-09-18 | 11 | 4 | 0 | 0 | 0.0% | ok | | 2022-09-19 | 2022-09-25 | 10 | 4 | 0 | 0 | 0.0% | ok | | 2022-09-26 | 2022-10-02 | 12 | 4 | 0 | 0 | 0.0% | ok | | 2022-10-03 | 2022-10-09 | 13 | 5 | 0 | 0 | 0.0% | ok | | 2022-10-10 | 2022-10-16 | 14 | 5 | 0 | 0 | 0.0% | ok | | 2022-10-17 | 2022-10-23 | 12 | 4 | 0 | 0 | 0.0% | ok | | 2022-10-24 | 2022-10-30 | 12 | 8 | 0 | 0 | 0.0% | ok | | 2022-10-31 | 2022-11-06 | 11 | 5 | 0 | 0 | 0.0% | ok | | 2022-11-07 | 2022-11-13 | 12 | 5 | 0 | 0 | 0.0% | ok | | 2022-11-14 | 2022-11-20 | 8 | 5 | 0 | 0 | 0.0% | ok | | 2022-11-21 | 2022-11-27 | 5 | 3 | 0 | 0 | 0.0% | ok | | 2022-11-28 | 2022-12-04 | 13 | 5 | 0 | 0 | 0.0% | ok | | 2022-12-05 | 2022-12-11 | 8 | 3 | 0 | 0 | 0.0% | ok | | 2022-12-12 | 2022-12-18 | 23 | 11 | 1 | 0 | 9.1% | ok | | 2022-12-19 | 2022-12-25 | 10 | 6 | 0 | 0 | 0.0% | ok | | 2022-12-26 | 2023-01-01 | 6 | 3 | 0 | 0 | 0.0% | ok | | 2023-01-02 | 2023-01-08 | 7 | 3 | 0 | 0 | 0.0% | ok |