names

21 rows where place_id = 617797

✎ 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
3721336 1932981 1932981 defendant Borowe Richard husbandman 617797 617797 Borowe, Richard, of Dyseworth, husbandman 0
4414523 2169446 2169446 defendant Beram Adam   617797 617797 Beram, Adam, of Dyseworth 0
4425763 2172868 2172868 defendant Colyer John le   617797 617797 Colyer, John le, of Dyseworth 0
4445515 2183552 2183552 defendant Gurumdeley John   617797 617797 Gurumdeley, John, of Dyseworth 0
4462276 2188897 2188897 defendant Colyns John   617797 617797 Colyns, John, of Dyseworth 0
4696786 2264473 2264473 defendant Gromley Ralph gent 617797 617797 Gromley, Ralph, of Dyseworth, gent 0
4696788 2264474 2264474 defendant Bromley Ralph gent 617797 617797 Bromley, Ralph, of Dyseworth, gent 0
4705597 2267121 2267121 defendant Milner John miller 617797 617797 Milner, John, of Dyseworth, miller 0
4707153 2267615 2267615 defendant Gromley Ralph gent 617797 617797 Gromley, Ralph, of Dyseworth, gent 0
4707821 2267815 2267815 defendant Roys William husbandman 617797 617797 Roys, William, of Dyseworth, husbandman 1
4707822 2267815 2267815 defendant Mariot William husbandman 617797 617797 Mariot, William, of Dyseworth, husbandman 2
4730771 2274825 2274825 defendant Grimley Reginald gent 617797 617797 Grimley, Reginald, of Dyseworth, gent 0
4748549 2280078 2280078 defendant Grimley Reginald gent 617797 617797 Grimley, Reginald, of Dyseworth, gent 0
4775708 2288399 2288399 plaintiff Wryght William   617797 617797 Wryght, William, of Dyseworth 0
4910045 2329664 2329664 defendant Blakwelle Ralph yeoman 617797 617797 Blakwelle, Ralph, of Dyseworth, yeoman 3
4981521 2351384 2351384 defendant Blakwell Richard yeoman 617797 617797 Blakwell, Richard, of Dyseworth, yeoman 0
5068582 2377093 2377093 defendant Garard John husbandman 617797 617797 Garard, John, of Dyseworth, husbandman 3
5120036 2392298 2392298 defendant Owneby Thomas husbandman 617797 617797 Owneby, Thomas, of Dyseworth, husbandman 0
5189909 2412791 2412791 defendant Ounby Thomas husbandman 617797 617797 Ounby, Thomas, of Dyseworth, husbandman 0
5189910 2412791 2412791 defendant Ratclyf John gent 617797 617797 Ratclyf, John, of Dyseworth, gent 1
5315346 2449646 2449646 defendant Amby Thomas yeoman 617797 617797 Amby, Thomas, of Dyseworth, yeoman 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);