{"id":41494,"date":"2026-06-22T21:27:20","date_gmt":"2026-06-22T19:27:20","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/fda-novel-drug-approvals-2021-2024-us-nonprofit-hospital-charity-care-reporting-parquet-json-csv-public-domain\/"},"modified":"2026-06-22T21:27:20","modified_gmt":"2026-06-22T19:27:20","slug":"fda-novel-drug-approvals-2021-2024-us-nonprofit-hospital-charity-care-reporting-parquet-json-csv-public-domain","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/fda-novel-drug-approvals-2021-2024-us-nonprofit-hospital-charity-care-reporting-parquet-json-csv-public-domain\/","title":{"rendered":"FDA Novel Drug Approvals (2021\u20132024) + US Nonprofit Hospital Charity-care Reporting \u2014 Parquet\/JSON\/CSV, Public Domain"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Disclosure: I&#8217;m the author of the open-source project (trove) that parses and repackages these. Original government sources are linked below; my bundles are at the end. MIT code, public-domain data, nothing paid.<\/p>\n<p>Two public-domain US healthcare datasets that get cited constantly but are painful to use in raw form:<\/p>\n<ol>\n<li>FDA novel drug approvals, 2021\u20132024 \u2014 218 drugs (192 CDER NMEs + 26 CBER cell &amp; gene therapies). Each row: application number, sponsor, approval date, indication, regulatory center, and a deep link to the approval-package docs.<\/li>\n<\/ol>\n<p>Original sources:<\/p>\n<p>&#8211; CDER Novel Drug Approvals: <a href=\"https:\/\/www.fda.gov\/drugs\/development-approval-process-drugs\/novel-drug-approvals-fda\">https:\/\/www.fda.gov\/drugs\/development-approval-process-drugs\/novel-drug-approvals-fda<\/a><\/p>\n<p>&#8211; CBER Approved Cellular and Gene Therapy Products: <a href=\"https:\/\/www.fda.gov\/vaccines-blood-biologics\/cellular-gene-therapy-products\/approved-cellular-and-gene-therapy-products\">https:\/\/www.fda.gov\/vaccines-blood-biologics\/cellular-gene-therapy-products\/approved-cellular-and-gene-therapy-products<\/a><\/p>\n<p>&#8211; Drugs@FDA: <a href=\"https:\/\/www.fda.gov\/drugsatfda\">https:\/\/www.fda.gov\/drugsatfda<\/a><\/p>\n<ol>\n<li>Nonprofit hospital charity-care reporting, TY2022 \u2014 1,295 nonprofit hospital systems, with CMS HCRIS Worksheet S-10 and IRS Form 990 Schedule H side by side. Both lines are meant to capture the cost of care for patients who couldn&#8217;t pay, but the rules diverge, so the two numbers often disagree. Each row also carries a CDC Social Vulnerability Index county percentile and a deep link to the 990 on ProPublica.<\/li>\n<\/ol>\n<p>Original sources:<\/p>\n<p>&#8211; CMS HCRIS (Hospital 2552-10 cost reports): <a href=\"https:\/\/www.cms.gov\/data-research\/statistics-trends-and-reports\/cost-reports\/hospital-2552-2010-form\">https:\/\/www.cms.gov\/data-research\/statistics-trends-and-reports\/cost-reports\/hospital-2552-2010-form<\/a><\/p>\n<p>&#8211; IRS Form 990 series XML downloads: <a href=\"https:\/\/www.irs.gov\/charities-non-profits\/form-990-series-downloads\">https:\/\/www.irs.gov\/charities-non-profits\/form-990-series-downloads<\/a><\/p>\n<p>&#8211; CDC Social Vulnerability Index 2022: <a href=\"https:\/\/www.atsdr.cdc.gov\/place-health\/php\/svi\/index.html\">https:\/\/www.atsdr.cdc.gov\/place-health\/php\/svi\/index.html<\/a><\/p>\n<p>&#8211; ProPublica Nonprofit Explorer (where the 990 deep links point): <a href=\"https:\/\/projects.propublica.org\/nonprofits\/\">https:\/\/projects.propublica.org\/nonprofits\/<\/a><\/p>\n<p>What I added on top: parsing the raw formats (headerless 100k-row HCRIS CSVs, IRS bulk-XML ZIPs, hundreds of FDA PDF directories) into tidy Parquet\/JSON\/CSV, plus a CCN\u2194EIN crosswalk that joins the two hospital filings.<\/p>\n<p>My packaged bundles + parsers (self-promo \u2014 I built this): <a href=\"https:\/\/github.com\/cbetz\/trove\">https:\/\/github.com\/cbetz\/trove<\/a> \u2014 browsable lookup at <a href=\"https:\/\/troveproject.com\/\">https:\/\/troveproject.com<\/a><\/p>\n<p>Happy to answer questions about the parsing or add fields people want!<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/scrapdog\"> \/u\/scrapdog <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1ucty66\/fda_novel_drug_approvals_20212024_us_nonprofit\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1ucty66\/fda_novel_drug_approvals_20212024_us_nonprofit\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-41494 jlk' href='javascript:void(0)' data-task='like' data-post_id='41494' data-nonce='a8b0fd065c' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-41494 lc'>0<\/span><\/a><\/div><\/div> <div class='status-41494 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Disclosure: I&#8217;m the author of the open-source project (trove) that parses and repackages these. Original government sources&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-41494","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/41494","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=41494"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/41494\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=41494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=41494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=41494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}