Scrape Ontario SIU Director's Reports into a tidy CSV
Source:R/siu_fetch.R
morie_siu_fetch_cases.RdPulls the SIU index, walks every linked case-detail page, and writes a
six-column CSV (case_number, police_service,
incident_iso, notification_iso, decision_iso,
director_decision_text, source_url) into
cache_dir.
Arguments
- years
Integer vector of fiscal years to scrape, or
NULL(default) to scrape the unfiltered index. Years above2023(the latest published as of release) may return empty results.- cache_dir
Output directory. Default
file.path(tempdir(), "morie", "siu"); passmorie_cache_dir("siu")for persistent caching.- overwrite
Logical; if
FALSEandSIU.csvalready exists, its path is returned without re-scraping.- progress
Logical; print a one-line status per index / case fetch when
TRUE(default).
Details
This is the lightweight R-only path. For the full 64-column corpus
use morie_fetch_siu (compiled C++ harvester).
Examples
# \donttest{
# Network: scrapes the SIU index (~5-15 min at the polite rate).
csv <- morie_siu_fetch_cases(cache_dir = tempfile("siu_"))
#> SIU: wrote the panel-reviewed corpus from rmoriedata (4613 rows) to /tmp/RtmpNbJQ2u/siu_2cd22878f84e/SIU.csv. For a live re-fetch set options(morie.siu.allow_fetch = TRUE).
utils::head(utils::read.csv(csv))
#> case_number drid nrid
#> 1 17-OVI-201 46 3135
#> 2 17-OVI-201 47 3136
#> 3 17-TVI-108 48 3035
#> 4 17-TVI-108 65 3036
#> 5 17-TCI-209 66 4504
#> 6 17-TCI-209 67 4505
#> source_url_report
#> 1 https://www.siu.on.ca/en/directors_report_details.php?drid=46
#> 2 https://www.siu.on.ca/en/directors_report_details.php?drid=47
#> 3 https://www.siu.on.ca/en/directors_report_details.php?drid=48
#> 4 https://www.siu.on.ca/en/directors_report_details.php?drid=65
#> 5 https://www.siu.on.ca/en/directors_report_details.php?drid=66
#> 6 https://www.siu.on.ca/en/directors_report_details.php?drid=67
#> source_url_news
#> 1 https://www.siu.on.ca/en/news_template.php?nrid=3135
#> 2 https://www.siu.on.ca/en/news_template.php?nrid=3136
#> 3 https://www.siu.on.ca/en/news_template.php?nrid=3035
#> 4 https://www.siu.on.ca/en/news_template.php?nrid=3036
#> 5 https://www.siu.on.ca/en/news_template.php?nrid=4504
#> 6 https://www.siu.on.ca/en/news_template.php?nrid=4505
#> scraped_at_utc parser_version date_of_incident_iso
#> 1 2026-05-06T21:26:07+00:00 0.1.0 2017-08-03
#> 2 2026-05-06T21:26:07+00:00 0.1.0 2017-08-03
#> 3 2026-05-06T21:26:07+00:00 0.1.0 2017-05-11
#> 4 2026-05-06T21:26:07+00:00 0.1.0 2017-05-11
#> 5 2026-05-06T21:26:07+00:00 0.1.0 2017-08-12
#> 6 2026-05-06T21:26:08+00:00 0.1.0 2017-08-12
#> date_of_incident_raw time_of_incident_raw date_of_injury_iso
#> 1 August 3 2017 NA NA
#> 2 NA NA
#> 3 May 11 2017 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> date_of_injury_raw incident_to_injury_raw date_siu_notified_iso
#> 1 NA NA 2017-08-03
#> 2 NA NA 2017-08-03
#> 3 NA NA 2017-05-11
#> 4 NA NA 2017-05-11
#> 5 NA NA 2017-08-13
#> 6 NA NA 2017-08-13
#> date_siu_notified_raw time_of_notification_raw notifying_party
#> 1 August 3 2017 NA Guelph Police Service
#> 2 NA
#> 3 May 11 2017 NA Toronto Police Service
#> 4 NA
#> 5 August 13 2017 NA Toronto Police Service
#> 6 NA
#> notifying_party_other_text date_of_director_decision_iso
#> 1 NA 2018-06-27
#> 2 NA 2018-06-27
#> 3 NA 2018-03-13
#> 4 NA 2018-03-13
#> 5 NA 2018-04-09
#> 6 NA 2018-04-09
#> date_of_director_decision_raw time_of_director_decision_raw siu_investigators
#> 1 June 27 2018 NA 3
#> 2 NA 3
#> 3 March 13 2018 NA 6
#> 4 NA 6
#> 5 April 9 2018 NA 2
#> 6 NA 2
#> siu_forensics_investigators police_service
#> 1 2 Guelph Police Service
#> 2 2 Service de police de Guelph
#> 3 2 Toronto Police Service
#> 4 2 Service de police de Toronto
#> 5 1 Toronto Police Service
#> 6 1 Service de police de Toronto
#> number_of_officers_involved
#> 1 1
#> 2 1
#> 3 1
#> 4 1
#> 5 1
#> 6 1
#> location_of_call
#> 1 1499 Gordon Street in the City of Guelph
#> 2
#> 3 Bloor Street West between Gladstone Avenue and Dufferin Street, in Toronto
#> 4
#> 5 City of Toronto
#> 6
#> type_of_building_or_scene reason_for_interaction injuries_sustained
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> injuries_other_text
#> 1 NA
#> 2 NA
#> 3 NA
#> 4 NA
#> 5 NA
#> 6 NA
#> specific_injuries
#> 1 concussion and whiplash injury as well as trauma to the front of the mouth for which he had a tooth
#> 2
#> 3 fracture to his L2 vertebrae
#> 4
#> 5 fracture to his face
#> 6
#> location_of_treatment number_of_affected_persons sex_gender_affected
#> 1 NA NA male
#> 2 NA NA male
#> 3 NA NA male
#> 4 NA NA male
#> 5 NA NA male
#> 6 NA NA male
#> age_affected affected_interviewed date_of_affected_interview_iso
#> 1 18 NA NA
#> 2 18 NA NA
#> 3 23 NA NA
#> 4 23 NA NA
#> 5 35 NA NA
#> 6 35 NA NA
#> date_of_affected_interview_raw number_of_civilian_witnesses
#> 1 NA 6
#> 2 NA 6
#> 3 NA 3
#> 4 NA 3
#> 5 NA 3
#> 6 NA 3
#> date_of_witness_interview_raw number_of_subject_officials
#> 1 NA 1
#> 2 NA 1
#> 3 NA 1
#> 4 NA 1
#> 5 NA 1
#> 6 NA 1
#> subject_official_interviewed_or_notes date_of_subject_interview_raw
#> 1 Yes NA
#> 2 Yes NA
#> 3 Yes NA
#> 4 Yes NA
#> 5 Yes NA
#> 6 Yes NA
#> number_of_witness_officials date_of_witness_official_interview_raw
#> 1 4 NA
#> 2 4 NA
#> 3 6 NA
#> 4 6 NA
#> 5 2 NA
#> 6 2 NA
#> evidence_types evidence_other_text evidence_features
#> 1 NA NA NA
#> 2 NA NA NA
#> 3 NA NA NA
#> 4 NA NA NA
#> 5 NA NA NA
#> 6 NA NA NA
#> narrative_summary
#> 1 Just prior to 10:00 a.m. on August 3rd, 2017, three men attempted to rob the Scotia Bank on Clair Road in the City of Guelph. As the bank had not yet opened for business, the suspects were unable to gain access and left the bank empty handed. Photographs of the suspects leaving the bank were captured on devices operated by bank staff, and descriptions of the culprits and their motor vehicle, a Volkswagen Jetta, were immediately broadcast throughout the city of Guelph resulting in a massive police response to the area. The suspects then drove north on Gordon Street, the main road through Guelph, and went on to rob the RBC . During the robbery, the suspects were reported as indicating that they were armed with firearms and would be willing to shoot anyone in the bank if they did not cooperate. After that robbery, the suspects drove south on Gordon Street directly into a heavy police presence due to police having responded to the reporting of the first attempted robbery.
#> 2 Le 3 août 2017, peu après 10 h du matin, trois hommes masqués ont tenté de cambrioler la succursale de la Banque Scotia sur Clair Road, dans la ville de Guelph. Comme la banque n'avait pas encore ouvert ses portes, les suspects n'ont pas pu entrer et sont repartis bredouilles. Un membre du personnel de la banque a pris des photographies des suspects quittant la banque. La description des coupables et de leur véhicule, une Volkswagen Jetta, a été immédiatement diffusée par radio à toutes les unités de police dans la ville de Guelph, et de nombreux policiers se sont donc rendus dans le secteur. Les suspects se sont dirigés en voiture vers le nord sur la rue Gordon, la principale artère qui traverse Guelph, pour cambrioler la RBC . Des témoins ont signalé que lors de ce cambriolage de la banque, les suspects ont dit qu'ils étaient armés et que si on ne leur obéissait pas, ils étaient prêts à tirer. Après ce braquage, les suspects sont repartis sur la rue Gordon en direction sud, où se trouvaient de nombreux policiers alertés par la première tentative de cambriolage.
#> 3 On May 11th, 2017, shortly before 4:00 a.m., the Complainant was driving a white Chevrolet Cruze southbound on Lansdowne Avenue and turned left to travel eastbound on Lappin Avenue. The Complainant had a passenger in his vehicle. According to the SO and WO #1, the Complainant cut the corner to travel eastbound on Lappin Avenue whereupon he entered the oncoming lane of traffic and was driving toward the police officers, who were travelling westbound on Lappin Avenue toward the intersection. The Complainant then corrected and his vehicle returned to its proper lane. The Complainant then stopped on Lappin Avenue to drop off his passenger. The police vehicle conducted a U-turn to pull up behind the Complainant's vehicle. The Complainant moved off, increased his speed, and turned onto a side street. The Complainant continued driving and eventually turned a corner at a high rate of speed, lost control of his vehicle, and collided with a Toronto Public Library ( TPL ) building.
#> 4 Le 11 mai 2017, peu avant 4 h, le plaignant conduisait une Chevrolet Cruze blanche en direction sud sur l'avenue Lansdowne et a tourné à gauche pour se rendre dans la direction est sur l'avenue Lappin. Le plaignant avait un passager à bord de son véhicule. D'après l' AI et l' AT no 1, le plaignant a coupé le coin pour se diriger vers l'est sur l'avenue Lappin, auquel moment il est entré dans la voie opposée et s'approchait des agents de police, qui se déplaçaient en direction ouest sur l'avenue Lappin vers l'intersection. Puis, le plaignant a redressé le véhicule et est retourné dans la voie correcte. Ensuite, le plaignant s'est arrêté sur l'avenue Lappin pour déposer son passager. Le véhicule de police a fait demi tour pour s'approcher du véhicule du plaignant par derrière. Le plaignant a accéléré pour s'éloigner rapidement et a tourné dans une rue latérale. Le plaignant a continué de rouler et à un moment donné, a tourné un coin à un taux de vitesse élevé, a perdu le contrôle de son véhicule et a percuté un bâtiment abritant la Bibliothèque publique de Toronto ( BPT ).
#> 5 On Saturday, August 12th, 2017, at approximately 10:30 p.m., the SO and WO #1 met with a ten-year-old girl at the police station. The ten-year-old girl told the SO and WO #1 that she was sexually assaulted by a black man [later identified as the Complainant] while getting off an elevator at her apartment building located in the City of Toronto. The SO and WO #1 attended the apartment building and met with two building security officers who showed the police officers the CCTV recordings from the elevator and identified the man in the video as the Complainant, who was known to them. The SO and WO #1 attended the Complainant's apartment and spoke with him outside his apartment. They told the Complainant that he was being arrested for sexually assaulting a ten-year-old girl. The Complainant began to resist the two police officers. After a brief struggle, the Complainant was arrested and placed in a police cruiser. The Complainant indicated to the police officer than he was experiencing pain to his face, and he was transported to hospital.
#> 6 Le samedi 12 août 2017, vers 22 h 30, l' AI et l' AT no 1 ont rencontré une fillette de dix ans au poste de police. La fillette de dix ans a dit à l' AI et à l' AT no 1 qu'un homme de race noire [plus tard identifié comme étant le plaignant] l'avait agressée sexuellement, alors qu'elle sortait d'un ascenseur dans son immeuble d'appartements situé dans la ville de Toronto. L' AI et l' AT no 1 se sont rendus à l'immeuble d'habitation et ont rencontré deux agents de sécurité de l'immeuble qui ont montré aux agents de police les enregistrements de TVCF de l'ascenseur et ont identifié l'homme dans la vidéo comme étant le plaignant, lequel était connu des agents de police. L' AI et l' AT no 1 se sont rendus à l'appartement du plaignant et lui ont parlé à l'extérieur de son appartement. Ils ont dit au plaignant qu'il était arrêté pour avoir agressé sexuellement une fillette de dix ans. Le plaignant a commenté à résister aux deux agents de police.
#> relevant_legislation
#> 1 Criminal Code
#> 2
#> 3 Sections 1-3, Ontario Regulation 266/10, Ontario Police Services Act; Section 25(1), Criminal Code; Section 249, Criminal Code; Section 216(1), Highway Traffic Act of Ontario
#> 4
#> 5 Criminal Code
#> 6
#> legislation_other_text weapons_or_force_used weapons_other_text
#> 1 NA NA NA
#> 2 NA NA NA
#> 3 NA NA NA
#> 4 NA NA NA
#> 5 NA NA NA
#> 6 NA NA NA
#> charges_recommended
#> 1 FALSE
#> 2 FALSE
#> 3 NA
#> 4 NA
#> 5 FALSE
#> 6 FALSE
#> directors_decision_reasonable
#> 1
#> 2
#> 3 On the evidence before me, I find that I have reasonable grounds to believe that the Complainant’s injury was caused by the motor vehicle collision based on the following evidence: the expert medical opinion as to the mechanism of his injury; the comments made by the Complainant, as overheard by an independent civilian witness, that he had sustained his injury as a result of being involved in a “c
#> 4 On the evidence before me, I find that I have reasonable grounds to believe that the Complainant’s injury was caused by the motor vehicle collision based on the following evidence: the expert medical opinion as to the mechanism of his injury; the comments made by the Complainant, as overheard by an independent civilian witness, that he had sustained his injury as a result of being involved in a “c
#> 5 While the evidence of the Complainant that he was immediately punched in the face by both the SO and WO #1, one in each eye, as soon as he exited his apartment, and that the SO thereafter grabbed the Complainant by the back of his neck and slammed his head against the wall, and then took the Complainant to the ground and repeatedly struck him on his upper torso with his fist, if accepted, would un
#> 6 While the evidence of the Complainant that he was immediately punched in the face by both the SO and WO #1, one in each eye, as soon as he exited his apartment, and that the SO thereafter grabbed the Complainant by the back of his neck and slammed his head against the wall, and then took the Complainant to the ground and repeatedly struck him on his upper torso with his fist, if accepted, would un
#> supplemental_materials news_links_extra mental_health_or_race_indications
#> 1 NA Black
#> 2 NA
#> 3 NA
#> 4 NA
#> 5 NA Black
#> 6 NA
#> X_language
#> 1 en
#> 2 fr
#> 3 en
#> 4 fr
#> 5 en
#> 6 fr
#> news_release_title
#> 1 SIU Investigation Started following Bank Robbery and Crash in Guelph
#> 2 L’UES ouvre une enquête à la suite d’un vol de banque et d’une collision à Guelph
#> 3 SIU Investigating Incident in which a Vehicle Crashed into a Toronto Public Library Building
#> 4 L’UES enquête sur un incident dans lequel un véhicule s’est écrasé contre un bâtiment de la Bibliothèque publique de Toronto
#> 5 No Criminal Wrongdoing on Part of Officers in Relation to Man’s Arrest at Toronto Apartment
#> 6 Aucun agissement criminel de la part d'agents de police relativement à l'arrestation d'un homme dans un appartement à Toronto
#> news_release_date_iso news_release_date_raw
#> 1 2017-08-03 3 August, 2017
#> 2
#> 3 2017-05-11 11 May, 2017
#> 4
#> 5 2018-12-11 11 December, 2018
#> 6
#> news_release_summary
#> 1 The province’s Special Investigations Unit is examining the circumstances surrounding an incident in which a young man was seriously injured following a bank robbery in Guelph.
#> 2
#> 3 Ontario’s Special Investigations Unit is examining the circumstances surrounding an early morning incident in which a vehicle crashed into a Toronto Public Library building.
#> 4
#> 5 The Director of the Special Investigations Unit, Tony Loparco, has determined there are no reasonable grounds to lay criminal charges against a Toronto Police Service officer in relation to the serious injury sustained by a 35-year-old man during his arrest in August of 2017.
#> 6
#> directors_name panel_reviewed corrigenda
#> 1 Tony Loparco TRUE
#> 2 Tony Loparco FALSE
#> 3 Tony Loparco TRUE
#> 4 Tony Loparco FALSE
#> 5 Tony Loparco TRUE
#> 6 Tony Loparco FALSE
# }