names

24 rows where place_id = 600320

✎ 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
3640588 1907498 1907498 plaintiff Ashe Richard esq 600320 600320 Ashe, Richard, of Tykenham, esq 0
3840885 1970718 1970718 defendant Hygons Thomas husbandman 600320 600320 Hygons, Thomas, of Tykenham, husbandman 0
4469276 2191059 2191059 defendant Stanford Richard   600320 600320 Stanford, Richard, of Tykenham 0
4668895 2255973 2255973 defendant Danyes Hugh ploughman 600320 600320 Danyes, Hugh, of Tykenham, ploughman 0
4765253 2285115 2285115 defendant Whitebred John   600320 600320 Whitebred, John, of Tykenham, bailiff 0
4930305 2335877 2335877 defendant Bibbys John husbandman 600320 600320 Bibbys, John, of Tykenham, husbandman 0
4943813 2340028 2340028 defendant Innewode Robert husbandman 600320 600320 Innewode, Robert, of Tykenham, husbandman 10
4943826 2340028 2340028 defendant Gybbys John husbandman 600320 600320 Gybbys, John, of Tykenham, husbandman 23
4990029 2353929 2353929 defendant Warewyk John clerk 600320 600320 Warewyk, John, of Tykenham, clerk 0
4990030 2353929 2353929 defendant Hawkyn Thomas husbandman 600320 600320 Hawkyn, Thomas, of Tykenham, husbandman 1
4990031 2353929 2353929 defendant Northewey Richard husbandman 600320 600320 Northewey, Richard, of Tykenham, husbandman 2
5014235 2361016 2361016 defendant Gybbys Thomas husbandman 600320 600320 Gybbys, Thomas, of Tykenham, husbandman 0
5014236 2361016 2361016 defendant Russell John husbandman 600320 600320 Russell, John, of Tykenham, husbandman 1
5017834 2362096 2362096 defendant Zely or Yely John butcher 600320 600320 Zely or Yely, John, of Tykenham, butcher 0
5022447 2363465 2363465 defendant Bays Thomas gent 600320 600320 Bays, Thomas, of Tykenham, gent 0
5025940 2364481 2364481 defendant Nethewey John husbandman 600320 600320 Nethewey, John, of Tykenham, husbandman 0
5285024 2440642 2440642 defendant Hoggys Thomas yeoman 600320 600320 Hoggys, Thomas, of Tykenham, yeoman 0
5447600 2489154 2489154 defendant Gybbys Thomas yeoman 600320 600320 Gybbys, Thomas, of Tykenham, yeoman 0
5460019 2492928 2492928 defendant Gibbs Thomas yeoman 600320 600320 Gibbs, Thomas, of Tykenham, yeoman 0
5471663 2496473 2496473 defendant Gybbys Thomas yeoman 600320 600320 Gybbys, Thomas, of Tykenham, yeoman 0
5483056 2499874 2499874 defendant Gybbys Thomas yeoman 600320 600320 Gybbys, Thomas, of Tykenham, yeoman 0
5511396 2508410 2508410 defendant Lynge John yeoman 600320 600320 Lynge, John, of Tykenham, yeoman 3
5534719 2515401 2515401 defendant Holl Thomas husbandman 600320 600320 Holl, Thomas, of Tykenham, husbandman 0
5613444 2547996 2547996 defendant Basset Andrew   600320 600320 Basset, Andrew, of Tykenham 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);