Listing all records

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

ID Job Specialty City State Shift Title
546784 Pediatrics Gardner MASSACHUSETTS 12 Hour Nights
548004 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
546039 Pediatrics Hilo HAWAII 12 Hour Nights
546228 Pediatrics Concord NEW HAMPSHIRE 12 Hour Nights
528573 Pediatrics Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
531394 Pediatrics Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
546037 Pediatrics Hilo HAWAII 12 Hour Varied
546050 Pediatrics Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
547497 Pediatrics Hilo HAWAII 12 Hour Nights
540168 Pediatrics Walnut Creek CALIFORNIA 12 Hour Nights
545966 Pediatrics Gainesville FLORIDA 12 Hour Nights
547794 Pediatrics Valley City NORTH DAKOTA Nights
540326 Pediatrics Walnut Creek CALIFORNIA 12 Hour Days
545992 Pediatrics King City CALIFORNIA 12 Hour Nights
547561 Pediatrics Fort Defiance ARIZONA 12 Hour Day/Night Rotate
546276 Pediatrics Sitka ALASKA Varied
548209 OB South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
494609 PCU Casa Grande ARIZONA 12 Hour Nights
548269 PCU Chillicothe OHIO 12 Hour Nights RN/Registered Nurse
547459 PCU Abilene TEXAS 12 Hour Day/Night Rotate
547758 PCU Phoenix ARIZONA 12 Hour Nights
547847 PCU Tarzana CALIFORNIA 12 Hour Nights
546005 PCU Mesa ARIZONA 12 Hour Days
545140 PCU Coos Bay OREGON 12 Hour Nights
547729 PCU Mesa ARIZONA 12 Hour Days
528069 PCU Flagstaff ARIZONA 12 Hour Nights RN/Registered Nurse
547654 PCU Kearney NEBRASKA 12 Hour Nights
547658 PCU Omaha NEBRASKA 12 Hour Nights
547659 PCU Omaha NEBRASKA 12 Hour Days
548147 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
531418 PCU Phoenix ARIZONA 12 Hour Nights
547727 PCU Sun City ARIZONA 12 Hour Days
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
548399 PCU Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548041 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
546718 PCU Centralia WASHINGTON 12 Hour Nights
548073 PCU Palm Springs CALIFORNIA 12 Hour Days RN/Registered Nurse
544995 PCU Omaha NEBRASKA 12 Hour Nights
548087 PCU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
546744 PCU Charleston WEST VIRGINIA 12 Hour Nights
537910 PCU Lexington KENTUCKY 12 Hour Nights
548101 PCU Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
547455 PCU Abilene TEXAS 12 Hour Days
538460 PCU Grand Island NEBRASKA 12 Hour Nights
539110 PCU Concord CALIFORNIA 12 Hour Nights
548148 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
539616 PCU Johnson City TENNESSEE 12 Hour Nights
539618 PCU Johnson City TENNESSEE 12 Hour Days
539620 PCU Johnson City TENNESSEE 12 Hour Nights
547728 PCU Mesa ARIZONA 12 Hour Nights
540006 PCU Walnut Creek CALIFORNIA 12 Hour Nights
540029 PCU Concord CALIFORNIA 8 Hour Days
540034 PCU Concord CALIFORNIA 8 Hour Nights
540035 PCU Concord CALIFORNIA 8 Hour Days
545291 PCU Rock Hill SOUTH CAROLINA 12 Hour Nights
545482 PCU Lancaster SOUTH CAROLINA 12 Hour Nights
546629 PCU Bristol TENNESSEE 12 Hour Days
546216 PCU Sun City ARIZONA 12 Hour Nights
544944 PCU Johnson City TENNESSEE 12 Hour Days
544558 PCU Spokane WASHINGTON 12 Hour Nights
546217 PCU Sun City ARIZONA 12 Hour Nights
544536 PCU Hilo HAWAII Varied
544518 PCU Fayetteville NORTH CAROLINA 12 Hour Nights
547376 PCU Charlottesville VIRGINIA 12 Hour Nights
545343 PCU Concord NEW HAMPSHIRE 12 Hour Nights
547540 PCU Coos Bay OREGON 12 Hour Days
547377 PCU Albuquerque NEW MEXICO 12 Hour Days
547762 PCU Glendale ARIZONA 12 Hour Nights
540743 PCU Concord CALIFORNIA 12 Hour Days
540744 PCU Concord CALIFORNIA 12 Hour Days
545003 PCU Palm Springs CALIFORNIA 12 Hour Nights
545035 PCU Concord NEW HAMPSHIRE 12 Hour Nights
547657 PCU Omaha NEBRASKA 12 Hour Nights
541271 PCU Bismarck NORTH DAKOTA Nights
541332 PCU Albuquerque NEW MEXICO 12 Hour Nights
548100 PCU Pittsfield MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
541500 PCU Spokane WASHINGTON 12 Hour Nights
541501 PCU Spokane WASHINGTON 12 Hour Nights
541503 PCU Spokane WASHINGTON 12 Hour Nights
541504 PCU Spokane WASHINGTON 12 Hour Nights
541505 PCU Spokane WASHINGTON 12 Hour Nights
541518 PCU Spokane WASHINGTON 12 Hour Nights
541519 PCU Spokane WASHINGTON 12 Hour Nights
541521 PCU Spokane WASHINGTON 12 Hour Days
541522 PCU Spokane WASHINGTON 12 Hour Days
541524 PCU Spokane WASHINGTON 12 Hour Nights
541525 PCU Spokane WASHINGTON 12 Hour Days
541526 PCU Spokane WASHINGTON 12 Hour Days
541527 PCU Spokane WASHINGTON 12 Hour Days
548123 PCU Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
546012 PCU Hays KANSAS 12 Hour Nights
542617 PCU Sun City West ARIZONA 12 Hour Nights
542618 PCU Sun City West ARIZONA 12 Hour Days
542779 PCU Bristol TENNESSEE 12 Hour Nights
542790 PCU Kingsport TENNESSEE 12 Hour Nights
543225 PCU Johnson City TENNESSEE 12 Hour Nights
548057 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
545262 PCU Omaha NEBRASKA 12 Hour Nights
544034 PCU Spokane WASHINGTON 12 Hour Nights
547066 PCU Rio Rancho NEW MEXICO 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.7154 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 1600,100 in 1.6081 seconds