Last active
November 21, 2022 12:21
-
-
Save petervandenabeele/62853ff3bcdd09132bf7 to your computer and use it in GitHub Desktop.
Some quick stats from the Belgian Open Data Company Registry
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Open data (license only in French) about Belgian registered companies from: | |
https://kbopub.economie.fgov.be/kbo-open-data | |
Top 10 email domains of the contact persons in the data set: | |
➜ KboOpenData_0001_2014_05_Full grep EMAIL contact.csv | cut -d@ -f2 | cut -d\" -f1 | sort | uniq -c | sort -rn | head -10 | |
14215 hotmail.com | |
10758 gmail.com | |
10190 skynet.be | |
8524 telenet.be | |
1471 yahoo.fr | |
1319 pandora.be | |
1296 yahoo.com | |
1008 live.be | |
897 hotmail.be | |
849 scarlet.be | |
Number of companies started since 2000 (oldest start dates are way older then the year 1800) | |
➜ KboOpenData_0001_2014_05_Full less establishment.csv | cut -d, -f2 | cut -d- -f3 | sort -n | uniq -c | tail -15 | |
28384 2000 | |
29839 2001 | |
33105 2002 | |
34985 2003 | |
31989 2004 | |
36690 2005 | |
46371 2006 | |
54253 2007 | |
60393 2008 | |
55329 2009 | |
65225 2010 | |
71991 2011 | |
73290 2012 | |
79238 2013 | |
31348 2014 | |
Number of companies per Juridical Form | |
➜ KboOpenData_0001_2014_05_Full cut -d, -f4,5 enterprise.csv | grep \"2 | cut -d, -f2 | sort | uniq -c | sort -rn | head -10 | |
351537 "015" # BVBA | |
133599 "017" # VZW | |
118572 "014" # NV | |
68056 "070" | |
35385 "030" | |
35136 "010" # EBVBA | |
31595 "215" # BVBVBA | |
24451 "012" # GCV | |
19025 "016" # CV | |
16382 "011" # VOF | |
➜ KboOpenData_0001_2014_05_Full less code.csv | grep NL | grep JuridicalForm | egrep '((015)|(017)|(014)|(070)|(030)|(010)|(215)|(012)|(016)|(011))' | cut -d, -f2,4 | |
"010","Eenmans besloten vennootschap met beperkte aansprakelijkheid" | |
"011","Vennootschap onder firma" | |
"012","Gewone commanditaire vennootschap" | |
"014","Naamloze vennootschap" | |
"015","Besloten vennootschap met beperkte aansprakelijkheid" | |
"016","Coöperatieve vennootschap (oud statuut)" | |
"017","Vereniging zonder winstoogmerk" | |
"030","Buitenlandse onderneming" | |
"070","Vereniging van mede-eigenaars" | |
"215","Burgerlijke vennootschap onder vorm van besloten vennootschap met beperkte aansprakelijkheid" | |
➜ KboOpenData_0001_2014_05_Full |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hi Peter,
By chance did you keep some of these KBO files (KboOpenData_xx.zip) ? I am trying to get them but unfortunately on the kbopub.economie.fgov.be official website only the last five months are available (currently from KboOpenData_0101_2022_07_Full.zip to KboOpenData_0105_2022_11_Full.zip).