item
Data source: https://ilsweb.cincinnatilibrary.org/collection-analysis-docs/
5,515,381 rows sorted by item_callnumber
This data as json, CSV (advanced)
Link | rowid | item_record_num | bib_record_num | creation_date | record_last_updated | barcode | agency_code_num | location_code | checkout_statistic_group_code_num | checkin_statistics_group_code_num | checkout_date | due_date | patron_branch_code | last_checkout_date | last_checkin_date | checkout_total | renewal_total | isbn | item_format | item_status_code | price_cents | item_callnumber ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
196 | 196 | 11008460 | 3570810 | 2020-12-28 | 2020-12-28 | 1 | 1pabr | 0 | 0 | 0 | 0 | 9786317398511 | Bluray | p | 1467 | |||||||
293 | 293 | 11008850 | 3563369 | 2020-12-28 | 2020-12-28 | 1 | tsac | 0 | 0 | 0 | 0 | 9786318427128 | Music on CD | p | 1188 | |||||||
303 | 303 | 11008641 | 3567551 | 2020-12-28 | 2020-12-28 | 1 | tsac | 0 | 0 | 0 | 0 | Music on CD | p | 974 | ||||||||
416 | 416 | 9239393 | 3245045 | 2017-02-07 | 2018-01-26 | A000040901027 | 1 | 3ca | 1 | 1 | 2017-11-15 | 2017-12-06 | 1 | 2017-11-14 | 2017-11-15 | 2 | 0 | Rare Book | o | 0 | ||
1845 | 1845 | 11004590 | 3387357 | 2020-12-22 | 2020-12-31 | A000069421875 | 1 | tsaar | 0 | 0 | 0 | 0 | 1786814226 | Book | t | 1299 | ||||||
2394 | 2394 | 11011833 | 3572647 | 2020-12-30 | 2020-12-30 | 1 | tsjho | 0 | 0 | 0 | 0 | 9781910307472 | Juvenile Book | p | 1499 | |||||||
2439 | 2439 | 11011938 | 3572662 | 2020-12-30 | 2020-12-30 | 1 | tstf | 0 | 0 | 0 | 0 | 9781975399351 | Teen Book | p | 1500 | |||||||
2444 | 2444 | 11011934 | 3572662 | 2020-12-30 | 2020-12-30 | 1 | tstf | 0 | 0 | 0 | 0 | 9781975399351 | Teen Book | p | 1500 | |||||||
2541 | 2541 | 11012011 | 3573490 | 2020-12-30 | 2020-12-30 | 1 | tsjnf | 0 | 0 | 0 | 0 | 9780997318722 | Juvenile Book | p | 1895 | |||||||
2825 | 2825 | 11012409 | 3572691 | 2020-12-30 | 2020-12-30 | 1 | tsaab | 0 | 0 | 0 | 0 | 9781250752192 | Book on CD | p | 2222 | |||||||
3099 | 3099 | 10703514 | 3172041 | 2020-01-14 | 2020-01-23 | A000068309220 | 1 | getgn | 0 | 0 | 0 | 0 | 9780316309523 | Teen Book | - | 2400 | ||||||
6696 | 6696 | 10712754 | 2614313 | 2020-01-22 | 2021-01-01 | A000068327115 | 1 | dtanf | 210 | 210 | 2020-12-30 | 2021-02-10 | dt | 2020-10-10 | 2020-10-21 | 3 | 3 | 9780061537110 | Book | - | 1599 | |
8582 | 8582 | 1634056 | 2677994 | 2012-06-26 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | ||||||||
14038 | 14038 | 10219471 | 3489411 | 2019-01-17 | 2021-01-01 | A000062940004 | 37 | haanf | 281 | 280 | 2020-02-22 | 2020-03-09 | 4 | 12 | Book | - | 2495 | |||||
27451 | 27451 | 10729035 | 3512148 | 2020-01-31 | 2020-01-31 | A000011912961 | 1 | 1pal | 0 | 0 | 0 | 0 | Large Print Book | - | 2895 | |||||||
27544 | 27544 | 10729063 | 3512150 | 2020-01-31 | 2021-01-01 | A000011912300 | 0 | osanf | 0 | 0 | 2020-01-31 | 2020-02-12 | 1 | 0 | Book | - | 0 | |||||
27634 | 27634 | 10729114 | 3512153 | 2020-01-31 | 2021-01-01 | A000011913266 | 2 | cranf | 0 | 0 | 2020-01-31 | 2020-02-07 | 1 | 0 | Book | - | 2795 | |||||
28593 | 28593 | 10726391 | 3511650 | 2020-01-29 | 2020-02-11 | A000011911807 | 14 | fojbi | 0 | 0 | 0 | 0 | Juvenile Book | - | 1795 | |||||||
33332 | 33332 | 8313138 | 3051591 | 2015-06-16 | 2018-11-21 | A000040927667 | 1 | 4da | 491 | 490 | 2016-06-13 | 2016-06-15 | 1 | 0 | 9780160926761 | Government Document | - | 4000 | ||||
33965 | 33965 | 7060627 | 2835593 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
35966 | 35966 | 7019444 | 2827061 | 2013-02-20 | 2019-08-30 | A000030361018 | 38 | mwad | 382 | 1 | 2014-08-19 | 2019-08-30 | 67 | 30 | DVD/Videocassette | e | 2999 | |||||
35976 | 35976 | 7019690 | 2827152 | 2013-02-20 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
35977 | 35977 | 7019694 | 2827156 | 2013-02-20 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
35990 | 35990 | 7020134 | 2827559 | 2013-02-20 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36003 | 36003 | 7020418 | 2827783 | 2013-02-20 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36022 | 36022 | 7056517 | 2831483 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36035 | 36035 | 7056833 | 2831799 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36038 | 36038 | 7056905 | 2831871 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36078 | 36078 | 7058420 | 2833386 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36079 | 36079 | 7058506 | 2833472 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36092 | 36092 | 7058916 | 2833882 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36098 | 36098 | 7059026 | 2833992 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36107 | 36107 | 7059280 | 2834246 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36108 | 36108 | 7059331 | 2834297 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36110 | 36110 | 7059342 | 2834308 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36116 | 36116 | 7059661 | 2834627 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36117 | 36117 | 7059687 | 2834653 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36119 | 36119 | 7059737 | 2834703 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36123 | 36123 | 7059825 | 2834791 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36124 | 36124 | 7059889 | 2834855 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36125 | 36125 | 7059862 | 2834828 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36129 | 36129 | 7060086 | 2835052 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36130 | 36130 | 7060102 | 2835068 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36134 | 36134 | 7060149 | 2835115 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36141 | 36141 | 7060393 | 2835359 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36145 | 36145 | 7060507 | 2835473 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36160 | 36160 | 7060759 | 2835725 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36161 | 36161 | 7060718 | 2835684 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36163 | 36163 | 7060806 | 2835772 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36165 | 36165 | 7060809 | 2835775 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36167 | 36167 | 7060915 | 2835881 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36170 | 36170 | 7061040 | 2836006 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36180 | 36180 | 7061176 | 2836142 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36188 | 36188 | 7061401 | 2836367 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36209 | 36209 | 7061724 | 2836690 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36221 | 36221 | 7061980 | 2836946 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36223 | 36223 | 7062048 | 2837014 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36261 | 36261 | 7062971 | 2837937 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36266 | 36266 | 7063091 | 2838057 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36269 | 36269 | 7063149 | 2838115 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36283 | 36283 | 7063606 | 2838572 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36284 | 36284 | 7063670 | 2838636 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36299 | 36299 | 7064014 | 2838980 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36309 | 36309 | 7064317 | 2839283 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36310 | 36310 | 7064343 | 2839309 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36311 | 36311 | 7064423 | 2839389 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36319 | 36319 | 7064589 | 2839555 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36320 | 36320 | 7064615 | 2839581 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36322 | 36322 | 7064721 | 2839687 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36340 | 36340 | 7065064 | 2840030 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36361 | 36361 | 7065434 | 2840400 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36376 | 36376 | 7065657 | 2840623 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36377 | 36377 | 7065703 | 2840669 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36380 | 36380 | 7065790 | 2840756 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36393 | 36393 | 7065932 | 2840898 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
36687 | 36687 | 7061351 | 2836317 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
41403 | 41403 | 10746803 | 3489961 | 2020-02-11 | 2021-01-01 | A000068170127 | 1 | smal | 801 | 490 | 2020-12-10 | 2021-01-21 | os | 2020-11-10 | 2020-11-30 | 4 | 3 | 9781432872496 | Large Print Book | - | 3799 | |
56205 | 56205 | 10784199 | 3520939 | 2020-03-09 | 2021-01-02 | A000068641929 | 1 | hajer | 801 | 281 | 2020-11-21 | 2021-01-25 | ha | 2020-11-21 | 2020-11-21 | 5 | 1 | 9781368047845 | Juvenile Book | - | 1699 | |
57000 | 57000 | 8657371 | 2841599 | 2016-01-14 | 2018-01-01 | A000049160864 | 31 | nstgn | 302 | 400 | 2016-09-20 | 2016-10-04 | 3 | 3 | 9781401234676 | Teen Book | - | 1699 | ||||
58067 | 58067 | 9167170 | 2841599 | 2016-12-13 | 2019-01-01 | A000045610649 | 18 | hatgn | 800 | 280 | 2018-06-25 | 2018-08-27 | 2 | 4 | 9781401234676 | Teen Book | - | 1799 | ||||
64509 | 64509 | 10463673 | 3461556 | 2019-07-18 | 2019-07-18 | 1 | geaoo | 0 | 0 | 0 | 0 | 9781538761878 | Book | p | 1573 | |||||||
66479 | 66479 | 7019729 | 2827191 | 2013-02-20 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
66599 | 66599 | 7019810 | 2827272 | 2013-02-20 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
66607 | 66607 | 7019818 | 2827280 | 2013-02-20 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
66662 | 66662 | 7019850 | 2827312 | 2013-02-20 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
66908 | 66908 | 7056260 | 2831226 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
66911 | 66911 | 7056263 | 2831229 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
67057 | 67057 | 10880843 | 1964741 | 2020-08-20 | 2021-01-01 | A000070497146 | 1 | majeb | 323 | 320 | 2020-10-06 | 2020-10-28 | 3 | 0 | 9780593373194 | Juvenile Book | - | 1099 | ||||
67060 | 67060 | 10880844 | 1964741 | 2020-08-20 | 2021-01-01 | A000070497153 | 1 | anjeb | 102 | 102 | 2020-12-10 | 2020-12-23 | 4 | 0 | 9780593373194 | Juvenile Book | - | 1099 | ||||
67115 | 67115 | 6931338 | 2819163 | 2012-12-07 | 2019-10-28 | A000036936458 | 39 | clanf | 800 | 150 | 2017-12-18 | 2018-01-25 | 17 | 17 | 9780977919109 | Book | f | 3500 | ||||
67123 | 67123 | 7056948 | 2831914 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
67128 | 67128 | 7056953 | 2831919 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
67201 | 67201 | 7057013 | 2831979 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
67208 | 67208 | 7057019 | 2831985 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
67301 | 67301 | 6959140 | 2820294 | 2013-01-03 | 2021-01-01 | A000037027430 | 18 | smadc | 493 | 490 | 2020-09-19 | 2020-09-30 | 32 | 53 | 1422922324 | DVD/Videocassette | - | 2995 | ||||
67468 | 67468 | 6989914 | 2819477 | 2013-01-25 | 2021-01-02 | A000033659285 | 15 | wtadt | 801 | 510 | 2020-12-21 | 2021-01-11 | wt | 2020-03-03 | 2020-08-07 | 59 | 27 | 9781419864346 | DVD/Videocassette | - | 1000 | |
67542 | 67542 | 7057651 | 2832617 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
67555 | 67555 | 7002521 | 2820257 | 2013-02-06 | 2020-03-27 | A000033715442 | 1 | 1padm | 1 | 1 | 2015-03-02 | 2015-03-24 | 82 | 38 | DVD/Videocassette | e | 1999 | |||||
67588 | 67588 | 7057689 | 2832655 | 2013-03-23 | 2018-07-27 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | ||||||||
67641 | 67641 | 7015061 | 2821323 | 2013-02-15 | 2019-06-14 | A000007289135 | 100 | ycml | 0 | 0 | 0 | 0 | Reference Book | o | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE item ( item_record_num BIGINT, bib_record_num BIGINT, creation_date TEXT, record_last_updated TEXT, barcode TEXT, agency_code_num BIGINT, location_code TEXT, checkout_statistic_group_code_num BIGINT, checkin_statistics_group_code_num BIGINT, checkout_date TEXT, due_date TEXT, patron_branch_code TEXT, last_checkout_date TEXT, last_checkin_date TEXT, checkout_total BIGINT, renewal_total BIGINT, isbn TEXT, item_format TEXT, item_status_code TEXT, price_cents BIGINT, item_callnumber TEXT ); CREATE INDEX "idx_item_item_format_item_status_location_code_item_callnumber" ON "item" ( "location_code", "item_format", "item_status_code", "item_callnumber" ); CREATE INDEX "idx_item_bib_record_num" ON "item" ( "bib_record_num" ); CREATE INDEX "idx_item_item_record_num" ON "item" ( "item_record_num" ); CREATE INDEX "idx_item_agency_code_num_location_code" ON "item" ( "agency_code_num", "location_code" ); CREATE INDEX "idx_item_barcode" ON "item" ( "barcode" );