Listing all records

Displaying records 1201 through 1300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
541610 PT Hesperia CALIFORNIA 8 Hour Days
541613 Ultrasound Tech Portland OREGON 8 Hour Days
541620 Med Surg Spokane WASHINGTON 12 Hour Nights
541627 PT Butte MONTANA Days
541634 NICU Greenbrae CALIFORNIA 12 Hour Days
541635 Case Manager Woonsocket RHODE ISLAND 8 Hour Days
541642 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
541643 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
541647 Med Surg Colville WASHINGTON 12 Hour Nights
541649 Med Surg Chewelah WASHINGTON 12 Hour Nights
541650 CT Tech Chewelah WASHINGTON 12 Hour Day/Night Rotate
541652 PT SANTA ROSA CALIFORNIA 8 Hour Days
541654 Surgical Tech SANTA ROSA CALIFORNIA 8 Hour Days
541657 Med Surg Walla Walla WASHINGTON 12 Hour Nights
541700 L&D Eureka CALIFORNIA 12 Hour Nights
541705 PT Eureka CALIFORNIA 8 Hour Days
541730 First Assist Brooklyn NEW YORK 8 Hour Days
541734 Med Surg Brooklyn NEW YORK 12 Hour Evenings
541736 OR Louisville KENTUCKY 10 Hour Days
541750 PT Union City CALIFORNIA 8 Hour Days
541755 Med Surg Tele Pittsfield MASSACHUSETTS 12 Hour Nights
541765 CVOR Oceanside CALIFORNIA 8 Hour Nights
541769 Oncology Pueblo COLORADO 12 Hour Days
541779 Telemetry Farmington CONNECTICUT 12 Hour Days
541782 ICU Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
541785 CNA The Dalles OREGON Nights
541786 ICU The Dalles OREGON 12 Hour Day/Night Rotate
541792 ER Newark NEW JERSEY 12 Hour Day/Night Rotate
541798 L&D Newton IOWA 12 Hour Nights
541809 Med Surg Oneonta NEW YORK 12 Hour Nights
541810 Med Surg Oneonta NEW YORK 12 Hour Nights
541829 RAD Tech CHANDLER ARIZONA 12 Hour Day/Night Rotate
541840 PT SANTA MARIA CALIFORNIA 8 Hour Days
541844 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
541845 NICU Walnut Creek CALIFORNIA 12 Hour Nights
541846 PCU Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
541847 Psych Peoria ILLINOIS 8 Hour Days RN/Registered Nurse
541860 PT Lovington NEW MEXICO 8 Hour Days
541886 Rehab Chesterfield MONTANA 12 Hour Days
541891 Telemetry Farmington CONNECTICUT 12 Hour Nights
541929 Management Corvallis OREGON 12 Hour Day/Night Rotate
541949 Med Surg Boise IDAHO 12 Hour Nights
541958 CVICU Spokane WASHINGTON 12 Hour Nights
541964 Cath Lab Whittier CALIFORNIA 8 Hour Days
541984 Med Surg New York NEW YORK Days
542007 Med Surg Hot Springs ARKANSAS 12 Hour Nights
542008 CVICU Little Rock ARKANSAS 12 Hour Days
542029 Med Surg Bronx NEW YORK 10 Hour Days
542039 OR San Angelo TEXAS Varied
542040 Physician PHiladelphia PENNSYLVANIA 8 Hour Days
542041 ICU Ann Arbor MICHIGAN 12 Hour Nights
542049 Surgical Tech CVOR York PENNSYLVANIA 12 Hour Days
542063 ICU Wailuku HAWAII 12 Hour Nights
542070 Med Surg Tele Wailuku HAWAII 12 Hour Varied
542071 Med Surg Tele Wailuku HAWAII 12 Hour Nights
542081 Med Surg Tele Madison WISCONSIN 12 Hour Day/Night Rotate
542084 RAD Tech Farmington CONNECTICUT 8 Hour Days
542085 PT Oneonta NEW YORK 8 Hour Days
542103 Medical Assistant Portland OREGON 12 Hour Nights
542104 Medical Assistant Portland OREGON 12 Hour Nights
542114 Med Surg Tele Syracuse NEW YORK Nights
542129 RAD Tech Kapaau HAWAII Varied
542130 Echo Technologist San Angelo TEXAS Varied
542131 Echo Great Falls MONTANA 8 Hour Days
542137 Med Surg Brooklyn NEW YORK 12 Hour Nights
542138 Med Surg Brooklyn NEW YORK 12 Hour Nights
542156 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
542160 CT Tech Lynwood CALIFORNIA 12 Hour Day/Night Rotate
542171 Angiography Hilo HAWAII 12 Hour Day/Night Rotate
542176 ICU Boise IDAHO 12 Hour Nights
542177 ICU Boise IDAHO 12 Hour Nights
542211 Telemetry CHANDLER ARIZONA 12 Hour Nights
542242 Oncology Charlottesville VIRGINIA 12 Hour Nights
542243 Oncology Charlottesville VIRGINIA 12 Hour Nights
542262 CVOR Charlottesville VIRGINIA 10 Hour Days
542263 CVOR Charlottesville VIRGINIA 10 Hour Days
542272 Med Surg Excelsior Springs MISSOURI 12 Hour Nights
542273 Med Surg Excelsior Springs MISSOURI 12 Hour Nights
542299 ER Laconia NEW HAMPSHIRE Nights
542321 CT Tech Boise IDAHO 10 Hour Days
542340 Home Health Santa Fe NEW MEXICO 8 Hour Days RN/Registered Nurse
542345 MLT Westerville OHIO 8 Hour Nights
542347 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
542353 Therapy Rehab Inman SOUTH CAROLINA Days
542364 OR Spokane WASHINGTON 12 Hour Days
542375 Med Surg Spokane WASHINGTON 12 Hour Nights
542380 PT SANTA ROSA CALIFORNIA 8 Hour Days
542387 Med Surg Des Moines IOWA 12 Hour Days
542390 Pediatric ER New York NEW YORK 12 Hour Nights
542401 Surgical Tech Leavenworth KANSAS 8 Hour Days
542402 Sterile Processing Tech Leavenworth KANSAS 8 Hour Days
542423 OR IOWA CITY IOWA 10 Hour Days
542424 PT Norwalk IOWA Days
542427 PT Lakeport CALIFORNIA Varied
542430 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
542442 Med Surg Oneonta NEW YORK 12 Hour Days
542449 PTA Lakeport CALIFORNIA 8 Hour Days
542451 ER Rockford ILLINOIS 12 Hour Nights
542458 Clinic Pahala HAWAII 12 Hour Day/Night Rotate
542462 SLP Williamstown NEW JERSEY 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.4184 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.id asc limit 1200,100 in 1.1362 seconds