names

32 rows where place_id = 604174

✎ 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
3657068 1912473 1912473 defendant Brewster Thomas husbandman 604174 604174 Brewster, Thomas, of Stoke by Clare, husbandman 1
4394579 2162776 2162776 defendant Richardson Edward butcher 604174 604174 Richardson, Edward, of Stoke by Clare,butcher 1
4504397 2201927 2201927 defendant Martyn John   604174 604174 Martyn, John, of Stoke by Clare 0
4538733 2212387 2212387 defendant Salmunt Thomas   604174 604174 Salmunt, Thomas, of Stoke by Clare 0
4553136 2216917 2216917 defendant Halle John   604174 604174 Halle, John, of Stoke by Clare 0
4553137 2216917 2216917 defendant Bulwy John   604174 604174 Bulwy, John, of Stoke by Clare 1
4554907 2217464 2217464 defendant Parker John smith 604174 604174 Parker, John, of Stoke by Clare, smith 0
4627669 2239586 2239586 plaintiff Rote William   604174 604174 Rote, William, of Stoke by Clare 0
4670811 2256550 2256550 defendant Gille Nicholas clerk 604174 604174 Gille, Nicholas, of Stoke by Clare, clerk 0
4718623 2271163 2271163 plaintiff Barnesley Thomas clerk & deacon of the college of St John Baptist 604174 604174 Barnesley, Thomas, of Stoke by Clare, clerk & deacon of the college of St John Baptist 0
4747398 2279742 2279742 defendant Fysshe Henry yeoman 604174 604174 Fysshe, Henry, of Stoke by Clare, yeoman 0
4751518 2280928 2280928 defendant Carpenter Thomas carpenter 604174 604174 Carpenter, Thomas, of Stoke by Clare, carpenter 0
4759557 2283329 2283329 defendant Fyssh Henry husbandman 604174 604174 Fyssh, Henry, of Stoke by Clare, husbandman 0
4848960 2311141 2311141 defendant Andrewe William yeoman 604174 604174 Andrewe, William, of Stoke by Clare, yeoman 0
4848961 2311141 2311141 defendant Andrewe Nicholas yeoman 604174 604174 Andrewe, Nicholas, of Stoke by Clare, yeoman 1
4918268 2332236 2332236 plaintiff Grymston John   604174 604174 Grymston, John, of Stoke by Clare 0
4930517 2335944 2335944 plaintiff Evyas Richard chaplain 604174 604174 Evyas, Richard, of Stoke by Clare, chaplain 3
4930826 2336043 2336043 defendant Hertyshorn John gent 604174 604174 Hertyshorn, John, of Stoke by Clare, gent 0
4931876 2336356 2336356 plaintiff Evyas Richard chaplain 604174 604174 Evyas, Richard, of Stoke by Clare, chaplain 3
4986853 2353007 2353007 plaintiff Barneslay Thomas   604174 604174 Barneslay, Thomas, of Stoke by Clare, master & dean of the collegiate church, of St John the Baptist 0
4997508 2356106 2356106 defendant Belle Henry shoemaker 604174 604174 Belle, Henry, of Stoke by Clare, shoemaker 1
5006990 2358944 2358944 defendant Asterle Thomas yeoman 604174 604174 Asterle, Thomas, of Stoke by Clare, yeoman 0
5006991 2358944 2358944 defendant Wakeryng William husbandman 604174 604174 Wakeryng, William, of Stoke by Clare, husbandman 1
5006996 2358946 2358946 defendant Auncell John miller 604174 604174 together with Auncell, John, of Stoke by Clare, miller 1
5202313 2416439 2416439 plaintiff Wulfleet William   604174 604174 Wulfleet, William, of Stoke by Clare 1
5441908 2487509 2487509 defendant Coote John gent 604174 604174 Coote, John, of Stoke by Clare, gent 0
5441909 2487509 2487509 defendant Neweton Thomas gent 604174 604174 Neweton, Thomas, of Stoke by Clare, gent 1
5454698 2491327 2491327 defendant Coote John gent 604174 604174 Coote, John, of Stoke by Clare, gent 0
5454699 2491327 2491327 defendant Neweton Thomas gent 604174 604174 Neweton, Thomas, of Stoke by Clare, gent 1
5466549 2494935 2494935 defendant Coote John gent 604174 604174 Coote, John, of Stoke by Clare, gent 0
5466550 2494935 2494935 defendant Neweton Thomas gent 604174 604174 Neweton, Thomas, of Stoke by Clare, gent 1
5466913 2495055 2495055 plaintiff Beeke Reginald   604174 604174 Beeke, Reginald, of Stoke by Clare 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);