names

22 rows where place_id = 607604

✎ 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
3670040 1916575 1916575 defendant Lovell John husbandman 607604 607604 Lovell, John, of Beryngton, husbandman 0
3727129 1934756 1934756 defendant Collegn Peter gent 607604 607604 Collegn, Peter, of Beryngton, gent 0
3857929 1976122 1976122 defendant Mores William husbandman 607604 607604 Mores, William, of Beryngton, husbandman 0
3922852 1997945 1997945 defendant Tavernor Paul gent 607604 607604 Tavernor, Paul, of Beryngton, gent 0
4005707 2026815 2026815 defendant Burghe William tailor 607604 607604 Burghe, William, of Beryngton, tailor 0
4030780 2035672 2035672 defendant Rowbery John, senior husbandman 607604 607604 Rowbery, John, senior, of Beryngton, husbandman 0
4030781 2035672 2035672 defendant Ryse Richard laborer 607604 607604 Ryse, Richard, of Beryngton, laborer 1
4045282 2040771 2040771 plaintiff Rychard Margery spinster 607604 607604 Margery his wife, formerly Margery Bryght, of Beryngton, spinster 1
4045285 2040772 2040772 plaintiff Rychard Margery spinster 607604 607604 Margery his wife, formerly Margery Bryght, of Beryngton, spinster 1
4128348 2070426 2070426 defendant Holte Roger yeoman 607604 607604 Holte, Roger, of Beryngton, yeoman 1
4139945 2074651 2074651 defendant Holte Roger husbandman 607604 607604 Holte, Roger, of Beryngton, husbandman 1
4150602 2078344 2078344 defendant Adams John gent 607604 607604 Adams, John, of Beryngton, gent 0
4199398 2095339 2095339 defendant Bridge William husbandman 607604 607604 Bridge, William, of Beryngton, husbandman 0
4361856 2151401 2151401 defendant Naishe John husbandman 607604 607604 Naishe, John, of Beryngton, husbandman 1
4386402 2160131 2160131 defendant Gushe John husbandman 607604 607604 Gushe, John, of Beryngton, husbandman 2
4401710 2165166 2165166 defendant Rosberye Edward husbamdman 607604 607604 Rosberye, Edward, of Beryngton, husbamdman 3
4657000 2248080 2248080 defendant Monketon John gent 607604 607604 Monketon, John, of Beryngton, gent 3
5018899 2362415 2362415 defendant Coke Thomas husbandman 607604 607604 Coke, Thomas, of Beryngton, husbandman 2
5347418 2459356 2459356 defendant Chamber Thomas, junior husbandman 607604 607604 Chamber, Thomas, junior, of Beryngton, husbandman 0
5391413 2472621 2472621 defendant Venteman John milner 607604 607604 Venteman, John, of Beryngton, milner 2
5625931 2552064 2552064 defendant Fissher John husbandman 607604 607604 Fissher, John, of Beryngton, husbandman 0
5625933 2552065 2552065 defendant Wykyng Thomas husbandman 607604 607604 Wykyng, Thomas, of Beryngton, husbandman 0

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