Sample

The license file, fifty rows of it

The license is four datasets — every covered entity, every contract pharmacy, every value that changed, and the cost report each hospital filed — as CSV and Parquet, with the column schema below and a manifest of the report each file was built from. This sample is the first fifty rows of the register, in the file’s own column order.

What arrives

The excerpt, as a file

The same fifty rows the table below shows, as a CSV and a Parquet file, each opening with SAMPLE — 50 of 94,381 rows.

• covered_entities.sample.csv — the column schema above, 50 rows.
• covered_entities.sample.parquet — the same rows, same columns.
• portfolio_roster.sample.csv — a sample roster export of the facilities a portfolio watch follows.

covered_entities — schema

entity_340b_id · ce_id · entity_type · entity_name · sub_division_name · participating_raw · participating_start_date · termination_date · termination_reason · certified_date · parent_340b_id · site_id · grant_number · ccn · npi · medicaid_number · rural · street_address_1 · street_address_2 · street_city · street_state · street_zip · edit_date · first_seen_file_date · last_seen_file_date · source_file · source_url

covered_entities — the first 50 rows

SAMPLE — 50 of 94,381 rows

Scopes and prices

One state $7,500/year

Every covered entity in a state, its sites and its contract pharmacies, with the daily history.

The whole register, internal use $35,000/year

Every entity, every site, every arrangement, and every filed cost report, for use inside your own organization.

Enterprise, with redistribution $95,000/year

The same file, with the right to build it into something you sell or publish.

Every figure in the file is the value its source document printed, with the file it came from and the date its publisher stamped inside it. Buy a license.