names

28 rows where place_id = 611420

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3647015 1909466 1909466 defendant Heawars alias Newcombe William   611420 611420 Heawars alias Newcombe, William, of Wytherygge, groom 2
3688351 1922513 1922513 defendant Downe Thomas husbandman 611420 611420 Downe, Thomas, of Wytherygge, husbandman 0
3688530 1922572 1922572 defendant Mortemer William   611420 611420 Mortemer, William, of Wytherygge, groom 0
3720460 1932681 1932681 defendant Rokys Thomas gent 611420 611420 Rokys, Thomas, of Wytherygge, gent 0
3733914 1936851 1936851 defendant Benet John (legal representative) 611420 611420 Benet, John, of Wytherygge, executrix of 5
3901513 1990731 1990731 defendant Stevyng Richard husbandman 611420 611420 Stevyng, Richard, of Wytherygge, husbandman 0
3901515 1990731 1990731 defendant Herneyman alias Pawle Ralph husbandman 611420 611420 Herneyman alias Pawle, Ralph, of Wytherygge, husbandman 2
3901516 1990731 1990731 defendant Ratclyff Thomas dyer 611420 611420 Ratclyff, Thomas, of Wytherygge, dyer 3
4713394 2269513 2269513 defendant Marteyn Richard husbandman 611420 611420 Marteyn, Richard, of Wytherygge, husbandman 0
4757122 2282600 2282600 defendant Drayton Geoffrdy   611420 611420 Drayton, Geoffrdy, of Wytherygge 2
4767720 2285885 2285885 defendant Newenham William   611420 611420 Newenham, William, of Wytherygge, book binder 2
4792115 2293634 2293634 defendant Newenham William bookbinder 611420 611420 Newenham, William, of Wytherygge, bookbinder 2
4985235 2352511 2352511 defendant Hoygge Thomas   611420 611420 Hoygge, Thomas, of Wytherygge, bailiff 3
5225195 2423041 2423041 defendant Fleccher John husbandman 611420 611420 Fleccher, John, of Wytherygge, husbandman 1
5241956 2427844 2427844 defendant Howe John yeoman 611420 611420 Howe, John, of Wytherygge, yeoman 2
5254548 2431544 2431544 defendant Tayllour alias Fleccher John tailor 611420 611420 Tayllour alias Fleccher, John, of Wytherygge, tailor 0
5289476 2441921 2441921 defendant Kemplonde John butcher 611420 611420 Kemplonde, John, of Wytherygge, butcher 0
5349285 2459904 2459904 defendant Kemplond John butcher 611420 611420 Kemplond, John, of Wytherygge, butcher 1
5357040 2462263 2462263 defendant Thomas Joan spinster 611420 611420 Thomas, Joan, of Wytherygge, spinster 0
5357041 2462263 2462263 defendant Hurle John husbandman 611420 611420 Hurle, John, of Wytherygge, husbandman 1
5357044 2462263 2462263 defendant Godeman Richard husbandman 611420 611420 Godeman, Richard, of Wytherygge, husbandman 4
5368850 2465846 2465846 defendant Coke Thomas husbandman 611420 611420 Coke, Thomas, of Wytherygge, husbandman 0
5407386 2477177 2477177 defendant Mersshey John Smith 611420 611420 Mersshey, John, of Wytherygge, Smith 0
5420618 2481091 2481091 defendant Mersshey John smith 611420 611420 Mersshey, John, of Wytherygge, smith 0
5439460 2486739 2486739 defendant Mersshay John smith 611420 611420 Mersshay, John, of Wytherygge, smith 0
5453266 2490859 2490859 defendant Mersshey John smith 611420 611420 Mersshey, John, of Wytherygge, smith 0
5492581 2502693 2502693 defendant Bukman or Cukman William husbandman 611420 611420 Bukman or Cukman, William, of Wytherygge, husbandman 1
5507591 2507270 2507270 defendant Toker Thomas baker 611420 611420 Toker, Thomas, of Wytherygge, baker 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);