Reaction data collector
Pulls the Reddit record for every decision in the calibration set and writes the measurement columns. Every search term is shown in the table and can be edited before you run it.
Relay setup
Arctic Shift does not permit a browser on another domain to read its data, so the pull goes through a relay on your own Cloudflare account. It fetches the data and adds the missing permission. The address check inside it means the relay can only ever reach Arctic Shift.
- Cloudflare dashboard, Workers & Pages, Create, then Worker. Name it anything.
- Replace everything in the editor with the code below, then Deploy.
- Copy the
workers.devaddress Cloudflare shows you and paste it in the relay box.
export default {
async fetch(request) {
const target = new URL(request.url).searchParams.get("u") || "";
if (!target.startsWith("https://arctic-shift.photon-reddit.com/")) {
return new Response("blocked", { status: 403 });
}
const upstream = await fetch(target);
return new Response(upstream.body, {
status: upstream.status,
headers: {
"content-type": "application/json",
"access-control-allow-origin": "*"
}
});
}
}
The relay did not answer
Check that the address is the full https address Cloudflare gave the Worker, with nothing after it, and that the Worker shows as deployed.
| Decision | Year | Search term | Threads | Comments | Top score | Median score | Top thread |
|---|
The CSV maps to columns M1, M2 and M3 in the calibration workbook. Paste it into the Decisions tab and the Online Reaction Index calculates itself.
Thread counts come from a count query with no ceiling. Comments, top score and median score are drawn from the hundred highest-scoring threads for each term, so for a decision above that many threads those three read as the busiest hundred rather than the whole set.
Comment valence (M4) still needs judgment, so the CSV carries the link to each decision's top thread for hand coding. Survey support and opposition (M11 and M12) come from the City Pulse and Budget Survey reports. Facebook figures come from the Business Suite export.