Data on the Open Data Network

Publishers

Refine by:Found 27 results

finance Close
data.bayareametro.gov Close
health.data.ny.gov Close
data.countyofriverside.us Close
results.livewellsd.org Close

finance - The Finance category contains data, from across the Open Data Network™ of publishers, related to finance, government spending, salaries, budgets, revenues, and taxes.

API
Vital Signs: Income (Median by Workplace) – by county
data.bayareametro.gov | Last Updated 2019-08-13T16:17:18.000Z
VITAL SIGNS INDICATOR Income (EC5) FULL MEASURE NAME Worker income by workplace (earnings) LAST UPDATED May 2019 DESCRIPTION Income reflects the median earnings of individuals and households from employment, as well as the income distribution by quintile. Income data highlight how employees are being compensated for their work on an inflation-adjusted basis. DATA SOURCE U.S. Census Bureau: Decennial Census Count 4Pb (1970) Form STF3 (1980-1990) Form SF3a (2000) https://nhgis.org U.S. Census Bureau: American Community Survey Form B08521 (2006-2017; place of employment) http://api.census.gov Bureau of Labor Statistics: Consumer Price Index All Urban Consumers Data Table (1970-2017; specific to each metro area) http://data.bls.gov CONTACT INFORMATION Vitalsigns.info@bayareametro.gov METHODOLOGY NOTES (across all datasets for this indicator) Income data reported in a given year reflects the income earned in the prior year (decennial Census) or in the prior 12 months (American Community Survey); note that this inconsistency has a minor effect on historical comparisons (for more information, go to: http://www.census.gov/acs/www/Downloads/methodology/ASA_nelson.pdf). American Community Survey 1-year data is used for larger geographies – metropolitan areas and counties – while smaller geographies rely upon 5-year rolling average data due to their smaller sample sizes. Quintile income for 1970-2000 is imputed from Decennial Census data using methodology from the California Department of Finance (for more information, go to: http://www.dof.ca.gov/Forecasting/Demographics/Census_Data_Center_Network/documents/How_to_Recalculate_a_Median.pdf). Bay Area income is the population weighted average of county-level income. Income has been inflated using the Consumer Price Index specific to each metro area; however, some metro areas lack metro-specific CPI data back to 1970 and therefore adjusted data is unavailable for some historical data points. Note that current MSA boundaries were used for historical comparison by identifying counties included in today’s metro areas.
API
Vital Signs: List Rents – by metro
data.bayareametro.gov | Last Updated 2018-07-06T18:06:30.000Z
VITAL SIGNS INDICATOR List Rents (EC9) FULL MEASURE NAME List Rents LAST UPDATED October 2016 DESCRIPTION List rent refers to the advertised rents for available rental housing and serves as a measure of housing costs for new households moving into a neighborhood, city, county or region. DATA SOURCE real Answers (1994 – 2015) no link Zillow Metro Median Listing Price All Homes (2010-2016) http://www.zillow.com/research/data/ CONTACT INFORMATION vitalsigns.info@mtc.ca.gov METHODOLOGY NOTES (across all datasets for this indicator) List rents data reflects median rent prices advertised for available apartments rather than median rent payments; more information is available in the indicator definition above. Regional and local geographies rely on data collected by real Answers, a research organization and database publisher specializing in the multifamily housing market. real Answers focuses on collecting longitudinal data for individual rental properties through quarterly surveys. For the Bay Area, their database is comprised of properties with 40 to 3,000+ housing units. Median list prices most likely have an upward bias due to the exclusion of smaller properties. The bias may be most extreme in geographies where large rental properties represent a small portion of the overall rental market. A map of the individual properties surveyed is included in the Local Focus section. Individual properties surveyed provided lower- and upper-bound ranges for the various types of housing available (studio, 1 bedroom, 2 bedroom, etc.). Median lower- and upper-bound prices are determined across all housing types for the regional and county geographies. The median list price represented in Vital Signs is the average of the median lower- and upper-bound prices for the region and counties. Median upper-bound prices are determined across all housing types for the city geographies. The median list price represented in Vital Signs is the median upper-bound price for cities. For simplicity, only the mean list rent is displayed for the individual properties. The metro areas geography rely upon Zillow data, which is the median price for rentals listed through www.zillow.com during the month. Like the real Answers data, Zillow's median list prices most likely have an upward bias since small properties are underrepresented in Zillow's listings. The metro area data for the Bay Area cannot be compared to the regional Bay Area data. Due to afore mentioned data limitations, this data is suitable for analyzing the change in list rents over time but not necessarily comparisons of absolute list rents. Metro area boundaries reflects today’s metro area definitions by county for consistency, rather than historical metro area boundaries. Due to the limited number of rental properties surveyed, city-level data is unavailable for Atherton, Belvedere, Brisbane, Calistoga, Clayton, Cloverdale, Cotati, Fairfax, Half Moon Bay, Healdsburg, Hillsborough, Los Altos Hills, Monte Sereno, Moranga, Oakley, Orinda, Portola Valley, Rio Vista, Ross, San Anselmo, San Carlos, Saratoga, Sebastopol, Windsor, Woodside, and Yountville. Inflation-adjusted data are presented to illustrate how rents have grown relative to overall price increases; that said, the use of the Consumer Price Index does create some challenges given the fact that housing represents a major chunk of consumer goods bundle used to calculate CPI. This reflects a methodological tradeoff between precision and accuracy and is a common concern when working with any commodity that is a major component of CPI itself. Percent change in inflation-adjusted median is calculated with respect to the median price from the fourth quarter or December of the base year.
API
Vital Signs: Housing Production – by county (updated November 2019)
data.bayareametro.gov | Last Updated 2019-11-25T18:02:56.000Z
VITAL SIGNS INDICATOR Housing Production (LU4) FULL MEASURE NAME Produced housing units by unit type LAST UPDATED October 2019 DESCRIPTION Housing production is measured in terms of the number of units that local jurisdictions produces throughout a given year. The annual production count captures housing units added by new construction and annexations, subtracts demolitions and destruction from natural disasters, and adjusts for units lost or gained by conversions. DATA SOURCE California Department of Finance Form E-8 1990-2010 http://www.dof.ca.gov/Forecasting/Demographics/Estimates/E-8/ California Department of Finance Form E-5 2011-2018 http://www.dof.ca.gov/Forecasting/Demographics/Estimates/E-5/ U.S. Census Bureau Population Estimates 2000-2018 https://www.census.gov/programs-surveys/popest.html CONTACT INFORMATION vitalsigns.info@bayareametro.gov METHODOLOGY NOTES (across all datasets for this indicator) Single-family housing units include single detached units and single attached units. Multi-family housing includes two to four units and five plus or apartment units. Housing production data for metropolitan areas for each year is the difference of annual housing unit estimates from the Census Bureau’s Population Estimates Program. Housing production data for the region, counties, and cities for each year is the difference of annual housing unit estimates from the California Department of Finance. Department of Finance data uses an annual cycle between January 1 and December 31, whereas U.S. Census Bureau data uses an annual cycle from April 1 to March 31 of the following year. Housing production data shows how many housing units have been produced over time. Like housing permit statistics, housing production numbers are an indicator of where the region is growing. However, since permitted units are sometimes not constructed or there can be a long lag time between permit approval and the start of construction, production data also reflects the effects of barriers to housing production. These range from a lack of builder confidence to high construction costs and limited financing. Data also differentiates the trends in multi-family, single-family and mobile home production.
API
Vital Signs: Poverty - by metro
data.bayareametro.gov | Last Updated 2019-10-25T20:37:40.000Z
VITAL SIGNS INDICATOR Poverty (EQ5) FULL MEASURE NAME The share of the population living in households that earn less than 200 percent of the federal poverty limit LAST UPDATED December 2018 DESCRIPTION Poverty refers to the share of the population living in households that earn less than 200 percent of the federal poverty limit, which varies based on the number of individuals in a given household. It reflects the number of individuals who are economically struggling due to low household income levels. DATA SOURCE U.S Census Bureau: Decennial Census http://www.nhgis.org (1980-1990) http://factfinder2.census.gov (2000) U.S. Census Bureau: American Community Survey Form C17002 (2006-2017) http://api.census.gov METHODOLOGY NOTES (across all datasets for this indicator) The U.S. Census Bureau defines a national poverty level (or household income) that varies by household size, number of children in a household, and age of householder. The national poverty level does not vary geographically even though cost of living is different across the United States. For the Bay Area, where cost of living is high and incomes are correspondingly high, an appropriate poverty level is 200% of poverty or twice the national poverty level, consistent with what was used for past equity work at MTC and ABAG. For comparison, however, both the national and 200% poverty levels are presented. For Vital Signs, the poverty rate is defined as the number of people (including children) living below twice the poverty level divided by the number of people for whom poverty status is determined. Poverty rates do not include unrelated individuals below 15 years old or people who live in the following: institutionalized group quarters, college dormitories, military barracks, and situations without conventional housing. The household income definitions for poverty change each year to reflect inflation. The official poverty definition uses money income before taxes and does not include capital gains or noncash benefits (such as public housing, Medicaid, and food stamps). For the national poverty level definitions by year, see: https://www.census.gov/hhes/www/poverty/data/threshld/index.html For an explanation on how the Census Bureau measures poverty, see: https://www.census.gov/hhes/www/poverty/about/overview/measure.html For the American Community Survey datasets, 1-year data was used for region, county, and metro areas whereas 5-year rolling average data was used for city and census tract. To be consistent across metropolitan areas, the poverty definition for non-Bay Area metros is twice the national poverty level. Data were not adjusted for varying income and cost of living levels across the metropolitan areas.
API
Vital Signs: Housing Production – by metro (updated November 2019)
data.bayareametro.gov | Last Updated 2019-11-14T19:53:21.000Z
VITAL SIGNS INDICATOR Housing Production (LU4) FULL MEASURE NAME Produced housing units by unit type LAST UPDATED October 2019 DESCRIPTION Housing production is measured in terms of the number of units that local jurisdictions produces throughout a given year. The annual production count captures housing units added by new construction and annexations, subtracts demolitions and destruction from natural disasters, and adjusts for units lost or gained by conversions. DATA SOURCE California Department of Finance Form E-8 1990-2010 http://www.dof.ca.gov/Forecasting/Demographics/Estimates/E-8/ California Department of Finance Form E-5 2011-2018 http://www.dof.ca.gov/Forecasting/Demographics/Estimates/E-5/ U.S. Census Bureau Population Estimates 2000-2018 https://www.census.gov/programs-surveys/popest.html CONTACT INFORMATION vitalsigns.info@bayareametro.gov METHODOLOGY NOTES (across all datasets for this indicator) Single-family housing units include single detached units and single attached units. Multi-family housing includes two to four units and five plus or apartment units. Housing production data for metropolitan areas for each year is the difference of annual housing unit estimates from the Census Bureau’s Population Estimates Program. Housing production data for the region, counties, and cities for each year is the difference of annual housing unit estimates from the California Department of Finance. Department of Finance data uses an annual cycle between January 1 and December 31, whereas U.S. Census Bureau data uses an annual cycle from April 1 to March 31 of the following year. Housing production data shows how many housing units have been produced over time. Like housing permit statistics, housing production numbers are an indicator of where the region is growing. However, since permitted units are sometimes not constructed or there can be a long lag time between permit approval and the start of construction, production data also reflects the effects of barriers to housing production. These range from a lack of builder confidence to high construction costs and limited financing. Data also differentiates the trends in multi-family, single-family and mobile home production.
API
Vital Signs: Transit Cost-Effectiveness – by metro
data.bayareametro.gov | Last Updated 2018-07-06T18:04:53.000Z
VITAL SIGNS INDICATOR Transit Cost-Effectiveness (T13) FULL MEASURE NAME Net cost per transit boarding (cost per boarding minus fare per boarding) LAST UPDATED May 2017 DESCRIPTION Transit cost-effectiveness refers to both the total and net costs per transit boarding, both of which are adjusted to reflect inflation over time. Net costs reflect total operating costs minus farebox revenue (i.e. operating costs that are not directly funded by system users). The dataset includes metropolitan area, regional, mode, and system tables for net cost per boarding, total cost per boarding, and farebox recovery ratio. DATA SOURCE Federal Transit Administration: National Transit Database http://www.ntdprogram.gov/ntdprogram/data.htm Bureau of Labor Statistics: Consumer Price Index http://www.bls.gov/data/ CONTACT INFORMATION vitalsigns.info@mtc.ca.gov METHODOLOGY NOTES (across all datasets for this indicator) Simple modes were aggregated to combine the various bus modes (e.g. rapid bus, express bus, local bus) into a single mode to avoid incorrect conclusions resulting from mode recoding over the lifespan of NTD. For other metro areas, operators were identified by developing a list of all urbanized areas within a current MSA boundary and then using that UZA list to flag relevant operators; this means that all operators (both large and small) were included in the metro comparison data. Financial data was inflation-adjusted to match 2015 dollar values using metro-specific Consumer Price Indices.
API
Vital Signs: Poverty - Bay Area
data.bayareametro.gov | Last Updated 2019-10-25T20:36:36.000Z
VITAL SIGNS INDICATOR Poverty (EQ5) FULL MEASURE NAME The share of the population living in households that earn less than 200 percent of the federal poverty limit LAST UPDATED December 2018 DESCRIPTION Poverty refers to the share of the population living in households that earn less than 200 percent of the federal poverty limit, which varies based on the number of individuals in a given household. It reflects the number of individuals who are economically struggling due to low household income levels. DATA SOURCE U.S Census Bureau: Decennial Census http://www.nhgis.org (1980-1990) http://factfinder2.census.gov (2000) U.S. Census Bureau: American Community Survey Form C17002 (2006-2017) http://api.census.gov METHODOLOGY NOTES (across all datasets for this indicator) The U.S. Census Bureau defines a national poverty level (or household income) that varies by household size, number of children in a household, and age of householder. The national poverty level does not vary geographically even though cost of living is different across the United States. For the Bay Area, where cost of living is high and incomes are correspondingly high, an appropriate poverty level is 200% of poverty or twice the national poverty level, consistent with what was used for past equity work at MTC and ABAG. For comparison, however, both the national and 200% poverty levels are presented. For Vital Signs, the poverty rate is defined as the number of people (including children) living below twice the poverty level divided by the number of people for whom poverty status is determined. Poverty rates do not include unrelated individuals below 15 years old or people who live in the following: institutionalized group quarters, college dormitories, military barracks, and situations without conventional housing. The household income definitions for poverty change each year to reflect inflation. The official poverty definition uses money income before taxes and does not include capital gains or noncash benefits (such as public housing, Medicaid, and food stamps). For the national poverty level definitions by year, see: https://www.census.gov/hhes/www/poverty/data/threshld/index.html For an explanation on how the Census Bureau measures poverty, see: https://www.census.gov/hhes/www/poverty/about/overview/measure.html For the American Community Survey datasets, 1-year data was used for region, county, and metro areas whereas 5-year rolling average data was used for city and census tract. To be consistent across metropolitan areas, the poverty definition for non-Bay Area metros is twice the national poverty level. Data were not adjusted for varying income and cost of living levels across the metropolitan areas.
API
Vital Signs: Housing Production – by city (updated November 2019)
data.bayareametro.gov | Last Updated 2019-11-14T20:06:31.000Z
VITAL SIGNS INDICATOR Housing Production (LU4) FULL MEASURE NAME Produced housing units by unit type LAST UPDATED October 2019 DESCRIPTION Housing production is measured in terms of the number of units that local jurisdictions produces throughout a given year. The annual production count captures housing units added by new construction and annexations, subtracts demolitions and destruction from natural disasters, and adjusts for units lost or gained by conversions. DATA SOURCE California Department of Finance Form E-8 1990-2010 http://www.dof.ca.gov/Forecasting/Demographics/Estimates/E-8/ California Department of Finance Form E-5 2011-2018 http://www.dof.ca.gov/Forecasting/Demographics/Estimates/E-5/ U.S. Census Bureau Population Estimates 2000-2018 https://www.census.gov/programs-surveys/popest.html CONTACT INFORMATION vitalsigns.info@bayareametro.gov METHODOLOGY NOTES (across all datasets for this indicator) Single-family housing units include single detached units and single attached units. Multi-family housing includes two to four units and five plus or apartment units. Housing production data for metropolitan areas for each year is the difference of annual housing unit estimates from the Census Bureau’s Population Estimates Program. Housing production data for the region, counties, and cities for each year is the difference of annual housing unit estimates from the California Department of Finance. Department of Finance data uses an annual cycle between January 1 and December 31, whereas U.S. Census Bureau data uses an annual cycle from April 1 to March 31 of the following year. Housing production data shows how many housing units have been produced over time. Like housing permit statistics, housing production numbers are an indicator of where the region is growing. However, since permitted units are sometimes not constructed or there can be a long lag time between permit approval and the start of construction, production data also reflects the effects of barriers to housing production. These range from a lack of builder confidence to high construction costs and limited financing. Data also differentiates the trends in multi-family, single-family and mobile home production.
API
Vital Signs: Rent Payments – by city
data.bayareametro.gov | Last Updated 2019-10-25T20:17:50.000Z
VITAL SIGNS INDICATOR Rent Payments (EC8) FULL MEASURE NAME Median rent payment LAST UPDATED August 2019 DESCRIPTION Rent payments refer to the cost of leasing an apartment or home and serves as a measure of housing costs for individuals who do not own a home. The data reflect the median monthly rent paid by Bay Area households across apartments and homes of various sizes and various levels of quality. This differs from advertised rents for available apartments, which usually are higher. Note that rent can be presented using nominal or real (inflation-adjusted) dollar values; data are presented inflation-adjusted to reflect changes in household purchasing power over time. DATA SOURCE U.S. Census Bureau: Decennial Census 1970-2000 https://nhgis.org Note: Count 1 and Count 2; Form STF1; Form SF3a U.S. Census Bureau: American Community Survey 2005-2017 http://api.census.gov Note: Form B25058; 1-YR Bureau of Labor Statistics: Consumer Price Index 1970-2017 http://www.bls.gov/data/ Note: All Urban Consumers Data Table (by metro) CONTACT INFORMATION vitalsigns.info@bayareametro.gov METHODOLOGY NOTES (across all datasets for this indicator) Rent data reflects median rent payments rather than list rents (refer to measure definition above). Larger geographies (metro and county) rely upon ACS 1-year data, while smaller geographies rely upon ACS 5-year rolling average data. 1970 Census data for median rent payments has been imputed by ABAG staff as the source data only provided the mean, rather than the median, monthly rent. Metro area boundaries reflects today’s metro area definitions by county for consistency, rather than historical metro area boundaries. Inflation-adjusted data are presented to illustrate how rent payments have grown relative to overall price increases; that said, the use of the Consumer Price Index does create some challenges given the fact that housing represents a major chunk of consumer goods bundle used to calculate CPI. This reflects a methodological tradeoff between precision and accuracy and is a common concern when working with any commodity that is a major component of CPI itself.
API
Vital Signs: List Rents – by city
data.bayareametro.gov | Last Updated 2018-07-06T18:05:35.000Z
VITAL SIGNS INDICATOR List Rents (EC9) FULL MEASURE NAME List Rents LAST UPDATED October 2016 DESCRIPTION List rent refers to the advertised rents for available rental housing and serves as a measure of housing costs for new households moving into a neighborhood, city, county or region. DATA SOURCE real Answers (1994 – 2015) no link Zillow Metro Median Listing Price All Homes (2010-2016) http://www.zillow.com/research/data/ CONTACT INFORMATION vitalsigns.info@mtc.ca.gov METHODOLOGY NOTES (across all datasets for this indicator) List rents data reflects median rent prices advertised for available apartments rather than median rent payments; more information is available in the indicator definition above. Regional and local geographies rely on data collected by real Answers, a research organization and database publisher specializing in the multifamily housing market. real Answers focuses on collecting longitudinal data for individual rental properties through quarterly surveys. For the Bay Area, their database is comprised of properties with 40 to 3,000+ housing units. Median list prices most likely have an upward bias due to the exclusion of smaller properties. The bias may be most extreme in geographies where large rental properties represent a small portion of the overall rental market. A map of the individual properties surveyed is included in the Local Focus section. Individual properties surveyed provided lower- and upper-bound ranges for the various types of housing available (studio, 1 bedroom, 2 bedroom, etc.). Median lower- and upper-bound prices are determined across all housing types for the regional and county geographies. The median list price represented in Vital Signs is the average of the median lower- and upper-bound prices for the region and counties. Median upper-bound prices are determined across all housing types for the city geographies. The median list price represented in Vital Signs is the median upper-bound price for cities. For simplicity, only the mean list rent is displayed for the individual properties. The metro areas geography rely upon Zillow data, which is the median price for rentals listed through www.zillow.com during the month. Like the real Answers data, Zillow's median list prices most likely have an upward bias since small properties are underrepresented in Zillow's listings. The metro area data for the Bay Area cannot be compared to the regional Bay Area data. Due to afore mentioned data limitations, this data is suitable for analyzing the change in list rents over time but not necessarily comparisons of absolute list rents. Metro area boundaries reflects today’s metro area definitions by county for consistency, rather than historical metro area boundaries. Due to the limited number of rental properties surveyed, city-level data is unavailable for Atherton, Belvedere, Brisbane, Calistoga, Clayton, Cloverdale, Cotati, Fairfax, Half Moon Bay, Healdsburg, Hillsborough, Los Altos Hills, Monte Sereno, Moranga, Oakley, Orinda, Portola Valley, Rio Vista, Ross, San Anselmo, San Carlos, Saratoga, Sebastopol, Windsor, Woodside, and Yountville. Inflation-adjusted data are presented to illustrate how rents have grown relative to overall price increases; that said, the use of the Consumer Price Index does create some challenges given the fact that housing represents a major chunk of consumer goods bundle used to calculate CPI. This reflects a methodological tradeoff between precision and accuracy and is a common concern when working with any commodity that is a major component of CPI itself. Percent change in inflation-adjusted median is calculated with respect to the median price from the fourth quarter or December of the base year.