25:["$","title",null,{"children":"Trending Job Markets | John E Freier | Observable"}] 49: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] } )} `4a:[] 29:{"id":"d77dff703cfc5ff9","slug":null,"title":"Trending Job Markets","thumbnail":"ab6625c227eabc90cdcf1770aa9b1d807d74ab7b89233930f0a0180e11d86b5c","access_level":"public","create_time":"$D2023-11-25T03:23:47.780Z","update_time":"$D2023-11-25T03:23:47.780Z","view_time":null,"first_public_time":"$D2023-11-25T03:23:47.780Z","has_unpublished_edits":null,"fork":{"id":"2cd35b19a7eb45a7","slug":null,"title":"Trending Job Markets","owner":{"id":"d40ec6f54474d319","login":"linayang-mids","name":"Lina"}},"stars":0,"starred":false,"owner":{"type":"team","id":"e8e2b1fcb956e4d5","login":"gofullthrottle","name":"John E Freier","avatar_url":"https://avatars-next.observableusercontent.com/94ced36504de6c16812033f876f60a9874c91a7439f4f99aed3a8bce5fe86906","tier":"starter_2024","bio":"Serial entrepreneur, statistician & machine learning enthusiast, data hoarder, data modeler, hacker & maker, web dev, innovator, dirt biker.\n\nI like collecting, analyzing, and modeling massive amounts of data. Feels like treasure hunting.","followed_by_you":false,"follows_you":false},"version":737,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"7bf910b8a95c8e3c","login":"gofullthrottle","name":"John E Freier","avatar_url":"https://avatars-next.observableusercontent.com/94ced36504de6c16812033f876f60a9874c91a7439f4f99aed3a8bce5fe86906","tier":null,"bio":"Serial entrepreneur, statistician & machine learning enthusiast, data hoarder, data modeler, hacker & maker, web dev, innovator, dirt biker.\n\nI like collecting, analyzing, and modeling massive amounts of data. Feels like treasure hunting.","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"7bf910b8a95c8e3c","login":"gofullthrottle","name":"John E Freier","avatar_url":"https://avatars-next.observableusercontent.com/94ced36504de6c16812033f876f60a9874c91a7439f4f99aed3a8bce5fe86906","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":644,"value":"md`\n## National View\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":433,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"md`\n

\n#### Data Prep\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"md`\n

\n#### Data Collection\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"md`\n

\n#### Imported Packages\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"d3 = require(\"d3@6\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"import {Radio} from \"@observablehq/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"import {table, area} from \"@hamzaamjad/tiny-charts\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"format_percent = d3.format(Object.assign(d3.formatSpecifier(\"%\"), {align: \">\", precision: d3.precisionFixed(0.1)}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":326,"value":"style = html`\n\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":189,"value":"md`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4a","stdlib":"1"}} 24:null