names

18 rows where place_id = 609576

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3679166 1919552 1919552 defendant Croford John dyer 609576 609576 Croford, John, of Chechester, Sussex, dyer 0
3710061 1929457 1929457 defendant Gronowe Thomas clerk 609576 609576 Gronowe, Thomas, of Chechester, Sussex, clerk 0
3762420 1945890 1945890 defendant Hillis John merchant 609576 609576 Hillis, John, of Chechester, Sussex, merchant 0
3869634 1980085 1980085 defendant Hampton Thomas gent 609576 609576 Hampton, Thomas, of Chechester, Sussex, gent 0
3872868 1981141 1981141 defendant Hamarton Roger gent 609576 609576 Hamarton, Roger, of Chechester, Sussex, gent 0
3906520 1992473 1992473 defendant Flynte Thomas beer brewer 609576 609576 Flynte, Thomas, of Chechester, Sussex, beer brewer 0
5227678 2423715 2423715 defendant Crooke John chapman 609576 609576 Crooke, John, of Chechester, Sussex, chapman 2
5342458 2457840 2457840 defendant More Robert draper 609576 609576 More, Robert, of Chechester, Sussex, draper 0
5518776 2510707 2510707 defendant Ive Roger chapman 609576 609576 Ive, Roger, of Chechester, Sussex, chapman 3
5523768 2512257 2512257 defendant A Bevys or A Benys Denise widow 609576 609576 A Bevys or A Benys, Denise, of Chechester, Sussex, widow 5
5533950 2515160 2515160 defendant Folssan Thomas chapman 609576 609576 Folssan, Thomas, of Chechester, Sussex, chapman 0
5533954 2515161 2515161 defendant Fossame Thomas chapman 609576 609576 Fossame, Thomas, of Chechester, Sussex, chapman 0
5537351 2516175 2516175 defendant Bentall William yeoman 609576 609576 (Bentall, William, of Chechester, Sussex, yeoman 1
5566240 2524723 2524723 defendant Feygley Robert yeoman 609576 609576 Feygley, Robert, of Chechester, Sussex, yeoman 0
5568842 2525437 2525437 defendant Chepe Henry chapman 609576 609576 Chepe, Henry, of Chechester, Sussex, chapman 2
5575729 2527496 2527496 defendant Fygley Robert chaplain 609576 609576 Fygley, Robert, of Chechester, Sussex, chaplain 1
5594886 2533371 2533371 defendant Phelipp John yeoman of the crown 609576 609576 Phelipp, John, of Chechester, Sussex, yeoman of the crown 1
5601516 2535365 2535365 defendant Merres William chapman 609576 609576 Merres, William, of Chechester, Sussex, chapman 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);