names

30 rows where place_id = 765124

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4513614 2204683 2204683 defendant Webbe Robert   765124 765124 Webbe, Robert, of Headcorn 0
4556275 2217905 2217905 defendant Tonge Walter de   765124 765124 Tonge, Walter de, of Headcorn 0
4582264 2225891 2225891 defendant Tonge Richard   765124 765124 Tonge, Richard, of Headcorn 2
4603874 2232394 2232394 defendant Teldene Roger   765124 765124 Teldene, Roger, of Headcorn 2
4701412 2265845 2265845 defendant Dodyngton John smith 765124 765124 Dodyngton, John, of Headcorn, smith 0
4707504 2267720 2267720 defendant Gateman Thomas laborer 765124 765124 Gateman, Thomas, of Headcorn, laborer 2
4708470 2268017 2268017 defendant Parys John husbandman 765124 765124 Parys, John, of Headcorn, husbandman 0
4722538 2272363 2272363 defendant Hogges John, sen yeoman 765124 765124 Hogges, John, sen, of Headcorn, formerly parkman of Bokyngfeld, yeoman 0
4754813 2281886 2281886 plaintiff Adam Thomas   765124 765124 Adam, Thomas, of Headcorn 0
4755220 2282021 2282021 plaintiff atte Bregge Thomas   765124 765124 atte Bregge, Thomas, of Headcorn 0
4755304 2282046 2282046 defendant Bocher Thomas butcher 765124 765124 Bocher, Thomas, of Headcorn, butcher 0
4756015 2282266 2282266 defendant Adam Thomas gent 765124 765124 Adam, Thomas, of Headcorn, gent 0
4822369 2303077 2303077 defendant Burden Thomas husbandman 765124 765124 Burden, Thomas, of Headcorn, husbandman 4
4840292 2308511 2308511 defendant Blachynden Ralph   765124 765124 Blachynden, Ralph, of Headcorn, pedlar 0
4840326 2308521 2308521 defendant Blachynden Ralph   765124 765124 Blachynden, Ralph, of Headcorn, pedlar 0
4840493 2308566 2308566 defendant Dene Richard husbandman 765124 765124 Dene, Richard, of Headcorn, husbandman 0
5138391 2397736 2397736 defendant Dore Henry   765124 765124 Dore, Henry, of Headcorn, husbandman, Emma, his wife, formerly wife of Testator 2
5158259 2403537 2403537 defendant Duffeld Thomas   765124 765124 Duffeld, Thomas, of Headcorn, parish clerk 0
5302575 2445744 2445744 defendant Southelond John husbandman 765124 765124 Southelond, John, of Headcorn, husbandman, son & heir of Richard Southelond, of Headcorn, husbandman 0
5371497 2466668 2466668 defendant Webbe Nicholas husbandman 765124 765124 Webbe, Nicholas, of Headcorn, husbandman 0
5372202 2466899 2466899 defendant Borden Robert yeoman 765124 765124 Borden, Robert, of Headcorn, yeoman 0
5425793 2482681 2482681 defendant Marketman Thomas husbandman 765124 765124 Marketman,Thomas, of Headcorn, husbandman 0
5425794 2482681 2482681 defendant Vernour John weaver 765124 765124 Vernour, John, of Headcorn, weaver 1
5435228 2485468 2485468 defendant Borden Robert yeoman 765124 765124 Borden, Robert, of Headcorn, yeoman 0
5456621 2491905 2491905 defendant Frary William husbandman 765124 765124 Frary, William, of Headcorn, husbandman 0
5462441 2493669 2493669 defendant Borden Robert yeoman 765124 765124 Borden, Robert, of Headcorn, yeoman 0
5463124 2493885 2493885 defendant Tonge John husbandman 765124 765124 Tonge, John, of Headcorn, husbandman 0
5468483 2495516 2495516 defendant Frary William husbandman 765124 765124 Frary, William, of Headcorn, husbandman 0
5617688 2549361 2549361 defendant Roger John   765124 765124 Roger, John, of Headcorn 7
5617802 2549383 2549383 defendant Roger John   765124 765124 Roger, John, of Headcorn 7

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