Health Data 101

Here you will find an introduction to each element of healthcare data.

Electronic Health Records

What they are, how are they used, what’s good and bad about them.

What’s blood got to do with it – LOINCs

I describe how laboratory test results are represented –LOINCs – laboratory codes

Types of healthcare data: drug codes

I describe ways drug data is recorded via NDCs, ATCs, GPIs –NDC drug code look up

Ugly side of healthcare data

I describe different types of commonly seen healthcare data errors

Types of healthcare data: procedure codes

Procedure codes are critical for clinical information recording and billing purposes.

  CPT procedure code look up – Pay wall
  CPT procedure code look up – Free

Types of health data – Diagnoses / ICDs

Description of diagnosis codes: the reasons for why a person is ill – ICD look up tool

Sources of Health Data

Description of the main sources of healthcare data

Other tools

Most Useful Excel Formulas There are obviously loads more that Excel offers, but I found that I use these much more frequently than any other formulas.

Most Useful Excel Keyboard Shortcuts: these are the keyboard short cuts that will transform slow/inaccurate mouse clicking to you “flying” around the screen using only keyboard. You will navigate the spreadsheet a lot faster and more accurately.

Kaiser Family Foundation for great health financing data as well as in depth research

MEPS: medical expenditure panel survey

HEDIS