Box office data for Film projects is provided via VW_BOX_OFFICE_DS. The view contains one row per film (FTV_LUMINATE_PROJECT_ID) and includes cumulative totals as well as nested daily, weekend, and weekly domestic breakdowns and per-territory international breakdowns.

Use FTV_LUMINATE_PROJECT_ID to join to VW_FILM_PROJECTS_DS.

Column Reference

Field Name	Type	Description
FTV_LUMINATE_PROJECT_ID	VARCHAR	Unique Luminate ID pertaining to the film. Use this key to join to `VW_FILM_PROJECTS_DS`.
TITLE	VARCHAR	Title of the film.
RE_RELEASED	BOOLEAN	`TRUE` if the film has been re-released theatrically. `FALSE` otherwise.
ALL_RELEASE_BOX_OFFICE_DOM_CUME	NUMBER	Cumulative domestic box office in USD across all releases (original and re-release), as a plain number (e.g. `7317.00`).
ALL_RELEASE_BOX_OFFICE_INTL_CUME	NUMBER	Cumulative international box office in USD across all releases, as a plain number.
ALL_RELEASE_BOX_OFFICE_WW_CUME	NUMBER	Cumulative worldwide box office in USD across all releases, as a plain number.
DOMESTIC_BOX_OFFICE_CUME	OBJECT	Domestic cumulative box office, keyed by release year and release type. See DOMESTIC_BOX_OFFICE_CUME.
DOMESTIC_BOX_OFFICE_CUME_DATA	OBJECT	Domestic daily, weekend, and weekly box office detail. See DOMESTIC_BOX_OFFICE_CUME_DATA.
FOREIGN_TERRITORY_CUME_DATA	OBJECT	International weekend box office detail, keyed by release year and territory. See FOREIGN_TERRITORY_CUME_DATA.
WW_BOX_OFFICE_CUME	OBJECT	Worldwide cumulative box office, keyed by release year and release type. Same structure as `DOMESTIC_BOX_OFFICE_CUME`.

Nested Column Detail

DOMESTIC_BOX_OFFICE_CUME

Also applies to WW_BOX_OFFICE_CUME. An object keyed by release year, then by release type. Each release type holds an array containing the cumulative box office as a formatted dollar string.

{
  "2019": {
    "ORIGINAL RELEASE": [
      "$7,317"
    ]
  }
}

Key	Description
year	Release year (e.g. `"2019"`). May be an empty string (`""`) when the release year is unknown.
release_type	Type of release.
value	Array with a single string, the cumulative box office in USD formatted with a `$` and thousands separators (e.g. `"$17,163,667"`). A value of `"$0"` indicates a release with no reported gross.

DOMESTIC_BOX_OFFICE_CUME_DATA

An object with up to three keys, daily_data, weekend_data, and weekly_data. Each key is only present when data exists. When no breakdown is available, the value is an empty string ("").

{
  "daily_data": "",
  "weekend_data": "",
  "weekly_data": ""
}

When populated, each key holds an object keyed by release year, containing an array of records with newest first.

daily_data

Key	Description
date	Date of the box office record (`MM/DD/YYYY`).
DAY#	Number of days since release.
DAILY B.O.	Box office for the day, formatted as a dollar string.
B.O. CUME	Cumulative box office through that day.
%CHANGE	Percent change from the previous day.
release_type	Type of release, e.g. `ORIGINAL RELEASE`.

{
  "2019": [
    {
      "%CHANGE": "+17.9%",
      "B.O. CUME": "$319,979",
      "DAILY B.O.": "$1,278",
      "DAY#": "28",
      "date": "10/31/2019",
      "release_type": "ORIGINAL RELEASE"
    }
  ]
}

weekend_data

Key	Description
weekend	Weekend date range (`MM/DD/YYYY - MM/DD/YYYY`).
week_no	Week number since release.
weekend_bo	Box office for the weekend, formatted as a dollar string.
boxoffice_cum	Cumulative box office through that weekend.
engagements	Number of theatres/engagements the film played in.
avg_psa	Average box office per screen (PSA) for the weekend.
percentage_change	Percent change in weekend box office from the previous weekend.
release_type	Type of release, e.g. `ORIGINAL RELEASE`.

weekly_data

Key	Description
week_of	Week date range (`MM/DD/YYYY - MM/DD/YYYY`).
week_no	Week number since release.
weekly_bo	Box office for the week, formatted as a dollar string.
boxoffice_cum	Cumulative box office through that week.
engagements	Number of theatres/engagements the film played in.
avg_psa	Average box office per screen (PSA) for the week.
percentage_change	Percent change in weekly box office from the previous week.
release_type	Type of release, e.g. `ORIGINAL RELEASE`.

{
  "weekend_data": {
    "2019": [
      {
        "avg_psa": "$1,232",
        "boxoffice_cum": "$7,054",
        "engagements": "1",
        "percentage_change": "-2",
        "release_type": "ORIGINAL RELEASE",
        "week_no": "2",
        "weekend": "10/18/2019 - 10/20/2019",
        "weekend_bo": "$1,234"
      }
    ]
  },
  "weekly_data": {
    "2019": [
      {
        "avg_psa": "$1,940",
        "boxoffice_cum": "$5,829",
        "engagements": "3",
        "percentage_change": "",
        "release_type": "ORIGINAL RELEASE",
        "week_no": "1",
        "week_of": "10/11/2019 - 10/17/2019",
        "weekly_bo": "$5,824"
      }
    ]
  }
}

FOREIGN_TERRITORY_CUME_DATA

An object keyed by release year, then by territory name (e.g. United Kingdom, Australia, Russia/CIS, The Netherlands). Each territory holds an array of weekend records, newest first.

Key	Description
WEEKEND	Weekend date range (`MM/DD/YYYY-MM/DD/YYYY`).
WEEK#	Week number since release in the territory.
WEEKEND B.O.	Box office for the weekend, in USD, formatted as a dollar string.
B.O. CUME	Cumulative box office in the territory through that weekend.
ENGMTS.	Number of theatres/engagements.
AVG (PSA)	Average box office per screen for the weekend.
%CHANGE	Percent change from the previous weekend. Empty for the opening weekend.
release_type	Type of release, e.g. `ORIGINAL RELEASE`.

{
  "2019": {
    "United Arab Emirates": [
      {
        "%CHANGE": "-94%",
        "AVG (PSA)": "176",
        "B.O. CUME": "$48,897",
        "ENGMTS.": "2",
        "WEEK#": "3",
        "WEEKEND": "11/12/2020-11/15/2020",
        "WEEKEND B.O.": "$353",
        "release_type": "ORIGINAL RELEASE"
      }
    ]
  }
}

Notes

Key naming differs between domestic and international. Domestic weekend/weekly records use lowercase snake_case keys (weekend_bo, boxoffice_cum), while international and domestic daily records use uppercase keys with punctuation (WEEKEND B.O., B.O. CUME). Account for this when parsing.
Dollar values in nested columns are strings. Parse them (strip $ and ,) before aggregating. The ALL_RELEASE_* columns are already numeric.
Year keys reflect the release year, not the year of the individual weekend. A 2019 release can have weekend records dated in 2020. The year key is an empty string for some films with an unknown release year.
Missing data. Not all films have daily, weekend, and weekly detail; international detail is provided at the weekend level only when available.
Re-releases. RE_RELEASED flags films with a re-release, and the ALL_RELEASE_* columns include re-release grosses. Nested columns separate grosses by release_type.