names

48 rows where place_id = 758681

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4455919 2186867 2186867 defendant Norton John   758681 758681 Norton, John, of Farlegh 2
4455920 2186867 2186867 defendant Bakere Edward   758681 758681 Bakere, Edward, of Farlegh 3
4458072 2187552 2187552 plaintiff Preston William de   758681 758681 Preston, William de, of Farlegh, prior 0
4458074 2187553 2187553 plaintiff Preston William de   758681 758681 Preston, William de, of Farlegh, prior 0
4458077 2187554 2187554 plaintiff Preston William de   758681 758681 Preston, William de, of Farlegh, prior 0
4458083 2187556 2187556 plaintiff Preston William   758681 758681 Preston, William, of Farlegh, prior 0
4465478 2189871 2189871 plaintiff Worston Nicholas   758681 758681 Worston, Nicholas, of Farlegh 0
4488536 2197136 2197136 defendant Poucy Richard   758681 758681 Poucy, Richard, of Farlegh 0
4493041 2198522 2198522 defendant Boner or Bover John   758681 758681 Boner or Bover, John, of Farlegh 1
4494041 2198822 2198822 defendant Bedel Richard   758681 758681 Bedel, Richard, of Farlegh 0
4494343 2198923 2198923 defendant Dyne William   758681 758681 Dyne, William, of Farlegh 0
4495552 2199290 2199290 defendant Gy John   758681 758681 Gy, John, of Farlegh 0
4532412 2210406 2210406 plaintiff Preston William de   758681 758681 Preston, William de, of Farlegh, prior 0
4594770 2229621 2229621 plaintiff Preston William de   758681 758681 Preston, William de, of Farlegh, prior 0
4628795 2239935 2239935 plaintiff Shareshull John   758681 758681 Shareshull, John, of Farlegh, prior 0
4651064 2246334 2246334 defendant Broke John laborer 758681 758681 Broke, John, of Farlegh, laborer 2
4665554 2250697 2250697 defendant Deen John husbandman 758681 758681 Deen, John, of Farlegh, husbandman 0
4702641 2266232 2266232 defendant Viryng William husbandman 758681 758681 Viryng, William, of Farlegh, husbandman 0
4726638 2273603 2273603 defendant Taillour John husbandman 758681 758681 Taillour, John, of Farlegh, husbandman 1
4744638 2278953 2278953 defendant Dene John husbandman 758681 758681 Dene, John, of Farlegh, husbandman 0
4748122 2279961 2279961 defendant Hole John   758681 758681 Hole, John, of Farlegh, prior 0
4817020 2301422 2301422 defendant Farlegh John husbandman 758681 758681 Farlegh, John, of Farlegh, husbandman 2
4841679 2308930 2308930 defendant Tamworth John gent 758681 758681 Tamworth, John, of Farlegh, gent 0
4869055 2317292 2317292 defendant Tamworth John gent 758681 758681 Tamworth, John, of Farlegh, gent 0
4906538 2328631 2328631 defendant Taillour John husbandman 758681 758681 Taillour, John, of Farlegh, husbandman 0
4906539 2328631 2328631 defendant Taillour William laborer 758681 758681 Taillour, William, of Farlegh, laborer 1
4906540 2328631 2328631 defendant Taillour John   758681 758681 Taillour, John, of Farlegh, servant 2
4908829 2329312 2329312 defendant Burre Thoams smith 758681 758681 Burre, Thoams, of Farlegh, smith 1
4918403 2332273 2332273 plaintiff Hakeborne John   758681 758681 Hakeborne, John, of Farlegh, parson 0
4929916 2335769 2335769 plaintiff Tamworth John   758681 758681 Tamworth, John, of Farlegh, senior 0
4929917 2335769 2335769 defendant Taillour Thomas husbandman 758681 758681 Taillour, Thomas, of Farlegh, husbandman 0
5000945 2357156 2357156 defendant Pedelesham John husbandman 758681 758681 Pedelesham, John, of Farlegh, husbandman 3
5038641 2368201 2368201 defendant Taillour Thomas (legal representative) 758681 758681 Taillour, Thomas, of Farlegh, executors of 0
5038643 2368201 2368201 defendant Taillour Robert laborer 758681 758681 Taillour, Robert, of Farlegh, laborer 2
5038644 2368201 2368201 defendant Taillour Margery widow 758681 758681 Taillour, Margery, of Farlegh, widow 3
5215878 2420376 2420376 defendant Wylkyns John yeoman 758681 758681 Wylkyns, John, of Farlegh, yeoman 1
5215880 2420376 2420376 defendant Hode William   758681 758681 Hode, William, of Farlegh, servant 3
5215882 2420376 2420376 defendant Frenshman Janyn   758681 758681 Frenshman, Janyn, of Farlegh, servant 5
5215883 2420376 2420376 defendant Yerdeley John yeoman 758681 758681 Yerdeley, John, of Farlegh, yeoman 6
5215884 2420376 2420376 defendant Pynne William   758681 758681 Pynne, William, of Farlegh, servant 7
5215968 2420397 2420397 defendant Frensheman Janyn   758681 758681 Frensheman, Janyn, of Farlegh, servant 5
5215969 2420397 2420397 defendant Pynne William   758681 758681 Pynne, William, of Farlegh, servant 6
5215970 2420397 2420397 defendant Yerdeley John yeoman 758681 758681 together with Yerdeley, John, of Farlegh, yeoman 7
5329862 2454000 2454000 defendant Gybbes William husbandman 758681 758681 Gybbes, William, of Farlegh, husbandman 0
5454576 2491283 2491283 defendant Gybbys William husbandman 758681 758681 Gybbys, William, of Farlegh, husbandman 0
5454577 2491283 2491283 defendant Motte John husbandman 758681 758681 Motte, John, of Farlegh, husbandman 1
5619720 2550028 2550028 plaintiff Preston William de   758681 758681 Preston, William de, of Farlegh, prior 0
5625658 2551967 2551967 defendant Bryan William husbandman 758681 758681 Bryan, William, of Farlegh, 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);