Listing all records

Displaying records 2301 through 2400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545288 Step Down South Charleston WEST VIRGINIA 12 Hour Nights
545291 PCU Rock Hill SOUTH CAROLINA 12 Hour Nights
545292 CVICU Memphis TENNESSEE 12 Hour Nights
545299 CVICU Little Rock ARKANSAS 12 Hour Nights
545300 Med Surg Helena MONTANA 12 Hour Nights
545307 Med Surg Olympia WASHINGTON 12 Hour Nights
545308 Med Surg Olympia WASHINGTON 12 Hour Nights
545310 OR SANTA ROSA CALIFORNIA 12 Hour Nights
545311 ICU Colville WASHINGTON 12 Hour Nights
546620 ER Saratoga Springs NEW YORK 12 Hour Nights
545328 CNA Salem OREGON 12 Hour Nights
546635 ER Des Moines IOWA 12 Hour Nights
545338 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
545610 Med Surg HOBBS NEW MEXICO 12 Hour Nights
545343 PCU Concord NEW HAMPSHIRE 12 Hour Nights
545369 Step Down Mayfield Heights OHIO 12 Hour Nights
546708 ICU Albany NEW YORK 12 Hour Nights
546709 ER Albany NEW YORK 12 Hour Nights
546707 Med Surg Albany NEW YORK 12 Hour Nights
547123 Med Surg Des Moines IOWA 12 Hour Nights
547318 ICU Meridian IDAHO 12 Hour Nights
545421 RN Columbus OHIO 12 Hour Nights
545427 NICU Mishawaka INDIANA 12 Hour Nights
545452 ER Bristol PENNSYLVANIA 12 Hour Nights
545453 ER Lynwood CALIFORNIA 12 Hour Nights
547728 PCU Mesa ARIZONA 12 Hour Nights
545482 PCU Lancaster SOUTH CAROLINA 12 Hour Nights
547904 ICU Mesa ARIZONA 12 Hour Nights
545502 Telemetry Boise IDAHO 12 Hour Nights
545503 Telemetry Boise IDAHO 12 Hour Nights
545514 L&D Arcata CALIFORNIA 12 Hour Nights
545515 L&D Arcata CALIFORNIA 12 Hour Nights
545992 Pediatrics King City CALIFORNIA 12 Hour Nights
547319 Telemetry Nampa IDAHO 12 Hour Nights
546720 Med Surg Tele Olympia WASHINGTON 12 Hour Nights
545820 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545824 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545825 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545826 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545827 Med Surg Gainesville FLORIDA 12 Hour Nights
545828 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545830 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545832 ICU Gainesville FLORIDA 12 Hour Nights
545833 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545834 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545835 Pediatric ER Gainesville FLORIDA 12 Hour Nights
545836 ICU Gainesville FLORIDA 12 Hour Nights
545838 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545839 ICU Gainesville FLORIDA 12 Hour Nights
545840 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545842 ICU Gainesville FLORIDA 12 Hour Nights
545845 Med Surg Gainesville FLORIDA 12 Hour Nights
545846 Med Surg Gainesville FLORIDA 12 Hour Nights
545847 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545848 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545849 Med Surg Gainesville FLORIDA 12 Hour Nights
545851 ICU Gainesville FLORIDA 12 Hour Nights
545857 Med Surg Gainesville FLORIDA 12 Hour Nights
545860 Med Surg Gainesville FLORIDA 12 Hour Nights
545861 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545862 Med Surg Gainesville FLORIDA 12 Hour Nights
545864 ICU Gainesville FLORIDA 12 Hour Nights
545867 Cardiology Gainesville FLORIDA 12 Hour Nights
545869 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545871 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545877 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545879 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545881 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545883 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545885 Med Surg Gainesville FLORIDA 12 Hour Nights
545891 Med Surg Gainesville FLORIDA 12 Hour Nights
545892 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545894 ICU Gainesville FLORIDA 12 Hour Nights
545895 ICU Gainesville FLORIDA 12 Hour Nights
545897 Med Surg Gainesville FLORIDA 12 Hour Nights
545900 MLT Gainesville FLORIDA 12 Hour Nights
545903 Med Surg Gainesville FLORIDA 12 Hour Nights
545904 Med Surg Gainesville FLORIDA 12 Hour Nights
545905 Med Surg Gainesville FLORIDA 12 Hour Nights
545909 ICU Gainesville FLORIDA 12 Hour Nights
545910 ICU Gainesville FLORIDA 12 Hour Nights
545911 ICU Gainesville FLORIDA 12 Hour Nights
545912 ICU Gainesville FLORIDA 12 Hour Nights
545913 ICU Gainesville FLORIDA 12 Hour Nights
545914 Pediatric ER Gainesville FLORIDA 12 Hour Nights
547376 PCU Charlottesville VIRGINIA 12 Hour Nights
545922 Med Surg Gainesville FLORIDA 12 Hour Nights
545923 Med Surg Gainesville FLORIDA 12 Hour Nights
545927 Med Surg Gainesville FLORIDA 12 Hour Nights
545931 Med Surg Gainesville FLORIDA 12 Hour Nights
545932 Med Surg Gainesville FLORIDA 12 Hour Nights
545934 ICU Gainesville FLORIDA 12 Hour Nights
545935 Med Surg Gainesville FLORIDA 12 Hour Nights
545936 Med Surg Gainesville FLORIDA 12 Hour Nights
545937 Med Surg Gainesville FLORIDA 12 Hour Nights
545939 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545942 Med Surg Gainesville FLORIDA 12 Hour Nights
546228 Pediatrics Concord NEW HAMPSHIRE 12 Hour Nights
546225 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
545963 Med Surg Gainesville FLORIDA 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.8171 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.shift asc limit 2300,100 in 1.4465 seconds