names

26 rows where place_id = 604944

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3659822 1913327 1913327 defendant Hille Thomas husbandman 604944 604944 Hille, Thomas, of Putley, husbandman 0
3659824 1913327 1913327 defendant Jonys John husbandman 604944 604944 Jonys, John, of Putley, husbandman 2
3659825 1913327 1913327 defendant Jonys Agnes spinster 604944 604944 Jonys, Agnes, of Putley, spinster 3
3659984 1913382 1913382 defendant ap Griffith Hugh yeoman 604944 604944 ap Griffith, Hugh, of Putley, yeoman 0
3660314 1913486 1913486 defendant ap Gryffyth Hugh yeoman 604944 604944 ap Gryffyth, Hugh, of Putley, yeoman 0
3678449 1919312 1919312 defendant Morgan John laborer 604944 604944 Morgan, John, of Putley, laborer 8
3679833 1919757 1919757 defendant Jonys Roger husbandman 604944 604944 Jonys, Roger, of Putley, husbandman 0
3679834 1919757 1919757 defendant Jonys Richard husbandman 604944 604944 Jonys, Richard, of Putley, husbandman 1
3679835 1919757 1919757 defendant Jonys Thomas husbandman 604944 604944 Jonys, Thomas, of Putley, husbandman 2
4055316 2044300 2044300 defendant Jones Thomas gent 604944 604944 Jones, Thomas, of Putley, gent 2
4058566 2045453 2045453 defendant Jones William, junior yeoman 604944 604944 Jones, William, junior, of Putley, yeoman 3
4083712 2054446 2054446 defendant Jones William yeoman 604944 604944 Jones, William, of Putley, yeoman 0
4215260 2100833 2100833 defendant Jones Thomas husbandman 604944 604944 Jones, Thomas, of Putley, husbandman 0
4215261 2100833 2100833 defendant Jones John husbandman 604944 604944 Jones, John, of Putley, husbandman 1
4230346 2106104 2106104 defendant Jones Thomas yeoman 604944 604944 Jones, Thomas, of Putley, yeoman 0
4232845 2106994 2106994 defendant Jones Thomas husbandman 604944 604944 Jones, Thomas, of Putley, husbandman 0
4232846 2106994 2106994 defendant Jones John husbandman 604944 604944 Jones, John, of Putley, husbandman 1
4240421 2109774 2109774 defendant Jones John gent 604944 604944 Jones, John, of Putley, gent 1
4368684 2153851 2153851 defendant Aleridge Thomas yeoman 604944 604944 Aleridge, Thomas, of Putley, yeoman 0
4708453 2268011 2268011 defendant Kyng Rowland husbandman 604944 604944 Kyng, Rowland, of Putley, husbandman 1
4931484 2336227 2336227 defendant Hill Thomas husbandman 604944 604944 Hill, Thomas, of Putley, husbandman 3
4999903 2356849 2356849 defendant Comyn John husbandman 604944 604944 Comyn, John, of Putley, husbandman 0
5032956 2366525 2366525 defendant Comyn John gent 604944 604944 Comyn, John, of Putley, gent 4
5292866 2442906 2442906 defendant Scot William husbandman 604944 604944 Scot, William, of Putley, husbandman 0
5577167 2527910 2527910 defendant ap Thomas Hugh laborer 604944 604944 ap Thomas, Hugh, of Putley, laborer 0
5577168 2527910 2527910 defendant ap Thomas Roger husbandman 604944 604944 ap Thomas, Roger, of Putley, husbandman 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);