I have written Huge JSON viewer based on JSON.NET, one of the fastest JSON frameworks. It matches the requirements as follows:
open decently large files: it can open the 1.44 GB example file without crashing in ~ 2:45 minutes on my machine (Intel Core i7, 16 GB RAM, SSD). To do that, the OS must be 64 bit. A progress bar is shown
has a decently responsive UI: I use a commercial tree view from DevExpress which I hope is optimized very well.
can collapse/expand a given level: it is a full tree view and can expand/collapse any nodes. It has a feature to expand to a given level
works off-line: it's a Windows desktop application. Needs .NET
provide some statistics on the JSON content: some. Can definitely be improved.
gratis: yes. MIT license, but closed source.
displays the filename somewhere: yes, in the tab
The only thing it can definitely not (but was optional):
"can edit JSON data"
performance warning when memory swapping to disk is expected
Windows 7 SP1 or higher, x64 bit recommended
Physical RAM roughly 7 times the file size to be opened
Watch out the list of known issues until it's out of beta phase.
I'm using JSONedit, typically with 1-2MB of text. Largest data sets I've tested were around 50MB and it's annoyingly slow with loading it and peak RAM usage reaches few hundreds MB - there is definitely room for improvement, but it's at least order of magnitude better than browser-based editors I've tested. It seems to meet most of your requirements except tabs and I don't know what you mean by statistics - JSONedit can count nodes by type or count total length of strings for memory usage estimation for DOM-style parsers, maybe this is sufficient).
In case I want to open truly very large files (logs from application for example), then my preferred solution is to load this file into the local mongo database (it is for free) and then use some Mongo GUI (3T Studio/Mongo DBCompass/… for free as well). The benefits against other solutions (like HugeJsonViewer) is that you are definitely not restricted by file size (just size of your disk) and you have also structured query language for to asking for data. Fact is that a large JSON query is a just a database file.
unlimited file size : just size of disk is limit
Excellent GUI : not just one 3T Studio/Mongo DBCompass/... Support for those who want to pay
structured query language : that's what I'm really appreciated
Licence possible : you can buy a licence in case you want more a more
"Dadroit is a brilliant tool that treats JSON as a data format, not a plain text. It provides you a quick outline view with the help of tree representation of JSON data from root to last nodes. So you can browse and query JSON like an enterprise DBMS."
MiTeC JSON Viewer is free JSON viewer software, which you can use to load, view and edits multiple JSON files at a time.
It has an attractive and well-organized interface that comes fully loaded with various options to view a file both in Tree and Text mode. You can switch between them with Tree and Source options at the bottom of the interface.
I've created a web app (Cluria) for viewing very large JSON files that loads very fast. To support this, it only renders a preview of the file, not the entire data. This is useful if you just want to view the file (e.g. to understand its general structure) and data types without necessarily seeing the full data.
If this is your use case, this can be very useful since it can preview giant JSON files in just a few seconds.