names

21 rows where place_id = 613236

✎ 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
3697277 1925372 1925372 defendant Wodward William husbandman 613236 613236 Wodward, William, of Harborowe, husbandman 0
3697278 1925372 1925372 defendant Wodward Henry husbandman 613236 613236 Wodward, Henry, of Harborowe, husbandman 1
3739613 1938604 1938604 defendant Marten Nicholas yeoman 613236 613236 Marten, Nicholas, of Harborowe, yeoman 0
3747118 1941015 1941015 defendant Wodeward Henry smith 613236 613236 Wodeward, Henry, of Harborowe, smith 0
3756057 1943850 1943850 defendant Foster John innholder 613236 613236 Foster, John, of Harborowe, innholder 0
3791954 1955332 1955332 plaintiff Andrewe Thomas   613236 613236 Andrewe, Thomas, of Harborowe 0
3804283 1959273 1959273 defendant Foxon Thomas innholder 613236 613236 Foxon, Thomas, of Harborowe, innholder 0
3817764 1963460 1963460 defendant Foster John innholder 613236 613236 Foster, John, of Harborowe, innholder 0
3817766 1963461 1963461 defendant Foster John innholder 613236 613236 Foster, John, of Harborowe, innholder 0
3817768 1963462 1963462 defendant Foster John innholder 613236 613236 Foster, John, of Harborowe, innholder 0
3817770 1963463 1963463 defendant Foster John innholder 613236 613236 Foster, John, of Harborowe, innholder 0
3999018 2024408 2024408 plaintiff Fox Nicholas yeoman 613236 613236 Fox, Nicholas, of Harborowe, yeoman 0
4171392 2085458 2085458 defendant Buttres Simon gent 613236 613236 Buttres, Simon, of Harborowe, gent 0
4297649 2129264 2129264 defendant Clynt Richard shiemaker 613236 613236 Clynt, Richard, of Harborowe, yeoman, shiemaker 0
4361654 2151328 2151328 defendant Bolderbye Henry yeoman 613236 613236 Bolderbye, Henry, of Harborowe, yeoman 0
4361661 2151329 2151329 defendant Shuter Henry innholder 613236 613236 Shuter, Henry, of Harborowe, innholder 3
4387631 2160500 2160500 defendant Francis William shoemaker 613236 613236 Francis, William, of Harborowe, shoemaker 0
5518873 2510742 2510742 defendant Basset Henry butcher 613236 613236 Basset, Henry, of Harborowe, butcher 0
5521431 2511518 2511518 defendant Basset Henry butcher 613236 613236 Basset, Henry, of Harborowe, butcher 0
5550137 2520073 2520073 defendant Smyth Thomas draper 613236 613236 Smyth, Thomas, of Harborowe, draper 0
5583531 2529921 2529921 defendant Banham Richard butcher 613236 613236 Banham, Richard, of Harborowe, butcher 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);