2a:null 2b:["$","title",null,{"children":"Analysis of New Mexico PPP data | Christopher L. Keller | Observable"}] 30:T4d6,Five industry sectors accounted for **${highestSectors.count.toLocaleString( "en-US", { style: "percent", minimumFractionDigits: 2 } )}** of the **${totalApprovedLoans.toLocaleString()}** loans approved for New Mexico companies under the Paycheck Protection Plan, according to the [latest Small Business Administration data](https://data.sba.gov/dataset/ppp-foia) released on July 1, 2021.

The top sectors are:

${key} accounted for ${value.percentOfCount.toLocaleString( 'en-US', { style: 'percent', minimumFractionDigits: 2 } )} of the approved loans and ${value.percentOfTotal.toLocaleString( 'en-US', { style: 'percent', minimumFractionDigits: 2 } )} of the total value of the loans approved.

In all, these five sectors accounted for **${highestSectors.totalAmount.toLocaleString( "en-US", { style: "currency", currency: "USD" } )}** — or **${highestSectors.total.toLocaleString("en-US", { style: "percent", minimumFractionDigits: 2 })}** — of the approved loans to New Mexico businesses.

31:T7a2,

PPP figures for ${query}

Number of approved PPP loans in ${query} ${parseInt(results.length).toLocaleString()} Total PPP loans approved in ${query} ${d3.sum(results, d => d.CurrentApprovalAmount).toLocaleString('en-US', {style: 'currency',currency: 'USD'})}

Median PPP loans approved in ${query} ${d3.median(results, d => d.CurrentApprovalAmount).toLocaleString('en-US', {style: 'currency',currency: 'USD'})} Average PPP loans approved in ${query} ${d3.mean(results, d => d.CurrentApprovalAmount).toLocaleString('en-US', {style: 'currency',currency: 'USD'})}

Smallest PPP loans approved in ${query} ${d3.min(results, d => d.CurrentApprovalAmount).toLocaleString('en-US', {style: 'currency',currency: 'USD'})} Largest PPP loans approved in ${query} ${d3.max(results, d => d.CurrentApprovalAmount).toLocaleString('en-US', {style: 'currency',currency: 'USD'})}

32:Tf6e,mapOfNewMexicoCountiesByTier = { // top level SVG const svg = d3 .create('svg') .attr('viewBox', `0 0 480 570`) .style('width', '600') .style('height', 'auto'); // grouping element const g = svg.append('g'); const baseGroup = g.append('g').attr('class', 'base'); svg .append("text") .attr("x", 385) .attr("y", 40) .attr("text-anchor", "middle") .style("font-size", "20px") .style("font-family", "Arial") .style("font-weight", "Bold") .style("text-decoration", "underline"); // .text("As of " + dateMapData); // the base county layer baseGroup .append('path') .datum(new_mexico) .attr('opacity', 0) .attr('fill', mapFillColor) .attr('stroke', '#ffffff') .attr('stroke-width', 1) .attr('d', path); // for the counties const countiesGroup = g.append('g').attr('class', 'counties'); countiesGroup .selectAll('.county') .data( topojson.feature( new_mexico_counties, new_mexico_counties.objects.cb_2015_new_mexico_county_20m ).features ) .join('path') .attr('class', 'county') .attr('opacity', 0) .attr('fill', mapFillColor) .attr('stroke', '#ffffff') .attr('stroke-width', 1) .attr('d', path); const countyTiers = g.append('g').attr('class', 'tiers'); countyTiers .selectAll('.tier') .data( topojson.feature( new_mexico_counties, new_mexico_counties.objects.cb_2015_new_mexico_county_20m ).features ) .join('path') // .on("mouseover", handleMouseOver) // .on("mouseout", handleMouseOut) .attr('class', 'tier') .attr('opacity', 1) .attr('stroke', '#ffffff') .attr('stroke-width', 1) .attr('d', path) .attr('fill', mapFillColor); /*ADD DATA HERE */ // .style('fill', function(d) { // var lookup = mapData.find(o => o.name === d.properties.NAME); // return "gray"; // if ('colorTier' in lookup) { // return lookup.colorTier; // } else if ('outlookColor' in lookup) { // if (lookup.outlookColor === 'red') { // return tierRed; // } else if (lookup.outlookColor === 'yellow') { // return tierYellow; // } else if (lookup.outlookColor === 'orange') { // return tierYellow; // } else if (lookup.outlookColor === 'green') { // return tierGreen; // } else { // return null; // } // } // }); // for cities const citiesGroup = g.append('g').attr('class', 'cities'); // for each city const cityCircles = citiesGroup .selectAll('.city') .data(selectedCities) .join('g') .attr('class', 'city') .attr('data-name', d => d.name) .attr( 'transform', d => `translate(${projection(d.coordinates)[0]}, ${ projection(d.coordinates)[1] })` ); // city circles cityCircles .append('circle') .attr('fill', '#222222') .attr('stroke', '#222222') .attr('cx', 0) .attr('cy', 0) .attr('r', 2); // city labels cityCircles .append('text') .attr('x', d => d.x || 0) .attr('y', d => d.y || -15) .attr('text-anchor', d => d.anchor || 'start') .attr('font-family', 'sans-serif') .attr('fill', 'none') // .attr('stroke', 'white') // .attr('stroke-width', '1') // .attr('stroke-opacity', '1') .attr('font-size', '14px') .attr('pointer-events', 'none') .attr('font-style', d => (d.type === 'neighborhood' ? 'italic' : null)) .text(d => d.name); cityCircles .append('text') .attr('x', d => d.x || -5) .attr('y', d => d.y || -5) .attr('text-anchor', d => d.anchor || 'start') .attr('font-family', 'sans-serif') .attr('fill', '#000000') .attr('font-size', '14px') .attr('pointer-events', 'none') .attr('font-style', d => (d.type === 'neighborhood' ? 'italic' : null)) .text(d => d.name); return svg.node(); }33:[{"id":"8f9786d20ce20367bfdfa9b56846c13db8d73f497d9fc430ca520b9022fcffb986e796e21430d8fd063c8abc62434efe4be1179399599711f4f765ca82b384dc","href":"https://static.observableusercontent.com/files/8f9786d20ce20367bfdfa9b56846c13db8d73f497d9fc430ca520b9022fcffb986e796e21430d8fd063c8abc62434efe4be1179399599711f4f765ca82b384dc","name":"nm_ppp@3.db","type":"application/x-sqlite3","lastModified":1628549241253.449,"size":19341312}] 2e:{"id":"55256457648ce385","slug":"analysis-of-new-mexico-ppp-data","title":"Analysis of New Mexico PPP data","thumbnail":"0bdd5d19eb1b0c226fc1d7c2a5161655784212d0bbf72b9622a1f334785e40c8","access_level":"public","create_time":"$D2021-08-09T21:39:50.427Z","update_time":"$D2021-08-10T23:26:52.436Z","view_time":null,"first_public_time":"$D2023-03-10T20:51:13.028Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"b1060e5bd7932c0c","login":"chrislkeller","name":"Christopher L. Keller","avatar_url":"https://avatars-next.observableusercontent.com/480c1b063ca680d305e90abbeef687017de8de8a546032d2b65d715341bd861a","tier":"starter_2024"},"version":1019,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"7e214d36195dad3a","login":"chrislkeller","name":"Christopher L. Keller","avatar_url":"https://avatars-next.observableusercontent.com/480c1b063ca680d305e90abbeef687017de8de8a546032d2b65d715341bd861a","tier":null}],"members":[{"type":"individual","id":"7e214d36195dad3a","login":"chrislkeller","name":"Christopher L. Keller","avatar_url":"https://avatars-next.observableusercontent.com/480c1b063ca680d305e90abbeef687017de8de8a546032d2b65d715341bd861a","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Analysis of New Mexico PPP data","cells":[{"id":0,"value":"# Analysis of New Mexico PPP data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"toc({\n title: \"What is here?\",\n headers: \"h2,h3,h4\",\n hideStartingFrom: null\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":371,"value":"----\n## Interviewing New Mexico PPP Data\n\n### Topline figures\n\nThe number of approved PPP loans in New Mexico is **${parseInt(ppp_loans.length).toLocaleString()}**.\n\nThe total amount of PPP loans in New Mexico is **${d3.sum(ppp_loans, d => d.CurrentApprovalAmount).toLocaleString('en-US', {style: 'currency',currency: 'USD'})}**.\n\nThe median approved PPP loan in New Mexico is **${d3\n .median(ppp_loans, (d) => d.CurrentApprovalAmount)\n .toLocaleString(\"en-US\", { style: \"currency\", currency: \"USD\" })}**.\n\nThe average approved PPP loan in New Mexico is **${d3\n .mean(ppp_loans, (d) => d.CurrentApprovalAmount)\n .toLocaleString(\"en-US\", { style: \"currency\", currency: \"USD\" })}**.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":966,"value":"totalApprovedLoans = d3\n .sum(ppp_loans, (d) => d.CurrentApprovalAmount)\n .toLocaleString(\"en-US\", { style: \"currency\", currency: \"USD\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":963,"value":"$30","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":959,"value":"highestSectors = {\n return {\n count: d3.sum(\n sortedSectorApprovedCount.slice(0, 5),\n (d) => d.value.percentOfCount\n ),\n total: d3.sum(\n sortedSectorApprovedCount.slice(0, 5),\n (d) => d.value.percentOfTotal\n ),\n totalAmount: d3.sum(\n sortedSectorApprovedCount.slice(0, 5),\n (d) => d.value.total\n ),\n pctOfTotal:\n d3.sum(sortedSectorApprovedCount.slice(0, 5), (d) => d.value.total) /\n d3.sum(ppp_loans, (d) => d.CurrentApprovalAmount)\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":420,"value":"### Count of PPP loans approved for New Mexico businesses by industry sector","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":425,"value":"Plot.plot({\n height: 500,\n marginLeft: 350,\n grid: true,\n x: {\n axis: \"bottom\",\n label: \"Count\"\n },\n y: {\n axis: \"left\",\n label: \"NAICS Category\",\n domain: d3\n .groupSort(\n ppp_loans,\n (g) => -g.length,\n (d) => d.name\n )\n .slice(0, 15)\n },\n color: {\n type: \"diverging\"\n },\n marks: [\n Plot.barX(\n ppp_loans,\n Plot.groupY({ x: \"count\", fill: \"count\" }, { y: \"name\" })\n ),\n Plot.text(\n ppp_loans,\n Plot.groupY({ text: \"count\" }, { x: 0, y: \"name\", dx: 50 })\n ),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":707,"value":"### Sum of PPP loans approved for New Mexico businesses by industry sector","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":711,"value":"Plot.plot({\n height: 500,\n marginLeft: 350,\n grid: true,\n x: {\n axis: \"bottom\",\n label: \"Sum of approved loans\"\n },\n y: {\n axis: \"left\",\n label: \"NAICS Category\",\n domain: d3\n .groupSort(\n ppp_loans,\n (g) => -d3.sum(g, (d) => d.CurrentApprovalAmount),\n (d) => d.name\n )\n .slice(0, 15)\n },\n color: {\n type: \"diverging\"\n },\n marks: [\n Plot.barX(\n ppp_loans,\n Plot.groupY(\n { x: \"sum\", fill: \"sum\" },\n { x: \"CurrentApprovalAmount\", y: \"name\" }\n )\n ),\n Plot.text(ppp_loans, {\n x: 0,\n y: \"name\",\n text: (d) => sum_by_sector.get(d.name),\n dx: 50\n }),\n // Plot.text(\n // ppp_loans,\n // Plot.groupY(\n // { text: \"sum\" },\n // { x: \"CurrentApprovalAmount\", y: \"name\", dx: 0 }\n // )\n // ),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":783,"value":"sum_by_sector = d3.rollup(\n ppp_loans,\n (g) =>\n d3\n .sum(g, (d) => d.CurrentApprovalAmount)\n .toLocaleString(\"en-US\", { style: \"currency\", currency: \"USD\" }),\n (d) => d.name\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":949,"value":"sortedSectorApprovedCount = {\n const sectorMetrics = d3Collect\n .nest()\n .key((d) => d.name)\n .rollup((v) => ({\n count: v.length,\n percentOfCount: v.length / ppp_loans.length,\n total: d3.sum(v, (d) => d.CurrentApprovalAmount),\n jobsReported: d3.sum(v, (d) => d.JobsReported),\n percentOfTotal:\n d3.sum(v, (d) => d.CurrentApprovalAmount) /\n d3.sum(ppp_loans, (d) => d.CurrentApprovalAmount),\n avg: d3.mean(v, (d) => d.CurrentApprovalAmount),\n median: d3.median(v, (d) => d.CurrentApprovalAmount),\n sectorApprovedLoans: v\n }))\n .entries(ppp_loans);\n let d = [...sectorMetrics];\n d.sort(function (a, b) {\n return b.value.count - a.value.count;\n });\n return d;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1009,"value":"Plot.plot({\n marginLeft: 60,\n x: {\n inset: 6\n },\n y: {\n label: null\n },\n marks: [\n Plot.dot(ppp_loans, { y: \"name)\", x: (d) => sum_by_sector.get(d.name) }),\n Plot.ruleY(\n ppp_loans,\n Plot.groupY(\n { x1: \"min\", x2: \"max\" },\n { y: \"name)\", x: (d) => sum_by_sector.get(d.name) }\n )\n ),\n Plot.tickX(\n ppp_loans,\n Plot.groupY(\n { x: \"median\" },\n { y: \"name)\", x: (d) => sum_by_sector.get(d.name), stroke: \"red\" }\n )\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":940,"value":"### Top lenders in New Mexico by number of approved loans","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":927,"value":"**${\n sortedLenderCount[0].key\n}** approved **${sortedLenderCount[0].value.count.toLocaleString(\n 'en-US'\n)}** Paycheck Protection Program loans for New Mexico companies, the highest number of the **${\n sortedLenderCount.length\n}** unique lenders found in the New Mexico data. That figure represents about **${sortedLenderCount[0].value.percentOfCount.toLocaleString(\n 'en-US',\n {\n style: 'percent',\n minimumFractionDigits: 2\n }\n)}** of the total number of loans approved for New Mexico companies.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":814,"value":"html`\n\n\n\n\n\n\n\n\n${sortedLenderCount\n // .filter(d => d.value.count >= 100)\n .slice(0, 10)\n .map(\n ({ key, value }) =>\n html`\n\n\n\n`\n )}

Lender	No. of Loans	Pct of Count	Total
${key}	${value.count.toLocaleString(\"en-US\")}	${value.percentOfCount.toLocaleString(\"en-US\", {\n style: \"percent\",\n minimumFractionDigits: 2\n })}	${value.total.toLocaleString(\"en-US\", {\n style: \"currency\",\n currency: \"USD\"\n })}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":845,"value":"sortedLenderCount = {\n const lenderMetrics = d3Collect\n .nest()\n .key((d) => d.OriginatingLender)\n .rollup((v) => ({\n count: v.length,\n percentOfCount: v.length / ppp_loans.length,\n total: d3.sum(v, (d) => d.CurrentApprovalAmount),\n percentOfTotal:\n d3.sum(v, (d) => d.CurrentApprovalAmount) /\n d3.sum(ppp_loans, (d) => d.CurrentApprovalAmount),\n avg: d3.mean(v, (d) => d.CurrentApprovalAmount),\n median: d3.median(v, (d) => d.CurrentApprovalAmount),\n lenderApprovedLoans: v\n }))\n .entries(ppp_loans);\n let d = [...lenderMetrics];\n d.sort(function (a, b) {\n return b.value.count - a.value.count;\n });\n return d;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":935,"value":"### Top lenders in New Mexico by total amount of approved loans","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":810,"value":"**${\n sortedLenderTotal[0].key\n}** approved the highest total amount of Paycheck Protection Program loans, recording **${sortedLenderTotal[0].value.total.toLocaleString(\n 'en-US',\n {\n style: 'currency',\n currency: 'USD'\n }\n)}** in approved loans for New Mexico companies. That figure represents about **${sortedLenderTotal[0].value.percentOfTotal.toLocaleString(\n 'en-US',\n {\n style: 'percent',\n minimumFractionDigits: 2\n }\n)}** of the total amount approved for New Mexico companies.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":905,"value":"html`\n\n\n\n\n\n\n\n\n${sortedLenderTotal\n // .filter(d => d.value.count >= 100)\n .slice(0, 10)\n .map(\n ({ key, value }) =>\n html`\n\n\n\n`\n )}

Lender	No. of Loans	Median Loan	Total Anount
${key}	${value.count.toLocaleString(\"en-US\")}	${value.median.toLocaleString(\"en-US\", {\n style: \"currency\",\n currency: \"USD\"\n })}	${value.total.toLocaleString(\"en-US\", {\n style: \"currency\",\n currency: \"USD\"\n })}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":902,"value":"sortedLenderTotal = {\n let d = [...sortedLenderCount];\n d.sort(function (a, b) {\n return b.value.total - a.value.total;\n });\n return d;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"----\n## Search the PPP Data\n\nSelect a New Mexico city to view 2021 Paycheck Protection Program data for that city.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":195,"value":"viewof query = Inputs.select(\n nm_cities.map((a) => a.clean_city),\n {\n type: \"search\",\n placeholder: \"Search NM PPP data\",\n value: \"Albuquerque\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":238,"value":"$31","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"### Distribution of approved PPP loans in ${query}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":226,"value":"Plot.plot({\n x: {\n round: true,\n label: \"Approved PPP Loan Amount\"\n },\n y: {\n grid: true,\n label: \"Count\"\n },\n marks: [\n Plot.rectY(\n results,\n Plot.binX(\n { y: \"count\" },\n {\n x: \"CurrentApprovalAmount\",\n fill: \"CurrentApprovalAmount\",\n normalize: true\n }\n )\n ),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":296,"value":"### Restaurant Revitalization Fund grants for ${query} ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":284,"value":"Inputs.table(results, {\n columns: [\n \"DateApproved\",\n \"BorrowerName\",\n \"clean_city\",\n \"CurrentApprovalAmount\",\n \"NAICSCode\"\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":196,"value":"results = db.query(`SELECT * FROM nm_ppp WHERE clean_city LIKE $1`, [\n `%${query}%`\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"----\n## Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":217,"value":"### Generate a list of New Mexico cities","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":209,"value":"nm_cities = db.query(\n `SELECT DISTINCT clean_city FROM nm_ppp ORDER BY clean_city ASC`\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":187,"value":"### Generate layout of data table","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":166,"value":"db.describe(\"nm_ppp\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":191,"value":"### Generate table of approved PPP loans","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":171,"value":"Inputs.table(ppp_loans)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":323,"value":"### Raw data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":172,"value":"ppp_loans = db.query(\n `SELECT * FROM nm_ppp INNER JOIN naics on nm_ppp.NAICSCode = naics.id ORDER BY clean_city ASC;`\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"### Import the database","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":163,"value":"db = FileAttachment(\"nm_ppp@3.db\").sqlite()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"mapHeader = md`\n----\n## Map of New Mexico\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"viewof cities = Checkbox(cityList.map(d => d.name).sort(), {\n label: \"Cities\",\n value: [\n 'Alamogordo',\n 'Albuquerque',\n 'Carlsbad',\n 'Clayton',\n 'Clovis',\n 'Deming',\n 'Estancia',\n 'Farmington',\n 'Fort Sumner',\n 'Gallup',\n 'Grants',\n 'Hobbs',\n 'Las Cruces',\n 'Las Vegas',\n 'Lordsburg',\n 'Los Alamos',\n 'Los Lunas',\n 'Reserve',\n 'Roswell',\n 'San Ysidro',\n 'Santa Fe',\n 'Santa Rosa',\n 'Santa Teresa',\n 'Silver City',\n 'Socorro',\n 'Taos',\n 'Tierra Amarilla',\n 'Truth or Consequences'\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"selectedCities = cityList.filter(d => cities.includes(d.name))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"importsHeader = md`\n## Imports\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"visualHeader = md`\n### Maps & Graphics Imports\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"import {\n chartFonts,\n chartAxis,\n toc,\n tooltip,\n projection,\n path,\n new_mexico,\n new_mexico_counties,\n cityList,\n counties,\n calculatePctChange,\n commasize,\n jenks,\n jenksMatrices\n} from \"@chrislkeller/boilerplate-imports-for-graphics\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":156,"value":"import { SummaryTable } from \"@observablehq/summary-table\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"import { Plot } from \"@observablehq/plot\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":120,"value":"viewof mapFillColor = color({\n title: \"Base map fill color\",\n value: \"#e6e6e6\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":110,"value":"packagesHeader = md`\n### Package Imports\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":153,"value":"ss = require(\"https://unpkg.com/simple-statistics@6.1.0/dist/simple-statistics.min.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"vl = require.alias({\n vega: \"vega@5.9.0\",\n \"vega-lite\": \"vega-lite@4.17.0\"\n})(\"vega-embed@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":626,"value":"d3 = require(\"d3\")\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":847,"value":"d3Collect = require(\"d3-collection\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"GeoJSON = require('geojson@0.5.0/geojson.js').catch(() => window[\"GeoJSON\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"topojson = require(\"topojson-client@3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"userImports = md`\n### User Imports\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"import {\n Button,\n Checkbox,\n Radio,\n Range,\n Select,\n Text,\n Search,\n Table,\n html\n} from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":122,"value":"import { color } from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"import {serialize} from \"@palewire/saving-csv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1"}} 2f:"$2e:body"