Discover rows from one country

curl "https://www.socialcrawl.dev/v1/prism/discover?keywords=mortgage%20renewal&platforms=reddit,twitter,news&country=CA&unknown_country=drop&limit=50" \
  -H "x-api-key: YOUR_API_KEY"

// discover-rows-by-country.ts
// Canadian posts about mortgage renewal, in English and French.
// Run with: SOCIALCRAWL_KEY=sc_... npx tsx discover-rows-by-country.ts

const KEY = process.env.SOCIALCRAWL_KEY;
if (!KEY) throw new Error("Set SOCIALCRAWL_KEY");

const BASE = "https://www.socialcrawl.dev/v1";

const url = new URL(`${BASE}/prism/discover`);
url.searchParams.set("keywords", "mortgage renewal,renouvellement hypothécaire");
url.searchParams.set("platforms", "reddit,twitter,news");
url.searchParams.set("country", "CA");
url.searchParams.set("languages", "en,fr");
url.searchParams.set("limit", "50");

const res = await fetch(url, { headers: { "x-api-key": KEY } });
const json = (await res.json()) as {
  success: boolean;
  credits_used: number;
  data: {
    summary: { geo: { fill_rate: number } };
    items: Array<{
      platform: string;
      url: string;
      language: string | null;
      geo: { country: { value: string; source: string } | null };
    }>;
  };
  error?: { message: string };
};
if (!json.success) throw new Error(json.error?.message ?? "discover failed");

const { summary, items } = json.data;
const byLanguage: Record<string, number> = {};
for (const row of items) {
  const lang = row.language ?? "unknown";
  byLanguage[lang] = (byLanguage[lang] ?? 0) + 1;
}
console.log(`rows: ${items.length}, by language: ${JSON.stringify(byLanguage)}`);
console.log(`kept rows with a country: ${Math.round(summary.geo.fill_rate * 100)}%`);
for (const row of items.slice(0, 3)) {
  console.log(
    `${row.platform} ${row.language} ${row.geo.country?.value} (${row.geo.country?.source}) ${row.url}`,
  );
}
console.log(`credits used: ${json.credits_used}`);

rows: 50, by language: {"en":24,"fr":25,"unknown":1}
kept rows with a country: 62%
reddit en CA (community) https://www.reddit.com/r/PersonalFinanceCanada/comments/1vymv47/...
twitter en CA (author_location) https://x.com/wealthmoose/status/2115580720366207028
news en CA (publisher_domain) https://www.ratehub.ca/blog/renewing-your-mortgage-in-2026-heres-what-to-expect/
(47 more rows)
credits used: 4