Listing all records

Displaying records 1201 through 1300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
525235 CT Tech Oceanside CALIFORNIA 10 Hour Days
527624 Scrub Tech Oceanside CALIFORNIA 10 Hour Days
527625 Sterile Processing Technician Oceanside CALIFORNIA 10 Hour Nights
527789 RAD Tech Oceanside CALIFORNIA 8 Hour Days
528610 OR Oceanside CALIFORNIA 10 Hour Days
530433 Surgical Tech Oceanside CALIFORNIA Varied
531037 Nuclear Medicine Oceanside CALIFORNIA 8 Hour Days
534108 Echo Oceanside CALIFORNIA 10 Hour Days
534109 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
544908 ER Oceanside CALIFORNIA 12 Hour Nights
544909 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
544910 RAD Tech Oceanside CALIFORNIA 8 Hour Days
542847 SLP Oakland NEW JERSEY Days
523531 PTA Oakland NEW JERSEY Days
523668 PT Oakland CALIFORNIA Days
496231 COTA Oakhurst CALIFORNIA Days
542780 SLP Oakhurst CALIFORNIA Days
542424 PT Norwalk IOWA Days
546067 ICU Norton VIRGINIA 12 Hour Nights
547290 ER Norton VIRGINIA 12 Hour Days
539689 Med Surg Norton VIRGINIA 12 Hour Nights
535640 PT NORTHRIDGE CALIFORNIA 8 Hour Days
536753 PT NORTHRIDGE CALIFORNIA 8 Hour Days
548045 OR NORTHRIDGE CALIFORNIA 12 Hour Nights RN/Registered Nurse
546988 Radiation Therapy NORTHRIDGE CALIFORNIA 8 Hour Days
527487 PTA North Providence RHODE ISLAND Days
547707 ICU North Platte NEBRASKA Nights
474328 PT North Manchester INDIANA Days
527231 PT North Kingstown RHODE ISLAND Days
547786 CVOR North Kansas City MISSOURI 8 Hour Days
548382 ER North Adams MASSACHUSETTS 12 Hour Days RN/Registered Nurse
547697 PT Norristown PENNSYLVANIA Days
547513 Surgical Tech CVOR Norman OKLAHOMA 8 Hour Days
544091 Med Surg Norman OKLAHOMA 12 Hour Nights
548194 OR Norman OKLAHOMA 12 Hour Days RN/Registered Nurse
503607 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
515962 Pediatrics Nome ALASKA 12 Hour Day/Night Rotate
532051 Long Term Care Nome ALASKA 12 Hour Day/Night Rotate
544884 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
546346 PT Nogales ARIZONA 8 Hour Days
547593 ICU Newton IOWA 12 Hour Nights
541798 L&D Newton IOWA 12 Hour Nights
548034 ICU Newton IOWA 12 Hour Nights
545066 PT Newport OREGON 8 Hour Days
543245 Clinic Newport OREGON 8 Hour Days
518534 COTA NEWMAN CALIFORNIA Days
520208 PT NEWMAN CALIFORNIA Days
542803 Med Surg Newberg OREGON 12 Hour Nights
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
543974 ER Newark NEW JERSEY 12 Hour Nights
541792 ER Newark NEW JERSEY 12 Hour Day/Night Rotate
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
539384 Scrub Tech Newark NEW JERSEY 12 Hour Days
548152 ICU Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548330 Oncology Newark NEW JERSEY 8 Hour Days RN/Registered Nurse
548252 ICU - Per Diem Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
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
544552 ER Newark NEW JERSEY 12 Hour Nights
544894 Respiratory Therapist Newark NEW JERSEY 12 Hour Nights
544904 RAD Tech New York NEW YORK 8 Hour Days
545170 Infusion New York NEW YORK 8 Hour Days
548053 NICU New York NEW YORK 12 Hour Days RN/Registered Nurse
548063 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548103 L&D New York NEW YORK 12 Hour Days RN/Registered Nurse
548117 Postpartum New York NEW YORK 8 Hour Days RN/Registered Nurse
548130 ER New York NEW YORK 12 Hour Nights RN/Registered Nurse
548143 House Supervisor New York NEW YORK 8 Hour Days RN/Registered Nurse
548144 House Supervisor New York NEW YORK 8 Hour Days RN/Registered Nurse
548170 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548217 Telemetry New York NEW YORK 12 Hour Days RN/Registered Nurse
548219 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548236 Psych New York NEW YORK 12 Hour Nights RN/Registered Nurse
548303 OR New York NEW YORK 10 Hour Days RN/Registered Nurse
548323 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548345 Med Surg New York NEW YORK 12 Hour Nights RN/Registered Nurse
548369 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
540482 OR New York NEW YORK 12 Hour Nights
540498 Pediatric ER New York NEW YORK 12 Hour Nights
540501 Supervisor New York NEW YORK 8 Hour Days
541984 Med Surg New York NEW YORK Days
542390 Pediatric ER New York NEW YORK 12 Hour Nights
542972 Acute Care New York NEW YORK Days
543178 Neuro Intensive Care New York NEW YORK Days
507890 OR New York NEW YORK 12 Hour Days RN/Registered Nurse
527684 PICU New York NEW YORK 12 Hour Days RN/Registered Nurse
525987 Supervisor New York NEW YORK 8 Hour Days
525988 Supervisor New York NEW YORK 8 Hour Days
526102 ICU New York NEW YORK 12 Hour Days RN/Registered Nurse
534643 Med Surg New York NEW YORK 12 Hour Nights
535732 Pharmacist New York NEW YORK 8 Hour Nights
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.5291 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 z.city desc limit 1200,100 in 1.6322 seconds