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

13,710,736 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 450982863781 i 11297701 2021-08-03     0 2021-08-03 11:20:02.000000
102 420910457847 b 3662839 2021-08-03     0 2021-08-03 11:20:03.000000
103 420910457849 b 3662841 2021-08-03     0 2021-08-03 11:20:03.000000
104 420910457862 b 3662854 2021-08-03     0 2021-08-03 11:20:03.000000
105 420910457870 b 3662862 2021-08-03     0 2021-08-03 11:20:04.000000
106 450982863829 i 11297749 2021-08-03     0 2021-08-03 11:20:04.000000
107 420910457882 b 3662874 2021-08-03     0 2021-08-03 11:20:04.000000
108 420910457929 b 3662921 2021-08-03     0 2021-08-03 11:20:06.000000
109 450982863884 i 11297804 2021-08-03     0 2021-08-03 11:20:06.000000
110 450982863885 i 11297805 2021-08-03     0 2021-08-03 11:20:06.000000
111 420910457954 b 3662946 2021-08-03     0 2021-08-03 11:20:07.000000
112 420910457957 b 3662949 2021-08-03     0 2021-08-03 11:20:07.000000
113 450982863928 i 11297848 2021-08-03     0 2021-08-03 11:20:09.000000
114 450982863941 i 11297861 2021-08-03     0 2021-08-03 11:20:09.000000
115 420910457993 b 3662985 2021-08-03     0 2021-08-03 11:20:09.000000
116 420910457997 b 3662989 2021-08-03     0 2021-08-03 11:20:09.000000
117 450980780067 i 9213987 2017-01-18     0 2021-09-04 17:18:39.000000
118 450982816984 i 11250904 2021-07-20     0 2021-11-20 14:13:07.927000
119 450972649426 i 1083346 2012-06-23     0 2021-10-04 09:45:17.000000
120 420909760462 b 2965454 2014-04-24     0 2021-08-21 17:00:17.000000
121 450981529344 i 9963264 2018-07-11     0 2021-08-04 17:25:48.897000
122 450974384133 i 2818053 2012-06-29     0 2021-10-04 11:13:58.000000
123 420909565921 b 2770913 2012-06-21     0 2021-10-27 21:16:54.000000
124 450979634580 i 8068500 2014-12-19     0 2021-10-25 16:56:44.103000
125 450982989990 i 11423910 2021-10-20     0 2021-10-29 10:47:36.000000
126 450981044127 i 9478047 2017-07-17     0 2021-08-05 11:10:41.000000
127 450980801183 i 9235103 2017-02-03     0 2021-08-25 23:51:18.000000
128 450982465357 i 10899277 2020-09-16     0 2021-11-17 16:26:08.121000
129 420909291983 b 2496975 2012-06-21     0 2021-11-22 15:17:33.000000
130 450982098797 i 10532717 2019-09-16     0 2021-11-22 17:21:13.896000
131 450981389463 i 9823383 2018-03-27     0 2021-11-23 19:13:13.456000
132 450981902285 i 10336205 2019-04-05     0 2021-11-01 13:15:44.000000
133 420909535992 b 2740984 2012-06-21     0 2021-05-15 21:11:15.000000
134 450982008016 i 10441936 2019-06-28     0 2021-07-27 09:02:05.000000
135 450981557294 i 9991214 2018-08-06     0 2021-08-12 09:47:45.000000
136 450982863683 i 11297603 2021-08-03     0 2021-08-03 11:19:57.000000
137 450982863684 i 11297604 2021-08-03     0 2021-08-03 11:19:57.000000
138 420910457747 b 3662739 2021-08-03     0 2021-08-03 11:19:58.000000
139 450982863705 i 11297625 2021-08-03     0 2021-08-03 11:19:59.000000
140 450982863714 i 11297634 2021-08-03     0 2021-08-03 11:19:59.000000
141 420910457801 b 3662793 2021-08-03     0 2021-08-03 11:20:01.000000
142 450982863752 i 11297672 2021-08-03     0 2021-08-03 11:20:01.000000
143 420910457811 b 3662803 2021-08-03     0 2021-08-03 11:20:01.000000
144 420910457818 b 3662810 2021-08-03     0 2021-08-03 11:20:02.000000
145 420910457865 b 3662857 2021-08-03     0 2021-08-03 11:20:04.000000
146 420910457912 b 3662904 2021-08-03     0 2021-08-03 11:20:05.000000
147 450982863876 i 11297796 2021-08-03     0 2021-08-03 11:20:06.000000
148 420910458164 b 3663156 2021-08-03     0 2021-08-03 11:20:18.000000
149 450982864119 i 11298039 2021-08-03     0 2021-08-03 11:20:18.000000
150 420910458171 b 3663163 2021-08-03     0 2021-08-03 11:20:18.000000
151 420910458176 b 3663168 2021-08-03     0 2021-08-03 11:20:18.000000
152 450982864129 i 11298049 2021-08-03     0 2021-08-03 11:20:18.000000
153 450982864130 i 11298050 2021-08-03     0 2021-08-03 11:20:19.000000
154 420910458183 b 3663175 2021-08-03     0 2021-08-03 11:20:19.000000
155 420910458186 b 3663178 2021-08-03     0 2021-08-03 11:20:19.000000
156 420910458191 b 3663183 2021-08-03     0 2021-08-03 11:20:19.000000
157 450982864141 i 11298061 2021-08-03     0 2021-08-03 11:20:19.000000
158 420910458219 b 3663211 2021-08-03     0 2021-08-03 11:20:21.000000
159 450982864174 i 11298094 2021-08-03     0 2021-08-03 11:20:21.000000
160 420910458226 b 3663218 2021-08-03     0 2021-08-03 11:20:21.000000
161 450982864182 i 11298102 2021-08-03     0 2021-08-03 11:20:22.000000
162 420910458235 b 3663227 2021-08-03     0 2021-08-03 11:20:22.000000
163 450982864193 i 11298113 2021-08-03     0 2021-08-03 11:20:23.000000
164 450982864195 i 11298115 2021-08-03     0 2021-08-03 11:20:23.000000
165 420910458247 b 3663239 2021-08-03     0 2021-08-03 11:20:23.000000
166 420910458253 b 3663245 2021-08-03     0 2021-08-03 11:20:24.000000
167 450982864208 i 11298128 2021-08-03     0 2021-08-03 11:20:24.000000
168 420910458260 b 3663252 2021-08-03     0 2021-08-03 11:20:24.000000
169 420910458270 b 3663262 2021-08-03     0 2021-08-03 11:20:25.000000
170 420910458271 b 3663263 2021-08-03     0 2021-08-03 11:20:25.000000
171 450982864224 i 11298144 2021-08-03     0 2021-08-03 11:20:25.000000
172 420910458283 b 3663275 2021-08-03     0 2021-08-03 11:20:25.000000
173 450982806316 i 11240236 2021-07-16     0 2021-07-27 09:13:20.000000
174 450981617076 i 10050996 2018-09-20     0 2021-11-20 13:36:40.806000
175 420909514488 b 2719480 2012-06-21     0 2021-09-29 10:19:16.000000
176 450982473175 i 10907095 2020-09-23     0 2021-11-15 16:20:15.441000
177 450981953253 i 10387173 2019-05-15     0 2021-08-31 16:32:34.197000
178 420909297388 b 2502380 2012-06-21     0 2021-11-20 21:14:29.000000
179 420910457762 b 3662754 2021-08-03     0 2021-11-19 11:14:35.000000
180 450982806798 i 11240718 2021-07-19     0 2021-10-06 08:31:29.000000
181 450975193718 i 3627638 2012-06-30     0 2021-11-06 14:17:32.612000
182 450975314396 i 3748316 2012-06-30     0 2021-11-08 09:34:57.006000
183 450979498105 i 7932025 2014-10-01     0 2021-11-08 10:08:49.300000
184 450982768559 i 11202479 2021-06-10     0 2021-10-25 10:25:01.559000
185 420910401328 b 3606320 2021-04-16     0 2021-11-23 09:58:26.000000
186 450982790905 i 11224825 2021-07-01     0 2021-11-23 12:04:17.407000
187 450982922721 i 11356641 2021-09-13     0 2021-10-25 16:56:25.395000
188 450982799988 i 11233908 2021-07-12     0 2021-11-25 07:33:36.452000
189 450982803511 i 11237431 2021-07-14     0 2021-11-27 10:40:28.000000
190 420910175768 b 3380760 2018-08-21     0 2021-10-25 16:57:56.000000
191 450980373731 i 8807651 2016-04-13     0 2021-08-11 17:16:54.407000
192 450975144880 i 3578800 2012-06-30     0 2021-11-10 10:16:47.000000
193 450977754412 i 6188332 2012-07-03     0 2021-07-19 08:45:56.000000
194 450977902931 i 6336851 2012-07-03     0 2021-07-19 08:46:04.000000
195 450978747452 i 7181372 2013-06-07     0 2021-07-19 08:46:28.000000
196 450978865893 i 7299813 2013-09-09     0 2021-07-19 08:46:32.000000
197 450978867287 i 7301207 2013-09-10     0 2021-07-19 08:46:32.000000
198 450982863710 i 11297630 2021-08-03     0 2021-08-03 11:19:59.000000
199 450979256254 i 7690174 2014-04-24     0 2021-07-19 08:46:41.000000
200 450982863719 i 11297639 2021-08-03     0 2021-08-03 11:20:00.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);