Listing all records

Displaying records 3001 through 3100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546646 PT San Ramon CALIFORNIA Days
545979 CT Tech Santa Barbara CALIFORNIA 12 Hour Day/Night Rotate
544444 PT Santa Clara CALIFORNIA 10 Hour Days
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
547613 PICU Santa Clara CALIFORNIA 12 Hour Nights
547614 PICU Santa Clara CALIFORNIA 12 Hour Nights
547616 PICU Santa Clara CALIFORNIA 12 Hour Days
547618 PICU Santa Clara CALIFORNIA 12 Hour Days
547620 PICU Santa Clara CALIFORNIA 12 Hour Days
547621 PICU Santa Clara CALIFORNIA 12 Hour Days
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
548065 Step Down SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
548396 CVICU SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
540747 CT Tech SANTA CRUZ CALIFORNIA 8 Hour Day/Night Rotate
542340 Home Health Santa Fe NEW MEXICO 8 Hour Days RN/Registered Nurse
547026 ICU Santa Fe NEW MEXICO 12 Hour Day/Night Rotate
545280 LPN/LVN SANTA MARIA CALIFORNIA 8 Hour Days
541840 PT SANTA MARIA 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
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
547978 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
547979 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
544896 OR Santa Monica CALIFORNIA 12 Hour Nights
546081 Case Manager Santa Monica CALIFORNIA 8 Hour Days
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
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
546807 OT Saranac Lake NEW YORK 8 Hour Days
547368 Home Health Sarasota FLORIDA 8 Hour 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
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
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
547869 PT Savannah GEORGIA Days
548401 ER Schenectady NEW YORK 12 Hour Days RN/Registered Nurse
548047 Respiratory Therapist Schenectady NEW YORK 12 Hour Nights Respiratory Therapist
539926 Med Surg Schenectady NEW YORK 12 Hour Days
544819 ER Schenectady NEW YORK 12 Hour Nights
507007 Administration Scobey MONTANA Varied
490405 Long Term Care Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
492265 Long Term Care Scottsbluff NEBRASKA Nights
547963 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
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
515505 PT Scranton SOUTH CAROLINA Days
547646 L&D Seaside OREGON 12 Hour Day/Night Rotate
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
539836 RAD Tech Seattle WASHINGTON 8 Hour Days
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
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.818 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 3000,100 in 1.3414 seconds