names

33 rows where place_id = 613621

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3699409 1926038 1926038 defendant Lowthe John husbandman 613621 613621 Lowthe, John, of Barneham Brome, husbandman 1
3719595 1932394 1932394 defendant Debney John husbandman 613621 613621 Debney, John, of Barneham Brome, husbandman 1
3782257 1952204 1952204 defendant Frany John smith 613621 613621 Frany, John, of Barneham Brome, smith 0
3837551 1969654 1969654 defendant Cayster Edward husbandman 613621 613621 Cayster, Edward, of Barneham Brome, husbandman 0
3837555 1969655 1969655 defendant Cayster Edward husbandman 613621 613621 Cayster, Edward, of Barneham Brome, husbandman 0
3883079 1984605 1984605 defendant Whitered Geoffrey yeoman 613621 613621 Whitered, Geoffrey, of Barneham Brome, yeoman 0
3883080 1984605 1984605 defendant Debney John husbandman 613621 613621 Debney, John, of Barneham Brome, husbandman 1
3883081 1984605 1984605 defendant Debney George husbandman 613621 613621 Debney, George, of Barneham Brome, husbandman 2
3883082 1984605 1984605 defendant Lawes John husbandman 613621 613621 Lawes, John, of Barneham Brome, husbandman 3
3883084 1984605 1984605 defendant Wryght John yeoman 613621 613621 Wryght, John, of Barneham Brome, yeoman 5
3883085 1984605 1984605 defendant Ascue Hugh yeoman 613621 613621 Ascue, Hugh, of Barneham Brome, yeoman 6
3883086 1984605 1984605 defendant Aldred Edmund husbandman 613621 613621 Aldred, Edmund, of Barneham Brome, husbandman 7
3883087 1984605 1984605 defendant Whitacre Henry tailor 613621 613621 Whitacre, Henry, of Barneham Brome, tailor 8
3883089 1984605 1984605 defendant Baye William husbandman 613621 613621 Baye, William, of Barneham Brome, husbandman 10
3883090 1984605 1984605 defendant Darby Robert tailor 613621 613621 Darby, Robert, of Barneham Brome, tailor 11
3892185 1987639 1987639 defendant Hulbarde Robert clerk 613621 613621 Hulbarde, Robert, of Barneham Brome, clerk 0
3902261 1990992 1990992 defendant Masenger John husbandman 613621 613621 Masenger, John, of Barneham Brome, husbandman 0
3932278 2001099 2001099 defendant Chapman Ralph yeoman 613621 613621 Chapman, Ralph, of Barneham Brome, yeoman 1
3948761 2006635 2006635 defendant Reymont John   613621 613621 Reymont, John, of Barneham Brome, shepherd 0
3953859 2008420 2008420 defendant Pycknett Robert tailor 613621 613621 Pycknett, Robert, of Barneham Brome, tailor 1
3983691 2018938 2018938 defendant Flemyn George husbandman 613621 613621 Flemyn, George, of Barneham Brome, husbandman 0
4015061 2030076 2030076 defendant Crane William husbandman 613621 613621 Crane, William, of Barneham Brome, husbandman 12
4033878 2036770 2036770 plaintiff Gyldersleve Richard (legal representative) 613621 613621 Gyldersleve, Richard, of Barneham Brome, yeoman, executors of 0
4053262 2043548 2043548 defendant Leke William butcher 613621 613621 Leke, William, of Barneham Brome, butcher 2
4141566 2075214 2075214 defendant Bayes Edmund husbandman 613621 613621 Bayes, Edmund, of Barneham Brome, husbandman 0
4193432 2093269 2093269 defendant Bahe Edmund carpenter 613621 613621 Bahe, Edmund, of Barneham Brome, carpenter 1
4196909 2094470 2094470 defendant Ryx William   613621 613621 Ryx, William, of Barneham Brome, wool chapman 0
4207965 2098345 2098345 defendant Mayes William husbandman 613621 613621 Mayes, William, of Barneham Brome, husbandman 1
4212260 2099834 2099834 defendant Thyxston Geoffrey husbandman 613621 613621 Thyxston, Geoffrey, of Barneham Brome, husbandman 0
4212263 2099834 2099834 defendant Ryxe William husbandman 613621 613621 Ryxe, William, of Barneham Brome, husbandman 3
4220617 2102709 2102709 defendant Chamberlyn Edward gent 613621 613621 Chamberlyn, Edward, of Barneham Brome, gent 0
4251288 2113407 2113407 defendant Flower Edmund   613621 613621 Flower, Edmund, of Barneham Brome, dornix weaver 1
5579819 2528767 2528767 defendant Lawes John yeoman 613621 613621 Lawes, John, of Barneham Brome, yeoman 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);