names

28 rows where place_id = 608780

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3674180 1917962 1917962 plaintiff Garyngton John, senior (legal representative) 608780 608780 Garyngton, John, senior, of Munden, executors of 0
3675371 1918335 1918335 defendant Andrewe John, junior husbandman 608780 608780 Andrewe, John, junior, of Munden, husbandman 0
3732671 1936449 1936449 defendant Auncell Robert husbandman 608780 608780 Auncell, Robert, of Munden, husbandman 0
3866490 1979021 1979021 defendant Herrys William gent 608780 608780 Herrys, William, of Munden, gent 0
3951934 2007740 2007740 plaintiff Harrys Vincent gent 608780 608780 Harrys, Vincent, of Munden, gent 0
4325718 2138977 2138977 defendant Markes Walter yeoman 608780 608780 (Markes, Walter, of Munden, yeoman 3
4470794 2191517 2191517 defendant Frensshe Peter   608780 608780 Frensshe, Peter, of Munden 1
4484965 2195997 2195997 plaintiff Prentys John   608780 608780 Prentys, John, of Munden, on his own account 0
4492767 2198439 2198439 defendant Auncell John   608780 608780 Auncell, John, of Munden 2
4527419 2208853 2208853 defendant Chapman John   608780 608780 Chapman, John, of Munden 0
4547008 2214998 2214998 defendant Pottere John smith 608780 608780 Pottere, John, of Munden, smith 0
4549037 2215631 2215631 defendant Reigne John   608780 608780 Reigne, John, of Munden 2
4560318 2219166 2219166 defendant Cophode John maltman 608780 608780 Cophode, John, of Munden, maltman 0
4560320 2219167 2219167 defendant Cophode John maltman 608780 608780 Cophode, John, of Munden, maltman 0
4605760 2232917 2232917 defendant Benne John   608780 608780 Benne, John, of Munden 2
4613938 2235370 2235370 defendant Kernell William   608780 608780 Kernell, William, of Munden 0
4632765 2241132 2241132 defendant Benne John   608780 608780 Benne, John, of Munden 5
4647480 2245326 2245326 defendant Burnard John   608780 608780 Burnard, John, of Munden 0
4852687 2312261 2312261 defendant Ferour Thomas husbandman 608780 608780 Ferour, Thomas, of Munden, husbandman 2
5063087 2375497 2375497 defendant Abell William   608780 608780 Abell, William, of Munden, servant 2
5202412 2416467 2416467 defendant Shortwode John yeoman 608780 608780 Shortwode, John, of Munden, yeoman 0
5443888 2488090 2488090 defendant Cheff William husbandman 608780 608780 Cheff, William, of Munden, husbandman 0
5483408 2499984 2499984 defendant Wrottyng John maltman 608780 608780 Wrottyng, John, of Munden, maltman 4
5542875 2517889 2517889 defendant Colte John maltman 608780 608780 Colte, John, of Munden, maltman 0
5550750 2520247 2520247 defendant Garyngton John, junior yeoman 608780 608780 Garyngton, John, junior, of Munden, yeoman 1
5565965 2524650 2524650 defendant Garyngton John, junior yeoman 608780 608780 Garyngton, John, junior, of Munden, yeoman 1
5580917 2529105 2529105 defendant Garyngton John, junior yeoman 608780 608780 Garyngton, John, junior, of Munden, yeoman 1
5635455 2555055 2555055 defendant Swayn William husbandman 608780 608780 Swayn, William, of Munden, 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);