{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import sys" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "sys.path.insert(0, '/Users/joel/src/thundr/tracker')" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "No buildsha.py defined. sha will be 'NOT_SET'\n", "Not using secrets manager\n", "use_my_whitelist_cache False\n" ] } ], "source": [ "from tracker import config" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [], "source": [ "from tracker import spotify, db\n", "from tracker.unicorn import mysql" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "from importlib import reload" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "reload(spotify)" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [], "source": [ "db.Session.remove(); db.setup_session()" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "auth = spotify._authenticate()" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [], "source": [ "from datetime import datetime, timedelta, date" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [], "source": [ "import pymysql\n", "from contextlib import contextmanager\n", "\n", "\n", "conn_kwargs = {\n", " 'host': 'unicron.cluster-cbn1zk7uet6r.eu-west-1.rds.amazonaws.com', \n", " 'user': 'unicron', \n", " 'password': 'tydz5cy9xbvchqpa249rfekhcg9sey', \n", " 'db': 'unicron', \n", " 'charset': 'utf8mb4'\n", "}\n", "\n", "@contextmanager\n", "def get_cursor(commit_after=False):\n", " connection = pymysql.connect(**conn_kwargs)\n", " try:\n", " with connection.cursor() as cur:\n", " yield cur\n", " if commit_after:\n", " connection.commit()\n", " else:\n", " connection.rollback()\n", " finally:\n", " try:\n", " connection.close()\n", " except Exception as e:\n", " print(\"Warning, failed to close connection\")\n", " print(e)\n", " \n", " \n", "def chunks(lst, n):\n", " \"\"\"Yield successive n-sized chunks from lst.\"\"\"\n", " for i in range(0, len(lst), n):\n", " yield lst[i:i + n]" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "ALL_CHARTS = [\n", " ('37i9dQZEVXbMDoHDwVN2tF', 'Global Top 50', 'Global', False),\n", " ('37i9dQZEVXbMXbN3EUUhlg', 'Brazil Top 50', 'BR', False),\n", " ('37i9dQZEVXbNBz9cRCSFkY', 'Philippines Top 50', 'PH', False),\n", " ('37i9dQZEVXbNFJfN1Vw8d9', 'Spain Top 50', 'ES', False),\n", " ('37i9dQZEVXbObFQZ3JLcXt', 'Indonesia Top 50', 'ID', False),\n", " ('37i9dQZEVXbIQnj7RRhdSX', 'Italy Top 50', 'IT', False),\n", " ('37i9dQZEVXbJPcfkRz0wJ0', 'Australia Top 50', 'AU', False),\n", " ('37i9dQZEVXbLnolsZ8PSNw', 'United Kingdom Top 50', 'GB', False),\n", " ('37i9dQZEVXbO3qyFxbkOE1', 'Mexico Top 50', 'MX', False),\n", " ('37i9dQZEVXbJfdy5b0KP7W', 'Peru Top 50', 'PE', False),\n", " ('37i9dQZEVXbLRQDuF5jeBp', 'United States Top 50', 'US', False),\n", " ('37i9dQZEVXbMMy2roB9myp', 'Argentina Top 50', 'AR', False),\n", " ('37i9dQZEVXbJiZcmkrIHGU', 'Germany Top 50', 'DE', False),\n", " ('37i9dQZEVXbMnZEatlMSiu', 'Taiwan Top 50', 'TW', False),\n", " ('37i9dQZEVXbIPWwFssbupI', 'France Top 50', 'FR', False),\n", " ('37i9dQZEVXbKM896FDX8L1', 'Ireland Top 50', 'IE', False),\n", " ('37i9dQZEVXbNOUPGj7tW6T', 'Paraguay Top 50', 'PY', False),\n", " ('37i9dQZEVXbKyJS56d1pgi', 'Portugal Top 50', 'PT', False),\n", " ('37i9dQZEVXbKCF6dqVpDkS', 'Netherlands Top 50', 'NL', False),\n", " ('37i9dQZEVXbL3J0k32lWnN', 'Denmark Top 50', 'DK', False),\n", " ('37i9dQZEVXbOa2lmxNORXQ', 'Colombia Top 50', 'CO', False),\n", " ('37i9dQZEVXbL0GavIqMTeb', 'Chile Top 50', 'CL', False),\n", " ('37i9dQZEVXbJlfUljuZExa', 'Malaysia Top 50', 'MY', False),\n", " ('37i9dQZEVXbLiRSasKsNU9', 'Global Viral 50', 'Global', True),\n", " ('37i9dQZEVXbJNSeeHswcKB', 'Belgium Top 50', 'BE', False),\n", " ('37i9dQZEVXbIVYVBNw9D5K', 'Turkey Top 50', 'TR', False),\n", " ('37i9dQZEVXbJqfMFK4d691', 'Bolivia Top 50', 'BO', False),\n", " ('37i9dQZEVXbK4gjvS1FjPY', 'Singapore Top 50', 'SG', False),\n", " ('37i9dQZEVXbLoATJ81JYXz', 'Sweden Top 50', 'SE', False),\n", " ('37i9dQZEVXbMJJi3wgRbAy', 'Uruguay Top 50', 'UY', False),\n", " ('37i9dQZEVXbNHwMxAkvmF8', 'Hungary Top 50', 'HU', False),\n", " ('37i9dQZEVXbMxcczTSoGwZ', 'Finland Top 50', 'FI', False),\n", " ('37i9dQZEVXbLy5tBFyQvd4', 'Guatemala Top 50', 'GT', False),\n", " ('37i9dQZEVXbMZAjGMynsQX', 'Costa Rica Top 50', 'CR', False),\n", " ('37i9dQZEVXbLdGSmz6xilI', 'Vietnam Top 50', 'Global', False),\n", " ('37i9dQZEVXbJlM6nvL1nD1', 'Ecuador Top 50', 'EC', False),\n", " ('37i9dQZEVXbKypXHVwk1f0', 'Panama Top 50', 'PA', False),\n", " ('37i9dQZEVXbKj23U1GF4IR', 'Canada Top 50', 'CA', False),\n", " ('37i9dQZEVXbMnz8KIWsvf9', 'Thailand Top 50', 'Global', False),\n", " ('37i9dQZEVXbM8SIrkERIYl', 'New Zealand Top 50', 'NZ', False),\n", " ('37i9dQZEVXbN6itCcaL3Tt', 'Poland Top 50', 'PL', False),\n", " ('37i9dQZEVXbJvfa0Yxg7E7', 'Norway Top 50', 'NO', False),\n", " ('37i9dQZEVXbKXQ4mDTEBXq', 'Japan Top 50', 'JP', False),\n", " ('37i9dQZEVXbKuaTI1Z1Afx', 'United States Viral 50', 'US', True),\n", " ('37i9dQZEVXbLwpL8TjsxOG', 'Hong Kong Top 50', 'HK', False),\n", " ('37i9dQZEVXbKNHh6NIXu36', 'Austria Top 50', 'AT', False),\n", " ('37i9dQZEVXbMOkSwG072hV', 'Brazil Viral 50', 'BR', True),\n", " ('37i9dQZEVXbIP3c3fqVrJY', 'Czech Republic Top 50', 'CZ', False),\n", " ('37i9dQZEVXbJp9wcIM9Eo5', 'Honduras Top 50', 'HN', False),\n", " ('37i9dQZEVXbJqdarpmTJDL', 'Greece Top 50', 'GR', False),\n", " ('37i9dQZEVXbJiyhoAPEfMK', 'Switzerland Top 50', 'CH', False),\n", " ('37i9dQZEVXbLxoIml4MYkT', 'El Salvador Top 50', 'SV', False),\n", " ('37i9dQZEVXbJ6IpvItkve3', 'Israel Top 50', 'Global', False),\n", " ('37i9dQZEVXbMfVLvbaC3bj', 'Spain Viral 50', 'ES', True),\n", " ('37i9dQZEVXbKpV6RVDTWcZ', 'Indonesia Viral 50', 'ID', True),\n", " ('37i9dQZEVXbMH2jvi6jvjk', 'South Africa Top 50', 'Global', False),\n", " ('37i9dQZEVXbKbvcwe5owJ1', 'Italy Viral 50', 'IT', True),\n", " ('37i9dQZEVXbNZbJ6TZelCq', 'Romania Top 50', 'Global', False),\n", " ('37i9dQZEVXbKAbrMR8uuf7', 'Dominican Republic Top 50', 'DO', False),\n", " ('37i9dQZEVXbMx56Rdq5lwc', 'Lithuania Top 50', 'Global', False),\n", " ('37i9dQZEVXbNGGDnE9UFTF', 'Poland Viral 50', 'PL', True),\n", " ('37i9dQZEVXbJv2Mvelmc3I', 'Philippines Viral 50', 'PH', True),\n", " ('37i9dQZEVXbLuUZrygauiA', 'Mexico Viral 50', 'MX', True),\n", " ('37i9dQZEVXbMIJZxwqzod6', 'Turkey Viral 50', 'TR', True),\n", " ('37i9dQZEVXbJajpaXyaKll', 'Argentina Viral 50', 'AR', True),\n", " ('37i9dQZEVXbMGnTCc4Vx7v', 'Taiwan Viral 50', 'Global', True),\n", " ('37i9dQZEVXbL3DLHfQeDmV', 'United Kingdom Viral 50', 'GB', True),\n", " ('37i9dQZEVXbLOov4J0GutU', 'Greece Viral 50', 'Global', True),\n", " ('37i9dQZEVXbLesry2Qw2xS', 'Estonia Top 50', 'Global', False),\n", " ('37i9dQZEVXbLZ52XmnySJg', 'India Top 50', 'Global', False),\n", " ('37i9dQZEVXbJWuzDrTxbKS', 'Latvia Top 50', 'Global', False),\n", " ('37i9dQZEVXbJs8e2vk15a8', 'Chile Viral 50', 'CL', True),\n", " ('37i9dQZEVXbNv6cjoMVCyg', 'Germany Viral 50', 'DE', True),\n", " ('37i9dQZEVXbJmRv5TqJW16', 'France Viral 50', 'FR', True),\n", " ('37i9dQZEVXbISk8kxnzfCq', 'Nicaragua Top 50', 'Global', False),\n", " ('37i9dQZEVXbKIVTPX9a2Sb', 'Slovakia Top 50', 'Global', False),\n", " ('37i9dQZEVXbKHoaIcElSSA', 'Portugal Viral 50', 'PT', True),\n", " ('37i9dQZEVXbO5MSE9RdfN2', 'Australia Viral 50', 'AU', True),\n", " ('37i9dQZEVXbKrooeK9WSFF', 'Colombia Viral 50', 'CO', True),\n", " ('37i9dQZEVXbIUY6VUoboP4', 'Latvia Viral 50', 'Global', True),\n", " ('37i9dQZEVXbMTKZuy8ORFV', 'Bolivia Viral 50', 'Global', True),\n", " ('37i9dQZEVXbNxY4E5g33Gy', 'Paraguay Viral 50', 'Global', True),\n", " ('37i9dQZEVXbKfIuOAZrk7G', 'Canada Viral 50', 'CA', True),\n", " ('37i9dQZEVXbNfM2w2mq1B8', 'Bulgaria Top 50', 'Global', False),\n", " ('37i9dQZEVXbLuey1EKVv9I', 'Hungary Viral 50', 'Global', True),\n", " ('37i9dQZEVXbMnf7ONzeQWM', 'Thailand Viral 50', 'Global', True),\n", " ('37i9dQZEVXbLzhUVGQUCoe', 'Ireland Viral 50', 'IE', True),\n", " ('37i9dQZEVXbLRmg3qDbY1H', 'Malaysia Viral 50', 'MY', True),\n", " ('37i9dQZEVXbMIO7B1pcKUy', 'Panama Viral 50', 'Global', True),\n", " ('37i9dQZEVXbJWZV7aRNQck', 'Dominican Republic Viral 50', 'Global', True),\n", " ('37i9dQZEVXbN7gfhgaomhA', 'Peru Viral 50', 'PE', True),\n", " ('37i9dQZEVXbJcpVBLdFV7m', 'Bulgaria Viral 50', 'Global', True),\n", " ('37i9dQZEVXbLo3yC8XJf1e', 'El Salvador Viral 50', 'Global', True),\n", " ('37i9dQZEVXbNF1heNYHDnE', 'Guatemala Viral 50', 'Global', True),\n", " ('37i9dQZEVXbM1qaaFAyPLz', 'Uruguay Viral 50', 'Global', True),\n", " ('37i9dQZEVXbKOefHPXPMyf', 'Costa Rica Viral 50', 'CR', True),\n", " ('37i9dQZEVXbJpRQ294oZ9N', 'Ecuador Viral 50', 'EC', True),\n", " ('37i9dQZEVXbKMzVsSGQ49S', 'Iceland Top 50', 'IS', False),\n", " ('37i9dQZEVXbINTEnbFeb8d', 'Japan Viral 50', 'JP', True),\n", " ('37i9dQZEVXbIPOivNiyjjS', 'Sweden Viral 50', 'SE', True),\n", " ('37i9dQZEVXbMQaPQjt027d', 'Netherlands Viral 50', 'NL', True),\n", " ('37i9dQZEVXbNwDVyEEfWV3', 'Romania Viral 50', 'Global', True),\n", " ('37i9dQZEVXbKxYYIUIgn7V', 'Austria Viral 50', 'Global', True),\n", " ('37i9dQZEVXbMBNcyQCfU4w', 'Finland Viral 50', 'FI', True),\n", " ('37i9dQZEVXbJx9hUtTN0Sj', 'Belgium Viral 50', 'BE', True),\n", " ('37i9dQZEVXbJ9SRaVj0yDF', 'Luxembourg Viral 50', 'Global', True),\n", " ('37i9dQZEVXbK4KA2JSuft7', 'Estonia Viral 50', 'Global', True),\n", " ('37i9dQZEVXbNBxnXSWuAcX', 'Cyprus Viral 50', 'Global', True),\n", " ('37i9dQZEVXbMjKD6qnoc8p', 'Malta Viral 50', 'Global', True),\n", " ('37i9dQZEVXbMHnoaLVkVuk', 'Iceland Viral 50', 'Global', True),\n", " ('37i9dQZEVXbMxjQJh4Um8T', 'Andorra Viral 50', 'Global', True),\n", " ('37i9dQZEVXbNGlbFNNXxgC', 'Israel Viral 50', 'Global', True),\n", " ('37i9dQZEVXbKGcyg6TFGx6', 'Luxembourg Top 50', 'Global', False),\n", " ('37i9dQZEVXbMBUm3g7j4Kb', 'Czech Republic Viral 50', 'Global', True),\n", " ('37i9dQZEVXbNjqq6Tw4Fb0', 'Switzerland Viral 50', 'Global', True),\n", " ('37i9dQZEVXbJVi45MafAu0', 'Singapore Viral 50', 'SG', True),\n", " ('37i9dQZEVXbJ7gPAehey5W', 'New Zealand Viral 50', 'Global', True),\n", " ('37i9dQZEVXbJ15VhfDPEzQ', 'Monaco Viral 50', 'Global', True),\n", " ('37i9dQZEVXbMD2H5HJqmx9', 'Malta Top 50', 'Global', False),\n", " ('37i9dQZEVXbNaCk6h5bujZ', 'South Africa Viral 50', 'Global', True),\n", " ('37i9dQZEVXbLDLOTfCtAUM', 'Lithuania Viral 50', 'Global', True),\n", " ('37i9dQZEVXbK3Iy2zvpfp4', 'Slovakia Viral 50', 'Global', True),\n", " ('37i9dQZEVXbKgCVIE0PTOD', 'Nicaragua Viral 50', 'Global', True),\n", " ('37i9dQZEVXbL1G1MbPav3j', 'Vietnam Viral 50', 'Global', True),\n", " ('37i9dQZEVXbNpKdqfZ9Upp', 'Honduras Viral 50', 'Global', True),\n", " ('37i9dQZEVXbK4NvPi6Sxit', 'India Viral 50', 'Global', True),\n", " ('37i9dQZEVXbKXd6qahcpCg', 'Hong Kong Viral 50', 'Global', True),\n", " ('37i9dQZEVXbMA8BIYDeMkD', 'Denmark Viral 50', 'DK', True),\n", " ('37i9dQZEVXbOcsE2WCaJa2', 'Norway Viral 50', 'NO', True),\n", "]" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "from collections import namedtuple" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "ViralChart = namedtuple('ViralChart', 'spyid name')" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "VIRALS = [ViralChart(c[0], c[1]) for c in ALL_CHARTS if c[3]]" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "len(VIRALS)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "```sql\n", "\n", "create table spotify_track_on_playlist (\n", " playlist_id varchar(30) character set latin1 not null,\n", " track_id varchar(30) character set latin1 not null,\n", " first_seen timestamp not null,\n", " last_seen timestamp not null,\n", " last_position int not null, \n", " primary key (playlist_id, track_id)\n", ")\n", "\n", "```\n" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "Playlist = namedtuple('ViralPlaylist', 'spyid name first_seen last_visited last_snapshot_id')\n", "Track = namedtuple('Track', 'spyid title last_popularity first_seen last_seen release_date isrc album_id album_type album_size first_artist second_artist')\n", "ArtistTrack = namedtuple('ArtistTrack', 'artist_id track_id')\n", "Artist = namedtuple('Artist', 'spyid name first_seen last_seen')\n", "PlaylistTracks = namedtuple('ViralPlaylistTracks', 'playlist_id as_of snapshot_id track_ids')\n", "TrackOnPlaylist = namedtuple('TrackOnPlaylist', 'playlist_id track_id first_seen last_seen last_position')\n", "\n", "\n", "\n", "def db_safe(val):\n", " if isinstance(val, list):\n", " return \",\".join([str(x) for x in val])\n", " return val\n", "\n", "def upsert(tablename, datarows, column_names=None, immut_columns=('id', 'first_seen', 'release_date')):\n", "\n", " if len(datarows) == 0:\n", " print(f\"No rows to upsert for {tablename}\")\n", " return\n", " \n", " print(f\"upserting {tablename}\") \n", " if column_names is None:\n", " # try a namedtuple....\n", " column_names = datarows[0]._fields\n", " \n", " assert len(column_names) == len(datarows[0])\n", " \n", " col_csv = \", \".join(column_names)\n", " row_pct = \"(\" + (\",\".join(['%s'] * len(column_names))) + \")\"\n", " pcts = \",\\n\".join([row_pct] * len(datarows))\n", " \n", " \n", " updates = \", \\n\".join([f'{col}=VALUES({col})' for col in column_names if col not in immut_columns])\n", " if updates:\n", " on_dupe = f'on duplicate key update \\n{updates}'\n", " else:\n", " on_dupe = ''\n", " \n", " sql = f'''\n", " insert into {tablename}\n", " ({col_csv})\n", " values\n", " {pcts}\n", " {on_dupe}\n", " '''\n", " \n", " args = [db_safe(v) for row in datarows for v in row]\n", " \n", " with get_cursor(True) as cur:\n", " cur.execute(sql, args)\n", "\n", "def query(sql, args=None):\n", " '''select a, b, c -> [(a1, b1, c1), (a2, b2, c), ....]'''\n", " with get_cursor() as cur:\n", " cur.execute(sql, args)\n", " return list(cur.fetchall())\n", "\n", "\n", "def query_one(sql, args=None):\n", " '''select a, b, c -> (a1, b1, c1) // returns the first row tuple'''\n", " res = query(sql, args)\n", " return res[0] if len(res) > 0 else None\n", "\n", "\n", "def query_single_column(sql, args=None):\n", " '''select a -> [a1, a2, a3,...] // returns first column not as tuples'''\n", " res = query(sql, args)\n", " return [r[0] for r in res]\n", "\n", "\n", "def query_single_value(sql, args=None):\n", " '''select a -> a1 // first row's first column not as list or tuple'''\n", " res = query_one(sql, args)\n", " return res[0] if res else None\n", "\n", "\n", "def get_table_name(rows, prefix='spotify_'):\n", " typename = type(rows[0]).__name__.split('.')[-1]\n", " snakename = typename[0].lower() + \"\".join([\n", " '_'+c.lower() if c != c.lower() else c\n", " for c in typename[1:]\n", " ])\n", " return prefix + snakename\n", "\n", "\n", "def query_dicts(sql, args=None):\n", " with get_cursor() as cur:\n", " cur.execute(sql, args)\n", " cols = [c[0] for c in cur.description]\n", " return [\n", " dict(zip(cols, r))\n", " for r in cur.fetchall()\n", " ]\n", "\n", "def std_upsert(datarows):\n", " if len(datarows) == 0:\n", " print(f\"No rows to upsert for {tablename}\")\n", " return\n", " \n", " upsert(get_table_name(datarows), datarows)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "conn = pymysql.connect(**conn_kwargs)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "cur = conn.cursor()" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "query_dicts('select * from spotify_track limit 3')" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "cur?" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "from tracker.utils import chunks\n", "\n", "def parse_playlist_result(playlist_json):\n", " utcnow = datetime.utcnow()\n", " playlist = Playlist(\n", " spyid=playlist_json['id'], \n", " name=playlist_json['name'], \n", " first_seen=utcnow,\n", " last_visited=utcnow, \n", " last_snapshot_id=playlist_json['snapshot_id']\n", " )\n", " track_ids = []\n", " tracks = {}\n", " artist_tracks = []\n", " artists = {}\n", " for item in playlist_json['tracks']['items']:\n", " track_obj = item['track']\n", " if not track_obj:\n", " print(\"Skipping removed track\")\n", " continue\n", " track_id = track_obj['id']\n", " track_ids.append(track_id)\n", " album = track_obj['album']\n", " these_artists = [Artist(a['id'], a['name'], first_seen=utcnow, last_seen=utcnow) for a in track_obj['artists']]\n", " tracks[track_id] = Track(\n", " spyid=track_id,\n", " first_seen=utcnow,\n", " last_seen=utcnow,\n", " title=track_obj['name'],\n", " last_popularity=track_obj['popularity'],\n", " release_date=album['release_date'] if len(album['release_date']) == 10 else None,\n", " isrc=(track_obj.get('external_ids') or {}).get('isrc'),\n", " first_artist=these_artists[0].spyid,\n", " second_artist=these_artists[1].spyid if len(these_artists) > 1 else None,\n", " album_id=album['id'],\n", " album_type=album['album_type'],\n", " album_size=album['total_tracks'],\n", " )\n", " artists.update({a.spyid: a for a in these_artists})\n", " artist_tracks.extend([ArtistTrack(artist_id=a.spyid, track_id=track_id) for a in these_artists])\n", " playlist_tracks = PlaylistTracks(\n", " playlist_id=playlist.spyid, \n", " snapshot_id=playlist.last_snapshot_id,\n", " as_of=utcnow, \n", " track_ids=track_ids\n", " )\n", " tracks_on_playlist = [\n", " TrackOnPlaylist(\n", " playlist_id=playlist.spyid,\n", " track_id=tid,\n", " first_seen=utcnow,\n", " last_seen=utcnow,\n", " last_position=i+1\n", " ) for i, tid in enumerate(track_ids)\n", " ]\n", " \n", " return playlist, playlist_tracks, artist_tracks, tracks, artists, tracks_on_playlist\n", "\n", "\n", "\n", "def get_snapshot_if_exists(playlist_spyid):\n", " with get_cursor() as cur:\n", " cur.execute('select last_snapshot_id from spotify_viral_playlist where spyid = %s', [playlist_spyid])\n", " res = cur.fetchone()\n", " return res[0] if res else None\n", "\n", "def process_chart(chart: ViralChart, skip_snapshot_check=False):\n", " sp = spotify._authenticate()\n", " res = sp.playlist(chart.spyid)\n", " playlist, *rest = parse_playlist_result(res)\n", "\n", " last_snapshot = get_snapshot_if_exists(playlist.spyid)\n", " if not skip_snapshot_check and playlist.last_snapshot_id == last_snapshot:\n", " print(f\"No update to {playlist.name} based on snapshot\")\n", " else:\n", " print(f\"{playlist.name} is updated.\")\n", " std_upsert([playlist])\n", "\n", " for item in rest:\n", " if isinstance(item, list):\n", " std_upsert(item)\n", " elif isinstance(item, dict):\n", " std_upsert(list(item.values()))\n", " else:\n", " std_upsert([item])\n", "\n", " \n", "\n", "def run_for_charts(charts):\n", " for chart in charts:\n", " print(f\"Processing: {chart}\")\n", " process_chart(chart)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "run_for_charts(VIRALS)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "chart = VIRALS[0]\n", "sp = spotify._authenticate()\n", "res = sp.playlist(chart.spyid)\n", "playlist, playlist_tracks, *rest = parse_playlist_result(res)\n", "existing = query_single_value('select track_ids from spotify_viral_playlist_tracks where playlist_id = %s', [chart.spyid])\n", "\n", "diffs = [f for f,g in list(zip([s for s in existing.split(',')], playlist_tracks.track_ids)) if f != g]\n", "\n", "print(f'Diffs for {chart.name}: {diffs}')" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "def get_new_adds():\n", " return query('''\n", " select spyid, album_id, first_artist \n", " from spotify_track \n", " where first_seen > date_sub(now(), interval 2 hour)\n", " ''')\n", "\n", "added_today = get_new_adds()" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "len(added_today)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Albums" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "Album = namedtuple('Album', 'spyid first_seen last_seen release_date size type p_line c_line label_code is_signed')\n", "\n", "def to_album(json_data, utcnow) -> Album._fields:\n", " label_class = spotify.classify_label(json_data)\n", " \n", " return Album(\n", " spyid=json_data['id'],\n", " first_seen=utcnow,\n", " last_seen=utcnow,\n", " release_date=json_data['release_date'] if json_data['release_date_precision'] == 'day' else None,\n", " size=json_data['total_tracks'],\n", " type=json_data['album_type'],\n", " p_line=next((c['text'] for c in json_data['copyrights'] if c['type'].lower() == 'p'), None),\n", " c_line=next((c['text'] for c in json_data['copyrights'] if c['type'].lower() == 'c'), None),\n", " label_code=label_class.split('-')[-1] if label_class else None,\n", " is_signed=label_class is not None,\n", " )" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "def store_albums(album_ids):\n", " spy = spotify._authenticate()\n", " utcnow = datetime.utcnow()\n", " for chunk in chunks(album_ids, 20):\n", " res = spy.albums(chunk)\n", " std_upsert([to_album(a, utcnow) for a in res['albums']])\n", " import time; time.sleep(1)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "albs = list(set([r[1] for r in added_today]))" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "len(albs)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "store_albums(albs)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Add monthly listener scraping" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "from tracker.spotify import _scrape_artist_page_to_json, _uri_to_id\n", "from collections import namedtuple" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "ArtistListeners = namedtuple(\n", " 'ArtistListeners', '''\n", " spyid\n", " last_updated\n", " global_chart_position\n", " monthly_listeners\n", " monthly_listeners_delta\n", " playlist0_spyid\n", " playlist0_listeners\n", " playlist1_spyid\n", " playlist1_listeners\n", " playlist2_spyid\n", " playlist2_listeners\n", " city0_name\n", " city0_region\n", " city0_country\n", " city0_listeners\n", " city1_name\n", " city1_region\n", " city1_country\n", " city1_listeners\n", " city2_name\n", " city2_region\n", " city2_country\n", " city2_listeners'''\n", ")" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "def fetch_listeners(spyid):\n", " utcnow = datetime.utcnow()\n", " web_page_data = _scrape_artist_page_to_json(spyid)\n", " insights = web_page_data['insights']\n", "\n", " cities = insights.get('cities') or []\n", " playlists = (\n", " insights['playlists']['entries'] \n", " if insights.get('playlists') and insights.get('playlists').get('entries') else []\n", " )\n", "\n", " top_cities = sorted(cities, key=lambda c: c['listeners'], reverse=True)[0:3]\n", " top_playlists = sorted(playlists, key=lambda c: c['listeners'], reverse=True)[0:3]\n", " \n", " insert_data = {f: None for f in ArtistListeners._fields}\n", " \n", " insert_data.update({\n", " 'spyid': spyid,\n", " 'last_updated': utcnow,\n", " 'global_chart_position': insights.get('global_chart_position') or 0,\n", " 'monthly_listeners': insights.get('monthly_listeners') or 0,\n", " 'monthly_listeners_delta': insights.get('monthly_listeners_delta') or 0,\n", " })\n", "\n", " if len(top_cities) > 0:\n", " insert_data.update(dict(\n", " city0_name=top_cities[0]['city'],\n", " city0_region=top_cities[0]['region'],\n", " city0_country=top_cities[0]['country'],\n", " city0_listeners=top_cities[0]['listeners'],\n", " ))\n", " if len(top_cities) > 1:\n", " insert_data.update(dict(\n", " city1_name=top_cities[1]['city'],\n", " city1_region=top_cities[1]['region'],\n", " city1_country=top_cities[1]['country'],\n", " city1_listeners=top_cities[1]['listeners'],\n", " ))\n", " if len(top_cities) > 2:\n", " insert_data.update(dict(\n", " city2_name=top_cities[2]['city'],\n", " city2_region=top_cities[2]['region'],\n", " city2_country=top_cities[2]['country'],\n", " city2_listeners=top_cities[2]['listeners'],\n", " ))\n", " if len(top_playlists) > 0:\n", " insert_data.update(dict(\n", " playlist0_spyid=_uri_to_id(top_playlists[0]['uri']),\n", " playlist0_listeners=top_playlists[0]['listeners'],\n", " ))\n", " if len(top_playlists) > 1:\n", " insert_data.update(dict(\n", " playlist1_spyid=_uri_to_id(top_playlists[1]['uri']),\n", " playlist1_listeners=top_playlists[1]['listeners'],\n", " ))\n", " if len(top_playlists) > 2:\n", " insert_data.update(dict(\n", " playlist2_spyid=_uri_to_id(top_playlists[2]['uri']),\n", " playlist2_listeners=top_playlists[2]['listeners'],\n", " ))\n", "\n", " return ArtistListeners(**insert_data)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "def store_listeners(artist_spyids):\n", " for i, spyid in enumerate(artist_spyids):\n", " print(i, spyid)\n", " ml = fetch_listeners(spyid)\n", " std_upsert([ml])\n", " import time; time.sleep(10)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "track_spyids_arg = \",\".join([repr(r[0]) for r in added_today])" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "track_spyids_arg" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "needing_listeners = query_single_column(f'''\n", " select distinct t.first_artist\n", " from spotify_track t\n", " join spotify_album a on a.spyid = t.album_id\n", " left join spotify_artist_listeners sal on t.first_artist = sal.spyid\n", " where not is_signed\n", " and sal.spyid is null\n", " and upper(substring(isrc, 1, 2)) not in (\n", " 'MX', 'BR', 'CL', 'TR', 'SG', 'JP', 'ID', 'TH', 'TW', 'AR', 'PE', 'PH',\n", " 'IN', 'CO', 'MY', 'MA', 'UY', 'GT', 'DO', 'CR', 'VN', 'PA', 'PY', 'SA',\n", " 'EC', 'EG', 'TN', 'HK', 'DZ', 'BO', 'JO', 'MT'\n", " )\n", " and t.spyid in ({track_spyids_arg})\n", " order by t.first_seen desc\n", " '''\n", ")" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "len(needing_listeners)" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "scrolled": true }, "outputs": [], "source": [ "store_listeners(needing_listeners)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "inlist = \",\".join([repr(i) for i in visited_spyids])\n", "count = query_single_value(f'''\n", "select count(*) from spotify_artist_listeners where spyid in ({inlist})\n", "''')" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "count" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### New adds" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "columns = [\n", " 'track_id',\n", " 'link',\n", " 'artist_id',\n", " 'title',\n", " 'artist name',\n", " 'released',\n", " 'monthly listeners',\n", " 'monthly listeners delta',\n", " 'p line',\n", " 'release country',\n", "# 'isrc',\n", " 'first seen days ago',\n", " 'num playlists',\n", " 'playlists',\n", "]" ] }, { "cell_type": "code", "execution_count": 34, "metadata": {}, "outputs": [], "source": [ "EXCLUDED_COUNTRIES = \",\".join([repr(c) for c in [\n", " 'MX', 'BR', 'CL', 'TR', 'SG', 'JP', 'ID', 'TH', 'TW', 'AR', 'PE', 'PH',\n", " 'IN', 'CO', 'MY', 'MA', 'UY', 'GT', 'DO', 'CR', 'VN', 'PA', 'PY', 'SA',\n", " 'EC', 'EG', 'TN', 'HK', 'DZ', 'BO', 'JO', 'MT'\n", "]])\n" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "sql = f'''\n", " select\n", " st.spyid,\n", " concat('https://open.spotify.com/track/', st.spyid) as link,\n", " st.title,\n", " sa.name,\n", " st.release_date,\n", " sal.monthly_listeners,\n", " sal.monthly_listeners_delta,\n", " coalesce(alb.p_line, alb.c_line) as p_line,\n", " upper(substring(st.isrc, 1, 2)) as release_country,\n", " -- st.isrc,\n", " sad.tsdata as daily_streams,\n", " sad.s0 as last_streams,\n", " sad.smax as max_daily,\n", " current_date - sad.smax_date as max_streams_days_ago,\n", " current_date - cast(st.first_seen as date) first_seen_days_ago,\n", " count(*) as num_viral_adds,\n", " group_concat( replace(svp.name, ' Viral 50', '') ) as playlists\n", " from spotify_track_on_playlist top\n", " join spotify_track st on st.spyid = top.track_id\n", " join spotify_viral_playlist svp on svp.spyid = top.playlist_id\n", " join spotify_artist sa on st.first_artist = sa.spyid\n", " join spotify_album alb on alb.spyid = st.album_id\n", " join spotify_artist_listeners sal on sa.spyid = sal.spyid\n", " left join spotify_daily_streams sad on sad.spyid = st.first_artist\n", " \n", " where st.first_seen > date_sub(now(), interval %s hour)\n", " and not is_signed\n", " and sal.monthly_listeners_delta > -100\n", " and sal.monthly_listeners between 5000 and 2000000\n", " and upper(substring(isrc, 1, 2)) in (\n", " select isrc_code from country_settings where is_source_for_releases\n", " )\n", " group by 1\n", " order by st.first_seen desc\n", " '''\n", "hours=5\n", "\n" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "sql = f'''\n", " select\n", " st.spyid,\n", " concat('https://open.spotify.com/track/', st.spyid) as link,\n", " st.title,\n", " sa.name,\n", " st.release_date,\n", " sal.monthly_listeners,\n", " sal.monthly_listeners_delta,\n", " coalesce(alb.p_line, alb.c_line) as p_line,\n", " upper(substring(st.isrc, 1, 2)) as release_country,\n", " -- st.isrc,\n", " sad.tsdata as daily_streams,\n", " sad.s0 as last_streams,\n", " sad.smax as max_daily,\n", " current_date - sad.smax_date as max_streams_days_ago,\n", " current_date - cast(st.first_seen as date) first_seen_days_ago,\n", " count(*) as num_viral_adds,\n", " group_concat( replace(svp.name, ' Viral 50', '') ) as playlists\n", " from spotify_track_on_playlist top\n", " join spotify_track st on st.spyid = top.track_id\n", " join spotify_viral_playlist svp on svp.spyid = top.playlist_id\n", " join spotify_artist sa on st.first_artist = sa.spyid\n", " join spotify_album alb on alb.spyid = st.album_id\n", " join spotify_artist_listeners sal on sa.spyid = sal.spyid\n", " left join spotify_daily_streams sad on sad.spyid = st.first_artist\n", " \n", " where st.first_seen > date_sub(now(), interval %s hour)\n", " and not is_signed\n", " and sal.monthly_listeners_delta > -100\n", " and sal.monthly_listeners between 5000 and 2000000\n", " and upper(substring(isrc, 1, 2)) in (\n", " select isrc_code from country_settings where is_source_for_releases\n", " )\n", " group by 1\n", " order by st.first_seen desc\n", " '''\n", "hours=5" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [], "source": [ "from tracker import sheet, bangers" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [], "source": [ "from tracker.bangers import query_to_sheet" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [], "source": [ "import csv\n", "\n", "def convert_tsdata(row, columns):\n", " row = list(row)\n", " sparkline_ix = columns.index('daily_streams')\n", " if row[sparkline_ix]:\n", " row[sparkline_ix] = [r[1] for r in csv.reader(row[sparkline_ix].splitlines()) if r[1] != 'num']\n", " return row[1:] # drop the spyid column\n", "\n", "def snake_to_title(name):\n", " return \" \".join([w.title() for w in name.split('_')])\n", "\n", "def get_sheet_csv(sql, args=None):\n", " with mysql.get_cursor() as cur:\n", " cur.execute(sql, args)\n", " columns = [c[0] for c in cur.description]\n", " newly_added = [convert_tsdata(r, columns) for r in cur.fetchall()]\n", "\n", " header = [snake_to_title(c) for c in columns[1:]]\n", " print(f\"Found {len(newly_added) - 1} artists\")\n", " return [header] + [list(r) for r in newly_added]\n", "\n", "def get_artist_sheet_csv(artist_spyids):\n", " spyids_args = \",\".join([repr(s) for s in artist_spyids])\n", " return get_sheet_csv(f'''\n", " select\n", " st.spyid as spyid,\n", " concat('https://open.spotify.com/track/', st.spyid) as link,\n", " st.title,\n", " sa.name,\n", " st.release_date,\n", " sal.monthly_listeners,\n", " sal.monthly_listeners_delta,\n", " coalesce(alb.p_line, alb.c_line) as p_line,\n", " upper(substring(st.isrc, 1, 2)) as release_country,\n", " -- st.isrc,\n", " sad.tsdata as daily_streams,\n", " sad.s0 as last_streams,\n", " sad.smax as max_daily,\n", " datediff(current_date, sad.smax_date) as max_streams_days_ago,\n", " datediff(current_date, st.first_seen) as first_seen_days_ago,\n", " count(distinct svp.name) as num_viral_adds,\n", " group_concat( replace(svp.name, ' Viral 50', '') ) as playlists\n", " from spotify_artist sa \n", " join spotify_track st on st.first_artist = sa.spyid\n", " join spotify_album alb on alb.spyid = st.album_id\n", " left join spotify_track_on_playlist top on st.spyid = top.track_id\n", " left join spotify_viral_playlist svp on svp.spyid = top.playlist_id\n", " left join spotify_artist_listeners sal on sa.spyid = sal.spyid\n", " left join spotify_daily_streams sad on sa.spyid = sad.spyid \n", " where sa.spyid in ({spyids_args})\n", " and not is_signed\n", " group by 1\n", " order by st.first_seen desc\n", " ''')\n", "\n", "def create_sheet_for_artists(artist_spyids, sheet_name=None, spr=None):\n", " if spr is None:\n", " sh = sheet.Sheet()\n", " spr = sh.client.open('Viral Adds')\n", " sheet_csv = get_artist_sheet_csv(artist_spyids)\n", " return query_to_sheet.csv_to_sheet(sheet_csv, spr, sheet_name=sheet_name)" ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [], "source": [ "#spr.share('joel@whtlst.in', perm_type='user', role='writer', notify=False)" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [], "source": [ "arts = mysql.query_single_column(\n", " '''select spyid from spotify_daily_streams \n", " where cast(first_date as date) >= date_sub(current_date, interval 7 day)''')" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['05KeKcvDkuqjtgp2IZcfco',\n", " '07QESImfxfUZRhSxsPAnEv',\n", " '0bhbJosHyBjBOw4o5QUb0V',\n", " '0BRqvQoxmmLexIg5tsOeBb',\n", " '0DdDnziut7wOo6cAYWVZC5',\n", " '0DnbOatBnP7UDkeiQACgxd',\n", " '0EHYuPn9Xng2lZP2cfz4cV',\n", " '0gGd4WhPXBSgDX6fdOHcOw',\n", " '0kSzgSZrcCMcniVcIynswT',\n", " '0m5FakHKCQdA7UN0PIzMcL',\n", " '0MsH4wFbCN1xoKXGJlWuo2',\n", " '0mXTJETA4XUa12MmmXxZJh',\n", " '0oJmDwK2QxYDXfkdlTvc4C',\n", " '0OluGbRuQQEcYyttGww517',\n", " '0OmIOUU8SceGFVrqrEm70j',\n", " '0sYlth2PW1zWJMEU2vCukz',\n", " '0UOrkpzPED604dKzxgfJqg',\n", " '0UTzLuwz9RvFOCnwAZjUxn',\n", " '0vTetVoy09JHDMYGBgnwuQ',\n", " '0ZkJ54ZnjZt0ZuoQpXbR8U',\n", " '0zX0CnUqQpJKrwLhgLMN3N',\n", " '11jTIrOwxFOLvhJIdb4FYo',\n", " '12AnGvqOxseM5VJLyO5yBs',\n", " '14QPRrwRDAiUhdGC6D3VpE',\n", " '14YDWSgNTuQ9zHNiB2xq83',\n", " '17vcSw40ZyiruoeNtuOPM0',\n", " '1AUZYkS7eLmZUnBjQyJmwf',\n", " '1BkYFAwH5LYzZQHQRWkQ4i',\n", " '1dsilrkrvxXE6I02SWfDYD',\n", " '1DxLCyH42yaHKGK3cl5bvG',\n", " '1Fg19vpUJpAAPFjnKaVYVW',\n", " '1GI8IChPP8ffQwl1ETaBb9',\n", " '1GyfNm3xj64IZR4rKnzNti',\n", " '1H6jTzPmJTIZLfxQ26iYqE',\n", " '1hEew8IFcwMc0gpMyHJm8u',\n", " '1HhtxROran5HmdjnuIawzp',\n", " '1IdkKQ9CM1i0wygfxYV4Z3',\n", " '1IKP8dm7pmlkZS4V4MzKkI',\n", " '1iPKB0JFpcrkPkyof4pAdv',\n", " '1jsB2W4c9zTq9ilGXegrDM',\n", " '1KfRf4VkEYpL2G0FTWb7JX',\n", " '1lhFyyRRWH7llPdQGIhXYD',\n", " '1LMyTeRhjaitILs98h3MaF',\n", " '1noWnd8QFQD9VLxWEeo4Zf',\n", " '1oR9k6INbjcgqbBMtiOCJU',\n", " '1QL7yTHrdahRMpvNtn6rI2',\n", " '1RDmz5jLTAyj9onvIA4qv8',\n", " '1rNNeas60ogZm9uhv1VZOh',\n", " '1sEGUJyocmOnW6emzgoHMM',\n", " '1sJbXvN5tJwsn9JQuM8fTo',\n", " '1sldhz8tzC100cRAdfnMht',\n", " '1srm08CX3SDOBR40CQPH0J',\n", " '1t8a5iaDp83vi65VtHLVpl',\n", " '1TEtmERaKcUQI5zraIA1Je',\n", " '1W3FSF1BLpY3hlVIgvenLz',\n", " '1x6N4tQft8TwRuhOfRUgWC',\n", " '1Yyag4BRejtPxsKTrSkKDz',\n", " '1zh9JkZhBzTtkd2WztHgmt',\n", " '220SaLUhEtl59oRglesxcL',\n", " '2563ILWHSx52eOxOoi5rJW',\n", " '25UNJbwGZSQKvz5cPLWlv3',\n", " '26JloX1vHxGGrGUVeMItFJ',\n", " '2AWUCT9xtcvkjpFq1ZgpPj',\n", " '2cMTqhE7xY6oXmfiRhbiSk',\n", " '2CtyJZjJ1IAaChE7Lmx5Ga',\n", " '2GoeZ0qOTt6kjsWW4eA6LS',\n", " '2h3ZcRa4CSTILfWC4RRgZJ',\n", " '2jGvmFH6YE352p9LKmuB0y',\n", " '2kTb8aNeiYJt6qAOG4JsrF',\n", " '2nwPBvsuf070C7KYSWoXbD',\n", " '2O8Fgh14LT9QBGfFM5q5Rb',\n", " '2OTfhbxhBO1u1bAuCy6ouu',\n", " '2P1h10tRBVlC2lVUqhl6wm',\n", " '2qgmmxh9BoVRm6j18CnSYm',\n", " '2QUvtLq6oQaX0LNsYY2fas',\n", " '2sjnyyL9NXijL3Fr2eLikf',\n", " '2t8MqmLfhytnTWXJHQkRSM',\n", " '2Tk0pWxTuQgnE5nsUexrLr',\n", " '2u4xMsh0M2B7R8Wb3pEWae',\n", " '2VsTgQUocqoaXjLG5YerlB',\n", " '2w9zwq3AktTeYYMuhMjju8',\n", " '2xGCGoulmU85qYdpb2Z4xx',\n", " '2Y3kRJYYun9lDcRMM7ulQg',\n", " '30BSBWLKnYJION1lCPugXc',\n", " '37awA8DFCAnCCL7aqYbDnD',\n", " '38SWPOPO1YqxUPnT4AAoID',\n", " '38u18VoGaIwVeSyVoA0eU5',\n", " '39sUQ6z3CTsNB4BhBecLOg',\n", " '3aROeSNBd69DWHpcyyMOcI',\n", " '3BifJ2eD9KMFgAGa8LbPtI',\n", " '3CDZrQx4ddOOez8oxkY6Ig',\n", " '3crnzLy8R4lVwaigKEOz7V',\n", " '3d13oWvwmjcodRr3NzdArc',\n", " '3dayhmhJfL4I8w1PuL9MqQ',\n", " '3E4OJ0ZqhQJti8OiSxfxUN',\n", " '3eZXi1et2XpXPD7PoUDDzE',\n", " '3FvETENOtMuQV4dKhXCQKD',\n", " '3FwNjtXQCdxpDOXmgJQGnG',\n", " '3h3LGRApFzJhSbvclBMkLE',\n", " '3HXLY1sNXIxHfulrjPiRf5',\n", " '3IZxs4ZukiitIk8vkAPAxC',\n", " '3jpPlA4ASvE9TlObazOIee',\n", " '3LaBw0YCv8D35w9AvePFtF',\n", " '3NIZFmehJM8YiGpCdihlck',\n", " '3Nvjwz6gDry7Uume9kjCBT',\n", " '3p2pMpzDerhMR4w2xZyHWg',\n", " '3Pio0pbDUVZNd9fQOJEPpg',\n", " '3Skc9QXX1LHDaLeHIBKkWQ',\n", " '3uIfha7lvdSsoFeJNJS3vJ',\n", " '3wayc8vDx8ukvWV17IBZE1',\n", " '3WgX9Ioo1Qcug9H0tNmmUH',\n", " '3wqNVw34Ut3ABp7fej8FSR',\n", " '3XbtJ4U0wuYnOUpEr73ru4',\n", " '3Z8221k9q4oLkXUEuizRJP',\n", " '3ZKUFIrYS6aAgIxu5AfTX5',\n", " '3zMBw1jxFritUP7Mpce68i',\n", " '40HDiLfKm0tXk2FxlJx6aO',\n", " '4225vUKDHwHhcYY9IRWwX0',\n", " '42qy7l7d3qDiovQ0fxQRRe',\n", " '45b70w0HEIshoMZiGvFN61',\n", " '47i4noBzl5Os351Qlmxuia',\n", " '47IdumnUeVozInz0gfdk6o',\n", " '48QpIkzC2yRCUCvNvOVZqD',\n", " '4aFx7q4WkiTWPLJNW5mkKK',\n", " '4aNZYL0FCIl9zzPMC6yvEZ',\n", " '4BKC2HOGEqtYz2Xbgp9N1q',\n", " '4bl3n48f31CUJkAvofDiVg',\n", " '4CKIGHCZRzNoiNDSaW5eaq',\n", " '4f5V3PQ66nIrBCqugJtaGn',\n", " '4FH6xGueB6CRmiEdtPnu41',\n", " '4gQEXxzqwNmQwjU0Wc0Ioe',\n", " '4HoeFhWFsstq8FvaPe6rSQ',\n", " '4HozTjFfieqgVzmsn5CK5a',\n", " '4i70orTITjlYP1lDoHPsZr',\n", " '4IC2X34tZmHG3VfTbpzvwL',\n", " '4IdNUGAtqlYjfXNx4ktplO',\n", " '4jtv7mIerRdHNQOkFtKyDW',\n", " '4L5QHhmkOdVWH91Kz0uLPg',\n", " '4mErKO4g29SXtBwj4S80aB',\n", " '4MgA2G0NoAMdcFBaK5ZAfw',\n", " '4MR6tQyIrWK82b56cYPBDv',\n", " '4nu1h45niRUoPEoeXnHH7p',\n", " '4o6vIkdmHiEXZOesrJj3KO',\n", " '4OaSyxqlkp7aVpAZwF02QZ',\n", " '4oPYazJJ1o4rWBrTw9lm40',\n", " '4pOglqMAavrWFo20ORRx5w',\n", " '4psozRvxjEJEOANLHTwA7J',\n", " '4QHjJWgPhculd31AHEsjOb',\n", " '4rsSvru4JQWSjP7SfxUCid',\n", " '4sGgnHfL5rjJqK5WxQl9bU',\n", " '4srslZ2sGZ7GQoikELwXsX',\n", " '4tNdafEbEWT8PfSHSjP9zx',\n", " '4TS37lr3ZraUxBHS727sEp',\n", " '4u1nYxjl132D6rcMeYQ6Zz',\n", " '4UGA0TDpRVVt2SCz8FZOMm',\n", " '4uiMn2g0pgTrhN096QJhbp',\n", " '4UuICMmKQKNyCJfBg6lFFD',\n", " '4VVEpEhC8NcR7AqNEds42U',\n", " '4W3fa7tiXGVXl3KilbACqt',\n", " '4wk2Ga6EdKuBvjWDbJgWzg',\n", " '4zOhMWD0LoBe2nP7s9cHhX',\n", " '506Thef5DTWpeFlL88CdNX',\n", " '514w90CKIw9w84Zh3NSNyA',\n", " '51aWHhJ7AjxKmZ4dDUc0sm',\n", " '51yyeVxyvecgePAWXmeLUE',\n", " '524rbl9t4PcNkv2PjItZw0',\n", " '53xwq54syWZgXoordzYUnA',\n", " '5Aixh4wA2Q2e2fjVsNl4FC',\n", " '5bVwCv4C9KQXdUVTCVSjy4',\n", " '5c1T1hZNinExpQD99XP5zB',\n", " '5cVZnnikhcTwPENYemDKF6',\n", " '5DSVjHy2YWufmRUHBM3PLX',\n", " '5Eqs8CFkMm9goeiSRvtc17',\n", " '5Exvb6CXfgIb7sYwvzO7pS',\n", " '5F73ZVq8ivLhsYF2pGg4Fc',\n", " '5FgjaJZKmTjnJyfvE3UU2C',\n", " '5FltlsNXcB1hNGvSCwzGhx',\n", " '5fOlvCMHLP0XxXDMbe2T1i',\n", " '5IbEL2xjRtKsunfmsahLuO',\n", " '5IvJzgDwTyF6fEcZUEkVxR',\n", " '5Jwz2Uzhk06OKiiUwngnyW',\n", " '5kt4v3JNtP8svtTI8PDFOT',\n", " '5L88UL7xuw4CzYyzxqwgBz',\n", " '5lQTiEDGcwZhSzNdzHDPsy',\n", " '5lYeiQxUTcGKVgAuTqbTeL',\n", " '5Njezu4xqAnJWdyzDf5gW7',\n", " '5ou3jxRm9LFgxvuZij5LBT',\n", " '5pjp3kifXk55dcYaooLpZe',\n", " '5pOYIshq4ZLnVBEuw8sF6f',\n", " '5pWUVnrc1y0FpWZ6VCy0Hg',\n", " '5pzb04LnJQrbs8U6qQ6KxC',\n", " '5RHWqLCNmcKFDME3G7sxiJ',\n", " '5sK8BsvyDl4TFA6KaBf8or',\n", " '5szdY7KaSi7epwyffrbV8c',\n", " '5tqcGCzAJeX4ysqiegDC37',\n", " '5u4ozdMUTJLCJPYkFVoy0o',\n", " '5UUsQ38YTugFjdLX82IDAE',\n", " '5vmUq7Y6ysFa40JktRgQWl',\n", " '5VyXOfvTQljStUXx1coETY',\n", " '5w0OByoAbNVg7eco8JQwid',\n", " '5WDOXIkjKNjEzlXmLgZVz9',\n", " '5wTAi7QkpP6kp8a54lmTOq',\n", " '5ypEYwWaSgtjBPCPcredFM',\n", " '5ZCOgPpZNvlJEBnUZnDqW8',\n", " '5ZdWGWlHFXgo51ouiol6hl',\n", " '60KR2lVVoYd6GIcfLoUjPI',\n", " '66OYzK2q18j4EVdMqRtf6L',\n", " '68X9nXuSoKCVxT5bVjaTUm',\n", " '6a2V6IHS7jT9M1IvJ8V3yB',\n", " '6agSBzJ9kJnlglVc271CLD',\n", " '6BdSOHfQ6kMg0tbAFlXR1z',\n", " '6cpj6MeLF0pLx34Un9Bpj3',\n", " '6d4AePmkVnbu2qIbT6vsem',\n", " '6EIriUxo7vznEgJtTDlXpq',\n", " '6EL5GD53kaaVgJCHgdtdLz',\n", " '6fHE8xZBCxzwer9DIbOmv4',\n", " '6jVOHz5AjBoJImzesvZeGx',\n", " '6L5bLEtpxwd0KOdOr3gtW4',\n", " '6mkRgafSHF30Dr2wEch4YU',\n", " '6nhsSK9KbToX3Brq0xeWbV',\n", " '6owH8F2INpb18PhnISiVh2',\n", " '6p2442ymrT9lZEuCZJdYcH',\n", " '6PsS5unEiFNKVEFMu3Vq2D',\n", " '6q1sTU51oryTTcWTPTd0VC',\n", " '6QZvn1e3UtnFP0wMqq6ggl',\n", " '6RHKEd9dpzQ4c09x8Zdaxu',\n", " '6RJbFqgnnHvQcq8TGdCIn2',\n", " '6rYEqmajzlhGVaayOJ2bpJ',\n", " '6SfPAcR67ssVyMQWoizN7Q',\n", " '6slyJwua5e5GuhuP82sTHR',\n", " '6T8S4zSY1ICYEG50Hgs3QJ',\n", " '6tJRAxu0HwB2GI9GueEj4l',\n", " '6VjsMdMAIrpFjxtpz5VEUp',\n", " '6ybd4tPF7McLj3BNhZavQi',\n", " '6ZqX1hMl57m51iWusfz1CU',\n", " '71Cy7nzbfpuGJAS5FGxm93',\n", " '73LjFn4z6WTV7MevyPxrRc',\n", " '759Wbu0yM5VsYUEFnWcYHY',\n", " '76oqoGaknr9WGOegYTjxdh',\n", " '79jKLAo2K6B8owRoRgTW8y',\n", " '7AiFAkvE8VYLDdsmLC78ik',\n", " '7ANf7tAnPESElMa8bUTMmd',\n", " '7aVpHHpAZUygyQChfGxPz6',\n", " '7BgEOZ9w3Y4IMShXTMu1nN',\n", " '7c34Wg8HcWO9BWhHLwiXsr',\n", " '7cjh6y0V9SsyCrWSXTzwOs',\n", " '7eILArMiTFTQf8SEh5fFHK',\n", " '7EnLmrL4jTZKjeseaZyA0L',\n", " '7F8ZcsMcpKLO4U7J4pqkpy',\n", " '7fFoO8E3rLkTJBItdhAwCy',\n", " '7FiAkNWMb6ZBYI8tbQLuIS',\n", " '7gjr06Lie1BDJuefW3v9YQ',\n", " '7gZRUp2WL6r11PXTv309P1',\n", " '7hD6dkjWHapWVwkI6bjDFo',\n", " '7HFja6X48hWE58m3pQnGV0',\n", " '7IUaYyqcGB3aU2Tm4s5JY8',\n", " '7IvXFbdaAQEFyeB7SSEfCG',\n", " '7J9MUXwyjyi4RURa24FQIO',\n", " '7LfubERo7MbImr0DkPBifZ',\n", " '7licaqhcEBQUzz9FownRaJ',\n", " '7M4raOQ6EsBzMYM0oyKlTu',\n", " '7MGFOSQK8O3im8YslR3DLB',\n", " '7MW9uAUmWgmvSsv41dg7J0',\n", " '7myabgfqP4KyeTazTyZ4vJ',\n", " '7nJNuftnqwrFGFs3ZRRe0u',\n", " '7nkLRaWHImCvWGHdNGnhVE',\n", " '7nw7Hh1qSVsic7HdEw6kZl',\n", " '7qPuL4RaYtQK8K5BOAOTgn',\n", " '7sKF5Km6aiVVTt0SnOwADn',\n", " '7vdksiaT0UGPpZgCCPCKrU',\n", " '7xBhNR6BprH7PZO0Sqg1cA',\n", " '7yCGrS6Xh3UngvY6Ad5sMJ',\n", " '7ydulAijh9CshP34VMrzuy',\n", " '7yjRUA0Iz3VI4Kqa5oPJZK',\n", " '7zS2n2fSTNuwDTqfYHv55G']" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "arts" ] }, { "cell_type": "code", "execution_count": 15, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "275" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(arts)" ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Found 336 artists\n" ] } ], "source": [ "row_data = get_artist_sheet_csv(arts)" ] }, { "cell_type": "code", "execution_count": 18, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[['Link',\n", " 'Title',\n", " 'Name',\n", " 'Release Date',\n", " 'Monthly Listeners',\n", " 'Monthly Listeners Delta',\n", " 'P Line',\n", " 'Release Country',\n", " 'Daily Streams',\n", " 'Last Streams',\n", " 'Max Daily',\n", " 'Max Streams Days Ago',\n", " 'First Seen Days Ago',\n", " 'Num Viral Adds',\n", " 'Playlists'],\n", " ['https://open.spotify.com/track/0GEeVI8Wa1KXGTStgBUerG',\n", " 'Ja, Vi Elsker Dette Landet',\n", " 'N/A',\n", " None,\n", " 41807,\n", " 7953,\n", " '(C) 1997 Grappa Musikkforlag A/S',\n", " 'NO',\n", " ['1096',\n", " '1163',\n", " '1134',\n", " '942',\n", " '1148',\n", " '960',\n", " '977',\n", " '1102',\n", " '1133',\n", " '1260',\n", " '830',\n", " '946',\n", " '1025',\n", " '1064',\n", " '1083',\n", " '1196',\n", " '1066',\n", " '915',\n", " '1006',\n", " '1172',\n", " '1005',\n", " '911',\n", " '1116',\n", " '1303',\n", " '1196',\n", " '1130',\n", " '1164',\n", " '1068',\n", " '1324',\n", " '1177',\n", " '1106',\n", " '1020',\n", " '980',\n", " '1080',\n", " '990',\n", " '1180',\n", " '1062',\n", " '1162',\n", " '1192',\n", " '1004',\n", " '1191',\n", " '941',\n", " '1007',\n", " '1149',\n", " '1079',\n", " '978',\n", " '947',\n", " '979',\n", " '1096',\n", " '1248',\n", " '1353',\n", " '981',\n", " '949',\n", " '1003',\n", " '1092',\n", " '1032',\n", " '1260',\n", " '1157',\n", " '1000',\n", " '1030',\n", " '1057',\n", " '928',\n", " '987',\n", " '1189',\n", " '1088',\n", " '1084',\n", " '1119',\n", " '1063',\n", " '1123',\n", " '1216',\n", " '1073',\n", " '1122',\n", " '1121',\n", " '1116',\n", " '1083',\n", " '1085',\n", " '1029',\n", " '1062',\n", " '1102',\n", " '1068',\n", " '963',\n", " '1110',\n", " '1182',\n", " '1069',\n", " '1123',\n", " '1048',\n", " '1131',\n", " '1031',\n", " '1171',\n", " '1150',\n", " '1061',\n", " '1194',\n", " '1129',\n", " '1247',\n", " '1181',\n", " '892',\n", " '923',\n", " '1160',\n", " '1137',\n", " '1197',\n", " '1214',\n", " '1056',\n", " '1050',\n", " '1159',\n", " '1143',\n", " '957',\n", " '1120',\n", " '1053',\n", " '1191',\n", " '1279',\n", " '1396',\n", " '1159',\n", " '1274',\n", " '1069',\n", " '1173',\n", " '1026',\n", " '1232',\n", " '1203',\n", " '1084',\n", " '1199',\n", " '1090',\n", " '1061',\n", " '1014',\n", " '1419',\n", " '1034',\n", " '1207',\n", " '1338',\n", " '1277',\n", " '1228',\n", " '1159',\n", " '1093',\n", " '1264',\n", " '1337',\n", " '1125',\n", " '1186',\n", " '1139',\n", " '1129',\n", " '1068',\n", " '1109',\n", " '1297',\n", " '1160',\n", " '1339',\n", " '1248',\n", " '1084',\n", " '1401',\n", " '1142',\n", " '999',\n", " '1119',\n", " '1209',\n", " '1130',\n", " '1248',\n", " '939',\n", " '967',\n", " '1201',\n", " '1160',\n", " '1219',\n", " '1299',\n", " '1292',\n", " '1006',\n", " '1305',\n", " '1373',\n", " '1155',\n", " '1272',\n", " '1210',\n", " '1082',\n", " '1182',\n", " '1126',\n", " '1242',\n", " '1264',\n", " '1113',\n", " '1094',\n", " '1135',\n", " '1167',\n", " '1020',\n", " '1176',\n", " '1100',\n", " '1149',\n", " '1053',\n", " '1010',\n", " '1075',\n", " '1278',\n", " '1241',\n", " '1131',\n", " '1210',\n", " '1227',\n", " '1027',\n", " '900',\n", " '1096',\n", " '995',\n", " '1102',\n", " '1149',\n", " '1029',\n", " '950',\n", " '987',\n", " '926',\n", " '987',\n", " '950',\n", " '1080',\n", " '1118',\n", " '960',\n", " '932',\n", " '925',\n", " '876',\n", " '1040',\n", " '1096',\n", " '1035',\n", " '917',\n", " '1093',\n", " '990',\n", " '1054',\n", " '1168',\n", " '1206',\n", " '1287',\n", " '1201',\n", " '945',\n", " '1057',\n", " '996',\n", " '899',\n", " '1149',\n", " '1173',\n", " '1100',\n", " '1068',\n", " '1021',\n", " '1013',\n", " '899',\n", " '909',\n", " '1079',\n", " '906',\n", " '833',\n", " '927',\n", " '982',\n", " '917',\n", " '1202',\n", " '1006',\n", " '1128',\n", " '961',\n", " '1111',\n", " '997',\n", " '1337',\n", " '1111',\n", " '960',\n", " '901',\n", " '914',\n", " '1218',\n", " '949',\n", " '964',\n", " '954',\n", " '972',\n", " '905',\n", " '1115',\n", " '957',\n", " '1074',\n", " '941',\n", " '977',\n", " '998',\n", " '894',\n", " '1001',\n", " '1015',\n", " '1136',\n", " '1059',\n", " '967',\n", " '903',\n", " '752',\n", " '807',\n", " '793',\n", " '980',\n", " '983',\n", " '1025',\n", " '920',\n", " '1035',\n", " '913',\n", " '983',\n", " '1092',\n", " '862',\n", " '966',\n", " '885',\n", " '850',\n", " '811',\n", " '926',\n", " '1009',\n", " '1038',\n", " '944',\n", " '1028',\n", " '774',\n", " '879',\n", " '804',\n", " '764',\n", " '822',\n", " '985',\n", " '971',\n", " '917',\n", " '991',\n", " '978',\n", " '972',\n", " '951',\n", " '1020',\n", " '824',\n", " '919',\n", " '1141',\n", " '935',\n", " '1069',\n", " '1080',\n", " '1114',\n", " '1063',\n", " '963',\n", " '936',\n", " '878',\n", " '859',\n", " '1020',\n", " '897',\n", " '981',\n", " '1011',\n", " '894',\n", " '1008',\n", " '1211',\n", " '1045',\n", " '968',\n", " '854',\n", " '967',\n", " '1008',\n", " '1160',\n", " '936',\n", " '1045',\n", " '1070',\n", " '977',\n", " '1096',\n", " '969',\n", " '1039',\n", " '1006',\n", " '1156',\n", " '1388',\n", " '1150',\n", " '1277',\n", " '1129',\n", " '1090',\n", " '1131',\n", " '1167',\n", " '1317',\n", " '1434',\n", " '1242',\n", " '1055',\n", " '1150',\n", " '1192',\n", " '1186',\n", " '1404',\n", " '1474',\n", " '1319',\n", " '1104',\n", " '1183',\n", " '1311',\n", " '1392',\n", " '1337',\n", " '1565',\n", " '1435',\n", " '1255',\n", " '1389',\n", " '1655',\n", " '2175',\n", " '2053',\n", " '1217',\n", " '1095',\n", " '861',\n", " '1127',\n", " '966',\n", " '1342',\n", " '1020',\n", " '1036',\n", " '939',\n", " '921',\n", " '1258',\n", " '815',\n", " '943',\n", " '1066',\n", " '928',\n", " '1103',\n", " '989',\n", " '917',\n", " '1167',\n", " '1149',\n", " '1252',\n", " '1058',\n", " '899',\n", " '1037',\n", " '880',\n", " '1127',\n", " '1059',\n", " '1070',\n", " '989',\n", " '952',\n", " '1032',\n", " '998',\n", " '1101',\n", " '1082',\n", " '1245',\n", " '971',\n", " '930',\n", " '921',\n", " '939',\n", " '919',\n", " '929',\n", " '1009',\n", " '950',\n", " '821',\n", " '939',\n", " '905',\n", " '979',\n", " '889',\n", " '1066',\n", " '971',\n", " '1002',\n", " '893',\n", " '997',\n", " '915',\n", " '1097',\n", " '1116',\n", " '1022',\n", " '928',\n", " '952',\n", " '1039',\n", " '1121',\n", " '1155',\n", " '1078',\n", " '1156',\n", " '1161',\n", " '1039',\n", " '980',\n", " '1073',\n", " '953',\n", " '1033',\n", " '1090',\n", " '1049',\n", " '919',\n", " '1135',\n", " '1098',\n", " '1128',\n", " '1020',\n", " '961',\n", " '916',\n", " '968',\n", " '893',\n", " '1029',\n", " '930',\n", " '1155',\n", " '1008',\n", " '837',\n", " '839',\n", " '914',\n", " '1079',\n", " '906',\n", " '1052',\n", " '1143',\n", " '1019',\n", " '827',\n", " '980',\n", " '940',\n", " '1084',\n", " '984',\n", " '1106',\n", " '806',\n", " '1041',\n", " '928',\n", " '978',\n", " '1091',\n", " '1069',\n", " '1061',\n", " '1020',\n", " '928',\n", " '908',\n", " '1112',\n", " '1088',\n", " '1060',\n", " '1031',\n", " '1115',\n", " '1017',\n", " '977',\n", " '1176',\n", " '1172',\n", " '1089',\n", " '983',\n", " '925',\n", " '1008',\n", " '1140',\n", " '1020',\n", " '1027',\n", " '921',\n", " '918',\n", " '942',\n", " '941',\n", " '899',\n", " '1045',\n", " '1009',\n", " '1005',\n", " '1104',\n", " '996',\n", " '1055',\n", " '990',\n", " '1044',\n", " '1045',\n", " '1033',\n", " '937',\n", " '886',\n", " '994',\n", " '827',\n", " '1083',\n", " '1081',\n", " '1028',\n", " '1072',\n", " '1134',\n", " '1074',\n", " '859',\n", " '1096',\n", " '1209',\n", " '1089',\n", " '1087',\n", " '955',\n", " '998',\n", " '978',\n", " '1007',\n", " '1067',\n", " '1075',\n", " '1097',\n", " '960',\n", " '1134',\n", " '1053',\n", " '1122',\n", " '1177',\n", " '1273',\n", " '997',\n", " '931',\n", " '833',\n", " '978',\n", " '934',\n", " '1113',\n", " '1114',\n", " '1055',\n", " '1165',\n", " '959',\n", " '920',\n", " '938',\n", " '922',\n", " '959',\n", " '1005',\n", " '912',\n", " '932',\n", " '977',\n", " '1023',\n", " '946',\n", " '946',\n", " '926',\n", " '896',\n", " '1151',\n", " '957',\n", " '1004',\n", " '901',\n", " '981',\n", " '1046',\n", " '893',\n", " '884',\n", " '985',\n", " '1000',\n", " '892',\n", " '988',\n", " '913',\n", " '1007',\n", " '831',\n", " '989',\n", " '872',\n", " '972',\n", " '967',\n", " '1113',\n", " '1012',\n", " '759',\n", " '1014',\n", " '859',\n", " '912',\n", " '943',\n", " '986',\n", " '965',\n", " '827',\n", " '886',\n", " '773',\n", " '908',\n", " '925',\n", " '804',\n", " '930',\n", " '901',\n", " '864',\n", " '945',\n", " '900',\n", " '933',\n", " '920',\n", " '925',\n", " '855',\n", " '969',\n", " '934',\n", " '875',\n", " '879',\n", " '836',\n", " '770',\n", " '792',\n", " '888',\n", " '865',\n", " '887',\n", " '906',\n", " '940',\n", " '847',\n", " '883',\n", " '819',\n", " '996',\n", " '963',\n", " '897',\n", " '841',\n", " '910',\n", " '981',\n", " '1048',\n", " '960',\n", " '916',\n", " '864',\n", " '914',\n", " '896',\n", " '840',\n", " '970',\n", " '957',\n", " '866',\n", " '1075',\n", " '826',\n", " '830',\n", " '813',\n", " '969',\n", " '862',\n", " '1068',\n", " '998',\n", " '975',\n", " '952',\n", " '1065',\n", " '902',\n", " '951',\n", " '1019',\n", " '962',\n", " '1030',\n", " '882',\n", " '763',\n", " '1010',\n", " '961',\n", " '1042',\n", " '953',\n", " '1239',\n", " '767',\n", " '869',\n", " '868',\n", " '1031',\n", " '835',\n", " '920',\n", " '820',\n", " '914',\n", " '877',\n", " '945',\n", " '882',\n", " '946',\n", " '1045',\n", " '917',\n", " '918',\n", " '898',\n", " '942',\n", " '982',\n", " '1069',\n", " '870',\n", " '883',\n", " '862',\n", " '790',\n", " '897',\n", " '1045',\n", " '849',\n", " '934',\n", " '984',\n", " '908',\n", " '832',\n", " '807',\n", " '927',\n", " '893',\n", " '944',\n", " '1017',\n", " '956',\n", " '918',\n", " '878',\n", " '907',\n", " '927',\n", " '959',\n", " '1021',\n", " '907',\n", " '888',\n", " '998',\n", " '1014',\n", " '1036',\n", " '1021',\n", " '969',\n", " '1068',\n", " '923',\n", " '1089',\n", " '958',\n", " '1256',\n", " '1189',\n", " '1198',\n", " '1317',\n", " '1846',\n", " '1413',\n", " '1439',\n", " '1140',\n", " '1439',\n", " '1439',\n", " '1373',\n", " '1402',\n", " '1600',\n", " '1347',\n", " '1349',\n", " '1295',\n", " '1267',\n", " '1262',\n", " '1198',\n", " '1257',\n", " '1294',\n", " '1232',\n", " '1492',\n", " '1905',\n", " '1754',\n", " '1152',\n", " '1012',\n", " '981',\n", " '1099',\n", " '1145',\n", " '1259',\n", " '982',\n", " '959',\n", " '990',\n", " '951',\n", " '1190',\n", " '1081',\n", " '977',\n", " '957',\n", " '1376',\n", " '1067',\n", " '1071',\n", " '1213',\n", " '1138',\n", " '1272',\n", " '1104',\n", " '891',\n", " '1150',\n", " '1166',\n", " '984',\n", " '1040',\n", " '1130',\n", " '1079',\n", " '1246',\n", " '968',\n", " '1004',\n", " '1303',\n", " '1000',\n", " '1105',\n", " '1082',\n", " '1050',\n", " '1059',\n", " '1053',\n", " '921',\n", " '1075',\n", " '1115',\n", " '992',\n", " '911',\n", " '1021',\n", " '1069',\n", " '990',\n", " '945',\n", " '1004',\n", " '940',\n", " '1082',\n", " '1077',\n", " '1072',\n", " '1238',\n", " '1155',\n", " '999',\n", " '1177',\n", " '964',\n", " '1032',\n", " '976',\n", " '1126',\n", " '1137',\n", " '1027',\n", " '1043',\n", " '906',\n", " '984',\n", " '1255',\n", " '1145',\n", " '1104',\n", " '950',\n", " '945',\n", " '944',\n", " '906',\n", " '1087',\n", " '1068',\n", " '1135',\n", " '1043',\n", " '957',\n", " '890',\n", " '910',\n", " '936',\n", " '1009',\n", " '842',\n", " '807',\n", " '904',\n", " '850',\n", " '1020',\n", " '871',\n", " '1074',\n", " '1027',\n", " '958',\n", " '940',\n", " '946',\n", " '1092',\n", " '913',\n", " '1015',\n", " '932',\n", " '988',\n", " '980',\n", " '932',\n", " '1035',\n", " '1057',\n", " '963',\n", " '1045',\n", " '1002',\n", " '1014',\n", " '1084',\n", " '949',\n", " '1060',\n", " '896',\n", " '848',\n", " '865',\n", " '861',\n", " '821',\n", " '954',\n", " '1002',\n", " '972',\n", " '861',\n", " '837',\n", " '803',\n", " '707',\n", " '863',\n", " '853',\n", " '999',\n", " '878',\n", " '812',\n", " '870',\n", " '850',\n", " '820',\n", " '854',\n", " '971',\n", " '889',\n", " '993',\n", " '928',\n", " '850',\n", " '976',\n", " '935',\n", " '888',\n", " '869',\n", " '866',\n", " '791',\n", " '977',\n", " '841',\n", " '764',\n", " '976',\n", " '908',\n", " '947',\n", " '943',\n", " '1052',\n", " '828',\n", " '1025',\n", " '1033',\n", " '990',\n", " '1001',\n", " '947',\n", " '866',\n", " '815',\n", " '861',\n", " '821',\n", " '941',\n", " '926',\n", " '881',\n", " '909',\n", " '794',\n", " '885',\n", " '926',\n", " '921',\n", " '898',\n", " '910',\n", " '838',\n", " '730',\n", " '704',\n", " '774',\n", " '920',\n", " '955',\n", " '981',\n", " '790',\n", " '884',\n", " '1265',\n", " '957',\n", " '811',\n", " '852',\n", " '858',\n", " '795',\n", " '688',\n", " '902',\n", " '819',\n", " '987',\n", " '915',\n", " '924',\n", " '854',\n", " '950',\n", " '963',\n", " '1011',\n", " '933',\n", " '879',\n", " '922',\n", " '884',\n", " '1012',\n", " '892',\n", " '902',\n", " '1030',\n", " '892',\n", " '916',\n", " '870',\n", " '873',\n", " '843',\n", " '907',\n", " '996',\n", " '1027',\n", " '859',\n", " '852',\n", " '898',\n", " '925',\n", " '976',\n", " '896',\n", " '937',\n", " '817',\n", " '796',\n", " '838',\n", " '890',\n", " '870',\n", " '827',\n", " '901',\n", " '762',\n", " '821',\n", " '778',\n", " '794',\n", " '889',\n", " '859',\n", " '817',\n", " '839',\n", " '761',\n", " '887',\n", " '764',\n", " '874',\n", " '1116',\n", " '1039',\n", " '921',\n", " '837',\n", " '854',\n", " '940',\n", " '881',\n", " '1022',\n", " '1177',\n", " '971',\n", " '934',\n", " '913',\n", " '1072',\n", " '996',\n", " '877',\n", " '1100',\n", " '1007',\n", " '881',\n", " '873',\n", " '881',\n", " '926',\n", " '1060',\n", " '902',\n", " '849',\n", " '789',\n", " '785',\n", " '771',\n", " '857',\n", " '962',\n", " '1236',\n", " '929',\n", " '934',\n", " '835',\n", " '937',\n", " '886',\n", " '1029',\n", " '942',\n", " '797',\n", " '776',\n", " '832',\n", " ...],\n", " 3739,\n", " 56007,\n", " 357,\n", " 0,\n", " 1,\n", " 'Norway'],\n", " ['https://open.spotify.com/track/1DEQ5owAg3k67Lhvs6rttu',\n", " 'Dunkebil',\n", " 'Ryss',\n", " datetime.date(2020, 3, 27),\n", " 22961,\n", " 5090,\n", " '2020 Alcopop.no',\n", " 'NO',\n", " ['1',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '1',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '2',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '1',\n", " '1',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '3',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '1',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '2',\n", " '0',\n", " '0',\n", " '0',\n", " '0',\n", " '1061',\n", " '1099',\n", " '1104',\n", " '1213',\n", " '1474',\n", " '1515',\n", " '1758',\n", " '2409',\n", " '2210',\n", " '1450',\n", " '918',\n", " '690',\n", " '560',\n", " '662',\n", " '772',\n", " '535',\n", " '571',\n", " '680',\n", " '615',\n", " '607',\n", " '588',\n", " '510',\n", " '528',\n", " '570',\n", " '643',\n", " '498',\n", " '431',\n", " '534',\n", " '451',\n", " '478',\n", " '531',\n", " '568',\n", " '452',\n", " '373',\n", " '273',\n", " '375',\n", " '570',\n", " '337',\n", " '434',\n", " '384',\n", " '419',\n", " '492',\n", " '289',\n", " '354',\n", " '368',\n", " '451',\n", " '371',\n", " '302',\n", " '703',\n", " '631',\n", " '594',\n", " '896',\n", " '2150',\n", " '799',\n", " '704',\n", " '786',\n", " '734',\n", " '837',\n", " '929',\n", " '1670',\n", " '1465',\n", " '883',\n", " '1245',\n", " '1051',\n", " '1241',\n", " '1077',\n", " '945',\n", " '695',\n", " '593',\n", " '757',\n", " '800',\n", " '713',\n", " '954',\n", " '818',\n", " '873',\n", " '476',\n", " '636',\n", " '597',\n", " '696',\n", " '706',\n", " '780',\n", " '765',\n", " '571',\n", " '788',\n", " '679',\n", " '713',\n", " '772',\n", " '884',\n", " '693',\n", " '601',\n", " '704',\n", " '646',\n", " '612',\n", " '709',\n", " '683',\n", " '626',\n", " '451',\n", " '606',\n", " '838',\n", " '735',\n", " '797',\n", " '1383',\n", " '765',\n", " '907',\n", " '1377',\n", " '1362',\n", " '2046',\n", " '1264',\n", " '1526',\n", " '1234',\n", " '1175',\n", " '1071',\n", " '901',\n", " '867',\n", " '877',\n", " '1016',\n", " '703',\n", " '562',\n", " '782',\n", " '766',\n", " '832',\n", " '731',\n", " '884',\n", " '655',\n", " '766',\n", " '851',\n", " '723',\n", " '937',\n", " '667',\n", " '863',\n", " '592',\n", " '582',\n", " '754',\n", " '773',\n", " '711',\n", " '760',\n", " '851',\n", " '712',\n", " '653',\n", " '996',\n", " '862',\n", " '850',\n", " '888',\n", " '1921',\n", " '1245',\n", " '1089',\n", " '879',\n", " '1150',\n", " '909',\n", " '874',\n", " '1038',\n", " '800',\n", " '695',\n", " '740',\n", " '793',\n", " '714',\n", " '979',\n", " '2235',\n", " '1496',\n", " '1399',\n", " '1948',\n", " '2034',\n", " '1486',\n", " '1577',\n", " '1771',\n", " '1680',\n", " '1069',\n", " '1513',\n", " '1426',\n", " '1152',\n", " '1445',\n", " '1356',\n", " '874',\n", " '922',\n", " '1578',\n", " '1492',\n", " '1128',\n", " '1263',\n", " '948',\n", " '1017',\n", " '681',\n", " '860',\n", " '745',\n", " '735',\n", " '874',\n", " '1062',\n", " '868',\n", " '609',\n", " '763',\n", " '771',\n", " '870',\n", " '694',\n", " '794',\n", " '735',\n", " '519',\n", " '769',\n", " '709',\n", " '754',\n", " '646',\n", " '739',\n", " '612',\n", " '531',\n", " '605',\n", " '664',\n", " '688',\n", " '709',\n", " '906',\n", " '695',\n", " '900',\n", " '926',\n", " '808',\n", " '785',\n", " '824',\n", " '744',\n", " '729',\n", " '601',\n", " '698',\n", " '563',\n", " '566',\n", " '616',\n", " '709',\n", " '608',\n", " '478',\n", " '578',\n", " '575',\n", " '613',\n", " '601',\n", " '697',\n", " '594',\n", " '578',\n", " '757',\n", " '776',\n", " '696',\n", " '918',\n", " '975',\n", " '648',\n", " '565',\n", " '665',\n", " '707',\n", " '788',\n", " '732',\n", " '772',\n", " '640',\n", " '607',\n", " '724',\n", " '703',\n", " '699',\n", " '680',\n", " '724',\n", " '686',\n", " '676',\n", " '912',\n", " '970',\n", " '896',\n", " '932',\n", " '890',\n", " '816',\n", " '775',\n", " '961',\n", " '925',\n", " '908',\n", " '943',\n", " '959',\n", " '805',\n", " '796',\n", " '896',\n", " '927',\n", " '870',\n", " '906',\n", " '914',\n", " '783',\n", " '635',\n", " '766',\n", " '851',\n", " '739',\n", " '725',\n", " '924',\n", " '851',\n", " '710',\n", " '784',\n", " '729',\n", " '1142',\n", " '1386',\n", " '1658',\n", " '1373',\n", " '955',\n", " '1453',\n", " '1396',\n", " '1359',\n", " '1433',\n", " '1493',\n", " '1275',\n", " '964',\n", " '1453',\n", " '1387',\n", " '1530',\n", " '1462',\n", " '1664',\n", " '1256',\n", " '954',\n", " '1256',\n", " '1251',\n", " '1240',\n", " '1330',\n", " '1533',\n", " '1328',\n", " '1001',\n", " '1620',\n", " '1478',\n", " '1450',\n", " '1554',\n", " '2199',\n", " '1344',\n", " '997',\n", " '1407',\n", " '1344',\n", " '1245',\n", " '1363',\n", " '1605',\n", " '1563',\n", " '931',\n", " '1779',\n", " '1443',\n", " '1426',\n", " '1415',\n", " '1684',\n", " '1323',\n", " '1054',\n", " '1399',\n", " '1191',\n", " '1296',\n", " '1394',\n", " '1451',\n", " '1253',\n", " '936',\n", " '1537',\n", " '1594',\n", " '1437',\n", " '1282',\n", " '1640',\n", " '1192',\n", " '914',\n", " '1381',\n", " '1177',\n", " '1139',\n", " '1285',\n", " '1299',\n", " '1121',\n", " '851',\n", " '1457',\n", " '1238',\n", " '1131',\n", " '1180',\n", " '1386',\n", " '1153',\n", " '762',\n", " '1146',\n", " '1043',\n", " '1067',\n", " '1240',\n", " '1264',\n", " '1027',\n", " '726',\n", " '1991',\n", " '1645',\n", " '1829',\n", " '1624',\n", " '1612',\n", " '1264',\n", " '956',\n", " '2135',\n", " '2126',\n", " '2074',\n", " '2168',\n", " '2993',\n", " '2298',\n", " '1298',\n", " '1561',\n", " '1542',\n", " '1575',\n", " '1557',\n", " '1742',\n", " '1472',\n", " '1147',\n", " '1781',\n", " '1550',\n", " '1701',\n", " '1638',\n", " '1859',\n", " '1484',\n", " '1185',\n", " '1703',\n", " '1675',\n", " '1702',\n", " '1680',\n", " '2018',\n", " '1583',\n", " '1352',\n", " '1907',\n", " '1185',\n", " '1650',\n", " '1543',\n", " '1663',\n", " '1668',\n", " '1421',\n", " '2184',\n", " '2008',\n", " '1431',\n", " '1985',\n", " '2085',\n", " '1848',\n", " '1613',\n", " '1734',\n", " '1822',\n", " '1826',\n", " '1928',\n", " '2164',\n", " '1737',\n", " '1440',\n", " '2124',\n", " '2114',\n", " '1864',\n", " '1989',\n", " '2664',\n", " '1861',\n", " '1453',\n", " '2103',\n", " '1929',\n", " '1696',\n", " '1868',\n", " '2185',\n", " '1915',\n", " '1285',\n", " '1730',\n", " '1648',\n", " '1585',\n", " '1696',\n", " '1875',\n", " '1518',\n", " '1317',\n", " '1798',\n", " '1701',\n", " '1682',\n", " '1687',\n", " '1904',\n", " '1579',\n", " '1223',\n", " '2021',\n", " '1744',\n", " '1710',\n", " '1906',\n", " '2077',\n", " '1514',\n", " '1188',\n", " '1651',\n", " '1592',\n", " '1608',\n", " '1627',\n", " '3261',\n", " '2666',\n", " '1966',\n", " '2612',\n", " '2346',\n", " '2301',\n", " '2356',\n", " '3767',\n", " '2608',\n", " '2053',\n", " '3094',\n", " '2911',\n", " '2650',\n", " '2470',\n", " '2982',\n", " '2620',\n", " '1957',\n", " '2781',\n", " '2546',\n", " '2144',\n", " '2013',\n", " '3243',\n", " '2376',\n", " '1927',\n", " '2255',\n", " '2206',\n", " '2146',\n", " '2166',\n", " '2423',\n", " '2023',\n", " '1676',\n", " '2269',\n", " '2181',\n", " '2419',\n", " '2337',\n", " '2717',\n", " '2185',\n", " '1779',\n", " '2650',\n", " '2505',\n", " '2646',\n", " '2431',\n", " '2795',\n", " '2221',\n", " '1807',\n", " '2694',\n", " '2391',\n", " '2450',\n", " '2524',\n", " '2357',\n", " '2249',\n", " '1934',\n", " '2212',\n", " '2709',\n", " '2635',\n", " '2569',\n", " '2642',\n", " '2415',\n", " '1926',\n", " '3044',\n", " '2717',\n", " '2582',\n", " '2495',\n", " '3001',\n", " '2606',\n", " '1844',\n", " '2336',\n", " '2566',\n", " '2644',\n", " '3207',\n", " '2603',\n", " '2620',\n", " '2472',\n", " '5778',\n", " '5259',\n", " '6565',\n", " '6236'],\n", " 6236,\n", " 6565,\n", " 2,\n", " 0,\n", " 1,\n", " 'Norway'],\n", " ['https://open.spotify.com/track/7w75F85oAXsdaTrCoREONt',\n", " 'Norge I Rødt Hvitt Og Blått',\n", " 'Lars-Erik Larsson',\n", " datetime.date(2000, 6, 8),\n", " 14349,\n", " 4409,\n", " '(C) 2000 Musikkoperatørene',\n", " 'NO',\n", " ['208',\n", " '193',\n", " '178',\n", " '192',\n", " '276',\n", " '222',\n", " '131',\n", " '189',\n", " '228',\n", " '198',\n", " '335',\n", " '255',\n", " '278',\n", " '221',\n", " '199',\n", " '258',\n", " '250',\n", " '236',\n", " '207',\n", " '305',\n", " '235',\n", " '183',\n", " '231',\n", " '230',\n", " '293',\n", " '234',\n", " '230',\n", " '260',\n", " '259',\n", " '246',\n", " '554',\n", " '321',\n", " '296',\n", " '246',\n", " '246',\n", " '290',\n", " '307',\n", " '234',\n", " '205',\n", " '228',\n", " '257',\n", " '191',\n", " '251',\n", " '188',\n", " '220',\n", " '192',\n", " '258',\n", " '166',\n", " '238',\n", " '290',\n", " '268',\n", " '239',\n", " '237',\n", " '226',\n", " '208',\n", " '188',\n", " '204',\n", " '208',\n", " '242',\n", " '236',\n", " '224',\n", " '271',\n", " '218',\n", " '245',\n", " '320',\n", " '193',\n", " '201',\n", " '205',\n", " '227',\n", " '175',\n", " '199',\n", " '175',\n", " '182',\n", " '182',\n", " '214',\n", " '201',\n", " '231',\n", " '203',\n", " '236',\n", " '181',\n", " '220',\n", " '184',\n", " '254',\n", " '193',\n", " '177',\n", " '234',\n", " '234',\n", " '219',\n", " '265',\n", " '233',\n", " '291',\n", " '217',\n", " '254',\n", " '263',\n", " '193',\n", " '239',\n", " '201',\n", " '220',\n", " '227',\n", " '241',\n", " '181',\n", " '200',\n", " '282',\n", " '213',\n", " '205',\n", " '288',\n", " '290',\n", " '225',\n", " '192',\n", " '245',\n", " '293',\n", " '224',\n", " '233',\n", " '269',\n", " '225',\n", " '276',\n", " '248',\n", " '272',\n", " '324',\n", " '444',\n", " '314',\n", " '225',\n", " '302',\n", " '346',\n", " '363',\n", " '430',\n", " '445',\n", " '527',\n", " '424',\n", " '501',\n", " '963',\n", " '869',\n", " '811',\n", " '583',\n", " '697',\n", " '1336',\n", " '5172',\n", " '760',\n", " '630',\n", " '545',\n", " '417',\n", " '285',\n", " '235',\n", " '251',\n", " '240',\n", " '246',\n", " '277',\n", " '268',\n", " '265',\n", " '302',\n", " '249',\n", " '213',\n", " '238',\n", " '216',\n", " '187',\n", " '275',\n", " '262',\n", " '202',\n", " '236',\n", " '228',\n", " '198',\n", " '168',\n", " '177',\n", " '215',\n", " '170',\n", " '179',\n", " '169',\n", " '219',\n", " '296',\n", " '546',\n", " '213',\n", " '166',\n", " '179',\n", " '230',\n", " '154',\n", " '187',\n", " '185',\n", " '164',\n", " '128',\n", " '174',\n", " '124',\n", " '148',\n", " '156',\n", " '144',\n", " '113',\n", " '129',\n", " '146',\n", " '127',\n", " '168',\n", " '145',\n", " '138',\n", " '152',\n", " '170',\n", " '170',\n", " '117',\n", " '118',\n", " '141',\n", " '155',\n", " '138',\n", " '156',\n", " '135',\n", " '138',\n", " '175',\n", " '154',\n", " '171',\n", " '187',\n", " '126',\n", " '114',\n", " '187',\n", " '150',\n", " '168',\n", " '101',\n", " '124',\n", " '105',\n", " '115',\n", " '115',\n", " '160',\n", " '102',\n", " '144',\n", " '132',\n", " '159',\n", " '159',\n", " '169',\n", " '126',\n", " '181',\n", " '158',\n", " '136',\n", " '104',\n", " '152',\n", " '151',\n", " '118',\n", " '131',\n", " '170',\n", " '134',\n", " '113',\n", " '151',\n", " '120',\n", " '206',\n", " '178',\n", " '175',\n", " '163',\n", " '147',\n", " '175',\n", " '199',\n", " '186',\n", " '195',\n", " '192',\n", " '181',\n", " '159',\n", " '158',\n", " '156',\n", " '216',\n", " '200',\n", " '173',\n", " '215',\n", " '216',\n", " '181',\n", " '212',\n", " '141',\n", " '163',\n", " '177',\n", " '132',\n", " '220',\n", " '168',\n", " '175',\n", " '182',\n", " '172',\n", " '187',\n", " '161',\n", " '191',\n", " '190',\n", " '181',\n", " '197',\n", " '2581',\n", " '2961',\n", " '2303',\n", " '3360',\n", " '4333',\n", " '4554',\n", " '4871',\n", " '5099',\n", " '3291',\n", " '2235',\n", " '3098',\n", " '4423',\n", " '4883',\n", " '4578',\n", " '5002',\n", " '3419',\n", " '2612',\n", " '3470',\n", " '4848',\n", " '5032',\n", " '4750',\n", " '4406',\n", " '3130',\n", " '2348',\n", " '3150',\n", " '4501',\n", " '4810',\n", " '4656',\n", " '3946',\n", " '2998',\n", " '2076',\n", " '2844',\n", " '4428',\n", " '5141',\n", " '4821',\n", " '4406',\n", " '3233',\n", " '2531',\n", " '3521',\n", " '4697',\n", " '4371',\n", " '4294',\n", " '4189',\n", " '3218',\n", " '2237',\n", " '3098',\n", " '4508',\n", " '4284',\n", " '4328',\n", " '4205',\n", " '3028',\n", " '2309',\n", " '3094',\n", " '4099',\n", " '3984',\n", " '3643',\n", " '2947',\n", " '2367',\n", " '2445',\n", " '3121',\n", " '4237',\n", " '4486',\n", " '4974',\n", " '4570',\n", " '3738',\n", " '2813',\n", " '3603',\n", " '5091',\n", " '4934',\n", " '5015',\n", " '4661',\n", " '3621',\n", " '2855',\n", " '3829',\n", " '5218',\n", " '4651',\n", " '4379',\n", " '3440',\n", " '2252',\n", " '1362',\n", " '1423',\n", " '1947',\n", " '1740',\n", " '1416',\n", " '843',\n", " '599',\n", " '937',\n", " '1214',\n", " '1712',\n", " '1909',\n", " '1723',\n", " '1388',\n", " '971',\n", " '1981',\n", " '2108',\n", " '3305',\n", " '3383',\n", " '3487',\n", " '3455',\n", " '2766',\n", " '2416',\n", " '3059',\n", " '3615',\n", " '3812',\n", " '3840',\n", " '3929',\n", " '2970',\n", " '2317',\n", " '2942',\n", " '3965',\n", " '4245',\n", " '4137',\n", " '4160',\n", " '3623',\n", " '2658',\n", " '3347',\n", " '4337',\n", " '4755',\n", " '4318',\n", " '4012',\n", " '3165',\n", " '2361',\n", " '2991',\n", " '4081',\n", " '4467',\n", " '4353',\n", " '4219',\n", " '3148',\n", " '2399',\n", " '2727',\n", " '3713',\n", " '3968',\n", " '4218',\n", " '3859',\n", " '3079',\n", " '2269',\n", " '2667',\n", " '3933',\n", " '4063',\n", " '4283',\n", " '4082',\n", " '3230',\n", " '2202',\n", " '3015',\n", " '4140',\n", " '4126',\n", " '4349',\n", " '4140',\n", " '3144',\n", " '2350',\n", " '2807',\n", " '3816',\n", " '4040',\n", " '4043',\n", " '4018',\n", " '2877',\n", " '2232',\n", " '2787',\n", " '3923',\n", " '3924',\n", " '4015',\n", " '3769',\n", " '2959',\n", " '2154',\n", " '2883',\n", " '3662',\n", " '3759',\n", " '3702',\n", " '3366',\n", " '2476',\n", " '2013',\n", " '2372',\n", " '3320',\n", " '3171',\n", " '3085',\n", " '2598',\n", " '2095',\n", " '1729',\n", " '1849',\n", " '3292',\n", " '3353',\n", " '3379',\n", " '3343',\n", " '2656',\n", " '1985',\n", " '3063',\n", " '4013',\n", " '3745',\n", " '4046',\n", " '3862',\n", " '3080',\n", " '2635',\n", " '3347',\n", " '4528',\n", " '4405',\n", " '4516',\n", " '4187',\n", " '3203',\n", " '2547',\n", " '3079',\n", " '4296',\n", " '4366',\n", " '4100',\n", " '3717',\n", " '3419',\n", " '2902',\n", " '3405',\n", " '5423',\n", " '5382',\n", " '5533',\n", " '5238',\n", " '4490',\n", " '3501',\n", " '4235',\n", " '6075',\n", " '6055',\n", " '5356',\n", " '5398',\n", " '3936',\n", " '3394',\n", " '3748',\n", " '5471',\n", " '5631',\n", " '5400',\n", " '5163',\n", " '4688',\n", " '3475',\n", " '4234',\n", " '6041',\n", " '9549',\n", " '4658',\n", " '4536',\n", " '3845',\n", " '2978',\n", " '3465',\n", " '4544',\n", " '4439',\n", " '4573',\n", " '3695',\n", " '2990',\n", " '2581',\n", " '3122',\n", " '3804',\n", " '4114',\n", " '4218',\n", " '3842',\n", " '3230',\n", " '2546',\n", " '3404',\n", " '4568',\n", " '4237',\n", " '4076',\n", " '3718',\n", " '2792',\n", " '2376',\n", " '2915',\n", " '3859',\n", " '3955',\n", " '3584',\n", " '3601',\n", " '2523',\n", " '2430',\n", " '2404',\n", " '3460',\n", " '3261',\n", " '3150',\n", " '3191',\n", " '2633',\n", " '1869',\n", " '2283',\n", " '2895',\n", " '3056',\n", " '3110',\n", " '2666',\n", " '2167',\n", " '1759',\n", " '1837',\n", " '2598',\n", " '2783',\n", " '2884',\n", " '2642',\n", " '2343',\n", " '1785',\n", " '1754',\n", " '2691',\n", " '3080',\n", " '2847',\n", " '2707',\n", " '2134',\n", " '1556',\n", " '1817',\n", " '2625',\n", " '2857',\n", " '2555',\n", " '2369',\n", " '1909',\n", " '1543',\n", " '1600',\n", " '2561',\n", " '2338',\n", " '2185',\n", " '2177',\n", " '1891',\n", " '1326',\n", " '1534',\n", " '2332',\n", " '2324',\n", " '2277',\n", " '2236',\n", " '1915',\n", " '1498',\n", " '1707',\n", " '2342',\n", " '2309',\n", " '2477',\n", " '2209',\n", " '1706',\n", " '1461',\n", " '1717',\n", " '2290',\n", " '2803',\n", " '2483',\n", " '2289',\n", " '2080',\n", " '1693',\n", " '2134',\n", " '2684',\n", " '3014',\n", " '2943',\n", " '2678',\n", " '2232',\n", " '1672',\n", " '2495',\n", " '3121',\n", " '3250',\n", " '3396',\n", " '3317',\n", " '2601',\n", " '2174',\n", " '2816',\n", " '3254',\n", " '3517',\n", " '3865',\n", " '3496',\n", " '3197',\n", " '2009',\n", " '2688',\n", " '4026',\n", " '3948',\n", " '3563',\n", " '3440',\n", " '2957',\n", " '2143',\n", " '3142',\n", " '3789',\n", " '3823',\n", " '3858',\n", " '3841',\n", " '2991',\n", " '2329',\n", " '3079',\n", " '4181',\n", " '3871',\n", " '3872',\n", " '3650',\n", " '3047',\n", " '2157',\n", " '3041',\n", " '4116',\n", " '4206',\n", " '4051',\n", " '3800',\n", " '2722',\n", " '2247',\n", " '3241',\n", " '3881',\n", " '4288',\n", " '4312',\n", " '3752',\n", " '3230',\n", " '2911',\n", " '3469',\n", " '4021',\n", " '3939',\n", " '3651',\n", " '3474',\n", " '2607',\n", " '2227',\n", " '2762',\n", " '3618',\n", " '3555',\n", " '3678',\n", " '3315',\n", " '2468',\n", " '1924',\n", " '2566',\n", " '3196',\n", " '3706',\n", " '3430',\n", " '3381',\n", " '2821',\n", " '2501',\n", " '3087',\n", " '3983',\n", " '3892',\n", " '3711',\n", " '3632',\n", " '2860',\n", " '2304',\n", " '3062',\n", " '4227',\n", " '4145',\n", " '3999',\n", " '3914',\n", " '2856',\n", " '2643',\n", " '3121',\n", " '4015',\n", " '3903',\n", " '3786',\n", " '3243',\n", " '2569',\n", " '2377',\n", " '3078',\n", " '4044',\n", " '4394',\n", " '4326',\n", " '3993',\n", " '3346',\n", " '2628',\n", " '3558',\n", " '4861',\n", " '4953',\n", " '4590',\n", " '4400',\n", " '3833',\n", " '3291',\n", " '4015',\n", " '5222',\n", " '4953',\n", " '4825',\n", " '4032',\n", " '2890',\n", " '1927',\n", " '2469',\n", " '3045',\n", " '2539',\n", " '2317',\n", " '2037',\n", " '1419',\n", " '1100',\n", " '956',\n", " '1524',\n", " '1726',\n", " '2037',\n", " '2020',\n", " '1958',\n", " '1383',\n", " '1266',\n", " '2279',\n", " '3277',\n", " '3353',\n", " '3357',\n", " '2872',\n", " '2632',\n", " '3086',\n", " '4011',\n", " '4199',\n", " '4051',\n", " '3943',\n", " '3459',\n", " '2817',\n", " '3123',\n", " '3972',\n", " '3830',\n", " '3877',\n", " '3576',\n", " '2932',\n", " '2412',\n", " '2948',\n", " '3898',\n", " '3939',\n", " '3686',\n", " '3515',\n", " '3243',\n", " '2232',\n", " '2540',\n", " '3910',\n", " '3980',\n", " '3601',\n", " '3763',\n", " '2905',\n", " '2703',\n", " '2976',\n", " '3565',\n", " '3538',\n", " '3959',\n", " '3666',\n", " '3080',\n", " '2292',\n", " '2887',\n", " '3554',\n", " '3297',\n", " '3671',\n", " '3735',\n", " '2552',\n", " '2040',\n", " '2501',\n", " '3396',\n", " '3636',\n", " '3769',\n", " '3354',\n", " '2587',\n", " '2127',\n", " '2690',\n", " '3250',\n", " '3680',\n", " '3821',\n", " '3280',\n", " '2639',\n", " '2177',\n", " '2536',\n", " '3451',\n", " '3557',\n", " '3605',\n", " '3586',\n", " '2924',\n", " '2106',\n", " '2612',\n", " '3474',\n", " '3480',\n", " '3624',\n", " '3283',\n", " '2577',\n", " '2240',\n", " '2494',\n", " '3500',\n", " '3749',\n", " '3593',\n", " '3229',\n", " '2740',\n", " '2117',\n", " '2474',\n", " '3466',\n", " '3432',\n", " '3662',\n", " '3524',\n", " '2968',\n", " '2037',\n", " '2525',\n", " '3401',\n", " '3472',\n", " '3506',\n", " '3169',\n", " '2705',\n", " '2680',\n", " '2172',\n", " '3426',\n", " '3290',\n", " '2858',\n", " '2314',\n", " '2209',\n", " '1824',\n", " '1770',\n", " '3081',\n", " '3376',\n", " '3627',\n", " '3324',\n", " '2689',\n", " '2028',\n", " '2541',\n", " '3507',\n", " '3487',\n", " '3339',\n", " '3234',\n", " '2533',\n", " '1960',\n", " '2391',\n", " '4104',\n", " '4101',\n", " '3636',\n", " '3524',\n", " '2730',\n", " '2245',\n", " '2856',\n", " '3863',\n", " '4055',\n", " '3451',\n", " '3391',\n", " '2732',\n", " '2164',\n", " '2508',\n", " '3744',\n", " '5395',\n", " '9931',\n", " '3317',\n", " '2482',\n", " '2164',\n", " '2478',\n", " '3009',\n", " '2797',\n", " '2619',\n", " '2653',\n", " '2166',\n", " '1675',\n", " '2180',\n", " '2538',\n", " '2721',\n", " '2660',\n", " '2684',\n", " '2028',\n", " '1715',\n", " '2035',\n", " '2519',\n", " '2792',\n", " '2755',\n", " '2571',\n", " '2102',\n", " '1831',\n", " '1872',\n", " '2692',\n", " '2360',\n", " '2333',\n", " '2334',\n", " '1872',\n", " '1565',\n", " '1689',\n", " '2130',\n", " '2388',\n", " '2354',\n", " '2001',\n", " '2052',\n", " '1449',\n", " '1533',\n", " '1967',\n", " '2104',\n", " '1886',\n", " '1446',\n", " '1045',\n", " '880',\n", " '858',\n", " '949',\n", " '772',\n", " '979',\n", " '890',\n", " '788',\n", " '561',\n", " '743',\n", " '802',\n", " '715',\n", " '801',\n", " '814',\n", " '763',\n", " '545',\n", " '547',\n", " '732',\n", " '885',\n", " '767',\n", " '732',\n", " '637',\n", " '564',\n", " '481',\n", " '770',\n", " '742',\n", " '620',\n", " '753',\n", " '662',\n", " '776',\n", " '579',\n", " '766',\n", " '667',\n", " '643',\n", " '673',\n", " '728',\n", " '675',\n", " '512',\n", " '502',\n", " '632',\n", " '725',\n", " '725',\n", " '629',\n", " '625',\n", " '516',\n", " '596',\n", " '739',\n", " '784',\n", " '945',\n", " '522',\n", " '671',\n", " '607',\n", " '652',\n", " '674',\n", " '714',\n", " '714',\n", " '688',\n", " '595',\n", " '727',\n", " '681',\n", " '741',\n", " '908',\n", " '866',\n", " '725',\n", " '707',\n", " '666',\n", " '900',\n", " '709',\n", " '759',\n", " '972',\n", " '818',\n", " '672',\n", " '748',\n", " '875',\n", " '756',\n", " '837',\n", " '858',\n", " '838',\n", " '736',\n", " '647',\n", " '800',\n", " '886',\n", " '1103',\n", " '1001',\n", " '768',\n", " '704',\n", " '646',\n", " '838',\n", " '881',\n", " ...],\n", " 2094,\n", " 22160,\n", " 357,\n", " 0,\n", " 1,\n", " 'Norway'],\n", " ['https://open.spotify.com/track/1oaM5MaTQYs5xoDdV6AsSu',\n", " 'Em',\n", " 'Khoi Vu',\n", " datetime.date(2020, 3, 24),\n", " 5123,\n", " 4688,\n", " '2020 Khoi Vu',\n", " 'QZ',\n", " ['19',\n", " '20',\n", " '0',\n", " '0',\n", " '64',\n", " '8',\n", " '5',\n", " '4',\n", " '10',\n", " '2',\n", " '124',\n", " '121',\n", " '39',\n", " '22',\n", " '95',\n", " '35',\n", " '52',\n", " '35',\n", " '118',\n", " '67',\n", " '69',\n", " '12',\n", " '14',\n", " '51',\n", " '72',\n", " '29',\n", " '22',\n", " '18',\n", " '62',\n", " '115',\n", " '54',\n", " '36',\n", " '108',\n", " '93',\n", " '75',\n", " '47',\n", " '286',\n", " '91',\n", " '39',\n", " '29',\n", " '41',\n", " '36',\n", " '76',\n", " '93',\n", " '67',\n", " '307',\n", " '80',\n", " '82',\n", " '122',\n", " '157',\n", " '182',\n", " '261',\n", " '220',\n", " '167',\n", " '233',\n", " '291',\n", " '225',\n", " '273',\n", " '232',\n", " '218',\n", " '268',\n", " '222',\n", " '148',\n", " '201',\n", " '299',\n", " '240',\n", " '456',\n", " '290',\n", " '222',\n", " '267',\n", " '332',\n", " '1249',\n", " '2302',\n", " '1580',\n", " '876',\n", " '929',\n", " '1112',\n", " '902',\n", " '952',\n", " '1372',\n", " '2546',\n", " '2672'],\n", " 2672,\n", " 2672,\n", " 2,\n", " 0,\n", " 1,\n", " 'Vietnam'],\n", " ['https://open.spotify.com/track/5rF37RljDTpMLI1PezKqyN',\n", " 'PARIS MIAMI PRAHA (feat. Shimmi)',\n", " 'Tisci',\n", " datetime.date(2020, 4, 6),\n", " 10901,\n", " 3385,\n", " '2020 ConspiracyFlat Studio, with courtesy of MIKE ROFT Records',\n", " 'CZ',\n", " ['598',\n", " '976',\n", " '655',\n", " '807',\n", " '694',\n", " '666',\n", " '770',\n", " '753',\n", " '772',\n", " '887',\n", " '844',\n", " '528',\n", " '518',\n", " '997',\n", " '994',\n", " '939',\n", " '572',\n", " '618',\n", " '909',\n", " '518',\n", " '596',\n", " '657',\n", " '482',\n", " '586',\n", " '460',\n", " '521',\n", " '422',\n", " '430',\n", " '463',\n", " '366',\n", " '348',\n", " '475',\n", " '498',\n", " '569',\n", " '350',\n", " '408',\n", " '473',\n", " '344',\n", " '316',\n", " '304',\n", " '289',\n", " '282',\n", " '282',\n", " '219',\n", " '321',\n", " '340',\n", " '254',\n", " '317',\n", " '211',\n", " '209',\n", " '252',\n", " '366',\n", " '207',\n", " '200',\n", " '233',\n", " '187',\n", " '225',\n", " '225',\n", " '197',\n", " '160',\n", " '167',\n", " '216',\n", " '172',\n", " '172',\n", " '100',\n", " '210',\n", " '209',\n", " '299',\n", " '300',\n", " '156',\n", " '160',\n", " '97',\n", " '108',\n", " '147',\n", " '186',\n", " '231',\n", " '231',\n", " '215',\n", " '122',\n", " '115',\n", " '96',\n", " '122',\n", " '133',\n", " '153',\n", " '221',\n", " '161',\n", " '101',\n", " '145',\n", " '125',\n", " '134',\n", " '114',\n", " '174',\n", " '261',\n", " '125',\n", " '155',\n", " '109',\n", " '146',\n", " '171',\n", " '232',\n", " '169',\n", " '145',\n", " '149',\n", " '141',\n", " '199',\n", " '119',\n", " '148',\n", " '89',\n", " '111',\n", " '137',\n", " '155',\n", " '285',\n", " '156',\n", " '182',\n", " '113',\n", " '152',\n", " '146',\n", " '144',\n", " '126',\n", " '141',\n", " '131',\n", " '188',\n", " '103',\n", " '115',\n", " '89',\n", " '110',\n", " '120',\n", " '101',\n", " '104',\n", " '154',\n", " '107',\n", " '105',\n", " '202',\n", " '198',\n", " '193',\n", " '92',\n", " '100',\n", " '45',\n", " '51',\n", " '100',\n", " '113',\n", " '93',\n", " '72',\n", " '78',\n", " '148',\n", " '109',\n", " '87',\n", " '52',\n", " '89',\n", " '87',\n", " '112',\n", " '142',\n", " '165',\n", " '116',\n", " '124',\n", " '118',\n", " '95',\n", " '83',\n", " '134',\n", " '112',\n", " '144',\n", " '186',\n", " '125',\n", " '73',\n", " '74',\n", " '62',\n", " '65',\n", " '52',\n", " '78',\n", " '73',\n", " '152',\n", " '93',\n", " '87',\n", " '130',\n", " '94',\n", " '226',\n", " '91',\n", " '82',\n", " '104',\n", " '80',\n", " '57',\n", " '99',\n", " '99',\n", " '96',\n", " '83',\n", " '74',\n", " '109',\n", " '74',\n", " '65',\n", " '92',\n", " '95',\n", " '80',\n", " '55',\n", " '65',\n", " '120',\n", " '77',\n", " '77',\n", " '94',\n", " '66',\n", " '64',\n", " '104',\n", " '59',\n", " '93',\n", " '120',\n", " '122',\n", " '93',\n", " '97',\n", " '122',\n", " '107',\n", " '54',\n", " '135',\n", " '114',\n", " '127',\n", " '136',\n", " '86',\n", " '87',\n", " '136',\n", " '99',\n", " '128',\n", " '83',\n", " '103',\n", " '112',\n", " '121',\n", " '89',\n", " '70',\n", " '106',\n", " '70',\n", " '52',\n", " '80',\n", " '72',\n", " '115',\n", " '97',\n", " '116',\n", " '71',\n", " '85',\n", " '98',\n", " '73',\n", " '116',\n", " '93',\n", " '84',\n", " '59',\n", " '47',\n", " '90',\n", " '104',\n", " '106',\n", " '68',\n", " '75',\n", " '73',\n", " '48',\n", " '62',\n", " '109',\n", " '64',\n", " '81',\n", " '51',\n", " '67',\n", " '49',\n", " '88',\n", " '99',\n", " '78',\n", " '49',\n", " '57',\n", " '71',\n", " '56',\n", " '54',\n", " '53',\n", " '73',\n", " '78',\n", " '75',\n", " '73',\n", " '67',\n", " '101',\n", " '97',\n", " '63',\n", " '80',\n", " '73',\n", " '45',\n", " '41',\n", " '92',\n", " '77',\n", " '55',\n", " '51',\n", " '69',\n", " '76',\n", " '81',\n", " '102',\n", " '107',\n", " '115',\n", " '138',\n", " '163',\n", " '98',\n", " '88',\n", " '180',\n", " '55',\n", " '109',\n", " '106',\n", " '135',\n", " '72',\n", " '59',\n", " '93',\n", " '129',\n", " '163',\n", " '195',\n", " '200',\n", " '178',\n", " '130',\n", " '170',\n", " '156',\n", " '131',\n", " '202',\n", " '109',\n", " '133',\n", " '146',\n", " '102',\n", " '117',\n", " '87',\n", " '134',\n", " '149',\n", " '197',\n", " '224',\n", " '112',\n", " '180',\n", " '102',\n", " '98',\n", " '138',\n", " '93',\n", " '118',\n", " '163',\n", " '103',\n", " '123',\n", " '156',\n", " '92',\n", " '83',\n", " '112',\n", " '75',\n", " '90',\n", " '57',\n", " '89',\n", " '83',\n", " '50',\n", " '156',\n", " '112',\n", " '85',\n", " '170',\n", " '203',\n", " '136',\n", " '155',\n", " '191',\n", " '162',\n", " '165',\n", " '146',\n", " '172',\n", " '173',\n", " '135',\n", " '141',\n", " '141',\n", " '145',\n", " '136',\n", " '91',\n", " '143',\n", " '88',\n", " '101',\n", " '81',\n", " '96',\n", " '71',\n", " '103',\n", " '109',\n", " '114',\n", " '109',\n", " '88',\n", " '91',\n", " '165',\n", " '125',\n", " '138',\n", " '107',\n", " '126',\n", " '123',\n", " '158',\n", " '212',\n", " '116',\n", " '132',\n", " '117',\n", " '93',\n", " '108',\n", " '178',\n", " '168',\n", " '184',\n", " '191',\n", " '112',\n", " '152',\n", " '120',\n", " '89',\n", " '96',\n", " '82',\n", " '124',\n", " '158',\n", " '212',\n", " '173',\n", " '165',\n", " '158',\n", " '190',\n", " '137',\n", " '92',\n", " '164',\n", " '126',\n", " '222',\n", " '156',\n", " '122',\n", " '132',\n", " '153',\n", " '146',\n", " '160',\n", " '150',\n", " '146',\n", " '130',\n", " '212',\n", " '130',\n", " '162',\n", " '126',\n", " '169',\n", " '154',\n", " '82',\n", " '202',\n", " '110',\n", " '134',\n", " '92',\n", " '153',\n", " '162',\n", " '213',\n", " '161',\n", " '160',\n", " '120',\n", " '158',\n", " '171',\n", " '106',\n", " '1215',\n", " '1365',\n", " '863',\n", " '887',\n", " '885',\n", " '807',\n", " '697',\n", " '625',\n", " '747',\n", " '550',\n", " '381',\n", " '372',\n", " '403',\n", " '385',\n", " '390',\n", " '314',\n", " '254',\n", " '247',\n", " '245',\n", " '289',\n", " '285',\n", " '286',\n", " '315',\n", " '314',\n", " '307',\n", " '242',\n", " '226',\n", " '290',\n", " '218',\n", " '269',\n", " '153',\n", " '275',\n", " '366',\n", " '287',\n", " '361',\n", " '250',\n", " '286',\n", " '297',\n", " '211',\n", " '211',\n", " '191',\n", " '239',\n", " '304',\n", " '244',\n", " '230',\n", " '272',\n", " '231',\n", " '209',\n", " '330',\n", " '352',\n", " '255',\n", " '311',\n", " '210',\n", " '344',\n", " '352',\n", " '251',\n", " '257',\n", " '294',\n", " '214',\n", " '236',\n", " '305',\n", " '218',\n", " '252',\n", " '225',\n", " '185',\n", " '158',\n", " '210',\n", " '198',\n", " '236',\n", " '254',\n", " '164',\n", " '203',\n", " '161',\n", " '173',\n", " '203',\n", " '244',\n", " '308',\n", " '224',\n", " '279',\n", " '254',\n", " '327',\n", " '454',\n", " '506',\n", " '337',\n", " '325',\n", " '233',\n", " '214',\n", " '144',\n", " '168',\n", " '185',\n", " '271',\n", " '204',\n", " '169',\n", " '216',\n", " '157',\n", " '175',\n", " '166',\n", " '153',\n", " '200',\n", " '274',\n", " '309',\n", " '210',\n", " '182',\n", " '156',\n", " '173',\n", " '150',\n", " '149',\n", " '155',\n", " '162',\n", " '156',\n", " '164',\n", " '221',\n", " '295',\n", " '218',\n", " '202',\n", " '148',\n", " '171',\n", " '106',\n", " '110',\n", " '154',\n", " '187',\n", " '212',\n", " '155',\n", " '273',\n", " '219',\n", " '233',\n", " '219',\n", " '185',\n", " '238',\n", " '165',\n", " '193',\n", " '226',\n", " '130',\n", " '233',\n", " '149',\n", " '198',\n", " '144',\n", " '266',\n", " '271',\n", " '245',\n", " '271',\n", " '176',\n", " '217',\n", " '194',\n", " '191',\n", " '169',\n", " '207',\n", " '200',\n", " '231',\n", " '165',\n", " '159',\n", " '190',\n", " '202',\n", " '150',\n", " '138',\n", " '131',\n", " '177',\n", " '89',\n", " '148',\n", " '151',\n", " '182',\n", " '179',\n", " '237',\n", " '152',\n", " '151',\n", " '219',\n", " '283',\n", " '150',\n", " '169',\n", " '152',\n", " '129',\n", " '97',\n", " '161',\n", " '178',\n", " '207',\n", " '186',\n", " '168',\n", " '137',\n", " '156',\n", " '170',\n", " '159',\n", " '171',\n", " '155',\n", " '195',\n", " '130',\n", " '131',\n", " '176',\n", " '181',\n", " '287',\n", " '228',\n", " '199',\n", " '144',\n", " '150',\n", " '161',\n", " '166',\n", " '173',\n", " '164',\n", " '227',\n", " '210',\n", " '85',\n", " '176',\n", " '206',\n", " '189',\n", " '182',\n", " '208',\n", " '158',\n", " '139',\n", " '110',\n", " '91',\n", " '160',\n", " '147',\n", " '107',\n", " '157',\n", " '127',\n", " '160',\n", " '156',\n", " '136',\n", " '144',\n", " '192',\n", " '128',\n", " '154',\n", " '128',\n", " '177',\n", " '103',\n", " '130',\n", " '140',\n", " '143',\n", " '127',\n", " '163',\n", " '114',\n", " '97',\n", " '95',\n", " '136',\n", " '146',\n", " '116',\n", " '141',\n", " '189',\n", " '337',\n", " '172',\n", " '133',\n", " '154',\n", " '110',\n", " '102',\n", " '100',\n", " '109',\n", " '168',\n", " '115',\n", " '76',\n", " '108',\n", " '127',\n", " '177',\n", " '113',\n", " '190',\n", " '233',\n", " '140',\n", " '188',\n", " '163',\n", " '482',\n", " '645',\n", " '693',\n", " '549',\n", " '497',\n", " '556',\n", " '450',\n", " '577',\n", " '451',\n", " '447',\n", " '557',\n", " '459',\n", " '531',\n", " '427',\n", " '374',\n", " '419',\n", " '464',\n", " '770',\n", " '430',\n", " '531',\n", " '697',\n", " '603',\n", " '813',\n", " '645',\n", " '557',\n", " '503',\n", " '427',\n", " '496',\n", " '460',\n", " '474',\n", " '649',\n", " '554',\n", " '412',\n", " '433',\n", " '1671',\n", " '1467',\n", " '1170',\n", " '1191',\n", " '1105',\n", " '804',\n", " '806',\n", " '1133',\n", " '973',\n", " '3762',\n", " '3684',\n", " '3271',\n", " '2415',\n", " '2008',\n", " '1983',\n", " '1989',\n", " '1876',\n", " '1956',\n", " '2358',\n", " '1923',\n", " '1633',\n", " '2078',\n", " '1994',\n", " '1840',\n", " '1815',\n", " '1719',\n", " '1459',\n", " '1314',\n", " '1342',\n", " '1277',\n", " '1432',\n", " '1214',\n", " '1328',\n", " '1119',\n", " '916',\n", " '1160',\n", " '1178',\n", " '1095',\n", " '1195',\n", " '1226',\n", " '1021',\n", " '937',\n", " '1389',\n", " '1384',\n", " '1758',\n", " '1618',\n", " '1647',\n", " '1363',\n", " '1329',\n", " '1671',\n", " '1549',\n", " '1371',\n", " '1265',\n", " '1371',\n", " '1314',\n", " '1120',\n", " '1218',\n", " '1227',\n", " '1275',\n", " '1203',\n", " '1073',\n", " '953',\n", " '888',\n", " '1197',\n", " '1163',\n", " '1058',\n", " '938',\n", " '999',\n", " '987',\n", " '1134',\n", " '1202',\n", " '924',\n", " '1012',\n", " '1006',\n", " '1180',\n", " '974',\n", " '2656',\n", " '12483',\n", " '9828',\n", " '8090',\n", " '6680',\n", " '5813',\n", " '4839',\n", " '4656',\n", " '4968',\n", " '4756',\n", " '4559',\n", " '4281',\n", " '4397',\n", " '3517',\n", " '3188',\n", " '3629',\n", " '3899',\n", " '3381',\n", " '3885',\n", " '3584',\n", " '2975',\n", " '2859',\n", " '3261',\n", " '3346',\n", " '3394',\n", " '3510',\n", " '2809',\n", " '2882',\n", " '2663',\n", " '3654',\n", " '3631',\n", " '3367',\n", " '3583'],\n", " 3583,\n", " 12483,\n", " 32,\n", " 0,\n", " 1,\n", " 'Slovakia'],\n", " ['https://open.spotify.com/track/4ZxL5Fi5K0nkyTmsbwPdsj',\n", " 'Call It What You Want',\n", " 'rum.gold',\n", " datetime.date(2019, 8, 16),\n", " 226296,\n", " 179018,\n", " '2019 Leola LLC',\n", " 'QM',\n", " ['248',\n", " '311',\n", " '321',\n", " '475',\n", " '723',\n", " '16599',\n", " '4312',\n", " '3047',\n", " '1809',\n", " '1712',\n", " '2170',\n", " '2354',\n", " '5285',\n", " '3047',\n", " '2822',\n", " '2397',\n", " '2392',\n", " '3386',\n", " '3300',\n", " '2958',\n", " '2042',\n", " '1444',\n", " '1050',\n", " '846',\n", " '1351',\n", " '2631',\n", " '4361',\n", " '3161',\n", " '2754',\n", " '2755',\n", " '2426',\n", " '2594',\n", " '3070',\n", " '2252',\n", " '2213',\n", " '2213',\n", " '2409',\n", " '2022',\n", " '2836',\n", " '3165',\n", " '2366',\n", " '2110',\n", " '2105',\n", " '2283',\n", " '1912',\n", " '4985',\n", " '5617',\n", " '4328',\n", " '3301',\n", " '3034',\n", " '3234',\n", " '2845',\n", " '4028',\n", " '3928',\n", " '4513',\n", " '14203',\n", " '7153',\n", " '4702',\n", " '3731',\n", " '10154',\n", " '5390',\n", " '5093',\n", " '14624',\n", " '7008',\n", " '4440',\n", " '3679',\n", " '8652',\n", " '5886',\n", " '6673',\n", " '9519',\n", " '5436',\n", " '4455',\n", " '3566',\n", " '7380',\n", " '7821',\n", " '8071',\n", " '13164',\n", " '9943',\n", " '9234',\n", " '5241',\n", " '10940',\n", " '7226',\n", " '11172',\n", " '11290',\n", " '7934',\n", " '8476',\n", " '4874',\n", " '12002',\n", " '7790',\n", " '12030',\n", " '11763',\n", " '6517',\n", " '8063',\n", " '4547',\n", " '10428',\n", " '6868',\n", " '11972',\n", " '11233',\n", " '6575',\n", " '8259',\n", " '4305',\n", " '10345',\n", " '7609',\n", " '11351',\n", " '11177',\n", " '6188',\n", " '7142',\n", " '4178',\n", " '7846',\n", " '6404',\n", " '9289',\n", " '9151',\n", " '5482',\n", " '6684',\n", " '3774',\n", " '8444',\n", " '6826',\n", " '9953',\n", " '10493',\n", " '6070',\n", " '6184',\n", " '4386',\n", " '8123',\n", " '6141',\n", " '8743',\n", " '8178',\n", " '5529',\n", " '6504',\n", " '4577',\n", " '7016',\n", " '5951',\n", " '7221',\n", " '7341',\n", " '4935',\n", " '5350',\n", " '4241',\n", " '10776',\n", " '8385',\n", " '9310',\n", " '9129',\n", " '6926',\n", " '6753',\n", " '5278',\n", " '8467',\n", " '6851',\n", " '8079',\n", " '5799',\n", " '5323',\n", " '6039',\n", " '4316',\n", " '6283',\n", " '4943',\n", " '3890',\n", " '4808',\n", " '4001',\n", " '3395',\n", " '3007',\n", " '3974',\n", " '4212',\n", " '3939',\n", " '3633',\n", " '3935',\n", " '3488',\n", " '2943',\n", " '4078',\n", " '4874',\n", " '4130',\n", " '3535',\n", " '3375',\n", " '3678',\n", " '3332',\n", " '3774',\n", " '4650',\n", " '3702',\n", " '2842',\n", " '4083',\n", " '3013',\n", " '2362',\n", " '3589',\n", " '3373',\n", " '3308',\n", " '3169',\n", " '3775',\n", " '2418',\n", " '2175',\n", " '2296',\n", " '1813',\n", " '2232',\n", " '2620',\n", " '2803',\n", " '2573',\n", " '2293',\n", " '2775',\n", " '2331',\n", " '3553',\n", " '3390',\n", " '3406',\n", " '2723',\n", " '2567',\n", " '3847',\n", " '3636',\n", " '3436',\n", " '3268',\n", " '2904',\n", " '2480',\n", " '2228',\n", " '3512',\n", " '3078',\n", " '3029',\n", " '2788',\n", " '3010',\n", " '2321',\n", " '2248',\n", " '4392',\n", " '4285',\n", " '3915',\n", " '3735',\n", " '3373',\n", " '2778',\n", " '2536',\n", " '5633',\n", " '6214',\n", " '5631',\n", " '5111',\n", " '4718',\n", " '3953',\n", " '3731',\n", " '5286',\n", " '4965',\n", " '4642',\n", " '3994',\n", " '3966',\n", " '2872',\n", " '2904',\n", " '4153',\n", " '3659',\n", " '3729',\n", " '3551',\n", " '3046',\n", " '2702',\n", " '2647',\n", " '4327',\n", " '4248',\n", " '4148',\n", " '3838',\n", " '3374',\n", " '2824',\n", " '2851',\n", " '4723',\n", " '4387',\n", " '3999',\n", " '3356',\n", " '3157',\n", " '2605',\n", " '2574',\n", " '6111',\n", " '5542',\n", " '4914',\n", " '4602',\n", " '5368',\n", " '6491',\n", " '5700',\n", " '9339',\n", " '8757',\n", " '7830',\n", " '7114',\n", " '6899',\n", " '5876',\n", " '5850',\n", " '8282',\n", " '7868',\n", " '7179',\n", " '6772',\n", " '6549',\n", " '5199',\n", " '5239',\n", " '7471',\n", " '6872',\n", " '6750',\n", " '5792',\n", " '5372',\n", " '4508',\n", " '4286',\n", " '5106',\n", " '5622',\n", " '5315',\n", " '6660',\n", " '5718',\n", " '4555',\n", " '4764',\n", " '7351',\n", " '7223',\n", " '6903',\n", " '6402',\n", " '5505',\n", " '4164',\n", " '3806',\n", " '5915',\n", " '5983',\n", " '5490',\n", " '5203',\n", " '4545',\n", " '4155',\n", " '3685',\n", " '5169',\n", " '5539',\n", " '5079',\n", " '4724',\n", " '4377',\n", " '3421',\n", " '3382',\n", " '5266',\n", " '5086',\n", " '4652',\n", " '4649',\n", " '4142',\n", " '3445',\n", " '3564',\n", " '6413',\n", " '6322',\n", " '5443',\n", " '5048',\n", " '4661',\n", " '3841',\n", " '3506',\n", " '5802',\n", " '5569',\n", " '5406',\n", " '4764',\n", " '4138',\n", " '3329',\n", " '3261',\n", " '3685',\n", " '3777',\n", " '4065',\n", " '3432',\n", " '3113',\n", " '2602',\n", " '2535',\n", " '3225',\n", " '4707',\n", " '4295',\n", " '3867',\n", " '3458',\n", " '3031',\n", " '2855',\n", " '4241',\n", " '4080',\n", " '3898',\n", " '3602',\n", " '4066',\n", " '3649',\n", " '3591',\n", " '4700',\n", " '4743',\n", " '4733',\n", " '5277',\n", " '4944',\n", " '4007',\n", " '3563',\n", " '5598',\n", " '5711',\n", " '6039',\n", " '5583',\n", " '5128',\n", " '4712',\n", " '4401',\n", " '5426',\n", " '5173',\n", " '5452',\n", " '5356',\n", " '4633',\n", " '3968',\n", " '3852',\n", " '6465',\n", " '6501',\n", " '5882',\n", " '4935',\n", " '4215',\n", " '3986',\n", " '4058',\n", " '4981',\n", " '5184',\n", " '4660',\n", " '4415',\n", " '3994',\n", " '3639',\n", " '3715',\n", " '5601',\n", " '5961',\n", " '5442',\n", " '5049',\n", " '4983',\n", " '4235',\n", " '3683',\n", " '6015',\n", " '6499',\n", " '5482',\n", " '4844',\n", " '4609',\n", " '4085',\n", " '4171',\n", " '5602',\n", " '5885',\n", " '5233',\n", " '4854',\n", " '4593',\n", " '4061',\n", " '3826',\n", " '5165',\n", " '5250',\n", " '5170',\n", " '4975',\n", " '4180',\n", " '3131',\n", " '3084',\n", " '4007',\n", " '3986',\n", " '3800',\n", " '3718',\n", " '5263',\n", " '6950',\n", " '6408',\n", " '8183',\n", " '6894',\n", " '4845',\n", " '4745',\n", " '4732',\n", " '3646',\n", " '3422',\n", " '4754',\n", " '5024',\n", " '4924',\n", " '4782',\n", " '4736',\n", " '3695',\n", " '3469',\n", " '4792',\n", " '5278',\n", " '5165',\n", " '4935',\n", " '4334',\n", " '3854',\n", " '3744',\n", " '5545',\n", " '5564',\n", " '5419',\n", " '5002',\n", " '4372',\n", " '3706',\n", " '3690',\n", " '6286',\n", " '6326',\n", " '5387',\n", " '5251',\n", " '5268',\n", " '4784',\n", " '4752',\n", " '6303',\n", " '6436',\n", " '5968',\n", " '5450',\n", " '4714',\n", " '3853',\n", " '3850',\n", " '4836',\n", " '5184',\n", " '4971',\n", " '4721',\n", " '4259',\n", " '3615',\n", " '3421',\n", " '7595',\n", " '7727',\n", " '7042',\n", " '6406',\n", " '5637',\n", " '4545',\n", " '4619',\n", " '6725',\n", " '6845',\n", " '6017',\n", " '5938',\n", " '5464',\n", " '4567',\n", " '4378',\n", " '6339',\n", " '6202',\n", " '5653',\n", " '5414',\n", " '4851',\n", " '4117',\n", " '3969',\n", " '7376',\n", " '6909',\n", " '6166',\n", " '5716',\n", " '4939',\n", " '4233',\n", " '4411',\n", " '5482',\n", " '5334',\n", " '5284',\n", " '4904',\n", " '4625',\n", " '3877',\n", " '3845',\n", " '5287',\n", " '5371',\n", " '5225',\n", " '4946',\n", " '4651',\n", " '4102',\n", " '4000',\n", " '9347',\n", " '9485',\n", " '8423',\n", " '7536',\n", " '6528',\n", " '5147',\n", " '5050',\n", " '5525',\n", " '5686',\n", " '5280',\n", " '4770',\n", " '4223',\n", " '3881',\n", " '3872',\n", " '6164',\n", " '6306',\n", " '6006',\n", " '5472',\n", " '4886',\n", " '4060',\n", " '3992',\n", " '5339',\n", " '4938',\n", " '4907',\n", " '4589',\n", " '4387',\n", " '3547',\n", " '3364',\n", " '5500',\n", " '5432',\n", " '5118',\n", " '4662',\n", " '4244',\n", " '3747',\n", " '3449',\n", " '4142',\n", " '3344',\n", " '2565',\n", " '3067',\n", " '3427',\n", " '3332',\n", " '3473',\n", " '5364',\n", " '5023',\n", " '3423',\n", " '4917',\n", " '5234',\n", " '4502',\n", " '4076',\n", " '5966',\n", " '5914',\n", " '5446',\n", " '5310',\n", " '4886',\n", " '4354',\n", " '4109',\n", " '7475',\n", " '7329',\n", " '6602',\n", " '6144',\n", " '5311',\n", " '4295',\n", " '4098',\n", " '6834',\n", " '7243',\n", " '6074',\n", " '5456',\n", " '5141',\n", " '4236',\n", " '3946',\n", " '4689',\n", " '4713',\n", " '4545',\n", " '4513',\n", " '4088',\n", " '3267',\n", " '3248',\n", " '5591',\n", " '5615',\n", " '5235',\n", " '5050',\n", " '4576',\n", " '3899',\n", " '3882',\n", " '4828',\n", " '4728',\n", " '4432',\n", " '4257',\n", " '3975',\n", " '3291',\n", " '3234',\n", " '4890',\n", " '4962',\n", " '4652',\n", " '4179',\n", " '3869',\n", " '3535',\n", " '3459',\n", " '4430',\n", " '4134',\n", " '4200',\n", " '4331',\n", " '3721',\n", " '3251',\n", " '3133',\n", " '4875',\n", " '4811',\n", " '4533',\n", " '4277',\n", " '4111',\n", " '3724',\n", " '3592',\n", " '6365',\n", " '6457',\n", " '5669',\n", " '5043',\n", " '4402',\n", " '3837',\n", " '4020',\n", " '4025',\n", " '3907',\n", " '3731',\n", " '3412',\n", " '3448',\n", " '3179',\n", " '2944',\n", " '3819',\n", " '3923',\n", " '3853',\n", " '3665',\n", " '3505',\n", " '3119',\n", " '2975',\n", " '4398',\n", " '4123',\n", " '3987',\n", " '3603',\n", " '3621',\n", " '3268',\n", " '3132',\n", " '4252',\n", " '4364',\n", " '4024',\n", " '4035',\n", " '3615',\n", " '3411',\n", " '3061',\n", " '7018',\n", " '7633',\n", " '6452',\n", " '5789',\n", " '5017',\n", " '4510',\n", " '4417',\n", " '6723',\n", " '6172',\n", " '5586',\n", " '5327',\n", " '18594',\n", " '29204',\n", " '27034',\n", " '25683',\n", " '39981',\n", " '42257',\n", " '36688',\n", " '33608',\n", " '32412',\n", " '30899',\n", " '32088',\n", " '32827',\n", " '34381',\n", " '34167'],\n", " 34167,\n", " 42257,\n", " 9,\n", " 0,\n", " 1,\n", " 'South Africa'],\n", " ['https://open.spotify.com/track/16889jRQ2uzOeDSHaMRLIw',\n", " 'Sebastian - 2012 Remaster',\n", " 'Steve Harley & Cockney Rebel',\n", " datetime.date(1973, 11, 1),\n", " 661025,\n", " 27398,\n", " '2012 Chrysalis Records Limited',\n", " 'GB',\n", " ['7347',\n", " '7328',\n", " '7399',\n", " '6573',\n", " '6668',\n", " '6266',\n", " '6478',\n", " '6590',\n", " '7260',\n", " '8316',\n", " '6921',\n", " '6294',\n", " '6751',\n", " '6877',\n", " '7268',\n", " '8551',\n", " '8894',\n", " '7192',\n", " '6644',\n", " '6888',\n", " '7203',\n", " '6904',\n", " '8034',\n", " '8402',\n", " '7577',\n", " '8239',\n", " '8224',\n", " '8349',\n", " '8287',\n", " '9548',\n", " '9442',\n", " '7887',\n", " '7443',\n", " '7372',\n", " '7746',\n", " '7686',\n", " '8646',\n", " '8586',\n", " '7550',\n", " '6944',\n", " '7284',\n", " '7382',\n", " '7531',\n", " '9088',\n", " '9089',\n", " '7508',\n", " '7230',\n", " '6763',\n", " '7375',\n", " '7350',\n", " '8354',\n", " '8876',\n", " '7707',\n", " '7045',\n", " '7424',\n", " '7725',\n", " '7336',\n", " '8476',\n", " '8835',\n", " '7290',\n", " '7101',\n", " '7245',\n", " '7214',\n", " '8926',\n", " '10972',\n", " '10652',\n", " '8336',\n", " '7606',\n", " '8176',\n", " '8120',\n", " '8362',\n", " '9280',\n", " '9324',\n", " '7712',\n", " '7693',\n", " '9173',\n", " '8919',\n", " '8910',\n", " '10055',\n", " '9765',\n", " '7929',\n", " '7400',\n", " '8091',\n", " '8543',\n", " '8050',\n", " '9770',\n", " '9754',\n", " '7919',\n", " '7893',\n", " '8077',\n", " '8785',\n", " '8946',\n", " '9595',\n", " '9015',\n", " '8268',\n", " '7974',\n", " '7736',\n", " '8356',\n", " '8229',\n", " '9263',\n", " '9461',\n", " '7625',\n", " '7751',\n", " '7824',\n", " '8243',\n", " '8306',\n", " '9427',\n", " '9466',\n", " '7899',\n", " '7832',\n", " '7881',\n", " '8063',\n", " '8202',\n", " '8962',\n", " '9491',\n", " '7869',\n", " '7774',\n", " '7681',\n", " '8289',\n", " '8870',\n", " '10363',\n", " '9571',\n", " '8604',\n", " '7410',\n", " '8067',\n", " '10881',\n", " '8413',\n", " '9768',\n", " '10468',\n", " '7968',\n", " '7539',\n", " '7824',\n", " '8475',\n", " '8497',\n", " '9553',\n", " '10203',\n", " '7812',\n", " '7531',\n", " '8040',\n", " '7974',\n", " '8046',\n", " '9449',\n", " '10345',\n", " '7939',\n", " '7793',\n", " '7779',\n", " '7793',\n", " '8053',\n", " '9082',\n", " '9455',\n", " '7522',\n", " '7547',\n", " '7833',\n", " '8435',\n", " '8730',\n", " '9338',\n", " '9707',\n", " '7932',\n", " '7529',\n", " '8037',\n", " '8389',\n", " '8593',\n", " '9470',\n", " '9884',\n", " '7785',\n", " '7417',\n", " '7848',\n", " '7813',\n", " '8562',\n", " '9385',\n", " '9847',\n", " '7804',\n", " '7387',\n", " '7789',\n", " '7765',\n", " '8136',\n", " '9019',\n", " '9960',\n", " '7631',\n", " '7923',\n", " '7671',\n", " '7443',\n", " '7926',\n", " '9171',\n", " '9682',\n", " '7476',\n", " '6859',\n", " '7150',\n", " '7223',\n", " '7761',\n", " '8673',\n", " '9409',\n", " '8489',\n", " '8234',\n", " '7408',\n", " '7716',\n", " '7570',\n", " '8357',\n", " '9553',\n", " '8022',\n", " '7078',\n", " '7319',\n", " '7305',\n", " '7613',\n", " '8657',\n", " '9339',\n", " '7566',\n", " '7151',\n", " '7371',\n", " '7531',\n", " '7715',\n", " '8462',\n", " '8990',\n", " '7495',\n", " '6779',\n", " '6931',\n", " '7082',\n", " '6960',\n", " '8552',\n", " '9045',\n", " '7642',\n", " '6961',\n", " '6957',\n", " '7271',\n", " '7233',\n", " '8782',\n", " '9281',\n", " '7060',\n", " '6626',\n", " '6843',\n", " '7055',\n", " '6878',\n", " '8408',\n", " '9120',\n", " '6783',\n", " '6403',\n", " '6962',\n", " '7113',\n", " '7055',\n", " '8454',\n", " '8696',\n", " '7344',\n", " '7058',\n", " '6840',\n", " '7102',\n", " '7161',\n", " '8931',\n", " '9726',\n", " '7333',\n", " '6811',\n", " '7196',\n", " '7084',\n", " '7170',\n", " '8139',\n", " '8754',\n", " '7082',\n", " '6697',\n", " '6962',\n", " '6919',\n", " '7025',\n", " '8384',\n", " '8576',\n", " '6836',\n", " '6541',\n", " '6904',\n", " '7139',\n", " '7185',\n", " '8300',\n", " '8384',\n", " '6706',\n", " '6647',\n", " '7064',\n", " '7011',\n", " '7305',\n", " '8600',\n", " '8760',\n", " '6985',\n", " '6853',\n", " '7327',\n", " '7573',\n", " '7491',\n", " '8738',\n", " '8817',\n", " '7027',\n", " '6562',\n", " '8676',\n", " '7587',\n", " '7471',\n", " '8705',\n", " '9173',\n", " '6978',\n", " '6733',\n", " '6882',\n", " '6891',\n", " '7095',\n", " '8568',\n", " '8798',\n", " '7086',\n", " '6720',\n", " '7318',\n", " '7172',\n", " '7611',\n", " '8707',\n", " '9040',\n", " '7460',\n", " '6868',\n", " '7288',\n", " '7193',\n", " '7622',\n", " '9477',\n", " '10007',\n", " '7996',\n", " '7405',\n", " '7679',\n", " '7960',\n", " '7875',\n", " '9315',\n", " '9088',\n", " '8025',\n", " '6948',\n", " '7587',\n", " '7102',\n", " '7808',\n", " '9110',\n", " '9618',\n", " '7856',\n", " '6912',\n", " '7352',\n", " '7382',\n", " '7505',\n", " '8843',\n", " '9139',\n", " '7138',\n", " '6852',\n", " '7036',\n", " '7330',\n", " '7711',\n", " '8508',\n", " '8933',\n", " '7194',\n", " '6522',\n", " '6697',\n", " '7081',\n", " '7206',\n", " '8099',\n", " '8472',\n", " '6786',\n", " '6919',\n", " '7114',\n", " '7274',\n", " '7570',\n", " '8179',\n", " '8791',\n", " '7110',\n", " '7482',\n", " '7962',\n", " '8403',\n", " '8159',\n", " '8978',\n", " '8031',\n", " '8007',\n", " '7832',\n", " '8172',\n", " '8669',\n", " '13034',\n", " '9589',\n", " '8690',\n", " '7931',\n", " '7769',\n", " '7849',\n", " '7733',\n", " '8444',\n", " '9369',\n", " '10323',\n", " '8464',\n", " '7770',\n", " '8285',\n", " '8712',\n", " '8626',\n", " '9970',\n", " '10946',\n", " '8530',\n", " '8191',\n", " '8973',\n", " '8642',\n", " '8903',\n", " '10507',\n", " '10682',\n", " '8563',\n", " '8957',\n", " '8740',\n", " '8929',\n", " '8901',\n", " '10041',\n", " '10762',\n", " '8280',\n", " '8132',\n", " '8493',\n", " '8250',\n", " '8912',\n", " '10449',\n", " '10605',\n", " '8573',\n", " '8168',\n", " '8755',\n", " '8568',\n", " '8798',\n", " '10259',\n", " '10629',\n", " '8783',\n", " '8045',\n", " '8542',\n", " '8813',\n", " '9593',\n", " '10308',\n", " '10804',\n", " '8638',\n", " '8514',\n", " '8603',\n", " '8446',\n", " '8657',\n", " '10140',\n", " '10786',\n", " '8776',\n", " '8219',\n", " '8944',\n", " '8906',\n", " '8902',\n", " '9953',\n", " '10611',\n", " '8402',\n", " '8279',\n", " '8509',\n", " '8905',\n", " '10273',\n", " '10882',\n", " '10876',\n", " '8964',\n", " '9058',\n", " '9226',\n", " '9096',\n", " '9003',\n", " '10304',\n", " '10551',\n", " '8892',\n", " '8781',\n", " '8763',\n", " '9451',\n", " '10165',\n", " '10755',\n", " '10827',\n", " '9974',\n", " '9356',\n", " '8858',\n", " '9421',\n", " '9960',\n", " '10800',\n", " '10760',\n", " '8846',\n", " '8427',\n", " '9140',\n", " '9039',\n", " '9132',\n", " '10564',\n", " '11312',\n", " '9103',\n", " '9010',\n", " '9297',\n", " '9703',\n", " '9623',\n", " '11636',\n", " '11578',\n", " '9290',\n", " '9039',\n", " '9782',\n", " '9593',\n", " '10095',\n", " '11686',\n", " '12340',\n", " '9674',\n", " '9395',\n", " '9680',\n", " '10068',\n", " '10244',\n", " '11281',\n", " '11885',\n", " '9897',\n", " '9597',\n", " '9574',\n", " '10285',\n", " '10745',\n", " '11111',\n", " '11671',\n", " '9826',\n", " '9394',\n", " '9439',\n", " '9521',\n", " '10000',\n", " '11109',\n", " '11585',\n", " '9893',\n", " '9590',\n", " '9304',\n", " '9437',\n", " '9309',\n", " '11329',\n", " '12243',\n", " '10532',\n", " '10055',\n", " '9693',\n", " '10492',\n", " '10560',\n", " '12032',\n", " '12005',\n", " '10375',\n", " '10184',\n", " '10870',\n", " '10454',\n", " '10517',\n", " '11856',\n", " '12501',\n", " '11018',\n", " '10220',\n", " '10876',\n", " '11223',\n", " '11065',\n", " '11930',\n", " '11772',\n", " '9601',\n", " '9529',\n", " '10003',\n", " '9892',\n", " '9688',\n", " '11179',\n", " '11556',\n", " '10192',\n", " '9704',\n", " '9948',\n", " '9473',\n", " '10107',\n", " '10901',\n", " '10671',\n", " '8955',\n", " '8657',\n", " '9522',\n", " '9558',\n", " '9790',\n", " '11146',\n", " '11451',\n", " '10480',\n", " '10200',\n", " '10262',\n", " '9807',\n", " '9903',\n", " '11577',\n", " '12674',\n", " '10146',\n", " '11135',\n", " '10902',\n", " '10460',\n", " '10302',\n", " '11479',\n", " '12303',\n", " '9978',\n", " '11004',\n", " '11637',\n", " '10538',\n", " '10756',\n", " '11562',\n", " '12432',\n", " '10506',\n", " '11522',\n", " '10918',\n", " '11156',\n", " '11901',\n", " '12466',\n", " '12451',\n", " '10993',\n", " '11421',\n", " '10799',\n", " '10851',\n", " '10710',\n", " '12377',\n", " '11985',\n", " '9459',\n", " '9701',\n", " '10660',\n", " '9814',\n", " '10087',\n", " '11395',\n", " '11185',\n", " '9767',\n", " '9374',\n", " '10298',\n", " '10164',\n", " '10403',\n", " '11488',\n", " '11740',\n", " '9825',\n", " '10284',\n", " '10709',\n", " '9998',\n", " '10642',\n", " '12120',\n", " '11581',\n", " '10216',\n", " '10683',\n", " '11101',\n", " '10640',\n", " '9092',\n", " '11003',\n", " '11411',\n", " '9376',\n", " '9604',\n", " '9537',\n", " '9710',\n", " '10406',\n", " '11420',\n", " '11337',\n", " '9374',\n", " '9723',\n", " '9793',\n", " '10616',\n", " '11413',\n", " '33469',\n", " '16542',\n", " '12527',\n", " '12461',\n", " '13080',\n", " '12802',\n", " '12337',\n", " '12433',\n", " '11508',\n", " '9320',\n", " '9821',\n", " '9658',\n", " '9544',\n", " '10272',\n", " '11152',\n", " '11038',\n", " '9239',\n", " '9727',\n", " '10945',\n", " '11014',\n", " '11118',\n", " '12699',\n", " '12449',\n", " '10670',\n", " '10319',\n", " '10757',\n", " '10339',\n", " '10900',\n", " '12043',\n", " '12510',\n", " '10549',\n", " '10582',\n", " '11653',\n", " '11514',\n", " '11308',\n", " '11970',\n", " '11759',\n", " '9090',\n", " '9089',\n", " '9945',\n", " '9492',\n", " '9766',\n", " '11216',\n", " '11123',\n", " '9373',\n", " '9991',\n", " '9477',\n", " '9578',\n", " '9512',\n", " '11061',\n", " '11305',\n", " '9417',\n", " '9575',\n", " '9590',\n", " '8757',\n", " '10336',\n", " '11773',\n", " '12310',\n", " '10160',\n", " '9867',\n", " '10553',\n", " '10283',\n", " '10456',\n", " '11959',\n", " '11474',\n", " '9936',\n", " '9738',\n", " '10670',\n", " '10329',\n", " '10694',\n", " '12085',\n", " '11516',\n", " '10083',\n", " '10109',\n", " '10745',\n", " '10384',\n", " '9927',\n", " '11234',\n", " '11939',\n", " '9544',\n", " '10671',\n", " '10678',\n", " '10366',\n", " '10632',\n", " '11732',\n", " '11233',\n", " '9424',\n", " '10597',\n", " '10388',\n", " '10043',\n", " '10211',\n", " '11463',\n", " '11793',\n", " '9632',\n", " '10176',\n", " '10314',\n", " '10365',\n", " '10373',\n", " '11338',\n", " '11262',\n", " '11082',\n", " '10073',\n", " '10163',\n", " '10590',\n", " '10538',\n", " '11452',\n", " '15270',\n", " '11298',\n", " '10175',\n", " '10914',\n", " '10771',\n", " '10724',\n", " '11953',\n", " '12520',\n", " '10996',\n", " '10515',\n", " '10421',\n", " '10414',\n", " '11901',\n", " '12941',\n", " '13250',\n", " '11321',\n", " '10610',\n", " '10914',\n", " '10972',\n", " '12760',\n", " '12398',\n", " '13120',\n", " '10791',\n", " '11394',\n", " '11799',\n", " '11230',\n", " '11490',\n", " '13136',\n", " '13164',\n", " '10921',\n", " '10796',\n", " '11000',\n", " '11023',\n", " '12051',\n", " '13395',\n", " '13421',\n", " '10984',\n", " '10496',\n", " '11227',\n", " '11233',\n", " '11896',\n", " '12985',\n", " '12677',\n", " '10970',\n", " '10916',\n", " '11323',\n", " '10739',\n", " '11533',\n", " '13309',\n", " '13899',\n", " '11398',\n", " '11926',\n", " '11521',\n", " '11319',\n", " '11396',\n", " '12769',\n", " '12857',\n", " '11087',\n", " '11410',\n", " '11905',\n", " '11803',\n", " '11971',\n", " '13048',\n", " '13119',\n", " '11365',\n", " '11192',\n", " '11536',\n", " '11087',\n", " '11040',\n", " '12834',\n", " '13027',\n", " '11037',\n", " '10874',\n", " '11534',\n", " '11945',\n", " '13418',\n", " '14354',\n", " '14771',\n", " '13141',\n", " '12545',\n", " '12240',\n", " '11306',\n", " '13068',\n", " '13720',\n", " '14583',\n", " '11980',\n", " '11997',\n", " '12035',\n", " '11819',\n", " '11837',\n", " '13783',\n", " '13973',\n", " '11817',\n", " '11876',\n", " '12372',\n", " '12976',\n", " '12374',\n", " '13493',\n", " '13783',\n", " '12134',\n", " '11701',\n", " '11703',\n", " '11896',\n", " '12573',\n", " '14075',\n", " '13319',\n", " '12345',\n", " '11986',\n", " '11019',\n", " '10905',\n", " '11519',\n", " '14233',\n", " '14481',\n", " '11949',\n", " '12079',\n", " '12825',\n", " '12220',\n", " '12539',\n", " '14510',\n", " '14572',\n", " '13613',\n", " '15062',\n", " '15631',\n", " '14198',\n", " '13752',\n", " '15430',\n", " '15766',\n", " '13209',\n", " '13698',\n", " '18571',\n", " '25237',\n", " '18182',\n", " '19864',\n", " '21035',\n", " '19330',\n", " '18631',\n", " '19887',\n", " '22524',\n", " '18182',\n", " '19801',\n", " '20591',\n", " '18497',\n", " '19661',\n", " '20622',\n", " '22497',\n", " '20509',\n", " '22169',\n", " '20372',\n", " '18734',\n", " '19959',\n", " '20619',\n", " '22683',\n", " '19765',\n", " '21210',\n", " '21178',\n", " '17737',\n", " '18068',\n", " '18190',\n", " '19412',\n", " '17921',\n", " '19227',\n", " '19954',\n", " '17715',\n", " '16511',\n", " '17580',\n", " '19679',\n", " '18214',\n", " '19440',\n", " '22316',\n", " '20289',\n", " '17943',\n", " '19104',\n", " '19460',\n", " '18127',\n", " '20044',\n", " '19791',\n", " '16750',\n", " '17125',\n", " '18193',\n", " '18979',\n", " '18217',\n", " '19738',\n", " '21234',\n", " '21504',\n", " '18281',\n", " '17198',\n", " '16744',\n", " '15680',\n", " '17557',\n", " '18230',\n", " '18091',\n", " '15132',\n", " '16009',\n", " '15417',\n", " '15804',\n", " '17450',\n", " '18494',\n", " '18042',\n", " '15836',\n", " '15743',\n", " '15536',\n", " '16091',\n", " '17046',\n", " '18797',\n", " '18824',\n", " '15982',\n", " '16132',\n", " '15941',\n", " '16535',\n", " '17866',\n", " '19034',\n", " '19190',\n", " '16193',\n", " '16915',\n", " '16360',\n", " '16770',\n", " '18760',\n", " '18853',\n", " '19538',\n", " '17267',\n", " '17134',\n", " '16615',\n", " '16928',\n", " '18776',\n", " '19215',\n", " '20553',\n", " '17026',\n", " '16525',\n", " '16288',\n", " '16424',\n", " '17691',\n", " '21269',\n", " '19122',\n", " '16098',\n", " '16400',\n", " '16658',\n", " '16655',\n", " '18566',\n", " '20939',\n", " '18990',\n", " '16955',\n", " '16237',\n", " '16471',\n", " '16480',\n", " '18216',\n", " '22441',\n", " '20813',\n", " '16691',\n", " '16288',\n", " '16239',\n", " '16255',\n", " '18134',\n", " '20877',\n", " '18487',\n", " '15795',\n", " '15567',\n", " '15691',\n", " '16868',\n", " '19599',\n", " '22809',\n", " '19859',\n", " '17586',\n", " '18257',\n", " '18192',\n", " '18812',\n", " '20639',\n", " '22892',\n", " '19274',\n", " '17790',\n", " '18000',\n", " ...],\n", " 41756,\n", " 70509,\n", " 603,\n", " 0,\n", " 1,\n", " 'Monaco'],\n", " ['https://open.spotify.com/track/2Bls0igCm79XQQ95IoUbhq',\n", " 'Mr. Big Stuff',\n", " 'Jean Knight',\n", " None,\n", " 703014,\n", " 78728,\n", " '℗ 1990 Fantasy, Inc.',\n", " 'US',\n", " ['4509',\n", " '4181',\n", " '4632',\n", " '3878',\n", " '4175',\n", " '4232',\n", " '4383',\n", " '4503',\n", " '4762',\n", " '4954',\n", " '4043',\n", " '3849',\n", " '4372',\n", " '4485',\n", " '4573',\n", " '5178',\n", " '5403',\n", " '4415',\n", " '4140',\n", " '4322',\n", " '4359',\n", " '4771',\n", " '5117',\n", " '5270',\n", " '4235',\n", " '4023',\n", " '4317',\n", " '4552',\n", " '4853',\n", " '5505',\n", " '5134',\n", " '4110',\n", " '3888',\n", " '4157',\n", " '4259',\n", " '4703',\n", " '5172',\n", " '5077',\n", " '4335',\n", " '4278',\n", " '4488',\n", " '4394',\n", " '4823',\n", " '5106',\n", " '5257',\n", " '4333',\n", " '4007',\n", " '4454',\n", " '4513',\n", " '4591',\n", " '5283',\n", " '5227',\n", " '4510',\n", " '3990',\n", " '4546',\n", " '4459',\n", " '4650',\n", " '5120',\n", " '5046',\n", " '4257',\n", " '3930',\n", " '4411',\n", " '4488',\n", " '4564',\n", " '5426',\n", " '5303',\n", " '10670',\n", " '4999',\n", " '5028',\n", " '10518',\n", " '5551',\n", " '6335',\n", " '5637',\n", " '5138',\n", " '4747',\n", " '4977',\n", " '4858',\n", " '5040',\n", " '5962',\n", " '5476',\n", " '4790',\n", " '4650',\n", " '4915',\n", " '4886',\n", " '5068',\n", " '5957',\n", " '5540',\n", " '4681',\n", " '4771',\n", " '4909',\n", " '5118',\n", " '5352',\n", " '5906',\n", " '5571',\n", " '5044',\n", " '4768',\n", " '4750',\n", " '4627',\n", " '4851',\n", " '5380',\n", " '5255',\n", " '4197',\n", " '4336',\n", " '4490',\n", " '4719',\n", " '5037',\n", " '5515',\n", " '5564',\n", " '4305',\n", " '4218',\n", " '4752',\n", " '4678',\n", " '4736',\n", " '5741',\n", " '5311',\n", " '4407',\n", " '4289',\n", " '4392',\n", " '4762',\n", " '5184',\n", " '5442',\n", " '5535',\n", " '4630',\n", " '4402',\n", " '4623',\n", " '4645',\n", " '4805',\n", " '5235',\n", " '5179',\n", " '4695',\n", " '4270',\n", " '4487',\n", " '4561',\n", " '4953',\n", " '5420',\n", " '5126',\n", " '4375',\n", " '4102',\n", " '4446',\n", " '4635',\n", " '4659',\n", " '5091',\n", " '5072',\n", " '4546',\n", " '4310',\n", " '4391',\n", " '4331',\n", " '4602',\n", " '5254',\n", " '5055',\n", " '4311',\n", " '4814',\n", " '4432',\n", " '4729',\n", " '5130',\n", " '5681',\n", " '5444',\n", " '4918',\n", " '4402',\n", " '4865',\n", " '4694',\n", " '5045',\n", " '5183',\n", " '5554',\n", " '4486',\n", " '4345',\n", " '4664',\n", " '4954',\n", " '4904',\n", " '5638',\n", " '5324',\n", " '4652',\n", " '4202',\n", " '4517',\n", " '4627',\n", " '4934',\n", " '5238',\n", " '5348',\n", " '4451',\n", " '4346',\n", " '4598',\n", " '4742',\n", " '4715',\n", " '5136',\n", " '5303',\n", " '4210',\n", " '4110',\n", " '4352',\n", " '4402',\n", " '4689',\n", " '4884',\n", " '5367',\n", " '4390',\n", " '4022',\n", " '4403',\n", " '4666',\n", " '4822',\n", " '4947',\n", " '5084',\n", " '4355',\n", " '4206',\n", " '4853',\n", " '4840',\n", " '5010',\n", " '5272',\n", " '5567',\n", " '4712',\n", " '4392',\n", " '4718',\n", " '4869',\n", " '5071',\n", " '5502',\n", " '5474',\n", " '4689',\n", " '4959',\n", " '5345',\n", " '5180',\n", " '5077',\n", " '5321',\n", " '5663',\n", " '5006',\n", " '4916',\n", " '5150',\n", " '5624',\n", " '5335',\n", " '5696',\n", " '5747',\n", " '4856',\n", " '4781',\n", " '5304',\n", " '5353',\n", " '5341',\n", " '5997',\n", " '5562',\n", " '4846',\n", " '4867',\n", " '5366',\n", " '5220',\n", " '5303',\n", " '5862',\n", " '5600',\n", " '4959',\n", " '4585',\n", " '5148',\n", " '4924',\n", " '5298',\n", " '5685',\n", " '5807',\n", " '5069',\n", " '4856',\n", " '4870',\n", " '4980',\n", " '5118',\n", " '5488',\n", " '5452',\n", " '4416',\n", " '4671',\n", " '4925',\n", " '5090',\n", " '5468',\n", " '5628',\n", " '5478',\n", " '4425',\n", " '4641',\n", " '5500',\n", " '5228',\n", " '5533',\n", " '5683',\n", " '5411',\n", " '4543',\n", " '4938',\n", " '5443',\n", " '5253',\n", " '5342',\n", " '5930',\n", " '5587',\n", " '4435',\n", " '5081',\n", " '5686',\n", " '5714',\n", " '5708',\n", " '6216',\n", " '6002',\n", " '4844',\n", " '5295',\n", " '5598',\n", " '5449',\n", " '5649',\n", " '5868',\n", " '5859',\n", " '4747',\n", " '4986',\n", " '5284',\n", " '5690',\n", " '6091',\n", " '6726',\n", " '6188',\n", " '4975',\n", " '5325',\n", " '5884',\n", " '6308',\n", " '6148',\n", " '6516',\n", " '6265',\n", " '5135',\n", " '5368',\n", " '5646',\n", " '5950',\n", " '6320',\n", " '6688',\n", " '6299',\n", " '5205',\n", " '4966',\n", " '5047',\n", " '5142',\n", " '5496',\n", " '5809',\n", " '5677',\n", " '4895',\n", " '4531',\n", " '4716',\n", " '5071',\n", " '5452',\n", " '5879',\n", " '5695',\n", " '4771',\n", " '4396',\n", " '4795',\n", " '5210',\n", " '5523',\n", " '5166',\n", " '5393',\n", " '4544',\n", " '4266',\n", " '4459',\n", " '4815',\n", " '12318',\n", " '7252',\n", " '6233',\n", " '5161',\n", " '5023',\n", " '5173',\n", " '5123',\n", " '5168',\n", " '5235',\n", " '5202',\n", " '4137',\n", " '4104',\n", " '4230',\n", " '4247',\n", " '4725',\n", " '4812',\n", " '4955',\n", " '4070',\n", " '3805',\n", " '4357',\n", " '4423',\n", " '4241',\n", " '3805',\n", " '3937',\n", " '3990',\n", " '4098',\n", " '4607',\n", " '4902',\n", " '6694',\n", " '4969',\n", " '4410',\n", " '4071',\n", " '4055',\n", " '4442',\n", " '4582',\n", " '4850',\n", " '5230',\n", " '5445',\n", " '4607',\n", " '3956',\n", " '4109',\n", " '4446',\n", " '4879',\n", " '5293',\n", " '5531',\n", " '4552',\n", " '4454',\n", " '4518',\n", " '4552',\n", " '4910',\n", " '5531',\n", " '5650',\n", " '4597',\n", " '4377',\n", " '4814',\n", " '4974',\n", " '5141',\n", " '5541',\n", " '5836',\n", " '4877',\n", " '4482',\n", " '4923',\n", " '4698',\n", " '5317',\n", " '5772',\n", " '5859',\n", " '4905',\n", " '4782',\n", " '4764',\n", " '5225',\n", " '5566',\n", " '6028',\n", " '5990',\n", " '5102',\n", " '4668',\n", " '4761',\n", " '5107',\n", " '5388',\n", " '5952',\n", " '6444',\n", " '5320',\n", " '5155',\n", " '5367',\n", " '5759',\n", " '5455',\n", " '6485',\n", " '6253',\n", " '5263',\n", " '4855',\n", " '5256',\n", " '5786',\n", " '5959',\n", " '6902',\n", " '6298',\n", " '5368',\n", " '5485',\n", " '15918',\n", " '8230',\n", " '6554',\n", " '6884',\n", " '6539',\n", " '5545',\n", " '5454',\n", " '7178',\n", " '6054',\n", " '5975',\n", " '6139',\n", " '6041',\n", " '5550',\n", " '4978',\n", " '5920',\n", " '5661',\n", " '5714',\n", " '6420',\n", " '6447',\n", " '11722',\n", " '5907',\n", " '5599',\n", " '5883',\n", " '5932',\n", " '6674',\n", " '6562',\n", " '11656',\n", " '6215',\n", " '6375',\n", " '6216',\n", " '6561',\n", " '7264',\n", " '7225',\n", " '5768',\n", " '5545',\n", " '5985',\n", " '6533',\n", " '6346',\n", " '6856',\n", " '7275',\n", " '5880',\n", " '5658',\n", " '6101',\n", " '6242',\n", " '6441',\n", " '6816',\n", " '7231',\n", " '5838',\n", " '5658',\n", " '5945',\n", " '6024',\n", " '6333',\n", " '6784',\n", " '6934',\n", " '5755',\n", " '5605',\n", " '5626',\n", " '6009',\n", " '6348',\n", " '6923',\n", " '7106',\n", " '6230',\n", " '5426',\n", " '5830',\n", " '6054',\n", " '6343',\n", " '6716',\n", " '6923',\n", " '5816',\n", " '5478',\n", " '5595',\n", " '6014',\n", " '6353',\n", " '6915',\n", " '6595',\n", " '5966',\n", " '5614',\n", " '5721',\n", " '6316',\n", " '6642',\n", " '7252',\n", " '7054',\n", " '6277',\n", " '5851',\n", " '5723',\n", " '6197',\n", " '6326',\n", " '6996',\n", " '7219',\n", " '6175',\n", " '5668',\n", " '6126',\n", " '6277',\n", " '6442',\n", " '6906',\n", " '6735',\n", " '5910',\n", " '5360',\n", " '5982',\n", " '6197',\n", " '5987',\n", " '6523',\n", " '6817',\n", " '6108',\n", " '5297',\n", " '5839',\n", " '5892',\n", " '6117',\n", " '6674',\n", " '6582',\n", " '5683',\n", " '5166',\n", " '5686',\n", " '5871',\n", " '6142',\n", " '6811',\n", " '6753',\n", " '5948',\n", " '5858',\n", " '6146',\n", " '6095',\n", " '5988',\n", " '6742',\n", " '6855',\n", " '5502',\n", " '5660',\n", " '5903',\n", " '6176',\n", " '6446',\n", " '6949',\n", " '6975',\n", " '6236',\n", " '5872',\n", " '6081',\n", " '6335',\n", " '6464',\n", " '7030',\n", " '7419',\n", " '6337',\n", " '5681',\n", " '5866',\n", " '6253',\n", " '6650',\n", " '7119',\n", " '7246',\n", " '6009',\n", " '5951',\n", " '6063',\n", " '6367',\n", " '6692',\n", " '7236',\n", " '7079',\n", " '5922',\n", " '5754',\n", " '6089',\n", " '6325',\n", " '6505',\n", " '7404',\n", " '7158',\n", " '6286',\n", " '6171',\n", " '6729',\n", " '6810',\n", " '6731',\n", " '7297',\n", " '7255',\n", " '6271',\n", " '6129',\n", " '6637',\n", " '7058',\n", " '7235',\n", " '7739',\n", " '7720',\n", " '6818',\n", " '6468',\n", " '6654',\n", " '6847',\n", " '6877',\n", " '7546',\n", " '7487',\n", " '6733',\n", " '6415',\n", " '6487',\n", " '6879',\n", " '6995',\n", " '7630',\n", " '7849',\n", " '6557',\n", " '6472',\n", " '6850',\n", " '7151',\n", " '7233',\n", " '8309',\n", " '9911',\n", " '30829',\n", " '9376',\n", " '8953',\n", " '8817',\n", " '9453',\n", " '9867',\n", " '9751',\n", " '28599',\n", " '9490',\n", " '8793',\n", " '9454',\n", " '9502',\n", " '10011',\n", " '10521',\n", " '30207',\n", " '9999',\n", " '9462',\n", " '9558',\n", " '9846',\n", " '10138',\n", " '10712',\n", " '32507',\n", " '10440',\n", " '9902',\n", " '10134',\n", " '10055',\n", " '10141',\n", " '11052',\n", " '28770',\n", " '13849',\n", " '10968',\n", " '12960',\n", " '13561',\n", " '10889',\n", " '11300',\n", " '35175',\n", " '10686',\n", " '10152',\n", " '10345',\n", " '10234',\n", " '11094',\n", " '11347',\n", " '42885',\n", " '11078',\n", " '10339',\n", " '10152',\n", " '10142',\n", " '11457',\n", " '12025',\n", " '17535',\n", " '9062',\n", " '9044',\n", " '8226',\n", " '9580',\n", " '10482',\n", " '11132',\n", " '18124',\n", " '9686',\n", " '9809',\n", " '9654',\n", " '9938',\n", " '10808',\n", " '11565',\n", " '41184',\n", " '11035',\n", " '11015',\n", " '11537',\n", " '12176',\n", " '12397',\n", " '12071',\n", " '15644',\n", " '9408',\n", " '9213',\n", " '9784',\n", " '9316',\n", " '10189',\n", " '11051',\n", " '24360',\n", " '10457',\n", " '10379',\n", " '10347',\n", " '10656',\n", " '11171',\n", " '11844',\n", " '24258',\n", " '10317',\n", " '9948',\n", " '9849',\n", " '9960',\n", " '10713',\n", " '11611',\n", " '31087',\n", " '10436',\n", " '10209',\n", " '10349',\n", " '10318',\n", " '10701',\n", " '10223',\n", " '10605',\n", " '9397',\n", " '9788',\n", " '10702',\n", " '11251',\n", " '9465',\n", " '12452',\n", " '9011',\n", " '7353',\n", " '7892',\n", " '8449',\n", " '8656',\n", " '8996',\n", " '9335',\n", " '8420',\n", " '7963',\n", " '8303',\n", " '8469',\n", " '9320',\n", " '9874',\n", " '10176',\n", " '8533',\n", " '7801',\n", " '8313',\n", " '8776',\n", " '9123',\n", " '9866',\n", " '10064',\n", " '8388',\n", " '8114',\n", " '8291',\n", " '8748',\n", " '8920',\n", " '9780',\n", " '10294',\n", " '8590',\n", " '7860',\n", " '8494',\n", " '9661',\n", " '10128',\n", " '11217',\n", " '10760',\n", " '9419',\n", " '9262',\n", " '9539',\n", " '10326',\n", " '10203',\n", " '11287',\n", " '10937',\n", " '9351',\n", " '8672',\n", " '9177',\n", " '9583',\n", " '9447',\n", " '10539',\n", " '10665',\n", " '9222',\n", " '8803',\n", " '8917',\n", " '9132',\n", " '9406',\n", " '10475',\n", " '10589',\n", " '9029',\n", " '8450',\n", " '9127',\n", " '9502',\n", " '11309',\n", " '11203',\n", " '11147',\n", " '9442',\n", " '9310',\n", " '9744',\n", " '26873',\n", " '16599',\n", " '12907',\n", " '12054',\n", " '9868',\n", " '9424',\n", " '9939',\n", " '11336',\n", " '11450',\n", " '11915',\n", " '12053',\n", " '10447',\n", " '10320',\n", " '10868',\n", " '11493',\n", " '14827',\n", " '12849',\n", " '12768',\n", " '10813',\n", " '10495',\n", " '10730',\n", " '10914',\n", " '11984',\n", " '12071',\n", " '12531',\n", " '10593',\n", " '9945',\n", " '10355',\n", " '10613',\n", " '10285',\n", " '10989',\n", " '11080',\n", " '9732',\n", " '9647',\n", " '10158',\n", " '10597',\n", " '11240',\n", " '11544',\n", " '11414',\n", " '11236',\n", " '10326',\n", " '10034',\n", " '10551',\n", " '11454',\n", " '12901',\n", " '12571',\n", " '10941',\n", " '10830',\n", " '10797',\n", " '11165',\n", " '11358',\n", " '12662',\n", " '12902',\n", " '12399',\n", " '11430',\n", " '11346',\n", " '12189',\n", " '12771',\n", " '13742',\n", " '14145',\n", " '13978',\n", " '13401',\n", " '13770',\n", " '14337',\n", " '14281',\n", " '14782',\n", " '14903',\n", " '13699',\n", " '12683',\n", " '13234',\n", " '13385',\n", " '13545',\n", " '14986',\n", " '15352',\n", " '13555',\n", " '12779',\n", " '13074',\n", " '13361',\n", " '13388',\n", " '15200',\n", " '14519',\n", " '13399',\n", " '12356',\n", " '12308',\n", " '12655',\n", " '13183',\n", " '14015',\n", " '13833',\n", " '11850',\n", " '11423',\n", " '12437',\n", " '13250',\n", " '13159',\n", " '13915',\n", " '14848',\n", " '12791',\n", " '11674',\n", " '12159',\n", " '12932',\n", " '12989',\n", " '14405',\n", " '15543',\n", " '14082',\n", " '11946',\n", " '12441',\n", " '12809',\n", " '13440',\n", " '13985',\n", " '14483',\n", " '12299',\n", " '11667',\n", " '12299',\n", " '12940',\n", " '13203',\n", " '14842',\n", " '15197',\n", " '14033',\n", " '12864',\n", " '13914',\n", " '13446',\n", " '13941',\n", " '14644',\n", " '15528',\n", " '13113',\n", " '12504',\n", " '12988',\n", " '13446',\n", " '13110',\n", " '13304',\n", " '14230',\n", " '11882',\n", " '11975',\n", " '12528',\n", " '12858',\n", " '59668',\n", " '23221',\n", " '17043',\n", " '14503',\n", " '14863',\n", " '13043',\n", " '13339',\n", " '58903',\n", " '23533',\n", " '18233',\n", " '16916',\n", " '15910',\n", " '21843',\n", " '18058',\n", " '23807',\n", " '15941',\n", " '15836',\n", " '15042',\n", " '13233',\n", " '13477',\n", " '13435',\n", " '13663',\n", " '14327',\n", " '14595',\n", " '13067',\n", " '12147',\n", " '13134',\n", " '12955',\n", " '13331',\n", " '14707',\n", " '15386',\n", " '14391',\n", " '13079',\n", " '13505',\n", " '13881',\n", " '14383',\n", " '15628',\n", " '15596',\n", " '14464',\n", " '13441',\n", " '13135',\n", " '14085',\n", " '14015',\n", " '15738',\n", " '16192',\n", " '14925',\n", " '13756',\n", " '13611',\n", " '13743',\n", " '13331',\n", " '14430',\n", " '14501',\n", " '12670',\n", " '11738',\n", " '12672',\n", " '13134',\n", " '13610',\n", " '14768',\n", " '14915',\n", " '12780',\n", " '12092',\n", " '12445',\n", " '13335',\n", " '14703',\n", " '16329',\n", " '16006',\n", " '15120',\n", " '13300',\n", " '14065',\n", " ...],\n", " 39225,\n", " 67975,\n", " 314,\n", " 0,\n", " 1,\n", " 'Monaco'],\n", " ['https://open.spotify.com/track/2GV039LpIeFtgTKKIZPrf0',\n", " 'In the Air Tonight',\n", " 'Nonpoint',\n", " datetime.date(2004, 7, 13),\n", " 955137,\n", " 21590,\n", " '2004 Lava Records LLC for the United States and WEA International Inc. for the world outside of the United States.',\n", " 'US',\n", " ['15753',\n", " '20696',\n", " '20207',\n", " '17461',\n", " '22662',\n", " '23936',\n", " '25094',\n", " '24670',\n", " '25158',\n", " '20964',\n", " '18800',\n", " '25034',\n", " '26413',\n", " '26017',\n", " '26498',\n", " '27118',\n", " '21996',\n", " '18405',\n", " '24061',\n", " '25920',\n", " '27077',\n", " '27175',\n", " '27415',\n", " '21494',\n", " '19871',\n", " '25445',\n", " '26142',\n", " '25761',\n", " '26694',\n", " '26449',\n", " '22046',\n", " '18730',\n", " '22003',\n", " '25644',\n", " '26654',\n", " '26143',\n", " '26367',\n", " '21855',\n", " '19264',\n", " '24918',\n", " '26430',\n", " '26317',\n", " '26812',\n", " '26374',\n", " '20975',\n", " '18259',\n", " '23497',\n", " '26449',\n", " '26977',\n", " '26248',\n", " '27952',\n", " '21660',\n", " '20049',\n", " '24486',\n", " '24725',\n", " '24845',\n", " '24940',\n", " '25350',\n", " '20640',\n", " '17927',\n", " '22584',\n", " '25530',\n", " '25248',\n", " '23880',\n", " '25384',\n", " '20705',\n", " '18618',\n", " '23974',\n", " '25703',\n", " '25000',\n", " '25399',\n", " '25557',\n", " '21413',\n", " '18419',\n", " '24313',\n", " '25389',\n", " '24296',\n", " '25054',\n", " '25636',\n", " '20877',\n", " '18046',\n", " '23817',\n", " '25067',\n", " '25348',\n", " '26467',\n", " '26411',\n", " '20361',\n", " '17973',\n", " '25392',\n", " '27222',\n", " '26290',\n", " '27165',\n", " '25212',\n", " '22731',\n", " '18382',\n", " '24503',\n", " '27046',\n", " '27298',\n", " '27592',\n", " '27616',\n", " '23293',\n", " '20566',\n", " '25469',\n", " '26692',\n", " '27977',\n", " '27270',\n", " '28729',\n", " '23731',\n", " '20899',\n", " '26360',\n", " '28253',\n", " '28382',\n", " '27385',\n", " '29617',\n", " '24140',\n", " '22282',\n", " '27828',\n", " '30433',\n", " '30768',\n", " '29932',\n", " '29341',\n", " '25049',\n", " '22126',\n", " '28778',\n", " '30955',\n", " '29658',\n", " '30671',\n", " '30395',\n", " '25225',\n", " '21162',\n", " '29092',\n", " '30258',\n", " '30491',\n", " '30762',\n", " '30887',\n", " '24474',\n", " '20648',\n", " '29598',\n", " '30400',\n", " '30821',\n", " '29773',\n", " '31996',\n", " '24825',\n", " '21334',\n", " '23135',\n", " '29804',\n", " '30740',\n", " '30167',\n", " '31107',\n", " '24655',\n", " '21404',\n", " '27375',\n", " '29668',\n", " '30881',\n", " '30487',\n", " '30552',\n", " '24773',\n", " '22315',\n", " '27941',\n", " '30440',\n", " '30952',\n", " '30169',\n", " '29751',\n", " '24870',\n", " '21502',\n", " '27609',\n", " '28658',\n", " '29821',\n", " '29391',\n", " '30504',\n", " '25011',\n", " '20990',\n", " '27623',\n", " '29194',\n", " '27987',\n", " '29090',\n", " '29427',\n", " '24244',\n", " '20890',\n", " '26641',\n", " '28434',\n", " '29022',\n", " '28754',\n", " '25538',\n", " '20334',\n", " '18595',\n", " '24872',\n", " '27529',\n", " '28051',\n", " '27847',\n", " '27192',\n", " '23597',\n", " '21179',\n", " '26161',\n", " '27551',\n", " '29038',\n", " '28215',\n", " '27813',\n", " '23261',\n", " '20645',\n", " '26453',\n", " '29227',\n", " '30333',\n", " '29860',\n", " '29522',\n", " '23810',\n", " '21350',\n", " '26775',\n", " '28858',\n", " '28362',\n", " '28356',\n", " '28409',\n", " '24588',\n", " '20338',\n", " '28727',\n", " '29219',\n", " '29910',\n", " '29480',\n", " '30795',\n", " '24376',\n", " '22806',\n", " '27921',\n", " '28630',\n", " '28991',\n", " '29193',\n", " '29269',\n", " '24032',\n", " '21552',\n", " '26594',\n", " '28105',\n", " '28195',\n", " '29048',\n", " '28288',\n", " '23631',\n", " '20527',\n", " '27050',\n", " '28210',\n", " '28433',\n", " '28848',\n", " '28741',\n", " '23866',\n", " '20797',\n", " '27124',\n", " '29174',\n", " '29100',\n", " '29373',\n", " '29019',\n", " '23268',\n", " '20320',\n", " '22632',\n", " '27993',\n", " '28802',\n", " '29684',\n", " '29328',\n", " '23840',\n", " '19947',\n", " '27920',\n", " '29590',\n", " '29279',\n", " '29006',\n", " '28358',\n", " '22665',\n", " '19659',\n", " '26282',\n", " '29182',\n", " '29072',\n", " '27963',\n", " '28342',\n", " '22528',\n", " '19720',\n", " '27501',\n", " '28879',\n", " '29477',\n", " '29247',\n", " '28956',\n", " '24254',\n", " '19736',\n", " '26623',\n", " '29242',\n", " '29614',\n", " '30120',\n", " '29495',\n", " '23709',\n", " '20440',\n", " '25720',\n", " '28486',\n", " '29258',\n", " '28889',\n", " '29200',\n", " '23571',\n", " '19856',\n", " '27321',\n", " '28982',\n", " '29261',\n", " '28965',\n", " '28757',\n", " '23364',\n", " '19734',\n", " '26571',\n", " '29627',\n", " '29380',\n", " '30536',\n", " '29228',\n", " '23063',\n", " '19272',\n", " '27118',\n", " '28710',\n", " '29631',\n", " '29284',\n", " '29199',\n", " '24123',\n", " '20402',\n", " '26781',\n", " '28393',\n", " '27433',\n", " '28156',\n", " '29350',\n", " '22796',\n", " '19585',\n", " '26665',\n", " '28082',\n", " '29239',\n", " '29435',\n", " '29144',\n", " '22443',\n", " '19736',\n", " '26216',\n", " '29258',\n", " '29818',\n", " '22870',\n", " '22460',\n", " '20793',\n", " '19117',\n", " '26267',\n", " '30007',\n", " '30182',\n", " '29885',\n", " '29183',\n", " '23822',\n", " '20728',\n", " '28273',\n", " '29854',\n", " '30514',\n", " '31248',\n", " '30426',\n", " '24484',\n", " '21090',\n", " '28841',\n", " '30657',\n", " '29967',\n", " '29911',\n", " '28809',\n", " '23224',\n", " '20437',\n", " '26987',\n", " '28094',\n", " '30641',\n", " '23986',\n", " '15648',\n", " '18703',\n", " '18113',\n", " '23627',\n", " '25250',\n", " '26798',\n", " '25868',\n", " '18707',\n", " '20376',\n", " '19575',\n", " '25927',\n", " '28615',\n", " '28122',\n", " '28540',\n", " '29356',\n", " '24149',\n", " '20829',\n", " '27541',\n", " '29477',\n", " '28509',\n", " '29702',\n", " '30840',\n", " '25832',\n", " '20592',\n", " '27002',\n", " '29563',\n", " '29251',\n", " '28981',\n", " '28911',\n", " '23791',\n", " '21015',\n", " '27822',\n", " '30358',\n", " '30760',\n", " '31175',\n", " '31489',\n", " '26624',\n", " '23438',\n", " '29154',\n", " '31151',\n", " '29805',\n", " '30885',\n", " '31726',\n", " '25935',\n", " '22462',\n", " '26979',\n", " '30169',\n", " '30751',\n", " '31098',\n", " '31779',\n", " '25626',\n", " '21918',\n", " '27985',\n", " '31526',\n", " '32359',\n", " '32069',\n", " '31952',\n", " '27135',\n", " '22324',\n", " '29745',\n", " '32428',\n", " '33359',\n", " '32976',\n", " '33276',\n", " '26763',\n", " '23627',\n", " '30601',\n", " '33185',\n", " '31916',\n", " '32057',\n", " '32608',\n", " '27168',\n", " '23091',\n", " '30489',\n", " '32814',\n", " '33522',\n", " '32631',\n", " '32705',\n", " '27503',\n", " '23467',\n", " '30640',\n", " '32800',\n", " '33003',\n", " '32674',\n", " '34035',\n", " '27483',\n", " '23263',\n", " '31234',\n", " '32966',\n", " '34119',\n", " '34277',\n", " '31923',\n", " '27755',\n", " '22175',\n", " '29915',\n", " '33399',\n", " '34088',\n", " '35687',\n", " '34901',\n", " '27929',\n", " '25190',\n", " '31837',\n", " '34947',\n", " '34942',\n", " '35081',\n", " '34441',\n", " '27195',\n", " '24477',\n", " '32074',\n", " '33073',\n", " '33257',\n", " '34178',\n", " '33873',\n", " '28068',\n", " '23930',\n", " '31840',\n", " '32399',\n", " '32616',\n", " '32534',\n", " '31987',\n", " '27158',\n", " '23966',\n", " '31137',\n", " '33186',\n", " '32798',\n", " '32897',\n", " '34369',\n", " '29433',\n", " '24675',\n", " '30672',\n", " '33280',\n", " '34019',\n", " '32563',\n", " '33193',\n", " '28088',\n", " '22395',\n", " '30240',\n", " '31652',\n", " '33711',\n", " '34892',\n", " '35521',\n", " '33198',\n", " '28023',\n", " '36605',\n", " '41625',\n", " '43049',\n", " '42669',\n", " '42704',\n", " '33486',\n", " '29819',\n", " '40076',\n", " '41364',\n", " '42435',\n", " '42052',\n", " '40367',\n", " '33593',\n", " '28038',\n", " '32962',\n", " '39166',\n", " '41280',\n", " '41253',\n", " '41681',\n", " '33991',\n", " '28304',\n", " '42512',\n", " '42391',\n", " '42448',\n", " '42287',\n", " '40617',\n", " '33593',\n", " '29101',\n", " '37982',\n", " '39428',\n", " '41211',\n", " '41180',\n", " '40163',\n", " '33053',\n", " '28911',\n", " '36902',\n", " '38409',\n", " '37578',\n", " '39478',\n", " '42556',\n", " '36314',\n", " '29796',\n", " '39778',\n", " '41808',\n", " '42192',\n", " '43177',\n", " '41408',\n", " '33573',\n", " '29055',\n", " '30762',\n", " '35531',\n", " '39346',\n", " '45103',\n", " '73227',\n", " '59505',\n", " '49988',\n", " '69014',\n", " '68150',\n", " '67239',\n", " '62927',\n", " '58167',\n", " '47819',\n", " '38024',\n", " '50199',\n", " '51885',\n", " '52276',\n", " '51153',\n", " '50658',\n", " '39639',\n", " '34907',\n", " '46346',\n", " '49894',\n", " '49603',\n", " '50718',\n", " '48455',\n", " '39056',\n", " '32885',\n", " '46717',\n", " '49860',\n", " '49150',\n", " '50323',\n", " '48165',\n", " '36809',\n", " '32385',\n", " '42518',\n", " '46168',\n", " '44977',\n", " '44988',\n", " '43455',\n", " '35031',\n", " '31262',\n", " '40144',\n", " '43369',\n", " '43758',\n", " '42815',\n", " '42585',\n", " '34844',\n", " '31431',\n", " '40605',\n", " '42947',\n", " '42045',\n", " '43481',\n", " '42240',\n", " '33772',\n", " '29265',\n", " '40869',\n", " '42091',\n", " '42976',\n", " '42985',\n", " '42864',\n", " '33609',\n", " '29521',\n", " '33985',\n", " '40317',\n", " '41379',\n", " '41338',\n", " '42482',\n", " '32935',\n", " '28739',\n", " '39498',\n", " '42048',\n", " '41285',\n", " '41985',\n", " '41485',\n", " '34004',\n", " '29691',\n", " '39443',\n", " '41129',\n", " '40589',\n", " '41064',\n", " '41525',\n", " '33775',\n", " '27974',\n", " '38219',\n", " '40773',\n", " '41948',\n", " '43919',\n", " '44251',\n", " '35167',\n", " '30070',\n", " '40657',\n", " '42742',\n", " '42602',\n", " '40584',\n", " '41195',\n", " '32945',\n", " '28040',\n", " '38894',\n", " '42079',\n", " '41145',\n", " '42500',\n", " '40847',\n", " '33243',\n", " '27936',\n", " '40200',\n", " '43011',\n", " '42210',\n", " '41377',\n", " '40187',\n", " '32019',\n", " '27588',\n", " '37963',\n", " '39478',\n", " '39914',\n", " '40217',\n", " '38231',\n", " '31178',\n", " '25775',\n", " '34644',\n", " '37249',\n", " '40193',\n", " '38632',\n", " '39471',\n", " '32193',\n", " '26281',\n", " '35605',\n", " '38909',\n", " '36334',\n", " '40664',\n", " '40747',\n", " '33172',\n", " '28177',\n", " '38805',\n", " '42109',\n", " '42901',\n", " '41023',\n", " '39876',\n", " '32675',\n", " '28193',\n", " '36489',\n", " '38865',\n", " '41653',\n", " '32896',\n", " '30804',\n", " '30441',\n", " '27807',\n", " '36761',\n", " '40544',\n", " '41721',\n", " '42132',\n", " '42612',\n", " '34647',\n", " '28641',\n", " '37393',\n", " '41752',\n", " '41030',\n", " '39785',\n", " '39969',\n", " '32132',\n", " '27744',\n", " '38265',\n", " '41265',\n", " '42720',\n", " '41857',\n", " '42091',\n", " '36192',\n", " '29914',\n", " '37905',\n", " '42254',\n", " '43356',\n", " '43224',\n", " '40878',\n", " '31133',\n", " '22882',\n", " '29229',\n", " '38482',\n", " '40665',\n", " '43401',\n", " '39786',\n", " '34720',\n", " '27498',\n", " '33744',\n", " '42743',\n", " '44218',\n", " '45798',\n", " '44139',\n", " '38317',\n", " '33629',\n", " '43809',\n", " '46197',\n", " '48875',\n", " '50672',\n", " '48546',\n", " '40479',\n", " '35201',\n", " '42698',\n", " '47000',\n", " '49912',\n", " '50468',\n", " '49152',\n", " '41302',\n", " '35657',\n", " '45401',\n", " '49399',\n", " '50979',\n", " '51798',\n", " '51895',\n", " '42873',\n", " '36771',\n", " '49409',\n", " '55371',\n", " '56940',\n", " '57340',\n", " '56284',\n", " '45512',\n", " '42225',\n", " '50449',\n", " '55530',\n", " '57158',\n", " '57751',\n", " '59030',\n", " '48695',\n", " '42373',\n", " '53646',\n", " '56158',\n", " '57333',\n", " '58479',\n", " '58140',\n", " '47373',\n", " '41341',\n", " '50174',\n", " '55139',\n", " '57429',\n", " '56113',\n", " '57237',\n", " '46778',\n", " '40049',\n", " '51454',\n", " '54350',\n", " '56414',\n", " '57996',\n", " '58324',\n", " '47304',\n", " '40442',\n", " '54363',\n", " '58065',\n", " '57915',\n", " '59397',\n", " '59231',\n", " '47263',\n", " '40681',\n", " '52498',\n", " '54248',\n", " '58807',\n", " '61643',\n", " '61345',\n", " '49215',\n", " '45017',\n", " '60271',\n", " '63308',\n", " '64434',\n", " '65034',\n", " '63411',\n", " '52074',\n", " '44930',\n", " '59664',\n", " '63723',\n", " '64677',\n", " '65537',\n", " '63886',\n", " '52493',\n", " '45005',\n", " '58168',\n", " '62822',\n", " '65595',\n", " '64367',\n", " '64725',\n", " '53460',\n", " '47032',\n", " '61176',\n", " '64492',\n", " '66202',\n", " '65484',\n", " '60017',\n", " '51210',\n", " '42591',\n", " '58363',\n", " '64571',\n", " '67528',\n", " '67830',\n", " '66780',\n", " '55595',\n", " '47955',\n", " '60787',\n", " '65141',\n", " '67820',\n", " '68553',\n", " '65107',\n", " '53312',\n", " '45682',\n", " '58881',\n", " '67266',\n", " '66833',\n", " '68595',\n", " '67413',\n", " '54950',\n", " '48186',\n", " '61314',\n", " '67632',\n", " '67557',\n", " '68536',\n", " '67894',\n", " '54418',\n", " '47705',\n", " '62554',\n", " '67607',\n", " '68101',\n", " '65830',\n", " '64959',\n", " '52175',\n", " '46478',\n", " '61800',\n", " '65997',\n", " '68118',\n", " '67697',\n", " '68250',\n", " '55221',\n", " '47996',\n", " '53755',\n", " '65464',\n", " '71136',\n", " '71914',\n", " '71322',\n", " '57166',\n", " '48976',\n", " '65821',\n", " '71788',\n", " '72208',\n", " '73052',\n", " '72817',\n", " '59268',\n", " '51056',\n", " '64637',\n", " '67597',\n", " '69024',\n", " '69009',\n", " '68905',\n", " '55642',\n", " '48702',\n", " '64843',\n", " '70198',\n", " '70197',\n", " '69094',\n", " '66632',\n", " '55847',\n", " '49432',\n", " '64314',\n", " '69788',\n", " '71134',\n", " '71365',\n", " '70106',\n", " '57502',\n", " '49073',\n", " '61183',\n", " '56449',\n", " '64892',\n", " '70548',\n", " '69417',\n", " '56710',\n", " '50147',\n", " '64937',\n", " '70737',\n", " '71497',\n", " '72427',\n", " '70917',\n", " '58393',\n", " '51111',\n", " '66355',\n", " '71693',\n", " '72893',\n", " '72808',\n", " '74200',\n", " '59685',\n", " '52305',\n", " '66364',\n", " '73062',\n", " '74795',\n", " '75800',\n", " '75853',\n", " '62267',\n", " '54592',\n", " '67801',\n", " '73255',\n", " '73930',\n", " '75266',\n", " '72407',\n", " '57649',\n", " '51194',\n", " '64368',\n", " '71442',\n", " '75856',\n", " '77196',\n", " '74225',\n", " '58286',\n", " '51841',\n", " '65227',\n", " '71711',\n", " '74082',\n", " '74873',\n", " '73393',\n", " '60338',\n", " '51327',\n", " '65262',\n", " '72273',\n", " '73795',\n", " '74598',\n", " '74453',\n", " '60720',\n", " '50739',\n", " '67147',\n", " '73729',\n", " '77411',\n", " '78266',\n", " '77747',\n", " '60038',\n", " '52525',\n", " '60269',\n", " '71274',\n", " '73656',\n", " '75535',\n", " '74420',\n", " '60447',\n", " '51822',\n", " '67867',\n", " '74317',\n", " '78284',\n", " '80249',\n", " '78927',\n", " '62380',\n", " '54043',\n", " '71809',\n", " '77816',\n", " '80657',\n", " '81430',\n", " '81158',\n", " '63272',\n", " '54435',\n", " '73013',\n", " '79052',\n", " ...],\n", " 124305,\n", " 190221,\n", " 520,\n", " 0,\n", " 1,\n", " 'Monaco']]" ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "row_data[0:10]" ] }, { "cell_type": "code", "execution_count": 88, "metadata": {}, "outputs": [], "source": [ "filtered_row_data = [\n", " r for i, r in enumerate(row_data) \n", " if i == 0 or (r[ix_link] not in seen_tracks and r[ix_last_streams] > 50000)\n", "]" ] }, { "cell_type": "code", "execution_count": 89, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "164" ] }, "execution_count": 89, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(filtered_row_data)" ] }, { "cell_type": "code", "execution_count": 95, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 95, "metadata": {}, "output_type": "execute_result" } ], "source": [ "sh = sheet.Sheet()\n", "spr = sh.client.open('Viral Adds')\n", "query_to_sheet.csv_to_sheet(row_data, spr, sheet_name='Virals May 3')" ] }, { "cell_type": "code", "execution_count": 56, "metadata": {}, "outputs": [], "source": [ "seen_tracks = '''https://open.spotify.com/track/3ZZ8CXYM90nGqzFUbYc53j\n", "https://open.spotify.com/track/16H89IXwu0I0DaV49Dfi7Q\n", "https://open.spotify.com/track/116bEFljiFEDt0zaHYcgWx\n", "https://open.spotify.com/track/031iL7mvKXZpFJAKkLMylo\n", "https://open.spotify.com/track/72jvp2nP4zstRmFdhyWgGu\n", "https://open.spotify.com/track/7HHYgMJYAtMkQn50wmXOIN\n", "https://open.spotify.com/track/72dHgPnaRtF1pgbpSZrgLX\n", "https://open.spotify.com/track/7xx7mUGAPcMd6gGqHzoec9\n", "https://open.spotify.com/track/0ou367q5bmco9pZNxq80iD\n", "https://open.spotify.com/track/51lu2hK6YLR0gHZHFAmdEA\n", "https://open.spotify.com/track/1ihZhbG3Ulj5IonDcUC0Yw\n", "https://open.spotify.com/track/4RBuYTb1Ebw9XPJ4JIUDJd\n", "https://open.spotify.com/track/66K9hoI6zNkxpTx88jFIvW\n", "https://open.spotify.com/track/14RLxOJGYs6BkLnvZYZisy\n", "https://open.spotify.com/track/1n1HgKJ9TFplBuhbdBbYZK\n", "https://open.spotify.com/track/0YgvHOlrhovTmiKL7QRfzr\n", "https://open.spotify.com/track/5uokjyBMNjaP6oHrtJJVys\n", "https://open.spotify.com/track/6rrnj1akJSUlXqd7Wyyn84\n", "https://open.spotify.com/track/27OVHIrX5WutMqV1N4hD2G\n", "https://open.spotify.com/track/25rk4fQl2sTESHcQaChLMr\n", "https://open.spotify.com/track/2twKCCzVkqTr7MKEbv3tcj\n", "https://open.spotify.com/track/17yOK7gmxYIhgmp6egnuVl\n", "https://open.spotify.com/track/39LJCSHy7nB1akjmhMQ7Y7\n", "https://open.spotify.com/track/2OU13apOMaGALVlSb2PzPi\n", "https://open.spotify.com/track/1UsMZEYf7DlkLqIdbpxJA7\n", "https://open.spotify.com/track/6DONTnamNDOJdO6DzCu71p\n", "https://open.spotify.com/track/0RZVAhyB8vhxQz6ITjiuyA\n", "https://open.spotify.com/track/6UwVBumIzgJg1GJwRbgYDy\n", "https://open.spotify.com/track/3JOXwHPhtdRU3kYKcf64Gj\n", "https://open.spotify.com/track/7MwwPyZJ7UKFROj2oVnH6R\n", "https://open.spotify.com/track/4TBtGrMgUYH7D5Tf5HLvyz\n", "https://open.spotify.com/track/75VNPADAFa4iNpjEBUYMhF\n", "https://open.spotify.com/track/4COR2ZPEyUn0lsbAouRWxA\n", "https://open.spotify.com/track/5soMJpcVhSrGrB4prvPL6P\n", "https://open.spotify.com/track/30ddpolNHwXlrS5XO8MiiO\n", "https://open.spotify.com/track/4unOsvr9C2NqI9aJXrxpCy\n", "https://open.spotify.com/track/0VPmIETYsw3JBnyh4iDjVv\n", "https://open.spotify.com/track/5vmRQ3zELMLUQPo2FLQ76x\n", "https://open.spotify.com/track/29nwG4y9NFmN76yfUfc01d\n", "https://open.spotify.com/track/5rAUZy2eDdegBxUVYxePK2\n", "https://open.spotify.com/track/4YTFAawmOFyRjJdT6H95oE\n", "https://open.spotify.com/track/0keCs8wD67bWkE4yrqZmir\n", "https://open.spotify.com/track/2lTtnKQgjbrBA1qnOFhBkP\n", "https://open.spotify.com/track/3vTQ939Tlk6CXYtQgMOFUR\n", "https://open.spotify.com/track/4yme4UrnlQT5txnkpSHKng\n", "https://open.spotify.com/track/0imfNymwLWKyhLBlBZYg53\n", "https://open.spotify.com/track/6Hhx7ksVnFxsLRssypYiEO\n", "https://open.spotify.com/track/7pegxVesMmE2qK0o58xoFG\n", "https://open.spotify.com/track/3b2STpVG1wHiZJ7u6hvmoR\n", "https://open.spotify.com/track/3WnqbZ1vm6FvlOjygpSe49\n", "https://open.spotify.com/track/5tzOL69W6lCp4gAomIXMnJ\n", "https://open.spotify.com/track/2MvxhedNhxhj32eVQJnmII\n", "https://open.spotify.com/track/0OOlmKW7Tn7FyeKDwNzEqN\n", "https://open.spotify.com/track/326OjKhvaCXNIaddeRhrZw\n", "https://open.spotify.com/track/5DlMR554Db6jiWPRWe95al\n", "https://open.spotify.com/track/5Gz9p2oDVHNHLoQOPHzaXm'''.splitlines()" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['001o475CIcdKHkvgKc9t8H',\n", " '001TRduQniM6dsJbQpMsbJ',\n", " '006ibfxHXj6ewIkihKcaS2',\n", " '007nYTXRhZJUZGH7ct5Y3v',\n", " '00CYRdkMnA0mwfy1VQPA7X',\n", " '00DSCauOVv9bIKe8bGWSTG',\n", " '00G1NTDAoU7rBpjG4KoYAM',\n", " '00Ja3YjvU4DYCHWt6cPs42',\n", " '00jACgDWIBdPM4eH8nORwz',\n", " '00LMt4rvi6xkahRJ8UVKDU']" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "mysql.query_single_column('select spyid from spotify_daily_streams limit 10')" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.7.1" } }, "nbformat": 4, "nbformat_minor": 2 }