| Server IP : 216.92.14.13 / Your IP : 216.73.217.126 Web Server : Apache System : Linux vps4089.pairvps.com 5.15.0-190-generic #200-Ubuntu SMP Fri Aug 7 15:06:04 UTC 2026 x86_64 User : rmlac2fmr ( 1040637) PHP Version : 8.2.32 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/home/rmlac2fmr/ |
Upload File : |
NICKNAMES = {"eddie": "edward", "edward": "eddie", "bill": "william", "william": "bill", "billy": "william", "charlie": "charles", "charles": "charlie", "beth": "elizabeth", "elizabeth": "beth", "biz": "elizabeth", "jc": "jose", "dick": "richard", "ricky": "richard", "rich": "richard", "richard": "ricky", "bob": "robert", "robert": "bob", "rob": "robert", "dan": "daniel", "daniel": "dan", "danny": "daniel", "jim": "james", "james": "jim", "ted": "theodore", "theodore": "ted", "mike": "michael", "michael": "mike", "matt": "matthew", "matthew": "matt", "ben": "benjamin", "benjamin": "ben", "chris": "christopher", "christopher": "chris", "nick": "nicholas", "nicholas": "nick", "pat": "patrick", "patrick": "pat", "len": "leonard", "leonard": "len", "ken": "kenneth", "kenneth": "ken", "joe": "joseph", "joseph": "joe", "jon": "jonathan", "jonathan": "jon", "deb": "deborah", "deborah": "deb", "cyndi": "cynthia", "cynthia": "cyndi", "kat": "katherine", "katherine": "kat", "biff": "walter", "gaff": "garth", "booey": "charles", "ron": "ronald", "ronald": "ron", "allison": "alison", "alison": "allison"}
MASTER = [{"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Fogel", "firstName": "Sean", "firstNameClean": "Sean", "conf": "3490802800/3490809813", "roomCode": "K1RRU1", "checkIn": "2026-06-18", "checkOut": "2026-06-20"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Fogel", "firstName": "Sean", "firstNameClean": "Sean", "conf": "3399777441 / 3470303910", "roomCode": "K1RRU1", "checkIn": "2026-06-26", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Williams", "firstName": "Morgan", "firstNameClean": "Morgan", "conf": "3479990602", "roomCode": "K1", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Chen", "firstName": "Christopher", "firstNameClean": "Christopher", "conf": "3477183648", "roomCode": "K1RL", "checkIn": "2026-06-22", "checkOut": "2026-07-09"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Kopp", "firstName": "Elizabeth (BIz)", "firstNameClean": "Elizabeth", "conf": "3477672138", "roomCode": "K1", "checkIn": "2026-06-18", "checkOut": "2026-07-10"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Taylor", "firstName": "Andrew", "firstNameClean": "Andrew", "conf": "381661712", "roomCode": "", "checkIn": "2026-06-22", "checkOut": "2026-07-12"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Naranjo", "firstName": "Jennifer", "firstNameClean": "Jennifer", "conf": "3477131513", "roomCode": "D2RL", "checkIn": "2026-06-25", "checkOut": "2026-07-06"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Souder", "firstName": "Hylee", "firstNameClean": "Hylee", "conf": "381661749", "roomCode": "", "checkIn": "2026-06-19", "checkOut": "2026-07-10"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Richardson", "firstName": "Joseph", "firstNameClean": "Joseph", "conf": "3475484232", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Thomas", "firstName": "Risa", "firstNameClean": "Risa", "conf": "3482061976", "roomCode": "D2RL", "checkIn": "2026-06-13", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Steinman", "firstName": "Rachel", "firstNameClean": "Rachel", "conf": "3481306239", "roomCode": "D2RL", "checkIn": "2026-06-20", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Zagorsky", "firstName": "Michelle", "firstNameClean": "Michelle", "conf": "3479000919", "roomCode": "K1RL", "checkIn": "2026-06-17", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Absher", "firstName": "Ted", "firstNameClean": "Ted", "conf": "3480146566", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Barrio", "firstName": "Hector", "firstNameClean": "Hector", "conf": "3473347579", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Kenerson", "firstName": "Dana", "firstNameClean": "Dana", "conf": "3476740721", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Macks", "firstName": "Jonathan", "firstNameClean": "Jonathan", "conf": "3401327465", "roomCode": "K1DL", "checkIn": "2026-06-26", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Terzakis", "firstName": "Andrew", "firstNameClean": "Andrew", "conf": "3478284614", "roomCode": "D2", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Jackson/Robinson", "firstName": "Guy/Quan", "firstNameClean": "Guy/Quan", "conf": "3472826229", "roomCode": "D2", "checkIn": "2026-06-28", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Clarke", "firstName": "Jadah", "firstNameClean": "Jadah", "conf": "3477995887", "roomCode": "K1", "checkIn": "2026-06-25", "checkOut": "2026-07-04"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "PRODUCTION", "firstName": "PA 1- Adam Shahen + Ian Bair", "firstNameClean": "PA 1- Adam Shahen + Ian Bair", "conf": "381627972", "roomCode": "", "checkIn": "2026-06-20", "checkOut": "2026-07-09"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "PRODUCTION", "firstName": "PA 2 - Kwame Kumah + Brad Bailey", "firstNameClean": "PA 2 - Kwame Kumah + Brad Bailey", "conf": "381627988", "roomCode": "", "checkIn": "2026-06-21", "checkOut": "2026-07-09"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "PRODUCTION", "firstName": "PA 3 - Ted Williams + Turner Andritz", "firstNameClean": "PA 3 - Ted Williams + Turner Andritz", "conf": "381628339", "roomCode": "", "checkIn": "2026-06-21", "checkOut": "2026-07-09"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "PRODUCTION", "firstName": "PA 4 -Chanel Cook + Freyja Golbach", "firstNameClean": "PA 4 -Chanel Cook + Freyja Golbach", "conf": "381628350", "roomCode": "", "checkIn": "2026-06-21", "checkOut": "2026-07-09"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Event Staff 3", "firstName": "Jirad Goudeaux + Brandon Cassell", "firstNameClean": "Jirad Goudeaux + Brandon Cassell", "conf": "381628108", "roomCode": "", "checkIn": "2026-06-21", "checkOut": "2026-07-09"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "(Razavi/Branden", "firstName": "Jake Fischvogt + Evan Applefeld", "firstNameClean": "Jake Fischvogt + Evan Applefeld", "conf": "381627738", "roomCode": "", "checkIn": "2026-06-21", "checkOut": "2026-07-09"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "transpo 2", "firstName": "Kiara Thomas", "firstNameClean": "Kiara Thomas", "conf": "381628356", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "transpo 3", "firstName": "Caleb Harris/Lorenzo Lane", "firstNameClean": "Caleb Harris/Lorenzo Lane", "conf": "381628368", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Trzcinski", "firstName": "Ryan", "firstNameClean": "Ryan", "conf": "3475562214", "roomCode": "K1", "checkIn": "2026-06-15", "checkOut": "2026-07-06"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Case", "firstName": "Ben", "firstNameClean": "Ben", "conf": "177764677", "roomCode": "", "checkIn": "2026-06-25", "checkOut": "2026-07-07"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Carney", "firstName": "Michael", "firstNameClean": "Michael", "conf": "3403411542", "roomCode": "K1RL", "checkIn": "2026-06-19", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Jovel", "firstName": "Patty", "firstNameClean": "Patty", "conf": "3396827226", "roomCode": "D2RL", "checkIn": "2026-06-28", "checkOut": "2026-07-03"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Mehmedovic", "firstName": "Brittany", "firstNameClean": "Brittany", "conf": "3478245182", "roomCode": "K1", "checkIn": "2026-06-26", "checkOut": "2026-07-04"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Laboy", "firstName": "Valentin", "firstNameClean": "Valentin", "conf": "381662060", "roomCode": "", "checkIn": "2026-06-28", "checkOut": "2026-07-06"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Everly", "firstName": "Jack", "firstNameClean": "Jack", "conf": "3402734228", "roomCode": "K1JL", "checkIn": "2026-06-26", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Odze", "firstName": "Warren", "firstNameClean": "Warren", "conf": "3481397806", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Siegel", "firstName": "Ira", "firstNameClean": "Ira", "conf": "3474950179", "roomCode": "K1", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Wertz", "firstName": "Kimberlee", "firstNameClean": "Kimberlee", "conf": "3478779676", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Norris", "firstName": "Nick", "firstNameClean": "Nick", "conf": "3476597901", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Torpezer", "firstName": "Michael", "firstNameClean": "Michael", "conf": "3480427398", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Gelfand", "firstName": "Gregg", "firstNameClean": "Gregg", "conf": "3395413891 / 3471290947", "roomCode": "K1JL", "checkIn": "2026-06-26", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Diego", "firstName": "Ken", "firstNameClean": "Ken", "conf": "3481781585", "roomCode": "K1", "checkIn": "2026-06-27", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Mischer", "firstName": "Jennifer", "firstNameClean": "Jennifer", "conf": "3480472520", "roomCode": "D2", "checkIn": "2026-06-27", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Natoli", "firstName": "Gary", "firstNameClean": "Gary", "conf": "3394248087", "roomCode": "K1D", "checkIn": "2026-06-28", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Digilio", "firstName": "Phyllis", "firstNameClean": "Phyllis", "conf": "3476539194", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Valk", "firstName": "Eddie", "firstNameClean": "Eddie", "conf": "3476936558", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Gitter", "firstName": "Jeffry", "firstNameClean": "Jeffry", "conf": "3480329700", "roomCode": "D2", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Goldman", "firstName": "Tyler", "firstNameClean": "Tyler", "conf": "3481580058", "roomCode": "D2", "checkIn": "2026-07-01", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Pacella", "firstName": "Jason", "firstNameClean": "Jason", "conf": "3479398283", "roomCode": "D2", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Nunnally", "firstName": "Russell", "firstNameClean": "Russell", "conf": "3473009363", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Parker", "firstName": "Donna", "firstNameClean": "Donna", "conf": "3475529795", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Owgang", "firstName": "Cyndi", "firstNameClean": "Cyndi", "conf": "3473387011", "roomCode": "D2", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Williams", "firstName": "Leslie", "firstNameClean": "Leslie", "conf": "3477216508", "roomCode": "D2", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Anderson", "firstName": "Mike", "firstNameClean": "Mike", "conf": "3475190697", "roomCode": "D2", "checkIn": "2026-06-26", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Sullivan", "firstName": "Chris", "firstNameClean": "Chris", "conf": "3475730881", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-06-30"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Becker", "firstName": "Eric", "firstNameClean": "Eric", "conf": "3474220730", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Wells", "firstName": "Allan", "firstNameClean": "Allan", "conf": "3475868452", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Jones", "firstName": "Guy", "firstNameClean": "Guy", "conf": "3472813967", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Brown", "firstName": "Michael", "firstNameClean": "Michael", "conf": "3480173295", "roomCode": "D2", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Bryan", "firstName": "Mitch", "firstNameClean": "Mitch", "conf": "3481345671", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Tipiere", "firstName": "Jarret", "firstNameClean": "Jarret", "conf": "3480909316", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Chinnock", "firstName": "Duncan", "firstNameClean": "Duncan", "conf": "3479600251", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Daquino", "firstName": "Jaime", "firstNameClean": "Jaime", "conf": "3477991520", "roomCode": "D2", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Cavanaugh", "firstName": "Deb", "firstNameClean": "Deb", "conf": "3479639242", "roomCode": "D2", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Irete", "firstName": "Allison", "firstNameClean": "Allison", "conf": "3482159674", "roomCode": "D2", "checkIn": "2026-07-01", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "King", "firstName": "John Mark", "firstNameClean": "John Mark", "conf": "3479560378", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Baltzell", "firstName": "Patrick", "firstNameClean": "Patrick", "conf": "3397302572", "roomCode": "K1D", "checkIn": "2026-06-28", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Dawes", "firstName": "Walter (Biff)", "firstNameClean": "Walter", "conf": "3478251313", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Gerhard", "firstName": "Dan", "firstNameClean": "Dan", "conf": "3479899035", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Parker", "firstName": "Michael", "firstNameClean": "Michael", "conf": "3477280905", "roomCode": "K1", "checkIn": "2026-06-28", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Bove", "firstName": "Michael", "firstNameClean": "Michael", "conf": "3481357933", "roomCode": "D2", "checkIn": "2026-06-28", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Henig", "firstName": "Alan", "firstNameClean": "Alan", "conf": "3474910306", "roomCode": "K1", "checkIn": "2026-06-28", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Correa", "firstName": "Gabriel", "firstNameClean": "Gabriel", "conf": "3476994383", "roomCode": "D2", "checkIn": "2026-06-28", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Bednar", "firstName": "Brian", "firstNameClean": "Brian", "conf": "3479514815", "roomCode": "D2", "checkIn": "2026-06-28", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Kent", "firstName": "Donald", "firstNameClean": "Donald", "conf": "3481110402", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Gilmour", "firstName": "Richard", "firstNameClean": "Richard", "conf": "3475099130", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Milner", "firstName": "Justin", "firstNameClean": "Justin", "conf": "3478055917", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Weinkam", "firstName": "Steve", "firstNameClean": "Steve", "conf": "3472716269", "roomCode": "K1", "checkIn": "2026-06-30", "checkOut": "2026-07-03"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Campbell", "firstName": "Charlie - Charles", "firstNameClean": "Charlie - Charles", "conf": "3476746852", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Michael", "firstName": "Garth (Gaff)", "firstNameClean": "Garth", "conf": "3480139994", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Reilly", "firstName": "Patricia", "firstNameClean": "Patricia", "conf": "3473692367", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "King", "firstName": "Shawn", "firstNameClean": "Shawn", "conf": "3476649154", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Bates", "firstName": "John", "firstNameClean": "John", "conf": "3475340089", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Saltzer", "firstName": "William (Bill)", "firstNameClean": "William", "conf": "3477860521", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Gonzales", "firstName": "Dylan", "firstNameClean": "Dylan", "conf": "3480375263", "roomCode": "D2", "checkIn": "2026-06-29", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Breckey", "firstName": "Dennis", "firstNameClean": "Dennis", "conf": "3479841210", "roomCode": "D2", "checkIn": "2026-06-29", "checkOut": "2026-07-01"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Velasco", "firstName": "Juan Pablo", "firstNameClean": "Juan Pablo", "conf": "3473829938", "roomCode": "K1", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Schroeder", "firstName": "Brooks", "firstNameClean": "Brooks", "conf": "3474989611", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Gan", "firstName": "Bianca", "firstNameClean": "Bianca", "conf": "3475328268", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Schrader", "firstName": "Christian", "firstNameClean": "Christian", "conf": "3475712047", "roomCode": "D2", "checkIn": "2026-07-01", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Ashton", "firstName": "Theodore (Ted)", "firstNameClean": "Theodore", "conf": "3481925287", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Balton", "firstName": "Daniel", "firstNameClean": "Daniel", "conf": "3477704998", "roomCode": "K1", "checkIn": "2026-06-30", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Gonzalez", "firstName": "Juan", "firstNameClean": "Juan", "conf": "3479743512", "roomCode": "D2", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Breece", "firstName": "Mike", "firstNameClean": "Mike", "conf": "3472423175", "roomCode": "K1", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Breece", "firstName": "Shane", "firstNameClean": "Shane", "conf": "3480518524", "roomCode": "K1", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Haviland", "firstName": "Helene", "firstNameClean": "Helene", "conf": "3480316556", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "O'Donnel", "firstName": "James (Jim)", "firstNameClean": "James", "conf": "3479007491", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Smith", "firstName": "Chad", "firstNameClean": "Chad", "conf": "3473634542", "roomCode": "K1", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Broker", "firstName": "William (Billy)", "firstNameClean": "William", "conf": "3476591329", "roomCode": "K1", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Smith", "firstName": "Ron", "firstNameClean": "Ron", "conf": "3475953006", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Hoover", "firstName": "Jake", "firstNameClean": "Jake", "conf": "3479541544", "roomCode": "K1", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Gutierrez", "firstName": "Manuel", "firstNameClean": "Manuel", "conf": "3478473438", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Heneghan", "firstName": "John", "firstNameClean": "John", "conf": "3476728018", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Cross", "firstName": "Christopher (Rambo)", "firstNameClean": "Christopher", "conf": "3480121160", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Xua", "firstName": "Easter", "firstNameClean": "Easter", "conf": "3474109888", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Renaudin", "firstName": "Mark", "firstNameClean": "Mark", "conf": "3476193965", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Whitman", "firstName": "Mark", "firstNameClean": "Mark", "conf": "3481234829", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Balton", "firstName": "Ryan", "firstNameClean": "Ryan", "conf": "3478675406", "roomCode": "K1", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Jib - Grant", "firstName": "Station Relation 1", "firstNameClean": "Station Relation 1", "conf": "3474311856", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Grant Jib Tech", "firstName": "Station Relation 2", "firstNameClean": "Station Relation 2", "conf": "3476929986", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Kehs", "firstName": "Pat", "firstNameClean": "Pat", "conf": "3478180344", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Aros", "firstName": "Don", "firstNameClean": "Don", "conf": "3479476265", "roomCode": "K1", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Shack", "firstName": "Joe", "firstNameClean": "Joe", "conf": "3472507729", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-03"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Johansson", "firstName": "Rolf", "firstNameClean": "Rolf", "conf": "3476337226", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Hunter", "firstName": "Drew", "firstNameClean": "Drew", "conf": "3478916365", "roomCode": "D2", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Schulleri", "firstName": "Brandon", "firstNameClean": "Brandon", "conf": "3491315814", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Muehlberger", "firstName": "Joshua", "firstNameClean": "Joshua", "conf": "3473216405", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Smith", "firstName": "Rodney Orin", "firstNameClean": "Rodney Orin", "conf": "3488246862", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Webb", "firstName": "Ricky - Richard", "firstNameClean": "Ricky - Richard", "conf": "3478667336", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Hayes", "firstName": "Kevin", "firstNameClean": "Kevin", "conf": "3479410327", "roomCode": "", "checkIn": "2026-06-29", "checkOut": "2026-07-02"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "TECH 1", "firstName": "NEP LED", "firstNameClean": "NEP LED", "conf": "3478554730", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "TECH 2", "firstName": "NEP LED", "firstNameClean": "NEP LED", "conf": "3477040169", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Lubell", "firstName": "Noah", "firstNameClean": "Noah", "conf": "3473344758", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Gary", "firstName": "Peter", "firstNameClean": "Peter", "conf": "3481287405", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Lalumia", "firstName": "Anthony", "firstNameClean": "Anthony", "conf": "3478669275", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Roberts", "firstName": "David", "firstNameClean": "David", "conf": "3479109556", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Flanzbaum", "firstName": "Brian", "firstNameClean": "Brian", "conf": "3473595551", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Chen", "firstName": "Teng", "firstNameClean": "Teng", "conf": "3476552338", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Goldsmith", "firstName": "James", "firstNameClean": "James", "conf": "3474806918", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Harnage", "firstName": "Wayne", "firstNameClean": "Wayne", "conf": "3480505380", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-03"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Barnhart", "firstName": "Robert", "firstNameClean": "Robert", "conf": "3400793412", "roomCode": "K1D", "checkIn": "2026-06-27", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Grill", "firstName": "David", "firstNameClean": "David", "conf": "3479163455", "roomCode": "D2", "checkIn": "2026-06-26", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Brown", "firstName": "Dean", "firstNameClean": "Dean", "conf": "3473152183", "roomCode": "D2", "checkIn": "2026-06-27", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Nowak", "firstName": "Matt", "firstNameClean": "Matt", "conf": "3482120242", "roomCode": "D2", "checkIn": "2026-06-27", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Applefeld", "firstName": "Len", "firstNameClean": "Len", "conf": "3476108970", "roomCode": "D2", "checkIn": "2026-06-27", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Bontrager", "firstName": "Karl", "firstNameClean": "Karl", "conf": "3479065757", "roomCode": "D2", "checkIn": "2026-06-27", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Sturgis", "firstName": "Jacob", "firstNameClean": "Jacob", "conf": "3474057753", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-03"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Halstead", "firstName": "Alex", "firstNameClean": "Alex", "conf": "3476578185", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Callen", "firstName": "Craig", "firstNameClean": "Craig", "conf": "3480407682", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Connolly", "firstName": "Ben", "firstNameClean": "Ben", "conf": "381104173", "roomCode": "", "checkIn": "2026-06-18", "checkOut": "2026-07-08"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Romero", "firstName": "Samuel", "firstNameClean": "Samuel", "conf": "381104141", "roomCode": "", "checkIn": "2026-06-26", "checkOut": "2026-07-08"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Martinez", "firstName": "Gabriel", "firstNameClean": "Gabriel", "conf": "381104234", "roomCode": "", "checkIn": "2026-06-26", "checkOut": "2026-07-08"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Beiter", "firstName": "Vincent", "firstNameClean": "Vincent", "conf": "381627721", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Lagler", "firstName": "Rene", "firstNameClean": "Rene", "conf": "3396488569", "roomCode": "K1", "checkIn": "2026-06-26", "checkOut": "2026-07-05"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Wert", "firstName": "Hans", "firstNameClean": "Hans", "conf": "381103860", "roomCode": "", "checkIn": "2026-06-20", "checkOut": "2026-07-10"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Gorenc", "firstName": "Matthew", "firstNameClean": "Matthew", "conf": "3475294967", "roomCode": "K1", "checkIn": "2026-06-22", "checkOut": "2026-07-09"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Zatarain", "firstName": "Doug", "firstNameClean": "Doug", "conf": "3477815399", "roomCode": "K1", "checkIn": "2026-06-20", "checkOut": "2026-07-09"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Verosky", "firstName": "Neil", "firstNameClean": "Neil", "conf": "177784149", "roomCode": "", "checkIn": "2026-06-21", "checkOut": "2026-07-09"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Sherlinski", "firstName": "Ryan", "firstNameClean": "Ryan", "conf": "177784150", "roomCode": "", "checkIn": "2026-06-21", "checkOut": "2026-07-09"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Verosky", "firstName": "Darren", "firstNameClean": "Darren", "conf": "177784151", "roomCode": "", "checkIn": "2026-06-21", "checkOut": "2026-07-09"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Campusano", "firstName": "Rosanna - Simon/Bryon", "firstNameClean": "Rosanna - Simon/Bryon", "conf": "177784152", "roomCode": "", "checkIn": "2026-06-21", "checkOut": "2026-07-09"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Fender", "firstName": "Thomas", "firstNameClean": "Thomas", "conf": "381662060", "roomCode": "", "checkIn": "2026-06-22", "checkOut": "2026-06-24"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Reigel", "firstName": "Robin", "firstNameClean": "Robin", "conf": "381628405", "roomCode": "", "checkIn": "2026-07-05", "checkOut": "2026-07-09"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Mountain - Driver2 (IN)", "firstName": "", "firstNameClean": "", "conf": "381662087", "roomCode": "", "checkIn": "2026-06-22", "checkOut": "2026-06-24"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Mountain - Driver2 (OUT)", "firstName": "", "firstNameClean": "", "conf": "381661580", "roomCode": "", "checkIn": "2026-07-05", "checkOut": "2026-07-09"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Ground Protection - Out", "firstName": "", "firstNameClean": "", "conf": "381662017", "roomCode": "", "checkIn": "2026-07-06", "checkOut": "2026-07-08"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Josserand", "firstName": "Bill", "firstNameClean": "Bill", "conf": "3476454199", "roomCode": "K1", "checkIn": "2026-06-21", "checkOut": "2026-06-25"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Josserand", "firstName": "Bill", "firstNameClean": "Bill", "conf": "3476265375", "roomCode": "D2", "checkIn": "2026-07-02", "checkOut": "2026-07-08"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Marshall", "firstName": "Sean", "firstNameClean": "Sean", "conf": "3479658517", "roomCode": "D2", "checkIn": "2026-07-03", "checkOut": "2026-07-08"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Beck", "firstName": "Dan", "firstNameClean": "Dan", "conf": "177764678", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Scears", "firstName": "Gary", "firstNameClean": "Gary", "conf": "177764679", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Guerrero", "firstName": "David", "firstNameClean": "David", "conf": "177764680", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Bello", "firstName": "Corey", "firstNameClean": "Corey", "conf": "177784404", "roomCode": "", "checkIn": "2026-06-21", "checkOut": "2026-06-26"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Bello", "firstName": "Corey", "firstNameClean": "Corey", "conf": "177784405", "roomCode": "", "checkIn": "2026-06-29", "checkOut": "2026-07-09"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Jeffers", "firstName": "Jon", "firstNameClean": "Jon", "conf": "177764665", "roomCode": "", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Kober", "firstName": "Charles (Booey)", "firstNameClean": "Charles", "conf": "3478205750", "roomCode": "D2", "checkIn": "2026-06-28", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Foster", "firstName": "David", "firstNameClean": "David", "conf": "3476023975", "roomCode": "D2", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Miller", "firstName": "Bill", "firstNameClean": "Bill", "conf": "3474637369", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Kober", "firstName": "Nicholas", "firstNameClean": "Nicholas", "conf": "3479417117", "roomCode": "D2", "checkIn": "2026-06-28", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Mileshin", "firstName": "Roman - Joseph Lauro", "firstNameClean": "Roman - Joseph Lauro", "conf": "3481501194", "roomCode": "D2", "checkIn": "2026-06-28", "checkOut": "2026-06-29"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Pickell", "firstName": "Jamie", "firstNameClean": "Jamie", "conf": "3480961010", "roomCode": "K1", "checkIn": "2026-06-25", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Pezzoni", "firstName": "Beth", "firstNameClean": "Beth", "conf": "3476069979", "roomCode": "K1", "checkIn": "2026-06-20", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Gorman", "firstName": "Anne", "firstNameClean": "Anne", "conf": "3473803650", "roomCode": "K1", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Dalton", "firstName": "Deb", "firstNameClean": "Deb", "conf": "3472494585", "roomCode": "K1", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Parker", "firstName": "Marla", "firstNameClean": "Marla", "conf": "381662024", "roomCode": "", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Nesby", "firstName": "Stacey & Peter", "firstNameClean": "Stacey & Peter", "conf": "381662106", "roomCode": "", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Colbert", "firstName": "Michael", "firstNameClean": "Michael", "conf": "3398768042", "roomCode": "K1ZLU1", "checkIn": "2026-06-26", "checkOut": "2026-07-07"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Jackson", "firstName": "Jill", "firstNameClean": "Jill", "conf": "3399543054", "roomCode": "K1RL", "checkIn": "2026-06-26", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Maginnis", "firstName": "Anne", "firstNameClean": "Anne", "conf": "3480628484", "roomCode": "K1D", "checkIn": "2026-06-28", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Howard", "firstName": "Jennifer", "firstNameClean": "Jennifer", "conf": "3473744502", "roomCode": "K1D", "checkIn": "2026-06-28", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Marshall", "firstName": "Carol", "firstNameClean": "Carol", "conf": "3481839851", "roomCode": "K1", "checkIn": "2026-06-28", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Belforte", "firstName": "Mia", "firstNameClean": "Mia", "conf": "177764673", "roomCode": "", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "De Boer", "firstName": "Sara", "firstNameClean": "Sara", "conf": "3474976026", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Station Relation 1", "firstName": "TBD", "firstNameClean": "TBD", "conf": "177764674", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Station Relation 2", "firstName": "TBD", "firstNameClean": "TBD", "conf": "177764675", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Kerwin", "firstName": "Chris", "firstNameClean": "Chris", "conf": "3473933290", "roomCode": "K1", "checkIn": "2026-06-07", "checkOut": "2026-06-10"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Kerwin", "firstName": "Chris", "firstNameClean": "Chris", "conf": "3475620921", "roomCode": "K1", "checkIn": "2026-07-03", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Adams/Reed", "firstName": "Jordan/Becky", "firstNameClean": "Jordan/Becky", "conf": "3472696553", "roomCode": "D2", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Jackson", "firstName": "Todd", "firstNameClean": "Todd", "conf": "3476361134", "roomCode": "D2", "checkIn": "2026-06-28", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "GUEST 2", "firstName": "COLBERT - Max Klie", "firstNameClean": "COLBERT - Max Klie", "conf": "3474570592", "roomCode": "K1", "checkIn": "2026-06-26", "checkOut": "2026-07-02"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "GUEST 3", "firstName": "COLBERT", "firstNameClean": "COLBERT", "conf": "3477605361", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Adamec", "firstName": "Melinda", "firstNameClean": "Melinda", "conf": "3479385139", "roomCode": "K1", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Howard", "firstName": "Marilyn", "firstNameClean": "Marilyn", "conf": "3476767009", "roomCode": "D2", "checkIn": "2026-07-01", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Kimm", "firstName": "Steven & Rose", "firstNameClean": "Steven & Rose", "conf": "3482296061", "roomCode": "K1", "checkIn": "2026-07-03", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Winston", "firstName": "Paul", "firstNameClean": "Paul", "conf": "3472618571", "roomCode": "K1DL", "checkIn": "2026-06-01", "checkOut": "2026-07-11"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Woodson", "firstName": "Paul", "firstNameClean": "Paul", "conf": "3478186916", "roomCode": "K1", "checkIn": "2026-06-10", "checkOut": "2026-07-11"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Rosepink", "firstName": "Thomas", "firstNameClean": "Thomas", "conf": "177764657", "roomCode": "", "checkIn": "2026-06-25", "checkOut": "2026-07-06"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Ruebeck", "firstName": "Amy", "firstNameClean": "Amy", "conf": "177764658", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-05"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Seymour", "firstName": "SAMANTHA", "firstNameClean": "SAMANTHA", "conf": "177784403", "roomCode": "", "checkIn": "2026-06-21", "checkOut": "2026-07-09"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Furman & Welsh", "firstName": "Holly Victoria & John", "firstNameClean": "Holly Victoria & John", "conf": "177764659", "roomCode": "", "checkIn": "2026-06-25", "checkOut": "2026-07-06"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Razavi", "firstName": "Branden", "firstNameClean": "Branden", "conf": "177764661", "roomCode": "", "checkIn": "2026-06-25", "checkOut": "2026-07-07"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Lewis", "firstName": "Lamont (THURSTON)", "firstNameClean": "Lamont", "conf": "381662117", "roomCode": "", "checkIn": "2026-06-20", "checkOut": "2026-07-09"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Staff 1", "firstName": "Event", "firstNameClean": "Event", "conf": "381627771", "roomCode": "", "checkIn": "2026-06-21", "checkOut": "2026-07-06"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Staff 2", "firstName": "Event", "firstNameClean": "Event", "conf": "177764664", "roomCode": "", "checkIn": "2026-07-03", "checkOut": "2026-07-04"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Staff 2", "firstName": "Event", "firstNameClean": "Event", "conf": "381627885", "roomCode": "", "checkIn": "2026-07-03", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Hall", "firstName": "Jay", "firstNameClean": "Jay", "conf": "177764660", "roomCode": "", "checkIn": "2026-06-29", "checkOut": "2026-07-06"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Staff 4", "firstName": "Event", "firstNameClean": "Event", "conf": "177764662", "roomCode": "", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Staff 5", "firstName": "Event", "firstNameClean": "Event", "conf": "177764663", "roomCode": "", "checkIn": "2026-07-03", "checkOut": "2026-07-04"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Staff 6", "firstName": "Event", "firstNameClean": "Event", "conf": "381660907", "roomCode": "", "checkIn": "2026-06-21", "checkOut": "2026-07-04"}, {"hotel": "YOTEL Washington DC", "hotel_raw": "YOTEL", "lastName": "Staff 7", "firstName": "Event", "firstNameClean": "Event", "conf": "381660946", "roomCode": "", "checkIn": "2026-06-26", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Artley", "firstName": "Kathy", "firstNameClean": "Kathy", "conf": "177764666", "roomCode": "", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Chandekar", "firstName": "Chandani", "firstNameClean": "Chandani", "conf": "177764667", "roomCode": "", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Drake", "firstName": "Wendy", "firstNameClean": "Wendy", "conf": "177764668", "roomCode": "", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Maltese", "firstName": "Sophie", "firstNameClean": "Sophie", "conf": "177764669", "roomCode": "", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Gitelson Krauth", "firstName": "Deborah", "firstNameClean": "Deborah", "conf": "177764670", "roomCode": "", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Jones", "firstName": "Angela", "firstNameClean": "Angela", "conf": "177764671", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Ozolins", "firstName": "Lillian", "firstNameClean": "Lillian", "conf": "177764672", "roomCode": "", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "ROOM HOLD 1", "firstName": "Ada", "firstNameClean": "Ada", "conf": "3400311494", "roomCode": "K1RRC", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "ROOM HOLD 2", "firstName": "Ada", "firstNameClean": "Ada", "conf": "3397602238", "roomCode": "K1RRC", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "ROOM HOLD 3", "firstName": "Ada", "firstNameClean": "Ada", "conf": "3401334037", "roomCode": "K1RRC", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "ROOM HOLD 4", "firstName": "Ada", "firstNameClean": "Ada", "conf": "3399490919", "roomCode": "K1RRC", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "ROOM HOLD 5", "firstName": "Ada", "firstNameClean": "Ada", "conf": "3393720606", "roomCode": "K1RRC", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "ROOM HOLD 6", "firstName": "Ada", "firstNameClean": "Ada", "conf": "3397888760", "roomCode": "K1RRC", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "ROOM HOLD 7", "firstName": "Ada", "firstNameClean": "Ada", "conf": "3393961565", "roomCode": "K1RRC", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "ROOM HOLD 8", "firstName": "Ada", "firstNameClean": "Ada", "conf": "3402395571", "roomCode": "K1RRC", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "olympians 1", "firstName": "olympians 1", "firstNameClean": "olympians 1", "conf": "177764391", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "olympians 2", "firstName": "olympians 2", "firstNameClean": "olympians 2", "conf": "177764392", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "olympians 3", "firstName": "olympians 3", "firstNameClean": "olympians 3", "conf": "177764393", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "olympians 4", "firstName": "olympians 4", "firstNameClean": "olympians 4", "conf": "177764394", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "olympians 5", "firstName": "olympians 5", "firstNameClean": "olympians 5", "conf": "177764395", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "olympians 6", "firstName": "olympians 6", "firstNameClean": "olympians 6", "conf": "177764396", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "olympians 7", "firstName": "olympians 7", "firstNameClean": "olympians 7", "conf": "177764397", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "olympians 8", "firstName": "olympians 8", "firstNameClean": "olympians 8", "conf": "177764398", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "olympians 9", "firstName": "olympians 9", "firstNameClean": "olympians 9", "conf": "177764399", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "olympians 10", "firstName": "olympians 10", "firstNameClean": "olympians 10", "conf": "177764400", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "olympians 11", "firstName": "olympians 11", "firstNameClean": "olympians 11", "conf": "177764401", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "olympians 12", "firstName": "olympians 12", "firstNameClean": "olympians 12", "conf": "177764402", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "WADE", "firstName": "SARAH", "firstNameClean": "SARAH", "conf": "3473660389", "roomCode": "D2", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Johnson", "firstName": "Ted", "firstNameClean": "Ted", "conf": "3475814112", "roomCode": "K1", "checkIn": "2026-06-29", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Brayshaw", "firstName": "Camille", "firstNameClean": "Camille", "conf": "3474871756", "roomCode": "D2", "checkIn": "2026-07-01", "checkOut": "2026-07-05"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "McKeown", "firstName": "Scott - Chris Custer", "firstNameClean": "Scott - Chris Custer", "conf": "", "roomCode": "K1", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Green", "firstName": "Andrew", "firstNameClean": "Andrew", "conf": "3475325622", "roomCode": "K1", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Brehm", "firstName": "Kelly", "firstNameClean": "Kelly", "conf": "3473632337", "roomCode": "K1", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Ariano", "firstName": "Brian", "firstNameClean": "Brian", "conf": "3481291331", "roomCode": "K1", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Frantz", "firstName": "Ryan", "firstNameClean": "Ryan", "conf": "3482066343", "roomCode": "K1", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "Hilton Washington DC Capitol Hill", "hotel_raw": "HILTON", "lastName": "Lidle", "firstName": "Brydon - Noah Golden", "firstNameClean": "Brydon - Noah Golden", "conf": "3475618716", "roomCode": "K1", "checkIn": "2026-07-02", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Fritch", "firstName": "Jessika & Jesse", "firstNameClean": "Jessika & Jesse", "conf": "177764653", "roomCode": "", "checkIn": "2026-06-29", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Vargo", "firstName": "Josh", "firstNameClean": "Josh", "conf": "177764654", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Houghten", "firstName": "Russell", "firstNameClean": "Russell", "conf": "177764655", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "The Royal Sonesta Washington, DC Capitol Hill", "hotel_raw": "SONESTA", "lastName": "Anton Eye 4", "firstName": "Anton Eye 4", "firstNameClean": "Anton Eye 4", "conf": "177764656", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Finneran", "firstName": "Joseph", "firstNameClean": "Joseph", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Scrivner", "firstName": "Andrew", "firstNameClean": "Andrew", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Kaufman", "firstName": "Quinn", "firstNameClean": "Quinn", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Mason", "firstName": "Wyatt", "firstNameClean": "Wyatt", "conf": "", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Gordon", "firstName": "Dean", "firstNameClean": "Dean", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Goldman", "firstName": "Tyler", "firstNameClean": "Tyler", "conf": "", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Dal", "firstName": "Ummer", "firstNameClean": "Ummer", "conf": "", "roomCode": "", "checkIn": "", "checkOut": ""}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Sullivan", "firstName": "Chris", "firstNameClean": "Chris", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Castro", "firstName": "JC", "firstNameClean": "JC", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Crawford", "firstName": "David", "firstNameClean": "David", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Bode", "firstName": "Ryan", "firstNameClean": "Ryan", "conf": "", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Breckey", "firstName": "Dennis", "firstNameClean": "Dennis", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Ferris", "firstName": "Jorge", "firstNameClean": "Jorge", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Balton", "firstName": "Rob", "firstNameClean": "Rob", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Balton", "firstName": "Dustin", "firstNameClean": "Dustin", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Kallergis", "firstName": "Kat", "firstNameClean": "Kat", "conf": "", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Bilyavskiy", "firstName": "Stas", "firstNameClean": "Stas", "conf": "", "roomCode": "", "checkIn": "2026-07-01", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Tabkum", "firstName": "Nava", "firstNameClean": "Nava", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Perez", "firstName": "Oscar", "firstNameClean": "Oscar", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Haber", "firstName": "Evan", "firstNameClean": "Evan", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}, {"hotel": "TownePlace Suites by Marriott Alexandria Fort Belvoir", "hotel_raw": "TownePlace Suites", "lastName": "Wilson", "firstName": "Michael", "firstNameClean": "Michael", "conf": "", "roomCode": "", "checkIn": "2026-06-30", "checkOut": "2026-07-04"}]
import json, re
from collections import Counter
def norm_last(s):
s = s.lower().strip().replace('.', '').replace("'", "").replace(',', '')
s = re.sub(r'\b(jr|sr|ii|iii|iv|v)\b', '', s).strip()
s = re.sub(r'\s+', ' ', s)
return s
def norm_last_compact(s):
return norm_last(s).replace(' ', '')
def norm_first(s):
s = re.sub(r'\s*\([^)]*\)', '', s).strip()
if ' - ' in s:
parts = s.split(' - ')
return parts[0].strip().lower()
s = re.sub(r'\s+[A-Za-z]$', '', s).strip()
return s.lower().strip()
def get_first_variants(s):
s_orig = re.sub(r'\s*\([^)]*\)', '', s).strip()
variants = set()
if ' - ' in s_orig:
for part in s_orig.split(' - '):
p = part.strip().lower()
if p: variants.add(p)
if p in NICKNAMES: variants.add(NICKNAMES[p])
else:
p = re.sub(r'\s+[A-Za-z]$', '', s_orig).strip().lower()
variants.add(p)
if p in NICKNAMES: variants.add(NICKNAMES[p])
return variants
def first_match(person_first, master_first, master_raw, aka=''):
pf = re.sub(r'\s+[A-Za-z]$', '', person_first).strip().lower()
pf_nick = NICKNAMES.get(pf, '')
aka_l = (aka or '').lower().strip()
master_variants = get_first_variants(master_raw)
for mv in master_variants:
if pf == mv: return True
if pf_nick and pf_nick == mv: return True
if aka_l and aka_l == mv: return True
if len(pf) >= 3 and len(mv) >= 3:
if pf.startswith(mv) or mv.startswith(pf): return True
if pf_nick and len(pf_nick) >= 3 and len(mv) >= 3:
if pf_nick.startswith(mv) or mv.startswith(pf_nick): return True
return False
def last_match(ops_last, master_last):
ol = norm_last(ops_last)
ml = norm_last(master_last)
olc = norm_last_compact(ops_last)
mlc = norm_last_compact(master_last)
if ol == ml or olc == mlc: return True
if ' ' in ol:
for part in ol.split():
if part == ml or part == mlc: return True
if ' ' in ml:
for part in ml.split():
if part == ol or part == olc: return True
return False
HOTEL_MAP = {
'HILTON': 'Hilton Washington DC Capitol Hill',
'YOTEL': 'YOTEL Washington DC',
'SONESTA': 'The Royal Sonesta Washington, DC Capitol Hill',
'TownePlace Suites': 'TownePlace Suites by Marriott Alexandria Fort Belvoir',
}
db = json.load(open("/home/rmlac2fmr/public_html/jn.com/ops/data/db.json"))
persons = {p["id"]: p for p in db.get("persons", [])}
s3_trs = {}
for r in db.get("travelRequests", []):
if r.get("showId") == "S3":
pid = r.get("personId", "")
if pid not in s3_trs: s3_trs[pid] = []
s3_trs[pid].append(r)
existing_hb = [h for h in db.get("hotelBookings", []) if h.get("showId") == "S3"]
matched_with_tr = []
matched_no_tr = []
not_found = []
ambiguous = []
person_stays = {}
for rec in MASTER:
ml = rec["lastName"]
mf_raw = rec["firstName"]
name = f"{rec['lastName']}, {rec['firstName']}"
matches = []
for p in db.get("persons", []):
if last_match(p.get("lastName",""), ml) and first_match(p.get("firstName",""), rec["firstNameClean"], mf_raw, p.get("aka","")):
matches.append(p)
if len(matches) == 0:
not_found.append({"name": name, "hotel": rec["hotel_raw"], "dates": f"{rec['checkIn']}-{rec['checkOut']}"})
elif len(matches) > 1:
ambiguous.append({"name": name, "hotel": rec["hotel_raw"], "matches": [f"{m['firstName']} {m['lastName']} ({m['id']})" for m in matches]})
else:
person = matches[0]
pid = person["id"]
trs = s3_trs.get(pid, [])
if not trs:
matched_no_tr.append({"name": name, "hotel": rec["hotel_raw"], "personId": pid, "dates": f"{rec['checkIn']}-{rec['checkOut']}"})
else:
key = pid
if key not in person_stays: person_stays[key] = []
person_stays[key].append(rec)
matched_with_tr.append({
"name": name, "hotel": rec["hotel"], "personId": pid,
"conf": rec["conf"], "roomCode": rec["roomCode"],
"checkIn": rec["checkIn"], "checkOut": rec["checkOut"],
})
multi_pids = {k for k, v in person_stays.items() if len(v) > 1}
multi_stay = []
for pid in multi_pids:
stays = person_stays[pid]
p = persons.get(pid, {})
multi_stay.append({"name": f"{p.get('lastName','')}, {p.get('firstName','')}", "personId": pid,
"stays": [{"hotel": s["hotel"], "dates": f"{s['checkIn']}-{s['checkOut']}"} for s in stays]})
matched_pids = set(r["personId"] for r in matched_with_tr) | set(r["personId"] for r in matched_no_tr)
orphan_bookings = [h for h in existing_hb if h.get("personId") not in matched_pids]
print("=" * 60)
print("HOTEL REBUILD DRY RUN v2 — ACF2026")
print("=" * 60)
print(f"\nMASTER RECORDS: {len(MASTER)}")
print(f"MATCHED WITH TR: {len(matched_with_tr)} (will import)")
print(f"MATCHED NO TR: {len(matched_no_tr)} (will skip)")
print(f"NOT FOUND: {len(not_found)}")
print(f"AMBIGUOUS: {len(ambiguous)}")
print(f"MULTI-STAY: {len(multi_stay)} people")
print(f"ORPHAN BOOKINGS TO DELETE: {len(orphan_bookings)}")
if not_found:
print(f"\n--- NOT FOUND ({len(not_found)}) ---")
for r in not_found: print(f" {r['name']} ({r['hotel']}, {r['dates']})")
if ambiguous:
print(f"\n--- AMBIGUOUS ({len(ambiguous)}) ---")
for r in ambiguous: print(f" {r['name']}: {r['matches']}")
if matched_no_tr:
print(f"\n--- MATCHED BUT NO ACF TR ({len(matched_no_tr)}) ---")
for r in matched_no_tr: print(f" {r['name']} ({r['hotel']}, {r['dates']})")
if multi_stay:
print(f"\n--- MULTI-STAY ({len(multi_stay)}) ---")
for r in multi_stay:
print(f" {r['name']} ({r['personId']}):")
for s in r["stays"]: print(f" {s['hotel']}: {s['dates']}")
if orphan_bookings:
print(f"\n--- ORPHAN BOOKINGS TO DELETE ({len(orphan_bookings)}) ---")
for h in orphan_bookings:
p = persons.get(h.get("personId",""), {})
name = f"{p.get('lastName','')}, {p.get('firstName','')}" if p else h.get("personId","?")
print(f" {name}: {h.get('hotel','?')} {h.get('checkIn','')}-{h.get('checkOut','')} (ID: {h['id']})")