Listing all records

Displaying records 3001 through 3100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546170 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546205 Long Term Care Watertown NEW YORK 12 Hour Day/Night Rotate
546230 RAD Tech Cincinnati OHIO 12 Hour Day/Night Rotate
546255 PT Falls River MASSACHUSETTS 12 Hour Day/Night Rotate
546256 PACU Hilo HAWAII 12 Hour Day/Night Rotate
546277 RAD Tech Albany OREGON 12 Hour Day/Night Rotate
546307 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546308 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546379 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546380 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
546381 Paramedic Lewisburg PENNSYLVANIA 12 Hour Day/Night Rotate
546474 CVOR Corvallis OREGON 12 Hour Day/Night Rotate
547838 Postpartum Albany OREGON 12 Hour Day/Night Rotate
546455 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
546459 Orthopedics Madison WISCONSIN 12 Hour Day/Night Rotate
546639 Cardiac ICU Falls Church VIRGINIA 12 Hour Day/Night Rotate
546660 OR Pueblo COLORADO 12 Hour Day/Night Rotate
546680 Pharmacist Tuba City ARIZONA 12 Hour Day/Night Rotate
546738 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547878 Echo Technologist Abilene TEXAS 12 Hour Day/Night Rotate
546785 Med Surg IOWA CITY IOWA 12 Hour Day/Night Rotate
546794 Med Surg Tele Madison WISCONSIN 12 Hour Day/Night Rotate
546832 Therapy Rehab Spring Valley ILLINOIS 12 Hour Day/Night Rotate
546835 Registered Dietician Waimea HAWAII 12 Hour Day/Night Rotate
546866 Surgical Tech Mammoth Lakes CALIFORNIA 12 Hour Day/Night Rotate
546869 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
546870 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
546927 ER Kaunakakai HAWAII 12 Hour Day/Night Rotate
546940 Psych Kealakekua HAWAII 12 Hour Day/Night Rotate
547026 ICU Santa Fe NEW MEXICO 12 Hour Day/Night Rotate
548028 CT Tech Pagosa Springs COLORADO 12 Hour Day/Night Rotate
547117 Cardiovascular York PENNSYLVANIA 12 Hour Day/Night Rotate
547709 Pediatrics Alturas CALIFORNIA 12 Hour Day/Night Rotate
547393 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547448 Med Surg Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547452 Rehab Abilene TEXAS 12 Hour Day/Night Rotate
547454 ICU Abilene TEXAS 12 Hour Day/Night Rotate
547459 PCU Abilene TEXAS 12 Hour Day/Night Rotate
547489 CT Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
547494 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547495 Respiratory Therapist WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
547518 CT Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
547522 CT Tech Cook MINNESOTA 12 Hour Day/Night Rotate
547561 Pediatrics Fort Defiance ARIZONA 12 Hour Day/Night Rotate
547566 ER Watertown NEW YORK 12 Hour Day/Night Rotate
547576 ER Watertown NEW YORK 12 Hour Day/Night Rotate
547583 Dialysis WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
547623 ER Albany OREGON 12 Hour Day/Night Rotate
547768 Long Term Care New Lisbon WISCONSIN 8 Hour Day/Night Rotate
547837 Surgical Tech Honolulu HAWAII 8 Hour Day/Night Rotate
547669 Home Health Springfield VERMONT 8 Hour Day/Night Rotate
527927 PT Mandan NORTH DAKOTA 8 Hour Day/Night Rotate
547836 OR Honolulu HAWAII 8 Hour Day/Night Rotate
529591 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
529597 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
532081 Physician Stanley WISCONSIN 8 Hour Day/Night Rotate
547909 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
533310 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
534546 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
548009 RAD Tech Honolulu HAWAII 8 Hour Day/Night Rotate
536159 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
548142 OR Bakersfield CALIFORNIA 8 Hour Day/Night Rotate RN/Registered Nurse
536775 RAD Tech San Francisco CALIFORNIA 8 Hour Day/Night Rotate
536776 CT Tech San Francisco CALIFORNIA 8 Hour Day/Night Rotate
544177 Surgical Tech Madison WISCONSIN 8 Hour Day/Night Rotate
538264 OR San Angelo TEXAS 8 Hour Day/Night Rotate
539658 OR Abingdon VIRGINIA 8 Hour Day/Night Rotate
540747 CT Tech SANTA CRUZ CALIFORNIA 8 Hour Day/Night Rotate
540994 Outpatient Clinic Watertown NEW YORK 8 Hour Day/Night Rotate
541283 Surgical Tech CVOR Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
542943 CT Tech San Bernardino CALIFORNIA 8 Hour Day/Night Rotate
543454 Home Health Fargo NORTH DAKOTA 8 Hour Day/Night Rotate
543484 Certified Surgical Tech Abingdon VIRGINIA 8 Hour Day/Night Rotate
543978 Scrub Tech Lamar COLORADO 8 Hour Day/Night Rotate
544096 Cath Lab Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
544124 Cath Lab Fort Smith ARIZONA 8 Hour Day/Night Rotate
544615 OR Duluth MINNESOTA 8 Hour Day/Night Rotate
544701 OB/GYN Socorro NEW MEXICO 8 Hour Day/Night Rotate
544850 RAD Tech Albuquerque NEW MEXICO 8 Hour Day/Night Rotate
545033 Echo Technologist Madison WISCONSIN 8 Hour Day/Night Rotate
545083 Cath Lab Corvallis OREGON 8 Hour Day/Night Rotate
545125 RAD Tech Gig Harbor WASHINGTON 8 Hour Day/Night Rotate
548394 OR Abingdon VIRGINIA 8 Hour Day/Night Rotate RN/Registered Nurse
545414 OT Rehab San Angelo TEXAS 8 Hour Day/Night Rotate
545542 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
545569 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545570 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545571 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545572 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545600 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545954 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
545955 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
546221 PTA Crescent City CALIFORNIA 8 Hour Day/Night Rotate
547908 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
546627 CVICU Madison WISCONSIN 8 Hour Day/Night Rotate
546948 Echo Lufkin TEXAS 8 Hour Day/Night Rotate
547036 Surgical Tech Falls Church VIRGINIA 8 Hour Day/Night Rotate
547302 MLT York MAINE 8 Hour Day/Night Rotate
547402 Cath Lab Tech Fort Smith ARIZONA 8 Hour Day/Night Rotate
547451 LPN/LVN Abilene TEXAS 8 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.6627 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 a.shift asc limit 3000,100 in 1.7033 seconds