Skip to contents

List all datasets with cache status

Usage

morie_list_datasets(db_path = NULL, con = NULL)

Arguments

db_path

Optional path to a SQLite/DuckDB file (default backend).

con

Optional pre-opened DBI connection (overrides db_path).

Value

A data.frame with columns: key, name, source, survey, year, type, cached (logical), rows (integer or NA).

Examples

morie_list_datasets()
#>             key                                                        name
#> 1         ocp21                                        CPADS 2021-2022 PUMF
#> 2         occ22                                          CCS 2018-2022 PUMF
#> 3         occ23                                               CCS 2023 PUMF
#> 4         occ24                                               CCS 2024 PUMF
#> 5       ocs22mf                                        CSADS 2021-2022 PUMF
#> 6       ocs22bt                                   CSADS 2021-2022 Bootstrap
#> 7       ocs24mf                                        CSADS 2023-2024 PUMF
#> 8       ocs24bt                                   CSADS 2023-2024 Bootstrap
#> 9        cu20mf                                         CSUS 2019-2020 PUMF
#> 10       cu20bt                                    CSUS 2019-2020 Bootstrap
#> 11       cu23mf                                              CSUS 2023 PUMF
#> 12       cu23bt                                         CSUS 2023 Bootstrap
#> 13         hibp                                             CPADS Aggregate
#> 14        hibsa                                             CSADS Provinces
#> 15        hibsb                                                CSADS Trends
#> 16        hibua                                                CSUS Alcohol
#> 17        hibub                                               CSUS Cannabis
#> 18        hibuc                                       CSUS Smoking & Vaping
#> 19        hibud                                     CSUS Illegal Substances
#> 20        hibue                                                CSUS Opioids
#> 21        hibuf                                           CSUS OTC Products
#> 22        hibug                                          CSUS Polysubstance
#> 23        hibuh                                              CSUS Sedatives
#> 24        hibui                                             CSUS Stimulants
#> 25        hibuj                                    CSUS Substance Use Harms
#> 26        hibuk                                              CSUS Treatment
#> 27       cihidt                                         CIHI All Indicators
#> 28     cihi820a                                CIHI 820: Substance Use Harm
#> 29     cihi820b                 CIHI 820: Substance Use Breakdown 2024-2025
#> 30      cihi849                                  CIHI 849: Alcohol Use Harm
#> 31     cihi885a                                    CIHI 885: Youth Services
#> 32     cihi885b                             CIHI 885: Youth Sites 2024-2025
#> 33         mapq      MAPQ: Modified Attitudes on Psychedelics Questionnaire
#> 34         otis             OTIS: Ontario Restrictive Confinement 2023-2025
#> 35      otisexp                      OTIS Expanded (1.9M placement records)
#> 36      otisfin                          OTIS Complete Analysis Environment
#> 37      otisa01        OTIS a01: Restrictive Confinement - Detailed Dataset
#> 38      otisb01                    OTIS b01: Segregation - Detailed Dataset
#> 39      otisb09 OTIS b09: Individuals in Segregation - Number of Placements
#> 40      otisc11 OTIS c11: Individuals in Segregation/RC by Aggregate Length
#> 41          siu       Ontario SIU: case-level investigations (2014-present)
#> 42   tpsassault                   TPS Assault open-data events 2014-present
#> 43 tpshomicides                 TPS Homicides open-data events 2004-present
#> 44 tpsshootings           TPS Shootings and Firearm Discharges 2004-present
#>    source     survey         year         type cached rows
#> 1      oc      cpads    2021-2022         pumf  FALSE   NA
#> 2      oc        ccs    2018-2022         pumf  FALSE   NA
#> 3      oc        ccs         2023         pumf  FALSE   NA
#> 4      oc        ccs         2024         pumf  FALSE   NA
#> 5      oc      csads    2021-2022         pumf  FALSE   NA
#> 6      oc      csads    2021-2022    bootstrap  FALSE   NA
#> 7      oc      csads    2023-2024         pumf  FALSE   NA
#> 8      oc      csads    2023-2024    bootstrap  FALSE   NA
#> 9      oc       csus    2019-2020         pumf  FALSE   NA
#> 10     oc       csus    2019-2020    bootstrap  FALSE   NA
#> 11     oc       csus         2023         pumf  FALSE   NA
#> 12     oc       csus         2023    bootstrap  FALSE   NA
#> 13    hib      cpads                 aggregate  FALSE   NA
#> 14    hib      csads                 aggregate  FALSE   NA
#> 15    hib      csads                 aggregate  FALSE   NA
#> 16    hib       csus                 aggregate  FALSE   NA
#> 17    hib       csus                 aggregate  FALSE   NA
#> 18    hib       csus                 aggregate  FALSE   NA
#> 19    hib       csus                 aggregate  FALSE   NA
#> 20    hib       csus                 aggregate  FALSE   NA
#> 21    hib       csus                 aggregate  FALSE   NA
#> 22    hib       csus                 aggregate  FALSE   NA
#> 23    hib       csus                 aggregate  FALSE   NA
#> 24    hib       csus                 aggregate  FALSE   NA
#> 25    hib       csus                 aggregate  FALSE   NA
#> 26    hib       csus                 aggregate  FALSE   NA
#> 27   cihi indicators                 indicator  FALSE   NA
#> 28   cihi indicators                 indicator  FALSE   NA
#> 29   cihi indicators    2024-2025    indicator  FALSE   NA
#> 30   cihi indicators                 indicator  FALSE   NA
#> 31   cihi indicators                 indicator  FALSE   NA
#> 32   cihi indicators    2024-2025    indicator  FALSE   NA
#> 33    vsr       mapq         2026 psychometric  FALSE   NA
#> 34    vsr       otis    2023-2025 correctional  FALSE   NA
#> 35    vsr       otis    2023-2025 correctional  FALSE   NA
#> 36    vsr       otis    2023-2025 correctional  FALSE   NA
#> 37   otis        a01    2023-2025 correctional  FALSE   NA
#> 38   otis        b01    2023-2025 correctional  FALSE   NA
#> 39   otis        b09    2023-2025 correctional  FALSE   NA
#> 40   otis        c11    2023-2025 correctional  FALSE   NA
#> 41    vsr        siu 2014-present    oversight  FALSE   NA
#> 42    tps    assault 2014-present        crime  FALSE   NA
#> 43    tps  homicides 2004-present        crime  FALSE   NA
#> 44    tps  shootings 2004-present        crime  FALSE   NA