names

16 rows where place_id = 592947

✎ 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
3609501 1870632 1870632 defendant Bagshawe Philip husbandman 592947 592947 Bagshawe, Philip, of Abney, husbandman 8
3609502 1870632 1870632 defendant Hall Thurstan husbandman 592947 592947 Hall, Thurstan, of Abney, husbandman 9
3658468 1912900 1912900 defendant Bokyng Denise husbandman 592947 592947 Bokyng, Denise, of Abney, husbandman 0
3998183 2024098 2024098 plaintiff Eyre George yeoman 592947 592947 Eyre, George, of Abney, yeoman 0
4386269 2160083 2160083 defendant Bagshawe Roger husbandman 592947 592947 Bagshawe, Roger, of Abney, husbandman 0
4386272 2160084 2160084 defendant Bamford or Bainford Elias husbandman 592947 592947 Bamford or Bainford, Elias, of Abney, husbandman 0
4794252 2294341 2294341 defendant Wylde John yeoman 592947 592947 Wylde, John, of Abney, yeoman 0
4806789 2298335 2298335 defendant Wylde John yeoman 592947 592947 Wylde, John, of Abney, yeoman 0
4806791 2298335 2298335 defendant Basbawe Thomas de yeoman 592947 592947 Basbawe, Thomas de, of Abney, yeoman 2
4901302 2327017 2327017 defendant Wylde John yeoman 592947 592947 Wylde, John, of Abney, yeoman 0
5037932 2367976 2367976 defendant Bowyer John husbandman 592947 592947 Bowyer, John, of Abney, husbandman 0
5066061 2376374 2376374 defendant Bagshawe Thomas yeoman 592947 592947 Bagshawe, Thomas, of Abney, yeoman 0
5075002 2379026 2379026 defendant Wylde William yeoman 592947 592947 Wylde, William, of Abney, yeoman 4
5228082 2423819 2423819 defendant Barker Robert yeoman 592947 592947 Barker, Robert, of Abney, yeoman 4
5228083 2423819 2423819 defendant Bagshawe Robert yeoman 592947 592947 Bagshawe, Robert, of Abney, yeoman 5
5346878 2459181 2459181 defendant Wyld William yeoman 592947 592947 Wyld, William, of Abney, yeoman 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);