names

30 rows where place_id = 613784

✎ 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
3700264 1926318 1926318 defendant Sheperd William husbandman 613784 613784 Sheperd, William, of Oure, husbandman 0
4308345 2133069 2133069 defendant Sayer David husbandman 613784 613784 Sayer, David, of Oure, husbandman 3
4641454 2243598 2243598 defendant Guyre Roger   613784 613784 Guyre, Roger, of Oure 0
4704023 2266638 2266638 defendant Gilberd John   613784 613784 Gilberd, John, of Oure, lathe maker 1
4727984 2273998 2273998 defendant Gilberd John lather 613784 613784 Gilberd, John, of Oure, lather 1
4769139 2286324 2286324 defendant Seman John forester 613784 613784 Seman, John, of Oure, forester 0
4793664 2294130 2294130 defendant Seman John forester 613784 613784 Seman, John, of Oure, forester 0
4800841 2296451 2296451 defendant Wolfryth Thomas husbandman 613784 613784 Wolfryth, Thomas, of Oure, husbandman 0
4848502 2311009 2311009 defendant Hunt John, sen husbandman 613784 613784 Hunt, John, sen, of Oure, husbandman 0
4848503 2311009 2311009 defendant Talbot John husbandman 613784 613784 Talbot, John, of Oure, husbandman 1
4848505 2311009 2311009 defendant Smolte John husbandman 613784 613784 Smolte, John, of Oure, husbandman 3
4848506 2311009 2311009 defendant Osmond Richard husbandman 613784 613784 Osmond, Richard, of Oure, husbandman 4
4904370 2327984 2327984 defendant Hayward John   613784 613784 Hayward, John, of Oure, servant 0
4904371 2327984 2327984 defendant Rothewell William husbandman 613784 613784 Rothewell, William, of Oure, husbandman 1
4904372 2327984 2327984 defendant Jane Peter husbandman 613784 613784 Jane, Peter, of Oure, husbandman 2
4904373 2327984 2327984 defendant Milward William husbandman 613784 613784 Milward, William, of Oure, husbandman 3
4904374 2327984 2327984 defendant Leverle or Lenerle John husbandman 613784 613784 Leverle or Lenerle, John, of Oure, husbandman 4
4904375 2327984 2327984 defendant Chapeleyn Richard husbandman 613784 613784 Chapeleyn, Richard, of Oure, husbandman 5
5145450 2399812 2399812 defendant Webbe William yeoman 613784 613784 Webbe, William, of Oure, yeoman 0
5165876 2405763 2405763 defendant Webber William   613784 613784 Webber, William, of Oure 0
5306898 2447061 2447061 defendant Holman Walter husbandman 613784 613784 Holman, Walter, of Oure, husbandman 1
5306899 2447061 2447061 defendant Bayly Walter husbandman 613784 613784 Bayly, Walter, of Oure, husbandman 2
5306900 2447061 2447061 defendant Benger Peter husbandman 613784 613784 together with Benger, Peter, of Oure, husbandman 3
5309786 2447961 2447961 defendant Castell John husbandman 613784 613784 Castell, John, of Oure, husbandman 0
5317411 2450291 2450291 defendant Castell John yeoman 613784 613784 Castell, John, of Oure, yeoman 1
5502883 2505816 2505816 defendant Bedwyn Thomas yeoman 613784 613784 Bedwyn, Thomas, of Oure, yeoman 0
5607676 2537300 2537300 defendant Polton John husbandman 613784 613784 Polton, John, of Oure, husbandman 0
5607677 2537300 2537300 defendant Chaundeler John husbandman 613784 613784 Chaundeler, John, of Oure, husbandman 1
5607678 2537300 2537300 defendant Benger John husbandman 613784 613784 Benger, John, of Oure, husbandman 2
5624457 2551591 2551591 defendant Seman John husbandman 613784 613784 Seman, John, of Oure, 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);