Listing all records

Displaying records 601 through 700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
526794 CT Tech Silver Spring MARYLAND 10 Hour Nights
544290 Infusion Oncology Sidney MONTANA Days
548325 SLP Shreveport LOUISIANA 8 Hour Days SLP/Speech Language Pathologist
546880 Med Surg Show Low ARIZONA 12 Hour Nights RN/Registered Nurse
541058 OR Sherwood ARKANSAS 10 Hour Days
527125 Therapy Rehab Shelby MISSISSIPPI Days
547445 PT Seguin TEXAS 8 Hour Days
547446 Rehab Seguin TEXAS 12 Hour Days
546245 Neuro Intensive Care Seattle WASHINGTON 12 Hour Nights
548399 PCU Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
547381 L&D Seattle WASHINGTON 12 Hour Days
547382 L&D Seattle WASHINGTON 12 Hour Days
547383 L&D Seattle WASHINGTON 12 Hour Nights
547386 Med Surg Seattle WASHINGTON 12 Hour Nights
547640 Med Surg Seattle WASHINGTON 12 Hour Nights
547898 Nuclear Med Technician Seattle WASHINGTON 8 Hour Days
547900 Infection Prevention Specialist Seattle WASHINGTON 12 Hour Day/Night Rotate
548251 ICU Seattle WASHINGTON 12 Hour Days RN/Registered Nurse
546163 L&D Seattle WASHINGTON 12 Hour Nights
548083 Surgical Tech Seattle WASHINGTON 10 Hour Days Tech/Technologist
548145 Telemetry Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548312 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548329 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
539836 RAD Tech Seattle WASHINGTON 8 Hour Days
547646 L&D Seaside OREGON 12 Hour Day/Night Rotate
515505 PT Scranton SOUTH CAROLINA Days
490405 Long Term Care Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
492265 Long Term Care Scottsbluff NEBRASKA Nights
546455 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
542474 Sterile Processing Technician Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
544388 ICU Scottsbluff NEBRASKA 12 Hour Varied
544977 Scrub Tech Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
545242 ICU Scottsbluff NEBRASKA 12 Hour Varied
547963 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
507007 Administration Scobey MONTANA Varied
539926 Med Surg Schenectady NEW YORK 12 Hour Days
548047 Respiratory Therapist Schenectady NEW YORK 12 Hour Nights Respiratory Therapist
548401 ER Schenectady NEW YORK 12 Hour Days RN/Registered Nurse
544819 ER Schenectady NEW YORK 12 Hour Nights
547869 PT Savannah GEORGIA Days
546597 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
546598 ER Saratoga Springs NEW YORK 12 Hour Nights
546599 ER Saratoga Springs NEW YORK 12 Hour Nights
546620 ER Saratoga Springs NEW YORK 12 Hour Nights
546621 ER Saratoga Springs NEW YORK 12 Hour Nights
546622 ER Saratoga Springs NEW YORK 12 Hour Days
546623 ER Saratoga Springs NEW YORK 12 Hour Days
546624 ER Saratoga Springs NEW YORK 12 Hour Days
546625 ER Saratoga Springs NEW YORK 12 Hour Days
547789 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Days
547875 Urgent Care Saratoga Springs NEW YORK 12 Hour Days
548187 L&D Saratoga Springs NEW YORK 12 Hour Nights RN/Registered Nurse
548189 Med Surg Saratoga Springs NEW YORK 12 Hour Nights RN/Registered Nurse
542740 ICU Saratoga Springs NEW YORK 12 Hour Nights
543475 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Nights
547698 ICU Saratoga Springs NEW YORK 12 Hour Nights
544153 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
546056 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Nights
546057 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Days
547368 Home Health Sarasota FLORIDA 8 Hour Days
546807 OT Saranac Lake NEW YORK 8 Hour Days
546309 ER Santa Rosa NEW MEXICO 12 Hour Nights
546310 ER Santa Rosa NEW MEXICO 12 Hour Nights
548254 Home Health Santa Rosa CALIFORNIA 8 Hour Days RN/Registered Nurse
545310 OR SANTA ROSA CALIFORNIA 12 Hour Nights
545313 Surgical Tech SANTA ROSA CALIFORNIA 8 Hour Days
545314 Interventional Radiology SANTA ROSA CALIFORNIA Days
545317 PT SANTA ROSA CALIFORNIA 8 Hour Days
541652 PT SANTA ROSA CALIFORNIA 8 Hour Days
541654 Surgical Tech SANTA ROSA CALIFORNIA 8 Hour Days
542380 PT SANTA ROSA CALIFORNIA 8 Hour Days
541642 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
541643 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
543380 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
544896 OR Santa Monica CALIFORNIA 12 Hour Nights
546081 Case Manager Santa Monica CALIFORNIA 8 Hour Days
547626 Certified Surgical Tech Santa Monica CALIFORNIA 12 Hour Days
546448 Nuclear Med Technician Santa Monica CALIFORNIA 12 Hour Days
546735 Telemetry Santa Monica CALIFORNIA 12 Hour Nights
547978 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
547979 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
545280 LPN/LVN SANTA MARIA CALIFORNIA 8 Hour Days
541840 PT SANTA MARIA CALIFORNIA 8 Hour Days
542340 Home Health Santa Fe NEW MEXICO 8 Hour Days RN/Registered Nurse
547026 ICU Santa Fe NEW MEXICO 12 Hour Day/Night Rotate
540747 CT Tech SANTA CRUZ CALIFORNIA 8 Hour Day/Night Rotate
548065 Step Down SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
548396 CVICU SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
548149 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548208 CVICU Santa Clara CALIFORNIA 12 Hour Days RN/Registered Nurse
548232 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548276 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548295 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548306 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548377 Telemetry Santa Clara CALIFORNIA 12 Hour Days RN/Registered Nurse
548386 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
547586 PICU Santa Clara CALIFORNIA 12 Hour Nights
547610 PICU Santa Clara CALIFORNIA 12 Hour Days
547611 PICU Santa Clara CALIFORNIA 12 Hour Nights
547612 PICU Santa Clara CALIFORNIA 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.2056 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 600,100 in 1.2687 seconds