Listing all records

Displaying records 3001 through 3100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547529 Sterile Processing Tech Berwyn ILLINOIS 8 Hour Evenings
547530 Cardiac ICU Chillicothe OHIO 12 Hour Nights
547531 L&D Arcata CALIFORNIA 12 Hour Nights
547532 CCU Concord MASSACHUSETTS 12 Hour Nights
547536 RAD Tech Tulsa OKLAHOMA 12 Hour Days
547537 Med Surg Tele Tulsa OKLAHOMA 12 Hour Days
547539 Case Manager Vail COLORADO Days
547540 PCU Coos Bay OREGON 12 Hour Days
547549 Med Surg Tele Manchester CONNECTICUT 12 Hour Nights
547550 ER Manchester CONNECTICUT 12 Hour Nights
547552 Interventional Radiology Tech Winston-Salem NORTH CAROLINA 8 Hour Days
547556 CT Tech Ritzville WASHINGTON 8 Hour Days
547557 CT Tech Akron OHIO 12 Hour Days
547560 Dialysis Per Diem Brooklyn NEW YORK 10 Hour Evenings RN/Registered Nurse
547561 Pediatrics Fort Defiance ARIZONA 12 Hour Day/Night Rotate
547562 Med Surg Tele Tulsa OKLAHOMA 12 Hour Nights
547564 Echo Technologist Cape Girardeau MISSOURI Days
547566 ER Watertown NEW YORK 12 Hour Day/Night Rotate
547568 CCU Marshall MICHIGAN 12 Hour Nights
547569 NICU Lynwood CALIFORNIA 12 Hour Nights
547570 Med Surg Per Diem/Local Contract Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
547573 Med Surg Chillicothe OHIO 12 Hour Days
547574 Med Surg Lewiston MAINE 12 Hour Days
547575 ICU Lewiston MAINE 12 Hour Days
547576 ER Watertown NEW YORK 12 Hour Day/Night Rotate
547579 MLT Watertown NEW YORK Nights
547580 Therapy Rehab Helena MONTANA Days
547581 Pulmonary Johnson City TENNESSEE 12 Hour Days
547582 SLP Lincoln City OREGON 8 Hour Days
547583 Dialysis WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
547585 RRT- Respiratory Louisville KENTUCKY 12 Hour Days
547586 PICU Santa Clara CALIFORNIA 12 Hour Nights
547592 Histology Technician Corvallis OREGON 8 Hour Days
547593 ICU Newton IOWA 12 Hour Nights
547594 Urgent Care Corvallis OREGON 8 Hour Days
547595 First Assist Canton OHIO 12 Hour Days
547603 ICU Issaquah WASHINGTON 12 Hour Days
547604 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
547605 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
547606 Surgical Tech Boise IDAHO 10 Hour Days
547607 OT Crescent City CALIFORNIA 8 Hour Days
547608 OT Crescent City CALIFORNIA 8 Hour Days
547609 OT Garden City KANSAS 8 Hour Days
547610 PICU Santa Clara CALIFORNIA 12 Hour Days
547611 PICU Santa Clara CALIFORNIA 12 Hour Nights
547612 PICU Santa Clara CALIFORNIA 12 Hour Nights
547613 PICU Santa Clara CALIFORNIA 12 Hour Nights
547614 PICU Santa Clara CALIFORNIA 12 Hour Nights
547616 PICU Santa Clara CALIFORNIA 12 Hour Days
547618 PICU Santa Clara CALIFORNIA 12 Hour Days
547620 PICU Santa Clara CALIFORNIA 12 Hour Days
547621 PICU Santa Clara CALIFORNIA 12 Hour Days
547623 ER Albany OREGON 12 Hour Day/Night Rotate
547624 L&D Laramie WYOMING Nights
547625 CNA Kula HAWAII 8 Hour Days
547626 Certified Surgical Tech Santa Monica CALIFORNIA 12 Hour Days
547633 CT Tech Titusville FLORIDA 12 Hour Nights
547634 Med Surg Tele Charlottesville VIRGINIA 12 Hour Nights
547635 SLP San Diego CALIFORNIA 8 Hour Days
547636 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
547637 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
547638 Med Surg Tele Lansing MICHIGAN 12 Hour Nights
547640 Med Surg Seattle WASHINGTON 12 Hour Nights
547642 Ambulatory Portland OREGON 8 Hour Days
547643 Med Surg Olympia WASHINGTON 12 Hour Nights
547646 L&D Seaside OREGON 12 Hour Day/Night Rotate
547647 Nuclear Med Technician Los Angeles CALIFORNIA 8 Hour Days
547648 RAD Tech Dothan ALABAMA 8 Hour Days
547650 Telemetry Hannibal MISSOURI 12 Hour Days
547651 Med Surg Tele Spartanburg SOUTH CAROLINA 12 Hour Nights
547652 Echo Columbia SOUTH CAROLINA 8 Hour Days
547654 PCU Kearney NEBRASKA 12 Hour Nights
547655 Med Surg Kearney NEBRASKA 12 Hour Nights
547656 Rehab Omaha NEBRASKA 12 Hour Days
547657 PCU Omaha NEBRASKA 12 Hour Nights
547658 PCU Omaha NEBRASKA 12 Hour Nights
547659 PCU Omaha NEBRASKA 12 Hour Days
547662 Surgical Tech Omaha NEBRASKA 8 Hour Days
547664 ICU Oceanside CALIFORNIA 12 Hour Nights
547665 Oncology Oceanside CALIFORNIA 12 Hour Nights
547666 PT Bad Axe MICHIGAN 8 Hour Days
547667 ICU Laconia NEW HAMPSHIRE Nights
547668 ICU Laconia NEW HAMPSHIRE Nights
547669 Home Health Springfield VERMONT 8 Hour Day/Night Rotate
547670 Psych Nashua NEW HAMPSHIRE 12 Hour Nights
547671 Med Surg Chillicothe OHIO 12 Hour Nights
547672 CVOR Falls Church VIRGINIA 12 Hour Days
547673 CVOR Falls Church VIRGINIA 12 Hour Days
547674 CVOR Falls Church VIRGINIA 12 Hour Days
547675 OR Waterloo IOWA 12 Hour Days
547676 ICU Lowville NEW YORK 12 Hour Nights
547677 Med Surg Lowville NEW YORK 12 Hour Days
547678 Med Surg Lowville NEW YORK 12 Hour Days
547680 Long Term Care Brantwood NORTH CAROLINA 12 Hour Nights
547681 Radiation Therapy Flint MICHIGAN 10 Hour Days
547682 Echo Technologist Chambersburg PENNSYLVANIA Varied
547683 OT Athens GEORGIA 8 Hour Days
547685 Electrophysiology Tech Monterey CALIFORNIA 8 Hour Days
547692 Ambulatory New York NEW YORK 8 Hour Days
547696 Med Surg Madison WISCONSIN 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.4657 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 3000,100 in 1.4463 seconds