Create a Situation & Outlook Report

The Situation & Outlook report provides a summary report for the selected area comprised of multi-sourced data. It provides a snapshot containing key data for one area as opposed to developing a dataset across a range of geographic areas. Its purpose is to provide immediate insights rather that develop a data file for use by other applications.

 

The report includes these sections:

    Lead narrative section

   .. the default content is modifiable by the user

 

    Summary of personal income and GDP

 

    How & Why Demographics are Changing

 

    Population & Components of Change

   .. derived from Census Bureau model-based population estimates program

   .. time series; updated annually

 

    Component Area Cities

   .. includes Census Bureau model-based population estimates program; time series; updated annually

   .. includes link to more detailed data

 

    Mobility -- County to County (and Country)

   .. based on ACS special tabulation

   .. updated annually; updates September 2021

 

    Extended Demographic Economic Data

   .. includes ACS 2019 5 or 1 year data

       - user selectable based on Statistical Program selection

   .. includes options Situation & Outlook estimates and projections

   .. General demographics

   .. Social characteristics

   .. Economic Characteristics

   .. Housing Situation

       - housing unit trends

       - new authorized residential construction (where available)

       - Housing Characteristics

 

    Establishments, Employment, Earnings

   .. based on BLS QCEW data

   .. user selectable: a) 5 digit NAICS code type of business or b) divisional levels

   .. user selectable quarterly or annual data

   .. updated quarterly

 

    Census Tracts in County

   .. report shows attributes of all tracts in county

   .. user selectable subject matter

 

   Steps to include tracts table

   .. the Tracts ckeckbox must be checked on (lower right section)

   .. the top right Query must be set to the state containing the county (e.g. "stab='CA'" for Orange County, CA)

   .. set the subject matter items file to the subject matter to be included in the profile (default recommended)

   .. dbl-click the county area to start profile generation

   .. in the final step the tracts API will be run

       - the statistical program must be an ACS 5 year program

       - the geography must be set to 140 census tract

 

Usage. Dbl-Click on a area in the Areas Listbox located in lower section of control panel to display a profile in the grid.

 

Click the Fresno County, CA item in the Areas listbox; a profile is displayed in the Grid.

 .. the profile is generated for the year or quarter shown in the Year/Qtr edit box in the control panel.

Click the Open XLS and click Create XLS button and an XLS file similar to the grid display is created/displayed.

 .. see the XLS file generated here: http://proximityone.com/dede/qcew0601920Q4.xls

 

What industry in Sedgwick County, KS (Wichita) had the highest average weekly wages in 4th quarter 2020?

-- follow the above procedure, selecting/dbl-clicking 20173 Sedgwick County, KS from Areas listbox.

-- profile appears in grid; click Create XLS button with Open XLS checked.

-- when the file opens in Excel, sort descending on col I to obtain this view:

 

-- the highest average weekly wages is industry NAICS 3241 -- Petroleum and coal products manufacturing ($7,998)

-- or 55111 -- Management of companies and enterprises, as it has a larger number of businesses/employees

Note that a similar view can be obtained by dbl-clicking the header cell on AWW using the grid -- the grid is sortable.

 

Level of Industry Detail The profiles show QCEW data by detailed private ownership type of industry for the selected area. There is one row for each NAICS code (2 through 5 digits NAICS levels). Columns include the NAICS title, NAICS code, disclosure indicator, number of establishments, monthly employment (three months), total payroll and average weekly wages.

 

To show only divisional industry level of detail, check the Divisional checkbox above the geography listbox before dbl-clicking the geographic item. The following example illustrates results of using the divisions checkbox for San Diego County, CA. This view shows that there were 118,195 total private ownership establishments in San Diego County as of the 4th quarter 2020. Divisional levels of detail follow in subsequent rows.

Â