names

22 rows where place_id = 616849

✎ 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
3716470 1931444 1931444 defendant Lowe Guy butcher 616849 616849 Lowe, Guy, of Alchurche, butcher 5
3724572 1933968 1933968 defendant Blyke Henry husbandman 616849 616849 Blyke, Henry, of Alchurche, husbandman 2
3752884 1942825 1942825 defendant Blyke Richard husbandman 616849 616849 Blyke, Richard, of Alchurche, husbandman 0
3779321 1951255 1951255 defendant Love Guy butcher 616849 616849 Love, Guy, of Alchurche, butcher 0
3809438 1960834 1960834 defendant Lowe Guy butcher 616849 616849 Lowe, Guy, of Alchurche, butcher 0
3809439 1960834 1960834 defendant Shetwyn Walter yeoman 616849 616849 Shetwyn, Walter, of Alchurche, yeoman 1
3858871 1976454 1976454 defendant Woode Edward carpenter 616849 616849 Woode, Edward, of Alchurche, carpenter 0
3879360 1983351 1983351 defendant More Thomas shoemaker 616849 616849 More, Thomas, of Alchurche, shoemaker 0
3903261 1991314 1991314 defendant Wood Edward carpenter 616849 616849 Wood, Edward, of Alchurche, carpenter 4
3911659 1994221 1994221 defendant More Thomas   616849 616849 More, Thomas, of Alchurche, "crosser" 1
3925864 1998964 1998964 defendant Bedyll Richard husbandman 616849 616849 Bedyll, Richard, of Alchurche, husbandman 0
3954698 2008707 2008707 defendant Carter John yeoman 616849 616849 Carter, John, of Alchurche, yeoman 3
3957238 2009596 2009596 defendant More Thomas yeoman 616849 616849 More, Thomas, of Alchurche, yeoman 0
3957240 2009597 2009597 defendant More Thomas yeoman 616849 616849 More, Thomas, of Alchurche, yeoman 0
3984545 2019229 2019229 defendant Hyll Humphrey yeoman 616849 616849 Hyll, Humphrey, of Alchurche, yeoman 0
3984547 2019230 2019230 defendant Hyll Humphrey yeoman 616849 616849 Hyll, Humphrey, of Alchurche, yeoman 0
4077417 2052211 2052211 defendant Taylor Guy innholder 616849 616849 Taylor, Guy, of Alchurche, innholder 1
4105200 2062135 2062135 plaintiff Neam Henry husbandman 616849 616849 Neam, Henry, of Alchurche, husbandman 0
4105202 2062136 2062136 plaintiff Neam Henry husbandman 616849 616849 Neam, Henry, of Alchurche, husbandman 0
4109792 2063760 2063760 defendant Hawk or Hawkes John cordwainer 616849 616849 Hawk or Hawkes, John, of Alchurche, cordwainer 3
5529637 2513769 2513769 defendant Milward John husbandman 616849 616849 Milward, John, of Alchurche, husbandman 0
5529638 2513769 2513769 defendant Milward Richard husbandman 616849 616849 Milward, Richard, of Alchurche, 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);