names

18 rows where place_id = 637210

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3835097 1968917 1968917 defendant Belle William husbandman 637210 637210 Belle, William, of Ronwell, husbandman 1
3866688 1979092 1979092 defendant Hyde John husbandman 637210 637210 Hyde, John, of Ronwell, husbandman 0
3866689 1979092 1979092 defendant Badcok Richard husbandman 637210 637210 Badcok, Richard, of Ronwell, husbandman 1
3887076 1985941 1985941 defendant Hyde John yeoman 637210 637210 Hyde, John, of Ronwell, yeoman 0
5229431 2424217 2424217 defendant Alene John drover 637210 637210 Alene, John, of Ronwell, drover 0
5229434 2424218 2424218 defendant Oulove or Onlone John drover 637210 637210 Oulove or Onlone, John, of Ronwell, drover 0
5411140 2478289 2478289 defendant Lepar John husbandman 637210 637210 Lepar, John, of Ronwell, husbandman 1
5411141 2478289 2478289 defendant Fraunceys Thomas husbandman 637210 637210 Fraunceys, Thomas, of Ronwell, husbandman 2
5411144 2478290 2478290 defendant Lepar John husbandman 637210 637210 Lepar, John, of Ronwell, husbandman 1
5411145 2478290 2478290 defendant Fraunceys John husbandman 637210 637210 Fraunceys, John, of Ronwell, husbandman 2
5413760 2479043 2479043 plaintiff Godfrey John husbandman 637210 637210 Godfrey, John, of Ronwell, husbandman 0
5425298 2482538 2482538 defendant Leper John husbandman 637210 637210 Leper, John, of Ronwell, husbandman 1
5425299 2482538 2482538 defendant Fraunceys Thomas husbandman 637210 637210 Fraunceys, Thomas, of Ronwell, husbandman 2
5425302 2482539 2482539 defendant Leper John husbandman 637210 637210 Leper, John, of Ronwell, husbandman 1
5425303 2482539 2482539 defendant Fraunceys Thomas husbandman 637210 637210 Fraunceys, Thomas, of Ronwell, husbandman 2
5435125 2485435 2485435 defendant Hoyde John yeoman 637210 637210 Hoyde, John, of Ronwell, yeoman 1
5485863 2500664 2500664 defendant Kyng Edward laborer 637210 637210 Kyng, Edward, of Ronwell, laborer 0
5609289 2537806 2537806 defendant Hyde John yeoman 637210 637210 Hyde, John, of Ronwell, yeoman 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);