Listing all records

Displaying records 1 through 100 out of a total 3,709 records. Next

ID Job Specialty City State Shift Title
531244 ICU   CALIFORNIA 12 Hour Days RN/Registered Nurse
543454 Home Health Fargo NORTH DAKOTA 8 Hour Day/Night Rotate
538434 Nuclear Med Technician Janesville WISCONSIN 8 Hour Days
538892 Med Surg Janesville WISCONSIN 12 Hour Nights
543041 Oncology Janesville WISCONSIN Varied
536307 MRI Tech Janesville WISCONSIN 8 Hour Days
546703 CT Tech Kremmling COLORADO 12 Hour Days
547100 Therapy Rehab Abbeville SOUTH CAROLINA 8 Hour Days
548018 MLT Aberdeen WASHINGTON 10 Hour Nights
547878 Echo Technologist Abilene TEXAS 12 Hour Day/Night Rotate
547456 Neuro Med Surg/Tele Abilene TEXAS 12 Hour Nights
547458 Outpatient Clinic Abilene TEXAS 10 Hour Day/Night Rotate
547452 Rehab Abilene TEXAS 12 Hour Day/Night Rotate
547490 Pharmacist Abilene TEXAS 12 Hour Days
547451 LPN/LVN Abilene TEXAS 8 Hour Day/Night Rotate
548158 Scrub Tech Abilene TEXAS 8 Hour Days CST/Certified Surgical Technician
547457 ICU Abilene TEXAS 12 Hour Nights
548021 PCU Abilene TEXAS 12 Hour Nights
547459 PCU Abilene TEXAS 12 Hour Day/Night Rotate
548309 ER Abilene TEXAS 12 Hour Day/Night Rotate RN/Registered Nurse
547460 MRI Tech Abilene TEXAS 8 Hour Days
547455 PCU Abilene TEXAS 12 Hour Days
547454 ICU Abilene TEXAS 12 Hour Day/Night Rotate
547453 Surgical Tech CVOR Abilene TEXAS 8 Hour Days
543484 Certified Surgical Tech Abingdon VIRGINIA 8 Hour Day/Night Rotate
545336 Ultrasound Tech Abingdon VIRGINIA 12 Hour Days
539656 Med Surg Abingdon VIRGINIA 12 Hour Nights
548394 OR Abingdon VIRGINIA 8 Hour Day/Night Rotate RN/Registered Nurse
539652 Med Surg Abingdon VIRGINIA 12 Hour Days
539658 OR Abingdon VIRGINIA 8 Hour Day/Night Rotate
547557 CT Tech Akron OHIO 12 Hour Days
540637 PT Akron OHIO 8 Hour Days
544627 Med Surg Tele Akron OHIO 12 Hour Nights
517854 CT Tech Akron OHIO 10 Hour Days
547106 Med Surg Tele Akron OHIO 12 Hour Nights
535177 Cath Lab Alameda Oakland CALIFORNIA 8 Hour Varied
535176 Cath Lab Alameda Oakland CALIFORNIA 8 Hour Days
544652 Med Surg Alamosa COLORADO 12 Hour Nights
546709 ER Albany NEW YORK 12 Hour Nights
546706 Med Surg Albany NEW YORK 12 Hour Nights
539176 ICU Albany NEW YORK 12 Hour Days
546707 Med Surg Albany NEW YORK 12 Hour Nights
544817 OR Albany NEW YORK 12 Hour Day/Night Rotate
547972 Cardiac Telemetry Albany NEW YORK 12 Hour Nights
546710 ER Albany NEW YORK 12 Hour Nights
546705 Med Surg Albany NEW YORK 12 Hour Nights
546938 ER Albany NEW YORK 12 Hour Nights
546984 CVICU Albany NEW YORK 12 Hour Nights
547838 Postpartum Albany OREGON 12 Hour Day/Night Rotate
548400 ER Albany NEW YORK 12 Hour Nights RN/Registered Nurse
545026 OR Albany NEW YORK 12 Hour Day/Night Rotate
546937 ER Albany NEW YORK 12 Hour Nights
546708 ICU Albany NEW YORK 12 Hour Nights
547755 OR Albany NEW YORK 12 Hour Days
527995 Oncology Albany NEW YORK 12 Hour Nights
547623 ER Albany OREGON 12 Hour Day/Night Rotate
546939 ER Albany NEW YORK 12 Hour Nights
548335 Oncology Albany NEW YORK 12 Hour Nights RN/Registered Nurse
546277 RAD Tech Albany OREGON 12 Hour Day/Night Rotate
539177 Cardiology Albany NEW YORK 12 Hour Nights
547377 PCU Albuquerque NEW MEXICO 12 Hour Days
547489 CT Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
543807 PACU Albuquerque NEW MEXICO 12 Hour Nights
527987 Case Manager Albuquerque NEW MEXICO 10 Hour Days
544850 RAD Tech Albuquerque NEW MEXICO 8 Hour Day/Night Rotate
541326 Certified Surgical Tech Albuquerque NEW MEXICO 12 Hour Nights
548093 ER Albuquerque NEW MEXICO 12 Hour Nights RN/Registered Nurse
545128 Med Surg Albuquerque NEW MEXICO 12 Hour Nights
543296 OR Albuquerque NEW MEXICO 12 Hour Days
541332 PCU Albuquerque NEW MEXICO 12 Hour Nights
545560 Scrub Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
543297 OR Albuquerque NEW MEXICO Nights
547374 PCU Albuquerque NEW MEXICO 12 Hour Days
543725 OR Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
546289 CT Tech Alexandria VIRGINIA 10 Hour Days
517887 CRNA Alturas CALIFORNIA 12 Hour Day/Night Rotate
538911 CT Tech Alturas CALIFORNIA 8 Hour Varied
547709 Pediatrics Alturas CALIFORNIA 12 Hour Day/Night Rotate
538064 Long Term Care Alturas CALIFORNIA 12 Hour Day/Night Rotate
525812 RAD Tech Amarillo TEXAS 8 Hour Evenings Radiology Techs/Technologists
525811 CT Tech Amarillo TEXAS 12 Hour Nights Tech/Technologist
547519 Hospice Amarillo TEXAS Days
548324 ICU Amsterdam NEW YORK 12 Hour Nights RN/Registered Nurse
548183 Home Health Anaheim CALIFORNIA 8 Hour Days RN/Registered Nurse
548368 ICU Anaheim CALIFORNIA 12 Hour Nights RN/Registered Nurse
548366 ICU Anaheim CALIFORNIA 12 Hour Days RN/Registered Nurse
548331 ICU Anaheim CALIFORNIA 12 Hour Nights RN/Registered Nurse
524120 PICU Anchorage ALASKA 12 Hour Nights RN/Registered Nurse
547009 Wound Care Anchorage ALASKA 8 Hour Days
543808 Case Manager Anchorage ALASKA 8 Hour Days
545393 Surgical Tech Anchorage ALASKA 10 Hour Nights
543574 Case Manager Anchorage ALASKA 8 Hour Days
545120 Case Manager Anchorage ALASKA 8 Hour Days
545392 CT Tech Anchorage ALASKA 12 Hour Days
544595 Surgical Tech Anchorage ALASKA 10 Hour Days
546224 CCU Ann Arbor MICHIGAN 12 Hour Nights
546923 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
538591 CT Tech Ann Arbor MICHIGAN 12 Hour Days
547326 CVOR Ann Arbor MICHIGAN 10 Hour Days
546223 ICU Ann Arbor MICHIGAN 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.5143 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 z.city asc limit 0,100 in 1.4151 seconds