new_titles_view (view)
21 rows where item_format in ["New Release DVDs"]
This data as json, CSV (advanced)
Suggested facets: cataloging_date, cataloging_date (date), indexed_subjects (array)
| jacket | catalog_link | cataloging_date | item_format | indexed_subjects |
|---|---|---|---|---|
| Marcello Mio 2024 dvd world france m314 2024 |
2025-03-31 | New Release DVDs | [
"drama mastroianni chiara 1972",
"mastroianni chiara 1972 drama",
"mastroianni marcello 1924 1996 drama",
"drama mastroianni marcello 1924 1996",
"drama motion picture actors and actresses france",
"france motion picture actors and actresses drama",
"motion picture actors and actresses france drama",
"drama motion picture actors and actresses italy",
"motion picture actors and actresses italy drama",
"italy motion picture actors and actresses drama",
"drama families",
"families drama",
"drama father and child",
"father and child drama",
"drama impersonation",
"impersonation drama"
] |
|
| Laws of man 2025 dvd suspense l425 2025 |
2025-03-31 | New Release DVDs | [
"investigation murder drama",
"drama murder investigation",
"murder investigation drama",
"drama united states marshals",
"united states marshals drama",
"conspiracies drama",
"drama conspiracies",
"drama fugitives from justice",
"fugitives from justice drama"
] |
|
| Customs frontline 2025 dvd world china c987 2025 |
2025-03-31 | New Release DVDs | [
"china customs administration hong kong drama",
"customs administration china hong kong drama",
"drama customs administration china hong kong",
"hong kong customs administration china drama",
"drama undercover operations",
"undercover operations drama"
] |
|
| One of them days 2025 dvd comedy o5812 2025 |
2025-03-28 | New Release DVDs | [
"drama female friendship",
"female friendship drama",
"drama interpersonal relations",
"interpersonal relations drama",
"drama rent",
"rent drama"
] |
|
| Love hurts 2025 dvd comedy l89714 2025 |
2025-03-28 | New Release DVDs | [
"drama real estate agents",
"real estate agents drama",
"drama assassins",
"assassins drama",
"revenge drama",
"drama revenge",
"criminals drama",
"drama criminals",
"drama life change events",
"life change events drama",
"martial arts drama",
"drama martial arts",
"drama milwaukee wis",
"milwaukee wis drama"
] |
|
| Flight risk 2025 dvd action f6213 2025 |
2025-03-28 | New Release DVDs | [
"drama sky marshals",
"sky marshals drama",
"air travel drama",
"drama air travel",
"drama false personation",
"false personation drama"
] |
|
| Mufasa, the Lion King 2025 dvd children m949 2025 |
2025-03-28 | New Release DVDs | [
"juvenile films mufasa fictitious character",
"mufasa fictitious character juvenile films",
"juvenile films lion",
"lion juvenile films",
"juvenile films kings and rulers",
"kings and rulers juvenile films"
] |
|
| The room next door 2025 dvd drama r7774 2025 |
2025-03-21 | New Release DVDs | [
"drama interpersonal relations",
"interpersonal relations drama",
"drama female friendship",
"female friendship drama",
"death drama",
"drama death",
"drama empathy",
"empathy drama"
] |
|
| Into the deep 2025 dvd horror i614 2025 |
2025-03-21 | New Release DVDs | [
"drama pirates",
"pirates drama",
"drama tourists",
"tourists drama",
"drama scuba diving",
"scuba diving drama",
"drama treasure troves",
"treasure troves drama",
"drama shark attacks",
"shark attacks drama"
] |
|
| Dog Man 2025 dvd children d6544 2025 |
2025-03-21 | New Release DVDs | [
"dog man fictitious character juvenile films",
"juvenile films dog man fictitious character",
"dogs juvenile films",
"juvenile films dogs",
"juvenile films police",
"police juvenile films"
] |
|
| Companion 2025 dvd suspense c7373 2025 |
2025-03-21 | New Release DVDs | [
"drama man woman relationships",
"man woman relationships drama",
"androids drama",
"drama androids",
"crime drama",
"drama crime"
] |
|
| Chosen family 2023 dvd comedy c551 2023 |
2025-03-14 | New Release DVDs | [
"drama yoga teachers",
"yoga teachers drama",
"drama man woman relationships",
"man woman relationships drama",
"drama families",
"families drama"
] |
|
| Know mercy 2024 dvd scifi k731 2024 |
2025-03-13 | New Release DVDs | [
"drama immortality",
"immortality drama",
"drama man woman relationships",
"man woman relationships drama",
"drama scientists",
"scientists drama"
] |
|
| Gunner 2025 dvd action g9761 2025 |
2025-03-13 | New Release DVDs | [
"drama kidnapping",
"kidnapping drama",
"drama rescues",
"rescues drama",
"drama fathers and sons",
"fathers and sons drama",
"drama veterans",
"veterans drama"
] |
|
| Alien rubicon 2025 dvd scifi a39893 2025 |
2025-03-13 | New Release DVDs | [
"drama human alien encounters",
"human alien encounters drama",
"drama unidentified flying objects",
"unidentified flying objects drama"
] |
|
| Wolf Man 2025 dvd horror w8543 2025 |
2025-03-13 | New Release DVDs | [
"animal attacks drama",
"drama animal attacks",
"drama werewolves",
"werewolves drama",
"drama families",
"families drama"
] |
|
| Moana 2 2025 dvd children m687t 2025 |
2025-03-13 | New Release DVDs | [
"gods juvenile films",
"juvenile films gods",
"juvenile films voyages and travels",
"voyages and travels juvenile films",
"juvenile films polynesians",
"polynesians juvenile films",
"juvenile films oceania",
"oceania juvenile films"
] |
|
| Cash for gold 2024 dvd drama c3381 2024 |
2025-03-10 | New Release DVDs | [
"drama holidays",
"holidays drama",
"drama single mothers",
"single mothers drama",
"drama widows",
"widows drama",
"drama secrecy",
"secrecy drama"
] |
|
 |
The 4:30 movie 2024 dvd comedy f7736 2024 |
2025-03-10 | New Release DVDs | [
"male friendship fiction",
"high school students fiction",
"teenagers conduct of life fiction",
"conduct of life teenagers fiction",
"teenage boys fiction",
"teenage girls fiction",
"employees motion picture theaters fiction",
"motion picture theaters employees fiction",
"man woman relationships fiction"
] |
| The Count of Monte Cristo 2025 dvd world france c855 2025 |
2025-03-06 | New Release DVDs | [
"dumas alexandre 1802 1870 film adaptations",
"film adaptations dumas alexandre 1802 1870",
"drama betrayal",
"betrayal drama",
"drama false imprisonment",
"false imprisonment drama",
"drama revenge",
"revenge drama",
"drama nobility",
"nobility drama",
"drama france history 19th century",
"france history 19th century drama",
"france feature films",
"feature films france"
] |
|
| September 5 2025 dvd drama s4793 2025 |
2025-03-06 | New Release DVDs | [
"drama olympic games 20th 1972 munich germany",
"olympic games 20th 1972 munich germany drama",
"journalism drama",
"drama journalism",
"drama journalists",
"journalists drama",
"athletes violence against germany munich drama",
"drama athletes violence against germany munich",
"munich athletes violence against germany drama",
"violence against athletes germany munich drama",
"germany athletes violence against munich drama",
"munich israelis violence against germany drama",
"drama israelis violence against germany munich",
"violence against israelis germany munich drama",
"germany israelis violence against munich drama",
"israelis violence against germany munich drama",
"germany terrorism munich drama",
"terrorism germany munich drama",
"drama terrorism germany munich",
"munich terrorism germany drama",
"drama hostages",
"hostages 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;