names

27 rows where place_id = 606286

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3664711 1914916 1914916 defendant Chesman John gent 606286 606286 Chesman, John, of Lewesham, gent 0
3664712 1914916 1914916 defendant Tower John husbandman 606286 606286 Tower, John, of Lewesham, husbandman 1
3680422 1919959 1919959 defendant Wheler Edward wheeler 606286 606286 Wheler, Edward, of Lewesham, wheeler 0
3701049 1926577 1926577 defendant Skypwith Richard (legal representative) 606286 606286 Skypwith, Richard, of Lewesham, gent, executors of 0
3701052 1926578 1926578 defendant Skypwith Richard (legal representative) 606286 606286 Skypwith, Richard, of Lewesham, gent, executors of 0
3702013 1926885 1926885 defendant Skypwyth Richard (legal representative) 606286 606286 Skypwyth, Richard, of Lewesham, gent, executors of 0
3710073 1929461 1929461 defendant Skypwyth Richard (legal representative) 606286 606286 Skypwyth, Richard, of Lewesham, gent, executors of 0
3710495 1929604 1929604 defendant Skypwyth Richard (legal representative) 606286 606286 Skypwyth, Richard, of Lewesham, gent, executors of 0
3710528 1929615 1929615 defendant Skypwith Richard (legal representative) 606286 606286 Skypwith, Richard, of Lewesham, gent, executors of 0
3710537 1929617 1929617 defendant Skypwyth Richard (legal representative) 606286 606286 Skypwyth, Richard, of Lewesham, gent, executors of 0
3724814 1934046 1934046 defendant Mosyer Nicholas husbandman 606286 606286 Mosyer, Nicholas, of Lewesham, husbandman 0
3744270 1940105 1940105 defendant Stevenson Hugh gent 606286 606286 Stevenson, Hugh, of Lewesham, gent 0
3744272 1940106 1940106 defendant Stevenson Hugh gent 606286 606286 Stevenson, Hugh, of Lewesham, gent 0
3760389 1945253 1945253 defendant Nicolson John chapman 606286 606286 Nicolson, John, of Lewesham, chapman 3
3761494 1945606 1945606 defendant Kyng John miller 606286 606286 Kyng, John, of Lewesham, miller 1
3765496 1946874 1946874 plaintiff Landysshe alias Bankyn John esq 606286 606286 Landysshe alias Bankyn, John, of Lewesham, esq 0
3806944 1960079 1960079 defendant Wallys Richard gent 606286 606286 Wallys, Richard, of Lewesham, gent 5
3842813 1971285 1971285 defendant Brown Robert husbandman 606286 606286 Brown, Robert, of Lewesham, husbandman 0
3842815 1971286 1971286 defendant Browne Robert husbandman 606286 606286 Browne, Robert, of Lewesham, husbandman 0
4225708 2104456 2104456 defendant Woodgate William husbandman 606286 606286 Woodgate, William, of Lewesham, or of Orpington, husbandman 1
5379081 2469052 2469052 defendant Memmys John laborer 606286 606286 Memmys, John, of Lewesham, laborer 4
5418474 2480450 2480450 defendant Waspe Thomas brewer 606286 606286 Waspe, Thomas, of Lewesham, brewer 1
5502466 2505690 2505690 defendant Johnson Alexander brewer 606286 606286 Johnson, Alexander, of Lewesham, brewer 0
5554933 2521446 2521446 defendant Gregory John yeoman 606286 606286 Gregory, John, of Lewesham, yeoman 2
5554937 2521447 2521447 defendant Gregory John yeoman 606286 606286 Gregory, John, of Lewesham, yeoman 2
5607685 2537303 2537303 defendant Robyns Joan widow 606286 606286 Robyns, Joan, of Lewesham, widow, formerly Willyams, Joan, of Levesham, widow 0
5607974 2537400 2537400 defendant Robyns Joan widow 606286 606286 Robyns, Joan, of Lewesham, widow, formerly Wyllyams, Joan, of Levesham, widow 0

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);