Skip to content

Instantly share code, notes, and snippets.

@imerla1

imerla1/db.json

Created September 10, 2023 09:38
Show Gist options
  • Save imerla1/902647c5407e285b0a6b36f3f68f14af to your computer and use it in GitHub Desktop.
Save imerla1/902647c5407e285b0a6b36f3f68f14af to your computer and use it in GitHub Desktop.
Download ZIP
Test Data
Raw
db.json
{
"venueName": "Hrazdan Stadium",
"eventName": "Snoop Dogg",
"readableDate": "23 Sep 2023",
"rawDate": "2023-09-23T20:00:00",
"eventId": 152172533,
"soldTickets": 4,
"availableTickets": 25,
"totalTickets": 29,
"allSections": [
"General Admission",
"Blue Zone",
"General Admission VIP",
"Orange Zone",
"Orange Area",
"Red Zone",
"GA"
],
"allSectionIds": [
1837498,
{
"$numberLong": "519860612614"
},
1837499,
{
"$numberLong": "1023697793073"
},
{
"$numberLong": "682772067383"
},
{
"$numberLong": "278883536099"
},
{
"$numberLong": "138134076086"
}
],
"representativeId": {
"$oid": "64fc4890647a1701304e3855"
},
"representativeName": "Snoop Dogg",
"revisionNumber": 1,
"createdAt": {
"$date": {
"$numberLong": "1694351288672"
}
},
"revisionDate": {
"$date": {
"$numberLong": "1694351288672"
}
},
"items": [
{
"section": "General Admission",
"totalAvailableTicketsInSection": 8,
"totalSoldTicketsInSection": 1,
"totalTicketsInSection": 9,
"averageSoldTicketPrice": 157.2,
"averageAvailableTicketPrice": 230.55999999999997,
"sectionId": 1837498,
"tickets": [
{
"rawPrice": 149.34,
"row": "",
"quantityRange": "1",
"sectionName": "General Admission",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6511379685"
}
},
{
"rawPrice": 149.34,
"row": "",
"quantityRange": "1 - 6",
"sectionName": "General Admission",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6529106067"
}
},
{
"rawPrice": 157.2,
"row": "",
"quantityRange": "1",
"sectionName": "General Admission",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6516034651"
}
},
{
"rawPrice": 157.2,
"row": "",
"quantityRange": "1",
"sectionName": "General Admission",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6526121490"
}
},
{
"rawPrice": 183.4,
"row": "",
"quantityRange": "1 - 6",
"sectionName": "General Admission",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6527598001"
}
},
{
"rawPrice": 157.2,
"row": "",
"quantityRange": "2",
"sectionName": "General Admission",
"ticketStatus": "sold",
"ticketId": {
"$numberLong": "6526121490"
}
},
{
"rawPrice": 314.4,
"row": "",
"quantityRange": "1",
"sectionName": "General Admission",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6527580687"
}
},
{
"rawPrice": 314.4,
"row": "",
"quantityRange": "1 - 8",
"sectionName": "General Admission",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6533416269"
}
},
{
"rawPrice": 419.2,
"row": "",
"quantityRange": "1 - 10",
"sectionName": "General Admission",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6527558543"
}
}
]
},
{
"section": "Blue Zone",
"totalAvailableTicketsInSection": 1,
"totalSoldTicketsInSection": 1,
"totalTicketsInSection": 2,
"averageSoldTicketPrice": 576.4,
"averageAvailableTicketPrice": 1048,
"sectionId": {
"$numberLong": "519860612614"
},
"tickets": [
{
"rawPrice": 576.4,
"row": null,
"quantityRange": "2",
"sectionName": "Blue Zone",
"ticketStatus": "sold",
"ticketId": {
"$numberLong": "6492546706"
}
},
{
"rawPrice": 1048,
"row": null,
"quantityRange": "2",
"sectionName": "Blue Zone",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6457058125"
}
}
]
},
{
"section": "General Admission VIP",
"totalAvailableTicketsInSection": 3,
"totalSoldTicketsInSection": 1,
"totalTicketsInSection": 4,
"averageSoldTicketPrice": 510.9,
"averageAvailableTicketPrice": 537.1,
"sectionId": 1837499,
"tickets": [
{
"rawPrice": 510.9,
"row": "",
"quantityRange": "2",
"sectionName": "General Admission VIP",
"ticketStatus": "sold",
"ticketId": {
"$numberLong": "6518384486"
}
},
{
"rawPrice": 510.9,
"row": "",
"quantityRange": "1 - 2",
"sectionName": "General Admission VIP",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6518384486"
}
},
{
"rawPrice": 524,
"row": "",
"quantityRange": "1 - 4",
"sectionName": "General Admission VIP",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6533826443"
}
},
{
"rawPrice": 576.4,
"row": "",
"quantityRange": "1 - 10",
"sectionName": "General Admission VIP",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6533980378"
}
}
]
},
{
"section": "Orange Zone",
"totalAvailableTicketsInSection": 5,
"totalSoldTicketsInSection": 1,
"totalTicketsInSection": 6,
"averageSoldTicketPrice": 209.6,
"averageAvailableTicketPrice": 404.13199999999995,
"sectionId": {
"$numberLong": "1023697793073"
},
"tickets": [
{
"rawPrice": 207.59,
"row": null,
"quantityRange": "1 - 10",
"sectionName": "Orange Zone",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6495377486"
}
},
{
"rawPrice": 248.9,
"row": "Area",
"quantityRange": "1 - 2",
"sectionName": "Orange Zone",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6505213659"
}
},
{
"rawPrice": 262,
"row": null,
"quantityRange": "1 - 6",
"sectionName": "Orange Zone",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6459255230"
}
},
{
"rawPrice": 209.6,
"row": null,
"quantityRange": "1",
"sectionName": "Orange Zone",
"ticketStatus": "sold",
"ticketId": {
"$numberLong": "6461730270"
}
},
{
"rawPrice": 516.17,
"row": null,
"quantityRange": "1 - 5",
"sectionName": "Orange Zone",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6488942135"
}
},
{
"rawPrice": 786,
"row": null,
"quantityRange": "2",
"sectionName": "Orange Zone",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6457048938"
}
}
]
},
{
"section": "Orange Area",
"totalAvailableTicketsInSection": 1,
"totalSoldTicketsInSection": 0,
"totalTicketsInSection": 1,
"averageSoldTicketPrice": 0,
"averageAvailableTicketPrice": 262,
"sectionId": {
"$numberLong": "682772067383"
},
"tickets": [
{
"rawPrice": 262,
"row": "No",
"quantityRange": "1 - 2",
"sectionName": "Orange Area",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6456949260"
}
}
]
},
{
"section": "Red Zone",
"totalAvailableTicketsInSection": 6,
"totalSoldTicketsInSection": 0,
"totalTicketsInSection": 6,
"averageSoldTicketPrice": 0,
"averageAvailableTicketPrice": 664.9866666666667,
"sectionId": {
"$numberLong": "278883536099"
},
"tickets": [
{
"rawPrice": 468.98,
"row": null,
"quantityRange": "1 - 6",
"sectionName": "Red Zone",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6495992706"
}
},
{
"rawPrice": 471.6,
"row": null,
"quantityRange": "1",
"sectionName": "Red Zone",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6465394936"
}
},
{
"rawPrice": 507,
"row": null,
"quantityRange": "2",
"sectionName": "Red Zone",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6530186083"
}
},
{
"rawPrice": 609.57,
"row": null,
"quantityRange": "4",
"sectionName": "Red Zone",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6530186939"
}
},
{
"rawPrice": 622.77,
"row": null,
"quantityRange": "1 - 10",
"sectionName": "Red Zone",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6495366395"
}
},
{
"rawPrice": 1310,
"row": null,
"quantityRange": "2",
"sectionName": "Red Zone",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6457055468"
}
}
]
},
{
"section": "GA",
"totalAvailableTicketsInSection": 1,
"totalSoldTicketsInSection": 0,
"totalTicketsInSection": 1,
"averageSoldTicketPrice": 0,
"averageAvailableTicketPrice": 1048,
"sectionId": {
"$numberLong": "138134076086"
},
"tickets": [
{
"rawPrice": 1048,
"row": "Orang",
"quantityRange": "1",
"sectionName": "GA",
"ticketStatus": "available",
"ticketId": {
"$numberLong": "6467636524"
}
}
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment