home / collection-2021-01-04

item

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

5,515,381 rows sorted by barcode

✎ 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
23 23 11007644 3172699 2020-12-28 2020-12-28   1 tsaar 0 0           0 0   Book p 1308 346.73052 r194
37 37 11007681 1302179 2020-12-28 2020-12-28   1 tsaar 0 0           0 0   Book p 2619 346.73052 qp699
60 60 11002771 3558996 2020-12-21 2020-12-21   1 tsadt 0 0           0 0 9781531712686 DVD/Videocassette p 2568 dvd tvadult r6281 2020
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
196 196 11008460 3570810 2020-12-28 2020-12-28   1 1pabr 0 0           0 0 9786317398511 Bluray p 1467  
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
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
289 289 11008513 2524040 2020-12-28 2020-12-28   1 tsad 0 0           0 0   DVD/Videocassette p 733 dvd action w251 2008
293 293 11008850 3563369 2020-12-28 2020-12-28   1 tsac 0 0           0 0 9786318427128 Music on CD p 1188  
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  
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
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
768 768 11010578 3547337 2020-12-29 2020-12-29   1 tsaar 0 0           0 0 9780857197689 Book p 1082 332.4019 h842 2020
800 800 11010626 3548988 2020-12-29 2020-12-29   1 tsal 0 0           0 0 9781432879716 Large Print Book p 3799 fiction
1641 1641 10413030 3459065 2019-06-07 2019-06-07   50 viint 0 0           0 0   Web Document v 0 electronic journal
1674 1674 10413056 3459091 2019-06-07 2019-06-07   50 viint 0 0           0 0   Web Document v 0 electronic journal
1867 1867 11011409 1340734 2020-12-30 2020-12-30   1 tstf 0 0           0 0 0152009507 Teen Book p 799 fiction
1878 1878 11011421 3048347 2020-12-30 2020-12-30   1 tstf 0 0           0 0 9780545695190 Teen Book p 1799 fiction
2146 2146 10049174 3385465 2018-09-20 2018-09-20   50 viint 0 0           0 0   Web Document v 0 electronic journal
2149 2149 10049206 3385497 2018-09-20 2018-09-20   50 viint 0 0           0 0   Web Document v 0 electronic journal
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  
2629 2629 11012175 2467936 2020-12-30 2020-12-30   1 osjoo 0 0           0 0 9780064402750 Juvenile Book p 699 fiction
2642 2642 10050215 3385699 2018-09-20 2018-09-20   50 vidow 0 0           0 0 9781492637141 Downloadable Book v 0 ebook
2647 2647 10050213 3385697 2018-09-20 2018-09-20   50 vidow 0 0           0 0 9781460328965 Downloadable Book v 0 ebook
2648 2648 10050232 3385716 2018-09-20 2018-09-20   50 vidow 0 0           0 0 9781681590691 Downloadable Book v 0 ebook
2650 2650 10050327 3385811 2018-09-20 2018-09-20   50 vidow 0 0           0 0 9781460384992 Downloadable Book v 0 ebook
2660 2660 11012191 2467936 2020-12-30 2020-12-30   1 osjoo 0 0           0 0 9780064402750 Juvenile Book p 699 fiction
2674 2674 11012211 3474041 2020-12-30 2020-12-30   1 tsjeb 0 0           0 0 9781771644730 Juvenile Book p 1795 easy
2684 2684 10050328 3385812 2018-09-20 2018-09-20   50 vidow 0 0           0 0 9781459290242 Downloadable Book v 0 ebook
2702 2702 11012251 3546785 2020-12-30 2020-12-30   1 tstgn 0 0           0 0 9781728412924 Teen Book p 1699 741.5 v671 2020
2714 2714 11006264 3568379 2020-12-23 2020-12-23   1 osjoo 0 0           0 0 9781978517493 Juvenile Book p 1840 782.421599 t239 2021
2752 2752 11012310 1025743 2020-12-30 2020-12-30   1 tsaar 0 0           0 0   Book p 1194 331.128 b691
2754 2754 10050610 3386094 2018-09-20 2018-09-20   50 vidow 0 0           0 0 9780814413906 Downloadable Book v 0 ebook
2755 2755 10050624 3386108 2018-09-20 2018-09-20   50 vidow 0 0           0 0 9781488031205 Downloadable Book v 0 ebook
2802 2802 10050609 3386093 2018-09-20 2018-09-20   50 vidow 0 0           0 0 9780912777276 Downloadable Book v 0 ebook
2823 2823 10050720 3386204 2018-09-20 2018-09-20   50 vidow 0 0           0 0 9781504055468 Downloadable Book v 0 ebook
2825 2825 11012409 3572691 2020-12-30 2020-12-30   1 tsaab 0 0           0 0 9781250752192 Book on CD p 2222  
2864 2864 11011728 3572988 2020-12-30 2020-12-30   1 tsaab 0 0           0 0 9781478916079 Book on CD p 4000 cd-spoken fiction beukes
2882 2882 10050856 3386339 2018-09-20 2018-09-20   50 vidow 0 0           0 0 9781418574048 Downloadable Book v 0 ebook
2932 2932 11012453 3073454 2020-12-31 2020-12-31   1 tstf 0 0           0 0 9781481463331 Teen Book p 738 fiction
2960 2960 11012497 3556495 2020-12-31 2020-12-31   1 tsaar 0 0           0 0 9781335430991 Book p 1083 fiction
2973 2973 11012495 3556495 2020-12-31 2020-12-31   1 tsaar 0 0           0 0 9781335430991 Book p 1083 fiction
3000 3000 11012548 3566981 2020-12-31 2020-12-31   1 tsaar 0 0           0 0 9781250273017 Book p 1517 fiction
3141 3141 11012733 3034808 2020-12-31 2020-12-31   1 tsjpu 0 0           0 0 0763665940 Juvenile Book p 2999 591.564 s541 2015
3195 3195 8862551 3180214 2016-05-21 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal
3197 3197 11012844 3547592 2020-12-31 2020-12-31   1 praar 0 0           0 0 9781501188817 Book p 1517 fiction
3249 3249 9732670 2664914 2018-01-23 2018-07-31   50 viint 0 0           0 0 1585661228 Web Document v 0 949.7103 u581 za 2003
3419 3419 9724275 2579987 2018-01-17 2018-07-31   50 viint 0 0           0 0 9780160842948 Web Document v 0 956.7044342 u58 za 2009
3432 3432 8444393 3090273 2015-09-04 2018-07-30   50 vidow 0 0           0 0 9781449469641 Downloadable Book v 0 ebook
3532 3532 8444523 3090402 2015-09-04 2018-07-30   50 vidow 0 0           0 0 9781613749845 Downloadable Book v 0 ebook
3568 3568 8444792 3090666 2015-09-04 2018-07-30   50 vidow 0 0           0 0 9781504015738 Downloadable Book v 0 ebook
3624 3624 8444726 3090600 2015-09-04 2018-07-30   50 vidow 0 0           0 0 9781504017213 Downloadable Book v 0 ebook
4095 4095 8042340 3014851 2014-12-03 2018-07-30   50 vidow 0 0           0 0   Downloadable Book v 0 917.7199 d5
4408 4408 10418006 3459878 2019-06-12 2019-06-12   50 vidow 0 0           0 0 9781492656005 Downloadable Book v 0 ebook
4416 4416 10417981 3459853 2019-06-12 2019-06-12   50 vidow 0 0           0 0 9781641970945 Downloadable Book v 0 ebook
4418 4418 10418022 3459894 2019-06-12 2019-06-12   50 vidow 0 0           0 0 9780062349071 Downloadable Book v 0 ebook
4437 4437 10418070 3459942 2019-06-12 2019-06-12   50 vidow 0 0           0 0 9781615195749 Downloadable Book v 0 ebook
4459 4459 10418023 3459895 2019-06-12 2019-06-12   50 vidow 0 0           0 0 9780062412928 Downloadable Book v 0 ebook
4497 4497 10418060 3459932 2019-06-12 2019-06-12   50 vidow 0 0           0 0 9780062412744 Downloadable Book v 0 ebook
5974 5974 10066547 3388346 2018-10-01 2018-10-01   50 vidow 0 0           0 0   Downloadable Music v 0 emusic
5992 5992 10066566 3388365 2018-10-01 2018-10-01   50 vidow 0 0           0 0   Downloadable Music v 0 emusic
6230 6230 7663171 2960674 2014-04-08 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal
6630 6630 9244023 3245653 2017-02-09 2018-07-30   50 vidow 0 0           0 0 9780385353557 Downloadable Book v 0 ebook
7018 7018 9244742 3245896 2017-02-09 2018-07-30   50 vidow 0 0           0 0 9781504043038 Downloadable Book v 0 ebook
7110 7110 8444593 3090469 2015-09-04 2018-07-30   50 vidow 0 0           0 0 9781504016520 Downloadable Book v 0 ebook
7111 7111 8444642 3090518 2015-09-04 2018-07-30   50 vidow 0 0           0 0 9781504012157 Downloadable Book v 0 ebook
7112 7112 8444709 3090583 2015-09-04 2018-07-30   50 vidow 0 0           0 0 9781504011563 Downloadable Book v 0 ebook
7250 7250 1533147 2725507 2012-06-26 2018-07-31   50 viint 0 0           0 0   Web Document v 0 oad 1.2:em5542004
7269 7269 1534770 2728029 2012-06-26 2018-07-31   50 viint 0 0           0 0   Web Document v 0 od 674.2:c8552006
7270 7270 1534786 2728052 2012-06-26 2018-07-31   50 viint 0 0           0 0   Web Document v 0 od 674.2:h76522005
7277 7277 7670977 2584817 2014-04-11 2018-07-31   50 viint 0 0           0 0   E-Magazine v 0 ezine
7290 7290 1537523 2731766 2012-06-26 2018-07-31   50 viint 0 0           0 0   Web Document v 0 ojb 1.2:un
7551 7551 1557691 2767416 2012-06-26 2018-07-31   50 viint 0 0           0 0   Web Document v 0 ohf 1.2:f6972009span
7560 7560 1558132 2767892 2012-06-26 2018-07-31   50 viint 0 0           0 0   Web Document v 0 onr 84.83:122001
8275 8275 8277405 3046251 2015-05-19 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal
8296 8296 8277320 3046166 2015-05-19 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal
8302 8302 10417941 3459813 2019-06-12 2019-06-12   50 vidow 0 0           0 0 9780062407818 Downloadable Book v 0 ebook
8334 8334 7684692 2964560 2014-04-22 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal
8347 8347 7684690 2964558 2014-04-22 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal
8348 8348 7684793 2964661 2014-04-22 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal
8364 8364 7685323 2965102 2014-04-22 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal
8370 8370 10417733 3459605 2019-06-12 2019-06-12   50 vidow 0 0           0 0 9780062357151 Downloadable Book v 0 ebook
8374 8374 10417782 3459654 2019-06-12 2019-06-12   50 vidow 0 0           0 0 9781459293298 Downloadable Book v 0 ebook
8383 8383 10417765 3459637 2019-06-12 2019-06-12   50 vidow 0 0           0 0 9781625674333 Downloadable Book v 0 ebook
8413 8413 10417903 3459775 2019-06-12 2019-06-12   50 vidow 0 0           0 0 9781788685368 Downloadable Book v 0 ebook
8416 8416 10417889 3459761 2019-06-12 2019-06-12   50 vidow 0 0           0 0 9781435166714 Downloadable Book v 0 ebook
8582 8582 1634056 2677994 2012-06-26 2018-07-31   50 viint 0 0           0 0   Web Document v 0  
9760 9760 8541818 3110880 2015-11-04 2018-07-30   50 vidow 0 0           0 0   Downloadable Book v 0 372.412 n285 1885
9897 9897 8546931 3111458 2015-11-06 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal
9918 9918 8548432 3111726 2015-11-09 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal
9922 9922 8548446 3111740 2015-11-09 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal
9930 9930 8548616 3111908 2015-11-09 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal
9931 9931 8548618 3111910 2015-11-09 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal
9937 9937 8548777 3112069 2015-11-09 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal
9947 9947 8549420 3112711 2015-11-09 2018-07-31   50 viint 0 0           0 0   Web Document v 0 electronic journal

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 174.844ms · Data source: https://ilsweb.cincinnatilibrary.org/collection-analysis-docs/