phrase_entry

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

6,830,621 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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
1 1 9141961 420907795009 d d 0 1 119 juvenile literature sea monsters united states twater monsters opposing viewpoints 6 R 023468 Juvenile literature Sea monsters United States 420907795009 t 0
2 2 9141962 420907795009 d d 0 0 119 sea monsters united states juvenile literature twater monsters opposing viewpoints 6 R 023468   420907795009 t 0
3 3 9141972 420907795010 d d 0 1 115 sermons disciples of christ tseeking the old paths and other sermons 6 R h023468 Sermons Disciples of Christ 420907795010 t 0
4 4 9141973 420907795010 d d 1 0 115 sermons american tseeking the old paths and other sermons 6 R 023468   420907795010 t 0
5 5 9141974 420907795010 d d 0 0 115 disciples of christ sermons tseeking the old paths and other sermons 6 R h023468   420907795010 t 0
6 6 9141987 420907795011 d d 0 0 102 endowments united states directories tfoundation grants index 6 R 023468   420907795011 t 0
7 7 9141995 420907795012 d d 1 1 114 juvenile literature christianity treligion of tomorrow 6 R 023468 Juvenile literature Christianity 420907795012 t 0
8 8 9141996 420907795012 d d 0 0 114 god treligion of tomorrow 6 R 023468   420907795012 t 0
9 9 9141997 420907795012 d d 1 0 114 christianity juvenile literature treligion of tomorrow 6 R 023468   420907795012 t 0
10 10 9141998 420907795013 d d 0 0 117 religion tupward steps 6 R 023468   420907795013 t 0
11 11 9142007 420907795014 d d 0 0 102 political science tfirst principles in politics 6 R 023468   420907795014 t 0
12 12 9142015 420907795015 d d 0 0 98 legends juvenile literature tbook of legends told over again 6 R 023468   420907795015 t 0
13 13 9142016 420907795015 d d 0 1 98 juvenile literature legends tbook of legends told over again 6 R 023468 Juvenile literature Legends 420907795015 t 0
14 14 9142031 420907795016 d d 0 0 115 trusts industrial congresses tspeeches debates resolutions list of the delegates committees etc 6 R 023468   420907795016 t 0
15 15 9142040 420907795017 d d 0 0 102 clearinghouses tfederal clearing houses 6 R 023468   420907795017 t 0
16 16 9142041 420907795017 d d 1 0 102 banks and banking united states tfederal clearing houses 6 R 023468   420907795017 t 0
17 17 9142051 420907795018 d d 0 0 114 conduct of life tright living as a fine art a study of channings symphony as an outline of the ideal life and character 6 R 023468   420907795018 t 0
18 18 9142059 420907795019 d d 0 0 102 public libraries tfreie offentliche bibliotheken volksbibliotheken und lesehallen 6 R 023468   420907795019 t 0
19 19 9142060 420907795019 d d 1 0 102 library extension tfreie offentliche bibliotheken volksbibliotheken und lesehallen 6 R 023468   420907795019 t 0
20 20 9142068 420907795020 d d 0 0 116 trusts industrial ttrusts or competition both sides of the great question in business law and politics 6 R 023468   420907795020 t 0
21 21 9142069 420907795020 d d 1 0 116 competition ttrusts or competition both sides of the great question in business law and politics 6 R 023468   420907795020 t 0
22 22 9142077 420907795021 d d 0 0 98 transcendentalism new england tbrook farm its members scholars and visitors 6 R 023468   420907795021 t 0
23 23 9142078 420907795021 d d 1 0 98 brook farm tbrook farm its members scholars and visitors 6 R 023468   420907795021 t 0
24 24 9142097 420907795023 d d 2 0 100 social sciences tdemocracy and empire with studies of their psychological economic and moral foundations 6 R 023468   420907795023 t 0
25 25 9142098 420907795023 d d 3 0 100 political science tdemocracy and empire with studies of their psychological economic and moral foundations 6 R 023468   420907795023 t 0
26 26 9142099 420907795023 d d 1 0 100 imperialism tdemocracy and empire with studies of their psychological economic and moral foundations 6 R 023468   420907795023 t 0
27 27 9142100 420907795023 d d 0 0 100 democracy tdemocracy and empire with studies of their psychological economic and moral foundations 6 R 023468   420907795023 t 0
28 28 9142106 420907795024 d d 0 0 115 christian sociology great britain tsocial meaning of modern religious movements in england 6 R 023468   420907795024 t 0
29 29 9142107 420907795024 d d 1 1 115 church history great britain 18th century tsocial meaning of modern religious movements in england 6 R 023468 Church history Great Britain 18th century 420907795024 t 0
30 30 9142108 420907795024 d d 2 1 115 church history great britain 19th century tsocial meaning of modern religious movements in england 6 R 023468 Church history Great Britain 19th century 420907795024 t 0
31 31 9142109 420907795024 d d 0 1 115 great britain christian sociology tsocial meaning of modern religious movements in england 6 R 023468 Great Britain Christian sociology 420907795024 t 0
32 32 9142131 420907795026 d d 0 1 101 commentaries bible n t epistles of paul tepistles of paul the apostle to the thessalonians corinthians galatians romans and philippians 7 R h023468 Commentaries Bible NT Epistles of Paul 420907795026 t 0
33 33 9142132 420907795026 d d 0 0 101 bible n t epistles of paul commentaries tepistles of paul the apostle to the thessalonians corinthians galatians romans and philippians 7 R h023468   420907795026 t 0
34 34 9142143 420907795027 d d 0 0 116 taxation ttheory and practice of taxation 6 R 023468   420907795027 t 0
35 35 9142156 420907795028 d d 1 0 115 spiritual life tspiritual life studies in the science of religion 6 R 023468   420907795028 t 0
36 36 9142157 420907795028 d d 0 0 115 religion philosophy tspiritual life studies in the science of religion 6 R 023468   420907795028 t 0
37 37 9142158 420907795028 d d 0 1 115 philosophy religion tspiritual life studies in the science of religion 6 R 023468 Philosophy Religion 420907795028 t 0
38 38 9142177 420907795030 d d 1 0 114 economics trural wealth and welfare economic principles illustrated and applied in farm life 6 R 023468   420907795030 t 0
39 39 9142178 420907795030 d d 0 1 114 economic aspects agriculture trural wealth and welfare economic principles illustrated and applied in farm life 6 R 023468 Economic aspects Agriculture 420907795030 t 0
40 40 9142179 420907795030 d d 0 0 114 agriculture economic aspects trural wealth and welfare economic principles illustrated and applied in farm life 6 R 023468   420907795030 t 0
41 41 9142187 420907795031 d d 0 0 101 economics teconomics of distribution 6 R 023468   420907795031 t 0
42 42 9142197 420907795032 d d 0 0 116 tenement houses tten years war an account of the battle with the slum in new york 6 R 023468   420907795032 t 0
43 43 9142198 420907795032 d d 1 0 116 poor new york state new york tten years war an account of the battle with the slum in new york 6 R 023468   420907795032 t 0
44 44 9142199 420907795032 d d 1 1 116 new york state poor new york tten years war an account of the battle with the slum in new york 6 R 023468 New York (State) Poor New York 420907795032 t 0
45 45 9142200 420907795032 d d 1 1 116 new york poor new york state tten years war an account of the battle with the slum in new york 6 R 023468 New York Poor New York (State) 420907795032 t 0
46 46 9142208 420907795033 d d 0 0 101 faith tessay toward faith 6 R 023468   420907795033 t 0
47 47 9142218 420907795034 d d 1 1 105 new york state imprints in rare books new york 1900 tintroduction to ethics 6 R 023468 New York (State) Imprints (in rare books) New York 1900 420907795034 t 0
48 48 9142219 420907795034 d d 1 1 105 new york imprints in rare books new york state 1900 tintroduction to ethics 6 R 023468 New York Imprints (in rare books) New York (State) 1900 420907795034 t 0
49 49 9142221 420907795034 d d 0 0 105 ethics tintroduction to ethics 6 R 023468   420907795034 t 0
50 50 9142224 420907795036 d d 0 0 99 united states congress tcongressional government a study in american politics 6 R h023468   420907795036 t 0
51 51 9142225 420907795036 d d 1 0 99 executive power united states tcongressional government a study in american politics 6 R 023468   420907795036 t 0
52 52 9142255 420907795038 d d 0 0 111 presidents united states election tour presidents and how we make them 6 R 023468   420907795038 t 0
53 53 9142256 420907795038 d d 0 1 111 election presidents united states tour presidents and how we make them 6 R 023468 Election Presidents United States 420907795038 t 0
54 54 9142263 420907795039 d d 0 0 115 parliamentary practice tshawhans parliamentary text book revised 6 R 023468   420907795039 t 0
55 55 9142271 420907795040 d d 1 0 99 individuality tconception of immortality 6 R 023468   420907795040 t 0
56 56 9142272 420907795040 d d 0 0 99 immortality tconception of immortality 6 R 023468   420907795040 t 0
57 57 9142296 420907795042 d d 0 0 99 english poetry tcomplete poetical works of sir walter scott 6 R 023468   420907795042 t 0
58 58 9142311 420907795044 d d 0 0 112 catholic church united states tpeople of our parish being chronicle and comment of katharine fitzgerald pewholder in the church of st paul the apostle 6 R h023468   420907795044 t 0
59 59 9142318 420907795045 d d 0 0 99 united states congress tcongressional committees a study of the origin and development of our national and local legislative methods 6 R h023468   420907795045 t 0
60 60 9142335 420907795046 d d 0 1 115 commentaries bible n t gospels tsynoptic gospels together with a chapter on the text criticism of the new testament 7 R h023468 Commentaries Bible NT Gospels 420907795046 t 0
61 61 9142336 420907795046 d d 0 0 115 bible n t gospels commentaries tsynoptic gospels together with a chapter on the text criticism of the new testament 7 R h023468   420907795046 t 0
62 62 9142343 420907795047 d d 0 0 105 referendum tinitiative and referendum state legislation 6 R 023468   420907795047 t 0
63 63 9142358 420907795048 d d 0 1 98 infallibility catholic church tbible and its interpreter 6 R h023468 Infallibility Catholic Church 420907795048 t 0
64 64 9142359 420907795048 d d 1 1 98 criticism interpretation etc bible tbible and its interpreter 7 R h023468 Criticism, interpretation, etc Bible 420907795048 t 0
65 65 9142360 420907795048 d d 0 0 98 catholic church infallibility tbible and its interpreter 6 R h023468   420907795048 t 0
66 66 9142361 420907795048 d d 1 0 98 bible criticism interpretation etc tbible and its interpreter 7 R h023468   420907795048 t 0
67 67 9142387 420907795051 d d 0 0 105 referendum tinitiative and referendum in switzerland a memorial relative to the initiative and referendum in switzerland 6 R 023468   420907795051 t 0
68 68 9142395 420907795052 d d 2 0 99 arbitration industrial new zealand tcountry without strikes a visit to the compulsory arbitration court of new zealand 6 R 023468   420907795052 t 0
69 69 9142396 420907795052 d d 1 0 99 labor new zealand tcountry without strikes a visit to the compulsory arbitration court of new zealand 6 R 023468   420907795052 t 0
70 70 9142397 420907795052 d d 2 1 99 new zealand arbitration industrial tcountry without strikes a visit to the compulsory arbitration court of new zealand 6 R 023468 New Zealand Arbitration, Industrial 420907795052 t 0
71 71 9142398 420907795052 d d 1 1 99 new zealand labor tcountry without strikes a visit to the compulsory arbitration court of new zealand 6 R 023468 New Zealand Labor 420907795052 t 0
72 72 9142399 420907795052 d d 0 1 99 new zealand strikes and lockouts tcountry without strikes a visit to the compulsory arbitration court of new zealand 6 R 023468 New Zealand Strikes and lockouts 420907795052 t 0
73 73 9142400 420907795052 d d 0 0 99 strikes and lockouts new zealand tcountry without strikes a visit to the compulsory arbitration court of new zealand 6 R 023468   420907795052 t 0
74 74 9142411 420907795053 d d 0 0 110 parliamentary practice tnew parliamentary manual a guide for deliberative bodies and a text book for high schools and colleges 6 R 023468   420907795053 t 0
75 75 9142418 420907795054 d d 1 0 100 spiritual life tdiscovery of a lost trail 6 R 023468   420907795054 t 0
76 76 9142419 420907795054 d d 0 0 100 conduct of life tdiscovery of a lost trail 6 R 023468   420907795054 t 0
77 77 9142429 420907795055 d d 1 0 112 parliamentary practice tparliamentary law method of transacting business in deliberative assemblies uses of the various motions method of conducting 6 R 023468   420907795055 t 0
78 78 9142430 420907795055 d d 0 0 112 legislation tparliamentary law method of transacting business in deliberative assemblies uses of the various motions method of conducting 6 R 023468   420907795055 t 0
79 79 9142449 420907795057 d d 0 0 114 voyages around the world treisetagebuch eines philosophen 6 R 023468   420907795057 t 0
80 80 9142456 420907795058 d d 0 0 102 african americans tfuture of the american negro 6 R 023468   420907795058 t 0
81 81 9142481 420907795060 d d 0 0 101 sports dictionaries tencyclopedia of physical education fitness and sports 6 R 023468   420907795060 t 0
82 82 9142482 420907795060 d d 1 0 101 physical education and training dictionaries tencyclopedia of physical education fitness and sports 6 R 023468   420907795060 t 0
83 83 9142489 420907795062 d d 0 0 104 united states politics and government thistory of american political theories 6 R 023468   420907795062 t 0
84 84 9142498 420907795063 d d 0 0 119 holy spirit twork of the holy spirit 6 R 023468   420907795063 t 0
85 85 9142516 420907795065 d d 0 0 116 women conduct of life ttalks with barbara being an informal and experimental discussion from the point of view of a young woman of to morrow of cert 6 R 023468   420907795065 t 0
86 86 9142517 420907795065 d d 0 1 116 conduct of life women ttalks with barbara being an informal and experimental discussion from the point of view of a young woman of to morrow of cert 6 R 023468 Conduct of life Women 420907795065 t 0
87 87 9142524 420907795067 d d 0 0 100 wealth tdistribution of wealth a theory of wages interest and profits 6 R 023468   420907795067 t 0
88 88 9142532 420907795066 d d 0 0 121 parliamentary practice tyour rights as a member with special reference to the legal contract between a member and his organization 6 R 023468   420907795066 t 0
89 89 9142543 420907795069 d d 0 0 112 parliamentary practice tparliamentary usage a manual of parliamentary law and practice designed for the use of societies literary social musical phil 6 R 023468   420907795069 t 0
90 90 9142553 420907795068 d d 0 0 116 sabbath tthree prophetic days or sunday the christians sabbath proving that sunday is the christians rest day 6 R 023468   420907795068 t 0
91 91 9142562 420907795071 d d 0 1 104 rules and practice ohio general assembly thughes american parliamentary guide 6 R h023468 Rules and practice Ohio General Assembly 420907795071 t 0
92 92 9142563 420907795071 d d 1 0 104 parliamentary practice united states thughes american parliamentary guide 6 R 023468   420907795071 t 0
93 93 9142564 420907795071 d d 0 0 104 ohio general assembly rules and practice thughes american parliamentary guide 6 R h023468   420907795071 t 0
94 94 9142575 420907795070 d d 1 0 112 shorthand tphonography for schools and colleges a course of lessons in the benn pitman system 6 R 023468   420907795070 t 0
95 95 9142581 420907795072 d d 0 1 104 rules and practice ohio general assembly thughes american parliamentary guide technique of lawmaking 6 R h023468 Rules and practice Ohio General Assembly 420907795072 t 0
96 96 9142582 420907795072 d d 1 0 104 parliamentary practice united states thughes american parliamentary guide technique of lawmaking 6 R 023468   420907795072 t 0
97 97 9142583 420907795072 d d 0 0 104 ohio general assembly rules and practice thughes american parliamentary guide technique of lawmaking 6 R h023468   420907795072 t 0
98 98 9142592 420907795073 d d 0 0 98 property insurance united states periodicals tbests insurance reports property casualty 6 R 023468   420907795073 t 0
99 99 9142593 420907795073 d d 7 1 98 canada casualty insurance periodicals tbests insurance reports property casualty 6 R 023468 Canada Casualty insurance Periodicals 420907795073 t 0
100 100 9142594 420907795073 d d 5 1 98 canada fire insurance periodicals tbests insurance reports property casualty 6 R 023468 Canada Fire insurance Periodicals 420907795073 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);