bi.open-contracting.org's People
bi.open-contracting.org's Issues
Add chart: Proportion of awards with competitive contracting processes over time
Chart details:
- Type: Single Line Chart
- Title: Proportion of awards with competitive contracting processes over time
- Description: Identify which times of the year does competition suffer.
- X-axis → Month and year
- Y-axis → Proportion of awards
Additonal details:
- Timestamp to use the date of the compiled release.
- Zoom into shorter time periods.
Add tile: Contracting processes with collusion red flags
Tile details
- < Number > and < Percentage > Contracting processes with collusion red flags
Add tile: Buyers with contracting processes with competition red flags
Tile details:
- < Number > and < Percentage > Buyers with contracting processes with competition red flags
Add tile: Buyers with contracting processes with 3+ competition red flags
Tile details
- < Number > and < Percentage > Buyers with contracting processes with 3+ competition red flags
Add chart: Top bidders with the highest number of red flags
Chart details:
- Type: Horizontal bar chart
- Title: Top bidders with the highest number of red flags
- Description: Identify who are the bidders with the highest number of red flags. Note that bidders may become suppliers.
- X-axis → Count of red flags
- Y-axis → Bidder name
Add chart: Prices over time for item category
Chart details:
- Type: Scatter plot
- Title: Prices over time for item category
- Description: Identify price disparity in specific item categories.
- X-axis → Month & Year
- Y-axis → Unit Price ($USD)
Additional details:
- Chart is for a specific item category only.
- Users can select the item category using a dropdown.
Add chart: Number of unique suppliers for a contracting process per item category
Chart details:
- Type: Horizontal bar chart
- Title: Number of unique suppliers for a contracting process per item category
- Description: See which item categories are more likely to end up with multiple suppliers contributing to fulfilling a contract.
- X-axis → Number of unique suppliers
- Y-axis → Item category
Additional details:
- Only the top 10 bars to be displayed. ‘See all’ button to view in a table.
- This considers all tenders not only competitive ones.
- Add in a tooltip: Number of contracting processes for the specific item category
Add tile: Contracting processes with competition red flags
Tile details:
- < Number > and < Percentage > Contracting processes with competition red flags
Add tile: Buyers with contracting processes with collusion red flags
Tile details:
- < Number > and < Percentage > Buyers with contracting processes with collusion red flags
Add chart: Contracting processes with red flags detected over time
Chart details:
- Type: Single line chart
- Title: Contracting processes with red flags detected over time
- Description: Visualise the overall trend to see if the number of contracting processes with red flags is getting better or worse over time or if there are specific times of the year when red flags are more likely to occur.
- X-axis → Month and year
- Y-axis → Proportion of contracting processes with red flags
Additional details:
- Timestamp to use the date of the compiled release
- Zoom into shorter time periods
Add chart: Proportion of contracting processes with red flags
Chart details:
- Type: 2-Slice Pie Chart
- Title: Proportion of contracting processes with red flags
- Slice A → Contracting processes with red flags
- Slice B → Contracting processes with no red flags
Add tile: Bidders with ‘supplier’ red flags
Tile details:
- < Number > and < Percentage > Bidders with ‘supplier’ red flags
Add chart: Price distribution per item category
Chart details:
- Type: Box plot
- Title: Price distribution per item category
- Description: Compare the unit price distribution between different item categories.
- X-axis → Item category
- Y-axis → Unit price
Additional details:
- One box plot for each price category. Users can select the item category using the dropdown.
- Users can select up to 5 item categories to compare.
- Include only item categories with a reasonable number of procedures. We need to check the data to select the threshold.
Add tile: Total bidder red flags detected
Tile details:
- < Number > Total bidder red flags detected
Ad tile: Bidders with red flags
Tile details:
- < Number > and < Percentage > Bidders with red flags
Add chart: Buyers with highest proportion of competition red flags
Chart details:
- Type: Horizontal bar chart
- Title: Buyers with highest proportion of contracting processes with competition red flags
- Description: See which buyers have a higher proportion of competition red flags
- X-axis → %
- Y-axis → Buyer name
Additional details:
- Exclude buyers with very few procedures. Check in the data what is the reasonable threshold. Eg. > 100 procedures.
- Only the top 10 bars with the highest proportion are to be displayed.
Add tile: Types of red flags found (out of XX)
Tile details:
- Title: < Number > Types of red flags found (X out of Y)
Additional details:
- This is not the count of red flags (which can be in the thousands), rather how many of the different red flags have been detected (R022, R023, R024, R028, R025, R034 etc...)
Add tile: Awards with competitive contracting processes
Tile details:
- Title: < Number > and < Percentage > Awards with competitive contracting processes
Add chart: Mean number of bidders for a contracting process per item category
Chart details:
- Type: Horizontal bar chart
- Title: Mean number of bidders for a contracting process per item category
- Description: See if there are item categories that are more competitive than others.
- X-axis → Mean number of bidders
- Y-axis → Number of unique bidders
Additonal details:
- Only the top 10 bars to be displayed. ‘See all’ button to view in a table.
- Add in tooltip: number of contracting processes for the specific item category.
- Need to check if there are outliers, e.g item categories with very few procedures and a high average, to evaluate if we should filter only for top item categories.
Add tile: Mean unique red flags per supplier
Tile details:
- < Number > Mean unique red flags per supplier
Add table: List of historical bidders and awarded suppliers by item categories
Table details:
- Title: List of historical bidders and awarded suppliers by item categories
- Description: This table lists for a specific item category, who have been the historical bidders and awarded suppliers. Start by selecting the item category from the dropdown.
Filters:
- Item category
- Bidder name
- Region
Columns:
Column Heading | Field Description | Requirements |
---|---|---|
Item category | The classification of the item using the OCDS field tender/items/classification/ description and the high level codes. Ecuador uses an internal classification scheme CPC. | Users can filter for a specific category. |
Bidder name | The name of the or bidder. The OCDS field is parties/name. | Users can filter by bidder name |
Region | Region of the supplier. The OCDS field is parties/address/region. | Users can filter by region |
Locality | Locality of the supplier. The OCDS field is parties/address/locality. | |
Number of awards | This indicates the number of awards the bidder has received for a particular item category | This is a calculated metric |
Number of bids | This indicates the number of bids this particular bidder submitted for a specific item category | This is a calculated metric |
Add chart: Proportion of total value awarded in competitive contracting processes over time
Chart details:
- Type: Single Line Chart
- Title: Proportion of total value awarded in competitive contracting processes over time
- Description: Understand the amount of public spending that goes on competitive contracting processes.
- X-axis → Month and year
- Y-axis → Total value of awards ($1,000)
Additional details:
- Add in a tooltip: “Proportion and total amount.”
Add chart: Collusion red flags frequency
Chart details:
- Type: Horizontal bar chart
- Title: Collusion red flags frequency
- Description: Identify which collusion red flags are most prevalent.
- X-axis → Number of contracting processes flagged
- Y-axis → Red flag name
Add table: List of contracting processes and details of competitiveness
Table details:
- Title: List of contracting processes and details of competitiveness.
- Description: This table lists contracting processes and details of the competitiveness of those contracting processes.
Filters:
- Ocid
- Buyer name
- Item category
- Date
- Competitive contracting process
Columns:
Column Heading | Field Description | Requirements |
---|---|---|
OCID | The OCDS field ocid. The globally unique identifier for this Open Contracting Process. | Users can click on an OCID to view the specific contracting process, in the Individual Contracting Process dashboard. |
Buyer name | The name of the buyer using the OCDS field buyerName. Alternatively use tender/procuringEntity. | Users can click on the buyer name to go to the Individual Buyers Dashboard. Filter for a specific buyer. |
Tender title | The title of the tender per the OCDS field tender/title. | |
Item category | The classification of the item using the OCDS field tender/items/classification/ description and the high level codes. Ecuador uses an internal classification scheme CPC. | Users can filter for a specific category. |
Date | The timestamp for the contracting process using the OCDS field tender/period/startDate. | Users can filter the contracting processes by selecting a date |
Tender value | The value of the contract and the currency. OCDS fields tender/value/amount and tender/value/currency. | Users can sort by value amount e.g. highest to lowest. |
Competitive contracting process | The different types of open contracting processes using the OCDS field tender/procurementMethodDetails | |
Number of unique bidders | The number of parties who submit a bid as per the OCDS field tenderNumberOfTenderers. | Number of unique bidders |
Supplier name | The name of the awarded supplier. The OCDS field is parties/name, where roles= ‘supplier’. The field award/supplier/name may also be used. | Can be more than one supplier. If so have all suppliers on one row, semi colon separated |
Add tile: Bidders with red flags
Tile details:
- Title: < Number > and < Percentage > Bidders with red flags
Additional details:
- This calculates the proportion of bidders that have +1 red flags.
Add chart: Buyers with the highest proportion of contracting processes with 1+ collusion red flags
Chart details:
- Type: Horizontal bar chart
- Title: Buyers with the highest proportion of contracting processes with 1+ collusion red flags
- Description: Identify which buyers have a higher risk collusion occurring.
- X-axis → Proportion of contracting processes with collusion red flags (0-100%)
- Y-axis → Buyer name
Additional details:
- Only the top 10 bars to be displayed. ‘See all’ button to view in a table.
- Add tooltip with number of procedures.
- Exclude buyers with very few procedures. Check in the data what is the reasonable threshold. Eg. > 100 procedures.
Add chart: Market concentration per item category (R051)
Chart details:
- Type: Horizontal bar chart
- Title: Market concentration per item category
- Description: See which item categories have a higher market concentration. A market with a HHI index above 2500 is considered highly concentrated.
- X-axis → Market Concentration HHI index (0-10,000)
- Y-axis → Item category
Additional details:
- Only the top 10 bars with the highest market concentration are to be displayed.
- The tooltip should indicate the number of contracting processes for that particular item
Add tile: Bidders with ‘collusion detection’ red flags
Tile details:
- < Number > and < Percentage > Bidders with ‘collusion detection’ red flags
Add chart: Proportion of single bid tenders over time
Chart details:
- Type: Single Line Chart
- Title: Proportion of single bid tenders over time
- Description: See if there are seasonal patterns in the proportion of tenders that only have a single bidder. Note that you can have a competitive process, but still only have a single bidder.
- X-axis → Month and year
- Y-axis → Proportion of awards
Additional details:
- Calculate this only for competitive contracting proceses.
Add chart: Item categories with a higher proportion of contracting processes with collusion risk
Chart details:
- Type: Horizontal bar chart
- Title: Item categories with a higher proportion of contracting processes with collusion risk
- Description: Identify if there is a higher collusion risk in specific item categories
- X-axis → Proportion of contracting processes in item category with collusion detection red flags (0-100%)
- Y-axis → Item category
Additional details:
- Only the top 10 bars to be displayed. ‘See all’ button to view in a table.
Add chart: Proportion of contracting processes with red flags now completed
Chart details:
- Type: 2-Slice Pie Chart
- Title: Proportion of contracting processes with red flags now completed
- Slice A → Contracting processes with red flags still in progress
- Slice B → Contracting processes with red flags now completed
Additional details:
- When the user clicks on a slice, only data for that segment to show in the other charts and for this to be highlighted.
- Data labels with percentage and value should show upon hover.
Add chart: Item categories with a higher proportion of price related flagged contracting processes
Chart details:
- Type: Horizontal bar chart
- Title: Item categories with a higher proportion of price related flagged contracting processes
- Description: Identify which item categories have a higher proportion of contracting processes with price related red flags.
- X-axis → Proportion of contracting processes in item category with price red flags
- Y-axis → Item category
Additional details:
- Only the top 10 bars to be displayed. ‘See all’ button to view in a table.
- Red flags are tender value higher or lower than average, items with unreasonable prices.
- Add tooltip for the number of contracting processes for the item category.
Add tile: Total unique bidders
Tile description
- < Number > Total unique bidders
Add chart: Proportion of value awarded in single bid tenders vs competitive tenders
Chart details:
- Type: 2-Slice Pie Chart
- Title: Proportion of value awarded in single bid tenders vs competitive tenders
- Slice A → Proportion of value awarded to single bid tenders ($000 USD)
- Slice B → Proportion of value awarded to competitive tenders ($000 USD)
Additional details:
- Data labels with percentage and value should show upon hover.
Add table: List of contracting processes with collusion red flags
Table details:
- Title: List of contracting processes with collusion red flags
- Description: This table lists all contracting processes with collusion red flags. Identify the riskiest contracting processes by sorting the list.
Filters:
- Ocid
- Buyer name
- Item category
- Date range
- Status
Columns:
Column Heading | Field Description | Requirements |
---|---|---|
OCID | The OCDS field ocid. The globally unique identifier for this Open Contracting Process. | Users can click on an OCID to view the specific contracting process, in the Individual Contracting Process dashboard. |
Buyer | The name of the buyer using the OCDS field buyerName. Alternatively use tender/procuringEntity. | Users can click on the buyer name to go to the Individual Buyers Dashboard. Users can filter for a specific buyer. |
Tender title | The title of the tender per the OCDS field tender/title. | |
Item category | The classification of the item using the OCDS field tender/items/classification/ description and the high level codes. Ecuador uses an internal classification scheme CPC. | Users can filter for a specific category |
Date | The timestamp for the red flag using the OCDS field tender/startDate. | Users can filter the contracting processes by selecting a date range. |
Status | The current status of the tender, from the closed tenderStatus codelist, using the OCDS field tender/status. | Users can filter by status using a dropdown with the different options. |
Supplier name | Name of the awarded supplier. | If multiple suppliers are awarded, separate by ; |
Count of red flags | This is the total of all of the collusion red flags detected in the contracting process. | Users to see visually via a colour scale which contracting processes are more problematic. Scale is for 1-9 red flags.Users can sort by value amount e.g. highest to lowest.Include note to state that buyers that are involved in more contracting processes are likely to have more red flags. |
Red flag name | This indicates if the red flag is present. A column for each flag should be added (see table below). | Users to see visually via colour that there is a red flag.The column headings will have names for each flag rather than F1, F2… |
Add tile: Contracting processes with tender value higher or lower than average
Tile details:
- < Number > and < Percentage > Contracting processes with tender value higher or lower than average
Add tile: Contracting processes with red flags
Tile details:
- Title: < Number > and < Percentage > Contracting processes with red flags
Add tile: Bidders with ‘competition’ red flags
Tile details:
- < Number > and < Percentage > Bidders with ‘competition’ red flags
Add chart: Contracting processes by number of red flags it has
Chart details:
- Type: Vertical Bar Chart
- Title: Contracting processes by number of red flags it has
- Description: Identify the contracting processes that have multiple risks through the count of red flags that are associated with them.
- X-axis → Number of red flags (1, 2, 3, 4, 5+)
- Y-axis → Count of contracting processes
Additional details:
- Bars should all be the same colour.
Add tile: Mean bidders per tender in competitive processes
Tile details:
- Title < Number > Mean bidders per tender in competitive processes
Add tile: Total number of contracting processes
Tile details:
- Title: < Number > and < Percentage > Contracting processes with red flags detected over time
Add table: List of contracting processes that procured a particular item
Table details:
- Title: List of contracting processes that procured a particular item
- Description: This table lists all of the contracting processes that have procured a particular item. Each contracting process can have multiple items and different quantities of an item.
Filters:
- Ocid
- Buyer name
- Procurement method
- Procurement method details
- Date range
- Status
- Item category
Columns:
Column Heading | Field Description | Requirements |
---|---|---|
OCID | The OCDS field ocid. The globally unique identifier for this Open Contracting Process. | Users can click on an OCID to view the specific contracting process, in the Individual Contracting Process dashboard. |
Buyer | The name of the buyer using the OCDS field buyerName. Alternatively use tender/procuringEntity. | Users can click on the buyer name to go to the Individual Buyers Dashboard. Users can filter for a specific buyer |
Procurement method | The method used to procure the goods/services. The OCDS field is tender/procurementMethod | Users can filter by procurement method |
Procurement method details | The details of the method used to procure the goods/services. The OCDS field is tender/procurementMethodDetails | Users can filter by procurement method details |
Date | The timestamp for the red flag using the OCDS field tender/startDate. | Users can filter the contracting processes by selecting a date range. |
Status | The current status of the tender, from the closed tenderStatus codelist, using the OCDS field tender/status. | Users can filter by status |
Tender title | The title of the tender per the OCDS field tender/title. | |
Item category | The classification of the item using the OCDS field tender/items/classification/ description and the high level codes. Ecuador uses an internal classification scheme CPC. | Users can filter for a specific category.If a tender has multiple items separate into different rows. |
Quantity | The number of units to be provided. The OCDS field is tender/items/quantity. | |
Unit | The description of the unit in which the supplies, services or works are provided (e.g. hours, kilograms). The OCDS field is tender/items/unit. | |
Item unit value | The value of the item and the currency. OCDS fields tender/items/unit/value/amount and tender/items/unit/value/currency. | Users can sort by value amount e.g. highest to lowest. |
Number of unique bidders | The number of parties who submit a bid as per the OCDS field tenderNumberOfTenderers. | |
Supplier name | The name of the entity supplying the goods/services. The OCDS field supplier/name. | Users can click on the supplier name to go to the Individual Suppliers Dashboard. Users can filter for a specific supplier |
Region | Region of the supplier. The OCDS field is parties/address/region. | Region is for the supplier |
Locality | Locality of the supplier. The OCDS field is parties/address/locality. | Locality is for the supplier |
Add tile: Single bid tenders
Tile details:
- Title: < Percentage > Single bid tenders
Add chart: Competition red flags frequency
Chart details:
- Type: Horizontal bar chart
- Title: Competition red flags frequency
- Description: See which competition red flags are most common.
- X-axis → Contracting processes with ‘competition’ red flags
- Y-axis → Red flag name
Add tile: Contracting processes with items with unreasonable prices
tile details:
- < Percentage > Contracting processes with items with unreasonable prices
Add table: List of item categories and details of their price distribution
Table details:
- Title: List of item categories and details of their price distribution
- Description: This table lists for all item categories, details of their unit price distribution and the number of procedures. You can use this table to identify average unit prices and market concentration.
Filters:
- Item category
Columns:
Column Heading | Field Description | Requirements |
---|---|---|
Item category | The classification of the item using the OCDS field tender/items/classification/ description and the high level codes. | Users can filter for a specific category |
Number of contracting processes | This is the count of the contracting processes for the item category. | |
Market concentration | This is a calculation that uses the Herfindahl–Hirschman Index (HHI). Formula → HHI = s21 + s22 + s23 + s24 + ….s2nwhere S2n = the market share percentage of firm n expressed as a whole number.HHI can range from close to 0 (near perfect competition) to 10,000 (a monopoly). | |
Average unit price | This is a calculated field. | |
Median unit price | This is a calculated field. | |
Standard deviation of the unit price | This is a calculated field. |
Add tile: Contracting processes with 3+ competition red flags
Tile details:
- < Number > and < Percentage > Contracting processes with 3+ competition red flags
Add table: List of contracting processes with competition red flags
Table details:
- Title: List of contracting processes with competition red flags
- Description: This table lists all contracting processes with competition red flags. Identify the riskiest contracting processes by sorting the list.
Filters:
- Ocid
- Buyer name
- Item category
Columns:
Column Heading | Field Description | Requirements |
---|---|---|
OCID | The OCDS field ocid. The globally unique identifier for this Open Contracting Process. | Users can click on an OCID to view the specific contracting process, in the Individual Contracting Process dashboard. |
Buyer name | The name of the buyer using the OCDS field buyerName. Alternatively use tender/procuringEntity. | Users can click on the buyer name to go to the Individual Buyers Dashboard. Users can filter for a specific buyer. |
Tender title | The title of the tender per the OCDS field tender/title. | |
Item category | The classification of the item using the OCDS field tender/items/classification/ description and the high level codes. Ecuador uses an internal classification scheme CPC. | Users can filter for a specific category.If there are multiple items, separate by semi-colon and keep on one row. |
Date | The timestamp for the contracting process using the OCDS field tender/startDate. | Users can filter the contracting processes by selecting a date range. |
Count of red flags | This is the total of all of the competition red flags that are associated with the contracting process | Users to see visually via a colour scale which contracting processes are more problematic. Scale is for 1-6 red flags.Users can sort by value amount e.g. highest to lowest. |
Red flag name | This indicates if the red flag is present. A column for each flag should be added (see table below). | Users to see visually via colour that there is a red flag.The column headings will have names for each flag rather than F1, F2… and a tooltip for the flag description.Users can filter to select just the contracting processes with a specific flag |
Add chart: Most prevalent red flags for contracting processes
Chart details:
- Type: Horizontal Bar Chart
- Title: Most prevalent red flags for contracting processes
- Description: See the prevalence of the different red flags in contracting processes being tracked to understand what kind issues are more common.
- X-axis → Count of red flags
- Y-axis → Red flag name
Additional details
- Only the top 10 bars to be displayed. ‘See all’ button to view in a table.
- The bars of the four categories of red flags ‘competition’, ‘collusion detection’, ‘related suppliers’ and ‘prices’ need to be different colours.
Add tile: Buyers with red flags
Tile details:
- Title: < Number > and < Percentage > Buyers with contracting processes with red flags
Additional details:
- This calculates the number and proportion of buyers that have +1 contracting processes flagged
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.