Followers

Showing posts with label database. Show all posts
Showing posts with label database. Show all posts

Wednesday, January 31, 2018

A Hotel Doctor's Database, Part 2


Men travel more than women but are less likely to call a doctor so I’ve seen more women (9833) than men (8483). My database contains 124 patients under age one and seventeen over 90, the oldest 97. The smallest of the small hours are not silent. I’ve made 858 housecalls between midnight and 5 a.m.

My leading diagnosis is the same as that of any family doctor: respiratory infections, 4700 visits. In second place are upset stomachs with vomiting and diarrhea: 2672.

I’ve been around long enough to see 77 patients with chicken pox, another 83 with gout, 12 with mumps, 61 with herpes, 29 with poison ivy, and 149 suffering a kidney stone. Victims of kidney stones rarely delay calling a doctor, and since they are rarely emergencies I visit a fair number.  I’ve seen 82 guests with chest pain and sent fifteen to the hospital. Far more of my 30,000 callers complained of chest pain, but I work hard weed out emergencies over the phone. Those fifteen were mistakes.

My most numerous foreign patients are from Argentina, 1854, barely surpassing Britons at 1821. That’s because South American travel insurers mostly began there and are still mostly based in Buenos Aires. But they are expanding, and since 2000 I’ve seen more Latin American guests from Brazil. 

I’ve cared for guests from Andorra, Tonga, Malta, New Caledonia, and Curacao but not from Latvia, Estonia, Yemen, and half a dozen African nations. Russians didn’t travel until the fall of the Soviet Union. I saw my first in 1991. The Chinese don’t appear until 1998. So far Cuba has sent one.

Six guests died – fortunately none in the room after my visit. One was dead when I arrived. Four died soon after I sent them to the hospital and one after the ER doctor (mistakenly) sent her back. I called the paramedics after examining sixteen guests. To my great distress (because that means no payment) paramedics were there when I arrived six times. Many more guests needed attention but weren’t urgent. Leaving after obtaining their promise to go to an emergency room is a bad idea. If the guest decides to wait, and something dreadful happens, I’m the last doctor he or she saw, a situation that focuses the attention of malpractice lawyers. When a guest needs an emergency room, I offer to drive them. I’ve done this 48 times.

28 guests cancelled while I was still driving. 47 weren’t in the room when I arrived. 60 refused to pay. 21 paid with a bad check, but not all were deliberate. I eventually collected on 8. Four times, when I arrived, another doctor was there.  I don’t record guests who get a discount but 173 paid between $5 and $50. 110, mostly hotel employees paid nothing. I will not deny that I have a category for “celebrity.” It has 95 entries although that includes their wives and children. I try to head off drug abusers, but 78 slipped through. The diagnosis on four was “drunk,” but that’s certainly too few.

Saturday, January 27, 2018

A Hotel Doctor's Database, Part 1


Few things besides wine and cheese improve with time, but a personal database is among them.   

It didn’t seem significant when I began in 1983, but now I can look over 18,316 visits. So when I claim to have made more housecalls than any doctor now alive, I have the evidence . It’s a fascinating trove of information. I saw 967 patients from Brazil, for example; 42 of them suffered skin problems. Of those calls from Brazilians, 70 arrived between 11pm and 6am, getting me out of bed.

Of the 18,316 nearly 12,000 (11,849) were of calls directly from a hotel. The remainder came from four other sources. 

The second source is agencies that insure travelers visiting America: 3490 visits. Few come from Europe or Australia whose insurers follow the American strategy of insisting that clients pay up front and apply for reimbursement later. Asian and Latin American carriers do better. Their clients phone the 800 number of the agency’s US office; the agency phones me; I make the housecall and send my invoice to the agency which pays exactly what I bill (American carriers undoubtedly roll their eyes at this archaic behavior).

Inevitably some insurers are less easy to deal with than others. Some have adopted the American system of requiring elaborate forms, itemization, and codes for every procedure. Others pay slowly and only after many pestering phone calls. When my patience runs out, I stop accepting their calls.

This doesn’t mean I stop seeing their clients, because they transfer their business to my third source of calls: competitors with 1760 visits. That includes other Los Angeles hotel doctors who ask my help or cover for me when I’m busy as well as one of the national housecall services. They have names like Expressdoc, AMPM Housecalls, Hoteldoc, Global Med. If you live in a large city, they may be available, but be warned that some are reasonable but others charge fees that will take your breath away.

Foreign airline crew make up the fourth source: 913 visits. American airlines have no interest in crew who fall ill when laying over. They have medical insurance but with no transportation or knowledge of facilities in a strange city, they are out of luck. Occasionally I deal with their pitiful calls and treat them as charity cases. As with American insurance carriers, it’s hopeless to bill an American airline for a housecall. 

A minor fifth category is what I call “private-parties:” 293 visits. These are people who learn about me from another source. That includes locals as well as former patients who return to the city and call me directly.