Listing all records

Displaying records 201 through 300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
524265 PTA San Ramon CALIFORNIA Days
532545 CT Tech Melrose Park ILLINOIS 8 Hour Evenings
524484 Cath Lab Louisville KENTUCKY 12 Hour Nights
532256 Med Surg Cincinnati OHIO 12 Hour Day/Night Rotate
524667 CT Tech Baker City OREGON 8 Hour Nights
524675 CVOR Mishawaka INDIANA 12 Hour Days
524678 Cath Lab Dubuque IOWA 10 Hour Days
524703 CT Tech Pontiac MICHIGAN 8 Hour Nights
524748 Surgical Tech Boise IDAHO 10 Hour Days
524930 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524932 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524933 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524972 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
524989 Telemetry Maywood ILLINOIS 12 Hour Nights
524992 Med Surg Boise IDAHO Nights
525066 PT Mason City IOWA 8 Hour Days
525077 LPN/LVN Mason City IOWA 12 Hour Days
525078 LPN/LVN Mason City IOWA 12 Hour Nights
525081 MRI Tech Grove City OHIO 12 Hour Days
532661 MLT Louisville KENTUCKY 8 Hour Evenings
525235 CT Tech Oceanside CALIFORNIA 10 Hour Days
525386 Vascular Ultrasound Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
532660 CMA Farmington CONNECTICUT 8 Hour Days
529965 ICU Boise IDAHO 12 Hour Nights
529926 SLP Grand Junction COLORADO Days
531496 CCU Newark NEW JERSEY 12 Hour Days
525646 Med Surg Boise IDAHO 12 Hour Nights
525662 Nurse Practicioner Syracuse NEW YORK 12 Hour Varied
525673 Cardiology Louisville KENTUCKY 8 Hour Days
531489 PT Ramsey NEW JERSEY Days
529991 Therapy Rehab Los Angeles CALIFORNIA Days
533910 PT Hayward CALIFORNIA 8 Hour Days
530228 CVOR Sioux City IOWA 10 Hour Days
534045 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
532921 SLP Edwardsville ILLINOIS 8 Hour Days
532920 Oncology San Angelo TEXAS Days
534046 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534047 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
532907 Ultrasound Tech Mason City IOWA 8 Hour Days
532202 RAD Tech Louisville KENTUCKY 8 Hour Days
533009 Cath Lab Mason City IOWA 8 Hour Days
532997 SLP Everett WASHINGTON 8 Hour Days
532981 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
526144 Therapy Rehab Baltimore MARYLAND Days
526268 Interventional Radiology Tech Fresno CALIFORNIA 12 Hour Days
527553 Cath Lab Louisville KENTUCKY 8 Hour Days
526356 Telemetry Boise IDAHO 12 Hour Nights
534049 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
526368 COTA Colfax WISCONSIN Days
526396 Therapy Rehab Cedar Falls IOWA Days
526505 PT Plains MONTANA Varied
533011 Respiratory Therapist Mason City IOWA 12 Hour Days
547698 ICU Saratoga Springs NEW YORK 12 Hour Nights
526586 PT Lewiston IDAHO Days
526714 CT Tech Hartford CONNECTICUT 8 Hour Nights
526794 CT Tech Silver Spring MARYLAND 10 Hour Nights
527226 ER Everett WASHINGTON 12 Hour Nights
530433 Surgical Tech Oceanside CALIFORNIA Varied
534643 Med Surg New York NEW YORK 12 Hour Nights
527092 PT Boardman OHIO Days
527125 Therapy Rehab Shelby MISSISSIPPI Days
527179 RAD Tech Boise IDAHO 12 Hour Days
530850 Home Health Hayward CALIFORNIA 8 Hour Days
527222 PT Freemont CALIFORNIA Days
527223 PTA Hayward CALIFORNIA Days
527231 PT North Kingstown RHODE ISLAND Days
527324 PT Palm Springs CALIFORNIA Days
527338 RAD Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
527487 PTA North Providence RHODE ISLAND Days
527559 RAD Tech San Diego CALIFORNIA 12 Hour Nights
530820 CT Tech Hudson NEW YORK 12 Hour Nights
527593 PT Pinehurst NORTH CAROLINA 8 Hour Days
527624 Scrub Tech Oceanside CALIFORNIA 10 Hour Days
527625 Sterile Processing Technician Oceanside CALIFORNIA 10 Hour Nights
527789 RAD Tech Oceanside CALIFORNIA 8 Hour Days
527927 PT Mandan NORTH DAKOTA 8 Hour Day/Night Rotate
531334 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
527971 RN Tuba City ARIZONA 12 Hour Day/Night Rotate
533260 RAD Tech Des Moines IOWA 10 Hour Days
533177 CT Tech Roseburg OREGON 8 Hour Days
528005 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
530585 PTA Yeadon PENNSYLVANIA Days
528026 Med Surg Mason City IOWA 12 Hour Nights
528028 Med Surg Mason City IOWA 12 Hour Nights
530379 Med Surg Boise IDAHO Nights
530909 SLP Chesnee SOUTH CAROLINA Days
528270 Surgical Tech Louisville KENTUCKY 12 Hour Days
528446 PTA Killeen TEXAS Days
528477 Respiratory Therapist Mason City IOWA 12 Hour Days
528482 SLP Fresno CALIFORNIA Days
528504 SLP Juneau ALASKA Days
530378 Med Surg Boise IDAHO Nights
528610 OR Oceanside CALIFORNIA 10 Hour Days
528615 SLP Salisbury NORTH CAROLINA Days
528766 PT Sparks NEVADA Days
529033 PT San Ramon CALIFORNIA Days
529162 Physician Assistant Syracuse NEW YORK 8 Hour Varied
529165 Surgical Tech CVOR Cincinnati OHIO 10 Hour Days
529209 Surgical Tech Passaic NEW JERSEY 12 Hour Days
529609 PT Low Moor VIRGINIA 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.2268 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 200,100 in 1.3162 seconds