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
1 450982213500 i 10647420 2019-12-05     0 2021-10-27 15:47:55.606000
2 450981830638 i 10264558 2019-02-21     0 2021-10-29 14:40:51.826000
3 450977999183 i 6433103 2012-07-03     0 2021-09-02 12:20:46.302000
4 450977263887 i 5697807 2012-07-03     0 2021-09-02 12:21:56.727000
5 450982657907 i 11091827 2021-03-11     0 2021-09-03 09:46:30.745000
6 450982806753 i 11240673 2021-07-19     0 2021-09-27 08:38:43.000000
7 450974979624 i 3413544 2012-06-30     0 2021-11-01 09:01:05.409000
8 420908301681 b 1506673 2012-06-20     0 2021-07-19 11:24:16.000000
9 450982863669 i 11297589 2021-08-03     0 2021-08-03 11:19:56.000000
10 450982863671 i 11297591 2021-08-03     0 2021-08-03 11:19:56.000000
11 450982788988 i 11222908 2021-06-29     0 2021-08-21 16:05:23.000000
12 420910457739 b 3662731 2021-08-03     0 2021-08-03 11:19:58.000000
13 450982789030 i 11222950 2021-06-29     0 2021-10-21 09:08:25.000000
14 420910457751 b 3662743 2021-08-03     0 2021-08-03 11:19:58.000000
15 450982863700 i 11297620 2021-08-03     0 2021-08-03 11:19:58.000000
16 420910457759 b 3662751 2021-08-03     0 2021-08-03 11:19:59.000000
17 450982863713 i 11297633 2021-08-03     0 2021-08-03 11:19:59.000000
18 420910457765 b 3662757 2021-08-03     0 2021-08-03 11:19:59.000000
19 450982030210 i 10464130 2019-07-19     0 2021-08-12 08:45:14.000000
20 420910457767 b 3662759 2021-08-03     0 2021-08-03 11:19:59.000000
21 450980550563 i 8984483 2016-08-11     0 2021-10-25 16:56:15.945000
22 420910457774 b 3662766 2021-08-03     0 2021-08-03 11:20:00.000000
23 450982863724 i 11297644 2021-08-03     0 2021-08-03 11:20:00.000000
24 420910457776 b 3662768 2021-08-03     0 2021-08-03 11:20:00.000000
25 450982463652 i 10897572 2020-09-15     0 2021-09-22 12:58:59.000000
26 420910457784 b 3662776 2021-08-03     0 2021-08-03 11:20:00.000000
27 420909275379 b 2480371 2012-06-21     0 2021-11-26 15:10:08.000000
28 450982863734 i 11297654 2021-08-03     0 2021-08-03 11:20:00.000000
29 450981134595 i 9568515 2017-09-25     0 2021-11-27 10:40:18.000000
30 450978721040 i 7154960 2013-05-16     0 2021-11-27 10:40:23.000000
31 420910457787 b 3662779 2021-08-03     0 2021-08-03 11:20:00.000000
32 450982795299 i 11229219 2021-07-06     0 2021-11-28 10:22:47.826000
33 450982863738 i 11297658 2021-08-03     0 2021-08-03 11:20:01.000000
34 420910457789 b 3662781 2021-08-03     0 2021-08-03 11:20:01.000000
35 420910457790 b 3662782 2021-08-03     0 2021-08-03 11:20:01.000000
36 450982863740 i 11297660 2021-08-03     0 2021-08-03 11:20:01.000000
37 420910457810 b 3662802 2021-08-03     0 2021-08-03 11:20:01.000000
38 420910457817 b 3662809 2021-08-03     0 2021-08-03 11:20:02.000000
39 420910457819 b 3662811 2021-08-03     0 2021-08-03 11:20:02.000000
40 450982863774 i 11297694 2021-08-03     0 2021-08-03 11:20:02.000000
41 420910457829 b 3662821 2021-08-03     0 2021-08-03 11:20:02.000000
42 420910457833 b 3662825 2021-08-03     0 2021-08-03 11:20:02.000000
43 450982863793 i 11297713 2021-08-03     0 2021-08-03 11:20:03.000000
44 450982863794 i 11297714 2021-08-03     0 2021-08-03 11:20:03.000000
45 420910457867 b 3662859 2021-08-03     0 2021-08-03 11:20:04.000000
46 450982159715 i 10593635 2019-10-30     0 2021-07-20 08:30:32.000000
47 450982863827 i 11297747 2021-08-03     0 2021-08-03 11:20:04.000000
48 450982863848 i 11297768 2021-08-03     0 2021-08-03 11:20:05.000000
49 450982863849 i 11297769 2021-08-03     0 2021-08-03 11:20:05.000000
50 450982863850 i 11297770 2021-08-03     0 2021-08-03 11:20:05.000000
51 420910457903 b 3662895 2021-08-03     0 2021-08-03 11:20:05.000000
52 420910457919 b 3662911 2021-08-03     0 2021-08-03 11:20:06.000000
53 420910457925 b 3662917 2021-08-03     0 2021-08-03 11:20:06.000000
54 420910457926 b 3662918 2021-08-03     0 2021-08-03 11:20:06.000000
55 450982863880 i 11297800 2021-08-03     0 2021-08-03 11:20:06.000000
56 420910457932 b 3662924 2021-08-03     0 2021-08-03 11:20:06.000000
57 450982863881 i 11297801 2021-08-03     0 2021-08-03 11:20:06.000000
58 420910457938 b 3662930 2021-08-03     0 2021-08-03 11:20:06.000000
59 450982863960 i 11297880 2021-08-03     0 2021-08-03 11:20:10.000000
60 450982863967 i 11297887 2021-08-03     0 2021-08-03 11:20:10.000000
61 420910342598 b 3547590 2020-07-31     0 2021-11-11 21:51:31.000000
62 420909299306 b 2504298 2012-06-21     0 2021-11-17 21:12:43.000000
63 420909324538 b 2529530 2012-06-21     0 2021-11-17 21:13:04.000000
64 450982621297 i 11055217 2021-02-10     0 2021-11-12 10:16:55.382000
65 450982758509 i 11192429 2021-06-02     0 2021-11-12 13:41:57.224000
66 450982572459 i 11006379 2020-12-23     0 2021-08-05 06:08:53.000000
67 450982215873 i 10649793 2019-12-09     0 2021-11-13 07:44:48.913000
68 450982899146 i 11333066 2021-08-20     0 2021-11-15 07:41:46.686000
69 450982740551 i 11174471 2021-05-18     0 2021-11-26 06:23:45.353000
70 450978968301 i 7402221 2013-10-30     0 2021-11-27 09:16:39.000000
71 450975950182 i 4384102 2012-06-30     0 2021-09-17 08:40:33.000000
72 450982984628 i 11418548 2021-10-15     0 2021-11-27 10:40:23.000000
73 450979498116 i 7932036 2014-10-01     0 2021-11-27 10:40:37.000000
74 450978267490 i 6701410 2012-07-27     0 2021-11-16 08:21:10.791000
75 450980054709 i 8488629 2015-10-02     0 2021-09-27 08:36:01.000000
76 450978230844 i 6664764 2012-07-03     0 2021-10-22 17:15:17.238000
77 450982827470 i 11261390 2021-07-27     0 2021-08-06 10:13:22.000000
78 450982807581 i 11241501 2021-07-19     0 2021-11-17 07:03:58.454000
79 450978078482 i 6512402 2012-07-03     0 2021-10-07 09:04:44.000000
80 450982112021 i 10545941 2019-09-25     0 2021-10-25 08:53:30.000000
81 450980964328 i 9398248 2017-05-18     0 2021-11-18 14:28:52.643000
82 450978895194 i 7329114 2013-09-26     0 2021-11-19 15:17:03.833000
83 420909318139 b 2523131 2012-06-21     0 2021-11-17 21:13:00.000000
84 450981892886 i 10326806 2019-03-28     0 2021-11-02 16:24:27.715000
85 450982758522 i 11192442 2021-06-02     0 2021-11-11 13:03:06.020000
86 450982042351 i 10476271 2019-07-30     0 2021-11-11 14:47:00.102000
87 450978911394 i 7345314 2013-10-07     0 2021-07-31 08:50:42.000000
88 450976183843 i 4617763 2012-06-30     0 2021-09-29 13:02:43.000000
89 450981981879 i 10415799 2019-06-11     0 2021-08-12 08:39:04.000000
90 450982863675 i 11297595 2021-08-03     0 2021-08-03 11:19:57.000000
91 420910457726 b 3662718 2021-08-03     0 2021-08-03 11:19:57.000000
92 420910457732 b 3662724 2021-08-03     0 2021-08-03 11:19:57.000000
93 420910457737 b 3662729 2021-08-03     0 2021-08-03 11:19:57.000000
94 450982863687 i 11297607 2021-08-03     0 2021-08-03 11:19:58.000000
95 420910457745 b 3662737 2021-08-03     0 2021-08-03 11:19:58.000000
96 450982863698 i 11297618 2021-08-03     0 2021-08-03 11:19:58.000000
97 420910457780 b 3662772 2021-08-03     0 2021-08-03 11:20:00.000000
98 450982863748 i 11297668 2021-08-03     0 2021-08-03 11:20:01.000000
99 420910457803 b 3662795 2021-08-03     0 2021-08-03 11:20:01.000000
100 450982863775 i 11297695 2021-08-03     0 2021-08-03 11:20:02.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);