names

34 rows where place_id = 618250

✎ 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
3723576 1933648 1933648 defendant Pellond Richard husbandman 618250 618250 Pellond, Richard, of Wodecherche, husbandman 0
3739405 1938533 1938533 defendant Pellond Richard husbandman 618250 618250 Pellond, Richard, of Wodecherche, husbandman 0
3743412 1939814 1939814 defendant Pelham Richard husbandman 618250 618250 Pelham, Richard, of Wodecherche, husbandman 0
3780140 1951511 1951511 defendant Mede Hugh yeoman 618250 618250 Mede, Hugh, of Wodecherche, yeoman 3
3797063 1956962 1956962 defendant Benett William husbandman 618250 618250 Benett, William, of Wodecherche, husbandman 0
3797064 1956962 1956962 defendant Morley John husbandman 618250 618250 Morley, John, of Wodecherche, husbandman 1
3807450 1960233 1960233 defendant Rogewey Robert yeoman 618250 618250 Rogewey, Robert, of Wodecherche, yeoman 0
4474931 2192825 2192825 defendant Elchyndenne Thomas   618250 618250 Elchyndenne, Thomas, of Wodecherche 0
4482709 2195296 2195296 defendant atte Bregge Thomas   618250 618250 atte Bregge, Thomas, of Wodecherche 0
4572422 2222914 2222914 plaintiff atte Bregge Thomas   618250 618250 atte Bregge, Thomas, of Wodecherche 0
4599458 2231047 2231047 defendant atte Forde John   618250 618250 atte Forde, John, of Wodecherche 3
4606722 2233217 2233217 defendant Eyngeham John, sen   618250 618250 Eyngeham, John, sen, of Wodecherche 0
4674643 2257676 2257676 plaintiff Edyngham Thomas   618250 618250 Edyngham, Thomas, of Wodecherche 0
4738534 2277143 2277143 defendant Tounlonde William gent 618250 618250 Tounlonde, William, of Wodecherche, gent 0
4738535 2277143 2277143 defendant Clerk Peter yeoman 618250 618250 Clerk, Peter, of Wodecherche, yeoman 1
4754342 2281738 2281738 defendant Dokene John husbadman 618250 618250 Dokene, John, of Wodecherche, husbadman 0
4766430 2285493 2285493 defendant Fryght John husbandman 618250 618250 Fryght, John, of Wodecherche, husbandman 0
4788575 2292485 2292485 defendant Maynard Thomas husbandman 618250 618250 Maynard, Thomas, of Wodecherche, husbandman 0
4798400 2295686 2295686 defendant Fryght John husbandman 618250 618250 Fryght, John, of Wodecherche, husbandman 0
4916013 2331510 2331510 plaintiff Harlakynden William   618250 618250 Harlakynden, William, of Wodecherche 1
4916016 2331511 2331511 plaintiff Harlakynden William   618250 618250 Harlakynden, William, of Wodecherche 1
4916022 2331513 2331513 plaintiff Harlakenden William   618250 618250 Harlakenden, William, of Wodecherche 1
4916025 2331514 2331514 plaintiff Harlakenden William   618250 618250 Harlakenden, William, of Wodecherche 1
4927642 2335080 2335080 defendant Edyngham Alan husbandman 618250 618250 (Edyngham, Alan, of Wodecherche, husbandman 1
4927644 2335080 2335080 defendant Harlakynden Willam husbandman 618250 618250 Harlakynden, Willam, of Wodecherche, husbandman 3
4950933 2342257 2342257 defendant Ixnyng John butcher 618250 618250 Ixnyng, John, of Wodecherche, butcher 0
4956399 2343878 2343878 plaintiff Typynden Henry (legal representative) 618250 618250 Typynden, Henry, of Wodecherche, or of Lyndested, executors of 0
5013716 2360854 2360854 defendant Colyn Peter husbandman 618250 618250 Colyn, Peter, of Wodecherche, husbandman 1
5020644 2362931 2362931 defendant Dunny John   618250 618250 Dunny, John, of Wodecherche, shipwright 0
5084622 2381915 2381915 defendant Bayle Simon tanner 618250 618250 Bayle, Simon, of Wodecherche, tanner 0
5260249 2433332 2433332 defendant Perys John chapman 618250 618250 Perys, John, of Wodecherche, chapman 4
5270642 2436512 2436512 defendant Harlokynden William gent 618250 618250 Harlokynden, William, of Wodecherche, gent 0
5273866 2437437 2437437 defendant Harlokynden William gent 618250 618250 Harlokynden, William, of Wodecherche, gent 0
5599776 2534819 2534819 defendant Pellond Thomas husbandman 618250 618250 Pellond, Thomas, of Wodecherche, husbandman 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);