In November 2020, the City of Cambridge began collecting and analyzing COVID-19 data from municipal wastewater, which can serve as an early indicator of increased COVID-19 infections in the city. The Cambridge Public Health Department and Cambridge Department of Public Works are using technology developed by Biobot, a Cambridge based company, and partnering with the Massachusetts Water Resources Authority (MWRA). This Cambridge wastewater surveillance initiative is funded through a $175,000 appropriation from the Cambridge City Council. This dataset indicates the presence of the COVID-19 virus (measured as viral RNA particles from the novel coronavirus per ml) in municipal wastewater. The Cambridge site data here were collected as a 24-hour composite sample, which is taken weekly. The MWRA site data ere were collected as a 24-hour composite sample, which is taken daily. MWRA and Cambridge data are listed here in a single table. An interactive graph of this data is available here: https://cityofcambridge.shinyapps.io/COVID19/?tab=wastewater All areas within the City of Cambridge are captured across four separate catchment areas (or sewersheds) as indicated on the map viewable here: https://cityofcambridge.shinyapps.io/COVID19/_w_484790f7/BioBot_Sites.png. The North and West Cambridge sample also includes nearly all of Belmont and very small areas of Arlington and Somerville (light yellow). The remaining collection sites are entirely -- or almost entirely -- drawn from Cambridge households and workplaces. Data are corrected for wastewater flow rate, which adjusts for population in general. Data listed are expected to reflect the burden of COVID-19 infections within each of the four sewersheds. A lag of approximately 4-7 days will occur before new transmissions captured in wastewater data would result in a positive PCR test for COVID-19, the most common testing method used. While this wastewater surveillance tool can provide an early indication of major changes in transmission within the community, it remains an emerging technology. In assessing community transmission, wastewater surveillance data should only be considered in conjunction with other clinical measures, such as current infection rates and test positivity. Each location is selected because it reflects input from a distinct catchment area (or sewershed) as identified on the color-coded map. Viral data collected from small catchment areas like these four Cambridge sites are more variable than data collected from central collection points (e.g., the MWRA facility on Deer Island) where wastewater from dozens of communities are joined and mixed. Data from each catchment area will be impacted by daily activity among individuals living in that area (e.g., working from home vs. traveling to work) and by daytime activities that are not from residences (businesses, schools, etc.) As such, the Regional MWRA data provides a more stable measure of regional viral counts. COVID wastewater data for Boston North and Boston South regions is available at https://www.mwra.com/biobot/biobotdata.htm
This dataset has the following 15 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Date | date | calendar_date | Sample date for 24 hour composite sample. | 2021-01-30T00:00:00.000 2022-02-15T00:00:00.000 2021-09-02T00:00:00.000 2022-05-03T00:00:00.000 2021-06-04T00:00:00.000 view top 100 |
MWRA_Concentration | mwra_concentration | text | Normalized SARS-CoV2 RNA Copies per ML collected during sampling period. | 80 366 190 249 view top 100 |
MWRA_7DayAverage | mwra_7dayaverage | text | 7 day rolling average for Normalized SARS-CoV2 RNA Copies per ML collected during sampling period. | 20 59 45 257 118 view top 100 |
Concentration_Mid Cambridge | concentration_mid_cambridge | text | Normalized SARS-CoV2 RNA Copies per ML collected during sampling period. | 0 158.643 79.084 131.11 view top 100 |
Concentration_East Cambridge | concentration_east_cambridge | text | Normalized SARS-CoV2 RNA Copies per ML collected during sampling period. | 0 65.385 3273.874 121.006 view top 100 |
Concentration_Cambridgeport | concentration_cambridgeport | text | Normalized SARS-CoV2 RNA Copies per ML collected during sampling period. | 0 166.338 89.983 118.808 view top 100 |
Concentration_North & West Cambridge | concentration_north_west | text | Normalized SARS-CoV2 RNA Copies per ML collected during sampling period. | 0 15.163 6.548 115.485 view top 100 |
HighCI_Mid Cambridge | highci_mid_cambridge | text | Upper Limit on Confidence Interval for Normalized SARS-CoV2 RNA Copies per ML collected during sampling period. | 0 267.176114 157.569974 558.567334 view top 100 |
HighCI_East Cambridge | highci_east_cambridge | text | Upper Limit on Confidence Interval for Normalized SARS-CoV2 RNA Copies per ML collected during sampling period. | 0 294.840078 104.47452 127.957164 view top 100 |
HighCI_Cambridgeport | highci_cambridgeport | text | Upper Limit on Confidence Interval for Normalized SARS-CoV2 RNA Copies per ML collected during sampling period. | 0 461.263924 4.669628 19.280856 view top 100 |
HighCI_North & West Cambridge | highci_north_west_cambridge | text | Upper Limit on Confidence Interval for Normalized SARS-CoV2 RNA Copies per ML collected during sampling period. | 0 290.76987 754.30428 10.298328 view top 100 |
LowCI_Mid Cambridge | lowci_mid_cambridge | text | Lower Limit on Confidence Interval for Normalized SARS-CoV2 RNA Copies per ML collected during sampling period. | 0 35.030779753762 238.357045143639 36.3987688098495 view top 100 |
LowCI_East Cambridge | lowci_east_cambridge | text | Lower Limit on Confidence Interval for Normalized SARS-CoV2 RNA Copies per ML collected during sampling period. | 0 112.746922024624 0.299589603283174 8.34404924760602 view top 100 |
LowCI_Cambridgeport | lowci_cambridgeport | text | Lower Limit on Confidence Interval for Normalized SARS-CoV2 RNA Copies per ML collected during sampling period. | 0 31.156634746922 79.8413132694938 1374.67373461012 view top 100 |
LowCI_North & West Cambridge | lowci_north_west_cambridge | text | Lower Limit on Confidence Interval for Normalized SARS-CoV2 RNA Copies per ML collected during sampling period. | 0 5.48632010943913 94.5143638850889 254.425444596443 view top 100 |