names

21 rows where place_id = 595215

✎ 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
3619454 1873653 1873653 defendant Halys Robert tailor 595215 595215 Halys, Robert, of Tokwyth, tailor 18
3619455 1873653 1873653 defendant Eland Henry husbandman 595215 595215 Eland, Henry, of Tokwyth, husbandman 19
3619456 1873653 1873653 defendant Bolton Thomas laborer 595215 595215 Bolton, Thomas, of Tokwyth, laborer 20
3619457 1873653 1873653 defendant Thomlynson William husbandman 595215 595215 Thomlynson, William, of Tokwyth, husbandman 21
3619458 1873653 1873653 defendant Hunsyngore William laborer 595215 595215 Hunsyngore, William, of Tokwyth, laborer 22
4437151 2176360 2176360 defendant Eynill John de   595215 595215 Eynill, John de, of Tokwyth 0
4556701 2218030 2218030 defendant Colynssone John   595215 595215 Colynssone, John, of Tokwyth 1
4562649 2219877 2219877 defendant Louthre William   595215 595215 Louthre, William, of Tokwyth 2
4635349 2241892 2241892 defendant Colynson John   595215 595215 Colynson, John, of Tokwyth 1
4635350 2241892 2241892 defendant Fournays John   595215 595215 Fournays, John, of Tokwyth 2
4635351 2241892 2241892 defendant Lowether William   595215 595215 Lowether, William, of Tokwyth 3
4714204 2269770 2269770 defendant Colynson John husbandman 595215 595215 Colynson, John, of Tokwyth, husbandman 0
4716463 2270467 2270467 defendant Thomlynson John husbandman 595215 595215 Thomlynson, John, of Tokwyth, husbandman 0
4764713 2284951 2284951 defendant Thomlynson John husbandman 595215 595215 Thomlynson, John, of Tokwyth, husbandman 0
4932479 2336554 2336554 defendant Tomlynson Robert husbandman 595215 595215 Tomlynson, Robert, of Tokwyth, husbandman 1
5132884 2396110 2396110 defendant Firthbank John yeoman 595215 595215 Firthbank, John, of Tokwyth, yeoman 8
5153064 2402039 2402039 defendant Frithbank John yeoman 595215 595215 Frithbank, John, of Tokwyth, yeoman 7
5489444 2501729 2501729 defendant Tomlynson William husbandman 595215 595215 Tomlynson, William, of Tokwyth, husbandman 1
5489447 2501730 2501730 defendant Tomlynson William husbandman 595215 595215 Tomlynson, William, of Tokwyth, husbandman 1
5489461 2501733 2501733 defendant Tomlynson William husbandman 595215 595215 Tomlynson, William, of Tokwyth, husbandman 0
5546407 2518950 2518950 defendant Thomlynson Thomas husbandman 595215 595215 Thomlynson, Thomas, of Tokwyth, husbandman 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);