names

13 rows where place_id = 616115

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3712648 1930271 1930271 plaintiff Ford John   616115 616115 Ford, John, of Wesminster 3
3827926 1966598 1966598 defendant Holmes William yeoman 616115 616115 Holmes, William, of Wesminster, yeoman 0
3873934 1981502 1981502 defendant Carter John yeoman 616115 616115 Carter, John, of Wesminster, yeoman 0
3991149 2021593 2021593 plaintiff Bowett Thomas   616115 616115 Bowett, Thomas, of Wesminster, serving man 0
4006313 2027036 2027036 defendant Harford William clerk 616115 616115 Harford, William, of Wesminster, clerk 3
4276575 2121742 2121742 defendant Brigg Andrew yeoman 616115 616115 Brigg, Andrew, of Wesminster, yeoman 0
4294587 2128148 2128148 defendant Sheres Roger brewer 616115 616115 Sheres, Roger, of Wesminster, brewer 0
4349998 2147259 2147259 defendant Arnold Katherine widow 616115 616115 Katherine his wife, formerly Katherine Thornell, of Wesminster, widow 1
4600625 2231422 2231422 defendant atte Water Robert   616115 616115 atte Water, Robert, of Wesminster 4
5029366 2365465 2365465 defendant Bryce Thomas baker 616115 616115 Bryce, Thomas, of Wesminster, baker 3
5117291 2391490 2391490 defendant Berowe John esq 616115 616115 Berowe, John, of Wesminster, esq 3
5293154 2442979 2442979 defendant Leonard Richard gent 616115 616115 Leonard, Richard, of Wesminster, gent 0
5322009 2451652 2451652 plaintiff Markys William yeoman 616115 616115 Markys, William, of Wesminster, 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);