Listing all records

Displaying records 401 through 500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
542615 Telemetry Terre Haute INDIANA 12 Hour Nights
546907 Telemetry Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
546908 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
546689 OR Templeton CALIFORNIA 10 Hour Days
546690 Surgical Tech Templeton CALIFORNIA 10 Hour Days
545277 Surgical Tech Templeton CALIFORNIA 10 Hour Days
545278 First Assist Templeton CALIFORNIA 10 Hour Days
547847 PCU Tarzana CALIFORNIA 12 Hour Nights
541578 Cath Lab Tarzana CALIFORNIA 8 Hour Days
535128 Management Tacoma WASHINGTON Varied
525662 Nurse Practicioner Syracuse NEW YORK 12 Hour Varied
529162 Physician Assistant Syracuse NEW YORK 8 Hour Varied
534655 CT Tech Syracuse NEW YORK 8 Hour Days
536558 ER Syracuse NEW YORK 12 Hour Nights RN/Registered Nurse
537185 CT Tech Syracuse NEW YORK Nights
541109 MLT Syracuse NEW YORK 8 Hour Nights
541437 Echo Syracuse NEW YORK 8 Hour Days
542114 Med Surg Tele Syracuse NEW YORK Nights
543378 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
544267 Med Surg Tele Syracuse NEW YORK 12 Hour Days
544268 Med Surg Tele Syracuse NEW YORK 12 Hour Days
544269 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
544270 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
544389 Lab Tech Syracuse NEW YORK 8 Hour Days
544390 Lab Tech Syracuse NEW YORK 8 Hour Days
544433 Ambulatory Syracuse NEW YORK 8 Hour Days
544481 Lab Tech Syracuse NEW YORK 12 Hour Nights
544608 SLP Syracuse NEW YORK 8 Hour Days
546045 EEG Tech Syracuse NEW YORK 8 Hour Days
548176 Med Surg Tele Syracuse NEW YORK 12 Hour Days RN/Registered Nurse
548283 Nurse Practicioner Syracuse NEW YORK 8 Hour Days NP/Nurse Practitioner
546225 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
546778 Ambulatory Syracuse NEW YORK 8 Hour Days RN/Registered Nurse
546789 RAD Tech Syracuse NEW YORK 8 Hour Evenings
546862 OT Syracuse NEW YORK 8 Hour Days
546985 Med Surg Tele Syracuse NEW YORK 12 Hour Days
547275 CT Tech Syracuse NEW YORK 12 Hour Nights
547832 PICU Syracuse NEW YORK Nights
546212 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
546213 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
547780 CT Tech Sunnyvale TEXAS 12 Hour Nights
545950 PT Sunnyvale CALIFORNIA Days
545951 PT Sunnyvale CALIFORNIA Days
512644 PT SUNNYVALE CALIFORNIA 8 Hour Days
516543 Case Manager SUNNYVALE CALIFORNIA 8 Hour Days
516544 Case Manager SUNNYVALE CALIFORNIA 8 Hour Days
539306 PT Sunnyvale CALIFORNIA Days
547759 Med Surg Sun City West ARIZONA 12 Hour Days
547765 Med Surg Sun City West ARIZONA 12 Hour Nights
542617 PCU Sun City West ARIZONA 12 Hour Nights
542618 PCU Sun City West ARIZONA 12 Hour Days
546216 PCU Sun City ARIZONA 12 Hour Nights
546217 PCU Sun City ARIZONA 12 Hour Nights
547699 OR Sun City ARIZONA 12 Hour Days
547700 CVOR Sun City ARIZONA 10 Hour Days
547727 PCU Sun City ARIZONA 12 Hour Days
547906 ICU Sun City ARIZONA 12 Hour Nights
548222 Certified Surgical Tech Sun City ARIZONA 10 Hour Days CST/Certified Surgical Technician
545331 PT Sumter SOUTH CAROLINA Days
548050 Respiratory Therapist Stony Brook NEW YORK 12 Hour Nights Respiratory Therapist
548054 CVOR STOCKTON CALIFORNIA 12 Hour Days RN/Registered Nurse
548135 CVICU Stockton CALIFORNIA 12 Hour Nights RN/Registered Nurse
535635 Therapy Rehab Stockton CALIFORNIA Days
547942 PACU Sterling ILLINOIS 8 Hour Days
548095 ER Sterling COLORADO 12 Hour Nights RN/Registered Nurse
537958 MRI Tech Staten Island NEW YORK 8 Hour Evenings
540488 SNF Staten Island NEW YORK 8 Hour Nights
543318 CT Tech Staten Island NEW YORK 8 Hour Evenings
543343 CT Tech Staten Island NEW YORK 8 Hour 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
547950 PT Staples MINNESOTA 8 Hour Days
547951 PT Staples MINNESOTA 8 Hour Days
532081 Physician Stanley WISCONSIN 8 Hour Day/Night Rotate
544634 APRN Stanley WISCONSIN Days
546104 ER Stafford Springs CONNECTICUT 12 Hour Nights
546105 ER Stafford Springs CONNECTICUT 12 Hour Nights
543630 Surgical Tech Stafford Springs CONNECTICUT 8 Hour Days
532855 PT St Johnsbury VERMONT Varied
534605 Therapy Rehab Springfield MISSOURI Varied
535465 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
538599 PT Springfield PENNSYLVANIA Days
540854 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
540855 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
540856 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
540857 ER Springfield MASSACHUSETTS 12 Hour Days
540859 ER Springfield MASSACHUSETTS 8 Hour Nights
540861 ER Springfield MASSACHUSETTS 8 Hour Nights
541077 CT Tech Springfield MASSACHUSETTS 8 Hour Evenings
546412 Med Surg Springfield VERMONT 12 Hour Days
546712 Respiratory Therapist Springfield MASSACHUSETTS 8 Hour Nights
546713 L&D Springfield MASSACHUSETTS 8 Hour Nights
546714 L&D Springfield MASSACHUSETTS 8 Hour Nights
547669 Home Health Springfield VERMONT 8 Hour Day/Night Rotate
544409 CT Tech Springfield VERMONT 8 Hour Nights
545422 ER Springfield MASSACHUSETTS 8 Hour Nights
545565 Therapy Rehab Springfield MISSOURI 8 Hour Days
545566 Therapy Rehab Springfield MISSOURI 8 Hour Days
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.7157 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 400,100 in 1.5515 seconds