Listing all records

Displaying records 3601 through 3700 out of a total 3,709 records. Prev Next

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