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

2,097,738 rows

View and edit SQL

Link rowid ▼ id record_id language_code bcode1 bcode2 bcode3 country_code index_change_count is_on_course_reserve is_right_result_exact allocation_rule_code skip_num cataloging_date_gmt marc_type_code is_suppressed
1 420907795009 420907795009 eng m a - cau 46 0 0 0 0 1992-05-11 00:00:00.000000 0
2 420907795010 420907795010 eng m a - ohu 5 0 0   0 1992-03-22 00:00:00.000000 0
3 420907795011 420907795011 eng s a - nyu 71 0 0 0 4 1992-03-22 00:00:00.000000 0
4 420907795012 420907795012 eng m a - nyu 6 0 0   4 1989-03-31 00:00:00.000000 0
5 420907795013 420907795013 eng m a - pau 5 0 0   0 1995-05-03 00:00:00.000000 0
6 420907795014 420907795014 eng m a -   5 0 0   0 1992-03-22 00:00:00.000000 0
7 420907795015 420907795015 eng m a - mau 6 0 0   4 1994-10-05 00:00:00.000000 0
8 420907795016 420907795016 eng m a -   4 0 0   0 1992-03-22 00:00:00.000000 0
9 420907795017 420907795017 eng m a - mau 9 0 0   0 1995-09-07 00:00:00.000000 0
10 420907795018 420907795018 eng m a - nyu 4 0 0   0 1992-03-22 00:00:00.000000 0
11 420907795019 420907795019 ger m a - pl 6 0 0   0 1992-03-22 00:00:00.000000 0
12 420907795020 420907795020 eng m a - ilu 5 0 0   0 1995-10-06 00:00:00.000000 0
13 420907795021 420907795021 eng m a - nju 21 0 0   0 2003-12-16 00:00:00.000000 0
14 420907795022 420907795022 eng m a - nyu 5 0 0   4 1989-04-07 00:00:00.000000 0
15 420907795023 420907795023 eng m a - nyu 4 0 0   0 1992-03-22 00:00:00.000000 0
16 420907795024 420907795024 eng m a - nyu 4 0 0   4 1989-03-28 00:00:00.000000 0
17 420907795025 420907795025 eng m a - mau 21 0 0 0 0 1992-03-22 00:00:00.000000 0
18 420907795026 420907795026 eng m a - nyu 5 0 0   4 1992-03-22 00:00:00.000000 0
19 420907795027 420907795027 eng m a -   4 0 0   4 1989-04-07 00:00:00.000000 0
20 420907795028 420907795028 eng m a - nyu 6 0 0   4 1992-03-22 00:00:00.000000 0
21 420907795029 420907795029 eng m a -   4 0 0   0 1992-03-22 00:00:00.000000 0
22 420907795030 420907795030 eng m a - nyu 6 0 0   0 1995-08-17 00:00:00.000000 0
23 420907795031 420907795031 eng m a - nyu 5 0 0   4 1995-08-16 00:00:00.000000 0
24 420907795032 420907795032 eng m a - mau 7 0 0   2 1995-09-06 00:00:00.000000 0
25 420907795033 420907795033 eng m a - nyu 5 0 0   3 1992-03-22 00:00:00.000000 0
26 420907795034 420907795034 eng m a - nyu 9 0 0 0 0 1992-03-22 00:00:00.000000 0
27 420907795035 420907795035 eng m a - mau 7 0 0   4 1997-12-08 00:00:00.000000 0
28 420907795036 420907795036 eng m a - nyu 11 0 0   0 1992-03-22 00:00:00.000000 0
29 420907795037 420907795037 eng m a - mau 4 0 0   4 1995-08-10 00:00:00.000000 0
30 420907795038 420907795038 eng m a - nyu 6 0 0   0 1995-07-31 00:00:00.000000 0
31 420907795039 420907795039 eng m a - alu 7 0 0   0 1995-08-11 00:00:00.000000 0
32 420907795040 420907795040 eng m a - mau 12 0 0   4 1992-03-22 00:00:00.000000 0
33 420907795041 420907795041 eng m a - enk 5 0 0   4 1995-08-14 00:00:00.000000 0
34 420907795042 420907795042 eng m a - mau 15 0 0 0 4 1995-08-17 00:00:00.000000 0
35 420907795043 420907795043 eng m a - pau 4 0 0   0 1995-08-11 00:00:00.000000 0
36 420907795044 420907795044 eng m a - xx 5 0 0   4 1989-03-28 00:00:00.000000 0
37 420907795045 420907795045 eng m a - nyu 6 0 0   0 1995-08-14 00:00:00.000000 0
38 420907795046 420907795046 eng m a - nyu 5 0 0   4 1992-03-22 00:00:00.000000 0
39 420907795047 420907795047 eng m a - wiu 8 0 0   4 1995-08-10 00:00:00.000000 0
40 420907795048 420907795048 eng m a -   5 0 0   4 1992-03-22 00:00:00.000000 0
41 420907795049 420907795049 eng m a -   5 0 0   0 1992-03-22 00:00:00.000000 0
42 420907795051 420907795051 eng m a - dcu 5 0 0   0 1995-08-11 00:00:00.000000 0
43 420907795052 420907795052 eng m a -   4 0 0   2 1989-04-07 00:00:00.000000 0
44 420907795053 420907795053 eng m a - nyu 6 0 0   2 1995-08-10 00:00:00.000000 0
45 420907795054 420907795054 eng m a - xx 6 0 0   0 1992-03-22 00:00:00.000000 0
46 420907795055 420907795055 eng m a -   6 0 0   0 1992-03-22 00:00:00.000000 0
47 420907795056 420907795056 eng m a - enk 6 0 0   0 1995-08-10 00:00:00.000000 0
48 420907795057 420907795057 ger m a - gw 5 0 0   4 1992-03-22 00:00:00.000000 0
49 420907795058 420907795058 eng m a -   5 0 0   4 1989-04-12 00:00:00.000000 0
50 420907795059 420907795059 eng m a - enk 110 0 0   0 1992-03-22 00:00:00.000000 0
51 420907795060 420907795060 eng m a - utu 12 0 0   0 1992-03-22 00:00:00.000000 0
52 420907795061 420907795061 eng m a - nyu 7 0 0   0 1995-08-01 00:00:00.000000 0
53 420907795062 420907795062 eng m a - nyu 6 0 0   2 1995-07-21 00:00:00.000000 0
54 420907795063 420907795063 eng m a - nyu 6 0 0   4 1992-03-22 00:00:00.000000 0
55 420907795064 420907795064 eng m a - enk 6 0 0   4 1992-03-22 00:00:00.000000 0
56 420907795065 420907795065 eng m a - nyu 4 0 0   0 1992-03-22 00:00:00.000000 0
57 420907795066 420907795066 eng m a - miu 6 0 0   0 1995-08-11 00:00:00.000000 0
58 420907795067 420907795067 eng m a -   5 0 0   4 1989-04-11 00:00:00.000000 0
59 420907795068 420907795068 eng m a - stk 5 0 0   0 1995-05-16 00:00:00.000000 0
60 420907795069 420907795069 eng m a - nyu 4 0 0   0 1995-08-11 00:00:00.000000 0
61 420907795070 420907795070 eng m a - pau 4 0 0   0 1996-09-05 00:00:00.000000 0
62 420907795071 420907795071 eng m a - ohu 6 0 0   0 1995-08-11 00:00:00.000000 0
63 420907795072 420907795072 eng m a - ohu 7 0 0   0 1992-03-22 00:00:00.000000 0
64 420907795073 420907795073 eng s a - nju 332 0 0 0 0 1992-03-22 00:00:00.000000 0
65 420907795074 420907795074 eng m a - nyu 5 0 0   2 1992-03-22 00:00:00.000000 0
66 420907795075 420907795075 eng m a -   6 0 0   0 1992-03-22 00:00:00.000000 0
67 420907795076 420907795076 eng m a - enk 12 0 0   4 1989-04-05 00:00:00.000000 0
68 420907795077 420907795077 eng m a - nyu 5 0 0   0 1992-03-22 00:00:00.000000 0
69 420907795078 420907795078 eng m a - pau 5 0 0   2 1995-08-14 00:00:00.000000 0
70 420907795079 420907795079 eng m a -   8 0 0   0 1992-03-22 00:00:00.000000 0
71 420907795080 420907795080 eng m a - pau 5 0 0   0 1991-04-24 00:00:00.000000 0
72 420907795081 420907795081 eng m a - nyu 4 0 0   0 1992-03-22 00:00:00.000000 0
73 420907795082 420907795082 eng m a - ilu 13 0 0   4 1989-03-31 00:00:00.000000 0
74 420907795083 420907795083 eng m a - nyu 10 0 0 0 0 1992-03-22 00:00:00.000000 0
75 420907795084 420907795084 eng m a - nyu 9 0 0   2 1989-03-16 00:00:00.000000 0
76 420907795085 420907795085 eng m a - mau 6 0 0   0 1995-08-11 00:00:00.000000 0
77 420907795086 420907795086 eng m a - nyu 7 0 0   2 1996-05-22 00:00:00.000000 0
78 420907795087 420907795087 eng m a -   8 0 0   0 1992-03-22 00:00:00.000000 0
79 420907795088 420907795088 eng m a - nyu 6 0 0   0 1995-08-11 00:00:00.000000 0
80 420907795089 420907795089 eng m a -   10 0 0   0 1992-03-22 00:00:00.000000 0
81 420907795090 420907795090 eng m a - nyu 17 0 0 0 0 1997-11-17 00:00:00.000000 0
82 420907795091 420907795091 eng m a - mau 8 0 0 a 0 1995-08-11 00:00:00.000000 0
83 420907795092 420907795092 eng m a - ilu 60 0 0   0 1992-03-22 00:00:00.000000 0
84 420907795093 420907795093 eng m a - mau 6 0 0   0 1995-08-11 00:00:00.000000 0
85 420907795094 420907795094 eng m a - ctu 7 0 0   4 1989-04-05 00:00:00.000000 0
86 420907795095 420907795095 eng m a - ctu 5 0 0   0 1995-08-11 00:00:00.000000 0
87 420907795096 420907795096 eng m a - nyu 6 0 0   4 1989-04-12 00:00:00.000000 0
88 420907795097 420907795097 eng m a -   12 0 0   4 1989-04-27 00:00:00.000000 0
89 420907795098 420907795098 eng m a - mau 5 0 0   0 1995-03-28 00:00:00.000000 0
90 420907795100 420907795100 eng m a - mau 4 0 0   0 1992-03-22 00:00:00.000000 0
91 420907795101 420907795101 eng m a - xx 11 0 0   2 1989-04-12 00:00:00.000000 0
92 420907795102 420907795102 eng m a - ja 10 0 0   3 1989-04-28 00:00:00.000000 0
93 420907795103 420907795103 eng m a -   6 0 0   0 1992-03-22 00:00:00.000000 0
94 420907795104 420907795104 eng m a - pau 54 0 0 a 0 1990-06-04 00:00:00.000000 0
95 420907795105 420907795105 eng m a - ctu 12 0 0   4 1992-03-22 00:00:00.000000 0
96 420907795106 420907795106 eng m a - nyu 5 0 0   4 1991-04-23 00:00:00.000000 0
97 420907795107 420907795107 eng m a - nyu 17 0 0 a 4 1992-03-22 00:00:00.000000 0
98 420907795108 420907795108 eng m a - xx 4 0 0   4 1992-03-22 00:00:00.000000 0
99 420907795109 420907795109 eng m a -   4 0 0   0 1992-03-22 00:00:00.000000 0
100 420907795110 420907795110 eng m a - nyu 21 0 0   4 1989-04-27 00:00:00.000000 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE bib_record (
	id INTEGER, 
	record_id INTEGER, 
	language_code TEXT, 
	bcode1 TEXT, 
	bcode2 TEXT, 
	bcode3 TEXT, 
	country_code TEXT, 
	index_change_count INTEGER, 
	is_on_course_reserve BOOLEAN, 
	is_right_result_exact BOOLEAN, 
	allocation_rule_code TEXT, 
	skip_num INTEGER, 
	cataloging_date_gmt DATETIME, 
	marc_type_code TEXT, 
	is_suppressed BOOLEAN
);
CREATE INDEX bib_record_bcode3_idx ON bib_record (bcode3);
CREATE INDEX bib_record_bib_level_idx ON bib_record (bcode1);
CREATE INDEX bib_record_country_idx ON bib_record (country_code);
CREATE INDEX bib_record_lang_idx ON bib_record (language_code);
CREATE INDEX bib_record_material_type_idx ON bib_record (bcode2);
CREATE UNIQUE INDEX bib_record_record_key ON bib_record (record_id);
CREATE INDEX idx_bib_record_cataloging_date ON bib_record (cataloging_date_gmt);
CREATE UNIQUE INDEX pk_bib_record ON bib_record (id);