2d:null 2e:["$","title",null,{"children":"Indeed Hiring Lab - Job Postings Tracker | Bobby Reedy | Observable"}] 33:T73b,plot = { const selectedField = lookback === "Past Year" ? "indeed_job_postings_index_SA_ly" : "indeed_job_postings_index_SA"; const filteredData = lookback === "Past Year" ? data.filter(d => d.indeed_job_postings_index_SA_ly != null) : data; const hover = vl.selectPoint('hover') .encodings('x') .on('mouseover') .toggle(false) .nearest(true); const isHovered = hover.empty(false); const line = vl.markLine({interpolate: 'monotone', line: true, size: 3}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ(selectedField).title("Indeed Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.color().fieldN('variable').title(false).scale({range: ["#CC107B", "#233F96"]}).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 3}) ); const base = line.transform(vl.filter(isHovered)); const label = {align: 'left', dx: -20, dy: -6, fontSize: 12, fontWeight: "bold", color: "#black"}; const white = {stroke: 'white', strokeWidth: 2, fontSize: 12}; const tooltip = vl.layer( base.markText({ align: "right", fontSize: 12, fontWeight: "bold", color: "#black"}).encode( vl.y().value(10), vl.text().fieldT("date") ) ); return vl.data(filteredData) .layer(line, vl.markRule({color: '#C0C0C0'}) .transform(vl.filter(isHovered)) .encode(vl.x().fieldT('date')), line.markCircle() .params(hover).encode(vl.opacity().if(isHovered, vl.value(1)).value(0)), base.markText(label, white).encode(vl.text().fieldQ(selectedField).format(",.4s")), base.markText(label).encode(vl.text().fieldQ(selectedField).format(",.4s")), tooltip ) .width(width/1.2) .height(360) .render(); }34:T62c,jolts_plot = { const line = vl.data(jolts_data) .layer( vl.markLine({line: true, size: 3, color: "#FF7F0E"}) .encode( vl.x().fieldT('month_end').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('JOLTS').title("Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.color().fieldN('type').title(false).scale({range: ["#FF7F0E", "#233F96"]}).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 8}), vl.tooltip([ { field: 'JOLTS', type: 'quantitative', format: ',.1f', title: 'JOLTS' }, { field: 'month_end', type: 'temporal', format: '%b %d, %Y', title: 'Date' } ]) ) ); const line2 = vl.data(data) .transform(vl.filter('datum.variable == "total postings"')) .layer( vl.markLine({interpolate: 'monotone', line: true, size: 3, color: "#233F96"}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('indeed_job_postings_index_SA').axis({format: "2s", nice: true, tickCount: 4}), vl.color().fieldN('variable').title(false).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 8}), vl.tooltip([ { field: 'indeed_job_postings_index_SA', type: 'quantitative', format: ',.1f', title: 'Indeed Job Index'}, { field: 'date', type: 'temporal', format: '%b %d, %Y', title: 'Date'} ]) ) ); return vl.layer(line2, line) .width(width/1.2) .height(360) .config({view: { stroke: null }}) .render(); }35:T4cc,viewof sector = { const type = select({ title: "Category", options: [ { label: 'Select All', value: 'Select All' }, { label: 'Administrative & Support', value: 'Administrative & Support' }, { label: 'Business & Finance', value: 'Business & Finance' }, { label: 'Creative & Media', value: 'Creative & Media' }, { label: 'Education & Community', value: 'Education & Community' }, { label: 'Engineering & Technical', value: 'Engineering & Technical' }, { label: 'Healthcare', value: 'Healthcare' }, { label: 'Information Technology', value: 'Information Technology' }, { label: 'Legal & Security', value: 'Legal & Security' }, { label: 'Marketing, Sales & Strategy', value: 'Marketing Sales & Strategy' }, { label: 'Production & Manufacturing', value: 'Production & Manufacturing' }, { label: 'Science & Research', value: 'Science & Research' }, { label: 'Service & Hospitality', value: 'Service & Hospitality' }, { label: 'Transportation & Logistics', value: 'Transportation & Logistics' }, ], value: "Select All", description: "Select Sector Category to chart." }); type.input.style.fontSize = "0.8em"; return type; }36:T112b,plot2 = { const selection1 = vl.selectPoint().on('click'); const selection2 = vl.selectPoint().on('click'); const line = vl.data(sector_data) .transform(vl.filter('datum.variable == "total postings"'), vl.filter('datum.jobcountry == "US"'), vl.filter(sector === 'Select All' ? 'true' : `datum.Category == "${sector}"`) ) .title("Job Postings by Sector Trends") .layer( vl.markLine({interpolate: 'monotone', line: true, opacitysize: 1, color: "black"}) .params(selection1) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('indeed_job_postings_index').title("Indeed Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.detail().fieldN('display_name').title("Sector"), vl.color().if(selection1, vl.value("black")).value("lightgray"), vl.opacity().if(selection1, vl.value("0.4")).value("0.2"), vl.tooltip([ { field: 'display_name', type: 'nominal', title: 'Sector'}, { field: 'indeed_job_postings_index', type: 'quantitative', format: ',.1f', title: 'Indeed Job Index'}, { field: 'date', type: 'temporal', format: '%b %d, %Y', title: 'Date'} ]) ) .height(320) .width(width/1.2) ); const line2 = vl.data(data) .transform(vl.filter('datum.variable == "total postings"'), vl.filter('datum.jobcountry == "US"') ) .layer( vl.markLine({interpolate: 'monotone', line: true, size: 3, color: "#233F96"}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('indeed_job_postings_index_SA').title("Indeed Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.color().fieldN('variable').title(false).scale({range: ["#233F96"]}).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 6}), vl.tooltip().fieldN('variable') ) .height(320) .width(width/1.2) ); const line3 = vl.data(sector_data) .transform( vl.filter('datum.variable == "total postings"'), vl.filter('datum.jobcountry == "US"'), vl.filter(sector === 'Select All' ? 'true' : `datum.Category == "${sector}"`), vl.aggregate([{op: 'mean', field: 'indeed_job_postings_index', as: 'average_index'}]) .groupby(['date']) ) .layer( vl.markLine({interpolate: 'monotone', line: true, size: 3, color: "#46a2da"}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('average_index').axis({format: "2s", nice: true, tickCount: 4}), vl.color().value("#46a2da").title(false).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 6}), vl.tooltip([ { field: 'date', type: 'temporal', format: '%b %d, %Y', title: 'Date' }, { field: 'average_index', type: 'quantitative', format: ',.1f', title: 'Average Indeed Job Index' } ]) ) ) .height(320) .width(width / 1.2); const bar = vl.data(sector_data_latest) .transform(vl.filter('datum.jobcountry == "US"'), vl.filter('datum.variable == "total postings"'), vl.filter(sector === 'Select All' ? 'true' : `datum.Category == "${sector}"`) ) .title("Job Postings by Sector (" + d3.timeFormat("%B %d, %Y")(maxDate) + ")") .layer( vl.markBar({opacity: 0.8}) .params(selection2) .encode( vl.x().fieldN('display_name').title(false).axis({nice: true, grid: false}) .sort({field: "indeed_job_postings_index", order: "descending"}), vl.y().fieldQ('indeed_job_postings_index').title("Indeed Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.color().if(selection2, vl.value("#233F96")).value("lightgray"), vl.tooltip([ { field: 'Sector', type: 'nominal', title: 'Sector'}, { field: 'indeed_job_postings_index', type: 'quantitative', format: ',.1f', title: 'Indeed Job Index'} ]) ) .width(width/1.2) .height(140), vl.markRule({size: 3, opacity: 1, stroke: 'black'}) .encode( vl.y().average('indeed_job_postings_index')) ); return vl.vconcat(vl.layer(line, line2, line3), bar) .config({view: { stroke: null }}) .render(); }37:T6c8,Plot.plot({ height: 800, x: { axis: "top", label: "Percent Change since Feb. 2020", labelAnchor: "center", labelOffset: 35, tickFormat: d => `${d}%` }, y: { axis: null }, marginLeft: 40, marginRight: 50, marginTop: 40, color: { scheme: "PiYG" }, marks: [ // Bars Plot.barX(sector_data_latest, { x: d => d.indeed_job_postings_index - 100, y: "Sector", fill: d => d.indeed_job_postings_index > 100, sort: { y: "x" } }), ...d3.groups(sector_data_latest, d => d.indeed_job_postings_index > 100) .map(([growth, sectors]) => Plot.text(sectors, { x: 0, y: "Sector", text: "Sector", textAnchor: growth ? "end" : "start", dx: growth ? -6 : 6, fill: "black", fontSize: 12, paintOrder: "stroke", stroke: "white", strokeWidth: 3 }) ), Plot.text( sector_data_latest.filter(d => d.indeed_job_postings_index > 100), { x: d => d.indeed_job_postings_index - 100, y: "Sector", text: d => "+" + Math.round(d.indeed_job_postings_index - 100) + "%", textAnchor: "start", dx: 5, fill: "#276419", fontSize: 12, fontWeight: "bold", strokeWidth: 3 } ), Plot.text( sector_data_latest.filter(d => d.indeed_job_postings_index <= 100), { x: d => d.indeed_job_postings_index - 100, y: "Sector", text: d => Math.round(d.indeed_job_postings_index - 100) + "%", textAnchor: "end", dx: -5, fill: "#8e0152", fontSize: 12, fontWeight: "bold", strokeWidth: 3 } ) ] }); 38:Te0a,plot5 = { const selection1 = vl.selectPoint().on('click'); const selection2 = vl.selectPoint().on('click'); const line = vl.data(sector_data) .transform(vl.filter('datum.variable == "total postings"'), vl.filter('datum.jobcountry == "US"'), vl.aggregate([{op: 'mean', field: 'indeed_job_postings_index', as: 'average_index'}]) .groupby(['date', 'Category']) ) .title("Job Postings by Category Trends") .layer( vl.markLine({interpolate: 'monotone', line: true, opacitysize: 1, color: "black"}) .params(selection1) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('average_index').title("Indeed Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.opacity().if(selection1, vl.value("0.5")).value("0.1"), vl.detail().fieldN('Category').title(false), vl.tooltip([ { field: 'Category', type: 'nominal', title: 'Category'}, { field: 'average_index', type: 'quantitative', format: ',.1f', title: 'Avg. Indeed Job Index'}, { field: 'date', type: 'temporal', format: '%b %d, %Y', title: 'Date'} ]) ) .height(320) .width(width/1.2) ); const line2 = vl.data(data) .transform(vl.filter('datum.variable == "total postings"'), vl.filter('datum.jobcountry == "US"') ) .layer( vl.markLine({interpolate: 'monotone', line: true, size: 4, color: "#233F96"}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('indeed_job_postings_index_SA').title("Indeed Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.color().fieldN('variable').scale({range: ["#233F96"]}).title(false).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 6}), vl.tooltip().fieldN('variable') ) .height(320) .width(width/1.2) ); const bar = vl.data(sector_data_latest) .transform(vl.filter('datum.jobcountry == "US"'), vl.filter('datum.variable == "total postings"'), vl.aggregate([{op: 'mean', field: 'indeed_job_postings_index', as: 'average_index'}]) .groupby(['date', 'Category']) ) .title("Job Postings by Category (" + d3.timeFormat("%B %d, %Y")(maxDate) + ")") .layer( vl.markBar({opacity: 0.8}) .params(selection2) .encode( vl.x().fieldN('Category').title(false).axis({nice: true, grid: false}) .sort({field: "average_index", order: "descending"}), vl.y().fieldQ('average_index').title("Avg. Indeed Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.color().if(selection2, vl.value("#233F96")).value("lightgray"), vl.tooltip([ { field: 'Category', type: 'nominal', title: 'Category'}, { field: 'average_index', type: 'quantitative', format: ',.1f', title: 'Avg. Indeed Job Index'} ]) ), vl.markRule({size: 3, opacity: 1, stroke: 'black'}) .encode( vl.y().average('average_index') ) /* , vl.markText({align: 'center', baseline: 'bottom', dy: -5, fontSize: 12, fontWeight: 'bold', color: '#233F96'}) .encode( vl.x().fieldN('Category'), vl.y().fieldQ('average_index'), vl.text().fieldQ('average_index').format(',.1f') // Format the text as needed )*/ ) .width(width / 1.2) .height(140); return vl.vconcat(vl.layer(line, line2), bar) .config({view: { stroke: null }}) .render(); }39:T4e7,viewof sectorFilter = { const type = select({ title: "Category", options: [ { label: 'All Categories', value: 'All Categories' }, { label: 'Administrative & Support', value: 'Administrative & Support' }, { label: 'Business & Finance', value: 'Business & Finance' }, { label: 'Creative & Media', value: 'Creative & Media' }, { label: 'Education & Community', value: 'Education & Community' }, { label: 'Engineering & Technical', value: 'Engineering & Technical' }, { label: 'Healthcare', value: 'Healthcare' }, { label: 'Information Technology', value: 'Information Technology' }, { label: 'Legal & Security', value: 'Legal & Security' }, { label: 'Marketing, Sales & Strategy', value: 'Marketing Sales & Strategy' }, { label: 'Production & Manufacturing', value: 'Production & Manufacturing' }, { label: 'Science & Research', value: 'Science & Research' }, { label: 'Service & Hospitality', value: 'Service & Hospitality' }, { label: 'Transportation & Logistics', value: 'Transportation & Logistics' }, ], value: "All Categories", description: "Select a Category to view Sector details." }); type.input.style.fontSize = "0.8em"; return type; }3a:Tc52,Plot.plot({ height: 400, x: { axis: "top", label: "Percent Change since Feb. 2020", labelAnchor: "center", labelOffset: 35, tickFormat: d => `${d}%` }, y: { axis: null }, marginLeft: (() => { if (sectorFilter === "All Categories") return 45; const values = sector_data_latest .filter(d => d.Category === sectorFilter) .map(d => d.indeed_job_postings_index - 100); const minVal = Math.min(...values); if (minVal > -10) return 170; return minVal > -15 ? 80 : 45; })(), marginRight: (() => { if (sectorFilter === "All Categories") return 45; const values = sector_data_latest .filter(d => d.Category === sectorFilter) .map(d => d.indeed_job_postings_index - 100); const maxVal = Math.max(...values); if (maxVal < -10) return 205; return maxVal < 10 ? 100 : 45; })(), marginTop: 40, color: { scheme: "PiYG" }, marks: [ // Bars: choose dataset and y field based on filter Plot.barX( sectorFilter === "All Categories" ? category_data_latest : sector_data_latest.filter(d => d.Category === sectorFilter), { x: d => d.indeed_job_postings_index - 100, y: sectorFilter === "All Categories" ? "Category" : "Sector", fill: d => d.indeed_job_postings_index > 100, sort: { y: "x" } } ), // Category/Sector labels at zero line ...d3.groups( sectorFilter === "All Categories" ? category_data_latest : sector_data_latest.filter(d => d.Category === sectorFilter), d => d.indeed_job_postings_index > 100 ) .map(([growth, items]) => Plot.text(items, { x: 0, y: sectorFilter === "All Categories" ? "Category" : "Sector", text: sectorFilter === "All Categories" ? "Category" : "Sector", textAnchor: growth ? "end" : "start", dx: growth ? -6 : 6, fill: "black", fontSize: 12, paintOrder: "stroke", }) ), // Positive change labels Plot.text( (sectorFilter === "All Categories" ? category_data_latest : sector_data_latest.filter(d => d.Category === sectorFilter)) .filter(d => d.indeed_job_postings_index > 100), { x: d => d.indeed_job_postings_index - 100, y: sectorFilter === "All Categories" ? "Category" : "Sector", text: d => "+" + Math.round(d.indeed_job_postings_index - 100) + "%", textAnchor: "start", dx: 5, fill: "#276419", fontSize: 12, fontWeight: "bold", strokeWidth: 3 } ), // Negative change labels Plot.text( (sectorFilter === "All Categories" ? category_data_latest : sector_data_latest.filter(d => d.Category === sectorFilter)) .filter(d => d.indeed_job_postings_index <= 100), { x: d => d.indeed_job_postings_index - 100, y: sectorFilter === "All Categories" ? "Category" : "Sector", text: d => Math.round(d.indeed_job_postings_index - 100) + "%", textAnchor: "end", dx: -5, fill: "#8e0152", fontSize: 12, fontWeight: "bold", strokeWidth: 3 } ) ] }); 3b:T73a,viewof state = { const type = select({ title: "State", options: [ { label: 'Select All', value: 'Select All' }, { label: 'AL', value: 'AL' }, { label: 'AK', value: 'AK' }, { label: 'AZ', value: 'AZ' }, { label: 'AR', value: 'AR' }, { label: 'CA', value: 'CA' }, { label: 'CO', value: 'CO' }, { label: 'CT', value: 'CT' }, { label: 'DE', value: 'DE' }, { label: 'FL', value: 'FL' }, { label: 'GA', value: 'GA' }, { label: 'HI', value: 'HI' }, { label: 'ID', value: 'ID' }, { label: 'IL', value: 'IL' }, { label: 'IN', value: 'IN' }, { label: 'IA', value: 'IA' }, { label: 'KS', value: 'KS' }, { label: 'KY', value: 'KY' }, { label: 'LA', value: 'LA' }, { label: 'ME', value: 'ME' }, { label: 'MD', value: 'MD' }, { label: 'MA', value: 'MA' }, { label: 'MI', value: 'MI' }, { label: 'MN', value: 'MN' }, { label: 'MS', value: 'MS' }, { label: 'MO', value: 'MO' }, { label: 'MT', value: 'MT' }, { label: 'NE', value: 'NE' }, { label: 'NV', value: 'NV' }, { label: 'NH', value: 'NH' }, { label: 'NJ', value: 'NJ' }, { label: 'NM', value: 'NM' }, { label: 'NY', value: 'NY' }, { label: 'NC', value: 'NC' }, { label: 'ND', value: 'ND' }, { label: 'OH', value: 'OH' }, { label: 'OK', value: 'OK' }, { label: 'OR', value: 'OR' }, { label: 'PA', value: 'PA' }, { label: 'RI', value: 'RI' }, { label: 'SC', value: 'SC' }, { label: 'SD', value: 'SD' }, { label: 'TN', value: 'TN' }, { label: 'TX', value: 'TX' }, { label: 'UT', value: 'UT' }, { label: 'VT', value: 'VT' }, { label: 'VA', value: 'VA' }, { label: 'WA', value: 'WA' }, { label: 'WV', value: 'WV' }, { label: 'WI', value: 'WI' }, { label: 'WY', value: 'WY' } ], value: "CA", description: "Select State to chart." }); type.input.style.fontSize = "0.8em"; return type; }3c:Tf48,plot3 = { const selection1 = vl.selectPoint().on('click'); const selection2 = vl.selectPoint().on('click'); const line = vl.data(metro_data) .transform(vl.filter(state === 'Select All' ? 'true' : `datum.Postal == "${state}"`)) .title("Job Postings by Metro Trends") .layer( vl.markLine({interpolate: 'monotone', line: true, opacity: 0.25, color: "black"}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('indeed_job_postings_index').title("Indeed Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.detail().fieldN('metro').title("CBSA"), vl.color().if(selection1, vl.value("black")).value("lightgray"), vl.opacity().if(selection1, vl.value("0.4")).value("0.2"), vl.tooltip([ { field: 'metro', type: 'nominal', title: 'Metro'}, { field: 'indeed_job_postings_index', type: 'quantitative', format: ',.1f', title: 'Indeed Job Index'}, { field: 'date', type: 'temporal', format: '%b %d, %Y', title: 'Date'} ]) ) .height(320) .width(width/1.2) ); const line2 = vl.data(data) .transform(vl.filter('datum.variable == "total postings"')) .layer( vl.markLine({interpolate: 'monotone', line: true, size: 3, color: "#233F96"}) .params(selection1) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('indeed_job_postings_index_SA').title("Indeed Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.color().fieldN('variable').title(false).scale({range: ["#233F96"]}).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 6}), vl.tooltip().fieldN('variable') ) .height(320) .width(width/1.2) ); const line3 = vl.data(metro_data) .transform( vl.filter(state === 'Select All' ? 'true' : `datum.Postal == "${state}"`), vl.aggregate([{op: 'mean', field: 'indeed_job_postings_index', as: 'average_index'}]) .groupby(['date']) ) .layer( vl.markLine({interpolate: 'monotone', line: true, size: 3, color: "#46a2da"}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('average_index').axis({format: "2s", nice: true, tickCount: 4}), vl.color().value("#46a2da").title(false).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 6}), vl.tooltip([ { field: 'date', type: 'temporal', format: '%b %d, %Y', title: 'Date' }, { field: 'average_index', type: 'quantitative', format: ',.1f', title: 'Average Indeed Job Index' } ]) ) ) .height(320) .width(width / 1.2); /*const bar = vl.data(metro_data_latest) .transform(vl.filter(state === 'Select All' ? 'true' : `datum.Postal == "${state}"`)) .title("Job Postings by State (" + d3.timeFormat("%m-%d-%Y")(maxDate) + ")") .layer( vl.markBar({opacity: 0.8, color: "#233F96"}) .params(selection2) .encode( vl.x().fieldN('metro').title(false).axis({nice: true, grid: false}).sort({field: "indeed_job_postings_index", order: "descending"}), vl.y().fieldQ('indeed_job_postings_index').title("Indeed Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.color().if(selection2, vl.value("#233F96")).value("lightgray"), vl.tooltip([ { field: 'Metro', type: 'nominal', title: 'Metro'}, { field: 'indeed_job_postings_index', type: 'quantitative', format: ',.1f', title: 'Indeed Job Index'} ]) ) .width(width/1.2) .height(140), vl.markRule({size: 3, opacity: 1, stroke: 'black'}).encode( vl.y().average('indeed_job_postings_index')) ); */ return vl.vconcat(vl.layer(line, line2, line3), // bar ) .config({view: { stroke: null }}) .render(); }3d:Tf4e,plot4 = { const selection1 = vl.selectPoint().on('click'); const selection2 = vl.selectPoint().on('click'); const line = vl.data(state_data) .transform(vl.filter(region === 'Select All' ? 'true' : `datum.Region == "${region}"`)) .title("Job Postings by State Trends") .layer( vl.markLine({interpolate: 'monotone', line: true, opacity: 0.25, color: "black"}) .params(selection1) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('indeed_job_postings_index').title("Indeed Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.detail().fieldN('state').title("State"), vl.color().if(selection1, vl.value("black")).value("lightgray"), vl.opacity().if(selection1, vl.value("0.4")).value("0.2"), vl.tooltip([ { field: 'state', type: 'nominal', title: 'State'}, { field: 'indeed_job_postings_index', type: 'quantitative', format: ',.1f', title: 'Indeed Job Index'}, { field: 'date', type: 'temporal', format: '%b %d, %Y', title: 'Date'} ]) ) .height(320) .width(width/1.2) ); const line2 = vl.data(data) .transform(vl.filter('datum.variable == "total postings"')) .layer( vl.markLine({interpolate: 'monotone', line: true, size: 3, color: "#233F96"}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('indeed_job_postings_index_SA').title("Indeed Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.color().fieldN('variable').title(false).scale({range: ["#233F96"]}).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 6}), vl.tooltip().fieldN('variable') ) .height(320) .width(width/1.2) ); const line3 = vl.data(state_data) .transform( vl.filter(region === 'Select All' ? 'true' : `datum.Region == "${region}"`), vl.aggregate([{op: 'mean', field: 'indeed_job_postings_index', as: 'average_index'}]) .groupby(['date']) ) .layer( vl.markLine({interpolate: 'monotone', line: true, size: 3, color: "#46a2da"}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('average_index').axis({format: "2s", nice: true, tickCount: 4}), vl.color().value("#46a2da").title(false).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 6}), vl.tooltip([ { field: 'date', type: 'temporal', format: '%b %d, %Y', title: 'Date' }, { field: 'average_index', type: 'quantitative', format: ',.1f', title: 'Average Indeed Job Index' } ]) ) ) .height(320) .width(width / 1.2); const bar = vl.data(state_data_latest) .transform(vl.filter(region === 'Select All' ? 'true' : `datum.Region == "${region}"`)) .title("Job Postings by Sector (" + d3.timeFormat("%m-%d-%Y")(maxDate) + ")") .layer( vl.markBar({opacity: 0.8, color: "#233F96"}) .params(selection2) .encode( vl.x().fieldN('state').title(false).axis({nice: true, grid: false}).sort({field: "indeed_job_postings_index", order: "descending"}), vl.y().fieldQ('indeed_job_postings_index').title("Indeed Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.color().if(selection2, vl.value("#233F96")).value("lightgray"), vl.tooltip([ { field: 'State', type: 'nominal', title: 'State'}, { field: 'indeed_job_postings_index', type: 'quantitative', format: ',.1f', title: 'Indeed Job Index'} ]) ) .width(width/1.2) .height(140), vl.markRule({size: 3, opacity: 1, stroke: 'black'}).encode( vl.y().average('indeed_job_postings_index')) ); return vl.vconcat(vl.layer(line, line2, line3), // bar ) .config({view: { stroke: null }}) .render(); }3e:T8aa,Plot.plot({ projection: "identity", width: 975, height: 610, color: { scheme: "PiYG", type: "quantize", n: 9, domain: [-50, 50], tickFormat: d => `${d}%`, label: "Percent Change since Feb. 2020", legend: true }, marks: [ Plot.geo(topojson.feature(us, us.objects.states), Plot.centroid({ fill: d => { const val = valuemap.get(d.properties.name); return val != null ? val - 100 : undefined; }, title: d => { const val = valuemap.get(d.properties.name); return val != null ? `${d.properties.name}\n${(val - 100).toFixed(0)}%` : d.properties.name; }, tip: true })), Plot.geo(topojson.mesh(us, us.objects.states, (a, b) => a !== b), { stroke: "white" }), // State abbreviations Plot.text( topojson.feature(us, us.objects.states).features.filter( d => !northeastStates.has(d.properties.name) ), Plot.centroid({ text: d => stateAbbrevMap[d.properties.name] || d.properties.name, fill: d => { const val = valuemap.get(d.properties.name); if (val == null) return "black"; const change = val - 100; return Math.abs(change) > 40 ? "white" : "black"; }, fontSize: 12, textAnchor: "center", dy: -5, dx: 0, paintOrder: "stroke" }) ), // Percent value text Plot.text( topojson.feature(us, us.objects.states).features.filter( d => !northeastStates.has(d.properties.name) ), Plot.centroid({ text: d => { const val = valuemap.get(d.properties.name); if (val == null) return ""; const pctChange = Math.round(val - 100); return (pctChange > 0 ? "+" : "") + pctChange + "%"; }, fill: d => { const val = valuemap.get(d.properties.name); if (val == null) return "black"; const change = val - 100; return Math.abs(change) > 40 ? "white" : "black"; }, fontWeight: "bold", fontSize: 12, textAnchor: "center", dy: 10, dx: 0, paintOrder: "stroke" }) ) ] }); 3f:T6bf,Plot.plot({ height: 800, x: { axis: "top", label: "Percent Change since Feb. 2020", labelAnchor: "center", labelOffset: 35, tickFormat: d => `${d}%` }, y: { axis: null }, marginLeft: 40, marginRight: 50, marginTop: 40, color: { scheme: "PiYG" }, marks: [ // Bars Plot.barX(state_data_latest, { x: d => d.indeed_job_postings_index - 100, y: "State", fill: d => d.indeed_job_postings_index > 100, sort: { y: "x" } }), ...d3.groups(state_data_latest, d => d.indeed_job_postings_index > 100) .map(([growth, sectors]) => Plot.text(sectors, { x: 0, y: "State", text: "State", textAnchor: growth ? "end" : "start", dx: growth ? -6 : 6, fill: "black", fontSize: 12, paintOrder: "stroke", stroke: "white", strokeWidth: 3 }) ), Plot.text( state_data_latest.filter(d => d.indeed_job_postings_index > 100), { x: d => d.indeed_job_postings_index - 100, y: "State", text: d => "+" + Math.round(d.indeed_job_postings_index - 100) + "%", textAnchor: "start", dx: 5, fill: "#276419", fontSize: 12, fontWeight: "bold", strokeWidth: 3 } ), Plot.text( state_data_latest.filter(d => d.indeed_job_postings_index <= 100), { x: d => d.indeed_job_postings_index - 100, y: "State", text: d => Math.round(d.indeed_job_postings_index - 100) + "%", textAnchor: "end", dx: -5, fill: "#8e0152", fontSize: 12, fontWeight: "bold", strokeWidth: 3 } ) ] }); 40:T1382,country_plot = { const au = vl.data(data_AU) .transform(vl.filter('datum.variable == "total postings"')) .layer( vl.markLine({interpolate: 'monotone', line: true, size: 3, color: "red"}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('indeed_job_postings_index_SA').title("Indeed Job Postings Index").axis({format: "2s", nice: true, tickCount: 4}), vl.color().fieldN('jobcountry').title(false).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 6}), vl.tooltip([ { field: 'jobcountry', type: 'nominal', title: 'Country'}, { field: 'indeed_job_postings_index_SA', type: 'quantitative', title: 'Indeed Job Index'}, { field: 'date', type: 'temporal', format: '%b %d, %Y', title: 'Date'} ]) ) ); const de = vl.data(data_DE) .transform(vl.filter('datum.variable == "total postings"')) .layer( vl.markLine({interpolate: 'monotone', line: true, size: 3, color: "orange"}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('indeed_job_postings_index_SA').axis({format: "2s", nice: true, tickCount: 4}), vl.color().fieldN('jobcountry').title(false).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 6}), vl.tooltip([ { field: 'jobcountry', type: 'nominal', title: 'Country'}, { field: 'indeed_job_postings_index_SA', type: 'quantitative', title: 'Indeed Job Index'}, { field: 'date', type: 'temporal', format: '%b %d, %Y', title: 'Date'} ]) ) ); const ie = vl.data(data_IE) .transform(vl.filter('datum.variable == "total postings"')) .layer( vl.markLine({interpolate: 'monotone', line: true, size: 3, color: "purple"}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('indeed_job_postings_index_SA').axis({format: "2s", nice: true, tickCount: 4}), vl.color().fieldN('jobcountry').title(false).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 6}), vl.tooltip([ { field: 'jobcountry', type: 'nominal', title: 'Country'}, { field: 'indeed_job_postings_index_SA', type: 'quantitative', title: 'Indeed Job Index'}, { field: 'date', type: 'temporal', format: '%b %d, %Y', title: 'Date'} ]) ) ); const gb = vl.data(data_GB) .transform(vl.filter('datum.variable == "total postings"')) .layer( vl.markLine({interpolate: 'monotone', line: true, size: 3, color: "orange"}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('indeed_job_postings_index_SA').axis({format: "2s", nice: true, tickCount: 4}), vl.color().fieldN('jobcountry').title(false).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 6}), vl.tooltip([ { field: 'jobcountry', type: 'nominal', title: 'Country'}, { field: 'indeed_job_postings_index_SA', type: 'quantitative', title: 'Indeed Job Index'}, { field: 'date', type: 'temporal', format: '%b %d, %Y', title: 'Date'} ]) ) ); const ca = vl.data(data_CA) .transform(vl.filter('datum.variable == "total postings"')) .layer( vl.markLine({interpolate: 'monotone', line: true, size: 3, color: "pink"}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('indeed_job_postings_index_SA').axis({format: "2s", nice: true, tickCount: 4}), vl.color().fieldN('jobcountry').title(false).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 6}), vl.tooltip([ { field: 'jobcountry', type: 'nominal', title: 'Country'}, { field: 'indeed_job_postings_index_SA', type: 'quantitative', title: 'Indeed Job Index'}, { field: 'date', type: 'temporal', format: '%b %d, %Y', title: 'Date'} ]) ) ); const us = vl.data(data) .transform(vl.filter('datum.variable == "total postings"')) .layer( vl.markLine({interpolate: 'monotone', line: true, size: 3, color: "blue"}) .encode( vl.x().fieldT('date').title("Date").axis({format: "%b %Y", nice: true, grid: false}), vl.y().fieldQ('indeed_job_postings_index_SA').axis({format: "2s", nice: true, tickCount: 4}), vl.color().fieldN('jobcountry').title(false).legend({orient: "top", titleFontSize:12, labelFontSize: 12, symbolSize: 120, symbolStrokeWidth: 6}), vl.tooltip([ { field: 'jobcountry', type: 'nominal', title: 'Country'}, { field: 'indeed_job_postings_index_SA', type: 'quantitative', title: 'Indeed Job Index'}, { field: 'date', type: 'temporal', format: '%b %d, %Y', title: 'Date'} ]) ) ); return vl.layer(au, de, ie, gb, ca, us) .width(width/1.2) .height(320) .config({view: { stroke: null }}) .render(); }41:T447,data = { const raw = await d3.csv( "https://raw.githubusercontent.com/hiring-lab/job_postings_tracker/master/US/aggregate_job_postings_US.csv" ); const parsed = raw.map(d => ({ ...d, date: new Date(d.date), indeed_job_postings_index_SA: +d.indeed_job_postings_index_SA })); const maxDate = d3.max(parsed, d => d.date); const baseDate = new Date(maxDate); baseDate.setFullYear(baseDate.getFullYear() - 1); const getBase = (variable) => { const rows = parsed .filter(d => d.variable === variable) .sort((a, b) => Math.abs(a.date - baseDate) - Math.abs(b.date - baseDate)); return rows[0]?.indeed_job_postings_index_SA ?? null; }; const baseValues = { "total postings": getBase("total postings"), "new postings": getBase("new postings") }; return parsed.map(d => { const base = baseValues[d.variable]; const inRange = d.date >= baseDate; return { ...d, indeed_job_postings_index_SA_ly: (base != null && inRange) ? (d.indeed_job_postings_index_SA / base) * 100 : null }; }); }42:[{"id":"1ec3edc43ba66c0db419744c479d1b5118bb405587189f3ad739a10853f6f933d86824e809f4b4ad18053ab33fb5dc7c5f3d6bc601654c8ea976afd5b321f517","href":"https://static.observableusercontent.com/files/1ec3edc43ba66c0db419744c479d1b5118bb405587189f3ad739a10853f6f933d86824e809f4b4ad18053ab33fb5dc7c5f3d6bc601654c8ea976afd5b321f517","name":"counties-albers-10m.json","type":"application/json","lastModified":1752697109374.376,"size":795407}] 31:{"id":"b4c0db8315593a84","slug":"indeed-hiring-lab-job-postings-tracker","title":"Indeed Hiring Lab - Job Postings Tracker","thumbnail":"32f7ce76b22151f7ea23f92eb576360c546b02d975fc6311eb39927c1d7d3f94","access_level":"public","create_time":"$D2023-03-07T17:58:05.789Z","update_time":"$D2026-09-18T16:19:27.176Z","view_time":null,"first_public_time":"$D2023-03-07T17:58:05.789Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"3b88b27becc4bbe6","login":"robertmreedy","name":"Bobby Reedy","avatar_url":"https://avatars-next.observableusercontent.com/90f1a7d743c3a2110c947721108b59ac8dcf7901079833e3803e54258687e7a4","tier":"starter_2024"},"version":2480,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"78c022c35bbdd3b7","login":"robertmreedy","name":"Bobby Reedy","avatar_url":"https://avatars-next.observableusercontent.com/90f1a7d743c3a2110c947721108b59ac8dcf7901079833e3803e54258687e7a4","tier":null}],"members":[{"type":"individual","id":"78c022c35bbdd3b7","login":"robertmreedy","name":"Bobby Reedy","avatar_url":"https://avatars-next.observableusercontent.com/90f1a7d743c3a2110c947721108b59ac8dcf7901079833e3803e54258687e7a4","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":null,"type":"notebook","body":{"title":"Indeed Hiring Lab - Job Postings Tracker","cells":[{"id":0,"value":"# Indeed Hiring Lab - Job Postings Tracker\n\nU.S. Indeed Job Postings Index (Seasonally Adjusted). *Data as of: **${d3.timeFormat(\"%B %d, %Y\")(maxDate)}***\n\n*Source: [Indeed Hiring Lab](https://github.com/hiring-lab/job_postings_tracker/tree/master/US), [U.S. Bureau of Labor Statistics (JOLTS)](https://www.bls.gov/charts/job-openings-and-labor-turnover/unemp-per-job-opening.htm#)*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2445,"value":"viewof lookback = Inputs.radio([\"Since 2020\", \"Past Year\"], {\n label: \"Time Period\",\n value: \"Since 2020\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":399,"value":"

\n## Indeed Job Postings Index vs. JOLTS\n\n*Index is set to 100 = Feb 1, 2020 for Indeed and Jan 31, 2020 for JOLTS. *","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":390,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"

\n## Job Postings Trends by Sector\n\n*Job Postings by Sector vs. Total Postings*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1343,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2253,"value":"

\n## Indeed Job Postings by Sector\n\n*Percent change in total job postings on Indeed compared to pre-pandemic levels (Data as of: **${d3.timeFormat(\"%B %d, %Y\")(maxDate)}**)*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2250,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2255,"value":"\n Source: Indeed Hiring Lab. Percent Change since Feb. 1, 2020.
\n Visual created by Bobby Reedy.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1531,"value":"

\n## Job Postings Trends by Job Category\n\n*Job Postings by Job Category vs. Total Postings*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1533,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2126,"value":"

\n## Indeed Job Postings by Category / Sector\n\n*Percent change in total job postings on Indeed compared to pre-pandemic levels \n(Data as of: **${d3.timeFormat(\"%B %d, %Y\")(maxDate)}**)*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2279,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2076,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2138,"value":"\n Source: Indeed Hiring Lab. Percent Change since Feb. 1, 2020.
\n Visual created by Bobby Reedy.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":354,"value":"

\n## Job Postings Trends by Metro\n\n*Job Postings by Metro vs. Total Postings*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1437,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":367,"value":"

\n## Job Postings Trends by State\n\n*Job Postings by State vs. Total Postings*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1364,"value":"viewof region = {\n const type = select({\n title: \"Region\",\n options: [\n { label: 'Select All', value: 'Select All' },\n { label: 'Midwest', value: 'Midwest' },\n { label: 'Northeast', value: 'Northeast' },\n { label: 'South', value: 'South' },\n { label: 'West', value: 'West' }\n ],\n value: \"Select All\",\n description: \"Select Region to chart.\"\n });\n type.input.style.fontSize = \"0.8em\";\n return type;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":363,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1722,"value":"

\n## Indeed Job Postings Index by State\n\n*Percent change in total job postings on Indeed compared to pre-pandemic levels (Data as of: **${d3.timeFormat(\"%B %d, %Y\")(maxDate)}**)*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1654,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1936,"value":"\n Source: Indeed Hiring Lab. Percent Change since Feb. 2020.
\n Map created by Bobby Reedy.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2357,"value":"

\n## Indeed Job Postings by State\n\n*Percent change in total job postings on Indeed compared to pre-pandemic levels (Data as of: **${d3.timeFormat(\"%B %d, %Y\")(maxDate)}**)*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2354,"value":"$3f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2364,"value":"\n Source: Indeed Hiring Lab. Percent Change since Feb. 2020.
\n Visual created by Bobby Reedy.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1054,"value":"

\n## Job Postings Trends by County\n\n*Total Job Postings by Country over Time*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1051,"value":"$40","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":971,"value":"

\n## Occupational Sector Job Titles \n\n*Job Titles for each respective Occupational Sector*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":960,"value":"printTable(job_titles)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"

\n## Code and Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":18,"value":"$41","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1859,"value":"sector_data = (\n await d3.csv(\"https://raw.githubusercontent.com/hiring-lab/job_postings_tracker/master/US/job_postings_by_sector_US.csv\")\n).map(row => {\n const cleanName = row.display_name.replace(\",\", \"\");\n const match = sector_category.find(x => x.Sector === cleanName);\n return match ? { ...row, ...match } : row;\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1847,"value":"state_data = (\n await d3.csv(\"https://raw.githubusercontent.com/hiring-lab/job_postings_tracker/master/US/state_job_postings_us.csv\")\n).map(d => {\n // uppercase state\n const stateUpper = d.state.toUpperCase();\n\n // find matching region info\n const match = census_regions.find(x => x.state === stateUpper);\n\n return match\n ? { ...d, state: stateUpper, ...match }\n : { ...d, state: stateUpper };\n});\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1851,"value":"metro_data = (\n await d3.csv(\"https://raw.githubusercontent.com/hiring-lab/job_postings_tracker/master/US/metro_job_postings_us.csv\")\n).map(row => {\n const match = cbsa_state.find(x => x.CBSA === row.cbsa_code);\n return match ? { ...row, ...match } : row;\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":962,"value":"job_titles = d3.csv(\"https://raw.githubusercontent.com/hiring-lab/job_postings_tracker/master/sector-job-title-examples.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1060,"value":"data_CA = d3.csv(\"https://raw.githubusercontent.com/hiring-lab/job_postings_tracker/master/CA/aggregate_job_postings_CA.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1064,"value":"data_DE = d3.csv(\"https://raw.githubusercontent.com/hiring-lab/job_postings_tracker/master/DE/aggregate_job_postings_DE.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1070,"value":"data_GB = d3.csv(\"https://raw.githubusercontent.com/hiring-lab/job_postings_tracker/master/GB/aggregate_job_postings_GB.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1073,"value":"data_IE = d3.csv(\"https://raw.githubusercontent.com/hiring-lab/job_postings_tracker/master/IE/aggregate_job_postings_IE.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1076,"value":"data_AU = d3.csv(\"https://raw.githubusercontent.com/hiring-lab/job_postings_tracker/master/AU/aggregate_job_postings_AU.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1286,"value":"cbsa_state = d3.csv(\"https://gist.githubusercontent.com/aodin/5583cd21d7e07f6c7c9dbd4bd0b26e64/raw/54dd81dd5361b66d6f9676d8b7c44d395dc8a0cd/us_metro_with_state_fips.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1290,"value":"census_regions = d3.csv(\"https://raw.githubusercontent.com/cphalpert/census-regions/refs/heads/master/us%20census%20bureau%20regions%20and%20divisions.csv\").then(data =>\n data.map(d => ({\n ...d,\n state: d[\"State Code\"]\n }))\n);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1328,"value":"sector_category = FileAttachment(\"sector_category_ref-1-1-1.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1738,"value":"maxDate = d3.max(data, d => new Date(d.date));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1765,"value":"sector_data_latest = sector_data.filter(\n d =>\n new Date(d.date).getTime() === maxDate.getTime() &&\n d.variable === \"total postings\"\n);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2268,"value":"category_data_latest = Array.from(\n d3.rollup(\n sector_data_latest,\n v => Math.round(d3.mean(v, d => d.indeed_job_postings_index)),\n d => d.Category\n ),\n ([Category, indeed_job_postings_index]) => ({ Category, indeed_job_postings_index })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1709,"value":"state_data_latest = state_data.filter(d => new Date(d.date).getTime() === maxDate.getTime());","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":374,"value":"jolts_data = d3.csv(\"https://raw.githubusercontent.com/robertmreedy/FRED_JOLTS_JOB_OPENINGS/refs/heads/main/data/jtsjol_processed.csv\") ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1890,"value":"stateAbbrevMap = ({\n \"Alabama\": \"AL\", \"Alaska\": \"AK\", \"Arizona\": \"AZ\", \"Arkansas\": \"AR\",\n \"California\": \"CA\", \"Colorado\": \"CO\", \"Connecticut\": \"CT\", \"Delaware\": \"DE\",\n \"Florida\": \"FL\", \"Georgia\": \"GA\", \"Hawaii\": \"HI\", \"Idaho\": \"ID\",\n \"Illinois\": \"IL\", \"Indiana\": \"IN\", \"Iowa\": \"IA\", \"Kansas\": \"KS\",\n \"Kentucky\": \"KY\", \"Louisiana\": \"LA\", \"Maine\": \"ME\", \"Maryland\": \"MD\",\n \"Massachusetts\": \"MA\", \"Michigan\": \"MI\", \"Minnesota\": \"MN\", \"Mississippi\": \"MS\",\n \"Missouri\": \"MO\", \"Montana\": \"MT\", \"Nebraska\": \"NE\", \"Nevada\": \"NV\",\n \"New Hampshire\": \"NH\", \"New Jersey\": \"NJ\", \"New Mexico\": \"NM\", \"New York\": \"NY\",\n \"North Carolina\": \"NC\", \"North Dakota\": \"ND\", \"Ohio\": \"OH\", \"Oklahoma\": \"OK\",\n \"Oregon\": \"OR\", \"Pennsylvania\": \"PA\", \"Rhode Island\": \"RI\", \"South Carolina\": \"SC\",\n \"South Dakota\": \"SD\", \"Tennessee\": \"TN\", \"Texas\": \"TX\", \"Utah\": \"UT\",\n \"Vermont\": \"VT\", \"Virginia\": \"VA\", \"Washington\": \"WA\", \"West Virginia\": \"WV\",\n \"Wisconsin\": \"WI\", \"Wyoming\": \"WY\", \"District of Columbia\": \"DC\"\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2032,"value":"northeastStates = new Set([\n \"Connecticut\",\n \"Rhode Island\",\n \"Delaware\",\n \"District of Columbia\"\n]);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1656,"value":"valuemap = new Map(state_data.map(d => [d.State, d.indeed_job_postings_index]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1659,"value":"us = FileAttachment(\"counties-albers-10m.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":957,"value":"import {printTable} from '@uwdata/data-utilities'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1340,"value":"import {select, radio} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"import {vl} from '@vega/vega-lite-api-v5'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W42","stdlib":"1","titling":"auto"}} 32:"$31:body"