How jakobvongehlen/tendertransparency works
Tender Transparency NL is a dashboard for exploring Dutch public procurement awards, buyer concentration and competition, and gaps in published records. Its workflow downloads TenderNed data, ingests and enriches it, builds analytical tables, then serves them through a read-only API to interactive dashboard pages. README documents the ETL stages and capabilities; sampled frontend excerpts show routing and API usage. Backend call details and some page implementations were not sampled, so those relationships rely on README documentation or are omitted.
Main entry points: App.tsx App and routing · api.ts API client · BuyerProfile.tsx Buyer profile · Overview.tsx Overview and buyers
Components 28
Data pipeline
- Dataset download
etl/download.py - OCDS ingestion
etl/ingest.py - Geographic enrichment
etl/enrich.py
Procurement analysis
- Analytical model
etl/model.sql - Model runner
etl/model.py
API service
- Tender database
- JSON API
api/main.py
Dashboard
- App and routing
web/src/App.tsx - API client
web/src/api.ts - Overview and buyers
web/src/pages/Overview.tsx - Buyer profile
web/src/pages/BuyerProfile.tsx - Supplier profile
web/src/pages/SupplierProfile.tsx - Peer comparison
web/src/pages/Compare.tsx - Concentration patterns
web/src/pages/Patterns.tsx - Competition analysis
web/src/pages/Competition.tsx - Municipal map
web/src/pages/MapPage.tsx - Information gaps
web/src/pages/Gaps.tsx - Procedure details
web/src/pages/Procedure.tsx - Method guide
web/src/pages/Method.tsx - Cell drilldown
web/src/components/CellDrilldown.tsx - Buyer-supplier network
web/src/components/Network.tsx - Charts
web/src/components/Chart.tsx - Shared UI
web/src/components/ui.tsx - Value formatting
web/src/format.ts
External data
- TenderNed data
- PDOK services
- CBS data
Other components
- Dashboard user
Connections 36
- TenderNed data → Dataset download: provides datasets
README.md - Dataset download → OCDS ingestion: downloads releases
README.md - PDOK services → Geographic enrichment: provides geocoding
README.md - CBS data → Geographic enrichment: provides population
README.md - OCDS ingestion → Tender database: writes raw tables
README.md - Geographic enrichment → Tender database: adds lookups
README.md - Model runner → Analytical model: runs SQL model
README.md - Analytical model → Tender database: builds analysis tables
README.md - Tender database → JSON API: serves read-only queries
README.md - Dashboard user → App and routing: explores dashboard
web/src/App.tsx - App and routing → Overview and buyers: routes to
web/src/App.tsx - App and routing → Buyer profile: routes to
web/src/App.tsx - App and routing → Supplier profile: routes to
web/src/App.tsx - App and routing → Peer comparison: routes to
web/src/App.tsx - App and routing → Concentration patterns: routes to
web/src/App.tsx - App and routing → Competition analysis: routes to
web/src/App.tsx - App and routing → Municipal map: routes to
web/src/App.tsx - App and routing → Information gaps: routes to
web/src/App.tsx - App and routing → Procedure details: routes to
web/src/App.tsx - App and routing → Method guide: routes to
web/src/App.tsx - Overview and buyers → API client: fetches data
web/src/pages/Overview.tsx - Buyer profile → API client: fetches data
web/src/pages/BuyerProfile.tsx - Peer comparison → API client: fetches data
web/src/pages/Compare.tsx - Competition analysis → API client: fetches data
web/src/pages/Competition.tsx - Municipal map → API client: fetches data
web/src/pages/MapPage.tsx - API client → JSON API: requests JSON
web/src/api.ts - Cell drilldown → API client: fetches cell data
web/src/components/CellDrilldown.tsx - Buyer-supplier network → API client: fetches network
web/src/components/Network.tsx - Buyer profile → Cell drilldown: shows drilldown
web/src/pages/BuyerProfile.tsx - Buyer profile → Buyer-supplier network: shows network
web/src/pages/BuyerProfile.tsx - Supplier profile → Buyer-supplier network: shows network
web/src/pages/SupplierProfile.tsx - Overview and buyers → Charts: renders charts
web/src/pages/Overview.tsx - Competition analysis → Charts: renders charts
web/src/pages/Competition.tsx - Buyer profile → Shared UI: uses shared UI
web/src/pages/BuyerProfile.tsx - Buyer-supplier network → Charts: renders graph
web/src/components/Network.tsx - Overview and buyers → Value formatting: formats values
web/src/pages/Overview.tsx