{
  "_id": "6a18a7e3acfb0bcc41dc91e6",
  "Package": "healthdb",
  "Type": "Package",
  "Title": "Working with Healthcare Databases",
  "Version": "0.5.1.9000",
  "Authors@R": "person(\"Kevin\", \"Hu\",\nemail = \"kevin.hu@bccdc.ca\",\nrole = c(\"aut\", \"cre\", \"cph\"),\ncomment = c(ORCID = \"0000-0003-0254-5277\"))",
  "Description": "A system for identifying diseases or events from\nhealthcare databases and preparing data for epidemiological\nstudies. It includes capabilities not supported by 'SQL', such\nas matching strings by 'stringr' style regular expressions, and\ncan compute comorbidity scores (Quan et al. (2005)\n<doi:10.1097/01.mlr.0000182534.19832.83>) directly on a\ndatabase server. The implementation is based on 'dbplyr' with\nfull 'tidyverse' compatibility.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "URL": "https://github.com/KevinHzq/healthdb,\nhttps://kevinhzq.github.io/healthdb/",
  "BugReports": "https://github.com/KevinHzq/healthdb/issues",
  "Config/testthat/edition": "3",
  "VignetteBuilder": "knitr",
  "Config/roxygen2/version": "8.0.0",
  "Config/pak/sysreqs": "libicu-dev",
  "Repository": "https://kevinhzq.r-universe.dev",
  "Date/Publication": "2026-05-28 18:20:27 UTC",
  "RemoteUrl": "https://github.com/kevinhzq/healthdb",
  "RemoteRef": "HEAD",
  "RemoteSha": "160d1bba61064f9b82a939d3eddd11d2aceb62c6",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-28 20:35:26 UTC",
    "User": "root"
  },
  "Author": "Kevin Hu [aut, cre, cph] (ORCID:\n<https://orcid.org/0000-0003-0254-5277>)",
  "Maintainer": "Kevin Hu <kevin.hu@bccdc.ca>",
  "MD5sum": "363f89ed99d540eb7ccc23db4b7846d2",
  "_user": "kevinhzq",
  "_type": "src",
  "_file": "healthdb_0.5.1.9000.tar.gz",
  "_fileid": "fa0897540ca3d2bcb5f7ee1486eff7bdd706a27b8342e220803d471ddb429671",
  "_filesize": 363030,
  "_sha256": "fa0897540ca3d2bcb5f7ee1486eff7bdd706a27b8342e220803d471ddb429671",
  "_created": "2026-05-28T20:35:26.000Z",
  "_published": "2026-05-28T20:38:59.840Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 78383317217,
      "time": 169,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7276776670"
    },
    {
      "job": 78383317183,
      "time": 159,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7276773211"
    },
    {
      "job": 78383317194,
      "time": 137,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7276777574"
    },
    {
      "job": 78383317173,
      "time": 121,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7276762272"
    },
    {
      "job": 78382732792,
      "time": 203,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7276721345"
    },
    {
      "job": 78383317147,
      "time": 128,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7276763154"
    },
    {
      "job": 78383317182,
      "time": 118,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7276760246"
    },
    {
      "job": 78383317196,
      "time": 105,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7276756223"
    },
    {
      "job": 78383317197,
      "time": 131,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7276764804"
    }
  ],
  "_buildurl": "https://github.com/r-universe/kevinhzq/actions/runs/26600517538",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/kevinhzq/healthdb",
  "_commit": {
    "id": "160d1bba61064f9b82a939d3eddd11d2aceb62c6",
    "author": "KevinHzq <38960619+KevinHzq@users.noreply.github.com>",
    "committer": "KevinHzq <38960619+KevinHzq@users.noreply.github.com>",
    "message": "Increment version number to 0.5.1.9000\n",
    "time": 1779992427
  },
  "_maintainer": {
    "name": "Kevin Hu",
    "email": "kevin.hu@bccdc.ca",
    "orcid": "0000-0003-0254-5277"
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "clock",
      "role": "Imports"
    },
    {
      "package": "data.table",
      "version": ">= 1.18.4",
      "role": "Imports"
    },
    {
      "package": "dbplyr",
      "version": ">= 2.5.1",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "version": ">= 1.1.0",
      "role": "Imports"
    },
    {
      "package": "glue",
      "role": "Imports"
    },
    {
      "package": "lubridate",
      "role": "Imports"
    },
    {
      "package": "magrittr",
      "role": "Imports"
    },
    {
      "package": "purrr",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "version": ">= 1.5.0",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    }
  ],
  "_owner": "kevinhzq",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-47",
      "n": 5
    },
    {
      "week": "2025-48",
      "n": 1
    },
    {
      "week": "2025-52",
      "n": 3
    },
    {
      "week": "2026-01",
      "n": 1
    },
    {
      "week": "2026-02",
      "n": 1
    },
    {
      "week": "2026-20",
      "n": 1
    },
    {
      "week": "2026-22",
      "n": 3
    }
  ],
  "_tags": [
    {
      "name": "v0.5.0",
      "date": "2025-12-30"
    },
    {
      "name": "v0.5.1",
      "date": "2026-05-26"
    }
  ],
  "_stars": 2,
  "_contributors": [
    {
      "user": "kevinhzq",
      "count": 25,
      "uuid": 38960619
    },
    {
      "user": "hadley",
      "count": 1,
      "uuid": 4196
    }
  ],
  "_userbio": {
    "uuid": 38960619,
    "type": "user",
    "name": "KevinHzq"
  },
  "_downloads": {
    "count": 211,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/healthdb"
  },
  "_devurl": "https://github.com/kevinhzq/healthdb",
  "_pkgdown": "https://kevinhzq.github.io/healthdb/",
  "_searchresults": 4,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/healthdb.html",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/kevinhzq/healthdb",
  "_realowner": "kevinhzq",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2024-04-27"
    },
    {
      "version": "0.2.0",
      "date": "2024-05-05"
    },
    {
      "version": "0.3.0",
      "date": "2024-05-16"
    },
    {
      "version": "0.3.1",
      "date": "2024-05-23"
    },
    {
      "version": "0.4.0",
      "date": "2025-02-28"
    },
    {
      "version": "0.4.1",
      "date": "2025-04-05"
    },
    {
      "version": "0.5.0",
      "date": "2026-01-08"
    },
    {
      "version": "0.5.1",
      "date": "2026-05-26"
    }
  ],
  "_exports": [
    "%>%",
    "bind_source",
    "build_def",
    "collapse_episode",
    "compute_comorbidity",
    "compute_duration",
    "cut_period",
    "define_case",
    "define_case_with_age",
    "exclude",
    "execute_def",
    "fetch_var",
    "identify_row",
    "if_date",
    "lookup",
    "make_test_dat",
    "pool_case",
    "report_n",
    "restrict_date",
    "restrict_n"
  ],
  "_help": [
    {
      "page": "bind_source",
      "title": "Row-bind a list of data.frames or remote tables with variable selection and renaming",
      "topics": [
        "bind_source"
      ]
    },
    {
      "page": "build_def",
      "title": "Build case definition function calls",
      "topics": [
        "build_def"
      ]
    },
    {
      "page": "collapse_episode",
      "title": "Group records no more than n days apart as episodes",
      "topics": [
        "collapse_episode"
      ]
    },
    {
      "page": "compute_comorbidity",
      "title": "Compute Elixhauser Comorbidity Index",
      "topics": [
        "compute_comorbidity"
      ]
    },
    {
      "page": "compute_duration",
      "title": "Compute duration between two dates",
      "topics": [
        "compute_duration"
      ]
    },
    {
      "page": "cut_period",
      "title": "Cut the time period in one row into multiple rows by interval",
      "topics": [
        "cut_period"
      ]
    },
    {
      "page": "define_case",
      "title": "Identify diseases/events from administrative records",
      "topics": [
        "define_case"
      ]
    },
    {
      "page": "define_case_with_age",
      "title": "Identify diseases/events from administrative records with age restriction",
      "topics": [
        "define_case_with_age"
      ]
    },
    {
      "page": "exclude",
      "title": "Remove rows based on conditions or another data set",
      "topics": [
        "exclude"
      ]
    },
    {
      "page": "execute_def",
      "title": "Execute parameterized case definitions",
      "topics": [
        "execute_def"
      ]
    },
    {
      "page": "fetch_var",
      "title": "Get variables from multiple tables with common ID columns",
      "topics": [
        "fetch_var"
      ]
    },
    {
      "page": "identify_row",
      "title": "Identify rows with a match",
      "topics": [
        "identify_row"
      ]
    },
    {
      "page": "if_date",
      "title": "Interpret if any n elements drawn from a date vector could be some days apart within some time span",
      "topics": [
        "if_date"
      ]
    },
    {
      "page": "lookup",
      "title": "Find value corresponding to the input vector using a look-up table",
      "topics": [
        "lookup"
      ]
    },
    {
      "page": "make_test_dat",
      "title": "Make test data",
      "topics": [
        "make_test_dat"
      ]
    },
    {
      "page": "pool_case",
      "title": "Pool qualified clients from results of multiple definitions",
      "topics": [
        "pool_case"
      ]
    },
    {
      "page": "report_n",
      "title": "Report number of distinct value in a column across data frames",
      "topics": [
        "report_n"
      ]
    },
    {
      "page": "restrict_date",
      "title": "Remove or flag groups failed to meet conditions based on dates",
      "topics": [
        "restrict_date"
      ]
    },
    {
      "page": "restrict_n",
      "title": "Remove or flag groups with n less than some number",
      "topics": [
        "restrict_n"
      ]
    }
  ],
  "_pkglogo": "https://github.com/kevinhzq/healthdb/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/kevinhzq/healthdb/raw/HEAD/README.md",
  "_rundeps": [
    "blob",
    "cli",
    "clock",
    "cpp11",
    "data.table",
    "DBI",
    "dbplyr",
    "dplyr",
    "generics",
    "glue",
    "lifecycle",
    "lubridate",
    "magrittr",
    "pillar",
    "pkgconfig",
    "purrr",
    "R6",
    "rlang",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "timechange",
    "tzdb",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "healthdb.Rmd",
      "filename": "healthdb.html",
      "title": "Introduction to healthdb",
      "engine": "knitr::rmarkdown",
      "headings": [
        "What it does",
        "Motivation",
        "Installation",
        "Intended use case",
        "make_test_dat() makes either a toy data.frame or database table in memory with known number of rows that satisfy the query we will show later",
        "this is a database table",
        "note that in-memory SQLite database stores dates as numbers",
        "this is a local data.frame/tibble",
        "convert Date to numeric to be consistent with claim_db",
        "Interactive functions",
        "here we use filter mode to remove records that failed the restriction",
        "here we use flag mode to flag records that met the restriction instead of removing those",
        "Class of result4",
        "execute query and download the result",
        "Number of rows in source",
        "Number of rows in the current result",
        "make two look up tables",
        "get year from dates for matching",
        "note that keys must be present in all tables",
        "Call-building functions"
      ],
      "created": "2024-05-06 18:18:39",
      "modified": "2025-11-20 07:48:09",
      "commits": 5
    }
  ],
  "_score": 4.845098040014257,
  "_indexed": true,
  "_nocasepkg": "healthdb",
  "_universes": [
    "kevinhzq"
  ],
  "_previous": "0.5.1",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.5.1.9000",
      "date": "2026-05-28T20:37:49.000Z",
      "distro": "noble",
      "commit": "160d1bba61064f9b82a939d3eddd11d2aceb62c6",
      "fileid": "ec3ce05ae89cbb0efd1138507f379f15badd861678003af858cff4c456deaf2f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/kevinhzq/actions/runs/26600517538"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.5.1.9000",
      "date": "2026-05-28T20:37:48.000Z",
      "distro": "noble",
      "commit": "160d1bba61064f9b82a939d3eddd11d2aceb62c6",
      "fileid": "243446163fabe8ea4589a4b8ca29f6ec118f744f46488c9501e5d9fa70cef610",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/kevinhzq/actions/runs/26600517538"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.5.1.9000",
      "date": "2026-05-28T20:37:56.000Z",
      "commit": "160d1bba61064f9b82a939d3eddd11d2aceb62c6",
      "fileid": "7ff1f526e4e0891f07738d04f3f375b4cd3448aecbfcf27ea9f91b375fb3c8c7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/kevinhzq/actions/runs/26600517538"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.5.1.9000",
      "date": "2026-05-28T20:37:19.000Z",
      "commit": "160d1bba61064f9b82a939d3eddd11d2aceb62c6",
      "fileid": "6e6f2c14010217d191e9f99754d2ca2680e476a3257e4a978a4d856ccc83c2e8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/kevinhzq/actions/runs/26600517538"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.5.1.9000",
      "date": "2026-05-28T20:37:56.000Z",
      "commit": "160d1bba61064f9b82a939d3eddd11d2aceb62c6",
      "fileid": "ce86c59212cb03a293c634870e8fb453596b75aff7c6ae9b882ce31b577655c2",
      "status": "success",
      "buildurl": "https://github.com/r-universe/kevinhzq/actions/runs/26600517538"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.5.1.9000",
      "date": "2026-05-28T20:36:52.000Z",
      "commit": "160d1bba61064f9b82a939d3eddd11d2aceb62c6",
      "fileid": "f9aefbad9ce25fcfb6b374c5e11762d210e482968fcf09cbc5887d3ea44a711b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/kevinhzq/actions/runs/26600517538"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.5.1.9000",
      "date": "2026-05-28T20:36:38.000Z",
      "commit": "160d1bba61064f9b82a939d3eddd11d2aceb62c6",
      "fileid": "836ca6d1588feec0ec52cc86176ec0c163af64e0887b477a96d517108112557b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/kevinhzq/actions/runs/26600517538"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.5.1.9000",
      "date": "2026-05-28T20:37:01.000Z",
      "commit": "160d1bba61064f9b82a939d3eddd11d2aceb62c6",
      "fileid": "1366bf243a1900e46451dd45887ee0ec716bdf7e0754876b5c281063ad0b7730",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/kevinhzq/actions/runs/26600517538"
    }
  ]
}