To download data sign in with GitHub
rows 4 / 4
id | name | start_date | end_date |
---|---|---|---|
id
1
|
name
1st Assembly
|
start_date
1998-06-25
|
end_date
2003-04-28
|
id
2
|
name
2nd Assembly
|
start_date
2003-11-26
|
end_date
2007-01-30
|
id
3
|
name
3rd Assembly
|
start_date
2007-03-09
|
end_date
2011-03-24
|
id
4
|
name
4th Assembly
|
start_date
2011-05-06
|
end_date
|
To download data sign in with GitHub
rows 10 / 468
id | name | historichansard | party | party_id | start_date | start_reason | end_date | end_reason | term |
---|---|---|---|---|---|---|---|---|---|
id
10002
|
name
Gerry Adams
|
historichansard
40
|
party
Sinn Féin
|
party_id
sinn-fein
|
start_date
1998-06-25
|
start_reason
general_election
|
end_date
2003-04-28
|
end_reason
general_election
|
term
1
|
id
10002
|
name
Gerry Adams
|
historichansard
40
|
party
Sinn Féin
|
party_id
sinn-fein
|
start_date
2003-11-26
|
start_reason
general_election
|
end_date
2007-01-30
|
end_reason
dissolution
|
term
2
|
id
10002
|
name
Gerry Adams
|
historichansard
40
|
party
Sinn Féin
|
party_id
sinn-fein
|
start_date
2007-03-09
|
start_reason
election
|
end_date
2010-12-07
|
end_reason
resigned
|
term
3
|
id
10172
|
name
Jeffrey M. Donaldson
|
historichansard
250
|
party
DUP
|
party_id
dup
|
start_date
2004-01-15
|
start_reason
changed_party
|
end_date
2007-01-30
|
end_reason
dissolution
|
term
2
|
id
10172
|
name
Jeffrey M. Donaldson
|
historichansard
250
|
party
DUP
|
party_id
dup
|
start_date
2007-03-09
|
start_reason
election
|
end_date
2010-06-09
|
end_reason
resigned
|
term
3
|
id
10300
|
name
John Hume
|
historichansard
373
|
party
Social Democratic and Labour Party
|
party_id
social-democratic-and-labour-party
|
start_date
1998-06-25
|
start_reason
general_election
|
end_date
2000-12-01
|
end_reason
resigned
|
term
1
|
id
10380
|
name
Robert McCartney
|
historichansard
483
|
party
UKUP
|
party_id
ukup
|
start_date
1998-06-25
|
start_reason
general_election
|
end_date
2003-04-28
|
end_reason
general_election
|
term
1
|
id
10380
|
name
Robert McCartney
|
historichansard
483
|
party
UKUP
|
party_id
ukup
|
start_date
2003-11-26
|
start_reason
general_election
|
end_date
2007-01-30
|
end_reason
dissolution
|
term
2
|
id
10385
|
name
Eddie McGrady
|
historichansard
487
|
party
Social Democratic and Labour Party
|
party_id
social-democratic-and-labour-party
|
start_date
1998-06-25
|
start_reason
general_election
|
end_date
2003-04-28
|
end_reason
general_election
|
term
1
|
id
10387
|
name
Martin McGuinness
|
historichansard
488
|
party
Sinn Féin
|
party_id
sinn-fein
|
start_date
1998-06-25
|
start_reason
general_election
|
end_date
2003-04-28
|
end_reason
general_election
|
term
1
|
Average successful run time: less than a minute
Total run time: 5 minutes
Total cpu time used: half a minute
Total disk space used: 85.2 KB