Skip to content

Instantly share code, notes, and snippets.

@lmorillas
Created Aug 21, 2021
Embed
What would you like to do?
Json from google spreadsheet
{'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}}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment