Listing all records

Displaying records 2001 through 2100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545392 CT Tech Anchorage ALASKA 12 Hour Days
545393 Surgical Tech Anchorage ALASKA 10 Hour Nights
545405 Surgical Tech CVOR Weston FLORIDA 12 Hour Days
545411 RAD Tech Rockville MARYLAND 8 Hour Days
545413 MLT Ely NEVADA 12 Hour Days
545414 OT Rehab San Angelo TEXAS 8 Hour Day/Night Rotate
545420 PT REDWOOD CITY CALIFORNIA 8 Hour Days
545421 RN Columbus OHIO 12 Hour Nights
545422 ER Springfield MASSACHUSETTS 8 Hour Nights
545423 Med Surg Waterbury CONNECTICUT 12 Hour Days
545424 Med Surg Waterbury CONNECTICUT 12 Hour Days
545425 L&D Mishawaka INDIANA 12 Hour Days
545426 NICU Mishawaka INDIANA 12 Hour Days
545427 NICU Mishawaka INDIANA 12 Hour Nights
545440 OT Rehab thermopolis WYOMING Days
545452 ER Bristol PENNSYLVANIA 12 Hour Nights
545453 ER Lynwood CALIFORNIA 12 Hour Nights
545856 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545470 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
545482 PCU Lancaster SOUTH CAROLINA 12 Hour Nights
545486 RAD Tech Florence SOUTH CAROLINA 8 Hour Days
547904 ICU Mesa ARIZONA 12 Hour Nights
545489 MRI Tech Farmington CONNECTICUT 8 Hour Evenings
545490 CT Tech Farmington CONNECTICUT 8 Hour Nights
545498 Respiratory Therapist Des Moines IOWA 12 Hour Days
545499 Respiratory Therapist Des Moines IOWA 12 Hour Days
545500 Med Surg Tele Des Moines IOWA 12 Hour Days
545501 Med Surg Tele Des Moines IOWA 12 Hour Days
545502 Telemetry Boise IDAHO 12 Hour Nights
545503 Telemetry Boise IDAHO 12 Hour Nights
545514 L&D Arcata CALIFORNIA 12 Hour Nights
545515 L&D Arcata CALIFORNIA 12 Hour Nights
545526 Med Surg Memphis TENNESSEE 12 Hour Days
547141 RAD Tech Farmington CONNECTICUT 8 Hour Nights
545532 CT Tech Montrose COLORADO 12 Hour Varied
545533 CT Tech Montrose COLORADO 12 Hour Varied
545539 Interventional Radiology Tech Columbia SOUTH CAROLINA 8 Hour Days
545541 RAD Tech Columbus OHIO 8 Hour Nights
545542 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
545552 PT Wilton CONNECTICUT Varied
545553 Outpatient Clinic Greencastle INDIANA 10 Hour Days
545560 Scrub Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
545564 RAD Tech Peoria ILLINOIS 8 Hour Days
545565 Therapy Rehab Springfield MISSOURI 8 Hour Days
545566 Therapy Rehab Springfield MISSOURI 8 Hour Days
545569 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545570 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545571 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545572 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545579 ER Willoughby OHIO 12 Hour Nights
545582 Step Down Cleveland OHIO 12 Hour Nights
545591 RAD Tech Richmond VIRGINIA 8 Hour Days
545592 RAD Tech Richmond VIRGINIA 8 Hour Days
545597 Med Surg Peoria ILLINOIS 12 Hour Nights
545599 RAD Tech Richmond VIRGINIA 8 Hour Days
545600 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545605 ER Peoria ILLINOIS 12 Hour Nights
545606 Interventional Radiology Tech Mission Viejo CALIFORNIA 10 Hour Days
545611 Cath Lab Mission Viejo CALIFORNIA 10 Hour Days
545613 EP Tech Mission Viejo CALIFORNIA 10 Hour Days
545616 Med Surg Lancaster SOUTH CAROLINA 12 Hour Nights
545617 Med Surg Gainesville FLORIDA 12 Hour Days
545618 MLT Gainesville FLORIDA 8 Hour Nights
545619 Med Surg Gainesville FLORIDA 12 Hour Nights
545620 Med Surg Gainesville FLORIDA 12 Hour Nights
545621 ER Massena NEW YORK 12 Hour Nights
545622 Cardiovascular Prescott ARIZONA 12 Hour Day/Night Rotate
545624 Surgical Tech CVOR Prescott ARIZONA 8 Hour Days
545625 Telemetry Prescott Valley ARIZONA 12 Hour Nights
545626 Telemetry Prescott Valley ARIZONA 12 Hour Day/Night Rotate
545627 Cardiology Gainesville FLORIDA 12 Hour Nights
545628 Med Surg Gainesville FLORIDA 12 Hour Days
545629 ICU Gainesville FLORIDA 12 Hour Nights
545630 Sterile Processing Technician Gainesville FLORIDA 8 Hour Evenings
545631 ICU Gainesville FLORIDA 12 Hour Nights
545632 Med Surg Gainesville FLORIDA 12 Hour Days
545633 Med Surg Gainesville FLORIDA 12 Hour Nights
545634 Med Surg Gainesville FLORIDA 12 Hour Days
545635 Med Surg Gainesville FLORIDA 12 Hour Nights
545636 ICU Gainesville FLORIDA 12 Hour Nights
545637 ICU Gainesville FLORIDA 12 Hour Nights
545638 Med Surg Gainesville FLORIDA 12 Hour Days
545639 ICU Gainesville FLORIDA 12 Hour Nights
545640 EEG Tech Gainesville FLORIDA 10 Hour Days
545641 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545642 Med Surg Gainesville FLORIDA 12 Hour Nights
545643 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545644 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545645 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545646 Med Surg Gainesville FLORIDA 12 Hour Days
545647 Med Surg Gainesville FLORIDA 12 Hour Days
545648 RAD Tech Gainesville FLORIDA 12 Hour Nights
545649 RAD Tech Gainesville FLORIDA 12 Hour Nights
545650 RAD Tech Gainesville FLORIDA 10 Hour Nights
545651 RAD Tech Gainesville FLORIDA 10 Hour Nights
545652 Med Surg Gainesville FLORIDA 12 Hour Nights
545653 Med Surg Gainesville FLORIDA 12 Hour Nights
545654 Med Surg Gainesville FLORIDA 12 Hour Nights
545655 Med Surg Gainesville FLORIDA 12 Hour Nights
545656 RRT- Respiratory Gainesville FLORIDA 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.6943 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 asc limit 2000,100 in 1.6097 seconds