Listing all records

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

ID Job Specialty City State Shift Title
547436 CT Tech Olympia WASHINGTON 12 Hour Nights
547440 Electrophysiology Tech Birmingham ALABAMA 10 Hour Days
547442 Electrophysiology Tech San Antonio TEXAS 10 Hour Days
547444 Med Surg Bloomington INDIANA 12 Hour Nights
547445 PT Seguin TEXAS 8 Hour Days
547446 Rehab Seguin TEXAS 12 Hour Days
547448 Med Surg Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547451 LPN/LVN Abilene TEXAS 8 Hour Day/Night Rotate
547452 Rehab Abilene TEXAS 12 Hour Day/Night Rotate
547453 Surgical Tech CVOR Abilene TEXAS 8 Hour Days
547454 ICU Abilene TEXAS 12 Hour Day/Night Rotate
547455 PCU Abilene TEXAS 12 Hour Days
547456 Neuro Med Surg/Tele Abilene TEXAS 12 Hour Nights
547457 ICU Abilene TEXAS 12 Hour Nights
547458 Outpatient Clinic Abilene TEXAS 10 Hour Day/Night Rotate
547459 PCU Abilene TEXAS 12 Hour Day/Night Rotate
547460 MRI Tech Abilene TEXAS 8 Hour Days
547461 Radiology Tech Auburn NEW YORK 12 Hour Days
547462 Long Term Care Claremont NEW HAMPSHIRE 8 Hour Days
547463 CNA Claremont NEW HAMPSHIRE 8 Hour Day/Night Rotate
547464 CNA Claremont NEW HAMPSHIRE 8 Hour Evenings
547465 Long Term Care Claremont NEW HAMPSHIRE 8 Hour Evenings
547466 NICU Des Moines IOWA 12 Hour Nights
547468 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
547470 CT Tech Hays KANSAS 8 Hour Nights
547471 Med Surg Prince Frederick MARYLAND 12 Hour Nights
547474 LTAC Fayetteville NORTH CAROLINA 12 Hour Nights
547475 LTAC Fayetteville NORTH CAROLINA 12 Hour Days
547479 CT Tech Arlington VIRGINIA 10 Hour Days
547480 ER Manchester CONNECTICUT 12 Hour Nights
547481 ER Manchester CONNECTICUT 12 Hour Nights
547482 CT Tech Rockingham NORTH CAROLINA 12 Hour Nights
547485 PT Union City CALIFORNIA 8 Hour Days
547486 MRI Tech Pierce Tacoma WASHINGTON 10 Hour Evenings
547487 Patient Care Coordinator Clackamas OREGON 8 Hour Days
547489 CT Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
547490 Pharmacist Abilene TEXAS 12 Hour Days
547494 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547495 Respiratory Therapist WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
547497 Pediatrics Hilo HAWAII 12 Hour Nights
547499 Cath Lab Pueblo COLORADO 10 Hour Varied
547500 Med Surg Chillicothe OHIO 12 Hour Nights
547512 Med Surg Coos Bay OREGON 12 Hour Nights
547513 Surgical Tech CVOR Norman OKLAHOMA 8 Hour Days
547515 Medical Assistant Ruidoso NEW MEXICO 8 Hour Days
547518 CT Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
547519 Hospice Amarillo TEXAS Days
547521 Med Surg Tele Bristol TENNESSEE 12 Hour Nights
547522 CT Tech Cook MINNESOTA 12 Hour Day/Night Rotate
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
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
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
547667 ICU Laconia NEW HAMPSHIRE Nights
547568 CCU Marshall MICHIGAN 12 Hour Nights
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
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
547834 Dialysis Tech Everett WASHINGTON 10 Hour Varied
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
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
547624 L&D Laramie WYOMING Nights
547625 CNA Kula HAWAII 8 Hour Days
547633 CT Tech Titusville FLORIDA 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.423 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.title desc limit 3000,100 in 1.4324 seconds