names

23 rows where place_id = 592141

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606710 1869774 1869774 defendant Thorne Thomas gent 592141 592141 Thorne, Thomas, of Shepewasshe, gent 0
3625779 1875600 1875600 defendant Thorne Humphrey gent 592141 592141 Thorne, Humphrey, of Shepewasshe, gent 0
3873118 1981224 1981224 defendant Pecok John husbandman 592141 592141 Pecok, John, of Shepewasshe, husbandman 1
4115804 2065937 2065937 defendant Skam or Skain Walter husbandman 592141 592141 Skam or Skain, Walter, of Shepewasshe, husbandman 0
4967872 2347335 2347335 defendant Idelcote Durand yeoman 592141 592141 Idelcote, Durand, of Shepewasshe, yeoman 0
5319129 2450815 2450815 defendant Molle Robert yeoman 592141 592141 Molle, Robert, of Shepewasshe, yeoman 2
5379766 2469252 2469252 defendant Kelly John husbandman 592141 592141 Kelly, John, of Shepewasshe, husbandman 0
5429377 2483720 2483720 defendant Surdecote Robert yeoman 592141 592141 Surdecote, Robert, of Shepewasshe, yeoman 7
5429378 2483720 2483720 defendant Loder Hugh yeoman 592141 592141 Loder, Hugh, of Shepewasshe, yeoman 8
5429379 2483720 2483720 defendant Walshe Thomas tailor 592141 592141 Walshe, Thomas, of Shepewasshe, tailor 9
5429380 2483720 2483720 defendant Lambell Richard husbandman 592141 592141 Lambell, Richard, of Shepewasshe, husbandman 10
5429381 2483720 2483720 defendant Pote John husbandman 592141 592141 Pote, John, of Shepewasshe, husbandman 11
5429382 2483720 2483720 defendant Tosbe Walter husbandman 592141 592141 Tosbe, Walter, of Shepewasshe, husbandman 12
5438665 2486499 2486499 defendant Surdecote Robert yeoman 592141 592141 Surdecote, Robert, of Shepewasshe, yeoman 2
5452605 2490662 2490662 defendant Surdecote Robert yeoman 592141 592141 Surdecote, Robert, of Shepewasshe, yeoman 2
5464507 2494306 2494306 defendant Surdecote Robert yeoman 592141 592141 Surdecote, Robert, of Shepewasshe, yeoman 2
5471331 2496363 2496363 defendant Thorne Thomas gent 592141 592141 Thorne, Thomas, of Shepewasshe, gent 0
5520569 2511259 2511259 defendant Sampson Robert tanner 592141 592141 Sampson, Robert, of Shepewasshe, tanner 0
5523807 2512267 2512267 defendant Sampson Robert husbandman 592141 592141 Sampson, Robert, of Shepewasshe, husbandman 0
5523810 2512267 2512267 defendant Walshe Thomas husbandman 592141 592141 Walshe, Thomas, of Shepewasshe, husbandman 3
5529594 2513756 2513756 defendant Gardegan Geoffrey husbandman 592141 592141 Gardegan, Geoffrey, of Shepewasshe, husbandman 0
5529595 2513756 2513756 defendant Morell William laborer 592141 592141 Morell, William, of Shepewasshe, laborer 1
5624089 2551482 2551482 defendant William William shoemaker 592141 592141 William, William, of Shepewasshe, shoemaker 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);