names

31 rows where place_id = 612003

✎ 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
3691111 1923382 1923382 plaintiff Hamond Richard   612003 612003 Hamond, Richard, of Depeden 0
3691112 1923382 1923382 defendant Chamberleyn Robert laborer 612003 612003 Chamberleyn, Robert, of Depeden, laborer 0
3748781 1941554 1941554 plaintiff Hamond Richard yeoman 612003 612003 Hamond, Richard, of Depeden, yeoman 0
4438742 2181409 2181409 defendant Makehayt John   612003 612003 Makehayt, John, of Depeden 0
4501881 2201188 2201188 defendant Serbeant Robert   612003 612003 Serbeant, Robert, of Depeden 1
4510962 2203883 2203883 defendant Coker Alice   612003 612003 Coker, Alice, of Depeden 3
4516612 2205608 2205608 defendant Blaksalt John   612003 612003 Blaksalt, John, of Depeden 0
4521956 2207206 2207206 plaintiff Milx Nicholas   612003 612003 Milx, Nicholas, of Depeden 4
4582449 2225950 2225950 defendant Snowedon John   612003 612003 Snowedon, John, of Depeden 0
4625650 2238983 2238983 plaintiff Schussche John   612003 612003 Schussche, John, of Depeden 1
4699351 2265260 2265260 defendant Sparwe John husbandman 612003 612003 (Sparwe, John, of Depeden, husbandman 3
4699352 2265260 2265260 defendant Godewyn John husbandman 612003 612003 Godewyn, John, of Depeden, husbandman 4
4756636 2282441 2282441 defendant Hilte Henry husbandman 612003 612003 Hilte, Henry, of Depeden, husbandman 0
4757836 2282828 2282828 defendant Laurens Alice widow 612003 612003 Laurens, Alice, of Depeden, widow 0
4757837 2282828 2282828 defendant Laurens Roger husbandman 612003 612003 Laurens, Roger, of Depeden, husbandman 1
4847970 2310844 2310844 defendant Warde William husbandman 612003 612003 Warde, William, of Depeden, husbandman 0
4847972 2310844 2310844 defendant Hoggekyn William husbandman 612003 612003 Hoggekyn, William, of Depeden, husbandman 2
4889592 2323542 2323542 defendant Yateman John husbandman 612003 612003 Yateman, John, of Depeden, husbandman 0
4889593 2323542 2323542 defendant Shusche Walter yeoman 612003 612003 Shusche, Walter, of Depeden, yeoman 1
4918830 2332401 2332401 defendant Berners Regianld   612003 612003 Berners, Regianld, of Depeden, parson 0
4919786 2332694 2332694 defendant Wale Thomas laborer 612003 612003 Wale, Thomas, of Depeden, laborer 0
4961392 2345377 2345377 defendant Seriaunt Thomas yeoman 612003 612003 Seriaunt, Thomas, of Depeden, yeoman 0
4975616 2349665 2349665 defendant Heryot John husbandman 612003 612003 Heryot, John, of Depeden, husbandman 0
4975929 2349763 2349763 defendant Sergeaunt Thomas yeoman 612003 612003 Sergeaunt, Thomas, of Depeden, yeoman 0
4985321 2352528 2352528 defendant Wale John husbandman 612003 612003 Wale, John, of Depeden, husbandman 0
5005439 2358493 2358493 defendant Perman John yeoman 612003 612003 Perman, John, of Depeden, yeoman 0
5024439 2364058 2364058 defendant Wale Thomas laborer 612003 612003 Wale, Thomas, of Depeden, laborer 0
5141684 2398677 2398677 defendant Wode John husbandman 612003 612003 Wode, John, of Depeden, husbandman 1
5162756 2404825 2404825 defendant Wrught John carpenter 612003 612003 Wrught, John, of Depeden, carpenter 2
5176682 2408863 2408863 defendant Wode John husbandman 612003 612003 Wode, John, of Depeden, husbandman 1
5176683 2408863 2408863 defendant Wryght John carpenter 612003 612003 Wryght, John, of Depeden, carpenter 2

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