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='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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: January 2024; 8,060 records
Human Phenotype Ontology	<link href='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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: 2023-10-09; 18,049 records
ICD-10-CM	<link href='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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: 2024; 74,044 records
ICD-11 (Codes)	<link href='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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.76 (2023-09-18); 101,632 records
Major surgeries and implants About 280, hand-edited with synonyms; a Regenstrief Institute derivative	<link href='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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: 2023-10-01; 284 records
Medical conditions Over 2,400, hand-edited with synonyms; a Regenstrief Institute derivative	<link href='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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: 2023-10-01; 2,418 records
NPI - individuals	<link href='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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-03-11; 6,246,431 records
NPI - organizations	<link href='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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-03-11; 1,700,438 records
Prescribable drug ingredients A subset of RxTerms/RxNorm ingredients	<link href='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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']});	From RxTerms/RxMix Data version: 202404; 2,249 records
RxTerms drug names & strength lists A prescriber's interface vocabulary. This is an RxNorm derivative.	<link href='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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: 202404; 9,080 records
UCUM (The Unified Code for Units of Measure)	<link href='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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	Customize	From NCBI ClinVar Data version: 2024-03-31; 2,807,112 records
COSMIC From the Sanger Institute	<link href='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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: v97 (2022-11-29); 77,597,493 records
COSMIC Structural Genomic Rearrangements From the Sanger Institute	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: v97 (2022-11-29); 643,608 records
Cytogenetic locations	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	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='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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']});	From NCBI ClinVar Data version: 2024-04-02; 44,398 records
Genes Symbols and regions from HGNC's dataset	Customize	From HGNC Data version: 2024-03-27; 42,275 records
NCBI Genes Human gene information from NCBI	Customize	From NCBI Gene Data version: 2024-04-01; 193,383 records
RefSeq NCBI accession numbers for the human genome, build GRCh37	Customize	From Genome Data version: 2012-03-06; 82,202 records
SNPs From NCBI's dbSNP	Customize	From NCBI dbSNP Data version: 2018-03-12; 650,265,778 records
PharmVar Star Alleles	<link href='/autocomplete-lhc-versions/17.0.2/autocomplete-lhc.min.css' rel="stylesheet"> <script src='https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js'></script> <script src='/autocomplete-lhc-versions/17.0.2/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.19.6 (changes)

Last updated: 2024-04-15