names

18 rows where place_id = 588164

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593560 1865622 1865622 defendant Symond John mercer 588164 588164 Symond, John, of Axbrygge, Soms, mercer 2
3616201 1872707 1872707 defendant Broun Richard shoemaker 588164 588164 Broun, Richard, of Axbrygge, Soms, shoemaker 0
3734653 1937085 1937085 defendant Cutler Thomas clothier 588164 588164 Cutler, Thomas, of Axbrygge, Soms, clothier 0
3734655 1937086 1937086 defendant Cutler Thomas clothier 588164 588164 Cutler, Thomas, of Axbrygge, Soms, clothier 0
4834018 2306645 2306645 defendant Wygmore John dyer 588164 588164 Wygmore, John, of Axbrygge, Soms, dyer 1
4930207 2335851 2335851 defendant Crudmede John draper 588164 588164 Crudmede, John, of Axbrygge, Soms, draper 6
4941978 2339474 2339474 defendant Croudemede John tucker 588164 588164 Croudemede, John, of Axbrygge, Soms, tucker 0
4941984 2339475 2339475 defendant Croudemede John tucker 588164 588164 Croudemede, John, of Axbrygge, Soms, tucker 0
4994988 2355359 2355359 defendant Dene John chapman 588164 588164 Dene, John, of Axbrygge, Soms, chapman 5
4994996 2355360 2355360 defendant Dens John chapman 588164 588164 Dens, John, of Axbrygge, Soms, chapman 5
5121088 2392597 2392597 defendant Hayne William clothmaker 588164 588164 Hayne, William, of Axbrygge, Soms, clothmaker 4
5132395 2395972 2395972 defendant Hayne John fuller 588164 588164 Hayne, John, of Axbrygge, Soms, fuller 1
5170217 2407017 2407017 defendant Phelyppes John John draper 588164 588164 Phelyppes, John John, of Axbrygge, Soms, draper 1
5256459 2432142 2432142 defendant Payne John yeoman 588164 588164 Payne, John, of Axbrygge, Soms, yeoman 2
5452941 2490760 2490760 defendant Symondys Willliam chapman 588164 588164 Symondys, Willliam, of Axbrygge, Soms, chapman 0
5464880 2494410 2494410 defendant Symondys William chapman 588164 588164 Symondys, William, of Axbrygge, Soms, chapman 0
5523548 2512193 2512193 defendant More Robert brasier 588164 588164 More, Robert, of Axbrygge, Soms, brasier 0
5532684 2514771 2514771 defendant Coteler Thomas chapman 588164 588164 Coteler, Thomas, of Axbrygge, Soms, chapman 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);