How we built the Find Case Law repository dashboard.
It's a table in Markdown, which uses shields.io to display various status items, and the Markdown is rendered by a script to simplify updates
Nick Jackson jacksonj04
jacksonj04
/ Repository Dashboards.md
Created
December 14, 2022 15:56
jacksonj04
/ candidates.csv
Last active
November 26, 2019 12:57
Democracy Club - Wikidata IDs Cross-reference
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
jacksonj04
/ gist:f27c4a2fee6f39acaed4ec2cb5e8f8e6
Created
April 24, 2019 14:09
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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,,,m.davies@greensocialist.org.uk,,,,,,,,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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 } |
jacksonj04
/ london-assembly.csv
Last active
September 13, 2018 10:25
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
jacksonj04
/ statements.tsv
Created
October 26, 2017 14:24
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
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.
jacksonj04
/ gist:60159919ee9e9b54fffb
Created
March 16, 2016 15:01
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 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}; |
NewerOlder