Microsoft Access query Exercise 1

See attached database examples and their related questions.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Queries

Assignment 1

Open the database Films.accdb.

Create a query showing all of the films which took more than $400,000,000 in 1998, and save this as HighGrossing1998.  Your datasheet should look like this:

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

For the BoxOffice criteria, type in >400000000

Create another query showing all of the films released in the 1960s, and save this as SixtiesFilms.

Another way of saying this is to ask for all the films released on or after 1960 and before or during 1969.

Your answer should look like this:

The effects of inflation mean that most films are recent ones

Close down both queries and your database.

Assignment 2

Open the database Films.accdb.

Create a query which shows the films in the following order:

· With the most recent films first; and

· Where there are two or more films for the same year, sort these into alphabetical order.

Your final answer should look like this:

The 2006 films, for example, are subsorted alphabetically

Save this query as FilmsOrdered, then close it down.

Assignment 3

Open the database Movies.accdb.

Create a query to show for each director’s year of birth:

· The average profit (box office minus budget) for films; and

· The number of films released.

If you sort the rows by average profit (with the highest number first) you should get:

1961 was a good year …

Save this as Wonder who was born in 1961, and close it down.

A challenge: how would you create a query to list out the names of the directors born in the highest-grossing year?

Assignment 4

Open the database Pets Database.accdb.

Create the following parameter queries:

· List either boy pets or girl pets, saving as parameterPetsOfGender;

· List pets name and type who like a particular food, saving as parameterPetsOfFood;

· List pets of a particular type, saving as parameterPetsOfType.

: Episode I – The Phantom Menace

2

2002

2003

2001

2005

00

2002

Star Wars

2004

2004

2006

2005

Reloaded

2003

1994

1999

2003

2002

2004

: The Meltdown

2006

1997

2004

2005

1997

2005

II

2000

533800000

2001

2004

1990

1996

2

1999

2004

1998

2005

1990

2003

The Matrix 1999

2000

: The Last Stand

2006

Shrek 2001

2006

Mission: Impossible 1996

2001

2001

2003

1999

2004

2005

2002

2002

1990

2000

2003 424000000

1993

Returns

2001

2003

The Mummy 1999

1989

1992

2002

2005

2003

2006

1991 390500000

Returns

2006

1991

Ice Age 2002 378300000

1998

2000

1993

2005

1994

1999

2001

1998

2001

1994

Toy Story 1995

2002

1998

2002

1992

2005

1999 352000000

1995

2004

1995

1988

2001 349200000

1998

2000

1995

1997

2004

2000

2004

2002

1999

1995

1995

1989

1996

2006

2005

2

2001

1986

2000

1996

1993

1994

1992

1984

1997

1997

2001

1999

1996

1999

2002

1997

2004

1996

1998

1991

1985

1985 300400000

1987

1977 300000000

2005

1999

1989

2000

X-Men 2000

1984

1998

Superman 1978

1998

2002

1988

2006

1997

1977

1998

1994

1992

2005

1995

1992

2

2001

2000

2004

2004

1996

1991

2004

1996

1999

2002

2002

1993

1995

1997

2002

1993

2003

1990

2000

2001

2000

1997

2000

2004

1995

1993

2001

2003

2001

1998

1997

1998

1995

2000

1994

2005

Rush Hour 1998

1998

1994

1990

2002

2003

1997

1999

1988

1985

2003

1990

1992

1997

1989

2003

1996 234400000

1999

1998

1997

2004

1996

1992

2003

2000

2002

2001

2005

1997

2006

2004

1993

2003

1989

2003

1997

1996

1997

1989

1989

1994

1990 221300000

2004

2003

1998

2005

2004

1999

1988

1989

2000

2002

1994

2000

1995 212300000

1994

1999

2003

2001

1999

2000

1978

2002

2005

2004

1994

2004

2000

1991

2000

1995

2006

1999

1990 202000000

1990

American Pie 1999

1993

2001

Number Title Year BoxOffice
1.0 Titanic 1997 1835300000
2.0 The Lord of the Rings: The Return of the King 2003 1129219252
3.0 Pirates of the Caribbean: Dead Man’s Chest 2006 1059365649
4.0 Harry Potter and the Sorcerer’s Stone 2001 968657891
5.0 Star Wars 1999 922379000
6.0 The Lord of the Rings: The Two Towers 2002 921600000
7.0 Jurassic Park 1993 919700000
8.0 Harry Potter and the Goblet of Fire 2005 892194397
9.0 Shrek 2004 880871036
10.0 Harry Potter and the Chamber of Secrets 866300000
11.0 Finding Nemo 865000000
12.0 The Lord of the Rings: The Fellowship of the Ring 860700000
13.0 Star Wars: Episode III – Revenge of the Sith 848462555
14.0 Independence Day 1996 811

2000
15.0 Spider-Man 806700000
16.0 1977 797900000
17.0 Harry Potter and the Prisoner of Azkaban 789458727
18.0 Spider-Man 2 783577893
19.0 The Lion King 1994 783400000
20.0 E.T. the Extra-Terrestrial 1982 756700000
21.0 The Da Vinci Code 749536138
22.0 The Chronicles of Narnia: The Lion, the Witch and the Wardrobe 738809845
23.0 The Matrix 735600000
24.0 Forrest Gump 679400000
25.0 The Sixth Sense 661500000
26.0 Pirates of the Caribbean: The Curse of the Black Pearl 653200000
27.0 Star Wars: Episode II – Attack of the Clones 648200000
28.0 The Incredibles 624037578
29.0 Ice Age 623829763
30.0 The Lost World: Jurassic Park 614300000
31.0 The Passion of the Christ 604370943
32.0 War of the Worlds 591377056
33.0 Men in Black 587200000
34.0 Star Wars: Episode VI – Return of the Jedi 1983 572700000
35.0 Armageddon 1998 554600000
36.0 King Kong 547051260
37.0 Mission: Impossible 545300000
38.0 Home Alone 1990 533800000
39.0 Star Wars: Episode V – The Empire Strikes Back 1980
40.0 Monsters, Inc. 528900000
41.0 The Day After Tomorrow 527939919
42.0 Ghost 517600000
43.0 Terminator 2: Judgment Day 1991 516800000
44.0 Aladdin 1992 501900000
45.0 Indiana Jones and the Last Crusade 1989 494800000
46.0 Twister 494700000
47.0 Toy Story 485700000
48.0 Troy 481228348
49.0 Saving Private Ryan 479300000
50.0 Charlie and the Chocolate Factory 471856431
51.0 Jaws 1975 470600000
52.0 Pretty Woman 463400000
53.0 Bruce Almighty 458900000
54.0 456300000
55.0 Gladiator 456200000
56.0 X-Men 455260014
57.0 455100000
58.0 Cars 454752771
59.0 452500000
60.0 Pearl Harbor 450400000
61.0 Ocean’s Eleven 444200000
62.0 The Last Samurai 435400000
63.0 Tarzan 435200000
64.0 Meet the Fockers 432667575
65.0 Mr. & Mrs. Smith 427936103
66.0 Men in Black II 425600000
67.0 Die Another Day 424700000
68.0 Dances with Wolves 424200000
69.0 Cast Away 424000000
70.0 The Matrix Revolutions
71.0 Mrs. Doubtfire 423200000
72.0 The Mummy 418700000
73.0 Terminator 3: Rise of the Machines 418200000
74.0 413300000
75.0 Batman 413200000
76.0 Rain Man 1988 412800000
77.0 The Bodyguard 410900000
78.0 Signs 407900000
79.0 Madagascar 406800000
80.0 X2 406400000
81.0 Mission: Impossible III 395382309
82.0 Gone with the Wind 1939 390500000
83.0 Robin Hood: Prince of Thieves
84.0 Superman 389569408
85.0 Raiders of the Lost Ark 1981 383900000
86.0 Grease 1978 379800000
87.0 Beauty and the Beast 378300000
88.0
89.0 Godzilla 375800000
90.0 What Women Want 370800000
91.0 The Fugitive 368700000
92.0 Hitch 367600000
93.0 True Lies 365200000
94.0 Die Hard: With a Vengeance 1995 365000000
95.0 Notting Hill 363000000
96.0 Jurassic Park III 362900000
97.0 There’s Something About Mary 360000000
98.0 Planet of the Apes 358900000
99.0 The Flintstones 358500000
100.0 358100000
101.0 Minority Report 358000000
102.0 A Bug’s Life 357900000
103.0 The Exorcist 1973 357500000
104.0 My Big Fat Greek Wedding 356500000
105.0 Basic Instinct 352700000
106.0 Batman Begins 352000000
107.0 The World Is Not Enough
108.0 GoldenEye 351500000
109.0 Ocean’s Twelve 351331634
110.0 Back to the Future 1985 350600000
111.0 Se7en 350100000
112.0 Who Framed Roger Rabbit 349200000
113.0 Hannibal
114.0 Deep Impact 348600000
115.0 Dinosaur 347800000
116.0 Pocahontas 347100000
117.0 Tomorrow Never Dies 346600000
118.0 Top Gun 1986 344800000
119.0 I, Robot 342795350
120.0 How the Grinch Stole Christmas 340400000
121.0 National Treasure 337605002
122.0 Catch Me If You Can 337400000
123.0 American Beauty 336000000
124.0 Batman Forever 335000000
125.0 Apollo 13 334100000
126.0 Indiana Jones and the Temple of Doom 1984 333000000
127.0 Back to the Future Part II 332000000
128.0 The Rock 330500000
129.0 Over the Hedge 329619340
130.0 Fantastic Four 329295569
131.0 Rush Hour 329100000
132.0 Crocodile Dundee 328000000
133.0 The Perfect Storm 327000000
134.0 The Hunchback of Notre Dame 325500000
135.0 Schindler’s List 321200000
136.0 The Mask 320900000
137.0 Fatal Attraction 1987 320100000
138.0 Lethal Weapon 3 319700000
139.0 Beverly Hills Cop 316400000
140.0 Air Force One 315000000
141.0 As Good as It Gets 313300000
142.0 A Beautiful Mind 312100000
143.0 Austin Powers: The Spy Who Shagged Me 309600000
144.0 Ransom 308700000
145.0 Runaway Bride 307900000
146.0 Chicago 306400000
147.0 Liar Liar 306300000
148.0 Shark Tale 306162022
149.0 101 Dalmatians 304200000
150.0 Mulan 303500000
151.0 Hook 300800000
152.0 Rambo: First Blood Part II 300400000
153.0 Rocky IV
154.0 Beverly Hills Cop II 300000000
155.0 Close Encounters of the Third Kind
156.0 Chicken Little 298181507
157.0 Stuart Little 297600000
158.0 Look Who’s Talking 297100000
159.0 Meet the Parents 295500000
160.0 294100000
161.0 Ghost Busters 291600000
162.0 Doctor Dolittle 290100000
163.0 289400000
164.0 Shakespeare in Love 289100000
165.0 Austin Powers in Goldmember 289000000
166.0 Coming to America 288800000
167.0 The Devil Wears Prada 287665689
168.0 My Best Friend’s Wedding 286900000
169.0 Saturday Night Fever 285400000
170.0 Lethal Weapon 4 284700000
171.0 Speed 283200000
172.0 Batman Returns 282800000
173.0 Wedding Crashers 282718368
174.0 Casper 282300000
175.0 Home Alone 2: Lost in New York 279600000
176.0 American Pie 276400000
177.0 What Lies Beneath 275500000
178.0 Van Helsing 275025245
179.0 The Polar Express 274871234
180.0 Jerry Maguire 273600000
181.0 The Silence of the Lambs 272700000
182.0 The Bourne Supremacy 272549130
183.0 The Nutty Professor 269300000
184.0 The Green Mile 268700000
185.0 Bambi 1942 268000000
186.0 Scooby-Doo 267600000
187.0 xXx 267200000
188.0 Indecent Proposal 266600000
189.0 Jumanji 264600000
190.0 The Fifth Element 263600000
191.0 Lilo & Stitch 262700000
192.0 The Firm 262300000
193.0 Bad Boys II 261900000
194.0 Total Recall 261400000
195.0 Scary Movie 259900000
196.0 Sen to Chihiro no kamikakushi 259200000
197.0 Charlie’s Angels 258500000
198.0 The Full Monty 256900000
199.0 Erin Brockovich 256500000
200.0 The Village 255395633
201.0 Waterworld 255200000
202.0 Cliffhanger 255000000
203.0 Bridget Jones’s Diary 254400000
204.0 Charlie’s Angels: Full Throttle 252500000
205.0 Lara Croft: Tomb Raider 251600000
206.0 You’ve Got Mail 250700000
207.0 Hercules 250600000
208.0 The Truman Show 249200000
209.0 Babe 249000000
210.0 Unbreakable 248900000
211.0 Dumb & Dumber 246200000
212.0 Robots 245600000
213.0 245200000
214.0 Enemy of the State 245100000
215.0 The Godfather 1972 244900000
216.0 Four Weddings and a Funeral 244100000
217.0 Back to the Future Part III 243700000
218.0 8 Mile 242300000
219.0 Hulk 241700000
220.0 Face/Off 241600000
221.0 The Blair Witch Project 240500000
222.0 ‘Crocodile’ Dundee II 239600000
223.0 Out of Africa 239500000
224.0 Love Actually 239200000
225.0 Die Hard 2 237700000
226.0 A Few Good Men 237300000
227.0 Batman & Robin 237200000
228.0 Dead Poets Society 235900000
229.0 2 Fast 2 Furious 234400000
230.0 Eraser
231.0 Big Daddy 233500000
232.0 The Mask of Zorro 233400000
233.0 Bean 232000000
234.0 Hauru no ugoku shiro 231710455
235.0 The English Patient 231700000
236.0 Sister Act 231600000
237.0 American Wedding 230700000
238.0 Gone in Sixty Seconds 230500000
239.0 The Ring 230100000
240.0 Artificial Intelligence: AI 230000000
241.0 Constantine 229500000
242.0 Vita è bella, La 228900000
243.0 Click 228640146
244.0 Bridget Jones: The Edge of Reason 228203020
245.0 Sleepless in Seattle 227900000
246.0 Something’s Gotta Give 227500000
247.0 Lethal Weapon 2 227300000
248.0 Brother Bear 226029248
249.0 Good Will Hunting 225800000
250.0 Space Jam 225400000
251.0 One Hundred and One Dalmatians 1961 224000000
252.0 Con Air 223100000
253.0 Honey, I Shrunk the Kids 222700000
254.0 The Little Mermaid 222300000
255.0 Interview with the Vampire: The Vampire Chronicles 221300000
256.0 Presumed Innocent
257.0 Fahrenheit 9/11 220078393
258.0 Elf 219700000
259.0 The Prince of Egypt 218400000
260.0 Flightplan 218306988
261.0 The Terminal 217845279
262.0 Wild Wild West 217700000
263.0 Twins 216600000
264.0 Ghostbusters II 215400000
265.0 The Patriot 215300000
266.0 The Bourne Identity 213500000
267.0 Pulp Fiction 212900000
268.0 Vertical Limit 212300000
269.0 Ace Ventura: When Nature Calls
270.0 Disclosure 212000000
271.0 Entrapment 211700000
272.0 Master and Commander: The Far Side of the World 210326386
273.0 The Others 209700000
274.0 End of Days 209300000
275.0 Wo hu cang long 209000000
276.0 Jaws 2 208900000
277.0 Red Dragon 208600000
278.0 Kingdom of Heaven 208300000
279.0 Collateral 208003492
280.0 Clear and Present Danger 207500000
281.0 Million Dollar Baby 207400000
282.0 Miss Congeniality 207000000
283.0 The Jungle Book 1967 205800000
284.0 JFK 205400000
285.0 Traffic 204800000
286.0 Braveheart 204000000
287.0 Moonraker 1979 202700000
288.0 The Break-Up 202483135
289.0 Sleepy Hollow 202000000
290.0 Kindergarten Cop
291.0 Teenage Mutant Ninja Turtles 201900000
292.0 201700000
293.0 Philadelphia 201300000
294.0 Vanilla Sky 201000000

/9/

1

/2

/

2

ichael Madsen

/

2

/

/

1

1

2

/

2

2

ene Russo

/

1

/

2

/

2

y Bob Thornton

2

1

Buscemi

/

/

2

/

2

2

are

2

/46

2

2

1

2

2

2

Farrell

/

2

2

1

yle

2

1

2

2

2

/94

1

2

2

Stiles

/

1

Strathairn

2

2

2

/64

1

2

1

2

2

1

2

2

2

2

2

uaid

2

2

2

2

2

1

2

2

2

1

2

2

1

Pegg

2

2

2

2

1

2

2

2

2

1

2

2

2

2

Baker

2

2

2

2

2

1

2

2

2

2

2

1

2

2

2

2

8/18/69 2

2

1

2

2

2

2

2

1

2

von Sydow

2

1

2

2

2

2

2

1

2

2

1

2

1

2

2

1

2

1

2

1

1

2

2

rban

2

1

2

2

2

2

Dance

2

1

2

2

2

2

2

1

1

2

i

1

2

1

2

2

2

2

2

2

1

dy Quaid

2

2

2

1

2

2

1

2

2

2

1

1

1

2

2

1

2

Murphy

2

2

2

2

2

1

1

2

2

1

1

2

2

1

1

2

2

1

2

2

2

2

1

1

1

1

2

4/13/50 2

1

2

1

2

2

2

2

2

2

1

2

2

2

2

2

2

2

1

2

2

2

2

1

2

2

2

1

1

1

2

2

2

2

2

2

2

2

2

2

2

12/3/60 1

2

1

2

2

2

1

1

1

1

2

2

2

2

2

2

2

1/9/65 1

1

2

2

2

3

1

4

2

5

2

6

2

7

2

8

2

9

1

10

1

11

2

12

2

13

2

14

2

15

1

16

2

17

2

18

1

19

2

20

2

21

2

22

2

23

2

24

2

25

2

26

2

27

1

28

2

29

2

30

2

31

2

32

2

33

2

34

2

35

2

36

2

37

1

38

2

39

2

40

3/29/55 2

41

2

42

2

43

2/21/46 2

44

4/15/59 1

45

a Bonham Carter

1

46

2

47

1

48

2

49

1

50

2

51

2

52

2

53

1

54

2

55

2

56

1

57

2

58

2

59

2

60

2

61

2

62

2

63

2

64

1

65

2

66

2

67

2

68

2

69

2

70

2

71

2

72

2

73

2

75

2

76

1

77

2

78

2

79

2

80

2

81

1

82

2

83

2

84

2

85

2

86

2

87

1

88

1

ActorId ActorName ActorDob Actor

GenderId
8 9 Judi Dench 1 2 3 4
90 John Cleese 10 7 39
91 M 9/2

5 58
92 Samantha Bond 11 27 6
93 Mel Gibson 1/3/

56
94 Danny Glover 7/

22 46
95 Joe Pesci 2/9/

43
96 R 2/

17 54
97 Jet Li 4/

26 63
98 Bruce Willis 3/

19 55
99 Bill 8/4/55
100 Liv Tyler 7/1/

77
101 Steve 12 13 57
102 Owen Wilson 11/

18 68
103 Michael Clarke Duncan 12/10/57
104 Peter

Storm 8/27/

53
105 Tommy Lee Jones 9/

15
106 Jamie Foxx 12/13/

67
107 Jessica Biel 3/3/

82
108 Ving Rhames 5/12/

59
109 Donald Sutherland 7/17/

35
110 James Woods 4/18/

47
111 Colin 5/

31 76
112 Ciaran Hinds 2/9/53
113 Sophie Marceau 11/17/

66
1

14 Robert

Carl 4/14/

61
115 Denise Richards 2/17/

71
1

16 Desmond Llewelyn 9/12/13
117 Russell Crowe 4/7/

64
118 Paul Bettany 5/27/71
119 Dakota Fanning 2/

23
1

20 Tim Robbins 10/16/58
1

21 Matt Damon 10/8/

70
122 Julia 3/

28 81
123 David 1/26/

49
1

24 Paddy Considine 9/5/

74
1

25 Albert Finney 5/9/

36
126 Monica Bellucci 9/

30
127 Laurence Fishburne 7/30/61
128 Carrie-Anne Moss 8/21/67
1

29 Keanu Reeves 9/2/64
130 Tom Hanks 7/9/56
131 Audrey Tautou 8/9/76
1

32 Ian McKellen 5/25/39
1

33 Jean Reno 7/30/

48
1

34 Jurgen Prochnow 6/10/

41
135 Richard Harris 10/1/30
136 John Hurt 1/22/

40
1

37 Dennis

Q 4/9/54
1

38 Jake Gyllenhaal 12/19/

80
139 Billy Connolly 11/24/

42
140 Hiroyuki Sanada 10/12/

60
141 Cillian Murphy 5/25/76
142 Michelle Yeoh 8/6/

62
143 George Clooney 5/6/61
1

44 Mark Wahlberg 6/5/71
1

45 John C. Reilly 5/24/

65
146 Mary Elizabeth Mastrantonio 11/17/58
147 Michael Ironside 2/12/

50
148 Philip Seymour Hoffman 7/23/67
149 Michelle Monaghan 3/23/76
150 Simon 2/14/70
1

51 Nicolas Cage 1/7/64
1

52 Christian Slater 8/18/

69
153 Ewan McGregor 3/31/71
154 Natalie Portman 6/9/81
155 Hayden Christensen 4/19/81
156 Frank Oz 5/25/44
157 Ian McDiarmid 8/11/44
158 Temuera Morrison 12/26/60
159 Rena Owen 7/22/62
160 Billy Crystal 3/14/48
161 James Coburn 8/31/28
162 Ray Park 8/23/74
163 Anthony Daniels 2/21/46
164 Kenny 8/24/34
165 Peter Mayhew 5/19/44
166 Joe Don Baker 2/12/36
167 Elliott Gould 8/29/38
168 Andy Garcia 4/12/56
169 Julia Roberts 10/28/67
170 Don Cheadle 11/29/64
171 Timothy Olyphant 5/20/68
1

72 Jackie Chan 4/7/54
1

73 Steve Coogan 10/14/65
174 Arnold Schwarzenegger 7/30/47
1

75 Maggie Q 5/22/

79
176 Sammo Hung 1/7/52
177 Jim Broadbent 5/24/49
1

78 Luke Wilson 9/21/71
179 Jeremy Irons 9/19/48
180 Edward Norton
181 Vince Vaughan 3/28/70
182 Cate Blanchett 5/14/69
1

83 Jude Law 12/29/72
1

84 Brent Spiner 2/2/49
1

85 Viggo Mortensen 10/20/58
1

86 Elijah Wood 1/28/81
1

87 James Cromwell 1/27/40
1

88 Bridget Moynahan 4/28/71
1

89 Daniel Craig 3/2/68
190 Max 4/10/29
191 Linda Hamilton 9/26/56
192 Edward Furlong 8/2/77
193 Robert Patrick 11/5/58
194 Kenneth Branagh 12/10/60
195 Denzel Washington 12/28/54
196 Djimon Hounsou 4/24/64
197 Jennifer Connelly 12/12/70
198 Arnold Vosloo 6/16/62
199 Joaquin Phoenix 10/28/74
200 Connie Nielsen 7/3/65
201 Oliver Reed 2/13/37
202 Jamie Lee Curtis 11/22/58
203 Tom Arnold 3/6/59
204 Charlton Heston 10/4/24
205 Tia Carrere 1/2/67
206 Art Malik 11/13/52
207 Eliza Dushku 12/30/80
208 Daniel Day-Lewis 4/29/57
209 Cameron Diaz 8/30/72
210 Milla Jovovich 12/17/75
211 Chris Tucker 8/31/72
212 Sean Bean 4/17/59
213 Karl

U 6/7/72
214 Linda Fiorentino 3/9/58
215 Jack Nicholson 4/22/37
216 Martin Sheen 8/3/40
217 Paul Giamatti 6/6/67
218 F. Murray Abraham 10/24/39
219 Charles 10/10/46
221 Catherine Zeta-Jones 9/25/69
222 Adam Sandler 9/9/66
223 Christopher Walken 3/31/43
224 David Hasselhoff 7/17/52
225 Henry Winkler 10/30/45
226 Jim Carrey 1/17/62
227 Jennifer Aniston 2/11/69
228 Emmanuelle Beart 8/14/63
229 Robert Duvall 1/5/31
230 Tea

Leon 2/25/66
231 Jon Favreau 10/19/66
232 Vanessa Redgrave 1/30/37
233 Paul Newman 1/26/25
234 Stanley Tucci 11/11/60
235 Ed Harris 11/28/50
236 Christopher Plummer 12/13/29
237 Clive Owen 10/3/64
238 Bill Pullman 12/17/53
239 Mary McDonnell 4/28/52
240 Ran 10/1/50
241 Hugh Jackman 10/12/68
242 Patrick Stewart 7/13/40
243 Famke Janssen 11/5/65
244 Sean Connery 8/25/30
245 Michael Biehn 7/31/56
246 Rachel Weisz 3/7/71
247 Will Ferrell 7/16/67
248 Sacha Baron Cohen 10/13/71
249 Dan Castellaneta 5/29/57
250 Julie Kavner 9/7/50
251 Nancy Cartwright 10/25/57
252 Yeardley

Smith 7/3/64
253 Patrick McGoohan 3/19/28
254 William Hurt 3/20/50
255 Sigourney Weaver 10/8/49
256 Mike Myers 5/25/63
257 Eddie 4/3/61
258 Antonio Banderas 8/10/60
259 Jonathan Frakes 8/19/52
260 LeVar Burton 2/16/57
261 Michael Dorn 12/9/52
262 Gates McFadden 3/2/49
263 Marina Sirtis 3/29/55
264 Bob Hoskins 10/26/42
265 Christopher Lloyd 10/22/38
266 Kathleen Turner 6/19/54
267 Christina Ricci 2/12/80
268 Vin Diesel 7/18/67
269 William Sadler 4/13/50
270 Bonnie Bedelia 3/25/48
271 Geena Davis 1/21/56
272 Kevin Bacon 7/8/58
273 Gary Sinise 3/17/55
274 Sharon Stone 3/10/58
275 Sylvester Stallone 7/6/46
276 John Lithgow 10/19/45
277 Michael Rooker 4/6/55
278 Harrison Ford 7/13/42
279 Scarlett Johansson 11/22/84
280 Hilary Swank 7/30/74
281 Kathleen Quinlan 11/19/54
282 Joely Richardson 1/9/65
283 Sean Pertwee 6/4/64
284 Ron Perlman
285 Selma Blair 6/23/72
286 Ben Stiller 11/30/65
287 Juliette Lewis 6/21/73
288 Fred Williamson 3/5/38
289 Snoop Dogg 10/20/71
290 Chris Penn 10/10/65
291 Gerard Butler 11/13/69
292 Dominic West 10/15/69
293 David Wenham 9/21/65
294 Lena Headey 10/3/73
295 Malcolm McDowell 6/13/43
296 James Doohan 3/3/20
297 Walter Koenig 9/14/36
298 William Shatner 3/22/31
299 Leonard Nimoy 3/26/31
300 DeForest Kelley 1/20/20
301 George Takei 4/20/37
302 Nichelle Nichols 12/28/32
303 Ricardo Montalban 11/25/20
305 Marlon Brando 4/3/24
306 Gene Hackman 1/30/30
307 Christopher Reeve 9/25/52
308 Margot Kidder 10/17/48
309 James Gandolfini 9/18/61
310 Val Kilmer 12/31/59
311 Jim Caviezel 9/26/68
312 Uma Thurman 4/29/70
313 Lucy Liu 12/2/68
314 Daryl Hannah 12/3/60
315 David Carradine 12/8/36
316 Charles S. Dutton 1/30/51
317 Pete Postlethwaite 2/16/46
318 Wesley Snipes 7/31/62
319 Kris Kristofferson 6/22/36
320 Donnie Yen 7/27/63
321 Ryan Phillippe 9/10/74
322 Robert De Niro 8/17/43
323 John Rhys-Davies 5/5/44
324 Stephen Dorff 7/29/73
325 James Earl Jones 1/17/31
326 Julianne Moore
327 Joe Pantoliano 9/12/51
328 Madeleine Stowe 8/18/58
329 Russell Means 11/10/39
330 Wes Studi 12/17/47
331 Rudy Youngblood 9/21/82
332 Dalia Hernandez 8/14/85
333 Rachel McAdams 10/7/76
334 Isla Fisher 2/3/76
335 Jane Seymour 2/15/51
336 Michael J. Fox 6/9/61
337 Thomas F. Wilson 4/15/59
338 Timothy Dalton 3/21/44
339 Benicio Del Toro 2/19/67
340 Robert Brown 7/23/21
341 David Hedison 5/20/27
1000 Andy Brown 3/4/64
1001 Jenny Brown
Tom Cruise 7/3/62
Sam Neill 9/14/47
Laura Dern 2/10/67
Jeff Goldblum 10/22/52
Richard Attenborough 8/29/23
Samuel L. Jackson 12/21/48
Tobey Maguire 6/27/75
Willem Dafoe 7/22/55
Kirsten Dunst 4/30/82
Naomi Watts 9/28/68
Jack Black 8/28/69
Adrien Brody 4/14/73
Andy Serkis 4/20/64
Brandon Routh 10/9/79
Kate Bosworth 1/2/83
Kevin Spacey 7/26/59
Leonardo DiCaprio 11/11/74
Kate Winslet 10/5/75
Billy Zane 2/24/66
Bill Paxton 5/17/55
Steve Carell 8/16/62
Morgan Freeman 6/1/37
Kevin Costner 1/18/55
Dennis Hopper 5/17/36
Ben Affleck 8/15/72
Josh Hartnett 7/21/78
Kate Beckinsale 7/26/73
Cuba Gooding Jr. 1/2/68
Jon Voight 12/29/38
Alec Baldwin 4/3/58
Tom Sizemore 11/29/61
Dan Aykroyd 7/1/52
Shia LaBeouf 6/11/86
John Turturro 2/28/57
Peter Cullen 7/28/41
Hugo Weaving 4/4/60
Megan Fox 5/16/86
Daniel Radcliffe 7/23/89
Ralph Fiennes 12/22/62
Brendan Gleeson
Gary Oldman 3/21/58
Michael Gambon 10/19/40
Alan Rickman
Emma Thompson
Helen 5/26/66
Robbie Coltrane 3/30/50
Emma Watson 4/15/90
Rupert Grint 8/24/88
Robin Wright Penn 4/8/66
Anthony Hopkins 12/31/37
John Malkovich 12/9/53
Ray Winstone 2/19/57
Angelina Jolie 6/4/75
John Goodman 6/20/52
Jerry Seinfeld 4/29/54
Renee Zellweger 4/25/69
Matthew Broderick 3/21/62
Chris Rock 2/7/65
Ray Liotta 12/18/54
Rip Torn 2/6/31
Johnny Depp 6/9/63
Geoffrey Rush 7/6/51
Orlando Bloom 1/13/77
Keira Knightley 3/26/85
Bill Nighy 12/12/49
Jonathan Pryce 6/1/47
Stellan Skarsgard 6/13/51
Will Smith 9/25/68
Patton Oswalt 1/27/69
Ian Holm 9/12/31
Brian Dennehy 7/9/38
Peter O’Toole 8/2/32
Brian Cox 6/1/46
Brad Pitt 12/18/63
Diane Kruger 7/15/76
Eric Bana 8/9/68
Christian Bale 1/30/74
Michael Caine 3/14/33
Liam Neeson 6/7/52
Katie Holmes 12/18/78
Rutger Hauer 1/23/44
Ken Watanabe 10/21/59
James Fox 5/19/39
Christopher Lee 5/27/22
Pierce Brosnan 5/16/53
Halle Berry 8/14/66
Rosamund Pike 1/28/79

1

1.0

2

3.0 1.0

3

1.0

4

1.0

5

1.0

6

2.0

7

2.0

8

2.0

9

3.0

10

3.0

11

3.0

12

3.0

13

5.0

14

5.0

15

5.0

16

6.0

17

6.0

18

6.0

19

6.0

20

7.0

21

7.0

22

8.0

23

8.0

24

8.0

11

9.0

25

9.0

26

9.0

27

9.0

28

9.0

29

9.0

30

9.0

31

9.0

32

33

10.0

37

10.0

29

10.0

34

10.0

35

10.0

36

11.0

38

11.0

39

11.0

40

11.0

41

11.0

47

11.0

48

11.0

42

11.0

43

11.0

44

11.0

45

11.0

46

12.0

49

12.0

50

12.0

51

12.0

52

12.0

40

12.0

53

7.0

54

13.0

55

13.0

56

13.0

57

13.0

54

13.0

58

13.0 Ray Liotta 59

13.0

60

14.0

61

14.0

62

14.0

63

14.0

64

14.0

65

14.0

66

14.0

67

15.0

68

15.0

ce Krippin

44

16.0

69

16.0

70

16.0

71

16.0

72

17.0

73

17.0

75

17.0

40

17.0 Helen 76

17.0

77

17.0

63

18.0 Harry Potter 38

18.0 Hermione Granger 47

18.0 Ron Weasley 48

18.0 Rubeus Hagrid 46

18.0 Albus Dumbledore 42

18.0 Severus Snape 43

18.0

40

18.0 Sirius Black 41

18.0 Lord Voldemort 39

19.0

78

19.0

79

19.0

80

19.0

81

19.0

41

19.0

82

19.0

83

19.0

22

20.0

61

20.0

45

20.0

84

20.0

85

21.0 Captain Jack Sparrow 61

21.0 Will Turner 63

21.0 Elizabeth Swann 64

21.0 Davy Jones 65

21.0 Governor Weatherby Swann 66

21.0 ‘Bootstrap’ Bill Turner 67

22.0

86

22.0 M 89

22.0 R 90

.0

22.0

87

22.0

88

.0

22.0

91

22.0

92

23.0

93

23.0

94

.0

23.0

95

.0

23.0

96

23.0

58

23.0

97

.0

24.0

98

.0

24.0

99

24.0

25

24.0

100

24.0

101

.0

24.0

102

24.0

103

24.0

104

.0

25.0

68

.0

25.0

105

.0

25.0

60

26.0 Peter Parker 7

26.0 Mary Jane Watson 9

.0

27.0 Peter Parker 7

.0

27.0 Mary Jane Watson 9

27.0 Norman Osborn 8

28.0

106

28.0

107

29.0

30

29.0

108

.0

29.0

101

.0

29.0

109

29.0

110

30.0

111

30.0

106

30.0

112

31.0 James Bond 86

.0

31.0

113

.0

31.0

114

31.0

115

31.0

46

31.0 Q 116

31.0 M 89

31.0 R 90

31.0 Miss Moneypenny 92

32.0

117

32.0

118

33.0

119

33.0

120

34.0

121

34.0

122

34.0

123

34.0

124

34.0

125

35.0 Harry Potter 38

35.0 Hermione Granger 47

35.0 Ron Weasley 48

35.0 Sirius Black 41

.0

35.0

43

.0

35.0 Rubeus Hagrid 46

35.0

44

.0

36.0

126

36.0

127

36.0

128

.0

36.0

129

36.0

36

37.0

130

37.0

131

37.0

132

.0

37.0

133

.0

37.0

118

.0

37.0

134

.0

38.0

135

.0

38.0 Rubeus Hagrid 46

.0

38.0 Harry Potter 38

.0

38.0

136

38.0 Ron Weasley 48

38.0 Hermione Granger 47

38.0

90

38.0 Professor Severus Snape 43

39.0

137

39.0

138

39.0

70

40.0 Captain Jack Sparrow 61

40.0 Will Turner 63

40.0 Elizabeth Swann 64

40.0 Governor Weatherby Swann 66

40.0 Captain Barbossa 62

41.0

1

41.0

83

140

264.0

141

264.0

142

19.0

141

41.0

140

41.0

139

42.0

143

42.0

144

42.0

145

42.0

146

42.0

147

43.0

1

43.0

148

43.0

108

43.0 Julia 149

43.0

150

43.0

127

44.0 Ethan Hunt 1

44.0

108

44.0

40

45.0 Christian Slater 151

45.0

104

45.0

152

46.0

153

46.0

Amidala

154

46.0

155

46.0

85

46.0

6

46.0

156

46.0

157

46.0

158

158

265.0

159

47.0

54

47.0

160

47.0

101

47.0

161

47.0

156

48.0

80

48.0 Obi-Wan Kenobi 153

48.0

154

48.0 Yoda 156

48.0

157

48.0

162

48.0

163

48.0

164

48.0 Mace Windu 6

48.0

64

49.0 Obi-Wan Kenobi 153

49.0 Padme 154

49.0 Anakin Skywalker 155

49.0

157

49.0 Mace Windu 6

49.0 Yoda 156

49.0 C-3PO 163

49.0 R2-D2 164

49.0 Count Dooku 85

49.0

158

49.0

165

49.0

159

264.0 50.0 Persephone 126
265.0 50.0 Morpheus 127

50.0 Trinity 128

50.0 Neo 129

50.0 Agent Smith 36

51.0 James Bond 86

51.0

66

51.0

142

51.0

166

51.0 M 89

51.0 Q 116

51.0 Miss Moneypenny 92

52.0

143

52.0

75

52.0

167

52.0

121

52.0

168

52.0

169

52.0

170

53.0

98

53.0

171

53.0

175

54.0

172

54.0

173

54.0

177

54.0

174

54.0

Agent

175

54.0

176

54.0

102

54.0

90

54.0

178

55.0

80

55.0

63

55.0

40

55.0

179

55.0

Baldwin

180

56.0

75

56.0

53

56.0 Eddie 181

56.0

149

57.0

17

57.0

182

57.0

27

57.0

145

57.0

30

57.0

70

57.0

183

57.0

184

57.0

8

58.0

68

58.0

106

58.0

29

59.0

182

59.0

63

59.0

70

59.0

85

59.0

13

59.0

132

59.0

185

59.0

100

59.0

36

59.0

186

60.0

68

60.0

33

60.0

188

60.0

187

61.0 James Bond 189

61.0 M 89

62.0

1

62.0

190

62.0

111

62.0

104

63.0

174

63.0

191

63.0

192

63.0

193

64.0

87

65.0 Harry Potter 38

65.0 Ron Weasley 48

65.0 Hermione Granger 47

65.0 Rubeus Hagrid 46

65.0

194

65.0

43

65.0 Professor Albus Dumbledore 135

65.0 Nearly Headless Nick 90

66.0

195

66.0

117

67.0

17

67.0

196

67.0

197

67.0

198

68.0

117

68.0

199

68.0

200

68.0

201

68.0

135

68.0

196

69.0

174

69.0

202

69.0

203

69.0 Simon 20

69.0

204

69.0

205

69.0

206

69.0

207

70.0

17

70.0

208

70.0

209

70.0

177

70.0

145

70.0

80

70.0

40

71.0

26

71.0

153

71.0

31

71.0

77

72.0

98

72.0

41

72.0

70

72.0

210

72.0

211

59.0

212

73.0 Boromir 212

73.0 Galadriel 182

73.0 Legolas Greenleaf 63

73.0 Bilbo Baggins 70

73.0

132

73.0 Aragorn 185

73.0 Gollum 13

73.0 Arwen 100

73.0 Elrond 36

73.0 Frodo Baggins 186

73.0 Saruman 85

74.0 Galadriel 182

74.0 Legolas Greenleaf 63

74.0 Saruman 85

74.0 Gandalf the White 132

74.0 Aragorn 185

74.0 Gollum 13

74.0 Arwen 100

74.0

213

73.0 Eomer 213

74.0 Elrond 36

74.0 Frodo Baggins 186

74.0 Boromir 212

75.0

172

75.0

211

75.0

190

75.0

140

76.0 Chief Inspector Lee 172

76.0 Detective James Carter 211

76.0

175

76.0 Kenny 170

77.0 Agent Kay 105

77.0 Agent Jay 68

77.0 Zed 60

77.0

214

78.0

17

78.0 Colin 121

78.0

215

78.0

144

78.0

216

78.0

52

78.0

30

79.0 John McClane 98

79.0

179

79.0

6

80.0

117

80.0

56

80.0

217

80.0

124

81.0 Jason Bourne 121

81.0

73

81.0 Nicky Parsons 122

81.0

213

81.0

149

82.0

174

82.0

218

82.0

132

82.0 Benedict 219

83.0

130

84.0 Rusty Ryan 75

84.0

221

84.0 Danny Ocean 143

84.0 Tess Ocean 169

84.0

168

84.0 Basher Tarr 170

84.0 Linus Caldwell 121

84.0 Reuben Tishkoff 167

84.0

125

85.0

222

85.0

27

85.0

223

85.0

224

85.0

225

86.0

226

86.0 God 22

86.0

227

86.0 Evan Baxter 21

87.0 Ethan Hunt 1

87.0

29

87.0

228

87.0

133

87.0 Luther Stickell 108

87.0 Max 232

88.0

229

88.0

230

88.0

186

88.0

232

88.0

22

88.0

187

88.0

231

89.0

130

89.0

233

89.0

189

89.0

112

89.0

183

89.0

234

90.0

117

90.0

235

90.0

197

90.0

236

90.0 Charles 118

91.0

79

91.0

237

92.0

77

92.0 Steve 189

92.0 Carl 112

92.0

62

93.0

68

93.0

238

93.0

4

93.0

239

93.0

240

93.0

184

94.0

241

94.0

242

94.0

132

94.0

243

94.0 Storm 87

94.0

162

95.0 Professor Charles Xavier 242

95.0 Wolverine 241

95.0 Magneto 132

95.0 Storm 87

95.0 Jean Grey 243

95.0

73

96.0

244

96.0

151

96.0

235

96.0

245

97.0

129

97.0

246

97.0

33

97.0

196

97.0

104

98.0

98

98.0

6

98.0

49

99.0

103

99.0

247

99.0

145

99.0

248

100.0

249

100.0

251

100.0

250

100.0

252

101.0

93

101.0

73

101.0

253

101.0

113

101.0

40

102.0

138

102.0

106

103.0

199

103.0

12

103.0

254

103.0

255

103.0

40

104.0

256

104.0

257

104.0

258

104.0 King 90

105.0 Shrek 256

105.0 Donkey 257

105.0 Puss in Boots 258

105.0 King 90

105.0

209

104.0 Princess Fiona 209

106.0

235

106.0

146

106.0

245

107.0

242

107.0

259

107.0

184

107.0

260

107.0

261

107.0

262

107.0

263

107.0

218

108.0

264

108.0

265

108.0

266

108.0

251

109.0

61

109.0

267

109.0

42

109.0

157

109.0

223

109.0

85

110.0

268

110.0

6

111.0 John McClane 98

111.0

270

111.0

269

111.0

193

112.0

271

112.0

6

112.0

73

113.0

130

113.0

20

113.0

272

113.0

273

113.0

235

130

114.0

31

114.0

268

114.0

121

114.0

217

115.0

180

115.0

75

115.0

45

Neo 129

116.0 Trinity 128

116.0 Morpheus 127

116.0 Agent Smith 36

117.0

174

64.0

274

82.0

274

117.0

274

117.0

147

118.0

275

118.0

276

118.0

277

119.0

278

119.0

8

James Bond 86

120.0

212

120.0

243

120.0 Jack Wade 166

120.0 M 89

120.0 Q 116

120.0 Miss Moneypenny 92

26

121.0

279

121.0

280

122.0

226

122.0

235

122.0

217

123.0

127

123.0

2

123.0

281

113.0

281

123.0

282

123.0 Smith 283

Jason Bourne 121

124.0

237

124.0 Ward Abbott 73

124.0 Nicky Parsons 122

284

125.0

136

125.0

285

126.0

102

126.0

286

126.0

289

126.0

288

126.0

181

126.0

287

126.0

290

126.0

69

127.0

143

127.0

221

127.0

62

127.0

99

73.0

293

74.0 Faramir 293

128.0

291

128.0

294

128.0

292

128.0

293

Captain Jean-Luc Picard 242

129.0 Commander William T. Riker 259

129.0 Lt. Commander Data 184

129.0 Lt. Commander Geordi La Forge 260

129.0 Lt. Commander Worf 261

129.0 Dr. Beverly Crusher 262

129.0 Commander Deanna Troi 263

129.0

284

146.0 Captain Jean-Luc Picard 242

146.0 Commander William T. Riker 259

146.0 Lt. Commander Data 184

146.0 Lt. Commander Geordi La Forge 260

146.0 Lt. Commander Worf 261

146.0 Dr. Beverly Crusher 262

146.0 Commander Deanna Troi 263

146.0

187

160.0 Captain Jean-Luc Picard 242

160.0 Commander William T. Riker 259

160.0 Lt. Commander Data 184

160.0 Lt. Commander Geordi La Forge 260

160.0 Lt. Commander Worf 261

160.0 Dr. Beverly Crusher 262

160.0 Commander Deanna Troi 263

160.0

298

160.0

295

160.0

296

160.0

297

225.0

298

225.0

299

225.0

300

225.0

296

225.0 Commander Pavel Chekov 297

225.0

301

225.0

302

225.0

303

162.0 Commander Montgomery “Scotty” Scott 296

162.0

297

162.0

301

162.0

302

162.0 Admiral James T. Kirk 298

162.0

299

162.0 Dr. Leonard “Bones” McCoy 300

201.0

265

201.0 Commander Montgomery “Scotty” Scott 296

201.0 Commander Pavel Chekov 297

201.0 Commander Hikaru Sulu 301

201.0 Commander Uhura 302

201.0 Admiral James T. Kirk 298

201.0 Captain Spock 299

201.0 Dr. Leonard “Bones” McCoy 300

174.0 Captain James T. Kirk 298

174.0 Captain Spock 299

174.0 Dr. Leonard “Bones” McCoy 300

174.0 Captain Montgomery “Scotty” Scott 296

174.0 Commander Pavel Chekov 297

174.0 Commander Uhura 302

174.0 Commander Hikaru Sulu 301

180.0 Captain James T. Kirk 298

180.0 Captain Spock 299

180.0 Dr. Leonard “Bones” McCoy 300

180.0 Captain Montgomery “Scotty” Scott 296

180.0 Commander Pavel Chekov 297

180.0 Commander Uhura 302

180.0

301

180.0

236

180.0

261

180.0

152

191.0 Captain James T. Kirk 298

191.0 Captain Spock 299

191.0 Dr. Leonard “Bones” McCoy 300

191.0 Commander Montgomery “Scotty” Scott 296

191.0 Commander Hikaru Sulu 301

191.0 Commander Pavel Chekov 297

191.0 Commander Uhura 302

130.0 Clark Kent 307

130.0

305

130.0 Lex Luthor 306

130.0 Lois Lane 308

131.0

195

131.0

306

131.0

185

131.0

309

195

132.0

310

132.0

311

195

133.0

119

133.0

223

68

134.0

306

134.0

29

134.0

11

134.0

31

135.0

312

135.0

313

135.0

314

135.0 Bill 315

135.0

91

136.0

255

136.0

316

136.0

219

136.0 David 317

172

137.0

102

137.0

313

The Bride 312

138.0 Bill 315

138.0 O-Ren Ishii 313

138.0 Budd 91

138.0 Elle Driver 314

138.0

6

139.0

318

139.0

319

139.0

284

139.0

320

140.0

321

140.0

193

141.0

322

141.0

274

141.0

95

141.0

110

142.0

23

142.0

22

142.0

146

142.0

152

142.0

43

142.0

244

143.0 Shrek 256

143.0 Donkey 257

143.0 Princess Fiona 209

143.0

276

Chon Wang 172

144.0 Roy O’Bannon 102

144.0

320

278

145.0

244

145.0

323

59.0

323

73.0 Gimli 323

74.0 Gimli 323

147.0 Blade 318

147.0 Abraham Whistler 319

147.0

324

148.0 Jack Ryan 278

148.0

212

148.0

6

148.0

135

148.0

325

149.0

278

149.0

105

149.0

326

149.0

327

150.0

241

150.0

78

150.0

79

150.0

279

150.0

13

208

151.0

328

151.0

chgook

329

151.0

330

331

152.0

332

153.0

102

153.0

181

153.0

223

153.0

333

153.0

334

153.0

335

154.0

336

154.0

265

154.0

337

155.0 Marty McFly 336

155.0 Dr. Emmett Brown 265

155.0

337

156.0 James Bond 338

156.0

339

156.0 Q 116

156.0 M 340

156.0

341

CastID Cast

FilmID CastCharacterName CastActorID
1.0 3

3.0 Ray Ferrier
2.0 Dr. Alan Grant
Dr. Ellie Sattler
4.0 Dr. Ian Malcolm
5.0 John Hammond
6.0 Ray Arnold
7.0 Peter Parker
8.0 Norman Osborn
9.0 Mary Jane Watson
1

0.0 Ann Darrow
11.0 Carl Denham
12.0 Jack Driscoll
13.0 Kong
14.0 Clark Kent
15.0 Lois Lane
16.0 Lex Luthor
17.0 Jack Dawson
18.0 Rose DeWitt Bukater
19.0 Caledon ‘Cal’ Hockley
20.0 Brock Lovett
21.0 Evan Baxter
22.0 God
23.0 Mariner
24.0 Deacon
25.0 Pilot
26.0 Captain Rafe McCawley
27.0 Captain Danny Walker
28.0 Nurse Lt. Evelyn Johnson
29.0 Petty Officer Doris Miller
30.0 President Franklin Delano Roosevelt
31.0 Lt. Col. James Doolittle
32.0 Sgt. Earl Sistern
33.0 Captain Thurman
34.0 10.0 Sam Witwicky
35.0 Mikaela Banes
36.0 Defense Secretary John Keller
37.0 Agent Simmons
38.0 Optimus Prime
39.0 Megatron
40.0 Harry Potter
41.0 Lord Voldemort
42.0 Alastor ‘Mad-Eye’ Moody
43.0 Sirius Black
44.0 Hermione Granger
45.0 Ron Weasley
46.0 Albus Dumbledore
47.0 Severus Snape
48.0 Sybil Trelawney
49.0 Bellatrix Lestrange
50.0 Rubeus Hagrid
51.0 Wealthow
52.0 Hrothgar
53.0 Unferth
54.0 Beowulf
55.0 Wiglaf
56.0 Grendel’s Mother
57.0 Congressman Long
58.0 Barry B. Benson
59.0 Vanessa Bloome
60.0 Adam Flayman
61.0 Layton T. Montgomery
62.0 Mooseblood
63.0
64.0 Lou Lo Duca
65.0 Captain Jack Sparrow
66.0 Captain Barbossa
67.0 Will Turner
68.0 Elizabeth Swann
69.0 Davy Jones
70.0 Governor Weatherby Swann
71.0 ‘Bootstrap’ Bill Turner
72.0 Robert Neville
73.0 Dr.

Ali
74.0 Remy
75.0 Skinner
76.0 Django
77.0 Anton Ego
78.0 Agamemnon
79.0 Achilles
80.0 Menelaus
81.0
82.0 Hector
83.0 Paris
84.0
85.0
86.0
87.0
88.0
89.0
90.0 Professor Alastor ‘Mad­Eye’ Moody
91.0
92.0
93.0 Bruce Wayne
94.0 Alfred
95.0 Henri Ducard
96.0 Rachel Dawes
97.0 Jim Gordon
98.0 Earle
99.0 Ra’s Al Ghul
100.0 Lucius Fox
101.0 Willy Wonka
102.0 Mrs. Bucket
103.0 Mr. Salt
104.0 Dr. Wonka
105.0
106.0
107.0
108.0
109.0
110.0
111.0 James Bond
112.0
113.0
114 Jinx
115.0 Miranda Frost
116 Damian Falco
117.0 Miss Moneypenny
118.0 Martin Riggs
119.0 Roger Murtaugh
120 Leo Getz
121 Lorna Cole
122.0 Detective Lee Butters
123.0 Wah Sing Ku
124 Harry S. Stamper
125 Dan Truman
126.0 A.J. Frost
127.0 Grace Stamper
128.0 Rockhound
129 Oscar Choi
130.0 Jayotis ‘Bear’ Kurleenbear
131.0 Lev Andropov
132 Agent Jay
133 Agent Kay
134 Zed
135.0
136.0
137
138
139.0
140.0 Lt. Henry Purcell
141.0 Lt. Kara Wade
142.0 Captain Gray Edwards
143.0 Sgt. Ryan Whitaker
144 Officer Neil Fleming
145 Dr. Cid
146.0 General Hein
147.0 Sonny Crockett
148.0 Ricardo Tubbs
149.0 FBI Agent Fujima
150.0
151 Elektra
152 Renard
153.0 Christmas Jones
154.0 Valentin Zukovsky
155.0
156.0
157.0
158.0
159.0 Captain Jack Aubrey
160.0 Dr. Stephen Maturin
161.0 Rachel Ferrier
162.0 Harlan Ogilvy
163.0 Jason Bourne
164.0 Nicky Parsons
165.0 Deputy Director Noah Vosen
166.0 Simon Ross
167.0 Dr. Albert Hirsch
168.0
169.0
170.0
171.0
172 Professor Severus Snape
173
174.0 Professor Sybil Trelawney
175 Persephone
176.0 Morpheus
177.0 Trinity
178 Neo
179.0 Agent Smith
180.0 Dr. Robert Langdon
181.0 Agent Sophie Neveu
182.0 Sir Leigh Teabing
183 Captain Bezu Fache
184 Silas
185 Andre Vernet
186 Professor Albus Dumbledore
187
188
189 Mr. Ollivander
190.0
191.0
192.0 Nearly Headless Nick
193.0
194.0 Jack Hall
195.0 Sam Hall
196.0 Terry Rapson
197.0
198.0
199.0
200.0
201.0
202.0 Nathan Algren
203.0 Katsumoto
204.0 264.0 Kaneda
205.0 Capa
206.0 Corazon
207.0 Dr. Jonathan Crane
208.0 Ujio
209.0 Zebulon Gant
210.0 Captain Billy Tyne
211.0 Bobby Shatford
212.0 Dale ‘Murph’ Murphy
213.0 Linda Greenlaw
214.0 Bob Brown
215.0 Ethan Hunt
216.0 Owen Davian
217.0 Luther
218.0
219.0 Benji
220.0 Theodore Brassel
221.0
222.0 Luther Stickell
223.0 John C. McCloy
224.0
225.0 Gunnery Sergeant Hjelmstad
226.0 Sgt. Pete ‘Ox’ Anderson
227.0 Obi-Wan Kenobi
228.0 Senator

Padme
229.0 Anakin Skywalker
230.0 Count Dooku
231.0 Mace Windu
232.0 Yoda
233.0 Chancellor Palpatine
234.0 Jango Fett
235.0 265.0 Jake Heke
236.0 Beth Heke
237.0 James P. “Sulley” Sullivan
238.0 Mike Wazowski
239.0 Randall Boggs
240.0 Henry J. Waternoose
241.0 Fungus
242.0 Qui-Gon Jinn
243.0
244.0 Queen Padme Amidala
245.0
246.0 Senator Palpatine
247.0 Darth Maul
248.0 C-3PO
249.0 R2-D2
250.0
251.0 Sabé
252.0
253.0
254.0
255.0 Supreme Chancellor Palpatine
256.0
257.0
258.0
259.0
260.0
261.0 Commander Cody
262.0 Chewbacca
263.0 Nee Alavar
266.0
267.0
268.0
269.0
270.0 Elliot Carver
271.0 Wai Lin
272.0 Jack Wade
273.0
274.0
275.0
276.0 Danny Ocean
277.0 Rusty Ryan
278.0 Reuben Tishkoff
279.0 Linus Caldwell
280.0 Terry

Benedict
281.0 Tess Ocean
282.0 Basher Tarr
283.0 John McClane
284.0 Thomas Gabriel
285.0 Mai
286.0 Passepartout
287.0 Phileas Fogg
288.0 Lord Kelvin
289.0 Prince Hapi
290.0 Female
291.0 Wong Fei Hung
292.0 Wilbur Wright
293.0 Grizzled Sergeant
294.0 Orville Wright
295.0 Godfrey de Ibelin
296.0 Balian de Ibelin
297.0 Reynald
298.0 Tiberias
299.0 King
300.0 John Smith
301.0 Jane Smith
302.0
303.0 Gwen
304.0 Howard Hughes
305.0 Katharine Hepburn
306.0 Ava Gardner
307.0 Noah Dietrich
308.0 Juan Trippe
309.0 Professor Fitz
310.0 Errol Flynn
311.0 Robert Gross
312.0 Roland Sweet
313.0 Muhammad Ali
314.0 Drew ‘Bundini’ Brown
315.0 Howard Cosell
316.0 Galadriel
317.0 Legolas Greenleaf
318.0 Bilbo Baggins
319.0 Saruman
320.0 Gollum
321.0 Gandalf the Grey
322.0 Aragorn
323.0 Arwen
324.0 Elrond
325.0 Frodo Baggins
326.0 Del Spooner
327.0 Farber
328.0 Susan Calvin
329.0 Dr. Alfred Lanning
330.0
331.0
332.0 Chief John Anderton
333.0 Director Lamar Burgess
334.0 Danny Witwer
335.0 Dr. Solomon Eddie
336.0 The Terminator
337.0 Sarah Connor
338.0 John Connor
339.0 T-1000
340.0 Patience Phillips
341.0
342.0
343.0
344.0
345.0 Professor Gilderoy Lockhart
346.0 Professor Snape
347.0
348.0
349.0 Frank Lucas
350.0 Detective Richie Roberts
351.0 Danny Archer
352.0 Solomon Vandy
353.0 Maddy Bowen
354.0 Colonel Coetzee
355.0 Maximus
356.0 Commodus
357.0 Lucilla
358.0 Proximo
359.0 Marcus Aurelius
360.0 Juba
361.0 Harry Tasker
362.0 Helen Tasker
363.0 Albert Gibson
364.0
365.0 Spencer Trilby
366.0 Juno Skinner
367.0 Salim Abu Aziz
368.0 Dana Tasker
369.0 Amsterdam Vallon
370.0 Bill ‘The Butcher’ Cutting
371.0 Jenny Everdeane
372.0 Boss Tweed
373.0 Happy Jack
374.0 ‘Priest’ Vallon
375.0 Walter ‘Monk’ McGinn
376.0 Eversmann
377.0 Grimes
378.0 McKnight
379.0 Hoot
380.0 Korben Dallas
381.0 Jean-Baptiste Emanuel Zorg
382.0 Father Vito Cornelius
383.0 Leeloo
384.0 Ruby Rhod
385.0 Boromir
386.0
387.0
388.0
389.0
390.0 Gandalf the White
391.0
392.0
393.0
394.0
395.0
396.0
397.0
398.0
399.0
400.0
401.0
402.0
403.0
404.0 Eomer
405.0
406.0
407.0
408.0
409.0 Chief Inspector Lee
410.0 Detective James Carter
411.0 Varden Reynard
412.0 Kenji
413.0
414.0
415.0 Girl in Car
416.0
417.0
418.0
419.0
420.0 Dr. Laurel Weaver
421.0 William M. ‘Billy’ Costigan Jr.
422.0
423.0 Costello
424.0 Dignam
425.0 Queenan
426.0 Mr.

French
427.0 Ellerby
428.0
429.0 Simon Gruber
430.0 Zeus Carver
431.0 Jim Braddock
432.0 Mae Braddock
433.0 Joe Gould
434.0 Mike Wilson
435.0
436.0 Ward Abbott
437.0
438.0 Kirill
439.0 Kim
440.0 Jack Slater
441.0 John Practice
442.0 Death
443.0
444.0 Chuck Noland
445.0
446.0 Isabel Lahiri
447.0
448.0
449.0 Terry Benedict
450.0
451.0
452.0
453.0 Gaspar LeMarque
454.0 Michael Newman
455.0 Donna Newman
456.0 Morty
457.0 Ammer
458.0 Ted Newman
459.0 Bruce Nolan
460.0
461.0 Grace Connelly
462.0
463.0
464.0 Jim Phelps
465.0 Claire Phelps
466.0 Franz Krieger
467.0
468.0
469.0 Captain Spurgeon ‘Fish’ Tanner
470.0 Jenny Lerner
471.0 Leo Beiderman
472.0 Robin Lerner
473.0 President Tom Beck
474.0 Alan Rittenhouse
475.0 Dr. Gus Partenza
476.0 Michael Sullivan
477.0 John Rooney
478.0 Connor Rooney
479.0 Finn McGovern
480.0 Harlen Maguire
481.0 Frank Nitti
482.0 John Nash
483.0 Parcher
484.0 Alicia Nash
485.0 Dr. Rosen
486.0
487.0 Jasper
488.0 Theo Faron
489.0 Avner
490.0
491.0
492.0 Ephraim
493.0 Captain Steven Hiller
494.0 President Thomas J. Whitmore
495.0 David Levinson
496.0 First Lady Marilyn Whitmore
497.0 Russell Casse
498.0 Dr. Brackish Okun
499.0 Wolverine
500.0 Professor Charles Xavier
501.0 Magneto
502.0 Jean Grey
503.0
504.0 Toad
505.0
506.0
507.0
508.0
509.0
510.0 William Stryker
511.0 John Patrick Mason
512.0 Dr. Stanley Goodspeed
513.0 Brigadier General Francis X. Hummel
514.0 Commander Anderson
515.0 John

Constantine
516.0 Angela Dodson
517.0 Chas Kramer
518.0 Midnite
519.0 Satan
520.0 David Dunn
521.0 Elijah Price
522.0 Audrey Dunn
523.0 Lucius Washington
524.0 Ricky Bobby
525.0 Cal Naughton, Jr.
526.0 Jean Girard
527.0 Homer
528.0 Bart
529.0 Marge
530.0 Lisa
531.0 William Wallace
532.0 Argyle Wallace
533.0 King Edward I
534.0 Princess Isabelle
535.0 Hamish Campbell
536.0 Anthony Swofford
537.0 Staff Sergeant Sykes
538.0 Lucius Hunt
539.0 Noah Percy
540.0 Edward Walker
541.0 Alice Hunt
542.0 August Nicholson
543.0 Shrek
544.0 Donkey
545.0 Puss in Boots
546.0
547.0
548.0
549.0
550.0
551.0 Princess Fiona
552.0
553.0 Virgil ‘Bud’ Brigman
554.0 Lindsey Brigman
555.0 Lt. Hiram Coffey
556.0 Captain Jean-Luc Picard
557.0 Commander William T. Riker
558.0 Lt. Commander Data
559.0 Lt. Commander Geordi La Forge
560.0 Lt. Commander Worf
561.0 Dr. Beverly Crusher
562.0 Commander Deanna Troi
563.0 Ad’har Ru’afo
564.0 Eddie Valiant
565.0 Judge Doom
566.0 Jessica Rabbit
567.0 Dipped Shoe
568.0 Ichabod Crane
569.0 Katrina Van Tassel
570.0 Baltus Van Tassel
571.0 Doctor Lancaster
572.0 Hessian Horseman
573.0 Burgomaster
574.0 Xander Cage
575.0 Agent Augustus Gibbons
576.0
577.0 Holly McClane
578.0 Colonel Stuart
579.0 O’Reilly
580.0 Samantha Caine
581.0 Mitch Henessey
582.0 Dr. Nathan Waldman
583.0 Jim Lovell
584.0 Fred Haise
585.0 Jack Swigert
586.0 Ken Mattingly
587.0 Gene Kranz
588.0 114.0 Captain John H. Miller
589.0 Sergeant Mike Horvath
590.0 Private Adrian Caparzo
591.0 Private James Francis Ryan
592.0 Sergeant Hill
593.0 The Narrator
594.0 Tyler Durden
595.0 Marla Singer
596.0 116.0
597.0
598.0
599.0
600.0 Douglas Quaid
601.0 Laurel Hedare
602.0 Catherine Tramell
603.0 Lori
604.0 Richter
605.0 Gabe Walker
606.0 Eric Qualen
607.0 Hal Tucker
608.0 Jack Ryan
609.0 John Clark
610.0 120.0
611.0 Alec Trevelyan
612.0 Xenia Zirgavna Onatopp
613.0
614.0
615.0
616.0
617.0 121.0 Dwight ‘Bucky’ Bleichert
618.0 Kay Lake
619.0 Madeleine Linscott
620.0 Truman Burbank
621.0 Christof
622.0 Control Room Director
623.0 Captain Miller
624.0 Dr. William Weir
625.0 Peters, Med Tech
626.0 Marilyn Lovell
627.0 Lt. Starck
628.0
629.0 124.0
630.0 The Professor
631.0
632.0
633.0 125.0 Hellboy
634.0 Trevor ‘Broom’ Bruttenholm
635.0 Liz Sherman
637.0 Ken Hutchinson
638.0 David Starsky
639.0 Huggy Bear
640.0 Captain Doby
641.0 Reese Feldman
642.0 Kitty
643.0 Manetti
644.0 Disco DJ
645.0 Miles
646.0 Marylin
647.0 Donovan Donaly
648.0 Howard D. Doyle
649.0 Faramir
650.0
651.0 King Leonidas
652.0 Queen Gorgo
653.0 Theron
654.0 Dilios
655.0 129.0
656.0
657.0
658.0
659.0
660.0
661.0
662.0 The Reman Viceroy
663.0
664.0
665.0
666.0
667.0
668.0
669.0
670.0 Dr. Zefram Cochrane
671.0
672.0
673.0
674.0
675.0
676.0
677.0
678.0 Captain James T. Kirk
679.0 Dr. Tolian Soran
680.0 Captain Montgomery “Scotty” Scott
681.0 Commander Pavel Chekov
682.0 Admiral James T. Kirk
683.0 Captain Spock
684.0 Dr. Leonard “Bones” McCoy
685.0 Commander Montgomery “Scotty” Scott
686.0
688.0 Commander Hikaru Sulu
689.0 Commander Uhura
690.0 Khan
700.0
701.0 Lt. Pavel Chekov
702.0 Lt. Commander Hikaru Sulu
703.0 Lt. Commander Uhura
704.0
705.0 Mr Spock
706.0
708.0 Commander Kruge
709.0
710.0
711.0
712.0
713.0
714.0
715.0
716.0
717.0
718.0
719.0
720.0
721.0
722.0
723.0
724.0
725.0
726.0
727.0
728.0
729.0 Captain Hikaru Sulu
730.0 General Chang
731.0 Colonel Worf
732.0 Excelsior Communications Officer
733.0
734.0
735.0
736.0
737.0
738.0
739.0
740.0
741.0 Jor-El
742.0
743.0
744.0 Lt. Commander Ron Hunter
745.0 Captain Frank Ramsey
746.0 Lt. Peter ‘WEAPS’ Ince
747.0 Lt. Bobby Dougherty
748.0 132.0 Agent Doug Carlin
749.0 Agent Paul Pryzwarra
750.0 Carroll Oerstadt
751.0 133.0 Creasy
752.0 Pita
753.0 Rayburn
754.0 134.0 Robert Clayton Dean
755.0 Brill
756.0 Reynolds
757.0 Fiedler
758.0 Boss Paulie Pintero
759.0 The Bride
760.0 O-Ren Ishii
761.0 Elle Driver
762.0
763.0 Budd
764.0 Ellen Ripley
765.0 Dillon
766.0 Clemens
767.0
768.0 137.0 Chon Wang
769.0 Roy O’Bannon
770.0 Princess Pei Pei
771.0 138.0
772.0
773.0
774.0
775.0
776.0 Rufus
777.0 Blade
778.0 Abraham Whistler
779.0 Reinhardt
780.0 Snowman
781.0 John “Doc” Bradley
782.0 Colonel Chandler Johnson
783.0 Sam ‘Ace’ Rothstein
784.0 Ginger McKenna
785.0 Nicky Santoro
786.0 Lester Diamond
787.0 Robin of Locksley
788.0 Azeem
789.0 Marian Dubois
790.0 Will Scarlett
791.0 Sheriff of Nottingham
792.0 King Richard
793.0
794.0
795.0
796.0 Lord Farquaad
797.0 144.0
798.0
799.0 Wu Chow
800.0 145.0 Indiana Jones
801.0 Professor Henry Jones
802.0 Sallah
803.0 Gimli
804.0
805.0
806.0
807.0
808.0 Deacon Frost
809.0
810.0 Sean Miller
811.0 Lt. Cmdr. Robby Jackson
812.0 Paddy O’Neil
813.0 Admiral James Greer
814.0 Dr. Richard David Kimble
815.0 Marshal Samuel Gerard
816.0 Dr. Anne Eastman
817.0 Deputy Marshal Cosmo Renfro
818.0 Robert Angier
819.0 Alfred Borden
820.0 Cutter
821.0 Olivia Wenscombe
822.0 Alley
823.0 151.0 Hawkeye
824.0 Cora Munro
825.0 China
826.0 Magua
827.0 152.0 Jaguar Paw
828.0 Seven
829.0 John Beckwith
830.0 Jeremy Grey
831.0 Secretary William Cleary
832.0 Claire Cleary
833.0 Gloria Cleary
834.0 Kathleen Cleary
835.0 Marty McFly
836.0 Dr. Emmett Brown
837.0 Buford ‘Mad Dog’ Tannen
838.0
839.0
840.0 Biff Tannen
841.0
842.0 Dario
843.0
844.0
845.0 Felix Leiter
U 1

2

12 3

4

15 5
18 6

7

CertificateName CertificateID
PG
12A
Unknown
48 China
79

118

167

240

241

257

y

258

CountryId CountryName
France
Japan
New Zealand
United Kingdom
United States
German
Russia
4

2

5

2

6

2

7

2

8

2

9

2

10

2

11

2

12

2

14

2

15

2

16

2

17

2

18

2

19

2

20

2

21

2

22

2

23

2/1/00 2

24

2

25

2

26

2

27

2

28

2

29

2

30

2

31

2

32

2

33

2

34

2

35

2

36

2

37

2

38

2

39

2

40

2

41

2

42

2

43

2

44

2

45

2

46

2

47

2

48

2

49

2

50

2

51

2

52

2

53

2

54

2

55

2

56

2

57

2

58

2

59

2

60

1

61

2

62

2

63

2/1/00 2

64

2

65 Mel Gibson

2

66

2/1/00 2

67

2

68

8/19/52 2

69

2

70

2

71

2

72

2

73

2

74

2

75

2

76

2

77

2

78

2

79

2

80

2/1/00 2

81

2/1/00 2

82

2/1/00 2

83

2

84

2

85

2

86

2

87

2/1/00 2

88

2

89

2

90

2

91

2

92

2

93

2/1/00 2

94

2

95 William Shatner 3/22/31 2
96

2

97

2

98 Kevin Costner 1/18/55 2
99 Leonard Nimoy 3/26/31 2
100

2

101 Richard Attenborough 8/29/23 2
102

2/1/00 2

103

2

104

2

105

2

106

2

107 Ang Lee 10/23/54 2
108

2

109

2

110

2

111

2

112

2

113

2

114

2

115

2

116 George Clooney 5/6/61 2
117

2

118 Sammo Hung 1/7/52 2
119

2

120

2

121

2/1/00 2

122

2

123

2

124

2

125

1

DirectorId DirectorName DirectorDob DirectorGenderId
Steven Spielberg 12/18/46
Joel Coen 11/29/54
Ethan Coen 9/21/57
George Lucas 5/14/44
Ang Lee 10/23/54
Martin Scorsese 11/17/42
Clint Eastwood 5/31/30
Sam Raimi 10/23/59
Peter Jackson 10/31/61
Bryan Singer 9/17/65
James Cameron 8/16/54
Tom Shadyac 12/11/58
Kevin Reynolds 1/17/52
Michael Bay 2/17/65
David Yates 11/30/63
Robert Zemeckis 5/14/52
Steve Hickner 2/1/00
Gore Verbinski 3/16/64
Francis Lawrence
Brad Bird 9/11/57
Wolfgang Peterson 3/14/41
Mike Newell 3/28/42
Christopher Nolan 7/30/70
Tim Burton 8/25/58
Lee Tamahori 6/17/50
Richard Donner 4/24/30
Barry Sonnenfeld 4/1/53
Rob Cohen 3/12/49
Hironobu Sakaguchi 11/14/62
Michael Mann 2/5/43
Michael Apted 2/10/41
Peter Weir 8/21/44
Paul Greengrass 8/13/55
Alfonso Cuaron 11/28/61
Andy Wachowski 12/29/67
Ron Howard 3/1/54
Chris Columbus 9/10/58
Roland Emmerich 11/10/55
Edward Zwick 10/8/52
J. J. Abrams 6/27/66
John Woo 9/23/46
Pete Docter 8/10/68
Roger Spottiswoode 1/5/45
Steven Soderbergh 1/14/63
Len Wiseman 3/4/73
Frank Coraci 2/3/66
Ridley Scott 11/30/37
Doug Liman 7/24/65
Alex Proyas 9/23/63
Martin Campbell 10/24/40
Jean-Christophe Comar 7/4/57
Luc Besson 3/18/59
Brett Ratner 3/28/69
John McTiernan 1/8/51
Brian De Palma 9/11/40
Mimi Leder 1/26/52
Sam Mendes 8/1/65
M. Night Shyamalan 8/6/70
Adam McKay
David Silverman 3/15/57
1/3/56
Chris Miller
Andrew Adamson 12/1/66
Jonathon Frakes
Renny Harlin 3/15/59
David Fincher 8/28/62
Guillermo del Toro 10/9/64
Paul Verhoeven 7/18/38
Phillip Noyce 4/29/50
Paul Anderson 3/4/65
Todd Phillips 12/20/70
Zack Snyder 3/1/66
Stuart Baird 11/30/47
Tony Scott 6/21/44
Quentin Tarantino 3/27/63
Tom Dey
David Dobkin
Stephen Norrington
Andrew Davis 11/21/46
John Glen 5/15/32
Frank Miller 1/27/57
Joss Whedon 6/23/64
David Carson
Irvin Kershner 4/29/23
Robert Wise 9/10/14
Richard Marquand 4/22/38
David Cronenberg 3/15/43
Lewis Gilbert 3/6/20
Andrew Dominik
Ivan Reitman 10/27/46
Nicholas Meyer 12/24/45
Paul Michael Glaser 3/25/43
John Guillermin 11/11/25
Kurt Wimmer
Robert Rodriguez 6/20/68
Larry Charles 2/20/56
Yimou Zhang 11/14/51
Edgar Wright 4/18/74
Danny Boyle 10/20/56
Oliver Hirschbiegel 12/29/57
Val Guest 12/11/11
Jean-Pierre Jeunet 9/3/53
Terence Young 6/20/15
Peter R. Hunt 3/11/25
Stanley Tong 4/7/60
Guy Hamilton 9/16/22
Michael Anderson 1/30/20
Timur Bekmambetov 6/25/61
Florian Henckel von Donnersmarck 5/2/73
Merian C. Cooper
Akira Kurosawa 10/23/10
Morgan Spurlock 11/7/70
Oliver Owl 1/1/70
Wendy Wise 2/1/71
FilmID

34.0

115.0

3.0 3.0 37 1 241 1 4

35.0

141.0 1.3E8

2.0 0.0 38 1 240 6 2

36.0

Reloaded

138.0

0.0 0.0 39 1 241 6 5

37.0

149.0

0.0 0.0 40 1 241 5 4

38.0

152.0 1.25E8

3.0 0.0 41 1 240 6 2

39.0

124.0 1.25E8

0.0 0.0 42 1 241 4 4

40.0

143.0 1.25E8

5.0 0.0 22 1 241 3 3

41.0

154.0

4.0 0.0 43 1 241 6 5

42.0

130.0 1.2E8

2.0 0.0 25 1 241 6 3

43.0

II

I

126.0

0.0 0.0 44 1 241 2 4

44.0 Mission: Impossible II

123.0 1.2E8

0.0 0.0 45 1 241 2 5

45.0

134.0

0.0 0.0 45 1 241 11 5

46.0

142.0 1.15E8

1.0 0.0 7 1 241 13 2

47.0

92.0 1.15E8

3.0 1.0 46 1 241 10 1

48.0

133.0 1.15E8

3.0 0.0 7 1 241 13 1

49.0

140.0 1.15E8

1.0 0.0 7 1 241 13 4

50.0

129.0

0.0 0.0 39 1 241 6 5

51.0

119.0 1.1E8

0.0 0.0 47 1 240 11 3

52.0

116.0 1.1E8

0.0 0.0 48 1 241 6 3

53.0

130.0 1.1E8

0.0 0.0 49 1 241 4 5

54.0

120.0 1.1E8

0.0 0.0 50 1 241 3 2

55.0

145.0 1.1E8

0.0 0.0 51 1 241 4 5

56.0

120.0 1.1E8

0.0 0.0 52 1 241 4 5

57.0

170.0 1.1E8

11.0 5.0 9 1 241 6 4

58.0 Ali

157.0

0.0 0.0 34 1 241 5 5

59.0

1.09E8

13.0 4.0 12 1 167 14 2

60.0

115.0

1.0 0.0 53 1 241 4 4

61.0

Royale

in Montenegro.

144.0

0.0 0.0 54 1 240 11 4

62.0

145.0 1.02E8

1.0 0.0 4 1 241 8 3

63.0

137.0

4.0 6.0 15 1 241 15 5

64.0

104.0 1.0E8

0.0 0.0 55 1 241 6 4

65.0

161.0 1.0E8

0.0 0.0 41 1 240 6 2

66.0

157.0 1.0E8

2.0 0.0 51 1 241 1 6

67.0

143.0 1.0E8

5.0 0.0 43 1 241 6 5

68.0

155.0

12.0 5.0 51 1 241 8 5

69.0

141.0 1.0E8

1.0 0.0 15 1 241 4 5

70.0

167.0

10.0 0.0 9 1 241 16 6

71.0

144.0

4.0 2.0 51 1 241 17 5

72.0

126.0 9.5E7

1.0 0.0 56 1 79 18 2

73.0

201.0

11.0 11.0 12 1 167 14 4

74.0

179.0 9.4E7

6.0 2.0 12 1 167 14 4

75.0

3

91.0

0.0 0.0 57 1 241 14 4

76.0

90.0

0.0 0.0 57 1 241 14 3

77.0

98.0 9.0E7

3.0 1.0 31 1 241 5 2

78.0

151.0 9.0E7

5.0 4.0 9 1 241 6 6

79.0

131.0 9.0E7

0.0 0.0 58 1 241 4 5

80.0

144.0

3.0 0.0 40 1 241 1 4

81.0

8/13/04

108.0

0.0 0.0 37 1 241 1 4

82.0

130.0 8.5E7

0.0 0.0 58 1 241 5 5

83.0

143.0 8.5E7

2.0 0.0 20 1 241 8 3

84.0

125.0 8.5E7

0.0 0.0 48 1 241 6 4

85.0

107.0

1.0 0.0 50 1 241 5 4

86.0

101.0

0.0 0.0 16 1 241 1 4

87.0 Mission: Impossible

110.0

0.0 0.0 59 1 241 2 2

88.0

120.0 8.0E7

0.0 0.0 60 1 241 2 3

89.0

117.0 8.0E7

6.0 1.0 61 1 241 8 5

90.0

2/22/02

135.0

8.0 4.0 40 1 241 1 3

91.0

109.0

3.0 0.0 38 1 241 1 5

1.0

127.0

3.0 3.0 4 1 241 1 2

2.0

121.0

2.0 0.0 11 1 241 5 4

3.0

4.0 3.0 12 1 241 1 4

5.0

Returns

154.0

1.0 0.0 14 1 241 6 4

6.0

194.0

14.0 11.0 15 1 241 4 3

7.0

95.0

0.0 0.0 16 1 241 1 2

8.0

136.0 1.75E8

1.0 0.0 17 1 241 1 3

9.0

4.0 1.0 18 1 241 7 3

92.0

164.0

5.0 0.0 4 1 241 8 5

93.0

145.0 7.5E7

2.0 1.0 42 1 241 4 3

94.0

104.0 7.5E7

0.0 0.0 14 1 241 4 3

95.0

133.0 1.25E8

0.0 0.0 14 1 241 4 4

96.0

136.0 7.5E7

1.0 0.0 18 1 241 17 5

97.0 Constantine

121.0 7.5E7

0.0 0.0 23 1 241 6 5

98.0

106.0

0.0 0.0 62 1 241 7 3

99.0

108.0

0.0 0.0 63 1 241 5 4

100.0

87.0

0.0 0.0 64 1 241 4 2

101.0

rule.

177.0

10.0 5.0 65 1 241 2 5

102.0

125.0 7.2E7

0.0 0.0 61 1 241 1 5

103.0

108.0

1.0 0.0 62 1 241 7 4

104.0

92.0

0.0 0.0 66 1 241 8 1

105.0

93.0

2.0 0.0 67 1 241 8 1

106.0

138.0 7.0E7

4.0 1.0 15 1 241 4 5

10.0

144.0

3.0 0.0 18 1 241 8 4

11.0

138.0 1.5E8

0.0 0.0 19 1 240 6 4

12.0 Beowulf 11/16/07

113.0 1.5E8

0.0 0.0 20 1 241 2 4

13.0

90.0 1.5E8

0.0 0.0 21 1 241 8 1

14.0

168.0 1.5E8

2.0 0.0 22 1 241 3 4

15.0

101.0 1.5E8

0.0 0.0 23 1 241 6 5

16.0

106.0 1.5E8

5.0 1.0 24 1 241 10 1

17.0

163.0 1.5E8

1.0 0.0 25 1 241 6 5

18.0

157.0 1.5E8

1.0 0.0 26 1 241 6 4

19.0

140.0 1.5E8

1.0 0.0 27 1 241 6 4

20.0

115.0 1.5E8

1.0 0.0 28 1 241 6 2

21.0

150.0 1.5E8

4.0 1.0 22 1 241 3 4

22.0

133.0

0.0 0.0 29 1 240 11 4

23.0

4

127.0

0.0 0.0 30 1 241 6 5

24.0

150.0 1.4E8

4.0 0.0 18 1 241 7 3

25.0

88.0 1.4E8

0.0 0.0 31 1 241 5 2

26.0

139.0

0.0 0.0 11 1 241 5 4

27.0

127.0 2.0E8

3.0 1.0 11 1 241 5 4

28.0

121.0

0.0 0.0 32 1 241 5 4

29.0

8/3/01

106.0

0.0 0.0 33 1 118 12 7

30.0

134.0

0.0 0.0 34 1 241 1 7

31.0

128.0 1.35E8

0.0 0.0 35 1 240 11 3

32.0

138.0 1.35E8

10.0 2.0 36 1 241 4 4

33.0

116.0

3.0 0.0 4 1 241 2 4

107.0

103.0 7.0E7

0.0 0.0 68 1 241 2 2

108.0

104.0 7.0E7

0.0 0.0 20 1 241 7 2

109.0

105.0 7.0E7

3.0 1.0 28 1 241 2 5

110.0

124.0 7.0E7

0.0 0.0 32 1 241 19 5

111.0

124.0 7.0E7

0.0 0.0 69 1 241 4 5

112.0

120.0

0.0 0.0 0.0 69 1 241 14 6

113.0

140.0 6.5E7

9.0 2.0 40 1 241 1 2

114.0

170.0 6.5E7

11.0 5.0 4 1 241 8 5

115.0

139.0 6.5E7 0.0 1.0 0.0 70 1 241 4 6

116.0 The Matrix

136.0 6.5E7

4.0 4.0 39 1 241 6 5

117.0

113.0 6.5E7

2.0 0.0 72 1 241 15 6

118.0

113.0 6.5E7

0.0 0.0 69 1 241 15 5

119.0

141.0

2.0 0.0 73 1 241 2 3

120.0

research center to stop the hijacking of a nuclear space weapon by a fellow agent believed to be dead.

130.0

0.0 0.0 54 1 240 11 3

121.0

9/15/06

121.0 6.0E7

1.0 0.0 59 1 241 1 5

122.0

103.0 6.0E7

3.0 0.0 36 1 241 2 2

123.0

96.0 6.0E7

0.0 0.0 74 1 241 2 6

124.0

119.0 6.0E7

0.0 0.0 52 1 241 1 4

125.0 Hellboy

122.0 6.0E7

0.0 0.0 71 1 241 19 4

126.0

101.0 6.0E7

0.0 0.0 75 1 241 6 5

127.0

100.0 6.0E7

0.0 0.0 5 1 241 20 4

128.0 300

117.0 6.0E7

0.0 0.0 76 1 241 6 5

129.0

116.0 6.0E7

0.0 0.0 77 1 241 2 4

130.0 Superman

143.0

3.0 0.0 30 1 241 6 2

131.0

116.0 5.5E7

3.0 0.0 78 1 241 17 5

132.0

126.0 8.0E7

0.0 0.0 78 1 241 7 4

133.0

146.0 6.0E7

0.0 0.0 78 1 241 4 6

134.0

132.0 8.5E7

0.0 0.0 78 1 241 7 5

135.0

111.0 5.5E7

0.0 0.0 79 1 241 16 6

136.0

3

114.0 5.5E7

1.0 0.0 70 1 241 4 6

137.0

110.0 5.5E7

0.0 0.0 80 1 241 7 3

138.0

136.0 5.5E7

0.0 0.0 79 1 241 16 6

139.0

117.0

0.0 0.0 71 1 241 14 6

140.0

132.0

2.0 0.0 10 1 241 8 5

141.0 Casino

178.0

1.0 0.0 9 1 241 1 6

142.0

143.0

1.0 0.0 17 1 241 6 2

143.0 Shrek

90.0 5.0E7

2.0 1.0 67 1 241 8 1

144.0

114.0 5.0E7 0.0 0.0 0.0 81 1 241 7 4

145.0

127.0

3.0 1.0 4 1 241 13 2

146.0

111.0

1.5E8 1.0 0.0 68 1 241 2 3

147.0 Blade

120.0

0.0 0.0 82 1 241 14 6

148.0

117.0 4.5E7

0.0 0.0 73 1 241 2 5

149.0

130.0

7.0 1.0 83 1 241 6 3

150.0

130.0

2.0 0.0 27 1 241 7 4

151.0

112.0 4.0E7 0.0 1.0 1.0 34 1 241 21 3

152.0

kingdom faces its decline, the rulers insist the key to prosperity is to build more temples and offer human sacrifices. Jaguar Paw, a young man captured for sacrifice, flees to avoid his fate.

139.0 4.0E7

3.0 0.0 65 8 241 7 6

153.0

119.0 4.0E7

0.0 0.0 81 1 241 14 5

154.0

Part II

I

118.0 4.0E7

0.0 0.0 20 1 241 1 2

155.0 Back to the Future Part II

108.0 4.0E7

1.0 0.0 20 1 241 1 2

156.0

133.0

0.0 0.0 84 1 240 22 7

157.0

130.0 4.0E7

0.0 0.0 84 1 240 22 7

158.0

124.0 4.0E7

0.0 0.0 85 1 241 23 7

159.0

119.0

0.0 0.0 86 1 241 1 7

160.0

118.0

1.2E8 0.0 0.0 87 1 241 2 2

161.0

134.0

1.6E8 0.0 0.0 88 1 241 6 7

162.0

132.0

1.39E8 3.0 0.0 89 1 241 2 1

163.0 Rush Hour

97.0 3.5E7

0.0 0.0 57 1 241 14 7

164.0

118.0 3.5E7

0.0 0.0 30 1 241 6 7

165.0

134.0

4.0 0.0 90 1 241 13 7

166.0

96.0

2.0 0.0 91 1 241 14 7

167.0

126.0

1.0 0.0 92 1 240 22 7

168.0

105.0

0.0 0.0 31 1 241 11 7

169.0

160.0

2.0 0.0 93 1 241 6 7

170.0

132.0 3.0E7

7.0 4.0 10 1 241 6 7

171.0

127.0 3.0E7

1.0 0.0 70 1 241 14 7

134.0 3.0E7

3.0 1.0 58 1 241 2 7

105.0 3.0E7

0.0 0.0 94 1 241 5 7

174.0

107.0 3.0E7

0.0 0.0 95 1 241 2 7

118.0

2.0 1.0 4 1 241 13 7

176.0

117.0 2.8E7

2.0 0.0 51 1 241 6 7

177.0 Die Hard

131.0 2.8E7

4.0 0.0 58 1 241 4 7

178.0

127.0 2.8E7

1.0 0.0 84 1 240 22 7

179.0

131.0

0.0 0.0 84 1 241 11 7

180.0

113.0

0.0 0.0 96 1 241 2 2

181.0

101.0 2.7E7

0.0 0.0 97 1 241 24 7

182.0

3/19/04

139.0

0.0 0.0 98 1 241 7 7

183.0

111.0 2.6E7

0.0 0.0 94 1 241 1 7

107.0 2.6E7

2.0 0.0 5 1 241 7 7

145.0

6.0 1.0 9 1 241 6 7

127.0 2.5E7

3.0 0.0 65 7 241 25 7

187.0

119.0 2.5E7

4.0 1.0 59 1 241 2 7

195.0 2.5E7

12.0 7.0 4 1 241 1 7

94.0 2.5E7

0.0 0.0 63 1 241 8 7

190.0

170.0 2.5E7

0.0 0.0 59 1 241 1 7

191.0

119.0

0.0 0.0 99 1 241 2 2

192.0 King Kong

134.0

2.0 0.0 100 1 241 2 7

193.0

124.0 2.3E7

3.0 1.0 88 1 241 13 7

194.0

188.0

11.0 8.0 101 1 240 26 7

195.0

107.0

0.0 0.0 102 1 241 23 7

196.0

108.0 2.0E7

0.0 0.0 103 1 241 23 7

197.0

115.0 2.0E7

8.0 4.0 4 1 241 13 7

199.0 Back to the Future

117.0

4.0 1.0 20 1 241 1 7

200.0

180.0 1.9E7

12.0 7.0 98 1 241 27 7

201.0

105.0

0.0 0.0 99 1 241 2 2

202.0

84.0 1.8E7

1.0 0.0 104 1 241 28 7

203.0

129.0 1.8E7

8.0 2.0 9 1 241 22 7

204.0

137.0

7.0 2.0 15 1 241 4 7

205.0 Hero

99.0 1.7E7

1.0 0.0 105 5 48 29 7

206.0

2/14/07

121.0

0.0 0.0 106 1 240 30 7

207.0 Leon

110.0 1.6E7

0.0 0.0 56 1 79 18 7

208.0

105.0

1.57E7 0.0 0.0 10 1 241 31 7

209.0

120.0 6.0E7

2.0 0.0 34 1 241 2 7

210.0

122.0

8.0 5.0 61 1 241 8 7

211.0 Lethal Weapon

110.0 1.5E7

1.0 0.0 30 1 241 6 7

212.0

114.0 2.5E7

0.0 0.0 30 1 241 6 7

213.0

120.0 1.5E7

10.0 4.0 8 5 48 5 7

214.0

1/13/06

134.0

8.0 3.0 8 1 241 2 7

215.0

138.0 1.37E8

0.0 0.0 8 1 241 1 7

216.0

2/23/96

136.0

7.0 1.0 8 1 240 5 7

217.0

138.0 3.5E7

0.0 0.0 8 1 241 1 7

218.0

105.0 1.5E7

0.0 0.0 94 1 241 1 7

219.0

113.0 1.5E7

0.0 0.0 108 1 240 32 7

220.0

119.0 5.0E7

0.0 0.0 108 1 240 4 7

221.0

2/23/96

94.0

1.0 0.0 108 1 240 33 7

222.0

125.0

3.0 0.0 92 1 240 22 7

223.0

156.0

1.0 0.0 109 4 257 34 7

224.0

who fought it.

141.0

4.0 1.0 10 6 241 8 7

225.0

113.0

0.0 0.0 96 1 241 2 3

226.0

1/14/05

119.0 1.2E7

1.0 0.0 105 5 48 29 7

227.0

149.0 1.2E7

6.0 0.0 25 4 257 7

228.0 Casino Royale

131.0 1.2E7

1.0 0.0 110 1 240 5 7

229.0

121.0

10.0 6.0 7 1 241 13 7

230.0

115.0

9.0 4.0 4 1 241 1 7

231.0

122.0

5.0 0.0 111 3 79 16 7

232.0

117.0

0.0 0.0 92 1 241 22 7

233.0

130.0

1.0 1.0 112 1 240 22 7

234.0 Alien

117.0 9000000.0

2.0 1.0 51 1 241 4 7

236.0

140.0

0.0 0.0 113 1 240 22 7

237.0

154.0 8000000.0

7.0 1.0 79 1 241 16 7

238.0

104.0

0.0 0.0 114 2 48 14 7

239.0

120.0

1.0 0.0 115 1 240 22 7

240.0

5/31/96

98.0

7.0 2.0 5 1 241 4 7

241.0

121.0 7000000.0

1.0 0.0 115 1 240 22 7

242.0

125.0 7000000.0

0.0 0.0 115 1 240 22 7

243.0

93.0 7000000.0

6.0 0.0 116 1 241 6 7

244.0

116.0

0.0 0.0 10 1 241 31 7

245.0 The Terminator

108.0

0.0 0.0 15 1 241 11 7

246.0 Around the World in 80 Days

167.0 0.0 0.0 8.0 5.0 117 1 241 22 7

249.0

106.0

2.0 2.0 14 1 241 11 7

250.0

113.0

2.0 0.0 27 1 241 5 7

251.0

99.0 5000000.0

0.0 0.0 106 1 240 33 7

252.0

117.0

2.0 0.0 26 1 240 33 7

253.0

10/7/05

114.0

0.0 0.0 119 9 258 4 7

254.0

1/9/65

110.0

1.0 1.0 115 1 241 22 7

255.0

137.0

1.0 1.0 120 4 257 36 7

256.0

110.0 2000000.0

0.0 0.0 112 1 240 22 7

257.0

99.0

0.0 0.0 79 1 241 16 7

258.0

110.0

0.0 0.0 112 1 240 22 7

259.0 King Kong

100.0

0.0 0.0 121 1 241 37 7

260.0

190.0 500000.0

2.0 0.0 122 6 118 38 7

261.0

9/10/04

100.0

1.0 0.0 123 1 241 39 7

262.0

179.0 0.0 0.0 2.0 0.0 122 6 118 38 7

263.0 Ran

160.0 1.2E7 0.0 4.0 1.0 122 6 118 38 7

264.0

107.0 4.0E7

0.0 0.0 108 1 240 4 5

265.0

99.0 1000000.0 0.0 0.0 0.0 29 1 167 40 6

FilmName FilmReleaseDate FilmSynopsis FilmRunTimeMinutes FilmBudgetDollars FilmBoxOfficeDollars FilmOscarNominations FilmOscarWins FilmDirectorID FilmLanguageID FilmCountryID FilmStudioID FilmCertificateID
The Bourne Ultimatum 8/17/07 Bourne dodges new, superior assassins as he searches for his unknown past while a government agent tries to track him down. 1.3E8 4.42748521E8
Harry Potter and the Prisoner of Azkaban 5/31/04 It’s Harry’s third year at Hogwarts; not only does he have a new “Defense Against the Dark Arts” teacher, but there is also trouble brewing. Convicted murderer Sirius Black has escaped the Wizards’ Prison and iscomingafter Harry. 7.95538952E8
The Matrix 5/21/03 Neo and the rebel leaders estimate that they have 72 hours until 250,000 probes discover Zion and destroy it and its inhabitants. During this, Neo must decide how he can save Trinity from a dark fate in his dreams. 1.27E8 7.38576929E8
The Da Vinci Code 5/19/06 A murder inside the Louvre and clues in Da Vinci paintings lead to the discovery of a religious mystery protected by a secret society for two thousand years — which could shake the foundations of Christianity. 1.25E8 7.57536138E8
Harry Potter and the Philosopher’s Stone 11/16/01 Rescued from the outrageous neglect of his aunt and uncle, a young boy with a great destiny proves his worth while attending Hogwarts School of Witchcraft and Wizardry. 9.76457891E8
The Day After Tomorrow 5/27/04 A climatologist tries to figure out a way to save the world from abrupt global warming. He must get to his young son in New York, which is being taken over by a new ice age. 5.42740799E8
Pirates of the Caribbean:Curse of the Black Pearl 8/8/03 Blacksmith Will Turner teams up with eccentric pirate “Captain” Jack Sparrow to save his love, the governor’s daughter, from Jack’s former pirate allies, who are now undead. 6.55011224E8
The Last Samurai 1/9/04 An American military advisor embraces the Samurai culture he was hired to destroy after he is captured in battle. 1.2E8 4.56810575E8
The Perfect Storm 7/28/00 An unusually intense storm pattern catches some commercial fishermen unaware and puts them in mortal danger. 3.28711434E8
Mission: Impossible 5/4/06 Ethan Hunt comes face to face with a dangerous and sadistic arms dealer while trying to keep his identity secret in order to protect his girlfriend. 1.5E8 3.97501348E8
7/7/00 A secret agent is sent to Sydney, to find and destroy a genetically modified disease called “Chimera” 5.46209889E8
Windtalkers 8/30/02 Two U.S. Marines in WWII are assigned to protect Navajo Marines who use their native language as an unbreakable radio cypher. 1.15E8 7.7628265E7
Star Wars: Episode II – Attack of the Clones 5/16/02 Anakin Skywalker shares a forbidden romance with Padmé Amidala while his teacher, Obi-Wan Kenobi, makes an investigation of a separatist assassination attempt on Padmé which leads to the discovery of a secret Republican clone army. 6.56695615E8
Monsters, Inc. 2/8/02 Monsters generate their city’s power by scaring children, but they are terribly afraid themselves of being contaminated by children, so when one enters Monstropolis, top scarer Sulley find his world disrupted. 5.25370172E8
Star Wars: Episode I – The Phantom Menace 7/16/99 The evil Trade Federation, led by Nute Gunray (Carson) is planning to take over the peaceful world of Naboo. 9.24288297E8
Star Wars: Episode III – Revenge of the Sith 5/19/05 After three years of fighting in the Clone Wars, Anakin Skywalker concludes his journey towards the Dark Side of the Force, putting his friendship with Obi Wan Kenobi and his marriage at risk. 8.48470577E8
The Matrix Revolutions 11/5/03 The human city of Zion defends itself against the massive invasion of the machines as Neo fights to end the war at another front while also opposing the rogue Agent Smith. 1.1E8 4.24259759E8
Tomorrow Never Dies 12/12/97 James Bond heads to stop a media mogul’s plan to induce war between China and the UK in order to obtain exclusive global media coverage. 3.39504276E8
Ocean’s Eleven 2/15/02 Danny Ocean and his ten accomplices plan to rob three Las Vegas casinos simultaneously. 4.50728529E8
Live Free or

Die Hard 7/4/07 John McClane takes on an Internet-based terrorist organization who is systematically shutting down the United States. 3.83277179E8
Around the World in 80 Days 7/9/04 A bet pits a British inventor, a Chinese thief, and a French artist on a worldwide adventure that they can circle the globe in 80 days. 7.2004159E7
Kingdom of Heaven 5/6/05 Balian of Ibelin travels to Jerusalem during the crusades of the 12th century, and there he finds himself as the defender of the city and its people. 2.11398413E8
Mr. and Mrs. Smith 6/10/05 A bored married couple is surprised to learn that they are both assassins hired by competing agencies to kill each other. 4.68336279E8
The Aviator 1/6/05 A biopic depicting the early years of legendary director and aviator Howard Hughes’ career, from the late 1920s to the mid-1940s. 2.14608827E8
2/22/02 A biography of sports legend, Muhammad Ali, from his early days to his days in the ring 1.09E8 8.53E7
The Lord of the Rings: Fellowship of the Ring 12/19/01 In a small village in the Shire a young Hobbit named Frodo has been entrusted with an ancient Ring. Now he must embark on an Epic quest to the Cracks of Doom in order to destroy it. 178.0 8.68621686E8
I, Robot 8/6/04 In the year 2035 a techno-phobic cop investigates a crime that may have been perpetrated by a robot, which leads to a larger threat to humanity. 1.05E8 3.48801023E8
Casino 11/16/06 In his first mission, James Bond must stop Le Chiffre, a banker to the world’s terrorist organizations, from winning a high-stakes poker tournament at

Casino Royale 1.02E8 5.94165E8
Minority Report 7/4/02 In the future, criminals are caught before the crimes they commit, but one of the officers in the special unit is accused of one such crime and sets out to prove his innocence. 3.58814112E8
Terminator 2: Judgement Day 8/16/91 The cyborg who once tried to kill Sarah Connor must now protect her teenager son, John Connor, from an even more powerful and advanced cyborg. 1.0E8 5.16816151E8
Catwoman 8/13/04 A shy woman, endowed with the speed, reflexes, and senses of a cat, walks a thin line between criminal and hero, even as a detective doggedly pursues her, fascinated by both of her personas. 7.3887903E7
Harry Potter and the Chamber of Secrets 11/15/02 Harry ignores warnings not to return to Hogwarts, only to find the school plagued by a series of mysterious attacks and a strange voice haunting him. 8.7898788E8
American Gangster 11/16/07 In 1970s America, a detective works to bring down the drug empire of Frank Lucas, a heroin kingpin from Manhattan, who is smuggling the drug into the country from the Far East. 2.64132214E8
Blood Diamond 1/26/07 A fisherman, a smuggler, and a syndicate of businessmen match wits over the possession of a priceless diamond. 1.71377916E8
Gladiator 5/12/00 When a Roman general is betrayed and his family murdered by a corrupt prince, he comes to Rome as a gladiator to seek revenge. 1.03E8 4.57683805E8
True Lies 8/12/94 When a secret agent learns of his wife’s extra-marital affair, he pursues her and uses his intelligence resources in a job he kept secret from her. 3.653E8
Gangs of New York 1/9/03 In 1863, Amsterdam Vallon returns to the Five Points area of New York City seeking revenge against Bill the Butcher, his father’s killer. 9.7E7 1.904E8
Black Hawk Down 1/18/02 123 elite U.S. soldiers drop into Somalia to capture two top lieutenants of a renegade warlord and find themselves in a desperate battle with a large force of heavily-armed Somalis. 9.5E7 1.73638745E8
The Fifth Element 6/6/97 In the colorful future, a cab driver unwittingly becomes the central figure in the search for a legendary cosmic weapon to keep Evil and Mr Zorg at bay. 2.639E8
The Lord of the Rings: Return of the King 12/17/03 The former Fellowship of the Ring prepare for the final battle for Middle Earth, while Frodo & Sam approach Mount Doom to destroy the One Ring. 9.4E7 1.133027325E9
The Lord of the Rings: The Two Towers 12/18/02 Frodo and Sam continue on to Mordor in their mission to destroy the One Ring. Whilst their former companions make new allies and launch an assault on Isengard. 9.26284377E8
Rush Hour 8/10/07 After an attempted assassination on Ambassador Han, Lee and Carter head to Paris to protect a French woman with knowledge of the Triads’ secret leaders. 1.8E8 2.5298085E8
Rush Hour 2 8/3/01 Carter and Lee head to Hong Kong for vacation, but become embroiled in a counterfeit money scam. 9.0E7 3.47425832E8
Men in Black 8/1/97 Two men who keep an eye on aliens in New York City must try to save the world after the aliens threaten to blow it up. 5.89390539E8
The Departed 10/6/06 Two men from opposite sides of the law are undercover within the Massachusetts State Police and the Irish mafia, but violence and bloodshed boil when discoveries are made, and the moles are dispatched to find out theirenemy’s identities. 2.90539042E8
Die Hard: With A Vengeance 8/18/95 John McClane and a store owner must play a bomber’s deadly game as they race around New York while trying to stop him. 3.65012499E8
Cinderella Man 9/9/05 The story of James Braddock, a supposedly washed up boxer who came back to become a champion and an inspiration in the 1930s. 8.8E7 1.08539911E8
The Bourne Supremacy When Jason Bourne is framed for a botched CIA operation he is forced to take up his former life as a trained assassin to survive. 8.5E7 2.8858745E8
Last Action

Hero 7/30/93 A young movie fan gets thrown into the movie world of his favourite action film character. 1.37298489E8
Cast Away 1/12/01 A FedEx executive must transform himself physically and emotionally to survive a crash landing on a deserted island. 4.27230516E8
Ocean’s Twelve 2/4/05 Daniel Ocean recruits one more team member so he can pull off three major European heists in this sequel to Ocean’s 11. 3.63531634E8
Click 9/29/06 A workaholic architect finds a universal remote that allows him to fast-forward and rewind to different parts of his life. Complications arise when the remote starts to overrule his choices. 8.25E7 2.37555633E8
Bruce Almighty 6/27/03 A guy who complains about God too often is given almighty powers to teach him how difficult it is to run the world. 8.1E7 4.85004995E8
7/5/96 An American agent, under false suspicion of disloyalty, must discover and expose the real spy without the help of his organization. 8.0E7 4.56481886E8
Deep Impact 5/15/98 Unless a comet can be destroyed before colliding with Earth, only those allowed into shelters will survive. Which people will survive? 3.49464664E8
Road to Perdition 9/27/02 Bonds of loyalty are put to the test when a hitman’s son witnesses what his father does for a living. 1.81054514E8
A Beautiful Mind After a brilliant but asocial mathematician accepts secret work in cryptography, his life takes a turn to the nightmarish. 7.8E7 3.16708996E8
Children of Men 9/22/06 In 2027, in a chaotic world in which humans can no longer procreate, a former activist agrees to help transport a miraculously pregnant woman to a sanctuary at sea, where her child’s birth may help scientists save thefuture of humankind. 7.6E7 6.9450202E7
Jurassic Park 7/16/93 Scientists clone dinosaurs to populate a theme park which suffers a major security breakdown and releases the dinosaurs. 6.3E7 9.201E8
Spider-Man 6/14/02 When bitten by a genetically modified spider, a nerdy, shy, and awkward high school student gains spider-like abilities that he eventually must use to fight evil as a superhero after tragedy befalls his family. 1.39E8 8.21606375E8
King Kong 12/15/05 In 1933 New York, an overly ambitious movie producer coerces his cast and hired ship crew to travel to mysterious Skull Island, where they encounter Kong, a giant ape who is immediately smitten with leading lady Ann Darrow. 187.0 2.07E8 5.50316796E8
Superman 7/16/06 After a long visit to the lost remains of the planet Krypton, the Man of Steel returns to earth to become the peoples savior once again and reclaim the love of Lois Lane. 2.04E8 3.9112E8
Titanic 1/23/98 Fictional romantic tale of a rich girl and poor boy who meet on the ill-fated voyage of the ‘unsinkable’ ship. 2.0E8 1.8354E9
Evan Almighty 8/3/07 God (Freeman) contacts Congressman Evan Baxter (Carell) and tells him to build an ark in preparation for a great flood. 1.75E8 1.7321928E8
Waterworld 8/11/95 In a future where the polar ice caps have melted and most of Earth is underwater, a mutated mariner fights starvation and outlaw “smokers,” and reluctantly helps a woman and a young girl find dry land. 2.6424622E8
Pearl Harbor 6/1/01 Pearl Harbor follows the story of two best friends, Rafe and Danny, and their love lives as they go off to join the war. 183.0 1.515E8 4.505E8
Munich 1/27/06 Based on the true story of the Black September aftermath, about the five men chosen to eliminate the ones responsible for that fateful day. 7.5E7 1.3027909E8
Independence Day 8/9/96 The aliens are coming and their goal is to invade and destroy. Fighting superior technology, Man’s best weapon is the will to survive. 8.16969255E8
X-Men 8/18/00 Two mutants come to a private academy for mutants whose resident superhero team must oppose a powerful mutant terrorist organization. 2.95999717E8
X2 5/1/03 The X-Men band together to find a mutant assassin who has made an attempt on the President’s life, while the Mutant Academy is attacked by military forces. 4.06400513E8
The Rock 6/21/96 A group of U.S. marines, under command of a renegade general, take over Alcatraz and threat San Francisco Bay with biological weapons. A chemical weapons specialist and the only man to have ever escaped from theRock are the only ones who can prevent chaos 3.36069511E8
3/18/05 Based on the DC/Vertigo comic book Hellblazer and written by Kevin Brodbin, Mark Bomback and Frank Capello, Constantine tells the story of irreverent supernatural detective John Constantine (Keanu Reeves), who has literally been to hell and back. 2.29976178E8
Unbreakable 12/29/00 A suspense thriller with supernatural overtones that revolves around a man who learns something extraordinary about himself after a devastating accident. 7.3243106E7 2.48099143E8
Talladega Nights: The Ballad or Ricky Bobby 9/15/06 #1 NASCAR driver Ricky Bobby (Ferrell) stays atop the heap thanks to a pact with his best friend and teammate, Cal Naughton, Jr. (Reilly). But when a French Formula One driver (Cohen), makes his way up the ladder, Ricky Bobby’s talent and devotion are put 7.3E7 1.63213377E8
The Simpsons Movie 7/25/07 After Homer accidentally pollutes the town’s water supply, Springfield is encased in a gigantic dome by the EPA and the Simpsons family are declared fugitives. 7.25E7 5.26758418E8
Braveheart 9/8/95 William Wallace, a commoner, unites the 13th Century Scots in their battle to overthrow

English 7.2E7 2.09E8
Jarhead 1/13/06 Based on former Marine Anthony Swofford’s best-selling 2003 book about his pre-Desert Storm experiences in Saudi Arabia and about his experiences fighting in Kuwait. 9.6780312E7
The Village 8/20/04 The population of a small, isolated countryside village believe that their alliance with the mythical creatures that inhabit the forest around them is coming to an end. 7.1682975E7 2.6019752E8
Shrek the Third 6/29/07 When his new father-in-law, King Harold falls ill, Shrek is looked at as the heir to the land of Far, Far Away. Not one to give up his beloved swamp, Shrek recruits his friends Donkey and Puss in Boots to install the rebellious Artie as the new king. Prin 1.6E8 7.98957081E8
Shrek 2 7/2/04 Princess Fiona’s parents invite her and Shrek to dinner to celebrate her marriage. If only they knew the newlyweds were both ogres. 7.0E7 9.15278586E8
The Abyss 10/13/89 A civilian diving team are enlisted to search for a lost nuclear submarine and face danger while encountering an alien aquatic species. 5.4243125E7
Transformers 7/27/07 A war re-erupts on Earth between two robotic clans, the heroic Autobots and the evil Decepticons, leaving the fate of mankind hanging in the balance. 1.51E8 7.07675744E8
Harry Potter and the Order of the Phoenix 7/12/07 With their warning about Lord Voldemort’s return scoffed at, Harry and Dumbledore are targeted by the Wizard authorities as an authoritarian bureaucrat slowly seizes power at Hogwarts. 9.38454486E8
The warrior Beowulf must fight and defeat the monster Grendel who is terrorizing towns, and later, Grendel’s mother, who begins killing out of revenge. 1.94995215E8
Bee Movie 1

2/14/07 Barry B. Benson, a bee who has just graduated from college, is disillusioned at his lone career choice: making honey. On a special trip outside the hive, Barry’s life is saved by Vanessa, a florist in New York City.As their relationship blossoms, he disco 2.86758211E8
Pirates of the Caribbean: at World’s End 5/24/07 Captain Barbossa, Will Turner and Elizabeth Swann must sail off the edge of the map, navigate treachery and betrayal, and make their final alliances for one last decisive battle. 9.52404152E8
I am Legend 12/26/07 Years after a plague kills most of humanity and transforms the rest into monsters, the sole survivor in New York City struggles valiantly to find a cure. 5.83527323E8
Ratatouille 10/12/07 Remy is a young rat in the French countryside who arrives in Paris, only to find out that his cooking idol is dead. When he makes an unusual alliance with a restaurant’s new garbage boy, the culinary and personal adventures begin despite Remy’s family’s s 6.17245654E8
Troy 5/21/04 An adaptation of Homer’s great epic, the film follows the assault on Troy by the united Greek forces and chronicles the fates of the men involved. 4.97298577E8
Harry Potter and the Goblet of Fire 11/18/05 Harry finds himself selected as an underaged competitor in a dangerous multi-wizardary school competition. 8.96013036E8
Batman Begins 6/16/05 The story of how Bruce Wayne became what he was destined to be: Batman. 3.71824647E8
Charlie and the Chocolate 7/29/05 A young boy wins a tour through the most magnificent chocolate factory in the world, led by the world’s most unusual candy maker. 4.73459076E8
Pirates of the Caribbean: Dead Man’s Chest 7/6/06 Jack Sparrow races to recover the heart of Davy Jones to avoid enslaving his soul to Jones’ service, as other friends and foes seek the heart for their own agenda as well. 1.065659812E9
Die Another Day 11/20/02 James Bond is sent to investigate the connection between a North Korean terrorist and a diamond mogul who is funding the development of an international space weapon. 1.42E8 4.31942139E8
Lethal Weapon 9/18/98 With personal crises and age weighing in on them, LAPD officers Riggs and Murtaugh must contend with a deadly Chinese crimelord trying to get his brother out of prison. 1.4E8 2.854E8
Armageddon 8/7/98 When an asteroid the size of Texas is headed for Earth the world’s best deep core drilling team is sent to nuke the rock from the inside. 5.546E8
Men in Black 2 8/2/02 Agent J needs help so he is sent to find Agent K and restore his memory. 4.41818803E8
Spider-Man 3 5/4/07 A strange black entity from another world bonds with Peter Parker and causes inner turmoil as he contends with new villains, temptations, and revenge. 2.58E8 8.91930303E8
Spider-Man 2 7/16/04 Peter Parker is beset with troubles in his failing personal life as he battles a brilliant scientist named Doctor Otto Octavius, who becomes Doctor Octopus (aka Doc Ock), after an accident causes him to bond psychically with mechanical tentacles that do h 7.84024485E8
Stealth 8/5/05 Deeply ensconced in a top-secret military program, three pilots struggle to bring an artificial intelligence program under control … before it initiates the next world war. 1.38E8 7.6416746E7
Final Fantasy: The Spirits Within A female scientist makes a last stand on Earth with the help of a ragtag team of soldiers against an invasion of alien phantoms. 1.37E8 8.513183E7
Miami Vice 8/4/06 Based on the 1980’s TV action/drama, this update focuses on vice detectives Crockett and Tubbs as their respective personal and professional lives become dangerously intertwined. 1.35E8 1.63818556E8
The World Is Not Enough 11/26/99 James Bond uncovers a nuclear plot when he protects an oil heiress from her former kidnapper, an international terrorist who can’t feel pain. 3.6173066E8
Master and Commander: The Far Side of the World 11/28/03 During the Napoleonic Wars, a brash British captain pushes his ship and crew to their limits in pursuit of a formidable French war vessel around South America. 2.09486484E8
War of the Worlds 7/1/05 As Earth is invaded by alien tripod fighting machines, one family fights for survival. 1.32E8 5.91745532E8
Star Trek: Insurrection 1/1/99 When the crew of the Enterprise learn of a Federation plot against the inhabitants of a unique planet, Capt. Picard begins an open rebellion. 1.178E8
Who Framed Roger Rabbit? 12/2/88 A toon hating detective is a cartoon rabbit’s only hope to prove his innocence when he is accused of murder. 3.515E8
Sleepy Hollow 1/7/00 Ichabod Crane is sent to Sleepy Hollow to investigate the decapitations of 3 people with the culprit being the legendary apparition, the Headless Horseman. 2.0706834E8
xXx 10/17/02 Xander Cage is an extreme sports athelete recruited by the government on a special mission. 2.672E8
Die Hard 2 8/17/90 John McClane is forced to battle mercenaries who seize control of an airport’s communications and threaten to cause plane crashes if their demands are not met. 2.37523878E8
The Long Kiss Goodnight 11/29/96 A women suffering from amnesia begins to recover her memories after trouble from her past finds her again. 6.5E7
Apollo 13 9/22/95 True story of the moon-bound mission that developed severe trouble and the men that rescued it with skill and dedication. 3.341E8
Saving Private Ryan 9/11/98 Based on a World War II drama. US soldiers try to save their comrade, paratrooper Private Ryan, who’s stationed behind enemy lines. 4.81635085E8
Fight Club 11/12/99 An office employee and a soap salesman build a global organization to help vent male aggression.
6/11/99 A computer hacker learns from mysterious rebels about the true nature of his reality and his role in the war against the controllers of it. 4.565E8
Total Recall 7/27/90 When a man goes for virtual vacation memories of the planet Mars, an unexpected and harrowing series of events forces him to go to the planet for real, or does he? 2.614E8
Cliffhanger 6/25/93 A botched mid-air heist results in suitcases full of cash being searched for by various groups throughout the Rocky Mountains. 2.55E8
Clear and Present Danger 8/3/94 CIA Analyst Jack Ryan is drawn into an illegal war fought by the US government against a Colombian drug cartel. 6.2E7 2.075E8
GoldenEye 11/24/95 James Bond teams up with the lone survivor of a destroyed

Russian 6.0E7 3.56429941E8
The Black Dahlia Two policemen see their personal and professional lives fall apart in the wake of the “Black Dahlia” murder investigation. 4.6672813E7
The Truman Show 10/9/98 An insurance salesman/adjuster discovers his entire life is actually a TV show. 2.484E8
Event Horizon 8/22/97 A rescue crew investigates a spaceship that disappeared into a black hole and has now returned…with someone or something new on-board. 2.6673242E7
The Bourne Identity 9/6/02 A man is picked up by a fishing boat, bullet-riddled and without memory, then races to elude assassins and recover from amnesia. 2.133E8
9/2/04 A demon, raised from infancy after being conjured by and rescued from the Nazis, grows up to become a defender against the forces of darkness. 9.8703901E7
Starsky & Hutch 3/19/04 Two streetwise cops (Stiller and Wilson) bust criminals in their red-and-white Ford Torino with the help of police snitch called Huggy Bear (Snoop Dogg). 1.70200225E8
Intolerable Cruelty 10/24/03 A revenge-seeking gold digger marries a womanizing Beverly Hills lawyer with the intention of making a killing in the divorce. 1.21327628E8
3/23/07 King Leonidas and a force of 300 men fight the Persians at Thermopylae in 480 B.C. 4.56068181E8
Star Trek: Nemesis 1/3/03 After the Enterprise is diverted to the Romulan planet of Romulus, supposedly because they want to negotiate a truce, the Federation soon find out the Romulans are planning an attack on Earth. 6.7312826E7
12/21/78 An alien orphan is sent from his dying planet to Earth, where he grows up to become his adoptive home’s first and greatest super-hero. 5.5E7 3.002E8
Crimson Tide 11/3/95 On a US nuclear missile sub, a young first officer stages a mutiny to prevent his trigger happy captain from launching his missiles before confirming his orders to do so. 1.59387195E8
Deja Vu 12/15/06 An ATF agent travels back in time to save a woman from being murdered, falling in love with her during the process. 1.81038616E8
Man On Fire 10/8/04 In Mexico City, a former assassin swears vengeance on those who committed an unspeakable act against the family he was hired to protect. 1.18706816E8
Enemy of the State 12/26/98 A lawyer becomes a target by a corrupt politician and his NSA goons when he accidentally receives key evidence to a serious politically motivated crime. 2.503E8
Kill Bill: Vol. 1 10/17/03 The Bride wakes up after a long coma. The baby that she carried before entering the coma is gone. The only thing on her mind is to have revenge on the assassination team that betrayed her – a team she was once partof. 1.80098138E8
Alien 8/21/92 Ripley continues to be stalked by a savage alien, after her escape pod crashes on a prison planet. 1.585E8
Shanghai Noon 8/25/00 Jackie Chan plays a Chinese man who travels to the Wild West to rescue a kidnapped princess. After teaming up with a train robber, the unlikely duo takes on a Chinese traitor and his corrupt boss. 7.1189835E7
Kill Bill: Vol. 2 4/23/04 The murderous Bride continues her vengeance quest against her ex-boss, Bill, and his two remaining associates; his younger brother Budd, and Bill’s latest flame Elle. 1.5090792E8
Blade II 3/29/02 Blade forms an uneasy alliance with the vampire council in order to combat the Reaper vampires who feed on vampires. 5.4E7 1.54306865E8
Flags of our Fathers 12/22/06 The life stories of the six men who raised the flag at The Battle of Iwo Jima, a turning point in WWII. 5.3E7 6.1902376E7
2/23/96 Greed, deception, money, power, and murder occur between two mobster best friends and a trophy wife over a gambling empire. 5.2E7 1.104E8
Robin Hood: Prince of Thieves 7/19/91 When Robin and his Moorish companion come to England and the tyranny of the Sheriff of Nottingham, he decides to fight back as an outlaw. 5.0E7 3.905E8
6/29/01 An ogre, in order to regain his swamp, travels along with an annoying donkey in order to bring a princess to a scheming lord, wishing himself King. 4.79467267E8
Shanghai Knights 4/4/03 When a Chinese rebel murders Chon’s estranged father and escapes to England, Chon and Roy make their way to London with revenge on their minds.
Indiana Jones and the Last Crusade 6/30/89 When Dr. Henry Jones Sr. suddenly goes missing while pursuing the Holy Grail, eminent archaeologist Indiana Jones must follow in his father’s footsteps and stop the Nazis. 4.8E7 4.74171806E8
Star Trek: First Contact 12/13/96 Capt. Picard and his crew pursue the Borg back in time to stop them from preventing Earth from initiating first contact with alien life. 4.6E7
11/13/98 A half-vampire, half-mortal man becomes a protector of the mortal race, while slaying evil vampires. 4.5E7 1.31237688E8
Patriot Games 9/25/92 When CIA Analyst Jack Ryan interferes with an IRA assassination, a renegade faction targets him and his family for revenge. 1.781E8
The Fugitive 9/24/93 Dr. Richard Kimble, unjustly accused of killing his wife, must find the real one-armed killer while avoiding Marshal Sam Gerard. 4.4E7 3.689E8
The Prestige 11/10/06 Robert and Alfred are rival magicians. When Alfred performs the ultimate magic trick, Robert tries desperately to find out the secret to the trick. 4.0E7 1.07896006E8
The Last of the Mohicans 11/6/92 Three trappers protect a British Colonel’s daughters in the midst of the French and Indian War.
Apocalypto 1/5/07 As the

Mayan 1.17784857E8
Wedding Crashers 7/14/05 John Beckwith and Jeremy Grey, a pair of committed womanizers who sneak into weddings to take advantage of the romantic tinge in the air, find themselves at odds with one another when John meets and falls for ClaireCleary. 2.83218368E8
Back to the Future 7/11/90 Doctor Emmet Brown was living in peace in 1885 until he was killed by Buford “Mad Dog” Tannen. Marty McFly travels back in time to save his friend. 2.437E8
11/24/89 After visiting 2015, Marty must repeat his visit to 1955 to prevent disastrous changes to 1985… without interfering with his first trip. 3.32E8
Licence to Kill 7/14/89 James Bond leaves Her Majesty’s Secret Service to stop an evil drug lord and avenge his best friend, Felix Leiter. 4.2E7 1.56167015E8
The Living Daylights 6/30/87 James Bond is living on the edge to stop an evil arms dealer from starting another world war. Bond crosses all seven continents in order to stop the evil Whitaker and General Koskov. 1.912E8
Sin City 6/3/05 A film that explores the dark and miserable town Basin City and tells the story of three different people, all caught up in the violent corruption of the city. 1.59098862E8
Serenity 10/7/05 In the future, when a passenger with a deadly secret. Six rebels on the run. An assassin in pursuit. 3.9E7 3.8514517E7
Star Trek: Generations 11/18/94 Capt. Picard, with the help of supposedly dead Capt. Kirk, must stop a madman willing to murder on a planetary scale in order to enter a space matrix. 3.8E7
Never Say Never Again 12/15/83 A SPECTRE agent has stolen two American nuclear warheads, and James Bond must find their targets before they are detonated. 3.6E7
Star Trek: The Motion Picture 12/20/79 When a destructive space entity is spotted approaching Earth, Admiral Kirk resumes command of the Starship Enterprise in order to intercept, examine, and hopefully stop it. 3.5E7
12/4/98 Two cops team up to get back a kidnapped daughter. 2.453E8
Lethal Weapon 3 8/14/92 Martin Riggs finally meets his match in the form of Lorna Cole, a beautiful but tough policewoman. 3.197E8
Star Wars: Episode IV – Return of the Jedi 5/25/83 After rescuing Han Solo from the palace of Jabba the Hutt, the Rebels attempt to destroy the Second Death Star, while Luke Skywalker tries to bring his father back to the Light Side of the Force. 3.25E7 5.727E8
A History of Violence 9/30/05 A mild-mannered man becomes a local hero through an act of violence, which sets off repercussions that will shake his family to its very core. 3.2E7 5.9993782E7
Moonraker 6/29/79 James Bond investigates the mid-air theft of a space shuttle and discovers a plot to commit global genocide. 3.1E7 2.103E8
Get Shorty 3/15/96 A mobster travels to Hollywood to collect a debt and discovers that the movie business is much the same as his current job. 3.025E7 1.15021008E8
The Assassination of Jesse James by the Coward Robert Ford 11/30/07 Robert Ford, who’s idolized Jesse James since childhood, tries hard to join the reforming gang of the Missouri outlaw, but gradually becomes resentful of the bandit leader. 3.0E7 1.1128555E7
Million Dollar Baby 1/14/05 A hardened trainer/manager works with a determined woman in her attempt to establish herself as a boxer. 2.16763646E8
Se7en 1/5/96 Police drama about two cops, one new and one about to retire, after a serial killer using the seven deadly sins as his MO. 3.28125643E8
172.0 The Hunt For Red October 4/20/90 In 1984, the USSR’s best submarine captain in their newest sub violates orders and heads for the USA. Is he trying to defect, or to start a war? 2.005E8
173.0 Ghost Busters 12/7/84 Three unemployed parapsychology professors set up shop as a unique ghost removal service. 2.91632124E8
Star Trek V: The Final Frontier 10/20/89 Capt. Kirk and his crew must deal with Mr. Spock’s half brother who hijacks the Enterprise for an obsessive search for God. 7.02E7
175.0 Indiana Jones and the Temple of Doom 6/15/84 After arriving in India, Indiana Jones is asked by a desperate village to find a mystical stone. He agrees, and stumbles upon a secret cult plotting a terrible plan in the catacombs of an ancient palace. 2.8E7 3.33080271E8
Blade Runner 9/9/82 Deckard, a blade runner, has to track down and terminate 4 replicants who hijacked a ship in space and have returned to earth seeking their maker. 3.3139618E7
2/3/89 New York cop John McClane gives terrorists a dose of their own medicine as they hold hostages in an LA office building. 1.37350242E8
For Your Eyes Only 6/26/81 Agent 007 is assigned to hunt for a lost British encryption device and prevent it from falling into enemy hands. 1.953E8
Octopussy 6/10/83 A fake Fabergé egg and a fellow agent’s death leads James Bond to uncovering an international jewel smuggling operation, headed by the mysterious Octopussy, being used to disguise a nuclear attack on NATO forces. 2.75E7 1.875E8
Star Trek VI: The Undiscovered Country 2/14/92 The crews of the Enterprise and the Excelsior must stop a plot to prevent a peace treaty between the Klingon Empire and the Federation. 2.7E7 9.69E7
The Running Man 10/21/88 A wrongly-convicted man must try to survive a public execution gauntlet staged as a TV game show. 3.8122E7
Open Range A former gunslinger is forced to take up arms again when he and his cattle crew are threatened by a corrupt lawman. 2.6E7 6.8293719E7
Kindergarten Cop 2/1/91 A tough cop is given his most difficult assignment: masquerade as a a kindergarten teacher in order to find a drug dealer. 2.02E8
184.0 O Brother, Where Art Thou? 9/15/00 Homer’s epic poem “The Odyssey”, set in the deep south during the 1930’s. In it, three escaped convicts search for hidden treasure while a relentless lawman pursues them. 7.4506619E7
185.0 Goodfellas 9/19/90 Henry Hill and his friends work their way up through the mob hierarchy. 2.5E7 4.6743809E7
186.0 The Passion of the Christ 3/26/04 A film detailing the final hours and crucifixion of Jesus Christ. 6.1189942E8
The Untouchables 9/18/87 Federal Agent Elliot Ness sets out to take out Al Capone; because of rampant corruption, he assembles a small, hand-picked team. 7.6270454E7
188.0 Schindler’s List 2/18/94 Oskar Schindler uses Jews to start a factory in Poland during the war. He witnesses the horrors endured by the Jews, and starts to save them. 3.212E8
189.0 Anchorman: The Legend of Ron Burgundy 9/10/04 Ron Burgundy is San Diego’s top rated newsman in the male dominated broadcasting of the 1970’s, but that’s all about to change when a new female employee with ambition to burn arrives in his office. 8.9366354E7
Scarface 12/9/83 In 1980 Miami, a determined Cuban immigrant takes over a drug empire while succumbing to greed. 4.4942821E7
Star Trek IV: The Voyage Home 4/10/87 To save Earth from an alien probe, Kirk and his crew go back in time to retrieve the only beings who can communicate with it, humpback whales. 2.4E7 1.33E8
12/17/76 A petroleum exploration expedition comes to an isolated island and encounters a colossal giant gorilla. 2.3E7 8.0014445E7
Star Wars: Episode V – The Empire Strikes Back 5/21/80 While Luke takes advanced Jedi training from Yoda, his friends are relentlessly pursued by Darth Vader as part of his plan to capture Luke. 5.342E8
Gandhi 12/8/82 Biography of Mahatma Gandhi, the lawyer who became the famed leader of the Indian revolts against the British through his philosophy of non-violent protest. 2.2E7 5.2767889E7
Equilibrium 3/14/03 In a Fascist future where all forms of feeling are illegal, a man in charge of enforcing the law rises to overthrow the system. 2.0E7 5345869.0
From Dusk Till Dawn 5/31/96 Two criminals and their hostages unknowingly seek temporary refuge in an establishment populated by vampires, with chaotic results. 2.5728961E7
Raiders of the Lost Ark 7/30/81 Archeologist and adventurer Indiana Jones is hired by the US government to find the Ark of the Covenant, before the Nazis. 3.86800358E8
12/4/85 In 1985, Doc Brown invented time travel, in 1955, Marty McFly accidentally prevented his parents from meeting, putting his own existence at stake. 1.9E7 3.81109762E8
Dances With Wolves 2/8/91 Lt. John Dunbar, exiled to a remote western Civil War outpost, befriends wolves and Indians, making him an intolerable aberration in the military. 4.242E8
Star Trek III: The Search For Spock 7/27/84 Admiral Kirk and his bridge crew risk their careers stealing the decommissioned Enterprise to return to the restricted Genesis planet to recover Spock’s body. 1.8E7 8.7E7
Borat: Cultural Learnings of America for Make Benefit Glorious Nation of Kazakhstan 11/2/06 Kazakh TV talking head Borat is dispatched to the United States to report on the greatest country in the world. With a documentary crew in tow, Borat becomes more interested in locating and marrying Pamela Anderson. 2.61509089E8
Raging Bull 4/10/81 An emotionally self-destructive boxer’s journey through life, as the violence and temper that leads him to the top in the ring, destroys his life outside it. 2.3380203E7
Aliens 8/29/86 The planet from Alien (1979) has been colonized, but contact is lost. This time, the rescue team has impressive firepower, enough? 1.7E7 1.83316455E8
9/24/04 A series of Rashomon-like flashback accounts shape the story of how one man defeated three assassins who sought to murder the most powerful warlord in pre-unified China. 1.7735214E8
Hot Fuzz Jealous colleagues conspire to get a top London cop transferred to a small town and paired with a witless new partner. On the beat, the pair stumble upon a series of suspicious accidents and events. 1.6E7 7.9192988E7
2/3/95 Professional assassin Leon reluctantly takes care of 12-year-old Mathilda, a neighbor whose parents are killed, and teaches her his trade. 4.5284974E7
High Plains Drifter 8/22/73 A gunfighting stranger comes to the small settlement of Lago and is hired to bring the townsfolk together in an attempt to hold off three outlaws who are on their way. 1.57E7
Collateral 9/17/04 A cab driver finds himself the hostage of an engaging contract killer as he makes his rounds from hit to hit during one night in LA. He must find a way to save both himself and one last victim. 2.17670152E8
American Beauty 2/4/00 Lester Burnham, a depressed suburban father in a mid-life crisis, decides to turn his hectic life around after developing an infatuation for his daughter’s attractive friend. 1.5E7 3.56258047E8
8/28/87 A veteran cop, Murtough, is partnered with a young homicidal cop, Riggs. Both having one thing in common, hating working in pairs. Now they must learn to work with one and other to stop a gang of drug smugglers. 1.2019235E8
Lethal Weapon 2 9/15/89 Riggs and Murtaugh are on the trail of South African diplomats who are using their immunity to engage in criminal activities. 1.40292E8
Crouching Tiger, Hidden Dragon 1/5/01 Two warriors in pursuit of a stolen sword and a notorious fugitive are led to an impetuous, physically-skilled, teenage nobleman’s daughter, who is at a crossroads in her life. 2.132E8
Brokeback Mountain Based on the ‘E. Annie Proulx’ story about a forbidden and secretive relationship between two cowboys and their lives over the years. 1.39E7 1.80343761E8
Hulk 7/18/03 A geneticist’s experimental accident curses him with the tendency to become a powerful giant green brute under emotional stress. 2.45160047E8
Sense and Sensibility Rich Mr. Dashwood dies, leaving his second wife and her daughters poor by the rules of inheritance. Two daughters are the titular opposites. 1.65E7 1.34993774E8
Ride with the Devil 11/5/99 Jake Roedel and Jack Bull Chiles are friends in Missouri when the Civil War starts. 630779.0
Twins 3/17/89 A physically perfect, but innocent, man goes in search of his twin brother, who is a short small-time crook. 2.166E8
28 Days Later… 11/1/02 Four weeks after a mysterious, incurable virus spreads throughout the UK, a handful of survivors try to find sanctuary. 8.2719885E7
The Beach 2/11/00 Twenty-something Richard travels to Thailand and finds himself in possession of a strange map. Rumours state that it leads to a solitary beach paradise, a tropical bliss – excited and intrigued, he sets out to findit. 3.9778599E7
Trainspotting Renton, deeply immersed in the Edinburgh drug scene, tries to clean up and get out, despite the allure of the drugs and influence of friends. 3100000.0 2.4000785E7
The Spy Who Loved Me 8/3/77 James Bond investigates the hijacking of British and Russian submarines carrying nuclear warheads with the help of a KGB agent whose lover he killed. 1.4E7 1.854E8
Downfall 4/1/05 Traudl Junge (Lara), the final secretary for Adolf Hitler (Ganz), tells of the Nazi dictator’s final days in his Berlin bunker at the end of WWII. 1.35E7 9.350194E7
Letters from Iwo Jima 2/23/07 The story of the battle of Iwo Jima between the United States and Imperial Japan during World War II, as told from the perspective of the

Japanese 1.3E7 6.8356082E7
Star Trek II: The Wrath of Khan 7/16/82 Admiral Kirk’s midlife crisis is interrupted by the return of an old enemy looking for revenge and a potentially destructive device. 1.2E7 9.68E7
House of Flying Daggers A romantic warrior breaks a beautiful member of a rebel army out of prison to help her rejoin her fellows, but things are not what they seem. 9.3041228E7
Das Boot 2/10/82 The claustrophobic world of a WWII German U-boat; boredom, filth, and sheer terror. 8.4970337E7
4/28/67 In an early spy spoof, aging Sir James Bond (David Niven) comes out of retirement to take on SMERSH. 4.1744718E7
Star Wars: Episode IV – A New Hope 12/27/77 Luke Skywalker leaves his home planet, teams up with other rebels, and tries to save Princess Leia from the evil clutches of Darth Vader. 1.1E7 7.979E8
E.T.: The Extra-Terrestrial 12/9/82 A group of Earth children help a stranded alien botanist return home. 1.05E7 7.92910554E8
Amelie 10/5/01 Amelie, an innocent and naive girl in Paris, with her own sense of justice, decides to help those around her and along the way, discovers love. 1.035E7 1.52637129E8
You Only Live Twice 6/13/67 Agent 007 and the Japanese secret service ninja force must find and stop the true culprit of a series of spacejackings before nuclear war is provoked. 9

500000.0 1.116E8
Thunderball 12/29/65 James Bond heads to The Bahamas to recover two nuclear warheads stolen by SPECTRE agent Emilio Largo in an international extortion scheme. 9000000.0 1.412E8
9/6/79 A mining ship, investigating a suspected SOS, lands on a distant planet. The crew discovers some strange creatures and investigates. 2.0363063E8
On Her Majesty’s Secret Service 12/18/69 James Bond woos a mob boss’s daughter and goes undercover to uncover the true reason for Blofeld’s allergy research in the Swiss Alps that involves beautiful women from around the world. 8000000.0 8.2E7
Pulp Fiction 10/21/94 The lives of two mob hit men, a boxer, a gangster’s wife, and a pair of diner bandits intertwine in four tales of violence and redemption. 2.129E8
Rumble in the Bronx 7/4/97 A young man visiting and helping his uncle in New York City finds himself forced to fight a street gang and the mob with his martial art skills. 7500000.0 3.6238752E7
Diamonds are Forever 12/30/71 A diamond smuggling investigation leads James Bond to Las Vegas, where he uncovers an extortion plot headed by his nemesis, Ernst Stavro Blofeld. 7200000.0 1.16E8
Fargo Jerry Lundegaard’s inept crime falls apart due to his and his henchmen’s bungling and the persistent police work of pregnant Marge Gunderson. 7000000.0 5.1567751E7
Live and Let Die 7/6/73 007 is sent to stop a diabolically brilliant heroin magnate armed with a complex organization and a reliable psychic tarot card reader. 1.618E8
The Man with the Golden Gun 12/20/74 Bond is led to believe that he is targeted by the world’s most expensive assassin and must hunt him down to stop him. 9.76E7
Good Night, and Good Luck 2/17/06 Broadcast journalist Edward R. Murrow looks to bring down Senator Joseph McCarthy. 5.4601218E7
Pale Rider 6/28/85 A mysterious preacher protects a humble prospector village from a greedy mining company trying to encroach on their land. 6900000.0 4.1410568E7
1/11/85 A human-looking, apparently unstoppable cyborg is sent from the future to kill Sarah Connor; Kyle Reese is sent to stop it. 6400000.0 7.8019031E7
10/17/56 Adaptation of Jules Verne’s novel about a Victorian Englishman who bets that with the new steamships and railways he can do what the title says.
The Usual Suspects 8/25/95 A boat has been destroyed, criminals are dead, and the key to this mystery lies with the only survivor and his twisted, convoluted story beginning with five career crooks in a seemingly random police lineup. 6000000.0 2.3341568E7
Memento 10/20/00 A man, suffering from short-term memory loss, uses notes and tattoos to hunt for the man he thinks killed his wife. 5000000.0 3.966595E7
Shaun of the Dead 4/9/04 A man decides to turn his moribund life around by winning back his ex-girlfriend, reconciling his relationship with his mother, and dealing with an entire community that has returned from the dead to eat the living. 3.0039392E7
Four Weddings and a Funeral 5/13/94 Comedy-drama about a group of British friends… the title says the rest. 4500000.0 2.57700832E8
Night Watch A fantasy-thriller set in present-day Moscow where the respective forces that control daytime and nighttime do battle. 4200000.0 3.392355E7
Goldfinger Investigating a gold magnate’s gold smuggling, James Bond uncovers a plot to contaminate the Fort Knox gold reserve. 3000000.0 1.249E8
The Lives of Others 4/13/07 In 1984 East Berlin, an agent of the secret police, conducting surveillance on a writer and his lover, finds himself becoming increasingly absorbed by their lives. 2000000.0 7.0053813E7
From Russia with Love 5/27/64 James Bond willingly falls into an assassination ploy involving a naive Russian beauty in order to retrieve a Soviet encryption device that was stolen by SPECTRE. 7.89E7
Reservoir Dogs 1/15/93 After a simple jewelery heist goes terribly wrong, the surviving criminals begin to suspect that one of them is a police informant. 1200000.0 2832029.0
Dr. No 5/8/63 James Bond’s investigation of a missing colleague in Jamaica leads him to the island of the mysterious Dr. No and a scheme to end the US space program. 1000000.0 5.9567035E7
4/7/33 A film crew goes to a tropical island for an exotic location shoot and discovers a colossal giant gorilla who takes a shine to their female blonde star. 670000.0 1.0E7
Seven Samurai 11/19/56 A poor village under attack by bandits recruits seven unemployed samurai to help them defend themselves. 271736.0
Super Size Me An irreverent look at obesity in America and one of its sources – fast food corporations. 65000.0 2.9529368E7
Kagemusha 10/6/80 When a powerful warlord in medieval Japan dies, a poor thief recruited to impersonate him finds difficulty
6/1/85 An elderly lord abdicates to his three sons, and the two corrupt ones turn against him.
Sunshine 4/5/07 A team of astronauts are sent to re-ignite the dying sun 50 years into the future. 3.1959646E7
Once Were Warriors 4/14/95 A family descended from Maori warriors is bedeviled by a violent father and the societal problems of being treated as outcasts.
GenderId

1 Female
2

3 Unknown
GenderName
Male
1 English
2

3 French
4 German
5

6 Japanese
7

8 Mayan
9 Russian
10

11

LanguageId LanguageName
Cantonese
Mandarin
Aramaic
Spanish
Owl Hoot
1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

StudioId StudioName
Universal Pictures
Paramount Pictures
Walt Disney Pictures
20th Century Fox
Columbia Pictures
Warner Bros. Pictures
Touchstone Pictures
Dreamworks
ImageMovers
Disney Pixar
MGM
Chris Lee Productions
Lucasfilm
New Line Cinema
Carolco Pictures
Miramax Films
Jerry Bruckheimer Films
Gaumont
Revolution Studios
Imagine Entertainment
Morgan Creek Productions
United Artists
Dimension Films
Braveworld Productions
Icon Productions
Carolina Bank
Tig Productions
Dune Entertainment
Beijing New Picture Film Co.
Big Talk Productions
Malpaso Company
British Film Council
Channel Four Films
Constantin Film
Bavaria Film
Bayerischer Rundfunk
RKO Radio Pictures
Toho Company
Kathbur Pictures
Avalon Studios

Id

LikesToEat

pudding

LikesToEat
1 Tuna
2 Curry
3 Beef
4 Lasagne
5 Leaves
6 Grass
7 Milk
8 Lager
9 Gin and Tonic
1

0 Pasta
11 Kebab
12 Hot dog
13 Crisps
14 Chocolate
15 Beef burgers
16 BLT
17 Chips
18 Black
19 Ice cream
20 Bananas
21 Guinness
22 Cheese
23 Flies
24 Rice
25 Water
26 Baked beans
27 Omelette
28 Stir fry
29 Sausages
30 Boiled egg
31 People
1

2

3

true

4

true

5

true

6

true

7

false

8

false

9

true

false

11

false

12

true

13

true

14

true

15

true

16

true

17

man

false

18

false

19

false

20

true

21

false

22

y

false

23

false

24

true

25

false

26

true

27

false

28

true

29

false

30

true

31

false

false

true

false

true

false

false

false

false

false

true

false

false

false

true

true

true

false

false

true

false

true

false

false

true

true

OwnerId OwnerName OwnerDOB Celebrity?
Vicki 1/12/69 true
Dean 6/8/57 false
Fred Flintstone 12/24/79
Barney Rubble 6/1/76
Daffy Duck 11/16/71
Elmer Fudd 8/2/70
Bugs Bunny 12/25/60
Homer Simpson 9/26/67
Mighty Mouse 4/13/66
10 Batman 10/18/75
Winnie the Pooh 3/13/78
Tigger 4/26/67
Piglet 5/21/74
Robin 10/13/79
Superman 1/22/66
Lex Luthor 4/6/58
Spider 1/9/78
Mr Magoo 8/14/79
Sylvester 12/28/63
Huckleberry Hound 10/11/61
Secret Squirrel 6/27/63
Yellow Pink 3/14/79
BatFink 6/19/75
Bart Simpson 5/28/63
Marvin the Martian 11/15/62
Tazmanian Devil 6/23/73
Bullwinkle Moose 3/17/68
Paddington Bear 6/17/60
Crazylegs Crane 9/22/79
Felix the

Cat 11/21/73
Popeye 5/9/66
32 Tom Cat 5/23/79
33 Jerry Mouse 4/5/68
34 Porky Pig 10/18/60
35 Scooby Doo 10/5/77
36 Top Cat 2/13/69
37 Snoopy 10/1/64
38 Mickey Mouse 3/14/67
39 Goofy 3/8/72
40 Betty Boop 3/9/70
41 Pepe LePew 10/14/60
42 Tweety Pie 9/21/58
43 Wile E. Coyote 5/12/78
44 Pebbles 7/5/71
45 Charlie

Brown 1/17/66
46 Woody Woodpecker 6/20/70
47 Chilly Willie 12/2/60
48 Donald Duck 3/26/69
49 Pink Panther 5/13/69
50 Barney Bear 10/17/66
51 Boo Boo 2/27/79
52 Yogi Bear 12/16/59
53 Count Duckula 9/7/65
54 Danger Mouse 10/22/74
55 Road Runner 1/22/76
56 Jessica

Rabbit 6/5/66

Id

Id

OwnerId

13

6 18 3 2

15

3 22 21 3

16

Girl

7 23 7 8

17

Girl

1 3 4 33

18

Boy

4 31 2 11

¤ 0.00

21

Boy

6 31 20 3

25

Girl

2 30 18 7

¤ 0.00

26

Girl

5 28 17 22 ¤ 0.00

27

Boy

17 20 19 51

¤ 0.00

28

Boy

16 16 13 53 ¤ 0.00

29

Girl

7 14 10 40 ¤ 0.00

30

Girl

1 19 9 23 ¤ 0.00

31

Girl

4 13 3 2 ¤ 0.00

32

Girl

9 30 3 10 ¤ 0.00

33

Boy

4 21 8 10 ¤ 0.00

PetId PetName Gender PetDOB Email PetColour LikesToEatId PetType SpecialRequirements VetBills
Dai Boy 8/14/96 #mailto:charlie@feline.net# Also loves roast chicken ¤ 25.00
Phoebe Girl 7/5/96 #mailto:pheobe@bunny.net# Likes to eat telephone cables too ¤ 0.00
Nancy 10/25/97 #mailto:nancy@amphibian.net# Hates the French ¤ 36.00
Fido 8/1/00 #mailto:fido@canine.net# ¤ 19.00
Arthur 5/4/95 #mailto:arthur@reptile.net# Needs his teeth brushing daily
Boris 11/12/95 #mailto:boris@creepycrawlies.net# ¤ 75.00
Daphne 9/15/99 #mailto:daphne@creepycrawlies.net# Also likes lettuce
Julie 1/12/97 #mailto:julie@birds.net#
Andy 4/13/95 #mailto:andy@reptile.net# Needs plenty of water
Dave 12/19/00 #mailto:dave@minerals.net
Jenny 1/1/90 #mailto:jenny@plants.net#
Sandi 12/12/00 #mailto:sandi@winter.net#
Daisy 9/13/97 #mailto:frank@feline.net#
Dorian 2/23/94 #mailto:dorian@feline.net#
Basil 7/1/99 #mailto:basil@brush.net#
PetColourId PetColour
1

2 Black
3 Brown
4

5 Pink
6

7

8 Yellow
9

10

11

12

16

17

White
Ginger
Red
Green
Purple
Gold
Blue
Orange
Grey
Silver

Id

PetSkin

1

2

3

4

5

6

7

8

9

10

11

PetSkin
Scaly
Furry
Smooth
Slimy
Clammy
Revolting
Rough
Lumpy
Spiky
Feathery
Hairy
PetTypeId PetType

2

1 4

3 Cat 2 4
4

3 4

5

4 4

6

5 4

7

4 4

8

7 4

9

8 2

10

8

11

2 4

12

2 4

13

3 0

14

3 0

15

1 3

16

2 4

17

10 4

18

6 0

19

1 4

20 Spider 6 8
21 Rabbit 11 4
PetSkinId Limbs Picture
Alligator
Dog
Horse
Lion
Frog
Fox
Snowman
Tree 100
Rat
Gerbil
Rock
Snake
Fish
Hamster
Parrot
Slug
Iguana

PARAMETERS __OwnerId Value;
SELECT DISTINCTROW *
FROM Pet AS OwnersOfPetsMainForm
WHERE ([__OwnerId] = OwnerId);
PARAMETERS __PetTypeId Value;
SELECT DISTINCTROW *
FROM Pet AS [PetsOfTypeMainForm 2]
WHERE ([__PetTypeId] = PetTypeId);
PARAMETERS __PetTypeId Value;
SELECT DISTINCTROW *
FROM Pet AS PetsOfTypeMainForm
WHERE ([__PetTypeId] = PetTypeId);
PARAMETERS __OwnerId Value;
SELECT DISTINCTROW *
FROM Pet AS [Types and Pets Main Form]
WHERE ([__OwnerId] = OwnerId);

Are you stuck with your online class?
Get help from our team of writers!