names

25 rows where place_id = 637995

✎ 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
3839822 1970384 1970384 defendant Lyvett John clerk 637995 637995 Lyvett, John, of Ryther, clerk 0
4033459 2036626 2036626 defendant Bullocke Robert yeoman 637995 637995 Bullocke, Robert, of Ryther, yeoman 0
4191780 2092680 2092680 defendant Matherer Ralph yeoman 637995 637995 Matherer, Ralph, of Ryther, yeoman 5
4360055 2150758 2150758 defendant Aske John esq 637995 637995 Aske, John, of Ryther, or of Aughton, Yorks, esq 0
4563797 2220245 2220245 defendant Wayte Ralph   637995 637995 Wayte, Ralph, of Ryther 0
4730386 2274703 2274703 defendant Turpyn William husbandman 637995 637995 Turpyn, William, of Ryther, husbandman 0
4730387 2274703 2274703 defendant Gayle William husbandman 637995 637995 Gayle, William, of Ryther, husbandman 1
4765967 2285346 2285346 defendant Turpyn William husbandman 637995 637995 Turpyn, William, of Ryther, husbandman 5
4881471 2321107 2321107 defendant Ryther William   637995 637995 Ryther, William, of Ryther, knight 0
4881476 2321108 2321108 defendant Ryther William   637995 637995 Ryther, William, of Ryther, knight 0
4881477 2321108 2321108 defendant Gayll William yeoman 637995 637995 Gayll, William, of Ryther, yeoman 1
4976817 2350018 2350018 defendant Ryther William esq 637995 637995 Ryther, William, of Ryther, esq 0
4976818 2350018 2350018 defendant Holme John yeoman 637995 637995 together with Holme, John, of Ryther, yeoman 1
4997660 2356156 2356156 plaintiff Holme John yeoman 637995 637995 Holme, John, of Ryther, yeoman 0
5036328 2367476 2367476 defendant Gale William husbandman 637995 637995 Gale, William, of Ryther, husbandman 0
5045280 2370215 2370215 defendant Milner John yeoman 637995 637995 Milner, John, of Ryther, yeoman 4
5119504 2392135 2392135 defendant Ryther William   637995 637995 Ryther, William, of Ryther, knight 2
5183260 2410847 2410847 defendant Heton Richard yeoman 637995 637995 Heton, Richard, of Ryther, yeoman 2
5203800 2416863 2416863 defendant Lovette William yeoman 637995 637995 Lovette, William, of Ryther, yeoman 1
5203801 2416863 2416863 defendant Heton Richard yeoman 637995 637995 Heton, Richard, of Ryther, yeoman 2
5295009 2443530 2443530 defendant Ryther William   637995 637995 Ryther, William, of Ryther, knight 0
5327180 2453201 2453201 defendant Ryther William   637995 637995 Ryther, William, of Ryther, knight 0
5390828 2472441 2472441 defendant Ryther John gent 637995 637995 Ryther, John, of Ryther, gent 4
5392267 2472878 2472878 defendant Ryther Robert   637995 637995 Ryther, Robert, of Ryther 0
5395008 2473637 2473637 defendant Ryther Thomas esq 637995 637995 Ryther, Thomas, of Ryther, esq 3

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