Listing all records

Displaying records 501 through 600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546103 OR Springfield MASSACHUSETTS 8 Hour Days
546832 Therapy Rehab Spring Valley ILLINOIS 12 Hour Day/Night Rotate
546608 Med Surg Spokane WASHINGTON 12 Hour Days
546699 Med Surg Spokane WASHINGTON 12 Hour Days
546899 Telemetry Spokane WASHINGTON 12 Hour Nights
547637 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
541473 CVOR Spokane WASHINGTON 10 Hour Days
541482 CVOR Spokane WASHINGTON 10 Hour Days
541483 CVOR Spokane WASHINGTON 10 Hour Days
541484 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
541485 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
541486 CVOR Spokane WASHINGTON 10 Hour Days
541489 Med Surg Spokane WASHINGTON 12 Hour Nights
541491 Interventional Radiology Spokane WASHINGTON 10 Hour Days
541492 Med Surg Spokane WASHINGTON 12 Hour Nights
541498 Med Surg Spokane WASHINGTON 12 Hour Nights
541499 Med Surg Spokane WASHINGTON 12 Hour Nights
541500 PCU Spokane WASHINGTON 12 Hour Nights
541501 PCU Spokane WASHINGTON 12 Hour Nights
541502 Med Surg Spokane WASHINGTON 12 Hour Nights
541503 PCU Spokane WASHINGTON 12 Hour Nights
541504 PCU Spokane WASHINGTON 12 Hour Nights
541505 PCU Spokane WASHINGTON 12 Hour Nights
541506 Med Surg Spokane WASHINGTON 12 Hour Nights
541508 Med Surg Spokane WASHINGTON 12 Hour Nights
541510 Med Surg Spokane WASHINGTON 12 Hour Nights
541511 Med Surg Spokane WASHINGTON 12 Hour Nights
541512 Med Surg Spokane WASHINGTON 12 Hour Nights
541513 Med Surg Spokane WASHINGTON 12 Hour Nights
541514 Med Surg Spokane WASHINGTON 12 Hour Nights
541518 PCU Spokane WASHINGTON 12 Hour Nights
541519 PCU Spokane WASHINGTON 12 Hour Nights
541521 PCU Spokane WASHINGTON 12 Hour Days
541522 PCU Spokane WASHINGTON 12 Hour Days
541524 PCU Spokane WASHINGTON 12 Hour Nights
541525 PCU Spokane WASHINGTON 12 Hour Days
541526 PCU Spokane WASHINGTON 12 Hour Days
541527 PCU Spokane WASHINGTON 12 Hour Days
541620 Med Surg Spokane WASHINGTON 12 Hour Nights
542364 OR Spokane WASHINGTON 12 Hour Days
542375 Med Surg Spokane WASHINGTON 12 Hour Nights
543535 Med Surg Spokane WASHINGTON 12 Hour Nights
543791 Med Surg Spokane WASHINGTON 12 Hour Nights
544034 PCU Spokane WASHINGTON 12 Hour Nights
454833 Med Surg Spokane WASHINGTON 12 Hour Nights
541958 CVICU Spokane WASHINGTON 12 Hour Nights
548342 Telemetry Spokane WASHINGTON 12 Hour Days RN/Registered Nurse
548348 Telemetry Spokane WASHINGTON 12 Hour Days RN/Registered Nurse
546148 Med Surg Spokane WASHINGTON 8 Hour Evenings
544558 PCU Spokane WASHINGTON 12 Hour Nights
544742 Med Surg Spokane WASHINGTON 12 Hour Days
544743 Med Surg Spokane WASHINGTON 12 Hour Days
546084 Med Surg Tele Spokane WASHINGTON 12 Hour Days
479108 SLP Spearfish SOUTH DAKOTA Days
547651 Med Surg Tele Spartanburg SOUTH CAROLINA 12 Hour Nights
514085 Therapy Rehab Sparks NEVADA Days
528766 PT Sparks NEVADA Days
514692 SLP Spanaway WASHINGTON Days
514696 Therapy Rehab Spanaway WASHINGTON Days
547965 SLP Spanaway WASHINGTON Days
547966 LPN/LVN Spanaway WASHINGTON Days
543285 SLP South San Francisco CALIFORNIA 8 Hour Days
548209 OB South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
548210 CNA South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
545288 Step Down South Charleston WEST VIRGINIA 12 Hour Nights
546882 Step Down South Charleston WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
495103 SLP South Bend INDIANA Days
497771 PT Sonora CALIFORNIA Days
537278 PT Sonoma CALIFORNIA 8 Hour Days
544701 OB/GYN Socorro NEW MEXICO 8 Hour Day/Night Rotate
545251 Clinic Sitka ALASKA Varied
542501 Long Term Care Sitka ALASKA 8 Hour Evenings
544016 Social Worker Sitka ALASKA Varied
546276 Pediatrics Sitka ALASKA Varied
546884 Respiratory Therapist Sitka ALASKA 10 Hour Varied
547775 Clinic Sitka ALASKA Varied
546999 Rehab Sioux City IOWA 12 Hour Nights
547277 CT Tech Sioux City IOWA 10 Hour Nights
544204 Med Surg Sioux City IOWA 12 Hour Days
530228 CVOR Sioux City IOWA 10 Hour Days
535231 Cath Lab Sioux City IOWA 8 Hour Days
535463 ICU Sioux City IOWA 12 Hour Nights
539710 Echo Sioux City IOWA 8 Hour Days
541107 Ultrasound Tech Sioux City IOWA 8 Hour Days
541108 Ultrasound Tech Sioux City IOWA 8 Hour Days
546966 CT Tech Silverdale WASHINGTON 10 Hour Nights
548151 L&D Silverdale WASHINGTON 12 Hour Days RN/Registered Nurse
544205 Ultrasound Tech Silver Spring MARYLAND 10 Hour Evenings
544264 RAD Tech Silver Spring MARYLAND 8 Hour Evenings
544377 Ultrasound Tech Silver Spring MARYLAND 8 Hour Evenings
544378 Ultrasound Tech Silver Spring MARYLAND 8 Hour Days
544644 OR Silver Spring MARYLAND 12 Hour Days
544645 OR Silver Spring MARYLAND 12 Hour Days
544646 OR Silver Spring MARYLAND 12 Hour Days
544647 OR Silver Spring MARYLAND 12 Hour Days
544648 OR Silver Spring MARYLAND Nights
544649 OR Silver Spring MARYLAND Nights
543370 Surgical Tech Silver Spring MARYLAND Nights
544375 Ultrasound Tech Silver Spring MARYLAND 10 Hour Nights
526713 CT Tech Silver Spring MARYLAND 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.5357 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 500,100 in 2.015 seconds