names

20 rows where place_id = 591689

✎ 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
3605248 1869309 1869309 defendant Hill John husbandman 591689 591689 Hill, John, of Besford, husbandman 1
3738557 1938267 1938267 defendant Harewell Edmund esq 591689 591689 Harewell, Edmund, of Besford, esq 0
3767315 1947421 1947421 defendant Harewell Edmund esq 591689 591689 Harewell, Edmund, of Besford, esq 0
3783886 1952733 1952733 defendant Harwell Edmund esq 591689 591689 Harwell, Edmund, of Besford, esq 0
3784140 1952823 1952823 defendant Vuett or Unett Richard gent 591689 591689 Vuett or Unett, Richard, of Besford, gent 0
3784141 1952823 1952823 defendant Warrall John yeoman 591689 591689 Warrall, John, of Besford, yeoman 1
3784142 1952823 1952823 defendant Hyll James husbandman 591689 591689 Hyll, James, of Besford, husbandman 2
3784143 1952823 1952823 defendant Taylour John, junior husbandman 591689 591689 Taylour, John, junior, of Besford, husbandman 3
3784144 1952823 1952823 defendant Bidder William draper 591689 591689 Bidder, William, of Besford, draper 4
3791459 1955165 1955165 defendant Wright Philip husbandman 591689 591689 Wright, Philip, of Besford, husbandman 0
3850566 1973767 1973767 defendant Horwell Thomas esq 591689 591689 Horwell, Thomas, of Besford, esq 0
3867640 1979413 1979413 defendant Harwell Thomas gent 591689 591689 Harwell, Thomas, of Besford, gent 0
3867641 1979413 1979413 defendant Wodde William laborer 591689 591689 Wodde, William, of Besford, laborer 1
3927941 1999683 1999683 defendant Shene Robert fisher 591689 591689 Shene, Robert, of Besford, fisher 2
3933701 2001563 2001563 defendant Staunton Nicholas husbandman 591689 591689 Staunton, Nicholas, of Besford, husbandman 0
3951668 2007637 2007637 defendant Harewell Thomas esq 591689 591689 Harewell, Thomas, of Besford, esq 0
4001439 2025292 2025292 defendant Horwell Edmund gent 591689 591689 Horwell, Edmund, of Besford, gent 0
4950827 2342229 2342229 defendant Mathewe Thomas, senior husbandman 591689 591689 Mathewe, Thomas, senior, of Besford, husbandman 14
5026483 2364627 2364627 defendant Bedull John husbandman 591689 591689 Bedull, John, of Besford, husbandman 4
5125692 2394003 2394003 defendant Harewell Roger esq 591689 591689 Harewell, Roger, of Besford, esq 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);