Working with Tables

Every registry table in Qope behaves the same way. Learn it once.

The toolbar

Each table has a single toolbar row above the columns. From left to right:

On narrower windows, button labels collapse to icons (hover for the name) and the filter chips fold into the Filters badge. On small screens the Compare toggle, the Freeze header icon and the keyboard icon are hidden.

The footer shows when the dataset was last refreshed on the left, and on the right Rows 1-25 of N, a rows-per-page menu, previous and next arrows and page numbers.

Search

Type in the Search box and press Enter.

• A row matches when every word of two or more letters or digits appears somewhere in its text columns. Counts and amounts are not searched.
• Search works together with your filters, and matching words are highlighted in the rows.
• Results are not ranked by relevance. They keep the table's current sort.
• On Providers, Facilities, Laboratories, Health Centers and NHSC Sites, typing a 10-digit US phone number in any format matches listed phone numbers.
• On Drug Pricing and Medicaid Rebate Drugs, an NDC typed with dashes is matched in its 11-digit form.
• Searches are limited to 80 characters.

When nothing matches, the table offers Clear search and, if filters are active, Search without filters. While a search is active, Watch and Map are unavailable; clear the search to use them. Saved views and exports include the search.

Filtering

Column header filters

Columns with a funnel icon next to the title can be filtered from the header. There are three kinds.

List filters. Most categorical columns open a searchable list of the values that exist under your other filters. Tick as many as you want -- multiple values are combined with OR. Type a few letters and press Enter to select every matching value at once. The funnel shows a count when more than one value is selected, and Clear removes them.

Multiple values appear in the URL joined with a pipe, for example ?state=NY|NJ|CT.

Search filters. A few high-cardinality fields -- Generic Name and Brand Name in NDC Directory, NDC and Description in Drug Pricing -- use a search box instead of a list, because listing every value would be useless. Type to see up to 100 matching values.

Date filters. Date columns open a Month and a Year selector. Filter by month alone, year alone, or both.

The filter panel

Filters opens a panel beside the table with every filter for that dataset. Each filter is a collapsible section that shows how many values you picked; state fields show as chips, and two-value fields show as Any plus the two values. Changes wait until you press Apply filters. Save view sits at the bottom of the panel. On phones the panel opens full screen.

Filter from a cell

Right-click a cell in a filterable column and choose Filter by "value" to filter the table to that value.

Default filters

The Providers table opens on Individual providers. The Individual / Organization switch also changes the columns -- organization name and subpart for organizations; first, middle and last name, gender and sole proprietor for individuals.

Clearing

Remove one filter with the x on its chip or Clear in its column header. Clear all removes every filter at once but keeps your search and the Individual / Organization choice.

Cohort scope

If you have an active cohort (see Cohorts), its states, specialties and drugs are applied automatically to any table that has a matching filter. The toolbar shows a badge with the cohort name and what it applied. Ignore turns the cohort off for this table and Apply turns it back on. Your own filter on the same field replaces the cohort value, and the badge marks it as overridden. Cohort values are not stored in saved views.

Displayed values

In FDA Approvals, products that have passed FDA review but cannot be marketed yet show the marketing status STAGED (PASSED FDA REVIEW) in the column, the column header filter and the filter chip. These are the staged generics used across Qope.

Sorting

Click a column title to sort ascending, and click again for descending. Sorting is server-side, so it sorts the whole result set, not the current page. The sort field and direction appear in the URL, and sorting returns you to page 1.

Each table has a default sort field, applied when you have not chosen one. You can also sort from the right-click menu.

Pages

• Rows per page: 25, 50 or 100, from the footer menu. 25 is the default.
• To change the default for every table, go to Settings and pick Default rows per page (Auto, 25, 50 or 100). It is saved in that browser only.
• Rows are sized so that 25 of them fill the visible area. With 50 or 100 rows per page, you scroll.

Saved views

Save view opens the Saved views dialog:

• Name this view saves the current filters, search and sort (names up to 40 characters).
• Saved lists your views with Open and delete. On Teams, a switch shares a view with your team, and views teammates share appear under From your team.
• Recent lists up to 8 filter combinations you used lately on this table, kept in this browser, so you can jump back without saving them.

See Pins and Saved Views.

Watching a view on Radar

The Watch button puts a filtered table on your Radar.

• Any table. Once at least one filter is set beyond the table's defaults, Watch adds that table view to Radar.
• Providers. With exactly one practice State (or one License State) and exactly one Primary Specialty, Watch tracks that provider market instead.
• When the filters do not qualify, the button is disabled with a hint: State + Specialty on Providers with no qualifying filters, clear search while a search is active, and too many filters when the view has too many filter values to watch.
• Watching a premium table needs Pro or Teams.

Compare (Providers)

On the Providers table, turn Compare off to Compare on. A checkbox column appears; select up to four providers and press Compare (it needs at least two) to open them side by side. See Compare.

Selection and copying

Tables behave like a spreadsheet. Click a cell to select it. Long text in a cell is cut off; clicking the cell expands it to its full text, and it stays expanded when you click it again. Shift + click extends the selection, and click and drag selects a range.

On a Mac, use Cmd in place of Ctrl. The keyboard icon in the toolbar shows the shortcut list at any time.

When cells are selected, a bar at the bottom of the screen shows the Count, and for numbers also the Sum, Avg, Min and Max.

Find on this page

Ctrl + F opens a find bar that highlights matches in the rows on screen. Enter and Shift + Enter step through matches, and Escape closes it. When nothing on the page matches, Search all pages runs the same words as a table search.

Right-click menu

Layout controls

• Freeze header -- keeps the column titles pinned under the top bar while you scroll. It is on by default; toggle it with the icon at the end of the toolbar. The setting is remembered in your browser.
• Column resizing -- drag a column border. Double-click the border to reset that column.
• Panning -- hold the middle mouse button and drag to move around a wide table. A horizontal scrollbar stays at the bottom of the table, and fade edges show when more columns are off-screen.
• Phones -- tables scroll sideways.

Row actions

• Profile -- tables whose records have a record page (Providers, Facilities, ACO Networks) have a pinned Profile column with a View button. It remembers where you came from, so the record page can send you back to the same filtered view.
• Pin -- pin a record from its record page. Pinned records for the current table appear under the pin icon in the toolbar.
• Expand -- in Trials, clicking a row expands the full study detail under it.

Refresh dates

The table footer shows Last refreshed with the date the dataset was last updated; hover it for the exact time. The Medicare tables (Prov Summary, Prov Services, Prov Drugs) also show the data year, for example CMS 2024 data. See Freshness.

When a table does not load

• If the data service is unavailable, Qope shows Temporarily Unavailable rather than an empty table. Check back later.
• If the page fails for another reason, an error page offers Try again.
• If you have no active plan, the page shows Subscription Required. If you have used up your monthly credits, it shows Monthly Limit Reached.
• If the dataset is premium and your plan does not include it, it shows the upgrade panel.

Values that cannot be filtered

Some source values contain a comma, for example a recall that lists two generic names in one field. Commas separate multiple values in a filter, so picking such a value can return no rows even though the list offered it. Use the Search box to find those rows instead. See Data Caveats.