This codebook.txt file was generated on 2081-01-31 by wilsonkm ------------------- GENERAL INFORMATION ------------------- 1. Title of Dataset Sedimentary Record of Antibiotic Accumulation in Minnesota Lakes 2. Author Information Principal Investigator Contact Information Name: William Arnold Institution: University of Minnesota Address: Civil Engineering, 500 Pillsbury Drive E SE, Minneapolis MN 55455 Email: arnol032@umn.edu Associate or Co-investigator Contact Information Name: Jill F Kerrigan Institution: University of Minnesota Address: Email: kerr0077@umn.edu Associate or Co-investigator Contact Information Name: Kyle Sandberg Institution: University of Minnesota Address: Email: sanb283@umn.edu Associate or Co-investigator Contact Information Name: Daniel Engstrom Institution: St. Croix Watershed Research Station, Science Museum of Minnesota Address: Email: dre@umn.edu Associate or Co-investigator Contact Information Name: Tim LaPara Institution: University of Minnesota Address: Civil Engineering, 500 Pillsbury Drive E SE, Minneapolis MN 55455 Email: lapar001@umn.edu 3. Date of data collection: 1900-2015 4. Geographic location of data collection: Lake Pepin, MN: 44.49975; -92.29417 Duluth Harbor: 46.732783, -92.065333 Little Wilson Lake, MN: 47.656138, -91.067905 Lake Winona, MN: 45.87501, -95.40402 5. Information about funding sources that supported the collection of the data: N/A -------------------------- SHARING/ACCESS INFORMATION -------------------------- 1. Licenses/restrictions placed on the data: Attribution-NonCommercial-NoDerivs 3.0 United States 2. Links to publications that cite or use the data: Kerrigan, J. F., Sandberg, K. D., Engstrom, D. R., LaPara, T. M., & Arnold, W. A. (2017). Sedimentary record of antibiotic accumulation in Minnesota Lakes. Science of The Total Environment. https://doi.org/10.1016/j.scitotenv.2017.10.130 3. Links to other publicly accessible locations of the data: 4. Links/relationships to ancillary data sets: Supplementary data associated with this article can be found in the online version, at https://doi.org/10.1016/j.scitotenv.2017.10.130. 5. Was data derived from another source? If yes, list source(s): 6. Recommended citation for the data: Kerrigan, Jill F. (2018). Sedimentary Record of Antibiotic Accumulation in Minnesota Lakes. Retrieved from the Data Repository for the University of Minnesota, http://hdl.handle.net/11299/192993. --------------------- DATA & FILE OVERVIEW --------------------- 1. File List A. Filename: Duluth Harbor Sediment Core_analyzed_May2016.xlsx Short description: Antibiotic accumulation rates in Duluth Harbor. .xlsx copy of the file contains 5 sheets: “Abbr(eviations)”, “LC-MS-MS Data”, “SAs & SGs”, “MCs & ORs”, and “TCs & FQs”. The sheet “Abbr” provides definitions for all abbreviations detailed in the workbook. Other information contained in this workbook: instrument used for analysis, dates of analysis, data finalized date, maps of area, core collected date, and GPS coordinates. LC-MS-S: liquid chromatography tandem mass spectrometry SAs & SGs: sulfonamides & surrogates MCs & ORs: macrolides & others TCs & FQs: tetracyclines & fluoroquinolones B. Filename: Lake Pepin and Lake Winona Sediment Cores_analyzed_April2017.xlsx Short description: Antibiotic accumulation rates in Lake Pepin and Lake Winona, ultrasound assisted extraction. .xlsx copy of the file contains 4 sheets: “Abbr(eviations)”, “LC-MS-MS Data”, “SAs & SGs”, and “TCs & FQs”. The sheet “Abbr” provides definitions for all abbreviations detailed in the workbook. Other information contained in this workbook: instrument used for analysis, dates of analysis, data finalized date, maps of area, core collected date, and GPS coordinates. LC-MS-S: liquid chromatography tandem mass spectrometry SAs & SGs: sulfonamides & surrogates TCs & FQs: tetracyclines & fluoroquinolones C. Filename: Lake Pepin Sediment Core_analyzed_March2016.xlsx Short description: Antibiotic accumulation rates in Lake Pepin. .xlsx copy of the file contains 5 sheets: “Abbr(eviations)”, “LC-MS-MS Data”, “SAs & SGs”, “TCs & FQs”, and “MCs & ORs”. The sheet “Abbr” provides definitions for all abbreviations detailed in the workbook. Other information contained in this workbook: instrument used for analysis, dates of analysis, data finalized date, maps of area, core collected date, and GPS coordinates. LC-MS-S: liquid chromatography tandem mass spectrometry SAs & SGs: sulfonamides & surrogates TCs & FQs: tetracyclines & fluoroquinolones MCs & ORs: macrolides & others D. Filename: Lake Winona Sediment Cores_analyzed_June2016.xlsx Short description: Antibiotic accumulation rates in Lake Winona. .xlsx copy of the file contains 5 sheets: “Abbr(eviations)”, “LC-MS-MS Data”, “SAs & SGs”, “MCs & ORs”, and “TCs & FQs”. The sheet “Abbr” provides definitions for all abbreviations detailed in the workbook. Other information contained in this workbook: instrument used for analysis, dates of analysis, data finalized date, maps of area, core collected date, and GPS coordinates. LC-MS-S: liquid chromatography tandem mass spectrometry SAs & SGs: sulfonamides & surrogates MCs & ORs: macrolides & others TCs & FQs: tetracyclines & fluoroquinolones E. Filename: Little Wilson Lake Sediment Core_analyzed_Nov2016.xlsx Short description: Antibiotic accumulation rates in Little Wilson Lake. .xlsx copy of the file contains 5 sheets: “Abbr(eviations)”, “LC-MS-MS Data”, “SAs & SGs”, “MCs & ORs”, and “TCs & FQs”. The sheet “Abbr” provides definitions for all abbreviations detailed in the workbook. Other information contained in this workbook: instrument used for analysis, dates of analysis, data finalized date, maps of area, core collected date, and GPS coordinates. LC-MS-S: liquid chromatography tandem mass spectrometry SAs & SGs: sulfonamides & surrogates MCs & ORs: macrolides & others TCs & FQs: tetracyclines & fluoroquinolones F. Filename: Rerun of Select Intervals in Sediment Cores_analyzed_Dec2016.xlsx Short description: Re-extracts of select sediment cores. .xlsx copy of the file contains 5 sheets: “Abbr(eviations)”, “LC-MS-MS Data”, “SAs & ORs”, “TCs & FQs”, and “MCs”. The sheet “Abbr” provides definitions for all abbreviations detailed in the workbook. Other information contained in this workbook: instrument used for analysis, dates of analysis, data finalized date, maps of area, core collected date, and GPS coordinates. LC-MS-S: liquid chromatography tandem mass spectrometry SAs & ORs: sulfonamides & others TCs & FQs: tetracyclines & fluoroquinolones MCs: macrolides 2. Relationship between files: 3. Additional related data collected that was not included in the current data package: 4. Are there multiple versions of the dataset? yes/no If yes, list versions: Name of file that was updated: i. Why was the file updated? ii. When was the file updated? Name of file that was updated: i. Why was the file updated? ii. When was the file updated? -------------------------- METHODOLOGICAL INFORMATION -------------------------- 1. Description of methods used for collection/generation of data: For more in-depth description of methodology, please see the referenced publication above. Instruments used are detailed in workbooks. 2. Methods for processing the data: 3. Instrument- or software-specific information needed to interpret the data: 4. Standards and calibration information, if appropriate: 5. Environmental/experimental conditions: 6. Describe any quality-assurance procedures performed on the data: 7. People involved with sample collection, processing, analysis and/or submission: ----------------------------------------- DATA-SPECIFIC INFORMATION: Abbreviations found throughout the following Excel workbooks: ----------------------------------------- AVG: Average DH: Duluth Harbor LOD: limits of detection ng/g: nanogram LOQ: limit of quantification LP: Lake Pepin LWL: Little Wilson Lake OS: Ottawa sand MB: method blank MID MB: middle method blank SR: spike and recovery PA: peak areas SED: sediment STD DEV: standard deviation WIN: Lake Winona seq: sequence Some workbooks have highlighting: Red: the concentration is below limit of detection Blue: the concentration is between the limit of detection and limit of quantification Green: highlighting the concentration in the method blanks. I subtracted off the method blank levels from the concentrations in the samples Orange: when sample were rerun in December 2016, the analyte was not detected ----------------------------------------- DATA-SPECIFIC INFORMATION FOR: Duluth Harbor Sediment Core_analyzed_May2016.xlsx ----------------------------------------- 1. Number of variables: 47 2. Number of cases/rows: By sheet: Abbrv: 37 rows LC-MS-S: 129 rows SAs & SGs: 224 rows MCs & ORs: 217 rows TCs & FQs: 215 rows 3. Missing data codes: N/A 4. Variable List: The following were taken from the sheet “Abbrv” in the workbook. 1. 13C2-EMC: 13C2-erythromycin 2. 13C2-EMC-H2O: 13C2-erythromycin-H2O 3. 13C6-SMZ: 13C6-sulfamethazine 4. 13C2-SMX: 13C6-sulfamethoxazole 5. CBX: carbadox 6. CTC: chlortetracycline 7. CFC: ciprofloxacin 8. CFX: clinafloxacin 9. dp-CTC: degradation products of chlortetracycline 10. DMC: demeclocycline 11. DXC: doxycycline 12. EFC: enrofloxacin 13. EMC: erythromycin 14. EMC-H2O: erythromycin-H2O 15. FQs: fluoroquinolones 16. LMC: lincomycin 17. MCs: macrolides 18. MEC: meclocycline 19. NDA: nalidixic acid 20. NFC: norfloxacin 21. OFC: ofloxacin 22. ORs : others 23. OTC: oxytetracycline 24. RXC: roxithromycin 25. SIM: simetone 26. SCP: sulfachloropyridazine 27. SDZ: sulfadiazine 28. SDM: sulfadimethoxine 29. SMZ: sulfamethazine 30. SMX: sulfamethoxazole 31. SPD: sulfapyridine 32. SAs : sulfonamides 33. TCC: tetracycline 34. TCs: tetracyclines 35. TMP: trimethoprim 36. TYL: tylosin 37. IS: internal standards 38. LOD: limit of detection 39. LOQ: limit of quantificaiton 40. SGs: surrogates 41. PA: peak area 42. LC-MS/MS: liquid chromatography tandem mass spectrometry 43. tR : retention time 44. OS: ottawa sand 45. MB: method blank 46. ND: non-detect 47. Sample ID ----------------------------------------- DATA-SPECIFIC INFORMATION FOR: Lake Pepin and Lake Winona Sediment Cores_analyzed_April2017.xlsx ----------------------------------------- 1. Number of variables: 47 2. Number of cases/rows: Abbrv: 37 rows LC-MS-S: 99 rows SAs & ORs: 291 rows TCs & FQs: 187 rows 3. Missing data codes: N/A 4. Variable List 1. 13C2-EMC: 13C2-erythromycin 2. 13C2-EMC-H2O: 13C2-erythromycin-H2O 3. 13C6-SMZ: 13C6-sulfamethazine 4. 13C2-SMX: 13C6-sulfamethoxazole 5. CBX: carbadox 6. CTC: chlortetracycline 7. CFC: ciprofloxacin 8. CFX: clinafloxacin 9. dp-CTC: degradation products of chlortetracycline 10. DMC: demeclocycline 11. DXC: doxycycline 12. EFC: enrofloxacin 13. EMC: erythromycin 14. EMC-H2O: erythromycin-H2O 15. FQs: fluoroquinolones 16. LMC: lincomycin 17. MCs: macrolides 18. MEC: meclocycline 19. NDA: nalidixic acid 20. NFC: norfloxacin 21. OFC: ofloxacin 22. ORs : others 23. OTC: oxytetracycline 24. RXC: roxithromycin 25. SIM: simetone 26. SCP: sulfachloropyridazine 27. SDZ: sulfadiazine 28. SDM: sulfadimethoxine 29. SMZ: sulfamethazine 30. SMX: sulfamethoxazole 31. SPD: sulfapyridine 32. SAs : sulfonamides 33. TCC: tetracycline 34. TCs: tetracyclines 35. TMP: trimethoprim 36. TYL: tylosin 37. IS: internal standards 38. LOD: limit of detection 39. LOQ: limit of quantificaiton 40. SGs: surrogates 41. PA: peak area 42. LC-MS/MS: liquid chromatography tandem mass spectrometry 43. tR : retention time 44. OS: ottawa sand 45. MB: method blank 46. ND: non-detect 47. Sample ID: ----------------------------------------- DATA-SPECIFIC INFORMATION FOR: Lake Pepin Sediment Core_analyzed_March2016.xlsx ----------------------------------------- 1. Number of variables: 47 2. Number of cases/rows: Abbrv: 37 rows LC-MS-S: 135 rows SAs & SGs: 248 rows MCs & ORs: 248 rows TCs & FQs: 228 rows 3. Missing data codes: N/A 4. Variable List 1. 13C2-EMC: 13C2-erythromycin 2. 13C2-EMC-H2O: 13C2-erythromycin-H2O 3. 13C6-SMZ: 13C6-sulfamethazine 4. 13C2-SMX: 13C6-sulfamethoxazole 5. CBX: carbadox 6. CTC: chlortetracycline 7. CFC: ciprofloxacin 8. CFX: clinafloxacin 9. dp-CTC: degradation products of chlortetracycline 10. DMC: demeclocycline 11. DXC: doxycycline 12. EFC: enrofloxacin 13. EMC: erythromycin 14. EMC-H2O: erythromycin-H2O 15. FQs: fluoroquinolones 16. LMC: lincomycin 17. MCs: macrolides 18. MEC: meclocycline 19. NDA: nalidixic acid 20. NFC: norfloxacin 21. OFC: ofloxacin 22. ORs : others 23. OTC: oxytetracycline 24. RXC: roxithromycin 25. SIM: simetone 26. SCP: sulfachloropyridazine 27. SDZ: sulfadiazine 28. SDM: sulfadimethoxine 29. SMZ: sulfamethazine 30. SMX: sulfamethoxazole 31. SPD: sulfapyridine 32. SAs : sulfonamides 33. TCC: tetracycline 34. TCs: tetracyclines 35. TMP: trimethoprim 36. TYL: tylosin 37. IS: internal standards 38. LOD: limit of detection 39. LOQ: limit of quantificaiton 40. SGs: surrogates 41. PA: peak area 42. LC-MS/MS: liquid chromatography tandem mass spectrometry 43. tR : retention time 44. OS: ottawa sand 45. MB: method blank 46. ND: non-detect 47. Sample ID: ----------------------------------------- DATA-SPECIFIC INFORMATION FOR: Lake Winona Sediment Cores_analyzed_June2016.xlsx ----------------------------------------- 1. Number of variables: 47 2. Number of cases/rows: Abbrv: 37 rows LC-MS-MS: 130 rows SAs & SGs: 242 rows MCs & ORs: 228 rows TCs & FQs: 227 rows 3. Missing data codes: N/A 4. Variable List 1. 13C2-EMC: 13C2-erythromycin 2. 13C2-EMC-H2O: 13C2-erythromycin-H2O 3. 13C6-SMZ: 13C6-sulfamethazine 4. 13C2-SMX: 13C6-sulfamethoxazole 5. CBX: carbadox 6. CTC: chlortetracycline 7. CFC: ciprofloxacin 8. CFX: clinafloxacin 9. dp-CTC: degradation products of chlortetracycline 10. DMC: demeclocycline 11. DXC: doxycycline 12. EFC: enrofloxacin 13. EMC: erythromycin 14. EMC-H2O: erythromycin-H2O 15. FQs: fluoroquinolones 16. LMC: lincomycin 17. MCs: macrolides 18. MEC: meclocycline 19. NDA: nalidixic acid 20. NFC: norfloxacin 21. OFC: ofloxacin 22. ORs : others 23. OTC: oxytetracycline 24. RXC: roxithromycin 25. SIM: simetone 26. SCP: sulfachloropyridazine 27. SDZ: sulfadiazine 28. SDM: sulfadimethoxine 29. SMZ: sulfamethazine 30. SMX: sulfamethoxazole 31. SPD: sulfapyridine 32. SAs : sulfonamides 33. TCC: tetracycline 34. TCs: tetracyclines 35. TMP: trimethoprim 36. TYL: tylosin 37. IS: internal standards 38. LOD: limit of detection 39. LOQ: limit of quantificaiton 40. SGs: surrogates 41. PA: peak area 42. LC-MS/MS: liquid chromatography tandem mass spectrometry 43. tR : retention time 44. OS: ottawa sand 45. MB: method blank 46. ND: non-detect 47. Sample ID: ----------------------------------------- DATA-SPECIFIC INFORMATION FOR: Little Wilson Lake Sediment Core_analyzed_Nov2016.xlsx ----------------------------------------- 1. Number of variables: 47 2. Number of cases/rows: Abbrv: 37 rows LC-MS-MS: 137 rows SAs & SGs: 236 rows MCs & ORs: 207 rows TCs & FQs: 199 rows 3. Missing data codes: N/A 4. Variable List 1. 13C2-EMC: 13C2-erythromycin 2. 13C2-EMC-H2O: 13C2-erythromycin-H2O 3. 13C6-SMZ: 13C6-sulfamethazine 4. 13C2-SMX: 13C6-sulfamethoxazole 5. CBX: carbadox 6. CTC: chlortetracycline 7. CFC: ciprofloxacin 8. CFX: clinafloxacin 9. dp-CTC: degradation products of chlortetracycline 10. DMC: demeclocycline 11. DXC: doxycycline 12. EFC: enrofloxacin 13. EMC: erythromycin 14. EMC-H2O: erythromycin-H2O 15. FQs: fluoroquinolones 16. LMC: lincomycin 17. MCs: macrolides 18. MEC: meclocycline 19. NDA: nalidixic acid 20. NFC: norfloxacin 21. OFC: ofloxacin 22. ORs : others 23. OTC: oxytetracycline 24. RXC: roxithromycin 25. SIM: simetone 26. SCP: sulfachloropyridazine 27. SDZ: sulfadiazine 28. SDM: sulfadimethoxine 29. SMZ: sulfamethazine 30. SMX: sulfamethoxazole 31. SPD: sulfapyridine 32. SAs : sulfonamides 33. TCC: tetracycline 34. TCs: tetracyclines 35. TMP: trimethoprim 36. TYL: tylosin 37. IS: internal standards 38. LOD: limit of detection 39. LOQ: limit of quantificaiton 40. SGs: surrogates 41. PA: peak area 42. LC-MS/MS: liquid chromatography tandem mass spectrometry 43. tR : retention time 44. OS: ottawa sand 45. MB: method blank 46. ND: non-detect 47. Sample ID ----------------------------------------- DATA-SPECIFIC INFORMATION FOR: Rerun of Select Intervals in Sediment Cores_analyzed_Dec2016.xlsx ----------------------------------------- 1. Number of variables: 47 2. Number of cases/rows: Abbrv: 37 LC-MS-S: 117 rows SAs & ORs: 169 rows TCs & FQs: 136 rows MCs: 135 rows 3. Missing data codes: N/A 4. Variable List 1. 13C2-EMC: 13C2-erythromycin 2. 13C2-EMC-H2O: 13C2-erythromycin-H2O 3. 13C6-SMZ: 13C6-sulfamethazine 4. 13C2-SMX: 13C6-sulfamethoxazole 5. CBX: carbadox 6. CTC: chlortetracycline 7. CFC: ciprofloxacin 8. CFX: clinafloxacin 9. dp-CTC: degradation products of chlortetracycline 10. DMC: demeclocycline 11. DXC: doxycycline 12. EFC: enrofloxacin 13. EMC: erythromycin 14. EMC-H2O: erythromycin-H2O 15. FQs: fluoroquinolones 16. LMC: lincomycin 17. MCs: macrolides 18. MEC: meclocycline 19. NDA: nalidixic acid 20. NFC: norfloxacin 21. OFC: ofloxacin 22. ORs : others 23. OTC: oxytetracycline 24. RXC: roxithromycin 25. SIM: simetone 26. SCP: sulfachloropyridazine 27. SDZ: sulfadiazine 28. SDM: sulfadimethoxine 29. SMZ: sulfamethazine 30. SMX: sulfamethoxazole 31. SPD: sulfapyridine 32. SAs : sulfonamides 33. TCC: tetracycline 34. TCs: tetracyclines 35. TMP: trimethoprim 36. TYL: tylosin 37. IS: internal standards 38. LOD: limit of detection 39. LOQ: limit of quantificaiton 40. SGs: surrogates 41. PA: peak area 42. LC-MS/MS: liquid chromatography tandem mass spectrometry 43. tR : retention time 44. OS: ottawa sand 45. MB: method blank 46. ND: non-detect 47. Sample ID