names

41 rows where place_id = 586027

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587732 1863808 1863808 defendant Michell Thomas chandler 586027 586027 Michell, Thomas, of Princes Rysburgh, chandler 0
3593030 1865448 1865448 defendant hawes Thomas husbandman 586027 586027 hawes, Thomas, of Princes Rysburgh, husbandman 0
3821911 1964743 1964743 defendant Coterell John husbandman 586027 586027 Coterell, John, of Princes Rysburgh, husbandman 3
4747368 2279733 2279733 plaintiff Kene William   586027 586027 Kene, William, of Princes Rysburgh 0
4747369 2279733 2279733 plaintiff Orchard John   586027 586027 Orchard, John, of Princes Rysburgh 1
4803070 2297147 2297147 plaintiff Bailly John esq 586027 586027 Bailly, John, of Princes Rysburgh, esq, on his own account 0
4877660 2319972 2319972 defendant Clerk Richard chandler 586027 586027 Clerk, Richard, of Princes Rysburgh, chandler 0
4888184 2323110 2323110 defendant Godman Thomas smith 586027 586027 Godman, Thomas, of Princes Rysburgh, smith 0
4889861 2323618 2323618 defendant Hawes Richard husbandman 586027 586027 Hawes, Richard, of Princes Rysburgh, husbandman 0
4889862 2323618 2323618 defendant Hawes Thomas laborer 586027 586027 Hawes, Thomas, of Princes Rysburgh, laborer 1
4908901 2329331 2329331 defendant Gomme William husbandman 586027 586027 Gomme, William, of Princes Rysburgh, husbandman 0
4934708 2337249 2337249 defendant Claydon alias Chalener Richard carpenter 586027 586027 Claydon alias Chalener, Richard, of Princes Rysburgh, carpenter 0
4940755 2339135 2339135 defendant Caulyn of Canlyn Thomas husbandman 586027 586027 Caulyn of Canlyn, Thomas, of Princes Rysburgh, husbandman 0
4946829 2341013 2341013 defendant Playtour John husbandman 586027 586027 Playtour, John, of Princes Rysburgh, husbandman 0
4964958 2346434 2346434 defendant Morden Henry husbandman 586027 586027 Morden, Henry, of Princes Rysburgh, husbandman 0
4969958 2347964 2347964 defendant Lokwode John chapman 586027 586027 Lokwode, John, of Princes Rysburgh, chapman 0
4991048 2354213 2354213 defendant Grene John yeoman 586027 586027 Grene, John, of Princes Rysburgh, yeoman 0
5068752 2377151 2377151 defendant Kene Thomas gent 586027 586027 Kene, Thomas, of Princes Rysburgh, gent 0
5097537 2385709 2385709 defendant Reyner Henry yeoman 586027 586027 Reyner, Henry, of Princes Rysburgh, yeoman 0
5183353 2410871 2410871 defendant Bemond Richard husbandman 586027 586027 Bemond, Richard, of Princes Rysburgh, husbandman 0
5189443 2412651 2412651 defendant Campyon William smith 586027 586027 Campyon, William, of Princes Rysburgh, smith 0
5206508 2417635 2417635 defendant Campion William smith 586027 586027 Campion, William, of Princes Rysburgh, smith 0
5208078 2418094 2418094 defendant Nyxun Andrew butcher 586027 586027 Nyxun, Andrew, of Princes Rysburgh, butcher 1
5213887 2419792 2419792 defendant Grene John yeoman 586027 586027 Grene, John, of Princes Rysburgh, yeoman 0
5221221 2421905 2421905 defendant Nykson Andrew husbandman or drover 586027 586027 Nykson, Andrew, of Princes Rysburgh, husbandman or drover 1
5237849 2426653 2426653 defendant Nykson Andrew butcher 586027 586027 Nykson, Andrew, of Princes Rysburgh, butcher 3
5238064 2426724 2426724 defendant Nyxon Andrew butcher 586027 586027 Nyxon, Andrew, of Princes Rysburgh, butcher 0
5238065 2426724 2426724 defendant Hare William butcher 586027 586027 Hare, William, of Princes Rysburgh, butcher 1
5238083 2426727 2426727 plaintiff Grene John   586027 586027 Grene, John, of Princes Rysburgh 0
5238087 2426727 2426727 defendant Pendeley John butcher 586027 586027 Pendeley, John, of Princes Rysburgh, butcher 3
5238088 2426727 2426727 defendant Wheler John butcher 586027 586027 Wheler, John, of Princes Rysburgh, butcher 4
5238093 2426728 2426728 defendant Pendley John butcher 586027 586027 Pendley, John, of Princes Rysburgh, butcher 3
5238094 2426728 2426728 defendant Wheler John butcher 586027 586027 Wheler, John, of Princes Rysburgh, butcher 4
5238095 2426729 2426729 plaintiff Grene John yeoman 586027 586027 Grene, John, of Princes Rysburgh, yeoman 0
5238096 2426729 2426729 defendant Nykson Andrew butcher 586027 586027 Nykson, Andrew, of Princes Rysburgh, butcher 0
5362103 2463810 2463810 defendant Hamond Thomas husbandman 586027 586027 Hamond, Thomas, of Princes Rysburgh, husbandman 3
5366337 2465125 2465125 defendant Benell Isabel widow 586027 586027 (Benell, Isabel, of Princes Rysburgh, widow 1
5367914 2465589 2465589 defendant Pynchon John chapman 586027 586027 Pynchon, John, of Princes Rysburgh, chapman 0
5368957 2465882 2465882 defendant Grene John   586027 586027 Grene, John, of Princes Rysburgh, wool man 0
5543124 2517969 2517969 defendant Skipwell John tailor 586027 586027 Skipwell, John, of Princes Rysburgh, tailor 1
5563571 2523952 2523952 defendant Prynce John husbandman 586027 586027 Prynce, John, of Princes Rysburgh, husbandman 0

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