Listing all records

Displaying records 1101 through 1200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
540864 CT Tech Pigeon MICHIGAN 12 Hour Nights
540867 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
540878 Case Manager Farmington CONNECTICUT 8 Hour Evenings
540879 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Days
540883 ER Hartford CONNECTICUT 12 Hour Nights
540890 Surgical Tech CVOR Farmington CONNECTICUT 10 Hour Days
540891 MLT Farmington CONNECTICUT 8 Hour Days
540892 MLT Farmington CONNECTICUT 8 Hour Days
540895 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540910 Social Worker Concord CALIFORNIA 8 Hour Days
540912 Med Surg Dubuque IOWA 12 Hour Nights
540923 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
540931 Med Surg Tele Cleveland OHIO 12 Hour Nights
540956 Interventional Therapy Grove City OHIO 8 Hour Days
540972 MLT Des Moines IOWA 10 Hour Nights
540976 Phlebotomist Farmington CONNECTICUT 8 Hour Days
540993 Med Surg Tele Chillicothe OHIO 12 Hour Nights
540994 Outpatient Clinic Watertown NEW YORK 8 Hour Day/Night Rotate
541026 RAD Tech Charleston SOUTH CAROLINA 12 Hour Nights
541028 SLP MERCED CALIFORNIA 8 Hour Days
541037 L&D Walnut Creek CALIFORNIA 12 Hour Days
541038 Phlebotomist Farmington CONNECTICUT 8 Hour Days
541039 Psych Concord CALIFORNIA 8 Hour Nights
541058 OR Sherwood ARKANSAS 10 Hour Days
541068 Cath Lab PHOENIX ARIZONA 12 Hour Days
541071 Med Surg Tele Des Moines IOWA 12 Hour Nights
541072 Orthopedics Des Moines IOWA 12 Hour Nights
541076 Med Surg Des Moines IOWA 12 Hour Nights
541077 CT Tech Springfield MASSACHUSETTS 8 Hour Evenings
541078 Oncology Des Moines IOWA 12 Hour Nights
541096 Long Term Care New Lisbon WISCONSIN 8 Hour Days
541105 PT Estes Park COLORADO 12 Hour Day/Night Rotate
541107 Ultrasound Tech Sioux City IOWA 8 Hour Days
541108 Ultrasound Tech Sioux City IOWA 8 Hour Days
541109 MLT Syracuse NEW YORK 8 Hour Nights
541117 Telemetry Farmington CONNECTICUT 12 Hour Nights
541191 Echo Ann Arbor MICHIGAN 8 Hour Days
541207 ER Walnut Creek CALIFORNIA 12 Hour Nights
541235 Med Surg National City CALIFORNIA 12 Hour Nights
541236 CT Tech Petoskey MICHIGAN 12 Hour Nights
541257 OR Concord CALIFORNIA 10 Hour Evenings
541258 ICU Concord CALIFORNIA 12 Hour Days
541271 PCU Bismarck NORTH DAKOTA Nights
541283 Surgical Tech CVOR Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
541312 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
541323 Med Surg Tele Warrensville Heights OHIO 12 Hour Nights
541326 Certified Surgical Tech Albuquerque NEW MEXICO 12 Hour Nights
541332 PCU Albuquerque NEW MEXICO 12 Hour Nights
541359 Vascular Ultrasound Tech Kearney NEBRASKA 8 Hour Days
541381 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
541384 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
541391 RAD Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
541392 OR East Norriton PENNSYLVANIA 8 Hour Days
541403 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
541437 Echo Syracuse NEW YORK 8 Hour Days
541443 COTA Towson MARYLAND Days
541447 Cath Lab Everett WASHINGTON 10 Hour Days
541473 CVOR Spokane WASHINGTON 10 Hour Days
541482 CVOR Spokane WASHINGTON 10 Hour Days
541483 CVOR Spokane WASHINGTON 10 Hour Days
541484 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
541485 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
541486 CVOR Spokane WASHINGTON 10 Hour Days
541489 Med Surg Spokane WASHINGTON 12 Hour Nights
541491 Interventional Radiology Spokane WASHINGTON 10 Hour Days
541492 Med Surg Spokane WASHINGTON 12 Hour Nights
541498 Med Surg Spokane WASHINGTON 12 Hour Nights
541499 Med Surg Spokane WASHINGTON 12 Hour Nights
541500 PCU Spokane WASHINGTON 12 Hour Nights
541501 PCU Spokane WASHINGTON 12 Hour Nights
541502 Med Surg Spokane WASHINGTON 12 Hour Nights
541503 PCU Spokane WASHINGTON 12 Hour Nights
541504 PCU Spokane WASHINGTON 12 Hour Nights
541505 PCU Spokane WASHINGTON 12 Hour Nights
541506 Med Surg Spokane WASHINGTON 12 Hour Nights
541508 Med Surg Spokane WASHINGTON 12 Hour Nights
541510 Med Surg Spokane WASHINGTON 12 Hour Nights
541511 Med Surg Spokane WASHINGTON 12 Hour Nights
541512 Med Surg Spokane WASHINGTON 12 Hour Nights
541513 Med Surg Spokane WASHINGTON 12 Hour Nights
541514 Med Surg Spokane WASHINGTON 12 Hour Nights
541518 PCU Spokane WASHINGTON 12 Hour Nights
541519 PCU Spokane WASHINGTON 12 Hour Nights
541521 PCU Spokane WASHINGTON 12 Hour Days
541522 PCU Spokane WASHINGTON 12 Hour Days
541524 PCU Spokane WASHINGTON 12 Hour Nights
541525 PCU Spokane WASHINGTON 12 Hour Days
541526 PCU Spokane WASHINGTON 12 Hour Days
541527 PCU Spokane WASHINGTON 12 Hour Days
541536 Cath Lab Portland OREGON 10 Hour Days
541543 Case Manager Portland OREGON 8 Hour Days
541550 PT Apple Valley CALIFORNIA 8 Hour Days
541551 PT Apple Valley CALIFORNIA 8 Hour Days
541578 Cath Lab Tarzana CALIFORNIA 8 Hour Days
541591 RAD Tech Petaluma CALIFORNIA 8 Hour Days
541606 Surgical Tech CVOR Lubbock TEXAS 10 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.6095 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.id asc limit 1100,100 in 1.051 seconds