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

7,850,088 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 450979002928 i 7436848 2013-11-20 14:20:00.000000   0 2020-04-24 11:47:00.000000
102 450975204389 i 3638309 2012-06-30 06:25:36.000000   0 2021-01-01 17:23:11.403716
103 450980945359 i 9379279 2017-05-08 09:01:00.000000   0 2019-01-01 00:48:07.253120
104 450979718097 i 8152017 2015-02-19 15:16:00.000000   0 2021-02-12 14:11:40.054000
105 450982345218 i 10779138 2020-03-04 14:45:00.000000   0 2021-01-13 16:07:56.278000
106 450976297399 i 4731319 2012-07-01 00:42:17.000000   0 2021-01-01 17:23:51.326982
107 450979003834 i 7437754 2013-11-20 15:19:00.000000   0 2020-04-24 11:47:00.000000
108 450979005377 i 7439297 2013-11-20 16:46:00.000000   0 2020-04-24 11:47:00.000000
109 420910059895 b 3264887 2017-04-25 09:31:33.000000   0 2020-09-30 12:23:24.000000
110 420910059974 b 3264966 2017-04-25 09:32:18.000000   0 2020-09-30 12:23:24.000000
111 420908483233 b 1688225 2012-06-20 20:49:14.000000   0 2018-10-22 17:39:41.000000
112 450981196640 i 9630560 2017-11-08 13:51:00.000000   0 2020-01-07 13:43:00.191717
113 420910124643 b 3329635 2018-01-16 14:37:18.000000   0 2020-11-02 21:26:32.000000
114 450981204812 i 9638732 2017-11-14 20:08:25.000000   0 2019-08-15 23:37:23.000000
115 450981965575 i 10399495 2019-05-28 11:10:58.000000   0 2020-02-28 11:24:43.000000
116 450977778328 i 6212248 2012-07-03 07:52:38.000000   0 2018-05-03 09:56:22.000000
117 420910059160 b 3264152 2017-04-25 09:24:26.000000   0 2020-09-30 12:23:24.000000
118 450976363727 i 4797647 2012-07-01 02:53:25.000000   0 2021-02-11 08:44:59.000000
119 450982125640 i 10559560 2019-10-04 08:12:59.000000   0 2020-06-09 16:46:34.000000
120 450979479544 i 7913464 2014-09-19 14:57:14.000000   0 2021-01-12 10:23:36.815000
121 450980490304 i 8924224 2016-06-29 15:31:00.000000   0 2021-01-01 17:53:01.874615
122 450974334996 i 2768916 2012-06-29 10:13:16.000000   0 2019-01-01 00:38:11.627519
123 450981205599 i 9639519 2017-11-15 15:03:00.000000   0 2019-08-15 23:37:23.000000
124 450975190884 i 3624804 2012-06-30 06:14:20.000000   0 2021-01-01 17:23:11.403716
125 450981049261 i 9483181 2017-07-20 15:10:00.000000   0 2021-01-01 17:53:30.052861
126 420910059394 b 3264386 2017-04-25 09:26:45.000000   0 2020-09-30 12:23:24.000000
127 450974771893 i 3205813 2012-06-30 00:12:00.000000   0 2021-01-01 17:22:56.337491
128 450981449059 i 9882979 2018-05-09 14:10:00.000000   0 2019-04-06 14:28:43.000000
129 420908775062 b 1980054 2012-06-20 23:52:29.000000   0 2021-01-04 21:08:50.000000
130 450979011868 i 7445788 2013-11-25 14:32:00.000000   0 2020-04-24 11:47:00.000000
131 450981940775 i 10374695 2019-05-06 13:47:00.000000   0 2021-01-30 07:31:29.800000
132 450980930854 i 9364774 2017-04-28 09:48:00.000000   0 2021-01-15 14:35:08.622000
133 450978788819 i 7222739 2013-07-15 15:21:00.000000   0 2021-01-01 17:24:54.090366
134 450981222625 i 9656545 2017-11-30 15:13:00.000000   0 2021-01-01 17:53:36.963063
135 450979011961 i 7445881 2013-11-25 14:42:00.000000   0 2020-04-24 11:47:00.000000
136 420910059772 b 3264764 2017-04-25 09:30:22.000000   0 2020-09-30 12:23:24.000000
137 450981244872 i 9678792 2017-12-15 15:02:00.000000   0 2019-01-01 00:50:57.624514
138 420910059971 b 3264963 2017-04-25 09:32:16.000000   0 2020-09-30 12:23:24.000000
139 450976233254 i 4667174 2012-06-30 22:44:36.000000   0 2018-01-01 00:26:47.597263
140 450981159313 i 9593233 2017-10-12 09:20:00.000000   0 2019-01-01 00:48:25.995384
141 450981224481 i 9658401 2017-12-04 09:03:00.000000   0 2019-08-15 23:37:25.000000
142 450974385320 i 2819240 2012-06-29 11:35:06.000000   0 2020-11-24 12:56:04.000000
143 450980373397 i 8807317 2016-04-13 08:40:00.000000   0 2020-01-07 13:42:45.050368
144 420908665891 b 1870883 2012-06-20 22:45:38.000000   0 2019-11-13 17:14:17.000000
145 420908491695 b 1696687 2012-06-20 20:53:22.000000   0 2018-08-13 15:42:31.000000
146 450979014612 i 7448532 2013-11-26 16:11:00.000000   0 2020-04-24 11:47:01.000000
147 450978473264 i 6907184 2012-11-19 13:41:47.000000   0 2019-07-12 14:20:02.000000
148 420910059399 b 3264391 2017-04-25 09:26:48.000000   0 2020-09-30 12:23:24.000000
149 450979025257 i 7459177 2013-12-02 08:14:00.000000   0 2020-04-24 11:47:01.000000
150 420910059972 b 3264964 2017-04-25 09:32:17.000000   0 2020-09-30 12:23:24.000000
151 450981224690 i 9658610 2017-12-04 09:22:00.000000   0 2020-01-07 13:11:40.267279
152 420910059377 b 3264369 2017-04-25 09:26:35.000000   0 2020-09-30 12:23:24.000000
153 420909212542 b 2417534 2012-06-21 05:53:46.000000   0 2017-10-18 10:35:28.000000
154 450979025781 i 7459701 2013-12-02 09:07:00.000000   0 2020-04-24 11:47:01.000000
155 420908789453 b 1994445 2012-06-21 00:02:09.000000   0 2021-01-04 21:08:54.000000
156 420910060031 b 3265023 2017-04-25 09:32:51.000000   0 2020-09-30 12:23:24.000000
157 450981011083 i 9445003 2017-06-22 08:14:00.000000   0 2019-01-01 00:48:11.759466
158 450982104671 i 10538591 2019-09-19 11:10:00.000000   0 2021-01-01 17:16:31.521611
159 420910060120 b 3265112 2017-04-25 09:33:44.000000   0 2020-09-30 12:23:24.000000
160 450974284151 i 2718071 2012-06-29 08:51:59.000000   0 2021-01-01 17:22:43.924440
161 420910060201 b 3265193 2017-04-25 09:34:35.000000   0 2020-09-30 12:23:25.000000
162 450981414917 i 9848837 2018-04-13 13:12:00.000000   0 2021-02-01 06:30:02.572000
163 420908877545 b 2082537 2012-06-21 02:21:34.000000   0 2018-05-02 20:07:02.000000
164 450979026321 i 7460241 2013-12-02 10:09:00.000000   0 2020-04-24 11:47:01.000000
165 450981226323 i 9660243 2017-12-05 08:53:00.000000   0 2021-01-01 17:53:36.963063
166 420910060491 b 3265483 2017-04-25 09:37:13.000000   0 2020-09-30 12:23:25.000000
167 420910050324 b 3255316 2017-04-11 11:03:01.000000   0 2020-10-26 21:24:07.000000
168 450977956153 i 6390073 2012-07-03 10:50:29.000000   0 2019-01-01 00:41:35.920368
169 420910060266 b 3265258 2017-04-25 09:35:10.000000   0 2020-09-30 12:23:25.000000
170 450981227419 i 9661339 2017-12-05 14:02:00.000000   0 2019-08-15 23:37:25.000000
171 450981237194 i 9671114 2017-12-12 09:05:00.000000   0 2019-08-15 23:37:26.000000
172 420910059287 b 3264279 2017-04-25 09:25:40.000000   0 2020-09-30 12:23:25.000000
173 420910059764 b 3264756 2017-04-25 09:30:17.000000   0 2020-09-30 12:23:25.000000
174 450976718695 i 5152615 2012-07-02 17:37:54.000000   0 2021-01-01 17:23:59.071157
175 420908699196 b 1904188 2012-06-20 23:05:32.000000   0 2012-06-30 14:23:51.000000
176 450979153744 i 7587664 2014-02-20 11:03:00.000000   0 2019-01-01 00:46:14.492438
177 450981037645 i 9471565 2017-07-12 13:52:00.000000   0 2019-01-01 00:48:14.572026
178 450979026329 i 7460249 2013-12-02 10:10:00.000000   0 2020-04-24 11:47:01.000000
179 420910059551 b 3264543 2017-04-25 09:28:15.000000   0 2020-09-30 12:23:25.000000
180 450981238899 i 9672819 2017-12-12 14:59:00.000000   0 2020-01-07 13:43:02.606591
181 420910060374 b 3265366 2017-04-25 09:36:07.000000   0 2020-09-30 12:23:25.000000
182 420910059381 b 3264373 2017-04-25 09:26:37.000000   0 2020-09-30 12:23:25.000000
183 455268049071 j 1515695 2020-12-02 15:53:22.000000   0 2020-12-02 15:53:25.000000
184 450981831716 i 10265636 2019-02-22 12:00:00.000000   0 2019-03-07 08:38:00.000000
185 450978003980 i 6437900 2012-07-03 11:31:46.000000   0 2019-01-01 00:41:38.216676
186 450981251776 i 9685696 2017-12-21 11:48:00.000000   0 2019-08-15 23:37:27.000000
187 420910059642 b 3264634 2017-04-25 09:29:07.000000   0 2020-09-30 12:23:25.000000
188 450979026438 i 7460358 2013-12-02 10:13:00.000000   0 2020-04-24 11:47:01.000000
189 420910059178 b 3264170 2017-04-25 09:24:36.000000   0 2020-09-30 12:23:25.000000
190 450981228718 i 9662638 2017-12-06 10:06:00.000000   0 2019-01-01 00:50:50.410718
191 450981040176 i 9474096 2017-07-13 14:48:00.000000   0 2019-01-01 00:48:14.572026
192 450981722877 i 10156797 2018-11-29 12:25:00.000000   0 2021-01-01 17:16:17.309615
193 450975555934 i 3989854 2012-06-30 11:29:18.000000   0 2021-01-01 17:23:30.957571
194 450979027535 i 7461455 2013-12-02 14:33:00.000000   0 2020-04-24 11:47:01.000000
195 420910060317 b 3265309 2017-04-25 09:35:37.000000   0 2020-09-30 12:23:25.000000
196 450981074383 i 9508303 2017-08-09 12:37:00.000000   0 2021-02-03 11:10:33.000000
197 450981090905 i 9524825 2017-08-23 13:40:00.000000   0 2020-09-16 09:51:30.000000
198 450976118027 i 4551947 2012-06-30 20:16:12.000000   0 2019-07-19 14:20:31.000000
199 450981940802 i 10374722 2019-05-06 13:51:00.000000   0 2021-02-01 13:10:27.122000
200 455268049072 j 1515696 2020-12-02 15:53:47.000000   0 2020-12-02 15:53:50.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);