Posting: Research Manager, York Region District School Board

The York Region District School Board currently has a position posted in their Research Services Department:

Role: Research Manager
Posting details available here
Deadline for submission: August 13, 2020

Qualifications sought include:

  • Education in the field of Education or a relevant social sciences discipline
  • Minimum 10 years of related experience in a school board or other applied research setting
  • Knowledge of statistical data analytic solutions, reserach and program evaluation methods, research ethics, and reseach and accountability issues in education.

 

Posted in Uncategorized | Leave a comment

Posting: Research Officer, Peel District School Board

The Peel District School Board currently has a position posted in their Assessment and Accountability Department:

Role: Research Officer
Posting details avaliable here
Deadline for submission:  August 13, 2020

Qualifications sought include:

  • Education in the fields of Education, Social Science or Sciences
  • 5 to 7 years experience in a research environment, within a school board setting.
  • Advanced Quantitative and Qualitative research design and statistical procedures.
  • Good understanding of equity, anti-oppression and anti-racism frameworks.

 

 

Posted in Uncategorized | Leave a comment

Provincial and Regional COVID19 Visualizations to April 24 and 26

Another week of COVID19 data and another set of updated visuals:

Historical trends across Ontario for cumulative reported cases, deaths and resolved cases on the DUG shiny dashboard, developed and maintained by @GregRousell https://gregrousell.shinyapps.io/COVID-19/

Provincial map of Regional COVID19 reported by Public Health Unit (PHU) on the DUG shiny dashboard. https://gregrousell.shinyapps.io/COVID-19/

Animation of the cumulative number of daily cases reported by Public Health Unit (PHU), @ResearchChat

Plot of the daily cases using a static scale.  This lets you see the scope of the daily cases relative to the other PHUs.  Since Toronto has so many cases, the other PHU distributions are difficult to see.  This is useful to see the magnitude of the reported cases across PHUs.

Plot of the daily cases using a dynamic scale and smoothing.  This lets you see the shape of the daily cases relative to other PHUs.  Some had most of their cases reported early and have few cases reported subsequently (for example Kawartha Pine Ridge and Frontenac and Lennox & Addington), some have had steady increases (for example Toronto and Peel), some have had multiple spikes (bimodal distribution) in reported cases (for example Northwestern Health Unit).

Although the majority of PHUs are reporting COVID19 statistics on their website as HTML text and tables, many are moving to Business Intelligence Tools such as PowerBI and Tableau.

Posted in Uncategorized | Leave a comment

COVID19 Daily Reported Cases Visualization Updates

Following are a few updates of visualizations that were presented last week:

Exploring the shape of distributions of regionally reported cases:

Daily reported cases by region over time using a static scale:

Animation of cumulative daily reported cases by region:

Posted in Uncategorized | Leave a comment

Cases of COVID19 still increasing in Ontario

The Data User Group continues to track and analyze the growth of the pandemic in Ontario.  The following animated visualization designed by @GregRousell depicts the increase in Total Cases, Confirmed Cases, Resolved Cases and Deaths in Ontario:

Posted in Uncategorized | Leave a comment

COVID19 Distributions – Ontario Public Health Units

The same data can be viewed in a variety of ways to support different reflections and discussions. This histogram of the regional distributions of daily reported cases of COVID19 helps you appreciate the volume of cases that the Toronto and Peel Health Units are dealing with…

Whereas this ridgeline plot uses a “free scale”, making the shape of the non-GTA distributions easier to see and consider. Toronto has had a relatively steady increase in the daily reported cases of COVID19. Reported cases for other regions, on the other hand, return more sporadically. This speaks to a variety of considerations including testing capacity, travellers returning home etc.

Posted in Uncategorized | Leave a comment

COVID19 reported cases of Public Health Units by Municipality

Updated with Public Health Unit Labels

Original post with PHU’s labelled by Municipal location:

The animated data visualization above was produced in R using the ggplot2 and gganimate packages with open source data from data.ontario.ca.  Data is current up to April 8, 2020.

Posted in Uncategorized | Leave a comment

COVID19 Data – Regional Explorations in Ontario

One of the challenges to understanding the spread of COVID19 data is the availability of data.  Each day, members of the Data User Group have been updating a CSV file on our Github and a shared Google Sheet with information from the Ontario Ministry of Health’s COVID 19 daily updates.  As the capacity for testing has expanded and the number of identified cases has increased, the once detailed tables of data available on the Ministry website has become daily notices: “Information for all cases today are pending.”

Unfortunately, since the Ministry of Health does not provide updates on the reported cases, every record coded as “pending” effectively becomes missing data.  Fortunately, each of the regional Health Units are providing updates on the numbers of cases on their websites.  These regional updates have been useful to validate and cross-reference the tables that Wikipedia has been maintaining (mentioned in the previous post).  This compiled data set is available in the shared Googles Sheet under the tab “Wikipedia”.

Following are a few of the questions we have explored with the data we have compiled (click on the visual to see it in a larger format):

What are the origins of internationally acquired COVID19 cases in Ontario?


Data source: “Wikipedia” tab in the DUG Google Sheet
Tool: QGIS

Where are the confirmed COVID19 cases in Ontario?

Data source: Github csv
Tool: R – Shiny Dashboard, Interactive Map (Greg Rousell)

What does the growth of COVID19 confirmed cases look like in each region?

Data source: Github csv
Tool: R – Shiny Dashboard, Interactive Plots (Greg Rousell)

 

Data source: “Wikipedia” tab in the DUG Google Sheet
Tool: R

Data Collection Updates

  • Records in the Wikipedia tab of the Google Sheet have been cross-referenced with local media reporting to fill in gaps on the formal Wikipedia site.  Links to the media reports are included in the record as an additional reference and validation.
  • CDUID codes have been added to the records in the Wikipedia tab of the Google Sheet to make it easier to produce maps in GIS platforms.  These CDUID codes correspond to the 2016 Census Divisions managed by Statistics Canada.  The 2016 Statistics Canada Census Division .shp file (polygons) is available here.
  • Some of the data in the Wikipedia tab are reported for aggregated regions.  An .shp file with corresponding merged regions is in development and will be posted shortly.
Posted in Uncategorized | Leave a comment

COVID19 – Understanding Ontario

We are a group of researchers and analysts who are interested in data science and would like to use our expertise to contribute to the understanding of COVID-19 in our communities. 

Looking for data…

One of the challenges we encountered trying to understand the spread of COVID-19 was finding a data source in a format that is easily accessible for analysis.  When we were unable to locate such a file (and finding that the process to scrape data through R was too messy given the formats that the information has been released) we decided to take a manual approach.  Using a few different sources, we have compiled data tables which are easily accessible in R (our favorite) and Python.

…Compiling our own 

DUGroup.ca

March 19, 2020

A COVID19 Googls Sheet for Ontario cases has been created, and is being maintained, with data from an Ontario government website and resources available on two Wikipedia pages. We will continue to update these tables until a more authoritative source of case records is made available, ideally by Public Health Ontario.

 

 

Resources: An invitation to explore and dive deeper

As we explore this data we will be sharing visualizations and insights on the Data User Group website. Our hope is that others will find our summaries useful.  We extend an open invitation to others interested in data science to engage in additional analysis and use this data set for your own exploration.  Resources include:

March 19, 2020

  • A Github has also been created which will include the R code of our members as well as a .csv file that will be updated regularly.  The Google Sheet will serve as our authoritative data source and the github will serve as our central repository for code.  We invite any who are interested to contribute to the github.
  • Shiny app of the github code has been created to provide interactive explorations of the COVID19 data by regional spread. 

Data Background and Sources

The “Provincial Reporting” tab in the Google Sheet is a compilation of data from this Ontario government website.  This webpage provides a table on new cases of COVID-19 diagnosed in the province.  Following are notes about the data:

  • Using the Wayback Machine, the earliest records that could be obtained began at case 32.  
  • The first 31 cases were then compiled by parsing the press releases available at the bottom of the page.  
  • Currently, case numbers 6, 16, 17 and 18 have not been found in the available press releases.  
  • Coding with respect to regional health unit appears to have changed over time.  A new column has been added with recoded health unit labels for consistency. 
  • On March 18th the website stopped posting the hospitals the cases are related to.
  • The data in the Google Sheet is updated daily from this website, around 10:30 am and 5:30 pm when the data is released.

The “Wikipedia” tab in the Google Sheet is a compilation of data from Wikipedia’s Thematic Google Map.  Included in this map are interactive summaries by region which includes the number of cases, number of patients in local hospitals and buildings that have been impacted.  Following are notes about the data that is published on this page:

  • The data in the Google Sheet is updated daily from this website.
  • Wikipedia also provides a table  with time-series data for the spread of COVID-19 for each province. The data from this website is available in “Wikipedia National” tab in the Google Sheet and is updated less frequently than the other two tabs.

 

Posted in Uncategorized | Leave a comment

Job Posting: Research Analyst, Durham District School Board

A posting is now open until February 8, 2019 for a Research Analyst contract position at the Durham District School Board.  The start date for this position is to be determined.  This posting can be viewed on and applied to through applytoeducation.com.

Click here for more information

Summary of the Research Analyst: This position will take a lead role in a project … as part of the Ontario Education Equity Action Plan.

Reports To: Administrative Officer, Accountability and Assessment.

 

Posted in Uncategorized | Leave a comment