Massachusetts Department of Public Health seal Massachusetts Environmental Public Health Tracking

=

Tutorials -Data Tables

Overview:

  • Convert your data set from a map into a custom table
  • Print your table
  • Export your data for further analysis
  • Observe metadata for inforation about where your data is from

    • 1. Table:

    Look at your query in a tabular form by selecting the “Table” option on the top right of the page.

    There is a screenshot of the map result for a query. There is a red box around the Table tab, located at the top of the page, to the right of the map tab with the cursor clicking on it.

    2. Table:

    A table will appear with the selected information.

    The screenshot displays a table of the data. The columns include town names, observed, expected, standardized incidence ratio, 95% confidence interval, and stability.

    3. Table:

    Want to go to back? On the bottom left, click “Revise Query” to edit your entry or click “New Query” to create a new one.

    The screenshot of the same table page is scrolled down, and has a red box over the Revise Query button at the bottom left corner of the page and the cursor is clicking on it.

    4. Printing a Table:

    Click File and Print on your browser. Your browser options may be in a different location.

    There is a screenshot of the table page with a browser menu open and there is a red box around the print option with a cursor clicking on it.

    5. Export Data:

    Select the Export to CSV option on the top right of the page to obtain a file with your query selection. The file should appear in your Downloads folder saved as a csv. If the data doesn’t automatically open in Excel, save it as an .xls file.

    The screenshot has a red box around the Export to CSV tab and the cursor is clicking on it.

    6. Metadata:

    Select the “Metadata” option on the top right of the page. Metadata is the data about your data.

    There screenshot has a red box around the Metadata tab and the cursor is clicking on it.

    7. Metadata:

    This is what the metadata page will look like. Sections include Identification Information, Data Quality Information, Entity and Attribute Information, Distribution Information, and Metadata Reference Information.

    There is a screenshot of the metadata page with paragraphs of information.
    This page was last edited on: