Listing all records

Displaying records 2101 through 2200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548276 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
525187 CVICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548080 CVICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
538454 CVICU Little Rock ARKANSAS 12 Hour Nights
548149 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548232 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
546984 CVICU Albany NEW YORK 12 Hour Nights
548135 CVICU Stockton CALIFORNIA 12 Hour Nights RN/Registered Nurse
542008 CVICU Little Rock ARKANSAS 12 Hour Days
548295 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548360 CVICU Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
548396 CVICU SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
548386 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
545292 CVICU Memphis TENNESSEE 12 Hour Nights
545299 CVICU Little Rock ARKANSAS 12 Hour Nights
546627 CVICU Madison WISCONSIN 8 Hour Day/Night Rotate
444999 PACU Bangor MAINE 12 Hour Days
546256 PACU Hilo HAWAII 12 Hour Day/Night Rotate
516790 PACU Everett WASHINGTON 12 Hour Days
548257 PACU Lynwood CALIFORNIA 12 Hour Days RN/Registered Nurse
548258 PACU Lynwood CALIFORNIA 12 Hour Days RN/Registered Nurse
548061 PACU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
548017 PACU Chico CALIFORNIA 10 Hour Days
540004 PACU Walnut Creek CALIFORNIA 12 Hour Days
540059 PACU Concord CALIFORNIA 10 Hour Days
540071 PACU Concord CALIFORNIA 12 Hour Days
540162 PACU Walnut Creek CALIFORNIA 12 Hour Days
540171 PACU Walnut Creek CALIFORNIA 12 Hour Nights
540206 PACU Concord CALIFORNIA 10 Hour Days
540301 PACU Concord CALIFORNIA 10 Hour Days
540317 PACU Walnut Creek CALIFORNIA 12 Hour Nights
540344 PACU Concord CALIFORNIA 12 Hour Days
547942 PACU Sterling ILLINOIS 8 Hour Days
543371 PACU Fresno CALIFORNIA 12 Hour Days
543373 PACU Fresno CALIFORNIA 12 Hour Days
543374 PACU Fresno CALIFORNIA 12 Hour Days
543592 PACU Nashua NEW HAMPSHIRE 10 Hour Days
543752 PACU Victorville CALIFORNIA 8 Hour Days
543807 PACU Albuquerque NEW MEXICO 12 Hour Nights
544158 PACU Cleveland OHIO 12 Hour Nights
545303 PACU Farmington CONNECTICUT 10 Hour Days
546681 PACU Hot Springs ARKANSAS 8 Hour Days
545684 PACU Gainesville FLORIDA 12 Hour Days
484788 PTA Merced CALIFORNIA Days
501006 PTA Freehold NEW JERSEY Days
505339 PTA San Jose CALIFORNIA Days
519986 PTA Big Stone City SOUTH DAKOTA Varied
523531 PTA Oakland NEW JERSEY Days
523666 PTA Freemont CALIFORNIA Days
524151 PTA Ramsey NEW JERSEY Days
524265 PTA San Ramon CALIFORNIA Days
527223 PTA Hayward CALIFORNIA Days
527487 PTA North Providence RHODE ISLAND Days
528446 PTA Killeen TEXAS Days
529353 PTA Harwich MASSACHUSETTS Days
529430 PTA New Providence NEW JERSEY Days
530585 PTA Yeadon PENNSYLVANIA Days
531884 PTA Avoca IOWA Days
532598 PTA Hanford CALIFORNIA Days
533521 PTA Belton TEXAS Days
534500 PTA Jacksonville ILLINOIS 12 Hour Day/Night Rotate
535270 PTA Modesto CALIFORNIA Days
535271 PTA Modesto CALIFORNIA Days
535889 PTA Essex MARYLAND Days
546110 PTA Clovis NEW MEXICO 8 Hour Days
539734 PTA Avoca IOWA Days
546221 PTA Crescent City CALIFORNIA 8 Hour Day/Night Rotate
547883 PTA Daly City CALIFORNIA Days
542449 PTA Lakeport CALIFORNIA 8 Hour Days
543087 PTA Ukiah CALIFORNIA 8 Hour Days
548027 PTA Escondido CALIFORNIA 8 Hour Days
546767 PTA Charlton MASSACHUSETTS Days
546867 PTA Wilton CONNECTICUT Varied
547683 OT Athens GEORGIA 8 Hour Days
547607 OT Crescent City CALIFORNIA 8 Hour Days
547057 OT Sacramento CALIFORNIA 8 Hour Days
547608 OT Crescent City CALIFORNIA 8 Hour Days
547609 OT Garden City KANSAS 8 Hour Days
546807 OT Saranac Lake NEW YORK 8 Hour Days
546862 OT Syracuse NEW YORK 8 Hour Days
474328 PT North Manchester INDIANA Days
541860 PT Lovington NEW MEXICO 8 Hour Days
548029 PT Goldendale WASHINGTON Days
526505 PT Plains MONTANA Varied
526586 PT Lewiston IDAHO Days
534923 PT thermopolis WYOMING Days
534999 PT Kerrville TEXAS Days
535174 PT San Francisco CALIFORNIA 8 Hour Days
535556 PT Athens GEORGIA 8 Hour Days
535640 PT NORTHRIDGE CALIFORNIA 8 Hour Days
546346 PT Nogales ARIZONA 8 Hour Days
547806 PT Mammoth Lakes CALIFORNIA Days
546035 PT Burbank CALIFORNIA 8 Hour Days
545111 PT Salem OREGON Days
545112 PT Salem OREGON Days
546423 PT Hayward CALIFORNIA 8 Hour Days
548026 PT Escondido CALIFORNIA 8 Hour Days
545317 PT SANTA ROSA CALIFORNIA 8 Hour Days
545331 PT Sumter SOUTH CAROLINA Days
545420 PT REDWOOD CITY CALIFORNIA 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 2.2461 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 2100,100 in 1.5706 seconds