prepare: Options for datasets without bids (e.g. R025)

[jpmckinney]

For R025 (Excessive unsuccessful bids), can consider filling in bids/details according to tender/tenderers, making the assumption that status is 'valid' and that each tenderer submitted a separate bid.

From discussion:

James: I'm not sure how this indicator should be modified if only tender/tenderers is available

Camila: I agree that the best option is to have bids information, where the bids are not disqualified or withdrawn. We should prioritize this and recommend the use of this field. However with tenderers/id, you could still calculate the success rate, with the limitation that you could be counting disqualified or withdrawn bids. We could highlight that, or maybe just calculate it with bids fields and in the methodology we could mention this alternative to users.

[jpmckinney]

This will be relevant for SERCOP, since only about about 50k of 2M procedures have bids.

[yolile]

This will be relevant for SERCOP, since only about about 50k of 2M procedures have bids.

Note: SERCOP only has bids for electronic auctions

[jpmckinney]

Noting SERCOP has /bids/details for 84% of Menor Cuantía.

SERCOP sets tenderers but not bids (in any location) in 19,888 procedures, all of which are Menor Cuantía (selective).

SELECT COUNT(*), data->'tender'->>'procurementMethod' procurementmethod, data->'tender'->>'procurementMethodDetails' procurementmethoddetails
FROM ecuador_sercop_bulk_clean
WHERE NOT data->'bids' ? 'details' AND data->'tender' ? 'tenderers'
GROUP BY procurementmethod, procurementmethoddetails;

There are 118,996 Menor Cuantía procedures in total

 2218642 | selective         | Catálogo electrónico
 1483621 | direct            | Catálogo electrónico
  356652 | open              | Subasta Inversa Electrónica
  118996 | selective         | Menor Cuantía
   53136 | direct            | Contratacion directa
   37701 | direct            | Bienes y Servicios únicos
   37380 |                   | 
   36451 | direct            | Comunicación Social – Contratación Directa
   36206 | direct            | Contratos entre Entidades Públicas o sus subsidiarias
   31155 | open              | Cotización
   19620 | direct            | Obra artística, científica o literaria
   16941 | direct            | Repuestos o Accesorios
    9161 | open              | Licitación de Seguros
    7618 | limited           | Lista corta
    6577 | open              | Licitación
    5015 | limited           | Comunicación Social – Proceso de Selección
    2402 | direct            | Contratación de Seguros
    1616 | direct            | Asesoría y Patrocinio Jurídico
     609 | direct            | Transporte de correo interno o internacional
     399 | direct            | Contratación Directa por Terminación Unilateral
     365 | open              | Concurso publico
     194 | direct            | Contrataciones con empresas públicas internacionales
     110 | open              | Concurso Público por Lista Corta Desierta
      73 | direct            | Asesoría y Patrocinio Jurídico – Cons. puntuales y específicas
      24 | limited           | Lista Corta por Contratación Directa Desierta
       8 | open              | Concurso Público por Contratación Directa Desierta

[Camilamila]

Cc' my answer from slack. I don't think this would be relevant for menor cuantía, since its invitation only to one qualified bidder. Menor Cuantía is not an open method, It’s mapped to selective. So its invitation only, and there should only be one bidder, so I don’t think the indicator applies in this case.

[jpmckinney]

Let's continue on Slack, because most of that doesn't match the data (there are frequently multiple bidders, selective doesn't mean invitation only – it means there is a qualification stage).

[jpmckinney]

Having read that page, there is something wrong with their data. They should not have up to hundreds of "tenderers" for a procedure with a single tenderer.

Anyway, I will not implement the tender/tenderers backup in case bids/details is missing for R025, since we don't want this indicator for Menor Cuantía in Ecuador.