{
  "_id": "6a10a8b1acfb0bcc41cbd50f",
  "Package": "allofus",
  "Type": "Package",
  "Title": "Interface for 'All of Us' Researcher Workbench",
  "Version": "1.2.0",
  "Authors@R": "c(\nperson(\"Louisa\", \"Smith\", email = \"l.smith@northeastern.edu\", role = c(\"aut\", \"cph\"), comment = c(ORCID = \"0000-0001-9029-4644\")),\nperson(\"Rob\", \"Cavanaugh\", email = \"r.cavanaugh@northeastern.edu\", role = c(\"aut\", \"cre\", \"cph\"), comment = c(ORCID = \"0000-0002-2114-6565\"))\n)",
  "Description": "Streamline use of the 'All of Us' Researcher Workbench\n(<https://www.researchallofus.org/data-tools/workbench/>)with\ntools to extract and manipulate data from the 'All of Us'\ndatabase. Increase interoperability with the Observational\nHealth Data Science and Informatics ('OHDSI') tool stack by\ndecreasing reliance of 'All of Us' tools and allowing for\ncohort creation via 'Atlas'. Improve reproducible and\ntransparent research using 'All of Us'.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "LazyData": "true",
  "RoxygenNote": "7.3.2",
  "URL": "https://roux-ohdsi.github.io/allofus/,\nhttps://github.com/roux-ohdsi/allofus",
  "BugReports": "https://github.com/roux-ohdsi/allofus/issues",
  "VignetteBuilder": "knitr",
  "Config/testthat/edition": "3",
  "Roxygen": "list(markdown = TRUE)",
  "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev libssl-dev",
  "Repository": "https://roux-ohdsi.r-universe.dev",
  "Date/Publication": "2025-09-02 21:06:29 UTC",
  "RemoteUrl": "https://github.com/roux-ohdsi/allofus",
  "RemoteRef": "HEAD",
  "RemoteSha": "aeeada29431b27129363054a8c33abe7a62716b8",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-02 15:53:40 UTC",
    "User": "root"
  },
  "Author": "Louisa Smith [aut, cph] (ORCID:\n<https://orcid.org/0000-0001-9029-4644>),\nRob Cavanaugh [aut, cre, cph] (ORCID:\n<https://orcid.org/0000-0002-2114-6565>)",
  "Maintainer": "Rob Cavanaugh <r.cavanaugh@northeastern.edu>",
  "MD5sum": "bba8a3fbbab5f2049c06564a968f75f0",
  "_user": "roux-ohdsi",
  "_type": "src",
  "_file": "allofus_1.2.0.tar.gz",
  "_fileid": "0f03e97c1666b6857fe43219d63ca623fc77021e243bcff751008a411645feb0",
  "_filesize": 3600016,
  "_sha256": "0f03e97c1666b6857fe43219d63ca623fc77021e243bcff751008a411645feb0",
  "_created": "2026-05-02T15:53:40.000Z",
  "_published": "2026-06-01T07:13:16.049Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77443508162,
      "time": 142,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6764088210"
    },
    {
      "job": 77443508594,
      "time": 154,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6764089425"
    },
    {
      "job": 77443508547,
      "time": 159,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6764164330"
    },
    {
      "job": 77443508271,
      "time": 210,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6764120050"
    },
    {
      "job": 77443508043,
      "time": 225,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6764075312"
    },
    {
      "job": 77443507918,
      "time": 157,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7168222617"
    },
    {
      "job": 77443508360,
      "time": 220,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6764095254"
    },
    {
      "job": 77443508632,
      "time": 80,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6764082635"
    },
    {
      "job": 77443508385,
      "time": 97,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6764084229"
    }
  ],
  "_buildurl": "https://github.com/r-universe/roux-ohdsi/actions/runs/25255705163",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/roux-ohdsi/allofus",
  "_commit": {
    "id": "aeeada29431b27129363054a8c33abe7a62716b8",
    "author": "Louisa Smith <louisahsmith@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Include participant-mediated EHR in observation period",
    "time": 1756847189
  },
  "_maintainer": {
    "name": "Rob Cavanaugh",
    "email": "r.cavanaugh@northeastern.edu",
    "login": "rbcavanaugh",
    "uuid": 46727239,
    "orcid": "0000-0002-2114-6565"
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 2.10",
      "role": "Depends"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "magrittr",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "version": ">= 1.1.4",
      "role": "Imports"
    },
    {
      "package": "glue",
      "role": "Imports"
    },
    {
      "package": "bigrquery",
      "version": ">= 1.5.1",
      "role": "Imports"
    },
    {
      "package": "purrr",
      "role": "Imports"
    },
    {
      "package": "stats",
      "role": "Imports"
    },
    {
      "package": "utils",
      "role": "Imports"
    },
    {
      "package": "dbplyr",
      "version": ">= 2.5.0",
      "role": "Imports"
    },
    {
      "package": "sessioninfo",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "lifecycle",
      "role": "Imports"
    },
    {
      "package": "bit64",
      "role": "Imports"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "kableExtra",
      "role": "Suggests"
    },
    {
      "package": "DT",
      "role": "Suggests"
    },
    {
      "package": "googlesheets4",
      "role": "Suggests"
    },
    {
      "package": "tibble",
      "role": "Suggests"
    },
    {
      "package": "forcats",
      "role": "Suggests"
    },
    {
      "package": "gh",
      "role": "Suggests"
    },
    {
      "package": "SqlRender",
      "version": ">= 1.6.0",
      "role": "Suggests"
    }
  ],
  "_owner": "roux-ohdsi",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-36",
      "n": 1
    }
  ],
  "_tags": [],
  "_stars": 19,
  "_contributors": [
    {
      "user": "louisahsmith",
      "count": 184,
      "uuid": 8386603
    },
    {
      "user": "rbcavanaugh",
      "count": 164,
      "uuid": 46727239
    },
    {
      "user": "yonghaoy",
      "count": 1,
      "uuid": 6351731
    }
  ],
  "_userbio": {
    "uuid": 97252065,
    "type": "organization",
    "name": "OHDSI Center at the Roux Institute"
  },
  "_downloads": {
    "count": 1022,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/allofus"
  },
  "_devurl": "https://github.com/roux-ohdsi/allofus",
  "_searchresults": 35,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/allofus.html",
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/roux-ohdsi/allofus",
  "_realowner": "roux-ohdsi",
  "_cranurl": true,
  "_releases": [
    {
      "version": "1.0.0",
      "date": "2023-12-21"
    },
    {
      "version": "1.1.0",
      "date": "2024-04-04"
    },
    {
      "version": "1.2.0",
      "date": "2024-11-06"
    }
  ],
  "_exports": [
    "%>%",
    "aou_atlas_cohort",
    "aou_bucket_to_workspace",
    "aou_collect",
    "aou_compute",
    "aou_concept_set",
    "aou_connect",
    "aou_create_temp_table",
    "aou_join",
    "aou_ls_bucket",
    "aou_ls_workspace",
    "aou_observation_period",
    "aou_session_info",
    "aou_sql",
    "aou_survey",
    "aou_tables",
    "aou_workspace_to_bucket",
    "on_workbench"
  ],
  "_datasets": [
    {
      "name": "aou_codebook",
      "title": "All of Us Modified Codebook",
      "object": "aou_codebook",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "concept_code",
        "concept_id",
        "concept_name",
        "concept_class_id",
        "field_type",
        "field_label",
        "choices",
        "standard_concept",
        "valid_start_date",
        "valid_end_date",
        "form_name",
        "link"
      ],
      "rows": 702,
      "table": true,
      "tojson": true
    },
    {
      "name": "aou_cohort_example",
      "title": "Example cohort definition and SQL query from ATLAS",
      "object": "aou_cohort_example",
      "class": [
        "list"
      ],
      "fields": [],
      "table": false,
      "tojson": true
    },
    {
      "name": "aou_concept_codes",
      "title": "Concept codes and survey answers",
      "object": "aou_concept_codes",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "code",
        "answer"
      ],
      "rows": 196,
      "table": true,
      "tojson": true
    },
    {
      "name": "aou_health_history",
      "title": "All of Us Health History Codebook",
      "object": "aou_health_history",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "question",
        "relative",
        "condition",
        "category",
        "concept_code",
        "concept_id_specific",
        "concept_id_overall",
        "concept_id_question",
        "concept_id_rx_meds",
        "concept_id_on_txt",
        "concept_id_age_diagnosis",
        "concept_code_rx_meds",
        "concept_code_on_txt",
        "concept_code_age_diagnosis",
        "form_name"
      ],
      "rows": 1703,
      "table": true,
      "tojson": true
    },
    {
      "name": "aou_table_info",
      "title": "Table of tables, columns, and use for researchers from the CT data dictionary",
      "object": "aou_table_info",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "table_name",
        "columns",
        "recommended_for_research"
      ],
      "rows": 69,
      "table": true,
      "tojson": true
    }
  ],
  "_help": [
    {
      "page": "aou_atlas_cohort",
      "title": "Retrieve a cohort from ATLAS for use in All of Us",
      "topics": [
        "aou_atlas_cohort"
      ]
    },
    {
      "page": "aou_bucket_to_workspace",
      "title": "Move files from a bucket to your workspace",
      "topics": [
        "aou_bucket_to_workspace"
      ]
    },
    {
      "page": "aou_codebook",
      "title": "All of Us Modified Codebook",
      "topics": [
        "aou_codebook"
      ]
    },
    {
      "page": "aou_collect",
      "title": "Collect a tbl object and convert integer64 columns to double",
      "topics": [
        "aou_collect"
      ]
    },
    {
      "page": "aou_compute",
      "title": "Compute a dplyr tbl SQL query into a temp table",
      "topics": [
        "aou_compute"
      ]
    },
    {
      "page": "aou_concept_codes",
      "title": "Concept codes and survey answers",
      "topics": [
        "aou_concept_codes"
      ]
    },
    {
      "page": "aou_concept_set",
      "title": "Get occurrences of a concept set from AoU for a given cohort",
      "topics": [
        "aou_concept_set"
      ]
    },
    {
      "page": "aou_connect",
      "title": "Create a connection to the database in All of Us",
      "topics": [
        "aou_connect"
      ]
    },
    {
      "page": "aou_create_temp_table",
      "title": "Creates a temporary table from a local data frame or tibble",
      "topics": [
        "aou_create_temp_table"
      ]
    },
    {
      "page": "aou_health_history",
      "title": "All of Us Health History Codebook",
      "topics": [
        "aou_health_history"
      ]
    },
    {
      "page": "aou_join",
      "title": "Join current query to another table",
      "topics": [
        "aou_join"
      ]
    },
    {
      "page": "aou_ls_bucket",
      "title": "List the current files in your bucket",
      "topics": [
        "aou_ls_bucket"
      ]
    },
    {
      "page": "aou_ls_workspace",
      "title": "List the current files in your workspace",
      "topics": [
        "aou_ls_workspace"
      ]
    },
    {
      "page": "aou_observation_period",
      "title": "Generate an observation period table",
      "topics": [
        "aou_observation_period"
      ]
    },
    {
      "page": "aou_session_info",
      "title": "Print session information for the AoU R environment",
      "topics": [
        "aou_session_info"
      ]
    },
    {
      "page": "aou_sql",
      "title": "Execute a SQL query on the All of Us database",
      "topics": [
        "aou_sql"
      ]
    },
    {
      "page": "aou_survey",
      "title": "Function to query allofus observation table for survey responses",
      "topics": [
        "aou_survey"
      ]
    },
    {
      "page": "aou_table_info",
      "title": "Table of tables, columns, and use for researchers from the CT data dictionary",
      "topics": [
        "aou_table_info"
      ]
    },
    {
      "page": "aou_tables",
      "title": "List tables in the AoU Database",
      "topics": [
        "aou_tables"
      ]
    },
    {
      "page": "aou_workspace_to_bucket",
      "title": "Save a file from your workspace to your bucket",
      "topics": [
        "aou_workspace_to_bucket"
      ]
    }
  ],
  "_readme": "https://github.com/roux-ohdsi/allofus/raw/HEAD/README.md",
  "_rundeps": [
    "askpass",
    "bigrquery",
    "bit",
    "bit64",
    "blob",
    "brio",
    "cli",
    "clock",
    "cpp11",
    "curl",
    "DBI",
    "dbplyr",
    "dplyr",
    "fs",
    "gargle",
    "generics",
    "glue",
    "httr",
    "jsonlite",
    "lifecycle",
    "magrittr",
    "mime",
    "nanoparquet",
    "openssl",
    "pillar",
    "pkgconfig",
    "prettyunits",
    "purrr",
    "R6",
    "rapidjsonr",
    "rappdirs",
    "rlang",
    "sessioninfo",
    "stringi",
    "stringr",
    "sys",
    "tibble",
    "tidyr",
    "tidyselect",
    "tzdb",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "allofus.Rmd",
      "filename": "allofus.html",
      "title": "All of Us in R",
      "engine": "knitr::rmarkdown",
      "headings": [
        "The Basics",
        "Installing and Loading allofus",
        "Accessing Data",
        "Connecting to the database",
        "Accessing a table",
        "Data manipulation on the database",
        "The collect() Function",
        "Data manipulation with multiple tables",
        "aou_join()",
        "Joins from different sources?",
        "Viewing the Underlying SQL with show_query()",
        "Running SQL code directly"
      ],
      "created": "2023-12-18 18:33:55",
      "modified": "2024-08-22 13:29:25",
      "commits": 4
    },
    {
      "source": "data.Rmd",
      "filename": "data.html",
      "title": "Extracting All of Us survey and EHR data",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Survey data",
        "EHR data",
        "Health history survey data"
      ],
      "created": "2023-12-18 18:33:55",
      "modified": "2024-08-02 16:13:04",
      "commits": 7
    },
    {
      "source": "workspace.Rmd",
      "filename": "workspace.html",
      "title": "Managing files on the workbench",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Listing Files",
        "In Your Workspace",
        "In Your Bucket",
        "Transferring Files",
        "From Workspace to Bucket",
        "From Bucket to Workspace",
        "Workflow Example",
        "Important Considerations"
      ],
      "created": "2023-12-18 18:33:55",
      "modified": "2023-12-19 19:03:03",
      "commits": 2
    },
    {
      "source": "atlas.Rmd",
      "filename": "atlas.html",
      "title": "Using ATLAS to create a cohort",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2023-12-18 18:33:55",
      "modified": "2024-08-22 13:29:25",
      "commits": 4
    }
  ],
  "_score": 6.434332532429761,
  "_indexed": true,
  "_nocasepkg": "allofus",
  "_universes": [
    "roux-ohdsi",
    "rbcavanaugh"
  ],
  "_progress_url": "https://github.com/r-universe/roux-ohdsi/actions/runs/26740626983",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.2.0",
      "date": "2026-06-01T07:18:35.000Z",
      "distro": "noble",
      "commit": "aeeada29431b27129363054a8c33abe7a62716b8",
      "fileid": "b06497ab251da0e4e7335016c430d207d4a5b3452d9b468a2e23d6f0f3393264",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/roux-ohdsi/actions/runs/26740626983"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.2.0",
      "date": "2026-06-01T07:18:49.000Z",
      "distro": "noble",
      "commit": "aeeada29431b27129363054a8c33abe7a62716b8",
      "fileid": "8d7def5d4c078ee62ecf90b970cc5e9d6524bfa3c8282d66d93a766f76e947b7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/roux-ohdsi/actions/runs/26740626983"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.2.0",
      "date": "2026-06-01T07:35:24.000Z",
      "commit": "aeeada29431b27129363054a8c33abe7a62716b8",
      "fileid": "288557427039fa94a3bdcb349eb7e34a5bca24e97315839ca110f4e6461a13b0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/roux-ohdsi/actions/runs/26740626983"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.2.0",
      "date": "2026-06-01T07:37:11.000Z",
      "commit": "aeeada29431b27129363054a8c33abe7a62716b8",
      "fileid": "33ace9fd9337ea7cc81b5b693c1ba641ec8aa7627997bde166c5e590b7151c96",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/roux-ohdsi/actions/runs/26740626983"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.2.0",
      "date": "2026-06-01T07:18:40.000Z",
      "commit": "aeeada29431b27129363054a8c33abe7a62716b8",
      "fileid": "a74a3435093c10740f1e6d299cc55e7485b4c7037ab028f3440116416dcfcdd5",
      "status": "success",
      "buildurl": "https://github.com/r-universe/roux-ohdsi/actions/runs/26740626983"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.2.0",
      "date": "2026-06-01T07:17:30.000Z",
      "commit": "aeeada29431b27129363054a8c33abe7a62716b8",
      "fileid": "cc48a7db0320e0f30874085bd35296aed39e432d57c6c8a1669e985dd1fa7968",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/roux-ohdsi/actions/runs/26740626983"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.2.0",
      "date": "2026-06-01T07:17:29.000Z",
      "commit": "aeeada29431b27129363054a8c33abe7a62716b8",
      "fileid": "4703c3b8d3ffd25c5c83d7012831a1cdf293a65c3ba59d6fde0b47d74e2f4080",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/roux-ohdsi/actions/runs/26740626983"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.2.0",
      "date": "2026-06-01T07:18:30.000Z",
      "commit": "aeeada29431b27129363054a8c33abe7a62716b8",
      "fileid": "1d5d64df1f8edc044f921097ea54dd29df931e1e4bbdea976c63c9806095381b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/roux-ohdsi/actions/runs/26740626983"
    }
  ]
}