For anyone interested in exploring the data yourself, here are a few tools https://dadroit.com/: desktop tool for processing large JSON files.There’s a free version so you can get pretty far with it if you’re patient https://www.dolthub.com/repositories/dolthub/quest: they’re running a bounty program for some healthcare providers to process the machine readable files, and have some useful code snippets in case... - Source: Hacker News / over 1 year ago

Note for people who don't know much about FreePascal. It is a full-featured and very fast compiler. The resulting program is a rival for the best output of C/CPP compilers. It can be used in the style of simpler languages like Go and is almost as safe as Rust in a much faster manner. It has a great but old-looking IDE, Lazarus. It has been under active development for decades and is used for proper projects like:... - Source: Hacker News / over 1 year ago

The files are insanely large. Eventually the only way I've been able to open them is using the DADROIT large JSON viewer: http://dadroit.com (but even this only worked when I got an M1 Mac). Source: over 1 year ago

For those looking for the ability to (locally) open and query very large JSON files, Dadroit is great: https://dadroit.com. It's been a while since I used it last, but it was a life saver for me when working with JSON lines files in S3 and Kafka log dumps. A side tidbit, IIRC, it was written in Pascal. - Source: Hacker News / over 1 year ago

You can review all the contents of it, but generally, there is one big 5GB JSON file — yelp_academic_dataset_review.json it contains 6,9 🍋 JSON records. Use Dadroid to review massive JSON files. - Source: dev.to / over 1 year ago

Hi all, I'm excited to share the new project I've been working on called AI2sql. Check it out here: http://ai2sql.softr.app If you're writing SQL queries, you should try AI2sql. Let's you ask questions in plain English and then AI2sql translates it into SQL, so you can focus on the data and not the syntax. Thanks for taking the time to have a look at this project, I'd appreciate any feedback you might have on... Source: over 2 years ago

I’ve upgraded AI2sql (generate SQL in seconds) ai2sql.softr.app to use the InstructGPT and its results are better than ever. Source: over 2 years ago

Offering a simple interface, the tool aims to create SQL queries for non-engineering users. You can try it here: http://ai2sql.softr.app. Source: over 2 years ago

Thought you might be interested in the AI2sql tool. It allows you to simply and easily build SQL queries, so you don’t have to learn any coding. It’s great for beginners or advanced users who find coding a hassle. Source: over 2 years ago

AI2sql is an easy-to find tool which will take your SQL coding to the next level. It will help you easily write highly complex and powerful queries within seconds powered by AI. http://ai2sql.softr.app. Source: over 2 years ago