shows
1 row where imdbRating = "8.7"
This data as json, CSV (advanced)
Suggested facets: startedDate (date), completedDate (date), createdAt (date), updatedAt (date)
id ▼ | title | language | showName | description | seasonNumber | year | genre | startedDate | completedDate | status | loved | imdbRating | imdbId | createdAt | updatedAt |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16 | Dexter Season 1 | English | Dexter | By day, mild-mannered Dexter is a blood-spatter analyst for the Miami police. But at night, he is a serial killer who only targets other murderers. | 1 | 2006 | Crime, Drama, Mystery | 2013-05-11T00:00:00.000Z | 2013-05-12T00:00:00.000Z | Completed | 1 | 8.7 | tt0773262 | 2021-12-12T05:52:44.157Z | 2021-12-12T05:52:44.157Z |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [shows] ( [id] INTEGER PRIMARY KEY, [title] TEXT, [language] TEXT, [showName] TEXT, [description] TEXT, [seasonNumber] INTEGER, [year] INTEGER, [genre] TEXT, [startedDate] TEXT, [completedDate] TEXT, [status] TEXT, [loved] INTEGER, [imdbRating] TEXT, [imdbId] TEXT, [createdAt] TEXT, [updatedAt] TEXT );