Hi,
I am using Stata 17 and would need some help in importing JSON into Stata. This is my first time doing it so I would need help in this area. Below is an example of my JSON file:
I did not see an option to import JSON file when I tried to import the file. Any help in this area would be appreciated.
Thanks!
I am using Stata 17 and would need some help in importing JSON into Stata. This is my first time doing it so I would need help in this area. Below is an example of my JSON file:
Code:
[{
"projects": [
{
"id": 1848663364,
"name": "Drawing a Drawing 365",
"blurb": "Portrait artist seeks funds to kickstart an exciting year-long project involving YOU and produce a drawing / painting tutorial video",
"goal": 10000,
"pledged": 62736.01,
"state": "successful",
"slug": "drawing-a-drawing-365",
"disable_communication": false,
"country": "US",
"currency": "USD",
"currency_symbol": "$",
"currency_trailing_code": true,
"deadline": 1335671940,
"state_changed_at": 1335671940,
"created_at": 1331325438,
"launched_at": 1332822807,
"backers_count": 479,
"static_usd_rate": "1.0",
"usd_pledged": "62736.01",
"photo": {
"full": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=560&h=420&fit=crop&auto=format&q=92&s=6cbd36c602d0124f63fb79f632ef1e8e",
"ed": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=338&h=250&fit=crop&auto=format&q=92&s=b32c42f4943722127d9889471d3c918c",
"med": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=266&h=200&fit=crop&auto=format&q=92&s=2483c039a636bfc6538d9573d71d8b47",
"little": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=200&h=150&fit=crop&auto=format&q=92&s=3ca2b75a4f2654aa270432d2ee35a094",
"small": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=160&h=120&fit=crop&auto=format&q=92&s=39fee61fe56c366f9c1f217fa341cdeb",
"thumb": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=40&h=30&fit=crop&auto=format&q=92&s=f2599f323e7c8e46d8d58bb88cccaba8",
"1024x768": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=1024&h=768&fit=crop&auto=format&q=92&s=56202045b5f599793245ac8660529b24",
"1536x1152": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=1536&h=1152&fit=crop&auto=format&q=92&s=7b4aad024a0685165f295c10c3894175"
},
"creator": {
"id": 1537276594,
"name": "Michael Shapcott",
"slug": "michaelshapcott",
"avatar": {
"thumb": "https://ksr-ugc.imgix.net/avatars/1539487/MichaelShapcott_thumb.original.jpg?v=1331450574&w=40&h=40&fit=crop&auto=format&q=92&s=d26aed7e3dc477dbf6122191b8ef2415",
"small": "https://ksr-ugc.imgix.net/avatars/1539487/MichaelShapcott_thumb.original.jpg?v=1331450574&w=80&h=80&fit=crop&auto=format&q=92&s=a951a2d5626f41be48003469ccca9576",
"medium": "https://ksr-ugc.imgix.net/avatars/1539487/MichaelShapcott_thumb.original.jpg?v=1331450574&w=160&h=160&fit=crop&auto=format&q=92&s=a359360352dcb46ab36dbf04866ba352"
},
"urls": {
"web": {
"user": "https://www.kickstarter.com/profile/michaelshapcott"
},
"api": {
"user": "https://api.kickstarter.com/v1/users/1537276594?signature=1434200014.6d2ca36f0053c57856eff001e8d164658b1ea6b6"
}
},
"user_id": 1539487
},
"location": {
"id": 2458090,
"name": "New Britain",
"slug": "new-britain-ct",
"short_name": "New Britain, CT",
"displayable_name": "New Britain, CT",
"country": "US",
"state": "CT",
"type": "Town",
"is_root": false,
"urls": {
"web": {
"discover": "https://www.kickstarter.com/discover/places/new-britain-ct",
"location": "https://www.kickstarter.com/locations/new-britain-ct"
},
"api": {
"nearby_projects": "https://api.kickstarter.com/v1/discover?signature=1434192693.1e67da952b6693c5eab2398af8884d4ec9c2919a&woe_id=2458090"
}
}
},
"category": {
"id": 23,
"name": "Painting",
"slug": "art/painting",
"position": 7,
"parent_id": 1,
"urls": {
"web": {
"discover": "http://www.kickstarter.com/discover/categories/art/painting"
}
}
},
"profile": {
"id": 97976,
"project_id": 97976,
"state": "inactive",
"state_changed_at": 1425915805,
"name": null,
"blurb": null,
"background_color": null,
"text_color": null,
"link_background_color": null,
"link_text_color": null,
"link_text": null,
"link_url": null,
"show_feature_image": false,
"background_image_opacity": 0.8,
"should_show_feature_image": true,
"feature_image_attributes": {
"image_urls": {
"default": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=1536&h=1152&fit=crop&auto=format&q=92&s=7b4aad024a0685165f295c10c3894175",
"baseball_card": "https://ksr-ugc.imgix.net/projects/95735/photo-original.jpg?v=1397773825&w=1536&h=1152&fit=crop&auto=format&q=92&s=7b4aad024a0685165f295c10c3894175"
}
}
},
"spotlight": true,
"urls": {
"web": {
"project": "https://www.kickstarter.com/projects/michaelshapcott/drawing-a-drawing-365?ref=category",
"rewards": "https://www.kickstarter.com/projects/michaelshapcott/drawing-a-drawing-365/rewards"
}
}
},
I did not see an option to import JSON file when I tried to import the file. Any help in this area would be appreciated.
Thanks!
Comment