Skip to content

Actions: MIT-LCP/mimic-code

Actions

BigQuery SQL syntax check via sqlglot

Actions

Loading...
Loading

Show workflow options

Create status badge

Loading
sql_syntax_check.yml
116 workflow runs
116 workflow runs

Filter by Event

⌥ + click/return to exclude

Filter by Status

⌥ + click/return to exclude

Filter by Branch

⌥ + click/return to exclude

Filter by Actor

⌥ + click/return to exclude
Fix SOFA CV scoring, urine_output_rate diffs, and Elixhauser no_drg BigQuery SQL syntax check via sqlglot #118: Pull request #2126 synchronize by Chessing234
28s Chessing234:fix/sofa-cv-and-uo-rate
Chessing234:fix/sofa-cv-and-uo-rate
28s
fix: load paths, imports, transpile, and CI permissions BigQuery SQL syntax check via sqlglot #117: Pull request #2128 synchronize by Chessing234
30s Chessing234:fix/load-path-infra
Chessing234:fix/load-path-infra
30s
fix: Charlson age_score half-open decade bands BigQuery SQL syntax check via sqlglot #116: Pull request #2129 synchronize by Chessing234
29s Chessing234:fix/charlson-age-score-decade-boundary
Chessing234:fix/charlson-age-score-decade-boundary
29s
fix: treat SURGICAL SAME DAY ADMISSION as elective surgery BigQuery SQL syntax check via sqlglot #115: Pull request #2133 synchronize by Chessing234
30s Chessing234:fix/iv-ssda-elective-surgery
Chessing234:fix/iv-ssda-elective-surgery
30s
fix: compare APS III equidistant arms to min not max BigQuery SQL syntax check via sqlglot #114: Pull request #2137 synchronize by Chessing234
28s Chessing234:fix/apsiii-equidistant-max-min
Chessing234:fix/apsiii-equidistant-max-min
28s
fix(mimic-iv): filter lab concepts by expected valueuom BigQuery SQL syntax check via sqlglot #113: Pull request #2141 synchronize by Chessing234
27s Chessing234:fix/lab-valueuom-filtering
Chessing234:fix/lab-valueuom-filtering
27s
fix(mimic-iv): exclude C4A from Charlson malignant_cancer mapping BigQuery SQL syntax check via sqlglot #112: Pull request #2142 synchronize by Chessing234
29s Chessing234:fix/charlson-icd10cm-c4a-exclusion
Chessing234:fix/charlson-icd10cm-c4a-exclusion
29s
fix: correct SIRS comment typos in mimic-iii and mimic-iv BigQuery SQL syntax check via sqlglot #111: Pull request #2143 synchronize by Chessing234
41s Chessing234:fix/sirs-comment-typos
Chessing234:fix/sirs-comment-typos
41s
ci: extend sqlglot syntax check to mimic-iii concepts BigQuery SQL syntax check via sqlglot #110: Pull request #2144 synchronize by Chessing234
30s Chessing234:fix/ci-mimic-iii-sql-syntax-check
Chessing234:fix/ci-mimic-iii-sql-syntax-check
30s
fix(mimic-iv): align lab measurement concepts on positive valuenum filter BigQuery SQL syntax check via sqlglot #109: Pull request #2145 synchronize by Chessing234
36s Chessing234:fix/lab-concept-positive-filters
Chessing234:fix/lab-concept-positive-filters
36s
fix: include wbc_max in SIRS WBC missing-data guard BigQuery SQL syntax check via sqlglot #108: Pull request #2146 synchronize by Chessing234
29s Chessing234:fix/sirs-wbc-max-null-guard
Chessing234:fix/sirs-wbc-max-null-guard
29s
docs: correct LODS scorecomp comment (SAPS → LODS) BigQuery SQL syntax check via sqlglot #107: Pull request #2147 synchronize by Chessing234
31s Chessing234:docs/lods-scorecomp-comment
Chessing234:docs/lods-scorecomp-comment
31s
docs(mimic-iv): timing notes for chartevents vs icustays windows (#1961) BigQuery SQL syntax check via sqlglot #106: Pull request #2151 synchronize by Chessing234
24s Chessing234:docs/icu-charttime-notes-1961
Chessing234:docs/icu-charttime-notes-1961
24s
docs(mimic-iv): interpret admissions.deathtime vs later transfers (#1945) BigQuery SQL syntax check via sqlglot #105: Pull request #2152 synchronize by Chessing234
27s Chessing234:docs/deathtime-notes-1945
Chessing234:docs/deathtime-notes-1945
27s
docs(mimic-iv): no official itemid→LOINC map (#1972) BigQuery SQL syntax check via sqlglot #104: Pull request #2153 synchronize by Chessing234
35s Chessing234:docs/loinc-mapping-notes-1972
Chessing234:docs/loinc-mapping-notes-1972
35s
docs(mimic-iv): where to find Vitamin C / ascorbic acid (#1962) BigQuery SQL syntax check via sqlglot #103: Pull request #2155 synchronize by Chessing234
31s Chessing234:docs/vitamin-c-notes-1962
Chessing234:docs/vitamin-c-notes-1962
31s
docs(mimic-iv): Charlson ICD-10-CM notes for C4A / C7A / C7B (#2017) BigQuery SQL syntax check via sqlglot #102: Pull request #2156 synchronize by Chessing234
27s Chessing234:docs/charlson-icd10cm-c7-note
Chessing234:docs/charlson-icd10cm-c7-note
27s
fix: load paths, imports, transpile, and CI permissions BigQuery SQL syntax check via sqlglot #101: Pull request #2128 synchronize by Chessing234
31s Chessing234:fix/load-path-infra
Chessing234:fix/load-path-infra
31s
fix(mimic-iv): filter lab concepts by expected valueuom BigQuery SQL syntax check via sqlglot #100: Pull request #2141 synchronize by Chessing234
28s Chessing234:fix/lab-valueuom-filtering
Chessing234:fix/lab-valueuom-filtering
28s
fix(mimic-iv): exclude C4A from Charlson malignant_cancer mapping BigQuery SQL syntax check via sqlglot #99: Pull request #2142 synchronize by Chessing234
32s Chessing234:fix/charlson-icd10cm-c4a-exclusion
Chessing234:fix/charlson-icd10cm-c4a-exclusion
32s
fix: correct SIRS comment typos in mimic-iii and mimic-iv BigQuery SQL syntax check via sqlglot #98: Pull request #2143 synchronize by Chessing234
30s Chessing234:fix/sirs-comment-typos
Chessing234:fix/sirs-comment-typos
30s
fix(mimic-iv): align lab measurement concepts on positive valuenum filter BigQuery SQL syntax check via sqlglot #97: Pull request #2145 synchronize by Chessing234
28s Chessing234:fix/lab-concept-positive-filters
Chessing234:fix/lab-concept-positive-filters
28s
fix: include wbc_max in SIRS WBC missing-data guard BigQuery SQL syntax check via sqlglot #96: Pull request #2146 synchronize by Chessing234
31s Chessing234:fix/sirs-wbc-max-null-guard
Chessing234:fix/sirs-wbc-max-null-guard
31s
docs: correct LODS scorecomp comment (SAPS → LODS) BigQuery SQL syntax check via sqlglot #95: Pull request #2147 synchronize by Chessing234
32s Chessing234:docs/lods-scorecomp-comment
Chessing234:docs/lods-scorecomp-comment
32s
docs(mimic-iv): timing notes for chartevents vs icustays windows (#1961) BigQuery SQL syntax check via sqlglot #94: Pull request #2151 synchronize by Chessing234
32s Chessing234:docs/icu-charttime-notes-1961
Chessing234:docs/icu-charttime-notes-1961
32s