Listing all records

Displaying records 501 through 600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548207 ER Mission Hills CALIFORNIA 12 Hour Evenings RN/Registered Nurse
545079 ER Pueblo COLORADO 12 Hour Day/Night Rotate
540223 ER Concord CALIFORNIA 12 Hour Days
548072 ER Lansing MICHIGAN 12 Hour Days RN/Registered Nurse
546913 ER Des Moines IOWA 12 Hour Days
547480 ER Manchester CONNECTICUT 12 Hour Nights
540000 ER Walnut Creek CALIFORNIA 12 Hour Nights
532671 ER Bronx NEW YORK 12 Hour Days
548409 ER Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
542156 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
548138 ER Truth or Consequences NEW MEXICO 12 Hour Days RN/Registered Nurse
544474 ER Hilo HAWAII 12 Hour Nights
542811 ER Bronx NEW YORK 12 Hour Days
548215 ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
545453 ER Lynwood CALIFORNIA 12 Hour Nights
547967 ER Madison WISCONSIN 12 Hour Day/Night Rotate
544552 ER Newark NEW JERSEY 12 Hour Nights
544531 ER Des Moines IOWA 12 Hour Nights
547776 ER Morton WASHINGTON Nights
547919 ER Des Moines IOWA 12 Hour Days
542572 ER Honolulu HAWAII 12 Hour Days RN/Registered Nurse
540201 ER Concord CALIFORNIA 12 Hour Nights
540213 ER Concord CALIFORNIA 12 Hour Days
540156 ER Concord CALIFORNIA 12 Hour Days
548198 ER Casa Grande ARIZONA 12 Hour Nights RN/Registered Nurse
544705 ER Des Moines IOWA 12 Hour Nights
548112 ER Rome NEW YORK 12 Hour Nights RN/Registered Nurse
547481 ER Manchester CONNECTICUT 12 Hour Nights
546937 ER Albany NEW YORK 12 Hour Nights
548274 ER Oceanside CALIFORNIA 12 Hour Nights RN/Registered Nurse
540076 ER Concord CALIFORNIA 12 Hour Nights
540859 ER Springfield MASSACHUSETTS 8 Hour Nights
545579 ER Willoughby OHIO 12 Hour Nights
547059 ER Rome NEW YORK 12 Hour Nights
540001 ER Walnut Creek CALIFORNIA 12 Hour Days
548106 ER Cobleskill NEW YORK 12 Hour Nights RN/Registered Nurse
545621 ER Massena NEW YORK 12 Hour Nights
544852 ER San Angelo TEXAS Varied
546761 ER Auburn NEW YORK 12 Hour Nights
540256 ER Concord CALIFORNIA 12 Hour Days
544890 ER Concord CALIFORNIA 12 Hour Days
543974 ER Newark NEW JERSEY 12 Hour Nights
540861 ER Springfield MASSACHUSETTS 8 Hour Nights
544908 ER Oceanside CALIFORNIA 12 Hour Nights
546695 ER Oceanside CALIFORNIA 12 Hour Nights
543882 ER Philadelphia PENNSYLVANIA 12 Hour Nights
543644 ER Walnut Creek CALIFORNIA 12 Hour Nights
546625 ER Saratoga Springs NEW YORK 12 Hour Days
548367 ER FOLSOM CALIFORNIA 12 Hour Nights RN/Registered Nurse
540104 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
540106 ER Concord CALIFORNIA 12 Hour Nights
540108 ER Concord CALIFORNIA 12 Hour Nights
545080 ER Pueblo COLORADO 12 Hour Nights
540115 ER Walnut Creek CALIFORNIA 12 Hour Nights
546265 ER Cincinnati OHIO Nights
545058 ER Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
536558 ER Syracuse NEW YORK 12 Hour Nights RN/Registered Nurse
539974 ER Philipsburg MONTANA 12 Hour Nights
539068 ER Avalon CALIFORNIA Nights
538394 ER Avalon CALIFORNIA 12 Hour Day/Night Rotate
546620 ER Saratoga Springs NEW YORK 12 Hour Nights
545092 ER Portland OREGON 12 Hour Nights
540133 ER Concord CALIFORNIA 12 Hour Nights
546264 ER Robbinsdale MINNESOTA 12 Hour Nights
546331 ER Centerville IOWA 12 Hour Days
546105 ER Stafford Springs CONNECTICUT 12 Hour Nights
546310 ER Santa Rosa NEW MEXICO 12 Hour Nights
546366 ER Waterloo IOWA 12 Hour Nights
546599 ER Saratoga Springs NEW YORK 12 Hour Nights
546624 ER Saratoga Springs NEW YORK 12 Hour Days
544232 ER Denville NEW JERSEY 12 Hour Day/Night Rotate
540072 ER Walnut Creek CALIFORNIA 12 Hour Nights
537901 ER Avalon CALIFORNIA 12 Hour Day/Night Rotate
545380 L&D Lewistown MONTANA Nights
548151 L&D Silverdale WASHINGTON 12 Hour Days RN/Registered Nurse
540036 L&D Walnut Creek CALIFORNIA 12 Hour Nights
548187 L&D Saratoga Springs NEW YORK 12 Hour Nights RN/Registered Nurse
547946 L&D Perryville MISSOURI 12 Hour Nights
540291 L&D Walnut Creek CALIFORNIA 12 Hour Nights
548141 L&D Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548103 L&D New York NEW YORK 12 Hour Days RN/Registered Nurse
540172 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540186 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540037 L&D Walnut Creek CALIFORNIA 12 Hour Nights
547929 L&D San Antonio TEXAS 12 Hour Nights
540215 L&D Walnut Creek CALIFORNIA 12 Hour Nights
545425 L&D Mishawaka INDIANA 12 Hour Days
547954 L&D Cincinnati OHIO Days
547717 L&D Bronx NEW YORK 12 Hour Days
546759 L&D Auburn NEW YORK 12 Hour Nights
540169 L&D Walnut Creek CALIFORNIA 12 Hour Days
540188 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540190 L&D Walnut Creek CALIFORNIA 12 Hour Days
540199 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540023 L&D Walnut Creek CALIFORNIA 12 Hour Nights
548129 L&D Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548062 L&D Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
545514 L&D Arcata CALIFORNIA 12 Hour Nights
545515 L&D Arcata CALIFORNIA 12 Hour Nights
547871 L&D Cincinnati OHIO 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.386 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 500,100 in 1.261 seconds