Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

2,677 rows

View and edit SQL

id ▼ name person_id
uk.org.publicwhip/member/1181 Syd Rapson Syd Rapson uk.org.publicwhip/person/10497
uk.org.publicwhip/member/1182 Nick Raynsford Nick Raynsford uk.org.publicwhip/person/10498
uk.org.publicwhip/member/1183 John Redwood John Redwood uk.org.publicwhip/person/10499
uk.org.publicwhip/member/1184 Andy Reed Andy Reed uk.org.publicwhip/person/10500
uk.org.publicwhip/member/1185 Alan Reid Alan Reid uk.org.publicwhip/person/11185
uk.org.publicwhip/member/1186 John Reid John Reid uk.org.publicwhip/person/10501
uk.org.publicwhip/member/1187 David Rendel David Rendel uk.org.publicwhip/person/10502
uk.org.publicwhip/member/1188 Andrew Robathan Andrew Robathan uk.org.publicwhip/person/10503
uk.org.publicwhip/member/1189 Angus Robertson Angus Robertson uk.org.publicwhip/person/11189
uk.org.publicwhip/member/119 Geoffrey Clifton-Brown Geoffrey Clifton-Brown uk.org.publicwhip/person/10119
uk.org.publicwhip/member/1190 Hugh Robertson Hugh Robertson uk.org.publicwhip/person/11190
uk.org.publicwhip/member/1191 John Robertson John Robertson uk.org.publicwhip/person/10684
uk.org.publicwhip/member/1192 Laurence Robertson Laurence Robertson uk.org.publicwhip/person/10505
uk.org.publicwhip/member/1193 Geoffrey Robinson Geoffrey Robinson uk.org.publicwhip/person/10506
uk.org.publicwhip/member/1194 Iris Robinson Iris Robinson uk.org.publicwhip/person/11194
uk.org.publicwhip/member/1195 Peter Robinson Peter Robinson uk.org.publicwhip/person/10507
uk.org.publicwhip/member/1196 Barbara Roche Barbara Roche uk.org.publicwhip/person/10508
uk.org.publicwhip/member/1197 Marion Roe Marion Roe uk.org.publicwhip/person/10509
uk.org.publicwhip/member/1198 Terry Rooney Terry Rooney uk.org.publicwhip/person/10512
uk.org.publicwhip/member/1199 Andrew Rosindell Andrew Rosindell uk.org.publicwhip/person/11199
uk.org.publicwhip/member/12 Janet Anderson Janet Anderson uk.org.publicwhip/person/10012
uk.org.publicwhip/member/120 Ann Clwyd Ann Clwyd uk.org.publicwhip/person/10120
uk.org.publicwhip/member/1200 Ernie Ross Ernie Ross uk.org.publicwhip/person/10513
uk.org.publicwhip/member/1201 Frank Roy Frank Roy uk.org.publicwhip/person/10517
uk.org.publicwhip/member/1202 Chris Ruane Chris Ruane uk.org.publicwhip/person/10518
uk.org.publicwhip/member/1203 Joan Ruddock Joan Ruddock uk.org.publicwhip/person/10519
uk.org.publicwhip/member/1204 David Ruffley David Ruffley uk.org.publicwhip/person/10520
uk.org.publicwhip/member/1205 Bob Russell Bob Russell uk.org.publicwhip/person/10521
uk.org.publicwhip/member/1206 Christine Russell Christine Russell uk.org.publicwhip/person/10522
uk.org.publicwhip/member/1207 Joan Ryan Joan Ryan uk.org.publicwhip/person/10523
uk.org.publicwhip/member/1208 Alex Salmond Alex Salmond uk.org.publicwhip/person/10525
uk.org.publicwhip/member/1209 Martin Salter Martin Salter uk.org.publicwhip/person/10526
uk.org.publicwhip/member/121 Vernon Coaker Vernon Coaker uk.org.publicwhip/person/10121
uk.org.publicwhip/member/1210 Adrian Sanders Adrian Sanders uk.org.publicwhip/person/10527
uk.org.publicwhip/member/1211 Mohammad Sarwar Mohammad Sarwar uk.org.publicwhip/person/10528
uk.org.publicwhip/member/1212 Malcolm Savidge Malcolm Savidge uk.org.publicwhip/person/10529
uk.org.publicwhip/member/1213 Phil Sawford Phil Sawford uk.org.publicwhip/person/10530
uk.org.publicwhip/member/1214 Jonathan Sayeed Jonathan Sayeed uk.org.publicwhip/person/10531
uk.org.publicwhip/member/1215 Brian Sedgemore Brian Sedgemore uk.org.publicwhip/person/10532
uk.org.publicwhip/member/1216 Andrew Selous Andrew Selous uk.org.publicwhip/person/11216
uk.org.publicwhip/member/1217 Jonathan R Shaw Jonathan R Shaw uk.org.publicwhip/person/10533
uk.org.publicwhip/member/1218 Barry Sheerman Barry Sheerman uk.org.publicwhip/person/10534
uk.org.publicwhip/member/1219 Gillian Shephard Gillian Shephard uk.org.publicwhip/person/10536
uk.org.publicwhip/member/122 Ann Coffey Ann Coffey uk.org.publicwhip/person/10122
uk.org.publicwhip/member/1220 Richard Shepherd Richard Shepherd uk.org.publicwhip/person/10537
uk.org.publicwhip/member/1221 Jim Sheridan Jim Sheridan uk.org.publicwhip/person/11221
uk.org.publicwhip/member/1222 Debra Shipley Debra Shipley uk.org.publicwhip/person/10539
uk.org.publicwhip/member/1223 Clare Short Clare Short uk.org.publicwhip/person/10540
uk.org.publicwhip/member/1224 Mark Simmonds Mark Simmonds uk.org.publicwhip/person/11224
uk.org.publicwhip/member/1225 Siôn Simon Siôn Simon uk.org.publicwhip/person/11225
uk.org.publicwhip/member/1226 Alan Simpson Alan Simpson uk.org.publicwhip/person/10541
uk.org.publicwhip/member/1227 Keith Simpson Keith Simpson uk.org.publicwhip/person/10542
uk.org.publicwhip/member/1228 Marsha Singh Marsha Singh uk.org.publicwhip/person/10543
uk.org.publicwhip/member/1229 Dennis Skinner Dennis Skinner uk.org.publicwhip/person/10544
uk.org.publicwhip/member/123 Harry Cohen Harry Cohen uk.org.publicwhip/person/10123
uk.org.publicwhip/member/1230 Andrew Smith Andrew Smith uk.org.publicwhip/person/10545
uk.org.publicwhip/member/1231 Angela Smith Angela Smith uk.org.publicwhip/person/10546
uk.org.publicwhip/member/1232 Chris Smith Chris Smith uk.org.publicwhip/person/10547
uk.org.publicwhip/member/1233 Geraldine Smith Geraldine Smith uk.org.publicwhip/person/10548
uk.org.publicwhip/member/1234 Jacqui Smith Jacqui Smith uk.org.publicwhip/person/10549
uk.org.publicwhip/member/1235 John Smith John Smith uk.org.publicwhip/person/10550
uk.org.publicwhip/member/1236 Llew Smith Llew Smith uk.org.publicwhip/person/10551
uk.org.publicwhip/member/1237 Robert Smith Robert Smith uk.org.publicwhip/person/10552
uk.org.publicwhip/member/1238 Martin Smyth Martin Smyth uk.org.publicwhip/person/10553
uk.org.publicwhip/member/1239 Nicholas Soames Nicholas Soames uk.org.publicwhip/person/10555
uk.org.publicwhip/member/124 Iain Coleman Iain Coleman uk.org.publicwhip/person/10124
uk.org.publicwhip/member/1240 Clive Soley Clive Soley uk.org.publicwhip/person/10556
uk.org.publicwhip/member/1241 Helen Southworth Helen Southworth uk.org.publicwhip/person/10557
uk.org.publicwhip/member/1242 John Spellar John Spellar uk.org.publicwhip/person/10558
uk.org.publicwhip/member/1243 Caroline Spelman Caroline Spelman uk.org.publicwhip/person/10559
uk.org.publicwhip/member/1244 Michael Spicer Michael Spicer uk.org.publicwhip/person/10560
uk.org.publicwhip/member/1245 Bob Spink Bob Spink uk.org.publicwhip/person/11245
uk.org.publicwhip/member/1246 Richard Spring Richard Spring uk.org.publicwhip/person/10561
uk.org.publicwhip/member/1247 Rachel Squire Rachel Squire uk.org.publicwhip/person/10562
uk.org.publicwhip/member/1248 John Stanley John Stanley uk.org.publicwhip/person/10563
uk.org.publicwhip/member/1249 Phyllis Starkey Phyllis Starkey uk.org.publicwhip/person/10564
uk.org.publicwhip/member/125 Tim Collins Tim Collins uk.org.publicwhip/person/10125
uk.org.publicwhip/member/1250 Anthony Steen Anthony Steen uk.org.publicwhip/person/10565
uk.org.publicwhip/member/1251 Gerry Steinberg Gerry Steinberg uk.org.publicwhip/person/10566
uk.org.publicwhip/member/1252 George Stevenson George Stevenson uk.org.publicwhip/person/10567
uk.org.publicwhip/member/1253 David Stewart David Stewart uk.org.publicwhip/person/10568
uk.org.publicwhip/member/1254 Ian Stewart Ian Stewart uk.org.publicwhip/person/10569
uk.org.publicwhip/member/1255 Paul Stinchcombe Paul Stinchcombe uk.org.publicwhip/person/10570
uk.org.publicwhip/member/1256 Howard Stoate Howard Stoate uk.org.publicwhip/person/10571
uk.org.publicwhip/member/1257 Gavin Strang Gavin Strang uk.org.publicwhip/person/10573
uk.org.publicwhip/member/1258 Jack Straw Jack Straw uk.org.publicwhip/person/10574
uk.org.publicwhip/member/1259 Gary Streeter Gary Streeter uk.org.publicwhip/person/10575
uk.org.publicwhip/member/126 Tony Colman Tony Colman uk.org.publicwhip/person/10126
uk.org.publicwhip/member/1260 Graham Stringer Graham Stringer uk.org.publicwhip/person/10576
uk.org.publicwhip/member/1261 Gisela Stuart Gisela Stuart uk.org.publicwhip/person/10577
uk.org.publicwhip/member/1262 Andrew Stunell Andrew Stunell uk.org.publicwhip/person/10578
uk.org.publicwhip/member/1263 Gerry Sutcliffe Gerry Sutcliffe uk.org.publicwhip/person/10579
uk.org.publicwhip/member/1264 Desmond Swayne Desmond Swayne uk.org.publicwhip/person/10580
uk.org.publicwhip/member/1265 Hugo Swire Hugo Swire uk.org.publicwhip/person/11265
uk.org.publicwhip/member/1266 Robert Syms Robert Syms uk.org.publicwhip/person/10582
uk.org.publicwhip/member/1267 Mark Tami Mark Tami uk.org.publicwhip/person/11267
uk.org.publicwhip/member/1268 Peter Tapsell Peter Tapsell uk.org.publicwhip/person/10583
uk.org.publicwhip/member/1269 Ann Taylor Ann Taylor uk.org.publicwhip/person/10584
uk.org.publicwhip/member/1270 Dari Taylor Dari Taylor uk.org.publicwhip/person/10585
uk.org.publicwhip/member/1271 David Taylor David Taylor uk.org.publicwhip/person/10586

Next page

Advanced export

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

CSV options:

CREATE TABLE members (
        id VARCHAR(50) NOT NULL,
        name TEXT,
        person_id TEXT,
        PRIMARY KEY (id),
        FOREIGN KEY ("person_id") REFERENCES [people](id)
    );