TMDB 5000 Credits
TMDB 5000 Movies Credit Information
@kaggle.ademylz_tmdb_5000_credits
Tmdb 5000 Credits
@kaggle.ademylz_tmdb_5000_credits.tmdb_5000_credits
- 11.2 MB
- 4803 rows
- 4 columns
movie_idMovie Id | titleTitle | castCast | crewCrew |
|---|---|---|---|
| 19995 | Avatar | [{"cast_id": 242, "character": "Jake Sully", "credit_id": "5602a8a7c3a3685532001c9a", "gender": 2, "id": 65731, "name": "Sam Worthington", "order": 0}, {"cast_id": 3, "character": "Neytiri", "credit_id": "52fe48009251416c750ac9cb", "gender": 1, "id": 8691, "name": "Zoe Saldana", "order": 1}, {"cast_… | [{"credit_id": "52fe48009251416c750aca23", "department": "Editing", "gender": 0, "id": 1721, "job": "Editor", "name": "Stephen E. Rivkin"}, {"credit_id": "539c47ecc3a36810e3001f87", "department": "Art", "gender": 2, "id": 496, "job": "Production Design", "name": "Rick Carter"}, {"credit_id": "54491c… |
| 285 | Pirates of the Caribbean: At World's End | [{"cast_id": 4, "character": "Captain Jack Sparrow", "credit_id": "52fe4232c3a36847f800b50d", "gender": 2, "id": 85, "name": "Johnny Depp", "order": 0}, {"cast_id": 5, "character": "Will Turner", "credit_id": "52fe4232c3a36847f800b511", "gender": 2, "id": 114, "name": "Orlando Bloom", "order": 1}, {… | [{"credit_id": "52fe4232c3a36847f800b579", "department": "Camera", "gender": 2, "id": 120, "job": "Director of Photography", "name": "Dariusz Wolski"}, {"credit_id": "52fe4232c3a36847f800b4fd", "department": "Directing", "gender": 2, "id": 1704, "job": "Director", "name": "Gore Verbinski"}, {"credit… |
| 206647 | Spectre | [{"cast_id": 1, "character": "James Bond", "credit_id": "52fe4d22c3a368484e1d8d6b", "gender": 2, "id": 8784, "name": "Daniel Craig", "order": 0}, {"cast_id": 14, "character": "Blofeld", "credit_id": "54805866c3a36829ab002592", "gender": 2, "id": 27319, "name": "Christoph Waltz", "order": 1}, {"cast_… | [{"credit_id": "54805967c3a36829b5002c41", "department": "Sound", "gender": 2, "id": 153, "job": "Original Music Composer", "name": "Thomas Newman"}, {"credit_id": "52fe4d22c3a368484e1d8d77", "department": "Directing", "gender": 2, "id": 39, "job": "Director", "name": "Sam Mendes"}, {"credit_id": "5… |
| 49026 | The Dark Knight Rises | [{"cast_id": 2, "character": "Bruce Wayne / Batman", "credit_id": "52fe4781c3a36847f8139869", "gender": 2, "id": 3894, "name": "Christian Bale", "order": 0}, {"cast_id": 8, "character": "Alfred Pennyworth", "credit_id": "52fe4781c3a36847f8139881", "gender": 2, "id": 3895, "name": "Michael Caine", "o… | [{"credit_id": "52fe4781c3a36847f81398c3", "department": "Sound", "gender": 2, "id": 947, "job": "Original Music Composer", "name": "Hans Zimmer"}, {"credit_id": "52fe4781c3a36847f8139899", "department": "Production", "gender": 0, "id": 282, "job": "Producer", "name": "Charles Roven"}, {"credit_id":… |
| 49529 | John Carter | [{"cast_id": 5, "character": "John Carter", "credit_id": "52fe479ac3a36847f813ea75", "gender": 2, "id": 60900, "name": "Taylor Kitsch", "order": 0}, {"cast_id": 20, "character": "Dejah Thoris", "credit_id": "52fe479ac3a36847f813eab3", "gender": 1, "id": 21044, "name": "Lynn Collins", "order": 1}, {"… | [{"credit_id": "52fe479ac3a36847f813eaa3", "department": "Writing", "gender": 2, "id": 7, "job": "Screenplay", "name": "Andrew Stanton"}, {"credit_id": "52fe479ac3a36847f813ea65", "department": "Directing", "gender": 2, "id": 7, "job": "Director", "name": "Andrew Stanton"}, {"credit_id": "58c69e8192… |
| 559 | Spider-Man 3 | [{"cast_id": 30, "character": "Peter Parker / Spider-Man", "credit_id": "52fe4252c3a36847f80151c7", "gender": 2, "id": 2219, "name": "Tobey Maguire", "order": 0}, {"cast_id": 7, "character": "Mary Jane Watson", "credit_id": "52fe4252c3a36847f801514f", "gender": 1, "id": 205, "name": "Kirsten Dunst",… | [{"credit_id": "52fe4252c3a36847f80151a5", "department": "Production", "gender": 1, "id": 6410, "job": "Casting", "name": "Francine Maisler"}, {"credit_id": "52fe4252c3a36847f801517b", "department": "Production", "gender": 0, "id": 10570, "job": "Executive Producer", "name": "Joseph M. Caracciolo Jr… |
| 38757 | Tangled | [{"cast_id": 34, "character": "Flynn Rider (voice)", "credit_id": "530d35bf9251411435001765", "gender": 2, "id": 69899, "name": "Zachary Levi", "order": 0}, {"cast_id": 33, "character": "Rapunzel (voice)", "credit_id": "530d35a2925141141e0017ff", "gender": 1, "id": 16855, "name": "Mandy Moore", "ord… | [{"credit_id": "52fe46db9251416c91062101", "department": "Production", "gender": 2, "id": 7879, "job": "Executive Producer", "name": "John Lasseter"}, {"credit_id": "52fe46db9251416c910620e3", "department": "Writing", "gender": 2, "id": 38748, "job": "Novel", "name": "Jacob Grimm"}, {"credit_id": "5… |
| 99861 | Avengers: Age of Ultron | [{"cast_id": 76, "character": "Tony Stark / Iron Man", "credit_id": "55e256d292514162cd000e40", "gender": 2, "id": 3223, "name": "Robert Downey Jr.", "order": 0}, {"cast_id": 8, "character": "Thor Odinson", "credit_id": "52fe4a449251416c750e3455", "gender": 2, "id": 74568, "name": "Chris Hemsworth",… | [{"credit_id": "55d5f7d4c3a3683e7e0016eb", "department": "Sound", "gender": 2, "id": 531, "job": "Original Music Composer", "name": "Danny Elfman"}, {"credit_id": "55f7d48892514103b60074ad", "department": "Sound", "gender": 0, "id": 900, "job": "Supervising Sound Editor", "name": "Christopher Boyes"… |
| 767 | Harry Potter and the Half-Blood Prince | [{"cast_id": 3, "character": "Harry Potter", "credit_id": "52fe4273c3a36847f801fa73", "gender": 2, "id": 10980, "name": "Daniel Radcliffe", "order": 0}, {"cast_id": 2, "character": "Ron Weasley", "credit_id": "52fe4273c3a36847f801fa6f", "gender": 2, "id": 10989, "name": "Rupert Grint", "order": 1}, … | [{"credit_id": "52fe4273c3a36847f801fab1", "department": "Camera", "gender": 0, "id": 2423, "job": "Director of Photography", "name": "Bruno Delbonnel"}, {"credit_id": "52fe4273c3a36847f801faf3", "department": "Art", "gender": 1, "id": 5331, "job": "Set Decoration", "name": "Stephanie McMillan"}, {"… |
| 209112 | Batman v Superman: Dawn of Justice | [{"cast_id": 18, "character": "Bruce Wayne / Batman", "credit_id": "52fe4d5bc3a368484e1e4c65", "gender": 2, "id": 880, "name": "Ben Affleck", "order": 0}, {"cast_id": 14, "character": "Clark Kent / Superman", "credit_id": "52fe4d5bc3a368484e1e4c55", "gender": 2, "id": 73968, "name": "Henry Cavill", … | [{"credit_id": "553bf23692514135c8002886", "department": "Sound", "gender": 2, "id": 947, "job": "Original Music Composer", "name": "Hans Zimmer"}, {"credit_id": "52fe4d5bc3a368484e1e4c2d", "department": "Production", "gender": 0, "id": 282, "job": "Producer", "name": "Charles Roven"}, {"credit_id":… |
CREATE TABLE tmdb_5000_credits (
"movie_id" BIGINT,
"title" VARCHAR,
"cast" VARCHAR,
"crew" VARCHAR
);