movies

Table actions

1 row where genre = "Comedy, Drama, Romance", language = "English" and "viewingDate" is on date 2011-08-17

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: viewingDate (date), createdAt (date), updatedAt (date)

id ▼ title description review language year genre viewingDate loved imdbRating imdbId createdAt updatedAt
72 City Lights With the aid of a wealthy erratic tippler, a dewy-eyed tramp who has fallen in love with a sightless flower girl accumulates money to be able to help her medically.   English 1931 Comedy, Drama, Romance 2011-08-17T01:00:00.000Z 1 8.5 tt0021749 2021-12-12T05:45:19.393Z 2021-12-12T05:45:19.393Z

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [movies] (
   [id] INTEGER PRIMARY KEY,
   [title] TEXT,
   [description] TEXT,
   [review] TEXT,
   [language] TEXT,
   [year] INTEGER,
   [genre] TEXT,
   [viewingDate] TEXT,
   [loved] INTEGER,
   [imdbRating] TEXT,
   [imdbId] TEXT,
   [createdAt] TEXT,
   [updatedAt] TEXT
);