SQL and Chart LLM Generator
Home
Generate Chart
Chart History
SQL and Chart LLM Generator for the FDA Orange Book
Describe the data you want to analyze, and we'll generate SQL queries and visualizations from the FDA Orange Book database.
About the FDA Orange Book
Example Prompts
Compare generic and new drug applications by year
Approvals
Show the trend of drug approvals over the past 20 years
Approvals
Compare the distribution of different application types (A vs N)
Approvals
Show the number of patents expiring by year for the next 10 years
Patents
Compare drug substance vs drug product patents
Patents
Show the most common patent use codes
Patents
Show the top 15 companies by number of approved products
Companies
Show approval trends for the top 5 pharmaceutical companies over the past 10 years
Companies
Show patents by the top 10 companies
Companies
Show the distribution of routes of administration
Routes
Show the most common dosage forms
Routes
Show how routes of administration have changed over the past 20 years
Routes
Show the different types of exclusivities granted
Exclusivities
Show the number of exclusivities granted by year
Exclusivities
Show the distribution of exclusivity durations
Exclusivities
Show the relationship between approval dates and patent expiration dates
Cross-category
Show the top 10 companies and their most common routes of administration
Cross-category
Show approvals and their associated exclusivities
Cross-category
Show drugs with both patents and exclusivities
Cross-category
Show approval trends for different routes of administration
Cross-category
What kind of data would you like to analyze?
Generate Chart