ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Hello!
2
3
I created this spreadsheet over a few months between December 2022 into 2023. I'll be keeping it updated as Taylor releases new music. Some things to keep in mind:
4
5
- I grouped similar types of words and motifs together. Some lines appear in several places for this reason.
- I didn't consider what we think we know of Taylor's personal life to pull this together.
- I tried to take the lyrics literally to collect the data. As a result, some data points contextually won't make sense since they're a detail instead of the motif/metaphor for the particular work.
- Lines that are similar, but had a different preceding or succeeding line "counted" several times. Choruses counted once.
- I omitted the non-album songs. Maybe one day I'll do it, but I'm not holding my breath.
6
7
I'm only one person, so this list isn't perfect or even complete(!), but I tried to be as comprehensive as possible. If there's anything I missed or is duplicated, please tell me so I can correct it. Obviously, this took a lot of work, so please give me credit if you use it for anything. :)
8
Blog: https://maxxr.squarespace.com/blog/tag/Taylor%20Swift
9
10
22 April 2024: Added individual links to available charts in the Table of contents
11
7 September 2023: Created Tableau data viz for all this data - https://public.tableau.com/app/profile/maxx.ramos/viz/TaylorSwiftlyrictrendsovertime/Dashboard43
12
13
Changelog:
14
14 May 2024: Updated and cleaned up most of the data and Tableau charts
15
13 May 2024: Added Robin, The Manuscript
16
9 May 2024: Added The Bolter
17
7 May2024: Added Cassandra
18
2 May 2024: Added thanK you aIMee, I Look In People's Windows, The Prophecy
19
1 May 2024: Added I Hate It Here
20
30 April 2024: Added imgonnagetyouback, The Albatross, Chloe or Sam or Sophia or Marcus, How Did It End?, So High School
21
28 April 2024: Added Clara Bow, The Black Dog
22
25 April 2024: Added I Can Fix Him (No Really I Can), loml, The Smallest Man Who Ever Lived, The Alchemy
23
23 April 2024: Added But Daddy I Love Him, Fresh Out The Slammer, Florida!!!, Guilty As Sin?, Who's Afraid Of Little Old Me?
24
22 April 2024: Updated table of contents with links to Tableau charts of usage over time
25
22 April 2024: Added My Boy Only Breaks His Favorite Toys, Down Bad, So Long London
26
22 April 2024: Changed "Highs and heights" to "Highs and lows", updated categories to High, Low, Transitions; added subcategories
27
21 April 2024: Updated name drops to count the unique instances of names mentioned per each era
28
21 April 2024: Added Fortnight and The Tortured Poets Department from The Tortured Poets Department
29
21 February 2024: Added missing mention of "hall/hallway" in exile
30
21 February 2024: Split Wounds and Weapons into separate sheets
31
9 January 2024: Updated Apparel and appearances and Fairytales and Kingdoms to include more crown mentions
32
9 January 2024: Updated Body parts to include more feet mentions
33
27 Nov 2023: Updated topics in C-F with the same data as the Tableau data viz. Topics are all updated with info from 1989 From the Vault tracks. Please let me know if I'm missing anything.
34
26 Nov 2023: Updated topics in G-Z with the same data as the Tableau data viz
35
25 Nov 2023: Updated topics in A-B with the same data as the Tableau data viz
36
?? October 2023: Removed "Fate and omens" and merged it with "Accidents and planning"
37
21 September 2023: Added Total count to each item in the table of contents (excludes Related lines)
38
7 September 2023: Normalizing data to create graphs. :)
39
10 August 2023: Experimented with Pivot Table to display data, appended numbers to Album era for tables. (Evermore is listed at 2021 for this experimentation)
40
27 July 2023: Added Foolish One to all relevant pages
41
26 July 2023: Added Castles Crumbling to all relevant pages
42
26 July 2023: Added I Can See You to all relevant pages
43
26 July 2023: Added When Emma Falls in love to all relevant pages
44
26 July 2023: Added Electric Touch to all the relevant pages
45
26 July 2023: Added trying, headlights and stars alight to Paired lines
46
25 July 2023: Designated (From the Vault) songs to see if their additions changed theme occurence across eras.
47
6 July 2023: I turned on commenting so you can leave comments if I missed anything!
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100