Skip to content

Instantly share code, notes, and snippets.

View jacksonj04's full-sized avatar

Nick Jackson jacksonj04

View GitHub Profile
@jacksonj04
jacksonj04 / candidates.csv
Last active November 26, 2019 12:57
Democracy Club - Wikidata IDs Cross-reference
name dc_id wikidata_id
Tom Crone 11 Q73117387
Steve Wilson 12315 Q63929127
Dave Radcliffe 1249 Q75838630
Vernon Coaker 1272 Q285975
David Evennett 135 Q303883
Rushanara Ali 143 Q259423
David Blackburn 156 Q55469097
Andrew Robathan 1897 Q501089
Jackie Jones 19920 Q63865632
id,name,honorific_prefix,honorific_suffix,gender,birth_date,election,party_id,party_name,post_id,post_label,mapit_url,elected,email,twitter_username,facebook_page_url,party_ppc_page_url,facebook_personal_url,homepage_url,wikipedia_url,linkedin_url,image_url,proxy_image_url_template,image_copyright,image_uploading_user,image_uploading_user_notes,twitter_user_id,election_date,election_current,party_lists_in_use,party_list_position,old_person_ids,gss_code,parlparse_id,theyworkforyou_url,party_ec_id,favourite_biscuits,cancelled_poll,wikidata_id
482,Mike Davies,,,male,,local.leeds.2019-05-02,party:67,Alliance For Green Socialism,MTW:E05011390,Chapel Allerton,,,[email protected],,,,,,,,https://static-candidates.democracyclub.org.uk/media/images/images/482.png,,other,j0e_m,Provided by the candidate to democlub for use on public website.,,2019-05-02,True,False,,,,,,PP67,,False,http://www.wikidata.org/entity/Q62273309
4815,Tim Goodall,,,male,,local.leeds.2019-05-02,party:63,Green Party,MTW:E05011397,Headi
@jacksonj04
jacksonj04 / query.rq
Created September 26, 2018 11:07
Generate Seed for Legislature
SELECT ?membershipLabel ("-" as ?count) ?itemLabel ?item ("yes" as ?namePopulated) ("yes" as ?positionPopulated) ?membership ?districtLabel ?district ?partyLabel ?party ("-" as ?fbPop) ?fb
WHERE
{
BIND (wd:Q1135593 as ?legislature) .
?item p:P39 ?node .
?node ps:P39 ?membership .
?membership wdt:P361 ?legislature .
OPTIONAL { ?node pq:P768 ?district }
OPTIONAL { ?node pq:P4100 ?party }
OPTIONAL { ?node pq:P582 ?endtime }
electoral_district_item electoral_district_name person_id person_name parliamentary_group_name parliamentary_group_id
Q2884679 Barnet and Camden Q338076 Andrew Dismore Labour Co-operative Q56577681
Q2900428 Bexley and Bromley Q5522788 Gareth Bacon Conservative Party Q20712896
Q15078119 Brent and Harrow Q6982484 Navin Shah Labour Party Q56577681
Q2974584 City and East Q24039527 Unmesh Desai Labour Party Q56577681
Q3005479 Croydon and Sutton Q7613485 Steve O'Connell Conservative Party Q20712896
Q2388154 Ealing and Hillingdon Q7093978 Onkar Sahota Labour Party Q56577681
Q3054197 Enfield and Haringey Q6206173 Joanne McCartney Labour Co-operative Q56577681
Q3116153 Greenwich and Lewisham Q6521755 Len Duvall Labour Co-operative Q56577681
Q3128701 Havering and Redbridge Q31389937 Keith Prince Conservative Party Q20712896
@jacksonj04
jacksonj04 / members.csv
Last active August 20, 2018 14:00
São Paulo State Legislature Members
person_name person_item parliamentary_group_name parliamentary_group_item
Abelardo Camarinha Q16141958 PSB Q2054789
Adilson Rossi Q28678009 PSB Q2054789
Afonso Lobato Q16337671 PV Q1234489
Aldo Demarchi Q9600628 DEM Q1185830
Alencar Santana Braga Q18237253 PT Q657089
Ana do Carmo Q28678143 PT Q657089
Analice Fernandes Q16490061 PSDB Q1322897
André do Prado Q28678144 PR Q2731720
André Soares Q16336601 DC Q2653287
@jacksonj04
jacksonj04 / barnbow.csv
Created August 14, 2018 14:22
Barnbow Lasses
Family Name Given Names
Jackson Ethel
Keyworth M
Alderson M
Chapman Katie
Reid Gertruda
Powel Agnes L
Atkinson Elsie Martha
Schofield Mary S
Whiteley Florence
Q118715 P39 Q118715-FC8E1E49-BCC1-4B91-8486-343856B410E3 P580 2017-10-24
Q76265 P39 Q76265-3F5F50D5-DD61-4E1C-B8BC-A3BD2E1DF4BE P580 2017-10-24
Q104706 P39 Q104706-39A1D352-D2AC-4301-8EB3-7B8A9F374975 P580 2017-10-24
Q15262812 P39 Q15262812-CD583ABA-308D-4746-8008-80FA3DED7DA3 P580 2017-10-24
Q1736645 P39 Q1736645-61AF15A4-89FE-4FA7-9B4A-095CBABC87C9 P580 2017-10-24
Q15813082 P39 Q15813082-667D83D5-B5D5-42E8-9990-E3ACEE15B6AC P580 2017-10-24
Q95185 P39 Q95185-89B5BD73-D662-4145-B37E-5F92EA7BB750 P580 2017-10-24
Q15434300 P39 Q15434300-7E74F9BA-0AA9-4313-B165-23551F50268D P580 2017-10-24
Q16019 P39 Q16019-2B2D090E-79A5-4EE7-A85A-7FD7161B9280 P580 2017-10-24
Q67164 P39 Q67164-1FF534EA-E555-4A1E-BF45-4262C6725A86 P580 2017-10-24
@jacksonj04
jacksonj04 / README.md
Created August 31, 2017 10:59
German MEPs (2014) Wikidata QuickStatements

This is a set of statements for the QuickStatements tool which completes statements about being members of the European Parliament for German MEPs elected in 2014.

Source

// Pin 13 has an LED connected on most Arduino boards.
// give it a name:
int led = 13;
int greenPin = 10;
int redPin = 11;
int bluePin = 9;
int whitePin = 6;
int dipPins[] = {4,3,2};