Skip to content

Instantly share code, notes, and snippets.

@cliff145
Last active August 31, 2015 12:31
Show Gist options
  • Select an option

  • Save cliff145/093465bfaf76370c3a1b to your computer and use it in GitHub Desktop.

Select an option

Save cliff145/093465bfaf76370c3a1b to your computer and use it in GitHub Desktop.
Hospital Staffing + Have a Day
Facility BeginDate EndDate County ControlType HoursType ProductiveHours ProductiveHoursPatient
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor Daily Cost Centers 97,925 12.25
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor Management & Supervision 84,775 10.6
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit Daily Cost Centers 172,742 9.08
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Daily Cost Centers 345,127 8.94
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit Registered Nurse 161,559 8.49
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit Ancillary Cost Centers 202,102 7.99
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit Daily Cost Centers 183,345 7.25
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit Technician & Specialist 128,689 6.76
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit General Services Cost Centers 126,937 6.67
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit Ancillary Cost Centers 117,881 6.2
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit Registered Nurse 154,836 6.12
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit Technician & Specialist 133,714 5.29
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Clerical & Other Administrative 186,594 4.83
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit Ambulatory Cost Centers 81,761 4.3
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit Contracted Other 81,592 4.29
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit Aides & Orderlies 108,319 4.28
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor Ancillary Cost Centers 33,083 4.14
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Technician & Specialist 157,691 4.08
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit Clerical & Other Administrative 75,916 3.99
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor Technician & Specialist 31,940 3.99
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Registered Nurse 143,987 3.73
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Management & Supervision 141,701 3.67
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit Clerical & Other Administrative 90,384 3.58
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor Administrative Services Cost Centers 28,108 3.51
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Ancillary Cost Centers 129,292 3.35
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Administrative Services Cost Centers 126,806 3.28
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor General Services Cost Centers 25,967 3.25
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor General Services Cost Centers 114,224 2.96
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Contracted Other 100,647 2.61
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor Environmental & Food Services 20,746 2.59
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit Administrative Services Cost Centers 44,338 2.33
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor Aides & Orderlies 18,464 2.31
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit Fiscal Services Cost Centers 42,510 2.23
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit Environmental & Food Services 41,762 2.2
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit General Services Cost Centers 55,053 2.18
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor Licensed Vocational Nurse 16,312 2.04
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit Aides & Orderlies 38,454 2.02
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Fiscal Services Cost Centers 76,197 1.97
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit Fiscal Services Cost Centers 42,906 1.7
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit Management & Supervision 37,987 1.5
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit Administrative Services Cost Centers 37,754 1.49
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit Ambulatory Cost Centers 36,022 1.42
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Ambulatory Cost Centers 52,247 1.35
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit Contracted Registry Nursing 21,219 1.12
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit Management & Supervision 18,991 1
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Education Cost Centers 38,619 1
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Other 37,294 0.97
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Licensed Vocational Nurse 37,059 0.96
SAN LEANDRO HOSPITAL 1/1/2013 10/30/2013 Alameda Non-Profit Licensed Vocational Nurse 17,987 0.95
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor Clerical & Other Administrative 7,125 0.89
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor Other 6,218 0.78
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Contracted Registry Nursing 29,907 0.77
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Aides & Orderlies 29,276 0.76
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit Licensed Vocational Nurse 18,997 0.75
PACIFIC HOSPITAL OF LONG BEACH 1/1/2013 10/8/2013 Los Angeles Investor Environmental & Food Services 18,356 0.48
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit Other 10,656 0.42
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor Fiscal Services Cost Centers 2,613 0.33
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor Contracted Registry Nursing 1,736 0.22
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit Contracted Registry Nursing 1,856 0.07
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor Registered Nurse 351 0.04
VERDUGO HILLS HOSPITAL 1/1/2013 7/15/2013 Los Angeles Non-Profit Contracted Other 433 0.02
KINDRED HOSPITAL - SACRAMENTO 1/1/2013 8/31/2013 Sacramento Investor Contracted Other 29 0
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Loading CSV Data with D3</title>
<script type="text/javascript" src="http://d3js.org/d3.v3.js"></script>
</head>
<body>
<p><em>Have a day!</em></p>
<svg width="400" height="300" background-color="charcoal">
<circle cx="100" cy="50" r="20" fill="yellow" />
<circle cx="200" cy="50" r="20" fill="yellow" />
<circle cx="150" cy="150" r="10" fill="yellow" />
<line x1="100" y1="225" x2="200" y2="225" stroke="yellow" stroke-width="3" />
<line x1="100" y1="200" x2="100" y2="225" stroke="yellow" stroke-width="3" />
<line x1="200" y1="200" x2="200" y2="225" stroke="yellow" stroke-width="3" />
</svg>
<script type="text/javascript">
//Load in contents of CSV file
d3.csv("hospitalStaffing.csv", function(data) {
//Now CSV contents have been transformed into
//an array of JSON objects.
//Log 'data' to the console, for verification.
console.log(data);
});
</script>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment