Quebec ERs, week by week

Name: Quebec ERs, week by week
Creator: Urgences Québec
License: https://creativecommons.org/licenses/by/4.0/

The ministry’s ER file only ever shows the current hour. We’ve been saving every hour of it since August 10 for the Urgences Québec app, so here it is rolled up by week (Monday to Sunday). The bars are the average stretcher occupancy across every ER and every hour they reported; over 100% means more people on stretchers than there are stretchers.

Week of	Average occupancy	Hours at 100% or more	Waiting (avg)	Present (avg)	Ambulatory stay (h)
Sep 28	85.3 %	44.8 %	12.2	34.6	4.6
Sep 21	83.8 %	44 %	11.5	33.9	4.5
Sep 14	85.6 %	46.1 %	12	34.3	4.6
Sep 7	84.1 %	45.3 %	12	34.5	4.7
Aug 31	82 %	41.6 %	11.8	33.6	4.5
Aug 24	81.2 %	41.6 %	11.8	33.3	4.7
Aug 17	80.8 %	41.3 %	12.2	33.6	4.8
Aug 10	83.2 %	43.1 %	12.7	34.4	4.7

The fullest ERs, week of Sep 28

(an ER needs at least 84 reported hours that week to make the list)

ER	Region	Average occupancy	Change from the week before	Hours at 100% or more
Hôpital Royal Victoria	Montréal	214.5 %	-11.7	168
Hôpital général juif	Montréal	202.2 %	+2.2	167
Hôpital général du Lakeshore	Montréal	178.3 %	-5.3	168
Hôpital de la Cité-de-la-Santé	Laval	169.7 %	+9.4	167
Hôpital et CLSC de Sept-Îles	Côte-Nord	166.1 %	-21.9	167
Hôpital général de Montréal	Montréal	162.2 %	+35.1	168
Hôpital de Saint-Eustache	Laurentides	155.6 %	+14.2	168
Hôpital de Lachine	Montréal	153 %	+14.2	168
Hôpital de Saint-Georges	Chaudière-Appalaches	152.9 %	+6.8	165
Hôtel-Dieu de Sorel	Montérégie	151.3 %	+32.7	161

Download

hebdo-quebec.csv — one row per week, all of Quebec (8)
hebdo-urgences.csv — one row per ER per week (960)

Both files rebuild every week. Hourly raw data is on GitHub if you want it.

Licence

CC BY 4.0, so use it in a story, a thesis, whatever. The underlying MSSS data on Données Québec is under the same licence. If you use it, credit “MSSS, compiled by the Urgences Québec app (sante.handled.tools/en/hebdo)”.

A couple of caveats. Occupancy is crowding, not how long you’ll wait, triage takes the sickest first. Six hospitals don’t report anything and are left out. Week one starts August 10 at 2 pm because that’s when we started.

The app

The site already does the real-time numbers, the map and the which-ER-to-drive-to part.

It opens from an icon, no address to type. And whatever you loaded last is still there when the signal drops, which it does in most hospital basements.

The app is free to download and everything inside it is free too: the wait times, the clinics, the surgery lists, one ER's last seven days with the hours it is usually quietest, and your own ERs pinned to the top of the list. No subscription, nothing left to unlock.

View on the App Store

On the App Store it is called "Urgences Québec: temps attente".