names

26 rows where place_id = 586677

✎ 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
3589349 1864310 1864310 defendant Water John husbandman 586677 586677 Water, John, of Marlyngford, husbandman 1
3708078 1928827 1928827 defendant Foster John husbandman 586677 586677 Foster, John, of Marlyngford, husbandman 3
3873636 1981398 1981398 plaintiff Chapman John yeoman 586677 586677 Chapman, John, of Marlyngford, yeoman 0
3986619 2019953 2019953 defendant Elye Richard husbandman 586677 586677 Elye, Richard, of Marlyngford, husbandman 1
4059255 2045703 2045703 defendant Hollande Robert yeoman 586677 586677 Hollande, Robert, of Marlyngford, yeoman 0
4327395 2139486 2139486 defendant Nycoll John comber 586677 586677 Nycoll, John, of Marlyngford, comber 0
4410192 2168011 2168011 defendant Sherlowe William husbandman 586677 586677 Sherlowe, William, of Marlyngford, husbandman 0
4416372 2170008 2170008 defendant Buk Geoffrey   586677 586677 Buk, Geoffrey, of Marlyngford 4
4514547 2204969 2204969 defendant Bokebroke Robert   586677 586677 Bokebroke, Robert, of Marlyngford 0
4518014 2206012 2206012 plaintiff Davy John   586677 586677 Davy, John, of Marlyngford 0
4575913 2223954 2223954 defendant Davy Geoffrey   586677 586677 Davy, Geoffrey, of Marlyngford 2
4595183 2229748 2229748 defendant Davy John   586677 586677 Davy, John, of Marlyngford 2
4595196 2229749 2229749 defendant Davy John   586677 586677 Davy, John, of Marlyngford 2
5062199 2375252 2375252 defendant Davy Robert husbandman 586677 586677 Davy, Robert, of Marlyngford, husbandman 0
5116760 2391336 2391336 defendant Amye Thomas yeoman 586677 586677 Amye, Thomas, of Marlyngford, yeoman 1
5290935 2442352 2442352 defendant Gerold Thomas husbandman 586677 586677 Gerold, Thomas, of Marlyngford, husbandman 1
5354907 2461609 2461609 defendant Claryngton John husbandman 586677 586677 Claryngton, John, of Marlyngford, husbandman 3
5355723 2461867 2461867 defendant Jerald Thomas husbandman 586677 586677 Jerald, Thomas, of Marlyngford, husbandman 0
5358367 2462669 2462669 defendant Myllys Robert husbandman 586677 586677 Myllys, Robert, of Marlyngford, husbandman 0
5358368 2462669 2462669 defendant Myllys John miller 586677 586677 Myllys, John, of Marlyngford, miller 1
5531988 2514548 2514548 defendant Davy Katherine widow 586677 586677 Davy, Katherine, of Marlyngford, widow 0
5531989 2514548 2514548 defendant Davy John husbandman 586677 586677 Davy, John, of Marlyngford, husbandman 1
5538894 2516651 2516651 plaintiff Foster John   586677 586677 Foster, John, of Marlyngford 0
5541304 2517395 2517395 defendant Milles Robert husbandman 586677 586677 Milles, Robert, of Marlyngford, husbandman 1
5569688 2525704 2525704 defendant Toly Thomas husbandman 586677 586677 Toly, Thomas, of Marlyngford, husbandman 2
5632731 2554252 2554252 defendant Knebord John tailor 586677 586677 Knebord, John, of Marlyngford, tailor 1

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