Listing all records

Displaying records 301 through 400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
531618 Med Surg Massena NEW YORK 12 Hour Nights
531702 OR Muskegon MICHIGAN 10 Hour Days
531706 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
531763 PT Inman SOUTH CAROLINA Days
531765 L&D Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531766 PICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
531824 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
531848 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
531884 PTA Avoca IOWA Days
531899 CT Tech Marysville OHIO 12 Hour Nights
531958 Social Worker Falls Church VIRGINIA 8 Hour Days
531994 Physician New Lisbon WISCONSIN Days
532051 Long Term Care Nome ALASKA 12 Hour Day/Night Rotate
532052 PT Carrizo Springs TEXAS Days
532057 PT San Ramon CALIFORNIA Days
532081 Physician Stanley WISCONSIN 8 Hour Day/Night Rotate
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
532201 RAD Tech Louisville KENTUCKY 8 Hour Days
532202 RAD Tech Louisville KENTUCKY 8 Hour Days
532256 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
532338 PT Ogden UTAH Days
532355 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
532394 ICU Nashua NEW HAMPSHIRE 12 Hour Nights
532473 ICU Maywood ILLINOIS 12 Hour Nights
532545 CT Tech Melrose Park ILLINOIS 8 Hour Evenings
532546 MRI Tech Mason City IOWA 12 Hour Days
532559 MRI Tech Louisville KENTUCKY 10 Hour Days
532598 PTA Hanford CALIFORNIA Days
532657 Cath Lab Walnut Creek CALIFORNIA 10 Hour Days
532660 CMA Farmington CONNECTICUT 8 Hour Days
532661 MLT Louisville KENTUCKY 8 Hour Evenings
532671 ER Bronx NEW YORK 12 Hour Days
532855 PT St Johnsbury VERMONT Varied
532907 Ultrasound Tech Mason City IOWA 8 Hour Days
532920 Oncology San Angelo TEXAS Days
532921 SLP Edwardsville ILLINOIS 8 Hour Days
532981 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
532997 SLP Everett WASHINGTON 8 Hour Days
533009 Cath Lab Mason City IOWA 8 Hour Days
533010 Cath Lab Mason City IOWA 8 Hour Days
533011 Respiratory Therapist Mason City IOWA 12 Hour Days
533012 Respiratory Therapist Mason City IOWA 12 Hour Days
533013 Respiratory Therapist Mason City IOWA 12 Hour Nights
533014 Respiratory Therapist Mason City IOWA 12 Hour Nights
533177 CT Tech Roseburg OREGON 8 Hour Days
533242 Angiography San Diego CALIFORNIA 8 Hour Days
533260 RAD Tech Des Moines IOWA 10 Hour Days
533274 PT Lawton OKLAHOMA Days
533275 PT Lawton OKLAHOMA Days
533310 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
533322 Long Term Care Lewiston MAINE 12 Hour Nights
533362 CNA Kingsport TENNESSEE 12 Hour Nights
533521 PTA Belton TEXAS Days
533767 PT Bessemer ALABAMA Varied
533910 PT Hayward CALIFORNIA 8 Hour Days
533986 CMA Farmington CONNECTICUT 8 Hour Days
534043 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534044 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534045 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534046 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534047 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534048 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534049 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534052 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534053 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534054 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534055 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534056 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534057 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534058 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534059 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534060 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534061 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534062 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534063 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534093 SLP Freehold NEW JERSEY Days
534108 Echo Oceanside CALIFORNIA 10 Hour Days
534109 RAD Tech Oceanside CALIFORNIA 8 Hour Evenings
534167 Surgical Tech Centerville IOWA 8 Hour Days
534169 Med Surg Oneonta NEW YORK 12 Hour Nights
534238 Med Surg Tele Concord CALIFORNIA 8 Hour Days
534242 Med Surg Tele Des Moines IOWA 12 Hour Nights
534249 Oncology Cleveland OHIO 12 Hour Days
534250 Oncology Cleveland OHIO 12 Hour Nights
534255 Electrophysiology York PENNSYLVANIA 12 Hour Days
534331 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
534500 PTA Jacksonville ILLINOIS 12 Hour Day/Night Rotate
534504 PT Raritan NEW JERSEY Days
534528 Social Worker Johnston PENNSYLVANIA 8 Hour Days
534546 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
534553 Surgical Tech Louisville KENTUCKY 8 Hour Days
534605 Therapy Rehab Springfield MISSOURI Varied
534628 SLP Pomona CALIFORNIA Days
534629 SLP Pomona CALIFORNIA Days
534643 Med Surg New York NEW YORK 12 Hour Nights
534655 CT Tech Syracuse NEW YORK 8 Hour Days
534687 Med Surg Tele Concord CALIFORNIA 8 Hour Nights
534694 Psych Woodsville NEW HAMPSHIRE 12 Hour Day/Night Rotate
534700 Therapy Rehab Lewiston IDAHO 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.695 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 300,100 in 1.1676 seconds