ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: referenceNumberFirstSeen (date), validTill (date)
Link | rowid ▲ | companyId | stdRefNo | nativeReferenceNumber | courtName | courtCode | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
2440122 | 2440122 | Y1304_HRB6811-D4608_HRB3742 | D4608_HRB3742 | Schweinfurt HRB 3742 | Schweinfurt | D4608 | 2005-04-28 | |
2440121 | 2440121 | Y1206_HRB519801 | Y1206_HRB519801 | Jena HRB 519801 | Jena | Y1206 | 2022-07-28 | |
2440120 | 2440120 | Y1206_HRB519758 | Y1206_HRB519758 | Jena HRB 519758 | Jena | Y1206 | 2022-07-15 | |
2440119 | 2440119 | Y1206_HRB519691 | Y1206_HRB519691 | Jena HRB 519691 | Jena | Y1206 | 2022-06-28 | |
2440118 | 2440118 | Y1206_HRB519637 | Y1206_HRB519637 | Jena HRB 519637 | Jena | Y1206 | 2022-06-09 | |
2440117 | 2440117 | Y1206_HRB519530 | Y1206_HRB519530 | Jena HRB 519530 | Jena | Y1206 | 2022-05-11 | |
2440116 | 2440116 | Y1206_HRB519507 | Y1206_HRB519507 | Jena HRB 519507 | Jena | Y1206 | 2022-05-04 | |
2440115 | 2440115 | Y1206_HRB519484 | Y1206_HRB519484 | Jena HRB 519484 | Jena | Y1206 | 2022-04-27 | |
2440114 | 2440114 | Y1206_HRB519438 | Y1206_HRB519438 | Jena HRB 519438 | Jena | Y1206 | 2022-04-12 | |
2440113 | 2440113 | Y1206_HRB519290 | Y1206_HRB519290 | Jena HRB 519290 | Jena | Y1206 | 2022-03-01 | |
2440112 | 2440112 | Y1206_HRB519285 | Y1206_HRB519285 | Jena HRB 519285 | Jena | Y1206 | 2022-03-01 | |
2440111 | 2440111 | Y1206_HRB519278 | Y1206_HRB519278 | Jena HRB 519278 | Jena | Y1206 | 2022-02-25 | |
2440110 | 2440110 | Y1206_HRB519273 | Y1206_HRB519273 | Jena HRB 519273 | Jena | Y1206 | 2022-02-24 | |
2440109 | 2440109 | Y1206_HRB519100 | Y1206_HRB519100 | Jena HRB 519100 | Jena | Y1206 | 2022-01-10 | |
2440108 | 2440108 | Y1206_HRB519073 | Y1206_HRB519073 | Jena HRB 519073 | Jena | Y1206 | 2022-01-05 | |
2440107 | 2440107 | Y1206_HRB519070 | Y1206_HRB519070 | Jena HRB 519070 | Jena | Y1206 | 2022-01-05 | |
2440106 | 2440106 | Y1206_HRB519053 | Y1206_HRB519053 | Jena HRB 519053 | Jena | Y1206 | 2021-12-28 | |
2440105 | 2440105 | Y1206_HRB518936 | Y1206_HRB518936 | Jena HRB 518936 | Jena | Y1206 | 2021-11-25 | |
2440104 | 2440104 | Y1206_HRB518913 | Y1206_HRB518913 | Jena HRB 518913 | Jena | Y1206 | 2021-11-17 | |
2440103 | 2440103 | Y1206_HRB518897 | Y1206_HRB518897 | Jena HRB 518897 | Jena | Y1206 | 2021-11-11 | |
2440102 | 2440102 | Y1206_HRB518894 | Y1206_HRB518894 | Jena HRB 518894 | Jena | Y1206 | 2021-11-10 | |
2440101 | 2440101 | Y1206_HRB518822 | Y1206_HRB518822 | Jena HRB 518822 | Jena | Y1206 | 2021-10-22 | |
2440100 | 2440100 | Y1206_HRB518712 | Y1206_HRB518712 | Jena HRB 518712 | Jena | Y1206 | 2021-09-22 | |
2440099 | 2440099 | Y1206_HRB518435 | Y1206_HRB518435 | Jena HRB 518435 | Jena | Y1206 | 2021-07-07 | |
2440098 | 2440098 | Y1206_HRB518359-R2402_HRB33626 | R2402_HRB33626 | Dortmund HRB 33626 | Dortmund | R2402 | 2022-01-10 | |
2440097 | 2440097 | Y1206_HRB518359-R2402_HRB33626 | Y1206_HRB518359 | Jena HRB 518359 | Jena | Y1206 | 2021-06-15 | 2022-01-10 |
2440096 | 2440096 | Y1206_HRB518210 | Y1206_HRB518210 | Jena HRB 518210 | Jena | Y1206 | 2021-05-11 | |
2440095 | 2440095 | Y1206_HRB518152 | Y1206_HRB518152 | Jena HRB 518152 | Jena | Y1206 | 2021-04-22 | |
2440094 | 2440094 | Y1206_HRB518112 | Y1206_HRB518112 | Jena HRB 518112 | Jena | Y1206 | 2021-04-08 | |
2440093 | 2440093 | Y1206_HRB518104 | Y1206_HRB518104 | Jena HRB 518104 | Jena | Y1206 | 2021-04-07 | |
2440092 | 2440092 | Y1206_HRB518008 | Y1206_HRB518008 | Jena HRB 518008 | Jena | Y1206 | 2021-03-16 | |
2440091 | 2440091 | Y1206_HRB517996 | Y1206_HRB517996 | Jena HRB 517996 | Jena | Y1206 | 2021-03-12 | |
2440090 | 2440090 | Y1206_HRB517980 | Y1206_HRB517980 | Jena HRB 517980 | Jena | Y1206 | 2021-03-09 | |
2440089 | 2440089 | Y1206_HRB517833-D3304_HRB19333 | D3304_HRB19333 | Fürth HRB 19333 | Fürth | D3304 | 2022-01-07 | |
2440088 | 2440088 | Y1206_HRB517833-D3304_HRB19333 | Y1206_HRB517833 | Jena HRB 517833 | Jena | Y1206 | 2021-02-01 | 2022-01-07 |
2440087 | 2440087 | Y1206_HRB517717 | Y1206_HRB517717 | Jena HRB 517717 | Jena | Y1206 | 2021-01-04 | |
2440086 | 2440086 | Y1206_HRB517703 | Y1206_HRB517703 | Jena HRB 517703 | Jena | Y1206 | 2020-12-29 | |
2440085 | 2440085 | Y1206_HRB517637 | Y1206_HRB517637 | Jena HRB 517637 | Jena | Y1206 | 2020-12-14 | |
2440084 | 2440084 | Y1206_HRB517628 | Y1206_HRB517628 | Jena HRB 517628 | Jena | Y1206 | 2020-12-14 | |
2440083 | 2440083 | Y1206_HRB517560 | Y1206_HRB517560 | Jena HRB 517560 | Jena | Y1206 | 2020-11-24 | |
2440082 | 2440082 | Y1206_HRB517507 | Y1206_HRB517507 | Jena HRB 517507 | Jena | Y1206 | 2020-11-12 | |
2440081 | 2440081 | Y1206_HRB517441 | Y1206_HRB517441 | Jena HRB 517441 | Jena | Y1206 | 2020-10-27 | |
2440080 | 2440080 | Y1206_HRB517431 | Y1206_HRB517431 | Jena HRB 517431 | Jena | Y1206 | 2020-10-22 | |
2440079 | 2440079 | Y1206_HRB517334 | Y1206_HRB517334 | Jena HRB 517334 | Jena | Y1206 | 2020-09-21 | |
2440078 | 2440078 | Y1206_HRB517280 | Y1206_HRB517280 | Jena HRB 517280 | Jena | Y1206 | 2020-09-04 | |
2440077 | 2440077 | Y1206_HRB517268 | Y1206_HRB517268 | Jena HRB 517268 | Jena | Y1206 | 2020-09-01 | |
2440076 | 2440076 | Y1206_HRB517215 | Y1206_HRB517215 | Jena HRB 517215 | Jena | Y1206 | 2020-08-13 | |
2440075 | 2440075 | Y1206_HRB517173 | Y1206_HRB517173 | Jena HRB 517173 | Jena | Y1206 | 2020-07-31 | |
2440074 | 2440074 | Y1206_HRB517138 | Y1206_HRB517138 | Jena HRB 517138 | Jena | Y1206 | 2020-07-22 | |
2440073 | 2440073 | Y1206_HRB517127 | Y1206_HRB517127 | Jena HRB 517127 | Jena | Y1206 | 2020-07-20 | |
2440072 | 2440072 | Y1206_HRB517006 | Y1206_HRB517006 | Jena HRB 517006 | Jena | Y1206 | 2020-06-15 | |
2440071 | 2440071 | Y1206_HRB516989 | Y1206_HRB516989 | Jena HRB 516989 | Jena | Y1206 | 2020-06-11 | |
2440070 | 2440070 | Y1206_HRB516927 | Y1206_HRB516927 | Jena HRB 516927 | Jena | Y1206 | 2020-05-25 | |
2440069 | 2440069 | Y1206_HRB516756 | Y1206_HRB516756 | Jena HRB 516756 | Jena | Y1206 | 2020-03-23 | |
2440068 | 2440068 | Y1206_HRB516746 | Y1206_HRB516746 | Jena HRB 516746 | Jena | Y1206 | 2020-03-19 | |
2440067 | 2440067 | Y1206_HRB516718 | Y1206_HRB516718 | Jena HRB 516718 | Jena | Y1206 | 2020-03-12 | |
2440066 | 2440066 | Y1206_HRB516701 | Y1206_HRB516701 | Jena HRB 516701 | Jena | Y1206 | 2020-03-09 | |
2440065 | 2440065 | Y1206_HRB516693 | Y1206_HRB516693 | Jena HRB 516693 | Jena | Y1206 | 2020-03-05 | |
2440064 | 2440064 | Y1206_HRB516646 | Y1206_HRB516646 | Jena HRB 516646 | Jena | Y1206 | 2020-02-21 | |
2440063 | 2440063 | Y1206_HRB516605 | Y1206_HRB516605 | Jena HRB 516605 | Jena | Y1206 | 2020-02-10 | |
2440062 | 2440062 | Y1206_HRB516545 | Y1206_HRB516545 | Jena HRB 516545 | Jena | Y1206 | 2020-01-24 | |
2440061 | 2440061 | Y1206_HRB516359 | Y1206_HRB516359 | Jena HRB 516359 | Jena | Y1206 | 2019-12-02 | |
2440060 | 2440060 | Y1206_HRB516339 | Y1206_HRB516339 | Jena HRB 516339 | Jena | Y1206 | 2019-11-28 | |
2440059 | 2440059 | Y1206_HRB516308 | Y1206_HRB516308 | Jena HRB 516308 | Jena | Y1206 | 2019-11-20 | |
2440058 | 2440058 | Y1206_HRB516286-B8536_HRB725061 | B8536_HRB725061 | Freiburg HRB 725061 | Registergericht Freiburg i. Br. | B8536 | 2021-09-22 | |
2440057 | 2440057 | Y1206_HRB516286-B8536_HRB725061 | Y1206_HRB516286 | Jena HRB 516286 | Jena | Y1206 | 2019-11-14 | 2021-09-22 |
2440056 | 2440056 | Y1206_HRB516281 | Y1206_HRB516281 | Jena HRB 516281 | Jena | Y1206 | 2019-11-13 | |
2440055 | 2440055 | Y1206_HRB516260 | Y1206_HRB516260 | Jena HRB 516260 | Jena | Y1206 | 2019-11-07 | |
2440054 | 2440054 | Y1206_HRB516225 | Y1206_HRB516225 | Jena HRB 516225 | Jena | Y1206 | 2019-10-25 | |
2440053 | 2440053 | Y1206_HRB516118-D4608_HRB8550 | D4608_HRB8550 | Schweinfurt HRB 8550 | Schweinfurt | D4608 | 2021-05-19 | |
2440052 | 2440052 | Y1206_HRB516118-D4608_HRB8550 | Y1206_HRB516118 | Jena HRB 516118 | Jena | Y1206 | 2019-09-19 | 2021-05-19 |
2440051 | 2440051 | Y1206_HRB515988 | Y1206_HRB515988 | Jena HRB 515988 | Jena | Y1206 | 2019-08-05 | |
2440050 | 2440050 | Y1206_HRB515920 | Y1206_HRB515920 | Jena HRB 515920 | Jena | Y1206 | 2019-07-12 | |
2440049 | 2440049 | Y1206_HRB515880 | Y1206_HRB515880 | Jena HRB 515880 | Jena | Y1206 | 2019-07-02 | |
2440048 | 2440048 | Y1206_HRB515759 | Y1206_HRB515759 | Jena HRB 515759 | Jena | Y1206 | 2019-05-15 | |
2440047 | 2440047 | Y1206_HRB515715 | Y1206_HRB515715 | Jena HRB 515715 | Jena | Y1206 | 2019-05-03 | |
2440046 | 2440046 | Y1206_HRB515584 | Y1206_HRB515584 | Jena HRB 515584 | Jena | Y1206 | 2019-03-27 | |
2440045 | 2440045 | Y1206_HRB515564 | Y1206_HRB515564 | Jena HRB 515564 | Jena | Y1206 | 2019-03-22 | |
2440044 | 2440044 | Y1206_HRB515516 | Y1206_HRB515516 | Jena HRB 515516 | Jena | Y1206 | 2019-03-06 | |
2440043 | 2440043 | Y1206_HRB515495 | Y1206_HRB515495 | Jena HRB 515495 | Jena | Y1206 | 2019-02-26 | |
2440042 | 2440042 | Y1206_HRB515447 | Y1206_HRB515447 | Jena HRB 515447 | Jena | Y1206 | 2019-02-12 | |
2440041 | 2440041 | Y1206_HRB515389 | Y1206_HRB515389 | Jena HRB 515389 | Jena | Y1206 | 2019-01-30 | |
2440040 | 2440040 | Y1206_HRB515388 | Y1206_HRB515388 | Jena HRB 515388 | Jena | Y1206 | 2019-01-30 | |
2440039 | 2440039 | Y1206_HRB515380 | Y1206_HRB515380 | Jena HRB 515380 | Jena | Y1206 | 2019-01-28 | |
2440038 | 2440038 | Y1206_HRB515360 | Y1206_HRB515360 | Jena HRB 515360 | Jena | Y1206 | 2019-01-23 | |
2440037 | 2440037 | Y1206_HRB515288 | Y1206_HRB515288 | Jena HRB 515288 | Jena | Y1206 | 2019-01-07 | |
2440036 | 2440036 | Y1206_HRB515284 | Y1206_HRB515284 | Jena HRB 515284 | Jena | Y1206 | 2019-01-04 | |
2440035 | 2440035 | Y1206_HRB515268 | Y1206_HRB515268 | Jena HRB 515268 | Jena | Y1206 | 2019-01-02 | |
2440034 | 2440034 | Y1206_HRB515181 | Y1206_HRB515181 | Jena HRB 515181 | Jena | Y1206 | 2018-12-06 | |
2440033 | 2440033 | Y1206_HRB515125 | Y1206_HRB515125 | Jena HRB 515125 | Jena | Y1206 | 2018-11-20 | |
2440032 | 2440032 | Y1206_HRB515079 | Y1206_HRB515079 | Jena HRB 515079 | Jena | Y1206 | 2018-11-01 | |
2440031 | 2440031 | Y1206_HRB514966 | Y1206_HRB514966 | Jena HRB 514966 | Jena | Y1206 | 2018-09-19 | |
2440030 | 2440030 | Y1206_HRB514922 | Y1206_HRB514922 | Jena HRB 514922 | Jena | Y1206 | 2018-09-04 | |
2440029 | 2440029 | Y1206_HRB514896 | Y1206_HRB514896 | Jena HRB 514896 | Jena | Y1206 | 2018-08-28 | |
2440028 | 2440028 | Y1206_HRB514884 | Y1206_HRB514884 | Jena HRB 514884 | Jena | Y1206 | 2018-08-23 | |
2440027 | 2440027 | Y1206_HRB514876 | Y1206_HRB514876 | Jena HRB 514876 | Jena | Y1206 | 2018-08-22 | |
2440026 | 2440026 | Y1206_HRB514841 | Y1206_HRB514841 | Jena HRB 514841 | Jena | Y1206 | 2018-08-10 | |
2440025 | 2440025 | Y1206_HRB514743 | Y1206_HRB514743 | Jena HRB 514743 | Jena | Y1206 | 2018-07-06 | |
2440024 | 2440024 | Y1206_HRB514729 | Y1206_HRB514729 | Jena HRB 514729 | Jena | Y1206 | 2018-07-04 | |
2440023 | 2440023 | Y1206_HRB514706 | Y1206_HRB514706 | Jena HRB 514706 | Jena | Y1206 | 2018-06-26 |
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" );