::* '''county''' or
::* '''state'''
:* ''template'' the type of census data to be returned. Over 45,000 different database fields can be reported on from the online census database. [[Census_Integration#List_of_Commonly-used_Templates|Examples]] are listed below. Note that the template should be enclosed within a double set of square brackets (e.g., <nowiki>[[</nowiki>B01003_001E<nowiki>]]</nowiki>)'''Example:'''In the example at the top of the page, the Median Family Income for Louisiana in 2012 ($56,047.00) is returned using
:<font size="3">@FFD(profile;;2012;;@address@ @city@ @state@;;state;;[[B19113_001E]])@</font>
Note that the template should be enclosed within a double set of square brackets (e.g., <nowiki>[[</nowiki>B01003_001E<nowiki>]]</nowiki>)
You would then use the following template: for the tract level @FFD(Profile;;year;;Address or FIPS code;;tract;;template)
for the county level @FFD(Profile;;year;;Address or FIPS code;;county;;template)
for the state level @FFD(Profile;;year;;Address or FIPS code;;state;;template)
Example: @FFD(profile;;2012;;@address@ @city@ @state@;;county;; [[B01003_001E]])
Profile – constant, query name
Year – integer value of year like 2012,2013. Normally last year statistics are not available until second halve of the current year
Address or FIPS code – can be full address or fips code like “@address@ @city@ @state@“ or “@FIPS@
Template – html template with statistic variables like “Earnings for Households:$[[B06002_001E]]”
Where B06002_001E is field name of Census data (please refer to the xlsx for complete list I sent earlier) ,2 square brackets are used to embed a fieldname
==List of Commonly-used Templates==
