names

22 rows where place_id = 625355

✎ 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
3763652 1946273 1946273 defendant Benett Philip miller 625355 625355 Benett, Philip, of Storyngton, miller 0
3816471 1963058 1963058 defendant Best Richard yeoman 625355 625355 Best, Richard, of Storyngton, yeoman 2
4134360 2072618 2072618 defendant Bennett John husbandman 625355 625355 Bennett, John, of Storyngton, husbandman 0
4134361 2072618 2072618 defendant Hayne Richard husbandman 625355 625355 Hayne, Richard, of Storyngton, husbandman 1
4173867 2086315 2086315 defendant Penfold Thomas butcher 625355 625355 Penfold, Thomas, of Storyngton, butcher 0
4366081 2152911 2152911 defendant Wase John yeoman 625355 625355 Wase, John, of Storyngton, yeoman 1
4371823 2154984 2154984 defendant Parham John yeoman 625355 625355 Parham, John, of Storyngton, yeoman 0
4377065 2156870 2156870 defendant Wase John yeoman 625355 625355 Wase, John, of Storyngton, yeoman 0
4377066 2156870 2156870 defendant Parham John yeoman 625355 625355 Parham, John, of Storyngton, yeoman 1
4377067 2156870 2156870 defendant Grantham Thomas yeoman 625355 625355 Grantham, Thomas, of Storyngton, yeoman 2
4382207 2158744 2158744 defendant Wase John yeoman 625355 625355 Wase, John, of Storyngton, yeoman 0
4767962 2285950 2285950 defendant Thurmond David esq 625355 625355 Thurmond, David, of Storyngton, esq 4
5018490 2362291 2362291 defendant atte Staple Richard husbandman 625355 625355 atte Staple, Richard, of Storyngton, husbandman 0
5402559 2475802 2475802 defendant Rouche John husbandman & pardoner 625355 625355 Rouche, John, of Storyngton, husbandman & pardoner 2
5416720 2479920 2479920 defendant Routhe John husbandman 625355 625355 Routhe, John, of Storyngton, husbandman 2
5433627 2485024 2485024 defendant Routhe John husbandman 625355 625355 Routhe, John, of Storyngton, husbandman 2
5433632 2485025 2485025 defendant Routhe John pardoner & husbandman 625355 625355 Routhe, John, of Storyngton, pardoner & husbandman 2
5461168 2493289 2493289 defendant Routhe John husbandman 625355 625355 Routhe, John, of Storyngton, husbandman 2
5523064 2512039 2512039 defendant Upbroke John butcher 625355 625355 Upbroke, John, of Storyngton, butcher 0
5526677 2512909 2512909 defendant Pyrley William clerk 625355 625355 Pyrley, William, of Storyngton, clerk 0
5573735 2526884 2526884 defendant Barnard William husbandman 625355 625355 Barnard, William, of Storyngton, husbandman 0
5573736 2526884 2526884 defendant Owedoun John husbandman 625355 625355 Owedoun, John, of Storyngton, 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);