35:null 36:["$","title",null,{"children":"Pennsylvania 2020 General Election Mail Ballot Requests Analysis | Mario Delgado | Observable"}] 3c:T4fc,fetchURL = { /* dateofbirth : https://dev.socrata.com/foundry/data.pa.gov/mcba-yywm This is the voter's date of birth. The reason some birth dates will display as 1/1/1800 is due to confidentiality reasons of the registered votes. Usually this is for victims of domestic violence. ballotreturndate : https://dev.socrata.com/foundry/data.pa.gov/mcba-yywm This is the date the county marked the ballot as received after the voter mailed the voted ballot back to the county. where : https://dev.socrata.com/docs/queries/where.html date_extract_y : https://dev.socrata.com/docs/functions/date_extract_y.html limit : https://dev.socrata.com/docs/paging.html */ const filterYear = 2020 - minimumAge; const yearExtract = "date_extract_y(dateofbirth)"; let fetchURL = `${jsonDataURL}?$limit=5000000&$where=${yearExtract} <= ${filterYear} AND ${yearExtract} != 1800`; fetchURL += ` AND ballotreturneddate <= '2020-11-03T23:59:59'`; return fetchURL; } 3d:[{"id":"11642bec436a224ab9d4d1d45360184882cd2906048cc50cd3a4c558fab0741885c5b504758a08f0093a33a7f226dbe396584052ef9519bdfcf0fc95a71fd41d","href":"https://static.observableusercontent.com/files/11642bec436a224ab9d4d1d45360184882cd2906048cc50cd3a4c558fab0741885c5b504758a08f0093a33a7f226dbe396584052ef9519bdfcf0fc95a71fd41d","name":"Capture2.PNG","type":"image/png","lastModified":1606514162657.193,"size":63137}] 3a:{"id":"4da7130f31bf8db9","slug":"pennsylvania-2020-general-election-mail-ballot-requests-a","title":"Pennsylvania 2020 General Election Mail Ballot Requests Analysis","thumbnail":"798ab2a57f4aa349c0a1cc54add15541845a8b9eedbd72e4596aa8e525f441f6","access_level":"public","create_time":"$D2020-11-06T16:19:02.904Z","update_time":"$D2020-12-13T19:17:06.036Z","view_time":null,"first_public_time":"$D2020-11-06T19:46:46.540Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"f57b9f8a19d28778","login":"mariodelgadosr","name":"Mario Delgado ","avatar_url":"https://avatars-next.observableusercontent.com/2d2982ad09c4ca9dfd6570810ae00301e0db6ef798c4f7025ea03d4325d4807d","tier":"starter_2024","bio":"Designing and Engineering a Better Tomorrow","following":false},"version":461,"publish_version":461,"role":null,"authored":false,"authors":[{"type":"individual","id":"1d3988d482a8ec0f","login":"mariodelgadosr","name":"Mario Delgado ","avatar_url":"https://avatars-next.observableusercontent.com/2d2982ad09c4ca9dfd6570810ae00301e0db6ef798c4f7025ea03d4325d4807d","tier":null,"bio":"Designing and Engineering a Better Tomorrow","following":false}],"members":[{"type":"individual","id":"1d3988d482a8ec0f","login":"mariodelgadosr","name":"Mario Delgado ","avatar_url":"https://avatars-next.observableusercontent.com/2d2982ad09c4ca9dfd6570810ae00301e0db6ef798c4f7025ea03d4325d4807d","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":{"id":"9d4bfb0224d7ba04","slug":"election-2020","title":"Election 2020","owner":{"id":"f57b9f8a19d28778","login":"mariodelgadosr","name":"Mario Delgado "}},"type":"notebook","body":{"titling":"auto","title":"Pennsylvania 2020 General Election Mail Ballot Requests Analysis","cells":[{"id":0,"value":"md`# Pennsylvania 2020 General Election Mail Ballot Requests Analysis\n\n* Open Data Source: https://data.pa.gov/Government-Efficiency-Citizen-Engagement/2020-General-Election-Mail-Ballot-Requests-Departm/mcba-yywm\n\n* [API](https://dev.socrata.com/foundry/data.pa.gov/mcba-yywm) Endpoint to data from data source: https://data.pa.gov/resource/mcba-yywm.json (***Caution***: unfiltered data set is VERY large.)\n`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":157,"value":"md `## Age Analysis\n* Filters on database query:\n * Birth date not equal to 1/1/1800. According to the [data dictionary](https://dev.socrata.com/foundry/data.pa.gov/mcba-yywm), this date is used for confidentiality of ballot requestor(s).\n\n * Returned by 2020-11-03; election day 2020.\n\n * Minimum age of ${minimumAge}.\n\n* **Background**: [List of oldest living people in the United States (110+)](https://gerontology.wikia.org/wiki/List_of_oldest_living_people_in_the_United_States) has:\n * Three (3) individuals from Pennsylvania as of November 6, 2020. \n * Only one (1) individual is older than 112 years old.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"viewof minimumAge = select({\n title: \"Requesting Voter Age is Equal to or Greater than:\",\n description: \"Select Minimum Age\",\n options: d3.range(95,166).reverse(),\n value: 112\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"{ \n\n const title = \n `${d3.format(\",\")(ageData.length)} ballot(s) requested and returned with minimum age of ${minimumAge} by county`;\n \n const x = vl.x().fieldO(\"countyname\")\n .sort({field:\"countyname\", op: \"count\", order: \"descending\"})\n .title(\"County\");\n\n \n const y = vl.y().count().title(\"Ballot Requests\");\n \n\n\n const color = vl.color().fieldN(\"mailapplicationtype\").title(\"Application Type\");\n\n return vl.markBar({tooltip: true})\n .title(title)\n .data(ageData)\n .encode(x,y,color)\n .width(width * .8)\n .height(350)\n .render();\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":229,"value":"{ \n\n const title = \n `${d3.format(\",\")(ageData.length)} ballot(s) requested and returned with minimum age of ${minimumAge} by Age`;\n \n const x = vl.x().fieldO(\"age\")\n .sort(\"ascending\")\n .title(\"Voter age when application was issued\");\n\n \n const y = vl.y().count().title(\"Count of Ballot Requests\");\n \n\n\n const color = vl.color().fieldN(\"mailapplicationtype\").title(\"Application Type\");\n\n return vl.markBar({tooltip: true})\n .title(title)\n .data(ageData)\n .encode(x,y,color)\n .width(width * .8)\n .height(350)\n .render();\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"jsonDataURL = \"https://data.pa.gov/resource/mcba-yywm.json\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":61,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"ageData = \n{ \n //https://developer.mozilla.org/en-US/docs/Web/API/Fetch_API\n const data = await fetch(fetchURL).then(response => response.json());\n \n // 3.15576e+10 = 365.25 * 24 * 60 * 60 * 1000\n // Age when the application was issued \n data.forEach(d => d.age = Math.floor((new Date(d.appissuedate) - new Date(d.dateofbirth).getTime()) / 3.15576e+10)); \n return data.filter(d => d.age >= minimumAge); \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":119,"value":"md `### ${d3.format(\",\")(ageData.length)} ballot(s) requested and returned with minimum age of ${minimumAge}. \n\nUse '↓' at lower right of table to download an extract.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":107,"value":"table(ageData.sort((a,b) => a.dateofbirth > b.dateofbirth),{limit:ageData.length})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":311,"value":"md `## Mailed/Returned Analysis`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":254,"value":"md `### ${d3.format(\",\")(novData.length)} 'MAILIN' ballots mailed by Pennsylvania in November (1st, 2nd or 3rd) and returned by Nov 3, 2020 (election day)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":266,"value":"{ \n\n const title = \n `${d3.format(\",\")(novData.length)} ballot(s) mailed by Pennsylvania in November and returned by election day`;\n \n const x = vl.x().fieldO(\"ballotreturneddate\")\n .timeUnit(\"monthdate\")\n .title(\"Return Date\");\n\n \n const y = vl.y().count().title(\"Ballot Requests\");\n \n const color = vl.color().fieldN(\"countyname\").title(\"County\");\n\n return vl.markBar({tooltip: true})\n .title(title)\n .data(novData)\n .encode(x,y,color)\n .width(width * .8)\n .height(350)\n .render();\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":258,"value":"novData= {\n \n const fetchURL = `https://data.pa.gov/resource/mcba-yywm.json?$where= mailapplicationtype='MAILIN' AND\n date_extract_m(ballotsentdate)=11 AND date_extract_m(ballotreturneddate)=11 AND date_trunc_ymd(ballotreturneddate)<='2020-11-03'&$limit=4000000`;\n \n const data = await fetch(fetchURL)\n .then(function(response){\n return response.json();\n }); \n \n return data; \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":323,"value":"table(novData)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":288,"value":"md `### 'MAILIN' ballots mailed by Pennsylvania on Nov 3, 2020 and returned on Nov 3, 2020 (election day)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":292,"value":"{ \n\n const title = \n `${d3.format(\",\")(nov3Data.length)} ballot(s) mailed and returned on Nov 3, 2020 (election day)`;\n \n\n const theta = vl.theta().count().fieldQ(\"countyname\").title(\"Ballot Requests\");\n \n const color = vl.color().fieldN(\"countyname\").title(\"County\");\n\n return vl.markArc({tooltip: true})\n .title(title)\n .data(nov3Data)\n .encode(theta,color)\n .width(width * .9)\n .height(350)\n .render();\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":285,"value":"nov3Data = novData.filter(d => d.ballotsentdate.substring(0,10) == \"2020-11-03\" && d.ballotreturneddate.substring(0,10) == \"2020-11-03\");","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":327,"value":"table(nov3Data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":335,"value":"processAnalysis = md `## ${process} Workflow Analysis for [MAILIN or OLMAILV 'mailapplicationtype'](https://dev.socrata.com/foundry/data.pa.gov/mcba-yywm) requests\n\n* **Related**: [Pennsylvania Mail-in Ballot Database Tampered With After the Epochtimes Article Published ](https://ballotwatcher.blogspot.com/2020/11/pennsylvania-ballot-database-tampered.html)\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":437,"value":"html`\n

${viewof process}

${viewof legend}

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":368,"value":"{ \n\n const title = \n `${d3.format(\",\")(processData.length)} ${process}(s) (mailapplicationtype = 'MAILIN' or 'OLMAILV') Returned Before ${process == \"Application\" ? 'Issued' : 'Sent'}`;\n \n const field = legend == \"County\" ? \"countyname\" : \"party\";\n\n const theta = vl.theta().count().fieldQ(field).title(`${process} Requests`);\n \n const color = vl.color().fieldN(field).title(`${legend == \"County\" ? \"County\" : \"Party\"}`);\n\n return vl.markArc({tooltip: true})\n .title(title)\n .data(processData)\n .encode(theta,color)\n .width(width * .9)\n .height(350)\n .render();\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":381,"value":"md `### Database Column Definitions (from [data dictionary](https://dev.socrata.com/foundry/data.pa.gov/mcba-yywm)): \n\n* **appissuedate**: Date the application was submitted by the voter. \n* **appreturndate**: Date the application was processed by the county election office.\n* **ballotsentdate**: Date the county confirmed the application to queue a ballot label to mail the ballot materials to the voter. \n* **ballotreturneddate**: Date the county marked the ballot as received after the voter mailed the voted ballot back to the county.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":338,"value":"processData = \n{\n \n const where = process == \"Application\" ? \"appreturndate < appissuedate\" \n : \"ballotreturneddate < ballotsentdate\"; \n const query = \n \"SELECT * WHERE \" + where + \" AND mailapplicationtype IN ('MAILIN','OLMAILV')\";\n \n let fetchURL = jsonDataURL + \"?$query=\";\n fetchURL += query;\n \n const data = await fetch(fetchURL)\n .then(function(response){\n return response.json();\n }); \n \n\n return data; \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":364,"value":"table(processData)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":447,"value":"md`🢇 Click cell to exapand code for ***viewof process***` ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":391,"value":"viewof process = radio({\n title: 'Process',\n description: 'Select process for analysis.',\n options: ['Application','Ballot'],\n value: 'Ballot'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":449,"value":"md`🢇 Click cell to exapand code for ***viewof legend***` ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":428,"value":"viewof legend = radio({\n title: 'Legend',\n description: 'Select legend visualization.',\n options: ['County','Party'],\n value: 'County'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"md `## Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"d3 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"import {select,radio} from \"@jashkenas/inputs\"\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":104,"value":"import { table } from \"@gampleman/table\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":179,"value":"import {vl} from '@vega/vega-lite-api'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":161,"value":"md `## Updates\n\n* 11/23/2020: Data was [removed from data.pa.gov](https://data.pa.gov/browse?sortBY=newest)\n\n * **Related**: [Pennsylvania pulls the data](https://www.dolthub.com/blog/2020-11-09-debunking-election-fraud/#Update).\n\n* 12/2/2020: [Data](https://data.pa.gov/resource/mcba-yywm.json) is on-line again.\n\n${ await FileAttachment(\"Capture2.PNG\").image()}\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3d","stdlib":"1"}} 3b:"$3a:body"