Skip to content

Instantly share code, notes, and snippets.

@kartikeyaSh
Last active July 4, 2018 10:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kartikeyaSh/1c2a2c23787d5bd41c56cc9b56b765db to your computer and use it in GitHub Desktop.
Save kartikeyaSh/1c2a2c23787d5bd41c56cc9b56b765db to your computer and use it in GitHub Desktop.

recording_json

id data data_sha256 meta_sha256
1 {"artist":"Jay\u2010Z & Beyonc\u00e9","title":"'03 Bonnie and Clyde"} 427dde900a7fa69d596dd6beaa0ac689460ace3b83adc45f592f1cddcaff9cf0 427dde900a7fa69d596dd6beaa0ac689460ace3b83adc45f592f1cddcaff9cf0
2 {"artist":"Big Sean feat. The\u2010Dream","title":"Live This Life"} c0d970eebc5b45674e7f5822dc66f8259721add01a4573eb21051a16bf5105d4 c0d970eebc5b45674e7f5822dc66f8259721add01a4573eb21051a16bf5105d4
3 {"artist":"Jay\u2010Z & Beyonc\u00e9","artist_mbids":["f82bcf78-5b69-4622-a5ef-73800768d9ac","859d0860-d480-4efd-970c-c05d5f1776b8"],"recording_mbid":"5465ca86-3881-4349-81b2-6efbd3a59451","release":"The Blueprint\u00b2: The Gift & The Curse","release_mbid":"2c5e4198-24cf-3c95-a16e-83be8e877dfa","title":"'03 Bonnie and Clyde"} c5cbe54a757645e7ebfa0b81f3bc5927a7199891d25f10f6f3ed125f52428076 427dde900a7fa69d596dd6beaa0ac689460ace3b83adc45f592f1cddcaff9cf0
4 {"artist":"Jay\u2010Z & Beyonc\u00e9","artist_mbids":["f82bcf78-5b69-4622-a5ef-73800768d9ac","859d0860-d480-4efd-970c-c05d5f1776b8"],"recording_mbid":"5465ca86-3881-4349-81b2-6efbd3a59451","release":"The Blueprint\u00b2: The Gift and The Curse","release_mbid":"2c5e4198-24cf-3c95-a16e-83be8e877dfa","title":"'03 Bonnie and Clyde"} b432769e14972a349bf5f6add7dc7e92f309f244a9d7a7cb42a0176b9d357291 427dde900a7fa69d596dd6beaa0ac689460ace3b83adc45f592f1cddcaff9cf0
5 {"artist":"Jay\u2010Z & Beyonc\u00e9","artist_mbids":["f82bcf78-5b69-4622-a5ef-73800768d9ac","859d0860-d480-4efd-970c-c05d5f1776b8"],"recording_mbid":"5465ca86-3881-4349-81b2-6efbd3a59451","release":"The Blueprint\u00b2: The Gift and The Curse","release_mbid":"2c5e4198-24cf-3c95-a16e-83be8e877dfa","title":"'03 Bonnie & Clyde"} b5f572e53bf110ac456781edb24d2f1cf688aae1a11496bd11004545a71a0e99 93840a6e5c3b29f6192625687e40a377abb7f136ef5bc0a14705259d07c4acb4
6 {"artist":"Jay\u2010Z & Beyonc\u00e9","artist_mbids":["f82bcf78-5b69-4622-a5ef-73800768d9ac","859d0860-d480-4efd-970c-c05d5f1776b8"],"recording_mbid":"5465ca86-3881-4349-81b2-6efbd3a59451","release":"The Blueprint\u00b2: The Gift & The Curse","release_mbid":"801678aa-5d30-4342-8227-e9618f164cca","title":"'03 Bonnie & Clyde"} b37ab954782f0448199986e08f8b2b15d872e9192b8436873d103b4af52cea32 93840a6e5c3b29f6192625687e40a377abb7f136ef5bc0a14705259d07c4acb4
7 {"artist":"Jay\u2010Z & Beyonc\u00e9","artist_mbids":["f82bcf78-5b69-4622-a5ef-73800768d9ac","859d0860-d480-4efd-970c-c05d5f1776b8"],"recording_mbid":"5465ca86-3881-4349-81b2-6efbd3a59451","release":"The Blueprint\u00b2: The Gift and The Curse","release_mbid":"801678aa-5d30-4342-8227-e9618f164cca","title":"'03 Bonnie & Clyde"} 2b3d2010de5db38c4d16daef6bd12ed8e4d130e2e8e81f726646e5e395998ce4 93840a6e5c3b29f6192625687e40a377abb7f136ef5bc0a14705259d07c4acb4
8 {"artist":"Jay\u2010Z & Beyonc\u00e9","artist_mbids":["f82bcf78-5b69-4622-a5ef-73800768d9ac","859d0860-d480-4efd-970c-c05d5f1776b8"],"recording_mbid":"5465ca86-3881-4349-81b2-6efbd3a59451","release":"Blueprint 2.1","release_mbid":"7111c8bc-8549-4abc-8ab9-db13f65b4a55","title":"'03 Bonnie & Clyde"} 61c3f3288656169684422055a1596915d63474a12c7feb0af467c8cc48a0390a 93840a6e5c3b29f6192625687e40a377abb7f136ef5bc0a14705259d07c4acb4
9 {"artist":"Lil Kim","artist_mbids":["bc1b5c95-e6d6-46b5-957a-5e8908b02c1e"],"recording_mbid":"6ba092ae-aaf7-4154-b987-9eb9d05f8616","release":"The Notorious KIM","release_mbid":"e8c8bbf8-15c1-477f-af5b-2c1479af037e","title":"Don't Mess With Me"} ca96ee51c516107f0d3279eeaa785aaba6558b1d2e9ffc1badb68e70bc69e634 2d1951271eeb7dda79eedfbc34808132fc1350544287812109d1f80b7c8e135f
10 {"artist":"Lil Kim","artist_mbids":["bc1b5c95-e6d6-46b5-957a-5e8908b02c1e"],"recording_mbid":"6ba092ae-aaf7-4154-b987-9eb9d05f8616","release":"The Notorious KIM","release_mbid":"09701309-2f7b-4537-a066-daa1c79b3f06","title":"Don't Mess With Me"} 982936651b7b55e390768cc87876cdffa7ab158e20e26a5ce4775c9f2094a3e8 2d1951271eeb7dda79eedfbc34808132fc1350544287812109d1f80b7c8e135f
11 {"artist":"JAY-Z","artist_mbids":["f82bcf78-5b69-4622-a5ef-73800768d9ac"],"recording_mbid":"cad174ad-d683-4858-a205-7bdc4175fff7","release":"The Blueprint Collector's Edition","release_mbid":"d75e103c-5ef4-4146-ae81-e27d19dc7fc4","title":"Some People Hate"} 58fb5a90f7483a5ca30495318c453a725c63f451aa115632058e9199a17dd74d f187919a3b0c9f618a37debf3af93e65b4ed6c8b50c33a4f28f2789719dc4072
12 {"artist":"JAY-Z","artist_mbids":["f82bcf78-5b69-4622-a5ef-73800768d9ac"],"recording_mbid":"cad174ad-d683-4858-a205-7bdc4175fff7","release":"The Blueprint\u00b2: The Gift & The Curse","release_mbid":"801678aa-5d30-4342-8227-e9618f164cca","title":"Some People Hate"} 518e3040effd4845a669cc44e7243253b6e4899d5b5476994dcffcde6ef597ce f187919a3b0c9f618a37debf3af93e65b4ed6c8b50c33a4f28f2789719dc4072
13 {"artist":"Syreeta","artist_mbids":["5cfeec75-f6e2-439c-946d-5317334cdc6c"],"recording_mbid":"9ed38583-437f-4186-8183-9c31ffa2c116","release":"Syreeta","release_mbid":"5f7853be-1f7a-4850-b0b8-2333d6b0318f","title":"She's Leaving Home"} 26befe317189758865261180e6b092d70092e14e132924dfb0097f466f60cee9 f346d81ae45ec9688323dacd90fa060db15f8fa45c714e32bd6498a5832d1226
14 {"artist":"Jay\u2010Z and Beyonc\u00e9","artist_mbids":["f82bcf78-5b69-4622-a5ef-73800768d9ac","859d0860-d480-4efd-970c-c05d5f1776b8"],"recording_mbid":"5465ca86-3881-4349-81b2-6efbd3a59451","release":"The Blueprint\u00b2: The Gift and The Curse","release_mbid":"2c5e4198-24cf-3c95-a16e-83be8e877dfa","title":"'03 Bonnie and Clyde"} b434b52fbd1177ff437227235ad9c56e3b47ffff928fefeb41ea50621c4dbcd3 fa509a904c77a49d1fc1f85e05bf1ad2dedd364b477fbf228929917acd983fe8
15 {"artist":"Jay\u2010Z and Beyonc\u00e9","title":"'03 Bonnie and Clyde"} fa509a904c77a49d1fc1f85e05bf1ad2dedd364b477fbf228929917acd983fe8 fa509a904c77a49d1fc1f85e05bf1ad2dedd364b477fbf228929917acd983fe8
16 {"artist":"Donal Leace","artist_mbids":["7a5e3cfc-32a4-450a-8a6d-142709da279c"],"recording_mbid":"45ff8510-2d1a-41de-8866-d7bd9efd3ce6","release":"Donal Leace","release_mbid":"2b82a22b-0492-44be-bfd8-d1cee7d259fb","title":"Today Won't Come Again"} eec953d9a06b2c794b0689d3bc550536ed466159a0a85c2eb2888067101bbb6d 75fc6160de0d5f776d5dc5cc856fc11d3e9a2e9e88a390b0d7f99efcd9f6c55b

release

gid title submitted
d8f2693c-0c68-4c3e-b713-fc8d8b5e2243 The Blueprint²: The Gift & The Curse 2018-07-02 15:38:07.570417+00
88e26ab6-63ae-49e7-b03b-8cdf38042326 The Blueprint²: The Gift and The Curse 2018-07-02 15:38:07.656918+00
008a080b-5fb9-4895-b2cd-425f297c175c Blueprint 2.1 2018-07-02 15:38:07.93467+00
7db491f0-39d0-4ac4-a288-1c5942866e14 The Notorious KIM 2018-07-02 15:38:07.94559+00
eabfb461-1af1-4a62-8e9c-5ebf1ed7c3fc The Blueprint Collector's Edition 2018-07-02 15:38:08.001852+00
cd10dd74-1dcf-4bcc-abfe-99f6d04d4815 Syreeta 2018-07-02 15:38:08.281571+00
28e24452-a385-4dc2-b418-f3dd687080b3 Donal Leace 2018-07-02 15:38:08.334694+00

release_cluster

cluster_id release_gid updated
008a080b-5fb9-4895-b2cd-425f297c175c 008a080b-5fb9-4895-b2cd-425f297c175c 2018-07-02 15:38:47.69132+00
28e24452-a385-4dc2-b418-f3dd687080b3 28e24452-a385-4dc2-b418-f3dd687080b3 2018-07-02 15:38:47.713762+00
cd10dd74-1dcf-4bcc-abfe-99f6d04d4815 cd10dd74-1dcf-4bcc-abfe-99f6d04d4815 2018-07-02 15:38:47.735218+00
7db491f0-39d0-4ac4-a288-1c5942866e14 7db491f0-39d0-4ac4-a288-1c5942866e14 2018-07-02 15:38:47.758047+00
eabfb461-1af1-4a62-8e9c-5ebf1ed7c3fc eabfb461-1af1-4a62-8e9c-5ebf1ed7c3fc 2018-07-02 15:38:47.779764+00
88e26ab6-63ae-49e7-b03b-8cdf38042326 88e26ab6-63ae-49e7-b03b-8cdf38042326 2018-07-02 15:38:47.802265+00
88e26ab6-63ae-49e7-b03b-8cdf38042326 d8f2693c-0c68-4c3e-b713-fc8d8b5e2243 2018-07-02 15:38:47.802265+00

release_redirect

release_cluster_id release_mbid
008a080b-5fb9-4895-b2cd-425f297c175c 7111c8bc-8549-4abc-8ab9-db13f65b4a55
28e24452-a385-4dc2-b418-f3dd687080b3 2b82a22b-0492-44be-bfd8-d1cee7d259fb
cd10dd74-1dcf-4bcc-abfe-99f6d04d4815 5f7853be-1f7a-4850-b0b8-2333d6b0318f
7db491f0-39d0-4ac4-a288-1c5942866e14 09701309-2f7b-4537-a066-daa1c79b3f06
eabfb461-1af1-4a62-8e9c-5ebf1ed7c3fc d75e103c-5ef4-4146-ae81-e27d19dc7fc4
88e26ab6-63ae-49e7-b03b-8cdf38042326 2c5e4198-24cf-3c95-a16e-83be8e877dfa
7db491f0-39d0-4ac4-a288-1c5942866e14 e8c8bbf8-15c1-477f-af5b-2c1479af037e
88e26ab6-63ae-49e7-b03b-8cdf38042326 801678aa-5d30-4342-8227-e9618f164cca

Verbose output

Creating release clusters...
================================================================================

Creating clusters without considering anomalies...
--------------------------------------------------------------------------------
Cluster MBIDs:
	7111c8bc-8549-4abc-8ab9-db13f65b4a55
Recordings metadata:
{
    "artist": "Jay\u2010Z & Beyonc\u00e9",
    "artist_mbids": [
        "f82bcf78-5b69-4622-a5ef-73800768d9ac",
        "859d0860-d480-4efd-970c-c05d5f1776b8"
    ],
    "recording_mbid": "5465ca86-3881-4349-81b2-6efbd3a59451",
    "release": "Blueprint 2.1",
    "release_mbid": "7111c8bc-8549-4abc-8ab9-db13f65b4a55",
    "title": "'03 Bonnie & Clyde"
}

Cluster ID:
	008a080b-5fb9-4895-b2cd-425f297c175c
Cluster gids and title:
	008a080b-5fb9-4895-b2cd-425f297c175c: Blueprint 2.1
--------------------------------------------------------------------------------
Cluster MBIDs:
	2b82a22b-0492-44be-bfd8-d1cee7d259fb
Recordings metadata:
{
    "artist": "Donal Leace",
    "artist_mbids": [
        "7a5e3cfc-32a4-450a-8a6d-142709da279c"
    ],
    "recording_mbid": "45ff8510-2d1a-41de-8866-d7bd9efd3ce6",
    "release": "Donal Leace",
    "release_mbid": "2b82a22b-0492-44be-bfd8-d1cee7d259fb",
    "title": "Today Won't Come Again"
}

Cluster ID:
	28e24452-a385-4dc2-b418-f3dd687080b3
Cluster gids and title:
	28e24452-a385-4dc2-b418-f3dd687080b3: Donal Leace
--------------------------------------------------------------------------------
Cluster MBIDs:
	5f7853be-1f7a-4850-b0b8-2333d6b0318f
Recordings metadata:
{
    "artist": "Syreeta",
    "artist_mbids": [
        "5cfeec75-f6e2-439c-946d-5317334cdc6c"
    ],
    "recording_mbid": "9ed38583-437f-4186-8183-9c31ffa2c116",
    "release": "Syreeta",
    "release_mbid": "5f7853be-1f7a-4850-b0b8-2333d6b0318f",
    "title": "She's Leaving Home"
}

Cluster ID:
	cd10dd74-1dcf-4bcc-abfe-99f6d04d4815
Cluster gids and title:
	cd10dd74-1dcf-4bcc-abfe-99f6d04d4815: Syreeta
--------------------------------------------------------------------------------
Cluster MBIDs:
	09701309-2f7b-4537-a066-daa1c79b3f06
Recordings metadata:
{
    "artist": "Lil Kim",
    "artist_mbids": [
        "bc1b5c95-e6d6-46b5-957a-5e8908b02c1e"
    ],
    "recording_mbid": "6ba092ae-aaf7-4154-b987-9eb9d05f8616",
    "release": "The Notorious KIM",
    "release_mbid": "09701309-2f7b-4537-a066-daa1c79b3f06",
    "title": "Don't Mess With Me"
}

Cluster ID:
	7db491f0-39d0-4ac4-a288-1c5942866e14
Cluster gids and title:
	7db491f0-39d0-4ac4-a288-1c5942866e14: The Notorious KIM
--------------------------------------------------------------------------------
Cluster MBIDs:
	e8c8bbf8-15c1-477f-af5b-2c1479af037e
Recordings metadata:
{
    "artist": "Lil Kim",
    "artist_mbids": [
        "bc1b5c95-e6d6-46b5-957a-5e8908b02c1e"
    ],
    "recording_mbid": "6ba092ae-aaf7-4154-b987-9eb9d05f8616",
    "release": "The Notorious KIM",
    "release_mbid": "e8c8bbf8-15c1-477f-af5b-2c1479af037e",
    "title": "Don't Mess With Me"
}

--------------------------------------------------------------------------------
Cluster MBIDs:
	d75e103c-5ef4-4146-ae81-e27d19dc7fc4
Recordings metadata:
{
    "artist": "JAY-Z",
    "artist_mbids": [
        "f82bcf78-5b69-4622-a5ef-73800768d9ac"
    ],
    "recording_mbid": "cad174ad-d683-4858-a205-7bdc4175fff7",
    "release": "The Blueprint Collector's Edition",
    "release_mbid": "d75e103c-5ef4-4146-ae81-e27d19dc7fc4",
    "title": "Some People Hate"
}

Cluster ID:
	eabfb461-1af1-4a62-8e9c-5ebf1ed7c3fc
Cluster gids and title:
	eabfb461-1af1-4a62-8e9c-5ebf1ed7c3fc: The Blueprint Collector's Edition
--------------------------------------------------------------------------------
Cluster MBIDs:
	2c5e4198-24cf-3c95-a16e-83be8e877dfa
Recordings metadata:
{
    "artist": "Jay\u2010Z & Beyonc\u00e9",
    "artist_mbids": [
        "f82bcf78-5b69-4622-a5ef-73800768d9ac",
        "859d0860-d480-4efd-970c-c05d5f1776b8"
    ],
    "recording_mbid": "5465ca86-3881-4349-81b2-6efbd3a59451",
    "release": "The Blueprint\u00b2: The Gift & The Curse",
    "release_mbid": "2c5e4198-24cf-3c95-a16e-83be8e877dfa",
    "title": "'03 Bonnie and Clyde"
}
{
    "artist": "Jay\u2010Z & Beyonc\u00e9",
    "artist_mbids": [
        "f82bcf78-5b69-4622-a5ef-73800768d9ac",
        "859d0860-d480-4efd-970c-c05d5f1776b8"
    ],
    "recording_mbid": "5465ca86-3881-4349-81b2-6efbd3a59451",
    "release": "The Blueprint\u00b2: The Gift and The Curse",
    "release_mbid": "2c5e4198-24cf-3c95-a16e-83be8e877dfa",
    "title": "'03 Bonnie and Clyde"
}
{
    "artist": "Jay\u2010Z & Beyonc\u00e9",
    "artist_mbids": [
        "f82bcf78-5b69-4622-a5ef-73800768d9ac",
        "859d0860-d480-4efd-970c-c05d5f1776b8"
    ],
    "recording_mbid": "5465ca86-3881-4349-81b2-6efbd3a59451",
    "release": "The Blueprint\u00b2: The Gift and The Curse",
    "release_mbid": "2c5e4198-24cf-3c95-a16e-83be8e877dfa",
    "title": "'03 Bonnie & Clyde"
}
{
    "artist": "Jay\u2010Z and Beyonc\u00e9",
    "artist_mbids": [
        "f82bcf78-5b69-4622-a5ef-73800768d9ac",
        "859d0860-d480-4efd-970c-c05d5f1776b8"
    ],
    "recording_mbid": "5465ca86-3881-4349-81b2-6efbd3a59451",
    "release": "The Blueprint\u00b2: The Gift and The Curse",
    "release_mbid": "2c5e4198-24cf-3c95-a16e-83be8e877dfa",
    "title": "'03 Bonnie and Clyde"
}

Cluster ID:
	88e26ab6-63ae-49e7-b03b-8cdf38042326
Cluster gids and title:
	88e26ab6-63ae-49e7-b03b-8cdf38042326: The Blueprint²: The Gift and The Curse
	d8f2693c-0c68-4c3e-b713-fc8d8b5e2243: The Blueprint²: The Gift & The Curse
--------------------------------------------------------------------------------
Cluster MBIDs:
	801678aa-5d30-4342-8227-e9618f164cca
Recordings metadata:
{
    "artist": "Jay\u2010Z & Beyonc\u00e9",
    "artist_mbids": [
        "f82bcf78-5b69-4622-a5ef-73800768d9ac",
        "859d0860-d480-4efd-970c-c05d5f1776b8"
    ],
    "recording_mbid": "5465ca86-3881-4349-81b2-6efbd3a59451",
    "release": "The Blueprint\u00b2: The Gift & The Curse",
    "release_mbid": "801678aa-5d30-4342-8227-e9618f164cca",
    "title": "'03 Bonnie & Clyde"
}
{
    "artist": "Jay\u2010Z & Beyonc\u00e9",
    "artist_mbids": [
        "f82bcf78-5b69-4622-a5ef-73800768d9ac",
        "859d0860-d480-4efd-970c-c05d5f1776b8"
    ],
    "recording_mbid": "5465ca86-3881-4349-81b2-6efbd3a59451",
    "release": "The Blueprint\u00b2: The Gift and The Curse",
    "release_mbid": "801678aa-5d30-4342-8227-e9618f164cca",
    "title": "'03 Bonnie & Clyde"
}
{
    "artist": "JAY-Z",
    "artist_mbids": [
        "f82bcf78-5b69-4622-a5ef-73800768d9ac"
    ],
    "recording_mbid": "cad174ad-d683-4858-a205-7bdc4175fff7",
    "release": "The Blueprint\u00b2: The Gift & The Curse",
    "release_mbid": "801678aa-5d30-4342-8227-e9618f164cca",
    "title": "Some People Hate"
}


Clusters modified: 6.
Clusters added to redirect table: 6.

Creating clusters for anomalies...
--------------------------------------------------------------------------------
Cluster MBIDs:
	e8c8bbf8-15c1-477f-af5b-2c1479af037e
Recordings metadata:
{
    "artist": "Lil Kim",
    "artist_mbids": [
        "bc1b5c95-e6d6-46b5-957a-5e8908b02c1e"
    ],
    "recording_mbid": "6ba092ae-aaf7-4154-b987-9eb9d05f8616",
    "release": "The Notorious KIM",
    "release_mbid": "e8c8bbf8-15c1-477f-af5b-2c1479af037e",
    "title": "Don't Mess With Me"
}

Cluster IDs and title:
	7db491f0-39d0-4ac4-a288-1c5942866e14: The Notorious KIM
--------------------------------------------------------------------------------
Cluster MBIDs:
	801678aa-5d30-4342-8227-e9618f164cca
Recordings metadata:
{
    "artist": "Jay\u2010Z & Beyonc\u00e9",
    "artist_mbids": [
        "f82bcf78-5b69-4622-a5ef-73800768d9ac",
        "859d0860-d480-4efd-970c-c05d5f1776b8"
    ],
    "recording_mbid": "5465ca86-3881-4349-81b2-6efbd3a59451",
    "release": "The Blueprint\u00b2: The Gift & The Curse",
    "release_mbid": "801678aa-5d30-4342-8227-e9618f164cca",
    "title": "'03 Bonnie & Clyde"
}
{
    "artist": "Jay\u2010Z & Beyonc\u00e9",
    "artist_mbids": [
        "f82bcf78-5b69-4622-a5ef-73800768d9ac",
        "859d0860-d480-4efd-970c-c05d5f1776b8"
    ],
    "recording_mbid": "5465ca86-3881-4349-81b2-6efbd3a59451",
    "release": "The Blueprint\u00b2: The Gift and The Curse",
    "release_mbid": "801678aa-5d30-4342-8227-e9618f164cca",
    "title": "'03 Bonnie & Clyde"
}
{
    "artist": "JAY-Z",
    "artist_mbids": [
        "f82bcf78-5b69-4622-a5ef-73800768d9ac"
    ],
    "recording_mbid": "cad174ad-d683-4858-a205-7bdc4175fff7",
    "release": "The Blueprint\u00b2: The Gift & The Curse",
    "release_mbid": "801678aa-5d30-4342-8227-e9618f164cca",
    "title": "Some People Hate"
}

Cluster IDs and title:
	88e26ab6-63ae-49e7-b03b-8cdf38042326: The Blueprint²: The Gift and The Curse

Clusters added to redirect table: 2.
================================================================================
Clusters modified: 6.
Clusters add to redirect table: 8.
Done!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment