names

16 rows where place_id = 632507

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3807015 1960088 1960088 defendant Fox James gent 632507 632507 Fox, James, of Cliffords Inn, London, gent 11
3999655 2024639 2024639 plaintiff Gardener Thomas gent 632507 632507 Gardener, Thomas, of Cliffords Inn, London, gent 0
4009858 2028303 2028303 plaintiff Nycholas Anthony gent 632507 632507 Nycholas, Anthony, of Cliffords Inn, London, gent 0
4030276 2035481 2035481 defendant Byflett John   632507 632507 Byflett, John, of Cliffords Inn, London, gent, son of Jane 1
4031547 2035948 2035948 plaintiff Floyde John gent 632507 632507 Floyde, John, of Cliffords Inn, London, gent 0
4061471 2046503 2046503 plaintiff Dyer George gent 632507 632507 Dyer, George, of Cliffords Inn, London, gent 0
4069537 2049386 2049386 defendant Gardener Thomas   632507 632507 Gardener, Thomas, of Cliffords Inn, London, gent, attorney of the bench 0
4121404 2067949 2067949 plaintiff Bosgrave John gent 632507 632507 Bosgrave, John, of Cliffords Inn, London, gent 0
4144858 2076361 2076361 defendant Browne Thomas gent 632507 632507 Browne, Thomas, of Cliffords Inn, London, gent 0
4187947 2091284 2091284 defendant Pulvertoft George gent 632507 632507 Pulvertoft, George, of Cliffords Inn, London, gent 1
4318320 2136514 2136514 defendant Dolberie Robert   632507 632507 Dolberie, Robert, of Cliffords Inn, London, gent, attorney 0
4323422 2138252 2138252 defendant Dawtrey William gent 632507 632507 Dawtrey, William, of Cliffords Inn, London, gent 3
4372416 2155201 2155201 defendant Gardyner Thomas gent 632507 632507 (Gardyner, Thomas, of Cliffords Inn, London, gent 1
4383513 2159194 2159194 defendant Coller John gent 632507 632507 Coller, John, of Cliffords Inn, London, gent 1
4397607 2163775 2163775 defendant Gardner Thomas gent 632507 632507 (Gardner, Thomas, of Cliffords Inn, London, gent 2
4403771 2165834 2165834 defendant Gardener Thomas gent 632507 632507 (Gardener, Thomas, of Cliffords Inn, London, gent 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);