Chart Rank Table

The ChartRank table contains 5601 row’s including headers TrackID, Week, Rank, PreviousRank, and WeekOnCharts. This table does not contain it’s own primary key, so the foreign key, TrackID, is acting as the Unique Identifier. The goal of this table is to track how long a song has spent on the charts, including when it specifically happened and what it peaked.

Track ID	Weekly	Ranks	Peak Rank	Previous Rank	Weeks on Charts
spotify:track:3Wrjm47oTz2sjIgck11l5e	1/20/2022	106	5	117	31
spotify:track:0fv2KH6hac06J86hBUTcSf	1/20/2022	107	16	123	7
spotify:track:60ynsPSSKe6O3sfwRnIBRf	1/20/2022	111	3	125	54
spotify:track:0lnpnsrVaW9elGgRxpDCgE	1/20/2022	112	22	121	30
spotify:track:003vvx7Niy0yvhvHt4a68B	1/20/2022	113	72	130	77
spotify:track:2wAJTrFhCnQyNSD3oUgTZO	1/20/2022	114	111	145	23
spotify:track:0sTlGEld0h8kIPZaKDYUf4	1/20/2022	115	75	135	14
spotify:track:5lAnYvAIkSDNXqfo7DyFUm	1/20/2022	117	4	136	30
spotify:track:2JPLbjOn0wPCngEot2STUS	1/20/2022	120	5	141	33
spotify:track:5Ts1DYOuouQLgzTaisxWYh	1/20/2022	121	120	120	3
spotify:track:3jfZ9M23l0L7RxzYMTgBTv	1/20/2022	122	77	146	18
spotify:track:7uLFOXgLrS90tEYPO1DGXy	1/20/2022	123	72	126	6
spotify:track:4MTmAFWHpvB9kPMSRgLFRp	1/20/2022	125	125		1
spotify:track:6zzdyvVWjGrQBraSvuqJPY	1/20/2022	126	23	23	2
spotify:track:5QO79kh1waicV47BqGRL3g	1/20/2022	127	2	133	58
spotify:track:0QwKxajohg1rAMMmv1AWe1	1/20/2022	128	6	118	6
spotify:track:21jGcNKet2qwijlDFuPiPb	1/20/2022	129	1	143	125
spotify:track:30bqVoKjX479ab90a8Pafp	1/20/2022	131	101	171	40
spotify:track:1BYZxKSf0aTxp8ZFoeyM3d	1/20/2022	132	93	165	13
spotify:track:7GX5flRQZVHRAGd6B4TmDO	1/20/2022	133	2	150	249
spotify:track:7m9OqQk4RVRkw9JJdeAw96	1/20/2022	134	3	153	229
spotify:track:2eAvDnpXP5W0cVtiI0PUxV	1/20/2022	137	137	179	2
spotify:track:61Emqg95O9zo1GNOcyxq4Y	1/20/2022	138	134	156	6
spotify:track:6tDDoYIxWvMLTdKpjFkc1B	1/20/2022	139	4	151	49
spotify:track:0wXuerDYiBnERgIpbb3JBR	1/20/2022	140	9	158	105
spotify:track:4xqrdfXkTW4T0RauPLv3WA	1/20/2022	142	9	159	81
spotify:track:3FAJ6O0NOHQV8Mc5Ri6ENp	1/20/2022	144	9	144	50
spotify:track:0eu4C55hL6x29mmeAjytzC	1/20/2022	145	31	138	18
spotify:track:6Hj9jySrnFppAI0sEMCZpJ	1/20/2022	147	3	149	153
spotify:track:3jjsRKEsF42ccXf8kWR3nu	1/20/2022	149	127	168	16
spotify:track:5JCoSi02qi3jJeHdZXMmR8	1/20/2022	150	5	147	35
spotify:track:2KnLkZ3z7PO3kgVGHGqDpD	1/20/2022	151	100	167	5
spotify:track:6foY66mWZN0pSRjZ408c00	1/20/2022	153	59	160	141
spotify:track:2GiJYvgVaD2HtM8GqD9EgQ	1/20/2022	156	44	174	75
spotify:track:7fBv7CLKzipRk6EC6TWHOB	1/20/2022	158	27	140	53
spotify:track:3cBsEDNhFI9E82vPj3kvi3	1/20/2022	159	3	152	52
spotify:track:2U5WueTLIK5WJLD7mvDODv	1/20/2022	160	1	164	80
spotify:track:0ofHAoxe9vBkTCp2UQIavz	1/20/2022	162	6	176	69
spotify:track:4EWCNWgDS8707fNSZ1oaA5	1/20/2022	163	137	183	16
spotify:track:6gBFPUFcJLzWGx4lenP6h2	1/20/2022	164	8	175	260
spotify:track:30QR0ndUdiiMQMA9g1PGCm	1/20/2022	165	37	162	42
spotify:track:2Q5q1q01KOdHt5fM00WUJ8	1/20/2022	166	166	197	2
spotify:track:0jA4h2SD50Oak4C3Vn905a	1/20/2022	173	160	189	8
spotify:track:4IowQDUOzUvNtp72HMDcKO	1/20/2022	174	162	193	5
spotify:track:63q3GlHZstxXzfb0zt7ZYY	1/20/2022	175	175		1
spotify:track:5UwA4sYMyaLALd3F2hUgjR	1/20/2022	176	52	52	2
spotify:track:0uRrG2jRR5tuifsYIJHEao	1/20/2022	177	13	178	30
spotify:track:6UelLqGlWMcVH1E5c4H7lY	1/20/2022	181	4	190	111
spotify:track:6a4GH1gljLL7VvmO9u5O92	1/20/2022	182	32	32	2
spotify:track:2ZXxRC6V6AXzMdbLQZMHSB	1/20/2022	183	65	192	16

1 - 50