names

21 rows where place_id = 585977

✎ 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
3587613 1863771 1863771 defendant Kyngeston Thomas innholder 585977 585977 Kyngeston, Thomas, of Gildeford, Surrey, innholder 4
3858711 1976394 1976394 defendant Romsse Robert merchant 585977 585977 Romsse, Robert, of Gildeford, Surrey, merchant 1
4777506 2288958 2288958 defendant Rendhurst Thomas butcher 585977 585977 Rendhurst, Thomas, of Gildeford, Surrey, butcher 0
4781938 2290357 2290357 defendant Jankyns Robert clerk 585977 585977 Jankyns, Robert, of Gildeford, Surrey, clerk 0
4800937 2296482 2296482 defendant Syer John dyer 585977 585977 Syer, John, of Gildeford, Surrey, dyer 3
4943565 2339957 2339957 defendant Danaster John gent 585977 585977 Danaster, John, of Gildeford, Surrey, gent 3
4947199 2341114 2341114 defendant Buntyng John yeoman 585977 585977 Buntyng, John, of Gildeford, Surrey, yeoman 0
4979290 2350764 2350764 defendant Briggys William yeoman 585977 585977 Briggys, William, of Gildeford, Surrey, yeoman 3
5090779 2383693 2383693 defendant FitzJohn John yeoman 585977 585977 FitzJohn, John, of Gildeford, Surrey, yeoman 1
5216895 2420683 2420683 defendant Shawe Richard fisher 585977 585977 Shawe, Richard, of Gildeford, Surrey, fisher 0
5239569 2427159 2427159 defendant Basset Thomas esq 585977 585977 Basset, Thomas, of Gildeford, Surrey, esq 1
5278465 2438808 2438808 defendant Aunce- Thomas chapman 585977 585977 Aunce-, Thomas, of Gildeford, Surrey, chapman 0
5343770 2458237 2458237 plaintiff Striklond Agnes widow 585977 585977 Striklond, Agnes, of Gildeford, Surrey, widow 0
5347121 2459259 2459259 defendant Basset Thomas esq 585977 585977 Basset, Thomas, of Gildeford, Surrey, esq 0
5347563 2459394 2459394 defendant Basset Thomas esq 585977 585977 Basset, Thomas, of Gildeford, Surrey, esq 0
5348164 2459568 2459568 defendant Magge Thomas yeoman 585977 585977 Magge, Thomas, of Gildeford, Surrey, yeoman 1
5626272 2552185 2552185 defendant Grigge John chapman 585977 585977 Grigge, John, of Gildeford, Surrey, chapman 0
5626279 2552186 2552186 defendant Grygge John chapman 585977 585977 Grygge, John, of Gildeford, Surrey, chapman 0
5634882 2554904 2554904 defendant Figge John fuller 585977 585977 Figge, John, of Gildeford, Surrey, fuller 0
5634888 2554905 2554905 defendant Fygge John fuller 585977 585977 Fygge, John, of Gildeford, Surrey, fuller 0
5634891 2554905 2554905 defendant Caunterbury alias Maundevyle Thomas   585977 585977 Caunterbury alias Maundevyle, Thomas, of Gildeford, Surrey 3

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