### Amazon S3 Data Integration

The following visits data schema refers specifically to the data Foursquare sends via the Amazon S3 integration.

To learn more, please see the [Amazon S3 Data Integration Guide](https://docs.foursquare.com/developer/docs/amazon-s3).

| Field                     | Description                                                                                   | Nullable |
|---------------------------|-----------------------------------------------------------------------------------------------|----------|
| VisitId                   | The ID of the visit                                                                          | N        |
| ConsumerId                | The application’s Foursquare consumerId                                                     | N        |
| ConsumerType              | DeviceOS Type. One of androidSdk or iosSdk                                                  | N        |
| SdkBuild                  | The SDK Build version                                                                        | N        |
| InstallId                 | The unique ID created by Pilgrim for each installation                                        | N        |
| AdId                      | The user ADID                                                                                | Y        |
| ArrivalTime               | Time of the arrival in milliseconds since epoch                                               | N        |
| DepartureTime             | Time of the departure in milliseconds since epoch. Available on exit and historical visit types| N        |
| LocationType              | The type of place the event corresponds to, which is one of: venue, home, work, none, unknown| N        |
| ConfidenceLevel           | The venue confidence level. One of: none, low, med, high                                   | Y        |
| ArrivalLat                | The latitude of the user when they arrived at the place                                      | N        |
| ArrivalLng                | The longitude of the user when they arrived at the place                                     | N        |
| DepartureLat              | The latitude of the user when they departed the place                                        | N        |
| DepartureLng              | The longitude of the user when they departed the place                                       | N        |
| Backfilled                | Whether the visit was backfilled or not: true or false                                       | N        |
| VenueId                   | The venue ID                                                                                 | Y        |
| VenueName                 | The Venue name                                                                                | Y        |
| Address                   | The address of the venue                                                                      | Y        |
| CrossStreet               | The venue cross street                                                                        | Y        |
| City                      | The city of the venue                                                                         | Y        |
| State                     | The state of the venue                                                                        | Y        |
| Zip                       | The zip of the venue                                                                          | Y        |
| CountryCode               | The country code of the venue                                                                 | Y        |
| VenueLat                  | The latitude of the venue center                                                               | Y        |
| VenueLng                  | The longitude of the venue center                                                              | Y        |
| Chain1_id                 | The primary chain Id                                                                          | Y        |
| Chain1                    | The primary chain name                                                                        | Y        |
| Chain2_id                 | The secondary chain Id                                                                        | Y        |
| Chain2                    | The secondary chain name                                                                      | Y        |
| Chain3_id                 | The tertiary chain Id                                                                         | Y        |
| Chain3                    | The tertiary chain name                                                                       | Y        |
| Category_primary_id       | The primary category id                                                                       | Y        |
| Category_primary          | The primary category name                                                                     | Y        |
| Category_secondary_id     | The secondary category id                                                                     | Y        |
| Category_secondary         | The secondary category name                                                                   | Y        |
| Category_tertiary_id      | The tertiary category id                                                                      | Y        |
| Category_tertiary         | The tertiary category name                                                                    | Y        |
| PartnerVenue_Id           | The partner ID from the venue harmonization process                                          | Y        |