Listing all records

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

ID Job Specialty City State Shift Title
540032 Surgical Tech CVOR Farmington CONNECTICUT 8 Hour Days
540040 Telemetry Farmington CONNECTICUT 12 Hour Days
540041 Ultrasound Tech Farmington CONNECTICUT 12 Hour Days
540043 CMA Farmington CONNECTICUT 8 Hour Days
540045 OR Farmington CONNECTICUT 10 Hour Days
540055 ICU Farmington CONNECTICUT 12 Hour Nights
540060 CT Tech Farmington CONNECTICUT 10 Hour Days
540061 OR Farmington CONNECTICUT 10 Hour Days
540062 OR Farmington CONNECTICUT 10 Hour Days
540063 Telemetry Farmington CONNECTICUT 12 Hour Nights
540065 Telemetry Farmington CONNECTICUT 12 Hour Days
546432 Telemetry Farmington CONNECTICUT 12 Hour Days
546843 Telemetry Farmington CONNECTICUT 12 Hour Days
546668 Ultrasound Tech Farmington CONNECTICUT 8 Hour Days
546844 Telemetry Farmington CONNECTICUT 12 Hour Days
547074 Social Worker Farmington CONNECTICUT 8 Hour Days
547075 Social Worker Farmington CONNECTICUT 8 Hour Days
547076 CT Tech Farmington CONNECTICUT 12 Hour Nights
547077 CT Tech Farmington CONNECTICUT 12 Hour Nights
547822 Interventional Radiology Tech Farmington NEW MEXICO 8 Hour Days
547833 PT Farmington CONNECTICUT 8 Hour Days
547945 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
540083 RAD Tech Farmington CONNECTICUT 8 Hour Days
540569 Telemetry Farmington CONNECTICUT 12 Hour Nights
540867 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
540878 Case Manager Farmington CONNECTICUT 8 Hour Evenings
540879 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Days
540890 Surgical Tech CVOR Farmington CONNECTICUT 10 Hour Days
540891 MLT Farmington CONNECTICUT 8 Hour Days
540892 MLT Farmington CONNECTICUT 8 Hour Days
540976 Phlebotomist Farmington CONNECTICUT 8 Hour Days
541038 Phlebotomist Farmington CONNECTICUT 8 Hour Days
541117 Telemetry Farmington CONNECTICUT 12 Hour Nights
542084 RAD Tech Farmington CONNECTICUT 8 Hour Days
542595 CMA Farmington CONNECTICUT 8 Hour Days
544103 Phlebotomist Farmington CONNECTICUT 8 Hour Days
543193 Ultrasound Tech Farmington CONNECTICUT 8 Hour Days
543309 Telemetry Farmington CONNECTICUT 12 Hour Nights
543337 OR Farmington CONNECTICUT 10 Hour Days
543338 OR Farmington CONNECTICUT 10 Hour Days
543355 Phlebotomist Farmington CONNECTICUT 8 Hour Days
544152 Surgical Tech Farmington CONNECTICUT 10 Hour Days
544251 OR Farmington CONNECTICUT 10 Hour Days
545273 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Days
545226 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
545264 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
545274 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
545302 RAD Tech Farmington CONNECTICUT 8 Hour Evenings
545303 PACU Farmington CONNECTICUT 10 Hour Days
545489 MRI Tech Farmington CONNECTICUT 8 Hour Evenings
545490 CT Tech Farmington CONNECTICUT 8 Hour Nights
547141 RAD Tech Farmington CONNECTICUT 8 Hour Nights
544199 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
544422 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
544502 Interventional Radiology Tech Fayetteville NORTH CAROLINA 10 Hour Days
544518 PCU Fayetteville NORTH CAROLINA 12 Hour Nights
544547 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
544658 Med Surg Fayetteville NORTH CAROLINA 12 Hour Nights
544667 Med Surg Fayetteville NORTH CAROLINA 12 Hour Nights
538047 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
547474 LTAC Fayetteville NORTH CAROLINA 12 Hour Nights
547475 LTAC Fayetteville NORTH CAROLINA 12 Hour Days
547604 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
547605 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
541403 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
542877 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
543747 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
505886 MRI Tech Federal Way WASHINGTON 10 Hour Days
528069 PCU Flagstaff ARIZONA 12 Hour Nights RN/Registered Nurse
547681 Radiation Therapy Flint MICHIGAN 10 Hour Days
547982 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
547983 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
547998 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
547999 Med Surg Florence SOUTH CAROLINA 12 Hour Nights
545486 RAD Tech Florence SOUTH CAROLINA 8 Hour Days
546128 Certified Surgical Tech Florence SOUTH CAROLINA 12 Hour Days
548367 ER FOLSOM CALIFORNIA 12 Hour Nights RN/Registered Nurse
546360 Sonographer Forest Hills NEW YORK 8 Hour Days
548010 CT Tech Fort Bragg CALIFORNIA 12 Hour Day/Night Rotate
546799 Ambulatory Fort Defiance ARIZONA 8 Hour Days
547561 Pediatrics Fort Defiance ARIZONA 12 Hour Day/Night Rotate
544535 Psych Fort Defiance ARIZONA 12 Hour Varied
544796 Clinic Fort Defiance ARIZONA 8 Hour Days
539089 PT Fort Dodge IOWA 8 Hour Days
547402 Cath Lab Tech Fort Smith ARIZONA 8 Hour Day/Night Rotate
544124 Cath Lab Fort Smith ARIZONA 8 Hour Day/Night Rotate
546354 Cardiology Fountain Valley CALIFORNIA 12 Hour Days
547852 Ultrasound Tech Fredericksburg VIRGINIA 8 Hour Days
501006 PTA Freehold NEW JERSEY Days
509587 PT Freehold NEW JERSEY Days
534093 SLP Freehold NEW JERSEY Days
523666 PTA Freemont CALIFORNIA Days
527222 PT Freemont CALIFORNIA Days
526268 Interventional Radiology Tech Fresno CALIFORNIA 12 Hour Days
528482 SLP Fresno CALIFORNIA Days
536509 CVOR Fresno CALIFORNIA 12 Hour Days
536510 CVOR Fresno CALIFORNIA 12 Hour Days
536731 Surgical Tech Fresno CALIFORNIA 10 Hour Days
539948 Social Worker Fresno CALIFORNIA Days
539151 Surgical Tech Fresno 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.5488 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 1200,100 in 1.2615 seconds