Yeh the objects are gonna be kinda like you described. Say "foo" is bank account number for example, then it has the value you listed. "bar" is fullname then it has the value you listed, "one" is balance you listed, and so on.

I'm looking at anywhere from 3-10 keys per object.

What I have in mind is webapp where you have different pages in the web app and depending on page the user is on they see different datasets. These datasets have anywhere from 1000 objects to a few million. Obviously as you ahve more pages and more datasets, the cumulative number of objects of all the datasets combined across an entire webapp could end up reaching 100m.

On top of that I'm also doing transformations on said datasets. What if I wanted to figure out the total average balance of people named x. Or total average salary of men from region y? So I'm creating sub datasets of objects of a dataset.

Say I'm loading all these jsons locally from my computer and say a user visit a page on the app. Then it's only that page that's being loaded, correct? So this won't really be too problematic probably? Or is the entire thing loaded?