Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors
---Find the number of users who report being located in the New York state.
---These include people who report themselves in New York city or in the NY state.
---Be as accurate as possible as the self-reported location may take different forms.
---Report id, displayname, and location in your result set.
WHERE Location = 'New York'