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

13,720,026 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
1 450980558319 i 8992239 2016-08-16     0 2021-10-11 11:41:47.025000
2 420909767806 b 2972798 2014-06-10     0 2020-02-24 21:24:32.000000
3 450975109490 i 3543410 2012-06-30     0 2019-04-18 08:52:06.000000
4 450982452214 i 10886134 2020-08-31     0 2021-09-26 00:30:16.000000
5 450977618266 i 6052186 2012-07-03     0 2021-04-16 12:21:42.000000
6 450979658427 i 8092347 2015-01-08     0 2019-03-26 09:47:49.000000
7 450981623822 i 10057742 2018-09-25     0 2020-10-14 08:35:18.000000
8 420909495851 b 2700843 2012-06-21     0 2021-08-25 12:10:27.000000
9 450981296039 i 9729959 2018-01-22     0 2020-02-28 08:31:26.000000
10 450980355849 i 8789769 2016-04-05     0 2021-09-13 09:24:07.000000
11 450982883564 i 11317484 2021-08-09     0 2021-11-26 09:42:46.000000
12 420910167708 b 3372700 2018-08-08     0 2021-12-03 21:31:13.000000
13 420910152029 b 3357021 2018-05-21     0 2020-11-02 15:06:01.000000
14 420908471834 b 1676826 2012-06-20     0 2019-03-26 15:16:24.000000
15 450981775853 i 10209773 2019-01-09     0 2021-12-05 09:22:42.336000
16 420909521841 b 2726833 2012-06-21     0 2021-10-11 12:02:54.000000
17 450981259591 i 9693511 2017-12-28     0 2021-04-19 00:04:12.000000
18 450981368705 i 9802625 2018-03-14     0 2021-04-19 00:04:23.000000
19 450981266411 i 9700331 2018-01-03     0 2021-05-26 11:07:58.772000
20 450977028114 i 5462034 2012-07-02     0 2021-11-18 17:22:10.000000
21 450981628588 i 10062508 2018-09-28     0 2021-01-01 16:31:49.777926
22 450981344982 i 9778902 2018-02-27     0 2020-01-07 13:11:45.783971
23 450980529647 i 8963567 2016-07-26     0 2021-05-07 09:50:06.000000
24 450976764727 i 5198647 2012-07-02     0 2021-05-07 14:31:42.628000
25 450980586225 i 9020145 2016-09-06     0 2021-11-27 15:55:04.665000
26 420909781082 b 2986074 2014-09-03     0 2021-11-27 21:17:00.000000
27 420910222694 b 3427686 2019-03-05     0 2021-04-19 21:33:46.000000
28 450980063697 i 8497617 2015-10-08     0 2020-01-07 13:42:39.790938
29 420909510888 b 2715880 2012-06-21     0 2020-03-05 21:21:12.000000
30 450976974990 i 5408910 2012-07-02     0 2021-01-01 17:24:05.271289
31 450977341209 i 5775129 2012-07-03     0 2021-01-01 17:24:22.639413
32 450977652771 i 6086691 2012-07-03     0 2021-01-01 17:24:30.119197
33 450976567677 i 5001597 2012-07-02     0 2019-01-01 00:40:13.792203
34 450981764820 i 10198740 2019-01-02     0 2021-11-30 08:18:44.293000
35 450978708966 i 7142886 2013-05-06     0 2021-07-27 19:24:42.822000
36 450973638567 i 2072487 2012-06-27     0 2019-03-11 16:26:31.000000
37 420909749615 b 2954607 2014-03-10     0 2021-11-12 21:20:43.000000
38 450980286779 i 8720699 2016-02-17     0 2021-07-20 15:57:48.439000
39 450981390489 i 9824409 2018-03-28     0 2021-11-15 08:31:58.464000
40 450977938195 i 6372115 2012-07-03     0 2021-09-24 08:58:25.000000
41 450981469409 i 9903329 2018-05-24     0 2019-01-08 11:11:40.000000
42 450981384694 i 9818614 2018-03-23     0 2021-11-01 12:12:43.972000
43 450981338405 i 9772325 2018-02-21     0 2021-08-23 17:52:29.347000
44 420908233875 b 1438867 2012-06-20     0 2021-11-23 09:15:32.000000
45 450981510099 i 9944019 2018-06-26     0 2021-09-25 22:41:22.000000
46 450979682304 i 8116224 2015-01-26     0 2021-11-23 10:05:24.038000
47 450982503518 i 10937438 2020-10-26     0 2021-08-11 12:25:23.000000
48 450981425325 i 9859245 2018-04-20     0 2021-06-15 22:45:53.000000
49 450976010108 i 4444028 2012-06-30     0 2021-11-16 13:51:17.000000
50 420907964602 b 1169594 2012-06-20     0 2021-11-26 21:10:37.000000
51 450978924585 i 7358505 2013-10-16     0 2019-06-10 09:29:21.000000
52 450980988902 i 9422822 2017-06-07     0 2020-03-05 10:12:42.000000
53 450982240367 i 10674287 2019-12-19     0 2021-09-13 09:25:05.000000
54 420907930875 b 1135867 2012-06-19     0 2021-06-11 21:05:39.000000
55 450981216675 i 9650595 2017-11-27     0 2021-12-04 13:04:43.000000
56 450977882469 i 6316389 2012-07-03     0 2019-07-12 14:14:32.000000
57 450976156679 i 4590599 2012-06-30     0 2019-01-01 00:39:57.655709
58 420910129225 b 3334217 2018-02-08     0 2020-01-29 21:51:10.000000
59 420908085400 b 1290392 2012-06-20     0 2021-11-07 15:48:33.000000
60 420910152030 b 3357022 2018-05-21     0 2020-11-02 15:06:01.000000
61 450982105634 i 10539554 2019-09-19     0 2021-01-01 17:16:31.521611
62 450978320142 i 6754062 2012-08-07     0 2020-07-03 09:47:40.000000
63 450982243577 i 10677497 2019-12-19     0 2021-01-01 17:16:37.549937
64 450975535744 i 3969664 2012-06-30     0 2021-01-01 17:23:29.012918
65 450979939209 i 8373129 2015-07-24     0 2021-01-01 17:52:43.969505
66 450980605927 i 9039847 2016-09-16     0 2021-01-01 17:53:05.525573
67 450981273574 i 9707494 2018-01-08     0 2021-01-01 17:53:39.283498
68 450982213210 i 10647130 2019-12-05     0 2021-03-16 15:18:39.000000
69 450981446497 i 9880417 2018-05-08     0 2019-01-01 00:51:24.959550
70 450975523838 i 3957758 2012-06-30     0 2021-06-30 08:35:25.000000
71 420909815020 b 3020012 2015-01-08     0 2021-03-31 13:43:21.000000
72 450982512838 i 10946758 2020-11-02     0 2021-12-04 13:04:25.000000
73 450982180764 i 10614684 2019-11-14     0 2021-11-22 11:18:11.058000
74 450981816687 i 10250607 2019-02-12     0 2021-08-06 08:31:31.000000
75 450976932933 i 5366853 2012-07-02     0 2021-04-18 23:59:40.000000
76 450979319676 i 7753596 2014-06-12     0 2020-01-07 13:09:57.432727
77 450982794288 i 11228208 2021-07-05     0 2021-07-14 17:34:04.000000
78 450980402806 i 8836726 2016-05-04     0 2021-09-10 08:46:02.000000
79 450973709117 i 2143037 2012-06-27     0 2021-05-05 12:06:19.000000
80 420909720726 b 2925718 2013-12-12     0 2020-12-31 21:35:08.000000
81 450979160672 i 7594592 2014-02-24     0 2019-01-08 11:11:15.000000
82 450979783978 i 8217898 2015-04-08     0 2019-01-08 11:11:19.000000
83 450981261136 i 9695056 2017-12-29     0 2021-04-19 00:04:12.000000
84 450981903419 i 10337339 2019-04-05     0 2021-04-26 13:22:44.000000
85 450981430004 i 9863924 2018-04-24     0 2021-04-19 09:10:34.000000
86 450982794297 i 11228217 2021-07-05     0 2021-07-22 11:28:59.000000
87 450982083882 i 10517802 2019-09-05     0 2021-09-28 17:02:25.000000
88 450981186353 i 9620273 2017-11-01     0 2021-11-24 12:53:35.234000
89 420908118766 b 1323758 2012-06-20     0 2021-03-25 15:50:57.000000
90 450975950119 i 4384039 2012-06-30     0 2018-08-20 15:53:47.000000
91 450982567968 i 11001888 2020-12-18     0 2021-10-25 11:55:49.206000
92 450980108564 i 8542484 2015-11-04     0 2020-02-18 09:20:32.000000
93 450981628592 i 10062512 2018-09-28     0 2021-02-26 08:33:32.000000
94 450980384354 i 8818274 2016-04-21     0 2021-04-29 09:33:57.147000
95 450979658605 i 8092525 2015-01-08     0 2020-07-08 08:52:14.000000
96 450975495793 i 3929713 2012-06-30     0 2021-08-09 12:01:02.000000
97 450981272298 i 9706218 2018-01-08     0 2020-09-08 09:02:31.000000
98 420908268879 b 1473871 2012-06-20     0 2019-08-22 14:05:30.000000
99 450975208476 i 3642396 2012-06-30     0 2021-01-01 17:23:11.403716
100 450975826134 i 4260054 2012-06-30     0 2021-01-01 17:23:37.966062

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);