Georgian procurement data in OCDS Analytics

date 08-07-2019

We imported a new database into the OCDS Analytics SaaS. Now, apart from the ProZorro data, Georgian State Procurement Agency (SPA) data is also available.

SPA logo

Currently, there are 275K Georgian tenders, 184K contracts, and 38K organizations accessible via our API at https://ocdsanalytics.com/ge/spa/graphql.

Try it

How to build queries for Georgian data

Georgian data shares the OCDS Analytics data structure with the ProZorro, so you can use the same documentation while building queries. Note that our API GUI contains docs and schema that will help in writing the correct queries.

Here are some examples.

To get the number of completed tenders in the system use the following request:

{
  Tenders(
    filters: { eq: { field: "status", value: "complete" } }
  ) {
    aggregation {
      count
    }
  }
}

Results:

{
  "data": {
    "Tenders": {
      "aggregation": {
        "count": 187378
      }
    }
  }
}

To get the top 3 suppliers send the following request:

{
  Organizations(
    page: { limit: 3 }
    order: {
      aggregation: { sum: { contractsAsSupplier: { field: "value.amount" } } }
      direction: "DESC"
    }
  ) {
    values {
      name
      contracts {
        aggregation {
          sum(params: { field: "value.amount" })
          count
        }
      }
    }
  }
}

Results:

{
  "data": {
    "Organizations": {
      "values": [
        {
          "name": "Xinjiang Beiken Energy Engineering Co., Ltd",
          "contracts": {
            "aggregation": {
              "sum": 7664331097,
              "count": 22
            }
          }
        },
        {
          "name": "ONUR TAAHHUT TASIMACILIK İNSAAT TİCARET VE SANAYİ ANONİM SİRKETİ(ОНУР ТААХХУТ ТАШИМАДЖИЛИК ІНШААТ ТІДЖАРЕТ ВЕ САНАЇ АНОНІМ ШИРКЕТІ)",
          "contracts": {
            "aggregation": {
              "sum": 5388670988,
              "count": 18
            }
          }
        },
        {
          "name": "POJAZDY SZYNOWE PESA BYDGOSZCZ SPÓŁKA AKCYJNA",
          "contracts": {
            "aggregation": {
              "sum": 2381641472,
              "count": 2
            }
          }
        }
      ]
    }
  }
}

To get a list of tenders with a specific classifier:

{
Tenders(
    page: { limit: 3 }
    filters: [
      {
        eq: {
          relatedField: { classification: { field: "id" } }
          value: "39500000-7"
        }
      }
    ]
  ) {
    tenders: values {
      id
      value {
        amount
      }
      tenderers {
        values {
          id
        }
      }
      procuringEntity {
        id
        name
        identifier {
          id
          scheme
          legalName
        }
      }
    }
  }
}

Results:

{
  "data": {
    "Tenders": {
      "tenders": [
        {
          "id": "SPA130027350",
          "value": {
            "amount": 1100
          },
          "tenderers": {
            "values": [
              {
                "id": "GE-NAPR-439862622"
              }
            ]
          },
          "procuringEntity": {
            "id": "GE-NAPR-204861970",
            "name": "ილიას სახელმწიფო უნივერსიტეტი",
            "identifier": {
              "id": "204861970",
              "scheme": "GE-NAPR",
              "legalName": null
            }
          }
        },
        {
          "id": "SPA130027321",
          "value": {
            "amount": 3880
          },
          "tenderers": {
            "values": [
              {
                "id": "GE-NAPR-201946573"
              }
            ]
          },
          "procuringEntity": {
            "id": "GE-NAPR-205190513",
            "name": "სსიპ საქართველოს შინაგან საქმეთა სამინისტროს მომსახურების სააგენტო",
            "identifier": {
              "id": "205190513",
              "scheme": "GE-NAPR",
              "legalName": null
            }
          }
        },
        {
          "id": "SPA130027433",
          "value": {
            "amount": 15850
          },
          "tenderers": {
            "values": [
              {
                "id": "GE-NAPR-56001023202"
              },
              {
                "id": "GE-NAPR-202251080"
              },
              {
                "id": "GE-NAPR-412675939"
              },
              {
                "id": "GE-NAPR-204379957"
              }
            ]
          },
          "procuringEntity": {
            "id": "GE-NAPR-243570989",
            "name": "თვითმმართველი ერთეული ხარაგაულის მუნიციპალიტეტი",
            "identifier": {
              "id": "243570989",
              "scheme": "GE-NAPR",
              "legalName": null
            }
          }
        }
      ]
    }
  }
}