names

22 rows where place_id = 768157

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4546599 2214864 2214864 defendant Neuman Thomas   768157 768157 Neuman, Thomas, of Sydelesham 3
4663565 2250084 2250084 defendant Whussh John, senior gent 768157 768157 Whussh, John, senior, of Sydelesham, gent 0
4663567 2250084 2250084 defendant Pykeron William husbandman 768157 768157 (Pykeron, William, of Sydelesham, husbandman 2
4663568 2250084 2250084 defendant Gysburgh John husbandman 768157 768157 Gysburgh, John, of Sydelesham, husbandman 3
4679242 2259115 2259115 defendant Toky Robert seaman 768157 768157 Toky, Robert, of Sydelesham, seaman 0
4698594 2265035 2265035 defendant Lawe Henry husbandman 768157 768157 Lawe, Henry, of Sydelesham, husbandman 0
4711381 2268892 2268892 defendant Jogell John shipman 768157 768157 Jogell, John, of Sydelesham, shipman 1
4711382 2268892 2268892 defendant atte Londe John husbandman 768157 768157 atte Londe, John, of Sydelesham, husbandman 2
4747293 2279711 2279711 defendant Pykeron William husbandman 768157 768157 Pykeron, William, of Sydelesham, husbandman 1
4747302 2279714 2279714 defendant Manewode John husbandman 768157 768157 Manewode, John, of Sydelesham, husbandman 1
4747319 2279718 2279718 defendant Pokeron Willim husbandman 768157 768157 Pokeron, Willim, of sydelesham, husbandman 1
4884603 2322096 2322096 defendant Lawe Henry husbandman 768157 768157 Lawe, Henry, of Sydelesham, husbandman 0
4912531 2330420 2330420 defendant Warener Richard smith 768157 768157 Warener, Richard, of Sydelesham, smith 2
5000907 2357143 2357143 defendant Walshe Henry husbandman 768157 768157 Walshe, Henry, of Sydelesham, husbandman 0
5133643 2396334 2396334 defendant Fuller Robert husbandman 768157 768157 Fuller, Robert, of Sydelesham, husbandman 0
5133646 2396335 2396335 defendant Fuller Robert husbandman 768157 768157 Fuller, Robert, of Sydelesham, husbandman 0
5133649 2396336 2396336 defendant Fuller Robert husbandman 768157 768157 Fuller, Robert, of Sydelesham, husbandman 0
5138683 2397811 2397811 defendant Manwode William husbandman 768157 768157 Manwode, William, of Sydelesham, husbandman 0
5139045 2397913 2397913 defendant Swalshe Clarice widow 768157 768157 Swalshe, Clarice, of Sydelesham, widow 0
5139046 2397913 2397913 defendant Walshe Robert laborer 768157 768157 Walshe, Robert, of Sydelesham, laborer 1
5139047 2397913 2397913 defendant Walshe Richard laborer 768157 768157 Walshe, Richard, of Sydelesham, laborer 2
5228938 2424067 2424067 defendant atte Water Flynt cordwainer 768157 768157 atte Water, Flynt, of Sydelesham, cordwainer 2

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