# Can I access to raw results of Web Almanac markup query from google BigQuery?

**URL:** <https://discuss.httparchive.org/t/can-i-access-to-raw-results-of-web-almanac-markup-query-from-google-bigquery/2841>\
**Category:** Uncategorized\
**Created:** [December 7, 2024, 6:12pm UTC](https://discuss.httparchive.org/t/can-i-access-to-raw-results-of-web-almanac-markup-query-from-google-bigquery/2841 "2024-12-07T18:12:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![silentimp](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/silentimp/32/2253_2.png) [@silentimp](https://discuss.httparchive.org/u/silentimp)\
**Post date:** [December 7, 2024, 6:12pm UTC](https://discuss.httparchive.org/t/can-i-access-to-raw-results-of-web-almanac-markup-query-from-google-bigquery/2841/1 "2024-12-07T18:12:15Z")

</div>

Hi,  
I want to know the adoption of `details`, `summary` and `dialog` html elements, ideally with change over years.  
And maybe it’s bit too early, but popover and invoker commands-related attributes.

I did try to create a [query](https://gist.github.com/SilentImp/d94e7459bcadcef35af0a7dcf5d9bba5) for this and run over google BigQuery, but it seems it’s far outside of something I can do for free.  
Any way access this data without paying?  
I was trying set up free tier or something but go nowhere, google demand billing and don’t accept my cards for some reason.

Regards. Anton Nemtsev.

---

<div class="post-metadata">

**Author:** ![imkevdev](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/imkevdev/32/1941_2.png) [@imkevdev](https://discuss.httparchive.org/u/imkevdev)\
**Post date:** [December 12, 2024, 12:31pm UTC](https://discuss.httparchive.org/t/can-i-access-to-raw-results-of-web-almanac-markup-query-from-google-bigquery/2841/2 "2024-12-12T12:31:24Z")

</div>

Hi,

You can view the query that was used in the Web Almanac by clicking on the three dots beside any chart or table.

 ![Screenshot of Web Almanac Markup chapter showing the table with the Top Elements and a small select with View data and View query options](https://canada1.discourse-cdn.com/flex035/uploads/httparchive/original/2X/c/cbdb12115b35913cf08dd0bc10c0b6889ac86304.png)

In the preceding screenshot, clicking View Data will take you to the [Results sheet](https://docs.google.com/spreadsheets/d/1TtOMr_w58HvqNBv4RIWX021Lxm6m5ajYOcRykrPdAJc/edit?gid=248650818#gid=248650818) and View Query will take you to the [SQL query](https://github.com/HTTPArchive/almanac.httparchive.org/blob/main/sql/2024/markup/element_frequency.sql). `dialog`, `details`, and `summary` are all present in the full result set.

| client | name | pages | total\_pages | pct\_pages |
| --- | --- | --- | --- | --- |
| mobile | summary | 1,065,277 | 30,046,933 | 3.5% |
| desktop | summary | 807,844 | 24,167,800 | 3.3% |
| mobile | details | 1,063,591 | 30,046,933 | 3.5% |
| desktop | details | 805,687 | 24,167,800 | 3.3% |
| mobile | dialog | 76,293 | 30,046,933 | 0.3% |
| desktop | dialog | 69,877 | 24,167,800 | 0.3% |

Let me know if that helps.

---

<div class="post-metadata">

**Author:** ![silentimp](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/silentimp/32/2253_2.png) [@silentimp](https://discuss.httparchive.org/u/silentimp)\
**Post date:** [December 12, 2024, 2:46pm UTC](https://discuss.httparchive.org/t/can-i-access-to-raw-results-of-web-almanac-markup-query-from-google-bigquery/2841/3 "2024-12-12T14:46:51Z")

</div>

Was it helpful you ask?  
You just make my day a whole lot better!  
I love you @imkevdev!  
Thank you very much!