This is no different from using a big spreadsheet or CSV to get those types of very specific answers. Currently, none of the models is good at doing what would be a standard query on a ‘big’ document. Anything over 30k characters or so (in my experience) and you’re out of luck.
So consider different strategies - like using a function call to get a specific record from the that JSON instead of one big json with thousands of records.
See this discussion for a few other strategies that could including using code completion (again, IMO better to use a function call ) The Fortune 500 list challenge!
The Forture 500 list is on 500 rows and 10 or so columns.