elenalabzina / nlpFox-Congress

1 stars 0 forks source link

Aggregate fox news channel positions by district #4

Open elliottash opened 5 years ago

elliottash commented 5 years ago

The channel positions are by zip code -- they need to be aggregated to the congressional district level.

That should be done using the population-weighted average by zip code.

This dataset can be used for this purpose: https://www.dropbox.com/s/fjpi2uwyvu1axlc/zip_code_data.dta?dl=0

elenalabzina commented 5 years ago

The files with the channel positions aggregated (weighted for the population by zipcodes) for 2005 and 2011 can be found in weighted_channel_position_2005.csv and weighted_channel_position_2011.csv.