names

26 rows where place_id = 795409

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4745934 2279315 2279315 defendant Marchall Stephen husbandman 795409 795409 Marchall, Stephen, of Hiegham Ferrers, husbandman 0
4925103 2334283 2334283 defendant Glover John husbandman 795409 795409 Glover, John, of Hiegham Ferrers, husbandman 3
5079899 2380468 2380468 defendant Jafret Thomas   795409 795409 Jafret, Thomas, of Hiegham Ferrers, oil maker 0
5079900 2380468 2380468 defendant Mayons John   795409 795409 Mayons, John, of Hiegham Ferrers, mason 1
5079904 2380468 2380468 defendant Baker William husbandman 795409 795409 Baker, William, of Hiegham Ferrers, husbandman 5
5138340 2397723 2397723 defendant Druell William chaplain 795409 795409 Druell, William, of Hiegham Ferrers, chaplain 5
5147078 2400283 2400283 defendant Magot Henry butcher 795409 795409 Magot, Henry, of Hiegham Ferrers, butcher 0
5147081 2400283 2400283 defendant Lynnessey Alexander yeoman 795409 795409 Lynnessey, Alexander, of Hiegham Ferrers, yeoman 3
5163194 2404967 2404967 plaintiff Wellys John   795409 795409 Wellys, John, of Hiegham Ferrers 0
5194984 2414284 2414284 defendant Algar John husbandman 795409 795409 Algar, John, of Hiegham Ferrers, husbandman 1
5194985 2414284 2414284 defendant Carter John smith 795409 795409 Carter, John, of Hiegham Ferrers, smith 2
5194986 2414284 2414284 defendant Maye John   795409 795409 Maye, John, of Hiegham Ferrers, mason 3
5199434 2415583 2415583 defendant butcher William butcher 795409 795409 butcher, William, of Hiegham Ferrers, butcher 2
5239527 2427143 2427143 defendant Smyth William yeoman 795409 795409 Smyth, William, of Hiegham Ferrers, yeoman 3
5250540 2430277 2430277 defendant Rudde Thomas clerk 795409 795409 Rudde, Thomas, of Hiegham Ferrers, clerk 0
5273349 2437276 2437276 defendant Bere William husbandman 795409 795409 Bere, William, of Hiegham Ferrers, husbandman 0
5273350 2437276 2437276 defendant Pykerell Henry chandler 795409 795409 Pykerell, Henry, of Hiegham Ferrers, chandler 1
5273351 2437276 2437276 defendant Fythyan John husbandman 795409 795409 Fythyan, John, of Hiegham Ferrers, husbandman 2
5278077 2438679 2438679 defendant Drenwell Richard husbandman 795409 795409 Drenwell, Richard, of Hiegham Ferrers, husbandman 2
5302570 2445743 2445743 plaintiff Bartlot John   795409 795409 (Bartlot, John, of Hiegham Ferrers 1
5306191 2446839 2446839 plaintiff Martyn alias Marten Thomas   795409 795409 Martyn alias Marten, Thomas, of Hiegham Ferrers 0
5306251 2446853 2446853 plaintiff Martyn Thomas   795409 795409 Martyn, Thomas, of Hiegham Ferrers 0
5312658 2448822 2448822 defendant Wyngrave John tailor 795409 795409 Wyngrave, John, of Hiegham Ferrers, tailor 4
5322091 2451680 2451680 defendant Sculle William yeoman 795409 795409 Sculle, William, of Hiegham Ferrers, yeoman 0
5322092 2451680 2451680 defendant Draper Henry yeoman 795409 795409 Draper, Henry, of Hiegham Ferrers, yeoman 1
5322096 2451680 2451680 defendant Stucle Alice widow 795409 795409 Stucle, Alice, of Hiegham Ferrers, widow 5

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