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

5,695,393 rows

View and edit SQL

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
101 2897668 1371220 2012-06-29 2013-01-06 0966413352016 1 2ga 0 0           4 0 0201550695 Book - 2495 352.650973 w727
102 2898204 1631683 2012-06-29 2019-04-03 1000526057012 1 3ca 0 0           0 0   Rare Book o 1550 338.0977178 ffc574
103 2898039 1631620 2012-06-29 2013-01-06 1000523052016 1 2ga 0 0           0 0   Reference Book o 1500 368.4 qb56
104 2897163 1630855 2012-06-29 2013-01-06 1000504352013 1 2ga 0 0           0 0   Reference Book o 1600 368.3 u59
105 2897552 1631215 2012-06-29 2013-01-06 1000513052018 1 2ga 0 0           0 0   Reference Book o 1550 368.31 qs74
106 2898122 1371607 2012-06-29 2013-01-06 0966422258014 1 2sa 0 0           3 0   Book - 600 535.37 36.2
107 2898218 1629647 2012-06-29 2018-09-19 0982968157015 1 3ca 0 0           0 0   Rare Book o 1550 fiction
108 2898346 1774101 2012-06-29 2013-01-06 1016771953010 1 3ha 0 0           0 0   Reference Book o 3000 917.4727 qh314
109 8390272 3074957 2015-08-04 2018-07-30   50 vidow 0 0           0 0   Downloadable Music v 0 emusic
110 2896339 1008509 2012-06-29 2019-04-04 0915018260017 1 1fa 0 0           0 0   LP Record - 100 slpx 02827
111 2896594 1628126 2012-06-29 2013-01-06 0982927946011 1 3aa 0 0           0 0   Music Score - 125 m2.24 qb118 c18
112 2896369 1370377 2012-06-29 2013-01-06 0966391353010 1 3ha 0 0           0 0   Book - 275 970.3 p97 w
113 2896756 1771504 2012-06-29 2013-01-06 1016742453017 1 3ha 0 0           0 0   Reference Book o 1550 917.13 m81
114 2896785 1370664 2012-06-29 2013-01-06 0966399953027 1 3ha 0 0           0 0   Book - 200 920 h314 .1
115 2896886 1630472 2012-06-29 2013-01-06 1000497153014 1 3ha 0 0           0 0   Book - 1550 910 m87 .1
116 2897585 1628588 2012-06-29 2013-01-06 0996798753017 1 3gar 0 0           0 0 1568373066 Reference Book o 6000 973.742 qc748 zr
117 2898466 1930531 2012-06-29 2013-01-06 1036218256017 1 3ra 0 0           0 0 0838638104 Book - 4950 809.102 r472
118 2898135 1629505 2012-06-29 2013-01-06 0982965056012 1 3la 0 0           0 0   Book - 1550 823.912 b471 zbe
119 2898418 1008629 2012-06-29 2013-01-06 0915021449011 1 2ea 0 0           0 0   Reference Book o 175 218 m82 .1
120 2898410 1774225 2012-06-29 2013-01-06 1016773453019 1 3ha 0 0           0 0   Book - 400 917.3 g854
121 2898692 1774668 2012-06-29 2013-01-06 1016777853016 1 3ha 0 0           0 0   Book - 495 917.49 p424
122 2898290 1629740 2012-06-29 2013-01-06 0982969248011 1 1lj 0 0           0 0   Reference Juvenile Book o 300 fiction
123 2898123 1773762 2012-06-29 2013-01-06 1016768153012 1 3ha 0 0           0 0   Book - 400 917.48 w54
124 2898552 1371965 2012-06-29 2013-01-06 0966432353011 1 3ea 0 0           0 0   Book - 375 929.75 m489 c
125 2898772 1774815 2012-06-29 2013-01-06 1016779353015 1 3ha 0 0           0 0   Book - 300 917.41 b99
126 2899336 1372506 2012-06-29 2013-01-06 0966452553011 1 3ha 0 0           0 0   Reference Book o 1550 910 p94
127 2899149 1372402 2012-06-29 2013-01-06 0966443649019 1 2ea 0 0           1 0   Book - 500 799.1 l419
128 1149500 2385146 2012-06-23 2013-01-04 6502439956037 1 3la 0 0           1 0   Book - 350 828 d419 zw
129 2899256 1372506 2012-06-29 2013-01-06 0966446653018 1 3ha 0 0           0 0   Reference Book o 1550 910 p94
130 2899281 1372506 2012-06-29 2013-01-06 0966448153017 1 3ha 0 0           0 0   Reference Book o 1550 910 p94
131 2899527 1008725 2012-06-29 2013-01-06 0915024149014 1 2ea 0 0           0 0   Reference Book o 1550 220 f845
132 2899524 1775923 2012-06-29 2014-09-18 1016793646014 1 3aa 0 0           0 0 0810834898 Reference Book o 7500 016.782102 qd786
133 1149508 1039030 2012-06-23 2013-01-04 0923712353021 1 3ha 0 0           0 0   Book - 450 942.063 a826
134 4170452 2561453 2012-06-30 2021-01-01 1597649-3001 1 2ra 801 1       2019-04-06 2019-08-19 9 13 7801264169 Book - 2495 495.183421 qc539
135 2897144 1630855 2012-06-29 2013-01-06 1000503552019 1 2ga 0 0           0 0   Reference Book o 700 368.3 u59
136 2897318 1370923 2012-06-29 2018-12-04 0966406757015 1 3ca 0 0           0 0   Rare Book o 1550 372.412 qa111 r 1884
137 2898874 1632534 2012-06-29 2013-01-06 1000543353048 1 3ha 0 0           0 0   Book - 1550 910 fr32
138 2898950 1631168 2012-06-29 2013-01-06 0982986756012 1 3la 0 0           0 0   Reference Book o 1550 814 b972 x
139 4653566 2226544 2012-06-30 2021-09-01 1049212948018 1 1lj 393 390       2021-07-24 2021-08-28 21 2 0439266459 Juvenile Book - 1695 easy
140 2899317 1775714 2012-06-29 2013-01-06 1016789756017 1 3la 0 0           0 0 0679448500 Reference Book o 4450 082 qr1941
141 2899306 1372506 2012-06-29 2013-01-06 0966449753013 1 3ha 0 0           0 0   Reference Book o 1550 910 p94
142 2899745 1934636 2012-06-29 2013-01-06 1036262953014 1 3ha 0 0           0 0   Reference Book o 700 975.4003 w516
143 1149151 2383117 2012-06-23 2013-01-04 6502299256056 1 3la 0 0           6 0 573013888 Book - 395 822 s5255r
144 8390362 3075046 2015-08-04 2018-07-30   50 vidow 0 0           0 0   Downloadable Music v 0 emusic
145 2897941 1629088 2012-06-29 2018-02-26 0982960052016 1 3ea 0 0           0 0   Reference Book o 1550 363.610977 l814 1853
146 2898074 1008591 2012-06-29 2013-01-06 0915020249131 1 2ea 0 0           0 0   Book - 1550 218 f54 .1
147 2900654 1633512 2012-06-29 2019-08-27 0983017053015 1 3ha 0 0           0 0   Reference Book o 100 973.910922 qg721 , 1948
148 2900010 1632586 2012-06-29 2018-09-19 0983004657018 1 3ca 0 0           0 0   Rare Book o 1550 fiction
149 2900262 1777086 2012-06-29 2013-01-06 1016807051011 1 1fa 0 0           9 0 0670877646 Book - 2195 fiction
150 2900309 1372850 2012-06-29 2013-01-06 0966461956015 1 3la 0 0           6 0 0810939703 Book - 4500 814.4 qb972 zk
151 2899750 1934636 2012-06-29 2013-01-06 2359900153014 1 3ha 0 0           0 0   Reference Book o 15000 975.4003 w516
152 2899672 1633807 2012-06-29 2013-01-06 1000561053017 1 3ha 0 0           0 0   Reference Book o 1550 910 h75
153 2897764 1371334 2012-06-29 2013-01-06 0966415649013 1 2ea 0 0           2 0 0819191086 Book - 4650 261.87306 l973
154 2897786 1371369 2012-06-29 2013-01-06 0966416356014 1 3la 0 0           0 0   Book - 200 812 g654 m
155 2898025 1631620 2012-06-29 2013-01-06 1000522652014 1 2ga 0 0           0 0   Reference Book o 1500 368.4 qb56
156 2897818 1371407 2012-06-29 2013-01-06 0966417256015 1 3la 0 0           0 0   Book - 200 811 r659 ch
157 2898163 1008607 2012-06-29 2013-01-06 0915020649017 1 2ea 0 0           0 0   Reference Book o 1550 212 s616 m2
158 2900030 1935331 2012-06-29 2013-01-06 1042043953018 1 3gar 0 0           0 0   Reference Book o 16600 917.6930025 fh153
159 2898216 1773926 2012-06-29 2013-01-06 1016769953022 1 3ha 0 0           1 0   Book - 100 917.3 f87
160 2898428 1629962 2012-06-29 2013-01-06 0982971752018 1 2ga 0 0           0 0   Book - 1550 352.16 f688
161 8390431 3075113 2015-08-04 2018-07-30   50 vidow 0 0           0 0   Downloadable Music v 0 emusic
162 2900512 1633320 2012-06-29 2013-01-06 0983014546011 1 3aa 0 0           0 0   Reference Book o 2200 709.2 qc191 zm
163 2900650 1071097 2012-06-29 2013-01-06 0918087749019 1 2ea 0 0           0 0   Book - 350 296 h865
164 2900034 1372728 2012-06-29 2013-01-06 0966458853019 1 3ha 0 0           1 0   Book - 360 977 c44
165 2900053 1372733 2012-06-29 2013-01-06 0966458956010 1 3la 0 0           0 0   Reference Book o 1550 428.2 c3 .1
166 2900720 1373185 2012-06-29 2018-06-22 0966471153017 1 3ea 0 0           0 0   Reference Book o 2500 975.287 w727 1967
167 2900942 1935418 2012-06-29 2013-01-06 954781-168001 40 wtard 0 0           0 0   Reference Book o 1000 917.71770025 fh153 w
168 2901536 1634500 2012-06-29 2017-10-19 0983032052018 1 2ga 0 0           0 0   Reference Book o 500 355 c61 ve, 1953
169 2900890 1778278 2012-06-29 2013-01-06 1016821553018 1 3ha 0 0           0 0   Book - 175 917.5 p134
170 2901225 1636264 2012-06-29 2013-01-06 1000597053015 1 3ha 0 0           0 0   Reference Book o 1550 369.129 d23
171 2901321 1636312 2012-06-29 2013-01-06 1000598253010 1 3ea 0 0           0 0   Reference Book o 1550 369.132 d23 .1
172 2898876 1372199 2012-06-29 2013-01-06 0966437953013 1 3ha 0 0           4 0 0706513223 Book - 250 956.94 h673 h
173 2899045 1197844 2012-06-29 2013-01-06 0912148260017 1 1fa 0 0           48 0   LP Record - 898 s 08736
174 2899303 1633226 2012-06-29 2013-01-06 1000552353012 1 3ha 0 0           1 0   Book - 1550 910 c81
175 2899411 1775840 2012-06-29 2019-05-07 1016791853018 1 3ha 0 0           0 0   Reference Book o 406 917.4043 c489 e, 1968
176 2899461 1775864 2012-06-29 2013-01-06 1016792853017 1 3ha 0 0           0 0 0814314031 Reference Book o 1550 917.30974 j59 zm
177 2899631 1934309 2012-06-29 2013-01-06 1036259353012 1 3ea 0 0           0 0 0788416103 Reference Book o 3200 975.247 c477
178 2899887 1632388 2012-06-29 2018-05-22 0983002457015 1 3ca 0 0           0 0   Rare Book o 1550 296 s41 c
179 2899778 1128506 2012-06-29 2013-01-06 0919584149026 1 2ea 0 0           0 0   Book - 500 274.7 b768
180 2899965 1634503 2012-06-29 2013-01-06 1000570752013 1 2na 0 0           0 0 0890935688 Reference Book o 400 327.174 n964 w
181 1900170 1200587 2012-06-27 2014-04-21 0934082552019 1 2ga 0 0           17 0 0891331530 Book - 1695 387.15 qh734
182 2899950 1935130 2012-06-29 2013-01-06 1036269046010 1 3aa 0 0           0 0 1574322273 Reference Book o 2495 745.10952 qf632
183 2900108 1935331 2012-06-29 2013-01-06 A000032734923 4 baar 0 0           0 0   Reference Book o 27400 917.6930025 fh153
184 2901846 1636566 2012-06-29 2013-01-06 1000607853016 1 3ea 0 0           0 0   Reference Book o 1550 369.141 s67 .1
185 2901176 1778785 2012-06-29 2013-01-06 1016827353017 1 3ha 0 0           0 0   Book - 1550 917.3 l23
186 2901219 1778871 2012-06-29 2018-09-19 1016828557012 1 3ca 0 0           0 0   Rare Book o 1550 820.82 d548 x
187 2901794 1128702 2012-06-29 2013-01-06 0919588446014 1 3aa 0 0           0 0 087011249X Reference Book o 6000 779.36 fs558
188 2901524 1936192 2012-06-29 2014-02-24 1036283356015 1 3ra 492 490       2014-01-29 2014-02-24 1 0 0802044891 Book - 6000 823.087209 p998
189 2902089 1636687 2012-06-29 2013-01-06 1000612453018 1 3ea 0 0           0 0   Reference Book o 1550 369.151 k16
190 2901912 1636583 2012-06-29 2013-01-06 1000609653018 1 3ea 0 0           0 0   Reference Book o 1550 369.151 g75
191 2900402 1197907 2012-06-29 2013-01-06 0912150252019 1 2ga 0 0           0 0   Reference Book o 6000 341.754 qi61 s
192 2900007 1634591 2012-06-29 2018-05-22 1000571857019 1 3ca 0 0           0 0   Rare Book o 50 356.14 c57
193 2900293 1935387 2012-06-29 2013-02-14 954778-145001 19 hpaoo 0 0           0 0   Reference Book o 1000 917.71770025 fh153 e
194 2902094 1780928 2012-06-29 2013-01-06 1016859653011 1 3ha 0 0           0 0   Reference Book o 1550 917.441 b91 b
195 2899918 1935003 2012-06-29 2013-01-06 1036267352014 1 2rar 0 0           0 0 078763171X Reference Book o 3140 323.173 e57
196 2900431 1633172 2012-06-29 2013-01-06 0983012853013 1 3ha 0 0           0 0 9068091972 Reference Book o 1661 912.492 p386
197 2901259 1373583 2012-06-29 2013-01-06 0966481856054 1 3la 0 0           0 0   Book - 200 811 r659 zw
198 2901709 1373963 2012-06-29 2014-11-17 0966490246016 1 3cac 0 0           0 0   Reference Book o 6000 741.1 fd14 d
199 2901713 1373963 2012-06-29 2014-11-17 0966490446012 1 3cac 0 0           0 0   Reference Book o 6000 741.1 fd14 d
200 7057308 2832274 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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"
);
CREATE INDEX "idx_item_item_format" ON "item" (
    "item_format"
);