Listing all records

Displaying records 3301 through 3400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
526998 Cardiac ICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
527053 CVOR Houston TEXAS 8 Hour Days RN/Registered Nurse
527184 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
527570 Med Surg Tele Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
527935 OR Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
530725 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
528069 PCU Flagstaff ARIZONA 12 Hour Nights RN/Registered Nurse
528182 Outpatient Clinic Per Diem San Diego CALIFORNIA 8 Hour Days RN/Registered Nurse
528573 Pediatrics Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
529616 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
529699 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530475 Telemetry Panorama City CALIFORNIA 12 Hour Days RN/Registered Nurse
530739 Med Surg Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530071 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530911 Pediatric ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
530323 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
542664 ICU - Per Diem Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
530439 ICU - Per Diem Woodland Hills CALIFORNIA 12 Hour Nights RN/Registered Nurse
530740 Med Surg Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
530741 Med Surg Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
530873 Med Surg Tele Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548039 OR Petersburg WEST VIRGINIA 8 Hour Days RN/Registered Nurse
531152 Med Surg Tele Farmington CONNECTICUT 12 Hour Nights RN/Registered Nurse
531204 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
531244 ICU   CALIFORNIA 12 Hour Days RN/Registered Nurse
531354 ER - Per Diem Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531355 ER - Per Diem Brooklyn NEW YORK 12 Hour Days 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
531848 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights 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
535911 Telemetry Lubbock TEXAS 12 Hour Days RN/Registered Nurse
536346 CVOR Lumberton NORTH CAROLINA 8 Hour Days RN/Registered Nurse
538592 Telemetry Panorama City CALIFORNIA 12 Hour Days RN/Registered Nurse
536558 ER Syracuse NEW YORK 12 Hour Nights RN/Registered Nurse
538306 Step Down Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
538137 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Days 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
540529 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
543965 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
542340 Home Health Santa Fe NEW MEXICO 8 Hour Days RN/Registered Nurse
542572 ER Honolulu HAWAII 12 Hour Days RN/Registered Nurse
548322 PICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
543201 Psych Grand Rapids MICHIGAN 8 Hour Evenings 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
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
546192 ICU - Per Diem Irvine CALIFORNIA 12 Hour Nights RN/Registered Nurse
546301 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
546368 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
546561 ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548399 PCU Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548400 ER Albany NEW YORK 12 Hour Nights RN/Registered Nurse
548401 ER Schenectady NEW YORK 12 Hour Days RN/Registered Nurse
548402 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
548403 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548153 Home Health Pomona CALIFORNIA 8 Hour Days RN/Registered Nurse
546778 Ambulatory Syracuse NEW YORK 8 Hour Days RN/Registered Nurse
548053 NICU New York NEW YORK 12 Hour Days RN/Registered Nurse
546879 Med Surg Tele Prescott ARIZONA 12 Hour Days RN/Registered Nurse
546880 Med Surg Show Low ARIZONA 12 Hour Nights RN/Registered Nurse
546881 ER MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
546882 Step Down South Charleston WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
546907 Telemetry Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
546908 Oncology Terre Haute INDIANA 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
548161 Surgical Tech MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
548162 OR Centerville IOWA 8 Hour Days RN/Registered Nurse
548163 OR Mason City IOWA 8 Hour Days RN/Registered Nurse
548164 LTAC Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548165 ICU San Jose CALIFORNIA 12 Hour Nights RN/Registered Nurse
548166 Med Surg Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
548167 ER Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548168 Certified Surgical Tech Coos Bay OREGON 10 Hour Days RN/Registered Nurse
548040 PCU Lowell MASSACHUSETTS 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.5889 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 3300,100 in 1.424 seconds