UT-Austin Data Drive Reporting class's reports | Mode

@utdata

UT-Austin Data Drive Reporting class

Published Bcycle Data 201409 to 201508

Data set used for Spring 2015 Data Visualization alternative data format story.
Published BCycle Trips with locations

All BCycle trip records, with checkout and return latitude/longitudes added, as pulled ...
Published kiosk

SELECT checkout_kiosk, DATE_PART('month',...ckout_kiosk, mcheck ORDER BY count(*) desc
Published Membership

SELECT checkout_kiosk, DATE_PART('month',...ckout_kiosk, mcheck ORDER BY count(*) desc
Published Popular bike

SELECT bike, count(*) FROM utdata.bcycletrips GROUP BY bike ORDER BY count(*) desc
Published Duration per membership_type

SELECT count(membership_type), membership...membership_type ORDER BY avg(duration) desc
Published avgg

SELECT DATE_PART AVG('day', checkout_date) ...ckout_time) = '2014' GROUP BY count(*) desc