new_titles_view (view)
42 rows where item_format in ["New Release DVDs"]
This data as json, CSV (advanced)
Suggested facets: cataloging_date, cataloging_date (date)
| jacket | catalog_link | cataloging_date | item_format | indexed_subjects |
|---|---|---|---|---|
| Finding Tony 2024 dvd drama f4947 2024 |
2024-11-22 | New Release DVDs | [
"drama mental illness",
"mental illness drama",
"basketball players drama",
"drama basketball players",
"drama fate and fatalism",
"fate and fatalism drama",
"drama redemption",
"redemption drama"
] |
|
| Between the temples 2024 dvd comedy b5654 2024 |
2024-11-22 | New Release DVDs | [
"drama grief",
"grief drama",
"drama faith",
"faith drama",
"drama judaism",
"judaism drama",
"cantors judaism drama",
"drama cantors judaism"
] |
|
| Slotherhouse 2023 dvd horror s6342 2023 |
2024-11-22 | New Release DVDs | [
"college students drama",
"drama college students",
"drama sloths",
"sloths drama",
"college sorority members drama",
"drama college sorority members"
] |
|
| Reagan 2024 dvd drama r2871 2024 |
2024-11-22 | New Release DVDs | [
"kengor paul 1966 film adaptations",
"film adaptations kengor paul 1966",
"political and social views reagan ronald drama",
"reagan ronald political and social views drama",
"drama reagan ronald political and social views",
"reagan ronald influence drama",
"drama reagan ronald influence",
"influence reagan ronald drama",
"communism history 20th century drama",
"drama communism history 20th century",
"communism soviet union drama",
"drama communism soviet union",
"soviet union communism drama",
"foreign relations united states 1981 1989 drama",
"drama united states foreign relations 1981 1989",
"united states foreign relations 1981 1989 drama",
"foreign relations united states soviet union drama",
"drama united states foreign relations soviet union",
"soviet union united states foreign relations drama",
"united states foreign relations soviet union drama",
"foreign relations soviet union united states drama",
"soviet union foreign relations united states drama",
"drama soviet union foreign relations united states",
"communist countries united states foreign relations drama",
"drama united states foreign relations communist countries",
"united states foreign relations communist countries drama",
"foreign relations united states communist countries drama",
"communist countries foreign relations united states drama",
"drama communist countries foreign relations united states",
"foreign relations communist countries united states drama",
"united states politics and government 1981 1989 drama",
"drama united states politics and government 1981 1989"
] |
|
| All shall be well 2024 dvd world china a416 2024 |
2024-11-22 | New Release DVDs | [
"drama lesbians",
"lesbians drama",
"drama mercy",
"mercy drama",
"dignity drama",
"drama dignity",
"drama families",
"families drama",
"china feature films",
"feature films china"
] |
|
| Dead money 2024 dvd suspense d2789 2024 |
2024-11-22 | New Release DVDs | [
"drama poker players",
"poker players drama",
"drama poker",
"poker drama",
"drama robbery",
"robbery drama",
"drama gambling",
"gambling drama"
] |
|
| The dead don't hurt 2024 dvd western d2785 2024 |
2024-11-22 | New Release DVDs | [
"man woman relationships drama",
"drama man woman relationships",
"drama immigrants",
"immigrants drama",
"civil war 1861 1865 united states history drama",
"drama united states history civil war 1861 1865",
"united states history civil war 1861 1865 drama",
"drama nevada",
"nevada drama"
] |
|
| The critic 2024 dvd suspense c934 2024 |
2024-11-22 | New Release DVDs | [
"film adaptations quinn anthony 1964",
"quinn anthony 1964 film adaptations",
"drama critics",
"critics drama",
"drama theater",
"theater drama",
"drama extortion",
"extortion drama",
"actresses drama",
"drama actresses"
] |
|
| A sudden case of Christmas 2024 dvd comedy s943 2024 |
2024-11-18 | New Release DVDs | [
"drama families",
"families drama",
"drama holidays",
"holidays drama",
"drama hotels",
"hotels drama",
"drama italy",
"italy drama"
] |
|
| Escaping Ohio 2024 dvd comedy e741 2024 |
2024-11-18 | New Release DVDs | [
"drama man woman relationships",
"man woman relationships drama",
"drama moving household",
"moving household drama",
"drama young adults",
"young adults drama",
"drama ohio",
"ohio drama"
] |
|
| The Christmas letter 2024 dvd comedy c55591 2024 |
2024-11-18 | New Release DVDs | [
"christmas plays",
"drama friendship",
"friendship drama",
"drama envy",
"envy drama"
] |
|
| Bank of Dave 2023 dvd comedy b2181 2023 |
2024-11-18 | New Release DVDs | [
"drama fishwick dave",
"fishwick dave drama",
"banks and banking drama",
"drama banks and banking",
"drama rich people",
"rich people drama"
] |
|
| The good half 2024 dvd drama g64612 2024 |
2024-11-18 | New Release DVDs | [
"drama grief",
"grief drama",
"drama homecoming",
"homecoming drama",
"drama interpersonal relations",
"interpersonal relations drama",
"cleveland ohio drama",
"drama cleveland ohio"
] |
|
| The killer's game 2024 dvd action k4893 2024 |
2024-11-15 | New Release DVDs | [
"bonansinga jay r film adaptations",
"film adaptations bonansinga jay r",
"drama terminally ill",
"terminally ill drama",
"assassins drama",
"drama assassins"
] |
|
| Speak no evil 2024 dvd horror s7412 2024 |
2024-11-15 | New Release DVDs | [
"drama families",
"families drama",
"americans great britain drama",
"drama americans great britain",
"great britain americans drama",
"drama vacations",
"vacations drama"
] |
|
| Beetlejuice Beetlejuice 2024 dvd horror b415b 2024 |
2024-11-15 | New Release DVDs | [
"families drama",
"drama families",
"drama goth culture subculture new england",
"goth culture subculture new england drama",
"new england goth culture subculture drama",
"drama haunted houses new england",
"new england haunted houses drama",
"haunted houses new england drama",
"drama new england",
"new england drama"
] |
|
| Godzilla minus one 2024 dvd world japan g592gm 2024 |
2024-11-15 | New Release DVDs | [
"drama godzilla fictitious character",
"godzilla fictitious character drama",
"drama atomic bomb japan history",
"atomic bomb japan history drama",
"japan atomic bomb history drama",
"postwar reconstruction japan drama",
"drama postwar reconstruction japan",
"japan postwar reconstruction drama",
"drama monsters japan",
"japan monsters drama",
"monsters japan drama",
"feature films japan",
"japan feature films"
] |
|
| The thicket 2024 dvd western t428 2024 |
2024-11-12 | New Release DVDs | [
"drama orphans",
"orphans drama",
"drama kidnapping",
"kidnapping drama",
"drama texas east",
"texas east drama"
] |
|
| Homestead 2024 dvd western h767 2024 |
2024-11-12 | New Release DVDs | [
"drama frontier and pioneer life",
"frontier and pioneer life drama",
"drama outlaws",
"outlaws drama",
"drama survival",
"survival drama"
] |
|
| The silent hour 2024 dvd suspense s5821 2024 |
2024-11-12 | New Release DVDs | [
"police drama",
"drama police",
"detectives drama",
"drama detectives",
"drama hard of hearing people",
"hard of hearing people drama",
"deaf people drama",
"drama deaf people",
"witnesses drama",
"drama witnesses",
"drama murder",
"murder drama"
] |
|
| Baghead 2024 dvd horror b144 2024 |
2024-11-12 | New Release DVDs | [
"drama inheritance and succession",
"inheritance and succession drama",
"drama mediums",
"mediums drama",
"drama monsters",
"monsters drama"
] |
|
| All happy families 2024 dvd comedy a4165 2024 |
2024-11-12 | New Release DVDs | [
"brothers drama",
"drama brothers",
"actors drama",
"drama actors",
"drama families",
"families drama",
"drama family secrets",
"family secrets drama"
] |
|
| Dance first 2024 dvd drama d1736 2024 |
2024-11-12 | New Release DVDs | [
"beckett samuel 1906 1989 drama",
"drama beckett samuel 1906 1989",
"drama english drama irish authors",
"english drama irish authors drama",
"irish authors english drama drama"
] |
|
| You gotta believe 2024 dvd children y67 2024 |
2024-11-12 | New Release DVDs | [
"juvenile films little league baseball",
"little league baseball juvenile films",
"baseball players juvenile films",
"juvenile films baseball players"
] |
|
| The last breath 2024 dvd horror l34912 2024 |
2024-11-12 | New Release DVDs | [
"drama scuba diving",
"scuba diving drama",
"drama shipwrecks",
"shipwrecks drama",
"drama shark attacks",
"shark attacks drama"
] |
|
| Skincare 2024 dvd suspense s628 2024 |
2024-11-12 | New Release DVDs | [
"businesswomen drama",
"drama businesswomen",
"cosmetics industry drama",
"drama cosmetics industry",
"conspiracies drama",
"drama conspiracies"
] |
|
| Cabrini 2024 dvd drama c117 2024 |
2024-11-08 | New Release DVDs | [
"cabrini frances xavier saint 1850 1917 drama",
"drama cabrini frances xavier saint 1850 1917",
"drama christian saints italy biography",
"christian saints italy biography drama",
"italy christian saints biography drama",
"christian saints united states biography drama",
"drama christian saints united states biography",
"new york state immigrants new york drama",
"drama immigrants new york state new york",
"immigrants new york state new york drama",
"new york immigrants new york state drama",
"italians united states drama",
"drama italians united states",
"new york n y social conditions 19th century drama",
"social conditions new york n y 19th century drama",
"drama new york n y social conditions 19th century"
] |
|
| National anthem 2024 dvd drama n2772 2024 |
2024-11-07 | New Release DVDs | [
"drama lgbtq+ people",
"lgbtq+ people drama",
"drama rodeo performers new mexico",
"new mexico rodeo performers drama",
"rodeo performers new mexico drama"
] |
|
 |
Subservience 2024 dvd scifi s941 2024 |
2024-11-05 | New Release DVDs | [
"artificial intelligence drama",
"drama artificial intelligence",
"androids drama",
"drama androids",
"drama families",
"families drama"
] |
| The Crow 2024 dvd scifi c9531 2024 |
2024-11-01 | New Release DVDs | [
"film adaptations obarr j",
"obarr j film adaptations",
"drama crow fictitious character",
"crow fictitious character drama",
"drama revenge",
"revenge drama",
"drama supernatural",
"supernatural drama",
"drama organized crime",
"organized crime drama"
] |
|
| It ends with us 2024 dvd drama i885 2024 |
2024-11-01 | New Release DVDs | [
"film adaptations hoover colleen",
"hoover colleen film adaptations",
"businesswomen fiction",
"first loves fiction",
"neurosurgeons fiction",
"man woman relationships fiction",
"triangles interpersonal relations fiction",
"intimate partner violence fiction",
"boston mass fiction"
] |
|
| Afraid 2024 dvd scifi a2583 2024 |
2024-11-01 | New Release DVDs | [
"artificial intelligence drama",
"drama artificial intelligence",
"drama families",
"families drama"
] |
|
| Blink twice 2024 dvd suspense b6481 2024 |
2024-11-01 | New Release DVDs | [
"drama man woman relationships",
"man woman relationships drama",
"billionaires drama",
"drama billionaires",
"drama survival",
"survival drama",
"drama sexual assault",
"sexual assault drama"
] |
|
| Apartment 7A 2024 dvd horror a6392 2024 |
2024-11-01 | New Release DVDs | [
"film adaptations levin ira 1929 2007",
"levin ira 1929 2007 film adaptations",
"dancers drama",
"drama dancers",
"dancing injuries drama",
"drama dancing injuries",
"fame drama",
"drama fame",
"apartment houses drama",
"drama apartment houses",
"demonology drama",
"drama demonology",
"new york n y drama",
"drama new york n y"
] |
|
| Trap 2024 dvd suspense t773 2024 |
2024-11-01 | New Release DVDs | [
"drama fathers and daughters",
"fathers and daughters drama",
"drama rock concerts",
"rock concerts drama"
] |
|
| Another happy day 2024 dvd drama a6153 2024 |
2024-10-24 | New Release DVDs | [
"drama postpartum depression",
"postpartum depression drama",
"aunts drama",
"drama aunts",
"drama mothers",
"mothers drama"
] |
|
| Strange darling 2024 dvd suspense s8977 2024 |
2024-10-24 | New Release DVDs | [
"drama serial murderers",
"serial murderers drama",
"drama man woman relationships",
"man woman relationships drama"
] |
|
| Rocky aur Rani kii prem kahaani 2024 dvd world india r684 2024 |
2024-10-24 | New Release DVDs | [
"drama man woman relationships",
"man woman relationships drama",
"drama grandparents",
"grandparents drama",
"drama grandparent and child",
"grandparent and child drama",
"drama india",
"india drama"
] |
|
| School of Magical Animals 2 2024 dvd children s372t 2024 |
2024-10-22 | New Release DVDs | [
"auer margit 1967 film adaptations",
"film adaptations auer margit 1967",
"juvenile films schools",
"schools juvenile films",
"animals juvenile films",
"juvenile films animals",
"juvenile films magic",
"magic juvenile films",
"juvenile films musicals",
"musicals juvenile films"
] |
|
| Blood and snow 2024 dvd horror b6559 2024 |
2024-10-22 | New Release DVDs | [
"drama scientists",
"scientists drama",
"drama meteors",
"meteors drama",
"drama survival",
"survival drama"
] |
|
| Guthlee Ladoo 2024 dvd world india g984 2024 |
2024-10-21 | New Release DVDs | [
"caste based discrimination india drama",
"drama caste based discrimination india",
"india caste based discrimination drama",
"drama poor children",
"poor children drama",
"drama school principals",
"school principals drama",
"feature films india",
"india feature films"
] |
|
| Día de muertos 2024 dvd world mexico d536 2024 |
2024-10-21 | New Release DVDs | [
"all souls day mexico drama",
"drama all souls day mexico",
"mexico all souls day drama",
"drama grief",
"grief drama",
"death drama",
"drama death",
"drama mexico",
"mexico drama",
"feature films mexico",
"mexico feature films"
] |
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;