names

19 rows where place_id = 597846

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3630097 1904262 1904262 defendant Melbank Peter kendalman 597846 597846 Melbank, Peter, of Skypton in Craven, Yorks, kendalman 0
3632017 1904831 1904831 defendant Clyfford Henry   597846 597846 Clyfford, Henry, of Skypton in Craven, Yorks, knight 0
3654636 1911710 1911710 defendant Haver Peter clothman 597846 597846 Haver, Peter, of Skypton in Craven, Yorks, clothman 0
3926583 1999221 1999221 defendant Melbanke alias Atkynson Reginald chapman 597846 597846 Melbanke alias Atkynson, Reginald, of Skypton in Craven, Yorks, chapman 0
4017177 2030847 2030847 defendant Lambert John yeoman 597846 597846 Lambert, John, of Skypton in Craven, Yorks, yeoman 0
4038156 2038286 2038286 defendant Tomlynson William chapman 597846 597846 Tomlynson, William, of Skypton in Craven, Yorks, chapman 0
4074552 2051201 2051201 defendant Tomlynson Thomas chapman 597846 597846 Tomlynson, Thomas, of Skypton in Craven, Yorks, chapman 1
4131980 2071752 2071752 defendant Kychyn Gabriel gent 597846 597846 Kychyn, Gabriel, of Skypton in Craven, Yorks, gent 1
4131993 2071755 2071755 defendant Kychyn Gabriel gent 597846 597846 Kychyn, Gabriel, of Skypton in Craven, Yorks, gent 1
4858958 2314181 2314181 defendant Blakebourne William gent 597846 597846 Blakebourne, William, of Skypton in Craven, Yorks, gent 3
4914245 2330970 2330970 defendant Crakanthorp John gent 597846 597846 (Crakanthorp, John, of Skypton in Craven, Yorks, gent 1
4931812 2336336 2336336 defendant Forster John yeoman 597846 597846 Forster, John, of Skypton in Craven, Yorks, yeoman 0
5026427 2364619 2364619 defendant Crakanthorp John esq 597846 597846 Crakanthorp, John, of Skypton in Craven, Yorks, esq 0
5088521 2383018 2383018 defendant Agarth John gent 597846 597846 Agarth, John, of Skypton in Craven, Yorks, gent 2
5088530 2383019 2383019 defendant Agarth Thomas gent 597846 597846 Agarth, Thomas, of Skypton in Craven, Yorks, gent 1
5255360 2431792 2431792 defendant Garth Thomas gent 597846 597846 Garth, Thomas, of Skypton in Craven, Yorks, gent 1
5398431 2474614 2474614 defendant Dounyng Thomas gent & Secretary of Lord Clyfford 597846 597846 Dounyng, Thomas, of Skypton in Craven, Yorks, gent & Secretary of Lord Clyfford 0
5463836 2494099 2494099 defendant Waller Thomas merchant 597846 597846 Waller, Thomas, of Skypton in Craven, Yorks, merchant 0
5605738 2536682 2536682 defendant Hayler or Haibar Peter kendalman 597846 597846 Hayler or Haibar, Peter, of Skypton in Craven, Yorks, kendalman 2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);