31:T2035,populationChart = { const svg = d3 .create('svg') .attr('viewBox', [0, 0, width, height]) .attr('font-family', 'Roboto Condensed, Helvetica Neue, Hiragino Sans'); const populationX = d3 .scaleLinear() .domain([0, 600000]) .range([0, sexX.bandwidth()]); const g = svg.append('g'); // .attr('transform', `translate(${margin.left}, ${margin.top})`); g.append('rect') .classed('bg', true) .attr('width', width) .attr('height', height) .attr('fill', 'hsl(42, 100%, 98%)'); const startDate = new Date('2020-08-16'); const endDate = new Date('2020-08-22'); const data = ageSexPatientsOfDateRange(startDate, endDate); const ageG = g .selectAll('g.age') .data(data) .join('g') .classed('age', true) .attr('transform', d => `translate(0, ${ageY(d.key)})`); const sexG = ageG .selectAll('g') .data(d => d.values) .join('g') .attr('transform', d => `translate(${sexX(d.key)}, 0)`); sexG .selectAll('rect.bar') .data(d => [d]) .join('rect') .classed('bar', true) .attr('x', d => d.key === '男性' ? sexX.bandwidth() - populationX(d.population) : 0 ) .attr('y', 0) .attr('width', d => populationX(d.population)) .attr('height', ageY.bandwidth()) .attr('fill', 'hsl(19, 100%, 90%)') .attr('opacity', 0.5); const rowNum = 6; const circleMargin = (ageY.bandwidth() - rowNum) * 0.05; const r = (ageY.bandwidth() - (rowNum + 1) * circleMargin) / rowNum / 2; const circleX = (d, i) => { let x = Math.floor(i / rowNum) * (r * 2 + circleMargin) + r + circleMargin; if (d.sex === '男性') { x = sexX.bandwidth() - x; } if (d.sex === '調査中') { x = width / 2; } return x; }; const circleY = (d, i) => { if (d.sex === '調査中') { i = i + 4; } return (i % rowNum) * (r * 2 + circleMargin) + r + circleMargin; }; const circleTransform = (d, i) => { let transform; switch (d.sex) { case '男性': transform = `translate(${sexX.bandwidth() - (Math.floor(i / rowNum) * (r * 2 + circleMargin) + r + circleMargin)}, ${(i % rowNum) * (r * 2 + circleMargin) + r + circleMargin})`; break; case '女性': transform = `translate(${Math.floor(i / rowNum) * (r * 2 + circleMargin) + r + circleMargin}, ${(i % rowNum) * (r * 2 + circleMargin) + r + circleMargin})`; break; case '調査中': default: transform = `translate(${width / 2 - r + Math.floor(i / rowNum) * (r * 2 + 1) + r + circleMargin}, ${((i + 4) % rowNum) * (r * 2 + circleMargin) + r + circleMargin})`; break; } return transform; }; const patientStroke = '#000'; const patientStrokeWidth = d => (d.statusSort <= 6 ? 1 : 0.5); sexG .selectAll('circle') .data(d => d.values) .join('circle') .attr('class', d => `status-${transitionIndex(d)}`) .attr('r', r) // .attr('r', 0) .attr('fill', patientColor) .attr('stroke', patientStroke) .attr('stroke-width', patientStrokeWidth) .attr('stroke-opacity', 0.75) .attr('transform', circleTransform); const lastIndex = d => Math.ceil(d.values.length / rowNum) * rowNum; // sexG // .append('text') // .classed('num-patients', true) // .attr('transform', (d, i) => { // return `translate(${circleX(d.values[0], lastIndex(d))}, // ${circleY(d.values[0], lastIndex(d)) + 16 * 1.8})`; // }) // .attr('opacity', d => (d.values[0].sex === '調査中' ? 0 : .75)) // .attr('text-anchor', d => (d.values[0].sex === '男性' ? 'end' : 'start')) // .selectAll('tspan') // .data(d => // [ // `${d.rate === Infinity ? '' : d3.format('.2f')(d.rate)}`, // `${d.values.length}人` // ].map( // (e, i) => // `${e}${ // d.key === '女性' && d.values[0].age === 80 // ? i === 0 // ? '（10万人あたり）' // : '（実数）' // : '' // }` // ) // ) // .join('tspan') // .attr('x', (d, i) => `0em`) // .attr('dx', (d, i) => `0em`) // .attr('dy', (d, i) => `${i * 1.2}em`) // .attr('font-size', (d, i) => (i === 0 ? 16 : 12)) // .attr('font-weight', (d, i) => (i === 0 ? 600 : 300)) // .text(d => d); g.call(addAgeLabels); g.selectAll('text.sex') .data(ageSexPatients[0].values) .join('text') .classed('sex', true) .text(d => d.key) .attr('text-anchor', d => (d.key === '男性' ? 'end' : 'start')) .attr('font-family', 'sans-serif') .attr('font-size', '16px') .attr('font-weight', 'bold') .attr('transform', d => d.key === '男性' ? `translate(${sexX(d.key) + sexX.bandwidth()}, ${margin.top})` : `translate(${sexX(d.key)}, ${margin.top})` ); const status = g .append('g') .selectAll('g') .data(statuses.map(d => ({ status: d, statusSort: statusSort(d) }))) .join('g') .attr('class', d => `status-${transitionIndex(d)}`) .attr( 'transform', (d, i) => `translate(${margin.left / 2}, ${margin.top + 40 + i * 20})` ); // .attr('opacity', 0); status .append('circle') .attr('cx', r) .attr('cy', r) .attr('r', r) .attr('fill', patientColor) .attr('stroke', patientStroke) .attr('stroke-width', patientStrokeWidth) .attr('stroke-opacity', 0.75); status .append('text') .text(d => d.status) .attr('font-family', 'sans-serif') .attr('font-size', '12px') .attr('dy', '8px') .attr('transform', `translate(${r * 2 + circleMargin}, 0)`); const texts = [ `集計期間：${d3.timeFormat('%Y/%m/%d')(startDate)} – ${d3.timeFormat( '%Y/%m/%d' )(endDate)} (7日間)`, 'データ', `患者数：大阪府(2020年${updateDate.getMonth() + 1}月${updateDate.getDate()}日更新)`, '　　人口：総務省統計局人口推計(2018年10月)', // '　　正規｜非正規雇用労働者：平成29年就業構造基本調査', // '　　就業者数：総務省統計局労働力調査(2019年平均)', // `府発表${d3.format(',')(patients.length)}人のうち居住地大阪府外${ // cityPatients.find(d => d.key == '大阪府外').values.length // }人を除く`, `作図：SUGIMOTO Tatsuo` ]; g.append('text') .text('大阪府新型コロナウイルス感染確認者の年代性別') .attr('transform', `translate(${margin.left / 2}, ${margin.top / 2})`) .attr('font-family', 'Hiragino Sans') .attr('font-size', '30px') .attr('font-weight', '300') .attr('letter-spacing', '.1em'); g.append('rect') .attr('x', margin.left / 2) .attr('y', margin.top / 2 + 28 + 3 * 18 - 10) .attr('width', 24) .attr('height', 12) .attr('fill', 'hsl(19, 100%, 90%)') .attr('opacity', 0.5); // g.append('rect') // .attr('x', margin.left / 2) // .attr('y', margin.top / 2 + 28 + 3 * 18 - 10) // .attr('width', 12) // .attr('height', 12) // .attr('fill', 'hsl(220, 100%, 80%)') // .attr('opacity', 0.5); // g.append('rect') // .attr('x', margin.left / 2 + 12) // .attr('y', margin.top / 2 + 28 + 3 * 18 - 10) // .attr('width', 12) // .attr('height', 12) // .attr('fill', 'hsl(220, 100%, 90%)') // .attr('opacity', 0.5); const description = g .append('g') .selectAll('text.desc') .data(texts) .join('text') .classed('desc', true) .text(d => d) .attr( 'transform', (d, i) => `translate(${margin.left / 2}, ${margin.top / 2 + 28 + i * 18})` ) .attr('font-family', 'sans-serif') .attr('font-size', '12px') .attr('opacity', 0.8); // for (let i = 0; i < 5; i++) { // sexG // .selectAll(`circle.status-${i}`) // .transition() // .delay((d, j) => 5000 + i * 3000 + j * 10) // .attr('r', r); // g.selectAll(`g.status-${i}`) // .transition() // .delay((d, j) => 5000 + i * 3000 + j * 10) // .attr('opacity', 1); // } return svg.node(); }32:Tc6f,table = { const div = d3.create('div').classed('table', true); const startDate = new Date('2020-08-16'); const endDate = new Date('2020-08-22'); const data = osakaDataOfDateRange(startDate, endDate); const numMunic = 43; const numRow = 3; const group = d3.range(numRow).map(d => ({ title: '市町村', begin: d * Math.ceil(numMunic / numRow), end: (d + 1) * Math.ceil(numMunic / numRow) })); const mData = group.map(g => data .filter( d => new RegExp(`[${g.title}]\$`).test(d.municipality) && !d.islands ) .slice(g.begin, g.end) ); const headdiv = div.append('div').style('margin-bottom', '1em'); // .classed('container', true); headdiv .append('h3') .text('大阪府居住地別新型コロナウイルス感染確認者数') .style('font-size', '26px') .style('font-weight', '300'); const texts = [ `集計期間：${d3.timeFormat('%Y/%m/%d')(startDate)} – ${d3.timeFormat( '%Y/%m/%d' )(endDate)} (7日間)`, `データ：大阪府（2020年${updateDate.getMonth() + 1}月${updateDate.getDate()}日時点）大阪府推計人口（2020年3月）`, `人口比＝10万人あたりの感染者数`, `作表：SUGIMOTO Tatsuo` ]; headdiv .selectAll('div.desc') .data(texts) .join('div') .classed('desc', true) .html(d => d) .style('font-family', 'sans-serif') .style('font-size', '12px'); const container = div.append('div').classed('container', true); const column = container .selectAll('div') .classed('column', true) .data(mData) .join('div'); const table = column.append('table'); const haederRow = table.append('thead').append('tr'); haederRow.append('th').text((d, i) => group[i].title); haederRow.append('th').text('人口比'); haederRow .selectAll('td') .data(['実数', '重症', '死亡']) .join('td') .text(d => d); const tr = table .append('tbody') .selectAll('tr') .data(d => d) .join('tr') .on('mouseover', function() { d3.select(this).style('background-color', '#fff'); }) .on('mouseout', function(d, i) { d3.select(this).style( 'background-color', i % 2 ? 'transparent' : `hsla(15, 20%, 90%, 0.5)` ); }); const spacing = d => d.municipality.length === 2 ? 2 : d.municipality.length === 3 ? 0.5 : 0; tr.append('th') .text(d => d.municipality) .style('letter-spacing', d => `${spacing(d)}em`) .style('margin-right', d => `-${spacing(d) - 0.2}em`) .style('transform', d => d.municipality.length >= 5 ? `scale(0.8, 1)` : `none` ) .style('transform-origin', `left center`); tr.append('td') .classed('num', true) .text(d => d3.format('.2f')(d.rate)); tr.append('td') .classed('num', true) .classed('sub', true) .text(d => `${d3.format('.4')(d.case)}`); tr.append('td') .classed('num', true) .classed('sub', true) .text(d => `${d3.format('.3')(d.danger)}`); tr.append('td') .classed('num', true) .classed('sub', true) .text(d => `${d3.format('.3')(d.death)}`); return div.node(); }33:T4ff,style = html` `34:[{"id":"e4262d55eeee6c4f92be8fc2973b0d1bd08a54e7e8e4167d92294e4fb9214d7ba2077ba68ea52baa6652eeb8f4ce3771abc9e6c449f13803410daa3936b3e7b7","href":"https://static.observableusercontent.com/files/e4262d55eeee6c4f92be8fc2973b0d1bd08a54e7e8e4167d92294e4fb9214d7ba2077ba68ea52baa6652eeb8f4ce3771abc9e6c449f13803410daa3936b3e7b7","name":"osaka-population-2018-10.csv","type":"text/csv","lastModified":1586570882855.189,"size":417},{"id":"d7f7c1cf1e3cf3ed33dc4c260d6a95216742d3304d291f62217140f66badb4d4ccf18c4e30f489e5c177ca8f6b1c7ad6d83768d62fe5302fb76ba1e58bd100c7","href":"https://static.observableusercontent.com/files/d7f7c1cf1e3cf3ed33dc4c260d6a95216742d3304d291f62217140f66badb4d4ccf18c4e30f489e5c177ca8f6b1c7ad6d83768d62fe5302fb76ba1e58bd100c7","name":"osaka20200420.csv","type":"text/csv","lastModified":1587510489933.677,"size":55945},{"id":"c253c27f692109b8819839698e133b6f733f26a828c82df41bf2fc93961ea0225a8a9eab94d3de618a32abe19149d083e0ff8b90668a9c077bea63fd0bd31663","href":"https://static.observableusercontent.com/files/c253c27f692109b8819839698e133b6f733f26a828c82df41bf2fc93961ea0225a8a9eab94d3de618a32abe19149d083e0ff8b90668a9c077bea63fd0bd31663","name":"osaka20200504.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1588773858682.297,"size":71914},{"id":"47641ce5ff87a39e6914a7cfe43cde443bf5f3584d0df1d71e9ef8453ec832423e5ea27a25e572d714b362b40dc9bb4ca17a10343a7ffbc72f744036d6134b41","href":"https://static.observableusercontent.com/files/47641ce5ff87a39e6914a7cfe43cde443bf5f3584d0df1d71e9ef8453ec832423e5ea27a25e572d714b362b40dc9bb4ca17a10343a7ffbc72f744036d6134b41","name":"osaka-population.csv","type":"text/csv","lastModified":1586391791339.396,"size":1139}] 2f:{"title":"Internal page for COVID-19 in Osaka","cells":[{"id":1809,"value":"md`# Internal page for COVID-19 in Osaka\n\nPlease do not share this notebook.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":0,"value":"md`# COVID-19 Patients Table by Ward in Osaka`","pinned":true,"hidden":false,"mode":"ojs"},{"id":1340,"value":"osakaPatients.length","pinned":true,"hidden":false,"mode":"ojs"},{"id":1274,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"},{"id":1508,"value":"updateDate = dates.slice(-1)[0]","pinned":true,"hidden":false,"mode":"ojs"},{"id":1889,"value":"height = 800","pinned":true,"hidden":false,"mode":"ojs"},{"id":1876,"value":"ageY = d3\n .scaleBand()\n .domain(ages)\n .range([margin.top, height - margin.bottom])\n .padding(0.1)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1879,"value":"sexX = d3\n .scaleBand()\n // .domain(ageSexPatients[0].values.map(d => d.key))\n .domain(['男性', '女性'])\n .range([margin.left, width - margin.right])\n .padding(0.15)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1883,"value":"ages = ageSexPatients.map(d => d.key)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1874,"value":"addAgeLabels = g => {\n const label = g\n .selectAll('text.age')\n .data(\n ages.map(d => ({\n key: d,\n num: d.replace(/\\D+/, ''),\n suffix: d.replace(/\\d+/, '')\n }))\n )\n .join('text')\n .classed('age', true)\n .attr('text-anchor', 'middle')\n .attr('font-weight', '600')\n .attr('font-family', `Roboto Condensed`)\n .attr(\n 'transform',\n d => `translate(0, ${ageY(d.key) + ageY.bandwidth() / 2})`\n );\n\n label\n .append('tspan')\n .attr('font-size', '20px')\n .attr('x', `${width / 2}`)\n // .attr('dy', '1.2em')\n .text(d => d.num);\n label\n .append('tspan')\n .attr('font-size', '12px')\n .attr('font-weight', '400')\n .attr('x', `${width / 2}`)\n .attr('dy', '1.2em')\n .text(d => d.suffix);\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1665,"value":"patientColor = d => {\n let color;\n\n return (\n d3\n .scaleOrdinal()\n .domain(statuses)\n // .range(['gray', 'green', 'black', 'lightgray', 'yellow'])(d.症状);\n .range([\n 'hsl(0, 0%, 0%)',\n\n 'hsl(20, 60%, 50%)',\n 'hsl(20, 60%, 70%)',\n\n 'hsl(60, 70%, 40%)',\n 'hsl(60, 70%, 70%)',\n\n 'hsl(160, 80%, 50%)',\n // 'hsl(160, 80%, 70%)',\n\n 'hsl(0, 0%, 80%)',\n 'hsl(0, 0%, 80%)',\n 'hsl(0, 0%, 80%)',\n\n 'hsl(0, 0%, 80%)',\n 'hsl(0, 0%, 100%)',\n 'hsl(0, 0%, 100%)'\n ])(d.status)\n );\n // 0: \"死亡\"\n\n // 1: \"入院中\"\n // 2: \"入院調整中\"\n\n // 3: \"宿泊療養\"\n // 4: \"宿泊療養調整中\"\n\n // 5: \"自宅療養\"\n // 6: \"自宅療養調整中\"\n\n // 7: \"退院\"\n // 8: \"宿泊療養解除\"\n // 9: \"自宅療養解除\"\n // 10: \"確認中\"\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1724,"value":"transitionIndex = d => {\n let r = 0;\n switch (d.statusSort) {\n case 0:\n r = 0;\n break;\n case 1:\n case 2:\n r = 1;\n break;\n case 3:\n case 4:\n r = 2;\n break;\n case 5:\n case 6:\n r = 3;\n break;\n case 7:\n case 8:\n case 9:\n case 10:\n r = 4;\n break;\n }\n return r;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1294,"value":"_patientColor = d => {\n let color;\n\n return (\n d3\n .scaleOrdinal()\n .domain(symptoms)\n // .range(['gray', 'green', 'black', 'lightgray', 'yellow'])(d.症状);\n .range([\n 'hsl(0, 100%, 10%)',\n 'hsl(20, 60%, 30%)',\n 'hsl(40, 60%, 60%)',\n 'hsl(50, 90%, 60%)',\n 'hsl(0, 100%, 100%)',\n 'hsl(0, 0%, 90%)'\n ])(d.symptom)\n );\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1396,"value":"d3\n .nest()\n .key(d => d.sex)\n .entries(osakaPatients)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1669,"value":"statuses = d3\n .nest()\n .key(d => d.status)\n .entries(osakaPatients)\n .sort((a, b) => a.values[0].statusSort - b.values[0].statusSort)\n .map(d => d.key)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1299,"value":"symptoms = d3\n .nest()\n .key(d => d.symptom)\n .entries(osakaPatients)\n .map(d => d.key)\n// .sort((a, b) => d3.ascending(a, b))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1342,"value":"$32","pinned":true,"hidden":false,"mode":"ojs"},{"id":1360,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":1175,"value":"circleColor = d =>\n d.left ? 'white' : d.sex === '男性' ? 'steelblue' : 'maroon'","pinned":true,"hidden":false,"mode":"ojs"},{"id":185,"value":"md`### データの準備`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1551,"value":"dates = d3\n .nest()\n .key(d => d.date)\n .entries(osakaPatients)\n .map(d => new Date(d.key))\n .sort((a, b) => a.getTime() - b.getTime())","pinned":true,"hidden":false,"mode":"ojs"},{"id":1616,"value":"__csv__osakaPatients = d3\n .csvParse(await FileAttachment('osaka20200420.csv').text(), d3.autoType)\n .filter(d => d.municipality !== '大阪府外')\n .map(d => ({\n sex: d.性別,\n age:\n d.年代 === 90\n ? 80\n : d.年代 === '未就学児'\n ? 0\n : d.年代 === '就学児'\n ? 6\n : d.年代,\n symptom: d.症状 === '―' ? '―（退院?）' : d.症状,\n symptomSort:\n d.症状 === '死亡'\n ? 0\n : d.症状 === '重症'\n ? 1\n : d.症状 === '軽症'\n ? 2\n : d.症状 === '無症状'\n ? 3\n : d.症状 === '―（退院?）'\n ? 4\n : 99,\n municipality: d.居住地,\n // date: new Date(d.報道提供日),\n ...d\n }))\n .sort((a, b) => a.symptomSort - b.symptomSort)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1635,"value":"_patients = xlsx.utils.sheet_to_json(sheet)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1727,"value":"statusSort = status =>\n status === '死亡退院'\n ? 0\n : status === '入院中'\n ? 1\n : status === '入院調整中'\n ? 2\n : status === '宿泊療養'\n ? 3\n : status === '宿泊療養調整中'\n ? 4\n : status === '自宅療養'\n ? 5\n : status === '自宅療養調整中'\n ? 6\n : status === '退院'\n ? 7\n : status === '宿泊療養解除'\n ? 8\n : status === '自宅療養解除'\n ? 9\n : status === '確認中'\n ? 10\n : status === '府外'\n ? 11\n : 99","pinned":true,"hidden":false,"mode":"ojs"},{"id":1468,"value":"osakaPatients = patients\n .filter(d => d.居住地 !== '大阪府外')\n .filter(d => d.退院 !== '府外')\n // .filter(d => d.年代 !== '調査中')\n .map(d => ({\n sex: d.性別,\n age:\n d.年代 == 90 || d.年代 == 100\n ? 80\n : d.年代 === '未就学児'\n ? 0\n : d.年代 === '就学児'\n ? 6\n : d.年代,\n symptom: d.症状 === '―' ? '―（退院?）' : d.症状,\n symptomSort:\n d.症状 === '死亡'\n ? 0\n : d.症状 === '重症'\n ? 1\n : d.症状 === '軽症'\n ? 2\n : d.症状 === '無症状'\n ? 3\n : d.症状 === '―（退院?）'\n ? 4\n : 99,\n status: d.退院,\n statusSort: statusSort(d.退院),\n municipality: d.居住地,\n date: new Date(d.報道提供日),\n ...d\n }))\n .sort((a, b) => a.symptomSort - b.symptomSort)\n .sort((a, b) => a.statusSort - b.statusSort)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1475,"value":"sheet['!ref']","pinned":true,"hidden":false,"mode":"ojs"},{"id":1461,"value":"sheet = workbook.Sheets[workbook.SheetNames[0]]","pinned":false,"hidden":false,"mode":"ojs"},{"id":1777,"value":"patients = {\n function ec(r, c) {\n return xlsx.utils.encode_cell({ r: r, c: c });\n }\n\n function delete_row(ws, row_index) {\n var variable = xlsx.utils.decode_range(ws[\"!ref\"]);\n for (var R = row_index; R < variable.e.r; ++R) {\n for (var C = variable.s.c; C <= variable.e.c; ++C) {\n ws[ec(R, C)] = ws[ec(R + 1, C)];\n }\n }\n variable.e.r--;\n ws['!ref'] = xlsx.utils.encode_range(variable.s, variable.e);\n }\n var worksheet = wb.Sheets[wb.SheetNames[1]];\n delete_row(worksheet, 0);\n return xlsx.utils.sheet_to_json(worksheet);\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1845,"value":"patientsJSON = (await d3.json(\n 'https://raw.githubusercontent.com/codeforosaka/covid19/development/data/data.json',\n d3.autoType\n)).patients.data","pinned":true,"hidden":false,"mode":"ojs"},{"id":1857,"value":"xlsx.read(data, {\n type: \"array\",\n cellDates: true,\n cellNF: false,\n cellText: false\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1851,"value":"data = new Uint8Array(\n await d3.buffer(\n \"https://raw.githubusercontent.com/codeforosaka/covid19/development/data/patients_and_inspections.xlsx\"\n )\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1739,"value":"wb = loadExcelFile(\n \"https://raw.githubusercontent.com/codeforosaka/covid19/development/data/patients_and_inspections.xlsx\"\n // 'https://github.com/codeforosaka/covid19/raw/development/data/patients_and_inspections.xlsx'\n // 'https://github.com/codeforosaka/covid19/blob/development/data/patients_and_inspections.xlsx?raw=true'\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1770,"value":"function loadExcelFile(url) {\n return new Promise((resolve, reject) => {\n var req = new window.XMLHttpRequest();\n req.open(\"GET\", url, true);\n req.responseType = \"arraybuffer\";\n\n req.onload = function(e) {\n var data = new Uint8Array(req.response);\n var workbook = xlsx.read(data, {\n type: \"array\",\n cellDates: true,\n cellNF: false,\n cellText: false\n });\n resolve(workbook);\n // XLSX.utils.sheet_to_json(workbook.Sheets[workbook.SheetNames[1]])\n // );\n };\n req.send();\n });\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1576,"value":"array = new Uint8Array(await FileAttachment(\"osaka20200504.xlsx\").arrayBuffer())\n// array = new Uint8Array(\n// await FileAttachment(\"patients_and_inspections(1)@1.xlsx\").arrayBuffer()\n// )","pinned":true,"hidden":false,"mode":"ojs"},{"id":1489,"value":"workbook = xlsx.read(array, {\n // type: 'buffer'\n type: 'array',\n cellDates: true,\n cellNF: false,\n cellText: false\n})\n// workbook = _xlsx.read(\n// await FileAttachment(\"osaka20200415.xlsx\").arrayBuffer(),\n// {\n// type: 'buffer'\n// }\n// )","pinned":true,"hidden":false,"mode":"ojs"},{"id":1903,"value":"ageSexPatientsOfDateRange(new Date('2020-08-09'), new Date('2020-08-15'))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1898,"value":"ageSexPatientsOfDateRange = (startDate, endDate) => {\n return (\n d3\n .nest()\n .key(d => d.age)\n .key(d => d.sex)\n // .entries(testdata)\n .entries(\n osakaPatients.filter(\n d =>\n d.年代 !== '調査中' &&\n d.date.getTime() >= startDate.getTime() &&\n d.date.getTime() <= endDate.getTime()\n )\n )\n .sort((a, b) => +b.key - +a.key)\n .map(d => ({\n key:\n d.key === '0'\n ? '未就学児'\n : d.key === '6'\n ? '就学児'\n : d.key === '80'\n ? `${d.key}代以上`\n : `${d.key}代`,\n values: d.values.map(sex => ({\n population: population(d.key, sex.key),\n rate: (sex.values.length / population(d.key, sex.key)) * 100000,\n ...sex\n }))\n }))\n );\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1260,"value":"ageSexPatients = d3\n .nest()\n .key(d => d.age)\n .key(d => d.sex)\n // .entries(osakaPatients.filter(d => d.居住地 !== '大阪府外'))\n .entries(osakaPatients.filter(d => d.年代 !== '調査中'))\n .sort((a, b) => +b.key - +a.key)\n .map(d => ({\n key:\n d.key === '0'\n ? '未就学児'\n : d.key === '6'\n ? '就学児'\n : d.key === '80'\n ? `${d.key}代以上`\n : `${d.key}代`,\n values: d.values.map(sex => ({\n population: population(d.key, sex.key),\n rate: (sex.values.length / population(d.key, sex.key)) * 100000,\n ...sex\n }))\n }))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1839,"value":"agePatients = d3\n .nest()\n .key(d => d.age)\n // .key(d => d.sex)\n // .entries(osakaPatients.filter(d => d.居住地 !== '大阪府外'))\n .entries(osakaPatients.filter(d => d.年代 !== '調査中'))\n .sort((a, b) => +b.key - +a.key)\n .map(d => ({\n key:\n d.key === '0'\n ? '未就学児'\n : d.key === '6'\n ? '就学児'\n : d.key === '80'\n ? `${d.key}代以上`\n : `${d.key}代`,\n values: d.values\n }))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1349,"value":"osakaPopulation = d3.csvParse(\n await FileAttachment(\"osaka-population.csv\").text(),\n d3.autoType\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1957,"value":"osakaPatientsOfDateRange(new Date('2020-08-09'), new Date('2020-08-15'))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1954,"value":"osakaPatientsOfDateRange = (startDate, endDate) =>\n osakaPatients.filter(\n d =>\n d.date.getTime() >= startDate.getTime() &&\n d.date.getTime() <= endDate.getTime()\n )","pinned":true,"hidden":false,"mode":"ojs"},{"id":1945,"value":"osakaDataOfDateRange = (startDate, endDate) => {\n const data = osakaPatients.filter(\n d =>\n d.date.getTime() >= startDate.getTime() &&\n d.date.getTime() <= endDate.getTime()\n );\n\n return osakaPopulation\n .filter(d => d.municipality !== 'total')\n .map(d => ({\n case: data.filter(e => e.居住地 === d.municipality).length,\n death: data.filter(\n e => e.居住地 === d.municipality && e.symptom === '死亡'\n ).length,\n danger: data.filter(\n e => e.居住地 === d.municipality && e.symptom === '重症'\n ).length,\n ...d\n }))\n .map(d => ({\n rate: (d.case / d.population) * 100000,\n ...d\n }))\n .sort((a, b) => b.rate - a.rate);\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1366,"value":"osakaData = osakaPopulation\n .filter(d => d.municipality !== 'total')\n .map(d => ({\n case: osakaPatients.filter(e => e.居住地 === d.municipality).length,\n death: osakaPatients.filter(\n e => e.居住地 === d.municipality && e.symptom === '死亡'\n ).length,\n danger: osakaPatients.filter(\n e => e.居住地 === d.municipality && e.symptom === '重症'\n ).length,\n ...d\n }))\n .map(d => ({\n rate: (d.case / d.population) * 100000,\n ...d\n }))\n .sort((a, b) => b.rate - a.rate)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1288,"value":"cityPatients = d3\n .nest()\n .key(d => d.居住地)\n .entries(osakaPatients)\n .map(d => ({\n municipality: d.key,\n case: d.values.length,\n population: osakaPopulation.find(e => e.municipality === d.key)\n ? osakaPopulation.find(e => e.municipality === d.key).population\n : 0\n }))\n .map(d => ({\n rate: (d.case / d.population) * 100000,\n ...d\n }))","pinned":true,"hidden":false,"mode":"ojs"},{"id":715,"value":"swap = (arr, a, b) => {\n const tmp = arr[a];\n arr[a] = arr[b];\n arr[b] = tmp;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1402,"value":"population = (age, sex) => {\n if (age === '0' || age === '6' || age === '90' || age === '100') {\n return 0;\n }\n\n const startAge = age === '10歳未満' ? 0 : +age.substr(0, 2);\n\n return (\n d3.sum(\n ageData.filter(d => d.age >= startAge && d.age < startAge + 10),\n d => d[sex]\n ) * 1000\n );\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":584,"value":"ageData = d3.csvParse(\n await FileAttachment(\"osaka-population-2018-10.csv\").text(),\n d3.autoType\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":652,"value":"margin = ({\n top: 140,\n right: 60,\n bottom: 30,\n left: 60\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1601,"value":"md`### Libs`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1452,"value":"xlsx = require('https://bundle.run/xlsx@0.14.1')\n// xlsx = require('https://bundle.run/xlsx@0.15.6')\n// xlsx = require('https://bundle.run/xlsx')","pinned":false,"hidden":false,"mode":"ojs"},{"id":1562,"value":"_xlsx = require('xlsx')","pinned":false,"hidden":false,"mode":"ojs"},{"id":1456,"value":"import { load } from \"@sugi2000/fetcher\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":216,"value":"import { legend } from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"d3 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}