person_statement

10 rows where birthdate = "2011-03-29", "birthdate" is on date 2011-03-29 and statementdate = "2023-11-01"

✎ View and edit SQL

This data as json, CSV (advanced)

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

_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
113951 personStatement 2011-03-29 12110644585673323638 false 2023-11-01 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-11-01 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-11-01 officialRegister https://rpvs.gov.sk/OpenData/Partneri
113967 personStatement 2011-03-29 13404829257627457932 false 2023-11-01 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-11-01 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-11-01 officialRegister https://rpvs.gov.sk/OpenData/Partneri
113978 personStatement 2011-03-29 1417199676651629202 false 2023-11-01 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-11-01 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-11-01 officialRegister https://rpvs.gov.sk/OpenData/Partneri
113987 personStatement 2011-03-29 15539703772587757932 false 2023-11-01 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-11-01 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-11-01 officialRegister https://rpvs.gov.sk/OpenData/Partneri
114029 personStatement 2011-03-29 2337215743585794323 false 2023-11-01 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-11-01 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-11-01 officialRegister https://rpvs.gov.sk/OpenData/Partneri
114037 personStatement 2011-03-29 300853344424630256 false 2023-11-01 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-11-01 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-11-01 officialRegister https://rpvs.gov.sk/OpenData/Partneri
114048 personStatement 2011-03-29 3979296579059836019 false 2023-11-01 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-11-01 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-11-01 officialRegister https://rpvs.gov.sk/OpenData/Partneri
114089 personStatement 2011-03-29 72055486623525959 false 2023-11-01 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-11-01 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-11-01 officialRegister https://rpvs.gov.sk/OpenData/Partneri
114165 personStatement 2011-03-29 12570983802468962320 false 2023-11-01 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-11-01 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-11-01 officialRegister https://rpvs.gov.sk/OpenData/Partneri
114320 personStatement 2011-03-29 4626187075864859193 false 2023-11-01 knownPerson 0.2 https://register.openownership.org/terms-and-conditions 2023-11-01 OpenOwnership Register https://register.openownership.org   SK Register Partnerov Verejného Sektora 2023-11-01 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]) 
);