names

15 rows where case_id = 2386544

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5100327 2386544 2386544 plaintiff Yates John     Yates, John 0
5100328 2386544 2386544 defendant Bunne John yeoman 606657 606657 Bunne, John, of Bynham, yeoman 0
5100329 2386544 2386544 defendant Noreys Geoffrey yeoman 640089 640089 Noreys, Geoffrey, of Tilney, yeoman 1
5100330 2386544 2386544 defendant Lawys Thomas husbandman 586365 586365 Lawys, Thomas, of Wymondham, husbandman 2
5100331 2386544 2386544 defendant Tilman Richard yeoman 588126 588126 Tilman, Richard, of North Walsham, yeoman 3
5100332 2386544 2386544 defendant Tawell John, senior husbandman 846370 846370 Tawell, John, senior, of Barowe juxta Hengham, husbandman 4
5100333 2386544 2386544 defendant Ferrour or Smith John husbandman 846371 846371 Ferrour or Smith, John, of Sechehithe, husbandman 5
5100334 2386544 2386544 defendant Folcard John yeoman 846372 846372 Folcard, John, of Crostwyk juxta Norwich, yeoman 6
5100335 2386544 2386544 defendant Hogate Edmund husbandman 615180 615180 Hogate, Edmund, of Sculton, husbandman 7
5100336 2386544 2386544 defendant Roberdys John pedder 587592 587592 Roberdys, John, of Hempton, pedder 8
5100337 2386544 2386544 defendant Sotill William carpenter 610955 610955 Sotill, William, of Wignale, carpenter 9
5100338 2386544 2386544 defendant Hose Roger clerk 588071 588071 Hose, Roger, of Multon, clerk 10
5100339 2386544 2386544 defendant Brodde Robert husbandman 586401 586401 Brodde, Robert, of Stanfeld, husbandman 11
5100340 2386544 2386544 defendant Roo Richard husbandman 594685 594685 Roo, Richard, of South Birlyngham, husbandman 12
5100341 2386544 2386544 defendant Howys Richard husbandman 589536 589536 Howys, Richard, of Shotesham, husbandman 13

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