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: ASBOs Breached
|   Year of Breach | Age group breach 2   | Court_breach                                |   Sex |   ASBOs_breached |
|-----------------:|:---------------------|:--------------------------------------------|------:|-----------------:|
|             2013 | 18+                  | Derby Crown Court                           |     1 |                1 |
|             2013 | 18+                  | Nottingham Crown Court                      |     1 |                1 |
|             2013 | 18+                  | Harrow Crown Court                          |     1 |                1 |
|             2013 | 18+                  | South Cheshire Magistrates' Court           |     1 |                1 |
|             2013 | 18+                  | North Cheshire Magistrates' Court           |     1 |                1 |
|             2013 | 18+                  | Liverpool and Knowsley Magistrates' Court   |     1 |                1 |
|             2013 | 18+                  | Stockport Magistrates' Court                |     1 |                1 |
|             2013 | 18+                  | Hull and Holderness Magistrates' Court      |     1 |                1 |
|             2013 | 18+                  | Norfolk Magistrates' Court                  |     1 |                1 |
|             2013 | 18+                  | Wakefield and pontefract Magistrates' Court |     1 |                1 |


Table: ASBOs Issued
|   Year of Issue | Court                                    | Sex   | Asbo on application or conviction   | Age_Group   |   ASBOs issued |
|----------------:|:-----------------------------------------|:------|:------------------------------------|:------------|---------------:|
|            2003 | Ashford and Tenterden Magistrates' Court | Male  | Conviction                          | 18+         |              1 |
|            2003 | Aylesbury Crown Court                    | Male  | Conviction                          | 18+         |              1 |
|            2003 | Barnet Magistrates' Court                | Male  | Conviction                          | 18+         |              1 |
|            2003 | Basildon Magistrates' Court              | Male  | Conviction                          | 18+         |              1 |
|            2003 | Batley and Dewsbury Magistrates' Court   | Male  | Conviction                          | 18+         |              1 |
|            2003 | Bexley Magistrates' Court                | Male  | Conviction                          | 18+         |              1 |
|            2003 | Bolton Crown Court                       | Male  | Conviction                          | 18+         |              1 |
|            2003 | Brent Magistrates' Court                 | Male  | Conviction                          | 18+         |              1 |
|            2003 | Carlisle Crown Court                     | Male  | Conviction                          | 18+         |              1 |
|            2003 | Claro Magistrates' Court                 | Male  | Conviction                          | 18+         |              1 |


Table: LatLong Coordinates
| original coordinate   | ETRS89 Geodetic ( Degrees, Minutes, Seconds )   | ETRS89 Geodetic ( Degrees, Decimal Minutes )   |     Lat |     Long |   ETRS89 Geodetic ( Decimal Degrees ).3 | ETRS89 XYZ                               | National Grid Eastings and Northings   | National Grid KM Square   |
|:----------------------|:------------------------------------------------|:-----------------------------------------------|--------:|---------:|----------------------------------------:|:-----------------------------------------|:---------------------------------------|:--------------------------|
| 430226 433202         | 53, 47, 39.380176, W, 1, 32, 33.505856, 49.2696 | 53, 47.656336, W, 1, 32.558431, 49.2696        | 53.7943 | -1.54264 |                                 49.2696 | 3774376.4959, -101646.4649, 5123291.1743 | 430226 433202 0 1                      | SE3033                    |
| 430330 433321         | 53, 47, 43.208789, W, 1, 32, 27.780352, 49.2644 | 53, 47.720146, W, 1, 32.463006, 49.2644        | 53.7953 | -1.54105 |                                 49.2644 | 3774283.8338, -101539.1269, 5123361.0889 | 430330 433321 0 1                      | SE3033                    |
| 430324 433288         | 53, 47, 42.142307, W, 1, 32, 28.119895, 49.2647 | 53, 47.702372, W, 1, 32.468665, 49.2647        | 53.795  | -1.54114 |                                 49.2647 | 3774310.2632, -101546.0555, 5123341.613  | 430324 433288 0 1                      | SE3033                    |
| 430433 433982         | 53, 48, 4.574269, W, 1, 32, 21.917312, 49.2597  | 53, 48.076238, W, 1, 32.365289, 49.2597        | 53.8013 | -1.53942 |                                 49.2597 | 3773753.8725, -101417.5236, 5123751.2325 | 430433 433982 0 1                      | SE3033                    |
| 430385 433607         | 53, 47, 52.450985, W, 1, 32, 24.673481, 49.2618 | 53, 47.874183, W, 1, 32.411225, 49.2618        | 53.7979 | -1.54019 |                                 49.2618 | 3774054.8711, -101476.0792, 5123529.8619 | 430385 433607 0 1                      | SE3033                    |
| 430891 433408         | 53, 47, 45.905319, W, 1, 31, 57.090086, 49.2364 | 53, 47.765089, W, 1, 31.951501, 49.2364        | 53.7961 | -1.53253 |                                 49.2364 | 3774231.6356, -100975.7482, 5123410.3097 | 430891 433408 0 1                      | SE3033                    |
| 430306 433396         | 53, 47, 45.640478, W, 1, 32, 29.065532, 49.2656 | 53, 47.760675, W, 1, 32.484426, 49.2656        | 53.796  | -1.54141 |                                 49.2656 | 3774222.5589, -101561.0116, 5123405.4969 | 430306 433396 0 1                      | SE3033                    |
| 430375 433505         | 53, 47, 49.152807, W, 1, 32, 25.256062, 49.2622 | 53, 47.819213, W, 1, 32.420934, 49.2622        | 53.797  | -1.54035 |                                 49.2622 | 3774136.8386, -101488.9506, 5123469.6342 | 430375 433505 0 1                      | SE3033                    |
| 430530 433708         | 53, 47, 55.688443, W, 1, 32, 16.712773, 49.2547 | 53, 47.928141, W, 1, 32.278546, 49.2547        | 53.7988 | -1.53798 |                                 49.2547 | 3773978.04, -101328.253, 5123588.9742    | 430530 433708 0 1                      | SE3033                    |
| 430383 433728         | 53, 47, 56.366433, W, 1, 32, 24.74002, 49.262   | 53, 47.939441, W, 1, 32.412334, 49.262         | 53.799  | -1.54021 |                                 49.262  | 3773957.1892, -101474.6711, 5123601.3604 | 430383 433728 0 1                      | SE3033                    |


Table: Outcomes
| Source.Name                       | Crime ID                                                         | Month   | Reported by                 | Falls within                |   Longitude |   Latitude | Location               | LSOA code   | LSOA name        | Outcome type                                  |
|:----------------------------------|:-----------------------------------------------------------------|:--------|:----------------------------|:----------------------------|------------:|-----------:|:-----------------------|:------------|:-----------------|:----------------------------------------------|
| 2016-11-metropolitan-outcomes.csv | 57ef8b6f4cce1e1590a909e9c33e7d715dfd2f2b346d8f43959e3746164eb695 | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.131588 |    51.5165 | On or near Supermarket | E01004763   | Westminster 013B | Investigation complete; no suspect identified |
| 2016-11-metropolitan-outcomes.csv | 7c58e5aae729b2e8315892b6eeaae2b4017e6b6fb6bbcbdca06df64cf6cfe6c6 | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.131588 |    51.5165 | On or near Supermarket | E01004763   | Westminster 013B | Investigation complete; no suspect identified |
| 2016-11-metropolitan-outcomes.csv | 283bf0cd2f2717995d2862dc0680a0701a8862443558af41e2f9978b313a4d16 | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.165877 |    51.5176 | On or near Supermarket | E01004658   | Westminster 012B | Investigation complete; no suspect identified |
| 2016-11-metropolitan-outcomes.csv | c2e0e48493c6c2b2ab13d8f091b81b82d4d23e393e0f9ef6795d2e1eadd8cfe6 | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.131247 |    51.6343 | On or near Supermarket | E01001519   | Enfield 020D     | Investigation complete; no suspect identified |
| 2016-11-metropolitan-outcomes.csv | eb1d1f06adfc639b389c6b47684784ee9e9c1d1bf5bc1d93e8eb1cb2afee8117 | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.057577 |    51.6475 | On or near Supermarket | E01001511   | Enfield 016D     | Investigation complete; no suspect identified |
| 2016-11-metropolitan-outcomes.csv | 63d4f54d15c4137a95c7bb9873491c386eb3d4e03e11d263fbd771cef80376a1 | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.046807 |    51.6573 | On or near Supermarket | E01001439   | Enfield 006A     | Investigation complete; no suspect identified |
| 2016-11-metropolitan-outcomes.csv | 62040fc31495636e1882c8fbd00807b592e25311e8e6559281dc3e152e8ce491 | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.04855  |    51.61   | On or near Supermarket | E01001559   | Enfield 033F     | Investigation complete; no suspect identified |
| 2016-11-metropolitan-outcomes.csv | e724f48c6ffc56392f0bf8af05d8836cf0b3346d1c6cf6756941a792f053f141 | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.04855  |    51.61   | On or near Supermarket | E01001559   | Enfield 033F     | Investigation complete; no suspect identified |
| 2016-11-metropolitan-outcomes.csv | ea5a55e2dec25688c8ac92b70c08214503354632cb1190c87719c418cf997a40 | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.04855  |    51.61   | On or near Supermarket | E01001559   | Enfield 033F     | Investigation complete; no suspect identified |
| 2016-11-metropolitan-outcomes.csv | 96f0fa48a2b51d54bd954df5063544a1219cf02ac0730be9a6fbefb7ee29644e | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.08181  |    51.6638 | On or near Supermarket | E01001411   | Enfield 004B     | Investigation complete; no suspect identified |


Table: Road Collision Attendants In Camden
| Reference   | London Borough Name   | Attendant Location                      | Severity   |   Number Of Casualties |   Number Of Vehicles | Date                    | Day       |   Time | Highway   | Road Class 1   |   Road Number 1 | Road Type    | Speed Limit   | Junction Detail   | Junction Control        | Road Class 2   |   Road Number 2 | Pedestrian Crossing       | Light Condition Band   | Weather   | Road Surface   | Special Conditions   | Carriage Way Hazard   |   Easting |   Northing |   Longitude |   Latitude | Ward Code   | Ward Name                      | Spatial Accuracy   | Location               |   Socrata ID | Last Uploaded           | Organisation URI                                                |
|:------------|:----------------------|:----------------------------------------|:-----------|-----------------------:|---------------------:|:------------------------|:----------|-------:|:----------|:---------------|----------------:|:-------------|:--------------|:------------------|:------------------------|:---------------|----------------:|:--------------------------|:-----------------------|:----------|:---------------|:---------------------|:----------------------|----------:|-----------:|------------:|-----------:|:------------|:-------------------------------|:-------------------|:-----------------------|-------------:|:------------------------|:----------------------------------------------------------------|
| 0105EO40315 | CAMDEN                | HAMPSTEAD ROAD J/W ROBERT STREET        | 3 Slight   |                      1 |                    2 | 2005-05-11 17:20:00.000 | Wednesday |  17.2  | 1 TLRN    | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    529210 |     182710 |   -0.138749 |    51.5285 | E05000142   | Regent's Park                  | Unknown            | (51.528536, -0.138749) |        34332 | 2016-11-04 10:29:06.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO40503 | CAMDEN                | KENTISH TOWN ROAD J/W CAMDEN GARDENS    | 3 Slight   |                      1 |                    2 | 2005-06-06 18:35:00.000 | Monday    |  18.35 | 3 Bor     | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    528940 |     184190 |   -0.142097 |    51.5419 | E05000130   | Camden Town with Primrose Hill | Unknown            | (51.541898, -0.142097) |        34248 | 2016-11-04 10:29:06.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO40585 | CAMDEN                | KENTISH TOWN ROAD J/W LEVERTON PLACE    | 3 Slight   |                      1 |                    2 | 2005-06-21 07:20:00.000 | Tuesday   |   7.2  | 3 Bor     | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    529000 |     185230 |   -0.140852 |    51.5512 | E05000139   | Kentish Town                   | Unknown            | (51.551231, -0.140852) |        34209 | 2016-11-04 10:29:06.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO40696 | CAMDEN                | HOLLOWAY RD J/W HAWLEY CRESCENT         | 3 Slight   |                      1 |                    2 | 2005-07-19 09:02:00.000 | Tuesday   |   9.02 | 3 Bor     | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    528940 |     184090 |   -0.142134 |    51.541  | E05000130   | Camden Town with Primrose Hill | Unknown            | (51.541, -0.142134)    |        34152 | 2016-11-04 10:29:06.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO40910 | CAMDEN                | HAMPSTEAD ROAD J/W WILLIAM ROAD         | 3 Slight   |                      1 |                    2 | 2005-08-15 16:20:00.000 | Monday    |  16.2  | 1 TLRN    | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    529210 |     182570 |   -0.1388   |    51.5273 | E05000142   | Regent's Park                  | Unknown            | (51.527278, -0.1388)   |        34042 | 2016-11-04 10:29:05.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO41051 | CAMDEN                | NFL  KENTISH TOWN ROAD J/W ISLIP STREET | 3 Slight   |                      1 |                    2 | 2005-09-26 08:40:00.000 | Monday    |   8.4  | 3 Bor     | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    529000 |     185040 |   -0.140921 |    51.5495 | E05000139   | Kentish Town                   | Unknown            | (51.549523, -0.140921) |        33976 | 2016-11-04 10:29:05.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO41334 | CAMDEN                | HAMPSTEAD RD J/W NETLEY ST              | 3 Slight   |                      1 |                    2 | 2005-12-10 12:40:00.000 | Saturday  |  12.4  | 1 TLRN    | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    529210 |     182620 |   -0.138782 |    51.5277 | E05000142   | Regent's Park                  | Unknown            | (51.527728, -0.138782) |        33842 | 2016-11-04 10:29:05.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105TA00228 | CAMDEN                | HAMPSTEAD ROAD J/W ROBERT STREET        | 3 Slight   |                      1 |                    2 | 2005-10-06 19:10:00.000 | Thursday  |  19.1  | 1 TLRN    | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    529210 |     182710 |   -0.138749 |    51.5285 | E05000142   | Regent's Park                  | Unknown            | (51.528536, -0.138749) |        33688 | 2016-11-04 10:29:05.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0107EO40468 | CAMDEN                | HAMPSTEAD ROAD J/W ROBERT STREET        | 3 Slight   |                      1 |                    2 | 2007-08-09 18:50:00.000 | Thursday  |  18.5  | 1 TLRN    | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    529210 |     182710 |   -0.138749 |    51.5285 | E05000142   | Regent's Park                  | Unknown            | (51.528536, -0.138749) |        32430 | 2016-11-04 10:29:04.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0107EO40546 | CAMDEN                | FORTESS RD J/W FALKLAND RD              | 3 Slight   |                      1 |                    2 | 2007-09-05 07:40:00.000 | Wednesday |   7.4  | 3 Bor     | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    528980 |     185330 |   -0.141103 |    51.5521 | E05000139   | Kentish Town                   | Unknown            | (51.552134, -0.141103) |        32397 | 2016-11-04 10:29:04.000 | http://opendatacommunities.org/id/london-borough-council/camden |


Table: Road Collision Casualties In Camden
| Reference   | London Borough Name   | Casualty Class   | Casualty Sex   | Casualty Age Band   |   Casualty Age |   Number Of Casualties | Casualty Severity   | Pedestrian Location   | Pedestrian Movement   | Mode Of Travel   | Attendant Location                        |   Number Of Vehicles | Date                    | Day       |   Time | Highway   | Road Class 1   |   Road Number 1 | Road Type    | Speed Limit   | Junction Detail   | Junction Control        | Road Class 2   |   Road Number 2 | Pedestrian Crossing       | Light Condition Band   | Weather   | Road Surface   | Special Conditions   | Carriage Way Hazard   |   Easting |   Northing |   Longitude |   Latitude | Ward Code   | Ward Name                      | Spatial Accuracy   | Location               | Organisation URI                                                |   Socrata ID | Last Uploaded           |
|:------------|:----------------------|:-----------------|:---------------|:--------------------|---------------:|-----------------------:|:--------------------|:----------------------|:----------------------|:-----------------|:------------------------------------------|---------------------:|:------------------------|:----------|-------:|:----------|:---------------|----------------:|:-------------|:--------------|:------------------|:------------------------|:---------------|----------------:|:--------------------------|:-----------------------|:----------|:---------------|:---------------------|:----------------------|----------:|-----------:|------------:|-----------:|:------------|:-------------------------------|:-------------------|:-----------------------|:----------------------------------------------------------------|-------------:|:------------------------|
| 0105EO40009 | CAMDEN                | 1 Driver/Rider   | 2 Female       | 25-59               |             29 |                      1 | 3 Slight            | -2 Unknown            | -2 N/A                | 2 Pedal Cycle    | FIMCHLEY ROAD J/W STUDHOLME COURT         |                    2 | 2005-02-07 08:39:00.000 | Monday    |   8.39 | 1 TLRN    | A              |              41 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    525430 |     185540 |   -0.192203 |    51.5548 | E05000132   | Fortune Green                  | Unknown            | (51.554821, -0.192203) | http://opendatacommunities.org/id/london-borough-council/camden |        25331 | 2016-11-04 10:28:59.000 |
| 0105EO40297 | CAMDEN                | 1 Driver/Rider   | 1 Male         | 25-59               |             33 |                      1 | 3 Slight            | -2 Unknown            | -2 N/A                | 2 Pedal Cycle    | EVERSHOLT STREET J/W POLYGON ROAD         |                    2 | 2005-04-21 08:43:00.000 | Thursday  |   8.43 | 3 Bor     | A              |            4200 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    529480 |     182970 |   -0.134763 |    51.5308 | E05000142   | Regent's Park                  | Unknown            | (51.530811, -0.134763) | http://opendatacommunities.org/id/london-borough-council/camden |        25219 | 2016-11-04 10:28:59.000 |
| 0105EO40315 | CAMDEN                | 1 Driver/Rider   | 1 Male         | 25-59               |             37 |                      1 | 3 Slight            | -2 Unknown            | -2 N/A                | 2 Pedal Cycle    | HAMPSTEAD ROAD J/W ROBERT STREET          |                    2 | 2005-05-11 17:20:00.000 | Wednesday |  17.2  | 1 TLRN    | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    529210 |     182710 |   -0.138749 |    51.5285 | E05000142   | Regent's Park                  | Unknown            | (51.528536, -0.138749) | http://opendatacommunities.org/id/london-borough-council/camden |        25206 | 2016-11-04 10:28:59.000 |
| 0105EO40696 | CAMDEN                | 1 Driver/Rider   | 2 Female       | 25-59               |             28 |                      1 | 3 Slight            | -2 Unknown            | -2 N/A                | 2 Pedal Cycle    | HOLLOWAY RD J/W HAWLEY CRESCENT           |                    2 | 2005-07-19 09:02:00.000 | Tuesday   |   9.02 | 3 Bor     | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    528940 |     184090 |   -0.142134 |    51.541  | E05000130   | Camden Town with Primrose Hill | Unknown            | (51.541, -0.142134)    | http://opendatacommunities.org/id/london-borough-council/camden |        25012 | 2016-11-04 10:28:59.000 |
| 0105EO40863 | CAMDEN                | 1 Driver/Rider   | 1 Male         | 25-59               |             26 |                      1 | 3 Slight            | -2 Unknown            | -2 N/A                | 2 Pedal Cycle    | KILBURN HIGH ROAD J/W KINGSGATE PLACE     |                    2 | 2005-08-14 15:10:00.000 | Sunday    |  15.1  | 3 Bor     | A              |               5 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    525100 |     184030 |   -0.197497 |    51.5413 |             |                                | Unknown            | (51.541324, -0.197497) | http://opendatacommunities.org/id/london-borough-council/camden |        24922 | 2016-11-04 10:28:59.000 |
| 0105EO40910 | CAMDEN                | 1 Driver/Rider   | 1 Male         | 25-59               |             32 |                      1 | 3 Slight            | -2 Unknown            | -2 N/A                | 2 Pedal Cycle    | HAMPSTEAD ROAD J/W WILLIAM ROAD           |                    2 | 2005-08-15 16:20:00.000 | Monday    |  16.2  | 1 TLRN    | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    529210 |     182570 |   -0.1388   |    51.5273 | E05000142   | Regent's Park                  | Unknown            | (51.527278, -0.1388)   | http://opendatacommunities.org/id/london-borough-council/camden |        24896 | 2016-11-04 10:28:59.000 |
| 0105EO41074 | CAMDEN                | 1 Driver/Rider   | 1 Male         | 25-59               |             32 |                      1 | 3 Slight            | -2 Unknown            | -2 N/A                | 2 Pedal Cycle    | FORTESS RD J/W FORTESS GROVE              |                    2 | 2005-10-03 09:00:00.000 | Monday    |   9    | 3 Bor     | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    528980 |     185420 |   -0.141071 |    51.5529 | E05000139   | Kentish Town                   | Unknown            | (51.552943, -0.141071) | http://opendatacommunities.org/id/london-borough-council/camden |        24805 | 2016-11-04 10:28:59.000 |
| 0105EO41091 | CAMDEN                | 1 Driver/Rider   | 1 Male         | 25-59               |             28 |                      1 | 3 Slight            | -2 Unknown            | -2 N/A                | 2 Pedal Cycle    | NORTH END ROAD J/W  SANDY ROAD            |                    2 | 2005-09-25 08:20:00.000 | Sunday    |   8.2  | 3 Bor     | A              |             502 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    526030 |     186960 |   -0.183045 |    51.5674 | E05000135   | Hampstead Town                 | Unknown            | (51.567449, -0.183045) | http://opendatacommunities.org/id/london-borough-council/camden |        24796 | 2016-11-04 10:28:59.000 |
| 0107EO40168 | CAMDEN                | 1 Driver/Rider   | 1 Male         | 25-59               |             43 |                      1 | 3 Slight            | -2 Unknown            | -2 N/A                | 2 Pedal Cycle    | THEOBALD'S ROAD J/W OLD GLOUCESTER STREET |                    2 | 2007-02-26 10:55:00.000 | Monday    |  10.55 | 3 Bor     | A              |             401 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    530490 |     181710 |   -0.120677 |    51.5193 | E05000138   | Holborn and Covent Garden      | Unknown            | (51.519256, -0.120677) | http://opendatacommunities.org/id/london-borough-council/camden |        23034 | 2016-11-04 10:28:58.000 |
| 0107EO40468 | CAMDEN                | 1 Driver/Rider   | 1 Male         | 25-59               |             40 |                      1 | 3 Slight            | -2 Unknown            | -2 N/A                | 2 Pedal Cycle    | HAMPSTEAD ROAD J/W ROBERT STREET          |                    2 | 2007-08-09 18:50:00.000 | Thursday  |  18.5  | 1 TLRN    | A              |             400 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    529210 |     182710 |   -0.138749 |    51.5285 | E05000142   | Regent's Park                  | Unknown            | (51.528536, -0.138749) | http://opendatacommunities.org/id/london-borough-council/camden |        23551 | 2016-11-04 10:28:58.000 |


Table: Road Collision Vehicles In Camden
| Reference   | London Borough Name   | Severity   |   Vehicle Reference | Vehicle Type     | Vehicle Type Banded   | Vehicle Manoeuvres   | Vehicle Skidding       | Restricted Lane          | Junction Location   | Object In Carriage Way   | Vehicle Leaving Carriage Way   | Vehicle Off Carriage Way   | Vehicle Impact    | Driver Sex   |   Driver Age | Driver Age Band   | Attendant Location                    |   Number Of Casualties | Date                    | Day       |   Time | Highway   | Road Class 1   |   Road Number 1 | Road Type    | Speed Limit   | Junction Detail   | Junction Control        | Road Class 2   |   Road Number 2 | Pedestrian Crossing       | Light Condition Band   | Weather   | Road Surface   | Special Conditions   | Carriage Way Hazard   |   Easting |   Northing |   Longitude |   Latitude | Ward Code   | Ward Name                 | Spatial Accuracy   | Location               |   Socrata ID | Last Uploaded           | Organisation URI                                                |
|:------------|:----------------------|:-----------|--------------------:|:-----------------|:----------------------|:---------------------|:-----------------------|:-------------------------|:--------------------|:-------------------------|:-------------------------------|:---------------------------|:------------------|:-------------|-------------:|:------------------|:--------------------------------------|-----------------------:|:------------------------|:----------|-------:|:----------|:---------------|----------------:|:-------------|:--------------|:------------------|:------------------------|:---------------|----------------:|:--------------------------|:-----------------------|:----------|:---------------|:---------------------|:----------------------|----------:|-----------:|------------:|-----------:|:------------|:--------------------------|:-------------------|:-----------------------|-------------:|:------------------------|:----------------------------------------------------------------|
| 0105CW11230 | CAMDEN                | 3 Slight   |                   1 | 09 Car           | 3 Car                 | 18 Going Ahead Other | 0 No Skidding/Overturn | 0 On Main Cw - Not Rest. | 8 Jct Mid           | 00 None                  | 0 Did Not Leave                | 00 None                    | 1 Front Hit First | 2 Female     |           33 | 25-34             | OUTER CIRCLE J/W CHESTER ROAD         |                      1 | 2005-08-21 16:40:00.000 | Sunday    |  16.4  | 3 Bor     | Unclassified   |               0 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    528710 |     182740 |   -0.145942 |    51.5289 | E05000142   | Regent's Park             | Unknown            | (51.52892, -0.145942)  |        15205 | 2016-11-04 10:28:52.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO00041 | CAMDEN                | 3 Slight   |                   1 | 03 M/C 50-125cc  | 2 Powered 2 wheeler   | 18 Going Ahead Other | 0 No Skidding/Overturn | 0 On Main Cw - Not Rest. | 8 Jct Mid           | 00 None                  | 0 Did Not Leave                | 00 None                    | 1 Front Hit First | 1 Male       |           31 | 25-34             | HAVERSTOCK HILL J/W STEELE'S ROAD     |                      1 | 2005-01-12 20:58:00.000 | Wednesday |  20.58 | 3 Bor     | A              |             502 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 2 Dark                 | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    527810 |     184680 |   -0.158205 |    51.5466 | E05000136   | Haverstock                | Unknown            | (51.546559, -0.158205) |        15126 | 2016-11-04 10:28:52.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO00054 | CAMDEN                | 3 Slight   |                   1 | 04 M/C 125-500cc | 2 Powered 2 wheeler   | 18 Going Ahead Other | 0 No Skidding/Overturn | 0 On Main Cw - Not Rest. | 8 Jct Mid           | 00 None                  | 0 Did Not Leave                | 00 None                    | 1 Front Hit First | 1 Male       |           41 | 35-64             | HIGHGATE ROAD J/W ST ALBAN'S ROAD     |                      1 | 2005-01-20 19:27:00.000 | Thursday  |  19.27 | 3 Bor     | C              |               0 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 2 Dark                 | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    528310 |     186280 |   -0.150415 |    51.5608 | E05000137   | Highgate                  | Unknown            | (51.560824, -0.150415) |        15117 | 2016-11-04 10:28:52.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO00082 | CAMDEN                | 3 Slight   |                   1 | 02 M/C <= 50cc   | 2 Powered 2 wheeler   | 18 Going Ahead Other | 0 No Skidding/Overturn | 0 On Main Cw - Not Rest. | 8 Jct Mid           | 00 None                  | 0 Did Not Leave                | 00 None                    | 1 Front Hit First | 1 Male       |           35 | 35-64             | HAVERSTOCK HILL J/W UPPER PARK ROAD   |                      1 | 2005-01-17 10:40:00.000 | Monday    |  10.4  | 3 Bor     | A              |             502 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 2 Road-Wet     | 0 None               | 0 None                |    527510 |     184940 |   -0.162435 |    51.549  | E05000128   | Belsize                   | Unknown            | (51.548963, -0.162435) |        15097 | 2016-11-04 10:28:52.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO00131 | CAMDEN                | 3 Slight   |                   2 | 03 M/C 50-125cc  | 2 Powered 2 wheeler   | 18 Going Ahead Other | 0 No Skidding/Overturn | 0 On Main Cw - Not Rest. | 8 Jct Mid           | 00 None                  | 0 Did Not Leave                | 00 None                    | 1 Front Hit First | 1 Male       |           34 | 25-34             | HIGHGATE ROAD J/W GROVE TERRACE MEWS  |                      1 | 2005-01-25 08:45:00.000 | Tuesday   |   8.45 | 3 Bor     | C              |               0 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    528450 |     186020 |   -0.148492 |    51.5585 | E05000137   | Highgate                  | Unknown            | (51.558456, -0.148492) |        15053 | 2016-11-04 10:28:52.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO00133 | CAMDEN                | 3 Slight   |                   2 | 04 M/C 125-500cc | 2 Powered 2 wheeler   | 18 Going Ahead Other | 0 No Skidding/Overturn | 0 On Main Cw - Not Rest. | 8 Jct Mid           | 00 None                  | 0 Did Not Leave                | 00 None                    | 1 Front Hit First | 1 Male       |           32 | 25-34             | THEOBALDS ROAD J/W NEW NORTH STREET   |                      1 | 2005-01-25 11:20:00.000 | Tuesday   |  11.2  | 3 Bor     | A              |             401 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    530570 |     181780 |   -0.119499 |    51.5199 | E05000138   | Holborn and Covent Garden | Unknown            | (51.519866, -0.119499) |        15051 | 2016-11-04 10:28:52.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO40005 | CAMDEN                | 3 Slight   |                   3 | 09 Car           | 3 Car                 | 18 Going Ahead Other | 0 No Skidding/Overturn | 0 On Main Cw - Not Rest. | 8 Jct Mid           | 00 None                  | 0 Did Not Leave                | 00 None                    | 1 Front Hit First | 1 Male       |           35 | 35-64             | LEIGHTON ROAD J/W LEVERTON STREET     |                      1 | 2005-02-05 15:30:00.000 | Saturday  |  15.3  | 3 Bor     | C              |               0 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    529060 |     185190 |   -0.140002 |    51.5509 | E05000139   | Kentish Town              | Unknown            | (51.550858, -0.140002) |        15011 | 2016-11-04 10:28:52.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO40102 | CAMDEN                | 3 Slight   |                   2 | 02 M/C <= 50cc   | 2 Powered 2 wheeler   | 18 Going Ahead Other | 0 No Skidding/Overturn | 0 On Main Cw - Not Rest. | 8 Jct Mid           | 00 None                  | 0 Did Not Leave                | 00 None                    | 1 Front Hit First | 1 Male       |           24 | 17-24             | AVENUE ROAD J/W ELSWORTHY ROAD        |                      1 | 2005-02-15 21:46:00.000 | Tuesday   |  21.46 | 3 Bor     | B              |             525 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 2 Dark                 | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    526960 |     183840 |   -0.170759 |    51.5392 | E05000144   | Swiss Cottage             | Unknown            | (51.539201, -0.170759) |        14963 | 2016-11-04 10:28:52.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO40160 | CAMDEN                | 3 Slight   |                   2 | 01 Pedal Cycle   | 1 Pedal cycle         | 18 Going Ahead Other | 0 No Skidding/Overturn | 0 On Main Cw - Not Rest. | 8 Jct Mid           | 00 None                  | 0 Did Not Leave                | 00 None                    | 1 Front Hit First | 1 Male       |           24 | 17-24             | CLERKENWELL ROAD J/W EYRE STREET HILL |                      1 | 2005-03-08 13:34:00.000 | Tuesday   |  13.34 | 3 Bor     | A              |            5201 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    531200 |     182040 |   -0.110328 |    51.5221 | E05000138   | Holborn and Covent Garden | Unknown            | (51.522057, -0.110328) |        14929 | 2016-11-04 10:28:52.000 | http://opendatacommunities.org/id/london-borough-council/camden |
| 0105EO40280 | CAMDEN                | 3 Slight   |                   2 | 19 Gds =< 3.5t   | 7 Goods vehicles      | 18 Going Ahead Other | 0 No Skidding/Overturn | 0 On Main Cw - Not Rest. | 8 Jct Mid           | 00 None                  | 0 Did Not Leave                | 00 None                    | 1 Front Hit First | 1 Male       |           28 | 25-34             | MILL LANE J/W BROOMSLEIGH STREET      |                      1 | 2005-04-28 11:02:00.000 | Thursday  |  11.02 | 3 Bor     | C              |               0 | 6 Single Cwy | 2 30 MPH      | 3 T/Stag Jun      | 4 Give Way/Uncontrolled | Unclassified   |               0 | 0 No Xing Facility In 50m | 1 Daylight             | 1 Fine    | 1 Road-Dry     | 0 None               | 0 None                |    524960 |     185160 |   -0.199114 |    51.5515 | E05000132   | Fortune Green             | Unknown            | (51.55151, -0.199114)  |        14850 | 2016-11-04 10:28:52.000 | http://opendatacommunities.org/id/london-borough-council/camden |


Table: Road Traffic Accidents
| Reference Number   |   Easting |   Northing |   Number of Vehicles | Accident Date           |   Time (24hr) | 1st Road Class   | Road Surface   | Lighting Conditions             | Weather Conditions      | Casualty Class   | Casualty Severity   | Sex of Casualty   |   Age of Casualty | Type of Vehicle   | Coord Lookup   |
|:-------------------|----------:|-----------:|---------------------:|:------------------------|--------------:|:-----------------|:---------------|:--------------------------------|:------------------------|:-----------------|:--------------------|:------------------|------------------:|:------------------|:---------------|
| 2640274            |    422183 |     428747 |                    2 | 2015-06-04 00:00:00.000 |           826 | Unclassified     | Dry            | Daylight: street lights present | Fine without high winds | Driver/Rider     | Slight              | Female            |                22 | Car               | 422183 428747  |
| 2640378            |    427438 |     432800 |                    2 | 2015-06-04 00:00:00.000 |          1003 | Unclassified     | Dry            | Daylight: street lights present | Fine without high winds | Driver/Rider     | Slight              | Male              |                65 | Car               | 427438 432800  |
| 2660836            |    436506 |     441865 |                    2 | 2015-06-06 00:00:00.000 |          1412 | Unclassified     | Dry            | Daylight: street lights present | Fine without high winds | Driver/Rider     | Slight              | Female            |                40 | Car               | 436506 441865  |
| 2660836            |    436506 |     441865 |                    2 | 2015-06-06 00:00:00.000 |          1412 | Unclassified     | Dry            | Daylight: street lights present | Fine without high winds | Driver/Rider     | Slight              | Female            |                31 | Car               | 436506 441865  |
| 2661053            |    431597 |     435556 |                    2 | 2015-06-06 00:00:00.000 |          1624 | Unclassified     | Dry            | Daylight: street lights present | Fine without high winds | Driver/Rider     | Slight              | Male              |                20 | Car               | 431597 435556  |
| 2691088            |    421576 |     440732 |                    2 | 2015-06-09 00:00:00.000 |          1510 | Unclassified     | Dry            | Daylight: street lights present | Fine without high winds | Driver/Rider     | Slight              | Male              |                53 | Car               | 421576 440732  |
| 2691313            |    431218 |     433711 |                    2 | 2015-06-09 00:00:00.000 |          1917 | Unclassified     | Dry            | Daylight: street lights present | Fine without high winds | Driver/Rider     | Slight              | Male              |                39 | Car               | 431218 433711  |
| 26C1198            |    428921 |     430406 |                    2 | 2015-06-12 00:00:00.000 |          1714 | Unclassified     | Dry            | Daylight: street lights present | Fine without high winds | Driver/Rider     | Slight              | Male              |                44 | Car               | 428921 430406  |
| 26F0205            |    422850 |     433733 |                    2 | 2015-06-15 00:00:00.000 |           720 | Unclassified     | Dry            | Daylight: street lights present | Fine without high winds | Driver/Rider     | Slight              | Female            |                48 | Car               | 422850 433733  |
| 26F1396            |    427069 |     435702 |                    2 | 2015-06-15 00:00:00.000 |          1800 | Unclassified     | Dry            | Daylight: street lights present | Fine without high winds | Driver/Rider     | Slight              | Female            |                21 | Car               | 427069 435702  |


Table: Stop and Search
| Source.Name                              | Type          | Date                    | Part of a policing operation   | Policing operation   |   Latitude |   Longitude | Gender   | Age range     | Self-defined ethnicity     | Officer-defined ethnicity   | Legislation                           | Object of search   | Outcome                           | Outcome linked to object of search   | Removal of more than just outer clothing   |
|:-----------------------------------------|:--------------|:------------------------|:-------------------------------|:---------------------|-----------:|------------:|:---------|:--------------|:---------------------------|:----------------------------|:--------------------------------------|:-------------------|:----------------------------------|:-------------------------------------|:-------------------------------------------|
| 2016-11-metropolitan-stop-and-search.csv | Person search | 2016-11-15 00:20:00.000 | False                          | NOT STATED           |    51.3911 |   -0.30559  | Male     | 18-24         | White - White British (W1) | White                       | Misuse of Drugs Act 1971 (section 23) | Controlled drugs   | Nothing found - no further action |                                      |                                            |
| 2016-11-metropolitan-stop-and-search.csv | Person search | 2016-11-15 00:50:00.000 | False                          | NOT STATED           |    51.5376 |   -0.248489 | Male     | 18-24         | White - White British (W1) | White                       | Misuse of Drugs Act 1971 (section 23) | Controlled drugs   | Nothing found - no further action |                                      |                                            |
| 2016-11-metropolitan-stop-and-search.csv | Person search | 2016-11-15 01:27:00.000 | False                          | NOT STATED           |    51.5872 |   -0.003793 | Male     | Not Specified | White - White British (W1) | White                       | Misuse of Drugs Act 1971 (section 23) | Controlled drugs   | Nothing found - no further action |                                      |                                            |
| 2016-11-metropolitan-stop-and-search.csv | Person search | 2016-11-15 02:50:00.000 | False                          | NOT STATED           |    51.5417 |   -0.072611 | Male     | 18-24         | White - White British (W1) | White                       | Misuse of Drugs Act 1971 (section 23) | Controlled drugs   | Nothing found - no further action |                                      |                                            |
| 2016-11-metropolitan-stop-and-search.csv | Person search | 2016-11-15 02:50:00.000 | False                          | NOT STATED           |    51.5417 |   -0.072611 | Male     | 18-24         | White - White British (W1) | White                       | Misuse of Drugs Act 1971 (section 23) | Controlled drugs   | Nothing found - no further action |                                      |                                            |
| 2016-11-metropolitan-stop-and-search.csv | Person search | 2016-11-15 09:48:00.000 | False                          | NOT STATED           |    51.5081 |   -0.224576 | Male     | over 34       | White - White British (W1) | White                       | Misuse of Drugs Act 1971 (section 23) | Controlled drugs   | Nothing found - no further action |                                      |                                            |
| 2016-11-metropolitan-stop-and-search.csv | Person search | 2016-11-15 13:00:00.000 | False                          | NOT STATED           |    51.4893 |    0.058636 | Male     | Not Specified | White - White British (W1) | White                       | Misuse of Drugs Act 1971 (section 23) | Controlled drugs   | Nothing found - no further action |                                      |                                            |
| 2016-11-metropolitan-stop-and-search.csv | Person search | 2016-11-15 14:20:00.000 | False                          | NOT STATED           |    51.4676 |   -0.023155 | Male     | 18-24         | White - White British (W1) | White                       | Misuse of Drugs Act 1971 (section 23) | Controlled drugs   | Nothing found - no further action |                                      |                                            |
| 2016-11-metropolitan-stop-and-search.csv | Person search | 2016-11-15 14:45:00.000 | False                          | NOT STATED           |    51.5263 |   -0.094931 | Male     | over 34       | White - White British (W1) | White                       | Misuse of Drugs Act 1971 (section 23) | Controlled drugs   | Nothing found - no further action |                                      |                                            |
| 2016-11-metropolitan-stop-and-search.csv | Person search | 2016-11-15 14:50:00.000 | False                          | NOT STATED           |    51.5507 |   -0.131832 | Male     | 18-24         | White - White British (W1) | White                       | Misuse of Drugs Act 1971 (section 23) | Controlled drugs   | Nothing found - no further action |                                      |                                            |


Table: Street
| Source.Name                     | Crime ID   | Month   | Reported by                 | Falls within                |   Longitude |   Latitude | Location               | LSOA code   | LSOA name                 | Crime type            | Last outcome category   | Context   |
|:--------------------------------|:-----------|:--------|:----------------------------|:----------------------------|------------:|-----------:|:-----------------------|:------------|:--------------------------|:----------------------|:------------------------|:----------|
| 2016-11-metropolitan-street.csv |            | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |    0.142061 |    51.53   | On or near Supermarket | E01000095   | Barking and Dagenham 018E | Anti-social behaviour |                         |           |
| 2016-11-metropolitan-street.csv |            | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |    0.142061 |    51.53   | On or near Supermarket | E01000095   | Barking and Dagenham 018E | Anti-social behaviour |                         |           |
| 2016-11-metropolitan-street.csv |            | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.203549 |    51.6458 | On or near Supermarket | E01000292   | Barnet 001E               | Anti-social behaviour |                         |           |
| 2016-11-metropolitan-street.csv |            | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.159536 |    51.6123 | On or near Supermarket | E01000162   | Barnet 015E               | Anti-social behaviour |                         |           |
| 2016-11-metropolitan-street.csv |            | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.209011 |    51.6073 | On or near Supermarket | E01000257   | Barnet 017B               | Anti-social behaviour |                         |           |
| 2016-11-metropolitan-street.csv |            | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.209011 |    51.6073 | On or near Supermarket | E01000257   | Barnet 017B               | Anti-social behaviour |                         |           |
| 2016-11-metropolitan-street.csv |            | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.209011 |    51.6073 | On or near Supermarket | E01000257   | Barnet 017B               | Anti-social behaviour |                         |           |
| 2016-11-metropolitan-street.csv |            | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.155137 |    51.6075 | On or near Supermarket | E01000164   | Barnet 022D               | Anti-social behaviour |                         |           |
| 2016-11-metropolitan-street.csv |            | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.192079 |    51.6031 | On or near Supermarket | E01000296   | Barnet 023C               | Anti-social behaviour |                         |           |
| 2016-11-metropolitan-street.csv |            | 2016-11 | Metropolitan Police Service | Metropolitan Police Service |   -0.266245 |    51.6001 | On or near Supermarket | E01000129   | Barnet 024D               | Anti-social behaviour |                         |           |

 


tables: name: ASBOs Breached
data: ASBOs Breached.csv
name: ASBOs Issued
data: ASBOs Issued.csv
name: LatLong Coordinates
data: LatLong Coordinates.csv
name: Outcomes
data: Outcomes.csv
name: Road Collision Attendants In Camden
data: Road Collision Attendants In Camden.csv
name: Road Collision Casualties In Camden
data: Road Collision Casualties In Camden.csv
name: Road Collision Vehicles In Camden
data: Road Collision Vehicles In Camden.csv
name: Road Traffic Accidents
data: Road Traffic Accidents.csv
name: Stop and Search
data: Stop and Search.csv
name: Street
data: Street.csv
label: Road Traffic Accidents
Coord Lookup
LatLong Coordinates
original coordinate
Road Collision Casualties In Camden
Reference
Road Collision Attendants In Camden
Reference
Road Collision Vehicles In Camden
Reference
Road Collision Attendants In Camden
Reference
output: {
    "joins": [
        {
            "from_table": "Road Traffic Accidents",
            "from_column": "Coord Lookup",
            "to_table": "LatLong Coordinates",
            "to_column": "original coordinate"
        },
        {
            "from_table": "Road Collision Casualties In Camden",
            "from_column": "Reference",
            "to_table": "Road Collision Attendants In Camden",
            "to_column": "Reference"
        },
        {
            "from_table": "Road Collision Vehicles In Camden",
            "from_column": "Reference",
            "to_table": "Road Collision Attendants In Camden",
            "to_column": "Reference"
        }
    ]
}