names

35 rows where place_id = 675468

✎ 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
4016681 2030674 2030674 defendant Day Henry farmer of rectory of Thrapston 675468 675468 Day, Henry, of Thrapston, Nhants, yeoman, farmer of rectory of Thrapston 0
4018782 2031449 2031449 defendant Sudlowe John clerk 675468 675468 Sudlowe, John, of Thrapston, Nhants, clerk 0
4049994 2042429 2042429 defendant Sudlowe John clerk 675468 675468 Sudlowe, John, of Thrapston, Nhants, clerk 0
4116748 2066288 2066288 defendant Knyght Edward chapman 675468 675468 Knyght, Edward, of Thrapston, Nhants, chapman 0
4262660 2117181 2117181 defendant Sherman Henry yeoman 675468 675468 Sherman, Henry, of Thrapston, Nhants, yeoman 1
4273334 2120644 2120644 defendant Sherman Henry yeoman 675468 675468 Sherman, Henry, of Thrapston, Nhants, yeoman 1
4698119 2264898 2264898 defendant del Chaumbre William   675468 675468 del Chaumbre, William, of Thrapston, Nhants, parson 0
4772433 2287345 2287345 defendant Comfort Simon drover 675468 675468 Comfort, Simon, of Thrapston, Nhants, drover 0
4834787 2306881 2306881 defendant Daundelyn John ostler 675468 675468 Daundelyn, John, of Thrapston, Nhants, ostler 3
4837121 2307563 2307563 defendant Wombe William   675468 675468 Wombe, William, of Thrapston, Nhants, cart wright 0
4839563 2308294 2308294 defendant Coumfort Simon yeoman 675468 675468 Coumfort, Simon, of Thrapston, Nhants, yeoman 1
4841122 2308757 2308757 defendant Whythng Thomas husbandman 675468 675468 (Whythng, Thomas, of Thrapston, Nhants, husbandman 1
4868335 2317073 2317073 defendant Whitlyng Thomas husbandman 675468 675468 Whitlyng, Thomas, of Thrapston, Nhants, husbandman 0
4874185 2318868 2318868 defendant Draper John woolman 675468 675468 Draper, John, of Thrapston, Nhants, woolman 0
4891276 2323998 2323998 defendant Glover Thomas glover 675468 675468 Glover, Thomas, of Thrapston, Nhants, glover 2
4907298 2328846 2328846 defendant Glover John husbandman 675468 675468 Glover, John, of Thrapston, Nhants, husbandman 0
4911638 2330141 2330141 defendant Comford Simon yeoman 675468 675468 Comford, Simon, of Thrapston, Nhants, yeoman 0
4920721 2332996 2332996 defendant Langham Geoffrey dyer 675468 675468 Langham, Geoffrey, of Thrapston, Nhants, dyer 2
4947110 2341090 2341090 defendant Comforth Simon yeoman 675468 675468 Comforth, Simon, of Thrapston, Nhants, yeoman 0
4976711 2349989 2349989 defendant Cumfort Simon yeoman 675468 675468 Cumfort, Simon, of Thrapston, Nhants, yeoman 0
4976713 2349990 2349990 defendant Cumfort Simon yeoman 675468 675468 Cumfort, Simon, of Thrapston, Nhants, yeoman 0
4982392 2351652 2351652 defendant Parker Richard yeoman 675468 675468 Parker, Richard, of Thrapston, Nhants, yeoman 1
5000704 2357082 2357082 defendant Smyth Richard smith 675468 675468 Smyth, Richard, of Thrapston, Nhants, smith 0
5007323 2359035 2359035 defendant Counford Simon husbandman 675468 675468 Counford, Simon, of Thrapston, Nhants, husbandman 0
5035689 2367292 2367292 defendant Bachon Thomas clerk 675468 675468 Bachon, Thomas, of Thrapston, Nhants, clerk 3
5035697 2367293 2367293 defendant Bachon Thomas clerk 675468 675468 Bachon, Thomas, of Thrapston, Nhants, clerk 4
5199525 2415608 2415608 defendant Comforth Simon husbandman 675468 675468 Comforth, Simon, of Thrapston, Nhants, husbandman 2
5231035 2424676 2424676 defendant Gote John yeoman 675468 675468 (Gote, John, of Thrapston, Nhants, yeoman 1
5231042 2424677 2424677 defendant Gote John yeoman 675468 675468 (Gote, John, of Thrapston, Nhants, yeoman 1
5238903 2426966 2426966 defendant Gote John yeoman 675468 675468 Gote, John, of Thrapston, Nhants, yeoman 0
5238905 2426967 2426967 defendant Gote John yeoman 675468 675468 Gote, John, of Thrapston, Nhants, yeoman 0
5317999 2450472 2450472 defendant Smyth Richard smith 675468 675468 Smyth, Richard, of Thrapston, Nhants, smith 2
5323931 2452239 2452239 defendant Thomson Joan widow 675468 675468 Thomson, Joan, of Thrapston, Nhants, widow 0
5337336 2456238 2456238 defendant Gote John yeoman 675468 675468 Gote, John, of Thrapston, Nhants, yeoman 0
5355182 2461692 2461692 defendant Osteler William husbandman 675468 675468 Osteler, William, of Thrapston, Nhants, husbandman 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);