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

13,705,875 rows

View and edit SQL

Link rowid ▼ id record_type_code record_num creation_date_gmt deletion_date_gmt campus_code agency_code_num record_last_updated_gmt
101 450981082642 i 9516562 2017-08-17     0 2018-01-01 00:39:29.337782
102 450976602057 i 5035977 2012-07-02     0 2021-08-19 10:16:18.960000
103 450982195943 i 10629863 2019-11-25     0 2019-11-25 13:00:58.000000
104 450982976804 i 11410724 2021-10-11     0 2021-10-11 09:19:40.000000
105 420908301199 b 1506191 2012-06-20     0 2016-12-26 21:31:07.000000
106 450974189635 i 2623555 2012-06-29     0 2013-01-06 10:51:33.000000
107 450974189655 i 2623575 2012-06-29     0 2015-02-14 11:25:39.000000
108 450974189637 i 2623557 2012-06-29     0 2013-01-06 10:51:33.000000
109 450981317804 i 9751724 2018-02-07     0 2021-11-10 10:38:02.658000
110 450974189646 i 2623566 2012-06-29     0 2019-04-26 14:32:40.000000
111 450979070320 i 7504240 2014-01-03     0 2021-09-10 16:42:19.000000
112 450975960035 i 4393955 2012-06-30     0 2013-01-08 13:41:16.000000
113 450976199107 i 4633027 2012-06-30     0 2013-03-11 16:23:39.000000
114 450972682705 i 1116625 2012-06-23     0 2013-01-04 18:53:05.000000
115 450974189645 i 2623565 2012-06-29     0 2013-01-06 10:51:33.000000
116 450974189656 i 2623576 2012-06-29     0 2013-01-06 10:51:35.000000
117 450975960213 i 4394133 2012-06-30     0 2013-01-08 13:41:33.000000
118 450975466828 i 3900748 2012-06-30     0 2019-01-01 00:39:14.451725
119 450974645995 i 3079915 2012-06-29     0 2018-01-01 00:21:33.771895
120 450976114003 i 4547923 2012-06-30     0 2015-09-02 13:52:58.000000
121 450975960244 i 4394164 2012-06-30     0 2013-01-08 13:41:36.000000
122 450974973180 i 3407100 2012-06-30     0 2014-09-05 11:09:39.000000
123 450973470253 i 1904173 2012-06-27     0 2021-04-08 13:26:35.000000
124 450982976805 i 11410725 2021-10-11     0 2021-10-11 09:19:40.000000
125 450972682710 i 1116630 2012-06-23     0 2013-01-04 18:53:05.000000
126 420908560637 b 1765629 2012-06-20     0 2012-06-30 15:12:33.000000
127 450972682711 i 1116631 2012-06-23     0 2013-01-04 18:53:05.000000
128 450982195944 i 10629864 2019-11-25     0 2019-11-25 13:00:58.000000
129 450972682712 i 1116632 2012-06-23     0 2013-01-04 18:53:05.000000
130 450972682713 i 1116633 2012-06-23     0 2013-01-04 18:53:05.000000
131 450972682716 i 1116636 2012-06-23     0 2013-01-04 18:53:05.000000
132 450974189638 i 2623558 2012-06-29     0 2013-01-06 10:51:33.000000
133 450975959813 i 4393733 2012-06-30     0 2013-01-08 13:40:54.000000
134 450977197202 i 5631122 2012-07-02     0 2013-01-10 07:23:04.000000
135 450972682719 i 1116639 2012-06-23     0 2013-01-04 18:53:06.000000
136 420908704937 b 1909929 2012-06-20     0 2019-11-07 14:29:06.000000
137 450972682720 i 1116640 2012-06-23     0 2013-01-04 18:53:06.000000
138 450974189849 i 2623769 2012-06-29     0 2013-01-06 10:51:52.000000
139 450972682721 i 1116641 2012-06-23     0 2013-01-04 18:53:06.000000
140 450980778081 i 9212001 2017-01-17     0 2021-01-01 17:53:11.698649
141 450976466970 i 4900890 2012-07-01     0 2018-01-01 00:27:32.339400
142 450979702229 i 8136149 2015-02-10     0 2018-07-30 10:04:20.000000
143 420910502919 b 3707911 2021-10-01     0 2021-11-21 22:37:43.000000
144 420907883974 b 1088966 2012-06-19     0 2016-10-25 14:40:57.000000
145 450973683938 i 2117858 2012-06-27     0 2017-01-01 00:52:09.593163
146 450975959839 i 4393759 2012-06-30     0 2021-01-04 13:38:39.992000
147 450974189686 i 2623606 2012-06-29     0 2019-09-03 10:24:36.000000
148 450972682717 i 1116637 2012-06-23     0 2013-01-04 18:53:06.000000
149 450974189643 i 2623563 2012-06-29     0 2013-01-06 10:51:33.000000
150 420908373602 b 1578594 2012-06-20     0 2013-09-22 15:20:46.000000
151 420907972127 b 1177119 2012-06-20     0 2015-08-11 21:28:07.000000
152 450972682723 i 1116643 2012-06-23     0 2013-01-04 18:53:06.000000
153 450974189644 i 2623564 2012-06-29     0 2013-01-06 10:51:33.000000
154 450982208333 i 10642253 2019-12-03     0 2021-11-18 15:30:58.000000
155 450975959953 i 4393873 2012-06-30     0 2013-01-08 13:41:07.000000
156 450975960056 i 4393976 2012-06-30     0 2013-01-08 13:41:17.000000
157 450975960079 i 4393999 2012-06-30     0 2013-01-08 13:41:19.000000
158 450978144089 i 6578009 2012-07-03     0 2013-01-11 11:34:14.000000
159 450978144152 i 6578072 2012-07-03     0 2013-01-11 11:34:24.000000
160 450978865607 i 7299527 2013-09-09     0 2021-03-25 08:41:55.000000
161 450973925745 i 2359665 2012-06-28     0 2021-05-05 07:46:25.000000
162 450975950685 i 4384605 2012-06-30     0 2021-05-05 14:58:06.000000
163 450982976806 i 11410726 2021-10-11     0 2021-10-11 09:19:40.000000
164 450974703073 i 3136993 2012-06-29     0 2020-01-07 13:41:29.354592
165 450974189650 i 2623570 2012-06-29     0 2013-01-06 10:51:34.000000
166 450978150010 i 6583930 2012-07-03     0 2021-03-25 12:19:44.000000
167 450974189651 i 2623571 2012-06-29     0 2013-01-06 10:51:34.000000
168 450979605662 i 8039582 2014-12-01     0 2021-08-26 09:38:43.841000
169 450972682724 i 1116644 2012-06-23     0 2013-01-04 18:53:06.000000
170 450975749216 i 4183136 2012-06-30     0 2014-12-30 16:35:04.000000
171 450972682725 i 1116645 2012-06-23     0 2013-01-04 18:53:06.000000
172 420908252676 b 1457668 2012-06-20     0 2017-09-29 14:52:10.000000
173 450972682726 i 1116646 2012-06-23     0 2013-01-04 18:53:06.000000
174 450974189652 i 2623572 2012-06-29     0 2013-01-06 10:51:34.000000
175 450972682727 i 1116647 2012-06-23     0 2013-01-04 18:53:06.000000
176 450972682728 i 1116648 2012-06-23     0 2013-01-04 18:53:06.000000
177 450972682730 i 1116650 2012-06-23     0 2013-01-04 18:53:07.000000
178 450972682731 i 1116651 2012-06-23     0 2013-01-04 18:53:07.000000
179 450972682733 i 1116653 2012-06-23     0 2013-01-04 18:53:07.000000
180 450972682734 i 1116654 2012-06-23     0 2013-01-04 18:53:07.000000
181 450972682735 i 1116655 2012-06-23     0 2013-01-04 18:53:07.000000
182 450973524665 i 1958585 2012-06-27     0 2013-01-05 17:29:31.000000
183 420907867817 b 1072809 2012-06-19     0 2021-11-17 10:40:04.000000
184 450975959754 i 4393674 2012-06-30     0 2019-01-01 00:39:46.748747
185 450978150063 i 6583983 2012-07-03     0 2013-01-11 11:44:47.000000
186 450979939492 i 8373412 2015-07-24     0 2020-12-15 08:57:07.000000
187 450982288351 i 10722271 2020-01-28     0 2021-05-12 07:28:17.000000
188 450981305163 i 9739083 2018-01-30     0 2021-02-24 08:30:15.000000
189 450982925737 i 11359657 2021-09-14     0 2021-09-22 11:41:26.000000
190 450980009025 i 8442945 2015-09-03     0 2018-01-01 00:35:35.478158
191 420910504283 b 3709275 2021-10-11     0 2021-10-11 09:19:40.000000
192 450975960558 i 4394478 2012-06-30     0 2013-01-08 13:42:06.000000
193 450982976817 i 11410737 2021-10-11     0 2021-10-11 09:19:41.000000
194 450974288813 i 2722733 2012-06-29     0 2013-06-03 18:36:18.000000
195 450972682786 i 1116706 2012-06-23     0 2013-02-26 16:48:01.000000
196 450976088014 i 4521934 2012-06-30     0 2017-01-01 01:00:54.226526
197 450972682732 i 1116652 2012-06-23     0 2013-01-04 18:53:07.000000
198 450973266375 i 1700295 2012-06-26     0 2020-01-07 13:41:21.185718
199 450972682765 i 1116685 2012-06-23     0 2013-01-04 18:53:09.000000
200 450973771068 i 2204988 2012-06-28     0 2013-01-05 23:27:16.000000

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE record_metadata (
	id BIGINT, 
	record_type_code TEXT, 
	record_num BIGINT, 
	creation_date_gmt DATE, 
	deletion_date_gmt TEXT, 
	campus_code TEXT, 
	agency_code_num BIGINT, 
	record_last_updated_gmt DATETIME
);
CREATE INDEX idx_record_metadata_id_record_last_updated ON record_metadata (id, record_last_updated_gmt);
CREATE INDEX idx_record_metadata_record_creation_date_gmt ON record_metadata (creation_date_gmt);
CREATE INDEX idx_record_metadata_record_num ON record_metadata (record_num);
CREATE INDEX pk_record_id ON record_metadata (id);
CREATE INDEX record_id_unique_constraint ON record_metadata (record_type_code, record_num, campus_code);
CREATE INDEX record_metadata_last_modified ON record_metadata (record_last_updated_gmt, record_type_code, id);