{"id":"https://openalex.org/W7164333472","doi":"https://doi.org/10.5061/dryad.3bk3j9m1h","title":"Supplemental data from: Large language model chatbot-based text-to-SQL application for database analyses in liver diseases and hepatology research","display_name":"Supplemental data from: Large language model chatbot-based text-to-SQL application for database analyses in liver diseases and hepatology research","publication_year":2026,"publication_date":"2026-05-25","ids":{"openalex":"https://openalex.org/W7164333472","doi":"https://doi.org/10.5061/dryad.3bk3j9m1h"},"language":"en","primary_location":{"id":"doi:10.5061/dryad.3bk3j9m1h","doi":"https://doi.org/10.5061/dryad.3bk3j9m1h","is_oa":true,"landing_page_url":"https://doi.org/10.5061/dryad.3bk3j9m1h","pdf_url":null,"source":{"id":"https://openalex.org/S7407051161","display_name":"DRYAD","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"public-domain","license_id":"https://openalex.org/licenses/public-domain","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Dataset"},"volume":null,"type":"supplementary-materials","is_traditional":false,"indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.5061/dryad.3bk3j9m1h","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5135132075","display_name":"Aryana Far","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I180670191","display_name":"University of California, San Francisco","ror":"https://ror.org/043mz5j54","country_code":"US","type":"education","lineage":["https://openalex.org/I180670191"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Far, Aryana","raw_affiliation_strings":["University of California, San Francisco"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, San Francisco","institution_ids":["https://openalex.org/I180670191"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5138404422","display_name":"Steve Sun","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I180670191","display_name":"University of California, San Francisco","ror":"https://ror.org/043mz5j54","country_code":"US","type":"education","lineage":["https://openalex.org/I180670191"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sun, Steve","raw_affiliation_strings":["University of California, San Francisco"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, San Francisco","institution_ids":["https://openalex.org/I180670191"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022426777","display_name":"Gabrielle Jutras","orcid":"https://orcid.org/0000-0003-2319-3880","observed_orcids":["https://orcid.org/0000-0003-2319-3880"]},"institutions":[{"id":"https://openalex.org/I70931966","display_name":"Universit\u00e9 de Montr\u00e9al","ror":"https://ror.org/0161xgx34","country_code":"CA","type":"education","lineage":["https://openalex.org/I70931966"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Jutras, Gabrielle","raw_affiliation_strings":["Universit\u00e9 de Montr\u00e9al"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universit\u00e9 de Montr\u00e9al","institution_ids":["https://openalex.org/I70931966"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052630177","display_name":"Melinda B. Wang","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210110664","display_name":"University of California San Francisco Medical Center","ror":"https://ror.org/01t8svj65","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I4210110664"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Wang, Melinda B","raw_affiliation_strings":["University of California San Francisco Medical Center"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California San Francisco Medical Center","institution_ids":["https://openalex.org/I4210110664"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5135130168","display_name":"Shohei Burns","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210110664","display_name":"University of California San Francisco Medical Center","ror":"https://ror.org/01t8svj65","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I4210110664"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Burns, Shohei","raw_affiliation_strings":["University of California San Francisco Medical Center"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California San Francisco Medical Center","institution_ids":["https://openalex.org/I4210110664"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5099331925","display_name":"Joseph Owens","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210110664","display_name":"University of California San Francisco Medical Center","ror":"https://ror.org/01t8svj65","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I4210110664"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Owens, Joseph","raw_affiliation_strings":["University of California San Francisco Medical Center"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California San Francisco Medical Center","institution_ids":["https://openalex.org/I4210110664"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5093243695","display_name":"Victor Galvez","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210110664","display_name":"University of California San Francisco Medical Center","ror":"https://ror.org/01t8svj65","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I4210110664"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Galvez, Victor","raw_affiliation_strings":["University of California San Francisco Medical Center"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California San Francisco Medical Center","institution_ids":["https://openalex.org/I4210110664"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5144369538","display_name":"Ma Somsouk","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210110664","display_name":"University of California San Francisco Medical Center","ror":"https://ror.org/01t8svj65","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I4210110664"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Somsouk, Ma","raw_affiliation_strings":["University of California San Francisco Medical Center"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California San Francisco Medical Center","institution_ids":["https://openalex.org/I4210110664"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5138453257","display_name":"Jennifer Lai","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210110664","display_name":"University of California San Francisco Medical Center","ror":"https://ror.org/01t8svj65","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I4210110664"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lai, Jennifer","raw_affiliation_strings":["University of California San Francisco Medical Center"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California San Francisco Medical Center","institution_ids":["https://openalex.org/I4210110664"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113929793","display_name":"Ki Lai","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210110664","display_name":"University of California San Francisco Medical Center","ror":"https://ror.org/01t8svj65","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I4210110664"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lai, Ki","raw_affiliation_strings":["University of California San Francisco Medical Center"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California San Francisco Medical Center","institution_ids":["https://openalex.org/I4210110664"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5023565042","display_name":"Jin Ge","orcid":"https://orcid.org/0000-0003-1574-1525","observed_orcids":["https://orcid.org/0000-0003-1574-1525"]},"institutions":[{"id":"https://openalex.org/I4210110664","display_name":"University of California San Francisco Medical Center","ror":"https://ror.org/01t8svj65","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I4210110664"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ge, Jin","raw_affiliation_strings":["University of California San Francisco Medical Center"],"raw_orcid":"https://orcid.org/0000-0003-1574-1525","affiliations":[{"raw_affiliation_string":"University of California San Francisco Medical Center","institution_ids":["https://openalex.org/I4210110664"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11636","display_name":"Artificial Intelligence in Healthcare and Education","score":0.9589999914169312,"subfield":{"id":"https://openalex.org/subfields/2718","display_name":"Health Informatics"},"field":{"id":"https://openalex.org/fields/27","display_name":"Medicine"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},"topics":[{"id":"https://openalex.org/T11636","display_name":"Artificial Intelligence in Healthcare and Education","score":0.9589999914169312,"subfield":{"id":"https://openalex.org/subfields/2718","display_name":"Health Informatics"},"field":{"id":"https://openalex.org/fields/27","display_name":"Medicine"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},{"id":"https://openalex.org/T11396","display_name":"Artificial Intelligence in Healthcare","score":0.007600000128149986,"subfield":{"id":"https://openalex.org/subfields/3605","display_name":"Health Information Management"},"field":{"id":"https://openalex.org/fields/36","display_name":"Health Professions"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},{"id":"https://openalex.org/T11710","display_name":"Biomedical Text Mining and Ontologies","score":0.006500000134110451,"subfield":{"id":"https://openalex.org/subfields/2718","display_name":"Health Informatics"},"field":{"id":"https://openalex.org/fields/27","display_name":"Medicine"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/large-language-models","display_name":"large language models","score":0.8629999756813049},{"id":"https://openalex.org/keywords/chatbots","display_name":"chatbots","score":0.7910000085830688},{"id":"https://openalex.org/keywords/natural-language-questions","display_name":"natural language queries","score":0.8709999918937683},{"id":"https://openalex.org/keywords/hepatocellular-carcinoma","display_name":"hepatocellular carcinoma","score":0.7900000214576721},{"id":"https://openalex.org/keywords/liver-disease","display_name":"liver disease","score":0.9160000085830688},{"id":"https://openalex.org/keywords/hepatology-research","display_name":"hepatology research","score":0.800000011920929},{"id":"https://openalex.org/keywords/medical-data-analysis","display_name":"medical data analysis","score":0.6880000233650208},{"id":"https://openalex.org/keywords/structured-query-language","display_name":"structured query language","score":0.6399999856948853}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7926999926567078},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7116000056266785},{"id":"https://openalex.org/C2779041454","wikidata":"https://www.wikidata.org/wiki/Q870780","display_name":"Chatbot","level":2,"score":0.6902999877929688},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.4968000054359436},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.477400004863739},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.46129998564720154},{"id":"https://openalex.org/C527412718","wikidata":"https://www.wikidata.org/wiki/Q855395","display_name":"Interpretation (philosophy)","level":2,"score":0.4311999976634979},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.42489999532699585},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.41839998960494995},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.4156000018119812},{"id":"https://openalex.org/C118643609","wikidata":"https://www.wikidata.org/wiki/Q189210","display_name":"Web application","level":2,"score":0.38929998874664307},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.38580000400543213},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.34929999709129333},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3488999903202057},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.3481000065803528},{"id":"https://openalex.org/C32977378","wikidata":"https://www.wikidata.org/wiki/Q604737","display_name":"Data control language","level":5,"score":0.3368000090122223},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.33239999413490295},{"id":"https://openalex.org/C137293760","wikidata":"https://www.wikidata.org/wiki/Q3621696","display_name":"Language model","level":2,"score":0.33149999380111694},{"id":"https://openalex.org/C56666940","wikidata":"https://www.wikidata.org/wiki/Q788790","display_name":"Documentation","level":2,"score":0.3206000030040741},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.3012000024318695},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2662000060081482},{"id":"https://openalex.org/C69505689","wikidata":"https://www.wikidata.org/wiki/Q455338","display_name":"Unified Medical Language System","level":2,"score":0.257099986076355}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.5061/dryad.3bk3j9m1h","doi":"https://doi.org/10.5061/dryad.3bk3j9m1h","is_oa":true,"landing_page_url":"https://doi.org/10.5061/dryad.3bk3j9m1h","pdf_url":null,"source":{"id":"https://openalex.org/S7407051161","display_name":"DRYAD","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"public-domain","license_id":"https://openalex.org/licenses/public-domain","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Dataset"}],"best_oa_location":{"id":"doi:10.5061/dryad.3bk3j9m1h","doi":"https://doi.org/10.5061/dryad.3bk3j9m1h","is_oa":true,"landing_page_url":"https://doi.org/10.5061/dryad.3bk3j9m1h","pdf_url":null,"source":{"id":"https://openalex.org/S7407051161","display_name":"DRYAD","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"public-domain","license_id":"https://openalex.org/licenses/public-domain","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Dataset"},"sustainable_development_goals":[{"score":0.8560000061988831,"id":"https://metadata.un.org/sdg/3","display_name":"Good health and well-being"}],"study_designs":[],"awards":[{"id":"https://openalex.org/G208418196","display_name":null,"funder_award_id":"P30DK026743","funder_id":"https://openalex.org/F4320332622","funder_display_name":"University of California, San Francisco"},{"id":"https://openalex.org/G9000868559","display_name":"Investigating the role of frailty on outcomes in acutely ill patients with cirrhosis undergoing liver transplantation in the acute care setting","funder_award_id":"R01DK133527","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"},{"id":"https://openalex.org/G9000885772","display_name":"NRSA Hepatology Training Grant","funder_award_id":"T32DK060414","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"},{"id":"https://openalex.org/G9000887914","display_name":"The Impact of Frailty on Liver Transplant Outcomes in Older Adults with Hepatocellular Carcinoma","funder_award_id":"K24AG080021","funder_id":"https://openalex.org/F4320337337","funder_display_name":"National Institute on Aging"},{"id":"https://openalex.org/G9000889757","display_name":"A pragmatic RCT to evaluate the effect of CirrhosisRx, a novel clinical decision support system, versus usual care on guideline-adherence and clinical outcomes for patients with cirrhosis","funder_award_id":"K23DK139455","funder_id":"https://openalex.org/F4320337357","funder_display_name":"National Institute of Diabetes and Digestive and Kidney Diseases"}],"funders":[{"id":"https://openalex.org/F4320332622","display_name":"University of California, San Francisco","ror":"https://ror.org/043mz5j54"},{"id":"https://openalex.org/F4320337337","display_name":"National Institute on Aging","ror":"https://ror.org/049v75w11"},{"id":"https://openalex.org/F4320337357","display_name":"National Institute of Diabetes and Digestive and Kidney Diseases","ror":"https://ror.org/00adh9b73"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W7165357396","https://openalex.org/W7165423415","https://openalex.org/W4409060418","https://openalex.org/W7082486515","https://openalex.org/W7132642692","https://openalex.org/W4395084058","https://openalex.org/W4401042565","https://openalex.org/W7148989968","https://openalex.org/W7213442772","https://openalex.org/W7166172600"],"abstract_inverted_index":{"Objectives:":[0],"Large":[1],"language":[2,15],"models":[3],"(LLMs)":[4],"may":[5],"improve":[6],"analysis":[7],"of":[8,39],"structured":[9],"clinical":[10,126,145],"data":[11,81,146],"by":[12,79],"enabling":[13],"natural":[14],"(NL)":[16],"queries.":[17],"We":[18,83],"developed":[19],"an":[20],"interactive,":[21],"PHI-compliant":[22,123],"\u201cText2SQL\u201d":[23],"chatbot":[24,50],"as":[25],"a":[26,80,140],"proof-of-concept":[27],"for":[28,143],"hepatocellular":[29],"carcinoma":[30],"(HCC)":[31],"research.":[32],"Materials":[33],"and":[34,62,66,72,91,105,117],"methods:":[35],"Using":[36],"the":[37,49],"University":[38],"California,":[40],"San":[41],"Francisco\u2019s":[42],"secure":[43],"artificial":[44],"intelligence":[45],"platform,":[46],"we":[47],"configured":[48],"to":[51],"translate":[52],"NL":[53],"queries":[54],"into":[55],"Structured":[56],"Query":[57],"Language":[58],"(SQL),":[59],"execute":[60],"them,":[61],"return":[63],"both":[64],"code":[65],"results.":[67],"Clinicians":[68],"posed":[69],"30":[70],"questions,":[71],"outputs":[73],"were":[74],"compared":[75],"with":[76,125],"SQL":[77,87,100],"written":[78],"scientist.":[82],"assessed":[84],"prompt":[85],"interpretation,":[86],"accuracy,":[88,90],"output":[89,106],"error":[92],"types.":[93,135],"Results:":[94],"Prompt":[95],"interpretation":[96],"accuracy":[97,101,107],"was":[98],"87%,":[99],"ranged":[102],"from":[103,108],"77-83%,":[104],"70-80%.":[109],"Frequent":[110],"errors":[111],"included":[112],"group":[113],"comparisons,":[114],"ambiguous":[115],"variables,":[116],"exploratory":[118],"questions.":[119],"Discussion":[120],"Text2SQL":[121,138],"enables":[122],"interaction":[124],"datasets":[127],"without":[128],"coding,":[129],"though":[130],"performance":[131],"varies":[132],"across":[133],"query":[134],"Conclusion:":[136],"LLM-powered":[137],"offers":[139],"promising":[141],"approach":[142],"clinician-friendly":[144],"access.":[147]},"counts_by_year":[],"updated_date":"2026-10-28T10:33:24.094632","created_date":"2026-06-12T00:00:00"}