Listing all records

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

ID Job Specialty City State Shift Title
529353 PTA Harwich MASSACHUSETTS Days
529660 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
529430 PTA New Providence NEW JERSEY Days
529510 CT Tech Bethel ALASKA 12 Hour Day/Night Rotate
529591 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
529597 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
534249 Oncology Cleveland OHIO 12 Hour Days
534242 Med Surg Tele Des Moines IOWA 12 Hour Nights
534238 Med Surg Tele Concord CALIFORNIA 8 Hour Days
532921 SLP Edwardsville ILLINOIS 8 Hour Days
531496 CCU Newark NEW JERSEY 12 Hour Days
529926 SLP Grand Junction COLORADO Days
529965 ICU Boise IDAHO 12 Hour Nights
535651 COTA Rock Rapids IOWA Days
529991 Therapy Rehab Los Angeles CALIFORNIA Days
534063 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534058 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534044 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
530228 CVOR Sioux City IOWA 10 Hour Days
530245 Telemetry CHANDLER ARIZONA 12 Hour Nights
534500 PTA Jacksonville ILLINOIS 12 Hour Day/Night Rotate
530378 Med Surg Boise IDAHO Nights
530379 Med Surg Boise IDAHO Nights
530433 Surgical Tech Oceanside CALIFORNIA Varied
534255 Electrophysiology York PENNSYLVANIA 12 Hour Days
534528 Social Worker Johnston PENNSYLVANIA 8 Hour Days
530463 PT Republic WASHINGTON Days
530562 CT Tech Camp Hill PENNSYLVANIA 10 Hour Nights
530585 PTA Yeadon PENNSYLVANIA Days
534643 Med Surg New York NEW YORK 12 Hour Nights
530655 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
535905 Psych Concord CALIFORNIA 8 Hour Nights
534250 Oncology Cleveland OHIO 12 Hour Nights
531334 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534798 MRI Tech Langhorne PENNSYLVANIA 8 Hour Evenings
530820 CT Tech Hudson NEW YORK 12 Hour Nights
530850 Home Health Hayward CALIFORNIA 8 Hour Days
534546 RAD Tech Columbus OHIO 8 Hour Day/Night Rotate
530909 SLP Chesnee SOUTH CAROLINA Days
531138 ICU Ogdensburg NEW YORK 12 Hour Nights
531037 Nuclear Medicine Oceanside CALIFORNIA 8 Hour Days
533310 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
534655 CT Tech Syracuse NEW YORK 8 Hour Days
531188 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
535674 Cath Lab Passaic NEW JERSEY 8 Hour Days
531219 PT Williamstown NEW JERSEY Days
534888 Home Health Lawton OKLAHOMA 8 Hour Days
534706 PT King City CALIFORNIA Days
534629 SLP Pomona CALIFORNIA Days
531388 Cath Lab Louisville KENTUCKY 12 Hour Nights
534941 Med Surg Cape Girardeau MISSOURI Nights
531418 PCU Phoenix ARIZONA 12 Hour Nights
531433 Long Term Care Marion VIRGINIA Nights
531489 PT Ramsey NEW JERSEY Days
531502 Surgical Tech Muskegon MICHIGAN 12 Hour Nights
531507 Therapy Rehab Modesto CALIFORNIA Days
531580 ICU Dubuque IOWA 12 Hour Days
531609 CT Tech Jackson MISSISSIPPI 8 Hour Nights
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
534924 PT thermopolis WYOMING Days
534923 PT thermopolis WYOMING Days
531824 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
534902 Telemetry Boise IDAHO 12 Hour Nights
531884 PTA Avoca IOWA Days
531899 CT Tech Marysville OHIO 12 Hour Nights
535732 Pharmacist New York NEW YORK 8 Hour Nights
531994 Physician New Lisbon WISCONSIN Days
532201 RAD Tech Louisville KENTUCKY 8 Hour 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
534971 Administration Kealakekua HAWAII Days
535030 Surgical Tech Louisville KENTUCKY 12 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
535037 Cath Lab Rockville MARYLAND 10 Hour Days
532855 PT St Johnsbury VERMONT Varied
543938 Med Surg Kingsport TENNESSEE 12 Hour Days
532907 Ultrasound Tech Mason City IOWA 8 Hour Days
532920 Oncology San Angelo TEXAS 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
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.2526 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 300,100 in 1.2416 seconds