names

23 rows where place_id = 612294

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3692502 1923838 1923838 defendant Tylly Thomas esq 612294 612294 Tylly, Thomas, of Canyngton, Soms, esq 0
3694868 1924603 1924603 defendant Hewysshe William carver 612294 612294 Hewysshe, William, of Canyngton, Soms, carver 0
3838907 1970094 1970094 defendant Tylley Thomas esq 612294 612294 Tylley, Thomas, of Canyngton, Soms, esq 0
3941316 2004101 2004101 defendant Pemme Erastus gent 612294 612294 Pemme, Erastus, of Canyngton, Soms, gent 0
4558968 2218767 2218767 defendant Asshewater John   612294 612294 Asshewater, John, of Canyngton, Soms 3
4558984 2218770 2218770 defendant Asshewater John   612294 612294 Asshewater, John, of Canyngton, Soms 2
4558990 2218771 2218771 defendant Asshwater John   612294 612294 Asshwater, John, of Canyngton, Soms 2
4736460 2276535 2276535 defendant Pym Roger gent 612294 612294 Pym, Roger, of Canyngton, Soms, gent 0
4755616 2282138 2282138 defendant Gornard Philip   612294 612294 (Gornard, Philip, of Canyngton, Soms, mason 4
4884343 2322008 2322008 defendant Ile John   612294 612294 Ile, John, of Canyngton, Soms, bailiff 0
4895756 2325349 2325349 defendant of Yle John yeoman 612294 612294 of Yle, John, of Canyngton, Soms, yeoman 2
4930901 2336065 2336065 plaintiff Tylly Leonard gent 612294 612294 Tylly, Leonard, of Canyngton, soms, gent 0
4936744 2337870 2337870 defendant More Julia   612294 612294 More, Julia, of Canyngton, Soms, widow of More, Hugh 1
5007711 2359146 2359146 defendant Willesson John husbandman 612294 612294 Willesson, John, of Canyngton, Soms, husbandman 5
5027536 2364932 2364932 defendant Tilly Leonard gent 612294 612294 Tilly, Leonard, of Canyngton, Soms, gent 0
5079831 2380446 2380446 defendant Michell Walter gent 612294 612294 Michell, Walter, of Canyngton, Soms, gent 2
5105629 2388096 2388096 defendant Haccheford John gent 612294 612294 Haccheford, John, of Canyngton, Soms, gent 1
5157358 2403287 2403287 defendant Tylly Leonard gent 612294 612294 Tylly, Leonard, of Canyngton, Soms, gent 6
5188533 2412366 2412366 defendant Wolmer John   612294 612294 Wolmer, John, of Canyngton, Soms, parish clerk 1
5194447 2414101 2414101 defendant Pole William yeoman 612294 612294 Pole, William, of Canyngton, Soms, yeoman 2
5206110 2417519 2417519 defendant Wolmer John   612294 612294 Wolmer, John, of Canyngton, Soms, parish clerk 1
5451945 2490463 2490463 defendant Basyng Edward gent 612294 612294 Basyng, Edward, of Canyngton, Soms, gent 3
5487934 2501281 2501281 defendant Michell Walter esq 612294 612294 Michell, Walter, of Canyngton, Soms, esq 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);