location_view (view)

2,913 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_public, branch_code_num, branch_name

location_id location_code is_public is_requestable branch_code_num location_name items branch_name
1 1cj 1 1 1 Main Children's Library view items Main Library
2 1cjau 0 1 1 Main - 1st Floor South - Juvenile Audio view items Main Library
4 1cjbg 0 1 1 Main - 1st Floor - Children's Library - Big Books view items Main Library
5 1cjeb 0 1 1 Main - 1st Floor South - Juvenile Easy Books view items Main Library
7 1cjfl 0 1 1 DO NOT USE view items Main Library
8 1cjho 0 1 1 Main - 1st Floor South - Juvenile Holidays view items Main Library
9 1cjnf 0 1 1 Main - 1st Floor South - Juvenile Nonfiction view items Main Library
10 1cjoo 0 1 1 Main - 1st Floor - Children's Library - On Order view items Main Library
12 1cjpu 0 1 1 Main - 1st Floor South - Pop-up Books view items Main Library
13 1cjrd 0 1 1 Main - 1st Floor - Children's Library - Desk Reference view items Main Library
14 1cjrf 0 1 1 Main - 1st Floor - Children's Library - Floor Reference view items Main Library
15 1cjro 0 1 1 Main - 1st Floor - Children's Library - Office Reference view items Main Library
16 1cjsb 0 1 1 Main - 1st Floor - Children's Library - Series Books view items Main Library
17 1cjsf 0 1 1 Main - 1st Floor - Children's Library - Science Fair view items Main Library
18 1fa 1 1 1 Main Popular Library Stacks view items Main Library
19 1hj 1 1 1 Main - 1st Floor - Adult Learning and Literacies - Juvenile view items Main Library
20 1hja 0 1 1 DO NOT USE view items Main Library
21 1hjoo 0 1 1 Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile view items Main Library
22 1hjrf 0 1 1 Main - 1st Floor - Adult Learning and Literacies - Juvenile Floor Reference view items Main Library
23 1lj 1 1 1 Main Children's Library Stacks view items Main Library
24 1pa 1 1 1 Main Popular Library Adult view items Main Library
25 1paa 0 1 1 Main - 1st Floor South - Contemporary view items Main Library
27 avjpl 0 1 3 DO NOT USE view items Avondale
28 1paal 0 1 1 Main - 1st Floor South - Record Albums view items Main Library
29 mdjk 0 1 22 Madisonville Juvenile Kits view items Madisonville
30 1paar 0 1 1 Main - 1st Floor South - New Arrivals view items Main Library
31 prjk 0 1 34 Price Hill Juvenile Kits view items Price Hill
32 1fabc 0 1 1 Main Popular Library Stacks Book Club Kits view items Main Library
33 osjf 0 1 32 Outreach Services Juvenile Fiction view items Outreach Services
34 osjnf 0 1 32 Outreach Services Juvenile Nonfiction view items Outreach Services
35 osaf 0 1 32 Outreach Services Adult Fiction view items Outreach Services
36 ostnf 0 1 32 Outreach Services Teen Nonfiction view items Outreach Services
37 osamg 0 1 32 Outreach Services Adult Magazines view items Outreach Services
38 osjmg 0 1 32 Outreach Services Juvenile Magazines view items Outreach Services
39 osaml 0 1 32 Outreach Services Adult Large Print Magazines view items Outreach Services
40 1pacl 0 1 1 Main - 1st Floor South - Local Music view items Main Library
41 9smfp 0 1 1 Stow-Munroe Public Library view items Main Library
42 1pacn 0 1 1 DO NOT USE view items Main Library
43 1paco 0 1 1 Main - 1st Floor - Popular Library - Opera CDs view items Main Library
44 3cac 0 1 1 Main - 3rd floor - Cincinnati Room - Secured - Ask Staff view items Main Library
45 eptpl 0 1 13 DO NOT USE view items Elmwood Place
46 1ljsf 0 1 1 Main - Children's Library Stacks - Science Fair view items Main Library
47 osak 0 1 32 Outreach Services Adult Kit view items Outreach Services
48 osjk 0 1 32 Outreach Services Juvenile Kit view items Outreach Services
49 ostab 0 1 32 Outreach Services Teen Audiobooks view items Outreach Services
50 1pacx 0 1 1 Main - 1st Floor - Popular Library - Box Set CDs view items Main Library
52 1pada 0 1 1 Main - 1st Floor - Popular Library - Anime DVD view items Main Library
53 1padf 0 1 1 DO NOT USE view items Main Library
54 1padm 0 1 1 Main - 1st Floor South - DVDs view items Main Library
55 1padn 0 1 1 Main - 1st Floor South - New Release DVDs view items Main Library
58 1padt 0 1 1 Main - 1st Floor - Popular Library - Television DVDs view items Main Library
60 1paes 0 1 1 Main - 1st Floor - Popular Library - English as 2nd Language view items Main Library
61 1pafc 0 1 1 Main - 1st Floor South - Classic Novels view items Main Library
62 1paff 0 1 1 DO NOT USE view items Main Library
63 1pafh 0 1 1 Main - 1st Floor South - Historical Fiction view items Main Library
64 1pafi 0 1 1 Main - 1st Floor South - Inspirational Fiction view items Main Library
65 1pafl 0 1 1 DO NOT USE view items Main Library
66 1pafm 0 1 1 Main - 1st Floor South - Mysteries / Suspense view items Main Library
68 1pafr 0 1 1 Main - 1st Floor South - Romance view items Main Library
69 1pafs 0 1 1 Main - 1st Floor South - Sci-Fi view items Main Library
70 1pafw 0 1 1 Main - 1st Floor South - Western view items Main Library
71 1pagn 0 1 1 DO NOT USE view items Main Library
72 1paho 0 1 1 Main - 1st Floor South - Holiday view items Main Library
73 9cler 0 1 1 Clermont County PL view items Main Library
74 au3bg 0 1 1 ~Antioch University view items Main Library
75 y0603 0 1 1 ~Antioch College Lib view items Main Library
76 1panf 0 1 1 Main - 1st Floor - Popular Library - Nonfiction view items Main Library
77 1panr 0 1 1 Main - 1st Floor - Popular Library - Adult New Reader view items Main Library
78 1paod 0 1 1 Main - 1st Floor - Popular Library - Display view items Main Library
79 1paof 0 1 1 Main - 1st Floor - Popular Library - Office - Ask Staff view items Main Library
80 1paoo 0 1 1 Main - 1st Floor - Popular Library - On Order view items Main Library
81 y0604 0 1 1 ~Antioch University Lib view items Main Library
82 1papl 0 1 1 Main - 1st Floor - Popular Library - Playaways view items Main Library
83 rew 0 1 35 Reading Pickup Window view items Reading
84 1parf 0 1 1 Main - 1st Floor - Popular Library - Reference - Ask Staff view items Main Library
85 1paro 0 1 1 Main - 1st Floor - Popular Library - Office Reference view items Main Library
87 1pasp 0 1 1 Main - 1st Floor - Popular Library - Staff Picks view items Main Library
88 1pass 0 1 1 Main - 1st Floor - Popular Library - Short Stories view items Main Library
89 1pavm 0 1 1 Main - 1st Floor - Popular Library - Movie Videos view items Main Library
90 1pj 1 1 1 Main Popular Library Juvenile view items Main Library
91 1pjd 0 1 1 Main - 1st Floor South - Juvenile DVDs view items Main Library
93 1zzzz 0 1 1 Main Cleanup view items Main Library
94 2ea 1 1 1 Main Information & Reference - Education Stacks view items Main Library
95 2ga 1 1 1 Main Information & Reference - Government Stacks view items Main Library
96 2kt 1 1 1 Main Teen Stacks view items Main Library
97 2ma 1 1 1 Main - 2nd Floor - Magazines & Newspapers view items Main Library
99 2maoo 0 1 1 Main - 2nd Floor - Magazines & Newspapers - On Order view items Main Library
100 2na 1 1 1 Main Information & Reference - Magazines Stacks (C) view items Main Library
101 2ra 1 1 1 Main - 2nd Floor South - Non Fiction view items Main Library
102 2rabi 0 1 1 DO NOT USE view items Main Library
103 2rabu 0 1 1 DO NOT USE view items Main Library
104 2raca 0 1 1 DO NOT USE view items Main Library
105 2ragt 0 1 1 Main - 2nd Floor South - Nonprofit Grants Resources view items Main Library
106 2raod 0 1 1 DO NOT USE view items Main Library
107 2raoo 0 1 1 Main - 2nd Floor - Information & Reference - On Order view items Main Library
108 2rar 0 1 1 Main - 2nd Floor South - Non Fiction Reference view items Main Library
109 2rard 0 1 1 Main - 2nd Floor - Information & Reference - Desk Reference view items Main Library
110 2raro 0 1 1 DO NOT USE view items Main Library
111 2sa 1 1 1 Main Science Stacks view items Main Library
112 2tt 1 1 1 Main Teen Spot view items Main Library
113 2ttab 0 1 1 Main - 1st Floor - Popular Library - Teen Audiobooks view items Main Library
114 2ttar 0 1 1 Do Not Use view items Main Library
115 2ttbi 0 1 1 Main - 2nd floor - TeenSpot - Biographies view items Main Library
116 2ttda 0 1 1 Main - 2nd Floor - TeenSpot - Anime view items Main Library
121 2ttmg 0 1 1 Main - 1st Floor South - Teen Magazines view items Main Library
123 2ttod 0 1 1 Main - 2nd Floor - TeenSpot - Display view items Main Library
124 2ttoo 0 1 1 Main - 1st Floor - Popular Library - Teen On Order view items Main Library
126 2ttrd 0 1 1 Main - 2nd Floor - TeenSpot - Desk Reference view items Main Library
127 2ttrf 0 1 1 Main - 2nd Floor - TeenSpot - Floor Reference view items Main Library
128 2ttro 0 1 1 Main - 2nd Floor - TeenSpot - Office Reference view items Main Library
130 2x 1 1 1 Main Tech Center view items Main Library
131 2xrf 0 1 1 Main - 2nd Floor - Tech Center - Floor Reference view items Main Library
132 3aa 1 1 1 Main - 3rd Floor Art Stacks view items Main Library
134 3ca 1 1 1 Main - 3rd Floor - Cincinnati Room - Ask Staff view items Main Library
135 3cacr 0 1 1 Main - 3rd Floor - Cincinnati Room - Desk Reference view items Main Library
136 3caod 0 1 1 Main - 3rd Floor - Cincinnati Room - Display view items Main Library
137 3carv 0 1 1 Main - 3rd Floor - Genealogy & Local History - Cincinnati Rm-River view items Main Library
138 3da 1 1 1 Main Genealogy & Local History view items Main Library
142 3darf 0 1 1 Main - 3rd Floor - Genealogy & Local History - Floor Reference view items Main Library
146 3ea 1 1 1 Main Genealogy & Local History Stacks view items Main Library
147 3eama 0 1 1 Main Genealogy Stacks - Maps view items Main Library
148 3ear 0 1 1 DO NOT USE view items Main Library
149 3ga 1 1 1 DO NOT USE view items Main Library
150 3gaa 0 1 1 DO NOT USE view items Main Library
151 3galh 0 1 1 DO NOT USE view items Main Library
152 3galr 0 1 1 DO NOT USE view items Main Library
153 3gama 0 1 1 DO NOT USE view items Main Library
154 3gaod 0 1 1 Main - 3rd Floor - Genealogy & Local History - Display view items Main Library
155 3gaoo 0 1 1 Main - 3rd Floor - Genealogy & Local History - On Order view items Main Library
156 3gar 0 1 1 DO NOT USE view items Main Library
157 3gara 0 1 1 DO NOT USE view items Main Library
158 3gard 0 1 1 Main - 3rd Floor - Genealogy & Local History - Desk Reference view items Main Library
159 3garo 0 1 1 DO NOT USE view items Main Library
160 3garr 0 1 1 DO NOT USE view items Main Library
162 3ha 1 1 1 Main - Information & Reference - History Stacks view items Main Library
163 3la 1 1 1 Main Literature Stacks view items Main Library
164 3ra 1 1 1 Main - 3rd Floor South view items Main Library
165 4ca 1 1 1 Main Circulation Services view items Main Library
166 4cdd 0 1 1 Main Circulation Services - Document Delivery view items Main Library
167 4da 1 1 1 Main Information & Reference - Documents and Patents view items Main Library
168 4va 1 1 1 Main Virtual Information Center view items Main Library
169 4vaoo 0 1 1 Main Virtual Information Center - On Order view items Main Library
170 5acq 1 1 1 Main Acquisitions view items Main Library
171 5cat 1 1 1 Main Cataloging Services view items Main Library
172 5cld 1 1 1 Main Collection - Development Office - Adult view items Main Library
173 5com 1 1 1 Main Computer Services view items Main Library
174 5dir 1 1 1 Main Director's Office view items Main Library
175 5fa 1 1 1 Main Facilities view items Main Library
176 5hum 1 1 1 Main Human Resources view items Main Library
177 5lib 1 1 1 Main Library Services view items Main Library
178 5mkt 1 1 1 Main Marketing & Progamming view items Main Library
179 5pro 1 1 1 Main Processing Binding view items Main Library
180 5sup 1 1 1 Main Support Services view items Main Library
181 an 0 1 2 Anderson view items Anderson
182 ana 1 1 2 Anderson Adult view items Anderson
183 anaab 0 1 2 Anderson Adult Audiobooks view items Anderson
184 anaar 0 1 2 Anderson New Arrivals view items Anderson
185 anaat 0 1 2 Anderson Adult ATLA view items Anderson
186 anac 0 1 2 Anderson Compact Discs view items Anderson
189 anad 0 1 2 Anderson DVDs view items Anderson
191 anadc 0 1 2 Anderson Documentaries view items Anderson
192 anadf 0 1 2 Anderson World DVDs view items Anderson
193 anadn 0 1 2 Anderson New Release DVDs view items Anderson
194 anadt 0 1 2 Anderson Television DVDs view items Anderson
195 anaf 0 1 2 Anderson Fiction view items Anderson
196 anafl 0 1 2 DO NOT USE view items Anderson
197 anaho 0 1 2 Anderson Holidays view items Anderson
198 anal 0 1 2 Anderson Large Print view items Anderson
199 anamg 0 1 2 Anderson Adult Magazines view items Anderson
200 ananf 0 1 2 Anderson Adult Nonfiction view items Anderson
201 anaoo 0 1 2 Anderson On Order view items Anderson
202 anapl 0 1 2 DO NOT USE view items Anderson
204 anard 0 1 2 Anderson Adult Reference view items Anderson
209 anj 1 1 2 Anderson Juvenile view items Anderson
210 anjab 0 1 2 Anderson Juvenile Audiobooks view items Anderson
211 anjbd 0 1 2 Anderson Board Books view items Anderson
212 anjbg 0 1 2 Anderson Big Books view items Anderson
213 anjbi 0 1 2 Anderson Juvenile Biographies view items Anderson
214 anjc 0 1 2 Anderson Juvenile Compact Discs view items Anderson
215 anjcy 0 1 2 Anderson Juvenile CD-ROM view items Anderson
217 anjd 0 1 2 Anderson Juvenile DVDs view items Anderson
218 anjdn 0 1 2 Anderson Juvenile New Release DVDs view items Anderson
219 anjeb 0 1 2 Anderson Easy Books view items Anderson
220 anjec 0 1 2 Anderson Concepts: ABC, Counting, Colors, etc. view items Anderson
221 anjer 0 1 2 Anderson Easy Readers view items Anderson
222 anjf 0 1 2 Anderson Juvenile Fiction view items Anderson
223 anjgn 0 1 2 Anderson Juvenile Graphic Novels view items Anderson
224 anjmg 0 1 2 Anderson Juvenile Magazines view items Anderson
225 anjnf 0 1 2 Anderson Juvenile Nonfiction view items Anderson
226 anjpl 0 1 2 DO NOT USE view items Anderson
227 anjpu 0 1 2 Anderson Juvenile Pop-up Books view items Anderson
228 anjr 0 1 2 Anderson Juvenile Reference view items Anderson
230 ant 1 1 2 Anderson Teen view items Anderson
231 antab 0 1 2 Anderson Teen Audiobooks view items Anderson
232 antf 0 1 2 Anderson Teen Fiction view items Anderson
233 antgn 0 1 2 Anderson Teen Graphic Novels view items Anderson
234 antmg 0 1 2 Anderson Teen Magazines view items Anderson
235 antnf 0 1 2 Anderson Teen Nonfiction view items Anderson
236 antpl 0 1 2 DO NOT USE view items Anderson
237 anzzz 0 1 2 Anderson Cleanup view items Anderson

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW location_view AS select
  "location".id as location_id,
  "location"."code" as location_code,
  "location".is_public,
  "location".is_requestable,
  branch.code_num as branch_code_num,
  location_name."name" as location_name,
  json_object(
    "href",
    "/current_collection/item?location_code__exact=" || coalesce("location".code, ""),
    "label",
    "view items"
  ) as items,
  branch_name."name" as branch_name
from
  "location"
  join location_name on location_name.location_id = "location".id
  join branch on branch.code_num = location.branch_code_num
  join branch_name on branch_name.branch_id = branch.id;