names

29 rows where place_id = 616912

✎ 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
3617250 1873018 1873018 defendant Coton John (legal representative) 616912 616912 Coton, John, of Panfeld, executrix of 2
3716763 1931534 1931534 plaintiff Cotton Sigismund esq 616912 616912 Cotton, Sigismund, of Panfeld, esq 0
3893343 1988007 1988007 defendant Ungle Richard husbandman 616912 616912 Ungle, Richard, of Panfeld, husbandman 0
3918403 1996483 1996483 defendant Russell William laborer 616912 616912 Russell, William, of Panfeld, laborer 0
4072548 2050488 2050488 defendant Byckner Thomas husbandman 616912 616912 Byckner, Thomas, of Panfeld, husbandman 0
4278862 2122542 2122542 defendant Goodaye John yeoman 616912 616912 Goodaye, John, of Panfeld, yeoman 0
4505453 2202234 2202234 defendant Kehoo John   616912 616912 Kehoo, John, of Panfeld, junior 2
4565217 2220694 2220694 defendant Langham John   616912 616912 Langham, John, of Panfeld 0
4579879 2225194 2225194 defendant Cowes John, sen   616912 616912 Cowes, John, sen, of Panfeld 0
4672824 2257142 2257142 defendant Turnour Nicholas (legal representative) 616912 616912 Turnour, Nicholas, of Panfeld, executor of 0
4693590 2263496 2263496 defendant Cohoo John yeoman 616912 616912 Cohoo, John, of Panfeld, yeoman 3
4723686 2272713 2272713 defendant Richolde John husbandman 616912 616912 Richolde, John, of Panfeld, husbandman 2
4762292 2284186 2284186 defendant Petevyle John husbandman 616912 616912 Petevyle, John, of Panfeld, husbandman 1
4770890 2286874 2286874 defendant Chelmeshoo John husbandman 616912 616912 Chelmeshoo, John, of Panfeld, husbandman 0
4776725 2288712 2288712 defendant Cohoo John husbandman 616912 616912 Cohoo, John, of Panfeld, husbandman 2
4776726 2288712 2288712 defendant Chelmesho john husbandman 616912 616912 Chelmesho, john, of Panfeld, husbandman 3
4780642 2289945 2289945 defendant Cohoo John husbandman 616912 616912 Cohoo, John, of Panfeld, husbandman 0
4789288 2292711 2292711 defendant Cohoo John, junior husbandman 616912 616912 Cohoo, John, junior, of Panfeld, husbandman 2
4795720 2294812 2294812 defendant Chelmeshoo John husbandman 616912 616912 Chelmeshoo, John, of Panfeld, husbandman 0
4796783 2295146 2295146 defendant Cohoo John, junior husbandman 616912 616912 Cohoo, John, junior, of Panfeld, husbandman 0
4796784 2295146 2295146 defendant Richaud or Richand Richard, junior herder 616912 616912 Richaud or Richand, Richard, junior, of Panfeld, herder 1
4808596 2298855 2298855 defendant Cohoo John husbandman 616912 616912 Cohoo, John, of Panfeld, husbandman 1
4808597 2298855 2298855 defendant Chelmysho John husbandman 616912 616912 Chelmysho, John, of Panfeld, husbandman 2
4966740 2346986 2346986 defendant Coho John, senior husbandman 616912 616912 Coho, John, senior, of Panfeld, husbandman 0
5176074 2408688 2408688 defendant Shelde John yeoman 616912 616912 Shelde, John, of Panfeld, yeoman 0
5235831 2426058 2426058 defendant Stokke Thomas gent 616912 616912 Stokke, Thomas, of Panfeld, gent 1
5627317 2552511 2552511 defendant Cohoo John husbandman 616912 616912 Cohoo, John, of Panfeld, husbandman 1
5631187 2553763 2553763 defendant Chilmesho John collier 616912 616912 Chilmesho, John, of Panfeld, collier 0
5631196 2553765 2553765 defendant Estfeld John husbandman 616912 616912 Estfeld, John, of Panfeld, husbandman 5

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