Listing all records

Displaying records 3101 through 3200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548238 Neuro Intensive Care Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
543178 Neuro Intensive Care New York NEW YORK Days
543759 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
543760 Neuro Intensive Care Lynwood CALIFORNIA 12 Hour Nights
548298 Neuro Intensive Care PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
546245 Neuro Intensive Care Seattle WASHINGTON 12 Hour Nights
547735 Neuro Intensive Care Palo Alto CALIFORNIA 12 Hour Day/Night Rotate
530911 Pediatric ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
540498 Pediatric ER New York NEW YORK 12 Hour Nights
542390 Pediatric ER New York NEW YORK 12 Hour Nights
547970 Pediatric ER Bronx NEW YORK Nights
548180 Pediatric ER Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
545641 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545643 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545644 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545645 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545774 Pediatric ER Gainesville FLORIDA 12 Hour Evenings
545776 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545780 Pediatric ER Gainesville FLORIDA 12 Hour Evenings
545835 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545914 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545967 Pediatric ER Gainesville FLORIDA 12 Hour Evenings
546440 Ophthalmic Tech Beverly Hills CALIFORNIA 8 Hour Days
547111 Ophthalmic Tech Duluth MINNESOTA Days
548139 Newborn Nursery Marion INDIANA 12 Hour Nights RN/Registered Nurse
541846 PCU Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
547560 Dialysis Per Diem Brooklyn NEW YORK 10 Hour Evenings RN/Registered Nurse
548337 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
539941 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548084 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548085 Med Surg Tele Per Diem Van Nuys 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
548143 House Supervisor New York NEW YORK 8 Hour Days RN/Registered Nurse
548144 House Supervisor New York NEW YORK 8 Hour Days RN/Registered Nurse
528182 Outpatient Clinic Per Diem San Diego CALIFORNIA 8 Hour Days RN/Registered Nurse
517353 ER - Per Diem San pedro CALIFORNIA 12 Hour Nights RN/Registered Nurse
519847 ER - Per Diem San pedro CALIFORNIA 12 Hour Nights RN/Registered Nurse
548193 ER - Per Diem Brooklyn NEW YORK 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
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
538137 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
548356 ER - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548122 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
544061 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548202 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
542402 Sterile Processing Tech Leavenworth KANSAS 8 Hour Days
543045 Sterile Processing Tech Cleveland OHIO 8 Hour Evenings
543977 Sterile Processing Tech Lamar COLORADO Days
544235 Sterile Processing Tech Denville NEW JERSEY 8 Hour Days
546392 Sterile Processing Tech Muskegon MICHIGAN Nights
546637 Sterile Processing Tech Muskegon MICHIGAN Nights
547061 Sterile Processing Tech Muskegon MICHIGAN Nights
547062 Sterile Processing Tech Muskegon MICHIGAN Nights
547276 Sterile Processing Tech Muskegon MICHIGAN Nights
547529 Sterile Processing Tech Berwyn ILLINOIS 8 Hour Evenings
496817 Surgical Tech Peterborough NEW HAMPSHIRE 8 Hour Days
548272 Surgical Tech Tuba City ARIZONA 10 Hour Days Tech/Technologist
506863 Surgical Tech Durham NORTH CAROLINA 10 Hour Days
547837 Surgical Tech Honolulu HAWAII 8 Hour Day/Night Rotate
517294 Surgical Tech Oceanside CALIFORNIA 10 Hour Days
524748 Surgical Tech Boise IDAHO 10 Hour Days
548318 Surgical Tech Bad Axe MICHIGAN 8 Hour Days Tech/Technologist
534167 Surgical Tech Centerville IOWA 8 Hour Days
534553 Surgical Tech Louisville KENTUCKY 8 Hour Days
535030 Surgical Tech Louisville KENTUCKY 12 Hour Days
539930 Surgical Tech Louisville KENTUCKY 8 Hour Days
540014 Surgical Tech Farmington CONNECTICUT 10 Hour Days
540018 Surgical Tech Farmington CONNECTICUT 8 Hour Days
540039 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540094 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540136 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
540163 Surgical Tech Concord CALIFORNIA 8 Hour Evenings
540180 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540185 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
543291 Surgical Tech Muskegon MICHIGAN 12 Hour Days
543370 Surgical Tech Silver Spring MARYLAND Nights
543630 Surgical Tech Stafford Springs CONNECTICUT 8 Hour Days
544152 Surgical Tech Farmington CONNECTICUT 10 Hour Days
544223 Surgical Tech Passaic NEW JERSEY 12 Hour Days
544234 Surgical Tech Denville NEW JERSEY 12 Hour Days
544263 Surgical Tech Westerville OHIO 12 Hour Days
544345 Surgical Tech Ketchum IDAHO 12 Hour Days
544595 Surgical Tech Anchorage ALASKA 10 Hour Days
544604 Surgical Tech Duluth MINNESOTA 12 Hour Day/Night Rotate
548083 Surgical Tech Seattle WASHINGTON 10 Hour Days Tech/Technologist
548315 Surgical Tech Detroit MICHIGAN 8 Hour Days Tech/Technologist
544735 Surgical Tech MERCED CALIFORNIA 12 Hour Days
544994 Surgical Tech Kearney NEBRASKA 8 Hour Days
545191 Surgical Tech New Albany OHIO 12 Hour Days
545277 Surgical Tech Templeton CALIFORNIA 10 Hour Days
545313 Surgical Tech SANTA ROSA CALIFORNIA 8 Hour Days
545393 Surgical Tech Anchorage ALASKA 10 Hour Nights
547979 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
547978 Surgical Tech Santa Monica CALIFORNIA 8 Hour Days
548161 Surgical Tech MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
547606 Surgical Tech Boise IDAHO 10 Hour Days
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.3513 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.specialty asc limit 3100,100 in 2.9803 seconds