GET A
QUOTE

Client

EuroPAM is a European anti-corruption initiative within the DIGIWHIST project, supported by a consortium of universities and anti-corruption institutions. The platform collects open data on political financing, public procurement, access to information, conflicts of interest and financial openness across European countries. The website turns this data into a tool that analysts, journalists and the public can work with.

EuroPAM desktop version, screen 1EuroPAM desktop version, screen 2EuroPAM desktop version, screen 3EuroPAM desktop version, screen 4EuroPAM desktop version, screen 5

Challenges

The project needed an online platform for analyzing and comparing the transparency and accountability of European states against key criteria. The data had to be accurate, updated regularly in line with current legislation, and presented so that not only expert audiences could make sense of it.

Platform users: public policy analysts and researchers, investigative journalists, civic activists and NGOs, government bodies, and European advocacy organizations.

  • A single database: systematize data for each country on political financing, public procurement, conflicts of interest and more.
  • Visual comparison: maps, filters and comparison of states by forms of transparency.
  • Primary sources in open access: downloadable regulatory documents in PDF and XLS.
  • Compliance with Horizon 2020 requirements: correctly display the project's funding.

Implementation challenges

  1. Data from 28+ countries

    Open legislative data organized into 5 indicators, with country comparison and year-over-year dynamics.

  2. Complex data for a wide audience

    Interactive color-coded maps help people beyond experts make sense of the data.

  3. Accuracy and Horizon 2020

    SQL tests and cross-checks before publication, and correct acknowledgment of the project's funding.

Solution

  1. Data collection from legislative sources. Data was gathered from open sources and organized into 5 indicators: political financing, public procurement, access to information, conflicts of interest, financial openness.
  2. A database with year-over-year comparison. We created a structured repository where countries can be compared with each other and over time; data is imported from CSV and XLS.
  3. Interactive maps. Transparency levels are visualized on a map with color-coded countries.
  4. A document library. Regulations and tables are available for download in PDF and XLS formats.
  5. Pre-publication checks. Data accuracy was verified with SQL tests and content cross-checks, and the maps with UX testing.
EuroPAM

Results

  • A database covering 28+ countries across 5 transparency categories.
  • An interactive color-coded map and country comparison, openly accessible.
  • Regulations and tables available for download in PDF and XLS formats.
  • Horizon 2020 funding is stated in the legal section.

Technical details

  • Platform: Laravel, SQL database with CSV and XLS import, interactive maps.
  • Program requirements: Horizon 2020 funding acknowledgment, as the program requires.
  • Promodex team: 7 specialists — project manager, business analyst, UI/UX designer, front-end and back-end developers, QA engineer, SEO specialist.

Technologies

Have a large body of open data that needs to be made understandable?
Contact us and we will design a portal with a database, search and clear presentation for a wide audience.

Next project

Dive And See Underwater Video Store Case Study

Ready to build something remarkable?
Awards & recognition
1st place WEBAWARDS
Online store developers
2nd place WEBAWARDS
Magento CMS developers
1st place WEBAWARDS
Online store developers
5th place Clutch
Top small business web design companies
7th place Clutch
Top WordPress developers
2nd place Clutch
Top 30 web development companies
19th place Clutch
List of the top Wyoming web design companies
4th place Clutch
Top web designers in Casper
22nd place Clutch
Top web developers in Wyoming
4th place 99 Firms
40 Best web design companies
1st place Digital Agency Network
Best digital marketing agencies in Delaware
4th place UpCity
BigCommerce development companies
55th place UpCity
Ecommerce development companies
1st place UpCity
Website development companies
5th place OpenCart
OpenCart experts
20th place DESIGNRUSH
Top web design companies in the USA
5th place DESIGNRUSH
Top design firms in the USA
5th place Top Developers
Top 10+ OpenCart development companies