Atul Gawande “How do we heal medicine?”

Cowboys vs Pit Crews

Key facts from his recent TED talk…

  • Modern doctors have 4000 procedures and 6000 medications at their disposal
  • In 1970 it took 2 FTEs to care for a patient in the hospital
  • In 2001 it took 15 FTEs to care for the same patient
  • Checklists and mandatory pauses help decrease mistakes

“We are all specialists now, even primary care physicians.”

To sum up his talk in two words, both the Intensity and Complexity of care have increased in the past forty years. This is not surprising when you think about it. What aspect of life in the US has not become more intense and complex? He focuses on how the education of physicians lags behind the realities of team-based care. This is a valid point as far as it goes. He does not speculate on why “even primary care physicians” are specialists and no one is charged with understanding the entire spectrum of care for individual patients? (So I will…) In a word, Economics! During the 1990s Medicare and other payers decided to stop paying for coordination of care by primary care physicians. This was exacerbated by division of outpatient and inpatient care in the past ten years (again primarily for economic reasons). The new focus on high-volume, episodic care leaves little time for the big picture. This is not a flaw in medical education and not a choice made by primary care physicians! Merely the predictable consequence of decisions made by insurers and the federal government.

Timezone Solution for mySQL

I am new to SQL languages and I recently spent about two hours trying to bring some order to timestamps in my PTM project. It was obvious that I should store universal UTC/GMT date/times in the database. It was not so clear how to convert these back to local time. Examples I found on the web were all commands typed at the mysql prompt, not database queries. After quite a bit of poking around I finally stumbled on the AS Keyword in mySQL. Seems to work well so I decided to share the solution here for the next newbie to learn from!

SELECT id, date, CONVERT_TZ(date,'+00:00','-04:00') AS corrected_date
FROM `some_table`
WHERE some_criteria = 'something'

This yields output that is nicely localized and completely abstracted from the actual data. Notice that the line for id=27 handles midnight properly.

Output
id date corrected_date
1 2012-06-24 11:46:15 2012-06-24 07:46:15
21 2012-04-23 18:22:21 2012-04-23 14:22:21
28 2011-06-24 11:12:44 2011-06-24 07:12:44
27 2012-04-23 01:53:51 2012-04-22 21:53:51
29 0000-00-00 00:00:00 NULL
30 2012-06-24 00:00:00 2012-06-23 20:00:00
10 2012-06-12 17:12:37 2012-06-12 13:12:37
31 2012-05-06 13:14:35 2012-05-06 09:14:35