Listing all records

Displaying records 101 through 200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548402 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
540235 ICU Concord CALIFORNIA 12 Hour Days
545693 ICU Gainesville FLORIDA 12 Hour Nights
548251 ICU Seattle WASHINGTON 12 Hour Days RN/Registered Nurse
547924 ICU Boise IDAHO 12 Hour Nights
529965 ICU Boise IDAHO 12 Hour Nights
540118 ICU Walnut Creek CALIFORNIA 12 Hour Nights
545678 ICU Gainesville FLORIDA 12 Hour Days
540175 ICU Walnut Creek CALIFORNIA 12 Hour Nights
547812 ICU Woonsocket RHODE ISLAND 12 Hour Nights
548116 ICU Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
547707 ICU North Platte NEBRASKA Nights
540293 ICU Concord CALIFORNIA 12 Hour Nights
538179 ICU San Diego CALIFORNIA 12 Hour Day/Night Rotate
540128 ICU Walnut Creek CALIFORNIA 12 Hour Days
548060 ICU Casper WYOMING 12 Hour Days RN/Registered Nurse
545714 ICU Gainesville FLORIDA 12 Hour Nights
541258 ICU Concord CALIFORNIA 12 Hour Days
543668 ICU Bristol TENNESSEE 12 Hour Days
532394 ICU Nashua NEW HAMPSHIRE 12 Hour Nights
547454 ICU Abilene TEXAS 12 Hour Day/Night Rotate
540105 ICU Concord CALIFORNIA 12 Hour Nights
546566 ICU Brooklyn NEW YORK 12 Hour Days
540056 ICU Walnut Creek CALIFORNIA 12 Hour Nights
547281 ICU Muskegon MICHIGAN 12 Hour Nights
531138 ICU Ogdensburg NEW YORK 12 Hour Nights
540119 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540274 ICU Concord CALIFORNIA 12 Hour Days
548025 ICU Portland OREGON 12 Hour Nights
545731 ICU Gainesville FLORIDA 12 Hour Nights
545911 ICU Gainesville FLORIDA 12 Hour Nights
540203 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540208 ICU Concord CALIFORNIA 12 Hour Days
546567 ICU Brooklyn NEW YORK 12 Hour Days
540117 ICU Walnut Creek CALIFORNIA 12 Hour Nights
545738 ICU Gainesville FLORIDA 12 Hour Nights
545944 ICU Issaquah WASHINGTON 12 Hour Days
540216 ICU Walnut Creek CALIFORNIA 12 Hour Nights
545832 ICU Gainesville FLORIDA 12 Hour Nights
538261 ICU Ogdensburg NEW YORK 12 Hour Nights
526101 ICU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
545737 ICU Gainesville FLORIDA 12 Hour Nights
545894 ICU Gainesville FLORIDA 12 Hour Nights
545793 ICU Gainesville FLORIDA 12 Hour Nights
545839 ICU Gainesville FLORIDA 12 Hour Nights
544222 ICU Passaic NEW JERSEY 12 Hour Nights
546096 ICU Hilo HAWAII 12 Hour Days
540236 ICU Walnut Creek CALIFORNIA 12 Hour Nights
536431 ICU Ann Arbor MICHIGAN 12 Hour Nights
540275 ICU Concord CALIFORNIA 12 Hour Days
540086 ICU Walnut Creek CALIFORNIA 12 Hour Nights
547085 ICU Pendleton OREGON 12 Hour Nights
548262 ICU Arcata CALIFORNIA 12 Hour Days RN/Registered Nurse
541786 ICU The Dalles OREGON 12 Hour Day/Night Rotate
541782 ICU Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547667 ICU Laconia NEW HAMPSHIRE Nights
544574 ICU Cleveland OHIO 12 Hour Day/Night Rotate
544870 ICU Oxford NORTH CAROLINA 12 Hour Nights
546411 ICU Ogdensburg NEW YORK 12 Hour Nights
545934 ICU Gainesville FLORIDA 12 Hour Nights
540116 ICU Walnut Creek CALIFORNIA 12 Hour Nights
545843 ICU Gainesville FLORIDA 12 Hour Days
544060 ICU Pontiac MICHIGAN 12 Hour Nights
542782 ICU Boise IDAHO 12 Hour Nights
546708 ICU Albany NEW YORK 12 Hour Nights
537141 ICU Ogdensburg NEW YORK 12 Hour Nights
546410 ICU Ogdensburg NEW YORK 12 Hour Nights
521322 ICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
547575 ICU Lewiston MAINE 12 Hour Days
540225 ICU Walnut Creek CALIFORNIA 12 Hour Nights
546577 ICU Brooklyn NEW YORK 12 Hour Nights
547593 ICU Newton IOWA 12 Hour Nights
542526 ICU Cleveland OHIO 12 Hour Day/Night Rotate
540281 ICU Concord CALIFORNIA 12 Hour Days
546570 ICU Brooklyn NEW YORK 12 Hour Nights
540282 ICU Walnut Creek CALIFORNIA 12 Hour Nights
547084 ICU Pendleton OREGON 12 Hour Nights
545895 ICU Gainesville FLORIDA 12 Hour Nights
545842 ICU Gainesville FLORIDA 12 Hour Nights
530342 ICU Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
540321 ICU Walnut Creek CALIFORNIA 12 Hour Days
547906 ICU Sun City ARIZONA 12 Hour Nights
547668 ICU Laconia NEW HAMPSHIRE Nights
540276 ICU Concord CALIFORNIA 12 Hour Nights
548002 ICU Gillette WYOMING 12 Hour Day/Night Rotate
545812 ICU Gainesville FLORIDA 12 Hour Nights
540345 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540343 ICU Walnut Creek CALIFORNIA 12 Hour Days
523478 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
540346 ICU Walnut Creek CALIFORNIA 12 Hour Days
545637 ICU Gainesville FLORIDA 12 Hour Nights
545636 ICU Gainesville FLORIDA 12 Hour Nights
545631 ICU Gainesville FLORIDA 12 Hour Nights
547904 ICU Mesa ARIZONA 12 Hour Nights
523775 ICU Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
542177 ICU Boise IDAHO 12 Hour Nights
545902 ICU Gainesville FLORIDA 12 Hour Days
547260 ICU Portland OREGON 12 Hour Nights
547282 ICU Muskegon MICHIGAN 12 Hour Nights
545687 ICU Gainesville FLORIDA 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.0427 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 100,100 in 1.0161 seconds