new_titles_view (view)
55 rows where item_format = "DVD/Videocassette"
This data as json, CSV (advanced)
| jacket | catalog_link | cataloging_date | item_format | indexed_subjects |
|---|---|---|---|---|
| Mother, couch 2025 dvd drama m9186 2025 |
2025-03-31 | DVD/Videocassette | [
"drama dysfunctional families",
"dysfunctional families drama",
"drama mother and child",
"mother and child drama",
"drama stores retail",
"stores retail drama"
] |
|
| Care bears : unlock the magic. Seeds of caring. 2025 dvd tvchild c271unsc 2025 |
2025-03-31 | DVD/Videocassette | [
"care bears fictitious characters juvenile films",
"juvenile films care bears fictitious characters",
"bears juvenile films",
"juvenile films bears",
"friendship juvenile films",
"juvenile films friendship",
"caring juvenile films",
"juvenile films caring"
] |
|
| Wildcat 2024 dvd drama w669 2024 |
2025-03-31 | DVD/Videocassette | [
"film adaptations oconnor flannery",
"oconnor flannery film adaptations",
"drama oconnor flannery",
"oconnor flannery drama",
"drama women authors",
"women authors drama",
"catholics drama",
"drama catholics",
"drama lupus patients",
"lupus patients drama",
"patients lupus drama"
] |
|
| There's still tomorrow = C'è ancora domani 2025 dvd world italy t398 2025 |
2025-03-31 | DVD/Videocassette | [
"drama elections italy",
"elections italy drama",
"italy elections drama",
"nineteen forty six a d",
"drama rome italy",
"rome italy drama",
"allied occupation 1943 1947 italy history drama",
"drama italy history allied occupation 1943 1947",
"italy history allied occupation 1943 1947 drama"
] |
|
| Dalgliesh. Series three 2025 dvd tvadult d142s3 2025 |
2025-03-31 | DVD/Videocassette | [
"television adaptations james p d",
"james p d television adaptations",
"dalgliesh adam fictitious character drama",
"drama dalgliesh adam fictitious character",
"drama police england",
"police england drama",
"england police drama",
"drama murder investigation england",
"england murder investigation drama",
"investigation murder england drama",
"murder investigation england drama",
"drama england",
"england drama"
] |
|
 |
Dino birds. 2025 dvd 567.9 d58692 2025 |
2025-03-31 | DVD/Videocassette | [
"birds history",
"birds origin",
"origin birds",
"dinosaurs"
] |
| The road to Eilat 2025 dvd world israel r628 2025 |
2025-03-21 | DVD/Videocassette | [
"drama veterans israel",
"israel veterans drama",
"veterans israel drama",
"automobile travel israel drama",
"drama automobile travel israel",
"israel automobile travel drama",
"drama farm tractors",
"farm tractors drama",
"drama fathers and sons",
"fathers and sons drama",
"feature films israel",
"israel feature films"
] |
|
| Aum : the cult at the end of the world 2025 dvd 299.93 a925 2025 |
2025-03-21 | DVD/Videocassette | [
"film adaptations kaolan david e 1955",
"kaolan david e 1955 film adaptations",
"film adaptations marshall andrew 1967",
"marshall andrew 1967 film adaptations",
"asahara shoko",
"oumu shinrikyo religious organization",
"cults japan history 20th century",
"japan cults history 20th century",
"japan terrorism history 20th century",
"terrorism japan history 20th century"
] |
|
| Without arrows 2025 dvd 305.897 w824 2025 |
2025-03-21 | DVD/Videocassette | [
"fiddler delwin elk bear",
"lakota indians south dakota",
"south dakota lakota indians",
"indians of north america south dakota",
"south dakota indians of north america",
"indigenous peoples south dakota",
"south dakota indigenous peoples",
"indian reservations united states",
"lakota indians",
"cheyenne river sioux tribe of the cheyenne river reservation south dakota"
] |
|
| The Wingfeather saga. Season one. 2023 dvd tvchild w769s1 2023 |
2025-03-21 | DVD/Videocassette | [
"peterson andrew 1974 television adaptations",
"television adaptations peterson andrew 1974",
"dragons juvenile films",
"juvenile films dragons",
"juvenile films siblings",
"siblings juvenile films",
"television programs",
"fantasy films",
"action and adventure films"
] |
|
 |
Pol pot dancing 2025 dvd 959.604092 p762 2025 |
2025-03-21 | DVD/Videocassette | [
"pol pot",
"cambodia dance history",
"dance cambodia history",
"cambodia history 1975 1979"
] |
| Mr. Monk's last case : a Monk movie. 2024 bluray suspense m678 2024 |
2025-03-21 | DVD/Videocassette | [
"monk adrian fictitious character drama",
"drama monk adrian fictitious character",
"california criminal investigation san francisco drama",
"criminal investigation california san francisco drama",
"drama criminal investigation california san francisco",
"san francisco criminal investigation california drama",
"california murder investigation san francisco drama",
"investigation murder california san francisco drama",
"san francisco murder investigation california drama",
"murder investigation california san francisco drama",
"drama murder investigation california san francisco",
"california fear of contamination san francisco drama",
"drama fear of contamination california san francisco",
"fear of contamination california san francisco drama",
"san francisco fear of contamination california drama",
"san francisco phobias california drama",
"phobias california san francisco drama",
"drama phobias california san francisco",
"california phobias san francisco drama",
"san francisco male friendship california drama",
"california male friendship san francisco drama",
"male friendship california san francisco drama",
"drama male friendship california san francisco",
"obsessive compulsive disorder drama",
"drama obsessive compulsive disorder",
"phobias drama",
"drama phobias",
"police drama",
"drama police",
"drama san francisco calif",
"san francisco calif drama"
] |
|
| Walnut tree 2025 dvd world iran w217 2025 |
2025-03-21 | DVD/Videocassette | [
"chemical warfare drama",
"drama chemical warfare",
"drama families",
"families drama",
"atrocities iran iraq war 1980 1988 drama",
"drama iran iraq war 1980 1988 atrocities",
"iran iraq war 1980 1988 atrocities drama",
"feature films iran",
"iran feature films"
] |
|
| Superman & Lois. The complete fourth season. 2025 dvd tvadult s9593s4 2025 |
2025-03-21 | DVD/Videocassette | [
"drama superman fictitious character",
"superman fictitious character drama",
"drama lane lois fictitious character",
"lane lois fictitious character drama",
"drama superheroes",
"superheroes drama",
"drama parenting",
"parenting drama",
"drama families",
"families drama",
"teenage boys drama",
"drama teenage boys"
] |
|
 |
Great migrations : a people on the move. 2025 dvd 307.240899 g786 2025 |
2025-03-19 | DVD/Videocassette | [
"african americans migrations history 20th century",
"migrations african americans history 20th century",
"migration internal united states history 20th century",
"rural urban migration united states history 20th century"
] |
| Charlie's angels. The complete series. Season five 2016 dvd tvadult c478s5 2016 |
2025-03-17 | DVD/Videocassette | [
"drama women private investigators",
"women private investigators drama",
"criminal investigation drama",
"drama criminal investigation"
] |
|
| Charlie's angels. The complete series. Season four 2016 dvd tvadult c478s4 2016 |
2025-03-17 | DVD/Videocassette | [
"drama women private investigators",
"women private investigators drama",
"criminal investigation drama",
"drama criminal investigation"
] |
|
| Charlie's angels. The complete series. Season three 2016 dvd tvadult c478s3 2016 |
2025-03-17 | DVD/Videocassette | [
"women private investigators",
"criminal investigation"
] |
|
| Charlie's angels. The complete series. Season two 2016 dvd tvadult c478s2 2016 |
2025-03-17 | DVD/Videocassette | [
"drama women private investigators",
"women private investigators drama",
"criminal investigation drama",
"drama criminal investigation"
] |
|
| Charlie's angels. The complete series. Season one 2016 dvd tvadult c478s1 2016 |
2025-03-17 | DVD/Videocassette | [
"drama women private investigators",
"women private investigators drama",
"criminal investigation drama",
"drama criminal investigation"
] |
|
| Ex-husbands 2025 dvd drama e9617 2025 |
2025-03-14 | DVD/Videocassette | [
"drama fathers and sons",
"fathers and sons drama",
"divorced men drama",
"drama divorced men",
"bachelor parties drama",
"drama bachelor parties",
"drama mexico",
"mexico drama"
] |
|
 |
Krystal 2018 dvd drama k94 2018 |
2025-03-14 | DVD/Videocassette | [
"drama man woman relationships",
"man woman relationships drama",
"drama families",
"families drama"
] |
 |
I do-- I did 2009 dvd comedy i1123 2009 |
2025-03-14 | DVD/Videocassette | [
"drama marriage united states",
"marriage united states drama",
"drama man woman relationships united states",
"man woman relationships united states drama",
"drama wives united states",
"wives united states drama",
"drama polygamy united states",
"polygamy united states drama",
"drama interracial marriage united states",
"interracial marriage united states drama",
"drama competition psychology",
"competition psychology drama",
"romantic comedy films"
] |
| Mia and me : the hero of Centopia 2025 dvd tvchild m618h 2025 |
2025-03-13 | DVD/Videocassette | [
"imaginary places juvenile films",
"juvenile films imaginary places",
"juvenile films unicorns",
"unicorns juvenile films",
"elves juvenile films",
"juvenile films elves"
] |
|
| Roswell delirium 2025 dvd scifi r841 2025 |
2025-03-13 | DVD/Videocassette | [
"drama human alien encounters",
"human alien encounters drama",
"drama nuclear warfare",
"nuclear warfare drama",
"drama mothers and daughters",
"mothers and daughters drama"
] |
|
| Star trek, lower decks. The final season 2025 dvd tvadult s79591s5 2025 |
2025-03-13 | DVD/Videocassette | [
"drama space ships",
"space ships drama",
"drama interplanetary voyages",
"interplanetary voyages drama",
"drama interstellar travel",
"interstellar travel drama",
"drama extraterrestrial beings",
"extraterrestrial beings drama"
] |
|
 |
Big cats, small world. 2025 dvd 599.75 b592 2025 |
2025-03-13 | DVD/Videocassette | [
"botswana felidae",
"felidae botswana"
] |
| Quantum leap. Season two. 2025 dvd tvadult q123s2 2025 |
2025-03-12 | DVD/Videocassette | [
"drama time travel",
"time travel drama",
"drama machinery",
"machinery drama",
"drama physicists",
"physicists drama",
"drama space and time",
"space and time drama",
"drama quantum jumps",
"quantum jumps drama",
"drama scientists",
"scientists drama"
] |
|
| Friends. Season 10 2019 dvd tvadult f911s10 2019 |
2025-03-10 | DVD/Videocassette | [
"drama friendship",
"friendship drama",
"drama man woman relationships",
"man woman relationships drama",
"drama new york n y",
"new york n y drama"
] |
|
| Friends. Season 9 2019 dvd tvadult f911s9 2019 |
2025-03-10 | DVD/Videocassette | [
"drama friendship",
"friendship drama",
"drama man woman relationships",
"man woman relationships drama",
"drama new york n y",
"new york n y drama"
] |
|
| Friends. Season 8 2019 dvd tvadult f911s8 2019 |
2025-03-10 | DVD/Videocassette | [
"drama friendship",
"friendship drama",
"drama man woman relationships",
"man woman relationships drama",
"drama new york n y",
"new york n y drama"
] |
|
| Friends. Season 7 2019 dvd tvadult f911s7 2019 |
2025-03-10 | DVD/Videocassette | [
"drama friendship",
"friendship drama",
"drama man woman relationships",
"man woman relationships drama",
"drama new york n y",
"new york n y drama"
] |
|
| Friends. Season 6 2019 dvd tvadult f911s6 2019 |
2025-03-10 | DVD/Videocassette | [
"drama friendship",
"friendship drama",
"drama man woman relationships",
"man woman relationships drama",
"drama new york n y",
"new york n y drama"
] |
|
| Friends. Season 5 2019 dvd tvadult f911s5 2019 |
2025-03-10 | DVD/Videocassette | [
"drama friendship",
"friendship drama",
"drama man woman relationships",
"man woman relationships drama",
"drama new york n y",
"new york n y drama"
] |
|
| Friends. Season 4 2019 dvd tvadult f911s4 201 |
2025-03-10 | DVD/Videocassette | [
"drama friendship",
"friendship drama",
"drama man woman relationships",
"man woman relationships drama",
"drama new york n y",
"new york n y drama"
] |
|
| Friends. Season 3. 2019 dvd tvadult f911s3 2019 |
2025-03-10 | DVD/Videocassette | [
"drama friendship",
"friendship drama",
"drama man woman relationships",
"man woman relationships drama",
"drama new york n y",
"new york n y drama"
] |
|
| Friends. Season 2 2019 dvd tvadult f911s2 2019 |
2025-03-10 | DVD/Videocassette | [
"drama friendship",
"friendship drama",
"drama man woman relationships",
"man woman relationships drama",
"drama new york n y",
"new york n y drama"
] |
|
| Friends. The complete first season [videorecording] 2019 dvd tvadult f911s1 2019 |
2025-03-10 | DVD/Videocassette | [
"drama friendship",
"friendship drama",
"drama man woman relationships",
"man woman relationships drama",
"drama new york n y",
"new york n y drama"
] |
|
| Riley 2025 dvd drama r573 2025 |
2025-03-10 | DVD/Videocassette | [
"drama high school students",
"high school students drama",
"closeted gay people drama",
"drama closeted gay people",
"coming out sexual orientation drama",
"drama coming out sexual orientation"
] |
|
| Good side of bad 2023 dvd drama g64613 2023 |
2025-03-10 | DVD/Videocassette | [
"film adaptations olevin beverly",
"olevin beverly film adaptations",
"drama siblings",
"siblings drama",
"drama financial crises",
"financial crises drama",
"drama psychoses",
"psychoses drama"
] |
|
 |
Women of World War II : the untold stories. 2025 dvd 940.53082 w8721 2025 |
2025-03-10 | DVD/Videocassette | [
"women world war 1939 1945 united states",
"world war 1939 1945 women united states",
"war work world war 1939 1945 women united states",
"women world war 1939 1945 war work united states",
"world war 1939 1945 war work women united states",
"women soldiers united states history 20th century",
"sex role united states history 20th century",
"women united states history 20th century"
] |
| The Klezmer project 2025 dvd 781.62924 k64 2025 |
2025-03-10 | DVD/Videocassette | [
"klezmer music",
"man woman relationships",
"motion pictures production and direction",
"production and direction motion pictures"
] |
|
| Every little thing 2025 dvd 598.764 e93 2025 |
2025-03-10 | DVD/Videocassette | [
"masear teresa e 1959",
"hummingbirds"
] |
|
| A woman of Paris 2025 dvd silent w8721 2025 |
2025-03-10 | DVD/Videocassette | [
"drama man woman relationships",
"man woman relationships drama",
"drama love",
"love drama",
"betrayal drama",
"drama betrayal"
] |
|
 |
Resistance : they fought back 2025 dvd 940.5318 r4331 2025 |
2025-03-10 | DVD/Videocassette | [
"holocaust jewish 1939 1945 poland warsaw",
"poland holocaust jewish 1939 1945 warsaw",
"warsaw holocaust jewish 1939 1945 poland",
"poland world war 1939 1945 warsaw",
"warsaw world war 1939 1945 poland",
"world war 1939 1945 poland warsaw",
"warsaw ghetto uprising 1943 warsaw poland history",
"warsaw poland history warsaw ghetto uprising 1943"
] |
| Tulsa King. Season two. 2024 dvd tvadult t924s2 2025 |
2025-03-10 | DVD/Videocassette | [
"drama mafia",
"mafia drama",
"drama organized crime",
"organized crime drama",
"drama interpersonal relations",
"interpersonal relations drama",
"drama tulsa okla",
"tulsa okla drama"
] |
|
| Guardians of the formula 2025 dvd world serbia g914 2025 |
2025-03-06 | DVD/Videocassette | [
"drama institut za nuklearne nauke boris kidric",
"institut za nuklearne nauke boris kidric drama",
"drama nuclear accidents serbia vinca grocka",
"nuclear accidents serbia vinca grocka drama",
"serbia nuclear accidents vinca grocka drama",
"vinca grocka nuclear accidents serbia drama",
"drama vinca grocka serbia history 20th century",
"vinca grocka serbia history 20th century drama",
"feature films serbia",
"serbia feature films"
] |
|
| The Penguin. The complete first season. 2025 dvd tvadult p398s1 2025 |
2025-03-06 | DVD/Videocassette | [
"drama supervillains",
"supervillains drama",
"drama gotham city imaginary place",
"gotham city imaginary place drama",
"drama gangsters",
"gangsters drama",
"crime drama",
"drama crime"
] |
|
| Separated 2025 dvd 325.73 s479 2025 |
2025-03-04 | DVD/Videocassette | [
"illegal immigration government policy united states",
"government policy illegal immigration united states",
"border security government policy united states",
"government policy border security united states",
"government policy noncitizens united states",
"noncitizens government policy united states",
"deportation social aspects united states",
"social aspects deportation united states",
"noncitizen children united states social conditions",
"social conditions noncitizen children united states",
"immigrant families united states social conditions",
"social conditions immigrant families united states"
] |
|
| Black Sunday 2020 dvd suspense b6275 2020 |
2025-03-04 | DVD/Videocassette | [
"film adaptations harris thomas 1940",
"harris thomas 1940 film adaptations",
"drama super bowl",
"super bowl drama",
"suspense in motion pictures television etc",
"drama terrorism",
"terrorism drama"
] |
|
| Frasier. Season two 2025 dvd tvadult f8421s2 2025 |
2025-03-04 | DVD/Videocassette | [
"boston mass psychiatrists drama",
"drama psychiatrists boston mass",
"psychiatrists boston mass drama",
"boston mass brothers drama",
"brothers boston mass drama",
"drama brothers boston mass",
"drama fathers and sons boston mass",
"boston mass fathers and sons drama",
"fathers and sons boston mass drama",
"boston mass man woman relationships drama",
"drama man woman relationships boston mass",
"man woman relationships boston mass drama",
"drama radio talk shows boston mass",
"boston mass radio talk shows drama",
"radio talk shows boston mass drama",
"radio programs boston mass drama",
"boston mass radio programs drama",
"drama radio programs boston mass",
"boston mass drama",
"drama boston mass"
] |
|
| Master crimes 2025 dvd tvadult m4233s1 2025 |
2025-03-03 | DVD/Videocassette | [
"criminal investigation drama",
"drama criminal investigation",
"college teachers drama",
"drama college teachers",
"drama women police chiefs",
"women police chiefs drama"
] |
|
| Hounds 2024 dvd world morocco h839 2024 |
2025-03-03 | DVD/Videocassette | [
"drama fathers and sons",
"fathers and sons drama",
"criminals drama",
"drama criminals",
"drama kidnapping",
"kidnapping drama",
"casablanca morocco drama",
"drama casablanca morocco",
"feature films morocco",
"morocco feature films"
] |
|
| Agent of happiness : a film 2025 954.98 a265 2025 |
2025-03-03 | DVD/Videocassette | [
"bhutan happiness",
"happiness bhutan",
"bhutan social life and customs",
"social life and customs bhutan",
"bhutan social conditions",
"social conditions bhutan",
"bhutan politics and government"
] |
|
| The real west 2025 dvd drama r2882 2025 |
2025-03-03 | DVD/Videocassette | [
"drama man woman relationships",
"man woman relationships drama",
"college teachers drama",
"drama college teachers",
"drama vacations",
"vacations drama",
"drama ranches",
"ranches drama"
] |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW new_titles_view AS select
json_object(
-- 'img_src', 'https://covers.openlibrary.org/b/isbn/0899080871-L.jpg',
'img_src',
'https://covers.openlibrary.org/b/isbn/' || json_extract(bib.isbn_values, '$[0]') || '-L.jpg',
'href',
'https://cincinnatilibrary.bibliocommons.com/v2/record/S170C' || bib.bib_record_num
) as jacket,
json_object(
--'img_src', 'https://placekitten.com/200/300',
'href',
'https://cincinnatilibrary.bibliocommons.com/v2/record/S170C' || bib.bib_record_num,
'label',
bib.best_title,
-- || coalesce(vol_statement, ''),
'title',
bib.best_title || coalesce('
' || bib.best_author, ''),
'description',
bib.best_author || '
' || bib.publish_year || coalesce ('
' || bib.bib_level_callnumber, '')
) as catalog_link,
cataloging_date,
-- isbn_values,
(
select
item_format
from
item
where
item.bib_record_num = bib.bib_record_num
group by
1
order by
count(*) DESC
limit
1
) as item_format,
indexed_subjects
from
bib
where
cataloging_date >= date('now', 'weekday 1', '-7 days', '-30 days')
order by
cataloging_date DESC;