names

18 rows where place_id = 623083

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3750572 1942097 1942097 defendant Jonys Richard husbandman 623083 623083 Jonys, Richard, of Oldbury, husbandman 0
3750580 1942099 1942099 defendant Kemes John gent 623083 623083 Kemes, John, of Oldbury, gent 0
3798654 1957489 1957489 defendant Atkyns Richard husbandman 623083 623083 Atkyns, Richard, of Oldbury, husbandman 0
3804338 1959292 1959292 defendant Tunkes William laborer 623083 623083 Tunkes, William, of Oldbury, laborer 3
3929437 2000189 2000189 defendant Rownde Thomas husbandman 623083 623083 Rownde, Thomas, of Oldbury, husbandman 0
3946947 2005995 2005995 defendant Walker Roger nailer 623083 623083 Walker, Roger, of Oldbury, nailer 1
3955438 2008967 2008967 defendant Seley Roger husbandman 623083 623083 Seley, Roger, of Oldbury, husbandman 3
3961445 2011096 2011096 defendant Tunck Henry husbandman 623083 623083 Tunck, Henry, of Oldbury, husbandman 0
3961449 2011098 2011098 defendant Tunk or Tuck Henry husbandman 623083 623083 Tunk or Tuck, Henry, of Oldbury, husbandman 0
4160371 2081703 2081703 defendant Payton Anne widow of Lawrence Richard 623083 623083 Anne his wife, alias Anne Richard, of Oldbury, widow of Lawrence Richard 1
4243778 2110899 2110899 defendant Thurston Thomas husbandman 623083 623083 Thurston, Thomas, of Oldbury, husbandman 0
4295007 2128298 2128298 defendant Watt or Wattes alis Tayler James husbandman 623083 623083 Watt or Wattes alis Tayler, James, of Oldbury, husbandman 2
4340210 2143837 2143837 defendant Oldebury alias Westwood William yeoman 623083 623083 Oldebury alias Westwood, William, of Oldbury, yeoman 3
4390055 2161294 2161294 defendant Oldebury alias Westwood William yeoman 623083 623083 Oldebury alias Westwood, William, of Oldbury, yeoman 3
4408331 2167359 2167359 defendant White Nicholas yeoman 623083 623083 White, Nicholas, of Oldbury, yeoman 0
4918311 2332246 2332246 defendant Rene or Reve Thomas   623083 623083 Rene or Reve, Thomas, of Oldbury, millward 0
4943979 2340081 2340081 defendant Ryve Thomas   623083 623083 Ryve, Thomas, of Oldbury, millward 0
5592043 2532501 2532501 defendant Kemys John gent 623083 623083 Kemys, John, of Oldbury, gent 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);