text:
Tantalus to Waikiki PUMA, HI
Public Use Microdata Area (PUMA)
0.796% 1-year growth
Brian Schatz
Mazie Hirono
2019 Median Age
1.15% 1-year decrease
2019 Poverty Rate
2019 Median Household Income
3.77% 1-year growth
2019 Median Property Value
2019 Employed Population
Housing & Living
In 2019, Tantalus to Waikiki PUMA, HI had a population of 123k people with a median age of 42.8 and a median household income of $63,962. Between 2018 and 2019 the population of Tantalus to Waikiki PUMA, HI grew from 121,547 to 122,514, a 0.796% increase and its median household income grew from $61,641 to $63,962, a 3.77% increase.
The 5 largest ethnic groups in Tantalus to Waikiki PUMA, HI are Asian (Non-Hispanic) (52%), White (Non-Hispanic) (19.3%), Two+ (Non-Hispanic) (13.9%), Native Hawaiian & Other Pacific Islander (Non-Hispanic) (6.18%), and Two+ (Hispanic) (2.71%). 35.4% of the households in Tantalus to Waikiki PUMA, HI speak a non-English language at home as their primary language.
85.9% of the residents in Tantalus to Waikiki PUMA, HI are U.S. citizens.
The largest universities in Honolulu County--Tantalus to Waikiki PUMA, HI are University of Hawaii at Manoa (4,551 degrees awarded in 2019) and Hawaii Medical College (240 degrees).
In 2019, the median property value in Tantalus to Waikiki PUMA, HI was $539,200, and the homeownership rate was 40.6%. Most people in Tantalus to Waikiki PUMA, HI drove alone to work, and the average commute time was 20.8 minutes. The average car ownership in Tantalus to Waikiki PUMA, HI was 1 car per household.
Tantalus to Waikiki PUMA, HI borders Rural Oahu PUMA, HI, Koolaupoko PUMA, HI, East Honolulu to Kapahulu PUMA, HI, and Nuuanu to Kalihi PUMA, HI.
United StatesHawaii
Tantalus to Waikiki PUMA, HI is home to a population of 123k people, from which 85.9% are citizens. As of 2019, 29.1% of Tantalus to Waikiki PUMA, HI residents were born outside of the country (35.7k people).
In 2019, there were 2.7 times more Asian (Non-Hispanic) residents (63.7k people) in Tantalus to Waikiki PUMA, HI than any other race or ethnicity. There were 23.6k White (Non-Hispanic) and 17.1k Two+ (Non-Hispanic) residents, the second and third most common ethnic groups.
The most common foreign languages spoken in Tantalus to Waikiki PUMA, HI are Japanese (11,187 speakers), Chinese (Incl. Mandarin, Cantonese) (8,021 speakers), and Korean (7,594 speakers).
The 3 largest ethnic groups in Tantalus to Waikiki PUMA, HI
Asian (Non-Hispanic)
63.7k ± 1.94k
White (Non-Hispanic)
Two+ (Non-Hispanic)
Hispanic Population
8.08k people
6.59% of the people in Tantalus to Waikiki PUMA, HI are hispanic (8.08k people).
The following chart shows the 7 races represented in Tantalus to Waikiki PUMA, HI as a share of the total population.
Most Common Languages
11,187 speakers (9.55%)
Chinese (Incl. Mandarin, Cantonese)
8,021 speakers (6.85%)
35.4% of Tantalus to Waikiki PUMA, HI citizens are speakers of a non-English language, which is higher than the national average of 22%.
In 2019, the most common non-English language spoken in Tantalus to Waikiki PUMA, HI was Japanese. 9.55% of the overall population of Tantalus to Waikiki PUMA, HI are native Japanese speakers. 6.85% speak Chinese (Incl. Mandarin, Cantonese) and 6.48% speak Korean, the next two most common languages.
Foreign-Born Population
2019 Foreign-Born Population
35k people
As of 2019, 29.1% of Tantalus to Waikiki PUMA, HI residents (35.7k people) were born outside of the United States, which is higher than the national average of 13.7%. In 2018, the percentage of foreign-born citizens in Tantalus to Waikiki PUMA, HI was 28.8%, meaning that the rate has been increasing.
The following chart shows the percentage of foreign-born residents in Tantalus to Waikiki PUMA, HI compared to that of it's neighboring and parent geographies.
Age by Nativity
Median Native-Born Age
Median Foreign-Born Age
± 1.3
In 2019, the median age of all people in Tantalus to Waikiki PUMA, HI was 42.8. Native-born citizens, with a median age of 38, were generally younger than foreign-born citizens, with a median age of 49. But people in Tantalus to Waikiki PUMA, HI are getting getting younger. In 2018, the average age of all Tantalus to Waikiki PUMA, HI residents was 43.
Most Common Origin
7,452 ± 2,054 people
In 2019, the most common birthplace for the foreign-born residents of Tantalus to Waikiki PUMA, HI was Japan, the natal country of 7,452 Tantalus to Waikiki PUMA, HI residents, followed by Korea with 6,819 and China with 4,831.
2019 Citizenship
As of 2019, 85.9% of Tantalus to Waikiki PUMA, HI residents were US citizens, which is lower than the national average of 93.4%. In 2018, the percentage of US citizens in Tantalus to Waikiki PUMA, HI was 85.7%, meaning that the rate of citizenship has been increasing.
The following chart shows US citizenship percentages in Tantalus to Waikiki PUMA, HI compared to that of it's neighboring and parent geographies.
Most Common Service Period
Gulf War (2001-)
2,583 ± 380
Gulf War (1990s)
980 ± 217
Tantalus to Waikiki PUMA, HI has a large population of military personnel who served in Gulf War (2001-), 1.03 times greater than any other conflict.
Daily New Cases by Date
Showing data at the state level for Hawaii. Hospitalization data for some states may be delayed or not reported.
Y-Axis Daily New CasesConfirmed CasesConfirmed Cases per CapitaDeathsDeaths per CapitaTestsHospitalizations
This chart shows the number of COVID-19 daily new cases by date in Hawaii, as a 7-day rolling average, compared with the four states with the most similar number of confirmed cases.
View Full Dashboard
Unemployment Insurance Claims
Data is only available at the state level. Showing data for Hawaii.
This chart shows weekly unemployment insurance claims in Hawaii (not-seasonally adjusted) compared with the four states with the most similar impact.
The most recent data point uses Advance State Claims data, which can be revised in subsequent weeks.
Employment by Industry Sector
Y-Axis Monthly Employees (Non-Seasonally Adjusted)Monthly Growth (Year-over-Year)
Year-over-year growth
Employment change between May 2020 and May 2021
As of May 2021, there are 145M people employed in Hawaii. This represents a 8.45% increase in employment when compared to May 2020.
The following chart shows monthly employment numbers for each industry sector in Hawaii.
Community Mobility
This chart presents movement trends over time in the state of Hawaii across different categories of places such as retail and recreation, groceries and pharmacies, parks, transit stations, workplaces, and residential.
Median household income in Tantalus to Waikiki PUMA, HI is $63,962. In 2019, the PUMA with the highest Median Household Income in Tantalus to Waikiki PUMA, HI was East Honolulu to Kapahulu PUMA, HI with a value of $113,348, followed by Ewa PUMA, HI and Koolaupoko PUMA, HI, with respective values of $107,883 and $107,111.
Males in Tantalus to Waikiki PUMA, HI have an average income that is 1.28 times higher than the average income of females, which is $57,844. The income inequality in Tantalus to Waikiki PUMA, HI (measured using the Gini index) is 0.453, which is lower than than the national average.
The economy of Tantalus to Waikiki PUMA, HI employs 65.5k people. The largest industries in Tantalus to Waikiki PUMA, HI are Restaurants & Food Services (6,505 people), Colleges, universities & professional schools, including junior colleges (3,983 people), and Elementary & secondary schools (3,329 people), and the highest paying industries are Offices of other health practitioners ($126,740), Offices of physicians ($123,297), and Legal services ($122,503).
2019 value
Households in Tantalus to Waikiki PUMA, HI have a median annual income of $63,962, which is less than the median annual income of $65,712 across the entire United States. This is in comparison to a median income of $61,641 in 2018, which represents a 3.77% annual growth.
The following chart shows how the median household income in Tantalus to Waikiki PUMA, HI compares to that of its neighboring and parent geographies.
Wage by Gender in Common Jobs
Average Male Salary in Tantalus to Waikiki PUMA, HI
± $10,727
Average Female Salary in Tantalus to Waikiki PUMA, HI
In 2019, full-time male employees in Tantalus to Waikiki PUMA, HI made 1.28 times more than female employees.
This chart shows the gender-based wage disparity in the 5 most common occupations in Tantalus to Waikiki PUMA, HI by number of full-time employees.
Wage by Race and Ethnicity in Common Jobs
Highest Average Salaries by Race & Ethnicity in Tantalus to Waikiki PUMA, HI
$66,759 ± $12,985
$58,063 ± $8,632
In 2019 the highest paid race/ethnicity of Tantalus to Waikiki PUMA, HI workers was White. These workers were paid 1.15 times more than Asian workers, who made the second highest salary of any race/ethnicity in Tantalus to Waikiki PUMA, HI.
This chart shows the race- and ethnicity-based wage disparities in the 5 most common occupations in Tantalus to Waikiki PUMA, HI by number of full-time employees.
Wage Distribution
2019 Wage GINI in Tantalus to Waikiki PUMA, HI
In 2019, the income inequality in Tantalus to Waikiki PUMA, HI was 0.453 according to the GINI calculation of the wage distribution. Income inequality had a 0.847% growth from 2018 to 2019, which means that wage distribution grew somewhat less even. The GINI for Tantalus to Waikiki PUMA, HI was lower than than the national average of 0.478. In other words, wages are distributed more evenly in Tantalus to Waikiki PUMA, HI in comparison to the national average.
This chart shows the number of workers in Tantalus to Waikiki PUMA, HI across various wage buckets compared to the national average.
Income by Location
Use the dropdown to filter by race/ethnicity.
Race/Ethnicity TotalWhiteBlackNative AmericanAsianPacific IslanderTwo Or MoreWhite Non-HispanicHispanic
Highest Median Household Income (Total)
East Honolulu to Kapahulu PUMA, HI
Ewa PUMA, HI
Koolaupoko PUMA, HI
In 2019, the PUMA with the highest Median Household Income (Total) in Tantalus to Waikiki PUMA, HI was East Honolulu to Kapahulu PUMA, HI with a value of $113,348, followed by Ewa PUMA, HI and Koolaupoko PUMA, HI, with respective values of $107,883 and $107,111.
The following map shows all of the PUMAs in Tantalus to Waikiki PUMA, HI colored by their Median Household Income (Total).
Poverty by Age and Gender
Largest Demographic Living in Poverty
11.9% of the population for whom poverty status is determined in Tantalus to Waikiki PUMA, HI (13.9k out of 117k people) live below the poverty line, a number that is lower than the national average of 12.3%. The largest demographic living in poverty are Females 75+, followed by Females 18 - 24 and then Females 25 - 34.
The Census Bureau uses a set of money income thresholds that vary by family size and composition to determine who classifies as impoverished. If a family's total income is less than the family's threshold than that family and every individual in it is considered to be living in poverty.
Poverty by Race and Ethnicity
Largest Race or Ethnicity Living in Poverty
Two Or More
The most common racial or ethnic group living below the poverty line in Tantalus to Waikiki PUMA, HI is Asian, followed by White and Two Or More.
Employment by Occupations
From 2018 to 2019, employment in Tantalus to Waikiki PUMA, HI grew at a rate of 2.44%, from 63.9k employees to 65.5k employees.
The most common job groups, by number of people living in Tantalus to Waikiki PUMA, HI, are Retail salespersons (2,231 people), Waiters & waitresses (2,165 people), and Firstline supervisors of retail sales workers (1,729 people). This chart illustrates the share breakdown of the primary jobs held by residents of Tantalus to Waikiki PUMA, HI.
The most common jobs held by residents of Tantalus to Waikiki PUMA, HI, by number of employees, are Retail salespersons (2,231 people), Waiters & waitresses (2,165 people), and Firstline supervisors of retail sales workers (1,729 people).
Compared to other PUMAs, Tantalus to Waikiki PUMA, HI has an unusually high number of residents working as Tour & travel guides (14.2 times higher than expected), Firstline enlisted military supervisors (10.1 times), and Residential advisors (7.72 times).
The highest paid jobs held by residents of Tantalus to Waikiki PUMA, HI, by average salary, are Physicians ($219,880), Chief executives & legislators ($198,291), and Firstline supervisors of nonretail sales workers ($152,189).
Employment by Industries
The most common employment sectors for those who live in Tantalus to Waikiki PUMA, HI, are Restaurants & Food Services (6,505 people), Colleges, universities & professional schools, including junior colleges (3,983 people), and Elementary & secondary schools (3,329 people). This chart shows the share breakdown of the primary industries for residents of Tantalus to Waikiki PUMA, HI, though some of these residents may live in Tantalus to Waikiki PUMA, HI and work somewhere else. Census data is tagged to a residential address, not a work address.
The most common industries in Tantalus to Waikiki PUMA, HI, by number of employees, are Restaurants & Food Services (6,505 people), Colleges, universities & professional schools, including junior colleges (3,983 people), and Elementary & secondary schools (3,329 people).
Compared to other PUMAs, Tantalus to Waikiki PUMA, HI has an unusually high number of Scenic & sightseeing transportation (11.9 times higher than expected), Travel arrangements & reservation services (8.9 times), and Jewelry, luggage, & leather goods stores (7.22 times) industries.
Highest Paying
The highest paying industries in Tantalus to Waikiki PUMA, HI, by average salary, are Offices of other health practitioners ($126,740), Offices of physicians ($123,297), and Legal services ($122,503).
Domestic Trade
Domestic Production & Consumption
Domestic production and consumption consists of products and services shipped from Hawaii to other states, or from other states to Hawaii.
Domestic Production in DollarsDomestic Production in TonnageDomestic Consumption in DollarsDomestic Consumption in Tonnage
Top Domestic Production in Dollars
Fuel oils
Crude petroleum
In 2018, the top outbound Hawaii product (by dollars) was Fuel oils with $5.5B, followed by Gasoline ($5.17B) and Crude petroleum ($3.46B).
The following chart shows the share of these products in relation to all outbound Hawaii products.
Domestic Trade Growth
Showing data for Hawaii.
2018 Value in Hawaii
Projected 2045 Value in Hawaii
41% growth
In 2018, total outbound Hawaii trade was $31.6B. This is expected to increase 41% to $44.5B by 2045.
The following chart shows how the domestic outbound Hawaii trade is projected to change in comparison to its neighboring states.
Interstate Trade
Interstate trade consists of products and services shipped from Hawaii to other states, or from other states to Hawaii.
Most Common Trade Partners
$129M
In 2018, the top outbound Hawaii domestic partner for goods and services (by dollars) was California with $1.32B, followed by Texas with $129M and Washington and $79.2M.
The following map shows the amount of trade that Hawaii shares with each state (excluding itself).
In the 2016 presidential election, the popular vote in Hawaii went to Hillary Rodham Clinton with 61% of the vote. The runner-up was Donald J. Trump (29.4%), followed by Gary Johnson (3.65%). The most partisan county was Maui County, HI with 64.5% of the vote going to Hillary Rodham Clinton running for the Democratic Party.
Brian Schatz and Mazie Hirono are the senators currently representing the state of Hawaii. In the United States, senators are elected to 6-year terms with the terms for individual senators staggered.
Hawaii is currently represented by 2 members in the U.S. house, and members of the House of Representives are elected to 2-year terms.
Presidential Popular Vote Over Time
Voting results are not available for Tantalus to Waikiki PUMA, HI. Showing the available data for Hawaii.
Showing data up to the 2016 election. Updated election results are currently being processed, and will be released in the coming months.
Hillary Rodham Clinton (61%)
Donald J. Trump (29.4%)
Gary Johnson (3.65%)
In the 2016 presidential election, the popular vote in Hawaii went to Hillary Rodham Clinton with 61% of the vote. The runner-up was Donald J. Trump (29.4%), followed by Gary Johnson (3.65%).
The following chart shows the popular vote results in Hawaii for each registered party from 1976 to 2016.
Presidential Popular Vote by County
Presidential voting results are only available at the county level. Showing data for the counties inside of Hawaii.
Popular Vote for Hawaii
61% for the Democratic Party
Most Partisan Counties in Hawaii
Maui County, HI
64.5% for Hillary Rodham Clinton (Democratic Party)
Hawaii County, HI
Kauai County, HI
In the 2016 presidential election, the most partisan county in Hawaii was Maui County, HI with 64.5% of the vote going to Hillary Rodham Clinton running for the Democratic Party.
The following map shows the counties in Hawaii colored by their party leaning.
US Senators from Hawaii
Senatorial voting results are only available at the state level. Showing data for Hawaii.
Senator from Hawaii3
Assumed office on December 26, 2012
Appointed to the seat following the death of Daniel Inouye.
Assumed office on January 3, 2013
Brian Schatz and Mazie Hirono are the senators currently representing Hawaii.
In the United States, senators are elected to 6-year terms with the terms for individual senators staggered.
The following chart shows elected senators in Hawaii over time, excluding special elections, colored by their political party.
US Representatives from Hawaii
Hawaii is currently represented by 2 members in the U.S. house.
Members of the House of Representives are elected to 2-year terms, and the following chart shows the how the members for Hawaii have changed over time starting in 2008.
In 2019, universities in Honolulu County--Tantalus to Waikiki PUMA, HI awarded 4,791 degrees. The student population of Honolulu County--Tantalus to Waikiki PUMA, HI is skewed towards women, with 7,290 male students and 10,826 female students.
Most students graduating from Universities in Honolulu County--Tantalus to Waikiki PUMA, HI are Asian (1,788 and 39.8%), followed by Two or More Races (1,096 and 24.4%), White (915 and 20.4%), and Hispanic or Latino (421 and 9.37%).
The largest universities in Honolulu County--Tantalus to Waikiki PUMA, HI by number of degrees awarded are University of Hawaii at Manoa (4,551 and 95%) and Hawaii Medical College (240 and 5.01%).
The most popular majors in Honolulu County--Tantalus to Waikiki PUMA, HI are General Psychology (199 and 4.15%), General Business Administration & Management (199 and 4.15%), and Kinesiology & Exercise Science (158 and 3.3%).
The median tuition cost in Honolulu County--Tantalus to Waikiki PUMA, HI for a public four year colleges is $11,304 for in-state students and $33,336 for out-of-state students.
1 to 2 Year Postsecondary CertificateAssociates DegreeBachelors DegreePostbaccalaureate CertificateMasters DegreeResearch DoctorateProfessional Doctorate
Kinesiology & Exercise Science
144 degree-majorss awarded
Speech Communication & Rhetoric
In 2019, the most common concentation for Bachelors Degree recipients in Honolulu County--Tantalus to Waikiki PUMA, HI was Kinesiology & Exercise Science with 144 degrees awarded.
This visualization illustrates the percentage of students graduating with a Bachelors Degree from schools in Honolulu County--Tantalus to Waikiki PUMA, HI according to their major.
Largest Universities by degrees awarded
University of Hawaii at Manoa
4,551 degrees awarded
Hawaii Medical College
In 2019, the Honolulu County--Tantalus to Waikiki PUMA, HI institution with the largest number of graduating students was University of Hawaii at Manoa with 4,551 degrees awarded.
Student Gender for Common Institutions
Degrees Awarded to Men
Degrees Awarded to Women
In 2019, 1,877 men were awarded degrees from institutions in Honolulu County--Tantalus to Waikiki PUMA, HI, which is 0.644 times less than the 2,914 female students who received degrees in the same year.
This chart displays the gender disparity between the institutions in Honolulu County--Tantalus to Waikiki PUMA, HI by degrees awarded.
Student Race and Ethnicity
Most Common Student Race or Ethnicity
In 2019 the most common race/ethnicity group awarded degrees at institutions in Honolulu County--Tantalus to Waikiki PUMA, HI was Asian students. These 1,788 degrees mean that there were 1.63 times more degrees awarded to Asian students then the next closest race/ethnicity group, Two or More Races, with 1,096 degrees awarded.
The median property value in Tantalus to Waikiki PUMA, HI was $539,200 in 2019, which is 2.24 times larger than the national average of $240,500. Between 2018 and 2019 the median property value increased from $516,800 to $539,200, a 4.33% increase. The homeownership rate in Tantalus to Waikiki PUMA, HI is 40.6%, which is lower than the national average of 64.1%. People in Tantalus to Waikiki PUMA, HI have an average commute time of 20.8 minutes, and they drove alone to work. Car ownership in Tantalus to Waikiki PUMA, HI is lower than the national average, with an average of 1 car per household.
2019 Median
In 2019, the median property value in Tantalus to Waikiki PUMA, HI grew to to $539,200 from the previous year's value of $516,800.
The following charts display, first, the property values in Tantalus to Waikiki PUMA, HI compared to it's parent and neighbor geographies and, second, owner-occupied housing units distributed between a series of property value buckets compared to the national averages for each bucket. In Tantalus to Waikiki PUMA, HI the largest share of households have a property value in the $500k - $750k range.
Please note that the buckets used in this visualization were not evenly distributed by ACS when publishing the data.
In 2019, the median household income of the 57.1k households in Tantalus to Waikiki PUMA, HI grew to $63,962 from the previous year's value of $61,641.
The following chart displays the households in Tantalus to Waikiki PUMA, HI distributed between a series of income buckets compared to the national averages for each bucket. The largest share of households have an income in the $75k - $100k range.
Average Range
This chart shows the households in Tantalus to Waikiki PUMA, HI distributed between a series of property tax buckets compared to the national averages for each bucket. In Tantalus to Waikiki PUMA, HI the largest share of households pay taxes in the $800 - $1,499 range.
2019 Homeownership
In 2019, 40.6% of the housing units in Tantalus to Waikiki PUMA, HI were occupied by their owner. This percentage grew from the previous year's rate of 40.4%.
This percentage of owner-occupation is lower than the national average of 64.1%. This chart shows the ownership percentage in Tantalus to Waikiki PUMA, HI compared it's parent and neighboring geographies.
20.8 minutes
Average Travel Time
Using averages, employees in Tantalus to Waikiki PUMA, HI have a shorter commute time (20.8 minutes) than the normal US worker (25.5 minutes). Additionally, 1.04% of the workforce in Tantalus to Waikiki PUMA, HI have "super commutes" in excess of 90 minutes.
The chart below shows how the median household income in Tantalus to Waikiki PUMA, HI compares to that of it's neighboring and parent geographies.
Commuter Transportation
Most Common Commute in 2019
Drove Alone (53.3%)
Walked (13.8%)
Carpooled (11.3%)
In 2019, 53.3% of workers in Tantalus to Waikiki PUMA, HI drove alone to work, followed by those who walked to work (13.8%) and those who carpooled to work (11.3%).
The following chart shows the number of households using each mode of transportation over time, using a logarithmic scale on the y-axis to help better show variations in the smaller means of commuting.
Car Ownership
Average Number
The following chart displays the households in Tantalus to Waikiki PUMA, HI distributed between a series of car ownership buckets compared to the national averages for each bucket. The largest share of households in Tantalus to Waikiki PUMA, HI have 1 car, followed by false.
95.7% of the population of Tantalus to Waikiki PUMA, HI has health coverage, with 53.8% on employee plans, 10.2% on Medicaid, 13.9% on Medicare, 15.7% on non-group plans, and 2.07% on military or VA plans.
Per capita personal health care spending in Hawaii was $7,299 in 2014. This is a 4.95% increase from the previous year ($6,955).
Primary care physicians in Hawaii see 1127 patients per year on average, which represents a 1.31% decrease from the previous year (1142 patients). Compare this to dentists who see 1110 patients per year, and mental health providers who see 383 patients per year.
Comparing across all counties in the state, Honolulu County has the highest prevalence of diabetes (11.3%). Additionally, Hawaii County has the highest prevalence of adult obesity (25.8%)
Patient to Clinician Ratios
Patient to Primary Care Physician RatioPatient to Dentist RatioPatient to Mental Health Provider RatioOther Primary Care Providers
1,127 to 1
Patient to Primary Care Physician Ratio in Hawaii
Primary care physicians in Hawaii see an average of 1,127 patients per year. This represents a 1.31% decrease from the previous year (1,142 patients).
The following chart shows how the number of patients seen by primary care physicians has been changing over time in Hawaii in comparison to its neighboring geographies.
Behavioral Health Conditions
Data only available at the state level.
Adults With Major Depressive EpisodeAdults With Serious Mental IllnessOpioid Overdose Death RateSubstance Use Disorder Among Adolescents and Adults (Age 12+)Drug Overdose Death RateExcessive Drinking
State with the Highest Prevalence
8.26% of the population affected
In 2016, West Virginia had the highest prevalence of adults with major depressive episode, with 8.26% of the population affected. The second highest is Arkansas (8.13%), followed by New Hampshire (7.98%).
The following map shows the percent of individuals with major depressive episode by state over multiple years.
Estimated Number of Chronically Homeless IndividualsPercent of Residents with Access To Exercise OpportunitiesPrevalence of Food InsecurityPercent of Occupied Households Lacking Complete Plumbing FacilitiesPercent of Occupied Households Lacking Complete Kitchen FacilitiesPercent of Households Lacking Internet Access
Most prevalent states
35,798 individuals
5,087 individuals
In 2017, California had the highest estimated number of chronically homeless individuals in the nation, at 35,798. New York has the second highest (5,087), followed by Florida (4,915).
The following map shows the estimated number of chronically homeless individuals by state over multiple years.
Access and Quality
Data only available at state level.
Adults Who Haven't Seen a Doctor in the Past 12 Months Due to CostMental Health Service Use Among Adults With Mental Illness30-Day Hospital Readmission Rate Among Medicare PatientsAdult Hospice Patients Who Received Care Consistent With Their End-Of-Life Wishes
19.2% of adults
In 2016, Mississippi had the highest prevalence of adults who haven't seen a doctor in the past 12 months due to cost, at 19.2%. It is followed by Texas (17.9%) and Louisiana (17.6%).
The following map shows the prevalence of adults who haven't seen a doctor in the past 12 months due to cost by state over multiple years.
Health Care Spending
Total Per Capita Spending on Personal Health Care in Hawaii
Per Enrollee Private Health Insurance Spending on Personal Health Care
Per Enrollee Medicaid Spending on Personal Health Care
Per Enrollee Medicare Spending on Personal Health Care
Between 2013 and 2014, all personal health care spending per capita in Hawaii (including private, Medicare, and Medicaid) grew 4.95%, from $6,955 to $7,299.
The following chart shows how this spending changed over time in comparison to Medicaid, Medicare, and private insurance spending, per enrollee.
Health Care Coverage
Employer Coverage
Non-Group
Military or VA
Between 2018 and 2019, the percent of uninsured citizens in Tantalus to Waikiki PUMA, HI declined by 8.69% from 4.75% to 4.34%.
The following chart shows how the percent of uninsured individuals in Tantalus to Waikiki PUMA, HI changed over time compared with the percent of individuals enrolled in various types of health insurance.
Data available at the county level.
DiabetesAdult ObesityHIV DiagnosesSexually Transmitted InfectionsAdult SmokingAlcohol-Impaired Driving DeathsMotor Vehicle Crash DeathsHomicidesViolent Crimes
Most at risk counties
11.3% prevalence
Honolulu County has the highest prevalence of diabetes in Hawaii, at 11.3%.
The following map shows the prevalence of diabetes in Hawaii by county over multiple years.
Nuuanu to Kalihi PUMA, HI
Rural Oahu PUMA, HI
Honolulu County, HI


text:
Case Study 129
Andrew is driving a 12 tonne rigid lorry for a general haulage firm delivering pallets to different destinations throughout the UK. It's the middle of January, and the temperature is -3c with ice on the roads.
Andrew starts his shift at 9 am and stops at a service station at 12:00 pm for a 30 minute rest and to buy a drink. On his way back to the depot, he is involved in an accident.
Andrew finishes work at 14:30 pm
Andrew is driving to his first delivery, and the warning light appears indicating low air pressure in the braking system
What action should he take?
Bring the vehicle to a safe stop as soon as possible
Rev the engine
Use the service parking brake to stop the vehicle
Continue to his next delivery destination and check the problem when he arrives
Which type of drink will keep Andrew hydrated the most?
It's now 13:00 pm and Andrew has decided to stop for a break.
How long will Andrew be required to stop for to complete his 45 minute rest period
On his way back to the depot, Andrew has hit and damaged a farm gate while negotiating a bend on a quiet country road.
What could have contributed to this accident?
Ice on the roads
Heavy traffic
Andrew is unable to locate the owner of the farm gate.
He must
Report the incident to the police within 24 hours
Report the incident to local council within 24 hours
Report the incident to the police within seven days
What type of licence does Andrew require to drive his truck?
C+E

redpajama_set_name: RedPajamaCommonCrawl


text:
Q: i18n in ExtJS & Spring MVC I've searched a bit on the web but haven't really found a concrete solution to internationalize an application running ExtJS & Spring MVC. Currently (for testing), I define global javascript variables in the JSP's & assign the string literals using JSTL tags.
Has anyone had any success in coming up w/ a clear/clean/flexible solution on this?
Any thoughts are really appreciated. TIA.

A: There are 3 types of strings that you should translate in an application

*

*Static strings on you page -> as Adam said using a template is a good idea. MVC can solve the problem. So you keep all your strings in a db or a properties file.

*Error messages strings that are send to Ext J.S -> Here you have two solutions, either you allow Ext J.S to handle them , so this means that you have js files with the translations loaded
OR
on the MVC before you send the reply you add the translation on your response

*Values from a db table that must be translated, e.g car parts. In this case you keep the key in you car_parts table and the translations in a properties file or on a translation table in db.
On my current app I perform the translation on the MVC level and I keep the translations on the db. The advantage are
1. The translation logic is one place the MVC and not split.
2. Your translations are in one place and whenever you make an error on a translation you do not have to make a new release, you just update the db OR you provide a form on the application admins to do it on their own. Backup of the translation table is required!!!

A: This is how it is done in my application, which is using Pylons, Ext JS and a template engine called Mako.
I'm treating JavaScript files as templates. I keep each class in a separate file and use a defined by me function require() to handle dependencies. My server processes these templates, handles dependencies, joins them together and compresses. Those templates contain calls to gettext-like function "_" e.g.:
window.setTitle("${_('My title')}");

These templates are regular Mako templates and can be preprocessed by a gettext-like utility to create .po files. The .po generator I'm using (Babel) puts positions of found strings as comments inside a .po file, which is convenient for me, because I know where the string appeared.

A: Take a look at the Spring MVC Ajax example frpm Spring.
if you use JSP views, you can use fmt tag library and resource bundles.
If you use Velocity views, use #springMessage('my.key') as explained in Spring documentation.

redpajama_set_name: RedPajamaStackExchange


Electroplated Golden Finish idol of Goddess Durga, ideal for puja room and car dashboard.
This product is currently out of stock. Please check again later.
Legacy of three generations in original fragrance creation.
Strict adherence to fair trade and ethical business practices.
Cycle.in is a one stop store bringing to you the best fragrance products from the unsurpassed leaders in the industry. Discover an array of handpicked products and accessories associated with prayer requirements, personal care, air care and lifestyle products.
Copyright © 2018, Cycle, All Rights Reserved.


Well, Mr. Paladino — the no nonsense guy; the guy who can't be pushed around — had me completely fooled. What he had us thinking is that he, and his not-very-well-know-or-established-Rabbi friend who fancies himself head of a Hassidic Tea Party, were simply professing their mutual concern about the gay menace.
But now it turns out, according to Carl, that he wasn't acting on his free will at all, but instead, that he was reading a statement somehow foisted on him by the bearded-and-jacketed-ones. In other words, looking back at what was supposed to be a routine campaign photo, what this actually is (like one of those terrorist videos) is … a hostage taking.


text:
Harry B. Stearns1
b. 2 February 1895, d. 1 March 1969
Father William R. Stearns1
Mother Alice A. Wallace1 b. 28 Dec 1873, d. 12 May 1951
Charts Descendants of Jacob Tarr
Harry B. Stearns was born on 2 February 1895 in Petroleum Centre, Cornplanter Township, Venango County, Pennsylvania.1,2 He was the son of William R. Stearns and Alice A. Wallace.1 He married Velma Robishaw in 1924.2 He died on 1 March 1969 in Franklin Hospital, Sugarcreek Borough, Venango County, Pennsylvania, at age 74.2 He was buried in Sunville Cemetery, Sunville, Plum Township, Venango County, Pennsylvania.2
Velma Robishaw
[S152] 1900 U.S. Census, Pennsylvania, Crawford Co., Troy Tp., William Stearns household, National Archives, (William Stearns, Apr 1867, PA/PA/NY, md10y, laborer; Alice A., Dec 1874, PA/Ire/PA, 6child/6lvg; Ollive L., Feb 1891, PA/PA/PA, dau; Ida E., Apr 1893, PA/PA/PA, dau; Harry B., Feb 1895, PA/PA/PA, son; Laurie N., Dec 1896, PA/PA/PA, dau; Clarence O., Oct 1898, PA/PA/PA, son; Charles E., Mar 1900, PA/PA/PA, son).
[S8] Obituary of Harry B. Stearns, The Oil City Derrick, Oil City, PA, 3 Mar 1969, p. 2, Oil City Library, Oil City, Venango County, Pennsylvania. Hereinafter cited as The Derrick.
Clarence O. Stearns1
b. October 1898
Clarence O. Stearns was born in October 1898 in Pennsylvania.1 He was the son of William R. Stearns and Alice A. Wallace.1
Laurie Naomi Stearns1
b. December 1896
Laurie Naomi Stearns was born in December 1896 in Pennsylvania.1 She was the daughter of William R. Stearns and Alice A. Wallace.1
Charles E. Stearns1
Charles E. Stearns was born on 24 March 1900 in Neiltown, Forest County, Pennsylvania.1,2 He was the son of William R. Stearns and Alice A. Wallace.1 He married Irene Watson on 19 May 1926 in Titusville, Crawford County.2 He died on 29 August 1977 in Titusville, Crawford County, Pennsylvania, at age 77.2 He was buried in Jerusalem Corners Cemetery, Cherrytree Township, Venango County, Pennsylvania.2
Irene Watson
[S272] Obituary of Charles E. Stearns, Titusville Herald, Titusville, PA, 30 Aug 1977, p. 5. Hereinafter cited as Titusville Herald.
Frank Stearns1
Frank Stearns is the son of William R. Stearns and Alice A. Wallace.1
[S207] 1910 U.S. Census, Pennsylvania, Forest Co., Harmony Tp., William Stearns household, National Archives, (William Stearns, 53, PA/PA/NY, md18y, laborer, sawmill; Alice A., 35, PA/Ire/WI, 10child/8lvg; Naomi, 13, PA/PA/PA, dau; Clarence, 11, PA/PA/PA, son; Charles, 10, PA/PA/PA, son; Frank, 6, PA/PA/PA, son; Ralph, 5, PA/PA/PA, son; Alfred, 1 1/12, PA/PA/PA, son).
Ralph Stearns1
Ralph Stearns is the son of William R. Stearns and Alice A. Wallace.1
Alfred Stearns1
Alfred Stearns is the son of William R. Stearns and Alice A. Wallace.1
Burton W. Brown1
b. 14 January 1914, d. 5 January 1980
Father Zephania Brown1
Burton W. Brown was born on 14 January 1914 in Titsuville, Crawford County, Pennsylvania.1,2 He was the son of Zephania Brown and Alice A. Wallace.1 He married Velma Robishaw on 9 December 1970 in New Castle, Lawrence County, Pennsylvania.2 He died on 5 January 1980 in Hamot Medical Center, Erie, Erie County, Pennsylvania, at age 65.2 He was buried in Diamond Cemetery, Plum Township, Venango County, Pennsylvania.2
[S433] 1920 U.S. Census, Pennsylvania, Crawford Co., Titusville, Alice Sterns household, National Archives, (Alice Sterns, 46, PA/Ire/Ire, wd; Charles, 26, PA/PA/PA, son; Berton, 6, PA/PA/PA, son; Alice, 2 3/12, PA/PA/PA, dau).
[S272] Obituary of Burton W. Brown, Titusville Herald, Titusville, PA, 7 Jan 1980. Hereinafter cited as Titusville Herald.
Alice G. Brown1
b. 6 April 1917, d. 28 July 1985
Alice G. Brown was born on 6 April 1917 in Troy Township, Crawford County, Pennsylvania.1,2 She was the daughter of Zephania Brown and Alice A. Wallace.1 She married Gard L. Proper on 23 January 1931 in Troy Township, Crawford County, Pennsylvania.2 She died on 28 July 1985 in Titsuville, Crawford County, Pennsylvania, at age 68.2 She was buried in Troy Center Cemetery, Troy Center, Troy Township, Crawford County, Pennsylvania.2
Alice G. Brown was known as Eva Brown.1
Gard L. Proper d. 1 Feb 1971
[S969] 1930 U.S. Census, Pennsylvania, Crawford Co., Richmond Tp., Jerome C. Crawford household, National Archives, (Jerome C. Crawford, 45, PA/PA/PA, farming, dairy farm; Alice A., 55, PA/PA/PA; Berton B. Brown, 16, PA/PA/PA, step-son; Eva B. Brown, 13, PA/PA/PA, step-dau).
[S272] Obituary of Alice Proper Hollabaugh, Titusville Herald, Titusville, PA, 29 Jul 1985. Hereinafter cited as Titusville Herald.
Gard L. Proper1
d. 1 February 1971
Gard L. Proper married Alice G. Brown, daughter of Zephania Brown and Alice A. Wallace, on 23 January 1931 in Troy Township, Crawford County, Pennsylvania.1 He died on 1 February 1971.1
Alice G. Brown b. 6 Apr 1917, d. 28 Jul 1985
Velma Robishaw1
Charts Descendants of Jacob Tarr (#1)
Descendants of Jacob Tarr (#2)
Velma Robishaw married Harry B. Stearns, son of William R. Stearns and Alice A. Wallace, in 1924.1 She married Burton W. Brown, son of Zephania Brown and Alice A. Wallace, on 9 December 1970 in New Castle, Lawrence County, Pennsylvania.2
Harry B. Stearns b. 2 Feb 1895, d. 1 Mar 1969
Burton W. Brown b. 14 Jan 1914, d. 5 Jan 1980
Irene Watson1
Irene Watson married Charles E. Stearns, son of William R. Stearns and Alice A. Wallace, on 19 May 1926 in Titusville, Crawford County.1
Charles E. Stearns b. 24 Mar 1900, d. 29 Aug 1977
Sarah Morrison1
b. 26 November 1824, d. 30 April 1909
Father Joseph Morrison1,2 b. c 1802, d. 21 Feb 1874
Mother Ann Beatty1,2 b. c 1802, d. bt 1860 - 1870
Sarah Morrison was born on 26 November 1824 in Venango County, Pennsylvania.2,1,3 She was the daughter of Joseph Morrison and Ann Beatty.1,2 She married Washington Karns.1 She died on 30 April 1909 in Jackson Township, Venango County, Pennsylvania, at age 84.2 She was buried in Cooperstown Cemetery, Cooperstown, Jackson Township.2
Washington Karns
Ella Margaret Karns4 b. c 1852, d. 10 Sep 1930
Chalmers W. Karns+4 b. 30 Jan 1852, d. 28 Jan 1934
Anna Viola Karns3 b. Feb 1853, d. 2 Nov 1925
Joseph M. Karns+3 b. Aug 1858
Sarah C. Karns5 b. c 1861
George D. Karns+5 b. Oct 1864, d. 1938
[S1456] Warren County Intestate Docket, 1:32-33 (Estate of Joseph Morrison), Registrar & Recorder's Office, Courthouse, Warren, Pennsylvania.
[S1462] Sarah Karns, Pennsylvania Death Certificate 33648 (4 May 1909), (informant: Chalmers W. Karns), viewed at Ancestry.com, online www.ancestry.com, accessed 18 Apr 2014; original at Pennsylvania Dept. of Health, Division of Vital Records, New Castle, PA.
[S152] 1900 U.S. Census, Pennsylvania, Venango Co., Jackson Tp., Joseph Karns household, National Archives, (Joseph Karns, Aug 1858, PA/PA/PA, md1y, farmer; Laura, Sep 1865, PA/PA/PA, 0child; Sarah, Nov 1824, PA/PA/PA, wd, 6child/5lvg, mother; Annie, Feb 1853, PA/PA/PA, sister).
[S155] 1860 U.S. Census, Pennsylvania, Venango Co., Jackson Tp., Washn Carnes household, National Archives, (Washn Carnes, 35, PA, farmer; Sarah, 34, PA; Chalmers, 9, PA; Margaret, 8, PA; Viola, 6, PA; Joseph H., 2, PA).
[S151] 1880 U.S. Census, Pennsylvania, Venango Co., Jackson Tp., Washington Karnes household, National Archives, (Washington Karnes, 56, PA/PA/PA, farmer; Sary, 56, PA/PA/PA; Ella, 28, PA/PA/PA, dau, teaches school; Viola A., 26, PA/PA/PA, dau, without occ.; Joseph M., 21, PA/PA/PA, son, works on farm; Sary S., 19, PA/PA/PA, dau, without occ.; George D., 15, PA/PA/PA, son, works on farm; next household: Chalmers Karnes, 28, PA/PA/PA, farmer; Mary E., 28, PA/PA/PA, wife; no name Bower, 7/12 (Nov), PA/PA/PA, neace).
Washington Karns1
Washington Karns married Sarah Morrison, daughter of Joseph Morrison and Ann Beatty.1
Sarah Morrison b. 26 Nov 1824, d. 30 Apr 1909
Chalmers W. Karns1
b. 30 January 1852, d. 28 January 1934
Father Washington Karns1
Mother Sarah Morrison1 b. 26 Nov 1824, d. 30 Apr 1909
Chalmers W. Karns was born on 30 January 1852 in Venango County, Pennsylvania.1,2 He was the son of Washington Karns and Sarah Morrison.1 He married Mary E. Bowers circa 1880.3,4 He died on 28 January 1934 in Franklin, Venango County, Pennsylvania, at age 81.1 He was buried in Franklin Cemetery, Sugarcreek Township, Venango County, Pennsylvania.1
Chalmers W. Karns and Mary E. Bowers raised Mary's niece Gertrude Bowers.5,4 He was a carpenter in Jackson Township and Franklin, Venango County, Pennsylvania.4,6
Mary E. Bowers b. Mar 1851
Gertrude (Bowers) Karns4 b. Mar 1879
[S8] Obituary of Chalmers W. Karns, The Oil City Derrick, Oil City, PA, 29 Jan 1934, p. 9, Oil City Library, Oil City, Venango County, Pennsylvania. Hereinafter cited as The Derrick.
[S152] 1900 U.S. Census, Pennsylvania, Venango Co., Jackson Tp., Chalmers Karns household, National Archives, (Chalmers Karns, Aug 1850, PA/PA/PA, md20y, house carpenter; Mary E., Mar 1851, PA/PA/PA, wife, 1child/1lvg; Gertude, Mar 1879, PA/PA/PA, dau).
[S151] 1880 U.S. Census, Pennsylvania, Venango Co., Jackson Tp., Chalmers Karnes household, National Archives, (Chalmers Karnes, 28, PA/PA/PA, farmer; Mary E., 28, PA/PA/PA, wife; no name Bower, 7/12 (Nov), PA/PA/PA, neace).
[S207] 1910 U.S. Census, Pennsylvania, Venango Co., Franklin, Chalmers W. Karns household, National Archives, (Chalmers W. Karns, 59, PA/PA/PA, md33y, carpenter, odd jobs; Mary E., 59, PA/PA/PA, wife, 0child/0lvg).
Mary E. Bowers1
b. March 1851
Mary E. Bowers was born in March 1851 in Pennsylvania.2 She married Chalmers W. Karns, son of Washington Karns and Sarah Morrison, circa 1880.1,2
Mary E. Bowers and Chalmers W. Karns raised Mary's niece Gertrude Bowers.3,2
Chalmers W. Karns b. 30 Jan 1852, d. 28 Jan 1934
Gertrude (Bowers) Karns1
Father Chalmers W. Karns1 b. 30 Jan 1852, d. 28 Jan 1934
Mother Mary E. Bowers1 b. Mar 1851
Gertrude (Bowers) Karns was born in March 1879 in Pennsylvania.1 She was the daughter of Chalmers W. Karns and Mary E. Bowers.1 She married Albert O. Law on 1 November 1905 in Franklin, Venango County, Pennsylvania.2
Gertrude was raised by her uncle and aunt Chalmers and Mary Karns.3,1
Albert O. Law
[S10] Venango County (PA) Marriage License, Gertrude B. Karns and Albert O. Law, Registrar & Recorder's Office, Courthouse, Franklin, Venango County, Pennsylvania.
Albert O. Law1
Albert O. Law married Gertrude (Bowers) Karns, daughter of Chalmers W. Karns and Mary E. Bowers, on 1 November 1905 in Franklin, Venango County, Pennsylvania.1
Gertrude (Bowers) Karns b. Mar 1879
Ella Margaret Karns1,2
b. circa 1852, d. 10 September 1930
Ella Margaret Karns was born circa 1852 in Venango County, Pennsylvania.1 She was the daughter of Washington Karns and Sarah Morrison.1 She married John Wilson Slonaker on 24 December 1889 in Franklin, Venango County, Pennsylvania.3 She died on 10 September 1930 in Rochester, Olmsted, Minnesota.4
Ella Margaret Karns was a school teacher prior to her marriage.2
John Wilson Slonaker
[S10] Venango County (PA) Marriage License, Ella Karns and John Wilson Slonaker, Registrar & Recorder's Office, Courthouse, Franklin, Venango County, Pennsylvania.
[S1273] "Minnesota, Deaths and Burials, 1835-1990," index, Mrs Ella K. Slonaker, viewed at FamilySearch (familysearch.org), (parents Washington Karns and Sarah Morrison).
John Wilson Slonaker1
John Wilson Slonaker married Ella Margaret Karns, daughter of Washington Karns and Sarah Morrison, on 24 December 1889 in Franklin, Venango County, Pennsylvania.1
Ella Margaret Karns b. c 1852, d. 10 Sep 1930
Anna Viola Karns1
b. February 1853, d. 2 November 1925
Anna Viola Karns was born in February 1853 in Jackson Township, Venango County, Pennsylvania.1,2 She was the daughter of Washington Karns and Sarah Morrison.1 She was unmarried.2 She died on 2 November 1925 in Jackson Township at age 72.2
[S8] Obituary of Miss Anna Viola Karns, The Oil City Derrick, Oil City, PA, 3 Nov 1925, p. 11, Oil City Library, Oil City, Venango County, Pennsylvania. Hereinafter cited as The Derrick.
Joseph M. Karns1
b. August 1858
Joseph M. Karns was born in August 1858 in Venango County, Pennsylvania.1 He was the son of Washington Karns and Sarah Morrison.1 He married Laura A. Weed on 13 March 1900 in New Albany, Bradford County, Pennsylvania.2
Laura A. Weed b. Sep 1865
Jennie Karns3 b. 21 Dec 1901, d. 9 May 1962
Clyde W. Karns+3 b. 25 Apr 1903, d. Apr 1979
[S1273] Marriage License of Joseph M. Karns and Laura A. Weed, Bradford Co., PA, "Pennsylvania, County Marriages, 1885-1950," index and images,, viewed at FamilySearch (familysearch.org).
[S8] "Mrs. Lepley, Ex-Teacher, Succumbs", The Oil City Derrick, Oil City, PA, 10 May 1962, p. 13, Oil City Library, Oil City, Venango County, Pennsylvania. Hereinafter cited as The Derrick.
Laura A. Weed1
b. September 1865
Laura A. Weed was born in September 1865 in Pennsylvania.2 She married Joseph M. Karns, son of Washington Karns and Sarah Morrison, on 13 March 1900 in New Albany, Bradford County, Pennsylvania.1
Joseph M. Karns b. Aug 1858
Jennie Karns1
b. 21 December 1901, d. 9 May 1962
Father Joseph M. Karns1 b. Aug 1858
Mother Laura A. Weed1 b. Sep 1865
Jennie Karns was born on 21 December 1901 in Cooperstown, Jackson Township, Venango County, Pennsylvania.1 She was the daughter of Joseph M. Karns and Laura A. Weed.1 She married Robert Lepley in November 1954 in Oil City, Venango County.1 She died on 9 May 1962 in Franklin Hospital, Sugarcreek Township, Venango County, Pennsylvania, at age 60.1 She was buried in Cooperstown Cemetery, Cooperstown, Jackson Township.1
Jennie Lepley had no children.1
Robert Lepley
Robert Lepley1
Robert Lepley married Jennie Karns, daughter of Joseph M. Karns and Laura A. Weed, in November 1954 in Oil City, Venango County.1
Jennie Karns b. 21 Dec 1901, d. 9 May 1962
Clyde W. Karns1
b. 25 April 1903, d. April 1979
Clyde W. Karns was born on 25 April 1903 in Pennsylvania.2 He was the son of Joseph M. Karns and Laura A. Weed.1 He married Gladyce Burchfield.3 He and Gladyce Burchfield were divorced.4 He died in April 1979 in Franklin, Venango County, Pennsylvania.2
Gladyce Burchfield
Dorothy Mae Karns3 b. 5 Dec 1925, d. 23 Mar 1968
Raymond L. Karns5
Donald E. Karns5
Patricia Jean Karns4
[S114] Clyde Karns, Social Security Death Index, Master File, www.ancestry.com (Orem, UT: Ancestry, Inc., 1999). Hereinafter cited as SSDI.
[S8] "Mrs. Forbes of Titusville Dies at 42", The Oil City Derrick, Oil City, PA, 25 Mar 1968, p. 18, Oil City Library, Oil City, Venango County, Pennsylvania. Hereinafter cited as The Derrick.
[S1348] 1940 U.S. Census, Pennsylvania, Venango Co., Cornplanter Tp., Fred G. Miller household, National Archives, (Fred G. Miller, 38, PA, laborer, petroleum refinery; Gertrude, 50, PA, wife; Richard Burchfield, 33, PA, div, step-son; Gladyce Karns, 33, PA, div, step-dau; Dorothy M. Karns, 14, PA/PA/PA, granddau; Ray L. Karns, 12, PA/PA/PA, grandson; Donald E. Karns, 11, PA/PA/PA, grandson; Patty J. Karns, 9, PA, granddau).
[S969] 1930 U.S. Census, Pennsylvania, Venango Co., Cornplanter Tp., Hasson Heights, Clyde W. Karns household, National Archives, (Clyde W. Karns, 25, PA/PA/PA, laborer, oil refinery; Gladyce K., 23, PA/PA/PA; Dorothy M., 4 3/12, PA/PA/PA, dau; Ray L., 2 10/12, PA/PA/PA, son; Donald E., 1 6/12, PA/PA/PA, son).
Gladyce Burchfield1
Gladyce Burchfield married Clyde W. Karns, son of Joseph M. Karns and Laura A. Weed.1 She and Clyde W. Karns were divorced.2
Clyde W. Karns b. 25 Apr 1903, d. Apr 1979
Dorothy Mae Karns1
b. 5 December 1925, d. 23 March 1968
Father Clyde W. Karns1 b. 25 Apr 1903, d. Apr 1979
Mother Gladyce Burchfield1
Dorothy Mae Karns was born on 5 December 1925 in Oil City, Venango County, Pennsylvania.1 She was the daughter of Clyde W. Karns and Gladyce Burchfield.1 She married Harry J. Forbes in March 1948.1 She died on 23 March 1968 in Titusville, Crawford County, Pennsylvania, at age 42.1 She was buried in Plumer Cemetery, Cornplanter Township, Venango County, Pennsylvania.1
Harry J. Forbes d. 20 Feb 1965
Harry J. Forbes1
d. 20 February 1965
Harry J. Forbes married Dorothy Mae Karns, daughter of Clyde W. Karns and Gladyce Burchfield, in March 1948.1 He died on 20 February 1965.1
Dorothy Mae Karns b. 5 Dec 1925, d. 23 Mar 1968
Raymond L. Karns is the son of Clyde W. Karns and Gladyce Burchfield.1


text:
Q: conflicting requests error while building SDK I got the following conflicting requests error while building SDK
I am using sumo branch , and generic core-intel-i7-64 machine configuration.
Running the following command: bitbake -c populate_sdk core-image-minimal
Fails at the last step with the following error.
ERROR: core-image-minimal-1.0-r0 do_populate_sdk: Could not invoke dnf. Command '/home/jamal/repotest1/yocto_intel_build/tmp/work/intel_corei7_64-poky-linux/core-image-minimal/1.0-r0/recipe-sysroot-native/usr/bin/dnf -y -c /home/jamal/repotest1/yocto_intel_build/tmp/work/intel_corei7_64-poky-linux/core-image-minimal/1.0-r0/sdk/image/opt/poky/2.5/sysroots/corei7-64-poky-linux/etc/dnf/dnf.conf --setopt=reposdir=/home/jamal/repotest1/yocto_intel_build/tmp/work/intel_corei7_64-poky-linux/core-image-minimal/1.0-r0/sdk/image/opt/poky/2.5/sysroots/corei7-64-poky-linux/etc/yum.repos.d --repofrompath=oe-repo,/home/jamal/repotest1/yocto_intel_build/tmp/work/intel_corei7_64-poky-linux/core-image-minimal/1.0-r0/oe-sdk-repo --installroot=/home/jamal/repotest1/yocto_intel_build/tmp/work/intel_corei7_64-poky-linux/core-image-minimal/1.0-r0/sdk/image/opt/poky/2.5/sysroots/corei7-64-poky-linux --setopt=logdir=/home/jamal/repotest1/yocto_intel_build/tmp/work/intel_corei7_64-poky-linux/core-image-minimal/1.0-r0/temp --nogpgcheck install lib32-dpkg lib32-libstdc++6 lib32-packagegroup-core-standalone-sdk-target lib32-libx11-6 lib32-ncurses lib32-libgcc1 lib32-libgnutls30 lib32-libfreetype6 lib32-libc6 run-postinsts libgnutls30 dpkg kernel-devsrc packagegroup-core-standalone-sdk-target packagegroup-core-boot target-sdk-provides-dummy' returned 1:
Added oe-repo repo from /home/jamal/repotest1/yocto_intel_build/tmp/work/intel_corei7_64-poky-linux/core-image-minimal/1.0-r0/oe-sdk-repo
Last metadata expiration check: 0:00:02 ago on Thu 18 Oct 2018 01:12:30 PM UTC.
Error:
 Problem: conflicting requests
  - nothing provides /usr/bin/python needed by kernel-devsrc-1.0-r0.intel_corei7_64

ERROR: core-image-minimal-1.0-r0 do_populate_sdk: Function failed: do_populate_sdk
ERROR: Logfile of failure stored in: /home/jamal/repotest1/yocto_intel_build/tmp/work/intel_corei7_64-poky-linux/core-image-minimal/1.0-r0/temp/log.do_populate_sdk.11307
ERROR: Task (/home/jamal/repotest1/sources/poky/meta/recipes-core/images/core-image-minimal.bb:do_populate_sdk) failed with exit code '1'

I found similar error in yocto mailing list, but unable to understand.. Can you please help me to resolve this issue.. Thanks for your time
https://lists.yoctoproject.org/pipermail/yocto/2018-February/039941.html
I have /usr/bin/python in my system

A: Add RDEPENDS to your  kernel-devsrc.bb
RDEPENDS_${PN} = "bc python flex bison ${TCLIBC}-utils"
RDEPENDS_${PN} += "openssl-dev util-linux"
RDEPENDS_${PN} += "${@bb.utils.contains('ARCH', 'x86', 'elfutils', '', d)}"

https://lists.yoctoproject.org/pipermail/yocto/2018-October/042908.html


This weekend, my wife Anette and I welcomed Dillon Jacob Spoon - all 7.5 pounds and 20.5 inches of him. We thank everyone for the well wishes and notes... we were truly overwhelmed by everyone's kindness and generosity. Though only a couple days into the journey, we have loved every moment =) A few pictures are below and I will be taking a short hiatus from email, the blog, and so forth. Please understand if there is a delay in returning emails / calls!
1. Apple's Facetime is made for experiences like this... in fact, it is why Anette, my parents and I all got the new iPhone. Facetime has allowed family and friends outside of San Francisco to 'spend time' with Anette, Dillon and I. It really is life changing.
2. Thank god for Amazon (and Amazon Prime).
3. Facebook too: with its ability to easily share updates, photographs and so forth with all of our friends and family. Everyone's feedback has been touching!
Goodbye Dotster. Hello Media Temple (mt).
So I decided to migrate everything to a dedicated server using Media Temple (mt). Things are now lightning fast and mt's customer support and responsiveness have been outstanding. The blog should be running faster than ever and it should be entirely stable. Thanks for your patience and big thanks to Danny Leffel (of InGameNow) and Russell Cook (of beRecruited) for all of the assistance.
I am excited to announce that, starting Monday, I will be joining Polaris Venture Partners and will work out of the Dog Patch Lab on Pier 38. Over the last few years, I have had the opportunity to get to know the Polaris team and I am eager to begin working with them in a different capacity. I have enjoyed my time at eBay, Widgetbox and beRecruited, but have always wanted to move into venture. My two questions were: what is the right them and where is the right fit. Polaris is certainly the right fit and the timing is particularly exciting because I will be based in the Dog Patch Lab - a vibrant collection of entrepreneurs and start ups on Pier 38 off of Embarcadero (portfolio company LOLapps and ThingLabs launched here). The lab is operated by Polaris and focused at connecting entrepreneurs and helping founders conceive and build startups.
If you read this blog, you know my interests: consumer internet, digital media, mobile and social media. I will also enjoy being exposed to other investment areas as Polaris is diversified across industries and stages: life sciences, growth equity and technology.
If you would like to tour the lab or find a time to meet, drop me a line!
- PolarisVentures.com - VCMike (Mike Hirshland): Blog, Twitter - RyanSpoon.com: Blog, Twitter, Facebook - TechCrunch: Polaris & Dog Patch Labs - Xconomy.com: "Dog Patch Lab - An Entrepreneur's Kennel"
Introducing New Blog Design... Thoughts?
When I first started this blog, it was on a whim and I built it over a weekend on a hosted version of Wordpress. The theme I implemented and hacked-together worked well but didn't scale well with increased amounts of content, advertising, etc. And while much of my readership is via RSS and email, I was bothered by the overflow that become my blog.... so I finally mustered up the time and courage to hack a redesign together over the past few nights. So here it is: a new theme that is more of a "magazine" template. It is based on Arthemia and is very flexible / customizable. There several great features which aren't turned on because I haven't had the ambition or confidence to upgrade to the latest version of Wordpress (any help welcome!).
I'd also love your thoughts - like it? Hate it? Improvements? Know CSS and want to help!?
This Saturday, I will compete in the famed Alcatraz swim race for the seventh time and will joined by last year's winner and co-founder of InGameNow, Steuart Martens, and Widgetbox CEO Will Price. We will be swimming in the Alcatraz 100 swim race which was recently named one of the ten best open water swims behind other famous events like the Waikiki Roughwater Swim and the Manhattan Island Marathon Swim. It's clearly not tech related (so if you read this blog for tech news, I apologize), but I am frequently asked about the Alcatraz swim and, with the race a couple days away, I thought it was worthwhile to post a guide to swimming Alcatraz.
Two Alcatraz Courses There are two Alcatraz courses: the most common is from the rock almost directly south into the Aquatic Park beaches. This swim is (if swum perfectly) 1.25 miles long and the last quarter mile is actually protected within Aquatic Park (in a cove near the wharf with a concrete opening for boats). The second course, shown below, is into the beaches of Chrissy Fields. This course is roughly 1.75 miles long and is far more difficult because it requires better sighting and mapping - in addition to better conditioning. The mixture of currents makes the Chrissy Fields swim very difficult. As an example, I swam the Aquatic Park course as part of the Alcatraz 100 race in 2004 and placed 2nd with a time of 28:14. Of course conditions were not equal, I swam the Chrissy Fields course in July 2006 and it took 39 minutes.
Alcatraz Water Temperatures The hardest part about the swim is clearly the frigid water temperatures which can range from 57-63 degrees depending on the time of year and the city's weather. The first year that I swum the race, the water was around 63 degrees and last summer it was just under 60... I recommend a wetsuit, although Steuart swam the race last year in nothing more than a Speedo. Either way, it's important that you condition yourself for the water temperature and swimming in a wetsuit. Aquatic Park is a great place to get a feel for what the water is like and how different swimming in a wetsuit is. One piece of advice I give is that you will always find Aquatic Park colder because, on race day, your adrenaline is so great that it somewhat soothes the cold.
If you are particularly worried, you can wear swim caps made of wetsuit-like materials - if you don't have one, you can wear multiple latex caps. Always make sure that your cap is neon colored as its much safer should you need attention or assistance.
If you can't practice in Aquatic Park, it is recommended that you prepare by showering in cold water (seriously).
Starting the Race Pretty simple and pretty gut-wrenching. Hundreds of swimmers - mostly in wetsuits - stand on the deck of a big cruiser-boat. The race director blows a shotgun and everyone dives in and races to shore. The stronger, more aggressive swimmers dive out first. If you want to avoid the crowds and are doing the swim more for accomplishment than for time, I recommend waiting for the competitive swimmers to dive in first.
Be warned - NEVER aim for the swimmers ahead of you. They will most always be to the your right and, by following them, you will be much further west than they are by the time you reach that point! They have already fought the currents to get to their current positioning - if you must follow a leading swimmer, aim EAST.
Also of note, it is ALWAYS better to overshoot East rather than West. Take a look at the images below used by GPS tracking - you will notice how off course some of the swims are. There is nothing worse or more difficult than having to fight the currents and swim upstream to correct earlier mistakes. It is always easier to swim downstream!
Over this July 4th weekend - where we vacationed in Cape Cod with my family - Anette and I got engaged! We actually debated whether or not I should post the announcement and picture on this blog. Anette finds it tacky and I have personally struggled with the balance / conflict between tech posts vs. personal posts. But now, a few days after the proposal, I've realized how important the web has been (despite being 'tacky') in communicating the news... and consequently, I don't feel awkward posting this information on a blog... and a tech blog at that.
The other interesting aspect was how Facebook played a role in reaching our friends. Outside of phone calls, text messages and emails - I was really struck by the impact of simply changing my "Facebook" relationship status. Unlike my sisters, I am not an avid Facebook user who logs in multiple times a day (or even daily). I consider myself a reactive Facebooker - someone who logs in when drawn through SMS and email alerts. I suspected that most of my friends were also reactive users.
By only changing our relationship status, we each received numerous messages from people who saw the news hit their Facebook Feeds - which means that people were logging in and actively using the Feed to monitor changes in their network. Fascinating considering the amount of activity most people's feeds contain and the rapidity of which we both started getting emails. There is no overlooking how important the Feed has become to Facebook's ecosystem.
I haven't yet posted to Twitter... I can't bring myself to be that tacky (for now).
- Bike: Almost entirely uphill. You go from sea-level to high in the Presidio - well above the Golden Gate's entrance. 90% of the bike is done is gear 1-1.
- Run: Along Chrissy Field and up to the Golden Gate Bridge... which includes scaling very steep steps.
When my dog Manny was diagnosed with Legg-Perthes Disease last year, there was little information available on the web about the disease, it's impact and the necessary surgery. So I documented the entire process (both Manny's experience and mine) on MyDogManny.com. I made the site in the hope that it might help other dogs and dog-owners overcome the debilitating and commonly misunderstood disease. I receive emails like the one below every couple weeks. This one arrived yesterday and really demonstrated the power of the internet and of content.
I just wanted to extend my heartfelt thanks for all the work and time you put into your website (mydogmanny.com) and chronicling your dogs' progression through FHO surgery.
We recently went through the same experience with our own dog. We were on the fence regarding the surgery, as our pet is older. Your experience convinced us that she could get through this, and the surgery was a huge success!
Without your site to encourage us, we probably would have put her down. Thank you so much for the help and encouragement that your experience lent to us. We are looking forward to many more good years with our beloved little fur ball Peawee, a toy mix we rescued from a shelter.
Sending good vibes to you today - you rock!
Yesterday, we took an unbelievable snowmobile tour in Vail. I had never snowmobiled before - so we decided to take a 4 hour tour with Nova Guides (one of the big guide companies in Vail Valley). They took us out in groups of 8 and we had over 80 miles of national forest track available to ride. The tracks were about 20 minutes past Minturn on route 24 (which before I-70 was the only way from Vail to Denver) - passing through Redcliff, an relatively recently abandoned mining town.
Here are some of the photos from atop the tracks at about 12,000 feet. You can see Breckenridge, Copper Mountain, Vail and some other local chutes. The highlight of the trip (other than riding around powder at 50+ mph) was seeing one of the riders in our group fall off his snowmobile and subsequently have it roll 400 yards down a bank of waist-high powder.
The first video shows the view atop the mountain. The second is of the fallen snowmobile.


text:
Email support@scvo.info
Staying Informed – SCVO Communications
Financial Management & Support
Governance & Committee Support
Help for Small & New Groups
Volunteering Support
Building Resilience in Sandwell Communities
Good Engagement
Leaders Forum
VCS Representatives
Sandwell Advice Providers Network
Jubilee Food Network
Route2wellbeing Portal
Funding Digests
VCS Database
Local Impact Snapshots
Local Impact Spotlight
Local Impact Videos
Launch of new Jobs and Training publication
August 28, 2018by Mazeline Hemmings in Blog, Did you know...?, Training Support and Resources tagged Employment, Training
A new publication is being launched to give people living across the Black Country a helping hand if they are looking to improve their skills, find work or need tips and advice on changing a career.
The Jobs and Training magazine will offer dedicated area features and industry spotlights, case studies, funding news and information, course directories plus information, advice and guidance. It will also offer a loyalty scheme, giving regular readers the opportunity to earn rewards and vouchers when the first issue comes out towards the end of September.
A website and a mobile app providing a complete online solution for learners to find career opportunities will complement the bi-monthly magazine.
Around 20,000 issues will be distributed twice a month through supermarkets, Job Centre Plus sites, community centres, adult learning centres and retail and hospitality hotspots in Walsall, Wolverhampton, Sandwell and Dudley. Copies would will also be available from the Council House in Oldbury.
Neil Harding, business development manager for Jobs and Training, said: "The main focus is to provide people with easy access to courses, local providers and career opportunities.
"But we can also help reduce the spend of businesses who can waste thousands of pounds per year on hit and miss marketing in search of the right person for the right opportunity. Our dedicated product will provide the link between learners, training providers and employers.
"There are also hundreds or even thousands of opportunities that are being missed, including millions of pounds of funding that may be handed back because people don't know what's available and what they are entitled to.
"Jobs and Training hopes to fill the gap in this market and keep learners and businesses updated."
For more information about Jobs and Training, telephone Rachel Gardiner on 0121 501 2243 or email Rachel@jobsandtraining.co.uk
Workshop for Muslim Couples
August 28, 2018by Mazeline Hemmings in Blog, Training Support and Resources tagged Community News, culture, Support & Services
The Yemeni Community Association is delighted to be hosting this workshop on Sunday, 9 September 2018, from 9.30 am to 5.00 pm.
The speaker, Dr Suzy Ismail, renowned author and international speaker, is visiting the UK and the West Midlands for the first time. Dr Ismail works therapeutically and compassionately with Muslim couples.
The workshop is for counsellors, psychotherapists, family support workers or any professional interested in the subject.
The cost of the workshop is £95 per person (CPD certificate of attendance and light lunch included).
The venue is Greets Green Access Centre, Tildasley Street, West Bromwich B70 9SJ. For further details please contact the YCA on 0121 525 3909 or email saeed@yca-sandwell.org.uk
Register via Eventbrite
Wolfson Foundation
August 28, 2018by Mazeline Hemmings in Blog, Funding tagged Funder News, Funding Opportunities
The Wolfson Foundation has announced that the next closing date for stage 1 applications to its Health and Disability Grants Programme is the 5th January 2019.
Through the programme, the Wolfson Foundation, makes grants of between £15,000 – £100,000 for new buildings, refurbishments and equipment for a range of organisations delivering excellent care and support. The funding is focused on:
Palliative Care and Hospices
Transitions and Independence.
Match funding is required for projects over £50,000.
The Foundation does not provide funding for clinical care which might be considered the proper responsibility of the National Health Service (e.g. refurbishment of hospital wards or other facilities, or provision of surgical equipment).
The Foundation also encourage applications from all parts of the UK, especially regions that have few alternative sources of funding.
Lloyds Bank Foundation
Registered charities with incomes between £25,000 and £1 million, working with people over the age of 17 facing complex social issues, will be able to apply for grants of up to £100,000 through the Lloyds Bank Foundation Invest programme.
The programme opens for applications on the 28th August 2018 and close on the 5th October 2018.
Digital to Drive Government Civil Society Strategy
August 28, 2018by Libby Mahoney in Blog, VCS Feature tagged news, Policy
Government calls for better apps and 'digital technology-for-good' to boost democratic innovation and bolster charities' work across age ranges, among other proposals.
The UK Government's first Civil Society Strategy proposal for 15 years has been unveiled. The strategy claims to place communities at the centre of decision-making, and focuses on five key foundations of social value: people, places and the public, private and social sectors.
The charity sector strategy compliments plans to grow the UK's economy and boost productivity by 'building a more connected society', where 'everyone can play their part in a fairer, healthier and more prosperous country'.
It aims to create more opportunities for people to actively take part in community decisions, as well as highlighting ways to harness the power of digital and technology 'for public good', according to a Government statement.
Civil Society Strategy actions include:
The launch of an 'Innovation in Democracy' pilot scheme in six regions across the country. This will trial ways for people to take a more direct role in decisions that affect their local area. This could include 'citizens juries' or mass participation in decision-making on community issues via an online poll or app.
Use of digital technology-for-good to improve the work charities can provide to support healthy ageing, bolster online safety, and better connect people in an effort to tackle loneliness.
Unlocking £20m from 'inactive' charitable trusts (those which spend less than 30% of annual income) to support community organisations over the next two years. The work will be carried out in conjunction with the Charity Commission and UK Community Foundations.
The establishment of an independent organisation that will distribute £90m from dormant bank accounts to get disadvantaged young people into employment.
To read the full Charity Digital News article click here.
Royal Society of Chemistry – Outreach Fund Small Grants Scheme
Individuals and organisations such as researchers, museums, schools, community groups, not-for-profit organisations, arts groups and libraries can apply for grants of up to £10,000 to run chemistry-based events and activities for public audiences and in schools.
Priority will be given to projects that raise awareness of the place of chemistry in people's everyday lives, especially those not already interested in chemistry, and/or develop the science communication skills of people who are already highly trained in chemistry.
The Outreach Fund is split into two categories: Small grants – up to £2,000; and Large grants – between £2,000 and £10,000.
The closing date for small grants is 12 noon on the 10th September 2018. Applications for the large grants programme are currently closed and will re-open for applications in January 2019.
Funding Digest: 27th August to 9th September 2018
August 28, 2018by Stuart Ashmore in Blog, SCVO News tagged Funder Update
It's w/c 27th August 2018 and, for regular followers of our 'Funding Digest' publication, you might be wondering about the next edition.
Well, there will be a short delay in its production as the regular editor is currently enjoying a short period of Annual Leave.
But don't despair, because you can still access funding information on a 'live' basis by using our FREE (yes, FREE) 'Funding Portal'…and this is available whenever* you need it, not just every fortnight!
Simply follow the instructions on the Portal introduction page: www.scvo.info/local-vcs-intelligence/funding-portal/ to get access to information that would be provided in the Digest and much, much more!
Plus…you don't have to be a member of SCVO, or based in Sandwell, to use it – it's FREE to anyone signing up.
Normal Digest service will be resumed from Monday, 10th September 2018.
*As this service is provided by a third party, availability is subject to their operating requirements.
Sainsbury's Local Food Partner Programme
Sainsbury's continues to expand its Local Food Partner Programme and is accepting applications from local charities to join the network.
Local food partner charities can collect dry and tinned food donated by customers and/or fresh food donated by Sainsbury's to distribute in the community.
Applicants must be a registered charity, have appropriate Food Hygiene certification and be able to collect donated food regularly from your partner store. Applications can be submitted at any time.
Grants to Support the Cataloguing and Scoping of Archives
A new funding programme launched in February 2018 to support the cataloguing and scoping of archives is due to re-open for a second round in October 2018.
'Archives Revealed' is the only source of funding available in the UK dedicated to cataloguing and unlocking archives and comprises two funding strands: Cataloguing Grants of up to £40,000 and Scoping Grants of up to £3,000 are available.
Public sector bodies, registered charities, other not-for-profit organisations can apply. The funding is being made available through a partnership between the National Archives and the Pilgrims Trust.
The Birmingham Honey Show
August 28, 2018by Mazeline Hemmings in Blog, Did you know...?, News and Events tagged Events and Meetings, Social Value
The Birmingham and District Beekeepers' Association is proud to announce this year's Birmingham Honey Show will be on Saturday 1st and Sunday 2nd September 2018, 10 am – 4 pm.
For an fun day out, go along to Martineau Gardens at 27 Priory Road, Edgbaston, Birmingham B5 7UG where you can:
View the Honey Show competition entries
Make your own Beeswax candle
Buy local honey and other hive products
Indulge yourself at the Cake stall
See live bee demonstration (weather permitting)
Visit the Observation Hive
Admission is free and there is plenty of parking! For more information visit the website
Page 1 of 7123»...Last
Housing, Environment & Economy
Safer, Stronger Communities
SCVO News
Swap-shop
Training Support and Resources
VCS Feature
Tweets by @SCVOSandwell
National Lottery names more charities to benefit from £8.6m Digital Fund grants Charities including Refugee Action… https://t.co/hfXfmIuqGv
Follow @SCVOSandwell
Email: support@scvo.info
1st Floor, Landchard House
Victoria Street, West Bromwich
B70 8ER
© 2014 Sandwell Council of Voluntary Organisations. All Rights Reserved
Registered Charity No. 1071514 | Company Registration No. 03570517


text:
Q: Can I reference a later table in a join? I have some code that looks like the following:
SELECT *
FROM invoices
LEFT JOIN shipments ON (
    shipments.id = invoices.shipment_id
)
LEFT JOIN details ON (
    details.id = invoices.detail_id
)

Basically, I want to look up the shipments table and the details table by an identifier from the invoices table. However, I would also like to join these two tables using something like the following:
SELECT *
FROM shipments
JOIN details ON (shipments.order = details.order)

Basically, I want a way of pulling both tables if either one of (invoices.shipment_id, invoices.detail_id) is found. However, I cannot reference a later table in a join, so I can't just do something like:
SELECT *
FROM invoices
LEFT JOIN shipments ON (
    shipments.id = invoices.shipment_id
    OR shipments.order = details.order
)
LEFT JOIN details ON (
    details.id = invoices.detail_id
)

Is there a way to do this while pulling both tables?
Edit for clarity:
Here is a sample table structure
CREATE TABLE invoices (
    id integer PRIMARY KEY,
    shipment_id integer,
    detail_id integer,
    data text
)

CREATE TABLE shipments (
    id integer PRIMARY KEY,
    data text
)

CREATE TABLE details (
    id integer PRIMARY KEY,
    shipment_id REFERENCES shipments (id),
    data text
)

invoices.shipment_id may or may not contain a shipments.id, and invoices.detail_id may or may not contain a details.id.
If invoices.shipment_id contains a valid id, I need to do something like:
SELECT
    shipments.data as shipment_data,
    details.data as detail_data,
FROM invoices
JOIN shipments ON (invoices.shipment_id = shipments.id)
JOIN details ON (details.shipment_id = shipments.id)

If invoices.detail_id contains a valid id, I need to do:
SELECT
    shipments.data as shipment_data,
    details.data as detail_data,
FROM invoices
JOIN details ON (invoices.detail_id = details.id)
JOIN shipments ON (details.shipment_id = shipments.id)

Is there some way of combining these two together cleanly?

A: Try
select * from invoices
left join (
  select shipments.id as ids, details.id as idd, * from shipments
  outer join details on (
   shipments.order=details.order
  )
) as sd on (
 sd.ids=invoices.shipment_id OR
 sd.idd = invoices.detail_id
)

A: Sorry i thought the question is about SQL server so please excuse me if my syntax is wrong. But i am quite sure the query will work in postgres.
this will look odd .. but if i understood right then following will do the job
SELECT *
FROM shipments INNER JOIN
details ON shipments.order = details.order RIGHT JOIN
invoices ON details.id = invoices.detail_id
AND shipments.id = invoices.shipment_id

A: It's not clear what you want. Perhaps this:
SELECT *
FROM invoices
  LEFT JOIN shipments ON
    shipments.id = invoices.shipment_id
  LEFT JOIN details ON
    details.id = invoices.detail_id
WHERE ( shipments.order = details.order
     OR shipments.order IS NULL
     OR details.order IS NULL
      )

A: Best I could come up with is this solution:
SELECT DISTINCT * FROM
(
    SELECT
        shipments.data as shipment_data,
        details.data as detail_data,
    FROM invoices
    JOIN shipments ON (invoices.shipment_id = shipments.id)
    JOIN details ON (details.shipment_id = shipments.id)

    UNION

    SELECT
        shipments.data as shipment_data,
        details.data as detail_data,
    FROM invoices
    JOIN details ON (invoices.detail_id = details.id)
    JOIN shipments ON (details.shipment_id = shipments.id)
)

This isn't the prettiest solution, but it properly uses the indices on all three tables and returns both sets of records when needed.

A: Use UNION ALL:
Assuming that only one of (invoices.shipment_id, invoices.detail_id) can contain a value and the other one must be NULL and you are actually enforcing this rule with a CHECK constraint - because anything else would lead to ambiguity.
SELECT s.data AS shipment_data, d.data AS detail_data
FROM   invoices  i
JOIN   shipments s ON s.id = i.shipment_id
JOIN   details   d ON d.shipment_id = s.id

UNION ALL
SELECT s.data, d.data
FROM   invoices  i
JOIN   details   d ON d.id = i.detail_id
JOIN   shipments s ON s.id = d.shipment_id

*

*The 1st branch only returns values if invoices.shipment_id IS NOT NULL.

*The 2nd branch only returns values if invoices.detail_id IS NOT NULL.

Voilá.
I have a tingling sensation that your db schema leaves room for improvement. :)


text:
Remove IAM users from your Organization!
The landscape of AWS access patterns has been a very frustrating one for years. Having worked with people at all skill levels in AWS, we at Trek10 have discovered that most people struggle with it, even industry-leading experts. We've even worked on solutions like awsume to help make some of it easier, but there's always more to be desired. Building access patterns with raw AWS IAM is a fundamentally difficult thing to get right, and is not something that the community can solve, but rather the AWS platform needs to evolve to support more modern access patterns.
This is where AWS SSO comes into play - the next step in the evolution of AWS access. When an organization has fully adopted AWS SSO, signing into AWS will be just like any other enterprise application or service their employees use. And the best part - AWS SSO is totally free!
AWS SSO is a service that helps facilitate access to your Organization's AWS accounts and SAML 2.0-authenticated applications. For AWS accounts, it integrates directly with AWS Organizations. It does not yet support AWS Organizations delegated admin, so you must use the organization management account to configure it. Once it's configured, you'll be able to use the AWS SSO portal to access your AWS accounts.
Identity Provider vs Service Provider
A couple of key terms to understand are "Identity Provider" and "Service Provider." An identity provider is a service that manages information about people and machines - their identities. This could be something like Okta or Google. If you have an account registered with an identity provider, it can validate that you are who you say you are through some method of authentication (commonly username and password).
A service provider on the other hand is an application that performs a service, like Office365, something from the Atlassian suite of projects, or even GitHub. It may maintain its own identities, but if you are an organization that utilizes many different service providers, you may find it cumbersome to have your employees manage authentication to multiple different service providers since they would have to maintain separate logins to each service.
To solve this problem, you can usually hook a service provider up to an identity provider, that way authentication happens at one location, and can be re-used for any integrated service provider.
AWS SSO can serve as both an identity provider and a service provider. By default, it provides you with a default identity store that you can use to manage identities (users and groups). However, it's better to use a dedicated identity provider, such as Okta, Google, or Microsoft Active Directory, and only treat AWS SSO as a service provider. When you do this, it means that AWS becomes just another one of your "enterprise apps" that your users will have access to. The primary reason we recommend against using AWS SSO as an identity provider is that a dedicated identity provider is likely to have more of the features your organization might feel is necessary, where the AWS SSO default identity store would be lacking (context-aware MFA controls, robust API controls, or even white-labeling).
Authentication vs Authorization
When treating AWS SSO as a service provider, there are two concepts to consider: authorization and authentication.
Authentication verifies the identity of the user. It should be handled by the identity provider.
Authorization determines what resources a user can access. In this case, the resources are AWS accounts you're granting access to, so authorization should be handled by AWS SSO (more on that later).
The only time you'll want to federate applications to AWS SSO and not your identity provider is when the application/service sits within the AWS ecosystem. A few examples are the AWS services that get federated via SAML, such as QuickSight or IoT SiteWise Monitor. Another one could be this community self-hosted service for sandbox-style account vending: https://github.com/iann0036/aws-account-controller). For any other type of application (email, Jira/Atlassian, GitHub, etc), you should be federating them to your identity provider directly.
Beyond the actual federation, you'll want to also consider configuring automatic provisioning via the SCIM protocol. With SCIM, you can configure your identity provider with credentials from the service provider to automatically provision and de-provision users in the target service provider (AWS SSO) as they're assigned and unassigned from the service within your identity provider (Okta, etc). Without automatic provisioning, you'll have to manually replicate any assigned user within AWS SSO, which undermines some of the advantages of a true SSO solution (single source of identity management).
Unfortunately, certain identity providers don't yet support SCIM (most notably Google Workspace/G Suite) so this part may still be manual, however adopting AWS SSO is still largely beneficial even in this case, as your users will still be authenticated against your identity provider. Even if you forget to remove an old AWS SSO user, they won't be able to sign in since the identity provider authentication would fail.
Questions about AWS SSO? Our Experts are here to help!
AWS SSO Authorization
When it comes to authorization, this is handled on the AWS SSO side by two resources: AWS::SSO::PermissionSet and AWS::SSO::Assignment.
A permission set is simply an IAM policy. A permission set can reference multiple managed policies and also have a single inline policy associated with it. On its own, a permission set does not translate into anything tangible - no access is granted yet. To grant access, you have to create an AWS::SSO::Assignment.
An assignment grants access to a specified principal (SSO user or group) to a specified target (AWS account) using a permission set. When an assignment is created on an account, AWS SSO uses a service-linked role in the target account to create the following:
An AWS::IAM::SAMLProvider if one does not already exist in the account - this SAML provider (usually named AWSSSO_abcde12345_DO_NOT_DELETE) defines the issuer and service location as your AWS SSO instance portal, not your actual identity provider.
An AWS::IAM::Role that trusts the created AWS::IAM::SAMLProvider and contains the permissions defined by the permission set. This role is usually named AWSReservedSSO_PermissionSetName_abcde12345.
AWS SSO Portal
Once you have your identity provider federated, automatic provisioning setup, permission sets created, and assignments created, you'll be able to access your AWS organization via AWS SSO. This can happen in one of two ways: identity provider-initiated auth (clicking an AWS SSO app from your identity provider) or service provider-initiated auth (going to an https://{SOME_ID}.awsapps.com/start).
If you use service provider-initiated auth, you'll be directed to sign in to your identity provider, and then redirected to the AWS SSO portal. If you use identity provider-initiated auth, your identity provider will automatically authenticate the user within the AWS SSO portal when it redirects you there.
It's important to understand that your identity provider only handles authentication (federating to the portal), not authorization (access to individual accounts). Within the AWS SSO portal, you'll have a view of each account you have an assignment for, and underneath each account, you have a view of each permission set within that account you have an assignment for. From there you can get console access or get credentials for the CLI (although for CLI access we recommend configuring the AWSCLIv2 for this, along with the helper utility aws-sso-util).
Go Get Started!
So how do you get started? Well first, you'll need access to an AWS organization. If you have a personal account, you can get started with the default AWS SSO identity store, but to get a better understanding of the AWS SSO configuration lifecycle, you can get a free Okta developer account at https://developer.okta.com/signup/. If your work organization is interested, you can configure AWS SSO without any disruption to your existing access patterns (IAM users/roles) while you get familiar. If you're worried about accidentally granting unnecessary access, note that you won't grant any access if you don't create any SSO assignments, but you can configure federation from the AWS SSO portal to your identity provider.
You'll want to decide on a region to configure your AWS SSO instance in. AWS SSO can only be instantiated in a single region. Once you've decided on a region, go to the SSO console in that region and create your SSO instance. Once it's created it will be in its default state. You'll then want to configure settings like the AWS SSO portal URL. If you're federating to another identity provider, you'll also want to set that up, along with automatic provisioning if that's supported by your identity provider.
After that, you'll want to define a landscape for your AWS access by creating assignments, following the principal of least privilege. An assignment has 3 dimensions to it: principal (preferably assigning by group), AWS account, and an AWS SSO permission set, so it's helpful to have this fully described before you dig into implementation. We like to have this defined using some sort of matrix for easy reference:
Once you have your AWS SSO instance and your identity provider configured, you'll be able to sign onto the AWS SSO and view all assigned accounts and permission sets, and finally start treating AWS access like a modern federated service.
Go to Stories by Michael
Michael started his career out in the serverless world, joining the Trek10 team right out of college - a true Serverless Native.
Preparing for and real-world Kubernetes Deployments Pt. 2
Experimenting with a Docker container to research the self-healing capabilities of Kubernetes to help manage issues encountered during the pod lifecycle.
Ryan Wendel | Jan 11 2022
Cloud Emergency Preparedness Kit Pt. 1
The 3 topics cover what needs to be done before, during, and after an incident. Learn important factors that will contribute to great incident response.
Jeremiah Owen | Dec 03 2021
Preparing for and real-world Kubernetes Deployments Part 1
Understanding Kubernetes manifest directives that allow containers to self-heal throughout the pod lifecycle and control the deployment process.
Ryan Wendel | Nov 11 2021
Learn more about AWS SSO from our Experts
Work at Trek10