fivethirtyeight: love-actually/love_actually

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

1,003 rows

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "love-actually/love_actually_appearances" (
"scenes" TEXT,
  "bill_nighy" TEXT,
  "keira_knightley" TEXT,
  "andrew_lincoln" TEXT,
  "hugh_grant" INTEGER,
  "colin_firth" TEXT,
  "alan_rickman" TEXT,
  "heike_makatsch" TEXT,
  "laura_linney" TEXT,
  "emma_thompson" TEXT,
  "liam_neeson" TEXT,
  "kris_marshall" TEXT,
  "abdul_salis" TEXT,
  "martin_freeman" TEXT,
  "rowan_atkinson" TEXT
);