Listing all records

Displaying records 1 through 100 out of a total 3,709 records. Next

ID Job Specialty City State Shift Title
548203 Technician Hartford CONNECTICUT 8 Hour Days Tech/Technologist
547594 Urgent Care Corvallis OREGON 8 Hour Days
547875 Urgent Care Saratoga Springs NEW YORK 12 Hour Days
547900 Infection Prevention Specialist Seattle WASHINGTON 12 Hour Day/Night Rotate
548228 EP Tech Evanston ILLINOIS 8 Hour Days Advanced Practice
546609 EP Tech Pinehurst NORTH CAROLINA 10 Hour Days
545613 EP Tech Mission Viejo CALIFORNIA 10 Hour Days
545226 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
547972 Cardiac Telemetry Albany NEW YORK 12 Hour Nights
547945 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
547913 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Days
547910 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
547911 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
546201 Registered Nurse Bristol TENNESSEE 12 Hour Nights
548332 Clinic Chandler ARIZONA 8 Hour Days LPN/Licensed Practical Nurse
547108 Clinic Cleveland OHIO 12 Hour Nights
545251 Clinic Sitka ALASKA Varied
522368 Clinic Bethel ALASKA Days
546830 Clinic Peoria ILLINOIS 8 Hour Days
546813 Clinic Cleveland OHIO 12 Hour Nights
544796 Clinic Fort Defiance ARIZONA 8 Hour Days
547775 Clinic Sitka ALASKA Varied
546246 Clinic Cleveland OHIO 8 Hour Days
547884 Clinic State College PENNSYLVANIA Days
543245 Clinic Newport OREGON 8 Hour Days
542458 Clinic Pahala HAWAII 12 Hour Day/Night Rotate
544389 Lab Tech Syracuse NEW YORK 8 Hour Days
544390 Lab Tech Syracuse NEW YORK 8 Hour Days
536150 Lab Tech King Renton WASHINGTON 8 Hour Days
544481 Lab Tech Syracuse NEW YORK 12 Hour Nights
544441 Therapy Rehab Baltimore MARYLAND Days
543480 Therapy Rehab Athens GEORGIA 8 Hour Days
539873 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
539875 Therapy Rehab Athens GEORGIA 8 Hour Days
535635 Therapy Rehab Stockton CALIFORNIA Days
546832 Therapy Rehab Spring Valley ILLINOIS 12 Hour Day/Night Rotate
519987 Therapy Rehab Big Stone City SOUTH DAKOTA 8 Hour Days
526144 Therapy Rehab Baltimore MARYLAND Days
491571 Therapy Rehab E Lamberton MINNESOTA Days
545565 Therapy Rehab Springfield MISSOURI 8 Hour Days
547100 Therapy Rehab Abbeville SOUTH CAROLINA 8 Hour Days
529991 Therapy Rehab Los Angeles CALIFORNIA Days
526396 Therapy Rehab Cedar Falls IOWA Days
547891 Therapy Rehab Twin Falls IDAHO 10 Hour Days
545888 Therapy Rehab JEROME IDAHO 8 Hour Days
542697 Therapy Rehab Garden City KANSAS 8 Hour Days
542353 Therapy Rehab Inman SOUTH CAROLINA Days
545067 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
507014 Therapy Rehab Ballinger TEXAS Days
527125 Therapy Rehab Shelby MISSISSIPPI Days
546451 Therapy Rehab Macon GEORGIA 8 Hour Nights
534605 Therapy Rehab Springfield MISSOURI Varied
545566 Therapy Rehab Springfield MISSOURI 8 Hour Days
519354 Therapy Rehab Baltimore MARYLAND Days
534700 Therapy Rehab Lewiston IDAHO Days
531507 Therapy Rehab Modesto CALIFORNIA Days
514085 Therapy Rehab Sparks NEVADA Days
514696 Therapy Rehab Spanaway WASHINGTON Days
543633 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
547580 Therapy Rehab Helena MONTANA Days
542822 Therapy Rehab Cheraw SOUTH CAROLINA Days
542691 Lab Supervisor Avalon CALIFORNIA 8 Hour Varied
547581 Pulmonary Johnson City TENNESSEE 12 Hour Days
539617 Pulmonary Johnson City TENNESSEE 12 Hour Nights
529162 Physician Assistant Syracuse NEW YORK 8 Hour Varied
543903 Adult Care Rockaway Park NEW YORK 8 Hour Days
534255 Electrophysiology York PENNSYLVANIA 12 Hour Days
540956 Interventional Therapy Grove City OHIO 8 Hour Days
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
539898 Cardiovascular York PENNSYLVANIA Nights
517474 Ortho Tech Oceanside CALIFORNIA 8 Hour Days
543117 RN Columbus OHIO 10 Hour Days
543116 RN Columbus OHIO 8 Hour Days
543118 RN Columbus OHIO 12 Hour Nights
527971 RN Tuba City ARIZONA 12 Hour Day/Night Rotate
545421 RN Columbus OHIO 12 Hour Nights
538720 RN Columbus OHIO 12 Hour Days
538355 Cardiovascular Technologist Chino CALIFORNIA 8 Hour Days
532660 CMA Farmington CONNECTICUT 8 Hour Days
533986 CMA Farmington CONNECTICUT 8 Hour Days
542595 CMA Farmington CONNECTICUT 8 Hour Days
540043 CMA Farmington CONNECTICUT 8 Hour Days
524667 CT Tech Baker City OREGON 8 Hour Nights
520291 CT Tech Oceanside CALIFORNIA 10 Hour Days
538435 CT Tech Harvard ILLINOIS 8 Hour Evenings
538498 CT Tech Riverhead NEW YORK 8 Hour Nights
540747 CT Tech SANTA CRUZ CALIFORNIA 8 Hour Day/Night Rotate
532545 CT Tech Melrose Park ILLINOIS 8 Hour Evenings
503607 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
540278 CT Tech Concord CALIFORNIA 10 Hour Nights
541077 CT Tech Springfield MASSACHUSETTS 8 Hour Evenings
541650 CT Tech Chewelah WASHINGTON 12 Hour Day/Night Rotate
524703 CT Tech Pontiac MICHIGAN 8 Hour Nights
533177 CT Tech Roseburg OREGON 8 Hour Days
540812 CT Tech Denville NEW JERSEY 8 Hour Days
531899 CT Tech Marysville OHIO 12 Hour Nights
538402 CT Tech Bellefontaine OHIO 12 Hour Nights
540263 CT Tech Concord CALIFORNIA 10 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.588 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 desc limit 0,100 in 1.5571 seconds