3c:null 3d:["$","title",null,{"children":"Supreme Court Justice Nominations | Giuseppe Sollazzo | Observable"}] 43:Ta9c,plot = addTooltips( Plot.plot({ width:1200, height:730, style: {backgroundColor:"transparent", fontFamily:"Domine"}, x: {label:null, domain:[-2.25, 2.25], ticks:false}, y: {label:null, domain:[-1.25,2.25], ticks:false}, facet: {data:nominees, y:"row_index", x:"column_index", label:null}, marks:[ //dot - create arc of votes, positional arguments included in data Plot.dot(votes, {x:"x",y:"y", r:6, title: d => d.senator + d.state + ' (' + d.party + ')\n' + d.original_vote, fy:"row_index", fx:"column_index", //if then logic for color mapping fill: d=> d.vote==="Yea" && d.party==="D" ? "#154FD6" : d.vote==="Yea" && d.party==="R" ? "#EB0000" : d.vote==="Yea" && d.party==="I" ? "grey" :"white", stroke: d=> d.party==="D" ? "#154FD6" : d.party==="R" ? "#EB0000" : "grey"}), //dot - used for image border Plot.dot(nominees, {fill:"black", y: d=> 0.15, x: d=> 0, r:32}), //image - SCOTUS nominee Plot.image(nominees, {x:0, y:0.15, src:"image", width:60}), //text - SCOTUS nominee Plot.text(nominees, {text:"nominee", y: d=> -0.65, x: d=> 0, fontSize:16, fontWeight:'bold'}), //text - nominating president Plot.text(nominees, {text: d=> 'Nominated by\n' + d.president + ' (' + d.president_party + ')', fill:'#666666',y: d=> -1.02, x: d=> 0, fontSize:11}), //text - aggregate Dem votes Plot.text(nominees, {text: d=> "Dem Yeas", y:-0.35, x:-1.5, fill:"#154FD6", fontSize:13, fontFamily:"Open Sans", fontWeight:'bold'}), Plot.text(nominees, {text: d=> Math.round((d.dem_yeas/d.total_dem)*100)+"%", y:-.725, x:-1.5, fill:"#154FD6", fontSize:20, fontWeight:'bold', fontFamily:"Open Sans"}), Plot.text(nominees, {text: d=> d.dem_yeas + '/' + d.total_dem, y:-1.1, x:-1.5, fill:"#154FD6", fontSize:13, fontFamily:"Open Sans"}), //text - aggregate Rep votes Plot.text(nominees, {text: d=> "Rep Yeas", y:-0.35, x:1.5, fill:"#EB0000", fontSize:13, fontFamily:"Open Sans", fontWeight:'bold'}), Plot.text(nominees, {text: d=> Math.round((d.rep_yeas/d.total_rep)*100)+"%", y:-.725, x:1.5, fill:"#EB0000", fontSize:20, fontWeight:'bold', fontFamily:"Open Sans"}), Plot.text(nominees, {text: d=> d.rep_yeas + '/' + d.total_rep, y:-1.1, x:1.5, fill:"#EB0000", fontSize:13, fontFamily:"Open Sans"}), ] }), {fill:"green", "stroke-width": "3px", stroke: "green"} )44:[{"id":"90cfe8ed3a1d59d780ad90c79ed8f91f6a0d0afbb5520921b191a3346f58d91fd06fb03e0657dba1de90db4ad769f868868d8bc4159297198776f8574fe86110","href":"https://static.observableusercontent.com/files/90cfe8ed3a1d59d780ad90c79ed8f91f6a0d0afbb5520921b191a3346f58d91fd06fb03e0657dba1de90db4ad769f868868d8bc4159297198776f8574fe86110","name":"supreme-court-justices.jpeg","type":"image/jpeg","lastModified":1685630406626.318,"size":2557894},{"id":"64a1df20893d862d2979a0e9e607f80c2dfce0be2a0733c883edae7976cd81504cdc37b35c310755efb500938a656cb92e807da7276c9f8a2cf60b610108d43a","href":"https://static.observableusercontent.com/files/64a1df20893d862d2979a0e9e607f80c2dfce0be2a0733c883edae7976cd81504cdc37b35c310755efb500938a656cb92e807da7276c9f8a2cf60b610108d43a","name":"scotus-nominee-votes@1.csv","type":"text/csv","lastModified":1685630406626.318,"size":95108}] 41:{"id":"838aa57c985d3272","slug":null,"title":"Supreme Court Justice Nominations","thumbnail":"a80c9654fce9fe88259fe98620e7654bd978d25a491ce860f7901b5dafaecee8","access_level":"public","create_time":"$D2023-06-01T14:40:06.626Z","update_time":"$D2023-06-01T14:40:06.626Z","view_time":null,"first_public_time":"$D2023-06-01T14:40:06.626Z","has_unpublished_edits":null,"fork":{"id":"6c17f4b11c38626e","slug":null,"title":"Supreme Court Justice Nominations","owner":{"id":"230f604926360997","login":"tashapiro","name":"Tanya Shapiro"}},"stars":0,"starred":false,"owner":{"type":"team","id":"d201b910f522c5b4","login":"puntofisso","name":"Giuseppe Sollazzo","avatar_url":"https://avatars-next.observableusercontent.com/435a12885939dcd83a498fa92eb6feff6145bae663fedcd9aeb51ffdc9cce2c1","tier":"starter_2024","bio":"Personal Profile.\r\nHead of AI Skunkworks @NHSx, formerly Head of Data @departmentfortransport, formerly known as \"The Open Data Rottweiler\". Always a techie."},"version":380,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"25c4fb47bd957b2b","login":"puntofisso","name":"Giuseppe Sollazzo","avatar_url":"https://avatars-next.observableusercontent.com/435a12885939dcd83a498fa92eb6feff6145bae663fedcd9aeb51ffdc9cce2c1","tier":null,"bio":"Personal Profile.\r\nHead of AI Skunkworks @NHSx, formerly Head of Data @departmentfortransport, formerly known as \"The Open Data Rottweiler\". Always a techie."}],"members":[{"type":"individual","id":"25c4fb47bd957b2b","login":"puntofisso","name":"Giuseppe Sollazzo","avatar_url":"https://avatars-next.observableusercontent.com/435a12885939dcd83a498fa92eb6feff6145bae663fedcd9aeb51ffdc9cce2c1","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Supreme Court Justice Nominations","cells":[{"id":61,"value":"# Supreme Court Justice Nominations\nObservable Plot recreation of a plot I created with R **ggplot2** and supporting ggplot2 libraries. Data scraped from the U.S. Senate gov website using rvest.\n\nSimilar to ggplot2, you can **facet** an Observable Plot. In this example, I'm using a facet to create a plot per Supreme Court Justice with their respective Senate Confirmation votes. \n
\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":99,"value":"

U.S. Supreme Court Justice Confirmations

Justices of the United States Supreme Court are appointed by the President and confirmed by the Senate. The President nominates a candidate to fill a vacancy, after which the Senate Judiciary Committee holds hearings on the nominee. The committee then makes a recommendation to the full Senate, which holds a vote. A simple majority (51 of 100) is required to confirm a nominee. The graphic uses Senate Roll Call data to show the vote results for the last 12 appointed justices.

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"title","database":"$undefined"},{"id":10,"value":"$43","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":132,"value":"# Original for Comparison\nThe original plot was created in R with ggplot2, ggimage, and ggtext. Positional arguments for x and y were created with an additional package, ggparliament.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":134,"value":"supremeCourtJustices = FileAttachment(\"supreme-court-justices.jpeg\").image()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":318,"value":"# Tooltip\nImport tooltip feature from Mike Freeman's notebook. Observable expected to release its own tooltip feature soon.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":320,"value":"import {Plot} from \"@mkfreeman/plot-tooltip\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":332,"value":"import {addTooltips} from \"@mkfreeman/plot-tooltip\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":0,"value":"# Data\nImport data from csv file. Data scraped from Senate gov website. Positional arguments created with R ggparliament.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":346,"value":"scotus_votes = await FileAttachment(\"scotus-nominee-votes@1.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"scotus_votes","database":"$undefined"},{"id":375,"value":"# SQL Queries\nUse SQL to create two new data sets: 1) clean the votes data to add some indexes for the facets (requires a mapping for x and y facet) and 2) create an aggregated data set at the justice level to tally votes for Dems and Reps.\n\n## Cleaned up Votes","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":6,"value":"select a. * ,\n case when a.nominee_index<5 then 1\n when a.nominee_index<9 then 2\n when a.nominee_index<13 then 3\n end as row_index\n ,case when a.nominee_index IN (1,5,9) then 1\n when a.nominee_index IN (2,6,10) then 2\n when a.nominee_index IN (3,7,11) then 3\n when a.nominee_index IN (4,8,12) then 4\n end as column_index\n ,'https://raw.github.com/tashapiro/supreme-court-justices/main/images/' || UPPER(nominee) || '.png' as image\n from\n (select s. * ,\n case when s.nominee = 'Souter' then 1\n when s.nominee='Thomas' then 2\n when s.nominee='Ginsburg' then 3\n when s.nominee='Breyer' then 4\n when s.nominee='Roberts' then 5\n when s.nominee='Alito' then 6\n when s.nominee='Kagan' then 7\n when s.nominee='Sotomayor' then 8\n when s.nominee='Gorsuch' then 9\n when s.nominee='Kavanaugh' then 10\n when s.nominee='Barrett' then 11\n when s.nominee = 'Jackson' then 12 end as nominee_index\nfrom scotus_votes s\n) a","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"votes","database":"var:scotus_votes"},{"id":379,"value":"## Aggregate Data at Justice Level","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":169,"value":"select \n nominee, column_index, row_index, image \n ,case \n when nominee IN ('Souter','Thomas') then 'George H.W. Bush'\n when nominee IN ('Ginsburg','Breyer') then 'Bill Clinton'\n when nominee IN ('Alito','Roberts') then 'George W. Bush'\n when nominee IN ('Kagan','Sotomayor') then 'Barack Obama'\n when nominee IN ('Gorsuch','Kavanaugh','Barrett') then 'Donald Trump'\n when nominee='Jackson' then 'Joe Biden' else '' end as president\n ,case when nominee IN ('Souter','Thomas','Alito','Roberts','Gorsuch','Kavanaugh','Barrett') then 'R'\n else 'D' end as president_party\n ,count(case when party='D' and vote='Yea' then senator end) as dem_yeas\n ,count(case when party='D' then senator end) as total_dem\n ,count(case when party='R' and vote='Yea' then senator end) as rep_yeas\n ,count(case when party='R' then senator end) as total_rep\n from votes\ngroup by 1,2,3,4","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"nominees","database":"var:votes"},{"id":314,"value":"# CSS\nApply additional stylings, including trick to hide facet labels.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":97,"value":"","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"css","database":"$undefined"}],"files":"$W44","stdlib":"1"}} 42:"$41:body"