Download Survey Data

[Alethia Tiell]

Thispage provides anglers and other users access to fish survey data collected by Iowa Department of Natural Resources (DNR) fisheries staff during electroshocking and netting surveys on lakes, rivers and streams. Information available includes survey summaries from individual lakes and rivers, fish species length across lakes, and fish length and weight data. Additional data and summaries will be available in the future.

The American Community Survey (ACS) releases new data every year through a variety of data tables that you can access with different data tools. Learn more about the different types of tables and profiles powered by ACS data. We also have information about other special datasets, such as the ACS Experimental Data, ACS Summary File, and ACS Public Use Microdata Sample (PUMS) files.

Check out data.census.gov, the Census Bureau's main data dissemination tool. Here, you can access tables and maps with ACS data. You can also view data.census.gov Resources for step-by-step guidance, video tutorials, FAQs, and more.

Data Profiles contain the most popular social, economic, housing, and demographic data for a single geographic area. The Data Profiles summarize the data, providing both estimates and percentages, to cover the most basic data on all ACS topics. Click on a link below to view these profiles on data.census.gov. From there, you can select Customize Table to select your geography and product (or data set) of interest.

Overview: Each year, the FCC conducts a survey of the fixed voice and broadband service rates offered to consumers in urban areas. The FCC uses the survey data to determine the reasonable comparability benchmarks for fixed voice and broadband rates for universal service purposes.

Compare data across countries and trends over time for hundreds of population, health and nutrition indicators. Choose indicators for over 200 surveys and create customized tables, graphs, charts and maps. See the STATcompiler tutorials for instructions on the use of the STATcompiler. See STATcompiler comparability for information on the comparability of STATcompiler results and differences from results in the final reports.

Conducted in 2012, the NHANES National Youth Fitness Survey (NNYFS) was a one-time survey to collect data on physical activity and fitness levels in order to provide an evaluation of the health and fitness of children and teens in the U.S. ages 3 to 15 years. The NNYFS collected data on physical activity and fitness levels through interviews and fitness tests.

Conducted in 1986, 1987, and 1992 , the NHANES I Epidemiologic Follow-up Study (NHEFS) was a national longitudinal study designed to investigate the relationships between clinical, nutritional, and behavioral factors assessed in the NHANES I and subsequent morbidity, mortality, and hospital utilization, as well as changes in risk factors, functional limitation, and institutionalization.

Conducted from 1988-1994, the third National Health and Nutrition Examination Survey (NHANES III) focused on oversampling many groups within the U.S. population aged 2 months and over. These oversampled groups included children aged 2 months to 5 years, persons over age 60, Mexican-American persons, and non-Hispanic black persons. This survey also concentrated on health and nutrition but additionally began to collect environmental exposure and infectious disease data.

Conducted from 1976-1980, the second National Health and Nutrition Examination Survey (NHANES II) focused on nutrition and health, but the age of participation started at 6 month. The maximum age remained 74 years.

Conducted from 1971-1974, the National Health Examination Survey added a nutrition component and was renamed the National Health and Nutrition Examination Survey (NHANES I). The first NHANES focused on the U.S. population aged 1-74. In 1974-1975, there was an augmentation to the survey on an additional national sample. This augmentation sample only included adults aged 25-74 and did not oversample any population groups nor include nutrition data.

During 1982-1984, NHANES temporarily shifted to a population-specific survey. The Hispanic Health and Nutrition Survey (HHANES) focused on health and nutrition, but involved only the 3 largest Hispanic subgroups in the U.S. at the time aged 6 months to 74 years: Mexican-American persons residing in the Southwest, Cuban-American persons residing in Dade County Florida, and Puerto Rican persons residing in the New York City metropolitan area.

Conducted from 1966-1970, the third National Health Examination Survey (NHES III) focused on the growth and development of U.S. adolescents aged 12-17. Approximately 1/3 of the examined adolescents in NHES III were previously examined in NHES II.

Novice Smartsheet user here. I created a Likert-syle survey using a Smartsheet form that has about 20 questions on it. I have results from five respondents so far. I would like to present this data in a Dashboard using the chart widget - one chart per question. Ideally, the chart would show how many respondents answered "agree", "neutral", or "disagree" for each of the questions.

I have done this many, many times for our district (both for Professional Learning type surveys and Resource type surveys). Yes, this is entirely possible and works like a charm. I would be more than happy to share with you the steps you could to make this happen on a dashboard (via charts and/or metric widgets). Do you have a preferred method by which I could provide you with this information? It would be helpful to see a few examples of what you have set up so far and I am always more than happy and willing to have you email me directly if you would like. Below is a screenshot of a Professional Learning feedback survey that we ran last school year. If you find this helpful I would love to help you. I accomplished this particular dashboard by first setting up a Metrics sheet and I used cross-sheet formulas to pull over the data from my survey sheet. From there it was a simple task of setting up my dashboard and connecting to the data. I used both Chart & Metric widgets for this particular dashboard. Just let me know if you are interested.

Deanna, thank you so much for your response. That would be very helpful to gain some of this knowledge. Could you provide an overview of the steps you to to take one piece of survey data (one Likert-style question) and automated it into the chart widget?

@Deanna Vandermeer How did you create your outcomes by month? I'm having the hardest time? Is it a report? A pivot table? I have answers like "Agree, Strongly Agree.." and I'm not sure how best to change them into numbers for a chart.

@nonahunt There are several ways to go about this. I first started with the form (survey questions) and had a column titled "Feedback Month" in which I would have as a "Hidden" field with a default value set. This worked for us since each month our survey questions varied slightly depending on the professional learning that was delivered that particular month and so we would simply copy the previous form, inactivate the old survey, and then made the appropriate adjustments to the new survey form. Since multiple forms can intake data to a single sheet this worked beautifully. I then created our metrics sheets for the data using cross-sheet formulas. To get that data by month I simply referenced the month in each =countifs formula, then the "strongly agree" or "disagree" (etc.) as necessary for each of those columns. From there I created a district survey dashboard and surfaced this data from our metrics sheets using bar graphs.

But there are other ways you could do this as well, for example you could create a date column (could be hidden in your form as well, but with the default value set to return today's date), then add a helper column to your sheet called "Month" and add a column formula to return the month as a number (i.e., 1=Jan, 2=Feb ...). If you have any other questions or would like help with figuring this out further for your particular solution I would be willing to trying. I hope some of this information does help and provides you with a few ideas. Thanks for reaching out.

I have prepared a google form that will be shared to the customers soon, but unfortunately, i can't get the data into the dashboard. As I have read, there must be some numeric data in the sheet to be able to open it on the dashboard. The other problem is that, most of the answers of the questions contain symbols (e.g. starts to rate form 1 to 5), and in my sheet they show up as stars but not numbers. Do you think this might be the problem that I can not transfer my data to the dashboard (chart widget)?

It's likely that we can use a Report's Grouping and Summary features to generate numbers out of your symbols (see: Configure grouping to organize results in report builder) then use the Report as the source for your chart. Either that, or we could use formulas to create calculations.

You can create a Report with just two columns: the primary column and then one of your drop-down columns. Then you can GROUP by the drop-down and use SUMMARIZE to Count how many rows contain each value.

Let me know if you still need help after reviewing the webinar and I'd be happy to post my own screen captures. It also looks like your account has access to Pro Desk sessions - these are 30-minute coaching sessions over screen share. You may want to book one session to specifically go over how to create Grouping to use a Report for Chart Widgets. See: -desk

I was able to retrieve the data onto the chart by following the steps you explained. But my concern is that I have many dropdowns to implement onto the chart.. In the way that you described, I was able to take one data then as I change the second column to another one, I lost the previous chart that I did. (I've attached the picture)

Yes, to go this route you would need to create many individual reports. This means instead of changing the column being used, you would need to create a duplicate Report with Save as New, then change the column in the next Report.

3a8082e126