Warning: Large file size (over 1GB). Each monthly data set is large (over 4 million rows), but can be viewed in standard software such as Microsoft WordPad (save by right-clicking on the file name and selecting 'Save Target As', or equivalent on Mac OSX). It is then possible to select the required rows of data and copy and paste the information into another software application, such as a spreadsheet. Alternatively add-ons to existing software, such as the Microsoft PowerPivot add-on for Excel, to handle larger data sets, can be used. The Microsoft PowerPivot add-on for Excel is available using the link in the 'Related Links' section below. Once PowerPivot has been installed, to load the large files, please follow the instructions below. Note that it August take at least 20 to 30 minutes to load one monthly file. 1. Start Excel as normal 2. Click on the PowerPivot tab 3. Click on the PowerPivot Window icon (top left) 4. In the PowerPivot Window, click on the "From Other Sources" icon 5. In the Table Import Wizard e.g. scroll to the bottom and select Text File 6. Browse to the file you want to open and choose the file extension you require e.g. CSV Once the data has been imported you can view it in a spreadsheet. What does the data cover? General practice prescribing data is a list of all medicines, dressings and appliances that are prescribed and dispensed each month. A record will only be produced when this has occurred and there is no record for a zero total. For each practice in England, the following information is presented at presentation level for each medicine, dressing and appliance, (by presentation name): - the total number of items prescribed and dispensed - the total net ingredient cost - the total actual cost - the total quantity The data covers NHS prescriptions written in England and dispensed in the community in the UK. Prescriptions written in England but dispensed outside England are included. The data includes prescriptions written by GPs and other non-medical prescribers (such as nurses and pharmacists) who are attached to GP practices. GP practices are identified only by their national code, so an additional data file - linked to the first by the practice code - provides further detail in relation to the practice. Presentations are identified only by their BNF code, so an additional data file - linked to the first by the BNF code - provides the chemical name for that presentation.

Note: Please use the following view to be able to see the entire Dataset Description: https://data.ct.gov/Environment-and-Natural-Resources/Hazardous-Waste-Portal-Manifest-Metadata/x2z6-swxe

Dataset Description Outline (5 sections)

• INTRODUCTION

• WHY USE THE CONNECTICUT OPEN DATA PORTAL MANIFEST METADATA DATASET INSTEAD OF THE DEEP DOCUMENT ONLINE SEARCH PORTAL ITSELF?

• WHAT MANIFESTS ARE INCLUDED IN DEEP’S MANIFEST PERMANENT RECORDS ARE ALSO AVAILABLE VIA THE DEEP DOCUMENT SEARCH PORTAL AND CT OPEN DATA?

• HOW DOES THE PORTAL MANIFEST METADATA DATASET RELATE TO THE OTHER TWO MANIFEST DATASETS PUBLISHED IN CT OPEN DATA?

• IMPORTANT NOTES

INTRODUCTION • All of DEEP’s paper hazardous waste manifest records were recently scanned and “indexed”. • Indexing consisted of 6 basic pieces of information or “metadata” taken from each manifest about the Generator and stored with the scanned image. The metadata enables searches by: Site Town, Site Address, Generator Name, Generator ID Number, Manifest ID Number and Date of Shipment. • All of the metadata and scanned images are available electronically via DEEP’s Document Online Search Portal at: https://filings.deep.ct.gov/DEEPDocumentSearchPortal/ • Therefore, it is no longer necessary to visit the DEEP Records Center in Hartford for manifest records or information. • This CT Data dataset “Hazardous Waste Portal Manifest Metadata” (or “Portal Manifest Metadata”) was copied from the DEEP Document Online Search Portal, and includes only the metadata – no images.

WHY USE THE CONNECTICUT OPEN DATA PORTAL MANIFEST METADATA DATASET INSTEAD OF THE DEEP DOCUMENT ONLINE SEARCH PORTAL ITSELF? The Portal Manifest Metadata is a good search tool to use along with the Portal. Searching the Portal Manifest Metadata can provide the following advantages over searching the Portal: • faster searches, especially for “large searches” - those with a large number of search returns unlimited number of search returns (Portal is limited to 500); • larger display of search returns; • search returns can be sorted and filtered online in CT Data; and • search returns and the entire dataset can be downloaded from CT Data and used offline (e.g. download to Excel format) • metadata from searches can be copied from CT Data and pasted into the Portal search fields to quickly find single scanned images. The main advantages of the Portal are: • it provides access to scanned images of manifest documents (CT Data does not); and • images can be downloaded one or multiple at a time.

WHAT MANIFESTS ARE INCLUDED IN DEEP’S MANIFEST PERMANENT RECORDS ARE ALSO AVAILABLE VIA THE DEEP DOCUMENT SEARCH PORTAL AND CT OPEN DATA? All hazardous waste manifest records received and maintained by the DEEP Manifest Program; including: • manifests originating from a Connecticut Generator or sent to a Connecticut Destination Facility including manifests accompanying an exported shipment • manifests with RCRA hazardous waste listed on them (such manifests may also have non-RCRA hazardous waste listed) • manifests from a Generator with a Connecticut Generator ID number (permanent or temporary number) • manifests with sufficient quantities of RCRA hazardous waste listed for DEEP to consider the Generator to be a Small or Large Quantity Generator • manifests with PCBs listed on them from 2016 to 6-29-2018. • Note: manifests sent to a CT Destination Facility were indexed by the Connecticut or Out of State Generator. Searches by CT Designated Facility are not possible unless such facility is the Generator for the purposes of manifesting.

All other manifests were considered “non-hazardous” manifests and not scanned. They were discarded after 2 years in accord with DEEP records retention schedule. Non-hazardous manifests include: • Manifests with only non-RCRA hazardous waste listed • Manifests from generators that did not have a permanent or temporary Generator ID number • Sometimes non-hazardous manifests were considered “Hazardous Manifests” and kept on file if DEEP had reason to believe the generator should have had a permanent or temporary Generator ID number. These manifests were scanned and included in the Portal.

Dates included: manifests with shipment dates from 1980 to present • States were the primary keepers of manifest records until June 29, 2018. Any manifest regarding a Connecticut Generator or Destination Facility should have been sent to DEEP, and should be present in the Portal and CT Data. • June 30, 2018 was the start of the EPA e-Manifest program. Most manifests with a shipment date on and after this date are sent to, and maintained by the EPA. • For information from EPA regarding these newer manifests: • Overview: https://rcrapublic.epa.gov/rcrainfoweb/action/modules/em/emoverview • To search by site, use EPA’s Sites List: https://rcrapublic.epa.gov/rcrainfoweb/action/modules/hd/handlerindex (Tip: Change the Location field from “National” to “Connecticut”) • Manifests still sent to DEEP on or after 6-30-2018 include: • manifests from exported shipments; and • manifest copies submitted pursuant to discrepancy reports and unmanifested shipments.

HOW DOES THE PORTAL MANIFEST METADATA RELATE TO THE OTHER TWO MANIFEST DATASETS PUBLISHED IN CT DATA? • DEEP has posted in CT Data two other datasets about the same hazardous waste documents which are the subject of the Portal and the Portal Manifest Metadata Copy. • There are likely some differences in the metadata between the Portal Manifest Metadata and the two others. DEEP recommends using all data sources for a complete search. • These two datasets were the best search tool DEEP had available to the public prior to the Portal and the Metadata Copy: • “Hazardous Waste Manifest Data (CT) 1984 – 2008” https://data.ct.gov/Environment-and-Natural-Resources/Hazardous-Waste-Manifest-Data-CT-1984-2008/h6d8-qiar; and • “Hazardous Waste Manifest Data (CT) 1984 – 2008: Generator Summary View” https://data.ct.gov/Environment-and-Natural-Resources/Hazardous-Waste-Manifest-Data-CT-1984-2008-Generat/72mi-3f82.
• The only difference between these two datasets is: • the first dataset includes all of the metadata transcribed from the manifests. • the second “Generator Summary View” dataset is a smaller subset of the first, requested for convenience by the public. Both of these datasets: • Are copies of metadata from a manifest database maintained by DEEP. No scanned images are available as a companion to these datasets. • The date range of the manifests for these datasets is 1984 to approximately 2008.

IMPORTANT NOTES (4): NOTE 1: Some manifest images are effectively unavailable via the Portal and the Portal Metadata due to incomplete or incorrect metadata. Such errors may be the result of unintentional data entry error, errors on the manifests or illegible manifests. • Incomplete or incorrect metadata may prevent a manifest from being found by a search. DEEP is currently working to complete the metadata as best it can. • Please report errors to the DEEP Manifest Program at deep.manifests@ct.gov. • DEEP will publish updates regarding this work here and through the DEEP Hazardous Waste Advisory Committee listserv. To sign up for this listserv, visit this webpage: https://portal.ct.gov/DEEP/Waste-Management-and-Disposal/Hazardous-Waste-Advisory-Committee/HWAC-Home. NOTE 2: This dataset does not replace the potential need for a full review of other files publicly available either on-line and/or at CT DEEP’s Records Center. For a complete review of agency records for this or other agency programs, you can perform your own search in our DEEP public file room located at 79 Elm Street, Hartford CT or at our DEEP Online Search Portal at: https://filings.deep.ct.gov/DEEPDocumentSearchPortal/Home. NOTE 3: Other DEEP programs or state and federal agencies may maintain manifest records (e.g., DEEP Emergency Response, US Environmental Protection Agency, etc.) These other manifests were not scanned along with those from the Manifest Program files. However, most likely these other manifests are duplicate copies of manifests available via the Portal. NOTE 4: search tips for using the Portal and CT Data: • If your search will yield a small number of search returns, try using the Portal for your search. “Small” is meant to mean fewer than the 500 maximum search returns allowed using the Portal. • Start your search as broadly as possible – try entering just the town and the street name, or a portion of the street name that is likely to be spelled correctly • For searches yielding a large number of search returns, try using first the Portal Manifest Metadata in CT Data. • Try downloading the metadata and sorting, filtering, etc. the data to look for related spellings, etc. • Once you narrow down you research, copy the manifest number of a manifest you are interested in, and paste it into the Agency ID field of the Portal search page. • If you are using information from older information sources for consistency, you may want to search the two datasets copied from the older DEEP Manifest Database.

Following a review of our processes, NHS Digital has recently decided to bring forward the publishing date for Practice Level Prescribing data. This data is currently published on the 1st Friday of the month. The February 2017 data will be published on Friday 5 May 2017, however these dates are constantly under review and may move earlier. What does the data cover? General practice prescribing data is a list of all medicines, dressings and appliances that are prescribed and dispensed each month. A record will only be produced when this has occurred and there is no record for a zero total. For each practice in England, the following information is presented at presentation level for each medicine, dressing and appliance, (by presentation name): - the total number of items prescribed and dispensed - the total net ingredient cost - the total actual cost - the total quantity The data covers NHS prescriptions written in England and dispensed in the community in the UK. Prescriptions written in England but dispensed outside England are included. The data includes prescriptions written by GPs and other non-medical prescribers (such as nurses and pharmacists) who are attached to GP practices. GP practices are identified only by their national code, so an additional data file - linked to the first by the practice code - provides further detail in relation to the practice. Presentations are identified only by their BNF code, so an additional data file - linked to the first by the BNF code - provides the chemical name for that presentation. Warning: Large file size (over 1GB). Each monthly data set is large (over 10 million rows), but can be viewed in standard software such as Microsoft WordPad (save by right-clicking on the file name and selecting 'Save Target As', or equivalent on Mac OSX). It is then possible to select the required rows of data and copy and paste the information into another software application, such as a spreadsheet. Alternatively add-ons to existing software, such as the Microsoft PowerPivot add-on for Excel, to handle larger data sets, can be used. The Microsoft PowerPivot add-on for Excel is available using the link in the 'Related Links' section below. Once PowerPivot has been installed, to load the large files, please follow the instructions below. Note that it may take at least 20 to 30 minutes to load one monthly file. 1. Start Excel as normal 2. Click on the PowerPivot tab 3. Click on the PowerPivot Window icon (top left) 4. In the PowerPivot Window, click on the "From Other Sources" icon 5. In the Table Import Wizard e.g. scroll to the bottom and select Text File 6. Browse to the file you want to open and choose the file extension you require e.g. CSV Once the data has been imported you can view it in a spreadsheet.

https://londondatastore-upload.s3.amazonaws.com/gla-custom-age-screen.JPG" alt="Alt text" />

Excel age range creator for GLA Projections data

This Excel based tool enables users to query the raw single year of age data so that any age range can easily be calculated without having to carry out often complex, and time consuming formulas that could also be open to human error. Each year the GLA demography team produce sets of population projections. On this page each of these datasets since 2009 can be accessed, though please remember that the older versions have been superceded. From 2012, data includes population estimates and projections between 2001 and 2041 for each borough plus Central London (Camden, City of London, Kensington & Chelsea, and Westminster), Rest of Inner Boroughs, Inner London, Outer London and Greater London.

The full raw data by single year of age (SYA) and gender are available as Datastore packages at the links below.

How to use the tool: Simply select the lower and upper age range for both males and females (starting in cell C3) and the spreadsheet will return the total population for the range.

Tip: You can copy and paste the boroughs you are interested in to another worksheet by clicking: Edit then Go To (or Control + G), then Special, and Visible cells only. Then simply copy and 'paste values' of the cells to a new location.

Warning: The ethnic group and ward files are large (around 35MB), and may take some time to download depending on your bandwidth.

Find out more about GLA population projections on the GLA Demographic Projections page

BOROUGH PROJECTIONS

GLA 2009 Round London Plan Population Projections (January 2010) (SUPERSEDED)

GLA 2009 Round (revised) London Plan Population Projections (August 2010) (SUPERCEDED)

GLA 2009 Round (revised) SHLAA Population Projections (August 2010) (SUPERCEDED)

GLA 2010 Round SHLAA Population Projections (February 2011) (SUPERCEDED)

GLA 2011 Round SHLAA Population Projections, High Fertility (December 2011) (SUPERCEDED)

GLA 2011 Round SHLAA Population Projections, Standard Fertility (January 2012) (SUPERCEDED)

GLA 2012 Round SHLAA Population Projections, (December 2012)(SUPERCEDED)

GLA 2012 Round Trend Based Population Projections, (December 2012) (SUPERCEDED)

GLA 2012 Round SHLAA Borough Projections incorporating DCLG 2011 household formation rates, (June 2013) (SUPERCEDED)

GLA 2013 Round Trend Based Population Projections - High (December 2013) (SUPERCEDED)

GLA 2013 Round Trend Based Population Projections - Central (December 2013) (SUPERCEDED)

GLA 2013 Round Trend Based Population Projections - Low (December 2013) (SUPERCEDED)

GLA 2013 Round SHLAA Based Population Projections (February 2014) (SUPERCEDED) Spreadsheet now includes national comparator data from ONS.

GLA 2013 Round SHLAA Based Capped Population Projections (March 2014) (SUPERCEDED) Spreadsheet includes national comparator data from ONS.

GLA 2014 Round Trend-based, Short-Term Migration Scenario Population Projections (April 2015) Spreadsheet includes national comparator data from ONS.

GLA 2014 Round Trend-based, Long-Term Migration Scenario Population Projections (April 2015) Spreadsheet includes national comparator data from ONS.

GLA 2014 Round SHLAA DCLG Based Long Term Migration Scenario Population Projections (April 2015) Spreadsheet includes national comparator data from ONS.

GLA 2014 Round SHLAA Capped Household Size Model Short Term Migration Scenario Population Projections (April 2015) Spreadsheet includes national comparator data from ONS. This is the recommended file to use.

WARD PROJECTIONS

GLA 2008 round (High) Ward Projections (March 2009) (SUPERSEDED)

GLA 2009 round (revised) London Plan Ward Projections (August 2010) (SUPERCEDED)

GLA 2010 round SHLAA Ward Projections (February 2011) (SUPERCEDED)

GLA 2011 round SHLAA Standard Ward Projections (January 2012) (SUPERCEDED)

GLA 2011 round SHLAA High Ward Projections (January 2012) (SUPERCEDED)

GLA 2012 round SHLAA based Ward Projections (March 2013) (XLS) (SUPERCEDED)

GLA 2012 round SHLAA Ward Projections (March 2013) (XLS) (SUPERCEDED)

GLA 2013 round SHLAA Ward Projections (March 2014) (SUPERCEDED)

GLA 2013 round SHLAA Capped Ward Projections (March 2014) (SUPERCEDED)

GLA 2014 round SHLAA Capped Household Size Model Short Term Migration Scenario Ward Projections (April 2015) This is the recommended file to use.

ETHNIC GROUP PROJECTIONS FOR LOCAL AUTHORITIES

GLA 2012 Round SHLAA Ethnic Group Borough Projections - Interim (May 2013) (SUPERCEDED)

GLA 2012 Round Trend Based Ethnic Group Borough Projections - Interim (May 2013) (SUPERCEDED)

GLA 2012 Round SHLAA Based Ethnic Group Borough Projections - Final (Nov 2013) (SUPERCEDED)

GLA 2012 Round Trend Based Ethnic Group Borough Projections - Final (Nov 2013) (SUPERCEDED)

GLA 2013 Round SHLAA Capped Ethnic Group Borough Projections (August 2014)

The raw data file is available online for public access (https://data.ontario.ca/dataset/lake-simcoe-monitoring). Download the 1980-2019 csv files and open up the file named "Simcoe_Zooplankton&Bythotrephes.csv". Copy and paste the zooplankton sheet into a new excel file called "Simcoe_Zooplankton.csv". The column ZDATE in the excel file needs to be switched from GENERAL to SHORT DATE so that the dates in the ZDATE column read "YYYY/MM/DD". Save as .csv in appropriate R folder. The data file "simcoe_manual_subset_weeks_5" is the raw data that has been subset for the main analysis of the article using the .R file "Simcoe MS - 5 Station Subset Data". The .csv file produced from this must then be manually edited to remove data points that do not have 5 stations per sampling period as well as by combining data points that should fall into a single week. The "simcoe_manual_subset_weeks_5.csv" is then used for the calculation of variability, stabilization, asynchrony, and Shannon Diversity for each year in the .R file "Simcoe MS - 5 Station Calculations". The final .R file "Simcoe MS - 5 Station Analysis contains the final statistical analyses as well as code to reproduce the original figures. Data and code for main and supplementary analyses are also available on GitHub (https://github.com/reillyoc/ZPseasonalPEs).