Names
Data license: CC-By 4.0
2,552,121 rows sorted by name
This data as json, CSV (advanced)
These facets timed out: validFrom
Link | rowid | companyId | globalId | validFrom | name ▼ | validTill | isCurrent |
---|---|---|---|---|---|---|---|
120159 | 120159 | G1207_HRB12618FF | br_40859 | 2009-10-19 | True | ||
120179 | 120179 | G1207_HRB12793FF | br_43869 | 2010-01-21 | 2018-04-10 | False | |
120202 | 120202 | G1207_HRB12968FF | br_47907 | 2010-05-03 | True | ||
120206 | 120206 | G1207_HRB12972FF | br_47911 | 2010-05-05 | True | ||
120215 | 120215 | G1207_HRB13048FF | br_49870 | 2010-06-28 | True | ||
120242 | 120242 | G1207_HRB13215FF | br_53649 | 2010-10-18 | 2010-10-18 | False | |
120268 | 120268 | G1207_HRB13518FF | br_61427 | 2011-05-17 | True | ||
120295 | 120295 | G1207_HRB13758FF | br_66663 | 2011-10-20 | True | ||
120297 | 120297 | G1207_HRB13762FF-U1206_HRB27625 | br_66665 | 2011-10-21 | True | ||
120359 | 120359 | G1207_HRB14433FF-U1206_HRB33075 | br_114566 | 2015-03-26 | True | ||
120643 | 120643 | G1207_HRB17760FF | br_179913 | 2019-12-08 | 2022-06-10 | False | |
121336 | 121336 | G1309_HRB1048NP | br_94183 | 2013-08-21 | True | ||
121436 | 121436 | G1309_HRB11520NP | br_195719 | 2021-02-15 | True | ||
121483 | 121483 | G1309_HRB12020NP | br_185873 | 2020-06-25 | True | ||
121811 | 121811 | G1309_HRB3237NP-F1103_HRB163689B | be_314385 | 2014-12-22 | True | ||
122007 | 122007 | G1309_HRB6269NP-G1309_HRB6299NP-F1103_HRB148693B-G1103_HRB11793CB-G1312_HRB29008P | be_242115 | 2013-03-25 | True | ||
122425 | 122425 | G1309_HRB9444NP | br_112519 | 2015-02-03 | 2019-09-05 | False | |
122471 | 122471 | G1309_HRB9703NP-R2707_HRB16179 | br_76707 | 2012-08-14 | 2019-03-14 | False | |
122912 | 122912 | G1312_HRB15892P-F1103_HRB105071B | be_29725 | 2006-12-18 | True | ||
123497 | 123497 | G1312_HRB20875P-F1103_HRB153387B-V1109_HRB105912 | br_23002 | 2008-02-21 | 2013-10-14 | False | |
123736 | 123736 | G1312_HRB2279P | br_160950 | 2018-10-01 | True | ||
123930 | 123930 | G1312_HRB24428P | br_66895 | 2011-11-03 | 2011-11-08 | False | |
125315 | 125315 | G1312_HRB6200P-F1103_HRB130768B | be_204105 | 2012-04-12 | True | ||
125566 | 125566 | H1101_HRB11927HB | hb_15658 | 2009-10-08 | True | ||
125631 | 125631 | H1101_HRB13349HB-K1101_HRB107371 | hh_66015 | 2008-11-20 | 2013-07-23 | False | |
126365 | 126365 | H1101_HRB22843HB | hb_89333 | 2020-02-04 | True | ||
126502 | 126502 | H1101_HRB23995HB-B2609_HRB735859 | bw_221517 | 2010-12-15 | True | ||
126594 | 126594 | H1101_HRB2454BHV | hb_32018 | 2012-04-24 | True | ||
126626 | 126626 | H1101_HRB24791HB-P2716_HRB70416 | hb_6176 | 2008-04-22 | True | ||
126779 | 126779 | H1101_HRB25859HB | hb_15660 | 2009-10-08 | True | ||
126943 | 126943 | H1101_HRB26938HB | hb_24821 | 2011-03-16 | True | ||
127022 | 127022 | H1101_HRB2751BHV-K1101_HRB145861 | hb_17397 | 2010-01-04 | True | ||
127986 | 127986 | H1101_HRB34983HB | hb_99221 | 2021-06-28 | True | ||
127995 | 127995 | H1101_HRB3502BHV | hb_26482 | 2011-06-24 | True | ||
128087 | 128087 | H1101_HRB3569BHV | hb_35665 | 2012-11-16 | True | ||
128107 | 128107 | H1101_HRB35856HB | hb_92489 | 2020-07-31 | 2020-07-31 | False | |
128398 | 128398 | H1101_HRB37995HB | hb_105510 | 2022-05-13 | True | ||
128574 | 128574 | H1101_HRB5691BHV | hb_29563 | 2011-12-20 | True | ||
128583 | 128583 | H1101_HRB5727BHV | hb_31641 | 2012-04-02 | True | ||
128585 | 128585 | H1101_HRB5733BHV | hb_31754 | 2012-04-11 | True | ||
128589 | 128589 | H1101_HRB5765BHV | hb_33595 | 2012-07-24 | 2021-07-05 | False | |
128592 | 128592 | H1101_HRB5767BHV | hb_33752 | 2012-08-02 | 2012-12-06 | False | |
128598 | 128598 | H1101_HRB5785BHV | hb_34860 | 2012-10-02 | 2017-08-18 | False | |
128601 | 128601 | H1101_HRB5796BHV | hb_35314 | 2012-10-29 | True | ||
133057 | 133057 | K1101_HRB127125-P2613_HRB204769-F1103_HRB195329B | ni_323550 | 2014-12-01 | True | ||
133199 | 133199 | K1101_HRB128004-P2613_HRB208637 | ni_623822 | 2021-04-08 | True | ||
133882 | 133882 | K1101_HRB132900-X1517_HRB16823KI-K1101_HRB148625 | sh_217369 | 2017-10-30 | True | ||
135030 | 135030 | K1101_HRB140275 | hh_290441 | 2016-02-19 | True | ||
135821 | 135821 | K1101_HRB145817-F1103_HRB192688B | be_459931 | 2018-01-11 | True | ||
136617 | 136617 | K1101_HRB151676-B2609_HRB769593 | bw_744629 | 2019-05-29 | True | ||
142941 | 142941 | K1101_HRB75262-X1721_HRB19847HL-K1101_HRB163192 | sh_271083 | 2020-06-25 | True | ||
144322 | 144322 | K1101_HRB89468-X1517_HRB10269KI | sh_44289 | 2008-11-27 | True | ||
144819 | 144819 | K1101_HRB93430-F1103_HRB103834B | be_24998 | 2006-10-13 | True | ||
145097 | 145097 | K1101_HRB95386-X1721_HRB6651HL | sh_85525 | 2010-12-20 | True | ||
145786 | 145786 | K1101_HRB99172-X1517_HRB9855KI | sh_106359 | 2012-01-05 | True | ||
146043 | 146043 | M1103_HRB100946 | he_726725 | 2020-09-24 | 2020-09-24 | False | |
153437 | 153437 | M1201_HRB109171-F1103_HRB190322B | be_447988 | 2017-10-11 | True | ||
153993 | 153993 | M1201_HRB112920-B2609_HRB769511-B2609_HRB119220 | bw_743349 | 2019-05-22 | True | ||
154705 | 154705 | M1201_HRB118117-M1103_HRB100473-M1114_HRB52709 | he_708063 | 2020-05-20 | True | ||
155125 | 155125 | M1201_HRB121301-B8536_HRB724484 | bw_887854 | 2021-06-24 | True | ||
155521 | 155521 | M1201_HRB124358-M1607_HRB18922 | he_805064 | 2022-01-14 | True | ||
156249 | 156249 | M1201_HRB25355-F1103_HRB239555B | be_689043 | 2022-03-04 | True | ||
156864 | 156864 | M1201_HRB42119-M1103_HRB90330-M1706_HRB6502 | he_246366 | 2011-08-30 | True | ||
157119 | 157119 | M1201_HRB47038-D2601_HRB175208 | by_428112 | 2010-07-15 | True | ||
159351 | 159351 | M1201_HRB81503-B2609_HRB724772 | bw_50498 | 2007-12-06 | True | ||
159424 | 159424 | M1201_HRB81909-H1101_HRB5346BHV-H1101_HRB5346 | hb_11601 | 2009-02-04 | True | ||
159711 | 159711 | M1201_HRB83472-B8536_HRB702729 | bw_89973 | 2008-09-03 | 2008-09-11 | False | |
160088 | 160088 | M1201_HRB85995-P3210_HRB203741-D2601_HRB185297 | ni_101928 | 2009-09-29 | 2019-02-22 | False | |
160622 | 160622 | M1201_HRB89790-D4102_HRB12691-P2408_HRB205993 | by_739493 | 2013-12-02 | 2018-11-07 | False | |
162129 | 162129 | M1202_HRB11484 | he_227039 | 2011-03-29 | True | ||
162628 | 162628 | M1202_HRB8735-M1203_HRB7125-F1103_HRB120027B | be_98239 | 2009-06-04 | True | ||
162790 | 162790 | M1203_HRB10985-M1103_HRB102992 | he_807768 | 2022-01-27 | True | ||
163242 | 163242 | M1203_HRB8871 | he_397647 | 2014-08-25 | 2022-03-28 | False | |
164898 | 164898 | M1405_HRB9625 | he_832028 | 2022-06-22 | True | ||
169520 | 169520 | M1710_HRB2197-B2805_HRB735144-R2402_HRB30358 | bw_614064 | 2017-05-16 | True | ||
169754 | 169754 | M1710_HRB5561-M1406_HRB6288-P2507_HRB204105 | ni_237290 | 2012-12-17 | 2012-12-17 | False | |
170168 | 170168 | M1809_HRB1057 | he_722779 | 2020-08-31 | 2020-08-31 | False | |
170919 | 170919 | M1906_HRB12409-F1103_HRB124244B | be_121908 | 2010-02-04 | True | ||
173086 | 173086 | N1105_HRB1469 | mv_109629 | 2021-08-24 | 2022-02-11 | False | |
174044 | 174044 | N1206_HRB11924-X1721_HRB13663HL-X1721_HRB13663-X1517_HRB18949KI | sh_214287 | 2017-08-31 | 2020-04-08 | False | |
175940 | 175940 | N1308_HRB10911-N1206_HRB12707 | mv_48593 | 2013-09-18 | 2014-09-17 | False | |
177701 | 177701 | P1103_HRB203151-B8536_HRB712706 | bw_476737 | 2015-03-03 | True | ||
183639 | 183639 | P2305_HRB219050-P2507_HRB209557 | ni_623304 | 2021-04-01 | True | ||
184406 | 184406 | P2305_HRB54205-F1103_HRB157320B | be_283670 | 2014-03-26 | 2017-11-29 | False | |
188041 | 188041 | P2507_HRB206480-R2108_HRB17794 | ni_408655 | 2016-10-11 | True | ||
188398 | 188398 | P2507_HRB210594 | ni_685812 | 2022-06-20 | True | ||
188767 | 188767 | P2613_HRB111319-H1101_HRB5738BHV-D4708_HRB15007 | hb_31869 | 2012-04-17 | True | ||
188946 | 188946 | P2613_HRB121320 | ni_651251 | 2021-11-01 | True | ||
190006 | 190006 | P2613_HRB209434 | ni_680272 | 2022-05-05 | True | ||
192605 | 192605 | P3101_HRB203506-B2609_HRB756892 | bw_552395 | 2016-05-25 | True | ||
193604 | 193604 | P3210_HRB140014-H1101_HRB34966HB | hb_86751 | 2019-10-16 | True | ||
193919 | 193919 | P3210_HRB151636 | ni_167813 | 2011-04-27 | True | ||
195569 | 195569 | P3210_HRB212465 | ni_655608 | 2021-12-01 | True | ||
196659 | 196659 | P3313_HRB120137 | ni_637345 | 2021-07-13 | True | ||
200278 | 200278 | R1101_HRB22694-R1608_HRB20776-U1104_HRB32498 | sn_155380 | 2013-08-02 | True | ||
202663 | 202663 | R1101_HRB52395 | nw_848470 | 2012-10-24 | 2014-04-02 | False | |
202693 | 202693 | R1101_HRB52618-F1103_HRB101013B | be_10790 | 2006-03-15 | 2006-03-23 | False | |
203362 | 203362 | R1101_HRB56646-X1517_HRB9261KI | sh_24417 | 2007-09-13 | 2009-06-19 | False | |
207158 | 207158 | R1101_HRB83880-B2609_HRB765773 | bw_686322 | 2018-07-17 | 2018-07-17 | False | |
208261 | 208261 | R1101_HRB93417-F1103_HRB237567B | be_679754 | 2022-01-12 | True |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "Names" ( "companyId" varchar, "globalId" varchar, "validFrom" date, "name" varchar, "validTill" date, "isCurrent" boolean ); CREATE INDEX "NamesCompanyId" ON "Names" ( "companyId" );