#1 FairPrice Datasets

Provided by NTUC FairPrice

There will be 5 separate datasets. The fields of each datasets are listed below. Download here.

Datasets

1. Customer and Address.xlsx
   • Order Code (Order No.)
   • Corporate Customer ID
   • Individual Customer ID
   • Postal Sector
2. Orders Details.xlsx
   • Order No.
   • Total Order Discount
   • Order Day
   • Order Time
   • Delivery Day
   • Delivery Timeslot
3. Customer Demographics.xlsx
   • Individual Customer ID
   • Gender
   • Age Band
   • Race
   • Nationality

   Note: Customer demographics information is available for some individual customers only.

4. Item_Category.xlsx
   • Item ID
   • Department
   • Category
   • Sub Category
5. Ordered Items.xlsx
   • Order No.
   • Item ID
   • Quantity Purchased
   • Sales Amount

Descriptions of dataset fields

• Order No. - Unique number given when a purchase is made.
• Corporate Customer ID - Unique number given to customers who make purchases on behalf of the company.
• Individual Customer ID - Unique number given to an individual customer who make purchases for themselves and/or on behalf of the household.
• Postal Sector - A postal address at sector level.
   Note: Orders with "NA' postal sectors are Voluntary Welfare Orders (VWO).
• Item ID - Product Identification number
• Department - The broad categorisation of items e.g. Toiletries
• Category - Category is a sub-class within the Department e.g: Toiletries/Baby Care
• Sub Category - Sub-category is a sub-class within the Category e.g. Toiletries/Baby Care/ Diapers
• Quantity Purchased - Quantity bought for an item.
• Sales Amount - Revenue received based on quantity purchased.
   Note: Items with no sales denotes Free gift
• Total Order Discount - Consolidated discount given for an order
• Order Day, Order Time - Day No. and Time of order
• Delivery Day, Delivery Timeslot - Day No. and Time of Delivery

#2 Canteen Crowd

Provided by NUS Living Lab

This project generates crowd index, describing the level of crowd using image processing algorithms. This is a temporal data with data resolution of one crowd index every 30 seconds. The data is generated from morning (7 a.m) to evening (9 p.m) during week days (Monday to Friday). This service is shut down on Saturdays and Sundays. The data is generated for over 60+ camera locations across canteens at National University of Singapore.

Live data and historical data for the past 2 weeks are available here.

• Name - Name of the camera
• Canteen - Name of the canteen
• CrowdValue - Canteen crowd value (in percentage)
• CrowdTimeString - Crowd detected time

Sample Data:

                        {
                            name: "TechnoEdge_Cam09",
                            canteen: "TechnoEdge",
                            crowd: 92,
                            crowdTimeString: "2016-09-07T02:32:15.000Z" (UTC Time)
                        }
                                

#3 MSE Data

Provided by NUS Living Lab

MSE is short for Mobile Service Engine, which is a CISCO product, mainly provides localisation service for mobile user. CISCO MSE is suitable to generate heat map representation for visualizing the crowd density of an area. The CISCO MSE proesses the wifi device information collected by CISCO wifi access points to localize wifi devices.

Live data and historical data for the past 2 weeks are available here.

• TimeStamp - Server time
• dot11Status - Status of the device whether it is associated or probing
• cur.ServerTime - Current server time
• firstLocatedTime - Device first detected time
• lastLocatedTime - Device last detected time
• latitude - Latitude of the device
• longitude - Longitude of the device
• HasedhMac - Hashed Device Mac Address for wi-fi device

Sample Data:

                        {
                            TimeStamp           :   20160830-01:00:01,
                            dot11Status         :   ASSOCIATED
                            currentServerTime   :   2016-08-30T00:59:48.416+0800
                            firstLocatedTime    :   2016-08-30T00:55:39.135+0800
                            lastLocatedTime     :   2016-08-30T00:55:39.135+0800
                            latitude            :   1.2972337752
                            longitude           :   103.7706123586
                            HashedMac           :   ce05e3ce261b1da11e721196dfc2747ba27db45f
                        }
                                

#4 Shuttle Bus Data

Provided by NUS Living Lab

It provides information on number of devices connected to wi-fi access points inside shuttle buses. There are 2 API calls- one is for bus location and another is for session. Using these information, one can track a wifi device across bus stops.

Live data and historical data for the past 2 weeks are available here.

• Bus location
  • node_id - Unique id to track the bus
  • vehicle_serial - Bus number
  • gps_time - Gps time for the bus
  • latitude - Latitude of the bus
  • longitude - Longitude of the bus
  • altitude - Altitude of the bus (The height of the bus from sea level)
  • speed - Speed of the bus
  • heading - Heading of the bus (Direction of the bus with respect to previous position)
• Session
  • session_id - unique id per device
  • mac_hash - Hashed Mac address for wi-fi device
  • ts_begin - Wi-fi device enters coverage area
  • ts_end - Wi-fi device leaves coverage area
  • incoming - Volume of incoming data
  • outgoing - Volume of outgoing data
  • latitude_begin - Starting location(latitude) of the wi-fi device
  • longitude_begin - Starting location(longitude) of the wi-fi device
  • latitude_end - Ending location(latitude) of the wi-fi device
  • longitude_end - Ending location(longitude) of the wi-fi device
  • duration - Total duration of the wi-fi device

Sample Data:

                        // Bus location
                        {
                            "node_id": 2021,
                            "vehicle_serial": "PC3853E",
                            "system_time": "2016-06-29T16:00:04.000Z",
                            "gps_time": "2016-06-29T16:00:03.000Z",
                            "latitude": 1.294367,
                            "longitude": 103.77503,
                            "altitude": 35,
                            "speed": 0,
                            "heading": 158,
                        }

                        // Session
                        {
                            "session_id": "1fc49523305679beac2d276bc27c0b55a5c0cb42",
                            "mac_hash": "ce05e3ce261b1da11e721196dfc2747ba27db45f",
                            "gw_id": 2052,
                            "ts_begin": "2016-06-29T16:11:04.000Z",
                            "ts_end": "2016-06-29T16:18:02.000Z",
                            "incoming": 70060,
                            "outgoing": 50756,
                            "latitude_begin": 1.291867,
                            "longitude_begin": 103.78059,
                            "latitude_end": 1.291883,
                            "longitude_end": 103.78055,
                            "duration": 418
                        }
                                

#5 LTA Taxi Availability

Provided by NUS Living Lab

This dataset contains the location coordinates of all Taxis that are available for hire at present moment. Does not include "Hired" or "Busy" Taxis.

Data for the past 2 weeks is available here.

• Latitude
• Longitude

Sample Data:

                        {
                            1.336980,
                            103.705830
                        }
                                

#6 LTA Traffic Incidents

Provided by NUS Living Lab

This dataset Lists traffic incidents currently occurring on the roads, including Accidents, Vehicle Breakdowns, Obstacles, Road Blocks, Traffic Diversions etc.

Data for the past 2 weeks is available here.

• Type
• Latitude
• Longitude
• Message

Sample Data:

                    {
                        Accident
                        1.336980,
                        103.705830,
                        (23/1)10:12 Accident in the CTE Tunnel (towards AYE) at Havelock Exit.
                    }
                                

#7 NEA Environment

Provided by NUS Living Lab

This dataset Lists traffic incidents currently occurring on the roads, including Accidents, Vehicle Breakdowns, Obstacles, Road Blocks, Traffic Diversions etc.

Data for the past 2 weeks is available here.

• Hour
• Valid time
• Area name
• Forecast abbreviation
• Latitude
• Longitude

Sample Data:

                    {
                        11:30 PM,
                        11.30 pm to 1.30 am,
                        ANG MO KIO,
                        FD, 
                        1.37,   
                        103.8494
                    }
                                

#8 AMI Lab Sensor Info

Provided by NUS Living Lab

It provides sensor information like Temparature , Humidity, Luminocity etc. As of now these sensor devices located in AMI lab.

Data for the past 2 weeks is available here.

• ISOTime
• Device ID
• Temperature
• Humidity
• Luminosity

Sample Data:

                    {
                        2016-08-09T00:00:03+00:00,
                        00124b983d84,
                        29,
                        62,
                        1
                    }