search

FDA / openfda

openFDA is an FDA project to provide open APIs, raw data downloads, documentation and examples, and a developer community for an important collection of FDA public datasets.
https://open.fda.gov
Creative Commons Zero v1.0 Universal
572 stars 132 forks source link

REGRESSION: Search is including unrelated results #116

Closed beckyconning closed 4 years ago

beckyconning commented 4 years ago

https://api.fda.gov/drug/event.json?count=patient.drug.drugindication.exact

    {
      "term": "OSTEOARTHRITIS",
      "count": 23323
    },

https://api.fda.gov/drug/event.json?search=patient.drug.drugindication=OSTEOARTHRITIS&limit=100

    "results": {
      "skip": 0,
      "limit": 100,
      "total": 51909
    }

Also it seems that this search contains reports which contain no drugs indicated for osteoarthritis e.g.

        "drug": [
          {
            "drugstartdateformat": "102",
            "drugintervaldosageunitnumb": "1",
            "drugadministrationroute": "048",
            "drugdosageform": "FILM-COATED TABLET",
            "drugstartdate": "20031111",
            "drugenddateformat": "102",
            "drugauthorizationnumb": "020788",
            "drugenddate": "20031202",
            "drugstructuredosageunit": "003",
            "medicinalproduct": "PROPECIA",
            "activesubstance": {
              "activesubstancename": "FINASTERIDE"
            },
            "drugcharacterization": "1",
            "drugstructuredosagenumb": "1",
            "drugintervaldosagedefinition": "804",
            "drugdosagetext": "1 MG, QD",
            "drugseparatedosagenumb": "1"
          },
          {
            "drugstartdateformat": "102",
            "drugintervaldosageunitnumb": "1",
            "drugadministrationroute": "048",
            "drugdosageform": "FILM-COATED TABLET",
            "drugstartdate": "20040329",
            "drugenddateformat": "610",
            "drugauthorizationnumb": "020788",
            "drugenddate": "200411",
            "drugstructuredosageunit": "003",
            "medicinalproduct": "PROPECIA",
            "activesubstance": {
              "activesubstancename": "FINASTERIDE"
            },
            "drugcharacterization": "1",
            "drugstructuredosagenumb": "1",
            "drugintervaldosagedefinition": "804",
            "drugdosagetext": "1 MG, QD",
            "drugseparatedosagenumb": "1"
          },
          {
            "drugstartdateformat": "102",
            "drugindication": "ALOPECIA",
            "drugintervaldosageunitnumb": "1",
            "drugadministrationroute": "048",
            "drugdosageform": "FILM-COATED TABLET",
            "drugstartdate": "20021216",
            "drugenddateformat": "102",
            "drugauthorizationnumb": "020788",
            "drugenddate": "20030618",
            "drugstructuredosageunit": "003",
            "medicinalproduct": "PROPECIA",
            "activesubstance": {
              "activesubstancename": "FINASTERIDE"
            },
            "drugcharacterization": "1",
            "drugstructuredosagenumb": "1",
            "drugintervaldosagedefinition": "804",
            "drugdosagetext": "1 MG, QD",
            "drugseparatedosagenumb": "1"
          }
        ]
beckyconning commented 4 years ago

This appears to be a regression as previously the correct results were returned.

beckyconning commented 4 years ago

Hi! This is a serious issue affecting multiple researchers from different organisations.

beckyconning commented 4 years ago

We should have had a : instead of a = 🤦‍♀️