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
#> 1              ocp21
#> 2              occ22
#> 3              occ23
#> 4              occ24
#> 5            ocs22mf
#> 6            ocs22bt
#> 7            ocs24mf
#> 8            ocs24bt
#> 9             cu20mf
#> 10            cu20bt
#> 11            cu23mf
#> 12            cu23bt
#> 13              hibp
#> 14             hibsa
#> 15             hibsb
#> 16             hibua
#> 17             hibub
#> 18             hibuc
#> 19             hibud
#> 20             hibue
#> 21             hibuf
#> 22             hibug
#> 23             hibuh
#> 24             hibui
#> 25             hibuj
#> 26             hibuk
#> 27            cihidt
#> 28          cihi820a
#> 29          cihi820b
#> 30           cihi849
#> 31          cihi885a
#> 32          cihi885b
#> 33              mapq
#> 34              otis
#> 35           otisexp
#> 36           otisfin
#> 37           otisloc
#> 38           otisa01
#> 39           otisb01
#> 40           otisb09
#> 41           otisc11
#> 42               siu
#> 43       siumanifest
#> 44        tpsassault
#> 45      tpshomicides
#> 46      tpsshootings
#> 47   naps-co-on-2023
#> 48  naps-no2-ab-2023
#> 49  naps-no2-bc-2023
#> 50  naps-no2-ca-2023
#> 51  naps-no2-ns-2023
#> 52  naps-no2-on-2022
#> 53  naps-no2-on-2023
#> 54  naps-no2-qc-2023
#> 55   naps-o3-ca-2023
#> 56   naps-o3-on-2021
#> 57   naps-o3-on-2022
#> 58   naps-o3-on-2023
#> 59 naps-pm10-on-2023
#> 60 naps-pm25-ab-2023
#> 61 naps-pm25-bc-2023
#> 62 naps-pm25-ca-2023
#> 63 naps-pm25-ns-2023
#> 64 naps-pm25-on-2019
#> 65 naps-pm25-on-2020
#> 66 naps-pm25-on-2021
#> 67 naps-pm25-on-2022
#> 68 naps-pm25-on-2023
#> 69 naps-pm25-qc-2023
#> 70  naps-so2-on-2023
#> 71            cchs22
#>                                                                      name
#> 1                                                    CPADS 2021-2022 PUMF
#> 2                                                      CCS 2018-2022 PUMF
#> 3                                                           CCS 2023 PUMF
#> 4                                                           CCS 2024 PUMF
#> 5                                                    CSADS 2021-2022 PUMF
#> 6                                               CSADS 2021-2022 Bootstrap
#> 7                                                    CSADS 2023-2024 PUMF
#> 8                                               CSADS 2023-2024 Bootstrap
#> 9                                                     CSUS 2019-2020 PUMF
#> 10                                               CSUS 2019-2020 Bootstrap
#> 11                                                         CSUS 2023 PUMF
#> 12                                                    CSUS 2023 Bootstrap
#> 13                                                        CPADS Aggregate
#> 14                                                        CSADS Provinces
#> 15                                                           CSADS Trends
#> 16                                                           CSUS Alcohol
#> 17                                                          CSUS Cannabis
#> 18                                                  CSUS Smoking & Vaping
#> 19                                                CSUS Illegal Substances
#> 20                                                           CSUS Opioids
#> 21                                                      CSUS OTC Products
#> 22                                                     CSUS Polysubstance
#> 23                                                         CSUS Sedatives
#> 24                                                        CSUS Stimulants
#> 25                                               CSUS Substance Use Harms
#> 26                                                         CSUS Treatment
#> 27                                                    CIHI All Indicators
#> 28                                           CIHI 820: Substance Use Harm
#> 29                            CIHI 820: Substance Use Breakdown 2024-2025
#> 30                                             CIHI 849: Alcohol Use Harm
#> 31                                               CIHI 885: Youth Services
#> 32                                        CIHI 885: Youth Sites 2024-2025
#> 33                 MAPQ: Modified Attitudes on Psychedelics Questionnaire
#> 34                        OTIS: Ontario Restrictive Confinement 2023-2025
#> 35                                 OTIS Expanded (1.9M placement records)
#> 36                                     OTIS Complete Analysis Environment
#> 37 OTIS: Ontario's adult provincial correctional institutions (locations)
#> 38                   OTIS a01: Restrictive Confinement - Detailed Dataset
#> 39                               OTIS b01: Segregation - Detailed Dataset
#> 40            OTIS b09: Individuals in Segregation - Number of Placements
#> 41            OTIS c11: Individuals in Segregation/RC by Aggregate Length
#> 42                   SIU director's reports (reviewed corpus, rmoriedata)
#> 43                                         SIU drid manifest (rmoriedata)
#> 44                              TPS Assault open-data events 2014-present
#> 45                            TPS Homicides open-data events 2004-present
#> 46                      TPS Shootings and Firearm Discharges 2004-present
#> 47                                                   NAPS CO Ontario 2023
#> 48                                                  NAPS NO2 Alberta 2023
#> 49                                         NAPS NO2 British Columbia 2023
#> 50                                                   NAPS NO2 Canada 2023
#> 51                                              NAPS NO2 Nova Scotia 2023
#> 52                                                  NAPS NO2 Ontario 2022
#> 53                                                  NAPS NO2 Ontario 2023
#> 54                                                   NAPS NO2 Quebec 2023
#> 55                                                    NAPS O3 Canada 2023
#> 56                                                   NAPS O3 Ontario 2021
#> 57                                                   NAPS O3 Ontario 2022
#> 58                                                   NAPS O3 Ontario 2023
#> 59                                                 NAPS PM10 Ontario 2023
#> 60                                                 NAPS PM25 Alberta 2023
#> 61                                        NAPS PM25 British Columbia 2023
#> 62                                                  NAPS PM25 Canada 2023
#> 63                                             NAPS PM25 Nova Scotia 2023
#> 64                                                 NAPS PM25 Ontario 2019
#> 65                                                 NAPS PM25 Ontario 2020
#> 66                                                 NAPS PM25 Ontario 2021
#> 67                                                 NAPS PM25 Ontario 2022
#> 68                                                 NAPS PM25 Ontario 2023
#> 69                                                  NAPS PM25 Quebec 2023
#> 70                                                  NAPS SO2 Ontario 2023
#> 71                      CCHS 2022 PUMF (Canadian Community Health Survey)
#>        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       otis              correctional  FALSE   NA
#> 38       otis        a01    2023-2025 correctional  FALSE   NA
#> 39       otis        b01    2023-2025 correctional  FALSE   NA
#> 40       otis        b09    2023-2025 correctional  FALSE   NA
#> 41       otis        c11    2023-2025 correctional  FALSE   NA
#> 42 rmoriedata        siu    2005-2026    oversight  FALSE   NA
#> 43 rmoriedata        siu    2005-2026    oversight  FALSE   NA
#> 44        tps    assault 2014-present        crime  FALSE   NA
#> 45        tps  homicides 2004-present        crime  FALSE   NA
#> 46        tps  shootings 2004-present        crime  FALSE   NA
#> 47       naps       naps         2023  air-quality  FALSE   NA
#> 48       naps       naps         2023  air-quality  FALSE   NA
#> 49       naps       naps         2023  air-quality  FALSE   NA
#> 50       naps       naps         2023  air-quality  FALSE   NA
#> 51       naps       naps         2023  air-quality  FALSE   NA
#> 52       naps       naps         2022  air-quality  FALSE   NA
#> 53       naps       naps         2023  air-quality  FALSE   NA
#> 54       naps       naps         2023  air-quality  FALSE   NA
#> 55       naps       naps         2023  air-quality  FALSE   NA
#> 56       naps       naps         2021  air-quality  FALSE   NA
#> 57       naps       naps         2022  air-quality  FALSE   NA
#> 58       naps       naps         2023  air-quality  FALSE   NA
#> 59       naps       naps         2023  air-quality  FALSE   NA
#> 60       naps       naps         2023  air-quality  FALSE   NA
#> 61       naps       naps         2023  air-quality  FALSE   NA
#> 62       naps       naps         2023  air-quality  FALSE   NA
#> 63       naps       naps         2023  air-quality  FALSE   NA
#> 64       naps       naps         2019  air-quality  FALSE   NA
#> 65       naps       naps         2020  air-quality  FALSE   NA
#> 66       naps       naps         2021  air-quality  FALSE   NA
#> 67       naps       naps         2022  air-quality  FALSE   NA
#> 68       naps       naps         2023  air-quality  FALSE   NA
#> 69       naps       naps         2023  air-quality  FALSE   NA
#> 70       naps       naps         2023  air-quality  FALSE   NA
#> 71    statcan       cchs         2022         pumf  FALSE   NA