names

18 rows where place_id = 590858

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602532 1868452 1868452 defendant Note William husbandman 590858 590858 Note, William, of Mauteby, husbandman 0
3614781 1872274 1872274 defendant Hevenyngham Thomas clerk 590858 590858 Hevenyngham, Thomas, of Mauteby, clerk 0
4560595 2219255 2219255 defendant Willes Robert   590858 590858 Willes, Robert, of Mauteby 2
4643530 2244208 2244208 defendant Purdon Roger   590858 590858 Purdon, Roger, of Mauteby 3
4909790 2329585 2329585 plaintiff Begge John   590858 590858 Begge, John, of Mauteby, parson 0
5157461 2403316 2403316 defendant Banham Robert husbandman 590858 590858 Banham, Robert, of Mauteby, husbandman 1
5173369 2407918 2407918 defendant Banham Robert husbandman 590858 590858 Banham, Robert, of Mauteby, husbandman 1
5270105 2436359 2436359 defendant Coteler Robert clerk 590858 590858 Coteler, Robert, of Mauteby, clerk 14
5274141 2437515 2437515 defendant Ponde alias Dey John husbandman 590858 590858 Ponde alias Dey, John, of Mauteby, husbandman 0
5388043 2471639 2471639 plaintiff Gerard Simon yeoman 590858 590858 Gerard, Simon, of Mauteby, yeoman 0
5400576 2475231 2475231 plaintiff Garrard Simon yeoman 590858 590858 Garrard, Simon, of Mauteby, yeoman 0
5410562 2478105 2478105 defendant Bataly William, sen husbandman 590858 590858 Bataly, William, sen, of Mauteby, husbandman 0
5413679 2479014 2479014 plaintiff Gerard Simon yeoman 590858 590858 Gerard, Simon, of Mauteby, yeoman 0
5424465 2482288 2482288 defendant Bataly William, sen husbandman 590858 590858 Bataly, William, sen, of Mauteby, husbandman 0
5428995 2483593 2483593 plaintiff Gerard Simon yeoman 590858 590858 Gerard, Simon, of Mauteby, yeoman 0
5446184 2488744 2488744 plaintiff Gerard Simon yeoman 590858 590858 Gerard, Simon, of Mauteby, yeoman 0
5458824 2492531 2492531 plaintiff Gerard Simon yeoman 590858 590858 Gerard, Simon, of Mauteby, yeoman 0
5631516 2553865 2553865 defendant Mauteby Robert esq 590858 590858 Mauteby, Robert, of Mauteby, esq 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);