Listing all records

Displaying records 2301 through 2400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543693 Med Surg Tele Laconia NEW HAMPSHIRE 12 Hour Day/Night Rotate
546228 Pediatrics Concord NEW HAMPSHIRE 12 Hour Nights
546303 MRI Tech Concord NEW HAMPSHIRE 12 Hour Nights
546304 MRI Tech Concord NEW HAMPSHIRE 12 Hour Nights
546630 Med Surg Tele Laconia NEW HAMPSHIRE Nights
546670 Outpatient Clinic Claremont NEW HAMPSHIRE 8 Hour Days
547050 CNA Claremont NEW HAMPSHIRE 8 Hour Evenings
547462 Long Term Care Claremont NEW HAMPSHIRE 8 Hour Days
547463 CNA Claremont NEW HAMPSHIRE 8 Hour Day/Night Rotate
547464 CNA Claremont NEW HAMPSHIRE 8 Hour Evenings
547465 Long Term Care Claremont NEW HAMPSHIRE 8 Hour Evenings
547667 ICU Laconia NEW HAMPSHIRE Nights
547668 ICU Laconia NEW HAMPSHIRE Nights
547670 Psych Nashua NEW HAMPSHIRE 12 Hour Nights
547866 RRT- Respiratory Exeter NEW HAMPSHIRE 12 Hour Nights
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
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
548152 ICU Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548330 Oncology Newark NEW JERSEY 8 Hour Days RN/Registered Nurse
546287 PT Hamilton NEW JERSEY 8 Hour Days
548252 ICU - Per Diem Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
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
544617 Scrub Tech Rio Rancho NEW MEXICO 10 Hour Days
544701 OB/GYN Socorro NEW MEXICO 8 Hour Day/Night Rotate
544846 OR Espanola NEW MEXICO 10 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.6729 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 asc limit 2300,100 in 1.5528 seconds