ENERGY STAR Certified Ceiling Fans

Please note, Ceiling Fan Light Kits are not included in this dataset. The Ceiling Fan Light Kit dataset can be found here: https://data.energystar.gov/Active-Specifications/ENERGY-STAR-Certified-Ceiling-Fans-Light-Kit/3zeh-haeu/data. Certified models meet all ENERGY STAR requirements as listed in the Version 4.0 ENERGY STAR Program Requirements for Ceiling Fans that are effective as of June 15, 2018. A detailed listing of key efficiency criteria are available at https://www.energystar.gov/products/ceiling_fans/ceiling_fans_key_product_criteria .

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 \"energystar-gov/energy-star-certified-ceiling-fans-2te3-nmxp\".\"energy_star_certified_ceiling_fans\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.