TIMDB - Bollywood Films

A Data-Driven Approach to Bollywood

@kaggle.thedevastator_timdb_bollywood_films

Table List

14 tables(4.1 MB)

Bollywood Writers Data

Genome Scores

Genome Tags

Links

Ratings

Bollywood Full

@kaggle.thedevastator_timdb_bollywood_films.bollywood_full

2.77 MB
4330 rows
18 columns

title_x Title X	imdb_id Imdb Id	poster_path Poster Path	wiki_link Wiki Link	title_y Title Y	original_title Original Title	year_of_release Year Of Release	runtime Runtime	genres Genres	imdb_rating Imdb Rating	imdb_votes Imdb Votes	story Story	summary Summary	tagline Tagline	actors Actors	wins_nominations Wins Nominations	release_date Release Date
Uri: The Surgical Strike	tt8291224	https://upload.wikimedia.org/wikipedia/en/thumb/3/3b/URI_-_New_poster.jpg/220px-URI_-_New_poster.jpg	https://en.wikipedia.org/wiki/Uri:_The_Surgical_Strike	Uri: The Surgical Strike	Uri: The Surgical Strike	2019	138	Action\|Drama\|War	8.4	35112	Divided over five chapters the film chronicles the events of the surgical strike conducted by the Indian military against suspected militants in Pakistan occupied Kashmir. It tells the story of the 11 tumultuous events over which the operation was carried out. Indian army special forces carry out a…	Indian army special forces execute a covert operation avenging the killing of fellow army men at their base by a terrorist group.	nan	Vicky Kaushal\|Paresh Rawal\|Mohit Raina\|Yami Gautam\|Kirti Kulhari\|Rajit Kapoor\|Ivan Rodrigues\|Manasi Parekh\|Swaroop Sampat\|Riva Arora\|Yogesh Soman\|Fareed Ahmed\|Akashdeep Arora\|Kallol Banerjee\|	4 wins	11 January 2019 (USA)
Battalion 609	tt9472208	nan	https://en.wikipedia.org/wiki/Battalion_609	Battalion 609	Battalion 609	2019	131	War	4.1	73	The story revolves around a cricket match between the Indian Army and the Pakistan Army gone wrong and narrates the tale of the soldiers of Battalion 609 putting up a fight with Taliban. After an attack on Indian Army that is Battalion 609 near the LOC the match which was to be played between India…	The story of Battalion 609 revolves around a cricket match between the Indian Army and the Pakistan army gone wrong and narrates the tale of the brave soldiers of Battalion 609 putting up a fight with the mighty Taliban.	nan	Vicky Ahuja\|Shoaib Ibrahim\|Shrikant Kamat\|Elena Kazan\|Vishwas Kini\|Major Kishore\|Jashn Kohli\|Rammy C. Pandey\|Manish Sharma\|Sparsh Sharma\|Farnaz Shetty\|Vikas Shrivastav\|Chandraprakash Thakur\|Brajesh Tiwari\|	nan	11 January 2019 (India)
The Accidental Prime Minister (film)	tt6986710	https://upload.wikimedia.org/wikipedia/en/thumb/a/a1/The_Accidental_Prime_Minister_film.jpg/220px-The_Accidental_Prime_Minister_film.jpg	https://en.wikipedia.org/wiki/The_Accidental_Prime_Minister_(film)	The Accidental Prime Minister	The Accidental Prime Minister	2019	112	Biography\|Drama	6.1	5549	Based on the memoir by Indian policy analyst Sanjaya Baru The Accidental Prime Minister explores Manmohan Singh's tenure as the Prime Minister of India and the interference of Congress Party in contradicting his decisions during his first tenure. He details how Singh fell a victim to Congress Part…	Explores Manmohan Singh's tenure as the Prime Minister of India and the kind of control he had over the cabinet and the country.	nan	Anupam Kher\|Akshaye Khanna\|Aahana Kumra\|Atul Sharma\|Manoj Anand\|Arjun Mathur\|Suzanne Bernert\|Abdul Quadir Amin\|Bharat Mistri\|Divya Seth\|Anil Rastogi\|Ramesh Bhatkar\|Parrgash Kaur\|Jess Kaur\|	nan	11 January 2019 (USA)
Why Cheat India	tt8108208	https://upload.wikimedia.org/wikipedia/en/thumb/a/a2/Why_Cheat_India_poster.jpg/220px-Why_Cheat_India_poster.jpg	https://en.wikipedia.org/wiki/Why_Cheat_India	Why Cheat India	Why Cheat India	2019	121	Crime\|Drama	6	1891	The movie focuses on existing malpractices in country's education system the whole concept of buying your way through education jobs and earnings. Even with an evolving education system the country faces scams like SSC and HSC paper leaks CBSE re-examination Vyaapam etc. The movie tries to shi…	The movie focuses on existing malpractices in country's education system the whole concept of buying your way through education jobs and earnings. Even with an evolving education system ...	nan	Emraan Hashmi\|Shreya Dhanwanthary\|Snighdadeep Chatterji\|Navneet Srivastava\|Nanda Yadav\|	nan	18 January 2019 (USA)
Evening Shadows	tt6028796	nan	https://en.wikipedia.org/wiki/Evening_Shadows	Evening Shadows	Evening Shadows	2018	102	Drama	7.3	280	While gay rights and marriage equality has been embraced by most countries a small town in Southern India lives within a cocoon of traditions and social morality. In such a milieu when a young gay man Kartik comes out to his mother Vasudha her entire world comes crashing down. She has no one to t…	Under the 'Evening Shadows' truth often plays hide and seek. Set in South India and Mumbai 'Evening Shadows' is a tender heartwarming story about a mother-son bond that has to withstand the ravages of time distance and truths.	nan	Mona Ambegaonkar\|Ananth Narayan Mahadevan\|Devansh Doshi\|Arpit Chaudhary\|Yamini Singh\|Abhay Kulkarni\|Veena Nair\|Disha Thakur\|Kala Ramanathan\|Sushant Divgikar\|	17 wins & 1 nomination	11 January 2019 (India)
Soni (film)	tt6078866	https://upload.wikimedia.org/wikipedia/en/thumb/d/de/Soni_India_Netflix_Movie_Poster.jpg/220px-Soni_India_Netflix_Movie_Poster.jpg	https://en.wikipedia.org/wiki/Soni_(film)	Soni	Soni	2018	97	Drama	7.2	1595	Soni a young policewoman in Delhi and her superintendent Kalpana have collectively taken on a growing crisis of violent crimes against women. However their alliance suffers a major setback when Soni is transferred out for alleged misconduct on duty.	While fighting crimes against women in Delhi a short-fused policewoman and her level-headed female boss grapple with gender issues in their own lives.	nan	Geetika Vidya Ohlyan\|Saloni Batra\|Vikas Shukla\|Mohit Chauhan\|Himanshu Kohli\|Gauri Chakraborty\|Mohinder Gujral\|Upasya Goswami\|Simrat Kaur\|Dimple Kaur\|Prateek Pachori\|Kalpana Jha\|Samar\|	3 wins & 5 nominations	18 January 2019 (USA)
Fraud Saiyaan	tt5013008	https://upload.wikimedia.org/wikipedia/en/thumb/4/48/Fraud_Saiyyan_film_poster.jpg/220px-Fraud_Saiyyan_film_poster.jpg	https://en.wikipedia.org/wiki/Fraud_Saiyaan	Fraud Saiyaan	Fraud Saiyyan	2019	109	Comedy\|Drama	4.2	504	Fraud Saiyyan is the story of a con artist in North India who convinces women to marry him just so he can live off their money.	Fraud Saiyyan is the story of a con artist in North India who convinces women to marry him just so he can live off their money.	nan	Arshad Warsi\|Saurabh Shukla\|Flora Saini\|Sara Loren\|Varun Badola\|Deepali Pansare\|Nivedita Tiwari\|Peeyush Suhaney\|Preeti Sood\|Parag Tyagi\|Anangsha Biswas\|Amanda Rosario\|Elli Avrram\|	nan	18 January 2019 (India)
Bombairiya	tt4971258	https://upload.wikimedia.org/wikipedia/en/thumb/b/bb/Bombairiya_poster.jpg/220px-Bombairiya_poster.jpg	https://en.wikipedia.org/wiki/Bombairiya	Bombairiya	Bombairiya	2019	104	Comedy\|Crime\|Drama	4.3	295	It follows the story of Meghna who gets embroiled in a series of events after her phone gets stolen.	It follows the story of Meghna who gets embroiled in a series of events after her phone gets stolen.	They didn't mean to change the world.	Radhika Apte\|Akshay Oberoi\|Siddhanth Kapoor\|Ravi Kishan\|Adil Hussain\|Shilpa Shukla\|Ajinkya Deo\|Amit Sial\|	nan	18 January 2019 (India)
Manikarnika: The Queen of Jhansi	tt6903440	https://upload.wikimedia.org/wikipedia/en/thumb/4/44/Manikarnika_Poster.jpg/220px-Manikarnika_Poster.jpg	https://en.wikipedia.org/wiki/Manikarnika:_The_Queen_of_Jhansi	Manikarnika: The Queen of Jhansi	Manikarnika: The Queen of Jhansi	2019	148	Action\|Biography\|Drama	6.5	7361	Manikarnika born in Varanasi when Dixt a minister in Jhansi princely state sees her he proposes her marriage to Gangadar Rao prince of Jhansi.Sadashiv Rao plots along with British officers to conquer Jhansi as he Is promised a stake in it after conquering Jhansi.After the birth of Lakshmi and Gangad…	Story of Rani Lakshmibai one of the leading figures of the Indian Rebellion of 1857 and her resistance to the British Rule.	nan	Kangana Ranaut\|Rimi Sen\|Atul Kulkarni\|Nalneesh Neel\|Danny Denzongpa\|Mishti\|Kulbhushan Kharbanda\|Mohammed Zeeshan Ayyub\|Anil George\|Vikram Kochhar\|Edward Sonnenblick\|Ankita Lokhande\|Richard Keep\|Jishu Sengupta\|	nan	25 January 2019 (USA)
Thackeray (film)	tt7777196	https://upload.wikimedia.org/wikipedia/en/thumb/8/8e/Thackeray_film_poster.jpeg/220px-Thackeray_film_poster.jpeg	https://en.wikipedia.org/wiki/Thackeray_(film)	Thackeray	Thackeray	2019	120	Biography\|Drama	5.1	2301	Balasaheb Thackrey works as a cartoonist for a newspaper. But his editor isn't happy with it as he creates cartoons of politician which affects the sales of his paper.He is asked to try something else but he quits his job and now his only aim is to fight for the rights of Marathi people. He sees tha…	Biographical account of Shiv Sena Supremo Balasaheb Thackeray.	nan	Nawazuddin Siddiqui\|Amrita Rao\|Abdul Quadir Amin\|Sanjay Narvekar\|Prakash Belawadi\|Vineet Sharma\|Radha Sagar\|Sonamoni Jayant Gadekar\|Satish Alekar\|Micky Makhija\|Nikhil Mahajan\|Resh Lamba\|Jaywant Wadkar\|Laxman Singh Rajput\|	nan	25 January 2019 (India)


CREATE TABLE bollywood_full (
  "title_x" VARCHAR,
  "imdb_id" VARCHAR,
  "poster_path" VARCHAR,
  "wiki_link" VARCHAR,
  "title_y" VARCHAR,
  "original_title" VARCHAR,
  "is_adult" BIGINT,
  "year_of_release" VARCHAR,
  "runtime" VARCHAR,
  "genres" VARCHAR,
  "imdb_rating" DOUBLE,
  "imdb_votes" DOUBLE,
  "story" VARCHAR,
  "summary" VARCHAR,
  "tagline" VARCHAR,
  "actors" VARCHAR,
  "wins_nominations" VARCHAR,
  "release_date" VARCHAR
);