names

16 rows where place_id = 625223

✎ 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
3762865 1946023 1946023 defendant Bydney Richard butcher 625223 625223 Bydney, Richard, of Lymston, butcher 0
3762866 1946023 1946023 defendant Pereman William laborer 625223 625223 Pereman, William, of Lymston, laborer 1
3801994 1958519 1958519 defendant Wescote John husbandman 625223 625223 Wescote, John, of Lymston, husbandman 0
3806912 1960071 1960071 defendant Bydney Richard husbandman 625223 625223 Bydney, Richard, of Lymston, husbandman 0
3810686 1961240 1961240 defendant Haydon John merchant 625223 625223 Haydon, John, of Lymston, merchant 0
3915874 1995687 1995687 defendant Seward Thomas husbandman 625223 625223 Seward, Thomas, of Lymston, husbandman 1
3997771 2023960 2023960 plaintiff Ellyot or Eliot Henry husbandman 625223 625223 Ellyot or Eliot, Henry, of Lymston, husbandman 0
4088124 2056046 2056046 defendant Paige Richard husbandman 625223 625223 Paige, Richard, of Lymston, husbandman 2
4099187 2060034 2060034 defendant Slade William husbandman 625223 625223 Slade, William, of Lymston, husbandman 0
4191540 2092604 2092604 defendant Whedon Richard husbandman 625223 625223 Whedon, Richard, of Lymston, husbandman 0
5312022 2448625 2448625 defendant Symme John fisher 625223 625223 Symme, John, of Lymston, fisher 1
5312023 2448625 2448625 defendant Symme Thomas yeoman 625223 625223 Symme, Thomas, of Lymston, yeoman 2
5481765 2499479 2499479 defendant Symme John fisher 625223 625223 Symme, John, of Lymston, fisher 2
5481766 2499479 2499479 defendant Symme William fisher 625223 625223 Symme, William, of Lymston, fisher 3
5481767 2499479 2499479 defendant Wilcok John husbandman 625223 625223 Wilcok, John, of Lymston, husbandman 4
5483441 2499995 2499995 defendant Haydon Richard mariner 625223 625223 Haydon, Richard, of Lymston, mariner 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);