About this Dataset

Community Survey: 2021 Random Sample Results

A random sample of households were invited to participate in this survey.

In the dataset, you will find the respondent level data in each row with the questions in each column. The numbers represent a scale option from the survey, such as 1=Excellent, 2=Good, 3=Fair, 4=Poor. The question stem, response option, and scale information for each field can be found in the var "variable labels" and "value labels" sheets.

VERY IMPORTANT NOTE: The scientific survey data were weighted, meaning that the demographic profile of respondents was compared to the demographic profile of adults in Bloomington from US Census data. Statistical adjustments were made to bring the respondent profile into balance with the population profile. This means that some records were given more "weight" and some records were given less weight. The weights that were applied are found in the field "wt". If you do not apply these weights, you will not obtain the same results as can be found in the report delivered to the Bloomington. The easiest way to replicate these results is likely to create pivot tables, and use the sum of the "wt" field rather than a count of responses.
Organization: City of Bloomington
Last updated: 2023-05-20T03:47:49.135511

Tables

Table 1

@usgov.city_of_bloomington_community_survey_2021_random_sampl_a0cff257.table_1

212.28 kB
527 rows
240 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "area" BIGINT,
  "q1a" DOUBLE,
  "q1b" DOUBLE,
  "q1c" DOUBLE,
  "q1d" DOUBLE,
  "q1e" DOUBLE,
  "q1f" DOUBLE,
  "q1g" DOUBLE,
  "q2a" DOUBLE,
  "q2b" DOUBLE,
  "q2c" DOUBLE,
  "q2d" DOUBLE,
  "q2e" DOUBLE,
  "q2f" DOUBLE,
  "q2g" DOUBLE,
  "q2h" DOUBLE,
  "q2i" DOUBLE,
  "q2j" DOUBLE,
  "q3a" DOUBLE,
  "q3b" DOUBLE,
  "q4a" DOUBLE,
  "q4b" DOUBLE,
  "q4c" DOUBLE,
  "q4d" DOUBLE,
  "q4e" DOUBLE,
  "q4f" DOUBLE,
  "q4g" DOUBLE,
  "q5a" DOUBLE,
  "q5b" DOUBLE,
  "q5c" DOUBLE,
  "q5d" DOUBLE,
  "q6a" DOUBLE,
  "q6b" DOUBLE,
  "q6c" DOUBLE,
  "q6d" DOUBLE,
  "q7a" DOUBLE,
  "q7b" DOUBLE,
  "q7c" DOUBLE,
  "q7d" DOUBLE,
  "q7e" DOUBLE,
  "q7f" DOUBLE,
  "q7g" DOUBLE,
  "q7h" DOUBLE,
  "q7i" DOUBLE,
  "q7j" DOUBLE,
  "q7k" DOUBLE,
  "q7l" DOUBLE,
  "q7m" DOUBLE,
  "q7n" DOUBLE,
  "q7o" DOUBLE,
  "q7p" DOUBLE,
  "q7q" DOUBLE,
  "q7r" DOUBLE,
  "q7s" DOUBLE,
  "q7t" DOUBLE,
  "q7u" DOUBLE,
  "q7v" DOUBLE,
  "q7w" DOUBLE,
  "q7x" DOUBLE,
  "q7y" DOUBLE,
  "q7z" DOUBLE,
  "q7aa" DOUBLE,
  "q7bb" DOUBLE,
  "q7cc" DOUBLE,
  "q7dd" DOUBLE,
  "q7ee" DOUBLE,
  "q7ff" DOUBLE,
  "q7gg" DOUBLE,
  "q7hh" DOUBLE,
  "q7ii" DOUBLE,
  "q7jj" DOUBLE,
  "q7kk" DOUBLE,
  "q7ll" DOUBLE,
  "q7mm" DOUBLE,
  "q7nn" DOUBLE,
  "q7oo" DOUBLE,
  "q7pp" DOUBLE,
  "q8a" DOUBLE,
  "q8b" DOUBLE,
  "q8c" DOUBLE,
  "q8d" DOUBLE,
  "q8e" DOUBLE,
  "q8f" DOUBLE,
  "q8g" DOUBLE,
  "q8h" DOUBLE,
  "q8i" DOUBLE,
  "q8j" DOUBLE,
  "q9a1" DOUBLE,
  "q9b1" DOUBLE,
  "q9c1" DOUBLE,
  "q9d1" DOUBLE,
  "q9e1" DOUBLE,
  "q9f1" DOUBLE,
  "q9g1" DOUBLE,
  "q9h1" DOUBLE,
  "q9i1" DOUBLE,
  "q9j1" DOUBLE,
  "q9k1" DOUBLE,
  "q9l1" DOUBLE
);