names

26 rows where place_id = 635291

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3824490 1965532 1965532 defendant Alen Robert yeoman 635291 635291 Alen, Robert, of Tumby, yeoman 0
3824491 1965532 1965532 defendant Watson William yeoman 635291 635291 Watson, William, of Tumby, yeoman 1
3933363 2001454 2001454 plaintiff Greynfeyld Gilbert   635291 635291 Greynfeyld, Gilbert, of Tumby 0
3933364 2001454 2001454 defendant Wyggens Nicholas yeoman 635291 635291 Wyggens, Nicholas, of Tumby, yeoman 0
3939359 2003467 2003467 defendant Shawe James yeoman 635291 635291 Shawe, James, of Tumby, yeoman 1
3948262 2006451 2006451 defendant Overton William yeoman 635291 635291 Overton, William, of Tumby, yeoman 0
3951088 2007446 2007446 defendant Dethyck Richard laborer 635291 635291 Dethyck, Richard, of Tumby, laborer 2
4184607 2090126 2090126 defendant Bryckles Robert husbandman 635291 635291 Bryckles, Robert, of Tumby, husbandman 2
4184608 2090126 2090126 defendant Wind Francis husbandman 635291 635291 Wind, Francis, of Tumby, husbandman 3
4208509 2098528 2098528 defendant Brickles Robert husbandman 635291 635291 Brickles, Robert, of Tumby, husbandman 2
4366148 2152933 2152933 defendant Fitzwilliams Henry gent 635291 635291 Fitzwilliams, Henry, of Tumby, gent 3
4516221 2205482 2205482 plaintiff Cok Robert   635291 635291 Cok, Robert, of Tumby 0
4540015 2212785 2212785 defendant Cokke William   635291 635291 Cokke, William, of Tumby 0
4595688 2229912 2229912 defendant May Walter   635291 635291 May, Walter, of Tumby 2
4787111 2292031 2292031 defendant Broun John husbandman 635291 635291 Broun, John, of Tumby, husbandman 0
4836816 2307476 2307476 defendant Brynkell William husbandman 635291 635291 Brynkell, William, of Tumby, husbandman 0
5038193 2368057 2368057 defendant Walker Robert husbandman 635291 635291 Walker, Robert, of Tumby, husbandman 1
5119948 2392272 2392272 defendant Burdon William husbandman 635291 635291 Burdon, William, of Tumby, husbandman 0
5119949 2392272 2392272 defendant Burdon John husbandman 635291 635291 Burdon, John, of Tumby, husbandman 1
5119950 2392272 2392272 defendant Burdon Thomas husbandman 635291 635291 Burdon, Thomas, of Tumby, husbandman 2
5119951 2392272 2392272 defendant Walker William walker 635291 635291 Walker, William, of Tumby, walker 3
5435857 2485667 2485667 defendant Brone Thomas husbandman 635291 635291 Brone, Thomas, of Tumby, husbandman 0
5450760 2490115 2490115 defendant Brond Thomas husbandman 635291 635291 Brond, Thomas, of Tumby, husbandman 0
5450763 2490116 2490116 defendant Grove Thomas husbandman 635291 635291 Grove, Thomas, of Tumby, husbandman 0
5613402 2547980 2547980 defendant Hunder John   635291 635291 Hunder, John, of Tumby 4
5613403 2547980 2547980 defendant Carder Roger   635291 635291 Carder, Roger, of Tumby 5

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