names

20 rows where place_id = 595206

✎ 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
3619409 1873647 1873647 defendant Webbe William husbandman 595206 595206 Webbe, William, of Walcomstowe, husbandman 0
3623692 1874941 1874941 defendant Webbe Thomas brewer 595206 595206 Webbe, Thomas, of Walcomstowe, brewer 1
3624453 1875184 1875184 defendant Webbe Thomas husbandman 595206 595206 Webbe, Thomas, of Walcomstowe, husbandman 0
3704334 1927656 1927656 defendant Walker Clement husbandman 595206 595206 (Walker, Clement, of Walcomstowe, husbandman 1
3722068 1933164 1933164 defendant Walker Clement husbandman 595206 595206 Walker, Clement, of Walcomstowe, husbandman 5
3763320 1946160 1946160 defendant Garold Richard collier 595206 595206 Garold, Richard, of Walcomstowe, collier 0
3781825 1952061 1952061 defendant Drynklowe William gent 595206 595206 Drynklowe, William, of Walcomstowe, gent 0
5054062 2372807 2372807 defendant Yonge John, junior yeoman 595206 595206 Yonge, John, junior, of Walcomstowe, yeoman 0
5224903 2422955 2422955 defendant Symond William baker 595206 595206 Symond, William, of Walcomstowe, baker 0
5261900 2433829 2433829 defendant Barby Richard husbandman 595206 595206 Barby, Richard, of Walcomstowe, husbandman 0
5500980 2505241 2505241 defendant Maskall Joan widow 595206 595206 Maskall, Joan, of Walcomstowe, widow 3
5518542 2510629 2510629 plaintiff Acotys Robert yeoman 595206 595206 Acotys, Robert, of Walcomstowe, yeoman 0
5519434 2510927 2510927 defendant Webbe Thomas husbandman 595206 595206 Webbe, Thomas, of Walcomstowe, husbandman 1
5519436 2510927 2510927 defendant Fyncke John husbandman 595206 595206 Fyncke, John, of Walcomstowe, husbandman 3
5539174 2516736 2516736 defendant Paty or Pacy William husbandman 595206 595206 Paty or Pacy, William, of Walcomstowe, husbandman 0
5547785 2519369 2519369 defendant Webbe Thomas husbandman 595206 595206 Webbe, Thomas, of Walcomstowe, husbandman 1
5565023 2524356 2524356 defendant Beton Thomas yeoman 595206 595206 Beton, Thomas, of Walcomstowe, yeoman 2
5569899 2525771 2525771 defendant Cotes Robert yeoman 595206 595206 Cotes, Robert, of Walcomstowe, yeoman 0
5569917 2525776 2525776 defendant Cotes Robert yeoman 595206 595206 Cotes, Robert, of Walcomstowe, yeoman 0
5596668 2533878 2533878 defendant Pate Thomas yeoman 595206 595206 Pate, Thomas, of Walcomstowe, 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);