names

18 rows where place_id = 638714

✎ 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
3844362 1971785 1971785 defendant West John clerk 638714 638714 West, John, of Ryngwode, Hants, clerk 0
4805168 2297817 2297817 defendant Shepherd John chapman 638714 638714 Shepherd, John, of Ryngwode, Hants, chapman 3
4816847 2301373 2301373 defendant Astwode alias Wyndesore Henry   638714 638714 Astwode alias Wyndesore, Henry, of Ryngwode, Hants, mason 0
4902039 2327244 2327244 defendant Mahewe Thomas butcher 638714 638714 Mahewe, Thomas, of Ryngwode, Hants, butcher 3
4916657 2331720 2331720 defendant Skynner John skinner 638714 638714 Skynner, John, of Ryngwode, Hants, skinner 3
4925387 2334373 2334373 defendant Galewey Stephen   638714 638714 Galewey, Stephen, of Ryngwode, Hants, milward 0
4955302 2343542 2343542 defendant Dawe William fishmonger 638714 638714 Dawe, William, of Ryngwode, Hants, fishmonger 0
4955304 2343543 2343543 defendant Dawe William fishmonger 638714 638714 Dawe, William, of Ryngwode, Hants, fishmonger 0
4969890 2347944 2347944 defendant Stampford John chapman 638714 638714 Stampford, John, of Ryngwode, Hants, chapman 1
4993523 2354935 2354935 defendant Boket Maud widow 638714 638714 Boket, Maud, of Ryngwode, Hants, widow 1
5000276 2356958 2356958 defendant Estyngton William gent 638714 638714 Estyngton, William, of Ryngwode, Hants, gent 2
5213359 2419638 2419638 defendant Brooke Geoffrey carpenter 638714 638714 Brooke, Geoffrey, of Ryngwode, Hants, carpenter 1
5264230 2434571 2434571 defendant Dyer Peter dyer 638714 638714 Dyer, Peter, of Ryngwode, Hants, dyer 2
5296611 2443996 2443996 defendant Veryng Robert husbandman 638714 638714 Veryng, Robert, of Ryngwode, Hants, husbandman 0
5405887 2476756 2476756 defendant Feryng William dyer 638714 638714 Feryng, William, of Ryngwode, Hants, dyer 0
5418921 2480583 2480583 defendant Feryng William dyer 638714 638714 Feryng, William, of Ryngwode, Hants, dyer 0
5455827 2491646 2491646 defendant Masday John yeoman 638714 638714 Masday, John, of Ryngwode, Hants, yeoman 1
5455858 2491658 2491658 defendant Masday John yeoman 638714 638714 Masday, John, of Ryngwode, Hants, yeoman 1

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