Listing all records

Displaying records 3401 through 3500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548076 Case Manager Burbank CALIFORNIA 8 Hour Days RN/Registered Nurse
548078 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548079 PICU Roseville CALIFORNIA 12 Hour Nights RN/Registered Nurse
548080 CVICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
548081 ICU Hartford CONNECTICUT 12 Hour Nights RN/Registered Nurse
548082 PCU Torrance CALIFORNIA 12 Hour Days RN/Registered Nurse
548083 Surgical Tech Seattle WASHINGTON 10 Hour Days Tech/Technologist
548084 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548085 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
548086 Ultrasound Tech Cobleskill NEW YORK 8 Hour Days Tech/Technologist
548087 PCU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
548088 ER Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
548089 NICU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
548091 OR Columbia SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
548093 ER Albuquerque NEW MEXICO 12 Hour Nights RN/Registered Nurse
548094 ER ODESSA TEXAS 12 Hour Nights RN/Registered Nurse
548095 ER Sterling COLORADO 12 Hour Nights RN/Registered Nurse
548096 Med Surg Espanola NEW MEXICO 12 Hour Nights RN/Registered Nurse
548097 Med Surg Tele Lufkin TEXAS 12 Hour Days RN/Registered Nurse
548098 Med Surg Tele Chandler ARIZONA 12 Hour Day/Night Rotate RN/Registered Nurse
548099 Telemetry - Per Diem Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548100 PCU Pittsfield MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
548101 PCU Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
548103 L&D New York NEW YORK 12 Hour Days RN/Registered Nurse
548104 Telemetry - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548105 OR Cleveland OHIO 10 Hour Days RN/Registered Nurse
548106 ER Cobleskill NEW YORK 12 Hour Nights RN/Registered Nurse
548107 Case Manager Littleton NEW HAMPSHIRE 8 Hour Days RN/Registered Nurse
548108 Case Manager Indianaplis INDIANA 8 Hour Days RN/Registered Nurse
548110 Med Surg Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
548111 Respiratory Therapist Indianapolis INDIANA 12 Hour Nights Respiratory Therapist
548112 ER Rome NEW YORK 12 Hour Nights RN/Registered Nurse
548114 Telemetry MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
548115 Telemetry Brattleboro VERMONT 12 Hour Nights RN/Registered Nurse
548116 ICU Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548117 Postpartum New York NEW YORK 8 Hour Days RN/Registered Nurse
548118 ER Wailuku HAWAII 12 Hour Days RN/Registered Nurse
548120 Med Surg Tele Honolulu HAWAII 12 Hour Days RN/Registered Nurse
548121 Med Surg Kula HAWAII 12 Hour Nights RN/Registered Nurse
548122 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548123 PCU Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
548124 Med Surg Tele Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
548125 Med Surg Tele Cooperstown NEW YORK 12 Hour Varied RN/Registered Nurse
548126 Med Surg Tele Princeton WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
548127 ICU Glens Falls NEW YORK 12 Hour Days RN/Registered Nurse
548129 L&D Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548130 ER New York NEW YORK 12 Hour Nights RN/Registered Nurse
548131 Respiratory Therapist Keene NEW HAMPSHIRE 12 Hour Nights Respiratory Therapist
548132 ER Peterborough NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548133 Cath Lab Mesa ARIZONA 12 Hour Days RN/Registered Nurse
548134 Med Surg Tele Burien WASHINGTON 12 Hour Nights RN/Registered Nurse
548135 CVICU Stockton CALIFORNIA 12 Hour Nights RN/Registered Nurse
548136 ICU Glens Falls NEW YORK 12 Hour Nights RN/Registered Nurse
548137 Med Surg Modesto CALIFORNIA 12 Hour Nights RN/Registered Nurse
548138 ER Truth or Consequences NEW MEXICO 12 Hour Days RN/Registered Nurse
548139 Newborn Nursery Marion INDIANA 12 Hour Nights RN/Registered Nurse
548140 Surgical Tech Nacogdoches TEXAS 8 Hour Days CST/Certified Surgical Technician
548141 L&D Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548142 OR Bakersfield CALIFORNIA 8 Hour Day/Night Rotate RN/Registered Nurse
548143 House Supervisor New York NEW YORK 8 Hour Days RN/Registered Nurse
548144 House Supervisor New York NEW YORK 8 Hour Days RN/Registered Nurse
548145 Telemetry Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548146 Med Surg Bakersfield CALIFORNIA 12 Hour Nights RN/Registered Nurse
548147 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
548148 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
548149 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548150 NICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548151 L&D Silverdale WASHINGTON 12 Hour Days RN/Registered Nurse
548152 ICU Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548153 Home Health Pomona CALIFORNIA 8 Hour Days RN/Registered Nurse
548154 Home Health Los Angeles Downey CALIFORNIA 8 Hour Days RN/Registered Nurse
548155 OR Coos Bay OREGON 10 Hour Days RN/Registered Nurse
548156 Med Surg Weirton WEST VIRGINIA 12 Hour Days RN/Registered Nurse
548157 Psych Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
548158 Scrub Tech Abilene TEXAS 8 Hour Days CST/Certified Surgical Technician
548159 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548160 Med Surg Prince Frederick MARYLAND 12 Hour Nights RN/Registered Nurse
548161 Surgical Tech MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
548162 OR Centerville IOWA 8 Hour Days RN/Registered Nurse
548163 OR Mason City IOWA 8 Hour Days RN/Registered Nurse
548164 LTAC Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548165 ICU San Jose CALIFORNIA 12 Hour Nights RN/Registered Nurse
548166 Med Surg Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
548167 ER Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548168 Certified Surgical Tech Coos Bay OREGON 10 Hour Days RN/Registered Nurse
548169 Interventional Radiology Tech Indianaplis INDIANA 10 Hour Nights Radiology Techs/Technologists
548170 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548171 Speech Language Redding CALIFORNIA 10 Hour Days RN/Registered Nurse
548172 PT Red Bluff CALIFORNIA 8 Hour Days RN/Registered Nurse
548173 Med Surg Auburn NEW YORK 12 Hour Nights RN/Registered Nurse
548174 Psych Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548176 Med Surg Tele Syracuse NEW YORK 12 Hour Days RN/Registered Nurse
548177 ICU Rancho Cordova CALIFORNIA 12 Hour Nights RN/Registered Nurse
548178 Speech Language Redding CALIFORNIA 10 Hour Days SLP/Speech Language Pathologist
548179 Case Manager Falls Church VIRGINIA 8 Hour Days RN/Registered Nurse
548180 Pediatric ER Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548181 ICU Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548182 CCU Pittsfield MASSACHUSETTS 12 Hour Days RN/Registered Nurse
548183 Home Health Anaheim CALIFORNIA 8 Hour Days RN/Registered Nurse
548184 Psych Salem MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
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.442 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.id asc limit 3400,100 in 1.2512 seconds