names

30 rows where place_id = 636036

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3828508 1966790 1966790 defendant Mayne Thomas husbandman 636036 636036 Mayne, Thomas, of Hardmede, husbandman 0
3828510 1966791 1966791 defendant Mayne Thomas laborer 636036 636036 Mayne, Thomas, of Hardmede, laborer 0
3828515 1966792 1966792 defendant Mayne Thomas laborer 636036 636036 Mayne, Thomas, of Hardmede, laborer 0
4429180 2173935 2173935 defendant Botiller Margaret le   636036 636036 Botiller, Margaret le, of Hardmede, formerly wife of William 0
4429181 2173935 2173935 defendant Botiller Edward le   636036 636036 Botiller, Edward le, of Hardmede 1
4575902 2223951 2223951 defendant Coupere William   636036 636036 Coupere, William, of Hardmede 0
4711109 2268829 2268829 defendant Mauncell Simon husbandman 636036 636036 Mauncell, Simon, of Hardmede, husbandman 0
4733860 2275772 2275772 defendant Mauncell Simon husbandman 636036 636036 Mauncell, Simon, of Hardmede, husbandman 0
4763065 2284431 2284431 plaintiff Giffard John   636036 636036 Giffard, John, of Hardmede 0
4795785 2294831 2294831 defendant Giffard John gent 636036 636036 Giffard, John, of Hardmede, gent 0
4795786 2294831 2294831 defendant Dradres John gent 636036 636036 Dradres, John, of Hardmede, gent 1
4795787 2294831 2294831 defendant Dudlee John laborer 636036 636036 Dudlee, John, of Hardmede, laborer 2
4795788 2294831 2294831 defendant Mathewe Alexander laborer 636036 636036 Mathewe, Alexander, of Hardmede, laborer 3
4799724 2296100 2296100 defendant Rose John yeoman 636036 636036 Rose, John, of Hardmede, yeoman 0
4803417 2297258 2297258 defendant Giffard John husbandman 636036 636036 Giffard, John, of Hardmede, husbandman 2
4927098 2334908 2334908 defendant Hamond Thomas husbandman 636036 636036 Hamond, Thomas, of Hardmede, husbandman 0
4956338 2343859 2343859 defendant Salet Edward husbandman 636036 636036 Salet, Edward, of Hardmede, husbandman 0
5005752 2358579 2358579 defendant Dardys John gent 636036 636036 Dardys, John, of Hardmede, gent 0
5080044 2380513 2380513 defendant Smyth Robert chaplain 636036 636036 Smyth, Robert, of Hardmede, chaplain 1
5110756 2389546 2389546 defendant Keston Roger husbandman 636036 636036 Keston, Roger, of Hardmede, husbandman 0
5151805 2401687 2401687 defendant Keston Roger husbandman 636036 636036 Keston, Roger, of Hardmede, husbandman 0
5151920 2401699 2401699 defendant Keston Roger husbandman 636036 636036 Keston, Roger, of Hardmede, husbandman 0
5169878 2406927 2406927 defendant Keston Roger husbandman 636036 636036 Keston, Roger, of Hardmede, husbandman 0
5178205 2409329 2409329 defendant Richardson John yeoman 636036 636036 together with Richardson, John, of Hardmede, yeoman 1
5178207 2409330 2409330 defendant Richardson John yeoman 636036 636036 Richardson, John, of Hardmede, yeoman 0
5187031 2411943 2411943 defendant Keston Roger husbandman 636036 636036 Keston, Roger, of Hardmede, husbandman 0
5205465 2417351 2417351 defendant Keston Roger husbandman 636036 636036 Keston, Roger, of Hardmede, husbandman 0
5232268 2425014 2425014 defendant Bysshop John husbandman 636036 636036 Bysshop, John, of Hardmede, husbandman 3
5619072 2549808 2549808 defendant Gerveys Richard   636036 636036 Gerveys, Richard, of Hardmede 1
5619073 2549808 2549808 defendant Barbour Robert   636036 636036 Barbour, Robert, of Hardmede 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);