Help regenerating lost summary_requests data

We had a data loss issue with the March desktop requests. The good news is that the HAR-based JSON data is all there, but our processed summary data didn’t make it. So I have a challenge for anyone looking to sharpen their SQL skills.

As part of our goal to deprecate the legacy PHP/mysql system, we need to come up with a way to summarize the HAR-based JSON data into a format identical (or similar) to the mysql-based CSV data, eg extracting high-level request and response headers, HTTP status, etc for the summary_requests tables. Most if not all of the fields in the summary CSV-based tables should be included in the HAR data.

So: given this sample data could you produce results that fit the schema of the summary_requests tables?

For more info see this issue.