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
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,main_group,region_eng
19556689,VIRKSOMHED,46,Handel og transport mv.,4622,Havdrup,269,SOLRØD,DK,0.0,u0,0.0,0.0,1085,Region Sjaelland,Trade and transport,Zealand
12809239,VIRKSOMHED,64,Finansiering og forsikring,2665,Vallensbæk Strand,187,VALLENSBÆK,DK,160210.0,u3,0.0,160210.0,1084,Region Hovedstaden,Financing,Capital
40875093,VIRKSOMHED,26,"Industri, råstoffer, forsyning",2950,Vedbæk,230,RUDERSDAL,DK,28493.0,u3,0.0,28493.0,1084,Region Hovedstaden,"Industry, raw material, supply",Capital
37755303,VIRKSOMHED,64,Finansiering og forsikring,8381,Tilst,751,AARHUS,DK,-13387.0,DKK,0.0,-13387.0,1082,Region Midtjylland,Financing,Central Jutland
39201704,VIRKSOMHED,64,Finansiering og forsikring,3500,Værløse,190,FURESØ,DK,-2021.0,vDKK,0.0,-2021.0,1084,Region Hovedstaden,Financing,Capital
36049596,VIRKSOMHED,96,"Kultur, forlystelser og sport",2640,Hede
@PernilleMatthews
PernilleMatthews / aggregate_industries_profit_per_county.csv
Last active December 15, 2021 23:03
Aggregate industries profit per county
hovedgruppe navn kommune navn profit count mean
Engrosh. og detailh.- rep. af motorkør. og motorcykler. SOLRØD 0.0 161447.9705882353 0.0
Pengeinstitut- og finansvirksomhed mv VALLENSBÆK 160210.0 1551091.4074074074 0.16021
Fremstillingsvirksomhed RUDERSDAL 28493.0 2990543.212121212 0.028493
Pengeinstitut- og finansvirksomhed mv AARHUS -13387.0 1572491.6315662651 -0.013387
Pengeinstitut- og finansvirksomhed mv FURESØ -2021.0 686007.0170777988 -0.002021
Andre serviceydelser HØJE TAASTRUP -10303.0 86221.14285714286 -0.010303
Pengeinstitut- og finansvirksomhed mv KØBENHAVN -7022.0 4527088.056867892 -0.007022
Liberale, videnskabelige og tekniske tjenesteydelser KØBENHAVN -50076.0 461202.6848159509 -0.050076
Pengeinstitut- og finansvirksomhed mv ÆRØ 17504.0 142053.23076923078 0.017504
@PernilleMatthews
PernilleMatthews / counties_geojson.json
Created December 7, 2021 20:49
Counties of Denmark in geoJSON
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@PernilleMatthews
PernilleMatthews / regioner_geo.json
Created December 7, 2021 20:48
Regions of Denmark in geoJSON format
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@PernilleMatthews
PernilleMatthews / topojson.json
Last active December 6, 2021 08:58
Topojson with multipolygons
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@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
@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 / 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 / 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 / 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