Listing all records

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

ID Job Specialty City State Shift Title
537785 SLP Fargo NORTH DAKOTA Days
547965 SLP Spanaway WASHINGTON Days
546181 SLP Cooperstown NEW YORK 8 Hour Days
541028 SLP MERCED CALIFORNIA 8 Hour Days
547745 SLP Philadelphia PENNSYLVANIA Days
542847 SLP Oakland NEW JERSEY Days
542462 SLP Williamstown NEW JERSEY Days
542780 SLP Oakhurst CALIFORNIA Days
543285 SLP South San Francisco CALIFORNIA 8 Hour Days
543591 SLP Milan MISSOURI Days
546931 SLP Visalia CALIFORNIA 8 Hour Days
544485 SLP Danvers MASSACHUSETTS Days
544608 SLP Syracuse NEW YORK 8 Hour Days
547582 SLP Lincoln City OREGON 8 Hour Days
547332 SLP Garden City KANSAS Varied
545316 SLP Eureka CALIFORNIA 8 Hour Days
547902 SLP Madison WISCONSIN 8 Hour Days
548283 Nurse Practicioner Syracuse NEW YORK 8 Hour Days NP/Nurse Practitioner
525662 Nurse Practicioner Syracuse NEW YORK 12 Hour Varied
525929 Nurse Practicioner Brooklyn NEW YORK 8 Hour Days
548076 Case Manager Burbank CALIFORNIA 8 Hour Days RN/Registered Nurse
547992 Case Manager Torrance CALIFORNIA 8 Hour Days
504074 Case Manager San Francisco CALIFORNIA 8 Hour Days
516543 Case Manager SUNNYVALE CALIFORNIA 8 Hour Days
516544 Case Manager SUNNYVALE CALIFORNIA 8 Hour Days
548044 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
518108 Case Manager Burbank CALIFORNIA 8 Hour Days
542785 Case Manager Glens Falls NEW YORK 8 Hour Days
545669 Case Manager Gainesville FLORIDA 10 Hour Days
527987 Case Manager Albuquerque NEW MEXICO 10 Hour Days
548107 Case Manager Littleton NEW HAMPSHIRE 8 Hour Days RN/Registered Nurse
548192 Case Manager BAKERSFIELD CALIFORNIA 8 Hour Days RN/Registered Nurse
540446 Case Manager Napa CALIFORNIA 8 Hour Days
539979 Case Manager Petoskey MICHIGAN 8 Hour Days
547539 Case Manager Vail COLORADO Days
540081 Case Manager Concord CALIFORNIA 8 Hour Days
540098 Case Manager Concord CALIFORNIA 8 Hour Evenings
548179 Case Manager Falls Church VIRGINIA 8 Hour Days RN/Registered Nurse
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
546081 Case Manager Santa Monica CALIFORNIA 8 Hour Days
540308 Case Manager Concord CALIFORNIA 8 Hour Evenings
540423 Case Manager Oceanside CALIFORNIA 8 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
542838 Case Manager Eureka CALIFORNIA 8 Hour Days
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
548078 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
545755 Case Manager Gainesville FLORIDA 8 Hour Days
548108 Case Manager Indianaplis INDIANA 8 Hour Days RN/Registered Nurse
545120 Case Manager Anchorage ALASKA 8 Hour Days
543419 SICU Bowling Green KENTUCKY 12 Hour Nights
520665 PICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
547618 PICU Santa Clara CALIFORNIA 12 Hour Days
521326 PICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
524120 PICU Anchorage ALASKA 12 Hour Nights RN/Registered Nurse
527684 PICU New York NEW YORK 12 Hour Days RN/Registered Nurse
547616 PICU Santa Clara CALIFORNIA 12 Hour Days
531766 PICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548079 PICU Roseville CALIFORNIA 12 Hour Nights RN/Registered Nurse
545692 PICU Gainesville FLORIDA 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
547832 PICU Syracuse NEW YORK Nights
540165 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540221 PICU Walnut Creek CALIFORNIA 12 Hour Days
540233 PICU Walnut Creek CALIFORNIA 12 Hour Days
547586 PICU Santa Clara CALIFORNIA 12 Hour Nights
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
540339 PICU Walnut Creek CALIFORNIA 12 Hour Days
547610 PICU Santa Clara CALIFORNIA 12 Hour Days
547611 PICU Santa Clara CALIFORNIA 12 Hour Nights
547613 PICU Santa Clara CALIFORNIA 12 Hour Nights
547612 PICU Santa Clara CALIFORNIA 12 Hour Nights
547614 PICU Santa Clara CALIFORNIA 12 Hour Nights
547962 PICU Madison WISCONSIN 12 Hour Day/Night Rotate
547621 PICU Santa Clara CALIFORNIA 12 Hour Days
547620 PICU Santa Clara CALIFORNIA 12 Hour Days
546801 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
547070 PICU Walnut Creek CALIFORNIA 12 Hour Days
547071 PICU Walnut Creek CALIFORNIA 12 Hour Days
548295 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548135 CVICU Stockton CALIFORNIA 12 Hour Nights RN/Registered Nurse
541958 CVICU Spokane WASHINGTON 12 Hour Nights
525187 CVICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548149 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
545292 CVICU Memphis TENNESSEE 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.4974 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 2000,100 in 1.4238 seconds