names

40 rows where place_id = 588960

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596111 1866412 1866412 defendant Yate William husbandman 588960 588960 Yate, William, of Byggyng, husbandman 3
3596112 1866412 1866412 defendant Yate John husbandman 588960 588960 Yate, John, of Byggyng, husbandman 4
3649598 1910262 1910262 defendant Gwyn Reginald husbandman 588960 588960 Gwyn, Reginald, of Byggyng, husbandman 5
3649599 1910262 1910262 defendant Bland Leonard husbandman 588960 588960 Bland, Leonard, of Byggyng, husbandman 6
3649600 1910262 1910262 defendant Richardson alias Wyllyamson Leonard husbandman 588960 588960 Richardson alias Wyllyamson, Leonard, of Byggyng, husbandman 7
3649618 1910263 1910263 defendant Gwyn or Ewyn Reginald   588960 588960 Gwyn or Ewyn, Reginald, of Byggyng 7
3649636 1910264 1910264 defendant Gwyn Reginald husbandman 588960 588960 Gwyn, Reginald, of Byggyng, husbandman 7
3649637 1910264 1910264 defendant Bland Leonard husbandman 588960 588960 Bland, Leonard, of Byggyng, husbandman 8
3649638 1910264 1910264 defendant Richardson alias Wyllyamson Leonard husbandman 588960 588960 Richardson alias Wyllyamson, Leonard, of Byggyng, husbandman 9
3649654 1910265 1910265 defendant Gwyn Reginald husbandman 588960 588960 Gwyn, Reginald, of Byggyng, husbandman 7
3649655 1910265 1910265 defendant Bland Leonard husbandman 588960 588960 Bland, Leonard, of Byggyng, husbandman 8
3649656 1910265 1910265 defendant Richardson alias Wyllyamson Leonard husbandman 588960 588960 Richardson alias Wyllyamson, Leonard, of Byggyng, husbandman 9
3687837 1922360 1922360 defendant Metcalf Gilbert (legal representative) 588960 588960 Metcalf, Gilbert, of Byggyng, gent, executors of 0
3687839 1922360 1922360 defendant Metcalf Isabel widow 588960 588960 Metcalf, Isabel, of Byggyng, widow 2
3846190 1972363 1972363 defendant Day William yeoman 588960 588960 Day, William, of Byggyng, yeoman 1
3846253 1972384 1972384 defendant Browmelowe Henry husbandman 588960 588960 Browmelowe, Henry, of Byggyng, husbandman 0
3872725 1981093 1981093 defendant Day William yeoman 588960 588960 Day, William, of Byggyng, yeoman 0
3882430 1984388 1984388 defendant Day William yeoman 588960 588960 Day, William, of Byggyng, yeoman 1
3882436 1984390 1984390 defendant Day William yeoman 588960 588960 Day, William, of Byggyng, yeoman 1
3895849 1988819 1988819 defendant Ensour William husbandman 588960 588960 Ensour, William, of Byggyng, husbandman 0
4536401 2211668 2211668 defendant Couper John   588960 588960 Couper, John, of Byggyng 6
4602919 2232127 2232127 plaintiff Whitley Robert   588960 588960 Whitley, Robert, of Byggyng 0
4656028 2247767 2247767 plaintiff Burton John   588960 588960 Burton, John, of Byggyng 0
4996378 2355775 2355775 plaintiff Burton John   588960 588960 Burton, John, of Byggyng 2
5045282 2370215 2370215 defendant Wylde Robert   588960 588960 Wylde, Robert, of Byggyng 6
5054702 2372984 2372984 defendant Scargill Robert yeoman 588960 588960 Scargill, Robert, of Byggyng, yeoman 5
5272457 2437016 2437016 defendant Robynson Mathewe yeoman 588960 588960 Robynson, Mathewe, of Byggyng, yeoman 2
5272461 2437017 2437017 defendant Robynson Mathewe yeoman 588960 588960 Robynson, Mathewe, of Byggyng, yeoman 2
5272726 2437101 2437101 defendant Robynson Mathewe yeoman 588960 588960 Robynson, Mathewe, of Byggyng, yeoman 2
5272730 2437102 2437102 defendant Robynson Mathew yeoman 588960 588960 Robynson, Mathew, of Byggyng, yeoman 2
5272734 2437103 2437103 defendant Robynson Mathewe yeoman 588960 588960 Robynson, Mathewe, of Byggyng, yeoman 2
5305277 2446582 2446582 defendant Robynson Mathew yeoman 588960 588960 Robynson, Mathew, of Byggyng, yeoman 2
5358724 2462790 2462790 defendant Alsop Humphrey gent 588960 588960 Alsop, Humphrey, of Byggyng, gent 0
5358725 2462790 2462790 defendant Yate Richard husbandman 588960 588960 Yate, Richard, of Byggyng, husbandman 1
5366941 2465312 2465312 defendant Clerk Thomas husbandman 588960 588960 Clerk, Thomas, of Byggyng, husbandman 1
5366946 2465313 2465313 defendant Clerk Thomas husbandman 588960 588960 Clerk, Thomas, of Byggyng, husbandman 1
5366952 2465314 2465314 defendant Clerk Thomas husbandman 588960 588960 Clerk, Thomas, of Byggyng, husbandman 1
5556070 2521769 2521769 defendant Cartwryght John husbandman 588960 588960 Cartwryght, John, of Byggyng, husbandman 3
5611444 2547311 2547311 plaintiff Botdolever or Botclever Thomas   588960 588960 Botdolever or Botclever, Thomas, of Byggyng 0
5627028 2552421 2552421 defendant Burton John husbandman 588960 588960 Burton, John, of Byggyng, 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);