names

16 rows where place_id = 612338

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3692750 1923922 1923922 defendant Lewes John husbandman 612338 612338 Lewes, John, of Haston, husbandman 2
3963409 2011807 2011807 plaintiff Wynkyn Richard (legal representative) 612338 612338 Wynkyn, Richard, of Haston, or of Hounslowe, Middx, executors of 0
4575285 2223785 2223785 defendant Randolf William   612338 612338 Randolf, William, of Haston 1
4685149 2260957 2260957 defendant Clerk Robert yeoman 612338 612338 Clerk, Robert, of Haston, yeoman 1
4692954 2263306 2263306 defendant Hewe William clerk 612338 612338 Hewe, William, of Haston, clerk 0
4697388 2264668 2264668 defendant Lucas Margery widow 612338 612338 Lucas, Margery, of Haston, widow 2
4906408 2328592 2328592 plaintiff Emmys John   612338 612338 Emmys, John, of Haston 0
4947476 2341206 2341206 defendant Coppyng John yeoman 612338 612338 (Coppyng, John, of Haston, yeoman 1
5059214 2374320 2374320 defendant Don Roger husbandman 612338 612338 Don, Roger, of Haston, husbandman 1
5091149 2383811 2383811 defendant Bartelet John laborer 612338 612338 Bartelet, John, of Haston, laborer 0
5132797 2396088 2396088 plaintiff Hill John   612338 612338 Hill, John, of Haston 0
5132862 2396105 2396105 plaintiff Ho-- John   612338 612338 Ho--, John, of Haston 0
5223801 2422646 2422646 defendant Gurdon Robert husbandman 612338 612338 Gurdon, Robert, of Haston, husbandman 0
5268931 2436021 2436021 defendant Seman John husbandman 612338 612338 Seman, John, of Haston, husbandman 6
5268932 2436021 2436021 defendant Sawer Thomas husbandman 612338 612338 Sawer, Thomas, of Haston, husbandman 7
5280710 2439435 2439435 plaintiff Ferour Robert   612338 612338 Ferour, Robert, of Haston 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);