Listing all records

Displaying records 2701 through 2800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546845 Med Surg Peoria ILLINOIS 12 Hour Nights
546856 Certified Surgical Tech Berlin MARYLAND 10 Hour Days
546858 CVOR Annapolis MARYLAND 12 Hour Days
546859 Telemetry Everett WASHINGTON 12 Hour Nights
546860 Endoscopy Jefferson City MISSOURI 8 Hour Days
546862 OT Syracuse NEW YORK 8 Hour Days
546866 Surgical Tech Mammoth Lakes CALIFORNIA 12 Hour Day/Night Rotate
546867 PTA Wilton CONNECTICUT Varied
546868 ER MERCED CALIFORNIA 12 Hour Days
546869 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
546870 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
546874 Med Surg Tele Greensboro NORTH CAROLINA 12 Hour Nights
546875 Telemetry PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
546877 MLT Pittsfield MASSACHUSETTS 8 Hour Days
546879 Med Surg Tele Prescott ARIZONA 12 Hour Days RN/Registered Nurse
546880 Med Surg Show Low ARIZONA 12 Hour Nights RN/Registered Nurse
546881 ER MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
546882 Step Down South Charleston WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
546884 Respiratory Therapist Sitka ALASKA 10 Hour Varied
546886 PT Globe ARIZONA Days
546897 Cath Lab New Bern NORTH CAROLINA 8 Hour Days
546898 Telemetry Cleveland OHIO 12 Hour Nights
546899 Telemetry Spokane WASHINGTON 12 Hour Nights
546902 Telemetry Cleveland OHIO 12 Hour Nights
546903 Med Surg Tele Canton OHIO 12 Hour Nights
546904 Telemetry Cleveland OHIO 12 Hour Nights
546907 Telemetry Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
546908 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
546912 ER Goldendale WASHINGTON 12 Hour Days
546913 ER Des Moines IOWA 12 Hour Days
546915 Med Surg Hilo HAWAII 12 Hour Nights
546918 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
546919 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546920 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546923 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
546924 Cath Lab Detroit MICHIGAN 8 Hour Days
546925 ER East Norriton PENNSYLVANIA 12 Hour Nights
546926 MICU San Dimas CALIFORNIA 12 Hour Nights
546927 ER Kaunakakai HAWAII 12 Hour Day/Night Rotate
546928 Med Surg Tele Mt. Vernon WASHINGTON 12 Hour Nights
546929 Interventional Radiology Tech Detroit MICHIGAN 10 Hour Days
546931 SLP Visalia CALIFORNIA 8 Hour Days
546934 RAD Tech Dubuque IOWA 12 Hour Nights
546937 ER Albany NEW YORK 12 Hour Nights
546938 ER Albany NEW YORK 12 Hour Nights
546939 ER Albany NEW YORK 12 Hour Nights
546940 Psych Kealakekua HAWAII 12 Hour Day/Night Rotate
546942 Perfusionist Boston MASSACHUSETTS 10 Hour Days
546943 Med Surg Tele Cleveland OHIO 12 Hour Nights
546946 CT Tech Brattleboro VERMONT 12 Hour Nights
546948 Echo Lufkin TEXAS 8 Hour Day/Night Rotate
546949 RAD Tech Hot Springs ARKANSAS 8 Hour Days
546951 Surgical Tech Long Beach CALIFORNIA 12 Hour Nights
546958 Med Surg Tele Princeton WEST VIRGINIA 12 Hour Nights
546966 CT Tech Silverdale WASHINGTON 10 Hour Nights
546971 Radiology PHOENIX ARIZONA 12 Hour Nights
546973 Interventional Radiology Tech York PENNSYLVANIA 8 Hour Days
546976 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
546977 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
546984 CVICU Albany NEW YORK 12 Hour Nights
546985 Med Surg Tele Syracuse NEW YORK 12 Hour Days
546986 LPN/LVN SAN ANDREAS CALIFORNIA 8 Hour Days
546987 Echo Osage Beach MISSOURI 8 Hour Days
546988 Radiation Therapy NORTHRIDGE CALIFORNIA 8 Hour Days
546992 Certified Surgical Tech Concord MASSACHUSETTS 8 Hour Days
546993 Med Surg Troy NEW YORK 12 Hour Nights
546994 Med Surg Troy NEW YORK 12 Hour Nights
546995 OR Athens GEORGIA 8 Hour Days
546996 Mammo Tech Morgantown WEST VIRGINIA 8 Hour Days
546999 Rehab Sioux City IOWA 12 Hour Nights
547000 Med Surg Dubuque IOWA 12 Hour Days
547002 Med Surg Dubuque IOWA 12 Hour Days
547006 CVOR Charlottesville VIRGINIA 10 Hour Days
547007 CT Tech Maryville ILLINOIS 12 Hour Nights
547008 Oncology Everett WASHINGTON 12 Hour Nights
547009 Wound Care Anchorage ALASKA 8 Hour Days
547013 Med Surg Tele Cleveland OHIO 12 Hour Days
547014 Med Surg Tele Cleveland OHIO 12 Hour Days
547015 Med Surg Tele Cleveland OHIO 12 Hour Days
547016 Med Surg Tele Cleveland OHIO 12 Hour Days
547021 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
547022 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
547023 Med Surg Tele Rome NEW YORK 12 Hour Nights
547024 Med Surg Tele Rome NEW YORK 12 Hour Nights
547026 ICU Santa Fe NEW MEXICO 12 Hour Day/Night Rotate
547027 Long Term Care Claremont NEW HAMPSHIRE 12 Hour Nights
547031 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547032 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547033 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547034 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547035 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547036 Surgical Tech Falls Church VIRGINIA 8 Hour Day/Night Rotate
547039 Supervisor Oneonta NEW YORK 8 Hour Nights
547043 Med Surg Tele Beachwood OHIO 12 Hour Nights
547045 Cath Lab New Bern NORTH CAROLINA 10 Hour Days
547046 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
547050 CNA Claremont NEW HAMPSHIRE 8 Hour Evenings
547051 RAD Tech Phoenix ARIZONA 12 Hour Days
547056 PT Sacramento CALIFORNIA 8 Hour Days
547057 OT Sacramento CALIFORNIA 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.6528 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.id asc limit 2700,100 in 1.2871 seconds