🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 8 (from laksa095)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa008.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://www.presidency.ucsb.edu/statistics/data/final-presidential-job-approval-ratings\')), getAhrefsUnparsedNoserviceFromURL(\'https://www.presidency.ucsb.edu/statistics/data/final-presidential-job-approval-ratings\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/www.presidency.ucsb.edu\/statistics\/data\/final-presidential-job-approval-ratings","crawl_time":1775734720,"first_indexed_time":1570860064,"http_code":200,"src_unparsed":"edu,ucsb!presidency,www,\/statistics\/data\/final-presidential-job-approval-ratings s443","src_root_hash":"17349601505395987608","history_drop_reason":null,"meta_title":"Final Presidential Job Approval Ratings | The American Presidency Project","meta_descriptions":[],"attrs_boilerpipe_text":"Table entries are percentages from the population sample.\nYear\nInterview Dates\nPresident\nApproval\nDisapproval\n No Opinion\n1952\nDec. 11-16\nHarry S. Truman\n32\n56\n12\n1960\nDec. 8-13\nDwight D. Eisenhower\n59\n28\n13\n1969\nJan. 1-6\nLyndon B. Johnson\n49\n37\n14\n1974\nAug. 2-5\nRichard Nixon\n24\n66\n10\n1976\nDec. 10-13\nGerald Ford\n53\n32\n15\n1980\nDec. 5-8\nJimmy Carter\n34\n55\n11\n1988\nDec. 27-29\nRonald Reagan\n63\n29\n8\n1993\nJan. 8-11\nGeorge Bush\n56\n37\n7\n2001\nJan. 10-14\nWilliam J. Clinton\n66\n29\n5\n2009\nJan. 9-11\nGeorge W. Bush\n34\n61\n5\n2017\nJan. 17-19\nBarack Obama\n59\n37\n4\n2021\nJan. 4-15\nDonald Trump\n34\n62\n4\n2025\nJan. 2-16\nJoseph R. Biden, Jr.\n40\n54\n6\n*compiled from the Gallup Poll, these data exclude presidents who died in office (F. Roosevelt & Kennedy)\nCitations\nGerhard Peters. \"Final Presidential Job Approval Ratings.\"\nThe American Presidency Project\n. Ed. John T. Woolley and Gerhard Peters. Santa Barbara, CA: University of California. 1999-2025.","attrs_markdown":"[Skip to main content](https:\/\/www.presidency.ucsb.edu\/statistics\/data\/final-presidential-job-approval-ratings#main-content)\n\n[The American Presidency Project](https:\/\/www.presidency.ucsb.edu\/)\n\n[About](https:\/\/www.presidency.ucsb.edu\/about) [Search](https:\/\/www.presidency.ucsb.edu\/advanced-search)\n\n[![ucsb wordmark black](https:\/\/www.presidency.ucsb.edu\/sites\/default\/files\/pictures\/uc_santa_barbara_wordmark_black_rgb.svg)](https:\/\/www.ucsb.edu\/)\n\nToggle navigation\n\n- [Documents](https:\/\/www.presidency.ucsb.edu\/documents)\n  - [Guidebook](https:\/\/www.presidency.ucsb.edu\/documents\/presidential-documents-archive-guidebook)\n  - [Category Attributes](https:\/\/www.presidency.ucsb.edu\/documents\/category-attributes)\n- [Statistics](https:\/\/www.presidency.ucsb.edu\/statistics)\n  - [Data Archive](https:\/\/www.presidency.ucsb.edu\/statistics\/data)\n  - [Elections](https:\/\/www.presidency.ucsb.edu\/statistics\/elections)\n- [Media Archive](https:\/\/www.presidency.ucsb.edu\/media)\n- [Presidents](https:\/\/www.presidency.ucsb.edu\/presidents)\n- [Analyses](https:\/\/www.presidency.ucsb.edu\/analyses)\n- [GIVE](https:\/\/give.ucsb.edu\/campaigns\/58728\/donations\/new)\n\n## Statistics\n- [Data Archive](https:\/\/www.presidency.ucsb.edu\/statistics\/data)\n- [Elections](https:\/\/www.presidency.ucsb.edu\/statistics\/elections)\n\n# Final Presidential Job Approval Ratings\nTruman - Biden\n\nTable entries are percentages from the population sample.\n\n|   |   |   |   |   |   |\n|---|---|---|---|---|---|\n| **Year** | **Interview Dates** | **President** | **Approval** | **Disapproval** | **No Opinion** |\n| 1952 | Dec. 11-16 | Harry S. Truman | 32 | 56 | 12 |\n| 1960 | Dec. 8-13 | Dwight D. Eisenhower | 59 | 28 | 13 |\n| 1969 | Jan. 1-6 | Lyndon B. Johnson | 49 | 37 | 14 |\n| 1974 | Aug. 2-5 | Richard Nixon | 24 | 66 | 10 |\n| 1976 | Dec. 10-13 | Gerald Ford | 53 | 32 | 15 |\n| 1980 | Dec. 5-8 | Jimmy Carter | 34 | 55 | 11 |\n| 1988 | Dec. 27-29 | Ronald Reagan | 63 | 29 | 8 |\n| 1993 | Jan. 8-11 | George Bush | 56 | 37 | 7 |\n| 2001 | Jan. 10-14 | William J. Clinton | 66 | 29 | 5 |\n| 2009 | Jan. 9-11 | George W. Bush | 34 | 61 | 5 |\n| 2017 | Jan. 17-19 | Barack Obama | 59 | 37 | 4 |\n| 2021 | Jan. 4-15 | Donald Trump | 34 | 62 | 4 |\n| 2025 | Jan. 2-16 | Joseph R. Biden, Jr. | 40 | 54 | 6 |\n\n\\*compiled from the Gallup Poll, these data exclude presidents who died in office (F. Roosevelt & Kennedy)\n### Citations\nGerhard Peters. \"Final Presidential Job Approval Ratings.\" The American Presidency Project. Ed. John T. Woolley and Gerhard Peters. Santa Barbara, CA: University of California. 1999-2025.\n\nThe American Presidency Project  \nJohn Woolley and Gerhard Peters  \n**[Contact](https:\/\/www.presidency.ucsb.edu\/contact)**\n\n[Twitter](https:\/\/twitter.com\/presidency_proj) [Facebook](https:\/\/www.facebook.com\/pg\/american.presidency.project\/)\n\nCopyright © The American Presidency Project  \n[Terms of Service](http:\/\/www.ucsb.edu\/terms-of-use) \\| [Privacy](https:\/\/www.privacy.ucsb.edu\/information-privacy\/website-privacy) \\| [Accessibility](https:\/\/www.presidency.ucsb.edu\/accessibility)\n\n![uc santa barbara logo](https:\/\/www.presidency.ucsb.edu\/sites\/default\/files\/pictures\/uc-santa-barbara-wordmark-white1x.svg)","attrs_readable_markdown":"Table entries are percentages from the population sample.\n\n|   |   |   |   |   |   |\n|---|---|---|---|---|---|\n| **Year** | **Interview Dates** | **President** | **Approval** | **Disapproval** | **No Opinion** |\n| 1952 | Dec. 11-16 | Harry S. Truman | 32 | 56 | 12 |\n| 1960 | Dec. 8-13 | Dwight D. Eisenhower | 59 | 28 | 13 |\n| 1969 | Jan. 1-6 | Lyndon B. Johnson | 49 | 37 | 14 |\n| 1974 | Aug. 2-5 | Richard Nixon | 24 | 66 | 10 |\n| 1976 | Dec. 10-13 | Gerald Ford | 53 | 32 | 15 |\n| 1980 | Dec. 5-8 | Jimmy Carter | 34 | 55 | 11 |\n| 1988 | Dec. 27-29 | Ronald Reagan | 63 | 29 | 8 |\n| 1993 | Jan. 8-11 | George Bush | 56 | 37 | 7 |\n| 2001 | Jan. 10-14 | William J. Clinton | 66 | 29 | 5 |\n| 2009 | Jan. 9-11 | George W. Bush | 34 | 61 | 5 |\n| 2017 | Jan. 17-19 | Barack Obama | 59 | 37 | 4 |\n| 2021 | Jan. 4-15 | Donald Trump | 34 | 62 | 4 |\n| 2025 | Jan. 2-16 | Joseph R. Biden, Jr. | 40 | 54 | 6 |\n\n\\*compiled from the Gallup Poll, these data exclude presidents who died in office (F. Roosevelt & Kennedy)\n### Citations\nGerhard Peters. \"Final Presidential Job Approval Ratings.\" The American Presidency Project. Ed. John T. Woolley and Gerhard Peters. Santa Barbara, CA: University of California. 1999-2025.","meta_canonical":null}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

7 days ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	0.2 months ago
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property	Value
URL	https://www.presidency.ucsb.edu/statistics/data/final-presidential-job-approval-ratings
Last Crawled	2026-04-09 11:38:40 (7 days ago)
First Indexed	2019-10-12 06:01:04 (6 years ago)
HTTP Status Code	200
Meta Title	Final Presidential Job Approval Ratings \| The American Presidency Project
Meta Description	null
Meta Canonical	null
Boilerpipe Text	Table entries are percentages from the population sample. Year Interview Dates President Approval Disapproval No Opinion 1952 Dec. 11-16 Harry S. Truman 32 56 12 1960 Dec. 8-13 Dwight D. Eisenhower 59 28 13 1969 Jan. 1-6 Lyndon B. Johnson 49 37 14 1974 Aug. 2-5 Richard Nixon 24 66 10 1976 Dec. 10-13 Gerald Ford 53 32 15 1980 Dec. 5-8 Jimmy Carter 34 55 11 1988 Dec. 27-29 Ronald Reagan 63 29 8 1993 Jan. 8-11 George Bush 56 37 7 2001 Jan. 10-14 William J. Clinton 66 29 5 2009 Jan. 9-11 George W. Bush 34 61 5 2017 Jan. 17-19 Barack Obama 59 37 4 2021 Jan. 4-15 Donald Trump 34 62 4 2025 Jan. 2-16 Joseph R. Biden, Jr. 40 54 6 *compiled from the Gallup Poll, these data exclude presidents who died in office (F. Roosevelt & Kennedy) Citations Gerhard Peters. "Final Presidential Job Approval Ratings." The American Presidency Project . Ed. John T. Woolley and Gerhard Peters. Santa Barbara, CA: University of California. 1999-2025.
Markdown	[Skip to main content](https://www.presidency.ucsb.edu/statistics/data/final-presidential-job-approval-ratings#main-content) [The American Presidency Project](https://www.presidency.ucsb.edu/) [About](https://www.presidency.ucsb.edu/about) [Search](https://www.presidency.ucsb.edu/advanced-search) [![ucsb wordmark black](https://www.presidency.ucsb.edu/sites/default/files/pictures/uc_santa_barbara_wordmark_black_rgb.svg)](https://www.ucsb.edu/) Toggle navigation - [Documents](https://www.presidency.ucsb.edu/documents) - [Guidebook](https://www.presidency.ucsb.edu/documents/presidential-documents-archive-guidebook) - [Category Attributes](https://www.presidency.ucsb.edu/documents/category-attributes) - [Statistics](https://www.presidency.ucsb.edu/statistics) - [Data Archive](https://www.presidency.ucsb.edu/statistics/data) - [Elections](https://www.presidency.ucsb.edu/statistics/elections) - [Media Archive](https://www.presidency.ucsb.edu/media) - [Presidents](https://www.presidency.ucsb.edu/presidents) - [Analyses](https://www.presidency.ucsb.edu/analyses) - [GIVE](https://give.ucsb.edu/campaigns/58728/donations/new) ## Statistics - [Data Archive](https://www.presidency.ucsb.edu/statistics/data) - [Elections](https://www.presidency.ucsb.edu/statistics/elections) # Final Presidential Job Approval Ratings Truman - Biden Table entries are percentages from the population sample. \| \| \| \| \| \| \| \|---\|---\|---\|---\|---\|---\| \| Year \| Interview Dates \| President \| Approval \| Disapproval \| No Opinion \| \| 1952 \| Dec. 11-16 \| Harry S. Truman \| 32 \| 56 \| 12 \| \| 1960 \| Dec. 8-13 \| Dwight D. Eisenhower \| 59 \| 28 \| 13 \| \| 1969 \| Jan. 1-6 \| Lyndon B. Johnson \| 49 \| 37 \| 14 \| \| 1974 \| Aug. 2-5 \| Richard Nixon \| 24 \| 66 \| 10 \| \| 1976 \| Dec. 10-13 \| Gerald Ford \| 53 \| 32 \| 15 \| \| 1980 \| Dec. 5-8 \| Jimmy Carter \| 34 \| 55 \| 11 \| \| 1988 \| Dec. 27-29 \| Ronald Reagan \| 63 \| 29 \| 8 \| \| 1993 \| Jan. 8-11 \| George Bush \| 56 \| 37 \| 7 \| \| 2001 \| Jan. 10-14 \| William J. Clinton \| 66 \| 29 \| 5 \| \| 2009 \| Jan. 9-11 \| George W. Bush \| 34 \| 61 \| 5 \| \| 2017 \| Jan. 17-19 \| Barack Obama \| 59 \| 37 \| 4 \| \| 2021 \| Jan. 4-15 \| Donald Trump \| 34 \| 62 \| 4 \| \| 2025 \| Jan. 2-16 \| Joseph R. Biden, Jr. \| 40 \| 54 \| 6 \| \compiled from the Gallup Poll, these data exclude presidents who died in office (F. Roosevelt & Kennedy) ### Citations Gerhard Peters. "Final Presidential Job Approval Ratings." The American Presidency Project. Ed. John T. Woolley and Gerhard Peters. Santa Barbara, CA: University of California. 1999-2025. The American Presidency Project John Woolley and Gerhard Peters [Contact](https://www.presidency.ucsb.edu/contact)* [Twitter](https://twitter.com/presidency_proj) [Facebook](https://www.facebook.com/pg/american.presidency.project/) Copyright © The American Presidency Project [Terms of Service](http://www.ucsb.edu/terms-of-use) \\| [Privacy](https://www.privacy.ucsb.edu/information-privacy/website-privacy) \\| [Accessibility](https://www.presidency.ucsb.edu/accessibility) ![uc santa barbara logo](https://www.presidency.ucsb.edu/sites/default/files/pictures/uc-santa-barbara-wordmark-white1x.svg)
Readable Markdown	Table entries are percentages from the population sample. \| \| \| \| \| \| \| \|---\|---\|---\|---\|---\|---\| \| Year \| Interview Dates \| President \| Approval \| Disapproval \| No Opinion \| \| 1952 \| Dec. 11-16 \| Harry S. Truman \| 32 \| 56 \| 12 \| \| 1960 \| Dec. 8-13 \| Dwight D. Eisenhower \| 59 \| 28 \| 13 \| \| 1969 \| Jan. 1-6 \| Lyndon B. Johnson \| 49 \| 37 \| 14 \| \| 1974 \| Aug. 2-5 \| Richard Nixon \| 24 \| 66 \| 10 \| \| 1976 \| Dec. 10-13 \| Gerald Ford \| 53 \| 32 \| 15 \| \| 1980 \| Dec. 5-8 \| Jimmy Carter \| 34 \| 55 \| 11 \| \| 1988 \| Dec. 27-29 \| Ronald Reagan \| 63 \| 29 \| 8 \| \| 1993 \| Jan. 8-11 \| George Bush \| 56 \| 37 \| 7 \| \| 2001 \| Jan. 10-14 \| William J. Clinton \| 66 \| 29 \| 5 \| \| 2009 \| Jan. 9-11 \| George W. Bush \| 34 \| 61 \| 5 \| \| 2017 \| Jan. 17-19 \| Barack Obama \| 59 \| 37 \| 4 \| \| 2021 \| Jan. 4-15 \| Donald Trump \| 34 \| 62 \| 4 \| \| 2025 \| Jan. 2-16 \| Joseph R. Biden, Jr. \| 40 \| 54 \| 6 \| \*compiled from the Gallup Poll, these data exclude presidents who died in office (F. Roosevelt & Kennedy) ### Citations Gerhard Peters. "Final Presidential Job Approval Ratings." The American Presidency Project. Ed. John T. Woolley and Gerhard Peters. Santa Barbara, CA: University of California. 1999-2025.
Shard	8 (laksa)
Root Hash	17349601505395987608
Unparsed URL	edu,ucsb!presidency,www,/statistics/data/final-presidential-job-approval-ratings s443