︠a54255d5-b248-431f-afed-ba7d29108799s︠ import requests data = requests.get('https://data.seattle.gov/resource/6qkn-8xvw.json?$limit=50000').json() def get_column(data, column): return [row[column] for row in data] dates = sorted(get_column(data, 'received_date')) bar_chart([dates.count(item) for item in sorted(list(set(dates)))]) ︡66b9d982-459e-4b47-abad-215f48e9db4d︡︡{"once":false,"done":false,"file":{"show":true,"uuid":"c0425a41-9730-4b0f-a345-fbec621b9d92","filename":"/projects/6976c13f-01d8-486c-962d-5b2bb6ecce1b/.sage/temp/compute4-us/27244/tmp_v_wQBH.svg"}}︡{"html":"
","done":false}︡{"done":true} ︠3b6c9e5b-3b5e-4545-83fe-8b832b007497s︠ sorted([{'date': item, 'count': dates.count(item)} for item in sorted(list(set(dates)))], key=lambda x: x['count'], reverse=True)[:10] ︡da5e3f97-9a30-4ba9-bf60-9eaaf1563386︡︡{"stdout":"[{'date': u'2015-02-05T00:00:00', 'count': 912}, {'date': u'2015-10-29T00:00:00', 'count': 276}, {'date': u'2015-01-26T00:00:00', 'count': 177}, {'date': u'2015-02-09T00:00:00', 'count': 152}, {'date': u'2015-02-02T00:00:00', 'count': 150}, {'date': u'2015-02-06T00:00:00', 'count': 70}, {'date': u'2015-01-30T00:00:00', 'count': 62}, {'date': u'2015-02-04T00:00:00', 'count': 62}, {'date': u'2015-02-10T00:00:00', 'count': 60}, {'date': u'2015-02-03T00:00:00', 'count': 52}]","done":false}︡{"stdout":"\n","done":false}︡{"done":true} ︠79d228ba-44aa-45f5-8b48-f4b4dcc1ffd9︠ html.table