names

22 rows where place_id = 601747

✎ 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
3646829 1909410 1909410 defendant Burcombe Richard weaver 601747 601747 Burcombe, Richard, of Kyngeswode, weaver 9
3646830 1909410 1909410 defendant Chamber Thomas tucker 601747 601747 Chamber, Thomas, of Kyngeswode, tucker 10
3646838 1909412 1909412 defendant Bircombe Richard weaver 601747 601747 Bircombe, Richard, of Kyngeswode, weaver 3
3646839 1909412 1909412 defendant Chamber Thomas ticker 601747 601747 Chamber, Thomas, of Kyngeswode, ticker 4
3697116 1925318 1925318 defendant Ameryk Thomas fuller 601747 601747 Ameryk, Thomas, of Kyngeswode, fuller 1
4566409 2221065 2221065 plaintiff Stevenes Nicholas   601747 601747 Stevenes, Nicholas, of Kyngeswode 0
4707791 2267804 2267804 defendant Belly John, sen husbandman 601747 601747 Belly, John, sen, of Kyngeswode, husbandman 0
4722508 2272356 2272356 defendant Thorney Richard husbandman 601747 601747 Thorney, Richard, of Kyngeswode, husbandman 3
5020821 2362986 2362986 defendant Wade Thomas fuller 601747 601747 Wade, Thomas, of Kyngeswode, fuller 2
5050150 2371669 2371669 defendant Jacop John fuller 601747 601747 Jacop, John, of Kyngeswode, fuller 0
5074648 2378920 2378920 defendant Southern Richard dyer 601747 601747 Southern, Richard, of Kyngeswode, dyer 0
5090697 2383664 2383664 defendant Aleyn Thomas husbandman 601747 601747 Aleyn, Thomas, of Kyngeswode, or of Ewell, husbandman 0
5169708 2406880 2406880 defendant Southerne Richard dyer 601747 601747 (Southerne, Richard, of Kyngeswode, dyer 1
5183926 2411035 2411035 defendant Penhale John husbandman 601747 601747 Penhale, John, of Kyngeswode, husbandman 4
5204070 2416939 2416939 defendant Penhale John husbandman 601747 601747 Penhale John, of Kyngeswode, husbandman 4
5217758 2420922 2420922 defendant Southern Richard dyer 601747 601747 (Southern, Richard, of Kyngeswode, dyer 4
5236118 2426148 2426148 defendant Southerne Richard dyer 601747 601747 Southerne, Richard, of Kyngeswode, dyer 1
5369931 2466186 2466186 defendant Cosyn John fuller of cloth 601747 601747 Cosyn, John, of Kyngeswode, fuller of cloth 1
5594846 2533357 2533357 defendant Weldon Gregory clothier 601747 601747 Weldon, Gregory, of Kyngeswode, clothier 0
5597225 2534041 2534041 defendant Barret Richard clothier 601747 601747 Barret, Richard, of Kyngeswode, clothier 1
5597226 2534041 2534041 defendant Hewys Thomas smith 601747 601747 Hewys, Thomas, of Kyngeswode, smith 2
5597227 2534041 2534041 defendant Baldon Thomas yeoman 601747 601747 Baldon, Thomas, of Kyngeswode, yeoman 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);