names

27 rows where place_id = 596870

✎ 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
3626466 1903134 1903134 defendant Rydynges Henry clerk 596870 596870 Rydynges, Henry, of Kynston, clerk 0
3642374 1908061 1908061 defendant Grenowe Richard husbandman 596870 596870 Grenowe, Richard, of Kynston, husbandman 3
3746714 1940886 1940886 defendant Hughes John husbandman 596870 596870 Hughes, John, of Kynston, husbandman 0
3755420 1943649 1943649 defendant Holland Lewis yeoman 596870 596870 Holland, Lewis, of Kynston, yeoman 0
3988468 2020619 2020619 defendant Daye John husbandman 596870 596870 Daye, John, of Kynston, husbandman 0
3989067 2020834 2020834 defendant Pygeon William gent 596870 596870 Pygeon, William, of Kynston, gent 0
4041107 2039312 2039312 plaintiff Musgrave John, senior husbandman 596870 596870 Musgrave, John, senior, of Kynston, husbandman 0
4051264 2042892 2042892 defendant Babyngton Henry (legal representative) 596870 596870 Babyngton, Henry, of Kynston, esq, executors of 0
4057699 2045137 2045137 plaintiff Bysshop Thomas   596870 596870 Bysshop, Thomas, of Kynston 0
4273747 2120764 2120764 defendant Jackson Sebastian yeoman 596870 596870 Jackson, Sebastian, of Kynston, yeoman 0
4438196 2181244 2181244 defendant Warde William   596870 596870 Warde, William, of Kynston 2
4439222 2181544 2181544 defendant Warde William   596870 596870 Warde,William, of Kynston 2
4453463 2186089 2186089 defendant Hethur John de   596870 596870 Hethur, John de, of Kynston 3
4453464 2186089 2186089 defendant Warde William   596870 596870 Warde, William, of Kynston 4
4646640 2245081 2245081 defendant Taillour Thomas   596870 596870 Taillour, Thomas, of Kynston 2
4646641 2245081 2245081 defendant atte Tounesende Thomas   596870 596870 atte Tounesende, Thomas, of Kynston 3
4685502 2261061 2261061 defendant Blythe John husbandman 596870 596870 Blythe, John, of Kynston, husbandman 2
4685504 2261061 2261061 defendant Rotenay William husbandman 596870 596870 Rotenay, William, of Kynston, husbandman 4
4687976 2261807 2261807 defendant Parys John husbandman 596870 596870 Parys, John, of Kynston, husbandman 1
5241706 2427783 2427783 defendant Johnson Nicholas yeoman 596870 596870 Johnson, Nicholas, of Kynston, yeoman 1
5318500 2450629 2450629 defendant Blour Richard husbandman 596870 596870 Blour, Richard, of Kynston, husbandman 0
5370206 2466267 2466267 defendant Bulte Richard husbandman 596870 596870 Bulte, Richard, of Kynston, husbandman 0
5519013 2510790 2510790 defendant Rydyngis Henry clerk 596870 596870 Rydyngis, Henry, of Kynston, clerk 1
5593960 2533102 2533102 defendant Ryddyngys Henry clerk 596870 596870 Ryddyngys, Henry, of Kynston, clerk 0
5593961 2533102 2533102 defendant Heyghwall George yeoman 596870 596870 Heyghwall, George, of Kynston, yeoman 1
5593962 2533102 2533102 defendant Eyton William yeoman 596870 596870 Eyton, William, of Kynston, yeoman 2
5593963 2533102 2533102 defendant Borough George laborer 596870 596870 Borough, George, of Kynston, laborer 3

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