Listing all records

Displaying records 3101 through 3200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548329 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
547445 PT Seguin TEXAS 8 Hour Days
547446 Rehab Seguin TEXAS 12 Hour Days
527125 Therapy Rehab Shelby MISSISSIPPI Days
541058 OR Sherwood ARKANSAS 10 Hour Days
546880 Med Surg Show Low ARIZONA 12 Hour Nights RN/Registered Nurse
548325 SLP Shreveport LOUISIANA 8 Hour Days SLP/Speech Language Pathologist
544290 Infusion Oncology Sidney MONTANA Days
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
526794 CT Tech Silver Spring MARYLAND 10 Hour Nights
546966 CT Tech Silverdale WASHINGTON 10 Hour Nights
548151 L&D Silverdale WASHINGTON 12 Hour Days RN/Registered Nurse
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
542501 Long Term Care Sitka ALASKA 8 Hour Evenings
544016 Social Worker Sitka ALASKA Varied
545251 Clinic Sitka ALASKA Varied
546276 Pediatrics Sitka ALASKA Varied
546884 Respiratory Therapist Sitka ALASKA 10 Hour Varied
547775 Clinic Sitka ALASKA Varied
544701 OB/GYN Socorro NEW MEXICO 8 Hour Day/Night Rotate
537278 PT Sonoma CALIFORNIA 8 Hour Days
497771 PT Sonora CALIFORNIA Days
495103 SLP South Bend INDIANA Days
546882 Step Down South Charleston WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
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
543285 SLP South San Francisco CALIFORNIA 8 Hour Days
514692 SLP Spanaway WASHINGTON Days
514696 Therapy Rehab Spanaway WASHINGTON Days
547965 SLP Spanaway WASHINGTON Days
547966 LPN/LVN Spanaway WASHINGTON Days
514085 Therapy Rehab Sparks NEVADA Days
528766 PT Sparks NEVADA Days
547651 Med Surg Tele Spartanburg SOUTH CAROLINA 12 Hour Nights
479108 SLP Spearfish SOUTH DAKOTA Days
454833 Med Surg Spokane WASHINGTON 12 Hour Nights
541958 CVICU Spokane WASHINGTON 12 Hour Nights
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
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
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
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.6498 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 3100,100 in 1.5696 seconds