Listing all records

Displaying records 1401 through 1500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543124 Cath Lab Fresno CALIFORNIA 12 Hour Days
543126 Cath Lab Mason City IOWA 8 Hour Days
543127 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543128 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543129 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543130 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543133 Echo Charlottesville VIRGINIA 8 Hour Days
543147 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
543152 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
543153 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
543178 Neuro Intensive Care New York NEW YORK Days
543183 Surgical Tech Athens GEORGIA 8 Hour Days
543184 Surgical Tech Athens GEORGIA 8 Hour Days
543186 Med Surg Oneonta NEW YORK 12 Hour Days
543193 Ultrasound Tech Farmington CONNECTICUT 8 Hour Days
543196 ER Newark NEW JERSEY 12 Hour Days
543199 ICU Newark NEW JERSEY 12 Hour Nights
543200 ICU Newark NEW JERSEY 12 Hour Days
543201 Psych Grand Rapids MICHIGAN 8 Hour Evenings RN/Registered Nurse
543214 Telemetry Cleveland OHIO 12 Hour Nights
543215 Telemetry Cleveland OHIO 12 Hour Nights
543225 PCU Johnson City TENNESSEE 12 Hour Nights
543230 OR Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543243 CVOR Falls Church VIRGINIA 12 Hour Days RN/Registered Nurse
543245 Clinic Newport OREGON 8 Hour Days
543252 Telemetry Rock Hill SOUTH CAROLINA 12 Hour Nights
543259 Step Down Cleveland OHIO 12 Hour Nights
543260 Step Down Cleveland OHIO 12 Hour Nights
543285 SLP South San Francisco CALIFORNIA 8 Hour Days
543286 RAD Tech Lynwood CALIFORNIA 8 Hour Nights
543291 Surgical Tech Muskegon MICHIGAN 12 Hour Days
543293 PT Hudson FLORIDA Days
543296 OR Albuquerque NEW MEXICO 12 Hour Days
543297 OR Albuquerque NEW MEXICO Nights
543308 NICU Walnut Creek CALIFORNIA 12 Hour Days
543309 Telemetry Farmington CONNECTICUT 12 Hour Nights
543312 RAD Tech Denville NEW JERSEY Nights
543318 CT Tech Staten Island NEW YORK 8 Hour Evenings
543330 Ultrasound Tech San Angelo TEXAS 12 Hour Nights
543331 Cath Lab Dubuque IOWA 10 Hour Days
543332 CT Tech Waimea HAWAII 12 Hour Day/Night Rotate
543336 CT Tech Westerville OHIO 10 Hour Days
543337 OR Farmington CONNECTICUT 10 Hour Days
543338 OR Farmington CONNECTICUT 10 Hour Days
543343 CT Tech Staten Island NEW YORK 8 Hour Days
543355 Phlebotomist Farmington CONNECTICUT 8 Hour Days
543370 Surgical Tech Silver Spring MARYLAND Nights
543371 PACU Fresno CALIFORNIA 12 Hour Days
543373 PACU Fresno CALIFORNIA 12 Hour Days
543374 PACU Fresno CALIFORNIA 12 Hour Days
543378 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
543380 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
543387 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
543405 ICU Rome NEW YORK 12 Hour Nights
543406 PT Palm Springs CALIFORNIA 8 Hour Days
543407 PT Palm Springs CALIFORNIA 8 Hour Days
543419 SICU Bowling Green KENTUCKY 12 Hour Nights
543428 ICU Ogdensburg NEW YORK 12 Hour Nights
543439 L&D Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
543446 Acute Care Kingsport TENNESSEE 12 Hour Days
543454 Home Health Fargo NORTH DAKOTA 8 Hour Day/Night Rotate
543455 OR Cape Girardeau MISSOURI Days
543461 Oncology Kingsport TENNESSEE 12 Hour Nights
543465 Telemetry Wailuku HAWAII 12 Hour Nights
543466 Med Surg Tele Wailuku HAWAII 12 Hour Nights
543468 PT Athens GEORGIA 8 Hour Days
543475 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Nights
543480 Therapy Rehab Athens GEORGIA 8 Hour Days
543483 Med Surg Chillicothe OHIO 12 Hour Nights
543484 Certified Surgical Tech Abingdon VIRGINIA 8 Hour Day/Night Rotate
543486 Echo Waimea HAWAII 12 Hour Day/Night Rotate
543494 Med Surg Nashua NEW HAMPSHIRE 12 Hour Nights
543510 Ultrasound Tech Phoenix ARIZONA 12 Hour Day/Night Rotate
543519 MRI Tech Beachwood OHIO 8 Hour Nights
543527 Step Down Lansing MICHIGAN Nights
543535 Med Surg Spokane WASHINGTON 12 Hour Nights
543549 Med Surg Tele Concord CALIFORNIA 12 Hour Days
543550 Med Surg Tele Concord CALIFORNIA 12 Hour Days
543574 Case Manager Anchorage ALASKA 8 Hour Days
543575 Nuclear Med Technician Los Angeles CALIFORNIA 8 Hour Days
543585 CT Tech Laconia NEW HAMPSHIRE 12 Hour Days
543590 L&D Devils Lake NORTH DAKOTA 12 Hour Day/Night Rotate
543591 SLP Milan MISSOURI Days
543592 PACU Nashua NEW HAMPSHIRE 10 Hour Days
543593 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
543598 Rehab Twin Falls IDAHO 12 Hour Nights
543599 Telemetry Twin Falls IDAHO 12 Hour Nights
543607 Telemetry Nampa IDAHO 12 Hour Nights
543613 Telemetry Boise IDAHO 12 Hour Nights
543617 Social Worker Twin Falls IDAHO 8 Hour Nights
543618 Social Worker Twin Falls IDAHO 8 Hour Nights
543630 Surgical Tech Stafford Springs CONNECTICUT 8 Hour Days
543633 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
543644 ER Walnut Creek CALIFORNIA 12 Hour Nights
543645 ER Walnut Creek CALIFORNIA 12 Hour Nights
543646 ER Walnut Creek CALIFORNIA 12 Hour Nights
543647 ER Walnut Creek CALIFORNIA 12 Hour Nights
543648 ER Walnut Creek CALIFORNIA 12 Hour Nights
543649 ER Walnut Creek CALIFORNIA 12 Hour Nights
543650 ER Walnut Creek CALIFORNIA 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.3678 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 1400,100 in 1.2186 seconds