Key Performance Indicators (KPIs)
Database Completeness
99.5%
Successfully indexed 3.78 million companies from KVK Handelsregister with high accuracy.
Achievements
Executive Summary
Addressed critical registration data gaps through KVK's official dump processing.
- Historical Backfill: 450k missing registrations identified and backfilled
- Deregistrations: 150k missing deregistrations updated and deactivated
- SBI 2025 migration: Updated all branches with new 2025 SBI codes
- Handelsdata API integration: Cheap branch processing
- Vestigingsprofiel API: Detailed branch profiles
Implementation Details
KVK Dump Processing & Missing Data Resolution
Context:
- Updated all SBI codes to 2025 classification using KVK's official dump (September 6, 2025)
- Identified two types of missing data: 450k missing registrations and 150k missing deregistrations
One-Time Setup Scripts (Executed Once in Order)
- force_all_requests.php --force_paid - Force SBI updates (legacy, before dump discovery)
- 06_update_sbi_from_kvk_conversion.php - Update SBI codes to 2025, detect missing registrations → bedrijf_nieuw
- 07_diff_sbi_kvk_with_cbs.php - Validate SBI names using 07_kvk_sbi.csv (909 definitions)
- check_missing_kvk_branches_from_source.php - Identify 150k missing deregistrations
- update_kvk_from_file.php - Bulk process deregistrations via free KVK endpoint
- add_missing_branches_from_csv_to_db.php - Verification script to ensure no missing branches remain (cross-check against CSV after all processes finished)
Infrastructure Costs
Monthly API Costs
- Handelsdata: €120/month (3 subscriptions, 300k credits total)
- KVK Basisprofiel/Vestigingsprofiel: €0.02 per request (up to 300k limit)
October 2024 One-Time Cost: €6,000
KVK API: 250k new companies + 20k Handelsdata failures + 30k quality verification
Handelsdata: 120k testing/verification + 180k missing companies