Skip to content

Trending: Treatment of Timestamps and Statuses

For example, here are two records

{ "timestamp_range" : { "min" : "2014-08-14 00:00:00", "max" : "2014-08-14 00:00:00" }, "timestamps" : { "tender_awardDeadline" : null, "tender_contractSignatureDate" : null, "tender_awardDecisionDate" : null, "tender_bidDeadline" : null, "tender_cancellationDate" : null, "tender_estimatedStartDate" : null, "tender_estimatedCompletionDate" : null, "tender_publications_firstCallForTenderDate" : null, "tender_publications_lastCallForTenderDate" : null, "tender_publications_firstdContractAwardDate" : "2014-08-14 00:00:00", "tender_publications_lastContractAwardDate" : "2014-08-14 00:00:00", "lot_contractSignatureDate" : null, "lot_cancellationDate" : null }, "identified_status" : "Closed" }

{ "timestamps" : { "epublished_date" : "2021-08-16 09:00:00", "epublished_date_" : "2021-08-16 09:00:00", "tender_opening_date" : "2021-09-09 10:30:00", "bid_opening_date" : "2021-09-09 10:30:00", "bid_submission_start_date" : "2021-08-18 09:00:00", "bid_submission_closing_date" : "2021-09-07 18:00:00", "bid_submission_end_date" : "2021-09-07 18:00:00", "document_download_start_date" : "2021-08-18 09:00:00", "document_download_end_date" : "2021-09-07 18:00:00" }, "timestamp_range" : { "min" : "2021-08-16 09:00:00", "max" : "2021-09-09 10:30:00" }, "identified_status" : "Closed" }
  • These are primary fields that one is going to find in a document comprising data for a project or a tender. Few ways to identify whether a project or a tender is active or prospective is by looking at the identified_status field.
  • If the project is prospective that it can be categorized as TRENDING if the max date is not less than two years than today's date.
  • If the tender is active, it can be categorized as TRENDING if the max date is not less than one week than today's date.