Listing all records

Displaying records 601 through 700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
539710 Echo Sioux City IOWA 8 Hour Days
537910 PCU Lexington KENTUCKY 12 Hour Nights
537922 Neuro Med Surg/Tele Des Moines IOWA 12 Hour Nights
544177 Surgical Tech Madison WISCONSIN 8 Hour Day/Night Rotate
537958 MRI Tech Staten Island NEW YORK 8 Hour Evenings
537981 ICU Cleveland OHIO 12 Hour Days
543428 ICU Ogdensburg NEW YORK 12 Hour Nights
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
539616 PCU Johnson City TENNESSEE 12 Hour Nights
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
538261 ICU Ogdensburg NEW YORK 12 Hour Nights
538242 PT Lansing MICHIGAN 8 Hour Days
538243 PT Lansing MICHIGAN 8 Hour Days
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
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
540864 CT Tech Pigeon MICHIGAN 12 Hour Nights
539629 CT Tech Cleveland OHIO 8 Hour Nights
538402 CT Tech Bellefontaine OHIO 12 Hour Nights
538410 Med Surg Tele Wailuku HAWAII 12 Hour Nights
538542 Cath Lab Mason City IOWA 8 Hour Days
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
546759 L&D Auburn NEW YORK 12 Hour Nights
538527 Long Term Care Rochdale MASSACHUSETTS 12 Hour Days
540059 PACU Concord CALIFORNIA 10 Hour Days
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
538598 RAD Tech IOWA CITY IOWA Varied
538599 PT Springfield PENNSYLVANIA Days
538622 ER New York NEW YORK 12 Hour Nights
540061 OR Farmington CONNECTICUT 10 Hour Days
540060 CT Tech Farmington CONNECTICUT 10 Hour Days
545126 Med Surg Espanola NEW MEXICO Nights
538686 Laboratory New York NEW YORK 8 Hour Days
538714 Respiratory Therapist Mason City IOWA 12 Hour Nights
538717 Surgical Tech Columbus OHIO Days
538720 RN Columbus OHIO 12 Hour Days
538741 ICU Cleveland OHIO 12 Hour Day/Night Rotate
543405 ICU Rome NEW YORK 12 Hour Nights
538824 Medical Assistant Madison WISCONSIN 8 Hour Evenings
538849 Echo Honolulu HAWAII 8 Hour Days
539948 Social Worker Fresno CALIFORNIA Days
538869 MRI Tech Lexington KENTUCKY 8 Hour Nights
538892 Med Surg Janesville WISCONSIN 12 Hour Nights
538911 CT Tech Alturas CALIFORNIA 8 Hour Varied
538917 Med Surg Hilo HAWAII 12 Hour Day/Night Rotate
538936 Psych Boise IDAHO 12 Hour Nights
538951 Med Surg Tele Cleveland OHIO 12 Hour Nights
538956 Med Surg Tele Cleveland OHIO 12 Hour Nights
539009 Med Surg Tele Cleveland OHIO 12 Hour Nights
539020 Step Down Morgantown WEST VIRGINIA 12 Hour Nights
539068 ER Avalon CALIFORNIA Nights
539078 MLT Des Moines IOWA 8 Hour Days
539087 Oncology Duluth MINNESOTA 12 Hour Day/Night Rotate
539089 PT Fort Dodge IOWA 8 Hour Days
539093 MLT Des Moines IOWA 12 Hour Days
539095 MLT Des Moines IOWA 8 Hour Days
539105 Telemetry San Diego CALIFORNIA 12 Hour Days
539106 Telemetry San Diego CALIFORNIA 12 Hour Nights
539107 ICU San Diego CALIFORNIA 12 Hour Nights
539110 PCU Concord CALIFORNIA 12 Hour Nights
539111 OR Concord CALIFORNIA 10 Hour Days
539112 Social Worker Concord CALIFORNIA 8 Hour Days
539151 Surgical Tech Fresno CALIFORNIA 10 Hour Days
546342 Cath Lab Lexington KENTUCKY 10 Hour Days
543331 Cath Lab Dubuque IOWA 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.6024 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 600,100 in 1.3869 seconds