The Movies Dataset
Metadata on over 45,000 movies. 26 million ratings from over 270,000 users.
@kaggle.rounakbanik_the_movies_dataset
Credits
@kaggle.rounakbanik_the_movies_dataset.credits
- 65.29 MB
- 45476 rows
- 3 columns
castCast | crewCrew | idId |
|---|---|---|
| [{'cast_id': 14, 'character': 'Woody (voice)', 'credit_id': '52fe4284c3a36847f8024f95', 'gender': 2, 'id': 31, 'name': 'Tom Hanks', 'order': 0, 'profile_path': '/pQFoyx7rp09CJTAb932F2g8Nlho.jpg'}, {'cast_id': 15, 'character': 'Buzz Lightyear (voice)', 'credit_id': '52fe4284c3a36847f8024f99', 'gender… | [{'credit_id': '52fe4284c3a36847f8024f49', 'department': 'Directing', 'gender': 2, 'id': 7879, 'job': 'Director', 'name': 'John Lasseter', 'profile_path': '/7EdqiNbr4FRjIhKHyPPdFfEEEFG.jpg'}, {'credit_id': '52fe4284c3a36847f8024f4f', 'department': 'Writing', 'gender': 2, 'id': 12891, 'job': 'Screenp… | 862 |
| [{'cast_id': 1, 'character': 'Alan Parrish', 'credit_id': '52fe44bfc3a36847f80a7c73', 'gender': 2, 'id': 2157, 'name': 'Robin Williams', 'order': 0, 'profile_path': '/sojtJyIV3lkUeThD7A2oHNm8183.jpg'}, {'cast_id': 8, 'character': 'Samuel Alan Parrish / Van Pelt', 'credit_id': '52fe44bfc3a36847f80a7c… | [{'credit_id': '52fe44bfc3a36847f80a7cd1', 'department': 'Production', 'gender': 2, 'id': 511, 'job': 'Executive Producer', 'name': 'Larry J. Franco', 'profile_path': None}, {'credit_id': '52fe44bfc3a36847f80a7c89', 'department': 'Writing', 'gender': 2, 'id': 876, 'job': 'Screenplay', 'name': 'Jonat… | 8844 |
| [{'cast_id': 2, 'character': 'Max Goldman', 'credit_id': '52fe466a9251416c75077a8d', 'gender': 2, 'id': 6837, 'name': 'Walter Matthau', 'order': 0, 'profile_path': '/xJVkvprOnzP5Zdh5y63y8HHniDZ.jpg'}, {'cast_id': 3, 'character': 'John Gustafson', 'credit_id': '52fe466a9251416c75077a91', 'gender': 2,… | [{'credit_id': '52fe466a9251416c75077a89', 'department': 'Directing', 'gender': 2, 'id': 26502, 'job': 'Director', 'name': 'Howard Deutch', 'profile_path': '/68Vae1HkU1NxQZ6KEmuxIpno7c9.jpg'}, {'credit_id': '52fe466b9251416c75077aa3', 'department': 'Writing', 'gender': 2, 'id': 16837, 'job': 'Charac… | 15602 |
| [{'cast_id': 1, 'character': "Savannah 'Vannah' Jackson", 'credit_id': '52fe44779251416c91011aad', 'gender': 1, 'id': 8851, 'name': 'Whitney Houston', 'order': 0, 'profile_path': '/69ouDnXnmklYPr4sMJXWKYz81AL.jpg'}, {'cast_id': 2, 'character': "Bernadine 'Bernie' Harris", 'credit_id': '52fe447792514… | [{'credit_id': '52fe44779251416c91011acb', 'department': 'Directing', 'gender': 2, 'id': 2178, 'job': 'Director', 'name': 'Forest Whitaker', 'profile_path': '/4pMQkelS5lK661m9Kz3oIxLYiyS.jpg'}, {'credit_id': '52fe44779251416c91011ae1', 'department': 'Writing', 'gender': 0, 'id': 5144, 'job': 'Screen… | 31357 |
| [{'cast_id': 1, 'character': 'George Banks', 'credit_id': '52fe44959251416c75039eb9', 'gender': 2, 'id': 67773, 'name': 'Steve Martin', 'order': 0, 'profile_path': '/rI2EMvkfKKPKa5z0nM2pFVBtUyO.jpg'}, {'cast_id': 2, 'character': 'Nina Banks', 'credit_id': '52fe44959251416c75039ebd', 'gender': 1, 'id… | [{'credit_id': '52fe44959251416c75039ed7', 'department': 'Sound', 'gender': 2, 'id': 37, 'job': 'Original Music Composer', 'name': 'Alan Silvestri', 'profile_path': '/chEsfnDEtRmv1bfOaNAoVEzhCc6.jpg'}, {'credit_id': '52fe44959251416c75039ee9', 'department': 'Camera', 'gender': 2, 'id': 5506, 'job': … | 11862 |
| [{'cast_id': 25, 'character': 'Lt. Vincent Hanna', 'credit_id': '52fe4292c3a36847f80291f5', 'gender': 2, 'id': 1158, 'name': 'Al Pacino', 'order': 0, 'profile_path': '/ks7Ba8x9fJUlP9decBr6Dh5mThX.jpg'}, {'cast_id': 26, 'character': 'Neil McCauley', 'credit_id': '52fe4292c3a36847f80291f9', 'gender': … | [{'credit_id': '52fe4292c3a36847f802916d', 'department': 'Directing', 'gender': 2, 'id': 638, 'job': 'Director', 'name': 'Michael Mann', 'profile_path': '/nKmUpRpuQIsYubR7vIxVKhkbaTW.jpg'}, {'credit_id': '52fe4292c3a36847f8029173', 'department': 'Writing', 'gender': 2, 'id': 638, 'job': 'Screenplay'… | 949 |
| [{'cast_id': 1, 'character': 'Linus Larrabee', 'credit_id': '52fe44959251416c75039d97', 'gender': 2, 'id': 3, 'name': 'Harrison Ford', 'order': 0, 'profile_path': '/7CcoVFTogQgex2kJkXKMe8qHZrC.jpg'}, {'cast_id': 2, 'character': 'Sabrina Fairchild', 'credit_id': '52fe44959251416c75039d9b', 'gender': … | [{'credit_id': '52fe44959251416c75039da9', 'department': 'Directing', 'gender': 2, 'id': 2226, 'job': 'Director', 'name': 'Sydney Pollack', 'profile_path': '/zxkoU2diKtvarV1Qk4z9He2lJj9.jpg'}, {'credit_id': '52fe44959251416c75039daf', 'department': 'Writing', 'gender': 1, 'id': 70846, 'job': 'Screen… | 11860 |
| [{'cast_id': 2, 'character': 'Tom Sawyer', 'credit_id': '52fe46bdc3a36847f810f771', 'gender': 2, 'id': 53283, 'name': 'Jonathan Taylor Thomas', 'order': 0, 'profile_path': '/1S8DpfNv6iiQRuKFPtb5u6sCQ5G.jpg'}, {'cast_id': 3, 'character': 'Huck Finn', 'credit_id': '52fe46bdc3a36847f810f775', 'gender':… | [{'credit_id': '52fe46bdc3a36847f810f797', 'department': 'Writing', 'gender': 2, 'id': 2075, 'job': 'Screenplay', 'name': 'David Loughery', 'profile_path': None}, {'credit_id': '52fe46bdc3a36847f810f791', 'department': 'Writing', 'gender': 2, 'id': 7775, 'job': 'Screenplay', 'name': 'Stephen Sommers… | 45325 |
| [{'cast_id': 1, 'character': 'Darren Francis Thomas McCord', 'credit_id': '52fe44dbc3a36847f80ae0e3', 'gender': 2, 'id': 15111, 'name': 'Jean-Claude Van Damme', 'order': 0, 'profile_path': '/aqZ9RjL5j44HMlBMvTaawhHiGOH.jpg'}, {'cast_id': 2, 'character': 'Joshua Foss', 'credit_id': '52fe44dbc3a36847f… | [{'credit_id': '52fe44dbc3a36847f80ae0f1', 'department': 'Directing', 'gender': 2, 'id': 37710, 'job': 'Director', 'name': 'Peter Hyams', 'profile_path': '/dAuDsStGGlUESaaAYQf0GCE2JWo.jpg'}, {'credit_id': '52fe44dbc3a36847f80ae0f7', 'department': 'Writing', 'gender': 1, 'id': 53300, 'job': 'Screenpl… | 9091 |
| [{'cast_id': 1, 'character': 'James Bond', 'credit_id': '52fe426ec3a36847f801e10d', 'gender': 2, 'id': 517, 'name': 'Pierce Brosnan', 'order': 0, 'profile_path': '/1JXL0zrA26JjdoX8sqf57fJRDVM.jpg'}, {'cast_id': 2, 'character': 'Alec Trevelyan', 'credit_id': '52fe426ec3a36847f801e111', 'gender': 2, '… | [{'credit_id': '52fe426ec3a36847f801e14b', 'department': 'Directing', 'gender': 2, 'id': 10702, 'job': 'Director', 'name': 'Martin Campbell', 'profile_path': '/qhx0AySf8yH3kiHrinWknUJbr1y.jpg'}, {'credit_id': '52fe426ec3a36847f801e151', 'department': 'Writing', 'gender': 2, 'id': 9856, 'job': 'Chara… | 710 |
CREATE TABLE credits (
"cast" VARCHAR,
"crew" VARCHAR,
"id" BIGINT
);