names

47 rows where place_id = 590725

✎ 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
3602097 1868319 1868319 defendant Cokke William husbandman 590725 590725 Cokke, William, of Ellerker, husbandman 0
3808590 1960564 1960564 defendant Medley William husbandman 590725 590725 Medley, William, of Ellerker, husbandman 0
3971534 2014606 2014606 plaintiff Estofte Christopher (legal representative) 590725 590725 Estofte, Christopher, of Ellerker, or of Beverley, esq, administratrix of 0
4004341 2026332 2026332 defendant Ellerker William esq 590725 590725 Ellerker, William, of Ellerker, esq 0
4061857 2046637 2046637 defendant Eyr Walter yeoman 590725 590725 Eyr, Walter, of Ellerker, yeoman 0
4392825 2162216 2162216 defendant Meyson John chapman 590725 590725 Meyson, John, of Ellerker, chapman 1
4458571 2187730 2187730 defendant Marchall William   590725 590725 Marchall, William, of Ellerker 4
4510815 2203840 2203840 defendant Godsalf Peter   590725 590725 Godsalf, Peter, of Ellerker 2
4518101 2206033 2206033 defendant Scot John   590725 590725 Scot, John, of Ellerker 7
4519253 2206375 2206375 defendant Taillour Thomas   590725 590725 Taillour, Thomas, of Ellerker 0
4535547 2211391 2211391 defendant Fissher John   590725 590725 Fissher, John, of Ellerker 2
4618591 2236825 2236825 defendant Hoton William tanner 590725 590725 Hoton, William, of Ellerker, tanner 0
4618592 2236825 2236825 defendant Hoton John   590725 590725 Hoton, John, of Ellerker, son of William 1
4625997 2239087 2239087 defendant Wryght William   590725 590725 Wryght, William, of Ellerker 0
4631107 2240626 2240626 defendant Robertson John   590725 590725 Robertson, John, of Ellerker 0
4660070 2248991 2248991 defendant Roberdson John husbandman 590725 590725 Roberdson, John, of Ellerker, husbandman 8
4673687 2257399 2257399 defendant Knapton Henry milner 590725 590725 Knapton, Henry, of Ellerker, milner 0
4685455 2261047 2261047 defendant Robertson John husbandman 590725 590725 Robertson, John, of Ellerker, husbandman 4
4699827 2265391 2265391 defendant Marshall Gillian widow 590725 590725 (Marshall, Gillian, of Ellerker, widow 1
4699828 2265391 2265391 defendant Anson Richard husbandman 590725 590725 Anson, Richard, of Ellerker, husbandman 2
4752270 2281129 2281129 defendant Robertson John husbandman 590725 590725 Robertson, John, of Ellerker, husbandman 3
4793741 2294161 2294161 defendant Taillour Thomas husbandman 590725 590725 Taillour, Thomas, of Ellerker, husbandman 0
4798500 2295709 2295709 defendant Robertson John yeoman 590725 590725 Robertson, John, of Ellerker, yeoman 0
4798501 2295709 2295709 defendant de la Bekk Simon husbandman 590725 590725 de la Bekk, Simon, of Ellerker, husbandman 1
4815764 2301033 2301033 defendant Robertson John yeoman 590725 590725 Robertson, John, of Ellerker, yeoman 0
4859679 2314400 2314400 defendant Goldyng Thomas husbandman 590725 590725 Goldyng, Thomas, of Ellerker, husbandman 0
4900490 2326795 2326795 defendant Robertson John husbandman 590725 590725 Robertson, John, of Ellerker, husbandman 2
4923670 2333839 2333839 defendant Sydehare Thomas chapman 590725 590725 Sydehare, Thomas, of Ellerker, chapman 0
5001874 2357448 2357448 defendant Pate Robert husbandman 590725 590725 Pate, Robert, of Ellerker, husbandman 1
5018893 2362413 2362413 defendant Robertson John husbandman 590725 590725 Robertson, John, of Ellerker, husbandman 0
5115794 2391045 2391045 defendant Cokke Thomas husbandman 590725 590725 Cokke, Thomas, of Ellerker, husbandman 3
5152375 2401827 2401827 defendant del Butre Joan widow 590725 590725 del Butre, Joan, of Ellerker, widow 1
5159569 2403915 2403915 defendant Cartwryght Edward husbandman 590725 590725 Cartwryght, Edward, of Ellerker, husbandman 2
5189344 2412617 2412617 defendant Cok Thomas husbandman 590725 590725 Cok, Thomas, of Ellerker, husbandman 0
5191814 2413340 2413340 defendant Cartwryght Edward husbandman 590725 590725 Cartwryght, Edward, of Ellerker, husbandman 0
5191815 2413340 2413340 defendant Cosyn George husbandman 590725 590725 Cosyn, George, of Ellerker, husbandman 1
5191816 2413340 2413340 defendant Bolewe Richard husbandman 590725 590725 Bolewe, Richard, of Ellerker, husbandman 2
5191817 2413340 2413340 defendant Hauson Simon husbandman 590725 590725 Hauson, Simon, of Ellerker, husbandman 3
5195390 2414402 2414402 defendant Cartwryght Edward husbandman 590725 590725 Cartwryght, Edward, of Ellerker, husbandman 2
5292280 2442745 2442745 defendant Riplyngham John, junior yeoman 590725 590725 Riplyngham, John, junior, of Ellerker, yeoman 1
5301807 2445497 2445497 defendant Ripplyngham John yeoman 590725 590725 Ripplyngham, John, of Ellerker, yeoman 0
5337799 2456383 2456383 defendant Ryplyngham John husbandman 590725 590725 Ryplyngham, John, of Ellerker, husbandman 0
5351717 2460638 2460638 defendant Ripplyngham John yeoman 590725 590725 Ripplyngham, John, of Ellerker, yeoman 0
5351718 2460638 2460638 defendant Ripplyngham Richard husbandman 590725 590725 Ripplyngham, Richard, of Ellerker, husbandman 1
5512020 2508619 2508619 defendant Cok William husbandman 590725 590725 Cok, William, of Ellerker, husbandman 0
5512024 2508620 2508620 defendant Cok William husbandman 590725 590725 Cok, William, of Ellerker, husbandman 0
5555893 2521716 2521716 defendant Ellerker John gent 590725 590725 Ellerker, John, of Ellerker, gent 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);