home / uk_version_0_4

entity_annotations

5,626,630 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: creationdate (date)

_link ▼ _link_entity_statement motivation description statementpointertarget creationdate url createdby_name createdby_uri
1000.annotations.0 1000 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/11094128 Open Ownership https://www.openownership.org
10000.annotations.0 10000 commenting Company Entity Status: Active - Proposal to Strike off   2025-03-05 http://business.data.gov.uk/id/company/13006026 Open Ownership https://www.openownership.org
100000.annotations.0 100000 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/CE028124 Open Ownership https://www.openownership.org
1000000.annotations.0 1000000 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/15980164 Open Ownership https://www.openownership.org
1000001.annotations.0 1000001 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/10515913 Open Ownership https://www.openownership.org
1000002.annotations.0 1000002 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/08976899 Open Ownership https://www.openownership.org
1000003.annotations.0 1000003 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/06828838 Open Ownership https://www.openownership.org
1000004.annotations.0 1000004 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/04458744 Open Ownership https://www.openownership.org
1000005.annotations.0 1000005 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/09535698 Open Ownership https://www.openownership.org
1000006.annotations.0 1000006 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/05188159 Open Ownership https://www.openownership.org
1000007.annotations.0 1000007 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/15712250 Open Ownership https://www.openownership.org
1000008.annotations.0 1000008 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/10433917 Open Ownership https://www.openownership.org
1000009.annotations.0 1000009 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/12014122 Open Ownership https://www.openownership.org
100001.annotations.0 100001 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/10921002 Open Ownership https://www.openownership.org
1000010.annotations.0 1000010 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/15881944 Open Ownership https://www.openownership.org
1000011.annotations.0 1000011 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/14796414 Open Ownership https://www.openownership.org
1000012.annotations.0 1000012 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/07705531 Open Ownership https://www.openownership.org
1000013.annotations.0 1000013 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/15044834 Open Ownership https://www.openownership.org
1000014.annotations.0 1000014 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/12807075 Open Ownership https://www.openownership.org
1000015.annotations.0 1000015 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/06512238 Open Ownership https://www.openownership.org
1000016.annotations.0 1000016 commenting Company Entity Status: Active - Proposal to Strike off   2025-03-05 http://business.data.gov.uk/id/company/NI658783 Open Ownership https://www.openownership.org
1000017.annotations.0 1000017 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/08569237 Open Ownership https://www.openownership.org
1000018.annotations.0 1000018 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/08605250 Open Ownership https://www.openownership.org
1000019.annotations.0 1000019 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/15907888 Open Ownership https://www.openownership.org
100002.annotations.0 100002 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/09008842 Open Ownership https://www.openownership.org
1000020.annotations.0 1000020 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/13725853 Open Ownership https://www.openownership.org
1000021.annotations.0 1000021 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/08777696 Open Ownership https://www.openownership.org
1000022.annotations.0 1000022 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/08396252 Open Ownership https://www.openownership.org
1000023.annotations.0 1000023 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/13732675 Open Ownership https://www.openownership.org
1000024.annotations.0 1000024 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/15688414 Open Ownership https://www.openownership.org
1000025.annotations.0 1000025 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/14847677 Open Ownership https://www.openownership.org
1000026.annotations.0 1000026 commenting Company Entity Status: Active - Proposal to Strike off   2025-03-05 http://business.data.gov.uk/id/company/11685625 Open Ownership https://www.openownership.org
1000027.annotations.0 1000027 commenting Company Entity Status: Active - Proposal to Strike off   2025-03-05 http://business.data.gov.uk/id/company/07214814 Open Ownership https://www.openownership.org
1000028.annotations.0 1000028 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/09096262 Open Ownership https://www.openownership.org
1000029.annotations.0 1000029 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/05279520 Open Ownership https://www.openownership.org
100003.annotations.0 100003 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/11511826 Open Ownership https://www.openownership.org
1000030.annotations.0 1000030 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/07856887 Open Ownership https://www.openownership.org
1000031.annotations.0 1000031 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/10077253 Open Ownership https://www.openownership.org
1000032.annotations.0 1000032 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/04675506 Open Ownership https://www.openownership.org
1000033.annotations.0 1000033 commenting Company Entity Status: Liquidation   2025-03-05 http://business.data.gov.uk/id/company/05382501 Open Ownership https://www.openownership.org
1000034.annotations.0 1000034 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/05628666 Open Ownership https://www.openownership.org
1000035.annotations.0 1000035 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/09340502 Open Ownership https://www.openownership.org
1000036.annotations.0 1000036 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/09809236 Open Ownership https://www.openownership.org
1000037.annotations.0 1000037 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/07172818 Open Ownership https://www.openownership.org
1000038.annotations.0 1000038 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/04379392 Open Ownership https://www.openownership.org
1000039.annotations.0 1000039 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/05579352 Open Ownership https://www.openownership.org
100004.annotations.0 100004 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/09472455 Open Ownership https://www.openownership.org
1000040.annotations.0 1000040 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/16204799 Open Ownership https://www.openownership.org
1000041.annotations.0 1000041 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/02327235 Open Ownership https://www.openownership.org
1000042.annotations.0 1000042 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/15753640 Open Ownership https://www.openownership.org
1000043.annotations.0 1000043 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/11542946 Open Ownership https://www.openownership.org
1000044.annotations.0 1000044 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/03510837 Open Ownership https://www.openownership.org
1000045.annotations.0 1000045 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/03273043 Open Ownership https://www.openownership.org
1000046.annotations.0 1000046 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/11628016 Open Ownership https://www.openownership.org
1000047.annotations.0 1000047 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/08193625 Open Ownership https://www.openownership.org
1000048.annotations.0 1000048 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/08589640 Open Ownership https://www.openownership.org
1000049.annotations.0 1000049 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/05104080 Open Ownership https://www.openownership.org
100005.annotations.0 100005 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/05195168 Open Ownership https://www.openownership.org
1000050.annotations.0 1000050 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/09867655 Open Ownership https://www.openownership.org
1000051.annotations.0 1000051 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/09021924 Open Ownership https://www.openownership.org
1000052.annotations.0 1000052 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/13292638 Open Ownership https://www.openownership.org
1000053.annotations.0 1000053 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/07161552 Open Ownership https://www.openownership.org
1000054.annotations.0 1000054 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/07159629 Open Ownership https://www.openownership.org
1000055.annotations.0 1000055 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/07498881 Open Ownership https://www.openownership.org
1000056.annotations.0 1000056 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/07745632 Open Ownership https://www.openownership.org
1000057.annotations.0 1000057 commenting Company Entity Status: Active - Proposal to Strike off   2025-03-05 http://business.data.gov.uk/id/company/08922758 Open Ownership https://www.openownership.org
1000058.annotations.0 1000058 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/03607262 Open Ownership https://www.openownership.org
1000059.annotations.0 1000059 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/08791142 Open Ownership https://www.openownership.org
100006.annotations.0 100006 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/14244209 Open Ownership https://www.openownership.org
1000060.annotations.0 1000060 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/08743370 Open Ownership https://www.openownership.org
1000061.annotations.0 1000061 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/12391442 Open Ownership https://www.openownership.org
1000062.annotations.0 1000062 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/07777190 Open Ownership https://www.openownership.org
1000063.annotations.0 1000063 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/15617214 Open Ownership https://www.openownership.org
1000064.annotations.0 1000064 commenting Company Entity Status: Active - Proposal to Strike off   2025-03-05 http://business.data.gov.uk/id/company/08929993 Open Ownership https://www.openownership.org
1000065.annotations.0 1000065 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/08438819 Open Ownership https://www.openownership.org
1000066.annotations.0 1000066 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/10667585 Open Ownership https://www.openownership.org
1000067.annotations.0 1000067 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/08617040 Open Ownership https://www.openownership.org
1000068.annotations.0 1000068 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/11444310 Open Ownership https://www.openownership.org
1000069.annotations.0 1000069 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/07777121 Open Ownership https://www.openownership.org
100007.annotations.0 100007 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/15663297 Open Ownership https://www.openownership.org
1000070.annotations.0 1000070 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/15052883 Open Ownership https://www.openownership.org
1000071.annotations.0 1000071 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/15577751 Open Ownership https://www.openownership.org
1000072.annotations.0 1000072 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/09865428 Open Ownership https://www.openownership.org
1000073.annotations.0 1000073 commenting Company Entity Status: Active - Proposal to Strike off   2025-03-05 http://business.data.gov.uk/id/company/13954146 Open Ownership https://www.openownership.org
1000074.annotations.0 1000074 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/07298705 Open Ownership https://www.openownership.org
1000075.annotations.0 1000075 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/15565501 Open Ownership https://www.openownership.org
1000076.annotations.0 1000076 commenting Company Entity Status: Active - Proposal to Strike off   2025-03-05 http://business.data.gov.uk/id/company/12168121 Open Ownership https://www.openownership.org
1000077.annotations.0 1000077 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/08174095 Open Ownership https://www.openownership.org
1000078.annotations.0 1000078 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/07874105 Open Ownership https://www.openownership.org
1000079.annotations.0 1000079 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/14115033 Open Ownership https://www.openownership.org
100008.annotations.0 100008 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/02241270 Open Ownership https://www.openownership.org
1000080.annotations.0 1000080 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/15169742 Open Ownership https://www.openownership.org
1000081.annotations.0 1000081 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/11015254 Open Ownership https://www.openownership.org
1000082.annotations.0 1000082 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/05219798 Open Ownership https://www.openownership.org
1000083.annotations.0 1000083 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/08136261 Open Ownership https://www.openownership.org
1000084.annotations.0 1000084 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/07210076 Open Ownership https://www.openownership.org
1000085.annotations.0 1000085 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/06597146 Open Ownership https://www.openownership.org
1000086.annotations.0 1000086 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/12040968 Open Ownership https://www.openownership.org
1000087.annotations.0 1000087 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/05104082 Open Ownership https://www.openownership.org
1000088.annotations.0 1000088 commenting Company Entity Status: Active   2025-03-05 http://business.data.gov.uk/id/company/12687108 Open Ownership https://www.openownership.org

Next page

Advanced export

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

CSV options:

CREATE TABLE [entity_annotations] ( [_link] TEXT 
 , [_link_entity_statement] TEXT 
 , [motivation] TEXT 
 , [description] TEXT 
 , [statementpointertarget] BOOL 
 , [creationdate] TIMESTAMP 
 , [url] TEXT 
 , [createdby_name] TEXT 
 , [createdby_uri] TEXT 
 , PRIMARY KEY ([_link]) 
 , FOREIGN KEY ([_link_entity_statement]) REFERENCES [entity_statement]([_link]) 
   );
Powered by Datasette · Queries took 990.109ms