Listing all records

Displaying records 1601 through 1700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548360 CVICU Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
545299 CVICU Little Rock ARKANSAS 12 Hour Nights
548306 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548149 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548232 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
538454 CVICU Little Rock ARKANSAS 12 Hour Nights
548396 CVICU SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
546627 CVICU Madison WISCONSIN 8 Hour Day/Night Rotate
548276 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548080 CVICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
548135 CVICU Stockton CALIFORNIA 12 Hour Nights RN/Registered Nurse
548386 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
542008 CVICU Little Rock ARKANSAS 12 Hour Days
548208 CVICU Santa Clara CALIFORNIA 12 Hour Days RN/Registered Nurse
546984 CVICU Albany NEW YORK 12 Hour Nights
547614 PICU Santa Clara CALIFORNIA 12 Hour Nights
520665 PICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521326 PICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
547610 PICU Santa Clara CALIFORNIA 12 Hour Days
524120 PICU Anchorage ALASKA 12 Hour Nights RN/Registered Nurse
527684 PICU New York NEW YORK 12 Hour Days RN/Registered Nurse
547586 PICU Santa Clara CALIFORNIA 12 Hour Nights
547612 PICU Santa Clara CALIFORNIA 12 Hour Nights
547618 PICU Santa Clara CALIFORNIA 12 Hour Days
531766 PICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
547071 PICU Walnut Creek CALIFORNIA 12 Hour Days
545692 PICU Gainesville FLORIDA 12 Hour Nights
548079 PICU Roseville CALIFORNIA 12 Hour Nights RN/Registered Nurse
547611 PICU Santa Clara CALIFORNIA 12 Hour Nights
540007 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540075 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540110 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540165 PICU Walnut Creek CALIFORNIA 12 Hour Nights
546801 PICU Walnut Creek CALIFORNIA 12 Hour Days
540221 PICU Walnut Creek CALIFORNIA 12 Hour Days
540233 PICU Walnut Creek CALIFORNIA 12 Hour Days
540262 PICU Walnut Creek CALIFORNIA 12 Hour Days
540280 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540283 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540285 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540288 PICU Walnut Creek CALIFORNIA 12 Hour Nights
547832 PICU Syracuse NEW YORK Nights
540339 PICU Walnut Creek CALIFORNIA 12 Hour Days
547613 PICU Santa Clara CALIFORNIA 12 Hour Nights
547616 PICU Santa Clara CALIFORNIA 12 Hour Days
547621 PICU Santa Clara CALIFORNIA 12 Hour Days
547620 PICU Santa Clara CALIFORNIA 12 Hour Days
547070 PICU Walnut Creek CALIFORNIA 12 Hour Days
548322 PICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
543787 PICU Detroit MICHIGAN 12 Hour Days
547962 PICU Madison WISCONSIN 12 Hour Day/Night Rotate
543419 SICU Bowling Green KENTUCKY 12 Hour Nights
504074 Case Manager San Francisco CALIFORNIA 8 Hour Days
547539 Case Manager Vail COLORADO Days
516543 Case Manager SUNNYVALE CALIFORNIA 8 Hour Days
516544 Case Manager SUNNYVALE CALIFORNIA 8 Hour Days
518108 Case Manager Burbank CALIFORNIA 8 Hour Days
542785 Case Manager Glens Falls NEW YORK 8 Hour Days
548076 Case Manager Burbank CALIFORNIA 8 Hour Days RN/Registered Nurse
527987 Case Manager Albuquerque NEW MEXICO 10 Hour Days
548192 Case Manager BAKERSFIELD CALIFORNIA 8 Hour Days RN/Registered Nurse
548078 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
540446 Case Manager Napa CALIFORNIA 8 Hour Days
548108 Case Manager Indianaplis INDIANA 8 Hour Days RN/Registered Nurse
548179 Case Manager Falls Church VIRGINIA 8 Hour Days RN/Registered Nurse
539979 Case Manager Petoskey MICHIGAN 8 Hour Days
540081 Case Manager Concord CALIFORNIA 8 Hour Days
540098 Case Manager Concord CALIFORNIA 8 Hour Evenings
547992 Case Manager Torrance CALIFORNIA 8 Hour Days
540179 Case Manager Concord CALIFORNIA 12 Hour Days
540194 Case Manager Concord CALIFORNIA 8 Hour Days
540214 Case Manager Concord CALIFORNIA 8 Hour Evenings
540253 Case Manager Concord CALIFORNIA 8 Hour Days
540308 Case Manager Concord CALIFORNIA 8 Hour Evenings
546081 Case Manager Santa Monica CALIFORNIA 8 Hour Days
540423 Case Manager Oceanside CALIFORNIA 8 Hour Days
545669 Case Manager Gainesville FLORIDA 10 Hour Days
540878 Case Manager Farmington CONNECTICUT 8 Hour Evenings
541543 Case Manager Portland OREGON 8 Hour Days
541635 Case Manager Woonsocket RHODE ISLAND 8 Hour Days
548044 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
545755 Case Manager Gainesville FLORIDA 8 Hour Days
542838 Case Manager Eureka CALIFORNIA 8 Hour Days
545120 Case Manager Anchorage ALASKA 8 Hour Days
548107 Case Manager Littleton NEW HAMPSHIRE 8 Hour Days RN/Registered Nurse
543574 Case Manager Anchorage ALASKA 8 Hour Days
543802 Case Manager Attleboro MASSACHUSETTS 8 Hour Days
543808 Case Manager Anchorage ALASKA 8 Hour Days
547813 Case Manager Woonsocket RHODE ISLAND 8 Hour Days
525662 Nurse Practicioner Syracuse NEW YORK 12 Hour Varied
525929 Nurse Practicioner Brooklyn NEW YORK 8 Hour Days
548283 Nurse Practicioner Syracuse NEW YORK 8 Hour Days NP/Nurse Practitioner
495103 SLP South Bend INDIANA Days
517691 SLP Vernon CONNECTICUT Days
546931 SLP Visalia CALIFORNIA 8 Hour Days
534093 SLP Freehold NEW JERSEY Days
534628 SLP Pomona CALIFORNIA Days
534629 SLP Pomona CALIFORNIA Days
535334 SLP Pasco WASHINGTON 12 Hour Day/Night Rotate
547745 SLP Philadelphia PENNSYLVANIA 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.3186 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 asc limit 1600,100 in 1.4707 seconds