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

872,906 rows

View and edit SQL

Link rowid ▼ id volume_record_id volume_record_num item_record_id item_record_num items_display_order volume_statement
1 1767526 455268049177 1515801 450982646391 11080311 13 NO. 320 Mar/Apr 2021
2 1291701 455267993735 1460359 450980450028 8883948   v.01
3 1682866 455268041893 1508517 450982294494 10728414   v.01
4 1782435 455268047942 1514566 450982732174 11166094 21 V. 75 NO. 6 Jun 2021
5 1769651 455268050902 1517526 450982627310 11061230   v.01
6 1766111 455268047638 1514262 450982639414 11073334   v.02
7 663549 455267900655 1367279 450977794066 6227986   v.03
8 1798947 455268053568 1520192 450982850021 11283941 40 V. 240 NO. 2 Aug 2021
9 1570323 455268025178 1491802 450981725705 10159625   v.01
10 1777795 455268048943 1515567 450982710466 11144386 1 V. 80 NO. 7 May 2021
11 675535 455267901883 1368507 450978027982 6461902   v.06
12 1541279 455268022136 1488760 450981581871 10015791   v.05
13 1778625 455267960645 1427269 450982715153 11149073   v.02
14 1203115 455267982375 1448999 450980044875 8478795   v.03
15 1113863 455267970872 1437496 450979650901 8084821   v.01
16 1780512 455268047994 1514618 450982722547 11156467 13 NO. 314 May 2021
17 1788745 455268048760 1515384 450982766352 11200272 7 NO. 170 Jun/Jul 2021
18 1810437 455268053458 1520082 450982936224 11370144 20 V. 76 NO. 10 Oct 2021
19 1780001 455268048635 1515259 450982719838 11153758 0 V. 80 NO. 3 May/Jun 2021
20 1476425 455268015499 1482123 450981270635 9704555   v.02
21 1207008 455267983978 1450602 450980058519 8492439   v.01
22 1795632 455268053150 1519774 450982800091 11234011   Jul 11, 2021
23 1773473 455268048578 1515202 450982680688 11114608 24 V. 8 NO. 4 Apr/May 2021
24 1759432 455268049113 1515737 450982603300 11037220 29 V. 29 NO. 1 Feb/Mar 2021
25 1777636 455268050571 1517195 450982708950 11142870 82 V. 45 NO. 17 Apr 26, 2021
26 1198888 455267981451 1448075 450980027706 8461626   v.02
27 1784437 455268048173 1514797 450982740965 11174885   V. 96 NO. 4 Apr 2021
28 490191 455267876853 1343477 450976328876 4762796   75 v.02
29 1824121 455268052585 1519209 450983033338 11467258 27 V. 270 NO. 9 Dec 2021/Jan 2022
30 681262 455267832516 1299140 450978126320 6560240   v.01
31 1764793 455268047245 1513869 450982628933 11062853 3 V. 78 NO. 3 Mar 2021
32 1807660 455268052507 1519131 450982922847 11356767 49 V. 20 NO. 33 Aug 16, 2021
33 1802108 455268051423 1518047 450982893155 11327075 4 V. 6 NO. 3 Fal 2021
34 1727955 455268045274 1511898 450982455905 10889825   v.03
35 1476428 455268015500 1482124 450981270638 9704558   v.03
36 1616040 455267584932 1051556 450981955126 10389046   v.02
37 1089077 455267965340 1431964 450979535635 7969555   v.01
38 1303455 455267995798 1462422 450980510281 8944201   v.03
39 710082 455267910725 1377349 450975180822 3614742   v.01
40 1749628 455268047876 1514500 450982559827 10993747   v.01
41 1804906 455268052062 1518686 450982908206 11342126 0 NO. 93 Sep/Oct 2021
42 713820 455267914475 1381099 450977284287 5718207   v.03
43 612616 455267585276 1051900 450976926328 5360248   v.04
44 1822706 455268042044 1508668 450983021618 11455538   v.01
45 659193 455267899999 1366623 450977695222 6129142   v.01
46 1766638 455268047159 1513783 450982643142 11077062 22 V. 163 NO. 1 Feb/Mar 2021
47 1794327 455268054228 1520852 450982794141 11228061   v.01
48 1375700 455268004840 1471464 450980812595 9246515   v.04
49 1778090 455268048203 1514827 450982712950 11146870 4 V. 24 NO. 3 May 2021
50 1779062 455268047247 1513871 450982716080 11150000 27 V. 78 NO. 5 May 2021
51 1780396 455268051293 1517917 450982722431 11156351 3 V. 21 NO. 1025 May 7, 2021
52 1741041 455268041760 1508384 450982515373 10949293 7 V. 28 NO. 1 Win 2021
53 1082377 455267964934 1431558 450979519135 7953055   v.03
54 1689661 455268039380 1506004 450982330898 10764818 11 V. 90 NO. 2 Mar 2020
55 1777189 455268050164 1516788 450982707714 11141634 3 V. 439 NO. 9241 Apr 17, 2021
56 1773508 455268047557 1514181 450982680707 11114627   V. 270 NO. 3 Apr 2021
57 1768000 455268048955 1515579 450982647147 11081067 2 V. 54 NO. 2 Mar/Apr 2021
58 1762142 455268049439 1516063 450982618774 11052694 3 NO. 4688 Feb 8, 2021
59 1511471 455268020860 1487484 450981442816 9876736   2018/19
60 1753504 455268047055 1513679 450982577514 11011434 18 V. 45 NO. 1 Jan 4, 2021
61 1771522 455268049529 1516153 450982672194 11106114 66 V. 20 NO. 11 Mar 15, 2021
62 781638 455267934122 1400746 450978514779 6948699 11 v.01
63 1623411 455268032970 1499594 450981986205 10420125   v.03
64 1784432 455268048696 1515320 450982740960 11174880 34 NO. 169 Mar/Apr 2021
65 1754958 455268048166 1514790 450982584880 11018800   v.01
66 1822502 455268057823 1524447 450982284481 10718401   v.01
67 1529191 455268020496 1487120 450981532854 9966774   v.01
68 1581131 455268024733 1491357 450981773100 10207020   NO. 117 Spr 2019
69 1657214 455268038980 1505604 450982140679 10574599   2020
70 1784455 455268048873 1515497 450982741061 11174981   V. 35 NO. 2 Mar/Apr 2021
71 1784454 455268048253 1514877 450982741050 11174970   V. 55 NO. 4 Apr 2021
72 1785846 455268047579 1514203 450982753360 11187280 12 V. 42 NO. 4 Jun 2021
73 1798002 455268052436 1519060 450982826060 11259980 13 NO. 4707 Jul 26, 2021
74 1784428 455268047210 1513834 450982740954 11174874   V. 31 NO. 2 Mar 2021
75 1785254 455268049315 1515939 450982749441 11183361 0 V. 5 NO. 2 Sum 2021
76 1776038 455268047160 1513784 450982696223 11130143 0 V. 163 NO. 2 Apr/May 2021
77 1436200 455268009829 1476453 450981095169 9529089   v.05
78 1808340 455268052970 1519594 450982924752 11358672 30 V. 41 NO. 1 Sep 2021
79 641296 455267897748 1364372 450977425515 5859435   v.02
80 1424105 455268010663 1477287 450981043503 9477423   v.09
81 1570326 455268025178 1491802 450981725708 10159628   v.01
82 1784440 455268048749 1515373 450982740989 11174909 28 V. 71 NO. 2 Apr 2021
83 1473826 455268017152 1483776 450981249251 9683171   v.06
84 1782238 455268051950 1518574 450982720827 11154747   v.05 2021
85 1779608 455268048266 1514890 450982717536 11151456 0 V. 197 NO. 1170 May 2021
86 1775840 455268050204 1516828 450982695422 11129342 74 V. 20 NO. 15 Apr 12, 2021
87 1491557 455268018639 1485263 450981344352 9778272   8th_ed. 2018
88 658330 455267899890 1366514 450977672774 6106694   v.02
89 1513599 455268020766 1487390 450981460959 9894879   v.01
90 1796308 455268053880 1520504 450982805716 11239636   V. 48 NO. 7 Jul 2021
91 642459 455267897838 1364462 450977442491 5876411   v.03
92 1786817 455268052814 1519438 450982753524 11187444   v.88
93 1810976 455268056286 1522910 450982939200 11373120   v.01
94 1552216 455268022256 1488880 450981626816 10060736   v.02
95 1796257 455268053248 1519872 450982805662 11239582 2 V. 27 NO. 24 Jul 13, 2021
96 1493168 455268018906 1485530 450981354500 9788420   v.03
97 1791194 455268051186 1517810 450982780084 11214004 107 V. 95 NO. 26 Jun 28, 2021
98 1784191 455268049115 1515739 450982739501 11173421 11 V. 29 NO. 3 Jun/Jul 2021
99 1137124 455267966673 1433297 450979751323 8185243   V. 234 NO. 4 Apr 2015
100 1784205 455268049115 1515739 450982739473 11173393 25 V. 29 NO. 3 Jun/Jul 2021

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE volume_record_item_record_link (
	id BIGINT, 
	volume_record_id BIGINT, 
	volume_record_num INTEGER, 
	item_record_id BIGINT, 
	item_record_num INTEGER, 
	items_display_order INTEGER, 
	volume_statement TEXT
);
CREATE INDEX idx_volume_record_item_record_link_volume_record_id ON volume_record_item_record_link (volume_record_id);
CREATE INDEX idx_volume_record_item_record_link_volume_record_num ON volume_record_item_record_link (volume_record_num);
CREATE UNIQUE INDEX pk_volume_record_item_record_link ON volume_record_item_record_link (id);
CREATE UNIQUE INDEX uc_volume_record_item_record_link ON volume_record_item_record_link (item_record_id);
CREATE INDEX volume_record_item_record_link_item_id_volume_id ON volume_record_item_record_link (item_record_id, volume_record_id);
CREATE INDEX volume_record_item_record_link_item_num_volume_num ON volume_record_item_record_link (item_record_num, volume_record_num);