names

34 rows where place_id = 664411

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3972796 2015058 2015058 defendant Hawkyns Humphrey husbandman 664411 664411 Hawkyns, Humphrey, of Wollavington, husbandman 0
3974362 2015604 2015604 defendant Crofte William yeoman 664411 664411 Crofte, William, of Wollavington, yeoman 0
3974364 2015605 2015605 defendant Theyr Robert husbandman 664411 664411 Theyr, Robert, of Wollavington, husbandman 0
4055200 2044254 2044254 defendant Deye John yeoman 664411 664411 Deye, John, of Wollavington, yeoman 0
4089783 2056641 2056641 defendant Arter John husbandman 664411 664411 Arter, John, of Wollavington, husbandman 0
4089784 2056641 2056641 defendant Stevens Henry yeoman 664411 664411 Stevens, Henry, of Wollavington, yeoman 1
4089785 2056641 2056641 defendant Palmer John, junior husbandman 664411 664411 Palmer, John, junior, of Wollavington, husbandman 2
4114313 2065402 2065402 defendant Edwardes John husbandman 664411 664411 Edwardes, John, of Wollavington, husbandman 3
4132832 2072071 2072071 defendant James Robert   664411 664411 James, Robert, of Wollavington, husbandman, his son 1
4179037 2088140 2088140 defendant Nicholles John husbandman 664411 664411 Nicholles, John, of Wollavington, husbandman 0
4179038 2088140 2088140 defendant Davie John clerk 664411 664411 Davie, John, of Wollavington, clerk 1
4182688 2089424 2089424 defendant Davye John clerk 664411 664411 Davye, John, of Wollavington, clerk 1
4182689 2089424 2089424 defendant Nycholas John husbandman 664411 664411 Nycholas, John, of Wollavington, husbandman 2
4182691 2089425 2089425 defendant Daye John yeoman 664411 664411 Daye, John, of Wollavington, yeoman 0
4182692 2089425 2089425 defendant Davye John clerk 664411 664411 Davye, John, of Wollavington, clerk 1
4182693 2089425 2089425 defendant Nycholes John husbandman 664411 664411 Nycholes, John, of Wollavington, husbandman 2
4182695 2089426 2089426 defendant Daye John yeoman 664411 664411 Daye, John, of Wollavington, yeoman 0
4182696 2089426 2089426 defendant Davye John clerk 664411 664411 Davye, John, of Wollavington, clerk 1
4182697 2089426 2089426 defendant Nycholes John husbandman 664411 664411 Nycholes, John, of Wollavington, husbandman 2
4196630 2094367 2094367 defendant Paulmer or Pawmer Andrew husbandman 664411 664411 Paulmer or Pawmer, Andrew, of Wollavington, husbandman 0
4196631 2094367 2094367 defendant Paulmer or Pawmer John, junior husbandman 664411 664411 Paulmer or Pawmer, John, junior, of Wollavington, husbandman 1
4210608 2099267 2099267 defendant Davye John clerk 664411 664411 Davye, John, of Wollavington, clerk 2
4213526 2100246 2100246 defendant Harrys Nicholas yeoman 664411 664411 Harrys, Nicholas, of Wollavington, yeoman 1
4219423 2102294 2102294 defendant Daye John yeoman 664411 664411 Daye, John, of Wollavington, yeoman 0
4219424 2102294 2102294 defendant Daye Edward yeoman 664411 664411 Daye, Edward, of Wollavington, yeoman 1
4238611 2109120 2109120 defendant Nicolls John husbandman 664411 664411 Nicolls, John, of Wollavington, husbandman 0
4255438 2114814 2114814 defendant Day John husbandman 664411 664411 Day, John, of Wollavington, husbandman 0
4304093 2131566 2131566 defendant Dey Edward yeoman 664411 664411 Dey, Edward, of Wollavington, yeoman 2
4314645 2135236 2135236 defendant Daye John yeoman 664411 664411 Daye, John, of Wollavington, yeoman 0
4314646 2135236 2135236 defendant Daye Edward yeoman 664411 664411 Daye, Edward, of Wollavington, yeoman 1
4367299 2153359 2153359 defendant Arthure John, senior husbandman 664411 664411 Arthure, John, senior, of Wollavington, husbandman 2
4376917 2156816 2156816 defendant Palmer Andrew husbandman 664411 664411 Palmer, Andrew, of Wollavington, husbandman 3
4376921 2156817 2156817 defendant Palmer Andrew husbandman 664411 664411 Palmer, Andrew, of Wollavington, husbandman 2
4376922 2156817 2156817 defendant Champyn Edward husbandman 664411 664411 Champyn, Edward, of Wollavington, husbandman 3

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