names

36 rows where place_id = 596877

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626485 1903139 1903139 defendant Gryffyth John laborer 596877 596877 Gryffyth, John, of Typton, laborer 2
3626486 1903139 1903139 defendant Carre George laborer 596877 596877 Carre, George, of Typton, laborer 3
3626487 1903139 1903139 defendant Melbourne Thomas laborer 596877 596877 Melbourne, Thomas, of Typton, laborer 4
3651528 1910834 1910834 defendant Toll Reginald husbandman 596877 596877 Toll, Reginald, of Typton, husbandman 1
3651529 1910834 1910834 defendant Malpas William husbandman or smith 596877 596877 Malpas, William, of Typton, husbandman or smith 2
3671608 1917104 1917104 defendant Parkys John smith 596877 596877 Parkys, John, of Typton, smith 0
3837784 1969732 1969732 defendant Sherard James smith 596877 596877 Sherard, James, of Typton, smith 2
3849183 1973341 1973341 defendant Lydde Edward husbandman 596877 596877 Lydde, Edward, of Typton, husbandman 0
3849184 1973341 1973341 defendant Lydder Hamlet husbandman 596877 596877 Lydder, Hamlet, of Typton, husbandman 1
3930539 2000557 2000557 defendant Hampton Nicholas yeoman 596877 596877 Hampton, Nicholas, of Typton, yeoman 0
3937269 2002799 2002799 defendant Sheldon Thomas yeoman 596877 596877 Sheldon, Thomas, of Typton, yeoman 0
3975067 2015843 2015843 defendant Sparry Richard laborer 596877 596877 Sparry, Richard, of Typton, laborer 0
4043036 2039981 2039981 defendant Aron or Arne John yeoman 596877 596877 Aron or Arne, John, of Typton, yeoman 1
4043044 2039982 2039982 defendant Aron or Arne John yeoman 596877 596877 Aron or Arne, John, of Typton, yeoman 1
4069795 2049485 2049485 defendant Webbe Thomas yeoman 596877 596877 Webbe, Thomas, of Typton, yeoman 2
4074617 2051224 2051224 defendant Wynshurste John nailer 596877 596877 Wynshurste, John, of Typton, nailer 2
4143941 2076046 2076046 defendant Waiger Thomas weaver 596877 596877 Waiger, Thomas, of Typton, weaver 1
4173083 2086042 2086042 defendant Sheldon Thomas carrier 596877 596877 Sheldon, Thomas, of Typton, carrier 0
4173084 2086042 2086042 defendant Tole Richard yeoman 596877 596877 Tole, Richard, of Typton, yeoman 1
4214951 2100730 2100730 defendant Darbye William nailer 596877 596877 Darbye, William, of Typton, nailer 0
4222298 2103290 2103290 defendant Whitehouse Thomas nailer 596877 596877 Whitehouse, Thomas, of Typton, nailer 0
4222299 2103290 2103290 defendant Darbye William nailer 596877 596877 Darbye, William, of Typton, nailer 1
4222300 2103290 2103290 defendant Warde Robert nailer 596877 596877 Warde, Robert, of Typton, nailer 2
4271170 2119932 2119932 defendant Darbye William nailer 596877 596877 Darbye, William, of Typton, nailer 0
4343915 2145154 2145154 defendant Cockeyne Elizabeth widow 596877 596877 Cockeyne, Elizabeth, of Typton, widow 0
4344658 2145410 2145410 defendant Derbye Edmund nailer 596877 596877 Derbye, Edmund, of Typton, nailer 0
4353191 2148344 2148344 defendant Dudley Edward yeoman 596877 596877 Dudley, Edward, of Typton, yeoman 0
4353192 2148344 2148344 defendant More John smith 596877 596877 More, John, of Typton, smith 1
4353193 2148344 2148344 defendant Dudley Thomas, senior yeoman 596877 596877 Dudley, Thomas, senior, of Typton, yeoman 2
4401020 2164932 2164932 defendant Nightingalle Hugh yeoman 596877 596877 Nightingalle, Hugh, of Typton, yeoman 2
4804528 2297606 2297606 plaintiff Bolle Henry   596877 596877 Bolle, Henry, of Typton 0
4828440 2304940 2304940 defendant Turnepeny William husbandman 596877 596877 Turnepeny, William, of Typton, husbandman 0
4852003 2312059 2312059 defendant Stylyng John husbandman 596877 596877 Stylyng, John, of Typton, husbandman 0
4856318 2313350 2313350 defendant Storche or Scorche John husbandman 596877 596877 Storche or Scorche, John, of Typton, husbandman 1
4880007 2320660 2320660 defendant Stylyng John husbandman 596877 596877 Stylyng, John, of Typton, husbandman 0
5342874 2457968 2457968 defendant Waynwryght George chaplain 596877 596877 Waynwryght, George, of Typton, chaplain 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);