Listing all records

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

ID Job Specialty City State Shift Title
494609 PCU Casa Grande ARIZONA 12 Hour Nights
548269 PCU Chillicothe OHIO 12 Hour Nights RN/Registered Nurse
547729 PCU Mesa ARIZONA 12 Hour Days
548100 PCU Pittsfield MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
546216 PCU Sun City ARIZONA 12 Hour Nights
546744 PCU Charleston WEST VIRGINIA 12 Hour Nights
548087 PCU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
546687 PCU San Luis Obispo CALIFORNIA 12 Hour Days
528069 PCU Flagstaff ARIZONA 12 Hour Nights RN/Registered Nurse
531418 PCU Phoenix ARIZONA 12 Hour Nights
547727 PCU Sun City ARIZONA 12 Hour Days
548123 PCU Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
547459 PCU Abilene TEXAS 12 Hour Day/Night Rotate
548057 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
535783 PCU Tucson ARIZONA 12 Hour Nights
537910 PCU Lexington KENTUCKY 12 Hour Nights
547658 PCU Omaha NEBRASKA 12 Hour Nights
538460 PCU Grand Island NEBRASKA 12 Hour Nights
548406 PCU Pittsfield MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
539110 PCU Concord CALIFORNIA 12 Hour Nights
546005 PCU Mesa ARIZONA 12 Hour Days
539616 PCU Johnson City TENNESSEE 12 Hour Nights
547455 PCU Abilene TEXAS 12 Hour Days
539618 PCU Johnson City TENNESSEE 12 Hour Days
539620 PCU Johnson City TENNESSEE 12 Hour Nights
547728 PCU Mesa ARIZONA 12 Hour Nights
548147 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
540006 PCU Walnut Creek CALIFORNIA 12 Hour Nights
548148 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
540029 PCU Concord CALIFORNIA 8 Hour Days
540034 PCU Concord CALIFORNIA 8 Hour Nights
540035 PCU Concord CALIFORNIA 8 Hour Days
547847 PCU Tarzana CALIFORNIA 12 Hour Nights
548040 PCU Lowell MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
547066 PCU Rio Rancho NEW MEXICO 12 Hour Nights
548399 PCU Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
547540 PCU Coos Bay OREGON 12 Hour Days
547654 PCU Kearney NEBRASKA 12 Hour Nights
546683 PCU Birmingham ALABAMA 12 Hour Nights
548073 PCU Palm Springs CALIFORNIA 12 Hour Days RN/Registered Nurse
540743 PCU Concord CALIFORNIA 12 Hour Days
540744 PCU Concord CALIFORNIA 12 Hour Days
541271 PCU Bismarck NORTH DAKOTA Nights
547657 PCU Omaha NEBRASKA 12 Hour Nights
541332 PCU Albuquerque NEW MEXICO 12 Hour Nights
547659 PCU Omaha NEBRASKA 12 Hour Days
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
548101 PCU Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
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
546012 PCU Hays KANSAS 12 Hour Nights
543225 PCU Johnson City TENNESSEE 12 Hour Nights
547374 PCU Albuquerque NEW MEXICO 12 Hour Days
547376 PCU Charlottesville VIRGINIA 12 Hour Nights
547758 PCU Phoenix ARIZONA 12 Hour Nights
547762 PCU Glendale ARIZONA 12 Hour Nights
544034 PCU Spokane WASHINGTON 12 Hour Nights
547377 PCU Albuquerque NEW MEXICO 12 Hour Days
546217 PCU Sun City ARIZONA 12 Hour Nights
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
544518 PCU Fayetteville NORTH CAROLINA 12 Hour Nights
544536 PCU Hilo HAWAII Varied
544558 PCU Spokane WASHINGTON 12 Hour Nights
548021 PCU Abilene TEXAS 12 Hour Nights
548041 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
544944 PCU Johnson City TENNESSEE 12 Hour Days
544995 PCU Omaha NEBRASKA 12 Hour Nights
545003 PCU Palm Springs CALIFORNIA 12 Hour Nights
545035 PCU Concord NEW HAMPSHIRE 12 Hour Nights
546718 PCU Centralia WASHINGTON 12 Hour Nights
546686 PCU San Luis Obispo CALIFORNIA 12 Hour Nights
545140 PCU Coos Bay OREGON 12 Hour Nights
548082 PCU Torrance CALIFORNIA 12 Hour Days RN/Registered Nurse
545262 PCU Omaha NEBRASKA 12 Hour Nights
545291 PCU Rock Hill SOUTH CAROLINA 12 Hour Nights
545343 PCU Concord NEW HAMPSHIRE 12 Hour Nights
545482 PCU Lancaster SOUTH CAROLINA 12 Hour Nights
546629 PCU Bristol TENNESSEE 12 Hour Days
548209 OB South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
547794 Pediatrics Valley City NORTH DAKOTA Nights
548004 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
540168 Pediatrics Walnut Creek CALIFORNIA 12 Hour Nights
547136 Pediatrics Quincy CALIFORNIA Nights
546039 Pediatrics Hilo HAWAII 12 Hour Nights
546276 Pediatrics Sitka ALASKA Varied
547088 Pediatrics Pittsfield MASSACHUSETTS 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.6671 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 2000,100 in 1.5709 seconds