I am using cartoDB database and making a web application. I have a data in my database which you can view it from here and its public https://farook.cartodb.com/tables/entire_data. The response of the query would be json. I have two accounts created in cartoDB database but the same data given in the above link is there in both the accounts. The problem is when i do query and get a json response, the json differs for the same data from two different accounts. You can view the json response of one account where the order of the first row is cartodb_id, the_geom, the_geom_webmercator, 2007_dec and so on. and the json response for the same data from other account is also here where the order is cartodb_id, the_geom, the_geom_webmercator, region_name, 1990_january and so on. Why it behaves so? WHat would be the problem for different responses?
If the only difference between two json ouputs is the order of the keys it is something normal. The JSON spec does not says nothing about the order that must follow the keys, neither the cartodb sql api.