new_titles_view (view)
5,999 rows
This data as json, CSV (advanced)
Suggested facets: cataloging_date (date)
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;