item_view (view)

81 rows where location_code = "ycmus"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: item_format, item_callnumber, best_author, best_title, agency_code_num, item_status_name, last_circ_act_date, checkout_total, renewal_total, item_price, publish_year, creation_date (date), last_circ_act_date (date)

item_record_num volume_record_num bib_record_num creation_date barcode item_format location_code location_name branch_name item_callnumber vol_statement best_author best_title agency_code_num item_status_code item_status_name last_circ_act_date checkout_date due_date checkout_total renewal_total item_price publish_year
9341472   3254692 2017-04-21 A000055322192 Book ycmus Cincinnati Museum Center Main Library 306.8743 k811 2017   Komisar, Erica, author. Being there : why prioritizing motherhood in the first three years matters 1 - CHECK SHELVES 2018-07-06     4 12 26.0 2017
7625774   2945201 2014-03-13 A000040616799 Book ycmus Cincinnati Museum Center Main Library 649.1 c7521 2014   Conley, Dalton, 1969- Parentology : everything you wanted to know about the science of raising children but were too exhausted to ask 1 - CHECK SHELVES 2015-11-19     4 26 25.0 2014
3627360   1848987 2012-06-30 1044386948019 Juvenile Book ycmus Cincinnati Museum Center Main Library 242.62 h515   Hennessy, B. G. (Barbara G.) The book of thanks 1 - CHECK SHELVES 2019-10-01     32 10 12.0 2002
5198427   2597955 2012-07-02 A000011994340 Juvenile Book ycmus Cincinnati Museum Center Main Library 294.536 d553   Dickmann, Nancy. Diwali 1 - CHECK SHELVES 2019-10-22     13 13 21.5 2011
6140815   2670853 2012-07-03 1803843-1001 Juvenile Book ycmus Cincinnati Museum Center Main Library 294.536 p672   Pirotta, Saviour. Divali 1 - CHECK SHELVES 2019-10-17     9 12 21.25 2008
6061888   2596868 2012-07-03 1663879-1001 Juvenile Book ycmus Cincinnati Museum Center Main Library 294.536 t866   Trueit, Trudi Strain. Diwali 1 - CHECK SHELVES 2019-10-15     13 13 20.5 2007
3589943   1380217 2012-06-30 0966684848015 Juvenile Book ycmus Cincinnati Museum Center Main Library 393.90972 qa542   Ancona, George. Pablo remembers : the fiesta of the Day of the Dead 1 - CHECK SHELVES 2019-10-08     38 2 14.93 1993
3719889   1823703 2012-06-30 1021229348052 Juvenile Book ycmus Cincinnati Museum Center Main Library 394.264 a617 v   Ansary, Mir Tamim. Veterans Day 1 - CHECK SHELVES 2019-01-16     19 10 19.95 1999
5177973   2633593 2012-07-02 1672830-1007 Juvenile Book ycmus Cincinnati Museum Center Main Library 394.264 a617 v   Ansary, Mir Tamim. Veterans Day 1 - CHECK SHELVES 2018-11-24     11 11 25.36 2006
5615150   2542409 2012-07-02 1653206-1012 Juvenile Book ycmus Cincinnati Museum Center Main Library 394.264 n429   Nelson, Robin, 1971- Veterans Day 1 - CHECK SHELVES 2019-01-24     13 17 18.6 2005
4145490   1451745 2012-06-30 0975092048035 Juvenile Book ycmus Cincinnati Museum Center Main Library 394.264 ql345   Lasky, Kathryn. Days of the Dead 1 - CHECK SHELVES 2016-11-03     42 2 15.89 1994
3462009   1931683 2012-06-30 1033090748047 Juvenile Book ycmus Cincinnati Museum Center Main Library 394.2646 qa481   Amado, Elisa. Barrilete : a kite for the Day of the Dead 1 - CHECK SHELVES       13 2 15.95 1999
3523746   1809242 2012-06-30 1043926148031 Juvenile Book ycmus Cincinnati Museum Center Main Library 394.266 s238   San Vicente, Luis. Festival of the bones : the little-bitty book for the day of the dead = El festival de las calaveras 1 - CHECK SHELVES 2017-11-07     22 0 14.95 2002
4159806   1658170 2012-06-30 1000923048010 Juvenile Book ycmus Cincinnati Museum Center Main Library 508 b355   Baxter, Nicola. Autumn 1 - CHECK SHELVES 2018-10-25     33 7 15.0 1996
3400984   1144653 2012-06-30 0940304048017 Juvenile Book ycmus Cincinnati Museum Center Main Library 508 qt484 a   Thomson, Ruth. Autumn 1 - CHECK SHELVES 2018-09-17     81 10 11.4 1989
3448494   1927641 2012-06-30 1033032048027 Juvenile Book ycmus Cincinnati Museum Center Main Library 508.2 k65   Amoroso, Cynthia. Fall 1 - CHECK SHELVES 2018-12-04     46 18 21.36 2001
4556451   1891704 2012-06-30 1029311948028 Juvenile Book ycmus Cincinnati Museum Center Main Library 508.2 qb974   Burton, Jane. The nature and science of autumn 1 - CHECK SHELVES 2019-10-16     48 26 15.95 1999
3035034   1512511 2012-06-29 1009732248059 Juvenile Book ycmus Cincinnati Museum Center Main Library 508.2 s257   Saunders-Smith, Gail. Autumn 1 - CHECK SHELVES 2019-01-08     51 20 9.95 1998
3274315   1809226 2012-06-30 1013907648044 Juvenile Book ycmus Cincinnati Museum Center Main Library 581.48 qr634   Robbins, Ken. Autumn leaves 1 - CHECK SHELVES 2018-12-06     35 17 15.95 1998
4524896   1557176 2012-06-30 734176-35032 Juvenile Book ycmus Cincinnati Museum Center Main Library 581.48 s257   Saunders-Smith, Gail. Autumn leaves 1 - CHECK SHELVES 2018-10-26     27 24 15.5 1998
4634158   1707714 2012-06-30 A000029739372 Juvenile Book ycmus Cincinnati Museum Center Main Library 582.16 qb967 , 1998   Burns, Diane L. Trees, leaves, and bark 1 - CHECK SHELVES 2018-12-23     41 24 13.95 1998
4536030   1564434 2012-06-30 1006958248029 Juvenile Book ycmus Cincinnati Museum Center Main Library 631.55 s257   Saunders-Smith, Gail. Fall harvest 1 - CHECK SHELVES 2019-10-28     46 16 9.95 1998
7181250   2872990 2013-06-07 A000029280096 Juvenile Book ycmus Cincinnati Museum Center Main Library 634.11 f316 2013   Felix, Rebecca, 1984- We harvest apples in fall 1 - CHECK SHELVES 2019-10-09     14 10 22.79 2013
4204741   1722504 2012-06-30 1001913148018 Juvenile Book ycmus Cincinnati Museum Center Main Library 634.11092 qa648 zd, 1996   Demuth, Patricia. Johnny Appleseed 1 - CHECK SHELVES 2019-10-12     42 8 11.95 1996
4473871   1736551 2012-06-30 1005859748046 Juvenile Book ycmus Cincinnati Museum Center Main Library 634.115 s257   Saunders-Smith, Gail. Picking apples 1 - CHECK SHELVES 2019-10-09     35 10 9.95 1998
3922776   1754116 2012-06-30 1024378448061 Juvenile Book ycmus Cincinnati Museum Center Main Library 635.62 qg441   Gibbons, Gail. The pumpkin book 1 - CHECK SHELVES 2019-10-28     16 18 16.95 1999
2619771   1501129 2012-06-29 0995275748045 Juvenile Book ycmus Cincinnati Museum Center Main Library 641.3411 qb948   Burckhardt, Ann, 1933- Apples 1 - CHECK SHELVES 2019-10-09     21 6 9.93 1996
1014152   1766492 2012-06-23 1043443448021 Juvenile Book ycmus Cincinnati Museum Center Main Library 641.3411 s756   Spilsbury, Louise. Apples 1 - CHECK SHELVES 2019-10-16     15 14 21.36 2001
2080355   1226909 2012-06-27 0942356448079 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Lindbergh, Reeve. Johnny Appleseed 1 - CHECK SHELVES 2019-09-28     42 2 14.95 1990
2979385   1946027 2012-06-29 1039550548017 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Doyle, Malachy. Sleepy Pendoodle 1 - CHECK SHELVES       0 0 12.99 2002
3139196   1324967 2012-06-29 0958696548014 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Ray, Mary Lyn. Pumpkins : a story for a field 1 - CHECK SHELVES 2018-10-19     69 3 13.95 1992
3167640   1799103 2012-06-29 1031290048010 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Spetter, Jung-Hee, 1969- Lily and Trooper's fall 1 - CHECK SHELVES 2018-10-08     41 13 8.95 1998
3186443   1715993 2012-06-29 1012573348020 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Brown, Margaret Wise, 1910-1952. The little scarecrow boy 1 - CHECK SHELVES 2018-11-21     76 9 15.89 1998
3478398   1816394 2012-06-30 1017357448011 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Rius, María. Fall 1 - CHECK SHELVES 2019-10-14     55 11 5.95 1998
3478411   1816394 2012-06-30 1017357448037 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Rius, María. Fall 1 - CHECK SHELVES 2018-11-05     46 14 5.95 1998
3483454   1311151 2012-06-30 0964865548017 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Devlin, Wende. Cranberry autumn 1 - CHECK SHELVES 2015-01-15     59 19 13.95 1993
3526615   1226909 2012-06-30 0942356448061 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Lindbergh, Reeve. Johnny Appleseed 1 - CHECK SHELVES 2018-09-18     84 9 14.95 1990
3572946   1246867 2012-06-30 0942930648020 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Stock, Catherine. Thanksgiving treat 1 - CHECK SHELVES 2017-01-13     25 10 4.99 1990
3578242   1248577 2012-06-30 0942985248056 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Leedy, Loreen. A dragon Thanksgiving feast : things to make and do 1 - CHECK SHELVES 2019-01-16     43 13 14.95 1990
3587769   1981026 2012-06-30 1033796048049 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Moffatt, Judith. The pumpkin man 1 - CHECK SHELVES 2015-11-02     21 4 12.95 1998
3630253   1274973 2012-06-30 0943706448082 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Maass, Robert. When autumn comes 1 - CHECK SHELVES 2018-11-01     58 4 0.95 1990
3646699   2447689 2012-06-30 1576908-2011 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Nikola-Lisa, W. Setting the turkeys free 1 - CHECK SHELVES 2019-01-17     27 12 15.99 2004
3731549   1891746 2012-06-30 1044872948036 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Purmell, Ann. Apple cider making days 1 - CHECK SHELVES 2019-10-09     31 5 21.9 2002
3737963   1653436 2012-06-30 0993962748055 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Hunter, Anne. Possum's harvest moon 1 - CHECK SHELVES 2019-09-05     34 12 14.95 1996
4000455   1387906 2012-06-30 0973336848013 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Slawson, Michele Benoit. Apple picking time 1 - CHECK SHELVES 2019-10-04     64 15 15.99 1994
4027275   2535586 2012-06-30 A000005882626 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Henry, Heather French. Pepper's Purple Heart : a Veterans Day story 1 - CHECK SHELVES 2017-11-22     17 4 8.64 2004
4028437   1544167 2012-06-30 0999116648018 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Beard, Darleen Bailey. The pumpkin man from Piney Creek 1 - CHECK SHELVES 2014-11-22     27 2 14.0 1995
4094193   2132605 2012-06-30 8400448448054 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Gibbons, Gail. The seasons of Arnold's apple tree 1 - CHECK SHELVES 2019-10-12     58 11 15.0 1984
4202210   1485212 2012-06-30 0976026848011 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Krull, Kathleen. Maria Molina : and the Days of the Dead 1 - CHECK SHELVES 2018-11-03     41 4 15.95 1994
4210052   1488593 2012-06-30 0976151448058 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Tryon, Leslie. Albert's Thanksgiving 1 - CHECK SHELVES 2018-12-03     44 7 14.95 1994
4232877   1760017 2012-06-30 1037237548020 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Harshman, Marc. Red are the apples 1 - CHECK SHELVES 2019-10-16     58 20 16.0 2001
4309120   1590289 2012-06-30 0978168248042 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Good, Elaine W., 1944- Fall is here! I love it! 1 - CHECK SHELVES 2019-01-22     58 19 6.95 1990
4371599   1815550 2012-06-30 1037918348039 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Glaser, Linda. It's fall! 1 - CHECK SHELVES 2019-10-28     53 12 21.9 2001
4374045   2387337 2012-06-30 8600310048011 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Stevenson, James, 1929-2017 Fried feathers for Thanksgiving 1 - CHECK SHELVES 2015-11-23     45 1 11.75 1986
4374949   2387802 2012-06-30 8600328748057 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Krensky, Stephen. Lionel in the fall 1 - CHECK SHELVES 2016-09-22     52 9 8.89 1987
4401332   1657351 2012-06-30 1004686048027 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Johnston, Tony, 1942- Day of the Dead 1 - CHECK SHELVES 2019-10-08     30 4 14.0 1997
4464568   1730998 2012-06-30 1005782548059 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Bunting, Eve, 1928-2023. The pumpkin fair 1 - CHECK SHELVES 2019-10-28     45 9 15.0 1997
4470447   1735396 2012-06-30 1005837248028 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Fleming, Denise, 1950- Time to sleep 1 - CHECK SHELVES 2019-02-06     77 20 15.95 1997
4583023   2631317 2012-06-30 1612062-1001 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Jane, Pamela. Fall is here! : counting 1 to 10 1 - CHECK SHELVES 2019-10-28     30 10 4.87 2005
4629803   1701175 2012-06-30 A000026963165 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Rylant, Cynthia. Scarecrow 12 - CHECK SHELVES 2019-10-24     62 10 16.0 1998
4629905   1701175 2012-06-30 1008875548044 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Rylant, Cynthia. Scarecrow 1 - CHECK SHELVES 2019-10-16     46 11 16.0 1998
4631633   1703076 2012-06-30 1008897548048 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Schnur, Steven. Autumn : an alphabet acrostic 1 - CHECK SHELVES 2019-09-28     56 12 15.0 1997
4862555   2725698 2012-07-01 1631488-1002 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Brimner, Larry Dane. In the fall 1 - CHECK SHELVES 2019-10-02     34 23 18.16 2006
5195443   2774972 2012-07-02 1702137-1001 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Hubery, Julia. A friend for all seasons 1 - CHECK SHELVES 2019-08-01     16 14 9.51 2007
5416084   2503139 2012-07-02 1706632-1001 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Raczka, Bob. Who loves the fall? 1 - CHECK SHELVES 2019-09-20     27 10 16.95 2007
5431619   2516396 2012-07-02 1648331-1001 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Gerritsen, Paula. Nuts 1 - CHECK SHELVES 2018-11-26     16 11 9.49 2005
5809368   2686591 2012-07-03 1742830-1001 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Bildner, Phil. Turkey Bowl 1 - CHECK SHELVES 2018-12-21     19 15 15.99 2008
5836258   2554095 2012-07-03 1716773-1001 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Sams, Carl R. First snow in the woods : a photographic fantasy 1 - CHECK SHELVES 2019-02-04     24 12 19.95 2007
5951945   2585774 2012-07-03 1661753-1001 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Anderson, Derek, 1969-2024. Blue Burt and Wiggles 1 - CHECK SHELVES 2017-10-06     29 8 8.9 2006
6292084   2683534 2012-07-03 1808331-1001 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Emmett, Jonathan. Leaf trouble 1 - CHECK SHELVES 2019-10-09     26 16 16.99 2009
9511455   3288276 2017-08-10 A000056658420 Juvenile Book ycmus Cincinnati Museum Center Main Library easy     Llama Llama Gives Thanks 1 - CHECK SHELVES 2018-11-14     3 0 5.99 2017
9548520   3288253 2017-09-12 A000056564529 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Sirett, Dawn, author. Baby's first Thanksgiving 1 - CHECK SHELVES 2018-12-16     4 4 5.99 2017
9552468   3301123 2017-09-13 A000056584998 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Noble, Trinka Hakes, 1944- author. Rettie and the Ragamuffin Parade : a Thanksgiving story 1 - CHECK SHELVES 2018-12-08     4 1 17.95 2017
9992116   3369356 2018-08-06 A000061382513 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Madden, Colleen M., author, illustrator. The kiddie table 1 - CHECK SHELVES 2018-11-26     2 2 15.95 2018
10029755   3369338 2018-09-05 A000061836286 Juvenile Book ycmus Cincinnati Museum Center Main Library easy   Long, Ethan, author, illustrator. Fangsgiving 1 - CHECK SHELVES 2018-12-08     2 2 16.99 2018
9992478   3364125 2018-08-06 A000061375616 Juvenile Book ycmus Cincinnati Museum Center Main Library fiction   Schwartz, Joanne (Joanne F.), 1960- author. Pinny in fall 1 - CHECK SHELVES 2019-10-28     3 4 16.95 2018
4685929   2247712 2012-06-30 1049486948025 Juvenile Book ycmus Cincinnati Museum Center Main Library s b   Boynton, Sandra. Perritos : un libro para contar y ladrar 1 - CHECK SHELVES       19 2 5.99 2004
3739682   1839323 2012-06-30 1021516448029 Juvenile Book ycmus Cincinnati Museum Center Main Library s l   Luenn, Nancy. A gift for Abuelita : celebrating the Day of the Dead 1 - CHECK SHELVES 2012-10-02     12 0 15.95 1998
6323843   2598684 2012-07-03 1725726-1002 Juvenile Book ycmus Cincinnati Museum Center Main Library s r   Rosa-Mendoza, Gladys. Colors and shapes = Los colores y las figuras 1 - CHECK SHELVES       16 4 6.95 2000
6324134   2598696 2012-07-03 1725728-1002 Juvenile Book ycmus Cincinnati Museum Center Main Library s r   Rosa-Mendoza, Gladys. Opposites = Opuestos 1 - CHECK SHELVES 2014-12-31     15 8 6.95 2001
2758801   1878072 2012-06-29 1032430748022 Juvenile Book ycmus Cincinnati Museum Center Main Library 629.454 a644 zh, 2001   Hasday, Judy L., 1957- The Apollo 13 mission 1 m MISSING 2018-11-03     3 4 19.95 2001

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW item_view AS select
  item.item_record_num,
  item.volume_record_num,
  item.bib_record_num,
  item.creation_date,
  item.barcode,
  item.item_format,
  item.location_code,
  location_name."name" as location_name,
  branch_name."name" as branch_name,
  item.item_callnumber,
  item.volume_record_statement as vol_statement,
  bib.best_author,
  bib.best_title,
  item.agency_code_num,
  item.item_status_code,
  item_status_property.item_status_name,
  coalesce(
    item.checkout_date,
    item.last_checkin_date,
    item.last_checkout_date
  ) as last_circ_act_date,
  item.checkout_date,
  item.due_date,
  item.checkout_total,
  item.renewal_total,
  item.price_cents / 100.0 as item_price,
  bib.publish_year
from
  item
  left outer join bib on bib.bib_record_num = item.bib_record_num
  left outer join location on location.code = item.location_code
  left outer join location_name on location_name.location_id = location.id
  left outer join branch on branch.code_num = location.branch_code_num
  left outer join branch_name on branch_name.branch_id = branch.id
  left outer join item_status_property on item_status_property.item_status_code = item.item_status_code;