location_view (view)
2,921 rows
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 - A 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 South - 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 |
Advanced export
JSON shape: default, array, newline-delimited
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;