names

18 rows where place_id = 637324

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3835775 1969114 1969114 defendant Thwaytes Edward   637324 637324 Thwaytes, Edward, of Chilham, Kent 0
3981886 2018280 2018280 defendant Twaight Edward gent 637324 637324 Twaight, Edward, of Chilham, Kent, gent 1
3997235 2023780 2023780 defendant Mill Richard draper 637324 637324 Mill, Richard, of Chilham, Kent, draper 0
4078922 2052759 2052759 plaintiff Thwaytes Edward gent 637324 637324 Thwaytes, Edward, of Chilham, Kent, gent 0
4098774 2059891 2059891 defendant Hadd Arnold gent 637324 637324 Hadd, Arnold, of Chilham, Kent, gent 0
4098780 2059893 2059893 defendant Pettit William gent 637324 637324 Pettit, William, of Chilham, Kent, gent 0
4098783 2059894 2059894 defendant Petytt William gent 637324 637324 Petytt, William, of Chilham, Kent, gent 0
4142122 2075421 2075421 defendant Streynsham John gent 637324 637324 Streynsham, John, of Chilham, Kent, gent 0
4184153 2089954 2089954 defendant Pettyte William gent 637324 637324 Pettyte, William, of Chilham, Kent, gent 0
4335828 2142262 2142262 defendant Bungey Jonah gent 637324 637324 Bungey, Jonah, of Chilham, Kent, gent 0
4493286 2198604 2198604 plaintiff Bade Richard   637324 637324 Bade, Richard, of Chilham, Kent, on his own account 0
4675534 2257958 2257958 defendant Derby William   637324 637324 Derby, William, of Chilham, Kent, vicar 4
4989510 2353797 2353797 defendant Bak Denis chapman 637324 637324 Bak, Denis, of Chilham, Kent, chapman 0
5062771 2375413 2375413 defendant Meredyth Morgan esq 637324 637324 Meredyth, Morgan, of Chilham, kent, esq 4
5062812 2375417 2375417 defendant Meredyth Morgan esq 637324 637324 Meredyth, Morgan, of Chilham, Kent, esq 4
5065951 2376339 2376339 defendant Haddon William husbandman 637324 637324 Haddon, William, of Chilham, Kent, husbandman 0
5294700 2443431 2443431 defendant Beverley Thomas   637324 637324 Beverley, Thomas, of Chilham, Kent, franklin 1
5519498 2510939 2510939 defendant Huntlowe Hugh clerk 637324 637324 Huntlowe, Hugh, of Chilham, Kent, clerk 5

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