Patch Notes
May 10 2026
- Graph time in one spot
- Modify calculation to find time spent camping, rather than occurences
- Start styling graphs
May 9 2026
- Modify players alive graphs so that line colours are consistent
- Update distance travelled query to account for time players are alive, therefore calculating movement speed
- Graph movement speed
May 8 2026
- Modify graphs to show correct legend order and clarify tournament names
May 7 2026
- Create graphs of game length and players alive
May 6 2026
- Continue writing up article
- Write up dataset details
- Create game length query
- Including both overall, and for Erangel and Mirimar specifically
May 5 2026
- Modify average time alive dataset to better account for phases with no players alive (as game finished)
May 4 2026
- Calculate info about dataset
- Start writing up article
May 3 2026
- Calculate average time per cell, occurences of staying in one spot
May 2 2026
- Extract player locations, find out the grid cell they're in
May 1 2026
- Calculate average time alive
April 31 2026
April 30 2026
- Start calculating distance moved
April 29 2026
- Add PGS 7 to the players alive analysis
April 28 2026
- Bar chart of average players alive in final pahses of game for TPP and FPP tournaments
- Start exploring player movement distance
April 27 2026
- Fixed bug in average players alive query
- Line graph of average players alive per phase for TPP and FPP tournaments
April 26 2026
- Refined materialised views
- Found average players alive per phase
April 25 2026
- Starting some analysis looking at potential impacts of the PUBG FPP to TPP switch
- Brainstormed potential metrics to measure
- Extracted recent tournament games games
- Created materialised views to facilitate analysis
April 24 2026
- Revise distance from circle query to increase speed
- Query now considers all PGC games
April 23 2026
- Fix bug in distance from circle query to make sure the correct cirlce is used
April 22 2026
- Remove old versions of player position and circle tables
April 21 2026
- Start revision player position and circle tables to include match ID
April 20 2026
- Created expanded player position and circle location tables (for PGC) to test analyse
- Started working on query to get average distance from circle for each player
April 19 2026
- Finished downloading latest PUBG telemetry data
- Working on a query to extract players who participated in games / tournaments
- Extract players from each game
- Filter to unique players
April 18 2026
- Time to focus more on this project again. I'll be tracking my progress on this patch notes page. Let's see how far I can get.
- Started downloading most recent PUBG telemtry data
- Continued work on a query to analyse player distance from the blue zone throughout a match
- Identify whether a player is inside or outside the circle
- Identify how far from the cirlce edge the player is (positive if inside, negative if outside)