SafeGraph product image in hero

SafeGraph Spend | Consumer Data| McDonalds and Chipotle | September 2021 | PA, USA

SafeGraph
Start icon5.0(17)Badge iconVerified Data Provider
#
placekey
parent_placekey
top_category
sub_category
region
open_hours
category_tags
opened_on
closed_on
tracking_closed_since
geometry_type
date_range_start
date_range_end
day_counts
raw_total_spend
raw_num_transactions
raw_num_customers
median_spend_per_transaction
median_spend_per_customer
spend_per_transaction_percentiles
spend_by_day
spend_per_transaction_by_day
spend_by_day_of_week
spend_pct_change_vs_prev_month
spend_pct_change_vs_prev_year
online_transactions
online_spend
transaction_intermediary
spend_by_transaction_intermediary
bucketed_customer_frequency
mean_spend_per_customer_by_frequency
bucketed_customer_incomes
mean_spend_per_customer_by_income
customer_home_city
1 xxxxxxxxxx Xxxxxxxxx xxxxxx xxxxxxxxxx Xxxxx Xxxxxx Xxxxxxxxxx Xxxxxx Xxxxxxxxx Xxxxxxxxxx xxxxxxxxx Xxxxxxxxx xxxxxxxxx Xxxxxxx xxxxxx Xxxxx xxxxxxxxxx xxxxxx Xxxxxxxxxx xxxxxx Xxxxx Xxxxxx xxxxx xxxxxxxx xxxxxxx Xxxxx Xxxxxxxx xxxxxxxxxx xxxxxx Xxxxxxxxx xxxxxx Xxxxxxxxx Xxxxxxxxx xxxxxxxxxx Xxxxxx Xxxxx xxxxxx xxxxxxx xxxxxxx Xxxxx xxxxxx Xxxxxxxxxx xxxxxxxx xxxxxx Xxxxx
2 Xxxxxxx xxxxxx Xxxxxxxx Xxxxxxx Xxxxx xxxxxx xxxxxxxxxx Xxxxx xxxxxxxxxx xxxxxxxxx Xxxxxxx xxxxxxxx xxxxxxxx Xxxxxxxxxx Xxxxxxxx Xxxxxxxx xxxxxxxxx Xxxxxxxxxx Xxxxxx Xxxxxxxxx xxxxx xxxxxxx xxxxxxxxx Xxxxxx Xxxxxxx Xxxxxxxxx xxxxxxxxx xxxxxxxxx Xxxxx xxxxxxxx Xxxxxxx xxxxxxxxx Xxxxxxx xxxxx Xxxxxxx xxxxxxx Xxxxx xxxxxxxxxx Xxxxxxx Xxxxx xxxxxxxxxx Xxxxxx xxxxxx Xxxxxxxxx xxxxx
3 Xxxxxxxxxx xxxxxx xxxxx xxxxxxxx Xxxxxx Xxxxxxxxxx xxxxxxxxx Xxxxxxxxxx xxxxxxxx xxxxx Xxxxxx xxxxxxxxxx xxxxxxxxx xxxxx xxxxx xxxxxxxx xxxxxx Xxxxxxxxxx xxxxxxxxxx Xxxxx xxxxxxx Xxxxxxxx Xxxxxxx xxxxx xxxxxxxx xxxxxxxxxx Xxxxxx xxxxxxxxx Xxxxx xxxxx xxxxxxxxx xxxxxxx Xxxxxxxxx Xxxxxxx xxxxxxxxxx Xxxxx xxxxxxxxx xxxxxxx Xxxxxx xxxxxxxxx xxxxx Xxxxxxx xxxxxxxxx Xxxxxxxx xxxxxxxx
4 Xxxxxxxx Xxxxxxxx xxxxxxxx xxxxxxxxx Xxxxxxx Xxxxxxxxx xxxxxxxx xxxxx Xxxxxxxxxx xxxxxxxxxx xxxxxx Xxxxx Xxxxxxx Xxxxx Xxxxxx Xxxxx Xxxxxxxxx xxxxxx xxxxxxxx Xxxxxxxxx Xxxxxx Xxxxxxxxxx Xxxxxx Xxxxx Xxxxxxx xxxxxxxxx Xxxxx xxxxx Xxxxxx xxxxxxxxx xxxxxxx xxxxxxxxx Xxxxxxxxxx xxxxxxxxx Xxxxx Xxxxx Xxxxxxxxx xxxxxxxxxx xxxxxx xxxxxxxxx xxxxxxx Xxxxxxx Xxxxxxxxxx Xxxxxxxxxx Xxxxxxxx
5 Xxxxxxxxx xxxxx Xxxxxxx xxxxxxxxxx Xxxxxxxxx Xxxxxxxx xxxxxxxxxx xxxxxxx Xxxxxxxx xxxxx Xxxxxx xxxxxx xxxxxxxx xxxxxxx Xxxxx Xxxxxxxxx Xxxxx Xxxxxxx Xxxxxxxx xxxxxxxxx xxxxxxxx xxxxx Xxxxxxxxxx Xxxxxxx xxxxxxxxx xxxxxxx xxxxxxxxxx xxxxxx xxxxx Xxxxxxxxxx Xxxxxxxxx xxxxxxx Xxxxxx Xxxxx Xxxxxxxx xxxxxxxxx xxxxxxxx Xxxxxx xxxxxxxxxx xxxxxxxxx xxxxx Xxxxx xxxxxxx xxxxxxxxxx Xxxxxx
6 Xxxxxxxxx xxxxxxx Xxxxxxxx xxxxx xxxxx Xxxxxxxxxx Xxxxxxx Xxxxxxxx Xxxxxxx xxxxx xxxxxxx Xxxxx xxxxxxxxxx Xxxxxxxxxx xxxxxxx Xxxxx xxxxxxxxx xxxxxxxx Xxxxxxxx xxxxxxxx Xxxxxxx Xxxxxx Xxxxxxxxx Xxxxxxxx Xxxxxxxxxx Xxxxxxx Xxxxxx Xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx Xxxxxxx Xxxxx Xxxxx Xxxxx Xxxxxxx xxxxx xxxxxxxxx xxxxxxx Xxxxxxx xxxxxx xxxxxxxxxx xxxxxxxxxx Xxxxxxx xxxxxxxxx Xxxxx
7 xxxxxxx Xxxxxx Xxxxx xxxxxxxxxx xxxxxxxxx Xxxxxxxxxx Xxxxxxxxx Xxxxxxxx xxxxxxxxx Xxxxxxx Xxxxxxx Xxxxx xxxxxxxxxx Xxxxxxxxx Xxxxxxx Xxxxxxx xxxxxxxx xxxxx Xxxxx Xxxxxxxx xxxxxxxx Xxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxx xxxxxxxxx Xxxxxxx Xxxxxxx Xxxxxxx Xxxxxxx xxxxxxx Xxxxxxxxxx xxxxxxxx Xxxxx xxxxxxxxxx xxxxxxxxxx xxxxxx xxxxxxxx Xxxxxxxx xxxxxx xxxxxxxx xxxxxx Xxxxxxxx xxxxxxxxx xxxxx
8 Xxxxxxxxxx Xxxxxxxxx Xxxxxxx xxxxxxxx Xxxxxxx Xxxxxxxxxx Xxxxxxxxx xxxxxxxxxx xxxxxxx Xxxxxxxxx xxxxxxxxx xxxxxxxx xxxxxxxxx xxxxx Xxxxx Xxxxxxxx xxxxxxxxxx Xxxxxx Xxxxxxxxx Xxxxxxxxxx xxxxxxx Xxxxxxxxxx Xxxxxxxxx Xxxxxx xxxxxxxx xxxxxxxxxx xxxxxxxx Xxxxx xxxxxxxx xxxxxxxxxx xxxxxxxx Xxxxx xxxxxxxx xxxxxx Xxxxxxxx xxxxxxxxxx Xxxxxxx xxxxxxxxxx Xxxxxxx Xxxxxxxxx xxxxxx Xxxxx Xxxxx Xxxxxx Xxxxxxxxx
9 Xxxxxxxxx xxxxx Xxxxx Xxxxxxxxxx Xxxxxxx Xxxxxxxxxx Xxxxxxxx xxxxxxx xxxxxxxx Xxxxxx Xxxxxxxxx Xxxxxxxxxx Xxxxxx Xxxxxx Xxxxxxx xxxxxxxxxx Xxxxxxx Xxxxxxxxxx xxxxx xxxxxxx xxxxxxxxx xxxxxxxxx xxxxxx xxxxxx Xxxxxxxxxx xxxxxxxxxx xxxxxxxxx Xxxxxx xxxxxxxxxx Xxxxxxx xxxxxxxxx xxxxxxx Xxxxxxxx Xxxxxxxx Xxxxxxx xxxxxx xxxxx xxxxx Xxxxxxxxx xxxxx Xxxxx Xxxxxx xxxxxxxxxx Xxxxxxxx Xxxxxxxx
10 Xxxxxxxxx Xxxxxxxxxx xxxxxx Xxxxx Xxxxxxxx xxxxxx Xxxxx Xxxxxx xxxxxx xxxxxxxx Xxxxxxxx Xxxxxxxxxx xxxxxxxxxx Xxxxx Xxxxxxx Xxxxxxx Xxxxxx Xxxxxx xxxxxxxx Xxxxxxxxx Xxxxx Xxxxxxx xxxxxxxxx Xxxxxxxxx xxxxxxx Xxxxxxxx Xxxxxxxxxx xxxxxx xxxxxxxxxx xxxxxx xxxxxx Xxxxxxxxxx xxxxxxx Xxxxxxxxxx xxxxx Xxxxxxxxx Xxxxxxx Xxxxxxxxx Xxxxx Xxxxxxxx xxxxxxxxx xxxxxxxxxx xxxxx xxxxxxxxxx xxxxxxx
... xxxxxxxx Xxxxx xxxxx xxxxxx Xxxxxx xxxxxxxxxx xxxxxxxxxx Xxxxxxxxx xxxxxxx Xxxxxxx Xxxxxxxxxx Xxxxxxxx xxxxxx xxxxxx Xxxxxx xxxxxx xxxxx Xxxxxxxxx Xxxxxxxxx Xxxxxx Xxxxx Xxxxxxxxx Xxxxxx Xxxxxx xxxxxx xxxxx xxxxxxx xxxxxxxxxx xxxxxx Xxxxxxx Xxxxx xxxxxxxxxx Xxxxx xxxxxxx xxxxxxx Xxxxxxxxxx Xxxxx xxxxxxx Xxxxxxxx Xxxxxx xxxxxxxxxx Xxxxx Xxxxxxx xxxxx xxxxxx
Sign In To Preview Data
Volume
~ 528
Records
Depth
45
Attributes
Size
2.2 MB
Size
Format
.csv
File
Price
$0.47
per record
Freshness
Jan 2022
last updated

Data Dictionary

Attribute Type Example Mapping
placekey
String [email protected]
parent_placekey
String [email protected]
String McDonald's Location Name
String SG_BRAND_5179b21fc1d50950b99b4eecaa48c614 Brand ID
String McDonald's Brand Name
top_category
String Restaurants and Other Eating Places
sub_category
String Limited-Service Restaurants
Integer 722513 Company NAICS Code
Float 40.336132 Latitude
Float -76.484539 Longitude
String ### * **** *** Address
String Cleona City Name
region
String PA
Integer 17042 Postal Code
String US Country Code Alpha-2
Integer ########### Phone Number
open_hours
String { "Mon": [["7:00", "23:00"]], "Tue": [["7:00", "23:00"]],...
category_tags
String Counter Service,Lunch,Fast Food,Drive Through,Breakfast,D...
opened_on
String
closed_on
String
tracking_closed_since
String 2019-07
geometry_type
String POLYGON
date_range_start
DateTime 2021-09-01T00:00:00-04:00
date_range_end
DateTime 2021-10-01T00:00:00-04:00
day_counts
String {"Wednesday":5,"Monday":4,"Saturday":4,"Thursday":5,"Tues...
raw_total_spend
Float 5478.73
raw_num_transactions
Integer 499
raw_num_customers
Integer 292
median_spend_per_transaction
Float 9.3
median_spend_per_customer
Float 15.08
spend_per_transaction_percentiles
String {"25":5.93,"75":14.61}
spend_by_day
String [146.43,65.69,184.83,1.06,44.75,0.00,894.32,125.23,163.07...
spend_per_transaction_by_day
String [9.09,6.77,9.48,1.06,22.38,null,9.42,8.73,12.07,8.81,23.4...
spend_by_day_of_week
String {"Monday":1794.08,"Tuesday":1414.67,"Wednesday":605.54,"T...
spend_pct_change_vs_prev_month
Integer 2
spend_pct_change_vs_prev_year
Integer 2
online_transactions
Integer 1
online_spend
Float 23.4
transaction_intermediary
String {"No intermediary":498,"Visa":1}
spend_by_transaction_intermediary
String {"No intermediary":5455.33,"Visa":23.40}
bucketed_customer_frequency
String {"1":185,"2":66,"3":21,"4":9,"5-10":11,">10":0}
mean_spend_per_customer_by_frequency
String {"1":11.88,"2":23.99,"3":25.60,"4":35.44,"5-10":76.45,">1...
bucketed_customer_incomes
String {"<25k":48,"25-45k":52,"45-60k":32,"60-75k":28,"75-100k":...
mean_spend_per_customer_by_income
String {"<25k":14.66,"25-45k":18.66,"45-60k":16.03,"60-75k":24.3...
customer_home_city
String {"Lebanon, PA":66,"Avon, PA":39,"Lancaster, PA":16,"Campb...

Details

Aggregated transaction patterns of all the McDonalds and Chipotle restaurants in Pennsylvania. This dataset is one month of credit and debit card patterns of consumer behavior for these locations. For transaction data for more locations, regions, or timeframes, please contact SafeGraph.

Geographical Coverage

North America (1)
United States of America

Category Tags

Similar Datasets

$250.00
excl. taxes
$0.47 per record
Checkout
Instant Delivery

SafeGraph

We predict the past. SafeGraph is the place for data about the physical world.

Verified provider icon Verified Provider
5h Avg. response time
100% Response rate

Trusted by

Customer Logo #1 of SafeGraph
Customer Logo #2 of SafeGraph
Customer Logo #3 of SafeGraph
Contact Provider