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

52 rows

View and edit SQL

Link rowid ▼ id address address_latitude address_longitude code_num
1 52   39.1057790 -84.5133140 52
2 50 Main Library$800 Vine Street$Cincinnati, Ohio 45202-2009 39.2305206 -84.3749388 50
3 17 Greenhills Branch$8 Enfield St.$Cincinnati, Ohio 45218 39.2682526 -84.5221859 16
4 49       49
5 44       46
6 45       47
7 46       44
8 47       45
9 48       48
10 3 Avondale Branch$3566 Reading Rd.$Cincinnati, Ohio 45229 39.1466330 -84.4892080 3
11 15 Green Township Branch$6525 Bridgetown Rd.$Cincinnati, Ohio 45248 39.1518620 -84.6622540 15
12 11 Deer Park Branch$3970 E. Galbraith Rd.$Cincinnati, Ohio 45236 39.2086877 -84.4022557 11
13 12 Delhi Township Branch$5095 Foley Rd.$Cincinnati, Ohio 45238 39.1035759 -84.6107980 12
14 13 Elmwood Place Branch$6120 Vine St.$Cincinnati, Ohio 45216 39.1870577 -84.4877710 13
15 14 Forest Park Branch$655 Waycross Road$Cincinnati, Ohio 45240 39.2756830 -84.5002800 14
16 16 Groesbeck Branch$2994 W. Galbraith Rd.$Cincinnati, Ohio 45239 39.2203310 -84.5834370 17
17 18 Hyde Park Branch$2747 Erie Ave.$Cincinnati, Ohio 45208 39.1392578 -84.4411358 19
18 20 Madeira Branch$7200 Miami Ave.$Cincinnati, Ohio 45243 39.1915790 -84.3626240 21
19 22 Mariemont Branch$3810 Pocahontas Ave.$Cincinnati, Ohio 45227 39.1447071 -84.3681905 23
20 23 Madisonville Branch$4830 Whetsel Ave.$Cincinnati, Ohio 45227 39.1592164 -84.3932369 22
21 24 Monfort Heights Branch$3825 West Fork Rd.$Cincinnati, Ohio 45247 39.1886380 -84.6092250 25
22 25 Miami Township Branch$8 North Miami Ave.$Cleves, Ohio 45002 39.1629000 -84.7488050 24
23 7 Clifton Branch$3400 Brookline Ave.$Cincinnati, Ohio 45220 39.1437085 -84.5214016 7
24 1 Main Library$800 Vine Street$Cincinnati, Ohio 45202-2009 39.1050133 -84.5139331 1
25 2 Anderson Branch$7450 State Rd.$Cincinnati, Ohio 45230 39.0847759 -84.3523426 2
26 4 Blue Ash Branch$4911 Cooper Rd.$Cincinnati, Ohio 45242 39.2305206 -84.3749388 4
27 6 Cheviot Branch$3711 Robb Ave.$Cincinnati, Ohio 45211 39.1553204 -84.6196606 6
28 5 Bond Hill Branch$1740 Langdon Farm Road at Jordan Crossing$Cincinnati, Ohio 45237 39.2305206 -84.3749388 5
29 8 College Hill Branch$1400 W. North Bend Rd.$Cincinnati, Ohio 45224 39.2028825 -84.5417593 8
30 32 Price Hill Recreation Center$959 Hawthorne Ave.$Cincinnati, Ohio 45205 39.1099258 -84.5645008 34
31 10 Covedale Branch$4980 Glenway Ave.$Cincinnati, Ohio 45238 39.1210451 -84.6007320 10
32 19 Harrison Branch$10398 New Haven Road$Harrison, Ohio 45030 39.2620320 -84.7875325 18
33 21 Loveland Branch$649 Loveland Madeira Rd.$Loveland, Ohio 45140 39.2628368 -84.2703149 20
34 26 Mt Washington Branch$2049 Beechmont Ave.$Cincinnati, Ohio 45230 39.0912999 -84.3871080 27
35 27 Mt Healthy Branch$7608 Hamilton Ave.$Cincinnati, Ohio 45231 39.2328634 -84.5480661 26
36 28 Northside Branch$4219 Hamilton Ave.$Cincinnati, Ohio 45223 39.1636773 -84.5401430 29
37 30 Oakley Branch$4033 Gilmore Ave.$Cincinnati, Ohio 45209 39.1522070 -84.4306080 31
38 31 Norwood Branch$4325 Montgomery Rd.$Cincinnati, Ohio 45212 39.1565920 -84.4593469 30
39 34 Outreach Services - Main Library$800 Vine Street$Cincinnati, Ohio 45202-2009 39.1057790 -84.5133140 32
40 29 North Central Branch$11109 Hamilton Ave.$Cincinnati, Ohio 45231 39.2812490 -84.5651220 28
41 51 Main Library$800 Vine Street$Cincinnati, Ohio 45202-2009     51
42 35 Pleasant Ridge Branch$6233 Montgomery Rd.$Cincinnati, Ohio 45213 39.1839418 -84.4239532 33
43 36 Symmes Township Branch$11850 Enyart Rd.$Loveland, Ohio 45140 39.2845731 -84.3102289 38
44 39 Sharonville Branch$10980 Thornview Dr.$Cincinnati, Ohio 45241 39.2675440 -84.4040100 37
45 33 Reading Branch$8740 Reading Rd.$Cincinnati, Ohio 45215 39.2234607 -84.4406101 35
46 40 Wyoming Branch$500 Springfield Pike$Cincinnati, Ohio 45215 39.1481840 -84.6004960 42
47 41   39.2275392 -84.4724136 43
48 42 West End Branch$805 Ezzard Charles Dr.$Cincinnati, Ohio 45203 39.1270640 -84.4879005 40
49 43 Westwood Branch$3345 Epworth Ave.$Cincinnati, Ohio 45211 39.1091568 -84.5279639 41
50 37 Walnut Hills Branch$2533 Kemper Lane$Cincinnati, Ohio 45206 39.1057790 -84.5133140 39
51 38 St Bernard Branch$10 McClelland Ave.$Cincinnati, Ohio 45217 39.1680258 -84.4962196 36
52 9 Corryville Branch$2802 Short Vine St.$Cincinnati, Ohio 45219 39.1317127 -84.5091700 9

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE branch (
	id INTEGER, 
	address TEXT, 
	email_source TEXT, 
	email_reply_to TEXT, 
	address_latitude TEXT, 
	address_longitude TEXT, 
	code_num INTEGER
);
CREATE UNIQUE INDEX pk_branch ON branch (id);
CREATE UNIQUE INDEX uniq_branch_code_num ON branch (code_num);