names

32 rows where place_id = 616133

✎ 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
3712725 1930295 1930295 defendant Crofte Robert yeoman 616133 616133 Crofte, Robert, of Batley, yeoman 3
3792720 1955576 1955576 defendant Coventre Edmund husbandman 616133 616133 Coventre, Edmund, of Batley, husbandman 0
3858696 1976391 1976391 defendant Lee Thomas laborer 616133 616133 Lee, Thomas, of Batley, laborer 0
3858697 1976391 1976391 defendant Copley Edward smith 616133 616133 Copley, Edward, of Batley, smith 1
3858698 1976391 1976391 defendant Bradley William husbandman 616133 616133 Bradley, William, of Batley, husbandman 2
3858699 1976391 1976391 defendant Turner William yeoman 616133 616133 Turner, William, of Batley, yeoman 3
3858700 1976391 1976391 defendant Willy Thomas husbandman 616133 616133 Willy, Thomas, of Batley, husbandman 4
3874919 1981837 1981837 plaintiff Dighton John   616133 616133 Dighton, John, of Batley 0
3942049 2004355 2004355 defendant Spene Thomas yeoman 616133 616133 Spene, Thomas, of Batley, yeoman 0
3962644 2011522 2011522 defendant Thorpe Christopher smith 616133 616133 Thorpe, Christopher, of Batley, smith 0
3972623 2014999 2014999 defendant Rayner Robert tanner 616133 616133 Rayner, Robert, of Batley, tanner 1
4001172 2025196 2025196 defendant Grenewood Gregory yeoman 616133 616133 Grenewood, Gregory, of Batley, yeoman 0
4105576 2062275 2062275 defendant Hudson Alan dyer 616133 616133 Hudson, Alan, of Batley, dyer 0
4108878 2063428 2063428 defendant Wylbore Edmund yeoman 616133 616133 Wylbore, Edmund, of Batley, yeoman 0
4124019 2068890 2068890 defendant Steade Humphrey laborer 616133 616133 Steade, Humphrey, of Batley, laborer 2
4157381 2080651 2080651 defendant Wilbore Edmund yeoman 616133 616133 Wilbore, Edmund, of Batley, yeoman 0
4220594 2102700 2102700 defendant Foxcrofte Thomas yeoman 616133 616133 Foxcrofte, Thomas, of Batley, yeoman 1
4253415 2114133 2114133 defendant Sherde Martin yeoman 616133 616133 Sherde, Martin, of Batley, yeoman 2
4271049 2119891 2119891 defendant Foxcrofte Thomas yeoman 616133 616133 Foxcrofte, Thomas, of Batley, yeoman 1
4314194 2135072 2135072 defendant Foscroft Thomas clothier 616133 616133 Foscroft, Thomas, of Batley, clothier 0
4349133 2146957 2146957 defendant Brooke Alvered or Avericus yeoman 616133 616133 Brooke, Alvered or Avericus, of Batley, yeoman 0
4351863 2147892 2147892 defendant Counsmith or Connsmith Alvered yeoman 616133 616133 Counsmith or Connsmith, Alvered, of Batley, yeoman 3
4731153 2274943 2274943 defendant Benet Robert husbandman 616133 616133 Benet, Robert, of Batley, husbandman 2
4818371 2301826 2301826 defendant Dale John   616133 616133 Dale, John, of Batley, vicar 0
4818372 2301826 2301826 defendant Machon Thomas husbandman 616133 616133 Machon, Thomas, of Batley, husbandman 1
5018485 2362289 2362289 defendant Grene William husbandman 616133 616133 Grene, William, of Batley, husbandman 2
5269888 2436301 2436301 plaintiff Copley Thomas   616133 616133 Copley, Thomas, of Batley 1
5281517 2439659 2439659 plaintiff Copley Thomas   616133 616133 Copley, Thomas, of Batley 1
5298003 2444429 2444429 defendant Cokson Richard clerk 616133 616133 Cokson, Richard, of Batley, clerk 0
5356126 2461993 2461993 defendant Foxby William husbandman 616133 616133 Foxby, William, of Batley, husbandman 2
5367895 2465582 2465582 defendant Wikbore Richard   616133 616133 Wikbore, Richard, of Batley, wheel wright 1
5492403 2502643 2502643 defendant Wilbore Robert barker 616133 616133 Wilbore, Robert, of Batley, barker 4

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