Broadcast TV Data Fields
Broadcast TV Data Set.           Product 400

Broadcast TV Product 400 ships with a complete set of pre-defined map shape files for BusinessMap (.bzm) and MS MapPoint (.ptm), covering all 224 DTVMA's. In addition a complete set of Excel (.xls), dBase III (.dbf) and Comma Delimited (.txt)  are provided for each DTVMA.

      Broadcasttv2010  
     1,844 Records                                                      
      Field          Field Name                 Type                   Width

1

CALLSIGN

Character

4

Station Call Sign

2

AFFILIATE

Character

35

National Affiliate (CBS, NBC Etc..)

3

 NTSCCHL

Character

 10

Station NTSC Channel Number

4

DTVCHL

Character

10

Digital Channel Number

5

OWNER

Character

35

Corporate Owner

6

 ADDRESS

Character

35

Mailing Address (Office)

7

 CITY

Character

 35

Mailing City

8

STATE

Character

2

Mailing State

9

ZIPCODE

Character

15

Mailing Zip Code

10

COUNTY

Character

35

Station County Location

11

TELEPHONE

Character

15

Office Telephone Number

12

ALTPHONE

Character

15

Alternate Telephone Number

14

 FAX

Character

15

Office Fax Number

15

 GNLMANAGER

Character

35

Station General Manager

16

 GMEMAIL

Character

75

General Manager Email

17

ENGMANAGER

Character

 35

Manager Engineering

22

ENGEMAIL

Character

 8

Engineering Manager Email

22

ENGPHONE

Character

25

Engineering Direct Line

23

 WEBSITE

Character

 25

Web Site URL

24

RANK

Character

 75

Market Rank

25

MARKETNAME

Character

 55

 Market Area Name

26

NTSCERP

Character

 10

 NTSC Effective Radiated Power

27

 DTVERP

Character

 35

 Digital Effective Radiated Power

18

NTSCHAAT

Character

25

 NTSC Antenna Height

19

 DTVHAAT

Character

 75

 DTV Antenna Height

20

 DTVLAT

Character

45

 Digital Antenna Latitude

21

DTVLON

Character

 8

 Digital Antenna Longituder

22

 DTVPOP

Character

25

 Population in Digital Coverage Area

23

 AREAHH

Character

 25

 House-Holds in Digital Coverage Area

24

 LEGALREP

Character

 75

 Station Legal Representation

25

 MCSZ

Character

 55

 Mail City State (for mailing convenience)

26

PRLABEL

Character

 1

Identifies Duplicate Addresses

      Broadcastcomzip2010                                                      
     Field   Field Name               Type           Width

1

COMZIP

Character

10

Main Community Zip Code

2

COMMUNITY

Character

35

Community Covered Name

3

STATE

Character

35

State Covered Name

4

COUNTY

Character

35

DTVMA Market Area Name

5

MARKETNAME

Character

45

Mailing State

6

DTVMARANK

Numeric

3

DTVMA Market Area Rank

7

CBSANAME

Character

35

Dept. Census CBSA Name

8

AREACODE

Character

3

Area Code

9

HHBYZIP

Numeric

10

TV House-Holds within Zip Code

10

POPBYZIP

Numeric

10

TV Population within Zip Code 

11

WHITEPOP

Numeric

10

White Population within Zip Code

12

BLACKPOP

Numeric

10

Black Population within Zip Code

13

HISPPOP

Numeric

10

Hispanic population with Zip Code

14

HHINCOME

Numeric

10

Average House-Hold Income

15

DTVMAHH

Numeric

10

DTV Market Area House-Holds

16

DTVNAPOP

Numeric

10

DTV Market Area Population

17

HHGAIN

Numeric

10

TV HH Gain with Digital TV

18

HHLOSS

Numeric

10

TV HH Loss with Digital TV

19

NTSCERP

Character

10

NTSC Effective Radiated Power

20

STATEFIPS

Character

5

State FIPS Code

21

COUNTYFIPS

Character

5

County FIPS Code

22

CITYFIPS

Character

10

City FIPS Code

23

PLACECODE

Character

35

Place Code

24

LATITUDE

Character

15

Latitude of Centroid

25

LONGITUDE

Character

15

Longitude of Centroid

26

CITYALIAS

Character

35

Community Alias name

27

DIVISION

Character

45

US by Division

28

REGION

Character

45

US by Region

29

NUMBERBUS

Numeric

10

Number of Business within Zip

30

NUMBEREMP

Numeric

10

Number of Emoloyees within Zip