names

17 rows where place_id = 602149

✎ 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
3648633 1909960 1909960 defendant Herd Walter yeoman 602149 602149 Herd, Walter, of Methe, yeoman 1
4111100 2064223 2064223 defendant Cowper William   602149 602149 Cowper, William, of Methe, wheelwright 0
4485572 2196193 2196193 defendant Croft John   602149 602149 Croft, John, of Methe 3
4611770 2234744 2234744 defendant Hackere Richard   602149 602149 Hackere, Richard, of Methe 2
4639327 2243014 2243014 defendant Haukere Richard   602149 602149 Haukere, Richard, of Methe 7
4680802 2259615 2259615 defendant Bourjour John   602149 602149 Bourjour, John, of Methe, lime burner 0
4803377 2297248 2297248 defendant Mayer John drover 602149 602149 Mayer, John, of Methe, drover 0
4829461 2305256 2305256 defendant Mayer John drover 602149 602149 Mayer, John, of Methe, drover 0
4933491 2336861 2336861 defendant Frye Geoffrey husbandman 602149 602149 Frye, Geoffrey, of Methe, husbandman 0
4933494 2336861 2336861 defendant Colaton John   602149 602149 Colaton, John, of Methe, parson 3
4933495 2336861 2336861 defendant forst John, senior husbandman 602149 602149 forst, John, senior, of Methe, husbandman 4
4958760 2344590 2344590 defendant Forst John, senior husbandman 602149 602149 Forst, John, senior, of Methe, husbandman 0
4958761 2344590 2344590 defendant Norys John husbandman 602149 602149 Norys, John, of Methe, husbandman 1
4958763 2344590 2344590 defendant Forst William husbandman 602149 602149 Forst, William, of Methe, husbandman 3
5095308 2385046 2385046 defendant Gruggeworthy John husbandman 602149 602149 Gruggeworthy, John, of Methe, husbandman 2
5484522 2500290 2500290 defendant Yeme John carpenter 602149 602149 Yeme, John, of Methe, carpenter 0
5593994 2533112 2533112 defendant Frye John yeoman or gent 602149 602149 Frye, John, of Methe, or of Fryshell, yeoman or gent 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);