Pricing

$0.05 / useful report

Try for free

Go to Apify Store

Dataset Join Preflight

Try for free

Measure duplicate keys, orphan rows, and exact equijoin expansion before joining two datasets.

Pricing

$0.05 / useful report

Rating

0.0

(0)

Developer

L3Digital

Actor stats

Bookmarked

Total users

Monthly active users

3 days ago

Last modified

Categories

Developer tools

Schema version

schemaVersion

Optional

Version of the report contract.

Type:string | null

Example:

1.0

Options:

1.0

Input SHA-256

inputSha256

Optional

Digest of the canonical validated input JSON.

Type:string | null

Example:

a0f6c2a88f412b3741e08df72e6cc234756f4f597f540b7e110461f60848a5d0

Left rows

leftRowCount

Optional

Number of records supplied on the left side.

Type:integer | null

Minimum:0

Example:

Right rows

rightRowCount

Optional

Number of records supplied on the right side.

Type:integer | null

Minimum:0

Example:

Left key coverage

leftKeyCoverage

Optional

Complete accounting of left-side row key states and matches.

Type:object | null

Example:

{
  "totalRows": 3,
  "validRows": 3,
  "matchedRows": 2,
  "orphanRows": 1
}

Right key coverage

rightKeyCoverage

Optional

Complete accounting of right-side row key states and matches.

Type:object | null

Example:

{
  "totalRows": 3,
  "validRows": 3,
  "matchedRows": 2,
  "orphanRows": 1
}

Cardinality

cardinality

Optional

Multiplicity among keys present on both sides.

Type:string | null

Example:

many-to-many

Options:

no-matchone-to-oneone-to-manymany-to-onemany-to-many

Inner join rows

innerJoinRows

Optional

Exact number of rows an equijoin inner join would produce.

Type:integer | null

Minimum:0

Example:

Left join rows

leftJoinRows

Optional

Exact number of rows an equijoin left join would produce.

Type:integer | null

Minimum:0

Example:

Duplicates

duplicates

Optional

Repeated valid keys and rows beyond their first occurrence.

Type:object | null

Example:

{
  "leftKeys": 1,
  "leftRows": 1,
  "rightKeys": 1,
  "rightRows": 1
}

Orphans

orphans

Optional

Valid orphan keys and all rows unable to match.

Type:object | null

Example:

{
  "leftKeys": 1,
  "leftRows": 1,
  "rightKeys": 1,
  "rightRows": 1
}

Warnings

warnings

Optional

Deterministic notices about invalid keys or many-to-many expansion.

Type:string[] | null

Max. items:3

Example:

[
  "Matched duplicate keys on both sides expand the inner join many-to-many."
]

Key examples

keyExamples

Optional

Up to five typed duplicate or orphan keys, present only when requested.

Type:object[] | null

Max. items:5

Example:

[
  {
    "side": "left",
    "category": "duplicate",
    "keyType": "integer",
    "value": 42,
    "occurrences": 2
  }
]

Other properties may be included.

Twitter Trends Scraper With Rank History & Staying Power

scrapier/getdaytrends-trending-scraper

Twitter Trends Scraper with Rank History & Staying Power: Track trending topics, ranks, timestamps, locations, duration, and staying power on X. Analyze trend momentum, identify emerging topics, monitor audience interests, research competitors, and build structured datasets for trend analysis.

Scrapier

EU Air Passenger Flow — By Country & Traffic Type, Per Record

nexgensignal/eu-air-passenger-flow-records

Eurostat air-passenger-transport statistics (avia_paoc) as clean, flat, per-record traffic-flow benchmarks — passengers by traffic measurement, national/international coverage and schedule type, per reporting country. Licence-clean, verbatim values, $0.05 per record.

NexGen Signal

Realtor.ca Scraper

haketa/realtor-ca-scraper

Realtor.ca scraper & API for Canadian real estate: search homes for sale & rent and export address, price, beds, baths, property type, MLS number, description, agent & brokerage, photos and GPS coordinates. Canada property market data and real-estate lead generation — fast, no login.

Haketa

Google Maps Email Extractor & Lead Scraper

highbrow_fame/google-maps-email-extractor

Extract business emails and leads from Google Maps. Finds the contact page under its native name - impressum, kapcsolat, contatti and 44 more across ten languages - then grades every address with MX, SPF, DMARC and catch-all detection. Measured: 71% of rows returned an email.

yestrue

Facebook Groups Scraper – Posts, Comments & Replies [No Login]✅

unseenuser/fb-groups

Scrape public Facebook group posts with full comment threads and replies - no login, no cookies, never member data. The only Groups scraper that returns complete comment threads. Export JSON, CSV, or Excel.

Unseen User

5.0

(3)

AutoScout24 Clean Scraper with 75 typed fields, 8 EU domains

hardy_ice-owner/autoscout24-clean-scraper-py

75 typed fields per AutoScout24 listing across 8 EU domains (DE/FR/IT/ES/NL/AT/BE/EN). VIN, GPS, VAT, accident history, TÜV, structured equipment. Pay-per-vehicle $0.004 — failed records never charge. MCP-ready for AI agents. Idempotent UUID dedup, schema versioned.

Tars Technology

5.0

(1)

Lead Enrichment Pipeline — 5-47x Cheaper Than Clay

ryanclinton/lead-enrichment-pipeline

All-in-one lead enrichment: email discovery, phone finding, verification, company research, and lead scoring in one run. CSV or JSON in, scored leads out. $0.12/lead — 5-47x cheaper than Clay.

Ryan Clinton

107

1.0

(1)

Google Maps Extractor Listing Completeness Audit

scrapier/google-maps-extractor

Google Maps Extractor: Extract business listings with names, categories, ratings, reviews, addresses, phone numbers, websites, hours, and Google Maps URLs. Audit listing completeness to identify missing business information, optimize local profiles, and uncover data quality gaps.

Scrapier

Childcare Provider Leads — Daycare Contact Lists + Compliance

malonestar/childcare-provider-leads

Licensed childcare provider lead lists from official state licensing data with direct phone AND email contacts (Texas HHSC). Filter by county, type, capacity, ages served; each lead scored with 2-year deficiency counts + high-risk flag. Delta mode alerts on newly licensed operations.

Kyle Maloney

Work Email Finder - Name + Domain to Email, Pattern & Score

scrapersdelight/work-email-finder-scraper

Give it a first name, last name and company domain; get back ranked work-email candidates. Each guess is built from REAL addresses observed at that domain (GitHub, npm, team pages) plus MX/SPF/DMARC, so the confidence score is earned, not invented. Source URLs on every row. No fake SMTP checks.

Scrapers Delight

EPA GHGRP Emitter Screener — Facility CO2e, Gases & Trend

malonestar/epa-ghgrp-emitter-screener

Every large US greenhouse-gas emitter from EPA GHGRP, on EPA’s own basis: direct CO2e excluding biogenic, with supplier volume and injected CO2 kept separate. Per-gas split (CO2/CH4/N2O/fluorinated), subparts, parent company, YoY delta, multi-year trend, rank and proximity mode. Keyless.

Kyle Maloney