{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":694340241,"defaultBranch":"main","name":"FlightTragedyAnalysis","ownerLogin":"Hanan-Nawaz","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-09-20T19:57:11.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/93150331?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1695493243.0","currentOid":""},"activityList":{"items":[{"before":"afd663211165ca33c32fc99924581e787ee5b2fd","after":"ac3d2ef89ac757e7a9584c97642d5586344f646b","ref":"refs/heads/main","pushedAt":"2023-09-25T10:15:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"Script developed. csv files moved to S3.","shortMessageHtmlLink":"Script developed. csv files moved to S3."}},{"before":"190f3517d4421ae37215788b9284e08bbe0a5e82","after":"afd663211165ca33c32fc99924581e787ee5b2fd","ref":"refs/heads/main","pushedAt":"2023-09-25T08:38:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"csv files created from tables.","shortMessageHtmlLink":"csv files created from tables."}},{"before":"08d3819fd654872714a6ce12122ac3f226307148","after":"190f3517d4421ae37215788b9284e08bbe0a5e82","ref":"refs/heads/main","pushedAt":"2023-09-25T07:30:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"Developing python script for storing CSV.\n\nScript for moving data from db to S3.","shortMessageHtmlLink":"Developing python script for storing CSV."}},{"before":"9aeb2075b299b484d9737b255fc37132cb0db58a","after":"08d3819fd654872714a6ce12122ac3f226307148","ref":"refs/heads/main","pushedAt":"2023-09-23T20:17:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"Data Loaded into Db. Script Completed.\n\nData from CSV is Loaded to Postgresql database.","shortMessageHtmlLink":"Data Loaded into Db. Script Completed."}},{"before":"9b16e05fd643c28ee412a9aae641402e6d79a4d7","after":"9aeb2075b299b484d9737b255fc37132cb0db58a","ref":"refs/heads/main","pushedAt":"2023-09-23T20:16:34.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"guide.txt of Scripts directory Updated.\n\nName of file is updated.","shortMessageHtmlLink":"guide.txt of Scripts directory Updated."}},{"before":"405c8a7aae7dc74c7085c0f17d11af3444b1106a","after":"9b16e05fd643c28ee412a9aae641402e6d79a4d7","ref":"refs/heads/main","pushedAt":"2023-09-23T20:15:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"DataBase Script Updated.\n\nRange Error on Some Table Resolved.","shortMessageHtmlLink":"DataBase Script Updated."}},{"before":"806ef91142403c134ec97641e5ad6546816f9b02","after":"405c8a7aae7dc74c7085c0f17d11af3444b1106a","ref":"refs/heads/main","pushedAt":"2023-09-23T18:20:43.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"working on Loading data from CSV to DB.\n\nSo far used 'Pandas' and 'Psycopg2'. write a function to Connect to db and read all data from CSV and store in a Variable. Working on add_data() function to add data to db.","shortMessageHtmlLink":"working on Loading data from CSV to DB."}},{"before":"72d7baca1e46d383bd7c64ad8aa8cc82bde9cb65","after":"806ef91142403c134ec97641e5ad6546816f9b02","ref":"refs/heads/main","pushedAt":"2023-09-23T18:17:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"added guide.txt in Scripts directory.","shortMessageHtmlLink":"added guide.txt in Scripts directory."}},{"before":"de01c4d32b406a638b338912f49351d9813fc82a","after":"72d7baca1e46d383bd7c64ad8aa8cc82bde9cb65","ref":"refs/heads/main","pushedAt":"2023-09-22T19:06:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"update height of ERD.","shortMessageHtmlLink":"update height of ERD."}},{"before":"994b9c374baaae121be3fc491114c224ebefef97","after":"de01c4d32b406a638b338912f49351d9813fc82a","ref":"refs/heads/main","pushedAt":"2023-09-22T19:04:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"added ERD for Flight Tragedy Analysis.","shortMessageHtmlLink":"added ERD for Flight Tragedy Analysis."}},{"before":"720f6f6ba242afd7d6948e2f1e18badc4d69b005","after":"994b9c374baaae121be3fc491114c224ebefef97","ref":"refs/heads/main","pushedAt":"2023-09-22T19:03:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"Delete data_model/Plane-Crash-Data-ERD.png","shortMessageHtmlLink":"Delete data_model/Plane-Crash-Data-ERD.png"}},{"before":"45aeb3f9122728140eaef064edafe6966c462a7a","after":"720f6f6ba242afd7d6948e2f1e18badc4d69b005","ref":"refs/heads/main","pushedAt":"2023-09-22T19:02:43.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"added ERD for Flight Trag","shortMessageHtmlLink":"added ERD for Flight Trag"}},{"before":"d8b98a3112f7c0aa9d1ba8da4c5a6849de4907b8","after":"45aeb3f9122728140eaef064edafe6966c462a7a","ref":"refs/heads/main","pushedAt":"2023-09-22T19:02:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"Delete data_model/Plane-Crash-Data-ERD.png","shortMessageHtmlLink":"Delete data_model/Plane-Crash-Data-ERD.png"}},{"before":"3696344c8f504cdbf3405b6a43b43fb3900150cd","after":"d8b98a3112f7c0aa9d1ba8da4c5a6849de4907b8","ref":"refs/heads/main","pushedAt":"2023-09-22T18:34:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"added roadmap in the readme file","shortMessageHtmlLink":"added roadmap in the readme file"}},{"before":"35b1caadf7cdc4a0e22e3dcdec0ccbfd292de4d7","after":"3696344c8f504cdbf3405b6a43b43fb3900150cd","ref":"refs/heads/main","pushedAt":"2023-09-22T18:33:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"updated & new roadmap for the project.","shortMessageHtmlLink":"updated & new roadmap for the project."}},{"before":"65c10d3b69b59d189d1adee4bfdc0bf53bcdae65","after":"35b1caadf7cdc4a0e22e3dcdec0ccbfd292de4d7","ref":"refs/heads/main","pushedAt":"2023-09-22T18:32:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"Delete FlightTragedyAnalysis-roadmap.png","shortMessageHtmlLink":"Delete FlightTragedyAnalysis-roadmap.png"}},{"before":"6a130194f68beccb0ef120f6d7fba7046d1e6df2","after":"65c10d3b69b59d189d1adee4bfdc0bf53bcdae65","ref":"refs/heads/main","pushedAt":"2023-09-22T18:25:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"designed full roadmap for the project.","shortMessageHtmlLink":"designed full roadmap for the project."}},{"before":"3c30951c25ebdf92909427a9f17061b5cc5006f1","after":"6a130194f68beccb0ef120f6d7fba7046d1e6df2","ref":"refs/heads/main","pushedAt":"2023-09-22T17:43:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"script for database creation created.","shortMessageHtmlLink":"script for database creation created."}},{"before":"41daf51feb9e4727e444e638862160ed43d269c4","after":"3c30951c25ebdf92909427a9f17061b5cc5006f1","ref":"refs/heads/main","pushedAt":"2023-09-22T17:42:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"Created guide.txt for database folder.","shortMessageHtmlLink":"Created guide.txt for database folder."}},{"before":"5c4ca42fd42a4732f2d69c9faff676cadee7740b","after":"41daf51feb9e4727e444e638862160ed43d269c4","ref":"refs/heads/main","pushedAt":"2023-09-21T17:00:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"LICENSE added","shortMessageHtmlLink":"LICENSE added"}},{"before":"b670449c4b6c3f71059d6540ac99e9b20af42c43","after":"5c4ca42fd42a4732f2d69c9faff676cadee7740b","ref":"refs/heads/main","pushedAt":"2023-09-21T16:53:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"added ERD and Logo.","shortMessageHtmlLink":"added ERD and Logo."}},{"before":"ef2b2fa83f361e42b0e25dfa27f8c86de8a80d79","after":"b670449c4b6c3f71059d6540ac99e9b20af42c43","ref":"refs/heads/main","pushedAt":"2023-09-21T16:48:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"logo for FlightTragedyAnalysis added","shortMessageHtmlLink":"logo for FlightTragedyAnalysis added"}},{"before":"eefd5acf84476e2af0f9ef4cceb00299ccf6d5e3","after":"ef2b2fa83f361e42b0e25dfa27f8c86de8a80d79","ref":"refs/heads/main","pushedAt":"2023-09-21T16:45:37.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"Update README.md, ERD added","shortMessageHtmlLink":"Update README.md, ERD added"}},{"before":"27fe2ce30287a35b5787707e2b135c4a92f61b08","after":"eefd5acf84476e2af0f9ef4cceb00299ccf6d5e3","ref":"refs/heads/main","pushedAt":"2023-09-21T16:43:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"added red","shortMessageHtmlLink":"added red"}},{"before":"63e623827ad7cebe1958015ca79f9527d4dcafff","after":"27fe2ce30287a35b5787707e2b135c4a92f61b08","ref":"refs/heads/main","pushedAt":"2023-09-21T16:43:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"Created guide.txt for data_model","shortMessageHtmlLink":"Created guide.txt for data_model"}},{"before":"df85cb4c6d79796ef1cdbda451657eda0011ef2d","after":"63e623827ad7cebe1958015ca79f9527d4dcafff","ref":"refs/heads/main","pushedAt":"2023-09-21T16:39:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"dataset downloaded","shortMessageHtmlLink":"dataset downloaded"}},{"before":"304f5562598726aaf65f06fc5ccbd0f12435e956","after":"df85cb4c6d79796ef1cdbda451657eda0011ef2d","ref":"refs/heads/main","pushedAt":"2023-09-21T16:36:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"Rename Airplane_Crashes_and_Fatalities_Since_1908.csv to fbd.csv","shortMessageHtmlLink":"Rename Airplane_Crashes_and_Fatalities_Since_1908.csv to fbd.csv"}},{"before":"5554998d9171a871015216e9834e28a1b78911a2","after":"304f5562598726aaf65f06fc5ccbd0f12435e956","ref":"refs/heads/main","pushedAt":"2023-09-21T16:34:48.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"Create Airplane_Crashes_and_Fatalities_Since_1908.csv","shortMessageHtmlLink":"Create Airplane_Crashes_and_Fatalities_Since_1908.csv"}},{"before":"0265c3348d7da4d8546d06d744bcd6fd8ffc797c","after":"5554998d9171a871015216e9834e28a1b78911a2","ref":"refs/heads/main","pushedAt":"2023-09-21T16:27:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"Added Readme","shortMessageHtmlLink":"Added Readme"}},{"before":null,"after":"0265c3348d7da4d8546d06d744bcd6fd8ffc797c","ref":"refs/heads/main","pushedAt":"2023-09-20T19:57:12.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Hanan-Nawaz","name":"Abdul Hanan Nawaz","path":"/Hanan-Nawaz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/93150331?s=80&v=4"},"commit":{"message":"Initial commit","shortMessageHtmlLink":"Initial commit"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"Y3Vyc29yOnYyOpK7MjAyMy0wOS0yNVQxMDoxNTo1Ni4wMDAwMDBazwAAAAOIFyBe","startCursor":"Y3Vyc29yOnYyOpK7MjAyMy0wOS0yNVQxMDoxNTo1Ni4wMDAwMDBazwAAAAOIFyBe","endCursor":"Y3Vyc29yOnYyOpK7MjAyMy0wOS0yMFQxOTo1NzoxMi4wMDAwMDBazwAAAAOFJe2s"}},"title":"Activity · Hanan-Nawaz/FlightTragedyAnalysis"}