Listing all records

Displaying records 1001 through 1100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545103 Certified Surgical Tech Cleveland OHIO 10 Hour Days
548222 Certified Surgical Tech Sun City ARIZONA 10 Hour Days CST/Certified Surgical Technician
545104 Certified Surgical Tech Cleveland OHIO 10 Hour Days
546128 Certified Surgical Tech Florence SOUTH CAROLINA 12 Hour Days
546992 Certified Surgical Tech Concord MASSACHUSETTS 8 Hour Days
543484 Certified Surgical Tech Abingdon VIRGINIA 8 Hour Day/Night Rotate
547993 LTAC Torrance CALIFORNIA 8 Hour Evenings
547475 LTAC Fayetteville NORTH CAROLINA 12 Hour Days
548164 LTAC Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
547474 LTAC Fayetteville NORTH CAROLINA 12 Hour Nights
544792 Orthopedics Detroit MICHIGAN 12 Hour Nights
545206 Orthopedics Des Moines IOWA 12 Hour Nights
535227 Orthopedics Des Moines IOWA 12 Hour Nights
547124 Orthopedics Des Moines IOWA 12 Hour Nights
540583 Orthopedics Des Moines IOWA 12 Hour Nights
546459 Orthopedics Madison WISCONSIN 12 Hour Day/Night Rotate
541072 Orthopedics Des Moines IOWA 12 Hour Nights
547125 Orthopedics Des Moines IOWA 12 Hour Nights
547532 CCU Concord MASSACHUSETTS 12 Hour Nights
548182 CCU Pittsfield MASSACHUSETTS 12 Hour Days RN/Registered Nurse
531496 CCU Newark NEW JERSEY 12 Hour Days
529983 CCU Newark NEW JERSEY 12 Hour Nights
547568 CCU Marshall MICHIGAN 12 Hour Nights
544233 CCU Denville NEW JERSEY 12 Hour Nights
548212 CCU Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
546224 CCU Ann Arbor MICHIGAN 12 Hour Nights
548302 CCU Chillicothe OHIO 12 Hour Nights RN/Registered Nurse
546571 MICU Brooklyn NEW YORK 12 Hour Nights
546573 MICU Brooklyn NEW YORK 12 Hour Days
544220 MICU Newark NEW JERSEY 8 Hour Nights
546574 MICU Brooklyn NEW YORK 12 Hour Days
546576 MICU Brooklyn NEW YORK 12 Hour Days
546926 MICU San Dimas CALIFORNIA 12 Hour Nights
546591 MICU Brooklyn NEW YORK 12 Hour Days
543090 MICU San Dimas CALIFORNIA 12 Hour Nights
548275 MICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548336 MICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
543092 MICU San Dimas CALIFORNIA 12 Hour Nights
517887 CRNA Alturas CALIFORNIA 12 Hour Day/Night Rotate
544199 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
548065 Step Down SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
545370 Step Down Cincinnati OHIO Nights
545372 Step Down Cincinnati OHIO Nights
542786 Step Down Kingsport TENNESSEE 12 Hour Nights
547107 Step Down Cleveland OHIO 12 Hour Nights
521323 Step Down Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521327 Step Down Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521981 Step Down Oklahoma City OKLAHOMA 12 Hour Days
521994 Step Down Oklahoma City OKLAHOMA 12 Hour Days
526359 Step Down Orangeburg SOUTH CAROLINA 12 Hour Varied
544037 Step Down Lansing MICHIGAN 12 Hour Nights
545371 Step Down Cincinnati OHIO Days
543259 Step Down Cleveland OHIO 12 Hour Nights
547846 Step Down Centralia WASHINGTON 12 Hour Nights
544526 Step Down Wailuku HAWAII 12 Hour Days
544572 Step Down Willoughby OHIO 12 Hour Nights
545288 Step Down South Charleston WEST VIRGINIA 12 Hour Nights
547272 Step Down Fairmont WEST VIRGINIA 12 Hour Nights
545582 Step Down Cleveland OHIO 12 Hour Nights
538306 Step Down Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
546382 Step Down Lansing MICHIGAN 12 Hour Nights
545369 Step Down Mayfield Heights OHIO 12 Hour Nights
539020 Step Down Morgantown WEST VIRGINIA 12 Hour Nights
546882 Step Down South Charleston WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
543527 Step Down Lansing MICHIGAN Nights
545233 Step Down Cleveland OHIO 12 Hour Nights
543260 Step Down Cleveland OHIO 12 Hour Nights
542877 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
545232 Step Down Cleveland OHIO 12 Hour Nights
540725 Step Down Oklahoma City OKLAHOMA 12 Hour Nights
547069 Step Down Johnson City TENNESSEE 12 Hour Nights
544918 Step Down Parma OHIO 12 Hour Nights
547105 Step Down Dover OHIO 12 Hour Nights
544036 Step Down Lansing MICHIGAN 12 Hour Nights
546453 Step Down Elkin NORTH CAROLINA 12 Hour Days
548317 ST Muskegon MICHIGAN 12 Hour Days Tech/Technologist
547343 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547341 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547339 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
547348 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547344 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547487 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547340 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
547342 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547349 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547347 Patient Care Coordinator Clackamas OREGON 8 Hour Days
535465 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
535604 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
546630 Med Surg Tele Laconia NEW HAMPSHIRE Nights
544547 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
546596 Med Surg Tele Rome NEW YORK 12 Hour Nights
543466 Med Surg Tele Wailuku HAWAII 12 Hour Nights
540821 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
546186 Med Surg Tele Cleveland OHIO 12 Hour Nights
540799 Med Surg Tele Euclid OHIO 12 Hour Nights
540229 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540231 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540240 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540243 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540249 Med Surg Tele Walnut Creek CALIFORNIA 12 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.3665 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.specialty desc limit 1000,100 in 1.4176 seconds