25:["$","title",null,{"children":"Российские школьные стрелки. Анализ данных | Ксюша Хабибулина | Observable"}] 49:T74a,viewof russia_map = { const selection = vl .selectSingle() .on('mouseover') .clear("none") .nearest(true); const ru_land = vl.markGeoshape({stroke: 'black', strokeWidth:1}) .width(800) .height(600) .data(russia.features) .encode( vl.color().value("#F0FFF0") ); const formatYear = d3.timeFormat("%Y"); const ru_p = vl.markPoint() .data(data) .encode( vl.longitude().fieldQ("lon"), vl.latitude().fieldQ("lat"), vl.tooltip([{field: "date", title: "Дата"}, {field: "name_c", title: "Город"}, {field: "name", title: "ФИО"}, {field: "age", title: "Возраст"}, {field: "death", title: "Убиты"}, {field: "inj", title: "Ранены"}, {field: "name", title: "ФИО"}]), vl.color().value("#8B0000"), vl.size().fieldQ('t_i').scale({range: [10, 1000]}) ); const ru_c = vl.markCircle() .data(data) .select(selection) .encode( vl.longitude().fieldQ("lon"), vl.latitude().fieldQ("lat"), vl.color().value("#CD5C5C").if(selection , {value: "#000000"}), vl.size().fieldQ('t_i').scale({range: [10, 1000]}).legend({title: "Пострадавшие (с убитыми)"}) ); // const t = vl.markText({dx:-15, dy:15, stroke: 'grey', strokeWidth:0.5, fill: 'grey', fontSize: 18}) // .data(data) // .encode( // vl.longitude().fieldQ("lon"), // vl.latitude().fieldQ("lat"), // vl.fill().if(selection, vl.value('black')), // vl.text().fieldN('name_c') // ); return vl.layer( ru_land, ru_c, ru_p)//, t) .view({stroke:"transparent"}) // .title({text: "Нападения на школы в России" , anchor: "start", frame: "group" , fontSize: 22, font: "PT Sans"}) .project( vl.projection("Albers") .parallels([52,64]) .rotate([-105 , 0 ]) .center([-10,65]) ).render() } 4a:T4b6,function select(config = {}) { let { value: formValue, title, description, disabled, submit, multiple, size, options } = Array.isArray(config) ? { options: config } : config; options = options.map(o => typeof o === "object" ? o : { value: o, label: o } ); const form = input({ type: "select", title, description, submit, attributes: { disabled }, getValue: input => { const selected = Array.prototype.filter .call(input.options, i => i.selected) .map(i => i.value); return multiple ? selected : selected[0]; }, form: html` ` }); form.output.remove(); return form; }4b:T906,function input(config) { let { form, type = "text", attributes = {}, action, getValue, title, description, format, display, submit, options } = config; const wrapper = html`

`; if (!form) form = html``; Object.keys(attributes).forEach(key => { const val = attributes[key]; if (val != null) form.input.setAttribute(key, val); }); if (submit) form.append( html`` ); form.append( html`` ); if (title) form.prepend( html`

${title}

` ); if (description) form.append( html`

${description}

` ); if (format) format = typeof format === "function" ? format : d3format.format(format); if (action) { action(form); } else { const verb = submit ? "onsubmit" : type == "button" ? "onclick" : type == "checkbox" || type == "radio" ? "onchange" : "oninput"; form[verb] = e => { e && e.preventDefault(); const value = getValue ? getValue(form.input) : form.input.value; if (form.output) { const out = display ? display(value) : format ? format(value) : value; if (out instanceof window.Element) { while (form.output.hasChildNodes()) { form.output.removeChild(form.output.lastChild); } form.output.append(out); } else { form.output.value = out; } } form.value = value; if (verb !== "oninput") form.dispatchEvent(new CustomEvent("input", { bubbles: true })); }; if (verb !== "oninput") wrapper.oninput = e => e && e.stopPropagation() && e.preventDefault(); if (verb !== "onsubmit") form.onsubmit = e => e && e.preventDefault(); form[verb](); } while (form.childNodes.length) { wrapper.appendChild(form.childNodes[0]); } form.append(wrapper); return form; }4c:[{"id":"6e93856a0af4ad90ccdbcc031d02f008ed68ea2b66213e91b078086ac3c5f9f5b9906e3f94e1591c4417d0b382f9681f581c5b8951495a277594a63238ed8cad","href":"https://static.observableusercontent.com/files/6e93856a0af4ad90ccdbcc031d02f008ed68ea2b66213e91b078086ac3c5f9f5b9906e3f94e1591c4417d0b382f9681f581c5b8951495a277594a63238ed8cad","name":"russia_ne50.geojson","type":"application/geo+json","lastModified":1695374485196.3,"size":310298},{"id":"1e81b66e9b0d9885ce4c44c826443744ee5ea91a55c0e502a87f22b7ce01518760ca80e5369ff671058b6bc8129f163931a734f33e984a6d291ecb819aecf819","href":"https://static.observableusercontent.com/files/1e81b66e9b0d9885ce4c44c826443744ee5ea91a55c0e502a87f22b7ce01518760ca80e5369ff671058b6bc8129f163931a734f33e984a6d291ecb819aecf819","name":"bd1@1.csv","type":"text/csv","lastModified":1695399428596.631,"size":4253},{"id":"f2db23394ee27f5c46aff82faa5523cbd3c1bec1ecbcc0e3664c2f2f2a2f99c585868c5f47c4436bfb3351a12232c8dd904e4433f7e8a8fa865c941a3abe079c","href":"https://static.observableusercontent.com/files/f2db23394ee27f5c46aff82faa5523cbd3c1bec1ecbcc0e3664c2f2f2a2f99c585868c5f47c4436bfb3351a12232c8dd904e4433f7e8a8fa865c941a3abe079c","name":"name.csv","type":"text/csv","lastModified":1695574252590.362,"size":374},{"id":"0f0f63f12052756f27afaafc4825cf30353fd3af8ec81d24d83e59dad44bca268735dbd7fd534aa39b16a86882f559005d825d98c6d02b0d9f2ffb9ef7681c48","href":"https://static.observableusercontent.com/files/0f0f63f12052756f27afaafc4825cf30353fd3af8ec81d24d83e59dad44bca268735dbd7fd534aa39b16a86882f559005d825d98c6d02b0d9f2ffb9ef7681c48","name":"russia-and-annexed-regions-compressed.json","type":"application/json","lastModified":1702279552056.684,"size":80740},{"id":"b00fc4bf058affede0b8a7cdaf085ac6616981d6c3ddd08ff045fd228bf91e7e282275db8528fa38de728524783ef54b0f196de9b582d992880fbbd1e3ba7a8b","href":"https://static.observableusercontent.com/files/b00fc4bf058affede0b8a7cdaf085ac6616981d6c3ddd08ff045fd228bf91e7e282275db8528fa38de728524783ef54b0f196de9b582d992880fbbd1e3ba7a8b","name":"bd@11.csv","type":"text/csv","lastModified":1702303744012.511,"size":4930},{"id":"891076bfc8f5b57e3be17e9620f3fbd50a6fd52a486ac49b8f062b0f66f3e60c9d9b318888f90e5bafbd3c039a56d8e6cda2ec45d68eddfe535ff1420385195b","href":"https://static.observableusercontent.com/files/891076bfc8f5b57e3be17e9620f3fbd50a6fd52a486ac49b8f062b0f66f3e60c9d9b318888f90e5bafbd3c039a56d8e6cda2ec45d68eddfe535ff1420385195b","name":"t_i@3.csv","type":"text/csv","lastModified":1702245804872.952,"size":19649}] 29:{"id":"378be4c1765ab361","slug":null,"title":"Российские школьные стрелки. Анализ данных","thumbnail":"011d5d4ca56bcdf55e5798561dbf31ac7a0e935ba90b12cfefa74376c4846ad6","access_level":"public","create_time":"$D2023-09-22T09:19:47.438Z","update_time":"$D2025-01-30T20:27:01.019Z","view_time":null,"first_public_time":"$D2023-09-22T09:19:47.438Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"714b07d0cf8bbd05","login":"ae95974477593eac","name":"Ксюша Хабибулина","avatar_url":"https://avatars-next.observableusercontent.com/523ae42993e86ff3a1250fc3b3cee2c3c2d772b8df897ea6e42f2604175db9af","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":867,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"ae95974477593eac","login":"ae95974477593eac","name":"Ксюша Хабибулина","avatar_url":"https://avatars-next.observableusercontent.com/523ae42993e86ff3a1250fc3b3cee2c3c2d772b8df897ea6e42f2604175db9af","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"ae95974477593eac","login":"ae95974477593eac","name":"Ксюша Хабибулина","avatar_url":"https://avatars-next.observableusercontent.com/523ae42993e86ff3a1250fc3b3cee2c3c2d772b8df897ea6e42f2604175db9af","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Российские школьные стрелки. Анализ данных","cells":[{"id":0,"value":"# Российские школьные стрелки. Анализ данных","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":777,"value":"viewof text = md`# Статистика нападений на школы в России`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":779,"value":"viewof text1 = md`На карте территория Российской Федерации представлена по состоянию на 2021 год`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":533,"value":"viewof q1 = {\n const q1 = select({\n title: \"Характеристика стрелка\",\n options: [\n { label: \"Диагноз\", value: \"health\" },\n { label: \"Наказание\", value: \"final\" },\n { label: \"Семья\", value: \"fam\" },\n { label: \"Манифест\", value: \"words\" },\n { label: \"Тип личности (1 - замкнутый, 2 - активный)\", value: \"person\"},\n { label: \"Оружие\", value: \"weapon\" },\n { label: \"План самоубийства\", value: \"plan\" },\n { label: \"Возраст\", value: \"age\" },\n { label: \"Тип учебного заведения\", value: \"type\" }, \n { label: \"Вменяемость\", value: \"heals\" }\n ],\n value: \"hmmm\"\n });\n q1.input.style.fontSize = \"15px\";\n q1.input.style.marginTop = \"8px\";\n return q1;\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":249,"value":"full = \n{\n \n const arc = vl.markArc()\n .width(300)\n .height(500)\n .encode(\n vl.theta().count().stack(true),\n vl.color().fieldN(q1).scale({scheme: \"pastel1\"}).legend({title: null}),\n vl.tooltip(q1)\n );\n\n\n const text = arc.markText({radius: 100, align:\"center\"})\n .encode(\n vl.text().count(),\n vl.detail().fieldN(q1),\n vl.color().value(\"black\")\n )\n\n\n return vl.layer(arc, text)\n .data(data.slice(0, 15))\n .render();\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":791,"value":"viewof text2 = md`# 60 погибших и 236 пострадавших за 10 лет`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":786,"value":"viewof text3 = md`С момента первого шутинга в 2014 году в России во время нападений в школах погибли 60 человек, 236 человек пострадали`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":106,"value":"barch = { \n const barch = vl.markBar()\n .data(data2)\n .transform([\n vl\n .calculate(\n `if(datum.rus == 'погибли', 1, 0) + \n if(datum.rus == 'пострадали', 1, 0)`\n )\n .as(\"t_t\")])\n .encode(\n vl\n .y()\n .fieldO('name')\n .axis({ title: false, tickCount: 15, domain: false, grid: false })\n .sort('-x'),\n vl\n .x()\n .sum('t_t')\n \n .axis({\n title: 'Всего пострадавших (вместе с убитыми)',\n tickCount: 10,\n domain: false,\n grid: false\n }),\n vl\n .color()\n .fieldN('rus')\n .scale({type: 'Ordinal', domain: domain, range: range}) \n .legend({title: null}),\n \n vl.tooltip('t_t').sum('t_t')\n )\n \n return vl.layer(barch)\n .view({stroke: \"transparent\" })\n .render()\n\n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":756,"value":"## Массивы и импорты","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":612,"value":"\nimport {table} from \"@tmcw/tables/2\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":536,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":540,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"russia = {return await FileAttachment(\"russia_ne50.geojson\").json();}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"d33 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":59,"value":"d3 = require(\"d3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"import {gold_fixed, gold} from \"@glebtr/vega-start\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"//import {vl} from '@vega/vega-lite-api-v5'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"//vegalite = require(\"@observablehq/vega-lite\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"data = {\n const points = await FileAttachment(\"bd@11.csv\").text();\n const psv = d3.dsvFormat(\";\");\n const parseDate = d3.utcParse(\"%d.%m.%Y\");\n return psv.parse(points, ({fio, data, age, data1, Latitude, Longitude, city, type, plan,\tdeath,\tinj,\tm,\theals,\tweapon,\tfriend,\tbefore,\tperson,\twords,\tfam,\thealth,\tfinal, q}) => ({\n date_b: parseDate(data),\n date_i: parseDate(data1),\n date: data1,\n name: fio,\n age: age,\n lon: parseFloat(Longitude),\n lat: parseFloat(Latitude),\n name_c: city,\n death: parseInt(death),\n d: parseInt(death),\n inj: parseInt(inj),\n t_i: parseInt(inj)+parseInt(death),\n fam: fam,\n plan : plan,\n health: health,\n q: q,\n friend: friend,\n person: person,\n words: words,\n weapon: weapon,\n type: type,\n final: final,\n heals: heals,\n before: before\n })\n ); \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"data1 = {\n const points = await FileAttachment(\"bd1@1.csv\").text();\n const psv = d3.dsvFormat(\";\");\n const parseDate = d3.utcParse(\"%d.%m.%Y\");\n return psv.parse(points, ({fio, data, age, data1, Latitude, Longitude, city, type, plan,\tdeath,\tinj,\tm,\theals,\tweapon,\tfriend,\tbefore,\tperson,\twords,\tfam,\thealth,\tfinal}) => ({\n date_b: parseDate(data),\n date_i: parseDate(data1),\n date: data1,\n name: fio,\n age: age,\n lon: parseFloat(Longitude),\n lat: parseFloat(Latitude),\n name_c: city,\n death: parseInt(death),\n d: parseInt(death),\n inj: parseInt(inj),\n t_i: parseInt(inj)+parseInt(death),\n fam: fam,\n plan: plan,\n health: health,\n friend: friend\n })\n ); \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":391,"value":"data2 = {\n const points = await FileAttachment(\"t_i@3.csv\").text();\n const psv = d3.dsvFormat(\";\");\n return psv.parse(points, ({fio, type, name}) => ({\n name: fio,\n type: type,\n rus: name\n })\n ); \n} ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":373,"value":"range = Array.from(colors.values())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":371,"value":"\ndomain = Array.from(colors.keys())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":486,"value":"s = data.slice(0, 15);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":543,"value":"d3format = require(\"d3-format@1\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":365,"value":"colors = new Map([\n [\"погибли\", \"#000000\"],\n [\"пострадали\", \"#CD5C5C\"]\n])\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":362,"value":"color = d3\n .scaleOrdinal()\n .domain(Array.from(colors.keys()))\n .range(Array.from(colors.values))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":316,"value":"q3 = {\n const points = await FileAttachment(\"name.csv\").text();\n const psv = d3.dsvFormat(\";\");\n return psv.parse(points, ({q, й}) => ({\n q:q,\n й: й\n })\n ); \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":255,"value":"q2 = Array.from(new Set(data.map(e=>e[\"q\"]))).sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":661,"value":"russiaAndAnnexedRegionsData = FileAttachment(\"russia-and-annexed-regions-compressed.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":663,"value":"regionsIsoMap = russiaAndAnnexedRegionsData.objects.collection.geometries.reduce((acc, i) => {\n acc[i.properties.iso] = i.properties.name_en\n return acc\n}, {})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4c","stdlib":"1"}} 24:null