names

18 rows where place_id = 671204

✎ 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
4000591 2024983 2024983 plaintiff Grenestrete John yeoman 671204 671204 Grenestrete, John, of Ospringe, yeoman 0
4000818 2025062 2025062 plaintiff Grynstrete or Grinsted John yeoman 671204 671204 Grynstrete or Grinsted, John, of Ospringe, yeoman 0
4001023 2025140 2025140 defendant Grenestrete John yeoman 671204 671204 Grenestrete, John, of Ospringe, yeoman 0
4144149 2076116 2076116 defendant Sowgatt Edward yeoman 671204 671204 Sowgatt, Edward, of Ospringe, yeoman 0
4212246 2099830 2099830 defendant Sungate Robert husbandman 671204 671204 Sungate, Robert, of Ospringe, husbandman 0
4226007 2104565 2104565 defendant Streynsham Robert gent 671204 671204 Streynsham, Robert, of Ospringe, gent 1
4226629 2104790 2104790 defendant Browne Thomas alias "Unatt Bull" yeoman 671204 671204 Browne, Thomas alias "Unatt Bull", of Ospringe, yeoman 0
4226630 2104790 2104790 defendant Stransham Robert gent 671204 671204 together with Stransham, Robert, of Ospringe, gent 1
4228860 2105572 2105572 defendant Hodge William glover 671204 671204 Hodge, William, of Ospringe, glover 2
4243019 2110658 2110658 defendant Streynsham Robert gent 671204 671204 Streynsham, Robert, of Ospringe, gent 1
4245957 2111628 2111628 defendant Hodge William glover 671204 671204 Hodge, William, of Ospringe, glover 2
4309828 2133593 2133593 defendant Owre or Ore Alexander yeoman 671204 671204 Owre or Ore, Alexander, of Ospringe, yeoman 0
4319871 2137056 2137056 defendant Wyllyams Thomas husbandman 671204 671204 Wyllyams, Thomas, of Ospringe, husbandman 0
4381621 2158536 2158536 defendant Stafforde John   671204 671204 Stafforde, John, of Ospringe, or of Ware, Herts, tallow chandler 0
4646884 2245150 2245150 defendant Chapman William   671204 671204 Chapman, William, of Ospringe 0
4709634 2268376 2268376 defendant atte Sole Robert husbandman 671204 671204 atte Sole, Robert, of Ospringe, husbandman 0
5199339 2415555 2415555 defendant Wade John husbandman 671204 671204 Wade, John, of Ospringe, husbandman 0
5211091 2418970 2418970 defendant Wade John husbandman 671204 671204 Wade, John, of Ospringe, husbandman 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);