array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9998" ["dmaType"]=> NULL ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(7) "Unrated" ["Population25up"]=> string(1) "0" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(0) "" }
*** city ***************
array(22) { ["id"]=> string(5) "80401" ["State"]=> string(2) "TN" ["CityName"]=> string(9) "Hermitage" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> NULL ["Population"]=> NULL ["Latitude"]=> NULL ["Longitude"]=> NULL ["PrimaryAC"]=> NULL ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> NULL ["ISPCount"]=> NULL ["CovadDSL"]=> NULL ["VerizonDSL"]=> NULL ["allegiance"]=> NULL ["SBC"]=> NULL ["RateCenterCityid"]=> NULL ["Population2000"]=> NULL ["FIPS"]=> NULL ["cTZoffset"]=> NULL ["DST"]=> string(1) "0" ["DMAID"]=> NULL }
****** zip code ************
array(13) { ["zipcode"]=> string(5) "37076" ["zip3"]=> string(3) "370" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "HERMITAGE" ["zipstate"]=> string(2) "TN" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "36.13" ["iplongitude"]=> string(6) "-86.58" ["ziplocation"]=> string(18) "NA-US-TN-HERMITAGE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "17303" ["zippopulation"]=> string(5) "28410" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "370" ["zipcity"]=> string(11) "CLARKSVILLE" ["zipstate"]=> string(2) "TN" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "18517" ["State"]=> string(2) "TN" ["CityName"]=> string(11) "Clarksville" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "205" ["Population"]=> string(5) "75494" ["Latitude"]=> string(9) "36.559383" ["Longitude"]=> string(10) "-87.358261" ["PrimaryAC"]=> string(3) "931" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "18517" ["Population2000"]=> string(6) "103455" ["FIPS"]=> string(7) "4715160" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "206" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
19 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
18517TNClarksville02057549436.559383-87.35826193100000185171034554715160-6-1206
7027KYHopkinsville01152980936.854712-87.488872270000007027300892137918-6-1206
35647KYFort Campbell North-101886136.653631-87.45971600000143382128486-6-1206
18498TNBrentwood001639235.998194-86.79261961500000234454708280-1206
7104KYMurray01461443936.609494-88.315656270000007104149502154642-6-1206
18631TNLewisburg-167987935.449034-86.7931129310000018631104134741860-1206
18623TNLafayette-10364136.525595-86.026246615000001862338854740160-1206
18509TNCenterville-156361635.788218-87.45589931000001850937934712420-1206
7114KYOak Grove-150286336.658374-87.41956527000000711470642157090-6-1206
18480TNAshland City063255236.267954-87.054877615000001848036414702180-1206
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
18507TNCarthage-196238636.25496-85.949211615000001850722514711280-1206
7095KYMorgantown-163228437.219465-86.69251327000000709525442153490-6-1206
18596TNHartsville-176218836.391617-86.160172615000001859623954732720-1206
6910KYCadiz-173214836.867781-87.81737427000000691023732111692-6-1206
6962KYElkton03178936.808926-87.15637727000000696219842124400-6-1206
18618TNKingston Springs063152936.087195-87.108267615000001861827734739660-1206
18634TNLinden-14109935.612168-87.841601931000001863410154742720-1206
18531TNCornersville-1068335.358152-86.84168161500000185319624717180-1206
79862KYFort Campbell-10206
**** cities in zip3 **************
64 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
37013ANTIOCHTN59428
37042CLARKSVILLETN51009Clarksville206
37075HENDERSONVILLETN49659Hendersonville44
37027BRENTWOODTN45316Brentwood206
37064FRANKLINTN40050Franklin44
37066GALLATINTN34739Gallatin44
37040CLARKSVILLETN33347Clarksville206
37043CLARKSVILLETN33098Clarksville206
37087LEBANONTN31942Lebanon44
37076HERMITAGETN28410Hermitage
zipcodezipcityzipstatezippopulationcitynameDMAID
37086LA VERGNETN25682La Vergne44
37072GOODLETTSVILLETN24301Goodlettsville44
37055DICKSONTN20425Dickson44
37067FRANKLINTN19811Franklin44
37091LEWISBURGTN16740Lewisburg206
37069FRANKLINTN16667Franklin44
37015ASHLAND CITYTN14315Ashland City206
37073GREENBRIERTN11103Greenbrier
37090LEBANONTN11014Lebanon44
37083LAFAYETTETN10331Lafayette206
zipcodezipcityzipstatezippopulationcitynameDMAID
37062FAIRVIEWTN8951Fairview
37080JOELTONTN6307
37033CENTERVILLETN5682Centerville206
37082KINGSTON SPRINGSTN5512Kingston Springs206
37034CHAPEL HILLTN5501Chapel Hill
37037CHRISTIANATN5501
37074HARTSVILLETN5419Hartsville206
37030CARTHAGETN5410Carthage206
37058DOVERTN5399Dover
37048COTTONTOWNTN4959
zipcodezipcityzipstatezippopulationcitynameDMAID
37025BON AQUATN4934
37036CHARLOTTETN4605Charlotte
37029BURNSTN4593Burns
37022BETHPAGETN4504Bethpage
37096LINDENTN4191Linden206
37098LYLESTN4148Lyles
37020BELL BUCKLETN3945Bell Buckle
37010ADAMSTN3891Adams
37061ERINTN3811Erin
37032CEDAR HILLTN3691Cedar Hill
zipcodezipcityzipstatezippopulationcitynameDMAID
37085LASCASSASTN3371
37031CASTALIAN SPRINGSTN3190
37046COLLEGE GROVETN3110College Grove
37035CHAPMANSBOROTN3020
37051CUMBERLAND FURNACETN2833
37049CROSS PLAINSTN2827Cross Plains
37052CUNNINGHAMTN2132Cunningham
37079INDIAN MOUNDTN2081
37047CORNERSVILLETN1948Cornersville206
37060EAGLEVILLETN1948Eagleville
zipcodezipcityzipstatezippopulationcitynameDMAID
37026BRADYVILLETN1762
37012ALEXANDRIATN1740Alexandria
37018BEECHGROVETN1590Beechgrove
37097LOBELVILLETN1559Lobelville
37095LIBERTYTN1504Liberty
37014ARRINGTONTN1469
37023BIG ROCKTN1370
37050CUMBERLAND CITYTN1329Cumberland City
37059DOWELLTOWNTN1242Dowelltown
37019BELFASTTN724Belfast
zipcodezipcityzipstatezippopulationcitynameDMAID
37016AUBURNTOWNTN714Auburntown
37057DIXON SPRINGSTN641Dixon Springs
37078HURRICANE MILLSTN578
37028BUMPUS MILLSTN517
Station W279CH-FX
City Hermitage-TN

City Hermitage, TN is located in DMAID: