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

6,018,901 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 7305366 2881577 2013-09-11 2020-01-03 A000036286672 25 maad 324 320       2019-12-09 2019-12-19 134 46   DVD/Videocassette t 1998 dvd drama d6111 2013
102 1009447 1973984 2012-06-22 2013-01-04 1042880846010 1 3aa 0 0           0 0 8487342884 Reference Book o 400 709.2074 qi24 zi
103 1009681 1975478 2012-06-22 2019-04-03 1042908157010 1 3carv 0 0           0 0   Rare Book o 1550 627.120973 u58
104 1009713 1975478 2012-06-22 2019-04-03 1042912557015 1 3carv 0 0           0 0   Rare Book o 1550 627.120973 u58
105 1009792 1975478 2012-06-22 2019-04-03 1042921257011 1 3carv 0 0           0 0   Rare Book o 1550 627.120973 u58
106 1009885 1975877 2012-06-23 2017-01-01 1042912951028 1 1fa 400 400       2015-08-11 2015-11-06 10 0 0743214447 Book - 2400 fiction
107 1009843 1975511 2012-06-23 2013-01-04 1042897358017 1 2sa 0 0           0 0   Reference Book o 1550 507 ff46 .2
108 7642472 2958995 2014-03-25 2018-07-30   50 vidow 0 0           0 0 9780738217130 Downloadable Book v 0 ebook
109 1010031 1977559 2012-06-23 2013-01-04 1042941746019 1 3aa 0 0           0 0 290143262X Reference Book o 400 759.4 s223 zs
110 1010067 1977960 2012-06-23 2013-01-04 1042945846013 1 3aa 0 0           0 0   Reference Book o 400 709.2074 a792 za2
111 1010208 1979450 2012-06-23 2013-01-04 1042961546018 1 3aa 0 0           0 0   Reference Book o 400 709.04 fk17
112 1010243 1228039 2012-06-23 2013-01-04 6802274948010 1 1lj 0 0           0 0   Juvenile Book - 395 j948
113 1010298 1980593 2012-06-23 2019-04-16 1042972948021 1 1lj 1 1       2019-03-28 2019-04-16 3 2 1582460272 Juvenile Book - 1495 easy
114 9241986 3227466 2017-02-08 2019-11-23 A000053706487 19 smjf 801 490       2019-09-16 2019-11-23 12 23 1338117556 Juvenile Book - 999 fiction
115 7642941 2927426 2014-03-25 2019-08-05 A000042377598 28 moaf 361 360       2019-07-08 2019-08-05 29 12 9781250010094 Book - 2799 fiction
116 7643460 2958134 2014-03-25 2019-06-14 A000042382747 6 wtjeb 510 1       2014-05-19 2019-06-14 5 0 9780544142282 Juvenile Book e 1699 easy
117 1010816 1983209 2012-06-23 2013-01-04 1011856-12001 1 2ga 0 0           0 0   Reference Book o 1000 659.058 qs785 g
118 1010863 1983237 2012-06-23 2013-01-04 1011859-3001 1 2ga 0 0           0 0   Reference Book o 1000 659.1 qs785
119 1010868 1983237 2012-06-23 2013-01-04 1011859-9001 1 2ga 0 0           0 0   Reference Book o 129900 659.1 qs785
120 1010872 1983398 2012-06-23 2013-01-04 1043014946015 1 3aa 0 0           0 0 4118926733 Music Score - 3500 m4.21858 p964 c3
121 1010938 1984235 2012-06-23 2013-01-04 1043026146018 1 3aa 0 0           0 0   Reference Book o 400 709.2074 qa342 za
122 1010949 1984347 2012-06-23 2013-01-04 1043027246015 1 3aa 0 0           0 0 0899510523 Reference Book o 400 779.074794 qo58
123 9726468 2153819 2018-01-19 2019-03-13 A000051236735 1 2mamh 1 360       2018-10-10 2018-10-20 1 0   Magazine w 500 periodical
124 1011105 1985703 2012-06-23 2013-01-04 1043046553011 1 3gar 0 0           0 0   Reference Book o 1400 929.377112 qr3232
125 1011078 1985403 2012-06-23 2013-01-04 1043042458017 1 2sa 0 0           0 0   Reference Book o 1550 507 f46 .1
126 1011179 1986916 2012-06-23 2014-08-05 1043059405018 7 clar 0 0           1 0 1882203917 Reference Book o 3495 027.477178 fp976 zf
127 7305492 2885085 2013-09-11 2018-11-10 A000036586162 22 mdad 330 1       2013-10-31 2018-11-10 7 3   DVD/Videocassette e 2299 dvd suspense s8973 2013
128 1011207 1986964 2012-06-23 2013-01-04 1043059858018 1 2sa 0 0           0 0   Reference Book o 6000 507 f46
129 1011278 1987602 2012-06-23 2013-01-04 1043066346015 1 3aa 0 0           0 0   Reference Book o 400 709.040074 c3921
130 1011304 1987841 2012-06-23 2013-01-04 1043068753010 1 3galr 0 0           0 0   Reference Book o 400 977.211 qs642
131 8044803 2432254 2014-12-04 2019-01-01 A000040238446 36 dpjf 422 420       2018-10-04 2018-11-15 18 28 9780316058438 Juvenile Book w 700 fiction
132 7656689 2959360 2014-04-01 2019-02-25 A000040103442 12 nwanf 800 340       2017-10-11 2017-10-30 12 10 9780385345002 Book f 2999 641.5975 qv218 2014
133 1011652 1228613 2012-06-23 2013-01-04 0922177856015 1 3la 0 0           0 0 0842500790 Reference Book o 1495 813.52 qb972 zp
134 1011692 1991269 2012-06-23 2013-01-04 1043111646013 1 3aa 0 0           0 0   Reference Book o 400 709.2074 qm829 zm3
135 1011721 1228659 2012-06-23 2013-01-04 0922178953019 1 3ha 0 0           5 0 0393056295 Book - 895 979.2 p485
136 8270424 1981622 2015-05-13 2019-12-24 A000043950922 42 grjgn 801 260 2019-10-22 2020-01-16 gr 2019-09-07 2019-10-07 18 6   Juvenile Book - 999 741.5 qp7612
137 9239023 1023871 2017-02-06 2018-10-15 A000043315951 4 baamg 124 120       2017-11-16 2017-12-14 6 2   Magazine w 0 periodical
138 1011803 1992230 2012-06-23 2013-01-04 1043123751017 1 1fa 0 0           11 0 0393049787 Book - 2595 fiction
139 1011866 1992773 2012-06-23 2018-04-18 1043132956037 1 3la 0 0           0 0 031227307X Book w 400 070.444 a211 za
140 1011939 1004750 2012-06-23 2013-01-04 0503651249016 1 2ea 0 0           5 0   Reference Book o 1550 277.46 g81
141 1011993 1993795 2012-06-23 2013-01-04 1043146658017 1 2sa 0 0           0 0   Reference Book o 6000 507 f46
142 1012049 1994175 2012-06-23 2013-01-04 1043152358015 1 2sa 0 0           0 0   Reference Book o 1550 507 f46
143 7642647 2958835 2014-03-25 2019-02-12 A000042380808 25 grjnf 801 260       2018-12-12 2019-02-12 13 9 9781426212864 Juvenile Book - 2295 508.2 b854 2013
144 1012085 1994327 2012-06-23 2019-01-01 1043155558017 1 2sa 800 100       2018-05-17 2018-06-26 1 2 093732101X Book - 795 598.0978 s438
145 1012197 1228897 2012-06-23 2017-01-01 0922186049016 1 2ea 243 360       2015-10-07 2015-11-23 1 2 052284233X Book - 750 371.979 s666
146 1012246 1995538 2012-06-23 2013-01-04 1043174058015 1 2sa 0 0           0 0   Reference Book o 1550 507 f46
147 1012316 1228965 2012-06-23 2013-01-04 0922187656041 1 3la 0 0           0 0   Book - 175 822 c874 bi
148 1012378 1996565 2012-06-23 2013-01-04 1043189558017 1 2sa 0 0           0 0 0821823264 Reference Book o 6000 510.8 qa51 m
149 1012635 1229137 2012-06-23 2013-01-04 0922192358013 1 2sa 0 0           1 0   Book - 500 629.2882 72.2
150 1012709 1999023 2012-06-23 2019-04-27 1043236646013 1 3ra 520 1       2019-04-05 2019-04-27 13 9 1888698411 Book - 2995 791.4372 f457 zm
151 1012780 1004757 2012-06-23 2013-01-04 0503713452012 1 2ga 0 0           2 0   Book - 1550 326.973 r32
152 1012864 1751746 2012-06-23 2013-01-04 1043261356025 1 3la 0 0           0 0 1557832730 Book - 695 812.54 c515 zg
153 1012905 1752221 2012-06-23 2013-01-04 1043265756014 1 3ra 0 0           0 0 0933087683 Book - 1095 818.5407 f939
154 1012982 1753258 2012-06-23 2018-01-13 1043277052014 1 2ra 800 120       2017-11-03 2018-01-11 5 2 0761989765 Book - 6200 331.639507 w873
155 1013042 1753846 2012-06-23 2013-01-04 1043283451010 1 1fa 0 0           4 0 0743233034 Book - 2600 fiction
156 1013142 1754949 2012-06-23 2019-01-01 1043295741010 32 osjnf 1 10         2018-06-19 8 5 083685120X Juvenile Book - 2660 974.8 qi54
157 1013288 1229626 2012-06-23 2013-01-04 0922205153013 1 3ha 0 0           0 0 0253204402 Book - 3700 947.0841 b951
158 7643077 2958746 2014-03-25 2019-06-27 A000039618574 20 rejer 463 467       2019-06-15 2019-06-27 18 3 0062284991 Juvenile Book - 399 easy
159 1013360 1758226 2012-06-23 2013-01-04 1043338058018 1 2sa 0 0           0 0   Reference Book o 1550 557.62 m67
160 1013377 1043511 2012-06-23 2019-11-23 0903178751074 1 1fa 1 10         2019-11-23 13 0 0523485530 Book - 295 fiction
161 1013512 1760694 2012-06-23 2013-01-04 1043367658019 1 2sa 0 0           0 0   Reference Book o 1550 557.46 c75
162 1013610 1762067 2012-06-23 2018-07-03 1043387457012 1 3ca 0 0           0 0 0963411292 Rare Book o 1995 381.45002025 s571
163 7305671 2885889 2013-09-12 2019-07-26 A000038171617 8 coad 161 1       2014-07-10 2019-07-26 45 21 1415773785 DVD/Videocassette e 3099 dvd horror w927 2013
164 7305677 2885889 2013-09-12 2019-03-22 A000038171674 9 crad 170 1       2014-03-04 2019-03-22 30 13 1415773785 DVD/Videocassette e 3099 dvd horror w927 2013
165 1013785 1764068 2012-06-23 2013-01-04 1043414646017 1 3aa 0 0           0 0 0966676912 Reference Book o 5000 738.37 qh673
166 9716628 3308257 2018-01-11 2019-12-04 A000059325110 34 rejf 801 467 2019-05-24 2019-11-29 re 2019-05-12 2019-05-19 14 9 9781338189575 Juvenile Book - 599 fiction
167 1014077 1765809 2012-06-23 2013-01-04 1043436552011 1 2ra 0 0           2 0 156720516X Book - 6995 338.88 s949
168 1014170 1230092 2012-06-23 2013-01-04 0922215246021 1 3aa 0 0           0 0 0961354534 Reference Book o 1550 736.23 w891 c
169 1014161 1766604 2012-06-23 2017-10-18 1043444353014 1 3ha 0 0           0 0 0670829226 Reference Book o 5000 940 qd964 ee, 1990
170 1014294 1767285 2012-06-23 2013-01-04 1043451655913 1 4cdd 0 0           28 0   Magazine o 3000 xx(1015723.89)
171 9239086 1014072 2017-02-06 2019-01-01 A000043316280 4 baamg 123 120       2018-06-15 2018-06-28 6 7   Magazine - 0 periodical
172 10053922 1014568 2018-09-24 2018-09-24 A000058636848 34 pramg 0 0           0 0   Magazine - 500 periodical
173 1014404 1768557 2012-06-23 2013-01-04 1015855-5001 1 3la 0 0           0 0 0198182619 Reference Book o 3500 820.9 o985
174 1014585 1230294 2012-06-23 2018-05-14 0922219552044 1 2ga 0 0           1 0   Book w 795 343.7304 qa791
175 1014689 1771796 2012-06-23 2013-01-04 1043507858016 1 2sa 0 0           0 0   Reference Book o 1550 557.61 a41
176 1014759 1230384 2012-06-23 2013-01-04 0922221849016 1 2ea 0 0           7 0 0404567428 Book - 1000 378.19822 d255
177 9239097 1014025 2017-02-06 2019-08-05 A000043316132 4 baamg 800 370       2017-05-04 2017-09-06 7 6   Magazine w 0 periodical
178 1014852 1774183 2012-06-23 2013-01-04 1043532558011 1 2sa 0 0           0 0   Reference Book o 1550 557.58 qg34
179 1015169 1778905 2012-06-23 2014-04-07 1043584256019 1 2ra 800 100       2013-11-07 2014-04-05 3 2 0199250650 Book - 2797 401 i612
180 9722723 2769233 2018-01-15 2020-01-03 A000059088353 2 smadf 493 490       2019-11-25 2019-11-29 19 17   DVD/Videocassette - 1298 dvd foreign korea h831 2007
181 9239117 2341119 2017-02-06 2019-06-17 A000051151017 4 baamg 122 492       2018-08-04 2018-09-05 5 0   Magazine w 0 periodical
182 7305787 2885889 2013-09-12 2019-01-01 A000038172771 25 shad 801 480       2018-07-20 2018-10-11 114 59 1415773785 DVD/Videocassette $ 3099 dvd horror w927 2013
183 7305790 2885889 2013-09-12 2017-01-01 A000038172805 25 cvad 181 180 2015-02-26 2015-03-28 bh 2015-02-18 2015-02-24 50 36 1415773785 DVD/Videocassette n 3099 dvd horror w927 2013
184 1015330 1781516 2012-06-23 2013-01-04 1043613846012 1 3aa 0 0           0 0 0893819964 Reference Book o 5000 770.9 qa641 zp
185 1015351 1230826 2012-06-23 2019-05-20 0922233656011 1 3la 322 320       2017-04-10 2017-04-26 6 1 0262530708 Book - 2100 410 c548 l
186 9726614 2653698 2018-01-19 2019-12-18 A000059089195 7 smjf 801 490       2019-10-15 2019-12-18 12 14 0440498058 Juvenile Book - 699 fiction
187 8856954 3168668 2016-05-17 2018-04-06 A000052035987 1 1padm 1 1       2017-07-10 2017-07-16 40 26   DVD/Videocassette w 2999 dvd comedy z871t 2016
188 9726637 2653698 2018-01-19 2019-06-18 A000059089427 13 fojf 440 230       2019-06-11 2019-06-18 9 5 0440498058 Juvenile Book - 699 fiction
189 1015714 1231028 2012-06-23 2013-01-04 0922238153014 1 3ha 0 0           0 0 0198200862 Reference Book o 5700 942.034 s775
190 1015810 1787402 2012-06-23 2013-01-04 1043684256018 1 3la 13 1       2012-11-24 2012-11-25 1 0 0300041039 Book - 3500 841.912 m338
191 1015993 1043624 2012-06-23 2013-01-04 0903184158017 1 2sa 0 0           1 0 0932620124 Book - 612 641.507 82
192 1016045 1790394 2012-06-23 2013-01-04 1043722152013 1 2ga 0 0           0 0 0962111856 Book - 1500 658.3044 qg244
193 10414650 1052175 2019-06-10 2020-01-01 A000054833843 4 baamg 801 310       2019-10-31 2019-12-11 2 1   Magazine - 0 periodical
194 7643948 2947644 2014-03-25 2019-12-12 A000039622501 12 mojnf 361 360       2019-11-14 2019-12-12 18 3 9780753470886 Juvenile Book - 1299 599.7147 l791 2013
195 8045205 2994429 2014-12-04 2018-12-26 A000048338263 15 gejnf 0 0           0 0 9780716601159 Juvenile Book f 84900 031 qw92 2015
196 8044920 2702990 2014-12-04 2020-01-03 A000040266397 31 motf 363 360       2019-12-16 2020-01-03 34 33 9780062059932 Teen Book - 999 fiction
197 1016364 1793578 2012-06-23 2018-01-01 1043757851026 1 1fa 313 310       2016-12-02 2016-12-07 9 0 0688167810 Book - 2495 fiction
198 1016435 1794332 2012-06-23 2013-01-04 1043764658018 1 2sa 0 0           0 0   Reference Book o 1550 557.73 i27
199 1016475 1794633 2012-06-23 2013-01-04 1043767958027 1 2sa 0 0           0 0   Book - 1550 557.73 i27
200 1016519 1794980 2012-06-23 2013-01-04 1043771358016 1 2sa 0 0           0 0   Reference Book o 1550 557.73 i27

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