names

15 rows where place_id = 738851

✎ 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
4332390 2141123 2141123 defendant Bradie or Braddye George gent 738851 738851 Bradie or Braddye, George, of Fen Ditton, gent 0
4568108 2221594 2221594 defendant Tollere Hubert   738851 738851 Tollere, Hubert, of Fen Ditton 0
4568110 2221594 2221594 defendant Cumnore Thomas   738851 738851 Cumnore, Thomas, of Fen Ditton 2
4761431 2283919 2283919 defendant Chapman John coler maker 738851 738851 Chapman, John, of Fen Ditton, coler maker 0
4916100 2331536 2331536 defendant Clerk Walter husbandman 738851 738851 Clerk, Walter, of Fen Ditton, husbandman 4
5017537 2362015 2362015 plaintiff Cheyne Lawrence esq 738851 738851 Cheyne, Lawrence, of Fen Ditton, esq 0
5104957 2387889 2387889 plaintiff Chenee Lawrence esq 738851 738851 Chenee, Lawrence, of Fen Ditton, esq 0
5104959 2387889 2387889 defendant Byerdon William husbandman 738851 738851 Byerdon, William, of Fen Ditton,husbandman 1
5203259 2416717 2416717 plaintiff Cheyny Lawrence esq 738851 738851 Cheyny, Lawrence, of Fen Ditton, esq 0
5278884 2438935 2438935 defendant Cheyne John   738851 738851 Cheyne, John, of Fen Ditton, knight 0
5299645 2444867 2444867 defendant Cheyne John   738851 738851 Cheyne, John, of Fen Ditton, knight 0
5299647 2444867 2444867 defendant Canne John yeoman 738851 738851 Canne, John, of Fen Ditton, yeoman 2
5299654 2444869 2444869 defendant Godoke Thomas gent 738851 738851 Godoke, Thomas, of Fen Ditton, gent 0
5299656 2444869 2444869 defendant Cheyne John   738851 738851 together with Cheyne, John, of Fen Ditton, knight 2
5299658 2444869 2444869 defendant Canne John yeoman 738851 738851 Canne, John, of Fen Ditton, yeoman 4

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