names

23 rows where place_id = 637204

✎ 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
3835031 1968896 1968896 defendant Stevens John yeoman 637204 637204 Stevens, John, of Ardley, yeoman 0
3999613 2024627 2024627 defendant Sayer Quintin laborer 637204 637204 Sayer, Quintin, of Ardley, laborer 1
3999614 2024627 2024627 defendant Baker Lawrence laborer 637204 637204 Baker, Lawrence, of Ardley, laborer 2
3999617 2024628 2024628 defendant Sayer Quintin laborer 637204 637204 Sayer, Quintin, of Ardley, laborer 1
3999618 2024628 2024628 defendant Baker Lawrence laborer 637204 637204 Baker, Lawrence, of Ardley, laborer 2
4108913 2063442 2063442 defendant Bonde John yeoman 637204 637204 Bonde, John, of Ardley, yeoman 0
4110231 2063921 2063921 defendant Newman Alexander carpenter 637204 637204 Newman, Alexander, of Ardley, carpenter 0
4137977 2073943 2073943 defendant Scofyld John yeoman 637204 637204 Scofyld, John, of Ardley, yeoman 0
4186265 2090681 2090681 defendant Lawrence John glover 637204 637204 Lawrence, John, of Ardley, glover 0
4217865 2101739 2101739 defendant Doughtye Humphrey gent 637204 637204 Doughtye, Humphrey, of Ardley, gent 1
4244884 2111275 2111275 defendant Aylward John laborer 637204 637204 Aylward, John, of Ardley, laborer 2
4268874 2119184 2119184 defendant Aylward John laborer 637204 637204 Aylward, John, of Ardley, laborer 2
4281825 2123548 2123548 defendant Bragge Thomas husbandman 637204 637204 Bragge, Thomas, of Ardley, husbandman 0
4283568 2124161 2124161 defendant Awfyld Robert husbandman 637204 637204 Awfyld, Robert, of Ardley, husbandman 0
4359397 2150520 2150520 defendant Parker Richard yeoman 637204 637204 Parker, Richard, of Ardley, yeoman 0
4359398 2150520 2150520 defendant Franklyn Thomas husbandman 637204 637204 Franklyn, Thomas, of Ardley, husbandman 1
4359399 2150520 2150520 defendant Browne Robert husbandman 637204 637204 Browne, Robert, of Ardley, husbandman 2
4359495 2150554 2150554 defendant Woodward Henry   637204 637204 Woodward, Henry, of Ardley, coverlet weaver 0
4361998 2151450 2151450 defendant Webbe John husbandman 637204 637204 Webbe, John, of Ardley, husbandman 0
5519892 2511059 2511059 defendant Pacche Thomas weaver 637204 637204 Pacche, Thomas, of Ardley, weaver 1
5519893 2511059 2511059 defendant Squyer Thomas weaver 637204 637204 Squyer, Thomas, of Ardley, weaver 2
5519896 2511060 2511060 defendant Pacche Thomas weaver 637204 637204 Pacche, Thomas, of Ardley, weaver 1
5519897 2511060 2511060 defendant Squyer Thomas weaver 637204 637204 Squyer, Thomas, of Ardley, weaver 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);