current_collection

Data source: https://ilsweb.cincinnatilibrary.org/collection-analysis-docs/

Custom SQL query returning 101 rows (hide)

rowiditem_record_numbib_record_numcreation_daterecord_last_updatedbarcodeagency_code_numlocation_codecheckout_statistic_group_code_numcheckin_statistics_group_code_numcheckout_datedue_datepatron_branch_codelast_checkout_datelast_checkin_datecheckout_totalrenewal_totalisbnitem_formatitem_status_codeprice_centsitem_callnumber
1 1148751 2380708 2012-06-23 2013-01-04 6502166248038 1 1lj 0 0           0 0   Juvenile Book - 275 fiction
2 2892527 1765111 2012-06-29 2013-01-06 1016664653016 1 3ha 0 0           0 0   Reference Book o 1550 916.043 d754
3 2892476 1367740 2012-06-29 2018-07-03 0966317657015 1 3ca 0 0           0 0   Rare Book o 495 686 55.1
4 2893025 1914653 2012-06-29 2013-01-06 1036033853014 1 3gar 0 0           0 0 0897252977 Reference Book o 6150 973.3130922 u58 dzp
5 2892800 1913903 2012-06-29 2013-01-06 1036025052013 1 2ra 0 0           0 0 026800840X Book - 2600 306.260983 l845 ce
6 1148974 2382161 2012-06-23 2013-01-04 6502242051166 1 1fa 0 0           0 0   Book - 250 fiction
7 2893003 1765983 2012-06-29 2013-01-06 1016674753012 1 3ha 0 0           0 0   Reference Book o 1550 915.403 qg289
8 2893016 1623826 2012-06-29 2013-01-06 0982844752013 1 2ga 0 0           0 0   Reference Book o 1550 342.7502 b197
9 2893335 1766452 2012-06-29 2013-01-06 1016680553018 1 3ha 0 0           0 0   Book - 350 916.24 l283
10 2893625 1766916 2012-06-29 2013-01-06 1016686153011 1 3ha 0 0           0 0   Reference Book o 1550 916.4 a51 .2
11 2893561 1626235 2012-06-29 2018-07-03 1000412957010 1 3ca 0 0           0 0   Rare Book o 1550 551.76 1881
12 2893623 1626360 2012-06-29 2013-01-06 1000414253012 1 3ha 0 0           0 0   Reference Book o 520 902 s81
13 2893611 1626340 2012-06-29 2013-02-14 689876-2001 199 ycml 0 0           0 0   Reference Book o 0 901 v26 .2
14 2893844 1199368 2012-06-29 2013-01-06 0921443658015 1 2sa 0 0           10 0 0133542823 Book - 1395 616.849 83.1
15 2894014 1626926 2012-06-29 2013-01-06 1000422353010 1 3ha 0 0           0 0   Reference Book o 1550 909 t17
16 2894383 1369203 2012-06-29 2013-01-06 0966359958016 1 2sa 0 0           0 0   Book - 325 540.2 31.1
17 2894052 1368875 2012-06-29 2013-01-06 0966352552014 1 2ga 0 0           0 0 0137993137 Reference Book o 3995 658.3741 c549
18 2894373 1625639 2012-06-29 2013-01-06 0982885452010 1 2ga 0 0           0 0   Book - 375 330 fb932
19 2894298 1627373 2012-06-29 2018-02-15 1000431053015 1 3ha 0 0           0 0   Reference Book o 500 909 p975
20 2894522 1197537 2012-06-29 2013-01-06 0912130660018 1 1fa 0 0           4 0   LP Record - 2398 lpx 02710
21 2894681 1768325 2012-06-29 2013-01-06 1016703253018 1 3ha 0 0           0 0   Reference Book o 1550 916.8 h75
22 2894541 1625788 2012-06-29 2013-01-06 0982887652013 1 2ga 0 0           0 0   Reference Book o 6000 330 e19
23 2894867 1628104 2012-06-29 2019-06-26 1000440858016 1 2sa 0 0           0 0   Book - 6000 597.09593 s649 , 1965
24 2895218 1197578 2012-06-29 2018-11-15 0912135856017 1 3la 0 0           0 0   Reference Book o 1350 808.8 g787 , 1952
25 2895613 1629325 2012-06-29 2013-01-06 1000455649011 1 2ea 0 0           0 0 0684819023 Reference Book o 1200 393.9 b471
26 2892819 1913967 2012-06-29 2013-01-06 1036025653018 1 3gar 0 0           0 0 089725144X Reference Book o 3200 929.374 c541
27 2895958 1629736 2012-06-29 2013-01-06 1000465552015 1 2ga 0 0           0 0   Reference Book o 1550 368.3 a85
28 2893011 1623817 2012-06-29 2017-02-08 0982844552017 1 2ga 0 0           0 0   Reference Book o 1550 349.748 p415 , 1920
29 2892825 1913967 2012-06-29 2013-01-06 1036025853014 1 3gar 0 0           0 0 089725144X Reference Book o 3200 929.374 c541
30 2892920 1623743 2012-06-29 2013-01-06 0982842356015 1 3la 0 0           0 0 0815318871 Reference Book o 5000 808.819353 g285
31 2895765 1369886 2012-06-29 2013-01-06 0966378853016 1 3ha 0 0           0 0 3796508561 Book - 880 907.2024 b948 zb
32 2896257 1630053 2012-06-29 2013-01-06 1000480952018 1 2ga 0 0           0 0   Reference Book o 700 368.3 f62 p
33 2893059 1766057 2012-06-29 2013-01-06 1016675453018 1 3ha 0 0           0 0   Reference Book o 200 915.40331 w947
34 2892837 1765711 2012-06-29 2013-01-06 1016671353014 1 3ha 0 0           1 0   Book - 350 915.4 r313
35 2893139 1766139 2012-06-29 2013-01-06 1016676553014 1 3ha 0 0           0 0   Book - 225 917.2 m15 m
36 1679218 2323628 2012-06-26 2013-02-12 1495886-1001 1 4da 0 0           0 0   Reference Government Document o 0 ep 1.2:r
37 3203161 2136525 2012-06-30 2019-01-01 7112397256021 1 3la 1 10         2018-09-10 11 3 0060147075 Book - 1095 081 w855
38 3426414 2372964 2012-06-30 2021-08-04 1564212-2002 32 osal 240 240       2021-07-28 2021-08-02 27 3 078388396X Large Print Book - 2395 fiction
39 5420446 2663073 2012-07-02 2021-02-04 A000003281011 20 smjho 492 490       2019-01-09 2019-01-16 13 3 0836865065 Juvenile Book w 1933 394.261 d282 m
40 2892885 1623690 2012-06-29 2019-07-09 0982841717019 21 maar 0 0           51 0 0964743310 Reference Book o 2695 977.178 qw854 , 1995
41 2892862 1623649 2012-06-29 2013-01-06 0982841952012 1 2ga 0 0           0 0   Reference Book o 7000 382.097305 qs617
42 2893112 1368195 2012-06-29 2013-01-06 0966330458011 1 2sa 0 0           0 0   Reference Book o 500 595.780972 fb615
43 2893424 1368388 2012-06-29 2019-08-17 0966342753011 1 3ha 0 0           0 0 0231089260 Reference Book o 7000 973.4 h217 xs
44 2893267 1766313 2012-06-29 2013-01-06 1016679153010 1 3ha 0 0           0 0   Reference Book o 2250 916.2043 qn124
45 2893805 1625025 2012-06-29 2013-01-06 0982874017014 21 majr 0 0           0 0 0803718403 Reference Juvenile Book o 1395 easy
46 2893812 1625025 2012-06-29 2013-01-06 0982874048019 1 1lj 0 0           0 0 0803718403 Reference Juvenile Book o 1395 easy
47 2894015 1625267 2012-06-29 2013-01-06 0982879752011 1 2ga 0 0           0 0   Reference Book o 1550 328.7721 e
48 2894163 1767653 2012-06-29 2013-01-06 1016694932018 37 shjr 0 0           0 0 189960751X Reference Juvenile Book o 1095 easy
49 2893999 1625267 2012-06-29 2013-01-06 0982879152014 1 2ga 0 0           0 0   Reference Book o 1550 328.7721 e
50 2894286 1627373 2012-06-29 2018-02-15 1000430353010 1 3ha 0 0           0 0   Reference Book o 795 909 p975
51 2894195 1627202 2012-06-29 2013-01-06 1000426353016 1 3ha 0 0           0 0   Reference Book o 1550 908 r65
52 2894773 1627932 2012-06-29 2013-01-06 1000439158014 1 2sa 0 0           0 0   Book - 250 597 q45 .2
53 1148898 2381696 2012-06-23 2013-01-04 6502213151029 1 1fa 0 0           0 0   Book - 350 fiction
54 2894603 1768223 2012-06-29 2019-04-29 1016701753019 1 3ha 0 0           0 0   Book - 595 917.2 qt32 , 1962
55 2894581 1627664 2012-06-29 2013-01-06 1000435853014 1 3ha 0 0           0 0   Book - 175 909 h97
56 2895874 1629726 2012-06-29 2013-01-06 1000464353019 1 3ha 0 0           0 0   Reference Book o 720 903 ql32 .1
57 2894853 1921382 2012-06-29 2013-01-06 1036106356010 1 3ra 0 0           0 0 0312232020 Book - 5500 823.912091 o94
58 2894758 1625999 2012-06-29 2013-01-06 0982891252016 1 2ga 0 0           0 0   Reference Book o 1550 349.37 ql82
59 2893586 1766855 2012-06-29 2013-01-06 1016685253010 1 3ha 0 0           0 0   Reference Book o 1550 916.3 p252
60 2893499 1626147 2012-06-29 2013-01-06 1000412158015 1 2sa 0 0           0 0   Reference Book o 1550 551.92 q1824
61 2893786 1917686 2012-06-29 2013-01-06 1036065556014 1 2rar 0 0           0 0 0816042381 Reference Book o 4500 423.1 qs394 e
62 2894215 1625478 2012-06-29 2013-01-06 0982882452013 1 2ga 0 0           0 0   Book - 500 353.930975 qa881
63 2896030 1627428 2012-06-29 2013-01-06 0982916352015 1 2ga 0 0           0 0   Reference Book o 1550 330.6 t97
64 2894258 1919365 2012-06-29 2013-01-06 1036083158017 1 2sa 0 0           0 0 0140514031 Reference Book o 1495 580.3 p398
65 2894933 1369597 2012-06-29 2013-01-06 0966370058010 1 2sa 0 0           2 0   Book - 250 623.38 41.3
66 2021908 1056690 2012-06-27 2014-09-12 0938028646017 1 3aa 0 0           0 0   Reference Book o 2445 016.78281 qm987
67 2894810 1768561 2012-06-29 2013-01-06 1016706953010 1 3ha 0 0           0 0   Reference Book o 1550 917.3 b96
68 2894836 1768627 2012-06-29 2019-04-25 1016707653015 1 3ha 0 0           0 0   Reference Book o 1750 917.043 m156 1902
69 2894994 1768838 2012-06-29 2013-01-06 1016710653010 1 3ha 0 0           0 0   Reference Book o 555 917.1 qe56
70 2895573 1626792 2012-06-29 2013-01-06 0982904552014 1 2ga 0 0           0 0   Reference Book o 1750 330.05 f491
71 2895632 1769689 2012-06-29 2013-01-06 1016720853014 1 3ha 0 0           0 0   Book - 1550 916.89 b88
72 2895536 1629220 2012-06-29 2013-01-06 1000454656017 1 3la 0 0           0 0   Reference Book o 1550 861.008 m541
73 2896261 1627773 2012-06-29 2018-09-19 0982921157011 1 3ca 0 0           0 0   Rare Book o 1550 fiction
74 2896137 1627564 2012-06-29 2013-01-06 0982918252015 1 2ga 0 0           0 0   Reference Book o 600 352.140977 qn874
75 2896897 1630472 2012-06-29 2013-01-06 1000497453018 1 3ha 0 0           0 0   Book - 1550 910 m87 .1
76 7057076 2832042 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
77 7057081 2832047 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
78 7057128 2832094 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
79 2896538 1925715 2012-06-29 2013-01-06 1036162846011 1 3aa 0 0           0 0   Reference Book o 1995 791.43079 u47
80 2897108 1630821 2012-06-29 2013-01-06 1000502653016 1 3ha 0 0           0 0   Reference Book o 1550 910.4 r28
81 2896684 1630332 2012-06-29 2013-01-06 1000493752017 1 2ga 0 0           0 0   Reference Book o 600 368.3 n2772l
82 2897029 1771836 2012-06-29 2013-01-06 1016746353015 1 3ha 0 0           0 0   Book - 250 917.19 h81
83 2896946 1771787 2012-06-29 2013-01-06 1016745353016 1 3ha 0 0           0 0   Book - 200 917.2 t67 m
84 2897105 1771988 2012-06-29 2013-01-06 1016747953011 1 3ha 0 0           0 0 095124745X Reference Book o 2256 941.93 s743
85 2897286 1630924 2012-06-29 2013-01-06 1000505953017 1 3ha 0 0           0 0   Reference Book o 1550 910.4 c21
86 2897340 1370962 2012-06-29 2013-01-06 0966407549015 1 2ea 0 0           1 0   Book - 650 371.422 y18
87 2897345 1631010 2012-06-29 2013-01-06 1000507053014 1 3ha 0 0           0 0   Book - 650 911 g575
88 2897578 1628588 2012-06-29 2013-01-06 0994850353016 1 3gar 0 0           0 0 1568373066 Reference Book o 6000 973.742 qc748 zr
89 2895367 1626479 2012-06-29 2013-01-06 0982900448019 1 1lj 0 0           3 0 1565660633 Juvenile Book - 1795 fiction
90 2895716 1769825 2012-06-29 2019-04-29 1016722353013 1 3ha 0 0           0 0   Reference Book o 1550 917.12 b98 1904
91 2897485 1631215 2012-06-29 2013-01-06 1000510652018 1 2ga 0 0           0 0   Reference Book o 1550 368.31 qs74
92 2897391 1772551 2012-06-29 2013-01-06 1016754153034 1 3ha 0 0           0 0   Reference Book o 1000 917.3 c877
93 8390348 3075032 2015-08-04 2018-07-30   50 vidow 0 0           0 0   Downloadable Music v 0 emusic
94 1374564 1121286 2012-06-24 2019-01-15 0925869852010 1 2ga 801 490       2018-12-14 2019-01-11 34 1   Book - 395 355.31 j93
95 2895770 1369886 2012-06-29 2013-01-06 0966379053012 1 3ha 0 0           0 0 3796508561 Book - 4635 907.2024 b948 zb
96 2895885 1770075 2012-06-29 2013-01-06 1016725053016 1 3ha 0 0           0 0   Reference Book o 300 917.12 m134
97 2897817 1628920 2012-06-29 2013-01-06 0982957952012 1 2ga 0 0           0 0   Book - 160 323.60973 e24
98 2897624 1631215 2012-06-29 2013-01-06 1000517052014 1 2ga 0 0           0 0   Reference Book o 1550 368.31 qs74
99 2897973 1631590 2012-06-29 2013-01-06 1000520752014 1 2ga 0 0           0 0   Reference Book o 2000 368.3201 i61
100 2898010 1629188 2012-06-29 2013-01-06 0982961052015 1 2ga 0 0           0 0   Reference Book o 1550 307.121609 fm873
101 2898370 1774143 2012-06-29 2013-01-06 1016772453010 1 3ha 0 0           0 0   Reference Book o 1550 917.3 g77