A dataset with ~10 million rows

Question

I am looking for a dataset with 10 millions of rows to analyze it. Actually to rework it into more usable format and come up with some interesting metrics for it. So there are two requirements:

1) ~10 million rows

2) "Interesting" data to build some metrics on it (like users per country, average temperature in month, average check and so on).

So the question is: where can I find such dataset? I found awesome-public-datasets repo on Github but looks like there is no any classification by data size/format there. If you have any ideas about relevant datasets and where I can find it it would be great.

Answer 1

City bike shares will have about that number of records, and because there will be some geospatial data (latitude/longitude) along with timestamps, it's usually a fun topic to explore

• GitHub list of city bike share data

• Washington DC (Capital Bikeshare) has quite a large bike share system

• Capital Bikeshare CSV Column Descriptions

• Raw data for Capital Bikeshare (by my estimate, 1 MB zipped is about 100k rows of CSV)

Duration - Duration of trip

Start date – Includes start date and time

End date – Includes end date and time

Start station – Includes starting station name and number

End station – Includes ending station name and number

Bike # - Includes ID number of bike used for the trip

Member Type – Lists whether user was a Registered (annual or monthly) or Casual (1 to 5 day) member.

(photo source Wikipedia)