names

11 rows where place_id = 586804

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589659 1864408 1864408 defendant Fetiplace William gent 586804 586804 Fetiplace, William, of Chelrey, Berks, gent 0
4709860 2268442 2268442 defendant Cokercell Thomas gent 586804 586804 Cokercell, Thomas, of Chelrey, Berks, gent 0
4983126 2351854 2351854 defendant Walrond William gent 586804 586804 Walrond, William, of Chelrey, Berks, gent 11
5360106 2463201 2463201 defendant Kyngeston Thomas esq 586804 586804 Kyngeston, Thomas, of Chelrey, Berks, esq 0
5391638 2472678 2472678 defendant Kyngeston Thomas esq 586804 586804 Kyngeston, Thomas, of Chelrey, Berks, esq 0
5442358 2487636 2487636 defendant Godard John husbandman 586804 586804 Godard, John, of Chelrey, Berks, husbandman 0
5453565 2490959 2490959 defendant Kynges_ Thomas esq 586804 586804 Kynges_, Thomas, of Chelrey, Berks, esq 1
5462562 2493714 2493714 defendant Godard John husbandman 586804 586804 Godard, John, of Chelrey, Berks, husbandman 0
5474095 2497231 2497231 defendant Edward John husbandman 586804 586804 Edward, John, of Chelrey, , Berks, husbandman 0
5485547 2500588 2500588 defendant Godard John husbandman 586804 586804 Godard, John, of Chelrey, Berks, husbandman 0
5512001 2508611 2508611 defendant Kyngeston Thomas esq 586804 586804 Kyngeston, Thomas, of Chelrey, Berks, esq 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);