names

25 rows where place_id = 595480

✎ 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
3620629 1874031 1874031 defendant Roberd John chapman 595480 595480 Roberd, John, of Hertest, chapman 0
3657610 1912643 1912643 defendant Frost John   595480 595480 Frost, John, of Hertest, parish clerk 2
3657619 1912644 1912644 defendant Frost John   595480 595480 Frost, John, of Hertest, parish clerk 2
3676910 1918817 1918817 defendant Coppyng John husbandman 595480 595480 Coppyng, John, of Hertest, husbandman 1
3694786 1924577 1924577 defendant Phillypson John husbandman 595480 595480 Phillypson, John, of Hertest, husbandman 0
3696102 1925005 1925005 defendant Everard John weaver 595480 595480 Everard, John, of Hertest, weaver 0
3712143 1930115 1930115 defendant Phillipson John, junior husbandman 595480 595480 Phillipson, John, junior, of Hertest, husbandman 0
3712145 1930116 1930116 defendant Phillipson John husbandman 595480 595480 Phillipson, John, of Hertest, husbandman 0
3767568 1947493 1947493 defendant Phylypson John husbandman 595480 595480 Phylypson, John, of Hertest, husbandman 0
3802282 1958612 1958612 defendant Nunne Robert yeoman 595480 595480 Nunne, Robert, of Hertest, yeoman 0
3853578 1974745 1974745 defendant Browne Esmund shoemaker 595480 595480 Browne, Esmund, of Hertest, shoemaker 1
4603633 2232322 2232322 defendant Doune Roger   595480 595480 Doune, Roger, of Hertest 0
4677395 2258546 2258546 defendant Burle John laborer 595480 595480 Burle, John, of Hertest, laborer 5
4744547 2278929 2278929 defendant Struch alias Strut Robert yeoman 595480 595480 Struch alias Strut, Robert, of Hertest, yeoman 2
4833487 2306479 2306479 defendant Mour Robert yeoman 595480 595480 Mour, Robert, of Hertest, yeoman 1
4871169 2317959 2317959 defendant atte Moor Robert husbandman 595480 595480 atte Moor, Robert, of Hertest, husbandman 0
4950225 2342034 2342034 defendant Hebell or Hevell William yeoman 595480 595480 Hebell or Hevell, William, of Hertest, yeoman 1
5049647 2371518 2371518 defendant Roberd John husbandman 595480 595480 Roberd, John, of Hertest, husbandman 1
5147038 2400272 2400272 defendant Warde James husbandman 595480 595480 Warde, James, of Hertest, husbandman 1
5310747 2448250 2448250 defendant Waryn John butcher 595480 595480 Waryn, John, of Hertest, butcher 0
5505129 2506514 2506514 defendant Smert William smith 595480 595480 Smert, William, of Hertest, smith 0
5566299 2524736 2524736 defendant Hawekyn John barker 595480 595480 Hawekyn, John, of Hertest, barker 3
5567235 2524994 2524994 defendant Roberd William yeoman 595480 595480 Roberd, William, of Hertest, yeoman 0
5567236 2524994 2524994 defendant Haukyn or Hankyn John yeoman 595480 595480 Haukyn or Hankyn, John, of Hertest, yeoman 1
5568824 2525432 2525432 defendant Frost John husbandman 595480 595480 Frost, John, of Hertest, husbandman 2

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