Listing all records

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

ID Job Specialty City State Shift Title
542364 OR Spokane WASHINGTON 12 Hour Days
542375 Med Surg Spokane WASHINGTON 12 Hour Nights
543535 Med Surg Spokane WASHINGTON 12 Hour Nights
543791 Med Surg Spokane WASHINGTON 12 Hour Nights
544034 PCU Spokane WASHINGTON 12 Hour Nights
548342 Telemetry Spokane WASHINGTON 12 Hour Days RN/Registered Nurse
548348 Telemetry Spokane WASHINGTON 12 Hour Days RN/Registered Nurse
546832 Therapy Rehab Spring Valley ILLINOIS 12 Hour Day/Night Rotate
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
534605 Therapy Rehab Springfield MISSOURI Varied
535465 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
538599 PT Springfield PENNSYLVANIA Days
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
546103 OR Springfield MASSACHUSETTS 8 Hour 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
532855 PT St Johnsbury VERMONT Varied
543630 Surgical Tech Stafford Springs CONNECTICUT 8 Hour Days
546104 ER Stafford Springs CONNECTICUT 12 Hour Nights
546105 ER Stafford Springs CONNECTICUT 12 Hour Nights
544634 APRN Stanley WISCONSIN Days
532081 Physician Stanley WISCONSIN 8 Hour Day/Night Rotate
547950 PT Staples MINNESOTA 8 Hour Days
547951 PT Staples MINNESOTA 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
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
547942 PACU Sterling ILLINOIS 8 Hour Days
548095 ER Sterling COLORADO 12 Hour Nights RN/Registered Nurse
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
548050 Respiratory Therapist Stony Brook NEW YORK 12 Hour Nights Respiratory Therapist
545331 PT Sumter SOUTH CAROLINA Days
548222 Certified Surgical Tech Sun City ARIZONA 10 Hour Days CST/Certified Surgical Technician
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
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
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
546212 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
546213 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
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
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
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
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
535128 Management Tacoma WASHINGTON Varied
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.5846 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 3200,100 in 1.6916 seconds