names

33 rows where place_id = 615789

✎ 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
3710772 1929687 1929687 defendant Scutte John, senior carpenter 615789 615789 Scutte, John, senior, of West Burton, carpenter 1
3710774 1929687 1929687 defendant A Stapyll Richard husbandman 615789 615789 A Stapyll, Richard, of West Burton, husbandman 3
3725367 1934226 1934226 defendant Scutt John, senior carpenter 615789 615789 Scutt, John, senior, of West Burton, carpenter 1
3803149 1958887 1958887 defendant Rowley Edward yeoman 615789 615789 Rowley, Edward, of West Burton, yeoman 2
4017772 2031067 2031067 plaintiff Tonge Richard husbandman 615789 615789 Tonge, Richard, of West Burton, husbandman 0
4060788 2046265 2046265 defendant Clarke Peter husbandman 615789 615789 Clarke, Peter, of West Burton, husbandman 0
4060789 2046265 2046265 defendant Tonge Richard husbandman 615789 615789 Tonge, Richard, of West Burton, husbandman 1
4060790 2046265 2046265 defendant Denbye Richard husbandman 615789 615789 Denbye, Richard, of West Burton, husbandman 2
4060791 2046265 2046265 defendant Holme Humphrey husbandman 615789 615789 Holme, Humphrey, of West Burton, husbandman 3
4061584 2046540 2046540 defendant Denton Thomas yeoman 615789 615789 Denton, Thomas, of West Burton, yeoman 2
4130165 2071096 2071096 defendant Gatehowse John yeoman 615789 615789 Gatehowse, John, of West Burton, yeoman 0
4139031 2074330 2074330 defendant Denbie Richard yeoman 615789 615789 Denbie, Richard, of West Burton, yeoman 1
4139043 2074334 2074334 defendant Clarke Peter husbandman 615789 615789 Clarke, Peter, of West Burton, husbandman 1
4139044 2074334 2074334 defendant Tonge Richard (legal representative) 615789 615789 Tonge, Richard, of West Burton, husbandman, executors of 2
4139045 2074334 2074334 defendant Tonge Jenetta widow 615789 615789 (Tonge, Jenetta, of West Burton, widow 3
4139046 2074334 2074334 defendant Tonge Michael husbandman 615789 615789 Tonge, Michael, of West Burton, husbandman 4
4216334 2101206 2101206 defendant Tonge Michael yeoman 615789 615789 Tonge, Michael, of West Burton, yeoman 0
4225653 2104438 2104438 defendant Tonge Michael yeoman 615789 615789 Tonge, Michael, of West Burton, yeoman 0
4886841 2322739 2322739 defendant Haryngton John esq 615789 615789 Haryngton, John, of West Burton, esq 1
4893142 2324571 2324571 defendant Haryngton John esq 615789 615789 Haryngton, John, of West Burton, esq 1
4934974 2337343 2337343 defendant Grentham John husbandman 615789 615789 Grentham, John, of West Burton, husbandman 2
4952739 2342776 2342776 defendant atte Halle William gent 615789 615789 atte Halle, William, of West Burton, gent 0
5005559 2358525 2358525 defendant Grygger John husbandman 615789 615789 Grygger, John, of West Burton, husbandman 2
5030681 2365843 2365843 defendant atte Hall William husbandman 615789 615789 atte Hall, William, of West Burton, husbandman 0
5030683 2365843 2365843 defendant Colles William husbandman 615789 615789 Colles, William, of West Burton, husbandman 2
5117494 2391549 2391549 defendant Skutte Nicholas husbandman 615789 615789 Skutte, Nicholas, of West Burton, husbandman 0
5117495 2391549 2391549 defendant Grentham John husbandman 615789 615789 Grentham, John, of West Burton, husbandman 1
5117496 2391549 2391549 defendant Sergeaunt Robert husbandman 615789 615789 Sergeaunt, Robert, of West Burton, husbandman 2
5117498 2391549 2391549 defendant Perham John husbandman 615789 615789 Perham, John, of West Burton, husbandman 4
5164846 2405451 2405451 defendant Rykeford Nicholas carpenter 615789 615789 Rykeford, Nicholas, of West Burton, carpenter 0
5178399 2409390 2409390 defendant Rykeford Nicholas carpenter 615789 615789 Rykeford, Nicholas, of West Burton, carpenter 0
5201421 2416172 2416172 defendant Rykeford Nicholas carpenter 615789 615789 Rykeford, Nicholas, of West Burton, carpenter 0
5201424 2416173 2416173 defendant Rykeford Nicholas carpenter 615789 615789 Rykeford, Nicholas, of West Burton, carpenter 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);