Cloud Academy

Everything you need to build with Cognizant Cloud. Product guides, API references, real-world walkthroughs, and interactive courses with live data.

Quick Start Guide

Create your account, run your first search, and explore the platform in minutes.

4 steps5 min

NPI ProLookup

Search 8M+ providers with 5 search modes including AI-powered Magic Lookup.

Live DemoMost Popular

Magic Data Fixer

Clean messy data with AI. Auto-detects schema, normalizes values, exports CSV/JSON.

AI-PoweredNew

API Reference

NPPES, openFDA, RxNorm, DailyMed, and ClinicalTrials.gov documentation.

5 APIsCode Examples

Interactive Courses

6 lessons with quizzes and live API demos. Track your progress as you learn.

2 Courses~45 min total

Use Case Library

5 real-world scenarios with step-by-step tool guidance and pro tips.

5 Walkthroughs

Quick Start Guide

Welcome to Cloud Academy. This guide walks you through creating your account, running your first search, and understanding how credits work across the platform.

Create Your Free Account

Visit cognizantcloud.com/account and click "Create Account." Enter your email and choose a password. No credit card is required. Your free account includes 25 credits per month, enough for hundreds of NPI lookups, several AI-powered data cleaning sessions, and unlimited access to all free healthcare tools.

Run Your First NPI Lookup

Navigate to NPI ProLookup and type any provider name, NPI number, or specialty into the search bar. Try something like "Dr. Smith cardiology Maryland" and watch Magic Lookup parse your query, identify the specialty and state, and return matching providers in under two seconds. Each lookup against the NPPES registry is completely free and does not consume credits.

Explore the Free Tools

Head to the Tools page to access Drug 360 Intelligence, Formulary Decision Support, and Safety Signal Scanner. These tools query live federal databases (openFDA, RxNorm, DailyMed) and do not require credits for basic use. Type any drug name to pull FAERS adverse event reports, prescribing information, recall history, and more.

Try AI-Powered Features

Ready for something more powerful? Go to Magic Data Fixer to clean messy data with AI, or try NPI Data Enrichment to upload a provider list and automatically append 30+ data fields. AI features use credits, but your free monthly allocation covers plenty of experimentation.

Understanding Credits

Credits power the AI and enrichment features of the platform. Standard NPI lookups and the free healthcare tools do not consume credits.

ActionCredit CostNotes
NPI Quick/Advanced/Batch Search0 creditsAlways free, unlimited queries
Magic Lookup (AI-parsed search)0 creditsAI parsing is free for search
Drug 360 / Safety Signals0 creditsFree tools, live federal API data
Magic Data Fixer (Free tier)1 creditUp to 500 characters input
Magic Data Fixer (Pro tier)3 creditsUp to 5,000 characters input
Magic Data Fixer (Ultra tier)10 creditsUp to 50,000 characters, GPT-5.4 model
NPI Data Enrichment1 credit/rowPer provider record enriched
Tip: Your free account comes with 25 credits per month. Upgrade to Pro for 500 credits/month, or Ultra for 5,000 credits/month with priority processing and the GPT-5.4 model for data cleaning.

NPI ProLookup

Search over 8 million healthcare providers in the NPPES National Provider Identifier registry. NPI ProLookup offers five distinct search modes, each optimized for different workflows.

NPPES Registry (Live)
8.2M+ Providers
Updated Daily
No Auth Required

Five Search Modes

Quick Search

Type a name, NPI number, city, or state and get instant results. The system detects whether you entered a 10-digit NPI, a name, or a location and routes your query accordingly. Ideal for one-off lookups.

Advanced Search

Filter by first name, last name, taxonomy (specialty), city, state, zip code, enumeration type, gender, and organization name. Results display in a sortable table format, perfect for building targeted provider lists.

Batch Lookup

Paste up to 500 NPI numbers (one per line, comma-separated, or in any format) and retrieve full records for all of them in a single operation. Export results as CSV. Great for validating provider databases.

Magic Lookup

Paste messy, unstructured text and let AI parse it into a structured provider search. Handles business cards, email signatures, partial names, and misspellings. Uses multi-wave search with confidence scoring.

Taxonomy Explorer

Browse and search the complete CMS taxonomy code system. Find providers by specialty category, view provider counts by state, and discover taxonomy codes for niche specialties like "Pediatric Sleep Medicine" (2080S0012X).

Magic Lookup Deep Dive

Magic Lookup is the most advanced search mode, designed for situations where you have messy or incomplete provider information.

Step 1: AI Text Parsing

The input text is analyzed to extract structured fields. The parser identifies names (including titles like "Dr." and credentials like "MD," "DO," "NP"), locations (city, state, zip), specialties and taxonomy descriptions, phone numbers, and NPI numbers if present.

Step 2: Spelling Correction and Name Variants

The system generates spelling variations and nickname mappings. "Bill" maps to "William," "Bob" to "Robert," "Beth" to "Elizabeth," and so on. Common misspellings are corrected: "cardiologist" catches "cardioligist" and "cardiolagy."

Step 3: Multi-Wave Search

Rather than running a single query, Magic Lookup executes multiple search waves in parallel, each with progressively broader criteria:

  • Wave 1: Exact match on all extracted fields (name + specialty + state)
  • Wave 2: Name variations with wildcard matching
  • Wave 3: Last name only with specialty and broader geography
  • Wave 4: Fuzzy matching on partial name fragments

Step 4: Confidence Scoring

Each result is scored based on how many of the original query fields matched. A perfect match across name, specialty, and location scores 95%+. Partial matches are ranked lower but still returned, with visual indicators showing match quality.

Example Input: "dr johnson cardiology baltimore md" will parse as first_name=null, last_name=Johnson, specialty=Cardiovascular Disease, city=Baltimore, state=MD, then search across multiple NPPES queries to find the best match.

Data Fields Returned

Every NPI lookup returns the following fields from the NPPES registry:

FieldAPI KeyDescription
NPI NumbernumberUnique 10-digit National Provider Identifier
Entity Typeenumeration_typeNPI-1 (Individual) or NPI-2 (Organization)
Provider Namebasic.first_name, basic.last_nameFull legal name for individuals, organization name for Type 2
Credentialbasic.credentialProfessional credential (MD, DO, NP, PA, PhD, etc.)
Genderbasic.genderM or F (individuals only)
Enumeration Datebasic.enumeration_dateDate the NPI was assigned (YYYY-MM-DD)
Last Updatedbasic.last_updatedMost recent record update date
Statusbasic.statusActive (A) or Deactivated (D)
Practice Addressaddresses[0]Primary practice location (street, city, state, zip, phone, fax)
Taxonomy Code(s)taxonomies[].codeHealthcare Provider Taxonomy code(s)
Taxonomy Descriptiontaxonomies[].descHuman-readable specialty name
Primary Taxonomytaxonomies[].primaryBoolean flag for the primary specialty
License Numbertaxonomies[].licenseState medical license number

Common Use Cases

  • Credential Verification: Confirm a provider's NPI, specialty, and active status before onboarding or referring patients.
  • Referral Network Building: Find all cardiologists within a 50-mile radius using Advanced Search with taxonomy and state filters.
  • Provider Database Cleanup: Validate hundreds of NPIs at once with Batch Lookup and flag deactivated or mismatched records.
  • Specialist Research: Use Taxonomy Explorer to discover providers in niche specialties, then filter by state to build regional maps.
  • CRM Data Enrichment: Match partial provider names from your CRM to full NPI records using Magic Lookup, then export clean data.

Try It Now: Live NPI Search

This search hits the live NPPES API through our Netlify function. Enter a provider name, NPI number, or specialty to see real results.

Enter a search term above to query the live NPPES database.

API Source: All NPI data comes from the NPPES NPI Registry at npiregistry.cms.hhs.gov/api. This is a free, public API maintained by CMS. No API key or authentication is required. Data is updated daily from the national NPI downloadable file.

Magic Data Fixer

Paste messy, unstructured data and get clean, structured output in seconds. Powered by large language models that detect your data's schema, clean values, and normalize formatting automatically.

AI-Powered
CSV / JSON / Markdown output
Auto schema detection

How It Works

1. Schema Detection

When you paste data, the AI analyzes the content to determine its structure. It identifies column headers (if present), data types (names, dates, numbers, addresses, codes), and the overall format (tabular, list, key-value pairs, free text).

2. Value Cleaning

Each value is cleaned according to its detected type. Names are properly capitalized. Phone numbers are normalized to a consistent format. Dates are standardized. Drug names are matched against known databases. Addresses are parsed into components (street, city, state, zip).

3. Format Normalization

The cleaned data is output in your chosen format. CSV output includes proper escaping and quoting. JSON output uses consistent key naming (camelCase). Markdown produces clean, readable tables. All formats preserve the original data relationships.

Example Input dr. JOHN smith MD - johns hopkins hospital baltimore maryland 21287 ph: (410) 555-1234 cardiology, interventional jane DOE np washington dc pediatrics 202.555.9876
CSV Output Name,Credential,Organization,City,State,Zip,Phone,Specialty John Smith,MD,Johns Hopkins Hospital,Baltimore,MD,21287,(410) 555-1234,"Cardiology, Interventional" Jane Doe,NP,,Washington,DC,,(202) 555-9876,Pediatrics

Processing Tiers

TierInput LimitModelCredit CostBest For
Free500 charactersGPT-5.4-nano1 creditQuick cleanups, small lists, testing
Pro5,000 charactersGPT-5.4-mini3 creditsMedium datasets, provider lists, contact data
Ultra50,000 charactersGPT-5.410 creditsLarge datasets, complex multi-format data, maximum accuracy

Use Cases

  • Provider List Cleanup: Paste a messy list of providers from any source and get a clean CSV with normalized names, addresses, and specialties.
  • Drug Name Normalization: Input brand names, generics, and misspellings in any order. The AI maps them to standardized names and formats.
  • Business Card Data: Photograph text from business cards or conference contacts, paste the OCR output, and get structured records.
  • Legacy System Migration: Export data from old systems in inconsistent formats and use the Ultra tier to clean and restructure large datasets for import into modern platforms.

NPI Data Enrichment

Upload a list of provider records and automatically enrich each one with NPI numbers and 30+ data fields from the NPPES registry. The matching engine uses multiple strategies to maximize hit rates.

Multi-Strategy Matching
30+ Enrichment Fields
CSV Upload/Download

Multi-Strategy Matching Engine

The enrichment engine tries multiple matching strategies in order of specificity. If the first strategy finds a confident match, it stops. If not, it falls through to broader searches:

Direct NPI Match

If your data already includes an NPI number, the system verifies it against the registry and pulls all associated fields. This is the fastest and most accurate strategy.

Exact Name Match

Searches by first name + last name + state (if available). Requires an exact character match. Works best for common provider formats like "John Smith, MD" with a state field.

Nickname Expansion

If the exact name match fails, the engine expands first names to common variants. "Bill" becomes "William," "Bob" becomes "Robert," "Liz" becomes "Elizabeth," and so on. Over 200 nickname mappings are built in.

Fuzzy Match with Scoring

As a last resort, the engine uses wildcard and partial matching with a confidence score. Results below the confidence threshold are flagged as "unmatched" for manual review rather than risking a false positive.

Fields Appended

When a match is found, these fields are added to your original record:

npi_number Verified NPI
provider_type Individual or Organization
credential MD, DO, NP, PA, etc.
gender M or F
primary_specialty Main taxonomy description
taxonomy_code CMS taxonomy code
license_number State license ID
license_state License issuing state
practice_address Street, city, state, zip
practice_phone Office phone
enumeration_date NPI assignment date
status Active or Deactivated
match_confidence Match quality score (0-100)
match_strategy Which strategy found the match

Healthcare Intelligence Tools 100% Free

Six powerful tools that query live federal databases in real time. No account required, no credits consumed, no rate limits for normal use.

Drug 360 Intelligence

Enter any drug name to get a comprehensive report: FAERS adverse event counts, prescribing information from DailyMed, NDC codes, FDA approval history, drug labeling, and pharmacologic class.

Formulary Decision Support

Compare two drugs head-to-head across safety profiles, adverse event frequencies, drug interactions, and clinical data for formulary reviews.

Safety Signal Scanner

Query FAERS for any drug. View serious vs. non-serious event breakdowns, patient outcome distributions, top reported reactions, and temporal trends.

Drug Interaction Checker

Powered by the RxNorm API. Enter two or more drug names and instantly see known interactions, severity levels, and clinical descriptions.

FDA Recall Monitor

Search drug recalls, market withdrawals, and safety alerts from the openFDA enforcement endpoint. Filter by status, classification, and date range.

Clinical Trial Search

Search ClinicalTrials.gov for active and recruiting studies by condition, drug name, or sponsor. View trial phases, enrollment targets, and study sites.

API Sources and Data Freshness

ToolAPI SourceUpdate FrequencyAuthentication
Drug 360openFDA + DailyMed + RxNormQuarterly (FAERS), Weekly (labels)None required
Formulary DecisionopenFDA + RxNormQuarterlyNone required
Safety SignalsopenFDA FAERSQuarterlyNone required
Drug InteractionsRxNorm Interaction APIMonthlyNone required
FDA RecallsopenFDA EnforcementWeeklyNone required
Clinical TrialsClinicalTrials.gov v2 APIDailyNone required

API Reference

Cognizant Cloud aggregates data from five federal healthcare APIs into a unified interface. This section documents each API, its searchable fields, response structures, and rate limits.

NPPES NPI Registry API Free

The National Plan and Provider Enumeration System (NPPES) maintains the authoritative registry of all healthcare providers in the United States. The API provides real-time access to 8.2+ million provider records.

Endpoint GET https://npiregistry.cms.hhs.gov/api/?version=2.1

Searchable Parameters

ParameterTypeDescriptionExample
numberStringExact 10-digit NPI number1234567890
enumeration_typeStringNPI-1 (Individual) or NPI-2 (Organization)NPI-1
taxonomy_descriptionStringProvider specialty or taxonomy descriptionCardiology
first_nameStringProvider first name (exact or wildcard with *)John*
last_nameStringProvider last name (exact or wildcard with *)Smith
organization_nameStringOrganization name (Type 2 only)Johns Hopkins
cityStringPractice cityBaltimore
stateStringTwo-letter state codeMD
postal_codeString5-digit or 9-digit ZIP code21287
limitIntegerResults per page (max 200)50
skipIntegerNumber of results to skip (pagination)200

Response Structure

JSON Response { "result_count": 1, "results": [{ "number": "1234567890", "enumeration_type": "NPI-1", "basic": { "first_name": "JOHN", "last_name": "SMITH", "credential": "MD", "gender": "M", "enumeration_date": "2005-05-23", "last_updated": "2024-11-15", "status": "A" }, "addresses": [{ "address_purpose": "LOCATION", "city": "BALTIMORE", "state": "MD" }], "taxonomies": [{ "code": "207RC0000X", "desc": "Cardiovascular Disease", "primary": true }] }] }

Rate Limits

The NPPES API does not enforce strict rate limits, but CMS recommends limiting requests to a reasonable frequency. In practice, bursts of up to 20 requests per second work reliably. No API key required.

Wildcard Searches: The NPPES API supports the * wildcard character in name fields. For example, first_name=Joh* will match "John," "Johann," "Johanna," and "Johnny."

openFDA API Free

The openFDA API provides access to FDA datasets including adverse event reports (FAERS), drug labeling, recalls, and NDC directory.

Endpoints We Use

EndpointBase URLPrimary Use
Drug Adverse Eventsapi.fda.gov/drug/event.jsonFAERS adverse event reports, signal detection
Drug Labelsapi.fda.gov/drug/label.jsonPrescribing information, warnings, indications
Drug Enforcementapi.fda.gov/drug/enforcement.jsonRecalls, market withdrawals, safety alerts
Drug NDC Directoryapi.fda.gov/drug/ndc.jsonNational Drug Code mapping, packaging info
Adverse Event Query GET https://api.fda.gov/drug/event.json ?search=patient.drug.medicinalproduct:"metformin" &count=patient.reaction.reactionmeddrapt.exact &limit=10

Rate Limits

Without an API key: 40 requests/min, 1,000/day. With a free API key: 240 requests/min. Our platform uses an API key and implements request queuing.

RxNorm API (NLM) Free

RxNorm, maintained by the National Library of Medicine, provides normalized names for clinical drugs and links to many drug vocabularies.

EndpointURL PatternPurpose
Drug Name Search/REST/drugs.json?name={name}Find drugs by name, get RxCUI
RxCUI Lookup/REST/rxcui.json?name={name}Resolve name to RxNorm Concept ID
Interactions/REST/interaction/list.json?rxcuis={ids}Check interactions between multiple drugs
Related Concepts/REST/rxcui/{id}/related.jsonFind related ingredients, brands, generics
Spelling Suggest/REST/spellingsuggestions.json?name={name}Correct drug name spelling

Rate limit: 20 requests per second per IP address. No API key required. Data updated monthly.

DailyMed & ClinicalTrials.gov

DailyMed (NLM)

DailyMed publishes the FDA-approved drug labeling (package inserts) in a structured format called SPL (Structured Product Labeling).

ClinicalTrials.gov v2 API

The ClinicalTrials.gov API provides access to the registry of 480,000+ studies from 220+ countries.

Example Query GET https://clinicaltrials.gov/api/v2/studies ?query.cond=heart+failure &query.intr=sacubitril &filter.overallStatus=RECRUITING &pageSize=10

Which API Powers Which Feature

FeatureNPPESopenFDARxNormDailyMedClinicalTrials
NPI ProLookupPrimary----
Drug 360 Report-PrimaryNamesLabelsPipeline
Formulary Decision-PrimaryPrimary--
Safety Signals-Primary---
Drug Interactions--Primary--
Clinical Trials----Primary

Use Case Library

Real-world scenarios with step-by-step guidance on which tools to use and how. Click any scenario to expand the full walkthrough.

"I need to verify 500 provider NPIs from a spreadsheet"

Batch Lookup
  1. Open the NPI ProLookup page and select the Batch tab.
  2. Copy all 500 NPI numbers from your spreadsheet. They can be in any format: one per line, comma-separated, tab-separated, or even embedded in other text.
  3. Paste them into the batch input area. The system will show you how many valid NPIs it detected.
  4. Click Look Up All. The batch processor queries the NPPES API in parallel, processing roughly 20 NPIs per second.
  5. Review the results summary: found, active vs. deactivated, and any NPIs that returned no match.
  6. Click Export CSV to download a file with NPI, name, specialty, status, and address for every matched record.
Pro Tip: If your spreadsheet has names instead of NPIs, use NPI Data Enrichment instead. Upload your CSV with name and state columns, and the matching engine will find NPIs for you.

"I have messy provider data from a business card"

Magic Lookup
  1. Go to NPI ProLookup and select the Magic tab.
  2. Paste or type the text exactly as it appears on the card.
  3. Click Magic Search. The AI parser will extract structured fields automatically.
  4. The multi-wave search runs automatically, trying exact through fuzzy matches.
  5. Review the results ranked by confidence score. 95%+ means all parsed fields matched.
  6. Click the result to expand full provider details including NPI, address, taxonomy codes, and license information.

"I need to find all cardiologists in Maryland"

Advanced Search + Taxonomy
  1. Open NPI ProLookup and select the Advanced tab.
  2. In the Taxonomy/Specialty field, type "Cardiovascular Disease" or use code 207RC0000X.
  3. Set State to "MD".
  4. Click Search. The API returns up to 200 results per page with pagination controls.
  5. For sub-specialties, use Taxonomy Explorer to find codes like Interventional Cardiology (207RI0011X).
  6. Click Export to download results as CSV.

"I need to check drug interactions for a formulary review"

Drug Interaction Checker
  1. Navigate to Tools and open Drug Interaction Checker.
  2. Enter the first drug name. The system resolves it to its RxNorm RxCUI identifier.
  3. Add additional drugs. Brand names and generics both work.
  4. Click Check Interactions. The RxNorm API checks every pairwise combination.
  5. Review the interaction list with severity levels and clinical consequences.
  6. For deeper analysis, click through to Drug 360 for either drug.

"I need adverse event data for a drug safety review"

Safety Signal Scanner
  1. Go to Tools and select Safety Signal Scanner.
  2. Enter the drug name. Brand names and generics both work.
  3. Review the summary dashboard: total reports, serious vs. non-serious split, outcome distribution, temporal trends.
  4. Examine top adverse reactions ranked by frequency.
  5. Use Drug 360 Intelligence for the complete picture with recalls and trial data.
Important: FAERS data represents voluntary reports and does not establish causation. Always interpret FAERS data in context with other evidence sources.
NPI Fundamentals Lesson 1 of 3

What Is an NPI Number?

Learn the fundamentals of the National Provider Identifier system and why it matters for healthcare data work.

The National Provider Identifier (NPI) is a unique 10-digit identification number assigned to healthcare providers in the United States. Congress mandated the NPI as part of the Health Insurance Portability and Accountability Act (HIPAA) of 1996 to simplify the administration of healthcare transactions.

Key facts about NPI numbers

  • Issuing authority: The Centers for Medicare & Medicaid Services (CMS) assigns all NPI numbers through the National Plan and Provider Enumeration System (NPPES).
  • Permanent assignment: Once assigned, an NPI stays with the provider for life. It does not change when the provider moves, changes specialties, or switches employers.
  • Two entity types: Type 1 NPIs identify individual practitioners (physicians, nurses, therapists). Type 2 NPIs identify organizations (hospitals, group practices, pharmacies, home health agencies).
  • Required for billing: Any provider who submits electronic healthcare claims must use their NPI.

NPI number structure

Every NPI is exactly 10 digits. The final digit is a check digit computed using the Luhn algorithm, the same algorithm used to validate credit card numbers. This means you can verify whether a 10-digit number is a structurally valid NPI without hitting any external API.

Why NPI matters for data work

When building healthcare analytics or integrations, the NPI is your primary key for linking provider records across systems. Claims data, prescribing data, referral networks, and credentialing systems all reference providers by NPI. Understanding NPI structure and the NPPES registry is the foundation for any healthcare data project.

Knowledge Check
1. How many digits are in an NPI number?
A 8 digits
B 10 digits
C 12 digits
D 16 digits
2. Which entity assigns NPI numbers?
A The American Medical Association (AMA)
B State medical boards
C The Centers for Medicare & Medicaid Services (CMS)
D The FDA
3. What happens to an NPI when a provider changes employers?
A The NPI stays the same for life
B A new NPI is issued by the new employer
C The NPI is deactivated and reissued
D The last 4 digits change to reflect the new organization
NPI Fundamentals Lesson 2 of 3

How to Search the NPPES Database

Learn the different strategies for querying the NPPES registry API and interpreting results.

The NPPES is the authoritative registry for all NPI records. CMS maintains a public API that anyone can query for free, with no API key required.

Search strategies

  • By NPI number: The fastest path. If you already have a 10-digit NPI, you can pull the complete record in a single API call.
  • By name: Search using first and last name fields. Wildcards (the * character) let you handle partial matches.
  • By taxonomy: Filter by specialty using standard taxonomy codes like 207RC0000X for Cardiovascular Disease.
  • By location: Filter by state, city, or ZIP code. Combine with taxonomy for queries like "all cardiologists in Maryland."
  • Combined filters: The real power comes from combining these parameters.

Understanding the response

Each NPI record contains several nested objects. The basic object holds the provider name, credential, gender, and enumeration date. The addresses array contains practice and mailing addresses. The taxonomies array lists all specialties, with one marked as primary.

Try It: Live NPPES Search
Enter a provider name, NPI number, or a query like "cardiology Maryland" to search the live NPPES registry.
Tip: Run a search above to complete the interactive portion of this lesson.
NPI FundamentalsLesson 3 of 3

Batch Lookups and CSV Export

Learn how to process hundreds or thousands of NPI lookups efficiently and export the results.

Single NPI lookups are useful for verification, but most production workloads involve batch processing.

Batch lookup strategies

  • Sequential API calls: Loop through your NPI list and call the API once per number. For 1,000 NPIs, this takes roughly 5 to 10 minutes.
  • Concurrent requests: Use 3 to 5 parallel threads. Be careful not to overwhelm the public API.
  • NPPES bulk download: For truly large-scale work, CMS publishes the entire NPPES dataset as a downloadable file (~8 GB uncompressed).

CSV export workflow

  1. Start with a CSV containing NPI numbers.
  2. For each NPI, call the NPPES API and extract the fields you need.
  3. Flatten the nested JSON response into a tabular row.
  4. Write the enriched data to a new CSV.
  5. Validate: check for deactivated NPIs (status = "D"), missing taxonomies, and address mismatches.

Using Cognizant Cloud for batch work

NPI ProLookup supports file uploads directly. Upload a CSV with an NPI column, select fields, and download. The NPI lookup API endpoint accepts bulk requests with up to 50 NPIs per call.

Knowledge Check
1. What is the approximate size of the full NPPES bulk download file (uncompressed)?
A 500 MB
B 2 GB
C 8 GB
D 50 GB
2. When batch processing NPIs with sequential API calls, what is a responsible request rate?
A 100 requests per second
B A few requests per second
C 1 request per minute
D No limit at all
3. In a batch export, what does a provider status of "D" indicate?
A Duplicate record
B Data pending verification
C Provider is deceased
D Deactivated NPI
Drug Data MasteryLesson 1 of 3

Understanding RxNorm and Drug Naming

Learn how RxNorm provides a standardized naming system for clinical drugs and why it matters for data interoperability.

RxNorm is a standardized naming system maintained by the National Library of Medicine (NLM) that provides a consistent way to identify drugs across different systems. In healthcare data, the same medication can appear under dozens of names. RxNorm solves this by assigning each drug concept a unique RxCUI (RxNorm Concept Unique Identifier).

Why drug naming is so complex

  • Brand vs. generic: "Lipitor" and "atorvastatin" refer to the same active ingredient. RxNorm maps both to the same concept hierarchy.
  • Dose forms and strengths: "Atorvastatin 20 MG Oral Tablet" and "Atorvastatin 40 MG Oral Tablet" are different clinical drugs in RxNorm.
  • Combination products: Drugs with multiple active ingredients have their own concept entries.
  • Term types: RxNorm organizes concepts into term types: IN (ingredient), SCD (semantic clinical drug), SBD (semantic branded drug), GPCK (generic pack), and others.

Using RxNorm in practice

When your data contains drug names, RxNorm normalization is the first step. You feed a drug string into the RxNorm API, and it returns the best-match RxCUI along with the standardized name, term type, and related concepts.

Try It: RxNorm Drug Resolution
Type any drug name (brand or generic) to see how RxNorm resolves it.
Drug Data MasteryLesson 2 of 3

FDA Adverse Event Data (FAERS)

Learn how to query and interpret the largest database of post-market drug safety reports in the world.

The FDA Adverse Event Reporting System (FAERS) is the largest database of post-market drug safety reports. Healthcare professionals, consumers, and drug manufacturers submit reports when they observe an adverse event that may be associated with a medication.

What FAERS data contains

  • Patient demographics: Age, sex, weight (when reported).
  • Drug information: The suspect drug(s), concomitant medications, dose, route, and indication.
  • Adverse reactions: Coded using MedDRA preferred terms.
  • Outcomes: Hospitalization, disability, death, or required intervention.
  • Report source: Healthcare professional, consumer, or manufacturer.

Important caveats

FAERS data has known limitations. Reports are voluntary, so the data underrepresents actual adverse event frequency. A report does not establish that the drug caused the event. Despite these limitations, FAERS remains an essential resource for pharmacovigilance.

Try It: Search FAERS Adverse Events
Enter a drug name to pull real adverse event data from the FDA's FAERS database.
Drug Data MasteryLesson 3 of 3

Drug Recalls and Safety Signals

Understand how the FDA classifies recalls, how safety signals are detected, and the journey from signal to regulatory action.

A safety signal is a pattern in the data that suggests a potential risk. A recall is a formal action taken by a manufacturer to remove or correct a product.

Recall classifications

  • Class I: The most serious. Reasonable probability of serious adverse health consequences or death.
  • Class II: May cause temporary or medically reversible adverse health consequences. The most common class.
  • Class III: Unlikely to cause adverse health consequences. Typically labeling or packaging issues.

How safety signals are detected

  1. Disproportionality analysis: Statistical methods comparing a drug's adverse event rate against the background rate across all drugs.
  2. Case series review: Manual review of individual case reports describing serious or unexpected events.
  3. Temporal clustering: A sudden increase in reports for a specific drug/event combination.
  4. Literature monitoring: Published case reports and studies validated against FAERS data.

From signal to action

When the FDA identifies a validated safety signal, the response can range from updating the drug label, to requiring a Risk Evaluation and Mitigation Strategy (REMS), to requesting a voluntary recall. In rare cases, the FDA can mandate a market withdrawal.

Knowledge Check
1. Which recall class represents the most serious health risk?
A Class I
B Class II
C Class III
D All classes carry equal risk
2. What statistical approach compares a drug's adverse event rate against the background rate?
A Randomized controlled trial
B Disproportionality analysis
C Bayesian meta-analysis
D Kaplan-Meier estimation
3. What does REMS stand for in FDA drug safety?
A Regulatory Enforcement Management System
B Rapid Event Monitoring Service
C Risk Evaluation and Mitigation Strategy
D Recall and Enforcement Monitoring Standard