Oscar Best Picture Movies

Oscar Best Picture Winners an Nominees, IMDB, Rotten Tomato

@kaggle.martinmraz07_oscar_movies

Table List

1 table(473.37 KB)

Oscars Df

@kaggle.martinmraz07_oscar_movies.oscars_df

473.37 KB
571 rows
30 columns

unnamed_0 Unnamed: 0	film Film	oscar_year Oscar Year	film_studio_producer_s Film Studio/Producer(s)	award Award	year_of_release Year Of Release	movie_time Movie Time	movie_genre Movie Genre	imdb_rating IMDB Rating	imdb_votes IMDB Votes	movie_info Movie Info	genres Genres	critic_consensus Critic Consensus	content_rating Content Rating	directors Directors	authors Authors	actors Actors	original_release_date Original Release Date	streaming_release_date Streaming Release Date	production_company Production Company	tomatometer_status Tomatometer Status	tomatometer_rating Tomatometer Rating	tomatometer_count Tomatometer Count	audience_status Audience Status	audience_rating Audience Rating	audience_count Audience Count	tomatometer_top_critics_count Tomatometer Top Critics Count	tomatometer_fresh_critics_count Tomatometer Fresh Critics Count	tomatometer_rotten_critics_count Tomatometer Rotten Critics Count	film_id Film ID
	Wings	1927/28	Famous Players-Lasky	Winner	1927	144	Drama,Romance,War	7.5	12221	With World War I afoot, David Armstrong (Richard Arlen) and Jack Powell (Charles "Buddy" Rogers) join the military with an eye toward flying American fighter planes. They leave behind Mary Preston (Clara Bow), a local girl who's in love with David but committed to Jack. Dispatched to France as newly…	Action & Adventure, Classics	Subsequent war epics may have borrowed heavily from the original Best Picture winner, but they've all lacked Clara Bow's luminous screen presence and William Wellman's deft direction.	PG-13	William Wellman	Hope Loring, Louis D. Lighton	Clara Bow, Charles 'Buddy' Rogers, Richard Arlen, Gary Cooper, Jobyna Ralston, Charles Rogers, Arlette Marchal, El Brendel, "Gunboat" Smith, Richard Tucker, Julia Swayne Gordon, Henry B. Walthall, George Irving, Hedda Hopper, Roscoe Karns, Charles Barton, Nigel De Brulier, James Pierce, Gloria Wellm…	Fri Aug 12 1927 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Unknown	Certified-Fresh	93	46	Upright	78	3530	9	43	3	2becf7d5-a3de-46ab-ae45-abdd6b588067
1	7th Heaven	1927/28	Fox	Nominee	1927	110	Drama,Romance	7.7	3439	nan	nan	nan	nan	nan	nan	nan			nan	nan			nan						19ed3295-a878-4fd2-8e60-5cd7b5f93dad
2	The Racket	1927/28	The Caddo Company	Nominee	1928	84	Crime,Drama,Film-Noir	6.7	1257	nan	nan	nan	nan	nan	nan	nan			nan	nan			nan						3111c2d8-0908-4093-8ff3-99c89f2f2f08
3	The Broadway Melody	1928/29	Metro-Goldwyn-Mayer	Winner	1929	100	Drama,Musical,Romance	5.7	6890	Vaudeville sisters "Hank" (Bessie Love) and Queenie Mahoney (Anita Page) take their act to the Broadway stage in New York when Eddie (Charles King), a professional song-and-dance man appearing in a new show, invites his girlfriend Hank to join him. Soon after, Eddie transfers his affections to Queen…	Musical & Performing Arts, Romance	The Broadway Melody is interesting as an example of an early Hollywood musical, but otherwise, it's essentially bereft of appeal for modern audiences.	NR	Harry Beaumont	James Gleason, Norman Houston, Sarah Y. Mason	Anita Page, Bessie Love, Charles King, Jed Prouty, Ken Thomson, Edward Dillon, Mary Doran, J. Emmett Beck, Marshall Ruth, J.E. Beck, Drew Demarest, Eddie Kane, Nacio Herb Brown, Ray Cooke, James Gleason, Charles King Bibby, Angella Mawby, Claudine Mawby, Claudette Mawby	Fri Feb 01 1929 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Feb 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	MGM Home Entertainment	Rotten	33	24	Spilled	21	1813	7	8	16	de063f3f-2d35-4e1c-8636-6eb4c16bd236
4	Alibi	1928/29	Feature Productions	Nominee	1929	91	Action,Crime,Romance	5.8	765	nan	nan	nan	nan	nan	nan	nan			nan	nan			nan						609887c2-877c-43a4-b88c-e40e31096a98
5	Hollywood Revue	1928/29	Metro-Goldwyn-Mayer	Nominee	1929	130	Comedy,Music	5.7	2004	nan	nan	nan	nan	nan	nan	nan			nan	nan			nan						689f22d5-a700-4ce1-b9be-65652f32c186
6	In Old Arizona	1928/29	Fox	Nominee	1928	95	Western	5.6	1019	In this early Western, notorious bandit the Cisco Kid (Warner Baxter) is so feared that he rarely has to fire his gun to rob a stagecoach. His ravishing girlfriend, Tonia (Dorothy Burgess), often accuses him of being unfaithful, but he assures her that he loves only her, and even composes a song in …	Action & Adventure, Classics, Western, Romance	nan	NR	Irving Cummings, Raoul Walsh	Tom Barry	Warner Baxter, Edmund Lowe, Dorothy Burgess, J. Farrell MacDonald, Fred Warren, Henry Armetta, Frank Campeau, Tom Santschi, Pat Hartigan, Roy Stewart, Soledad Jiminez, Frank Nelson, Duke Martin, James Marcus, Alphonse Ethier, Helen Lynch, Ivan Linow, Joe E. Brown, Lola Salvi, Edward Peil Sr., John W…	Tue Dec 25 1928 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 12 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	20th Century Fox Film Corporation	Rotten	56	9	Spilled	38	356	2	5	4	a0644f19-a136-44c2-ab5d-50978ef19608
7	The Patriot	1928/29	Paramount Famous Lasky	Nominee	1928	113	Drama,History,Thriller	7.4	18	nan	nan	nan	nan	nan	nan	nan			nan	nan			nan						5d4ef7bd-2f81-47f3-9305-2c8fe140d4e4
8	All Quiet on the Western Front	1929/30	Universal	Winner	1930	152	Drama,War	8.1	59214	nan	nan	nan	nan	nan	nan	nan			nan	nan			nan						281742f9-3b4e-480d-b704-c8c15de6b721
9	The Big House	1929/30	Cosmopolitan	Nominee	1930	87	Crime,Drama,Thriller	7.1	2079	After being convicted of manslaughter, drunk driver Kent Marlowe (Robert Montgomery) is inducted into the rigors of prison life. He befriends fellow cons "Machine Gun" Butch Schmidt (Wallace Beery) and John Morgan (Chester Morris). Together they bristle at the prison's deplorable conditions and espe…	Classics, Drama	nan	NR	George W. Hill	Frances Marion, Martin Flavin, Joseph Farnham, Lennox Robinson	Wallace Beery, Robert Montgomery, Chester Morris, Karl Dane, Lewis Stone, Leila Hyams, George F. Marion, J.C. Nugent, DeWitt Jennings, Matthew Betz, Claire McDowell, Robert E. O'Connor, Robert Emmett O'Connor, Tom Wilson, Eddie Foyer, Roscoe Ates, Fletcher Norton, Adolph Seidel, Tom Kennedy, Eddie L…	Wed May 14 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Apr 16 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Warner Bros.	Fresh	75	8	Upright	69	323		6	2	297aa285-29d7-4a22-b833-c5632ab3e562


CREATE TABLE oscars_df (
  "unnamed_0" BIGINT,
  "film" VARCHAR,
  "oscar_year" VARCHAR,
  "film_studio_producer_s" VARCHAR,
  "award" VARCHAR,
  "year_of_release" BIGINT,
  "movie_time" BIGINT,
  "movie_genre" VARCHAR,
  "imdb_rating" DOUBLE,
  "imdb_votes" BIGINT,
  "movie_info" VARCHAR,
  "genres" VARCHAR,
  "critic_consensus" VARCHAR,
  "content_rating" VARCHAR,
  "directors" VARCHAR,
  "authors" VARCHAR,
  "actors" VARCHAR,
  "original_release_date" TIMESTAMP,
  "streaming_release_date" TIMESTAMP,
  "production_company" VARCHAR,
  "tomatometer_status" VARCHAR,
  "tomatometer_rating" DOUBLE,
  "tomatometer_count" DOUBLE,
  "audience_status" VARCHAR,
  "audience_rating" DOUBLE,
  "audience_count" DOUBLE,
  "tomatometer_top_critics_count" DOUBLE,
  "tomatometer_fresh_critics_count" DOUBLE,
  "tomatometer_rotten_critics_count" DOUBLE,
  "film_id" VARCHAR
);