Last active
April 21, 2021 08:34
-
-
Save giocomai/c3b9052acfb346d73fe9763aae73124f to your computer and use it in GitHub Desktop.
Get MEPs of the 9th legislature
This file contains hidden or 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
| library("dplyr", warn.conflicts = FALSE) # data wrangling | |
| library("tidywikidatar") | |
| tw_enable_cache() | |
| tw_set_cache_folder(path = fs::path(fs::path_home_r(), | |
| "R", | |
| "tw_data")) | |
| tw_create_cache_folder(ask = FALSE) | |
| meps_df_query <- tibble::tribble( | |
| ~p, ~q, | |
| "P39", "Q27169" | |
| ) | |
| meps_df <- tw_query(query = meps_df_query) | |
| mep_terms <- tw_get_qualifiers(id = meps_df$id, p = "P39") %>% # get qualifiers for "position held" of all MEPs | |
| filter(qualifier_id == "Q27169", qualifier_property == "P2937") %>% # keep only details about their position as MEP, and only about their parliamentary term | |
| select(-set) # remove qualifier identifier | |
| meps_9th <- mep_terms %>% | |
| filter(value == "Q64038205") %>% | |
| distinct(id) %>% | |
| pull(id) | |
| tibble::tibble(id = meps_9th) %>% | |
| readr::write_csv(file = "meps_9th.csv") |
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
This file contains hidden or 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 | |
| Q11860 | |
| Q12869 | |
| Q12978 | |
| Q15995 | |
| Q31236 | |
| Q32681 | |
| Q55703 | |
| Q55782 | |
| Q55823 | |
| Q55900 | |
| Q55910 | |
| Q55915 | |
| Q57279 | |
| Q57640 | |
| Q57663 | |
| Q58085 | |
| Q58095 | |
| Q58100 | |
| Q62093 | |
| Q63655 | |
| Q65437 | |
| Q71528 | |
| Q71660 | |
| Q74162 | |
| Q74191 | |
| Q74215 | |
| Q75194 | |
| Q77761 | |
| Q78194 | |
| Q78202 | |
| Q78415 | |
| Q84687 | |
| Q85368 | |
| Q85537 | |
| Q85543 | |
| Q85566 | |
| Q85676 | |
| Q87485 | |
| Q87549 | |
| Q88213 | |
| Q88866 | |
| Q90244 | |
| Q91526 | |
| Q91697 | |
| Q92274 | |
| Q95758 | |
| Q95895 | |
| Q96290 | |
| Q97573 | |
| Q98158 | |
| Q104492 | |
| Q105761 | |
| Q108736 | |
| Q111435 | |
| Q114033 | |
| Q114667 | |
| Q116719 | |
| Q116812 | |
| Q159490 | |
| Q172301 | |
| Q174491 | |
| Q201794 | |
| Q202117 | |
| Q236968 | |
| Q242090 | |
| Q246216 | |
| Q249551 | |
| Q250611 | |
| Q253020 | |
| Q253793 | |
| Q256001 | |
| Q261120 | |
| Q271646 | |
| Q272522 | |
| Q274125 | |
| Q274739 | |
| Q274770 | |
| Q281433 | |
| Q286466 | |
| Q287849 | |
| Q290539 | |
| Q292095 | |
| Q293214 | |
| Q293223 | |
| Q293291 | |
| Q293295 | |
| Q296452 | |
| Q298846 | |
| Q299667 | |
| Q307920 | |
| Q318471 | |
| Q345794 | |
| Q348993 | |
| Q372388 | |
| Q376204 | |
| Q376746 | |
| Q380310 | |
| Q405025 | |
| Q431743 | |
| Q432086 | |
| Q432190 | |
| Q432566 | |
| Q433055 | |
| Q433637 | |
| Q435394 | |
| Q439039 | |
| Q439111 | |
| Q439991 | |
| Q440151 | |
| Q440355 | |
| Q440710 | |
| Q441032 | |
| Q441282 | |
| Q441543 | |
| Q441791 | |
| Q442810 | |
| Q443095 | |
| Q444504 | |
| Q446679 | |
| Q446991 | |
| Q449080 | |
| Q450298 | |
| Q455548 | |
| Q456901 | |
| Q457117 | |
| Q458084 | |
| Q459373 | |
| Q462744 | |
| Q466236 | |
| Q467633 | |
| Q493714 | |
| Q497480 | |
| Q500389 | |
| Q501991 | |
| Q502972 | |
| Q504595 | |
| Q513301 | |
| Q519793 | |
| Q520490 | |
| Q534677 | |
| Q540812 | |
| Q543763 | |
| Q546215 | |
| Q548970 | |
| Q556149 | |
| Q557693 | |
| Q559402 | |
| Q559545 | |
| Q578504 | |
| Q583545 | |
| Q602944 | |
| Q644441 | |
| Q645267 | |
| Q652908 | |
| Q666504 | |
| Q689483 | |
| Q695272 | |
| Q704126 | |
| Q716486 | |
| Q721647 | |
| Q728720 | |
| Q730921 | |
| Q731042 | |
| Q774605 | |
| Q809726 | |
| Q850077 | |
| Q862343 | |
| Q912776 | |
| Q918818 | |
| Q921839 | |
| Q925180 | |
| Q929248 | |
| Q929393 | |
| Q932720 | |
| Q937002 | |
| Q939484 | |
| Q941950 | |
| Q948169 | |
| Q949046 | |
| Q954006 | |
| Q962333 | |
| Q967118 | |
| Q969701 | |
| Q974023 | |
| Q975171 | |
| Q979348 | |
| Q984556 | |
| Q995812 | |
| Q997327 | |
| Q1060314 | |
| Q1077655 | |
| Q1081665 | |
| Q1083771 | |
| Q1097007 | |
| Q1112658 | |
| Q1183377 | |
| Q1238315 | |
| Q1260118 | |
| Q1284472 | |
| Q1285166 | |
| Q1287239 | |
| Q1324589 | |
| Q1324719 | |
| Q1361333 | |
| Q1376538 | |
| Q1381218 | |
| Q1386500 | |
| Q1450883 | |
| Q1476255 | |
| Q1485198 | |
| Q1499562 | |
| Q1502078 | |
| Q1503075 | |
| Q1614514 | |
| Q1618317 | |
| Q1628512 | |
| Q1640725 | |
| Q1799046 | |
| Q1854955 | |
| Q1862392 | |
| Q1876930 | |
| Q1892853 | |
| Q1895909 | |
| Q1922673 | |
| Q1944783 | |
| Q1985836 | |
| Q1986007 | |
| Q1986069 | |
| Q2003427 | |
| Q2066785 | |
| Q2080450 | |
| Q2085597 | |
| Q2097451 | |
| Q2129398 | |
| Q2164581 | |
| Q2165078 | |
| Q2187156 | |
| Q2223607 | |
| Q2272984 | |
| Q2294644 | |
| Q2336010 | |
| Q2355582 | |
| Q2360756 | |
| Q2366466 | |
| Q2391857 | |
| Q2420152 | |
| Q2477402 | |
| Q2507571 | |
| Q2542770 | |
| Q2617559 | |
| Q2640766 | |
| Q2662771 | |
| Q2697618 | |
| Q2738322 | |
| Q2745560 | |
| Q2755156 | |
| Q2780443 | |
| Q2794709 | |
| Q2798242 | |
| Q3101123 | |
| Q3134543 | |
| Q3143147 | |
| Q3154049 | |
| Q3165682 | |
| Q3191042 | |
| Q2898005 | |
| Q2941852 | |
| Q2972740 | |
| Q2975532 | |
| Q2983767 | |
| Q3052795 | |
| Q3059549 | |
| Q3066505 | |
| Q3334944 | |
| Q3340073 | |
| Q3367388 | |
| Q3385791 | |
| Q3453988 | |
| Q3497934 | |
| Q3510471 | |
| Q3556414 | |
| Q3617687 | |
| Q3659342 | |
| Q3672035 | |
| Q3740539 | |
| Q3755512 | |
| Q3763386 | |
| Q3765532 | |
| Q3775015 | |
| Q3775281 | |
| Q3777503 | |
| Q3778169 | |
| Q3801917 | |
| Q3851074 | |
| Q3851077 | |
| Q3905080 | |
| Q3929173 | |
| Q3948237 | |
| Q4118653 | |
| Q4353146 | |
| Q4559562 | |
| Q4725739 | |
| Q4740163 | |
| Q4759190 | |
| Q4769431 | |
| Q4769784 | |
| Q4877021 | |
| Q4890847 | |
| Q4891277 | |
| Q4894822 | |
| Q4937928 | |
| Q4949040 | |
| Q4958080 | |
| Q4979205 | |
| Q4988619 | |
| Q4992676 | |
| Q5085688 | |
| Q5125204 | |
| Q5214099 | |
| Q5231883 | |
| Q5236464 | |
| Q5278073 | |
| Q5413481 | |
| Q5478286 | |
| Q5556322 | |
| Q5612566 | |
| Q5616258 | |
| Q5771098 | |
| Q5796275 | |
| Q5811605 | |
| Q5895692 | |
| Q5913582 | |
| Q5928039 | |
| Q6082822 | |
| Q6096116 | |
| Q6149636 | |
| Q6212174 | |
| Q6232261 | |
| Q6271307 | |
| Q6452486 | |
| Q6700640 | |
| Q6751217 | |
| Q6775257 | |
| Q6838473 | |
| Q6896677 | |
| Q6986880 | |
| Q7351526 | |
| Q7380323 | |
| Q9027010 | |
| Q9139694 | |
| Q9152187 | |
| Q9154406 | |
| Q9155828 | |
| Q9175313 | |
| Q9253246 | |
| Q9296459 | |
| Q9359622 | |
| Q9375875 | |
| Q9389714 | |
| Q10291438 | |
| Q10309880 | |
| Q10324447 | |
| Q10338219 | |
| Q10346767 | |
| Q11074254 | |
| Q11714338 | |
| Q11728715 | |
| Q11749266 | |
| Q11767999 | |
| Q11813593 | |
| Q11857612 | |
| Q11880159 | |
| Q11917597 | |
| Q12016827 | |
| Q12028942 | |
| Q12036669 | |
| Q12055995 | |
| Q12059351 | |
| Q12271852 | |
| Q12272021 | |
| Q12327679 | |
| Q12328993 | |
| Q12379326 | |
| Q12467437 | |
| Q12725938 | |
| Q12726340 | |
| Q12726380 | |
| Q12735517 | |
| Q12742616 | |
| Q12770572 | |
| Q13104358 | |
| Q13105242 | |
| Q13224746 | |
| Q13450383 | |
| Q13538232 | |
| Q14038593 | |
| Q14053382 | |
| Q14476134 | |
| Q14541202 | |
| Q15055614 | |
| Q15117357 | |
| Q15146511 | |
| Q15229428 | |
| Q15564103 | |
| Q15623382 | |
| Q15649550 | |
| Q15651402 | |
| Q15718586 | |
| Q15724624 | |
| Q15742179 | |
| Q15830415 | |
| Q15870687 | |
| Q15870693 | |
| Q15907132 | |
| Q15967888 | |
| Q15980671 | |
| Q16061914 | |
| Q16064658 | |
| Q16089810 | |
| Q16113442 | |
| Q16162917 | |
| Q16189675 | |
| Q16209258 | |
| Q16268441 | |
| Q16328888 | |
| Q16329183 | |
| Q16329215 | |
| Q16389751 | |
| Q16440157 | |
| Q16444907 | |
| Q16459273 | |
| Q16530497 | |
| Q16537126 | |
| Q16549460 | |
| Q16563740 | |
| Q16571128 | |
| Q16595498 | |
| Q16633235 | |
| Q16666184 | |
| Q16684166 | |
| Q16727434 | |
| Q16866329 | |
| Q16945593 | |
| Q16977486 | |
| Q16977671 | |
| Q16979858 | |
| Q16979883 | |
| Q16999649 | |
| Q16999729 | |
| Q17013901 | |
| Q17015617 | |
| Q17033649 | |
| Q17093506 | |
| Q17116940 | |
| Q17123340 | |
| Q17124693 | |
| Q17143079 | |
| Q17143283 | |
| Q17143453 | |
| Q17152415 | |
| Q17152507 | |
| Q17155237 | |
| Q17155333 | |
| Q17155376 | |
| Q17155698 | |
| Q17170880 | |
| Q17171393 | |
| Q17174898 | |
| Q17189402 | |
| Q17265926 | |
| Q17265935 | |
| Q17266637 | |
| Q17266640 | |
| Q17266672 | |
| Q17266674 | |
| Q17266677 | |
| Q17266678 | |
| Q17266683 | |
| Q17266806 | |
| Q17266811 | |
| Q17297615 | |
| Q17297655 | |
| Q17302280 | |
| Q17305108 | |
| Q17305189 | |
| Q17310794 | |
| Q17315553 | |
| Q17315555 | |
| Q17315715 | |
| Q17410051 | |
| Q17428148 | |
| Q17484120 | |
| Q17496473 | |
| Q17578800 | |
| Q17634440 | |
| Q18211172 | |
| Q18222891 | |
| Q18225970 | |
| Q18541650 | |
| Q18544407 | |
| Q18575732 | |
| Q18641022 | |
| Q18668688 | |
| Q18744905 | |
| Q19422218 | |
| Q19725706 | |
| Q19760666 | |
| Q19973739 | |
| Q20016702 | |
| Q20186168 | |
| Q20251661 | |
| Q20254806 | |
| Q20481002 | |
| Q20525324 | |
| Q20535883 | |
| Q21029376 | |
| Q21156576 | |
| Q21282054 | |
| Q21282143 | |
| Q21547522 | |
| Q21634444 | |
| Q22005939 | |
| Q22252746 | |
| Q22661777 | |
| Q23010148 | |
| Q23058507 | |
| Q23559933 | |
| Q23691603 | |
| Q23769958 | |
| Q23867530 | |
| Q24292529 | |
| Q24346604 | |
| Q24951518 | |
| Q26822072 | |
| Q26833634 | |
| Q27666246 | |
| Q27671969 | |
| Q27903982 | |
| Q28035943 | |
| Q28549362 | |
| Q28802997 | |
| Q28860746 | |
| Q28862426 | |
| Q28966945 | |
| Q28973801 | |
| Q29575749 | |
| Q29877665 | |
| Q30010698 | |
| Q30011696 | |
| Q30301690 | |
| Q31271619 | |
| Q32077841 | |
| Q33035647 | |
| Q33109862 | |
| Q33178150 | |
| Q34674536 | |
| Q35487495 | |
| Q37793165 | |
| Q38057897 | |
| Q38655134 | |
| Q40655898 | |
| Q42099949 | |
| Q42216408 | |
| Q43376217 | |
| Q43475331 | |
| Q43677404 | |
| Q45237464 | |
| Q45815517 | |
| Q47485256 | |
| Q47506087 | |
| Q47514370 | |
| Q48321355 | |
| Q48627081 | |
| Q50221206 | |
| Q51952680 | |
| Q51954730 | |
| Q52618103 | |
| Q52818869 | |
| Q54861014 | |
| Q54934102 | |
| Q55082237 | |
| Q55453413 | |
| Q55493801 | |
| Q55714607 | |
| Q56320702 | |
| Q56390799 | |
| Q56392496 | |
| Q56460787 | |
| Q56822818 | |
| Q58826805 | |
| Q58885861 | |
| Q59601214 | |
| Q60552203 | |
| Q60566514 | |
| Q60604421 | |
| Q60604481 | |
| Q60617266 | |
| Q61062718 | |
| Q61743771 | |
| Q61944361 | |
| Q61944387 | |
| Q61963488 | |
| Q61994009 | |
| Q62016445 | |
| Q62085985 | |
| Q62091380 | |
| Q62122110 | |
| Q62626907 | |
| Q62667366 | |
| Q62667399 | |
| Q62990563 | |
| Q63140495 | |
| Q63141476 | |
| Q63147897 | |
| Q63224222 | |
| Q63225379 | |
| Q63228573 | |
| Q64129385 | |
| Q64140539 | |
| Q64140675 | |
| Q64141630 | |
| Q64142542 | |
| Q64142585 | |
| Q64153989 | |
| Q64156353 | |
| Q64156446 | |
| Q64156493 | |
| Q64156914 | |
| Q64159898 | |
| Q64171693 | |
| Q64174236 | |
| Q64174237 | |
| Q64210396 | |
| Q64223558 | |
| Q64223721 | |
| Q64223730 | |
| Q64223758 | |
| Q64226233 | |
| Q64280455 | |
| Q64282369 | |
| Q64351495 | |
| Q64351725 | |
| Q64399737 | |
| Q64399772 | |
| Q64441604 | |
| Q64451739 | |
| Q64452485 | |
| Q64485602 | |
| Q64495249 | |
| Q64504181 | |
| Q64504293 | |
| Q64504343 | |
| Q64520631 | |
| Q64523123 | |
| Q64524420 | |
| Q64555028 | |
| Q64555189 | |
| Q64555231 | |
| Q64556144 | |
| Q64578398 | |
| Q64585327 | |
| Q64590304 | |
| Q64594647 | |
| Q64605658 | |
| Q64616136 | |
| Q64624736 | |
| Q64626731 | |
| Q64692014 | |
| Q64692215 | |
| Q64729766 | |
| Q64737145 | |
| Q64737478 | |
| Q64762049 | |
| Q64767831 | |
| Q64777784 | |
| Q64876326 | |
| Q64952500 | |
| Q64995541 | |
| Q65006911 | |
| Q65013040 | |
| Q65058344 | |
| Q65588984 | |
| Q65589121 | |
| Q66092063 | |
| Q66486277 | |
| Q67115913 | |
| Q84082329 | |
| Q84143629 | |
| Q84922653 | |
| Q86921402 | |
| Q96682831 | |
| Q99769691 | |
| Q101584186 | |
| Q104126196 | |
| Q104686899 | |
| Q106518433 | |
| Q106519771 | |
| Q63228576 | |
| Q63248655 | |
| Q63346170 | |
| Q63347906 | |
| Q63348799 | |
| Q63348832 | |
| Q63348995 | |
| Q63365893 | |
| Q63400148 | |
| Q63413116 | |
| Q63532607 | |
| Q63537108 | |
| Q63537174 | |
| Q63607673 | |
| Q63607678 | |
| Q63615187 | |
| Q63764512 | |
| Q63764921 | |
| Q63766124 | |
| Q63781072 | |
| Q63791339 | |
| Q63865632 | |
| Q63865633 | |
| Q63928594 | |
| Q63929018 | |
| Q63929022 | |
| Q63929026 | |
| Q63929052 | |
| Q63929123 | |
| Q63929128 | |
| Q63929153 | |
| Q63929166 | |
| Q63929188 | |
| Q63929206 | |
| Q63929209 | |
| Q63929211 | |
| Q63929243 | |
| Q63929258 | |
| Q63929307 | |
| Q63929323 | |
| Q63929324 | |
| Q63929340 | |
| Q63929374 | |
| Q63929375 | |
| Q63929384 | |
| Q63929396 | |
| Q63929397 | |
| Q63929422 | |
| Q63929432 | |
| Q63929445 | |
| Q63929447 | |
| Q63929457 | |
| Q63929465 | |
| Q63932525 | |
| Q63945501 | |
| Q63965965 | |
| Q63975157 | |
| Q63975305 | |
| Q63975366 | |
| Q63975557 | |
| Q63978256 | |
| Q63979256 | |
| Q64031647 | |
| Q64031739 | |
| Q64031924 | |
| Q64032175 | |
| Q64032638 | |
| Q64032728 | |
| Q64032761 | |
| Q64032959 | |
| Q64033377 | |
| Q64034460 | |
| Q64034615 | |
| Q64035116 | |
| Q64038074 | |
| Q64043969 | |
| Q64044365 | |
| Q64051695 | |
| Q64056386 | |
| Q64057331 | |
| Q64063467 | |
| Q64063745 | |
| Q64068338 | |
| Q64069403 | |
| Q64071790 | |
| Q64073047 | |
| Q64073803 | |
| Q64076211 | |
| Q64076366 | |
| Q64078250 | |
| Q64081097 | |
| Q64084024 | |
| Q64084178 | |
| Q64085484 | |
| Q64091813 | |
| Q64092237 | |
| Q64092987 | |
| Q64093425 | |
| Q64094738 | |
| Q64095559 |
Author
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
This script takes exactly 3 minutes to run after caching with
tidywikikidatar0.2