names

23 rows where place_id = 590135

✎ 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
3600038 1867665 1867665 defendant Haselwode Henry husbandman 590135 590135 Haselwode, Henry, of Langley Abbots, husbandman 2
3632449 1904966 1904966 defendant Felse Thomas laborer 590135 590135 Felse, Thomas, of Langley Abbots, laborer 0
3632450 1904966 1904966 defendant Coke William laborer 590135 590135 Coke, William, of Langley Abbots, laborer 1
3632452 1904966 1904966 defendant Felse Walter laborer 590135 590135 Felse, Walter, of Langley Abbots, laborer 3
3640647 1907516 1907516 defendant Heward Thomas, junior husbandman 590135 590135 Heward, Thomas, junior, of Langley Abbots, husbandman 0
3640648 1907516 1907516 defendant Heyward Henry laborer 590135 590135 Heyward, Henry, of Langley Abbots, laborer 1
3640652 1907516 1907516 defendant Hasylwode John miller 590135 590135 Hasylwode, John, of Langley Abbots, miller 5
3816792 1963160 1963160 defendant Russell John tailor 590135 590135 Russell, John, of Langley Abbots, tailor 0
3858934 1976478 1976478 defendant Cogdell Alexander yeoman 590135 590135 Cogdell, Alexander, of Langley Abbots, yeoman 0
4868043 2316975 2316975 defendant Kytter Roger husbandman 590135 590135 Kytter, Roger, of Langley Abbots, husbandman 0
4875574 2319317 2319317 defendant Twychet Richard carpenter 590135 590135 Twychet, Richard, of Langley Abbots, carpenter 0
4952083 2342589 2342589 defendant Twychet Richard carpenter 590135 590135 Twychet, Richard, of Langley Abbots, carpenter 0
5234489 2425677 2425677 plaintiff Couper John   590135 590135 Couper, John, of Langley Abbots 0
5234490 2425677 2425677 plaintiff Cokdell Andrew   590135 590135 Cokdell, Andrew, of Langley Abbots 1
5298185 2444486 2444486 defendant Martyn Thomas husbandman 590135 590135 Martyn, Thomas, of Langley Abbots, husbandman 0
5453497 2490939 2490939 defendant Merston Thomas husbandman 590135 590135 Merston, Thomas, of Langley Abbots, husbandman 0
5561180 2523248 2523248 defendant Roger Thomas yeoman 590135 590135 Roger, Thomas, of Langley Abbots, yeoman 1
5582801 2529693 2529693 plaintiff Ewer alias Thewer Thomas (legal representative) 590135 590135 Ewer alias Thewer, Thomas, of Langley Abbots, yeoman, executors of 0
5585209 2530441 2530441 defendant Marston Thomas yeoman 590135 590135 Marston, Thomas, of Langley Abbots, yeoman 0
5585210 2530441 2530441 defendant Nevell Robert yeoman 590135 590135 Nevell, Robert, of Langley Abbots, yeoman 1
5599047 2534586 2534586 plaintiff Gape Robert (legal representative) 590135 590135 Gape, Robert, of Langley Abbots, executors of 0
5599050 2534586 2534586 defendant Heyward Thomas, senior husbandman 590135 590135 Heyward, Thomas, senior, of Langley Abbots, husbandman 0
5599051 2534586 2534586 defendant Bukmaster Thomas husbandman 590135 590135 Bukmaster, Thomas, of Langley Abbots, husbandman 1

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