Listing all records

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

ID Job Specialty City State Shift Title
546843 Telemetry Farmington CONNECTICUT 12 Hour Days
546623 ER Saratoga Springs NEW YORK 12 Hour Days
546684 L&D Detroit MICHIGAN 12 Hour Days
546687 PCU San Luis Obispo CALIFORNIA 12 Hour Days
543965 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
546868 ER MERCED CALIFORNIA 12 Hour Days
542008 CVICU Little Rock ARKANSAS 12 Hour Days
542049 Surgical Tech CVOR York PENNSYLVANIA 12 Hour Days
543446 Acute Care Kingsport TENNESSEE 12 Hour Days
546640 NICU Los Angeles CALIFORNIA 12 Hour Days
547051 RAD Tech Phoenix ARIZONA 12 Hour Days
545332 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
546858 CVOR Annapolis MARYLAND 12 Hour Days
546622 ER Saratoga Springs NEW YORK 12 Hour Days
546913 ER Des Moines IOWA 12 Hour Days
546985 Med Surg Tele Syracuse NEW YORK 12 Hour Days
545426 NICU Mishawaka INDIANA 12 Hour Days
546699 Med Surg Spokane WASHINGTON 12 Hour Days
542364 OR Spokane WASHINGTON 12 Hour Days
547002 Med Surg Dubuque IOWA 12 Hour Days
542387 Med Surg Des Moines IOWA 12 Hour Days
547013 Med Surg Tele Cleveland OHIO 12 Hour Days
547022 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
542523 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
545405 Surgical Tech CVOR Weston FLORIDA 12 Hour Days
545392 CT Tech Anchorage ALASKA 12 Hour Days
547073 NICU Walnut Creek CALIFORNIA 12 Hour Days
542572 ER Honolulu HAWAII 12 Hour Days RN/Registered Nurse
542618 PCU Sun City West ARIZONA 12 Hour Days
543861 L&D Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
545424 Med Surg Waterbury CONNECTICUT 12 Hour Days
545423 Med Surg Waterbury CONNECTICUT 12 Hour Days
545425 L&D Mishawaka INDIANA 12 Hour Days
542718 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
542758 Med Surg Tele Concord CALIFORNIA 12 Hour Days
547339 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
542811 ER Bronx NEW YORK 12 Hour Days
543884 ICU Philadelphia PENNSYLVANIA 12 Hour Days
544636 Interventional Radiology Tech PHOENIX ARIZONA 12 Hour Days
547382 L&D Seattle WASHINGTON 12 Hour Days
542905 Med Surg Lewiston MAINE 12 Hour Days
547461 Radiology Tech Auburn NEW YORK 12 Hour Days
544644 OR Silver Spring MARYLAND 12 Hour Days
547403 Med Surg Tele Kansas City MISSOURI 12 Hour Days
543933 Med Surg Bronx NEW YORK 12 Hour Days
544646 OR Silver Spring MARYLAND 12 Hour Days
544645 OR Silver Spring MARYLAND 12 Hour Days
543196 ER Newark NEW JERSEY 12 Hour Days
545501 Med Surg Tele Des Moines IOWA 12 Hour Days
545499 Respiratory Therapist Des Moines IOWA 12 Hour Days
547678 Med Surg Lowville NEW YORK 12 Hour Days
543078 Surgical Tech CVOR Ann Arbor MICHIGAN 12 Hour Days
547490 Pharmacist Abilene TEXAS 12 Hour Days
547540 PCU Coos Bay OREGON 12 Hour Days
547536 RAD Tech Tulsa OKLAHOMA 12 Hour Days
547570 Med Surg Per Diem/Local Contract Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
547557 CT Tech Akron OHIO 12 Hour Days
543119 Surgical Tech Columbus OHIO 12 Hour Days
547573 Med Surg Chillicothe OHIO 12 Hour Days
547575 ICU Lewiston MAINE 12 Hour Days
543124 Cath Lab Fresno CALIFORNIA 12 Hour Days
547595 First Assist Canton OHIO 12 Hour Days
545285 OR El Paso TEXAS 12 Hour Days
547672 CVOR Falls Church VIRGINIA 12 Hour Days
543186 Med Surg Oneonta NEW YORK 12 Hour Days
547616 PICU Santa Clara CALIFORNIA 12 Hour Days
543200 ICU Newark NEW JERSEY 12 Hour Days
547636 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
543230 OR Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543243 CVOR Falls Church VIRGINIA 12 Hour Days RN/Registered Nurse
547621 PICU Santa Clara CALIFORNIA 12 Hour Days
547650 Telemetry Hannibal MISSOURI 12 Hour Days
543291 Surgical Tech Muskegon MICHIGAN 12 Hour Days
543296 OR Albuquerque NEW MEXICO 12 Hour Days
544263 Surgical Tech Westerville OHIO 12 Hour Days
543308 NICU Walnut Creek CALIFORNIA 12 Hour Days
547674 CVOR Falls Church VIRGINIA 12 Hour Days
547677 Med Surg Lowville NEW YORK 12 Hour Days
544706 NICU Des Moines IOWA 12 Hour Days
547729 PCU Mesa ARIZONA 12 Hour Days
545685 Med Surg Gainesville FLORIDA 12 Hour Days
543371 PACU Fresno CALIFORNIA 12 Hour Days
543373 PACU Fresno CALIFORNIA 12 Hour Days
543374 PACU Fresno CALIFORNIA 12 Hour Days
548263 CNA Hampton IOWA 12 Hour Evenings CNA/Certified Nursing Assistant
548214 Psych Peoria ILLINOIS 12 Hour Evenings RN/Registered Nurse
548207 ER Mission Hills CALIFORNIA 12 Hour Evenings RN/Registered Nurse
545774 Pediatric ER Gainesville FLORIDA 12 Hour Evenings
545780 Pediatric ER Gainesville FLORIDA 12 Hour Evenings
545967 Pediatric ER Gainesville FLORIDA 12 Hour Evenings
541734 Med Surg Brooklyn NEW YORK 12 Hour Evenings
546693 Telemetry Oceanside CALIFORNIA 12 Hour Evenings
544225 Med Surg Dover NEW JERSEY 12 Hour Nights
526545 ICU - Per Diem Woodland Hills CALIFORNIA 12 Hour Nights RN/Registered Nurse
547698 ICU Saratoga Springs NEW YORK 12 Hour Nights
535604 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
540242 ICU Concord CALIFORNIA 12 Hour Nights
548410 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
540250 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540251 Med Surg Walnut Creek 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.6215 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.shift asc limit 1400,100 in 1.5804 seconds