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) "" }
Database: media
SQL: select * from cities where CityName = 'HARTFORD' and State = 'CT'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const12Using where


Number of rows returned = 1
Start: 1754167308.4672
End: 1754167308.4674
Elapsed time: 0.1600 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
2895CTHartford034013973941.76255-72.688587860010002895121578937000-5-1

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "06106" ["zip3"]=> string(3) "061" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(8) "HARTFORD" ["zipstate"]=> string(2) "CT" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "41.76" ["iplongitude"]=> string(6) "-72.68" ["ziplocation"]=> string(17) "NA-US-CT-HARTFORD" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "15185" ["zippopulation"]=> string(5) "24425" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "061" ["zipcity"]=> string(8) "HARTFORD" ["zipstate"]=> string(2) "CT" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "2895" ["State"]=> string(2) "CT" ["CityName"]=> string(8) "Hartford" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "340" ["Population"]=> string(6) "139739" ["Latitude"]=> string(8) "41.76255" ["Longitude"]=> string(10) "-72.688587" ["PrimaryAC"]=> string(3) "860" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "2895" ["Population2000"]=> string(6) "121578" ["FIPS"]=> string(6) "937000" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
17 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
06111NEWINGTONCT27167Newington
06106HARTFORDCT24425Hartford
06109WETHERSFIELDCT23881Wethersfield
06118EAST HARTFORDCT22839East Hartford
06114HARTFORDCT18603Hartford
06108EAST HARTFORDCT18429East Hartford
06107WEST HARTFORDCT17031West Hartford50
06112HARTFORDCT14548Hartford
06117WEST HARTFORDCT13211West Hartford50
06105HARTFORDCT12164Hartford
zipcodezipcityzipstatezippopulationcitynameDMAID
06119WEST HARTFORDCT12133West Hartford50
06110WEST HARTFORDCT10680West Hartford50
06120HARTFORDCT6580Hartford
06103HARTFORDCT1087Hartford
06101HARTFORDCT0Hartford
06152HARTFORDCT0Hartford
06199HARTFORDCT0Hartford
Station W231CZ-FX
City HARTFORD-CT

City , is located in DMAID: