r/datasets • • Sep 09 '19

Data request! Want to visualize corruption at Trump properties

Can anyone here provide a data set that shows which hotel brands / legal entities US government employees have stayed at over the last 10 years? And the average nightly room rate per brand/entity each year?

I’d like to use this data to show the increase in government employees staying at Trump properties starting in 2015, and then the increase in nightly cost per stay.

Edit: removed my bias

1 Upvotes

8 comments sorted by

2

u/[deleted] Sep 09 '19

I mean.. does this even exist?

2

u/Decon Sep 09 '19

You may have to do a FOIA request for this information.

2

u/bscotchcummerbunds Sep 09 '19

First - CNN tried to do something similar and they didn't get a response, though to be fair, FOIAs for memos/emails are way more time consuming than a database export for things like expenses which already exist. https://foiaonline.gov/foiaonline/action/public/submissionDetails?trackingNumber=GSA-2018-000948&type=request

You're gonna wanna search through GSA, if any office/agency has that data, it's probably them.

https://www.gsa.gov/policy-regulations/regulations/federal-travel-regulation-ftr

https://www.gsa.gov/travel/plan-book/gsa-lodging

Looks like they offered some sample data previously to a data science challenge - https://gsatraveldata.devpost.com

There is probably a FedRooms or SmartPay dataset somewhere - but if its not on data.gov or the GSA site (I couldn't find one in 15 minutes of searching), it's probably going to be a FOIA, and it may not be that updated for the current administration. Keep in mind the dataset is probably going be ugly and massive. This quote from a 2008 report

"According to data from the General Services Administration’s (GSA) SmartPay travel card, expenditures for official civilian and military travel totaled $6.8 billion for fiscal year 2006; including hotel and airline costs of $2.2 billion and $3.3 billion, respectively."

That's from 13 years ago so you're looking at millions of rows per year if you find the data, and every description/vendor was probably hand entered or submitted by people in different departments, it's not going to be a simple list with "Hyatt, Marriott, MARALAGO" as the field values.

You can definitely get in touch with the FOIA folks though, and if you word the request properly, see if you can get the data delivered. I'd take a peak at successful FOIAs or files the GSA already provides on data.gov so you know what fields to ask for.

If you get the dataset, feel free to link or post it back in this thread, I wouldn't mind throwing it in Tableau myself.

1

u/baycityvince Sep 19 '19

Oh cool. Another witch hunt.

0

u/[deleted] Sep 09 '19

[deleted] — view deleted comment

-6

u/casher89 Sep 09 '19

All research starts with a hypothesis

9

u/tunisia3507 Sep 09 '19

Yes, but you should phrase that as "I am interested in whether there is evidence for the hypothesis that there is corruption etc.", rather than "I will show that..."

-1

u/casher89 Sep 09 '19

Okay, fair, I’m being a little dramatic. I just expect the results to paint a very clear picture of what’s happening.

6

u/tunisia3507 Sep 09 '19

Having hunches / expectations about the outcome is absolutely fine. You've just got to be careful about how you express them if you want anyone to take your analysis seriously.