names

26 rows where place_id = 590997

✎ 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
3602955 1868588 1868588 defendant Clerke Maurice   590997 590997 Clerke, Maurice, of Southover juxta Lewes, wax chandler 0
3602956 1868588 1868588 defendant Michell alias Malne Richard carpenter 590997 590997 Michell alias Malne, Richard, of Southover juxta Lewes, carpenter 1
3603723 1868835 1868835 defendant Clerk Maurice   590997 590997 Clerk, Maurice, of Southover juxta Lewes, wax chandler 0
3607225 1869925 1869925 defendant Frodde Robert yeoman 590997 590997 Frodde, Robert, of Southover juxta Lewes, yeoman 0
3722308 1933238 1933238 defendant Fortune John carpenter 590997 590997 Fortune, John, of Southover juxta Lewes, carpenter 0
3722435 1933277 1933277 defendant Ledys John gent 590997 590997 Ledys, John, of Southover juxta Lewes, gent 0
3741591 1939240 1939240 plaintiff Stempe John   590997 590997 Stempe, John, of Southover juxta Lewes 0
3875319 1981989 1981989 defendant Fowle Gabriel   590997 590997 Fowle, Gabriel, of Southover juxta Lewes 0
3940650 2003879 2003879 plaintiff Stempe John, senior (legal representative) 590997 590997 Stempe, John, senior, of Southover near Lewes, executor of 0
3940654 2003880 2003880 plaintiff Stempe John, senior (legal representative) 590997 590997 Stempe, John, senior, of Southover near Lewes, executor of 0
4082218 2053953 2053953 defendant Caplyn Henry   590997 590997 Caplyn, Henry, of Southover juxta Lewes, yeoman, bachelor 0
4109742 2063742 2063742 defendant Fraunce William miller 590997 590997 Fraunce, William, of Southover juxta Lewes, miller 0
4109744 2063743 2063743 defendant Fraunce William miller 590997 590997 Fraunce, William, of Southover juxta Lewes, miller 0
4179128 2088174 2088174 defendant Jennynge Edward husbandman 590997 590997 Jennynge, Edward, of Southover juxta Lewes, husbandman 0
4228506 2105453 2105453 defendant Dennys John yeoman 590997 590997 Dennys, John, of Southover juxta Lewes, yeoman 3
4311520 2134171 2134171 defendant Sternes John yeoman 590997 590997 Sternes, John, of Southover near Lewes, yeoman 1
4375453 2156275 2156275 defendant Codwell John gent 590997 590997 (Codwell, John, of Southover juxta Lewes, gent 1
4983237 2351889 2351889 defendant Crosby William tanner 590997 590997 Crosby, William, of Southover juxta Lewes, tanner 3
5035672 2367287 2367287 defendant Crosby William tanner 590997 590997 Crosby, William, of Southover juxta Lewes, tanner 4
5035678 2367288 2367288 defendant Crosby William tanner 590997 590997 Crosby, William, of Southover juxta Lewes, tanner 4
5073530 2378568 2378568 defendant Lee Robert esq 590997 590997 Lee, Robert, of Southover juxta Lewes, esq 0
5098545 2386006 2386006 defendant Lee Robert esq 590997 590997 together with Lee, Robert, of Southover juxta Lewes, esq 1
5332534 2454795 2454795 defendant Delve William yeoman 590997 590997 Delve, William, of Southover juxta Lewes, yeoman 0
5336695 2456044 2456044 defendant Delve William yeoman 590997 590997 Delve, William, of Southover juxta Lewes, yeoman 0
5336697 2456044 2456044 defendant Delve John yeoman 590997 590997 Delve, John, of Southover juxta Lewes, yeoman 2
5577158 2527906 2527906 plaintiff Warene Richard yeoman 590997 590997 Warene, Richard, of Southover juxta Lewes, yeoman 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);