home / collection-2021-01-04

item

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

5,515,381 rows sorted by checkout_statistic_group_code_num

✎ View and edit SQL

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
165 165 10053922 1014568 2018-09-24 2020-06-09 A000058636848 34 pramg 0 0           0 0   Magazine y 500 periodical
166 166 1014404 1768557 2012-06-23 2013-01-04 1015855-5001 1 3la 0 0           0 0 0198182619 Reference Book o 3500 820.9 o985
167 167 1014689 1771796 2012-06-23 2013-01-04 1043507858016 1 2sa 0 0           0 0   Reference Book o 1550 557.61 a41
168 168 1014759 1230384 2012-06-23 2013-01-04 0922221849016 1 2ea 0 0           7 0 0404567428 Book - 1000 378.19822 d255
170 170 1014852 1774183 2012-06-23 2013-01-04 1043532558011 1 2sa 0 0           0 0   Reference Book o 1550 557.58 qg34
176 176 1015330 1781516 2012-06-23 2013-01-04 1043613846012 1 3aa 0 0           0 0 0893819964 Reference Book o 5000 770.9 qa641 zp
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
182 182 1015714 1231028 2012-06-23 2013-01-04 0922238153014 1 3ha 0 0           0 0 0198200862 Reference Book o 5700 942.034 s775
184 184 1015993 1043624 2012-06-23 2013-01-04 0903184158017 1 2sa 0 0           1 0 0932620124 Book - 612 641.507 82
185 185 1016045 1790394 2012-06-23 2013-01-04 1043722152013 1 2ga 0 0           0 0 0962111856 Book - 1500 658.3044 qg244
190 190 1016435 1794332 2012-06-23 2013-01-04 1043764658018 1 2sa 0 0           0 0   Reference Book o 1550 557.73 i27
191 191 1016475 1794633 2012-06-23 2013-01-04 1043767958027 1 2sa 0 0           0 0   Book - 1550 557.73 i27
192 192 1016519 1794980 2012-06-23 2013-01-04 1043771358016 1 2sa 0 0           0 0   Reference Book o 1550 557.73 i27
196 196 11008460 3570810 2020-12-28 2020-12-28   1 1pabr 0 0           0 0 9786317398511 Bluray p 1467  
197 197 8042257 2553321 2014-12-03 2019-10-21 A000040262297 3 avtf 0 0           0 0 9780758234421 Teen Book w 995 fiction
200 200 1017017 1800283 2012-06-23 2013-01-04 1043826952011 1 2ra 0 0           2 0 0878408878 Book - 5300 368.5728 p561
201 201 1017085 1231744 2012-06-23 2013-01-04 1044733156019 1 2rar 0 0           0 0   Reference Book o 18000 801.9509 qc614
202 202 1017101 1231744 2012-06-23 2013-01-04 101906-116001 1 2rar 0 0           0 0   Reference Book o 19065 801.9509 qc614
203 203 1017126 1231744 2012-06-23 2013-01-04 101906-141001 1 2rar 0 0           0 0   Reference Book o 24300 801.9509 qc614
206 206 1017425 1231884 2012-06-23 2013-01-04 0922258058010 1 2sa 0 0           1 0   Book - 1495 541.28 69
208 208 1017755 1806675 2012-06-23 2013-01-04 1043899052012 1 2ga 0 0           0 0 0517460858 Book - 898 385.065 fn532 zk
209 209 1017787 1807054 2012-06-23 2013-01-04 1043903158011 1 2sa 0 0           0 0 9241545550 Reference Book o 400 616.707572 qd261
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
213 213 1018396 1232407 2012-06-23 2013-01-04 0922269546037 1 3aa 0 0           0 0   Reference Music Score o 995 m4.8 qs844 c
214 214 1018403 1232413 2012-06-23 2013-01-04 0922269651027 1 1fa 0 0           0 0   Book - 395 fiction
216 216 1018595 1043723 2012-06-23 2013-01-04 0903192458029 1 2sa 0 0           0 0   Reference Book o 495 508 qc321
217 217 1018833 1819721 2012-06-23 2013-01-04 1044048153016 1 3ha 0 0           0 0 0875300332 Reference Book o 895 912.755581 fa382
218 218 1018836 1819750 2012-06-23 2013-01-04 1044048453010 1 3ha 0 0           0 0 0875300367 Reference Book o 895 912.75251 fa375
220 220 1018979 1821348 2012-06-23 2014-09-05 1044065641067 32 osjnf 0 0           3 0 0516226703 Juvenile Book - 1900 975.8 b831
221 221 1019099 1232867 2012-06-23 2013-01-04 0922284158040 1 2sa 0 0           1 0   Reference Book o 300 623.82 qm919
223 223 1019187 1823283 2012-06-23 2013-01-04 1044091848025 1 1lj 0 0           0 0 0516224786 Juvenile Book - 2950 977.6 h345
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
230 230 1019737 1828691 2012-06-23 2013-01-04 1044152652019 1 2ga 0 0           0 0   Reference Book o 400 333.709771 qc633
231 231 1019752 1828793 2012-06-23 2013-01-04 1044153858011 1 2sa 0 0           0 0   Book - 650 623.82 j77
237 237 1020597 1837338 2012-06-23 2013-01-04 1044251358013 1 2sa 0 0           0 0   Reference Book o 1550 620 i28
238 238 1020599 1837355 2012-06-23 2013-01-04 1044251558018 1 2sa 0 0           0 0   Reference Book o 1550 620 i28
240 240 1020816 1839489 2012-06-23 2013-01-04 1044279958018 1 2sa 0 0           0 0 0889320381 Book - 895 688.79 w177
242 242 1020907 1840590 2012-06-23 2018-07-03 1044292157010 1 3ca 0 0           0 0   Rare Book o 500 629.133 j29
243 243 1020916 1840784 2012-06-23 2013-01-04 1044294258014 1 2sa 0 0           6 0 0387953892 Book - 7495 576.50151 l274
244 244 1021071 1842171 2012-06-23 2018-06-05 1023328-26001 28 nrar 0 0           0 0 1932250034 Reference Book o 4800 929.377177 qh536 s 2003
245 245 1021157 1233875 2012-06-23 2013-01-04 0922310549014 1 2ea 0 0           1 0   Book - 400 364.163 b995
246 246 1021227 1233906 2012-06-23 2013-01-04 0922311146034 1 3aa 0 0           4 0   Book - 1550 709 qj35
247 247 1021253 1844268 2012-06-23 2013-01-04 1044335853013 1 3ha 0 0           0 0   Book - 400 917.88830433 t969
248 248 1021291 1844722 2012-06-23 2013-01-04 1044341653019 1 3gar 0 0           0 0   Reference Book o 500 929.377175 qa188 b
249 249 1021391 1234018 2012-06-23 2013-01-04 0922313653029 1 3ha 0 0           14 0 0801834570 Book - 2950 947.0842 s782 zsl
250 250 1021401 1846171 2012-06-23 2013-01-04 1044357456018 1 3la 0 0           0 0   Book - 175 831 r573 ma
251 251 1021405 1846216 2012-06-23 2018-09-04 1044357853016 1 3gar 0 0           0 0 0970798806 Reference Book o 4995 929.37949 qg682 , 2001
252 252 1021513 1234057 2012-06-23 2013-01-04 0959011553010 1 3ha 0 0           0 0   Reference Book o 28000 920.056 qw628
254 254 10706614 3487294 2020-01-17 2020-01-22 A000067922122 1 nrjf 0 0           0 0 9780736439893 Juvenile Book - 699 fiction
260 260 1022055 1234400 2012-06-23 2013-01-04 0922325156011 1 3la 0 0           0 0 0520025423 Reference Book o 2000 818.409 c625 a2
261 261 1022068 1853645 2012-06-23 2013-01-04 1044437952010 1 2ra 0 0           0 0 0821353365 Book - 1000 382.450009 qm621
263 263 1022383 1858669 2012-06-23 2013-01-04 1044492858011 1 2sa 0 0           0 0   Reference Book o 1000 669.735 m587
264 264 1022585 1861809 2012-06-23 2013-01-04 1044529356013 1 2rar 0 0           0 0 0787660191 Reference Book o 19000 810.9003 qd554
266 266 1022687 1234930 2012-06-23 2013-01-04 0922337853019 1 3ha 0 0           0 0 0840771142 Reference Book o 465 975.502 g475
268 268 1022945 1869415 2012-06-23 2013-01-04 1044616158017 1 2sa 0 0           0 0   Reference Book o 1550 622.009 c15
270 270 1023042 1870697 2012-06-23 2013-01-04 1044630258017 1 2sa 0 0           0 0   Reference Book o 1550 622.009 c15
272 272 1023192 1235358 2012-06-23 2013-01-04 0922348853024 1 3ha 0 0           0 0   Book - 895 940.5472 g975
273 273 1023255 1873646 2012-06-23 2013-01-04 1044660658011 1 2sa 0 0           0 0   Book - 200 636.7001 b992 pe
274 274 1023296 1235448 2012-06-23 2013-01-04 1012244158014 1 2sa 0 0           0 0   Reference Book o 1550 621.9 m14
275 275 1023298 1235448 2012-06-23 2013-01-04 1012244358010 1 2sa 0 0           0 0   Reference Book o 1550 621.9 m14
277 277 10054103 1642235 2018-09-24 2020-07-16 A000058637754 1 2mamh 0 0           0 0   Magazine w 500 periodical
280 280 1023731 1879698 2012-06-23 2013-01-04 1044758356015 1 3la 0 0           0 0 8806272357 Reference Book o 2395 852.914 f649 xe
281 281 1023751 1879749 2012-06-23 2013-01-04 1044737658010 1 2sa 0 0           0 0   Reference Book o 1550 540.5 qf21 s
284 284 1023922 1882823 2012-06-23 2013-01-04 1044772158017 1 2sa 0 0           0 0   Reference Book o 1550 622.009 t29
285 285 1024190 1885951 2012-06-23 2013-01-04 1044808658014 1 2sa 0 0           0 0   Reference Book o 1550 622.009 qc212 t
286 286 1024139 1885576 2012-06-23 2018-08-29 1044804249016 1 2ea 0 0           0 0   Reference Book o 1550 378.7468 y18 zy3 , 1905
287 287 1024268 1887625 2012-06-23 2013-01-04 1044828746013 1 3aa 0 0           0 0   Reference Book o 400 741.94074 fs625
289 289 11008513 2524040 2020-12-28 2020-12-28   1 tsad 0 0           0 0   DVD/Videocassette p 733 dvd action w251 2008
290 290 1024525 1043984 2012-06-23 2013-01-04 0903218152051 1 2ga 0 0           0 0   Book - 1100 312.09771 qc396 p
291 291 1024661 1236430 2012-06-23 2013-01-04 0922377052019 1 2ga 0 0           0 0 0029193419 Book - 2250 353.123309 l866
293 293 11008850 3563369 2020-12-28 2020-12-28   1 tsac 0 0           0 0 9786318427128 Music on CD p 1188  
295 295 1024864 1044024 2012-06-23 2019-07-18 0903219441016 32 osanf 0 0           0 0 0440192242 Book w 350 fiction
296 296 1024945 1898753 2012-06-23 2013-01-04 1044957046011 1 3aa 0 0           0 0   Reference Book o 400 708.949457 k96 zk
297 297 1025066 1900567 2012-06-23 2013-01-04 1045031358017 1 2sa 0 0           0 0   Reference Book o 1550 543.3 qi2
300 300 1025480 1907426 2012-06-23 2013-01-04 1045051749012 1 2ea 0 0           0 0 0929874269 Book - 400 131 s243
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  
304 304 1026170 1918929 2012-06-23 2013-01-04 1046116749013 1 2ea 0 0           0 0   Reference Book o 1550 378.744 h3398
305 305 1026285 1920724 2012-06-23 2019-05-15 1045205053014 1 3garo 0 0           0 0 0195081374 Reference Book o 9833 929.40973 qd554 , 2003
307 307 1026326 1237845 2012-06-23 2013-01-04 0922410849017 1 2ea 0 0           6 0 087975382X Book - 1695 133.8 r287
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
311 311 1026805 1929075 2012-06-23 2013-01-04 1045292952011 1 2ga 0 0           0 0   Reference Book o 1550 658.57 m678
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
314 314 2421409 1770915 2012-06-29 2019-04-03 1024619957011 1 3ca 0 0           0 0   Rare Book o 1550 977.178 qm853 za 1914
315 315 1027790 1238869 2012-06-23 2013-01-04 0922434146028 1 3aa 0 0           0 0   Reference Book o 2450 791.43028 qk95 zce
316 316 1027861 1942116 2012-06-23 2013-01-04 1045439752019 1 2ra 0 0           0 0 0198298315 Book - 3995 328.41071 g786 zr
317 317 1027915 1943211 2012-06-23 2013-01-04 1045451052017 1 2ga 0 0           0 0   Reference Book o 1550 658.5 a51 ma
318 318 1028007 1944618 2012-06-23 2018-09-04 1045469756021 1 3la 0 0           0 0 880439109X Book - 7995 858.91408 b447 xf 1994
320 320 1028305 1949182 2012-06-23 2013-01-04 1034373-1002 1 2raoo 0 0           0 0   Book - 400 371.071273 c363 zbu2
321 321 1028519 1951389 2012-06-23 2013-01-04 1045547458012 1 2rar 0 0           0 0 0240804546 Reference Book o 6350 621.3893 qh236
323 323 1028900 1955224 2012-06-23 2017-10-19 1045594053013 1 3ha 0 0           0 0 029598077X Reference Book o 1795 973 qb831 , 2001
324 324 1028987 1956024 2012-06-23 2013-01-04 1045603046016 1 3aa 0 0           0 0 9645533619 Book - 3595 782.421629 t176
326 326 1029122 1957765 2012-06-23 2013-01-04 1045623752015 1 2ga 0 0           0 0   Reference Book o 1550 658 o37 c
327 327 1029147 1957890 2012-06-23 2013-01-04 1045626452019 1 2ga 0 0           0 0   Reference Book o 1550 658 o37 c
328 328 1029206 1958536 2012-06-23 2013-01-04 1045635752011 1 2ga 0 0           0 0   Book - 1550 658.5 a51 mr
330 330 1029445 1960544 2012-06-23 2018-09-04 1045658553015 1 3ha 0 0           0 0 1587650533 Reference Book o 5937 909.82 qg7862, 2002
331 331 1029658 1963218 2012-06-23 2013-01-04 1045686558010 1 2sa 0 0           0 0   Reference Book o 1550 693.7 qa512
332 332 1029714 1240005 2012-06-23 2019-10-21 0922462458022 1 2sa 0 0           0 0   Reference Book o 495 581.659097 m948 , 1960
336 336 1030005 1967908 2012-06-23 2013-01-04 1045747856015 1 3la 0 0           0 0 0142001708 Reference Book o 1400 423.1 n5323

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"
);
Powered by Datasette · Query took 2532.581ms · Data source: https://ilsweb.cincinnatilibrary.org/collection-analysis-docs/