names

25 rows where case_id = 2286316

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4769093 2286316 2286316 plaintiff Page (illegible)     Page, _ 0
4769094 2286316 2286316 defendant Perot Thomas yeoman 590277 590277 Perot, Thomas, of Hertfeld, yeoman 0
4769095 2286316 2286316 defendant Tyler R_ laborer 587765 587765 Tyler, R_, of Horsmonden, laborer 1
4769096 2286316 2286316 defendant Ryght William tailor 799712 799712 Ryght, William, of Edenbridge, Kent, tailor 2
4769097 2286316 2286316 defendant Smyth John laborer 606378 606378 Smyth, John, of Edenbridge, laborer 3
4769098 2286316 2286316 defendant Coupere John husbandman 606378 606378 Coupere, John, of Edenbridge, husbandman 4
4769099 2286316 2286316 defendant Stolde John laborer 764367 764367 Stolde, John, of Tudele, laborer 5
4769100 2286316 2286316 defendant Godesday Nicholas laborer 764367 764367 Godesday, Nicholas, of Tudele, laborer 6
4769101 2286316 2286316 defendant Wrynge Thomas laborer 595165 595165 Wrynge, Thomas, of Brenchesle, laborer 7
4769102 2286316 2286316 defendant Pycot Thomas, sen draper 656651 656651 Pycot, Thomas, sen, of Tunbridge, draper 8
4769103 2286316 2286316 defendant Chaundeler Thomas of Tunbridge yeoman   Chaundeler, Thomas of Tunbridge, yeoman 9
4769104 2286316 2286316 defendant Rode John   656651 656651 Rode, John, of Tunbridge, arrow maker 10
4769105 2286316 2286316 defendant Kyng Roger husbandman 600982 600982 Kyng, Roger, of Penshurst, husbandman 11
4769106 2286316 2286316 defendant Pendere John butcher 786212 786212 Pendere, John, of Rotherfield, butcher 12
4769107 2286316 2286316 defendant Saltere Nicholas of Rotherfield butcher   Saltere, Nicholas of Rotherfield, butcher 13
4769108 2286316 2286316 defendant Skynnere John   757117 757117 Skynnere, John, of Hertefeld, servant of John Skynnere 14
4769109 2286316 2286316 defendant Bocher John butcher 786212 786212 Bocher, John, of Rotherfield, butcher 15
4769110 2286316 2286316 defendant Saxpays John jun, of Wythiham, laborer   Saxpays, John, jun, of Wythiham, laborer 16
4769111 2286316 2286316 defendant Coupere Richard laborer 799715 799715 Coupere, Richard, of Wythhamme, laborer 17
4769112 2286316 2286316 defendant Boghiere John jun, of Hertefeld, laborer   Boghiere, John, jun, of Hertefeld, laborer 18
4769113 2286316 2286316 defendant Fynsherst Walter tailor 757117 757117 Fynsherst, Walter, of Hertefeld, tailor 19
4769114 2286316 2286316 defendant Steeke Thomas   646450 646450 Steeke, Thomas, of Wadhurst, nail maker or glove maker 20
4769115 2286316 2286316 defendant Aps Richard   865087 865087 Aps, Richard, of Fernthe, wheel wright 21
4769116 2286316 2286316 defendant Say Thomas parkman 757117 757117 Say, Thomas, of Hertefeld, parkman 22
4769117 2286316 2286316 defendant Smale William forester 786212 786212 Smale, William, of Rotherfield, forester 23

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