2b:null 2c:["$","title",null,{"children":"New Mexico Capital Outlay requests cookbook for the 2022 legislative session | Christopher L. Keller | Observable"}] 32:T7d2,---- ## What is this and what do I do with it? You might think of this project as a Blue Apron box for reporting on Capital Outlay requests and appropriations in New Mexico. The Capital Outlay process creates a lot of data in a lot of different formats that don't always line up with each other. There are requests and sponsors for those requests and a final appropriation and now data that shows who allocated what. For New Mexico journalists already reporting on the giant slalom that is the legislative session, acquiring, cleaning and parsing all of that Capital Outlay data presents some challenges. It can limit the depth of their reporting. So we wanted to do some of the heavy lifting, so to speak. So we boxed up some ingredients, wrote some recipes and now we want to get this into your hands. Why did we do this? At the end of the day, we believe in collaborative journalism as a mechanism to ensure stories important to New Mexico get told. To that end, we wanted to make it easier to report and tell stories about the Capital Outlay process. We've gathered 2,379 requests for capital outlay submitted by the Jan. 13 deadline. We scraped the details, categorized them and [made them searchable](https://observablehq.com/@chrislkeller/new-mexico-capital-outlay-applications-2022-legislative#cell-1405). These are the ingredients. We also came up with [some recipes](https://observablehq.com/@chrislkeller/new-mexico-capital-outlay-applications-2022-legislative#cell-2534) and added some [context and background](https://observablehq.com/@chrislkeller/new-mexico-capital-outlay-applications-2022-legislative#cell-324) as a side dish. In the coming days, we should be finished parsing the New Mexico House and Senate's sponsored project lists. In the weeks after the Capital Outlay bill is signed — and assuming [2021's House Bill 55 is followed](https://nmfog.org/nmfog-urges-governor-to-sign-hb-55/) — once the list of appropriations come out, we'll link those up as well.33:T1cbd,---- ## What is Capital Outlay in New Mexico? The [Property Control Act](https://www.nmlegis.gov/sessions/01%20Regular/FinalVersions/HB0556FV.html) defines a capital outlay project as the "acquisition, improvement, alteration or reconstruction of assets of a long-term character that are intended to continue to be held or used, including land, buildings, machinery, furniture and equipment." The Act continues: "A 'capital outlay project' includes all proposed expenditures related to the entire undertaking." Capital outlay appropriations cannot be used for operating expenses, salaries, materials and supplies, events, brochures, pamphlets and publications and retroactive reimbursements of previous purchases. ### How much money is at stake in 2022? As the 2022 session enters its final days, legislators could have access to more than $550 million to spend on capital projects, [according to a Legislative Council Service from October 2021](https://www.nmlegis.gov/Publications/Info_Bulletins/2021/Capital_Outlay_Primer_For_2022.pdf). That estimate doesn't take into account money set aside for water projects, tribal and colonias infrastructure, public school infrastructure and other projects. ### What does the 2022 process look like? Some [2,379 capital outlay project requests](https://observablehq.com/@chrislkeller/new-mexico-capital-outlay-applications-2022-legislative#cell-2598) were submitted for this session of the legislature by the Jan. 13 deadline, according to our analysis of the data. From there, [according to the Legislative Finance Committee](https://www.nmlegis.gov/Entity/LFC/Documents/Finance_Facts/finance%20facts%20capital%20outlay.pdf) and the [Legislative Council Service](https://www.nmlegis.gov/Publications/Info_Bulletins/2021/Capital_Outlay_Primer_For_2022.pdf): * After allocating money to statewide projects, the House and Senate leadership take any remaining money and divide it between members of the respective chamber for possible projects. The Legislative Finance Committee notes that "this process has not been formalized in law or legislative rules." * After the deadline to introduce bills, the capital outlay requests (CORs) — also known as sponsored project lists — are introduced. These documents show the capital outlay projects that each member of the House and each member of the Senate intend to sponsor. These documents contain project titles, descriptions and dollar amounts. [Here's an example](https://www.nmlegis.gov/Sessions/22%20Regular/capitaloutlays/house/HCO0001.pdf) from House Minority Whip [Rod Montoya](https://www.nmlegis.gov/members/Legislator?SponCode=HMONR) (R-Farmington). [Here's an example](https://www.nmlegis.gov/Sessions/22%20Regular/capitaloutlays/senate/SCO0008.pdf) from Senator [Katy M. Duhigg](https://www.nmlegis.gov/members/Legislator?SponCode=HMONR) (D-Albuquerque). * After legislators select capital outlay projects to allocate money to, allocations are added to a single bill that is voted on in both chambers, and upon passage, sent to the governor. The governor can then sign the legislation outright, or use whole or partial vetoes to remove projects. ### What happened last year? Leadership in the House and the Senate divvied up Capital Outlay money so that each representative received **$1,314,000** and each senator received **$2,190,000**, [according to an analysis of Capital Outlay projects by sponsor prepared by the Legislative Council Service](https://www.nmlegis.gov/Publications/Capital_Outlay/HB285%20Capital%20Projects%20Publication%20by%20County%20with%20Sponsor,%202021.pdf). New Mexico legislators appropriated about [$511,591,153](https://www.nmlegis.gov/Publications/Capital_Outlay/HB285%20Capital%20Projects%20Publication%20by%20County%20with%20Sponsor,%202021.pdf) in capital outlay money during the 2021 legislative session in [House Bill 285](https://www.nmlegis.gov/Legislation/Legislation?chamber=H&legType=B&legNo=285&year=21). The House unanimously passed the bill on March 16, 2021, and the Senate followed suit on March 19 with unanimous approval. Gov. Michelle Lujan Grisham signed the bill on April 9. Using 23 vetoes and seven partial vetoes, Lujan Grisham struck about $400,000 in general fund projects and $5.8 million in severance tax bond projects that — according to the [governor's veto message](https://www.nmlegis.gov/Sessions/21%20Regular/ExecMessages/house/HB0285GovMsg.pdf) — lacked "proper planning or are not ready to proceed." The governor's vetoes totaled about 1.2% of the total capital outlay appropriated in House Bill 285. Also in 2021, [House Bill 55](https://www.nmlegis.gov/Legislation/Legislation?Chamber=H&LegType=B&LegNo=55&year=21) allowed for the Legislative Council Service for the first time to publish "a searchable list" of capital outlay projects approved by the legislature, including projects later vetoed. The searchable list amounted to nothing more than a PDF, but it did contain the name of each legislator or governor, the name of the project and the amount of the allocation designated by each legislator and the governor. The legislation mandates the list be published "30 days after adjournment of each legislative session in which a capital projects list is approved by the Legislature." For the 2022 session, that date is approximately March 19, 2022. ### How far back does Capital Outlay spending go? In 2015, [Think New Mexico](https://www.thinknewmexico.org/), which calls itself a nonpartisan think tank, published a [36-page report](https://www.thinknewmexico.org/wp-content/uploads/pdfs/CapitalOutlayReportWeb.pdf) that traced the origins of Capital Outlay spending in New Mexico back to a piece of 1977 legislation. Dubbed the “Christmas Tree Bill,” according to the Think New Mexico report, the bill contained 27 distinct bills from both chambers that sought money for capital projects. Yes, it had what [amounted to an ASCII Christmas tree](https://nmindepth.com/2015/10/04/think-new-mexico-calls-for-capital-outlay-reform/) on the cover of the bill. ### Where does Capital Outlay money come from? In short, it comes from bonds issued against the state’s taxes on oil, gas, and minerals. ### What about the so-called "Junior Bill?" We [don't talk about](https://www.youtube.com/watch?v=bvWRMAU6V-c) the [Junior Bill](https://nmindepth.com/2021/04/29/lawmakers-continue-secret-spending/), no, no. Seriously, legislators don't.

This year, House Bill 55 brought greater transparency to the capital outlay process.

Do you know what also should be transparent? "Junior" appropriation allocations.#NMLEG pic.twitter.com/muk8c8fNKn
— Matthew McQueen (@mcqueenfornm) April 23, 2021

However, the [fiscal impact report for the Senate Bill 48 — 2022 Junior Bill — is available](https://www.nmlegis.gov/Sessions/22%20Regular/firs/SB0048.PDF). It contains $25.2 million. Half is for recurring spending and half is for nonrecurring spending.34:Tf5e,---- ## How did we do this? To say New Mexico's Capital Outlay process is unique is a bit of an understatement. Still, the process belongs to the entities that request money to complete projects, the legislators who decide how to appropriate money allocated to them and the people who learn about the process through the media. In order to better understand the flow of money through the Capital Outlay process, we decided to start with the requests submitted in advance of the 2022 legislative session. We intend to follow the money through the allocation phase of the process and determine which projects received money and which did not. **How was the data acquired?** We wrote a series of computer programs using the [Python](https://www.python.org/) programing language to download the text of each Capital Outlay request and structure it in the form of a .csv file. That .csv file forms the basis for this project. **How was the data cleaned and vetted** Using a spreadsheet application, we went through each row looking for inconsistencies. In some cases, the county name and a dollar figure were transposed. In other cases, linebreaks or punctuation split fields necessarily. In these cases, we did what we could to "clean" the data and offer some level of standardization. Outside of county names, we did not correct spelling errors or grammatical mistakes. While we have vetted the data and done what we can to bulletproof it, that doesn't mean there aren't errors or outliers that defy explanation. For instance, there is a [Parks/Recreation request for $20](https://www.nmlegis.gov/CapitalOutlayWeb/Summary?ID=2376) to "plan, design and construct improvements to Ventana Ranch Park to include but not limited to, the construction of a tennis administrative office and supporting infrastructure" that affects the mean for Bernalillo County as well as the Parks/Recreation category. We have not inquired to see if this amount — or any amount — is accurate. **How were categories determined?** We read through all ${capitalOutlayData.length.toLocaleString('en-US')} requests for Capital Outlay and did our best to arrive at a way to characterize the project. Some, such as a [community septic system for the La Bajada Community Ditch in Santa Fe County](https://www.nmlegis.gov/CapitalOutlayWeb/Summary?ID=262), are straightforward. Others, such as [the purchase of a prairie dog eradication machine known as the PERC 620 rodent control exhaust fumigator for the Colfax Soil and Water Conservation District in Colfax county](https://www.nmlegis.gov/CapitalOutlayWeb/Summary?ID=411), were not. Still, we tried. We also added what we call tags to allow for crossover categories and a further level of characterization. These tags can be found in the [data downloads](https://observablehq.com/@chrislkeller/new-mexico-capital-outlay-applications-2022-legislative#cell-2072), but we did not chart or analyze them. **How can I describe this process in a news story [nerd box](https://github.com/propublica/guides/blob/master/news-apps.md#methodology)?** I might offer you this as a starting point for some boilerplate language: `This analysis stemmed from more than 2,300 requests for Capital Outlay submitted by a Jan. 13, 2022 deadline and in advance of the New Mexico legislature's regular session. The data compiled for public use, reporting and research offer a detailed look at the projects across New Mexico's 33 counties in need of infrastructure money. While the data provides new insights, it does have limitations. Some of the data contained seemingly low values for the amount requested. The data also has spelling errors and incorrect grammar when it comes to project titles and descriptions. Still, the Capital Outlay request data provides the best look at the projects that New Mexico legislators will choose to sponsor, and ultimately allocate money to during the 2022 legislative session.`35:Td69,---- ## Data dictionary | column field | type | description | ------------------------------------ | ------- | ------------------------| | `url` | link | The https address linking to the Capital Outlay request submitted online. | | `id` | integer | Pulled from the Capital Outlay request submitted online, this identifies the request. | | `title` | string | Name of the project pulled from the title of the Capital Outlay request submitted online. Often contains abbreviations and shorthand. We made the editorial decision to lowercase for analysis purposes. | | `fiscal_agent` | string | Typically an administrative agency or an educational institution, this information is pulled from the Capital Outlay request submitted online. | | `owner` | string | Pulled from the Capital Outlay request submitted online and identifies the agency, entity or administrative unit requesting the allocation. | | `req_amt` | integer | Pulled from the Capital Outlay request submitted online, this is the amount being requested for the proposed project. | | `description` | text | Pulled from the Capital Outlay request submitted online and provides a sentence or two to describe the proposed project. | | `location` | string | Pulled from the Capital Outlay request submitted online and identifies the location of the proposed project. | | `county` | string | Pulled from the Capital Outlay request submitted online, this identifies the county where the project will be completed. | | `portion_funded` | integer | A dollar figure provided in the Capital Outlay request submitted online that represents how much of the project has been allocated already. | | `total_cost` | integer | A dollar figure provided in the Capital Outlay request submitted online that represents the estimated cost of the project. | | `contact_name` | string | The name of the individual heading the project outlined in the Capital Outlay request submitted online. | | `contact_title` | string | The title of the individual heading the project outlined in the Capital Outlay request submitted online. | | `contact_phone` | string | The contact phone number of the individual heading the project outlined in the Capital Outlay request submitted online. | | `contact_email` | string | The email address of the individual heading the project outlined in the Capital Outlay request submitted online. | | `icip_id` | integer | The Industrial & Commercial Incentive Program code pulled from the Capital Outlay request submitted online. | | `primary_category_proper` | string | Subjective value in an added column, used to identify the kind of project requested in the Capital Outlay request submitted online. | | `primary_category` | integer | Integer value added in a column, used to identify the kind of project requested in the Capital Outlay request submitted online. | | `tag_1` | string | Essentially a subcategory, this is a subjective value in an added column, used to identify the kind of project requested in the Capital Outlay request submitted online. | | `tag_2` | string | Essentially a subcategory, this is a subjective value in an added column, used to identify the kind of project requested in the Capital Outlay request submitted online. | | `tag_3` | string | Essentially a subcategory, this is a subjective value in an added column, used to identify the kind of project requested in the Capital Outlay request submitted online. |36:T50f,The table below shows the **${appropriationQueryResults.length.toLocaleString()} projects** in **${queryAppropriations} County** that received Capital Outlay appropriations in **[Senate Bill 212](https://www.nmlegis.gov/Legislation/Legislation?Chamber=S&LegType=B&LegNo=212&year=22)**. The **${appropriationQueryResults.length.toLocaleString()} projects** represent **${((appropriationQueryResults.length/appropriationData.length) * 100).toLocaleString('en-US', { minimumFractionDigits: 2 })}%** of all appropriations in **[Senate Bill 212](https://www.nmlegis.gov/Legislation/Legislation?Chamber=S&LegType=B&LegNo=212&year=22)** approved during New Mexico's 2022 legislative session. In total **${queryAppropriations} County** received **${d3.sum(appropriationQueryResults, d => d.amount).toLocaleString('en-US', {style: 'currency',currency: 'USD'})}** for Capital Outlay projects. That figure represents **${(d3.sum(appropriationQueryResults, d => d.amount) / totalCapitalOutlayAppropriated * 100).toLocaleString('en-US', { minimumFractionDigits: 2 })}%** of the **$${totalCapitalOutlayAppropriated.toLocaleString('en-US', { minimumFractionDigits: 2 })}** appropriated by New Mexico's legislators.37:Tdf0,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 state level 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 = dataChartMap.find((o) => o.name === d.properties.NAME); if (lookup === undefined) { return "red"; } else { return colorScale(lookup.value); } }); // 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(); }38:T20e3,newMexicoCountyPopulation = [ { county: "Eddy", population: 57437, affgeoid: "05000US35015", geoid: "35015", name: "Eddy", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "McKinley", population: 72290, affgeoid: "05000US35031", geoid: "35031", name: "McKinley", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Valencia", population: 76456, affgeoid: "05000US35061", geoid: "35061", name: "Valencia", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Los Alamos", population: 18356, affgeoid: "05000US35028", geoid: "35028", name: "Los Alamos", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Colfax", population: 12353, affgeoid: "05000US35007", geoid: "35007", name: "Colfax", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Lea", population: 69611, affgeoid: "05000US35025", geoid: "35025", name: "Lea", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Socorro", population: 17000, affgeoid: "05000US35053", geoid: "35053", name: "Socorro", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Luna", population: 24264, affgeoid: "05000US35029", geoid: "35029", name: "Luna", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Doña Ana", population: 217522, affgeoid: "05000US35013", geoid: "35013", name: "Doña Ana", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Chaves", population: 64689, affgeoid: "05000US35005", geoid: "35005", name: "Chaves", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Union", population: 4175, affgeoid: "05000US35059", geoid: "35059", name: "Union", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Sandoval", population: 145179, affgeoid: "05000US35043", geoid: "35043", name: "Sandoval", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Mora", population: 4563, affgeoid: "05000US35033", geoid: "35033", name: "Mora", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Curry", population: 50199, affgeoid: "05000US35009", geoid: "35009", name: "Curry", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Cibola", population: 26978, affgeoid: "05000US35006", geoid: "35006", name: "Cibola", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "De Baca", population: 2060, affgeoid: "05000US35011", geoid: "35011", name: "De Baca", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Guadalupe", population: 4382, affgeoid: "05000US35019", geoid: "35019", name: "Guadalupe", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Hidalgo", population: 4371, affgeoid: "05000US35023", geoid: "35023", name: "Hidalgo", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Roosevelt", population: 19117, affgeoid: "05000US35041", geoid: "35041", name: "Roosevelt", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "San Juan", population: 125043, affgeoid: "05000US35045", geoid: "35045", name: "San Juan", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Otero", population: 66781, affgeoid: "05000US35035", geoid: "35035", name: "Otero", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Taos", population: 32888, affgeoid: "05000US35055", geoid: "35055", name: "Taos", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Santa Fe", population: 150056, affgeoid: "05000US35049", geoid: "35049", name: "Santa Fe", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Bernalillo", population: 678701, affgeoid: "05000US35001", geoid: "35001", name: "Bernalillo", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "San Miguel", population: 28034, affgeoid: "05000US35047", geoid: "35047", name: "San Miguel", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Sierra", population: 11135, affgeoid: "05000US35051", geoid: "35051", name: "Sierra", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Catron", population: 3539, affgeoid: "05000US35003", geoid: "35003", name: "Catron", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Rio Arriba", population: 39307, affgeoid: "05000US35039", geoid: "35039", name: "Rio Arriba", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Grant", population: 28061, affgeoid: "05000US35017", geoid: "35017", name: "Grant", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Lincoln", population: 19482, affgeoid: "05000US35027", geoid: "35027", name: "Lincoln", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Quay", population: 8373, affgeoid: "05000US35037", geoid: "35037", name: "Quay", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Torrance", population: 15595, affgeoid: "05000US35057", geoid: "35057", name: "Torrance", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" }, { county: "Harding", population: 459, affgeoid: "05000US35021", geoid: "35021", name: "Harding", source: "ACS 2018 5-year", baseUrl: "http://embed.censusreporter.org.s3.amazonaws.com/1.0/data/profiles/2018/" } ]39:[] 2f:{"id":"36e0a853995afeab","slug":"new-mexico-capital-outlay-applications-2022-legislative","title":"New Mexico Capital Outlay requests cookbook for the 2022 legislative session","thumbnail":"19e17dafd58557e8145c0f729ff19ff8b2b2af5ccee5071e3682ac835adf2d07","access_level":"public","create_time":"$D2021-12-23T03:32:40.874Z","update_time":"$D2024-08-21T19:29:34.856Z","view_time":null,"first_public_time":"$D2021-12-23T04:49:38.525Z","fork":true,"stars":1,"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":3217,"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"},{"type":"individual","id":"a90e60cf72899efd","login":"russbiggs","name":"Russ Biggs","avatar_url":"https://avatars-next.observableusercontent.com/8b3a015f2d31671b4aad0217b98d3c024f15d09a73b8b30b6bcdf5f76320c25c","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":{"id":"73f7720dad2594d6","slug":"new-mexico-2022-capital-outlay","title":"New Mexico 2022 Capital Outlay","owner":{"id":"b1060e5bd7932c0c","login":"chrislkeller","name":"Christopher L. Keller"}},"type":"notebook","body":{"title":"New Mexico Capital Outlay requests cookbook for the 2022 legislative session","cells":[{"id":0,"value":"md`# New Mexico Capital Outlay requests cookbook for the 2022 legislative session`","pinned":false,"hidden":false,"mode":"ojs"},{"id":71,"value":"toc({\n title: \"Table of Contents\",\n headers: \"h2,h3,h5\",\n hideStartingFrom: null\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1235,"value":"$32","pinned":false,"hidden":false,"mode":"md"},{"id":324,"value":"$33","pinned":false,"hidden":false,"mode":"md"},{"id":3195,"value":"mermaid`graph TD\n'Applications'-->'House'\n'Applications'-->'Senate'\n'House'-->'Governor'\n'Senate'-->'Governor'\n`","pinned":true,"hidden":false,"mode":"ojs"},{"id":2514,"value":"$34","pinned":false,"hidden":false,"mode":"md"},{"id":3036,"value":"$35","pinned":false,"hidden":false,"mode":"md"},{"id":2559,"value":"----\n## Who has contributed to this project?\n\n### Principals\n\n* [Russ Biggs](https://www.russbiggs.com/), software developer and open data evangelist\n* [Chris Keller](https://chrislkeller.com/), managing editor [Albuquerque Business First](https://www.bizjournals.com/albuquerque/)\n\n### Feedback, perspective and data work\n\n* [Marjorie Childress](https://nmindepth.com/author/mchildress/), managing editor, New Mexico In Depth\n* [Sandra Fish](https://twitter.com/fishnette), data journalist who covered Capital Outlay for [New Mexico In Depth](https://nmindepth.com/author/sandrafish/)\n\n### Inspiration\n\n* Circle On A Line charts inspired by [Census Reporter](https://censusreporter.org/data/distribution/?table=B28002&geo_ids=04000US35,040|01000US&primary_geo_id=04000US35) and [Ryan Pitts](https://twitter.com/ryanpitts), [Joe Germuska](https://twitter.com/JoeGermuska), [Ian Dees](https://twitter.com/iandees) and [Sara Schnadt](https://twitter.com/SaraSchnadt).","pinned":false,"hidden":false,"mode":"md"},{"id":2534,"value":"----\n\n## How do I take these ingredients and cook up some stories?\n\nAhead of the close of the legislative session on Feb. 17, there are a handful of stories you can tell with this data.\n\nOne example would be to look at the number of requests from your particular area of New Mexico, the amount requested and the category of the requests. Another story might look at statewide trends to see if certain categories of projects are more prevalent in a particular area of New Mexico.","pinned":false,"hidden":false,"mode":"md"},{"id":3136,"value":"----\n\n## What can I do with Capital Outlay appropriations data?\n\nNew Mexico legislators this week passed Senate Bill 212 which appropriates **$${totalCapitalOutlayAppropriated.toLocaleString('en-US', { minimumFractionDigits: 2 })}** toward infastructure projects around the state.\n\nNew Mexico Gov. Michelle Lujan Grisham now has the opportunity to sign the bill as is or exercise her authority to veto projects. The governor has until March 9 to do so.\n\nClick the button below to download the Capital Outlay appropriations data as a .csv file or find projects approved for a particular county below. ","pinned":false,"hidden":false,"mode":"md"},{"id":3124,"value":"DOM.download(\n serialize(appropriationData),\n \"2022-02-16-nm-sfc-sb212-appropriations-by-county\",\n \"Download Capital Outlay Appropriations data as a .csv\"\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3140,"value":"viewof queryAppropriations = Inputs.select(\n appropriationData\n .map((a) => a.county)\n .filter((value, index, self) => self.indexOf(value) === index)\n .sort(d3.ascending),\n {\n type: \"search\",\n placeholder: \"Search Capital Outlay appropriations by County\",\n value: \"Bernalillo\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3151,"value":"$36","pinned":false,"hidden":false,"mode":"md"},{"id":3130,"value":"Inputs.table(appropriationQueryResults, {\n columns: [\"county\", \"project_name\", \"amount\"],\n rows: 15,\n width: {\n title: \"45%\"\n },\n header: {\n county: \"County\",\n project_name: \"Project name\",\n amount: \"Amount\"\n },\n align: {\n req_amt: \"left\"\n },\n sort: \"county\",\n reverse: true,\n layout: \"fixed\",\n format: {\n amount: (x) =>\n parseInt(x).toLocaleString(\"en-US\", {\n style: \"currency\",\n currency: \"USD\"\n })\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":7,"value":"----\n\n## What can I do with county-level data?\n\nUse this section to view and compare county-level data about Capital Outlay requests for the 2022 legislative session. \n\nSelecting a New Mexico county below will change the data and offer some details about Capital Outlay requests from entities in that county. You can use the button below to download data for an individual county and analyze it in your preferred application. ","pinned":false,"hidden":false,"mode":"md"},{"id":197,"value":"viewof query = Inputs.select(\n capitalOutlayData\n .map((a) => a.county)\n .filter((value, index, self) => self.indexOf(value) === index)\n .sort(d3.ascending),\n {\n type: \"search\",\n placeholder: \"Search Capital Outlay applications by County\",\n value: \"Bernalillo\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1250,"value":"The table below shows the **${countyQueryResults.length.toLocaleString()}** requests from **${query} County** entities and contains links to the applications.\n\nClick the button below to download the **${query} County** data as a .csv file. ","pinned":false,"hidden":false,"mode":"md"},{"id":2716,"value":"DOM.download(\n serialize(countyQueryResults),\n `${countyQueryResults[0].county}`.toLowerCase() + \"_county_capital_outlay\",\n \"Download \" + `${countyQueryResults[0].county}` + \" County data as a .csv\"\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":276,"value":"Inputs.table(\n countyQueryResults.map((d) => ({\n request: {\n url: \"https://www.nmlegis.gov/CapitalOutlayWeb/Summary?ID=\" + d.id,\n title: d.title\n },\n ...d\n })),\n {\n columns: [\"request\", \"req_amt\", \"primary_category_proper\"],\n rows: 15,\n width: {\n title: \"45%\"\n },\n header: {\n request: \"Request\",\n req_amt: \"Requested Amount\",\n primary_category_proper: \"Primary category\"\n },\n align: {\n req_amt: \"left\"\n },\n sort: \"req_amt\",\n reverse: true,\n layout: \"fixed\",\n format: {\n request: (request) =>\n htl.html`${request.title}`,\n req_amt: (x) =>\n parseInt(x).toLocaleString(\"en-US\", {\n style: \"currency\",\n currency: \"USD\"\n })\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":861,"value":"### Number of requests by county\n\nThe **${countyQueryResults.length.toLocaleString()} Capital Outlay applications** submitted for **${query} County** projects represents **${((countyQueryResults.length/capitalOutlayData.length) * 100).toLocaleString('en-US', { minimumFractionDigits: 2 })}%** of all applications in for New Mexico's 2022 legislative session.\n\nThe chart below shows how the total number of applications in **${query} County** compares to other counties.","pinned":false,"hidden":false,"mode":"md"},{"id":795,"value":"Plot.plot({\n height: 100,\n width: 1200,\n marginTop: 0,\n marginLeft: 25,\n marginRight: 25,\n marginBottom: 30,\n inset: 20,\n grid: true,\n // Configure the x scale\n x: {\n type: \"log\", // set the type\n axis: \"bottom\",\n label: \"→ \" + \"Count\",\n grid: true,\n domain: d3.extent(countyCount, (d) => d.value)\n },\n marks: [\n Plot.dotX(countyCount, {\n x: \"value\",\n r: 10,\n strokeWidth: 1,\n fill: (d) => (d.name === `${query}` ? countyFillColor : \"#aba194\"),\n title: (d) => `${d.name}: ${d.value}`\n }),\n Plot.text(countyCount, {\n filter: (d) => d.name === `${query}`,\n x: \"value\",\n text: (d) => d.name,\n dy: -30\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1140,"value":"### Total amount requested by county\n\nEntities in **${query} County** requested **${d3.sum(countyQueryResults, d => d.req_amt).toLocaleString('en-US', {style: 'currency',currency: 'USD'})}** in Capital Outlay money for projects. That figure represents **${(d3.sum(countyQueryResults, d => d.req_amt) / totalCapitalOutlayRequested * 100).toLocaleString('en-US', { minimumFractionDigits: 2 })}%** of the total Capital Outlay money requested for New Mexico's 2022 legislative session.\n\nThe chart below shows how the total amount requested by **${query} County** entities compares to other counties.\n","pinned":false,"hidden":false,"mode":"md"},{"id":1130,"value":"Plot.plot({\n height: 100,\n width: 1200,\n marginTop: 0,\n marginLeft: 25,\n marginRight: 25,\n marginBottom: 30,\n inset: 20,\n grid: true,\n // Configure the x scale\n x: {\n type: \"log\",\n axis: \"bottom\",\n label: \"→ \" + \"Total Amount Requested\",\n grid: true,\n domain: d3.extent(countyTotal, (d) => d.value)\n },\n marks: [\n Plot.dotX(countyTotal, {\n x: \"value\",\n r: 10,\n strokeWidth: 1,\n fill: (d) => (d.name === `${query}` ? countyFillColor : \"#aba194\"),\n title: (d) =>\n `${d.name}: ${d.value.toLocaleString(\"en-US\", {\n style: \"currency\",\n currency: \"USD\"\n })}`\n }),\n Plot.text(countyTotal, {\n filter: (d) => d.name === `${query}`,\n x: \"value\",\n text: (d) => d.name,\n dy: -30\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1173,"value":"### Min, Max, Mean and Median at the county level\n\nCapital Outlay applications in **${query} County** ranged from a minimum of ${d3.min(countyQueryResults, d => d.req_amt).toLocaleString('en-US', {style: 'currency',currency: 'USD'})} to a maximum of ${d3.max(countyQueryResults, d => d.req_amt).toLocaleString('en-US', {style: 'currency',currency: 'USD'})}\n\nThe median amount requested is ${d3.median(countyQueryResults, d => d.req_amt).toLocaleString('en-US', {style: 'currency',currency: 'USD'})}. The mean amount requested is ${d3.mean(countyQueryResults, d => d.req_amt).toLocaleString('en-US', {style: 'currency',currency: 'USD'})}.","pinned":false,"hidden":false,"mode":"md"},{"id":1282,"value":"myChart = Plot.plot({\n height: 100,\n width: 1200,\n marginTop: 0,\n marginLeft: 25,\n marginRight: 25,\n marginBottom: 30,\n inset: 20,\n grid: true,\n x: {\n type: \"log\",\n axis: \"bottom\",\n label: null,\n grid: true,\n domain: d3.extent(mmmmCountyStats, (d) => d.value)\n },\n marks: [\n Plot.dotX(mmmmCountyStats, {\n x: \"value\",\n r: 10,\n strokeWidth: 1,\n fill: countyFillColor,\n title: (d) =>\n `${d.name}:\\n${d.value.toLocaleString(\"en-US\", {\n minimumFractionDigits: 2\n })}`\n }),\n Plot.text(mmmmCountyStats, {\n x: \"value\",\n text: (d) =>\n `${d.name}:\\n${d.value.toLocaleString(\"en-US\", {\n minimumFractionDigits: 2\n })}`,\n dy: -30\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1262,"value":"----\n\n## What can I do with category-level data?\n\nUse this section to view and compare category-level data about Capital Outlay requests for the 2022 legislative session.\n\nSelecting a project category below will change the data and offer some details about Capital Outlay requests for projects fitting that category. You can use the button below to download data for an individual category and analyze it in your preferred application. ","pinned":false,"hidden":false,"mode":"md"},{"id":2968,"value":"viewof categoryQuery = Inputs.select(\n capitalOutlayData\n .map((a) => a.primary_category_proper)\n .filter((value, index, self) => self.indexOf(value) === index)\n .sort(d3.ascending),\n {\n type: \"search\",\n placeholder: \"Search Capital Outlay applications by Category\",\n value: \"Community/Cultural\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3001,"value":"The table below shows the **${categoryQueryResults.length.toLocaleString()}** requests for **${categoryQuery}** projects and contains links to the applications.\n\nClick the button below to download the **${categoryQuery}** data as a .csv file.","pinned":false,"hidden":false,"mode":"md"},{"id":3006,"value":"DOM.download(\n serialize(categoryQueryResults),\n `${categoryQueryResults[0].primary_category_proper}`.toLowerCase() +\n \"_county_capital_outlay\",\n \"Download \" +\n `${categoryQueryResults[0].primary_category_proper}` +\n \" project request data as a .csv\"\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":612,"value":"### Number of requests by category\n\nThe **${categoryQueryResults.length.toLocaleString()} Capital Outlay requests** submitted for **${categoryQuery}** projects represents **${((categoryQueryResults.length/capitalOutlayData.length) * 100).toLocaleString('en-US', { minimumFractionDigits: 2 })}%** of all requests for New Mexico's 2022 legislative session.\n\nThe chart below shows how the total number of **${categoryQuery}** requests compares to other categories.","pinned":false,"hidden":false,"mode":"md"},{"id":1455,"value":"Plot.plot({\n height: 100,\n width: 1200,\n marginTop: 0,\n marginLeft: 25,\n marginRight: 25,\n marginBottom: 30,\n inset: 20,\n grid: true,\n // Configure the x scale\n x: {\n type: \"log\",\n axis: \"bottom\",\n label: \"→ \" + \"Count\",\n grid: true,\n domain: d3.extent(categoryCount, (d) => d.value)\n },\n marks: [\n Plot.dotX(categoryCount, {\n x: \"value\",\n r: 10,\n strokeWidth: 1,\n fill: (d) =>\n d.name === `${categoryQuery}` ? categoryFillColor : \"#aba194\",\n title: (d) => `${d.name}:\\n${d.value}`\n }),\n Plot.text(categoryCount, {\n x: \"value\",\n text: (d) => d.name,\n dy: -30\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2384,"value":"Plot.plot({\n height: 800,\n width: 1200,\n marginTop: 0,\n marginLeft: 150,\n marginRight: 50,\n marginBottom: 25,\n inset: 50,\n grid: true,\n x: {\n axis: \"bottom\",\n label: \"→ \" + \"Count\",\n grid: true,\n domain: d3.extent(categoryCount, (d) => d.value)\n },\n y: {\n axis: \"left\",\n label: \"Category\",\n domain: d3.sort(categoryCount, (d) => -d.value).map((d) => d.name)\n },\n color: {\n type: \"sequential\",\n scheme: \"blues\"\n },\n marks: [\n Plot.barX(categoryCount, { x: \"value\", y: \"name\", fill: \"value\" }),\n Plot.text(categoryCount, {\n x: \"value\",\n y: \"name\",\n text: \"value\",\n dx: 50\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":614,"value":" ### Total amount requested by category\n\nCapital Outlay requests for **${categoryQuery}** projects totaled **${d3.sum(categoryQueryResults, d => d.req_amt).toLocaleString('en-US', {style: 'currency',currency: 'USD'})}**. That figure represents **${(d3.sum(categoryQueryResults, d => d.req_amt) / totalCapitalOutlayRequested * 100).toLocaleString('en-US', { minimumFractionDigits: 2 })}%** of the total Capital Outlay money requested for New Mexico's 2022 legislative session.\n\nThe chart below shows how the total amount requested for **${categoryQuery}** projects compares to other categories.\n","pinned":false,"hidden":false,"mode":"md"},{"id":1444,"value":"Plot.plot({\n height: 100,\n width: 1200,\n marginTop: 0,\n marginLeft: 25,\n marginRight: 25,\n marginBottom: 30,\n inset: 20,\n grid: true,\n // Configure the x scale\n x: {\n type: \"log\", // set the type\n axis: \"bottom\",\n label: \"→ \" + \"Sum\",\n grid: true,\n domain: d3.extent(categoryTotal, (d) => d.value)\n },\n marks: [\n Plot.dotX(categoryTotal, {\n x: \"value\",\n r: 10,\n strokeWidth: 1,\n fill: (d) =>\n d.name === `${categoryQuery}` ? categoryFillColor : \"#aba194\",\n title: (d) =>\n `${d.name}:\\n${d.value.toLocaleString(\"en-US\", {\n style: \"currency\",\n currency: \"USD\"\n })}`\n }),\n Plot.text(categoryTotal, {\n x: \"value\",\n text: (d) => d.name,\n dy: -30\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":866,"value":"Plot.plot({\n height: 800,\n width: 1200,\n marginTop: 0,\n marginLeft: 150,\n marginRight: 50,\n marginBottom: 25,\n inset: 50,\n grid: true,\n x: {\n axis: \"bottom\",\n label: \"→ \" + \"Amount\",\n grid: true,\n domain: d3.extent(categoryTotal, (d) => d.value)\n },\n y: {\n axis: \"left\",\n label: \"Category\",\n domain: d3.sort(categoryTotal, (d) => -d.value).map((d) => d.name)\n },\n color: {\n type: \"sequential\",\n scheme: \"blues\"\n },\n marks: [\n Plot.barX(categoryTotal, { x: \"value\", y: \"name\", fill: \"value\" }),\n Plot.text(categoryTotal, {\n x: \"value\",\n y: \"name\",\n text: \"value\",\n dx: 50\n })\n ]\n})\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":617,"value":"### Min, Max, Mean and Median at the category level","pinned":false,"hidden":false,"mode":"md"},{"id":1556,"value":"dotplot = Plot.plot({\n height: 600,\n width: 1200,\n marginTop: 0,\n marginLeft: 150,\n marginRight: 50,\n marginBottom: 50,\n inset: 50,\n grid: true,\n // Configure the x scale\n x: {\n // axis: null\n axis: \"bottom\",\n type: \"log\",\n label: null,\n // label: \"→ \" + \"Amount\",\n grid: true\n // domain: d3.extent(totalPerCapita, (d) => d.sum)\n },\n y: {\n // axis: null\n axis: \"left\",\n // type: \"linear\",\n label: \"↑ \" + \"Category\",\n grid: true\n // domain: d3.extent(totalPerCapita, (d) => d.pop)\n },\n marks: [\n Plot.dot(mmmmCategoryDisplay, {\n y: \"category\",\n x: \"value\",\n r: 10,\n strokeWidth: 1,\n fill: categoryFillColor,\n title: (d) =>\n `${d.name}\\n${d.value.toLocaleString(\"en-US\", {\n style: \"currency\",\n currency: \"USD\"\n })}`\n }),\n Plot.text(mmmmCategoryDisplay, {\n y: \"category\",\n x: \"value\",\n text: (d) => d.name,\n dy: -15\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1799,"value":"### Min, Max, Mean and Median at the category level","pinned":false,"hidden":false,"mode":"md"},{"id":1755,"value":"Plot.plot({\n height: 1000,\n width: 1200,\n marginTop: 0,\n marginLeft: 150,\n marginRight: 50,\n marginBottom: 50,\n inset: 50,\n grid: true,\n // Configure the x scale\n x: {\n // axis: null\n axis: \"bottom\",\n type: \"linear\",\n label: null,\n // label: \"→ \" + \"Amount\",\n grid: true\n // domain: d3.extent(mmmmCategoryBoxPlot, (d) => d.value)\n },\n y: {\n // axis: null\n axis: \"left\",\n type: \"band\",\n label: \"↑ \" + \"Category\",\n grid: true\n },\n marks: [\n Plot.ruleY(\n mmmmCategoryBoxPlot,\n Plot.groupY({ x1: iqr1, x2: iqr2 }, { x: \"value\", y: \"name\" })\n ),\n Plot.barX(\n mmmmCategoryBoxPlot,\n Plot.groupY(\n { x1: quartile1, x2: quartile3 },\n { x: \"value\", y: \"name\", fill: categoryFillColor }\n )\n ),\n Plot.tickX(\n mmmmCategoryBoxPlot,\n Plot.groupY({ x: \"median\" }, { x: \"value\", y: \"name\", strokeWidth: 2.5 })\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1276,"value":"## Comparing per capita\n\n**${query} County** entities submitted about **${requestsPerCapita.find(x => x.name === query).value.toLocaleString('en-US', { minimumFractionDigits: 2 })} requests** and **${totalPerCapita.find(x => x.name === query).value.toLocaleString('en-US', {style: 'currency',currency: 'USD'})}** per 100,000 people.","pinned":false,"hidden":false,"mode":"md"},{"id":1380,"value":"### Plotting population versus number of applications","pinned":false,"hidden":false,"mode":"md"},{"id":1327,"value":"Plot.plot({\n height: 500,\n width: 1200,\n marginTop: 10,\n marginLeft: 80,\n marginRight: 50,\n marginBottom: 50,\n inset: 20,\n grid: true,\n // Configure the x scale\n x: {\n type: \"linear\", // set the type\n axis: \"bottom\",\n label: \"→ \" + \"Count\",\n grid: true,\n domain: d3.extent(requestsPerCapita, (d) => d.value)\n },\n y: {\n type: \"linear\", // set the type\n axis: \"left\",\n label: \"↑ \" + \"Population\",\n grid: true,\n domain: d3.extent(requestsPerCapita, (d) => d.pop)\n },\n marks: [\n Plot.dotX(requestsPerCapita, {\n y: \"pop\",\n x: \"value\",\n r: 10,\n strokeWidth: 1,\n fill: (d) => (d.name === `${query}` ? countyFillColor : \"#aba194\"),\n title: (d) => `${d.name}:\\n${d.value}`\n })\n // Plot.text(requestsPerCapita, {\n // filter: (d) => d.name === `${query}`,\n // x: \"count\",\n // text: (d) => d.name,\n // dy: 30\n // })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1387,"value":"### Plotting population versus amount requested in applications","pinned":false,"hidden":false,"mode":"md"},{"id":1391,"value":"Plot.plot({\n height: 500,\n width: 1200,\n marginTop: 10,\n marginLeft: 80,\n marginRight: 50,\n marginBottom: 50,\n inset: 20,\n grid: true,\n // Configure the x scale\n x: {\n type: \"linear\", // set the type\n axis: \"bottom\",\n label: \"→ \" + \"Amount\",\n grid: true,\n domain: d3.extent(totalPerCapita, (d) => d.sum)\n },\n y: {\n type: \"linear\", // set the type\n axis: \"left\",\n label: \"↑ \" + \"Population\",\n grid: true,\n domain: d3.extent(totalPerCapita, (d) => d.pop)\n },\n marks: [\n Plot.dotX(totalPerCapita, {\n y: \"pop\",\n x: \"sum\",\n r: 10,\n strokeWidth: 1,\n fill: (d) => (d.name === `${query}` ? countyFillColor : \"#aba194\"),\n title: (d) => `${d.name}:\\n${d.sum}`\n })\n // Plot.text(totalPerCapita, {\n // filter: (d) => d.name === `${query}`,\n // x: \"count\",\n // text: (d) => d.name,\n // dy: 30\n // })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1405,"value":"----\n\n## What can I do with the top-level stats?\n\nUse this section to view and compare state-level data about Capital Outlay requests for the 2022 legislative session.\n\nIn all, entities across New Mexico submitted **${capitalOutlayData.length.toLocaleString('en-US')} requests** for Capital Outlay that totaled **$${totalCapitalOutlayRequested.toLocaleString('en-US')}**\n\n### Statewide table","pinned":false,"hidden":false,"mode":"md"},{"id":2598,"value":"Inputs.table(\n capitalOutlayData.map((d) => ({\n request: {\n url: \"https://www.nmlegis.gov/CapitalOutlayWeb/Summary?ID=\" + d.id,\n title: d.title\n },\n ...d\n })),\n {\n columns: [\"request\", \"req_amt\", \"primary_category_proper\"],\n rows: 15,\n width: {\n title: \"45%\"\n },\n header: {\n request: \"Request\",\n req_amt: \"Requested Amount\",\n primary_category_proper: \"Primary category\"\n },\n align: {\n req_amt: \"left\"\n },\n sort: \"req_amt\",\n reverse: true,\n layout: \"fixed\",\n format: {\n request: (request) =>\n htl.html`${request.title}`,\n req_amt: (x) =>\n parseInt(x).toLocaleString(\"en-US\", {\n style: \"currency\",\n currency: \"USD\"\n })\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":374,"value":"viewof toggleChartMap = Inputs.radio(\n [\n \"Count\",\n \"Total Requested\",\n \"Requests Per 100,000 people\",\n \"Total Per 100,000 people\"\n ],\n {\n value: \"Count\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2602,"value":"## Statewide chart","pinned":false,"hidden":false,"mode":"md"},{"id":217,"value":"Plot.plot({\n height: 1600,\n width: 1200,\n marginTop: 0,\n marginLeft: 100,\n marginRight: 100,\n marginBottom: 50,\n inset: 50,\n grid: true,\n // caption: \"Daily highs and lows\",\n grid: true,\n x: {\n axis: \"bottom\",\n label: \"→ \" + `${toggleChartMap}`,\n grid: true,\n domain: d3.extent(dataChartMap, (d) => d.value)\n },\n y: {\n axis: \"left\",\n label: \"County\",\n domain: d3.sort(dataChartMap, (d) => -d.value).map((d) => d.name)\n },\n color: {\n type: \"sequential\",\n scheme: \"reds\"\n },\n marks: [\n Plot.barX(dataChartMap, { x: \"value\", y: \"name\", fill: \"value\" }),\n Plot.text(dataChartMap, {\n x: \"value\",\n y: \"name\",\n text: \"value\",\n dx: 35\n })\n // Plot.text(\n // [`Number of New Mexico\\n Capital Outlay applications by county`],\n // {\n // fontSize: \"x-large\",\n // frameAnchor: \"top-left\"\n // }\n // )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2606,"value":"## Statewide map","pinned":false,"hidden":false,"mode":"md"},{"id":40,"value":"$37","pinned":false,"hidden":false,"mode":"ojs"},{"id":2072,"value":"## Download raw data and snapshots","pinned":false,"hidden":false,"mode":"md"},{"id":1418,"value":"### Download all Capital Outlay request data (${capitalOutlayData.length.toLocaleString('en-US')} rows)\n\n\n\n","pinned":false,"hidden":false,"mode":"md"},{"id":1414,"value":"DOM.download(\n serialize(capitalOutlayData),\n \"new_mexico_county_capital_outlay_applications\",\n \"Download raw data as a .csv\"\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":63,"value":"### Download Capital Outlay requests for **${dataDownloadQuery} County** (${downloadCountyResults.length} rows)","pinned":false,"hidden":false,"mode":"md"},{"id":2081,"value":"viewof dataDownloadQuery = Inputs.select(\n capitalOutlayData\n .map((a) => a.county)\n .filter((value, index, self) => self.indexOf(value) === index)\n .sort(d3.ascending),\n {\n type: \"search\",\n placeholder:\n \"Download Capital Outlay application data for a specific county\",\n value: \"Bernalillo\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":971,"value":"DOM.download(\n serialize(downloadCountyResults),\n `${downloadCountyResults[0].county}`.toLowerCase() + \"_county_capital_outlay\",\n \"Download \" + `${downloadCountyResults[0].county}` + \" County data as a .csv\"\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"----\n## Data","pinned":false,"hidden":false,"mode":"md"},{"id":2128,"value":"### Category-level data","pinned":false,"hidden":false,"mode":"md"},{"id":2519,"value":"categories = mmmmCategoryStats.map(d => d.category)","pinned":true,"hidden":false,"mode":"ojs"},{"id":2498,"value":"mmmmCategoryDisplay = {\n const arr = [];\n mmmmCategoryStats.forEach(function (d) {\n const { category, group, sum, count, value, ...measures } = d;\n for (const [k, v] of Object.entries(measures)) {\n arr.push({\n category: category,\n name: k,\n value: v\n });\n }\n });\n return arr;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1727,"value":"mmmmCategoryStats = {\n const arr = [];\n d3.flatGroup(capitalOutlayData, (d) => d.primary_category_proper).map(\n function (o) {\n console.log(o);\n arr.push({\n category: o[0],\n count: o[1].length,\n sum: d3.sum(o[1], (d) => d.req_amt),\n min: d3.min(o[1], (d) => d.req_amt),\n max: d3.max(o[1], (d) => d.req_amt),\n median: d3.median(o[1], (d) => d.req_amt),\n mean: d3.mean(o[1], (d) => d.req_amt)\n });\n }\n );\n return arr;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1803,"value":"mmmmCategoryBoxPlot = {\n const arr = [];\n capitalOutlayData.forEach(function (d) {\n arr.push({\n name: d.primary_category_proper,\n value: d.req_amt\n });\n });\n return arr;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1457,"value":"categoryCount = d3\n .rollups(\n capitalOutlayData,\n (v) => v.length,\n (d) => d.primary_category_proper\n )\n .map(([k, v]) => ({ name: k, value: v }))","pinned":false,"hidden":false,"mode":"ojs"},{"id":844,"value":"categoryTotal = d3\n .rollups(\n capitalOutlayData,\n (xs) => d3.sum(xs, (v) => v.req_amt),\n (d) => d.primary_category_proper\n )\n .map(([k, v]) => ({ name: k, value: v }))","pinned":false,"hidden":false,"mode":"ojs"},{"id":2973,"value":"categoryQueryResults = capitalOutlayData.filter(\n (a) => a.primary_category_proper === categoryQuery\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":767,"value":"amountRequestedTag = capitalOutlayData\n .map((o) =>\n o.tags.map((x) => {\n console.log(x);\n return {\n requestAmount: o.req_amt,\n tag: x\n };\n })\n )\n .flat()","pinned":false,"hidden":false,"mode":"ojs"},{"id":750,"value":"tags = [...new Set(capitalOutlayTags.map((o) => o.tags).flat())]","pinned":false,"hidden":false,"mode":"ojs"},{"id":575,"value":"capitalOutlayTags = {\n var output = [];\n capitalOutlayData.forEach((d) => {\n var tags = [];\n tags.push(d.tag_1);\n if (d.tag_2 != null) {\n tags.push(d.tag_2);\n }\n if (d.tag_3 != null) {\n tags.push(d.tag_3);\n }\n d.tags = tags;\n output.push(d);\n });\n return output;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2123,"value":"----\n\n### County-level data","pinned":false,"hidden":false,"mode":"md"},{"id":392,"value":"dataChartMap = {\n if (toggleChartMap === \"Count\") {\n return countyCount;\n } else if (toggleChartMap === \"Total Requested\") {\n return countyTotal;\n } else if (toggleChartMap === \"Requests Per 100,000 people\") {\n return countyRequestsPerCapita;\n } else if (toggleChartMap === \"Total Per 100,000 people\") {\n return totalPerCapita;\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":380,"value":"countyCount = d3\n .rollups(\n capitalOutlayData,\n (v) => v.length,\n (d) => d.county\n )\n .map(([k, v]) => ({ name: k, value: v }))","pinned":false,"hidden":false,"mode":"ojs"},{"id":384,"value":"countyTotal = d3\n .rollups(\n capitalOutlayData,\n (xs) => d3.sum(xs, (v) => v.req_amt),\n (d) => d.county\n )\n .map(([k, v]) => ({ name: k, value: v }))","pinned":false,"hidden":false,"mode":"ojs"},{"id":634,"value":"countyRequestsPerCapita = {\n const objects = [];\n countyCount.forEach(function (d) {\n if (d.name != \"Multiple Counties\") {\n let pop = newMexicoCountyPopulation.find((obj) => {\n return obj.name === d.name;\n });\n objects.push({\n name: d.name,\n pop: pop[\"population\"],\n value: (d.value * 100000) / pop[\"population\"],\n count: d.value\n });\n } else {\n objects.push({\n name: d.name,\n pop: null,\n value: 0,\n count: null\n });\n }\n });\n return objects;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2088,"value":"downloadCountyResults = capitalOutlayData.filter((a) => a.county === dataDownloadQuery)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1285,"value":"mmmmCountyStats = [\n { name: \"Min\", value: d3.min(countyQueryResults, (d) => d.req_amt) },\n { name: \"Median\", value: d3.median(countyQueryResults, (d) => d.req_amt) },\n { name: \"Mean\", value: d3.mean(countyQueryResults, (d) => d.req_amt) },\n { name: \"Max\", value: d3.max(countyQueryResults, (d) => d.req_amt) }\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":3144,"value":"appropriationQueryResults = appropriationData.filter(\n (a) => a.county === queryAppropriations\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":207,"value":"countyQueryResults = capitalOutlayData.filter((a) => a.county === query)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2502,"value":"requestsPerCapita = {\n const objects = [];\n countyCount.forEach(function (d) {\n if (d.name != \"Multiple Counties\") {\n let pop = newMexicoCountyPopulation.find((obj) => {\n return obj.name === d.name;\n });\n objects.push({\n name: d.name,\n pop: pop[\"population\"],\n value: (d.value * 100000) / pop[\"population\"],\n count: d.value\n });\n } else {\n objects.push({\n name: d.name,\n pop: null,\n value: 0,\n count: null\n });\n }\n });\n return objects;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":698,"value":"totalPerCapita = {\n const objects = [];\n countyTotal.forEach(function (d) {\n if (d.name != \"Multiple Counties\") {\n let pop = newMexicoCountyPopulation.find((obj) => {\n return obj.name === d.name;\n });\n objects.push({\n name: d.name,\n pop: pop[\"population\"],\n value: (d.value * 100000) / pop[\"population\"],\n sum: d.value\n });\n } else {\n objects.push({\n name: d.name,\n pop: null,\n value: 0,\n sum: null\n });\n }\n });\n return objects;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2321,"value":"----\n\n### Raw data","pinned":false,"hidden":false,"mode":"md"},{"id":546,"value":"// this is my url from a google spreadsheet\ndataUrl = \"https://docs.google.com/spreadsheets/d/1XmpSGWa2RMK6V4K4IOUqaYZlz6fkBFyz7WC0-Q4T7EU/edit?usp=sharing\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":194,"value":"// retrieve my data from a google spreadsheet\ncapitalOutlayData = d3.csv(getCsvUrl(dataUrl), d3.autoType)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3116,"value":"appropriationUrl = \"https://docs.google.com/spreadsheets/d/1XmpSGWa2RMK6V4K4IOUqaYZlz6fkBFyz7WC0-Q4T7EU/edit#gid=623533317\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":3114,"value":"// retrieve my data from a google spreadsheet\nappropriationData = d3.csv(getCsvUrl(appropriationUrl), d3.autoType)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2133,"value":"----\n\n### Misc data","pinned":false,"hidden":false,"mode":"md"},{"id":1160,"value":"totalCapitalOutlayRequested = d3.sum(capitalOutlayData, (d) => d.req_amt)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3174,"value":"totalCapitalOutlayAppropriated = d3.sum(appropriationData, (d) => d.amount)","pinned":false,"hidden":false,"mode":"ojs"},{"id":629,"value":"$38","pinned":false,"hidden":false,"mode":"ojs"},{"id":60,"value":"selectedCities = cityList.filter(d => cities.includes(d.name))","pinned":false,"hidden":false,"mode":"ojs"},{"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 // \"Espanola\",\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 \"Portales\",\n \"Raton\",\n \"Reserve\",\n // \"Rio Rancho\",\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"},{"id":2,"value":"----\n## Imports","pinned":false,"hidden":false,"mode":"md"},{"id":46,"value":"visualHeader = md`\n### Maps & Graphics Imports\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":44,"value":"import {\n getCsvUrl,\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"},{"id":156,"value":"import { SummaryTable } from \"@observablehq/summary-table\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":120,"value":"viewof mapFillColor = color({\n title: \"Base map fill color\",\n value: \"#e6e6e6\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1944,"value":"viewof countyFillColor = color({\n title: \"Categories fill color\",\n value: \"#67000d\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1951,"value":"viewof categoryFillColor = color({\n title: \"Categories fill color\",\n value: \"#08306b\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":177,"value":"function handleMouseOver(event, d) {\n const [x, y] = d3.pointer(event);\n d3.select(this)\n .style(\"opacity\", 0.8)\n .style(\"stroke\", \"#ffffff\")\n .style(\"stroke-width\", 1);\n tooltip.transition().duration(200).style(\"opacity\", 0.9);\n let lookup = dataChartMap.find((o) => o.county === d.properties.NAME);\n let county = lookup.county;\n let displayValue = lookup.value;\n tooltip\n .html(`${county} County:
${displayValue}`)\n .style(\"left\", `${event.x + 20}px`)\n .style(\"top\", `${event.y - 45}px`);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":178,"value":"function handleMouseOut(d) {\n d3.select(this)\n .style(\"opacity\", 1)\n .style(\"stroke\", \"#ffffff\")\n .style(\"stroke-width\", 1);\n\n tooltip.transition().duration(200).style(\"opacity\", 0);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":169,"value":"colorScale = d3\n .scaleSequential()\n .domain(extent)\n .interpolator(d3.interpolateReds)\n\n// colorScale = d3.scaleLinear()\n// .domain(cityList)\n// .range(d3.schemeBlues[6]);\n\n// colorScale = d3\n// .scaleSequential()\n// .domain([extent[0], extent[1]])\n// .interpolator(d3.interpolateBlues)\n\n// colorScale = d3.scaleLinear()\n// .domain(mapBreaks)\n// .range(d3.schemeBlues[mapBreaks.length]);\n\n// colorScale = d3.scaleLinear()\n// .domain([0, 10000, 20000, 40000, 60000, 100000, countCountyMax])\n// .range(d3.schemePuBuGn[7]);\n\n// colorScale = d3.scaleLinear()\n// .domain(mapBreaks)\n// .range(d3.schemePuBuGn[mapBreaks.length]);","pinned":false,"hidden":false,"mode":"ojs"},{"id":170,"value":"extent = d3.extent(dataChartMap, (d) => d.value)","pinned":false,"hidden":false,"mode":"ojs"},{"id":110,"value":"### Package Imports","pinned":false,"hidden":false,"mode":"md"},{"id":153,"value":"ss = require(\"https://unpkg.com/simple-statistics@6.1.0/dist/simple-statistics.min.js\")","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":15,"value":"d3 = require(\"d3@7\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":24,"value":"GeoJSON = require('geojson@0.5.0/geojson.js').catch(() => window[\"GeoJSON\"])","pinned":false,"hidden":false,"mode":"ojs"},{"id":25,"value":"topojson = require(\"topojson-client@3\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":113,"value":"### User Imports","pinned":false,"hidden":false,"mode":"md"},{"id":1027,"value":"import { Plot } from \"@mkfreeman/plot-tooltip\"","pinned":true,"hidden":false,"mode":"ojs"},{"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"},{"id":122,"value":"import { color } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":33,"value":"import {serialize} from \"@palewire/saving-csv\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1764,"value":"import { boxX, iqr1, iqr2, quartile1, quartile3 } from \"@observablehq/plot-box\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":2393,"value":"import { pivot } from \"ac2a320cf2b0adc4\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":289,"value":"function sparkbar(max) {\n return (x) => htl.html`

${x.toLocaleString(\"en\")}`;\n}","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W39","stdlib":"1","titling":"auto"}} 30:"$2f:body"