ReferenceNumbers

Data license: CC-By 4.0

2,440,122 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ companyId stdRefNo nativeReferenceNumber courtName courtCode referenceNumberFirstSeen validTill
101 101 B1601_HRB102544 B1601_HRB102544 Mannheim HRB 102544 Mannheim B1601 2009-02-19  
102 102 B1601_HRB102559 B1601_HRB102559 Mannheim HRB 102559 Mannheim B1601 2009-06-29  
103 103 B1601_HRB10256 B1601_HRB10256 Mannheim HRB 10256 Mannheim B1601 2010-10-01  
104 104 B1601_HRB102574 B1601_HRB102574 Mannheim HRB 102574 Mannheim B1601 2014-10-23  
105 105 B1601_HRB102600 B1601_HRB102600 Mannheim HRB 102600 Mannheim B1601 2009-04-07  
106 106 B1601_HRB102610 B1601_HRB102610 Mannheim HRB 102610 Mannheim B1601 2010-09-21  
107 107 B1601_HRB10262 B1601_HRB10262 Mannheim HRB 10262 Mannheim B1601 2006-12-21  
108 108 B1601_HRB10263 B1601_HRB10263 Mannheim HRB 10263 Mannheim B1601 2010-03-05  
109 109 B1601_HRB102632 B1601_HRB102632 Mannheim HRB 102632 Mannheim B1601 2007-01-08  
110 110 B1601_HRB102635 B1601_HRB102635 Mannheim HRB 102635 Mannheim B1601 2019-10-21  
111 111 B1601_HRB102637 B1601_HRB102637 Mannheim HRB 102637 Mannheim B1601 2008-01-21  
112 112 B1601_HRB102679 B1601_HRB102679 Mannheim HRB 102679 Mannheim B1601 2007-08-23  
113 113 B1601_HRB10268 B1601_HRB10268 Mannheim HRB 10268 Mannheim B1601 2010-07-29  
114 114 B1601_HRB102709 B1601_HRB102709 Mannheim HRB 102709 Mannheim B1601 2013-01-18  
115 115 B1601_HRB102777 B1601_HRB102777 Mannheim HRB 102777 Mannheim B1601 2010-02-16  
116 116 B1601_HRB102796 B1601_HRB102796 Mannheim HRB 102796 Mannheim B1601 2011-06-06  
117 117 B1601_HRB102808 B1601_HRB102808 Mannheim HRB 102808 Mannheim B1601 2007-03-27  
118 118 B1601_HRB102828 B1601_HRB102828 Mannheim HRB 102828 Mannheim B1601 2007-08-10  
119 119 B1601_HRB102865 B1601_HRB102865 Mannheim HRB 102865 Mannheim B1601 2012-07-25  
120 120 B1601_HRB102879 B1601_HRB102879 Mannheim HRB 102879 Mannheim B1601 2011-03-08  
121 121 B1601_HRB10293 B1601_HRB10293 Mannheim HRB 10293 Mannheim B1601 2007-11-06  
122 122 B1601_HRB102942 B1601_HRB102942 Mannheim HRB 102942 Mannheim B1601 2009-03-24  
123 123 B1601_HRB102990 B1601_HRB102990 Mannheim HRB 102990 Mannheim B1601 2012-04-24  
124 124 B1601_HRB10304 B1601_HRB10304 Mannheim HRB 10304 Mannheim B1601 2007-08-20  
125 125 B1601_HRB103055 B1601_HRB103055 Mannheim HRB 103055 Mannheim B1601 2022-04-26  
126 126 B1601_HRB103062 B1601_HRB103062 Mannheim HRB 103062 Mannheim B1601 2011-01-24  
127 127 B1601_HRB10311 B1601_HRB10311 Mannheim HRB 10311 Mannheim B1601 2008-01-31  
128 128 B1601_HRB103116 B1601_HRB103116 Mannheim HRB 103116 Mannheim B1601 2009-02-04  
129 129 B1601_HRB103195 B1601_HRB103195 Mannheim HRB 103195 Mannheim B1601 2013-06-26  
130 130 B1601_HRB10323-P2305_HRB204367 B1601_HRB10323 Mannheim HRB 10323 Mannheim B1601 2008-11-20 2009-06-26
131 131 B1601_HRB10323-P2305_HRB204367 P2305_HRB204367 Hannover HRB 204367 Hannover P2305 2009-06-26  
132 132 B1601_HRB103230 B1601_HRB103230 Mannheim HRB 103230 Mannheim B1601 2012-05-09  
133 133 B1601_HRB10324 B1601_HRB10324 Mannheim HRB 10324 Mannheim B1601 2009-03-18  
134 134 B1601_HRB103255 B1601_HRB103255 Mannheim HRB 103255 Mannheim B1601 2012-11-19  
135 135 B1601_HRB103265 B1601_HRB103265 Mannheim HRB 103265 Mannheim B1601 2013-11-20  
136 136 B1601_HRB10329 B1601_HRB10329 Mannheim HRB 10329 Mannheim B1601 2008-02-14  
137 137 B1601_HRB103325 B1601_HRB103325 Mannheim HRB 103325 Mannheim B1601 2013-11-11  
138 138 B1601_HRB10338 B1601_HRB10338 Mannheim HRB 10338 Mannheim B1601 2007-04-05  
139 139 B1601_HRB103380 B1601_HRB103380 Mannheim HRB 103380 Mannheim B1601 2008-09-25  
140 140 B1601_HRB103411 B1601_HRB103411 Mannheim HRB 103411 Mannheim B1601 2017-01-27  
141 141 B1601_HRB103424 B1601_HRB103424 Mannheim HRB 103424 Mannheim B1601 2011-10-07  
142 142 B1601_HRB103473 B1601_HRB103473 Mannheim HRB 103473 Mannheim B1601 2012-08-21  
143 143 B1601_HRB10349 B1601_HRB10349 Mannheim HRB 10349 Mannheim B1601 2008-05-02  
144 144 B1601_HRB103509 B1601_HRB103509 Mannheim HRB 103509 Mannheim B1601 2009-06-04  
145 145 B1601_HRB103523 B1601_HRB103523 Mannheim HRB 103523 Mannheim B1601 2020-02-28  
146 146 B1601_HRB103565 B1601_HRB103565 Mannheim HRB 103565 Mannheim B1601 2013-07-09  
147 147 B1601_HRB103581 B1601_HRB103581 Mannheim HRB 103581 Mannheim B1601 2019-01-18  
148 148 B1601_HRB10360 B1601_HRB10360 Mannheim HRB 10360 Mannheim B1601 2009-08-18  
149 149 B1601_HRB103607 B1601_HRB103607 Mannheim HRB 103607 Mannheim B1601 2010-09-07  
150 150 B1601_HRB103699 B1601_HRB103699 Mannheim HRB 103699 Mannheim B1601 2011-06-28  
151 151 B1601_HRB103700 B1601_HRB103700 Mannheim HRB 103700 Mannheim B1601 2021-01-11  
152 152 B1601_HRB103758 B1601_HRB103758 Mannheim HRB 103758 Mannheim B1601 2007-11-26  
153 153 B1601_HRB10376 B1601_HRB10376 Mannheim HRB 10376 Mannheim B1601 2008-05-02  
154 154 B1601_HRB103769 B1601_HRB103769 Mannheim HRB 103769 Mannheim B1601 2017-04-25  
155 155 B1601_HRB10380 B1601_HRB10380 Mannheim HRB 10380 Mannheim B1601 2012-01-05  
156 156 B1601_HRB103811 B1601_HRB103811 Mannheim HRB 103811 Mannheim B1601 2013-08-20  
157 157 B1601_HRB103820 B1601_HRB103820 Mannheim HRB 103820 Mannheim B1601 2009-03-20  
158 158 B1601_HRB103883 B1601_HRB103883 Mannheim HRB 103883 Mannheim B1601 2019-01-03  
159 159 B1601_HRB103915 B1601_HRB103915 Mannheim HRB 103915 Mannheim B1601 2022-06-02  
160 160 B1601_HRB103928 B1601_HRB103928 Mannheim HRB 103928 Mannheim B1601 2007-08-21  
161 161 B1601_HRB10393 B1601_HRB10393 Mannheim HRB 10393 Mannheim B1601 2007-01-11  
162 162 B1601_HRB103957 B1601_HRB103957 Mannheim HRB 103957 Mannheim B1601 2008-07-16  
163 163 B1601_HRB103961 B1601_HRB103961 Mannheim HRB 103961 Mannheim B1601 2013-04-10  
164 164 B1601_HRB10397 B1601_HRB10397 Mannheim HRB 10397 Mannheim B1601 2007-12-03  
165 165 B1601_HRB103979 B1601_HRB103979 Mannheim HRB 103979 Mannheim B1601 2009-10-02  
166 166 B1601_HRB103984 B1601_HRB103984 Mannheim HRB 103984 Mannheim B1601 2007-07-02  
167 167 B1601_HRB10402 B1601_HRB10402 Mannheim HRB 10402 Mannheim B1601 2007-02-28  
168 168 B1601_HRB104035 B1601_HRB104035 Mannheim HRB 104035 Mannheim B1601 2011-08-11  
169 169 B1601_HRB104070 B1601_HRB104070 Mannheim HRB 104070 Mannheim B1601 2011-10-11  
170 170 B1601_HRB104108 B1601_HRB104108 Mannheim HRB 104108 Mannheim B1601 2008-01-14  
171 171 B1601_HRB10411 B1601_HRB10411 Mannheim HRB 10411 Mannheim B1601 2008-09-29  
172 172 B1601_HRB104171 B1601_HRB104171 Mannheim HRB 104171 Mannheim B1601 2014-02-05  
173 173 B1601_HRB104189 B1601_HRB104189 Mannheim HRB 104189 Mannheim B1601 2009-12-02  
174 174 B1601_HRB104194 B1601_HRB104194 Mannheim HRB 104194 Mannheim B1601 2016-09-27  
175 175 B1601_HRB104206 B1601_HRB104206 Mannheim HRB 104206 Mannheim B1601 2007-07-19  
176 176 B1601_HRB10422 B1601_HRB10422 Mannheim HRB 10422 Mannheim B1601 2007-07-05  
177 177 B1601_HRB104267 B1601_HRB104267 Mannheim HRB 104267 Mannheim B1601 2008-12-18  
178 178 B1601_HRB104302 B1601_HRB104302 Mannheim HRB 104302 Mannheim B1601 2008-05-26  
179 179 B1601_HRB10432 B1601_HRB10432 Mannheim HRB 10432 Mannheim B1601 2014-05-12  
180 180 B1601_HRB104329 B1601_HRB104329 Mannheim HRB 104329 Mannheim B1601 2010-12-09  
181 181 B1601_HRB104343 B1601_HRB104343 Mannheim HRB 104343 Mannheim B1601 2012-05-23  
182 182 B1601_HRB104348 B1601_HRB104348 Mannheim HRB 104348 Mannheim B1601 2007-08-27  
183 183 B1601_HRB104361 B1601_HRB104361 Mannheim HRB 104361 Mannheim B1601 2011-01-11  
184 184 B1601_HRB104424 B1601_HRB104424 Mannheim HRB 104424 Mannheim B1601 2009-08-04  
185 185 B1601_HRB10448 B1601_HRB10448 Mannheim HRB 10448 Mannheim B1601 2007-12-14  
186 186 B1601_HRB104522 B1601_HRB104522 Mannheim HRB 104522 Mannheim B1601 2007-08-02  
187 187 B1601_HRB104563 B1601_HRB104563 Mannheim HRB 104563 Mannheim B1601 2012-08-23  
188 188 B1601_HRB104568 B1601_HRB104568 Mannheim HRB 104568 Mannheim B1601 2007-04-02  
189 189 B1601_HRB104579 B1601_HRB104579 Mannheim HRB 104579 Mannheim B1601 2018-05-28  
190 190 B1601_HRB104587 B1601_HRB104587 Mannheim HRB 104587 Mannheim B1601 2011-03-03  
191 191 B1601_HRB104594 B1601_HRB104594 Mannheim HRB 104594 Mannheim B1601 2021-02-25  
192 192 B1601_HRB104655 B1601_HRB104655 Mannheim HRB 104655 Mannheim B1601 2012-09-21  
193 193 B1601_HRB104738 B1601_HRB104738 Mannheim HRB 104738 Mannheim B1601 2008-12-18  
194 194 B1601_HRB104750 B1601_HRB104750 Mannheim HRB 104750 Mannheim B1601 2020-07-27  
195 195 B1601_HRB104760 B1601_HRB104760 Mannheim HRB 104760 Mannheim B1601 2011-01-26  
196 196 B1601_HRB104781 B1601_HRB104781 Mannheim HRB 104781 Mannheim B1601 2008-09-01  
197 197 B1601_HRB104793 B1601_HRB104793 Mannheim HRB 104793 Mannheim B1601 2009-06-18  
198 198 B1601_HRB104821-F1103_HRB174253B-F1103_HRB174253 B1601_HRB104821 Mannheim HRB 104821 Mannheim B1601 2007-10-17 2016-02-10
199 199 B1601_HRB104821-F1103_HRB174253B-F1103_HRB174253 F1103_HRB174253B Charlottenburg (Berlin) HRB 174253 B Berlin (Charlottenburg) F1103 2016-02-10  
200 200 B1601_HRB104846 B1601_HRB104846 Mannheim HRB 104846 Mannheim B1601 2007-05-14  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "ReferenceNumbers" (
    "companyId" varchar,
    "stdRefNo" varchar,
    "nativeReferenceNumber" varchar,
    "courtName" varchar,
    "courtCode" varchar,
    "referenceNumberFirstSeen" date,
    "validTill" date
);
CREATE INDEX "RefNocompanyId" ON "ReferenceNumbers" (
	"companyId"
);