Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Bus Location
| Bus Station               |   Latitude |   Longitude |   Value (For Coloring) |
|:--------------------------|-----------:|------------:|-----------------------:|
| Ang Mo Kio Interchange    |     1.3697 |     103.848 |                      1 |
| Bedok Interchange         |     1.3246 |     103.929 |                      1 |
| Bishan Interchange        |     1.3506 |     103.85  |                      1 |
| Boon Lay Interchange      |     1.3394 |     103.705 |                      1 |
| Bukit Merah Interchange   |     1.2821 |     103.817 |                      1 |
| Bukit Panjang Interchange |     1.3785 |     103.763 |                      1 |
| Choa Chu Kang Interchange |     1.3859 |     103.746 |                      1 |
| Clementi Interchange      |     1.3151 |     103.764 |                      1 |
| Compassvale Interchange   |     1.3913 |     103.897 |                      1 |
| Eunos Interchange         |     1.3194 |     103.902 |                      1 |


Table: Bus Population
|   Year |   Number of buses in Singapore from 2011 to 2020 (in 1,000s) |
|-------:|-------------------------------------------------------------:|
|   2015 |                                                        17.74 |
|   2016 |                                                        18.34 |
|   2017 |                                                        18.81 |
|   2018 |                                                        18.95 |
|   2019 |                                                        19.33 |
|   2020 |                                                        18.91 |


Table: Consumer Goods Navigation
| Consumer Good Page   |
|:---------------------|
| Price Index          |
| Accessibility        |
| Local Price Index    |
| Import Price Index   |


Table: Consumer-Price-Index-at-expenditure-division-level-2019 Annual
|   Year | Item      | Category             |   Index |
|-------:|:----------|:---------------------|--------:|
|   2000 | All Items | Food                 |  68.101 |
|   2000 | All Items | Clothing & Footwear  |  91.668 |
|   2000 | All Items | Health Care          |  62.534 |
|   2000 | All Items | Transport            |  76.945 |
|   2000 | All Items | Recreation & Culture |  85.603 |
|   2000 | All Items | Education            |  54.993 |
|   2001 | All Items | Food                 |  68.44  |
|   2001 | All Items | Clothing & Footwear  |  92.006 |
|   2001 | All Items | Health Care          |  64.34  |
|   2001 | All Items | Transport            |  76.104 |


Table: Crime Cases OTY
| Year                    |   Values | Crime              |
|:------------------------|---------:|:-------------------|
| 2020-01-01 00:00:00.000 |     4602 | Crimes to People   |
| 2020-01-01 00:00:00.000 |      305 | Serious Property   |
| 2020-01-01 00:00:00.000 |     7437 | Theft Related      |
| 2020-01-01 00:00:00.000 |    17123 | Commercial         |
| 2020-01-01 00:00:00.000 |     7596 | Miscellaneous      |
| 2020-01-01 00:00:00.000 |      210 | Housebreak Related |
| 2019-01-01 00:00:00.000 |     4349 | Crimes to People   |
| 2019-01-01 00:00:00.000 |      153 | Serious Property   |
| 2019-01-01 00:00:00.000 |    11128 | Theft Related      |
| 2019-01-01 00:00:00.000 |    12710 | Commercial         |


Table: Date
| Date                    |   Year | Quarter   | Month    |   MonthKey |
|:------------------------|-------:|:----------|:---------|-----------:|
| 2000-01-01 00:00:00.000 |   2000 | 2000 Q1   | 2000 Jan |     200001 |
| 2000-01-02 00:00:00.000 |   2000 | 2000 Q1   | 2000 Jan |     200001 |
| 2000-01-03 00:00:00.000 |   2000 | 2000 Q1   | 2000 Jan |     200001 |
| 2000-01-04 00:00:00.000 |   2000 | 2000 Q1   | 2000 Jan |     200001 |
| 2000-01-05 00:00:00.000 |   2000 | 2000 Q1   | 2000 Jan |     200001 |
| 2000-01-06 00:00:00.000 |   2000 | 2000 Q1   | 2000 Jan |     200001 |
| 2000-01-07 00:00:00.000 |   2000 | 2000 Q1   | 2000 Jan |     200001 |
| 2000-01-08 00:00:00.000 |   2000 | 2000 Q1   | 2000 Jan |     200001 |
| 2000-01-09 00:00:00.000 |   2000 | 2000 Q1   | 2000 Jan |     200001 |
| 2000-01-10 00:00:00.000 |   2000 | 2000 Q1   | 2000 Jan |     200001 |


Table: Date1
| Date                    |   Year | Quarter   | Month    |   MonthKey |
|:------------------------|-------:|:----------|:---------|-----------:|
| 2006-01-01 00:00:00.000 |   2006 | 2006 Q1   | 2006 Jan |     200601 |
| 2006-01-02 00:00:00.000 |   2006 | 2006 Q1   | 2006 Jan |     200601 |
| 2006-01-03 00:00:00.000 |   2006 | 2006 Q1   | 2006 Jan |     200601 |
| 2006-01-04 00:00:00.000 |   2006 | 2006 Q1   | 2006 Jan |     200601 |
| 2006-01-05 00:00:00.000 |   2006 | 2006 Q1   | 2006 Jan |     200601 |
| 2006-01-06 00:00:00.000 |   2006 | 2006 Q1   | 2006 Jan |     200601 |
| 2006-01-07 00:00:00.000 |   2006 | 2006 Q1   | 2006 Jan |     200601 |
| 2006-01-08 00:00:00.000 |   2006 | 2006 Q1   | 2006 Jan |     200601 |
| 2006-01-09 00:00:00.000 |   2006 | 2006 Q1   | 2006 Jan |     200601 |
| 2006-01-10 00:00:00.000 |   2006 | 2006 Q1   | 2006 Jan |     200601 |


Table: Delays
|   Year |   Number of delays lasting more than 30 minutes of the MRT Network |
|-------:|-------------------------------------------------------------------:|
|   2015 |                                                                 15 |
|   2016 |                                                                 16 |
|   2017 |                                                                 16 |
|   2018 |                                                                  9 |
|   2019 |                                                                  4 |
|   2020 |                                                                  6 |


Table: Dental Health Index
|   Year |   Dental Index |
|-------:|---------------:|
|   2003 |           0.74 |
|   2003 |           1.14 |
|   2004 |           0.73 |
|   2004 |           1.07 |
|   2005 |           0.77 |
|   2005 |           1.19 |
|   2006 |           0.74 |
|   2006 |           1.14 |
|   2007 |           0.72 |
|   2007 |           1.07 |


Table: Econ Nav
| Navigation                          |
|:------------------------------------|
| Retrenchment & Job Vacancies        |
| Stats Model for Economy             |
| Household Subsidies                 |
| Mthly Household Income In-depth 1st |
| Mthly Household Income In-depth 2nd |
| Mthly Household Income In-depth 3rd |
| Mthly Household Income In-depth 4th |


Table: Economy Date Table
| Date                    | Month    |   MonthKey | Quarter   |   Year |
|:------------------------|:---------|-----------:|:----------|-------:|
| 2010-01-01 00:00:00.000 | 2010 Jan |     201001 | 2010 Q1   |   2010 |
| 2010-01-02 00:00:00.000 | 2010 Jan |     201001 | 2010 Q1   |   2010 |
| 2010-01-03 00:00:00.000 | 2010 Jan |     201001 | 2010 Q1   |   2010 |
| 2010-01-04 00:00:00.000 | 2010 Jan |     201001 | 2010 Q1   |   2010 |
| 2010-01-05 00:00:00.000 | 2010 Jan |     201001 | 2010 Q1   |   2010 |
| 2010-01-06 00:00:00.000 | 2010 Jan |     201001 | 2010 Q1   |   2010 |
| 2010-01-07 00:00:00.000 | 2010 Jan |     201001 | 2010 Q1   |   2010 |
| 2010-01-08 00:00:00.000 | 2010 Jan |     201001 | 2010 Q1   |   2010 |
| 2010-01-09 00:00:00.000 | 2010 Jan |     201001 | 2010 Q1   |   2010 |
| 2010-01-10 00:00:00.000 | 2010 Jan |     201001 | 2010 Q1   |   2010 |


Table: Economy Low-Income Subsidies
| Comcare Schemes                                   | Year                    |   Amount Subsidised |
|:--------------------------------------------------|:------------------------|--------------------:|
| Overall Comcare Schemes (Households) (Households) | 2020-01-01 00:00:00.000 |               46147 |
| Overall Comcare Schemes (Households) (Households) | 2019-01-01 00:00:00.000 |               39197 |
| Overall Comcare Schemes (Households) (Households) | 2018-01-01 00:00:00.000 |               37436 |
| Overall Comcare Schemes (Households) (Households) | 2017-01-01 00:00:00.000 |               39300 |
| Overall Comcare Schemes (Households) (Households) | 2016-01-01 00:00:00.000 |               39162 |
| Overall Comcare Schemes (Households) (Households) | 2015-01-01 00:00:00.000 |               39548 |
| Overall Comcare Schemes (Households) (Households) | 2014-01-01 00:00:00.000 |               41920 |
| Overall Comcare Schemes (Households) (Households) | 2013-01-01 00:00:00.000 |               41086 |
| Overall Comcare Schemes (Households) (Households) | 2012-01-01 00:00:00.000 |               42246 |
| Overall Comcare Schemes (Households) (Households) | 2011-01-01 00:00:00.000 |               34908 |


Table: ED Attendances
| Day       |   AH |   CGH |   KTPH |   NTFGH |   NUH(A) |   SGH |   SKH |   TTSH |   AVG per day |
|:----------|-----:|------:|-------:|--------:|---------:|------:|------:|-------:|--------------:|
| Sunday    |   36 |   330 |    304 |     291 |      237 |   260 |   316 |    313 |       260.875 |
| Monday    |   55 |   405 |    398 |     376 |      308 |   348 |   406 |    338 |       329.25  |
| Tuesday   |   38 |   354 |    332 |     340 |      263 |   300 |   357 |    326 |       288.75  |
| Wednesday |   50 |   119 |    336 |     322 |      294 |   295 |   301 |    320 |       254.625 |
| Thursday  |   31 |   377 |    319 |     306 |      273 |   280 |   292 |    279 |       269.625 |
| Friday    |   48 |   346 |    323 |     310 |      242 |   285 |   301 |    284 |       267.375 |
| Saturday  |   33 |   312 |    274 |     298 |      250 |   314 |   336 |    254 |       258.875 |


Table: Fares
| Distance Travelled (in kilometres)   |   2015 |   2019 and 2016 |   2017 and 2018 |   2020 |
|:-------------------------------------|-------:|----------------:|----------------:|-------:|
| 0 to 3.2km                           |   0.39 |            0.38 |            0.37 |   0.42 |
| 3.3 to 4.2km                         |   0.44 |            0.43 |            0.42 |   0.47 |
| 4.3 to 5.2km                         |   0.49 |            0.48 |            0.47 |   0.52 |
| 5.3 to 6.2km                         |   0.54 |            0.53 |            0.52 |   0.57 |
| 6.3 to 7.2km                         |   0.58 |            0.56 |            0.55 |   0.6  |
| 7.3 to 8.2km                         |   0.61 |            0.59 |            0.58 |   0.63 |
| 8.3km and above                      |   0.61 |            0.59 |            0.58 |   0.63 |


Table: Food & Beverage Services Index-2017 Annual
|   Year | Category                                 |   Index |
|-------:|:-----------------------------------------|--------:|
|   2005 | Food Caterers                            |  77.449 |
|   2005 | Cafes, Food Courts & Other Eating Places |  69.618 |
|   2005 | Fast Food Outlets                        |  58.325 |
|   2005 | Restaurants                              |  81.821 |
|   2006 | Cafes, Food Courts & Other Eating Places |  71.788 |
|   2006 | Fast Food Outlets                        |  60.528 |
|   2006 | Food Caterers                            |  78.05  |
|   2006 | Restaurants                              |  88.034 |
|   2007 | Restaurants                              |  90.388 |
|   2007 | Cafes, Food Courts & Other Eating Places |  79.261 |


Table: Government Health Expenditure
|   Year |   Government Health Expenditure |   GDP |
|-------:|--------------------------------:|------:|
|   2006 |                          2009.7 |   0.9 |
|   2007 |                          2283.2 |   0.8 |
|   2008 |                          2814.1 |   1   |
|   2009 |                          3745.8 |   1.3 |
|   2010 |                          3856.7 |   1.2 |
|   2011 |                          4091.5 |   1.2 |
|   2012 |                          4837.3 |   1.3 |
|   2013 |                          5938.1 |   1.6 |
|   2014 |                          7223.1 |   1.8 |
|   2015 |                          8639.9 |   2.1 |


Table: Government-Expenditure-on-Education
|   Year |      Expenditure |
|-------:|-----------------:|
|   1981 | 942517           |
|   1982 |      1.35843e+06 |
|   1983 |      1.61165e+06 |
|   1984 |      1.76973e+06 |
|   1985 |      1.81238e+06 |
|   1986 |      1.64189e+06 |
|   1987 |      1.65412e+06 |
|   1988 |      1.60447e+06 |
|   1989 |      1.76525e+06 |
|   1990 |      2.05637e+06 |


Table: Government-Recurrent-Expenditure-Education-on-Education-Type
|   Year | School Category                         |   Expenditure |
|-------:|:----------------------------------------|--------------:|
|   1981 | Primary Schools                         |        241364 |
|   1981 | Secondary Schools                       |        222153 |
|   1981 | Junior Colleges / Centralised Institute |         22787 |
|   1981 | Institute of Technical Education        |         38900 |
|   1981 | Polytechnics                            |         33623 |
|   1981 | Universities                            |        108527 |
|   1981 | Others                                  |         45378 |
|   1982 | Primary Schools                         |        337339 |
|   1982 | Secondary Schools                       |        291171 |
|   1982 | Junior Colleges / Centralised Institute |         31992 |


Table: Healthcare Facilities
|   Year | Institution Type      |   Number of Facilities |   Number of Beds |
|-------:|:----------------------|-----------------------:|-----------------:|
|   2009 | Hospital              |                     14 |             8289 |
|   2009 | Hospital              |                      1 |             2040 |
|   2009 | Hospital              |                      6 |              877 |
|   2009 | Residential Long-Term |                     60 |             9442 |
|   2009 | Residential Long-Term |                      2 |              129 |
|   2010 | Hospital              |                     15 |             8249 |
|   2010 | Hospital              |                      1 |             2010 |
|   2010 | Hospital              |                      6 |              842 |
|   2010 | Residential Long-Term |                     62 |             9551 |
|   2010 | Residential Long-Term |                      2 |              123 |


Table: Healthcare Graduates
| Profession        |   Year |   Graduated |
|:------------------|-------:|------------:|
| Medical Graduates |   2006 |         229 |
| Medical Graduates |   2007 |         227 |
| Medical Graduates |   2008 |         227 |
| Medical Graduates |   2009 |         219 |
| Medical Graduates |   2010 |         228 |
| Medical Graduates |   2011 |         279 |
| Medical Graduates |   2012 |         290 |
| Medical Graduates |   2013 |         303 |
| Medical Graduates |   2014 |         312 |
| Medical Graduates |   2015 |         302 |


Table: Healthcare Manpower
| Profession   |   Year |   Number |
|:-------------|-------:|---------:|
| Doctors      |   2006 |     6931 |
| Doctors      |   2007 |     7384 |
| Doctors      |   2008 |     7841 |
| Doctors      |   2009 |     8323 |
| Doctors      |   2010 |     9030 |
| Doctors      |   2011 |     9646 |
| Doctors      |   2012 |    10225 |
| Doctors      |   2013 |    10953 |
| Doctors      |   2014 |    11733 |
| Doctors      |   2015 |    12459 |


Table: Healthcare Pricings
| Institution         |   Price |
|:--------------------|--------:|
| Polyclinic          |  14     |
| Family Clinic       |  25.4   |
| Government Hospital | 125.429 |
| Private Hospital    | 151.56  |


Table: Healthcare Professionals to Population
|   Year | Profession   |   Number per 1000 | YearDate   |
|-------:|:-------------|------------------:|:-----------|
|   2006 | Doctors      |               1.6 | 1/1/2006   |
|   2007 | Doctors      |               1.6 | 1/1/2007   |
|   2008 | Doctors      |               1.6 | 1/1/2008   |
|   2009 | Doctors      |               1.7 | 1/1/2009   |
|   2010 | Doctors      |               1.8 | 1/1/2010   |
|   2011 | Doctors      |               1.9 | 1/1/2011   |
|   2012 | Doctors      |               1.9 | 1/1/2012   |
|   2013 | Doctors      |               2   | 1/1/2013   |
|   2014 | Doctors      |               2.1 | 1/1/2014   |
|   2015 | Doctors      |               2.3 | 1/1/2015   |


Table: Hospital Admissions Waiting Time
| Day       |      AH |     CGH |     KTPH |   NTFGH |   NUH(A) |      SGH |     SKH |    TTSH |   AVG per day |
|:----------|--------:|--------:|---------:|--------:|---------:|---------:|--------:|--------:|--------------:|
| Monday    | 1.78167 | 2.53333 | 0.433333 |     3.2 |  1.85    | 1.25     | 2.39167 | 4.01667 |       2.18208 |
| Tuesday   | 1.60847 | 4.225   | 0.35     |    10.5 |  2.95    | 2.43333  | 8       | 4.85833 |       4.36564 |
| Wednesday | 1.16667 | 3.19167 | 4.3      |     7.2 |  2.76667 | 3.15833  | 4.1     | 4.3     |       3.77292 |
| Thursday  | 1.16667 | 3.78333 | 1.85     |     3.6 |  2.58333 | 2.53333  | 3.63333 | 4.2     |       2.91875 |
| Friday    | 1.13028 | 1.65    | 0.583333 |     2   |  3.2     | 1.80833  | 2.31667 | 4.13333 |       2.10274 |
| Saturday  | 1.00375 | 0.925   | 0.333333 |     1.9 |  2.30833 | 1.01667  | 1.96667 | 4.60833 |       1.75776 |
| Sunday    | 1.66528 | 1.16667 | 0.183333 |     2   |  1.5     | 0.816667 | 1.8     | 4.3     |       1.67899 |


Table: Household Healthcare Expenditure
| Year    | Household      |   Healthcare Expenditure Percentage |
|:--------|:---------------|------------------------------------:|
| 2002/3  | All Households |                                 4.7 |
| 2007/8  | All Households |                                 5.3 |
| 2012/13 | All Households |                                 4.5 |
| 2017/18 | All Households |                                 5.5 |


Table: Import Price Index Annual
|   Year | Description                                   |   Index |
|-------:|:----------------------------------------------|--------:|
|   2018 | IMPORT PRICE INDEX - ALL ITEMS                |     100 |
|   2018 | NON-OIL IMPORT PRICE INDEX                    |     100 |
|   2018 | OIL IMPORT PRICE INDEX                        |     100 |
|   2018 | FOOD & LIVE ANIMALS                           |     100 |
|   2018 | BEVERAGES & TOBACCO                           |     100 |
|   2018 | CRUDE MATERIALS (EXCL FUELS)                  |     100 |
|   2018 | MINERAL FUELS, LUBRICANTS & RELATED MATERIALS |     100 |
|   2018 | ANIMAL & VEGETABLE OILS FATS & WAXES          |     100 |
|   2018 | CHEMICALS & CHEMICAL PRODUCTS                 |     100 |
|   2018 | MANUFACTURED GOODS                            |     100 |


Table: Interest Groups In Community Clubs And Residents' Committees
| Interest Group                                     | Year                    |   Number of Interest |
|:---------------------------------------------------|:------------------------|---------------------:|
| Number Of Interest Groups For Music, Drama & Dance | 2019-01-01 00:00:00.000 |                 2854 |
| Number Of Interest Groups For Music, Drama & Dance | 2018-01-01 00:00:00.000 |                 2756 |
| Number Of Interest Groups For Music, Drama & Dance | 2017-01-01 00:00:00.000 |                 2597 |
| Number Of Interest Groups For Music, Drama & Dance | 2016-01-01 00:00:00.000 |                 2589 |
| Number Of Interest Groups For Music, Drama & Dance | 2015-01-01 00:00:00.000 |                 2447 |
| Number Of Interest Groups For Music, Drama & Dance | 2014-01-01 00:00:00.000 |                 2368 |
| Number Of Interest Groups For Music, Drama & Dance | 2013-01-01 00:00:00.000 |                 1932 |
| Dance                                              | 2019-01-01 00:00:00.000 |                 1110 |
| Dance                                              | 2018-01-01 00:00:00.000 |                 1062 |
| Dance                                              | 2017-01-01 00:00:00.000 |                 1019 |


Table: Job Vacancies by Occupation
|   Year | Occupation                                                 |   Job Vacancies |
|-------:|:-----------------------------------------------------------|----------------:|
|   2010 | professional, managers, executive and technicians          |           80200 |
|   2010 | clerical, sales and services workers                       |           48100 |
|   2010 | production and transport operators, cleaners and labourers |           48400 |
|   2011 | professional, managers, executive and technicians          |           91400 |
|   2011 | clerical, sales and services workers                       |           59900 |
|   2011 | production and transport operators, cleaners and labourers |           59600 |
|   2012 | professional, managers, executive and technicians          |           81700 |
|   2012 | clerical, sales and services workers                       |           58600 |
|   2012 | production and transport operators, cleaners and labourers |           54100 |
|   2013 | professional, managers, executive and technicians          |           94100 |


Table: Licensed Food Establishments
|   Year | Category                       |   Value |
|-------:|:-------------------------------|--------:|
|   2000 | Private Markets                |     427 |
|   2000 | Food Stalls                    |   13483 |
|   2000 | Supermarkets                   |     193 |
|   2000 | Non-Retail Food Establishments |    1194 |
|   2000 | Food Shops                     |    9217 |
|   2001 | Supermarkets                   |     193 |
|   2001 | Non-Retail Food Establishments |    1206 |
|   2001 | Food Shops                     |    9857 |
|   2001 | Private Markets                |     407 |
|   2001 | Food Stalls                    |   13499 |


Table: list-of-supermarket-licences
| License Name                    | Street Name          |   Postal Code | Location          |
|:--------------------------------|:---------------------|--------------:|:------------------|
| NTUC Fairprice Co-operative Ltd | HOUGANG STREET 91    |        538692 | Singapore, 538692 |
| NTUC Fairprice Co-operative Ltd | SENGKANG WEST AVENUE |        797653 | Singapore, 797653 |
| NTUC Fairprice Co-operative Ltd | HOUGANG AVENUE 4     |        530682 | Singapore, 530682 |
| NTUC Fairprice Co-operative Ltd | JALAN KAYU           |        791447 | Singapore, 791447 |
| NTUC Fairprice Co-operative Ltd | ANG MO KIO AVENUE 3  |        569933 | Singapore, 569933 |
| NTUC Fairprice Co-operative Ltd | ANG MO KIO DRIVE     |        567720 | Singapore, 567720 |
| NTUC Fairprice Co-operative Ltd | ANG MO KIO AVENUE 6  |        560712 | Singapore, 560712 |
| NTUC Fairprice Co-operative Ltd | ANG MO KIO AVENUE 1  |        560215 | Singapore, 560215 |
| NTUC Fairprice Co-operative Ltd | BISHAN STREET 13     |        570510 | Singapore, 570510 |
| NTUC Fairprice Co-operative Ltd | BISHAN PLACE         |        579837 | Singapore, 579837 |


Table: Local Price Index Annual
|   Year | Description                                             |   Index |
|-------:|:--------------------------------------------------------|--------:|
|   2000 | SINGAPORE MANUFACTURED PRODUCTS PRICE INDEX - ALL ITEMS | 117.099 |
|   2000 | NON-OIL SINGAPORE MANUFACTURED PRODUCTS PRICE INDEX     | 145.111 |
|   2000 | OIL SINGAPORE MANUFACTURED PRODUCTS PRICE INDEX         |  54.159 |
|   2000 | FOOD & LIVE ANIMALS                                     |  75.386 |
|   2000 | BEVERAGES & TOBACCO                                     |  76.232 |
|   2000 | CRUDE MATERIALS (EXCL FUELS)                            |  26.432 |
|   2000 | MINERAL FUELS, LUBRICANTS & RELATED MATERIALS           |  54.159 |
|   2000 | ANIMAL & VEGETABLE OILS FATS & WAXES                    |  70.726 |
|   2000 | CHEMICALS & CHEMICAL PRODUCTS                           |  91.78  |
|   2000 | MANUFACTURED GOODS                                      |  89.674 |


Table: Medifund Grants
|   Year |   Grants Disbursed |
|-------:|-------------------:|
|   2006 |               39.6 |
|   2007 |               49.5 |
|   2008 |               59   |
|   2009 |               64.3 |
|   2010 |               78.7 |
|   2011 |               90.8 |
|   2012 |              101.9 |
|   2013 |              129.8 |
|   2014 |              159.3 |
|   2015 |              155.2 |


Table: Monthly Household Income Percentage
| Monthly Household Income                        |   Year |   Percentage | Monthly Household Income (groups)               |
|:------------------------------------------------|-------:|-------------:|:------------------------------------------------|
| Solely Non-Working Persons Aged 65 Years & Over |   2010 |          4.1 | Solely Non-Working Persons Aged 65 Years & Over |
| Solely Non-Working Persons Aged 65 Years & Over |   2011 |          4.5 | Solely Non-Working Persons Aged 65 Years & Over |
| Solely Non-Working Persons Aged 65 Years & Over |   2012 |          4.7 | Solely Non-Working Persons Aged 65 Years & Over |
| Solely Non-Working Persons Aged 65 Years & Over |   2013 |          4.9 | Solely Non-Working Persons Aged 65 Years & Over |
| Solely Non-Working Persons Aged 65 Years & Over |   2014 |          5.7 | Solely Non-Working Persons Aged 65 Years & Over |
| Solely Non-Working Persons Aged 65 Years & Over |   2015 |          5.3 | Solely Non-Working Persons Aged 65 Years & Over |
| Solely Non-Working Persons Aged 65 Years & Over |   2016 |          6.1 | Solely Non-Working Persons Aged 65 Years & Over |
| Solely Non-Working Persons Aged 65 Years & Over |   2017 |          6.9 | Solely Non-Working Persons Aged 65 Years & Over |
| Solely Non-Working Persons Aged 65 Years & Over |   2018 |          7.1 | Solely Non-Working Persons Aged 65 Years & Over |
| Solely Non-Working Persons Aged 65 Years & Over |   2019 |          7.9 | Solely Non-Working Persons Aged 65 Years & Over |


Table: MRT Location
| MRT Station   | Line   |   Latitude |   Longitude | Type             |   Numbering (For coloring) |
|:--------------|:-------|-----------:|------------:|:-----------------|---------------------------:|
| Jurong East   | MRT    |    1.33321 |     103.742 | Combined         |                          0 |
| Bukit Batok   | MRT    |    1.34907 |     103.75  | North South Line |                          1 |
| Bukit Gombak  | MRT    |    1.35904 |     103.752 | North South Line |                          1 |
| Choa Chu Kang | MRT    |    1.38542 |     103.744 | Combined         |                          0 |
| Yew Tee       | MRT    |    1.39738 |     103.748 | North South Line |                          1 |
| Kranji        | MRT    |    1.4253  |     103.762 | North South Line |                          1 |
| Marsiling     | MRT    |    1.43258 |     103.774 | North South Line |                          1 |
| Woodlands     | MRT    |    1.43698 |     103.786 | Combined         |                          0 |
| Admiralty     | MRT    |    1.43698 |     103.786 | North South Line |                          1 |
| Sembawang     | MRT    |    1.44913 |     103.82  | North South Line |                          1 |


Table: N-Level Progressed-Post Secondary
|   Year | Race    |   % N-Level Progress Post-Secondary |
|-------:|:--------|------------------------------------:|
|   2007 | Overall |                                88.3 |
|   2008 | Overall |                                88.8 |
|   2009 | Overall |                                89.9 |
|   2010 | Overall |                                90.8 |
|   2011 | Overall |                                92.4 |
|   2012 | Overall |                                93.7 |
|   2013 | Overall |                                95.2 |
|   2014 | Overall |                                95.7 |
|   2015 | Overall |                                95.9 |
|   2016 | Overall |                                96.3 |


Table: Navigation (2)
| Page Name                           |
|:------------------------------------|
| Economy ( Subsidies )               |
| Mthly Household Income In-Depth 1st |
| Mthly Household Income In-Depth 2nd |
| Mthly Household Income In-Depth 3rd |
| Mthly Household Income In-Depth 4th |


Table: Navigation
| Page Name                          |
|:-----------------------------------|
| Healthcare Waiting Time            |
| Student's Healthcare               |
| Healthcare Affordability           |
| Healthcare Affordability 2         |
| Healthcare Statistical Modelling 1 |
| Healthcare Statistical Modelling 2 |
| Healthcare Professionals           |
| Thank you                          |


Table: Number of Members In Community Clubs And Residents' Committees (2)
| Interest Group                             | Year                    |   Number of Members |
|:-------------------------------------------|:------------------------|--------------------:|
| Number Of Members For Music, Drama & Dance | 2019-01-01 00:00:00.000 |               50180 |
| Number Of Members For Music, Drama & Dance | 2018-01-01 00:00:00.000 |               48783 |
| Number Of Members For Music, Drama & Dance | 2017-01-01 00:00:00.000 |               44968 |
| Number Of Members For Music, Drama & Dance | 2016-01-01 00:00:00.000 |               41032 |
| Number Of Members For Music, Drama & Dance | 2015-01-01 00:00:00.000 |               37851 |
| Number Of Members For Music, Drama & Dance | 2014-01-01 00:00:00.000 |               36181 |
| Number Of Members For Music, Drama & Dance | 2013-01-01 00:00:00.000 |               24348 |
| Dance                                      | 2019-01-01 00:00:00.000 |               24175 |
| Dance                                      | 2018-01-01 00:00:00.000 |               23356 |
| Dance                                      | 2017-01-01 00:00:00.000 |               22160 |


Table: Number of Retrenchments by Occupation
|   Year | Occupation                                                 |   Number of Retrenchments |
|-------:|:-----------------------------------------------------------|--------------------------:|
|   2010 | professional, managers, executive and technicians          |                      3450 |
|   2010 | clerical, sales and services workers                       |                      1450 |
|   2010 | production and transport operators, cleaners and labourers |                      4900 |
|   2011 | professional, managers, executive and technicians          |                      4170 |
|   2011 | clerical, sales and services workers                       |                      1080 |
|   2011 | production and transport operators, cleaners and labourers |                      4750 |
|   2012 | professional, managers, executive and technicians          |                      5960 |
|   2012 | clerical, sales and services workers                       |                      1480 |
|   2012 | production and transport operators, cleaners and labourers |                      3570 |
|   2013 | professional, managers, executive and technicians          |                      6430 |


Table: O-Level Progressed-Post Secondary
|   Year | Race    |   % O-Level Progress Post-Secondary |
|-------:|:--------|------------------------------------:|
|   2008 | Overall |                                97.4 |
|   2009 | Overall |                                97.4 |
|   2010 | Overall |                                97.8 |
|   2011 | Overall |                                97.8 |
|   2012 | Overall |                                98   |
|   2013 | Overall |                                98.1 |
|   2014 | Overall |                                98.2 |
|   2015 | Overall |                                98.2 |
|   2016 | Overall |                                98.6 |
|   2017 | Overall |                                98.5 |


Table: Occupation Re-Entry Percentage
|   Year | Occupation                                             |   Re-Entry Percentage |
|-------:|:-------------------------------------------------------|----------------------:|
|   2010 | Professionals, Managers, Executives & Technicians      |                  67   |
|   2010 | Clerical, Sales & Service Workers                      |                  72.1 |
|   2010 | Production & Transport Operators, Cleaners & Labourers |                  64.2 |
|   2011 | Professionals, Managers, Executives & Technicians      |                  67.4 |
|   2011 | Clerical, Sales & Service Workers                      |                  67.3 |
|   2011 | Production & Transport Operators, Cleaners & Labourers |                  74.1 |
|   2012 | Professionals, Managers, Executives & Technicians      |                  65.5 |
|   2012 | Clerical, Sales & Service Workers                      |                  76.3 |
|   2012 | Production & Transport Operators, Cleaners & Labourers |                  79.6 |
|   2013 | Professionals, Managers, Executives & Technicians      |                  64.7 |


Table: onePA Community Courses
| Course & Level                             | Category   | Sub-Category          | Map Location                             | Community Centers           | Start Date              | Course Time        |   Start Price Range |   End Price Range |
|:-------------------------------------------|:-----------|:----------------------|:-----------------------------------------|:----------------------------|:------------------------|:-------------------|--------------------:|------------------:|
| TasteBuds: Taiwan with a Twist (Online)    | Culinary   | International Cuisine | C026904516By Tiong Bahru CC              | Tiong Bahru CC              | 2022-03-05 00:00:00.000 | 4:30 PM - 5:30 PM  |                   0 |                 0 |
| TasteBuds: Taiwan with a Twist (Online)    | Culinary   | International Cuisine | C026904516By Tiong Bahru CC              | Tiong Bahru CC              | 2022-03-05 00:00:00.000 | 4:30 PM - 5:30 PM  |                   0 |                 0 |
| Malay Cooking (Intermediate)               | Culinary   | Malay Cooking         | C026891198By Geylang Serai CC            | Geylang Serai CC            | 2022-02-12 00:00:00.000 | 2:00 PM - 5:00 PM  |                  32 |                 0 |
| Line Dance (Adult) - Elementary            | Dance      | Line Dance            | C026907998By Macpherson Zone B RC        | Macpherson Zone B RC        | 2022-02-08 00:00:00.000 | 8:00 PM - 9:30 PM  |                  15 |                 0 |
| Line Dance (Senior Citizen) - Intermediate | Dance      | Line Dance            | C026906976By Joo Seng (Geylang Serai) RC | Joo Seng (Geylang Serai) RC | 2022-03-03 00:00:00.000 | 8:00 PM - 9:30 PM  |                  35 |                 0 |
| Line Dance (Adult) - Elementary            | Dance      | Line Dance            | C026900954By Clementi Zone 3 RC          | Clementi Zone 3 RC          | 2022-02-10 00:00:00.000 | 7:00 PM - 8:30 PM  |                  36 |                 0 |
| Line Dance (Adult) - Elementary            | Dance      | Line Dance            | C026907651By Clementi Zone 3 RC          | Clementi Zone 3 RC          | 2022-02-10 00:00:00.000 | 8:30 PM - 10:00 PM |                  36 |                 0 |
| Line Dance (Adult) - Intermediate          | Dance      | Line Dance            | C026906878By Jurong Spring Zone C RC     | Jurong Spring Zone C RC     | 2022-02-15 00:00:00.000 | 7:30 PM - 9:00 PM  |                  40 |                 0 |
| Line Dance (Adult) - Intermediate          | Dance      | Line Dance            | C026908241By Clementi Meadows RN         | Clementi Meadows RN         | 2022-02-07 00:00:00.000 | 8:00 PM - 9:30 PM  |                  40 |                 0 |
| Line Dance (Adult) - Elementary            | Dance      | Line Dance            | C026910058By Yuhua Zone 4 RC             | Yuhua Zone 4 RC             | 2022-02-24 00:00:00.000 | 8:00 PM - 9:30 PM  |                  40 |                 0 |


Table: Person arrested for Crime
|   Year | Crime                                   | Age Groups             |   Value | Crimes       |   Total |
|-------:|:----------------------------------------|:-----------------------|--------:|:-------------|--------:|
|   2015 | Total Persons Arrested For Murder       | 21 Years Old And Below |       2 | Murder       |       2 |
|   2015 | Total Persons Arrested For Rape         | 21 Years Old And Below |      28 | Rape         |      51 |
|   2015 | Total Persons Arrested For Robbery      | 21 Years Old And Below |      38 | Robbery      |      66 |
|   2015 | Total Persons Arrested For Snatch Theft | 21 Years Old And Below |      11 | Snatch Theft |      19 |
|   2015 | Total Persons Arrested For Rioting      | 21 Years Old And Below |     220 | Rioting      |     392 |
|   2015 | Total Persons Arrested For Serious Hurt | 21 Years Old And Below |      54 | Serious Hurt |      89 |
|   2016 | Total Persons Arrested For Murder       | 21 Years Old And Below |       2 | Murder       |       2 |
|   2016 | Total Persons Arrested For Rape         | 21 Years Old And Below |      44 | Rape         |      83 |
|   2016 | Total Persons Arrested For Robbery      | 21 Years Old And Below |      23 | Robbery      |      38 |
|   2016 | Total Persons Arrested For Snatch Theft | 21 Years Old And Below |       9 | Snatch Theft |      14 |


Table: Polyclinic Wait Time
| Institution              |   Registration Wait Time |   Consultation Wait Time |   Postal Code | Country   | Location         |   Index |
|:-------------------------|-------------------------:|-------------------------:|--------------:|:----------|:-----------------|--------:|
| Ang Mo Kio Polyclinic    |                        5 |                       45 |        569666 | Singapore | Singapore,569666 |       0 |
| Bedok Polyclinic         |                       30 |                       53 |        469662 | Singapore | Singapore,469662 |       1 |
| Bukit Batok Polyclinic   |                        7 |                       59 |        659164 | Singapore | Singapore,659164 |       2 |
| Bukit Merah Polyclinic   |                        5 |                       52 |        150163 | Singapore | Singapore,150163 |       3 |
| Bukit Panjang Polyclinic |                        6 |                       65 |        677726 | Singapore | Singapore,677726 |       4 |
| Choa Chu Kang Polyclinic |                        9 |                       52 |        688846 | Singapore | Singapore,688846 |       5 |
| Clementi Polyclinic      |                        6 |                       38 |        120451 | Singapore | Singapore,120451 |       6 |
| Geylang Polyclinic       |                        3 |                       22 |        389707 | Singapore | Singapore,389707 |       7 |
| Hougang Polyclinic       |                        5 |                       33 |        538829 | Singapore | Singapore,538829 |       8 |
| Jurong Polyclinic        |                        8 |                       58 |        609788 | Singapore | Singapore,609788 |       9 |


Table: Population of MRT and Bus
| Name MRT                       |   Total MRT/LRT | Name Bus                   |   Total Buses |
|:-------------------------------|----------------:|:---------------------------|--------------:|
| Number of MRT and LRT Stations |             174 | Number of Bus Interchanges |            26 |


Table: Recreation Navigation
| Recreation Navi                       |
|:--------------------------------------|
| Place of Interest and Courses Offered |
| Sport Facilities                      |


Table: Ridership Population
|   Year |   Average number of passengers using public buses (in 1,000s) |
|-------:|--------------------------------------------------------------:|
|   2015 |                                                          3891 |
|   2016 |                                                          3939 |
|   2017 |                                                          3952 |
|   2018 |                                                          4037 |
|   2019 |                                                          4099 |
|   2020 |                                                          2878 |


Table: School & education Navigation
| School & Education Page     |
|:----------------------------|
| Subsidies                   |
| Extra Support               |
| Education Linear Regression |


Table: Secondary School with Specialised facilities support-Special Education
| Secondary School              | Hearing Loss   | Visual Impairment   | Barrier Free Facilities   | Learning & Behaviour Support   |
|:------------------------------|:---------------|:--------------------|:--------------------------|:-------------------------------|
| Anderson Sec Sch              | No             | No                  | No                        | Yes                            |
| Bowen Sec Sch                 | No             | No                  | No                        | Yes                            |
| Canberra Sec Sch              | No             | No                  | No                        | Yes                            |
| Catholic High Sch             | No             | No                  | No                        | Yes                            |
| CHIJ St. Joseph’s Convent     | No             | No                  | No                        | Yes                            |
| Christ Church Sec Sch         | No             | No                  | No                        | Yes                            |
| Chung Cheng High Sch (Yishun) | No             | No                  | No                        | Yes                            |
| Compassvale Sec Sch           | No             | No                  | No                        | Yes                            |
| Evergreen Sec Sch             | No             | No                  | No                        | Yes                            |
| Greendale Sec Sch             | No             | No                  | No                        | Yes                            |


Table: Security Nav
| Security Nav                  |
|:------------------------------|
| Security                      |
| Statistical Model on Security |


Table: Sports Facilities Rates
| Sports     | Venue                   |   Non-Peak |   Peak | Citizen Type           |   Hr per court / pitch / lane |
|:-----------|:------------------------|-----------:|-------:|:-----------------------|------------------------------:|
| Badminton  | Sport Center            |        3.5 |    7.4 | Singapore Citizen / PR |                             1 |
| Badminton  | Sport Center            |        4.6 |    9.7 | Standard               |                             1 |
| Badminton  | School Hall             |        0   |    7.4 | Singapore Citizen / PR |                             1 |
| Badminton  | School Hall             |        0   |    9.7 | Standard               |                             1 |
| Basketball | MOE Evans Outdoor Court |        0   |   11.6 | Singapore Citizen / PR |                             1 |
| Basketball | MOE Evans Outdoor Court |        0   |   15.1 | Standard               |                             1 |
| Basketball | MOE Evans Indoor Court  |        0   |   23.1 | Singapore Citizen / PR |                             1 |
| Basketball | MOE Evans Indoor Court  |        0   |   30.1 | Standard               |                             1 |
| Basketball | School Hall             |        0   |   30   | Singapore Citizen / PR |                             1 |
| Basketball | School Hall             |        0   |   39   | Standard               |                             1 |


Table: Student Health Screening Percentage
|   Year |   Students' Health Screening Percent |
|-------:|-------------------------------------:|
|   2006 |                                   99 |
|   2007 |                                   99 |
|   2008 |                                   98 |
|   2009 |                                   98 |
|   2010 |                                   99 |
|   2011 |                                   98 |
|   2012 |                                   99 |
|   2013 |                                   99 |
|   2014 |                                   99 |
|   2015 |                                   99 |


Table: Student Immunisation Percentage
|   Year |   Students' Immunisation Percentage |
|-------:|------------------------------------:|
|   2008 |                                  97 |
|   2009 |                                  98 |
|   2010 |                                  96 |
|   2011 |                                  96 |
|   2012 |                                  96 |
|   2013 |                                  99 |
|   2014 |                                  96 |
|   2015 |                                  99 |
|   2016 |                                  99 |
|   2017 |                                  99 |


Table: Students per Teacher-in- Secondary School
|   Year |   Students per Teacher |
|-------:|-----------------------:|
|   2008 |                   17.9 |
|   2009 |                   16.4 |
|   2010 |                   16.1 |
|   2011 |                   14.8 |
|   2012 |                   13.9 |
|   2013 |                   13.2 |
|   2014 |                   12.5 |
|   2015 |                   12.2 |
|   2016 |                   11.9 |
|   2017 |                   11.6 |


Table: Tourism Receipts
| Components                          | Year                    |   Cost in Millions |
|:------------------------------------|:------------------------|-------------------:|
| Sightseeing, Entertainment & Gaming | 2020-01-01 00:00:00.000 |                951 |
| Sightseeing, Entertainment & Gaming | 2019-01-01 00:00:00.000 |               5997 |
| Sightseeing, Entertainment & Gaming | 2018-01-01 00:00:00.000 |               5859 |
| Sightseeing, Entertainment & Gaming | 2017-01-01 00:00:00.000 |               5618 |
| Sightseeing, Entertainment & Gaming | 2016-01-01 00:00:00.000 |               5348 |
| Sightseeing, Entertainment & Gaming | 2015-01-01 00:00:00.000 |               5093 |
| Sightseeing, Entertainment & Gaming | 2014-01-01 00:00:00.000 |               5823 |
| Sightseeing, Entertainment & Gaming | 2013-01-01 00:00:00.000 |               5471 |


Table: Usage Of Sports Facilities
| Facilities   |   Year |   Number of People |
|:-------------|-------:|-------------------:|
| Badminton    |   2020 |             479889 |
| Badminton    |   2019 |             815257 |
| Badminton    |   2018 |             774341 |
| Badminton    |   2017 |             727432 |
| Badminton    |   2016 |             669217 |
| Badminton    |   2015 |             638485 |
| Badminton    |   2014 |             579431 |
| Badminton    |   2013 |             526660 |
| Badminton    |   2012 |             538381 |
| Tennis       |   2020 |             167999 |


Table: Vaccination and Immunisation of Students
|   Year | Vaccination Type      |   Doses in Thousands |
|-------:|:----------------------|---------------------:|
|   2009 | Diphtheria tetanus    |                 48.7 |
|   2009 | Poliomyelitis         |                 92.1 |
|   2009 | Measles mumps rubella |                 89.9 |
|   2010 | Diphtheria tetanus    |                 48.7 |
|   2010 | Poliomyelitis         |                 89.3 |
|   2010 | Measles mumps rubella |                 86.6 |
|   2011 | Diphtheria tetanus    |                 50.8 |
|   2011 | Poliomyelitis         |                 92   |
|   2011 | Measles mumps rubella |                 88.5 |
|   2012 | Diphtheria tetanus    |                 44.2 |


Table: Victims of Crime
|   Year | Crime                         | Age Groups             |   Value |   Total | Crimes       |
|-------:|:------------------------------|:-----------------------|--------:|--------:|:-------------|
|   2015 | Total Victims Of Murder       | 21 Years Old And Below |       1 |       1 | Murder       |
|   2015 | Total Victims Of Rape         | 21 Years Old And Below |     107 |     200 | Rape         |
|   2015 | Total Victims Of Robbery      | 21 Years Old And Below |      12 |      19 | Robbery      |
|   2015 | Total Victims Of Snatch Theft | 21 Years Old And Below |       8 |      16 | Snatch Theft |
|   2015 | Total Victims Of Rioting      | 21 Years Old And Below |      68 |     118 | Rioting      |
|   2015 | Total Victims Of Serious Hurt | 21 Years Old And Below |      73 |     119 | Serious Hurt |
|   2016 | Total Victims Of Murder       | 21 Years Old And Below |       1 |       1 | Murder       |
|   2016 | Total Victims Of Rape         | 21 Years Old And Below |     104 |     199 | Rape         |
|   2016 | Total Victims Of Robbery      | 21 Years Old And Below |      13 |      21 | Robbery      |
|   2016 | Total Victims Of Snatch Theft | 21 Years Old And Below |      10 |      17 | Snatch Theft |


Table: Visitor to Selected Places of Interest
| Place of Interest            | Year                    |   Number of People |
|:-----------------------------|:------------------------|-------------------:|
| Asian Civilisations Museum   | 2020-01-01 00:00:00.000 |              179.3 |
| Asian Civilisations Museum   | 2019-01-01 00:00:00.000 |              670.3 |
| Asian Civilisations Museum   | 2018-01-01 00:00:00.000 |              524.9 |
| Asian Civilisations Museum   | 2017-01-01 00:00:00.000 |              488.6 |
| Asian Civilisations Museum   | 2016-01-01 00:00:00.000 |              534.3 |
| Asian Civilisations Museum   | 2015-01-01 00:00:00.000 |              349.6 |
| Asian Civilisations Museum   | 2014-01-01 00:00:00.000 |              423.2 |
| Asian Civilisations Museum   | 2013-01-01 00:00:00.000 |              452.4 |
| National Museum Of Singapore | 2020-01-01 00:00:00.000 |              424.8 |
| National Museum Of Singapore | 2019-01-01 00:00:00.000 |             1099.3 |

 


tables: name: Bus Location
data: Bus Location.csv
name: Bus Population
data: Bus Population.csv
name: Consumer Goods Navigation
data: Consumer Goods Navigation.csv
name: Consumer-Price-Index-at-expenditure-division-level-2019 Annual
data: Consumer-Price-Index-at-expenditure-division-level-2019 Annual.csv
name: Crime Cases OTY
data: Crime Cases OTY.csv
name: Date
data: Date.csv
name: Date1
data: Date1.csv
name: Delays
data: Delays.csv
name: Dental Health Index
data: Dental Health Index.csv
name: Econ Nav
data: Econ Nav.csv
name: Economy Date Table
data: Economy Date Table.csv
name: Economy Low-Income Subsidies
data: Economy Low-Income Subsidies.csv
name: ED Attendances
data: ED Attendances.csv
name: Fares
data: Fares.csv
name: Food & Beverage Services Index-2017 Annual
data: Food & Beverage Services Index-2017 Annual.csv
name: Government Health Expenditure
data: Government Health Expenditure.csv
name: Government-Expenditure-on-Education
data: Government-Expenditure-on-Education.csv
name: Government-Recurrent-Expenditure-Education-on-Education-Type
data: Government-Recurrent-Expenditure-Education-on-Education-Type.csv
name: Healthcare Facilities
data: Healthcare Facilities.csv
name: Healthcare Graduates
data: Healthcare Graduates.csv
name: Healthcare Manpower
data: Healthcare Manpower.csv
name: Healthcare Pricings
data: Healthcare Pricings.csv
name: Healthcare Professionals to Population
data: Healthcare Professionals to Population.csv
name: Hospital Admissions Waiting Time
data: Hospital Admissions Waiting Time.csv
name: Household Healthcare Expenditure
data: Household Healthcare Expenditure.csv
name: Import Price Index Annual
data: Import Price Index Annual.csv
name: Interest Groups In Community Clubs And Residents' Committees
data: Interest Groups In Community Clubs And Residents' Committees.csv
name: Job Vacancies by Occupation
data: Job Vacancies by Occupation.csv
name: Licensed Food Establishments
data: Licensed Food Establishments.csv
name: list-of-supermarket-licences
data: list-of-supermarket-licences.csv
name: Local Price Index Annual
data: Local Price Index Annual.csv
name: Medifund Grants
data: Medifund Grants.csv
name: Monthly Household Income Percentage
data: Monthly Household Income Percentage.csv
name: MRT Location
data: MRT Location.csv
name: N-Level Progressed-Post Secondary
data: N-Level Progressed-Post Secondary.csv
name: Navigation (2)
data: Navigation (2).csv
name: Navigation
data: Navigation.csv
name: Number of Members In Community Clubs And Residents' Committees (2)
data: Number of Members In Community Clubs And Residents' Committees (2).csv
name: Number of Retrenchments by Occupation
data: Number of Retrenchments by Occupation.csv
name: O-Level Progressed-Post Secondary
data: O-Level Progressed-Post Secondary.csv
name: Occupation Re-Entry Percentage
data: Occupation Re-Entry Percentage.csv
name: onePA Community Courses
data: onePA Community Courses.csv
name: Person arrested for Crime
data: Person arrested for Crime.csv
name: Polyclinic Wait Time
data: Polyclinic Wait Time.csv
name: Population of MRT and Bus
data: Population of MRT and Bus.csv
name: Recreation Navigation
data: Recreation Navigation.csv
name: Ridership Population
data: Ridership Population.csv
name: School & education Navigation
data: School & education Navigation.csv
name: Secondary School with Specialised facilities support-Special Education
data: Secondary School with Specialised facilities support-Special Education.csv
name: Security Nav
data: Security Nav.csv
name: Sports Facilities Rates
data: Sports Facilities Rates.csv
name: Student Health Screening Percentage
data: Student Health Screening Percentage.csv
name: Student Immunisation Percentage
data: Student Immunisation Percentage.csv
name: Students per Teacher-in- Secondary School
data: Students per Teacher-in- Secondary School.csv
name: Tourism Receipts
data: Tourism Receipts.csv
name: Usage Of Sports Facilities
data: Usage Of Sports Facilities.csv
name: Vaccination and Immunisation of Students
data: Vaccination and Immunisation of Students.csv
name: Victims of Crime
data: Victims of Crime.csv
name: Visitor to Selected Places of Interest
data: Visitor to Selected Places of Interest.csv
label: Student Health Screening Percentage
Year
Medifund Grants
Year
Healthcare Professionals to Population
Year
Date1
Year
Date1
Year
Government Health Expenditure
Year
Student Immunisation Percentage
Year
Medifund Grants
Year
Dental Health Index
Year
Date1
Year
Vaccination and Immunisation of Students
Year
Medifund Grants
Year
Vaccination and Immunisation of Students
Year
Government Health Expenditure
Year
Government Health Expenditure
Year
Government-Expenditure-on-Education
Year
Healthcare Facilities
Year
Government-Expenditure-on-Education
Year
Licensed Food Establishments
Year
Government-Expenditure-on-Education
Year
Government-Recurrent-Expenditure-Education-on-Education-Type
Year
Government-Expenditure-on-Education
Year
Students per Teacher-in- Secondary School
Year
Government-Expenditure-on-Education
Year
Import Price Index Annual
Year
Government-Expenditure-on-Education
Year
Local Price Index Annual
Year
Government-Expenditure-on-Education
Year
Consumer-Price-Index-at-expenditure-division-level-2019 Annual
Year
Government-Expenditure-on-Education
Year
Bus Population
Year
Government-Expenditure-on-Education
Year
Delays
Year
Government-Expenditure-on-Education
Year
Victims of Crime
Year
Government-Expenditure-on-Education
Year
Person arrested for Crime
Year
Government-Expenditure-on-Education
Year
Ridership Population
Year
Government-Expenditure-on-Education
Year
ED Attendances
Day
Hospital Admissions Waiting Time
Day
Healthcare Facilities
Year
Healthcare Manpower
Year
Economy Date Table
Year
Economy Low-Income Subsidies
Year
Local Price Index Annual
Year
Date
Year
Import Price Index Annual
Year
Date
Year
N-Level Progressed-Post Secondary
Year
Students per Teacher-in- Secondary School
Year
O-Level Progressed-Post Secondary
Year
Students per Teacher-in- Secondary School
Year
Food & Beverage Services Index-2017 Annual
Year
Consumer-Price-Index-at-expenditure-division-level-2019 Annual
Year
Interest Groups In Community Clubs And Residents' Committees
Interest Group
Number of Members In Community Clubs And Residents' Committees (2)
Interest Group
Occupation Re-Entry Percentage
Year
Economy Date Table
Year
Number of Retrenchments by Occupation
Year
Economy Date Table
Year
Job Vacancies by Occupation
Year
Economy Date Table
Year
Monthly Household Income Percentage
Year
Economy Date Table
Year
Usage Of Sports Facilities
Facilities
Sports Facilities Rates
Sports
output: {
    "joins": [
        {
            "from_table": "Student Health Screening Percentage",
            "from_column": "Year",
            "to_table": "Medifund Grants",
            "to_column": "Year"
        },
        {
            "from_table": "Healthcare Professionals to Population",
            "from_column": "Year",
            "to_table": "Date1",
            "to_column": "Year"
        },
        {
            "from_table": "Date1",
            "from_column": "Year",
            "to_table": "Government Health Expenditure",
            "to_column": "Year"
        },
        {
            "from_table": "Student Immunisation Percentage",
            "from_column": "Year",
            "to_table": "Medifund Grants",
            "to_column": "Year"
        },
        {
            "from_table": "Dental Health Index",
            "from_column": "Year",
            "to_table": "Date1",
            "to_column": "Year"
        },
        {
            "from_table": "Vaccination and Immunisation of Students",
            "from_column": "Year",
            "to_table": "Medifund Grants",
            "to_column": "Year"
        },
        {
            "from_table": "Vaccination and Immunisation of Students",
            "from_column": "Year",
            "to_table": "Government Health Expenditure",
            "to_column": "Year"
        },
        {
            "from_table": "Government Health Expenditure",
            "from_column": "Year",
            "to_table": "Government-Expenditure-on-Education",
            "to_column": "Year"
        },
        {
            "from_table": "Healthcare Facilities",
            "from_column": "Year",
            "to_table": "Government-Expenditure-on-Education",
            "to_column": "Year"
        },
        {
            "from_table": "Licensed Food Establishments",
            "from_column": "Year",
            "to_table": "Government-Expenditure-on-Education",
            "to_column": "Year"
        },
        {
            "from_table": "Government-Recurrent-Expenditure-Education-on-Education-Type",
            "from_column": "Year",
            "to_table": "Government-Expenditure-on-Education",
            "to_column": "Year"
        },
        {
            "from_table": "Students per Teacher-in- Secondary School",
            "from_column": "Year",
            "to_table": "Government-Expenditure-on-Education",
            "to_column": "Year"
        },
        {
            "from_table": "Import Price Index Annual",
            "from_column": "Year",
            "to_table": "Government-Expenditure-on-Education",
            "to_column": "Year"
        },
        {
            "from_table": "Local Price Index Annual",
            "from_column": "Year",
            "to_table": "Government-Expenditure-on-Education",
            "to_column": "Year"
        },
        {
            "from_table": "Consumer-Price-Index-at-expenditure-division-level-2019 Annual",
            "from_column": "Year",
            "to_table": "Government-Expenditure-on-Education",
            "to_column": "Year"
        },
        {
            "from_table": "Bus Population",
            "from_column": "Year",
            "to_table": "Government-Expenditure-on-Education",
            "to_column": "Year"
        },
        {
            "from_table": "Delays",
            "from_column": "Year",
            "to_table": "Government-Expenditure-on-Education",
            "to_column": "Year"
        },
        {
            "from_table": "Victims of Crime",
            "from_column": "Year",
            "to_table": "Government-Expenditure-on-Education",
            "to_column": "Year"
        },
        {
            "from_table": "Person arrested for Crime",
            "from_column": "Year",
            "to_table": "Government-Expenditure-on-Education",
            "to_column": "Year"
        },
        {
            "from_table": "Ridership Population",
            "from_column": "Year",
            "to_table": "Government-Expenditure-on-Education",
            "to_column": "Year"
        },
        {
            "from_table": "ED Attendances",
            "from_column": "Day",
            "to_table": "Hospital Admissions Waiting Time",
            "to_column": "Day"
        },
        {
            "from_table": "Healthcare Facilities",
            "from_column": "Year",
            "to_table": "Healthcare Manpower",
            "to_column": "Year"
        },
        {
            "from_table": "Economy Date Table",
            "from_column": "Year",
            "to_table": "Economy Low-Income Subsidies",
            "to_column": "Year"
        },
        {
            "from_table": "Local Price Index Annual",
            "from_column": "Year",
            "to_table": "Date",
            "to_column": "Year"
        },
        {
            "from_table": "Import Price Index Annual",
            "from_column": "Year",
            "to_table": "Date",
            "to_column": "Year"
        },
        {
            "from_table": "N-Level Progressed-Post Secondary",
            "from_column": "Year",
            "to_table": "Students per Teacher-in- Secondary School",
            "to_column": "Year"
        },
        {
            "from_table": "O-Level Progressed-Post Secondary",
            "from_column": "Year",
            "to_table": "Students per Teacher-in- Secondary School",
            "to_column": "Year"
        },
        {
            "from_table": "Food & Beverage Services Index-2017 Annual",
            "from_column": "Year",
            "to_table": "Consumer-Price-Index-at-expenditure-division-level-2019 Annual",
            "to_column": "Year"
        },
        {
            "from_table": "Interest Groups In Community Clubs And Residents' Committees",
            "from_column": "Interest Group",
            "to_table": "Number of Members In Community Clubs And Residents' Committees (2)",
            "to_column": "Interest Group"
        },
        {
            "from_table": "Occupation Re-Entry Percentage",
            "from_column": "Year",
            "to_table": "Economy Date Table",
            "to_column": "Year"
        },
        {
            "from_table": "Number of Retrenchments by Occupation",
            "from_column": "Year",
            "to_table": "Economy Date Table",
            "to_column": "Year"
        },
        {
            "from_table": "Job Vacancies by Occupation",
            "from_column": "Year",
            "to_table": "Economy Date Table",
            "to_column": "Year"
        },
        {
            "from_table": "Monthly Household Income Percentage",
            "from_column": "Year",
            "to_table": "Economy Date Table",
            "to_column": "Year"
        },
        {
            "from_table": "Usage Of Sports Facilities",
            "from_column": "Facilities",
            "to_table": "Sports Facilities Rates",
            "to_column": "Sports"
        }
    ]
}