names

18 rows where place_id = 630892

✎ 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
3797256 1957028 1957028 defendant Lusun Thomas laborer 630892 630892 Lusun, Thomas, of Chelsworth, laborer 0
3928575 1999897 1999897 defendant Blomfylde John husbandman 630892 630892 Blomfylde, John, of Chelsworth, husbandman 0
3982629 2018557 2018557 defendant Leman Thomas butcher 630892 630892 Leman, Thomas, of Chelsworth, butcher 3
4080563 2053362 2053362 defendant Marchute Henry husbandman 630892 630892 Marchute, Henry, of Chelsworth, husbandman 0
4234676 2107675 2107675 defendant Dike William tanner 630892 630892 Dike, William, of Chelsworth, tanner 0
4395745 2163161 2163161 defendant Bally Thomas blacksmith 630892 630892 Bally, Thomas, of Chelsworth, blacksmith 2
4463680 2189334 2189334 defendant Dyer William   630892 630892 Dyer, William, of Chelsworth 10
4463767 2189348 2189348 defendant Dyer William   630892 630892 Dyer, William, of Chelsworth 10
4896863 2325674 2325674 defendant Smyth John butcher 630892 630892 Smyth, John, of Chelsworth, butcher 2
4978682 2350574 2350574 defendant Weyneld Simon husbandman 630892 630892 Weyneld, Simon, of Chelsworth, husbandman 0
5042751 2369439 2369439 defendant Reynold or Weynold Simon fuller 630892 630892 Reynold or Weynold, Simon, of Chelsworth, fuller 0
5058808 2374199 2374199 defendant Prynchet Simon husbandman 630892 630892 Prynchet, Simon, of Chelsworth, husbandman 0
5058809 2374199 2374199 defendant Abot Thomas weaver 630892 630892 Abot, Thomas, of Chelsworth, weaver 1
5132967 2396134 2396134 defendant Fyn Richard   630892 630892 Fyn, Richard, of Chelsworth 0
5344327 2458405 2458405 defendant Howelett John dyer 630892 630892 Howelett, John, of Chelsworth, dyer 0
5502744 2505773 2505773 defendant Howlot John dyer 630892 630892 Howlot, John, of Chelsworth, dyer 2
5516872 2510100 2510100 defendant Howlet John dyer 630892 630892 Howlet, John, of Chelsworth, dyer 0
5516875 2510101 2510101 defendant Howlot John dyer 630892 630892 Howlot, John, of Chelsworth, dyer 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);