Data Analytics and the Law: Acquiring Data

Evidence based on Data Analytics hinges on the relevance of its underlying sources. Determining what potential data sources can prove is as important as generating an analysis. The first question should be “What claims do I want to assert with data?” The type of case and nature of the complaint should inform litigants where they should start looking in discovery. For example, a dataset of billing information could determine whether or not a healthcare provider committed fraud. Structured data sources like Excel files, SQL servers, or third party databases (e.x. Oracle), are the primary source material for statistical analyses, particularly those using transactional data.

 

In discovery, it’s important that both parties be aware of these structured data sources. Often, these sources do not have a single designated custodian, rather they may be the purview of siloed departments or an IT group. For any particular analysis, rarely is all the necessary data all held in one place. Identifying valuable source material is more difficult as the complexity of interactions between different sources increases. To efficiently stitch together smaller databases and tables, a party should conduct detailed data mapping by identifying links between structured data sources. For example, how two tables relate to another, how a SQL table relates to an Excel file, or how a data cube relates to a cloud file. Data mapping identifies which structured data sources are directly linked to one another through their variables, and how they as a whole fit together in an analysis.

 

However when using data based evidence to answer a question, structured data is rarely clean and/or well organized. Variables defined in a table may be underutilized or unused. Legacy files imported into newer systems can become corrupted. The originators of macros or scripts for data pulls may no longer work for an organization and forgo detailed instructions. Sometimes the data simply do not exist: not from a party burying evidence, but by the very nature of electronically stored information (ESI).

 

Any defensible analysis is inherently limited by what data is available. With data analytics the maxim “evidence of absence, is not absence of evidence,” is apparent. It’s always more dangerous to exaggerate or generalize from the available data than to produce a narrow, but statistically sound result. Thus, given the data available, what questions can be asked? What questions can be answered? Finally, if there is no data, does it mean there is no problem?

Texas RN’s, therapists, and PA’s see annual increase in job openings from July 2014

nursing_symbol

The number of job openings in Texas for nurses, therapists, and physician assistants increased from 10,068 to 13,438 from July 2014 to July 2015. The searcher-to-job opening ratio increased from 1.48 to 1.85 during that same span.

nurse_2015_07

Source: BLS

Image source: http://www.carrollhs.org/s/1253/index.aspx?pgid=877

Texas healthcare jobs increased by 0.7% from Aug to Sept

healthcareThe health care and social assistance industry gained 9,200 jobs from August 2015 to September 2015. Compared to September 2014, the cumulative number of jobs added in this industry is 67,000, an annual increase of 5.0%.

Source: http://www.tracer2.com/admin/uploadedPublications/2138_TLMR-Current_Edition.pdf

Image source: http://blogs.wsj.com/health/2012/01/06/health-care-sector-adds-jobs-as-overall-employment-picture-looks-healthier/

Texas health care jobs increased by 0.4% from May to June

healthcare

The health care and social assistance industry gained 5,100 jobs from May 2015 to June 2015. Compared to June 2014, the cumulative number of jobs added in this industry is 56,400, an annual increase of 4.2%.

Source: http://www.tracer2.com/admin/uploadedPublications/2138_TLMR-Current_Edition.pdf

Image source: http://blogs.wsj.com/health/2012/01/06/health-care-sector-adds-jobs-as-overall-employment-picture-looks-healthier/

California RN’s, PA’s, and therapists see decrease in job openings from April to May

healthcare

The number of job openings in California for nurses, therapists, and physician assistants decreased from 20,399 in April 2015 to 18,450 in May 2015. The searcher-to-job opening ratio increased from 2.16 to 2.39 in the same span.

nurse_2015_05

 

Source: BLS

Image source: http://pediatric-nurse-practitioners.blogspot.com/2012/12/top-5-cardiac-care-nursing-jobs-for-we.html

Texas RN’s, therapists, and PA’s see increase in job openings from Mar to Apr

nursing_symbol

The number of job openings in Texas for nurses, therapists, and physician assistants increased from 10,370 to 12,724 from March 2015 to April 2015. The searcher-to-job opening ratio increased from 0.71 to 1.39 during that same span.

nurse_2015_04

Source: BLS

Image source: http://www.carrollhs.org/s/1253/index.aspx?pgid=877

California RN’s, PA’s, and therapists see increase in job openings from Mar to Apr

healthcare

The number of job openings in California for nurses, therapists, and physician assistants increased from 15,983 in March 2015 to 20,399 in April 2015. The searcher-to-job opening ratio increased from 1.22 to 2.16 in the same span.

 

nurse_2015_04

Source: BLS

Image source: http://pediatric-nurse-practitioners.blogspot.com/2012/12/top-5-cardiac-care-nursing-jobs-for-we.html

Texas healthcare jobs increased by 0.5% from Feb to Mar

healthcare

The health care and social assistance industry gained 7,000 jobs from February 2015 to March 2015. Compared to March 2014, the cumulative number of jobs added in this industry is 49,900, an annual increase of 3.8%.

Source:http://www.tracer2.com/admin/uploadedPublications/2133_TLMR-March_15.pdf

Image source: http://blogs.wsj.com/health/2012/01/06/health-care-sector-adds-jobs-as-overall-employment-picture-looks-healthier/

CPI rose while medical care commodities and medical services fell from Jan to Feb

cpi

general_inflation_2015_02The consumer price index (CPI) went up from 234.677 in January 2015 to 235.186 in February 2015, an annualized rate of 2.60%.

medical_commodities_2015_02 medical_services_2015_02

The price index for medical care commodities went down at an annualized rate of 0.06% from January 2015 to February 2015. During the same period, the price index decreased for medical care services (2.31%), hospital and related services (2.32%), and professional services (1.86%).

Source: BLS

Image source: http://www.shutterstock.com/pic-54762670/stock-photo-background-concept-illustration-consumer-price-index.html

Texas RN’s, therapists, and PA’s see increase in job openings from Dec to Jan

nursing_symbol

The number of job openings in Texas for nurses, therapists, and physician assistants increased from 10,144 to 10,588 from December 2014 to January 2015. The searcher-to-job opening ratio increased from 0.63 to 0.91 during that same span.

nurse_2015_01

Source: BLS

Image source: http://www.carrollhs.org/s/1253/index.aspx?pgid=877