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
1 450981041092 i 9475012 2017-07-14 09:23:00.000000   0 2021-01-12 10:42:43.648000
2 450972724739 i 1158659 2012-06-23 19:42:14.000000   0 2013-01-04 19:52:13.000000
3 450972724740 i 1158660 2012-06-23 19:42:15.000000   0 2013-01-04 19:52:13.000000
4 450972724741 i 1158661 2012-06-23 19:42:15.000000   0 2013-01-04 19:52:13.000000
5 450972724749 i 1158669 2012-06-23 19:42:19.000000   0 2013-01-04 19:52:14.000000
6 450981891248 i 10325168 2019-03-27 14:05:00.000000   0 2021-02-03 17:16:53.929000
7 450978954689 i 7388609 2013-10-25 09:12:45.000000   0 2018-07-27 15:57:21.000000
8 450977182126 i 5616046 2012-07-02 23:26:50.000000   0 2014-09-05 15:59:45.000000
9 450979539218 i 7973138 2014-10-22 11:23:00.000000   0 2021-01-28 12:08:38.000000
10 420908044442 b 1249434 2012-06-20 02:53:33.000000   0 2014-12-23 22:19:06.000000
11 450973903980 i 2337900 2012-06-28 22:37:59.000000   0 2017-01-01 00:52:29.532739
12 450981083298 i 9517218 2017-08-17 10:40:51.000000   0 2018-07-30 15:19:06.000000
13 450976416939 i 4850859 2012-07-01 05:24:53.000000   0 2013-09-15 09:32:09.000000
14 450977177694 i 5611614 2012-07-02 23:23:36.000000   0 2014-09-05 15:59:41.000000
15 450978799110 i 7233030 2013-07-24 15:10:00.000000   0 2014-10-21 12:12:24.042000
16 450974768490 i 3202410 2012-06-30 00:08:23.000000   0 2015-06-18 11:16:09.000000
17 450974797911 i 3231831 2012-06-30 00:36:24.000000   0 2020-10-20 13:48:59.000000
18 450974212148 i 2646068 2012-06-29 06:57:22.000000   0 2013-01-06 11:24:42.000000
19 450974212146 i 2646066 2012-06-29 06:57:22.000000   0 2018-05-22 13:08:12.000000
20 450981841625 i 10275545 2019-03-01 14:22:00.000000   0 2021-01-01 16:32:54.136276
21 450981898155 i 10332075 2019-04-02 10:45:37.000000   0 2021-01-01 16:33:07.929122
22 450981762297 i 10196217 2018-12-28 14:37:00.000000   0 2021-01-01 17:16:18.740683
23 450979089967 i 7523887 2014-01-15 08:35:00.000000   0 2021-01-01 17:25:11.043986
24 450976422384 i 4856304 2012-07-01 05:39:29.000000   0 2021-01-22 10:50:59.000000
25 450972724745 i 1158665 2012-06-23 19:42:18.000000   0 2013-01-04 19:52:14.000000
26 450972724752 i 1158672 2012-06-23 19:42:21.000000   0 2013-01-04 19:52:14.000000
27 450972724753 i 1158673 2012-06-23 19:42:22.000000   0 2013-01-04 19:52:14.000000
28 450975958560 i 4392480 2012-06-30 17:11:32.000000   0 2013-01-08 13:38:47.000000
29 450975958581 i 4392501 2012-06-30 17:11:34.000000   0 2013-01-08 13:38:49.000000
30 420910092930 b 3297922 2017-08-17 10:40:14.000000   0 2019-08-22 20:49:17.000000
31 450974212147 i 2646067 2012-06-29 06:57:22.000000   0 2013-01-06 11:24:42.000000
32 450981937712 i 10371632 2019-05-03 09:57:00.000000   0 2021-01-01 17:16:24.855210
33 450972724755 i 1158675 2012-06-23 19:42:22.000000   0 2013-01-04 19:52:14.000000
34 450976400131 i 4834051 2012-07-01 04:34:56.000000   0 2013-01-09 04:44:05.000000
35 450976400172 i 4834092 2012-07-01 04:35:03.000000   0 2013-01-09 04:44:08.000000
36 450976400204 i 4834124 2012-07-01 04:35:09.000000   0 2013-01-09 04:44:12.000000
37 450974212155 i 2646075 2012-06-29 06:57:22.000000   0 2013-01-06 11:24:43.000000
38 450979673975 i 8107895 2015-01-20 14:50:39.000000   0 2015-09-21 12:55:43.000000
39 450974212159 i 2646079 2012-06-29 06:57:23.000000   0 2013-01-06 11:24:43.000000
40 450972724810 i 1158730 2012-06-23 19:42:48.000000   0 2013-01-04 19:52:19.000000
41 450973565636 i 1999556 2012-06-27 12:35:32.000000   0 2013-01-05 18:30:24.000000
42 420908374654 b 1579646 2012-06-20 19:55:04.000000   0 2020-09-17 16:45:38.000000
43 450975958570 i 4392490 2012-06-30 17:11:33.000000   0 2013-01-08 13:38:48.000000
44 450975958575 i 4392495 2012-06-30 17:11:33.000000   0 2013-01-08 13:38:49.000000
45 420908180824 b 1385816 2012-06-20 13:57:39.000000   0 2020-08-19 17:08:41.000000
46 450975958595 i 4392515 2012-06-30 17:11:32.000000   0 2013-01-08 13:38:51.000000
47 450978954690 i 7388610 2013-10-25 09:12:45.000000   0 2018-07-27 15:57:21.000000
48 450973565638 i 1999558 2012-06-27 12:35:32.000000   0 2013-01-05 18:30:24.000000
49 420908490011 b 1695003 2012-06-20 20:52:33.000000   0 2019-12-29 13:39:28.000000
50 450973565639 i 1999559 2012-06-27 12:35:32.000000   0 2013-01-05 18:30:24.000000
51 420909264218 b 2469210 2012-06-21 15:57:51.000000   0 2016-02-07 16:24:21.000000
52 450979673974 i 8107894 2015-01-20 14:50:39.000000   0 2015-01-26 08:58:51.000000
53 450975958586 i 4392506 2012-06-30 17:11:34.000000   0 2015-12-09 15:15:16.000000
54 450975958534 i 4392454 2012-06-30 17:11:31.000000   0 2013-02-06 08:46:27.000000
55 450974212221 i 2646141 2012-06-29 06:57:29.000000   0 2013-01-06 11:24:49.000000
56 450974212222 i 2646142 2012-06-29 06:57:29.000000   0 2013-01-06 11:24:49.000000
57 450976200497 i 4634417 2012-06-30 21:55:21.000000   0 2017-01-01 01:01:39.686922
58 450972724773 i 1158693 2012-06-23 19:42:30.000000   0 2013-01-04 19:52:16.000000
59 450972724775 i 1158695 2012-06-23 19:42:31.000000   0 2013-01-04 19:52:16.000000
60 450972724776 i 1158696 2012-06-23 19:42:32.000000   0 2013-01-04 19:52:16.000000
61 450979354941 i 7788861 2014-07-07 15:27:00.000000   0 2018-01-01 00:33:45.397096
62 420909587700 b 2792692 2012-07-26 23:20:58.000000   0 2019-03-20 14:20:40.000000
63 450981855444 i 10289364 2019-03-12 14:36:00.000000   0 2021-01-01 16:32:57.612316
64 450981977273 i 10411193 2019-06-05 15:39:00.000000   0 2021-01-01 16:33:27.855896
65 450981670680 i 10104600 2018-10-30 11:55:00.000000   0 2018-11-07 14:26:29.000000
66 450981912537 i 10346457 2019-04-15 11:22:00.000000   0 2021-01-01 16:33:11.434099
67 450980258668 i 8692588 2016-02-05 14:37:00.000000   0 2021-01-01 17:52:55.785774
68 450980225137 i 8659057 2016-01-15 14:04:00.000000   0 2020-01-27 09:21:46.000000
69 450976571492 i 5005412 2012-07-02 15:51:18.000000   0 2017-08-26 16:06:40.000000
70 450977179511 i 5613431 2012-07-02 23:24:56.000000   0 2014-09-05 15:59:43.000000
71 450975958545 i 4392465 2012-06-30 17:11:31.000000   0 2013-04-21 16:53:45.000000
72 450974778772 i 3212692 2012-06-30 00:18:53.000000   0 2017-01-01 00:54:15.598781
73 450974212154 i 2646074 2012-06-29 06:57:22.000000   0 2013-02-14 11:03:51.000000
74 450973565641 i 1999561 2012-06-27 12:35:32.000000   0 2013-01-05 18:30:24.000000
75 420908767249 b 1972241 2012-06-20 23:47:33.000000   0 2016-11-18 21:51:27.000000
76 420908975497 b 2180489 2012-06-21 03:22:21.000000   0 2020-10-28 16:01:33.000000
77 450973565648 i 1999568 2012-06-27 12:35:33.000000   0 2013-01-05 18:30:25.000000
78 420908777770 b 1982762 2012-06-20 23:54:09.000000   0 2019-10-11 14:14:16.309000
79 450978954691 i 7388611 2013-10-25 09:12:46.000000   0 2018-07-27 15:57:21.000000
80 450976400095 i 4834015 2012-07-01 04:34:51.000000   0 2014-12-30 13:54:09.000000
81 450972724861 i 1158781 2012-06-23 19:43:12.000000   0 2013-01-04 19:52:23.000000
82 450972724865 i 1158785 2012-06-23 19:43:14.000000   0 2013-01-04 19:52:23.000000
83 450972724866 i 1158786 2012-06-23 19:43:14.000000   0 2013-01-04 19:52:23.000000
84 450974212174 i 2646094 2012-06-29 06:57:24.000000   0 2013-01-06 11:24:44.000000
85 450973565652 i 1999572 2012-06-27 12:35:33.000000   0 2013-01-05 18:30:25.000000
86 450974212177 i 2646097 2012-06-29 06:57:24.000000   0 2013-01-06 11:24:45.000000
87 450972724768 i 1158688 2012-06-23 19:42:27.000000   0 2020-02-26 08:22:07.000000
88 450975459955 i 3893875 2012-06-30 10:07:00.000000   0 2021-02-10 09:42:02.000000
89 450981083193 i 9517113 2017-08-17 10:40:14.000000   0 2018-07-30 15:18:59.000000
90 450975224991 i 3658911 2012-06-30 06:42:42.000000   0 2021-02-11 09:51:37.000000
91 450982486428 i 10920348 2020-10-06 14:47:00.000000   0 2021-01-22 09:07:14.000000
92 450974212157 i 2646077 2012-06-29 06:57:23.000000   0 2013-01-06 11:24:43.000000
93 450972724778 i 1158698 2012-06-23 19:42:33.000000   0 2013-01-04 19:52:16.000000
94 420910092951 b 3297943 2017-08-17 10:40:21.000000   0 2019-08-22 20:49:17.000000
95 450972724792 i 1158712 2012-06-23 19:42:39.000000   0 2013-01-04 19:52:18.000000
96 450973565651 i 1999571 2012-06-27 12:35:33.000000   0 2013-01-05 18:30:25.000000
97 450977181484 i 5615404 2012-07-02 23:26:21.000000   0 2014-09-05 15:59:43.000000
98 450974775372 i 3209292 2012-06-30 00:15:21.000000   0 2013-03-25 17:13:38.000000
99 455267989642 j 1456266 2016-01-13 15:58:42.000000   0 2016-05-29 14:42:03.000000
100 450975152435 i 3586355 2012-06-30 05:43:14.000000   0 2021-02-01 08:19:41.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);