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 = 'HARROGATE' and State = 'TN'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754169082.5598
End: 1754169082.5606
Elapsed time: 0.8349 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('TN','Harrogate',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80037" ["State"]=> string(2) "TN" ["CityName"]=> string(9) "Harrogate" ["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) "37752" ["zip3"]=> string(3) "377" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "HARROGATE" ["zipstate"]=> string(2) "TN" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "36.56" ["iplongitude"]=> string(6) "-83.54" ["ziplocation"]=> string(18) "NA-US-TN-HARROGATE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "2616" ["zippopulation"]=> string(4) "4847" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "377" ["zipcity"]=> string(11) "GREENEVILLE" ["zipstate"]=> string(2) "TN" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "18589" ["State"]=> string(2) "TN" ["CityName"]=> string(11) "Greeneville" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "49" ["Population"]=> string(5) "13532" ["Latitude"]=> string(8) "36.16824" ["Longitude"]=> string(10) "-82.822474" ["PrimaryAC"]=> string(3) "423" ["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) "18589" ["Population2000"]=> string(5) "15198" ["FIPS"]=> string(7) "4730980" ["cTZoffset"]=> NULL ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "99" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
38 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
18613TNJohnson City01564938136.335399-82.372764230000018613554694738320-5-199
18616TNKingsport-11013636536.536851-82.5421234230000018616449054739560-5-199
18499TNBristol0862342136.569135-82.1974894230000018499248214708540-5-199
20231VABristol-1401842636.611116-82.1761935400000020231173675109816-5-199
18589TNGreeneville-1491353236.16824-82.8224744230000018589151984730980-199
18562TNElizabethton-1691193136.336527-82.2390384230000018562133724723500-199
18620TNLa Follette00719236.375006-84.1276234230000079264740180-199
18594TNHarriman-159711935.928585-84.5557865000001859467444732520-199
20182VAAbingdon-167700336.709773-81.975694276000002018277805100148-5-199
20409VAMarion-154663036.836953-81.516483540000002040963495149464-5-199
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
40875TNAlcoa-10640035.80385-83.97750000077344700540-199
18611TNJefferson City053549436.116389-83.4865865000001861177604737960-199
18565TNErwin-162501536.145036-82.410796423000001856556104724360-199
18515TNChurch Hill-10483436.520845-82.725472423000001851559164714980-199
20214VABig Stone Gap-122474836.867165-82.774471540000002021448565107480-5-199
18617TNKingston052455235.870083-84.501479865000001861752644739620-199
20461VANorton-169424736.936805-82.625146540000002046139045157688-5-199
18718TNRogersville-12414936.414418-82.997466423000001871842404764820-199
20394VALebanon-153338636.900912-82.076988540000002039432735144696-5-199
20583VAWise-14319336.978057-82.577033540000002058332555187072-5-199
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
40949TNJonesborough-10309136.294305-82.4724660000041684738540-199
40939TNHarrogate-Shawanee-10265736.58145-83.6435830000028654732650-199
18494TNBlountville091260536.533312-82.326474423000001849429594706740-199
18612TNJellico-163244736.582627-84.130608423000001861224484738020-199
18673TNMountain City-132216936.468444-81.803856423000001867323834750400-199
20273VACoeburn-192216536.943872-82.466069540000002027319965117952-5-199
20474VAPennington Gap-186192236.75658-83.029375540000002047417815161560-5-199
20271VAClintwood-12154237.150054-82.456698540000002027115495117552-5-199
18755TNSurgoinsville-10149936.474172-82.854126423000001875514844772380-199
20481VAPound-1099537.12382-82.607859540000002048110895164272-5-199
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
20380VAJonesville-1092736.688012-83.11630554000000203809955141272-5-199
40925TNFriendsville-1079235.755804-84.131028000008904728060-199
18607TNHuntsville-1266036.410732-84.49512442300000186079814736640-199
18503TNBulls Gap015265936.259094-83.07950742300000185037144709560-199
18587TNGreenback-15261135.655751-84.16489886500000185879544730880-199
70183VAWeber City0036.623284-82.561039000000013335183808-5-199
18625TNLake City-15236.224234-84.155902865000001862518884740240-199
20269VAClinchco-1137.162466-82.35995154000000202694245117504-5-199
**** cities in zip3 **************
44 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
37716CLINTONTN19578Clinton71
37743GREENEVILLETN19307Greeneville99
37774LOUDONTN15756Loudon71
37748HARRIMANTN13895Harriman99
37745GREENEVILLETN13441Greeneville99
37725DANDRIDGETN12966Dandridge
37763KINGSTONTN12836Kingston99
37766LA FOLLETTETN12520La Follette99
37771LENOIR CITYTN12281Lenoir City71
37721CORRYTONTN10182
zipcodezipcityzipstatezippopulationcitynameDMAID
37772LENOIR CITYTN9552Lenoir City71
37777LOUISVILLETN9280Louisville
37760JEFFERSON CITYTN9183Jefferson City99
37764KODAKTN7644
37757JACKSBOROTN6975Jacksboro
37701ALCOATN6070Alcoa99
37738GATLINBURGTN5103Gatlinburg71
37708BEAN STATIONTN4967
37737FRIENDSVILLETN4914Friendsville99
37752HARROGATETN4847Harrogate
zipcodezipcityzipstatezippopulationcitynameDMAID
37742GREENBACKTN4844Greenback99
37769LAKE CITYTN4569Lake City99
37722COSBYTN4521
37705ANDERSONVILLETN3930
37711BULLS GAPTN3868Bulls Gap99
37754HEISKELLTN3664
37714CARYVILLETN3270Caryville
37709BLAINETN2849Blaine
37779LUTTRELLTN2819Luttrell
37755HELENWOODTN2377Helenwood
zipcodezipcityzipstatezippopulationcitynameDMAID
37762JELLICOTN2314Jellico99
37756HUNTSVILLETN2113Huntsville99
37770LANCINGTN1827
37724CUMBERLAND GAPTN1614Cumberland Gap
37727DEL RIOTN1541
37726DEER LODGETN1278Deer Lodge
37713BYBEETN1206
37729DUFFTN921
37723CRAB ORCHARDTN782Crab Orchard
37710BRICEVILLETN749
zipcodezipcityzipstatezippopulationcitynameDMAID
37753HARTFORDTN619Hartford
37731EIDSONTN552
37715CLAIRFIELDTN551
37765KYLES FORDTN0
Station WCXZ-AM
City HARROGATE-TN

City Harrogate, TN is located in DMAID: