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

2,976 rows

View and edit SQL

Link rowid ▼ location_id name iii_language_id
1 884 Forest Park Teen Audiobooks 1
2 2177 Walnut Hills Television DVDs 1
3 1683 Northside Juvenile New Release DVDs 1
4 2338 Wyoming Foreign Films 1
5 616 Corryville Cleanup 1
6 436 Cheviot Juvenile New Release DVDs 1
7 2771 Salem Public Library 1
8 1162 Loveland Adult Audiobooks 1
9 2340 Wyoming Television DVDs 1
10 2772 Alexandria Public Library 1
11 2339 Wyoming New Release DVDs 1
12 2474 Wyoming On Order Juvenile 1
13 672 Covedale Cleanup 1
14 1251 Madeira Juvenile New Release DVDs 1
15 1557 Mt Washington Adult Nonfiction 1
16 1702 Northside Cleanup 1
17 331 Blue Ash Juvenile Graphic Novels 1
18 2369 Wyoming Juvenile Nonfiction 1
19 1661 Northside Television DVDs 1
20 2773 Bexley Public Library 1
21 1944 Price Hill Cleanup 1
22 2774 Columbus Metropolitan Library 1
23 2776 Grandview Heights Public Library 1
24 1660 Northside New Release DVDs 1
25 943 Green Township Teen Magazines 1
26 83 Reading Pickup Window 1
27 1249 Madeira Juvenile Cassettes 1
28 1248 Madeira Juvenile CD-ROMs 1
29 403 Cheviot Adult Audiobooks 1
30 2328 Westwood Cleanup 1
31 2787 Main - 2nd Floor - Tech Center - Technology Dispenser 1
32 434 Cheviot Juvenile Cassettes 1
33 2050 St Bernard Cleanup 1
34 2788 Carnegie Center Columbia Tusculum Laptop Dispenser 1
35 1686 Northside Easy Readers 1
36 1992 Reading Teen 1
37 1116 Hyde Park New Release DVDs 1
38 2790 Clark County Public Library 1
39 430 Cheviot Board Books 1
40 2791 North Central Technology Dispenser 1
41 431 Cheviot Big Books 1
42 989 Greenhills Juvenile VHS 1
43 1117 Hyde Park Television DVDs 1
44 432 Cheviot Juvenile Biographies 1
45 988 Greenhills Juvenile Reference 1
46 2157 Symmes Township Teen Magazines 1
47 1659 Northside Foreign Films 1
48 1658 Northside Documentaries 1
49 1657 Northside Anime DVD 1
50 1655 Northside CD-ROMs 1
51 120 Main - 2nd Floor - TeenSpot - Graphic Novels 1
52 2171 Walnut Hills CD-ROMs 1
53 1688 Northside Juvenile Graphic Novels 1
54 1246 Madeira Juvenile Biographies 1
55 2370 Wyoming Juvenile Playaways 1
56 2793 Delaware County DL 1
57 1245 Madeira Big Books 1
58 303 Blue Ash Television DVDs 1
59 429 Cheviot Juvenile Audiobooks 1
60 1244 Madeira Board Books 1
61 949 Greenhills Adult Audiobooks 1
62 2174 Walnut Hills Documentaries 1
63 2173 Walnut Hills Anime DVD 1
64 2371 Wyoming Juvenile Pop-up Books 1
65 1946 Reading Adult 1
66 1110 Hyde Park CD-ROMs 1
67 301 Blue Ash Foreign Films 1
68 1111 Hyde Park Cassettes 1
69 1098 Harrison Teen Audiobooks 1
70 2175 Walnut Hills Foreign Films 1
71 300 Blue Ash Documentaries 1
72 1972 Reading Juvenile 1
73 1113 Hyde Park Anime DVD 1
74 2748 Main - 1st Floor - Children's Library - New Arrivals 1
75 982 Greenhills Juvenile Fiction 1
76 302 Blue Ash New Release DVDs 1
77 1114 Hyde Park Documentaries 1
78 1115 Hyde Park Foreign Films 1
79 722 Deer Park Teen Graphic Novels 1
80 2176 Walnut Hills New Release DVDs 1
81 977 Greenhills Juvenile DVDs 1
82 975 Greenhills Juvenile Compact Discs 1
83 1255 Madeira Juvenile Fiction 1
84 1537 Mt Healthy Teen Playaways 1
85 972 Greenhills Juvenile Audiobooks 1
86 2786 Mt Healthy Technology Dispenser 1
87 1261 Madeira Juvenile Reference 1
88 2469 Symmes Township On Order Teen 1
89 864 Forest Park Juvenile Audiobooks 1
90 945 Green Township Teen Playaways 1
91 1171 Loveland New Release DVDs 1
92 1409 Miami Township Juvenile DVDs 1
93 1407 Miami Township Juvenile Compact Discs 1
94 1247 Madeira Juvenile Compact Discs 1
95 1414 Miami Township Juvenile Fiction 1
96 1172 Loveland Television DVDs 1
97 1250 Madeira Juvenile DVDs 1
98 973 Greenhills Board Books 1
99 1170 Loveland Foreign Films 1
100 1676 Northside Juvenile Audiobooks 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE location_name (
	location_id INTEGER, 
	name TEXT, 
	iii_language_id INTEGER
);
CREATE INDEX fk506824d5399f0cbb ON location_name (location_id);
CREATE INDEX fk506824d58eaffe82 ON location_name (iii_language_id);
CREATE UNIQUE INDEX location_name_pkey ON location_name (location_id, iii_language_id);