Listing all records

Displaying records 3201 through 3300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547838 Postpartum Albany OREGON 12 Hour Day/Night Rotate
547845 Med Surg Portland OREGON 12 Hour Nights
547848 CNA Portland OREGON 12 Hour Nights
547895 OR Coos Bay OREGON 10 Hour Days
546381 Paramedic Lewisburg PENNSYLVANIA 12 Hour Day/Night Rotate
546415 Oncology York PENNSYLVANIA Varied
546470 ICU East Norriton PENNSYLVANIA 12 Hour Days
546471 Respiratory Therapist East Norriton PENNSYLVANIA 12 Hour Nights
546472 Respiratory Therapist East Norriton PENNSYLVANIA 12 Hour Days
546698 ICU East Norriton PENNSYLVANIA 12 Hour Nights
546925 ER East Norriton PENNSYLVANIA 12 Hour Nights
546973 Interventional Radiology Tech York PENNSYLVANIA 8 Hour Days
547117 Cardiovascular York PENNSYLVANIA 12 Hour Day/Night Rotate
547682 Echo Technologist Chambersburg PENNSYLVANIA Varied
547697 PT Norristown PENNSYLVANIA Days
547745 SLP Philadelphia PENNSYLVANIA Days
547777 Histology Technician State College PENNSYLVANIA Days
547791 Certified Surgical Tech State College PENNSYLVANIA 8 Hour Days
547881 Wound Care State College PENNSYLVANIA 8 Hour Days
547884 Clinic State College PENNSYLVANIA Days
547910 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
547911 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
547913 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Days
547949 PT Philadelphia PENNSYLVANIA Varied
548014 Long Term Care Kane PENNSYLVANIA 12 Hour Nights
548195 Surgical Tech CVOR York PENNSYLVANIA 12 Hour Days CST/Certified Surgical Technician
540516 RRT- Respiratory Chambersburg PENNSYLVANIA 12 Hour Day/Night Rotate
541392 OR East Norriton PENNSYLVANIA 8 Hour Days
542040 Physician PHiladelphia PENNSYLVANIA 8 Hour Days
542049 Surgical Tech CVOR York PENNSYLVANIA 12 Hour Days
544104 OR Langhorne PENNSYLVANIA 12 Hour Nights
543765 ER Bristol PENNSYLVANIA 12 Hour Nights
543766 ER Bristol PENNSYLVANIA 12 Hour Nights
543881 Cath Lab Philadelphia PENNSYLVANIA 10 Hour Days
543882 ER Philadelphia PENNSYLVANIA 12 Hour Nights
543884 ICU Philadelphia PENNSYLVANIA 12 Hour Days
544376 Sterile Processing Technician Langhorne PENNSYLVANIA Nights
545452 ER Bristol PENNSYLVANIA 12 Hour Nights
530562 CT Tech Camp Hill PENNSYLVANIA 10 Hour Nights
530585 PTA Yeadon PENNSYLVANIA Days
534798 MRI Tech Langhorne PENNSYLVANIA 8 Hour Evenings
534255 Electrophysiology York PENNSYLVANIA 12 Hour Days
534528 Social Worker Johnston PENNSYLVANIA 8 Hour Days
536437 Cath Lab York PENNSYLVANIA 12 Hour Days
538176 Med Surg Waynesboro PENNSYLVANIA 12 Hour Day/Night Rotate
538557 PT Orwigsburg PENNSYLVANIA Days
538599 PT Springfield PENNSYLVANIA Days
539320 Oncology York PENNSYLVANIA 12 Hour Day/Night Rotate
539896 Ultrasound Tech York PENNSYLVANIA 12 Hour Day/Night Rotate
539898 Cardiovascular York PENNSYLVANIA Nights
539939 CNA Philipsburg PENNSYLVANIA 8 Hour Evenings
527231 PT North Kingstown RHODE ISLAND Days
527487 PTA North Providence RHODE ISLAND Days
541635 Case Manager Woonsocket RHODE ISLAND 8 Hour Days
542605 Surgical Tech Woonsocket RHODE ISLAND 8 Hour Days
543740 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Nights
543779 OR Woonsocket RHODE ISLAND 8 Hour Days
543780 OR Woonsocket RHODE ISLAND 8 Hour Days
543782 CT Tech Woonsocket RHODE ISLAND 8 Hour Nights
543784 GI Lab Woonsocket RHODE ISLAND 8 Hour Days
543786 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Days
546473 Cath Lab Woonsocket RHODE ISLAND 10 Hour Days
547811 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Days
547812 ICU Woonsocket RHODE ISLAND 12 Hour Nights
547813 Case Manager Woonsocket RHODE ISLAND 8 Hour Days
546358 Cardiac ICU Rock Hill SOUTH CAROLINA 12 Hour Nights
546389 RAD Tech Greenville SOUTH CAROLINA 8 Hour Days
547021 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
547022 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
547100 Therapy Rehab Abbeville SOUTH CAROLINA 8 Hour Days
547255 CT Tech Mullins SOUTH CAROLINA 12 Hour Nights
547651 Med Surg Tele Spartanburg SOUTH CAROLINA 12 Hour Nights
547652 Echo Columbia SOUTH CAROLINA 8 Hour Days
547723 Med Surg Georgetown SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
547865 Certified Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
541026 RAD Tech Charleston SOUTH CAROLINA 12 Hour Nights
542353 Therapy Rehab Inman SOUTH CAROLINA Days
542653 Telemetry Charleston SOUTH CAROLINA 12 Hour Nights
542718 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
542822 Therapy Rehab Cheraw SOUTH CAROLINA Days
543252 Telemetry Rock Hill SOUTH CAROLINA 12 Hour Nights
515505 PT Scranton SOUTH CAROLINA Days
521068 Echo Columbia SOUTH CAROLINA 8 Hour Days
526359 Step Down Orangeburg SOUTH CAROLINA 12 Hour Varied
530909 SLP Chesnee SOUTH CAROLINA Days
531763 PT Inman SOUTH CAROLINA Days
547982 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
547983 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
547998 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
547999 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
548023 LPN/LVN Mullins SOUTH CAROLINA 12 Hour Nights
548091 OR Columbia SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
548218 Med Surg Tele Travelers Rest SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
545291 PCU Rock Hill SOUTH CAROLINA 12 Hour Nights
545331 PT Sumter SOUTH CAROLINA Days
545332 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
545482 PCU Lancaster SOUTH CAROLINA 12 Hour Nights
545486 RAD Tech Florence SOUTH CAROLINA 8 Hour Days
545539 Interventional Radiology Tech Columbia SOUTH CAROLINA 8 Hour Days
545616 Med Surg Lancaster SOUTH CAROLINA 12 Hour Nights
Slow: select count(*) from joborders a left join specialties b on a.specialty=b.id left join shifts c on a.shift=c.id left join job_titles d on a.title=d.id left join hospital z on z.id=a.hospital_id left join states y on y.id=z.state where closed=0 in 1.652 seconds
Slow: select a.id,a.id,b.name as specialty,c.name as shift,d.name as title,z.city,y.name as state from joborders a left join specialties b on a.specialty=b.id left join shifts c on a.shift=c.id left join job_titles d on a.title=d.id left join hospital z on z.id=a.hospital_id left join states y on y.id=z.state where closed=0 order by y.name asc limit 3200,100 in 1.7006 seconds