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

7,850,101 rows

View and edit SQL

Link rowid ▼ id record_type_code record_num creation_date_gmt campus_code agency_code_num record_last_updated_gmt
101 450981862876 i 10296796 2019-03-13 14:40:00.000000   0 2021-01-01 16:33:01.130241
102 420910290368 b 3495360 2019-11-25 13:02:57.000000   0 2020-10-08 12:40:29.000000
103 450981920437 i 10354357 2019-04-18 13:25:00.000000   0 2021-01-01 16:33:14.641044
104 450982073256 i 10507176 2019-08-23 12:24:00.000000   0 2021-01-01 16:34:04.005602
105 450974461466 i 2895386 2012-06-29 13:39:55.000000   0 2021-01-01 17:22:47.168624
106 450975294914 i 3728834 2012-06-30 07:43:02.000000   0 2021-01-01 17:23:13.445269
107 450975757187 i 4191107 2012-06-30 14:21:17.000000   0 2021-01-01 17:23:36.277571
108 450978915923 i 7349843 2013-10-09 14:20:00.000000   0 2021-01-01 17:24:57.021269
109 450977485276 i 5919196 2012-07-03 03:22:55.000000   0 2020-01-07 13:22:17.169842
110 450978486442 i 6920362 2012-11-28 15:34:00.000000   0 2019-06-26 16:12:43.000000
111 450980567740 i 9001660 2016-08-23 15:12:00.000000   0 2021-01-27 13:14:25.811000
112 450982197703 i 10631623 2019-11-25 13:02:57.000000   0 2019-11-25 13:02:57.000000
113 420908253186 b 1458178 2012-06-20 16:30:07.000000   0 2012-06-20 16:30:08.000000
114 420909046730 b 2251722 2012-06-21 04:08:08.000000   0 2016-02-07 16:24:55.000000
115 450978600902 i 7034822 2013-03-05 11:18:00.000000   0 2021-01-14 09:00:24.000000
116 450973565653 i 1999573 2012-06-27 12:35:33.000000   0 2013-01-05 18:30:25.000000
117 450975958608 i 4392528 2012-06-30 17:11:34.000000   0 2017-01-01 00:59:49.452347
118 450974212162 i 2646082 2012-06-29 06:57:23.000000   0 2013-01-06 11:24:43.000000
119 450974212167 i 2646087 2012-06-29 06:57:24.000000   0 2013-01-06 11:24:44.000000
120 450981862893 i 10296813 2019-03-13 14:40:00.000000   0 2021-01-01 16:33:01.130241
121 450979429449 i 7863369 2014-08-25 11:56:00.000000   0 2021-01-14 09:00:25.000000
122 450977183390 i 5617310 2012-07-02 23:27:47.000000   0 2014-09-05 15:59:49.000000
123 450980405309 i 8839229 2016-05-06 14:14:00.000000   0 2019-01-01 00:47:27.780948
124 450974461336 i 2895256 2012-06-29 13:39:42.000000   0 2021-01-01 17:22:47.168624
125 450975534561 i 3968481 2012-06-30 11:11:01.000000   0 2021-01-01 17:23:29.012918
126 450976634952 i 5068872 2012-07-02 16:36:29.000000   0 2021-01-01 17:23:57.490651
127 450978918734 i 7352654 2013-10-10 10:10:00.000000   0 2019-03-06 17:55:05.000000
128 450981678341 i 10112261 2018-11-05 10:24:00.000000   0 2021-01-15 11:47:11.000000
129 450978277270 i 6711190 2012-07-27 17:26:59.000000   0 2019-03-09 13:52:04.000000
130 450980889027 i 9322947 2017-04-10 13:53:00.000000   0 2021-01-14 09:00:27.000000
131 450975958617 i 4392537 2012-06-30 17:11:35.000000   0 2013-01-08 13:38:53.000000
132 450974212163 i 2646083 2012-06-29 06:57:23.000000   0 2019-07-10 12:31:01.000000
133 450975527789 i 3961709 2012-06-30 11:04:27.000000   0 2021-01-20 12:48:29.000000
134 450974212172 i 2646092 2012-06-29 06:57:24.000000   0 2013-01-06 11:24:44.000000
135 450981083195 i 9517115 2017-08-17 10:40:14.000000   0 2018-07-30 15:19:00.000000
136 450974212171 i 2646091 2012-06-29 06:57:24.000000   0 2018-12-04 13:20:44.000000
137 450982431585 i 10865505 2020-07-29 12:30:00.000000   0 2020-08-07 08:50:14.000000
138 450974689598 i 3123518 2012-06-29 22:17:21.000000   0 2014-03-06 15:56:16.000000
139 450975958621 i 4392541 2012-06-30 17:11:36.000000   0 2013-01-08 13:38:53.000000
140 420909431279 b 2636271 2012-06-21 20:01:09.000000   0 2020-11-19 21:14:11.000000
141 420909196177 b 2401169 2012-06-21 05:43:25.000000   0 2017-10-18 10:29:44.000000
142 450981874513 i 10308433 2019-03-15 12:33:00.000000   0 2021-01-01 16:33:01.130241
143 450981890826 i 10324746 2019-03-27 12:51:00.000000   0 2021-01-01 16:33:04.391246
144 420908047803 b 1252795 2012-06-20 09:22:22.000000   0 2017-10-20 11:31:48.000000
145 450981972767 i 10406687 2019-06-03 07:30:12.000000   0 2021-01-01 17:16:25.591125
146 450978836020 i 7269940 2013-08-21 14:21:00.000000   0 2021-01-01 17:24:55.606991
147 450980610252 i 9044172 2016-09-20 14:30:00.000000   0 2021-01-01 17:53:05.525573
148 450980257511 i 8691431 2016-02-05 08:11:00.000000   0 2018-01-01 00:36:28.654714
149 420910346907 b 3551899 2020-09-02 10:36:41.000000   0 2020-12-17 21:34:40.000000
150 450974647596 i 3081516 2012-06-29 21:37:17.000000   0 2017-01-01 00:53:34.461026
151 450972724793 i 1158713 2012-06-23 19:42:40.000000   0 2013-01-04 19:52:18.000000
152 450973565671 i 1999591 2012-06-27 12:35:34.000000   0 2013-03-01 08:26:03.000000
153 450974212184 i 2646104 2012-06-29 06:57:24.000000   0 2013-01-06 11:24:45.000000
154 450978998774 i 7432694 2013-11-18 09:13:00.000000   0 2021-01-14 09:00:24.000000
155 450974212186 i 2646106 2012-06-29 06:57:25.000000   0 2013-01-06 11:24:46.000000
156 450982197704 i 10631624 2019-11-25 13:02:57.000000   0 2019-11-25 13:02:57.000000
157 450972724797 i 1158717 2012-06-23 19:42:42.000000   0 2013-01-04 19:52:18.000000
158 450977313465 i 5747385 2012-07-03 01:05:27.000000   0 2013-01-10 10:45:57.000000
159 450973783655 i 2217575 2012-06-28 19:27:20.000000   0 2019-07-09 12:39:24.000000
160 450974212206 i 2646126 2012-06-29 06:57:27.000000   0 2013-01-06 11:24:48.000000
161 450974212217 i 2646137 2012-06-29 06:57:28.000000   0 2013-01-06 11:24:49.000000
162 450972724814 i 1158734 2012-06-23 19:42:49.000000   0 2013-01-04 19:52:19.000000
163 450977182468 i 5616388 2012-07-02 23:27:05.000000   0 2014-09-05 15:59:47.000000
164 450977182885 i 5616805 2012-07-02 23:27:26.000000   0 2014-09-05 15:59:48.000000
165 450973558054 i 1991974 2012-06-27 12:22:07.000000   0 2019-11-04 10:57:15.000000
166 450975310118 i 3744038 2012-06-30 07:55:33.000000   0 2018-01-01 00:24:08.785099
167 450978277318 i 6711238 2012-07-27 17:27:16.000000   0 2020-06-19 10:00:48.000000
168 450975958675 i 4392595 2012-06-30 17:11:38.000000   0 2014-05-13 15:03:26.000000
169 450974212165 i 2646085 2012-06-29 06:57:23.000000   0 2013-01-06 11:24:44.000000
170 450972724809 i 1158729 2012-06-23 19:42:47.000000   0 2013-01-04 19:52:19.000000
171 450981876419 i 10310339 2019-03-18 12:09:00.000000   0 2021-01-01 16:33:01.130241
172 450976645380 i 5079300 2012-07-02 16:44:54.000000   0 2021-01-01 17:23:57.490651
173 450977911147 i 6345067 2012-07-03 10:11:51.000000   0 2021-01-01 17:24:36.296653
174 450978525349 i 6959269 2013-01-03 16:21:00.000000   0 2021-01-01 17:24:49.570016
175 450972724812 i 1158732 2012-06-23 19:42:49.000000   0 2013-01-04 19:52:19.000000
176 450972724813 i 1158733 2012-06-23 19:42:49.000000   0 2013-01-04 19:52:19.000000
177 420908053106 b 1258098 2012-06-20 09:33:53.000000   0 2014-12-23 22:19:45.000000
178 450972724815 i 1158735 2012-06-23 19:42:49.000000   0 2013-01-04 19:52:19.000000
179 450981904695 i 10338615 2019-04-08 09:37:13.000000   0 2019-04-08 09:41:34.000000
180 450974498122 i 2932042 2012-06-29 14:39:19.000000   0 2013-03-17 09:49:53.000000
181 450979895427 i 8329347 2015-06-30 09:24:00.000000   0 2021-01-20 12:32:41.000000
182 450977249204 i 5683124 2012-07-03 00:17:47.000000   0 2013-01-10 08:48:12.000000
183 450976400180 i 4834100 2012-07-01 04:35:05.000000   0 2013-01-09 04:44:09.000000
184 450972724826 i 1158746 2012-06-23 19:42:55.000000   0 2013-01-04 19:52:20.000000
185 450974212170 i 2646090 2012-06-29 06:57:24.000000   0 2013-01-06 11:24:44.000000
186 450972702483 i 1136403 2012-06-23 16:49:39.000000   0 2014-06-10 18:19:36.000000
187 450978694183 i 7128103 2013-04-24 15:57:29.000000   0 2018-07-31 12:24:05.000000
188 450974707905 i 3141825 2012-06-29 22:35:11.000000   0 2019-01-01 00:38:24.712325
189 450972724851 i 1158771 2012-06-23 19:43:07.000000   0 2013-01-04 19:52:22.000000
190 450972724852 i 1158772 2012-06-23 19:43:08.000000   0 2013-01-04 19:52:22.000000
191 450972724853 i 1158773 2012-06-23 19:43:08.000000   0 2013-01-04 19:52:22.000000
192 450972724856 i 1158776 2012-06-23 19:43:10.000000   0 2013-01-04 19:52:23.000000
193 450974212192 i 2646112 2012-06-29 06:57:26.000000   0 2013-01-06 11:24:46.000000
194 450972724842 i 1158762 2012-06-23 19:43:03.000000   0 2020-10-19 08:16:42.000000
195 450981691560 i 10125480 2018-11-13 10:26:00.000000   0 2021-01-22 11:07:41.000000
196 450981576324 i 10010244 2018-08-21 13:36:21.000000   0 2021-01-01 16:31:25.137756
197 450981877809 i 10311729 2019-03-18 14:17:10.000000   0 2021-01-01 16:33:01.130241
198 450976382555 i 4816475 2012-07-01 03:43:10.000000   0 2021-01-01 17:23:52.867178
199 450980089532 i 8523452 2015-10-23 11:39:00.000000   0 2020-01-27 09:21:43.000000
200 450973565721 i 1999641 2012-06-27 12:35:38.000000   0 2013-01-05 18:30:31.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 DATETIME, 
	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 UNIQUE INDEX pk_record_id ON record_metadata (id);
CREATE UNIQUE 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);