names

16 rows where place_id = 589147

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596680 1866598 1866598 defendant Faukener John clerk 589147 589147 Faukener, John, of Wesebury, clerk 0
3669682 1916457 1916457 defendant Stevyns Richard husbandman 589147 589147 Stevyns, Richard, of Wesebury, husbandman 0
3700705 1926472 1926472 defendant Malson Thomas husbandman 589147 589147 Malson, Thomas, of Wesebury, or of la Courte, Rodley, husbandman 0
4768496 2286121 2286121 defendant Wodeford Richard clerk 589147 589147 Wodeford, Richard, of Wesebury, clerk 1
4797968 2295548 2295548 defendant Wynthull William butcher 589147 589147 Wynthull, William, of Wesebury, butcher 0
4928844 2335443 2335443 defendant Yonge Richard husbandman 589147 589147 Yonge, Richard, of Wesebury, husbandman 2
5078703 2380118 2380118 defendant Hyll William yeoman 589147 589147 Hyll, William, of Wesebury, yeoman 1
5101255 2386777 2386777 defendant Smokyer Roger husbandman 589147 589147 Smokyer, Roger, of Wesebury, husbandman 1
5101256 2386777 2386777 defendant Smokyer Thomas husbandman 589147 589147 Smokyer, Thomas, of Wesebury, husbandman 2
5282503 2439942 2439942 defendant Chynne John husbandman 589147 589147 Chynne, John, of Wesebury, husbandman 2
5282504 2439942 2439942 defendant Malveson or Malneson John husbandman 589147 589147 Malveson or Malneson, John, of Wesebury, husbandman 3
5317862 2450429 2450429 defendant Boweley or Boly Richard yeoman 589147 589147 Boweley or Boly, Richard, of Wesebury, or of Wytnestre, yeoman 0
5483546 2500026 2500026 defendant Wodhouse Thomas husbandman 589147 589147 Wodhouse, Thomas, of Wesebury, husbandman 0
5605297 2536535 2536535 defendant Hampton Roger husbandman 589147 589147 Hampton, Roger, of Wesebury, husbandman 1
5605298 2536535 2536535 defendant Menske John yeoman 589147 589147 Menske, John, of Wesebury, yeoman 2
5605299 2536535 2536535 defendant Daysse Thomas husbandman 589147 589147 Daysse, Thomas, of Wesebury, husbandman 3

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