Listing all records

Displaying records 2201 through 2300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547452 Rehab Abilene TEXAS 12 Hour Day/Night Rotate
543598 Rehab Twin Falls IDAHO 12 Hour Nights
547718 Rehab New York NEW YORK Nights
547774 Rehab PARAMOUNT CALIFORNIA 12 Hour Nights
547773 Rehab PARAMOUNT CALIFORNIA 12 Hour Days
548067 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
548226 CST Peoria ILLINOIS 10 Hour Days CST/Certified Surgical Technician
548225 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
548250 CST Pontiac MICHIGAN 8 Hour Days CST/Certified Surgical Technician
543039 CLS San Diego CALIFORNIA 12 Hour Day/Night Rotate
543750 CLS Reno NEVADA 12 Hour Day/Night Rotate
543753 CLS Victorville CALIFORNIA 8 Hour Days
543769 CLS Lynwood CALIFORNIA 12 Hour Days
543770 CLS Lynwood CALIFORNIA 12 Hour Days
546554 Dialysis Brooklyn NEW YORK 12 Hour Days
536704 Dialysis Dover NEW JERSEY 12 Hour Day/Night Rotate
547583 Dialysis WILLISON NORTH DAKOTA 12 Hour Day/Night Rotate
548058 Dialysis Brooklyn NEW YORK 10 Hour Days RN/Registered Nurse
546236 Dialysis Oregon OHIO 8 Hour Days
544224 Dialysis Dover NEW JERSEY 12 Hour Day/Night Rotate
544229 Dialysis Denville NEW JERSEY 12 Hour Day/Night Rotate
544288 Dialysis Honolulu HAWAII 12 Hour Day/Night Rotate
544861 Dialysis Johnson City TENNESSEE 10 Hour Day/Night Rotate
546552 Dialysis Brooklyn NEW YORK 10 Hour Nights
540013 Monitor Tech Farmington CONNECTICUT 8 Hour Evenings
540016 Monitor Tech Farmington CONNECTICUT 8 Hour Days
545014 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Days
532355 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
548201 Medical Assistant Longview WASHINGTON 8 Hour Days Medical Assistant
538057 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
545943 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
538824 Medical Assistant Madison WISCONSIN 8 Hour Evenings
546337 Medical Assistant Playa Vista CALIFORNIA 8 Hour Days
542103 Medical Assistant Portland OREGON 12 Hour Nights
542104 Medical Assistant Portland OREGON 12 Hour Nights
546753 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
546177 Medical Assistant West Branch MICHIGAN 8 Hour Days
544586 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Day/Night Rotate
547515 Medical Assistant Ruidoso NEW MEXICO 8 Hour Days
546835 Registered Dietician Waimea HAWAII 12 Hour Day/Night Rotate
547384 Registered Dietician Los Angeles CALIFORNIA 8 Hour Days
547838 Postpartum Albany OREGON 12 Hour Day/Night Rotate
540015 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540123 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
548346 Postpartum Fresno CALIFORNIA 12 Hour Days RN/Registered Nurse
548379 Postpartum Fresno CALIFORNIA 12 Hour Nights RN/Registered Nurse
540824 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
542685 Postpartum Kealakekua HAWAII 12 Hour Nights
548117 Postpartum New York NEW YORK 8 Hour Days RN/Registered Nurse
545524 Postpartum Hilo HAWAII 12 Hour Day/Night Rotate
547409 Postpartum ODESSA TEXAS 12 Hour Days
547246 Postpartum Memphis TENNESSEE 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
547120 Neurology Des Moines IOWA 12 Hour Nights
548343 RNFA Peterborough NEW HAMPSHIRE 8 Hour Days RNFA/Registered Nurse First Assist
548296 RNFA Pittsfield MASSACHUSETTS 10 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
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
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
547816 Angiography Grand Forks NORTH DAKOTA Days
546672 Administration Cheyenne WYOMING Days
507007 Administration Scobey MONTANA Varied
534971 Administration Kealakekua HAWAII Days
546294 Administration Marion INDIANA 12 Hour Nights
547746 Ambulatory New York NEW YORK 8 Hour Days
547692 Ambulatory New York NEW YORK 8 Hour Days
547642 Ambulatory Portland OREGON 8 Hour Days
546778 Ambulatory Syracuse NEW YORK 8 Hour Days RN/Registered Nurse
547415 Ambulatory Bronx NEW YORK 8 Hour Days
542601 Ambulatory Cleveland OHIO 8 Hour Days
547747 Ambulatory New York NEW YORK 8 Hour Days
544433 Ambulatory Syracuse NEW YORK 8 Hour Days
546799 Ambulatory Fort Defiance ARIZONA 8 Hour Days
547423 Ambulatory New York NEW YORK 8 Hour Days
545170 Infusion New York NEW YORK 8 Hour Days
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
527935 OR Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
546641 Acute Care New York NEW YORK 8 Hour Days
547938 Acute Care Mt. Vernon WASHINGTON 12 Hour Nights
547971 Acute Care Bronx NEW YORK Days
542972 Acute Care New York NEW YORK Days
543446 Acute Care Kingsport TENNESSEE 12 Hour Days
543935 Acute Care Brooklyn NEW YORK 8 Hour Days
545169 Acute Care Bronx NEW YORK 12 Hour Days
545192 Acute Care Bronx NEW YORK 12 Hour Nights
546619 Acute Care Queens NEW YORK 8 Hour Days
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.3663 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 2200,100 in 1.7522 seconds