{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":640265221,"defaultBranch":"main","name":"data_build_tool_for_datathinking.org","ownerLogin":"onefact","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-05-13T14:17:41.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/89560450?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1693365008.0","currentOid":""},"activityList":{"items":[{"before":"9c659c2def930f9d98ecc2bb9b7b7736d1a5811b","after":"00d4d7d9ab373239937cb9c185acf16c5b43d864","ref":"refs/heads/main","pushedAt":"2023-08-30T03:10:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"stockdaleb108","name":null,"path":"/stockdaleb108","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/135244878?s=80&v=4"},"commit":{"message":"Add files via upload","shortMessageHtmlLink":"Add files via upload"}},{"before":"3e0bb5d2d020b81e25d846a831d6ef6bdb92f988","after":"9c659c2def930f9d98ecc2bb9b7b7736d1a5811b","ref":"refs/heads/main","pushedAt":"2023-08-22T15:36:13.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"stockdaleb108","name":null,"path":"/stockdaleb108","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/135244878?s=80&v=4"},"commit":{"message":"Add files via upload","shortMessageHtmlLink":"Add files via upload"}},{"before":"8598c2ec00cae3261db0b131374e1d2afeb8d6df","after":"3e0bb5d2d020b81e25d846a831d6ef6bdb92f988","ref":"refs/heads/main","pushedAt":"2023-08-01T16:16:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"stockdaleb108","name":null,"path":"/stockdaleb108","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/135244878?s=80&v=4"},"commit":{"message":"Add files via upload\n\nVisualization using the ACS dataset on poverty rate by geo ID: https://www2.census.gov/programs-surveys/acs/data/2021/1_year_geographic_comparison_tables/GCT1701.csv","shortMessageHtmlLink":"Add files via upload"}},{"before":"84bb428dbe0ee41a97ed4fead07c3cc2124a6fcf","after":"8598c2ec00cae3261db0b131374e1d2afeb8d6df","ref":"refs/heads/main","pushedAt":"2023-07-25T16:38:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update readme","shortMessageHtmlLink":"update readme"}},{"before":"2e28f79bb90b6e8030b1cc1dd16e8bf04aeaa150","after":"84bb428dbe0ee41a97ed4fead07c3cc2124a6fcf","ref":"refs/heads/main","pushedAt":"2023-07-24T23:26:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update with 2021 data","shortMessageHtmlLink":"update with 2021 data"}},{"before":"4ec7044ca42cd02ce6fd3e840bc7441e91c3c946","after":"2e28f79bb90b6e8030b1cc1dd16e8bf04aeaa150","ref":"refs/heads/main","pushedAt":"2023-07-24T23:19:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update","shortMessageHtmlLink":"update"}},{"before":"b9ed376ca171fbaa2c8ab3970bb91a7f7e9d3325","after":"4ec7044ca42cd02ce6fd3e840bc7441e91c3c946","ref":"refs/heads/main","pushedAt":"2023-07-24T23:04:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update area deprivation index","shortMessageHtmlLink":"update area deprivation index"}},{"before":"70b57ac986fc532ac789de4b103a55b7cfcc23ec","after":"b9ed376ca171fbaa2c8ab3970bb91a7f7e9d3325","ref":"refs/heads/main","pushedAt":"2023-07-24T23:02:48.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update area deprivation index","shortMessageHtmlLink":"update area deprivation index"}},{"before":"4a03f0e1540b7bf48475beeccf6fcbf3a44bdb8c","after":"70b57ac986fc532ac789de4b103a55b7cfcc23ec","ref":"refs/heads/main","pushedAt":"2023-07-24T22:44:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update notebook","shortMessageHtmlLink":"update notebook"}},{"before":"9626e5acb4c21a1c50596896abd2020c69d39df1","after":"4a03f0e1540b7bf48475beeccf6fcbf3a44bdb8c","ref":"refs/heads/main","pushedAt":"2023-07-24T22:15:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"add example with census block group file centroid computation yielding same latitude and longitude with duckdb spatial","shortMessageHtmlLink":"add example with census block group file centroid computation yieldin…"}},{"before":"3b33b816b9638fd6a59b6ad5477a8c0d66510e20","after":"9626e5acb4c21a1c50596896abd2020c69d39df1","ref":"refs/heads/main","pushedAt":"2023-07-24T22:12:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"add example with census block group file centroid computation yielding same latitude and longitude with duckdb spatial","shortMessageHtmlLink":"add example with census block group file centroid computation yieldin…"}},{"before":"71987fd40d5402682ba53c1c734f63813dc67a12","after":"3b33b816b9638fd6a59b6ad5477a8c0d66510e20","ref":"refs/heads/main","pushedAt":"2023-07-24T17:58:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update with casting of nulls","shortMessageHtmlLink":"update with casting of nulls"}},{"before":"d79c7f548cd65e5b2c1a06b84b94d52f570abb37","after":"71987fd40d5402682ba53c1c734f63813dc67a12","ref":"refs/heads/main","pushedAt":"2023-07-24T15:59:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update","shortMessageHtmlLink":"update"}},{"before":"91c2bb63649c4124024451e0e92df13443c98bde","after":"d79c7f548cd65e5b2c1a06b84b94d52f570abb37","ref":"refs/heads/main","pushedAt":"2023-07-24T15:58:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update with example of replacing nullstr values with null string","shortMessageHtmlLink":"update with example of replacing nullstr values with null string"}},{"before":"2e6a7fd1e0efacc8b0778f70f7434181c5a04c9b","after":"91c2bb63649c4124024451e0e92df13443c98bde","ref":"refs/heads/main","pushedAt":"2023-07-24T15:31:41.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"Merge branch 'main' of https://github.com/onefact/data_build_tool_for_datathinking.org","shortMessageHtmlLink":"Merge branch 'main' of <a href=\"https://github.com/onefact/data_build_tool_for_datathinking.org\">https://github.com/onefact/data_build_tool_for…</a>"}},{"before":"389c8dae662efd3046bbb4b7383b572b564d702f","after":"2e6a7fd1e0efacc8b0778f70f7434181c5a04c9b","ref":"refs/heads/main","pushedAt":"2023-07-24T15:17:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"stockdaleb108","name":null,"path":"/stockdaleb108","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/135244878?s=80&v=4"},"commit":{"message":"Notebook converts datasets to parquet files\n\nUsing pandas library you do not need to type in the column names and variable types. It should work with any type of file that pandas is capable of reading (excel, csv, etc...)","shortMessageHtmlLink":"Notebook converts datasets to parquet files"}},{"before":"bdfff1ba42466156461dcea88d0da4652ded6504","after":"389c8dae662efd3046bbb4b7383b572b564d702f","ref":"refs/heads/main","pushedAt":"2023-07-20T16:53:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"stockdaleb108","name":null,"path":"/stockdaleb108","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/135244878?s=80&v=4"},"commit":{"message":"PA area deprivation index, not the whole country\n\nSome changes still need to be made in the 'Visualizing the Data' Section. It is currently set up to look at phone call records","shortMessageHtmlLink":"PA area deprivation index, not the whole country"}},{"before":"97b63fe7e33475e4ce7970cbf9b7cd3e0e77baee","after":"bdfff1ba42466156461dcea88d0da4652ded6504","ref":"refs/heads/main","pushedAt":"2023-07-19T15:03:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"add SQL query we are blocked on with @stockdaleb108 - need to understand\nhow to add a column name that is currently missing in the area\ndeprivation index csv and debug duckdb before creating parquet file","shortMessageHtmlLink":"add SQL query we are blocked on with <a class=\"user-mention notranslate\" data-hovercard-type=\"user\" data-hovercard-url=\"/users/stockdaleb108/hovercard\" data-octo-click=\"hovercard-link-click\" data-octo-dimensions=\"link_type:self\" href=\"https://github.com/stockdaleb108\">@stockdaleb108</a> - need to understand"}},{"before":"2dab1d09b29b53e2d3bff8b7769ece7c6a315e49","after":"97b63fe7e33475e4ce7970cbf9b7cd3e0e77baee","ref":"refs/heads/main","pushedAt":"2023-07-11T23:05:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update with checkbooknyc.com example","shortMessageHtmlLink":"update with checkbooknyc.com example"}},{"before":"5a77a4cc6341658a1546b202d1cc3a7fbb32a7d8","after":"2dab1d09b29b53e2d3bff8b7769ece7c6a315e49","ref":"refs/heads/main","pushedAt":"2023-07-07T23:13:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update with full test","shortMessageHtmlLink":"update with full test"}},{"before":"3f97a70e886f6652a8b5bf86616396bc497408c7","after":"5a77a4cc6341658a1546b202d1cc3a7fbb32a7d8","ref":"refs/heads/main","pushedAt":"2023-07-07T23:12:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update with full test","shortMessageHtmlLink":"update with full test"}},{"before":"84476d99608a677aa5ecf1abdd246ab049e5f94d","after":"3f97a70e886f6652a8b5bf86616396bc497408c7","ref":"refs/heads/main","pushedAt":"2023-07-07T23:11:48.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update with full test","shortMessageHtmlLink":"update with full test"}},{"before":"d078ba094733f7779cb332a917ebb2cbf889ce11","after":"84476d99608a677aa5ecf1abdd246ab049e5f94d","ref":"refs/heads/main","pushedAt":"2023-06-23T15:35:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update with output example","shortMessageHtmlLink":"update with output example"}},{"before":"3259a12d536966093d562b7a0ebe7912431b0f90","after":"d078ba094733f7779cb332a917ebb2cbf889ce11","ref":"refs/heads/main","pushedAt":"2023-05-13T21:24:40.859Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"update with details from https://github.com/onefact/datathinking.org-codespace/blob/main/notebooks/in-class-notebooks/230420-debugging-duckdb-altair-falcon-3-1-1-service-requests.ipynb","shortMessageHtmlLink":"update with details from <a href=\"https://github.com/onefact/datathinking.org-codespace/blob/main/notebooks/in-class-notebooks/230420-debugging-duckdb-altair-falcon-3-1-1-service-requests.ipynb\">https://github.com/onefact/datathinking.org-…</a>"}},{"before":"c43e3754333931f03cbe77e48a960fc247e3db1b","after":"3259a12d536966093d562b7a0ebe7912431b0f90","ref":"refs/heads/main","pushedAt":"2023-05-13T21:08:40.366Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"add update","shortMessageHtmlLink":"add update"}},{"before":"5f178f47d21845854eb6bda10dce106a1ed7b69f","after":"c43e3754333931f03cbe77e48a960fc247e3db1b","ref":"refs/heads/main","pushedAt":"2023-05-13T21:08:09.952Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"add example for new york city 311 data","shortMessageHtmlLink":"add example for new york city 311 data"}},{"before":"7cadf4eb53737c1db52a60724bae80891e9a3272","after":"5f178f47d21845854eb6bda10dce106a1ed7b69f","ref":"refs/heads/main","pushedAt":"2023-05-13T20:49:50.217Z","pushType":"push","commitsCount":1,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?s=80&v=4"},"commit":{"message":"initial commit","shortMessageHtmlLink":"initial commit"}},{"before":null,"after":"7cadf4eb53737c1db52a60724bae80891e9a3272","ref":"refs/heads/main","pushedAt":"2023-05-13T14:17:41.498Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"jaanli","name":"Jaan Lı 李 PhD","path":"/jaanli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5317244?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":"djE6ks8AAAADdWNFmwA","startCursor":null,"endCursor":null}},"title":"Activity · onefact/data_build_tool_for_datathinking.org"}