{"action":"created","issue":{"url":"https://api.github.com/repos/socrata/dev.socrata.com/issues/105","labels_url":"https://api.github.com/repos/socrata/dev.socrata.com/issues/105/labels{/name}","comments_url":"https://api.github.com/repos/socrata/dev.socrata.com/issues/105/comments","events_url":"https://api.github.com/repos/socrata/dev.socrata.com/issues/105/events","html_url":"https://github.com/socrata/dev.socrata.com/issues/105","id":31826695,"number":105,"title":"string values have trailing spaces","user":{"login":"adaptive-webdev","id":7319836,"avatar_url":"https://avatars.githubusercontent.com/u/7319836?v=3","gravatar_id":"","url":"https://api.github.com/users/adaptive-webdev","html_url":"https://github.com/adaptive-webdev","followers_url":"https://api.github.com/users/adaptive-webdev/followers","following_url":"https://api.github.com/users/adaptive-webdev/following{/other_user}","gists_url":"https://api.github.com/users/adaptive-webdev/gists{/gist_id}","starred_url":"https://api.github.com/users/adaptive-webdev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adaptive-webdev/subscriptions","organizations_url":"https://api.github.com/users/adaptive-webdev/orgs","repos_url":"https://api.github.com/users/adaptive-webdev/repos","events_url":"https://api.github.com/users/adaptive-webdev/events{/privacy}","received_events_url":"https://api.github.com/users/adaptive-webdev/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2014-04-18T21:40:27Z","updated_at":"2015-01-30T19:25:55Z","closed_at":null,"body":"dev.socrata.com:\r\n\r\nWould you please remove the trailing spaces of query results.  Having extra space characters makes query very difficult.  \r\nEx. http://data.medicare.gov/resource/b8rp-pr7k.json?$where=city='ANCHORAGE' returns an empty array because . \"city\" : \"ANCHORAGE                     \" has extra space characters.  see   http://data.medicare.gov/resource/b8rp-pr7k.json?$limit=1\r\n\r\nThank you very much.\r\n\r\nSaun"},"comment":{"url":"https://api.github.com/repos/socrata/dev.socrata.com/issues/comments/72255718","html_url":"https://github.com/socrata/dev.socrata.com/issues/105#issuecomment-72255718","issue_url":"https://api.github.com/repos/socrata/dev.socrata.com/issues/105","id":72255718,"user":{"login":"marks","id":34566,"avatar_url":"https://avatars.githubusercontent.com/u/34566?v=3","gravatar_id":"","url":"https://api.github.com/users/marks","html_url":"https://github.com/marks","followers_url":"https://api.github.com/users/marks/followers","following_url":"https://api.github.com/users/marks/following{/other_user}","gists_url":"https://api.github.com/users/marks/gists{/gist_id}","starred_url":"https://api.github.com/users/marks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marks/subscriptions","organizations_url":"https://api.github.com/users/marks/orgs","repos_url":"https://api.github.com/users/marks/repos","events_url":"https://api.github.com/users/marks/events{/privacy}","received_events_url":"https://api.github.com/users/marks/received_events","type":"User","site_admin":false},"created_at":"2015-01-30T19:25:55Z","updated_at":"2015-01-30T19:25:55Z","body":"@adaptive-webdev - sorry this went without an answer for a while but unfortunately this is due to the data publisher publishing data with trailing spaces. We do not edit our customer's data unless specifically asked to by them. If you share the latest URL for that data set, I can suggest the fix to the data publisher."}}