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

5,700,009 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 2898370 1774143 2012-06-29 2013-01-06 1016772453010 1 3ha 0 0           0 0   Reference Book o 1550 917.3 g77
102 2898354 1371788 2012-06-29 2013-01-06 0966427549011 1 2ea 0 0           4 0   Reference Book o 1550 299.31 a21
103 2898242 1629672 2012-06-29 2013-01-06 0982968456011 1 3la 0 0           0 0   Book - 1550 822 c754 l
104 2898516 1630126 2012-06-29 2013-01-06 0982973552010 1 2ga 0 0           0 0   Book - 1550 353.360977 qm662
105 2898446 1632022 2012-06-29 2013-01-06 1000534552012 1 2ga 0 0           0 0   Reference Book o 1550 368.5 qs738
106 2898673 1774634 2012-06-29 2013-01-06 1016777553012 1 3ha 0 0           0 0 0813506840 Book - 275 917.49 c38 e
107 3281336 1938461 2012-06-30 2013-01-07 1042420456015 1 3la 0 0           4 0 0435070266 Book - 1095 822.04508 m349 c
108 2896362 1770875 2012-06-29 2013-01-06 1016735353166 1 3ha 0 0           0 0   Book - 200 917.2 b27 b
109 2896248 1627752 2012-06-29 2018-09-19 0982920957015 1 3ca 0 0           0 0   Rare Book o 1550 fiction
110 2897011 1927122 2012-06-29 2014-03-12 1036178253012 1 3gar 0 0           0 0   Reference Book o 3000 929.375655 w988
111 2897027 1197694 2012-06-29 2013-01-06 1021824949015 1 2ea 0 0           0 0   Book - 795 796 b56
112 2897767 1371344 2012-06-29 2013-01-06 0966415846015 1 3aa 0 0           0 0   Reference Book o 395 745.0973 qr424
113 2897710 1628736 2012-06-29 2013-01-06 0982955852024 1 2ga 0 0           0 0   Reference Book o 1550 320.973 h325
114 1149093 2382826 2012-06-23 2013-01-04 6502283051034 1 1fa 0 0           0 0   Book - 450 fiction
115 2897843 1631254 2012-06-29 2013-01-06 1000511156019 1 3la 0 0           1 0   Book - 150 891.852 w99 m
116 7057162 2832128 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
117 2897093 1927274 2012-06-29 2013-01-06 953945-5001 1 2ea 0 0           0 0   Reference Book o 9995 365.02 qd598
118 2897138 1630855 2012-06-29 2013-01-06 1000503352014 1 2ga 0 0           0 0   Reference Book o 500 368.3 u59
119 2897299 1630943 2012-06-29 2013-01-06 1000506253011 1 3ha 0 0           0 0   Reference Book o 1550 910.4 c12
120 2897552 1631215 2012-06-29 2013-01-06 1000513052018 1 2ga 0 0           0 0   Reference Book o 1550 368.31 qs74
121 2898290 1629740 2012-06-29 2013-01-06 0982969248011 1 1lj 0 0           0 0   Reference Juvenile Book o 300 fiction
122 2898123 1773762 2012-06-29 2013-01-06 1016768153012 1 3ha 0 0           0 0   Book - 400 917.48 w54
123 2898552 1371965 2012-06-29 2013-01-06 0966432353011 1 3ea 0 0           0 0   Book - 375 929.75 m489 c
124 5707322 2779817 2012-07-03 2021-11-22 1829440-1001 1 1fa 302 300       2021-08-25 2021-09-09 37 18   Music on CD g 2998 cd-classical opera bizet b625c 2010
125 2899367 1633373 2012-06-29 2013-01-06 1000554749027 1 2ea 0 0           5 0 0816516022 Book - 2195 128.089972 s399
126 2899125 1632889 2012-06-29 2013-01-06 1000548453017 1 3ha 0 0           0 0   Reference Book o 1550 910 b54
127 2899132 1631302 2012-06-29 2013-01-06 0982990152018 1 2ga 0 0           0 0   Book - 1550 352.238609 c518
128 2899425 1633451 2012-06-29 2013-01-06 1000555946010 1 3aa 0 0           0 0 0899900763 Reference Book o 4000 786.509 qh591
129 2899265 1631502 2012-06-29 2013-01-06 0982992452010 1 2ga 0 0           0 0   Reference Book o 1200 352.290973 qt519
130 7057351 2832317 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
131 2899756 1632216 2012-06-29 2018-05-22 0983000757010 1 3ca 0 0           0 0   Rare Book o 1550 331.125 d48
132 2900053 1372733 2012-06-29 2013-01-06 0966458956010 1 3la 0 0           0 0   Reference Book o 1550 428.2 c3 .1
133 5809067 2567479 2012-07-03 2021-07-19 1658152-1002 1 3la 801 10       2018-10-30 2019-02-14 26 9 1557288224 Book m 2112 811.54 c712 ap
134 2898747 1630589 2012-06-29 2013-01-06 0982978952017 1 2ga 0 0           3 0 0896801845 Book - 2200 327.866009 h615
135 1149298 2384095 2012-06-23 2013-01-04 6502360552037 1 2ga 0 0           0 0   Book - 1550 336.2 f714
136 2898943 1775165 2012-06-29 2016-06-27 1016783052017 1 2ga 0 0           0 0 0375401555 Reference Book o 1095 340.14 c589
137 2899402 1372506 2012-06-29 2013-01-06 0966455253015 1 3ha 0 0           0 0   Reference Book o 1550 910 p94
138 2899412 1631723 2012-06-29 2013-01-06 0982994652054 1 2ga 0 0           0 0   Book - 180 320.473 m968 a
139 2899544 1631925 2012-06-29 2018-05-22 0982996757018 1 3ca 0 0           0 0   Rare Book o 1550 330.9771 e86
140 2899676 1632098 2012-06-29 2018-05-22 0982999357014 1 3ca 0 0           0 0   Rare Book o 1550 330.162 b156 c
141 2899865 1776478 2012-06-29 2013-01-06 1016799953018 1 3ha 0 0           0 0   Book - 300 917.4 s44 w
142 2899741 1632198 2012-06-29 2018-05-22 0983000457017 1 3ca 0 0           0 0   Rare Book o 1550 330.9034 k54
143 2898098 1197787 2012-06-29 2013-01-06 0912143652010 1 2ga 0 0           19 0 0889140529 Book - 1095 385.0971 ql513
144 2898498 1774328 2012-06-29 2013-01-06 1016774653013 1 3ha 0 0           0 0   Book - 275 917.3 g97 f
145 7057207 2832173 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
146 2899031 1372301 2012-06-29 2013-01-06 0966440653014 1 3gar 0 0           0 0   Reference Book o 450 929.3 t69
147 3544154 1035745 2012-06-30 2016-09-08 0916593352013 1 2ga 0 0           12 0   Book - 375 327.73072 f673
148 1900170 1200587 2012-06-27 2014-04-21 0934082552019 1 2ga 0 0           17 0 0891331530 Book - 1695 387.15 qh734
149 2899120 1632873 2012-06-29 2013-01-06 1000548253011 1 3ha 0 0           0 0   Book - 300 910 h889
150 1149395 2384698 2012-06-23 2013-01-04 6502410649023 1 2ea 0 0           0 0   Book - 595 191.08 k96 am
151 2900402 1197907 2012-06-29 2013-01-06 0912150252019 1 2ga 0 0           0 0   Reference Book o 6000 341.754 qi61 s
152 2900007 1634591 2012-06-29 2018-05-22 1000571857019 1 3ca 0 0           0 0   Rare Book o 50 356.14 c57
153 2900293 1935387 2012-06-29 2013-02-14 954778-145001 19 hpaoo 0 0           0 0   Reference Book o 1000 917.71770025 fh153 e
154 2899918 1935003 2012-06-29 2013-01-06 1036267352014 1 2rar 0 0           0 0 078763171X Reference Book o 3140 323.173 e57
155 2900054 1632654 2012-06-29 2013-01-06 0983006552019 1 2ga 0 0           3 0   Book - 895 355.033556 p437
156 2900170 1632785 2012-06-29 2013-01-06 0983007952010 1 2ga 0 0           0 0   Book - 1550 352.238097 w754
157 1149456 2384871 2012-06-23 2013-01-04 6502422352020 1 2ga 0 0           0 0   Book - 975 301.364 h376
158 2899953 1776615 2012-06-29 2019-05-07 1016801453015 1 3ha 0 0           0 0   Reference Book o 1650 917.4 w78 1968
159 1149474 2385013 2012-06-23 2013-01-04 6502432951027 1 1fa 0 0           0 0   Book - 450 fiction
160 2900368 1372907 2012-06-29 2019-05-08 0966463158016 1 2sa 0 0           0 0   Reference Book o 1550 627.138 n532 , 1901
161 2900277 1777107 2012-06-29 2019-04-29 1016807253013 1 3ha 0 0           0 0   Book - 495 917.28045 c595 , 1964
162 2900701 1373170 2012-06-29 2013-01-06 0966470653017 1 3ha 0 0           0 0   Reference Book o 2500 973.5 c899 zs
163 2900529 1635488 2012-06-29 2013-01-06 1000584153018 1 3ha 0 0           0 0   Book - 190 914.2 w984
164 2900538 1633369 2012-06-29 2013-12-12 0983015053017 1 3ha 12 300       2013-12-05 2013-12-11 4 0   Book - 500 942.07 w72 w
165 2900227 1632863 2012-06-29 2015-05-20 0983008753011 1 3ha 0 0           0 0   Reference Book o 1000 973.46092 j45 xb
166 2901070 1636204 2012-06-29 2013-01-06 1000594653015 1 3ea 0 0           0 0   Reference Book o 1550 369.121 s68 .3
167 2900758 1778062 2012-06-29 2013-01-06 1016818553013 1 3ha 0 0           0 0   Book - 400 917.3 j72
168 2900712 1373180 2012-06-29 2013-01-06 0966470853013 1 3ha 0 0           0 0   Reference Book o 750 975.284 b789
169 2900713 1777978 2012-06-29 2013-01-06 1016817453017 1 3ha 0 0           0 0   Book - 1295 917.55044 qf898
170 1149541 2385439 2012-06-23 2013-01-04 6502464148021 1 1lj 0 0           2 0   Juvenile Book - 575 398.4
171 2900744 1633560 2012-06-29 2019-06-25 0983019253019 1 3ha 0 0           0 0   Reference Book o 1550 973.56 qi64 , 1903
172 2900876 1778269 2012-06-29 2013-01-06 1016821453011 1 3ha 0 0           0 0   Book - 1550 917.3 k17
173 2901237 1778871 2012-06-29 2018-09-19 1016829157010 1 3ca 0 0           0 0   Rare Book o 1550 820.82 d548 x
174 2900831 1373312 2012-06-29 2013-01-06 0966474046010 1 3ra 0 0           0 0 0826209084 Book - 2995 708.178411 n432 zw
175 2900729 1778015 2012-06-29 2013-01-06 1016817853018 1 3ha 0 0           0 0   Reference Book o 1550 917.5529 p134
176 2901863 1635132 2012-06-29 2013-01-06 0983039252017 1 2ga 0 0           0 0   Reference Book o 1550 355.03 f2 .1
177 2901782 1936997 2012-06-29 2013-01-06 1036293346014 1 3aa 0 0           0 0 0967692504 Reference Book o 7995 738.37 qs545 zm
178 8390469 3075151 2015-08-04 2018-07-30   50 vidow 0 0           0 0   Downloadable Music v 0 emusic
179 2901209 1778871 2012-06-29 2019-06-10 1016828057013 1 3ca 0 0           0 0   Rare Book o 1550 820.82 d548 x
180 2901286 1778871 2012-06-29 2018-09-19 1016831257014 1 3ca 0 0           0 0   Rare Book o 1550 820.82 d548 x
181 2900431 1633172 2012-06-29 2013-01-06 0983012853013 1 3ha 0 0           0 0 9068091972 Reference Book o 1661 912.492 p386
182 2901094 1634032 2012-06-29 2013-01-06 0983025452019 1 2ga 0 0           0 0   Book - 1550 352.40941 w739
183 2901515 1373783 2012-06-29 2013-01-06 0966485952016 1 2ga 0 0           5 0   Book - 950 382.0942 a547
184 2901058 1778602 2012-06-29 2013-01-06 1016824946011 1 3aa 0 0           0 0 0899900836 Reference Book o 2750 787.2092 b458 zbae
185 2901352 1634358 2012-06-29 2013-01-06 0983029452015 1 2ga 0 0           0 0   Reference Book o 995 330.9 d744
186 2901383 1636339 2012-06-29 2013-01-06 1000599753018 1 3ea 0 0           0 0   Reference Book o 1550 369.133 m62
187 2901731 1634858 2012-06-29 2018-09-19 0983036157011 1 3ca 0 0           0 0   Rare Book o 1550 826.912 c754 c
188 2901750 1636498 2012-06-29 2013-01-06 1000606053014 1 3ea 0 0           0 0   Reference Book o 1550 369.135 oc. 2
189 2902013 1780758 2012-06-29 2013-01-06 1016854253015 1 3ha 0 0           0 0   Book - 270 917.44 r84
190 2901780 1780203 2012-06-29 2013-01-06 1016848256017 1 3la 0 0           0 0 076181213X Book - 4400 843.7 a419 zh
191 2901897 1937500 2012-06-29 2013-01-06 1036301346014 1 3aa 0 0           7 0 0066209684 Reference Book o 5000 779.93023 fl897
192 2901585 1636455 2012-06-29 2013-01-06 1000602853011 1 3ea 0 0           0 0   Reference Book o 1550 369.135 n277 .2
193 7057317 2832283 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0 330 g62
194 2902462 1374605 2012-06-29 2013-07-08 1014545658015 1 2sa 0 0           0 0   Reference Book o 1550 629.287 qc558 da
195 2902468 1781471 2012-06-29 2013-01-06 1016866356012 1 3la 0 0           0 0 0313301395 Reference Book o 8500 813.52 f553 zgal
196 2902699 1637301 2012-06-29 2013-01-06 1000627153017 1 3ea 0 0           0 0   Reference Book o 1550 369.152 o4 .7
197 2902459 1374605 2012-06-29 2013-01-06 0966507958017 1 2sa 0 0           0 0   Reference Book o 400 629.287 qc558 da
198 2902530 1637173 2012-06-29 2013-01-06 1000624953013 1 3ea 0 0           0 0   Reference Book o 1550 369.152 o4
199 2903259 1782466 2012-06-29 2013-01-06 1016882753010 1 3ha 0 0           0 0   Reference Book o 150 917.471 m152
200 2902011 1374224 2012-06-29 2013-01-06 0966496746019 1 3aa 0 0           0 0   Reference Book o 795 759.6 qp58 pa

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"
);