names

25 rows where place_id = 634472

✎ 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
3819086 1963861 1963861 defendant Bygyn William yeoman 634472 634472 Bygyn, William, of Stystede, yeoman 2
4513339 2204589 2204589 plaintiff Broke John   634472 634472 Broke, John, of Stystede 0
4534828 2211176 2211176 defendant Glasen John   634472 634472 Glasen, John, of Stystede, parson 0
4536164 2211585 2211585 defendant Byggyng (illegible)   634472 634472 Byggyng, _, of Stystede 3
4609018 2233922 2233922 plaintiff Broke John (legal representative) 634472 634472 Broke, John, of Stystede, administrator of 0
4620557 2237415 2237415 plaintiff Jegon John   634472 634472 Jegon, John, of Stystede 0
4620558 2237415 2237415 defendant Whyte William   634472 634472 Whyte, William, of Stystede 0
4631259 2240672 2240672 defendant Godyng John   634472 634472 Godyng, John, of Stystede 0
4638282 2242743 2242743 defendant Kentyssh William (legal representative) 634472 634472 Kentyssh, William, of Stystede, executors of 0
4650511 2246170 2246170 defendant Rouhed John   634472 634472 Rouhed, John, of Stystede 0
4674143 2257518 2257518 defendant Bryde John shoemaker 634472 634472 Bryde, John, of Stystede, shoemaker 2
4686922 2261516 2261516 defendant Meller John miller 634472 634472 Meller, John, of Stystede, miller 0
4773103 2287558 2287558 defendant Melle John laborer 634472 634472 Melle, John, of Stystede, laborer 0
4778567 2289280 2289280 defendant Wolney John husbandman 634472 634472 Wolney, John, of Stystede, husbandman 0
4781050 2290082 2290082 defendant Marchaunt Richard husbandman 634472 634472 Marchaunt, Richard, of Stystede, husbandman 0
4789044 2292627 2292627 defendant Whyte William husbandman 634472 634472 Whyte, William, of Stystede, husbandman 1
5065841 2376304 2376304 defendant Hunte John   634472 634472 Hunte, John, of Stystede, mattress maker 0
5067404 2376757 2376757 defendant Hunt Philip fuller 634472 634472 Hunt, Philip, of Stystede, fuller 4
5099568 2386312 2386312 defendant Prentys John laborer 634472 634472 Prentys, John, of Stystede, laborer 1
5116269 2391190 2391190 defendant Samon John butcher 634472 634472 Samon, John, of Stystede, butcher 0
5136548 2397204 2397204 defendant Wybore (illegible) fuller 634472 634472 Wybore, ---, of Stystede, fuller 1
5223472 2422557 2422557 defendant Saman John butcher 634472 634472 Saman, John, of Stystede, butcher 1
5262405 2433984 2433984 defendant Saman John butcher 634472 634472 Saman, John, of Stystede, butcher 4
5377484 2468543 2468543 defendant Warner John husbandman 634472 634472 Warner, John, of Stystede, husbandman 0
5634988 2554929 2554929 defendant Bolthod Walter husbandman 634472 634472 Bolthod, Walter, of Stystede, husbandman 3

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