Listing all records

Displaying records 3301 through 3400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547966 LPN/LVN Spanaway WASHINGTON Days
547967 ER Madison WISCONSIN 12 Hour Day/Night Rotate
547969 Surgical Tech Auburn NEW YORK 10 Hour Days
547970 Pediatric ER Bronx NEW YORK Nights
547971 Acute Care Bronx NEW YORK Days
547972 Cardiac Telemetry Albany NEW YORK 12 Hour Nights
547973 Med Surg Oneonta NEW YORK 12 Hour Days
547974 CT Tech TOWNSHEND VERMONT Varied
547975 ER Goldendale WASHINGTON 12 Hour Nights
547977 ICU Memphis TENNESSEE 12 Hour Nights
547978 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
547979 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
547980 Med Surg Tele Lewiston MAINE 12 Hour Nights
547981 Med Surg Tele Lewiston MAINE 12 Hour Nights
547982 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
547983 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
547984 Home Health Portland OREGON 8 Hour Days
547985 Home Health Portland OREGON 8 Hour Days
547988 Intermediate Care Rumford MAINE 12 Hour Days
547989 Intermediate Care Rumford MAINE 12 Hour Days
547990 Cardiology Torrance CALIFORNIA 12 Hour Days
547991 Cardiology Torrance CALIFORNIA 12 Hour Days
547992 Case Manager Torrance CALIFORNIA 8 Hour Days
547993 LTAC Torrance CALIFORNIA 8 Hour Evenings
547994 Med Surg Tele Warrensville Heights OHIO 12 Hour Days
547995 Med Surg Tele Warrensville Heights OHIO 12 Hour Days
547996 Med Surg Perryville MISSOURI 12 Hour Days
547997 Med Surg Perryville MISSOURI 12 Hour Days
547998 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
547999 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
548002 ICU Gillette WYOMING 12 Hour Day/Night Rotate
548003 ER Pittsfield MASSACHUSETTS 12 Hour Nights
548004 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
548005 Med Surg Tele Des Moines IOWA 12 Hour Nights
548006 Med Surg Tele Des Moines IOWA 12 Hour Days
548007 Med Surg Tele Des Moines IOWA 12 Hour Days
548008 Respiratory Therapist Plains MONTANA Days
548009 RAD Tech Honolulu HAWAII 8 Hour Day/Night Rotate
548010 CT Tech Fort Bragg CALIFORNIA 12 Hour Day/Night Rotate
548011 SLP Crescent City CALIFORNIA 8 Hour Days
548012 PT Crescent City CALIFORNIA 8 Hour Days
548013 Outpatient Clinic Berlin NEW HAMPSHIRE 8 Hour Days
548014 Long Term Care Kane PENNSYLVANIA 12 Hour Nights
548015 CNA San Francisco CALIFORNIA 8 Hour Days
548016 CNA San Francisco CALIFORNIA 8 Hour Days
548017 PACU Chico CALIFORNIA 10 Hour Days
548018 MLT Aberdeen WASHINGTON 10 Hour Nights
548019 CNA Corvallis OREGON 12 Hour Day/Night Rotate
548020 MRI Tech Glenwood Springs COLORADO 12 Hour Varied
548021 PCU Abilene TEXAS 12 Hour Nights
548022 OT Rehab Rushville ILLINOIS Varied
548023 LPN/LVN Mullins SOUTH CAROLINA 12 Hour Nights
548024 Telemetry Cleveland OHIO 12 Hour Nights
548025 ICU Portland OREGON 12 Hour Nights
548026 PT Escondido CALIFORNIA 8 Hour Days
548027 PTA Escondido CALIFORNIA 8 Hour Days
548028 CT Tech Pagosa Springs COLORADO 12 Hour Day/Night Rotate
548029 PT Goldendale WASHINGTON Days
548030 Sterile Processing Technician Wenatchee WASHINGTON 12 Hour Day/Night Rotate
548031 Cath Lab Berwyn ILLINOIS 8 Hour Days
548032 CT Tech Columbus OHIO 10 Hour Nights
548033 Med Surg Tele Des Moines IOWA 12 Hour Days
548034 ICU Newton IOWA 12 Hour Nights
548035 Echo Pagosa Springs COLORADO 8 Hour Days
548036 MLT New Bern NORTH CAROLINA 10 Hour Nights
548037 OR Laurinburg NORTH CAROLINA 8 Hour Days
548038 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Nights
548039 OR Petersburg WEST VIRGINIA 8 Hour Days RN/Registered Nurse
548040 PCU Lowell MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
548041 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
548042 ER Pendleton OREGON 12 Hour Varied RN/Registered Nurse
548043 OR Bakersfield CALIFORNIA 8 Hour Days RN/Registered Nurse
548044 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548045 OR NORTHRIDGE CALIFORNIA 12 Hour Nights RN/Registered Nurse
548046 OR BAKERSFIELD CALIFORNIA 8 Hour Days RN/Registered Nurse
548047 Respiratory Therapist Schenectady NEW YORK 12 Hour Nights Respiratory Therapist
548048 LPN/LVN Rancho Cordova CALIFORNIA 12 Hour Nights LVN
548049 RAD Tech Centralia WASHINGTON 8 Hour Days Tech/Technologist
548050 Respiratory Therapist Stony Brook NEW YORK 12 Hour Nights Respiratory Therapist
548051 CNA - Per Diem Los Angeles CALIFORNIA 12 Hour Days CNA/Certified Nursing Assistant
548052 Med Surg Pontiac MICHIGAN 12 Hour Nights RN/Registered Nurse
548053 NICU New York NEW YORK 12 Hour Days RN/Registered Nurse
548054 CVOR STOCKTON CALIFORNIA 12 Hour Days RN/Registered Nurse
548055 ER Glens Falls NEW YORK 12 Hour Nights RN/Registered Nurse
548056 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548057 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
548058 Dialysis Brooklyn NEW YORK 10 Hour Days RN/Registered Nurse
548059 Surgical Tech SAN FRANCISCO CALIFORNIA 8 Hour Days Tech/Technologist
548060 ICU Casper WYOMING 12 Hour Days RN/Registered Nurse
548061 PACU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
548062 L&D Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548063 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548064 Respiratory Therapist Falls Church VIRGINIA 12 Hour Nights Respiratory Therapist
548065 Step Down SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
548066 ICU Bellefontaine OHIO 12 Hour Nights RN/Registered Nurse
548067 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
548069 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548072 ER Lansing MICHIGAN 12 Hour Days RN/Registered Nurse
548073 PCU Palm Springs CALIFORNIA 12 Hour Days RN/Registered Nurse
548074 ICU - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
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.5674 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 3300,100 in 1.2246 seconds