Raw Data for "By The Numbers" Mashup - a Socio-Technical System Introduction Opinion sampling with Social Networks, Data Collection from Mobile Devices, and Government delivery of Data Services present statistical challanges. The Opinion samples are self-selected and tagged with only the most general location metadata. The basis for data collected from Mobile Devices, is nominally a population, but in reality depends on a household, or perhaps on the physical lay of the land itself. Federal, State, County and Municipal Governments share a single distribution channel, although not providing rival data. Neither HTML nor RDF are suitable for the representation of these profiles, which must at some point "fold flat" to produce an identifier. An XML file is possible, can be validated by XSD, and the both flat and expanded visualizations presented in the same HTML page with a browser client-side XSLT (c.f. http://www.rustprivacy.org/2012/roadmap/tarrant.xml (gsh.xsl, GS.xsd)) ================================================================================= This mashup provides a regional profile at the US County Level. The NULL values in the table are obtained with the Census API. e.g. Travis County Texas (user keys can be obtained free of charge: http://www.census.gov/developers/) http://api.census.gov/data/2010/sf1?key=[user_key]&get=NAME,P0010001,P0180001&for=county+subdivision:*&in=state:48+county:453 Country = 539 = "US" base 26 [5] FIPSst = FIPS State Code FIPSco = FIPS County Code FIPScosub = FIPS County Subdivision Code P0010001 = POP = Population [1,6] P0180001 = HH = (Occupied) Housing Units [1,6] Land_sqmi = Proportion of Land in Sq. Miles [2] Water_sqmi = Proportion of Water in Sq. Miles [2] Total_sqmi = Area in Sq. Miles [2] Lat = Interpolated latitude of the center of the area [3,7] Lon = Interpolated longitude of the center of the area [3,7] stTZO = Standard Time offset from UTC [4] [1] Population and Housing data at the State Level can be obtained directly from the Census API. http://api.census.gov/data/2010/sf1?key=[user_key]&get=NAME,P0010001,P0180001&for=state:* [2] Sums, Continental US (excluding Alaska, Hawaii, and Puerto Rico) [3] Continental US (Wikipedia) [4] Some Time Zones split Counties. Both Time Zones are shown in that case (c.f. Culberson County below). The dates for Daylight Saving Time, or not, are generally set by Federal Governments and this property can be inherited ("@") as opposed to multi-valued ("*"). [5] ISO 3166 2 Character Code [6] The County values are the sum of the component subdivisions. [7] The regional coverage for mapping purposes can be determined by: (Decimal Degrees) = 0.017042 * (Miles) - 0.000022 or (Miles) = 58.677109 (Decimal Degrees) + 0.001286 ================================================================================= mysql> call CountyProfile('48','439'); +---------+--------+--------+-----------+--------------------+----------+---------+-------------+------------+-------------+-----------+------------+-------+ | Country | FIPSst | FIPSco | FIPScosub | Name | POP | HH | Land_sqmi | Water_sqmi | Total_sqmi | Lat | Lon | stTZO | +---------+--------+--------+-----------+--------------------+----------+---------+-------------+------------+-------------+-----------+------------+-------+ | 539 | * | * | * | United States | * | * | 2954841.845 | 165584.602 | 3120426.447 | 39.828175 | -98.579500 | * | | 539 | 48 | * | * | Texas | 25145561 | 8922933 | 261231.709 | 7364.755 | 268596.464 | 31.194647 | -99.990321 | * | | 539 | 48 | 439 | * | Tarrant | NULL | NULL | 863.608 | 38.696 | 902.304 | 32.772040 | -97.291291 | -6.00 | | 539 | 48 | 439 | 90135 | Arlington | NULL | NULL | 176.631 | 5.065 | 181.696 | 32.666739 | -97.129977 | @ | | 539 | 48 | 439 | 91380 | Fort Worth | NULL | NULL | 477.326 | 28.312 | 505.638 | 32.753413 | -97.385639 | @ | | 539 | 48 | 439 | 92805 | Northeast Tarrant | NULL | NULL | 209.652 | 5.319 | 214.971 | 32.900999 | -97.189890 | @ | +---------+--------+--------+-----------+--------------------+----------+---------+-------------+------------+-------------+-----------+------------+-------+ 6 rows in set (0.28 sec) [["NAME","P0010001","P0180001","state","county","county subdivision"], ["Arlington CCD","491713","176807","48","439","90135"], ["Fort Worth CCD","791745","285247","48","439","91380"], ["Northeast Tarrant CCD","525576","195080","48","439","92805"]] ================================================================================= mysql> call CountyProfile('48','109'); +---------+--------+--------+-----------+-----------------+----------+---------+-------------+------------+-------------+-----------+-------------+-------+ | Country | FIPSst | FIPSco | FIPScosub | Name | POP | HH | Land_sqmi | Water_sqmi | Total_sqmi | Lat | Lon | stTZO | +---------+--------+--------+-----------+-----------------+----------+---------+-------------+------------+-------------+-----------+-------------+-------+ | 539 | * | * | * | United States | * | * | 2954841.845 | 165584.602 | 3120426.447 | 39.828175 | -98.579500 | * | | 539 | 48 | * | * | Texas | 25145561 | 8922933 | 261231.709 | 7364.755 | 268596.464 | 31.194647 | -99.990321 | * | | 539 | 48 | 109 | * | Culberson | NULL | NULL | 3812.798 | 0.215 | 3813.013 | 31.445909 | -104.526945 | -6.00 | | 539 | 48 | 109 | * | Culberson | NULL | NULL | 3812.798 | 0.215 | 3813.013 | 31.445909 | -104.526945 | -7.00 | | 539 | 48 | 109 | 94010 | Van Horn | NULL | NULL | 136.980 | 0.032 | 137.012 | 31.081269 | -104.818947 | @ | | 539 | 48 | 109 | 94015 | Van Horn Rural | NULL | NULL | 3675.818 | 0.183 | 3676.001 | 31.469411 | -104.502843 | @ | +---------+--------+--------+-----------+-----------------+----------+---------+-------------+------------+-------------+-----------+-------------+-------+ 6 rows in set (0.29 sec) [["NAME","P0010001","P0180001","state","county","county subdivision"], ["Van Horn CCD","2189","824","48","109","94010"], ["Van Horn Rural CCD","209","84","48","109","94015"]] ================================================================================= mysql> call CountyProfile('48','113'); +---------+--------+--------+-----------+-------------------+----------+---------+-------------+------------+-------------+-----------+------------+-------+ | Country | FIPSst | FIPSco | FIPScosub | Name | POP | HH | Land_sqmi | Water_sqmi | Total_sqmi | Lat | Lon | stTZO | +---------+--------+--------+-----------+-------------------+----------+---------+-------------+------------+-------------+-----------+------------+-------+ | 539 | * | * | * | United States | * | * | 2954841.845 | 165584.602 | 3120426.447 | 39.828175 | -98.579500 | * | | 539 | 48 | * | * | Texas | 25145561 | 8922933 | 261231.709 | 7364.755 | 268596.464 | 31.194647 | -99.990321 | * | | 539 | 48 | 113 | * | Dallas | NULL | NULL | 871.279 | 37.335 | 908.614 | 32.766987 | -96.778424 | -6.00 | | 539 | 48 | 113 | 92792 | Northeast Dallas | NULL | NULL | 453.207 | 20.767 | 473.974 | 32.829449 | -96.688319 | @ | | 539 | 48 | 113 | 93682 | Southwest Dallas | NULL | NULL | 418.073 | 16.568 | 434.641 | 32.698426 | -96.876343 | @ | +---------+--------+--------+-----------+-------------------+----------+---------+-------------+------------+-------------+-----------+------------+-------+ 5 rows in set (0.27 sec) [["NAME","P0010001","P0180001","state","county","county subdivision"], ["Northeast Dallas CCD","1455973","545191","48","113","92792"], ["Southwest Dallas CCD","912166","310769","48","113","93682"]] ================================================================================= mysql> call CountyProfile('48','141'); +---------+--------+--------+-----------+------------------------+----------+---------+-------------+------------+-------------+-----------+-------------+-------+ | Country | FIPSst | FIPSco | FIPScosub | Name | POP | HH | Land_sqmi | Water_sqmi | Total_sqmi | Lat | Lon | stTZO | +---------+--------+--------+-----------+------------------------+----------+---------+-------------+------------+-------------+-----------+-------------+-------+ | 539 | * | * | * | United States | * | * | 2954841.845 | 165584.602 | 3120426.447 | 39.828175 | -98.579500 | * | | 539 | 48 | * | * | Texas | 25145561 | 8922933 | 261231.709 | 7364.755 | 268596.464 | 31.194647 | -99.990321 | * | | 539 | 48 | 141 | * | El Paso | NULL | NULL | 1012.693 | 2.267 | 1014.960 | 31.766403 | -106.241391 | -7.00 | | 539 | 48 | 141 | 91215 | El Paso | NULL | NULL | 143.454 | 0.585 | 144.039 | 31.789923 | -106.409030 | @ | | 539 | 48 | 141 | 91220 | El Paso East | NULL | NULL | 554.982 | 0.716 | 555.698 | 31.674054 | -106.115001 | @ | | 539 | 48 | 141 | 91225 | El Paso North Central | NULL | NULL | 181.112 | 0.391 | 181.503 | 31.923482 | -106.234897 | @ | | 539 | 48 | 141 | 91230 | El Paso Northwest | NULL | NULL | 133.145 | 0.575 | 133.720 | 31.948886 | -106.528069 | @ | +---------+--------+--------+-----------+------------------------+----------+---------+-------------+------------+-------------+-----------+-------------+-------+ 7 rows in set (0.20 sec) [["NAME","P0010001","P0180001","state","county","county subdivision"], ["El Paso CCD","550597","187712","48","141","91215"], ["El Paso East CCD","160404","43251","48","141","91220"], ["El Paso North Central CCD","11022","1565","48","141","91225"], ["El Paso Northwest CCD","78624","24029","48","141","91230"]] ================================================================================= mysql> call CountyProfile('48','367'); +---------+--------+--------+-----------+------------------------+----------+---------+-------------+------------+-------------+-----------+------------+-------+ | Country | FIPSst | FIPSco | FIPScosub | Name | POP | HH | Land_sqmi | Water_sqmi | Total_sqmi | Lat | Lon | stTZO | +---------+--------+--------+-----------+------------------------+----------+---------+-------------+------------+-------------+-----------+------------+-------+ | 539 | * | * | * | United States | * | * | 2954841.845 | 165584.602 | 3120426.447 | 39.828175 | -98.579500 | * | | 539 | 48 | * | * | Texas | 25145561 | 8922933 | 261231.709 | 7364.755 | 268596.464 | 31.194647 | -99.990321 | * | | 539 | 48 | 367 | * | Parker | NULL | NULL | 903.478 | 6.616 | 910.094 | 32.777096 | -97.805905 | -6.00 | | 539 | 48 | 367 | 93701 | Springtown-Reno | NULL | NULL | 196.004 | 0.824 | 196.828 | 32.889923 | -97.672844 | @ | | 539 | 48 | 367 | 94095 | Weatherford | NULL | NULL | 305.512 | 2.589 | 308.101 | 32.670489 | -97.895040 | @ | | 539 | 48 | 367 | 94100 | Weatherford Northwest | NULL | NULL | 239.242 | 1.288 | 240.530 | 32.902770 | -97.918825 | @ | | 539 | 48 | 367 | 94105 | Weatherford Southeast | NULL | NULL | 162.721 | 1.915 | 164.636 | 32.681777 | -97.642001 | @ | +---------+--------+--------+-----------+------------------------+----------+---------+-------------+------------+-------------+-----------+------------+-------+ 7 rows in set (0.23 sec) [["NAME","P0010001","P0180001","state","county","county subdivision"], ["Springtown-Reno CCD","37832","13594","48","367","93701"], ["Weatherford CCD","37677","14410","48","367","94095"], ["Weatherford Northwest CCD","13782","4338","48","367","94100"], ["Weatherford Southeast CCD","27636","9727","48","367","94105"]] ================================================================================= mysql> call CountyProfile('48','453'); +---------+--------+--------+-----------+-------------------+----------+---------+-------------+------------+-------------+-----------+------------+-------+ | Country | FIPSst | FIPSco | FIPScosub | Name | POP | HH | Land_sqmi | Water_sqmi | Total_sqmi | Lat | Lon | stTZO | +---------+--------+--------+-----------+-------------------+----------+---------+-------------+------------+-------------+-----------+------------+-------+ | 539 | * | * | * | United States | * | * | 2954841.845 | 165584.602 | 3120426.447 | 39.828175 | -98.579500 | * | | 539 | 48 | * | * | Texas | 25145561 | 8922933 | 261231.709 | 7364.755 | 268596.464 | 31.194647 | -99.990321 | * | | 539 | 48 | 453 | * | Travis | NULL | NULL | 990.202 | 32.806 | 1023.008 | 30.239513 | -97.691270 | -6.00 | | 539 | 48 | 453 | 90165 | Austin | NULL | NULL | 466.833 | 6.066 | 472.899 | 30.239513 | -97.691270 | @ | | 539 | 48 | 453 | 92807 | Northeast Travis | NULL | NULL | 143.235 | 0.065 | 143.300 | 30.411198 | -97.531169 | @ | | 539 | 48 | 453 | 92857 | Northwest Travis | NULL | NULL | 209.536 | 14.500 | 224.036 | 30.478443 | -97.940950 | @ | | 539 | 48 | 453 | 93688 | Southwest Travis | NULL | NULL | 170.598 | 12.176 | 182.774 | 30.339442 | -98.010748 | @ | +---------+--------+--------+-----------+-------------------+----------+---------+-------------+------------+-------------+-----------+------------+-------+ 7 rows in set (0.23 sec) [["NAME","P0010001","P0180001","state","county","county subdivision"], ["Austin CCD","774229","311231","48","453","90165"], ["Northeast Travis CCD","100175","33681","48","453","92807"], ["Northwest Travis CCD","96420","38719","48","453","92857"], ["Southwest Travis CCD","53442","20836","48","453","93688"]]