ReferenceNumbers
Data license: CC-By 4.0
2,440,122 rows sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | companyId | stdRefNo | nativeReferenceNumber | courtName | courtCode | referenceNumberFirstSeen | validTill |
---|---|---|---|---|---|---|---|---|
2439922 | 2439922 | Y1206_HRB509091 | Y1206_HRB509091 | Jena HRB 509091 | Jena | Y1206 | 2013-05-13 | |
2439921 | 2439921 | Y1206_HRB508908 | Y1206_HRB508908 | Jena HRB 508908 | Jena | Y1206 | 2013-03-13 | |
2439920 | 2439920 | Y1206_HRB508813 | Y1206_HRB508813 | Jena HRB 508813 | Jena | Y1206 | 2013-02-12 | |
2439919 | 2439919 | Y1206_HRB508739 | Y1206_HRB508739 | Jena HRB 508739 | Jena | Y1206 | 2013-01-24 | |
2439918 | 2439918 | Y1206_HRB508735 | Y1206_HRB508735 | Jena HRB 508735 | Jena | Y1206 | 2013-01-24 | |
2439917 | 2439917 | Y1206_HRB508606-W1215_HRB24727 | W1215_HRB24727 | Stendal HRB 24727 | Stendal | W1215 | 2017-08-25 | |
2439916 | 2439916 | Y1206_HRB508606-W1215_HRB24727 | Y1206_HRB508606 | Jena HRB 508606 | Jena | Y1206 | 2012-12-18 | 2017-08-25 |
2439915 | 2439915 | Y1206_HRB508586 | Y1206_HRB508586 | Jena HRB 508586 | Jena | Y1206 | 2012-12-12 | |
2439914 | 2439914 | Y1206_HRB508567 | Y1206_HRB508567 | Jena HRB 508567 | Jena | Y1206 | 2012-12-10 | |
2439913 | 2439913 | Y1206_HRB508398 | Y1206_HRB508398 | Jena HRB 508398 | Jena | Y1206 | 2012-10-05 | |
2439912 | 2439912 | Y1206_HRB508388 | Y1206_HRB508388 | Jena HRB 508388 | Jena | Y1206 | 2012-10-02 | |
2439911 | 2439911 | Y1206_HRB508372 | Y1206_HRB508372 | Jena HRB 508372 | Jena | Y1206 | 2012-09-25 | |
2439910 | 2439910 | Y1206_HRB508350 | Y1206_HRB508350 | Jena HRB 508350 | Jena | Y1206 | 2012-09-19 | |
2439909 | 2439909 | Y1206_HRB508240 | Y1206_HRB508240 | Jena HRB 508240 | Jena | Y1206 | 2012-08-22 | |
2439908 | 2439908 | Y1206_HRB507966 | Y1206_HRB507966 | Jena HRB 507966 | Jena | Y1206 | 2012-05-24 | |
2439907 | 2439907 | Y1206_HRB507922 | Y1206_HRB507922 | Jena HRB 507922 | Jena | Y1206 | 2012-05-10 | |
2439906 | 2439906 | Y1206_HRB507897 | Y1206_HRB507897 | Jena HRB 507897 | Jena | Y1206 | 2012-05-03 | |
2439905 | 2439905 | Y1206_HRB507893 | Y1206_HRB507893 | Jena HRB 507893 | Jena | Y1206 | 2012-05-03 | |
2439904 | 2439904 | Y1206_HRB507862 | Y1206_HRB507862 | Jena HRB 507862 | Jena | Y1206 | 2012-04-25 | |
2439903 | 2439903 | Y1206_HRB507814 | Y1206_HRB507814 | Jena HRB 507814 | Jena | Y1206 | 2012-04-03 | |
2439902 | 2439902 | Y1206_HRB507753 | Y1206_HRB507753 | Jena HRB 507753 | Jena | Y1206 | 2012-03-14 | |
2439901 | 2439901 | Y1206_HRB507684 | Y1206_HRB507684 | Jena HRB 507684 | Jena | Y1206 | 2012-02-22 | |
2439900 | 2439900 | Y1206_HRB507640 | Y1206_HRB507640 | Jena HRB 507640 | Jena | Y1206 | 2012-02-07 | |
2439899 | 2439899 | Y1206_HRB507571 | Y1206_HRB507571 | Jena HRB 507571 | Jena | Y1206 | 2012-01-24 | |
2439898 | 2439898 | Y1206_HRB507559 | Y1206_HRB507559 | Jena HRB 507559 | Jena | Y1206 | 2012-01-19 | |
2439897 | 2439897 | Y1206_HRB507552 | Y1206_HRB507552 | Jena HRB 507552 | Jena | Y1206 | 2012-01-18 | |
2439896 | 2439896 | Y1206_HRB507533 | Y1206_HRB507533 | Jena HRB 507533 | Jena | Y1206 | 2012-01-16 | |
2439895 | 2439895 | Y1206_HRB507463 | Y1206_HRB507463 | Jena HRB 507463 | Jena | Y1206 | 2011-12-29 | |
2439894 | 2439894 | Y1206_HRB507429 | Y1206_HRB507429 | Jena HRB 507429 | Jena | Y1206 | 2011-12-27 | |
2439893 | 2439893 | Y1206_HRB507319 | Y1206_HRB507319 | Jena HRB 507319 | Jena | Y1206 | 2011-11-24 | |
2439892 | 2439892 | Y1206_HRB507299 | Y1206_HRB507299 | Jena HRB 507299 | Jena | Y1206 | 2011-11-16 | |
2439891 | 2439891 | Y1206_HRB507262 | Y1206_HRB507262 | Jena HRB 507262 | Jena | Y1206 | 2011-11-03 | |
2439890 | 2439890 | Y1206_HRB507203 | Y1206_HRB507203 | Jena HRB 507203 | Jena | Y1206 | 2011-10-14 | |
2439889 | 2439889 | Y1206_HRB507169 | Y1206_HRB507169 | Jena HRB 507169 | Jena | Y1206 | 2011-09-30 | |
2439888 | 2439888 | Y1206_HRB507119 | Y1206_HRB507119 | Jena HRB 507119 | Jena | Y1206 | 2011-09-15 | |
2439887 | 2439887 | Y1206_HRB506900 | Y1206_HRB506900 | Jena HRB 506900 | Jena | Y1206 | 2011-07-14 | |
2439886 | 2439886 | Y1206_HRB506819 | Y1206_HRB506819 | Jena HRB 506819 | Jena | Y1206 | 2011-06-20 | |
2439885 | 2439885 | Y1206_HRB506700 | Y1206_HRB506700 | Jena HRB 506700 | Jena | Y1206 | 2011-05-12 | |
2439884 | 2439884 | Y1206_HRB506655 | Y1206_HRB506655 | Jena HRB 506655 | Jena | Y1206 | 2011-04-27 | |
2439883 | 2439883 | Y1206_HRB506629 | Y1206_HRB506629 | Jena HRB 506629 | Jena | Y1206 | 2011-04-14 | |
2439882 | 2439882 | Y1206_HRB506392 | Y1206_HRB506392 | Jena HRB 506392 | Jena | Y1206 | 2011-02-03 | |
2439881 | 2439881 | Y1206_HRB506301-D3310_HRB31542 | D3310_HRB31542 | Nürnberg HRB 31542 | Nürnberg | D3310 | 2015-03-06 | |
2439880 | 2439880 | Y1206_HRB506301-D3310_HRB31542 | Y1206_HRB506301 | Jena HRB 506301 | Jena | Y1206 | 2011-01-14 | 2015-03-06 |
2439879 | 2439879 | Y1206_HRB506159 | Y1206_HRB506159 | Jena HRB 506159 | Jena | Y1206 | 2010-12-13 | |
2439878 | 2439878 | Y1206_HRB506144 | Y1206_HRB506144 | Jena HRB 506144 | Jena | Y1206 | 2010-12-08 | |
2439877 | 2439877 | Y1206_HRB506139 | Y1206_HRB506139 | Jena HRB 506139 | Jena | Y1206 | 2010-12-07 | |
2439876 | 2439876 | Y1206_HRB506107 | Y1206_HRB506107 | Jena HRB 506107 | Jena | Y1206 | 2010-11-23 | |
2439875 | 2439875 | Y1206_HRB505840 | Y1206_HRB505840 | Jena HRB 505840 | Jena | Y1206 | 2010-09-03 | |
2439874 | 2439874 | Y1206_HRB505815 | Y1206_HRB505815 | Jena HRB 505815 | Jena | Y1206 | 2010-08-31 | |
2439873 | 2439873 | Y1206_HRB505794 | Y1206_HRB505794 | Jena HRB 505794 | Jena | Y1206 | 2010-08-25 | |
2439872 | 2439872 | Y1206_HRB505770 | Y1206_HRB505770 | Jena HRB 505770 | Jena | Y1206 | 2010-08-19 | |
2439871 | 2439871 | Y1206_HRB505740 | Y1206_HRB505740 | Jena HRB 505740 | Jena | Y1206 | 2010-08-11 | |
2439870 | 2439870 | Y1206_HRB505675 | Y1206_HRB505675 | Jena HRB 505675 | Jena | Y1206 | 2010-07-26 | |
2439869 | 2439869 | Y1206_HRB505673 | Y1206_HRB505673 | Jena HRB 505673 | Jena | Y1206 | 2010-07-26 | |
2439868 | 2439868 | Y1206_HRB505615-D4608_HRB8724 | D4608_HRB8724 | Schweinfurt HRB 8724 | Schweinfurt | D4608 | 2022-02-04 | |
2439867 | 2439867 | Y1206_HRB505615-D4608_HRB8724 | Y1206_HRB505615 | Jena HRB 505615 | Jena | Y1206 | 2010-07-09 | 2022-02-04 |
2439866 | 2439866 | Y1206_HRB505518-B2609_HRB736014 | B2609_HRB736014 | Stuttgart HRB 736014 | Stuttgart | B2609 | 2010-12-28 | |
2439865 | 2439865 | Y1206_HRB505518-B2609_HRB736014 | Y1206_HRB505518 | Jena HRB 505518 | Jena | Y1206 | 2010-06-10 | 2010-12-28 |
2439864 | 2439864 | Y1206_HRB505464 | Y1206_HRB505464 | Jena HRB 505464 | Jena | Y1206 | 2010-05-27 | |
2439863 | 2439863 | Y1206_HRB505422 | Y1206_HRB505422 | Jena HRB 505422 | Jena | Y1206 | 2010-05-12 | |
2439862 | 2439862 | Y1206_HRB505335-F1103_HRB164675B-D3508_HRB5119 | D3508_HRB5119 | Weiden i. d. OPf (Weiden) HRB 5119 | Weiden i. d. OPf. | D3508 | 2018-08-10 | |
2439861 | 2439861 | Y1206_HRB505335-F1103_HRB164675B-D3508_HRB5119 | F1103_HRB164675B | Charlottenburg (Berlin) HRB 164675 B | Berlin (Charlottenburg) | F1103 | 2015-02-04 | 2018-08-10 |
2439860 | 2439860 | Y1206_HRB505335-F1103_HRB164675B-D3508_HRB5119 | Y1206_HRB505335 | Jena HRB 505335 | Jena | Y1206 | 2010-04-21 | 2015-02-04 |
2439859 | 2439859 | Y1206_HRB505330 | Y1206_HRB505330 | Jena HRB 505330 | Jena | Y1206 | 2010-04-20 | |
2439858 | 2439858 | Y1206_HRB505179 | Y1206_HRB505179 | Jena HRB 505179 | Jena | Y1206 | 2010-03-15 | |
2439857 | 2439857 | Y1206_HRB505133 | Y1206_HRB505133 | Jena HRB 505133 | Jena | Y1206 | 2010-03-03 | |
2439856 | 2439856 | Y1206_HRB504836 | Y1206_HRB504836 | Jena HRB 504836 | Jena | Y1206 | 2009-12-21 | |
2439855 | 2439855 | Y1206_HRB504757 | Y1206_HRB504757 | Jena HRB 504757 | Jena | Y1206 | 2009-12-02 | |
2439854 | 2439854 | Y1206_HRB504736 | Y1206_HRB504736 | Jena HRB 504736 | Jena | Y1206 | 2009-11-27 | |
2439853 | 2439853 | Y1206_HRB504720 | Y1206_HRB504720 | Jena HRB 504720 | Jena | Y1206 | 2009-11-20 | |
2439852 | 2439852 | Y1206_HRB504714 | Y1206_HRB504714 | Jena HRB 504714 | Jena | Y1206 | 2009-11-19 | |
2439851 | 2439851 | Y1206_HRB504657 | Y1206_HRB504657 | Jena HRB 504657 | Jena | Y1206 | 2009-11-02 | |
2439850 | 2439850 | Y1206_HRB504610 | Y1206_HRB504610 | Jena HRB 504610 | Jena | Y1206 | 2009-10-21 | |
2439849 | 2439849 | Y1206_HRB504600 | Y1206_HRB504600 | Jena HRB 504600 | Jena | Y1206 | 2009-10-19 | |
2439848 | 2439848 | Y1206_HRB504582 | Y1206_HRB504582 | Jena HRB 504582 | Jena | Y1206 | 2009-10-13 | |
2439847 | 2439847 | Y1206_HRB504551 | Y1206_HRB504551 | Jena HRB 504551 | Jena | Y1206 | 2009-10-01 | |
2439846 | 2439846 | Y1206_HRB504533 | Y1206_HRB504533 | Jena HRB 504533 | Jena | Y1206 | 2009-09-30 | |
2439845 | 2439845 | Y1206_HRB504498-U1206_HRB26022-R1402_HRB14760 | R1402_HRB14760 | Krefeld HRB 14760 | Krefeld | R1402 | 2014-03-14 | |
2439844 | 2439844 | Y1206_HRB504498-U1206_HRB26022-R1402_HRB14760 | U1206_HRB26022 | Chemnitz HRB 26022 | Chemnitz | U1206 | 2010-08-19 | 2014-03-14 |
2439843 | 2439843 | Y1206_HRB504498-U1206_HRB26022-R1402_HRB14760 | Y1206_HRB504498 | Jena HRB 504498 | Jena | Y1206 | 2009-09-18 | 2010-08-19 |
2439842 | 2439842 | Y1206_HRB504395-U1206_HRB32659 | U1206_HRB32659 | Chemnitz HRB 32659 | Chemnitz | U1206 | 2019-08-21 | |
2439841 | 2439841 | Y1206_HRB504395-U1206_HRB32659 | Y1206_HRB504395 | Jena HRB 504395 | Jena | Y1206 | 2009-08-26 | 2019-08-21 |
2439840 | 2439840 | Y1206_HRB504320 | Y1206_HRB504320 | Jena HRB 504320 | Jena | Y1206 | 2009-08-10 | |
2439839 | 2439839 | Y1206_HRB504318 | Y1206_HRB504318 | Jena HRB 504318 | Jena | Y1206 | 2009-08-10 | |
2439838 | 2439838 | Y1206_HRB504182 | Y1206_HRB504182 | Jena HRB 504182 | Jena | Y1206 | 2009-07-07 | |
2439837 | 2439837 | Y1206_HRB504014-M1710_HRB5872 | M1710_HRB5872 | Wetzlar HRB 5872 | Wetzlar | M1710 | 2009-10-14 | |
2439836 | 2439836 | Y1206_HRB504014-M1710_HRB5872 | Y1206_HRB504014 | Jena HRB 504014 | Jena | Y1206 | 2009-05-28 | 2009-10-14 |
2439835 | 2439835 | Y1206_HRB503964 | Y1206_HRB503964 | Jena HRB 503964 | Jena | Y1206 | 2009-05-15 | |
2439834 | 2439834 | Y1206_HRB503955 | Y1206_HRB503955 | Jena HRB 503955 | Jena | Y1206 | 2009-05-14 | |
2439833 | 2439833 | Y1206_HRB503928 | Y1206_HRB503928 | Jena HRB 503928 | Jena | Y1206 | 2009-05-11 | |
2439832 | 2439832 | Y1206_HRB503841 | Y1206_HRB503841 | Jena HRB 503841 | Jena | Y1206 | 2009-04-20 | |
2439831 | 2439831 | Y1206_HRB503780 | Y1206_HRB503780 | Jena HRB 503780 | Jena | Y1206 | 2009-04-01 | |
2439830 | 2439830 | Y1206_HRB503774 | Y1206_HRB503774 | Jena HRB 503774 | Jena | Y1206 | 2009-04-01 | |
2439829 | 2439829 | Y1206_HRB503633 | Y1206_HRB503633 | Jena HRB 503633 | Jena | Y1206 | 2009-03-03 | |
2439828 | 2439828 | Y1206_HRB503588 | Y1206_HRB503588 | Jena HRB 503588 | Jena | Y1206 | 2009-02-23 | |
2439827 | 2439827 | Y1206_HRB503253 | Y1206_HRB503253 | Jena HRB 503253 | Jena | Y1206 | 2008-12-05 | |
2439826 | 2439826 | Y1206_HRB503222 | Y1206_HRB503222 | Jena HRB 503222 | Jena | Y1206 | 2008-11-28 | |
2439825 | 2439825 | Y1206_HRB503153 | Y1206_HRB503153 | Jena HRB 503153 | Jena | Y1206 | 2008-11-05 | |
2439824 | 2439824 | Y1206_HRB503141 | Y1206_HRB503141 | Jena HRB 503141 | Jena | Y1206 | 2008-10-30 | |
2439823 | 2439823 | Y1206_HRB503140 | Y1206_HRB503140 | Jena HRB 503140 | Jena | Y1206 | 2008-10-29 |
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" );