Listing all records

Displaying records 1901 through 2000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
534972 CT Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
544789 CNA Kealakekua HAWAII 12 Hour Day/Night Rotate
542685 Postpartum Kealakekua HAWAII 12 Hour Nights
542687 RAD Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
541359 Vascular Ultrasound Tech Kearney NEBRASKA 8 Hour Days
547654 PCU Kearney NEBRASKA 12 Hour Nights
547655 Med Surg Kearney NEBRASKA 12 Hour Nights
544994 Surgical Tech Kearney NEBRASKA 8 Hour Days
548248 ER Keene NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548131 Respiratory Therapist Keene NEW HAMPSHIRE 12 Hour Nights Respiratory Therapist
534999 PT Kerrville TEXAS Days
544344 L&D Ketchum IDAHO 12 Hour Nights
544345 Surgical Tech Ketchum IDAHO 12 Hour Days
546326 Social Worker Ketchum IDAHO 8 Hour Days
528446 PTA Killeen TEXAS Days
534706 PT King City CALIFORNIA Days
545988 Long Term Care King City CALIFORNIA 12 Hour Days
545989 Long Term Care King City CALIFORNIA 12 Hour Nights
545992 Pediatrics King City CALIFORNIA 12 Hour Nights
545997 LPN/LVN King City CALIFORNIA 12 Hour Days
536150 Lab Tech King Renton WASHINGTON 8 Hour Days
542786 Step Down Kingsport TENNESSEE 12 Hour Nights
543938 Med Surg Kingsport TENNESSEE 12 Hour Days
533362 CNA Kingsport TENNESSEE 12 Hour Nights
539703 Long Term Care Kingsport TENNESSEE 12 Hour Nights
547425 CVOR Kingsport TENNESSEE 8 Hour Days
547426 Scrub Tech Kingsport TENNESSEE 8 Hour Days
542772 Med Surg Kingsport TENNESSEE 12 Hour Nights
542773 Med Surg Kingsport TENNESSEE 12 Hour Nights
542790 PCU Kingsport TENNESSEE 12 Hour Nights
543446 Acute Care Kingsport TENNESSEE 12 Hour Days
543461 Oncology Kingsport TENNESSEE 12 Hour Nights
544853 Med Surg Kingsport TENNESSEE 12 Hour Nights
547890 CT Tech Knoxville TENNESSEE 12 Hour Nights
547625 CNA Kula HAWAII 8 Hour Days
544529 Med Surg Kula HAWAII 12 Hour Nights
519045 Med Surg Kula HAWAII 8 Hour Nights
519146 Med Surg Kula HAWAII 8 Hour Days
523400 Med Surg Kula HAWAII 8 Hour Nights
523403 Med Surg Kula HAWAII 8 Hour Nights
548121 Med Surg Kula HAWAII 12 Hour Nights RN/Registered Nurse
447084 CT Tech La Palma CALIFORNIA 12 Hour Day/Night Rotate
546630 Med Surg Tele Laconia NEW HAMPSHIRE Nights
547667 ICU Laconia NEW HAMPSHIRE Nights
547668 ICU Laconia NEW HAMPSHIRE Nights
542299 ER Laconia NEW HAMPSHIRE Nights
543585 CT Tech Laconia NEW HAMPSHIRE 12 Hour Days
543693 Med Surg Tele Laconia NEW HAMPSHIRE 12 Hour Day/Night Rotate
544772 Home Health Lake Charles LOUISIANA 8 Hour Days
547893 Certified Surgical Tech Lake Charles LOUISIANA 8 Hour Days
542449 PTA Lakeport CALIFORNIA 8 Hour Days
542427 PT Lakeport CALIFORNIA Varied
546355 CVOR Lakewood CALIFORNIA 8 Hour Days
546356 CVOR Lakewood CALIFORNIA 8 Hour Days
546357 CVOR Lakewood CALIFORNIA 8 Hour Days
540523 L&D Lamar COLORADO 12 Hour Nights
543977 Sterile Processing Tech Lamar COLORADO Days
543978 Scrub Tech Lamar COLORADO 8 Hour Day/Night Rotate
545122 Med Surg Lancaster OHIO 12 Hour Nights
492900 PT Lancaster MASSACHUSETTS Days
544403 First Assist Lancaster OHIO Days
545482 PCU Lancaster SOUTH CAROLINA 12 Hour Nights
545616 Med Surg Lancaster SOUTH CAROLINA 12 Hour Nights
544376 Sterile Processing Technician Langhorne PENNSYLVANIA Nights
544104 OR Langhorne PENNSYLVANIA 12 Hour Nights
534798 MRI Tech Langhorne PENNSYLVANIA 8 Hour Evenings
538242 PT Lansing MICHIGAN 8 Hour Days
538243 PT Lansing MICHIGAN 8 Hour Days
548072 ER Lansing MICHIGAN 12 Hour Days RN/Registered Nurse
546382 Step Down Lansing MICHIGAN 12 Hour Nights
547638 Med Surg Tele Lansing MICHIGAN 12 Hour Nights
543527 Step Down Lansing MICHIGAN Nights
543824 ER Lansing MICHIGAN 12 Hour Nights
544036 Step Down Lansing MICHIGAN 12 Hour Nights
544037 Step Down Lansing MICHIGAN 12 Hour Nights
547624 L&D Laramie WYOMING Nights
547099 PT Laurinburg NORTH CAROLINA 8 Hour Days
547820 OR Laurinburg NORTH CAROLINA 8 Hour Days
548037 OR Laurinburg NORTH CAROLINA 8 Hour Days
547908 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
547909 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
460916 PT Lawton OKLAHOMA 8 Hour Days
512505 MRI Tech Lawton OKLAHOMA 8 Hour Days
533274 PT Lawton OKLAHOMA Days
533275 PT Lawton OKLAHOMA Days
534888 Home Health Lawton OKLAHOMA 8 Hour Days
535919 Ultrasound Tech Lawton OKLAHOMA 8 Hour Days
542401 Surgical Tech Leavenworth KANSAS 8 Hour Days
542402 Sterile Processing Tech Leavenworth KANSAS 8 Hour Days
545154 RAD Tech Lebanon NEW HAMPSHIRE 12 Hour Nights
548067 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
548225 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
546381 Paramedic Lewisburg PENNSYLVANIA 12 Hour Day/Night Rotate
546604 RAD Tech Lewiston MAINE 10 Hour Days
547094 Surgical Tech CVOR Lewiston MAINE 10 Hour Days
547574 Med Surg Lewiston MAINE 12 Hour Days
547575 ICU Lewiston MAINE 12 Hour Days
547980 Med Surg Tele Lewiston MAINE 12 Hour Nights
547981 Med Surg Tele Lewiston MAINE 12 Hour Nights
548190 Psych Lewiston MAINE 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.4906 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 z.city asc limit 1900,100 in 1.6884 seconds