names

45 rows where place_id = 601559

✎ 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
3645867 1909113 1909113 plaintiff Harvy John pensioner 601559 601559 Harvy, John, of Lincolns Inn, pensioner 0
3690378 1923154 1923154 defendant Curson Robert gent 601559 601559 Curson, Robert, of Lincolns Inn, gent 0
3793269 1955753 1955753 defendant Fermer William   601559 601559 Fermer, William, of Lincolns Inn 2
3875064 1981891 1981891 plaintiff Drury Robert esq 601559 601559 Drury, Robert, of Lincolns Inn, esq 0
3955533 2009005 2009005 defendant Morgan Thomas gent 601559 601559 Morgan, Thomas, of Lincolns Inn, gent 0
3961079 2010970 2010970 plaintiff Thorowgood Richard gent 601559 601559 Thorowgood, Richard, of Lincolns Inn, gent 0
3961081 2010971 2010971 plaintiff Thorowgood Richard gent 601559 601559 Thorowgood, Richard, of Lincolns Inn, gent 0
3964724 2012269 2012269 plaintiff Awbrey John gent 601559 601559 Awbrey, John, of Lincolns Inn, gent 0
3982390 2018475 2018475 plaintiff Samwayes Robert gent 601559 601559 Samwayes, Robert, of Lincolns Inn, gent 0
3984781 2019314 2019314 plaintiff Thornton William esq 601559 601559 Thornton, William, of Lincolns Inn, esq 0
3984785 2019315 2019315 plaintiff Thornton William esq 601559 601559 Thornton, William, of Lincolns Inn, esq 0
3993470 2022407 2022407 defendant Scudamore Philip gent 601559 601559 Scudamore, Philip, of Lincolns Inn, gent 1
4001932 2025468 2025468 plaintiff Rand Nicholas gent 601559 601559 Rand, Nicholas, of Lincolns Inn, gent 1
4004908 2026537 2026537 defendant Browne Thomas gent 601559 601559 Browne, Thomas, of Lincolns Inn, gent 0
4015963 2030399 2030399 plaintiff Spret Richard esq 601559 601559 Spret, Richard, of Lincolns Inn, esq 0
4027489 2034477 2034477 plaintiff Clarke Edward gent 601559 601559 Clarke, Edward, of Lincolns Inn, gent 0
4027491 2034478 2034478 plaintiff Clarke Edward gent 601559 601559 Clarke, Edward, of Lincolns Inn, gent 0
4032074 2036140 2036140 plaintiff Fylmer Robert gent 601559 601559 Fylmer, Robert, of Lincolns Inn, gent 0
4050859 2042747 2042747 plaintiff Wentworth John gent 601559 601559 Wentworth, John, of Lincolns Inn, gent 0
4057294 2044993 2044993 plaintiff Burdsall William gent 601559 601559 Burdsall, William, of Lincolns Inn, gent 0
4074547 2051200 2051200 plaintiff Raygnold John gent 601559 601559 Raygnold, John, of Lincolns Inn, gent 0
4076866 2052013 2052013 defendant Haydon Henry gent 601559 601559 Haydon, Henry, of Lincolns Inn, gent 0
4081128 2053562 2053562 plaintiff Harpar Henry gent 601559 601559 Harpar, Henry, of Lincolns Inn, gent 2
4081132 2053563 2053563 plaintiff Harpur Henry gent 601559 601559 Harpur, Henry, of Lincolns Inn, gent 2
4081139 2053565 2053565 plaintiff Harpur Henry gent 601559 601559 Harpur, Henry, of Lincolns Inn, gent 2
4081276 2053611 2053611 defendant Morgan Thomas gent 601559 601559 Morgan, Thomas, of Lincolns Inn, gent 0
4086611 2055499 2055499 defendant Denys Thomas gent 601559 601559 Denys, Thomas, of Lincolns Inn, gent 2
4110088 2063873 2063873 defendant Walmesley Thomas esq 601559 601559 Walmesley, Thomas, of Lincolns Inn, esq 0
4140915 2074987 2074987 defendant Thorley William gent 601559 601559 Thorley, William, of Lincolns Inn, or of Salisbury, gent 0
4153446 2079303 2079303 defendant Shelbury John gent 601559 601559 Shelbury, John, of Lincolns Inn, gent 1
4155758 2080098 2080098 defendant Meringe Francis (legal representative) 601559 601559 Meringe, Francis, of Lincolns Inn, esq, executors of 0
4156470 2080339 2080339 defendant Wylbraham Ralph gent 601559 601559 Wylbraham, Ralph, of Lincolns Inn, gent 0
4183570 2089737 2089737 defendant Jenney Christopher gent 601559 601559 Jenney, Christopher, of Lincolns Inn, gent 0
4201735 2096153 2096153 defendant Calthorpe William esq 601559 601559 Calthorpe, William, of Lincolns Inn, or of Weybred, Suff, esq 0
4240543 2109820 2109820 plaintiff Albany Francis esq 601559 601559 Albany, Francis, of Lincolns Inn, esq 0
4248786 2112582 2112582 defendant Jenneye Christopher gent 601559 601559 Jenneye, Christopher, of Lincolns Inn, gent 0
4254016 2114341 2114341 defendant Townesend George Middx, gent 601559 601559 Townesend George, of Lincolns Inn, Middx, gent 2
4264434 2117746 2117746 defendant Hichcock Thomas   601559 601559 Hichcock, Thomas, of Lincolns Inn, Middx gent 1
4300614 2130317 2130317 defendant Toothby Richard gent 601559 601559 Toothby, Richard, of Lincolns Inn, or of Furnivals Inn, Middx, gent 1
4360484 2150917 2150917 defendant Wood Robert   601559 601559 Wood, Robert, of Lincolns Inn, Middx gent 1
4367056 2153273 2153273 defendant Bassett Philip esq 601559 601559 Bassett, Philip, of Lincolns Inn, esq 2
4376889 2156807 2156807 defendant Hungerford Thomas (legal representative) 601559 601559 Hungerford, Thomas, of Lincolns inn, esq, executrix of 1
4394086 2162624 2162624 defendant Washington Bartholomew gent 601559 601559 Washington, Bartholomew, of Lincolns Inn, gent 0
4396998 2163565 2163565 defendant Washington Bartholomew gent 601559 601559 Washington, Bartholomew, of Lincolns Inn, gent 0
5121002 2392575 2392575 plaintiff Sulyard John pensioner 601559 601559 Sulyard, John, of Lincolns Inn, pensioner 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);