Listing all records

Displaying records 601 through 700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
541484 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
547844 CT Tech Des Moines IOWA 10 Hour Days
545030 OR Gardner MASSACHUSETTS 10 Hour Days
539111 OR Concord CALIFORNIA 10 Hour Days
541642 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
539151 Surgical Tech Fresno CALIFORNIA 10 Hour Days
546342 Cath Lab Lexington KENTUCKY 10 Hour Days
543331 Cath Lab Dubuque IOWA 10 Hour Days
545570 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
548142 OR Bakersfield CALIFORNIA 8 Hour Day/Night Rotate RN/Registered Nurse
545569 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
540994 Outpatient Clinic Watertown NEW YORK 8 Hour Day/Night Rotate
547836 OR Honolulu HAWAII 8 Hour Day/Night Rotate
547768 Long Term Care New Lisbon WISCONSIN 8 Hour Day/Night Rotate
545954 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
545542 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
547909 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
545125 RAD Tech Gig Harbor WASHINGTON 8 Hour Day/Night Rotate
545033 Echo Technologist Madison WISCONSIN 8 Hour Day/Night Rotate
547837 Surgical Tech Honolulu HAWAII 8 Hour Day/Night Rotate
545600 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
548394 OR Abingdon VIRGINIA 8 Hour Day/Night Rotate RN/Registered Nurse
547036 Surgical Tech Falls Church VIRGINIA 8 Hour Day/Night Rotate
545955 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
540747 CT Tech SANTA CRUZ CALIFORNIA 8 Hour Day/Night Rotate
546948 Echo Lufkin TEXAS 8 Hour Day/Night Rotate
541283 Surgical Tech CVOR Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
527927 PT Mandan NORTH DAKOTA 8 Hour Day/Night Rotate
547451 LPN/LVN Abilene TEXAS 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
529591 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
529597 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
545083 Cath Lab Corvallis OREGON 8 Hour Day/Night Rotate
532081 Physician Stanley WISCONSIN 8 Hour Day/Night Rotate
545414 OT Rehab San Angelo TEXAS 8 Hour Day/Night Rotate
545571 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
546221 PTA Crescent City CALIFORNIA 8 Hour Day/Night Rotate
533310 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
546627 CVICU Madison WISCONSIN 8 Hour Day/Night Rotate
534546 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
545572 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
547302 MLT York MAINE 8 Hour Day/Night Rotate
539658 OR Abingdon VIRGINIA 8 Hour Day/Night Rotate
536159 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
547463 CNA Claremont NEW HAMPSHIRE 8 Hour Day/Night Rotate
536775 RAD Tech San Francisco CALIFORNIA 8 Hour Day/Night Rotate
536776 CT Tech San Francisco CALIFORNIA 8 Hour Day/Night Rotate
547402 Cath Lab Tech Fort Smith ARIZONA 8 Hour Day/Night Rotate
543484 Certified Surgical Tech Abingdon VIRGINIA 8 Hour Day/Night Rotate
547669 Home Health Springfield VERMONT 8 Hour Day/Night Rotate
547908 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
544177 Surgical Tech Madison WISCONSIN 8 Hour Day/Night Rotate
543978 Scrub Tech Lamar COLORADO 8 Hour Day/Night Rotate
544124 Cath Lab Fort Smith ARIZONA 8 Hour Day/Night Rotate
544096 Cath Lab Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
538264 OR San Angelo TEXAS 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
548009 RAD Tech Honolulu HAWAII 8 Hour Day/Night Rotate
546835 Registered Dietician Waimea HAWAII 12 Hour Day/Night Rotate
540516 RRT- Respiratory Chambersburg PENNSYLVANIA 12 Hour Day/Night Rotate
546680 Pharmacist Tuba City ARIZONA 12 Hour Day/Night Rotate
503607 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
546380 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
541929 Management Corvallis OREGON 12 Hour Day/Night Rotate
546940 Psych Kealakekua HAWAII 12 Hour Day/Night Rotate
542655 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
546832 Therapy Rehab Spring Valley ILLINOIS 12 Hour Day/Night Rotate
540104 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
546277 RAD Tech Albany OREGON 12 Hour Day/Night Rotate
546738 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
525386 Vascular Ultrasound Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
546869 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
547026 ICU Santa Fe NEW MEXICO 12 Hour Day/Night Rotate
546866 Surgical Tech Mammoth Lakes CALIFORNIA 12 Hour Day/Night Rotate
546927 ER Kaunakakai HAWAII 12 Hour Day/Night Rotate
546459 Orthopedics Madison WISCONSIN 12 Hour Day/Night Rotate
546474 CVOR Corvallis OREGON 12 Hour Day/Night Rotate
546308 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546307 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546379 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546455 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
548028 CT Tech Pagosa Springs COLORADO 12 Hour Day/Night Rotate
546660 OR Pueblo COLORADO 12 Hour Day/Night Rotate
534500 PTA Jacksonville ILLINOIS 12 Hour Day/Night Rotate
546639 Cardiac ICU Falls Church VIRGINIA 12 Hour Day/Night Rotate
540745 Telemetry Prescott ARIZONA 12 Hour Day/Night Rotate
546870 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
534694 Psych Woodsville NEW HAMPSHIRE 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
540746 Med Surg Prescott ARIZONA 12 Hour Day/Night Rotate
534972 CT Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
535045 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
540749 Med Surg Tele Prescott ARIZONA 12 Hour Day/Night Rotate
540802 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
547117 Cardiovascular York PENNSYLVANIA 12 Hour Day/Night Rotate
535334 SLP Pasco WASHINGTON 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.3799 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 desc limit 600,100 in 1.3571 seconds