sagerx
sagerx copied to clipboard
coderxio
Open drug data pipelines curated by pharmacists.
# Proposal Go after this data source https://coderx.io/source-data/cms-alpha-numeric-hcpcs # Rationale Because HCPCS.
## Resolves [#338](https://github.com/coderxio/sagerx/issues/338) ## Explanation - Created local `exports` folder within Airflow (and updating `.gitignore` and and `docker_compose.yml` accordingly) so that data marts are exported locally, in addition to on...
# Problem Statement At one point, the int_fda_packaging_components model required me to multiple an aggregate array and the only way I could do this was with a custom PostgreSQL function....
# Proposal RxClass API only gives you the last node of a class tree. There's a separate API call for the rest of the tree hierarchy. I don't think we...
# Proposal Create a data mart that maps a product-level RXCUI (TTY in [SCD, SBD, GPCK, BPCK]) to a "representative NDC" which means a somewhat random (but intentional) NDC that...
# Problem Statement Code finds the first match, but there can be multiple files. In this case, it is matching on the Dec one first instead of the  #...
# Problem Statement The `fda_enforcement` airflow DAG fails. I suspect something about the data format changed, but haven't been able to figure it out. The problem can be traced to...
# Problem Statement  # Criteria for Success Header is no longer in first row of data in sagerx_lake.purple_book # Additional Information Probably something with the COPY command of the...
# Problem Statement There are specific guidelines for figuring out Billing Unit per NCPDP at a NDC level. # Criteria for Success EA, ML and GM assigned to each NDC...
# Problem Statement VANDF data is in RxNorm. https://www.nlm.nih.gov/research/umls/rxnorm/sourcereleasedocs/vandf.html It's also available for download. https://www.pbm.va.gov/NationalFormulary.asp Assuming it's easier just to use RxNorm to get started, make a staging table out...