names

22 rows where place_id = 596451

✎ 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
3624849 1875307 1875307 defendant Ragon John yeoman 596451 596451 Ragon, John, of Hereford Est, yeoman 1
3653083 1911294 1911294 plaintiff Williams John skinner 596451 596451 Williams, John, of Hereford Est, skinner 0
3667048 1915633 1915633 defendant Floyd Roger chapman 596451 596451 Floyd, Roger, of Hereford East, chapman 1
3774828 1949855 1949855 defendant Hays Nicholas dyer 596451 596451 Hays, Nicholas, of Hereford Est, dyer 0
3774829 1949855 1949855 defendant Bouthloyd William tehoman 596451 596451 Bouthloyd, William, of Hereford Est, tehoman 1
3945926 2005655 2005655 defendant Huggen Thomas capper 596451 596451 Huggen, Thomas, of Hereford Est, capper 0
3945927 2005655 2005655 defendant Spylwater Nicholas   596451 596451 Spylwater, Nicholas, of Hereford Est 1
4015083 2030083 2030083 defendant Bromwyche Richard mercer 596451 596451 Bromwyche, Richard, of Hereford East, mercer 0
4077227 2052140 2052140 defendant Ryce Roland chapman 596451 596451 Ryce, Roland, of Hereford East, chapman 1
5035628 2367278 2367278 defendant May William goldsmith 596451 596451 May, William, of Hereford Est, goldsmith 1
5063355 2375569 2375569 defendant Asshby Thomas clerk 596451 596451 (Asshby, Thomas, of Hereford Est, clerk 5
5063363 2375570 2375570 defendant Assheby Thomas clerk 596451 596451 (Assheby, Thomas, of Hereford Est, clerk 5
5079028 2380212 2380212 defendant Glover John dyer 596451 596451 Glover, John, of Hereford Est, dyer 0
5120667 2392475 2392475 defendant Chipnam John mercer 596451 596451 Chipnam, John, of Hereford Est, mercer 0
5353653 2461212 2461212 defendant Goldsmyth John goldsmith 596451 596451 Goldsmyth, John, of Hereford Est, goldsmith 4
5353659 2461213 2461213 defendant Goldesmyth John goldsmith 596451 596451 Goldesmyth, John, of Hereford Est, goldsmith 4
5522592 2511891 2511891 plaintiff Draper Henry chaplain 596451 596451 Draper, Henry, of Hereford Est, chaplain 0
5522594 2511892 2511892 plaintiff Draper John chaplain 596451 596451 Draper, John, of Hereford Est, chaplain 0
5529028 2513598 2513598 plaintiff Osburne John clothier 596451 596451 Osburne, John, of Hereford Est, clothier 0
5529030 2513599 2513599 plaintiff Osburne John clothier 596451 596451 Osburne, John, of Hereford Est, clothier 0
5557023 2522012 2522012 defendant Walle George mercer 596451 596451 Walle, George, of Hereford Est, mercer 2
5558618 2522472 2522472 defendant Whietwodde John yeoman 596451 596451 Whietwodde, John, of Hereford Est, yeoman 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);