Listing all records

Displaying records 701 through 800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547911 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
544220 MICU Newark NEW JERSEY 8 Hour Nights
539754 L&D Wailuku HAWAII 8 Hour Nights
544409 CT Tech Springfield VERMONT 8 Hour Nights
544514 CT Tech Vernon Rockville CONNECTICUT 8 Hour Nights
444999 PACU Bangor MAINE 12 Hour Days
540145 L&D Walnut Creek CALIFORNIA 12 Hour Days
545617 Med Surg Gainesville FLORIDA 12 Hour Days
545424 Med Surg Waterbury CONNECTICUT 12 Hour Days
540309 L&D Walnut Creek CALIFORNIA 12 Hour Days
545169 Acute Care Bronx NEW YORK 12 Hour Days
545526 Med Surg Memphis TENNESSEE 12 Hour Days
540144 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545499 Respiratory Therapist Des Moines IOWA 12 Hour Days
545191 Surgical Tech New Albany OHIO 12 Hour Days
545423 Med Surg Waterbury CONNECTICUT 12 Hour Days
540180 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
545501 Med Surg Tele Des Moines IOWA 12 Hour Days
545285 OR El Paso TEXAS 12 Hour Days
517382 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
545173 Med Surg Brooklyn NEW YORK 12 Hour Days
540160 Med Surg Concord CALIFORNIA 12 Hour Days
545392 CT Tech Anchorage ALASKA 12 Hour Days
545425 L&D Mishawaka INDIANA 12 Hour Days
545500 Med Surg Tele Des Moines IOWA 12 Hour Days
545014 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Days
541886 Rehab Chesterfield MONTANA 12 Hour Days
541846 PCU Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
544735 Surgical Tech MERCED CALIFORNIA 12 Hour Days
540248 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
544743 Med Surg Spokane WASHINGTON 12 Hour Days
524588 ICU - Per Diem Oceanside CALIFORNIA 12 Hour Days RN/Registered Nurse
524675 CVOR Mishawaka INDIANA 12 Hour Days
540247 L&D Walnut Creek CALIFORNIA 12 Hour Days
540249 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
525077 LPN/LVN Mason City IOWA 12 Hour Days
525081 MRI Tech Grove City OHIO 12 Hour Days
525187 CVICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
545632 Med Surg Gainesville FLORIDA 12 Hour Days
545332 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
527493 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
525604 RAD Tech Richmond VIRGINIA 12 Hour Days Radiology Techs/Technologists
545284 OR El Paso TEXAS 12 Hour Days
525839 RAD Tech Wilmington NORTH CAROLINA 12 Hour Days Radiology Techs/Technologists
540254 NICU Walnut Creek CALIFORNIA 12 Hour Days
527684 PICU New York NEW YORK 12 Hour Days RN/Registered Nurse
545498 Respiratory Therapist Des Moines IOWA 12 Hour Days
526101 ICU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
526102 ICU New York NEW YORK 12 Hour Days RN/Registered Nurse
540182 Med Surg Tele Concord CALIFORNIA 12 Hour Days
526268 Interventional Radiology Tech Fresno CALIFORNIA 12 Hour Days
540181 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540179 Case Manager Concord CALIFORNIA 12 Hour Days
545634 Med Surg Gainesville FLORIDA 12 Hour Days
540256 ER Concord CALIFORNIA 12 Hour Days
540268 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540142 Intermediate Care Concord CALIFORNIA 12 Hour Days
544742 Med Surg Spokane WASHINGTON 12 Hour Days
540246 ICU Walnut Creek CALIFORNIA 12 Hour Days
540150 Telemetry Concord CALIFORNIA 12 Hour Days
540149 Med Surg Tele Concord CALIFORNIA 12 Hour Days
544890 ER Concord CALIFORNIA 12 Hour Days
544895 RAD Tech Lynwood CALIFORNIA 12 Hour Days
544955 Telemetry Twin Falls IDAHO 12 Hour Days
544944 PCU Johnson City TENNESSEE 12 Hour Days
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
545084 RAD Tech San Diego CALIFORNIA 12 Hour Days
534058 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534059 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534062 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534063 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
545098 Long Term Care Portland OREGON 12 Hour Days
545179 Med Surg Brooklyn NEW YORK 12 Hour Days
534249 Oncology Cleveland OHIO 12 Hour Days
534255 Electrophysiology York PENNSYLVANIA 12 Hour Days
545279 Cardiovascular Dubuque IOWA 12 Hour Days
540313 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540156 ER Concord CALIFORNIA 12 Hour Days
540161 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540314 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Days
540162 PACU Walnut Creek CALIFORNIA 12 Hour Days
534799 Sonographer Mason City IOWA 12 Hour Days
545405 Surgical Tech CVOR Weston FLORIDA 12 Hour Days
545413 MLT Ely NEVADA 12 Hour Days
540169 L&D Walnut Creek CALIFORNIA 12 Hour Days
540198 ER Concord CALIFORNIA 12 Hour Days
535030 Surgical Tech Louisville KENTUCKY 12 Hour Days
540166 NICU Walnut Creek CALIFORNIA 12 Hour Days
545426 NICU Mishawaka INDIANA 12 Hour Days
535099 Radiology Bronx NEW YORK 12 Hour Days
535179 CT Tech Columbus OHIO 12 Hour Days
540176 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
545628 Med Surg Gainesville FLORIDA 12 Hour Days
535418 Respiratory Therapist Mason City IOWA 12 Hour Days
540183 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540039 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540244 ICU Concord CALIFORNIA 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.5632 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 700,100 in 1.3998 seconds