Listing all records

Displaying records 801 through 900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540749 Med Surg Tele Prescott ARIZONA 12 Hour Day/Night Rotate
543679 RN House Supervisor Honolulu HAWAII 12 Hour Day/Night Rotate
538304 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
546379 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
538394 ER Avalon CALIFORNIA 12 Hour Day/Night Rotate
541829 RAD Tech CHANDLER ARIZONA 12 Hour Day/Night Rotate
541381 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
545390 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
545560 Scrub Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
538741 ICU Cleveland OHIO 12 Hour Day/Night Rotate
546054 Intermediate Care Hilo HAWAII 12 Hour Day/Night Rotate
546835 Registered Dietician Waimea HAWAII 12 Hour Day/Night Rotate
538917 Med Surg Hilo HAWAII 12 Hour Day/Night Rotate
545915 RAD Tech Richland WASHINGTON 12 Hour Day/Night Rotate
545342 Home Health Rockford ILLINOIS 12 Hour Day/Night Rotate
539087 Oncology Duluth MINNESOTA 12 Hour Day/Night Rotate
541650 CT Tech Chewelah WASHINGTON 12 Hour Day/Night Rotate
546050 Pediatrics Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
546256 PACU Hilo HAWAII 12 Hour Day/Night Rotate
546230 RAD Tech Cincinnati OHIO 12 Hour Day/Night Rotate
546927 ER Kaunakakai HAWAII 12 Hour Day/Night Rotate
539320 Oncology York PENNSYLVANIA 12 Hour Day/Night Rotate
546680 Pharmacist Tuba City ARIZONA 12 Hour Day/Night Rotate
546459 Orthopedics Madison WISCONSIN 12 Hour Day/Night Rotate
546660 OR Pueblo COLORADO 12 Hour Day/Night Rotate
546940 Psych Kealakekua HAWAII 12 Hour Day/Night Rotate
546307 ER Watertown NEW YORK 12 Hour Day/Night Rotate
547026 ICU Santa Fe NEW MEXICO 12 Hour Day/Night Rotate
539718 Angiography Hilo HAWAII 12 Hour Day/Night Rotate
543777 RAD Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
546277 RAD Tech Albany OREGON 12 Hour Day/Night Rotate
546794 Med Surg Tele Madison WISCONSIN 12 Hour Day/Night Rotate
546870 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
546308 ER Watertown NEW YORK 12 Hour Day/Night Rotate
539896 Ultrasound Tech York PENNSYLVANIA 12 Hour Day/Night Rotate
539903 MLT Tuba City ARIZONA 12 Hour Day/Night Rotate
542081 Med Surg Tele Madison WISCONSIN 12 Hour Day/Night Rotate
547393 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547117 Cardiovascular York PENNSYLVANIA 12 Hour Day/Night Rotate
547459 PCU Abilene TEXAS 12 Hour Day/Night Rotate
542160 CT Tech Lynwood CALIFORNIA 12 Hour Day/Night Rotate
547452 Rehab Abilene TEXAS 12 Hour Day/Night Rotate
547709 Pediatrics Alturas CALIFORNIA 12 Hour Day/Night Rotate
547489 CT Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
547576 ER Watertown NEW YORK 12 Hour Day/Night Rotate
542526 ICU Cleveland OHIO 12 Hour Day/Night Rotate
542669 Oncology Madison WISCONSIN 12 Hour Day/Night Rotate
547522 CT Tech Cook MINNESOTA 12 Hour Day/Night Rotate
547623 ER Albany OREGON 12 Hour Day/Night Rotate
547583 Dialysis WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
547646 L&D Seaside OREGON 12 Hour Day/Night Rotate
542474 Sterile Processing Technician Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
547735 Neuro Intensive Care Palo Alto CALIFORNIA 12 Hour Day/Night Rotate
547792 Scrub Tech Pueblo COLORADO 12 Hour Day/Night Rotate
542636 Oncology Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
542670 Oncology Madison WISCONSIN 12 Hour Day/Night Rotate
542156 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
547518 CT Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
547850 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547838 Postpartum Albany OREGON 12 Hour Day/Night Rotate
547878 Echo Technologist Abilene TEXAS 12 Hour Day/Night Rotate
547805 ER Cleveland OHIO 12 Hour Day/Night Rotate
547900 Infection Prevention Specialist Seattle WASHINGTON 12 Hour Day/Night Rotate
547952 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
540104 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
547962 PICU Madison WISCONSIN 12 Hour Day/Night Rotate
547963 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
548010 CT Tech Fort Bragg CALIFORNIA 12 Hour Day/Night Rotate
548019 CNA Corvallis OREGON 12 Hour Day/Night Rotate
542986 RAD Tech Tuba City ARIZONA 12 Hour Day/Night Rotate
548080 CVICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
543040 CT Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
543039 CLS San Diego CALIFORNIA 12 Hour Day/Night Rotate
548410 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
543123 ER Primghar IOWA 12 Hour Nights
546875 Telemetry PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
543259 Step Down Cleveland OHIO 12 Hour Nights
541891 Telemetry Farmington CONNECTICUT 12 Hour Nights
540251 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540250 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
543252 Telemetry Rock Hill SOUTH CAROLINA 12 Hour Nights
540258 ICU Concord CALIFORNIA 12 Hour Nights
526099 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
543147 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
544104 OR Langhorne PENNSYLVANIA 12 Hour Nights
526356 Telemetry Boise IDAHO 12 Hour Nights
526545 ICU - Per Diem Woodland Hills CALIFORNIA 12 Hour Nights RN/Registered Nurse
547698 ICU Saratoga Springs NEW YORK 12 Hour Nights
543118 RN Columbus OHIO 12 Hour Nights
543214 Telemetry Cleveland OHIO 12 Hour Nights
540261 Telemetry Concord CALIFORNIA 12 Hour Nights
543122 ER Primghar IOWA 12 Hour Nights
543225 PCU Johnson City TENNESSEE 12 Hour Nights
543215 Telemetry Cleveland OHIO 12 Hour Nights
535227 Orthopedics Des Moines IOWA 12 Hour Nights
535266 Med Surg Ogdensburg NEW YORK 12 Hour Nights
540252 NICU Walnut Creek CALIFORNIA 12 Hour Nights
535387 Rehab Clive IOWA 12 Hour Nights
543260 Step Down Cleveland OHIO 12 Hour Nights
535463 ICU Sioux City IOWA 12 Hour Nights
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.6455 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 800,100 in 1.5608 seconds