names

32 rows where place_id = 592501

✎ 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
3607897 1870120 1870120 defendant Dyer William husbandman 592501 592501 Dyer, William, of Stokebrigge, husbandman 1
4423654 2172243 2172243 plaintiff Hampton Robert   592501 592501 Hampton, Robert, of Stokebrigge 0
4565246 2220703 2220703 defendant Walyngforde John   592501 592501 Walyngforde, John, of Stokebrigge 0
4635231 2241859 2241859 defendant Cole Thomas   592501 592501 Cole, Thomas, of Stokebrigge, wool monger 0
4639707 2243126 2243126 defendant Baker Richard   592501 592501 Baker, Richard, of Stokebrigge 4
4639715 2243127 2243127 defendant Baker Richard   592501 592501 Baker, Richard, of Stokebrigge 4
4726089 2273447 2273447 defendant Cole Alice widow 592501 592501 Cole, Alice, of Stokebrigge, widow 0
4762138 2284137 2284137 defendant Tannere Thomas husbandman 592501 592501 Tannere, Thomas, of Stokebrigge, husbandman 0
4785633 2291534 2291534 defendant Tannere Thomas husbandman 592501 592501 Tannere, Thomas, of Stokebrigge, husbandman 0
4822108 2302993 2302993 defendant Lonyer or Louyer John ostler 592501 592501 Lonyer or Louyer, John, of Stokebrigge, ostler 0
4860840 2314751 2314751 defendant Mewe Thomas chapman 592501 592501 (Mewe, Thomas, of Stokebrigge, chapman 1
4879951 2320644 2320644 defendant Wodeford John ostler 592501 592501 Wodeford, John, of Stokebrigge, or of Southampton, ostler 0
4893024 2324539 2324539 defendant Huchon Richard   592501 592501 Huchon, Richard, of Stokebrigge tanner 0
4900161 2326676 2326676 defendant Wodeford John husbandman 592501 592501 Wodeford, John, of Stokebrigge, husbandman 0
4932189 2336465 2336465 defendant Judde Richard glover 592501 592501 Judde, Richard, of Stokebrigge, glover 0
4969184 2347744 2347744 defendant Pope alias Whetlokke John husbandman 592501 592501 Pope alias Whetlokke, John, of Stokebrigge, husbandman 2
4974226 2349251 2349251 defendant Chafyn Thomas husbandman 592501 592501 Chafyn, Thomas, of Stokebrigge, husbandman 0
5003335 2357873 2357873 defendant Feykyn John butcher 592501 592501 Feykyn, John, of Stokebrigge, butcher 1
5106409 2388312 2388312 defendant Elys Augustine yeoman 592501 592501 Elys, Augustine, of Stokebrigge, yeoman 11
5106410 2388312 2388312 defendant Horn William chaplain 592501 592501 Horn, William, of Stokebrigge, chaplain 12
5106462 2388323 2388323 defendant Phelip Robert husbandman 592501 592501 Phelip, Robert, of Stokebrigge, husbandman 2
5106465 2388323 2388323 defendant Horn William chaplain 592501 592501 Horn, William, of Stokebrigge, chaplain 5
5118274 2391777 2391777 defendant Elys Augustine yeoman 592501 592501 Elys, Augustine, of Stokebrigge, yeoman 25
5118275 2391777 2391777 defendant Horn William chaplain 592501 592501 Horn, William, of Stokebrigge, chaplain 26
5127972 2394658 2394658 defendant Gylmyn John husbandman 592501 592501 Gylmyn, John, of Stokebrigge, husbandman 0
5140568 2398351 2398351 defendant Morfeld Robert tailor 592501 592501 Morfeld, Robert, of Stokebrigge, tailor 0
5143947 2399374 2399374 defendant Phelip Robert husbandman 592501 592501 Phelip, Robert, of Stokebrigge, husbandman 0
5152077 2401745 2401745 defendant Cole John husbandman 592501 592501 Cole, John, of Stokebrigge, husbandman 1
5164131 2405248 2405248 defendant Trusse John laborer 592501 592501 Trusse, John, of Stokebrigge, laborer 0
5164132 2405248 2405248 defendant Smyth William husbandman 592501 592501 Smyth, William, of Stokebrigge, husbandman 1
5164971 2405493 2405493 defendant Phelip Robert husbandman 592501 592501 Phelip, Robert, of Stokebrigge, husbandman 0
5373846 2467416 2467416 defendant Cheke Richard yeoman 592501 592501 Cheke, Richard, of Stokebrigge, yeoman 4

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