I mostly agree with what you say, but I think this discussion is a bit overly-technical. For most fields ("columns", yes). I just used varchar for most of them and might amend them later or add more columns. For now, it's just a test/sandbox data set. The immediate goal is just to get a starting data set for these three dimensions (person/institution/list) and then flesh out what we really need from there. Things like birth or death date don't practically matter for how we want to use the data.

The starting data set is basically done, which I'm relieved to say, since it took me a lot longer than expected. Fun facts: There are no more than 7,376 individuals in VDR's list (some of which are duplicates or nicknames and need to be reviewed) and there are 23,258 discrete individual-institution relationships. The average person appears three times, and the person with the most appearances is Henry Kissinger, at 112 (plus more, once we count the "Henry K." s discretely, as these could also refer to Henry Kravis or Henry Kaufman, who appear 20 and 2 times, respectfully) I already counted all Jews with an appearance over 2 times, imperfectly, but I estimate that Jews account for about 22% of the overall representation of the 23,258. Researching some of these individuals has led to some interesting discoveries - for instance, did you know that Sumner Shapiro, Rear Admiral in the US Navy (a rare case, Jews almost never appear in US military positions), was instrumental in getting Israeli spy Jonathan Pollard's security clearance? Although he later stated

"We work so hard to establish ourselves and to get where we are, and to have somebody screw it up... and then to have Jewish organizations line up behind this guy and try to make him out a hero of the Jewish people, it bothers the hell out of me".

Really interesting stuff. Wish I could catalog everything at once

There are a few glaring shortcomings of VDR's list. The first is that there is an almost complete lack of interest in the media industry, which you think would be of paramount importance in assessing who is behind manufacturing the false and obviously biased narratives we see every day, and consequently why the population behaves like it does. Especially if your focus is on "conspiracy research" and bias against things about elites getting exposed, journalists assassinated, etc. Ofc, the basic answer to "who owns the media" is "Jews" (60-80%), and VDR has a very ant-anti-semitic slant so this aligns to his complete disavowal of "holocaust denial" and his very bad justifications (practically dogwhistling) for not investigating it:

Ever met a Nazi or Holocaust denier in real life? Most haven't, but online, they're everywhere. Ignore the many discussions about concentration camp Auschwitz. Instead, read about Babi Yar and the eastern European extermination camps of the Nazis and the Ustasa, or look up the visual evidence. You'll get the point.

Jew-hating - in its "deniable" form or not - is super-effective at pushing ordinary people out of any conspiracy discussions and at forcing censorship measures. Thus, like an ever-spreading virus, it remains

I half-ways agree with the sentiment, but ultimately the truth just is what it is. I think VDR is on-the-level and not a Jewish shill, but sometimes he begs the question.

As of now, most all of the data is in the database and I'm trying to figure out how to present and expose it. I'm going to add more people that aren't just in VDR's list, notably from CoC, Dissident-Right circles, and the media. To start, I'll probably create new pages that have no links to them in the existing UI, but expose them here. This way, interested people who come here will have the link can check them out and give feedback, but they wouldn't otherwise be accessible to casual lurkers.

Much more I could write about a lot of stuff, but I wanted to give a general update. Very much appreciate your interest.