Listing all records

Displaying records 1501 through 1600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548067 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
548250 CST Pontiac MICHIGAN 8 Hour Days CST/Certified Surgical Technician
548225 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
548226 CST Peoria ILLINOIS 10 Hour Days CST/Certified Surgical Technician
547446 Rehab Seguin TEXAS 12 Hour Days
541886 Rehab Chesterfield MONTANA 12 Hour Days
547452 Rehab Abilene TEXAS 12 Hour Day/Night Rotate
535387 Rehab Clive IOWA 12 Hour Nights
535638 Rehab Cape Girardeau MISSOURI Nights
547773 Rehab PARAMOUNT CALIFORNIA 12 Hour Days
546285 Rehab Windsor VERMONT 12 Hour Nights
547774 Rehab PARAMOUNT CALIFORNIA 12 Hour Nights
547718 Rehab New York NEW YORK Nights
547656 Rehab Omaha NEBRASKA 12 Hour Days
546999 Rehab Sioux City IOWA 12 Hour Nights
543598 Rehab Twin Falls IDAHO 12 Hour Nights
465120 Long Term Care Conrad MONTANA 8 Hour Evenings
487151 Long Term Care Conrad MONTANA 12 Hour Day/Night Rotate
490405 Long Term Care Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
492265 Long Term Care Scottsbluff NEBRASKA Nights
547680 Long Term Care Brantwood NORTH CAROLINA 12 Hour Nights
546233 Long Term Care Watertown NEW YORK 8 Hour Evenings
547462 Long Term Care Claremont NEW HAMPSHIRE 8 Hour Days
542655 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
545988 Long Term Care King City CALIFORNIA 12 Hour Days
547027 Long Term Care Claremont NEW HAMPSHIRE 12 Hour Nights
545985 Long Term Care Oneonta NEW YORK 8 Hour Nights
531433 Long Term Care Marion VIRGINIA Nights
532051 Long Term Care Nome ALASKA 12 Hour Day/Night Rotate
533310 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
533322 Long Term Care Lewiston MAINE 12 Hour Nights
546788 Long Term Care Westminster COLORADO 12 Hour Nights
536159 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
547819 Long Term Care Lowville NEW YORK 12 Hour Days
547768 Long Term Care New Lisbon WISCONSIN 8 Hour Day/Night Rotate
538064 Long Term Care Alturas CALIFORNIA 12 Hour Day/Night Rotate
545989 Long Term Care King City CALIFORNIA 12 Hour Nights
538527 Long Term Care Rochdale MASSACHUSETTS 12 Hour Days
538553 Long Term Care Lewiston MAINE 12 Hour Days
538581 Long Term Care Canton NEW YORK 12 Hour Varied
539660 Long Term Care Greeneville TENNESSEE 12 Hour Nights
539703 Long Term Care Kingsport TENNESSEE 12 Hour Nights
547424 Long Term Care GRAND MARAIS MINNESOTA 8 Hour Nights
544149 Long Term Care Moscow IDAHO 12 Hour Nights
545098 Long Term Care Portland OREGON 12 Hour Days
546205 Long Term Care Watertown NEW YORK 12 Hour Day/Night Rotate
540802 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
541096 Long Term Care New Lisbon WISCONSIN 8 Hour Days
547465 Long Term Care Claremont NEW HAMPSHIRE 8 Hour Evenings
542501 Long Term Care Sitka ALASKA 8 Hour Evenings
547818 Long Term Care Lowville NEW YORK 12 Hour Days
543032 Long Term Care Lowville NEW YORK 12 Hour Nights
548014 Long Term Care Kane PENNSYLVANIA 12 Hour Nights
518165 Endoscopy IOWA CITY IOWA Days
546793 Endoscopy Mt. Vernon WASHINGTON 10 Hour Day/Night Rotate
546860 Endoscopy Jefferson City MISSOURI 8 Hour Days
547873 Endoscopy Columbia MISSOURI 8 Hour Varied
545252 GI Lab Mason City IOWA 8 Hour Days
543784 GI Lab Woonsocket RHODE ISLAND 8 Hour Days
548339 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
544535 Psych Fort Defiance ARIZONA 12 Hour Varied
541847 Psych Peoria ILLINOIS 8 Hour Days RN/Registered Nurse
544628 Psych Cleveland OHIO 12 Hour Nights
548069 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
546940 Psych Kealakekua HAWAII 12 Hour Day/Night Rotate
547961 Psych Brattleboro VERMONT 12 Hour Nights
535905 Psych Concord CALIFORNIA 8 Hour Nights
534694 Psych Woodsville NEW HAMPSHIRE 12 Hour Day/Night Rotate
543891 Psych National City CALIFORNIA 12 Hour Days
537741 Psych New York NEW YORK 12 Hour Days
548354 Psych National City CALIFORNIA 12 Hour Nights RN/Registered Nurse
538936 Psych Boise IDAHO 12 Hour Nights
548223 Psych Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548236 Psych New York NEW YORK 12 Hour Nights RN/Registered Nurse
548304 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548323 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
540051 Psych Concord CALIFORNIA 8 Hour Evenings
540052 Psych Concord CALIFORNIA 8 Hour Evenings
540085 Psych Concord CALIFORNIA 8 Hour Evenings
540177 Psych Concord CALIFORNIA 8 Hour Evenings
546335 Psych Wailuku HAWAII 12 Hour Nights
540232 Psych Concord CALIFORNIA 8 Hour Nights
543890 Psych National City CALIFORNIA 12 Hour Nights
548369 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
541039 Psych Concord CALIFORNIA 8 Hour Nights
548170 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548174 Psych Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548184 Psych Salem MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
548190 Psych Lewiston MAINE 12 Hour Nights RN/Registered Nurse
547670 Psych Nashua NEW HAMPSHIRE 12 Hour Nights
548234 Psych Centreville ILLINOIS 12 Hour Nights RN/Registered Nurse
548219 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548214 Psych Peoria ILLINOIS 12 Hour Evenings RN/Registered Nurse
543201 Psych Grand Rapids MICHIGAN 8 Hour Evenings RN/Registered Nurse
548063 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548157 Psych Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
547088 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
548004 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
546784 Pediatrics Gardner MASSACHUSETTS 12 Hour Nights
540168 Pediatrics Walnut Creek CALIFORNIA 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.5261 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 desc limit 1500,100 in 1.3823 seconds