names

26 rows where place_id = 641850

✎ 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
3597676 1866899 1866899 defendant Everyngham John   641850 641850 Everyngham, John, of Birkyn, knight 2
3673403 1917700 1917700 plaintiff Everyngham John   641850 641850 Everyngham, John, of Birkyn, knight 0
3733677 1936776 1936776 plaintiff Everyngham John   641850 641850 Everyngham, John, of Birkyn, knight 0
3864247 1978235 1978235 defendant Everyngham Henry   641850 641850 Everyngham, Henry, of Birkyn, knight 0
3864249 1978235 1978235 defendant Talbott John, junior yeoman 641850 641850 Talbott, John, junior, of Birkyn, yeoman 2
4236931 2108494 2108494 defendant Gascoigne William yeoman 641850 641850 Gascoigne, William, of Birkyn, yeoman 0
4254104 2114369 2114369 defendant Hagg Christopher yeoman 641850 641850 Hagg, Christopher, of Birkyn, yeoman 1
4254106 2114369 2114369 defendant Bateson Richard clerk 641850 641850 Bateson, Richard, of Birkyn, clerk 3
4254109 2114370 2114370 defendant Hagg Christopher yeoman 641850 641850 Hagg, Christopher, of Birkyn, yeoman 1
4254111 2114370 2114370 defendant Bateson Richard clerk 641850 641850 Bateson, Richard, of Birkyn, clerk 3
4254114 2114371 2114371 defendant Hagg Christopher yeoman 641850 641850 Hagg, Christopher, of Birkyn, yeoman 1
4307525 2132770 2132770 defendant Gascoigne William esq 641850 641850 Gascoigne, William, of Birkyn, esq 0
4538426 2212304 2212304 plaintiff Toweton Thomas de   641850 641850 Toweton, Thomas de, of Birkyn, parson 0
4651129 2246355 2246355 defendant Midelton Peter husbandman 641850 641850 Midelton, Peter, of Birkyn, husbandman 0
4665829 2250788 2250788 defendant Birkyn Reyner fletcher 641850 641850 Birkyn, Reyner, of Birkyn, fletcher 0
4733690 2275715 2275715 defendant Middilton Peter yeoman 641850 641850 Middilton, Peter, of Birkyn, yeoman 0
5224669 2422885 2422885 defendant Everyngham William   641850 641850 Everyngham, William, of Birkyn, knight 0
5224670 2422885 2422885 defendant Halele Robert yeoman 641850 641850 together with Halele, Robert, of Birkyn, yeoman 1
5289303 2441877 2441877 defendant Everyngham William gent 641850 641850 Everyngham, William, of Birkyn, gent 1
5289313 2441877 2441877 defendant Colcole Robert yeoman 641850 641850 Colcole, Robert, of Birkyn, yeoman 11
5314384 2449326 2449326 defendant Everyngham John esq 641850 641850 Everyngham, John, of Birkyn, esq 0
5490155 2501937 2501937 defendant Beswyke John yeoman 641850 641850 Beswyke, John, of Birkyn, yeoman 0
5528349 2513414 2513414 defendant Everyngham John gent 641850 641850 Everyngham, John, of Birkyn, gent 15
5528350 2513414 2513414 defendant Everyngham Thomas gent 641850 641850 Everyngham, Thomas, of Birkyn, gent 16
5595865 2533619 2533619 defendant FitzWilliam John gent 641850 641850 FitzWilliam, John, of Birkyn, gent 0
5595866 2533619 2533619 defendant Markham Robert yeoman 641850 641850 Markham, Robert, of Birkyn, yeoman 1

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