When using Snowflake without Precog, the data must first be downloaded from the source. This immediately makes stale data more likely and introduces risks associated with incorrect or outdated results.
Dealing with pagination
Like many web data sources, FDA.gov provides data in a paginated manner. This means that the dataset is not available as a single document but is available as multiple documents. Without Precog, we must first download all the pages with a bash command such as the following:
next=$({ curl -v -g 'https://api.fda.gov/drug/event.json?limit=100&search=patient.drug.drugindication.exact:OSTEOARTHRITIS&api_key=' 2>&1 1>event.json | perl -0777 -ne 'print "$&\n" if /(?:(?!<).)*?(?=>; rel="next")/'; }) && while [ "$next" != "" ]; do next=$({ curl -v -g "$next&api_key=" 2>&1 1>>event.json | perl -0777 -ne 'print "$&\n" if /(?:(?!<).)*?(?=>; rel="next")/'; }); done
You will need to replace with an OpenFDA API key.
Loading the data into Snowflake
Snowflake allows us to load the data into a table that has a column with the type variant
.
Unfortunately, Snowflake’s UI prevents us from loading this dataset.
Instead, we can download and install SnowSQL, then load our data as follows (making sure to set our warehouse to XSMALL before beginning so that we don’t spend all of our credits):
snowsql -a Precog -u becky
create or replace warehouse example with warehouse_size = xsmall auto_suspend = 300;
use warehouse EXAMPLE;
use database TEST_DB;
create or replace file format json_format type = 'JSON' strip_outer_array = false;
create or replace stage raw_json file_format = json_format;
put file:///Users/beckyconning/event.json @raw_json;
create or replace table event_raw(data variant);
copy into event_raw from @raw_json;
As shown in this error, Snowflake has a limit on the size of JSON documents. Precog does not have any limit on the size of JSON documents and is tested on datasets containing 30GB documents.
100069 (22P02): Error parsing JSON: document is too large, max size 16777216 bytes
File 'stages/e15cb2fa-ac92-4a2d-95af-fee5665a904a/event.json.gz', line 7881707, character 47
Row 40 starts at line 7447303, column DATA
If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client.
When we don’t have control over the size of our JSON documents, we cannot use Snowflake alone to analyse them. Luckily, in this case, we can reduce the number of records in each page retrieved by our script. This will take about four times longer to retrieve.
next=$({ curl -v -g 'https://api.fda.gov/drug/event.json?limit=25&search=patient.drug.drugindication.exact:OSTEOARTHRITIS&api_key=' 2>&1 1>event.json | perl -0777 -ne 'print "$&\n" if /(?:(?!<).)*?(?=>; rel="next")/'; }) && while [ "$next" != "" ]; do next=$({ curl -v -g "$next&api_key=" 2>&1 1>>event.json | perl -0777 -ne 'print "$&\n" if /(?:(?!<).)*?(?=>; rel="next")/'; }); done
snowsql -a Precog -u becky
create or replace warehouse example with warehouse_size = xsmall auto_suspend = 300;
use warehouse EXAMPLE;
use database TEST_DB;
create or replace file format json_format type = 'JSON' strip_outer_array = false;
create or replace stage raw_json file_format = json_format;
put file:///Users/beckyconning/event.json @raw_json;
create or replace table event_raw(data variant);
copy into event_raw from @raw_json;
Exploring the data in Snowflake
We can now start to explore the non-tabular data by disecting a small sample of the data.
select * from event_raw limit 1;
select results.value
from event_raw,
lateral flatten (input => data, path => 'results') results
limit 1;
Which returns the following:
+-------------------------------------------------------------------+
| VALUE |
|-------------------------------------------------------------------|
| { |
| "companynumb": "US-PFIZER INC-2015467764", |
| "duplicate": "1", |
| "fulfillexpeditecriteria": "2", |
| "occurcountry": "US", |
| "patient": { |
| "drug": [ |
| { |
| "activesubstance": { |
| "activesubstancename": "INSULIN GLARGINE" |
| }, |
| "drugcharacterization": "2", |
| "drugdosagetext": "46 UNIT, UNK", |
| "drugintervaldosagedefinition": "804", |
| "drugintervaldosageunitnumb": "1", |
| "drugseparatedosagenumb": "1", |
| "drugstartdate": "20141120", |
| "drugstartdateformat": "102", |
| "drugstructuredosagenumb": "46", |
| "drugstructuredosageunit": "032", |
| "medicinalproduct": "LANTUS", |
| "openfda": {} |
| }, |
| { |
| "activesubstance": { |
| "activesubstancename": "INSULIN GLARGINE" |
| }, |
| "drugcharacterization": "2", |
| "drugdosagetext": "50 UNIT, QD", |
| "drugintervaldosagedefinition": "804", |
| "drugintervaldosageunitnumb": "1", |
| "drugseparatedosagenumb": "1", |
| "drugstartdate": "20150323", |
| "drugstartdateformat": "102", |
| "drugstructuredosagenumb": "50", |
| "drugstructuredosageunit": "032", |
| "medicinalproduct": "LANTUS", |
| "openfda": {} |
| }, |
| { |
| "activesubstance": { |
| "activesubstancename": "SULFAMETHOXAZOLE\\TRIMETHOPRIM" |
| }, |
| "drugadministrationroute": "065", |
| "drugcharacterization": "2", |
| "drugdosagetext": "1 TAB, BID", |
| "drugindication": "CHRONIC SINUSITIS", |
| "drugintervaldosagedefinition": "804", |
| "drugintervaldosageunitnumb": "1", |
| "drugseparatedosagenumb": "2", |
| "drugstructuredosagenumb": "1", |
| "drugstructuredosageunit": "032", |
| "medicinalproduct": "BACTRIM DS", |
| "openfda": { |
| "application_number": [ |
| "NDA017377" |
| ], |
| "brand_name": [ |
| "BACTRIM DS" |
| ], |
| "generic_name": [ |
| "SULFAMETHOXAZOLE AND TRIMETHOPRIM" |
| ], |
| "manufacturer_name": [ |
| "Sun Pharmaceutical Industries, Inc" |
| ], |
| "package_ndc": [ |
| "49708-146-01", |
| "49708-145-01" |
| ], |
| "product_ndc": [ |
| "49708-146", |
| "49708-145" |
| ], |
| "product_type": [ |
| "HUMAN PRESCRIPTION DRUG" |
| ], |
| "route": [ |
| "ORAL" |
| ], |
| "rxcui": [ |
| "198334", |
| "198335", |
| "849580", |
| "208416" |
| ], |
| "spl_id": [ |
| "72efc062-e8e3-bc81-e053-2991aa0ac4d8" |
| ], |
| "spl_set_id": [ |
| "f59d0c04-9c66-4d53-a0e1-cb55570deb62" |
| ], |
| "substance_name": [ |
| "TRIMETHOPRIM", |
| "SULFAMETHOXAZOLE" |
| ], |
| "unii": [ |
| "AN164J8Y0X", |
| "JE42381TNV" |
| ] |
| } |
| }, |
| { |
| "activesubstance": { |
| "activesubstancename": "BENAZEPRIL HYDROCHLORIDE" |
| }, |
| "drugadministrationroute": "048", |
| "drugcharacterization": "2", |
| "drugdosageform": "TABLET", |
| "drugdosagetext": "1 TAB, BID", |
| "drugindication": "DIABETES MELLITUS", |
| "drugintervaldosagedefinition": "804", |
| "drugintervaldosageunitnumb": "1", |
| "drugseparatedosagenumb": "2", |
| "drugstartdate": "20150420", |
| "drugstartdateformat": "102", |
| "drugstructuredosagenumb": "1", |
| "drugstructuredosageunit": "032", |
| "medicinalproduct": "BENAZEPRIL HCL", |
| "openfda": {} |
| }, |
| { |
| "actiondrug": "5", |
| "activesubstance": { |
| "activesubstancename": "PREGABALIN" |
| }, |
| "drugadditional": "3", |
| "drugadministrationroute": "065", |
| "drugauthorizationnumb": "021446", |
| "drugcharacterization": "1", |
| "drugindication": "DIABETES MELLITUS", |
| "medicinalproduct": "LYRICA", |
| "openfda": { |
| "application_number": [ |
| "NDA021446", |
| "NDA022488" |
| ], |
| "brand_name": [ |
| "LYRICA" |
| ], |
| "generic_name": [ |
| "PREGABALIN" |
| ], |
| "manufacturer_name": [ |
| "U.S. Pharmaceuticals", |
| "Parke-Davis Div of Pfizer Inc" |
| ], |
| "package_ndc": [ |
| "0071-1018-68", |
| "0071-1016-41", |
| "0071-1012-68", |
| "0071-1014-41", |
| "0071-1015-68", |
| "0071-1019-68", |
| "0071-1014-68", |
| "63539-014-90", |
| "0071-1015-41", |
| "63539-013-41", |
| "0071-1016-68", |
| "0071-1020-01", |
| "0071-1013-68", |
| "0071-1013-41", |
| "0071-1017-68" |
| ], |
| "product_ndc": [ |
| "0071-1012", |
| "0071-1013", |
| "0071-1014", |
| "0071-1015", |
| "0071-1016", |
| "0071-1017", |
| "0071-1018", |
| "0071-1019", |
| "63539-014", |
| "63539-013", |
| "0071-1020" |
| ], |
| "product_type": [ |
| "HUMAN PRESCRIPTION DRUG" |
| ], |
| "route": [ |
| "ORAL" |
| ], |
| "rxcui": [ |
| "607038", |
| "577127", |
| "607018", |
| "483438", |
| "898718", |
| "898715", |
| "607033", |
| "607028", |
| "607024", |
| "607026", |
| "483448", |
| "607022", |
| "607020", |
| "483442", |
| "483440", |
| "483450", |
| "483446", |
| "483444" |
| ], |
| "spl_id": [ |
| "a388b7cf-6780-4929-ba44-fb30da47e936", |
| "0fbd5d1f-30cd-464d-a1d6-71e8057a9377" |
| ], |
| "spl_set_id": [ |
| "ce1a4b9d-3127-4416-8bf2-fee5899fc0ba", |
| "60185c88-ecfd-46f9-adb9-b97c6b00a553" |
| ], |
| "substance_name": [ |
| "PREGABALIN" |
| ], |
| "unii": [ |
| "55JG375S6M" |
| ] |
| } |
| }, |
| { |
| "activesubstance": { |
| "activesubstancename": "TRAMADOL HYDROCHLORIDE" |
| }, |
| "drugadministrationroute": "065", |
| "drugcharacterization": "2", |
| "drugdosagetext": "1 TAB, Q8H", |
| "drugindication": "OSTEOARTHRITIS", |
| "drugintervaldosagedefinition": "804", |
| "drugintervaldosageunitnumb": "1", |
| "drugseparatedosagenumb": "3", |
| "drugstructuredosagenumb": "1", |
| "drugstructuredosageunit": "032", |
| "medicinalproduct": "TRAMADOL HCL", |
| "openfda": {} |
| }, |
| { |
| "activesubstance": { |
| "activesubstancename": "INSULIN GLARGINE" |
| }, |
| "drugadministrationroute": "065", |
| "drugcharacterization": "2", |
| "drugdosagetext": "34 UNIT, UNK", |
| "drugindication": "DIABETES MELLITUS", |
| "drugintervaldosagedefinition": "804", |
| "drugintervaldosageunitnumb": "1", |
| "drugseparatedosagenumb": "1", |
| "drugstartdate": "20151112", |
| "drugstartdateformat": "102", |
| "drugstructuredosagenumb": "34", |
| "drugstructuredosageunit": "032", |
| "medicinalproduct": "LANTUS", |
| "openfda": {} |
| }, |
| { |
| "activesubstance": { |
| "activesubstancename": "INSULIN HUMAN" |
| }, |
| "drugadministrationroute": "065", |
| "drugcharacterization": "2", |
| "drugdosagetext": "20 UNIT, UNK", |
| "drugindication": "DIABETES MELLITUS", |
| "drugintervaldosagedefinition": "804", |
| "drugintervaldosageunitnumb": "1", |
| "drugseparatedosagenumb": "3", |
| "drugstartdate": "20150729", |
| "drugstartdateformat": "102", |
| "drugstructuredosagenumb": "20", |
| "drugstructuredosageunit": "032", |
| "medicinalproduct": "NOVOLIN", |
| "openfda": {} |
| }, |
| { |
| "activesubstance": { |
| "activesubstancename": "METFORMIN HYDROCHLORIDE" |
| }, |
| "drugadministrationroute": "065", |
| "drugcharacterization": "2", |
| "drugdosageform": "TABLET", |
| "drugdosagetext": "1 TAB, BID", |
| "drugindication": "DIABETES MELLITUS", |
| "drugintervaldosagedefinition": "804", |
| "drugintervaldosageunitnumb": "1", |
| "drugseparatedosagenumb": "2", |
| "drugstartdate": "20150330", |
| "drugstartdateformat": "102", |
| "drugstructuredosagenumb": "1", |
| "drugstructuredosageunit": "032", |
| "medicinalproduct": "METFORMIN HYDROCHLORIDE.", |
| "openfda": { |
| "application_number": [ |
| "ANDA090888", |
| "ANDA090564", |
| "ANDA206955", |
| "NDA021591", |
| "ANDA207427", |
| "ANDA203769", |
| "ANDA078596", |
| "ANDA201991", |
| "ANDA076706", |
| "ANDA208999", |
| "ANDA076172", |
| "ANDA205096", |
| "ANDA076033", |
| "ANDA079148", |
| "NDA021202", |
| "ANDA075965", |
| "ANDA205330", |
| "ANDA075967", |
| "NDA021748", |
| "ANDA077078", |
| "ANDA090295", |
| "ANDA202917", |
| "ANDA076873", |
| "NDA020357", |
| "ANDA090692", |
| "ANDA206145", |
| "ANDA077336", |
| "ANDA209303", |
| "ANDA077880", |
| "ANDA076269", |
| "ANDA077095", |
| "ANDA076864", |
| "ANDA078321", |
| "ANDA203755", |
| "ANDA202306", |
| "ANDA079118", |
| "ANDA203832", |
| "NDA021574", |
| "ANDA200690", |
| "ANDA091664", |
| "ANDA203686", |
| "ANDA209993", |
| "ANDA076869", |
| "ANDA075973", |
| "ANDA209882", |
| "ANDA091184", |
| "ANDA077064", |
| "ANDA077060" |
| ], |
| "brand_name": [ |
| "GLUCOPHAGE", |
| "FORTAMET", |
| "METFORMIN HYDROCHLORIDE", |
| "RIOMET", |
| "METFORMIN HYDROCHLORIDE EXTENDED RELEASE", |
| "GLUCOPHAGE XR", |
| "GLUMETZA", |
| "METFORMIN HYDROCHLORIDE ER" |
| ], |
| "generic_name": [ |
| "METFORMIN", |
| "METFORMIN HYDROCHLORIDE TABLET", |
| "METFORMIN HYDROCHLORIDE", |
| "METFORMIN HYDROCHLORIDE EXTENDED-RELEASE TABLETS", |
| "METFORMIN HYDROCHLORIDE TABLETS" |
| ], |
| "manufacturer_name": [ |
| "PuraCap Laboratories LLC dba Blu Pharmaceuticals", |
| "Amneal Pharmaceuticals LLC", |
| "IntelliPharmaCeutics Corp.", |
| "ACI Healthcare USA, Inc.", |
| "Heritage Pharmaceuticals Inc.", |
| "Lupin Pharmaceuticals, Inc.", |
| "ScieGen Pharmaceuticals Inc", |
| "NorthStar RxLLC", |
| "Viona Pharmaceuticals Inc", |
| "Bayshore Pharmaceuticals LLC", |
| "Mylan Pharmaceuticals Inc.", |
| "Aurobindo Pharma Limited", |
| "Oceanside Pharmaceuticals", |
| "Ingenus Pharmaceuticals, LLC", |
| "INNOVIDA PHARMACEUTIQUE CORPORATION", |
| "Zydus Pharmaceuticals (USA) Inc.", |
| "MARKSANS PHARMA LIMITED", |
| "AvKARE, Inc.", |
| "Carlsbad Technology, Inc.", |
| "Amneal Pharmaceuticals of New York LLC", |
| "Golden State Medical Supply, Inc", |
| "Bristol-Myers Squibb Company", |
| "Qingdao BAHEAL Pharmaceutical Co., Ltd.", |
| "H. J. Harkins Company Inc.", |
| "Shionogi Inc.", |
| "EPIC PHARMA, LLC", |
| "Actavis Pharma, Inc.", |
| "New Horizon Rx Group, LLC", |
| "Breckenridge Pharmaceutical, Inc.", |
| "Metcure Pharmaceuticals, Inc.", |
| "Megalith Pharmaceuticals Inc", |
| "Ascend Laboratories, LLC", |
| "Laurus Labs Limited", |
| "Granules India Ltd", |
| "Eon Labs, Inc.", |
| "INDICUS PHARMA LLC", |
| "Sunshine Lake Pharma Co., Ltd.", |
| "Cadila Healthcare Limited", |
| "TAGI Pharma, Inc.", |
| "TIME CAP LABORATORIES, INC", |
| "AlignScience Pharma Inc.", |
| "Teva Pharmaceuticals USA, Inc.", |
| "Solco healthcare U.S., LLC", |
| "Epic Pharma, LLC", |
| "Westminster Pharmaceuticals, LLC", |
| "SANDOZ INC.", |
| "Nostrum Laboratories, Inc.", |
| "Sun Pharmaceutical Industries, Inc.", |
| "Santarus, Inc.", |
| "Macleods Pharmaceuticals Limited", |
| "GRAXCELL PHARMACEUTICAL, LLC.", |
| "Granules Pharmaceuticals Inc.", |
| "Apotex Corp." |
| ], |
| "package_ndc": [ |
| "57664-474-58", |
| "65862-292-01", |
| "65862-292-05", |
| "70795-1160-0", |
| "70795-1160-5", |
| "33342-141-10", |
| "33342-141-11", |
| "62207-442-49", |
| "65862-009-90", |
| "24724-016-01", |
| "51224-007-50", |
| "62207-442-43", |
| "68382-760-01", |
| "0093-7267-01", |
| "62207-442-47", |
| "68382-760-05", |
| "71093-132-06", |
| "71093-132-04", |
| "71093-132-05", |
| "68180-339-01", |
| "50228-107-10", |
| "60429-113-05", |
| "68180-339-09", |
| "60505-0190-3", |
| "65862-009-01", |
| "65862-009-05", |
| "68382-758-01", |
| "51991-805-05", |
| "68382-758-05", |
| "51991-805-01", |
| "51991-807-05", |
| "35208-002-10", |
| "51224-220-60", |
| "42806-405-60", |
| "53746-178-30", |
| "68382-028-30", |
| "57664-474-53", |
| "60505-0191-3", |
| "0591-2411-30", |
| "23155-102-10", |
| "60505-0191-0", |
| "60505-0191-8", |
| "65162-220-50", |
| "65841-030-05", |
| "65841-030-01", |
| "53746-218-01", |
| "25000-101-12", |
| "51224-007-70", |
| "65162-218-50", |
| "0591-2411-10", |
| "50742-156-05", |
| "53746-220-01", |
| "68382-758-77", |
| "68382-759-77", |
| "50742-156-01", |
| "53746-220-05", |
| "65841-809-10", |
| "50742-154-10", |
| "65862-009-99", |
| "65841-809-16", |
| "43547-320-11", |
| "43547-320-10", |
| "35208-001-10", |
| "53746-219-05", |
| "53746-219-01", |
| "65862-008-50", |
| "57664-397-58", |
| "71717-104-11", |
| "42291-605-27", |
| "24724-015-50", |
| "60429-111-60", |
| "42291-607-60", |
| "42806-213-10", |
| "65862-010-50", |
| "33342-143-44", |
| "24658-790-01", |
| "0087-6060-10", |
| "71709-111-07", |
| "71709-111-06", |
| "68180-339-02", |
| "29033-032-06", |
| "68682-018-90", |
| "67877-413-10", |
| "50742-156-90", |
| "60429-111-10", |
| "60429-111-12", |
| "60429-111-18", |
| "53746-179-90", |
| "65862-009-50", |
| "67877-221-05", |
| "68382-030-01", |
| "67877-221-01", |
| "68382-030-05", |
| "67877-217-05", |
| "70010-065-05", |
| "67877-217-01", |
| "25000-102-12", |
| "33342-142-10", |
| "48792-7861-1", |
| "69367-180-01", |
| "48792-7862-1", |
| "69367-180-05", |
| "70010-065-09", |
| "70010-063-01", |
| "33342-141-44", |
| "60505-0190-8", |
| "29033-031-06", |
| "69948-001-05", |
| "24724-016-50", |
| "60505-0190-0", |
| "60505-0190-1", |
| "65162-220-11", |
| "65162-220-10", |
| "53746-179-01", |
| "65841-028-10", |
| "51224-107-60", |
| "65841-028-16", |
| "42806-215-01", |
| "42806-215-05", |
| "70010-065-01", |
| "42291-605-10", |
| "42291-605-12", |
| "70010-065-06", |
| "68382-758-30", |
| "42291-605-18", |
| "24724-014-01", |
| "47335-305-83", |
| "47335-305-88", |
| "49483-623-50", |
| "65862-008-90", |
| "61442-363-01", |
| "65862-008-99", |
| "42385-902-10", |
| "42291-605-60", |
| "62037-577-01", |
| "65841-811-16", |
| "50228-106-30", |
| "62207-440-57", |
| "62207-440-50", |
| "71717-106-11", |
| "47335-306-18", |
| "61442-363-05", |
| "61442-361-10", |
| "65162-219-03", |
| "68382-039-01", |
| "68382-759-01", |
| "68382-039-05", |
| "33342-240-11", |
| "68382-759-05", |
| "47335-305-18", |
| "53746-178-90", |
| "0093-7212-01", |
| "23155-103-05", |
| "65162-218-10", |
| "65162-218-11", |
| "65862-008-05", |
| "65862-008-01", |
| "42291-606-10", |
| "71717-105-10", |
| "23155-103-01", |
| "49483-624-01", |
| "42291-607-90", |
| "10631-238-01", |
| "25000-102-53", |
| "65862-010-60", |
| "60429-112-05", |
| "51991-806-10", |
| "43547-322-11", |
| "51224-020-50", |
| "65841-811-10", |
| "51224-120-70", |
| "70010-064-09", |
| "0087-6070-05", |
| "50228-105-30", |
| "60429-112-90", |
| "60429-111-27", |
| "60505-0191-1", |
| "68180-337-02", |
| "68382-760-16", |
| "68382-760-10", |
| "0093-7267-10", |
| "50228-107-01", |
| "50228-107-00", |
| "25000-101-97", |
| "50228-107-05", |
| "67877-217-33", |
| "50742-155-10", |
| "25000-101-98", |
| "60429-113-10", |
| "43547-321-10", |
| "43547-321-11", |
| "71093-134-04", |
| "71093-134-05", |
| "16714-938-01", |
| "50742-154-90", |
| "51991-805-10", |
| "51991-807-10", |
| "51224-220-70", |
| "23155-102-09", |
| "49483-623-10", |
| "23155-102-05", |
| "23155-102-06", |
| "23155-102-01", |
| "70010-064-01", |
| "68382-029-30", |
| "70010-064-06", |
| "65862-292-30", |
| "65841-030-30", |
| "35208-002-90", |
| "70010-064-05", |
| "25000-101-03", |
| "67877-414-33", |
| "0591-2411-01", |
| "60505-0260-1", |
| "60505-0260-2", |
| "50742-156-10", |
| "65841-809-01", |
| "65841-809-05", |
| "71709-110-06", |
| "71709-110-07", |
| "0378-6001-91", |
| "0378-7187-05", |
| "60505-1329-1", |
| "65862-008-45", |
| "62756-143-01", |
| "0591-2719-60", |
| "72578-035-01", |
| "65841-810-16", |
| "72578-035-05", |
| "53746-179-30", |
| "68682-021-50", |
| "43547-322-50", |
| "57664-435-51", |
| "67877-159-05", |
| "0087-6060-05", |
| "67877-159-01", |
| "57664-435-59", |
| "57664-435-58", |
| "67877-413-05", |
| "57664-435-53", |
| "0087-6071-11", |
| "67877-413-01", |
| "65841-029-10", |
| "68382-760-30", |
| "65841-029-16", |
| "51224-007-60", |
| "65862-009-60", |
| "68382-030-16", |
| "68382-030-10", |
| "42291-606-27", |
| "67877-221-10", |
| "68012-002-13", |
| "62037-577-10", |
| "43547-321-50", |
| "71717-105-50", |
| "67877-218-33", |
| "68180-338-03", |
| "67877-218-38", |
| "68180-338-01", |
| "68382-028-10", |
| "70795-1170-0", |
| "68382-028-16", |
| "68382-029-77", |
| "33342-142-44", |
| "65841-030-77", |
| "61442-362-05", |
| "50228-107-30", |
| "70247-018-60", |
| "42806-215-10", |
| "65841-811-77", |
| "70010-063-10", |
| "0591-2412-30", |
| "53746-178-10", |
| "65862-291-05", |
| "24658-791-05", |
| "65862-291-01", |
| "23155-104-10", |
| "42385-902-01", |
| "68382-029-05", |
| "42385-902-05", |
| "68382-029-01", |
| "42385-902-06", |
| "24724-015-01", |
| "65841-028-77", |
| "50228-106-00", |
| "50228-106-01", |
| "50228-106-05", |
| "62207-440-47", |
| "62207-441-49", |
| "62207-440-43", |
| "57664-474-59", |
| "62207-441-43", |
| "57664-474-51", |
| "62207-440-49", |
| "62207-441-47", |
| "61442-361-01", |
| "68382-759-16", |
| "61442-361-05", |
| "68382-759-10", |
| "65162-219-11", |
| "65162-219-10", |
| "68180-336-01", |
| "68180-336-02", |
| "65841-809-77", |
| "68180-336-07", |
| "16714-939-01", |
| "70795-1170-5", |
| "65162-218-03", |
| "65862-008-33", |
| "42806-221-10", |
| "42291-606-18", |
| "23155-103-06", |
| "57664-397-53", |
| "50742-155-90", |
| "57664-397-51", |
| "53746-179-05", |
| "60429-113-90", |
| "51224-020-60", |
| "57664-397-59", |
| "23155-103-09", |
| "51224-120-60", |
| "42291-606-90", |
| "42291-607-10", |
| "47335-306-81", |
| "60505-1329-5", |
| "60505-1329-3", |
| "60429-111-36", |
| "42291-607-18", |
| "47335-306-83", |
| "0378-7185-05", |
| "76385-128-01", |
| "50742-155-05", |
| "50742-155-01", |
| "53746-219-10", |
| "0378-7186-05", |
| "43547-321-00", |
| "47335-306-88", |
| "43547-322-10", |
| "62756-142-02", |
| "62756-142-01", |
| "24724-014-50", |
| "67877-218-01", |
| "67877-218-05", |
| "49483-623-01", |
| "49483-623-09", |
| "65841-039-01", |
| "65841-810-10", |
| "65841-039-05", |
| "42806-406-60", |
| "42385-904-10", |
| "65841-028-30", |
| "65162-219-50", |
| "59630-574-60", |
| "65841-809-30", |
| "0185-4416-01", |
| "0185-4416-05", |
| "65841-027-05", |
| "65841-027-01", |
| "68180-338-02", |
| "62037-571-01", |
| "10631-238-02", |
| "42291-605-45", |
| "49483-624-50", |
| "76519-1152-3", |
| "60429-111-45", |
| "65862-010-33", |
| "70010-064-10", |
| "67877-159-10", |
| "33342-239-11", |
| "0378-6002-91", |
| "67877-413-33", |
| "53746-218-05", |
| "65841-029-05", |
| "65841-029-01", |
| "0591-2720-60", |
| "0185-4416-75", |
| "67877-414-05", |
| "67877-414-01", |
| "59630-575-60", |
| "60429-112-60", |
| "62037-577-05", |
| "33342-143-10", |
| "33342-143-11", |
| "60429-113-60", |
| "69367-182-01", |
| "42385-903-01", |
| "69367-182-05", |
| "42385-903-05", |
| "42385-903-09", |
| "51224-120-50", |
| "50228-105-10", |
| "65841-810-05", |
| "68012-002-92", |
| "68180-337-01", |
| "65841-810-01", |
| "68180-337-07", |
| "61442-362-01", |
| "68382-028-01", |
| "68382-028-05", |
| "62207-442-57", |
| "62207-442-50", |
| "58517-040-90", |
| "62037-571-90", |
| "76385-128-50", |
| "68012-003-16", |
| "68382-758-16", |
| "42291-605-36", |
| "68382-758-10", |
| "69367-181-01", |
| "53746-178-05", |
| "69367-181-05", |
| "53746-178-01", |
| "65862-291-30", |
| "23155-104-06", |
| "23155-104-05", |
| "68012-003-97", |
| "23155-104-01", |
| "10631-206-01", |
| "68382-029-16", |
| "42385-903-10", |
| "10631-206-02", |
| "23155-104-09", |
| "68382-029-10", |
| "62037-571-05", |
| "65841-030-16", |
| "65841-030-10", |
| "50228-106-10", |
| "51991-807-01", |
| "62207-441-50", |
| "62207-441-57", |
| "53746-220-10", |
| "50742-154-05", |
| "50742-154-01", |
| "43547-320-00", |
| "71093-133-05", |
| "71093-133-04", |
| "60429-113-18", |
| "71709-112-06", |
| "71709-112-07", |
| "60429-112-01", |
| "24658-792-05", |
| "42806-221-05", |
| "42806-221-01", |
| "65841-810-30", |
| "60429-111-90", |
| "42806-213-05", |
| "60429-112-27", |
| "42806-213-01", |
| "76385-129-50", |
| "23155-103-10", |
| "65862-010-46", |
| "51224-020-70", |
| "24658-790-10", |
| "60429-111-01", |
| "35208-001-90", |
| "65841-029-30", |
| "65862-009-44", |
| "67877-217-38", |
| "68382-030-30", |
| "68382-027-01", |
| "68382-760-77", |
| "68382-027-05", |
| "33342-142-11", |
| "76385-128-10", |
| "25000-102-03", |
| "67877-217-10", |
| "70010-063-06", |
| "70010-063-05", |
| "70010-063-09", |
| "65862-009-33", |
| "51224-220-50", |
| "67877-218-10", |
| "60505-0192-0", |
| "60505-0192-1", |
| "68382-028-77", |
| "69948-001-12", |
| "42385-904-09", |
| "65162-220-03", |
| "42385-904-01", |
| "65841-028-05", |
| "42385-904-05", |
| "65841-028-01", |
| "51224-107-50", |
| "0087-6064-13", |
| "25000-102-98", |
| "68012-004-50", |
| "70010-065-10", |
| "0591-2412-19", |
| "0591-2412-10", |
| "51991-806-05", |
| "65841-811-30", |
| "60505-0192-8", |
| "65862-008-60", |
| "65841-811-05", |
| "65841-811-01", |
| "51991-806-01", |
| "65862-010-05", |
| "65862-010-01", |
| "70247-019-60", |
| "42291-605-90", |
| "68382-759-30", |
| "72578-036-05", |
| "72578-036-01", |
| "0087-6063-13", |
| "53746-218-10", |
| "43547-320-50", |
| "65841-029-77", |
| "67877-414-10", |
| "48792-7863-1", |
| "68382-030-77", |
| "67877-221-33", |
| "71800-008-01", |
| "67877-221-38", |
| "65862-010-99", |
| "60429-112-18", |
| "65862-010-90", |
| "0781-5503-01", |
| "60505-0192-3", |
| "43547-322-00", |
| "62037-571-10", |
| "76385-129-01", |
| "50228-105-05", |
| "50228-105-01", |
| "50228-105-00", |
| "68682-017-10", |
| "65841-810-77" |
| ], |
| "product_ndc": [ |
| "67877-413", |
| "67877-414", |
| "65841-030", |
| "43547-320", |
| "43547-321", |
| "43547-322", |
| "65841-039", |
| "33342-240", |
| "76385-128", |
| "76385-129", |
| "67877-221", |
| "67877-159", |
| "51224-007", |
| "68382-760", |
| "53746-179", |
| "53746-178", |
| "42806-215", |
| "42806-213", |
| "0591-2720", |
| "65841-027", |
| "65841-028", |
| "65841-029", |
| "25000-101", |
| "23155-103", |
| "23155-102", |
| "76519-1152", |
| "60505-1329", |
| "68012-004", |
| "0378-6001", |
| "0378-6002", |
| "65862-009", |
| "65862-008", |
| "60505-0192", |
| "60505-0191", |
| "60505-0190", |
| "0093-7212", |
| "68382-028", |
| "68382-027", |
| "0087-6060", |
| "0087-6063", |
| "53746-219", |
| "0087-6064", |
| "50228-106", |
| "50228-107", |
| "50228-105", |
| "57664-474", |
| "48792-7862", |
| "48792-7863", |
| "48792-7861", |
| "62037-571", |
| "42806-406", |
| "29033-031", |
| "29033-032", |
| "42806-405", |
| "68012-003", |
| "70010-065", |
| "23155-104", |
| "65862-010", |
| "51224-107", |
| "25000-102", |
| "0185-4416", |
| "62756-143", |
| "62756-142", |
| "68382-030", |
| "53746-220", |
| "68382-039", |
| "0087-6070", |
| "0087-6071", |
| "0781-5503", |
| "68382-759", |
| "0093-7267", |
| "0591-2411", |
| "0591-2412", |
| "68682-021", |
| "0378-7186", |
| "0378-7187", |
| "35208-001", |
| "69367-180", |
| "61442-361", |
| "61442-362", |
| "33342-239", |
| "35208-002", |
| "16714-939", |
| "16714-938", |
| "71800-008", |
| "42385-903", |
| "42385-902", |
| "42385-904", |
| "42291-606", |
| "42291-607", |
| "42291-605", |
| "71717-104", |
| "71717-105", |
| "71717-106", |
| "68682-018", |
| "68682-017", |
| "49483-623", |
| "24658-791", |
| "24658-790", |
| "49483-624", |
| "24658-792", |
| "70010-064", |
| "57664-397", |
| "68180-339", |
| "51224-120", |
| "70795-1170", |
| "0378-7185", |
| "53746-218", |
| "58517-040", |
| "60429-111", |
| "60429-113", |
| "69367-181", |
| "60505-0260", |
| "70010-063", |
| "69367-182", |
| "60429-112", |
| "61442-363", |
| "71093-132", |
| "71093-133", |
| "65862-292", |
| "33342-141", |
| "33342-142", |
| "33342-143", |
| "0591-2719", |
| "65162-220", |
| "62207-442", |
| "62207-441", |
| "62207-440", |
| "51224-220", |
| "68382-758", |
| "10631-238", |
| "68180-338", |
| "65162-219", |
| "65862-291", |
| "51991-807", |
| "51991-806", |
| "51991-805", |
| "65841-811", |
| "65841-810", |
| "70795-1160", |
| "57664-435", |
| "62037-577", |
| "24724-016", |
| "24724-014", |
| "24724-015", |
| "70247-019", |
| "70247-018", |
| "68382-029", |
| "65162-218", |
| "51224-020", |
| "10631-206", |
| "71709-112", |
| "47335-306", |
| "47335-305", |
| "68012-002", |
| "71093-134", |
| "71709-110", |
| "65841-809", |
| "68180-337", |
| "68180-336", |
| "71709-111", |
| "72578-036", |
| "72578-035", |
| "69948-001", |
| "59630-575", |
| "59630-574", |
| "67877-217", |
| "67877-218", |
| "50742-154", |
| "50742-155", |
| "50742-156", |
| "42806-221" |
| ], |
| "product_type": [ |
| "HUMAN PRESCRIPTION DRUG" |
| ], |
| "route": [ |
| "ORAL" |
| ], |
| "rxcui": [ |
| "861010", |
| "861012", |
| "861008", |
| "860983", |
| "861002", |
| "860981", |
| "1807915", |
| "861027", |
| "1807888", |
| "861025", |
| "860975", |
| "861018", |
| "860977", |
| "861007", |
| "861006", |
| "1807917", |
| "861004", |
| "1807894", |
| "860998", |
| "861015" |
| ], |
| "spl_id": [ |
| "52bd71dd-5a8d-47cc-a823-89e2d8ca3238", |
| "6b008764-f135-454c-9ab4-900957bb03ab", |
| "a84b54af-b795-44bf-bb70-ab9d029ec0c7", |
| "11592f79-4433-463b-b1dc-dbbda93e7def", |
| "3b40b55a-0e14-4338-9adb-468a735d0161", |
| "462c8531-be91-4189-8471-e796777087a0", |
| "65ee5632-c06c-430e-8a71-fac24d5f452e", |
| "f300c5a2-8b31-4603-b867-16c030f893dc", |
| "5f04b7a7-df34-4be5-bd0a-0e10e3203126", |
| "7a9f3d27-8313-6298-e053-2991aa0a5644", |
| "8d6c9b7d-d362-a645-e053-2a95a90a5ab3", |
| "016f4c35-8adc-4729-a2b6-d76ea7f14eb8", |
| "304bb0b5-177f-42f7-8738-12dee0b1a342", |
| "d70630a0-bf09-4f1a-8bde-b255b0235ac7", |
| "7ea9ad08-6f32-ebc1-e053-2a91aa0a7ade", |
| "23461ab7-f7ed-4ae4-9392-652efccd95d5", |
| "ae94281a-734b-40ea-8b37-a03f726f3f3c", |
| "83c58114-0164-4aaf-9162-6e4f9d98dc33", |
| "63699815-ee85-645d-e053-2a91aa0a7c4f", |
| "7274fdaf-11f8-2b2f-e053-2991aa0ad3f6", |
| "59456bca-a898-4145-a5f0-84f5f551534f", |
| "849ebb76-89bd-55a4-e053-2991aa0a4ff5", |
| "2ecef46b-12b2-4e4b-935a-d81a89eb47d1", |
| "042296fb-d95e-481f-9be3-62a1a538cfde", |
| "20a28dc3-098d-497d-b50b-2fdc03b70781", |
| "ebb30c84-a321-4747-94b5-429f87d8ba04", |
| "af6fd4c6-390c-4925-850c-699594e0d024", |
| "7ea7746b-b27b-6496-e053-2991aa0aabac", |
| "af0b2836-f848-4a2d-91c0-d712b8d0640b", |
| "61b0353e-333a-4040-af33-b853b4d9a992", |
| "91e37851-9134-2578-e053-2a95a90a989c", |
| "ed2bfd8a-3381-472b-bda8-9e7f61c9aae6", |
| "afdd64b9-5edc-471e-8a72-7d8e3e5a9b3b", |
| "2c0747fd-dbaa-4e08-bbcf-317f14eda820", |
| "a1408ee0-115e-4091-8fe8-ceef0e04f453", |
| "258dde24-0dab-4720-b4f8-d827b1f44392", |
| "61788f24-a30f-4385-a080-a28cd42e90ec", |
| "8ed86d67-8a49-4334-82c4-1dbf6a489d3b", |
| "039bd4a8-cf35-4946-8079-ca0aef70b829", |
| "833c5e2e-8b2d-3b8f-e053-2a91aa0ab453", |
| "113691ff-933f-4d66-8b9d-1edbe33d4613", |
| "647f546e-43a5-2061-e053-2991aa0a2646", |
| "f1370190-b057-4e53-8a88-4e8338d7e126", |
| "62d835b1-e8f8-439a-bfb1-d42a18c431bc", |
| "60b87f7a-35c3-ab20-e053-2991aa0a793b", |
| "6e7926ae-f593-6fc6-e053-2991aa0af877", |
| "faeef849-d270-4208-a946-31c6c2982d9b", |
| "b1d71739-26c3-43d3-9088-60bef3689e74", |
| "9edce5ce-f627-2898-8fa5-8fb076709ec3", |
| "aa961594-6e64-4c41-9d10-8b76c520bdf9", |
| "4ca45053-c36e-40b6-a92a-b773bbbe830d", |
| "9a488911-2969-41b2-8c13-dfd4da4914e1", |
| "e1c4117d-93b8-445f-8433-1821836b512a", |
| "53f6a6f5-512b-419c-b481-77d67874202b", |
| "c21bc462-be06-427d-8345-b6ffd949067d", |
| "ba0272a1-f364-42bf-a536-f3fdd4caee48", |
| "3f97cd90-c9fa-4f14-b676-984ff1793bc4", |
| "798e5afb-9451-547c-e053-2991aa0a90b2", |
| "591c34f1-d12c-4869-b610-c5ad32db0f95", |
| "356b02d0-d239-4441-bb33-c4c54166fcd7", |
| "685643f3-cbdb-4884-90a6-96b4be67f60d", |
| "38db9381-e5ac-40a5-89d5-2714e0309088", |
| "08297a45-dcc8-469a-9276-4490f078d303", |
| "308dc0ee-f470-376f-e054-00144ff88e88" |
| ], |
| "spl_set_id": [ |
| "b992b02c-3176-4074-a378-21d70104ff04", |
| "05d4df4b-dfe8-4828-b423-a3d4f2c4114a", |
| "4a0166c7-7097-4e4a-9036-6c9a60d08fc6", |
| "86d268f3-994c-4678-1e14-8021083cc490", |
| "fd18f08e-7454-48d2-a515-01d1d6c4078b", |
| "e18b60f9-721e-4db6-9f61-d3437e18faf2", |
| "2387a618-24d8-4813-aa83-9114edb35374", |
| "ee2739df-8db4-4b05-9a81-1590efbb589b", |
| "56d13a1c-b289-4528-b23c-60f5427b4552", |
| "41a8bb80-7b0b-476c-8134-5d161c3239c8", |
| "fb832474-88d9-4e29-95cd-fbc446944cc4", |
| "5c2581e3-2b30-4da5-8bed-228173ca20d2", |
| "ab2084b3-eb1b-4c52-9196-76a43f280961", |
| "add7bad0-5a47-4dd3-8544-a5999dd94558", |
| "836f3647-bfef-40d1-b475-c0d240241a67", |
| "0ff1ba75-3c86-4baf-a6b1-1bb883839866", |
| "5df6adc9-79fd-66ef-e053-2991aa0a75ce", |
| "1200ea71-8a9e-4e49-bb77-7d9fe0d84ae7", |
| "da930058-8908-4fa3-8035-303abc9624fa", |
| "5bd46f87-5dff-2d23-e053-2a91aa0a8959", |
| "2b01a50f-e517-4f6c-bee5-9925ff029e55", |
| "5043d03e-3c9d-4c96-b48d-187f02a1d27c", |
| "d09a2eda-fdd8-44ed-8e2f-ea91ddfd3c68", |
| "7e41818c-60e9-4bcf-9586-7bb8d33d5e89", |
| "dd0ee2bf-f658-42dc-976d-49af0b1f32b5", |
| "93c8deae-3103-4cbf-a5d1-fe0d37e76df8", |
| "778400a4-5bc7-4c84-adb2-deaad26f0f94", |
| "6046ecd6-db16-4683-9e84-1d2b0085f55e", |
| "158b9adb-744f-41fd-a12d-52d5156961a3", |
| "14544c2f-88c8-48a5-941e-48a543d7baaa", |
| "462198db-084d-4fb9-b5ca-86a8bacc9284", |
| "af6fd4c6-390c-4925-850c-699594e0d024", |
| "c82a10fa-1e8e-46b6-890a-737de3f34ee1", |
| "79e46fdc-6200-4312-a87c-ea9294bf22e0", |
| "6249318a-dd65-4323-b501-386305aad059", |
| "85027e6c-d35b-49eb-a234-dd71aa77aee0", |
| "52c18b5c-2322-4b22-a36e-3c573d609dd0", |
| "f86bda10-8b25-4125-8bb1-1b5917969ff0", |
| "2b6e255e-cd05-4f9a-a144-bfe0344479c3", |
| "4f70f907-08d5-4c2e-a4be-32c6124faa7b", |
| "f0a2acff-e9d8-496f-87fa-bc7f13d50712", |
| "060c694c-804c-4d32-a6d6-d6575be7ac2f", |
| "4ac6d01a-af26-44e7-ae2e-3618de0080aa", |
| "a944a167-e3ac-4084-af1c-22b48713471c", |
| "5c59e295-8529-4402-81f7-d86047fde848", |
| "2a84c550-aed8-4058-961f-351a5e4cf7a1", |
| "e21989bb-d7ba-2dd0-d2d3-a99fc799f2a6", |
| "17cc4a42-d071-4288-b72e-5c9402f73cff", |
| "40fa26bc-ee0d-4b6d-9077-f909d84453e6", |
| "9e8686e9-cc6e-41a5-8709-215a6670575a", |
| "ed71d7ea-f5af-4406-8b0d-68e17cb1e61e", |
| "b090b18b-b53c-4c92-892f-d11551cfedc3", |
| "60b87f7a-35c2-ab20-e053-2991aa0a793b", |
| "74d32a8a-c4c2-4dbb-b376-eea3f8fa64d7", |
| "60643f78-fe80-8ee0-e053-2991aa0af3c1", |
| "9c74e4f2-b323-41eb-9e43-848ab82b527b", |
| "4e4c4ba9-65c6-4273-8f6b-2423ab521dad", |
| "7ea6e623-4073-4671-e053-2a91aa0a3ca3", |
| "623b3bc6-1b07-4a04-bc7a-7fc695adf063", |
| "1c101aba-83a6-494f-b976-3f1c8494680a", |
| "7a2179ad-6799-402f-943f-9041d3bd3ff2", |
| "356b02d0-d239-4441-bb33-c4c54166fcd7", |
| "1d8b8970-c2a1-4780-be87-ab8ccfd401fa", |
| "8cd5555c-f6b2-28d8-e053-2a95a90a5f1e" |
| ], |
| "substance_name": [ |
| "METFORMIN HYDROCHLORIDE" |
| ], |
| "unii": [ |
| "786Z46389E" |
| ] |
| } |
| }, |
| { |
| "actiondrug": "5", |
| "activesubstance": { |
| "activesubstancename": "APIXABAN" |
| }, |
| "drugadditional": "3", |
| "drugadministrationroute": "065", |
| "drugcharacterization": "1", |
| "drugdosageform": "FILM-COATED TABLET", |
| "drugdosagetext": "5 MG, UNK", |
| "drugindication": "CARDIAC DISORDER", |
| "drugstartdate": "20141120", |
| "drugstartdateformat": "102", |
| "drugstructuredosagenumb": "5", |
| "drugstructuredosageunit": "003", |
| "medicinalproduct": "ELIQUIS", |
| "openfda": { |
| "application_number": [ |
| "NDA202155" |
| ], |
| "brand_name": [ |
| "ELIQUIS", |
| "ELIQUIS 30-DAY STARTER PACK" |
| ], |
| "generic_name": [ |
| "APIXABAN" |
| ], |
| "manufacturer_name": [ |
| "E.R. Squibb & Sons, L.L.C." |
| ], |
| "package_ndc": [ |
| "0003-0894-31", |
| "0003-0894-91", |
| "0003-0894-21", |
| "0003-0894-70", |
| "0003-0893-21", |
| "0003-0893-31", |
| "0003-0893-91", |
| "0003-3764-74" |
| ], |
| "product_ndc": [ |
| "0003-0894", |
| "0003-0893", |
| "0003-3764" |
| ], |
| "product_type": [ |
| "HUMAN PRESCRIPTION DRUG" |
| ], |
| "route": [ |
| "ORAL" |
| ], |
| "rxcui": [ |
| "1364435", |
| "1992427", |
| "1992428", |
| "1364445", |
| "1364447", |
| "1364441" |
| ], |
| "spl_id": [ |
| "1e0e21aa-6190-4f63-8285-63f10a68b48d" |
| ], |
| "spl_set_id": [ |
| "e9481622-7cc6-418a-acb6-c5450daae9b0" |
| ], |
| "substance_name": [ |
| "APIXABAN" |
| ], |
| "unii": [ |
| "3Z9Y7UWC1J" |
| ] |
| } |
| }, |
| { |
| "actiondrug": "5", |
| "activesubstance": { |
| "activesubstancename": "FESOTERODINE FUMARATE" |
| }, |
| "drugadditional": "3", |
| "drugadministrationroute": "048", |
| "drugauthorizationnumb": "022030", |
| "drugcharacterization": "1", |
| "drugdosageform": "MODIFIED-RELEASE TABLET", |
| "drugdosagetext": "4 MG, UNK", |
| "drugindication": "URINE ANALYSIS ABNORMAL", |
| "drugstartdate": "20141029", |
| "drugstartdateformat": "102", |
| "drugstructuredosagenumb": "4", |
| "drugstructuredosageunit": "003", |
| "medicinalproduct": "TOVIAZ", |
| "openfda": { |
| "application_number": [ |
| "NDA022030" |
| ], |
| "brand_name": [ |
| "TOVIAZ" |
| ], |
| "generic_name": [ |
| "FESOTERODINE FUMARATE" |
| ], |
| "manufacturer_name": [ |
| "U.S. Pharmaceuticals", |
| "Pfizer Laboratories Div Pfizer Inc" |
| ], |
| "package_ndc": [ |
| "63539-242-05", |
| "63539-242-03", |
| "0069-0242-30", |
| "63539-183-03", |
| "63539-183-05", |
| "0069-0244-30" |
| ], |
| "product_ndc": [ |
| "0069-0242", |
| "63539-183", |
| "63539-242", |
| "0069-0244" |
| ], |
| "product_type": [ |
| "HUMAN PRESCRIPTION DRUG" |
| ], |
| "route": [ |
| "ORAL" |
| ], |
| "rxcui": [ |
| "810071", |
| "810077", |
| "810079", |
| "810075" |
| ], |
| "spl_id": [ |
| "f4a107e0-f8aa-4811-8623-3194b4670491", |
| "35289e46-594b-4809-a44a-f663358ce393" |
| ], |
| "spl_set_id": [ |
| "5be745f0-8ae7-4c3c-9962-37d6263326f1", |
| "4f01dced-195a-4712-a614-d68012bc29df" |
| ], |
| "substance_name": [ |
| "FESOTERODINE FUMARATE" |
| ], |
| "unii": [ |
| "EOS72165S7" |
| ] |
| } |
| }, |
| { |
| "activesubstance": { |
| "activesubstancename": "HYDROCHLOROTHIAZIDE\\VALSARTAN" |
| }, |
| "drugadministrationroute": "065", |
| "drugcharacterization": "2", |
| "drugdosageform": "TABLET", |
| "medicinalproduct": "VALSARTAN HCTZ" |
| }, |
| { |
| "activesubstance": { |
| "activesubstancename": "CARVEDILOL" |
| }, |
| "drugadministrationroute": "065", |
| "drugcharacterization": "2", |
| "drugdosageform": "TABLET", |
| "drugdosagetext": "UNK, 2X/DAY", |
| "drugindication": "CARDIAC DISORDER", |
| "drugintervaldosagedefinition": "804", |
| "drugintervaldosageunitnumb": "1", |
| "drugseparatedosagenumb": "2", |
| "drugstartdate": "20141120", |
| "drugstartdateformat": "102", |
| "medicinalproduct": "CARVEDILOL.", |
| "openfda": { |
| "application_number": [ |
| "ANDA078227", |
| "ANDA078384", |
| "ANDA077316", |
| "ANDA078332", |
| "ANDA076649", |
| "ANDA077614", |
| "NDA020297", |
| "ANDA076373", |
| "ANDA077346" |
| ], |
| "brand_name": [ |
| "COREG", |
| "CARVEDILOL" |
| ], |
| "generic_name": [ |
| "CARVEDILOL" |
| ], |
| "manufacturer_name": [ |
| "GlaxoSmithKline LLC", |
| "Teva Pharmaceuticals USA, Inc.", |
| "Dr. Reddy's Laboratories Limited", |
| "Zydus Pharmaceuticals (USA) Inc.", |
| "Sandoz Inc", |
| "Mylan Pharmaceuticals Inc.", |
| "Solco Healthcare US LLC", |
| "Cadila Healthcare Limited", |
| "ACETRIS HEALTH, LLC", |
| "Sun Pharmaceutical Industries, Inc.", |
| "Bayshore Pharmaceuticals LLC", |
| "Aurobindo Pharma Limited", |
| "BluePoint Laboratories" |
| ], |
| "package_ndc": [ |
| "68382-093-01", |
| "0781-5223-29", |
| "68382-093-05", |
| "68001-151-00", |
| "68001-151-03", |
| "0093-7295-05", |
| "55111-254-79", |
| "55111-254-78", |
| "0781-5222-29", |
| "57664-244-88", |
| "52343-027-99", |
| "65862-144-99", |
| "57664-247-88", |
| "76385-113-50", |
| "76385-111-01", |
| "0093-7295-01", |
| "57664-245-18", |
| "68382-094-17", |
| "57664-245-13", |
| "52343-029-99", |
| "68001-154-00", |
| "0781-5223-01", |
| "76385-110-01", |
| "57664-244-18", |
| "55111-255-01", |
| "57664-245-88", |
| "55111-255-05", |
| "0093-7296-01", |
| "65841-617-01", |
| "0093-7296-05", |
| "65841-617-05", |
| "55111-255-10", |
| "43547-255-10", |
| "43547-255-11", |
| "55111-254-05", |
| "57664-244-13", |
| "55111-254-01", |
| "68001-153-03", |
| "68001-153-00", |
| "43547-254-11", |
| "43547-254-10", |
| "65841-616-17", |
| "0007-4141-20", |
| "0781-5221-29", |
| "55111-255-30", |
| "55111-252-30", |
| "65841-617-17", |
| "55111-254-10", |
| "43547-256-11", |
| "43547-256-10", |
| "0007-4140-20", |
| "57664-242-88", |
| "68001-152-00", |
| "68001-152-03", |
| "65841-616-01", |
| "65841-619-05", |
| "65841-616-05", |
| "65841-619-01", |
| "55111-252-01", |
| "52343-028-99", |
| "55111-252-05", |
| "57664-242-18", |
| "57664-242-13", |
| "0378-3632-01", |
| "0378-3633-05", |
| "0378-3632-05", |
| "0378-3633-01", |
| "76385-113-01", |
| "43547-257-50", |
| "65841-618-17", |
| "55111-253-30", |
| "0781-5224-29", |
| "65841-619-17", |
| "52343-026-99", |
| "55111-252-10", |
| "76385-110-50", |
| "0378-3634-05", |
| "0378-3634-01", |
| "0007-4139-20", |
| "52343-028-05", |
| "0781-5224-60", |
| "0781-5222-60", |
| "52343-028-01", |
| "55111-254-30", |
| "0781-5223-60", |
| "68382-095-17", |
| "65841-618-01", |
| "76385-112-01", |
| "65841-618-05", |
| "0007-4142-20", |
| "0781-5221-60", |
| "0378-3631-01", |
| "68001-154-03", |
| "65862-143-99", |
| "0378-3631-05", |
| "65862-145-99", |
| "68382-095-01", |
| "52343-027-05", |
| "68382-095-05", |
| "52343-027-01", |
| "43547-254-50", |
| "43547-255-50", |
| "76385-111-50", |
| "55111-253-10", |
| "0781-5221-01", |
| "65862-142-99", |
| "65862-144-01", |
| "65862-145-05", |
| "65862-144-05", |
| "65862-145-01", |
| "55111-252-79", |
| "55111-252-78", |
| "55111-253-78", |
| "55111-253-79", |
| "55111-255-78", |
| "55111-255-79", |
| "0781-5224-01", |
| "0781-5222-01", |
| "68382-092-01", |
| "68382-092-05", |
| "52343-026-05", |
| "52343-026-01", |
| "55111-253-01", |
| "0093-0051-05", |
| "65862-142-05", |
| "55111-253-05", |
| "0093-0051-01", |
| "65862-142-01", |
| "43547-256-50", |
| "57664-247-18", |
| "68382-093-17", |
| "57664-247-13", |
| "68382-092-17", |
| "52343-029-01", |
| "52343-029-05", |
| "76385-112-50", |
| "0093-0135-01", |
| "0093-0135-05", |
| "43547-257-10", |
| "43547-257-11", |
| "65862-143-05", |
| "68382-094-05", |
| "65862-143-01", |
| "68382-094-01" |
| ], |
| "product_ndc": [ |
| "55111-252", |
| "55111-253", |
| "52343-026", |
| "55111-254", |
| "55111-255", |
| "0781-5224", |
| "0781-5221", |
| "0093-0051", |
| "0781-5222", |
| "76385-113", |
| "76385-112", |
| "76385-111", |
| "76385-110", |
| "0093-7295", |
| "0093-7296", |
| "52343-028", |
| "52343-029", |
| "0378-3631", |
| "0378-3632", |
| "0378-3633", |
| "0007-4139", |
| "68001-153", |
| "68001-152", |
| "68001-151", |
| "68001-154", |
| "68382-092", |
| "68382-093", |
| "68382-094", |
| "68382-095", |
| "65862-144", |
| "65862-145", |
| "65862-142", |
| "65862-143", |
| "43547-254", |
| "43547-255", |
| "43547-256", |
| "43547-257", |
| "0781-5223", |
| "0378-3634", |
| "57664-242", |
| "57664-244", |
| "57664-245", |
| "57664-247", |
| "52343-027", |
| "0007-4140", |
| "0007-4141", |
| "0007-4142", |
| "65841-617", |
| "65841-616", |
| "0093-0135", |
| "65841-619", |
| "65841-618" |
| ], |
| "product_type": [ |
| "HUMAN PRESCRIPTION DRUG" |
| ], |
| "route": [ |
| "ORAL" |
| ], |
| "rxcui": [ |
| "212388", |
| "212389", |
| "200031", |
| "200033", |
| "200032", |
| "686924", |
| "686926", |
| "212390" |
| ], |
| "spl_id": [ |
| "536e5dfc-70ad-4775-9ae3-d221fafac575", |
| "0f94a205-76ec-4fb5-957a-9a466b996c5a", |
| "9ce0652d-66d4-4e39-88f6-9b4ef7128a16", |
| "035eb099-7795-4db9-b744-1079d6b65520", |
| "79278a9a-b296-4943-986a-7b5f65148fba", |
| "d19e26b5-179a-4edf-ba22-5c3d406d87ea", |
| "2e2f6c86-24ca-49ab-9094-b0327dce0da0", |
| "231b19c0-5ee3-33c1-e054-00144ff88e88", |
| "b1fa8af3-9789-45d2-8b77-a53935c52b49", |
| "31305b0b-ee75-85e9-081c-73d15c0a7b83", |
| "4dc27fdb-d38a-4466-b77a-ebc50170cff9", |
| "eba0919f-b3b8-45d1-aa4d-705354262922", |
| "b69e8a39-67b8-4113-ae54-833e71eeac21" |
| ], |
| "spl_set_id": [ |
| "106ff38f-526a-4993-9779-8399e8a0f765", |
| "da8b8c20-0130-4aa9-924d-4a4f28c3f767", |
| "dc6a2d33-aa04-4a04-9cde-901b744d24ca", |
| "7cc14b86-0833-4c3c-91f3-7963d7052fd5", |
| "1e453c21-a8a8-dc54-5591-74c972d41727", |
| "2ba6d893-ae2a-4535-b904-667d206f93af", |
| "e5026c19-733f-41a4-a0c9-e48a9a742460", |
| "c57982f2-c7da-488a-7ea9-b9609439ac68", |
| "e68c9b18-e7fd-45f7-a8f5-1d815e32680b", |
| "29082d8c-bbde-4620-924f-02dcf1764919", |
| "33dfcf29-19d6-46ba-b8ed-d59d2226ad07", |
| "231b724a-edbd-3da4-e054-00144ff88e88", |
| "68c275e8-992a-4520-8065-ab6d615d89cc" |
| ], |
| "substance_name": [ |
| "CARVEDILOL" |
| ], |
| "unii": [ |
| "0K47UL67F2" |
| ] |
| } |
| }, |
| { |
| "activesubstance": { |
| "activesubstancename": "ROSUVASTATIN CALCIUM" |
| }, |
| "drugadministrationroute": "065", |
| "drugcharacterization": "2", |
| "drugdosageform": "TABLET", |
| "drugdosagetext": "UNK", |
| "drugindication": "CARDIAC DISORDER", |
| "drugstartdate": "20141120", |
| "drugstartdateformat": "102", |
| "medicinalproduct": "CRESTOR", |
| "openfda": { |
| "application_number": [ |
| "NDA021366" |
| ], |
| "brand_name": [ |
| "CRESTOR" |
| ], |
| "generic_name": [ |
| "ROSUVASTATIN CALCIUM" |
| ], |
| "manufacturer_name": [ |
| "AstraZeneca Pharmaceuticals LP" |
| ], |
| "package_ndc": [ |
| "0310-0755-90", |
| "0310-0752-90", |
| "0310-0751-90", |
| "0310-0752-39", |
| "0310-0751-39", |
| "0310-0754-30" |
| ], |
| "product_ndc": [ |
| "0310-0751", |
| "0310-0752", |
| "0310-0754", |
| "0310-0755" |
| ], |
| "product_type": [ |
| "HUMAN PRESCRIPTION DRUG" |
| ], |
| "route": [ |
| "ORAL" |
| ], |
| "rxcui": [ |
| "859426", |
| "859424", |
| "859421", |
| "859751", |
| "859753", |
| "859749", |
| "859747", |
| "859419" |
| ], |
| "spl_id": [ |
| "e7bc5f68-8cbd-4841-b74d-a4862baea587" |
| ], |
| "spl_set_id": [ |
| "bb0f3b5e-4bc6-41c9-66b9-6257e2513512" |
| ], |
| "substance_name": [ |
| "ROSUVASTATIN CALCIUM" |
| ], |
| "unii": [ |
| "83MVU38M7Q" |
| ] |
| } |
| }, |
| { |
| "activesubstance": { |
| "activesubstancename": "OMEPRAZOLE" |
| }, |
| "drugadministrationroute": "065", |
| "drugcharacterization": "2", |
| "drugdosageform": "TABLET", |
| "drugdosagetext": "UNK MG, UNK", |
| "drugindication": "DIABETES MELLITUS", |
| "drugstartdate": "20140718", |
| "drugstartdateformat": "102", |
| "medicinalproduct": "OMEPRAZOLE.", |
| "openfda": { |
| "application_number": [ |
| "ANDA210593", |
| "ANDA078878", |
| "ANDA207740", |
| "ANDA207891", |
| "ANDA076515", |
| "ANDA075876", |
| "NDA209400", |
| "ANDA204661", |
| "ANDA203270", |
| "ANDA203481", |
| "NDA022032", |
| "ANDA091352", |
| "ANDA076048", |
| "ANDA206877", |
| "ANDA204012", |
| "ANDA075410", |
| "ANDA091672", |
| "ANDA075757" |
| ], |
| "brand_name": [ |
| "DG HEALTH OMEPRAZOLE", |
| "SIGNATURE CARE OMEPRAZOLE", |
| "HARMON FACE VALUES OMEPRAZOLE", |
| "SOUND BODY OMEPRAZOLE", |
| "UP AND UP OMEPRAZOLE", |
| "GENOZOL", |
| "EQUATE OMEPRAZOLE DELAYED RELEASE ACID REDUCER", |
| "SMART SENSE OMEPRAZOLE", |
| "BEING WELL OMEPRAZOLE", |
| "EXCHANGE SELECT OMEPRAZOLE", |
| "EQUATE OMEPRAZOLE", |
| "MEMBERS MARK OMEPRAZOLE", |
| "WELBY OMEPRAZOLE", |
| "KIRKLAND SIGNATURE OMEPRAZOLE", |
| "SEVEN SELECT OMEPRAZOLE", |
| "FAMILY WELLNESS OMEPRAZOLE", |
| "EQUALINE OMEPRAZOLE", |
| "OMEPRAZOLE", |
| "GOOD NEIGHBOR PHARMACY OMEPRAZOLE", |
| "DG HEALTH OMPERAZOLE", |
| "BASIC CARE OMEPRAZOLE", |
| "CARE ONE OMEPRAZOLE", |
| "TOPCARE OMEPRAZOLE", |
| "CORE VALUES OMEPRAZOLE", |
| "HUMANA PHARMACY OMEPRAZOLE", |
| "TOPCARE OMEPRAZOLE DELAYED RELEASE", |
| "LEADER OMEPRAZOLE", |
| "HEALTH MART OMEPRAZOLE", |
| "HARRIS TEETER OMEPRAZOLE", |
| "QUALITY CHOICE OMEPRAZOLE", |
| "ACID REDUCER", |
| "BERKLEY AND JENSEN OMEPRAZOLE", |
| "SUNMARK OMEPRAZOLE", |
| "CAREONE OMEPRAZOLE", |
| "GOOD SENSE OMEPRAZOLE" |
| ], |
| "generic_name": [ |
| "OMEPRAZOLE" |
| ], |
| "manufacturer_name": [ |
| "New Horizon Rx Group, LLC", |
| "Meijer Distribution Inc", |
| "Costco Wholesale Company", |
| "Aldi Inc", |
| "Glenmark Pharmaceuticals Inc., USA", |
| "7-Eleven", |
| "Shopko Stores Operating Co., LLC", |
| "BJWC", |
| "American Sales Company", |
| "Thirty Madison Inc", |
| "Camber Pharmaceuticals, Inc.", |
| "Lannett Company, Inc.", |
| "Lidl US LLC", |
| "CVS Pharmacy", |
| "Aurobindo Pharma Limited", |
| "Winco Foods, LLC.", |
| "Wal-Mart Stores Inc", |
| "Genomma Lab USA, Inc.", |
| "Family Dollar Services Inc", |
| "Zydus Pharmaceuticals (USA) Inc.", |
| "Chain Drug Marketing Association", |
| "Rising Health, LLC", |
| "H E B", |
| "Humana Pharmacy, Inc.", |
| "Sam's West Inc", |
| "Kroger Company", |
| "Walgreen Company", |
| "Breckenridge Pharmaceutical, Inc.", |
| "Amerisource Bergen", |
| "Cardinal Health", |
| "Sandoz Inc", |
| "Publix Super Markets Inc", |
| "Harmon Stores Inc.", |
| "Supervalu Inc", |
| "Safeway", |
| "Ohm Laboratories Inc.", |
| "Perrigo New York Inc", |
| "Aurohealth LLC", |
| "Gericare Pharmaceuticals", |
| "Chain Drug Consortium, LLC", |
| "Dr. Reddys Laboratories Inc", |
| "Cadila Healthcare Limited", |
| "Army & Air Force Exchange Service", |
| "Teva Pharmaceuticals USA, Inc.", |
| "Dolgencorp, LLC", |
| "Rite Aid Corporation", |
| "Mylan Pharmaceuticals Inc.", |
| "Strategic Sourcing Services LLC", |
| "L. Perrigo Company", |
| "Big Lots Stores, Inc.", |
| "OHM LABORATORIES INC.", |
| "Topco Associates LLC", |
| "Sun Pharmaceutical Industries, Inc.", |
| "Major Pharmaceuticals", |
| "GERICARE PHARMACEUTICALS", |
| "Target Corporation", |
| "Kmart Corporation", |
| "Harris Teeter, LLC", |
| "Reliable 1 Laboratories LLC", |
| "Save-A-Lot Food Stores Ltd" |
| ], |
| "package_ndc": [ |
| "0378-6150-01", |
| "21130-137-74", |
| "59651-001-99", |
| "37808-915-30", |
| "36800-601-74", |
| "41163-915-55", |
| "65841-760-16", |
| "0781-2790-92", |
| "65841-760-10", |
| "57237-161-01", |
| "59651-003-30", |
| "36800-121-01", |
| "36800-121-03", |
| "49738-915-30", |
| "46122-281-04", |
| "37012-915-55", |
| "68462-397-10", |
| "59651-002-30", |
| "51991-643-01", |
| "59779-580-01", |
| "59779-580-03", |
| "0113-0520-55", |
| "59651-001-01", |
| "68016-759-14", |
| "59651-001-03", |
| "59651-002-78", |
| "56062-915-74", |
| "41250-349-55", |
| "71713-201-01", |
| "0363-1819-74", |
| "71713-201-03", |
| "57237-161-99", |
| "62011-0373-2", |
| "0363-0915-03", |
| "57237-161-90", |
| "59779-503-01", |
| "59779-503-03", |
| "59779-503-02", |
| "70000-0356-4", |
| "68462-396-90", |
| "70000-0356-1", |
| "70000-0356-3", |
| "70000-0356-2", |
| "0781-2868-10", |
| "51991-643-90", |
| "59651-001-78", |
| "0781-2234-31", |
| "68462-396-01", |
| "63868-170-42", |
| "36800-915-74", |
| "0113-7915-30", |
| "69256-915-55", |
| "49035-915-55", |
| "0113-0915-74", |
| "69842-791-74", |
| "68196-915-55", |
| "62011-0373-1", |
| "0363-0915-74", |
| "0781-2785-31", |
| "31722-527-30", |
| "59651-003-78", |
| "43598-286-74", |
| "43598-286-70", |
| "58602-826-05", |
| "0781-2790-31", |
| "62011-0157-1", |
| "62011-0157-3", |
| "62011-0157-2", |
| "58602-729-65", |
| "58602-729-64", |
| "58602-729-61", |
| "58602-729-62", |
| "57896-960-42", |
| "49348-846-55", |
| "56062-915-30", |
| "0781-2785-01", |
| "41520-939-74", |
| "21130-137-30", |
| "30142-557-55", |
| "59651-001-30", |
| "68016-759-28", |
| "59651-003-99", |
| "62175-136-49", |
| "62175-136-46", |
| "62175-136-43", |
| "0113-7401-03", |
| "0113-7401-01", |
| "0363-0007-01", |
| "0363-0007-03", |
| "59779-503-30", |
| "0113-0915-30", |
| "31722-528-30", |
| "69842-791-55", |
| "10202-915-01", |
| "68196-915-03", |
| "36800-915-03", |
| "68196-915-01", |
| "36800-915-01", |
| "62756-377-12", |
| "51991-642-01", |
| "62756-377-11", |
| "37012-711-55", |
| "62175-118-46", |
| "68462-397-90", |
| "11673-212-74", |
| "11822-0915-3", |
| "11822-0915-2", |
| "43598-286-32", |
| "43598-286-33", |
| "55910-713-74", |
| "46122-029-74", |
| "11822-0915-5", |
| "43598-286-37", |
| "51991-642-90", |
| "0378-6150-10", |
| "30142-557-03", |
| "30142-557-02", |
| "30142-557-01", |
| "41250-915-55", |
| "65841-760-06", |
| "65841-760-05", |
| "65841-760-01", |
| "49738-915-03", |
| "49738-915-01", |
| "37808-401-01", |
| "37808-401-03", |
| "46122-029-04", |
| "68462-397-01", |
| "46122-029-03", |
| "59651-002-90", |
| "49035-392-55", |
| "59651-002-99", |
| "51991-643-10", |
| "51660-029-14", |
| "68382-412-06", |
| "68382-412-05", |
| "68382-412-01", |
| "37808-915-55", |
| "58517-020-30", |
| "59651-002-01", |
| "59651-002-03", |
| "59651-002-05", |
| "68462-395-10", |
| "55301-915-74", |
| "11673-915-30", |
| "59779-503-74", |
| "68382-500-06", |
| "68382-500-05", |
| "63981-915-55", |
| "68382-500-01", |
| "58602-729-02", |
| "68462-396-10", |
| "31722-528-01", |
| "0904-5834-94", |
| "11673-915-74", |
| "41520-915-55", |
| "68196-915-74", |
| "0093-5294-98", |
| "0113-7520-55", |
| "49348-846-61", |
| "63940-242-01", |
| "11822-0453-1", |
| "11822-0453-2", |
| "11822-1040-2", |
| "11822-1040-1", |
| "0378-5222-93", |
| "37808-354-74", |
| "45802-888-55", |
| "57237-162-01", |
| "51660-061-44", |
| "0378-5211-95", |
| "41250-915-03", |
| "41163-634-74", |
| "41250-915-01", |
| "57237-162-90", |
| "59651-003-10", |
| "41250-401-03", |
| "49738-915-55", |
| "0781-2785-10", |
| "21130-128-55", |
| "51991-644-90", |
| "51660-029-44", |
| "0113-0520-74", |
| "0781-2859-31", |
| "0363-1819-55", |
| "56062-915-55", |
| "55319-191-74", |
| "62175-136-32", |
| "62175-136-37", |
| "69256-915-02", |
| "69256-915-01", |
| "0113-0915-03", |
| "0113-0915-01", |
| "51660-061-27", |
| "68196-303-55", |
| "63940-915-55", |
| "51991-644-05", |
| "51991-644-01", |
| "0781-2234-10", |
| "69618-047-14", |
| "0093-5294-56", |
| "51991-642-33", |
| "0113-7915-55", |
| "65841-761-01", |
| "62175-118-32", |
| "65841-761-05", |
| "65841-761-06", |
| "62175-118-37", |
| "0904-5834-41", |
| "0904-5834-42", |
| "43598-286-27", |
| "43598-286-25", |
| "62756-377-96", |
| "50594-011-03", |
| "30142-557-30", |
| "36800-601-55", |
| "41163-915-74", |
| "62756-377-79", |
| "68462-395-90", |
| "62756-377-70", |
| "0378-6150-93", |
| "0378-6150-97", |
| "37012-915-74", |
| "11673-018-03", |
| "11673-018-01", |
| "68462-397-30", |
| "68382-412-10", |
| "41250-806-03", |
| "68382-412-16", |
| "41250-349-74", |
| "62175-118-43", |
| "49348-846-78", |
| "68462-395-01", |
| "59651-002-10", |
| "41520-939-55", |
| "68382-411-10", |
| "11822-0915-1", |
| "68382-411-16", |
| "69618-047-42", |
| "62175-118-49", |
| "11822-0915-6", |
| "0781-2868-31", |
| "68382-500-10", |
| "49035-915-03", |
| "68382-500-16", |
| "11822-0915-4", |
| "0781-2859-01", |
| "49035-915-74", |
| "55910-915-74", |
| "69256-915-74", |
| "0113-0915-55", |
| "51660-061-14", |
| "64024-915-74", |
| "55319-915-30", |
| "70000-0381-1", |
| "63940-915-01", |
| "70000-0381-2", |
| "51991-644-33", |
| "65841-759-10", |
| "0363-0915-55", |
| "65841-759-16", |
| "55910-915-01", |
| "41250-915-02", |
| "55910-915-03", |
| "55910-915-02", |
| "0781-2859-92", |
| "41163-915-30", |
| "59651-003-90", |
| "0113-1723-01", |
| "0113-1723-03", |
| "11673-212-55", |
| "37012-711-74", |
| "37012-915-30", |
| "43598-286-52", |
| "0904-5834-71", |
| "0093-5294-10", |
| "36800-915-55", |
| "58602-729-03", |
| "21130-137-55", |
| "58602-729-01", |
| "58602-729-05", |
| "37808-915-01", |
| "0378-5211-93", |
| "41250-915-30", |
| "46994-915-74", |
| "59651-003-05", |
| "57237-161-30", |
| "59651-003-03", |
| "59651-003-01", |
| "41250-401-01", |
| "46122-281-74", |
| "30142-557-74", |
| "59651-001-10", |
| "57896-760-42", |
| "68462-395-30", |
| "0781-2790-10", |
| "57237-162-30", |
| "55910-915-30", |
| "11673-915-55", |
| "50066-915-03", |
| "50066-915-01", |
| "55319-915-74", |
| "0781-2868-01", |
| "57237-160-01", |
| "0781-2234-01", |
| "67091-316-14", |
| "45802-888-30", |
| "49035-119-01", |
| "49035-119-03", |
| "63940-242-55", |
| "70000-0521-1", |
| "71141-009-74", |
| "65841-761-10", |
| "65841-761-16", |
| "58602-826-61", |
| "58602-826-62", |
| "46122-029-99", |
| "0781-2868-92", |
| "49035-915-30", |
| "0363-0915-01", |
| "69256-915-30", |
| "41520-915-74", |
| "41163-915-01", |
| "41250-915-74", |
| "0113-7520-74", |
| "37012-915-03", |
| "41520-915-03", |
| "51991-643-33", |
| "46122-616-04", |
| "68016-759-42", |
| "37808-915-74", |
| "49348-846-46", |
| "37012-401-03", |
| "37012-401-01", |
| "55301-915-55", |
| "55910-713-30", |
| "68382-411-01", |
| "49738-915-74", |
| "68382-411-06", |
| "68382-411-05", |
| "0781-2859-10", |
| "68462-396-30", |
| "0113-7915-01", |
| "49035-915-01", |
| "62175-114-37", |
| "0363-0915-30", |
| "62175-114-32", |
| "11673-915-03", |
| "11673-915-02", |
| "11673-915-01", |
| "0378-5222-05", |
| "50594-011-74", |
| "65841-759-01", |
| "57237-160-30", |
| "65841-759-06", |
| "65841-759-05", |
| "62175-114-46", |
| "62175-114-49", |
| "59779-503-55", |
| "68391-915-55", |
| "41520-915-30", |
| "57896-960-14", |
| "31722-527-01", |
| "51991-642-10", |
| "36800-915-30", |
| "62756-377-21", |
| "37808-354-55", |
| "70925-915-01", |
| "0781-2790-01" |
| ], |
| "product_ndc": [ |
| "0113-1723", |
| "71713-201", |
| "43598-286", |
| "50594-011", |
| "0113-7401", |
| "0113-7520", |
| "41250-806", |
| "49738-915", |
| "67091-316", |
| "68196-303", |
| "63940-915", |
| "46122-616", |
| "70925-915", |
| "10202-915", |
| "46122-029", |
| "63940-242", |
| "0093-5294", |
| "58602-826", |
| "11822-1040", |
| "49035-915", |
| "21130-137", |
| "59651-001", |
| "59651-002", |
| "59651-003", |
| "37012-401", |
| "0904-5834", |
| "62011-0373", |
| "41520-915", |
| "51991-643", |
| "51991-642", |
| "51991-644", |
| "11822-0453", |
| "68016-759", |
| "55319-191", |
| "70000-0381", |
| "45802-888", |
| "0363-0915", |
| "58602-729", |
| "62175-118", |
| "21130-128", |
| "57896-760", |
| "55301-915", |
| "46122-281", |
| "36800-121", |
| "0781-2868", |
| "51660-061", |
| "57896-960", |
| "49035-119", |
| "68382-412", |
| "68382-411", |
| "0378-5222", |
| "58517-020", |
| "0113-0915", |
| "68391-915", |
| "41250-401", |
| "41163-634", |
| "37808-915", |
| "37012-915", |
| "11673-018", |
| "69256-915", |
| "37808-354", |
| "0781-2859", |
| "41250-915", |
| "63868-170", |
| "69618-047", |
| "11673-915", |
| "46994-915", |
| "37012-711", |
| "62175-136", |
| "71141-009", |
| "50066-915", |
| "30142-557", |
| "70000-0521", |
| "31722-527", |
| "62175-114", |
| "65841-761", |
| "65841-760", |
| "0781-2234", |
| "69842-791", |
| "49348-846", |
| "0113-7915", |
| "0781-2785", |
| "70000-0356", |
| "57237-161", |
| "57237-160", |
| "63981-915", |
| "57237-162", |
| "62756-377", |
| "37808-401", |
| "55319-915", |
| "68196-915", |
| "41250-349", |
| "62011-0157", |
| "0378-5211", |
| "65841-759", |
| "0781-2790", |
| "11822-0915", |
| "51660-029", |
| "49035-392", |
| "41163-915", |
| "0113-0520", |
| "56062-915", |
| "36800-915", |
| "0378-6150", |
| "59779-503", |
| "11673-212", |
| "55910-713", |
| "31722-528", |
| "0363-0007", |
| "68382-500", |
| "64024-915", |
| "59779-580", |
| "55910-915", |
| "36800-601", |
| "0363-1819", |
| "68462-395", |
| "68462-396", |
| "68462-397", |
| "41520-939" |
| ], |
| "product_type": [ |
| "HUMAN OTC DRUG", |
| "HUMAN PRESCRIPTION DRUG" |
| ], |
| "route": [ |
| "ORAL" |
| ], |
| "rxcui": [ |
| "199119", |
| "200329", |
| "2003656", |
| "198051", |
| "402014" |
| ], |
| "spl_id": [ |
| "bfe9e274-24ba-4952-9f23-baffc40055b9", |
| "99202ce8-79bd-42b3-94f2-7ae019f6b6ba", |
| "e4f4a217-25a7-4f92-bf56-c2b8134e03d0", |
| "545672b3-7927-4da2-9ad6-19f5aeeebb3d", |
| "a958dac3-8156-4222-a379-82fb3c229a74", |
| "eacdb1fd-5384-4b54-a9dd-0985c0ac8619", |
| "7b6700e4-3aeb-4446-a65c-88360feafbab", |
| "b3d11bd8-0ac3-363e-2e46-03fc1366a56a", |
| "e4b6b02f-53b9-4905-9e79-3a903230886e", |
| "be8158f5-6083-41f5-8c30-19869f2be5c0", |
| "94027fba-a071-44ab-89fa-14f2f4a171b9", |
| "046f049e-fcf4-4b5d-85a5-ede9402b8696", |
| "feaa1f7e-eb69-47c4-9db8-56a2f0850579", |
| "bcf66232-1a1b-4a34-a2e2-8b808083ae3a", |
| "3dda06d1-dee4-45b6-9032-33bb4d22ab94", |
| "1d5eb0db-901a-42a8-8f37-45b9a78aa23f", |
| "3f8dd174-2e24-40b6-ae02-41061abe609e", |
| "b43b4c61-9088-424b-9249-ba2e32fd227c", |
| "ba98ab42-6904-4258-904b-87aaa3f3e918", |
| "facd5359-fc48-467d-ac98-b52e76527e70", |
| "503a2e18-602b-439b-95fb-31d39d496f7b", |
| "d7fba3af-fb69-49a7-b1c8-d4f5a928e2e5", |
| "2726e5fd-0cd1-45b8-900b-1c296e9a794e", |
| "0c6e00a2-31e8-4e84-928d-80e69a5fc634", |
| "daa7fe33-a5c5-48be-bb4d-38cea9e34f33", |
| "507046fe-1b9f-4d36-9f5d-43ad9b32f020", |
| "74764042-44bb-4b8b-b062-16675650a6aa", |
| "615e8cef-2f1c-47ac-afe0-2e1a1da3d99b", |
| "4f415306-80d3-44dd-9e9b-cce3afaa791a", |
| "cbd0422a-753b-4084-9027-5ae730b802f3", |
| "4e8479ab-ab81-4af3-89b9-1a6f5ad50077", |
| "6b3dd6f7-7b86-433c-a125-816e7b68115d", |
| "9e3f549b-b112-4828-b17f-6418bcfd31ee", |
| "5b482e2b-e92f-40ff-a91f-2aaa6e49ada9", |
| "d3a01126-ce5b-4df8-a470-3a564e6330e1", |
| "196181dd-ca33-481c-87c0-d662346b7660", |
| "46f06125-ef9c-4dc5-906f-3f7b77e8dd3c", |
| "6be23b74-79fb-4d5e-b855-af5aa9c030f9", |
| "a6290b17-c395-4907-8739-b576dcb5271e", |
| "4a84fb71-2ab6-4dd1-b953-7478541c24c1", |
| "1fe73188-8c37-4d61-ba16-64c3f4d9bf3d", |
| "8c9d9c38-9da6-4f99-9f08-26ec4693fa55", |
| "ec5dc041-fca1-470f-a6f1-09677ce7ace1", |
| "0a5d67e8-bb90-4301-b0d7-c5f85613506f", |
| "7dcb6acb-6136-43d9-e053-2a91aa0ad419", |
| "771aa236-533f-4021-987c-4d4e4d4394b6", |
| "4d85f9cd-8b4e-4ce8-b00c-68df93005a8b", |
| "cd664883-a4cc-4ff4-b388-3e525b0e64b9", |
| "de7eb606-2ef1-4b26-8b9b-13c8be1b45e7", |
| "e5732375-cfb0-431c-b7b8-cacd604efb68", |
| "2c82152e-de40-4ee6-b46d-a4db851f7bc3", |
| "a4b86766-3372-492a-9065-2c2dcb9cfcc5", |
| "d3431cdd-a2ac-4144-a5b7-bb7e9e49408a", |
| "f8450f59-9629-41d2-92eb-9ac30593ea31", |
| "84ea36b7-7574-4cc4-a236-c98005e82218", |
| "d8c791bf-edd3-4500-b2cc-94fac3ee0b58", |
| "51f35387-e35e-47d7-8024-6ae6b398aac4", |
| "a4d1e73d-f839-477d-aed3-1b6acaa91d37", |
| "e88dfbd6-6706-470e-9113-545800662b1a", |
| "2644da5a-3173-45d9-a7eb-cf861ccc34a5", |
| "516170d4-4913-4577-a2d2-f5c52d1e79c6", |
| "45c17060-5647-48e6-9fbb-65da648c7006", |
| "2a3aef6c-b260-4737-b500-c79b5aaa1f35", |
| "54fd9f84-9c67-4846-b79d-eb9e6720a315", |
| "04ef8ac2-790d-40bc-b64b-81e895b813bc", |
| "375091c7-86fe-00dd-8dd8-7da0c6c42f07", |
| "62ee1647-4687-469c-98f8-67895571c828", |
| "b673c1ae-d733-4427-9cd2-857aab2d36bc", |
| "0ae27ef3-b66f-469b-a0de-6cdd0a3a3a3f", |
| "368d011a-f806-4872-86cd-97c5c1690f5b", |
| "5cec6c4c-02ba-476b-b5c7-a5de9ee50836", |
| "9de8ecfb-edd8-4b4d-8d5a-dc591386b691", |
| "0b946ec5-3fba-4cc3-8aa9-05417b672b94", |
| "d5d74614-a56e-43cf-89cf-671e272fa8fe", |
| "fd7594c7-f0f5-4cbc-8439-0ed79337fb1b", |
| "0ff0f5a5-50f2-4f35-a765-2180dabff9cb", |
| "54a04f22-d835-47c6-b249-252b68f9074a", |
| "0fe20799-e342-4743-9b3c-ac78418de7cf", |
| "7cc2e12a-ea77-28c9-e053-2991aa0ad3a7", |
| "7dcc6136-3d48-6a68-e053-2a91aa0af765", |
| "fa95ce8c-782a-4aea-9fc6-44f71e96b52d", |
| "a54f64f3-0e8d-45df-98b7-2c24a6e855dd", |
| "fd008a4b-e492-49af-8c33-61c9ae45ab08", |
| "deedf3aa-2740-4762-b2c9-482226945660", |
| "5b3c3d40-32c3-47d8-85ad-e3bb5abd2a67", |
| "56e6ee5e-3598-4c3d-838f-4cf07272e739", |
| "7de824f3-0e84-45c9-875d-808f3c687719", |
| "005f1154-da80-4092-a0c0-afd646d3b3ab", |
| "c3368489-ccc8-4df6-8dad-bfc23c13533c", |
| "e8de4708-5e58-48d0-8ee8-289097cc6f74", |
| "e2370e53-57c3-4a9a-890f-04f8b8922e38", |
| "f7e2081e-f97e-449a-a5e2-768ffcb931b4", |
| "0da1ba3c-6638-4d20-840f-8730e965856f", |
| "261212fe-7290-44f0-859d-c22cdee82bf5", |
| "2b4bc0c7-58d1-4ed4-a775-c08e536a408e", |
| "1abb9b6b-1b11-4fc9-beeb-3985edc5cf61", |
| "ef9e606e-87b6-4468-92a4-52c0a3c870f5", |
| "33f91b23-c0cc-4790-a3e0-d8f256652196", |
| "1a6d4adc-376d-4439-a292-24799b886cca", |
| "ddd867cb-71df-4b1b-84a7-415e67076d5f" |
| ], |
| "spl_set_id": [ |
| "dec6a371-3e80-4b88-9545-8d8171caab6d", |
| "5ee3cb79-5c0c-456f-b5d5-d5a008bbd118", |
| "9a0f2d8a-eaad-403b-90c3-0fd275abe4dc", |
| "216cc69b-1401-4bcb-9bbb-2cc622209676", |
| "7dcb6acb-6135-43d9-e053-2a91aa0ad419", |
| "78743f3b-257e-49df-98cd-6cc0e1b4e370", |
| "d664c45d-564a-4692-ae8f-8dd980ffcd87", |
| "f82a8d79-3150-4ad5-af8c-23ffef523019", |
| "318ceaa8-cb49-40d0-a568-5c44088af3f6", |
| "326bf21c-fad4-473e-9e7f-797319d4353a", |
| "d54e1097-bd56-4371-8e59-8ceab1a5e824", |
| "5ceaec04-3ca3-4c7c-9184-51a42686a595", |
| "68a24c01-f3b7-4302-a71a-12dfe2d03d98", |
| "facd5359-fc48-467d-ac98-b52e76527e70", |
| "92201fb1-4570-42db-8da3-3b8c0e291d32", |
| "5a09ce48-7139-4fc7-9b6e-439459c8e866", |
| "0c6e00a2-31e8-4e84-928d-80e69a5fc634", |
| "344b5548-e5c0-45bf-bc3f-73af50bd5913", |
| "48a44d0c-3502-430b-8b75-188a49d14da2", |
| "8a60af7e-13a9-4565-8278-835ff8770a8c", |
| "925399c7-dcbc-4546-9111-2a98a11ba538", |
| "4bb2866d-15b5-42a2-8cda-c7d41259a4af", |
| "5bfea5f5-898e-4ddb-e053-2a91aa0af2f4", |
| "4e849a58-ad34-4d6e-a065-d1e5a1ac8218", |
| "a1b1c61b-d4fe-433d-ad31-0b11758976fa", |
| "58256e7e-6f1d-40fb-9b58-968c682fb945", |
| "51c3ef34-b7c1-419e-a784-ae82540c7a22", |
| "4c6b6230-ad1f-478c-b69e-aef27ecf61e9", |
| "3cba4005-ebce-41ba-b856-d54eb719708b", |
| "2e7d807b-430a-47c1-b246-015567b50ed1", |
| "b7972f17-4a63-4d78-a181-01ea6d7d3963", |
| "fb3b1c3b-d486-4fa6-9ebf-ee1812ed2512", |
| "78507fde-256c-42e9-af3f-bb53024e5b10", |
| "b7289621-9dc7-fd2b-bbb1-f69dea450f7d", |
| "8dbe5015-58bf-4283-8de6-bb0604998bb5", |
| "9601ea95-070e-4d10-b9f2-6cdc5cd1f639", |
| "2aaaf0fd-7f2a-4533-b3ad-f35c6c19cca2", |
| "6919399e-f112-4274-b4de-df0b4c391e63", |
| "c6c22be1-659d-4e71-b292-701e27da201b", |
| "6b250394-f3fb-482c-8b33-e6ec4ebc6899", |
| "2f2b26fe-dbc2-4185-8a27-6b166dd49ba2", |
| "fe0bb8c5-9965-46f6-b675-773f2730d9f0", |
| "4b3b389d-a151-d851-cb05-64eb49979e5e", |
| "e4a68b0a-a550-4416-8911-1defe014ad89", |
| "0c86131a-473d-4aa2-b853-ce1b1c04d59e", |
| "814ceb75-1e79-4beb-b087-ec4ddb23b780", |
| "230e1aca-6644-4e6d-a6e1-9ba04cdcc8a8", |
| "922e7439-92ba-4248-aca3-a7b08cae2f9f", |
| "22b4492d-7afe-410f-97bf-57e4a57b1c27", |
| "8ed57521-e69a-4563-9ce2-4f6d667f065d", |
| "436c5ea1-c5ee-481f-803d-439f65873b1c", |
| "934601b6-fbba-43c4-a8ef-7a7dfe9f9a51", |
| "0cb2949a-baf2-4276-a27b-8f3cc4b9a658", |
| "b0ee8425-754a-4c31-ad51-c8cb691f0a88", |
| "a6db366e-03bc-4b14-95cc-817a8be11d15", |
| "5e72b06d-5724-4c1b-8eb7-721cfd3f317b", |
| "516170d4-4913-4577-a2d2-f5c52d1e79c6", |
| "b2dd3c63-3875-4a9b-9b78-b5b3eba2aa1a", |
| "44260509-a91c-4906-bcc7-4eb5d3465ded", |
| "54fd9f84-9c67-4846-b79d-eb9e6720a315", |
| "c76c4235-92d4-4384-8ddc-ceed0b928c48", |
| "4d98665d-38db-4c08-8406-cc0e45f7ab7c", |
| "e4562da8-9d94-4417-9f80-c1ffd4247259", |
| "dcd93796-8904-415d-a379-c4ea590cf544", |
| "35a95bec-51b9-465b-aa93-ad26afb87be8", |
| "30a893d2-198a-4184-81b4-02399324ff29", |
| "01bde9ca-0114-426d-8188-c55aefaa0961", |
| "5b88717a-e90c-4e74-ae2a-29270e14a3cc", |
| "3219744c-99c9-4bab-9931-68a5d7e3104d", |
| "491e3710-9a15-4b07-ae22-923bd1152ecc", |
| "c9ac950e-0ad7-4c90-a457-1b69c38ee21c", |
| "99f76e43-fa34-42a6-8bbb-e55467b852aa", |
| "8f2eb5e8-80f2-4c40-a8ad-e1d9c10d0c56", |
| "3eb70031-6439-44cf-8056-3e2e1e4a7fa9", |
| "0edfa800-fb14-44dd-9c31-de930b864ef9", |
| "9c22ceb2-2c34-43c3-9a35-2589c9078741", |
| "015b1c8f-9d5b-4afc-a55c-1a731b5fc72a", |
| "db333c49-2c3e-4ade-a202-7d4499205fc4", |
| "064f048c-eddd-4370-9ee4-706f9f00c8d2", |
| "ab74d236-7745-4b27-8c7b-f49d5009d8af", |
| "f74752a8-a686-4c7d-91ad-8c87c4596a7a", |
| "0f195e96-4acb-48fa-b1f7-d6504601fe27", |
| "8a4e00b2-a7c5-4829-a83a-bbd1eac2fe2e", |
| "ee853401-b641-4dab-b708-29424c2d0b79", |
| "fde12bf8-3e3b-4813-a8c4-4385e7de8204", |
| "f9aab207-d309-49b5-b941-c2912b186583", |
| "66a96497-1b65-4943-b6b9-01ae8bd975ff", |
| "0022ca14-9177-4fe9-90f3-1d67592d8d6c", |
| "19b5b960-cc4d-42d0-8c8a-04a355a4db92", |
| "e1da8e04-147c-4b9e-9be4-c799e2906d96", |
| "6361a492-782f-4608-a20f-1bd86afbd864", |
| "99fdfeed-6828-4bf6-bb81-cd29a4ec610b", |
| "235b5cab-70e0-4e2f-9ce8-47b1381782c4", |
| "616d8c9b-5d37-9fb3-e053-2a91aa0ac9a7", |
| "b6c87a6a-253a-4455-9b7d-62f506da592e", |
| "db2d75ea-5924-4b7f-a92d-d4847a010d52", |
| "cb47354c-297b-4dc2-85af-242acc967b56", |
| "11dfbf6c-59bf-4a30-b627-f49ccd31c0d0", |
| "3817cb8f-78f0-49cd-b55c-27f44a66d446", |
| "504b8282-d93f-454f-9f93-84cb8a9105d7" |
| ], |
| "substance_name": [ |
| "OMEPRAZOLE MAGNESIUM", |
| "OMEPRAZOLE" |
| ], |
| "unii": [ |
| "426QFE7XLK", |
| "KG60484QX9" |
| ] |
| } |
| }, |
| { |
| "activesubstance": { |
| "activesubstancename": "FUROSEMIDE" |
| }, |
| "drugadministrationroute": "065", |
| "drugcharacterization": "2", |
| "drugdosageform": "TABLET", |
| "drugdosagetext": "UNK", |
| "drugindication": "CARDIAC DISORDER", |
| "drugstartdate": "20141112", |
| "drugstartdateformat": "102", |
| "medicinalproduct": "FUROSEMIDE.", |
| "openfda": { |
| "application_number": [ |
| "ANDA070434", |
| "ANDA070082", |
| "ANDA202747", |
| "NDA018823", |
| "ANDA212174", |
| "NDA018667", |
| "NDA016273", |
| "ANDA070655", |
| "NDA018902", |
| "NDA018487", |
| "ANDA207552", |
| "ANDA075241", |
| "ANDA070433", |
| "NDA018569", |
| "ANDA070086", |
| "ANDA076796", |
| "ANDA077293", |
| "ANDA203428" |
| ], |
| "brand_name": [ |
| "LASIX", |
| "FUROSEMIDE", |
| "TOXYCOLOGY MEDICATED COLLECTION SYSTEM", |
| "DIASCREEN 12-PANEL MEDICATED COLLECTION SYSTEM" |
| ], |
| "generic_name": [ |
| "FUROSEMIDE" |
| ], |
| "manufacturer_name": [ |
| "Amneal Pharmaceuticals LLC", |
| "AuroMedics Pharma LLC", |
| "Solco Healthcare LLC", |
| "Validus Pharmaceuticals LLC", |
| "West-Ward Pharmaceuticals Corp.", |
| "Fresenius Kabi USA, LLC", |
| "Hospira, Inc.", |
| "Heritage Pharmaceuticals Inc.", |
| "IT3 Medical LLC", |
| "Sandoz Inc", |
| "Morton Grove Pharmaceuticals, Inc.", |
| "Mylan Pharmaceuticals Inc.", |
| "Baxter Healthcare Corporation", |
| "Leading Pharma, LLC" |
| ], |
| "package_ndc": [ |
| "0054-4297-31", |
| "30698-067-10", |
| "0378-0232-05", |
| "0378-0232-01", |
| "43547-401-11", |
| "43547-401-10", |
| "0054-3298-63", |
| "0409-1639-10", |
| "0781-1818-05", |
| "36000-064-05", |
| "0781-1818-01", |
| "30698-060-01", |
| "0378-0216-10", |
| "30698-067-01", |
| "0054-8297-25", |
| "0054-3294-50", |
| "43547-403-11", |
| "43547-403-10", |
| "68345-883-50", |
| "0409-1639-21", |
| "0409-9631-14", |
| "70529-549-01", |
| "0781-1818-10", |
| "0409-9631-04", |
| "30698-060-10", |
| "69315-117-10", |
| "0054-3294-46", |
| "55150-322-25", |
| "43547-402-51", |
| "55150-323-25", |
| "23155-473-33", |
| "23155-473-32", |
| "23155-473-31", |
| "0054-4297-25", |
| "63323-280-16", |
| "36000-283-25", |
| "70529-062-01", |
| "69315-117-01", |
| "70529-550-12", |
| "0378-0216-01", |
| "69315-116-01", |
| "36000-063-05", |
| "63323-280-36", |
| "0378-0208-01", |
| "55150-324-01", |
| "43547-401-51", |
| "30698-066-50", |
| "0409-6102-02", |
| "0409-6102-04", |
| "69315-116-10", |
| "70121-1164-1", |
| "70121-1164-5", |
| "0378-0208-10", |
| "36000-284-25", |
| "63323-280-26", |
| "55150-323-01", |
| "0781-1966-05", |
| "0781-1966-01", |
| "69315-118-01", |
| "69315-118-05", |
| "0781-1966-60", |
| "36000-065-05", |
| "0409-6102-19", |
| "0409-6102-18", |
| "0409-6102-10", |
| "43547-403-50", |
| "63323-280-10", |
| "30698-060-50", |
| "55150-324-25", |
| "60432-613-04", |
| "55150-322-01", |
| "0781-1966-10", |
| "36000-282-25", |
| "60432-613-60", |
| "0054-4299-31", |
| "0409-6102-26", |
| "0409-6102-27", |
| "0409-6102-25", |
| "43547-402-10", |
| "43547-402-11", |
| "0409-6102-20", |
| "70121-1163-5", |
| "0054-8301-25", |
| "70121-1163-1", |
| "0781-1446-05", |
| "0054-4301-29", |
| "0781-1446-01", |
| "0054-4301-25", |
| "63323-280-04", |
| "63323-280-01", |
| "63323-280-03", |
| "63323-280-02", |
| "0054-4299-25", |
| "30698-066-05", |
| "23155-473-44", |
| "23155-473-45", |
| "23155-473-42", |
| "23155-473-43", |
| "70529-061-08", |
| "23155-473-41", |
| "0054-8299-25", |
| "63323-280-05", |
| "70121-1076-5", |
| "70121-1076-1" |
| ], |
| "product_ndc": [ |
| "36000-065", |
| "36000-064", |
| "0054-4297", |
| "0409-1639", |
| "36000-063", |
| "0378-0216", |
| "70121-1076", |
| "0054-4299", |
| "0781-1818", |
| "0054-8299", |
| "63323-280", |
| "69315-116", |
| "69315-117", |
| "69315-118", |
| "70529-061", |
| "0054-8297", |
| "30698-066", |
| "30698-067", |
| "23155-473", |
| "0409-9631", |
| "70529-062", |
| "70529-549", |
| "60432-613", |
| "70121-1163", |
| "70121-1164", |
| "0054-8301", |
| "0781-1966", |
| "36000-284", |
| "0054-4301", |
| "36000-283", |
| "36000-282", |
| "0409-6102", |
| "0781-1446", |
| "0054-3298", |
| "55150-323", |
| "0054-3294", |
| "0378-0232", |
| "55150-324", |
| "43547-401", |
| "0378-0208", |
| "43547-403", |
| "43547-402", |
| "70529-550", |
| "30698-060", |
| "55150-322" |
| ], |
| "product_type": [ |
| "HUMAN PRESCRIPTION DRUG" |
| ], |
| "route": [ |
| "INTRAMUSCULAR", |
| "ORAL", |
| "INTRAVENOUS" |
| ], |
| "rxcui": [ |
| "1719286", |
| "1719290", |
| "1719291", |
| "200809", |
| "727574", |
| "727575", |
| "205732", |
| "313988", |
| "1038558", |
| "197732", |
| "197731", |
| "197730", |
| "200801", |
| "310429" |
| ], |
| "spl_id": [ |
| "526c46f4-1491-478c-a944-4d7f08570d46", |
| "a2f6ad89-adb0-4846-aa75-c4a07ec3bcae", |
| "32026e66-2942-4d0a-85a7-73d676889d4b", |
| "e69a1faa-ce50-4abf-be3a-74fdf56b58d9", |
| "eea5ef02-73d2-4446-8d5c-7720d847be80", |
| "4a8cf504-e890-4469-b4bd-a97379582dc1", |
| "94a2910a-1fdf-d5cd-e053-2a95a90afffb", |
| "d04db961-102f-463a-b75c-c3513f5f1702", |
| "1206cc9e-b951-4bc8-808a-b8727804b9f4", |
| "bb0cd799-020b-40bf-b009-5c12f8586404", |
| "64f5e6c2-98e8-4972-8082-c0b8fa2383b0", |
| "aad305a6-1e93-4e22-b05b-503f9aaa1193", |
| "a2e29d54-f9fe-46c4-b2fb-669d9db39349", |
| "dc025b15-b490-4049-a63c-28a56fcbcfe7", |
| "c99a35c6-59d3-4fc5-b1d8-c9e3b22d1284", |
| "421aa6d5-623b-4dc2-abd5-bb9e7765bf37", |
| "09ae874a-2d61-4da4-88dc-5079fbb2daf4", |
| "4487d2d4-6447-4d60-a0d5-d4bb7ffafd92", |
| "d081103b-6591-4bdb-a62d-298e3f5fe16b" |
| ], |
| "spl_set_id": [ |
| "6a0fb397-63ae-4fce-bddf-16a91b1b7a2f", |
| "39fd32f2-6bb7-4a65-d298-e48d26bc80c7", |
| "30cd95a8-ee0d-413d-b26a-6f042e8e1892", |
| "c71371a7-75c5-45b8-b762-8d782d4c71bc", |
| "1b9117d5-0dd9-4577-a1fd-bb0aaf7e68ec", |
| "aaced7a8-c3d7-4d66-8c07-aa407b8b3f35", |
| "3747bbcd-783d-4baa-bb5b-b6827bf390e3", |
| "d5b9f12e-d1e9-42de-90f2-c9ba33a86457", |
| "2c9b4d8f-0770-482d-a9e6-9c616a440b1a", |
| "a78407a8-3d3e-4eb5-9e3f-b32a1b8015e4", |
| "5c50b5a3-9b39-4cad-8be5-c2a8dd3f7df5", |
| "b5c6fcf4-fd37-4fee-8dac-1a3273d95ffe", |
| "34d7b9da-327d-45a7-a87a-f8b6d5e80a7b", |
| "59b21dbe-30a0-405b-b39e-c19cea7ad9d6", |
| "9e493331-dddd-496e-abf8-61747fb67aba", |
| "87960726-e901-4596-bd33-ead02cb93a20", |
| "421aa6d5-623b-4dc2-abd5-bb9e7765bf37", |
| "c794c95a-654e-48fe-9596-201fc122ff75", |
| "99e3dc3c-5416-4bf4-a410-a036f7008294" |
| ], |
| "substance_name": [ |
| "FUROSEMIDE" |
| ], |
| "unii": [ |
| "7LXU5N7ZO5" |
| ] |
| } |
| } |
| ], |
| "patientonsetage": "71", |
| "patientonsetageunit": "801", |
| "patientsex": "1", |
| "patientweight": "124.26", |
| "reaction": [ |
| { |
| "reactionmeddrapt": "Adverse event", |
| "reactionmeddraversionpt": "19.1", |
| "reactionoutcome": "6" |
| }, |
| { |
| "reactionmeddrapt": "Product use issue", |
| "reactionmeddraversionpt": "19.1", |
| "reactionoutcome": "6" |
| } |
| ] |
| }, |
| "primarysource": { |
| "qualification": "1", |
| "reportercountry": "US" |
| }, |
| "primarysourcecountry": "US", |
| "receiptdate": "20160830", |
| "receiptdateformat": "102", |
| "receivedate": "20160830", |
| "receivedateformat": "102", |
| "receiver": { |
| "receiverorganization": "FDA", |
| "receivertype": "6" |
| }, |
| "reportduplicate": { |
| "duplicatenumb": "US-PFIZER INC-2015467764", |
| "duplicatesource": "PFIZER" |
| }, |
| "reporttype": "1", |
| "safetyreportid": "12698542", |
| "safetyreportversion": "1", |
| "sender": { |
| "senderorganization": "FDA-Public Use", |
| "sendertype": "2" |
| }, |
| "serious": "2", |
| "transmissiondate": "20161109", |
| "transmissiondateformat": "102" |
| } |
+-------------------------------------------------------------------+
This query is not standard SQL and only works in Snowflake.
From carefully examining this sample, we can determine the parts we are interested in, such as the report id, the drug, pharmaceutical class, inidication, characterization and the reactions.
Tabulating the non-tabular data in Snowflake
By taking note of the structure of the sample, we can adjust our query by adding flatten statements for the drug, reaction arrays and selecting the projections we are interested in from those flattens.
select
results.value:safetyreportid as report_id,
reactions.value:reactionmeddrapt as reaction,
drugs.value:medicinalproduct as drug,
drugs.value:drugindication as drug_indication,
drugs.value:drugcharacterization as characterization
from event_raw,
lateral flatten (input => data, path => 'results') results,
lateral flatten (input => results.value, path => 'patient:reaction') reactions,
lateral flatten (results.value, path => 'patient:drug') drugs
limit 10;
REPORT_ID | REACTION | DRUG | DRUG_INDICATION | CHARACTERIZATION |
---|---|---|---|---|
“11808739” | “Bronchitis” | “OXYCODONE” | “RHEUMATOID ARTHRITIS” | “2” |
“11808739” | “Bronchitis” | “ATENOLOL.” | NULL | “2” |
“11808739” | “Bronchitis” | “MORPHINE” | “RHEUMATOID ARTHRITIS” | “2” |
“11808739” | “Bronchitis” | “ALBUTEROL.” | “RESTRICTIVE PULMONARY DISEASE” | “2” |
“11808739” | “Bronchitis” | “LEVOTHYROXINE.” | “HYPOTHYROIDISM” | “2” |
“11808739” | “Bronchitis” | “OXYCODONE” | “OSTEOARTHRITIS” | “2” |
“11808739” | “Bronchitis” | “RECLAST” | NULL | “2” |
“11808739” | “Bronchitis” | “ACTEMRA” | “RHEUMATOID ARTHRITIS” | “1” |
“11808739” | “Bronchitis” | “MORPHINE” | “PAIN” | “2” |
“11808739” | “Bronchitis” | “OXYCODONE” | “PAIN” | “2” |
Dealing with the varying structure of non-tabular records
The structure of non-tabular data can change from record to record. This is the case with this FDA data. One example of this is the pharmaceutical classes of drugs. Some records contain this information and others don’t.
Precog shows us all the available fields in the dataset. We can pick these and Precog will automatically take into account differences in structure, giving us access to the all the data.
If the same information is stored in different formats and structures, we can easily convert these and merge them together into a single column in the Precog user interface.
Without Precog, we have to examine samples of raw data. The sample we examined above does not contain the pharmaceutical classes of drugs, so without Precog we may be unaware of this information.
Even if we were aware of this information, we would need to factor the differences in structure into our query. We might think that the following query would be a sensible way of doing this.
select
results.value:safetyreportid as report_id,
reactions.value:reactionmeddrapt as reaction,
drugs.value:medicinalproduct as drug,
drugs.value:drugindication as drug_indication,
drugs.value:drugcharacterization as characterization,
classes.value as drug_class
from event_raw,
lateral flatten (input => data, path => 'results') results,
lateral flatten (input => results.value, path => 'patient:reaction') reactions,
lateral flatten (results.value, path => 'patient:drug') drugs,
lateral flatten (input => drugs.value, path => 'openfda:pharm_class_epc') classes
limit 10;
REPORT_ID | REACTION | DRUG | DRUG_INDICATION | CHARACTERIZATION | DRUG_CLASS |
---|---|---|---|---|---|
“16010135” | “Myocarditis” | “DOXYCYCLINE.” | “DERMATITIS ACNEIFORM” | “2” | “Tetracycline-class Drug [EPC]” |
“16018264” | “Renal impairment” | “DOXYCYCLINE.” | “INFECTION” | “2” | “Tetracycline-class Drug [EPC]” |
“16018264” | “Renal impairment” | “BISACODYL.” | “CONSTIPATION” | “2” | “Stimulant Laxative [EPC]” |
“16018264” | “Chronic kidney disease” | “DOXYCYCLINE.” | “INFECTION” | “2” | “Tetracycline-class Drug [EPC]” |
“16018264” | “Chronic kidney disease” | “BISACODYL.” | “CONSTIPATION” | “2” | “Stimulant Laxative [EPC]” |
“16018264” | “Renal injury” | “DOXYCYCLINE.” | “INFECTION” | “2” | “Tetracycline-class Drug [EPC]” |
“16018264” | “Renal injury” | “BISACODYL.” | “CONSTIPATION” | “2” | “Stimulant Laxative [EPC]” |
“16018264” | “Renal failure” | “DOXYCYCLINE.” | “INFECTION” | “2” | “Tetracycline-class Drug [EPC]” |
“16018264” | “Renal failure” | “BISACODYL.” | “CONSTIPATION” | “2” | “Stimulant Laxative [EPC]” |
“16018264” | “Acute kidney injury” | “DOXYCYCLINE.” | “INFECTION” | “2” | “Tetracycline-class Drug [EPC]” |
However this silently excludes all of the records which do not include drug class information.
In order to select all the data, we need to provide an additional outer => true
parameter to the flatten statement.
select
results.value:safetyreportid as report_id,
reactions.value:reactionmeddrapt as reaction,
drugs.value:medicinalproduct as drug,
drugs.value:drugindication as drug_indication,
drugs.value:drugcharacterization as characterization,
classes.value as drug_class
from event_raw,
lateral flatten (input => data, path => 'results') results,
lateral flatten (input => results.value, path => 'patient:reaction') reactions,
lateral flatten (results.value, path => 'patient:drug') drugs,
lateral flatten
(input => drugs.value, path => 'openfda:pharm_class_epc', outer => true) classes
limit 10;
REPORT_ID | REACTION | DRUG | DRUG_INDICATION | CHARACTERIZATION | DRUG_CLASS |
---|---|---|---|---|---|
“12698542” | “Adverse event” | “LANTUS” | NULL | “2” | NULL |
“12698542” | “Adverse event” | “LANTUS” | NULL | “2” | NULL |
“12698542” | “Adverse event” | “BACTRIM DS” | “CHRONIC SINUSITIS” | “2” | NULL |
“12698542” | “Adverse event” | “BENAZEPRIL HCL” | “DIABETES MELLITUS” | “2” | NULL |
“12698542” | “Adverse event” | “LYRICA” | “DIABETES MELLITUS” | “1” | NULL |
“12698542” | “Adverse event” | “TRAMADOL HCL” | “OSTEOARTHRITIS” | “2” | NULL |
“12698542” | “Adverse event” | “LANTUS” | “DIABETES MELLITUS” | “2” | NULL |
“12698542” | “Adverse event” | “NOVOLIN” | “DIABETES MELLITUS” | “2” | NULL |
“12698542” | “Adverse event” | “METFORMIN HYDROCHLORIDE.” | “DIABETES MELLITUS” | “2” | NULL |
“12698542” | “Adverse event” | “ELIQUIS” | “CARDIAC DISORDER” | “1” | NULL |
We can now save these results for future use.
create table drug_reactions as
select
results.value:safetyreportid as report_id,
reactions.value:reactionmeddrapt as reaction,
drugs.value:medicinalproduct as drug,
drugs.value:drugindication as drug_indication,
drugs.value:drugcharacterization as characterization,
classes.value as drug_class
from event_raw,
lateral flatten (input => data, path => 'results') results,
lateral flatten (input => results.value, path => 'patient:reaction') reactions,
lateral flatten (results.value, path => 'patient:drug') drugs,
lateral flatten
(input => drugs.value, path => 'openfda:pharm_class_epc', outer => true) classes;
Summary
To summarize, we have:
- Written a program to load and deal with the pagination of the data from the FDA API
- Installed
snowsql
and run it at the command line - Created a stage, data format and raw table
- Modified our program to reduce the document size
- Staged and loaded the data into the raw table
- Used a flatten statement to examine a sample of the raw non-tabular data
- Examined the raw source data to discover the data we’re interested in
- Used special knowledge to be aware of data that didn’t appear in the sample
- Written a query with multiple flatten statements and parameters to tabulate the data
By doing all of this now successfully paged, downloaded, imported, explored and tabulated the non-tabular data without using Precog.
Conclusion
Snowflake is an incredibly powerful and cost effective data warehouse. However, working with non-tabular data using Snowflake alone is an involved task that is time consuming, prone to error and not suited for self service.
Precog empowers even non-technical users to easily browse and curate tables from non-tabular data and load these tables directly into software such as Power BI and Tableau, databases such as Postgres and warehouses such as Snowflake.
Precog is a universal connector for non-tabular data such as MongoDB, JSON data in S3, data lakes, Azure Blob Storage, SaaS applications and web APIs such as Airship, Benchling, WooCommerce and HubSpot. Precog reduces development, integration, testing and compute times whilst improving accuracy and empowering analysts with self-service access to tabular and non-tabular data to fulfil their own data requests.