Listing all records

Displaying records 1 through 100 out of a total 3,709 records. Next

ID Job Specialty City State Shift Title
540203 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540057 ICU Walnut Creek CALIFORNIA 12 Hour Nights
530342 ICU Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
523775 ICU Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
542740 ICU Saratoga Springs NEW YORK 12 Hour Nights
545629 ICU Gainesville FLORIDA 12 Hour Nights
540276 ICU Concord CALIFORNIA 12 Hour Nights
540055 ICU Farmington CONNECTICUT 12 Hour Nights
548262 ICU Arcata CALIFORNIA 12 Hour Days RN/Registered Nurse
543884 ICU Philadelphia PENNSYLVANIA 12 Hour Days
531138 ICU Ogdensburg NEW YORK 12 Hour Nights
545242 ICU Scottsbluff NEBRASKA 12 Hour Varied
538179 ICU San Diego CALIFORNIA 12 Hour Day/Night Rotate
540282 ICU Walnut Creek CALIFORNIA 12 Hour Nights
542063 ICU Wailuku HAWAII 12 Hour Nights
540118 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540235 ICU Concord CALIFORNIA 12 Hour Days
543668 ICU Bristol TENNESSEE 12 Hour Days
531580 ICU Dubuque IOWA 12 Hour Days
540241 ICU Concord CALIFORNIA 12 Hour Days
544388 ICU Scottsbluff NEBRASKA 12 Hour Varied
536463 ICU Lexington KENTUCKY 12 Hour Nights
540117 ICU Walnut Creek CALIFORNIA 12 Hour Nights
541786 ICU The Dalles OREGON 12 Hour Day/Night Rotate
537141 ICU Ogdensburg NEW YORK 12 Hour Nights
543965 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
540042 ICU Concord CALIFORNIA 12 Hour Days
543669 ICU Bristol TENNESSEE 12 Hour Nights
544570 ICU Burbank CALIFORNIA 12 Hour Nights
532473 ICU Maywood ILLINOIS 12 Hour Nights
542908 ICU Cleveland OHIO 12 Hour Day/Night Rotate
540216 ICU Walnut Creek CALIFORNIA 12 Hour Nights
536431 ICU Ann Arbor MICHIGAN 12 Hour Nights
538741 ICU Cleveland OHIO 12 Hour Day/Night Rotate
540345 ICU Walnut Creek CALIFORNIA 12 Hour Nights
523478 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548267 ICU Auburn NEW YORK 12 Hour Nights RN/Registered Nurse
521322 ICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
542781 ICU Boise IDAHO 12 Hour Nights
542782 ICU Boise IDAHO 12 Hour Nights
543199 ICU Newark NEW JERSEY 12 Hour Nights
526101 ICU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
540128 ICU Walnut Creek CALIFORNIA 12 Hour Days
543405 ICU Rome NEW YORK 12 Hour Nights
540056 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540244 ICU Concord CALIFORNIA 12 Hour Days
540274 ICU Concord CALIFORNIA 12 Hour Days
544574 ICU Cleveland OHIO 12 Hour Day/Night Rotate
544871 ICU Oxford NORTH CAROLINA 12 Hour Nights
548265 ICU Columbus OHIO 12 Hour Nights RN/Registered Nurse
548266 ICU BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
540225 ICU Walnut Creek CALIFORNIA 12 Hour Nights
545311 ICU Colville WASHINGTON 12 Hour Nights
540275 ICU Concord CALIFORNIA 12 Hour Days
547698 ICU Saratoga Springs NEW YORK 12 Hour Nights
540120 ICU Walnut Creek CALIFORNIA 12 Hour Days
540293 ICU Concord CALIFORNIA 12 Hour Nights
540234 ICU Concord CALIFORNIA 12 Hour Nights
544870 ICU Oxford NORTH CAROLINA 12 Hour Nights
545468 ICU Tuba City ARIZONA 12 Hour Day/Night Rotate
542041 ICU Ann Arbor MICHIGAN 12 Hour Nights
540211 ICU Concord CALIFORNIA 12 Hour Nights
539107 ICU San Diego CALIFORNIA 12 Hour Nights
540340 ICU Walnut Creek CALIFORNIA 12 Hour Days
540343 ICU Walnut Creek CALIFORNIA 12 Hour Days
543428 ICU Ogdensburg NEW YORK 12 Hour Nights
540208 ICU Concord CALIFORNIA 12 Hour Days
542177 ICU Boise IDAHO 12 Hour Nights
543200 ICU Newark NEW JERSEY 12 Hour Days
542526 ICU Cleveland OHIO 12 Hour Day/Night Rotate
529965 ICU Boise IDAHO 12 Hour Nights
542176 ICU Boise IDAHO 12 Hour Nights
540329 ICU Walnut Creek CALIFORNIA 12 Hour Days
539176 ICU Albany NEW YORK 12 Hour Days
541258 ICU Concord CALIFORNIA 12 Hour Days
540346 ICU Walnut Creek CALIFORNIA 12 Hour Days
540230 ICU Walnut Creek CALIFORNIA 12 Hour Days
526102 ICU New York NEW YORK 12 Hour Days RN/Registered Nurse
540116 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540242 ICU Concord CALIFORNIA 12 Hour Nights
540105 ICU Concord CALIFORNIA 12 Hour Nights
540238 ICU Walnut Creek CALIFORNIA 12 Hour Days
540281 ICU Concord CALIFORNIA 12 Hour Days
540321 ICU Walnut Creek CALIFORNIA 12 Hour Days
540236 ICU Walnut Creek CALIFORNIA 12 Hour Nights
531244 ICU   CALIFORNIA 12 Hour Days RN/Registered Nurse
540119 ICU Walnut Creek CALIFORNIA 12 Hour Nights
547904 ICU Mesa ARIZONA 12 Hour Nights
537981 ICU Cleveland OHIO 12 Hour Days
532394 ICU Nashua NEW HAMPSHIRE 12 Hour Nights
544060 ICU Pontiac MICHIGAN 12 Hour Nights
535463 ICU Sioux City IOWA 12 Hour Nights
540246 ICU Walnut Creek CALIFORNIA 12 Hour Days
540200 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540258 ICU Concord CALIFORNIA 12 Hour Nights
540086 ICU Walnut Creek CALIFORNIA 12 Hour Nights
544222 ICU Passaic NEW JERSEY 12 Hour Nights
538261 ICU Ogdensburg NEW YORK 12 Hour Nights
540175 ICU Walnut Creek CALIFORNIA 12 Hour Nights
541782 ICU Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
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.2804 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 0,100 in 1.3091 seconds