# Bulk download views

Source: https://developers.novilabs.com/data/tables/downloads/

> The two views that list the full and diff zip files your account can download.

Load a full zip once from `DOWNLOADS_FULL`, then apply the diff zips from `DOWNLOADS_DIFF` in `RUN_ID` order. Each row has a download URL that stops working 2 hours after you query it. See [Delivery options](https://developers.novilabs.com/data/delivery/#bulk-files) for the full procedure.

Views live in `NOVI_DATA_ACCESS.NOVI_WELLS`. Column descriptions are from the Wells data dictionary, release 26.4.3.

## DOWNLOADS_FULL

Full zip files you can download: the latest complete extract of each basin, one row per basin. Load a full zip once, then apply the diff zips of later runs from `DOWNLOADS_DIFF` to keep it current. Lists only the zips your account is entitled to; the USA zip needs every US basin.

| Column | Description |
| --- | --- |
| `RUN_ID` | Run that produced the zip, as `YYYYMMDD_HHMISS` in UTC. After you load the zip, your data matches this run. |
| `BASIN` | Basin the zip covers, or USA for the country zip that holds every US basin. |
| `ZIP_NAME` | Name of the zip, the same as BASIN. The downloaded file has a different name, which contains `RUN_ID`. |
| `RUN_AT_UTC` | `RUN_ID` as a UTC timestamp. |
| `ZIP_SIZE_MB` | Size of the zip file in megabytes. |
| `URL` | Download link for the zip. The link is created when you query the view and stops working 2 hours later; query the view again for a new link. A download that has started continues after the link expires. |

## DOWNLOADS_DIFF

Diff zip files you can download, one row per basin per run. Each diff holds the changes from `BASE_RUN_ID` to `RUN_ID`, so it applies only on top of the data from `BASE_RUN_ID`. Apply diffs in `RUN_ID` order; if a `BASE_RUN_ID` is not the run you hold, download the full zip from `DOWNLOADS_FULL` instead. Lists only the zips your account is entitled to; the USA zip needs every US basin.

| Column | Description |
| --- | --- |
| `BASE_RUN_ID` | Run the diff starts from, as `YYYYMMDD_HHMISS` in UTC. Apply the diff only to data from this run. |
| `RUN_ID` | Run that produced the zip, as `YYYYMMDD_HHMISS` in UTC. After you apply the diff, your data matches this run. |
| `BASIN` | Basin the zip covers, or USA for the country zip that holds every US basin. Joins to `DOWNLOADS_FULL`.BASIN. |
| `ZIP_NAME` | Name of the zip: the basin name followed by --DIFF. The downloaded file has a different name, which contains `RUN_ID`. |
| `DAYS_PRIOR` | Position of this run among the diff runs: 1 for the newest, 2 for the run before it. It counts runs, not calendar days; runs happen on weekdays only. The same value names the same run in every basin. |
| `BASE_RUN_AT_UTC` | `BASE_RUN_ID` as a UTC timestamp. |
| `RUN_AT_UTC` | `RUN_ID` as a UTC timestamp. |
| `ZIP_SIZE_MB` | Size of the zip file in megabytes. |
| `URL` | Download link for the zip. The link is created when you query the view and stops working 2 hours later; query the view again for a new link. A download that has started continues after the link expires. |
