2b:null 2c:["$","title",null,{"children":"Story 1 - DEURU | anndawn | Observable"}] 31:Ta98,line2_update={ const wrapper = html`

Number of Russians and Ukrainians in Germany

In 2022, more than 1 million refugees from Ukraine entered Germany.

`; const container = wrapper.querySelector('div'); const logoWidth = 150; // Adjust based on how much space you want for the data source const logoHeight = (130 / 910) * logoWidth; const data_source = html`

Data Source: Statistisches Bundesamt (Destatis); The Commissioner of the Federal Government for Migration, Refugees and Integration

`; wrapper.appendChild(data_source); yield wrapper; const line = new G2Plot.Line(container, { title: { visible: true, }, height: 340, data: data, padding: 'auto', margin: 'auto', appendPadding:10, limitInPlot:false, xField: 'Year', yField: "Population", seriesField: 'Country', yAxis:{ title: { text: 'Population in Germany', style: { fontSize: 12, }, }, label: { formatter: (text) => { const value = parseInt(text, 10); if (value >= 1000000) { return `${value / 1000000} million`; } else{ const value = parseInt(text, 10); return new Intl.NumberFormat().format(value); } return text; }, } }, xAxis: { type: 'cat', tickInterval: 1, }, point: { // Add this configuration visible: true }, tooltip: { customContent: (title, items) => { let content = `'; return content; } }, smooth: true, renderer:'svg' }); line.render(); } 32:Tb7d,bar={ const wrapper = html`

Criminal cases in Berlin with a Ukrainian victim since February 2022

Berlin registered 1,237 cases with at least one Ukrainian victim and a suspect identified.The time period for the police records is 24.02.2022 - 28.02.2023

Data Source: DWH FI. Statistic was received 7th of March, 2023

`; wrapper.appendChild(data_source); yield wrapper; const bar = new G2Plot.Bar(container, { title: { visible: true, }, height: 340, data: offence_data, padding: 'auto', margin: 'auto', appendPadding:10, limitInPlot:false, xField: 'Number of the cases', yField: "Offense", color: (Offense) => { // Check if the category is 'Others' and return 'lightgrey', otherwise return a default color return Offense.Offense === 'Other offences' ? 'lightgrey' : null; }, yAxis:{ title: { text: 'Population in Germany', style: { fontSize: 12, }, }, label: { formatter: (text) => { const value = parseInt(text, 10); if (value >= 1000000) { return `${value / 1000000} million`; } return text; }, } }, yAxis: { type: 'cat', label: { formatter: (text) => { // Define the maximum number of characters per line const MAX_CHARACTERS_PER_LINE = 40; // Split words into an array const words = text.split(' '); let line = ''; let lines = []; // Build lines array for (let i = 0; i < words.length; i++) { if ((line + words[i]).length > MAX_CHARACTERS_PER_LINE) { lines.push(line); line = ''; } line += `${words[i]} `; if (i === words.length - 1) { lines.push(line); } } return lines.join('\n'); }, }, }, smooth: true, renderer:'svg' }); bar.render(); }33:T9fd,line={ const wrapper = html`

Trend of complaints received for platforms from Jan 2018-Jun 2023

Complaints related to Sections 130 (Incitement to hatred) & 166 (Insulting denominations, religious societies and ideological associations)

Data Source: NetzDG Transparency Reports published by each respective social media platform

`; wrapper.appendChild(data_source); yield wrapper; // const colorMap = { // 'Total complaints': 'rgba(120, 120, 120, 1)', // grey with full opacity // 'Deleted or blocked': 'rgba(255, 0, 0, 0.5)' // red with half opacity // }; const line = new G2Plot.Line(container, { data:trend_data, xField: 'period', yField: 'count', seriesField: 'platform', // color: (datum) => { // return colorMap[datum.category] || '#5B8FF9'; // default color if the category is not found in the colorMap // }, padding: 'auto', margin: 'auto', appendPadding:10, limitInPlot:false, yAxis:{ title: { text: 'Number of complaints', style: { fontSize: 12, }, }, }, tooltip:{ customContent: (title, items) => { let content = `'; return content; } }, smooth: true, renderer:'svg' }); line.render(); }34:T1570,column2={ const wrapper = html`

NetzDG complaints filed to major social media platforms operating in Germany and deleted content from January 2018 to June 2023

This chart shows the number of user complaints under Sections 130 (Incitement to hatred) and 166 (Insulting denominations, religious societies and ideological associations).

Data Source: NetzDG Transparency Reports published by each respective social media platform

Note: Discrepancies and variations in the number of complaints resulted in the deletion or blocking of content and to actual pieces of content that were deleted or blocked exist due to each platform’s differences in reporting standards or updates in the data post-publication.

`; const container = wrapper.querySelector('div'); yield wrapper; const colorMap = { 'Total complaints': 'rgba(120, 120, 120, 1)', // grey with full opacity 'Number of complaints resulting in the deletion or blocking of content': 'rgba(255, 0, 0, 0.5)' , 'Deleted or blocked pieces of content': '#720026' , }; const column = new G2Plot.Column(container, { data:netz, isGroup: true, xField: 'platform', yField: 'cases', seriesField: 'category', color: (datum) => { return colorMap[datum.category] || '#5B8FF9'; // default color if the category is not found in the colorMap }, // Add additional conditions here if you have more categories and want to color them specifically // dodgePadding: 2, padding: 'auto', margin: 'auto', appendPadding:10, limitInPlot:false, dodgePadding: -2, legend:{ flipPage:false, itemName: { style: { textOverflow: 'unset', // ensure text is not truncated overflow: 'visible', // display overflow content whiteSpace: 'normal', // wrap text as needed }, }, maxItemWidth: 400, }, label: { position: 'middle', // 'top', 'bottom', 'middle', style: { fill: '#000', fontSize: 8, // specify the font size you want for the labels }, content: (originData) => { let value = originData.cases; // replace yourFieldName with the field you're plotting if (value< 40000 ){return null} if (value > 800 && value < 1000000) { return `${(value / 1000).toFixed(0)}K`; // Convert to K for thousands } else if (value >= 1000000) { return `${(value / 1000000).toFixed(1)}M`; // Convert to M for millions } return value.toString(); // return the value as is if it doesn't require formatting }, layout: [ // ...other layout configurations { type: 'interval-adjust-position' }, { type: 'interval-hide-overlap' }, { type: 'adjust-color' }, ], }, yAxis:{ title: { text: 'Number of complaints', style: { fontSize: 12, }, }, label: { formatter: (text) => { const value = parseInt(text, 10); if (value >= 1000000) { return `${value / 1000000} million`; } else{ const value = parseInt(text, 10); return new Intl.NumberFormat().format(value); } return text; }, } }, tooltip: { customContent: (title, items) => { let content = `'; return content; } }, smooth: true, renderer:'svg' // 使用 annotation （图形标注）来展示：总数的 label // annotations, }); column.render(); }35:T15ec,column3={ const wrapper = html`

NetzDG complaints filed to major social media platforms operating in Germany and deleted content from January 2018 to June 2023

This chart shows the number of user complaints under Sections 130 (Incitement to hatred) and 166 (Insulting denominations, religious societies and ideological associations).

Data Source: NetzDG Transparency Reports published by each respective social media platform

`; const container = wrapper.querySelector('div'); yield wrapper; const colorMap = { 'Total complaints': '#D3D3D3', // soft grey 'Number of complaints resulting in the deletion or blocking of content': '#E63946' , 'Deleted or blocked pieces of content': '#FF9241', }; const column = new G2Plot.Column(container, { data:netz, isGroup: true, xField: 'platform', yField: 'cases', seriesField: 'category', color: (datum) => { return colorMap[datum.category] || '#5B8FF9'; // default color if the category is not found in the colorMap }, // Add additional conditions here if you have more categories and want to color them specifically // dodgePadding: 2, padding: 'auto', margin: 'auto', appendPadding:10, limitInPlot:true, dodgePadding: -2, legend:{ flipPage:false, itemName: { style: { textOverflow: 'unset', // ensure text is not truncated overflow: 'visible', // display overflow content whiteSpace: 'normal', // wrap text as needed }, }, maxItemWidth: 400, }, label: { position: 'middle', // 'top', 'bottom', 'middle', style: { fill: '#000', fontSize: 8, // specify the font size you want for the labels }, content: (originData) => { let value = originData.cases; // replace yourFieldName with the field you're plotting if (value< 40000 ){return null} if (value > 800 && value < 1000000) { return `${(value / 1000).toFixed(0)}K`; // Convert to K for thousands } else if (value >= 1000000) { return `${(value / 1000000).toFixed(1)}M`; // Convert to M for millions } return value.toString(); // return the value as is if it doesn't require formatting }, layout: [ // ...other layout configurations { type: 'interval-adjust-position' }, { type: 'interval-hide-overlap' }, { type: 'adjust-color' }, ], }, yAxis:{ title: { text: 'Number of complaints', style: { fontSize: 12, }, }, label: { formatter: (text) => { const value = parseInt(text, 10); if (value >= 1000000) { return `${value / 1000000} million`; } else{ const value = parseInt(text, 10); return new Intl.NumberFormat().format(value); } return text; }, } }, tooltip: { customContent: (title, items) => { let content = `'; return content; } }, smooth: true, renderer:'svg' // 使用 annotation （图形标注）来展示：总数的 label // annotations, }); column.render(); }36:[{"id":"369f17c1c1bce65c2d0d22f8ca5e341be554aadff4b7dc04c422b4b927a342f018eaebdc97b7e2f7d92f1b1f03f6896c707343fd1919e1e9046232549ddb7544","href":"https://static.observableusercontent.com/files/369f17c1c1bce65c2d0d22f8ca5e341be554aadff4b7dc04c422b4b927a342f018eaebdc97b7e2f7d92f1b1f03f6896c707343fd1919e1e9046232549ddb7544","name":"CCIJ-image-credit.svg","type":"image/svg+xml","lastModified":1695834045524.035,"size":34683},{"id":"5027d984369741dfa2fc5d09c620e7716003ea9c9f0f416fa6e5515afa7b4b86ebfe8c0c33a7a033e94126138da15d4321b549d7ccdfafb8278368fc8a5f7b2b","href":"https://static.observableusercontent.com/files/5027d984369741dfa2fc5d09c620e7716003ea9c9f0f416fa6e5515afa7b4b86ebfe8c0c33a7a033e94126138da15d4321b549d7ccdfafb8278368fc8a5f7b2b","name":"refugee.csv","type":"text/csv","lastModified":1695834390352.296,"size":866},{"id":"c44507db328bac37cdb8f3e167d30f9f933b90a83a9439e1cfcefcb4ea76c6d52dd984d9abfa9ba826d0c6b800582e87570956d8f5c4825ee857fc717e0ad721","href":"https://static.observableusercontent.com/files/c44507db328bac37cdb8f3e167d30f9f933b90a83a9439e1cfcefcb4ea76c6d52dd984d9abfa9ba826d0c6b800582e87570956d8f5c4825ee857fc717e0ad721","name":"refugee - Foreigners in Germany.csv","type":"text/csv","lastModified":1695901318718.996,"size":492},{"id":"79b0c5581460934e3102a70dd463f1e4f9a70b770a524cd66c1d31a48f7c5669c20fab62ad1b4bd06b35520bae86f910ea91881ac96e58d8787e0b8718c22169","href":"https://static.observableusercontent.com/files/79b0c5581460934e3102a70dd463f1e4f9a70b770a524cd66c1d31a48f7c5669c20fab62ad1b4bd06b35520bae86f910ea91881ac96e58d8787e0b8718c22169","name":"refugee - Foreigners in Germany@1.csv","type":"text/csv","lastModified":1695901547535.797,"size":512},{"id":"4ff9742f86692e2f3a6a36cf16dcacba226494e9e01381e9126115f0402b055ad41f950487727f8b852ede5d35253ef8094ac3faac8e0836577fb68b2e6c6e87","href":"https://static.observableusercontent.com/files/4ff9742f86692e2f3a6a36cf16dcacba226494e9e01381e9126115f0402b055ad41f950487727f8b852ede5d35253ef8094ac3faac8e0836577fb68b2e6c6e87","name":"offences.csv","type":"text/csv","lastModified":1695916990010.729,"size":315},{"id":"b4636fc6adb8f0363e20ada9d79e5e0d007aac278adeef4479b38d7b05837370fd366e44e5b95c886c0bb96e1a3e6b85279e0c4f2dcfb488ff73e1cc88f9ecf7","href":"https://static.observableusercontent.com/files/b4636fc6adb8f0363e20ada9d79e5e0d007aac278adeef4479b38d7b05837370fd366e44e5b95c886c0bb96e1a3e6b85279e0c4f2dcfb488ff73e1cc88f9ecf7","name":"The following overview lists the 1,237 cases sorted by offense - Calculations.csv","type":"text/csv","lastModified":1695917409432.354,"size":313},{"id":"30bd95e2deda494f120fa7446b929ea24b5fe8e9dbb02c85a9d47a2edb8a49b8821f53324bbeb65bea7e4880c18c773a99b0d2fc6f67ca24c8d84e361301a446","href":"https://static.observableusercontent.com/files/30bd95e2deda494f120fa7446b929ea24b5fe8e9dbb02c85a9d47a2edb8a49b8821f53324bbeb65bea7e4880c18c773a99b0d2fc6f67ca24c8d84e361301a446","name":"unpivoted_transparency_report_numbers (1).csv","type":"text/csv","lastModified":1698418485591.243,"size":1765},{"id":"3fb8c841736cd20efbb9ecb5a0ed39f44cbbac5ec6a85ab0982082496b600dfe9336e799ca89661ab2d2395b9fbc34deffb65b01b32d4e891588ee1a3d366ca5","href":"https://static.observableusercontent.com/files/3fb8c841736cd20efbb9ecb5a0ed39f44cbbac5ec6a85ab0982082496b600dfe9336e799ca89661ab2d2395b9fbc34deffb65b01b32d4e891588ee1a3d366ca5","name":"line - unpivoted_transparency_report_numbers (2).csv","type":"text/csv","lastModified":1698418807460.423,"size":1536},{"id":"a0152d9ecbb4b196f9376299b7d61596d047bd9edd57d7341ae56c632d5e8788264fb30a7dce14e70f36800db232d069acd734ebb4fbc2ed46c9cf65c715e6b0","href":"https://static.observableusercontent.com/files/a0152d9ecbb4b196f9376299b7d61596d047bd9edd57d7341ae56c632d5e8788264fb30a7dce14e70f36800db232d069acd734ebb4fbc2ed46c9cf65c715e6b0","name":"line - netz.csv","type":"text/csv","lastModified":1698419344484.576,"size":666},{"id":"d295ee44b43ee8645bb5671f6b78d146f8c9a27a933014b35e9fd157f98c3a06cf279a73c40eb25c0ec4d8e0b9f56f80f209893e7bdffc46bcaa96b43ff29a59","href":"https://static.observableusercontent.com/files/d295ee44b43ee8645bb5671f6b78d146f8c9a27a933014b35e9fd157f98c3a06cf279a73c40eb25c0ec4d8e0b9f56f80f209893e7bdffc46bcaa96b43ff29a59","name":"data_transparency.csv","type":"text/csv","lastModified":1697732681615.242,"size":460},{"id":"c9a81f067179a6def9ff6235ce094a2eccd54f66c02df980f607ab0fcb25968846a7761a0cb51a49bd807282fe7ddd5752ca13932523c9a6bf91b7de57c49bbf","href":"https://static.observableusercontent.com/files/c9a81f067179a6def9ff6235ce094a2eccd54f66c02df980f607ab0fcb25968846a7761a0cb51a49bd807282fe7ddd5752ca13932523c9a6bf91b7de57c49bbf","name":"NetzDG transparency report DATA - Sheet3.csv","type":"text/csv","lastModified":1697732764622.857,"size":426},{"id":"32fa356d84960c902bc5f32f75720c7764b00250bcc085937aa42b682741f5e2257a90469c62e540fc752d51133ee2648b68fabcd9abd7ddca2cbde7fecfc97c","href":"https://static.observableusercontent.com/files/32fa356d84960c902bc5f32f75720c7764b00250bcc085937aa42b682741f5e2257a90469c62e540fc752d51133ee2648b68fabcd9abd7ddca2cbde7fecfc97c","name":"unpivoted_transparency_report.csv","type":"text/csv","lastModified":1697795398294.658,"size":1608},{"id":"3a4bfd1188ba25b032603dc3ee4af88b9d5c5af49d7da7adf64ff56c2faab0df382580842e81d803d8257d66dd1e9bae5a6944a56dfa236541b42564807cf957","href":"https://static.observableusercontent.com/files/3a4bfd1188ba25b032603dc3ee4af88b9d5c5af49d7da7adf64ff56c2faab0df382580842e81d803d8257d66dd1e9bae5a6944a56dfa236541b42564807cf957","name":"unpivoted_transparency_report_numbers.csv","type":"text/csv","lastModified":1697795682115.193,"size":1576},{"id":"bcb97b5103e20d93a90c2bc6bb2688f2640fc8fbf607b2e7c304fbf7628742c483a3e204f56021bc498dc21e243b5c7012b5658aabe7570ad4aa3dd9013420a0","href":"https://static.observableusercontent.com/files/bcb97b5103e20d93a90c2bc6bb2688f2640fc8fbf607b2e7c304fbf7628742c483a3e204f56021bc498dc21e243b5c7012b5658aabe7570ad4aa3dd9013420a0","name":"Netz.csv","type":"text/csv","lastModified":1697798498396.688,"size":714},{"id":"51d6ad2ac002ea0235e39d42ef2ef0f4c2778cb6dc53e972e757c0071b552b1040aa63bdd6e8e8e2d245094a2e2d0ea1aab7f436abcb286e64e18d1cdc50de12","href":"https://static.observableusercontent.com/files/51d6ad2ac002ea0235e39d42ef2ef0f4c2778cb6dc53e972e757c0071b552b1040aa63bdd6e8e8e2d245094a2e2d0ea1aab7f436abcb286e64e18d1cdc50de12","name":"Netz@1.csv","type":"text/csv","lastModified":1697798755200.458,"size":724}] 2f:{"id":"a4bcd29f0ff7c78f","slug":null,"title":"Story 1 - DEURU","thumbnail":"ebf5ed9c0dde208c3a0c5eeb69e4ad4e17c2121c8e88a62bf52f5fa8f982c55b","access_level":"public","create_time":"$D2023-09-27T17:00:45.524Z","update_time":"$D2023-10-27T16:21:48.510Z","view_time":null,"first_public_time":"$D2023-09-27T17:00:45.524Z","has_unpublished_edits":null,"fork":{"id":"61dd4488ce6f4805","slug":null,"title":"lake","owner":{"id":"08b25cc9d2cc09a6","login":"anndawn","name":""}},"stars":0,"starred":false,"owner":{"type":"team","id":"08b25cc9d2cc09a6","login":"anndawn","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a9bef462081f7a77e161e2b21c48a5ea6a7153836b0db2eb8a565396dcfc57c5","tier":"starter_2024"},"version":483,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"b0fc265f2fad2840","login":"anndawn","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a9bef462081f7a77e161e2b21c48a5ea6a7153836b0db2eb8a565396dcfc57c5","tier":null}],"members":[{"type":"individual","id":"b0fc265f2fad2840","login":"anndawn","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a9bef462081f7a77e161e2b21c48a5ea6a7153836b0db2eb8a565396dcfc57c5","tier":null,"role":"editor"},{"type":"individual","id":"53a6e142a54532c2","login":"jillian-dudziak","name":"Jillian Dudziak","avatar_url":"https://avatars-next.observableusercontent.com/f51c95d8b7aec9528f827e5b97159d84fddad35857a7a04d09829f4df770bf71","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":null,"type":"notebook","body":{"title":"Story 1 - DEURU","cells":[{"id":0,"value":"# Story 1 - DEURU\n ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":6,"value":"G2Plot = require(\"@antv/g2plot\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":139,"value":"refugee_data=FileAttachment(\"refugee - Foreigners in Germany@1.csv\").csv({typed:true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"// Sort lake_data by 'Year' in ascending order\ndata=refugee_data.sort((a, b) => a.Year - b.Year)\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"bar_width=700","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":414,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":197,"value":"Plot.plot({\n marks: [\n Plot.auto(null, {})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":208,"value":"offence_data=FileAttachment(\"The following overview lists the 1,237 cases sorted by offense - Calculations.csv\").csv({typed:true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":213,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":243,"value":"transparency_data=FileAttachment(\"NetzDG transparency report DATA - Sheet3.csv\").csv({typed:true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":254,"value":"groupedData = transparency_data.reduce((acc, curr) => {\n if (!acc[curr.platform]) {\n acc[curr.platform] = [];\n }\n acc[curr.platform].push(curr);\n return acc;\n}, {});\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":316,"value":"trend_data=FileAttachment(\"line - unpivoted_transparency_report_numbers (2).csv\").csv({typed:true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":327,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":346,"value":"netz=FileAttachment(\"line - netz.csv\").csv({typed:true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":348,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":445,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":118,"value":"ccijImageCredit = FileAttachment(\"CCIJ-image-credit.svg\").image()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1","titling":"auto"}} 30:"$2f:body"