names

28 rows where place_id = 586797

✎ 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
3589645 1864405 1864405 plaintiff Cantelowe Geoffrey gent 586797 586797 Cantelowe, Geoffrey, of Bansted, gent 0
3659095 1913104 1913104 defendant Colcoke Richard yeoman 586797 586797 Colcoke, Richard, of Bansted, yeoman 0
3664641 1914895 1914895 defendant Saunder Thomas, senior husbandman 586797 586797 Saunder, Thomas, senior, of Bansted, husbandman 0
3864909 1978468 1978468 plaintiff Marlande Edward gent 586797 586797 Marlande, Edward, of Bansted, gent 0
4012295 2029117 2029117 defendant Woodward Richard husbandman 586797 586797 Woodward, Richard, of Bansted, husbandman 2
4012299 2029118 2029118 defendant Woodward Richard husbandman 586797 586797 Woodward, Richard, of Bansted, husbandman 2
4100281 2060435 2060435 defendant Johnson John tailor 586797 586797 Johnson, John, of Bansted, tailor 0
4100282 2060435 2060435 defendant Lusted John husbandman 586797 586797 Lusted, John, of Bansted, husbandman 1
4363646 2152070 2152070 defendant Hawkyns Richard butcher 586797 586797 Hawkyns, Richard, of Bansted, butcher 0
4378419 2157355 2157355 defendant Mathewe William husbandman 586797 586797 Mathewe, William, of Bansted, husbandman 1
4393626 2162473 2162473 defendant Hawkyns Richard butcher 586797 586797 Hawkyns, Richard, of Bansted, butcher 0
4398664 2164132 2164132 defendant Kinge George, junior   586797 586797 Kinge, George, junior, of Bansted, yeoman, his son 1
4421769 2171689 2171689 defendant Tykenore Richard de   586797 586797 Tykenore, Richard de, of Bansted 7
4678319 2258827 2258827 defendant Lampet John husbandman 586797 586797 Lampet, John, of Bansted, husbandman 2
4918962 2332444 2332444 defendant Lampit John husbandman 586797 586797 Lampit, John, of Bansted, husbandman 0
4963519 2346002 2346002 defendant Wythmer John, junior husbandman 586797 586797 Wythmer, John, junior, of Bansted, husbandman 0
4963520 2346002 2346002 defendant Wythmer John, senior farmer 586797 586797 Wythmer, John, senior, of Bansted, farmer 1
5395219 2473705 2473705 defendant Croke Thomas yeoman 586797 586797 Croke, Thomas, of Bansted, yeoman 1
5397664 2474401 2474401 plaintiff Broun John   586797 586797 Broun, John, of Bansted 5
5397665 2474401 2474401 plaintiff Puplet John yeoman 586797 586797 Puplet, John, of Bansted, yeoman 6
5397666 2474401 2474401 plaintiff Storyer John   586797 586797 Storyer, John, of Bansted 7
5397668 2474401 2474401 plaintiff Croke Thomas yeoman 586797 586797 Croke, Thomas, of Bansted, yeoman 9
5520884 2511352 2511352 plaintiff Cantlowe Geoffrey gent 586797 586797 Cantlowe, Geoffrey, of Bansted, gent 0
5565681 2524553 2524553 plaintiff Cantlowe Geoffrey gent 586797 586797 Cantlowe, Geoffrey, of Bansted, gent 0
5565686 2524553 2524553 defendant Williams John carpenter 586797 586797 Williams, John, of Bansted, carpenter 4
5578329 2528292 2528292 defendant Walshe John smith 586797 586797 Walshe, John, of Bansted, smith 0
5578330 2528292 2528292 defendant Hill John husbandman 586797 586797 Hill, John, of Bansted, husbandman 1
5586421 2530791 2530791 defendant White Nicholas husbandman 586797 586797 White, Nicholas, of Bansted, husbandman 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);