names

22 rows where place_id = 724539

✎ 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
4256480 2115135 2115135 defendant Button Edward husbandman 724539 724539 Button, Edward, of Filby, husbandman 1
4330578 2140522 2140522 defendant Odams Mary widow 724539 724539 Odams, Mary, of Filby, widow 0
4330579 2140522 2140522 defendant Odams Katherine spinster 724539 724539 Odams, Katherine, of Filby, spinster 1
4500736 2200846 2200846 plaintiff Kent John de   724539 724539 Kent, John de, of Filby 0
4557044 2218130 2218130 plaintiff Kent John   724539 724539 Kent, John, of Filby 0
4560592 2219255 2219255 plaintiff Norman Ralph   724539 724539 Norman, Ralph, of Filby 1
4563057 2220013 2220013 defendant Norman John   724539 724539 Norman, John, of Filby 0
4578369 2224724 2224724 plaintiff Norman John   724539 724539 Norman, John, of Filby 1
4620897 2237516 2237516 plaintiff Kent John   724539 724539 Kent, John, of Filby 0
4620899 2237517 2237517 plaintiff Kent John   724539 724539 Kent, John, of Filby 0
4643526 2244208 2244208 plaintiff Kent John   724539 724539 Kent, John, of Filby 0
4664756 2250457 2250457 defendant Burman William (legal representative) 724539 724539 Burman, William, of Filby, executors of 0
4664757 2250457 2250457 defendant Burman Thomas husbandman 724539 724539 (Burman, Thomas, of Filby, husbandman 1
4679974 2259340 2259340 defendant Pykeryng William yeoman 724539 724539 Pykeryng, William, of filby, yeoman 2
4679975 2259340 2259340 defendant Taylour William butcher 724539 724539 Taylour, William, of Filby, butcher 3
4699068 2265176 2265176 defendant Norman John yeoman 724539 724539 Norman, John, of Filby, yeoman 0
4837703 2307725 2307725 defendant Drye William yeoman 724539 724539 Drye, William, of Filby, yeoman 0
4837705 2307726 2307726 defendant Pykerynge Nicholas yeoman 724539 724539 Pykerynge, Nicholas, of Filby, yeoman 0
4849688 2311379 2311379 defendant Magr_ John yeoman 724539 724539 Magr_, John, of Filby, yeoman 0
4925318 2334351 2334351 plaintiff Pekeryng Nicholas   724539 724539 Pekeryng, Nicholas, of Filby 0
5306613 2446966 2446966 defendant Pekeryng John yeoman 724539 724539 Pekeryng, John, of Filby, yeoman 0
5623673 2551342 2551342 plaintiff Kent John   724539 724539 Kent, John, of Filby 0

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