names

22 rows where place_id = 589623

✎ 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
3598210 1867071 1867071 defendant Everard Thomas husbandman 589623 589623 Everard, Thomas, of Gatele, husbandman 2
4474893 2192814 2192814 plaintiff Dyntre Edmund de, junior   589623 589623 Dyntre, Edmund de, junior, of Gatele 0
4554769 2217420 2217420 defendant Shepherd Reginald   589623 589623 Shepherd, Reginald, of Gatele 1
4689776 2262362 2262362 defendant Verden John   589623 589623 Verden, John, of Gatele, shepherd 2
4689777 2262362 2262362 defendant Bateman John, senior husbandman 589623 589623 Bateman, John, senior, of Gatele, husbandman 3
4759068 2283186 2283186 defendant Shetull John   589623 589623 Shetull, John, of Gatele 3
4759608 2283349 2283349 defendant Shetyll John yeoman 589623 589623 Shetyll, John, of Gatele, yeoman 0
4943167 2339834 2339834 defendant Fuller Richard husbandman 589623 589623 Fuller, Richard, of Gatele, husbandman 1
4975021 2349505 2349505 defendant Yonge Nicholas shoemaker 589623 589623 Yonge, Nicholas, of Gatele, shoemaker 0
5202950 2416625 2416625 defendant Denys Thomas gent 589623 589623 Denys, Thomas, of Gatele, gent 0
5231208 2424727 2424727 defendant Farewell Richard, senior husbandman 589623 589623 Farewell, Richard, senior, of Gatele, husbandman 1
5231209 2424727 2424727 defendant Farewell Richard, junior husbandman 589623 589623 Farewell, Richard, junior, of Gatele, husbandman 2
5257076 2432344 2432344 defendant Harpour Nicholas husbandman 589623 589623 Harpour, Nicholas, of Gatele, husbandman 0
5287262 2441295 2441295 defendant Deneys or Deveys Thomas (legal representative) 589623 589623 Deneys or Deveys, Thomas, of Gatele, gent, executors of 3
5352303 2460821 2460821 defendant Sloth Walter husbandman 589623 589623 Sloth, Walter, of Gatele, husbandman 0
5359398 2462976 2462976 defendant Wythy Henry husbandman 589623 589623 Wythy, Henry, of Gatele, husbandman 1
5474219 2497263 2497263 defendant Farewell Richard (legal representative) 589623 589623 Farewell, Richard, of Gatele, yeoman, executors of 1
5474220 2497263 2497263 defendant Goldyng John yeoman 589623 589623 (Goldyng, John, of Gatele, yeoman 2
5478828 2498688 2498688 defendant Wythy Henry husbandman 589623 589623 Wythy, Henry, of Gatele, husbandman 0
5482406 2499678 2499678 defendant Sloth Walter yeoman 589623 589623 Sloth, Walter, of Gatele, yeoman 3
5495435 2503534 2503534 defendant Sloth Walter yeoman 589623 589623 Sloth, Walter, of Gatele, yeoman 3
5504430 2506302 2506302 defendant Goldyng Robert husbandman 589623 589623 Goldyng, Robert, of Gatele, husbandman 2

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