Listing all records

Displaying records 3601 through 3700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547436 CT Tech Olympia WASHINGTON 12 Hour Nights
547470 CT Tech Hays KANSAS 8 Hour Nights
547479 CT Tech Arlington VIRGINIA 10 Hour Days
547482 CT Tech Rockingham NORTH CAROLINA 12 Hour Nights
547489 CT Tech Albuquerque NEW MEXICO 12 Hour Day/Night Rotate
547518 CT Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
547522 CT Tech Cook MINNESOTA 12 Hour Day/Night Rotate
547556 CT Tech Ritzville WASHINGTON 8 Hour Days
547557 CT Tech Akron OHIO 12 Hour Days
547633 CT Tech Titusville FLORIDA 12 Hour Nights
547744 CT Tech Moses Lake WASHINGTON 12 Hour Nights
547761 CT Tech Glendale ARIZONA 8 Hour Days
547763 CT Tech Glendale ARIZONA 10 Hour Nights
547764 CT Tech Phoenix ARIZONA 10 Hour Days
547780 CT Tech Sunnyvale TEXAS 12 Hour Nights
547781 CT Tech Goodyear ARIZONA 10 Hour Nights
547844 CT Tech Des Moines IOWA 10 Hour Days
547886 CT Tech McCall IDAHO 12 Hour Nights
547887 CT Tech McCall IDAHO Days
547890 CT Tech Knoxville TENNESSEE 12 Hour Nights
547922 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
547936 CT Tech Morgantown WEST VIRGINIA 8 Hour Evenings
547974 CT Tech TOWNSHEND VERMONT Varied
548010 CT Tech Fort Bragg CALIFORNIA 12 Hour Day/Night Rotate
548032 CT Tech Columbus OHIO 10 Hour Nights
532660 CMA Farmington CONNECTICUT 8 Hour Days
533986 CMA Farmington CONNECTICUT 8 Hour Days
540043 CMA Farmington CONNECTICUT 8 Hour Days
542595 CMA Farmington CONNECTICUT 8 Hour Days
538355 Cardiovascular Technologist Chino CALIFORNIA 8 Hour Days
527971 RN Tuba City ARIZONA 12 Hour Day/Night Rotate
538720 RN Columbus OHIO 12 Hour Days
543116 RN Columbus OHIO 8 Hour Days
543117 RN Columbus OHIO 10 Hour Days
543118 RN Columbus OHIO 12 Hour Nights
545421 RN Columbus OHIO 12 Hour Nights
517474 Ortho Tech Oceanside CALIFORNIA 8 Hour Days
539898 Cardiovascular York PENNSYLVANIA Nights
545279 Cardiovascular Dubuque IOWA 12 Hour Days
545622 Cardiovascular Prescott ARIZONA 12 Hour Day/Night Rotate
547117 Cardiovascular York PENNSYLVANIA 12 Hour Day/Night Rotate
540956 Interventional Therapy Grove City OHIO 8 Hour Days
534255 Electrophysiology York PENNSYLVANIA 12 Hour Days
543903 Adult Care Rockaway Park NEW YORK 8 Hour Days
529162 Physician Assistant Syracuse NEW YORK 8 Hour Varied
539617 Pulmonary Johnson City TENNESSEE 12 Hour Nights
547581 Pulmonary Johnson City TENNESSEE 12 Hour Days
542691 Lab Supervisor Avalon CALIFORNIA 8 Hour Varied
491571 Therapy Rehab E Lamberton MINNESOTA Days
507014 Therapy Rehab Ballinger TEXAS Days
514085 Therapy Rehab Sparks NEVADA Days
514696 Therapy Rehab Spanaway WASHINGTON Days
519354 Therapy Rehab Baltimore MARYLAND Days
519987 Therapy Rehab Big Stone City SOUTH DAKOTA 8 Hour Days
526144 Therapy Rehab Baltimore MARYLAND Days
526396 Therapy Rehab Cedar Falls IOWA Days
527125 Therapy Rehab Shelby MISSISSIPPI Days
529991 Therapy Rehab Los Angeles CALIFORNIA Days
531507 Therapy Rehab Modesto CALIFORNIA Days
534605 Therapy Rehab Springfield MISSOURI Varied
534700 Therapy Rehab Lewiston IDAHO Days
535635 Therapy Rehab Stockton CALIFORNIA Days
539873 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
539875 Therapy Rehab Athens GEORGIA 8 Hour Days
542353 Therapy Rehab Inman SOUTH CAROLINA Days
542697 Therapy Rehab Garden City KANSAS 8 Hour Days
542822 Therapy Rehab Cheraw SOUTH CAROLINA Days
543480 Therapy Rehab Athens GEORGIA 8 Hour Days
543633 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
544441 Therapy Rehab Baltimore MARYLAND Days
545067 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
545565 Therapy Rehab Springfield MISSOURI 8 Hour Days
545566 Therapy Rehab Springfield MISSOURI 8 Hour Days
545888 Therapy Rehab JEROME IDAHO 8 Hour Days
546451 Therapy Rehab Macon GEORGIA 8 Hour Nights
546832 Therapy Rehab Spring Valley ILLINOIS 12 Hour Day/Night Rotate
547100 Therapy Rehab Abbeville SOUTH CAROLINA 8 Hour Days
547580 Therapy Rehab Helena MONTANA Days
547891 Therapy Rehab Twin Falls IDAHO 10 Hour Days
536150 Lab Tech King Renton WASHINGTON 8 Hour Days
544389 Lab Tech Syracuse NEW YORK 8 Hour Days
544390 Lab Tech Syracuse NEW YORK 8 Hour Days
544481 Lab Tech Syracuse NEW YORK 12 Hour Nights
522368 Clinic Bethel ALASKA Days
542458 Clinic Pahala HAWAII 12 Hour Day/Night Rotate
543245 Clinic Newport OREGON 8 Hour Days
544796 Clinic Fort Defiance ARIZONA 8 Hour Days
545251 Clinic Sitka ALASKA Varied
546246 Clinic Cleveland OHIO 8 Hour Days
546813 Clinic Cleveland OHIO 12 Hour Nights
546830 Clinic Peoria ILLINOIS 8 Hour Days
547108 Clinic Cleveland OHIO 12 Hour Nights
547775 Clinic Sitka ALASKA Varied
547884 Clinic State College PENNSYLVANIA Days
548332 Clinic Chandler ARIZONA 8 Hour Days LPN/Licensed Practical Nurse
546201 Registered Nurse Bristol TENNESSEE 12 Hour Nights
547910 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
547911 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
547913 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Days
547945 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
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.9497 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.specialty asc limit 3600,100 in 1.5549 seconds