Map Title: Unemployment rates by county, not seasonally adjusted
Map Type: Virginia county Map
Month/Year: January/2014
CountyJanuary
2014
Accomack County8.4
Albemarle County4.5
Alexandria City4.0
Alleghany County7.0
Amelia County6.1
Amherst County5.7
Appomattox County6.2
Arlington County3.3
Augusta County5.0
Bath County5.9
Bedford County5.5
Bland County6.5
Botetourt County5.2
Bristol City6.9
Brunswick County9.9
Buchanan County11.4
Buckingham County7.8
Buena Vista City6.1
Campbell County5.7
Caroline County7.2
Carroll County8.0
Charles City County6.5
Charlotte County7.3
Charlottesville City4.4
Chesapeake City5.7
Chesterfield County5.4
Clarke County4.5
Colonial Heights City6.0
Covington City9.9
Craig County7.0
Culpeper County5.5
Cumberland County6.6
Danville City9.5
Dickenson County12.0
Dinwiddie County7.0
Emporia City9.9
Essex County6.9
Fairfax City4.1
Fairfax County4.2
Falls Church City3.7
Fauquier County4.9
Floyd County5.4
Fluvanna County4.7
Franklin City9.2
Franklin County5.9
Frederick County5.2
Fredericksburg City6.2
Galax City7.8
Giles County7.0
Gloucester County5.4
Goochland County5.0
Grayson County8.7
Greene County4.4
Greensville County7.8
Halifax County9.3
Hampton City7.4
Hanover County4.8
Harrisonburg City5.8
Henrico County5.5
Henry County8.9
Highland County4.6
Hopewell City10.0
Isle of Wight County5.8
James City County5.8
King George County5.8
King William County6.0
King and Queen County6.1
Lancaster County11.3
Lee County9.3
Lexington City7.8
Loudoun County4.4
Louisa County5.8
Lunenburg County6.5
Lynchburg City6.5
Madison County4.1
Manassas City5.6
Manassas Park City5.2
Martinsville City11.2
Mathews County5.0
Mecklenburg County9.1
Middlesex County5.8
Montgomery County5.2
Nelson County5.6
New Kent County5.1
Newport News City6.9
Norfolk City6.9
Northampton County10.3
Northumberland County10.2
Norton City9.0
Nottoway County6.0
Orange County5.8
Page County11.7
Patrick County7.4
Petersburg City12.1
Pittsylvania County7.0
Poquoson City4.7
Portsmouth City8.3
Powhatan County4.9
Prince Edward County8.1
Prince George County6.7
Prince William County5.2
Pulaski County6.9
Radford City7.1
Rappahannock County4.9
Richmond City6.7
Richmond County6.9
Roanoke City6.5
Roanoke County4.9
Rockbridge County5.9
Rockingham County4.8
Russell County8.7
Salem City5.5
Scott County6.4
Shenandoah County5.6
Smyth County9.1
Southampton County5.6
Spotsylvania County5.8
Stafford County5.7
Staunton City5.5
Suffolk City6.2
Surry County7.3
Sussex County8.6
Tazewell County8.6
Virginia Beach City5.3
Warren County6.1
Washington County6.5
Waynesboro City5.9
Westmoreland County8.1
Williamsburg City8.0
Winchester City5.8
Wise County10.7
Wythe County7.5
York County5.3

PHP Code


<?php


// PHP Screen Scraping Tutorial

$url = "http://www.nfl.com/teams/sandiegochargers/roster?team=SD";
 
$raw = file_get_contents($url);

$newlines = array("\t","\n","\r","\x20\x20","\0","\x0B");
 
$content = str_replace($newlines, "", html_entity_decode($raw));

$start = strpos($content,'<table id="result"');
 
$end = strpos($content,'</table>',$start) + 8;
 
$table = substr($content,$start,$end-$start);

preg_match_all("|<tr(.*)</tr>|U",$table,$rows);
 
foreach ($rows[0] as $row){
 
	if ((strpos($row,'<th')===false)){
 
		preg_match_all("|<td(.*)</td>|U",$row,$cells);
 
		$number = strip_tags($cells[0][0]);
 
		$name = strip_tags($cells[0][1]);
 
		$position = strip_tags($cells[0][2]);
 
		echo "{$position} - {$name} - Number {$number} <br>\n";
 
	}
 
}








?>