City Senior Center Interval Energy Data

5-minute interval electric data for the Cambridge Senior center located at 806 Massachusetts Avenue from April 2013 through July 2018. The dataset enables analysis of electricity usage patterns over a series of days, weeks, months and years; this can help identify opportunities to reduce energy use and demand and can be used as a starting point to correlate energy consumption changes with conservation measures.

Electricity use is the amount of electricity that has been consumed over a certain period of time. Electricity demand is the maximum amount of electrical energy that is being consumed at a given time. Electricity use is measured in kilowatt hours (kWh). Electricity demand is measured in kilowatts (kW). Additionally, this dataset contains measurements for Power Factor and Reactive Power. Power Factor is the ratio of the real power that is flowing to the load and the apparent power that is supplied to the circuit. Reactive Power occurs in alternating current circuits when there is a phase difference between voltage and current. It is measured in kVAR for demand and kVARh for use.

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 \"cambridgema-gov/city-senior-center-interval-energy-data-uuej-6t9x\".\"city_senior_center_interval_energy_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.