Listing all records

Displaying records 1301 through 1400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543296 OR Albuquerque NEW MEXICO 12 Hour Days
543297 OR Albuquerque NEW MEXICO Nights
543725 OR Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
543807 PACU Albuquerque NEW MEXICO 12 Hour Nights
547945 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
548093 ER Albuquerque NEW MEXICO 12 Hour Nights RN/Registered Nurse
548096 Med Surg Espanola NEW MEXICO 12 Hour Nights RN/Registered Nurse
548138 ER Truth or Consequences NEW MEXICO 12 Hour Days RN/Registered Nurse
548247 ER Artesia NEW MEXICO 12 Hour Nights RN/Registered Nurse
541860 PT Lovington NEW MEXICO 8 Hour Days
527987 Case Manager Albuquerque NEW MEXICO 10 Hour Days
545126 Med Surg Espanola NEW MEXICO Nights
499331 SLP Little Egg Harbor Township NEW JERSEY Days
501006 PTA Freehold NEW JERSEY Days
509587 PT Freehold NEW JERSEY Days
541792 ER Newark NEW JERSEY 12 Hour Day/Night Rotate
523531 PTA Oakland NEW JERSEY Days
524151 PTA Ramsey NEW JERSEY Days
529209 Surgical Tech Passaic NEW JERSEY 12 Hour Days
529430 PTA New Providence NEW JERSEY Days
531496 CCU Newark NEW JERSEY 12 Hour Days
529983 CCU Newark NEW JERSEY 12 Hour Nights
542664 ICU - Per Diem Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
531219 PT Williamstown NEW JERSEY Days
531489 PT Ramsey NEW JERSEY Days
534093 SLP Freehold NEW JERSEY Days
534504 PT Raritan NEW JERSEY Days
535674 Cath Lab Passaic NEW JERSEY 8 Hour Days
536704 Dialysis Dover NEW JERSEY 12 Hour Day/Night Rotate
538043 Respiratory Therapist Denville NEW JERSEY 12 Hour Nights
538044 Respiratory Therapist Denville NEW JERSEY 12 Hour Nights
538045 Respiratory Therapist Denville NEW JERSEY 12 Hour Nights
538547 Med Surg Dover NEW JERSEY 12 Hour Days
538549 Med Surg Dover NEW JERSEY 12 Hour Nights
538550 Med Surg Dover NEW JERSEY 12 Hour Nights
538551 Med Surg Dover NEW JERSEY 12 Hour Nights
539384 Scrub Tech Newark NEW JERSEY 12 Hour Days
540812 CT Tech Denville NEW JERSEY 8 Hour Days
540813 CT Tech Denville NEW JERSEY 12 Hour Nights
542847 SLP Oakland NEW JERSEY Days
542462 SLP Williamstown NEW JERSEY Days
543196 ER Newark NEW JERSEY 12 Hour Days
543095 Cath Lab Newark NEW JERSEY 12 Hour Nights
543096 Oncology Newark NEW JERSEY 8 Hour Days
543097 Respiratory Therapist Newark NEW JERSEY 12 Hour Nights
543199 ICU Newark NEW JERSEY 12 Hour Nights
543200 ICU Newark NEW JERSEY 12 Hour Days
543312 RAD Tech Denville NEW JERSEY Nights
543974 ER Newark NEW JERSEY 12 Hour Nights
544218 CVOR Newark NEW JERSEY 12 Hour Days
544219 Oncology Newark NEW JERSEY 12 Hour Days
544220 MICU Newark NEW JERSEY 8 Hour Nights
544221 OR Newark NEW JERSEY 12 Hour Days
544222 ICU Passaic NEW JERSEY 12 Hour Nights
544223 Surgical Tech Passaic NEW JERSEY 12 Hour Days
544224 Dialysis Dover NEW JERSEY 12 Hour Day/Night Rotate
544225 Med Surg Dover NEW JERSEY 12 Hour Nights
544226 MLT Denville NEW JERSEY 12 Hour Day/Night Rotate
544227 Nuclear Med Technician Denville NEW JERSEY 8 Hour Days
544228 CT Tech Denville NEW JERSEY 12 Hour Day/Night Rotate
544229 Dialysis Denville NEW JERSEY 12 Hour Day/Night Rotate
544230 ER Denville NEW JERSEY 12 Hour Nights
544231 ER Denville NEW JERSEY 12 Hour Days
544232 ER Denville NEW JERSEY 12 Hour Day/Night Rotate
544233 CCU Denville NEW JERSEY 12 Hour Nights
544234 Surgical Tech Denville NEW JERSEY 12 Hour Days
544235 Sterile Processing Tech Denville NEW JERSEY 8 Hour Days
544552 ER Newark NEW JERSEY 12 Hour Nights
544553 Cath Lab Passaic NEW JERSEY 8 Hour Days
544894 Respiratory Therapist Newark NEW JERSEY 12 Hour Nights
546287 PT Hamilton NEW JERSEY 8 Hour Days
548252 ICU - Per Diem Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548152 ICU Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548330 Oncology Newark NEW JERSEY 8 Hour Days RN/Registered Nurse
548013 Outpatient Clinic Berlin NEW HAMPSHIRE 8 Hour Days
548067 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
548107 Case Manager Littleton NEW HAMPSHIRE 8 Hour Days RN/Registered Nurse
548116 ICU Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548131 Respiratory Therapist Keene NEW HAMPSHIRE 12 Hour Nights Respiratory Therapist
548132 ER Peterborough NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548159 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548191 ER New London NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548211 RRT- Respiratory Claremont NEW HAMPSHIRE 12 Hour Nights Respiratory Therapist
548225 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
548227 First Assist Peterborough NEW HAMPSHIRE 8 Hour Days RN/Registered Nurse
548343 RNFA Peterborough NEW HAMPSHIRE 8 Hour Days RNFA/Registered Nurse First Assist
547027 Long Term Care Claremont NEW HAMPSHIRE 12 Hour Nights
544411 CT Tech New London NEW HAMPSHIRE 12 Hour Nights
544586 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Day/Night Rotate
544775 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
545035 PCU Concord NEW HAMPSHIRE 12 Hour Nights
545154 RAD Tech Lebanon NEW HAMPSHIRE 12 Hour Nights
545343 PCU Concord NEW HAMPSHIRE 12 Hour Nights
545390 CT Tech Berlin NEW HAMPSHIRE 12 Hour Day/Night Rotate
496817 Surgical Tech Peterborough NEW HAMPSHIRE 8 Hour Days
548240 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548241 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548242 Med Surg Peterborough NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548248 ER Keene NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548239 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights 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.4932 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 y.name desc limit 1300,100 in 1.734 seconds