ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by companyId descending
This data as json, CSV (advanced)
Suggested facets: referenceNumberFirstSeen (date), validTill (date)
Link | rowid | companyId ▲ | stdRefNo | nativeReferenceNumber | courtName | courtCode | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
610230 | 610230 | Y1304_HRB6966-D5701_HRB191166 | D5701_HRB191166 | Ingolstadt HRB 191166 | Ingolstadt | D5701 | 2006-01-05 | |
915046 | 915046 | Y1304_HRB6956-D4608_HRB1060 | D4608_HRB1060 | Schweinfurt HRB 1060 | Schweinfurt | D4608 | 2006-01-16 | |
305533 | 305533 | Y1304_HRB6946-U1308_HRB2997 | U1308_HRB2997 | Leipzig HRB 2997 | Leipzig | U1308 | 2005-12-12 | |
2391414 | 2391414 | Y1304_HRB6859-V1109_HRB26275 | V1109_HRB26275 | Saarbrücken HRB 26275 | Saarbrücken | V1109 | 2005-08-23 | |
305532 | 305532 | Y1304_HRB6857-U1104_HRB4057 | U1104_HRB4057 | Dresden HRB 4057 | Dresden | U1104 | 2005-08-09 | |
610229 | 610229 | Y1304_HRB6841-D4401_HRB3724 | D4401_HRB3724 | Coburg HRB 3724 | Coburg | D4401 | 2005-07-02 | |
1219892 | 1219892 | Y1304_HRB6838-D5701_HRB2583 | D5701_HRB2583 | Ingolstadt HRB 2583 | Ingolstadt | D5701 | 2005-06-24 | |
2440122 | 2440122 | Y1304_HRB6811-D4608_HRB3742 | D4608_HRB3742 | Schweinfurt HRB 3742 | Schweinfurt | D4608 | 2005-04-28 | |
1513373 | 1513373 | Y1304_HRB6788-D4401_HRB1549 | D4401_HRB1549 | Coburg HRB 1549 | Coburg | D4401 | 2005-04-08 | |
1219891 | 1219891 | Y1304_HRB6767-U1308_HRB20014 | U1308_HRB20014 | Leipzig HRB 20014 | Leipzig | U1308 | 2005-03-10 | |
2391413 | 2391413 | Y1304_HRB6529-F1103_HRB101737B-Y1206_HRB306529 | Y1206_HRB306529 | Jena HRB 306529 | Jena | Y1206 | 2006-05-18 | |
2391412 | 2391412 | Y1304_HRB6529-F1103_HRB101737B-Y1206_HRB306529 | F1103_HRB101737B | Charlottenburg (Berlin) HRB 101737 B | Berlin (Charlottenburg) | F1103 | 2006-05-04 | 2006-05-18 |
1806964 | 1806964 | Y1206_HRB82 | Y1206_HRB82 | Jena HRB 82 | Jena | Y1206 | 2008-01-16 | |
305531 | 305531 | Y1206_HRB519816 | Y1206_HRB519816 | Jena HRB 519816 | Jena | Y1206 | 2022-08-01 | |
2391411 | 2391411 | Y1206_HRB519815 | Y1206_HRB519815 | Jena HRB 519815 | Jena | Y1206 | 2022-08-01 | |
915045 | 915045 | Y1206_HRB519810 | Y1206_HRB519810 | Jena HRB 519810 | Jena | Y1206 | 2022-07-29 | |
2099514 | 2099514 | Y1206_HRB519809 | Y1206_HRB519809 | Jena HRB 519809 | Jena | Y1206 | 2022-07-29 | |
1219890 | 1219890 | Y1206_HRB519808 | Y1206_HRB519808 | Jena HRB 519808 | Jena | Y1206 | 2022-07-29 | |
1806963 | 1806963 | Y1206_HRB519807 | Y1206_HRB519807 | Jena HRB 519807 | Jena | Y1206 | 2022-07-29 | |
1219889 | 1219889 | Y1206_HRB519806 | Y1206_HRB519806 | Jena HRB 519806 | Jena | Y1206 | 2022-07-29 | |
1806962 | 1806962 | Y1206_HRB519805 | Y1206_HRB519805 | Jena HRB 519805 | Jena | Y1206 | 2022-07-29 | |
1513372 | 1513372 | Y1206_HRB519804 | Y1206_HRB519804 | Jena HRB 519804 | Jena | Y1206 | 2022-07-28 | |
305530 | 305530 | Y1206_HRB519803 | Y1206_HRB519803 | Jena HRB 519803 | Jena | Y1206 | 2022-07-28 | |
610228 | 610228 | Y1206_HRB519802 | Y1206_HRB519802 | Jena HRB 519802 | Jena | Y1206 | 2022-07-28 | |
2440121 | 2440121 | Y1206_HRB519801 | Y1206_HRB519801 | Jena HRB 519801 | Jena | Y1206 | 2022-07-28 | |
305529 | 305529 | Y1206_HRB519800 | Y1206_HRB519800 | Jena HRB 519800 | Jena | Y1206 | 2022-07-27 | |
2099513 | 2099513 | Y1206_HRB519799 | Y1206_HRB519799 | Jena HRB 519799 | Jena | Y1206 | 2022-07-27 | |
610227 | 610227 | Y1206_HRB519798 | Y1206_HRB519798 | Jena HRB 519798 | Jena | Y1206 | 2022-07-26 | |
915044 | 915044 | Y1206_HRB519797 | Y1206_HRB519797 | Jena HRB 519797 | Jena | Y1206 | 2022-07-26 | |
1806961 | 1806961 | Y1206_HRB519796 | Y1206_HRB519796 | Jena HRB 519796 | Jena | Y1206 | 2022-07-26 | |
1806960 | 1806960 | Y1206_HRB519795 | Y1206_HRB519795 | Jena HRB 519795 | Jena | Y1206 | 2022-07-26 | |
2099512 | 2099512 | Y1206_HRB519794 | Y1206_HRB519794 | Jena HRB 519794 | Jena | Y1206 | 2022-07-26 | |
1806959 | 1806959 | Y1206_HRB519793 | Y1206_HRB519793 | Jena HRB 519793 | Jena | Y1206 | 2022-07-26 | |
610226 | 610226 | Y1206_HRB519792 | Y1206_HRB519792 | Jena HRB 519792 | Jena | Y1206 | 2022-07-25 | |
1513371 | 1513371 | Y1206_HRB519791 | Y1206_HRB519791 | Jena HRB 519791 | Jena | Y1206 | 2022-07-25 | |
2099511 | 2099511 | Y1206_HRB519790 | Y1206_HRB519790 | Jena HRB 519790 | Jena | Y1206 | 2022-07-25 | |
1513370 | 1513370 | Y1206_HRB519789 | Y1206_HRB519789 | Jena HRB 519789 | Jena | Y1206 | 2022-07-25 | |
1806958 | 1806958 | Y1206_HRB519788 | Y1206_HRB519788 | Jena HRB 519788 | Jena | Y1206 | 2022-07-25 | |
305528 | 305528 | Y1206_HRB519787 | Y1206_HRB519787 | Jena HRB 519787 | Jena | Y1206 | 2022-07-25 | |
610225 | 610225 | Y1206_HRB519786 | Y1206_HRB519786 | Jena HRB 519786 | Jena | Y1206 | 2022-07-25 | |
1219888 | 1219888 | Y1206_HRB519785 | Y1206_HRB519785 | Jena HRB 519785 | Jena | Y1206 | 2022-07-25 | |
2099510 | 2099510 | Y1206_HRB519784 | Y1206_HRB519784 | Jena HRB 519784 | Jena | Y1206 | 2022-07-22 | |
2099509 | 2099509 | Y1206_HRB519782 | Y1206_HRB519782 | Jena HRB 519782 | Jena | Y1206 | 2022-07-22 | |
2099508 | 2099508 | Y1206_HRB519781 | Y1206_HRB519781 | Jena HRB 519781 | Jena | Y1206 | 2022-07-21 | |
1806957 | 1806957 | Y1206_HRB519780 | Y1206_HRB519780 | Jena HRB 519780 | Jena | Y1206 | 2022-07-21 | |
1513369 | 1513369 | Y1206_HRB519778 | Y1206_HRB519778 | Jena HRB 519778 | Jena | Y1206 | 2022-07-21 | |
1513368 | 1513368 | Y1206_HRB519777 | Y1206_HRB519777 | Jena HRB 519777 | Jena | Y1206 | 2022-07-21 | |
2099507 | 2099507 | Y1206_HRB519776 | Y1206_HRB519776 | Jena HRB 519776 | Jena | Y1206 | 2022-07-21 | |
2391410 | 2391410 | Y1206_HRB519774 | Y1206_HRB519774 | Jena HRB 519774 | Jena | Y1206 | 2022-07-20 | |
610224 | 610224 | Y1206_HRB519773 | Y1206_HRB519773 | Jena HRB 519773 | Jena | Y1206 | 2022-07-20 | |
1219887 | 1219887 | Y1206_HRB519772 | Y1206_HRB519772 | Jena HRB 519772 | Jena | Y1206 | 2022-07-20 | |
1513367 | 1513367 | Y1206_HRB519771 | Y1206_HRB519771 | Jena HRB 519771 | Jena | Y1206 | 2022-07-20 | |
1806956 | 1806956 | Y1206_HRB519770 | Y1206_HRB519770 | Jena HRB 519770 | Jena | Y1206 | 2022-07-20 | |
1513366 | 1513366 | Y1206_HRB519768 | Y1206_HRB519768 | Jena HRB 519768 | Jena | Y1206 | 2022-07-20 | |
1219886 | 1219886 | Y1206_HRB519766 | Y1206_HRB519766 | Jena HRB 519766 | Jena | Y1206 | 2022-07-20 | |
1513365 | 1513365 | Y1206_HRB519765 | Y1206_HRB519765 | Jena HRB 519765 | Jena | Y1206 | 2022-07-19 | |
915043 | 915043 | Y1206_HRB519764 | Y1206_HRB519764 | Jena HRB 519764 | Jena | Y1206 | 2022-07-19 | |
610223 | 610223 | Y1206_HRB519763 | Y1206_HRB519763 | Jena HRB 519763 | Jena | Y1206 | 2022-07-19 | |
305527 | 305527 | Y1206_HRB519762 | Y1206_HRB519762 | Jena HRB 519762 | Jena | Y1206 | 2022-07-19 | |
2099506 | 2099506 | Y1206_HRB519761 | Y1206_HRB519761 | Jena HRB 519761 | Jena | Y1206 | 2022-07-18 | |
305526 | 305526 | Y1206_HRB519760 | Y1206_HRB519760 | Jena HRB 519760 | Jena | Y1206 | 2022-07-18 | |
1513364 | 1513364 | Y1206_HRB519759 | Y1206_HRB519759 | Jena HRB 519759 | Jena | Y1206 | 2022-07-18 | |
2440120 | 2440120 | Y1206_HRB519758 | Y1206_HRB519758 | Jena HRB 519758 | Jena | Y1206 | 2022-07-15 | |
1219885 | 1219885 | Y1206_HRB519757 | Y1206_HRB519757 | Jena HRB 519757 | Jena | Y1206 | 2022-07-15 | |
1513363 | 1513363 | Y1206_HRB519756 | Y1206_HRB519756 | Jena HRB 519756 | Jena | Y1206 | 2022-07-15 | |
2099505 | 2099505 | Y1206_HRB519755 | Y1206_HRB519755 | Jena HRB 519755 | Jena | Y1206 | 2022-07-15 | |
1513362 | 1513362 | Y1206_HRB519754 | Y1206_HRB519754 | Jena HRB 519754 | Jena | Y1206 | 2022-07-15 | |
1219884 | 1219884 | Y1206_HRB519753 | Y1206_HRB519753 | Jena HRB 519753 | Jena | Y1206 | 2022-07-15 | |
1806955 | 1806955 | Y1206_HRB519752 | Y1206_HRB519752 | Jena HRB 519752 | Jena | Y1206 | 2022-07-15 | |
2391409 | 2391409 | Y1206_HRB519751 | Y1206_HRB519751 | Jena HRB 519751 | Jena | Y1206 | 2022-07-14 | |
1806954 | 1806954 | Y1206_HRB519749 | Y1206_HRB519749 | Jena HRB 519749 | Jena | Y1206 | 2022-07-14 | |
915042 | 915042 | Y1206_HRB519748 | Y1206_HRB519748 | Jena HRB 519748 | Jena | Y1206 | 2022-07-14 | |
1806953 | 1806953 | Y1206_HRB519747 | Y1206_HRB519747 | Jena HRB 519747 | Jena | Y1206 | 2022-07-14 | |
1806952 | 1806952 | Y1206_HRB519746 | Y1206_HRB519746 | Jena HRB 519746 | Jena | Y1206 | 2022-07-14 | |
2391408 | 2391408 | Y1206_HRB519745 | Y1206_HRB519745 | Jena HRB 519745 | Jena | Y1206 | 2022-07-13 | |
2391407 | 2391407 | Y1206_HRB519744 | Y1206_HRB519744 | Jena HRB 519744 | Jena | Y1206 | 2022-07-13 | |
1219883 | 1219883 | Y1206_HRB519743 | Y1206_HRB519743 | Jena HRB 519743 | Jena | Y1206 | 2022-07-13 | |
2099504 | 2099504 | Y1206_HRB519742 | Y1206_HRB519742 | Jena HRB 519742 | Jena | Y1206 | 2022-07-13 | |
2099503 | 2099503 | Y1206_HRB519741 | Y1206_HRB519741 | Jena HRB 519741 | Jena | Y1206 | 2022-07-13 | |
915041 | 915041 | Y1206_HRB519740 | Y1206_HRB519740 | Jena HRB 519740 | Jena | Y1206 | 2022-07-13 | |
1219882 | 1219882 | Y1206_HRB519739 | Y1206_HRB519739 | Jena HRB 519739 | Jena | Y1206 | 2022-07-12 | |
1806951 | 1806951 | Y1206_HRB519738 | Y1206_HRB519738 | Jena HRB 519738 | Jena | Y1206 | 2022-07-12 | |
2391406 | 2391406 | Y1206_HRB519737 | Y1206_HRB519737 | Jena HRB 519737 | Jena | Y1206 | 2022-07-12 | |
2099502 | 2099502 | Y1206_HRB519736 | Y1206_HRB519736 | Jena HRB 519736 | Jena | Y1206 | 2022-07-12 | |
2099501 | 2099501 | Y1206_HRB519735 | Y1206_HRB519735 | Jena HRB 519735 | Jena | Y1206 | 2022-07-12 | |
2099500 | 2099500 | Y1206_HRB519734 | Y1206_HRB519734 | Jena HRB 519734 | Jena | Y1206 | 2022-07-11 | |
2099499 | 2099499 | Y1206_HRB519733 | Y1206_HRB519733 | Jena HRB 519733 | Jena | Y1206 | 2022-07-11 | |
1806950 | 1806950 | Y1206_HRB519732 | Y1206_HRB519732 | Jena HRB 519732 | Jena | Y1206 | 2022-07-11 | |
1219881 | 1219881 | Y1206_HRB519731 | Y1206_HRB519731 | Jena HRB 519731 | Jena | Y1206 | 2022-07-11 | |
610222 | 610222 | Y1206_HRB519730 | Y1206_HRB519730 | Jena HRB 519730 | Jena | Y1206 | 2022-07-11 | |
2099498 | 2099498 | Y1206_HRB519729 | Y1206_HRB519729 | Jena HRB 519729 | Jena | Y1206 | 2022-07-11 | |
915040 | 915040 | Y1206_HRB519728 | Y1206_HRB519728 | Jena HRB 519728 | Jena | Y1206 | 2022-07-08 | |
1219880 | 1219880 | Y1206_HRB519727 | Y1206_HRB519727 | Jena HRB 519727 | Jena | Y1206 | 2022-07-08 | |
1806949 | 1806949 | Y1206_HRB519726 | Y1206_HRB519726 | Jena HRB 519726 | Jena | Y1206 | 2022-07-08 | |
2391405 | 2391405 | Y1206_HRB519725 | Y1206_HRB519725 | Jena HRB 519725 | Jena | Y1206 | 2022-07-08 | |
915039 | 915039 | Y1206_HRB519724 | Y1206_HRB519724 | Jena HRB 519724 | Jena | Y1206 | 2022-07-08 | |
610221 | 610221 | Y1206_HRB519723 | Y1206_HRB519723 | Jena HRB 519723 | Jena | Y1206 | 2022-07-08 | |
1513361 | 1513361 | Y1206_HRB519722 | Y1206_HRB519722 | Jena HRB 519722 | Jena | Y1206 | 2022-07-07 | |
610220 | 610220 | Y1206_HRB519721 | Y1206_HRB519721 | Jena HRB 519721 | Jena | Y1206 | 2022-07-07 | |
1219879 | 1219879 | Y1206_HRB519720 | Y1206_HRB519720 | Jena HRB 519720 | Jena | Y1206 | 2022-07-07 |
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" );