User:Jacksonj04/prompts/Kenya/Senate

From Wikidata
Jump to navigation Jump to search

This compares Wikidata's list of the current members of the Senate to that at http://parliament.go.ke/the-senate/senators, via Morph.


Comparison

@@ url (SPARQL) url (CSV) name (SPARQL) name (CSV) district_id (SPARQL) district_id (CSV) party_id (SPARQL) party_id (CSV)
-> http://parliament.go.ke/the-senate/senators/item/3859-sen-adan-dullo-fatuma Dullo Fatuma Adan (Q47514853)Dullo Fatuma Adan Isiolo County (Q1499046) Party of Development and Reforms (Q7141057)
-> http://parliament.go.ke/the-senate/senators/item/3871-sen-ali-abdullahi-ibrahim Abdullahi Ibrahim Ali (Q47514825)Abdullahi Ibrahim Ali Wajir County (Q1852209) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3889-sen-boy-issa-juma Issa Juma Boy (Q47514874)Issa Juma Boy Kwale County (Q952571) Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3890-sen-chebeni-mercy Mercy Chebeni (Q47516257)Mercy Chebeni Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3891-sen-cherarkey-samson-k Cherarkey K Samson (Q47514820)Samson K Cherarkey Nandi County (Q1964569) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3868-sen-cheruiyot-aaron-kipkirui Aaron Kipkirui Cheruiyot (Q47514855)Aaron Kipkirui Cheruiyot Kericho County (Q1739252)
-> http://parliament.go.ke/the-senate/senators/item/3892-sen-gona-christine-zawadi Christine Zawadi Gona (Q47516259)Christine Zawadi Gona
-> http://parliament.go.ke/the-senate/senators/item/3893-sen-haji-farhiya-ali Farhiya Ali Haji (Q47516260)Farhiya Ali Haji Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3855-sen-haji-mohamed-yusuf Mohamed Yusuf Haji (Q1030776)Mohamed Yusuf Haji Garissa County (Q1494292) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3894-sen-halake-abshiro-soka Abshiro Soka Halake (Q47516261)Abshiro Soka Halake Kenya African National Union (Q1422517)
-> http://parliament.go.ke/the-senate/senators/item/3860-sen-hargura-godana Godana Hargura (Q47514914)Godana Hargura Marsabit County (Q1323683) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3895-sen-iman-falhada-dekow Falhada Dekow Iman (Q47516262)Falhada Dekow Iman Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3896-sen-imana-malachy-charles-ekal Malachy Charles Ekal Imana (Q47514883)Malachy Charles Ekal Imana Turkana County (Q1633078) Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3897-sen-inimah-getrude-musuruve Getrude Musuruve Inimah (Q47516263)Getrude Musuruve Inimah Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3898-sen-kabaka-boniface-mutinda Boniface Mutinda Kabaka (Q47514903)Boniface Mutinda Kabaka Machakos County (Q1882639) Chama Cha Uzalendo (Q5069325)
-> http://parliament.go.ke/the-senate/senators/item/3867-sen-kajwang'-moses-otieno Moses Otieno Kajwang (Q27893074)Moses Otieno Kajwang' Homa Bay County (Q1625834) Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3876-sen-kamar-margaret-jepkoech Margaret Kamar (Q6759579)Margaret Jepkoech Kamar Uasin Gishu County (Q1121429) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3877-sen-kang'ata-irungu Irungu Kang'ata (Q28113009)Irungu Kang'ata Muranga County (Q1781723)
-> http://parliament.go.ke/the-senate/senators/item/3899-sen-kasanga-sylvia-mueni Sylvia Mueni Kasanga (Q47516265)Sylvia Mueni Kasanga Wiper Democratic Movement (Q5251223)
-> http://parliament.go.ke/the-senate/senators/item/3853-sen-khaniri-george George Khaniri (Q5541326)George Khaniri Vihiga County (Q1313202)
-> http://parliament.go.ke/the-senate/senators/item/3900-sen-kibiru-charles-reubenson Charles Reubenson Kibiru (Q47514851)Charles Reubenson Kibiru Kirinyaga County (Q2230311) independent politician (Q327591)
-> http://parliament.go.ke/the-senate/senators/item/3885-sen-kihika-susan-wakarura Susan Wakarura Kihika (Q47514871)Susan Wakarura Kihika Nakuru County (Q1852202) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3866-sen-kilonzo-mutula-junior Mutula Kilonzo Junior (Q47514909)Mutula Junior Kilonzo Makueni County (Q473717) Wiper Democratic Movement (Q5251223)
-> http://parliament.go.ke/the-senate/senators/item/3861-sen-kimani-wamatangi-paul Wamatangi Paul Kimani (Q47514897)Wamatangi Paul Kimani Kiambu County (Q2575594) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3862-sen-kindiki-kithure Kithure Kindiki (Q47514805)Kithure Kindiki Tharaka Nithi County (Q2189432)
-> http://parliament.go.ke/the-senate/senators/item/3878-sen-kirinyaga-ephraim-mwangi Ephraim Maina (Q47514859)Ephraim Mwangi Kirinyaga Nyeri County (Q749665) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3901-sen-langat-christopher-andrew Christopher Andrew Langat (Q47514911)Christopher Andrew Langat Bomet County (Q891952) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3884-sen-lelegwe-steve-ltumbesi Steve Ltumbesi Lelegwe (Q47514912)Steve Ltumbesi Lelegwe Samburu County (Q2096419) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3872-sen-linturi-franklin-mithika Franklin Linturi (Q5491660)Franklin Mithika Linturi Meru County (Q15045704) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3902-sen-loitiptip-anuar Anuar Loitiptip (Q47516266)Anuar Loitiptip Lamu County (Q1951652) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/4352-sen-lokorio-petronila-were Petronila Were Lokorio (Q47516267)Petronila Were Lokorio NULLCode: "Amani National Congress"
-> http://parliament.go.ke/the-senate/senators/item/3863-sen-madzayo-stewart-mwachiru Stewart Mwachiru Shadrack Madzayo (Q47514905)Stewart Mwachiru Madzayo Kilifi County (Q1741307) Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3873-sen-mahamud-mohamed-m Mohamed Maalim Mahamud (Q47514796)Mohamed M Mahamud Mandera County (Q1477874) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3886-sen-makori-beatrice-kwamboka Beatrice Kwamboka Makori (Q47516268)Beatrice Kwamboka Makori Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3887-sen-malalah-cleophas-w Cleophas Wakhungu Malalah (Q47514910)Cleophas W Malalah Kakamega County (Q1721867) Amani National Congress (Q47489380)
-> http://parliament.go.ke/the-senate/senators/item/3903-sen-masitsa-naomi-shiyonga Naomi Shiyonga Masitsa (Q47516269)Naomi Shiyonga Masitsa Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3904-sen-mbito-michael-maling'a Michael Maling'a Mbito (Q47514852)Michael Maling'a Mbito Trans-Nzoia county (Q1278653) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3905-sen-milgo-alice-chepkorir Alice Chepkorir Milgo (Q47516271)Alice Chepkorir Milgo Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3906-sen-mogeni-erick-okong'o Kennedy Mong'are Okong'o (Q47516272)Erick Okong'o Mogeni Nyamira county (Q1569613) Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3858-sen-moi-gideon-kipsielei Gideon Moi (Q47514907)Gideon Kipsielei Moi Baringo County (Q808201) Kenya African National Union (Q1422517)
-> http://parliament.go.ke/the-senate/senators/item/3907-sen-mpaayei-phillip-salau Phillip Salau Mpaayei (Q47514806)Phillip Salau Mpaayei Kajiado County (Q285072) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3856-sen-mugo-beth-wambui Beth Wambui Mugo (Q4897658)Beth Wambui Mugo Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3864-sen-murkomen-onesimus-k Kipchumba Murkomen (Q46556896)Onesimus Kipchumba Murkomen Elgeyo-Marakwet County (Q15216433)
-> http://parliament.go.ke/the-senate/senators/item/3875-sen-mwangi-paul-githiomi Paul Githiomi Mwangi (Q47514875)Paul Githiomi Mwangi Nyandarua County (Q1714352) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3908-sen-mwaruma-johnes-m Johnes Mwashushe Mwaruma (Q47514877)Johnes M Mwaruma Taita–Taveta County (Q7193788) Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3879-sen-mwaura-isaack Isaac Mwaura (Q20744564)Isaack Mwaura
-> http://parliament.go.ke/the-senate/senators/item/3909-sen-mwinyi-haji-mohamed Mohamed Faki Mwinyihaji (Q47516273)Haji Mohamed Mwinyi Mombasa County (Q1112885)
-> http://parliament.go.ke/the-senate/senators/item/3910-sen-nderitu-john-kinyua John Kinyua Nderitu (Q47514797)John Kinyua Nderitu Laikipia County (Q1800699) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3880-sen-ndwiga-peter-njeru Peter Njeru Ndwiga (Q7176116)Peter Njeru Ndwiga Embu County (Q1335242) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3881-sen-nyamunga-rose-ogendo Rose Ogendo Nyamunga (Q47516274)Rose Ogendo Nyamunga Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3911-sen-okello-ben-oluoch Ben Oluoch Okello (Q47514837)Ben Oluoch Okello Migori County (Q429955) Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3912-sen-olekina-ledama Olekina Ledama (Q7086213)Ledama Olekina Narok County (Q1852220) Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3913-sen-omanga-millicent Millicent Omanga (Q47516275)Millicent Omanga
-> http://parliament.go.ke/the-senate/senators/item/3869-sen-ongeri-samson-kegengo Sam Ongeri (Q4705081)Samson Kegengo Ongeri Kisii County (Q1743730) Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3854-sen-orengo-james James Orengo (Q6140639)James Orengo Siaya County (Q3482913)
-> http://parliament.go.ke/the-senate/senators/item/3874-sen-outa-fredrick-otieno Frederick Outa Otieno (Q47514887)Fredrick Otieno Outa Kisumu County (Q1743809) Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3888-sen-pareno-judith-ramaita Judith Ramaita Pareno (Q47516276)Judith Ramaita Pareno NULLOrange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3870-sen-poghisio-samuel-losuron Samuel Poghisio (Q16734594)Samuel Losuron Poghisio West Pokot County (Q590860) Kenya African National Union (Q1422517)
-> http://parliament.go.ke/the-senate/senators/item/3914-sen-prengei-victor Victor Prengei (Q47516277)Victor Prengei Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3882-sen-sakaja-johnson-arthur Sakaja Johnson (Q28967580)Johnson Arthur Sakaja Nairobi County (Q3335223)
-> http://parliament.go.ke/the-senate/senators/item/3883-sen-seneta-mary-yiane Mary Yiane Seneta (Q47516278)Mary Yiane Seneta Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3852-sen-wako-sitswila-amos Sitswila Amos Wako (Q47514798)Sitswila Amos Wako Busia County (Q1017519) Orange Democratic Movement (Q1640905)
-> http://parliament.go.ke/the-senate/senators/item/3915-sen-wambua-enoch-kiio Enoch Kiio Wambua (Q47514898)Enoch Kiio Wambua Kitui County (Q1722597) Wiper Democratic Movement (Q5251223)
-> http://parliament.go.ke/the-senate/senators/item/3916-sen-waqo-naomi-jilo Naomi Jilo Waqo (Q47516279)Naomi Jilo Waqo Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3917-sen-wario-golich-juma Golich Juma Wario (Q47514830)Golich Juma Wario Tana River County (Q383150) Jubilee Party of Kenya (Q27963537)
-> http://parliament.go.ke/the-senate/senators/item/3857-sen-wetang'ula-moses-masika Moses Wetangula (Q58188)Moses Masika Wetang'ula Bungoma County (Q2928204) Forum for the Restoration of Democracy – Kenya (Q5473121)
-> http://parliament.go.ke/the-senate/senators/item/3865-sen-zani-agnes-philomena Agnes Philomena Zani (Q47516280)Agnes Philomena Zani

Stats

  • Items only found in SPARQL (--- in the first column): 0
  • Items only found in CSV (+++ in the first column): 0
  • Items that differ between sources (→ in the first column): 67
  • Total items in SPARQL: 67
  • Total items in CSV: 67

External source

https://morph-csv-proxy.herokuapp.com/?scraper=mysociety%2Fkenya-senate-members&query=SELECT+%2A+FROM+data

SPARQL query

SELECT ?url ?name ?district_id ?party_id
WHERE 
{
  ?name p:P39 ?statement .
  ?statement ps:P39/wdt:P279* wd:Q18555726 ; pq:P580 ?start .
  OPTIONAL { ?statement pq:P582 ?end }
  OPTIONAL { ?statement pq:P768 ?district_id }
  OPTIONAL { ?district_id rdfs:label ?district . FILTER(lang(?en_label)="en") }
  OPTIONAL { ?statement pq:P4100 ?party_id }
  OPTIONAL { ?name wdt:P973 ?url }
  FILTER(!BOUND(?end) || ?end > NOW())
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?start ?end
Try it!

Refresh prompt

Refresh this comparison Purge the cache

Customize (optional)


Retrieved from "https://www.wikidata.org/w/index.php?title=User:Jacksonj04/prompts/Kenya/Senate&oldid=624431747"