fairground street bridge and confederate avenue brick arch bridge were both built in which county?
warren
col : name | built | listed | location | county | type row 1 : abiaca creek bridge | 1930 | 2004-03-22 | vaiden\n33°19′57′′n 89° | carroll |  row 2 : bayou pierre bridge | ca. 1920 | 2005-06-10 | carpenter\n32°0′10′′n 90°41′23 | copiah |  row 3 : bayou pierre bridge | ca. 1900, 1940 | 2005-06-10 | carpenter\n32°0′10′′n 90°41′23 | copiah |  row 4 : big black river railroad bridge | 1917 | 1988-11-16 | bovina, edwards\n32°20′49′′n | hinds, warren | open-spandrel arch row 5 : byram bridge | ca. 1905 | 1979-05-23 | bryam, frenchs store\n32°10′35′′ | hinds, rankin | twin-tower swinging sus. br. row 6 : chunky river bridge | 1911 | 2004-03-22 | chunky\n32°19′16′′n 88° | newton |  row 7 : columbus bridge | 1925–1927 | 1988-11-16 | columbus\n33°29′37′′n 88°26′ | lowndes | warren truss;swing truss row 8 : confederate avenue brick arch bridge | 1935 | 1988-11-16 | vicksburg\n32°19′44′′n 90°52 | warren | brick arch row 9 : coon box fork bridge | 1919 | 1979-05-23 | coon box\n31°47′25′′n 91° | jefferson | twin-tower swng. susp. brdg. row 10 : eddiceton bridge | 1909 | 1988-11-16 | eddiceton\n31°29′33′′n 90 | franklin | pratt truss;camelback trus row 11 : enterprise bridge | ca. 1925, ca. 1935 | 1988-11-16 | enterprise\n32°10′33′′n 88°49′ | clarke | warren polygonal pony truss row 12 : fairchild's creek bridge | 1930 | 2005-06-08 | natchez\n31°43′31′′n 91°18 | adams |  row 13 : fairground street bridge | 1895 | 1988-11-16 | vicksburg\n32°20′16′′n 90°53 | warren | pratt through truss row 14 : gatesville bridge | 1908 | 1988-11-16 | gatesville, pearl\n31°59′46′′n 90° | copiah, simpson | pennsylvania through truss row 15 : r.h. henry bridge | 1929 | 2005-06-08 | edwards\n32°20′51′′n 90°41′ | hinds |  row 16 : lucien bridge | 1938 | 2005-06-16 | mccall creek\n31°30′40′′n 90°39 | franklin |  row 17 : mahned bridge | 1903 | 1997-11-24 | new augusta\n31°13′28′′n 89° | perry | pratt through truss row 18 : mississippi river bridge | 1928–1930 | 1989-02-14 | vicksburg\n32°18′54′′n 90°54 | warren | cantilevered truss span row 19 : motley slough bridge | 1920 | 1988-11-16 | columbus\n33°26′21′′n 88°31′ | lowndes | pratt pony truss row 20 : old hill place bridge | ca. 1920 | 1979-05-23 | fayette\n31°40′9′′n 91° | jefferson | twin-tower swng. susp. brdg row 21 : pearl river bridge on mississippi highway 28 | 1940 | 2005-06-10 | georgetown\n31°52′31′′n 90°8′17 | copiah |  row 22 : running water creek bridge | 1928 | 1988-11-16 | shuqualak\n33°1′5′′n 88° | noxubee | pratt half-hip pony truss row 23 : shubuta bridge | 1919 | 1988-11-16 | shubuta\n31°51′25′′n 88° | clarke | camelback through truss
fairground street bridge and confederate avenue brick arch bridge were both built in which county?
Name Built Listed Location County Type
Abiaca Creek Bridge 1930 2004-03-22 Vaiden\n33°19′57″N 89°56′57″W﻿ / ﻿33.33250°N 89.94917°W Carroll
Bahala Creek Bridge 1909 1988-11-16 Oma\n31°42′17″N 90°12′0″W﻿ / ﻿31.70472°N 90.20000°W Lawrence Pratt through truss
Bayou Pierre Bridge ca. 1920 2005-06-10 Carpenter\n32°0′10″N 90°41′23″W﻿ / ﻿32.00278°N 90.68972°W Copiah
Bayou Pierre Bridge ca. 1900, 1940 2005-06-10 Carpenter\n32°0′10″N 90°41′23″W﻿ / ﻿32.00278°N 90.68972°W Copiah
Big Black River Railroad Bridge 1917 1988-11-16 Bovina, Edwards\n32°20′49″N 90°42′17″W﻿ / ﻿32.34694°N 90.70472°W Hinds, Warren Open-spandrel arch
Byram Bridge ca. 1905 1979-05-23 Bryam, Frenchs Store\n32°10′35″N 90°14′37″W﻿ / ﻿32.17639°N 90.24361°W Hinds, Rankin Twin-tower swinging sus. br.
Chunky River Bridge 1911 2004-03-22 Chunky\n32°19′16″N 88°55′54″W﻿ / ﻿32.32111°N 88.93167°W Newton
Columbus Bridge 1925–1927 1988-11-16 Columbus\n33°29′37″N 88°26′3″W﻿ / ﻿33.49361°N 88.43417°W Lowndes Warren truss;Swing truss
Confederate Avenue Brick Arch Bridge 1935 1988-11-16 Vicksburg\n32°19′44″N 90°52′31″W﻿ / ﻿32.32889°N 90.87528°W Warren Brick arch
Coon Box Fork Bridge 1919 1979-05-23 Coon Box\n31°47′25″N 91°5′37″W﻿ / ﻿31.79028°N 91.09361°W Jefferson Twin-tower Swng. Susp. Brdg.
Eddiceton Bridge 1909 1988-11-16 Eddiceton\n31°29′33″N 90°47′21″W﻿ / ﻿31.49250°N 90.78917°W Franklin Pratt truss;Camelback truss
Enterprise Bridge ca. 1925, ca. 1935 1988-11-16 Enterprise\n32°10′33″N 88°49′11″W﻿ / ﻿32.17583°N 88.81972°W Clarke Warren polygonal pony truss
Fairchild's Creek Bridge 1930 2005-06-08 Natchez\n31°43′31″N 91°18′49″W﻿ / ﻿31.72528°N 91.31361°W Adams
Fairground Street Bridge 1895 1988-11-16 Vicksburg\n32°20′16″N 90°53′25″W﻿ / ﻿32.33778°N 90.89028°W Warren Pratt through truss
Gatesville Bridge 1908 1988-11-16 Gatesville, Pearl\n31°59′46″N 90°13′26″W﻿ / ﻿31.99611°N 90.22389°W Copiah, Simpson Pennsylvania through truss
R.H. Henry Bridge 1929 2005-06-08 Edwards\n32°20′51″N 90°41′49″W﻿ / ﻿32.34750°N 90.69694°W Hinds
Highway 11 Bridge over Chunky River 1926 1988-11-16 Enterprise\n32°11′32″N 88°49′30″W﻿ / ﻿32.19222°N 88.82500°W Clarke Parker through truss
Homochitto River Bridge 1909 1988-11-16 Hazelhurst\n31°42′48″N 90°40′1″W﻿ / ﻿31.71333°N 90.66694°W Copiah Pratt through truss
Keesler Bridge 1925 1988-11-16 Greenwood\n33°31′18″N 90°11′3″W﻿ / ﻿33.52167°N 90.18417°W Leflore Swing through truss
Lamb-Fish Bridge 1905 1982-05-17 Charleston\n34°1′20″N 90°11′32″W﻿ / ﻿34.02222°N 90.19222°W Tallahatchie Vertical Lift Span
Leaf River Bridge 1907 1988-11-16 McClain\n31°7′39″N 88°49′1″W﻿ / ﻿31.12750°N 88.81694°W Greene Pennsylvania through truss
Lucien Bridge 1938 2005-06-16 McCall Creek\n31°30′40″N 90°39′59″W﻿ / ﻿31.51111°N 90.66639°W Franklin
Mahned Bridge 1903 1997-11-24 New Augusta\n31°13′28″N 89°5′6″W﻿ / ﻿31.22444°N 89.08500°W Perry Pratt Through Truss
Mississippi River Bridge 1928–1930 1989-02-14 Vicksburg\n32°18′54″N 90°54′20″W﻿ / ﻿32.31500°N 90.90556°W Warren Cantilevered truss span
Motley Slough Bridge 1920 1988-11-16 Columbus\n33°26′21″N 88°31′8″W﻿ / ﻿33.43917°N 88.51889°W Lowndes Pratt pony truss
Old Hill Place Bridge ca. 1920 1979-05-23 Fayette\n31°40′9″N 91°10′52″W﻿ / ﻿31.66917°N 91.18111°W Jefferson Twin-tower swng. susp. brdg.
Owens Creek Bridge 1917 1988-11-16 Utica\n32°5′29″N 90°43′45″W﻿ / ﻿32.09139°N 90.72917°W Claiborne Warren pony truss
Pearl River Bridge on Mississippi Highway 28 1940 2005-06-10 Georgetown\n31°52′31″N 90°8′17″W﻿ / ﻿31.87528°N 90.13806°W Copiah
Running Water Creek Bridge 1928 1988-11-16 Shuqualak\n33°1′5″N 88°36′50″W﻿ / ﻿33.01806°N 88.61389°W Noxubee Pratt half-hip pony truss
Shubuta Bridge 1919 1988-11-16 Shubuta\n31°51′25″N 88°41′12″W﻿ / ﻿31.85694°N 88.68667°W Clarke Camelback through truss
Stuckey's Bridge 1901 1988-11-16 Meridian\n32°15′20″N 88°51′19″W﻿ / ﻿32.25556°N 88.85528°W Lauderdale Stearns through truss
Tibbee Bridge 1896 1988-11-16 West Point\n33°32′17″N 88°38′0″W﻿ / ﻿33.53806°N 88.63333°W Clay Pratt through truss
Valley of the Moon Bridge ca. 1925, ca. 1930 2005-06-08 Port Gibson\n32°1′3″N 90°52′37″W﻿ / ﻿32.01750°N 90.87694°W Claiborne
Waverly Bridge 1914 1989-03-20 Columbus, Waverly\n33°33′54″N 88°29′48″W﻿ / ﻿33.56500°N 88.49667°W Clay, Lowndes Swinging through truss
Widow's Creek Bridge 1917 1988-11-16 Port Gibson\n31°56′30″N 91°3′3″W﻿ / ﻿31.94167°N 91.05083°W Claiborne Pratt half-hip pony truss
Woodrow Wilson Bridge 1925 1988-11-16 Jackson\n32°17′22″N 90°10′44″W﻿ / ﻿32.28944°N 90.17889°W Hinds, Rankin Open-spandrel concrete arch
Woodburn Bridge ca. 1916 1988-11-16 Indianola\n33°23′15″N 90°42′21″W﻿ / ﻿33.38750°N 90.70583°W Sunflower Pratt truss;Swing truss
Yellow Creek Bridge 1910 1988-11-16 Waynesboro\n31°41′49″N 88°40′13″W﻿ / ﻿31.69694°N 88.67028°W Wayne Pratt pony truss
Youngblood Bridge 1900, 1915 1979-05-23 Union Church\n31°38′0″N 90°48′51″W﻿ / ﻿31.63333°N 90.81417°W Jefferson Twin-tower swng. susp. brdg.
Confederate Avenue Steel Arch Bridge 1903 removed 2002-12-16 Vicksburg Warren Steel deck arch
Hickahala Creek Bridge 1926 removed 1996-03-15 Senatobia Tate Warren pony truss
Rockport Bridge 1910 removed 1999-12-15 Georgetown, Pinola Copiah, Simpson Pennsylvania through truss
Waynesboro Bridge 1910 removed 2004-04-07 Waynesboro Wayne Pratt through truss
Warren