Listing all records

Displaying records 3201 through 3300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545169 Acute Care Bronx NEW YORK 12 Hour Days
545179 Med Surg Brooklyn NEW YORK 12 Hour Days
545288 Step Down South Charleston WEST VIRGINIA 12 Hour Nights
545328 CNA Salem OREGON 12 Hour Nights
545468 ICU Tuba City ARIZONA 12 Hour Day/Night Rotate
546096 ICU Hilo HAWAII 12 Hour Days
546326 Social Worker Ketchum IDAHO 8 Hour Days
546343 Med Surg Tele Lubbock TEXAS 12 Hour Days
546352 CT Tech Manteca CALIFORNIA 8 Hour Days
546411 ICU Ogdensburg NEW YORK 12 Hour Nights
546577 ICU Brooklyn NEW YORK 12 Hour Nights
546591 MICU Brooklyn NEW YORK 12 Hour Days
546619 Acute Care Queens NEW YORK 8 Hour Days
546621 ER Saratoga Springs NEW YORK 12 Hour Nights
546639 Cardiac ICU Falls Church VIRGINIA 12 Hour Day/Night Rotate
548003 ER Pittsfield MASSACHUSETTS 12 Hour Nights
546692 Med Surg Oceanside CALIFORNIA 12 Hour Days
546757 OR Petoskey MICHIGAN 10 Hour Days
547932 Telemetry - Per Diem Oceanside CALIFORNIA 12 Hour Nights
548017 PACU Chico CALIFORNIA 10 Hour Days
547035 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547060 L&D Pittsfield MASSACHUSETTS 12 Hour Days
547297 Med Surg Tele Denison IOWA 12 Hour Nights
547383 L&D Seattle WASHINGTON 12 Hour Nights
547415 Ambulatory Bronx NEW YORK 8 Hour Days
547511 Certified Surgical Tech Pittsfield MASSACHUSETTS 8 Hour Days
547526 Med Surg Parkersburg WEST VIRGINIA 12 Hour Nights
547549 Med Surg Tele Manchester CONNECTICUT 12 Hour Nights
547569 NICU Lynwood CALIFORNIA 12 Hour Nights
547623 ER Albany OREGON 12 Hour Day/Night Rotate
547672 CVOR Falls Church VIRGINIA 12 Hour Days
547685 Electrophysiology Tech Monterey CALIFORNIA 8 Hour Days
547700 CVOR Sun City ARIZONA 10 Hour Days
547711 ER New York NEW YORK 12 Hour Days
547717 L&D Bronx NEW YORK 12 Hour Days
547722 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
547729 PCU Mesa ARIZONA 12 Hour Days
547746 Ambulatory New York NEW YORK 8 Hour Days
547776 ER Morton WASHINGTON Nights
547795 OR Tuba City ARIZONA 10 Hour Days
547817 Respiratory Therapist Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547880 CNA Bangor MAINE 12 Hour Nights
547903 Surgical Tech Grand Forks NORTH DAKOTA Evenings
547917 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
548246 Med Surg Tele CARMICHAEL CALIFORNIA 12 Hour Nights RN/Registered Nurse
548247 ER Artesia NEW MEXICO 12 Hour Nights RN/Registered Nurse
548248 ER Keene NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548265 ICU Columbus OHIO 12 Hour Nights RN/Registered Nurse
548266 ICU BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
548239 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
516546 ER Burbank CALIFORNIA 8 Hour Days RN/Registered Nurse
516920 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
517353 ER - Per Diem San pedro CALIFORNIA 12 Hour Nights RN/Registered Nurse
517382 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
518547 NICU Per Diem/Local Contract Torrance CALIFORNIA 12 Hour Nights RN/Registered Nurse
546875 Telemetry PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
541846 PCU Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
541847 Psych Peoria ILLINOIS 8 Hour Days RN/Registered Nurse
523478 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
523775 ICU Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
524038 ICU - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
524120 PICU Anchorage ALASKA 12 Hour Nights RN/Registered Nurse
530342 ICU Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
524588 ICU - Per Diem Oceanside CALIFORNIA 12 Hour Days RN/Registered Nurse
525187 CVICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
527493 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
527684 PICU New York NEW YORK 12 Hour Days RN/Registered Nurse
526053 RAD Tech Clearwater FLORIDA 8 Hour Days RN/Registered Nurse
526099 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
526101 ICU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
526102 ICU New York NEW YORK 12 Hour Days RN/Registered Nurse
526545 ICU - Per Diem Woodland Hills CALIFORNIA 12 Hour Nights RN/Registered Nurse
531394 Pediatrics Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531765 L&D Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531766 PICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
532090 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
532091 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
539477 Telemetry - Per Diem Mission Viejo CALIFORNIA 12 Hour Days RN/Registered Nurse
539941 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
543230 OR Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543243 CVOR Falls Church VIRGINIA 12 Hour Days RN/Registered Nurse
543872 NICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543861 L&D Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543862 PICU Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
544061 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548321 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
544359 NICU Queens NEW YORK 12 Hour Nights RN/Registered Nurse
544397 Med Surg Peoria ILLINOIS 12 Hour Days RN/Registered Nurse
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
547331 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
547469 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
547560 Dialysis Per Diem Brooklyn NEW YORK 10 Hour Evenings RN/Registered Nurse
547570 Med Surg Per Diem/Local Contract Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
547723 Med Surg Georgetown SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
547796 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548249 Med Surg Pontiac MICHIGAN 12 Hour Days RN/Registered Nurse
548251 ICU Seattle WASHINGTON 12 Hour Days RN/Registered Nurse
548252 ICU - Per Diem Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548253 Neuro Intensive Care Boston MASSACHUSETTS 12 Hour Days RN/Registered Nurse
548254 Home Health Santa Rosa CALIFORNIA 8 Hour Days 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.5602 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.title asc limit 3200,100 in 1.4902 seconds