Listing all records

Displaying records 2401 through 2500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
538686 Laboratory New York NEW YORK 8 Hour Days
539450 Med Surg New York NEW YORK 8 Hour Evenings
539559 Laboratory New York NEW YORK 8 Hour Evenings
544904 RAD Tech New York NEW YORK 8 Hour Days
545170 Infusion New York NEW YORK 8 Hour Days
546641 Acute Care New York NEW YORK 8 Hour Days
547907 Med Surg New York NEW YORK Nights
547420 Radiology New York NEW YORK Nights
547423 Ambulatory New York NEW YORK 8 Hour Days
547692 Ambulatory New York NEW YORK 8 Hour Days
547711 ER New York NEW YORK 12 Hour Days
547715 Med Surg New York NEW YORK 12 Hour Nights
547716 Med Surg New York NEW YORK 8 Hour Days
547718 Rehab New York NEW YORK Nights
547746 Ambulatory New York NEW YORK 8 Hour Days
547747 Ambulatory New York NEW YORK 8 Hour Days
547748 Med Surg New York NEW YORK 8 Hour Nights
547749 Med Surg New York NEW YORK 8 Hour Nights
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
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
548252 ICU - Per Diem Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
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
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
548152 ICU Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548330 Oncology Newark NEW JERSEY 8 Hour Days RN/Registered Nurse
542803 Med Surg Newberg OREGON 12 Hour Nights
518534 COTA NEWMAN CALIFORNIA Days
520208 PT NEWMAN CALIFORNIA Days
543245 Clinic Newport OREGON 8 Hour Days
545066 PT Newport OREGON 8 Hour Days
541798 L&D Newton IOWA 12 Hour Nights
548034 ICU Newton IOWA 12 Hour Nights
547593 ICU Newton IOWA 12 Hour Nights
546346 PT Nogales ARIZONA 8 Hour Days
544884 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
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
548194 OR Norman OKLAHOMA 12 Hour Days RN/Registered Nurse
547513 Surgical Tech CVOR Norman OKLAHOMA 8 Hour Days
544091 Med Surg Norman OKLAHOMA 12 Hour Nights
547697 PT Norristown PENNSYLVANIA Days
548382 ER North Adams MASSACHUSETTS 12 Hour Days RN/Registered Nurse
547786 CVOR North Kansas City MISSOURI 8 Hour Days
527231 PT North Kingstown RHODE ISLAND Days
474328 PT North Manchester INDIANA Days
547707 ICU North Platte NEBRASKA Nights
527487 PTA North Providence RHODE ISLAND Days
535640 PT NORTHRIDGE CALIFORNIA 8 Hour Days
536753 PT NORTHRIDGE CALIFORNIA 8 Hour Days
546988 Radiation Therapy NORTHRIDGE CALIFORNIA 8 Hour Days
548045 OR NORTHRIDGE CALIFORNIA 12 Hour Nights RN/Registered Nurse
547290 ER Norton VIRGINIA 12 Hour Days
546067 ICU Norton VIRGINIA 12 Hour Nights
539689 Med Surg Norton VIRGINIA 12 Hour Nights
542424 PT Norwalk IOWA Days
542780 SLP Oakhurst CALIFORNIA Days
496231 COTA Oakhurst CALIFORNIA Days
523531 PTA Oakland NEW JERSEY Days
523668 PT Oakland CALIFORNIA Days
542847 SLP Oakland NEW JERSEY Days
540423 Case Manager Oceanside CALIFORNIA 8 Hour Days
540425 CT Tech Oceanside CALIFORNIA 8 Hour Evenings
542846 Interventional Radiology Tech Oceanside CALIFORNIA 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.685 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 asc limit 2400,100 in 1.4689 seconds