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 (5157 rows) to /tmp/RtmpOKyZlD/siu_2e2639b34b80/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 1 NA
#> 2 2 NA
#> 3 3 NA
#> 4 4 NA
#> 5 5 NA
#> 6 6 NA
#> source_url_report source_url_news
#> 1 https://www.siu.on.ca/en/directors_report_details.php?drid=1
#> 2 https://www.siu.on.ca/en/directors_report_details.php?drid=2
#> 3 https://www.siu.on.ca/en/directors_report_details.php?drid=3
#> 4 https://www.siu.on.ca/en/directors_report_details.php?drid=4
#> 5 https://www.siu.on.ca/en/directors_report_details.php?drid=5
#> 6 https://www.siu.on.ca/en/directors_report_details.php?drid=6
#> scraped_at_utc parser_version date_of_incident_iso
#> 1 2026-05-06T21:26:06+00:00 0.1.0
#> 2 2026-05-06T21:26:06+00:00 0.1.0
#> 3 2026-05-06T21:26:06+00:00 0.1.0
#> 4 2026-05-06T21:26:06+00:00 0.1.0
#> 5 2026-05-06T21:26:06+00:00 0.1.0
#> 6 2026-05-06T21:26:06+00:00 0.1.0
#> date_of_incident_raw time_of_incident_raw date_of_injury_iso
#> 1 NA NA
#> 2 NA NA
#> 3 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
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> date_siu_notified_raw time_of_notification_raw notifying_party
#> 1 NA
#> 2 NA
#> 3 NA
#> 4 NA
#> 5 NA
#> 6 NA
#> notifying_party_other_text date_of_director_decision_iso
#> 1 NA
#> 2 NA
#> 3 NA
#> 4 NA
#> 5 NA
#> 6 NA
#> date_of_director_decision_raw time_of_director_decision_raw siu_investigators
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> siu_forensics_investigators police_service number_of_officers_involved
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> location_of_call type_of_building_or_scene reason_for_interaction
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> injuries_sustained injuries_other_text specific_injuries
#> 1 NA
#> 2 NA
#> 3 NA
#> 4 NA
#> 5 NA
#> 6 NA
#> location_of_treatment number_of_affected_persons sex_gender_affected
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> age_affected affected_interviewed date_of_affected_interview_iso
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> date_of_affected_interview_raw number_of_civilian_witnesses
#> 1 NA
#> 2 NA
#> 3 NA
#> 4 NA
#> 5 NA
#> 6 NA
#> date_of_witness_interview_raw number_of_subject_officials
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> subject_official_interviewed_or_notes date_of_subject_interview_raw
#> 1 NA
#> 2 NA
#> 3 NA
#> 4 NA
#> 5 NA
#> 6 NA
#> number_of_witness_officials date_of_witness_official_interview_raw
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA 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 Special Investigations Unit -- Director's Report Details, Case Number: Careers Sitemap Français 1.800.787.8529 The Unit The Unit What We Can Investigate Investigative Process Our Staff SIU General and Operational Policies Legislation Shaping Civilian Oversight Media Centre Media Centre News Releases Status of SIU Cases Breakdown of Occurrences SIU on X Email Alerts - News Releases Media Contact Access to Information FAQs Case Numbers Public Reports Public Reports Director's Reports SIU Annual Report 2024-2025 Analysis of Special Investigations Unit Race-Based Data The SIU and Race-based Data Collection, Backgrounder SIU Director’s Expense Report Brochures 2025/26 – 2027/28 Special Investigations Unit Business Plan Accessibility Multi-Year Plan SIU-MAG Memorandum of Understanding Programs and Services Programs and Services Affected Persons Program Outreach Program Director's Resource Committee First Nations, Inuit and Métis Liaison Program Race-Based Data Collection Accessibility Careers Contact Us I Have Been Seriously Injured I've Witnessed an Incident SIU Outreach Request Contact Us Video/Photo Uploads Useful Links Home Public Reports Director's Report Details Public Reports Public Reports Director's Reports SIU Annual Report 2024-2025 Analysis of Special Investigations Unit Race-Based Data The SIU and Race-based Data Collection, Backgrounder SIU Director’s Expense Report Brochures 2025/26 – 2027/28 Special Investigations Unit Business Plan Accessibility Multi-Year Plan SIU
#> 2 Special Investigations Unit -- Director's Report Details, Case Number: Careers Sitemap Français 1.800.787.8529 The Unit The Unit What We Can Investigate Investigative Process Our Staff SIU General and Operational Policies Legislation Shaping Civilian Oversight Media Centre Media Centre News Releases Status of SIU Cases Breakdown of Occurrences SIU on X Email Alerts - News Releases Media Contact Access to Information FAQs Case Numbers Public Reports Public Reports Director's Reports SIU Annual Report 2024-2025 Analysis of Special Investigations Unit Race-Based Data The SIU and Race-based Data Collection, Backgrounder SIU Director’s Expense Report Brochures 2025/26 – 2027/28 Special Investigations Unit Business Plan Accessibility Multi-Year Plan SIU-MAG Memorandum of Understanding Programs and Services Programs and Services Affected Persons Program Outreach Program Director's Resource Committee First Nations, Inuit and Métis Liaison Program Race-Based Data Collection Accessibility Careers Contact Us I Have Been Seriously Injured I've Witnessed an Incident SIU Outreach Request Contact Us Video/Photo Uploads Useful Links Home Public Reports Director's Report Details Public Reports Public Reports Director's Reports SIU Annual Report 2024-2025 Analysis of Special Investigations Unit Race-Based Data The SIU and Race-based Data Collection, Backgrounder SIU Director’s Expense Report Brochures 2025/26 – 2027/28 Special Investigations Unit Business Plan Accessibility Multi-Year Plan SIU
#> 3 Special Investigations Unit -- Director's Report Details, Case Number: Careers Sitemap Français 1.800.787.8529 The Unit The Unit What We Can Investigate Investigative Process Our Staff SIU General and Operational Policies Legislation Shaping Civilian Oversight Media Centre Media Centre News Releases Status of SIU Cases Breakdown of Occurrences SIU on X Email Alerts - News Releases Media Contact Access to Information FAQs Case Numbers Public Reports Public Reports Director's Reports SIU Annual Report 2024-2025 Analysis of Special Investigations Unit Race-Based Data The SIU and Race-based Data Collection, Backgrounder SIU Director’s Expense Report Brochures 2025/26 – 2027/28 Special Investigations Unit Business Plan Accessibility Multi-Year Plan SIU-MAG Memorandum of Understanding Programs and Services Programs and Services Affected Persons Program Outreach Program Director's Resource Committee First Nations, Inuit and Métis Liaison Program Race-Based Data Collection Accessibility Careers Contact Us I Have Been Seriously Injured I've Witnessed an Incident SIU Outreach Request Contact Us Video/Photo Uploads Useful Links Home Public Reports Director's Report Details Public Reports Public Reports Director's Reports SIU Annual Report 2024-2025 Analysis of Special Investigations Unit Race-Based Data The SIU and Race-based Data Collection, Backgrounder SIU Director’s Expense Report Brochures 2025/26 – 2027/28 Special Investigations Unit Business Plan Accessibility Multi-Year Plan SIU
#> 4 Special Investigations Unit -- Director's Report Details, Case Number: Careers Sitemap Français 1.800.787.8529 The Unit The Unit What We Can Investigate Investigative Process Our Staff SIU General and Operational Policies Legislation Shaping Civilian Oversight Media Centre Media Centre News Releases Status of SIU Cases Breakdown of Occurrences SIU on X Email Alerts - News Releases Media Contact Access to Information FAQs Case Numbers Public Reports Public Reports Director's Reports SIU Annual Report 2024-2025 Analysis of Special Investigations Unit Race-Based Data The SIU and Race-based Data Collection, Backgrounder SIU Director’s Expense Report Brochures 2025/26 – 2027/28 Special Investigations Unit Business Plan Accessibility Multi-Year Plan SIU-MAG Memorandum of Understanding Programs and Services Programs and Services Affected Persons Program Outreach Program Director's Resource Committee First Nations, Inuit and Métis Liaison Program Race-Based Data Collection Accessibility Careers Contact Us I Have Been Seriously Injured I've Witnessed an Incident SIU Outreach Request Contact Us Video/Photo Uploads Useful Links Home Public Reports Director's Report Details Public Reports Public Reports Director's Reports SIU Annual Report 2024-2025 Analysis of Special Investigations Unit Race-Based Data The SIU and Race-based Data Collection, Backgrounder SIU Director’s Expense Report Brochures 2025/26 – 2027/28 Special Investigations Unit Business Plan Accessibility Multi-Year Plan SIU
#> 5 Special Investigations Unit -- Director's Report Details, Case Number: Careers Sitemap Français 1.800.787.8529 The Unit The Unit What We Can Investigate Investigative Process Our Staff SIU General and Operational Policies Legislation Shaping Civilian Oversight Media Centre Media Centre News Releases Status of SIU Cases Breakdown of Occurrences SIU on X Email Alerts - News Releases Media Contact Access to Information FAQs Case Numbers Public Reports Public Reports Director's Reports SIU Annual Report 2024-2025 Analysis of Special Investigations Unit Race-Based Data The SIU and Race-based Data Collection, Backgrounder SIU Director’s Expense Report Brochures 2025/26 – 2027/28 Special Investigations Unit Business Plan Accessibility Multi-Year Plan SIU-MAG Memorandum of Understanding Programs and Services Programs and Services Affected Persons Program Outreach Program Director's Resource Committee First Nations, Inuit and Métis Liaison Program Race-Based Data Collection Accessibility Careers Contact Us I Have Been Seriously Injured I've Witnessed an Incident SIU Outreach Request Contact Us Video/Photo Uploads Useful Links Home Public Reports Director's Report Details Public Reports Public Reports Director's Reports SIU Annual Report 2024-2025 Analysis of Special Investigations Unit Race-Based Data The SIU and Race-based Data Collection, Backgrounder SIU Director’s Expense Report Brochures 2025/26 – 2027/28 Special Investigations Unit Business Plan Accessibility Multi-Year Plan SIU
#> 6 Special Investigations Unit -- Director's Report Details, Case Number: Careers Sitemap Français 1.800.787.8529 The Unit The Unit What We Can Investigate Investigative Process Our Staff SIU General and Operational Policies Legislation Shaping Civilian Oversight Media Centre Media Centre News Releases Status of SIU Cases Breakdown of Occurrences SIU on X Email Alerts - News Releases Media Contact Access to Information FAQs Case Numbers Public Reports Public Reports Director's Reports SIU Annual Report 2024-2025 Analysis of Special Investigations Unit Race-Based Data The SIU and Race-based Data Collection, Backgrounder SIU Director’s Expense Report Brochures 2025/26 – 2027/28 Special Investigations Unit Business Plan Accessibility Multi-Year Plan SIU-MAG Memorandum of Understanding Programs and Services Programs and Services Affected Persons Program Outreach Program Director's Resource Committee First Nations, Inuit and Métis Liaison Program Race-Based Data Collection Accessibility Careers Contact Us I Have Been Seriously Injured I've Witnessed an Incident SIU Outreach Request Contact Us Video/Photo Uploads Useful Links Home Public Reports Director's Report Details Public Reports Public Reports Director's Reports SIU Annual Report 2024-2025 Analysis of Special Investigations Unit Race-Based Data The SIU and Race-based Data Collection, Backgrounder SIU Director’s Expense Report Brochures 2025/26 – 2027/28 Special Investigations Unit Business Plan Accessibility Multi-Year Plan SIU
#> relevant_legislation legislation_other_text weapons_or_force_used
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> weapons_other_text charges_recommended directors_decision_reasonable
#> 1 NA
#> 2 NA
#> 3 NA
#> 4 NA
#> 5 NA
#> 6 NA
#> supplemental_materials news_links_extra mental_health_or_race_indications
#> 1 NA
#> 2 NA
#> 3 NA
#> 4 NA
#> 5 NA
#> 6 NA
#> X_language news_release_title news_release_date_iso news_release_date_raw
#> 1 unknown
#> 2 unknown
#> 3 unknown
#> 4 unknown
#> 5 unknown
#> 6 unknown
#> news_release_summary directors_name panel_reviewed
#> 1 FALSE
#> 2 FALSE
#> 3 FALSE
#> 4 FALSE
#> 5 FALSE
#> 6 FALSE
# }