home / fivethirtyeight

love-actually/love_actually_appearances

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

1,003 rows

View and edit SQL

Link rowid scenes bill_nighy keira_knightley andrew_lincoln hugh_grant colin_firth alan_rickman heike_makatsch laura_linney emma_thompson liam_neeson kris_marshall abdul_salis martin_freeman rowan_atkinson
1 Airport       1                    
2 Music recording 1.0                          
3 Firth leaving for work         1.0                  
4 Liam's wife was TAKEN                 1.0 1.0        
5 Food delivery ugh             1.0       1.0      
6 Movie set                         1.0  
7 The wedding   1.0 1.0   1.0     1.0            
8 Hugh meets Natalie       1                    
9 Firth learns his wife is a cheater         1.0                  
10 Wedding reception   1.0 1.0               1.0 1.0    
11 Movie set part 2                       1.0 1.0  
12 Funeral                 1.0 1.0        
13 Wedding party   1.0 1.0         1.0            
14 The Karl talk           1.0 1.0 1.0            
15 Love Is All Around single 1.0                          
16 Hugh's first political meeting       1                    
17 Movie set part 3                       1.0 1.0  
18 Colin's plan to leave                     1.0 1.0    
19 Christmas party preparations           1.0 1.0              
20 Getting over the dead wife talk                 1.0 1.0        
21 Liam talks with Sammo about his mom                   1.0        
22 Linney creeping on Karl               1.0            
23 Firth's new place in France         1.0                  
24 Hugh learns where Natalie lives       1                    
25 Liam talks with Sammo about girls                   1.0        
26 Bill Nighy vs. BLUE 1.0                          
27 Kiera wants the videotape   1.0 1.0                      
28 Secretary hits on Rickman           1.0 1.0 1.0            
29 Firth meets Aurelia         1.0                  
30 Hugh meets with the President       1                    
31 Emma is married to Rickman, and the PM's sis       1   1.0     1.0          
32 Hugh dancing       1                    
33 Firth oogles Aurelia         1.0                  
34 Kiera learns the truth 1.0 1.0 1.0                      
35 Hugh fires Natalie       1                    
36 Liam and Sam watch Titanic                   1.0        
37 Hugh gets tea from someone new       1                    
38 Firth drops off Aurelia         1.0                  
39 Sammo wants to be a musician 1.0                 1.0        
40 Christmas party     1.0     1.0 1.0 1.0 1.0          
41 Hugh Grant watches Nighy 1.0     1                    
42 Linney and Karl go back to her place               1.0            
43 Emma warns Rickman           1.0 1.0   1.0          
44 At the asylum               1.0            
45 Emma can't sleep           1.0     1.0          
46 Christmas requests           1.0 1.0              
47 Christmas shopping           1.0     1.0         1.0
48 Colin's really leaving                     1.0 1.0    
49 Movie set part 4                         1.0  
50 Sammo loves the drums                   1.0        
51 Emma gets excited about her present           1.0     1.0          
52 Firth's learning Portuguese         1.0                  
53 Colin gets on the plane                     1.0 1.0    
54 Colin in Wisconsin                     1.0      
55 Emma is disappointed by the present           1.0 1.0   1.0          
56 Liam overshares with Sam                   1.0        
57 Nighy wins the single competition                            
58 Sex standins say goodnight                         1.0  
59 Firth does an xmas driveby         1.0                  
60 Laura cries without Rodrigo               1.0            
61 Sammo's still practicing                   1.0        
62 Laura at Christmas with her brother               1.0            
63 Best man professes his love   1.0 1.0                      
64 Nighy professes his love 1.0                          
65 Hugh hunts down Natalie       1     1.0              
66 Firth's at the airport         1.0                  
67 The Christmas play       1   1.0     1.0 1.0     1.0  
68 Firth finds Aurelia's family         1.0                  
69 Sammo proposes to Johana 1.0                 1.0       1.0
70 Firth proposes to Aurelia         1.0                  
71 At the airport again 1.0 1.0 1.0 1 1.0 1.0   1.0 1.0 1.0 1.0 1.0 1.0  
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                              

Next page

Advanced export

JSON shape: default, array

CSV options:

CREATE TABLE "love-actually/love_actually_appearances" (
"scenes" TEXT,
  "bill_nighy" REAL,
  "keira_knightley" REAL,
  "andrew_lincoln" REAL,
  "hugh_grant" INTEGER,
  "colin_firth" REAL,
  "alan_rickman" REAL,
  "heike_makatsch" REAL,
  "laura_linney" REAL,
  "emma_thompson" REAL,
  "liam_neeson" REAL,
  "kris_marshall" REAL,
  "abdul_salis" REAL,
  "martin_freeman" REAL,
  "rowan_atkinson" REAL
)
Powered by Datasette · Query took 832.211ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub