person_statement

70 rows where source_retrievedat = "2023-09-05"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate (date), source_retrievedat (date)

source_retrievedat 1 ✖

  • 2023-09-05 · 70 ✖

publicationdetails_publicationdate (date) 1 ✖

_link ▼ statementtype birthdate statementid iscomponent statementdate persontype publicationdetails_bodsversion publicationdetails_license publicationdetails_publicationdate publicationdetails_publisher_name publicationdetails_publisher_url source_assertedby source_description source_retrievedat source_type source_url
109728 personStatement 1971-12-28 10128407760022196472 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109729 personStatement 1980-06-22 10149702003990003330 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109730 personStatement 1970-01-28 10224009737637273381 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109731 personStatement 1966-08-12 10235807353741408650 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109732 personStatement 1991-10-29 10636826204707212836 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109733 personStatement 1971-10-04 10718662865738206847 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109734 personStatement 1965-09-26 11078159018069587839 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109735 personStatement 1957-06-26 11820835948966982156 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109736 personStatement 1984-12-17 13105558433834310128 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109737 personStatement 1971-07-26 13358278426672056918 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109738 personStatement 1961-10-31 13575461652967943368 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109739 personStatement 1978-06-12 13885070149448390443 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109740 personStatement 1984-09-24 13980362885621457679 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109741 personStatement 1963-01-23 14024617826151984722 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109742 personStatement 2007-12-11 14351569328050358182 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109743 personStatement 1963-03-18 14454101600895724234 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109744 personStatement 1970-09-02 14863226397497824835 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109745 personStatement 1985-06-26 14962690497441869942 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109746 personStatement 1982-10-01 15025476030913606806 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109747 personStatement 1961-05-23 15124525490167441121 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109748 personStatement 1981-07-12 1515207198585275369 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109749 personStatement 1943-12-17 15264786539115753982 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109750 personStatement 1960-11-24 15432922943803518779 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109751 personStatement 1966-08-13 15646370260767608145 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109752 personStatement 1980-03-10 15685917790742238877 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109753 personStatement 1965-02-04 16056580450933231413 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109754 personStatement 1975-06-24 16469602017522162570 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109755 personStatement 1982-04-08 16734355316743811292 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109756 personStatement 1958-02-18 17061441518979439158 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109757 personStatement 1965-02-11 17284315504297498502 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109758 personStatement 1976-10-09 17357124397599108419 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109759 personStatement 1975-05-04 17601949468254508841 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109760 personStatement 1957-03-12 17669092154232056729 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109761 personStatement 1965-05-24 226394574084716859 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109762 personStatement 1973-11-10 2594009385268426731 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109763 personStatement 1966-03-21 2655000862212946837 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109764 personStatement 1988-12-26 3028855172970819648 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109765 personStatement 1962-06-26 3667596016874501778 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109766 personStatement 1968-01-13 3687813383716162522 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109767 personStatement 1971-05-08 3748390234403080174 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109768 personStatement 1977-08-13 4393472910619893512 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109769 personStatement 1987-03-06 4414469619768546563 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109770 personStatement 1981-02-23 4536243065002495854 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109771 personStatement 1962-09-30 4701384155525938117 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109772 personStatement 1941-12-07 4799731226469979664 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109773 personStatement 1960-02-15 4901402771678339358 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109774 personStatement 1984-09-24 4983513351020375178 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109775 personStatement 1978-05-18 5018499326391632535 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109776 personStatement 1976-10-29 5524560281464362065 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109777 personStatement 1963-09-01 5754144241614964520 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109778 personStatement 1957-06-10 5804310038355868341 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109779 personStatement 1958-12-30 5834509325723126630 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109780 personStatement 1957-03-27 5986762896158881951 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109781 personStatement 1972-11-11 62352735195054893 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109782 personStatement 1980-07-19 6512610604468633801 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109783 personStatement 1957-11-25 6834670529539730020 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109784 personStatement 1974-09-15 6990887466079436108 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109785 personStatement 1985-03-08 7253780114062832053 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109786 personStatement 1972-04-25 7288508178590701851 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109787 personStatement 1996-07-12 7326226149454726885 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109788 personStatement 1975-03-06 7342788405813828878 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109789 personStatement 1956-09-29 7605568240858551611 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109790 personStatement 1957-02-08 7921104722143235957 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109791 personStatement 1984-11-20 8423772296708783101 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109792 personStatement 1943-12-17 8616437393321126973 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109793 personStatement 1983-09-27 8932497709888894975 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109794 personStatement 2000-02-14 9050771130866882296 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109795 personStatement 1997-07-03 9206468967243554546 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109796 personStatement 1964-03-05 9660149848568487237 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri
109797 personStatement 1975-03-25 9863817342071150410 false 2023-09-05 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-09-05 officialRegister https://rpvs.gov.sk/OpenData/Partneri

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [person_statement] ( [_link] TEXT 
 , [statementtype] TEXT 
 , [birthdate] TIMESTAMP 
 , [statementid] TEXT 
 , [iscomponent] BOOL 
 , [statementdate] TIMESTAMP 
 , [persontype] TEXT 
 , [publicationdetails_bodsversion] NUMERIC 
 , [publicationdetails_license] TEXT 
 , [publicationdetails_publicationdate] TIMESTAMP 
 , [publicationdetails_publisher_name] TEXT 
 , [publicationdetails_publisher_url] TEXT 
 , [source_assertedby] BOOL 
 , [source_description] TEXT 
 , [source_retrievedat] TIMESTAMP 
 , [source_type] TEXT 
 , [source_url] TEXT 
 , PRIMARY KEY ([_link]) 
);