2e:null 2f:["$","title",null,{"children":"Trending Job Markets | Justin Ferrara | Observable"}] 34:T9e7,tables = md`

Top 20 in Job Growth

${table( d3 .groups(data_top, d => d.Metro) .filter(([, data_top]) => data_top.some(d => d.Employment)) .map(([key, data_top]) => ({ Metro: key, Trend: area(data_top.map(d => Math.max(0, d.Employment)).reverse(), { width: 100, height: 15, color: { line: "green", fill: "#d0f0c0" }, highlights: { max: "blue", end: "black" }, margin: { vertical: 0.1, horizontal: 0.01 }, scaling: "min" }), "%\u0394": data_top[0].Emp_Change, "Max Employment": d3.max(data_top, d => d.Employment), "College Degrees\u00B9": data_top[0].College_degrees_per_100_people/100, "Skilled Labor\u00B2": data_top[0].Skilled_labor_per_100_jobs/100 })), { width: "800px", layout: "fixed", widths: ["150px", "50px", null, null, null, null, null], formats: [null, null, ".0%", ".3s", ".0%", ".0%"], align: ["left", "right", "right", "right", "right", "right", "right"], color: [null, null, null, "blue", null, null, null] } )}

Bottom 20 in Job Growth

${table( d3 .groups(data_bot, d => d.Metro) .filter(([, data_bot]) => data_bot.some(d => d.Employment)) .map(([key, data_bot]) => ({ Metro: key, Trend: area(data_bot.map(d => Math.max(0, d.Employment)), { width: 100, height: 15, color: { line: "red", fill: "mistyrose" }, highlights: { min: "blue", end: "black" }, margin: { vertical: 0.1, horizontal: 0.01 }, scaling: "min" }), "%\u0394": data_bot[0].Emp_Change, "Min Employment": d3.min(data_bot, d => d.Employment), "College Degrees\u00B9": data_bot[0].College_degrees_per_100_people/100, "Skilled Labor\u00B2": data_bot[0].Skilled_labor_per_100_jobs/100 })), { width: "800px", layout: "fixed", widths: ["150px", "50px", null, null, null, null, null], formats: [null, null, ".0%", ".3s", ".0%", ".0%"], align: ["left", "right", "right", "right", "right", "right", "right"], color: [null, null, null, "blue", null, null, null] } )} `35:[] 32:{"id":"fbb900be3d486b8b","slug":"trending-job-markets","title":"Trending Job Markets","thumbnail":"ebe7a5ac58117d9fa305652792bec4c194fea69799d3491650fd664650151a59","access_level":"public","create_time":"$D2021-02-13T01:13:00.657Z","update_time":"$D2021-02-24T05:15:05.062Z","view_time":null,"first_public_time":"$D2021-02-15T22:47:45.021Z","has_unpublished_edits":null,"fork":false,"stars":9,"starred":false,"owner":{"type":"team","id":"2cd32b06240db15f","login":"justinferrara","name":"Justin Ferrara","avatar_url":"https://avatars-next.observableusercontent.com/a23890b46ef96c5a78a02a96097e1222ef516229ce285e58e4545bac47fe49ab","tier":"starter_2024"},"version":732,"publish_version":732,"role":null,"authored":false,"authors":[{"type":"individual","id":"12881e650e1e221c","login":"justinferrara","name":"Justin Ferrara","avatar_url":"https://avatars-next.observableusercontent.com/a23890b46ef96c5a78a02a96097e1222ef516229ce285e58e4545bac47fe49ab","tier":null}],"members":[{"type":"individual","id":"12881e650e1e221c","login":"justinferrara","name":"Justin Ferrara","avatar_url":"https://avatars-next.observableusercontent.com/a23890b46ef96c5a78a02a96097e1222ef516229ce285e58e4545bac47fe49ab","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":7,"collection":null,"type":"notebook","body":{"title":"Trending Job Markets","cells":[{"id":0,"value":"title = md`\n\n# Trending Job Markets\n\n#### Sources: [Bureau of Labor Statistics](https://www.bls.gov/), [US Census Bureau](https://www.census.gov/en.html)\n\n

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":644,"value":"md`\n## National View\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"viewof metro_size = Radio([\"Large metro (pop. >1M)\", \"Mid-sized metro (pop. >500K)\", \"Small metro (pop. <500K)\"], {value: \"Large metro (pop. >1M)\", label: \"Metro size:\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":433,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":710,"value":"md`\n\\u00B9 **College Degrees** defined as the percentage of residents in a metropolitan area who have obtained a bachelor's degree (as of 2018)\\n\n\\u00B2 **Skilled Labor** defined as the percentage of jobs in a metropolitan area that require a specialized skill set in order to complete some of the assigned tasks. See [additional documentation](https://github.com/jcferrara/metro-job-data/blob/main/skilled_unskilled_classifications.xlsx) on how BLS occupation titles were classified as skilled or unskilled jobs.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":161,"value":"md`\n#### Additional notes\nWhy metro and not tract/county/state? \\n\nAdditional documentation available on github...\n\n#### To-Do:\nEdit display to fit mobile device\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"md`\n

\n#### Data Prep\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":436,"value":"data_top = raw_jobs_data_top.filter(raw_jobs_data_top => raw_jobs_data_top.Size == metro_size)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":587,"value":"data_bot = raw_jobs_data_bot.filter(raw_jobs_data_bot => raw_jobs_data_bot.Size == metro_size)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"md`\n

\n#### Data Collection\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":425,"value":"raw_jobs_data_top = d3.json(\"https://raw.githubusercontent.com/jcferrara/metro-job-data/main/Trending%20job%20market%20data%20-%20top.json\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":584,"value":"raw_jobs_data_bot = d3.json(\"https://raw.githubusercontent.com/jcferrara/metro-job-data/main/Trending%20job%20market%20data%20-%20bottom.json\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"md`\n

\n#### Imported Packages\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"import {Radio} from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"import {table, area} from \"@hamzaamjad/tiny-charts\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"format_percent = d3.format(Object.assign(d3.formatSpecifier(\"%\"), {align: \">\", precision: d3.precisionFixed(0.1)}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":296,"value":"function format_num (labelValue) {\n\n // Nine Zeroes for Billions\n return Math.abs(Number(labelValue)) >= 1.0e+9\n\n ? Math.round(Math.abs(Number(labelValue)) / 1.0e+9, 1) + \"B\"\n // Six Zeroes for Millions \n : Math.abs(Number(labelValue)) >= 1.0e+6\n\n ? Math.round(Math.abs(Number(labelValue)) / 1.0e+6, 2) + \"M\"\n // Three Zeroes for Thousands\n : Math.abs(Number(labelValue)) >= 1.0e+3\n\n ? Math.abs(Number(labelValue)) / 1.0e+3 + \"K\"\n\n : Math.abs(Number(labelValue));\n\n}\n\n//alert(test(6800000)); // this outputs 6.8M","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":326,"value":"style = html`\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":189,"value":"md`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 33:"$32:body"