Foursquare Open Source Places: A new foundational dataset

It's a bit bothersome they nudge you to install and use aws tools to download the data, instead of providing a plain CSV or JSON downloadable dump instead.

It's S3 so this works to list the bucket contents:

    curl -s "https://fsq-os-places-us-east-1.s3.amazonaws.com/?list-type=2&prefix=release/dt=2024-11-19/places/parquet/&delimiter=/"

And you can download a file called places-00000.snappy.parquet like this:

    curl -O "https://fsq-os-places-us-east-1.s3.amazonaws.com/release/dt=2024-11-19/places/parquet/places-00000.snappy.parquet"

I mean not really, why would you want to direct download a CSV or JSON dump this big