{"gallery_project_data":{"gallery_project":{"featured":false,"gallery_project_category":{"id":1,"name":"General","slug":"general","created_at":"2017-03-14T16:56:43.926-04:00","updated_at":"2017-03-24T11:30:10.745-04:00","description":"There are no limits to the type of content generated with Wordsmith. See examples from many verticals, and find one that fits your content needs. Don't see a project that matches your needs? Contact us and we'll help get you started. "},"id":62,"image_url":"https://dj65vgnq591pm.cloudfront.net/projects/home-sales/images/image.png?1749744962","project_name":"Home Sales","project_id":25002,"project_slug":"home-sales","project_description":"Gain insight on real estate market trends with summaries of home sales for each city.","template_image_url":"https://dj65vgnq591pm.cloudfront.net/projects/home-sales/images/template_image.png?1749744962","metadata":{"featuredColumns":[1,2,3,4],"scenarios":[{"name":"Raleigh","row":6},{"name":"Chicago","row":4},{"name":"San Diego","row":1}],"segmentTotals":{"synonym":920,"branch":598,"datavar":336}}},"project":{"id":25002,"name":"Home Sales","organization_id":4439,"created_at":"2017-10-31T09:00:45.444-04:00","updated_at":"2019-03-04T08:19:40.993-05:00","deleted_at":null,"slug":"home-sales","archived":false,"raw_csv_filename":"home-sales.csv","description":"Gain insight on real estate market trends with summaries of home sales for each city.","creator_id":1565,"editor_id":6456,"project_type":"gallery","source_id":null,"encrypted_csv_id":"11437a880bda43102ac209a2c4ab0eb87445e4f298894adaa21504ea1612","api_project_id":null,"encrypted_data_id":"2c2e8c02dfa8d21b8fe44d65cb053b861743480d4240f5e3b4ee5c7ad356","integration_type":null,"reference_id":"f0abb032e8392821a2e71a87a15eafae","external_tool":null,"visualization_url":null,"wordsmith_integration":false,"ds_integration_id":null},"dataset":{"columns":[{"name":"city","type":"String","example":["San Diego","Atlanta","Boston"],"index":0,"value":"city"},{"max":3845.0,"min":96.0,"sum":16360.0,"name":"home_sales_current","type":"Number","average":1636.0,"example":["3845","2345","1877"],"index":1,"value":"home_sales_current"},{"max":3553.0,"min":32.0,"sum":16126.0,"name":"home_sales_previous","type":"Number","average":1612.6,"example":["2123","2345","1890"],"index":2,"value":"home_sales_previous"},{"max":896000.0,"min":204000.0,"sum":3772000.0,"name":"median_price_current","type":"Number","average":377200.0,"example":["450000","275000","336000"],"index":3,"value":"median_price_current"},{"max":3570000.0,"min":193000.0,"sum":6320000.0,"name":"median_price_previous","type":"Number","average":632000.0,"example":["439000","260000","336000"],"index":4,"value":"median_price_previous"},{"name":"top_subregion","type":"String","example":["San Diego County","Gwinnett County","Cambridge"],"index":5,"value":"top_subregion"},{"max":2836.0,"min":21.0,"sum":9259.0,"name":"subregion_sales_current","type":"Number","average":925.9,"example":["1865","1700","976"],"index":6,"value":"subregion_sales_current"},{"max":3489.0,"min":31.0,"sum":9839.0,"name":"subregion_sales_previous","type":"Number","average":983.9,"example":["1678","1789","850"],"index":7,"value":"subregion_sales_previous"},{"max":6.0,"min":3.0,"sum":38.0,"name":"inventory_current","type":"Number","average":3.8,"example":["4","4","4"],"index":8,"value":"inventory_current"},{"max":5.0,"min":2.0,"sum":37.0,"name":"inventory_previous","type":"Number","average":3.7,"example":["3","5","4"],"index":9,"value":"inventory_previous"}],"data":[{"city":"San Diego","home_sales_current":"3845","home_sales_previous":"2123","median_price_current":"450000","median_price_previous":"439000","top_subregion":"San Diego County","subregion_sales_current":"1865","subregion_sales_previous":"1678","inventory_current":"4","inventory_previous":"3"},{"city":"Atlanta","home_sales_current":"2345","home_sales_previous":"2345","median_price_current":"275000","median_price_previous":"260000","top_subregion":"Gwinnett County","subregion_sales_current":"1700","subregion_sales_previous":"1789","inventory_current":"4","inventory_previous":"5"},{"city":"Boston","home_sales_current":"1877","home_sales_previous":"1890","median_price_current":"336000","median_price_previous":"336000","top_subregion":"Cambridge","subregion_sales_current":"976","subregion_sales_previous":"850","inventory_current":"4","inventory_previous":"4"},{"city":"Chicago","home_sales_current":"2010","home_sales_previous":"2020","median_price_current":"392000","median_price_previous":"340000","top_subregion":"Lincoln Park","subregion_sales_current":"654","subregion_sales_previous":"756","inventory_current":"3","inventory_previous":"4"},{"city":"Phoenix","home_sales_current":"3214","home_sales_previous":"3553","median_price_current":"424000","median_price_previous":"430000","top_subregion":"Phoenix County","subregion_sales_current":"2836","subregion_sales_previous":"3489","inventory_current":"3","inventory_previous":"2"},{"city":"Raleigh","home_sales_current":"1150","home_sales_previous":"998","median_price_current":"283000","median_price_previous":"254000","top_subregion":"Wake County","subregion_sales_current":"887","subregion_sales_previous":"398","inventory_current":"6","inventory_previous":"5"},{"city":"Philadelphia","home_sales_current":"1011","home_sales_previous":"1056","median_price_current":"265000","median_price_previous":"266000","top_subregion":"Kensington","subregion_sales_current":"233","subregion_sales_previous":"250","inventory_current":"4","inventory_previous":"4"},{"city":"New York City","home_sales_current":"710","home_sales_previous":"2050","median_price_current":"896000","median_price_previous":"3570000","top_subregion":"Upper West Side","subregion_sales_current":"64","subregion_sales_previous":"547","inventory_current":"3","inventory_previous":"5"},{"city":"Durham","home_sales_current":"102","home_sales_previous":"59","median_price_current":"204000","median_price_previous":"193000","top_subregion":"Trinity Park","subregion_sales_current":"23","subregion_sales_previous":"51","inventory_current":"4","inventory_previous":"2"},{"city":"Eugene","home_sales_current":"96","home_sales_previous":"32","median_price_current":"247000","median_price_previous":"232000","top_subregion":"South Hills","subregion_sales_current":"21","subregion_sales_previous":"31","inventory_current":"3","inventory_previous":"3"}],"total":10,"formulas":[{"name":"sales_percentage_change","type":"Number","example":[0.8111163447951013,0,-0.006878306878306878],"formula_id":101813,"ancestor_ids":[101813],"has_error":false},{"name":"price_change","type":"Number","example":[0.02505694760820045,0.0576923076923077,0],"formula_id":101814,"ancestor_ids":[101814],"has_error":false},{"name":"subregion_change","type":"Number","example":[0.1114421930870083,-0.04974846282839576,0.148235294117647],"formula_id":101815,"ancestor_ids":[101815],"has_error":false},{"name":"inventory_change","type":"Number","example":[0.3333333333333333,-0.2,0],"formula_id":101816,"ancestor_ids":[101816],"has_error":false}]},"row_count":10,"col_count":10}}