item
Data source: https://ilsweb.cincinnatilibrary.org/collection-analysis-docs/
5,515,381 rows sorted by barcode
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23 | 23 | 11007644 | 3172699 | 2020-12-28 | 2020-12-28 | 1 | tsaar | 0 | 0 | 0 | 0 | Book | p | 1308 | 346.73052 r194 | |||||||
37 | 37 | 11007681 | 1302179 | 2020-12-28 | 2020-12-28 | 1 | tsaar | 0 | 0 | 0 | 0 | Book | p | 2619 | 346.73052 qp699 | |||||||
60 | 60 | 11002771 | 3558996 | 2020-12-21 | 2020-12-21 | 1 | tsadt | 0 | 0 | 0 | 0 | 9781531712686 | DVD/Videocassette | p | 2568 | dvd tvadult r6281 2020 | ||||||
179 | 179 | 11008351 | 3537552 | 2020-12-28 | 2020-12-28 | 1 | tsadn | 0 | 0 | 0 | 0 | New Release DVDs | p | 2127 | dvd action b6181 2020 | |||||||
196 | 196 | 11008460 | 3570810 | 2020-12-28 | 2020-12-28 | 1 | 1pabr | 0 | 0 | 0 | 0 | 9786317398511 | Bluray | p | 1467 | |||||||
210 | 210 | 11008201 | 3520723 | 2020-12-28 | 2020-12-28 | 1 | tsadn | 0 | 0 | 0 | 0 | New Release DVDs | p | 2201 | dvd scifi u561 2020 | |||||||
224 | 224 | 11008278 | 3537555 | 2020-12-28 | 2020-12-28 | 1 | tsadn | 0 | 0 | 0 | 0 | New Release DVDs | p | 1100 | dvd action c1561 2020 | |||||||
229 | 229 | 11008307 | 3520722 | 2020-12-28 | 2020-12-28 | 1 | tsadn | 0 | 0 | 0 | 0 | New Release DVDs | p | 1467 | dvd musical c3671 2020 | |||||||
289 | 289 | 11008513 | 2524040 | 2020-12-28 | 2020-12-28 | 1 | tsad | 0 | 0 | 0 | 0 | DVD/Videocassette | p | 733 | dvd action w251 2008 | |||||||
293 | 293 | 11008850 | 3563369 | 2020-12-28 | 2020-12-28 | 1 | tsac | 0 | 0 | 0 | 0 | 9786318427128 | Music on CD | p | 1188 | |||||||
301 | 301 | 11008613 | 3539727 | 2020-12-28 | 2020-12-28 | 1 | tsadn | 0 | 0 | 0 | 0 | 9786318286404 | New Release DVDs | p | 1393 | dvd drama c2462 2020 | ||||||
303 | 303 | 11008641 | 3567551 | 2020-12-28 | 2020-12-28 | 1 | tsac | 0 | 0 | 0 | 0 | Music on CD | p | 974 | ||||||||
309 | 309 | 11008781 | 3546169 | 2020-12-28 | 2020-12-28 | 1 | pradn | 0 | 0 | 0 | 0 | New Release DVDs | p | 1174 | dvd comedy a4771 2019 | |||||||
312 | 312 | 11008706 | 3563363 | 2020-12-28 | 2020-12-28 | 1 | tsac | 0 | 0 | 0 | 0 | Music on CD | p | 849 | cd-country brooks b8731fu 2020 | |||||||
768 | 768 | 11010578 | 3547337 | 2020-12-29 | 2020-12-29 | 1 | tsaar | 0 | 0 | 0 | 0 | 9780857197689 | Book | p | 1082 | 332.4019 h842 2020 | ||||||
800 | 800 | 11010626 | 3548988 | 2020-12-29 | 2020-12-29 | 1 | tsal | 0 | 0 | 0 | 0 | 9781432879716 | Large Print Book | p | 3799 | fiction | ||||||
1641 | 1641 | 10413030 | 3459065 | 2019-06-07 | 2019-06-07 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
1674 | 1674 | 10413056 | 3459091 | 2019-06-07 | 2019-06-07 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
1867 | 1867 | 11011409 | 1340734 | 2020-12-30 | 2020-12-30 | 1 | tstf | 0 | 0 | 0 | 0 | 0152009507 | Teen Book | p | 799 | fiction | ||||||
1878 | 1878 | 11011421 | 3048347 | 2020-12-30 | 2020-12-30 | 1 | tstf | 0 | 0 | 0 | 0 | 9780545695190 | Teen Book | p | 1799 | fiction | ||||||
2146 | 2146 | 10049174 | 3385465 | 2018-09-20 | 2018-09-20 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
2149 | 2149 | 10049206 | 3385497 | 2018-09-20 | 2018-09-20 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
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 | |||||||
2629 | 2629 | 11012175 | 2467936 | 2020-12-30 | 2020-12-30 | 1 | osjoo | 0 | 0 | 0 | 0 | 9780064402750 | Juvenile Book | p | 699 | fiction | ||||||
2642 | 2642 | 10050215 | 3385699 | 2018-09-20 | 2018-09-20 | 50 | vidow | 0 | 0 | 0 | 0 | 9781492637141 | Downloadable Book | v | 0 | ebook | ||||||
2647 | 2647 | 10050213 | 3385697 | 2018-09-20 | 2018-09-20 | 50 | vidow | 0 | 0 | 0 | 0 | 9781460328965 | Downloadable Book | v | 0 | ebook | ||||||
2648 | 2648 | 10050232 | 3385716 | 2018-09-20 | 2018-09-20 | 50 | vidow | 0 | 0 | 0 | 0 | 9781681590691 | Downloadable Book | v | 0 | ebook | ||||||
2650 | 2650 | 10050327 | 3385811 | 2018-09-20 | 2018-09-20 | 50 | vidow | 0 | 0 | 0 | 0 | 9781460384992 | Downloadable Book | v | 0 | ebook | ||||||
2660 | 2660 | 11012191 | 2467936 | 2020-12-30 | 2020-12-30 | 1 | osjoo | 0 | 0 | 0 | 0 | 9780064402750 | Juvenile Book | p | 699 | fiction | ||||||
2674 | 2674 | 11012211 | 3474041 | 2020-12-30 | 2020-12-30 | 1 | tsjeb | 0 | 0 | 0 | 0 | 9781771644730 | Juvenile Book | p | 1795 | easy | ||||||
2684 | 2684 | 10050328 | 3385812 | 2018-09-20 | 2018-09-20 | 50 | vidow | 0 | 0 | 0 | 0 | 9781459290242 | Downloadable Book | v | 0 | ebook | ||||||
2702 | 2702 | 11012251 | 3546785 | 2020-12-30 | 2020-12-30 | 1 | tstgn | 0 | 0 | 0 | 0 | 9781728412924 | Teen Book | p | 1699 | 741.5 v671 2020 | ||||||
2714 | 2714 | 11006264 | 3568379 | 2020-12-23 | 2020-12-23 | 1 | osjoo | 0 | 0 | 0 | 0 | 9781978517493 | Juvenile Book | p | 1840 | 782.421599 t239 2021 | ||||||
2752 | 2752 | 11012310 | 1025743 | 2020-12-30 | 2020-12-30 | 1 | tsaar | 0 | 0 | 0 | 0 | Book | p | 1194 | 331.128 b691 | |||||||
2754 | 2754 | 10050610 | 3386094 | 2018-09-20 | 2018-09-20 | 50 | vidow | 0 | 0 | 0 | 0 | 9780814413906 | Downloadable Book | v | 0 | ebook | ||||||
2755 | 2755 | 10050624 | 3386108 | 2018-09-20 | 2018-09-20 | 50 | vidow | 0 | 0 | 0 | 0 | 9781488031205 | Downloadable Book | v | 0 | ebook | ||||||
2802 | 2802 | 10050609 | 3386093 | 2018-09-20 | 2018-09-20 | 50 | vidow | 0 | 0 | 0 | 0 | 9780912777276 | Downloadable Book | v | 0 | ebook | ||||||
2823 | 2823 | 10050720 | 3386204 | 2018-09-20 | 2018-09-20 | 50 | vidow | 0 | 0 | 0 | 0 | 9781504055468 | Downloadable Book | v | 0 | ebook | ||||||
2825 | 2825 | 11012409 | 3572691 | 2020-12-30 | 2020-12-30 | 1 | tsaab | 0 | 0 | 0 | 0 | 9781250752192 | Book on CD | p | 2222 | |||||||
2864 | 2864 | 11011728 | 3572988 | 2020-12-30 | 2020-12-30 | 1 | tsaab | 0 | 0 | 0 | 0 | 9781478916079 | Book on CD | p | 4000 | cd-spoken fiction beukes | ||||||
2882 | 2882 | 10050856 | 3386339 | 2018-09-20 | 2018-09-20 | 50 | vidow | 0 | 0 | 0 | 0 | 9781418574048 | Downloadable Book | v | 0 | ebook | ||||||
2932 | 2932 | 11012453 | 3073454 | 2020-12-31 | 2020-12-31 | 1 | tstf | 0 | 0 | 0 | 0 | 9781481463331 | Teen Book | p | 738 | fiction | ||||||
2960 | 2960 | 11012497 | 3556495 | 2020-12-31 | 2020-12-31 | 1 | tsaar | 0 | 0 | 0 | 0 | 9781335430991 | Book | p | 1083 | fiction | ||||||
2973 | 2973 | 11012495 | 3556495 | 2020-12-31 | 2020-12-31 | 1 | tsaar | 0 | 0 | 0 | 0 | 9781335430991 | Book | p | 1083 | fiction | ||||||
3000 | 3000 | 11012548 | 3566981 | 2020-12-31 | 2020-12-31 | 1 | tsaar | 0 | 0 | 0 | 0 | 9781250273017 | Book | p | 1517 | fiction | ||||||
3141 | 3141 | 11012733 | 3034808 | 2020-12-31 | 2020-12-31 | 1 | tsjpu | 0 | 0 | 0 | 0 | 0763665940 | Juvenile Book | p | 2999 | 591.564 s541 2015 | ||||||
3195 | 3195 | 8862551 | 3180214 | 2016-05-21 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
3197 | 3197 | 11012844 | 3547592 | 2020-12-31 | 2020-12-31 | 1 | praar | 0 | 0 | 0 | 0 | 9781501188817 | Book | p | 1517 | fiction | ||||||
3249 | 3249 | 9732670 | 2664914 | 2018-01-23 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | 1585661228 | Web Document | v | 0 | 949.7103 u581 za 2003 | ||||||
3419 | 3419 | 9724275 | 2579987 | 2018-01-17 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | 9780160842948 | Web Document | v | 0 | 956.7044342 u58 za 2009 | ||||||
3432 | 3432 | 8444393 | 3090273 | 2015-09-04 | 2018-07-30 | 50 | vidow | 0 | 0 | 0 | 0 | 9781449469641 | Downloadable Book | v | 0 | ebook | ||||||
3532 | 3532 | 8444523 | 3090402 | 2015-09-04 | 2018-07-30 | 50 | vidow | 0 | 0 | 0 | 0 | 9781613749845 | Downloadable Book | v | 0 | ebook | ||||||
3568 | 3568 | 8444792 | 3090666 | 2015-09-04 | 2018-07-30 | 50 | vidow | 0 | 0 | 0 | 0 | 9781504015738 | Downloadable Book | v | 0 | ebook | ||||||
3624 | 3624 | 8444726 | 3090600 | 2015-09-04 | 2018-07-30 | 50 | vidow | 0 | 0 | 0 | 0 | 9781504017213 | Downloadable Book | v | 0 | ebook | ||||||
4095 | 4095 | 8042340 | 3014851 | 2014-12-03 | 2018-07-30 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | 917.7199 d5 | |||||||
4408 | 4408 | 10418006 | 3459878 | 2019-06-12 | 2019-06-12 | 50 | vidow | 0 | 0 | 0 | 0 | 9781492656005 | Downloadable Book | v | 0 | ebook | ||||||
4416 | 4416 | 10417981 | 3459853 | 2019-06-12 | 2019-06-12 | 50 | vidow | 0 | 0 | 0 | 0 | 9781641970945 | Downloadable Book | v | 0 | ebook | ||||||
4418 | 4418 | 10418022 | 3459894 | 2019-06-12 | 2019-06-12 | 50 | vidow | 0 | 0 | 0 | 0 | 9780062349071 | Downloadable Book | v | 0 | ebook | ||||||
4437 | 4437 | 10418070 | 3459942 | 2019-06-12 | 2019-06-12 | 50 | vidow | 0 | 0 | 0 | 0 | 9781615195749 | Downloadable Book | v | 0 | ebook | ||||||
4459 | 4459 | 10418023 | 3459895 | 2019-06-12 | 2019-06-12 | 50 | vidow | 0 | 0 | 0 | 0 | 9780062412928 | Downloadable Book | v | 0 | ebook | ||||||
4497 | 4497 | 10418060 | 3459932 | 2019-06-12 | 2019-06-12 | 50 | vidow | 0 | 0 | 0 | 0 | 9780062412744 | Downloadable Book | v | 0 | ebook | ||||||
5974 | 5974 | 10066547 | 3388346 | 2018-10-01 | 2018-10-01 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Music | v | 0 | emusic | |||||||
5992 | 5992 | 10066566 | 3388365 | 2018-10-01 | 2018-10-01 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Music | v | 0 | emusic | |||||||
6230 | 6230 | 7663171 | 2960674 | 2014-04-08 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
6630 | 6630 | 9244023 | 3245653 | 2017-02-09 | 2018-07-30 | 50 | vidow | 0 | 0 | 0 | 0 | 9780385353557 | Downloadable Book | v | 0 | ebook | ||||||
7018 | 7018 | 9244742 | 3245896 | 2017-02-09 | 2018-07-30 | 50 | vidow | 0 | 0 | 0 | 0 | 9781504043038 | Downloadable Book | v | 0 | ebook | ||||||
7110 | 7110 | 8444593 | 3090469 | 2015-09-04 | 2018-07-30 | 50 | vidow | 0 | 0 | 0 | 0 | 9781504016520 | Downloadable Book | v | 0 | ebook | ||||||
7111 | 7111 | 8444642 | 3090518 | 2015-09-04 | 2018-07-30 | 50 | vidow | 0 | 0 | 0 | 0 | 9781504012157 | Downloadable Book | v | 0 | ebook | ||||||
7112 | 7112 | 8444709 | 3090583 | 2015-09-04 | 2018-07-30 | 50 | vidow | 0 | 0 | 0 | 0 | 9781504011563 | Downloadable Book | v | 0 | ebook | ||||||
7250 | 7250 | 1533147 | 2725507 | 2012-06-26 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | oad 1.2:em5542004 | |||||||
7269 | 7269 | 1534770 | 2728029 | 2012-06-26 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | od 674.2:c8552006 | |||||||
7270 | 7270 | 1534786 | 2728052 | 2012-06-26 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | od 674.2:h76522005 | |||||||
7277 | 7277 | 7670977 | 2584817 | 2014-04-11 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | E-Magazine | v | 0 | ezine | |||||||
7290 | 7290 | 1537523 | 2731766 | 2012-06-26 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | ojb 1.2:un | |||||||
7551 | 7551 | 1557691 | 2767416 | 2012-06-26 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | ohf 1.2:f6972009span | |||||||
7560 | 7560 | 1558132 | 2767892 | 2012-06-26 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | onr 84.83:122001 | |||||||
8275 | 8275 | 8277405 | 3046251 | 2015-05-19 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
8296 | 8296 | 8277320 | 3046166 | 2015-05-19 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
8302 | 8302 | 10417941 | 3459813 | 2019-06-12 | 2019-06-12 | 50 | vidow | 0 | 0 | 0 | 0 | 9780062407818 | Downloadable Book | v | 0 | ebook | ||||||
8334 | 8334 | 7684692 | 2964560 | 2014-04-22 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
8347 | 8347 | 7684690 | 2964558 | 2014-04-22 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
8348 | 8348 | 7684793 | 2964661 | 2014-04-22 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
8364 | 8364 | 7685323 | 2965102 | 2014-04-22 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
8370 | 8370 | 10417733 | 3459605 | 2019-06-12 | 2019-06-12 | 50 | vidow | 0 | 0 | 0 | 0 | 9780062357151 | Downloadable Book | v | 0 | ebook | ||||||
8374 | 8374 | 10417782 | 3459654 | 2019-06-12 | 2019-06-12 | 50 | vidow | 0 | 0 | 0 | 0 | 9781459293298 | Downloadable Book | v | 0 | ebook | ||||||
8383 | 8383 | 10417765 | 3459637 | 2019-06-12 | 2019-06-12 | 50 | vidow | 0 | 0 | 0 | 0 | 9781625674333 | Downloadable Book | v | 0 | ebook | ||||||
8413 | 8413 | 10417903 | 3459775 | 2019-06-12 | 2019-06-12 | 50 | vidow | 0 | 0 | 0 | 0 | 9781788685368 | Downloadable Book | v | 0 | ebook | ||||||
8416 | 8416 | 10417889 | 3459761 | 2019-06-12 | 2019-06-12 | 50 | vidow | 0 | 0 | 0 | 0 | 9781435166714 | Downloadable Book | v | 0 | ebook | ||||||
8582 | 8582 | 1634056 | 2677994 | 2012-06-26 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | ||||||||
9760 | 9760 | 8541818 | 3110880 | 2015-11-04 | 2018-07-30 | 50 | vidow | 0 | 0 | 0 | 0 | Downloadable Book | v | 0 | 372.412 n285 1885 | |||||||
9897 | 9897 | 8546931 | 3111458 | 2015-11-06 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
9918 | 9918 | 8548432 | 3111726 | 2015-11-09 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
9922 | 9922 | 8548446 | 3111740 | 2015-11-09 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
9930 | 9930 | 8548616 | 3111908 | 2015-11-09 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
9931 | 9931 | 8548618 | 3111910 | 2015-11-09 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
9937 | 9937 | 8548777 | 3112069 | 2015-11-09 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal | |||||||
9947 | 9947 | 8549420 | 3112711 | 2015-11-09 | 2018-07-31 | 50 | viint | 0 | 0 | 0 | 0 | Web Document | v | 0 | electronic journal |
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" );