ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by nativeReferenceNumber
This data as json, CSV (advanced)
Link | rowid | companyId | stdRefNo | nativeReferenceNumber ▼ | courtName | courtCode | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
1744911 | 1744911 | R3101_HRB10131 | R3101_HRB10131 | Aachen HRB 10131 | Aachen | R3101 | 2005-09-19 | |
1744912 | 1744912 | R3101_HRB10132 | R3101_HRB10132 | Aachen HRB 10132 | Aachen | R3101 | 2016-01-14 | |
1451336 | 1451336 | R3101_HRB10133 | R3101_HRB10133 | Aachen HRB 10133 | Aachen | R3101 | 2005-02-14 | |
545316 | 545316 | R3101_HRB10134 | R3101_HRB10134 | Aachen HRB 10134 | Aachen | R3101 | 2010-10-07 | |
850099 | 850099 | R3101_HRB10135 | R3101_HRB10135 | Aachen HRB 10135 | Aachen | R3101 | 2012-02-06 | |
2037463 | 2037463 | R3101_HRB10137 | R3101_HRB10137 | Aachen HRB 10137 | Aachen | R3101 | 2008-12-18 | |
545317 | 545317 | R3101_HRB10138 | R3101_HRB10138 | Aachen HRB 10138 | Aachen | R3101 | 2007-08-03 | |
2037464 | 2037464 | R3101_HRB10140 | R3101_HRB10140 | Aachen HRB 10140 | Aachen | R3101 | 2016-02-11 | |
2329724 | 2329724 | R3101_HRB10141-R1504_HRB16038 | R3101_HRB10141 | Aachen HRB 10141 | Aachen | R3101 | 2008-10-14 | 2014-05-05 |
2037465 | 2037465 | R3101_HRB10142 | R3101_HRB10142 | Aachen HRB 10142 | Aachen | R3101 | 2006-01-04 | |
240973 | 240973 | R3101_HRB10143 | R3101_HRB10143 | Aachen HRB 10143 | Aachen | R3101 | 2007-10-19 | |
850100 | 850100 | R3101_HRB10144 | R3101_HRB10144 | Aachen HRB 10144 | Aachen | R3101 | 2007-10-23 | |
2037466 | 2037466 | R3101_HRB10145 | R3101_HRB10145 | Aachen HRB 10145 | Aachen | R3101 | 2006-10-19 | |
240974 | 240974 | R3101_HRB10146 | R3101_HRB10146 | Aachen HRB 10146 | Aachen | R3101 | 2021-05-05 | |
1451337 | 1451337 | R3101_HRB10149 | R3101_HRB10149 | Aachen HRB 10149 | Aachen | R3101 | 2016-01-13 | |
1155048 | 1155048 | R3101_HRB1015 | R3101_HRB1015 | Aachen HRB 1015 | Aachen | R3101 | 2021-10-20 | |
1451338 | 1451338 | R3101_HRB10150 | R3101_HRB10150 | Aachen HRB 10150 | Aachen | R3101 | 2005-02-24 | |
850101 | 850101 | R3101_HRB10151 | R3101_HRB10151 | Aachen HRB 10151 | Aachen | R3101 | 2007-01-17 | |
1451339 | 1451339 | R3101_HRB10152 | R3101_HRB10152 | Aachen HRB 10152 | Aachen | R3101 | 2016-01-19 | |
1451340 | 1451340 | R3101_HRB10153 | R3101_HRB10153 | Aachen HRB 10153 | Aachen | R3101 | 2007-10-11 | |
1155049 | 1155049 | R3101_HRB10154 | R3101_HRB10154 | Aachen HRB 10154 | Aachen | R3101 | 2009-03-19 | |
2329726 | 2329726 | R3101_HRB10155 | R3101_HRB10155 | Aachen HRB 10155 | Aachen | R3101 | 2005-05-18 | |
1451341 | 1451341 | R3101_HRB10156 | R3101_HRB10156 | Aachen HRB 10156 | Aachen | R3101 | 2005-07-13 | |
1451342 | 1451342 | R3101_HRB10157 | R3101_HRB10157 | Aachen HRB 10157 | Aachen | R3101 | 2005-04-20 | |
850102 | 850102 | R3101_HRB10158 | R3101_HRB10158 | Aachen HRB 10158 | Aachen | R3101 | 2007-07-27 | |
545318 | 545318 | R3101_HRB10159 | R3101_HRB10159 | Aachen HRB 10159 | Aachen | R3101 | 2006-01-05 | |
1451343 | 1451343 | R3101_HRB10160 | R3101_HRB10160 | Aachen HRB 10160 | Aachen | R3101 | 2021-01-12 | |
2329727 | 2329727 | R3101_HRB10164 | R3101_HRB10164 | Aachen HRB 10164 | Aachen | R3101 | 2005-11-11 | |
2037467 | 2037467 | R3101_HRB10165 | R3101_HRB10165 | Aachen HRB 10165 | Aachen | R3101 | 2009-06-24 | |
1451344 | 1451344 | R3101_HRB10166 | R3101_HRB10166 | Aachen HRB 10166 | Aachen | R3101 | 2016-12-08 | |
850103 | 850103 | R3101_HRB10167 | R3101_HRB10167 | Aachen HRB 10167 | Aachen | R3101 | 2005-06-16 | |
1169085 | 1169085 | R3306_HRB67565-R3101_HRB10170 | R3101_HRB10170 | Aachen HRB 10170 | Aachen | R3101 | 2009-11-11 | |
545319 | 545319 | R3101_HRB10171 | R3101_HRB10171 | Aachen HRB 10171 | Aachen | R3101 | 2006-06-09 | |
2037468 | 2037468 | R3101_HRB10172 | R3101_HRB10172 | Aachen HRB 10172 | Aachen | R3101 | 2006-07-27 | |
1744913 | 1744913 | R3101_HRB10174 | R3101_HRB10174 | Aachen HRB 10174 | Aachen | R3101 | 2013-01-08 | |
2037469 | 2037469 | R3101_HRB10175 | R3101_HRB10175 | Aachen HRB 10175 | Aachen | R3101 | 2004-12-30 | |
240975 | 240975 | R3101_HRB10176 | R3101_HRB10176 | Aachen HRB 10176 | Aachen | R3101 | 2014-01-23 | |
240976 | 240976 | R3101_HRB10178-R1304_HRB15001 | R3101_HRB10178 | Aachen HRB 10178 | Aachen | R3101 | 2006-09-22 | 2017-11-29 |
2329728 | 2329728 | R3101_HRB10180 | R3101_HRB10180 | Aachen HRB 10180 | Aachen | R3101 | 2022-01-03 | |
1744914 | 1744914 | R3101_HRB10182 | R3101_HRB10182 | Aachen HRB 10182 | Aachen | R3101 | 2014-07-08 | |
2037470 | 2037470 | R3101_HRB10183 | R3101_HRB10183 | Aachen HRB 10183 | Aachen | R3101 | 2016-09-06 | |
2037471 | 2037471 | R3101_HRB10184 | R3101_HRB10184 | Aachen HRB 10184 | Aachen | R3101 | 2009-11-24 | |
240978 | 240978 | R3101_HRB10185 | R3101_HRB10185 | Aachen HRB 10185 | Aachen | R3101 | 2018-01-29 | |
850104 | 850104 | R3101_HRB10187 | R3101_HRB10187 | Aachen HRB 10187 | Aachen | R3101 | 2019-03-21 | |
1744915 | 1744915 | R3101_HRB10188 | R3101_HRB10188 | Aachen HRB 10188 | Aachen | R3101 | 2015-01-19 | |
545321 | 545321 | R3101_HRB10189-R1101_HRB65766-R1608_HRB28500 | R3101_HRB10189 | Aachen HRB 10189 | Aachen | R3101 | 2011-06-07 | 2017-11-09 |
240979 | 240979 | R3101_HRB10190 | R3101_HRB10190 | Aachen HRB 10190 | Aachen | R3101 | 2015-10-15 | |
2329729 | 2329729 | R3101_HRB10191-R1101_HRB96180 | R3101_HRB10191 | Aachen HRB 10191 | Aachen | R3101 | 2007-10-31 | 2022-01-21 |
850105 | 850105 | R3101_HRB10192 | R3101_HRB10192 | Aachen HRB 10192 | Aachen | R3101 | 2011-12-19 | |
1155050 | 1155050 | R3101_HRB10193 | R3101_HRB10193 | Aachen HRB 10193 | Aachen | R3101 | 2007-01-09 | |
2329731 | 2329731 | R3101_HRB10196-R2713_HRB15128 | R3101_HRB10196 | Aachen HRB 10196 | Aachen | R3101 | 2008-11-21 | 2014-08-28 |
1744916 | 1744916 | R3101_HRB10197-R3103_HRB8348 | R3101_HRB10197 | Aachen HRB 10197 | Aachen | R3101 | 2005-06-23 | 2020-04-23 |
1744918 | 1744918 | R3101_HRB10199 | R3101_HRB10199 | Aachen HRB 10199 | Aachen | R3101 | 2009-10-21 | |
545323 | 545323 | R3101_HRB10200 | R3101_HRB10200 | Aachen HRB 10200 | Aachen | R3101 | 2006-06-26 | |
2329733 | 2329733 | R3101_HRB10201 | R3101_HRB10201 | Aachen HRB 10201 | Aachen | R3101 | 2010-08-09 | |
1451345 | 1451345 | R3101_HRB10202 | R3101_HRB10202 | Aachen HRB 10202 | Aachen | R3101 | 2007-11-12 | |
850106 | 850106 | R3101_HRB10203 | R3101_HRB10203 | Aachen HRB 10203 | Aachen | R3101 | 2005-04-15 | |
240980 | 240980 | R3101_HRB10204 | R3101_HRB10204 | Aachen HRB 10204 | Aachen | R3101 | 2005-06-09 | |
545324 | 545324 | R3101_HRB10206 | R3101_HRB10206 | Aachen HRB 10206 | Aachen | R3101 | 2005-10-27 | |
1744919 | 1744919 | R3101_HRB10207-B2609_HRB783435 | R3101_HRB10207 | Aachen HRB 10207 | Aachen | R3101 | 2006-05-18 | 2022-02-15 |
545325 | 545325 | R3101_HRB10208 | R3101_HRB10208 | Aachen HRB 10208 | Aachen | R3101 | 2006-04-05 | |
2037472 | 2037472 | R3101_HRB10209 | R3101_HRB10209 | Aachen HRB 10209 | Aachen | R3101 | 2012-08-15 | |
1451346 | 1451346 | R3101_HRB10211 | R3101_HRB10211 | Aachen HRB 10211 | Aachen | R3101 | 2020-05-28 | |
1155051 | 1155051 | R3101_HRB10213 | R3101_HRB10213 | Aachen HRB 10213 | Aachen | R3101 | 2006-07-20 | |
2329734 | 2329734 | R3101_HRB10214 | R3101_HRB10214 | Aachen HRB 10214 | Aachen | R3101 | 2013-12-12 | |
850107 | 850107 | R3101_HRB10215 | R3101_HRB10215 | Aachen HRB 10215 | Aachen | R3101 | 2008-01-10 | |
1451347 | 1451347 | R3101_HRB10216 | R3101_HRB10216 | Aachen HRB 10216 | Aachen | R3101 | 2008-07-16 | |
850108 | 850108 | R3101_HRB10217 | R3101_HRB10217 | Aachen HRB 10217 | Aachen | R3101 | 2010-04-20 | |
850109 | 850109 | R3101_HRB1022 | R3101_HRB1022 | Aachen HRB 1022 | Aachen | R3101 | 2007-05-03 | |
1155052 | 1155052 | R3101_HRB10220-R1101_HRB96192 | R3101_HRB10220 | Aachen HRB 10220 | Aachen | R3101 | 2005-05-03 | 2022-01-21 |
240981 | 240981 | R3101_HRB10222 | R3101_HRB10222 | Aachen HRB 10222 | Aachen | R3101 | 2005-10-14 | |
2329735 | 2329735 | R3101_HRB10223 | R3101_HRB10223 | Aachen HRB 10223 | Aachen | R3101 | 2009-03-06 | |
1744921 | 1744921 | R3101_HRB10224-R2713_HRB15140 | R3101_HRB10224 | Aachen HRB 10224 | Aachen | R3101 | 2008-11-25 | 2014-09-02 |
1155054 | 1155054 | R3101_HRB10225 | R3101_HRB10225 | Aachen HRB 10225 | Aachen | R3101 | 2012-03-29 | |
240982 | 240982 | R3101_HRB10226 | R3101_HRB10226 | Aachen HRB 10226 | Aachen | R3101 | 2007-04-27 | |
2329736 | 2329736 | R3101_HRB10227 | R3101_HRB10227 | Aachen HRB 10227 | Aachen | R3101 | 2006-09-19 | |
1451348 | 1451348 | R3101_HRB10228 | R3101_HRB10228 | Aachen HRB 10228 | Aachen | R3101 | 2017-06-06 | |
1451349 | 1451349 | R3101_HRB10229 | R3101_HRB10229 | Aachen HRB 10229 | Aachen | R3101 | 2005-03-04 | |
240983 | 240983 | R3101_HRB10230 | R3101_HRB10230 | Aachen HRB 10230 | Aachen | R3101 | 2005-02-23 | |
1451350 | 1451350 | R3101_HRB10231 | R3101_HRB10231 | Aachen HRB 10231 | Aachen | R3101 | 2017-03-09 | |
1155055 | 1155055 | R3101_HRB10232 | R3101_HRB10232 | Aachen HRB 10232 | Aachen | R3101 | 2010-05-21 | |
1155056 | 1155056 | R3101_HRB10233 | R3101_HRB10233 | Aachen HRB 10233 | Aachen | R3101 | 2009-01-13 | |
1451351 | 1451351 | R3101_HRB10234 | R3101_HRB10234 | Aachen HRB 10234 | Aachen | R3101 | 2006-08-23 | |
545326 | 545326 | R3101_HRB10235 | R3101_HRB10235 | Aachen HRB 10235 | Aachen | R3101 | 2009-07-29 | |
1155057 | 1155057 | R3101_HRB10236 | R3101_HRB10236 | Aachen HRB 10236 | Aachen | R3101 | 2007-06-28 | |
545327 | 545327 | R3101_HRB10239 | R3101_HRB10239 | Aachen HRB 10239 | Aachen | R3101 | 2006-04-07 | |
2037473 | 2037473 | R3101_HRB10240 | R3101_HRB10240 | Aachen HRB 10240 | Aachen | R3101 | 2007-05-07 | |
1451352 | 1451352 | R3101_HRB10241 | R3101_HRB10241 | Aachen HRB 10241 | Aachen | R3101 | 2009-08-13 | |
2329737 | 2329737 | R3101_HRB10243 | R3101_HRB10243 | Aachen HRB 10243 | Aachen | R3101 | 2012-01-04 | |
240984 | 240984 | R3101_HRB10246 | R3101_HRB10246 | Aachen HRB 10246 | Aachen | R3101 | 2006-06-28 | |
850110 | 850110 | R3101_HRB10247 | R3101_HRB10247 | Aachen HRB 10247 | Aachen | R3101 | 2014-01-27 | |
1155058 | 1155058 | R3101_HRB10248 | R3101_HRB10248 | Aachen HRB 10248 | Aachen | R3101 | 2005-12-23 | |
2329738 | 2329738 | R3101_HRB10249 | R3101_HRB10249 | Aachen HRB 10249 | Aachen | R3101 | 2007-07-20 | |
1155059 | 1155059 | R3101_HRB10250 | R3101_HRB10250 | Aachen HRB 10250 | Aachen | R3101 | 2010-12-03 | |
1744923 | 1744923 | R3101_HRB10252 | R3101_HRB10252 | Aachen HRB 10252 | Aachen | R3101 | 2008-09-10 | |
240985 | 240985 | R3101_HRB10253 | R3101_HRB10253 | Aachen HRB 10253 | Aachen | R3101 | 2020-01-31 | |
1155060 | 1155060 | R3101_HRB10256 | R3101_HRB10256 | Aachen HRB 10256 | Aachen | R3101 | 2014-03-24 | |
850111 | 850111 | R3101_HRB10259 | R3101_HRB10259 | Aachen HRB 10259 | Aachen | R3101 | 2007-04-26 | |
1155061 | 1155061 | R3101_HRB10260 | R3101_HRB10260 | Aachen HRB 10260 | Aachen | R3101 | 2009-10-12 | |
850112 | 850112 | R3101_HRB10264 | R3101_HRB10264 | Aachen HRB 10264 | Aachen | R3101 | 2005-12-20 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "ReferenceNumbers" ( "companyId" varchar, "stdRefNo" varchar, "nativeReferenceNumber" varchar, "courtName" varchar, "courtCode" varchar, "referenceNumberFirstSeen" date, "validTill" date ); CREATE INDEX "RefNocompanyId" ON "ReferenceNumbers" ( "companyId" );