Listing all records

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

ID Job Specialty City State Shift Title
545185 CVOR Houston TEXAS 12 Hour Day/Night Rotate
548284 CVOR Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
543006 CVOR Oceanside CALIFORNIA 8 Hour Days
547786 CVOR North Kansas City MISSOURI 8 Hour Days
541765 CVOR Oceanside CALIFORNIA 8 Hour Nights
524675 CVOR Mishawaka INDIANA 12 Hour Days
527053 CVOR Houston TEXAS 8 Hour Days RN/Registered Nurse
544218 CVOR Newark NEW JERSEY 12 Hour Days
547425 CVOR Kingsport TENNESSEE 8 Hour Days
530228 CVOR Sioux City IOWA 10 Hour Days
547672 CVOR Falls Church VIRGINIA 12 Hour Days
547326 CVOR Ann Arbor MICHIGAN 10 Hour Days
546858 CVOR Annapolis MARYLAND 12 Hour Days
547700 CVOR Sun City ARIZONA 10 Hour Days
547006 CVOR Charlottesville VIRGINIA 10 Hour Days
548285 CVOR Sacramento CALIFORNIA 8 Hour Days RN/Registered Nurse
546474 CVOR Corvallis OREGON 12 Hour Day/Night Rotate
536346 CVOR Lumberton NORTH CAROLINA 8 Hour Days RN/Registered Nurse
536509 CVOR Fresno CALIFORNIA 12 Hour Days
536510 CVOR Fresno CALIFORNIA 12 Hour Days
546827 CVOR Parkersburg WEST VIRGINIA 12 Hour Days
548054 CVOR STOCKTON CALIFORNIA 12 Hour Days RN/Registered Nurse
546355 CVOR Lakewood CALIFORNIA 8 Hour Days
546357 CVOR Lakewood CALIFORNIA 8 Hour Days
546356 CVOR Lakewood CALIFORNIA 8 Hour Days
542263 CVOR Charlottesville VIRGINIA 10 Hour Days
543243 CVOR Falls Church VIRGINIA 12 Hour Days RN/Registered Nurse
548344 CVOR Fresno CALIFORNIA 12 Hour Days RN/Registered Nurse
544245 CVOR Reno NEVADA 12 Hour Day/Night Rotate
548350 CVOR Falls Church VIRGINIA 12 Hour Day/Night Rotate RN/Registered Nurse
547674 CVOR Falls Church VIRGINIA 12 Hour Days
542262 CVOR Charlottesville VIRGINIA 10 Hour Days
541473 CVOR Spokane WASHINGTON 10 Hour Days
541482 CVOR Spokane WASHINGTON 10 Hour Days
541483 CVOR Spokane WASHINGTON 10 Hour Days
541486 CVOR Spokane WASHINGTON 10 Hour Days
545229 Telemetry Cleveland OHIO 12 Hour Nights
546875 Telemetry PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
541891 Telemetry Farmington CONNECTICUT 12 Hour Nights
548038 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Nights
544525 Telemetry Wailuku HAWAII 12 Hour Nights
524989 Telemetry Maywood ILLINOIS 12 Hour Nights
527493 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
548217 Telemetry New York NEW YORK 12 Hour Days RN/Registered Nurse
543215 Telemetry Cleveland OHIO 12 Hour Nights
526356 Telemetry Boise IDAHO 12 Hour Nights
543607 Telemetry Nampa IDAHO 12 Hour Nights
543599 Telemetry Twin Falls IDAHO 12 Hour Nights
543613 Telemetry Boise IDAHO 12 Hour Nights
546732 Telemetry Everett WASHINGTON 12 Hour Nights
542653 Telemetry Charleston SOUTH CAROLINA 12 Hour Nights
544116 Telemetry Cleveland OHIO 12 Hour Nights
548115 Telemetry Brattleboro VERMONT 12 Hour Nights RN/Registered Nurse
546859 Telemetry Everett WASHINGTON 12 Hour Nights
548145 Telemetry Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
545503 Telemetry Boise IDAHO 12 Hour Nights
546730 Telemetry Everett WASHINGTON 12 Hour Nights
544031 Telemetry Portland OREGON 12 Hour Nights
546432 Telemetry Farmington CONNECTICUT 12 Hour Days
534901 Telemetry Boise IDAHO 12 Hour Nights
534902 Telemetry Boise IDAHO 12 Hour Nights
534903 Telemetry Boise IDAHO 12 Hour Nights
534904 Telemetry Boise IDAHO 12 Hour Nights
543309 Telemetry Farmington CONNECTICUT 12 Hour Nights
544052 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
546727 Telemetry Everett WASHINGTON 12 Hour Nights
546735 Telemetry Santa Monica CALIFORNIA 12 Hour Nights
545165 Telemetry Cleveland OHIO 12 Hour Nights
539105 Telemetry San Diego CALIFORNIA 12 Hour Days
539106 Telemetry San Diego CALIFORNIA 12 Hour Nights
546742 Telemetry Charleston WEST VIRGINIA 12 Hour Nights
546693 Telemetry Oceanside CALIFORNIA 12 Hour Evenings
543038 Telemetry San Diego CALIFORNIA 12 Hour Day/Night Rotate
539751 Telemetry Boise IDAHO 12 Hour Nights
545227 Telemetry Cleveland OHIO 12 Hour Nights
545228 Telemetry Cleveland OHIO 12 Hour Nights
545231 Telemetry Cleveland OHIO 12 Hour Nights
540003 Telemetry Farmington CONNECTICUT 12 Hour Days
548114 Telemetry MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
540011 Telemetry Farmington CONNECTICUT 12 Hour Nights
543465 Telemetry Wailuku HAWAII 12 Hour Nights
543214 Telemetry Cleveland OHIO 12 Hour Nights
540040 Telemetry Farmington CONNECTICUT 12 Hour Days
548403 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
542211 Telemetry CHANDLER ARIZONA 12 Hour Nights
540063 Telemetry Farmington CONNECTICUT 12 Hour Nights
540065 Telemetry Farmington CONNECTICUT 12 Hour Days
546729 Telemetry Everett WASHINGTON 12 Hour Nights
545502 Telemetry Boise IDAHO 12 Hour Nights
540107 Telemetry Concord CALIFORNIA 12 Hour Nights
540113 Telemetry Concord CALIFORNIA 12 Hour Nights
545626 Telemetry Prescott Valley ARIZONA 12 Hour Day/Night Rotate
545625 Telemetry Prescott Valley ARIZONA 12 Hour Nights
544313 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
540150 Telemetry Concord CALIFORNIA 12 Hour Days
540151 Telemetry Concord CALIFORNIA 12 Hour Nights
540159 Telemetry Concord CALIFORNIA 12 Hour Nights
540226 Telemetry Concord CALIFORNIA 12 Hour Days
546898 Telemetry Cleveland OHIO 12 Hour Nights
546733 Telemetry Everett WASHINGTON 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.5453 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 1200,100 in 1.4121 seconds