new_titles_view (view)
22 rows where item_format in ["New Release DVDs"]
This data as json, CSV (advanced)
| jacket | catalog_link | cataloging_date | item_format | indexed_subjects |
|---|---|---|---|---|
| 11 rebels 2025 dvd world japan e39 2025 |
2025-06-23 | New Release DVDs | [
"drama prisons",
"prisons drama",
"battles drama",
"drama battles",
"drama japan history",
"japan history drama"
] |
|
| Jigra 2025 dvd world india j61 2025 |
2025-06-23 | New Release DVDs | [
"drama siblings",
"siblings drama",
"drama judicial error",
"judicial error drama",
"drama rescues",
"rescues drama"
] |
|
| Bad newz 2025 dvd world india b132 2025 |
2025-06-23 | New Release DVDs | [
"drama man woman relationships",
"man woman relationships drama",
"drama unplanned pregnancy",
"unplanned pregnancy drama",
"drama triangles interpersonal relations",
"triangles interpersonal relations drama"
] |
|
| Snow White 2025 dvd children s6748 2025 |
2025-06-23 | New Release DVDs | [
"juvenile films snow white fictitious character from walt disney pictures",
"snow white fictitious character from walt disney pictures juvenile films",
"juvenile films princesses",
"princesses juvenile films",
"juvenile films revolutions",
"revolutions juvenile films",
"juvenile films snow white tale",
"snow white tale juvenile films"
] |
|
| A Minecraft movie 2025 dvd children m664 2025 |
2025-06-23 | New Release DVDs | [
"film adaptations minecraft game",
"minecraft game film adaptations",
"drama quests expeditions",
"quests expeditions drama",
"drama interpersonal relations",
"interpersonal relations drama",
"creative ability drama",
"drama creative ability"
] |
|
| The assessment 2025 dvd scifi a846 2025 |
2025-06-13 | New Release DVDs | [
"drama parenthood",
"parenthood drama",
"drama testing",
"testing drama",
"drama dystopias",
"dystopias drama"
] |
|
| Novocaine 2025 dvd action n945 2025 |
2025-06-13 | New Release DVDs | [
"congenital insensitivity to pain drama",
"drama congenital insensitivity to pain",
"drama kidnapping",
"kidnapping drama",
"drama man woman relationships",
"man woman relationships drama"
] |
|
| The monkey 2025 dvd horror m745 2025 |
2025-06-13 | New Release DVDs | [
"film adaptations king stephen 1947",
"king stephen 1947 film adaptations",
"brothers drama",
"drama brothers",
"drama toys",
"toys drama",
"death drama",
"drama death"
] |
|
| Bridget Jones. Mad about the boy 2025 dvd comedy b8513m 2025 |
2025-06-11 | New Release DVDs | [
"fielding helen 1958 film adaptations",
"film adaptations fielding helen 1958",
"drama jones bridget fictitious character",
"jones bridget fictitious character drama",
"widows drama",
"drama widows",
"single mothers drama",
"drama single mothers",
"dating social customs drama",
"drama dating social customs",
"drama man woman relationships",
"man woman relationships drama"
] |
|
| Gunslingers 2025 dvd western g9761 2025 |
2025-06-10 | New Release DVDs | [
"drama outlaws kentucky",
"kentucky outlaws drama",
"outlaws kentucky drama",
"drama revenge",
"revenge drama",
"drama kentucky",
"kentucky drama"
] |
|
| Call the midwife. Season fourteen 2025 dvd tvadult c156s14 2025 |
2025-06-10 | New Release DVDs | [
"television adaptations worth jennifer 1935 2011",
"worth jennifer 1935 2011 television adaptations",
"drama midwives england london history 20th century",
"midwives england london history 20th century drama",
"london midwives england history 20th century drama",
"england midwives london history 20th century drama",
"drama midwifery england london",
"midwifery england london drama",
"england midwifery london drama",
"london midwifery england drama",
"london nuns england history 20th century drama",
"england nuns london history 20th century drama",
"nuns england london history 20th century drama",
"drama nuns england london history 20th century",
"pregnant women england london history 20th century drama",
"london pregnant women england history 20th century drama",
"drama pregnant women england london history 20th century",
"england pregnant women london history 20th century drama",
"convents england london history 20th century drama",
"drama convents england london history 20th century",
"london convents england history 20th century drama",
"england convents london history 20th century drama",
"drama east end london england history 20th century",
"east end london england history 20th century drama"
] |
|
| A working man 2025 dvd action w926 2025 |
2025-06-05 | New Release DVDs | [
"drama missing persons",
"missing persons drama",
"criminals drama",
"drama criminals"
] |
|
| Los Frikis 2025 dvd drama f912 2025 |
2025-06-03 | New Release DVDs | [
"cuba musicians drama",
"drama musicians cuba",
"musicians cuba drama",
"drama liberty",
"liberty drama",
"drama human rights",
"human rights drama",
"cuba drama",
"drama cuba"
] |
|
| The wedding banquet 2025 dvd comedy w38813 2025 |
2025-06-03 | New Release DVDs | [
"gay men family relationships korea drama",
"korea gay men family relationships drama",
"drama gay men family relationships korea",
"family relationships gay men korea drama",
"drama gay couples united states",
"gay couples united states drama",
"koreans united states drama",
"drama koreans united states",
"drama parent and adult child",
"parent and adult child drama",
"drama families",
"families drama",
"drama interethnic dating united states",
"interethnic dating united states drama",
"noncitizens united states drama",
"drama noncitizens united states",
"social aspects marriage korea drama",
"korea marriage social aspects drama",
"drama marriage social aspects korea",
"marriage social aspects korea drama",
"drama illegal immigration united states",
"illegal immigration united states drama"
] |
|
| Borderline 2025 dvd horror b728 2025 |
2025-06-03 | New Release DVDs | [
"drama musicians",
"musicians drama",
"drama stalkers",
"stalkers drama",
"drama hostages",
"hostages drama"
] |
|
| In the lost lands 2025 dvd action i357 2025 |
2025-06-03 | New Release DVDs | [
"drama magic",
"magic drama",
"drama quests expeditions",
"quests expeditions drama",
"drama monsters",
"monsters drama",
"drama dystopias",
"dystopias drama"
] |
|
| Holy cow 2025 dvd world france h7613 2025 |
2025-06-03 | New Release DVDs | [
"dairy products industry france drama",
"drama dairy products industry france",
"france dairy products industry drama",
"drama orphans",
"orphans drama"
] |
|
| The friend 2025 dvd drama f9114 2025 |
2025-06-03 | New Release DVDs | [
"film adaptations nunez sigrid",
"nunez sigrid film adaptations",
"human animal relationships fiction",
"female friendship fiction",
"grief fiction"
] |
|
| The night they came home 2025 dvd western n6872 2025 |
2025-05-28 | New Release DVDs | [
"drama frontier and pioneer life",
"frontier and pioneer life drama",
"criminals drama",
"drama criminals",
"drama revenge",
"revenge drama"
] |
|
| Layla 2024 dvd drama l427 2024 |
2025-05-28 | New Release DVDs | [
"drag queens drama",
"drama drag queens",
"drama identity psychology",
"identity psychology drama"
] |
|
| Lost on a mountain in Maine 2025 dvd drama l88121 2025 |
2025-05-28 | New Release DVDs | [
"drama fendler donn 1926 2016",
"fendler donn 1926 2016 drama",
"katahdin mount survival maine drama",
"survival maine katahdin mount drama",
"maine survival katahdin mount drama",
"drama survival maine katahdin mount",
"maine wilderness survival katahdin mount drama",
"katahdin mount wilderness survival maine drama",
"wilderness survival maine katahdin mount drama",
"drama wilderness survival maine katahdin mount",
"drama boys new york state rye",
"boys new york state rye drama",
"rye boys new york state drama",
"new york state boys rye drama",
"children new york state rye drama biography",
"drama children new york state rye biography",
"rye children new york state drama biography",
"new york state children rye drama biography",
"katahdin mount me drama",
"drama katahdin mount me"
] |
|
 |
Twilight of the warriors : walled in 2024 dvd world china t9721 2024 |
2025-05-28 | New Release DVDs | [
"china organized crime hong kong drama",
"hong kong organized crime china drama",
"organized crime china hong kong drama",
"drama organized crime china hong kong",
"china criminals hong kong drama",
"criminals china hong kong drama",
"drama criminals china hong kong",
"hong kong criminals china drama",
"exclaves drama",
"drama exclaves",
"drama hand to hand fighting",
"hand to hand fighting drama",
"triads organized crime drama",
"drama triads organized crime",
"drama hong kong china",
"hong kong china drama",
"china feature films",
"feature films china"
] |
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;