JSON to Insights: Tabulating Non-tabular Data Without Precog
December 9, 2019

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.

Screenshot of an error uploading a file in the Snowflake UI

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.

Previous page: Tabulating non-tabular data with Precog

Next page: Analysing the tabulated data with Power BI

NEWS & BLOG

Precog Partners with SME

Precog Partners with SME

Precog, the company behind the popular Precog solution for transforming and loading complex data for analytics and data science, has partnered with SME Solutions Group, Inc. based in Tampa, Florida.

read more