names

13 rows where place_id = 624796

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3760343 1945238 1945238 defendant Whithere William husbandman 624796 624796 Whithere, William, of Anport, husbandman 0
5262311 2433963 2433963 defendant Galyot Robert husbandman 624796 624796 Galyot, Robert, of Anport, husbandman 1
5263443 2434314 2434314 defendant Whitehere John husbandman 624796 624796 Whitehere, John, of Anport, husbandman 6
5387639 2471531 2471531 defendant Thonder Gerard   624796 624796 Thonder, Gerard, of Anport 3
5387902 2471598 2471598 defendant Thonder Gerard   624796 624796 Thonder, Gerard, of Anport 3
5394461 2473478 2473478 defendant Thonder or Chouder Gerard   624796 624796 Thonder or Chouder, Gerard, of Anport 3
5400258 2475147 2475147 defendant Thonder Gerard   624796 624796 Thonder, Gerard, of Anport, Miller, Wlliam, of Clatford 3
5400518 2475215 2475215 defendant Thonder Gerard   624796 624796 Thonder, Gerard, of Anport, Miller, Wlliam, of Clatford 3
5407465 2477206 2477206 defendant Thonder Gerard   624796 624796 Thonder, Gerard, of Anport, Miller, Wlliam, of Clatford 3
5420703 2481117 2481117 defendant Thonder Gerard   624796 624796 Thonder, Gerard, of Anport 3
5464385 2494260 2494260 defendant Whyether John husbandman 624796 624796 Whyether, John, of Anport, husbandman 0
5464387 2494261 2494261 defendant Wyether John husbandman 624796 624796 Wyether, John, of Anport, husbandman 0
5487426 2501136 2501136 defendant Wyether John husbandman 624796 624796 Wyether, John, of Anport, husbandman 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);