News for hackers. Stuff that matters.
Re:Show HN: CIA World Factbook Archive (1990–2025), searchab... by roysting on Sunday February 22, 2026 @10:28PM (#47117745)
Hi. Nice project. One issue though; if you go to the Factbook for any year[1], the link to the entry for “Germany”[2] will take you to the entry for the Gambia for every year I have checked. I have not noticed any other countries where that happens.

[1] https://cia-factbook-archive.fly.dev/archive/2002

[2] https://cia-factbook-archive.fly.dev/archive/2002/GM

Re:Show HN: CIA World Factbook Archive (1990–2025), searchab... by tjsch on Sunday February 22, 2026 @10:51PM (#47117868)
I found another example: searching for "Nicaragua" takes you to the page for "Niger".
Re:Show HN: CIA World Factbook Archive (1990–2025), searchab... by MilkMp on Sunday February 22, 2026 @11:00PM (#47117932)
Hi there, I have located the root cause and will be fixing the issue:

Root cause: CIA uses FIPS codes (CanonicalCode), which differ from ISO Alpha-2 for many countries. Templates and SQL queries prioritized CanonicalCode over ISOAlpha2, so URL codes like /archive/2025/AU matched the wrong country.

Australia (AU) -> American Samoa (AS = CIA FIPS for Australia) Singapore (SG) -> Senegal (SG = CIA FIPS for Senegal) Germany (DE) -> Gambia (GM = CIA FIPS for Germany)

Re:Show HN: CIA World Factbook Archive (1990–2025), searchab... by roysting on Monday February 23, 2026 @09:08AM (#47122540)
Thanks for the follow up, I figured it was semantic collision. I noticed the “GM”.

This is a good example of the importance of strong toping patterns. The GDP of Germany just tanked, we didn’t lose a mars climate orbiter this time. :)

Re:Show HN: CIA World Factbook Archive (1990–2025), searchab... by whycome on Monday February 23, 2026 @01:58PM (#47126988)
What do you mean by 'toping patterns'?