# Httparchive.technologies table gone on big query?

**URL:** <https://discuss.httparchive.org/t/httparchive-technologies-table-gone-on-big-query/2917>\
**Category:** Analysis\
**Created:** [April 21, 2025, 6:29pm UTC](https://discuss.httparchive.org/t/httparchive-technologies-table-gone-on-big-query/2917 "2025-04-21T18:29:47Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![tunetheweb](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/tunetheweb/32/1671_2.png) [@tunetheweb](https://discuss.httparchive.org/u/tunetheweb)\
**Post date:** [April 21, 2025, 10:24pm UTC](https://discuss.httparchive.org/t/httparchive-technologies-table-gone-on-big-query/2917/2 "2025-04-21T22:24:48Z")

</div>

Yes this dataset is now gone, but the data resides in the `crawl` dataset.

See this notice: [[NOTICE] Reorganizing the har and runs datasets on BigQuery](https://discuss.httparchive.org/t/notice-reorganizing-the-har-and-runs-datasets-on-bigquery/1235)

Here’s an example query to find all WordPress sites in the top 1,000 pages:

```sql
SELECT
  COUNT(DISTINCT root_page) AS num_origins
FROM
  `httparchive.crawl.pages`
WHERE
  date = '2024-04-01' AND
  rank <= 1000 AND
  'WordPress' IN UNNEST (technologies.technology)

```

---

_[View the full topic](https://discuss.httparchive.org/t/httparchive-technologies-table-gone-on-big-query/2917)._
