names

22 rows where place_id = 634538

✎ 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
3819515 1963982 1963982 defendant Lokke John husbandman 634538 634538 Lokke, John, of Preston, Glos, husbandman 0
3823648 1965294 1965294 defendant Loke John, junior husbandman 634538 634538 Loke, John, junior, of Preston, Glos, husbandman 4
4001143 2025186 2025186 defendant Smyth John husbandman 634538 634538 Smyth, John, of Preston, Glos, husbandman 0
4004470 2026376 2026376 defendant Drewe John yeoman 634538 634538 Drewe, John, of Preston, Glos, yeoman 0
4064190 2047466 2047466 defendant Hunck Thomas gent 634538 634538 Hunck, Thomas, of Preston, Glos, gent 0
4095947 2058882 2058882 defendant Langston Edmund gent 634538 634538 Langston, Edmund, of Preston, Glos, gent 0
4131746 2071670 2071670 defendant Hamlet Robert yeoman 634538 634538 Hamlet, Robert, of Preston, Glos, yeoman 1
4159840 2081510 2081510 defendant Phyllippes David husbandman 634538 634538 Phyllippes, David, of Preston, Glos, husbandman 1
4210062 2099081 2099081 defendant Taylor Henry tailor 634538 634538 Taylor, Henry, of Preston, Glos, tailor 0
4215717 2100994 2100994 defendant Gondye or Goudye John yeoman 634538 634538 Gondye or Goudye, John, of Preston, Glos, yeoman 1
4243783 2110900 2110900 defendant Nurthen Richard yeoman 634538 634538 Nurthen, Richard, of Preston, Glos, yeoman 1
4293609 2127778 2127778 defendant Drewe Thomas husbandman 634538 634538 Drewe, Thomas, of Preston, Glos, husbandman 2
4294782 2128219 2128219 defendant Drewe Thomas yeoman 634538 634538 Drewe, Thomas, of Preston, Glos, yeoman 2
4334416 2141789 2141789 defendant Drewe Thomas yeoman 634538 634538 Drewe, Thomas, of Preston, Glos, yeoman 0
4370270 2154425 2154425 defendant Nurden Richard yeoman 634538 634538 Nurden, Richard, of Preston, Glos, yeoman 1
4407561 2167094 2167094 defendant Hamlett Robert yeoman 634538 634538 Hamlett, Robert, of Preston, Glos, yeoman 0
4407578 2167100 2167100 defendant Hamblett Robert yeoman 634538 634538 Hamblett, Robert, of Preston, Glos, yeoman 0
4780115 2289783 2289783 defendant Drewe William husbandman 634538 634538 Drewe, William, of Preston, Glos, husbandman 10
5052792 2372429 2372429 defendant Pullen Thomas gent 634538 634538 Pullen, Thomas, of Preston, Glos, gent 3
5052796 2372430 2372430 defendant Pullem Thomas gent 634538 634538 Pullem, Thomas, of Preston, Glos, gent 2
5294328 2443315 2443315 defendant Moysy William husbandman 634538 634538 Moysy, William, of Preston, Glos, husbandman 1
5294332 2443316 2443316 defendant Moysy William husbandman 634538 634538 Moysy, William, of Preston, Glos, husbandman 1

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