{
    "version": "https:\/\/jsonfeed.org\/version\/1",
    "title": "Графики и жизнь: гуманизация данных, заметки с тегом: europe",
    "home_page_url": "https:\/\/gizh.ru\/tags\/europe\/",
    "feed_url": "https:\/\/gizh.ru\/tags\/europe\/json\/",
    "icon": "https:\/\/gizh.ru\/user\/userpic@2x.jpg",
    "author": {
        "name": "Графики и жизнь",
        "url": "https:\/\/gizh.ru\/",
        "avatar": "https:\/\/gizh.ru\/user\/userpic@2x.jpg"
    },
    "items": [
        {
            "id": "20",
            "url": "https:\/\/gizh.ru\/all\/football\/",
            "title": "Average Elo Rating of major European football leagues",
            "content_html": "<p>Спарсил базу <a href=\"http:\/\/clubelo.com\">http:\/\/clubelo.com<\/a>. Узнал, что такое JOIN и SELECT, подсчитал средний Эло высших дивизионов на выбранные даты. Хотелось сделать horserace chart топ-клубов, но не смог. Визуальные материалы получились такие.<\/p>\n<h2>Video<\/h2>\n<div class=\"e2-text-video\">\n<iframe src=\"https:\/\/www.youtube.com\/embed\/3GPK2D4Deag\" frameborder=\"0\" allowfullscreen><\/iframe><\/div>\n<h2>Interactive Chart<\/h2>\n<script type=\"text\/javascript\">\r\n      google.charts.load('current', {'packages':['corechart']});\r\n      google.charts.setOnLoadCallback(drawChart);\r\n\r\n      function drawChart() {\r\n        var data = google.visualization.arrayToDataTable([\r\n          ['Date', 'England', 'Spain', 'Germany', 'Italy'],\r\n[ new Date(1960, 6, 1), 1645.74686501227, 1713.37734646389, 1544.82521615415, 1647.65861002556],\t[ new Date(1961, 6, 1), 1644.87496115955, 1728.26675415125, 1565.17510665132, 1621.78108723889],\t[ new Date(1962, 6, 1), 1627.25511532905, 1703.30462036, 1553.17454223725, 1674.46820746556],\t[ new Date(1963, 6, 1), 1665.72137741762, 1690.38793945438, 1553.92809432564, 1685.12776692667],\t[ new Date(1964, 6, 1), 1645.67909458714, 1675.24252658333, 1654.062187195, 1702.14978705611],\t[ new Date(1965, 6, 1), 1716.82788085952, 1646.495727539, 1679.7344741825, 1698.25773790111],\t[ new Date(1966, 6, 1), 1714.79680524524, 1681.51632690438, 1695.20389133111, 1686.37238227056],\t[ new Date(1967, 6, 1), 1666.67546497727, 1667.35881805375, 1705.20339965875, 1693.06736924944],\t[ new Date(1968, 6, 1), 1723.47385951476, 1667.01664733875, 1707.31357320208, 1729.75814819438],\t[ new Date(1969, 6, 1), 1700.33470570045, 1658.83872222937, 1714.62575954778, 1727.48124694813],\t[ new Date(1970, 6, 1), 1717.25020530045, 1623.4961166375, 1697.97089979333, 1710.221580505],\t[ new Date(1971, 6, 1), 1736.00243030864, 1649.122306825, 1692.17871093889, 1691.11312103188],\t[ new Date(1972, 6, 1), 1732.4500325519, 1579.829555935, 1659.73212348, 1671.60321044813],\t[ new Date(1973, 6, 1), 1751.90483165905, 1576.11643473333, 1679.69514295667, 1654.54951477125],\t[ new Date(1974, 6, 1), 1757.73118954571, 1562.63469780833, 1681.01074218765, 1619.9532241825],\t[ new Date(1975, 6, 1), 1717.83336821095, 1582.24352349222, 1714.64341227167, 1619.37525939937],\t[ new Date(1976, 6, 1), 1743.24072265619, 1588.07057020444, 1715.85257496588, 1601.71244049187],\t[ new Date(1977, 6, 1), 1722.56216153182, 1631.34162055167, 1702.65332709444, 1611.94910431],\t[ new Date(1978, 6, 1), 1717.47354958318, 1627.74130588111, 1678.42148166278, 1571.75425720188],\t[ new Date(1979, 6, 1), 1725.06039151182, 1650.18898519, 1731.60932752722, 1537.57408142188],\t[ new Date(1980, 6, 1), 1694.92679665273, 1652.99576823167, 1777.43918026118, 1529.30410003687],\t[ new Date(1981, 6, 1), 1717.48725474955, 1632.92440459278, 1751.02251838235, 1547.09903717063],\t[ new Date(1982, 6, 1), 1691.30492054364, 1628.32953558944, 1715.05116780556, 1533.7652816775],\t[ new Date(1983, 6, 1), 1629.15566184364, 1647.32134331611, 1718.30716959667, 1565.63255310125],\t[ new Date(1984, 6, 1), 1690.926913175, 1616.00146484389, 1666.39602481588, 1623.47679901125],\t[ new Date(1985, 6, 1), 1709.59528142727, 1614.13403998389, 1671.61595961647, 1652.330963135],\t[ new Date(1986, 6, 1), 1713.88836115045, 1651.09633382167, 1675.58302935471, 1654.22446441437],\t[ new Date(1987, 6, 1), 1716.41076660136, 1638.35372585667, 1675.94671271764, 1657.38472747875],\t[ new Date(1988, 6, 1), 1717.56348818762, 1667.033862305, 1690.04793054941, 1645.34070587188],\t[ new Date(1989, 6, 1), 1695.35321335524, 1648.132641602, 1686.07520967294, 1707.46354844889],\t[ new Date(1990, 6, 1), 1693.14136323429, 1633.755413818, 1699.05488416944, 1731.77929687556],\t[ new Date(1991, 6, 1), 1727.5635131835, 1608.701483155, 1614.15486145083, 1757.31439208944],\t[ new Date(1992, 6, 1), 1668.10356869913, 1632.137451172, 1651.676324463, 1757.36130777889],\t[ new Date(1993, 6, 1), 1628.49407959045, 1610.0715576175, 1655.59533691471, 1781.29939778556],\t[ new Date(1994, 6, 1), 1670.25655295591, 1621.49809827316, 1679.93117947, 1784.30581325944],\t[ new Date(1995, 6, 1), 1663.91641512818, 1620.6561096195, 1695.01673799294, 1780.79932318722],\t[ new Date(1996, 6, 1), 1622.212646483, 1640.54656427591, 1696.16392606765, 1756.70244683167],\t[ new Date(1997, 6, 1), 1622.4028869635, 1672.03049538364, 1719.10110812722, 1731.79968939944],\t[ new Date(1998, 6, 1), 1654.966510009, 1682.342730713, 1726.02115207222, 1739.66103786889],\t[ new Date(1999, 6, 1), 1660.994604492, 1714.1143188485, 1690.70755343944, 1763.93759494278],\t[ new Date(2000, 6, 1), 1689.4521911615, 1774.8047119145, 1658.70494927278, 1720.32281494167],\t[ new Date(2001, 6, 1), 1703.9010681155, 1786.5331420895, 1681.84280056222, 1688.19493272556],\t[ new Date(2002, 6, 1), 1694.279138183, 1762.8819641105, 1707.45517306833, 1679.33093939833],\t[ new Date(2003, 6, 1), 1684.811132813, 1766.012628174, 1672.294358995, 1702.09662543333],\t[ new Date(2004, 6, 1), 1688.5752441405, 1781.11190796, 1640.96227349167, 1651.87154134056],\t[ new Date(2005, 6, 1), 1714.72019043, 1731.283721924, 1650.33465576167, 1675.501068115],\t[ new Date(2006, 6, 1), 1711.7956665035, 1762.9198059085, 1644.58809407611, 1670.592126466],\t[ new Date(2007, 6, 1), 1742.67052580368, 1801.76351768, 1652.05527750722, 1665.406280517],\t[ new Date(2008, 6, 1), 1768.110174561, 1770.243438729, 1643.88727484944, 1680.9004028315],\t[ new Date(2009, 6, 1), 1734.5176818845, 1737.855004859, 1661.20432535833, 1669.651092529],\t[ new Date(2010, 6, 1), 1711.1146545415, 1719.7142028715, 1690.56434461722, 1680.285870361],\t[ new Date(2011, 6, 1), 1715.0594970705, 1725.6091430625, 1707.06691487611, 1616.3862243655],\t[ new Date(2012, 6, 1), 1709.6640686035, 1753.827886963, 1714.58252631333, 1612.580444337],\t[ new Date(2013, 6, 1), 1704.212329101, 1735.4735168455, 1733.72464328333, 1613.940917969],\t[ new Date(2014, 6, 1), 1713.5206054685, 1776.738201887, 1709.25090874556, 1624.308374024],\t[ new Date(2015, 6, 1), 1687.9140747075, 1764.20498658, 1701.65842013833, 1658.161712646],\t[ new Date(2016, 6, 1), 1706.9181274415, 1776.414544677, 1694.45806206611, 1636.5859924315],\t[ new Date(2017, 6, 1), 1707.849993896, 1737.4137512205, 1701.45509168833, 1631.437072754],\t[ new Date(2017, 11, 1), 1717.5967651365, 1735.0602539055, 1660.83714463889, 1660.2201416005],\r\n\r\n        ]);\r\n\r\n        var options = {\r\n          curveType: 'function',\r\n          legend: 'bottom',\r\n\t\t  vAxis: {minValue: 1400, maxValue: 1800},\r\n\t\t  \t\t    series: {\r\n            0: { color: '#3d195b' },\r\n            1: { color: '#ffc400' },\r\n            2: { color: '#d20515' },\r\n            3: { color: '#00a859' },\r\n                               }\r\n\t\t        };\r\n\r\n        var chart = new google.visualization.LineChart(document.getElementById('curve_chart'));\r\n\r\n        chart.draw(data, options);\r\n      }\r\n    <\/script>\n<\/head><p><body><\/p>\n<div id=\"curve_chart\" style=\"width: 900px; height: 500px\"><\/div><p><\/body><\/p>\n",
            "date_published": "2018-01-01T13:58:52+03:00",
            "date_modified": "2018-02-07T17:32:55+03:00",
            "_date_published_rfc2822": "Mon, 01 Jan 2018 13:58:52 +0300",
            "_rss_guid_is_permalink": "true",
            "_rss_guid": "https:\/\/gizh.ru\/all\/football\/",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [],
                "og_images": []
            }
        }
    ],
    "_e2_version": 3386,
    "_e2_ua_string": "E2 (v3386; Aegea)"
}