id
processing priority
4
site type
3 (personal blog or private political site, e.g. Blogspot, Substack, also small blogs on own domains)
review version
11
html import
20 (imported)
first seen date
2024-09-18 10:49:37
expired found date
-
created at
2024-09-18 10:49:37
updated at
2025-12-31 00:24:21
length
26
crc
19002
tld
2211
nm parts
0
nm random digits
0
nm rare letters
0
is subdomain of id
31727457 (substack.com)
previous id
0
replaced with id
0
related id
-
dns primary id
0
dns alternative id
0
lifecycle status
0 (unclassified, or currently active)
deleted subdomains
0
page imported products
0
page imported random
0
page imported parking
0
count skipped due to recent timeouts on the same server IP
0
count content received but rejected due to 11-799
0
count dns errors
0
count cert errors
0
count timeouts
0
count http 429
0
count http 404
0
count http 403
0
count http 5xx
0
next operation date
-
server bits
—
server ip
-
mp import status
20
mp rejected date
-
mp saved date
-
mp size orig
371900
mp size raw text
3086
mp inner links count
20
mp inner links status
10 (links queued, awaiting import)
title
description
image
site name
author
Jess Ramos
updated
2026-03-02 02:25:24
raw text
Big Data Energy⚡️ | Jess Ramos | Substack Subscribe Sign in Home Notes Archive Leaderboard About SQL Cheat Sheet from Basic to Advanced⚡️ What I've used most in my career as a Senior Data Analyst in Tech!🤩 May 31 • Jess Ramos 7 Share this post SQL Cheat Sheet from Basic to Advanced⚡️ jessramosdata.substack.com Copy link Facebook Email Note Other Latest Top Discussions Top 10 Tips to Optimize SQL Queries Don't be a chump and write slow, crappy code. Refactor and optimize 🤩 13 hrs ago 3 Share this post Top 10 Tips to Optimize SQL Queries jessramosdata.substack.com Copy link Facebook Email Note Other Data Analyst Resume Template Sep 10 • Jess Ramos Share this post Data Analyst Resume Template jessramosdata.substack.com Copy link Facebook Email Note Other SQL Interview Cheat Sheet Sep 7 • Jess Ramos 3 Share this post SQL Interview Cheat Sheet jessramosdata.substack.com Copy li...
redirect type
0 (-)
block type
0 (no issues)
detected language
1 (English)
category id
index version
1
spam phrases
0
text nonlatin
0
text cyrillic
0
text characters
2223
text words
441
text unique words
179
text lines
165
text sentences
16
text paragraphs
1
text words per sentence
27
text matched phrases
0
text matched dictionaries
0
links self subdomains
0
links other subdomains
3 - blog.dataengineer.io, big-data-energy-analytics.printify.me
links other domains
0
links spam adult
0
links spam random
0
links spam expired
0
links ext activities
0
links ext ecommerce
0
links ext finance
0
links ext crypto
0
links ext booking
0
links ext news
0
links ext leaks
0
links ext ugc
21 - substack.com, learnanalyticsengineering.substack.com, datastoryteller.substack.com, seattledataguy.substack.com, thedataecosystem.substack.com, linkedin.com
links ext klim
0
links ext generic
0
dol status
0
dol updated
2026-03-02 02:25:24
rss path
rss status
1 (priority 1 already searched, no matches found)
rss found date
-
rss size orig
0
rss items
0
rss spam phrases
0
rss detected language
0 (awaiting analysis)
inbefore feed id
-
inbefore status
0 (new)
sitemap path
sitemap status
40 (completed successful import of reports.txt file to table in_pages)
sitemap review version
2
sitemap urls count
28
sitemap urls adult
0
sitemap filtered products
0
sitemap filtered videos
0
sitemap found date
2024-09-21 21:26:08
sitemap process date
2024-09-21 21:26:12
sitemap first import date
-
sitemap last import date
2025-12-31 00:24:21