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

2,976 rows

View and edit SQL

Link rowid ▼ id code branch_code_num parent_location_code is_public is_requestable
1 884 fotab 14   0 1
2 81 y0604 1   0 1
3 1683 nsjdn 29   0 1
4 27 avjpl 3   0 1
5 616 crzzz 9   0 1
6 436 chjdn 6   0 1
7 1252 majeb 21   0 1
8 1162 lvaab 20   0 1
9 75 y0603 1   0 1
10 1253 majec 21   0 1
11 32 1fabc 1   0 1
12 34 osjnf 32   0 1
13 672 cvzzz 10   0 1
14 1251 majdn 21   0 1
15 1557 mwanf 27   0 1
16 1702 nszzz 29   0 1
17 331 bajgn 4   0 1
18 74 au3bg 1   0 1
19 1661 nsadt 29   0 1
20 1556 mwamg 27   0 1
21 1944 przzz 34   0 1
22 1685 nsjec 29   0 1
23 1684 nsjeb 29   0 1
24 1660 nsadn 29   0 1
25 943 getmg 15   0 1
26 2388 1 1   0 1
27 1249 majcz 21   0 1
28 1248 majcy 21   0 1
29 403 chaab 6   0 1
30 36 ostnf 32   0 1
31 305 baafl 4   0 1
32 434 chjcz 6   0 1
33 2050 sbzzz 36   0 1
34 1119 hpafl 19   0 1
35 1686 nsjer 29   0 1
36 1992 ret 35   1 1
37 1116 hpadn 19   0 1
38 2469 smtoo 38   0 1
39 430 chjbd 6   0 1
40 1915 prase 34   0 1
41 431 chjbg 6   0 1
42 989 ghjv 16   0 1
43 1117 hpadt 19   0 1
44 432 chjbi 6   0 1
45 988 ghjr 16   0 1
46 2157 smtmg 38   0 1
47 404 chaar 6   0 1
48 1659 nsadf 29   0 1
49 1658 nsadc 29   0 1
50 1657 nsada 29   0 1
51 1655 nsacy 29   0 1
52 120 2ttgn 1   0 1
53 1688 nsjgn 29   0 1
54 1246 majbi 21   0 1
55 1914 prard 34   0 1
56 1245 majbg 21   0 1
57 303 baadt 4   0 1
58 429 chjab 6   0 1
59 1244 majbd 21   0 1
60 949 ghaab 16   0 1
61 1946 rea 35   1 1
62 1110 hpacy 19   0 1
63 301 baadf 4   0 1
64 1111 hpacz 19   0 1
65 1098 hatab 18   0 1
66 300 baadc 4   0 1
67 1972 rej 35   1 1
68 1113 hpada 19   0 1
69 950 ghaar 16   0 1
70 982 ghjf 16   0 1
71 302 baadn 4   0 1
72 1114 hpadc 19   0 1
73 1115 hpadf 19   0 1
74 722 dptgn 11   0 1
75 977 ghjd 16   0 1
76 975 ghjc 16   0 1
77 1255 majf 21   0 1
78 1537 mttpl 26   0 1
79 118 2ttfh 1   0 1
80 972 ghjab 16   0 1
81 119 2ttfs 1   0 1
82 1261 majr 21   0 1
83 1653 nsaar 29   0 1
84 864 fojab 14   0 1
85 945 getpl 15   0 1
86 1171 lvadn 20   0 1
87 1409 mnjd 24   0 1
88 1407 mnjc 24   0 1
89 1247 majc 21   0 1
90 1414 mnjf 24   0 1
91 1172 lvadt 20   0 1
92 1250 majd 21   0 1
93 973 ghjbd 16   0 1
94 1170 lvadf 20   0 1
95 1676 nsjab 29   0 1
96 2158 smtnf 38   0 1
97 1108 hpaar 19   0 1
98 2446 mttoo 26   0 1
99 1420 mnjr 24   0 1
100 1168 lvada 20   0 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE location (
	id INTEGER, 
	code INTEGER, 
	branch_code_num INTEGER, 
	parent_location_code INTEGER, 
	is_public BOOLEAN, 
	is_requestable BOOLEAN, 
	CHECK (is_public IN (0, 1)), 
	CHECK (is_requestable IN (0, 1))
);
CREATE INDEX fk9ff58fb55804fddb ON location (branch_code_num);
CREATE UNIQUE INDEX location_code_key ON location (code);
CREATE UNIQUE INDEX pk_location ON location (id);