Listing all records

Displaying records 601 through 700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
542390 Pediatric ER New York NEW YORK 12 Hour Nights
545645 Pediatric ER Gainesville FLORIDA 12 Hour Nights
543760 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
546245 Neuro Intensive Care Seattle WASHINGTON 12 Hour Nights
540314 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Days
540121 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540259 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Days
540315 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540332 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
548253 Neuro Intensive Care Boston MASSACHUSETTS 12 Hour Days RN/Registered Nurse
548238 Neuro Intensive Care Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548355 Neuro Intensive Care Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
543759 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
540250 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
548298 Neuro Intensive Care PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
547735 Neuro Intensive Care Palo Alto CALIFORNIA 12 Hour Day/Night Rotate
543178 Neuro Intensive Care New York NEW YORK Days
547530 Cardiac ICU Chillicothe OHIO 12 Hour Nights
526998 Cardiac ICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
540706 Cardiac ICU Rockford ILLINOIS 12 Hour Nights
546358 Cardiac ICU Rock Hill SOUTH CAROLINA 12 Hour Nights
546639 Cardiac ICU Falls Church VIRGINIA 12 Hour Day/Night Rotate
546348 Cardiac ICU Detroit MICHIGAN 12 Hour Nights
548390 Cardiac Cath Lab Clackamas OREGON 10 Hour Days Advanced Practice
548389 Cardiac Cath Lab Clackamas OREGON 12 Hour Days Advanced Practice
545990 Neuro Med Surg/Tele Madison WISCONSIN 12 Hour Day/Night Rotate
547143 Neuro Med Surg/Tele Peoria ILLINOIS 12 Hour Nights
545991 Neuro Med Surg/Tele Madison WISCONSIN 12 Hour Day/Night Rotate
534331 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
548297 Neuro Med Surg/Tele Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
537922 Neuro Med Surg/Tele Des Moines IOWA 12 Hour Nights
547456 Neuro Med Surg/Tele Abilene TEXAS 12 Hour Nights
547468 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
539310 Speech Language Roseburg OREGON Days
548171 Speech Language Redding CALIFORNIA 10 Hour Days RN/Registered Nurse
548178 Speech Language Redding CALIFORNIA 10 Hour Days SLP/Speech Language Pathologist
541929 Management Corvallis OREGON 12 Hour Day/Night Rotate
535128 Management Tacoma WASHINGTON Varied
542040 Physician PHiladelphia PENNSYLVANIA 8 Hour Days
531994 Physician New Lisbon WISCONSIN Days
532081 Physician Stanley WISCONSIN 8 Hour Day/Night Rotate
547990 Cardiology Torrance CALIFORNIA 12 Hour Days
545867 Cardiology Gainesville FLORIDA 12 Hour Nights
547991 Cardiology Torrance CALIFORNIA 12 Hour Days
545389 Cardiology Coos Bay OREGON 8 Hour Days
546354 Cardiology Fountain Valley CALIFORNIA 12 Hour Days
525673 Cardiology Louisville KENTUCKY 8 Hour Days
545671 Cardiology Gainesville FLORIDA 12 Hour Nights
546142 Cardiology Muskegon MICHIGAN 12 Hour Days
545627 Cardiology Gainesville FLORIDA 12 Hour Nights
539177 Cardiology Albany NEW YORK 12 Hour Nights
545618 MLT Gainesville FLORIDA 8 Hour Nights
540139 MLT Walnut Creek CALIFORNIA 10 Hour Nights
545664 MLT Gainesville FLORIDA 8 Hour Days
546047 MLT Columbus OHIO Nights
512894 MLT Hickory NORTH CAROLINA 12 Hour Days
547579 MLT Watertown NEW YORK Nights
515845 MLT Louisville KENTUCKY Nights
539903 MLT Tuba City ARIZONA 12 Hour Day/Night Rotate
540972 MLT Des Moines IOWA 10 Hour Nights
545718 MLT Gainesville FLORIDA 8 Hour Nights
540009 MLT Farmington CONNECTICUT 8 Hour Evenings
544446 MLT Los Angeles CALIFORNIA 8 Hour Days
545668 MLT Gainesville FLORIDA 8 Hour Days
547302 MLT York MAINE 8 Hour Day/Night Rotate
540891 MLT Farmington CONNECTICUT 8 Hour Days
541109 MLT Syracuse NEW YORK 8 Hour Nights
545900 MLT Gainesville FLORIDA 12 Hour Nights
546795 MLT Estes Park COLORADO 12 Hour Nights
548018 MLT Aberdeen WASHINGTON 10 Hour Nights
547948 MLT Wolf Point MONTANA 8 Hour Days
547779 MLT Detroit MICHIGAN 8 Hour Evenings
545663 MLT Gainesville FLORIDA 12 Hour Nights
545662 MLT Gainesville FLORIDA 12 Hour Nights
544226 MLT Denville NEW JERSEY 12 Hour Day/Night Rotate
532661 MLT Louisville KENTUCKY 8 Hour Evenings
542345 MLT Westerville OHIO 8 Hour Nights
545761 MLT Gainesville FLORIDA 8 Hour Nights
545769 MLT Gainesville FLORIDA 8 Hour Evenings
540588 MLT Watertown NEW YORK Varied
540589 MLT Watertown NEW YORK Days
548036 MLT New Bern NORTH CAROLINA 10 Hour Nights
535301 MLT Pittsfield MASSACHUSETTS 10 Hour Nights
535302 MLT Pittsfield MASSACHUSETTS 8 Hour Days
544832 MLT East St Louis ILLINOIS 8 Hour Evenings
546877 MLT Pittsfield MASSACHUSETTS 8 Hour Days
544889 MLT Mason City IOWA 8 Hour Days
544598 MLT Des Moines IOWA 8 Hour Days
540892 MLT Farmington CONNECTICUT 8 Hour Days
545413 MLT Ely NEVADA 12 Hour Days
545901 MLT Gainesville FLORIDA 8 Hour Days
539078 MLT Des Moines IOWA 8 Hour Days
539093 MLT Des Moines IOWA 12 Hour Days
539095 MLT Des Moines IOWA 8 Hour Days
509595 Anesthesia Tech Everett WASHINGTON 12 Hour Varied
543978 Scrub Tech Lamar COLORADO 8 Hour Day/Night Rotate
539384 Scrub Tech Newark NEW JERSEY 12 Hour Days
543785 Scrub Tech Redding CALIFORNIA 12 Hour Day/Night Rotate
547815 Scrub Tech Yuma COLORADO 12 Hour Nights
544617 Scrub Tech Rio Rancho NEW MEXICO 10 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.5965 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 desc limit 600,100 in 1.513 seconds