names

23 rows where place_id = 677924

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4029073 2035042 2035042 defendant Darweyn Edmund yeoman 677924 677924 Darweyn, Edmund, of Scrobye, yeoman 0
4057985 2045235 2045235 defendant Troughton Thomas gent 677924 677924 Troughton, Thomas, of Scrobye, gent 0
4113368 2065052 2065052 defendant Copstake Robert maltster 677924 677924 Copstake, Robert, of Scrobye, yeoman, maltster 1
4157173 2080585 2080585 defendant Metcalfe Philip miller 677924 677924 Metcalfe, Philip, of Scrobye, miller 1
4157174 2080585 2080585 defendant Hanson George husbandman 677924 677924 Hanson, George, of Scrobye, husbandman 2
4157175 2080585 2080585 defendant Hanley Thomas husbandman 677924 677924 Hanley, Thomas, of Scrobye, husbandman 3
4157176 2080585 2080585 defendant Johnson Roland husbandman 677924 677924 Johnson, Roland, of Scrobye, husbandman 4
4157177 2080585 2080585 defendant Hanley Mathew husbandman 677924 677924 Hanley, Mathew, of Scrobye, husbandman 5
4157178 2080585 2080585 defendant Hanley John badger 677924 677924 Hanley, John, of Scrobye, badger 6
4157179 2080585 2080585 defendant Harrison Thomas miller 677924 677924 Harrison, Thomas, of Scrobye, miller 7
4157180 2080585 2080585 defendant Stubbinge Thomas laborer 677924 677924 Stubbinge, Thomas, of Scrobye, laborer 8
4157181 2080585 2080585 defendant Hareson William laborer 677924 677924 Hareson, William, of Scrobye, laborer 9
4157182 2080585 2080585 defendant Justys Thomas laborer 677924 677924 Justys, Thomas, of Scrobye, laborer 10
4157183 2080585 2080585 defendant Burgon William carpenter 677924 677924 Burgon, William, of Scrobye, carpenter 11
4157184 2080585 2080585 defendant Taylor Anthony shoemaker 677924 677924 Taylor, Anthony, of Scrobye, shoemaker 12
4157185 2080585 2080585 defendant Scarbroughe William shoemaker 677924 677924 Scarbroughe, William, of Scrobye, shoemaker 13
4157186 2080585 2080585 defendant Chauntrye Thomas laborer 677924 677924 Chauntrye, Thomas, of Scrobye, laborer 14
4157187 2080585 2080585 defendant Denton William, junior weaver 677924 677924 Denton, William, junior, of Scrobye, weaver 15
4157188 2080585 2080585 defendant Denton Ralph weaver 677924 677924 Denton, Ralph, of Scrobye, weaver 16
4157189 2080585 2080585 defendant Bolton Michael laborer 677924 677924 Bolton, Michael, of Scrobye, laborer 17
4157190 2080585 2080585 defendant Darwyn Edward husbandman 677924 677924 Darwyn, Edward, of Scrobye, husbandman 18
4157191 2080585 2080585 defendant Brashawe John weaver 677924 677924 Brashawe, John, of Scrobye, weaver 19
4157192 2080585 2080585 defendant Ingle Richard miller 677924 677924 Ingle, Richard, of Scrobye, miller 20

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