Accessing and Downloading the CDC Data Navigate to the website and then select the disease you want to map in the “STD” step 1 and then select in step 2. “Tables” This will result in transfer to the next window, you will be given the option to choose what type of STD data you want to download in the Indicator”. The “option1: rest of the options are greyed out and you will be prompted to select in each tab and then complete all the five tabs given on the website. In this window, select and then hit next. “Chlamydia” Then, you will be navigated to the other window where you need to select the geographical region in the tab. Select and then as State and then ‘County’ ‘Texas’ click next. In the next window, you are prompted to select the year for which the data should be downloaded. If you have a good and fast internet connection, then click all”; “select otherwise, select 2-3 years at a time and download the data. You must download the data for all the given years. Then, click next. Keep the default option for the and then keep the radio button of “demographic” geography unchecked in the by” tab and then click my Table”. “Group “Create You will see a table where all your data was created and then click on the top “Export” and your data will be downloaded as a .csv file. The downloaded data file will be seen as follows. You will see two columns “Cases” and for each year you are downloading. refers to the total number of “Rate” ‘Case’ chlamydia cases reported in the county for the year and the refers to the ‘Rate’ number of chlamydia cases recorded for 100,000 people. Arrange all the data and make a single excel file with all the Chlamydia data for all the and all the data. Your excel file should be seen as follows. ‘case’ ‘rate’
Accessing and Downloading the CDC Data Navigate to the website and then select the “STD” disease you want to map in the step 1 and then select “Tables” in step 2. This will result in transfer to the next window, you will be given the option to choose what type of STD data you want to download in the “option1: Indicator”. The rest of the options are greyed out and you will be prompted to select in each tab and then complete all the five tabs given on the website. In this window, select “Chlamydia” and then hit next. Then, you will be navigated to the other window where you need to select the geographical region in the tab. Select ‘County’ and then ‘Texas’ as State and then click next. In the next window, you are prompted to select the year for which the data should be downloaded. If you have a good and fast internet connection, then click “select all”; otherwise, select 2-3 years at a time and download the data. You must download the data for all the given years. Then, click next. Keep the default option for the “demographic” and then keep the radio button of geography unchecked in the “Group by” tab and then click “Create my Table”. You will see a table where all your data was created and then click “Export” on the top and your data will be downloaded as a .csv file. The downloaded data file will be seen as follows. You will see two columns “Cases” and “Rate” for each year you are downloading. ‘Case’ refers to the total number of chlamydia cases reported in the county for the year and the ‘Rate’ refers to the number of chlamydia cases recorded for 100,000 people. Arrange all the data and make a single excel file with all the Chlamydia data for all the ‘case’ and all the ‘rate’ data. Your excel file should be seen as follows.
bhaskar.docx