names

23 rows where place_id = 764406

✎ 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
4505730 2202301 2202301 defendant Bateman John   764406 764406 Bateman, John, of Hikelyng 1
4580744 2225458 2225458 defendant Goodknape Thomas   764406 764406 Goodknape, Thomas, of Hikelyng 0
4607229 2233373 2233373 plaintiff Beere William   764406 764406 Beere, William, of Hikelyng 0
4736041 2276412 2276412 defendant Smyth Thomas mercer 764406 764406 Smyth, Thomas, of Hikelyng, mercer 1
4875286 2319223 2319223 defendant Punche Robert, senior husbandman 764406 764406 Punche, Robert, senior, of Hikelyng, husbandman 0
4875287 2319223 2319223 defendant Punche Robert, junior fisher 764406 764406 Punche, Robert, junior, of Hikelyng, fisher 1
5083075 2381446 2381446 defendant Bolte John baker 764406 764406 Bolte, John, of Hikelyng, baker 3
5087449 2382705 2382705 defendant Bere William husbandman 764406 764406 Bere, William, of Hikelyng, husbandman 2
5103435 2387431 2387431 plaintiff Brightled Robert yeoman 764406 764406 Brightled, Robert,of Hikelyng, yeoman 0
5103439 2387432 2387432 plaintiff Brightlid Robert   764406 764406 Brightlid, Robert,of Hikelyng 0
5107021 2388482 2388482 defendant Wilkyns Thomas husbandman 764406 764406 Wilkyns, Thomas, of Hikelyng, husbandman 0
5156593 2403082 2403082 defendant Russhebroke William   764406 764406 Russhebroke, William, of Hikelyng, servant 0
5156595 2403083 2403083 defendant Russhebroke William   764406 764406 Russhebroke, William, of Hikelyng, servant 0
5176442 2408794 2408794 defendant Massyngham Robert husbandman 764406 764406 Massyngham, Robert, of Hikelyng, husbandman 0
5198543 2415329 2415329 defendant Massyngham Robert husbandman 764406 764406 Massyngham, Robert, of Hikelyng, husbandman 0
5198545 2415330 2415330 defendant Massyngham Robert husbandman 764406 764406 Massyngham, Robert, of Hikelyng, husbandman 0
5279928 2439205 2439205 defendant Ravele John butcher 764406 764406 Ravele, John, of Hikelyng, butcher 2
5410474 2478079 2478079 plaintiff Bryghtleed Robert   764406 764406 Bryghtleed, Robert, of Hikelyng 0
5448623 2489488 2489488 defendant Banburgh John   764406 764406 Banburgh, John, of Hikelyng 0
5448624 2489488 2489488 defendant Hethe Robert husbandman 764406 764406 Hethe, Robert, of Hikelyng, husbandman 1
5460914 2493214 2493214 defendant Banburgh John husbandman 764406 764406 Banburgh, John, of Hikelyng, husbandman 0
5460915 2493214 2493214 defendant Hethe Robert husbandman 764406 764406 Hethe, Robert, of Hikelyng, husbandman 1
5574151 2527003 2527003 defendant Walysshe Thomas mercer 764406 764406 Walysshe, Thomas, of Hikelyng, mercer 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);