Total Employees and Businesses

The Total Employees and Businesses Dataset is a snapshot of the total number of businesses that are currently in Mesa, as well as the total number of employees that work in Mesa.

Source: ESRI Community Analyst.

It is important to note that in this dataset, a “Full-Time Employee (FTE)” in Mesa is someone who may not necessarily live in Mesa, however, they are employed at a business that is located in Mesa. This is a distinct difference between the “Employment” number in Mesa, which is stated in the “Employment Dataset.” Employment refers to the total number of Mesa residents that are employed, within or outside of the City of Mesa.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"citydata-mesaaz-gov/total-employees-and-businesses-xt2b-s4bi\".\"total_employees_and_businesses\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.