branch

52 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: address, email_source, email_reply_to, address_latitude, address_longitude

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

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 INDEX [idx_branch_code_num]
    ON [branch] ([code_num]);
CREATE INDEX [idx_branch_id]
    ON [branch] ([id]);