Listing all records

Displaying records 1301 through 1400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545865 Med Surg Gainesville FLORIDA 12 Hour Days
540857 ER Springfield MASSACHUSETTS 12 Hour Days
545878 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545875 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
540895 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545817 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545882 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
543888 RAD Tech National City CALIFORNIA 12 Hour Days
544437 ER IOWA CITY IOWA 12 Hour Days
545896 ICU Gainesville FLORIDA 12 Hour Days
541037 L&D Walnut Creek CALIFORNIA 12 Hour Days
541068 Cath Lab PHOENIX ARIZONA 12 Hour Days
545902 ICU Gainesville FLORIDA 12 Hour Days
545907 Med Surg Gainesville FLORIDA 12 Hour Days
545908 Med Surg Gainesville FLORIDA 12 Hour Days
545945 Med Surg Gainesville FLORIDA 12 Hour Days
545920 Med Surg Gainesville FLORIDA 12 Hour Days
545930 Med Surg Gainesville FLORIDA 12 Hour Days
545928 Med Surg Gainesville FLORIDA 12 Hour Days
545925 Med Surg Gainesville FLORIDA 12 Hour Days
543078 Surgical Tech CVOR Ann Arbor MICHIGAN 12 Hour Days
541258 ICU Concord CALIFORNIA 12 Hour Days
547626 Certified Surgical Tech Santa Monica CALIFORNIA 12 Hour Days
544644 OR Silver Spring MARYLAND 12 Hour Days
542442 Med Surg Oneonta NEW YORK 12 Hour Days
545964 Ultrasound Tech Gainesville FLORIDA 12 Hour Days
545962 ICU Gainesville FLORIDA 12 Hour Days
545965 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
544645 OR Silver Spring MARYLAND 12 Hour Days
548152 ICU Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
545971 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545976 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
546259 Oncology Oklahoma City OKLAHOMA 12 Hour Days
544636 Interventional Radiology Tech PHOENIX ARIZONA 12 Hour Days
546005 PCU Mesa ARIZONA 12 Hour Days
545941 Med Surg Gainesville FLORIDA 12 Hour Days
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
546057 Med Surg Tele Saratoga Springs NEW YORK 12 Hour Days
546072 Surgical Tech Commerce Twp MICHIGAN 12 Hour Days
546128 Certified Surgical Tech Florence SOUTH CAROLINA 12 Hour Days
546142 Cardiology Muskegon MICHIGAN 12 Hour Days
546141 Med Surg Des Moines IOWA 12 Hour Days
546127 Med Surg Oxford NORTH CAROLINA 12 Hour Days
546198 Med Surg Bristol TENNESSEE 12 Hour Days
541521 PCU Spokane WASHINGTON 12 Hour Days
541522 PCU Spokane WASHINGTON 12 Hour Days
541525 PCU Spokane WASHINGTON 12 Hour Days
541526 PCU Spokane WASHINGTON 12 Hour Days
541527 PCU Spokane WASHINGTON 12 Hour Days
545756 Med Surg Gainesville FLORIDA 12 Hour Days
541634 NICU Greenbrae CALIFORNIA 12 Hour Days
546567 ICU Brooklyn NEW YORK 12 Hour Days
546602 CT Tech Minneapolis MINNESOTA 12 Hour Days
546331 ER Centerville IOWA 12 Hour Days
544743 Med Surg Spokane WASHINGTON 12 Hour Days
546629 PCU Bristol TENNESSEE 12 Hour Days
543965 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
546625 ER Saratoga Springs NEW YORK 12 Hour Days
542008 CVICU Little Rock ARKANSAS 12 Hour Days
546566 ICU Brooklyn NEW YORK 12 Hour Days
543308 NICU Walnut Creek CALIFORNIA 12 Hour Days
542049 Surgical Tech CVOR York PENNSYLVANIA 12 Hour Days
546368 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
546623 ER Saratoga Springs NEW YORK 12 Hour Days
546461 ER Des Moines IOWA 12 Hour Days
546432 Telemetry Farmington CONNECTICUT 12 Hour Days
543801 CT Tech Long Prairie MINNESOTA 12 Hour Days
544890 ER Concord CALIFORNIA 12 Hour Days
546684 L&D Detroit MICHIGAN 12 Hour Days
546462 ER Des Moines IOWA 12 Hour Days
546561 ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
546568 NICU Brooklyn NEW YORK 12 Hour Days
546591 MICU Brooklyn NEW YORK 12 Hour Days
546576 MICU Brooklyn NEW YORK 12 Hour Days
544219 Oncology Newark NEW JERSEY 12 Hour Days
546622 ER Saratoga Springs NEW YORK 12 Hour Days
544221 OR Newark NEW JERSEY 12 Hour Days
543371 PACU Fresno CALIFORNIA 12 Hour Days
542364 OR Spokane WASHINGTON 12 Hour Days
548402 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
542387 Med Surg Des Moines IOWA 12 Hour Days
546843 Telemetry Farmington CONNECTICUT 12 Hour Days
544223 Surgical Tech Passaic NEW JERSEY 12 Hour Days
546858 CVOR Annapolis MARYLAND 12 Hour Days
546697 Surgical Tech Reno NEVADA 12 Hour Days
546703 CT Tech Kremmling COLORADO 12 Hour Days
542523 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
546763 Oncology Oklahoma City OKLAHOMA 12 Hour Days
542572 ER Honolulu HAWAII 12 Hour Days RN/Registered Nurse
542811 ER Bronx NEW YORK 12 Hour Days
542618 PCU Sun City West ARIZONA 12 Hour Days
544895 RAD Tech Lynwood CALIFORNIA 12 Hour Days
547072 NICU Walnut Creek CALIFORNIA 12 Hour Days
546879 Med Surg Tele Prescott ARIZONA 12 Hour Days RN/Registered Nurse
542718 Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
546912 ER Goldendale WASHINGTON 12 Hour Days
542758 Med Surg Tele Concord CALIFORNIA 12 Hour Days
547002 Med Surg Dubuque IOWA 12 Hour Days
547014 Med Surg Tele Cleveland OHIO 12 Hour Days
547013 Med Surg Tele Cleveland OHIO 12 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.3491 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 1300,100 in 1.493 seconds