names

26 rows where place_id = 627584

✎ 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
3777123 1950595 1950595 defendant Mathu Henry fisherman 627584 627584 Mathu, Henry, of Stonehous, fisherman 0
3777125 1950595 1950595 defendant Bryan John fisherman 627584 627584 Bryan, John, of Stonehous, fisherman 2
3777126 1950595 1950595 defendant Donell William fisherman 627584 627584 Donell, William, of Stonehous, fisherman 3
3830608 1967454 1967454 plaintiff Fowler Richard clothman 627584 627584 Fowler, Richard, of Stonehous, clothman 0
4659097 2248715 2248715 defendant Amfrey Thomas husbandman 627584 627584 Amfrey, Thomas, of Stonehous, husbandman 0
4670012 2256320 2256320 defendant Jay William yeoman 627584 627584 Jay, William, of Stonehous, yeoman 0
4684622 2260788 2260788 defendant Derneford Stephen gent 627584 627584 Derneford, Stephen, of Stonehous, gent 3
4779407 2289542 2289542 defendant Benet John husbandman 627584 627584 Benet, John, of Stonehous, husbandman 4
4779412 2289543 2289543 defendant Benet John husbandman 627584 627584 Benet, John, of Stonehous, husbandman 3
4791561 2293453 2293453 defendant Frynsshe John tailor 627584 627584 Frynsshe, John, of Stonehous, tailor 0
5068192 2376991 2376991 defendant Durneford William gent 627584 627584 Durneford, William, of Stonehous, gent 0
5130337 2395360 2395360 defendant Mylle John   627584 627584 Mylle, John, of Stonehous, vicar 0
5149692 2401039 2401039 defendant Mille John   627584 627584 Mille, John, of Stonehous, vicar 0
5168550 2406517 2406517 defendant Mille John   627584 627584 Mille, John, of Stonehous, vicar 0
5223458 2422554 2422554 defendant Wylkyn John smith 627584 627584 Wylkyn, John, of Stonehous, smith 1
5226795 2423500 2423500 defendant Essetur John yeoman 627584 627584 Essetur, John, of Stonehous, yeoman 1
5238949 2426981 2426981 defendant Mille John clerk 627584 627584 Mille, John, of Stonehous, clerk 0
5355495 2461791 2461791 defendant Ellond William gent 627584 627584 Ellond, William, of Stonehous, gent 2
5357923 2462545 2462545 defendant Waryn Thomas husbandman 627584 627584 Waryn, Thomas, of Stonehous, husbandman 2
5481250 2499339 2499339 defendant Waren Thomas yeoman 627584 627584 Waren, Thomas, of Stonehous, yeoman 0
5510409 2508097 2508097 plaintiff Harry Robert mariner 627584 627584 Harry, Robert, of Stonehous, mariner 0
5547040 2519141 2519141 defendant Myll William husbandman 627584 627584 Myll, William, of Stonehous, husbandman 0
5547041 2519141 2519141 defendant Colyer Robert fuller 627584 627584 Colyer, Robert, of Stonehous, fuller 1
5547042 2519141 2519141 defendant Langcastell Miles tailor 627584 627584 Langcastell, Miles, of Stonehous, tailor 2
5547043 2519141 2519141 defendant Toppe John husbandman 627584 627584 Toppe, John, of Stonehous, husbandman 3
5547044 2519141 2519141 defendant Yomans John butcher 627584 627584 Yomans, John, of Stonehous, butcher 4

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