Listing all records

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

ID Job Specialty City State Shift Title
548251 ICU Seattle WASHINGTON 12 Hour Days RN/Registered Nurse
548252 ICU - Per Diem Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548253 Neuro Intensive Care Boston MASSACHUSETTS 12 Hour Days RN/Registered Nurse
548254 Home Health Santa Rosa CALIFORNIA 8 Hour Days 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
548177 ICU Rancho Cordova CALIFORNIA 12 Hour Nights RN/Registered Nurse
548039 OR Petersburg WEST VIRGINIA 8 Hour Days RN/Registered Nurse
548040 PCU Lowell MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
548041 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
548042 ER Pendleton OREGON 12 Hour Varied RN/Registered Nurse
548043 OR Bakersfield CALIFORNIA 8 Hour Days RN/Registered Nurse
548044 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548045 OR NORTHRIDGE CALIFORNIA 12 Hour Nights RN/Registered Nurse
548046 OR BAKERSFIELD CALIFORNIA 8 Hour Days RN/Registered Nurse
548145 Telemetry Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548138 ER Truth or Consequences NEW MEXICO 12 Hour Days RN/Registered Nurse
548152 ICU Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548144 House Supervisor New York NEW YORK 8 Hour Days RN/Registered Nurse
548141 L&D Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548052 Med Surg Pontiac MICHIGAN 12 Hour Nights RN/Registered Nurse
548053 NICU New York NEW YORK 12 Hour Days RN/Registered Nurse
548054 CVOR STOCKTON CALIFORNIA 12 Hour Days RN/Registered Nurse
548055 ER Glens Falls NEW YORK 12 Hour Nights RN/Registered Nurse
548056 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548057 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
548058 Dialysis Brooklyn NEW YORK 10 Hour Days RN/Registered Nurse
548156 Med Surg Weirton WEST VIRGINIA 12 Hour Days RN/Registered Nurse
548060 ICU Casper WYOMING 12 Hour Days RN/Registered Nurse
548061 PACU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
548062 L&D Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548063 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548143 House Supervisor New York NEW YORK 8 Hour Days RN/Registered Nurse
548065 Step Down SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
548066 ICU Bellefontaine OHIO 12 Hour Nights RN/Registered Nurse
548172 PT Red Bluff CALIFORNIA 8 Hour Days RN/Registered Nurse
548069 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548072 ER Lansing MICHIGAN 12 Hour Days RN/Registered Nurse
548073 PCU Palm Springs CALIFORNIA 12 Hour Days RN/Registered Nurse
548074 ICU - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
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
548155 OR Coos Bay OREGON 10 Hour Days RN/Registered Nurse
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
548157 Psych Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
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
548147 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
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
548146 Med Surg Bakersfield CALIFORNIA 12 Hour Nights RN/Registered Nurse
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
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.8255 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.title asc limit 3400,100 in 1.4755 seconds