Json from google spreadsheet

data.json

{'version': '0.6',
 'reqId': '0',
 'status': 'ok',
 'sig': '1494343106',
 'table': {'cols': [{'id': 'A', 'label': 'label', 'type': 'string'},
   {'id': 'B', 'label': 'url', 'type': 'string'},
   {'id': 'C', 'label': 'image', 'type': 'string'},
   {'id': 'D', 'label': 'City', 'type': 'string'},
   {'id': 'E', 'label': 'Region', 'type': 'string'},
   {'id': 'F', 'label': 'latlng', 'type': 'string'},
   {'id': 'G', 'label': 'Winners', 'type': 'number', 'pattern': 'General'},
   {'id': 'H', 'label': 'Runner-up', 'type': 'number', 'pattern': 'General'},
   {'id': 'I', 'label': 'ChampionshipSeasons', 'type': 'string'}],
  'rows': [{'c': [{'v': 'Juventus'},
     {'v': 'http://www.juventus.com/'},
     {'v': 'images/juve.png'},
     {'v': 'Turin'},
     {'v': 'Piedmont'},
     {'v': '45.070, 7.687'},
     {'v': 27.0, 'f': '27'},
     {'v': 20.0, 'f': '20'},
     {'v': '1905; 1925/26; 1930/31; 1931/32; 1932/33; 1933/34; 1934/35; 1949/50; 1951/52; 1957/58; 1959/60; 1960/61; 1966/67; 1971/72; 1972/73; 1974/75; 1976/77; 1977/78; 1980/81; 1981/82; 1983/84; 1985/86; 1994/95; 1996/97; 1997/98; 2001/02; 2002/03'}]},
   {'c': [{'v': 'Milan'},
     {'v': 'http://www.acmilan.com'},
     {'v': 'images/milan.png'},
     {'v': 'Milan'},
     {'v': 'Lombardy'},
     {'v': '45.464, 9.188'},
     {'v': 17.0, 'f': '17'},
     {'v': 14.0, 'f': '14'},
     {'v': '1901; 1906; 1907; 1950/51; 1954/55; 1956/57; 1958/59; 1961/62; 1967/68; 1978/79; 1987/88; 1991/92; 1992/93; 1993/94; 1995/96; 1998/99; 2003/04'}]},
   {'c': [{'v': 'Inter'},
     {'v': 'http://www.inter.it/aas/hp?L=en'},
     {'v': 'images/inter.png'},
     {'v': 'Milan'},
     {'v': 'Lombardy'},
     {'v': '45.463, 9.187'},
     {'v': 17.0, 'f': '17'},
     {'v': 13.0, 'f': '13'},
     {'v': '1909/10; 1919/20; 1929/30; 1937/38; 1939/40; 1952/53; 1953/54; 1962/63; 1964/65; 1965/66; 1970/71; 1979/80; 1988/89; 2005/06; 2006/07; 2007/08; 2008/09'}]},
   {'c': [{'v': 'Genoa'},
     {'v': 'http://www.genoacfc.it/index.php'},
     {'v': 'images/genoa.png'},
     {'v': 'Genoa'},
     {'v': 'Liguria'},
     {'v': '44.4065, 8.9335'},
     {'v': 9.0, 'f': '9'},
     {'v': 4.0, 'f': '4'},
     {'v': '1898; 1899; 1900; 1902; 1903; 1904; 1914/15; 1922/23; 1923/24'}]},
   {'c': [{'v': 'Torino'},
     {'v': 'http://www.torinofc.it/index.php'},
     {'v': 'images/torino.png'},
     {'v': 'Turin'},
     {'v': 'Piedmont'},
     {'v': '45.071, 7.686'},
     {'v': 7.0, 'f': '7'},
     {'v': 7.0, 'f': '7'},
     {'v': '1927/28; 1942/43; 1945/46; 1946/47; 1947/48; 1948/49; 1975/76'}]},
   {'c': [{'v': 'Bologna'},
     {'v': 'http://www.bolognafc.it/'},
     {'v': 'images/bologna.png'},
     {'v': 'Bologna'},
     {'v': 'Emilia Romagna'},
     {'v': '44.4942191, 11.3464815'},
     {'v': 7.0, 'f': '7'},
     {'v': 4.0, 'f': '4'},
     {'v': '1924/25; 1928/29; 1935/36; 1936/37; 1938/39; 1940/41; 1963/64'}]},
   {'c': [{'v': 'Pro Vercelli'},
     {'v': 'http://www.provercelli.it/'},
     {'v': 'images/vercelli.png'},
     {'v': 'Vercelli'},
     {'v': 'Piedmont'},
     {'v': '45.3210612, 8.4263931'},
     {'v': 7.0, 'f': '7'},
     {'v': 1.0, 'f': '1'},
     {'v': '1908; 1909; 1910/11; 1911/12; 1912/13; 1920/21; 1921/22 (CCI)'}]},
   {'c': [{'v': 'Roma'},
     {'v': 'http://www.asroma.it/'},
     {'v': 'images/roma.png'},
     {'v': 'Rome'},
     {'v': 'Lazio'},
     {'v': '41.89, 12.48'},
     {'v': 3.0, 'f': '3'},
     {'v': 11.0, 'f': '11'},
     {'v': '1941/42; 1982/83; 2000/01'}]},
   {'c': [{'v': 'Lazio'},
     {'v': 'http://www.sslazio.it/cms/view'},
     {'v': 'images/lazio.png'},
     {'v': 'Rome'},
     {'v': 'Lazio'},
     {'v': '41.90, 12.475'},
     {'v': 2.0, 'f': '2'},
     {'v': 6.0, 'f': '6'},
     {'v': '1973/74; 1999/2000'}]},
   {'c': [{'v': 'Fiorentina'},
     {'v': 'http://it.violachannel.tv/'},
     {'v': 'images/fiorentina.png'},
     {'v': 'Florence'},
     {'v': 'Tuscany'},
     {'v': '43.7687324, 11.2569013'},
     {'v': 2.0, 'f': '2'},
     {'v': 5.0, 'f': '5'},
     {'v': '1955/56; 1968/69'}]},
   {'c': [{'v': 'Napoli'},
     {'v': 'http://www.sscnapoli.it/client/render.aspx'},
     {'v': 'images/napoli.png'},
     {'v': 'Naples'},
     {'v': 'Campania'},
     {'v': '40.8400969, 14.2516357'},
     {'v': 2.0, 'f': '2'},
     {'v': 4.0, 'f': '4'},
     {'v': '1986/87; 1989/90'}]},
   {'c': [{'v': 'Cagliari'},
     {'v': 'http://www.cagliaricalcio.net/'},
     {'v': 'images/cagliari.png'},
     {'v': 'Cagliari'},
     {'v': 'Sardinia'},
     {'v': '39.2154, 9.1092'},
     {'v': 1.0, 'f': '1'},
     {'v': 1.0, 'f': '1'},
     {'v': '1969/70'}]},
   {'c': [{'v': 'Casale'},
     {'v': 'http://www.casalecalcio.it/'},
     {'v': 'images/casale.png'},
     {'v': 'Casale Monferrato'},
     {'v': 'Piedmont'},
     {'v': '45.1371, 8.4508'},
     {'v': 1.0, 'f': '1'},
     {'v': 0.0, 'f': '0'},
     {'v': '1913/14'}]},
   {'c': [{'v': 'Novese'},
     {'v': 'http://www.usnovese.it/'},
     {'v': 'images/novese.png'},
     {'v': 'Novi Ligure'},
     {'v': 'Piedmont'},
     {'v': '44.7617, 8.7861'},
     {'v': 1.0, 'f': '1'},
     {'v': 0.0, 'f': '0'},
     {'v': '1921/22 (FIGC)'}]},
   {'c': [{'v': 'Sampdoria'},
     {'v': 'http://www.sampdoria.it/'},
     {'v': 'images/sampdoria.png'},
     {'v': 'Genoa'},
     {'v': 'Liguria'},
     {'v': '44.407, 8.934'},
     {'v': 1.0, 'f': '1'},
     {'v': 0.0, 'f': '0'},
     {'v': '1990/91'}]},
   {'c': [{'v': 'Hellas Verona'},
     {'v': 'http://www.hellasverona.it/'},
     {'v': 'images/verona.png'},
     {'v': 'Verona'},
     {'v': 'Veneto'},
     {'v': '45.4383, 10.9917'},
     {'v': 1.0, 'f': '1'},
     {'v': 0.0, 'f': '0'},
     {'v': '1984/85'}]},
   {'c': [{'v': 'Spezia'},
     {'v': 'http://www.acspezia.com/home.html'},
     {'v': 'images/spezia.png'},
     {'v': 'La Spezia'},
     {'v': 'Liguria'},
     {'v': '44.2447, 9.7678'},
     {'v': 1.0, 'f': '1'},
     {'v': 0.0, 'f': '0'},
     {'v': '1994'}]}],
  'parsedNumHeaders': 1}}