names

36 rows where place_id = 590437

✎ 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
3601208 1868040 1868040 defendant Holme Richard innholder 590437 590437 Holme, Richard, of Dorchester, Oxon, innholder 3
3806884 1960063 1960063 defendant Birtt Edward gent 590437 590437 Birtt, Edward, of Dorchester, Oxon, gent 1
3806887 1960064 1960064 defendant Britt or Birtt Edward gent 590437 590437 Britt or Birtt, Edward, of Dorchester, Oxon, gent 1
3806890 1960065 1960065 defendant Britt Edward gent 590437 590437 Britt, Edward, of Dorchester, Oxon, gent 1
3909900 1993619 1993619 defendant Ilbery Richard innholder 590437 590437 Ilbery, Richard, of Dorchester, Oxon, innholder 0
4001530 2025327 2025327 defendant Bewforest Luke gent 590437 590437 Bewforest, Luke, of Dorchester, Oxon, gent 3
4057638 2045112 2045112 defendant Keyse John innholder 590437 590437 Keyse, John, of Dorchester, Oxon, innholder 2
4064937 2047745 2047745 defendant Bewforest Luke gent 590437 590437 Bewforest, Luke, of Dorchester, Oxon, gent 0
4065233 2047848 2047848 defendant Bewforrest Luke gent 590437 590437 Bewforrest, Luke, of Dorchester, Oxon, gent 0
4087309 2055752 2055752 defendant Keyse John chapman 590437 590437 Keyse, John, of Dorchester, Oxon, chapman 0
4093272 2057911 2057911 defendant Keyse John chapman 590437 590437 Keyse, John, of Dorchester, Oxon, chapman 0
4118925 2067048 2067048 defendant Sylvertopp Richard gent 590437 590437 Sylvertopp, Richard, of Dorchester, Oxon, or of Readyng, Berks, gent 0
4120806 2067728 2067728 defendant Blande Richard husbandman 590437 590437 Blande, Richard, of Dorchester, Oxon, husbandman 0
4143475 2075877 2075877 defendant Betterton John yeoman 590437 590437 Betterton, John, of Dorchester, Oxon, yeoman 0
4143964 2076051 2076051 defendant Blandye Richard husbandman 590437 590437 Blandye, Richard, of Dorchester, ,Oxon, husbandman 1
4176767 2087342 2087342 defendant Bewforest Luke gent 590437 590437 Bewforest, Luke, of Dorchester, Oxon, gent 0
4460478 2188341 2188341 defendant Porter John   590437 590437 Porter, John, of Dorchester, Oxon 0
4460485 2188342 2188342 defendant Porter John   590437 590437 Porter, John, of Dorchester, Oxon 0
4602036 2231858 2231858 defendant Langton John   590437 590437 (Langton, John, of Dorchester, Oxon 2
4725880 2273382 2273382 defendant Hoore John husbandman 590437 590437 Hoore, John, of Dorchester, Oxon, husbandman 0
4740593 2277763 2277763 defendant Baron John chapman 590437 590437 Baron, John, of Dorchester, Oxon, chapman 0
4765837 2285314 2285314 defendant Barouwen John chapman 590437 590437 Barouwen, John, of Dorchester, Oxon, chapman 0
4786896 2291963 2291963 defendant Hore John   590437 590437 Hore, John, of Dorchester, Oxon 0
4908774 2329295 2329295 defendant Hawe Walter yeoman 590437 590437 Hawe, Walter, of Dorchester, Oxon, yeoman 1
4915658 2331398 2331398 plaintiff Drayton Nicholas (legal representative) 590437 590437 Drayton, Nicholas, of Dorchester, Oxon, executrix of 0
4932557 2336577 2336577 defendant Idle Peter gent 590437 590437 Idle, Peter, of Dorchester, Oxon, gent 0
4961193 2345312 2345312 defendant Lavender Robert weaver 590437 590437 Lavender, Robert, of Dorchester, Oxon, weaver 0
5031853 2366189 2366189 defendant Hawe Walter yeoman 590437 590437 Hawe, Walter, of Dorchester, Oxon, yeoman 0
5058520 2374102 2374102 defendant Glasier Henry draper 590437 590437 Glasier, Henry, of Dorchester, Oxon, draper 0
5213460 2419669 2419669 defendant Baker William baker 590437 590437 Baker, William, of Dorchester, Oxon, baker 3
5222186 2422196 2422196 defendant Curtays John buther 590437 590437 Curtays, John, of Dorchester, Oxon, buther 0
5276366 2438159 2438159 defendant Howechilde William husbandman 590437 590437 Howechilde, William, of Dorchester, Oxon, husbandman 2
5295284 2443615 2443615 defendant Ewen William baker 590437 590437 Ewen, William, of Dorchester, Oxon, baker 3
5357826 2462519 2462519 defendant Elys William chapman 590437 590437 Elys, William, of Dorchester, Oxon, chapman 0
5357868 2462529 2462529 defendant Elys William chapman 590437 590437 Elys, William, of Dorchester, Oxon, chapman 0
5526025 2512730 2512730 defendant Nevyll Thomas gent 590437 590437 Nevyll, Thomas, of Dorchester, Oxon, gent 2

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