site site.xsl site

Have you seen our Economy indicators on Hotel Occupancy? Read about it.

Detailed information about unconventional wells drilled, permits and violations thanks to our partners at FracTracker.org Read about it.

Want to become involved with PittsburghTODAY? Read about it.

More than 75 percent of African Americans rate their health as good, very good or excellent. But 1-in-4 rate their health as fair or poor compared to about 1-in-5 residents of other races who give their health the lowest ratings. Read about it.

More residents overall support Marcellus Shale drilling than oppose it by a margin of 45 percent to 25 percent, with the rest in neither camp. Read about it.

1,800 residents, 32 counties, 4 states: A distillation of the findings of the Pittsburgh Regional Quality of Life Survey. Read about it.

Did you know that 45,000 jobs in SW PA are dependent upon the waterway transportation system? Read about it.

Our neighbors in Ohio and West Virginia lead the region in classical music attendance. Read about it.

Nearly 70 percent of new Pittsburgh arrivals are between the ages of 22 and 34, migrating from nearby cities such as Philadelphia, Pa.; Washington, D.C.; and New York, NY. Read about it.

Educational and Health Services is Pittsburgh’s largest job sector. Read about it.

Registered nurses pay is low in Pittsburgh by national standards. Read about it.

Local spending on schools is low by benchmark standards. Read about it.

Rush hour traffic in Pittsburgh is less congested than in most cities? Read about it.

Use our sitemap to quickly find content. Read about it.

section indicator_category.xsl indicator_category

page data_explorer.xsl explorer

Data Query and Export page

Use this page to define your own custom query against the data files available at PittsburghTODAY.

Alternatively, click here to visit the source Google document directly. Or Click here to return to the indicator view.

Ready

Step 1: Select data file

Explanation:

Select one of the PittsburghTODAY indicator datasets. The dataset associated with the indicator you were last viewing is currently selected.

Step 2: Select shape and axes

Fields (on columns):

Columns:

Rows:

Explanation:

1. Flat

Filter will select a subset of the data. Results will have the same shape as the source dataset.

2. Pivot

You will "shape" the result by pivoting the members of one field onto the colums. For example, if you pivot the "Year" field onto columns, then the result will have columns for each year present in the dataset.

Note that in preview table that number fields (such as year) will be formatted with a decimal point, but this will not be present in the CSV.

Step 3: Specify filters

Explanation:

Select members you wish to be included in result set.

* You may select multiple entries in these lists

.

Step 4: Review or refine query

Explanation:

The query created from your selections is displayed. You may click submit or edit the query with final adjustments before submitting.

Preview export

Preview result here before export.