Listing all records

Displaying records 1401 through 1500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548098 Med Surg Tele Chandler ARIZONA 12 Hour Day/Night Rotate RN/Registered Nurse
546739 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
546170 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547941 Med Surg Tele Vernon Rockville CONNECTICUT 12 Hour Nights
547396 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
543378 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
547440 Electrophysiology Tech Birmingham ALABAMA 10 Hour Days
547685 Electrophysiology Tech Monterey CALIFORNIA 8 Hour Days
547442 Electrophysiology Tech San Antonio TEXAS 10 Hour Days
543446 Acute Care Kingsport TENNESSEE 12 Hour Days
547971 Acute Care Bronx NEW YORK Days
545169 Acute Care Bronx NEW YORK 12 Hour Days
546641 Acute Care New York NEW YORK 8 Hour Days
545192 Acute Care Bronx NEW YORK 12 Hour Nights
542972 Acute Care New York NEW YORK Days
547938 Acute Care Mt. Vernon WASHINGTON 12 Hour Nights
543935 Acute Care Brooklyn NEW YORK 8 Hour Days
546619 Acute Care Queens NEW YORK 8 Hour Days
527935 OR Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
540046 Peri-Operative Walnut Creek CALIFORNIA 10 Hour Days
540158 Peri-Operative Concord CALIFORNIA 8 Hour Days
540189 Peri-Operative Concord CALIFORNIA 8 Hour Days
540224 Peri-Operative Walnut Creek CALIFORNIA 10 Hour Days
545170 Infusion New York NEW YORK 8 Hour Days
547746 Ambulatory New York NEW YORK 8 Hour Days
547692 Ambulatory New York NEW YORK 8 Hour Days
547423 Ambulatory New York NEW YORK 8 Hour Days
547415 Ambulatory Bronx NEW YORK 8 Hour Days
547747 Ambulatory New York NEW YORK 8 Hour Days
546778 Ambulatory Syracuse NEW YORK 8 Hour Days RN/Registered Nurse
544433 Ambulatory Syracuse NEW YORK 8 Hour Days
546799 Ambulatory Fort Defiance ARIZONA 8 Hour Days
542601 Ambulatory Cleveland OHIO 8 Hour Days
547642 Ambulatory Portland OREGON 8 Hour Days
507007 Administration Scobey MONTANA Varied
546294 Administration Marion INDIANA 12 Hour Nights
534971 Administration Kealakekua HAWAII Days
546672 Administration Cheyenne WYOMING Days
547816 Angiography Grand Forks NORTH DAKOTA Days
533242 Angiography San Diego CALIFORNIA 8 Hour Days
539718 Angiography Hilo HAWAII 12 Hour Day/Night Rotate
542171 Angiography Hilo HAWAII 12 Hour Day/Night Rotate
531765 L&D Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
543861 L&D Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
546361 Laboratory Manhasset NEW YORK 8 Hour Days
546362 Laboratory Manhasset NEW YORK 8 Hour Days
538497 Laboratory New York NEW YORK 8 Hour Evenings
538686 Laboratory New York NEW YORK 8 Hour Days
539559 Laboratory New York NEW YORK 8 Hour Evenings
539742 Laboratory Falls Church VIRGINIA 8 Hour Evenings
543709 Laboratory Orange CALIFORNIA 8 Hour Days
548343 RNFA Peterborough NEW HAMPSHIRE 8 Hour Days RNFA/Registered Nurse First Assist
548296 RNFA Pittsfield MASSACHUSETTS 10 Hour Days RN/Registered Nurse
547120 Neurology Des Moines IOWA 12 Hour Nights
537423 Neurology Des Moines IOWA 12 Hour Nights
537424 Neurology Des Moines IOWA 12 Hour Nights
542466 Neurology Des Moines IOWA 12 Hour Nights
547838 Postpartum Albany OREGON 12 Hour Day/Night Rotate
547246 Postpartum Memphis TENNESSEE 12 Hour Nights
547409 Postpartum ODESSA TEXAS 12 Hour Days
548346 Postpartum Fresno CALIFORNIA 12 Hour Days RN/Registered Nurse
548379 Postpartum Fresno CALIFORNIA 12 Hour Nights RN/Registered Nurse
540015 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
548117 Postpartum New York NEW YORK 8 Hour Days RN/Registered Nurse
540123 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
545524 Postpartum Hilo HAWAII 12 Hour Day/Night Rotate
540824 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
542685 Postpartum Kealakekua HAWAII 12 Hour Nights
546835 Registered Dietician Waimea HAWAII 12 Hour Day/Night Rotate
547384 Registered Dietician Los Angeles CALIFORNIA 8 Hour Days
545014 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Days
546337 Medical Assistant Playa Vista CALIFORNIA 8 Hour Days
545943 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
546177 Medical Assistant West Branch MICHIGAN 8 Hour Days
532355 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
538057 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
548201 Medical Assistant Longview WASHINGTON 8 Hour Days Medical Assistant
538824 Medical Assistant Madison WISCONSIN 8 Hour Evenings
547515 Medical Assistant Ruidoso NEW MEXICO 8 Hour Days
546753 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
544586 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Day/Night Rotate
542103 Medical Assistant Portland OREGON 12 Hour Nights
542104 Medical Assistant Portland OREGON 12 Hour Nights
540013 Monitor Tech Farmington CONNECTICUT 8 Hour Evenings
540016 Monitor Tech Farmington CONNECTICUT 8 Hour Days
544861 Dialysis Johnson City TENNESSEE 10 Hour Day/Night Rotate
546236 Dialysis Oregon OHIO 8 Hour Days
536704 Dialysis Dover NEW JERSEY 12 Hour Day/Night Rotate
544288 Dialysis Honolulu HAWAII 12 Hour Day/Night Rotate
548058 Dialysis Brooklyn NEW YORK 10 Hour Days RN/Registered Nurse
546552 Dialysis Brooklyn NEW YORK 10 Hour Nights
546554 Dialysis Brooklyn NEW YORK 12 Hour Days
547583 Dialysis WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
544224 Dialysis Dover NEW JERSEY 12 Hour Day/Night Rotate
544229 Dialysis Denville NEW JERSEY 12 Hour Day/Night Rotate
543770 CLS Lynwood CALIFORNIA 12 Hour Days
543769 CLS Lynwood CALIFORNIA 12 Hour Days
543753 CLS Victorville CALIFORNIA 8 Hour Days
543750 CLS Reno NEVADA 12 Hour Day/Night Rotate
543039 CLS San Diego CALIFORNIA 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.5295 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 1400,100 in 1.4917 seconds