home / colmem

committee_membership

Data source: See col-scraper on GitHub

17 rows where member_id = 256

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
445 445 Barbican Residential Committee 153 Michael Hudson 256  
446 446 Board of Governors of the City of London Freemen's School 230 Michael Hudson 256  
447 447 Corporate Asset Sub (Finance) Committee 216 Michael Hudson 256  
448 448 223 Michael Hudson 256  
449 449 Courts Sub (Policy & Resources) Committee 1229 Michael Hudson 256  
450 450 Finance Committee 145 Michael Hudson 256  
451 451 Hampstead Heath, Highgate Wood and Queen's Park Committee 250 Michael Hudson 256  
452 452 Health and Social Care Scrutiny Committee 185 Michael Hudson 256  
453 453 Inner North East London Joint Health Overview and Scrutiny Committee 252 Michael Hudson 256  
454 454 Investment Committee 176 Michael Hudson 256  
455 455 Licensing (Hearing) Sub Committee 200 Michael Hudson 256  
456 456 Licensing Committee 123 Michael Hudson 256  
457 457 Procurement Sub (Finance) Committee 1267 Michael Hudson 256  
458 458 Property Investment Board 125 Michael Hudson 256  
459 459 Reference Sub (Licensing) Committee 986 Michael Hudson 256  
460 460 Reference Sub (Markets) Committee 563 Michael Hudson 256  
461 461 Standards Appeals Committee 1259 Michael Hudson 256  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE committee_membership(
        committee_id INTEGER REFERENCES committees(id),
        member_id INTEGER REFERENCES members(id),
        role VARCHAR(50)
    );
CREATE INDEX committee_membership_committee_id ON committee_membership("committee_id");
CREATE INDEX committee_membership_member_id ON committee_membership("member_id");
Powered by Datasette · Queries took 235.596ms · Data source: See col-scraper on GitHub