names

38 rows where place_id = 611870

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3690453 1923181 1923181 defendant Orgill John carpenter 611870 611870 Orgill, John, of Burstowe, carpenter 0
3690455 1923182 1923182 defendant Orgill John carpenter 611870 611870 Orgill, John, of Burstowe, carpenter 0
3709202 1929173 1929173 defendant A Chert John husbandman 611870 611870 A Chert, John, of Burstowe, husbandman 0
3711261 1929825 1929825 defendant Roughey William husbandman 611870 611870 Roughey, William, of Burstowe, husbandman 0
3730525 1935781 1935781 defendant Wellys Henry husbandman 611870 611870 Wellys, Henry, of Burstowe, husbandman 0
3730526 1935781 1935781 defendant Roughey Thomas husbandman 611870 611870 Roughey, Thomas, of Burstowe, husbandman 1
3782860 1952389 1952389 defendant Grame Robert collier 611870 611870 Grame, Robert, of Burstowe, collier 1
3782861 1952389 1952389 defendant Busse John husbandman 611870 611870 Busse, John, of Burstowe, husbandman 2
3810194 1961080 1961080 defendant Wellys Henry husbandman 611870 611870 Wellys, Henry, of Burstowe, husbandman 0
3810195 1961080 1961080 defendant Roughey Thomas husbandman 611870 611870 Roughey, Thomas, of Burstowe, husbandman 1
3839431 1970257 1970257 defendant A Charte Marion widow 611870 611870 A Charte, Marion, of Burstowe, widow 0
3839432 1970257 1970257 defendant A Charte John laborer 611870 611870 A Charte, John, of Burstowe, laborer 1
3839433 1970257 1970257 defendant Gardener William laborer 611870 611870 Gardener, William, of Burstowe, laborer 2
3900352 1990353 1990353 defendant Charte John husbandman 611870 611870 Charte, John, of Burstowe, husbandman 0
3914204 1995095 1995095 defendant Charte John husbandman 611870 611870 Charte, John, of Burstowe, husbandman 0
4277277 2121984 2121984 defendant Smyth Richard tanner 611870 611870 Smyth, Richard, of Burstowe, tanner 0
4277915 2122206 2122206 defendant Hushe Richard gent 611870 611870 Hushe, Richard, of Burstowe, or of Cockfeild, Sussex, gent 0
4277916 2122206 2122206 defendant Ward Thomas gent 611870 611870 Ward, Thomas, of Burstowe, gent 1
4282211 2123677 2123677 defendant Bonnycke William   611870 611870 Bonnycke, William, of Burstowe, brick maker 3
4289118 2126165 2126165 defendant Rumsey Richard butcher 611870 611870 Rumsey, Richard, of Burstowe, or of Chipsted, Kent, butcher 0
4313894 2134963 2134963 defendant Smyth Richard, senior yeoman 611870 611870 Smyth, Richard, senior, of Burstowe, yeoman 0
4313895 2134963 2134963 defendant Smyth William yeoman 611870 611870 Smyth, William, of Burstowe, yeoman 1
4317919 2136379 2136379 defendant Rumsey Richard butcher 611870 611870 Rumsey, Richard, of Burstowe, or of Chipsted, Kent, butcher 0
4329880 2140294 2140294 defendant Smythe Richard tanner 611870 611870 Smythe, Richard, of Burstowe, tanner 1
4368314 2153716 2153716 defendant Pollarde William husbandman 611870 611870 Pollarde, William, of Burstowe, husbandman 5
4368315 2153716 2153716 defendant Owen William husbandman 611870 611870 Owen, William, of Burstowe, husbandman 6
4369752 2154240 2154240 defendant Mysslebrooke or Misselbroughe Lawrence yeoman 611870 611870 Mysslebrooke or Misselbroughe, Lawrence, of Burstowe, yeoman 0
4392505 2162115 2162115 defendant Smythe John   611870 611870 Smythe, John, of Burstowe, surgeon 0
4397433 2163721 2163721 defendant Mislebrooke or Misselbrough Lawrence yeoman 611870 611870 Mislebrooke or Misselbrough, Lawrence, of Burstowe, yeoman 0
4399663 2164478 2164478 defendant Leskooe John yeoman 611870 611870 Leskooe, John, of Burstowe, yeoman 0
4414339 2169398 2169398 defendant atte Strete John   611870 611870 atte Strete, John, of Burstowe 0
4420916 2171436 2171436 plaintiff Chalres Adam   611870 611870 Chalres, Adam, of Burstowe 0
4495196 2199181 2199181 defendant Clerk Walter   611870 611870 Clerk, Walter, of Burstowe 2
4745976 2279324 2279324 defendant Busse Robert husbandman 611870 611870 Busse, Robert, of Burstowe, husbandman 1
4745977 2279324 2279324 defendant Busse John husbandman 611870 611870 Busse, John, of Burstowe, husbandman 2
5351038 2460431 2460431 defendant Uhurst James yeoman 611870 611870 Uhurst, James, of Burstowe, yeoman 2
5512910 2508893 2508893 defendant Hert Richard husbandman 611870 611870 Hert, Richard, of Burstowe, husbandman 4
5575553 2527439 2527439 defendant Orgell John carpenter 611870 611870 Orgell, John, of Burstowe, carpenter 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);