Listing all records

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

ID Job Specialty City State Shift Title
544060 ICU Pontiac MICHIGAN 12 Hour Nights
544061 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
544067 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
544091 Med Surg Norman OKLAHOMA 12 Hour Nights
544096 Cath Lab Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
544103 Phlebotomist Farmington CONNECTICUT 8 Hour Days
544104 OR Langhorne PENNSYLVANIA 12 Hour Nights
544116 Telemetry Cleveland OHIO 12 Hour Nights
544121 CT Tech Avalon CALIFORNIA 8 Hour Varied
544124 Cath Lab Fort Smith ARIZONA 8 Hour Day/Night Rotate
544142 Cath Lab Cleveland OHIO 10 Hour Days
544143 Cath Lab Cleveland OHIO 10 Hour Days
544144 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
544145 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
544149 Long Term Care Moscow IDAHO 12 Hour Nights
544152 Surgical Tech Farmington CONNECTICUT 10 Hour Days
544153 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
544158 PACU Cleveland OHIO 12 Hour Nights
544162 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
544167 PT Garden City KANSAS 12 Hour Day/Night Rotate
544168 COTA Madera CALIFORNIA Days
544177 Surgical Tech Madison WISCONSIN 8 Hour Day/Night Rotate
544192 PT Wrangell ALASKA Varied
544196 Interventional Radiology Tech Arlington VIRGINIA 10 Hour Days
544198 Med Surg Tele Euclid OHIO 12 Hour Nights
544199 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
544201 OR Germantown MARYLAND 8 Hour Evenings
544202 RAD Tech Dubuque IOWA 8 Hour Days
544204 Med Surg Sioux City IOWA 12 Hour Days
544205 Ultrasound Tech Silver Spring MARYLAND 10 Hour Evenings
544208 Med Surg Grove City OHIO 12 Hour Nights
544209 Med Surg Grove City OHIO 12 Hour Nights
544215 Med Surg Tele Pueblo COLORADO 12 Hour Nights
544217 Med Surg Pella IOWA 12 Hour Nights
544218 CVOR Newark NEW JERSEY 12 Hour Days
544219 Oncology Newark NEW JERSEY 12 Hour Days
544220 MICU Newark NEW JERSEY 8 Hour Nights
544221 OR Newark NEW JERSEY 12 Hour Days
544222 ICU Passaic NEW JERSEY 12 Hour Nights
544223 Surgical Tech Passaic NEW JERSEY 12 Hour Days
544224 Dialysis Dover NEW JERSEY 12 Hour Day/Night Rotate
544225 Med Surg Dover NEW JERSEY 12 Hour Nights
544226 MLT Denville NEW JERSEY 12 Hour Day/Night Rotate
544227 Nuclear Med Technician Denville NEW JERSEY 8 Hour Days
544228 CT Tech Denville NEW JERSEY 12 Hour Day/Night Rotate
544229 Dialysis Denville NEW JERSEY 12 Hour Day/Night Rotate
544230 ER Denville NEW JERSEY 12 Hour Nights
544231 ER Denville NEW JERSEY 12 Hour Days
544232 ER Denville NEW JERSEY 12 Hour Day/Night Rotate
544233 CCU Denville NEW JERSEY 12 Hour Nights
544234 Surgical Tech Denville NEW JERSEY 12 Hour Days
544235 Sterile Processing Tech Denville NEW JERSEY 8 Hour Days
544240 RAD Tech Reno NEVADA 12 Hour Days
544241 RAD Tech Reno NEVADA 12 Hour Days
544242 CT Tech Reno NEVADA 12 Hour Nights
544243 CT Tech Reno NEVADA 12 Hour Nights
544245 CVOR Reno NEVADA 12 Hour Day/Night Rotate
544251 OR Farmington CONNECTICUT 10 Hour Days
544263 Surgical Tech Westerville OHIO 12 Hour Days
544264 RAD Tech Silver Spring MARYLAND 8 Hour Evenings
544265 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
544266 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
544267 Med Surg Tele Syracuse NEW YORK 12 Hour Days
544268 Med Surg Tele Syracuse NEW YORK 12 Hour Days
544269 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
544270 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
544288 Dialysis Honolulu HAWAII 12 Hour Day/Night Rotate
544290 Infusion Oncology Sidney MONTANA Days
544293 OR Maywood ILLINOIS 10 Hour Days
544294 OR Maywood ILLINOIS 10 Hour Days
544303 Ultrasound Tech Portland OREGON 10 Hour Days
544310 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
544311 Cath Lab Charleston WEST VIRGINIA 12 Hour Days
544312 BMT Cleveland OHIO 12 Hour Day/Night Rotate
544313 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
544316 Cath Lab Willoughby OHIO 10 Hour Days
544343 CT Tech Boise IDAHO 10 Hour Nights
544344 L&D Ketchum IDAHO 12 Hour Nights
544345 Surgical Tech Ketchum IDAHO 12 Hour Days
544347 Certified Surgical Tech Lewiston IDAHO 10 Hour Days
544354 Med Surg Meridian IDAHO 12 Hour Nights
544359 NICU Queens NEW YORK 12 Hour Nights RN/Registered Nurse
544375 Ultrasound Tech Silver Spring MARYLAND 10 Hour Nights
544376 Sterile Processing Technician Langhorne PENNSYLVANIA Nights
544377 Ultrasound Tech Silver Spring MARYLAND 8 Hour Evenings
544378 Ultrasound Tech Silver Spring MARYLAND 8 Hour Days
544388 ICU Scottsbluff NEBRASKA 12 Hour Varied
544389 Lab Tech Syracuse NEW YORK 8 Hour Days
544390 Lab Tech Syracuse NEW YORK 8 Hour Days
544397 Med Surg Peoria ILLINOIS 12 Hour Days RN/Registered Nurse
544399 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
544403 First Assist Lancaster OHIO Days
544405 ER Walnut Creek CALIFORNIA 12 Hour Nights
544409 CT Tech Springfield VERMONT 8 Hour Nights
544411 CT Tech New London NEW HAMPSHIRE 12 Hour Nights
544422 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
544433 Ambulatory Syracuse NEW YORK 8 Hour Days
544434 Telemetry IOWA CITY IOWA 12 Hour Nights
544435 ER IOWA CITY IOWA 12 Hour Nights
544436 ER IOWA CITY IOWA 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.549 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 1600,100 in 1.3218 seconds