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

6,830,621 rows

View and edit SQL

Link rowid ▼ id record_id index_tag varfield_type_code occurrence is_permuted type2 type3 index_entry insert_title phrase_rule_rule_num phrase_rule_operation phrase_rule_subfield_list original_content parent_record_id insert_title_tag insert_title_occ
101 9142595 420907795073 d d 3 1 98 canada liability insurance periodicals tbests insurance reports property casualty 6 R 023468 Canada Liability insurance Periodicals 420907795073 t 0
102 9142596 420907795073 d d 1 1 98 canada property insurance periodicals tbests insurance reports property casualty 6 R 023468 Canada Property insurance Periodicals 420907795073 t 0
103 9142597 420907795073 d d 7 0 98 casualty insurance canada periodicals tbests insurance reports property casualty 6 R 023468   420907795073 t 0
104 9142598 420907795073 d d 6 0 98 casualty insurance united states periodicals tbests insurance reports property casualty 6 R 023468   420907795073 t 0
105 9142599 420907795073 d d 5 0 98 fire insurance canada periodicals tbests insurance reports property casualty 6 R 023468   420907795073 t 0
106 9142600 420907795073 d d 4 0 98 fire insurance united states periodicals tbests insurance reports property casualty 6 R 023468   420907795073 t 0
107 9142601 420907795073 d d 3 0 98 liability insurance canada periodicals tbests insurance reports property casualty 6 R 023468   420907795073 t 0
108 9142602 420907795073 d d 2 0 98 liability insurance united states periodicals tbests insurance reports property casualty 6 R 023468   420907795073 t 0
109 9142603 420907795073 d d 1 0 98 property insurance canada periodicals tbests insurance reports property casualty 6 R 023468   420907795073 t 0
110 9142616 420907795074 d d 0 0 109 united states congress senate rules and practice tmanual of parliamentary practice composed originally for the use of the senate of the united states 6 R h023468   420907795074 t 0
111 9142617 420907795074 d d 1 0 109 united states congress house rules and practice tmanual of parliamentary practice composed originally for the use of the senate of the united states 6 R h023468   420907795074 t 0
112 9142618 420907795074 d d 0 1 109 rules and practice united states congress senate tmanual of parliamentary practice composed originally for the use of the senate of the united states 6 R h023468 Rules and practice United States Congress Senate 420907795074 t 0
113 9142619 420907795074 d d 1 1 109 rules and practice united states congress house tmanual of parliamentary practice composed originally for the use of the senate of the united states 6 R h023468 Rules and practice United States Congress House 420907795074 t 0
114 9142627 420907795075 d d 0 0 114 revivals trevivals and missions 6 R 023468   420907795075 t 0
115 9142628 420907795075 d d 2 0 114 parish missions trevivals and missions 6 R 023468   420907795075 t 0
116 9142629 420907795075 d d 1 0 114 evangelistic work trevivals and missions 6 R 023468   420907795075 t 0
117 9142652 420907795078 d d 0 0 109 united states congress rules and practice tmanual of parliamentary practice composed originally for the use of the senate of the united states 6 R h023468   420907795078 t 0
118 9142653 420907795078 d d 0 1 109 rules and practice united states congress tmanual of parliamentary practice composed originally for the use of the senate of the united states 6 R h023468 Rules and practice United States Congress 420907795078 t 0
119 9142654 420907795078 d d 1 0 109 parliamentary practice tmanual of parliamentary practice composed originally for the use of the senate of the united states 6 R 023468   420907795078 t 0
120 9142659 420907795079 d d 0 1 100 religion egypt tdevelopment of religion and thought in ancient egypt introd by john a wilson 6 R 023468 Religion Egypt 420907795079 t 0
121 9142660 420907795079 d d 0 0 100 egypt religion tdevelopment of religion and thought in ancient egypt introd by john a wilson 6 R 023468   420907795079 t 0
122 9142672 420907795077 d d 0 0 109 memory tmemory an inductive study 6 R 023468   420907795077 t 0
123 9142695 420907795080 d d 1 0 98 parliamentary practice united states tbolles manual for business corporation meetings founded on the judicial interpretation of the rules of parliamentary law appl 6 R 023468   420907795080 t 0
124 9142696 420907795080 d d 0 0 98 corporation law united states tbolles manual for business corporation meetings founded on the judicial interpretation of the rules of parliamentary law appl 6 R 023468   420907795080 t 0
125 9142716 420907795085 d d 0 0 114 parliamentary practice trules of proceeding and debate in deliberative assemblies 6 R 023468   420907795085 t 0
126 9142722 420907795083 d d 1 1 106 religious life and customs japan tjapans religions shinto and buddhism 6 R 023468 Religious life and customs Japan 420907795083 t 0
127 9142723 420907795083 d d 0 1 106 religion japan tjapans religions shinto and buddhism 6 R 023468 Religion Japan 420907795083 t 0
128 9142724 420907795083 d d 1 0 106 japan religious life and customs tjapans religions shinto and buddhism 6 R 023468   420907795083 t 0
129 9142725 420907795083 d d 0 0 106 japan religion tjapans religions shinto and buddhism 6 R 023468   420907795083 t 0
130 9142735 420907795084 d d 0 0 98 library science tbook for all readers designed as an aid to the collection use and preservation of books and the formation of public and priva 6 R 023468   420907795084 t 0
131 9142736 420907795084 d d 1 0 98 books and reading tbook for all readers designed as an aid to the collection use and preservation of books and the formation of public and priva 6 R 023468   420907795084 t 0
132 9142755 420907795088 d d 0 0 114 parliamentary practice handbooks manuals etc trules of proceeding and debate in deliberative assemblies 6 R 023468   420907795088 t 0
133 9142757 420907795088 d d 0 1 114 handbooks manuals etc parliamentary practice trules of proceeding and debate in deliberative assemblies 6 R 023468 Handbooks, manuals, etc Parliamentary practice 420907795088 t 0
134 9142777 420907795089 d d 0 0 102 philosophy modern tfirst principles 6 R 023468   420907795089 t 0
135 9142784 420907795091 d d 0 0 108 parliamentary practice united states tlex parliamentaria americana elements of the law and practice of legislative assemblies in the united states of america 6 R 023468   420907795091 t 0
136 9142803 420907795093 d d 0 0 108 parliamentary practice united states tlex parliamentaria americana elements of the law and practice of legislative assemblies in the united states of america 6 R 023468   420907795093 t 0
137 9142810 420907795092 d d 0 0 104 prayer thow to pray 6 R 023468   420907795092 t 0
138 9142819 420907795094 d d 3 0 112 indians of north america tpeyote cult 6 R 023468   420907795094 t 0
139 9142820 420907795094 d d 1 0 112 indians of north america religion tpeyote cult 6 R 023468   420907795094 t 0
140 9142821 420907795094 d d 2 0 112 indians of north america rites and ceremonies tpeyote cult 6 R 023468   420907795094 t 0
141 9142822 420907795094 d d 4 0 112 mescaline tpeyote cult 6 R 023468   420907795094 t 0
142 9142823 420907795094 d d 0 0 112 peyotism tpeyote cult 6 R 023468   420907795094 t 0
143 9142824 420907795094 d d 1 1 112 religion indians of north america tpeyote cult 6 R 023468 Religion Indians of North America 420907795094 t 0
144 9142825 420907795094 d d 2 1 112 rites and ceremonies indians of north america tpeyote cult 6 R 023468 Rites and ceremonies Indians of North America 420907795094 t 0
145 9142835 420907795096 d d 0 0 116 trusts industrial ttrusts what can we do with them what can they do for us 6 R 023468   420907795096 t 0
146 9142841 420907795095 d d 1 0 116 arbitration international law ttacna and arica an account of the chile peru boundary dispute and of the arbitrations by the united states 6 R 023468   420907795095 t 0
147 9142842 420907795095 d d 2 0 116 chile foreign relations peru ttacna and arica an account of the chile peru boundary dispute and of the arbitrations by the united states 6 R 023468   420907795095 t 0
148 9142843 420907795095 d d 3 1 116 chile peru foreign relations ttacna and arica an account of the chile peru boundary dispute and of the arbitrations by the united states 6 R 023468 Chile Peru Foreign relations 420907795095 t 0
149 9142844 420907795095 d d 2 1 116 foreign relations chile peru ttacna and arica an account of the chile peru boundary dispute and of the arbitrations by the united states 6 R 023468 Foreign relations Chile Peru 420907795095 t 0
150 9142845 420907795095 d d 3 1 116 foreign relations peru chile ttacna and arica an account of the chile peru boundary dispute and of the arbitrations by the united states 6 R 023468 Foreign relations Peru Chile 420907795095 t 0
151 9142846 420907795095 d d 2 1 116 peru chile foreign relations ttacna and arica an account of the chile peru boundary dispute and of the arbitrations by the united states 6 R 023468 Peru Chile Foreign relations 420907795095 t 0
152 9142847 420907795095 d d 3 0 116 peru foreign relations chile ttacna and arica an account of the chile peru boundary dispute and of the arbitrations by the united states 6 R 023468   420907795095 t 0
153 9142848 420907795095 d d 0 0 116 tacna arica question ttacna and arica an account of the chile peru boundary dispute and of the arbitrations by the united states 6 R 023468   420907795095 t 0
154 9142858 420907795097 d d 0 0 118 vikings tvikings 6 R 023468   420907795097 t 0
155 9142877 420907795098 d d 0 0 109 social problems tmaking the most of social opportunities 6 R 023468   420907795098 t 0
156 9142899 420907795100 d d 0 1 119 algeria women twomen of algeria an essay on change 6 R 023468 Algeria Women 420907795100 t 0
157 9142900 420907795100 d d 1 0 119 muslim women twomen of algeria an essay on change 6 R 023468   420907795100 t 0
158 9142901 420907795100 d d 0 0 119 women algeria twomen of algeria an essay on change 6 R 023468   420907795100 t 0
159 9142906 420907795101 d d 1 0 104 united states politics and government thistory of political parties in the united states being an account of the political parties since the foundation of the gover 6 R 023468   420907795101 t 0
160 9142907 420907795101 d d 0 0 104 political parties united states thistory of political parties in the united states being an account of the political parties since the foundation of the gover 6 R 023468   420907795101 t 0
161 9142918 420907795102 d d 0 0 105 japan history tintroduction to japanese history 6 R 023468   420907795102 t 0
162 9142930 420907795105 d d 0 0 116 antisemitism united states ttarnished dream the basis of american anti semitism 6 R 023468   420907795105 t 0
163 9142931 420907795105 d d 1 0 116 jews united states public opinion ttarnished dream the basis of american anti semitism 6 R 023468   420907795105 t 0
164 9142932 420907795105 d d 1 1 116 public opinion jews united states ttarnished dream the basis of american anti semitism 6 R 023468 Public opinion Jews United States 420907795105 t 0
165 9142933 420907795105 d d 2 0 116 public opinion united states ttarnished dream the basis of american anti semitism 6 R 023468   420907795105 t 0
166 9142934 420907795105 d d 3 0 116 united states politics and government ttarnished dream the basis of american anti semitism 6 R 023468   420907795105 t 0
167 9142954 420907795106 d d 2 1 97 foreign relations latin america united states tall american front 6 R 023468 Foreign relations Latin America United States 420907795106 t 0
168 9142955 420907795106 d d 1 1 97 foreign relations united states latin america tall american front 6 R 023468 Foreign relations United States Latin America 420907795106 t 0
169 9142956 420907795106 d d 0 0 97 latin america tall american front 6 R 023468   420907795106 t 0
170 9142957 420907795106 d d 2 0 97 latin america foreign relations united states tall american front 6 R 023468   420907795106 t 0
171 9142958 420907795106 d d 1 1 97 latin america united states foreign relations tall american front 6 R 023468 Latin America United States Foreign relations 420907795106 t 0
172 9142959 420907795106 d d 1 0 97 united states foreign relations latin america tall american front 6 R 023468   420907795106 t 0
173 9142971 420907795107 d d 0 0 116 antisemitism united states ttenacity of prejudice anti semitism in contemporary america 6 R 023468   420907795107 t 0
174 9142983 420907795108 d d 1 1 108 person and offices jesus christ tlife of lives further studies in the life of christ 6 R h023468 Person and offices Jesus Christ 420907795108 t 0
175 9142984 420907795108 d d 1 0 108 jesus christ person and offices tlife of lives further studies in the life of christ 6 R h023468   420907795108 t 0
176 9142985 420907795108 d d 0 0 108 jesus christ tlife of lives further studies in the life of christ 6 R h023468   420907795108 t 0
177 9143015 420907795111 d d 0 0 100 classification dewey decimal tdecimal classification and relativ index for libraries clippings notes etc 6 R 023468   420907795111 t 0
178 9143020 420907795113 d d 1 0 110 sports franchises united states tname that team the who what where and why behind how ninety eight professional sports teams obtained their nicknames 6 R 023468   420907795113 t 0
179 9143021 420907795113 d d 0 0 110 professional sports united states tname that team the who what where and why behind how ninety eight professional sports teams obtained their nicknames 6 R 023468   420907795113 t 0
180 9143032 420907795112 d d 0 0 112 palestinian arabs tpalestinians 6 R 023468   420907795112 t 0
181 9143033 420907795112 d d 1 0 112 jewish arab relations tpalestinians 6 R 023468   420907795112 t 0
182 9143040 420907795114 d d 1 0 109 united states politics and government tmachine abolished and the people restored to power by the organization of all the people on the lines of party organization 6 R 023468   420907795114 t 0
183 9143041 420907795114 d d 0 0 109 elections united states tmachine abolished and the people restored to power by the organization of all the people on the lines of party organization 6 R 023468   420907795114 t 0
184 9143072 420907795116 d d 0 1 105 new york state indians of north america tindian affairs in colonial new york the seventeenth century 6 R 023468 New York (State) Indians of North America 420907795116 t 0
185 9143074 420907795116 d d 0 0 105 indians of north america new york state tindian affairs in colonial new york the seventeenth century 6 R 023468   420907795116 t 0
186 9143086 420907795118 d d 3 0 117 caribbean sea tunited states and the caribbean 6 R 023468   420907795118 t 0
187 9143087 420907795118 d d 2 1 117 foreign relations latin america united states tunited states and the caribbean 6 R 023468 Foreign relations Latin America United States 420907795118 t 0
188 9143088 420907795118 d d 1 1 117 foreign relations united states latin america tunited states and the caribbean 6 R 023468 Foreign relations United States Latin America 420907795118 t 0
189 9143089 420907795118 d d 2 0 117 latin america foreign relations united states tunited states and the caribbean 6 R 023468   420907795118 t 0
190 9143090 420907795118 d d 1 1 117 latin america united states foreign relations tunited states and the caribbean 6 R 023468 Latin America United States Foreign relations 420907795118 t 0
191 9143091 420907795118 d d 0 0 117 monroe doctrine tunited states and the caribbean 6 R 023468   420907795118 t 0
192 9143092 420907795118 d d 1 0 117 united states foreign relations latin america tunited states and the caribbean 6 R 023468   420907795118 t 0
193 9143103 420907795119 d d 0 0 105 individuality tindividual a study of life and death 6 R 023468   420907795119 t 0
194 9143104 420907795119 d d 1 0 105 death tindividual a study of life and death 6 R 023468   420907795119 t 0
195 9143115 420907795120 d d 0 0 114 african americans history sources tracial thought in america a documentary history 6 R 023468   420907795120 t 0
196 9143116 420907795120 d d 2 0 114 minorities united states history sources tracial thought in america a documentary history 6 R 023468   420907795120 t 0
197 9143117 420907795120 d d 3 1 114 race relations united states history sources tracial thought in america a documentary history 6 R 023468 Race relations United States History Sources 420907795120 t 0
198 9143118 420907795120 d d 1 0 114 slavery united states history sources tracial thought in america a documentary history 6 R 023468   420907795120 t 0
199 9143119 420907795120 d d 0 1 114 sources african americans history tracial thought in america a documentary history 6 R 023468 Sources African Americans History 420907795120 t 0
200 9143120 420907795120 d d 2 1 114 sources minorities united states history tracial thought in america a documentary history 6 R 023468 Sources Minorities United States History 420907795120 t 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE phrase_entry (
	id INTEGER, 
	record_id INTEGER, 
	index_tag TEXT, 
	varfield_type_code TEXT, 
	occurrence INTEGER, 
	is_permuted BOOLEAN, 
	type2 INTEGER, 
	type3 TEXT, 
	index_entry TEXT, 
	insert_title TEXT, 
	phrase_rule_rule_num INTEGER, 
	phrase_rule_operation TEXT, 
	phrase_rule_subfield_list TEXT, 
	original_content TEXT, 
	parent_record_id INTEGER, 
	insert_title_tag TEXT, 
	insert_title_occ INTEGER, 
	CHECK (is_permuted IN (0, 1))
);
CREATE INDEX idx_phrase_entry ON phrase_entry (((index_tag || index_entry)), type2, insert_title, record_id);
CREATE INDEX idx_phrase_entry_parent_record_id ON phrase_entry (parent_record_id);
CREATE INDEX idx_phrase_entry_record ON phrase_entry (record_id);
CREATE INDEX idx_phrase_entry_record_key ON phrase_entry (record_id);
CREATE UNIQUE INDEX pk_phrase_entry ON phrase_entry (id);