Skip to content

Instantly share code, notes, and snippets.

@lbustelo
Created May 2, 2016 19:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lbustelo/1b6839cffa63a1dc112d847ed5e4da5b to your computer and use it in GitHub Desktop.
Save lbustelo/1b6839cffa63a1dc112d847ed5e4da5b to your computer and use it in GitHub Desktop.
{
"json_endpoint":"\/caravel\/explore\/table\/3\/?force=true&slice_name=Name+Cloud&row_limit=50000&granularity_sqla=ds&datasource_type=table&flt_op_1=in&flt_op_0=in&viz_type=table&since=100+years+ago&json=true&until=now&collapsed_fieldsets=&datasource_id=3&flt_col_0=gender&metrics=count&flt_eq_0=&flt_eq_1=boy&flt_col_1=gender&include_search=false&slice_id=19&previous_viz_type=table&groupby=gender&datasource_name=birth_names&where=&having=",
"csv_endpoint":"\/caravel\/explore\/table\/3\/?force=true&slice_name=Name+Cloud&row_limit=50000&granularity_sqla=ds&datasource_type=table&flt_op_1=in&flt_op_0=in&viz_type=table&since=100+years+ago&csv=true&until=now&collapsed_fieldsets=&datasource_id=3&flt_col_0=gender&metrics=count&flt_eq_0=&flt_eq_1=boy&flt_col_1=gender&include_search=false&slice_id=19&previous_viz_type=table&groupby=gender&datasource_name=birth_names&where=&having=",
"standalone_endpoint":"\/caravel\/explore\/table\/3\/?force=true&slice_name=Name+Cloud&row_limit=50000&granularity_sqla=ds&datasource_type=table&flt_op_1=in&flt_op_0=in&viz_type=table&since=100+years+ago&until=now&collapsed_fieldsets=&datasource_id=3&flt_col_0=gender&metrics=count&flt_eq_0=&flt_eq_1=boy&flt_col_1=gender&include_search=false&slice_id=19&standalone=true&previous_viz_type=table&groupby=gender&datasource_name=birth_names&where=&having=",
"is_cached":false,
"cached_dttm":"2016-05-02T19:12:32",
"form_data":{
"slice_name":"Name Cloud",
"granularity_sqla":"ds",
"all_columns":[
],
"flt_op_5":"in",
"flt_op_4":"in",
"flt_op_7":"in",
"flt_op_6":"in",
"flt_op_1":"in",
"flt_op_0":"in",
"flt_op_3":"in",
"flt_op_2":"in",
"flt_op_9":"in",
"flt_op_8":"in",
"json":"true",
"until":"now",
"flt_col_0":"gender",
"flt_col_7":"gender",
"flt_col_6":"gender",
"async":"",
"where":"",
"force":"true",
"row_limit":"50000",
"viz_type":"table",
"since":"100 years ago",
"collapsed_fieldsets":"",
"metrics":[
"count"
],
"flt_eq_8":"",
"flt_eq_9":"",
"flt_eq_6":"",
"flt_eq_7":"",
"flt_eq_4":"",
"flt_eq_5":"",
"flt_eq_2":"",
"flt_eq_3":"",
"flt_eq_0":"",
"flt_eq_1":"boy",
"flt_col_1":"gender",
"include_search":false,
"flt_col_3":"gender",
"flt_col_2":"gender",
"flt_col_5":"gender",
"flt_col_4":"gender",
"slice_id":"19",
"standalone":"",
"flt_col_9":"gender",
"flt_col_8":"gender",
"previous_viz_type":"table",
"groupby":[
"gender"
],
"extra_filters":"",
"having":""
},
"query":"SELECT gender AS gender,\n COUNT(*) AS count\nFROM birth_names\nWHERE ds >= '1916-05-02 19:12:32.000000'\n AND ds <= '2016-05-02 19:12:32.000000'\n AND gender IN ('boy')\nGROUP BY gender\nORDER BY COUNT(*) DESC LIMIT 50000\nOFFSET 0",
"cache_timeout":null,
"data":{
"records":[
{
"count":39245,
"gender":"boy"
}
],
"columns":[
"gender",
"count"
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment