names

23 rows where place_id = 600732

✎ 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
3642307 1908042 1908042 defendant Bultyng John husbandman 600732 600732 Bultyng, John, of Edyngton, husbandman 0
3657072 1912475 1912475 plaintiff Coope Robert clothier 600732 600732 Coope, Robert, of Edyngton, clothier 0
3687995 1922405 1922405 defendant Godfrey John husbandman 600732 600732 Godfrey, John, of Edyngton, husbandman 0
3788838 1954313 1954313 defendant Snowe John weaver 600732 600732 Snowe, John, of Edyngton, weaver 0
3833152 1968298 1968298 defendant ap Ryce Meryk yeoman 600732 600732 ap Ryce, Meryk, of Edyngton, yeoman 0
3850893 1973873 1973873 defendant Mylburn Henry yeoman 600732 600732 Mylburn, Henry, of Edyngton, yeoman 0
3850895 1973873 1973873 defendant Mylburne Henry yeoman 600732 600732 Mylburne, Henry, of Edyngton, yeoman 2
3867331 1979305 1979305 defendant Barley John butcher 600732 600732 Barley, John, of Edyngton, butcher 0
3940770 2003919 2003919 defendant Pole William weaver 600732 600732 Pole, William, of Edyngton, weaver 0
3981227 2018047 2018047 defendant Dobyn Robert husbandman 600732 600732 Dobyn, Robert, of Edyngton, husbandman 0
3989185 2020870 2020870 defendant Pytte John husbandman 600732 600732 Pytte, John, of Edyngton, husbandman 0
4144855 2076360 2076360 defendant Baynton Henry esq 600732 600732 Baynton, Henry, of Edyngton, esq 0
4443406 2182899 2182899 defendant Haulde William   600732 600732 Haulde, William, of Edyngton 0
4558554 2218628 2218628 defendant Hornebloweton Stephen   600732 600732 Hornebloweton, Stephen, of Edyngton 0
4750434 2280608 2280608 plaintiff Rector Thomas   600732 600732 Rector, Thomas, of Edyngton 0
4970611 2348150 2348150 defendant Wode William yeoman 600732 600732 Wode, William, of Edyngton, yeoman 2
5022088 2363353 2363353 defendant Vifehere Katherine widow 600732 600732 Vifehere, Katherine, of Edyngton, widow 0
5132911 2396118 2396118 plaintiff Hogges William   600732 600732 Hogges, William, of Edyngton 0
5170366 2407062 2407062 plaintiff Hogges William   600732 600732 Hogges, William, of Edyngton 0
5459441 2492737 2492737 defendant Criche Richard husbandman 600732 600732 Criche, Richard, of Edyngton, husbandman 2
5471164 2496311 2496311 defendant Cryche Richard husbandman 600732 600732 Cryche, Richard, of Edyngton, husbandman 1
5471168 2496312 2496312 defendant Cryche Richard husbandman 600732 600732 Cryche, Richard, of Edyngton, husbandman 2
5584236 2530137 2530137 defendant Batte Richard   600732 600732 Batte, Richard, of Edyngton 2

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