Listing all records

Displaying records 501 through 600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
536828 Radiation Therapy Los Angeles CALIFORNIA 8 Hour Days
536850 Cath Lab Cleveland OHIO 8 Hour Days
536873 Telemetry Cleveland OHIO 12 Hour Nights
536932 RAD Tech Maywood ILLINOIS 8 Hour Days
537089 PT Sacramento CALIFORNIA 8 Hour Days
537141 ICU Ogdensburg NEW YORK 12 Hour Nights
537185 CT Tech Syracuse NEW YORK Nights
537193 Med Surg Bloomington INDIANA 12 Hour Nights
537278 PT Sonoma CALIFORNIA 8 Hour Days
537353 OR Chino CALIFORNIA 12 Hour Day/Night Rotate
537419 Med Surg Tele Des Moines IOWA 12 Hour Nights
537420 Med Surg Tele Des Moines IOWA 12 Hour Nights
537423 Neurology Des Moines IOWA 12 Hour Nights
537424 Neurology Des Moines IOWA 12 Hour Nights
537431 Med Surg Des Moines IOWA 12 Hour Nights
537432 Med Surg Des Moines IOWA 12 Hour Nights
537444 CNA Brooklyn NEW YORK 8 Hour Nights
537445 CNA Brooklyn NEW YORK 8 Hour Nights
537446 CNA Brooklyn NEW YORK 8 Hour Days
537453 MRI Tech Falls Church VIRGINIA 12 Hour Days
537460 Phlebotomist Farmington CONNECTICUT 8 Hour Days
537493 Med Surg Tele Waterbury CONNECTICUT 12 Hour Nights
537494 Med Surg Tele Waterbury CONNECTICUT 12 Hour Nights
537514 CT Tech The Dalles OREGON 12 Hour Day/Night Rotate
537715 OR Farmington CONNECTICUT 10 Hour Days
537716 OR Farmington CONNECTICUT 10 Hour Days
537738 PT Vidalia GEORGIA 12 Hour Days
537741 Psych New York NEW YORK 12 Hour Days
537758 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Days
537759 Sterile Processing Technician Farmington CONNECTICUT 8 Hour Evenings
537785 SLP Fargo NORTH DAKOTA Days
537792 L&D Ogdensburg NEW YORK 12 Hour Nights
537821 Dosimetrist Duluth MINNESOTA Varied
537901 ER Avalon CALIFORNIA 12 Hour Day/Night Rotate
537902 SNF Avalon CALIFORNIA 12 Hour Days
537910 PCU Lexington KENTUCKY 12 Hour Nights
537922 Neuro Med Surg/Tele Des Moines IOWA 12 Hour Nights
537958 MRI Tech Staten Island NEW YORK 8 Hour Evenings
537981 ICU Cleveland OHIO 12 Hour Days
538043 Respiratory Therapist Denville NEW JERSEY 12 Hour Nights
538044 Respiratory Therapist Denville NEW JERSEY 12 Hour Nights
538045 Respiratory Therapist Denville NEW JERSEY 12 Hour Nights
538047 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
538057 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
538064 Long Term Care Alturas CALIFORNIA 12 Hour Day/Night Rotate
538087 PT Honolulu HAWAII 8 Hour Days
538132 PT Salisbury MISSOURI Days
538136 Echo Mason City IOWA 12 Hour Days
538137 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
538172 MRI Tech Germantown MARYLAND 10 Hour Days
538176 Med Surg Waynesboro PENNSYLVANIA 12 Hour Day/Night Rotate
538179 ICU San Diego CALIFORNIA 12 Hour Day/Night Rotate
538181 Cath Lab San Diego CALIFORNIA 12 Hour Days
538182 Cath Lab San Diego CALIFORNIA 8 Hour Days
538185 CNA Avalon CALIFORNIA 12 Hour Days
538194 CT Tech Omaha NEBRASKA 12 Hour Nights
538195 CT Tech Omaha NEBRASKA 12 Hour Days
538242 PT Lansing MICHIGAN 8 Hour Days
538243 PT Lansing MICHIGAN 8 Hour Days
538261 ICU Ogdensburg NEW YORK 12 Hour Nights
538264 OR San Angelo TEXAS 8 Hour Day/Night Rotate
538278 Telemetry Cleveland OHIO 12 Hour Nights
538302 Home Health Plains MONTANA Varied
538304 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
538306 Step Down Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
538355 Cardiovascular Technologist Chino CALIFORNIA 8 Hour Days
538356 RAD Tech Chino CALIFORNIA 8 Hour Days
538382 CT Tech Cleveland OHIO 8 Hour Evenings
538391 Med Surg Tele Wailuku HAWAII 8 Hour Days
538394 ER Avalon CALIFORNIA 12 Hour Day/Night Rotate
538400 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
538402 CT Tech Bellefontaine OHIO 12 Hour Nights
538410 Med Surg Tele Wailuku HAWAII 12 Hour Nights
538434 Nuclear Med Technician Janesville WISCONSIN 8 Hour Days
538435 CT Tech Harvard ILLINOIS 8 Hour Evenings
538440 COTA Monterey CALIFORNIA Days
538454 CVICU Little Rock ARKANSAS 12 Hour Nights
538460 PCU Grand Island NEBRASKA 12 Hour Nights
538497 Laboratory New York NEW YORK 8 Hour Evenings
538498 CT Tech Riverhead NEW YORK 8 Hour Nights
538527 Long Term Care Rochdale MASSACHUSETTS 12 Hour Days
538542 Cath Lab Mason City IOWA 8 Hour Days
538546 OR Falls Church VIRGINIA 12 Hour Nights
538547 Med Surg Dover NEW JERSEY 12 Hour Days
538549 Med Surg Dover NEW JERSEY 12 Hour Nights
538550 Med Surg Dover NEW JERSEY 12 Hour Nights
538551 Med Surg Dover NEW JERSEY 12 Hour Nights
538553 Long Term Care Lewiston MAINE 12 Hour Days
538557 PT Orwigsburg PENNSYLVANIA Days
538580 Echo Technologist Columbia MISSOURI Days
538581 Long Term Care Canton NEW YORK 12 Hour Varied
538590 ER Des Moines IOWA 12 Hour Nights
538591 CT Tech Ann Arbor MICHIGAN 12 Hour Days
538592 Telemetry Panorama City CALIFORNIA 12 Hour Days RN/Registered Nurse
538598 RAD Tech IOWA CITY IOWA Varied
538599 PT Springfield PENNSYLVANIA Days
538622 ER New York NEW YORK 12 Hour Nights
538624 ER New York NEW YORK 12 Hour Nights
538625 Med Surg Brooklyn NEW YORK 12 Hour Days
538686 Laboratory New York NEW YORK 8 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.812 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.id asc limit 500,100 in 1.1713 seconds