Skip to content

Instantly share code, notes, and snippets.

View PernilleMatthews's full-sized avatar
🏠
Working from home

Pernille Matthews PernilleMatthews

🏠
Working from home
View GitHub Profile
@PernilleMatthews
PernilleMatthews / aggregated_zip_codes.csv
Last active December 1, 2021 09:46
Aggregated companies per zip code
postnummer count postdistrikt
1050 57 København K
1051 93 København K
1052 20 København K
1053 9 København K
1054 15 København K
1055 27 København K
1056 3 København K
1057 47 København K
1058 77 København K
@PernilleMatthews
PernilleMatthews / aggregated_counties.csv
Last active December 4, 2021 12:14
Total amount of companies per county
kommune_kode count kommune_navn region_navn regionkode
101 19054 KØBENHAVN Region Hovedstaden 1084
147 3064 FREDERIKSBERG Region Hovedstaden 1084
151 1108 BALLERUP Region Hovedstaden 1084
153 794 BRØNDBY Region Hovedstaden 1084
155 502 DRAGØR Region Hovedstaden 1084
157 4304 GENTOFTE Region Hovedstaden 1084
159 1575 GLADSAXE Region Hovedstaden 1084
161 578 GLOSTRUP Region Hovedstaden 1084
163 852 HERLEV Region Hovedstaden 1084
@PernilleMatthews
PernilleMatthews / dkregions.json
Last active December 3, 2021 12:31
Denmarks regions
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@PernilleMatthews
PernilleMatthews / regions_kode_count.csv
Created December 2, 2021 14:11
Industries aggregated per region
regionkode count
1081 12729
1082 35873
1083 22758
1084 53868
1085 17793
@PernilleMatthews
PernilleMatthews / dktopo.json
Created December 3, 2021 11:49
TopoJSON of Denmark
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@PernilleMatthews
PernilleMatthews / municipalities_count_agg.csv
Last active December 7, 2021 09:53
Aggregated count of industries per municipalities and total
kommune_kode all 81 96 43 35 46 68 26 62 90 1 69 84 56 64 97 8 86 49 85 36
101 19054 787 226.0 574 33.0 1725 1689 373 2188.0 235.0 23.0 2608 5.0 882 6858 1.0 9.0 322.0 304.0 198.0 14.0
147 3064 95 44.0 101 6.0 258 271 42 262.0 39.0 1.0 489 0.0 101 1235 0.0 1.0 56.0 26.0 37.0 0.0
151 1108 54 16.0 106 0.0 174 69 54 101.0 6.0 1.0 96 0.0 18 348 0.0 1.0 18.0 33.0 11.0 2.0
153 794 54 8.0 63 0.0 133 53 42 39.0 4.0 3.0 77 1.0 15 238 0.0 1.0 10.0 45.0 6.0 2.0
155 502 14 4.0 28 0.0 66 28 9 33.0 2.0 1.0 63 0.0 15 219 0.0 0.0 4.0 10.0 3.0 3.0
157 4304 152 43.0 129 9.0 331 349 87 300.0 17.0 6.0 699 4.0 75 1909 0.0 1.0 104.0 56.0 33.0 0.0
159 1575 71 15.0 143 33.0 193 99 33 126.0 10.0 2.0 180 0.0 37 534 0.0 0.0 23.0 58.0 18.0 0.0
161 578 28 10.0 77 1.0 92 37 16 34.0 3.0 1.0 44 0.0 15 184 0.0 0.0 10.0 19.0 2.0 5.0
163 852 55 14.0 88 0.0 120 49 38 84.0 9.0 0.0 86 0.0 20 230 0.0 0.0 20.0 30.0 6.0 3.0
@PernilleMatthews
PernilleMatthews / municipalities_mean_profit_agg.csv
Last active December 5, 2021 15:45
Average profit per municipality and total
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 22 columns, instead of 11. in line 3.
kommune kode,total_mean,mean_81,mean_96,mean_43,mean_35,mean_46,mean_68,mean_26,mean_62,mean_90,mean_1,mean_69,mean_84,mean_56,mean_64,mean_97,mean_8,mean_86,mean_49,mean_85,mean_36
101,2551959.691660544,164218.44570520968,70947.96017699115,2008307.5954703833,5112046.1851515155,5123873.402898551,4928557.754754293,737543.1763270777,51965.83741316268,662173.5574468086,-238991.1739130435,310555.9442561349,-180027.8,-734956.4342403628,4614691.533724118,0.0,1828716.5177777777,779921.4161490683,-9274550.02680921,403243.85353535356,8574304.642857144
147,1545353.6761847257,945702.5789473684,343146.79545454547,848006.3861386139,-4648673.333333333,190803.61627906977,9222183.693726936,277773.2380952381,240251.2748091603,1605320.6923076923,183405.0,1066227.8711656441,0.0,447418.8415841584,1047554.7358947368,0.0,0.0,410760.1785714286,36022.0,58933.67567567567,0.0
151,912756.2563176895,382181.24074074073,307395.75,506296.1320754717,0.0,-30625.545977011494,8939155.231884059,-110942.25925925926,2448436.792079208,-109992.3333
@PernilleMatthews
PernilleMatthews / regions_count_aggregated.csv
Last active January 19, 2022 19:13
Regions count of industries total and per industry
main_group region_eng count
Trade and transport Zealand 2903
Financing Capital 20125
Industry, raw material, supply Capital 1662
Financing Central Jutland 13496
Culture, leisure, other service Capital 1103
Professional service Capital 9290
Financing South Denmark 10336
Trade and transport Capital 8642
Financing Zealand 6210
@PernilleMatthews
PernilleMatthews / regions_mean_profit_aggregations.csv
Last active December 5, 2021 15:49
Total and industry based profit per region
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 22 columns, instead of 8. in line 3.
regionskode,total_mean,mean_81,mean_96,mean_43,mean_35,mean_46,mean_68,mean_26,mean_62,mean_90,mean_1,mean_69,mean_84,mean_56,mean_64,mean_97,mean_8,mean_86,mean_49,mean_85,mean_36
1081,1251601.6114840128,760471.4666666667,-62016.80952380953,443873.63187855785,2114109.596756757,987995.3405409253,1123679.820886076,2199765.475378422,280453.3325415677,1060263.3152173914,1750338.0623145401,1707925.788748565,70854.0,132344.16949152542,1446869.3729639384,0.0,1742389.8333333333,1404776.6987179487,722270.1814814815,1333.22,16481611.032258065
1082,1376113.7013886422,552301.0844088177,241701.14285714287,803830.7653367653,2697765.1181203006,1628914.7255537633,1189901.900851711,3995820.8763578944,664366.5415781487,360694.3947368421,620461.0922580645,962106.168697997,611631.75,38198.25093632959,1552345.9409632485,-79393.0,719295.4444444445,472798.22162162163,878446.3392539965,97316.7435897436,3620948.8444444444
1083,1645439.1357078487,825100.8504176072,56216.44976076555,697389.3979112272,14394298.5,1017033.9589394424,1027
@PernilleMatthews
PernilleMatthews / complete_data_danish_companies.csv
Last active December 6, 2021 15:41
Complete data for Danish Companies 20-21
We can't make this file beautiful and searchable because it's too large.
cvr,enhedstype,hovedgruppe,hovedgruppe navn,postnummer,postdistrikt,kommune kode,kommune navn,landekode,profit,currency,decimals,profit_conv,regionskode,regionsnavn
19556689,VIRKSOMHED,46,Engrosh. og detailh.- rep. af motorkør. og motorcykler.,4622,Havdrup,269,SOLRØD,DK,0.0,u0,0.0,0.0,1085,Region Sjaelland
12809239,VIRKSOMHED,64,Pengeinstitut- og finansvirksomhed mv,2665,Vallensbæk Strand,187,VALLENSBÆK,DK,160210.0,u3,0.0,160210.0,1084,Region Hovedstaden
40875093,VIRKSOMHED,26,Fremstillingsvirksomhed,2950,Vedbæk,230,RUDERSDAL,DK,28493.0,u3,0.0,28493.0,1084,Region Hovedstaden
37755303,VIRKSOMHED,64,Pengeinstitut- og finansvirksomhed mv,8381,Tilst,751,AARHUS,DK,-13387.0,DKK,0.0,-13387.0,1082,Region Midtjylland
39201704,VIRKSOMHED,64,Pengeinstitut- og finansvirksomhed mv,3500,Værløse,190,FURESØ,DK,-2021.0,vDKK,0.0,-2021.0,1084,Region Hovedstaden
36049596,VIRKSOMHED,96,Andre serviceydelser,2640,Hedehusene,169,HØJE TAASTRUP,DK,-10303.0,u0,0.0,-10303.0,1084,Region Hovedstaden
38830791,VIRKSOMHED,64,Pengeinstitut- o