30:T451,function getSimilarArmySoldiers(persons){ const nested = d3.nest().key(d=>d.lastPlaceOfService).entries(persons) .filter(d=>d.key) // sort by death date nested.forEach(d=>{ d.values.sort((a,b)=>{ const splitted = [a,b].map(d=>d.deathDate.split('.')); const built = splitted.map(s=>s[2]+'.'+s[1]+'.'+s[0]); // resolve(built) return built[0]>built[1]?1:-1 }) ; d.values = d.values.filter((d,i,arr)=>{if(i>0 && arr[i].burialLocation==arr[i-1].burialLocation) return false;return true;}) }) const result = nested .sort((a,b)=>a.values.length{ d.values = d.values.map(v=>{ return { date:v.deathJsDate , burialLocation:v.burialLocation } }) }) return result; }31:T597,mongoData = withEngNames.map(d=>{ const id = d.id; const url = d.url; let nameGe = manualNamesMatchedObj[d['first name']]; let nameEn= d['fname']; if(nameEn== ""){ nameGe=""; } let lastNameGe = lastNamesMatchedObj[d['last name']]; let lastNameEn=d['lname']; let lastNameRus=d['last name']; if(lastNameRus== "Гелашвили"){ lastNameGe="გელაშვილი"; lastNameEn='gelashvili'; } const birthDate = d.birth_date; const lastPlaceOfService = d['last place of service'] const place = driveDataObj.regions[getRegion(d)]? +driveDataObj.regions[getRegion(d)].index : d['date/place of recruitment']; const rank = driveDataObj.rank[d['military rank']]? +driveDataObj.rank[d['military rank']].index : d['military rank']; const deathDate = d["death date"] const burialLocation = driveDataObj.burialLocation[getBurialLocation(d)]? +driveDataObj.burialLocation[getBurialLocation(d)].index : d['initial burial location']; const deathReason = driveDataObj.deathReason[d['death reason']]? +driveDataObj.deathReason[d['death reason']].index : d['death reason'] //deathReason return { id, nameGe, nameEn:nameEn.toLowerCase(), lastNameGe, lastNameEn:lastNameEn.toLowerCase(), birthDate, lastPlaceOfService, place, rank, burialLocation, deathDate, deathReason, url } })32:T17f8, function euroConfig(d) { var minDate = new Date('1939 sep 1'); var maxDate = new Date('1946 sep 1'); var coordinates = [ [ 23.5546875, 52.3755991766591 ], [ 23.818359375, 50.28933925329178 ], [ 25.6640625, 49.439556958940855 ], [ 25.3125, 53.4357192066942 ], [ 29.70703125, 49.49667452747045 ], [ 27.421875, 53.85252660044951 ], [ 30.234375, 52.74959372674114 ], [ 32.16796875, 51.17934297928927 ], [ 31.81640625, 53.330872983017066 ], [ 33.310546875, 54.470037612805754 ], [ 35.33203125, 51.67255514839674 ], [ 35.068359375, 53.69670647530323 ], [ 33.75, 55.52863052257191 ], [ 36.38671875, 55.32914440840507 ], [ 37.70507812499999, 55.32914440840507 ], [ 36.826171875, 53.64463782485651 ], [ 36.826171875, 52.32191088594773 ], [ 34.453125, 54.316523240258256 ], [ 33.486328125, 51.01375465718821 ], [ 32.783203125, 52.74959372674114 ], [ 30.05859375, 54.77534585936447 ], [ 30.849609375, 51.28940590271679 ], [ 30.849609375, 49.49667452747045 ], [ 27.861328125, 49.32512199104001 ], [ 26.630859375, 50.736455137010665 ], [ 24.609375, 51.56341232867588 ], [ 22.32421875, 52.214338608258196 ], [ 22.763671875, 50.064191736659104 ], [ 23.90625, 47.754097979680026 ], [ 25.224609375, 47.100044694025215 ], [ 23.203125, 46.558860303117164 ], [ 21.796875, 48.40003249610685 ], [ 20.126953125, 50.56928286558243 ], [ 17.841796875, 52.64306343665892 ], [ 17.841796875, 49.724479188712984 ], [ 19.335937499999996, 48.40003249610685 ], [ 19.16015625, 46.37725420510028 ], [ 15.732421875, 46.37725420510028 ], [ 15.029296875, 48.80686346108517 ], [ 14.94140625, 50.84757295365389 ], [ 14.414062499999998, 52.64306343665892 ], [ 13.271484375, 51.12421275782688 ], [ 12.041015625, 50.28933925329178 ], [ 12.65625, 51.6180165487737 ], [ 13.18359375, 52.482780222078226 ], [ 10.8984375, 52.16045455774706 ] ] var scale = d3.scaleTime().domain([minDate, maxDate]).range([0, coordinates.length]); var n = scale(d); n = Math.round(n); return coordinates[n]; }33:T48a, function EncodingConverter() { var geoToLatinBinding = [ 'a', 'b', 'g', 'd', 'e', 'v', 'z', 'T', 'i', 'k', 'l', 'm', 'n', 'o', 'p', 'J', 'r', 's', 't', 'u', 'f', 'q', 'R', 'k', 'S', 'ch', 'c', 'dz', 'w', 'W', 'x', 'j', 'h' ]; var latinToGeoBinding = [ 'A', 'B', 'ჩ', 'D', 'E', 'F', 'G', 'H', 'I', 'ჟ', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'ღ', 'შ', 'თ', 'U', 'V', 'ჭ', 'X', 'Y', 'ძ', '[', '\\', ']', '^', '_', '`', 'ა', 'ბ', 'ც', 'დ', 'ე', 'ფ', 'გ', 'ჰ', 'ი', 'ჯ', 'კ', 'ლ', 'მ', 'ნ', 'ო', 'პ', 'ქ', 'რ', 'ს', 'ტ', 'უ', 'ვ', 'წ', 'ხ', 'ყ', 'ზ' ]; this.toLatin = function(geoWord) { return convert(geoWord, geoToLatinBinding, 'ა', 'ჰ', 4304); } this.toGeorgian = function(latinWord) { return convert(latinWord, latinToGeoBinding, 'A', 'z', 65); } function convert(word, binding, min, max, charNum) { var buffer = [] var i = 0; word.split('').forEach(function(c) { if (c >= min && c <= max) { buffer[i++] = binding[c.charCodeAt(0) - charNum]; } else { buffer[i++] = c; } }); return buffer.join(''); } }34:[] 2e:{"title":"HackViz","cells":[{"id":0,"value":"md`# HackViz`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1175,"value":"md`# Places Algorithm`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1192,"value":"mongoData.filter(d=>d.lastPlaceOfService)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1200,"value":"d3.nest().key(d=>d.lastPlaceOfService).entries(mongoData).filter(d=>d.values.length==5)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1251,"value":"cityArmyStr = JSON.stringify(cityArmy)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1317,"value":"armyPlacesStr = JSON.stringify(armyPlaces)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1179,"value":"armyPlaces = getSimilarArmySoldiers(placePersons)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1211,"value":"$30","pinned":true,"hidden":false,"mode":"ojs"},{"id":1233,"value":"placePersons = getPlacePersons()\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":1334,"value":"cityArmy = d3.nest().key(d=>d.place)\n .entries(placePersons)\n .filter(d=>+d.key)\n .sort((a,b)=>a.values.length({city:d.key,army:getSimilarArmySoldiers(d.values).slice(0,10).map(d=>d.key)}))\n ","pinned":true,"hidden":false,"mode":"ojs"},{"id":1216,"value":"function getPlacePersons(place){\n return new Promise((resolve,reject)=>{\n resolve(mongoData\n .map(d=>{\n const splitted = d.deathDate.split('.');\n return Object.assign(d,{deathJsDate:new Date(splitted[2],splitted[1],splitted[0])})\n })\n .filter(obj=>{const d= obj.deathJsDate; return d instanceof Date && !isNaN(d);})\n .filter(d=>d.burialLocation!='1')\n .filter(d=>d.burialLocation!='')\n .filter(d=>+d.burialLocation)\n .filter(d=>d.deathDate)\n .filter(d=>d.deathDate.split('.')[0])\n ) ;\n })\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1224,"value":"soldiers = getAllServiceSoldiers([\"5 гв. А 9 гв. вдд 23 гв. вдсп\",'994 сп 286 сд'])","pinned":false,"hidden":false,"mode":"ojs"},{"id":1177,"value":"function getAllServiceSoldiers(arrOfServicePlaces){\n return new Promise((resolve,reject)=>{\n resolve(mongoData.filter(d=>arrOfServicePlaces.indexOf(d.lastPlaceOfService)!=-1))\n })\n}\n\n\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":1208,"value":"d3.nest().entries()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1146,"value":"md`## Deaths Data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1153,"value":"downloadButton(mapGeoData)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1149,"value":"mapGeoData = driveData.regions.elements.filter(d=>d.lat && d.lng)\n.map(d=>{\n const result = {};\n result.index = d.index;\n result.population = d.records ;\n result.cityGeo = d.geo;\n result.long = d.lng;\n result.lat = d.lat;\n return result;\n})\n.filter(d=>d.cityGeo!=\"ორჯონიკიძე\")\n.filter(d=>d.cityGeo!=\"ბორჩალო\")\n.filter(d=>d.cityGeo!=\"წითელწყარო\")\n.filter(d=>d.cityGeo!=\"ზნაური\")\n.filter(d=>d.cityGeo!=\"ქვემო სვანეთი\")\n.filter(d=>d.cityGeo!=\"თუშეთი\")\n.filter(d=>d.cityGeo!=\"ყაზბეგი\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":922,"value":"md`## LastName Matching`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1031,"value":"lastNamesMatched = d3.csv('https://raw.githubusercontent.com/bumbeishvili/georgian-names/master/RusEnGeoMatch/lastNamesRusGeoEng.csv')","pinned":true,"hidden":false,"mode":"ojs"},{"id":1042,"value":"lastNamesMatchedObj = {\n const result = {};\n lastNamesMatched.forEach(function(d){\n result[d.rus]=d.matched\n })\n return result;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":850,"value":"lastNamesTop = d3.csv('https://raw.githubusercontent.com/bumbeishvili/georgian-names/master/withCounts/lastNamesSorted.csv')","pinned":false,"hidden":false,"mode":"ojs"},{"id":932,"value":"lastNamesToCompare = lastNamesTop\n//.filter((d,i)=>i<3000)","pinned":true,"hidden":false,"mode":"ojs"},{"id":936,"value":"rusEnLastNames = lastnamesNested\n.map(d=>({rus:d.key,en:d.values[0].lname\n .toLowerCase()\n }))\n//.filter((d,i)=>i<3)","pinned":true,"hidden":false,"mode":"ojs"},{"id":959,"value":"rusEnLastNames","pinned":true,"hidden":false,"mode":"ojs"},{"id":1021,"value":"downloadButton(rusEnLastNames)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1023,"value":"downloadButton(lastNamesToCompare)","pinned":true,"hidden":false,"mode":"ojs"},{"id":961,"value":"lastNamesToCompare","pinned":true,"hidden":false,"mode":"ojs"},{"id":934,"value":"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1002,"value":"","pinned":true,"hidden":false,"mode":"ojs"},{"id":1006,"value":"","pinned":true,"hidden":false,"mode":"ojs"},{"id":1008,"value":"","pinned":true,"hidden":false,"mode":"ojs"},{"id":938,"value":"","pinned":false,"hidden":false,"mode":"ojs"},{"id":845,"value":"md`## Name Matching`","pinned":false,"hidden":false,"mode":"ojs"},{"id":915,"value":"manualNamesMatchedObj = {\n const result = {};\n manualNamesMatched.forEach(name=>{\n result[name.rus] = name.matched;\n })\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":901,"value":"manualNamesMatched = nameMatched.map(d=>{\n if(d.matched ==\"გეორგი\"){\n return Object.assign(d,{matched:\"გიორგი\"})\n }\n if(d.matched ==\"შაკრო\"){\n return Object.assign(d,{matched:\"შაქრო\"})\n }\n if(d.matched ==\"\"){\n return Object.assign(d,{matched:\"\"})\n }\n if(d.en ==\"Suliko\"){\n return Object.assign(d,{matched:\"სულიკო\"})\n }\n if(d.en ==\"Alesha\"){\n return Object.assign(d,{matched:\"ალიოშა\"})\n }\n if(d.en ==\"YAsha\"){\n return Object.assign(d,{matched:\"იაშა\"})\n }\n return d;\n \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":886,"value":"femaleNames = d3.text('https://raw.githubusercontent.com/EMOziko/Georgian-Names-By-Gender/master/femalenames.txt')","pinned":false,"hidden":false,"mode":"ojs"},{"id":889,"value":"femaleNamesTop = femaleNames.split(/\\n/g).filter((d,i)=>i<100)","pinned":false,"hidden":false,"mode":"ojs"},{"id":848,"value":"namesTop = d3.csv('https://raw.githubusercontent.com/bumbeishvili/georgian-names/master/withCounts/namesSorted.csv')","pinned":false,"hidden":false,"mode":"ojs"},{"id":853,"value":"rusEnNames = namesNested.map(d=>({rus:d.key,en:d.values[0].fname}))//.filter((d,i)=>i<10000)","pinned":true,"hidden":false,"mode":"ojs"},{"id":861,"value":"namesToCompare = namesTop\n.filter((d,i)=>i<10000)\n.filter((d)=>femaleNamesTop.indexOf(d.nameGe)==-1)","pinned":true,"hidden":false,"mode":"ojs"},{"id":904,"value":"nameMatched = d3.csv('https://raw.githubusercontent.com/bumbeishvili/georgian-names/master/RusEnGeoMatch/namesRusGeoEng.csv')","pinned":false,"hidden":false,"mode":"ojs"},{"id":913,"value":"","pinned":false,"hidden":false,"mode":"ojs"},{"id":865,"value":"rusEnNamesMatched = rusEnNames.map(d=>{\n return;\n /*\n let dist = Infinity;\n let matchedName = ''; \n \n for(var i=0;i{\n\n const rec = {};\n rec.id = d.id;\n rec.name = d.nameGe;\n rec.lastName = d.lastNameGe;\n rec.birthDate = d.birthDate;\n rec.lastPlaceOfService = d.lastPlaceOfService;\n rec.place =driveDataIndexObj.regions[d.place]&&driveDataIndexObj.regions[d.place].geo||d.place;\n rec.rank = driveDataIndexObj.rank[d.rank]&&driveDataIndexObj.rank[d.rank].geo||d.rank;\n rec.burialLocation = driveDataIndexObj.burialLocation[d.burialLocation]&&driveDataIndexObj.burialLocation[d.burialLocation].geo||'';\n rec.deathDate = d.deathDate;\n rec.deathReason = driveDataIndexObj.deathReason[d.deathReason]&&driveDataIndexObj.deathReason[d.deathReason].geo||d.deathReason==1?\"\":d.deathReason;\n rec.url = d.url;\n \n\n return rec;\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":799,"value":"md`### Data matching`","pinned":false,"hidden":false,"mode":"ojs"},{"id":729,"value":"md`## Search Algorithm`","pinned":false,"hidden":false,"mode":"ojs"},{"id":723,"value":"function getSearchResults(name,lastname,cityReg){\n return mongoData\n .filter(d=>lastname==null || lastname=='' || lastname==d.lastName)\n .filter(d=>name==null || name=='' || d.name==name)\n .filter(d=>cityReg==null || cityReg==''|| cityReg==d.place)\n .filter((d,i)=>i<30)\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":742,"value":"function searchName(name){\n const nameResult = Object.keys(driveDataObj.names)\n .filter(k=>driveDataObj.names[k].geo==name)[0];\n if(nameResult){\n return driveDataObj.names[nameResult].index\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":772,"value":"function searchLastName(lastName){\n const nameResult = Object.keys(driveDataObj.lastnames)\n .filter(k=>driveDataObj.lastnames[k].geo==lastName)[0];\n if(nameResult){\n return driveDataObj.lastnames[nameResult].index\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":293,"value":"md`# Export`","pinned":false,"hidden":false,"mode":"ojs"},{"id":656,"value":"md`### Mongo data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1196,"value":"mongoData.filter(d=>d.nameGe==\"დავითი\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":658,"value":"downloadButton(mongoData)","pinned":true,"hidden":false,"mode":"ojs"},{"id":608,"value":"md`# Data Preparation`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1050,"value":"lastNamesMatchedObj","pinned":true,"hidden":false,"mode":"ojs"},{"id":1057,"value":"withEngNames.filter(d=>d['last name'].indexOf(\"Орбел\")!=-1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1090,"value":"mongoData.filter(d=>d.lastNameEn.indexOf('feradze')!=-1)","pinned":true,"hidden":false,"mode":"ojs"},{"id":612,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"},{"id":615,"value":"","pinned":false,"hidden":false,"mode":"ojs"},{"id":391,"value":"md`# Data Categories`","pinned":false,"hidden":false,"mode":"ojs"},{"id":588,"value":"md`## Google drive data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":591,"value":"driveData = load(\"https://docs.google.com/spreadsheets/d/123zrq8tW1BbXKg27G7LZBZ1HonEMpDeDsCpToemabqY/edit#gid=1055102699\",true)","pinned":true,"hidden":false,"mode":"ojs"},{"id":596,"value":"driveDataObj = {\n const result = {};\n const keys = Object.keys(driveData);\n keys.forEach(d=>{\n result[d]={};\n const arr = driveData[d];\n arr.elements.forEach(item=>{\n result[d][item.rus]=item;\n })\n })\n return result;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":805,"value":"driveDataIndexObj = {\n const result = {};\n const keys = Object.keys(driveData);\n keys.forEach(d=>{\n result[d]={};\n const arr = driveData[d];\n arr.elements.forEach(item=>{\n result[d][item.index]=item;\n })\n })\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":648,"value":"md`## Last Place Of Service` ","pinned":false,"hidden":false,"mode":"ojs"},{"id":651,"value":"lastPlaceOfServiceNested = d3.nest()\n.key(d=>d['last place of service'])\n.entries(withEngNames)\n.sort((a,b)=>a.values.lengthd['military rank'])\n.entries(withEngNames)\n.sort((a,b)=>a.values.length${militaryRanksNested.map(d=>[d.key,d.values.length]).map(table).join('')}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":423,"value":"md`## Death reason`","pinned":false,"hidden":false,"mode":"ojs"},{"id":428,"value":"deathReasonNested = d3.nest()\n.key(d=>d['death reason'])\n.entries(withEngNames)\n.sort((a,b)=>a.values.length${deathReasonNested.map(d=>[d.key,d.values.length]).map(table).join('')}` ","pinned":true,"hidden":false,"mode":"ojs"},{"id":448,"value":"md`## Burial location`","pinned":true,"hidden":false,"mode":"ojs"},{"id":703,"value":"getBurialLocation=d=>d['initial burial location'].split(\",\")[0]","pinned":true,"hidden":false,"mode":"ojs"},{"id":445,"value":"burialsRegions = d3.nest()\n .key(getBurialLocation)\n .entries(withEngNames) \n .sort((a,b)=>a.values.lengthd.values.length>5)\n .map(d=>[d.key,d.values.length])\n ","pinned":true,"hidden":false,"mode":"ojs"},{"id":683,"value":"","pinned":true,"hidden":false,"mode":"ojs"},{"id":472,"value":"//html`${burialsRegions.map(table).join('')}

` ","pinned":false,"hidden":false,"mode":"ojs"},{"id":480,"value":"md`## Names`","pinned":false,"hidden":false,"mode":"ojs"},{"id":482,"value":"namesNested = d3.nest()\n .key(d=>d['first name'])\n .entries(withEngNames)\n .sort((a,b)=>a.values.lengthi<500)\n .map(d=>[d.key,d.values.length])","pinned":false,"hidden":false,"mode":"ojs"},{"id":493,"value":"//html`${namesFiltered.map(table).join('')}

` ","pinned":false,"hidden":false,"mode":"ojs"},{"id":502,"value":"md`## Lastnames`","pinned":false,"hidden":false,"mode":"ojs"},{"id":504,"value":"lastnamesNested = d3.nest()\n .key(d=>d['last name'])\n .entries(withEngNames)\n .sort((a,b)=>a.values.lengthi<500)\n .map(d=>[d.key,d.values.length])","pinned":false,"hidden":false,"mode":"ojs"},{"id":509,"value":"//html`${lastNamesFiltered.map(table).join('')}

` ","pinned":false,"hidden":false,"mode":"ojs"},{"id":518,"value":"","pinned":false,"hidden":false,"mode":"ojs"},{"id":512,"value":"md`## Cities / Regions`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1111,"value":"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1109,"value":"driveDataObj.regions","pinned":false,"hidden":false,"mode":"ojs"},{"id":670,"value":"function getRegion(d){\n var arr = d['date/place of recruitment']\n .split(' ')\n ; \n var result = arr[arr.length-1];\n if(result==\"р-н\"){\n result = arr[arr.length-2]\n }\n if(result==\"г.\" || result==\"ССР\"){\n result= arr[0]\n }\n if(result==\"г.\" || result==\"РВК\"){\n result= arr[arr.length-2]\n }\n if(result==\"АССР\" ){\n result= arr[arr.length-1]\n }\n if(result.match(/.[_\\d]/g)){\n result= arr[arr.length-4]\n }\n if(result==\"АССР\"){\n result= arr[1]\n }\n return result\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1121,"value":"function getGeo(result){\n return driveDataObj.oldRegions[result] && driveDataObj.oldRegions[result].geo||result; \n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1130,"value":"function getLat(result){\n return driveDataObj.oldRegions[result] && driveDataObj.oldRegions[result].lat||''; \n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1135,"value":"function getLng(result){\n return driveDataObj.regions[result]&&driveDataObj.regions[result].lng||''; \n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":520,"value":"regionCitiesNested = d3.nest()\n .key(d=> getGeo(getRegion(d)))\n .entries(withEngNames)\n .sort((a,b)=>a.values.lengthi<94)\n .map(d=>[getRegion(d.values[0]),d.key,d.values.length,getLat(getRegion(d.values[0])),getLng(getRegion(d.values[0]))])","pinned":true,"hidden":false,"mode":"ojs"},{"id":562,"value":"html`${regionCityFiltered.map(table).join('')}

` ","pinned":true,"hidden":false,"mode":"ojs"},{"id":556,"value":"regionCitiesNested","pinned":true,"hidden":false,"mode":"ojs"},{"id":539,"value":"\"__.__.1942 Сагареджинский РВК, Грузинская ССР\".match(/.[_\\d]/g)","pinned":true,"hidden":false,"mode":"ojs"},{"id":544,"value":"\"11.09.1941 Тианетский РВК, Грузинская ССР, Тианетский р-н\".match(/.[_\\d]/g)","pinned":true,"hidden":false,"mode":"ojs"},{"id":551,"value":"\"Ткибульский\".match(/.[_\\d]/g)","pinned":true,"hidden":false,"mode":"ojs"},{"id":224,"value":"md`# Actual Data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":222,"value":"goneByCity = finalResult","pinned":false,"hidden":false,"mode":"ojs"},{"id":379,"value":"withEngNames.filter(d=>d.fname.indexOf('asil')!=-1 && d.lname.indexOf('Kareli')!=-1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":289,"value":"withEngNames = names","pinned":false,"hidden":false,"mode":"ojs"},{"id":140,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":92,"value":" test = ['აბგდევზთიკლმნოპჟრსტუფქღყშცძწჭხჯჰ','კურტანიძე','ფინია','გობეჯაშვილი','აბოიან','გუკოსიან','ფინალი','მგელაძე','ხაჩიძე']","pinned":false,"hidden":false,"mode":"ojs"},{"id":100,"value":"test.map(d=>c.toLatin(d))","pinned":false,"hidden":false,"mode":"ojs"},{"id":180,"value":"getMinDistanceCity = function getMinDistanceCity(cityName){\n var minDist = Infinity;\n var obj = null;\n coords.forEach((d,i)=>{\n var cDist = distance(d.nameEn,cityName);\n if(cDist{\n return {\n lat:d.lat,\n long:d.long\n } \n}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":376,"value":"euroConfig(new Date('1944 sep 2'))","pinned":false,"hidden":false,"mode":"ojs"},{"id":374,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":273,"value":"finalResult ={\n \n \n var result = regionsMapped.concat(hardCodedCities);\n \n \n return regionsMapped.map(d=>{\n var c = cityMapped.filter(r=>r.old==d.old)[0];\n if(c){\n d.population+=c.population \n }\n return d;\n })\n .sort((a,b)=>a.population{\n var corrCity = getMinDistanceCity(d.key);\n return {\n old:d.key,\n population:d.values.length,\n corrCity:corrCity.obj.nameEn,\n distance:corrCity.distance,\n length:d.key.length ,\n \n lat:corrCity.obj.lat,\n long:corrCity.obj.long\n }\n\n})\n.filter(d=>d.population>999)\n.filter(d=>d.distance==0)\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":241,"value":"hardCodedCities = [\n {\n old: \"Suhumi\",\n nameGe: \"სოხუმი\",\n nameEn: \"Sukhum\",\n population: 4000,\n lat: \"41.0192741\",\n long: \"43.0033629\"\n }\n \n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":186,"value":"regionsMapped = regionsNested.map(d=>{\n var corrCity = getMinDistanceCity(d.key);\n return {\n old:d.key,\n population:d.values.length,\n corrCity:corrCity.obj.nameEn,\n distance:corrCity.distance,\n length:d.key.length,\n lat:corrCity.obj.lat,\n long:corrCity.obj.long\n }\n\n})\n.filter(d=>d.distance<6 || d.corrCity == \"Chkhorotsku\")\n.filter(d=>d.distance!=5)\n.filter(d=>d.distance!=4|| d.corrCity == \"Tetritskaro\")\n.filter(d=>d.distance!=3)\n//.filter(d=>d.old != \"Suhumi\" && d.old!=\"Hobi\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":124,"value":"cityNested = d3.nest().key(d=>d).entries(cities)\n.filter(d=>d.values.length>999)\n.sort((a,b)=>a.values.lengthObject.assign(d,{key:conv.transform(d.key)}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":136,"value":"regionsNested = d3.nest().key(d=>d).entries(regions)\n.filter(d=>d.values.length>999)\n.sort((a,b)=>a.values.lengthObject.assign(d,{key:conv.transform(d.key)}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":132,"value":"regions = names.map(d=>{var arr = d['date/place of recruitment'].split(' '); return arr[arr.length-2]})\n.filter(d=>d)\n.map(d=>d.replace(/ский/,'и'))","pinned":false,"hidden":false,"mode":"ojs"},{"id":117,"value":"cities = names.map(d=>{var arr = d['date/place of recruitment'].split(' ');return arr[arr.length-1]})\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":226,"value":" values = d3.nest().key(d=>d.lname).entries(names).map(d=>d.key)","pinned":false,"hidden":false,"mode":"ojs"},{"id":232,"value":"JSON.stringify(values)","pinned":false,"hidden":false,"mode":"ojs"},{"id":344,"value":"namesWithouLink = names.map(d=>{\n var str = d['source image url'];\n str = str.replace('https://cdn.obd-memorial.ru/html/fullimage?id=','')\n return Object.assign(d,{url:str}) \n \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":29,"value":"names = data.map(d=>{\nvar obj = {\n id:d.record_id,\n fname:conv.transform(d['first name']),\n lname:conv.transform(d['last name']),\n middle:conv.transform(d['middle name'])\n };\n \n return Object.assign({},obj,d)\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":27,"value":"Object.keys(data[0])","pinned":false,"hidden":false,"mode":"ojs"},{"id":13,"value":"d3.nest().key(d=>d['death reason']).entries(data)","pinned":false,"hidden":false,"mode":"ojs"},{"id":57,"value":"md`# Helpers`","pinned":false,"hidden":false,"mode":"ojs"},{"id":68,"value":"$33","pinned":true,"hidden":false,"mode":"ojs"},{"id":73,"value":"c = new EncodingConverter()","pinned":true,"hidden":false,"mode":"ojs"},{"id":170,"value":"distance = function distance(a, b){\n if(a.length == 0) return b.length; \n if(b.length == 0) return a.length; \n\n var matrix = [];\n\n // increment along the first column of each row\n var i;\n for(i = 0; i <= b.length; i++){\n matrix[i] = [i];\n }\n\n // increment each column in the first row\n var j;\n for(j = 0; j <= a.length; j++){\n matrix[0][j] = j;\n }\n\n // Fill in the rest of the matrix\n for(i = 1; i <= b.length; i++){\n for(j = 1; j <= a.length; j++){\n if(b.charAt(i-1) == a.charAt(j-1)){\n matrix[i][j] = matrix[i-1][j-1];\n } else {\n matrix[i][j] = Math.min(matrix[i-1][j-1] + 1, // substitution\n Math.min(matrix[i][j-1] + 1, // insertion\n matrix[i-1][j] + 1)); // deletion\n }\n }\n }\n\n return matrix[b.length][a.length];\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":24,"value":"md`# Data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":146,"value":"coords = d3.csv('https://raw.githubusercontent.com/bumbeishvili/awesome-georgian-datasets/master/data/maps/districtsAndCities/districts.csv')","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"dataPart1 = d3.csv('https://raw.githubusercontent.com/bumbeishvili/data-house/f1662d81f308ab66921bb8b079d6890243d39eed/hackviz/datap1.csv')","pinned":true,"hidden":false,"mode":"ojs"},{"id":15,"value":"dataPart2 = d3.csv('https://raw.githubusercontent.com/bumbeishvili/data-house/master/hackviz/datap2.csv')","pinned":true,"hidden":false,"mode":"ojs"},{"id":549,"value":"","pinned":false,"hidden":false,"mode":"ojs"},{"id":18,"value":"data = dataPart1.concat(dataPart2)","pinned":false,"hidden":false,"mode":"ojs"},{"id":405,"value":"md`## utils`","pinned":false,"hidden":false,"mode":"ojs"},{"id":411,"value":"table('test')","pinned":true,"hidden":false,"mode":"ojs"},{"id":464,"value":"","pinned":true,"hidden":false,"mode":"ojs"},{"id":408,"value":"function table(item){\n if(typeof item==\"object\"){\n return ''+item.map(d=>`${d}`).join('')+''\n }\n return `${item}`\n} ","pinned":true,"hidden":false,"mode":"ojs"},{"id":465,"value":"getEditDistance = function(a, b){\n if(a.length == 0) return b.length; \n if(b.length == 0) return a.length; \n\n var matrix = [];\n\n // increment along the first column of each row\n var i;\n for(i = 0; i <= b.length; i++){\n matrix[i] = [i];\n }\n\n // increment each column in the first row\n var j;\n for(j = 0; j <= a.length; j++){\n matrix[0][j] = j;\n }\n\n // Fill in the rest of the matrix\n for(i = 1; i <= b.length; i++){\n for(j = 1; j <= a.length; j++){\n if(b.charAt(i-1) == a.charAt(j-1)){\n matrix[i][j] = matrix[i-1][j-1];\n } else {\n matrix[i][j] = Math.min(matrix[i-1][j-1] + 1, // substitution\n Math.min(matrix[i][j-1] + 1, // insertion\n matrix[i-1][j] + 1)); // deletion\n }\n }\n }\n\n return matrix[b.length][a.length];\n};","pinned":false,"hidden":false,"mode":"ojs"},{"id":22,"value":"md`# Libs`","pinned":false,"hidden":false,"mode":"ojs"},{"id":983,"value":"a = ({\n \"Ё\": \"YO\",\n \"Й\": \"I\",\n \"Ц\": \"TS\",\n \"У\": \"U\",\n \"К\": \"K\",\n \"Е\": \"E\",\n \"Н\": \"N\",\n \"Г\": \"G\",\n \"Ш\": \"SH\",\n \"Щ\": \"SCH\",\n \"З\": \"Z\",\n \"Х\": \"Kh\",\n \"Ъ\": \"'\",\n \"ё\": \"yo\",\n \"й\": \"i\",\n \"ц\": \"ts\",\n \"у\": \"u\",\n \"к\": \"k\",\n \"е\": \"e\",\n \"н\": \"n\",\n \"г\": \"g\",\n \"ш\": \"sh\",\n \"щ\": \"sch\",\n \"з\": \"z\",\n \"х\": \"kh\",\n \"ъ\": \"'\",\n \"Ф\": \"F\",\n \"Ы\": \"I\",\n \"В\": \"V\",\n \"А\": \"a\",\n \"П\": \"P\",\n \"Р\": \"R\",\n \"О\": \"O\",\n \"Л\": \"L\",\n \"Д\": \"D\",\n \"Ж\": \"ZH\",\n \"Э\": \"E\",\n \"ф\": \"f\",\n \"ы\": \"i\",\n \"в\": \"v\",\n \"а\": \"a\",\n \"п\": \"p\",\n \"р\": \"r\",\n \"о\": \"o\",\n \"л\": \"l\",\n \"д\": \"d\",\n \"ж\": \"zh\",\n \"э\": \"e\",\n \"Я\": \"Ia\",\n \"Ч\": \"CH\",\n \"С\": \"S\",\n \"М\": \"M\",\n \"И\": \"I\",\n \"Т\": \"T\",\n \"Ь\": \"'\",\n \"Б\": \"B\",\n \"Ю\": \"IU\",\n \"я\": \"ia\",\n \"ч\": \"ch\",\n \"с\": \"s\",\n \"м\": \"m\",\n \"и\": \"i\",\n \"т\": \"t\",\n \"ь\": \"'\",\n \"б\": \"b\",\n \"ю\": \"iu\"\n})\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":985,"value":"function transliterate(word){\n return word.split('').map(function (char) { \n return a[char] || char; \n }).join(\"\");\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":4,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs"},{"id":37,"value":"cirrilic = require('https://bundle.run/cyrillic-to-translit-js@2.1.0')","pinned":true,"hidden":false,"mode":"ojs"},{"id":50,"value":"conv = ({transform:transliterate})","pinned":true,"hidden":false,"mode":"ojs"},{"id":40,"value":"import {requireFromGithub,load} from '@bumbeishvili/fetcher'","pinned":true,"hidden":false,"mode":"ojs"},{"id":578,"value":"import {downloadButton} from \"@bumbeishvili/utils\"","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}