Metadata for data files: “Urbanization Mediates the Effects of Water Quality and Climate on a Model Aerial Insectivorous Bird”. Wiley Manuscript ID ECM19-0080.R3. 1. Processed data CSVs (final). CSV files for use with R code. These data have been cleaned and correlated from data in the Excel spreadsheets. Units and other details about the variables can be found in the appropriate Excel spreadsheet from which these data are derived. a. 2source_&_TP_SIAR_output.csv: Output from SIAR stable isotope analysis. Used by Isotopes.R code. b. Individual_TRES.csv: Body condition data for individual Tree Swallows. c. Inverts: Final invertebrate data; a product of the InvertsMAY data and Inverts.R code. d. Inverts_SIAR_output.csv: Output from SIAR stable isotope analysis. Used by Isotopes.R code. e. InvertsMAY.csv: Semi-final invertebrate data; used by Inverts.R code. f. Reach_LULC_and_WQ.csv: Site-level environmental data (water chemistry, climate, etc.) g. Reproductive Response.csv: Nest-level reproductive response data. h. times: Local temperature data (site- and nest-level). i. TRES_SIAR.csv: Compiled lab results for stable isotopes. Input for SIAR_tp_and_ade_2source.R j. TRES_SIAR_inverts.csv: Compiled lab results for stable isotopes. Input for SIAR_inverts_4source.R 2. DBS lab reports: Raw data. DBS (Dried Blood Spot) data reports of heavy metal blood concentrations from Michigan State University’s Animal Health lab. a. Heavy Metals_2014-15.xls b. Heavy Metals_2016.pdf 3. Excel spreadsheets: Processed data (intermediate). Data have been transcribed or copied from field notes, lab reports, temperature loggers, GIS analyses, etc. and compiled at the appropriate observation level (study site, nest, bird, etc.). These data are partially cleaned but still include all observations. Spreadsheets may include formulas, summaries, or pivot tables used to further process data for analysis. Each spreadsheet includes a metadata tab. a. Birds_individual.xlsx: Body condition data for individual Tree Swallows. b. Birds_nests.xlsx: Nest-level reproductive response data c. Birds_recaptures.xlsx: Derived from Birds_individual.xlsx; indicates which birds were recaptured across years. d. Climate.xlsx: Temperature and humidity data from iButton loggers. e. Invertebrates.xlsx: All invertebrate data from malaise and emergent traps. f. Isotopes_compiled_lab_results.xlsx: Isotope data from the isotope lab reports. g. PCA_data_and_results.xlsx: Compilation of GIS land cover and water chemistry data for use with PCA. Includes computation of proportion of land cover for study sites. h. Water_chemistry.xlsx: Compilation of site-level water chemistry field data and results from STAR lab water chemistry reports. 4. GIS a. Study_site_coordinates.xlsx: GPS coordinates for study sites. b. TRES_land_cover.qgis: QGIS Project file. Use for developing maps and computing land cover (used in PCA). The NLCD raster files are required; however, they have not been included here due to their extremely large size (70+ GB). 5. iButton temp data: Raw data in CSV form. Temperature and humidity data .csv files from the iButton loggers. Filenames indicate year and study site (files not listed here). 6. Isotopes lab reports: Raw data. Reports of results of stable isotope analyses from Washington State University’s LBB2 lab. Filenames indicate year data was collected (4 files, not listed here). 7. Nests raw data: Raw data. Detailed records of nest observations. Note than, for 2014-16, observations are recorded as a separate observation for each day/nest. In 2017-18, observations are by nest or brood and are recorded in a single table. a. Tree_Swallow_Nest_Data_2017.xlsx b. Tree_Swallow_Nest_Data_2018.xlsx c. Tree_Swallow_Nest_Data_2014.xlsx d. Tree_Swallow_Nest_Data_2015.xlsx e. Tree_Swallow_Nest_Data_2016.xlsx 8. R code: Uses .csv files. Comments are included in code where appropriate. In most cases, required R packages are listed first (as library()). Note that file pathways and working directories in code are for authors’ system(s) and will require modification before proceeding. a. Inverts.R: used to compute site-level invertebrate stats, resulting in the Inverts.csv. Requires InvertsMAY.csv. b. Isotopes.R: Includes linear mixed effects models, regression models, and plots for trophic data derived from stable isotope analyses. Requires 2source_&_TP_SIAR_output.csv and Inverts_SIAR_output.csv. c. SIAR_inverts_4source.R: 4-source SIAR Stable Isotope Analysis (terrestrial and aquatic insects, 2 largest families of each). Requires TRES_SIAR_inverts.csv. d. SIAR_tp_and_ade_2source.R: 2-source SIAR Stable Isotope Analysis (detritus and periphyton). Requires TRES_SIAR.csv. e. temperature_calculator.R: Climate means and extremes (i.e., # of extreme days) at both the site- and nestbox-level. Requires times.csv. f. TRES_repro_and_bodycon.R: The bulk of the project’s R code is here. Includes linear mixed effects models, regression models, and plots for reproductive response and body condition. Requires Reach_LULC_and_WQ.csv, Reproductive_Response.csv, Inverts.csv, and Individual_TRES.csv. 9. Water chemistry lab reports: Raw data. Water chemistry data reports of contaminant and nutrient concentrations from OSU’s OARDC STAR Lab. a. water_chemistry_2015.xlsx b. water_chemistry_early_season_2016.xlsx c. water_chemistry_early_season_2017.xlsx d. water_chemistry_late_season_2016.xlsx e. water_chemistry_late_season_2017.xlsx