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

3,009 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 1248 Madeira Juvenile CD-ROMs 1
28 403 Cheviot Adult Audiobooks 1
29 2328 Westwood Cleanup 1
30 2787 Main - 2nd Floor - Tech Center - Technology Dispenser 1
31 2050 St Bernard Cleanup 1
32 2788 Carnegie Center Columbia Tusculum Laptop Dispenser 1
33 1686 Northside Easy Readers 1
34 1992 Reading Teen 1
35 1116 Hyde Park New Release DVDs 1
36 2790 Clark County Public Library 1
37 430 Cheviot Board Books 1
38 2791 North Central Technology Dispenser 1
39 431 Cheviot Big Books 1
40 989 Greenhills Juvenile VHS 1
41 1117 Hyde Park Television DVDs 1
42 432 Cheviot Juvenile Biographies 1
43 988 Greenhills Juvenile Reference 1
44 2157 Symmes Township Teen Magazines 1
45 1659 Northside Foreign Films 1
46 1658 Northside Documentaries 1
47 1657 Northside Anime DVD 1
48 1655 Northside CD-ROMs 1
49 2171 Walnut Hills CD-ROMs 1
50 1688 Northside Juvenile Graphic Novels 1
51 1246 Madeira Juvenile Biographies 1
52 2370 Wyoming Juvenile Playaways 1
53 2793 Delaware County DL 1
54 1245 Madeira Big Books 1
55 303 Blue Ash Television DVDs 1
56 429 Cheviot Juvenile Audiobooks 1
57 1244 Madeira Board Books 1
58 949 Greenhills Adult Audiobooks 1
59 2174 Walnut Hills Documentaries 1
60 2173 Walnut Hills Anime DVD 1
61 2371 Wyoming Juvenile Pop-up Books 1
62 1946 Reading Adult 1
63 1110 Hyde Park CD-ROMs 1
64 301 Blue Ash Foreign Films 1
65 1111 Hyde Park Cassettes 1
66 1098 Harrison Teen Audiobooks 1
67 2175 Walnut Hills Foreign Films 1
68 300 Blue Ash Documentaries 1
69 1972 Reading Juvenile 1
70 1113 Hyde Park Anime DVD 1
71 2748 Main - 1st Floor - Children's Library - New Arrivals 1
72 982 Greenhills Juvenile Fiction 1
73 302 Blue Ash New Release DVDs 1
74 1114 Hyde Park Documentaries 1
75 1115 Hyde Park Foreign Films 1
76 722 Deer Park Teen Graphic Novels 1
77 2176 Walnut Hills New Release DVDs 1
78 977 Greenhills Juvenile DVDs 1
79 975 Greenhills Juvenile Compact Discs 1
80 1255 Madeira Juvenile Fiction 1
81 1537 Mt Healthy Teen Playaways 1
82 972 Greenhills Juvenile Audiobooks 1
83 2786 Mt Healthy Technology Dispenser 1
84 1261 Madeira Juvenile Reference 1
85 2469 Symmes Township On Order Teen 1
86 864 Forest Park Juvenile Audiobooks 1
87 945 Green Township Teen Playaways 1
88 1171 Loveland New Release DVDs 1
89 1409 Miami Township Juvenile DVDs 1
90 1407 Miami Township Juvenile Compact Discs 1
91 1247 Madeira Juvenile Compact Discs 1
92 1414 Miami Township Juvenile Fiction 1
93 1172 Loveland Television DVDs 1
94 1250 Madeira Juvenile DVDs 1
95 973 Greenhills Board Books 1
96 1170 Loveland Foreign Films 1
97 1676 Northside Juvenile Audiobooks 1
98 2158 Symmes Township Teen Nonfiction 1
99 2796 Price Hill Technology Dispenser 1
100 2446 Mt Healthy On Order Teen 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);