Clinical Table Search Service

Clinical Table Search Service is a web service which software programs can use for querying clinical data tables. The API for each table is designed to work with our form field autocompletion package, but can be used by other programs as well. The tables may also be accessed through FHIR APIs. Check out the overview page and FAQ page for more details (including terms of use), and please contact us if you have further questions or if there are other clinical data tables you would like to see here. There is also an annoucements list for staying informed about changes.

Connectable Clinical Tables

What follows is a list of currently available tables with links to instructions for the APIs for programmatic access, and an example autocompleter for each table which uses that table's API.

Some of the data sets that we serve are stable (e.g., ICD-9-CM), while others are updated more frequently (e.g., ClinVar). We strive to keep our data up-to-date with respect to the data sources; in most cases it should be less than a month behind. Please refer to the "Details" column below for more information on a specific API's data version or date.

Table Description	Try It	Details
HCPCS Healthcare Common Procedure Coding System	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="hcpcs" placeholder="Code or words"> new Def.Autocompleter.Search('hcpcs', '/api/hcpcs/v3/search', {tableFormat: true, valueCols: [0], colHeaders: ['Code', 'Description']}); Customize	From CMS Data version: October 2024; 8,252 records
Human Phenotype Ontology	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="hpo" placeholder="Code or words"> new Def.Autocompleter.Search('hpo', '/api/hpo/v3/search', {tableFormat: true, valueCols: [0, 1], colHeaders: ['ID', 'Name']}); Customize	From Human Phenotype Ontology Data version: 2024-08-13; 19,434 records
ICD-10-CM	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="icd10" placeholder="Code or name"> new Def.Autocompleter.Search('icd10', '/api/icd10cm/v3/search?sf=code,name', {tableFormat: true, valueCols: [0], colHeaders: ['Code', 'Name']}); Customize	From CDC Data version: 2025; 74,260 records
ICD-11 (Codes)	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="icd11_codes" placeholder="Code or title"> new Def.Autocompleter.Search('icd11_codes', '/api/icd11_codes/v3/search?sf=code,title', {tableFormat: true, valueCols: [0], colHeaders: ['Code', 'Title', 'Type']}); Customize	From WHO ICD-11 stem codes and extension codes. Data version: 2023; 34,194 records
ICD-9-CM diagnoses	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="icd9dx" placeholder="Code or name"> new Def.Autocompleter.Search('icd9dx', '/api/icd9cm_dx/v3/search', {tableFormat: true, valueCols: [0], colHeaders: ['Code', 'Name']}); Customize	From CMS Data version: 32 (2014-10-01); 14,567 records
ICD-9-CM procedures	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="icd9sg" placeholder="Code or name"> new Def.Autocompleter.Search('icd9sg', '/api/icd9cm_sg/v3/search', {tableFormat: true, valueCols: [0], colHeaders: ['Code', 'Name']}); Customize	From CMS Data version: 32 (2014-10-01); 3,882 records
LOINC questions and forms Contains over 2000 medical forms and their associated questions	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="loinc_item" placeholder="LOINC item"> new Def.Autocompleter.Search('loinc_item', '/api/loinc_items/v3/search?df=text,LOINC_NUM', {tableFormat: true, valueCols: [0, 1], colHeaders: ['Text', 'LOINC Number']}); Customize	From LOINC. Note that use of LOINC is subject to the LOINC Terms of Use and in some cases additional copyrights. Form definitions for the forms can also be retrieved and rendered with the LHC-Forms display widget. Data version: 2.78 (2024-08-06); 104,054 records
Major surgeries and implants About 280, hand-edited with synonyms; a Regenstrief Institute derivative	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="procedure" placeholder="Procedure"> new Def.Autocompleter.Search('procedure', '/api/procedures/v3/search'); Customize	From the NLM PHR & Regenstrief Institute. The data is downloadable here. Data version: 2024-10-01; 284 records
Medical conditions Over 2,400, hand-edited with synonyms; a Regenstrief Institute derivative	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="condition" placeholder="Condition"> new Def.Autocompleter.Search('condition', '/api/conditions/v3/search'); Customize	From the NLM PHR & Regenstrief Institute. The data is downloadable here. Data version: 2024-10-01; 2,418 records
NPI - individuals	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="npi_idv" placeholder="Provider name or NPI"> new Def.Autocompleter.Search( 'npi_idv', '/api/npi_idv/v3/search', {tableFormat: true, valueCols: [0, 1], colHeaders: ['Name', 'NPI', 'Type', 'Practice Address'] }); Customize	National Provider Identifier (NPI) records for individuals, from CMS Data version: 2024-11-11; 6,557,559 records
NPI - organizations	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="npi_org" placeholder="Provider name or NPI"> new Def.Autocompleter.Search( 'npi_org', '/api/npi_org/v3/search', {tableFormat: true, valueCols: [0, 1], colHeaders: ['Name', 'NPI', 'Type', 'Practice Address'] }); Customize	National Provider Identifier (NPI) records for organizations, from CMS Data version: 2024-11-11; 1,765,502 records
Prescribable drug ingredients A subset of RxTerms/RxNorm ingredients	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="ingredient" placeholder="Ingredient"> new Def.Autocompleter.Search('ingredient', '/api/drug_ingredients/v3/search?df=name,code', {tableFormat: true, valueCols: [0], colHeaders: ['Name', 'Code']}); Customize	From RxTerms/RxMix Data version: 202411; 2,291 records
RxTerms drug names & strength lists A prescriber's interface vocabulary. This is an RxNorm derivative.	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="rxterms" placeholder="Drug name"> <input type="text" id="drug_strengths" placeholder="Strength list"> new Def.Autocompleter.Prefetch('drug_strengths', []); new Def.Autocompleter.Search('rxterms', '/api/rxterms/v3/search?ef=STRENGTHS_AND_FORMS'); Def.Autocompleter.Event.observeListSelections('rxterms', function() { var drugField = $('#rxterms')[0]; var autocomp = drugField.autocomp; var strengths = autocomp.getSelectedItemData()[0].data['STRENGTHS_AND_FORMS']; if (strengths) $('#drug_strengths')[0].autocomp.setListAndField(strengths, ''); }) Customize	From RxTerms Data version: 202411; 9,169 records
UCUM (The Unified Code for Units of Measure)	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="ucum" placeholder="Code or name"> new Def.Autocompleter.Search('ucum', '/api/ucum/v3/search', {tableFormat: true, valueCols: [0], colHeaders: ['Code', 'Name']}); Customize	From UCUM. Note that use is subject to the UCUM Terms of Use. Data version: 2024-01-30; 759 records
Genomics Data Tables
ClinVar Variants NCBI ClinVar variant codes	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="variant" placeholder="ClinVar Variation ID"> new Def.Autocompleter.Search('variant', '/api/variants/v4/search' + '?df=VariationID,Chromosome,GeneSymbol,HGVS_c,AminoAcidChange,Cytogenetic,dbSNP', {tableFormat: true, valueCols: [0], colHeaders: ['Variation ID', 'Chromosome', 'Gene Symbol', 'HGVS (c.)', 'Amino Acid Change', 'Cytogenetic', 'dbSNP ID'] }); Customize	From NCBI ClinVar Data version: 2024-11-11; 3,093,075 records
COSMIC From the Sanger Institute	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="cosmic" placeholder="Gene Name (e.g., rgs...)"> new Def.Autocompleter.Search('cosmic', '/api/cosmic/v4/search', { tableFormat: true, valueCols: [0], colHeaders: ['Mutation ID', 'Gene Name', 'Mutation CDS', 'Mutation AA'] }); Customize	Somatic mutation data from COSMIC. Please note that it is not permitted to use this service to try to reconstruct the COSMIC data file. Please see COSMIC's license page for information about access to the full data file. Data version: v100 (2024-05-21); 85,912,421 records
COSMIC Structural Genomic Rearrangements From the Sanger Institute	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="cosmic_struct" placeholder="Mutation ID (e.g. 1234...)"> new Def.Autocompleter.Search('cosmic_struct', '/api/cosmic_struct/v3/search', {tableFormat: true, valueCols: [0], colHeaders: ['Mutation ID', 'Description', 'Mutation Type'] }); Customize	Somatic mutation data from COSMIC. Please note that it is not permitted to use this service to try to reconstruct the COSMIC data file. Please see COSMIC's license page for information about access to the full data file. Data version: v100 (2024-05-21); 643,608 records
Cytogenetic locations	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="cytogeneticLoc" placeholder="Cytogenetic location (e.g., 2p...)"> new Def.Autocompleter.Search('cytogeneticLoc', '/api/cytogenetic_locs/v3/search', {tableFormat: true, valueCols: [0]}); Customize	From NCBI's genome ideogram data for the Genome Decoration Page. Data version: 1 (2014-06-02); 862 records
dbVar Genomic structural variations from NCBI's dbVar	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="dbvar" placeholder="Name (e.g. nssv1...)"> new Def.Autocompleter.Search('dbvar', '/api/dbvar/v3/search', {nonMatchSuggestions: false, tableFormat: true, valueCols: [0], colHeaders: ['Name', 'Origin', 'Zygosity']}); Customize	From NCBI dbVar Data version: 2023-10-30; 47,094,612 records
Genetic diseases Over 24,000; a subset of NCBI's ClinVar genetic diseases file	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="disease" placeholder="Disease"> new Def.Autocompleter.Search('disease', '/api/disease_names/v3/search?df=DiseaseName,ConceptID', {tableFormat: true, valueCols: [0], colHeaders: ['Name', 'Concept ID']}); Customize	From NCBI ClinVar Data version: 2024-11-11; 45,526 records
Genes Symbols and regions from HGNC's dataset	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="symbol" placeholder="Gene symbol"> new Def.Autocompleter.Search('symbol', '/api/genes/v4/search' + '?df=hgnc_id,symbol,name,refseq_accession', {tableFormat: true, valueCols: [0], colHeaders: ['HGNC ID', 'Symbol', 'Name', 'RefSeq'] }); Customize	From HGNC Data version: 2024-10-18; 42,298 records
NCBI Genes Human gene information from NCBI	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="ncbi_gene" placeholder="Gene symbol"> new Def.Autocompleter.Search('ncbi_gene', '/api/ncbi_genes/v3/search', {tableFormat: true, valueCols: [3], colHeaders: ['Code System', 'Gene Code', 'Chromosome', 'Symbol', 'Description', 'Type of Gene'] }); Customize	From NCBI Gene Data version: 2024-11-12; 193,285 records
RefSeq NCBI accession numbers for the human genome, build GRCh37	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="refseq" placeholder="RefSeq"> new Def.Autocompleter.Search('refseq', '/api/refseqs/v3/search', {tableFormat: true, valueCols: [0], colHeaders: ['RefSeq', 'Gene', 'NP RefSeq', 'NC RefSeq'] }); Customize	From Genome Data version: 2012-03-06; 82,202 records
SNPs From NCBI's dbSNP	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="snp" placeholder="rs number"> let displayFields = ['rsNum', '38.chr', '38.pos', '38.alleles', '38.gene']; new Def.Autocompleter.Search('snp', '/api/snps/v3/search?df=' + displayFields.join(','), {tableFormat: true, valueCols: [0], colHeaders: displayFields}); Customize	From NCBI dbSNP Data version: 2018-03-12; 650,265,778 records
PharmVar Star Alleles	<link href='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='https://clinicaltables.nlm.nih.gov/autocomplete-lhc-versions/19.2.4/autocomplete-lhc.min.js'></script> <input type="text" id="star_alleles" placeholder="Star allele name"> new Def.Autocompleter.Search('star_alleles', '/api/star_alleles/v3/search', {tableFormat: true, valueCols: [0], colHeaders: ['StarAlleleName', 'cDNANucleotideChanges', 'GeneNucleotideChange', 'OtherNames', 'ProteinChange']}); Customize	From the PharmVar CYP data Data version: 2017-06-22; 1,019 records

CTSS version: 9.20.16 (changes)

Last updated: 2024-11-19