Listing all records

Displaying records 1401 through 1500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
542811 ER Bronx NEW YORK 12 Hour Days
544096 Cath Lab Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
542822 Therapy Rehab Cheraw SOUTH CAROLINA Days
542826 Surgical Tech Boise IDAHO Days
544116 Telemetry Cleveland OHIO 12 Hour Nights
542846 Interventional Radiology Tech Oceanside CALIFORNIA 10 Hour Days
542856 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
542858 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
542873 PT Monterey CALIFORNIA Days
542877 Step Down Fayetteville NORTH CAROLINA 12 Hour Nights
544434 Telemetry IOWA CITY IOWA 12 Hour Nights
543480 Therapy Rehab Athens GEORGIA 8 Hour Days
542905 Med Surg Lewiston MAINE 12 Hour Days
542908 ICU Cleveland OHIO 12 Hour Day/Night Rotate
542910 Med Surg Tele Garfield Heights OHIO 12 Hour Nights
542997 Cath Lab Concord CALIFORNIA 10 Hour Days
542943 CT Tech San Bernardino CALIFORNIA 8 Hour Day/Night Rotate
542944 ER Concord CALIFORNIA 12 Hour Nights
542946 Surgical Tech Boise IDAHO Days
542972 Acute Care New York NEW YORK Days
542981 Med Surg Watertown NEW YORK 12 Hour Nights
542986 RAD Tech Tuba City ARIZONA 12 Hour Day/Night Rotate
543005 CT Tech Oceanside CALIFORNIA 10 Hour Days
543006 CVOR Oceanside CALIFORNIA 8 Hour Days
543336 CT Tech Westerville OHIO 10 Hour Days
543032 Long Term Care Lowville NEW YORK 12 Hour Nights
543196 ER Newark NEW JERSEY 12 Hour Days
543038 Telemetry San Diego CALIFORNIA 12 Hour Day/Night Rotate
543039 CLS San Diego CALIFORNIA 12 Hour Day/Night Rotate
543040 CT Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
543286 RAD Tech Lynwood CALIFORNIA 8 Hour Nights
543041 Oncology Janesville WISCONSIN Varied
543044 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
543045 Sterile Processing Tech Cleveland OHIO 8 Hour Evenings
543046 Histology Technician Watertown NEW YORK Days
543047 PT thermopolis WYOMING Days
543060 RAD Tech Toppenish WASHINGTON 8 Hour Days
543078 Surgical Tech CVOR Ann Arbor MICHIGAN 12 Hour Days
543087 PTA Ukiah CALIFORNIA 8 Hour Days
543089 OR San Dimas CALIFORNIA 8 Hour Days
543090 MICU San Dimas CALIFORNIA 12 Hour Nights
543092 MICU San Dimas CALIFORNIA 12 Hour Nights
543095 Cath Lab Newark NEW JERSEY 12 Hour Nights
544121 CT Tech Avalon CALIFORNIA 8 Hour Varied
543778 RAD Tech San Diego CALIFORNIA 12 Hour Day/Night Rotate
543097 Respiratory Therapist Newark NEW JERSEY 12 Hour Nights
543115 L&D Westerville OHIO 12 Hour Nights
543116 RN Columbus OHIO 8 Hour Days
543117 RN Columbus OHIO 10 Hour Days
543118 RN Columbus OHIO 12 Hour Nights
543119 Surgical Tech Columbus OHIO 12 Hour Days
543122 ER Primghar IOWA 12 Hour Nights
543123 ER Primghar IOWA 12 Hour Nights
543124 Cath Lab Fresno CALIFORNIA 12 Hour Days
543126 Cath Lab Mason City IOWA 8 Hour Days
543127 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543128 Surgical Tech Fresno CALIFORNIA 10 Hour Days
544124 Cath Lab Fort Smith ARIZONA 8 Hour Day/Night Rotate
543130 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543133 Echo Charlottesville VIRGINIA 8 Hour Days
543147 Med Surg Tele Potsdam NEW YORK 12 Hour Nights
543153 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
543178 Neuro Intensive Care New York NEW YORK Days
543183 Surgical Tech Athens GEORGIA 8 Hour Days
543184 Surgical Tech Athens GEORGIA 8 Hour Days
543186 Med Surg Oneonta NEW YORK 12 Hour Days
543193 Ultrasound Tech Farmington CONNECTICUT 8 Hour Days
543199 ICU Newark NEW JERSEY 12 Hour Nights
543200 ICU Newark NEW JERSEY 12 Hour Days
543769 CLS Lynwood CALIFORNIA 12 Hour Days
543214 Telemetry Cleveland OHIO 12 Hour Nights
543215 Telemetry Cleveland OHIO 12 Hour Nights
543225 PCU Johnson City TENNESSEE 12 Hour Nights
543784 GI Lab Woonsocket RHODE ISLAND 8 Hour Days
544104 OR Langhorne PENNSYLVANIA 12 Hour Nights
543783 RAD Tech Redding CALIFORNIA 8 Hour Days
543245 Clinic Newport OREGON 8 Hour Days
543252 Telemetry Rock Hill SOUTH CAROLINA 12 Hour Nights
543259 Step Down Cleveland OHIO 12 Hour Nights
543260 Step Down Cleveland OHIO 12 Hour Nights
543285 SLP South San Francisco CALIFORNIA 8 Hour Days
543291 Surgical Tech Muskegon MICHIGAN 12 Hour Days
543293 PT Hudson FLORIDA Days
543296 OR Albuquerque NEW MEXICO 12 Hour Days
543297 OR Albuquerque NEW MEXICO Nights
543308 NICU Walnut Creek CALIFORNIA 12 Hour Days
543309 Telemetry Farmington CONNECTICUT 12 Hour Nights
543312 RAD Tech Denville NEW JERSEY Nights
544144 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
543330 Ultrasound Tech San Angelo TEXAS 12 Hour Nights
543332 CT Tech Waimea HAWAII 12 Hour Day/Night Rotate
543337 OR Farmington CONNECTICUT 10 Hour Days
543338 OR Farmington CONNECTICUT 10 Hour Days
543343 CT Tech Staten Island NEW YORK 8 Hour Days
543355 Phlebotomist Farmington CONNECTICUT 8 Hour Days
544143 Cath Lab Cleveland OHIO 10 Hour Days
543371 PACU Fresno CALIFORNIA 12 Hour Days
543373 PACU Fresno CALIFORNIA 12 Hour Days
543374 PACU Fresno CALIFORNIA 12 Hour Days
543378 Med Surg Tele Syracuse NEW YORK 12 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.4262 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 a.title asc limit 1400,100 in 1.3436 seconds