names

29 rows where place_id = 759722

✎ 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
4463783 2189353 2189353 defendant Roo John   759722 759722 Roo, John, of Berdefeld 1
4463792 2189354 2189354 defendant Roo John   759722 759722 Roo, John, of Berdefeld 1
4493712 2198733 2198733 plaintiff Bayly John   759722 759722 Bayly, John, of Berdefeld 0
4531806 2210210 2210210 plaintiff Petyt William   759722 759722 Petyt, William, of Berdefeld 0
4553842 2217124 2217124 defendant Cartere John   759722 759722 Cartere, John, of Berdefeld 4
4586429 2227169 2227169 defendant Gobyon John   759722 759722 Gobyon, John, of Berdefeld 0
4615951 2235986 2235986 defendant Moyn Thomas   759722 759722 Moyn, Thomas, of Berdefeld 0
4629146 2240044 2240044 defendant Hokham Thomas   759722 759722 Hokham, Thomas, of Berdefeld 1
4647989 2245479 2245479 plaintiff Spryn Walter   759722 759722 Spryn, Walter, of Berdefeld 0
4657016 2248083 2248083 defendant Fryday Richard yeoman 759722 759722 Fryday, Richard, of Berdefeld, yeoman 1
4657019 2248084 2248084 defendant Fryday Richard yeoman 759722 759722 Fryday, Richard, of Berdefeld, yeoman 1
4668344 2255813 2255813 defendant Moyne Thomas   759722 759722 Moyne, Thomas, of Berdefeld, bailiff 6
4668345 2255813 2255813 defendant Glover John mercer 759722 759722 Glover, John, of Berdefeld, mercer 7
4717471 2270801 2270801 defendant Glover John yeoman 759722 759722 Glover, John, of Berdefeld, yeoman 0
4763602 2284601 2284601 defendant Stubbard Edward   759722 759722 Stubbard, Edward, of Berdefeld, shoe maker 0
4767151 2285711 2285711 defendant Stubberd Richard husbandman 759722 759722 Stubberd, Richard, of Berdefeld, husbandman 2
4767152 2285711 2285711 defendant Glover John yeoman 759722 759722 Glover, John, of Berdefeld, yeoman 3
4822381 2303080 2303080 defendant Pulco Jhn husbandman 759722 759722 Pulco, Jhn, of Berdefeld, husbandman 1
4910933 2329932 2329932 defendant Rychold John laborer 759722 759722 Rychold, John, of Berdefeld, laborer 0
5059958 2374543 2374543 defendant Stubbard John carter 759722 759722 Stubbard, John, of Berdefeld, carter 2
5059965 2374544 2374544 defendant Stubbard John carter 759722 759722 Stubbard, John, of Berdefeld, carter 2
5111815 2389847 2389847 defendant Bulmer alias Pantry John (legal representative) 759722 759722 Bulmer alias Pantry, John, of Berdefeld, , executrix of 0
5111816 2389847 2389847 defendant Bulmer alias Pantry Joan widow 759722 759722 Bulmer alias Pantry, Joan, of Berdefeld, widow 1
5273273 2437250 2437250 defendant Bartelett John timber man 759722 759722 Bartelett, John, of Berdefeld, timber man 3
5415866 2479678 2479678 defendant Bret John   759722 759722 Bret, John, of Berdefeld, nail maker 4
5470721 2496163 2496163 defendant Wright William (legal representative) 759722 759722 Wright, William, of Berdefeld, yeoman, executrix of 2
5543279 2518014 2518014 defendant Hervey John blacksmith 759722 759722 Hervey, John, of Berdefeld, blacksmith 4
5613363 2547965 2547965 defendant Hood Richard   759722 759722 Hood, Richard, of Berdefeld 0
5627987 2552724 2552724 defendant Pountfreyt John woolman 759722 759722 Pountfreyt, John, of Berdefeld, woolman 2

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