names

38 rows where place_id = 616263

✎ 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
3713533 1930545 1930545 plaintiff Andrewe Thomas esq 616263 616263 Andrewe, Thomas, of Charwelton, esq 0
3744129 1940064 1940064 plaintiff Andrewes Thomas esq 616263 616263 Andrewes, Thomas, of Charwelton, esq 0
3756232 1943908 1943908 plaintiff Andrewes Thomas esq 616263 616263 Andrewes, Thomas, of Charwelton, esq 0
3756234 1943909 1943909 plaintiff Andrewes Thomas esq 616263 616263 Andrewes, Thomas, of Charwelton, esq 0
3756237 1943910 1943910 plaintiff Andrewes Thomas esq 616263 616263 Andrewes, Thomas, of Charwelton, esq 0
3791973 1955339 1955339 plaintiff Andrewes Thomas esq 616263 616263 Andrewes, Thomas, of Charwelton, esq 0
3791975 1955340 1955340 plaintiff Andrewes Thomas esq 616263 616263 Andrewes, Thomas, of Charwelton, esq 0
4545276 2214445 2214445 defendant Bolton William   616263 616263 Bolton, William, of Charwelton, parson 0
4564595 2220486 2220486 defendant Colus John   616263 616263 Colus, John, of Charwelton 2
4698641 2265053 2265053 defendant Bailly Hnery yeoman 616263 616263 Bailly, Hnery, of Charwelton, yeoman 0
4719313 2271386 2271386 plaintiff Berughby Thomas   616263 616263 Berughby, Thomas, of Charwelton 0
4912607 2330444 2330444 defendant Cogenho John husbandman 616263 616263 Cogenho, John, of Charwelton, husbandman 1
4912610 2330445 2330445 defendant Cogenho John husbandman 616263 616263 Cogenho, John, of Charwelton, husbandman 1
4962309 2345628 2345628 defendant Beruby Nicholas husbandman 616263 616263 Beruby, Nicholas, of Charwelton, husbandman 1
5025772 2364435 2364435 plaintiff Knotte Henry   616263 616263 Knotte, Henry, of Charwelton 0
5102732 2387212 2387212 defendant Berby John merchant 616263 616263 Berby, John,of Charwelton, merchant 0
5128214 2394727 2394727 defendant Fraunceys John husbandman 616263 616263 Fraunceys, John, of Charwelton, husbandman 2
5128218 2394728 2394728 defendant Fraunceys John husbandman 616263 616263 Fraunceys, John, of Charwelton, husbandman 2
5134890 2396708 2396708 defendant Reynold Richard husbandman 616263 616263 Reynold, Richard, of Charwelton, husbandman 0
5134892 2396709 2396709 defendant Reynold Richard husbandman 616263 616263 Reynold, Richard, of Charwelton, husbandman 0
5147285 2400349 2400349 defendant Bawdewyn John husbandman 616263 616263 Bawdewyn, John, of Charwelton, husbandman 1
5147286 2400349 2400349 defendant Fraunceys John husbandman 616263 616263 Fraunceys, John, of Charwelton, husbandman 2
5147289 2400350 2400350 defendant Bawdewyn John husbandman 616263 616263 Bawdewyn, John, of Charwelton, husbandman 1
5147290 2400350 2400350 defendant Fraunceys John husbandman 616263 616263 Fraunceys, John, of Charwelton, husbandman 2
5167043 2406093 2406093 defendant Bawdewyn John husbandman 616263 616263 Bawdewyn, John, of Charwelton, husbandman 1
5167044 2406093 2406093 defendant Fraunceys John husbandman 616263 616263 Fraunceys, John, of Charwelton, husbandman 2
5167047 2406094 2406094 defendant Bawdewyn John husbandman 616263 616263 Bawdewyn, John, of Charwelton, husbandman 1
5167048 2406094 2406094 defendant Fraunceys John husbandman 616263 616263 Fraunceys, John, of Charwelton, husbandman 2
5182283 2410571 2410571 defendant Bawdewyn John husbandman 616263 616263 Bawdewyn, John, of Charwelton, husbandman 1
5182284 2410571 2410571 defendant Fraunceys John husbandman 616263 616263 Fraunceys, John, of Charwelton, husbandman 2
5182287 2410572 2410572 defendant Bawdewyn John husbandman 616263 616263 Bawdewyn, John, of Charwelton, husbandman 1
5182288 2410572 2410572 defendant Fraunceys John husbandman 616263 616263 Fraunceys, John, of Charwelton, husbandman 2
5182292 2410573 2410573 defendant Fraunceys John husbandman 616263 616263 Fraunceys, John, of Charwelton, husbandman 2
5182301 2410576 2410576 defendant Bawdewyn John husbandman 616263 616263 Bawdewyn, John, of Charwelton, husbandman 1
5182302 2410576 2410576 defendant Fraunceys John husbandman 616263 616263 Fraunceys, John, of Charwelton, husbandman 2
5222158 2422187 2422187 defendant Farnedon Henry yeoman 616263 616263 Farnedon, Henry, of Charwelton, yeoman 0
5242162 2427905 2427905 defendant Farnedon Henry yeoman 616263 616263 Farnedon, Henry, of Charwelton, yeoman 0
5604108 2536146 2536146 defendant Andrewe Richard gent 616263 616263 (Andrewe, Richard, of Charwelton, gent 1

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