names

23 rows where place_id = 694165

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4103284 2061455 2061455 defendant Phippes Robert, senior innholder 694165 694165 Phippes, Robert, senior, of Windsor, Berks, innholder 1
4143456 2075871 2075871 defendant Cotterell William mercer 694165 694165 Cotterell, William, of Windsor, Berks, mercer 0
4391127 2161651 2161651 defendant Urmeston Nicholas gent 694165 694165 Urmeston, Nicholas, of Windsor, Berks, gent 2
4676711 2258336 2258336 defendant Kyngeston Richard   694165 694165 Kyngeston, Richard, of Windsor, Berks, dean of the free chapel of St George, within the castle 0
4692730 2263237 2263237 defendant Somerton Thomas chapman 694165 694165 (Somerton, Thomas, of Windsor, Berks, chapman 1
4710292 2268574 2268574 defendant Spicer Henry clerk 694165 694165 Spicer, Henry, of Windsor, Berks, clerk 0
4715460 2270172 2270172 defendant Clerk Robert butcher 694165 694165 Clerk, Robert, of Windsor, Berks, butcher 0
4717325 2270751 2270751 defendant Gowe Robert   694165 694165 Gowe, Robert, of Windsor, Berks, canon in the King's free chapel 0
4719802 2271538 2271538 defendant Cresakere Isabel   694165 694165 (Cresakere, Isabel, of Windsor, Berks, widow, formerly wife of Thomas 1
4722947 2272491 2272491 defendant Thomas John clerk 694165 694165 Thomas, John, of Windsor, Berks, clerk 0
4736902 2276669 2276669 defendant Hunte Henry husbandman 694165 694165 Hunte, Henry, of Windsor, Berks, husbandman 1
4755877 2282222 2282222 defendant Hunte Henry yeoman 694165 694165 Hunte, Henry, of Windsor, Berks, yeoman 1
4755881 2282223 2282223 defendant Hunte Henry yeoman 694165 694165 Hunte, Henry, of Windsor, Berks, yeoman 1
4759548 2283326 2283326 defendant Hunt Henry yeoman 694165 694165 Hunt, Henry, of Windsor, Berks, yeoman 4
4770671 2286808 2286808 defendant Kent John yeoman 694165 694165 Kent, John, of Windsor, Berks, yeoman 0
4822976 2303269 2303269 defendant Gowe Robert clerk 694165 694165 Gowe, Robert, of Windsor, Berks, clerk 1
4835462 2307086 2307086 defendant Loundres alias Cornyssh Richard fishmonger 694165 694165 Loundres alias Cornyssh, Richard, of Windsor, Berks, fishmonger 0
4835465 2307087 2307087 defendant Loundres alias Cornyssh Richard fishmonger 694165 694165 Loundres alias Cornyssh, Richard, of Windsor, Berks, fishmonger 0
4845018 2309957 2309957 defendant Orcherd Richard husbandman 694165 694165 Orcherd, Richard, of Windsor, Berks, husbandman 1
4986454 2352876 2352876 plaintiff Ayassheley Thomas   694165 694165 Ayassheley, Thomas, of Windsor, Berks, clerk in the chapel of St George, within the castle 0
4992112 2354532 2354532 defendant Hanslap Henry   694165 694165 Hanslap, Henry, of Windsor, Berks, canon & clerk of the King's free chapel of St George, within the King's castle 0
5002924 2357761 2357761 defendant Hende John esq 694165 694165 Hende, John, of Windsor, Berks, esq 0
5273909 2437450 2437450 defendant Greneway Richard chapman 694165 694165 Greneway, Richard, of Windsor, Berks, chapman 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);