2a:null 2b:["$","title",null,{"children":"Visualizing Games Industry Layoffs | Ben Oldenburg | Observable"}] 30:T2533,Games_Industry_Layoffs = { // This code is still a bit of a mess, need to clean up const chartid = "chart-layoffs"; const height = 400; const margin = ({ top: 20, right: 0, bottom: 60, left: 20 }); const innerHeight = height - margin.top - margin.bottom; const innerWidth = width - margin.left - margin.right; // Metrics selections. let dataNodes = data.set.map(d => Object.assign({}, d)) let selectX = "Date"; let selectR = "Count"; let xExtent = d3.extent(dataNodes, d => d[selectX]) // Title & Source let chartTitle = "Games Industry Layoffs " let chartSubTitle = `January 2022 to ${d3.timeFormat("%B %Y")(xExtent[1])}` // let chartSubTitle = `January 2022 to May 2024` // let chartSource = "Data: Games Industry Layoffs (videogamelayoffs.com as of March 1, 2024) / Design: @benoldenburg" let chartSource = "Data: Games Industry Layoffs (videogamelayoffs.com as of 12/6/24) / Design: @benoldenburg" let titlePosition = 30 // let titlePosition = innerHeight - 40 let legendPosition = innerHeight-4 let color = ({ y2021: "#facc42", // facd60 y2022: "#facc42", // facd60 y2023: "#f09855", y2024: "#e74e45", // "#e86348", noValue: "#CCC", textTitle: "#333", textSource: "#AAA", legend: "#CCC", textLegend: "#888", }) let xStrength = 6; // forces the nodes closer to data on x axis (makes data more vertical) let formatCount = d3.format(`,.${3}s`); //let formatCount = d3.format(`,.0f`); // let formatCount = d3.format(`,.${innerWidth < 700 ? 2 : 3}s`); const svg = d3.create("svg") .attr("viewBox", [0, 0, width, height]) .attr("id", chartid); const group = svg.append("g") .attr('transform', `translate(${margin.left}, ${margin.top})`); //////////////////////////////////////// // Scales let x = d3.scaleTime().domain(xExtent) x.range([(innerWidth*0.1), innerWidth-(innerWidth*0.1)]) // Bubble Size let rMax = 18; let rMin = 4; let r = d3.scaleSqrt() .domain([0, d3.extent(dataNodes, d => d[selectR])[1]]) .range([rMin, rMax]) //////////////////////////////////////// // Source group.append("text") .attr("class", "chart-title") .text(chartTitle) .attr("text-anchor", "left") .attr("x", 0) .attr("y", titlePosition) .attr('fill', color.textTitle) .attr('font-size', '24px') .attr('font-weight', '700') group.append("text") .attr("class", "chart-subtitle") .text(chartSubTitle) .attr("text-anchor", "left") .attr("x", 0) .attr("y", titlePosition + 20) .attr('fill', color.textTitle) .attr('font-size', '15px') //.attr('font-weight', '600') //.attr('font-family', 'sans-serif'); group.append("text") .attr("class", "chart-source") .text(chartSource) .attr("text-anchor", "left") .attr("x", 0) .attr("y", innerHeight + margin.bottom - 14) .attr('fill', color.textSource) .attr('font-size', '.6rem') .attr('font-family', 'sans-serif'); //////////////////////////////////////// // Legend let rLegend = group.append("g") .attr("transform", `translate(${0},${legendPosition})`) rLegend.append('circle') .attr('r', rMin) .attr('cx',rMin) .attr('fill', 'none') .attr('stroke', color.legend) rLegend.append('circle') .attr('r', (rMin+rMax)/2) .attr('cx',(rMin+rMax)/2) .attr('fill', 'none') .attr('stroke', color.legend) rLegend.append('circle') .attr('r', rMax) .attr('cx', rMax) .attr('fill', 'none') .attr('stroke', color.legend) rLegend.append('text') .text("Layoffs") .attr('x', (6 + rMax*2)) .attr('font-size', '10px') .attr('font-family', 'sans-serif') .attr('font-weight', 'bold') //.attr('alignment-baseline', 'middle') .attr('dy', '.35em') .attr('fill', color.textLegend) let noDataOffset = 90 let rLegend2 = rLegend.append("g") .attr("transform", `translate(${10 + rMax*2},${20})`) rLegend2.append('circle') .attr('fill', color.noValue) .attr('r', rMin) rLegend2.append('text') .text("Unknown Number") .attr('x', (rMin*2)) .attr('font-size', '10px') .attr('font-family', 'sans-serif') .attr('font-weight', 'bold') // .attr('alignment-baseline', 'middle') .attr('dy', '.35em') .attr('fill', color.textLegend) //////////////////////////////////////// // Standard Axis >> Wanted to do something more customizes // let xAxis = d3.axisBottom(x) // .ticks(4) // let xg = group.append("g") // .attr("class", "x axis") // .attr("transform", "translate("+ 0 + "," + innerHeight + ")") // .call(xAxis) // .call(g => g.selectAll(".domain").remove()); //////////////////////////////////////// // Custom Axis Summary const summary = group.append('g') .attr('className', 'summary') let summarylabels = summary.selectAll('g') .data(data.summary) .join('g') .attr('transform', d => { let xPos = (d.year === 2024) ? x(d.ending) + 15 : x(d.ending) - 10 return `translate(${xPos},${innerHeight + 20})` // return `translate(${x(d.ending)},${innerHeight + 20})` }) .attr('class', 'summarylabel') summarylabels.append('line') .attr('x1', 0) .attr('x2', 0) .attr('y1', 0 - innerHeight/4) .attr('y2', 0) .attr('stroke', '#CCC') summarylabels.append('text') .text(d => d.year) .attr('x', -4) .attr('y', 0) .attr('fill', color.textTitle) .attr("text-anchor", "end") .attr('font-size', '15px') .attr('font-weight', '600') summarylabels.append('text') .text(d => formatCount(d.total)) .attr('x', -4) .attr('y', -17) .attr('fill', d => color[`y${d.year}`]) .attr("text-anchor", "end") .attr('font-size', '17px') .attr('font-weight', '600') .attr('font-family','sans-serif') //////////////////////////////////////// // Nodes const nodes = group.append('g') .attr('className', 'nodes') let node = nodes.selectAll('g') .data(dataNodes) .join('g') .attr('transform', d => { d.r = r(d[selectR]) let xVal = d[selectX]; d.xf = x(xVal); d.yf = (innerHeight/2) ; d.x = d.xf d.y = d.yf return `translate(${d.x},${d.y})` }) .attr('class', d => { return 'node' }) .on('mouseover', nodeMouseOver) .on('mouseout', nodeMouseOut ); node.append('circle') .attr('class', 'bubble') //.attr('pointer-events', 'none') .attr('r', d => { //d.r = r(d[selectR]) return d.r }) .attr('opacity', d => d.Count > 0 ? 1 : 0.5) // .attr('fill', d => color[`y${d.Year}`]) .attr('fill', d => d.Count > 0 ? color[`y${d.Year}`] : color.noValue) //.attr('fill', d => d.activeR ? color[`y${d.Year}`] : "#CCC") const labels = group.append('g') .attr('className', 'labels') let nodeLabels = labels.selectAll('g') .data(dataNodes.filter(d => d[selectR] >= 500)) .join('g') .attr('transform', d => { d.r = r(d[selectR]) let xVal = d[selectX]; let rVal = d[selectR]; d.xf = x(xVal); d.yf = (innerHeight/2) ; return `translate(${d.x},${d.y})` }) .attr('class', 'label') nodeLabels.append('text') .attr('x', function(d) { return 20 / d.group }) .attr('dy', '.35em') .style('font-size', '10px') .style('font-weight', '600') .style('font-family','sans-serif') .attr('fill', "#111") .attr("text-anchor", "middle") //.attr("alignment-baseline", "middle") // .attr("paint-order", "stroke") // .attr("stroke-linejoin", "round") // .attr("stroke", "rgba(255,255,255, .6)") // .attr("stroke-width", 3) .attr("pointer-events", "none") // .attr("opacity", .75) .text(d => abbr(d['Studio'])); //////////////////////////////////////// // Force Simulation let simulation = d3.forceSimulation(dataNodes) //.force('charge', d3.forceManyBody().strength(-1)) .force('x', d3.forceX(d => d.xf).strength(xStrength)) .force('y', d3.forceY(d => d.yf)) .force('collision', d3.forceCollide().radius(d => d.r + 1)) .on("tick", ticked); function ticked() { node .attr('transform', d => { d.x = Math.max(d.r, Math.min(innerWidth - d.r, d.x)); d.y = Math.max(d.r, Math.min(innerHeight - d.r, d.y)); return `translate(${d.x},${d.y})` }) nodeLabels .attr('transform', d => { d.x = Math.max(d.r, Math.min(innerWidth - d.r, d.x)); d.y = Math.max(d.r, Math.min(innerHeight - d.r, d.y)); return `translate(${d.x},${d.y})` }) } invalidation.then(() => simulation.stop()); //////////////////////////////////////// // Interactivity - Mouse Events function nodeMouseOver(event, d){ d3.select(event.target) .attr('stroke', '#333') .attr('stroke-width', 3); chartTip.style("left", () => { if (innerWidth - d.x < 140) { return event.pageX - (24+140) + "px"; } else { return event.pageX + 24 + "px"; } }) .style("top", event.pageY + 24 + "px") .style("display", "inline-block") .html(`${tipLayout(d)}`); } function nodeMouseOut(event, d){ chartTip.style("display", "none"); // Hide toolTip d3.select(event.target) .attr('stroke', '#FFF') .attr('stroke-width', 0); } return svg.node() }31:Tb49,data = { let result = {} let set = [] let setAT = [] let timeParsedAT = d3.timeParse("%Y-%m-%d") // '2020-01-01' let timeParsed = d3.timeParse("%m/%d/%Y") // '2020-01-01' // Process Airtable Data function processAirTable(data) { data.forEach(d => { // console.log(d.Date) d.Studio = d.Studio.trim() d.Parent = d.Parent.trim() d.isParent = d.Parent !== "" && d.Parent !== d.Studio d.Type = d.Type.trim() d.Date = timeParsedAT(d.Date) d.Year = d.Date.getFullYear() d.Count = +d.Headcount d.CountText = d.Count === 0 ? "Unknown" : d.Count setAT.push(d) }) } //processAirTable(await FileAttachment("2021-GI-Layoffs-AirTable.csv").csv()) processAirTable(await FileAttachment("2022-GI-Layoffs-AirTable.csv").csv()) processAirTable(await FileAttachment("2023-GI-Layoffs-AirTable.csv").csv()) processAirTable(await FileAttachment("2024-GI-Layoffs-AirTable-Partial-1216@1.csv").csv()) //process(await FileAttachment("2024-GI-Layoffs-Partial-2.tsv").tsv()) // Process Website Data function process(data) { data.forEach(d => { // console.log(d.Date) d.Studio = d.Studio.trim() d.Parent = d["Parent Company"].trim() d.isParent = d.Parent !== "" && d.Parent !== d.Studio d.Type = d.Type.trim() d.Date = timeParsed(d.Date.replace("~", '')) console.log(d.Studio) console.log(d.Date) d.Year = d.Date.getFullYear() d.Count = +d["Number Affected"].replace("~", '').replace("?", '') d.CountText = d.Count === 0 ? "Unknown" : d["Number Affected"] set.push(d) }) } process(d3.tsvParse(await FileAttachment("2022-GI-Layoffs@2.tsv").text())) process(d3.tsvParse(await FileAttachment("2023-GI-Layoffs@1.tsv").text())) process(d3.tsvParse(await FileAttachment("2024-GI-Layoffs@1.tsv").text())) process(d3.tsvParse(await FileAttachment("2025-GI-Layoffs.tsv").text())) process(d3.tsvParse(await FileAttachment("2026-GI-Layoffs-Partial@1.tsv").text())) result.totals = {} result.totals.airtable_layoffs = d3.rollups(setAT, data => d3.sum(data, d => d.Count)) result.totals.airtable_entries = setAT.length result.totals.website_layoffs = d3.rollups(set, data => d3.sum(data, d => d.Count)) result.totals.website_entries = set.length // Function to generate the annual totals for the dataset function summarize(array){ return d3.groups(array, d => d.Year).map(d => { // let timeParsed = d3.timeParse("%Y-%m-%d") let year = d[0] let count = d[1].length let total = d3.sum(d[1], d => d.Count) let ending = (year === 2024) ? d3.extent(d[1], d.Date)[1].Date : timeParsedAT(year+"-12-31") return {year, count, total, ending} }) } result.summary = summarize(setAT) result.set = setAT // result.summary = summarize(set) // result.set = set return result }32:T447,html` `33:[{"id":"4a0950a075879ef5249d4f1cb9d96503c8493be3ffbd0aaf081d9c0ce4348eef47ae34b99097857a32f819a41424e4ae51ad897911b33839be2006151663d74b","href":"https://static.observableusercontent.com/files/4a0950a075879ef5249d4f1cb9d96503c8493be3ffbd0aaf081d9c0ce4348eef47ae34b99097857a32f819a41424e4ae51ad897911b33839be2006151663d74b","name":"2024-GI-Layoffs-AirTable-Partial-1216.csv","type":"text/csv","lastModified":1734400495573.098,"size":13655},{"id":"a82aae040c70535a4d0c5fb340f081e11c472294fa52c6ae67a2910427ed039d3ee724cbdc893bfead72d2452f4be3afa3efafa4eb0eb199947bd8a67b4beb77","href":"https://static.observableusercontent.com/files/a82aae040c70535a4d0c5fb340f081e11c472294fa52c6ae67a2910427ed039d3ee724cbdc893bfead72d2452f4be3afa3efafa4eb0eb199947bd8a67b4beb77","name":"2024-GI-Layoffs-AirTable-Partial-1216@1.csv","type":"text/csv","lastModified":1734400836314.084,"size":13655},{"id":"5207611368d2b500595cc336a405152bd328e0158e5c6c2f95d2c8fd617c71856c06dfb74e740d62928bdebcdd8fe7fae86489797f168a74c63d83783e6ce6ef","href":"https://static.observableusercontent.com/files/5207611368d2b500595cc336a405152bd328e0158e5c6c2f95d2c8fd617c71856c06dfb74e740d62928bdebcdd8fe7fae86489797f168a74c63d83783e6ce6ef","name":"2024-GI-Layoffs-AirTable-Partial-0328.csv","type":"text/csv","lastModified":1712026454851.449,"size":4682},{"id":"d083583111a8a9bffdd42c0cb17accf9e0a57869d9962133cec21b2c6caff3780c11f6f312d3a2599889cccc04f3397630a84903003beb4826802d0904da82ef","href":"https://static.observableusercontent.com/files/d083583111a8a9bffdd42c0cb17accf9e0a57869d9962133cec21b2c6caff3780c11f6f312d3a2599889cccc04f3397630a84903003beb4826802d0904da82ef","name":"2022-GI-Layoffs-AirTable.csv","type":"text/csv","lastModified":1709394018674.049,"size":3401},{"id":"29ca964f713bc09165dbe3c5f259baed815416f3d82f3fe64dbf3e31fe310e8532ddd75f612f3287068f76f403351ae3c5cbb53ea0e93ff47bf22561727fb575","href":"https://static.observableusercontent.com/files/29ca964f713bc09165dbe3c5f259baed815416f3d82f3fe64dbf3e31fe310e8532ddd75f612f3287068f76f403351ae3c5cbb53ea0e93ff47bf22561727fb575","name":"2023-GI-Layoffs-AirTable.csv","type":"text/csv","lastModified":1709394018698.07,"size":13819},{"id":"cdfb7496d2522c4853a5d84ba2b9938ced69d6c58aaa599a29738aabee20131c9a4b0527597fa560b3adbef2cbae384379860e06d75bae86c52007f21b8e9054","href":"https://static.observableusercontent.com/files/cdfb7496d2522c4853a5d84ba2b9938ced69d6c58aaa599a29738aabee20131c9a4b0527597fa560b3adbef2cbae384379860e06d75bae86c52007f21b8e9054","name":"2024-GI-Layoffs-AirTable-Partial@1.csv","type":"text/csv","lastModified":1709394022540.137,"size":3692},{"id":"2e86832c0d3f1f393e1db87fbc8ddf30707b7bdb507c8412d742e1b2960be5391acaf967c1829aa2cdc9b84370e83ca8f83427daa0ff1c1388935041c3399f70","href":"https://static.observableusercontent.com/files/2e86832c0d3f1f393e1db87fbc8ddf30707b7bdb507c8412d742e1b2960be5391acaf967c1829aa2cdc9b84370e83ca8f83427daa0ff1c1388935041c3399f70","name":"2023-GI-Layoffs@1.tsv","type":"text/tab-separated-values","lastModified":1709395989237.716,"size":16797},{"id":"f593661d60ecc799cc8dd6d00acb2ff43d5ae0f808f268acc4954f45d5bdf996cf5d5ae40d49e4a5aacd95b08476d4c23e7b59a347575ea094d9ed37eb252bae","href":"https://static.observableusercontent.com/files/f593661d60ecc799cc8dd6d00acb2ff43d5ae0f808f268acc4954f45d5bdf996cf5d5ae40d49e4a5aacd95b08476d4c23e7b59a347575ea094d9ed37eb252bae","name":"2022-GI-Layoffs@2.tsv","type":"text/tab-separated-values","lastModified":1709396001512.676,"size":6431},{"id":"8211e56501a35d791e487437794f987476e0afaebab091a712c6d2cd94afa89a1bd4b965342e3d20bd3958647c3cfd9970c7fa6e60fe934b885695c428dc1597","href":"https://static.observableusercontent.com/files/8211e56501a35d791e487437794f987476e0afaebab091a712c6d2cd94afa89a1bd4b965342e3d20bd3958647c3cfd9970c7fa6e60fe934b885695c428dc1597","name":"2024-GI-Layoffs-Partial@2.tsv","type":"text/tab-separated-values","lastModified":1711074821778.21,"size":7078},{"id":"c477f54435f27fdfdee6e687461a353de7cc1c8980a32dbc295224ba2008fe2b31f21270d48363171dfc3f2a4b111808e8aa63f9b6198112008c20405a616f92","href":"https://static.observableusercontent.com/files/c477f54435f27fdfdee6e687461a353de7cc1c8980a32dbc295224ba2008fe2b31f21270d48363171dfc3f2a4b111808e8aa63f9b6198112008c20405a616f92","name":"2024-GI-Layoffs-AirTable-Partial-0523.csv","type":"text/csv","lastModified":1716471301202.094,"size":6317},{"id":"06e2278a982e08293cfafd3448cbd8eb378ac6054f20e885a46b58a3c74a3418568c1ff5b9bb9c2b484d9ddff9b6b007aab9b1b62b4076b1334996440ad6ba3b","href":"https://static.observableusercontent.com/files/06e2278a982e08293cfafd3448cbd8eb378ac6054f20e885a46b58a3c74a3418568c1ff5b9bb9c2b484d9ddff9b6b007aab9b1b62b4076b1334996440ad6ba3b","name":"2024-GI-Layoffs-AirTable-Partial-0523@1.csv","type":"text/csv","lastModified":1716471396339.481,"size":6317},{"id":"8211e56501a35d791e487437794f987476e0afaebab091a712c6d2cd94afa89a1bd4b965342e3d20bd3958647c3cfd9970c7fa6e60fe934b885695c428dc1597","href":"https://static.observableusercontent.com/files/8211e56501a35d791e487437794f987476e0afaebab091a712c6d2cd94afa89a1bd4b965342e3d20bd3958647c3cfd9970c7fa6e60fe934b885695c428dc1597","name":"2024-GI-Layoffs-Partial-2.tsv","type":"text/tab-separated-values","lastModified":1723153305629.177,"size":7078},{"id":"fadb0af998a948672d11b07327d53aee89811919815d03323c82e997a937a82c351b0c8a93fa850fa41202256693ca9eca3e74b9edee68e69341f62814120fa1","href":"https://static.observableusercontent.com/files/fadb0af998a948672d11b07327d53aee89811919815d03323c82e997a937a82c351b0c8a93fa850fa41202256693ca9eca3e74b9edee68e69341f62814120fa1","name":"2024-GI-Layoffs.tsv","type":"text/tab-separated-values","lastModified":1783741536445.375,"size":23007},{"id":"2e03606926ac5d6e38bb81b3847aec6170ecb46aab31a7f092b43e8d4cd59d9fd4c8d07bdd7f34247bd0c9f3c3abbc21381f5b024d176285592ce73f209a5e0a","href":"https://static.observableusercontent.com/files/2e03606926ac5d6e38bb81b3847aec6170ecb46aab31a7f092b43e8d4cd59d9fd4c8d07bdd7f34247bd0c9f3c3abbc21381f5b024d176285592ce73f209a5e0a","name":"2025-GI-Layoffs.tsv","type":"text/tab-separated-values","lastModified":1783741549445.279,"size":16841},{"id":"6d598e9f74b0049f02295598941fe8545141b2ffda319ee578b0594517f098bbfa186efa95c9f8bf172446c7d8b981e872c9761ad261b6a093b72e28ecf86f4a","href":"https://static.observableusercontent.com/files/6d598e9f74b0049f02295598941fe8545141b2ffda319ee578b0594517f098bbfa186efa95c9f8bf172446c7d8b981e872c9761ad261b6a093b72e28ecf86f4a","name":"2026-GI-Layoffs-Partial.tsv","type":"text/tab-separated-values","lastModified":1783741554358.42,"size":8592},{"id":"ed680abd4631b76bf32c826e0fa545d1c0fab3ed5c1d1bd3888dffaf7791be3606ac0b98102539d665734572acc664ad810f7c66a43e90df54a07d9b4fdb7e73","href":"https://static.observableusercontent.com/files/ed680abd4631b76bf32c826e0fa545d1c0fab3ed5c1d1bd3888dffaf7791be3606ac0b98102539d665734572acc664ad810f7c66a43e90df54a07d9b4fdb7e73","name":"2024-GI-Layoffs@1.tsv","type":"text/tab-separated-values","lastModified":1783742092023.373,"size":23007},{"id":"87a318917220d13850ca129a8fcd6381c555d9874b372abfcfbbf0cb971010dbb11feb984b3c39158639c4ce80026f26028a242727763e078d364df3d5b7bf51","href":"https://static.observableusercontent.com/files/87a318917220d13850ca129a8fcd6381c555d9874b372abfcfbbf0cb971010dbb11feb984b3c39158639c4ce80026f26028a242727763e078d364df3d5b7bf51","name":"2026-GI-Layoffs-Partial@1.tsv","type":"text/tab-separated-values","lastModified":1783742220575.278,"size":8592}] 2e:{"id":"1ac878be72194053","slug":"visualizing-games-industry-layoffs","title":"Visualizing Games Industry Layoffs","thumbnail":"a59ab8f41ca0580a0f87b2d6ca226b4602e7a6be271579766bb1f38f3c3a18c7","access_level":"public","create_time":"$D2024-02-28T00:45:00.345Z","update_time":"$D2026-07-11T04:08:11.058Z","view_time":null,"first_public_time":"$D2024-03-03T02:26:03.170Z","fork":false,"stars":29,"starred":false,"owner":{"type":"team","id":"113f2867d5a070ee","login":"benoldenburg","name":"Ben Oldenburg","avatar_url":"https://avatars-next.observableusercontent.com/8a88f07aaf262f0c6598eefd37083f84a94a8d06481968e87848779677f30fd6","tier":"starter_2024"},"version":725,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"e38da6b448cb1251","login":"benoldenburg","name":"Ben Oldenburg","avatar_url":"https://avatars-next.observableusercontent.com/8a88f07aaf262f0c6598eefd37083f84a94a8d06481968e87848779677f30fd6","tier":null}],"members":[{"type":"team","id":"113f2867d5a070ee","login":"benoldenburg","name":"Ben Oldenburg","avatar_url":"https://avatars-next.observableusercontent.com/8a88f07aaf262f0c6598eefd37083f84a94a8d06481968e87848779677f30fd6","tier":"starter_2024","role":"editor"},{"type":"individual","id":"e38da6b448cb1251","login":"benoldenburg","name":"Ben Oldenburg","avatar_url":"https://avatars-next.observableusercontent.com/8a88f07aaf262f0c6598eefd37083f84a94a8d06481968e87848779677f30fd6","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":13,"collection":null,"type":"notebook","body":{"title":"Visualizing Games Industry Layoffs","cells":[{"id":0,"value":"# Visualizing Games Industry Layoffs\n\nBased on what has felt like an increasing frequency and scale of games industry layoffs I wanted to try a and visualize the trend. Immense credit goes to the source data maintained an updated by Farhan Noor’s at [Games Industry Layoffs](https://publish.obsidian.md/vg-layoffs/) which also collects some jobs resources for those affected. The visualization is a work in progress. It would be ideal to load the live dataset so the visual automatically updates and I may add addition views.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":88,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":251,"value":"### Dataset\nThe data comes from [Games Industry Layoffs](https://publish.obsidian.md/vg-layoffs/) which looked to be the most comprehensive going back to at least 2022. The visualization is current using CSV files exported from the AirTable dataset. There were a few minor inconsistencies between the AirTable data and tables hosted on the main website but the AirTable data looked like it tracked closer to published totals. In addition to layoff announcements that may still be announced there may be slight inconsistencies with the exact totals. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":7,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":700,"value":"await FileAttachment(\"2024-GI-Layoffs-Partial-2.tsv\").tsv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":633,"value":"_Other found but unused references:_\n+ Layoffs ([gamesindustry.biz](https://www.gamesindustry.biz/topics/layoffs))\n+ Every Video Game Industry Layoff In 2024 ([Kotaku](https://kotaku.com/game-industry-layoffs-how-many-2024-unity-twitch-1851155818))","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":244,"value":"### Support Functions and Styles","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":60,"value":"function isNum(n) {\n return !isNaN(parseFloat(n)) && isFinite(n) && n !== \"\";\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":627,"value":"ToolTip Function and Styling","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":66,"value":"function tipLayout(d) {\n let dateFormat = d3.timeFormat(\"%b %e, %Y\");\n let tipContent = ``; // Start content string\n \n let studio = d['Studio'];\n let layoffs = d['Count'] > 0 ? d['Count'] : \"Unknown #\";\n let date = d['Date'];\n\n // \n tipContent += `

${dateFormat(date)}

`\n tipContent += `

${studio}

`\n if (d.isParent) {\n tipContent += `Parent: ${d['Parent']}`\n }\n tipContent += `

`\n if (d['Count'] > 0) {\n tipContent += `Layoffs: ${layoffs}
`\n } else {\n tipContent += `Layoffs: ${\"Unknown\"}
`\n }\n\n \n\n \n\n return tipContent;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":64,"value":"chartTip = d3.select(\"body\").append(\"div\").attr(\"class\", \"toolTip chartTip\");","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":133,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":237,"value":"**Handling abbreviated names for direct labels.** The `abbreviations` object holds manual abbreviations for when the automatic formatting of the just the first word in the `abbr()` function is insufficient. Since only companies with over 500 layoffs are directly labels there aren't that many cases.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":186,"value":"function abbr(str) {\n let abbrKeys = Object.keys(abbreviations)\n if (abbrKeys.includes(str)) {\n return abbreviations[str]\n } else {\n return str.trim().split(\" \")[0];\n } \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":188,"value":"abbreviations = ({\n \"Electronic Arts\": \"EA\",\n \"Game Insight\": \"Game Insight\",\n \"Zhoaoxi Guangnian (Nuverse)\": \"Nuverse\",\n \"Zhaoxi Guangnian (Nuverse)\": \"Nuverse\",\n \"Perfect World Games\": \"Perfect World\",\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 2f:"$2e:body"