Publications by Anthony Damico
why and how to install monetdb with r on windows
warning: the instructions below are obsolete. please check this page for the latest version. <3 anthony whya speed test of three sql queries on sixty-seven million records using my personal computer —# calculate the sum, mean, median, and standard deviation of a single variablesystem.time( dbGetQuery( db , ‘select sum( car_hcpcs_pmt_amt )...
5140 sym
analyze the basic stand alone medicare claims public use files (bsapufs) with r and monetdb
the centers for medicare and medicaid services (cms) took the plunge. the famous medicare 5% sample has been released to the public, free of charge. jfyi – medicare is the u.s. government program that provides health insurance to 50 million elderly and disabled americans. the basic stand alone medicare claims public use files ...
6243 sym
analyze the american community survey (acs) with r and monetdb
experimental. think of the american community survey (acs) as the united states’ census for off-years – the ones that don’t end in zero. every year, one percent of all americans respond, making it the largest complex sample administered by the u.s. government (the decennial census has a much broader reach, but since it attem...
8822 sym
analyze the behavioral risk factor surveillance system (brfss) with r and monetdb
experimental. the behavioral risk factor surveillance system (brfss) aggregates behavioral health data from 400,000 adults via telephone every year. it’s um *clears throat* the largest telephone survey in the world and it’s gotta lotta uses, here’s a list neato. state health departments perform the actual data collection (...
6168 sym
analyze the medical expenditure panel survey (meps) with r
the meps household component leads the pack for examining individual-level medical expenditures by payor and type of service. total expenditures captured by the survey tend to be low, but unbiased across the board and can be adjusted to match the national health expenditure accounts. i wrote the wikipedia article, so it’s data-o...
4630 sym
analyze the health and retirement study (hrs) with r
the hrs is the one and only longitudinal survey of american seniors. with a panel starting its third decade, the current pool of respondents includes older folks who have been interviewed every two years as far back as 1992. unlike cross-sectional or shorter panel surveys, respondents keep responding until, well, death do us part....
4932 sym
analyze the survey of consumer finances (scf) with r
the survey of consumer finances (scf) tracks the wealth of american families. every three years, more than five thousand households answer a battery of questions about income, net worth, credit card debt, pensions, mortgages, even the lease on their cars. plenty of surveys collect annual income, only the survey of consumer finance...
5629 sym
analyze the survey of income and program participation (sipp) with r
if the census bureau’s budget was gutted and only one complex sample survey survived, pray it’s the survey of income and program participation (sipp). it’s giant. it’s rich with variables. it’s monthly. it follows households over three, four, now five year panels. the congressional budget office uses it for their h...
7875 sym
analyze health professional shortage areas (hpsa) with r
a health professional shortage area (hpsa) is a geographic area, population group, or health care facility that has been designated by the united states government as having an insufficient supply of medical providers, based on certain provider-to-population ratios. primary care physician shortage areas are usually defined as any ge...
3591 sym
column-store R or: how i learned to stop worrying and love monetdb
“Combining R’s sophisticated calculations and MonetDB’s excellent data access performance is a no-brainer. One gets the best of two (open source) worlds with minimal hassle.” – Dr. Hannes Mühleisen“oh wow that was fast like a cheetah with a jetpack or something” – anthony damicowhy try monetdb + ra speed test of four analysis c...
6120 sym