names

40 rows where place_id = 599509

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3637077 1906396 1906396 defendant Merewydder Thomas husbandman 599509 599509 Merewydder, Thomas, of Batheley, husbandman 2
3697710 1925508 1925508 defendant Merewether Thomas husbandman 599509 599509 Merewether, Thomas, of Batheley, husbandman 1
3756170 1943890 1943890 plaintiff Alward Thomas   599509 599509 Alward, Thomas, of Batheley 0
3770724 1948527 1948527 defendant Meryweder Thomas husbandman 599509 599509 Meryweder, Thomas, of Batheley, husbandman 0
3775036 1949925 1949925 defendant Hygdon Richard pewterer 599509 599509 Hygdon, Richard, of Batheley, pewterer 0
3853139 1974603 1974603 plaintiff Shaxton Thomas   599509 599509 Shaxton, Thomas, of Batheley 0
3861474 1977298 1977298 defendant Merywether Thomas husbandman 599509 599509 Merywether, Thomas, of Batheley, husbandman 0
3903419 1991368 1991368 plaintiff Calle John gent 599509 599509 Calle, John, of Batheley, gent 2
3905918 1992263 1992263 defendant Wyatt John husbandman 599509 599509 Wyatt, John, of Batheley, husbandman 2
3946158 2005733 2005733 plaintiff Bulleyn Robert yeoman 599509 599509 Bulleyn, Robert, of Batheley, yeoman 0
3946159 2005733 2005733 defendant Shaxton Nicholas yeoman 599509 599509 Shaxton, Nicholas, of Batheley, yeoman 0
4009137 2028035 2028035 plaintiff Myght Geoffrey   599509 599509 Myght, Geoffrey, of Batheley 0
4079863 2053099 2053099 defendant Dygbye Thomas gent 599509 599509 Dygbye, Thomas, of Batheley, gent 3
4189171 2091705 2091705 defendant Framyngham Edmund   599509 599509 Framyngham, Edmund, of Batheley, ploughwright 0
4198929 2095182 2095182 defendant Carr Thomas husbandman 599509 599509 Carr, Thomas, of Batheley, or of Balle, husbandman 0
4517476 2205861 2205861 defendant Selston William   599509 599509 Selston, William, of Batheley 0
4530477 2209828 2209828 defendant Gelston William de   599509 599509 Gelston, William de, of Batheley 0
4561077 2219418 2219418 defendant Gelston William   599509 599509 Gelston, William, of Batheley 1
4663938 2250205 2250205 defendant Gelston Thomas   599509 599509 Gelston, Thomas, of Batheley, franklin 1
4673027 2257208 2257208 defendant Brewelove Robert husbandman 599509 599509 Brewelove, Robert, of Batheley, husbandman 1
4791684 2293497 2293497 defendant Trewelofe Robert husbandman 599509 599509 Trewelofe, Robert, of Batheley, husbandman 2
4808656 2298872 2298872 defendant Whyte William   599509 599509 Whyte, William, of Batheley 0
4815622 2300994 2300994 defendant Whyte William husbandman 599509 599509 Whyte, William, of Batheley, husbandman 0
4853867 2312619 2312619 defendant Wallley John husbandman 599509 599509 Wallley, John, of Batheley, husbandman 2
4944462 2340246 2340246 defendant Walley John husbandman 599509 599509 Walley, John, of Batheley, husbandman 0
4944463 2340246 2340246 defendant White William, junior husbandman 599509 599509 White, William, junior, of Batheley, husbandman 1
4983522 2351987 2351987 defendant Davy Richard laborer 599509 599509 Davy, Richard, of Batheley, laborer 0
5007715 2359147 2359147 defendant Gelston William gent 599509 599509 Gelston, William, of Batheley, gent 0
5007717 2359148 2359148 defendant Gelston William gent 599509 599509 Gelston, William, of Batheley, gent 0
5170450 2407086 2407086 defendant Walker John husbandman 599509 599509 Walker, John, of Batheley, husbandman 0
5248515 2429690 2429690 defendant Gelston Wiliam gent 599509 599509 Gelston, Wiliam, of Batheley, gent 0
5406389 2476899 2476899 defendant Helot Richard husbandman 599509 599509 Helot, Richard, of Batheley, husbandman 0
5515003 2509534 2509534 defendant Robertson John yeoman 599509 599509 Robertson, John, of Batheley, yeoman 3
5515008 2509535 2509535 defendant Robertson John yeoman 599509 599509 Robertson, John, of Batheley, yeoman 0
5544384 2518352 2518352 plaintiff Robertson John   599509 599509 Robertson, John, of Batheley 0
5557570 2522168 2522168 defendant Smyth John   599509 599509 Smyth, John, of Batheley, wright 1
5557573 2522169 2522169 defendant Smyth John   599509 599509 Smyth, John, of Batheley, wright 1
5587146 2531008 2531008 defendant Newton John husbandman 599509 599509 Newton, John, of Batheley, husbandman 0
5589691 2531773 2531773 defendant Walker John yeoman 599509 599509 Walker, John, of Batheley, yeoman 1
5601038 2535211 2535211 defendant Merewether Thomas husbandman 599509 599509 Merewether, Thomas, of Batheley, husbandman 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);