Listing all records

Displaying records 2601 through 2700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546145 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
546146 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
546147 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
546167 Med Surg Tele Dothan ALABAMA 12 Hour Nights
546169 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546170 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
546172 Med Surg Tele Gallipolis OHIO 12 Hour Nights
546186 Med Surg Tele Cleveland OHIO 12 Hour Nights
546225 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
548381 Med Surg Tele Prescott ARIZONA 12 Hour Nights RN/Registered Nurse
547811 Med Surg Tele Woonsocket RHODE ISLAND 12 Hour Days
548358 Med Surg Tele Cooperstown NEW YORK 12 Hour Days RN/Registered Nurse
546343 Med Surg Tele Lubbock TEXAS 12 Hour Days
548124 Med Surg Tele Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
546378 Med Surg Tele Gallipolis OHIO 12 Hour Nights
546379 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547771 Med Surg Tele Rome NEW YORK 12 Hour Nights
546596 Med Surg Tele Rome NEW YORK 12 Hour Nights
546985 Med Surg Tele Syracuse NEW YORK 12 Hour Days
546737 Med Surg Tele Cleveland OHIO 12 Hour Nights
546630 Med Surg Tele Laconia NEW HAMPSHIRE Nights
546717 Med Surg Tele Olympia WASHINGTON 12 Hour Nights
546720 Med Surg Tele Olympia WASHINGTON 12 Hour Nights
547487 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547349 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547340 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
547339 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
547342 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547343 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547344 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547347 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547348 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547341 Patient Care Coordinator Clackamas OREGON 8 Hour Days
548317 ST Muskegon MICHIGAN 12 Hour Days Tech/Technologist
542786 Step Down Kingsport TENNESSEE 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
547107 Step Down Cleveland OHIO 12 Hour Nights
546882 Step Down South Charleston WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
538306 Step Down Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
539020 Step Down Morgantown WEST VIRGINIA 12 Hour Nights
540725 Step Down Oklahoma City OKLAHOMA 12 Hour Nights
547272 Step Down Fairmont WEST VIRGINIA 12 Hour Nights
542877 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
543259 Step Down Cleveland OHIO 12 Hour Nights
543260 Step Down Cleveland OHIO 12 Hour Nights
543527 Step Down Lansing MICHIGAN Nights
544036 Step Down Lansing MICHIGAN 12 Hour Nights
544037 Step Down Lansing MICHIGAN 12 Hour Nights
544199 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
547069 Step Down Johnson City TENNESSEE 12 Hour Nights
544526 Step Down Wailuku HAWAII 12 Hour Days
544572 Step Down Willoughby OHIO 12 Hour Nights
544918 Step Down Parma OHIO 12 Hour Nights
545232 Step Down Cleveland OHIO 12 Hour Nights
545233 Step Down Cleveland OHIO 12 Hour Nights
545288 Step Down South Charleston WEST VIRGINIA 12 Hour Nights
545369 Step Down Mayfield Heights OHIO 12 Hour Nights
545370 Step Down Cincinnati OHIO Nights
545371 Step Down Cincinnati OHIO Days
545372 Step Down Cincinnati OHIO Nights
547105 Step Down Dover OHIO 12 Hour Nights
545582 Step Down Cleveland OHIO 12 Hour Nights
548065 Step Down SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
547846 Step Down Centralia WASHINGTON 12 Hour Nights
546382 Step Down Lansing MICHIGAN 12 Hour Nights
546453 Step Down Elkin NORTH CAROLINA 12 Hour Days
517887 CRNA Alturas CALIFORNIA 12 Hour Day/Night Rotate
546926 MICU San Dimas CALIFORNIA 12 Hour Nights
543090 MICU San Dimas CALIFORNIA 12 Hour Nights
543092 MICU San Dimas CALIFORNIA 12 Hour Nights
544220 MICU Newark NEW JERSEY 8 Hour Nights
548275 MICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548336 MICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
546571 MICU Brooklyn NEW YORK 12 Hour Nights
546573 MICU Brooklyn NEW YORK 12 Hour Days
546574 MICU Brooklyn NEW YORK 12 Hour Days
546576 MICU Brooklyn NEW YORK 12 Hour Days
546591 MICU Brooklyn NEW YORK 12 Hour Days
531496 CCU Newark NEW JERSEY 12 Hour Days
529983 CCU Newark NEW JERSEY 12 Hour Nights
548182 CCU Pittsfield MASSACHUSETTS 12 Hour Days RN/Registered Nurse
547568 CCU Marshall MICHIGAN 12 Hour Nights
547532 CCU Concord MASSACHUSETTS 12 Hour Nights
544233 CCU Denville NEW JERSEY 12 Hour Nights
548302 CCU Chillicothe OHIO 12 Hour Nights RN/Registered Nurse
548212 CCU Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
546224 CCU Ann Arbor MICHIGAN 12 Hour Nights
535227 Orthopedics Des Moines IOWA 12 Hour Nights
547125 Orthopedics Des Moines IOWA 12 Hour Nights
547124 Orthopedics Des Moines IOWA 12 Hour Nights
540583 Orthopedics Des Moines IOWA 12 Hour Nights
541072 Orthopedics Des Moines IOWA 12 Hour Nights
544792 Orthopedics Detroit MICHIGAN 12 Hour Nights
545206 Orthopedics Des Moines IOWA 12 Hour Nights
546459 Orthopedics Madison WISCONSIN 12 Hour Day/Night Rotate
547993 LTAC Torrance CALIFORNIA 8 Hour Evenings
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.6887 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 asc limit 2600,100 in 1.5668 seconds