home / collection-2021-01-04

item

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

5,515,381 rows sorted by item_callnumber

✎ 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 ▼
196 196 11008460 3570810 2020-12-28 2020-12-28   1 1pabr 0 0           0 0 9786317398511 Bluray p 1467  
293 293 11008850 3563369 2020-12-28 2020-12-28   1 tsac 0 0           0 0 9786318427128 Music on CD p 1188  
303 303 11008641 3567551 2020-12-28 2020-12-28   1 tsac 0 0           0 0   Music on CD p 974  
416 416 9239393 3245045 2017-02-07 2018-01-26 A000040901027 1 3ca 1 1 2017-11-15 2017-12-06 1 2017-11-14 2017-11-15 2 0   Rare Book o 0  
1845 1845 11004590 3387357 2020-12-22 2020-12-31 A000069421875 1 tsaar 0 0           0 0 1786814226 Book t 1299  
2394 2394 11011833 3572647 2020-12-30 2020-12-30   1 tsjho 0 0           0 0 9781910307472 Juvenile Book p 1499  
2439 2439 11011938 3572662 2020-12-30 2020-12-30   1 tstf 0 0           0 0 9781975399351 Teen Book p 1500  
2444 2444 11011934 3572662 2020-12-30 2020-12-30   1 tstf 0 0           0 0 9781975399351 Teen Book p 1500  
2541 2541 11012011 3573490 2020-12-30 2020-12-30   1 tsjnf 0 0           0 0 9780997318722 Juvenile Book p 1895  
2825 2825 11012409 3572691 2020-12-30 2020-12-30   1 tsaab 0 0           0 0 9781250752192 Book on CD p 2222  
3099 3099 10703514 3172041 2020-01-14 2020-01-23 A000068309220 1 getgn 0 0           0 0 9780316309523 Teen Book - 2400  
6696 6696 10712754 2614313 2020-01-22 2021-01-01 A000068327115 1 dtanf 210 210 2020-12-30 2021-02-10 dt 2020-10-10 2020-10-21 3 3 9780061537110 Book - 1599  
8582 8582 1634056 2677994 2012-06-26 2018-07-31   50 viint 0 0           0 0   Web Document v 0  
14038 14038 10219471 3489411 2019-01-17 2021-01-01 A000062940004 37 haanf 281 280       2020-02-22 2020-03-09 4 12   Book - 2495  
27451 27451 10729035 3512148 2020-01-31 2020-01-31 A000011912961 1 1pal 0 0           0 0   Large Print Book - 2895  
27544 27544 10729063 3512150 2020-01-31 2021-01-01 A000011912300 0 osanf 0 0       2020-01-31 2020-02-12 1 0   Book - 0  
27634 27634 10729114 3512153 2020-01-31 2021-01-01 A000011913266 2 cranf 0 0       2020-01-31 2020-02-07 1 0   Book - 2795  
28593 28593 10726391 3511650 2020-01-29 2020-02-11 A000011911807 14 fojbi 0 0           0 0   Juvenile Book - 1795  
33332 33332 8313138 3051591 2015-06-16 2018-11-21 A000040927667 1 4da 491 490       2016-06-13 2016-06-15 1 0 9780160926761 Government Document - 4000  
33965 33965 7060627 2835593 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
35966 35966 7019444 2827061 2013-02-20 2019-08-30 A000030361018 38 mwad 382 1       2014-08-19 2019-08-30 67 30   DVD/Videocassette e 2999  
35976 35976 7019690 2827152 2013-02-20 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
35977 35977 7019694 2827156 2013-02-20 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
35990 35990 7020134 2827559 2013-02-20 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36003 36003 7020418 2827783 2013-02-20 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36022 36022 7056517 2831483 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36035 36035 7056833 2831799 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36038 36038 7056905 2831871 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36078 36078 7058420 2833386 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36079 36079 7058506 2833472 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36092 36092 7058916 2833882 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36098 36098 7059026 2833992 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36107 36107 7059280 2834246 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36108 36108 7059331 2834297 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36110 36110 7059342 2834308 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36116 36116 7059661 2834627 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36117 36117 7059687 2834653 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36119 36119 7059737 2834703 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36123 36123 7059825 2834791 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36124 36124 7059889 2834855 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36125 36125 7059862 2834828 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36129 36129 7060086 2835052 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36130 36130 7060102 2835068 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36134 36134 7060149 2835115 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36141 36141 7060393 2835359 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36145 36145 7060507 2835473 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36160 36160 7060759 2835725 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36161 36161 7060718 2835684 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36163 36163 7060806 2835772 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36165 36165 7060809 2835775 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36167 36167 7060915 2835881 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36170 36170 7061040 2836006 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36180 36180 7061176 2836142 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36188 36188 7061401 2836367 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36209 36209 7061724 2836690 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36221 36221 7061980 2836946 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36223 36223 7062048 2837014 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36261 36261 7062971 2837937 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36266 36266 7063091 2838057 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36269 36269 7063149 2838115 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36283 36283 7063606 2838572 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36284 36284 7063670 2838636 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36299 36299 7064014 2838980 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36309 36309 7064317 2839283 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36310 36310 7064343 2839309 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36311 36311 7064423 2839389 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36319 36319 7064589 2839555 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36320 36320 7064615 2839581 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36322 36322 7064721 2839687 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36340 36340 7065064 2840030 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36361 36361 7065434 2840400 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36376 36376 7065657 2840623 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36377 36377 7065703 2840669 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36380 36380 7065790 2840756 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36393 36393 7065932 2840898 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
36687 36687 7061351 2836317 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
41403 41403 10746803 3489961 2020-02-11 2021-01-01 A000068170127 1 smal 801 490 2020-12-10 2021-01-21 os 2020-11-10 2020-11-30 4 3 9781432872496 Large Print Book - 3799  
56205 56205 10784199 3520939 2020-03-09 2021-01-02 A000068641929 1 hajer 801 281 2020-11-21 2021-01-25 ha 2020-11-21 2020-11-21 5 1 9781368047845 Juvenile Book - 1699  
57000 57000 8657371 2841599 2016-01-14 2018-01-01 A000049160864 31 nstgn 302 400       2016-09-20 2016-10-04 3 3 9781401234676 Teen Book - 1699  
58067 58067 9167170 2841599 2016-12-13 2019-01-01 A000045610649 18 hatgn 800 280       2018-06-25 2018-08-27 2 4 9781401234676 Teen Book - 1799  
64509 64509 10463673 3461556 2019-07-18 2019-07-18   1 geaoo 0 0           0 0 9781538761878 Book p 1573  
66479 66479 7019729 2827191 2013-02-20 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
66599 66599 7019810 2827272 2013-02-20 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
66607 66607 7019818 2827280 2013-02-20 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
66662 66662 7019850 2827312 2013-02-20 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
66908 66908 7056260 2831226 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
66911 66911 7056263 2831229 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
67057 67057 10880843 1964741 2020-08-20 2021-01-01 A000070497146 1 majeb 323 320       2020-10-06 2020-10-28 3 0 9780593373194 Juvenile Book - 1099  
67060 67060 10880844 1964741 2020-08-20 2021-01-01 A000070497153 1 anjeb 102 102       2020-12-10 2020-12-23 4 0 9780593373194 Juvenile Book - 1099  
67115 67115 6931338 2819163 2012-12-07 2019-10-28 A000036936458 39 clanf 800 150       2017-12-18 2018-01-25 17 17 9780977919109 Book f 3500  
67123 67123 7056948 2831914 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
67128 67128 7056953 2831919 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
67201 67201 7057013 2831979 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
67208 67208 7057019 2831985 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
67301 67301 6959140 2820294 2013-01-03 2021-01-01 A000037027430 18 smadc 493 490       2020-09-19 2020-09-30 32 53 1422922324 DVD/Videocassette - 2995  
67468 67468 6989914 2819477 2013-01-25 2021-01-02 A000033659285 15 wtadt 801 510 2020-12-21 2021-01-11 wt 2020-03-03 2020-08-07 59 27 9781419864346 DVD/Videocassette - 1000  
67542 67542 7057651 2832617 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
67555 67555 7002521 2820257 2013-02-06 2020-03-27 A000033715442 1 1padm 1 1       2015-03-02 2015-03-24 82 38   DVD/Videocassette e 1999  
67588 67588 7057689 2832655 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
67641 67641 7015061 2821323 2013-02-15 2019-06-14 A000007289135 100 ycml 0 0           0 0   Reference Book o 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"
);
Powered by Datasette · Query took 1772.432ms · Data source: https://ilsweb.cincinnatilibrary.org/collection-analysis-docs/