names

13 rows where place_id = 759797

✎ 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
3713334 1930484 1930484 defendant Byrkys John   759797 759797 Byrkys, John, of Thorn, wright 0
4464410 2189541 2189541 plaintiff Thomson Henry   759797 759797 Thomson, Henry, of Thorn 1
4464414 2189541 2189541 defendant Tharson John   759797 759797 Tharson, John, of Thorn 1
4494132 2198856 2198856 plaintiff Bilyngham Thomas   759797 759797 Bilyngham, Thomas, of Thorn 0
4494133 2198856 2198856 plaintiff Andrewe Rcihard   759797 759797 Andrewe, Rcihard, of Thorn 1
4537740 2212080 2212080 defendant Sydse Alan de   759797 759797 Sydse, Alan de, of Thorn, son of John 0
4537741 2212080 2212080 defendant Wilkynson John   759797 759797 Wilkynson, John, of Thorn 1
4679227 2259111 2259111 defendant Whitston Baldwin husbandman 759797 759797 Whitston, Baldwin, of Thorn, husbandman 2
4694411 2263752 2263752 defendant Tudde John clerk 759797 759797 Tudde, John, of Thorn, clerk 1
4919767 2332687 2332687 defendant Yeward Thomas husbandman 759797 759797 Yeward, Thomas, of Thorn, husbandman 1
4921907 2333255 2333255 defendant Gayte Richard husbandman 759797 759797 Gayte, Richard, of Thorn, husbandman 1
4922200 2333358 2333358 defendant Gayte Richard husbandman 759797 759797 Gayte, Richard, of Thorn, husbandman 1
5054709 2372986 2372986 defendant Aleyne Richard husbandman 759797 759797 Aleyne, Richard, of Thorn, husbandman 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);