ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by referenceNumberFirstSeen descending
This data as json, CSV (advanced)
Link | rowid | companyId | stdRefNo | nativeReferenceNumber | courtName | courtCode | referenceNumberFirstSeen ▲ | validTill |
---|---|---|---|---|---|---|---|---|
189997 | 189997 | P3313_HRB217916 | P3313_HRB217916 | Osnabrück HRB 217916 | Osnabrück | P3313 | 2022-07-28 | |
189998 | 189998 | P3313_HRB217918 | P3313_HRB217918 | Osnabrück HRB 217918 | Osnabrück | P3313 | 2022-07-28 | |
263270 | 263270 | T2214_HRB28632 | T2214_HRB28632 | Montabaur HRB 28632 | Montabaur | T2214 | 2022-07-28 | |
265503 | 265503 | T2304_HRB51401 | T2304_HRB51401 | Mainz HRB 51401 | Mainz | T2304 | 2022-07-28 | |
268769 | 268769 | T3104_HRB68320 | T3104_HRB68320 | Ludwigshafen a.Rhein (Ludwigshafen) HRB 68320 | Ludwigshafen a.Rhein (Ludwigshafen) | T3104 | 2022-07-28 | |
282206 | 282206 | U1308_HRB40555 | U1308_HRB40555 | Leipzig HRB 40555 | Leipzig | U1308 | 2022-07-28 | |
299927 | 299927 | X1721_HRB5022HL | X1721_HRB5022HL | Lübeck HRB 5022 HL | Lübeck | X1721 | 2022-07-28 | |
305530 | 305530 | Y1206_HRB519803 | Y1206_HRB519803 | Jena HRB 519803 | Jena | Y1206 | 2022-07-28 | |
314217 | 314217 | B1601_HRB744552 | B1601_HRB744552 | Mannheim HRB 744552 | Mannheim | B1601 | 2022-07-28 | |
314218 | 314218 | B1601_HRB744554 | B1601_HRB744554 | Mannheim HRB 744554 | Mannheim | B1601 | 2022-07-28 | |
314219 | 314219 | B1601_HRB744563 | B1601_HRB744563 | Mannheim HRB 744563 | Mannheim | B1601 | 2022-07-28 | |
327651 | 327651 | B2609_HRB785726 | B2609_HRB785726 | Stuttgart HRB 785726 | Stuttgart | B2609 | 2022-07-28 | |
332545 | 332545 | B2805_HRB744708 | B2805_HRB744708 | Ulm HRB 744708 | Ulm | B2805 | 2022-07-28 | |
363589 | 363589 | D2601_HRB253874-F1103_HRB244480B | F1103_HRB244480B | Charlottenburg (Berlin) HRB 244480 B | Berlin (Charlottenburg) | F1103 | 2022-07-28 | |
400100 | 400100 | F1103_HRB173111B-B2609_HRB785724 | B2609_HRB785724 | Stuttgart HRB 785724 | Stuttgart | B2609 | 2022-07-28 | |
408846 | 408846 | F1103_HRB244507B | F1103_HRB244507B | Charlottenburg (Berlin) HRB 244507 B | Berlin (Charlottenburg) | F1103 | 2022-07-28 | |
417979 | 417979 | G1309_HRB13945NP | G1309_HRB13945NP | Neuruppin HRB 13945 NP | Neuruppin | G1309 | 2022-07-28 | |
434821 | 434821 | K1101_HRB176438 | K1101_HRB176438 | Hamburg HRB 176438 | Hamburg | K1101 | 2022-07-28 | |
434822 | 434822 | K1101_HRB176442 | K1101_HRB176442 | Hamburg HRB 176442 | Hamburg | K1101 | 2022-07-28 | |
446098 | 446098 | M1114_HRB54954 | M1114_HRB54954 | Offenbach am Main HRB 54954 | Offenbach am Main | M1114 | 2022-07-28 | |
449787 | 449787 | M1201_HRB128235 | M1201_HRB128235 | Frankfurt am Main HRB 128235 | Frankfurt am Main | M1201 | 2022-07-28 | |
449788 | 449788 | M1201_HRB128236 | M1201_HRB128236 | Frankfurt am Main HRB 128236 | Frankfurt am Main | M1201 | 2022-07-28 | |
461407 | 461407 | M1502_HRB98852 | M1502_HRB98852 | Hanau HRB 98852 | Hanau | M1502 | 2022-07-28 | |
461408 | 461408 | M1502_HRB98853 | M1502_HRB98853 | Hanau HRB 98853 | Hanau | M1502 | 2022-07-28 | |
466910 | 466910 | M1906_HRB33576 | M1906_HRB33576 | Wiesbaden HRB 33576 | Wiesbaden | M1906 | 2022-07-28 | |
472537 | 472537 | P1103_HRB210167 | P1103_HRB210167 | Braunschweig HRB 210167 | Braunschweig | P1103 | 2022-07-28 | |
478035 | 478035 | P2305_HRB223966 | P2305_HRB223966 | Hannover HRB 223966 | Hannover | P2305 | 2022-07-28 | |
478036 | 478036 | P2305_HRB223967 | P2305_HRB223967 | Hannover HRB 223967 | Hannover | P2305 | 2022-07-28 | |
483887 | 483887 | P2613_HRB209559 | P2613_HRB209559 | Tostedt HRB 209559 | Tostedt | P2613 | 2022-07-28 | |
483888 | 483888 | P2613_HRB209560 | P2613_HRB209560 | Tostedt HRB 209560 | Tostedt | P2613 | 2022-07-28 | |
490583 | 490583 | P3210_HRB218488 | P3210_HRB218488 | Oldenburg HRB 218488 | Oldenburg (Oldenburg) | P3210 | 2022-07-28 | |
494071 | 494071 | P3313_HRB217917 | P3313_HRB217917 | Osnabrück HRB 217917 | Osnabrück | P3313 | 2022-07-28 | |
569845 | 569845 | T2304_HRB51403 | T2304_HRB51403 | Mainz HRB 51403 | Mainz | T2304 | 2022-07-28 | |
573304 | 573304 | T3104_HRB68318 | T3104_HRB68318 | Ludwigshafen a.Rhein (Ludwigshafen) HRB 68318 | Ludwigshafen a.Rhein (Ludwigshafen) | T3104 | 2022-07-28 | |
573305 | 573305 | T3104_HRB68319 | T3104_HRB68319 | Ludwigshafen a.Rhein (Ludwigshafen) HRB 68319 | Ludwigshafen a.Rhein (Ludwigshafen) | T3104 | 2022-07-28 | |
575188 | 575188 | T3403_HRB32795 | T3403_HRB32795 | Zweibrücken HRB 32795 | Zweibrücken | T3403 | 2022-07-28 | |
579242 | 579242 | U1104_HRB43094 | U1104_HRB43094 | Dresden HRB 43094 | Dresden | U1104 | 2022-07-28 | |
582619 | 582619 | U1206_HRB35146 | U1206_HRB35146 | Chemnitz HRB 35146 | Chemnitz | U1206 | 2022-07-28 | |
582752 | 582752 | U1206_HRB5619 | U1206_HRB5619 | Chemnitz HRB 5619 | Chemnitz | U1206 | 2022-07-28 | |
589912 | 589912 | V1109_HRB64351 | V1109_HRB64351 | Saarbrücken HRB 64351 | Saarbrücken | V1109 | 2022-07-28 | |
594651 | 594651 | W1215_HRB31659 | W1215_HRB31659 | Stendal HRB 31659 | Stendal | W1215 | 2022-07-28 | |
596313 | 596313 | X1112_HRB15845FL | X1112_HRB15845FL | Flensburg HRB 15845 FL | Flensburg | X1112 | 2022-07-28 | |
610228 | 610228 | Y1206_HRB519802 | Y1206_HRB519802 | Jena HRB 519802 | Jena | Y1206 | 2022-07-28 | |
618708 | 618708 | B1601_HRB744559 | B1601_HRB744559 | Mannheim HRB 744559 | Mannheim | B1601 | 2022-07-28 | |
618709 | 618709 | B1601_HRB744562 | B1601_HRB744562 | Mannheim HRB 744562 | Mannheim | B1601 | 2022-07-28 | |
632523 | 632523 | B2609_HRB785728 | B2609_HRB785728 | Stuttgart HRB 785728 | Stuttgart | B2609 | 2022-07-28 | |
632524 | 632524 | B2609_HRB785740 | B2609_HRB785740 | Stuttgart HRB 785740 | Stuttgart | B2609 | 2022-07-28 | |
642726 | 642726 | B8536_HRB727064 | B8536_HRB727064 | Freiburg HRB 727064 | Registergericht Freiburg i. Br. | B8536 | 2022-07-28 | |
642727 | 642727 | B8536_HRB727068 | B8536_HRB727068 | Freiburg HRB 727068 | Registergericht Freiburg i. Br. | B8536 | 2022-07-28 | |
642728 | 642728 | B8536_HRB727072 | B8536_HRB727072 | Freiburg HRB 727072 | Registergericht Freiburg i. Br. | B8536 | 2022-07-28 | |
668720 | 668720 | D2601_HRB257962-F1103_HRB244479B | F1103_HRB244479B | Charlottenburg (Berlin) HRB 244479 B | Berlin (Charlottenburg) | F1103 | 2022-07-28 | |
669923 | 669923 | D2601_HRB267778-F1103_HRB244485B | F1103_HRB244485B | Charlottenburg (Berlin) HRB 244485 B | Berlin (Charlottenburg) | F1103 | 2022-07-28 | |
710113 | 710113 | F1103_HRB217980B-M1201_HRB121271-M1203_HRB11305 | M1203_HRB11305 | Königstein HRB 11305 | Königstein | M1203 | 2022-07-28 | |
713214 | 713214 | F1103_HRB244499B | F1103_HRB244499B | Charlottenburg (Berlin) HRB 244499 B | Berlin (Charlottenburg) | F1103 | 2022-07-28 | |
713215 | 713215 | F1103_HRB244508B | F1103_HRB244508B | Charlottenburg (Berlin) HRB 244508 B | Berlin (Charlottenburg) | F1103 | 2022-07-28 | |
718385 | 718385 | F1103_HRB99913B-G1312_HRB37068P | G1312_HRB37068P | Potsdam HRB 37068 P | Potsdam | G1312 | 2022-07-28 | |
721070 | 721070 | G1207_HRB19523FF | G1207_HRB19523FF | Frankfurt/Oder HRB 19523 FF | Frankfurt/Oder | G1207 | 2022-07-28 | |
725810 | 725810 | G1312_HRB37066P | G1312_HRB37066P | Potsdam HRB 37066 P | Potsdam | G1312 | 2022-07-28 | |
728883 | 728883 | H1101_HRB38188HB | H1101_HRB38188HB | Bremen HRB 38188 HB | Bremen | H1101 | 2022-07-28 | |
739234 | 739234 | K1101_HRB176447 | K1101_HRB176447 | Hamburg HRB 176447 | Hamburg | K1101 | 2022-07-28 | |
744967 | 744967 | M1103_HRB103791 | M1103_HRB103791 | Darmstadt HRB 103791 | Darmstadt | M1103 | 2022-07-28 | |
744968 | 744968 | M1103_HRB103793 | M1103_HRB103793 | Darmstadt HRB 103793 | Darmstadt | M1103 | 2022-07-28 | |
744969 | 744969 | M1103_HRB103796 | M1103_HRB103796 | Darmstadt HRB 103796 | Darmstadt | M1103 | 2022-07-28 | |
754228 | 754228 | M1201_HRB128229 | M1201_HRB128229 | Frankfurt am Main HRB 128229 | Frankfurt am Main | M1201 | 2022-07-28 | |
754229 | 754229 | M1201_HRB128234 | M1201_HRB128234 | Frankfurt am Main HRB 128234 | Frankfurt am Main | M1201 | 2022-07-28 | |
754230 | 754230 | M1201_HRB128239 | M1201_HRB128239 | Frankfurt am Main HRB 128239 | Frankfurt am Main | M1201 | 2022-07-28 | |
769178 | 769178 | M1809_HRB8053 | M1809_HRB8053 | Marburg HRB 8053 | Marburg | M1809 | 2022-07-28 | |
776880 | 776880 | P1103_HRB210173 | P1103_HRB210173 | Braunschweig HRB 210173 | Braunschweig | P1103 | 2022-07-28 | |
782322 | 782322 | P2305_HRB223961 | P2305_HRB223961 | Hannover HRB 223961 | Hannover | P2305 | 2022-07-28 | |
782323 | 782323 | P2305_HRB223962 | P2305_HRB223962 | Hannover HRB 223962 | Hannover | P2305 | 2022-07-28 | |
784490 | 784490 | P2408_HRB208268 | P2408_HRB208268 | Hildesheim HRB 208268 | Hildesheim | P2408 | 2022-07-28 | |
798704 | 798704 | P3313_HRB217914 | P3313_HRB217914 | Osnabrück HRB 217914 | Osnabrück | P3313 | 2022-07-28 | |
798705 | 798705 | P3313_HRB217920 | P3313_HRB217920 | Osnabrück HRB 217920 | Osnabrück | P3313 | 2022-07-28 | |
874870 | 874870 | T2304_HRB51406 | T2304_HRB51406 | Mainz HRB 51406 | Mainz | T2304 | 2022-07-28 | |
884139 | 884139 | U1104_HRB43091 | U1104_HRB43091 | Dresden HRB 43091 | Dresden | U1104 | 2022-07-28 | |
891622 | 891622 | U1308_HRB40553 | U1308_HRB40553 | Leipzig HRB 40553 | Leipzig | U1308 | 2022-07-28 | |
899332 | 899332 | W1215_HRB31662 | W1215_HRB31662 | Stendal HRB 31662 | Stendal | W1215 | 2022-07-28 | |
923565 | 923565 | B1601_HRB744555 | B1601_HRB744555 | Mannheim HRB 744555 | Mannheim | B1601 | 2022-07-28 | |
923566 | 923566 | B1601_HRB744556 | B1601_HRB744556 | Mannheim HRB 744556 | Mannheim | B1601 | 2022-07-28 | |
923567 | 923567 | B1601_HRB744557 | B1601_HRB744557 | Mannheim HRB 744557 | Mannheim | B1601 | 2022-07-28 | |
923568 | 923568 | B1601_HRB744560 | B1601_HRB744560 | Mannheim HRB 744560 | Mannheim | B1601 | 2022-07-28 | |
923569 | 923569 | B1601_HRB744566 | B1601_HRB744566 | Mannheim HRB 744566 | Mannheim | B1601 | 2022-07-28 | |
937558 | 937558 | B2609_HRB785723 | B2609_HRB785723 | Stuttgart HRB 785723 | Stuttgart | B2609 | 2022-07-28 | |
937559 | 937559 | B2609_HRB785731 | B2609_HRB785731 | Stuttgart HRB 785731 | Stuttgart | B2609 | 2022-07-28 | |
937560 | 937560 | B2609_HRB785735 | B2609_HRB785735 | Stuttgart HRB 785735 | Stuttgart | B2609 | 2022-07-28 | |
942395 | 942395 | B2805_HRB744707 | B2805_HRB744707 | Ulm HRB 744707 | Ulm | B2805 | 2022-07-28 | |
947716 | 947716 | B8536_HRB727065 | B8536_HRB727065 | Freiburg HRB 727065 | Registergericht Freiburg i. Br. | B8536 | 2022-07-28 | |
947717 | 947717 | B8536_HRB727070 | B8536_HRB727070 | Freiburg HRB 727070 | Registergericht Freiburg i. Br. | B8536 | 2022-07-28 | |
1018459 | 1018459 | F1103_HRB244493B | F1103_HRB244493B | Charlottenburg (Berlin) HRB 244493 B | Berlin (Charlottenburg) | F1103 | 2022-07-28 | |
1018460 | 1018460 | F1103_HRB244496B | F1103_HRB244496B | Charlottenburg (Berlin) HRB 244496 B | Berlin (Charlottenburg) | F1103 | 2022-07-28 | |
1019150 | 1019150 | F1103_HRB4278B | F1103_HRB4278B | Charlottenburg (Berlin) HRB 4278 B | Berlin (Charlottenburg) | F1103 | 2022-07-28 | |
1034231 | 1034231 | H1101_HRB38187HB | H1101_HRB38187HB | Bremen HRB 38187 HB | Bremen | H1101 | 2022-07-28 | |
1044618 | 1044618 | K1101_HRB176444 | K1101_HRB176444 | Hamburg HRB 176444 | Hamburg | K1101 | 2022-07-28 | |
1044619 | 1044619 | K1101_HRB176451 | K1101_HRB176451 | Hamburg HRB 176451 | Hamburg | K1101 | 2022-07-28 | |
1044620 | 1044620 | K1101_HRB176453 | K1101_HRB176453 | Hamburg HRB 176453 | Hamburg | K1101 | 2022-07-28 | |
1050348 | 1050348 | M1103_HRB103786 | M1103_HRB103786 | Darmstadt HRB 103786 | Darmstadt | M1103 | 2022-07-28 | |
1050349 | 1050349 | M1103_HRB103790 | M1103_HRB103790 | Darmstadt HRB 103790 | Darmstadt | M1103 | 2022-07-28 | |
1059462 | 1059462 | M1201_HRB128231 | M1201_HRB128231 | Frankfurt am Main HRB 128231 | Frankfurt am Main | M1201 | 2022-07-28 | |
1059539 | 1059539 | M1201_HRB18229-M1103_HRB103787 | M1103_HRB103787 | Darmstadt HRB 103787 | Darmstadt | M1103 | 2022-07-28 | |
1071074 | 1071074 | M1502_HRB98855 | M1502_HRB98855 | Hanau HRB 98855 | Hanau | M1502 | 2022-07-28 |
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" );